Informatica sessions Terminated unexpectedly (Doc ID 2119167.1)

Last updated on AUGUST 12, 2016

Applies to:

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

Symptoms

ETL terminates with the following errors:

ERROR:
=======

2016-03-13 23:31:35 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : REP_12400 : Repository Error ([REP_55115] Still trying to connect to the Repository Service [ajgprod_rep]. The remaining resilience time is 114 seconds.)
2016-03-13 23:31:41 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : REP_12400 : Repository Error ([REP_12164] Domain-related error: [[PCSF_46008] Cannot connect to gateway to look up service [ajgprod_rep]. [FAULT_PCSFTIMEOUTEXCEPTION]].)
2016-03-13 23:32:41 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : REP_12400 : Repository Error ([REP_55115] Still trying to connect to the Repository Service [ajgprod_rep]. The remaining resilience time is 48 seconds.)
2016-03-13 23:32:47 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : REP_12400 : Repository Error ([REP_12164] Domain-related error: [[PCSF_46008] Cannot connect to gateway to look up service [ajgprod_rep]. [FAULT_PCSFTIMEOUTEXCEPTION]].)
2016-03-13 23:33:29 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : REP_12400 : Repository Error ([REP_55112] Unable to connect to the Repository Service [ajgprod_rep] since the resilience time is up.)
2016-03-13 23:33:29 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : REP_12400 : Repository Error (Failed to connect to repository service [ajgprod_rep].)
2016-03-13 23:33:29 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : REP_12014 : An error occurred while accessing the repository
2016-03-13 23:33:29 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : REP_12400 : Repository Error (Failed to connect to repository service [ajgprod_rep].)
2016-03-13 23:33:29 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : REP_12400 : Repository Error ([REP_55102] Failed to connect to repository service [ajgprod_rep].)
2016-03-13 23:33:29 : ERROR : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : VAR_27040 : Error: failed to delete existing persisted mapping variable value(s) for session [AJG_PLP_EmployeeDimension_Soft_Delete] from the repository.
2016-03-13 23:33:29 : INFO : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : TM_6063 : An error occurred updating repository tables.
2016-03-13 23:33:29 : INFO : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : TM_6022 :

SESSION LOAD SUMMARY
================================================

2016-03-13 23:33:29 : INFO : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : TM_6252 : Source Load Summary.
2016-03-13 23:33:29 : INFO : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : CMN_1740 : Table: [SQ_w_employee_d] (Instance Name: [SQ_w_employee_d])
Output Rows [93073], Affected Rows [93073], Applied Rows [93073], Rejected Rows [0]
2016-03-13 23:33:29 : INFO : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : TM_6253 : Target Load Summary.
2016-03-13 23:33:29 : INFO : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : CMN_1740 : Table: [W_EMPLOYEE_D] (Instance Name: [w_employee_d1])
Output Rows [93073], Affected Rows [93073], Applied Rows [93073], Rejected Rows [0]
2016-03-13 23:33:29 : INFO : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : TM_6023 :
===================================================

2016-03-13 23:33:29 : INFO : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : TM_6020 : Session [AJG_PLP_EmployeeDimension_Soft_Delete] completed at [Sun Mar 13 23:31:16 2016].
2016-03-13 23:39:03 : ERROR : (31705 | DIRECTOR) : (IS | ajgprodetl_integration) : node01_db3243 : TM_6775 : The master DTM process was unable to connect to the master service process to update the session status with the following message: error message [ERROR: The request to track the session [Session task instance [AJG_PLP_EmployeeDimension_Soft_Delete]] and [ folder id = 28, workflow id = 31024, workflow run id = 350526, worklet run id = 0, task instance id = 19778 ] is invalid. The master service process that started this session is different from the current master.] and error code [1418].
2016-03-13 23:39:03 : ERROR : (31705 | ) : (IS | ajgprodetl_integration) : node01_db3243 : PETL_24074 : Failed to send updates to the master service process. Session run will be terminated.

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