IBM Support

JR33055: DataStage Designer throws Repository Access Failure error when browsing sub-folders in the Repository tree

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • In DataStage Designer, browsing sub-folders in the Repository
tree view can fail with

"Repository Access Failure: An error occurred when retrieving
the folder content for '<folder path>'. Failure in repository
access interface".

This error has only been encountered when Oracle is used for
the Metadata Server (XMeta) repository database.  The
underlying problem is an Oracle bug which causes the following
error when XMeta executes an SQL query that contains a LIKE
clause, the LIKE pattern is specified as a parameter, and the
pattern contains multiple escaped backslashes:

"java.sql.SQLException: [IBM][Oracle JDBC
Driver][Oracle]ORA-01424: missing or illegal character following
the escape character".

This APAR is to work around the Oracle bug that is causing this
error.

Local fix

  • 



Problem summary


    

  • ****************************************************************
USERS AFFECTED:
Users of DataStage Designer
****************************************************************
PROBLEM DESCRIPTION:
In DataStage Designer, browsing sub-folders in the Repository
tree view can fail with "Repository Access Failure: An error
occurred when retrieving the folder content for '<folder
path>'.Failure in repository access interface".  This error has
only  been encountered when Oracle is used for the Metadata
Server   (XMeta) repository database. The underlying problem
is an    Oracle bug which causes the following error when
XMeta executes an SQL query that contains a LIKE clause, the
LIKE pattern is   specified as a parameter, and the pattern
contains multiple     escaped backslashes:
"java.sql.SQLException: [IBM][Oracle JDBC
Driver][Oracle]ORA-01424: missing or illegal character
followingthe escape character".
****************************************************************
RECOMMENDATION:
Apply JR33055 patch.
This fix is included in 81 Fp1
****************************************************************

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR33055
    • 

  • Reported component name
    WIS DATASTAGE
    • 

  • Reported component ID
    5724Q36DS
    • 

  • Reported release
    810
    • 

  • Status
    CLOSED  FIN
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2009-05-21
    • 

  • Closed date
    2010-01-21
    • 

  • Last modified date
    2010-01-21
    • 





    

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

    • 

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

    • 



Fix information


    



Applicable component levels


    

  • R810  PSN
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            21 January 2010
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback