Integration Manager Error – MSScriptControl

Microsoft Dynamics GPI’ve spent a fair bit of time recently importing data into Microsoft Dynamics GP using Integration Manager with which I have encounterd a few different error messages (ADO Field Is Nothing, All GP Windows Must Be Closed and Source Document Doesn’t Exist).

The latest error I’ve encountered related to the MSScriptControl;

Integration Manager - MSScriptControl Error


Integration Log
Integration: Customers Import (ID: 60)
Action: None
Start Time: 28/11/2011 11:21:01

28/11/2011 11:21:01 Source: IIntegrationEngine_Run, Status Code: 0 Opening source query...
28/11/2011 11:21:02 Source: IIntegrationEngine_Run, Status Code: 0 Establishing source record count...
28/11/2011 11:21:02 Source: IIntegrationEngine_Run, Status Code: 0 Beginning integration...
1: AMA001 Insert Failed 0. Seconds
DOC 3 WARNING: The default Tax Schedule ID assigned by the Class ID was overwritten by the mapped Tax Schedule ID.
DOC 3 ERROR: Unable to cast COM object of type 'MSScriptControl.ErrorClass' to interface type 'MSScriptControl.IScriptError'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{70841C78-067D-11D0-95D8-00A02463AB28}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
DOC 3 ERROR: Argument 'Number' is not a valid value. - Argument 'Number' is not a valid value.
DOC 3 ERROR: Unable to cast COM object of type 'MSScriptControl.ErrorClass' to interface type 'MSScriptControl.IScriptError'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{70841C78-067D-11D0-95D8-00A02463AB28}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
28/11/2011 11:21:05 Source: FinishDocument, Status Code: 0 ERROR: Max Errors Exceeded at 1, Integration Canceled
28/11/2011 11:21:05 Source: Microsoft.Dynamics.GP.IntegrationManager.IMProvider, Status Code: 51198184 ERROR: Integration canceled during document integration.
28/11/2011 11:21:05 Source: FinishIntegration, Status Code: 3 Integration Failed
28/11/2011 11:21:05 Source: FinishIntegration, Status Code: 3 Integration Results
132 documents were read from the source query.
11 documents were attempted:
0 integrated without warnings.
0 integrated with warnings.
11 failed to integrate.

Finish Time: 28/11/2011 11:21:05

Source Total: 132
Successfully Integrated: 0
Integrated With Warning: 0
Failed: 11

Completion Status: Incomplete
Integration Status: No Documents Succeeded

I had first tested the integration on my laptop before running it on the client’s server so I knew that there wasn’t an inherent problem with the integration itself.

I did some checking around and found a Microsoft KB Article 942750 referencing the rror I’d encountered; Error Message 3. The KB Article is for Integration Manager 10, whereas I am getting the error on Integration Manager 11. However, I figured Resolution 3, re-registering msscript.ocx, would likely be the applicable;

Run Command - regsvr32 %windir%\SysWOW64\msscript.ocx

Unfortunately, when I tried I got this error message;

Integration Manager - MSScriptControl Error

As a Domain User but Local Administrator on the server in question, I’d assumed that I should have the permissions to run regsvr32 but it appears not. I contacted the client’s IT department and asked if they could log on as the Domain Admin and give it a try.

After they notified me the ocx had been re-registered successfully, I was then able to import the customer list using Integration Manager without problem.

What should we write about next?

Your Name (required) -
Your Email (required) -

(Visited 1,573 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *