During the function db.clear.table, i receive an fatal error : error 215. this is an oracle error. is there someone to help me ?

Thanks a lot

Can you post the error entry from your $BSE/log/log.oracle file?

Hi,
Since I got this error today, I was looking for help in the baanboard archive.

In my case this happend just after installing a new porting set 7.1d.02 on baanERP 50c.

The error in log.bshell6.2 is displayed below.

If someone have any hints, please reply.

Bye,
Giuseppe

2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: ******* S T A R T of Error message *******
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Log message called from /view/port.7.1d.02/vobs/tt/lib/al_1/al_fpath.c: #220 keyword: sopen
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Pid 1314 Uid 102 Euid 102 Gid 125 Egid 125 Pset ecatucci@BaaNV:1314
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: user_type S language 2 user_name ecatucci tty ote locale ISO88591/NULL
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Errno 2 (No such file or directory) bdb_errno 215 (Illegal state)
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Log_mesg:
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: No definition in definition file for sopen(F_OBJ:ttdskbbrowser, ttdskbbrowser)
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: ******* E N D of Error message *******
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci:
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: ******* S T A R T of Error message *******
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Log message called from /view/port.7.1d.02/vobs/tt/mir/mir/bdb_fun.c: #1082 keyword: DB error
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Pid 1314 Uid 102 Euid 102 Gid 125 Egid 125 Pset ecatucci@BaaNV:1314
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: user_type S language 2 user_name ecatucci tty ote locale ISO88591/NULL
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Errno 0 bdb_errno 215 (Illegal state)
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Log_mesg: Error 215 (Illegal state) on select
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: ******* E N D of Error message *******
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci:
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: ******* S T A R T of Error message *******
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Log message called from /view/port.7.1d.02/vobs/tt/mir/mir/mul_fun.c: #459 keyword: Process state:
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Pid 1314 Uid 102 Euid 102 Gid 125 Egid 125 Pset ecatucci@BaaNV:1314
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: user_type S language 2 user_name ecatucci tty ote locale ISO88591/NULL
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Errno 0 bdb_errno 215 (Illegal state)
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: FATAL ERROR: Error 215 (Illegal state) on select
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci: Can not continue in ottstpstdlib ()
2003-07-26[17:33:02(UTC-01:00)]:E:ecatucci:

oracle:
# oerr ora 215
00215, 00000, "must be at least one controlfile"
// *Cause: No controlfile is specified or the controlfile specified does
// not exist.
// *Action: Specify at least one valid controlfile and retry the operation.

baan:
contact Baan support, this requires a patch.

Tianalita,

Please complete your user profile with regards to the Baan software
version, Database software and OS version. This will help other members
when diagnosing your problem.

There was a similar posting today -
audit error:254, cant commit transaction on audit server ?? (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=12432) and it
looks similar to the problem I faced long time ago.

Refer to the thread and check your source code or upgrade to the newest
porting set or work with BaaN Support.


Audit Errors (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=5396&highlight=audit)

Good Luck!