System Health and Performance

I may face the Automation schedule issue…When I went to the Automation Schedule Statuses, I found this error: 

Hi Everyone Do you know what happen for below as the automation schedule listing as the history show in completed but the statement itself is still no process   

Hi,A business event was set up based on the generic inquiry to be triggered each time a prepayment request has been approved by the Procurement manager. it was working fine until recently when it stopped, I checked the business event history, none was processed and no failed ones. Has anyone else run into a similar issue? 

Hi!Is there a way to take a snapshot that won’t copy the files in the table “UploadFileRevision”I’ve noticed that this is the table that’s taking up a significant amount of space in the database and when you copy or restore a snapshot, the other tenant also houses a lot of those records.would there be a reason to keep that data?  I understand the need to test, but you aren’t retesting the entire system and every single file.Here’s a screenshot what I’m referring to:  

Good day.What is the minimum bandwidth required by a customer subscribed to Acumatica SaaS?Many thanks,EM.

Hello everybody,Myself and a couple of colleagues have been facing an issue where the use of DateDiff in a GI causes the server to crash.This occurs when attempting to save, the save just goes on and on and on. Thanks, Aleks 

e are currently encountering an intermittent issue within Acumatica, specifically related to the loading of JPG files into screens. Some users have reported instances where files appear to be successfully attached without any error messages. However, upon closer inspection, we have observed a discrepancy between the reported number of files (#) and the actual files listed.Issue Description:Users experience sporadic instances where JPG files fail to load properly. After attaching files, the system indicates the correct number of files (#) in the top right corner. However, upon revisiting the screen, the displayed files (#) remains the same, while the list of files shows a mismatch, with some files missing.Example Scenario:User loads 2 files without encountering any errors. Files (#) in the top right corner correctly shows Files (2). User leaves the screen and returns.

The problem began when we made a new website and connected it to existed database. it worked well for some hoursbut after some time it slows down to the point that no one could work on it. so we restarted the database server and the iis then it worked.but from this point, it works for maybe 4 hours or so, then it begins to slowdown again, and we have to restart the iis to let it work againthe memory is not full nor the utilization of any resource.any insight on how to solve this problem? 

A historical full snapshot from a couple of years ago was taken without properly activating the system lockout and then restored to the site.  Is there a method by which the site can generate a safe snapshot?   Is this something that Acumatica Services needs to perform?  I have rebuilt indexes and optimized the db then scheduled a lockout in attempt to take a safe snapshot but still receive the following notice:  

Seeing as Snapshots are stored in the Acumatica database structure it would seem to me that the additional records not only take up storage space but also affect performance when running reports, generic inquiries, etc.   Has anyone found that to be the case or can anyone share some knowledge about why this might or might not impact performance for DB queries?  

Hello everyone, Out of the blue, we experienced a major slowdown in Acumatica today. For the record we are not on SaaS AWS hosting. Every screen takes about 15-30 seconds to load. We've checked: 1. System monitor - every query is taking 30+ seconds to run2. Automation schedule - some processes completed at 5am3. Business event history - nothing running right now4. Tried Chrome, Edge, and Firefox5. We rebooted both Acumatica and SQL 6. The SQL server CPU and memory are at 1% and 15% usage respectively 7. We are on 2021R1 with several customization packages.   Has anyone else that hosts directly had this issue? We are running on 2021R2 but we are expected to upgrade to 2023R1 in a few weeks.Thanks

I was deleting old snap shots to free up space.  I got this error: “The number of orphaned snapshots in the database is 8. Click Optimize Database to fix.”Where do a find “Optimize Database” so I can fix this issue? 

Hoping to find some quick help here.  Thanks in advance to anyone willing to lend some advice.  Can anyone give me some advice on how to find this API that is timing out every 10 minutes?We have an API running in the background that is timing out and slowing our system significantly.  I know the user that it is assigned to it by looking in System Monitor under “System Events” it doesn’t give me a screen ID or much information at all.  I’ve posted the information I can see below.  Can anyone offer any advice on how identify this “API-ML” and fix the timeout problem?And is my assumption correct that this process is a Machine Learning Application Programming Interface?CurrentCompany = ContextUserIdentity = XXXXXX@ProductionContextScreenId = CustomData = [  {    "CorrelationID": "8DC08946077156D",    "ContextID": "6B012D329006598311EE99ED322057CF",    "TypeOfRequest": "API-ML",    "ErrorType": "GlobalRequestTimeout",

Hi All,Im working on Fixed Asset then recognise some Fixed Asset which were converted from PO have wrong Orig. Acquisition Cost. 

With our company we have had to refresh out Sandbox Tenant a couple times within the past month. The first time I did this using the Copy Tenant function it took approximately 40 – 45 Minutes. The second time refreshing the Sandbox again and I am now over 70 minutes and it has been at most 30 days since the last refresh using the same function.For context the we have been on Acumatica for a year and the last size of our data was approximately 13GB averaging 1.08 GB of data each month of production. The time increase within 30 days seems a bit extreme for such a small amount of data. My question is if there is any insight anyone could provide as to how the Copy Tenant function works and any potential tips for data management with Acumatica?Thank you in advance!

HI All,I’ve had 2 upgrades in the last week and the users have complained that their system is slow after the upgrade. I have told them to clear their cache for all users, but does anyone else have any tips??I looked to see if this was a known issue and could not find it.  Thank you!

I cannot input primary contact in customer. when I type contact and tab to other field, it’s nothing save 

Hey everyone! 👋 I hope you're doing well. So, I'm diving into the Acumatica API, and I'm curious if anyone knows how to grab the License Monitoring Console Statistics from the API. Screenshot for reference:Is it doable through Acumatica API, whether it's Rest or Soap? Is there any Endpoint to access this data from Acumatica API-s? Your insights are super valuable, and I appreciate any help you can offer. Thanks a bunch in advance! 🙌Regads!

when using mobile app, → Scan Move, an error message occurs if there is a problem.   Is there a table in Acumatica where this error message is stored, such that I collect data of types of errors.

Hello Community,our customer want to use the Microsoft Authenticator für the MultiFactor Authentication. Is this possible? 

Good day, we are doing a project to move data from QB.  The vendor uses snapshots has development as move forward in the process from one tenant to another.  The process has caused a major space issue.  Does anyone have any advice.  We have started to delete old snapshots; this frees up some space but it is ongoing issue.Thank you

Hello Everyone,I’m getting the following error while trying to login to acumatica mobile app.What could be causing this, have researched about it but couldn’t get a solution. Kindly assist.All responses will be appreciated! 

When I create a snapshot for the purpose of installing the snapshot in a sandbox or for an emergency back up, should I create an “XML” or a “Binary” snapshot? Which is the most appropriate or better? We are on 2022 R2 so soon moving to 2023 R2.

I feel Acumatica could use someone in charge of tuning the site for performance. One of the little discussed dark sides of constant feature innovation is that there can be a tendency for performance to suffer as a result.For example, I was surprised that there doesn’t seem to be any plan to try to rearchitect the middle tier in conjunction with the move to Aurelia. Acumatica still has a pretty “thick client” approach to its stack, even though it is moving to adopt modern tools like Aurelia. Back in the bad old days of early .NET (remember code behinds?), it wasn’t really an option to asynchronously load the front end. You had to have all your data objects ready for presentation when the front end loaded. With modern asynchronous javascript, this is no longer the case, and so I think it is a missed opportunity to spend all the time to reskin the front end without focusing on the performance advantages that could also be gained by rejiggering the middle tier of the software.

Hello, We are encountering an issue after a recent Acumatica upgrade, with the DeviceHub.Basically, the printer has been configured and was working prior to the upgrade (on version 2021R1), however after installing the latest DeviceHub version 2022R1, the log shows the following message. When I am trying to use the ‘UPDATE PRINTER LIST’ on the ‘Printers’ screen in Acumatica, the DeviceHub log is not registering the request being made from the Acumatica web app. Note: The printer is correctly installed and the machine which is being used to run DeviceHub does have access to it as well. Has anyone ever encountered this please? Thanks and Regards,Nigel Pace