Bug #595
BV connection to Oracle problem again
| Status: | Development / Work In Progress | Start date: | October 27, 2010 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | - | % Done: | 0% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
This morning I saw this happening again in the logs at 8:10am:
27 Oct 2010 08:08:29 -- WARN -- XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=tucsvrbv001/1591148, BranchQual=, localId=1591148] errorCode=XA_RBROLLBACK
org.jboss.resource.connectionmanager.JBossLocalXAException: could not commit local tx; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: ORA-03114: not connected to ORACLE
))
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:912)
Also, the daily student sync normally take 40mins to run, but now it is taking 1 hour 45min since beginning of this month and I only notice it now. The problem lies at the 2nd stage of the sync where it is doing the profiling. Normally it processes 6~7 accounts per second, now it is processing only 2~3 accounts per second.
You can refer the log file in attachment
History
#1 Updated by Anonymous almost 14 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
Issue could be due to network connection between App & DB servers. Further monitoring by Taylors on this matter