Error: "user's password will expire within few days" with a DB connection to HANA

[adwilaa]

We are using EPM Add-in to connect to HANA MD provider (a DB connection to HANA). The error message “user's password will expire within few days: expire time (UTC) at [<UTC timestamp>]” is received and the connection fails.

However, if we try to log in to HANA studio with the same user, the user can log in successfully.

I found KBA 1752349 related but still not sure whether it's the normal behavior.

[lbreddemann · Accepted solution]

The warning about a soon to expire user is sent as a SQL warning from HANA. This is distinct from a SQL Error message and not all client software actively checks for this.

HANA Studio does check this and displays a little information triangle at the login in the system navigator. So, the user will expire soon, but is technically still able to connect right now. To solve the logon problem with clients that do not evaluate the warning correctly, simply extend the validity period of the user accordingly.

[former_member311115]

It's funny how HanaConnection works in this case. First time it throws the error “user's password will expire within few days: expire time (UTC) at [<UTC timestamp>]”, but if you connect second time from the same app, it works without throwing any errors 🙂