Budget Summary Master and Inventory Report Options won't upgrade to GP2015

(0) Share

Report

Posted on by Community Member

I am upgrading from GP2010 to GP2015 and moving to a new server. I moved four company databases to the new server. When running utilities on the new server to upgrade the data it made it through the DYNAMICS database. Then on the first company to upgrade I received two table errors - Budget Summary Master and Inventory Report Options.

When I ran the account framework validation script on the new server it returned "Database XXX, Segment 1 has the incorrect length in table GL00100 with the ACTNUMBR columns:. And four more lines just like it for the other four segments. I went back to the old server and ran through the process outlined by Derek Albaugh in his blog "The Account Framework Validation" script returned records, how do we resolve this?" to correct this. I ran the account framework validation and it returned no results. I then restored that company and DYNAMICS back to the new server and ran the account framework validation - again no results. I started the database upgrade with GP Utilities. I received the same two table errors. I ran the account framework validation and it returned results. Now the length in GP00100 is 9 for each segment, where before attempting the upgrade it was 5.

I tried upgrading another company and the received the same results - the account segment lengths were changed.

How can I prevent the upgrade from changing the segment lengths?

When I drill down on both of the table errors it says the temporary table did not get removed. I don't know if that means there is an additional problem or if that is expected with the framework changing.

Regarding the inventory report options errors (same in both companies I tried to upgrade). Neither of these companies use inventory and the IV70500 table is blank in both. I did run the "recreate selected table" through PSTL on this table also but am still receiving the error.

Thanks,

Marilyn

*This post is locked for comments

All responses (6)

Answers (1)

Derek Albaugh on at

Like (0)

Report

RE: Budget Summary Master and Inventory Report Options won't upgrade to GP2015

Thanks for the update and letting us know what resolved the issue for you.
Jothi Krishnan N 1,869 on at

Like (0)

Report

RE: Budget Summary Master and Inventory Report Options won't upgrade to GP2015

Thank you very much Harry and Derek for your valuable inputs. I was doing the test upgrade by refreshing the TEST databases with PROD copy. When the upgrade failed with the above message, I enabled the syncing thru Dex.ini file, but still the upgrade failed. I figured out that out of several companies we have in GP, 2 of them had the account segment field length higher than what was found in the setup/system database. I tweaked the script which I found in the above link and recreated the GL00201 and IV70500 tables with the correct field length and it worked. Thank you again.
Derek Albaugh on at

Like (0)

Report

RE: Budget Summary Master and Inventory Report Options won't upgrade to GP2015

During the installation of Dynamics GP, however, you're not actually choosing the account framework or doing anything with it, you're simply installing any additional features to go along with the 14 or so default features and creating those dictionary files and addins.

It's not until you launch GP Utilities where it will look for a DYNAMICS (or another named) system database that holds the SY003001 and SY00302 tables, which is the account framework. If it does not find a DYNAMICS/system database, then it will go through the process of having you setup the account framework from scratch, but again, only if it does not find any system database.

On a new install, or an existing install of Dynamics GP that was changed (i.e. a feature was added or removed), it will prompt you to launch Utilities, which will synchronize the account framework setup with all of the dictionary files for each feature/module. Otherwise, if the synchronization doesn't go through, Dynamics GP will use and expect a default framework of 5 segments each with a width of 9.
Verified answer

Redbeard 12,931 on at

Like (0)

Report

RE: Budget Summary Master and Inventory Report Options won't upgrade to GP2015

This is just a notion, but when moving Dynamics GP from one server to another, especially during an upgrade, it is not uncommon to install a new version of Dynamics GP on the new server, after restoring the Dynamics and company databases from the old server to the new server. It is exceedingly important to make sure when the code is installed on the new machine, to select an account framework that matches the framework on the original machine.

Dynamics GP supports up to 66 characters in 10 segments, but the default settings during installation if the advanced installation is skipped is 45 characters in 5 segments (see the image below).

The account framework can be found in the SY003001 and SY00302 tables in the Dynamics database. If you don't remember what account framework settings you chose during installation, you likely accepted the defaults. If the default settings don't match your original database, you would need to record the account format from the original install, and reinstall Dynamics GP on the new server, using advanced settings during install and match your existing account framework.
Jothi Krishnan N 1,869 on at

Like (0)

Report

RE: Budget Summary Master and Inventory Report Options won't upgrade to GP2015

Hi,

I'm facing the same problem that table upgrade fails for GL00201 and IV70500 when I try to upgrade from GP 2010 R2 ( with Jan 2015 Hotfix) to GP 2015 R2. I used the scripts given in the link below to resolve the issue but that didn't work for me. Also, link has another link to a video for the resolution but that video is not available anymore. Can you please let me know if you've resolved the issue and how.

https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/04/17/microsoft-dynamics-gp-2013-upgrade-troubleshooting

Here is the details of the error message....
Derek Albaugh on at

Like (0)

Report

RE: Budget Summary Master and Inventory Report Options won't upgrade to GP2015

Hello Marilyn,

I'm thinking you've probably gotten past this error, but if not, I just wanted to address it.

You're correct in that the Budget Summary Master (GL00201) and Inventory Report Options (IV70500) get setup with a specific number of columns to correspond with the Account Framework setup for Dynamics GP.

Unfortunately, the Account Framework Validation script only looks at the GL10110, GL10111, GL70500, GL70501 tables, but not the GL00201 or IV70500, so this may be why nothing was returned for these tables. There are over 30 tables in Dynamics GP that get setup with account framework structure, but these 4 are the most common we see fail.

I do question why the table would be getting changed by Utilities and the reason I say this, is because during an upgrade of a GP table via Utilities, it will take the original table and rename it and the primary key, for example, the GL00100 table will be changed to G00100L and the primary key PKGL00100 will become something like P00100KGL.

Utilities will then create the new GL00100 table and primary key, as well as any indexes, triggers, stored procedures, etc. specific to that table, then once it's completed with the new objects, it will try to take the data from the original table and put it into the new table and it isn't until the upgrade is completed for this table, that it will get rid of the original table.

However, should something cause the table to fail the upgrade, it will actually delete the new table and primary key, then rename the table back, for example, from G00100L to GL00100.

So, you can see, based on this, the original table never really changes, which is why I'm questioning why you're seeing your GL00100 table get a length of 9 for each segment, as this isn't something that is really possible, and definitely not what we commonly see, but it may be possible the temp table isn't getting dropped or something.

If the account framework doesn't successfully synch with the dictionary files, it'll default to use an account framework of 5 segments each with a length of 9. You can tell what it is using via a dexsql.log to see the structure of the new table, such as GL00100, being created during the upgrade.

The Professional Services Tools Library will also create tables using the synchronized or default dictionary scripts for the account framework, so if the dictionary files aren't synched, it could also potentially create objects with a default 5 segment with a length of 9 each structure.

Please let us know if you've resolved this issue or you're still seeing this occur.

Thank you,