error tdb2input although tables are in repository

christ_eprimo — Sat, 16 Nov 2024 07:11:45 GMT

Dear helpers

I'm using the latest talend version 7.

When trying to retrieve data from a DB2 database (version 11.1, fix pack 2) with tDB2Input, I get the error message below although I successfully found the tables in the db2 connection and added them to the belonging repository.

Since I am still testing this connection, I am working in the talend studio and trying to run the job locally in the first place.
DB2RIM ist the user, "/BIC/AYSPRD0700" is the table name. Since it work with SISS, it ought to work with talend as well.

Many thanks in advance!

Exception in component tDBInput_1 (DB2_P32_Test)
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2RIM./BIC/AYSDPRD0700, DRIVER=4.23.42
	at com.ibm.db2.jcc.am.ld.a(ld.java:810)
	at com.ibm.db2.jcc.am.ld.a(ld.java:66)
	at com.ibm.db2.jcc.am.ld.a(ld.java:140)
	at com.ibm.db2.jcc.am.aq.c(aq.java:2807)
	at com.ibm.db2.jcc.am.aq.d(aq.java:2791)
	at com.ibm.db2.jcc.am.aq.a(aq.java:2217)
	at com.ibm.db2.jcc.t4.bb.i(bb.java:192)
	at com.ibm.db2.jcc.t4.bb.b(bb.java:83)
	at com.ibm.db2.jcc.t4.p.a(p.java:32)
	at com.ibm.db2.jcc.t4.vb.i(vb.java:150)
	at com.ibm.db2.jcc.am.aq.lb(aq.java:2186)
	at com.ibm.db2.jcc.am.aq.a(aq.java:3312)
	at com.ibm.db2.jcc.am.aq.a(aq.java:722)
	at com.ibm.db2.jcc.am.aq.executeQuery(aq.java:701)
	at codecommit_bicc_projekt_01.db2_p32_test_0_1.DB2_P32_Test.tDBInput_1Process(DB2_P32_Test.java:2373)
	at codecommit_bicc_projekt_01.db2_p32_test_0_1.DB2_P32_Test.runJobInTOS(DB2_P32_Test.java:3739)
	at codecommit_bicc_projekt_01.db2_p32_test_0_1.DB2_P32_Test.main(DB2_P32_Test.java:3565)
[FATAL]: codecommit_bicc_projekt_01.db2_p32_test_0_1.DB2_P32_Test - tDBInput_1 DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2RIM./BIC/AYSDPRD0700, DRIVER=4.23.42

topic error tdb2input although tables are in repository in Talend Studio

error tdb2input although tables are in repository