Error 1053010 Object [db] is already locked by use

Error(1053010) @ Object [db] is already locked by user

When the all the Essbase Object in the db is locked then the connections made to the particular cube will not be accepted and it will throw the error we need to unlock all the objects in the db 

When the db is locked we cant insert into the particular db so when we run nay process in the fusion applications then the process may end up  in the error

When the Db is locked then we will get this kind of error messages

Mon Nov 19 15:07:42 2012]Local/ESSBASE0///1111554368/Info(1051001)@ Received client request: Lock Object (from user @ [FUSION_APPS_GL_ESSBASE_APPID])

Mon Nov 19 15:07:42 2012]Local/ESSBASE0///1111554368/Error(1053010)@ Object [db] is already locked by user [FAADMIN]

[Mon Nov 19 15:07:42 2012]Local/ESSBASE0///1111554368/Warning(1051003)@ Error 1053010 processing request [Lock Object] - disconnecting

Cannot open cube outline. null[[
com.essbase.api.base.EssException: Cannot open cube outline. null
at com.essbase.server.framework.EssOrbPluginDirect.ex_olap(Unknown Source)
at com.essbase.server.framework.EssOlapMetaDataService

We need to unlock all the objects in the db to solve this issue

Step 1

Log-in in to the MAXL form the command prompt 

navigate to the startMAXL.sh script and start it

Using MaxL, you can automate administrative operations on Essbase databases. You can write MaxL scripts with variables to make them customization and reusable.For Essbase to receive and parse MaxL statements, you must “pass” them to the Essbase Server using either the MaxL Shell (essmsh), Administration Services, or a customized Perl program that uses the MaxL Perl Module, which enables you to embed its statements in Perl programs.

[oracle@faht bin]$ ./startMAXL.sh

 Essbase MaxL Shell 64-bit - Release 11.1.2 (ESB11.1.2.2.001B3010)

 Copyright (c) 2000, 2012, Oracle and/or its affiliates.

 All rights reserved.

MAXL>

Step 2

Login to the MAXL command prompt 

Syntax :login <username> <password> on localhost:10215

MAXL> login faadmin <password> on localhost:10215;

 WARNING - 1040132 - Opening a wallet(path) failed(28759).                                                                                      

 WARNING - 1040156 - SSL initialization failed with error code [1040132]..

 OK/INFO - 1051034 - Logging in user [FAADMIN].

 OK/INFO - 1241001 - Logged in to Essbase.

Step 3

Unlock all the objects 

To Unlock all the objects which is in the particular db we need to proceeded with this command 

Syntax : alter database <database_name>.db unlock all objects;

MAXL> alter database OIC_ACCOUNTING_FLEX.db unlock all objects;

 OK/INFO - 1056023 - Database OIC_ACCOUNTING_FLEX.db altered.

Step 4

Check the application status  by using the display application 

MAXL> display application;

 

 application         comment             startup             autostartup         minimum permission  connects            commands            updates             security            lock_timeout        max_lro_file_size   application_type    application_locale  server              application_status  elapsed_time        users_connected     storage_type        number_of_databases

+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------

 OIC_ACCOUNTING_FLEX Standard Applicatio                TRUE               FALSE no_access                          TRUE                TRUE                TRUE                TRUE                3600                   0                   3 English_UnitedState fah.                   2 02:00:54:55                           0                   4                   1

 OIC_ACCOUNTING_FLEX Standard Applicatio                TRUE               FALSE no_access                          TRUE                TRUE                TRUE                TRUE                3600                   0                   3 English_UnitedState fah.                   0 00:00:00:00                           0                   4                   1

 OIC_ACCOUNTING_FLEX Standard Applicatio                TRUE               FALSE no_access                          TRUE                TRUE                TRUE                TRUE                3600                   0                   3 English_UnitedState fah.                   2 02:00:54:55                           0                   4                   1

 WARNING - 1241024 - Possible string truncation in column 2.

 WARNING - 1241028 - Output column defined with warnings.

 WARNING - 1241024 - Possible string truncation in column 14.

 WARNING - 1241028 - Output column defined with warnings.

 OK/INFO - 1241044 - Records returned: [3].