Skip to Content
0
Former Member
Jan 19, 2012 at 02:53 PM

Query shows no data after transport gives oracle error

40 Views

Hi,

I am having an issue with a query which was working fine in BWT. I made a change to the mutliprovider in BWD by replacing an existing cube with a new one although the new cube had all the same feilds as the old one so nothing changed on the query. The query still works fine in BWD but when I transported the changes to BWT I get the following errors upon execution of the query.

I tried regenerating the query in RSRT2 but even then same result.

Here is the error:-

ORA-00376: file 1573 cannot be read at this time ORA-01110: data file 1573: '/oracle/BWT/sapdata21/factd_162/factd.data162'

SQL Error: 376

An exception with the type CX_RS_ACCESS_ERROR occurred, but was neither handled locally, nor declared in a RAISING clause

Error reading the data of InfoProvider Z_DSC0030

Error while reading data; navigation is possible

What am I doing wrong, please advice.

Thanks,

PC

Edited by: Swaroop Chandra on Jan 19, 2012 3:58 PM