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 (BPC) 10 for NW on HANA(any release),
- SAP EPM Add-in for Microsoft Office (all Service Packs)
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-BPC-NW-XLS , Report on EPM-XLS* , 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.