Solved

What might be causing this ORA error in Informatica??

Posted on 2011-03-10
3
2,175 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
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
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

685 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