Getting Connection Close error for Oracle DB while loading table from source to destination

[Anonymous]

Getting Connection Close error for Oracle DB while loading table from source to destination

Below is the error log:

### Job STARTED at 2018/09/12 08:19:11 (jobId=20180912_081826_fShUG, jobExecutionId=20180912081911_bdEo5) ###
[INFO ]: local_project.job_stg_inc_xla_dist_links_load_0_1.Job_Stg_Inc_Xla_Dist_Links_Load - TalendJob: 'Job_Stg_Inc_Xla_Dist_Links_Load' - Start.
[statistics] connecting to socket on port 10149
[statistics] connected
12-09-2018 8:19:15
[INFO ]: local_project.job_stg_inc_xla_dist_links_load_0_1.Job_Stg_Inc_Xla_Dist_Links_Load - tOracleRow_2 - Execute the query: 'BEGIN
UPDATE CONTROL_TABLE SET LOAD_STATUS = 'IN PROGRESS'
WHERE TABLE_NAME = 'XLA_DISTRIBUTION_LINKS';

INSERT INTO DW_LOAD_HIST (JOB_ID, TABLE_NAME, LOAD_TYPE , START_TIME,END_TIME,LOAD_STATUS)
VALUES (-999, 'STG_XLA_DIST_LINKS','INCREMENTAL',TO_DATE('12-09-2018 8:19:15','DD-MM-YYYY HH:MIS'),NULL,'STARTED');

EXECUTE IMMEDIATE 'TRUNCATE TABLE STG_XLA_DIST_LINKS';
EXECUTE IMMEDIATE 'ALTER TABLE STG_XLA_DIST_LINKS MODIFY ROW_ID GENERATED AS IDENTITY ( START WITH 1)';
COMMIT;
END;
' has finished.

### Job ENDED WITH ERROR at 2018/09/12 14:01:54 (jobId=20180912_081826_fShUG, jobExecutionId=20180912081911_bdEo5) ###
[FATAL]: local_project.job_stg_inc_xla_dist_links_load_0_1.Job_Stg_Inc_Xla_Dist_Links_Load - tOracleInput_1 Closed Connection
[statistics] disconnected
Exception in component tOracleInput_1
java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:6295)
at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1364)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1343)
at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:100)
at local_project.job_stg_inc_xla_dist_links_load_0_1.Job_Stg_Inc_Xla_Dist_Links_Load.tOracleInput_1Process(Job_Stg_Inc_Xla_Dist_Links_Load.java:4706)
at local_project.job_stg_inc_xla_dist_links_load_0_1.Job_Stg_Inc_Xla_Dist_Links_Load.tOracleRow_2Process(Job_Stg_Inc_Xla_Dist_Links_Load.java:2770)
at local_project.job_stg_inc_xla_dist_links_load_0_1.Job_Stg_Inc_Xla_Dist_Links_Load.tOracleInput_4Process(Job_Stg_Inc_Xla_Dist_Links_Load.java:2534)
at local_project.job_stg_inc_xla_dist_links_load_0_1.Job_Stg_Inc_Xla_Dist_Links_Load.tJava_1Process(Job_Stg_Inc_Xla_Dist_Links_Load.java:2275)
at local_project.job_stg_inc_xla_dist_links_load_0_1.Job_Stg_Inc_Xla_Dist_Links_Load.runJobInTOS(Job_Stg_Inc_Xla_Dist_Links_Load.java:5425)
at local_project.job_stg_inc_xla_dist_links_load_0_1.Job_Stg_Inc_Xla_Dist_Links_Load.main(Job_Stg_Inc_Xla_Dist_Links_Load.java:5172)

Table is having 13 million rows.

Can anyone help with this issue

[Anonymous]

Hello,

Have you tried to increase the timeout of your connection to see if it works?

Best regards

Sabrina