Cant start Job: Exception in component tDBInput_1

RémiJ13 — Sat, 16 Nov 2024 00:10:03 GMT

Hello, i am new on Talend.

This is my error message:

Starting job test_migration at 16:49 10/05/2021.

Picked up _JAVA_OPTIONS: -Xmx512M

[statistics] connecting to socket on port 3758

[statistics] connected

Exception in component tDBInput_1 (test_migration)

org.postgresql.util.PSQLException: ERREUR: la relation « orgamediBastiaANO.code_post » n'existe pas

Position : 343

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2505)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2241)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310)

at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:309)

at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:295)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:272)

at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:225)

at local_project.test_migration_0_1.test_migration.tDBInput_1Process(test_migration.java:664)

at local_project.test_migration_0_1.test_migration.runJobInTOS(test_migration.java:1172)

at local_project.test_migration_0_1.test_migration.main(test_migration.java:1021)

[statistics] disconnected

Re: Cant start Job: Exception in component tDBInput_1

gjeremy1617088143 — Mon, 10 May 2021 15:05:12 GMT

Hi, you have a problem in your query or your schema :

the error : la relation « orgamediBastiaANO.code_post » n'existe pas could indicate where you have to looking for.

Send me love and Kudos