SAP Knowledge Base Article - Preview

1918121 - Extracting Data from a Cube with non-cumulative keyfigure

Symptom

  1. Load data from a BW cube with non-cumulative keyfigure using the standard "Load Transaction Data from BW InfoProvider UI" BPC Data Manager (DM) Package (/CPMB/LOAD_INFOPROV_UI process chain) fails with the error below:

    Task name CONVERT:
    No 1 Round:
    Error occurs when loading transaction data from other model
    model: <model_name>. Package status: ERROR
  2. On transaction RSPC, it is possible to see on the logs that the task 'Convert' failed and the status is 'Ended with errors'
  3. SM37 job status is 'Finished'
  4. On SM50 work process (WP) trace, the SQL query fails. The error message might change according to the database vendor, but in all cases, the query cannot be performed.
    1. Error message on MaxDB:

      C  *** ERROR =>   prepare() of C_0501, rc=1, rcSQL=-4005 (POS(2202) Unknown column name:<ncum_keyfigure_tech_name>)
       [dbsdbsql.cpp 2601]
      C  {root-id=00505601105E1ED389A9E3D8622BEF91}_{conn-id=184F25E32EFFF1BA8F9100505601105E}_1
      C  *** ERROR => SQL PREPARE on connection 0, rc=-4005 (POS(2202) Unknown column name:<ncum_keyfigure_tech_name>)
       [dbslsdb.cpp  8907]
       ... (SQL statement)
      B  ***LOG BY2=> sql error -4005      performing OPC        [dbds         398]
      B  ***LOG BY0=> POS(2202) Unknown column name:<ncum_keyfigure_tech_name> [dbds         398]
      B  ***LOG BY1=> sql error -4005      [dbacds       1512]

    2. Error message on DB6:

      C  *** ERROR in prepareStatement[dbdb6.c, 15197] CON = 0 (BEGIN)
      C  &+***      dsql_db6_open( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/AIX64] SQL0206N  "<ncum_keyfigure_tech_name>" is not valid in the cont
      C  &+***      ext where it is used.  SQLSTATE=42703
      ... (SQL statement)
      C  *** ERROR in prepareStatement[dbdb6.c, 15197] (END)
      B  ***LOG BY2=> sql error -206       performing OPC        [dbds         398]
      B  ***LOG BY0=> SQL0206N  "<ncum_keyfigure_tech_name>" is not valid in the context where it is used.  SQLSTATE=42703 [dbds         398]
      B  ***LOG BY1=> sql error -206       [dbacds       1512]

    3. Error message on Oracle is ORA-904


Read more...

Environment

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver

Keywords

ncum n-cum key figure , KBA , EPM-BPC-NW , NetWeaver Version , 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.