Six Stars

Talend not able to guess schema of a query

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. 
talend issue.PNG

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: Talend not able to guess schema of a query

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.

 

editschema.PNG

2 REPLIES
Twelve Stars

Re: Talend not able to guess schema of a query

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

Rilhia Solutions
Six Stars

Re: Talend not able to guess schema of a query

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.

 

editschema.PNG