SAP Knowledge Base Article - Preview

3467473 - Unable to delete unused SID table data with program RSDMDD_DELETE_BATCH

Symptom

RSDMDD_DELETE_BATCH report not deleting unused SIDs.

Job log will show the following warning:

Not all master data could be deleted RSDMD 128

Also, the following dump may happen:

Category               Installation error
Runtime Errors         DBSQL_SQL_ERROR   
Except.                CX_SY_OPEN_SQL_DB

Short Text: SQL error "SQL code: 2055" occurred while accessing table "/BI0/XXXXXXXXXX".

Database error text: "SQL message: maximum number of rows per table or partition reached: 'SCHEMA:/BI0/XXXXXXXXXX'"

"DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB                                                           
"CL_RSMD_USAGE_CHECK===========CP" bzw. CL_RSMD_USAGE_CHECK===========CM00V                   
"_UPDATE_TEMP_TAB"


Read more...

Environment

  • SAP Netweaver
  • SAP BW/4 HANA

Product

SAP BW/4HANA all versions ; SAP NetWeaver all versions

Keywords

SID, unused, RSDMDD_DELETE_BATCH_PACKAGE, RSDMD 128, RSDMDD_DELETE_BATCH, delete, master data, package size, MESSAGE_TYPE_X, SAPLARCJ, JOB_INIT , KBA , BW4-DM-MD , Masterdata , BW-WHM-DBA-MD , Master Data , 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.