Guess Schema not working in tOracleInput Component

Four Stars

Guess Schema not working in tOracleInput Component

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.

 

Thanks & Regards,
Sekar
Employee

Re: Guess Schema not working in tOracleInput Component

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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download