Emerald Blog

Stories, Tips And Tricks From Our Team’s Experiences With Primavera Since 1995

21 July 2017

How to Upgrade Primavera P6 16.x to Primavera P6 17.7

Written by Paul Jardin - VP of Technology

Step by Step Instructions on how to Upgrade Primavera P6

Here are step by step instructions on how to upgrade your Primavera P6 16.x environment to the new Primavera P6 17.7.


Download the latest version from edelivery.oracle.com.


Upgrading Primavera P6 17.7


 Extract Oracle Primavera P6 Client from the zip file named V886690-01.zip.

Upgrading PrimaveraP6 17.7


Run the setup.exe that is in the P6_Professional_for_EPPM folder, and choose the Upgrade option.

Upgrading Primavera P6 17.7


Press Upgrade again.

Upgrading Primavera P6 17.7


It will begin to upgrade itself. Now we need to Run Database Configuration.

Upgrading Primavera P6 17.7


Set the driver type to Oracle.

Upgrading Primavera P6 17.7


You need to enter your connection string. In this case, it's prima.

Upgrading Primavera P6 17.7


You will have to enter your public login information.

Upgrading Primavera P6 17.7


Then you should be ready to go!

9 Upgrading PrimaveraP6 17.7


 Upgrading the Primavera P6 Database


Select Upgrade an existing database.

Upgrading Primavera P6 17.7


Type in your database connection information.

Upgrading Primavera P6 17.7


Put in your Administrative user name and Administrative user password.

Upgrading Primavera P6 17.7


You will need to create a new keystore password here.

Upgrading Primavera P6 17.7


Type in the user names and passwords for each user.

Upgrading Primavera P6 17.7


Now you can upgrade your database.

Upgrading Primavera P6 17.7


Upgrading Primavera P6 17.7

31 May 2017

Primavera P6 UDFs are a Breeze with the P6-Loader

Written by Nicole Jardin - CEO

UDFs - Making Sure They are Clean


When working with a client to setup cost controls in P6, we were working with budgets, estimates, work in progress, incurred to dates etc. These required a lot of User-Defined Fields in P6 to make sure we were able to cleanly track all the values we were pulling from the disparate systems from accounting to spreadsheets.

As a contractor, we were planning to track both the costs of the project delivery and the sale to the client. This way we could also report on profit margins and markup.


22 May 2017

A Simple How To Guide on Scripting with the P6 API

Written by Ravi Wallau - Integration Specialist

A Technical Example Demonstrating What you can do With the P6 API

If you are a Java programmer, or if your organization has a Java programmer who is eager to learn about the Primavera API, there is a world of possibilities about what you can do with your P6 database. The P6 API is a powerful solution that lets you interact with the P6 database from a Java application.


04 May 2017

P6 Baseline Changes in Version 15.2 and Above

Written by Nicole Jardin - CEO

Baseline Moved to Job Services

When I added my first baseline in 15.2, I uttered a few choice words because they were not working!


I could not see my baseline, it was not doing anything and I was getting a bit annoyed to say the least. I could not understand what was going on, I mean baselining is not a new thing in P6. So before you panic and get worked up like I did, you need to know that Primavera has made a technology change here.


01 May 2017

Poorly Named Data Elements in Your P6 Global Dictionary Causing Confusion?

Written by Iryna Mykolayenko, PMP - Implementation Specialist

A Project Code Called EPS!

Project codes in the global dictionary are an important part of an organization's enterprise data in P6. Needless to say, keeping this dictionary (as well as other global data dictionaries) clean and well-organized is an essential task for the application administrator, as well as for other admin superusers. Incorrectly named project codes and project code values result in confusion and translates into unproductive time for the users, which ultimately results in losses for the company. 


11 April 2017

Chasing Down Logic in P6? Trace Logic to the Rescue

Written by Mary Lynn Backstrom, PMP – Implementation Specialist

When trying to work through a large schedule and trying to understand the sequence of work, what tools can help make sense of multiple paths?


This is a question I have addressed numerous times in training classes and at client sites when building huge turnaround schedules with the planning team. In days gone by (P3 days) , we used to print trailer walls full of these logic diagrams. I am talking about 30 feet long by 10 feet high easily.


But with trace logic, we can do a lot of troubleshooting without killing so many trees.


27 March 2017

Saying Goodbye to Expedition 8.5 and Hello to Unifier - Part 2

Written by Ian Nicholson - VP Solutions, Ravi Wallau - Integration Specialist

A Case Study From A Technical Perspective

Alberta’s Capital Health was a big user of Expedition from the 1990’s through to 2010. They had hundreds of projects that were sitting on a Sybase SQL-Anywhere server that needed to be retired but they needed to have easy access to the documents related to these health care projects.


