IBM Support

SQL Server case-sensitivity support for CommonDB and BPC components

Troubleshooting


Problem

Due to the existing limitations of the components in WebSphere Process Server and WebSphere Enterprise Service Bus when configured to use Microsoft SQL Server, you need to use a case-insensitive database for the CommonDB (WPRCSDB) and a case-sensitive database for BPC (BPEDB).

Symptom

If WebSphere Process Server or WebSphere Enterprise Service Bus is configured to use Microsoft SQL Server as the common database and the database is set to be case-sensitive, you will see the following message when you access Failed Event manager using the administrative console: "The Recovery sub-system is disabled. Enable the Recovery sub-system in order to work with failed events."

An exception will be logged in the SystemOut.log as below:
Caused by: javax.resource.ResourceException: addSync: caught Exception
        at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.jav  
        at com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionManager.  
        at com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionManager.j  
        at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManage  
        at com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl.getConnection(WSR  
        at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.getConnection(WSRelati  
        at com.ibm.ws.ejbpersistence.cache.TransactionListenerImpl.getConnection  
        at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Da  
        ... 23 more                                                    
Caused by: javax.transaction.RollbackException: Transaction rolled back
        at com.ibm.ws.Transaction.JTA.TransactionImpl.registerSynchronization(Tr  
        at com.ibm.ws.Transaction.JTA.TransactionImpl.registerSynchronization(Tr  
        at com.ibm.ws.Transaction.JTA.TranMaahnagerSet.registerSynchronization(Tra
        at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.jav  
        ... 30 more                                                    
        at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)      
        ava.sql.SQLException: [IBM][SQLServer JDBC                      
Driver][SQLServer]Invalid object name 'FAILEDEVENTS'.DSRA0010E: SQL    
State = 42S02t                                                          
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)            
Caused by: java.sql.SQLException: [IBM][SQLServer JDBC                  
Driver][SQLServer]Invalid object name 'FAILEDEVENTS'.DSRA0010E: SQL    
Strate = 42S02, Error Code = 208                                        
        ... 43 more                                                    
---- Begin backtrace for Nested Throwables
java.sql.SQLException: [IBM][SQLServer JDBC
Driver][SQLServer]Statement(s) could not be prepared.

Cause

Current limitations for SQL Server database support are detailed below for WebSphere Process Server and WebSphere Enterprise Service Bus products:

  • Components such as Recovery or Relationships, which use WPRCSDB as the database do not support case-sensitive database for SQL Server. Therefore, WPRCSDB must be created as a case-insensitive database.
  • The BPEDB database used by Business Process Choreographer must be case-sensitive. Therefore, if you are using Microsoft SQL Server for the WPRCSDB database, you must have a separate case-sensitive BPEDB database.

Resolving The Problem

Use a case-insensitive database for the CommonDB (WPRCSDB) and a case-sensitive database for BPC (BPEDB).

[{"Product":{"code":"SSQH9M","label":"WebSphere Process Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Common DB","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"},{"code":"PF012","label":"IBM i"}],"Version":"7.0.0.1;7.0;6.2.0.2;6.2.0.1;6.2","Edition":"NA","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SS7J6S","label":"WebSphere Enterprise Service Bus"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"","label":"i5\/OS"},{"code":"PF016","label":"Linux"},{"code":"","label":"Linux iSeries"},{"code":"","label":"Linux pSeries"},{"code":"","label":"Linux xSeries"},{"code":"","label":"Linux zSeries"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"7.0.0.1;7.0;6.2.0.2;6.2.0.1;6.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
23 June 2018

UID

swg21415787

Page Feedback