OIC - Use of Javascript in Integration | Add two numbers to keep fixed decimal positions

Usecase: Convert 2 numbers and rounding the numbers to keep only three decimals.

Step 1 : Create .js file and import in Libraries

add2NumbersTest.js

    function addTest(num1,num2){

    var newNum;

    var newNum2;

    newNum = parseFloat(num1) + parseFloat(num2);

    newNum2= newNum.toFixed(3)

    return newNum2;

    }

Import Navigation:

Integrations--Libraries--create--choose File --provide library name--create--select function--save

Step 2 : Create an Integration and use the javascript action and test it.

I have created a simple REST trigger connection and created an app driven Orchestration integration and in the REST trigger, I have added relative URL as /addTwoNums, Verb as POST, Configure following two options:

Configure a request payload for this endpoint

Configure this endpoint to receive the response

Input:

{

"num1":123.34567,

"num2":234.34455

}

choose Json as response payload type and  provide inline Json sample

{

"result": "234.56"

}

Add Javascript action and choose the created JS function. and map the two inputs with num1 and num2.

Last map the JS response with the output of the rest service.

Add Tracking and test

Shell script to move files older than 10 days

A small script to move file from one directory to another.

step1: Create a file with name file_move.sh

    for i in $(find  absolute_path_from_move -type f -name "*"  -mtime +10 2> /dev/null);

    do

    mv $i archive_path;

    done

step2: execute with Command 

    sh -x file_move.sh

OIC - Exception Handling

 OIC provides two out of the box features to handle exceptions.

• Scope Handler:

Scope is one of the out of the box activity allow you to bundle a set of activities which have their own variables, Faults and event handlers. In other words, scope allow you to handle error raised in IC. It is like as try and catch block in other programming languages as java, dotnet etc. every scope activity has their own fault handlers which is treated as catch block.

Click here oic-scope-level-error-handling for POC.

• Global Fault Handler:

The Global fault handler is super catch block which handle all the errors which are not supported by scope handlers. This functionality enables you to direct business faults to the caller or apply business logic before sending faults to the error handling framework. you can add fault handling to any integration type.

Click here oic-global-fault-handling-in-app-driven for POC.

OIC - Connectivity Agent part 2

 This includes:

• Pre-requisites for Connectivity Agent
• Download Connectivity Agent
• Install Connectivity Agent
• Start/Stop Connectivity Agent.
• Log files of Connectivity Agent

Pre-requisites for Connectivity Agent:

Download Connectivity Agent:

Step 1:

Go to the OIC Agents ⇾ Create Agent group ⇾ Provide Agent Group Name ⇾ create

Step2:

Next click the Download button ⇾ Connectivity agent and it will download oic_connectivity-agent.zip

 

Connectivity Agent Installation:

Here showing the installation in Linux system.

Step1: Java jdk 8 version should be installed.

export JAVA_HOME=/home/opc/java/jdk1.8.0_251

export path=$JAVA_HOME/bin:$PATH

java -version

java version "1.8.0_251"

Java (TM) SE Runtime Environment (build 1.8.0_251-b08)

Java HotSpot (TM) 64-bit Server VM (build 25.251-b08, mixed mode)

Step2: unzip zip file

unzip oic_connectivity_agent.zip

ls -ltr

InstallerProfile.cfg

cpi_upgradeutility.jar

coonectivityagent.jar

agenthome

Step3: Provide OIC url and agent group name in InstallerProfile.cfg

vi  InstallerProfile.cfg

Put the following details:

oic_URL:https://host:port

agent_Group_Identifier: AGENT_GROUP

Step4:

java -jar connectivityagent.jar

proceeding to install a new agent

Enter your OIC username:

Enter password for user:

...

Done with Agent installation & Configurations... Starting Agent for message processing.

Agent started successfully...Now available for new message.

Now go to the OIC agents and see 1 connectivity agent is created under Agent_GROUP. If you go to the Monitoring agents, you will see the agent is active in green.

No go the linux page and ctrl +c to shutdown it. and you will see the agent in red monitoring agent.

To run the connectivity in background.

nohup java -jar connectivityagent.jar &

and also add the oic_user and oic_password in the InstallerProfile.cfg file.

oic_user=oicuser

oic password=welcome

Start/Stop Connectivity Agent:

Start:

nohup java -jar connectivityagent.jar &

Stop:

Go to agenthome 

cat pid

5160

kill -9 5160

Log files of Connectivity Agent:

cd agenthome/logs

ls -ltr

12c SOA Weblogic console - Database - shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory error

While one of the SOA external DB was upgrading to 19c, I have stumbled with this following error during the datasourse connection testing.

Test of WorkboothDB on server osb_server1 failed, reason:

Error Connection test failed with the following exception: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory

Solution:

This is because the Database instance name got changed. I have used the correct instance name and it got resolved.

OIC - Connectivity Agent part 1

 This includes:

• Connectivity Agent
• Agent types
• Connectivity agent architecture
• Agent in HA Availability
• Agent Group
• Connectivity agent constraints

Connectivity Agent:

• A connectivity agent or on  premise agent is a light weight component which solve the problem of cloud to on premise integration.
• The agent is required to exchange messages with on premises application such as database, Oracle E-Business suite, systems, Applications and SAP products, Ariba etc. 
• This CA can be installed behind the firewall to access on-premises applications.

Agent Types:

• Connectivity agent
• This is the intermediate gateway which provides a connection between SaaS and on-premises application or vice-versa.

• Execution agent
• This is self-managed instance of OIC help to connect applications within the organizations that enable secure integration between these systems residing on premise.

Connectivity Agent Architecture:

• The agent work as a bridge between OIC and On premises applications and without that communication is not possible.
• The OIC does not send any request to CA but CA does this job. Agent sends his heartbeat signals to Oracle Integration regularly to tell that I am live to serve your requests. In addition, to that agent regularly poll for design and run time work on which agent need to act upon.
• Design time work includes set of activities like Test connection, activation or deactivation of integrations.
• Same ways there are run time activities on which agent need to act upon. For any communication between integration cloud and on-premises systems such as Databases, EBS etc.

Agent Group:

• An agent group is a unique identifier which comprises multiple connectivity agents.
• You must create a agent group in OIC before you can run the connectivity agent installer.
• For a single oracle integration instance, you can create up to 5 agent groups. If the limit exceeds, you will get error like "Max limit reached. Maximum 5 Connectivity agents can be added."

Connectivity Agent in HA :

To tackle the high traffic on a single connectivity agent, you can install Connectivity Agent in High Availability mode. you can associate max two agents with a single agent group and both the agents should run on different hosts. The HA mode ensures the transactions will continue if any of the agents goes down or any hosts becomes unavailable.

Connectivity agent constraints:

• 10 MB payload limit
• The OIC agent can handle payload in size which is less than 10 MB in a single transaction.
• 240 sec or 4 mins Timeout
• Every transaction sent out to the on-premises application via agent must be completed within 240 seconds.

OIC - create PGP key to use in FTP connection

Go to pgpkeygen and fill up few details like your name, email id and choose algorithm as RSA , key size as 4096 bits(more secure). expires and passphrase and click generate keys.

Now download the keys.

Downloaded private and public PGP key files: