[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 783
  • Last Modified:

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

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
OAC Technology
Asked:
OAC Technology
  • 7
  • 6
1 Solution
 
Bill BachPresidentCommented:
Are you running the MAS90 release based on Pervasive PSQL, or the one based on SQL Server?
0
 
OAC TechnologyProfessional NerdsAuthor Commented:
I believe it is Pervasive but is there a way I can check to be 100% sure?
0
 
Bill BachPresidentCommented:
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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
OAC TechnologyProfessional NerdsAuthor Commented:
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
 
Bill BachPresidentCommented:
If you launch Sage, then go into Task Manager to view ALL processes, do you see W3DBSMGR.EXE?
0
 
OAC TechnologyProfessional NerdsAuthor Commented:
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
 
Bill BachPresidentCommented:
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
 
OAC TechnologyProfessional NerdsAuthor Commented:
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
 
Bill BachPresidentCommented:
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
 
OAC TechnologyProfessional NerdsAuthor Commented:
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
 
Bill BachPresidentCommented:
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
 
OAC TechnologyProfessional NerdsAuthor Commented:
Sage had me purge the AR_Audit module which allowed me to rebuild without a problem.

Thanks for your help
0
 
OAC TechnologyProfessional NerdsAuthor Commented:
Found solution
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now