My Oracle Support Banner

OdiInvokeWebService Duplicates Service Name after Upgrade of Database Hosting 11g ODI Repositories (Doc ID 2164802.1)

Last updated on JANUARY 03, 2020

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.5.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

NOTE: In the examples below, the names represent a fictitious sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.

Issue with XAI Inbound Service - OdiInvokeWebService

A procedure calling a webservice was working correctly in ODI 11.1.1.5.0. Having upgraded the database hosting the ODI repositories from 11g to 12c, and keeping ODI intact (still 11.1.1.5.0 ), when the same webservice is called after the upgrade it gives an error.

The Service name is being duplicated.

HTTP/1.1 200 OK
Date: Fri, 08 Jul 2016 21:36:17 GMT
Content-Length: 821
Content-Type: text/xml;charset=UTF-8
Set-Cookie: JSESSIONID=<SESSION_ID>; path=/; HttpOnly
X-Powered-By: Servlet/3.0 JSP/2.2
<?xml version="1.0" ?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body >
<SOAP-ENV:Fault >
<faultcode>SOAP-ENV:Client</faultcode>
<faultstring>Client Error</faultstring>
<detail>
<ouaf:Fault xmlns:ouaf="http://ouaf.oracle.com/">
<ResponseStatus>F</ResponseStatus>
<ResponseCode>1009</ResponseCode>
<ResponseText>Service &apos;CMPersonAccountBSInboundServiceCMPersonAccountBSInboundService&apos; not found in the registry</ResponseText>            <---- DUPLICATED. THEREFORE THE ERROR
<ResponseData numParm="1" text="Service &apos;CMPersonAccountBSInboundServiceCMPersonAccountBSInboundService&apos; not found in the registry" category="11011" number="1009" parm1="CMPersonAccountBSInboundServiceCMPersonAccountBSInboundService" />
null
</ouaf:Fault>
</detail>
</SOAP-ENV:Fault>
</SOAP-ENV:Body >
</SOAP-ENV:Envelope>

This is the call:

OdiInvokeWebService "-URL=#XAI_URL" "-PORT_TYPE=CMPersonAccountBSInboundServicePortType" "-OPERATION=CMPersonAccountBSInboundService" "-RESPONSE_XML_ENCODING=UTF-8" "-HTTP_USER=SYSUSER" "-HTTP_PASS=<ENCRYPTED_PASSWORD>"
<?xml version = '1.0' encoding = 'UTF8'?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<CMPersonAccountBSInboundService faultStyle="wsdl"> <--------- THE CALL IS CORRECT. NOT DUPLICATION.
………
</CMPersonAccountBSInboundService>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

 

Changes

The Oracle database hosting the ODI repositories was upgraded from 11g to 12c.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.