Posts

Posts

  • Digvijay Chauhan
    OIC Timeout connecting to Database on Cloud5.0
    Topic posted September 11, 2019 by Digvijay ChauhanBlue Ribbon: 750+ 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?

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

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