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.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

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 *