4 Replies Latest reply: Jan 29, 2013 7:21 AM by 987083 RSS

    Message while executing the Automation Task execution

    987083
      Hi,

      I have written an xquery in that I asked to concat 2 variables in an automation task, the variable is getting concatinated and displayed in the log but its not updating in the Task webclient and also the following message is getting repeated in the log file while executing the automation taks, till the task ends. For making the concatinated value to appear in the task webclient what should I do? I have added the xquery and log file with this. Please take a look at it

      Xquery

      declare namespace saxon="http://saxon.sf.net/";
      declare namespace xsl="http://www.w3.org/1999/XSL/Transform";

      (: OSM namespaces :)
      declare namespace oms="urn:com:metasolv:oms:xmlapi:1";

      (: JAVA APIs namespaces: only require to be declared when editing with Oxygen :)
      declare namespace context = "java:com.mslv.oms.automation.TaskContext";
      declare namespace automator = "java:oracle.communications.ordermanagement.automation.plugin.ScriptReceiverContextInvocation";
      declare namespace log = "java:org.apache.commons.logging.Log";

      (: XML format control :)
      declare option saxon:output "method=xml";
      declare option saxon:output "saxon:indent-spaces=4";

      (: System object :)
      declare variable $context external;
      declare variable $automator external;
      declare variable $log external;

      declare function local:createEnv (
      $osmOrderRoot as element()*
      ) as element()*
      {


      let $approvedName := fn:string($osmOrderRoot//oms:employeeName)
      let $approved := "_Approved"

      return(

      <oms:finalElement>{fn:concat($approvedName,$approved)}</oms:finalElement>

      )
      };

      let $osmOrder := fn:root(.)/oms:GetOrder.Response
      let $osmOrderRoot := $osmOrder//oms:_root

      let $approvedName := fn:string($osmOrderRoot//oms:employeeName)

      let $SSOReq := local:createEnv($osmOrderRoot)


      let $inputXml:= saxon:serialize($SSOReq, <xsl:output method='xml' omit-xml-declaration='yes' indent='yes' saxon:indent-spaces='4'/>)


      return
      (
      log:info($log,"*********** Response - START ***********"),

      log:info($log,$inputXml),

      log:info($log,"*********** Response - END ***********")

      )

      LogFile

      ####<Jan 29, 2013 12:20:07 PM IST> <Info> <EJB> <B4L-BSM0ZR1> <AdminServer> <ExecuteThread: '14' for queue: 'oms.automation'> <oms-automation> <> <0cdf0d0811cb16cf:4587dd8e:13c844d75da:-8000-0000000000001b47> <1359442207525> <BEA-010213> <Message-Driven EJB: com.mslv.oms.automation.AutomationEventHandler's transaction was rolled back. The transaction details are: Name=[EJB com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.onMessage(javax.jms.Message)],Xid=BEA1-1FA6BB24067E3057A4BD(863656849),Status=Rolled back. [Reason=weblogic.transaction.internal.AppSetRollbackOnlyException: setRollbackOnly called on transaction],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=30,XAServerResourceInfo[WLStore_base_domain__WLS_AdminServer]=(ServerResourceInfo[WLStore_base_domain__WLS_AdminServer]=(state=rolledback,assigned=AdminServer),xar=WLStore_base_domain__WLS_AdminServer2141748590,re-Registered = false),NonXAServerResourceInfo[WL_JDBC_LLR_POOL.oms_pool]=(ServerResourceInfo[WL_JDBC_LLR_POOL.oms_pool]=(state=rolledback,assigned=AdminServer),nonXAResource=JDBC LLR, pool=oms_pool, table=ORDERMGMT001.WL_LLR_ADMINSERVER),SCInfo[base_domain+AdminServer]=(state=rolledback),properties=({weblogic.transaction.nonXAResource=WL_JDBC_LLR_POOL.oms_pool, weblogic.jdbc.remote.oms_pool=t3://[2001:0:4137:9e76:8d7:3cc0:3f57:ff92]:7001, weblogic.transaction.name=[EJB com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.onMessage(javax.jms.Message)], weblogic.jdbc.llr=oms_pool}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=AdminServer+[2001:0:4137:9e76:8d7:3cc0:3f57:ff92]:7001+base_domain+t3+, XAResources={WSATGatewayRM_AdminServer_base_domain, WLStore_base_domain__WLS_AdminServer},NonXAResources={})],CoordinatorURL=AdminServer+[2001:0:4137:9e76:8d7:3cc0:3f57:ff92]:7001+base_domain+t3+).>
      ####<Jan 29, 2013 12:20:07 PM IST> <Info> <oms> <B4L-BSM0ZR1> <AdminServer> <ExecuteThread: '13' for queue: 'oms.automation'> <oms-automation> <BEA1-1FA7BB24067E3057A4BD> <0cdf0d0811cb16cf:4587dd8e:13c844d75da:-8000-0000000000001b47> <1359442207544> <BEA-000000> <sample.New_Automation: *********** Response - START ***********>
      ####<Jan 29, 2013 12:20:07 PM IST> <Info> <oms> <B4L-BSM0ZR1> <AdminServer> <ExecuteThread: '13' for queue: 'oms.automation'> <oms-automation> <BEA1-1FA7BB24067E3057A4BD> <0cdf0d0811cb16cf:4587dd8e:13c844d75da:-8000-0000000000001b47> <1359442207549> <BEA-000000> <sample.New_Automation: <oms:finalElement xmlns:oms="urn:com:metasolv:oms:xmlapi:1">Menaka_Approved</oms:finalElement>>
      ####<Jan 29, 2013 12:20:07 PM IST> <Info> <oms> <B4L-BSM0ZR1> <AdminServer> <ExecuteThread: '13' for queue: 'oms.automation'> <oms-automation> <BEA1-1FA7BB24067E3057A4BD> <0cdf0d0811cb16cf:4587dd8e:13c844d75da:-8000-0000000000001b47> <1359442207550> <BEA-000000> <sample.New_Automation: *********** Response - END ***********>
      ####<Jan 29, 2013 12:20:07 PM IST> <Warning> <oms> <B4L-BSM0ZR1> <AdminServer> <ExecuteThread: '13' for queue: 'oms.automation'> <oms-automation> <BEA1-1FA7BB24067E3057A4BD> <0cdf0d0811cb16cf:4587dd8e:13c844d75da:-8000-0000000000001b47> <1359442207551> <BEA-000000> <sample.New_Automation: Attempting to clean up references to bad EJB references>
      ####<Jan 29, 2013 12:20:07 PM IST> <Error> <oms> <B4L-BSM0ZR1> <AdminServer> <ExecuteThread: '13' for queue: 'oms.automation'> <oms-automation> <BEA1-1FA7BB24067E3057A4BD> <0cdf0d0811cb16cf:4587dd8e:13c844d75da:-8000-0000000000001b47> <1359442207561> <BEA-000000> <automation.AutomationDispatcher: Failed to execute plugin[automation/plugin/internal/task/Sample/1.0.0.0.0/SecondTask/do] due to java.lang.NullPointerException
      com.mslv.oms.automation.AutomationException: java.lang.NullPointerException
           at com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.a(Unknown Source)
           at com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.processMessage(Unknown Source)
           at com.mslv.oms.automation.AutomationDispatcher.onLocalMessage(Unknown Source)
           at oracle.communications.ordermanagement.cluster.message.a.a(Unknown Source)
           at oracle.communications.ordermanagement.cluster.message.impl.a.a(Unknown Source)
           at oracle.communications.ordermanagement.cluster.message.impl.a.a(Unknown Source)
           at oracle.communications.ordermanagement.cluster.impl.a.a(Unknown Source)
           at oracle.communications.ordermanagement.cluster.message.ClusterMessageHandlerBean.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.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
           at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
           at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)
      Caused By: java.lang.NullPointerException
           at oracle.communications.ordermanagement.automation.plugin.AbstractScriptPluginImplementation.updateOrderData(Unknown Source)
           at oracle.communications.ordermanagement.automation.plugin.AbstractScriptPluginImplementation.runCommonFunctionality(Unknown Source)
           at oracle.communications.ordermanagement.automation.plugin.ScriptRunnerImpl.runScript(Unknown Source)
           at oracle.communications.ordermanagement.automation.plugin.AbstractScriptAutomator.run(Unknown Source)
           at com.mslv.oms.automation.plugin.AbstractAutomator._runAutomator(Unknown Source)
           at com.mslv.oms.automation.AutomationDispatcher.a(Unknown Source)
           at com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.processMessage(Unknown Source)
           at com.mslv.oms.automation.AutomationDispatcher.onLocalMessage(Unknown Source)
           at oracle.communications.ordermanagement.cluster.message.a.a(Unknown Source)
           at oracle.communications.ordermanagement.cluster.message.impl.a.a(Unknown Source)
           at oracle.communications.ordermanagement.cluster.message.impl.a.a(Unknown Source)
           at oracle.communications.ordermanagement.cluster.impl.a.a(Unknown Source)
           at oracle.communications.ordermanagement.cluster.message.ClusterMessageHandlerBean.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.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
           at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
           at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)

      Thanks in Advance
      Menaka

      Edited by: 984080 on Jan 28, 2013 11:05 PM

      Edited by: 984080 on Jan 28, 2013 11:14 PM
        • 1. Re: Message while executing the Automation Task execution
          975124
          use this in side your xquery return block

          automator:setUpdateOrder($automator,false())


          and also don't use like this >> $osmOrderRoot//oms:employeeName

          proper standard for $osmOrderRoot//oms:employeeName is $osmOrderRoot/oms:employeeName
          • 2. Re: Message while executing the Automation Task execution
            987083
            Hi Tarini,

            I need one more clarification in OSM. Is there any inbuilt functionality in OSM for task assignment and task re-assignment?

            For example,

            Tasks are assigned for one user, but he is on vacation and so he wants his tasks to be redirected to another user, for the vacation period only after that the tasks should come under his name itself, if it is not finished. Is there any inbuilt functionality in OSM for doing this?

            Thanks in Advance
            Menaka
            • 3. Re: Message while executing the Automation Task execution
              975124
              OSM provides two default algorithms: Load Balancing and Round Robin.
              The Load Balancing algorithm attempts to distribute tasks based on a user's current workload. The OSM server assigns tasks after determining which user in the workgroup has the fewest number of assigned tasks.

              The Round Robin algorithm assigns tasks in a predefined order among the users in the workgroup.

              You can add custom assignment algorithms to OSM, using OSM's cartridge management tools.
              For custom algorithms, you must manually enter the algorithm name in the Assignment Algorithm field of Automated task and Manual task details tab.
              • 4. Re: Message while executing the Automation Task execution
                987083
                Thanks Tarini.

                Is there any document on these algorithms? I need more details on this where can I find it?


                Thanks in Advance
                Menaka