See the below links will helful to you,
We had the same issue...This is an upublihser bug for which oracle supplies a patch
Bug 9884975 - 11G ADMIN TOOL RECEIVES NQSERROR: 37005 WHEN SAVING ONLINE RPD CHANGES
The fix for the unpublished Bug 9884975 is included in Patch 12909840 - GETTING ERROR :  INTERNAL ASSERTION: CONDITION M_LOCK.ISACQUIRED()
The patch appears to be valid only for 220.127.116.11. I've upgraded to 18.104.22.168.2 via 8 different patches, and the error still exists.
how to reslove this error can you please explain me in detail.
Edited by: kesana on 11-Jul-2012 02:42
In order to work aroud, you will have to make changes in offline mode and deploy the RPD instead of doing the changes in online mode.
Jus stop all opmn services n open the rep in offline mode.
make changes whevr u wnt n start all BI components.
Just in case someone has the same problem.
We are using OBIEE 22.214.171.124.6, and I was running into this problem whenever I tried to add a new foreign key in the physical model, it was only with one foreign key. We don't use the default names for foreign keys, we use certain precise notation, and after several attemps, I found out the problem was that name was already in use for another foreign key (I made a mistake naming the previous foreign key). After correcting the older foreign key name I could add the new foreign key without the transactional update problem.