• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tNetezzaInput to tNetezzaOutput Err on commit size = input or 0 input

#1 2011-03-24 23:18:48

llinares
Member
Registered: 2010-11-15
Posts: 17

tNetezzaInput to tNetezzaOutput Err on commit size = input or 0 input

Environment: v4.1.2 TIS RedHat 64 with nzJDBC.jar (also tried nzJDBC3.jar)

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:

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:

Exception in component tNetezzaOutput_1
org.netezza.error.NzSQLException: ERROR:  Transaction rolled back by client

    at org.netezza.internal.QueryExecutor.getNextResult(QueryExecutor.java:276)
    at org.netezza.internal.QueryExecutor.execute(QueryExecutor.java:73)
    at org.netezza.sql.NzConnection.execute(NzConnection.java:2620)
    at org.netezza.sql.NzStatement._execute(NzStatement.java:848)
    at org.netezza.sql.NzStatement._executeUpdate(NzStatement.java:859)
    at org.netezza.sql.NzPreparedStatament.executeBatch(NzPreparedStatament.java:1017)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaInput_1Process(Copy_of_JB_DateDim_LoadCore.java:4153)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaRow_7Process(Copy_of_JB_DateDim_LoadCore.java:1056)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaConnection_4Process(Copy_of_JB_DateDim_LoadCore.java:953)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tLibraryLoad_1Process(Copy_of_JB_DateDim_LoadCore.java:840)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.runJobInTOS(Copy_of_JB_DateDim_LoadCore.java:7059)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.main(Copy_of_JB_DateDim_LoadCore.java:6826)
Job Copy_of_JB_DateDim_LoadCore ended at 17:54 24/03/2011. [exit code=0]

------------------------------------------------------------------------------------
Second, I'm getting the error below when my input source has zero rows:
------------------------------------------------------------------------------------

Exception in component tNetezzaOutput_1
org.netezza.error.NzSQLException: failed to create external table for bulk load
    at org.netezza.sql.NzPreparedStatament.executeBatch(NzPreparedStatament.java:1006)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaInput_1Process(Copy_of_JB_DateDim_LoadCore.java:4153)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaRow_7Process(Copy_of_JB_DateDim_LoadCore.java:1056)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tNetezzaConnection_4Process(Copy_of_JB_DateDim_LoadCore.java:953)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.tLibraryLoad_1Process(Copy_of_JB_DateDim_LoadCore.java:840)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.runJobInTOS(Copy_of_JB_DateDim_LoadCore.java:7059)
    at core.copy_of_jb_datedim_loadcore_0_1.Copy_of_JB_DateDim_LoadCore.main(Copy_of_JB_DateDim_LoadCore.java:6826)
Job Copy_of_JB_DateDim_LoadCore ended at 17:56 24/03/2011. [exit code=0]

===================================================


Uploaded Images

Offline

#2 2011-05-04 19:37:47

llinares
Member
Registered: 2010-11-15
Posts: 17

Re: tNetezzaInput to tNetezzaOutput Err on commit size = input or 0 input

The error is thrown when the prepared statement is executed with no values. We have opened a support ticket for this.

Offline

#3 2011-05-05 15:22:32

pcoffre
Talend Team
Registered: 2009-03-26
Posts: 526
Website

Re: tNetezzaInput to tNetezzaOutput Err on commit size = input or 0 input

Hello llinares,

Thank you for opening the bug and for the feedback on the forum.

Best,
Pcoffre.


Follow Talend on Twitter, Linkedin, Facebook and the forum.
Download and try Talend solutions

Offline

#4 2011-05-20 18:26:06

llinares
Member
Registered: 2010-11-15
Posts: 17

Re: tNetezzaInput to tNetezzaOutput Err on commit size = input or 0 input

The bugtracker # is 0020584

Offline

#5 2012-12-12 18:37:34

adiallo
Talend Team
Registered: 2010-10-01
Posts: 26

Re: tNetezzaInput to tNetezzaOutput Err on commit size = input or 0 input

Hello llinares,

What was the solution here for your issue?

Can you share please here for other user?

Thanks,


Abdoul Karim DIALLO

Offline

#6 2013-01-05 13:27:41

sonal2562
Guest

Re: tNetezzaInput to tNetezzaOutput Err on commit size = input or 0 input

any update?

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tNetezzaInput to tNetezzaOutput Err on commit size = input or 0 input

Board footer

Powered by FluxBB