SAP Knowledge Base Article - Preview

1847202 - Error "400 Bad Request" when executing EPM Add-in report with a big amount of dimension members to be retrieved - BPC NW

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

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver

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.