Hello, I’m trying to assign a variable to a schema node by using below code, for SQL Adapter promoted schema element for SQL Insert opearation through stored procedure SP_UPDATE_Interface_Call_Track.
Ok, with below expression, I’m not seeing any syntactical errors around my Expression in Message Assign Shape and at run time it is giving some error, could you guys please help?
I fallowed the http://allcomputers.us/windows_server/biztalk-2010-recipes—document-mapping—passing-orchestration-variables-into-maps.aspx but it is not giving the results, I think there will be different procedure to work with SQL schemas.
try1:- msgReqUpdateCallTrack.MessagePart_1.SP_UPDATE_Interface_Call_Track.ID = varIdentity;
any suggestions by using xpath expressions ?
Error
InnerException: A failure occurred while evaluating the distinguished field SP_UPDATE_Interface_Call_Track.ID against the message part data. The message part data does not contain at least one of the nodes specified by the XPath expression (listed below) that corresponds to the distinguished field. The cause for this error may be that the message part data has not been initialized or that the message part data does not conform to the message part schema. Ensure that the message part data is initialized correctly. XPath expression: /*[local-name()=’ReqSP_UPDATE_Interface_Call_Track’ and namespace-uri()=’http://updatecalltrack.socialrest.org’%5D/*%5Blocal-name()=’SP_UPDATE_Interface_Call_Track‘ and namespace-uri()=’http://updatecalltrack.socialrest.org’%5D/@*%5Blocal-name()=’ID’ and namespace-uri()=”]