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 , 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.