IBM Support

IT24187: CONTROL CENTER SERVER CONNECTION GOES INTO PAUSE MODE

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

  • Control Center Server connection goes into Pause mode when
DBASE maintenance is done on weekends

Local fix

  • 



Problem summary


    

  • Description of Issue:  Server is being pauses when a batch
update fails with a SQL Exception when the database is
temporarily unavailable.

    



Problem conclusion


    

  • Description of Fix:  The recovery logic is checking the batch
level SQL error codes / SQL state against DatabaseProperties.xml
 to see if a retry is needed when it needs to check the
underlying  record level SQL exception.  Modified the recovery
logic to check the error codes / SQL states of the record level
exception instead of the batch level exception.  Also added
additional logging to show the error codes / SQL state of the
exception that causes the batch not to retry to help with
debugging.

    



Temporary fix


    

  •  IT24187/R562809 (2018-02-23)
 Description of Issue:  Server is being pauses when a batch
update fails with a SQL Exception when the database is
temporarily unavailable.
 Description of Fix:  The recovery logic is checking the batch
level SQL error codes / SQL state against DatabaseProperties.xml
to see if a retry is needed when it needs to check the
underlying  record level SQL exception.  Modified the recovery
logic to check the error codes / SQL states of the record level
exception instead of the batch level exception.  Also added
additional logging to show the error codes / SQL state of the
exception that causes the batch not to retry to help with
debugging.

    



Comments


    

  • 



APAR Information




    

  • APAR number
    IT24187
    • 

  • Reported component name
    STR CONTROL CEN
    • 

  • Reported component ID
    5725D0200
    • 

  • Reported release
    610
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2018-02-23
    • 

  • Closed date
    2018-03-15
    • 

  • Last modified date
    2018-03-15
    • 





    

  • 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
    STR CONTROL CEN
    • 

  • Fixed component ID
    5725D0200
    • 



Applicable component levels


    








      
              
                            

              

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

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            15 March 2018
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback