How to Track a P6 Web, Team Member Web, or P6 Professional Cloud Connect Users Session Using the Built-in Session Tracking Feature (Doc ID 2274947.1)

Last updated on AUGUST 17, 2023

Applies to:

Goal

How to track a P6 Web, Team Member Web, or P6 Professional Cloud Connect user's session using the built in session tracking feature.

This feature is built into the following:

• Cloud Connect deployment starting in versions 16.2.4+ and 17.2+
• P6 Web starting in versions 19.12.18+, 20.12.12+, 21.12+, and 22.1+. 
• Team Member Web starting in versions 21.12.14+, 22.12.4+, and 23.4+.

This tool will trace SQL for a single user logged into P6 Web, Team Member, or the P6 Professional Client using the Cloud Connect driver. 

While this provides similar tracing functionality to the tracer.jar utility (documented in Doc ID 894429.1 - How To Trace SQL And Java From The P6 Web Access Server), there are a few key differences:

• The session tracker is enabled out of the box and does not require special settings in the P6 Configuration.  This also means that using it will not require a restart of the deployment to enable it.
• The session tracker will only capture the SQL for individual sessions that are being chosen to track, while the tracer.jar captures all SQL processed by the deployments, including background services.
• Because it must be activated after the user is logged in, it cannot be used to troubleshoot issues that occur before the user has fully opened the software.

This functionality can be used by Support or Development to capture SQL for Primavera Cloud Customers without the intervention of the Cloud Hosting team.  Any Support engineer can implement this process during a conference with the customer while the customer replicates the issue being investigated.

Solution