Problem guessing schema

[Anonymous]

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?

[Anonymous]

Hello,

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

Best regards

Sabrina 

[Anonymous]

Here it is.

.log

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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