CX_RS_SQL_ERROR_SILENT========CP part LOAD

[Former Member]

Hi

When I am trying to run a query with some restriction on 0calmonth I am getting an error saying that 'CX_RS_SQL_ERROR_SILENT========CP part LOAD '..I am restricting the calmonth with 01/2006..

If I run the same report with 12/2005 to 02/2006 I am getting the data..and also if I run the query with 02/2006 also getting the data..Please suggest..

Thanks

Teja

[Former Member · Accepted solution]

Hi,

did you check RSRV consistency for the time dimension? other checks?

did you run it RSRT? you get a dump? Did you resave your query? Check its syntax?

is your infoprovider being collapsed or any other thing?

could you please describe further? is this a non-cumulative, the design of your report (CKF, RKF), do you have calmonth in the drilldown, how do you display it, dump...

let me know,

Olivier.

[Former Member · Accepted solution]

Hi

We have done RSRV Consistancy check

RSRT--Yes we got a dump

Resave--We cann't because it is already been in Quality server and in DEV we are not facing this problem

Syntax check--it is saying correct

we hvae created the indexes on the cube again and refreshed the stats on the cube

these are normal key figures .

no we dnt have calmonth in the drill down but it is a manditory input field .

Dump Message :Error(SQL error "-89987" occurred when accessing program

Thanks

Teja

[Former Member · Accepted solution]

hi,

thanks.

on which RDBMS is your BW?

can you paste the dump "Information on where termination occurred" here?

let me know...

Olivier.

[Former Member · Accepted solution]

Hi

it is DB2..

Thanks

Teja