Oracle Primavera - PM6

Description

Here's a place to discuss some Primavera Enterprise questions

Container
No

Unable to Import Excel file (.xlsx) in Primavera P6 Professional R16.2.0

I am trying to use a normal export and import function of P6. I exported the data into .xlsx format and I am trying to import the data back after minor edits , but its says "Process did not complete successfully. See log file for details" and the log shows as stated below:

 

Excel Import log started : 15-Mar-18

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts

Is it possible to export with unique and persistent task ID's

Hi! This is my first post.

I'm looking for any ID in the resulting exported (XER or XML or whatever) file.

An ID that uniquely identifies a task and that is "persistent".

I mean: in my tests I exported twice the same project.

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts

% complete Type for Milestones in P6

S
sam dsoza 👤 Member for 20 years

Good Evening

I use P6V8. The schedule I inherited has activties using "physical % complete" as most common way to status progress. So are milestones. 

As "activity percent complete based on activity steps" is checked at the project level, whenever I claim finish milestone, physical % complete shows 0% complete instead of 100%. This misleds foreman/engineers reading the schedule report who think planners missed to claim actual. 

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts

predecessor completion date and successor start date are the same

The predecessor completion date and successor start date are the same. For Example, if predecessor finishes on 04th Feb-18, 04:00 PM the successor start on 04th Feb-18, 04:00 PM instead of 05th Feb-18, 08:00 AM with 0 days lag.

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts

XER Import Error - Changing Version Not Working

When attempting to import an XER from a new version of P6 to the 8.4 version I have, I get an error stating, "The import file is invalid."

I have already changed the version number in notepad. This trick only works sometimes when I import files from new versions of P6. I would ask the scheduler to send a saved down version of the file but our GCs aren't always accomodating. Are there any other tricks I can try when this occurs? 

 

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts

Primavera Job Services ORA01017: invalid username/password; logon denied

I'm really struggling to run Primavera P6 Job services!

 

Primavera P6 17.12, 15.2 and 16.1 64 bit (tried all with no luck)

Database: oracle 11g 

JSDB alias is set with pubuser credentials.

When I start the Primavera P6 Job service (JDBC) it stops after 1-2 minutes. 

Windows event handler error: 

Failed to start Primavera Job Service:  PRM DBAccess Error: Connection attempt to database failed with message ORA-01017: invalid username/password; logon denied

I'm really stuck! 

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts

Standalone DB backup solution question

Evening

Just thought I'd better check - fairly new to P6 with a basic setup so I've simply enabled Windows' File History to backup the PPMDBSQLite.db to an external HDD on an hourly basis, thinking if there were any irretrievable mistakes, I could then use File History to restore the correct version and open P6 to find it recovered. 

If this works I'm happy to keep it like this, but if this isn't likely to work as a backup/recovery solution I'd need to know now.

Thanks for your help.

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts

Importing XLS Causing Resource Assignment Duplication

I'm exporting resource assignments from P6 to Excel, updating budgeted units, actual units, and at completion units, then importing and Excel sheet into P6. Once the import is complete, I noticed that the resource has been updated based on my import, and a second resorce has been added and given budgeted units based on units per time that do not match the updated resource. Can anyone give me some insite on what's happening here please? Thanks in advance. 

Forum Sponsor

Top Posters

James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts