System Health and Performance
Discussions about optimizing performance
- 115 Topics
- 422 Replies
Hi, I am trying to release this attached bill but keep on getting this error, I have updated the numbering sequence as well for some reason few bills are still returning this error. Anyone else encountering same problem?
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!
we have upgraded from 2020R2 to 2022R1. Ever since, in both our SaaS Acumatica and our AWS sandbox, I have not been able to get a snapshot to export. The snapshot will complete as long as I do not ask to prepare for export. But then when I tell it to prepare for XML export, I get the following error after about 10 minutesThe operation has been aborted.I have plenty of space, and have actually deleted all the old snapshots. Also I have ran the optimize database after each delete and failed attempt. I have also restarted application after database optimization and nothing seems to help. Any ideas would be greatly appreciated.
Good day,I set up a new email as an incoming email to process AP documents. Test the connection was successful. I have sent a number of emails as a test but they are not being received in ACM. I have other emails receiving incoming that are working. (Set-up by someone else)Any suggestions where i can review, look or something that needs to be done to get emails received.Thank you.Evan
Hello again Everyone, I recently discovered that there are some wrong conversions set in my Inventory module. I have corrected them now but I can not seem to reflect to change in the conversion in my inventory reports, please help on how to fix this? Thank you! Kind regards,Mrivera67
Hi,We currently have 2 sets of Purchase Orders (i.e. 4 purchase orders in total) which have the same OrderNbr. Fortunately, this isn’t causing any issues in the database, since the 2 sets of PO’s have different types, i.e. 1 Drop-Ship and 1 regular PO, and luckily this has only happened twice in more than 2 years, but I don’t think this is normal behaviour, is it? Note that we are using MySQL as database.We’re using the numbering sequences with auto incremental values, so technically these 4 POs should all have had different reference numbers, right? Is there perhaps something we can do to enforce that this doesn’t happen? It is causing a little bit of confusion in our operations department when they see 2 POs with the same reference number.
Performance issue: users are complaining system (Build 20.203.0028) run slower than before which is 2020R1
Hello, I’ve read the postBut I am still wondering, Is anyone else experiencing this same kind of feeling? After our upgrade from 2020r1 to 2020r2 (Build 20.203.0028), users are saying the system is obviously run slower than before. Like placing SO lines, it would take more time to get the inventory id filled in. Like saving a document, it would take more time to complete. Which means they feel OK before, and feel bad after. The hardware and users did not change. I don’t know. Is it an illusion? Or is it really due to some new features bring in by 2020r2 that would cost more system resources? Can someone give me some guidance to make system run faster, like turn off any unessential features?
Hello,We currently have an Active directory linked to our Acumatica user base, we have noticed over the past year users have entered the status “Disabled”, do you know what would cause this, is Active Director pushing something to Acumatica that would be causing this?Thank you
I have created a snapshot without attachments and wiki and exported it to XML from a production instance. When I attempt to restore the snapshot to a different (test) instance, I get an error: - Violation of PRIMARY KEY constraint 'Note_PK'. Cannot insert duplicate key in object 'dbo.Note'. When I do a search in the notes.xml file from the snapshot export, the id identified in the error message is <row NoteText="" GraphType="PX.SM.EmailSendReceiveMaint" EntityType="PX.SM.EMailAccount" NoteID="e6ed61c5-0122-ec11-9b48-00224843cfc4" /> The test instance to which I am restoring already has a older version of the same data. How should I resolve this?
Hello, As system goes, I found the “Acumatica ERP\BackUp\Sites” on our server hard disk is becoming larger and larger. I checked the files inside “Acumatica ERP\BackUp\Sites” Some are years old. I don’t know at what time did the system automatically back these files? And I don’t think they are needed anymore, causing there are serval version updated. But for safety， I have to ask， is it safe to clean the files inside “Acumatica ERP\BackUp\Sites”
Hello.So my DB has significantly increased in size. I suspect the culprit are orphaned snapshots. I had the warning signed in System → Tenants, that there were at least 2 orphaned snapshots but when I clicked on optimize database to remove does orphaned snapshots I got an error almost immediately and then the warning sign disappeared. Is there a way I can manually check in the SQL database to see if there are any orphaned snapshots and to delete all those records from the database? Also when I check the database size in the Acumatica Interface by going to System - Tenants - View Space Usage, it shows the database size is 110GB in total - but SQL Management Studio shows the Database Size is almost 300GB and when I do a manual backup thats about the size of the .bak file... Any pointers as what I can do to fix this issue would be greatly appreciated.
Dear All,We are following the consigned inventory process in this articlehttps://www.acumatica.com/blog/how-to-implement-consigned-inventory-part-1/ the default setting for the transfer receipt is transferred type 2-step, which means we have to create a Purchase Receipt for that transaction.is it possible to change it to 1-step? It means skip the step creating Purchase Receipt and auto release transferThanks in advance.Yên Chi
Good dayIs there a way to see what is pulling data out of the system and how much? I have looked at the Access History(OData refresh) but I am thinking the API can also be an issue.We currently experiencing massive data pulls via the IIS on our server and I can't see what is pulling the data.Any ideas or suggestions will be helpful
Dear All,There is some item that has an expired date but when we check with the supplier, they agreed to extend expire date. Our old system allows us to change the expiration date, but I don't see any screen manage this on Acu Is this possible to change the Lot/ Serial Number for a specific item - user sometimes got mistakes and inputs the wrong Lot NumberBest regards,Yên Chi
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.