10
I am encountering an issue with the ASIEXP81 table when upgrading to Microsoft Dynamics GP 2013 R2:
"The stored procedure SynchronizeTableData() of form duSQLAccountSynch : 27Pass Through SQL returned the following results: DBMS: 515, Microsoft Dynamics GP: 0.
We'd actually need to run a dexsql.log to capture this error message to see what exactly is going on.
DBMS: 515 is a SQL error basically stating that we cannot insert the value NULL into column XXXXX.
I've seen this type of error occur also if the table is having data populated into it, which the ASIEXP81 would, being it is the SmartList Favorite Master table, thus would have all default SmartList reports and favorites in it, but the table is missing the primary key and/or indexes, things like that.
The other thing to remember with the ASIEXP81 table is, it is the only table in the GP system database that gets setup with a specific number of columns, to correspond with the account framework maximums settings, as shown in the SY003001 and SY00302 tables.
Because of this, it wouldn't hurt to set SYNCHRONIZE=TRUE in the Dex.ini file, of the GP directory you're launching GP Utilities from, and then see if this resolves the error or not, by re-synchronizing the dictionary files with the account framework settings.
Thanks
Hi Beat Buche,
Yes, I tried this but not worked.
IF you have anything specific to fix this issue lease help.
Your help really appreciated.
Thank
Hi Raju,
Have you checked Microsoft's blog about GP upgrade issues ?
community.dynamics.com/.../microsoft-dynamics-gp-2018-r2-and-year-end-upgrade-known-upgrade-issues
And this blog post could likely help you narrow down the problem:
www.gpug.com/.../upgrade-issues-when-upgrading-to-microsoft-dynamic
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (