IV45140: AFTER DB2 UPGRADE SEE INVALD OPERATION: ERRORCODE=-4470, SQLSTATE=NULL

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as documentation error.

Error description

  • product: IBM Tivoli Business Service Manager
    release: 6.1
    
    abstact: Invald Operation: ERRORCODE=-4470, SQLSTATE=null
    
    problem: need documentation upgrade to explain how to
    avoid symptoms seen after a DB2 upgrade in TBSM environment.
    
    =======================
    error seen in trace.log
    =======================
    [6/21/13 13:49:29:951 CDT] 0000004b configclient  1
    com.micromuse.sla.configclient.MainRulesetController
    initialProcess
    ENTER^^T^[jcc][t4][10120][10898][3.57.82] Invalid operation:
    result set
    is closed. ERRORCODE=-4470, SQLSTATE=null
    
    com.micromuse.sla.common.RADException:
    [jcc][t4][10120][10898][3.57.82] Invalid operation: result set
    is
    closed. ERRORCODE=-4470, SQLSTATE=null
     at
    com.micromuse.sla.configclient.SessionTagBean.makePersistent(Ses
    sionTagB
    ean.java:2108)
    
    ==========================================================
    - can not create new tempate - when click save pop-up error.
    ==========================================================
    
    ---------------------------------------------------
    Error - Tivoli Business Service Manager          X
    ---------------------------------------------------
    
     (X)
      [jcc] [t4] [10120] [3.57.62] Invald Operation:
      results set is closed. ERROR CODE = -4470
      SQLSTATE = null
    
    
    
                                              [OK]
    -----------------------------------------------------
    
    From Level 3...
    
    Yes - please open Doc APAR.
    We need to do more investigastion as to when the fix is
    required, and if the change is on ds file (for data source) or
    JDBC props (for all).
    If this is required for DB2 9.7 FP8+ but also works for previous
    versions then change should be made in JDBC.
    Need to doc Backup file changes also and test.
    

Local fix

  • local fix
    ==========
    on the Data server, create the following file:
    
    <installdir>\tbsm\etc\TBSM_com.ibm.db2.jcc.DB2Driver.props
    
            In that file, add the following line:
    
    allowNextOnExhaustedResultSet=1
    
    
     Please note that if the above change is done while the Data
    server is running, it will be automatically picked up
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All TBSM Users                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Attempt to create newTBSM  template fromTBSM/TIP console in  *
    * Service Administration page. when clicking on  save,         *
    * processes for few seconds, the error message pops up.:       *
    *                                                              *
    * ?[jcc] [t4] [10120] [3.57.62] Invald Operation: results set  *
    * is closed. ERROR CODE = -4470 SQLSTATE = null                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * NONE                                                         *
    ****************************************************************
    pop-up message maps to the following entry on the trace log:
    
    ?[6/21/13 13:49:29:951 CDT] 0000004b configclient 1
    com.micromuse.sla.configclient.MainRulesetController
    initialProcess ENTER^^T^[jcc][t4][10120][10898][3.57.82] Invalid
    operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
    com.micromuse.sla.common.RADException:
    [jcc][t4][10120][10898][3.57.82] Invalid operation: result set
    is closed. ERRORCODE=-4470, SQLSTATE=null at
    com.micromuse.sla.configclient.SessionTagBean.makePersistent(Ses
    sionTagB ean.java:2108)
    

Problem conclusion

  • This issue is likely to be found when using DB2 9.7 Fix Pack 8
    and higher.  To resolve, on the Data server, create the
    following file:
    <installdir>\tbsm\etc\TBSM_com.ibm.db2.jcc.DB2Driver.props In
    that file, add the following line:
    
     allowNextOnExhaustedResultSet=1
    
     Please note that if the above change is done while the Data
    server is running, it will be automatically picked up
    
    The above resolution text will be included in the next pubs for
    TBSM 6.1.x in the Troubleshooting Guide.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV45140

  • Reported component name

    TIV BUS SERV MG

  • Reported component ID

    5724C5100

  • Reported release

    610

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-03

  • Closed date

    2013-08-27

  • Last modified date

    2013-08-27

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

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

Publications Referenced
GI11805709        

Fix information

Applicable component levels



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Business Service Manager

Software version:

610

Reference #:

IV45140

Modified date:

2013-08-27

Translate my page

Machine Translation

Content navigation