Home » Applications » Primavera » Primavera PPM & EPPM FAQ
Primavera PPM & EPPM FAQ [message #624359] Mon, 22 September 2014 06:17 Go to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
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

Primavera PPM & EPPM FAQ [message #624360 is a reply to message #624359] Mon, 22 September 2014 06:17 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: Mon, 22 September 2014 07:01]

Report message to a moderator

Primavera PPM & EPPM FAQ [message #624361 is a reply to message #624360] Mon, 22 September 2014 06:17 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.

[Updated on: Sat, 26 January 2019 11:11]

Report message to a moderator

Primavera PPM & EPPM FAQ [message #624362 is a reply to message #624361] Mon, 22 September 2014 06:17 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.

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

Report message to a moderator

Primavera PPM & EPPM FAQ [message #624363 is a reply to message #624362] Mon, 22 September 2014 06:17 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.

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

Report message to a moderator

Primavera PPM & EPPM FAQ [message #624364 is a reply to message #624363] Mon, 22 September 2014 06:17 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.

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

Report message to a moderator

Primavera PPM & EPPM FAQ [message #624365 is a reply to message #624364] Mon, 22 September 2014 06:17 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.

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

Report message to a moderator

Previous Topic: P6 Primavera (SQL Server) -> RDS (AWS)
Goto Forum:
  


Current Time: Thu Mar 28 13:52:25 CDT 2024