Kintana Script : Application Codes by Environment

Purpose

If you can't find an application code in the pick list when creating a request line and you know that the code is defined, this could be due to one of two reasons:

The application Code is not defined in EVERY environment referenced by the Workflow.

You belong to a security group which is restricted from using the application code.

This script will help you identify the FIRST reason : an environment with a missing application code.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the following script into SQL Runner

Omit the comment unless you're using a PL-SQL editor.
SQL Runner only supports select statements and you'll get a KNTA-10648 error.

-- List Application Codes by Environment

select ww.workflow_name,
       ee.environment_name,
       eea.app_code,
       wws.sort_order,
       wws.step_name
from KENV_ENVIRONMENTS ee,
     KWFL_WORKFLOWS ww,
     KWFL_WORKFLOW_STEPS wws,
     KENV_ENV_APPS eea
where ww.enabled_flag = 'Y'
and ( wws.source_environment_id != 0 or wws.dest_environment_id != 0 )
and wws.workflow_id = ww.workflow_id
and ( ( wws.source_environment_id = ee.environment_id
        and
        wws.source_environment_id = eea.environment_id )
      or
      ( wws.dest_environment_id   = ee.environment_id
        and
        wws.dest_environment_id   = eea.environment_id )
)

-- and ee.environment_name = 'prod'
-- and eea.app_code = 'hr'

order by ww.workflow_name, ee.environment_id, eea.app_code, wws.sort_order

WORKFLOW_NAME    ENVIRONMENT_NAME APP_CODE SORT_ORDER STEP_NAME
---------------- --------------   -------- ---------  ---------
DRS AU Backup    DRS APP1_BACKUP  AL3       2         APP1
DRS AU Backup    DRS APP1_BACKUP  AL3       3         APP2
etc etc

Check to see if the problem application code is defined in EVERY environment referenced by the workflow

To extract the output, click on the [Open as Text] button.

This opens a text window from which you can copy and paste.

Download

KintanaScripts.zip (79 Kb)