Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Cloud Adapter for RightNow

Heba Fouad-OracleJan 30 2015 — edited Feb 6 2015

Hello Everyone,

I really appreciate your help with the RightNow adapter.

The problem I face with the RightNow adapter on SOA 12c.

I am using the patch for Oracle RightNow Cloud Adapter 12.1.3.0.0

I followed the document of Oracle Cloud Adapter for Oracle RightNow Cloud Service User's Guide 12c (12.1.3)


The use case is I have a BPEL process invoking the RightNow adapter to create contact operation

  • I installed the adapter successfully on Jdev and I’m able to establish a connection through the IDE  and WSDL
  • I configured the CSF Key and certificate
  • I also checked the profile in RightNow, I have privileges for SOAP API and to invoke CRUD operations on contacts object


The only configuration I’m not sure about is the Host:

SEC_PAPI_INTEG_HOSTS_SOAP: it’s blank in RightNow, I tried to put my IP address same thing nothing happened

The problem is when I call the service in the test in Enterprise Manager

The error is as  the following about the connection

“oracle.sysman.emInternalSDK.webservices.util.SoapTestException: Client received SOAP Fault from server : Exception occurred when binding was invoked.<br>Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'Create' failed due to: Unable to create Cloud Operation: ". <br>The invoked JCA adapter raised a resource exception.<br>Please examine the above error message carefully to determine a resolution.<br>

java.lang.Exception: oracle.sysman.emInternalSDK.webservices.util.SoapTestException: Client received SOAP Fault from server : Exception occurred when binding was invoked.

Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'Create' failed due to: Unable to create Cloud Operation: ".

The invoked JCA adapter raised a resource exception. could not create url from wsdl: /WSDLs/soap.WSDL and https://bpd-poc.rightnowdemo.com/cgi-bin/bpd_poc.cfg/services/soap?xsd=base

<br>

the logs from the BPEL process:

<?xml version="1.0" encoding="UTF-8" ?>

- <messages>

- <fault>

- <bpelFault>

<faultType>0</faultType>

- <bindingFault xmlns="http://schemas.oracle.com/bpel/extension">

- <part name="summary">

<summary>Exception occurred when binding was invoked. Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'Create' failed due to: Unable to create Cloud Operation: ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.</summary>

</part>

- <part name="detail">

<detail>Could not create URL from '../WSDLs/soap.wsdl' and https://bpd-poc.rightnowdemo.com/cgi-bin/bpd_poc.cfg/services/soap?xsd=base'</detail>

</part>

- <part name="code">

<code>null</code>

</part>

</bindingFault>

</bpelFault>

</fault>

- <faultType>

<message>0</message>

</faultType>

</messages>

The JCA file is as the following:

<adapter-config name="rightnowReferencePortType" adapter="rightnow" wsdlLocation="../WSDLs/rightnowReference.wsdl" xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata">

<connection-factory location="cloud/CloudAdapter">

<non-managed-connection managedConnectionFactoryClassName="oracle.cloud.connector.rightnow.RightNowConnectionFactory">

<property name="targetWSDLURL" value="../WSDLs/soap.wsdl"/>

<property name="csfkey" value="RN_KEY"/>

<property name="appID" value="removeWhenAppIdIsHardcodedByRNPlugin"/>

<property name="applicationVersion" value="1_2"/>

</non-managed-connection>

</connection-factory>

<endpoint-interaction portType="rightnowReferencePortType" operation="Create">

    <interaction-spec className="oracle.tip.adapter.cloud.CloudInteractionSpec">

      <property name="targetOperation" value="Create"/>

<property name="operationPath" value="Create"/>

<property name="suppressResponse" value="true"/>

<property name="cpo.suppressExternalEvents" value="false"/>

<property name="cpo.suppressRules" value="false"/>

</interaction-spec>

</endpoint-interaction>

</adapter-config>

Comments

Jeo123

Yeah, it's compatible.  Our servers have 2016 on them and smartview works just fine.

Check your excel security settings to make sure it's not blocking the add in.  You can also try going to the Data Tab, selecting Edit Connections, and clicking open source on the HsTbar connection.  Usually if there's a problem, you'll get an error when you try to do that and it can point you in the right direction.

Abdul Sherif-Oracle

Yes, Supported. You could refer the article for support matrix for Smartview

Support Matrix and Compatibility FAQ (Doc ID 1923582.1)

You could check if the addin is in the 'disabled  items' under excel options -> add-ins

ChrisTurnbull

You can also look into the EXCEL> Options> Add in's and ensure the Comm ADDIN and EXCEL add in are both active (and not disabled as mentioned above).

Also you can confirm the Load Behavior in the COM Add in is set to Load at Startup, should it not be loading.

Capture.PNG

SureshM-Oracle

You can take a look into SmartView v11.1.2.5.520(Patch 22338240) readme document that states the following:

pastedImage_0.png

Chris Badenhorst

Hi

Check that ‘Disable all Application Add-ins’ is un-ticked in Excel Options => Trust Center => Add-ins

Also, put the LoadBehavior registry key value under Hyperion.CommonAddin in Registry Editor to 3

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 6 2015
Added on Jan 30 2015
1 comment
1,615 views