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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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