There are some specific scenarios where we need to delete entries from partition tables starting with /BIC/B* without which it does not allow deleting data from tables like PSA table, change log table etc.
While deleting data from PSA or change log table either manually or through process chain.
When we go and check “Display log” for the deletion, it will give error saying that “Data inconsistency; Partition /BIC/B* not deleted” (different loads has different partition tables).
This error is basically due to system fails to delete the entries from partition table /BIC/B*, which is specified in error message.
Steps for Correction:
Specify partition table name (/BIC/B* mentioned in error message) in I_TABLNM input parameter and execute it. The data entries can be seen that are still present in the partition table.
Execute this program again in Repair mode by setting I_REPAIR to delete data entries. After that, it will allow deleting DSO request or data in the PSA or Change log table.
This check report is used to deduct the possible problems of indices and other database related issues of the PSA. This report helps in deducting the following inconsistencies:
- Partitioning with global index
- Inconsistencies between DDIC definition and DB tables
- PSA definition without DDIC entry and vice-versa.
This report is available only for release 7.x.
The following symptoms can be noticed during the activation of DTP, DSO and Data-sources. They may also occur during the write or activation of the data:
ORA-01502: index ‘SAPDAT. /BIC/A*KE’ or partition of such index is in unusable state.
ORA-20000: index “SAPGBP”.” /BIC/B*KE” or partition of such index is in unusable state.
Run the report in check mode first and then execute the report in repair mode by setting i_repair = ‘X’. Refer the note 1012607 and 1558849 for more details.