Symptom
The following error is returned when you refresh a EPM report: (The following error message is taken when refreshing a BPC web report. The error may be different when running reports from EPM Add-in)
[{"code":"UJHANA_SQE_EXCEPTION_007","description":"Run SQE HANA query fail","severity":"error","log_id":"051MYARn7kcc{VbfJi}8NW","variables":[]},{"code":"UJHANA_SQE_EXCEPTION_006","description":"Run SQE HANA query fail","severity":"error","log_id":"051MYARn7kcc{VbfJi}8NW","variables":[]},{"code":"UJHANA_ERROR_004","description":"Run SQE HANA query fail","severity":"error","log_id":"051MYARn7kcc{VbfJi}8NW","variables":[{"key":"FUNC_NAME","value":"TREX_EXT_AGGREGATE"},{"key":"RET_CODE","value":"2991 "},{"key":"RET_TEXT","value":"table config for index SAPSR1:0BW:BIA:DBH:CPMB_XXXXXXX is not valid\/[Request Info: Object Name = SAPSR1:0BW:BIA:DBH:CPMB_XXXXXXX, FM Name = TREX_DBS_AGGREGATE]"}]}],
The programs below are all executed but the same error occurs:
- UJA_REFRESH_DIM_CACHE (flag "Refresh all dimensions")
- UJXO_CLEAN_DIM_CACHE (you don't have to select a dimension. leave the dimension field blank, It will apply to all)
- UJXO_CLEAN_TDH_DIM_CACHE(for time-dependent dimensions only)
- UJHANA_REFRESH_VIR_CUBE
- BPC_HANA_MIGRATE_FROM_10 (if you are on BPC 10.0)/ BPC_MIGRATE_TO_HANA (if you are on BPC 10.1)
Read more...
Environment
- SAP Business Planning and Consolidation, version for SAP NetWeaver
Product
Keywords
EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC , KBA , reporting , EPM-BPC-NW-SQE , Shared Query Engine , 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.