ETL9.2: Online Validation Causing Deadlocks on TL_VALD_MAIN.ST000.STEP040 DO SELECTS TL_VALD_MAIN.ST000.STEP040 DO SELECT (Doc ID 2048064.1)

Last updated on OCTOBER 01, 2021

Applies to:

Symptoms

Users are reporting getting kicked out of the application repeatedly. They can come back into the system only to be kicked out again.

Online error occurs when Leave time is submitted and the validation of leave time is called. Error received by user:
A SQL error occurred. Please consult your system log for details.

Process a1000009153 ABENDED at Step TL_VALD_MAIN.ST000.Step040 (Do Select)

CallAppEngine: Application TL_CALL_VAL:AppEngine error. (2,653) FUNCLIB_TL_WEEK.APPLY_RULES.FieldFormula Name:RunValidation PCPC:7191 Statement:69
Called from TL_MSS_EE_SRCH_PRD.GBL.SavePostChange Statement:4

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.


System should not be kicking the end users out of the system or encountering deadlock errors when reporting time.

The issue can be reproduced at will with the following steps:
1.  Hundreds of end users reporting time and hitting submit or entering time using Webclock

2.  TL Installation table is using Online and Batch validation for Leave and Comptime

3.  Validation set being used is ST_ALL and both online and time admin checkboxes are all turned on

All of these issues are causing a flood of calls from the user community. Payable time is not being created for payroll purposes, and they are in production for the first time in 9.2 after upgrading from 9.0 release.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.