Emerald solved their problem using the PCM-Archiver. This PCM add-on tool automates the extraction process of all projects and documents, and in this case, ultimately saved the client approximately 140 hours of computing work. For a more in-depth understanding of this project and its results please refer to Part 1 of Saying Goodbye to Expedition 8.5 and Hello to Unifier. In Part 2 we are going to explore a more technical perspective including some of the bumps we experienced along the way of extracting 1,213,318 documents, generating 1,123,318 Excel files, generating links for 39,384 attachments and generating 91,236 PDF files!

20 March 2017

Team Member Error - "Current Timesheet Period Does Not Exist"

Written by Dan MacMillan - Integration Specialist

How To Fix The Error in Team Member When Daylight Savings Time Kicks In

We recently turned our clocks forward an hour for the daylight savings adjustment. Today our users could not log into Team Member - they got an error indicating that the “Current Timesheet Period Does Not Exist”. What gives?

Team Member Error


15 March 2017

Saying goodbye to Expedition 8.5 and Hello to Unifier - Part 1

Written by Ian Nicholson - VP Solutions, Ravi Wallau - Integration Specialist

A Case Study From A Functional Perspective

Primavera Expedition, now known as Primavera Contract Management (PCM), was a great tool in its day, and still is as PCM. We had a number of clients who ran their entire capital program on the tool with hundreds of large and small projects.


Now that PCM is moving into the extended support phase, how do you get years of data out of the system and preserve it for future reference?


PCM Archiver

14 March 2017

What's New - Unifier v17 SaaS

Written by Nicole Jardin - CEO

A few weeks ago CEGBU released a new version of Unifier in their SaaS Cloud. This is their new release strategy with monthly releases in the cloud and yearly releases for on-premise.


13 March 2017

What's New - P6 v17 SaaS

Written by Nicole Jardin - CEO

A few weeks ago, Oracle CEGBU (Primavera) released P6-EPPM in their SaaS Cloud. This is part of their new release strategy for their SaaS Cloud of monthly releases while on-premise releases will be switched to yearly only.

07 March 2017

Primavera P6 Resource Leveling - Too Complicated? No Way!

Written by Nicole Jardin - CEO

In reading a P6 setup recommendation document for one of our IT program clients I almost fell off of my chair when I saw the recommendation for resource leveling. It said not to use resource leveling as it introduces too many variables into the scheduling process. For an IT group not to be using resource leveling in a program is crazy!


Believe it or not, we see this advice suggested a LOT.

27 February 2017

Save 5 Minutes Every Time You Cancel an Activity in Primavera P6

Written by Sue Hopkins - Implementation Specialist

Whenever we have a client that is interested in TAPS, we always get the question about how an activity is updated to reflect that it has been cancelled. So, how does TAPS cancel activities?


Cancelled work is work that you have decided not to perform. Typically the turnaround (TA) team doesn’t want to delete the activity because that would change the baseline hours. On the other hand, they also don’t want to progress the activity which would earn hours.

21 February 2017

Primavera SaaS Cloud vs On-Premise - 2017 New Upgrading Models to Consider

Written by Nicole Jardin - CEO

Penguin Looking To The Cloud

We are working with a client who have been on the Primavera SaaS cloud for awhile and are now getting serious about migrating their dispersed team to the Oracle Primavera SaaS cloud for their P6 users. We are helping them with this process using our P6-Loader for P6 v16.2 in the cloud. We wanted to go with P6-EPPM version 16.2.3, since it has some crucial patches applied to it in the last 3 months and seems to be stable.


Then we get the news we were dreading, no you can't get that version you must upgrade to version P6 17.1? So we went to Oracle e-delivery to download P6 17.1 and guess what? It is not even released for on-premise use. So what is going on?


We had heard rumors that the upgrade model in the Primavera SaaS Cloud was going to change, but did not want to believe them. Now we cannot ignore them anymore.

13 February 2017

The Fastest Way to Cancel Activities in Primavera P6

Written by Mary Lynn Backstrom, PMP – Implementation Specialist

Automate the Process of Updating Cancelled Activities in Primavera P6 with our Barcode Updating Technology

When planning a turnaround project you want to make sure you include all the tasks that will happen and even those that might happen. This is a great strategy in the planning phase because during the actual turnaround, you don't have time to add all of the “potential” activities that become necessary.


Now the dilemma becomes, how to cancel the tasks that your team doesn't need after all.


You could process the updates for cancelled activities using manual data entry, dealing with logic, manhours, and baselines, but if you handle a lot of these it becomes time consuming, tedious and frustrating. Lets face it, during a Turnaround that is just not a good idea. You might think that dissolving is good enough, but is it?


[12 3 4 5  >>