Fresh FMS 5.5.8 install with an external MySQL 5.1.50 install, showing the following types of errors in the FMS logs.
2011-06-27 09:48:10.951 ERROR [http-0.0.0.0-8080-2] com.quest.nitro.service.persistence.obs.handler.AbstractObservationPersister - An unexpected error occurred which may cause undesired behavior. You may want to contact Quest Software customer support if you see this error again: Prepared statement needs to be re-prepared
java.sql.SQLException: Prepared statement needs to be re-prepared
2011-06-27 09:48:10.994 ERROR [http-0.0.0.0-8080-2] org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/console].[Portal Servlet] - Servlet.service() for servlet Portal Servlet threw exception
java.lang.IllegalStateException: Error rendering part: chartMap in view: 'system:oshost.26' in top-level view: 'system:oshost.51' for user: '<user>'
…
Caused by: java.lang.RuntimeException: java.sql.SQLException: Prepared statement needs to be re-prepared
2011-06-27 12:14:39.474 ERROR [http-0.0.0.0-8080-8] com.quest.wcf.core.module.function.AbstractFunctionWithInputs - error executing script id=system:javaeejvm.108 name="'getHeapUsage - Period Average' from the System module Java EE/JVM"
message: com.quest.nitro.service.sl.interfaces.scripting.ScriptingException: com.quest.nitro.service.sl.interfaces.scripting.ScriptAbortException: script1000495: java.lang.RuntimeException: java.sql.SQLException: Prepared statement needs to be re-prepared
in view: 'system:monitor.22' in top-level view: 'system:monitor.151' for user: '<user>'
javax.script.ScriptException: com.quest.nitro.service.sl.interfaces.scripting.ScriptingException: com.quest.nitro.service.sl.interfaces.scripting.ScriptAbortException: script1000495: java.lang.RuntimeException: java.sql.SQLException: Prepared statement needs to be re-prepared
…
Caused by: java.lang.RuntimeExc
Cause
The cause for this case is unknown, after an FMS reycle to put the FMS in debug, the messages disappeared.
Resolution
The FMS service was recycled and these messages no longer appear in the logs.
Also reference https://support.quest.com/Search/SolutionDetail.aspx?id=SOL77495
Leave a Comment
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.