Solved

What might be causing this ORA buffer error in Informatica?

Posted on 2011-03-11
1
926 Views
Last Modified: 2012-06-21
A particular Informatica session is commonly experiencing the following error:

ORA-24306: bad buffer for piece

The common belief seems to be that this is an Informatica problem, not an Oracle problem.  Granted, we are reading in some very large columns as part of the session.  Certainly there are memory mismanagement issues.

That said, how is it possible that the Oracle side can report a buffer problem, and the problem exist in Informatica?  In other words, how can Oracle throw this error UNLESS the problem is in Oracle alone?  
0
Comment
Question by:iluomo227
1 Comment
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 35109458
>> In other words, how can Oracle throw this error UNLESS the problem is in Oracle alone?  

I know nothing about infomratica but wanted to comment on the above piece of the question.

Oracle is likely just the messenger.

For example.  In the below example, Oracle returns the error.  Who's fault is it?

create table tab1(col1 char(1));
insert into tab1 values('aa');
ERROR at line 1:
ORA-12899: value too large for column "BUD"."TAB1"."COL1" (actual: 2, maximum: 1)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ORA-12560: TNS:protocol adapter error 8 83
sql query 9 38
Question About Creating Primary Key Constraints on Oracle Tables... 5 38
Oracle Listener Not Starting 11 25
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now