IBM Support

JR45481: METADATA WORKBENCH LINEAGE SERVICES DOES NOT CORRECTLY PARSE THE CUSTOM SQL STATMENTS

 

APAR status

  • Closed as program error.

Error description

  • MetaData Workbench (MWB) Lineage Services returns errors when
parsing the Custom SQL Statements of Oracle Connector Jobs in
order to determine the Table (Database.Schema.Table) which the
Job is reading from or writing to.  MWB uses this relationship
to display within the rendered Data Lineage Reports.  Current
status is that Lineage Reports are incomplete.

Local fix

  • 



Problem summary


    

  • Error parsing SQL for Oracle Connector Stage and DB Views

    



Problem conclusion


    

  • Applying the patch rollup_RU3_MWB_all_8700-1 will resolve the
issue

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR45481
    • 

  • Reported component name
    METADATA WORKBE
    • 

  • Reported component ID
    5724S4100
    • 

  • Reported release
    870
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2013-01-21
    • 

  • Closed date
    2013-04-10
    • 

  • Last modified date
    2013-04-10
    • 





    

  • 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
    METADATA WORKBE
    • 

  • Fixed component ID
    5724S4100
    • 



Applicable component levels


    

  • R870  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SS3GFL","label":"InfoSphere Metadata Workbench"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.7"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            17 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback