Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

The Microsoft Dynamics GP Login is Slow Following the Installation of Microsoft Dynamics GP 10.0 Service Pack 5 or Microsoft Dynamics GP 2010


Symptoms

The Microsoft Dynamics GP login is slow following the installation of Microsoft Dynamics GP 10.0 Service Pack 5 or Microsoft Dynamics GP 2010.

↑ Back to the top


Cause

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

The Analytical Accounting and Dynamics Online Services products for Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010 are continually adding records to the SY07110 table in the DYNAMICS database for each user that logs into Microsoft Dynamics GP. Over time, this table becomes very large and causes the login to slow down.

↑ Back to the top


Resolution

Microsoft Dynamics GP 10.0
1. The resolution for the Analytical Accounting product is in the Microsoft Dynamics GP 10.0 2011 US Payroll Round 2 Tax Update (KB 2477916) or any later patch release.
2. The resolution for the Dynamics Online Services product is in the Microsoft Dynamics GP 10.0 2011 US Payroll Round 4 Tax Update (KB 2502038).

Click one of the links below to download the latest release for Microsoft Dynamics GP 10.0:

CustomerSource
https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp10_patchreleases.htm?printpage=false
PartnerSource
https://mbs.microsoft.com/partnersource/downloads/servicepack/mdgp10_patchreleases.htm?printpage=false


Microsoft Dynamics GP 2010
1. The resolution for the Analytical Accounting product is in Service Pack 1 for Microsoft Dynamics GP 2010. 
2. The resolution for the Dynamics Online Services product is in the Microsoft Dynamics GP 2010 2011 US Payroll Round 4 Tax Update (KB 2502043).

Click one of the links below to download the latest release for Microsoft Dynamics GP 2010:

CustomerSource
https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_patchreleases.htm?printpage=false
PartnerSource
https://mbs.microsoft.com/partnersource/downloads/servicepack/mdgp2010_patchreleases.htm?printpage=false


Workaround
A Microsoft SQL Server job can be created to remove the records from the SY07110 table for the Dynamics Online Services product as a workaround until the resolution is released. The Microsoft SQL Server job can be scheduled to run every morning and/or at other times during the day to remove the records

1. Open the SQL Server Management Studio.
2. Expand the SQL Server Agent.
3. Right-click Jobs and click New Job.
4. Enter a name for the job.
5. Under the Select a page area at the left, click Steps.
6. Click New.
7. Enter a Step Name such as "Remove SY07110".
8. Click to select DYNAMICS as the database.
9. Copy the following statement into the Command area.

Delete DYNAMICS..SY07110 Where CmdDictID = 6499

10. Click OK.
11. In the Select a page area, click Schedules.
12. Click New.
13. Enter a Name.
14. Click to select Daily under the Frequency area.
15. In the Daily Frequency area, enter a time early in the morning or if you would like to run this more times throughout the day click to select the Occurs Every option and set that option.
16. Click OK.
17. Click OK.
18. Right-click the job to verify it runs successfully.


↑ Back to the top


More Information

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2502089
Revision : 1
Created on : 1/7/2017
Published on : 8/5/2011
Exists online : False
Views : 85