When you launch GP you get the below error message but still can access the application.
ERROR: The EXECUTE permission was denied on the object 'zDP_DET00001', database 'COMPANYNAME', schema 'dbo'
To use my resolution below confirm the version that was installed by going into SQL and run the below select statement:
Select * from DYNAMICS.DB_Upgrade where PRODID='6831'
If this returns an older version, use the resolution below.
RESOLUTION:
- N.B. Make
sure to have full backups of all of your databases before performing these
steps.
--Run
the following scripts against the DYNAMICS database
DELETE
DYNAMICS..DB_Upgrade WHERE PRODID=6831
DELETE
DYNAMICS..DU000030 WHERE PRODID=6831
DELETE
DYNAMICS..DU000020 WHERE PRODID=6831
--Run
the following scripts against EVERY company database
DROP
TABLE DET00001
This will resolve the error, you can run the initial select statement to confirm the version number updated.