System Health and Performance
Discussions about optimizing performance
- 86 Topics
- 309 Replies
Export multiple specific files to external storage
Hello Everyone,I need to export some specific attachment files to my external storage. I found this screen File Maintenance.is there a way to specify multiple files at once then move them to my external storage instead of one by one?I need them to be stored on external storage and not in Acumatica database. Kindly assist.Any kind of response will be highly appreciated. Thank you.
Restore snapshot: Violation of PRIMARY KEY constraint 'Note_PK'.
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?
Is it safe to Clean SMEmail table in Database, because Emails can NOT be truly deleted from Screen.
Hello, We use Acumatica to send emails often, and the outing going emails are actually not needed. It takes me a lot time and effort to delete them twice on screen “All emails” CO409070. But I happened to find these records, even if I have clicked delete twice on screen to delete(first time make processed to deleted, second time makes it disappeared from screen.) The table space usage are NOT actually reduced. Because it is still in DB, just with “DeletedDatabaseRecord =1 ”. I am not quite understand why this is designed this way. My question is, if we just Delete * from SMEmail where CreatedDateTime <='2022-09-30 20:30:55.027' and DeletedDatabaseRecord =1 . Would it be OK?
Clean "automation schedule history" ,SM205035
Hello, Our company has run Acumatica for nearly 3 years. We installed Acumatica on our own server and database. As an IT stuff, I checked there are large amount of history records when opening screen SM205035. These records are not quiet necessary, so I want to clean them. However, if I click “Delete ALL” button, I would get request timeout. Maybe these records are too much(we set some scheduler run in minutes interval). I can select 1 page and delete 1 page’s record at once by clicking “delete”. but that is so time consuming. Is there a better way to clean them? To delete them directly from DB is probably a way to go, but I am afraid to broke the table constraints and reference of each other. Can anyone give me some directions.
DeviceHub - 'Printer is not configured in Acumatica Instance' log message
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
Performance Improvements / Custom Indexes - Best Practices
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
Create PO from Project PM301000
Is it possible to Create Purchase Order from Project PM301000?We set all items we use for that project on Cost Budget Tab (including inventory id, qty). When creating PO, we will go to Purchase Order PO301000 and add ADD PROJECT ITEM, and only inventory id goes in. We expect the system will take the qty & unit from Project so we don't have to input that data again.
Snapshot error - The operation has been aborted
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.
Automation Schedule - How long it ran for
I like how I can click the VIEW HISTORY button on the Automation Schedules (SM205020) screen to see when the Automation Schedule ran, how many records were processed, if there were any errors, etc.But I’d also like to know how long the Automation Schedule took to run. Something like an Execution Completed column with a Date / Timestamp would be nice.I’m trying to find out how long my Automation Schedules are taking. Some of them might only take 5 minutes, while others might run for over an hour. It’s important to know if some Automation Schedules are overlapping each other because sometimes you want to make sure that a certain Automation Schedule finishes before another certain Automation Schedule starts.Does anyone know if there is a way to find how long an Automation Schedule ran for?
Delete Snapshots not visible on the User Interface
Hi everyone,How can I delete the snapshots as seen below. From the user interface they are not available and the system has been optimized.Is there a way I can delete the snapshots from the Database instead? if anyone may have a suggestion on how to go along with this, kindly assist since they have taken too much of the system space. Thank you all,Any kind of response will be highly appreciated.
Chief Performance Officer
Is there a method to resolve unsafe snapshots to allow a safe snapshot?
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:
How to fix error "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
Dear ALL,When I did the feature like below, it got error “Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding” Finance > Master Financial Calendar > Actions (Close Periods) > Press “UNPOSTED DOCUMENTS” Please help me how to solve this error.Regards,NNT
Trouble in set up Auto Schedule of Process Shipment SO503000
Hi All,When creating SO type TR, the information of the Customer will be default as MAIN:I would like to create a Schedule that will auto UPDATE IN all shipments that has customer ID MAIN and Custsomer Name MAIN as belowBut it seems this condition doesn't work. Do you have any idea to process with this condition.Best regards,Yên Chi
Exchange Sync Fails due to XML Issue
The following Sync status error is returned does anyone know how to resolve? An error has occured during processing ‘firstname.lastname@example.org' mailbox. System.InvalidOperationException: There is an error in XML document (6, 1). ---> System.Xml.XmlException: Data at the root level is invalid. Line 6, position 1. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlReader.ReadEndElement() at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderMasterCategoryList.Read6_MasterCategoryList(Boolean isNullable, Boolean checkType) at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderMasterCategoryList.Read7_categories() --- End of inner exception stack trace --- at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events) at System.Xml.Serialization.XmlSerializer.Deserializ
Test Tenant Issue after Update
For most of our companies, we normally setup a test tenant. I noticed today when logging into one that the test tenant was not available. I looked and they recently had an update applied. I then looked at another customer, who I haven’t accessed in a while, and they also didn’t have a test tenant. These are our only 2 clients who have their acumatica automatically updated. The test tenant is not available in the dropdown nor is it available in the tenants window. I then went and looked at Space Usage. It shows both the live/active tenant and the test tenant, but beside the live tenant it has a checkmark for Current. It does not have that for the test tenant. Has anyone else experienced this?
Why can't I prepare a dunning letter even though the customer has an overdue invoice?
Hi everyone,Can anyone help me explain my business case with dụnning letter, the picture below is a dunning letter generated on Feb 13, but on Feb 14 there is another overdue invoice but when I go to the dunning letter screen to prepare on Feb 15 I can't see this customer.As a result, I sent a dunning letter to the customer and missed the overdue amount of the above invoice.I expect to be able to prepare a dunning letter when an invoice is overdue, or I misunderstood something, please correct me. Thanks in advanced.
Already have an account? Login
Social LoginLogin with your Acumatica account
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.