Project and Portfolio Management Practitioners Forum
cancel

Can't delete Environment name which is in use.

SOLVED
Go to solution
Highlighted
TurboMan
Honored Contributor.

Can't delete Environment name which is in use.

Hi,

I am trying to delete an environment name in the WorkBench, But I get an error saying
"This Environment cannot be deleted, It is in use on a workstep.(KDLV-20060)"
Is there any way to find out which worksteps are using this environment name instead of checking all worksteps one by one?

Thanks in advance
Regards
TM
3 REPLIES
Jim Esler
Acclaimed Contributor.
Solution

Re: Can't delete Environment name which is in use.

The only way I am aware of is to query the database directly. The relevant fields are SOURCE_ENVIRONMENT_ID and DEST_ENVIRONMENT_ID in the kwfl_workflow_steps table in PPM 7.5 and earlier releases. This may work in 8.0 and 9.1 but we have little experience with them.
TurboMan
Honored Contributor.

Re: Can't delete Environment name which is in use.

Thanks,

From your advice, I came up with the following SQL.

SELECT step_name, source_environment_name, dest_environment_name, sort_order
FROM kwfl_workflow_steps_v
WHERE workflow_id = (SELECT WORKFLOW_ID
FROM kwfl_workflows
WHERE workflow_name = 'MyWorkFlow') --WorFlow to be checked
AND SOURCE_ENVIRONMENT_ID IN (SELECT ENVIRONMENT_ID
FROM kenv_environments
WHERE environment_name <> 'ENV_NAME') --Checking all environments except ENV_NAME


TurboMan
Honored Contributor.

Re: Can't delete Environment name which is in use.

My post