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 7.9.6.1 and later
Information in this document applies to any platform.

Symptoms

OBIA version: 7.9.6.1
DAC Version: 11.1.1.6.4.20141119.2119
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.

Cause

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