Posts

Posts

  • 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

     

     

     

  • 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

  • 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

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

  • 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