topic Re: failed to close the connection in tDB2Output in Talend Studio

failed to close the connection in tDB2Output

Anonymous — Thu, 14 Sep 2017 06:18:23 GMT

hi team, the below is the error while connecting DB2 output. kinldy adivse.

Error log:-

failed to close the connection in tDB2Output_1 :[jcc][t4][10251][10308][4.11.77] java.sql.Connection.close() requested while a transaction is in progress on the connection.
The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null

Re: failed to close the connection in tDB2Output

Anonymous — Thu, 14 Sep 2017 06:48:12 GMT

It seems connection was not established properly, what is the input connection??

Create a METADATA connection and use this to connect DB- Use an existing connection

Regards,

Avinash

Re: failed to close the connection in tDB2Output

Anonymous — Thu, 14 Sep 2017 07:44:46 GMT

Thanks Avinash for response.

the below is the error after your suggestion applied.

Exception in component tDB2Close_1

com.ibm.db2.jcc.am.SqlException: [jcc][t4][10251][10308][4.11.77] java.sql.Connection.close() requested while a transaction is in progress on the connection.

The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null

at com.ibm.db2.jcc.am.gd.a(gd.java:660)

at com.ibm.db2.jcc.am.gd.a(gd.java:60)

at com.ibm.db2.jcc.am.gd.a(gd.java:120)

at com.ibm.db2.jcc.am.lb.u(lb.java:1238)

at com.ibm.db2.jcc.am.lb.x(lb.java:1260)

at com.ibm.db2.jcc.am.lb.v(lb.java:1246)

at com.ibm.db2.jcc.am.lb.close(lb.java:1228)

at poc_project.extcdmgcqualscoreload_0_1.EXTCDMGCQualScoreLoad.tDB2Close_1Process(EXTCDMGCQualScoreLoad.java:2108)

at poc_project.extcdmgcqualscoreload_0_1.EXTCDMGCQualScoreLoad.tFileInputDelimited_1Process(EXTCDMGCQualScoreLoad.java:1991)

at poc_project.extcdmgcqualscoreload_0_1.EXTCDMGCQualScoreLoad.tDB2Connection_1Process(EXTCDMGCQualScoreLoad.java:448)

at poc_project.extcdmgcqualscoreload_0_1.EXTCDMGCQualScoreLoad.runJobInTOS(EXTCDMGCQualScoreLoad.java:2350)

at poc_project.extcdmgcqualscoreload_0_1.EXTCDMGCQualScoreLoad.main(EXTCDMGCQualScoreLoad.java:2207)

Re: failed to close the connection in tDB2Output

Anonymous — Thu, 14 Sep 2017 07:52:06 GMT

Hello,

What does your whole work flow look like? Could you please post your job design screenshots into forum?

Best regards

Sabrina

Re: failed to close the connection in tDB2Output

Anonymous — Thu, 14 Sep 2017 12:29:48 GMT

the job design like

db2 connection -> file input delimied -> tMap ->Db2 output -> Db2 commit

the job reading the data from file and load into table

Re: failed to close the connection in tDB2Output

cterenzi — Thu, 14 Sep 2017 13:52:23 GMT

Don't use a row connection to tDB2Commit. Use OnComponentOK instead.

In more detail, Talend starts all of the components connected with row connections at the same time. You don't want to commit until your tDB2Output component has completely finished.

Re: failed to close the connection in tDB2Output

Anonymous — Fri, 15 Sep 2017 07:13:31 GMT

Hello,

If you want to use a Row > Main connection to link tDB2Commit to your Job, your data will be committed row by row.

In this case, do not select the Close connection check box or your connection will be closed before the end of your first row commit.

Please see a related scenario:TalendHelpCenter: Inserting data in mother/daughter tables (MySql DB as an example)

Best regards

Sabrina

Re: failed to close the connection in tDB2Output

Anonymous — Fri, 15 Sep 2017 10:25:38 GMT

it looks your box not able to connect DB2 port, are you able to create a DSN??

Re: failed to close the connection in tDB2Output

Anonymous — Tue, 19 Sep 2017 07:54:23 GMT

Sorry for late reply.

It's worked "tDB2Commit. Use OnComponentOK"

Re: failed to close the connection in tDB2Output

Anonymous — Thu, 24 May 2018 08:07:40 GMT

