?
Solved

What might be causing this ORA buffer error in Informatica?

Posted on 2011-03-11
1
Medium Priority
?
961 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1000 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

777 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