Table Config for Index is Not Valid

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 ;

Table Config for Index is Not Valid

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

Table Config for Index is Not Valid

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?”

Table Config for Index is Not Valid

Continue with Create button…

Result page comes ;

Table Config for Index is Not Valid

Now you can check your process again, if needed you will use the report for other view(s)

Leave a Reply


six + 2 =

Blogroll