Currently, Strategy does not support changing the metadata (MD) database connection passwords when the Intelligence Server is running. If you change the MD database connection passwords without restarting the Intelligence Server, almost all jobs related to the metadata server will fail.
You receive the following error:
Error obtaining a server session: (Invalid operation in authentication due to one of the following: connection to the database server is lost; no available memory; the configuration is in an inconsistent state.)
This is happening because the MD database connection passwords is cached in-memory. The cached passwords will not update if you change the database connection passwords while the Intelligence Server is running.
You should restart the Intelligence Server.
