Configure BPE Container for DB2
busj...@de.ibm.com
Hi,
we are running a WS Portal 5.1 on a WS AppServer 5.1.1 with the WBISF 5.1.1 plugin.
For configuring the BPE Container to run with a db2 I used the dll Scripts provided in the WAS_HOME/Processchoreographer directory to create the Database, Tables etc. Afterwards I used the ./WPSconfig.sh bpe-unconfig task to unconfigure and the ./WPSconfig.sh bpe-config -DparentPropertie=... task to configure the process container with the values specified in the bpeconfig.properties. (if needed I can provide the values specified in the properties)
After I restart the App Server the process container runs on db2, but throws an error message in the SystemOut.log:
[6/10/05 10:57:26:649 CEST] 5cf5a84e DSConfigurati E DSRA0010E: SQL State = XJ004, Error Code = 40,000
[6/10/05 10:57:26:655 CEST] 5cf5a84e J2CXAResource W J2CA0061W: Error creating XA Connection and Resource com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a XAConnection from the DataSource. with SQL State : XJ004 SQL Code : 40000
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:261)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:173)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:210)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:914)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:675)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:732)
at com.ibm.ejs.j2c.J2CXAResourceFactory.getXAResource(J2CXAResourceFactory.java:172)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:632)
at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1377)
at com.ibm.ws.Transaction.JTA.ResyncThread.run(RecoveryManager.java:1448)
Caused by: java.sql.SQLException: Database '/opt/XYZWEBSPHEREXYZ/AppServer/ProcessChoreographer/BPEDB' not found.DSRA0010E: SQL State = XJ004, Error Code = 40,000
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:257)
... 9 more
---- Begin backtrace for nested exception
java.sql.SQLException: Database '/opt/XYZWEBSPHEREXYZ/AppServer/ProcessChoreographer/BPEDB' not found.DSRA0010E: SQL State = XJ004, Error Code = 40,000
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:257)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:173)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:210)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:914)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:675)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:732)
at com.ibm.ejs.j2c.J2CXAResourceFactory.getXAResource(J2CXAResourceFactory.java:172)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:632)
at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1377)
at com.ibm.ws.Transaction.JTA.ResyncThread.run(RecoveryManager.java:1448)
[6/10/05 10:57:26:680 CEST] 5cf5a84e XARecoveryDat W WTRN0005W: The XAResource for a transaction participant could not be recreated and transaction recovery may not be able to complete properly. The resource was J2CXAResourceInfo :
cfName = BPEDataSourceCloudscape
configProps = [Deployed Resource Adapter Properties]
TransactionResourceRegistration java.lang.String dynamic
InactiveConnectionSupport java.lang.Boolean true
secureMode boolean true
dd = [Resource Adapter DD]
ManagedConnectionFactory Class Name: com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl
Transaction Support: 2
Reauthentication Support: false
mcfProps = com.ibm.ejs.j2c.ManagedConnectionFactoryProps@147284c
mmProps = {BasicPassword=javax.resource.spi.security.PasswordCredential, authMechanismPreference=BASIC_PASSWORD}
mbeanProps = MBeanProps@6c70a84c authMechPref=0 category= factoryId=cells/XYZNODENAMEXYZ/nodes/XYZNODENAMEXYZ/servers/server1/resources.xml#DataSource_1097430411782 factoryName=WebSphere:name=BPEDataSourceCloudscape,process=server1,platform=common,node=XYZNODENAMEXYZ,JDBCProvider=Cloudscape JDBC Provider (XA),Server=server1,version=5.0,type=DataSource,mbeanIdentifier=cells/XYZNODENAMEXYZ/nodes/XYZNODENAMEXYZ/servers/server1/resources.xml#DataSource_1097430411782,cell=XYZNODENAMEXYZ jndiName=jdbc/BPEDB mbeanType=DataSource name=BPEDataSourceCloudscape parentType=JDBCProvider pmiName=null providerId=cells/XYZNODENAMEXYZ/nodes/XYZNODENAMEXYZ/servers/server1/resources.xml#JDBCProvider_db2j_2 providerName=WebSphere:name=Cloudscape JDBC Provider (XA),process=server1,platform=common,node=XYZNODENAMEXYZ,Server=server1,version=5.0,type=JDBCProvider,mbeanIdentifier=cells/XYZNODENAMEXYZ/nodes/XYZNODENAMEXYZ/servers/server1/resources.xml#JDBCProvider_db2j_2,cell=XYZNODENAMEXYZ
secureMode = true
cmConfig = [Resource-ref settings]
res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
[Other attributes]
isCMP1_x: false (not CMP1.x)
isJMS: false (not JMS)
recoveryClasspath = /opt/XYZWEBSPHEREXYZ/AppServer/lib/rsadapter.rar
baseCfName = BPEDataSourceCloudscape
The exception stack trace follows: com.ibm.ws.Transaction.XAResourceNotAvailableException: Error creating XAResource: com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA8100E: Unable to get a XAConnection from the DataSource.
at com.ibm.ejs.j2c.J2CXAResourceFactory.getXAResource(J2CXAResourceFactory.java:181)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:632)
at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1377)
at com.ibm.ws.Transaction.JTA.ResyncThread.run(RecoveryManager.java:1448)
also when the bpecontainer.jar is started the following message is logged:
[6/10/05 10:57:48:231 CEST] 4fec684f WSRelationalR W DSRA8210W: The database product name DB2/LINUX does not match the database represented by the backend ID (CLOUDSCAPE).
I am sure these messages are connected, but I don't know how to fix them :-).
Any help is greatly appreciated!