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.
No comments:
Post a Comment