3569517 - DBSQL_SQL_INTERNAL_DB_ERROR dump in QUERY_XREF_TARGET_VIEW_NO_REQ method from CL_RSPM_PERSISTENCY_STANDARD

The following dump can happen while opening an ADSO in RSMNG transaction or during a process chain execution:

Category               External Error
Runtime Errors      DBSQL_SQL_INTERNAL_DB_ERROR
Except.                 CX_SY_OPEN_SQL_DB

Short Text
    SQL error "SQL code: 4" occurred while accessing table "RSPMXREF".

"DBSQL_SQL_INTERNAL_DB_ERROR" CX_SY_OPEN_SQL_DB                                               
"CL_RSPM_PERSISTENCY_STANDARD==CP" bzw. CL_RSPM_PERSISTENCY_STANDARD==CM01B                  
"IF_RSPM_QUERY_RETRIEVE~QUERY_XREF_TARGET_VIEW_NO_REQ" 

Also, by collecting a ST12 trace for the respective process, it shows the worst SQL similar to:

SELECT DISTINCT <AGGREGATE> <JOIN> WHERE "P" . "PROCESS_TYPE" = ? AND "P" . "PROCESS_ID" = ? AND "X" . "REQUEST_TSN" <> N'000000
Tables: RSPMXREF, RSPMREQUEST, RSPMPRO
Class: CL_RSPM_PERSISTENCY_STANDARD==CM018

• SAP NetWeaver BW;
• SAP BW/4HANA.

RSMNG, CL_RSPM_PERSISTENCY_STANDARD==CP, IF_RSPM_QUERY_RETRIEVE~QUERY_XREF_TARGET_VIEW_NO_REQ, RSPMXREF, RSPM_DELETE_UNNEEDED_XREF  , KBA , BW4-DM-RSPM , Request Status and Process Management , BW-WHM-DST-RSPM , BW Request Status and Process Management , Problem