2488817 - SY_530 error when refreshing report with YTD and PER data and ENABLE_QUERY_CACHE is active | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2488817 - SY_530 error when refreshing report with YTD and PER data and ENABLE_QUERY_CACHE is active

Symptom

Issue: When global parameter ENABLE_QUERY_CACHE is active refreshing EPM reports results in error:

HTTP Status:400

[{"code":"SY_530","description":"An exception was raised","severity":"error","log_id":"01O{3c7y7kUJZbj1GUZr6W","variables":[{"key":"DATAVALUE","value":""},{"key":"MDX","value":""},{"key":"V1","value":""},{"key":"V2","value":""},{"key":"V3","value":""},{"key":"V4","value":""}]},{"code":"UJA_EXCEPTION_014","description":"An exception was raised","severity":"error","log_id":"01O{3c7y7kUJZbj1GUZr6W","variables":[{"key":"APPLICATION_NAME","value":""},{"key":"APPSET_ID","value":"EMN"},{"key":"ATTRIBUTE_NAME","value":""},{"key":"BEXVCUBE","value":""},{"key":"CUBE","value":""},{"key":"DIMENSION","value":"MEASURES"},{"key":"DIM_TECH_NAME","value":""},{"key":"ERROR_CODE","value":"0 "},{"key":"ERROR_MSG","value":""},{"key":"FUNC_NAME","value":""},{"key":"HIER_NUM","value":"0 "},{"key":"INFOAREA","value":""},{"key":"MEMBER_ID","value":""},{"key":"MULTIPROVIDER","value":""},{"key":"PARAM01","value":""},{"key":"PARENT","value":""},{"key":"SRC_APPSET_PREFIX","value":""},{"key":"TABLE_NAME","value":""},{"key":"TGT_APPSET_PREFIX","value":""},{"key":"USER_ID","value":""}]}]

After disabling the parameter reports refresh as expected.

Issue is not resolved after multiple execution of UJX0_CLEAN_CACHE.


Read more...

Environment

  • SAP BusinessObjects Planning and Consolidation 10.0 version for SAP Netweaver
  • SAP BusinessObjects Planning and Consolidation 10.1 version for SAP Netweaver
  • SAP BW 7.50 SP03 and later

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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