Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-12-27 10:35 PM

tOracleBulkExec throws ORA-00942: table or view does not exist error

I am trying to use tOracleBulkExec component (TOS 5.6.1) to "UPDATE" an Oracle table from a .csv file (exported from another database). I am getting the following error:
Exception in component tOracleBulkExec_1
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
Is there any known problem with this component? I checked all the database permissions. They are correct. The "INSERT" works fine.
Any help would be much appreciated.
Thanks.
Labels (5)
Labels
381 Views
0 Likes
5 Replies
Anonymous
Not applicable
‎2016-12-27 10:50 PM
Author

Hi,
Are you using BLOB or CLOB field when loading file to oralce database? More information of your current situation will be preferred.
Best regards
Sabrina
381 Views
0 Likes
Anonymous
Not applicable
‎2016-12-27 10:58 PM
Author

Hi Sabrina, thanks for your response.
No, I am not using CLOB or BLOB. The database table columns types are varchar and date. Here are the screenshots of my simple test:
0683p000009MCmr.png 0683p000009MCad.png 0683p000009MCbk.png 0683p000009MCmO.png
381 Views
0 Likes
Anonymous
Not applicable
‎2016-12-28 02:32 AM
Author

Hi,
Have you tried to use tOracleOutput component instead to see if this issue repro?
The work flow looks like:tOracleConnection-->tFileInput-->toracleoutput(update option)
Best regards
Sabrina
381 Views
0 Likes
Anonymous
Not applicable
‎2016-12-28 03:36 PM
Author

Hi Sabrina, yes, tOracleOutput works. It appears to be this is a bug with the tOracleBulkExec component (that "UPDATE" doesn't work) in TOS 5.6.1.
Thanks for your help.
381 Views
0 Likes
Anonymous
Not applicable
‎2016-12-29 02:21 AM
Author

Hi,
Usually, the tOracleOutputBulk and tOracleBulkExec components are used together in a two step process.
Could you please take a look at component reference about:TalendHelpCenter:tOracleBulkExec and re-design your work flow to see if it works?
tfileinputxxx-->tOracleOutputBulk
|onsubjobok
tOracleBulkExec
Best regards
Sabrina
381 Views
0 Likes