Posts

Posts

  • 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?

     

  • Moon Ray Lo
    Downtime Handling in OIC35.0
    Topic posted August 3, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, Cloud, Connection, Database, Integration, Mapping, Orchestration, PaaS, REST, SOAP, xml in Integration > Integration public
    Title:
    Downtime Handling in OIC
    Summary:
    We encountered intermittent connection (2-3 minutes of random downtime) in OIC
    Content:

    Hi,

     

    We encountered intermittent connection (2-3 minutes of random downtime like service not accessible) with OIC, which happens a couple of times in a week. It may not sound a big deal, but this is concerning on a production system, that some integrations are unavailable on that instance (especially there are activities triggered).

    Aside from having error handling (integration level), can you suggest how to handle OIC downtime? I can see there's a 'Load Balancer' for every OIC service, any idea how to leverage on this context?

     

    Appreciate your inputs on this.

     

    Thanks,

    Moon

  • Thirunavukarasur
    OIC on-prim Agent performance improvement125.0
    Topic posted June 26, 2018 by Thirunavukarasur Bronze Medal: 1,250+ Points, tagged Agent in Integration > Integration public
    Title:
    OIC on-prim Agent performance improvement
    Summary:
    How to improve the performance of OIC on-prim agent
    Content:

    We have couple of integrations which times out intermittently and , any suggestion on  how to improve the performance of on-prim agent as well as OIC.  Thank you so much for the help.

    Thanks

    Ravi

  • Moon Ray Lo
    ICS: Agent not showing in DB Connection Agent Confguration...Answered45.0
    Topic posted June 25, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, Connection, Database in Integration > Integration public
    Title:
    ICS: Agent not showing in DB Connection Agent Confguration after installing the On-Premise Agent
    Summary:
    The agent is not showing in the 'Configure Agents' interface when doing DB Connection setup in ICS
    Content:

    Hi,

    We are using ICS Standard Edition, Version: 18.2.3.0.1 (180419.0000.1063).

    The connectivity agent group we created is visible in 'Agents' page, which has 1 newly linked Agent (ID: PLOACS.AGENT15700) as shown in one of the screenshot (ICS_AgentsList.JPG) after being installed on our server where the DB resides. I tried to create a DB Connection and when I scroll down and access the 'Configure Agent', it is NOT showing on the list as shown in one of the screenshots (ICS_DBConnection_NoAgentsFound.JPG). I have also attached the Agent Installation Log in case it might help. (LOG-cloud-connectivity-agent-installation.txt).

     

    Any idea what could have caused this issue to arise? or anything I missed to setup?

     

    Thanks,

    Moon

    Document:
  • Ritu
    OIC Connectivity AgentAnswered85.0
    Topic posted June 7, 2018 by RituBronze Medal: 1,250+ Points, tagged Agent, Connection, Integration in Integration > Integration public
    Title:
    OIC Connectivity Agent
    Summary:
    Coomunication and High Availability Details
    Content:

    Hi,

    Could anybody throw some light what exactly happens in the background when an OIC agent is installed ,how exactly it communicates with OIC instance and how does the agent ensures high availability.

     

    Thanks

  • Ritu
    OIC Integration Cloud:Connectivity Agent InstallationAnswered45.0
    Topic posted June 5, 2018 by RituBronze Medal: 1,250+ Points, tagged Agent, Integration in Integration > Integration public
    Title:
    OIC Integration Cloud:Connectivity Agent Installation
    Summary:
    OIC Connectivity Agent weblogic details
    Content:

    Hi,

    I had installed an OIC connectivity agent on another DBCS instance to do a quick connection testing with my IC home instance. The agent got successfully installed and reflected on the IC home.

    But after some time, the monitoring tab displayed the agent connection in red.When I tried to search the startAgent.sh file to restart the agent on DBCS instance, there was no such file.

    Can i not install OIC agent on DBCS?If yes, then how do i start and stop the agent if there is no domain created.

    Thanks

     

     

     

  • Tarun
    [SRC Class: oracle.cloud.cpi.agent.install.AgentInstaller;...35.0
    Topic posted March 31, 2018 by Tarun Red Ribbon: 250+ Points, tagged Agent, E-Business Suite, Integration in Integration > Integration public
    Title:
    [SRC Class: oracle.cloud.cpi.agent.install.AgentInstaller; Method: checkAgentGroup] Agent Installation Failed !!! Error Occurred while checking Agent group availability
    Summary:
    [SRC Class: oracle.cloud.cpi.agent.install.AgentInstaller; Method: checkAgentGroup] Agent Installation Failed !!! Error Occurred while checking Agent group availability
    Content:

    Hi Experts,

     

    We have installed the agent on EBS on-prem server and when we are trying to run the agent with the command we get the below error.

    Any pointers on this will help us

     

    -bash-4.1$ java -jar connectivityagent.jar

    Proceeding to install a new agent ...

    Enter your OIC username : ****

    Enter password for *****

    No Proxy Configuration Detected

    Checking for trusted certificates ...

    Making call to check OIC Version ...

    Making call to check Agent group availability ...

    Agent Group Already Contains Agent. Exiting Agent Installation.

    Agent Installation Failed !!! Error Occurred while checking Agent group availability.

    Agent Installation Failed !!! See Logs for more details.

     

    And in the log file I am seeing the below error.

     

    [2018-03-31T22:14:44.149Z] [SEVERE] [ThreadID: 1] [Logger: oracle.cloud.cpi.agent.install.AgentInstaller] [SRC Class: oracle.cloud.cpi.agent.install.AgentInstaller; Method: checkAgentGroup] Agent Installation Failed !!! Error Occurred while checking Agent group availability. java.lang.Exception: {"type":"agentDefinitionResourceBean","id":"EBS_AGENT","name":"EBS-Agent","status":"AVAILABLE","transporterServiceType":"AQ","message":"Agent definition is available","agentInstanceCount":1,"retrieveStatus":"SUCCESS","links":{"link":[]},"agentInstances":[{"id":"CA-*****.COM-1521907491792","name":"******.COM-1521907491792","agentDefinition":"EBS_AGENT","version":"18.1.3.0.0"}]}

            at oracle.cloud.cpi.agent.install.AgentInstaller.checkAgentGroup(AgentInstaller.java:280)

            at oracle.cloud.cpi.agent.install.AbstractAgentInstaller.createAgentEnvironment(AbstractAgentInstaller.java:45)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:498)

            at oracle.cloud.cpi.agent.CpiAgentLoader.configureAgent(CpiAgentLoader.java:63)

            at oracle.cloud.cpi.agent.CpiAgentLoader.runAgent(CpiAgentLoader.java:38)

            at oracle.cloud.cpi.agent.CpiAgentLoader.startAgent(CpiAgentLoader.java:25)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:498)

            at oracle.cloud.cpi.agent.CpiBootstrapLoader.startAgent(CpiBootstrapLoader.java:89)

            at oracle.cloud.cpi.agent.CpiBootstrapLoader.main(CpiBootstrapLoader.java:49)

     

    Thanks

    Tarun

  • 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!

  • Santosh K Jagtap
    ICS Agent- Message not received within 240 seconds of wait...35.0
    Topic posted February 8, 2018 by Santosh K JagtapRed Ribbon: 250+ Points, tagged Agent, Integration in Integration > Integration public
    Title:
    ICS Agent- Message not received within 240 seconds of wait interval
    Summary:
    ICS Agent- Message not received within 240 seconds of wait interval
    Content:

    Hi,

    Using ICS DB Adapter i query a onpremise oracle database table via  an ics agent.I am successful (more than 15000 records) if my table column count less than 10 but for a table where i have 60 columns where i need all field values when queried for 250 records things work out fine with no issue but when query more than 250 records it fails with following message. I understand ICS Agent default timeout property is 240sec.Is there a way to increase this limit.Otherwise only left out option is read records in chunks which actually makes my integration complex because downstream i need to build a xml file to be placed in a ftp location.

     

    I am using db adapter execute sql query (select * from table) for this....

     

    ==============

    _Rlt1id0001Gw0000J2> <1518106187890> <BEA-000000> <servicebus:/SYNCHEBSCUSTOMERTO3RDPARTYAPP_01/Resources/resources/application_15/inbound_16/resourcegroup_17/GetCustomerDATA_REQUEST.wsdl [ GetCustomerDATA_REQUEST_ptt::GetCustomerDATA_REQUEST(parameters,parameters) ] - Could not invoke operation 'GetCustomerDATA_REQUEST' against the 'database' due to:

    oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.>

    ####<Feb 8, 2018 4:09:47 PM UTC> <Error> <oracle.osb.transports.jca.jcatransport> <us2z32-ics-ics9003-ics-ms2.opcics.z32.usdc2.oraclecloud.com> <ics_server2> <[ACTIVE] ExecuteThread: '33' for queue: 'weblogic.kernel.Default (self-tuning)'> <tapas.banerjee@in.ibm.com> <> <005PBMLMr9xA9T3_Rlt1id0001Gw0000J2> <1518106187893> <OSB-381967> <Invoke JCA outbound service failed with application error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.; nested exception is:

        javax.resource.ResourceException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.

    com.bea.wli.sb.transports.jca.JCATransportException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.; nested exception

     

    ============

     

    Santosh