Unable to delete package after upgrade

Document ID : KB000008706
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:
Unable to delete a package if it has an attachment. When he tries to delete a package he is getting this error message:

E03020003: Database error [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'HARUSDDEPLOYINFO'
SQLSTATE=S0002
Environment:
CA Harvest SCM v13.xSQL Server database
Cause:

A certain database trigger in the Harvest database remained active after the last upgrade when it should have been deleted.

Resolution:

The solution to this problem is to delete a certain trigger in the Harvest database that is left-over from the previous version of Harvest and is obsolete.

In order to locate the trigger to be deleted, login to SQL Server Management Studio, navigate to the Harvest database, expand the list of tables, and locate the dbo.HARFORMATTACHMENT table. Click the “+” to expand the details of the HARFORMATTACHMENT table, and expand the “Triggers” folder to find a trigger named HARUSDDEPLOYINFO_ATTID_TRIGGER.  Right click on the name of the trigger and select “Delete”.

image001.jpg

On the “Delete Object” dialog click “OK” to confirm.

image002.jpg

Once the trigger has been deleted, you can stop and restart the SCM Broker.  After that you should be able to delete the package without any further trouble.

Additional Information:

As always, it is best to make a backup of your Harvest database before giving this a try.  Could you or your DBA follow these steps and let me know if this resolves the problem?