EAL 11.1.2.2.500 Essbase partition cannot be created. ERROR: "1023057 - Cannot replace partition definition file while there are other active users on database [XXXX], check application log for details" (Doc ID 2054853.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Essbase Analytics Link for HFM - Version 11.1.2.2.500 to 11.1.2.2.500 [Release 11.1]
Information in this document applies to any platform.

Symptoms

EAL 11.1.2.2.500 with EPM 11.1.2.4.


Create Bridge Application or Essbase Create in the bridge receive the following error in EAS Console:

Error: Essbase partition cannot be created.

 

The eal.log will log the following error:

ERROR - 1023057 - Cannot replace partition definition file while there are other active users on database [XXXX], check application log for details

 

This occurs for both Replicated and Transparent partitions.


Here is an example of the full output seen in the EAL.log:

[2015-Sep-09 10:32:42]     CREATE OR REPLACE TRANSPARENT PARTITION 'TEST'.'TEST'  AREA '@UDA("ESSScenario","eal"), @UDA("ESSYear","eal"), @UDA("ESSPeriod","eal"), @UDA("ESSAccount","eal"), @UDA("ESSProducts","eal"), @UDA("ESSCustomers","eal"), @UDA("ESSCustom3","eal"), @UDA("ESSFlow","eal"), @UDA("ESSEntity","eal"), @UDA("ESSValue","eal"), @UDA("ESSICP","eal"), @UDA("ESSView","eal")' targetArea  FROM 'LL_AUN'.'LL_2' AT 'PS4:5025' AS 'XXX' identified by 'YYY'  AREA '@IDESCENDANTS("ESSCustom3")' sourceArea  COMMENT 'Created By Bridge: TEST' ;

[2015-Sep-09 10:32:42]     MaxL Errors: OK/INFO - 1051034 - Logging in user [(hidden)]

[2015-Sep-09 10:32:42] OK/INFO - 1051035 - Last login on Wednesday, September 09, 2015 10:32:42 AM

[2015-Sep-09 10:32:42] OK/INFO - 1054014 - Database LL_2 loaded

[2015-Sep-09 10:32:42] OK/INFO - 1051061 - Application LL_AUN loaded - connection established

[2015-Sep-09 10:32:42] OK/INFO - 1054027 - Application [LL_AUN] started with process id [3496]

[2015-Sep-09 10:32:42] OK/INFO - 1053012 - Object [LL_2] is locked by user [(hidden)]

[2015-Sep-09 10:32:42] OK/INFO - 1053012 - Object [TEST] is locked by user [admin@Native Directory]

[2015-Sep-09 10:32:42] OK/INFO - 1053013 - Object [TEST] unlocked by user [admin@Native Directory]

[2015-Sep-09 10:32:42] ERROR - 1023057 - Cannot replace partition definition file while there are other active users on database [TEST], check application log for details

[2015-Sep-09 10:32:42] OK/INFO - 1053013 - Object [LL_2] unlocked by user [(hidden)]

[2015-Sep-09 10:32:42] OK/INFO - 1051037 - Logging out user [(hidden)], active for 0 minutes

[2015-Sep-09 10:32:42] java.lang.Exception: MaxL command failed: MaxL command failed

[2015-Sep-09 10:32:42] at com.hyperroll.hfm2ess.outline.MaxlRunnerExecImpl.performMaxl(Unknown Source)

[2015-Sep-09 10:32:42] at com.hyperroll.hfm2ess.outline.PartitionCreator.createPartition(Unknown Source)

[2015-Sep-09 10:32:42] at com.hyperroll.hfm2ess.bridge.EssbaseProcess.createPartition(Unknown Source)

[2015-Sep-09 10:32:42] at com.hyperroll.hfm2ess.bridge.EssbaseProcess.createOutline(Unknown Source)

[2015-Sep-09 10:32:42] at com.hyperroll.hfm2ess.bridge.ws.BridgeOperationManagerImpl.createEssDatabaseMetadata(Unknown Source)

[2015-Sep-09 10:32:42] at com.hyperroll.hfm2ess.bridge.ws.BridgeOperationManager.createEssDatabaseMetadata(Unknown Source)

[2015-Sep-09 10:32:42] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[2015-Sep-09 10:32:42] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

[2015-Sep-09 10:32:42] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

[2015-Sep-09 10:32:42] at java.lang.reflect.Method.invoke(Method.java:597)

[2015-Sep-09 10:32:42] at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)

[2015-Sep-09 10:32:42] at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:151)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.server.sei.EndpointMethodHandlerImpl.invoke(EndpointMethodHandlerImpl.java:268)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:100)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:867)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:815)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:778)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:680)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:403)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:539)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:253)

[2015-Sep-09 10:32:42] at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:141)

[2015-Sep-09 10:32:42] at weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:172)

[2015-Sep-09 10:32:42] at weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)

[2015-Sep-09 10:32:42] at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)

[2015-Sep-09 10:32:42] at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)

[2015-Sep-09 10:32:42] at weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)

[2015-Sep-09 10:32:42] at weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)

[2015-Sep-09 10:32:42] at weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)

[2015-Sep-09 10:32:42] at weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)

[2015-Sep-09 10:32:42] at weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)

[2015-Sep-09 10:32:42] at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)

[2015-Sep-09 10:32:42] at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

[2015-Sep-09 10:32:42] at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

[2015-Sep-09 10:32:42] at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

[2015-Sep-09 10:32:42] at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:185)

[2015-Sep-09 10:32:42] at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3732)

[2015-Sep-09 10:32:42] at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

[2015-Sep-09 10:32:42] at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

[2015-Sep-09 10:32:42] at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

[2015-Sep-09 10:32:42] at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

[2015-Sep-09 10:32:42] at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

[2015-Sep-09 10:32:42] at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

[2015-Sep-09 10:32:42] at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

[2015-Sep-09 10:32:42] at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

[2015-Sep-09 10:32:42]     createPartition MAXL command failed:MaxL command failed: MaxL command failed

[2015-Sep-09 10:32:42]  LiveLinkException [HR#09839]: Essbase partition cannot be created

[2015-Sep-09 10:32:43] 09-Sep-2015 10:32:43 com.hyperion.dsf.server.framework.BaseLogger logWarning

[2015-Sep-09 10:32:43] WARNING: Essbase (B124000020000) and Java API (B124000010000) are on different protocol versions.

Changes

 Installed EAL 11.1.2.2.500 on EPM 11.1.2.4

Cause

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