When the Oracle DB password is about to expire, it will show a message box in developer tools like "PL/SQL Developer". This is just a warning message by Oracle DB and has an ORA code. Still, this seems to be an unsolved (uncaught) exception in Talend
Yes, that's right. But the Talend stops the execution and throws a schema error in tOracleInput, that's the problem
Yes, DB connection works well after extending the password's validity and well before the password expiry warning arise.
This fails only when the Oracle DB's password is about to expire (before five days)
So both components tDBInput AND tDBConnection raise an exception when a password is about to expire?
However, quite unusual to set an expiration date for a system/backend user... a common practice for 'batch_etl_talend' user:
alter profile <profile_name> limit password_life_time UNLIMITED;
Yes, these components "tDBInput AND tDBConnection" raise the exception, but the wrong one (schema exception) which I addressed as an uncaught exception
Please refer post - 3
I want this issue to be fixed in Talend
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.