Unlock a stubborn outline

From The Essbase Wiki

Jump to: navigation, search

I had a stubborn outline that I did this to. A different user had a lock on it and for whatever reason, I couldn't unlock it from EAS (version 7.x). So I fired up a MaxL shell:

This was run on the server itself but could easily be run from a remote location by specifying which analytic server to login to. Replace admin and password with the respective ID of a superuser, and of course, replace appname and databasename with the app/database to unlock objects for.

C:\>essmsh
Analytic Services MaxL Shell - Release 7.1.6 (ESB7161B001)
(c) Copyright 2000-2006 Hyperion Solutions Corporation.
All rights reserved.
MAXL> login admin password;
OK/INFO - 1051034 - Logging in user [admin].
OK/INFO - 1051035 - Last login on Thursday, September 24, 2009 2:24:23 PM.
OK/INFO - 1241001 - Logged in to Essbase.
MAXL> alter database appname.databasename unlock all objects;
OK/INFO - 1056023 - Database appname.databasename altered.
MAXL> quit;
MaxL Shell completed
Personal tools