IBM Support

IC82429: USER DEFINED TYPE NOT FOUND ERROR WHEN USING COMPLEX ORACLE DATA TYPES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In Oracle when there is a complex structure or program package
    defined within a schema, and there is a public synonym defined
    to all allow global access to the structure and program package,
    DataPower will return the following error if the SQL
    Data Source object has a schema/user name that is not the owning
    schema of the artifacts.
    [sql][error] sql-source(sqlMyTest): tid(55480): Database
    reported query
    error: User defined type not found: DP.MYLIST
    
    Here user "Bob" owned the artifacts while schema/user of ?DP? on
    the DataPower SQL Data Source object resulted in this error.
    

Local fix

  • Utilize the userid/schema name in the SQL Data Source Object
    that owns the complex structure.
    

Problem summary

  • Affected is the use of DataPower with an Oracle database.
    
    Under certain circumstances, stored procedures invoked using
    public synonyms would fail to run properly.
    

Problem conclusion

  • Stored procedures can be run using public synonyms to refer to a
    schema, package, or stored procedure itself in DataPower
    fixpacks 4.0.2.8, 5.0.0.1, and follow on fixpacks. This fix only
    applies to invoking the stored procedure itself; synonyms are
    not supported for procedure parameter types.
    
    Fix is available in 4.0.2.8 and 5.0.0.1
    

Temporary fix

  • Invoke the stored procedure directly using its fully qualified
    name.
    

Comments

APAR Information

  • APAR number

    IC82429

  • Reported component name

    DATAPOWER BLAD

  • Reported component ID

    DPBLADE01

  • Reported release

    382

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-02

  • Closed date

    2012-06-25

  • Last modified date

    2012-11-15

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DATAPOWER BLAD

  • Fixed component ID

    DPBLADE01

Applicable component levels

  • R402 PSY

       UP

  • R500 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFGB5","label":"WebSphere DataPower Integration Blade XI50B"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.8.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
15 November 2012