cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BW Query failing with ORA ERROR

Former Member
0 Kudos

Hi There

We have SAP BW 3.5 on AIX 5.3 TL10. Oracle is 9i (9.2.0.7). Our users are facing problems with Cost calculation job on cubes.

The job got failed with below error

Database error 1115 at FET access to table /BI0/03538

> ORA-01115: IO error reading block from file 48 (block #

> 1144987)#ORA-01110: data file 48:

> '/oracle//sapdata11/.data35.dbf'#ORA-27091: skgfqio:

> unable to queue I/O#ORA-27072: skgfdisp: I/O error#IBM AIX

> RISC System/6000 Error: 5: I/O error

-


Database error text........: "ORA-01115: IO error reading block from file 2

(block # 214041)#ORA-01110: data file 2:

'/oracle//sapdata4/_1/.data1'#ORA-27091: skgfqio: unable to queue

I/O#ORA-27072: skgfdisp: I/O error#IBM AIX RISC System/6000 Error: 5: I/O

error"

Internal call code.........: "[RSQL/READ/RSSDBATCH ]"

More Info:

Checked alert log, no errors in alert log. checked datafiles status and everything is perfect!! The errors are appearing in SAP application logs only

Is it due to any patches missing on AIX/oracle?

Any idea guys? Looks like some oracle/AIX error?

Accepted Solutions (0)

Answers (2)

Answers (2)

stefan_koehler
Active Contributor
0 Kudos

Hello Shrinath,

please post the following content.


shell> aioo -a

Maybe you have reached the maximum number of asynchronous I/O requests.

For example in our SAP environments the following parameters are set


shell> aioo -a
               minservers = 8
               maxservers = 400
               maxreqs = 1228
               fsfastpath = 1

Regards

Stefan

Former Member
0 Kudos

Hello

we have already set the maximum values for aio

MINIMUM number of servers 1000

MAXIMUM number of servers per cpu 1000

Maximum number of REQUESTS 4096

stefan_koehler
Active Contributor
0 Kudos

Hello,

> we have already set the maximum values for aio

> Maximum number of REQUESTS 4096

That is not the maximum by far ... please try the following settings and monitor your system again.


shell> aioo -o maxreqs=16384
shell> chdev -l aio0 -a maxreqs=16384 -P
shell> aioo -a (to verify the settings)

After making that settings you have to restart your oracle database.

By the way .. all that stuff is also mentioned in metalink note #559697.1

Regards

Stefan

Former Member
0 Kudos

Hi Shrinath,

I guess I have seen this before.

There was a discussion for the same in OTN.

Throw some light the below link.

Thanks,

Nick S

Former Member
0 Kudos

Hi Nick

I have seen that link already. In the link, the problem was with a table space and recovring the tablespace etc. In my case, i have execute the queries on database with out any problems.