SAP Knowledge Base Article - Preview

2541018 - Runtime error "DBIF_RSQL_SQL_ERROR with Except CX_SY_OPEN_SQL_DB" in the DVM size extractor


The DVM Size extractor fails in the dataloader phase with error:

SQL error SQL code: 0 occurred while accessing table /BI0/F0SM_SIZES
Query Execution Error: Invalid input. Check infoprovider and query specification.

The following ST22 dump is produced:

Category               Installation Errors                                                         
Runtime Errors         DBIF_RSQL_SQL_ERROR                                                         
Except.                CX_SY_OPEN_SQL_DB                                                            
Short text                                                                                        
    SQL error 14400 when accessing table "/BI0/F0SM_SIZES".

What happened?                                                                                    
    Error Text of the Database: "ORA-14400: inserted partition key does not map to                
     any partition"                                                                                                               
Error analysis                                                                                    
    An exception occurred that is explained in detail below.                                      
    The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught                 
    procedure "WRITE_ICFACT" "(FORM)", nor was it propagated by a RAISING clause.                 
    Since the caller of the procedure could not have anticipated that the                         
    exception would occur, the current program is terminated.                                     
    The reason for the exception is:                                                              
    Error Text of the Database: "ORA-14400: inserted partition key does not map to                
     any partition"

Information on where terminated                                                                   
    Termination occurred in the ABAP program "GP00O2TK1Z5X9LID0RYHIGDSMVF" - in                   
    The main program was "SAPMSSY1 ".                                                             
    In the source code you have the termination point in line 3433                                
    of the (Include) program "GP00O2TK1Z5X9LID0RYHIGDSMVF".                                       
    The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in                   
    procedure "WRITE_ICFACT" "(FORM)", but it was neither handled locally nor                     
    in the RAISING clause of its signature.                                                       
    The procedure is in program "GP00O2TK1Z5X9LID0RYHIGDSMVF "; its source code                   
     begins in line                                                                               
    3403 of the (Include program "GP00O2TK1Z5X9LID0RYHIGDSMVF ".
Source Code Extract
Line source Code
>>>>> INSERT (l_facttab) FROM TABLE g_t_u.



  • SAP Solution Manager 7.1
  • SAP Solution Manager 7.2


SAP Solution Manager 7.1 ; SAP Solution Manager 7.2


DBIF_RSQL_SQL_ERROR, DVM size extractor, size cube, BW API, concurrent, DVM Size Statistics Extractors, DBSQL_SQL_ERROR, /BI0/F0SM_SIZES, ORA-14400, SQL code: 0 , KBA , SV-SMG-DVM , Data Volume Management , How To

About this page

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

Search for additional results

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