Our Client is using BaaN IVc4 and on the platform mentioned above. He is a "Normal" user. While Opening the Maintain Sales Order Session he gets the error

"
Fatal error: Error 2115 (bdb_errno 2115) on SELECT
Fatal error: Can not continue in tdsls4110m000 (mess)

"


I have checked the logs. they are not highly descriptive
The log.ba6.1 says
"
Log message called from /BAAN/view/port.6.1c.07.15/vob
s/tt/ba/ba/baerrhand.c: #100 keyword: bshell message
2009-05-26[12:03:04]:E:islechfr: Pid 434984 Uid 2019 Euid 2019 Gid 125 Egid 125
2009-05-26[12:03:04]:E:islechfr: user_type N language 2 user_name islechfr tty 0 locale
ISO88592/NULL
2009-05-26[12:03:04]:E:islechfr: Errno 0 bdb_errno 0
2009-05-26[12:03:04]:E:islechfr: Log_mesg: Fatal error: Can not continue in tdsls4110m0
00 (mess)
"

The Log.bshell reports
"
Log message called from /BAAN/view/port.6.1c.07.15/vob
s/tt/mir/mir/bdb_fun.c: #1127 keyword: DB error
2009-05-26[12:20:37]:E:islechfr: Pid 508078 Uid 2019 Euid 2019 Gid 125 Egid 125
2009-05-26[12:20:37]:E:islechfr: user_type N language 2 user_name islechfr tty 0 locale
ISO88592/NULL
2009-05-26[12:20:37]:E:islechfr: Errno 0 bdb_errno 2115 (bdb_errno 2115)
2009-05-26[12:20:37]:E:islechfr: Log_mesg: Error 2115 (bdb_errno 2115) on "

And finally i checked log.oracle. It reports

"2009-05-26[12:20:37]:E:islechfr: dbs_errno = 0, Error 2115 occurred:
2009-05-26[12:20:37]:E:islechfr: Error ORA-1115 occurred during execute.
2009-05-26[12:20:37]:E:islechfr: ORA-01115: IO error reading block from file 33 (block
# 10473)
2009-05-26[12:20:37]:E:islechfr: ORA-01110: data file 33: '/baanFRU501p/oradata03/EUBAA
N1P/eubaan01_data_730d03.dbf'
2009-05-26[12:20:37]:E:islechfr: ORA-27091: skgfqio: unable to queue I/O
2009-05-26[12:20:37]:E:islechfr: ORA-27072: skgfdisp: I/O error
2009-05-26[12:20:37]:E:islechfr: ORA-27091: skgfqio: unable to queue I/O
2009-05-26[12:20:37]:E:islechfr: ORA-27072: skgfdisp: I/O error
2009-05-26[12:20:37]:E:islechfr: IBM AIX RISC System/6000 Error: 5: I/O error
2009-05-26[12:20:37]:E:islechfr:
2009-05-26[12:20:37]:E:islechfr: Error BDB-2115 returned.
2009-05-26[12:20:37]:E:islechfr: See fatal SQL statement in '/eubaan01/app/bse/log/log.
ora.sql'.
2009-05-26[12:20:37]:E:islechfr: Flushed at /BAAN/view/port.6.1c.07.15/vobs/tt/servers/
ORACLE_2/ora_cursor.c : #534.
"


Anybody with any insight?

P.S: I did not find that error either being a Super User as well as with Normal User.

It appears that you may have an Oracle problem. Go to Oracle's MetaLink and look up Doc ID: 559697.1 as it has to do with error condition ORA-01115 ORA-01110 ORA-27091 ORA-27072 Error: 5: I/O error. If you have a DBA you will need to talk to them. This does not appear to have anything to do with the way the user is set up or with the Baan application.

Check the Oracle - Alert Log.

This seems like Block Corruptions in redo or undo -> Check with DBA.
else
Try making a standby using last clean cold backup(which does not have the above issue) , apply archives and activate it.

all the best,.

Thanks for the response.

The error does not consistently come. It seems to have gone for now.

that's because you have file / disk corruption and you're not working in those blocks anymore.

The longer you wait to fix the problem the worse it will be when you try to.

Dave

Hi,

Check for Alert logs - oracle , May be a certain Block refering to a certain datafile - might be corrupt which will be re-read (read again & again) .

Note : if Yes - it is suggested to consultation from your DBA
or
make a Standby from ur last clean cold backup and activate it with a minimum of 10 min downtime .
(If downtime is ur major concern)