Hi, we have recently upgraded to oracle 10g and have found (as well as a few performance issues) that when we try to import using exchange we get an disconnection error. funny things is this doesnt happen when there is no one else logged on the server, only during normal work times.

see attached for error detail

Baan 5c
Porting set is 7.1d.12a
GUI is 7.1d.15.168
oracle 10g

Thanks for any help

Dave

Update - we kinda now now what the problem is and it seems that the exchange issue is a symptom of a bigger problem. we create a temp table using our 'bsp' user and when we try to create the physical table we get thrown out of baan with the same database server disconnection error. Looks like our bsp user doesnt have authorisation to create tables (and temp tables for exchange).

any ideas how we allow this authorisation, we have just upgraded to oracle 10g

Thanks

Dave

Dear davismit,

please try to add the bsp users to unix group dba.


Regards,

Kozure

Hi, Thanks for the reply.

Thats the thing he exists in dba_users

Dave

Dear davismit,

ist dba_users on oracle level or on OS (Unix) level (= /etc/group).

We had permission problems (as workaround) we had to add the os user to the group dba.

Can you add a table on oracle level with oracle user bsp e.g. with sqlplus.

Regards,

Kozure

Hi, Yes we can create tables at oracle level. can you explain further waht you did on your work around. Im starting to think this may be an issue with Shared memory

Dave

Dear davismit,

just add the user bsp on unix level to the group dba.

command: groupadd ... OR usermod -G ...

or manually edit the file /etc/group and add the user "bsp" in the "dba" line:

Example:

dba:*:601:bsp,oracle,root

Regards,

Kozure

Hi we still get the error. Would we need to restart oracle or reboot the box for this to be picke up.

Regards

Dave

Hello, i have the same problem, it comes a window with the message ....Fatal error: Detected database server termination, and the oracle log has:
2008-06-04[15:38:05(UTC+06:00)]:E:bsp: ******* S T A R T of Error message *******
2008-06-04[15:38:05(UTC+06:00)]:E:bsp: Log message called from /view/port.7.1d.10/vobs/tt/lib/al_1/al_sig.c: #173 keyword: CORE D
MPED
2008-06-04[15:38:05(UTC+06:00)]:E:bsp: Pid 4657396 Uid 125 Euid 125 Gid 125 Egid 125 Pset mchowell@CD1-01MCHOWELL:2612
2008-06-04[15:38:05(UTC+06:00)]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2008-06-04[15:38:05(UTC+06:00)]:E:bsp: Errno 0 bdb_errno 110 (End of file reached)
2008-06-04[15:38:05(UTC+06:00)]:E:bsp: Log_mesg: core_dumped() signal 11 cwd: '/home/bsp'
2008-06-04[15:38:05(UTC+06:00)]:E:bsp: ******* E N D of Error message *******
and the bshell log has

2008-06-04[15:38:10(UTC+06:00)]:E:bsp: ******* S T A R T of Error message *******
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Log message called from /view/port.7.1d.10/vobs/tt/mir/mir/main.c: #1105 keyword: 4GL/3GL P
rocess information:
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Pid 5701682 Uid 125 Euid 125 Gid 125 Egid 125 Pset mchowell@CD1-01MCHOWELL:2612
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Errno 32 (There is no process to read data written to a pipe.) bdb_errno 0
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Active session: 10.o
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Company number: 801
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Executing 3GL function: db.create.table
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Stack information:
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Object Name: /baan_users/Exchange/progs/fin005/10.o
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: 4GL/3GL Stack Trace
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: create.tables() (object /baan_users/Exchange/progs/fin005/10.o)
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: runtm_imp.main() (object otudllruntm_imp)
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: <0>() (object /baan_users/Exchange/progs/fin005/10.o)
2008-06-04[15:38:10(UTC+06:00)]:E:bsp:
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: ******* E N D of Error message *******
2008-06-04[15:38:10(UTC+06:00)]:E:bsp:
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: ******* S T A R T of Error message *******
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Log message called from /view/port.7.1d.10/vobs/tt/lib/nw_1/ipc_fdio.c: #225 keyword: IPC
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Pid 5701682 Uid 125 Euid 125 Gid 125 Egid 125 Pset mchowell@CD1-01MCHOWELL:2612
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: user_type S language 5 user_name bsp tty ote locale ISO88591/NULL
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Errno 32 (There is no process to read data written to a pipe.) bdb_errno 0
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: Log_mesg: Connection to server lost: fd_write 11: num_bytes -1 errno 32
2008-06-04[15:38:10(UTC+06:00)]:E:bsp: ******* E N D of Error message *******

Does anyone know what it means??

looks like your driver is crashing while creating a table.

I know i've seen it before, but it's been a while.

Could be your porting set version.
Could be the $ORACLE_HOME permissions not being opened enough.
or it could be ulimits on the box.

Dave

Actually, i made a re installation of oracle, before i didnt have this problem, i could make exchenge without problem, but after the reinstallation i get this error, if i connect via sqlplus with the same oracle user as baan, this can create, insert, etc on the data base but, the only problem its at the time of an Exchange import.
The portingset its the same than before the reinstallation
$ ora8_srv6.2 -v
-------------------------------------------------------
Portingset : 7.1d.10
Port no. : PA.2791
Date : Tue Jul 5 13:22:03 DFT 2005
Uname : AIX orion 1 5 000B0E68A400
Machine-id : IBM_RS6000
OS-release : AIX5.1

You say, check the $ORACLE_HOME, but i have a doubt which folder need to have permissions ???
And the ulimits ?? for the bsp user???
$ ulimit -a
time(seconds) unlimited
file(blocks) 16777208
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000


I hope you can remember how to solve this, thanks

Regards

mchowell

Look on metalink for Oracle 9i permissions. I think they deliver a script that fixes them (So you don't have to) you might actually find some discussion about it on baanboard too.

If you re-installed oracle and that's all that's changed, then it's a decent guess that - that is your problem.

Dave

Hi, i finally solve this problem, its an oracle permission, you have to change at OS level the permissions to the lib and lib32 directories on $ORACLE_HOME

chmod o+xr ${ORACLE_HOME}/lib/*
chmod o+xr ${ORACLE_HOME}/lib32/*

Restart oracle and baan and that´s all.

Hope this work, if someone have the same problem, to execute exchanges, create o drop tables from baan to oracle.