Symptom
- 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 - On transaction RSPC, it is possible to see on the logs that the task 'Convert' failed and the status is 'Ended with errors'
- SM37 job status is 'Finished'
- 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.
- 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] - 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] - 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.