Skip to main content
Nintex Community Menu Bar

K2 BlackPerl Processes CleanUp

  • October 12, 2009
  • 4 replies
  • 16 views

Forum|alt.badge.img+6

Dear All, 


 


I have been in a very critical situation, since my client is asking to delete and remove 10 of his processes which he doesn't want anymore. 


 


As we know there is no possibility in K2 BP to remove a process, any updates about this feature if it has been implemented ? 

4 replies

Forum|alt.badge.img+1

There is a K2 stored procedure called "wProcDelete" in K2 DB which allows you to remove Process Definitions.
Just need to pass in the FullName of the process as a parameter.
Do note that it's not recommended for Production system and not supported by K2.


Forum|alt.badge.img+6
  • Author
  • October 19, 2009

Hi, The stored procedure deletes and cleans the K2Server DB but it does not clear the K2ServerLog DB. Since in the Process Overview Report i'm still getting all the workflow and instances and information about the WFs. 


 


We need also a way to clean the K2ServerLog DB.


 


Thanks a lot for your support


Forum|alt.badge.img+10
  • Nintex Partner
  • October 19, 2009

There is a supported way to clean out the K2ServerLog DB by using the K2 workspace archive functionality.  The downside of this tool is it doesn't allow you to specify what processes you want to move to the archive database but simply moves everything within a certain date range.  So if you want to move everthing simply select a date range from the past till today.


Here is a section in the online help which talks about the Archive capability:


K2 Workspace > K2 Management Console > Workflow Server > Workflow Service Management - Archiving


 


I hope this helps.


Tim


Forum|alt.badge.img+9
  • Nintex Partner
  • October 20, 2009