Error While Deploying Composite Cartridge - java.sql.SQLException: ORA-20500: Task not found. (Doc ID 1904488.1)

Last updated on DECEMBER 24, 2015

Applies to:

Oracle Communications Order and Service Management - Version 7.2.2 and later
Information in this document applies to any platform.
Review relevance Dec 24, 2015

Symptoms

Received following error while deploying composite cartridge

<28-Apr-2014 7:51:32,713 IST PM> <ERROR> <core.logSQLException> <[ACTIVE] ExecuteThread: '31' for queue: 'weblogic.kernel.Default (self-tuning)'> <SQL Exception 20,500 : ORA-20500: Task not found.
ORA-06512: at "ORDERMGMT_CLOUD2.OM_AUTOMATION_PKG", line 237
ORA-06512: at line 1
>
java.sql.SQLException: ORA-20500: Task not found.
ORA-06512: at "ORDERMGMT_CLOUD2.OM_AUTOMATION_PKG", line 237
ORA-06512: at line 1

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
       at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
       at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1075)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
       at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
       at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9259)
       at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
       at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
       at com.mslv.oms.dataaccesslayer.CallableProxy.executeStatement(Unknown Source)
       at com.mslv.oms.dataaccesslayer.AbstractProxy.execute(Unknown Source)
       at com.mslv.oms.eventengine.EventDispatcherEJB.a(Unknown Source)
       at com.mslv.oms.eventengine.EventDispatcherEJB.registerTaskEvent(Unknown Source)
       at com.mslv.oms.eventengine.EventDispatcher_86q3j1_EOImpl.__WL_invoke(Unknown Source)
       at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
       at com.mslv.oms.eventengine.EventDispatcher_86q3j1_EOImpl.registerTaskEvent(Unknown Source)
       at com.mslv.oms.automation.deploy.RegisterEventHandler.registerEvent(Unknown Source)
       at com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.b(Unknown Source)
       at com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.a(Unknown Source)
       at com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.refresh(Unknown Source)
       at com.mslv.oms.automation.plugin.AutomationEventHandlerImpl$1.refresh(Unknown Source)
       at oracle.communications.ordermanagement.b.a.a.a(Unknown Source)
       at com.mslv.oms.model.MetaDataManager$1.onMetaDataRefresh(Unknown Source)
       at com.mslv.oms.model.MetaDataManager.refresh(Unknown Source)
       at oracle.communications.ordermanagement.cluster.BusinessRequestBalancer.q(Unknown Source)
       at com.mslv.oms.priviledgeoperations.PriviledgedOperationsEJB.refreshLocalServerMetaData(Unknown Source)
       at com.mslv.oms.priviledgeoperations.PriviledgedOperations_helmzh_ELOImpl.__WL_invoke(Unknown Source)
       at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
       at com.mslv.oms.priviledgeoperations.PriviledgedOperations_helmzh_ELOImpl.refreshLocalServerMetaData(Unknown Source)
       at com.mslv.oms.eventengine.EventDispatcherEJB.refreshLocalServerCache(Unknown Source)
       at com.mslv.oms.eventengine.EventDispatcher_86q3j1_EOImpl.__WL_invoke(Unknown Source)
       at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
       at com.mslv.oms.eventengine.EventDispatcher_86q3j1_EOImpl.refreshLocalServerCache(Unknown Source)
       at com.mslv.oms.cartridgemgmt.DeployCartridgeMDB.a(Unknown Source)
       at com.mslv.oms.cartridgemgmt.DeployCartridgeMDB.a(Unknown Source)
       at com.mslv.oms.cartridgemgmt.DeployCartridgeMDB.a(Unknown Source)
       at com.mslv.oms.cartridgemgmt.DeployCartridgeMDB.onMessage(Unknown Source)
       at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:583)
       at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:486)
       at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:388)
       at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
       at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
       at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
       at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
       at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
       at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
       at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
       at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)


<30-Apr-2014 8:22:13,966 EDT AM> <ERROR> <core.logSQLException> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <
SQL Exception 20,051 : ORA-20051: Notification cannot be found.  notification mnemonic = WirelessSOMEProcess_SendCustomEmailFalloutNotification.
ORA-06512: at "OSM7223_WN.ERROR_MSG", line 8
ORA-06512: at "OSM7223_WN.OM_EVENT_PKG", line 344
ORA-06512: at line 1
>
java.sql.SQLException: ORA-20051: Notification cannot be found.  notification mnemonic = WirelessSOMEProcess_SendCustomEmailFalloutNotification.
ORA-06512: at "OSM7223_WN.ERROR_MSG", line 8
ORA-06512: at "OSM7223_WN.OM_EVENT_PKG", line 344
ORA-06512: at line 1

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

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