topic Re: tOracleInput throws error when Oracle DB password is about to expiry in Talend Studio

tOracleInput throws error when Oracle DB password is about to expiry

abarjun — Tue, 18 Sep 2018 04:46:48 GMT

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

Re: tOracleInput throws error when Oracle DB password is about to expiry

Jesperrekuh — Tue, 18 Sep 2018 12:25:34 GMT

Its definitely NOT an uncaught exception.
As you're saying, its a warning... so an error should never be raised. And as of errors are raised by throwing an exception (in Java) and this is a warning, behavior is as expected and should not be treated as an error.

However it would be nice if tDBcomponents are able to handle warnings too, like OnComponentWarning, or OnComponetResultInfo or something like that.

Re: tOracleInput throws error when Oracle DB password is about to expiry

abarjun — Tue, 18 Sep 2018 12:30:36 GMT

Yes, that's right. But the Talend stops the execution and throws a schema error in tOracleInput, that's the problem

Re: tOracleInput throws error when Oracle DB password is about to expiry

Jesperrekuh — Tue, 18 Sep 2018 12:35:47 GMT

Aaah now I get your title ) , sorry...
Does the DBConnection work, did you try that? Or are you connecting via tDBInput? There's a checkbox which you could uncheck in order not to 'die' when there's an error, not preferable.

Re: tOracleInput throws error when Oracle DB password is about to expiry

abarjun — Tue, 18 Sep 2018 12:59:01 GMT

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)

Re: tOracleInput throws error when Oracle DB password is about to expiry

Jesperrekuh — Tue, 18 Sep 2018 13:09:24 GMT

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;

Re: tOracleInput throws error when Oracle DB password is about to expiry

abarjun — Tue, 18 Sep 2018 13:33:18 GMT

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

Re: tOracleInput throws error when Oracle DB password is about to expiry

Jesperrekuh — Tue, 18 Sep 2018 14:07:18 GMT

I think you need to report a Bug. If you are on an enterprise license maybe you can get a temporary fix ... otherwise... wait and pray!