Good afternoon.
Dear Community, I have the following situation: I have imported the ca uim database (12c) from one server to another and pointed the ca uim application to the new server, the application seems to work normal except that the maintenance work fails and the next error.
Jun 17 00:40:02:271 [140247928108832] 0 de: getNextRunTime: new style time spec. nextRun: 1623994800
Jun 17 00:40:03:091 [140247484577536] 0 de: data_engine [Admin Classic] [Admin] - ExecuteSP [Admin] data_engine [Admin Classic] status: -1
OCI_ERROR - ORA-00001: unique constraint (CA_UIM.PKNLOGGING) violated
ORA-06512: at "CA_UIM.SPN__LOGEVENT", line 18
ORA-06512: at "CA_UIM.SPN__LOGEVENTATLEVEL", line 14
ORA-06512: at "CA_UIM.SPN_DE_DATAMAINT", line 77
ORA-00001: unique constraint (CA_UIM.PKNLOGGING) violated
ORA-06512: at "CA_UIM.SPN__LOGEVENT", line 18
ORA-06512: at "CA_UIM.SPN__LOGEVENTATLEVEL", line 14
ORA-06512: at "CA_UIM.SPN_DE_DATAMAINT", line 33
ORA-06512: at line 1
OCIEnv: 0x0x7f8dcc07d2e0 OCIAuthInfo: 0x0x7f8dcc013370 OCISvcCtx: 0x0x7f8dcc145da8
- Error: ExecuteSP [Admin] data_engine [Admin Classic] status: -1
OCI_ERROR - ORA-00001: unique constraint (CA_UIM.PKNLOGGING) violated
ORA-06512: at "CA_UIM.SPN__LOGEVENT", line 18
ORA-06512: at "CA_UIM.SPN__LOGEVENTATLEVEL", line 14
ORA-06512: at "CA_UIM.SPN_DE_DATAMAINT", line 77
ORA-00001: unique constraint (CA_UIM.PKNLOGGING) violated
ORA-06512: at "CA_UIM.SPN__LOGEVENT", line 18
ORA-06512: at "CA_UIM.SPN__LOGEVENTATLEVEL", line 14
ORA-06512: at "CA_UIM.SPN_DE_DATAMAINT", line 33
ORA-06512: at line 1
OCIEnv: 0x0x7f8dcc07d2e0 OCIAuthInfo: 0x0x7f8dcc013370 OCISvcCtx: 0x0x7f8dcc145da8
Jun 17 00:40:03:091 [140247484577536] 0 de: Data Maintenance - FAILED for Table: RN_QOS_DATA_0001 qos=QOS_POWER_STATE [ExecuteSP [Admin] data_engine [Admin Classic] status: -1
OCI_ERROR - ORA-00001: unique constraint (CA_UIM.PKNLOGGING) violated
ORA-06512: at "CA_UIM.SPN__LOGEVENT", line 18
ORA-06512: at "CA_UIM.SPN__LOGEVENTATLEVEL", line 14
ORA-06512: at "CA_UIM.SPN_DE_DATAMAINT", line 77
ORA-00001: unique constraint (CA_UIM.PKNLOGGING) violated
ORA-06512: at "CA_UIM.SPN__LOGEVENT", line 18
ORA-06512: at "CA_UIM.SPN__LOGEVENTATLEVEL", line 14
ORA-06512: at "CA_UIM.SPN_DE_DATAMAINT", line 33
ORA-06512: at line 1
I would appreciate your support, greetings