catgovind

[catgovind]

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

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

    Export the ADMIN_CONFIG table 

  Open the SQL Developer and create connection to ADMUSER account where you want to export the ADMIN_CONFIG table . Below are my local ADMIN_CONFIG records I am going to export. As I highlighted below, This contains BLOB  data. 

      Click on the TOOLS, Database…

[catgovind]

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…

[catgovind]

How to count ADMUSER tables in Oracle

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 the number of records in each table in a particular schema. In this case, we are…

[catgovind]

How to Shrink ProjectSecurityTable in Primavera P6

How to Shrink ProjectSecurityTable 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, the PROJECTSECURITY table size get increases. This causes increase in Wasted Space in the table. Soon this will cause performance issue in P6 . Also, the Publish Security may got struck in RUNNING state all…

[catgovind]

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

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 where job_type in…

[catgovind]

How to schedule a Oracle BPEL process using Oracle Enterprise Schedule Service

How to schedule a Oracle BPEL process using Oracle Enterprise Schedule Service

How to schedule an Oracle BPEL process using Oracle Enterprise Schedule Service

  In my previous post, I have explained the installation of Oracle Enterprise Schedule Service. This post, I walk through on invoking an Oracle BPEL process every one-minute using OESS. Here below is my depleted sample Oracle BPEL composite that I am going to invoke. BPEL composite is exposed as Web Service. We need…

[catgovind]

How to install Oracle Enterprise Scheduler 12C

How to install Oracle Enterprise Scheduler 12C

How to Install Oracle Enterprise Scheduler  12C

  This post, I have explained the installation of Oracle Enterprise Scheduler12.1.3 on Windows machine. OES is used to create schedules like a UNIX CRON job in WebLogic server, For example, we can create a job that invokes a Webservice Or Java process every night. I often use Oracle Enterprise Scheduler to invoke Oracle BPEL process. It supports…

[catgovind]

How to reset ADF input File component

How to reset ADF input File component

How to reset ADF input File component

  In this section, we walk through how to reset ADF File component ad:inputFile

  1. Here below is the JSF page

[catgovind]

How to add a catch block on Oracle BPEL

How to add a catch block on Oracle BPEL #OracleBPEL @OracleBPEL

How to add a catch block on Oracle BPEL

  In Oracle BPEL, Select the scope you want to add a catch block. The below rectangular dotted line represents a scope. Also, you can drag and drop a scope activity to create a scope. Now click on the CatchAll or Catch as highlighted in the YELLOW color.

      I added a CatchAll block and I used an Exitactivity. The BPEL process will get terminated if it…

[catgovind]

How to Pass array of strings to a Field in Oracle BPEL

How to Pass array of strings to a Field in Oracle BPEL #OracleBPEL@OracleBPEL

How to Pass an array of strings to a Field in Oracle BPEL

  Here Below, I passed three string variable in one Field.

      Once the assignment is done, Click on the Source tab and input the argument bpelx:ignoreMissingToData=”yes” for all the copy tags where the array is mentioned like below.

  'name' $ReadProject.params/ns1:Field[1] 'Id' $ReadProject.params/ns1:Field[2] 'age' $ReadProject.param…

[catgovind]

Oracle BPEL For Each Activity Example

Oracle BPEL For Each Activity Example #OracleBPEL @OracleBPEL

Oracle BPEL For-Each Activity Example

  Oracle BPEL 2.0 supports For-Each activity. It is similar to a Java For loop. It requires a counter variable, Start value and Final value.

  For example, let’s implement the below Java For-Each in Oracle BPEL:

  Java for Loop:

  for(int i=0;i<100;i++) { }

  In Oracle BPEL:

  Open the BPEL process, Drop Oracle BPEL For-Each activityfrom component palette to…

[catgovind]

Oracle BPEL If then Else condition

Oracle BPEL If then Else condition

Oracle BPEL If then Else condition

  Oracle BPEL supports If-else statement. The Syntax is below, similar to Java. Only If is required on this conditional statement, Else-If and Else are optional.

  If(Condition=true){ } Else if (Condition=true){ } …. Else{ }

  To implement If-else in Oracle BPEL, Drag and drop the IF activity from the component palette to the BPEL. Click on the…

[catgovind]

How to create Oracle BPEL Subprocess, call a subprocess and pass variables

How to create Oracle BPEL Subprocess, call a subprocess and pass variables #OracleBPEL @OracleBPEL

How to create and call an Oracle BPEL Subprocess

  Oracle BPEL subprocess is like a method call in Java. It can be called by any BPEL process including another subprocess. Subprocess is like any other BPEL process, the only thing is it can be reused. This section, we walk through how to create a subprocess, Call Subprocess and pass variables.

  For instance, I want to send an email to the process…

[catgovind]

Oracle BPEL SubProcess Pass by value and Pass by reference

Oracle BPEL SubProcess Pass by value and Pass by reference

Oracle BPEL Subprocess Pass by Value and Pass by reference

  Oracle BPEL supports both the pass by Value & pass by referencewhen we pass variable to the subprocess. For pass a variable by reference, Just toggle off the COPY BY VALUE checkbox when calling a subprocess like below, that is if the content of the variable changed in the subprocess it reflects in the calling process. Toggle on the…

[catgovind]

How to count collection in Oracle BPEL

How to count collection in Oracle BPEL #OracleBPEL @OracleBPEL

How to count collection in Oracle BPEL

  The count() function in Oracle BPEL can be used to retrieve the number of nodes in the collection. The Syntax is count (node). The count function will return 0 if it is empty. For example, Below Is a sample web service response:

  <ACollection> <Project>….</Project> <Project>….</Project> <Project>….</Project> </ACollection>

  So, the count…

[catgovind]

How to create a Read-Only-User in Oracle WebLogic server

How to create a Read-Only-User in Oracle WebLogic server

How to create Read Only user in Oracle WebLogic Server

  1. Log in to WebLogic console as Admin user(User ‘WebLogic’); the URL looks like http://localhost:7001/console

  2. Click on the Security Realms > My Realms

    3. Create a user by clicking the NEW button (Or click on the existing user and go to Step 5 )

    4. Fill the fields for the new user

    5. Click on the user

    6. Click on…

[catgovind]

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

How to disable Primavera P6 admin config or Application settings from user @OraclePrimavera @PrimavearP6 #PrimaveraP6

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 in the P6 admin config affects the whole application. Suppose, if a…