Error : tOracleBulkExec component table and view does not exist

Four Stars

Error : tOracleBulkExec component table and view does not exist

Hi All

 

I am trying to use tOracleBulkExec component (6.3) to "UPDATE" an Oracle table from a .csv file

I am getting the following error:
Exception in component tOracleBulkExec_1_t0BE
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

 

I tried using tOracleOutputBulk and tOracleOutputBulkExec but still Iam getting the same error

 

I tried using tOracleOutput component its is working fine. but since I have to update large volume of data and performance is the concern, cannot prefer doing via tOracleOutput

 

Can anyone please assist

Eleven Stars

Re: Error : tOracleBulkExec component table and view does not exist

check if you have Create table permission in the schema ? you must have create table permission to do Update mode operation.

 

Also check if same job works in "append" mode instead of update ? if all ok it means no issue with your job design and above is only reason you have this issue.


Let me know if you are able to identify issue.


Regards
Abhishek KUMAR
Eleven Stars

Re: Error : tOracleBulkExec component table and view does not exist

can you please check above 

Regards
Abhishek KUMAR
Highlighted
Employee

Re: Error : tOracleBulkExec component table and view does not exist

Hi,

 

    The Oracle error "ORA-00942: table or view does not exist" is quite common error when one of the below issue happens.

 

  1. Referencing a table or view that does not exist
  2. Using an unauthorized synonym
  3. Using an expression of view where a table is required
  4. Attempting to use a table without proper permission or privilege

 

Since you have told that you were able to do the operation with tOracleOutput, could you please advise the Table operation you selected in the component? If there is privilege issue, you would not have been able to create the table if not available already.

 

Another quite common mistake which I used to do when I was a developer is to use wrong user id to do the operation where table will not be available. There is high chance that table will be under separate user/schema. Could you please look these issues and come back?

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

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

Definitive Guide to Data Quality

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

Download