Create Package error
Article ID: 199427
Updated On:
Products
Issue/Introduction
the screen shot below shows the error that comes up when trying to create a package. Please advise.
Environment
Release : 13.0.3
Component : CA Harvest Software Change Manager
Cause
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'.
SQLSTATE-S0002
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.
Resolution
We restored the database from a backup and used HDBSetup to upgrade the schema to the new version of Harvest again. Problem is resolved.
Attachments
Feedback
