https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269889#M47973 The error is thrown when the prepared statement is executed with no values. We have opened a support ticket for this. Wed, 04 May 2011 18:37:47 GMT Anonymous 2011-05-04T18:37:47Z https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269888#M47972 Environment: v4.1.2 TIS RedHat 64 with nzJDBC.jar (also tried nzJDBC3.jar) <BR />I believe this is a Talend bug regarding the tNetezzaInput/Output components. The tOracleInput and tOracleOutput components work just fine with the same two scenarios I've described below: <BR />First, I'm getting the error below when I have a simple input to output data flow and the commit size equals the total number of rows in the input source: <BR />Exception in component tNetezzaOutput_1 <BR />org.netezza.error.NzSQLException: ERROR: Transaction rolled back by client <BR /> at org.netezza.internal.QueryExecutor.getNextResult(QueryExecutor.java:276) <BR /> at org.netezza.internal.QueryExecutor.execute(QueryExecutor.java:73) <BR /> at org.netezza.sql.NzConnection.execute(NzConnection.java:2620) <BR /> at org.netezza.sql.NzStatement._execute(NzStatement.java:848) <BR /> at org.netezza.sql.NzStatement._executeUpdate(NzStatement.java:859) <BR /> at org.netezza.sql.NzPreparedStatament.executeBatch(NzPreparedStatament.java:1017) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaInput_1Process(Copy_of_JB_DateDim_LoadCore.java:4153) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaRow_7Process(Copy_of_JB_DateDim_LoadCore.java:1056) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaConnection_4Process(Copy_of_JB_DateDim_LoadCore.java:953) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tLibraryLoad_1Process(Copy_of_JB_DateDim_LoadCore.java:840) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.runJobInTOS(Copy_of_JB_DateDim_LoadCore.java:7059) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.main(Copy_of_JB_DateDim_LoadCore.java:6826) <BR />Job Copy_of_JB_DateDim_LoadCore ended at 17:54 24/03/2011. <BR />------------------------------------------------------------------------------------ <BR />Second, I'm getting the error below when my input source has zero rows: <BR />------------------------------------------------------------------------------------ <BR />Exception in component tNetezzaOutput_1 <BR />org.netezza.error.NzSQLException: failed to create external table for bulk load <BR /> at org.netezza.sql.NzPreparedStatament.executeBatch(NzPreparedStatament.java:1006) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaInput_1Process(Copy_of_JB_DateDim_LoadCore.java:4153) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaRow_7Process(Copy_of_JB_DateDim_LoadCore.java:1056) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaConnection_4Process(Copy_of_JB_DateDim_LoadCore.java:953) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tLibraryLoad_1Process(Copy_of_JB_DateDim_LoadCore.java:840) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.runJobInTOS(Copy_of_JB_DateDim_LoadCore.java:7059) <BR /> at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.main(Copy_of_JB_DateDim_LoadCore.java:6826) <BR />Job Copy_of_JB_DateDim_LoadCore ended at 17:56 24/03/2011. <BR />=================================================== Sat, 16 Nov 2024 13:01:06 GMT https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269888#M47972 Anonymous 2024-11-16T13:01:06Z https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269889#M47973 The error is thrown when the prepared statement is executed with no values. We have opened a support ticket for this. Wed, 04 May 2011 18:37:47 GMT https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269889#M47973 Anonymous 2011-05-04T18:37:47Z https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269890#M47974 Hello llinares, <BR />Thank you for opening the bug and for the feedback on the forum. <BR />Best, <BR />Pcoffre. Thu, 05 May 2011 14:22:32 GMT https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269890#M47974 Anonymous 2011-05-05T14:22:32Z https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269891#M47975 The bugtracker # is 0020584 Fri, 20 May 2011 17:26:06 GMT https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269891#M47975 Anonymous 2011-05-20T17:26:06Z https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269892#M47976 Hello llinares, <BR />What was the solution here for your issue? <BR />Can you share please here for other user? <BR />Thanks, Wed, 12 Dec 2012 17:37:34 GMT https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269892#M47976 Anonymous 2012-12-12T17:37:34Z https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269893#M47977 any update? Sat, 05 Jan 2013 12:27:41 GMT https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269893#M47977 _AnonymousUser 2013-01-05T12:27:41Z https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269894#M47978 Guys, any update on this ? Wed, 21 Sep 2016 20:04:35 GMT https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-to-tNetezzaOutput-Err-on-commit-size-input-or-0/m-p/2269894#M47978 Anonymous 2016-09-21T20:04:35Z