Step A. Stabilize the job scheduler.
1. Set all jobs that are WAITING to PAUSED;
2. Set all jobs that are SCHEDULED to PAUSED;
3. Make note of the PROCESSING jobs and its scheduled times as they will need to be re-entered later.
4. Set all jobs that are in PROCESSING to CANCELLED.
5. Delete all CANCELLED job instances.
Step B. Stop all BG services.
Step C. Have DBA team delete and regenerate the slice data on the table.
1. Review the BG logs to obtain the table name.
2. Run the following queries to validate the slice id and table name.
a. select id, request_name, table_name from PRJ_BLB_SLICEREQUESTS where table_name = '[TABLE_IN_BG_LOG]'
Check how many records needs to be deleted, in order to regenerate the data.
NOTE: Actual data will be regenerated, therefore no data is being deleted.
select slice_request_id, count(*) from
where slice_request_id in
group by slice_request_id
delete from [TABLE_NAME]
where slice_request_id in (x);
d. Reset the dates to force a reslice
set expiration_date = null,
request_completed_date = null
where id in
Step D. Restart all BG services.
Step E. Run an immediate instance of the Time Slicing job to check if the same error occurs.
If the same error occurs, please contact the Support team for further assistance.