web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Integration Manager RPC Server is unavailable

(0) ShareShare
ReportReport
Posted on by 12

I know there are a number of great posts on this matter - especially Terry H's blog -> https://community.dynamics.com/gp/b/dynamicsgp/posts/integration-manager-rpc-server-is-unavailable but they are a bit dated - yes 2019 is so long ago ( ha ha )

Anyway, I am looking for a solution to a situation where my client is running IM to update records between AP1 on SQL1 and GP running on SQL2.  IM runs for all other types of transactions - data output from same application (AP1) into either SQL tables or into Excel sheets that the users then add to - then all of these are imported as transactions to GP on SQL2.

When it comes to updates of the CUSTOMER / VENDOR masters we run into the RPC Server error.  There can be 10 updates or 5,000 updates - depending on the changes to AP1 over the period prior to the update.

We have now restricted the AP1 in what it sends over as updates and it clears out the Update Table so that there is only one update per CUSTOMER / VENDOR and then only if the update was something in the past period ( since the last update ) 

Still if the number of updates exceeds 2,000 we get this error.

Looking for some feedback and unfortunately one option off the table right now is changing the IM - the client is not spending money on this - they will drop the integration before they spend money - sure you understand, but NFP and CO-VID-19 are not great for the bottom line.

Thanks and look forward to suggestions.

Categories:
I have the same question (0)
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    Hi Bill,

    How do you connect the 2 SQL servers together ? one ODBC connexion each ? have you tried to use "linked servers" on the SQL2 server, so it would see the databases of SQL1 as local ?

  • Suggested answer
    Derek Albaugh Profile Picture
    on at

    To add to the information already mentioned.......

    >>Normally, when we see the 'RPC server is unavailable' message occur, related to Integration Manager, it is due to stranded Dynamics.exe sessions open.

        Please try the following:

        1. Close all running instances of Microsoft Dynamics GP and Integration Manager.

        2. In Windows Task Manager, under the 'Processes' tab, verify that you don't see any instances of Dynamics.exe process running, on any machines.

        3. Right-click on the Dynamics.exe file and choose 'Run As Administrator' when re-launching Dynamics GP 2016 R2.

        4. Right-click on Integration Manager and also use 'Run As Administrator' to re-launch Integration Manager.

        5. Try running the integration again to verify whether you get the same error, different error, or the integration now works correctly.  

    >>We've also seen this error caused by Integration Manager not being able to read a registry key for Microsoft Dynamics GP, so restarting Dynamics GP and Integration Manager or rebooting the entire server usually resolves the issue, when re-launching Dynamics GP first and then Integration Manager.

        If not doing so, you can also re-launch these applications by right-clicking on them and using the 'Run As Administrator' option, even if you're logged onto the machine as a administrator account.

    >>If you're on a terminal server and/or Citrix environment, make sure you don't have more than one active session at a time. If you do, decide which unwanted sessions to close down.

          Also, if running Integration Manager as a published application, you will receive RPC errors if attempt to integrate a document to Dynamics GP when both Dynamics GP and Integration Manager are ran as published applications.

    >>If none of the above resolve the RPC error when attempting the custom integration, then we'd want to verify if all other integrations work fine, including sample integrations, or if all integrations fail with the same error, or only if it is this custom integration.

          --If it is all integrations, then we may need to run a Repair and/or Reinstall of Integration Manager.

          --If it is just this one custom integration, then you may need to look at it further, especially if it has never worked correctly.

    The above information is mentioned in KB 943948 as well as the following blog: dynamicsgpblogster.blogspot.com/.../im-troubleshooting-rpc-errors-when.html

    Thanks

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans