Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 26, 2017 at 05:55 AM
    -1

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 04 at 08:40 PM

    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 :)

    Add comment
    10|10000 characters needed characters exceeded