Version of dynamics gp on the client does not match the version of dynamics gp on the sql server (GP 2013)

(0) Share

Report

Posted on by Community Member

After restoring dynamics GP 10 db to Dynamics GP 2013 we are getting message the version of dynamics gp on the client does not match the version of dynamics gp on the sql server (GP 2013),Also when we are trying to login GP with 'sa' after restoring Database we are getting message "A get/change first operation on table 'SY_Users_MSTR' failed accessing sql data"

More Info : Number of results columns doesnt match table definition.

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (3)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

You cannot mismatch a GP 2013 client with a GP 10 database. You must upgrade the database first to GP 2013 by using GP Utilities.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Humayun,

Like Richard says, mismatched versions is a no no.

I got this error just two days ago at a client's office. They had upgraded the database on one machine, but failed to update the workstation. What you need to find out is what version is the database vs the workstation.

When you attempted to start GP, there should have been a file written to the temp folder in your profile named GP_LoginErrors.log. On my machine the log resides in:

C:\Users\LVail\AppData\Local\Temp\GP_LoginErrors.log

The log should tell you what the incompatibility is. For instance, it will tell you what version the db is on and what version the wkstn is on. The AppData folder is a hidden folder, so you'll want to make sure you can see hidden folders.

Another way to tell what build the wkstn is on is to hover your mouse over the Dynamics.dic file. If it's still associated with the dynamics.exe engine, the version number will pop up.

The workstation most likely has an entry in the Dex.ini file that will reveal it to you (unless this is a new installation)

Once you know the versions, your job is to update whichever one is on the lower version to the higher version. You could also upgrade them both to a higher version (which is what I did.)

Please let us know if you have any problems.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Richard.

Just to have clear understanding ,I am not connecting my client to GP 10 database , I have restored the GP10 Dynamics database to my new GP 2013 seq server .

do i need to upgrade GP10 database after restoring it to new server using GP utilities 2013 or i need to upgrade GP 10 database using GP 10 utilities. Also after restoring the database on new server sql 2008 i am getting the following message while logging in to GP utilities 2013 "There was problem ascertaining product version iformation."

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Leslie.

I have found the version of GP by Dynamics.dic but my GP_LoginErrors.log file empty (0 kb) contains nothing. I am trying to find DB version now

Was this reply helpful? Yes No
Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

You will need to upgrade GP 10 to 10.00.1779. You can get this SP on CustomerSource. This will eliminate the message about product versions.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Many Thanks for the prompt response Richard.

My new server have GP 2013 version 12.0.1295 according to .dic file.

GP 10 is installed on another production server . I have just taken backup of GP 10 database and restored here on GP 2013 database which is causing theses issues. I can not run anything on production server on GP 10 . I have to fix this issue for my GP 2013 server which have its own DB sql server 2008 on same machine and it was working fine before restoring GP 10 dynamics DB using its backup file.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

I am a bit confused.

You have server running GP10

You have another server running GP 2013

You copied the GP 10 to your GP 2013 server and somehow GP 10 no longer works?

What version of GP 10?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have production server running GP10 with sql server 2005

I have another server running GP 2013 with sql server 2008

i have restored the database from GP 10 database environment to my GP 2013 database server and then GP 13 stopped working

version of GP 10 : 10.0.1061

version of GP2013 : 12.0.1295

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am now able log in to GP utilities but during an update i am getting following message

"The stored procedure synchroniztabledata() of form dusqlaccountsynch:27Pass Through SQL returned the fowlloing results : DBMS :5000 ,Microsoft Dynamics :0"

Can you help me out here

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Please follow instructions in KB878449. You will need to copy all of your company databases plus the DYNAMICS database and do a complete upgrade using GP Utilities.

Was this reply helpful? Yes No