IBM Support

PH39925: DURING UPGRADE PROCESS, THE DB SCRIPTS FOR THE SCHEMA FAILS.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • During upgrade process, the db scripts for the schema fails.
Due to a custom configuration, there was a duplicate OPENPAGE
RPS_SQL_STMT_PARTS table in another schema. This caused the
8.2.0.3 upgrade to fail.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* OpenPages Users                                              *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* DURING UPGRADE PROCESS, THE DB SCRIPTS FOR THE SCHEMA FAILS. *
****************************************************************
* RECOMMENDATION:                                              *
* Customers should download OpenPages with Watson 8.2 Fix Pack *
* 4 (8.2.0.4). See the following document for details on       *
* obtaining OpenPages 8.2.0.4:                                 *
* https://www.ibm.com/support/pages/openpages-watson-82-fix-pa *
* ck-4                                                         *
****************************************************************

    



Problem conclusion


    

  • We fixed an issue to correct duplicate table name in diff
schemas.  It was being filtered out using current schema user
name in the filter.

Customers should download OpenPages with Watson 8.2 Fix Pack 4
(8.2.0.4). See the following document for details on obtaining
OpenPages 8.2.0.4:
https://www.ibm.com/support/pages/openpages-watson-82-fix-pack-4

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH39925
    • 

  • Reported component name
    OPENPAGES GRC
    • 

  • Reported component ID
    5725D5100
    • 

  • Reported release
    820
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2021-08-17
    • 

  • Closed date
    2021-12-20
    • 

  • Last modified date
    2021-12-20
    • 





    

  • 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
    OPENPAGES GRC
    • 

  • Fixed component ID
    5725D5100
    • 



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFUEU","label":"OpenPages GRC Platform"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"820"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            21 December 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback