Dynamics Community Forum Thread Details

Fixed Assets FA00902 Chunk File--Is It "Acceptable"?

Hello:

About a year ago, someone posted a document showing the need to (a) modify the DB_Upgrade table and (b) load a chunk file in order to eliminate slowness with upgrading fixed assets data during the run of GP Utilities in an upgrade.

Is it a legitimate chunk file? It will not explode.

I did the update to the DB_Upgrade table recommended by this document. And, I had no issues (for the most part) with the upgrade. So, I don't know if the chunk file is needed.

Below is the verbiage from the document. Please let me know your thoughts.

Thanks!

John

Fix for FA00902 upgrade problem

Dynutils_902.txt. Run this SQL script in your DYNAMICS database. This will add records for each company and DYNAMICS into the DB_Upgrade table. If you don’t do this then dynutils will exit after it determines it found an unknown product/version (the customization).

The customization – add to your GP folder where you are running dynutils from. When you launch Dynutils, make sure to right click and “run as administrator” to make sure the product code is included in the dynutils.set file.

After GP inspects your company versions, it is going to give a bunch of errors about cannot find a “\902\install.dll”. Dynutils expects there to be a folder for each product and the dlls to upgrade the application. In this case we don’t have any of that (nor need it). But I believe it will give the error at least twice – once for the “company” and once for “Dynamics”. Just click past the errors and ignore them. Doesn’t seem to affect anything else.

At the point that Dynutils is updating the FA00902 table, it is running my new TSQL update code and it should prove much faster than the GP code does.

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