Skip to Content

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

Sep 26, 2017 at 04:05 AM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
Sep 26, 2017 at 05:55 AM

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.

10 |10000 characters needed characters left characters exceeded