Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 and laterInformation in this document applies to any platform.
*********Currency checked on 13-Oct-2017 *************

Symptoms

When OSM starts receiving orders, OSM is is trying to insert into a partition which is not present in the Database.When we checked om_order_id_block; we could see new entries for partitions which are not present in DB.

The following is the Error stack trace :

#### <ms1> <[ACTIVE] ExecuteThread: '200' for queue: 'weblogic.kernel.Default (self-tuning)'> <> 4400: inserted partition key does not map to any partitionORA-06512: at "ORDERMGMT.OM_WF_API", line 4283ORA-06512: at "ORDERMGMT.OM_WF_API", line 4198ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 1722ORA-06512: at line 1Nested Exception: ORA-14400: inserted partition key does not map to any partitionORA-06512: at "ORDERMGMT.OM_WF_API", line 4283ORA-06512: at "ORDERMGMT.OM_WF_API", line 4198ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 1722ORA-06512: at line 1

java.lang.RuntimeException: com.mslv.oms.OMSException: ORA-14400: inserted partition key does not map to any partitionORA-06512: at "ORDERMGMT.OM_WF_API", line 4283ORA-06512: at "ORDERMGMT.OM_WF_API", line 4198ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 1722ORA-06512: at line 1Nested Exception: ORA-14400: inserted partition key does not map to any partitionORA-06512: at "ORDERMGMT.OM_WF_API", line 4283ORA-06512: at "ORDERMGMT.OM_WF_API", line 4198ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 1722ORA-06512: at line 1

at oracle.communications.ordermanagement.ws.f.a(Unknown Source) at oracle.communications.ordermanagement.ws.a.a(Unknown Source) at oracle.communications.ordermanagement.ws.OrderManagementWSPortImpl.createOrder(Unknown Source) at sun.reflect.GeneratedMethodAccessor782.invoke(Unknown Source) 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.jms.JmsWebservicesMessageDispatcher$1.run(JmsWebservicesMessageDispatcher.java:191) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146) at weblogic.wsee.server.jms.JmsWebservicesMessageDispatcher.dispatchMessage(JmsWebservicesMessageDispatcher.java:186) at oracle.communications.ordermanagement.ws.WebserviceJMSTransportSubstitute.onMessage(Unknown Source) at sun.reflect.GeneratedMethodAccessor781.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)