Timeout Based Commit Point" Messages In The Informatica Session Log For Slow Performing Mappings As Too Much Data Is Being Processed And The Timeout Settings Are Not Set To a High Enough Value (Doc ID 1914620.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

This customer was facing the "TIMEOUT BASED COMMIT POINT" error message in their Informatica 9.0.1 Session Logs :-

2014-06-16 03:52:00 : INFO : (5309 | WRITER_1_*_1) : (IS | BIA_IS) : node01_biappsrapp01.xxx.net : WRT_8167 : Start loading table [W_GL_REVN_F] at: Mon Jun 16 02:21:59 2014
2014-06-16 03:53:00 : INFO : (5309 | WRITER_1_*_1) : (IS | BIA_IS) : node01_biappsrapp01.xxx.net : WRT_8165 : TIMEOUT BASED COMMIT POINT
2014-06-16 04:05:10 : INFO : (5309 | WRITER_1_*_1) : (IS | BIA_IS) : node01_biappsrapp01.xxx.net : WRT_8165 : TIMEOUT BASED COMMIT POINT
2014-06-16 04:10:48 : INFO : (5309 | WRITER_1_*_1) : (IS | BIA_IS) : node01_biappsrapp01.xxx.net : WRT_8165 : TIMEOUT BASED COMMIT POINT
2014-06-16 04:12:20 : INFO : (5309 | WRITER_1_*_1) : (IS | BIA_IS) : node01_biappsrapp01.xxx.net : WRT_8165 : TIMEOUT BASED COMMIT POINT
2014-06-16 04:14:55 : INFO : (5309 | WRITER_1_*_1) : (IS | BIA_IS) : node01_biappsrapp01.xxx.net : WRT_8165 : TIMEOUT BASED COMMIT POINT

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