Posts

Posts

  • Frank Brink
    a JSON to JSON integration using a local REST service result...8
    Topic posted Yesterday by Frank BrinkRed Ribbon: 250+ Points, tagged Agent, Connection, Integration, REST in Integration > Integration public
    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)
  • Nazeer Anantha
    Wants to download or read file from File Storage in OIC2
    Topic posted December 3, 2019 by Nazeer AnanthaBlue Ribbon: 750+ Points, tagged Adapters, Agent, API, Cloud, Connection, ERP Cloud, Integration, PaaS, REST, Web Services in Integration > Integration public
    Title:
    Wants to download or read file from File Storage in OIC
    Summary:
    Wants to download or read file from File Storage in OIC
    Content:

    Hi All,

    I am trying to download or read a file from File Storage in OIC.

    is there any way to achieve this without using File Adapter?

    Thanks,

    Nazeer.

  • Frank Brink
    The usage of a local REST swagger based connection (icw...
    Topic posted December 2, 2019 by Frank BrinkRed Ribbon: 250+ Points, tagged Agent, Connection, Integration, REST in Integration > Integration public
    Title:
    The usage of a local REST swagger based connection (icw an agent) in an integration result in an "unexpected error"
    Summary:
    unexpected error in integration while calling a connection based on local REST swagger based connection icw an agent
    Content:

    Hereby my (faied) scenario
    My REST based modules leveraging ORDS are running and executing successfully
    I am able to call the various REST methods directly and receive the expected answers
    I am able to generate and lookup the swagger definition in my browser
    I am able to define and test this same local REST swagger based (Invoke) connection icw an agent - with no authorization
    Then using that same connection within an integration result in
    "The application has encountered an unexpected error. 
    Please check the applications connection details, credentials and retry your request"
    as a result I cannot leverage/use all methods with this local REST based solutions in any integration
    Any ideas to circumvent this design error within an integration?

     

    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 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:
  • Samuel Lima
    OAUTH_CLIENT_CREDENTIALS not supported with Agent Group2
    Topic posted October 25, 2019 by Samuel LimaBronze Medal: 1,250+ Points, tagged Agent, Connection, Integration in Integration > Integration public
    Title:
    OAUTH_CLIENT_CREDENTIALS not supported with Agent Group
    Content:

    Hi experts,

    I tried to configure a connection to access an on-premises service secured with OAuth Client Credentials.but when tried to configure the connection this error appeared.

     

    Version:
    19.3.3.0.0 (190924.1600.31522)
    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 in Integration > Integration public
    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?

  • Sridhar Yerram
    Error while invoking INT based on the local agent2
    Topic posted October 16, 2019 by Sridhar YerramRed Ribbon: 250+ Points, tagged Adapters, Agent in Integration > Integration public
    Title:
    Error while invoking INT based on the local agent
    Content:

    Hi All,

    I'm trying to perform a inbound to outbound file integration using local agent, i designed the integration and activated.

    But when i tried to run it, it displayed the below error.

    Please suggest where i did the mistake.

    -Sri

    Code Snippet:
  • 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:
  • 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

  • Amitabha Dutta
    OIC Agent Installation - UnknownHostException from DbaaS...4
    Topic posted September 28, 2019 by Amitabha DuttaBlue Ribbon: 750+ Points, tagged Agent, Connection, Database in Integration > Integration public
    Title:
    OIC Agent Installation - UnknownHostException from DbaaS server
    Summary:
    OIC Agent Installation - UnknownHostException from DbaaS server
    Content:

    We had followed https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/index.html and installed agent on the dbaas server by connecting opc user.
    It was working well, suddenly we noticed the agent went down and when we tried to restart the agent, it failed with error -
    Client.ClientHandlerException: java.net.UnknownHostException: <xxxx>.integration.ocp.oraclecloud.com

    It seems it is not able to connect to oic_URL. If I follow the same steps on my local machine, the agent starts successfully.

    As we need to keep the agent running in background from a server for all-time availability, can anyone provide some suggestion to overcome the issue? I hope a separate proxy server is not required as all the components belong to same cloud account.