ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Create Package error

book

Article ID: 199427

calendar_today

Updated On:

Products

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

Issue/Introduction

the screen shot below shows the error that comes up when trying to create a package. Please advise.

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.

Environment

Release : 13.0.3

Component : CA Harvest Software Change Manager

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