Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Upgrading Dynamics GP ...
Microsoft Dynamics GP (Archived)

Upgrading Dynamics GP 2010 to Dynamics GP 2013R2 issue

(0) ShareShare
ReportReport
Posted on by Mark_21 245

Hi,

I've been asked to upgrade our current GP version (11.00.2044) to GP 2013R2 (12.00.1745)

Running Server 2012 and SQL 2012 Std.

The install went fine but when running GP Utilities it is failing to update our main Company, it states 'Company has errors from a previous update'

It is failing on 3 tables with the following errors:

Looking at the middle line it seems to be looking for I00101V instead of IV00101, which doesn't make sense to me.

Any help on these errors would be appreciated.

Thanks

Mark

*This post is locked for comments

  • Mark_21 Profile Picture
    Mark_21 245 on at
    RE: Upgrading Dynamics GP 2010 to Dynamics GP 2013R2 issue

    Hi Jonathan,

     

    After checking the SQL Logs it was that the 3 tables were used for replication,

    Thank you for you help as I would never have thought to check the SQL Logs.

     

    Mark

  • Verified answer
    Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Upgrading Dynamics GP 2010 to Dynamics GP 2013R2 issue

    Do the tables have the correct structure? These are not easy things to troubleshoot in a forum post Mark. If you want the best results open a support case so a engineer can get a Dexsql.log and script results.

    If you want to go about this the slow way then check the Dexsql.log and see what the error is behind the scenes.

  • Mark_21 Profile Picture
    Mark_21 245 on at
    RE: Upgrading Dynamics GP 2010 to Dynamics GP 2013R2 issue

    Just looked and they did not exist prior to the upgrade, ran the following:

    SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID

    FROM DYNAMICS.dbo.DU000030 a

    JOIN

    DYNAMICS.dbo.DU000010 b

    ON a.fileNumber = b.fileNumber

    AND a.PRODID = b.PRODID

    JOIN

    DYNAMICS.dbo.SY01500 c

    ON a.companyID = c.CMPANYID

    WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15

    Also going through the Upgrade guide as well.

    Thanks

    Mark

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Upgrading Dynamics GP 2010 to Dynamics GP 2013R2 issue

    Good idea Max. You don't want any records in the DU000030 table before you start an upgrade. Also make sure you go through the upgrade manual as well as the hot topic pages to make sure you are doing the necessary things to avoid known issues.

  • DinB Profile Picture
    DinB 3,812 on at
    RE: Upgrading Dynamics GP 2010 to Dynamics GP 2013R2 issue

    Can you check your backup of the system database to see if those records exist in DU000030 table before you started the upgrade?

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

Featured topics

Product updates

Dynamics 365 release plans