1 Reply Latest reply: Oct 28, 2009 7:16 AM by anvv sharma RSS

    11g HTML email notification giving an error

    586784
      Hi,

      I have tried HTML email notification in 11g and getting some exception.

      "The file to be loaded oramds:/deployed-composites/SampleEmail_rev2.0/HTMLBody.xsl does not exist" does this error mean that should we load the xsl file on to the meta data store explicitly after deploying the composite?


      Please help me on this issue.

      SOA log Error:
      [2009-10-12T11:56:41.817-05:00] [soa_server1] [WARNING] [] [oracle.soa.bpel.engine.xml] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [ecid: 0000IH9fYhy6qIL_uPQ5UX1AnCEG0000wz,0:2] [WEBSERVICE_PORT.name: SampleEmailProcess_pt] [APP: soa-infra] [composite_name: SampleEmail] [component_name: SampleEmailProcess] [component_instance_id: 320068] [J2EE_MODULE.name: fabric] [WEBSERVICE.name: sampleemailprocess_client_ep] [J2EE_APP.name: soa-infra] [composite_instance_id: 330077] <BPELXPathFunctionWrapper::evaluate> [[
      oracle.fabric.common.xml.xpath.XPathFunctionException: Error in getting XML input stream: oramds:/deployed-composites/SampleEmail_rev2.0/HTMLBody.xsl: MDS-00054: The file to be loaded oramds:/deployed-composites/SampleEmail_rev2.0/HTMLBody.xsl does not exist.
           at oracle.fabric.common.xml.xpath.XPathFunctionException.fillInStackTrace(XPathFunctionException.java:65)
           at java.lang.Throwable.<init>(Throwable.java:196)
           at java.lang.Exception.<init>(Exception.java:41)
           at oracle.fabric.common.xml.xpath.XPathFunctionException.<init>(XPathFunctionException.java:23)
           at com.collaxa.cube.xml.xpath.functions.xml.GetElementFromXSLTFunction.call(GetElementFromXSLTFunction.java:122)
           at com.collaxa.cube.xml.xpath.BPELXPathFunctionWrapper.evaluate(BPELXPathFunctionWrapper.java:70)
           at oracle.xml.xpath.JXPathContext$JXFunction.invoke(JXPathContext.java:150)
           at oracle.xml.xpath.JXPathContext$JXFunction.invoke(JXPathContext.java:119)
           at oracle.xml.xpath.XPathExtFunction.evaluate(XPathExtFunction.java:254)
           at oracle.xml.xpath.JXPathExpression.evaluate(JXPathExpression.java:187)
           at com.collaxa.cube.xml.xpath.BPELXPathUtil.evaluate(BPELXPathUtil.java:206)
           at com.collaxa.cube.engine.ext.bpel.common.BPELWMPHelper.evalFromValue(BPELWMPHelper.java:328)
           at com.collaxa.cube.engine.ext.bpel.v1.wmp.BPEL1AssignWMP.__executeStatements(BPEL1AssignWMP.java:129)
           at com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform(BaseBPELActivityWMP.java:140)
           at com.collaxa.cube.engine.CubeEngine._performActivity(CubeEngine.java:2675)
           at com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:2558)
           at com.collaxa.cube.engine.CubeEngine.handleWorkItem(CubeEngine.java:1256)
           at com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal(PerformMessageHandler.java:73)
           at com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage(DispatchHelper.java:188)
           at com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory(DispatchHelper.java:285)
           at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4607)
           at com.collaxa.cube.engine.CubeEngine.createAndInvoke(CubeEngine.java:828)
           at com.collaxa.cube.engine.ejb.impl.CubeEngineBean.createAndInvoke(CubeEngineBean.java:111)
           at com.collaxa.cube.engine.ejb.impl.CubeEngineBean.syncCreateAndInvoke(CubeEngineBean.java:147)
           at com.collaxa.cube.engine.ejb.impl.bpel.BPELEngineBean.syncCreateAndInvoke(BPELEngineBean.java:103)
           at sun.reflect.GeneratedMethodAccessor1879.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)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
           at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
           at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
           at $Proxy188.syncCreateAndInvoke(Unknown Source)
           at com.collaxa.cube.engine.ejb.impl.bpel.BPELEngineBean_51369e_ICubeEngineLocalBeanImpl.syncCreateAndInvoke(BPELEngineBean_51369e_ICubeEngineLocalBeanImpl.java:491)
           at com.collaxa.cube.engine.delivery.DeliveryHandler.initialRequestAnyType(DeliveryHandler.java:528)
           at com.collaxa.cube.engine.delivery.DeliveryHandler.initialRequest(DeliveryHandler.java:482)
           at com.collaxa.cube.engine.delivery.DeliveryHandler.request(DeliveryHandler.java:156)
           at com.collaxa.cube.engine.ejb.impl.CubeDeliveryBean.request(CubeDeliveryBean.java:600)
           at sun.reflect.GeneratedMethodAccessor1878.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)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
           at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
           at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
           at $Proxy185.request(Unknown Source)
           at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.request(BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.java:1080)
           at oracle.fabric.CubeServiceEngine.request(CubeServiceEngine.java:290)
           at oracle.integration.platform.blocks.mesh.SynchronousMessageHandler.doRequest(SynchronousMessageHandler.java:139)
           at oracle.integration.platform.blocks.mesh.MessageRouter.request(MessageRouter.java:179)
           at oracle.integration.platform.blocks.mesh.MeshImpl.request(MeshImpl.java:144)
           at sun.reflect.GeneratedMethodAccessor1292.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
           at oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:59)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
           at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
           at $Proxy199.request(Unknown Source)
           at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.doMessageProcessing(WebServiceEntryBindingComponent.java:1155)
           at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.processIncomingMessage(WebServiceEntryBindingComponent.java:767)
           at oracle.integration.platform.blocks.soap.FabricProvider.processMessage(FabricProvider.java:113)
           at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:1119)
           at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:873)
           at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessing(ProviderProcessor.java:553)
           at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:202)
           at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:166)
           at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:384)
           at oracle.integration.platform.blocks.soap.FabricProviderServlet.doPost(FabricProviderServlet.java:444)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
           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:292)
           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:202)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3588)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2200)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2106)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1428)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

      ]]


      Thanks,
      Chaitu.
        • 1. Re: 11g HTML email notification giving an error
          anvv sharma
          Hi Ravi,

          calling the XSLT in Bpel
          <copy>
          <from expression="ora:processXSLT('GenerateEmailContent.xsl', bpws:getVariableData('CreateNotificationRequestEBM','payload'))"/>
          <to variable="varNotificationReq" part="EmailPayload"
          query="/EmailPayload/ns4:Content/ns4:ContentBody"/>
          </copy>

          GenerateEmailContent.xsl Code
          <?xml version="1.0" encoding="UTF-8" ?>
          <!-- removed oracle-xsl-mapper -->
          <xsl:stylesheet version="1.0"
          <!-- removed the namespaces-->
          >

          <xsl:output method="html" indent="yes" version="4.0"/>
          <xsl:template match="/">
          <html>
          <head><title>Email Notification Body Content</title></head>
          <body>

          <xsl:variable name="greeting">Hi </xsl:variable>

          <!-- removed other Variables -->
          <xsl:variable name="TransactionNumber" select="/ns1:TransactionNumber"/>

          <table border='0' style='font-size:10;font-family:verdana' cellspacing='4' cellpadding='8'>

          <tr><td colspan='2'>
          <xsl:value-of select="$greeting"/><xsl:value-of select="$CreatorName"/>,
          </td></tr>
          <tr><td colspan='2'>
          <xsl:value-of select="concat($TransactionType,' ',$mailSubject)"/>
          </td></tr>

          <xsl:if test="$TransactionNumber != ''">
          <tr>
          <td width='247'><xsl:value-of select="$TransactionNumberText"/></td>
          <td width='441'><xsl:value-of select="$TransactionNumber"/></td>
          </tr>
          </xsl:if>

          <xsl:if test="$TransactionType != ''">
          <tr>
          <td width='247'><xsl:value-of select="$TransactionTypeText"/></td>
          <td width='441'><xsl:value-of select="$TransactionType"/></td>
          </tr>
          </xsl:if>

          <xsl:if test="$CreatorName != ''">
          <tr>
          <td width='247'><xsl:value-of select="$CreatorNameText"/></td>
          <td width='441'><xsl:value-of select="$CreatorName"/></td>
          </tr>
          </xsl:if>

          <xsl:if test="$CreatorEmail != ''">
          <tr>
          <td width='247'><xsl:value-of select="$CreatorEmailText"/></td>
          <td width='441'><xsl:value-of select="$CreatorEmail"/></td>
          </tr>
          </xsl:if>

          <xsl:if test="$YearDateFormat != ''">
          <tr>
          <td width='247'><xsl:value-of select="$TransactionTimestampText"/></td>
          <td width='441'><xsl:value-of select="$TransactionTimestamp"/></td>
          </tr>
          </xsl:if>

          <xsl:if test="$AccountName != ''">
          <tr>
          <td width='247'><xsl:value-of select="$AccountNameText"/></td>
          <td width='441'><xsl:value-of select="$AccountName"/></td>
          </tr>
          </xsl:if>

          <xsl:if test="$PromotionName != ''">
          <tr>
          <td width='247'><xsl:value-of select="$PromotionNameText"/></td>
          <td width='441'><xsl:value-of select="$PromotionName"/></td>
          </tr>
          </xsl:if>

          <xsl:if test="$TransactionRefId != ''">
          <tr>
          <td width='247'><xsl:value-of select="$TransactionRefIdText"/></td>
          <td width='441'><xsl:value-of select="$TransactionRefId"/></td>
          </tr>
          </xsl:if>

          <xsl:if test="$ShortMessage != ''">
          <tr>
          <td width='247'><xsl:value-of select="$ShortMessageText"/></td>
          <td width='441' wrap='yes'><xsl:value-of select="$ShortMessage"/></td>
          </tr>
          </xsl:if>

          <xsl:if test="$DetailMessage != ''">
          <tr>
          <td width='247'><xsl:value-of select="$DetailMessageText"/></td>
          <td width='441' wrap='yes'><xsl:value-of select="$DetailMessage"/></td>
          </tr>
          </xsl:if>

          <tr height='20'><td colspan='2'></td></tr>

          <tr><td colspan='2'><xsl:value-of select="$TandGText"/></td></tr>

          <tr><td colspan='2'><xsl:value-of select="$ThanksGivingText" /></td></tr>
          </table>

          </body>
          </html>
          </xsl:template>

          </xsl:stylesheet>

          regards,
          anvv sharma