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