Improve company productivity with a Business Account.Sign Up

x
?
Solved

What might be causing this ORA error in Informatica??

Posted on 2011-03-10
3
Medium Priority
?
2,415 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 500 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 500 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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

579 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