Monday, September 23, 2013

Caused By: java.sql.SQLException: JDBC LLR, table verify failed for table 'DEV2_SOAINFRA.WL_LLR_ADMINSERVER', row 'JDBC LLR Domain//Server' record had unexpected value

Some times this issue appears during server startup.

In such cases just execute the following query against the SOAINFRA Schema

select * from WL_LLR_ADMINSERVER;

Check the value for RECRORDSTR column

If it is not matching to the current domain , update the value using the below sql script

update DEV2_SOAINFRA.WL_LLR_ADMINSERVER set RECORDSTR = 'health_domain//AdminServer' where  XIDSTR  = 'JDBC LLR Domain//Server';

commit;

Another way is :

Goto  <MiddlewareHome>\user_projects\domains\<your_domain>\config

and remove the following section from the config.xml file

  <jdbc-system-resource>
    <name>wlsbjmsrpDataSource</name>
    <target>AdminServer,osb_server1</target>
    <descriptor-file-name>jdbc/wlsbjmsrpDataSource-jdbc.xml</descriptor-file-name>
  </jdbc-system-resource>

No comments:

Post a Comment