Unable to Turn off Admin Mode

Body

In certain cases you can't turn off the Admin Mode you will see some errors like this "Cache LOCHI could not be initialized".

The IBM tech not explains how to resolve this issue. If you have followed the solution and still not not resolved you can try the below solution. Find out you have any orphaned location records.

First get a list of the distinct system id's in the lochierarchy table with

select distinct systemid from lochierarchy;
 
For each systemid do this:
 
Create a  temporary table with this statement
 
create table mec_lochierarchy as (select * from lochierarchy where systemid = '{insert system id}');
 
Then look at the hierarchy tree with this statement

select level ||' ' || lpad('-',8*(level-1)) || location || ' ' || children from mec_lochierarchy start with parent is null connect by prior location =  parent;
 
And pay particular attention to the rowcount. Then do

select count(*) from mec_lochierarchy;
 
And see if the rowcount from the hierarchical query and the count(*) match. If they do then everything is good with that systemid. If not, you can find the orphaned records with this query.
 
select location from mec_lochierarchy minus select location from mec_lochierarchy start with parent is null connect by prior location = parent;
 
Once you can see the orphaned records update to correct the data. Don't forget to drop your temporary table mec_lochierarchy when you're done.

In some cases locations have two trees, both trying to be the primary tree. One with site 'BEDFORD' and another with site 'FLEET'. Top of both of these trees only one of these could have been the parent in the PRIMARY system.

SELECT location, PARENT FROM LOCHIERARCHY WHERE SITEID = 'BEDFORD' MINUS select location, PARENT from LOCHIERARCHY WHERE SITEID = 'BEDFORD' start with parent is null connect by prior location = parent;
 
And I ran this for each record found in this query:

select distinct siteid from lochierarchy;