Hi,
(This problem I'm not sure is with Weblogic or Database, also I could not post on Weblogic forums so I opened the discussion here. Moderators if you can help me resolve opening a discussion on Weblogic forum, I would be most grateful.)
We are an application provider for some organization. Our application uses Weblogic 10.3.6 as application server, runnig with Oracle 11.2.0.4 database. In production environment, a 4-node database cluster exists with a 12-node (on 4 different physical machines) Weblogic cluster. They are running on AIX 7.1.
We are having some troubles with XA-transactions. Our application uses XA to ensure atomic commit/rollback on different areas of database. During the Pilot phase, as the administrator of Pilot environment, I used to get ORA-01591 from time to time, and I was able to resolve it by either force commit or force rollback the pending local transaction. But now our client is getting this error on Production environment Application logs very frequently, but the table dba_2pc_pending is empty and there is no pending transaction in there.
We have asked some consultants and experts to look in, but they haven't been able to resolve it. Also we had some long-running queries on a key table (which gets updated with almost any XA transaction) due to the number of indexes on some tables. I suspected the issue of in-doubt might be that. Now we've fixed the table and our query is running fine, but we still getting ORA-01591 error in app logs and database shows nothing.
Can this be any related to some timeout configuration on both sides (Weblogic and Database)? Is there any way to track these transactions to find out the root cause? Let me know if you have more questions about the status or if you need more information.