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

EDB Mailboxes to Office 365: Useful Tips by Experts

EDB Mailboxes to Office 365: Useful Tips by Experts For migration from on-premises Exchange Server environment to Office 365, administrators can migrate all mailbox items-emails, calendars, contacts, tasks to Office 365 with the help of Cutover, Staged, or Exchange-Hybrid migration methods. Exchange administrators can also use PowerShell scripts to convert mailbox data into PST format [...]

By |2019-11-21T06:15:32-05:00November 21st, 2019|Categories: Blog, Windows|Tags: |Comments Off on EDB Mailboxes to Office 365: Useful Tips by Experts

Ora-12505 – TNS Listener does not currently know of SID given in connection descriptor | Oracle XE | Localhost

Ora-12505. TNS Listener does not currently know of SID given in connection descriptor   Often Times I receive the following error on my Oracle XE database . This happens sometimes on reboot.    Status: Failure - test Failed: Listener refused the connection with the following error Ora-12505. TNS Listener does not currently know of SID [...]

By |2019-11-18T19:23:22-05:00November 18th, 2019|Categories: Oracle|Tags: , |Comments Off on Ora-12505 – TNS Listener does not currently know of SID given in connection descriptor | Oracle XE | Localhost

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 create maven build POM file for Oracle BPEL 12.1.3 project

How to create maven build POM file for Oracle BPEL 12.1.3 project   Before proceed to create POM file. We need to create Oracle SOA repository. The following command will create the repositotirs.    Assume the  Oracle BPM 12.1.3 installed on the directory C:\Oracle\Middleware\Oracle_Home   Set the following property    export M2_HOME=C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\org.apache.maven_3.0.5 export PATH=${M2_HOME}/bin:$PATH   [...]

By |2019-08-17T00:16:48-05:00August 16th, 2019|Categories: BPEL|Tags: |Comments Off on How to create maven build POM file for Oracle BPEL 12.1.3 project

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