DB connection (SybConnectionDeadException: JZ0C0 ) closed error while running data profiling --> Talend Data profile
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.
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 🙂
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.
