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

One Star

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

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:MISmiley FrustratedS'),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

Moderator

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

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch