Hi.

I am in the process of migrating a Baan installation from Informix to Oracle (9.2.0.4.0). The OS is W2k.

The database was created separately and then connected baan to the created instance manually.

Was able to load the 000 company using bdbpost.

However, when doing some operations in Baan like Installing a patch with 50 precedences, the bw session hangs. The error appears in random circumstances.
No errors appear on Oracle neither on W2k Event Viewer...

Can someone take a look at the db_resource we are using and see if there is something stange over there ? (DB is Oracle 9.2.0.4.0).

Here is the DB_resource....

ora_init:0111000
dbsinit:021
ora_timeout:{60,60,60,60,60}
ora_max_array_insert:2
ora_max_array_fetch:2
rds_full:2
lock_retry:0

Thanks a lot
Fred

Well I think you should change the ora_timeout parameter to

ora_timeout: (999,999,999,999,999)

try this and check if the problem still exist.

- Ranias

Actually, ora_timeout is broken in windows, you need to unset it
and set lock_retry instead.


Dave

Hi.

Finally was able to test the suggestions.

Dave, you were right. After removing the parameter ora_timeout, did not get the BW hangs anymore.

Will keep it under surveillance but the problem seems to be solved..

Thanks to everyone.
Fred

Cool! glad it worked!

I received a very long explanation from baan development on that.. it's got to do with the # of connections baan opens with the driver and the oracle client libs killing them for no good reason..

Dave