Error "Insufficient result space to convert uniqueidentifier value to char.Sql.CommandText" occurs when trying to drill down into the Asset Management 6.5 report "Count of Assets by Cost Center"

book

Article ID: 156421

calendar_today

Updated On:

Products

Asset Management Solution CMDB Solution

Issue/Introduction

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.

Cause

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.

Resolution

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.


Attachments

Updated Report Count of Assets by Cost Center.xml get_app