Advertisements

Tag Archives: ICS

How to Enabled HTTP Debug Logs on ICS Agent

 

Steps to enable http debug logs at agent side for Troubleshooting:

 

Steps to enable http debug logs at agent side –

1. Go to agenthome/user_projects/domains/agent-domain/bin folder
2. Open setDomainEnv.sh
3. Modify JAVA_OPTIONS=”${JAVA_OPTIONS} ${JAVA_PROPERTIES}” to JAVA_OPTIONS=”${JAVA_OPTIONS} ${JAVA_PROPERTIES} -Dhttp.debug=true” and save the file
4. Stop the agent and restart the agent using startAgent.sh from agent installation directory

 

Thank you !!

 

 

Advertisements

Enable debug logs for ICS Agent

 

Enable debug logs for ICS Agent:

1. Open agenthome/user_projects/domains/agent- domain/config/fmwconfig/servers/AdminServer/logging.xml
2. Under loggers add a new logger as follows… e.g.
<logger name=’oracle.cloud.cpi.agent’ level=’TRACE:1’/>
3. Save and exit.
4. Restart agent for the new log level to take effect

Note: Once debug is complete please remove revert above changes to avoid debug log files getting filled.

 

Thank You !!

 

 

Cannot Activate Integration In ICS

 

 

ISSUE:

Unable to Activate Integration which connects to on premise DB in ICS

looks like the agent is not responding
The server logs shows that the request to activate is timing out at the
agent.

Caused by: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not
received within 120 seconds of wait interval.
at oracle.cloud.cpi.agent.transport.AQChannel.syncSend(AQChannel.java:336)
From customer update , i assume that the agent is shown as running in the
monitoring page .
SOLUTION:

Restart the Agent

ICS agent provide startAgent.sh and stopAgent.sh scripts to start and stop on-premises agent respectively. These two script resides inside the folder where we have installed the Agent.

If you required to set the java home then,
Set JAVA_HOME using export JAVA_HOME=

Stop ICS Agent:
———————-

1. Login into the host machine where we have installed ICS agent
2. Move to the directory where ICS agent has been installed and see the files under this
3. See stopAgent.sh exist in the directory. Hit the below command to start ICS agent
./stopAgent.sh
4.Make sure server stop with a successful message

Start ICS Agent:
————————
1. Login into the host machine where we have installed ICS agent
2. Move to the directory where ICS agent has been installed and see the files under this
3. See startAgent.sh exist in the directory. Hit the below command to start ICS agent
nohup ./startAgent.sh -u=test@test.com -p=TEST@123 &

Where: -u= {User Name of ICS console} and -p={Password of ICS console}

4. As nohup command is used to start agent. Agent will be start in background. To see the output use below command
tail -500f nohup.out

5.Make sure server starts with a successful message

Thank you !!

 

DB Timeout Issue In ICS

 

 

Call PLSQL from ICS DB adapter, if ICS to DB calls take more than 240 seconds it will timeout at ICS.

Can we increase this value to some value higher?

Solution:

Timeout can not be changed. It is set to 240sec.
If you are still getting timeout, then we need to find out what is the root cause of Agent timeout. Agent logs should contain information on communication status between ICS and agent, and trace of DB requests processing.

 

Thank you !!

 

ICS Connection Count

 

 

ICS Connection Count (Doc ID 2385409.1)

How many connections will be considered from an ICS licensing Point of view?

 

A ‘Connection’ identifies a connection from an instance of ICS to a unique end system/application.
If, for example, a customer has number of WSDLs, but they all point to the same base URI, this would constitute 1 ICS connection. The following are the other rules when it comes to considering if two endpoints are considered the same connection or not.

– 2 different adapter types used to connect to the same instance of the application would be considered 2 different chargeable connections (e.g. using EBS Adapter and the Database Adapter to talk to the same EBS Instance is considered two connections)

– Different pillars/modules within an App (e.g. ERP) would still be different chargeable connections. e.g. ERP Financials would be one, ERP SCM would be second, ERP Projects and so on…, even if they are a single GSI instance.

– ICS-to-ICS is free (Daisy chaining integration). This includes invocation of ICS Flows on other ICS Instances.

– In Pub/Sub flows, Publishing or subscribing actions are not considered additional connections.

– Inbound (local) SOAP or REST connections counted as separate connections as well

– Connections are always chargeable – used actively in integration or not.

 

 

ICS Integration Not Working

 

 

ICS Integration Not Working (Doc ID 2340114.1)

Integration between Oracle Sales Cloud and Oracle service cloud – After adding the CSF Key, no instance is created in ICS.

