0

New Performance Improvements

Alicia Swanson (Care Director) 3 years ago in Procentive News updated by Shauna Dall 3 years ago 5

In an effort to improve Procentive, we have been working on updates to improve your experience with speed and standard session timeout features. In order to take advantage of the new performance improvement features every user will want to clear their cache/browsing history on Thursday 03/01/2018 to allow the new updates to work properly.


If your cache is not cleared you will continue to experience undesired log offs. The new updates will not be live until  about Thursday about 5:00 am so please clear your cache/browsing history after that time.


Please note: Standard Session timeout settings are still active and will log you out if you are not active in the software based on those settings.


Clear Your Cache in Internet Explorer
Clear Your Cache in Google Chrome
Clear Your Cache in Safari


Answer

Answer

Hi Teresa,


This is actually separate from the issues being experienced today. Today's issues are directly related to DHS eligibility system not working. For more details, please review this post on the User Community.


Thank you!

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 

Answer

Hi Teresa,


This is actually separate from the issues being experienced today. Today's issues are directly related to DHS eligibility system not working. For more details, please review this post on the User Community.


Thank you!

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.