Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question