Dynamics Community Forum Thread Details

Dynamics GP 2013 R2 Upgrade Crashes on Fixed Assets Tables

Hello:

I'm conducting a test upgrade from GP 2010 (11.00.2197) to GP 2013 R2 (12.00.1920). I have 16 company databases to upgrade.

The DYNAMICS databases and two of the larger databases upgraded successfully. But, the upgrade has crashed on another large database. Specifically, GP Utilities crashed on the following fixed asset tables:

FA_Batch_Headers

FA_Financial_Detail_MSTR

FA_Financial_Detail_WORK

FA_GL_Interface_WORK

FA_Transfer_MSTR

When I review the details, most of the messages are "The conversion process encountered an error and the temporary table did not get removed" and "Remove the temporary table at the database level".

Another error says, "Invalid column name 'Ledger_ID'".

Now, I ran the script below before the upgrade and inserted the FA00902.cnk file into the GP 2013 code folder. My past experience and discussions with other consultants on upgrading showed that this procedure needs to be done in order to prevent another issue that has been reported with upgrading fixed assets tables.

I frankly cannot make heads or tails of what's in the dexsql.log file.

Any ideas?

Thanks!

John

delete from DB_Upgrade where PRODID = 902

insert into DB_Upgrade (db_name,PRODID,db_verMajor,db_verMinor,db_verBuild,db_verOldMajor,db_verOldMinor,
db_verOldBuild,db_status,start_time,stop_time)
    select DB_Name(),902,12,0,1,12,0,1,0,GetDate(),GetDate()

insert into DB_Upgrade (db_name,PRODID,db_verMajor,db_verMinor,db_verBuild,db_verOldMajor,db_verOldMinor,
db_verOldBuild,db_status,start_time,stop_time)
     select INTERID,902,12,0,1,12,0,1,0,GetDate(),GetDate() from SY01500

Quick Links

Leaderboard