topic DB connection (SybConnectionDeadException: JZ0C0 ) closed error while running data profiling --> Talend Data profile in Data Quality

DB connection (SybConnectionDeadException: JZ0C0 ) closed error while running data profiling --> Talend Data profile

Anonymous — Sat, 16 Nov 2024 07:20:07 GMT

I am using data profiling feature of Talend MDM studio (v6.4.1) to profile data stored in Sybase Database.

I am trying to run simple column analysis to find count , null , value frequency against one column . There are approx 120 million data in that particular table.

So data profiling runs for 2 hours and after that get DB connection closed error.
!ENTRY org.talend.platform.logging 4 0 2018-11-08 00:27:21.324
!MESSAGE 2018-11-08 00:27:21,324 ERROR org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor - java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.

Appreciate your any help on this.

Re: DB connection (SybConnectionDeadException: JZ0C0 ) closed error while running data profiling --> Talend Data profile

Anonymous — Sat, 10 Nov 2018 17:33:41 GMT

Hi,

Could you please ask the Sybase DBAs what is the current session timeout set? The reason could be because DB query was running for longer time and it must have crossed the threshold time set by the DBAs for database sessions.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: DB connection (SybConnectionDeadException: JZ0C0 ) closed error while running data profiling --> Talend Data profile

Anonymous — Sun, 11 Nov 2018 13:18:08 GMT

Thanks Nikhil for reply and would check for it. I also need help on this.
I am trying to limit rows to profile through Talend Studio and used some combination but do not get any luck . Could you please help me on this.
I tried below things. Is there any other way to limit the roww to profile ? Say, there are 1 million data in one table but I would like to run profile on 100K (100,000) records so how to do this ?
1. Change the limit under data preview section but the limit can only be 3 digits, so the max is 999.

2. Change execution engine into Jave and get another option to set rows but it also did not work out.

Re: DB connection (SybConnectionDeadException: JZ0C0 ) closed error while running data profiling --> Talend Data profile

Anonymous — Sun, 11 Nov 2018 15:16:58 GMT

Hi,

Could you please add some screen shots of your current setup so that we will get more idea about your current profiling configuration?

Warm Regards,

Nikhil Thampi