Integration Manager is Failing

(0) Share

Report

Posted on by Community Member

Greetings -

I am relatively new to Dynamics, so please forgive me if I get some of this wrong.

I am setting up my first company in dynamics and I ran into an issue. Everything appears to be installed correctly, and I am having no problems setting up the mappings. I am using an advanced ODBC map with a sql statement as the source and the chart of accounts as the destination. The map is VERY simple (this is just a test).

When I start the integration I get this wonderfully helpful error:

The destination could not be initialized due to the following problem:
- Unable to cast COM object of type 'System.__ComObject' to interface type 'Dynamics.Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D016638-BA35-11CF-827E-00001B27AB13}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Then I found this:

https://support.microsoft.com/en-us/kb/942750

It said to run this command: regsvr32 C:\Windows\sysWOW64\MSScript.ocx

I did everything it said, but I get the same error. Does anyone have any idea what is going on here? Thanks for any help.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (1)

Community Member on at

Like (0)

Report

Does anyone have any thoughts?

If not, how would I open a support ticket with Microsoft? When I try it is asking for an access id. I have no idea what that is or how I would find it.

Thanks again.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

Is this a W10 computer? If so I would first try by right-clicking on IM and select run as administrator. If that works, I would uninstall IM and reinstall it as administrator.

Was this reply helpful? Yes No
drummerboy_10 on at

Like (0)

Report

If you're loading a chart of accounts, have you tried loading them using a CSV file as the source? Also, have you verified all users have full permissions to the Dynamics GP installation and Integration Manager directories?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Richard, I have tried running Integration manager and GP as administrator. That did not work.

Sean,

I tried to load with a CSV - that did not work either. I also made sure that the user I had had full access to all dynamics folders, again that did not help. I get this error message if it helps:

The destination could not be initialized due to the following problem:

- Unable to cast COM object of type 'System.__ComObject' to interface type 'Dynamics.Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D016638-BA35-11CF-827E-00001B27AB13}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Was this reply helpful? Yes No
Suggested answer

drummerboy_10 on at

Like (0)

Report
Tom,

I'm going to ask this question, just to make sure and mean no offense, but you are opening Dynamics GP to the company you want to integrate the data into before running the integration - correct?

If you've done everything else Richard and I have suggested, I would try a CSV file again using a simple Text ODBC driver. Create your CSV file with the following columns:

Account Number

Description

Category

Posting Type

Typical Balance

Populate your data and then create your text ODBC/DSN and see if this works. There's should be a need to use an Advanced ODBC trying to connect to a SQL table to load a chart of accounts. Just a suggestion.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok, a bit more information.

First, I had to add the domain admin to the local administrator group on the server. That got past the old error message sort of.

Now I get an error that says DEX.DIC version 12.00.0196.000 is not compatible with executable versio9n 16.00.0027.000. I do not have GP 2013 on this machine, so I haven't the foggiest idea where that DEX.DIC file came from. I saw where I should be able to rename this file and have it just recreate it by repairing GP. That did not work though.

Any ideas on what to do from here? Is there a way to see if somehow an old GP2013 version is still installed? I do not see it in programs or anything but perhaps there is a registry setting?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Sean - I will try this once I resolve the above error.

I do appreciate the help - this has been a wonderful learning experience!

Was this reply helpful? Yes No
drummerboy_10 on at

Like (0)

Report

Tom -

On the server where IM is installed, under the Microsoft Dynamics folder, is there an old GP2013 folder?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

BTW, I am opening GP to the company I wish to process the COA.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No, there is not. I am thinking about uninstalling everything (GP and IM) and reinstalling. Do you think that would help?

Was this reply helpful? Yes No