Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Getting an error while...
Microsoft Dynamics GP (Archived)

Getting an error while upgrading Dynamics GP company database to 2016R2

(0) ShareShare
ReportReport
Posted on by Preetham theGP 17

Hello,

We are currently working on upgrading GP 2013 R2(12.0.1745) to GP 2016 R2(16.00.0552).  Instead of upgrading GP from 2013R2 to 2016R2 , we are planning to do clean installation, steps are as below,

Step1: Build new server and do clean straight installation of GP 2016R2.(Get rid of old servers once our users are good with GP 2016R2.)

Step2: Open GP Utilities and upgrade existing company database to 2016R2.

I am getting below issue to proceed with Step 2

Error: Product 0 does not support upgrading from version 12.0.1745.

Based on my research on above error i found out that first we have to upgrade GP 2013R2 to latest build then upgrade to 2016R2. If this statement is correct then I have 2 questions  , please find below. If this statement is wrong then please help me to how to resolve above issue.

Question 1: Should i first upgrade GP 2013R2 to latest build and upgrade all companies to latest 2013R2 build then proceed with above 2 steps ?

Question 2: If above statement is yes then can i upgrade as below

                   GP 2013R2 12.0.1745 --> GP 2013R2 12.00.2198

                   GP 2013R2 12.00.2198 --> GP 2016R2 16.00.0552

Thanks in advance for your help and support.

*This post is locked for comments

  • Preetham theGP Profile Picture
    Preetham theGP 17 on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    Lucas,

    Thanks for your response, i have also checked above links though but i am noticing differences in table definition of SY00500 which is not included in any of above links. I am not sure why this table is not included, is there a chance table definition of SY00500 might be changed in later versions of 2013R2 ? Any idea ?

    Currently we are in 2013R2 12.00.1745 and upgrading to 2016R2 16.00.0675.

  • Verified answer
    Lucas Miller Profile Picture
    Lucas Miller on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    Preetham,

    This sort of information is published in the Dynamics GP Support and Services blog:

    Table, Column, and Parameter Changes in Microsoft Dynamics GP 2016 R2 and Year-End Update

    community.dynamics.com/.../table-and-column-changes-in-microsoft-dynamics-gp-2016-r2-and-year-end-update

    Table and Column Changes in Microsoft Dynamics GP 2016

    community.dynamics.com/.../table-and-column-changes-in-microsoft-dynamics-gp-2016

    Table and Column Changes in Dynamics GP 2015

    community.dynamics.com/.../blogs

  • Preetham theGP Profile Picture
    Preetham theGP 17 on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    Hello All,

    Can anyone please help me with a link that i can find all database schema changes from GP 2013 R2 to GP 2016 R2. Thanks in advance for your help.

  • Preetham theGP Profile Picture
    Preetham theGP 17 on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    Lucas,

    Thanks for your response.

    Actually i found that there were some customization's made to triggers and it has been missed so once i updated triggers the issue is gone.

  • Verified answer
    Lucas Miller Profile Picture
    Lucas Miller on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    Preetham,

    You're probably going to want to capture a DEXSQL.LOG or SQL Profiler trace of this issue to determine what sort of error is happening on the SQL side.  That will point you towards a resolution.

  • Preetham theGP Profile Picture
    Preetham theGP 17 on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    Hi,

    After 2016 upgrade, when users are trying to access RM inquiry window when they click on document number they are getting below error. I have researched in online on the same error but all i found is to run Grant.SQl which i did run but no lock. Can anyone please help me on this issue, Thanks in advance.

    I am running GP 2016R2 16.00.0675

    "A save operation on table 'RM_OPEN' failed accessing SQL data"

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    Hi Preetham,

    DavidMO had once written a SQL view to monitor the progress of a GP upgrade, as it can take several hours when owning multiple companies, and the last thing you want to do is kill the client.. :-)

    Check also out this blog post :

    http://dynamicsgpblogster.blogspot.ca/2011/05/microsoft-dynamics-gp-database.html

  • Preetham theGP Profile Picture
    Preetham theGP 17 on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    I am able upgrade all my companies successfully using below mentioned path, Thanks Beat and everyone for your help and support. This forum is always quick in responding to questions.

    GP 2013R2 12.0.1745 --> GP 2013R2 12.00.2230 --> GP 2016R2 16.00.0675

    While i am performing db upgrade for our major company i have noticed that dbutilities was greyed out for 2-3 hours but it looked like it's still working behind the scenes and i did not do anything and finally upgrade has been finished successfully in 6.5 hours. My question is what are all the ways i can find in the backend that upgrade is still going on with no issues ? I know that i can check db_status in DB_Upgrade table but i am trying to get more details such as in what order it goes on and what it means on each status ? If anyone have more details please let me know. Thanks in advance.

  • Preetham theGP Profile Picture
    Preetham theGP 17 on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    Thanks Lucas. I installed 16.00.0675 and it's working fine now.I started dbutilities and upgrading my companies from 12.00.2230 to 16.00.0675.

  • Verified answer
    Lucas Miller Profile Picture
    Lucas Miller on at
    RE: Getting an error while upgrading Dynamics GP company database to 2016R2

    Preetham,

    You'll want to look at the Dynamics GP 2016 Upgrade Hot Topic on CustomerSource to find the valid upgrade paths:

    https://mbs.microsoft.com/customersource/northamerica/GP/support/hot-topics/HOT_TOPIC_MDGP2016Upgrade

    So, if you're on 12.00.2230 you'll be able to upgrade to 16.00.0675 or later.  There is no upgrade path from that version of Dynamics GP 2013 to 16.00.0552 unless you upgrade to Dynamics GP 2015 first.  Applying the January Hotfix (16.00.0675) for GP 2016 prior to running your upgrade is going to be a much fast solution though.

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans