Posts

Posts

  • logu Prasanth
    How to create a post REST service in OIC25
    Topic posted March 27, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Agent, API, Case Management, Cloud, Connection, Database, E-Business Suite, Events, Integration, Mapping, Orchestration, PaaS, Process, REST, SOAP, Web Services, xml in Integration > Integration public
    Title:
    How to create a post REST service in OIC
    Summary:
    We have a requirement to create a REST service in OIC. And this service will be exposed to the client to POST their JSON data.
    Content:

    We have a requirement to create a REST service in OIC. And this service will be exposed to the client to POST their JSON data.

    Can you please provide any artifact /whitepaper/ procedure for creating simple REST service in OIC.

     

     

     

     

     

  • 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

  • Nirmal Kumar
    HDL File upload to UCM not working through OIC11
    Topic posted March 23, 2019 by Nirmal KumarRed Ribbon: 250+ Points, tagged Adapters, Agent, Cloud, Connection, Database, E-Business Suite, Integration, Mapping, Orchestration, SOAP, Web Services, xml in Integration > Integration public
    Title:
    HDL File upload to UCM not working through OIC
    Summary:
    HDL File upload to UCM not working through OIC
    Content:

    Hi All,

    I am trying to upload worker.dat HDL file to UCM server through OIC integration.

    But it is failing with the below error -

    Content item 'UCMFA00012909' was not successfully checked in. The content type 'dat' is not defined in the system. :Application Error

    I also tried uploading Worker.zip file. But getting similar error saying - Content type 'zip' is not defined in the system.

    Can you please help resolve it.

    Attached is the screenshot of mapping. Please let me know if setup is correct.

     

    Thanks,

    Nirmal

    Version:
    Version: 19.1.5.0.0
    Document:
  • 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,

  • 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.
  • Ritu
    OIC Connectivity AgentAnswered85.0
    Topic posted June 7, 2018 by RituSilver Medal: 2,000+ 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

  • Afolabi Sulaimon
    Agent Installation Failed!! Error While Checking Version...7
    Topic posted October 28, 2019 by Afolabi Sulaimon, tagged Agent, Cloud, Connection, Integration, PaaS in Integration > Integration public
    Title:
    Agent Installation Failed!! Error While Checking Version Response
    Summary:
    ICS Agent Installation 19.4.1.0.0 (191012.1400.31860)
    Content:

    I seem to have run into a challenge with the ICS installation, i have created an agent group, proceeded to download connectivity agent, modified the InstallerProfile.cfg file, included the oic_url, agent group and proxy information. However, upon running the execution command (on windows 10) -java -jar connectivityagent.jar. It fails.

    Upon examining the log, i found this error 

    Agent Installation Failed !!! Error occurred while checking version response. javax.ws.rs.NotAuthorizedException: HTTP 401 Unauthorized
    at org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:1080)
     
    I have repeated the steps severally, the credentials are correct and the error still persists. Any suggestions/ideas on how to manage Agent installation with Proxy?
    Version:
    ICS 19.4.1.0.0 (191012.1400.31860)
    Image:
  • Frank Brink
    OIC Connectivity Agent Install Issue on Windows7
    Topic posted October 16, 2019 by Frank BrinkRed Ribbon: 250+ Points, tagged Agent in Integration > Integration public
    Title:
    OIC Connectivity Agent Install Issue on Windows
    Summary:
    OIC agent install result in "Agent install/startup failed. Please ensure the agent install/startup command is attempted from agent install location"
    Content:

    After downloading and unzipping oic_connectivity_agent.zip into a stage directory

    Populating the InstallerProfile.cfg file with oic_url and agent_group

    Starting the install with "C:\Program Files\Java\jdk1.8.0_212\bin\java.exe" -jar connectivityagent.jar

    I receive the following message

    Agent install/startup failed. Please ensure the agent install/startup command is attempted from agent install location.

    The Windows output:

    e:\stage\oicagent>"C:\Program Files\Java\jdk1.8.0_212\bin\java.exe" -jar connectivityagent.jar
    Agent install/startup failed. Please ensure the agent install/startup command is attempted from agent install location.

    e:\stage\oicagent>

    How to proceed from here?

    Version:
    OIC Version 19.3.3.0.0 (190924.1600.31521)
    Code Snippet:
  • 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.

  • 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