Claim digger error in P6.2.1
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Martin,
Try this if Arnolds suggestions doesnt work with you:
Go to Start/Programs/Microsoft SQL Server 2005/Configuration Tools/SQL Server Configuration Manager
OR
Go to Start/Run and type SQLServerManager.msc, click OK.
Expand "SQL Server 2005 Network Configuration" and highlight "Protocols for PRIMAVERA"
Right-click on "TCP/IP" and choose "Properties"
Click on "IP Addresses" tab.
Scroll down to "IPAll"
Clear the "TCP Dynamic Ports" column (if it is populated)
Assign "1433" to "TCP Port"
Click "Apply"
Restart the SQL Server Service
In Windows Explorer on the client workstation go to C:\Program Files\Common Files\Primavera Common\Java and run dbconfig.cmd
Select Microsoft SQL Server, click Next.
Enter the pubuser password (pubuser by default), the Database Name, Database Host Address (for standalone install use localhost and for server install use the server machine name) NOTE: No instance name is required after host name, enter the TCP/IP port (1433 in this example), click Next.
Do not use an existing configuration, create a new configuration with a unique name and click Next.
Click OK.
Login to Project Management and try Claim Digger again.
Click on Tools, Claim Digger.
Let us knows if the above helps.
Best regards,
R. Catalan
Hi Martin,
The connection information is incorrect in the INTERNAL_PLUGINS section of Primavera Administrator
To fix this:
1. Navigate to C:\Program Files\Common Files\Primavera Common\Java
2. Run admin.cmd
3. Enter the Database username and password
* Note the Configuration being used in the Command window. By default, this is "INTERNAL_PLUGINS"
* Expand the Configuration being used (i.e. INTERNAL_PLUGINS)
* Expand Database
* Expand Instance
* NOTE - Hit F2 or right click and select configure in order to makes changes to the URL
4. Verify that the URL Connection points to the correct database. Check the correct URL and can be found under Help in Project Management, About Primavera, System Tab then look for "jdbc:..." it looks like this:
jdbc:sqlserver://localhost:1433;database=pmdb$primavera;
Just try this.
Regards,
Arnold