User from ICS connection was not defined in ICS

After creating the user in ICS, the flow worked

To implement the solution, please execute the following steps:
1. Go into MyServices console
2. Navigate to Users
3. Create new user with the username defined in the ICS Connection
4. Change the password to the one used in the ICS Connection and csf-key

5. Retest

 

ICS: Which Bugs Are Fixed In 18.3.3

 

 

Useful Oracle Document:

ICS: Which Bugs Are Fixed In 18.3.3? (Doc ID 2425178.1)

ICS 18.3.3 Bug Fixes

1. Bug 27903791 – Consider User specified/Default Timezone in Preferences while running Scheduled Orchestrations

2. Bug 27362036 – Design-time Performance Improvements while working with very large Integrations

3. Bug 28316295 – Two Way SSL Support in REST Adapter

4. Bug 28308929 –  Gzip Support in FTP Adapter

5. Bug 28274350 – Enable User to specify Schedule Parameter with or without quotes

6. Bug 28266402 – Retain state of the schedule when importing a schedule driven integration flow into OIC from ICS

7. Bug 28266395 – Payload Trace/Logging setting not being honored when activating an integration flow with a new minor version

8. Bug 28246985 – Changing the Security type after Importing an Integration with REST/Oauth Client credentials based Connection does not work

9. Bug 28168603 – On execution of a outbound SAP Adapter flow using IDOC interface,TID is not being returned in response.

10. Bug 28164267 – Unintended line breaks introduced at runtime in payloads when using literal result element based mappings in the Mapper

11. Bug 28127472 – ERP Adapter design-time throws “The application has encountered an unexpected error”

12. Bug 28032110 – Audit trail of Global fault displays ‘Resource messageID ‘UF_NAME_EH’ not found in resource bundle EhStop’ when Database down

13. Bug 28025831 – Misleading Alert Notifications strongly advising the user to initiate manual purge of the data

14. Bug 28017414 – Handle Exclamation characters in JSON Keys in JSON samples

15. Bug 28011838 – Issue Consuming ICS Integration with complex request payload from PCS

16. Bug 28325374 – Do not mask the underlying errors when returned to caller in Lookups

17. Bug 27932827 – Updated values in Lookups not reflected at runtime due to Cache issues

18. Bug 28082314 – Unable to find the Lookup due to MDS Issues

19. Bug 28181446 – REST API call to Fusion Applications fails with SSLException

 

Thank you !!

 

 

Sample Integration with OTM/GTM using ICS

 

 

Useful Oracle Document:

Sample Integration with OTM/GTM using ICS (Doc ID 2209248.1)

 

As of version 16.4.5, Integration Cloud Service (ICS) includes a Logistics adapter that can be used to integrate Oracle Transportation and Global Trade Management versions 6.4.2 and later with other products. This document provides sample integrations that illustrate how Oracle Transportation and Global Trade Management might be integrated with Product Hub Cloud, Order Management Cloud, and Inventory Management Cloud through ICS.

 

Thank you !!

 

 

 

 

java.net.SocketException Unexpected end of file from server – An error occurred while invoking the target REST endpoint – ICS

 

ICS runtime execution error</summary></part><part name=”detail”><detail><detail><errorCode>OSB-380001</errorCode><ICSfaultVar/><reason><genericRestFault><errorCode>REST_CLIENT_RES_ERR</errorCode><errorPath><![CDATA[An error occurred while processing the client response from the target REST endpoint.]]></errorPath><instance><![CDATA[Target REST endpoint’s response processing failed.[[java.io.IOException: Premature EOF]]]]></instance></genericRestFault>

 

Calling One integration from Another integration through REST API fails with error
“Generic Rest Fault, unexpected end of file from server”

An error occurred while invoking the target REST endpoint

Issue is due to the child integration takes long time to finish and parent integration is timing out. To address issue, invoke child integration either one-way  or Asynchronously which will help address the issue.

In case still issue exists, please contact Oracle Support.

 

Thank you !!

 

 

 

 

Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body has been invalidated – ICS Integration Failed

 

 

ORA-04068: existing state of packages has been discarded

Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package “XXX” has been invalidated

ORA-04065: not executed, altered or dropped package “XXXXX”

ORA-06508: PL/SQL: could not find program unit being called: “XXX” ORA-06512: at line 1

 

Recompilation is resulting in invalidation of packages by database for existing database sessions related to ICS.

Avoid recompilation of packages during the working hours and plan such all migrations at once during the weekend.

Hope next execution of ICS integration run should be fine, if not, restarting Agent is the solution at the moment or contact Oracle Support.

 

Thank you !!