Integration Manager Error – MSScriptControl

I’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 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;

Unfortunately, when I tried I got this error message;

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.