Script to refresh identity cache in 4.7?

Hi,

Thanks for the info... Basically, support used Visual Studio code to create a K2 process for updating the Identity Cache (not sure what the code looked like as they created it for us).

This code has worked fine pn older K2 versions, but I tried to use Package and Deployment to migrate it to our new v4.7 server, but pakage and deployement fails to package up the process, i get these errors:

'MaintainADGroupsMaintainMembership' Process is referencing the 'Read' method on the 'PostScanning_BasketMetaData_BasketMembership' SmartObject that could not be found.

'MaintainADGroupsMaintainMembership' Process is referencing the return type 'read' of the 'Read' method on the 'PostScanning_BasketMetaData_BasketMembership' SmartObject that could not be found.

'MaintainADGroupsMaintainMembership' Process is referencing the 'PostScanning_BasketMetaData_BasketMembership' SmartObject that could not be found.

So i can't package up the process from the source server to deploy to the new one.

Any chance of showing me how to create the process from scratch using your code in v4.7? I've never created a process from Visual Studio.

Thanks

Peter is correct. Try including the SmartObject stated in the error message into your package. If the same error still appears, check if that SmartObject has the method stated, and that it is currently working. You can just the SmartObjects Service Tester to check if your SmartObject is working properly.

I think you're best bet is to go and find that SmartObject that's missing.  Then deploy that to the other environment and then your P&D should work.  With that said the P&D should typically pick up a smartobject that's used by a process and include it in the original package if you have the include depencies checked off.  Maybe the package wasn't created correctly.

Another option to find that smartobject is the SmartObject Tester Tool.  It has a search feature to look for that SmartObject..

http://help.k2.com/onlinehelp/k2blackpearl/userguide/4.7/content/resources/projects/advancedsmartobjects/smartobject-service-tester.htm

If that still doesn't help maybe submit a support ticket.

I'm doing well. Thanks

Okay this shouldn’t be too hard to resolve. In that case what if you create a stored proc using that identity sql script, wrap it in a SmartObject and then call it inside of K2 Studio like any other SmartObject.

Here is an example of a Stored Proc that you could add to a database (doesn’t necessarily have to be the K2 Database since that would be unsupported :)) but I tested it on the same sql server that contains the K2 database. Maybe have your SQL guy do a quick check of the stored proc but conceptually I see no difference than running the SQL script directly against the K2 database like recommends.

http://help.k2.com/onlinehelp/k2blackpearl/icg/4.6.11/webframe.html#User_Manager_Introduction.html#Refresh_the_User_Manager_Cache

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:           <Author,,Name>

-- Create date: <Create Date,,>

-- Description:      <Description,,>

-- =============================================

CREATE PROCEDURE RefreshK2ServerIdentityCache

AS

BEGIN

       -- SET NOCOUNT ON added to prevent extra result sets from

       -- interfering with SELECT statements.

       SET NOCOUNT ON;

    -- Insert statements for procedure here

UPDATE [K2].[Identity].[Identity]

SET [ExpireOn] = GETDATE()

,[Resolved] = 0

,[ContainersResolved] = 0

,[ContainersExpireOn] = GETDATE()

,[MembersResolved] = 0

,[MembersExpireOn] = GETDATE()

END

GO