IT Service Management
Showing results for 
Search instead for 
Do you mean 

Expert tips and tricks to take your solution to the max

XiaoboWu ‎08-15-2013 01:29 PM - edited ‎07-09-2015 08:08 PM

Hello! As this is my first post I wanted to take a moment to introduce myself. My name is Xiao-Bo Wu. I am a Product Manager with HP Project and Portfolio Management. I will be posting here regularly with tips and tricks to provide advice to help you maximize your HP Project and Portfolio Management solution. So without further ado, I proudly present my first post….

 

First Tip: Troubleshooting your HP Project and Portfolio Management Database Connection

 

A database connection is the way in which a database server and the client software communicate with each other in order to send commands to and receive replies from the server.  If your HP Project and Portfolio Management (PPM) instance is running out of database connections, the easiest way to find the culprit is to use the Connection Correlation page.  All you have to do is enable the server parameter to access this feature:

 

com.kintana.core.server.ENABLE_CONNECTION_CORRELATION=true

 

*If this parameter does not appear in the admin console it should be added directly to server.conf.

 

Benefits: This feature allows support engineers to identify suspect leaking connections. The Connection Correlation page can be accessed from: Open- Administration-View- Connection Correlation.

 

Additionally, the HP PPM administrator is required to have an administrator license and “server tools” to run the program with administrator credentials.  You will need to execute “admin tools” to grant access to this page.

 

Second Tip: Retrieve exception details when a generic error message is displayed to a user through GUID:

 

Whenever an unexpected error occurs in HP Project and Portfolio Management (PPM), a generic error message is displayed to the user. How many of you have seen this pop-up on your screen?   “An unknown error has occurred. For more information, please contact your PPM administrator.” 

 

In instances such as these, if you want for quicker service, provide the respective Globally Unique Identifier (GUID) number to the administrator.  For example: GUID=D1B57AA2-5FA2-B714-F096-1A5837FC4E77.   A GUID is a unique reference number to identify computer software and various necessary implementations.

 

Benefits: When a GUID number is provided, the HP PPM administrator can obtain more details about the exception from the search exceptions page.  With this ability, they can get to the bottom of a problem that much quicker.

 

The “Search Exception” page is accessed from: Search- Administrative- Exceptions

 

The HP PPM administrator is required have an administrator license and “Server Tools.”  To execute admin tools and grant access to this page. This saves the administrator the burden of having to search the exception.  

 

From the HP PPM logs, you can provide the following valuable information to the administrator:

 

  1. User – The full name of the login user-field is empty for a background service exception.
  2. GUID – The GUID identifier of this exception. Most web exceptions are tagged with a GUID.  Background service exceptions usually do not have a GUID.
  3. Name – The name of the exception.
  4. URL – The URL of the page that encountered this exception.
  5. Reason – Reason for the exception. This can be an error message for background service entries.
  6. Node name – The node name where this exception occurred.
  7. Generated Time – The time when this exception occurred.
  8. Stack trace – The stack trace of the exception.

 

 

Do you have any thoughts on troubleshooting your PPM database connection? Have you experienced this before and you have advice for others? Feel free to reach out to me in the comments section below.

 

 

0 Kudos
About the Author

XiaoboWu

Events
Aug 29 - Sep 1
Boston, MA
HPE Big Data Conference 2016
Attend HPE’s Big Data Conference on August 29 - September 1, 2016 to learn from peers in every industry and hear from Big Data experts and thought lea...
Read more
Sep 13-16
National Harbor, MD
HPE Protect 2016
Protect 2016 is our annual conference on September 13 - 16, 2016, and is the place to meet the world’s top information security talent, discuss new pr...
Read more
View all