OSM 7.2.2 Error When Cancelling Order - com.mslv.oms.OMSException: Error loading flow history

(Doc ID 2147158.1)

Last updated on JULY 06, 2016

Applies to:

Oracle Communications Order and Service Management - Version 7.2.2 to 7.2.2 [Release 7.2]
Information in this document applies to any platform.

Symptoms

Every time we try to cancel an order we are getting this error:

####<May 28, 2016 11:30:24 AM GMT> <Warning> <oms> <somecompany.com> <osm_ms01> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <osmAdmin> <BEA1-00BDF9E6DA4174108907> <8117ba88e8882052:-2f7e5e1e:154f71ecfbc:-8000-0000000000000074> <1464435024342> <BEA-000000> <dataaccesslayer.AbstractProxy: SQL Exception 17,410 : java.sql.SQLRecoverableException: No more data to read from socket>
####<May 28, 2016 11:30:24 AM GMT> <Error> <oms> <somecompany.com> <osm_ms01> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <osmAdmin> <> <8117ba88e8882052:-2f7e5e1e:154f71ecfbc:-8000-0000000000000074> <1464435024353> <BEA-000000> <ws.b: Error processing cancelOrder
com.mslv.oms.OMSException: Error loading flow history.
at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
at oracle.communications.ordermanagement.ws.b.a(Unknown Source)
at oracle.communications.ordermanagement.ws.OrderManagementWSPortImpl.cancelOrder(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.wsee.component.pojo.JavaClassComponent.invoke(JavaClassComponent.java:112)
at weblogic.wsee.ws.dispatch.server.ComponentHandler.handleRequest(ComponentHandler.java:84)
at weblogic.wsee.handler.HandlerIterator.handleRequest(HandlerIterator.java:141)
at weblogic.wsee.ws.dispatch.server.ServerDispatcher.dispatch(ServerDispatcher.java:114)
at weblogic.wsee.ws.WsSkel.invoke(WsSkel.java:80)
at weblogic.wsee.server.servlet.SoapProcessor.handlePost(SoapProcessor.java:66)
at weblogic.wsee.server.servlet.SoapProcessor.process(SoapProcessor.java:44)
at weblogic.wsee.server.servlet.BaseWSServlet$AuthorizedInvoke.run(BaseWSServlet.java:285)
at weblogic.wsee.server.servlet.BaseWSServlet.service(BaseWSServlet.java:169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3739)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3705)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2282)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2181)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused By: java.lang.RuntimeException: Error loading flow history.
at com.mslv.oms.handler.order.cache.compensation.m.c(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.m.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.j.c(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.j.b(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.j.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.k.b(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.k.c(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.k.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.a.c(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.a.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.a.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.c.executeIteration(Unknown Source)
at com.mslv.oms.amendorder.a.a(Unknown Source)
at com.mslv.oms.amendorder.a.a(Unknown Source)
at com.mslv.oms.amendorder.a.a(Unknown Source)
at com.mslv.oms.amendorder.a.a(Unknown Source)
at com.mslv.oms.handler.cancelorder.CancelOrderHandlerEJB.a(Unknown Source)
at com.mslv.oms.handler.cancelorder.CancelOrderHandlerEJB.process(Unknown Source)
at com.mslv.oms.handler.a.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
at oracle.communications.ordermanagement.ws.b.a(Unknown Source)
at oracle.communications.ordermanagement.ws.OrderManagementWSPortImpl.cancelOrder(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.wsee.component.pojo.JavaClassComponent.invoke(JavaClassComponent.java:112)
at weblogic.wsee.ws.dispatch.server.ComponentHandler.handleRequest(ComponentHandler.java:84)
at weblogic.wsee.handler.HandlerIterator.handleRequest(HandlerIterator.java:141)
at weblogic.wsee.ws.dispatch.server.ServerDispatcher.dispatch(ServerDispatcher.java:114)
at weblogic.wsee.ws.WsSkel.invoke(WsSkel.java:80)
at weblogic.wsee.server.servlet.SoapProcessor.handlePost(SoapProcessor.java:66)
at weblogic.wsee.server.servlet.SoapProcessor.process(SoapProcessor.java:44)
at weblogic.wsee.server.servlet.BaseWSServlet$AuthorizedInvoke.run(BaseWSServlet.java:285)
at weblogic.wsee.server.servlet.BaseWSServlet.service(BaseWSServlet.java:169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3739)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3705)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2282)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2181)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused By: com.mslv.oms.dataaccesslayer.ProxyException: No more data to read from socketNested Exception: No more data to read from socketNested Exception: java.sql.SQLRecoverableException: No more data to read from socket
at com.mslv.oms.dataaccesslayer.AbstractProxy.execute(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.m.c(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.m.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.j.c(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.j.b(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.j.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.k.b(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.k.c(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.k.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.a.c(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.a.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.a.a(Unknown Source)
at com.mslv.oms.handler.order.cache.compensation.c.executeIteration(Unknown Source)
at com.mslv.oms.amendorder.a.a(Unknown Source)
at com.mslv.oms.amendorder.a.a(Unknown Source)
at com.mslv.oms.amendorder.a.a(Unknown Source)
at com.mslv.oms.amendorder.a.a(Unknown Source)
at com.mslv.oms.handler.cancelorder.CancelOrderHandlerEJB.a(Unknown Source)
at com.mslv.oms.handler.cancelorder.CancelOrderHandlerEJB.process(Unknown Source)
at com.mslv.oms.handler.a.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
at oracle.communications.ordermanagement.ws.b.a(Unknown Source)
at oracle.communications.ordermanagement.ws.OrderManagementWSPortImpl.cancelOrder(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.wsee.component.pojo.JavaClassComponent.invoke(JavaClassComponent.java:112)
at weblogic.wsee.ws.dispatch.server.ComponentHandler.handleRequest(ComponentHandler.java:84)
at weblogic.wsee.handler.HandlerIterator.handleRequest(HandlerIterator.java:141)
at weblogic.wsee.ws.dispatch.server.ServerDispatcher.dispatch(ServerDispatcher.java:114)
at weblogic.wsee.ws.WsSkel.invoke(WsSkel.java:80)
at weblogic.wsee.server.servlet.SoapProcessor.handlePost(SoapProcessor.java:66)
at weblogic.wsee.server.servlet.SoapProcessor.process(SoapProcessor.java:44)
at weblogic.wsee.server.servlet.BaseWSServlet$AuthorizedInvoke.run(BaseWSServlet.java:285)
at weblogic.wsee.server.servlet.BaseWSServlet.service(BaseWSServlet.java:169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3739)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3705)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2282)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2181)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

In DB alert file, following entry is found
----
Sat May 28 11:13:55 2016
Timed out trying to start process O00F.
Sat May 28 11:30:21 2016
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x6B57C50, kkpamCheckTransJoin()+318] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/dbm/dbm1/trace/dbm1_ora_1948.trc (incident=116217):
ORA-07445: exception encountered: core dump [kkpamCheckTransJoin()+318] [SIGSEGV] [ADDR:0x0] [PC:0x6B57C50] [SI_KERNEL(general_protection)] []
Incident details in: /u01/app/oracle/diag/rdbms/dbm/dbm1/incident/incdir_116217/dbm1_ora_1948_i116217.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat May 28 11:30:23 2016
Dumping diagnostic data in directory=[cdmp_20160528113023], requested by (instance=1, osid=1948), summary=[incident=116217].
Sat May 28 11:30:24 2016
Sweep [inc][116217]: completed
Sweep [inc2][116217]: completed

----
We are running OSM in a database cluster version "Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production".

We tested with another database version and we do not have errors (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production), so we think this could be related with the database.



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