How To Change The Database Connection Information For Claim Digger/Schedule Analyzer For P6

(Doc ID 899593.1)

Last updated on JANUARY 03, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 5.0 and later
Primavera Contractor - Version 5.0 to 6.1 [Release 5.0 to 6.1]
Primavera P6 Professional Project Management - Version 5.0 and later
All Platforms

Goal

This document explains explains how the Java connection from P6 desktop client API application tools to the database works (Claim Digger/Schedule Analyzer, Update Baselines, XML Import/Export) as well as how to trouble-shoot the database connection. 

A user might need to change this information if Claim Digger or one of the other API applications does not launch or launches and prompts for a user name and password.

A user might also change this information if any of the following error messages occur when trying to run Claim Digger or Update Baseline:

com.primavera.PhoenixException: Unable to resolve privileged username and password
Failed Logon:com.jnetdirect.jsql.u: TCP/IP connection failed to host:java.net.ConnectException: Connection refused: connect url:jdbc:JSQLConnect://server:###/database=pmdb

com.primavera.PhoenixException: Unable to resolve privileged username and password
Failed Logon:com.jnetdirect.jsql.u: TCP/IP connection failed to host:java.net.ConnectException: Connection refused: connect url:jdbc:JSQLConnect://[SERVER NAME]:[PORT No.]/database=pmdb$primavera

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms