Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : 0hZYnyDCWvN+gkDMhMECWM
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / error upgrading GP 9 t...
Microsoft Dynamics GP (Archived)

error upgrading GP 9 to GP2010

Like (0) ShareShare
ReportReport
Posted on 14 Dec 2010 15:14:58 by Beth Jones 250
Error when running Dynamics Utilities after installing GP2010 SP1 and the most recent hotfix - "There was a problem ascertaining product version information. Microsoft Dynamics GP Utilities will now exit. Please check the duinstall.log file for more information."
Duinstall.log error - Error:  Product 0 does not support upgrading from version 9.0.352.
This morning I installed the most recent fix for GP 9.0 taking it to version 9.0.386 however I sitll get these errors. So somewhere that older version is stuck.
I'm out of ideas to try and I dont want to have to spend the money to call Microsoft.
Thank you in advance,
Beth

*This post is locked for comments

  • Paul Clements Profile Picture
    Paul Clements 150 on 02 Feb 2011 at 05:40:27
    Re: error upgrading GP 9 to GP2010

    I tried Beth`s suggestion but still the same problem, I think I will have to wait until the next tax update is released as per Leslie suggestion.

    thanks for all your help with this

  • L Vail Profile Picture
    L Vail 65,271 on 01 Feb 2011 at 23:01:52
    Re: error upgrading GP 9 to GP2010

    I do not think the upgrade path to GP2010 will not be restored until the round 2 tax update is released for GP 2010. I give more details in my blog article

    dynamicsconfessions.blogspot.com/.../v-9000386-upgrade-path-to-gp2010-gone.html

  • Beth Jones Profile Picture
    Beth Jones 250 on 01 Feb 2011 at 15:22:22
    Re: error upgrading GP 9 to GP2010

    You can try this, it didn't work for me but was another suggestion from Microsoft.

    1) First, backup the DYNAMICS database as well as the company you're updating

    2) Then, edit and run the following:

    UPDATE DYNAMICS..DB_Upgrade

    SET db_status = 23

    WHERE db_name = 'xxxx'

    3) Run GP 9.0 Utilities and you should be prompted to upgrade. If several companies are given just select the one we're working on and proceed with the update.

  • Paul Clements Profile Picture
    Paul Clements 150 on 01 Feb 2011 at 13:44:45
    Re: error upgrading GP 9 to GP2010

    Thanks for the reply Beth, My servername is fine. I have also tried this from Warren Pease

    Here is what I think is going on.   The DU00020 table has an entry for company -1, which is Fabrikam.   I bet the TWO database does not exist.    Utilitiles looks to the DU00020 to determine versions and find the -1 company at the wrong level, so it errors.

    1) Look at SY01500 table in the Dynamics database.   If you find -1 in the CMPNYID column, delete the row.   If you don't, that is okay.

    2) If TWO database exists, delete it.

    3) Delete all rows in the DU00020 table that have CMPNYID of -1.  

    4) On Customer Source, find the KB863236 article.   Download and run the clear companies script.

    All your other companies and Dynamics databases look like they are on the right level.   You should be good to go.

    Once upgraded, you can add the sample company back using utilities if you want.

    This didnt work either.

    I have tried another Hotix which takes me up to 9.0.0.388 , but still the same error

  • Community Member Profile Picture
    Community Member on 01 Feb 2011 at 12:49:22
    Re: error upgrading GP 9 to GP2010

    Here is what I think is going on.   The DU00020 table has an entry for company -1, which is Fabrikam.   I bet the TWO database does not exist.    Utilitiles looks to the DU00020 to determine versions and find the -1 company at the wrong level, so it errors.

    1) Look at SY01500 table in the Dynamics database.   If you find -1 in the CMPNYID column, delete the row.   If you don't, that is okay.

    2) If TWO database exists, delete it.

    3) Delete all rows in the DU00020 table that have CMPNYID of -1.  

    4) On Customer Source, find the KB863236 article.   Download and run the clear companies script.

    All your other companies and Dynamics databases look like they are on the right level.   You should be good to go.

    Once upgraded, you can add the sample company back using utilities if you want.

    Warren.

  • Beth Jones Profile Picture
    Beth Jones 250 on 01 Feb 2011 at 12:18:42
    Re: error upgrading GP 9 to GP2010

    I worked with a microsoft rep to get this fixed. Turns out when i ran GP Utilities to update the tables from 9.0 to Gp2010 I had error messages which I just ignored. Turns out my test SQl server name was differnent.

    1) First, run the following to see what server names are stored in SQL:

    SELECT @@servername

    SELECT * from master..sysservers

    2) Assuming that this is wrong, you need to edit and run the following to set them to the correct name:

    sp_dropserver 'oldserver'

    sp_addserver 'newserver', local

    3) Then, restart the SQL Server service on the test server

    4) Re-run the scripts from Step #1 to verify the change took place

    Reinstall GP2010 to upgrade companies with no errors.

  • Paul Clements Profile Picture
    Paul Clements 150 on 01 Feb 2011 at 11:40:12
    Re: error upgrading GP 9 to GP2010

    I`mhaving the exact same issues as Beth, has anyone else got round this??

  • Beth Jones Profile Picture
    Beth Jones 250 on 15 Dec 2010 at 10:21:24
    Re: error upgrading GP 9 to GP2010

    I am upgrading to 2010. I did find the upgrade paths for 2010 and I followed them. It said to upgrade 9.0 to the newest version which I did (9.00.386) and to use the latest GP2010 which I am. But for some reason the duinstall.log file still thinks I'm using version 352.... which I'm not.

    Duinstall.log error - Error:  Product 0 does not support upgrading from version 9.0.352.

    It's definiately a version issue but I followed Microsoft's paths but for some reason it's not liking it. Any other ideas??

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,269 on 14 Dec 2010 at 20:35:30
    Re: error upgrading GP 9 to GP2010

    Beth,

    follow my blog article for above error. I faced this error before.

    sandipdjadhav.blogspot.com/.../there-was-problem-ascertaining-product.html

    Let me know problem resolve or not.

    Thanks

    Sandip

  • Community Member Profile Picture
    Community Member on 14 Dec 2010 at 17:17:13
    Re: error upgrading GP 9 to GP2010

    Chances are it is the Fabrikam, Inc. DB run th following script for verification

    SELECT * FROM SY01500 where cmpanyid = -1

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,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans