Service Pack 5 affects Microsoft Dynamics GP 10.0 logon performance
Views (1295)
MG-16101311-0
26,225
Like
Share
Report
No need to be alarmed, but if you currently use Analytical Accounting with Microsoft Dynamics GP 10 and have applied the recently released Service Pack 5, you may experience slow logon performance due to extra records being added to the dbo.syMenuMstr table each time a user logs into the system.
As a temporary fix and workaround, you can setup a SQL Server job to run once a day (more depending on the number of users in your environment) that will clear the offending records:
Upon logon, the menu items for Analytical Accounting are automatically recreated.
For more information on creating a SQL Server job visit MSDN.
Until next post!
MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
As a temporary fix and workaround, you can setup a SQL Server job to run once a day (more depending on the number of users in your environment) that will clear the offending records:
use DYNAMICS;
go
delete from SY07110 where CmdParentDictID = 3180;
Upon logon, the menu items for Analytical Accounting are automatically recreated.
For more information on creating a SQL Server job visit MSDN.
Until next post!
MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
This was originally posted here.
*This post is locked for comments