1 Reply Latest reply: Jan 29, 2013 1:25 AM by 740807 RSS

    EDN Event Subscription filter using DVM-Invalid XPath Expression or Namespa

    951706
      I'm subscribing an Event on basis of a filter condition (if Dept = 'HR'). The filter data is fetched from a DVM table column. However the filter condition is not working even though data is properly lookedup from the DVM. I've attached the code for both publish and subscibe events.

      1.WLS version. - 10.3.4.0
      2.database version - Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
      3.SOA version - 11.1.1.4
      4.Java/JRockit version. - Java(TM) SE Runtime Environment (build 1.6.0_21-b51)
      5.Operating System and version. - Windows 7 SP1 32bit

      Step by Step replication steps to reproduce the problem.

      The composite contains two BPEL processes. Test the EventPulisher.bpel with the following Dept = 'HR' or 'FIN' and the EventSubscriber component should consume the published event. Again on publishing an event with Dept='Admin', the evnt should not be subscribed. The Dept values are defined in the Dept.dvm.
      When the DVM lookup is done in an assign activity, I can see the correct value being fetched. However the values are not fetched when the DVM lookup expression is put in the Event subscription filter exp.

      [Composite.xml]

      <?xml version="1.0" encoding="UTF-8" ?>
      <!-- Generated by Oracle SOA Modeler version 1.0 at [1/25/13 1:37 PM]. -->
      <composite name="TestEDN"
      revision="1.0"
      label="2013-01-25_13-37-09_391"
      mode="active"
      state="on"
      xmlns="http://xmlns.oracle.com/sca/1.0"
      xmlns:xs="http://www.w3.org/2001/XMLSchema"
      xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy"
      xmlns:orawsp="http://schemas.oracle.com/ws/2006/01/policy"
      xmlns:dvm="http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue"
      xmlns:ui="http://xmlns.oracle.com/soa/designer/">
      <import namespace="http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher"
      location="EventPulisher.wsdl" importType="wsdl"/>
      <import namespace="http://schemas.oracle.com/events/edl/PersonEvent"
      location="PersonEvent.edl" importType="edl"/>
      <service name="eventpulisher_client_ep" ui:wsdlLocation="EventPulisher.wsdl">
      <interface.wsdl interface="http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher#wsdl.interface(EventPulisher)"/>
      <binding.ws port="http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher#wsdl.endpoint(eventpulisher_client_ep/EventPulisher_pt)"/>
      </service>
      <component name="EventPulisher" version="1.1">
      <implementation.bpel src="EventPulisher.bpel"/>
      <business-events>
      <publishes xmlns:pub1="http://schemas.oracle.com/events/edl/PersonEvent"
      name="pub1:Person"/>
      </business-events>
      </component>
      <component name="EventSubscriber" version="1.1">
      <implementation.bpel src="EventSubscriber.bpel"/>
      <business-events>
      <subscribe xmlns:sub1="http://schemas.oracle.com/events/edl/PersonEvent"
      name="sub1:Person" consistency="oneAndOnlyOne"
      runAsRoles="$publisher">
      <filter>
      <xpath xmlns:dvm="http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue"
      xmlns:ns1="http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher"
      xmlns:be="http://oracle.com/fabric/businessEvent"
      expression="/be:business-event/be:content/ns1:process/ns1:dept = dvm:lookupValue(&quot;Dept.dvm&quot;,'DeptDesc','HumanResource','Dept','No_data_found')"/>
      </filter>
      </subscribe>
      </business-events>
      </component>
      <wire>
      <source.uri>eventpulisher_client_ep</source.uri>
      <target.uri>EventPulisher/eventpulisher_client</target.uri>
      </wire>
      </composite>

      [Dept.dvm]

      <?xml version="1.0" encoding="UTF-8" ?>
      <!-- Generated by Oracle DVM Editor version 1.0 at [1/25/13 2:54 PM]. -->
      <dvm name="Dept" xmlns="http://xmlns.oracle.com/dvm">
      <description>
      </description>
      <columns>
      <column name="Dept"/>
      <column name="DeptDesc"/>
      </columns>
      <rows>
      <row>
      <cell>HR</cell>
      <cell>HumanResource</cell>
      </row>
      <row>
      <cell>FIN</cell>
      <cell>Finance</cell>
      </row>
      </rows>
      </dvm>

      [Error in domain log]

      ####<Jan 28, 2013 2:22:01 PM IST> <Error> <oracle.integration.platform.blocks.event.saq> <01HW452949> <Admin> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-35BEA0898D0C08F62304> <944138ac44ed2d71:-7ecc9e7c:13c802e17cb:-8000-0000000000000e6f> <1359363121739> <SOA-31030> <Invalid XPath Expression or Namespaces setting "ui,http://xmlns.oracle.com/soa/designer/;,http://xmlns.oracle.com/sca/1.0;ns1,http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher;wsp,http://schemas.xmlsoap.org/ws/2004/09/policy;orawsp,http://schemas.oracle.com/ws/2006/01/policy;xs,http://www.w3.org/2001/XMLSchema;sub1,http://schemas.oracle.com/events/edl/PersonEvent;be,http://oracle.com/fabric/businessEvent;dvm,http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue;"; Exception: Unable to evaluate XPath expression; for subscriber: id=default/TestEDN!1.0*soa_3ec05d9c-65fa-436e-bc6a-194ae7b1727c/ubscribeMediator, consistencyLevel=ONE_AND_ONLY_ONE, filter=XPath Filter: /be:business-event/be:content/ns1:process/ns1:dept = dvm:lookupValue("Dept.dvm",'DeptDesc','Finance','Dept','No_data_found'), runAsRoles=[$publisher]>
      ####<Jan 28, 2013 2:22:01 PM IST> <Error> <oracle.integration.platform.blocks.event.saq> <01HW452949> <Admin> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-35BEA0898D0C08F62304> <944138ac44ed2d71:-7ecc9e7c:13c802e17cb:-8000-0000000000000e6f> <1359363121759> <SOA-31030> <Invalid XPath Expression or Namespaces setting "ui,http://xmlns.oracle.com/soa/designer/;,http://xmlns.oracle.com/sca/1.0;ns1,http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher;wsp,http://schemas.xmlsoap.org/ws/2004/09/policy;orawsp,http://schemas.oracle.com/ws/2006/01/policy;xs,http://www.w3.org/2001/XMLSchema;sub1,http://schemas.oracle.com/events/edl/PersonEvent;be,http://oracle.com/fabric/businessEvent;dvm,http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue;"; Exception: Unable to evaluate XPath expression; for subscriber: id=default/TestEDN!1.0*soa_3ec05d9c-65fa-436e-bc6a-194ae7b1727c/EventSubscriber, consistencyLevel=ONE_AND_ONLY_ONE, filter=XPath Filter: /be:business-event/be:content/ns1:process/ns1:dept = dvm:lookupValue("Dept.dvm",'DeptDesc','HumanResource','Dept','No_data_found'), runAsRoles=[$publisher]>
      ####<Jan 28, 2013 2:22:17 PM IST> <Error> <oracle.integration.platform.blocks.event.saq> <01HW452949> <Admin> <weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@e467a> <<anonymous>> <> <944138ac44ed2d71:-7ecc9e7c:13c802e17cb:-8000-0000000000000e6f> <1359363137726> <SOA-31030> <Invalid XPath Expression or Namespaces setting "ui,http://xmlns.oracle.com/soa/designer/;,http://xmlns.oracle.com/sca/1.0;ns1,http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher;wsp,http://schemas.xmlsoap.org/ws/2004/09/policy;orawsp,http://schemas.oracle.com/ws/2006/01/policy;xs,http://www.w3.org/2001/XMLSchema;sub1,http://schemas.oracle.com/events/edl/PersonEvent;be,http://oracle.com/fabric/businessEvent;dvm,http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue;"; Exception: Unable to evaluate XPath expression; for subscriber: id=default/TestEDN!1.0*soa_3ec05d9c-65fa-436e-bc6a-194ae7b1727c/ubscribeMediator, consistencyLevel=ONE_AND_ONLY_ONE, filter=XPath Filter: /be:business-event/be:content/ns1:process/ns1:dept = dvm:lookupValue("Dept.dvm",'DeptDesc','Finance','Dept','No_data_found'), runAsRoles=[$publisher]>
      ####<Jan 28, 2013 2:22:17 PM IST> <Error> <oracle.integration.platform.blocks.event.saq> <01HW452949> <Admin> <weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@e467a> <<anonymous>> <> <944138ac44ed2d71:-7ecc9e7c:13c802e17cb:-8000-0000000000000e6f> <1359363137731> <SOA-31030> <Invalid XPath Expression or Namespaces setting "ui,http://xmlns.oracle.com/soa/designer/;,http://xmlns.oracle.com/sca/1.0;ns1,http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher;wsp,http://schemas.xmlsoap.org/ws/2004/09/policy;orawsp,http://schemas.oracle.com/ws/2006/01/policy;xs,http://www.w3.org/2001/XMLSchema;sub1,http://schemas.oracle.com/events/edl/PersonEvent;be,http://oracle.com/fabric/businessEvent;dvm,http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue;"; Exception: Unable to evaluate XPath expression; for subscriber: id=default/TestEDN!1.0*soa_3ec05d9c-65fa-436e-bc6a-194ae7b1727c/EventSubscriber, consistencyLevel=ONE_AND_ONLY_ONE, filter=XPath Filter: /be:business-event/be:content/ns1:process/ns1:dept = dvm:lookupValue("Dept.dvm",'DeptDesc','HumanResource','Dept','No_data_found'), runAsRoles=[$publisher]>
      ####<Jan 28, 2013 2:22:50 PM IST> <Error> <oracle.integration.platform.blocks.event.saq> <01HW452949> <Admin> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-36C7A0898D0C08F62304> <944138ac44ed2d71:-7ecc9e7c:13c802e17cb:-8000-0000000000000ed3> <1359363170031> <SOA-31030> <Invalid XPath Expression or Namespaces setting "ui,http://xmlns.oracle.com/soa/designer/;,http://xmlns.oracle.com/sca/1.0;ns1,http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher;wsp,http://schemas.xmlsoap.org/ws/2004/09/policy;orawsp,http://schemas.oracle.com/ws/2006/01/policy;xs,http://www.w3.org/2001/XMLSchema;sub1,http://schemas.oracle.com/events/edl/PersonEvent;be,http://oracle.com/fabric/businessEvent;dvm,http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue;"; Exception: Unable to evaluate XPath expression; for subscriber: id=default/TestEDN!1.0*soa_3ec05d9c-65fa-436e-bc6a-194ae7b1727c/ubscribeMediator, consistencyLevel=ONE_AND_ONLY_ONE, filter=XPath Filter: /be:business-event/be:content/ns1:process/ns1:dept = dvm:lookupValue("Dept.dvm",'DeptDesc','Finance','Dept','No_data_found'), runAsRoles=[$publisher]>
      ####<Jan 28, 2013 2:22:50 PM IST> <Error> <oracle.integration.platform.blocks.event.saq> <01HW452949> <Admin> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-36C7A0898D0C08F62304> <944138ac44ed2d71:-7ecc9e7c:13c802e17cb:-8000-0000000000000ed3> <1359363170040> <SOA-31030> <Invalid XPath Expression or Namespaces setting "ui,http://xmlns.oracle.com/soa/designer/;,http://xmlns.oracle.com/sca/1.0;ns1,http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher;wsp,http://schemas.xmlsoap.org/ws/2004/09/policy;orawsp,http://schemas.oracle.com/ws/2006/01/policy;xs,http://www.w3.org/2001/XMLSchema;sub1,http://schemas.oracle.com/events/edl/PersonEvent;be,http://oracle.com/fabric/businessEvent;dvm,http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue;"; Exception: Unable to evaluate XPath expression; for subscriber: id=default/TestEDN!1.0*soa_3ec05d9c-65fa-436e-bc6a-194ae7b1727c/EventSubscriber, consistencyLevel=ONE_AND_ONLY_ONE, filter=XPath Filter: /be:business-event/be:content/ns1:process/ns1:dept = dvm:lookupValue("Dept.dvm",'DeptDesc','HumanResource','Dept','No_data_found'), runAsRoles=[$publisher]>
      ####<Jan 28, 2013 2:22:50 PM IST> <Error> <oracle.integration.platform.blocks.event.saq> <01HW452949> <Admin> <weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@e467a> <<anonymous>> <> <944138ac44ed2d71:-7ecc9e7c:13c802e17cb:-8000-0000000000000ed3> <1359363170630> <SOA-31030> <Invalid XPath Expression or Namespaces setting "ui,http://xmlns.oracle.com/soa/designer/;,http://xmlns.oracle.com/sca/1.0;ns1,http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher;wsp,http://schemas.xmlsoap.org/ws/2004/09/policy;orawsp,http://schemas.oracle.com/ws/2006/01/policy;xs,http://www.w3.org/2001/XMLSchema;sub1,http://schemas.oracle.com/events/edl/PersonEvent;be,http://oracle.com/fabric/businessEvent;dvm,http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue;"; Exception: Unable to evaluate XPath expression; for subscriber: id=default/TestEDN!1.0*soa_3ec05d9c-65fa-436e-bc6a-194ae7b1727c/ubscribeMediator, consistencyLevel=ONE_AND_ONLY_ONE, filter=XPath Filter: /be:business-event/be:content/ns1:process/ns1:dept = dvm:lookupValue("Dept.dvm",'DeptDesc','Finance','Dept','No_data_found'), runAsRoles=[$publisher]>
      ####<Jan 28, 2013 2:22:50 PM IST> <Error> <oracle.integration.platform.blocks.event.saq> <01HW452949> <Admin> <weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@e467a> <<anonymous>> <> <944138ac44ed2d71:-7ecc9e7c:13c802e17cb:-8000-0000000000000ed3> <1359363170635> <SOA-31030> <Invalid XPath Expression or Namespaces setting "ui,http://xmlns.oracle.com/soa/designer/;,http://xmlns.oracle.com/sca/1.0;ns1,http://xmlns.oracle.com/CreditWorkspace/TestEDN/EventPulisher;wsp,http://schemas.xmlsoap.org/ws/2004/09/policy;orawsp,http://schemas.oracle.com/ws/2006/01/policy;xs,http://www.w3.org/2001/XMLSchema;sub1,http://schemas.oracle.com/events/edl/PersonEvent;be,http://oracle.com/fabric/businessEvent;dvm,http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue;"; Exception: Unable to evaluate XPath expression; for subscriber: id=default/TestEDN!1.0*soa_3ec05d9c-65fa-436e-bc6a-194ae7b1727c/EventSubscriber, consistencyLevel=ONE_AND_ONLY_ONE, filter=XPath Filter: /be:business-event/be:content/ns1:process/ns1:dept = dvm:lookupValue("Dept.dvm",'DeptDesc','HumanResource','Dept','No_data_found'), runAsRoles=[$publisher]>
      ####<Jan 28, 2013 2:23:11 PM IST> <Warning> <oracle.adfinternal.view.faces.renderkit.rich.TreeRendererUtils> <01HW452949> <Admin> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <944138ac44ed2d71:-7ecc9e7c:13c802e17cb:-8000-0000000000000f24> <1359363191931> <BEA-000000> <Context menu child is not a RichMenu>

      Any help would be highly appreciated.

      Regards
      Samyajit

      Edited by: 948703 on Jan 28, 2013 4:33 AM
        • 1. Re: EDN Event Subscription filter using DVM-Invalid XPath Expression or Namespa
          740807
          As confirmed by Oracle Support that this is a bug.

          Bug 14579843: DEP80 : XREF LOOKUP1M DOES NOT WORK FOR EVENT SUBSCRIPTION FILTER

          Summary of bug content:
          -------------------------------------------------------------
          XRef Function does not work with Event Subscription Filter and fails with Error similar to this one:

          [2012-09-03T23:34:26.502-07:00] [soa_server1] [ERROR] [SOA-31030] [oracle.integration.platform.blocks.event.saq] [tid: [ACTIVE].ExecuteThread:'1' for queue: 'weblogic.kernel.Default (self-tuning)']...
          [J2EE_APP.name: soa-infra] [composite_instance_id: 10078] Invalid XPath Expression or Namespaces setting
          "ui,http://xmlns.oracle.com/soa/designer/;,http://xmlns.oracle.com/sca/1.0;wsp,http://schemas.xmlsoap.org/ws/2004/09/policy;orawsp,http://schemas.oracle.com/ws/2006/01/policy;tns,http://TargetNamespace.com/JMSService;xref,http://www.oracle.com/XSL/Transform/java/oracle.tip.xref.xpath.XRefXPathFunctions;xs,http://www.w3.org/2001/XMLSchema;sub1,http://schemas.oracle.com/events/edl/EventDefinition;be,http://oracle.com/fabric/businessEvent;";
          Exception: Unable to evaluate XPath expression: Extension function error:

          Error invoking 'lookupXRef1M':'oracle.tip.xref.exception.RepositoryException: Unable to get XPathContext for Cross Reference Table "./TestEventXRef.xref"[[ Please ensure the XPathContext is available.'; for subscriber:
          id=default/TestEvent1!1.0*soa_af9a250a-ccba-4a61-ae28-4fb3832e2f93/BPELProcess1 ...


          Cause:
          DVM and Xref xpath functions were not getting executed in EDN filters as EDN layer was not setting the proper xpath context.

          Fix:
          The fix has been included in release 11.1.1.7.