[Problem]
Now I have installed a testing Triton(BaanIV).
OS: SCO 5.0.5
Database: Oracle 7.3.4
Application: Baan IV
...........
When I update a record and save it, the error message appears.
--> Detected database server termination
--> and Lost connection with bshell..

...........
The log.ba6.1 is as follow:
What does it mean? How to solve the problem?

2006-04-20[23:17:44]bsp: ******* S T A R T of Log message *******
2006-04-20[23:17:44]bsp: Log message called from /port.6.1b.05/vobs/tt/ba/ba/bae
rrhand.c: #108 keyword: bshell message
2006-04-20[23:17:44]bsp: Pid 3551 Uid 102 Euid 102 Gid 102 Egid 102
2006-04-20[23:17:44]bsp: user_type S language 2 user_name bsp tty 2 locale ISO88
591/NULL
2006-04-20[23:17:44]bsp: Errno 0 bdb_errno 0
2006-04-20[23:17:44]bsp: Log_mesg: Fatal error: Detected database server termina
tion
2006-04-20[23:17:44]bsp: ********** E N D of Log message **********

And the Log.oracle7:
2006-04-20[23:17:37]bsp: ******* S T A R T of Log message *******
2006-04-20[23:17:37]bsp: Log message called from /port.6.1b.05/vobs/tt/lib/al_1/
al_sig.c: #81 keyword: CORE DUMPED
2006-04-20[23:17:37]bsp: Pid 3553 Uid 102 Euid 102 Gid 102 Egid 102
2006-04-20[23:17:37]bsp: user_type S language 2 user_name bsp tty 2 locale ISO88
591/NULL
2006-04-20[23:17:37]bsp: Errno 0 bdb_errno 0
2006-04-20[23:17:37]bsp: Log_mesg: core_dumped() signal 11 cwd: '/ap/bse/log'
2006-04-20[23:17:37]bsp: ********** E N D of Log message **********


Thanks!

The "database server termination" error is caused by the core dump.

you'll need to debug the core to find out why that is..

could be your oracle 7 install (maybe it needs to be relinked)
but it could be any number of things.

Dave

Hi, Dave:
Thank you for your suggestion.
But what should I refer to as i'm not familiar with such checking.
1. How to debug the core ?
2. Should I check os level or DB level?
It seem the database works well, as I could use SQL to insert/update the tables, while the error happens when I use sessions.

Konichiwa,

we have a oracle 8.1.7 with a Baan IV SP19 running on Tru64 Unix System.

We had the same error, occuring only in one special department, termination 2 - 3 times a day, not reproduceable with a special session.

Reason was a serie of 5 cascading switches which results in a network error.

Moving the user one switch lower solved the problem.

BW Message was:
Fatal error : Detected database server termination

Sometimes a more specific error message came up:
Error 215 (illegal state) on ttcom010100 in db_insert
or
error in db_insert (with 4 retrys) in tables likettadv990 (User Defaults) and ttadv999 (Runtime) or an error in baan standard dll.

Regards,

Kozure

Hi, Dave:
Thank you for your suggestion.
But what should I refer to as i'm not familiar with such checking.
1. How to debug the core ?
2. Should I check os level or DB level?
It seem the database works well, as I could use SQL to insert/update the tables, while the error happens when I use sessions.


Your ability to use the database has actually very little to do with baan.
Baan connects to the database using OCI functionality. Oracle does not provide any programs that use this way of connecting, so the only way to know if your OCI is broken is the fact that baan isn't working.

As for debugging the core, you'll need to install a debugger like gdb.
That's the extent of what i know about it =).

one other way to look is to do "strings -a" on the core file, but there you kind of have to have something you're looking for.

Dave

Thanks, dave!
Attached the core file for reference..before we find the solution..:)

all i can tell from the core is that the driver is causing the dump
and that you're porting set is very old and linked against
DBMS ver. : 7.1.6.2.0

Maybe the driver won't work with 7.3.4

Dave

Thanks, Dave!
The things puzzled me is that:
It comes all right when I update records in company 000 (Baan Tools company), such as delete a user and save.
(If the db driver does not work, the company 000 will also terminated , is it?)

The error exists only in the company created by me.

Have something special to be pay attention to?

Thank you!

What does your tabledef6.1 look like?

Dave

Attached tabledef6.1 and ora_storage.
Thanks!

Hi, Dave:
It seems OK now.
The error "Detected database termination" doesn't happen again!
Here is my solution.
------------------------------------------
Check the original tabledef6.1:
........
trwrc000:*:oracle7(ORACLE_SID=AOTRITON,ORACLE_HOME=/u1/app/oracle/product/7.3.4):Y
tssma000:*:oracle7(ORACLE_SID=AOTRITON,ORACLE_HOME=/u1/app/oracle/product/7.3.4):Y
*:*:oracle7(ORACLE_HOME=/u1/app/oracle/product/7.3.4,ORACLE_SID=AOTRITON,ORA_INIT=0111000):N
........

Backup it, and change it as follow: remove all the lines,and add just one line:
*:*:oracle7(ORACLE_HOME=/u1/app/oracle/product/7.3.4,ORACLE_SID=AOTRITON):N

------------------------------------------

Thanks for your help!: )

Here I'd ask a little question..
What does "Audit" in Baan ERP mean?
It seems my "Assign Tables to Databases(ttaad4111m000)" does not work.
When I save and Convert to Runtime, it shows "BSE path system athena.aopen.or unknown" and conversion failed..(attached pic)
PS: I only need to convert to local .
Should I set some other parameters?

Thanks again!

When you copy from one server to another you have to go through
the system and change all the paths and all the servers to point to the right places. It seems like you missed a few.

As for Audit, Baan has built in audit usually by default the parameters
tables are audited but you can audit more. Audit is turned on
by setting the flag at the end of your line in your tabledef from
:N to :Y

You wouldn't want to do this for all tables.

Dave

Ok. Thank you! :)