Wednesday, August 7, 2013

Unable to activate JDBC store(BEA-280077)

Some customer was trying to activate JDBC store,i checked the logs and found this.

<Aug 7, 2013 4:03:23 AM CDT> <Warning> <Store> <BEA-280076> <Database table "WLStore" for store "test" is currently owned by "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=AHSOSBJDBCStore!table=WLStore}:random=5697096127807814759:timestamp=1375866194364]". Trying to wait for ownership.>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280077> <JDBC store "test" in this server is not the owner of database table "WLStore". Unexpected current owner is "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=AHSOSBJDBCStore!table=WLStore}:random=5697096127807814759:timestamp=1375866214386]", expected current owner is "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=test!table=WLStore}:random=-1796623192164004707:timestamp=1375866203282]".>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280072> <JDBC store "test" failed to open table "WLStore".
weblogic.store.io.jdbc.JDBCStoreException: [Store:280064]280077 (server="osb_server1" store="test" table="WLStore")
       at weblogic.store.io.jdbc.JDBCStoreIO.checkTableOwnership(JDBCStoreIO.java:2621)
       at weblogic.store.io.jdbc.JDBCStoreIO.getTableOwnershipLogical(JDBCStoreIO.java:2734)
       at weblogic.store.io.jdbc.JDBCStoreIO.open(JDBCStoreIO.java:495)
       at weblogic.store.internal.PersistentStoreImpl.recoverStoreConnections(PersistentStoreImpl.java:436)
       at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:423)
       Truncated. see log file for complete stacktrace>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280061> <The persistent store "test" could not be deployed: weblogic.store.io.jdbc.JDBCStoreException: open failed

weblogic.store.io.jdbc.JDBCStoreException: open failed

Cause:
 The cause of this issue is that the database table representing the store is locked by another JMS server at the same time, as is indicated by the error message. This setup of using the same underlying database table to represent more than one JDBC Store is not recommended or supported.  

Solution:
Please ensure that for each JDBC Store you set the prefix for the store to a unique value for each configured JDBC store table, as mentioned in the URL http://download.oracle.com/docs/cd/E12839_01/web.1111/e13701/store.htm#i1143431. This will ensure that each store has its own table.

No comments:

Post a Comment