SAP Knowledge Base Article - Preview

2195051 - Insert into PSA dumps with SQL error 2048

Symptom

An insert into a PSA table dumps with the following or a very similar dump:

Category ABAP Server Resource Shortage
Runtime Errors DBIF_RSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB

SQL error 2048 while accessing table "/BIC/B0004859000".

Database error text: "column store error: TrexUpdate failed on table 'SAPX06:/BIC/B0004859000' with error: Error allocating rows to parts;Could not determine parts for multi-level partitioning., rc=2592"

(Please note that the PSA table name /BIC/B0004859000 is just an example, it is probably different in your particular case and has a pattern of /BIC/B*.)


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

Keywords

INSERT_ODS, FROM TABLE  l_t_data, ACCEPTING DUPLICATE KEYS, InfoPackage, DTP , KBA , BW-WHM-DST-DS , DataSource , BW-WHM-DBA-ODS , DataStore Object (classic) , BW-WHM-DST-TRS , Transfer and Communication Structure , BW-WHM-DST-PSA , Persistent Staging Area , 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.