After Infomatica Upgrade The Data Load Is Skipping Some Data During ETL Extract

(Doc ID 2191637.1)

Last updated on OCTOBER 18, 2017

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


OBIA version:
DAC Version:
Database version: MS SQL Server 2008 R2

After Informatica upgrade from 9.1.0 to 9.6.1, we are seeing some different ETL behavior where the data pull is skipping the data with a data column length greater than 4000 characters.

The log has the below details:

Severity: ERROR
Timestamp: 8/4/2016 5:01:33 PM
Node: node01_DND
Thread: READER_1_1_1
Process ID: 296
Message Code: RR_4053
Message: Row error occured while fetching data from database.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms