Hi, the sa user was removed from the database last month because of security reasons. Everything is still working fine from what needs to be working. However, every Saturday morning, between 2AM and 3AM, something is causing timeouts and database lag to the point where the data can't log to the database, and they thus can't run production. All SQL log executes time out. Looked into the logs and they indicate the attached:
The logs start around 10 minutes before 2am and continue up to about 20 minutes before 3am, which aligns with when they are experiencing the data logging issues. I'm not sure if the issue is indeed with MES or if something else is running at this time that just happens to cause the below issues. Can you please assist?
Not using the MES anymore to its fullest (all OCO objects are undeployed). The data is logged to normal "flat file" tables, however there is still MES code that runs that logs data to the data_log_16 and 48 tables. But this is executed for every single part, could this be the issue?
MES 2014 R2 Version 5.2.0
Windows Server 2012 R2 Standard
My question is also if you know what in MES normally uses the SA user (is there any configurator?) and what could possibly be running every week at this time? Are there something like jobs or routines that can be setup in MES that I can look at? If so, where are they setup and configured?
We are not using the MES anymore to its fullest (all OCO objects are undeployed). The data is logged to normal "flat file" tables, however there is still MES code that runs that logs data to the data_log_16 and 48 tables. But this is executed for every single part.
