Removing redundant processes

Hi,

As far as I'm aware, there is no way of removing old processes from the system using the management tools.

It may be worth checking the release notes for SP2, to see if there is anything about this there, otherwise, it's probably worth checking with your local K2 office to see if there is any method of removing old processes.

Regards,
Dave.

Hi Paul,

Did you find a way to remove redundant processes as I have a similar problem?

Cammie

Unfortunately not, Cammie - we've been working around the problem.

If anyone else comes up with a solution to this one, I would be interested though....

Unfortunately SP2a still has no way to remove a redundant Process. You can however dive into the database and look around at the table _ProcSet in the transaction database. I have deleted processes from my dev database with no ill effects so far. I would recommend a thorough test before attempting this with a production system!

[Edit]
This table has related entries in _Proc joined by ProcSetID. _Proc has releated entries in _ProcData joined by ProcID as well as _ProcImp, _ProcRef and _ProcInst which has related entries in _ProcInstDestQueue.

these are the table I found related entries to the records I deleted there may be more, you probably don't need to clean these up.

Definitely NOT a recommended solution - especially not on production databases. K2Workflow can not take responsibility for ANY problems occurring after manually altering databases. For security, auditability, reliability, and a host of other reasons - THIS IS NOT ALLOWED ON PRODUCTION DATABASES!!!

Please contact your local K2 support office for assistance in this matter.

Regards,
Ockert

Quite right Ockert, as I said as well I would not do this on a production database. I think people are after solutions to issues and I hope K2 is taking on board enhancements people are looking for in updates to this product.

:D

Hi JB,

I can assure you that we take note of all feedback supplied by customers and partners, the success of the product is measured by having successful customers.

I have encountered this question a couple of time and as Ockert mentioned For security, auditability, reliability, and a host of other reasons . We have a set of Clean-Up procedures that's aimed at development environments; I will recommend you using this rather that doing it directly in the database.

Please contact your local K2.net representative for more information on the Clean-Up procedures (if they not 100% sure what you are referring to please ask them to contact me directly :))

Thanks Rénier,

It is good to know there is going to be a supported method of doing this, although we have not got a situation where process need to be removed in a production system, it has been highlighted as a risk that we may need to and it is not currently supported.

I am looking for the ability to delete individual processes as well as deleting a processs set.

Was wondering if there has been any development in this area.


cheers

Gwyn

Please contact your local K2.net Support office and ask for the database cleanup scripts - Please note: This is NOT supported on production environments.

Regards,
Ockert