When selecting Deployment Targets, Workflows, or Components an error "No row with the given identifier exists" is displayed.
Article ID: 87476
CA Automic Workload Automation - Automation Engine
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>
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
OS Version: N/A
Have the Database Administrator (DBA) check ARA's database against the tables:
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.