Expert tips and tricks to take your solution to the max

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….

 

tips and tricks pic.pngFirst 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.

 

 

Leave a Comment

We encourage you to share your comments on this post. Comments are moderated and will be reviewed
and posted as promptly as possible during regular business hours

To ensure your comment is published, be sure to follow the Community Guidelines.

Be sure to enter a unique name. You can't reuse a name that's already in use.
Be sure to enter a unique email address. You can't reuse an email address that's already in use.
Type the characters you see in the picture above.Type the words you hear.
Search
Showing results for 
Search instead for 
Do you mean 
About the Author
Featured


Follow Us
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.