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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.