tOracleBulkExec errorORA-00942: table or view does not exist

[Anonymous]

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
Regards
Ricardo Mendes

[Anonymous]

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

[Anonymous]

Hi,
And pay attention on "Case Sensitive".
Best regards
Sabrina

[Anonymous]

I've checked all the configurations but still doesn't work

[Anonymous]

Hi,
Have you checked DB "Permissions"? Could you get the table by your user role?
Best regards
Sabrina

[Anonymous]

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

[Anonymous]

Hi,
Could you please show us your whole workflow? What's your job requirement?
Best regards
Sabrina

[Anonymous]

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!