Friday, August 20, 2010

Count(bpws:getVariableData(....)) results in SelectionFailure in SOA 11g

This perhaps will be a short post about a known issue on SOA 11g. I was trying to use count XPATH function on getVariableData to find count of dataarea in EBM. This worked fine in SOA 10g but in 11g it failed with SelectionFailure.

Found that this is a known issue in SOA 11g.
Oracle Release Notes for 11g

16.1.8 getVariableData Function Throws a selectionFailure if the Result Node Set is of a Size Other Than One During Execution

According to the Business Process Execution Language for Web Services Specification, if the the locationPath argument of the bpws:getVariableData() function selects a node set of a size other than one during execution, the standard fault bpws:selectionFailure must be thrown by a compliant implementation.


To get around this issue simply use ora:getNodes() which acts as an alternate to getVariableData to obtain the same functionality. getVariableData is striclty for one node result, where as getNodes would return a nodeset.

No comments:

Post a Comment