topic Re: table or view does not exist error in toracleinput in Talend Studio

table or view does not exist error in toracleinput

Anonymous — Thu, 17 May 2018 08:34:04 GMT

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.

Re: table or view does not exist error in toracleinput

manodwhb — Thu, 17 May 2018 08:40:06 GMT

@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?

Re: table or view does not exist error in toracleinput

Anonymous — Thu, 17 May 2018 12:03:46 GMT

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

tOracleoutput1.JPG

Re: table or view does not exist error in toracleinput

manodwhb — Thu, 17 May 2018 12:30:18 GMT

@brahmatalend,did you provide grant access?

Re: table or view does not exist error in toracleinput

Anonymous — Tue, 29 May 2018 07:34:15 GMT

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

Re: table or view does not exist error in toracleinput

Anonymous — Fri, 20 Sep 2019 06:16:57 GMT

Hi,

My job is executing but parallelly I get this error in the log 'table or view does not exist'. What would be the issue. Please see the attached screenshot. At the end, some records are not getting the values.

Re: table or view does not exist error in toracleinput

manodwhb — Fri, 20 Sep 2019 06:40:00 GMT

@Alekhya05 ,what is your Target table ? which you have specified in TOracleOutput and which is not there in the DB,may be schema or target table or pointed wrong DB

Re: table or view does not exist error in toracleinput

Anonymous — Fri, 20 Sep 2019 06:46:20 GMT

Thank you for your reply.

Well I have checked the schema and target that I am trying to send to.
Everything seems to be correct. Some records are getting the values though
but some aren’t, and hence this error.
Both my source and output are Oracle DB.

Re: table or view does not exist error in toracleinput

manodwhb — Fri, 20 Sep 2019 06:47:36 GMT

@Alekhya05 ,for few records only rejecting?

Re: table or view does not exist error in toracleinput

Anonymous — Fri, 20 Sep 2019 06:49:20 GMT

@ manodwhb yes.

Re: table or view does not exist error in toracleinput

manodwhb — Fri, 20 Sep 2019 07:00:52 GMT

@Alekhya05 , Do you have any constrains on target table?