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
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?


All Replies
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?

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch