SAP Knowledge Base Article - Preview

2196780 - Access to PSA / PSA / Error stack maintenance screen takes long time or dumps .

Symptom

When we goto the PSA/Error stack maintainence screen and click on the records to view or access the records , the screen hangs for a long time.
Sometimes it also gives the below dump :

Category               Installation Errors
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB
Date and Time          08.07.2015 14:16:19

SQL error "SQL code: 131" occurred while accessing table "DDFTX".

 "DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB
 "SAPLSDIFRUNTIME" bzw. LSDIFRUNTIMEU05
 "DD_INT_DELETE_DDFTX"

>>>>>   DELETE FROM ddftx CONNECTION (gc_con_ddftx) WHERE tabname = iv_tabname.
    9   COMMIT CONNECTION (gc_con_ddftx).

SY-TITLE Requests for PSA /BIC/B00011000
SY-MSGTY E
SY-MSGID DA
SY-MSGNO 300
SY-MSGV1 STRU_00AXVT4SAPRZX7RYHZCZA4ZK1


Read more...

Environment

  • SAP NetWeaver Business Warehouse 7.00
  • SAP NetWeaver Business Warehouse 7.01
  • SAP NetWeaver Business Warehouse 7.02
  • SAP NetWeaver Business Warehouse 7.03
  • SAP NetWeaver Business Warehouse 7.30
  • SAP NetWeaver Business Warehouse 7.31
  • SAP NetWeaver Business Warehouse 7.40

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; 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 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

TABNAME,Last SQL statement,DELETE,LOCATION,SQL0911N,CL_RSAR_PSA_API,QUERY_DEGREE,SQL code: 131, SAPLSDTA,RZ11. , KBA , BW-WHM-DST-PSA , Persistent Staging Area , BW-WHM-DST-DTP , Data Transfer Process , BC-DWB-DIC , ABAP Dictionary and ABAP CDS , 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.