We Caught Another Primavera P6 Bug
Bug 17904646 : DATA NOT REFRESHING FOR MULTIPLE USERS AFTER CHANGES COMMITTED TO DATABASE
One of our consultants who is currently loading large amounts of P6 data using Emerald’s P6 Loader came to me with a concern that there is sometimes a lag between loading information using our P6 Loader (via the API’s) and it appearing in P6, even if he repeatedly pressed the F5 (Refresh) key. The lag could be minutes or hours depending on the situation.
In attempting to resolve the issue, we checked all the common issues, such as whether the data was actually hitting the database (it was), whether the system was configured with grants to allow proper refresh performance (it was). It appeared that there was no reason for the lag to occur.
Then we checked the Oracle knowledgebase for the symptoms shown and we discovered that there is a known bug with P6 8.x that causes Refresh to not work correctly. The bug is covered under Oracle article: Bug 17904646 : DATA NOT REFRESHING FOR MULTIPLE USERS AFTER CHANGES COMMITTED TO DATABASE.
If you are using 8.x and refresh is not working for you, try closing and re-opening the project to get the changes to appear properly.
About the Author
Ian Nicholson, P.Eng. - VP Solutions
As our VP Solutions and a Lead Risk and Implementation Specialist, Ian leads Emerald’s functional consulting group. With over 20 years of international experience in varied fields and roles from manufacturing, heavy civil construction, pharmaceutical plant construction, hospital projects and oil and gas capital and turnaround projects, Ian brings a wealth of project knowledge to all of our clients.
A visionary in the world of CAPEX, maintenance and turnaround planning processes, Ian has lead many of our large clients through their integration projects between ERP/EAM systems and Primavera products. Some of his integration success stories include Suncor Energy SAP to Primavera integration, BP Maximo to P6 integration, implementation of P6 at the Ontario Power Authority as well as the integration of Primavera Contract Manager with Oracle Financials at Capital Health Authority and Vancouver’s Rapid Transit Project 2000. Other major clients include Milwaukee Metropolitan Sewerage District, Shell Canada and Shell Global Solutions.
Ian has conducted Monte-Carlo risk analysis on CAPEX and turnaround projects for Shell Canada, Suncor Energy, Husky Energy and Bruce Power. He believes that successful Monte Carlo application is a process, not just a tool and has spoken at a number of events on the correct application of risk analysis.
When not assisting clients with their projects, Ian unwinds by riding his BMW motorcycle, listening to music or dragging his kids on long hikes.
