When
we are creating multiple domains in the same server and trying to run Oracle
SOA Server, we gets the below error because the old domain was updated in the
database and expecting the new domain value.
Below
are the exception details.
javax.transaction.
registerLoggingResourceTransac
weblogic.transaction.
weblogic.transaction.
java.sql.SQLException: JDBC LLR, table verify failed for table
<schema>.WL_LLR_SOA_SERVER1', row 'JDBC LLR Domain//Server' record had
unexpected value <old domain>//soa_server1' expected
'<new domain>//soa_server1' ONLY the original domain and server that creates an
LLR table may access it
registerLoggingResourceTransac
weblogic.transaction.
weblogic.transaction.
java.sql.SQLException: JDBC LLR, table verify failed for table
<schema>.WL_LLR_SOA_SERVER1', row 'JDBC LLR Domain//Server' record had
unexpected value <old domain>//soa_server1' expected
'<new domain>//soa_server1' ONLY the original domain and server that creates an
LLR table may access it
Solution:
- Update the database with new domain entries and restart the SOA Server
Command
:-
update
<Shema>.WL_LLR_SOA_SERVER1 set RECORDSTR = '<New Domain>//soa_server1'
where XIDSTR = 'JDBC LLR Domain//Server'
where XIDSTR = 'JDBC LLR Domain//Server'
Example
:-
update
MYSOA.WL_LLR_SOA_SERVER1 set RECORDSTR = 'soadomain//soa_server1'
where XIDSTR = 'JDBC LLR Domain//Server'
where XIDSTR = 'JDBC LLR Domain//Server'
I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Service-Oriented Architectures .Actually I was looking for the same information on internet for Oracle SOA and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.
ReplyDelete