Hi Team,

I am facing an issue while i am trying to load data into Db2 by using talend. Error message is below mentioned -

failed to close the connection in tDB2Output_1 :[jcc][t4][10251][10308][4.13.127] java.sql.Connection.close() requested while a transaction is in progress on the connection.
The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null
Exception in component tDB2Output_1
[statistics] disconnected
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-604, SQLSTATE=42611, SQLERRMC=VARCHAR(0), DRIVER=4.13.127
at com.ibm.db2.jcc.am.id.a(id.java:677)
at com.ibm.db2.jcc.am.id.a(id.java:60)
at com.ibm.db2.jcc.am.id.a(id.java:127)
at com.ibm.db2.jcc.am.no.c(no.java:2653)
at com.ibm.db2.jcc.am.no.d(no.java:2641)
at com.ibm.db2.jcc.am.no.b(no.java:2027)
at com.ibm.db2.jcc.t4.cb.i(cb.java:225)
at com.ibm.db2.jcc.t4.cb.c(cb.java:48)
at com.ibm.db2.jcc.t4.q.b(q.java:38)
at com.ibm.db2.jcc.t4.sb.h(sb.java:114)
at com.ibm.db2.jcc.am.no.hb(no.java:2022)
at com.ibm.db2.jcc.am.no.a(no.java:3166)
at com.ibm.db2.jcc.am.no.e(no.java:1053)
at com.ibm.db2.jcc.am.no.execute(no.java:1037)
at local_project.firstjob_0_1.FirstJob.tRowGenerator_1Process(FirstJob.java:573)
at local_project.firstjob_0_1.FirstJob.runJobInTOS(FirstJob.java:1080)
at local_project.firstjob_0_1.FirstJob.main(FirstJob.java:937)

Please help me out here ASAP.

1.PNG

Re: failed to close the connection in tDB2Output

Anonymous — Wed, 30 May 2018 08:00:26 GMT

Hello,

Have you tried to use a connection close component in your work flow? Please move it to tPostJob-->tDB2Close.

Best regards

Sabrina

Re: failed to close the connection in tDB2Output

Anonymous — Thu, 13 Sep 2018 09:32:11 GMT

Hi,

I am trying to migrate a simple table from db2 to mongodb and getting an error message

Exception in component tDB2Input_1
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=DB2ADMIN;SELECT;PROFESSIONAL.CUSTOMER, DRIVER=4.13.127
at com.ibm.db2.jcc.am.id.a(id.java:677)
at com.ibm.db2.jcc.am.id.a(id.java:60)
at com.ibm.db2.jcc.am.id.a(id.java:127)
at com.ibm.db2.jcc.am.no.c(no.java:2653)
at com.ibm.db2.jcc.am.no.d(no.java:2641)
at com.ibm.db2.jcc.am.no.a(no.java:2090)
at com.ibm.db2.jcc.t4.cb.h(cb.java:141)
at com.ibm.db2.jcc.t4.cb.b(cb.java:41)
at com.ibm.db2.jcc.t4.q.a(q.java:32)
at com.ibm.db2.jcc.t4.sb.i(sb.java:135)
at com.ibm.db2.jcc.am.no.ib(no.java:2059)
at com.ibm.db2.jcc.am.no.a(no.java:3130)
at com.ibm.db2.jcc.am.no.a(no.java:688)
at com.ibm.db2.jcc.am.no.executeQuery(no.java:672)
at local_project.db2tomongodb_0_1.db2toMongoDB.tDB2Input_1Process(db2toMongoDB.java:964)
at local_project.db2tomongodb_0_1.db2toMongoDB.tMongoDBConnection_1Process(db2toMongoDB.java:402)
at local_project.db2tomongodb_0_1.db2toMongoDB.runJobInTOS(db2toMongoDB.java:1443)
at local_project.db2tomongodb_0_1.db2toMongoDB.main(db2toMongoDB.java:1300)
[statistics] disconnected
Job db2toMongoDB ended at 13:55 13/09/2018. [exit code=1]

Re: failed to close the connection in tDB2Output

Anonymous — Fri, 12 Oct 2018 08:46:13 GMT

Hello @ravi,

This error should be from your DB2. It looks like the DB2 environment does not have the permissions required for Portal operation. Could you please check it?

Best regards

Sabrina