You’re offline. This is a read only version of the page.
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
I have the same question (0)Thanks for posting this. I was experiencing similar performance issues via RDS (local, not in cloud) on login and SmarLists specifically. I found the DEX.INI was pointing to an old version of REPORTS.DIC. I renamed that file (since we don't have any modified reports anyway) and restarted GP. Now it's humming along like it should be. I've been using GP since 1995 and the Reports.DIC file has always been delicate and problematic so I'm not sure why I didn't think of this. Thanks again for taking the time to post. It saved me some time and will make my customer happy!
Share
Report
All responses (
Answers (
385
