Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager is...
Microsoft Dynamics GP (Archived)

Integration Manager is Failing

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager is Failing

    Thanks Sean - I got this to work finally.  For anyone else who runs into this, here is what I did.

    1.  I used the domain admin to install GP.  However, the domain admin was not in the local administrators group.  I added the domain admins group to the local administrator group

    2.  I uninstalled GP completely along with IM.

    3.  I reinstalled GP - and yes, it was a bit of a pain.  All of my companies disappeared.  I am not well enough versed in GP to figure out how to re-add them.  Be warned if you do this step and have a bunch you need.

    4.  I reinstalled IM.

    After all that, I got the integration with the advanced ODBC connection to work.  I have errors, but those are related to structure of the file.

    I have not tested the web client or anything else yet, so I might have to redo that as well.

    Thanks again for the help Sean and Richard!

  • drummerboy_10 Profile Picture
    drummerboy_10 15 on at
    RE: Integration Manager is Failing

    I would uninstall Integration Manager and then re-install IM from the GP2015 installation screen.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager is Failing

    A bit more information - the DEX.DIC file that gets created is dated 12/6/2012.  That is probably not the one I want.....

    Where does that come from?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager is Failing

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager is Failing

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

  • drummerboy_10 Profile Picture
    drummerboy_10 15 on at
    RE: Integration Manager is Failing

    Tom -

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager is Failing

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

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager is Failing

    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?

  • Suggested answer
    drummerboy_10 Profile Picture
    drummerboy_10 15 on at
    RE: Integration Manager is Failing

    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. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager is Failing

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans