Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Can't delete Environment name which is in use.

SOLVED
Go to solution
Highlighted
TurboMan
Member

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
Honored 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
Member

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
Member

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

My post
//Add this to "OnDomLoad" event