Error encountered while executing the transform <mapping name>. Error:Transformation failed..

Question

Hi,

I'm migrating the Biztalk from version 2009 to 2013 R2, that project upload the flat files data(zipped to one file Data_<Datetime>.zip file) to the our SQL Database. the inbound message is large xml message before mapping is 50MB. I testing and got the error "Error encountered while executing the transform MyProject.Maps.FTData_To_KDData. Error:Transformation failed.."

This mapping use custom xslt file and I can use above xml message to successful testing xslt even take long time.

anybody have any idea please give me.

Thanks in advance.

Answer 1

Hi Daniel,

Thank you for posting in MSDN forum.

Error 'Transformation failed'  mean error in map (while doing transformation), could you please validate your map with input message?

---

Thanks,

If my reply is helpful please mark as Answer or vote as Helpful.

My blog | Twitter | LinkedIn

This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

Answer 2

I click to validate map and got the successful result.

I click to test map and got the error:

Error 3 Input validation error: The 'Timestamp' attribute is invalid - The value '' is invalid according to its datatype 'http://www.w3.org/2001/XMLSchema:dateTime' - The string '' is not a valid DateTime value.
Error 4 Input validation error: The 'http://MyNamespace/KDData:KDRoot' element is not declared.
Error 5 Input validation error: The element 'FTData' in namespace 'http://MyNamespace/FTData' has invalid child element 'FTRoot' in namespace 'http://MyNamespace/FTData'.

My source schema is using the any element as structure

FTData
--FTRoot
---Timestamp
---<Any>

Notes: my mapping using custom xslt file. I used input message to debug xlst file and get output without error.

Answer 3

Hi Daniel ,

There can be following reasons for "Error encountered while executing the transform" failure

1) As you are migrating map from BizTalk 2009 to BizTalk 2013 ,the underlying execution of mapper now follows xslt compiled transform which has put certain restriction like

◾Only public methods may be called from XPath expressions.

◾Overloads are distinguishable from each other based on the number of arguments. If more than one overload has the same number of arguments, an exception will be raised.

Refer MSDN Link Known issues in BizTalk Server 2013 Mapper

2) As your message size is large (more than 50 MB) you may be getting out of memory exception during mapper translation .As you said you have flat file as inbound, you are doing mapping and then sending it to MSSQL .Try using debug tool to see if memory leak is happening http://www.microsoft.com/en-in/download/details.aspx?id=26798

3)Also refer https://support.microsoft.com/en-us/kb/945924

Thanks

Abhishek

---

If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply