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

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

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