Issue with Range Partition (/B**/FKO**)

[SAPSupport]

Dear SAP Team,

We have recently received an alert for the table SAPB***./B**/FKO** , specifically Partition 4, in our BPC Production system (***). Upon investigation, we found that the Range partition was executed on the key "KEY_KOII***" with the following ranges: 0, 1, 2, and others (*). However, only data for range 0 is present while ranges 1 and 2 are missing.

Table Name: /B**/FKO**

It seems that the data has been recorded under partition ID 4 (i.e., *). Looks like the partitioning was not performed correctly (in DIGITS), and the ranges were not properly assigned during the process.

Could you please provide a solution to resolve this partitioning issue? Is there an alternative solution that can be performed online without requiring an outage? Please let us know if you need any additional information. I've attached screenshots of the table for reference.

Thanks,
***

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[tanuj_gupta]

Hi

Sub-partition 1 and Sub-partition 4 in InfoCube refers to Compressed requests and UnCompressed requests.

Infocubes are partitioned ROUDROBIN as first level and Range as second level based on package ID and you can not change it.

So two possible solutions;

1. Compress your Infocube so that uncompress data will move from Sub-partition 4 and Sub-partition 1 to allow more room for data in Sub-partition 4

OR

2, Perform partitoning at DB level to change first level ROUNDROBIN partitions based on your table placement setting. See SAP Note 2069235 - How to Change the Initial Number of First-level Partitions for BW generated Tables in SAP HANA.

Regards

Tanuj