XPath Exception when mapping data between source & destination sch

[Lakshmi Murthy]

Hi,

I am getting the following error when i am trying to map data between source
and destination schemas.

Microsoft.XLANGs.RuntimeTypes.AmbiguousXPathException: The result set for
the XPath expression '/*[local-name()='PLMXML' and
namespace-uri()='http://CBI_WindChill.BOM_TCE_updated']/*[local-name()='item'
and namespace-uri()='']/*[local-name()='tcrev' and namespace-uri()='']'
contains more than a single node.

at Microsoft.XLANGs.Core.XmlDocumentWrapper.GetXPath(String xpath)

at Microsoft.XLANGs.Core.Value.GetXPath(String xpath, Boolean isDynamic)

at Microsoft.XLANGs.Core.Part._getXPath(String xpath, Boolean dynamic)

at Microsoft.XLANGs.Core.XSDPart.GetPayloadProperty(PropertyDefinition pd)

at Microsoft.XLANGs.Core.XMessage.GetContentProperties()

at
Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.PrepareMessage(XLANGMessage
msg, IList promoteProps, IList toPromote)

at
Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.WriteMessageState(XLANGMessage
msg, Segment seg, IList promoteProps, Boolean track, IList toPromote, Boolean
ignoreRoutingFailure)

at
Microsoft.BizTalk.XLANGs.BTXEngine.BTXDirectPortBinding.SendMessage(XLANGMessage
xmsg, XlangStore store, Segment seg, OperationInfo op, IList additionalProps,
IList toPromote, Boolean ignoreRoutingFailure)

at Microsoft.BizTalk.XLANGs.BTXEngine.BTXPortBase.SendMessage(Int32
iOperation, XLANGMessage msg, Correlation[] initCorrelations, Correlation[]
followCorrelations, Context cxt, Segment seg, ActivityFlags flags)

at CBI_WindChill.BOMOrchestration.segment1(StopConditions stopOn)

at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s,
StopConditions stopCond, Exception& exp)
Microsoft.XLANGs.RuntimeTypes.AmbiguousXPathException

The above error shows that the destination schema has more than one node. I
am using loop and scripting functoids to send single values to nodes from
source schema to destination. Why am i getting this error? how can i solve
this problem?

I was getting the above error when i have promoted fields in both source and
destination schemas using distinguished fields. I thought that might be the
problem and now i have created property schema for both source and
destination schemas for promoting the fields and mapping the data. When i
test my map, i am able to see that desired result. only when i am trying to
send the output file to the destination folder, i am getting this error and
the file sent to the destination folder is source schema (not in destination
schema format).

Please let me know how i can solve the above issue.
Looking forward for answers
Regards
Lakshmi

[abby]

Hi,

Is your schema specify that node which you are using for property promotion
can be multiple. What is the valuse for min and max value for that node?

Abhay

[Lakshmi Murthy]

Hi Abhay,

The min value for that node is 0 and max is unbounded..

<xs:element minOccurs="0" name="tcid" type="xs:string" />

The following is the error message i am getting after starting this
orchestration:

Microsoft.XLANGs.RuntimeTypes.AmbiguousXPathException: The result set for
the XPath expression '/*[local-name()='PLMXML' and
namespace-uri()='http://CBI_WindChill.BOM_TCE_updated']/*[local-name()='item'

and namespace-uri()='']/*[local-name()='tcid' and namespace-uri()='']'

contains more than a single node.

at Microsoft.XLANGs.Core.XmlDocumentWrapper.GetXPath(String xpath)

at Microsoft.XLANGs.Core.Value.GetXPath(String xpath, Boolean isDynamic)

at Microsoft.XLANGs.Core.Part._getXPath(String xpath, Boolean dynamic)

at Microsoft.XLANGs.Core.XSDPart.GetPayloadProperty(PropertyDefinition pd)

at Microsoft.XLANGs.Core.XMessage.GetContentProperties()

at
Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.PrepareMessage(XLANGMessage
msg, IList promoteProps, IList toPromote)

at
Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.WriteMessageState(XLANGMessage
msg, Segment seg, IList promoteProps, Boolean track, IList toPromote, Boolean
ignoreRoutingFailure)

at
Microsoft.BizTalk.XLANGs.BTXEngine.BTXDirectPortBinding.SendMessage(XLANGMessage
xmsg, XlangStore store, Segment seg, OperationInfo op, IList additionalProps,
IList toPromote, Boolean ignoreRoutingFailure)

at Microsoft.BizTalk.XLANGs.BTXEngine.BTXPortBase.SendMessage(Int32
iOperation, XLANGMessage msg, Correlation[] initCorrelations, Correlation[]
followCorrelations, Context cxt, Segment seg, ActivityFlags flags)

at CBI_WindChill.BOMOrchestration.segment1(StopConditions stopOn)

at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s,
StopConditions stopCond, Exception& exp)
Microsoft.XLANGs.RuntimeTypes.AmbiguousXPathException

Scoped@
BOMOrchestration.BOMOrchestration
316e10bb-9e05-4fa1-9915-9ed28f3335f6

How can i resolve this error???

Waiting for answers.
Thanks in advance
Regards
Lakshmi