topic Re: [resolved] table or view does not exist error in Talend Studio

[resolved] table or view does not exist error

Anonymous — Fri, 13 Apr 2012 09:04:58 GMT

Hi !
I began on Talend. I managed to connect Talend with my DB but when i want to extract data, i got a problem. Here is the backtrace :
Exception in component tOracleInput_1
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
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:754)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1315)
at testtalend.essaisixtus_0_1.EssaiSixtus.tOracleInput_1Process(EssaiSixtus.java:1171)
at testtalend.essaisixtus_0_1.EssaiSixtus.runJobInTOS(EssaiSixtus.java:2177)
at testtalend.essaisixtus_0_1.EssaiSixtus.main(EssaiSixtus.java:2045)

I just want to copy data from an OracleInput to an OracleOutput.
I can copy the schema of my table
Connexion with my DB, it's ok
But when i want to preview the data : "broken connexion".
I use PL/SQL Developer to check if the table exist, and it's ok.
Which parameters can i modify, check ?
More informations :
OS : Windows XP Pro v2002 SP3
TOS Version: 5.0.2 Build id: r78327-20120216-0244
Generated language : Java
Thanks a lot.
Best regards.
Dex

Re: [resolved] table or view does not exist error

Anonymous — Fri, 13 Apr 2012 09:28:08 GMT

Hi
can you upload the image of your job, what is the action type you have configured for tOracleOutput component, i mean to say "Action on data"
Thanks and Regards,
Pavan

Re: [resolved] table or view does not exist error

Anonymous — Fri, 13 Apr 2012 09:32:33 GMT

Hi,
I had encountered the problem, the solution for this is you need to check whether the source and destination tables have same data types for the columns defined in the schema. Kindly check for that and i hope u r issue will be resolved
Thanks and Regards,
Pavan

Hi !
I began on Talend. I managed to connect Talend with my DB but when i want to extract data, i got a problem. Here is the backtrace :
Exception in component tOracleInput_1
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
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:754)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1315)
at testtalend.essaisixtus_0_1.EssaiSixtus.tOracleInput_1Process(EssaiSixtus.java:1171)
at testtalend.essaisixtus_0_1.EssaiSixtus.runJobInTOS(EssaiSixtus.java:2177)
at testtalend.essaisixtus_0_1.EssaiSixtus.main(EssaiSixtus.java:2045)

I just want to copy data from an OracleInput to an OracleOutput.
I can copy the schema of my table
Connexion with my DB, it's ok
But when i want to preview the data : "broken connexion".
I use PL/SQL Developer to check if the table exist, and it's ok.
Which parameters can i modify, check ?
More informations :
OS : Windows XP Pro v2002 SP3
TOS Version: 5.0.2 Build id: r78327-20120216-0244
Generated language : Java
Thanks a lot.
Best regards.
Dex

Re: [resolved] table or view does not exist error

Anonymous — Fri, 13 Apr 2012 09:52:31 GMT

Hi,
Thanks for your answer. I check the type for the columns and it's the same (i duplicate the table thanks to pl/sql developer). I try to modify and test all the "action on data" (create, drop, and so on) and nothing works.
Any others ideas ?!
Thanks and best regards
Dex.

Re: [resolved] table or view does not exist error

Anonymous — Fri, 13 Apr 2012 10:07:55 GMT

Hi,
I think i find my problem. I can work on the other tables from the DB but not on my table. I think there is a specific password. Does it possible to change password according to the table ?
Best regards,
Dex.

Re: [resolved] table or view does not exist error

Anonymous — Fri, 13 Apr 2012 10:10:23 GMT

Hi,
Can you modify you job and put a tMap in between tOracleInput and tOracleOutput and map the columns from input to output, because one of the reason this error occurs is if you don't have permissions on destinations table or if there are clob values in source and the destination had varchar2 type then this error appears
Thanks and Regards,
Pavan

Hi,
Thanks for your answer. I check the type for the columns and it's the same (i duplicate the table thanks to pl/sql developer). I try to modify and test all the "action on data" (create, drop, and so on) and nothing works.
Any others ideas ?!
Thanks and best regards
Dex.

Re: [resolved] table or view does not exist error

Anonymous — Fri, 13 Apr 2012 11:01:29 GMT

Hi,
I got the problem !! It's a problem query. As you can see on this image : http://imageshack.us/photo/my-images/404/tosrequetepb.png/
(Don't look my job, it's works but i have modify my request to have this result)
i have "from f_total" however i need to have "from dm_report_tools.f_total".
That's why the table does not exist. Do you know how to modify all the query to have the good syntax (how to prefix all my table with the good name schema ?) ?
Thanks a lot, best regards
Dex.

Re: [resolved] table or view does not exist error

Anonymous — Fri, 13 Apr 2012 12:43:01 GMT

Hi,
If you want to retreive data from tables which are prsent in different schema of database better you create a db connection for the schema and retrieve the schema of the tables which you want to process
Thanks and Regards,
Pavan

Re: [resolved] table or view does not exist error

Anonymous — Fri, 13 Apr 2012 13:23:50 GMT

Hi,
Thanks a lot for your help. It was a parameter connexion problem.
Thanks again, best regards
Dex