If anyone has seen, in my previous question I had a weird error that I have fixed now.
Now, I'm trying to do an upgrade to GP10. It works great until I try to run it. It tells me it needs to run utilities. I click OK and when it opens during the Validating Product Version Information screen, I get an error that says "The stored procedure verifyVersionInformation()
After I click OK, I get "There was a problem ascertaining product version information. Microsoft Dynamics GP Utilities will now exit."
This will be a continuous loop. Anyone have any idea?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Just out of curiousity, what service pack is your Great Plains 9?
We are doing the same thing in a test environment at the moment, upgrading from 9 to 10.
We ran into issues because our version 9 was at Service Pack 1. You have to have version 9 at Service Pack 2, before upgrading to Great Plains 10.
Thanks.
Here is what I found out in the Microsoft Dynamics KnowledgeBase.
You receive an error message when the Validating Product Version Information process is run in Microsoft Dynamics GP Utilities
View products that this article applies to.
--------------------------
Confidential Article
(The information in this article is provided to you in accordance with your Confidentiality Agreement)
--------------------------
Partner Only Article Article ID : 943966
Last Review : N/A
Revision : 1.0
On This Page
SYMPTOMS
CAUSE
RESOLUTION
Method 1
Method 2
MORE INFORMATION
APPLIES TO
HOTFIX DOWNLOAD
SYMPTOMS
When the Validating Product Version Information process is run in Microsoft Dynamics GP Utilities, you receive the following error message:
The stored procedure verifyVersionInformation()
Back to the top
CAUSE
This problem occurs if the collations and the sort orders of the DYNAMICS database and of the company database do not match the collations and the sort orders of the Microsoft SQL Server system databases.
To compare the collations and the sort orders of the databases, see the "More Information" section.
Back to the top
RESOLUTION
To resolve this problem, correct the collations and the sort orders so that they are the same for the DYNAMICS database, for the company database, and for the SQL Server system databases. To do this, use one of the following methods.
Back to the top
Method 1
Contact MBS Professional Services to schedule a billable service to be completed by Microsoft Business Solutions. To do this, send an e-mail message to the following address:
MBSProfessionalServices@mi
Back to the top
Method 2
Change the collations and the sort orders of the DYNAMICS database and of the company database by using the Bulk Copy Process (BCP) feature of SQL Server.
For more information about scripts when you use the BCP process to change the SQL Server sort order, click the following article number to view the article in the Microsoft Knowledge Base:
875179 How to use the Bulk Copy Process (BCP) to export Microsoft Dynamics GP data from one database and import data into a new database
Note Changing the SQL Server sort order for the DYNAMICS database and for the company database is supported by Microsoft Business Solutions only if this change is completed as a service through MBS Professional Services. For more information about submitting a service request to change the SQL Server sort order, contact MBS Professional Services. To do this, send an e-mail message to the following address:
MBSProfessionalServices@mi
Back to the top
MORE INFORMATION
The SQL Server system databases can be the following databases:" master
" model
" msdb
" tempdb
To compare the collations and the sort orders of the databases, follow these steps:1. Run the sp_helpdb command in a query tool. To do this, use one of the following methods.
Method 1: If you use SQL Server Management Studioa. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
b. In the "Connect to Server" window, follow these steps:1. In the Server name box, type the name of the server that is running SQL Server.
2. In the Authentication box, click SQL Authentication.
3. In the Login box, type sa.
4. In the Password box, type the password for the sa user, and then click Connect.
c. Click File, point to New, and then click Query with Current Connection.
d. In the blank query window, type the following script.
sp_helpdb
e. On the Query menu, click Execute.
Method 2: If you use SQL Query Analyzera. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
b. In the "Connect to SQL Server" window, follow these steps:1. In the SQL Server box, type the name of the old server that is running SQL Server.
2. In the Connect using area, click SQL Server Authentication.
3. In the Login name box, type sa.
4. In the Password box, type the password for the sa user, and then click OK.
c. In the blank query window, type the following script
sp_helpdb
d. On the Query menu, click Execute.
Method 3: If you use Support Administrator Consolea. Click Start, point to All Programs, point to Microsoft Support Administrator Console, and then click Support Administrator Console.
b. In the "Connect to Server" window, follow these steps:1. In the SQL Server box, type the name of the new server that is running SQL Server.
2. In the Login Name box, type sa.
3. In the Password box, type the password for the sa user, and then click OK.
c. In the blank query window, type the following script.
sp_helpdb
d. On the File menu, click Execute.
2. To view the data, expand the Status column in the results.
3. Compare the values after the following statements:
Collation=
SQLSortOrder=
For example, you may see a statement that resembles the following statement.
Collation=SQL_Latin1_Gener
Note The following SQL Server sort orders are supported by Microsoft Dynamics GP: " Binary Sort Order: 0 and 50
" Dictionary Order Case-Insensitive (DOCI) Sort Order: 52
Business Accounts
Answer for Membership
by: scrathcyboyPosted on 2008-08-13 at 18:57:48ID: 22227356
version 10 evidently does not like your registration number for version 9, probably because that was an upgrade from a previous version of GP software. As with all M$ version and REG number problems, you are going to have to call M$ to have some dippo "unlock" your locked install. M$ believes that paying for their software is just not enough -- you also have to suffer their regulatory control too. Call them.