VJDBC ERROR: Canceled (in Optimizer)

Mike_Gong_1

Hi I got an VJDBC error when I ran a transformation through Pentaho. Somehow, a simple query was cancelled by Vertica. 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : Unexpected error 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : An error occurred executing SQL: 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : select distinct a.app_name, a.app_version, b.app_ver_alias 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : from application_dim a 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : left outer join app_ver_alias b 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : on a.app_name = b.app_name 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : and a.app_version = b.app_version 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : order by a.app_name, a.app_version 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : [Vertica][VJDBC](ERROR: Canceled (in Optimizer)) {1} 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1857) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:233) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at java.lang.Thread.run(Unknown Source) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : Caused by: java.sql.SQLException: [Vertica][VJDBC](ERROR: Canceled (in Optimizer)) {1} 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at com.vertica.dataengine.VQueryExecutor.checkForCancelError(Unknown Source) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at com.vertica.dataengine.VQueryExecutor.handleExecuteResponse(Unknown Source) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at com.vertica.jdbc.SStatement.executeNoParams(Unknown Source) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at com.vertica.jdbc.SStatement.executeQuery(Unknown Source) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1843) 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : ... 4 more 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : Caused by: com.vertica.support.exceptions.ErrorException: [Vertica][VJDBC](ERROR: Canceled (in Optimizer)) {1} 2013/08/26 16:25:09 - Get App Version.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : ... 10 more 2013/08/26 16:25:09 - Get App Version.0 - Finished reading query, closing connection. Any help is much appreciated. Thanks

Mike_Gong_1

Never mind. It seems to be cancelled by Pentaho itself due to an expected data format issue. Thanks