when I insert 0 record, error occurred.

[Anonymous]

hello.

I make a job. select data and insert to table.

when i select 0 record, error occurred.

I think it is a reason.

there is no record to commit.

what is the solution for 0 record to insert?

Thank you.

[TRF]

Hi,

What's the error mesage?

[Anonymous]

I got a korean error message. so i translated it.

error message. 

failed to close the connection in tDB2Output_1 : [jcc][t4][10251][10308][4.19.26] 

java.sql.Connection.close() is called when trasaction  is running.

can't close connection because, transaction is running. ERRORCODE = -4471, SQLSTATE=null

thank you.

[TRF]

Thank's for the translation

I don't think the problem is due to the number of rows.

Can you share the whole job design?

[Anonymous]

it is my job desing.

thank you.

[Anonymous]

[TRF]

Nothing to sy about the job design.
Maybe a problem with the tDB2Output component.
To my knowledge, this doesn't occur with components like tSalesforceOutput or tOracleOutput (but it does with tSalesforceOutputBulkExec for example).

[Anonymous]

thank you.