User were experiencing posting times for Sales and Receivables batches with a single transaction upwards of 10 minutes, longer if the batch was larger.
Went through various fixes and checks offered here with no luck at all other than restarting server. These included recompile, update statistics, verifying various tables did not contain stale records, etc.
The issue we found was that the DEX.INI file was pointing to a path here locally for the REPORTS.DIC file while the RDS server was up in our data center in the cloud. We moved the REPORTS.DIC file local to the RDS server and updated the DEX.INI file and the batches are posting quickly again. We set the pointer back and were able to recreate the issue.
I hope this helps someone else out there this took several days to uncover for our team.
*This post is locked for comments

Report
All responses (