Dynamics GP - Free any records locked by users

Use this script for all errors pertaining to locks / shares

Ensure all users log out of GP, then run
------------------------------------------------------------------------------

DELETE FROM [DYNAMICS].[dbo].[ACTIVITY]
DELETE FROM [DYNAMICS].[dbo].[SY00800]
DELETE FROM [DYNAMICS].[dbo].[SY00801]
DELETE FROM [tempdb].[dbo].[DEX_LOCK]
DELETE FROM [tempdb].[dbo].[DEX_SESSION]

------------------------------------------------------------------------------
If it says a batch is stuck / being edited, and there is no one else in the system

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

Integration Manager for GP 2013 error when running integration

Errors Obtained:

“The destination could not be initialized due to the following problem: ActiveX component can't create object”

 

“The destination could not be initialized due to the following problem:  Cannot create Active X Component.  Cannon create Active X Component”

 

“The RPC Server is unavailable “

 

 

Resolution:

 

-      Log on to the computer with the user who is receiving the error message while doing integration.

-      Reregister the Dynamics.exe file, To reregister

o    Click Start,

o    Then Click Run,

o    Then Type "\FileName.exe “/REGSERVER, and then click OK.

        = Represents the full path of the folder that contains the file, and the placeholder

FileName.exe = Represents the name of the file.

For example, type the following string

“C:\Program Files\Microsoft Dynamics\GP2010\Dynamics.exe” / REGSERVER

 

 

 

 

Error message when you start Microsoft Management Reporter: “Can’t connect to the Management Reporter server”

When you start Microsoft Management Reporter (MR) you receive one of the following error messages: "A connection to the server could not be established. Check the server address and try again or contact your system administrator." or "Can't connect to the Management Reporter server. Do you want to specify a different server address?"

To troubleshoot Management Reporter connection problems you need to click OK to this message and then click Test Connection to get an additional error message. You also need to go to Event Viewer to get additional information on the error. In Event Viewer click Windows Logs and then click Application. Under the Source column look for Management Reporter Report Designer or Management Reporter Services




If you check the Event Viewer, you may find the following error messages:

• Message: System.ServiceModel.ServerTooBusyException: The HTTP service located at http://servername:4712/InformationService.svc is too busy. ---> System.Net.WebException: The remote server returned an error: (503) Server Unavailable

This can happen if you have recently had your Management Reporter service account password changed.

Please use the below link to resolve your issue:

http://support.microsoft.com/kb/2666579

If you have not changed the password use the below link instead:

http://support.microsoft.com/kb/2406829

" The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company"

" The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company"

You receive the above error after restoring one database to another.

• To resolve the error you need to go to the SY01500 table of the DYNAMICS database and take note of the CMPANYID value for the database being restored to. 
• Next go to the SY00100 table of the company database where the restore was made to and update the 'CMPANYID" field with that value. 
• Also update the "DBNAME" with the relevant DYNAMICS database name if you are using a separate DYNAMICS database for this company.

Your SQL Server has not been named. Please contact your System Administrator

Your SQL Server has not been named. Please contact your System Administrator

You receive the above error message when signing into GP Utilities.

The below post helped me. Hope it helps you.

http://support.microsoft.com/kb/852728