Forcing the creation of new partitions for BSI tables

Products

• CA Business Service Insight

Issue/Introduction

With data partitions configured, most commonly on T_RAW_DATA, you may wish to manually force the generation of fresh partitions. This could be because there was a problem previously with their generation and you are receiving the Oracle error when trying to store adapter data:

ORA-14400: inserted partition key does not map to any partition

Environment

CA Business Service Insight 8.3.5.x

Resolution

The partition tools are stored in the Database package 'PART_MNG_PKG'. This package should have been compiled during creation in Oracle - if it is invalid, then recompile it.

It contains a number of tools for working with database partitions and picks up its information on partition configuration within BSI from the table T_PART_MNG_PARAMS - the rows within it will describe how your partitions and purge settings are defined out of the box.

To perform the cleanup procedure, you can run the following SQL:

BEGIN
PART_MNG_PKG.RUN_PROCESS();
END;

Additional Information

The Part_Mng_Pkg.sql can be found under the BSI install media if you need to recreate it from scratch:

SetupDB\InstallDB\Build_Schema\Packages