PM85314: CWSIS1501E WHEN USING MICROSOFT SQL SERVER 2005 FOR SIB MESSAGING ENGINE DATA STORE

8.5.5.1: WebSphere Application Server V8.5.5 Fix Pack 1
8.5.5.2: WebSphere Application Server V8.5.5 Fix Pack 2
8.5.5.3: WebSphere Application Server V8.5.5 Fix Pack 3
8.5.5.4: WebSphere Application Server V8.5.5 Fix Pack 4
8.5.5.5: WebSphere Application Server V8.5.5 Fix Pack 5
8.5.5.6: WebSphere Application Server V8.5.5 Fix Pack 6
8.5.5.7: WebSphere Application Server V8.5.5 Fix Pack 7
8.5.5.8: WebSphere Application Server V8.5.5 Fix Pack 8
8.5.5.9: WebSphere Application Server V8.5.5 Fix Pack 9
8.5.5.10: WebSphere Application Server V8.5.5 Fix Pack 10
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14

APAR status

• Closed as program error.

Error description

• A Service Integration Bus (SIB) Message Engine fails to start
  when using Microsoft SQL Server 2005 for the data store.
  SibMessage    E   ME name ] CWSIS0002E: The messaging engine
  encountered an exception while starting.
  
  Exception: com.ibm.ws.sib.msgstore.PersistenceException:
  CWSIS1501E: The data source has produced an unexpected
  exception:com.microsoft.sqlserver.jdbc.SQLServerException:
  Column,parameter, or variable #5: Cannot find data type
  DATETIME2.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Users of the default messaging provider     *
  *                  for IBM WebSphere Application Server        *
  *                  version 8.5.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Messaging engine (ME) cannot start in   *
  *                      if Microsoft SQL Server 2005 is         *
  *                      configured as a datastore.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Messaging engine (ME) fails to start in WebSphere Application
  Server V8.5 if Microsoft SQL Server 2005 database is
  configured as a datastore. This is due to incompatible
  datatype "DATETIME2" which is valid from SQLServer 2008
  version and above. "DATETIME2" datatype for SQLServer was
  introduced in WebSphere Application Server V8.5 to store the
  ME's last database updated timestamp.
  This problem is only applicable with WebSphere Application
  Server V8.5 with Microsoft SQL Server version 2005 database.
  

Problem conclusion

• Source code has been modified to change the data type as
  "DATETIME" which is compatible with SQL Server 2005 version
  and above versions.
  
  The fix for this APAR is currently targeted for inclusion in
  fix pack 8.5.5.1.  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 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