GP 2013 Error when applying service pack 'Cannot drop the index taErrorCode.Ak2taErrorCode because it does not exist or you do not have permission

(0) Share

Report

Posted on by Rennecia Barran

Hello,

I am trying to upgrade GP2013R2 to GP2018R2. I know I have to get to a version of GP 2013 version number of 12.00.1826 or higher before i can upgrade to 2016 then to 2018R2.

I am applying a service pack to increase the version to 12.00.1826 but i get this error regardless of the 2013 service pack I apply. I also get it when i try to get to 12.00.2230:

Anyone know how to fix?

ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the index 'taErrorCode.AK2taErrorCode', because it does not exist or you do not have permission. dynamics gp upgrade.

I do not have taErrorCode.Ak2taErrorCode Index in Dynamics, i have taErrorCode.Ak1taErrorCode index though.

I get the error when running utilities. I am signed in as sa and the table exists in SQL.

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Rennecia Barran on at

Like (0)

Report

RE: GP 2013 Error when applying service pack 'Cannot drop the index taErrorCode.Ak2taErrorCode because it does not exist or you do not have permission

Ok so I fixed it! Yay me! I scripted the index 2 and the constraint from my 2015 machine into the 2013 and the upgrade is in progress!