MicroStrategy – Resolving Hung Database Connections in MicroStrategy IServer

This could be achieved by/through different ways:

        1) Disconnect the DB connection inside MicroStrategy Desktop ~ Administration
        2) Kill the task manager running process
        3) Disconnect the DB connection at the DB Layer (Which is not in scope of this discussion, as it varies from DB to DB)
        4) I happened to get the same request for XML based MDX reports from MicroStrategy ~ which is not available and the only way for that is to delete the connections from DB Layer and not at MicroStrategy layer. Because MicroStrategy doesn’t supports that since they are working as design as per XML standards (Will post the tech note for the same in the coming post regarding it)
       5) Also need to enable the setting at DB instance level to disconnect db connections if idle

Tools/Components Required for the same:

      1) MicroStrategy Desktop (with Administrator rights to disconnect the DB connections) {OR}
      2) MicroStrategy Command Manager to trigger the disconnect command (With command manager and disconnect privilege for the user to execute)

 (Syntax 🙂 DELETE DBCONNECTION “<dbConnection_name>”;
      3) Place the required logic in the script (windows/unix depending on the installation) and execute the script to perform actions

Tech Note for the same as reference: