Dear All,
I am using Microsoft Dynamics GP 10. from last 3 days when I am going to post Single Sales Transaction Batch It takes 20 to 30 minutes. We are using AA and we don't have more then 2000 entry in Sales Order Process Module.
Can any body tell me how can I resolve this issue.
Regards,
Asif Fattah
*This post is locked for comments
I agree. specially profiler can point which tables getting more time..
If it is only in SOP posting perhaps there are corrupt records in inventory or a locked record in SQL. If you can I would reboot the SQL server and then in SSMS run this command while NO one is in GP.
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
If this does not help, I would try these steps.
1) Backup company database
2) Run Check Links on all modules all series
3) Run Inventory Reconcile
4) Try posting again. If problem persists run SQL Profiler while posting.
If there is any specific list I would also love to know, but in your situation I would first try sql profiler , I have same delay issue on gp login it takes 10 to 15 minutess to login and I found, it is calling some procedure repeatedly.
Is there any Check list which I can go through to check the performance of Microsoft Dynamics GP.
Then I would say without looking into your environment can't say anything, need to check this through several means, did you try sql profiler? is it happening with some specific user?
No customization at all.
and do you have any customization on sales entry window or on posting?
Yes, all Transaction posted without any error.
If No. of Transaction Increase in Sales Batch the time is also increased. If we have 10 Transaction in Batch then It may take 1 to 1.5 Hour.
And did your all 2 to 3 transactions get posted successfully after 20 to 30 minutes or you get some errors?
almas
Currently in our existing GP Server I have Total No. of Sales Transaction are 2000. In single batch I have one or two Transaction which I am going to Post but that 1 or 2 Transaction taking 20 to 30 minute. This delay only happen in Sales Transaction. When I am going to post other then Sales Transaction Its working fine. delay only occur during posting of Sales Transaction. So I think this problem relates to GP.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
