Friday, February 24, 2012

Persistence of disabled Allow connects

ESSbase - v11.1.1.3
DBAG - Release 11.1.1 - Page# 635

To disable connections to an application we would uncheck the option Allow connects on the application properties.  DBAG states the persistence of this disabled option as below:

Connections are disabled until any of the following actions occur:
1. The application is stopped and restarted.
2. An administrator re-enables connections.

I had to disable connections to an application & tried to test option1.  I had stopped the database, stopped the application, started the application back & found that the option is still unchecked which is in contrary to option1.

To further test it, I had restarted the ESSbase service & found that the option has been checked now.  To confirm the behavior I had tested it again & the results are same.  So here is what I concluded:

Connections are disabled until any of the following actions occur:
1. The ESSbase (not application) is stopped and restarted.
2. An administrator re-enables connections.

**DBAG could be right & our ESSbase environ might be mischievous, who knows!!