GP 2013 Upgrade Error "CB_Import_Deposit_TRN"

(0) Share

Report

Posted on by Community Member

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

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

RE: GP 2013 Upgrade Error "CB_Import_Deposit_TRN"

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.
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: GP 2013 Upgrade Error "CB_Import_Deposit_TRN"

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?
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: GP 2013 Upgrade Error "CB_Import_Deposit_TRN"

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.
Community Member on at

Like (0)

Report

RE: GP 2013 Upgrade Error "CB_Import_Deposit_TRN"

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.
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: GP 2013 Upgrade Error "CB_Import_Deposit_TRN"

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.
Community Member on at

Like (0)

Report

RE: GP 2013 Upgrade Error "CB_Import_Deposit_TRN"

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.