web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / GP Upgrade Error - Can...
Finance | Project Operations, Human Resources, ...
Answered

GP Upgrade Error - Cannot Create View DS10000

(2) ShareShare
ReportReport
Posted on by Rochelle Mausteller 773
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:
Microsoft Dynamics GP
I have the same question (0)
  • Joseph Markovich Profile Picture
    Joseph Markovich 3,972 on at
    GP Upgrade Error - Cannot Create View DS10000
    Am glad you got it all figured out! Yay!
  • Community member Profile Picture
    Community member 2 on at
    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
    Rochelle Mausteller Profile Picture
    Rochelle Mausteller 773 on at
    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.
     
     
  • Rochelle Mausteller Profile Picture
    Rochelle Mausteller 773 on at
    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
  • Community member Profile Picture
    Community member 6 on at
    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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,239

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 903 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 604 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans