When trying to save online the repository, sometimes we get the error “[nQSError: 37005] Transaction update failed”.
This error occurs when the repository is not consistent (The error was due to having in the rpd one table with twice exactly the same key with same name). This error disappears once OBIEE services (OPMN Components) are restarted from Enterprise Manger. However this bug has been fixed in the following versions:
OBIEE 22.214.171.124.0 BP2 (download and install patch 13611078).
Till Next Time