Tools 8.98.2.0 (Security History)

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

Hi,
I read in an Oracle post that with 8.98.2 they did a change which allowed the security kernel to manage the login time in mili seconds better.

Did you use server manager to enable security history or made the change directly in the JDE.INI. I made a mistake once of directly updating the JDE.INI with History=True instead of History=1

Yep that's what we thought as well but it din't. Also we changed using SM only and the Value is indeed 1 and not True.

Also we have not seen this large no of log files being reported anywhere. Aren't they related?

Thanks,
CNC Guy

According to solution id 826081.1 this is fixed with 8.98.1.2. So with your tools release the fix should have been included. Were there any special instructions to be followed. I have worked with 8.98.1.1 where it is still an issue.

I forwarded your post onto our CNC Administrator for him to check impact here, if any. We too also just completed upgrade to 8.98.2 and must say so far we are TOTALLY PLEASED with the improvements to integrity, transaction completion, kernel processing, and speed.

On which Tools Release were you before upgrading to 8.98.2 Terry?

Tools Release 5