topic Re: Data not fetching in tOracleInput component in Talend Studio

Data not fetching in tOracleInput component

Rathesh — Wed, 03 Oct 2018 19:17:08 GMT

I am trying to move data from a oracle table to its archive table using talend. In tOracleInput component, i have included the query which fetches the data to be archived. I am moving data which are older than 2 months to archive based on date column in parent table. In child table, data is moved by linking parent table with foreign key relationship and and based on date. If i execute the query in sql developer data is fetching. Same query is used in talend, but it is not fetching data and job runs with no error. if i remove where condition it is fetching data in talend.

Re: Data not fetching in tOracleInput component

manodwhb — Thu, 04 Oct 2018 06:26:22 GMT

@Rathesh,can you make sure are you pointing to right DB? and also check that the same query are you used in Talend where in SQL was giving the output?

Re: Data not fetching in tOracleInput component

Anonymous — Thu, 04 Oct 2018 08:01:04 GMT

Hi,

Could you please share the component screen shots (basic and advanced) and also the query you are executing in Talend?

Another query is whether you are using same user id while fetching data using SQL developer and Talend.

Warm Regards,

Nikhil Thampi

Re: Data not fetching in tOracleInput component

Rathesh — Wed, 10 Oct 2018 17:15:43 GMT

I don't know what is happening in talend 7.1. Sometimes it is fetching and sometimes not.

Re: Data not fetching in tOracleInput component

Anonymous — Wed, 10 Oct 2018 17:43:54 GMT

Hi Rathesh,

Could you please share the screen shot of your job and the component where you are getting the error? If you could share the error message it will help to narrow down the possibilities.

I doubt the error has anything to do with version 7.1. Did you find any pattern when the data is not getting loaded? Is it something like waiting for any commit to happen from previous transaction?

Warm Regards,

Nikhil Thampi

Re: Data not fetching in tOracleInput component

Anonymous — Tue, 14 Apr 2020 22:17:10 GMT

Hi!

I have loaded a table in oracle using tOracleOutput from a csv file. Then i go to oracle and update a record using the update query.

After this if i load the oracle table again, it is not showing the updated changes but is reflecting the old data only.

Any help is appreciated.

Re: Data not fetching in tOracleInput component

manodwhb — Wed, 15 Apr 2020 01:54:33 GMT

Have you commited changes?