KNOWN ISSUE: Error ''Conversion failed when converting from a character string to uniqueidentifier'' when trying to export resource to Barcode handheld

Article:TECH30719  |  Created: 2007-06-06  |  Updated: 2007-06-18  |  Article URL
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


When trying export resources to a Barcode handheld, the following error may appear:

The following error is logged to the Altiris server logs:

Module: AltirisNativeHelper.dll
Source: Altiris.Barcode.Web.DataHandler.GetResourceTypeFolderForResourceTypes
Description: Exception thrown in GetResourceTypeFolderForResourceTypes. ( Unhandled exception.  Type=System.Data.SqlClient.SqlException Msg=Conversion failed when converting from a character string to uniqueidentifier. Src=.Net SqlClient Data Provider
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Altiris.Barcode.Web.DataHandler.GetResourceTypeFolderForResourceTypes(Guid[] resTypeGuids) )


Barcode 6.6 SP2


This can be caused if more than 111 Resource Type GUIDs are being processed in the export.

The Resource Type GUIDs are passed to the procedure spGetResourceTypeFolder which has an input parameter defined as @resTypeGuids  nvarchar(4000), which causes this error to be thrown under these conditions.


  1. Back up the spGetResourceTypeFolder stored procedure.
  2. Alter the procedure, changing the @resTypeGuids nvarchar(4000) input parameter to @resTypeGuids ntext.

Supplemental Materials

ValueSYD 30840
DescriptionLogged in sydd2 (Altiris - Sydney) database

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices