My Oracle Support Banner

Informatica 10.2 Errors: CMN_1551/CMN_1792/CMN_1793 After Upgrading From 9.6.1 To 10.2.0 (Doc ID 2637989.1)

Last updated on FEBRUARY 12, 2020

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 to 7.9.6.4 [Release V7]
Information in this document applies to any platform.

Symptoms

Following recent Informatica upgrade from 9.6.1 to 10.2.0, now receiving the following error while running a full ETL load:

Example error from workflow log: SDE_ORA_EmployeeDimension_Full.log

TRANSF_1_1_1> TM_6085 A fatal error occurred at  transformation [mplt_BC_ORA_EmployeeDimension.Sq_Employees], and the session is terminating.
TRANSF_1_1_1> DBG_21511 TE: Fatal Transformation Error.
WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Feb 10 16:08:23 2020]
WRITER_1_*_1> CMN_1022 Database driver error...
CMN_1022 [
ORA-24795: Illegal ROLLBACK attempt made

Database driver error...
Function Name : Commit
Database driver error...
Function Name : Rollback]

WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Feb 10 16:08:23 2020]
WRITER_1_*_1> WRT_8183 Rollback failed for the target [WC_EMPLOYEE_EXT_DS, W_EMPLOYEE_DS]
WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Feb 10 16:08:23 2020]
WRITER_1_*_1> WRT_8170 Writer run terminated: Abort Session request received from the DTM
WRITER_1_*_1> WRT_8168 End loading table [WC_EMPLOYEE_EXT_DS] at: Mon Feb 10 16:08:23 2020
WRITER_1_*_1> WRT_8168 End loading table [W_EMPLOYEE_DS] at: Mon Feb 10 16:08:23 2020
WRITER_1_*_1> WRT_8035 Load complete time: Mon Feb 10 16:08:23 2020
.
.
MAPPING> CMN_1793 The index cache size that would hold [13614] rows in the lookup table for [mplt_BC_ORA_EmployeeDimension.Lkp_Work_Country], in memory, is [321200] bytes
MAPPING> CMN_1792 The data cache size that would hold [13614] rows in the lookup table for [mplt_BC_ORA_EmployeeDimension.Lkp_Work_Country], in memory, is [1867776] bytes
MAPPING> CMN_1793 The index cache size that would hold [248492] rows in the lookup table for [mplt_BC_ORA_EmployeeDimension.LKP_Leaving_Reason], in memory, is [19491840] bytes
MAPPING> CMN_1792 The data cache size that would hold [248492] rows in the lookup table for [mplt_BC_ORA_EmployeeDimension.LKP_Leaving_Reason], in memory, is [18030592] bytes
MAPPING> CMN_1793 The index cache size that would hold [38] rows in the lookup table for [mplt_BC_ORA_EmployeeDimension.Lkp_HR_lookups], in memory, is [8400] bytes
MAPPING> CMN_1792 The data cache size that would hold [38] rows in the lookup table for [mplt_BC_ORA_EmployeeDimension.Lkp_HR_lookups], in memory, is [16384] bytes
MAPPING> CMN_1793 The index cache size that would hold [0] rows in the lookup table for [MPLT_EMPLOYEE_EXTENSION_INS_REJ.LKPTRANS], in memory, is [23040] bytes
MAPPING> CMN_1792 The data cache size that would hold [0] rows in the lookup table for [MPLT_EMPLOYEE_EXTENSION_INS_REJ.LKPTRANS], in memory, is [16384] bytes
.

Changes

 Upgrading Informatica 9.6.1 to 10.2.0

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.