Skip to Content
0
Former Member
Feb 24, 2017 at 09:11 AM

Error while refreshing the report or template SAP BPC

357 Views Last edit Mar 31, 2017 at 04:20 PM 3 rev

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.