ERROR: relation "igp_bdohmks.anl_persoon" does not exist

Highlighted
Four Stars

ERROR: relation "igp_bdohmks.anl_persoon" does not exist

Hi,

 

It's my first Talend job and after connecting the database I get the follewing error.

Can someone help me with this?

 

Thanx Henk

 

 

 

Exception in component tPostgresqlInput_1 (Test_Henk)

org.postgresql.util.PSQLException: ERROR: relation "igp_bdohmks.anl_persoon" does not exist

Position: 9312

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

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

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

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:286)

 


Accepted Solutions
Highlighted
Seventeen Stars

Re: ERROR: relation "igp_bdohmks.anl_persoon" does not exist

This means the query you send is wrong. Check the query with a different tool like DBeaver or what ever and correct it.

The error message comes from the database and this means within Talend everything is actually ok except your select statement.

Perhaps you have configured the connection to a wrong database?

View solution in original post


All Replies
Highlighted
Seventeen Stars

Re: ERROR: relation "igp_bdohmks.anl_persoon" does not exist

This means the query you send is wrong. Check the query with a different tool like DBeaver or what ever and correct it.

The error message comes from the database and this means within Talend everything is actually ok except your select statement.

Perhaps you have configured the connection to a wrong database?

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog