Hi All,

I am facing the following error while trying to run MRP is multiple bshell mode (using performance boosters).


Log.bshell6.1 error when MRP is starting

2007-02-20[19:52:30]:E:bsp: ******* S T A R T of Error message *******
2007-02-20[19:52:30]:E:bsp: Log message called from /view/port.6.1c.07.07/vobs/tt/lib/qpd/qpd_ldic.c: #1473 keyword: xchdef

2007-02-20[19:52:30]:E:bsp: Pid 22191 Uid 125 Euid 125 Gid 125 Egid 125
2007-02-20[19:52:30]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2007-02-20[19:52:30]:E:bsp: Errno 2 (No such file or directory) bdb_errno 0
2007-02-20[19:52:30]:E:bsp: Log_mesg: lib/xchdef6.1 open error 2
2007-02-20[19:52:30]:E:bsp: ******* E N D of Error message *******

Log.orcale8 error when MRP is starting

2007-02-20[19:53:33]:E:bsp: ******* S T A R T of Error message *******
2007-02-20[19:53:33]:E:bsp: Log message called from /view/port.6.1c.07.07/vobs/tt/lib/dbs/dbs_rowact.c: #2005 keyword: Reference

2007-02-20[19:53:33]:E:bsp: Pid 21486 Uid 125 Euid 125 Gid 125 Egid 125
2007-02-20[19:53:33]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2007-02-20[19:53:33]:E:bsp: Errno 0 bdb_errno 110 (End of file reached)
2007-02-20[19:53:33]:E:bsp: Log_mesg: Reference locked: table tirou001 key [608]
2007-02-20[19:53:33]:E:bsp: ******* E N D of Error message *******

2007-02-20[19:53:46]:E:bsp: ******* S T A R T of Error message *******
2007-02-20[19:53:46]:E:bsp: Log message called from /view/port.6.1c.07.07/vobs/tt/lib/dbs/dbs_rowact.c: #2005 keyword: Reference

2007-02-20[19:53:46]:E:bsp: Pid 20728 Uid 125 Euid 125 Gid 125 Egid 125
2007-02-20[19:53:46]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2007-02-20[19:53:46]:E:bsp: Errno 0 bdb_errno 110 (End of file reached)
2007-02-20[19:53:46]:E:bsp: Log_mesg: Reference locked: table tirou001 key [608]
2007-02-20[19:53:46]:E:bsp: ******* E N D of Error message *******

Any help would be highly appreciated.

Thanks in advance

I think that something causes the table lock. Did you try it when there is a no lock on table or Is there a possibility to try it when there is a no user on system. !

Good luck !

do u able to log into the oracle through baanIV,bsp,baan users.please check.

the log entry in log.bshell is most likely not connected to your problem at all. It is complaining about a missing file in $BSE/lib. You can create that file by executing "Convert to runtime" in Session ttaad4117m000 "Maintain tables exchanged with audit". This "convert to runtime" is one of the harmless once and only recreates this file.

Good luck,

Markus

Thanks all for your quick reply. I just want to know that wheather these errors are going to affact my system because my system is running smoothly and no users has been reported any type of error so far. If this is going to affact my system then how to resolve this problem

Thanks in advance

Hi Markus,

Thanks, bshell error is solved when I have created the xchedef6.1 file in $BSE/lib but I am still getting the reference table locked problem in log.oracle8. How to solve this problem.

Hi there,

I don't have any experience with the performance booster. Do you see locks too if you start the session without it? (Perhaps this performance booster is buggy and creates this lock situation?)
Perhaps you can find out who sets the lock with session ttstpdellocks.
If you can't find it this way, there should be a way to have oracle display locks.

good luck

Norbert