Monday, July 30, 2012

JDBC LLR, table verify failed for table 'WL_LLR_ADMINSERVER'

JDBC LLR, table verify failed for table 'WL_LLR_ADMINSERVER'

I had some issue with the Oracle SOA Suite domain so that tried to delete and re-create the the domain with different name by using the same schema repository.

The domain creation was successful but when starting the server i was receiving the following error.

javax.transaction.SystemException: weblogic.transaction.loggingresource.LoggingResourceException: java.sql.SQLException: JDBC LLR, table verify failed for table 'WL_LLR_ADMINSERVER', row 'JDBC LLR Domain//Server' record had unexpected value 'BLOG_DOMAIN//AdminServer' expected
'blog_domain1//AdminServer'*** ONLY the original domain and server that creates an LLR table may access it ***
        at weblogic.transaction.internal.ServerTransactionManagerImpl.registerLoggingResourceTransactions(
        at weblogic.jdbc.common.internal.RmiDataSource.recoverLoggingResourceTransactions(
        at weblogic.jdbc.common.internal.DataSourceManager.createAndStartDataSource(
        at weblogic.jdbc.common.internal.DataSourceManager.createAndStartDataSource(
        at weblogic.jdbc.module.JDBCModule.activate(
        Truncated. see log file for complete stacktrace

The issue is with the table WL_LLR_ADMINSERVER pointing to the old domain/server details.

Steps to resolve the issue

Update the table with the correct domain and the server details.


1 comment:

  1. From where will the table would be updated? I mean what is the table name, schema name etc etc.

    What does this table signifies and how to get the details of this table?