• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Firewall Timeout with Jobs Stats & Logs and Oracle SID connection

#1 2010-06-10 18:23:24

dydom
New member
Registered: 2010-06-04
Posts: 2

Firewall Timeout with Jobs Stats & Logs and Oracle SID connection

Firewall Timeout with Jobs Stats & Logs and Oracle SID connection

Hi,
I have a problem with a firewall timeout when I run a long job using these stats & logs parameters (screenshot) in the job setting, with an Oracle with SID Connection (JDBC Thin).
There is a firewall between the server running talend job and the server with my Oracle Database.
When the job is too long (more than one hour), the firewall break the connection with the database where I log any Talend events (stats & logs job setting).
To keep my connection alive, I have already add these parameters on the Talend running job server :
In the SQLNET.ORA files : SQLNET.EXPIRE_TIME=1
In the TNSNAMES.ORA files : ENABLE=BROKEN parameter in the DESCRIPTION clause in the connect descriptor

In Talend, in the Additional parameters textbox, in Stat & Logs, I try to use this setting : “tcp_keepalive_interval=240000” (screenshot)

But that doesn’t work.

I got this error (with or without the tcp_keepalive_interval parameter) :

Exception in component talendMeter_DB
java.sql.SQLException: Exception d'E/S: Connection reset
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:255)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare
dStatement.java:826)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
nt.java:1039)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
redStatement.java:850)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1134)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3339)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:3384)
        at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.j
ava:2472)

Connexion interrompueException in component tRunJob_1

Talend Open Studio Version : 4.01
Oracle Database v10.g
OS of the Talend running job server : Windows Server 2003 R2 32 Bits

Could you help me to find a solution, maybe using additional parameters in Talend, or anything else. I don’t know how this parameters “tcp_keepalive_interval=240000” can be used with Talend Oracle with SID connection. Or if an external solution may be used ?
Thanks in advance.


Uploaded Images

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Firewall Timeout with Jobs Stats & Logs and Oracle SID connection

Board footer

Powered by FluxBB