Talend not able to guess schema of a query

[MahiwalVinit]

Hi,

I have connected talend with mssqlserver. I have a query to fetched data from mssqlserver.

When I execute a query on mssqlserver using Toad also directly on mssqlserver.  I am able to see the result while when

while when I use this query on mssqlserver output component(tjdbcinput), it shows a  column does not exist. 

How to deal with this issue. 

Note: I am able to guess schema using other queries. 

[Anonymous]

I can't see your entire query, but I do not see a table either in the query or in the table field. This *could* be connected to the issue. It would be the first thing I would test anyway

[MahiwalVinit · Accepted solution]

This query is very long around 500 line. To run the job without guess schema,  I have selected edit schema and created manually the schema. Then I was able to run the job.