Error: "Conversion failed when converting from a character string to uniqueidentifier." when merging two computers

Products

• IT Management Suite

Issue/Introduction

When attempting to merge two computer resources the following error is reported: 

Error: Conversion failed when converting from a character string to uniqueidentifier. 

Environment

ITMS 8.x

Cause

There are more data class's being merged than allowed per the size of the defined variables

Resolution

Alter the Stored procedure sppResourceMerge2 with the attached script, as this will allow it to merge resources with a larger number of data class's defined.

1. Log into SQL Management Studio with a user that has rights to alter stored procedures.
2. Copy the contents of the script into a query window.
3. Execute the script.
4. The Stored Procedure is now altered and no further changes should be necessary.