This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hello!
Since our move to 7.6.0.4 we've been unable to properly turn Admin Mode off as we've got some bad data in our LOCHIERARCHY table. The CHILDREN attribute is incorrect on about 1500 records, as well as a few other, more easily fixed issues. When Admin Mode tries to reload the cache the LOCATION service does not restart properly and thus Admin Mode stays on until you fully restart Maximo.
So my question is this, are there any utilities or easy ways you know of to rebuild the LOCHIERARCHY data?
How familiar are you with locancestor?
Fairly familiar. I've built a query to show the full hierarchy. Are you suggesting we use this to rebuild LOCHIERARCHY through SQL?
---In MAXIMO@yahoogroups.com, <boyddensmore@protonmail.com> wrote :
Fairly familiar. I've built a query to show the full hierarchy. Are you suggesting we use this to rebuild LOCHIERARCHY through SQL?
That's exactly where I'm going. You'll want to build an update script that changes the parent for each location in one go. The usual disclaimers apply, backup the table, etc, You'll lose location move history unless you want to insert new rows there, entirely up to you.
-C