osdWsdlRegenerator Throws ORA-01403 Errors and Fails to Write Multiple Address:Port Combinations to WSDL Files

(Doc ID 2298323.1)

Last updated on AUGUST 18, 2017

Applies to:

Oracle Communications Convergent Charging Controller - Version 6.0.0 to 6.0.1 [Release 6.0]
Information in this document applies to any platform.

Symptoms

On all versions of Oracle Communications Convergent Charging Controller (OC3C), two related issues exist in Open Services Development (OSD) when trying to save configuration changes to the OSD screens.

1. An ORA-01403 error is thrown in the osdWsdlRegenerator log

osdWsdlRegenerator(12746) ERROR: {1101018} Oracle error 1403 received trying to fetch from OSD_PORT_LIST_ENTRY

2. When multiple Service Logic Controller (SLC) addresses and ports are configured in the OSD "Service Providers → SLC Ports" sub screen, the resulting Web Service Definition Language (WSDL) file does not contain each SLC Address and Port combination.

For example, when the following is configured in the screens:

SQL> select * from OSD_PORT_LIST_ENTRY;

        ID  PORT_LIST       PORT INTERNAL_ADDRESS      INTERFACE_NAME
---------- ---------- ---------- --------------------- --------------------
         1          2       7000 1.2.3.4               osdInterface
         2          2       7000 1.2.3.5               osdInterface
        21          2       7000 1.2.3.6               osdInterface
        26          2       7000 1.2.3.7               osdInterface
        24          2       7000 1.2.3.8               osdInterface
        25          2       7000 1.2.3.9               osdInterface

The WSDL will still only contain the following connection information:

<service name="Service_1">
  <port name="Service_1Port1" binding="tns:Service_1Binding">
    <soap:address location="http://1.2.3.4:7000"/>
  </port>
</service>

Issue 1 has no external impact beyond an unsightly error in the logs whereas issue 2 writes a WSDL file that once imported into an Application Service Provider (ASP), fails to list all the available sockets which traffic can be sent to.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms