Javascript for disabling KROIP in workflows

[Jackbayer13]

Hello,

We have an issue with users using the 'Keep the result of interim populations' option to validate data in their workflows, and leaving it enabled. This option is not recommended by Adobe for Production environments, as it stores data in temporary tables and takes up disk space, affecting instance performance. We have tried communicating the impact this practice has on the instance, but it is a very convenient method of data validation for users, so they keep using it.

I have been told by Adobe Support that it is possible to write a custom script that will disable the KROIP option for workflows. I was wondering if anyone had done this and if they could share the script? We'd like to build a workflow that will disable KROIP for all workflows at the end of every day.

Thanks in advance!

[ParthaSarathy]

Hi @Jackbayer13 ,

You can try the script given in this 'Tuesday tech bytes' thread 

[Jackbayer13]

Hi Partha,

This script seemed to work in STAGE, but now I'm trying to run it in PROD and it doesn't seem to be working.

Thanks

[ParthaSarathy]

Hi @Jackbayer13 , The script logic suits to all the environments.

Might be an database permission issue. Check with your database team that is there permission to update the value in xtk:workflow schema in Production environment. Or else you can try the another solution suggested by David in the same Tuesday tech bytes thread.

[Jackbayer13]

Hi Partha,

I have administrator rights, so I should be able to update values in the schema. And doesn't David's script do the same things as yours, but also prevents SQL logging?

Thanks,

Jack