Posts

Posts

  • Surya Satyanarayana
    OIC connectivity agent JMS issue4
    Topic last edited October 26, 2018 by Surya Satyanarayana, tagged Adapters, Agent, Cloud, Connection, Integration in Integration > Integration public
    Title:
    OIC connectivity agent JMS issue
    Summary:
    JMS connectivity issue for manage server port
    Content:

    We are trying to connect to manage server port for weblogic server but are getting the below issue.

    Test connection failed. Please ensure you are providing correct Weblogic JMS Admin host and port. Error Details : While trying to lookup 'weblogic.management.mbeanservers.domainruntime' didn't find subcontext 'management'. Resolved 'weblogic'

    The same connection for admin port is working fine. We tried to place few libraries and restarted the agent but have got a different error now.

    • java.lang.NoClassDefFoundError: Could not initialize class weblogic.security.SubjectUtils

    Any idea what all libraries need to be added for the weblogic JMS connection to work for manage server port.

    Thank you.

    Surya

    Version:
    OIC Version: 18.3.5.0.0
  • John Graves
    OIC 18.3.5 - JMS Adapter 18.1.5 - Consumer - Managed Server...2
    Topic posted October 17, 2018 by John GravesSilver Trophy: 7,500+ Points, tagged Adapters, Agent, Integration in Integration > Integration public
    Title:
    OIC 18.3.5 - JMS Adapter 18.1.5 - Consumer - Managed Server issue
    Summary:
    Having issues using the JMS adapter (via connectivity agent) to connect to queues on managed servers.
    Content:

    Having issues using the JMS adapter (via connectivity agent) to connect to queues on managed servers.

    It works fine when connecting to queues on admin server.

    When connecting to queue on Admin server, I get a 'good' message in the agent log
    ----------------------------

    [2018-10-18T01:21:43.912Z] [INFO] [ThreadID: 63] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** ICS jmsCmd: getJMSDestinationTargetUrl 
    [2018-10-18T01:21:43.913Z] [INFO] [ThreadID: 63] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection params - 100.65.4.46 **** 7001 **** weblogic 
    [2018-10-18T01:21:44.077Z] [INFO] [ThreadID: 63] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection Url - t3://100.65.4.46:9071; 
    

    ----------------------------

    When I try to connect to a queue on a managed server I get a 'bad' or empty message in the log

    ----------------------------

    [2018-10-18T01:24:16.134Z] [INFO] [ThreadID: 92] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** ICS jmsCmd: getJMSDestinationTargetUrl 
    [2018-10-18T01:24:16.135Z] [INFO] [ThreadID: 92] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection params - 100.65.4.46 **** 7001 **** weblogic 
    [2018-10-18T01:24:17.156Z] [INFO] [ThreadID: 92] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection Url -  
    

    ----------------------------

    -John

    Version:
    18.3.5
  • 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

  • Moon Ray Lo
    Runtime Fault/Exception Handling in OIC (Oracle SOA...3
    Topic posted September 17, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, Cloud, Connection, Database, Integration, Mapping, PaaS, REST, SOAP, Web Services in Integration > Integration public
    Title:
    Runtime Fault/Exception Handling in OIC (Oracle SOA Fault Policy Functionality?)
    Summary:
    Is Oracle SOA Fault Policy Functionality also present in OIC? Especially handling runtime fault on server side
    Content:

    Hello OIC Gurus, 

    Oracle SOA has this Fault Policy Functionality, controlling actions as faults arise, especially recoverable errors (re-try instances). May I know if this feature is also available in OIC? (both user-managed and autonomous OIC). If none, I know leveraging the OIC REST API (retrieve and resubmit error instances) is a feasible option, but do we have another workaround at the moment to attain this functionality? (like raising Cloud Support request for fault-policy configuration?)

    Appreciate all your inputs on this.


    Thanks,
    Moon

  • Manash Chowdhury
    Issue Activating ICS Integration - DB Adpater Issue75.0
    Topic last edited 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.

  • Carin Webb
    Oracle Cloud HCM to EBS On-Premise Payroll Integration with...5
    Topic posted September 7, 2018 by Carin WebbRed Ribbon: 250+ Points, tagged Adapters, Agent, E-Business Suite in Integration > Integration public
    Title:
    Oracle Cloud HCM to EBS On-Premise Payroll Integration with ICS
    Summary:
    How to get data from Oracle Cloud HCM to Send to EBS On-Premise with ICS
    Content:

    Hi,

     

    I am new to Cloud and ICS. I need to build integration between Cloud HCM and EBS On-Premise to get Employee Information from Cloud to On-Premise to run the Payroll.

     

    We have created the EBS Agent and Exposed the Rest API's and created the Connection using the EBS Adapter in ICS. I have also created the Cloud HCM Adapter connection.

     

    I need to know what service do I need to Use on the Cloud HCM adapter to retrieve the employee information to map and send to EBS.

     

    Your assistance is appreciated.

     

    Regards

    Cariin Webb

    Version:
    Cloud HCM Release 13 (18b) On-Premise EBS 12.27
  • Tarun
    [SRC Class: oracle.cloud.cpi.agent.install.AgentInstaller;...35.0
    Topic last edited April 3, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Agent, E-Business Suite, Integration in Integration > Integration public
    Title:
    [SRC Class: oracle.cloud.cpi.agent.install.AgentInstaller; Method: checkAgentGroup] Agent Installation Failed !!! Error Occurred while checking Agent group availability
    Summary:
    [SRC Class: oracle.cloud.cpi.agent.install.AgentInstaller; Method: checkAgentGroup] Agent Installation Failed !!! Error Occurred while checking Agent group availability
    Content:

    Hi Experts,

     

    We have installed the agent on EBS on-prem server and when we are trying to run the agent with the command we get the below error.

    Any pointers on this will help us

     

    -bash-4.1$ java -jar connectivityagent.jar

    Proceeding to install a new agent ...

    Enter your OIC username : ****

    Enter password for *****

    No Proxy Configuration Detected

    Checking for trusted certificates ...

    Making call to check OIC Version ...

    Making call to check Agent group availability ...

    Agent Group Already Contains Agent. Exiting Agent Installation.

    Agent Installation Failed !!! Error Occurred while checking Agent group availability.

    Agent Installation Failed !!! See Logs for more details.

     

    And in the log file I am seeing the below error.

     

    [2018-03-31T22:14:44.149Z] [SEVERE] [ThreadID: 1] [Logger: oracle.cloud.cpi.agent.install.AgentInstaller] [SRC Class: oracle.cloud.cpi.agent.install.AgentInstaller; Method: checkAgentGroup] Agent Installation Failed !!! Error Occurred while checking Agent group availability. java.lang.Exception: {"type":"agentDefinitionResourceBean","id":"EBS_AGENT","name":"EBS-Agent","status":"AVAILABLE","transporterServiceType":"AQ","message":"Agent definition is available","agentInstanceCount":1,"retrieveStatus":"SUCCESS","links":{"link":[]},"agentInstances":[{"id":"CA-*****.COM-1521907491792","name":"******.COM-1521907491792","agentDefinition":"EBS_AGENT","version":"18.1.3.0.0"}]}

            at oracle.cloud.cpi.agent.install.AgentInstaller.checkAgentGroup(AgentInstaller.java:280)

            at oracle.cloud.cpi.agent.install.AbstractAgentInstaller.createAgentEnvironment(AbstractAgentInstaller.java:45)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:498)

            at oracle.cloud.cpi.agent.CpiAgentLoader.configureAgent(CpiAgentLoader.java:63)

            at oracle.cloud.cpi.agent.CpiAgentLoader.runAgent(CpiAgentLoader.java:38)

            at oracle.cloud.cpi.agent.CpiAgentLoader.startAgent(CpiAgentLoader.java:25)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:498)

            at oracle.cloud.cpi.agent.CpiBootstrapLoader.startAgent(CpiBootstrapLoader.java:89)

            at oracle.cloud.cpi.agent.CpiBootstrapLoader.main(CpiBootstrapLoader.java:49)

     

    Thanks

    Tarun

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

     

  • 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 in Integration > Integration public
    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

  • SM
    starting Oracle ICS agentAnswered25.0
    Topic last edited March 1, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Agent, Integration in Integration > Integration public
    Title:
    starting Oracle ICS agent
    Summary:
    starting Oracle ICS agent
    Content:

    Hello,

     

    How can we start the Oracle ICS agent in the background, passing along with the connection parameters?

     

    The document (E85413-03  January 2018), I am following doesn't have any information as such about starting the agent in the background. Please advice.

     

     

    $java -jar connectivityagent.jar

    Proceeding to install a new agent ...

    Enter your OIC username : abc@xyz.com

    Enter password for abc@xyz.com :

     

     

    Thanks!