Error when trying to delete a package Invalid object name 'HARUSDDEPLOYINFO'

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

How to fix this error obtained when deleting a Harvest Package, E03020003: Database error [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'HARUSDDEPLOYINFO' SQLSTATE=S0002

Environment

Release : 13.0.3 and above

Component : CA Harvest Software Change Manager

Resolution

Backup of your Harvest database before following below steps:

1) 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.
2) 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.
3) Click the “+” to expand the details of the HARFORMATTACHMENT table, and expand the “Triggers” folder to find a trigger named HARUSDDEPLOYINFO_ATTID_TRIGGER.
4) Right click on the name of the trigger and select “Delete”. On the “Delete Object” dialog click “OK” to confirm.  (Disabling the trigger is also an option, rather than fully deleting it)
5) Once the trigger has been deleted, you can stop and restart the SCM Broker.

You should be able to delete the package without any further trouble now.