New Performance Improvements

If this doesn't work and Procentive is still slow is there something else we can do? There is a lot of lag time even after we have cleared the browsers. there is issues from switching modules and notes and appointments saving. Any help would be greatly appreciated as staff are having a difficult time assisting clients.

thank you 

Teresa 

Ashley, is the DHS eligibility system different from the MN-ITS site? I've being using the MN-ITS site all morning and haven't had any issues. 

Ashley, I have cleared cache and rebooted twice.  Errors are still popping up everywhere, mainly Billing Module that I am concerned about today as we have a deadline of 4pm that will likely not be met at this point.  

Procentive Has Encountered an Error 

You have encountered a part of the program that is experiencing errors. Procentive makes every effort to correct errors. If this problem persists, please click the "Show Detail" button and send the contents to the Help Desk along with the following code: s501970304187. 

 

Error
Reference Number:1970304187
1
Vendor Specific Error:0
SQL State:08003
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

** BEGIN NESTED EXCEPTION ** 

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
MESSAGE: Communications link failure

Last packet sent to the server was 46636 ms ago.

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 46636 ms ago.

at sun.reflect.GeneratedConstructorAccessor128.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:408)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)

at procentive.database.Database.executeSelect(Database.java:460)

at procentive.database.RecordList.executeSQL(RecordList.java:107)

at procentive.database.RecordList.executeSQL(RecordList.java:137)

at procentive.database.RecordList.initList(RecordList.java:143)

at procentive.database.DatabaseFarm.getRecordListOnMirror(DatabaseFarm.java:337)

at procentive.database.DatabaseFarm.getRecordListOnMirror(DatabaseFarm.java:324)

at procentive.utility.GUtil.grlm(GUtil.java:2527)

at procentive.trove.database.tables.TableObject.setRecordCount(TableObject.java:198)

at procentive.trove.database.tables.TimeTableObject.executeRecordList(TimeTableObject.java:169)

at procentive.trove.database.tables.TableObject.setCommand(TableObject.java:121)

at org.apache.jsp.time2.table_jsp._jspService(table_jsp.java:152)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:335)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:219)

at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:196)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at procentive.trove.servlets.TrackerFilter.process(TrackerFilter.java:283)

at procentive.trove.servlets.TrackerFilter.doFilter(TrackerFilter.java:78)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:534)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)

at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2431)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)

... 54 more

** END NESTED EXCEPTION **

at sun.reflect.GeneratedConstructorAccessor251.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1098)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2380)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2362)
at procentive.database.Database.getSelectStatement(Database.java:334)
at procentive.database.Database.executeSelect(Database.java:440)
at procentive.database.RecordEnumeration.executeSQL(RecordEnumeration.java:113)
at procentive.database.RecordEnumeration.initList(RecordEnumeration.java:134)
at procentive.database.DatabaseFarm.getRecordEnumerationOnMirror(DatabaseFarm.java:471)
at procentive.database.DatabaseFarm.getRecordEnumerationOnMirror(DatabaseFarm.java:418)
at procentive.trove.actions.SQLHandler.process(SQLHandler.java:43)
at procentive.trove.actions.SimpleTable.process(SimpleTable.java:25)
at procentive.trove.servlets.ADispatch.dispatch(ADispatch.java:61)
at procentive.servlets.ProcentiveServlet.processHTTP(ProcentiveServlet.java:96)
at procentive.servlets.ProcentiveServlet.doPost(ProcentiveServlet.java:58)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:219)
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:196)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at procentive.trove.servlets.TrackerFilter.process(TrackerFilter.java:283)
at procentive.trove.servlets.TrackerFilter.doFilter(TrackerFilter.java:78)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:534)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2
Vendor Specific Error:0
SQL State:null
Error while executing:select REPLACE( REPLACE( wf_remindertypes.name, '', 'Project' ), '_{', 'Task' ) as remindertype, count(distinct wf_reminders.id) as num, IF( wf_tasks.procentivepriority > 0, 1, IF( wf_subtasks.procentivepriority > 0, 1, 0 ) ) AS ticketflag from wf_reminders inner join wf_remindertypes on wf_remindertypes.id = wf_reminders.remindertype LEFT OUTER JOIN wf_tasks ON wf_tasks.id = wf_reminders.record AND ( wf_remindertypes.id = 1 OR wf_remindertypes.id = 3 ) LEFT OUTER JOIN wf_subtasks ON wf_subtasks.id = wf_reminders.record AND ( wf_remindertypes.id = 2 OR wf_remindertypes.id = 4 ) where wf_reminders.staff=14789 and (wf_tasks.id is not null or wf_subtasks.id is not null) group by wf_remindertypes.id order by wf_remindertypes.name /* tracker SQLHandler:process:43/SimpleTable:process:25*/}

Ashley, thank you! I didn't even think of how that would slow the system down. We will just wait it out and do what we can. thank you for directing me.