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

Forecaster - Input Set Lock

To remove the input set lock, follow these steps.

Before you clear the lock, verify that no other users are logged on to the system. Otherwise, the user who is modifying the input set will lose their changes. To check for other users who are logged on, click View, and then click Current Users List.

1. Click Tools, and then click Remove Input Lock.
2. Click to select the input set that is locked, and then click Clear Lock.

Voila!

GP Budget Import Error

Trying to import budget from excel to GP.

SCENARIO:
Trying to import budget from excel to GP although you have exported the sample from GP and used that as your basis and put your figures in the spreadsheet generated by GP. Then you proceed to import and get an error.

ERROR:
"The number of periods for the budget does not match the number of columns in Excel. Import will not be able to complete."

RESOLUTION:
Change column headers from date type to text by putting apostrophe (') in front the date fields.

Voila!

Forecaster Data Transfer Utility

Ok so after looking and looking and looking I've finally found the forecaster data transfer tool/utility.

You need to download it from customersource.

Use the link below:

https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID=%7bC706AC0F-0F5E-402A-86C1-38A7800C0B26%7d&NRORIGINALURL=%2fcustomersource%2fdownloads%2fservicepacks%2fFCDataTool%2ehtm&NRCACHEHINT=Guest

Hope this helps!