IBM Support

JR48073: SCHEMAGENERATOR FOR SAVED SEARCH OPTIMIZATION GENERATES INVALID SQL ON ORACLE AND DB2.

Fixes are available

Version 8.5 Refresh Pack 5 for the IBM Business Process Manager products
Download Version 8.0.1 Fix Pack 3 for the IBM Business Process Manager products

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The generated screen output or SQL file of the SchemaGenerator
shell script is incorrect. If it is performed against the BPM
database, then it fails in the creation of the Stored Procedure.

Local fix

  • manually modify the script

Problem summary

  • The generated screen output or SQL file of the SchemaGenerator
shell script is incorrect.  If it is performed against the BPM
database, then it fails in the creation of the Stored Procedure.

PROBLEM DETAILED DESCRIPTION:
Stored procedure definitions in SQL files needs a special
handling, which is different for the RDBMS provider.  The SQL
file generated by the SchemaGenerator has generated the stored
procedure part incorrectly.

Problem conclusion

  • The SchemaGenerator generates the stored procedure RDBMS
specific now.

FIX AVAILABILITY:
iFix for 8.0.0.0 is available on Fix Central, search for APAR
JR48073 at http://www.ibm.com/support/fixcentral/
Fix is also targetted for inclusion in next fixpack for BPM
8.0.1

When obtaining any of the above fixes, be sure to download the
accompanying readme, for itself, and any prerequisite fixes, and
review them thorougly.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR48073
    • 

  • Reported component name
    BPM STANDARD
    • 

  • Reported component ID
    5725C9500
    • 

  • Reported release
    800
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2013-10-15
    • 

  • Closed date
    2014-01-22
    • 

  • Last modified date
    2014-01-22
    • 





    

  • 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
    BPM STANDARD
    • 

  • Fixed component ID
    5725C9500
    • 



Applicable component levels


    

  • R800  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            22 January 2014
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback