workbook not getting data...........?

[Former Member]

Hi all

I have a problem in workbooks. while i am executing workbooks it doesn't fetch

data from their multiprovider. But the Infoproviders having data here. Please let

me know where do i check it? how to check it? is there any specific way to find

out this?

thanks a lot in advacne.

swetha.

[Former Member · Accepted solution]

Does the query display data?

Check the selections, filters....

[Former Member · Accepted solution]

Hi JrRobert

I did like what you said. so it throws below error.

EError while reading data; navigation is possible

ESQL Error: 1578

EORA-01578: ORACLE data block corrupted (file # 211, block # 114243)#ORA-0

I>> Row: 71 Inc: NEXT_PACKAGE Prog: CL_SQL_RESULT_SET

advice me what to do now.

Regards

swetha

[Former Member · Accepted solution]

Hi,

Seems to be a problem with oracle database, try to consult with basis team, they might be helpful.

Cheers.

Ranga.

[Former Member · Accepted solution]

Hi,

Sorry to post again on that issue, but I face the same problem (I hope...), and it looks like someone found the root cause.

Could you share it please ?

PY

[Former Member · Accepted solution]

Is the query built from a cube or multiprovider. If it;s off a multiprovider, find the cubes underneath and try dropping the Oracle Indexes and Recreating them -

If its built directly on a cube then just drop the index on that cube and recreate them. This should resolve the issue.

[Former Member]

Use t code RSRT and use option Execute and execute your query in here.

in the result if it displays the data, that means everythign is fine.

You might have some issues with Workbooks add on or like that..

If in execution you do not see data than that means there is problem in Query Designing.

As Jr. Roberto suggested than you might have to go and check the detail designing of query like selection , filters etc...