HomeHardware Independent Imaging SolutionCommon Errors"Error 2332" on Deployment

8.9. "Error 2332" on Deployment

"Error 2332" on Create External Batch File task

This is caused by an unhandled error, with two possible causes.

If using 1633, regenerate your deploy jobs, as they have the wrong parameters.

In old versions it is caused by a SQL collation mismatch as follows:

The error 2332 is caused by an incompatibility in one of the SQL User Defined Function that HIIS uses, it only affects SQL Server 2005, and only when using certain Database Collations.

Solution:
This issue has been fixed in the codebase, but until the next release you can use the included script script to patch the stored procedure.

ALTER FUNCTION [dbo].[HIIS_FolderList]
(
@compid int,
@profid int,
@intiald int
)
Returns @Result TABLE
(
FolderId int
)
AS
BEGIN
if @intiald = 1
BEGIN
insert into @Result (FolderId)
(
select
[dbo].[HIIS_Get_FolderIDtoUse]([FolderId])
from

[HIIS_Folders_Associations],[HIIS_ReferenceClass],[computer]
where
[AssociationId]=[HIIS_ReferenceClass].[ID] AND
([Associationtype]=50 or [Associationtype]=51)
AND
[HIIS_ReferenceClass].[ProfID]=@profid AND
[computer].[prod_name] =
[HIIS_ReferenceClass].[Model] collate database_default AND
[computer].[computer_id] = @compid
union
select
[dbo].[HIIS_Get_FolderIDtoUse]([FolderId])
From
[HIIS_Folders_Associations]
where
[AssociationId] = @profid AND
[Associationtype] = 1000
union
select
[dbo].[HIIS_Get_FolderIDtoUse]([FolderId])
From
[HIIS_Folders_Associations] FA join
[HIIS_Association_Strings] AStr
on Astr.[id] = FA.[AssociationId]
Join
[computer]
on lower(Astr.[stringval]) like
lower([computer].[prod_name]) collate database_default
where
Astr.[profid] = @profid and
FA.[Associationtype] = 500 and [computer].[computer_id] = @compid

)
END
ELSE
BEGIN
insert into @Result (FolderId)
(
select [dbo].[HIIS_Get_FolderIDtoUse]([FolderId])
from

[HIIS_Folders_Associations],[HIIS_ReferenceClassGrp],[HIIS_ReferenceClass]

where
[AssociationId]=[HIIS_ReferenceClass].[ID]
AND
([Associationtype]=50 or
[Associationtype]=51) AND

[HIIS_ReferenceClass].[ReferenceClassID]=[HIIS_ReferenceClassGrp].[ReferenceClassUID]
AND
[HIIS_ReferenceClass].[ProfID]=@profid AND

[HIIS_ReferenceClassGrp].[Computer_id]=@compid
union
select
[dbo].[HIIS_Get_FolderIDtoUse]([FolderId])
From
[HIIS_Folders_Associations]
where
[AssociationId] = @profid AND
[Associationtype] = 1000
union
select
[dbo].[HIIS_Get_FolderIDtoUse]([FolderId])
From
[HIIS_Folders_Associations] FA join
[HIIS_Association_Strings] AStr
on Astr.[id] = FA.[AssociationId]
Join
[computer]
on lower(Astr.[stringval]) like
lower([computer].[prod_name]) collate database_default
where
Astr.[profid] = @profid and FA.[Associationtype]
= 500 and [computer].[computer_id] = @compid
)
END
return
END

Versions Affected:
HIIS 6.9.0.416 and older, only SQL Server 2005

Downloads

This page was: Helpful | Not Helpful