Installed Hotfix 2.01 (4.7281.1.0). Now I can't delete Smart Objects

Hi Mikr1,

Where have you got your HostServer installed i.e. did you install to C: drive or D: drive?

Regards,

Ockert

Hi

 I have the same peoblem. If I try to delete an SmartObject, I became the same error message.

Regards

Juerg

I also experienced this problem today for the first time.  I am running BlackPearl hotfix 2.01.

Is there any resolution for this problem?  As it is now, I am not able to open the Service Object node in the environment library because of a problem with a custom smart object, but I can't delete it to get rid of the problem.  Essentially, this is making it so that K2 is not usable. 

I have heard rumors that a service pack release is coming sometime.  Any word on when that will be?  There are a number of things like this which would be nice to have updated.  

I actually wrote a SQL script to remove SmartObjects directly from the K2:BP databases. It seems to work, but neither I nor my company, nor (obviously) Sourcecode take any resposibility for the use of this code. You'll also probably invalidate any support agreement you have for K2, so ONLY USE THIS IN EXPERIMENTAL DEVELOPMENT ENVIRONMENT (or just take virtual pc snapshot).

-- SmartObject brute force deleter

-- assign @soname the name of your SmartObject
declare @soname as nvarchar(255)
select @soname = 'CompetencyFramework' -- Name of your smart object goes here

-- Categories -> CategoriesData
DELETE FROM [Categories].[dbo].[CategoriesData]
      WHERE ([objectname]=@soname)

-- Dependencies -> Dependancies
DELETE FROM [Dependencies].[dbo].[Dependancies]
WHERE (([ParentName] = @soname) OR (DependantName = @soname))

-- SmartBox -> SmartBoxObject
declare @soid as uniqueidentifier
SELECT @soid = [SmartBoxObjectGUID]
  FROM [SmartBox].[dbo].[SmartBoxObject]
 WHERE (SmartBoxObjectXML.value('(/object/metadata/display/displayname)[1]', 'nvarchar(255)')=@soname)
DELETE [SmartBox].[dbo].[SmartBoxObject]
WHERE ([SmartBoxObjectGUID]=@soid)

-- SmartBroker -> ServiceObject
DELETE [SmartBroker].[dbo].[ServiceObject]
where ([SystemName]=@soname)

-- SmartBroker -> SmartObject
DELETE [SmartBroker].[dbo].[SmartObject]
WHERE     ([SystemName] = @soname)

-- SmartBroker -> Associations
DELETE [SmartBroker].[dbo].[Associations]
WHERE ((SmartObjectName = @soname) OR (RefSmartObjectName =@soname))

-- SmartBroker -> AssociationProperties
declare @soid2 as uniqueidentifier
SELECT     TOP (1) @soid2=SmartObjectGUID
FROM         [SmartBroker].[dbo].[SmartObject]
WHERE     (SystemName = @soname)
ORDER BY Version DESC
DELETE [SmartBroker].[dbo].[AssociationProperties]
WHERE     ((SmartObjectGUID = @soid2) OR (RefSmartObjectGUID = @soid2))

-- Drop SmartBox -> [@soname]
exec('DROP TABLE [SmartBox].[dbo].['+@soname+']')

Good luck

As I said: "It seems to work" :D

I've actually been using it a lot and I does get rid of SmartObjects. I've been using it in a virtual pc development environment to implement our first K2:BP (proof of concept) project - an employee appraisal system.

Generally I'm quite happy with K2. I've had to do a bit of tweeking to the activity designer templates to make it send emails properly. I'm not brilliantly sure it's at production level just yet. I've got really high hope for the up-coming service pack.