SAP Knowledge Base Article - Preview

2155151 - Archiving request in Deletion phase / Selective Deletion fails due existing shadow table

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

 

pic1KBA.png

 

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

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.