My Oracle Support Banner

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 JUNE 01, 2018

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
===================
1. Administration
2. Database account
3. Put in the user name, database account name, password and confirm password.
4. Users immediately see the aforementioned error messages.



 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.