System Health and Performance

Hello, I would like to bring it to attention that the Acumatica: Report Outages page has been experiencing an error for about a month now. Here is a screen shot.   Would someone please let me know how I can report connectivity issues, or if this is a problem with my login? Nobody wants to be caught in a position where the service goes down, and there is no clear procedure for reporting outages. 

Just looking to see what best practices others have around improving performance of GI’s, pivots, reports inside of Acumatica.  We have a client that does a lot of transactions (Project trans, Inventory trans, Sales Order trans).  We’ve created many custom GI’s, pivots and reports (some utilizing custom DACs) for their data reporting needs.  As their data and transactions grow, some of these are getting very slow to run.  Maybe some of these are written poorly but many I don’t think there would be a better way.  Is anyone out there creating custom indexes to address performance issues?  I know we can use Request profiler in Acumatica to identify problem queries or SQL tools if we have a local test instance.  Any best-practices or “gotchas” anyone wants to share on custom indexes and Acumatica?  I know there are requirements around multi-tenancy (i.e, include CompanyID in the index).  Any other thoughts or tools people have found helpful? Or are people just moving to 3rd party data ware

Other than using the Request Profiler, (which I find only slightly better than useless), is there any other way to produce/create a list of the processes in Acumatica that are Long Running processes?If so, what is that method?Thank you,Jeff

HI All,I want to set up that when the user change status of PO from Hold to Open, the system will require approval from the manager.But I can't find the condition Status. Is there any way we can do it? Please advise 

 Automation Schedules are not working for Emails Pending Processing Screen. I created a new one (Send Email (Calgary)) but it doesn’t work also. I have read some post here in the community that INITIALIZE SCHEDULER should be click. However, it is disabled on our end.  Need your inputs as I am doing the release of outgoing emails manually for now. We have also created a Acumatica support ticket but still no response receive. Thank you!

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. Files (#) still shows Files (2). Upon checking the list of files, only 1 file is present.It's important to note that thi

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",    "CustomMessage": "Denial Code 508: The system was unable to complete t

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?