table or view does not exist error in toracleinput

Four Stars

table or view does not exist error in toracleinput

Hi , 

New to talend and while learning i was getting Table or view does not exist error while inserting one table data into another table (both tables are in same DB). I have not created the target table and used Action on table option as Create table if does not exist. But when i check the db after this error i was able to see the table created with out data.

 Attached the screenshots , please check and let me know what is the solution.

 

 

 

Forteen Stars

Re: table or view does not exist error in toracleinput

@brahmatalend,since you might not have the table or view in DB or you might not have privillages to read that table/View,which you specified in Table Name or  Table name if you rusing Query in Basic settings of tOracleInput.

 

are you able to select the table out of Talend with the same credentilas?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: table or view does not exist error in toracleinput

Yes, I am able to select the table , attached the screenshot.

Forteen Stars

Re: table or view does not exist error in toracleinput

@brahmatalend,did you provide grant access?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: table or view does not exist error in toracleinput

Hello brahmatalend,

Please check the Oracle Input Component. It is not correctly configured. The output component has no issues hence, it has created an empty table however, no data was flown because of the input component issue. I probably think, the right table name /view name was misconfigured.
Regards,
Praveen K Bandi

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads