Kintana Script : Unable to Open an Environment

Purpose

Sometimes nothing happens when you click on an environment in the environment workbench.

This is due to one or more of the environment's visible password fields having been corrupted. In my experience the corrupt password is usually a user defined password on the 'User Data' tab.

This script will help you locate and fix the corrupt password so you can open the environment record dialog.

Tested

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

Usage

Paste the following script into Toad or SQL Runner

Use the gui to locate the Environment user data definitions and identify the 'user_dataN' field(s) on it being used for passwords.

Write down the field names, what they're used for, and the current plaintext passwords.

Field        Used for   Current Password

user_data6   "APPS"     opensesame
user_data8   "HR"       alibaba
user_data9   "BOM"      houdini

Modify this query with your field names:

update KENV_ENVIRONMENTS ee
set ee.visible_user_data6 = NULL, ee.user_data6 = NULL,
--  ee.visible_user_data8 = NULL, ee.user_data8 = NULL,
--  ee.visible_user_data9 = NULL, ee.user_data9 = NULL,
where ee.enabled_flag = 'Y'
and ee.environment_name = 'theenvironmentnameyoucantopen'

Run the update, followed by a 'commit', and then go back to the environment workbench and click on the environment.

If the environment still does not open, then un-comment the next line, re-run the update, do the commit, and click on the environment again.

Do this as many times as required until the dialog for the environment opens!

Using the gui, update the password fields you nulled out.

Save and close the environment record, and finally click it again to make sure it now opens properly!

Download

KintanaScripts.zip (64 Kb)