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)
ITMS 8.5 RU1
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.
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: