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.

[SAPSupport · Accepted solution]

The issue you are encounterring that is a typical problem, what you need to do for handling this situation is following this note:

- note
2019973 - Handling Very Large Data Volumes in SAP BW on SAP HANA
2374652 - Handling Very Large Data Volumes in SAP BW/4HANA
-> Handling Large Data Volumes - 2 Billion Limit Value Reached

You need apply script TABLE_PLACEMENT.zip and perform reorg after that.