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 http://www.symantec.com/docs/TECH30719
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

Issue



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
StackTrace=
   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) )


Environment



Barcode 6.6 SP2

Cause



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.


Solution



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

Supplemental Materials

SourceDEFECT
ValueSYD 30840
DescriptionLogged in sydd2 (Altiris - Sydney) database

Legacy ID



35345


Article URL http://www.symantec.com/docs/TECH30719


Terms of use for this information are found in Legal Notices