IBM Support

PI06974: ORACLE DATABASE ADAPTER FAILS TO USE A CUSTOM TYPE THAT IS CREATED BY ANOTHER USER AND REFERENCED BY A PUBLIC SYNONYM

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The IBM WebSphere TX Oracle database adapter will not get or
put correctly when used with a Custom Type that is created by
another user and referenced by a public synonym.

Error returned by OCIDescribeAny, errcode=4043

ORA-04043:  object XXXXXXXXXXXX does not exist

The exact same query would however works from other database
client programs such as SQL*Plus.

Local fix

  • WTXCQ - WTX00043974
PB / PB
Circumvention: None

Problem summary

  • Users Affected:
WebSphere Transformation Extender customers that define custom
Abstract Data Types (ADTs) in a schema that differs from the
user who is executing the SQL operation.

Problem Description:
When a SQL select or update operation references a fully
qualified custom type that is preceded by another user's schema,
the SQL operation fails to execute.


Platforms Affected:
All

Problem conclusion

  • Select and update operations can now be performed on Oracle ADTs
 that are defined in another user schema.  Before this fix, the
ADT could not be described unless it was defined in the same
schema as the logged in user.

Delivered in:
8.3.0.6, 8.4.0.5, 8.4.1.2

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI06974
    • 

  • Reported component name
    WEBSPHERE LAUNC
    • 

  • Reported component ID
    5724M4011
    • 

  • Reported release
    841
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2013-11-27
    • 

  • Closed date
    2013-12-20
    • 

  • Last modified date
    2014-02-06
    • 





    

  • 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
    WEBSPHERE LAUNC
    • 

  • Fixed component ID
    5724M4011
    • 



Applicable component levels


    

  • R830  PSY
       UP
    • 

  • R840  PSY
       UP
    • 

  • R841  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.4.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            06 February 2014
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback