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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.