Symptom
- Error message
Category Installation error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time
Short Text
SQL error "SQL code: 544" occurred while accessing table "/BIC/Bxxxxxxxxx1".
What happened?
Database error text: "SQL message: partition error: cannot determine partition
for each row with error: Error allocating rows to parts;Could not allocate
value '1' for column 'PARTNO' to a part of table
BWP::SAPABAP1:/BIC/Bxxxxxxxxx1en. The table has no OTHERS part. Create a n"
- Checking upon the partition specification for the table and it shows like:
PARTITION BY HASH ("REQUEST","DATAPAKID","RECORD")
PARTITIONS 1, RANGE ("PARTNO")
(PARTITION VALUE = '2') WITH PARAMETERS ('PARTNAMES'=('2'))
- The table does not have any record.
- You already checked the following notes but still face the problem:
2687073 - Could not allocate value XXX for column 'PARTNO' to a part of table/BIC/Bxxx during HANA optimized Request Activation Overall Rating
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...
Read more...
Environment
SAP HANA Database
Keywords
SQL error, SQL code: 544, Installation error, SAP BW 750, SAP HANA Database, Partition error, Reactivate data source, BW table. , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , BW-WHM-DBA-DSO , DataStore Object (classic) , 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.