Skip to Content
0
Former Member
Mar 19, 2009 at 02:14 AM

physical plan error when running query on BIA - table not committed in BIA

74 Views

Hello Everyone,

We have one of the InfoCubes in BIA which has data in the F fact table and no date in the E fact table as no data was compressed.

But, when I am running the queries on top of the InfoCube I am getting the errors stating query cannot be executed.

The error message is 2966 occured in BIA server.

We currently are at SP13 and I have identified the OSS Note 1240401 which is part of SP20 and cannot be applied in our system through SNOTE.

Did anyone else have the same issue with the BIA InfoCube Index which does not have data in E fact table.

The error screen has the following info:

"Error while reading data; navigation is possible"

"Errors occured during parallel processing of query 1, RC: 3"

"Error creating physical plan: table bdv_bic:fzcsls 2966"

"Error reading the data of InfoProvider ZCSLSRM06$X"

"The following error 2966 occurred in BIA server"

"Error creating physical plan: table bdv_bic:fzcslsmr06 is not committed in cube: bdv_zcslsmr06"

">>Row: 58 Inc: WRITE_MESSAGES Prog: CL_RSDR_AT_QUERY"

When I compress the InfoCube in question I am able to run the queries fine without any issue.

But I would still like to find out if this is mandatory to have atleast few requests compressed in order to have both E and F fact tables available.

Thanks

Dharma.