Baanboard.com

Go Back   Baanboard.com > Forum > CMS - Forum Integration > Blogs and Web links

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th May 2009, 21:11
jsbrouse jsbrouse is offline
Newbie
 
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

Quote:
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
Sponsored Links
  #2  
Old 12th May 2009, 08: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
  #3  
Old 12th May 2009, 13:28
Kozure Ohashi's Avatar
Kozure Ohashi Kozure Ohashi is offline
Guru
 
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:

http://www.dba-oracle.com/sf_ora_031...ocol_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

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


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 19:40
Actual Issues by period calculation SeargantD Distribution, Transportation & Warehousing 0 18th December 2007 16:17
Are there any fundamental issues with Oracle 9.2.0.5? skapoor73 Operating Systems & Databases 10 2nd February 2006 02:24
Some issues with BW on Citrix frankn Tools Administration & Installation 15 14th July 2004 18:05
Item Issues by Period - by date staugner Tools Development 13 20th November 2002 19:57


All times are GMT +2. The time now is 02:30.


©2001-2017 - Baanboard.com - Baanforums.com