Posts

Posts

  • Digvijay Chauhan
    OIC Timeout connecting to Database on Cloud5.0
    Topic posted September 11, 2019 by Digvijay ChauhanBronze Trophy: 5,000+ Points, tagged Adapters, Agent, Database, Integration in Integration > Integration public
    Title:
    OIC Timeout connecting to Database on Cloud
    Summary:
    OIC Timeout connecting to Database on Cloud
    Content:

    Hi All,

    I have heard new DB adapter is being rolled out that won't need an agent to be installed on Cloud DB, Does that mean that DB agent timeout of 240 seconds won't be valid going further?

    Have any have tried this new DB adapter?

    Thanks

    Dvi

  • Moon Ray Lo
    OIC Exception/Error Handling & Recoverable InstanceAnswered65.0
    Topic posted February 5, 2019 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, API, Case Management, Cloud, Connection, Database, E-Business Suite, Eloqua, ERP Cloud, Events, Integration, Mapping, NetSuite, Orchestration, PaaS, Primavera, Process, REST, RightNow, Sales Cloud, Salesforce, SAP, Siebel, SOACS, SOAP, Taleo, Tip, Web Services, Workday in Integration > Integration public
    Title:
    OIC Exception/Error Handling & Recoverable Instance
    Summary:
    Oracle Integration Cloud's Exception/Error Handling & Recoverable Instance
    Content:

    Hi Team,

     

    I have noticed that NOT ALL instances that faulted can be recovered or resubmitted for reprocessing - based from y experience, I have resubmitted/recovered some (scheduled integration) and unable for others (app-driven integration)

     

    I'd like to know as to which specific conditions would an instance considered as recoverable when fault encountered.

     

    Thanks ahead,

    Moon

    Version:
    19.1.3.0.0 (190129.1200.23460)
  • Christopher Maggiulli
    Select statement with DB2 connector doesn't return...Answered85.0
    Topic posted July 3, 2018 by Christopher MaggiulliSilver Crown: 22,500+ Points, tagged Adapters, Agent, Database, Mapping, Orchestration in Integration > Integration public
    Title:
    Select statement with DB2 connector doesn't return anything to map
    Summary:
    Using the DB2 connector to connect to DB2 over port 446, select statement validates and generates and xsd but there is not outbound mapping.
    Content:
    I administer a test and production customer managed OIC environment 18.2.5. We have an on premise connectivity agent that we use for a majority of our integrations. We have an AS400 that uses DB2 as our main ERP. I can connect to it successfully over port 446 (that's the standard port for DB2 on the as400 not 5000, shouldn't matter though). When I created an integration invoking the DB2 adapter using a simple select statement the it validates the query and generates the XSD, but the outbound mapping does not show anything to map to. Has anyone experienced this issue? In our Java applications we connect directly to the database using a jt400 jdbc driver. We had an issue with connecting to MySQL until I found a special driver and added it to the agenthome/third-party/lib folder. I tried to add the jt400 driver to that folder and restart, no fix. This is turning into a huge issue. On the old forum someone told me the DB2 adapter does not allow select statements, but I haven't been able to find that stated in the documentation.i haven't placed a SR yet because we have several open and I'm the only technical person to manage them currently. If I could find my own solution I'd prefer so that I don't clutter Oracle with tickets then become unresponsive.
  • 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?

  • Mukesh Patil02
    How to enable SOA Suite Adapter in OICAnswered65.0
    Topic posted October 15, 2019 by Mukesh Patil02Red Ribbon: 250+ Points, tagged Adapters, Agent, Cloud, Connection, Integration, PaaS in Integration > Integration public
    Title:
    How to enable SOA Suite Adapter in OIC
    Summary:
    How to enable SOA Suite Adapter in OIC
    Content:

    Hi all

    As per below blogs,SOA Suite adapter is available in OIC.

    https://blogs.oracle.com/integration/soa-suite-adapter-connection-v2

    https://blogs.oracle.com/integration/soa-suite-adapter-faq-v2

     

     

    Any idea how to get this connection available in existing OIC instance ?

    Do we need to raise SR or wait for updates

    Mukesh

  • Cesar Tepetla Corte
    how to measure the messages of an OIC integration5.0
    Topic posted August 22, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Adapters, Agent, Cloud, Integration in Integration > Integration public
    Title:
    how to measure the messages of an OIC integration
    Content:

    How are the messages of an OIC integration measured?

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

  • Rohit Mopuri
    Connectivity Agent in OIC - Recommendation115.0
    Topic posted July 26, 2018 by Rohit MopuriSilver Medal: 2,000+ Points, tagged Agent, Cloud, Integration in Integration > Integration public
    Title:
    Connectivity Agent in OIC - Recommendation
    Summary:
    Connectivity Agent in OIC - Recommendation
    Content:

    Hello experts,

     

    When we install a connectivity agent on windows system. Is it recommended to have a seperate VM for the agent or is it ok to have an existing VM where other windows services are also installed.

    What are the pros and cons for having a separate VM.

    Regards,

    Rohit,

  • Subrahmanyam Vempati
    Connectivity Agent ICS Vs OICAnswered65.0
    Topic posted September 28, 2018 by Subrahmanyam VempatiBronze Trophy: 5,000+ Points, tagged Agent, Cloud, Integration, Tip in Integration > Integration public
    Title:
    Connectivity Agent ICS Vs OIC
    Summary:
    Difference between the connectivity agent execution
    Content:

    Hi Team,

    I wonder how the connectivity agent of OIC is much lighter than the ICS agent .

    ICS agent is almost 1.7 GB and OIC is just 140MB. What makes this difference?

    Can anyone explain the internal architecture?

    Is still the weblogic running behind the scenes for OIC?

    Thanks,

    Vempati

  • Manash Chowdhury
    Issue Activating ICS Integration - DB Adpater Issue75.0
    Topic posted September 3, 2018 by Manash ChowdhuryRed Ribbon: 250+ Points, tagged Adapters, Agent, Database, Integration, PaaS in Integration > Integration public
    Title:
    Issue Activating ICS Integration - DB Adpater Issue
    Summary:
    Facing Issue while Activating ICS Integration with DB adapter configured.
    Content:

    We are now facing issue in activating and ICS integration with DB adapter. I'll list the steps and the output for better understanding:

    1. Installed a connectivity agent in ICS db server as we will connect to user defined tables in ICS. Below is the output that the agent is running fine:

    [oracle@DevICSDb-Multichoice oic_connectivity_agent]$ pwd
    /home/oracle/devDBCS_agent/oic_connectivity_agent
    [oracle@DevICSDb-Multichoice oic_connectivity_agent]$ ls
    agenthome  connectivityagent.jar  InstallerProfile.cfg  oic_connectivity_agent.zip  pid
    [oracle@DevICSDb-Multichoice oic_connectivity_agent]$ java -jar connectivityagent.jar &
    [1] 26966
    [oracle@DevICSDb-Multichoice oic_connectivity_agent]$ Existing Agent installation found... Starting Agent for message processing.
    Checking for already running instances of this agent. This might take up to 15 seconds ...
    Initializing the credential store ...
    Agent started successfully...Now available for new messages...

    Step 2: Created a db connection with required details and test was successful.

    Step 3. Created an integration with a SOAP and DB adapter. While conencting the db adpater, the SQL query provided was succesful too.

    Step 4. Create the required mapping and tried to activate the integration and got the following error:

    [SEVERE] [ThreadID: 1780] [Logger: oracle.cloud.cpi.agent.ActivationCpiCommand] [SRC Class: oracle.cloud.cpi.agent.ActivationCpiCommand; Method: doRequest] Error in performing activation. java.lang.ArrayIndexOutOfBoundsException: 1
            at oracle.cloud.cpi.agent.store.FileAgentStore.getArtifactsRoot(FileAgentStore.java:97)
            at oracle.cloud.cpi.agent.store.FileAgentStore.addActivation(FileAgentStore.java:28)
            at oracle.cloud.cpi.agent.ActivationCpiCommand.doRequest(ActivationCpiCommand.java:80)
            at oracle.cloud.cpi.agent.ActivationCpiCommand.execute(ActivationCpiCommand.java:54)
            at oracle.cloud.cpi.agent.CpiAgentImpl.execute(CpiAgentImpl.java:40)
            at oracle.cloud.cpi.agent.framework.CpiCommandBus.execute(CpiCommandBus.java:29)
            at oracle.cloud.cpi.agent.framework.CpiCommandBus.receive(CpiCommandBus.java:24)
            at oracle.cloud.cpi.agent.transport.DistributedCpiCommandExecutorOmcs.received(DistributedCpiCommandExecutorOmcs.java:112)
            at oracle.cloud.cpi.agent.transport.AQConsumer$AdapterCommandTask.call(AQConsumer.java:289)
            at oracle.cloud.cpi.agent.transport.AQConsumer$AdapterCommandTask.call(AQConsumer.java:277)
            at java.util.concurrent.FutureTask.run(FutureTask.java:266)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
            at java.lang.Thread.run(Thread.java:745)

    Not sure what's going wrong. Please suggest. We'll try to delete and recreate the agent as the last approach.