Symptoms: On very rare occasions the following error may be observed after attempting to restart the Tomcat service: [12-02-16 11:41:19]
WARN main com.agiliance.dal.persistence. HibernateUtil? - Commiting back the orphaned transaction! [12-02-16 11:41:19] WARN main com.agiliance.dal.persistence. HibernateUtil? - Closing the orphaned session! [12-02-16 11:41:45] WARN main com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager - An attempt to create an automatic test table failed. Create SQL: CREATE TABLE "AGL_AUTO_TEST_TABLE" ( a CHAR(1) ) java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver. DatabaseError? .newSQLException( DatabaseError? .java:133) at oracle.jdbc.driver. DatabaseError? .throwSqlException( DatabaseError? .java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at The Tomcat service fails to start as a result of this error. Tomcat will only restart successfully after, first, dropping the AGL_AUTO_TEST_TABLE.
This issue may only occur when RiskVision is installed on an Oracle database.
Resolution: This issue is believed to occur when the RiskVision database performance is very slow. Set the database.oracle.user.readonly=true property in the agiliance.properties file and restart Tomcat.