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) -

Leave a Reply

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