Skip to Content

BPC 10 on HANA - Internal error: no result set

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 07, 2014 at 08:42 PM

    Hi Valerio,

    Do you have ENABLE_HANA_MDX=X in SPRO?

    -Gersh

    Add comment
    10|10000 characters needed characters exceeded

    • 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