After upgraded SAP NW version from NW 7.3 to NW 7.4 on BPC (BW) systems with HANA database, BEX analyzer can give the error like “table config for index SAPSR3:….. is not valid”, also you can get this error message after homogeneous copy operations on BW systems.
Detail of the error screen should be like below picture ;
In this case, trying the EPM Add in usage probably gives the below message also ;
Bad request.
Server message:
—————–code: UJHANA_ERROR_004
severity: error
description: Run SQE HANA query fail
log id: 051MZsOe7kYqsZVKM3ohoG
FUNC_NAME:TREX_EXT_AGGREGATE
RET_CODE:2991
RET_TEXT:table config for index SAPSR3:0BW:BIA:CPMB_CUINF3F is not valid/[Request Info: Object Name = "SAPSR3"."0BW:BIA:CPMB_CUINF3F", FM Name = TREX_DBS_AGGREGATE]
To solve the issue, you can use the report “RSDDB_INDEX_CREATE_MASS” on the related system.
SE388 –> RSDDB_INDEX_CREATE_MASS –> F8
In our case, errors comes from the InfoObjects and Infocubes, therefore we chose the below view groups to create,
also other important point is unchecking the selection of “Skip object if it already exist?”
Continue with Create button…
Result page comes ;
Now you can check your process again, if needed you will use the report for other view(s)
