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

Anonymous — Fri, 14 Sep 2018 10:50:49 GMT

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

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

Anonymous — Mon, 17 Sep 2018 04:37:57 GMT

Hello,

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

Best regards

Sabrina

topic Getting Connection Close error for Oracle DB while loading table from source to destination in Talend Studio

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

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