A new blog entry has been added:

BaanIVc4/Oracle 10g/Migration issues

We recently migrated our Baan IVc4 system from Oracle 9i to Oracle 10g and upgraded to porting set 6.1c.07.21 on a HP-UX 11:31 system.

 We are having problems with 3 customized sessions we developed for processing records from an external system.  The sessions poll external table (Baan views) and process records to try and make Baan real time. The problems we are experiencing didn’t happen prior to the migration.  Nothing with the sessions changed for the migration.

 Only one session actually errors (see below).  Our DBA said this error isn’t an Oracle 10g error.  We did have our programmer put the session in debug to figure out where the problem is happening.  It is happening on a simple select statement.

is there any other log information?

ORA 3106:

This link could be helpful:

http://www.dba-oracle.com/sf_ora_03106_fatal_two_task_communication_protocol_error.htm

Slow session time:
Maybe you have to update your statistics.

One known limitation with Oracle 10g (10.2.0.1):
ORA-1445: ANSI joins may fail. Can occur for ANSI join queries with large views / subqueries.
Restriction:
Max. 6 joins are allowed
Max. number of fields in the querry (exact value unknown).
Solution: Update to a higher version.

Regards,

Kozure