This is a short post about
how to find out a data deletion related logs in SAP BW. Mostly details about
data deletion operations that happened can be revealed by t-code SLG1.
SLG1 ->provide following input on its selection
screen:
Object: *
SubObject: *
External ID: value1: CHECK_DM
Value2: MON:PROTOCOLL_ACTION
value3: *DELETE_FROM_PSA
value4: ERRORSTACK_REQUEST_*
value5: *-DELET-*
value6: *req_no*
1/
CHECK_DMRX…:
FB RSM1_CHECK_DM_GOT_REQUEST called from PRG LRSM1F08;
row 004240
Request '
1259141'; DTA 'RX…'; action 'D'; with dialog 'X'
Leave RSM1_CHECK_DM_GOT_REQUEST in row 70; Req_State ''
2/
MON:PROTOCOLL_ACTION
Request ID 1259141 from data target RX… scheduled
for deletion
3/
DTPR_7TQYDLHVH8KTJ5A6QDBVV2F3Q-DELETE_FROM_PSA
Request DTPR_7TQYDLHVH8KTJ5A6QDBVV2F3Q deleted from
PSA; RSREQICODS entry also deleted
Request DTPR_7TQYDLHVH8KTJ5A6QDBVV2F3Q not found in IC RX…;
RSREQICODS also deleted
4/
ERRORSTACK_REQUEST_1259141
MON:PROTOCOLL_ACTION-DELET-RX…
Delete is running: Data target RX…, from 1259141 to
1259141
P-DIMID 156 deleted from table /BIC/DRX… (InfoCube RX…)
P-dimension index read; number of records: '26'
Number of request entries to be deleted: '1'
'1' records indexed
Prepare optimize and commit optimize executed
Request with P-DIMID 1259141 from InfoCube RX…deleted
(27000242 data records)
Delete was successful: Data target RX…, from 1259141 to
1259141
Delete is finished: Data target RX…, from 1259141 to
1259141
5/
DTPR_7TQYDLHVH8KTJ5A6QDBVV2F3Q-DELET-RX…
Delete is running: Data target RX…, from 1259141 to
1259141
P-DIMID 156 deleted from table /BIC/DRX… (InfoCube RX…)
P-dimension index read; number of records: '26'
Number of request entries to be deleted: '1'
'1' records indexed
Prepare optimize and commit optimize executed
Request with P-DIMID 1259141 from InfoCube RX… deleted
(27000242 data records)
Delete was successful: Data target RX…, from 1259141 to
1259141
Delete is finished: Data target RX…, from 1259141 to
1259141
6/
*req_no*
No comments:
Post a Comment