Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

GP2010 to GP2013 Upgrade Error - HR Tables

(0) ShareShare
ReportReport
Posted on by 673

Hi All,

Has anyone encountered the below when upgrading GP2010 to GP2013? What is the fix?

8228.GP-Error.JPG

Categories:
  • Verified answer
    RE: GP2010 to GP2013 Upgrade Error - HR Tables

    Based on the number of tables failing for 414/Human Resources and the error mentioning status 25 and "Path for this table was not resolved properly", my thoughts are that you're missing the record(s) for 414/SY02100, which is the paths table.

    Looking at my SY02100 table, I have 14 total records for my company database(s): 7 for DICTID 0, then one each for other modules I have installed, which include Manufacturing, Human Resources, the HR/Payroll Suite (4 total) and Advanced Security.

    You can verify this by running this script against your SY02100 table:

         Select * from SY02100 where DICTID = 414

    You should see a record for each company database and the system database.

    If you don't see this record, you can use this script example to insert it into the table:

    Insert SY02100
    Values(-1,414, 10, 0, 'TWO/dbo/','TWO','dbo','local')

    Once you add the missing record(s) into the SY02100 table as needed, run the following script before you launch GP 2013 Utilities again and continue the upgrade of this company database:

          Delete DU000030 where Status <> 0 and Status <> 15

    If this doesn't help resolve this upgrade error, we'd probably need a support case created so we can look at logs and tables, if you haven't already done so.

    Thanks

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans