Process Mappers‎ > ‎Excel Process‎ > ‎

Failure exporting maps to Excel

 This article is suitable for a Process Mapper
 
Id: 2609346
Last Edited: May 29th, 2012
Applies to: Process Navigator 4.60 onwards

Description 

When the map page does not contain a Node, Process Navigator throws an exception message and Export to Excel process is stopped. See example below.

 
03/11/2011 17:22:30

Failure exporting selected maps to Excel XML.
Object reference not set to an instance of an object.
Failure exporting selected maps to Excel XML.
System.NullReferenceException: Object reference not set to an instance of an object.

at Triaster.ProcessNavigator.Common.ProcessObjects.ExcelExportHelper.SetReferenceIDsForCollection(ElementBase objElement) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\Common\ProcessObjects\clsExcelExportHelper.vb:line 1921
at Triaster.ProcessNavigator.Common.ProcessObjects.ExcelExportHelper.SetReferenceIDs(Map objMap) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\Common\ProcessObjects\clsExcelExportHelper.vb:line 1884
at Triaster.ProcessNavigator.Common.ProcessObjects.ExcelExportHelper.SetReferenceIDs(Maps objMaps) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\Common\ProcessObjects\clsExcelExportHelper.vb:line 1843
at Triaster.ProcessNavigator.Common.ProcessObjects.ExcelExportHelper.PopulateXML(Maps objMaps) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\Common\ProcessObjects\clsExcelExportHelper.vb:line 97
at Triaster.ProcessNavigator.Common.ProcessObjects.Maps.ExportToExcel(String strExcelXMLFile) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\Common\ProcessObjects\clsMaps.vb:line 1513

03/11/2011 17:22:30

General error when Exporting to Excel File.
Object reference not set to an instance of an object.
General error when Exporting to Excel File.
System.NullReferenceException: Object reference not set to an instance of an object.
at Aspose.Cells.Workbook.ԝ(Stream Ԡ, LoadOptions ԟ)
at Aspose.Cells.Workbook..ctor(Stream stream)
at Triaster.ProcessNavigator.Common.Helper.FileSupport.AsConvertXML(Stream stream, String filename, Int32 intfilterindex) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\Common\Helper\FileSupport.vb:line 1903
at Triaster.ProcessNavigator.AnalystEdition.clsExportExcelFiles.ExportSingleExcelFile() in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\AnalystEdition\clsExportExcelFiles.vb:line 97
 at Triaster.ProcessNavigator.AnalystEdition.frmMain.mnuSingleExcelXML_Click(Object sender, EventArgs e) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\AnalystEdition\frmMain.vb:line 11747

Cause

The map page does not have a Node, a required shape for many Process Navigator feature, including Export to Excel. Process Navigator proceeds to throw an exception message.

Workaround

Ensure there is a a Node on to the map page and export again.

Solution

This has been resolbed in 11.2, Process Navigator no longer attempts to export maps that do not have a Node.
 
 
Need further help? Contact the Triaster Support team by e-mailing support@triaster.co.uk or by calling us on +44 (0)870 402 1234.
 
Do you have any feedback or suggestions that you would like to share with Triaster? We would love to hear from you! Please e-mail feedback@triaster.co.uk