"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 resources the following error is reported: 

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

Conversion failed when converting from a character string to uniqueidentifier. 

Environment

ITMS 7.x, 8.x

Cause

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

Resolution

Alter the Stored procedure sppResourceMerge2 with the attached script, this will allow it to merge resources with a large 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. No further changes should be necessary.