Symptom
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
in
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
"WRITE_ICFACT".
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
declared
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.
Read more...
Environment
- SAP Solution Manager 7.1
- SAP Solution Manager 7.2
Product
Keywords
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.