Excel issue in BPC 10 on hana "The execution of report Default Report failed. Please contact your administrator.".

[former_member280858]

Hi Experts...

We are using EPM 10.0 SP04 NW HANA and facing below error in one of our environments when we click on New report. If we keep any dimensions in column and rows we are getting the below error.

"The execution of report Default Report failed. Please contact your administrator.".

Bad request.

Server message:

code: UJHANA_SQE_EXCEPTION_007

severity: error

description: Run SQE HANA query fail

log id: 025QbI0w7kEcieZw{ze90m

-----------------code: UJHANA_SQE_EXCEPTION_004

severity: error

description: Run SQE HANA query fail

log id: 025QbI0w7kEcieZw{ze90m

-----------------code:

severity:

description: Run SQE HANA query fail

log id: 025QbI0w7kEcieZw{ze90m

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:  [6994] Hierarchy source data: Cycles in graph not allowed;Invalid cycles detected. A SUCC node has itself as an ancestor. -1

UNKNOWN_CONNECTION:

-----------------

Framework message:

The remote server returned an error: (400) Bad Request.

Please give your suggestions to resolve this issue.

Thanks,

Raj

[Former Member · Accepted solution]

Hi Raj,

Please refer note 1861181 - SQE HANA query fails with error - SQL_MESSAGE:invalid table name: Could not find table/vie... and see if it helps.

Regards,

Kalyan

[former_member190501]

Hi,

Can you check Note    1763693  - Run SQE HANA query fail

Thanks,

Raju

[former_member280858]

Hi Raju,

Thanks for your reply but we are already using SP04 patch but in the OSS Note it shows upgrade to SP03.

Please update if your know any more suggestions.

Thanks,

Raj