SAP Knowledge Base Article - Preview

3405092 - Runtime error in DBSQL_SQL_ERROR: SQL code: 0 occurred while accessing table /BI0/F0SM_SIZES in SAP Solution Manager 7.2

Symptom

The following dump occurs in ST22:

Category               Installation Errors
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB

SQL error "SQL code: 0" occurred while accessing table "/BI0/F0SM_SIZES".

 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"

Source Code Extract:

3567   SORT g_t_u BY
3568   KEY_0SM_SIZESP
3569   KEY_0SM_SIZEST
3570   KEY_0SM_SIZES1
3571   KEY_0SM_SIZES2
3572   KEY_0SM_SIZES3
3573   KEY_0SM_SIZES4
3574 .
3575
3576
3577
>>>>   INSERT (l_facttab) FROM TABLE g_t_u.
3579
3580 c_lines  = sy-dbcnt.


Read more...

Environment

SAP Solution Manager 7.2

Product

SAP Solution Manager all versions

Keywords

DVM size extractor, size cube, concurrent, DVM Size Statistics Extractors, DBSQL_SQL_ERROR, /BI0/F0SM_SIZES, ORA-14400, SQL code: 0 , KBA , SV-SMG-DVM , Data Volume 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.