Hi,

I have an orchestration that fails while trying to execute a transform
in the ConsrtuctMessage.

The Event log shows WARNING:
The adapter "SQL" raised an error message. Details
"HRESULT="0x80040e14" Description="The request for procedure 'orders'
failed because 'orders' is a table object."
<?xml version="1.0" encoding="utf-16"
?><OLOAuditUpdategramResponse
xmlns="http://OLOAuditUpdategram"><?MSSQLError HResult="0x80040e14"
Source="Microsoft OLE DB Provider for SQL Server" Description="The
request for procedure 'orders' failed because 'orders' is a table
object."?></OLOAuditUpdategramResponse>".

And the Exception thrown in HAT is:
Microsoft.XLANGs.Core.XTransformationFailureException: Error
encountered while executing the transform
OLOTrans.TransformOLOtoHRXMLOrder. Error:Transformation failed.. --->
System.Xml.Xsl.XsltException: Function 'userCSharp:FormatMessage()'
has failed. ---> System.Reflection.TargetInvocationException:
Exception has been thrown by the target of an invocation. --->
System.Reflection.TargetInvocationException: Exception has been thrown
by the target of an invocation. --->
Microsoft.BizTalk.CrossReferencing.RuntimeException: FormatMessage:
Error Code <octomappconn> and Error Language Code <61> cannot be
found.

at Microsoft.BizTalk.CrossReferencing.ErrorHandling.FormatMessage(String
code, String lang, String appInstance, String appType, String[]
commonValues)

at Microsoft.BizTalk.CrossReferencing.CrossReferencing.FormatMessage(String
code, String lang, String appInstance, String appType, String[] args)

--- End of inner exception stack trace ---

at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters,
CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean
verifyAccess)

at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters,
CultureInfo culture, Boolean verifyAccess)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters,
CultureInfo culture)

at System.RuntimeType.InvokeMember(String name, BindingFlags
invokeAttr, Binder binder, Object target, Object[] args,
ParameterModifier[] modifiers, CultureInfo culture, String[]
namedParameters)

at Microsoft.Xslt.CompiledScripts.CSharp.ScriptClass_1.FormatMessage(String
param0, String param1)

--- End of inner exception stack trace ---

at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters,
CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean
verifyAccess)

at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters,
CultureInfo culture, Boolean verifyAccess)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters,
CultureInfo culture)

at System.Reflection.MethodBase.Invoke(Object obj, Object[]
parameters)

at System.Xml.Xsl.FuncExtension.Invoke(XsltContext xsltContext,
Object[] args, XPathNavigator docContext)

at System.Xml.XPath.XsltFunction.InvokeFunction(XPathNavigator qy,
XPathNodeIterator iterator)

--- End of inner exception stack trace ---

at System.Xml.XPath.XsltFunction.InvokeFunction(XPathNavigator qy,
XPathNodeIterator iterator)

at System.Xml.XPath.XsltFunction.getValue(XPathNavigator qy,
XPathNodeIterator iterator)

at System.Xml.XPath.XPathNavigator.Evaluate(XPathExpression expr,
XPathNodeIterator context)

at System.Xml.Xsl.Processor.RunQuery(ActionFrame context, Int32
key)

at System.Xml.Xsl.VariableAction.Execute(Processor processor,
ActionFrame frame)

at System.Xml.Xsl.ActionFrame.Execute(Processor processor)

at System.Xml.Xsl.Processor.Execute()

at System.Xml.Xsl.ReaderOutput.Read()

at System.Xml.XmlLoader.LoadChildren(XmlNode parent)

at System.Xml.XmlLoader.LoadElementNode()

at System.Xml.XmlLoader.LoadCurrentNode()

at System.Xml.XmlLoader.LoadChildren(XmlNode parent)

at System.Xml.XmlLoader.LoadElementNode()

at System.Xml.XmlLoader.LoadCurrentNode()

at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)

at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader,
Boolean preserveWhitespace)

at System.Xml.XmlDocument.Load(XmlReader reader)

at Microsoft.XLANGs.Core.Service.ApplyTransform(Type mapRef,
Object[] outParams, Object[] inParams)

--- End of inner exception stack trace ---

at Microsoft.XLANGs.Core.Service.ApplyTransform(Type mapRef,
Object[] outParams, Object[] inParams)

at OLOTrans.OLOtoHRXML.segment2(StopConditions stopOn)

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

[ Post a follow-up to this message ]