failed to close the connection in tDB2Output

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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]

[Anonymous]

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