Solved

File not found problems with Sage 100 ERP 2013 / MAS 90

Posted on 2014-09-23
13
649 Views
Last Modified: 2014-10-04
We're having lots of problems with our MAS90. Clients are receiving random file not found errors.  We're trying to rebuild the key files for each module and they all seem to rebuild just fine with exception to the Accounts Receivable module. The Accounts Receivable rebuild gets stuck at AR_Audit and will sit overnight without moving on to the next section. We have run checkdisk several times, restarted the server, rebuilt sort files on all modules, ran sfc scan, and made sure MAS90 is up to date with all patches. Antivirus software is also disabled.

Also some additional information: The MAS90 server is running in a Hyper-V virtual machine running Windows 2012 Standard. There are also points and time where even when I try double-clicking the sage icon from the server it will take 5+ minutes to display the login prompt and another 5+ minutes after clicking login to show the MAS90 page. I don't see any other network problems when this happens (ping times are fine, no network disconnects, etc.)

 What should my next steps be?
0
Comment
Question by:DataDudes
  • 7
  • 6
13 Comments
 
LVL 28

Expert Comment

by:Bill Bach
ID: 40341494
Are you running the MAS90 release based on Pervasive PSQL, or the one based on SQL Server?
0
 
LVL 2

Author Comment

by:DataDudes
ID: 40341580
I believe it is Pervasive but is there a way I can check to be 100% sure?
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 40341614
Of course, but Sage never makes things easy, because they use a non-standard installer for PSQL and hide most of the real good tools.  

On the server, check for the presence of the Server database engine, called NTDBSMGR.EXE (for 32-bit engines) or NTDBSMGR64.EXE (for 64-bit engines), or for the Workgroup Engine, look for W3DBSMGR.EXE.  Alternatively, check the Services list (Right-Click Computer/Manage) for either the Pervasive PSQL Transactional Engine and Relational Engine services, or for the Pervasive PSQL Workgroup Engine service.  The Workgroup Service will only show up if it was installed as a service -- it may have been installed as an application, in which case it will only be loaded when Sage is running.
0
 
LVL 2

Author Comment

by:DataDudes
ID: 40341648
Actually I don't see any of these processes running and don't see any Pervasive services in the services panel. I also don't see any SQL services installed. This is what I see in my Programs and Features on the server if it's helpful:

Sage 100 ERP 2013
Sage 100 Standard ERP 2013 Workstation
Sage Advisor Update
Sage Exchange
Sage ODBC 64-bit Installer
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 40341655
If you launch Sage, then go into Task Manager to view ALL processes, do you see W3DBSMGR.EXE?
0
 
LVL 2

Author Comment

by:DataDudes
ID: 40341742
I still don't see anything like this in task manager when viewing all processes. Also, this took me a while to check as Sage took about 10 minutes to open on the server (another one of our random problems) and another 5 minutes to log in and users are complaining it is too slow to work with right now. Everything else on the server seems to move just fine. Processor utilization is at 10% and memory usage is at 30%. Network seems fine as well.
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 28

Expert Comment

by:Bill Bach
ID: 40341888
Interesting.  Well, you may not be using PSQL/Btrieve (which is my forte), but I can offer another suggestion -- get a copy of both Wireshark (www.wireshark.org) and Process Monitor (www.sysinternals.com) and put them on the machine in question.  Then, shut down EVERY other application on the machine that you can, activate one of the tracing tools, and launch the app to duplicate the problem.  Stop it as soon as the load finishes.  Then, do the same with the other one.

That is, of course, the easy part.  Beyond that, you'll need to try to interpret the results.  I'd start with Wireshark and see what is happening on the network side.  Specifically, look for huge delays in the timeline when the system appears to be doing "nothing".  It may be issuing network requests (such as DNS lookups) that take time to fail.  (Some such requests can take 30 seconds to fail, and if the app does it three times, there goes a minute and a half.)
0
 
LVL 2

Author Comment

by:DataDudes
ID: 40341955
Thanks for the idea, I'll try this later. Any idea on why the AR_Audit module refuses to rebuild and how to fix this module?
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 40341973
Without knowing your database type, no.  Can you see how big the data file is right now?  It is possible that the audit trail is huge, and it just takes a long time to rebuild.
0
 
LVL 2

Author Comment

by:DataDudes
ID: 40342094
I don't believe Sage is using anything other than the built in database. The only database connection I see on that server is an ODBC connection for MAS90 ProvideX ODBC driver. The AR folder also seems very small at 7.35MB. Although when I enter this folder I do not see any files named AR_Audit. Could the fact that I don't see this file be the problem with the rebuild?

Thanks for your help
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 40342126
Yeah -- it looks like they changed databases once again.  My experience is with the older, PSQL versions of MAS90.  Sorry, but I cannot advise on this second issue.
0
 
LVL 2

Accepted Solution

by:
DataDudes earned 0 total points
ID: 40349853
Sage had me purge the AR_Audit module which allowed me to rebuild without a problem.

Thanks for your help
0
 
LVL 2

Author Closing Comment

by:DataDudes
ID: 40360996
Found solution
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Read about achieving the basic levels of HRIS security in the workplace.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now