Skip to Content
0
Former Member
Aug 02, 2016 at 09:23 PM

Can I unlock a universe by clearing OBJ_M_UNIVERSES.M_UNI_N_LOCKER?

47 Views

I have previously posted that I have a universe that refuses to unlock by normal means. My shop is running an antiquated Business Objects 6.5.1, which lacks features referenced in a recent KB solution to the problem, so I was unable to use the KB solution.

I have been manually exploring the tables in the Oracle database that houses this universe domain. I think I've found a clue.

I have found that table OBJ_M_UNIVERSES has a row for this universe. Item M_UNI_N_LOCKER for that row holds the numeric value 123. A different row in OBJ_M_UNIVERSES, for a different universe that is not locked, carries a numeric value of 0 in M_UNI_N_LOCKER.

Looking in table OBJ_M_ACTOR, I see that M_ACTOR_N_ID = 123 is the value for the user who has this universe locked.

If I reset that M_UNI_N_LOCKER value from 123 to 0, will that unlock the universe? Or is there something more I need to do?