Manjula

Manjula

  • 2.1k
  • 2
  • 3.2k

ThreadAbortException while generating report

Jul 16 2012 3:42 AM
Hi,

I have a report that generated by pulling data from SQl DB as XML, compiles with XSL then puts the data in excel file.   It was woking fine in LIVE.  All of a studden, I am facing Thread exception (given below) while generating the report. 

System.Threading.ThreadAbortException: Thread was being aborted.

   at System.Collections.Hashtable.HashtableEnumerator.get_Current()
I copied DB data to my trial server and tested the same case there.  it worked fine.  All the settings are same in these two servers.  What is the cause for this issue and How to fix it?  the Complete exception is :

DEBUG PCPS.Web.Common.GenerateAcuteChronicRpt [(null)] - GenerateAcuteChronicRpt - GenerateAcuteChronicRpt_New

System.Threading.ThreadAbortException: Thread was being aborted.

   at System.Collections.Hashtable.HashtableEnumerator.get_Current()

   at System.Xml.XmlDataDocument.AddPointer(IXmlDataVirtualNode pointer)

   at System.Xml.XPathNodePointer..ctor(DataDocumentXPathNavigator owner, XmlDataDocument doc, XmlNode node, DataColumn c, Boolean bOnValue, XmlBoundElement parentOfNS)

   at System.Xml.XPathNodePointer..ctor(DataDocumentXPathNavigator owner, XPathNodePointer pointer)

   at System.Xml.DataDocumentXPathNavigator..ctor(DataDocumentXPathNavigator other)

   at System.Xml.DataDocumentXPathNavigator.Clone()

   at System.Xml.Xsl.Runtime.ContentIterator.Create(XPathNavigator context)

   at <xsl:template match="/REPORT/ClaimDetail">(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime, XPathNavigator {urn:schemas-microsoft-com:xslt-debug}current)

   at <xsl:template match="/*">(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime, XPathNavigator {urn:schemas-microsoft-com:xslt-debug}current)

   at <xsl:template match="/">(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime, XPathNavigator {urn:schemas-microsoft-com:xslt-debug}current)

   at Root(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime)

   at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter writer, Boolean closeWriter)

   at System.Xml.Xsl.XmlILCommand.Execute(IXPathNavigable contextDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter results)

   at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, Stream results)

   at PCPS.Web.Common.GenerateAcuteChronicRpt.GenerateAcuteChronicRpt_New(RptClaimDTO SearchData)