Integration

Hi,

I have used lookup-xml() Xpath function to lookup some values from an XML file.

When it finds a value for key passed in input it works fine.

But when it does not find a value for key specified, it gives the Error - internal xpath error.

Code ::

oraext:lookup-xml('oramds:/apps/GETSPRIVIFC/LOV/ResourceCode.xml','/Resource/ResourceCodes/ResourceCode','Name','Value',$input)

Error ::

<exception class="com.collaxa.cube.xml.xpath.XPathException">
XPath expression failed to execute. An error occurs while processing the XPath
expression; the expression is
oraext:lookup-xml('oramds:/apps/GETSPRIVIFC/LOV/ResourceCode.xml','/Resource/ResourceCodes/ResourceCode','Name','Value',$input).
The XPath expression failed to execute; the reason was: internal xpath error.
Check the detailed root cause described in the exception message text and
verify that the XPath query is correct.
<stack>
<f>com.collaxa.cube.xml.xpath.BPELXPathUtil.evaluate#262</f>
<f>com.collaxa.cube.engine.ext.bpel.v1.wmp.BPEL1AssignWMP.__executeStatements#137</f>
<f>com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform#158</f>
<f>com.collaxa.cube.engine.CubeEngine._performActivity#2463</f>
<f>com.collaxa.cube.engine.CubeEngine.handleWorkItem#1115</f>
<f>com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal#73</f>
<f>com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage#220</f>
<f>com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory#328</f>
<f>com.collaxa.cube.engine.CubeEngine.createAndInvoke#679</f>
<f>com.collaxa.cube.engine.ejb.impl.CubeEngineBean.createAndInvoke#103</f>
<f>com.collaxa.cube.engine.ejb.impl.CubeEngineBean.syncCreateAndInvoke#145</f>
<f>com.collaxa.cube.engine.ejb.impl.bpel.BPELEngineBean.syncCreateAndInvoke#111</f>
<f>sun.reflect.GeneratedMethodAccessor4027.invoke</f>
<f>sun.reflect.DelegatingMethodAccessorImpl.invoke#25</f>
<f>java.lang.reflect.Method.invoke#597</f>
<f>com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed#149</f>
<f>...</f>
</stack>
</exception>
<root class="javax.xml.xpath.XPathExpressionException">
internal xpath error
<stack>
<f>oracle.xml.xpath.JXPathExpression.evaluate#242</f>
<f>com.collaxa.cube.xml.xpath.BPELXPathUtil.evaluate#240</f>
<f>com.collaxa.cube.engine.ext.bpel.common.BPELWMPHelper.evalFromValue#339</f>
<f>com.collaxa.cube.engine.ext.bpel.v1.wmp.BPEL1AssignWMP.__executeStatements#137</f>
<f>com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform#158</f>
<f>com.collaxa.cube.engine.CubeEngine._performActivity#2463</f>
<f>com.collaxa.cube.engine.CubeEngine.performActivity#2334</f>
<f>com.collaxa.cube.engine.CubeEngine.handleWorkItem#1115</f>
<f>com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal#73</f>
<f>com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage#220</f>
<f>com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory#328</f>
<f>com.collaxa.cube.engine.CubeEngine.endRequest#4350</f>
<f>com.collaxa.cube.engine.CubeEngine.endRequest#4281</f>
<f>com.collaxa.cube.engine.CubeEngine.createAndInvoke#679</f>
<f>com.collaxa.cube.engine.ejb.impl.CubeEngineBean.createAndInvoke#103</f>
<f>com.collaxa.cube.engine.ejb.impl.CubeEngineBean.syncCreateAndInvoke#145</f>
<f>...</f>
</stack>
</root>