2195051 - Insert into PSA dumps with SQL error 2048

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

• 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

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

INSERT_ODS, FROM TABLE  l_t_data, ACCEPTING DUPLICATE KEYS, InfoPackage, DTP , KBA , BW-WHM-DST-DS , DataSource , BW-WHM-DBA-DSO , DataStore Object (classic) , BW-WHM-DST-PSA , Persistent Staging Area , BW-WHM-DST-TRS , Transfer and Communication Structure , Problem