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.
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?
