Wednesday, 23 December 2015

Error after installing 'Date Effective Tax Rates' module in GP versions 2010 or 2013.

In an attempt to add the feature 'Date Effective Tax Rates' on an existing GP Client you receive errors in launching GP Utilities stating there was a problem ascertaining the version.

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

Launch Utilities on a machine that has the Date Effective Tax Rates module installed and let it run through the installation.

This will resolve the error, you can run the initial select statement to confirm the version number updated.

No comments:

Post a Comment