Integration

Get Involved. Join the Conversation.

Posts

  • Frank Brink
    a JSON to JSON integration using a local REST service result...10
    Topic posted December 4, 2019 by Frank BrinkRed Ribbon: 250+ Points, tagged Agent, Connection, Integration, REST 
    Title:
    a JSON to JSON integration using a local REST service result in Failed to translate XML to JSON
    Summary:
    a basic routing integration (JSON to JSON) leveraging a local REST service (through an agent) result in Failed to translate XML to JSON
    Content:

    Hereby my scenario that result in a faulted json response within SOAPUI - see below the error in SOAPUI on the JSON tab

    1. Create an invoke connection to a REST module that resides in the database using a generic REST API Base URL option (contain all my REST modules: http://10.0.20.6:8091/ords/hr_schema tthrough an agent since the REST services resided in my database

    2. Create a JSON to JSON integration leveraging this connection with a request and response mapping

    3. Executing this integration result in the following error on the JSON tab:

    {
       "type": "10.5.3",
       "title": "exception occurred while translating the response into the accepted media type.",
       "detail": "oracle.cloud.connector.api.CloudInvocationException: ORABPEL-15236\n
       \n
       Translation Failure.\nFailed to translate XML to JSON. 
       Cannot write end element: empno\n
       The data does not conform to the NXSD schema. Please correct the problem.\n",
       "o:errorCode": "TRANSLATION-ERROR-01",
       "o:errorDetails": [   {
          "type": "NA",
          "instance": "NA",
          "title": "NA",
          "o:errorPath": "NA",
          "o:errorCode": "NA"
       }]
    }

    Odly enough there are NO failing instance(s)

    In addition if you lookup the payload within the activity stream option you can actually see the expected/correct response payload?

    So no failed instances with the expected payload but this payload is not shown in SOAPUI on the JSON tab - in stead the error as displayed above

    What could be the root cause of this inconstent behavior? 

    See also below for a substract of the diagnostic file containing the "ORABPEL-15236 Translation Failure. Failed to translate XML to JSON. Cannot write end element: empno" error
    ..

    [2019-12-04T07:28:04.169+00:00] [oiclhr3I_server_1] [ERROR] [] [oracle.tip.pc.services.translation.xlators.json.JsonTranslator] 

    [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] 
    [userId: frank.brink@darwin-it.nl] [ecid: 780150c5-74f2-4fe4-b56a-0ab2e1a0aa73-00042ae1,0] 
    [APP: Cloud Adapter Inbound Http App] [partition-name: DOMAIN] [tenant-name: GLOBAL] 
    [oracle.soa.tracking.FlowId: 7600006] [FlowId: 0000MvFnj8ZCSs95zf_AiW1TtPJT00002l] JsonTranslator.translateToNative writer Exception caught[[
    org.xml.sax.SAXException: Cannot write end element: empno
    javax.xml.stream.XMLStreamException: Cannot write end element: empno
    at oracle.tip.pc.services.translation.xlators.json.NillableSupportedJsonSaxContentHandler.endElement(NillableSupportedJsonSaxContentHandler.java:347)
     
    Caused by: org.codehaus.jackson.JsonGenerationException: Error occurred while trying to write the value: 
    at oracle.tip.pc.services.translation.xlators.json.jackson.TypeDeducingJsonGenerator.writeString(TypeDeducingJsonGenerator.java:92)
    Caused by: java.lang.NumberFormatException
    at java.math.BigDecimal.<init>(BigDecimal.java:599)
     
    [2019-12-04T07:28:04.236+00:00] [oiclhr3I_server_1] [ERROR] 
    [] [oracle.tip.pc.services.translation.xlators.json.JsonTranslator] 
    [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] 
    [userId: frank.brink@darwin-it.nl] [ecid: 780150c5-74f2-4fe4-b56a-0ab2e1a0aa73-00042ae1,0] 
    [APP: Cloud Adapter Inbound Http App] [partition-name: DOMAIN] 
    [tenant-name: GLOBAL] [oracle.soa.tracking.FlowId: 7600006] 
    [FlowId: 0000MvFnj8ZCSs95zf_AiW1TtPJT00002l] JsonTranslator.translateToNative TranslationException caught[[
    ORABPEL-15236 Translation Failure. Failed to translate XML to JSON. Cannot write end element: empno
    The data does not conform to the NXSD schema. Please correct the problem.
     
    at oracle.tip.pc.services.translation.xlators.json.JsonTranslator.translateToNative(JsonTranslator.java:331)
     
    Caused by: org.xml.sax.SAXException: Cannot write end element: empno
    javax.xml.stream.XMLStreamException: Cannot write end element: empno
    at oracle.tip.pc.services.translation.xlators.json.NillableSupportedJsonSaxContentHandler.endElement(NillableSupportedJsonSaxContentHandler.java:347)
    at

     

    Version:
    Version: 19.4.2.0.0 (191110.1400.32380)
  • Afolabi Sulaimon
    Agent Installation Failed!! Error While Checking Version...7
    Topic posted October 28, 2019 by Afolabi Sulaimon, tagged Agent, Cloud, Connection, Integration, PaaS 
    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
    Connection: The configure connectivity does not accept a...
    Topic posted October 22, 2019 by Frank BrinkRed Ribbon: 250+ Points, tagged Adapters, Agent, API, Connection, REST 
    Title:
    Connection: The configure connectivity does not accept a local swagger rest api icw an agent group
    Summary:
    How to setup a connection to a local REST api in combination with a running agent group
    Content:

    The following REST api url (swagger)

    http://localhost:8091/ords/hr_schema/open-api-catalog/empdep/ gives me all available methods for the empdep REST module in my browser

    If I use the same url within the REST adapter connection (in the configure connectivity section) the url is not accepted while explicitely using my earlier defined agent group

    Also the other options like "REST API" based are refused by the configure connectivity  

    If I setup my router using myipv4 and forwarding all requests (and leave the agent group blank) on port 8091 the configure connectivity is accepting the url

    http://Myipv4:8091/ords/hr_schema/open-api-catalog/empdep/ is accepted

    How to setup a connection to a local REST api in combination with a running agent group?

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

  • Rohit Mopuri
    Connectivity Agent in OIC - Recommendation115.0
    Topic posted July 26, 2018 by Rohit MopuriSilver Medal: 2,000+ Points, tagged Agent, Cloud, Integration 
    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,

  • Moon Ray Lo
    Downtime Handling in OIC35.0
    Topic posted August 3, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, Cloud, Connection, Database, Integration, Mapping, Orchestration, PaaS, REST, SOAP, xml 
    Title:
    Downtime Handling in OIC
    Summary:
    We encountered intermittent connection (2-3 minutes of random downtime) in OIC
    Content:

    Hi,

     

    We encountered intermittent connection (2-3 minutes of random downtime like service not accessible) with OIC, which happens a couple of times in a week. It may not sound a big deal, but this is concerning on a production system, that some integrations are unavailable on that instance (especially there are activities triggered).

    Aside from having error handling (integration level), can you suggest how to handle OIC downtime? I can see there's a 'Load Balancer' for every OIC service, any idea how to leverage on this context?

     

    Appreciate your inputs on this.

     

    Thanks,

    Moon

  • Nirmal Kumar
    E-business suite business event is not reaching ICS3
    Topic posted January 3, 2019 by Nirmal KumarRed Ribbon: 250+ Points, tagged Adapters, Agent, Cloud, Connection, E-Business Suite, Events, Integration, REST 
    Title:
    E-business suite business event is not reaching ICS
    Summary:
    E-business suite business event is not reaching ICS
    Content:

    Dear All,

    I am creating a HRMS Job in E-business suite and the same must be interfaced to HCM via ICS.

    I have enabled the business event in EBS related to Create Job and I have built integration in ICS using EBS adapter to receive business events. 

    But when I create new jobs in EBS, nothing comes into ICS. The logs are showing 0 messages.

    Not sure if I am using EBS event subscriptions correctly. Please Let me know subscription creation steps.

    Request you all to provide suggestions. Looking forward to your help. 

     

    Thanks,

    Nirmal

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

  • Robert Cruickshank
    ERP and SCM Cloud Data Extracts to on-premise data warehouse
    Topic posted December 29, 2018 by Robert CruickshankGreen Ribbon: 100+ Points, tagged Adapters, Agent, Cloud, Connection, Database, E-Business Suite, ERP Cloud, Integration, Mapping, SOAP, xml 
    Title:
    ERP and SCM Cloud Data Extracts to on-premise data warehouse
    Summary:
    Need advice on best option for extract data from ERP/SCM Cloud to on-premise wartehouse. Looked at BI Cloud Connect, but believe that requires a UCM Server on-premise.
    Content:

    Need advice on best option for extract data from ERP/SCM Cloud to on-premise data warehouse.

    Looked at BI Cloud Connect, but believe that requires a UCM Server on-premise. Which would mean a new license as well ?

    Reviewed the Financials Data Extract (Oracle Support 2303683.1). This sounds like a possibility as it also mentions the possibility of using custom BIP reports through the ERP Integration Services.

    We plan to have Oracle Autonomous Integration Service and would prefer to put extracts through that for visibility. However, I am keen to find a solution, relatively 'out of the box', rather than developing multiple extracts from scratch (probably unavoidable).

    Would Data Integration Platform Cloud (DIPC)  also be a good fit? I think so, but think it is probably overkill for the simplicity of incremental data extracts.

    Note HCM Extracts is another option for HCM Data, is their the same for SCM and Financials data?

    rgds

    Rob

     

     

     

  • logu Prasanth
    Error : While running the integration i am getting Error...1
    Topic posted July 16, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Agent, Connection, E-Business Suite, Integration, Mapping, Orchestration, PaaS, Process, REST, Web Services, xml 
    Title:
    Error : While running the integration i am getting Error "No response received within response time out window of 240 seconds"
    Summary:
    No response received within response time out window of 240 seconds
    Content:

    While running the integration i am getting Error "No response received within response time out window of 240 seconds

    oracle.cloud.cpi.agent.transport.aq.CpiAQException: No response received within response time out window of 240 seconds. Agent may not be running, or temporarily facing connectivity issues to Oracle Integration Cloud Service. Please check the health of the Agent in Agent Monitoring page.:Application Error

    Is there any possibilities to increase the time out error time in OIC?

     or this 240 seconds is fixed?

    Thanks in advance

    Regards,

    -LP