Skip to Content
0

Error while refreshing the report or template SAP BPC

Feb 24, 2017 at 09:11 AM

109

avatar image
S R

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Mar 09, 2017 at 10:01 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Alex Jedig Jun 22, 2017 at 07:46 AM
0

Hello S R,

did you find any solution for this problem?

I have the exact same error after maintaining a Dimension.

Best regards,

Alex

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

Hello Vadim,

I opened a new discussion:

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

Best regards,

Alex

0