Tried to create UAT from OPSConsole and now Prod is metadata locked but unable to get into ConfigDB to change.

Version 1

    Details

    Tried to create UAT from OPSConsole and now Prod is metadata locked but unable to get into ConfigDB to change.


    Resolution

     

    1. Run the following query to identify the name of the Tenant that is in metadata locked mode (if not familiar with the naming convention):

       

      SELECT TenantURL, IsMetaReadOnly

      FROM ConfigDB.dbo.Tenants

         

    1. Based on above returned results, run the following to reset the metadata read only setting using the proper TenantURL value returned as a “1” or locked:

       

      UPDATE ConfigDB.dbo.Tenants

      SET IsMetaReadOnly = 0

      WHERE TenantURL = ‘Win2012-XL’

       

    2. Either do an IISReset or recycle the HEATAppServerAppPool.

    3. You should now be able to re-launch the browser and gain access to the Configure Application AdminUI.