There was a problem ascertaining product version information.

(0) Share

Report

Posted on by Angel Nuñez

Hi fellas, I'm having an issue with sub-features 1428 and 1045: They are been used and are running okay on three different companies, but whenever I try to login to the fourth company, I first get this: "Database setup has not been completed for Microsoft Dynamics GP. Use Microsoft Dynamics GP Utilities to complete the database setup before starting Microsoft Dynamics GP". Then after going to the server and running GP Utilities I get this: "There was a problem ascertaining product version information. Microsoft Dynamics GP Utilities will now exit. Check DUinstall.log for more information". DUinstall has this: Error: Product 1428 does not support upgrading from version 12.0.0 or prior. Error: Product 1045 does not support upgrading from version 8.0.0. There's no reference to these sub-features for this particular company on tables DB_Upgrade and DU000020. My manager told me they were added after the upgrade to GP 2013. I have followed this: http://support.microsoft.com/kb/952054 and this: http://support.microsoft.com/kb/915472, but can't find a resolution.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: There was a problem ascertaining product version information.

1045 is Revenue/Expense Deferrals and 1428 is Electronic Reconcile. I would try running these scripts

SELECT CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500

SELECT * FROM DYNAMICS..DB_Upgrade where PRODID = 1045 and db_name = 'xxxx'

SELECT * FROM DYNAMICS..DU000020 where PRODID = 1045 and companyID = xx

SELECT * FROM DYNAMICS..DU000030 where PRODID =1 045 and companyID = xx

Please report back your findings.

Was this reply helpful? Yes No
Angel Nuñez on at

Like (0)

Report

RE: There was a problem ascertaining product version information.

The troubled company ID is listed on SY01500 as ID 8. There is no reference to 1045 nor 1428 on DB_Upgrade, DU000020 or DU000030 for this ID, but there is for the rest of the companies. Thanks Richard.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

RE: There was a problem ascertaining product version information.

The first thing GP is going to check when logging into Utilities is the db_upgrade. If there are no records in that table for a module GP will go look to see if the version check table exists:

1045- PP000001

1428- ME142803

If the version check table does not exist it will reinstall/reinitialize the module (drop all object and recreate them). However if it does find that table it will insert a record for GP 8 (or 9 depending on when the version check table was introduced for that module) into the db_upgrade table.

I am not sure how this has been working before as when you log into GP it is going to check the DU000020 table and when you log into Utilities the db_upgrade table. If these were added at GP 2013 then you could insert records into these two tables for this company but you need to realize that you have to be 100% sure that these modules are actually on GP 2013 version otherwise you are going to start getting errors in the application.

Was this reply helpful? Yes No
Angel Nuñez on at

Like (0)

Report

RE: There was a problem ascertaining product version information.

I have manually inserted records for both features to both DU000020 and DB_Upgrade, but keep getting the same error. This company DB does not have PPs or ME14s tables. Other companies on the same server are running these features just fine on GP 2013. I inherited this situation, so I'm not sure what the problem could be. Thanks Jonathan.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

RE: There was a problem ascertaining product version information.

If you have the right records in both tables you wont be getting the errors. Post the following script results:

Select * from Dynamics..db_upgrade where prodid = '1045'

Select * from Dynamics..db_upgrade where prodid = '1428'

Select * from Dynamics..DU000020 where prodid = '1045'

Select * from Dynamics..DU000020where prodid = '1428'

Was this reply helpful? Yes No
Angel Nuñez on at

Like (0)

Report

RE: There was a problem ascertaining product version information.

The faulty company is row 1 for DB_upgrade and row 6 for DU000020 (see image)

.

I'm not getting this error anymore:

"Database setup has not been completed for Microsoft Dynamics GP. Use Microsoft Dynamics GP Utilities to complete the database setup before starting Microsoft Dynamics GP" and tables for R/ED have been created, but tables for Electronic Reconcile are still missing and I'm still getting:

"There was a problem ascertaining product version information. Microsoft Dynamics GP Utilities will now exit. Check DUinstall.log for more information".

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

RE: There was a problem ascertaining product version information.

The issue isn't with row one in the first db_upgrade results, it is with row 4. If you look at the DUinstall.log file now I bet it says it cannot upgrade from version 8. You will need to delete that line and insert in a new one for that company.

Was this reply helpful? Yes No
Verified answer

Angel Nuñez on at

Like (0)

Report

RE: There was a problem ascertaining product version information.

Jonathan, you're totally right.

The issue persists because of this company in row 4, but the problem was brought to me after the user reported errors when trying to log in to company in row 1 as well, so I guess something happened during the upgrade to 2013.

After editing DB_Upgrade and DU000020, I got rid of the errors. We still have to upgrade this feature from 8 to 12, but that's a different matter.

Thank you very much, I've learned a lot today.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

RE: There was a problem ascertaining product version information.

But Angel you cannot upgrade the module now. That is why I said you can only change these records in these tables if you were 100% sure the modules were on GP 2013 version.

Was this reply helpful? Yes No
Angel Nuñez on at

Like (0)

Report

RE: There was a problem ascertaining product version information.

That's right. I'm not upgrading, it's a test company so i'll just let it be for a while.

Thanks

Was this reply helpful? Yes No