Error while refreshing the report or template SAP BPC

[Former Member]

Hi Experts,

We are encountering below error message while simple refreshing the template.

Observation:

Noticed that, in the report if we select base members in one Dimension it does not through error. Once we select the node for that same dimension it gives the error. Dimension here it is Account Dimension. The report acts like this only for this dimension. For rest of the dimensions changing from node to base members not effecting the report.

We have done Dimension refresh from the back-end by UJXO_CLEAN_DIM_CACHE program in SE38, as suggested by one of the notes. Please advice

System details:

EPM SP20

Error :

Server message:

code: UJHANA_SQE_EXCEPTION_007

severity: error

description: Run SQE HANA query fail

log id: 051Mibge7jQ{ir9{XRB{9W

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

severity: error

description: Run SQE HANA query fail

log id: 051Mibge7jQ{ir9{XRB{9W

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

severity:

description: Run SQE HANA query fail

log id: 051Mibge7jQ{ir9{XRB{9W

CONNECTION_CLOSED:

CONNECTION_OPEN_ERROR:

DBOBJECT_EXISTS:

DBOBJECT_NOT_EXISTS:

DB_ERROR:X

DUPLICATE_KEY:

EXTERNAL_ERROR:

INTERNAL_ERROR:1

INVALID_CURSOR:

NO_MORE_MEMORY:

SQL_CODE:391

SQL_MESSAGE:invalidated view: $BPC$V$KNDQE46P1: line 1 col 88 (at pos 87)

UNKNOWN_CONNECTION:

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

Framework message:

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

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

[mondfalter]

Hello S R,

did you find any solution for this problem?

I have the exact same error after maintaining a Dimension.

Best regards,

Alex

[former_member186338]

Please open a new discussion and provide full info about your case!

[mondfalter]

Hello Vadim,

I opened a new discussion:

https://answers.sap.com/questions/233922/ujhana-sqe-exception-007-invalidated-view.html

Best regards,

Alex

[former_member186338]

Please provide the detailed info about your BPC and BW version an SP