Error on DB Statistics causing job failure

[Former Member]

Hello all,

We are facing an issue on db13 transaction where the DBstatistics job is getting the following error:

BR0301E SQL error -1115 at location stats_tab_collect-20, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"SRRELROLES"', ESTIMATE_PERCENT => 30, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

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

ORA-01110: data file 14: '/oracle/ED0/sapdata3/sr3_11/sr3.data11'

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 404921

Additional information: -1

ORA-06512: at "SYS.DBMS_STATS", line 20390

ORA-06512: at "SYS.DBMS_STATS", line 20413

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPSR3.SRRELROLES

Can you help me to solve this issue?

[Former Member]

Hi Gabriel,

Could you also post the complete log

Regards,

Nikhil

[Former Member]

Hi Gabriel,

Is the issue fixed. Could you check with hardware team for any hardware or file system issues.

Regards,

Nikhil

[Former Member]

Hello Nikhil,

The issue is not fixed yet, I already contacted the hardware team and i`m waiting them to check it.

Thanks in advance,

Gabriel Cieplinski

[Former Member]

Is there any kernel update took place?

Regards,

Nick Loy

[Former Member]

Is this error continuous ?

Possible cause: 1) May be it was assigned temporarily , rerunning  the job might not face same issue

2) Mount Point/Disk is full

Try running the job again in different time schedule.

Regards,

[Former Member]

Hello Gagan,

I already tried the first option but it didn`t work, also there is a lot of space avaiable in the disk.

Last week the error ocurred on sr3.data09 now it is not working on sr3data11.

[former_member188883]

Hi Gabriel,

Please share the OS/DB details + SAP kernel details including version and patch.

Regards,

Deepak Kori