OBIEE: Gotcha #3
I received this wonderfully informative error this evening:
Value[nQSError: 36006] Promotion of checkout lock on Value to exclusive failed.Lacking an Oracle Support login...I ventured to Google. Just like the error, it was wonderfully uninformative.
Log files?
Nothing.
This halted all development for me. Not
all, I could make one change, check it in (save) and then I would get that error again. Wonderful.
From what I could piece together, and this is the purest form of speculation, it had something to do with naming.
I had a Physical database named "LOV"
I had a couple of columns (different tables) in another database with the same name.
These were all combined into one subject area.
Therefore that had to be the issue.
Or not. Who knows?
How did I fix it?
Shutdown the BI Server, opened up the RPD in read-only mode, did what I had to do and saved it...no error. Sweet.
Fired up the BI Server, opened up the RPD...you can only open this in read-only mode. WTF?
Let's try this again.
Shutdown.
Start.
Login. Success!
I almost followed the universal Windows rule of
rebooting 3 times...almost.
Labels: gotcha, obiee, oradb, rant
