ORA-06512 CA UIM

[Jose Romero]

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

[David Michel]

check the data_engine raw configure to see if you have table_maintenance_loglevel, if there set it to 0.

------------------------------
Support Engineer
Broadcom
------------------------------

[Jose Romero]

thanks for your answer, I have assigned the following permissions to the CA_UIM user And it seems to have fixed the problem:

Grant unlimited tablespace to CA_UIM;
grant administer database trigger to CA_UIM;
grant create table to CA_UIM;
grant create view to CA_UIM;
grant alter any table to CA_UIM;
grant select any table to CA_UIM;
grant create sequence to CA_UIM;
grant create procedure to CA_UIM;
grant create session to CA_UIM;
grant create trigger to CA_UIM;
grant create type to CA_UIM;
grant select on sys.v_$session to CA_UIM;
grant execute on sys.dbms_lob to CA_UIM;
grant execute on dbms_redefinition to CA_UIM;
grant create any table to CA_UIM;
grant drop any table to CA_UIM;
grant lock any table to CA_UIM;