ORACLE SErvice Bus OWSM EXtension-11.1.1.4{Oracle_OSB1}
as shown in the diagram below.
now once you set up is complete you tried to start your OSB admin server and you are getting following error message at your end.
<Apr 26, 2011 3:08:15 PM IST> <Warning> <JDBC> <BEA-001110> <No test table set u
p for pool "wlsbjmsrpDataSource". Connections will not be tested.>
<Apr 26, 2011 3:08:15 PM IST> <Warning> <JDBC> <BEA-001552> <The Logging Last Re
source (LLR) data source wlsbjmsrpDataSource will not function when it is a part
icipant in a global transaction that spans multiple WebLogic Server instances be
cause remote JDBC support is disabled. LLR will function in single-server config
urations.>
<Apr 26, 2011 3:08:17 PM IST> <Critical> <JTA> <BEA-110482> <A logging last reso
urce failed during initialization. The server cannot boot unless all configured
logging last resources (LLRs) initialize. Failing reason:
weblogic.transaction.loggingresource.LoggingResourceException: java.sql.SQLExcep
tion: JDBC LLR, table verify failed for table 'WL_LLR_ADMINSERVER', row 'JDBC LL
R Domain//Server' record had unexpected value 'soa_domain//AdminServer' expected
'OSB_domain//AdminServer'*** ONLY the original domain and server that creates a
n LLR table may access it ***
weblogic.transaction.loggingresource.LoggingResourceException: java.sql.SQLExcep
tion: JDBC LLR, table verify failed for table 'WL_LLR_ADMINSERVER', row 'JDBC LL
R Domain//Server' record had unexpected value 'soa_domain//AdminServer' expected
'OSB_domain//AdminServer'*** ONLY the original domain and server that creates a
n LLR table may access it ***
at weblogic.jdbc.wrapper.JTSLoggableResourceImpl.recoverXARecords(JTSLog
gableResourceImpl.java:248)
at weblogic.transaction.internal.ServerTransactionManagerImpl.registerLo
ggingResourceTransactions(ServerTransactionManagerImpl.java:747)
at weblogic.jdbc.common.internal.RmiDataSource.recoverLoggingResourceTra
nsactions(RmiDataSource.java:302)
at weblogic.jdbc.common.internal.DataSourceManager.createAndStartDataSou
rce(DataSourceManager.java:148)
at weblogic.jdbc.common.internal.DataSourceManager.createAndStartDataSou
rce(DataSourceManager.java:97)
Truncated. see log file for complete stacktrace
Caused By: java.sql.SQLException: JDBC LLR, table verify failed for table 'WL_LL
R_ADMINSERVER', row 'JDBC LLR Domain//Server' record had unexpected value 'soa_d
omain//AdminServer' expected 'OSB_domain//AdminServer'*** ONLY the original doma
in and server that creates an LLR table may access it ***
at weblogic.jdbc.wrapper.JTSLoggableResourceTable.newVerifyException(JTS
LoggableResourceTable.java:244)
at weblogic.jdbc.wrapper.JTSLoggableResourceTable.findOrCreateTable(JTSL
oggableResourceTable.java:327)
at weblogic.jdbc.wrapper.JTSLoggableResourceImpl.findOrCreateBackingTabl
e(JTSLoggableResourceImpl.java:528)
at weblogic.jdbc.wrapper.JTSLoggableResourceImpl.recoverXARecords(JTSLog
gableResourceImpl.java:241)
at weblogic.transaction.internal.ServerTransactionManagerImpl.registerLo
ggingResourceTransactions(ServerTransactionManagerImpl.java:747)
Truncated. see log file for complete stacktrace
>
<Apr 26, 2011 3:08:17 PM IST> <Critical> <JTA> <BEA-110482> <A logging last reso
urce failed during initialization. The server cannot boot unless all configured
logging last resources (LLRs) initialize. Failing reason:
, table verify failed for table
'WL_LLR_ADMINSERVER', row 'JDBC LLR Domain//Server' record had unexpected value
'soa_domain//AdminServer' expected 'OSB_domain//AdminServer'*** ONLY the origin
al domain and server that creates an LLR table may access it ***
javax.transaction.SystemException: weblogic.transaction.loggingresource.LoggingR
esourceException: java.sql.SQLException: JDBC LLR, table verify failed for table
'WL_LLR_ADMINSERVER', row 'JDBC LLR Domain//Server' record had unexpected value
'soa_domain//AdminServer' expected 'OSB_domain//AdminServer'*** ONLY the origin
al domain and server that creates an LLR table may access it ***
at weblogic.transaction.internal.ServerTransactionManagerImpl.registerLo
ggingResourceTransactions(ServerTransactionManagerImpl.java:752)
at weblogic.jdbc.common.internal.RmiDataSource.recoverLoggingResourceTra
nsactions(RmiDataSource.java:302)
at weblogic.jdbc.common.internal.DataSourceManager.createAndStartDataSou
rce(DataSourceManager.java:148)
at weblogic.jdbc.common.internal.DataSourceManager.createAndStartDataSou
rce(DataSourceManager.java:97)
at weblogic.jdbc.module.JDBCModule.activate(JDBCModule.java:359)
Truncated. see log file for complete stacktrace
Caused By: weblogic.transaction.loggingresource.LoggingResourceException: java.s
ql.SQLException: JDBC LLR, table verify failed for table 'WL_LLR_ADMINSERVER', r
ow 'JDBC LLR Domain//Server' record had unexpected value 'soa_domain//AdminServe
r' expected 'OSB_domain//AdminServer'*** ONLY the original domain and server tha
t creates an LLR table may access it ***
at weblogic.jdbc.wrapper.JTSLoggableResourceImpl.recoverXARecords(JTSLog
gableResourceImpl.java:248)
at weblogic.transaction.internal.ServerTransactionManagerImpl.registerLo
ggingResourceTransactions(ServerTransactionManagerImpl.java:747)
at weblogic.jdbc.common.internal.RmiDataSource.recoverLoggingResourceTra
nsactions(RmiDataSource.java:302)
at weblogic.jdbc.common.internal.DataSourceManager.createAndStartDataSou
rce(DataSourceManager.java:148)
at weblogic.jdbc.common.internal.DataSourceManager.createAndStartDataSou
rce(DataSourceManager.java:97)
Truncated. see log file for complete stacktrace
Caused By: java.sql.SQLException: JDBC LLR, table verify failed for table 'WL_LL
R_ADMINSERVER', row 'JDBC LLR Domain//Server' record had unexpected value 'soa_d
omain//AdminServer' expected 'OSB_domain//AdminServer'*** ONLY the original doma
in and server that creates an LLR table may access it ***
at weblogic.jdbc.wrapper.JTSLoggableResourceTable.newVerifyException(JTS
LoggableResourceTable.java:244)
at weblogic.jdbc.wrapper.JTSLoggableResourceTable.findOrCreateTable(JTSL
oggableResourceTable.java:327)
at weblogic.jdbc.wrapper.JTSLoggableResourceImpl.findOrCreateBackingTabl
e(JTSLoggableResourceImpl.java:528)
at weblogic.jdbc.wrapper.JTSLoggableResourceImpl.recoverXARecords(JTSLog
gableResourceImpl.java:241)
at weblogic.transaction.internal.ServerTransactionManagerImpl.registerLo
ggingResourceTransactions(ServerTransactionManagerImpl.java:747)
Truncated. see log file for complete stacktrace
>
<Apr 26, 2011 3:08:17 PM IST> <Error> <Deployer> <BEA-149231> <Unable to set the
activation state to true for the application 'wlsbjmsrpDataSource'.
weblogic.application.ModuleException:
at weblogic.jdbc.module.JDBCModule.activate(JDBCModule.java:362)
at weblogic.application.internal.flow.ModuleListenerInvoker.activate(Mod
uleListenerInvoker.java:227)
at weblogic.application.internal.flow.DeploymentCallbackFlow$2.next(Depl
oymentCallbackFlow.java:541)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:52)
at weblogic.application.internal.flow.DeploymentCallbackFlow.activate(De
ploymentCallbackFlow.java:175)
Truncated. see log file for complete stacktrace
Caused By: java.sql.SQLException: JDBC LLR, table verify failed for table 'WL_LL
R_ADMINSERVER', row 'JDBC LLR Domain//Server' record had unexpected value 'soa_d
omain//AdminServer' expected 'OSB_domain//AdminServer'*** ONLY the original doma
in and server that creates an LLR table may access it ***
at weblogic.jdbc.wrapper.JTSLoggableResourceTable.newVerifyException(JTS
LoggableResourceTable.java:244)
at weblogic.jdbc.wrapper.JTSLoggableResourceTable.findOrCreateTable(JTSL
oggableResourceTable.java:327)
at weblogic.jdbc.wrapper.JTSLoggableResourceImpl.findOrCreateBackingTabl
e(JTSLoggableResourceImpl.java:528)
at weblogic.jdbc.wrapper.JTSLoggableResourceImpl.recoverXARecords(JTSLog
gableResourceImpl.java:241)
at weblogic.transaction.internal.ServerTransactionManagerImpl.registerLo
ggingResourceTransactions(ServerTransactionManagerImpl.java:747)
Truncated. see log file for complete stacktrace
>
Here OSB_domain is the name of my domain which i have created and trying to start as shown below.
This issue occurs because by default RECORDSTR in WL_LLR_ADMINSERVER is set to
'JDBC LLR Domain//Server' and when we create a new domain it just contradict with the name of the domain.We can esily get rid of this by either delete the record itslelf before the installation or we can just update it using the following command
update WL_LLR_ADMINSERVER set RECORDSTR = 'OSB_domain//AdminServer' where XIDSTR= 'JDBC LLR Domain//Server';
commit;
Here OSB_domain in the name of my domain inyou case you have to replace this value with the name of your domain.
Once you change this try to restart the server and it will run fine.
Once more thing you have to log in to your SOAINFRA schema to perform this action as shown below
No comments:
Post a Comment