Hi,
When running the “Close Production Order (ticst0201m000)” session we are getting the following error message in the log files.

log.oracle8
sampannh: ******* S T A R T of Error message *******
sampannh: Log message called from /port.6.1c.03.01/vobs/tt/servers/ORACLE_2/ora_native.c: #2013 keyword: Oracle

sampannh: Pid 2118 Uid 2822 Euid 2822 Gid 47 Egid 47
sampannh: user_type S language 2 user_name sampannh tty ote locale ISO88591/NULL
sampannh: Errno 0 bdb_errno 0
sampannh:
sampannh: dbs_errno = 0Error 2115 occurred:
sampannh: Error ORA-1115 occurred during execute.
sampannh: ORA-01115: IO error reading block from file 67 (block # 262144)
sampannh: ORA-01110: data file 67: '/odata01/baandata/co100/index/utfidx3.dbf'
sampannh: ORA-27072: skgfdisp: I/O error
sampannh: SVR4 Error: 25: Inappropriate ioctl for device
sampannh: Additional information: 262143
sampannh:
sampannh: Error BDB-2115 returned.
sampannh: See fatal SQL statement in '/baan/bse/log/log.ora.sql'.
sampannh: Flushed at /port.6.1c.03.01/vobs/tt/servers/ORACLE_2/ora_cursor.c : #511.
sampannh: ******* E N D of Error message *******

log.bshell
sampannh: ******* S T A R T of Error message *******
sampannh: Log message called from /port.6.1c.03.01/vobs/tt/mir/mir/bdb_fun.c: #935 keyword: DB error
sampannh: Pid 12097 Uid 2822 Euid 2822 Gid 47 Egid 47
sampannh: user_type S language 2 user_name sampannh tty ote locale ISO88591/NULL
sampannh: Errno 0 bdb_errno 2115 (bdb_errno 2115)
sampannh: Log_mesg: Error 2115 (bdb_errno 2115) on tfgld418100 in db_insert(51)
sampannh: ******* E N D of Error message *******

Does anyone have any idea how to go around to fix this problem?

Appreciate your help.

Thanks,
Nagesh

It looks like a database corruption. Please take down the database and do a dbverify on that datafile.

Please ensure that your backups are handy. If this is a corruption, you may need to do recovery.

Thanks for your response.

It turned out that we have an index that is sitting in a corrupted block. I could drop and recreate the index but the problem is that the index is on table tfgld418 and we have 25 million rows in that table and it will probably take really long time to recreate this index.

Does anyone know any other work around for this issue?

Appreciate your help.

Thanks,
Nagesh