Saturday, February 2, 2019

PeopleSoft Time Admin Process Error : Dropped 1 Time Reporters found in other concurrent runs

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:

  1. PROCESS_INSTANCE
  2. RUN_CNTL_ID
  3. 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