When trying to drill down into the Asset Management 6.5 report "Count of Assets by Cost Center", a large SQL error occurs beginning with "Insufficient result space to convert uniqueidentifier value to char.Sql.CommandText."
Insufficient result space to convert uniqueidentifier value to char.Sql.CommandText.
Defect. The SQL code for the second report parameter incorrectly sets a too-small size to a text (nvarchar) value to receive a guid (uniqueidentifier) value.
This was originally resolved in an old version of Asset Management but is nevertheless still present in 6.5. The workaround is to modify the report by cloning and then editing it to increase the text size. An attached copy of the report is available to download. To use, copy to the Altiris Notification Server, go to Reports, then right click on the Reports folder and choose Import.