Symptom
- The creation of a SAP EPM Add-in report fails when trying to retrieve a substantial amount of dimension members in row or column axis
- If the number of members is reduced (less than 1000 members), the report can be properly created and refreshed
- Error:
Bad request.
Server message:
code: SY_530
severity: error
description: An exception has occurred
log id: KMiqI7}Q0sdX08002W8N4m
DATAVALUE:
MDX:
V1:
V2:
V3:
V4:
-----------------code:
severity:
description: An exception has occurred
log id: KMiqI7}Q0sdX08002W8N4m
CONNECTION_CLOSED:
DBOBJECT_EXISTS:
DBOBJECT_NOT_EXISTS:
DB_ERROR:X
DUPLICATE_KEY:
EXTERNAL_ERROR:
INTERNAL_ERROR:1
INVALID_CURSOR:
SQL_CODE:2048
SQL_MESSAGE:column store error: search table error: [23008] Can't create plan for join query;stack overflow
UNKNOWN_CONNECTION:
-----------------
Framework message:
The remote server returned an error: (400) Bad Request.
----------------------
Read more...
Environment
- SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver on HANA(any release)
- SAP EPM Add-in for Microsoft Office
Product
Keywords
EPM , BPC NW , EPM Add in , EPM Addin , Office , Excel , HANA , DB , Database , (400) Bad Request , SQL_MESSAGE:column store error: search table error: [23008] Can't create plan for join query ; stack overflow , members , size , tables , indexserver.ini , indexserver , report with a big amount of dimension members to be retrieved , KBA , EPM-XLS , EPM Excel Client , 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.
SAP Knowledge Base Article - Preview