BPC 10 on HANA - Internal error: no result set

[valeriocicchiel]

Hello community,
when we run our packages and reports from BPC EPM client, we have this error in EPM:

Bad request.
Server message:
code: SY_530
...
DATAVALUE:Internal error : no result set
...
Framework message:
The remote server returned an error: (400) Bad Request.”

SAP Note 1947736 (Error when refreshing reports for the second time in EPM Add-in) does not help in our scenario.
The only solution is the complete restart of BPC+HANA, but the error reappear later on.

In SM21 we see the following errors:
B ***LOG BY2=> sql error -9300 performing OPC [dbds 437]
B ***LOG BY0=> Internal error : no result set [dbds 437]

In the indexserver trace of SAP Hana we have this error when run packages

buildDynamicHierarchyDefinition 842993 object not found No error
Error occurred while executing a MDX statement. The error message is: exception  1: no.9500000

    An internal error occurred. Assertion failed with error message Can't read entity info for [Measure: [Measures].[/B28/S_SDATA

- And this error when we run reports

buildDynamicHierarchyDefinition 842993 object not found No error

Error occurred while executing a MDX statement. The error message is: exception  1: no.9500000

    An internal error occurred. Assertion failed with error message Hierarchy cache container is null

Did anyone found the same errors? SAP support consider our issue as consulting and not support question

Regards,
Valerio

[former_member200327 · Accepted solution]

Hi Valerio,

Do you have ENABLE_HANA_MDX=X in SPRO?

-Gersh

[valeriocicchiel · Accepted solution]

Hello Gersh,

Yes we have ENABLE_HANA_MDX=X in SPRO. These are our current parameters:

Global Parameters:

ENABLE_ACCELERATOR Y

Environment Parameters:

ACCELERATOR_ON Y

ALLOW_EXTENSIONS ALL

ALLOW_FILE_SIZE 104857600

DEFAULT_EXTENSIONS XLS,XLT,DOC,DOT,PPT,POT,XML,MHT,MHTML,XLSX,XLSM,XLSB,ZIP,PDF,PPTX,PPTM,POTX,POTM,DOCX,DOCM,DOTX,DOTM,CDM,TDM,PNG,GIF,JPG,CSS,MRC

ENABLE_DISAGGREGATION X

ENABLE_SHARED_OBJECT Y

LOGLEVEL 3

Model Parameters

BPC_STATISTICS

ENABLE_HANA_MDX X

ENABLE_NATIVE_HANA_MODEL X

INTERVAL_NR 10

MULTIPLY_COEF 50

NW_VERSION 0

PACKAGE_SIZE 40000

RECLEVEL_NR 40000

SPARSITY_COEF 5

I will check BPC_STATISTICS, but we don't think it's related to our problem. Are there other parameters which must be set in order to make the MDX engine work properly?

Best Regards,

Valerio

[former_member200327 · Accepted solution]

Hi Valerio,

Can you try setting ENABLE_HANA_MDX = SPACE and run that report again?

If you don't receive any errors set it back and tr y following OSS Note 1958603 - Analyze HANA MDX problems in Planning and Consolidation 10.0 NW.

Regards,

Gersh

[valeriocicchiel · Accepted solution]

Thank you Gersh,

we will follow your hint in order to isolate and analyse deeply the issue, thanks for your help.

We just found a new revision for HANA which probably solves one of our errors: SAP Note 2016740 - SAP HANA SPS 07 Database Maintenance Revision 74.01. In the note we found this: Fixed an issue that caused MDX query failures with the error message "Hierarchy cache container is null".

So we are patching HANA before try any other action, because we are still on SPS07 revision 72.00

Best regards,

Valerio