One Star

tOracleInput with Materialized View

It is possible to run a query on a Oracle Materialized View?
I am able to run a query from sqldeveloper "select * from schema.MaterializedView" where MaterializedView is categorised as Materialized View by sqldeveloper.
However, if I add the same query to the tOracleInput component (all other parameters are set), I get the following error
Exception in component tOracleInput_9
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
at ...
Any ideas why this is happening and suggestions on how to resolve it?
2 REPLIES
Six Stars

Re: tOracleInput with Materialized View

Hi,
I didn't try materialized views in TalenD but already found some bugs related to Oracle and Talend. As soon as the materialized view works in little different way against standard view internally in Oracle database, I would expect also different way of retrieving data from this type of object, but maybe I am wrong...
Please post screenshot of tOracleInput component configuration, I would expect some error related to ORA-XXX...
If you think you found bug, please report it to talend bugtracker, their response is as fast as possible.
Best regards,
archenroot
One Star

Re: tOracleInput with Materialized View

Hi Folks,
I am getting below error. I ran the query in oracle as it is given in component toracleinput_5. Please assist me.

Starting job temp at 02:30 27/04/2012.
connecting to socket on port 3846
connected
Exception in component tOracleInput_5
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
at talend_dev.temp_0_1.temp.tOracleInput_5Process(temp.java:5514)
at talend_dev.temp_0_1.temp.tFileInputExcel_3Process(temp.java:1560)
at talend_dev.temp_0_1.temp.tOracleConnection_1Process(temp.java:1014)
disconnected
at talend_dev.temp_0_1.temp.runJobInTOS(temp.java:6061)
at talend_dev.temp_0_1.temp.main(temp.java:5685)
Job temp ended at 02:30 27/04/2012.