When selecting Deployment Targets, Workflows, or Components an error "No row with the given identifier exists" is displayed.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Affects Release version(s): 5;6;7;8

Error Message :
No row with the given identifier exists [Ventum.Bond2.DomainModels.DeploymentTargetTypeVersion#XXXXXXX]

When clicking on Deployment Targets, Workflows, and Components in ARA, errors such as "No row with the given identifier exists [Ventum.Bond2.DomainModels.DeploymentTargetTypeVersion#1148761]" occur.

<Please see attached file for image>

 

Environment

OS Version: N/A

Cause

Cause type:
Other
Root Cause: The error is caused by inconsistencies within the ARA's database while copying or importing/exporting data,
Exporting and Importing data using SQL Developer/DB Loader is not the best solution. Using expdp/impdp tools is much better in speed and data integrity

Resolution

Have the Database Administrator (DBA) check ARA's database against the tables:

* DEPLOYMENTTARGET 
* DEPTARGETTYPE 
* DEPTARGETTYPEVER 

Make sure each row in DEPLOYMENTTARGET table references to existing rows in 

* DEPTARGETTYPE (via TYPEID column) 
* DEPTARGETTYPEVER (via TYPEVERID column)

If there are not the same number of TYPEVERID objects in the table DeploymentTarget as in the table DepTargetTypeVer then data is missing from the database and a database restore may be necessary by a database administrator.

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
N/A