Go Back > Forum > CMS - Forum Integration > Blogs and Web links

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 50

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 8th May 2009, 20:11
jsbrouse jsbrouse is offline
Join Date: May 2009
Posts: 1
jsbrouse is on a distinguished road
Baan: Baan IVc4 - DB: Oracle 10g - OS: HP-UX 11.31
BaanIVc4/Oracle 10g/Migration issues

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.
Reply With Quote
Old 12th May 2009, 07:25
chuguangan chuguangan is offline
Junior Member
Join Date: Sep 2006
Posts: 4
chuguangan is on a distinguished road
Baan: IV - DB: oracle - OS: solaris
is there any other log information

is there any other log information?
Reply With Quote
Sponsored Links
Old 12th May 2009, 12:28
Kozure Ohashi's Avatar
Kozure Ohashi Kozure Ohashi is offline
Join Date: Dec 2003
Location: Tokyo-Otsuka
Posts: 324
Kozure Ohashi is on a distinguished road
Baan: Baan IV c4 SP 19, ERP LN 6.1 FP3 - DB: 10g R2 - OS: Linux SLES 10 64 Bit
Oracle 10g

ORA 3106:

This link could be helpful:

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

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



Last edited by Kozure Ohashi : 12th May 2009 at 15:19.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Could be printing issues between Windows Domains?? tnzabo Tools Administration & Installation 4 6th January 2008 18:40
Actual Issues by period calculation SeargantD Distribution, Transportation & Warehousing 0 18th December 2007 15:17
Are there any fundamental issues with Oracle skapoor73 Operating Systems & Databases 10 2nd February 2006 01:24
Some issues with BW on Citrix frankn Tools Administration & Installation 15 14th July 2004 17:05
Item Issues by Period - by date staugner Tools Development 13 20th November 2002 18:57

All times are GMT +2. The time now is 15:10.

©2001-2018 - -