When attempting to create a new Configuration Item (CI), the CI does not get created. A search for the CI gives no match; it cannot be found.
ERROR messages are written to the stdlog during the attempt to create the CI. One error message indicates that the trigger named "CA_TR_INS_OWN_RESOURCE_B4" is invalid and failed to re-compile/re-validate. The trigger must run successfully before a new CI can be inserted into the mdb database.
A sample of the ERROR messages is:
sqlagt:upinde 6204 ERROR orclclass.c 1302 SQL Statement Failed. ORA: 4098 Message: ORA-04098: el disparador 'MDBADMIN.CA_TR_INS_OWN_RESOURCE_B4' no es válido y ha fallado al revalidar
sqlagt:upinde 6204 ERROR orclclass.c 1303 Clause (INSERT INTO ca_owned_resource ...
Even if you attempt to recompile the trigger using the following SQL command, the problem may not be resolved:
ALTER TRIGGER MDBADMIN.CA_TR_INS_OWN_RESOURCE_B4 COMPILE