com.workpoint.server.pojo.MonitorPvt.queryAlertQMonitors(java.lang.String,java.lang.String,java.math.BigDecimal,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String[],java.lang.String,boolean,java.lang.String,boolean,int,boolean) throws com.workpoint.server.ejb.WorkPointEJBException: com.workpoint.server.ejb.WorkPointEJBException: An SQL Exception has occurred. Please see the server logs for details.

Cause:

A limit has been reached on the EVALUATION_COUNT field in one of the monitor queue tables. The maximum count, according to Workpoint Support is 32765, a hard limit, so the count needs to be reset. This is likely due to one or more specific processes or activities that organically runs up the count to its limit.

Resolution:

Roll back the EVALUATION_COUNT field in the monitor queue tables to 1 if it reaches 32765 to prevent the database error.