nQSError: 37005 Transnational Update Failed

This issue was there since version 11.1.1.3.x. It will appear if you edit an OBIEE repository in online mode.The administrator tool for editing the RPD is unable sometimes to acquire an exclusive lock on the objects, that in turn causes the error message.Checking in the changes on a regular basis will reduce the occurrence of this error.

• One more thing you can try for this bug is,

Failures that trigger this error are normally written to the NQServer.log file located in C:\Middleware\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1

Check this file for errors like "has name with leading or trailing space(s)". Fix that, check for consistency and save. Then restart the services.

As per my knowledge, this should be the most preferable solution.

• As a temporary solution, the following workaround can be used.

1. After you click on the Check-in button, do Consistency Check.
2. Click ‘Save’ button.It will display the ‘nQSError: 37005 Transnational Update Failed’ error.
3. Click ‘Save’ one more time despite the error.
4. Click the ‘Close’ button.You will get a prompt, Do you want to check in the changes?
5. Select ‘Yes’, you will get the error again.
6. Click the ‘Close’ button again.Then you will get a prompt, Do you want to check in the changes?
7. Select ‘No’.Then the RPD will close.
8. If the RPD says ‘your changes will get saved’ then it means that your changes will be there when you re-open the repository.

• To permanently resolve this Bug 9884975, apply patch number 12909840 to your OBIEE platform. Oracle Support released a patch for the [nQSError: 37005] Transaction update failed error.
  Remember that you have to ask the patch password (by opening a new SR) in order to download it.