Solved

What might be causing this ORA buffer error in Informatica?

Posted on 2011-03-11
1
938 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Pivot Question 8 71
Shredding xml into an oracle 11g Database 2 58
MULTIPLE DATE QUERY 15 91
oracle DR - data guard failover. 18 45
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to take different types of Oracle backups using RMAN.

808 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