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

book

Article ID: 87476

calendar_today

Updated On:

Products

CA Continuous Delivery 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>

0EMb0000001Fal8.png

 

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

Environment

OS Version: N/A

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

Attachments

1558693243143000087476_sktwi1f5rjvs16m44.png get_app