Guess Schema not working in tOracleInput Component

Anonymous — Mon, 29 Oct 2018 09:28:30 GMT

Hi,

I am getting error while clicking Guess Schema option in tOracleInput often.

After I write my query inside the Query box of the tOracleInput component, I clicked Guess Schema.

A pop up was displayed saying Connect to DB error, or some errors in SQL query string, or 'Guess Schema' not compatible with current SQL query string.

Then I have checked my DB connection (pointed inside the component), it was successful,

and I tried executing my SQL query string in Oracle developer, it was perfectly executed.

Is there any compatibility for Guess Schema option with respect to SQL query string?

Thanks in advance.

Re: Guess Schema not working in tOracleInput Component

Anonymous — Mon, 29 Oct 2018 09:54:29 GMT

Hi,

Could you please share your query and component detail screen shot for a quick look? If you are having any functions or column combinations without alias, it might create issue.

Warm Regards,

Nikhil Thampi

topic Re: Guess Schema not working in tOracleInput Component in Talend Studio

Guess Schema not working in tOracleInput Component

Re: Guess Schema not working in tOracleInput Component