SAP Knowledge Base Article - Preview

2812016 - "Run SQE HANA query fail" with "table config for index xxxx is not valid" when refreshing an EPM report

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

SAP Business Planning and Consolidation, version for SAP NetWeaver all versions

Keywords

EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC , KBA , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.