CNC Guy
Well Known Member
Folks,
We recently upgraded our toolset from 8.96 D1 to 8.98.2.0. We had an issue in 96 where when we turned on security history it started throwing errors in security kernels e.g. below.
We logged a case with oracle and were told this would be fixed in 8.98. After the upgrade we again enabled the same and we are still getting those errors as below.
Also what we noted in addtion to this is on our batch server where all the ube's are running we have more than 5000 log files. When we researched we found that for each entry in the Security Kernel for errors below and the associated PID there is a correponding log file created with the same name i.e. jde_PID.log with just one line in the log (API ipcSawUnregisterProcV1 : process 9400 unregistered in entry 14). Hence every time there is an entry in the Security Kernel in the log there are log files created and hence the no of log files is huge.
Due to this the SM console takes a long time to open the main ES page.
Any ideas/ suggestions guys?
Thanks,
CNC Guy
E1 8.11 SP1 (8.98.2.0), Unix Solaris, OAS
28839/1 MAIN_THREAD Sat Jan 9 12:10:13.138928 secutil.c523
Insert Failed for F9312: User (SCHED) Action (02) Machine (NZNSFN59) IPAddress (10.115.6.251) PID (9400-runbatch)
28839/1 MAIN_THREAD Sat Jan 9 12:10:14.637579 dbperfrq.c456
OCI0000178 - Unable to execute - INSERT INTO SY811.F9312 (SHUSER, SHEVTYP, SHEVSTAT, SHMKEY, SHUSR0, SHPID, SHJOBN, SHUPMJ, SHUPMT, SHDTOFF, SHTMOFF, SHCHGF, SHSECF1, SHSECF2, SHSECV3, SHSECV4) VALUES BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16)
28839/1 MAIN_THREAD Sat Jan 9 12:10:14.637705 dbperfrq.c462
OCI0000179 - Error - ORA-00001: unique constraint (SY811.F9312_PK) violated
28839/1 MAIN_THREAD Sat Jan 9 12:10:14.637755 jdb_drvm.c1116
JDB9900401 - Failed to execute db request
28839/1 MAIN_THREAD Sat Jan 9 12:10:14.637810 jdb_exet.c6144
JDB3400009 - Failed to perform Insert for F9312
We recently upgraded our toolset from 8.96 D1 to 8.98.2.0. We had an issue in 96 where when we turned on security history it started throwing errors in security kernels e.g. below.
We logged a case with oracle and were told this would be fixed in 8.98. After the upgrade we again enabled the same and we are still getting those errors as below.
Also what we noted in addtion to this is on our batch server where all the ube's are running we have more than 5000 log files. When we researched we found that for each entry in the Security Kernel for errors below and the associated PID there is a correponding log file created with the same name i.e. jde_PID.log with just one line in the log (API ipcSawUnregisterProcV1 : process 9400 unregistered in entry 14). Hence every time there is an entry in the Security Kernel in the log there are log files created and hence the no of log files is huge.
Due to this the SM console takes a long time to open the main ES page.
Any ideas/ suggestions guys?
Thanks,
CNC Guy
E1 8.11 SP1 (8.98.2.0), Unix Solaris, OAS
28839/1 MAIN_THREAD Sat Jan 9 12:10:13.138928 secutil.c523
Insert Failed for F9312: User (SCHED) Action (02) Machine (NZNSFN59) IPAddress (10.115.6.251) PID (9400-runbatch)
28839/1 MAIN_THREAD Sat Jan 9 12:10:14.637579 dbperfrq.c456
OCI0000178 - Unable to execute - INSERT INTO SY811.F9312 (SHUSER, SHEVTYP, SHEVSTAT, SHMKEY, SHUSR0, SHPID, SHJOBN, SHUPMJ, SHUPMT, SHDTOFF, SHTMOFF, SHCHGF, SHSECF1, SHSECF2, SHSECV3, SHSECV4) VALUES BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16)
28839/1 MAIN_THREAD Sat Jan 9 12:10:14.637705 dbperfrq.c462
OCI0000179 - Error - ORA-00001: unique constraint (SY811.F9312_PK) violated
28839/1 MAIN_THREAD Sat Jan 9 12:10:14.637755 jdb_drvm.c1116
JDB9900401 - Failed to execute db request
28839/1 MAIN_THREAD Sat Jan 9 12:10:14.637810 jdb_exet.c6144
JDB3400009 - Failed to perform Insert for F9312