topic Relation doesnot exist Error with postgres in Data Quality

Relation doesnot exist Error with postgres

_AnonymousUser — Sat, 16 Nov 2024 14:06:52 GMT

I am able to create a new connection and analyse data for tables under certain schemas. Whereas for other schemas; analysis on any column of any of the tables; gives this error -Fail to run this analysis:" ". ERROR: relation "tablename" does not exist.
Is this related to DB permissions? Pls suggest how to resolve the error.

Re: Relation doesnot exist Error with postgres

Sebastiao_Qlik — Mon, 29 Dec 2008 08:53:43 GMT

Hi benzhyd,
Which version of Talend Open Profiler do you use?
Does your user have the permissions to do SELECT on this table?
If yes, then it's probably not related to DB permissions.
You may find more information about the error in the "Error Log" view: Menu "Window > Show view > General > Error Log"

Re: Relation doesnot exist Error with postgres

Zouraiz — Tue, 16 Mar 2021 16:47:36 GMT

Hi everyone,

I am having the same problem. my DB connection is successful and I can see tables but when I run the job I keep saying that relation does not exist. this problem is with all the tables. Need advice on it.?