This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
Consider the following scenario: during Package and Deployment, you created a duplicate Service Instance (by mistake) which has a display name identical to another existing service instance (e.g. you created an additional Endpoint Assembly service instance which points to exactly the same DLL file as an existing service instance with the same display name).
In this scenario it is necessary to delete the duplicate service instance and be sure you are deleting the right one (i.e. no existing/used SmartObjects will be impacted by its removal). To be able to do that you need to check which SmartObjects belong to which specific service instance.
Before You Begin
Make sure you backup your K2 database before deleting the service instance, to be able to rollback this operation.
There are two ways to check which SmartObject belongs to which specific service instance:
1. Use the Tester Tool > Tools > Search SmartObjects > Service.
2. Or by using the SQL script which has to be run against the K2 database:
SELECT DISTINCT SystemName as SMOSystemName, DisplayName_XML AS SMODisplayName, SmartObjectGUID, SO.ID.value('@guid', 'nvarchar(100)') AS ServiceInstanceGUID
CROSS APPLY SmartObjectXML.nodes('/smartobjectroot/methods/method/serviceinstances/serviceinstance') AS SO(ID)
WHERE SO.ID.value('@guid', 'nvarchar(100)') = '%INSERT_SI_GUID%'
ORDER BY SMOSystemName
Once you've identified the "unnecessary" service instance (the one which does not have SmartObjects linked to it), you can delete it using the Tester Tool utility.