Ufdjrw

Get error:

Cannot implicitly convert type 'string' to 'int'

on this code:

<TotalInvoiceCost>
 <xsl:value-of select="sum(//*[local-name()='InvoiceTotal'])" />
</TotalInvoiceCost>

Then tried this:

 <TotalInvoiceCost>
 <xsl:value-of select="sum(number(//*[local-name()='InvoiceTotal']))" />
 </TotalInvoiceCost>

but get this error:

Argument 1 of function 'sum()' cannot be converted to a node-set.

Cut Down Sample Data with Structure (all values are numeric):

<TAR210 xmlns="demo">
 <DummyHeaderGroup xmlns=""/>
 <Invoice xmlns="">
 <Level1>
 <InvoiceTotal>1075</InvoiceTotal>
 </Level1>
 <Level1>
 <InvoiceTotal>595</InvoiceTotal>
 </Level1>
 </Invoice>
</TAR210>

In http://www.xpathtester.com/xpath, this works fine:

sum(//*[local-name()="InvoiceTotal"])

Example of XSLT in context:

<?xml version="1.0" encoding="utf-16"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt"
 xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var"
 exclude-result-prefixes="msxsl var userCSharp" version="1.0"
 xmlns:ns0="demo"
 xmlns:userCSharp="http://schemas.microsoft.com/BizTalk/2003/userCSharp">

 <xsl:output omit-xml-declaration="yes" method="xml" version="1.0" />

 <xsl:template match="/">
 <ns0:TAR210>
 <DummyHeaderGroup>
 <Level0>
 <TotalInvoiceCost>
 <xsl:value-of select="sum(//*[local-name()='InvoiceTotal'])" />
 </TotalInvoiceCost>
 </Level0>
 </DummyHeaderGroup>
 </ns0:TAR210>
 </xsl:template>

</xsl:stylesheet>

Well, the real world program is typically more complex than what we post on the web when we have a problem; I tried to simplify. The error had nothing to do with the code I posted.

To me, it seems like the biggest issue is that the error from the "Test Map" in Visual Studio doesn't give any hint to the line number with the error.

<Level0>
 <BatchNumberLeaveBlank></BatchNumberLeaveBlank>
 <InvoiceSendDateCCYYMM>
 <!-- Get current CCYYMM -->
 <!-- Current-DateTime doesn't exist in XSLT 1.0, had to use C# 
 <xsl:value-of select="concat(substring(current-dateTime(),1,4),substring(current-dateTime(),6,2))"/>
 --> 
 <xsl:value-of select="userCSharp:GetDateCCYYMM()"/>
 </InvoiceSendDateCCYYMM>
 <DefaultValueN>N</DefaultValueN>
 <TotalInvoiceCost>...

Then I had the C# code below:

 <msxsl:script language="C#" implements-prefix="userCSharp">
<![CDATA[ int lineCount = 0;

public int GetDateCCYYMM()
 
 return DateTime.Now.ToString("yyyyMMdd");
 

 ]]> 
 </msxsl:script>

Obviously, the "public int" should have been "public string" above.

The only way I know how to tackle these problems is the "divide and conquer" method.
I made a copy of the XSLT, named it same with _Debug.xslt, changed the BizTalk map to use it instead, and started ripping out lines of code left and right until the error goes away. Even removing the call to the c# didn't remove the error, so it must have been running a .NET compile or syntax check on the code.