Solved

What might be causing this ORA error in Informatica??

Posted on 2011-03-10
3
2,250 Views
Last Modified: 2012-05-11
Why would a query, run in sqlplus or Toad, run just fine....   but then the same query run by Informatica against the same DB cause the following error??

ORA-29275: partial multibyte character

Following is an exerpt of the session's log file:

32011-03-10 11:41:18 : ERROR : (18198 | READER_1_1_1) : (IS | ISVC_ISS_AU_01) : Node_AU01_g3u1675c : RR_4035 : SQL Error [
ORA-29275: partial multibyte character

ORA-29275: partial multibyte character

Database driver error...
Function Name : Fetch
SQL Stmt : SELECT ODS_CM3RM1_D_VW.NUMBERHPSW, ODS_CM3RM1_D_VW.PAGE, .......

Open in new window


At the very least, does anyone have a way to figure out how to determine what record is causing the problem?  The query is a simple select from a single table... no joins... no where clauses... it might as well be a simple "select *" query.

Thanks,
iluomo
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
3 Comments
 
LVL 7

Expert Comment

by:MrNed
ID: 35101578
I guess you are using some Unicode character set. I'm not familiar with Informatica, but can you confirm it supports the character set you are using?
0
 
LVL 5

Assisted Solution

by:jaiminpsoni
jaiminpsoni earned 125 total points
ID: 35103594
Check this if it helps.

http://infapc.blogspot.com/2009/05/informatica-session-fails-with-rr4035.html

To figure out what record is causing problem, try restricting the count of rows returned by the query using some where condition.

I am not familiar with informatica, but in oracle we have rownum to get first N rows.

Suppose table has 1000 rows, retrieve first 100 rows, first 200 rows.... Not really efficient, but you will be able to figure out which record is causing problem using this way.

0
 
LVL 2

Accepted Solution

by:
preraksheth earned 125 total points
ID: 35103775
First step: Determine which column is causing the problem, by issuing column by column query instead of * or all columns
Second step: Once the column is found (after adding the column, you should get the problem, and after removing, you should not), limit records by using where clause - the where clause will depend on the column properties, but the best candidate is the primary key column. Say you have a numeric primary key, then you can directly put a between clause to limit record.
This way you should be able to find the exact value causing the problem. Then update the record to something acceptable, and you are done
0

Featured Post

Veeam gives away 10 full conference passes

Veeam is a VMworld 2017 US & Europe Platinum Sponsor. Enter the raffle to get the full conference pass. Pass includes the admission to all general and breakout sessions, VMware Hands-On Labs, Solutions Exchange, exclusive giveaways and the great VMworld Customer Appreciation Part

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…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

617 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