Skip to main content

Notifications

Announcements

No record found.

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

Integration Manager for GP 2015

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

I am updating 6,000 vendors in GP via IM.  The first time we ran it, it failed at record 950.  The second time we tried running it directly from the SQL server, and it failed at record 958.  It gives me an RPC error (The RPC Server is unavailable. Exception from HRESULT: 0x800706BA).

I have read other posts on this subject and it seems that others get these errors at random times during their import.  Is there a cap due to SQL Server limitations to the number of rows it will update at a time?  

I suppose we could break up our file into 7 files of 850, and that should work ... but it's just annoying that we have to do that for every import or update.

I appreciate your feedback and advice.

Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager for GP 2015

    Using eConnect worked like a charm.  Thank you for the recommendation!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager for GP 2015

    There's an article buried somewhere that (I think) Frank Hamelly wrote. It actually has something to do with the macro that's running and the way your window is set up (since integration manager jobs are really just huge macros). The macro just kind of decides to quit after a while. To resolve the issue, open up the GP user preferences (on the client PC that's running IM) and set the window command display to Menu Bar.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Integration Manager for GP 2015

    Aaron,

    A few months ago, I ran an integration with 34000 items. It went through in one step. these were master files we were updating. Our data source was a SQL table and we didn't have a hitch.

    Kind regards,

    Leslie

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager for GP 2015

    Hi Aaron - The times i have seen that message is when there are multiple instances of Dynamics.exe running. Curious, have you tried using the eConnect adaptor in IM? Much much faster and nice thing is you do not need GP client running. Just install the eConnect run time and then add eConnect as the destination adaptor.

    Sandeep.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans