Symptom
In Deletion Phase of archiving request, the Job BI_ARCH-* fails during selective deletion (Background execution):
Warning:
cannot get new name for shadow table
Message no. RSDRD001
Errors:
Deletion of data recs using Insert/Select &--> terminated with errors
Message no. RSDRD113
Package deletion of data records from table & terminated with errors
Message no. RSDRD114
Error deleting data from InfoProvider & in deletion mode 'C'
Message no. RSDA229
Exception occurred in line 331 of include CL_RSDA_DAP_REQUEST_COLLECTIONCM00A (program CL_RSDA_DAP_REQUEST_COLLECTIONCP)
Message no. RSDA140
The following dump happens during selective deletion:
"RAISE_EXCEPTION"
"SAPLRSDRD" bzw. LRSDRDU09
"RSDRD_SEL_DELETION"
"Dequeue only if necessary
IF ( l_no_enqueue = rs_c_false AND l_enq_lockid IS NOT INITIAL ).
"dequeue according to lockmatrix
CALL FUNCTION 'RSENQ_DEQUEUE'
EXPORTING
i_lockid = l_enq_lockid
CHANGING
c_t_msg = c_t_msg
EXCEPTIONS
no_lock_found = 0
OTHERS = 0.
ENDIF.
"Raise old exception
>>> RAISE x_message.
FUNCTION SAPLRSDRD LRSDRDU09 503
RSDRD_SEL_DELETION
This is the function that checks the existence of shadow table according to related InfoProvider:
CALL FUNCTION 'DB_EXISTS_TABLE'
EXPORTING
tabname = r_shd_tablnm
IMPORTING
subrc = l_rc.
IF l_rc = 0.
if_rsdrd_seldel_tab~p_r_log->append_message(
i_msgty = 'W'
i_msgv1 = 'cannot get new name for shadow table' ).
RAISE EXCEPTION TYPE cx_rs_program_error
EXPORTING
method ='CREATE_SHD_TABLE:RSDDTMPTAB_GET_NEW_NAME'.
ENDIF.
This is the Call Stack in runtime:
METHOD CREATE_SHD_TABLE CL_RSDRD_SELDEL_PACK==========CP
METHOD INSERT_SELECT_INV CL_RSDRD_SELDEL_PACK==========CP
METHOD IF_RSDRD_SELDEL_TAB~EXECUTE CL_RSDRD_SELDEL_PACK==========CP
METHOD DELETE_FROM_FFACT CL_RSDRD_SELDEL_IC============CP
METHOD DELETE_FROM_CUBE CL_RSDRD_SELDEL_IC============CP
FORM DELETE_INFOCUBE_WITH_AGGR_NEW SAPLRSDRD
FUNCTION RSDRD_SEL_DELETION SAPLRSDRD
Read more...
Environment
- SAP NetWeaver 7.0
- SAP NetWeaver 7.3
- SAP NetWeaver 7.4
- SAP enhancement package 1 for SAP NetWeaver 7.0
- SAP enhancement package 2 for SAP NetWeaver 7.0
- SAP enhancement package 1 for SAP NetWeaver 7.3
Product
Keywords
Archiving, deletion phase, delete phase, shadow table, selective deletion, Business Warehouse, BW, 7.0, 7.01, 7.02, 7.3, 7.31, 7.4, RSDRD, 001, 113, 114, RSDA, 229, 140, RSDA229, RSDA140, RSDRD113, RSDRD114, RSDRD001, LRSDRDU09, RSDRD_SEL_DELETION, CREATE_SHD_TABLE, DB_EXISTS_TABLE, SAPLRSDRD , KBA , BW-WHM-DST-ARC , Archiving , BW-WHM-DBA-SDEL , Selective deletion , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.