2753417 - BW Data Load fails for PSA table with error "SQL code: 2048" occurred while accessing table "/BIC/xxxxxxxxxxx" ...The table has no OTHERS part...

Symptom

BW Data load fails with the below error and dump in transaction ST22 when updating BW PSA table:

Short Text
SQL error "SQL code: 2048" occurred while accessing table "/BIC/xxxxxxxxxxx".

What happened?
Database error text: "SQL message: column store error: TrexUpdate failed on table 'SCHEMA:/BIC/xxxxxxxxxxx'
with error: Error allocating rows to parts;Could not allocate value '0' for column 'PARTNO' to a part of table
'SCHEMA:/BIC/xxxxxxxxxxx'en. The table has no OTHERS part...

Incident 560168 2018 SQL error SQL code 2048 occurred while accessing table BI

Environment

SAP HANA Database

SAP NetWeaver

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0 ; SAP NetWeaver all versions

Keywords

partitioned; partition; partitioning; REPORT RSDU_TABLE_CONSISTENCY; RSAR_PSA_CLEANUP_DIRECTORY; Create a new partition for the value; DBSQL_SQL_ERROR; CX_SY_OPEN_SQL_DB , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , HAN-DB , SAP HANA Database , 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.