Upgrade Issues When Upgrading To Microsoft Dynamics GP 2018 R2

When I was upgrading to GP 2018 R2 I received an error.  The error was:

“The stored procedure SynchronizeTableData() of form duSQLAccountSynch : 27Pass Through SQL returned the following results: DBMS: 2601, Microsoft Dynamics GP: 0.”

I searched online and did not find anything about it for GP 2018.  I did find this article which helped me find the errors one at a time.

https://community.dynamics.com/gp/b/dynamicsgp/archive/2015/06/10/draft-known-upgrade-issues-when-upgrading-to-microsoft-dynamics-gp-2015-r2?pi62366=4

Thank you Sarah Purdy for the article!

By creating a dexsql.log, you can see what table is causing your problem.  Here is the link on how to start one.  Note that the log file will be in the same directory as the dex.ini file.

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;850996

It turns out that there are some duplicate records found in the ASIEXP86 Table.  After removing all the duplicates the upgrade process continued successfully.

 

Hope this helps!

Mike

 

By | 2018-10-21T12:38:39+00:00 October 21st, 2018|0 Comments

About the Author:

Trained as an Accountant and has the certification as CPA. Discovered computerized accounting in 1989 with Great Plains Accounting and has grown up with Dynamics GP for 25 years.

Leave A Comment