[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

What might be causing this ORA buffer error in Informatica?

Posted on 2011-03-11
1
Medium Priority
?
979 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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.  …
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 how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

650 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