Version conflict after installing SP2 for GP version 9.0

[GPUser05]

We are at Version 9.0 for Dynamics GP. We installed service pack 2 on server, it installed fine and updated tables through GP Utilities. After updating tables, when we launch the GP on server it writes all new code but when we log in to the Dynamics, it gives error that client version is different than database version, check Login Error file. The loginError file shows that Database version has SP2 but Client Version is still at SP1.

I would appreciate any help.

Thanks,

 

[jymm]

in your dynamics database
look at the DB_Upgrade table
HOPEFULLY you do not have too many products - you can look through this table and see which company might be the problem, but you gotta convert them all.

you might see if anything is in this table - duLCK - this is the one that locks the databases - if there is something in there IN THE PAST I have been able to delete that record - then go back into the install and it picks up where it left off. This has helpped us in the past

this script will show you if one of the companies failed

SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID FROM DYNAMICS.dbo.DU000030 a JOIN DYNAMICS.dbo.DU000010 b ON a.fileNumber = b.fileNumber JOIN DYNAMICS.dbo.SY01500 c ON a.companyID = c.CMPANYID WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15

Personally - I would have called my partner when the problem started since they can bend MS's ear a bit to get you to help - I know we took SP2 a long time ago, so I am working from memory a bit - SP4 took longer it seems

sorry I am not more help.

 

[GPUser05]

Thanks Jymm for your reply. I had looked at DB_Upgrade table but did not see anything. We had called MS and the Tech person asked to reapply the service pack that we had already tried three times.

The issue was that patch was not updating the Dynamics.dic file. We copied the file from client install to server code folder and it worked.

Thanks for the script.