Home » Other » Suggestions & Feedback » Primavera PPM & EPPM FAQ
Primavera PPM & EPPM FAQ [message #621266] Tue, 12 August 2014 04:29 Go to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
I will be using this topic to create the Primavera PPM & EPPM FAQ.


Edited by Lalit : Updated topic title as per the forum title.

[Updated on: Mon, 22 September 2014 06:34]

Report message to a moderator

Re: Primavera PPM FAQ [message #621689 is a reply to message #621266] Sat, 16 August 2014 08:50 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
1. Always post the poduct details in the topic title as PPM/EPPM.

Oracle Primavera products are available in two forms i.e. client and web, relating to PPM and EPPM respectively.

[Updated on: Sat, 16 August 2014 08:50]

Report message to a moderator

Re: Primavera PPM FAQ [message #621690 is a reply to message #621689] Sat, 16 August 2014 08:59 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
2. Always provide the product name and version details.
Re: Primavera PPM FAQ [message #621692 is a reply to message #621690] Sat, 16 August 2014 09:20 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
3. Always provide the DB name and version.

W.R.T. points 1, 2 and 3; please mention it in topic details.

For example : EPPM P6 8.3 Oracle 11.2.0.4


Edited by Lalit :

This will be considered as single point, to make it easier to understand I am mentioning the first point below :

1. Always post the following information in the topic title :

  • Product details - Oracle Primavera products are available in two forms i.e. client and web, relating to PPM and EPPM respectively.
  • Product name and version details.
  • DB name and version - Oracle Primavera products are available on two DB platforms, Oracle and SQL Server.


For example : EPPM P6 8.3 Oracle 11.2.0.4

[Updated on: Mon, 22 September 2014 07:00]

Report message to a moderator

Re: Primavera PPM FAQ [message #621697 is a reply to message #621692] Sat, 16 August 2014 10:26 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Im my opinion, these 3 could/should be part of the same instruction. I don't see any reason to put them into 3 separate messages.
Re: Primavera PPM FAQ [message #621699 is a reply to message #621697] Sat, 16 August 2014 10:38 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
LF,

Yes, no doubt, these will be merged into one point. That's why I edited the third point and provided an example to make sure I myself remember to consolidate them as a single point.

Hopefully, this time it won't be that difficult to finalize the points, I have a bit of experience now with previous topic.
Re: Primavera PPM FAQ [message #621700 is a reply to message #621699] Sat, 16 August 2014 10:40 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LOL, me too!
Re: Primavera PPM FAQ [message #622040 is a reply to message #621700] Wed, 20 August 2014 10:54 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Above mentioned 3 points will be considered as 1st point in the FAQ. Need to be mentioned in topic title as an expectation.
Re: Primavera PPM FAQ [message #622041 is a reply to message #622040] Wed, 20 August 2014 11:00 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
2. I don't see the tables/views/other DB objects in my schema, why?

As what privilege did you login? There are 5 schemas created by default. Please mention the user you logged in as. Usually, users log in as "privuser" and run out of privileges to view DB objects. The administrator privileges are held with "admuser".

[Updated on: Wed, 20 August 2014 11:01]

Report message to a moderator

Re: Primavera PPM FAQ [message #622045 is a reply to message #622041] Wed, 20 August 2014 11:20 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
3. I am unable to use EXP/EXPDP utility to restore my Oracle DB

Please mention the product version and DB version. Older versions of the product, 8.1 and earlier are not compatible with EXPDP utility. If you using 8.1 or prior version of the product, use legacy EXP utility. And be advised, not all schemas would be restored.

Edit : Forgot to add the serial number.

[Updated on: Wed, 20 August 2014 11:27]

Report message to a moderator

Re: Primavera PPM FAQ [message #622048 is a reply to message #622045] Wed, 20 August 2014 11:31 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
4. I successfully exported the dump file, however, I see errors while importing the dump file

This question has two things. Export and import of dump file. For export see FAQ#3. While importing the dump file, look at the error, for example, if it says "privuser not found", you need to remove the respective schema from the EXP/EXPDP command.
Re: Primavera PPM FAQ [message #622052 is a reply to message #622048] Wed, 20 August 2014 11:46 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
5. I don't find the extended/new schema for batch jobs

Please mention the product version. If you are on 8.1 or prior version, you can't install it, that's the 5th default schema for versions 8.1 and above.

Edit : Once again I forgot to include the FAQ serial number.

[Updated on: Wed, 20 August 2014 11:48]

Report message to a moderator

Re: Primavera PPM FAQ [message #622247 is a reply to message #622052] Sat, 23 August 2014 10:51 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
6. I don't find ADMUSER schema

Which DB is it? If it is SQL Server, SA user/schema is precreated similar to ADMUSER in Oracle, however, it is explicitly created in Oracle. So use SA as username and the system password.
Re: Primavera PPM FAQ [message #623515 is a reply to message #622247] Thu, 11 September 2014 02:10 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
7. Why do I see junk values in my client.

For PPM users, that is probably because your client characterset doesn't match with database characterset. Do the following to check :

select value from v$nls_parameters where parameter = 'NLS_CHARACTERSET'; -- locale-specific characterset
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'; -- database characterset


If you see a mismatch between the two, then set the locale-specific characterset to that of database characterset.
Previous Topic: Formatting SQL
Next Topic: How delete owned topic
Goto Forum:
  


Current Time: Tue Mar 19 04:29:07 CDT 2024