Issue with Upgrading GP10 to SP5-"Microsoft Dynamics GP Utilities Install/Upgrade failed"

(0) Share

Report

Posted on by Mohammed Ahmed

I'm working on upgrading our GP10 from Serivce Pack 2 to Service Pack 5 and I'm doing it on our test enviorment ..

The error message "Microsoft Dynamics GP Utilities Install/Upgrade failed" pops up in GP Utilities during Server Installation when updating Dynamics database.

According to DEXSQL logs the procudure possibly fails when updating table "dbo.taErrorCode " with the below error

SQLSTATE:(23000) Native Err:(2627) stmt(14349776):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PKtaErrorCode_T'. Cannot insert duplicate key in object 'dbo.taErrorCode_T'.*/

It's worth noting that we are using SQL server 2008 R2 and the SP5 installation is taking place in the server side , I have looked through the Dynamics KB but the only resolution I found was irrelevant to my case which was about DB compatibility with 2005 .

Please advise ..

Many Thanks

*This post is locked for comments

All responses (1)

Answers (0)

Jonathan Fear on at

Like (0)

Report

Re: Issue with Upgrading GP10 to SP5-"Microsoft Dynamics GP Utilities Install/Upgrade failed"

Typically this issue is because Utilities is having a problem with synching the two tables. Try renaming the taErrorCode_T table to toErrorCode including the primary keys on it.