LSH 2.3: "Unexpected Error", "JBO-26041" and "ORA-01086: savepoint 'BO_SP'" Creating a Database User in LSH GUI (Doc ID 1587852.1)

Last updated on JULY 04, 2016

Applies to:

Oracle Life Sciences Data Hub - Version 2.3 and later
Information in this document applies to any platform.

Goal

Users get the following error message trying to create a new Database User inside LSH User Interface:

"You have encountered an unexpected error"

and with diagnostics on, the click here link shows:

Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Rollback to Savepoint": SQL Statement "null". at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797) at oracle.apps.cdr.security.webui.CreateDbAccountCO.processFormRequest(CreateDbAccountCO.java:124) at oracle.apps.cdr.framework.webui.CdrControllerImpl.processFormRequest(CdrControllerImpl.java:234) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385) at

..

com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: ORA-01086: savepoint 'BO_SP' never established in this session or is invalid at

 

Steps to Replicate

==============

Administration --> Database account --> put in the user name, database account name, password and confirm password.

Users immediately see the aforementioned error messages.


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms