1. Try Goto RSA1 -> PSA, find the PSA, then delete the error request from there
  2. Goto RSRV, drag in the ‘foreign key ..’ and ‘check status…’ tests to the right, then put in the ODS name, and run
  3. ST22, see if there is any relevant error
  4. SM37, job name you put “BI_DEL*” basically try to find the deletion job that failed see if u can find it
  5. Solution: a) Goto table RSODSACTREQ

b) Put the request number in the request ID

Eg: “REQU_ALZLI4CPDLXMINAQ7397WLNWC”

c) Delete that record, check the record, then ‘table entry’ -> ‘delete’

d) Goto table RSODSACTUPDTYPE, deletes all the entries which have the same request number

e) After deleted go to SE37,

RSDRO_SETSTATUS_FOR_REQUEST_20

I_ODSOBJECT put your ODS name

I_ACTREQUEST put your ODS request name

Eg:“ODSR_0V86SZU38DNXULICERI5A6CJ7”