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!
Find out about Talend's 2019 Summer release
Talend continues to revolutionize how businesses leverage speed and manage scale
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend