SAP Knowledge Base Article - Preview

3396481 - SQL error "SQL code: 544" occurred while accessing table "/BIC/Bxxxxxxxxxx"

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