This patch is required for Oracle Primavera P6 Version 21 Professional if upgrading existing SQLite databases.
Primavera P6 Professional Project Management (P6 PPM) Version 21.12 Patch Set 1 (21.12.1.0) (Doc ID 2834576.1)
In the latest Oracle Primavera P6 release (19.12), the P6 web pages have been setup to follow an Oracle Primavera standard. This standard is to save the column widths and grouping theme to the user viewing the page. This applies to any Primavera web-based application so they all work the same way.
If you are running these older versions of P6 Enterprise or Oracle Weblogic, it is imperative that you upgrade immediately to protect your installation and data from known security issues:
If you are running P6 Enterprise R18.8 or R19.12 with the latest patches, and Oracle Weblogic version 12.2.1.4 with latest patchsets, you have the most current updates.
Applies to:
Information in this document applies to any platform.
When attempting to click on the 'Download File' link within the Job Status window of P6 Professional for downloading an exported XML file (while connected to an EPPM database), no XML file download is initiated and instead clicking the link does nothing.
Note: This issue can occur with either a Primavera XML or Microsoft Project XML (MSP XML).
When attempting to click on the 'Download File' link within the Job Status window of P6 Professional for a XML export, a browser should launch to load P6 (web) for in initiating the XML file download.
The issue can be reproduced at will with the following steps:
Firefox version 52, no longer supports Java plugins, which are needed to make the classic views in P6 EPPM work.
Beginning in Firefox version 52, support for NPAPI plugins in Firefox has ended, except for Adobe Flash. Some of the plugins that will no longer load include Java, Microsoft Silverlight and Adobe Acrobat. See this compatibility document for details.
Over the past few years, Firefox has implemented various Web APIs so that websites can do the same things they’ve always done without plugins, so you will most likely not notice any change to your browsing experience.
In case you’re not yet ready for this transition to happen, the ESR (Extended Support Release) of Firefox 52 will continue to support these plugins until early 2018.
Click here to download Firefox ESR.
Release 15.1 is the latest release of Oracle’s Primavera P6 Enterprise Project Portfolio Management solution. This release delivers significant advances in functionality and will help companies deliver more projects on schedule and within scope, while reducing overall costs.
The last version of EPPM was release 8.4. Release 15.1 is not the current version, and it represents a change in the numbering system so that year of release is represented in the release number.
[collapse collapsed title=Import and Export Baselines of Projects in XML Format]
1. Start cmd prompt as administrator
2. cd\oracle_middleware_12c\user_projects\domains\PrimaveraP6EPPM\bin
3. Run setdomainenv.cmd
4. Create keystores directory in C:\oracle_middleware_12c\user_projects\domains\PrimaveraP6EPPM
5. cd to keystores directory (your dir should be: c:\oracle_middleware_12c\user_projects\domains\PrimaveraP6EPPM\keystores)
6. Run the following to generate the keystore:
keytool -genkey -alias server_cert -keyalg RSA -keysize 2048 -dname "CN=ENTERYOURDOMAINHERE,OU=Hosting,O=YOURNAMEHERE,L=YOURLOCATIONHERE,ST=YOURSTATEHERE,C=US" -keypass welcome -keystore keystore.jks -storepass welcome
7. Run the following to create the csr
keytool -certreq -v -alias server_cert -file server.csr -keypass welcome -storepass welcome -keystore keystore.jks
8. log into ssls.com and buy new PositiveSSL for any # of years
9. Submit the text of server.csr - select weblogic - all versions
10. Verify e-mail and wait for .zip file
11. Once .zip file arrives, unzip to the keystores directory on the server
12. rename all root certs as rootCA.crt, rootCA2.crt, rootCA3.crt etc
Challenge: Client can't export from VM IE 9 Windows & PC via the P6 Web 8.3.
More specifically, client could get the project to show after selecting it from the popup menu.
Client was able to export from his server with Server 2008 r2 IE 8
When comparing the two, client found the VM to have a different set of plugs loaded when trying to export.
Client also found that Java 6.0_43 was still installed.
Before the fix, we uninstalled the old Java from the control panel, deleted all browser history, and reopened IE and logged into P6 the application downloaded the correct plugins need to fix the problem.
After the Fix
The popup fills in correctly.
The File exports correctly.
When using a SQL Server Platform, the responsibility for maintaining performance of the SQL Server database is a task of the SQL Administrator (SA). The following information can assist with this task and should be considered when performance tuning a SQL Database Instance and database for P6 EPPM:
The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends. Click here for a Microsoft TechNet site which will provide useful information in the guidance of how to perform these tasks effectively.
Highlighted information which should be considered from this section:
If you are upgrading to Primavera P6 Enterprise Project Portfolio Management (P6 EPPM) Version 8.3 Patch Set 4 (Doc ID 1915620.1), you must first apply 8.3.3.0. Version 8.3.3.0 is considered a base release and it must be applied before upgrading to Patchset 8.3.4.0.
