0 Replies Latest reply on Oct 5, 2020 10:50 AM by Uttej Gouri

    How to keep Azure SQL Server connection live in Informatica Cloud - when runajobcli triggers task

    Uttej Gouri New Member

      Hi,

       

      I'm having a stored procedure(SP) executed within Mapping which is taking around 45 mins and the SP has output (Select columns). Based on the operations within SP, output is generated and is used to update value in SQL Server table.

      During the SP execution the Informatica Cloud job is failing to keep the connection live.

      Is there any way to keep the connection alive? How to do that?

      Is there a property KeepAlive/ timeout property for Informatica Cloud Agent?

       

      Server: Azure SQL Server

      Mapping Task Error:

      RR_4035 SQL Error [ FnName: Execute -- [Informatica][ODBC SQL Server Wire Protocol driver]Socket closed. FnName: Execute -- [Informatica][ODBC SQL Server Wire Protocol driver]SSL I/O Error. FnName: Execute -- [Informatica][ODBC SQL Server Wire Protocol driver]01006].