Unable to save a report as CSV file from Windows (Microsoft Data) Reports

Products

Patch Management Solution for Windows IT Management Suite

Issue/Introduction

The customer reported that he is unable to save as CSV file any report under Home > Patch Management > Windows (Microsoft Data), for example:
Software Updates> Microsoft Updates
Compliance and Remediation> Compliance by Update
Compliance and Remediation> Compliance by Computer
Compliance and Remediation> Compliance Updates

Or under:

Reports > Software > Patch Management > Compliance > Windows (Microsoft Data)
Microsoft Updates
Windows (Microsoft Data) Compliance by Update
Windows (Microsoft Data) Compliance by Computer
Windows (Microsoft Data) Compliance Updates

When he goes to Save as>Spreadsheet, it gets the prompt for selecting parameters and data range but he never gets the window for selecting where to save it.

The NS logs shows the following messages:

Simplified entry 1:

Failed to process formatting for column: 'Computer Name' (0, String)

Failed to apply formatting rule condition
....
Column '_ResourceGuid' does not belong to table Table.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Simplified entry 2:

HTTP Request failed:
/Altiris/Reporting/ReportSave.aspx?SaveAs=csv&ReportContext=e3ee0d8b-eab2-
48af-9df2-2c1a2275f482&ReportName=Windows+(Microsoft+Data)+Compliance+by+Computer&ProductGuid=00000000-0000-0000-0000-000000000000&SaveAll=True

Failed to apply formatting rule condition
...
Column '_ResourceGuid' does not belong to table Table.

Entry 1:

Failed to process formatting for column: 'Computer Name' (0, String)

Failed to apply formatting rule condition
   [Altiris.Reporting.Exceptions.ReportingException @ Altiris.Reporting]
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.ApplyFragment(Fragment fr, DataRow dr, GridColumnDetail gcd, Boolean conditioned, Object currentValue)
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.ApplyFormattingRules(DataRow dr, GridColumnDetail gcd, Boolean& applied)
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.ProcessRules (Int32
column, DataRow dr, Boolean& applied)

Column '_ResourceGuid' does not belong to table Table.
   [System.ArgumentException @ System.Data]
   at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.CollectConditionFieldValues(Fragment fr, DataRow dr, GridColumnDetail gcd, Object currentValue)
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.ApplyFragment(Fragment fr, DataRow dr, GridColumnDetail gcd, Boolean conditioned, Object currentValue)

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Entry 2:

HTTP Request failed:
/Altiris/Reporting/ReportSave.aspx?SaveAs=csv&ReportContext=e3ee0d8b-eab2-
48af-9df2-2c1a2275f482&ReportName=Windows+(Microsoft+Data)+Compliance+by+Computer&ProductGuid=00000000-0000-0000-0000-000000000000&SaveAll=True

Failed to apply formatting rule condition
   [Altiris.Reporting.Exceptions.ReportingException @ Altiris.Reporting]
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.ApplyFragment(Fragment fr, DataRow dr, GridColumnDetail gcd, Boolean conditioned, Object currentValue)
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.ApplyFormattingRules(DataRow dr, GridColumnDetail gcd, Boolean& applied)
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.ProcessRules (Int32 column, DataRow dr, Boolean& applied)
   at Altiris.Reporting.Web.HTMLHelper.RenderData(IReport ireport, DataTable dt, OnStart onStart, OnRow onRow, OnCell onCell, IsCellVisible isVisible)
   at Altiris.Reporting.Web.ReportSave.ConvertData2Csv(DataTable oDataTable)
   at Altiris.Reporting.Web.ReportSave.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at Altiris.NS.UI.Controls.PageCachePage.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Column '_ResourceGuid' does not belong to table Table.
   [System.ArgumentException @ System.Data]
   at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.CollectConditionFieldValues(Fragment fr, DataRow dr, GridColumnDetail gcd, Object currentValue)
   at Altiris.Reporting.Presentation.Formatting.FormattingRuleHandler.ApplyFragment(Fragment fr, DataRow dr, GridColumnDetail gcd, Boolean conditioned, Object currentValue)

Cause

Known issue. There is a call looking or passing '_ResourceGuid' as one that is part of the actual report. The reports seems to be using '_SWUGuid' instead.

Environment

ITMS 8.5 RU1

Resolution

This issue has been reported to the Symantec Development team. A fix has been added to our ITMS 8.5 RU2.

The current workaround in case you still need to save this type of reports as CSV file is the following:

Using the "Compliance by Computer" under Home>Patch Management>Windows(Microsoft Data)>Compliance and Remediation as example:

Select "Compliance by Computer"
Save as>Static Filter>Save...
The "Saved Static Filter" should be under Manage>Filters>Report Based Filters. Go there and find it.
Select the created Static Filter
Save As>Spreadsheet
Now you should be able to save and select a location and use the CSV file created as you need it.
Delete the "Static Filter" after you are done saving the CSV file so you don't end up with multiple copies of this report static filter.