Community
Discussion Forums
System Health and Performance

System Health and Performance

Discussions about optimizing performance

147 Topics
560 Replies

When you subscribe we will email you when there is a new topic in this category

147 Topics

Recently active

Most replies Most views Newest first

AndrewAVarsity I

asked in System Health and Performance

Insufficient resources to perform operation

Hi,A client is having an issue where they receive the error below on occasion, but sometimes it happens more frequently than other days.Have you ever run into a similar issue before? If not, is there anything you would recommend I check?Also, in case it matters, they are all using Macs, not Windows computers.Kind regards,Andrew

1 year ago

RSHAH1Freshman I

asked in System Health and Performance

Regarding Acumatica Time is not showing correct

Hello Team, One issue is facing that in acumatica time and system time is different and due to that session expire issue is happens quite alot so i want to fix the issue regarding set the EST time in Acumatica platform so your help is alot to me Please find attachment. Thanks and RegardsRushabh Shah@Naveen Boga @laura01 @BenjaminCrisman

1 year ago

helpdesk37Freshman I

asked in System Health and Performance

Automation Schedule to email statements

Hi @all,Have been trying to configure Automation Schedule to email statements. When I select Bi monthly which is the statement cycle ID set up for my customers no records come into view as shown;- What actually causes this? And again what if I continue configuring the automation schedule, will it be able to email the statements even if no customer records appears?

1 year ago

helpdesk37Freshman I

asked in System Health and Performance

Instance upgrade

Hi @all,I wanted to upgrade my instance from Build version 21.113.0011 to the latest 2023 R1 version. Have already uploaded the SQL database back up format of the system to test the upgrade offline. Have also installed Acumatica configuration wizard of build version 21.113.0011 same as my live instance and deploy an instance on it to help me test the upgrade offline.Which place actually should I perform the upgrade? is it on the configuration wizard or on the instance: -System > Management > Process > Apply Updates>Download Package>validate customization……..Which place exactly?

1 year ago

frankd97Freshman I

asked in System Health and Performance

Get "Execute Timeout Error" when releasing an AR Credit Memo applied to an AR Invoice.

In 22R2 when trying to “Release” an AR Credit Memo generated from “Reversing” an Original AR Invoice an error message appears "Execute Timeout Error Expired. The timeout period elapsed prior to completion of the operation or the server is not responding" error. I’ve seen this issue on forum for other situations in system and says resolved in previous versions prior to 22R2.

1 year ago

nawanjanahansamali50Freshman II

asked in System Health and Performance

How add a new email template on behalf of exicisting one?

Hi All,I need to add a new email template on behalf of existing one. Could you please let me know that how can I deactivate the existing email template.

1 year ago

ray20Captain II

asked in System Health and Performance

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?

1 year ago

Michael NdungiVarsity I

asked in System Health and Performance

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.

1 year ago

MichaelhSemi-Pro II

asked in System Health and Performance

Snapshot Deletion Timeout

I’m trying to delete a large (50GB+) snapshot. I keep getting a timeout error. How do I delete this thing?

1 year ago

Michael NdungiVarsity I

asked in System Health and Performance

Execution time out expired

I keep getting this error when loading this report.How can I resolve this? Thank you all

1 year ago

KMcGuire

asked in System Health and Performance

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?

1 year ago

helpdesk37Freshman I

asked in System Health and Performance

USER ACCESS RIGHTS

How can I can restrict and deny a user from creating a vendor? Which form or screen do I use?

1 year ago

ray20Captain II

asked in System Health and Performance

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.

1 year ago

mmedleyFreshman II

asked in System Health and Performance

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.

1 year ago

TimRodmanSemi-Pro III

asked in System Health and Performance

Automation Schedule - How long it ran for

1 year ago

Michael NdungiVarsity I

asked in System Health and Performance

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.

1 year ago

CAMORRISONFreshman I

asked in System Health and Performance

Using Amazon for storage

We need help getting started using Amazon for more storage because we have used up our usage in Acumatica. Does anyone have experience with Amazon and the steps they had to take to use them?

1 year ago

sd79Freshman II

asked in System Health and Performance

REQUEST TIMED OUT While creating PO from Requisition

My requisition has 4735 lines in detail level;I have 10000 lines per transaction License;Still I am getting “Request Timed Out” while creating PO from Requisition; Please assist;

1 year ago

nhatnghetinhCaptain II

asked in System Health and Performance

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

1 year ago

Troy VarsSemi-Pro I

asked in System Health and Performance

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 ‘myemail@me.com' 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

1 year ago

jvinski71Freshman I

asked in System Health and Performance

Reduce File Size

Is there a way for someone to reduce the size of an image they are uploading into Acumatica directly in Acumatica?

1 year ago

Michael NdungiVarsity I

asked in System Health and Performance

Specify Files to move to Local storage

Is there a way I can specify specific files to move to my local storage and not all;MOVE FILES TO STORAGE moves all files in the database to local storage specified, but I don't want to move all of them, I need to move specific files to local. Kindly help

1 year ago

jeffersonmacedoJr Varsity III

asked in System Health and Performance

System queues monitor - queue size is possibly exceeded

Hoping someone can help. I wonder if I can have a few ideas on how to resolve/investigate this case as we are experiencing this issue to one specific site. The queue size is overloaded not letting a business event get triggered. I have tried cleaning the queue and restarting the dispatcher, and it works fine, however, the next day I checked the business event history and no further events had been triggered so I updated one customer to ensure it was still working and it didn’t work. Then I manually cleared all the queues again as I did previously, retested the customer and it worked… how can we optimize the system so this will run as it should?Furthermore, I’m comparing a few GIs and Business events but I have no idea what is causing this as the GI has only a few records. Thanks !

1 year ago

RSHAH1Freshman I

asked in System Health and Performance

Automation Scheduler is not working and icon not showing as Active

Hello Team,, Can you please check why the scheduler is not working i set the required field but still its now working…

1 year ago

hthuy24Jr Varsity II

asked in System Health and Performance

How to use business event to auto send dunning letter when SO status is credit hold?

Hi all, I am currently set up system automatically send dunning letter when sales order status is credit hold by using business event.But there is a problem with my attached file, system send all dunning letter avaiable not only for this customer.Below is the email template and business event I have set up. Thanks in advanced.

1 year ago

Page 4 / 6

Badge winners

Dipak Nilkanthhas earned the badge Financials expert
kkraushas earned the badge Easy talker
ranjithduraisamy72has earned the badge Easy talker
jhoncandare04has earned the badge Easy talker
suchit39has earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.