Symptoms
We have a new sandbox environment and we're trying to build a workflow in k2 studio for the first time. We're getting an error message when trying to browse to the smartobject server:
SmartObject does not exist on the server. Name:
Diagnoses
Dependency data has not been properly cleaned up on teh server.
Resolution
NOTE: This required directly manipulating the database which is not recommended.
Can you run the following queries to see if there were references to the GUID in question in the Categories and/or Dependencies databases:-
select * from [K2].[Category].[Data] where data = ''
select * from [K2].[Dependency].[Dependency] where DependantId = ''
If records exist, please follow the following steps:-
1. Stop K2 blackpearl server service
2. Run the select statements above again and save results to an excel file (can be used for rollback)
2. Backup the K2 Databases
3. Delete the entries found
DELETE from [K2].[Category].[Data] where data = ''
DELETE from [K2].[Dependency].[Dependency] where DependantId = ''
4. Start K2 blackpearl server service
Please do remember to make a backup copy of the K2 databases prior to deleting any entries, in case of the need to roll back.
Note from client: I followed the steps above and retried K2 Studio. It then produced a different error with a different GUID. I ran the sql script against the new GUID and it resolved the issue.
