How to look default EPS or Activity view assigned to user using SQL Query – Primavera P6/Oracle

How to look default EPS or Activity view assigned to user using SQL Query - Primavera P6/Oracle   Some times, Primavera P6  users does not see the EPS or Activity page . The reason is not because of the browser or java applets. The EPS/Activity View or filters in the view has got corrupted. The [...]

By |2020-03-10T10:42:26-05:00March 10th, 2020|Categories: P6|Tags: |Comments Off on How to look default EPS or Activity view assigned to user using SQL Query – Primavera P6/Oracle

How to read all modules assigned to user from Primavera P6 database

How to read all modules assigned to user from Primavera P6 EPPM database   Login to ADMUSER schema and run the following query to get the user_id    select user_id from admuser.users where user_name = ?           2.  Pass the User ID to the below query to get the assigned modules  [...]

By |2019-11-21T12:23:37-05:00November 21st, 2019|Categories: P6|Tags: |Comments Off on How to read all modules assigned to user from Primavera P6 database

How to select all the OBS assigned to User from the database in Primavera P6

How to select all the OBS assigned to a User from the database in Primavera P6 EPPM     Login to ADMUSER schema and run the following query to get the user_id    select user_id from admuser.users where user_name = ?            2. Login to ADMUSER schema , pass the USER_ID  [...]

By |2019-11-21T12:09:41-05:00November 21st, 2019|Categories: P6|Tags: |Comments Off on How to select all the OBS assigned to User from the database in Primavera P6

How to export Primavear P6 admin_config table using SQL Developer and import using SQLLDR

How to export Primavear P6 ADMUSER admin_config table using SQL Developer and import using SQLLDR   I usually migrate Primavera P6 EPPM between environments by exporting  P6 EPPM schemes from the source  and importing to the target database. Once we migrated the Schemas to the target database, we need to open the P6 admin config [...]

By |2019-10-25T20:47:47-05:00October 10th, 2019|Categories: P6|Tags: , |Comments Off on How to export Primavear P6 admin_config table using SQL Developer and import using SQLLDR

P6 Classic EPS page not loaded: javax.net.ssl.SSLException: Received fatal alert: unexpected_message

Primavera P6 Classic EPS Page not loaded: javax.net.ssl.SSLException: Received fatal alert: unexpected_message   The Primavera P6 classic page ( Applets ) are not loaded after we updated to the Java 8 Update 171 . We got the below error in the Java Console    network: Connecting https://localhost:7002/p6/applets/projects.jar.pack.gz?version-id=16.2.0.0 with proxy=DIRECT network: Connecting http://localhost:7002/ with proxy=DIRECT javax.net.ssl.SSLException: Received [...]

By |2019-10-03T12:16:17-05:00October 3rd, 2019|Categories: P6|Tags: |Comments Off on P6 Classic EPS page not loaded: javax.net.ssl.SSLException: Received fatal alert: unexpected_message

How to count ADMUSER tables in Oracle

How to count Primavera P6 ADMUSER tables in Oracle    Counting ADMUSER table is helpful to find which tables holds large number of records. By this, we can truncate temp tables, and optimize other costly tables like remove wasted space, gather stats to improve the performance of Primavera P6 .    The below query list [...]

By |2019-09-10T11:02:57-05:00September 10th, 2019|Categories: P6|Tags: , , , |Comments Off on How to count ADMUSER tables in Oracle

How to Shrink ProjectSecurity Table in Primavera P6

How to Shrink ProjectSecurityTable in Primavera P6       The ADMUSER.PROJECTSECURITY table is one of the costly table in the Primavera P6 . Whenever The ProjectSecurity runs inside the P6 ( See Above) , the PROJECTSECURITY table size get increases. This causes increase in Wasted Space in the table-space . Soon this will cause [...]

By |2019-08-30T14:55:58-05:00August 30th, 2019|Categories: P6|Tags: , |Comments Off on How to Shrink ProjectSecurity Table in Primavera P6

How to turn Off the Global Scheduled Services through SQL Query in Primavera P6

How to turn off the Global Scheduled Services through SQL query in Primavera P6  In this section, we will see how to turn Off or On the following Global Scheduled Services through Oracle SQL Query      Log into ADMUSER account. The following query list the 5 Global Scheduled Services    select * from admuser.jobsvc [...]

By |2019-08-17T00:16:28-05:00August 16th, 2019|Categories: P6|Tags: |Comments Off on How to turn Off the Global Scheduled Services through SQL Query in Primavera P6

How to disable Primavera P6 admin config or Application settings from user

How to disable Primavera P6 admin config or Application Settings from User   Primavera P6 admin config is one of the powerful area which allows the user to change the P6 database setting, Authentication, Configuring LDAP, BPM & BI Integration Settings, Configuring P6 Web Service & P6 API, Daylight setting and much more. A change [...]

By |2018-05-07T22:52:11-05:00May 7th, 2018|Categories: P6|Tags: , , |Comments Off on How to disable Primavera P6 admin config or Application settings from user

About Primavera P6 Jobs, P6 Job Server and P6 Services.jar

About Primavera P6 Jobs, P6 Job Server and P6 Services.jar   In Primavera P6, many of the functionality requires time to complete, say more than 8 seconds. Oracle Primavera predefined these types of long-running functionality as a job which runs in the background. For example, copy and paste Projects. The time required to copy, and [...]

By |2018-02-25T23:19:10-05:00February 25th, 2018|Categories: P6|Tags: , , , |Comments Off on About Primavera P6 Jobs, P6 Job Server and P6 Services.jar