cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle and SQL error

Former Member
0 Kudos

Hello All,

I am executing a report both in Bex analyzer and web template. When I try to drill down on any filedsin the report, it is giving this error, otherwise it is working fine.

This query is runing on Multiprovider underneath there are infocubes.

*SQL Error: 1578*

*ORA-01578: ORACLE data block corrupted (file # 354, block # 3146279) ORA-01110: data file 354: '/oracle/BWQ/sapdata/Bwp_74/bwp.data74' ORA-*

*Errors occurred during parallel processing of query 15, RC: 3*

*Error while reading data; navigation is possible*

Please help me what I need to check to resolve the issue..

Thanks

Edited by: sahiti_sap on Jul 26, 2011 3:45 AM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thank You all.

Former Member
0 Kudos

Hi,

Check the following thread,

[;

According to this thread re-indexing solved the issue.

Regards,

Durgesh.

gaurav_kothari
Contributor
0 Kudos

Hi,

This is an error due to data block corruption in the database level. You can have a look at the [Note 365481 - Block corruptions|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=365481] on similar issue. You can also do some more seach with the SQL error term in Service market place.

Regards,

Gaurav