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 for Me (Login required).

Search for additional results

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