Oracle SOA - Weblogic - java.sql.SQLException: JDBC LLR weblogic.transaction.loggingresource.LoggingResourceException: java.sql.SQLException: JDBC LLR, table verify failed for table 'WL_LLR_ADMIN SERVER', row 'JDBC LLR Domain//Server' record had unexpected value 'soa_domain//AdminServer' expected 'soabpel//AdminServer'*** ONLY the or iginal domain and server that creates an LLR table may access it ***

SQL Test=SELECT 1 FROM SYS.SYSTABLES

If  database is Oracle 11g, then test SQL should be SELECT 1 FROM DUAL

This error comes when datasource not configured for Oracle DB, rather it is pointing to Derby database.

Make sure that while creating/extending the domain, on "Configure JDBC Component Schema" screen, you are selecting the checkbox against "OSB JMS Reporting Provider" and you are selecting "Oracle" as vendor. By default, "Derby" remains selected. Provide the connection details and click on next. On next screen, you test should be successful, and you should see lines similar to below -

Component Schema=OSB JMS Reporting Provider
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@localhost:1521:XE
User=DEV_SOAINFRA
Password=********
SQL Test=SELECT 1 FROM DUAL

CFGFWK-20850: Test Successful!