tOracleBulkExec errorORA-00942: table or view does not exist

One Star

tOracleBulkExec errorORA-00942: table or view does not exist

Hi,
I have a job that is updating a large amount of records but when executing the tOracleBulkExec gives the message
java.sql.SQLException: ORA-00942: table or view does not exist
I've set the correct database and table but doesn't work Smiley Sad
Regards
Ricardo Mendes
One Star

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Hi Mendesr
Have you checked correctly the schema and database in all fields of tOracleBulkExec??
DATABASE.schema.TABLE
Cheers
Moderator

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Hi,
And pay attention on "Case Sensitive".
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tOracleBulkExec errorORA-00942: table or view does not exist

I've checked all the configurations Smiley Happy but still doesn't work Smiley Sad
Moderator

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Hi,
Have you checked DB "Permissions"? Could you get the table by your user role?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Hi, yes I can get the table by my role, the first step is to read rows from that table and if I use tOracleOutput to update the table it works but takes 3 minutes to update 50 rows Smiley Sad
Moderator

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Hi,
Could you please show us your whole workflow? What's your job requirement?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tOracleBulkExec errorORA-00942: table or view does not exist

I also get a similar error on TOS - 5.6.2 with tOracleOutputBulkExec.
Mine is a simple flow - Delimited_file (all strings) -> tMap (to covert 2 columns to an Int and Date) -> tOracleOutputBulkExec
Attaching screenshot for both the Basic and Advanced properties of tOracleOutputBulkExec here!
Also, I'm trying to Bulk-Update the table with this, with proper Keys defined in the schema!

Any help is much appreciated!

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now