topic Problem guessing schema in Talend Studio

Problem guessing schema

Anonymous — Tue, 07 May 2019 13:34:09 GMT

I have a job that is not working fine. In every input table I try to set does not wor the ... button to edit the query. When I try to press it nothing happens.

But it allows me to edit it in the space so although it is not ideal I can deal it.

Now it is also giving me another problem, when I click on Guess schema button it last a lot of time and finally gives me the error I attached. If there is only one field in the query it works but there are around 60.

The component is tPostgresqlInput.

The version is 7.0.1

¿Any ideas?

Re: Problem guessing schema

Anonymous — Wed, 08 May 2019 07:29:51 GMT

Hello,

Could you please upload the log message? Which is located in <Talend Studio installation path>/workspace/.metadata/.log

Best regards

Sabrina

Re: Problem guessing schema

Anonymous — Wed, 08 May 2019 07:48:37 GMT

Here it is.

.log

Re: Problem guessing schema

Anonymous — Wed, 08 May 2019 08:48:29 GMT

Hello,

From your error log, we don't find a related error stack about your current issue. Would you mind posting your query with fields in tPostgresqlInput here?

Best regards

Sabrina

Re: Problem guessing schema

Anonymous — Wed, 08 May 2019 08:52:25 GMT

I can not post the query for privacy issues but it is something like:

SELECT
(select h.field1 from table2 h where h.id = e.id) ,
field2,
field3...
FROM
table e

Re: Problem guessing schema

Anonymous — Tue, 01 Oct 2019 13:09:30 GMT

I finally found the solution to both problems. It all came because the Db Connection has some brackets () and it did not read it well