IBM Support

PI31587: WEBSPHERE V8.5.5 SERVICE INTEGRATION BUS MESSAGING ENGINE FAILS TO START IF DB2 VERSION IS HIGHER THAN 10.1

Fixes are available

9.0.0.1: WebSphere Application Server traditional V9.0 Fix Pack 1
9.0.0.2: WebSphere Application Server traditional V9.0 Fix Pack 2
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
9.0.0.3: WebSphere Application Server traditional V9.0 Fix Pack 3
9.0.0.4: WebSphere Application Server traditional V9.0 Fix Pack 4
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
9.0.0.5: WebSphere Application Server traditional V9.0 Fix Pack 5
9.0.0.6: WebSphere Application Server traditional V9.0 Fix Pack 6
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
9.0.0.7: WebSphere Application Server traditional V9.0 Fix Pack 7
9.0.0.8: WebSphere Application Server traditional V9.0 Fix Pack 8
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
9.0.0.9: WebSphere Application Server traditional V9.0 Fix Pack 9
9.0.0.10: WebSphere Application Server traditional V9.0 Fix Pack 10
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
9.0.0.11: WebSphere Application Server traditional V9.0 Fix Pack 11
9.0.5.0: WebSphere Application Server traditional Version 9.0.5 Refresh Pack
9.0.5.1: WebSphere Application Server traditional Version 9.0.5 Fix Pack 1
9.0.5.2: WebSphere Application Server traditional Version 9.0.5 Fix Pack 2
8.5.5.17: WebSphere Application Server V8.5.5 Fix Pack 17
9.0.5.3: WebSphere Application Server traditional Version 9.0.5 Fix Pack 3
9.0.5.4: WebSphere Application Server traditional Version 9.0.5 Fix Pack 4
9.0.5.5: WebSphere Application Server traditional Version 9.0.5 Fix Pack 5
9.0.5.6: WebSphere Application Server traditional Version 9.0.5 Fix Pack 6

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In WebSphere Application Server v8.5.5, the Service Integration
    Bus messaging engine fails to start when the data store used
    by the messaging engine is DB2 and is of version higher than
    10.1 , Ex: 10.1.3.
    An FFDC is produced with the following stack:
    Exception:java.lang.NumberFormatException
    SourceId:com.ibm.ws.sib.msgstore.persistence.DatabaseMetaDataExt
    ensions.setDBMS ProbeId:148
    Reporter:com.ibm.ws.sib.msgstore.persistence.impl.DatabaseMetaDa
    taExtensions@29227e23
    java.lang.NumberFormatException: For input string: "1."
    atjava.lang.NumberFormatException.forInputString(NumberFormatEx
         cep tion.java:59)
    at java.lang.Integer.parseInt(Integer.java:469)
    at java.lang.Integer.parseInt(Integer.java:510)
    atcom.ibm.ws.sib.msgstore.persistence.impl.DatabaseMetaDataExte
        nsi ons.setDBMS(DatabaseMetaDataExtensions.java:387)
    atcom.ibm.ws.sib.msgstore.persistence.impl.DatabaseMetaDataExte
        nsi ons.<init>(DatabaseMetaDataExtensions.java:110)
    atcom.ibm.ws.sib.msgstore.persistence.impl.ConnectionWrapper.ge
        tMe taDataExtensions(ConnectionWrapper.java:124)
    atcom.ibm.ws.sib.msgstore.persistence.impl.WASDatasourceWrapper
        .ge tLockConnection(WASDatasourceWrapper.java:429)
    atcom.ibm.ws.sib.msgstore.persistence.impl.WASDatasourceWrapper
       .ge tConnection(WASDatasourceWrapper.java:317)
    atcom.ibm.ws.sib.msgstore.persistence.impl.DatasourceControlle
          r .pe rformFirstAction(DatasourceController.java:229)
    atcom.ibm.ws.sib.msgstore.persistence.impl.TableManager.initial
        ize (TableManager.java:248)
    atcom.ibm.ws.sib.msgstore.persistence.impl.PersistentMessageSto
        reI mpl.start(PersistentMessageStoreImpl.java:198)
    atcom.ibm.ws.sib.msgstore.impl.MessageStoreImpl.start(MessageSt
        ore Impl.java:1565)
    atcom.ibm.ws.sib.admin.impl.JsMessagingEngineImpl.start(JsMessa
        gin gEngineImpl.java:627)
    atcom.ibm.ws.sib.admin.impl.HAManagerMessagingEngineImpl.activa
        te( HAManagerMessagingEngineImpl.java:1243)
    atcom.ibm.ws.sib.admin.impl.JsActivationThread.run(JsActivation
        Thr ead.java:94)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  Users of the default messaging provider for *
    *                  IBM WebSphere Application Server            *
    ****************************************************************
    * PROBLEM DESCRIPTION: Service Integration Bus messaging       *
    *                      engine fails to start when the data     *
    *                      store is DB2 with a version having      *
    *                      more than '.' in the version number     *
    *                      like 10.1.3.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    In WebSphere Application Server v8.5.5, the Service Integration
    Bus messaging engine fails to start when the data store is a
    DB2 version having more than '.' in the version number, like
    10.1.3.
    

Problem conclusion

  • Code has been modified to extract the version number and use
    the major version only. The parsing mechanism takes into
    account that the version can have multiple decimals.
    
    The fix for this APAR is currently targeted for inclusion in
    fix packs 8.5.5.11 and 9.0.0.2.  Please refer to the
    Recommended Updates page for delivery information:
    http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI31587

  • Reported component name

    WAS SIB & SIBWS

  • Reported component ID

    620800101

  • Reported release

    855

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-12-15

  • Closed date

    2016-06-23

  • Last modified date

    2016-06-23

  • 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

    WAS SIB & SIBWS

  • Fixed component ID

    620800101

Applicable component levels

  • R850 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"855","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
14 October 2021