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

Document ID : KB000087476
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
0EMb0000001Fal8.png

 
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