Recently we got this error while running the time admin process TL_TIMEADMIN. The error text read as:
Dropped 1 Time Reporters found in other concurrent runs. (13507,9)
We did the RCA and discovered that the table TL_TR_STATUS contains the data that suggests the employee in question is being processed through another run control id. Following fields in the table contained values:
We had to clear these three fields and also update the Earliest Change Date (EARLIEST_CHDT) back to the last reporting date. But instead of doing it through UPDATE SQL, we first deleted the row and then did an INSERT.
Example:
DELETE FROM PS_TL_TR_STATUS WHERE EMPLID = 'KU0045';
INSERT
INTO PS_TL_TR_STATUS
(
emplid,
empl_rcd,
ta_status,
earliest_chgdt,
prcs_thru_dt,
lastupddttm,
last_prcs_dttm,
process_instance,
oprid,
run_cntl_id
)
VALUES
(
'KU0045',
0,
'Y',
TO_DATE('2017-06-24','YYYY-MM-DD'),
TO_DATE('2017-06-24','YYYY-MM-DD'),
TO_TIMESTAMP('2017-06-24-12.50.57.000000','YYYY-MM-DD-HH24.MI.SS.FF'),
TO_TIMESTAMP('2017-06-24-12.50.57.000000','YYYY-MM-DD-HH24.MI.SS.FF'),
'0',
' ',
' '
) ;
Additionally, we also deleted run control data from below three tables:
DELETE FROM PS_TL_TA_RUNCTL WHERE OPRID = 'PS';
DELETE FROM PS_TL_RUN_CTRL_GRP WHERE OPRID = 'PS' AND EMPLID = 'KU0045';
DELETE FROM PS_PRCSRUNCNTL WHERE OPRID = 'PS';
After doing the above three steps we ran the time admin again and it went to success and the error was also gone.
Dropped 1 Time Reporters found in other concurrent runs. (13507,9)
We did the RCA and discovered that the table TL_TR_STATUS contains the data that suggests the employee in question is being processed through another run control id. Following fields in the table contained values:
- PROCESS_INSTANCE
- RUN_CNTL_ID
- OPRID
We had to clear these three fields and also update the Earliest Change Date (EARLIEST_CHDT) back to the last reporting date. But instead of doing it through UPDATE SQL, we first deleted the row and then did an INSERT.
Example:
DELETE FROM PS_TL_TR_STATUS WHERE EMPLID = 'KU0045';
INSERT
INTO PS_TL_TR_STATUS
(
emplid,
empl_rcd,
ta_status,
earliest_chgdt,
prcs_thru_dt,
lastupddttm,
last_prcs_dttm,
process_instance,
oprid,
run_cntl_id
)
VALUES
(
'KU0045',
0,
'Y',
TO_DATE('2017-06-24','YYYY-MM-DD'),
TO_DATE('2017-06-24','YYYY-MM-DD'),
TO_TIMESTAMP('2017-06-24-12.50.57.000000','YYYY-MM-DD-HH24.MI.SS.FF'),
TO_TIMESTAMP('2017-06-24-12.50.57.000000','YYYY-MM-DD-HH24.MI.SS.FF'),
'0',
' ',
' '
) ;
Additionally, we also deleted run control data from below three tables:
DELETE FROM PS_TL_TA_RUNCTL WHERE OPRID = 'PS';
DELETE FROM PS_TL_RUN_CTRL_GRP WHERE OPRID = 'PS' AND EMPLID = 'KU0045';
DELETE FROM PS_PRCSRUNCNTL WHERE OPRID = 'PS';
After doing the above three steps we ran the time admin again and it went to success and the error was also gone.
No comments:
Post a Comment