Share
ReportGot this error during GP 2010 upgrade to GP 2013 R2. This error i get during updating database. Any one can help me on this;
*This post is locked for comments
You’re offline. This is a read only version of the page.
Got this error during GP 2010 upgrade to GP 2013 R2. This error i get during updating database. Any one can help me on this;
*This post is locked for comments
Hi guys,
Sorry for late to reply back.
Actually i already solve this issue using this link.
community.dynamics.com/.../microsoft-dynamics-gp-2013-upgrade-troubleshooting.aspx
This link is very good for those had this Table Conversion Failure! And please make sure check the video ok!
Thanks again guys!
Shah.
I would like to add first making sure DYNSA is the owner of your database. Plus look inside this database. Are there any backup tables that can be removed and are there any tables that have spaces in their names. If there are either remove them or remove the space. Did you run check links on your tables on this database prior to the attempted upgrade?
Shah - the Recommended action is to Remove the temporary tables at the Database Level.
First, make a backup of your USGPL database. Then Drop the tables identified in the error details. You should restart the utilities after removing the tables.
Thank you for reply guys and sorry for not give you more detail info regrading this issue. The Errors/Warnings;
Error Code: 0
Error: Other Error (135)
Error Explanation: The conversion process encountered an error and the temporary table did not get removed.
Recommended Action: Remote the temporary table at the database level.
Table Detail;
Table Name: Account Master
Technical Name: GL_Account_MSTR
Physical Name: GL00100
Table Series: Financial
Table Group: Account Master
Total Records: 322
Version: 11.80.0001
Table Location: USGPL\dbo\
The error not just for Account Master, it also for Budget Summary Master (GL_Budget_SUM_MSTR - GL00201), Inventory Report Options (IV_Options_ROPT - IV70500), Import Deposit Transaction (CB_Import_Deposit_TRN - CBDEP002)
Any ideas? Thanks for helping.
Mohammad is indeed correct, there isn't much we can contribute without the details of the Errors and Warnings related to the various tables. The tables all appear to be in the Financial Series. If I were playing a hunch I would suppose a product like Analytical Accounting or some 3rd Party product, which extends these tables, needs to be installed to be able to successfully run the utilities and upgrade the databases.
Hello Shah,
You need to provide more information to be able to help you with this, please click on the error and hit on "Errors/Warnings" button and "Details" button to get the full details about the issue.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (