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

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

  • Cesar Tepetla Corte
    How to read file using ICS file adapter63.0
    Topic posted March 11, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Adapters, Agent, API, Integration, Orchestration, REST, Web Services in Integration > Integration public
    Title:
    How to read file using ICS file adapter
    Summary:
    Read a file from an FTP server using file adapter.
    Content:

    Hi everyone,

    I am working on an integration to read an FTP file I was previously working with the FTP adapter and this worked without problem but we have changed the server and due to security the only option they gave us was to use the file adapter.
    I created a small exercise to read a file but without success when I activate the integration it shows me a WSDL that when opening it tells me the error: "Error 503 - Service Unavailable
    From RFC 2068 Hypertext Transfer Protocol - HTTP / 1.1:
    503 Service Unavailable "

    Any opinions and comments are grateful.

    Regards,

    Bartholomew

     

  • 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)
  • Nirmal Kumar
    Outbound from EBS to OIC6
    Topic posted January 8, 2019 by Nirmal KumarRed Ribbon: 250+ Points, tagged Adapters, Agent, Cloud, Connection, E-Business Suite, ERP Cloud, Events, Integration, REST, SOAP, Web Services in Integration > Integration public
    Title:
    Outbound from EBS to OIC
    Summary:
    Outbound from EBS to OIC
    Content:

    Hi All,

    When outbound interface happens from EBS to OIC, does/should the traffic from EBS go directly to OIC through proxy server without involving OIC agent?

    Or both inbound and outbound traffics must go via OIC agent only?

    Please provide clarification.

     

    Thanks,,

    Nirmal 

    Version:
    OIC version 18.4.5.0.0