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

Search for additional results

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