OA CP is unavailable, it is impossible to login to the system.
UI calls in
/var/log/poa.logfail with the following error:
java.sql.SQLException: Invalid state, the Connection object is closed.
There is a DBService error preceding the exceptions in
javax.ejb.EJBTransactionRolledbackException: could not extract ResultSet Caused by: java.sql.SQLException: I/O Error: Read timed out
As a result of a service restart or an outage of some different kind on the side of MSSQL, PAU ODBC uses the old threads for DB requests without validating the connection, therefore SQL errors are faced. This case has been submitted to the Maintenance Team as internal issue with id POA-101854.
Please contact your Account Manager or Pooled Technical Associates Team (firstname.lastname@example.org) to trace the status of the issue. In order to avoid similar outages in the future, JBoss configuration should be tuned:
C:\Program Files (x86)\SWsoft\PEM\jboss-eap-6.2\standalone\configuration\standalone-full.xmlfile add the following line at the top of
Please also note recommendations related to
standalone-full.xmlcustomization from the following KB article:
#123177 Operations Automation (formerly POA 6.0) - Known Issues and limitations
Restart services on MN:
net stop pem net stop pau net start pau net start pem