Insertion failed with error Error during insert of cmdb_ci_db_ora_instance

[Adiseshu Borra]

Hi All,

i am getting below issue in service mapping.

 An un-categorized system error has occurred: Identification Engine errors: See identification logs  for more info. Insertion failed with error Insertion failed with error Error during insert of cmdb_ci_db_ora_instance (******instance name ).

i checked the identification logs. it saying  "Insertion failed with error Error during insert of cmdb_ci_db_ora_instance "

i removed matching records. still no use.

 thanks in advance.

[richardbrounste · Accepted solution]

When there is an identification error like this, their is usually required attributes missing in the payload.  You need to get the identification payload from the error message and try it with the identification simulator (Configuration -> Identification Simulation).  It will reproduce the error and you can see where in the payload that it is failing.  cmdb_ci_db_ora_instance depends on some hardware to be inserted successfully (cmdb_ci_hardware or cmdb_ci_computer or Windows/Linux/Unix server) You probably have some required attribute values missing or possibly something is wrong with the payload.

[Adiseshu Borra]

Hi Richard,

Thanks for the inputs.

i tested with identification simulation with payload. i am getting below message in logs.

Info : identification_engine : identifyCI: Matched 3 records and 2 relations in 72msec

i think identification rules on the table cmdb_ci_db_ora_instance are not working. Because, it allowing duplicate records.