Posts

Posts

  • Moon Ray Lo
    Integration with HCM Extract Run & Retrieve Flow2
    Topic posted December 15, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, API, Cloud, Connection, Database, Integration, Mapping, Orchestration, PaaS, SAP, SOAP, Web Services in Integration > Integration public
    Title:
    Integration with HCM Extract Run & Retrieve Flow
    Summary:
    This is to take note the best practices to observe when integrating OIC with HCM's Extract Run-Retrieve Flow
    Content:

    Hi Team,

     

    I'd like to ask for inputs from the group with regards to integrating HCM's Run-Retrieve Extract Flow with Oracle Integration Cloud. I have attached the sample OIC flow (initial design) we've come up with. Here are the requirements:

    1) Integrating HCM Core HR Data through Extract with SAP Payroll

    2) Sending data every 10minutes (OIC's limit for scheduled integration) from HCM to SAP for data synchronization.

    3) Extract Data sent are 'Changes Only' data, we are only sending changes in HCM to SAP within the 10-minute period (not master data).

     

    The attached initial design works fine for above requirements, as far as we've tested it (unfortunately we only have few test data available as of this writing). But there are still concerns though and I'd appreciate any inputs from the group to enhance the design:

    1) What if we process a full, master data extract run and takes longer time than the current delta-only run? (Will it raise timeout issue on OIC side? What's the runtime limit on OIC for every integration run?)

    2) Anyone have tried the callback option for SOAP WS? How does it work for Extract RunRetrieve Process?

     

    We want to consider a design that can handle both master and delta-only extract data in OIC. Appreciate all your inputs.

     

    Thanks ahead,

    Moon

    Image:
  • John Graves
    OIC 18.3.5 - JMS Adapter 18.1.5 - Consumer - Managed Server...2
    Topic posted October 17, 2018 by John GravesSilver Trophy: 7,500+ Points, tagged Adapters, Agent, Integration in Integration > Integration public
    Title:
    OIC 18.3.5 - JMS Adapter 18.1.5 - Consumer - Managed Server issue
    Summary:
    Having issues using the JMS adapter (via connectivity agent) to connect to queues on managed servers.
    Content:

    Having issues using the JMS adapter (via connectivity agent) to connect to queues on managed servers.

    It works fine when connecting to queues on admin server.

    When connecting to queue on Admin server, I get a 'good' message in the agent log
    ----------------------------

    [2018-10-18T01:21:43.912Z] [INFO] [ThreadID: 63] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** ICS jmsCmd: getJMSDestinationTargetUrl 
    [2018-10-18T01:21:43.913Z] [INFO] [ThreadID: 63] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection params - 100.65.4.46 **** 7001 **** weblogic 
    [2018-10-18T01:21:44.077Z] [INFO] [ThreadID: 63] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection Url - t3://100.65.4.46:9071; 
    

    ----------------------------

    When I try to connect to a queue on a managed server I get a 'bad' or empty message in the log

    ----------------------------

    [2018-10-18T01:24:16.134Z] [INFO] [ThreadID: 92] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** ICS jmsCmd: getJMSDestinationTargetUrl 
    [2018-10-18T01:24:16.135Z] [INFO] [ThreadID: 92] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection params - 100.65.4.46 **** 7001 **** weblogic 
    [2018-10-18T01:24:17.156Z] [INFO] [ThreadID: 92] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection Url -  
    

    ----------------------------

    -John

    Version:
    18.3.5
  • Christopher Maggiulli
    Error connecting to application running on-premise, on same...25.0
    Topic posted August 5, 2018 by Christopher MaggiulliSilver Crown: 22,500+ Points, tagged Adapters, Agent, Cloud, Connection, Integration, REST, SOAP in Integration > Integration public
    Title:
    Error connecting to application running on-premise, on same box as connectivity agent
    Content:

    OIC version 18.3.3 (but occurred in 18.3.1 and 18.2.4 as well)

     

    We have a dedicated RHEL 7 box that our production on premise connectivity agent runs on.  However, the connectivity agent for our test environment does not have a dedicated box, and is running on a RHEL 7 server that also hosts the test environment of a coldfusion application that we integrate with through the rest and soap adapters.  In other words I'm trying to create a rest connection with the on premise connectivty agent, and the connection is to the same box the on premise connectivity agent runs on.  Every time I attempt to test the connection it fails saying connection refused.  I've tried the following

    http://test.vikingdatabase.net (internal dns name which works from the production on prem agent)

    http://127.0.0.1

    localhost (wont event let me enter that)

    945575-VikThorDev.pacific.lathamint.com

     

    All say connection refused.

     

    The coldfusion application is internal only.  The application server runs on port 8500 but all connections go through an apache web server running on port 80.  If I enable local access to port 8500 through iptables (its disabled by default except when the request are routed via mod_jk) it works. However I do not want to bypass the apache webserver since that is not how we do any of our integrations nor is it how we do it in production (the test and production set up are identical. Only different is we have the connectivity agent rujnning on the test box, whereas in production it has a dedicated box).

    I've also tried using http://test.vikingdatabase.net:80 but that refuses the connection too.

    I know that the on premise connectivity agent is not running on port 80 so I don't get what the conflict is about (although I havent really looked at the diagnostic log).

    Is there any way to get around other than spinning up a dedicated box for the test environments on premise agent?

     

    Also, as a second question, I have tables created in the DBaaS that is used by ICS.  If I want to integrate with those tables, should i run another connectivity agent on the database box, or should I just use APEX?

     

  • Christopher Maggiulli
    MySQL adapter cannot connect (needs JDBC jar?) Using...Answered25.0
    Topic posted March 19, 2018 by Christopher MaggiulliSilver Crown: 22,500+ Points, tagged Agent, Connection, Database in Integration > Integration public
    Title:
    MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agent
    Summary:
    MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agent
    Content:

    I have an OIC instance with an On-Prem adapter installed within my firewall.  The On-Prem adapter works when I use the various REST and SOAP connections.  However when I set up a connection using the MySQL adapter it fails to connect, saying that I should check the com.jdbc.myswl.driver.  Following that advice I SHH'd into the box and found where location of the driver's for the weblogic server. I see the MySQL connector/j driver is already present (additionally, it already says pre installed on the GUI (underneath the adapter)). I verified that I can access the MySQL box from the box the on prem agent is installed on. The log files do not say anything interesting beyond "cannot connect" and to check if the jar driver is installed.  Does anyone have any thoughts?

  • Chetan D
    EBS Download Agent for trial cloud account not...25.0
    Topic posted March 19, 2018 by Chetan D, tagged Agent, E-Business Suite in Integration > Integration public
    Title:
    EBS Download Agent for trial cloud account not enabled(Currently, downloading Connectivity Agent is not supported. Please contact oracle support to download agent. )
    Summary:
    EBS Download Agent for trial cloud account not enabled(Currently, downloading Connectivity Agent is not supported. Please contact oracle support to download agent. )
    Content:

    Hello Experts,

     

    We have bought a trial cloud service account in which we are trying to use OIC to integrate with EBS on-prem.

    But currently the download Agent is not allowing to download and raised the SR also but as per the oracle support they dont support the trial account for both subscription and technical issue and informed to contact the Forums.

    So not sure if anybody has faced the same issue and what is the process of getting the download agent.

    We get the below message when clicked on download agent

    "Currently, downloading Connectivity Agent is not supported. Please contact oracle support to download agent. "

     

    Thanks

    Chetan

  • SM
    starting Oracle ICS agentAnswered25.0
    Topic posted February 14, 2018 by SMBlue Ribbon: 750+ Points, tagged Agent, Integration in Integration > Integration public
    Title:
    starting Oracle ICS agent
    Summary:
    starting Oracle ICS agent
    Content:

    Hello,

     

    How can we start the Oracle ICS agent in the background, passing along with the connection parameters?

     

    The document (E85413-03  January 2018), I am following doesn't have any information as such about starting the agent in the background. Please advice.

     

     

    $java -jar connectivityagent.jar

    Proceeding to install a new agent ...

    Enter your OIC username : abc@xyz.com

    Enter password for abc@xyz.com :

     

     

    Thanks!

  • logu Prasanth
    Error : While running the integration i am getting Error...1
    Topic posted July 16, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Agent, Connection, E-Business Suite, Integration, Mapping, Orchestration, PaaS, Process, REST, Web Services, xml in Integration > Integration public
    Title:
    Error : While running the integration i am getting Error "No response received within response time out window of 240 seconds"
    Summary:
    No response received within response time out window of 240 seconds
    Content:

    While running the integration i am getting Error "No response received within response time out window of 240 seconds

    oracle.cloud.cpi.agent.transport.aq.CpiAQException: No response received within response time out window of 240 seconds. Agent may not be running, or temporarily facing connectivity issues to Oracle Integration Cloud Service. Please check the health of the Agent in Agent Monitoring page.:Application Error

    Is there any possibilities to increase the time out error time in OIC?

     or this 240 seconds is fixed?

    Thanks in advance

    Regards,

    -LP

  • Carlos Toso
    OIC Agent consume bandwith15.0
    Topic posted May 27, 2019 by Carlos Toso, tagged Agent, Cloud, Integration in Integration > Integration public
    Title:
    OIC Agent consume bandwith
    Summary:
    How Much Bandwidth Does Agent Need to Communicate to OIC
    Content:

    Hi all, I am looking for documentation about How Much Bandwidth Does Agent (on premise) Need to Communicate to OIC. Please any comments or documentation about this is welcome.

  • Russell Cormier
    When I try to create a connection in ICS, it is necessary to...1
    Topic posted May 17, 2018 by Russell Cormier, tagged Agent in Integration > Integration public
    Title:
    When I try to create a connection in ICS, it is necessary to install agent for which Admin privileges are required. How do obtain admin access?
    Summary:
    When I try to create a connection in ICS, it is necessary to install agent for which Admin privileges are required. How do obtain admin access?
    Content:

    How is admin privilege achieved to install an agent in ICS?  thx

  • Frank Brink
    Connection: The configure connectivity does not accept a...
    Topic posted October 22, 2019 by Frank BrinkRed Ribbon: 250+ Points, tagged Adapters, Agent, API, Connection, REST in Integration > Integration public
    Title:
    Connection: The configure connectivity does not accept a local swagger rest api icw an agent group
    Summary:
    How to setup a connection to a local REST api in combination with a running agent group
    Content:

    The following REST api url (swagger)

    http://localhost:8091/ords/hr_schema/open-api-catalog/empdep/ gives me all available methods for the empdep REST module in my browser

    If I use the same url within the REST adapter connection (in the configure connectivity section) the url is not accepted while explicitely using my earlier defined agent group

    Also the other options like "REST API" based are refused by the configure connectivity  

    If I setup my router using myipv4 and forwarding all requests (and leave the agent group blank) on port 8091 the configure connectivity is accepting the url

    http://Myipv4:8091/ords/hr_schema/open-api-catalog/empdep/ is accepted

    How to setup a connection to a local REST api in combination with a running agent group?