You’re offline. This is a read only version of the page.
I am upgrading from 2013r2 to 2015 Dynamics GP. When running the utilities to upgrade the database I am getting an error as such.
Table GL10110 did not have the correct structure prior to the conversion of this table.
Table GL10111 did not have the correct structure prior to the conversion of this table.
I ran the account_framework_validation script and it didn't return any issues. Where else can I check to resolve this error?
*This post is locked for comments
So for those of you playing at home...
Contact MS support. Apparently there is a bug of sorts that if it skips the synchronize tables initially it will never do it despite what you set the flag to in the DEX.ini file.
The answer was to uninstall GP2015 and reinstall (or in my case install into a different directory).
Once it started on the new install it performed the synchronization and worked as expected. It needs the synchronization because our install is using 3 segments as opposed to the default of 5 which is where the error was coming from.
Hi
No, Database Validation is code i wrote too check and fix many issues with the system. I have close to 250 hours of development in that one feature alone.
It is just one of many features in GP Power Tools that take the stress out of being a Dynamics GP administrator, consultant or developer.
David
Is the database validation feature the Database Maintenance program? I looked at that and it has several options of which area to select, I wasn't sure which one was tied to the GL tables in question. (Sorry new to Dynamics GP, I just got handed the system and told to upgrade this).
How do the SY tables translate into the GL?
Ex: SY003001 has 3 columns (mxlacnum, mxnumseg,dex_row_id) and only 1 row (25,3,2)
Does that tell me anything?
Just a suggestion, run the Database Validation feature in GP Power Tools before upgrading to make sure all tables in the system are the correct format.
For more info see [View:http://WinthropDC.com/GPPT]
David
Try this script:
Select * from DYNAMICS..SY003001
Select * from DYNAMICS..SY00302
GO
sp_help GL10110
GO
sp_help GL10111
DYNAMICS..SY003001 and DYNAMICS..SY00302 tables held the account framework settings.
I ran that script and it has no rows returned, which is why I was confused it failed on those tables.
Tables contain incorrect account framework information
If the following tables contain incorrect account framework information, the
upgrade will fail. You must run the following script in each company to correct the
issue.
To access attached scripts, you must view this document in Adobe Reader 6.0 or later or in
the full version of Acrobat. You also can download the scripts from go.microsoft.com/fwlink.
To verify account framework information in tables:
1. Right-click the paperclip icon to the left to open the
Account_Framework_Validation.txt script or save the script to your hard disk.
2. Copy all of the contents of the script and paste the contents of the script into
Microsoft SQL Server Management Studio.
3. Run the script against any database.
4. If results aren’t returned after running the script, the tables are in the correct
format.
Table physical name Table display name
GL10110 Account Current Summary Master
GL10111 Account Summary History
GL70500 General Ledger Report Options
GL70501 General Ledger Report Options Temporary
GL00200 Budget Master
GL00201 Budget Summary Master
U P G R A D E I N S T R U C T I O N S 27
C H A P T E R 4 S Y S T E M P R E P A R A T I O N
If results are returned after running the script, the tables do not match the
account framework information. Contact the Microsoft Dynamics GP Update
Technical Support Team for instructions before upgrading. You can contact
Microsoft Dynamics GP Technical Support using one of the following methods.
• Create a Support request (mbs.microsoft.com/support
newstart.aspx).
• Contact by telephone at 1-888-477-7877.
I thought that was how it was supposed to work, but I was hoping I had missed something. Other than the account_framework_validation script that is attached to the upgrade documentation, are there other scripts I need to run? Just checking in case.
Thanks!
You may need to start a case with MS to get it fixed but you may need to restore your Dynamics and Company DB's, Run the Pre-Upgrade scripts, and then run your utilities again. As long as the Account Framework file doesn't exist in the data folder, and the settings are set to true, It should verify the Account Framework in the DYNAMICS and COMPANY Databases.
Best of luck to you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,104
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (