Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

GP Upgrade Error - Cannot Create View DS10000

Posted on by 769
I am upgrading a client from 18.3.1233 to 18.4.1384.
At one point I was receiving the following error:  An error occurred while the Microsoft Dynamics GP Dictionary was being synchronized with the account framework.  In the dex.ini I sent Synchronize =True and ran utilities
During the upgrade I got an error on View DS10000  Invalid Column Name ACTNUMBR_6 and the upgrade fails and GP exists.
 
Their account format is set up for a possible 8 segments.  They are using 4 segments.  Tables GL00100 and GL00500 reflect columns for each of the 8 segments.  Tables GL00100F2, GL00100F3, GL00100F4, and GL00100TA each have columns for only 5 segments.  I have tried running checklinks on all the System, Company and Financial tables to get it to create the other 3 columns for segment 6, 7, and 8 but it did not create them.
 
I have since restored the databases back to their original version.
 
Does anyone have any recommendations on how to proceed?
 
 
 
Categories:
  • GP Upgrade Error - Cannot Create View DS10000
    Hello,
    Can you tell me what the potential impacts are of changing the account framework from 5 shards to 8 shards and how this might impact data integrity and system functionality?
  • Verified answer
    GP Upgrade Error - Cannot Create View DS10000
     
    SELECT * FROM DYNAMICS..SY003001              Account Definition Header

    SELECT * FROM DYNAMICS..SY00302               Account Definition
     
    I found the solution in the link above.  The number of segments in the Account Definition Header and the Account Definition table did not match.  I ran a sql script to change Sy003001 to match the total of the segments and max length defined in SY00302.  The database was then able to upgrade.
     
     
  • GP Upgrade Error - Cannot Create View DS10000
    I just got access to a test system in the customer's environment.  I first tried running the Alter sql scripts - and I still received the error.  I was able to drop and re-create the GL00100F2, GL00100F3 AND GL00100F4 Tables.  They were named Account Master Filter 2 3 and 4.  However I could not find the GL00100ta table to drop and re-create so that table still has the incorrect number of columns.  I then tried running the Alter scripts to add the columns to that table and that didn't work.
     
    I am now receiving  new errors when running utilities:
     
    FP:Bad component offset.Form: 22010Wind: 22000Fld: 14
     
    Unhandled Script Exception:
    Illegal address for field 'Account Number' in script 'initCompany'.
    Script Terminated
    Exception_Class_Script_Bad_Type
    Script_Cmd_Component
     
    I went through all the Products and Series' under Resource Descriptions and could not find GL00100ta.    This table is filled with GL type data
  • GP Upgrade Error - Cannot Create View DS10000
    You might want to try creating the missing columns manually. Here are the steps you can follow:
    Open SQL Server Management Studio and connect to your Microsoft Dynamics GP database.
    Open a new query window and execute the following SQL command to add the missing columns to the GL00100F2 table:
    • ALTER TABLE GL00100F2 ADD ACTNUMBR_6 CHAR(15) NULL
    • ALTER TABLE GL00100F2 ADD ACTNUMBR_7 CHAR(15) NULL
    • ALTER TABLE GL00100F2 ADD ACTNUMBR_8 CHAR(15) NULL
    Repeat step 2 for the GL00100F3, GL00100F4, and GL00100TA tables. getting over it
    After adding the missing columns, you should be able to complete the upgrade process without encountering the Invalid Column Name ACTNUMBR_6 error.
  • Suggested answer
    Robert Yao Profile Picture
    Robert Yao 492 on at
    GP Upgrade Error - Cannot Create View DS10000
    Hi Rochelle,
     
    It is very possible the account framework was changed from 5 segments to 8 segments in the past while GL00100F1 through GL00100F4 were never changed since the initial framework setup, what you can try here is to drop off those four tables then recreate them with ACTNUMBR_6, 7 & 8 with char(7), save it then try to upgrade again.  Try on a test server first.
     
    Hope it helps.
     
    Rob

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans