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:
*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:
- User – The full name of the login user-field is empty for a background service exception.
- GUID – The GUID identifier of this exception. Most web exceptions are tagged with a GUID. Background service exceptions usually do not have a GUID.
- Name – The name of the exception.
- URL – The URL of the page that encountered this exception.
- Reason – Reason for the exception. This can be an error message for background service entries.
- Node name – The node name where this exception occurred.
- Generated Time – The time when this exception occurred.
- 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.
by Xiao-Bo Wu, Product Manager with HP Project and Portfolio Management
Article source: HP PPM Blog