2591386 - CCM - Dump with error: ORA-14400: inserted partition key does not map to any partition

Symptom

Solution Manager system produces the following dump:

Category                  Installation Errors
Runtime Errors         DBSQL_SQL_ERROR
Except.                    CX_SY_OPEN_SQL_DB

Short Text
      SQL error "SQL code: 0" occurred while accessing table "/BI0/F0SM_CCREF".

What happened?
Database error text: "SQL message: ORA-14400: inserted partition key does not map to any partition"

Error analysis
      An exception has occurred which is explained in more detail below. The
     exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in
      procedure
     "WRITE_ICFACT" "(FORM)", nor was it propagated by a RAISING clause.
     Since the caller of the procedure could not have anticipated this
     exception, the current program was terminated.
     The reason for the exception is:
     Database error text: SQL message: ORA-14400: inserted partition key does not
      map to any partition
     Return value of the database layer: "SQL dbsl rc: 99"

Information on where terminated
    The termination occurred in ABAP program "GP33D5WD27E65E103CWOGDN2XFV", in
     "WRITE_ICFACT". The main program
    was "SAPMSSY1".

    In the source code, the termination point is in line 4565 of (Include)
    program "GP33D5WD27E65E103CWOGDN2XFV".
    The termination is due to exception "CX_SY_OPEN_SQL_DB" occurring in procedure
    "WRITE_ICFACT" "(FORM)".
    This exception was not handled locally or declared in the RAISING
    clause in the procedure's signature however.
    The procedure is in program "GP33D5WD27E65E103CWOGDN2XFV". The source code
     begins in line 4530 of
    (include) program "GP33D5WD27E65E103CWOGDN2XFV".

    4564
    >>>>> INSERT (l_facttab) FROM TABLE g_t_u.
    4566
    4567      c_lines = sy-dbcnt.

Environment

Solution Manager 7.2 SP3-6
Oracle Database

Reproducing the Issue

Access T-code ST22
Runtime Error "DBSQL_SQL_ERROR" is found

Cause

Issue is caused due to errors and inconsistency related to the database

Resolution

In Solution Manager system, run transaction RSRV
Select following tests in Database folder:

Database Indexes of an InfoCube and its aggregates
Database statistics of an InfoCube and its aggregates
Database information about InfoProvider tables
Database parameters of * schema tables for InfoCube
Data row compression of InfoProviders in DB2 for….
Data row compression of PSA database tables in ….

**Note - The target InfoCube for all above tests would be 0SM_CCREF

Click on Execute button:
When the tests are executed, select/highlight (one by one) the test with errors
For each test with an error, click on "Correct Error" button:
When the errors are corrected the dump should no longer occur.

Keywords

/BI0/F0SM_CCREF, DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, ORA-14400, st22, BW objects, partition key, 7.2, CCM, custom code, CCM, CCREF , KBA , SV-SMG-CCM , Custom Code Management , Problem

Product

SAP Business ByDesign all versions