Four Stars

when I insert 0 record, error occurred.

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.

output_2.jpg

7 REPLIES
Twelve Stars TRF
Twelve Stars

Re: when I insert 0 record, error occurred.

Hi,

What's the error mesage?


TRF
Four Stars

Re: when I insert 0 record, error occurred.

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.

 

Twelve Stars TRF
Twelve Stars

Re: when I insert 0 record, error occurred.

Thank's for the translation Smiley Wink

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

Can you share the whole job design?


TRF
Four Stars

Re: when I insert 0 record, error occurred.

 

 

 

IMG_20171103_172239HD.jpg

 

it is my job desing.

 

thank you.

Four Stars

Re: when I insert 0 record, error occurred.

test.png

Twelve Stars TRF
Twelve Stars

Re: when I insert 0 record, error occurred.

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).

TRF
Four Stars

Re: when I insert 0 record, error occurred.

thank you.