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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Talend TOracle componet Error.

Hi,
I am trying to connect Oracle data base. when i am running a job I am getting this error. Please find bellow. Could you please suggest me.
Exception in component tOracleInput_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:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
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:1034)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
at salesforce.test_0_1.Test.tOracleInput_1Process(Test.java:1745)
at salesforce.test_0_1.Test.tSetProxy_1Process(Test.java:1338)
at salesforce.test_0_1.Test.tFileInputProperties_1Process(Test.java:1230)
at salesforce.test_0_1.Test.runJobInTOS(Test.java:2507)
at salesforce.test_0_1.Test.main(Test.java:2157)
disconnected
Thank you,
Praveen
Labels (5)
12 Replies
Anonymous
Not applicable
Author

Hi Shong,
I Build the job same way as you said,
Job properties files--main-->Load properties File to context
|
onsubjobok
|
proxy info
|
onsubjobok
|
tAs400Input-->tMap-->tOracleOutput

But still the problem is not sloved. I am thinking on data types. Can you please find this data types:
Anonymous
Not applicable
Author

Hi
What's the error message thrown on tOracleOutput component now? The size of third pic is small, I can't see it clear.
Best regards
Shong
Anonymous
Not applicable
Author

Hi Shong,
I thought the issue is related data types. I resolved the issue.
Thank you for your help.
Praveen