GP Upgrade Error

(0) Share

Report

Posted on by Community Member Microsoft Employee

Getting an error when attempting to move from GP9 to GP10.

GP9 = 9.00.0385, GP10=10.00.1634

Dynamics db upgrades without error

Company db fails on 10 tables. All are error 135 (The conversion process encountered an error and the temporary table did not get removed.) Recommended Action = Remove the temportary table at the database level.

Inspection of DU000030 shows 2 types of errors. First 'Invalid Column Name' and the second 'Table did not have correct structure prior to conversion'.

Additional information is that this is really a move from SBF 9 to GP10. SBF 9 to GP9 went without error. GP9 SP 4 with year end update went without error. There are 9 companies. Have attempted move to GP10 on 3 and all error on same tables.

Have tried drop and create tables in GP9, but did not resolve issue.

Any suggestions?

Warren

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: GP Upgrade Error

Tables are:

GL00201 - Budget Summary Master

PM30300 - PM Apply History

PM30200 - PD Pd Trx History

PM20000 - PM Trx Open

PM10000 - PM Trx Work

PM00204 - Purch 1099 Period Detail

POP30300-POP Reciept History

POP30100 - ???

SVC00701 - SRV Transfer Line Detail

None of the are 3rd party.

The PM tables seem to be missing TEN99BOX, Which was not in V9 tables but is in V10 tables.

So something is causing the upgrade not to add columns to these tables.

Warren
Michael Marinaro 8 on at

Like (0)

Report

Re: GP Upgrade Error

Can you please provide some additional information? What tables aren't upgrading? Are they for a product you are no longer using or possible an SBF specific product?

Thanks,

Mike