One Star

Caanot connect to netezza

I am trying to connect to a Netezza database. looking on other forums i found that I needed to obtain the netezza driver nzjdbc.jar and copy it to a specific location
i have installed the netezza driver in program files\java\jdk1.7.0\jre\lib
but I am still getting Driver not found: org.netezza.Driver errors
I guess I am missing something. Please can you help?
Thanks
4 REPLIES
Employee

Re: Caanot connect to netezza

Hi there,
Sounds like you have the appropriate JDBC driver, but you need to deploy it where Talend can see it rather than inside the JDK. There is a link below to a post where another user had the same question: can you try these steps and let us know how you get on?
http://www.talendforge.org/forum/viewtopic.php?id=16495
One Star

Re: Caanot connect to netezza

I can now connect to the Netezza database but when I tried to do a statistical analysis on a single column, I got an error - At least one analysis execution failed, check the error logs for more details.
I have included the entries in the log from when I tried to run the analyse below
Please can you help?
Thanks
Tracey

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:00.557
!MESSAGE 2011-08-03 16:36:00,557 INFO org.talend.dq.analysis.AnalysisExecutor - Connection tojdbc:netezza://10.156.11.205:5480/COBAL_ODS_DEV

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:14.760
!MESSAGE 2011-08-03 16:36:14,760 INFO org.talend.cwm.management.connection.DatabaseContentRetriever - Database Product Name:Netezza NPS

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:14.760
!MESSAGE 2011-08-03 16:36:14,760 INFO org.talend.cwm.management.connection.DatabaseContentRetriever - Database Product Name:Release 4.6.8 (P-4)

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:36.854
!MESSAGE 2011-08-03 16:36:36,854 INFO org.talend.dq.analysis.ConnectionPool - Create a new connection pool...

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:36.869
!MESSAGE 2011-08-03 16:36:36,869 INFO org.talend.dq.analysis.ConnectionPool - create connections and add those connections to the connection pool.

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:51.869
!MESSAGE 2011-08-03 16:36:51,869 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Row Count

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.354
!MESSAGE 2011-08-03 16:36:52,354 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:52.369
!MESSAGE 2011-08-03 16:36:52,369 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Minimal Length With Blank and Null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.666
!MESSAGE 2011-08-03 16:36:52,369 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:52.666
!MESSAGE 2011-08-03 16:36:52,666 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT COUNT(*) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:52.682
!MESSAGE 2011-08-03 16:36:52,682 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.682
!MESSAGE 2011-08-03 16:36:52,682 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Row Count" SQL query: SELECT COUNT(*) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.682
!MESSAGE 2011-08-03 16:36:52,666 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.682
!MESSAGE 2011-08-03 16:36:52,651 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:52.682
!MESSAGE 2011-08-03 16:36:52,682 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Minimal Length With Blank

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:52.698
!MESSAGE 2011-08-03 16:36:52,682 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT MIN(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:52.698
!MESSAGE 2011-08-03 16:36:52,698 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.698
!MESSAGE 2011-08-03 16:36:52,698 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Minimal Length With Blank and Null" SQL query: SELECT MIN(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.698
!MESSAGE 2011-08-03 16:36:52,698 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:52.713
!MESSAGE 2011-08-03 16:36:52,713 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT MIN(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:52.713
!MESSAGE 2011-08-03 16:36:52,713 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.713
!MESSAGE 2011-08-03 16:36:52,713 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Minimal Length With Blank" SQL query: SELECT MIN(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.713
!MESSAGE 2011-08-03 16:36:52,713 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:52.713
!MESSAGE 2011-08-03 16:36:52,713 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Minimal Length With Null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.729
!MESSAGE 2011-08-03 16:36:52,729 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:52.729
!MESSAGE 2011-08-03 16:36:52,729 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT MIN(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:52.729
!MESSAGE 2011-08-03 16:36:52,729 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.744
!MESSAGE 2011-08-03 16:36:52,729 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Minimal Length With Null" SQL query: SELECT MIN(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:52.744
!MESSAGE 2011-08-03 16:36:52,744 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:52.760
!MESSAGE 2011-08-03 16:36:52,760 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Maximal Length With Blank and Null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.010
!MESSAGE 2011-08-03 16:36:53,010 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:53.010
!MESSAGE 2011-08-03 16:36:53,010 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Maximal Length With Null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.260
!MESSAGE 2011-08-03 16:36:53,010 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:53.260
!MESSAGE 2011-08-03 16:36:53,260 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT MAX(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:53.260
!MESSAGE 2011-08-03 16:36:53,260 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.260
!MESSAGE 2011-08-03 16:36:53,260 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Maximal Length With Blank and Null" SQL query: SELECT MAX(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.260
!MESSAGE 2011-08-03 16:36:53,260 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:53.276
!MESSAGE 2011-08-03 16:36:53,276 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT MAX(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:53.276
!MESSAGE 2011-08-03 16:36:53,276 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.276
!MESSAGE 2011-08-03 16:36:53,276 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Maximal Length With Null" SQL query: SELECT MAX(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.276
!MESSAGE 2011-08-03 16:36:53,260 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:53.291
!MESSAGE 2011-08-03 16:36:53,291 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Maximal Length With Blank

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.526
!MESSAGE 2011-08-03 16:36:53,526 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:53.541
!MESSAGE 2011-08-03 16:36:53,541 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Average Length With Blank and Null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.776
!MESSAGE 2011-08-03 16:36:53,526 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.791
!MESSAGE 2011-08-03 16:36:53,776 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.791
!MESSAGE 2011-08-03 16:36:53,776 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:53.791
!MESSAGE 2011-08-03 16:36:53,791 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT SUM(CHAR_LENGTH("ADDRESSLINE1")), COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:53.791
!MESSAGE 2011-08-03 16:36:53,791 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT MAX(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:53.807
!MESSAGE 2011-08-03 16:36:53,791 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - java.lang.NullPointerException
!STACK 0
java.lang.NullPointerException
at org.netezza.internal.NzSocket.receiveByte(NzSocket.java:152)
at org.netezza.internal.NzSocket.receiveChar(NzSocket.java:170)
at org.netezza.sql.NzConnection.clearSocket(NzConnection.java:797)
at org.netezza.internal.QueryExecutor.sendQuery(QueryExecutor.java:442)
at org.netezza.internal.QueryExecutor.execute(QueryExecutor.java:72)
at org.netezza.sql.NzConnection.execute(NzConnection.java:2613)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:53.807
!MESSAGE 2011-08-03 16:36:53,807 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Average Length With Blank and Null" SQL query: SELECT SUM(CHAR_LENGTH("ADDRESSLINE1")), COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:53.807
!MESSAGE 2011-08-03 16:36:53,791 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Average Length With Null

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:54.057
!MESSAGE 2011-08-03 16:36:53,791 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - java.lang.NullPointerException
!STACK 0
java.lang.NullPointerException
at org.netezza.internal.NzSocket.receiveByte(NzSocket.java:152)
at org.netezza.internal.NzSocket.receiveChar(NzSocket.java:170)
at org.netezza.sql.NzConnection.clearSocket(NzConnection.java:797)
at org.netezza.internal.QueryExecutor.sendQuery(QueryExecutor.java:442)
at org.netezza.internal.QueryExecutor.execute(QueryExecutor.java:72)
at org.netezza.sql.NzConnection.execute(NzConnection.java:2613)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.073
!MESSAGE 2011-08-03 16:36:54,057 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Maximal Length With Blank" SQL query: SELECT MAX(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.073
!MESSAGE 2011-08-03 16:36:54,057 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.073
!MESSAGE 2011-08-03 16:36:54,057 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.073
!MESSAGE 2011-08-03 16:36:54,073 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Average Length With Blank

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.307
!MESSAGE 2011-08-03 16:36:54,073 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT SUM(CHAR_LENGTH("ADDRESSLINE1")), COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.323
!MESSAGE 2011-08-03 16:36:54,307 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.323
!MESSAGE 2011-08-03 16:36:54,307 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.323
!MESSAGE 2011-08-03 16:36:54,323 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT SUM(CHAR_LENGTH("ADDRESSLINE1")), COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:54.323
!MESSAGE 2011-08-03 16:36:54,323 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:54.323
!MESSAGE 2011-08-03 16:36:54,323 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - java.lang.NullPointerException
!STACK 0
java.lang.NullPointerException
at org.netezza.internal.NzSocket.receiveByte(NzSocket.java:152)
at org.netezza.internal.NzSocket.receiveChar(NzSocket.java:170)
at org.netezza.sql.NzConnection.clearSocket(NzConnection.java:797)
at org.netezza.internal.QueryExecutor.sendQuery(QueryExecutor.java:442)
at org.netezza.internal.QueryExecutor.execute(QueryExecutor.java:72)
at org.netezza.sql.NzConnection.execute(NzConnection.java:2613)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.323
!MESSAGE 2011-08-03 16:36:54,323 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Maximal Length

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.573
!MESSAGE 2011-08-03 16:36:54,323 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Average Length With Blank" SQL query: SELECT SUM(CHAR_LENGTH("ADDRESSLINE1")), COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.588
!MESSAGE 2011-08-03 16:36:54,323 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Average Length With Null" SQL query: SELECT SUM(CHAR_LENGTH("ADDRESSLINE1")), COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.604
!MESSAGE 2011-08-03 16:36:54,573 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.604
!MESSAGE 2011-08-03 16:36:54,604 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Minimal Length

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.604
!MESSAGE 2011-08-03 16:36:54,573 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.854
!MESSAGE 2011-08-03 16:36:54,854 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT MAX(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:54.854
!MESSAGE 2011-08-03 16:36:54,854 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.854
!MESSAGE 2011-08-03 16:36:54,854 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Maximal Length" SQL query: SELECT MAX(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.869
!MESSAGE 2011-08-03 16:36:54,854 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.869
!MESSAGE 2011-08-03 16:36:54,869 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Average Length

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.869
!MESSAGE 2011-08-03 16:36:54,854 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.885
!MESSAGE 2011-08-03 16:36:54,885 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT MIN(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:54.885
!MESSAGE 2011-08-03 16:36:54,885 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.885
!MESSAGE 2011-08-03 16:36:54,885 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Minimal Length" SQL query: SELECT MIN(CHAR_LENGTH("ADDRESSLINE1")) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.916
!MESSAGE 2011-08-03 16:36:54,869 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.916
!MESSAGE 2011-08-03 16:36:54,916 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT SUM(CHAR_LENGTH("ADDRESSLINE1")), COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:54.916
!MESSAGE 2011-08-03 16:36:54,916 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.916
!MESSAGE 2011-08-03 16:36:54,916 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Average Length" SQL query: SELECT SUM(CHAR_LENGTH("ADDRESSLINE1")), COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:54.932
!MESSAGE 2011-08-03 16:36:54,901 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:54.932
!MESSAGE 2011-08-03 16:36:54,932 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Frequency Table

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.166
!MESSAGE 2011-08-03 16:36:55,166 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:55.166
!MESSAGE 2011-08-03 16:36:55,166 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT "ADDRESSLINE1", COUNT(*) c FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT" t GROUP BY "ADDRESSLINE1" ORDER BY c DESC

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:55.182
!MESSAGE 2011-08-03 16:36:55,182 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.182
!MESSAGE 2011-08-03 16:36:55,182 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Frequency Table" SQL query: SELECT "ADDRESSLINE1", COUNT(*) c FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT" t GROUP BY "ADDRESSLINE1" ORDER BY c DESC

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.182
!MESSAGE 2011-08-03 16:36:55,166 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:55.182
!MESSAGE 2011-08-03 16:36:55,182 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Blank Count

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.432
!MESSAGE 2011-08-03 16:36:55,432 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:55.432
!MESSAGE 2011-08-03 16:36:55,432 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Duplicate Count

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.682
!MESSAGE 2011-08-03 16:36:55,432 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.698
!MESSAGE 2011-08-03 16:36:55,682 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:55.698
!MESSAGE 2011-08-03 16:36:55,698 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Unique Count

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.948
!MESSAGE 2011-08-03 16:36:55,682 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:55.948
!MESSAGE 2011-08-03 16:36:55,948 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT COUNT(*) FROM (SELECT "ADDRESSLINE1", COUNT(*) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT" m GROUP BY "ADDRESSLINE1" HAVING COUNT(*) > 1) AS myquery

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:55.948
!MESSAGE 2011-08-03 16:36:55,948 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.948
!MESSAGE 2011-08-03 16:36:55,948 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Duplicate Count" SQL query: SELECT COUNT(*) FROM (SELECT "ADDRESSLINE1", COUNT(*) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT" m GROUP BY "ADDRESSLINE1" HAVING COUNT(*) > 1) AS myquery

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.963
!MESSAGE 2011-08-03 16:36:55,932 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:55.963
!MESSAGE 2011-08-03 16:36:55,932 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:55.963
!MESSAGE 2011-08-03 16:36:55,963 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Distinct Count

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:56.213
!MESSAGE 2011-08-03 16:36:55,698 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT" WHERE TRIM("ADDRESSLINE1") = ''

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:56.213
!MESSAGE 2011-08-03 16:36:56,213 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:56.229
!MESSAGE 2011-08-03 16:36:56,213 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Problem when changing trying to set catalog " COBAL_ODS_DEV " on connection. RuntimeException message: null

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:56.229
!MESSAGE 2011-08-03 16:36:55,963 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT COUNT(*) FROM (SELECT "ADDRESSLINE1", COUNT(*) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT" GROUP BY "ADDRESSLINE1" HAVING COUNT(*) = 1) AS myquery

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:56.229
!MESSAGE 2011-08-03 16:36:56,229 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:56.229
!MESSAGE 2011-08-03 16:36:56,229 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Unique Count" SQL query: SELECT COUNT(*) FROM (SELECT "ADDRESSLINE1", COUNT(*) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT" GROUP BY "ADDRESSLINE1" HAVING COUNT(*) = 1) AS myquery

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:56.229
!MESSAGE 2011-08-03 16:36:56,229 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Computing indicator: Null Count

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:56.244
!MESSAGE 2011-08-03 16:36:56,229 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT COUNT(DISTINCT "ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:56.244
!MESSAGE 2011-08-03 16:36:56,213 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - org.netezza.error.NzSQLException: netezza.con.closed
!STACK 0
org.netezza.error.NzSQLException: netezza.con.closed
at org.netezza.sql.NzConnection.execute(NzConnection.java:2601)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 2 0 2011-08-03 16:36:56.244
!MESSAGE 2011-08-03 16:36:56,244 WARN org.talend.dq.analysis.ColumnAnalysisSqlExecutor - java.lang.NullPointerException
!STACK 0
java.lang.NullPointerException
at org.netezza.internal.NzSocket.receiveByte(NzSocket.java:152)
at org.netezza.internal.NzSocket.receiveChar(NzSocket.java:170)
at org.netezza.sql.NzConnection.clearSocket(NzConnection.java:797)
at org.netezza.internal.QueryExecutor.sendQuery(QueryExecutor.java:442)
at org.netezza.internal.QueryExecutor.execute(QueryExecutor.java:72)
at org.netezza.sql.NzConnection.execute(NzConnection.java:2613)
at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
at org.netezza.sql.NzStatement.execute(NzStatement.java:305)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor.executeQuery(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlParallelExecutor.run(Unknown Source)
at org.talend.dq.analysis.ColumnAnalysisSqlExecutor$ExecutiveAnalysisJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:56.244
!MESSAGE 2011-08-03 16:36:56,244 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Blank Count" SQL query: SELECT COUNT("ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT" WHERE TRIM("ADDRESSLINE1") = ''

!ENTRY org.talend.platform.logging 4 0 2011-08-03 16:36:56.244
!MESSAGE 2011-08-03 16:36:56,244 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Query not executed for indicator: "Distinct Count" SQL query: SELECT COUNT(DISTINCT "ADDRESSLINE1") FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT"

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:56.713
!MESSAGE 2011-08-03 16:36:56,713 INFO org.talend.dq.analysis.ColumnAnalysisSqlExecutor - Executing query: SELECT COUNT(*) FROM "COBAL_ODS_DEV"."ADMIN"."CH_ODS_COMPLAINANT" WHERE "ADDRESSLINE1" IS NULL

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:59.494
!MESSAGE 2011-08-03 16:36:59,494 INFO org.talend.dq.analysis.ConnectionPool - Close connections and connection pool...

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:59.494
!MESSAGE 2011-08-03 16:36:59,494 INFO org.talend.dataprofiler.core.ui.action.actions.RunAnalysisAction - "Analysis "AddresslineStatistics" execution code: KO: At least one analysis execution failed, check the error logs for more details.. Duration: 58.88 s.
Employee

Re: Caanot connect to netezza

Hi,
Your original question (How do I...?) was quite correctly posted on the forum. It looks to me like this second issue isn't something you've done - it's an error.
In that situation, you can post on our bugtracker - but I see that someone has already encountered this, and a fix is currently scheduled for 4.2.3. The issue is reported here: http://jira.talendforge.org/browse/TDQ-1693
You are still welcome to raise an issue for it if you wish - it will be marked as a duplicate of the original, and enables us to track that more than one user is affected by the issue.
hope this helps
One Star

Re: Caanot connect to netezza

Thanks, I will wait for 4.2.3. Any idea when this will be delivered, please?