SAP Knowledge Base Article - Preview

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.


Read more...

Environment

  • Solution Manager 7.2 SP3-6
  • Oracle Database

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.