the screen shot below shows the error that comes up when trying to create a package. Please advise.
Release : 13.0.3
Component : CA Harvest Software Change Manager
We increased HServer logging level to 5 and reproduced the problem. When we checked the HServer log files we found this error message:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'harinfadg'.
We checked the database and found that table is missing. It's a table for a custom form type.
We ran this query to get a list of all the tables for the custom form types.
select distinct formtablename from harformtype
Found that all the other table names are related to the default form types that come with Harvest and they were all found in the database so only the one table is missing.
We restored the database from a backup and used HDBSetup to upgrade the schema to the new version of Harvest again. Problem is resolved.