Hi all,
So I deployed a workflow that I had tested and was ready to bring to my production OKM. After a some production testing, I found some errors and decided to delete the workflow. Now even though there are no instances of the any workflows on my production unit, anytime I upload a file in any folder, the system complains about not being able to run the workflow. I hadn't setup any sort of automation to run the workflow upon upload, so I have no idea why it's started this behavior. Do you have any suggestions based on the below errors??
So I deployed a workflow that I had tested and was ready to bring to my production OKM. After a some production testing, I found some errors and decided to delete the workflow. Now even though there are no instances of the any workflows on my production unit, anytime I upload a file in any folder, the system complains about not being able to run the workflow. I hadn't setup any sort of automation to run the workflow upon upload, so I have no idea why it's started this behavior. Do you have any suggestions based on the below errors??
Code: Select all
Also, when I try to re-upload a new version of the workflow, it now automatically starts the workflow whenever a file is uploaded in any folder. I have no idea how this started, it's not in my testing environment at all. This is all the the catalina.log shows.2016-10-25 17:19:40,056 [http-apr-0.0.0.0-8080-exec-19] ERROR com.openkm.servlet.frontend.WorkflowServlet-
java.lang.NullPointerException
at com.openkm.module.common.CommonWorkflowModule.getProcessDefinitionForms(CommonWorkflowModule.java:225)
at com.openkm.module.db.DbWorkflowModule.getProcessDefinitionForms(DbWorkflowModule.java:178)
at com.openkm.api.OKMWorkflow.getProcessDefinitionForms(OKMWorkflow.java:102)
at com.openkm.servlet.frontend.WorkflowServlet.getProcessDefinitionFormsByName(WorkflowServlet.java:232)
at sun.reflect.GeneratedMethodAccessor16683.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
2016-10-25 17:20:00,102 [Thread-3964] INFO com.openkm.extractor.TextExtractorWorker- processSerial.Working on {docUuid=c0e3c0d5-3c6c-4180-94cb-1b8048cfe24a, docPath=/okm:root/Production/System Packets/15 - Univ of Oklahoma - S12006021411-15/Testing Data/Sapphire Blue LDP.1168047.519887/Overnight cycle test/Current.txt, docVerUuid=bd1e046c-4d19-4e88-95bc-5eb3250a43c5, date=Wed Dec 23 16:29:42 PST 2015}
2016-10-25 17:20:06,124 [Thread-3964] WARN org.hibernate.util.JDBCExceptionReporter- SQL Error: 0, SQLState: S1000
2016-10-25 17:20:06,124 [Thread-3964] ERROR org.hibernate.util.JDBCExceptionReporter- Packet for query is too large (6163170 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
2016-10-25 17:20:06,124 [Thread-3964] WARN com.openkm.extractor.TextExtractorWorker- could not update: [com.openkm.dao.bean.NodeDocument#c0e3c0d5-3c6c-4180-94cb-1b8048cfe24a]
com.openkm.core.DatabaseException: could not update: [com.openkm.dao.bean.NodeDocument#c0e3c0d5-3c6c-4180-94cb-1b8048cfe24a]
at com.openkm.dao.NodeDocumentDAO.textExtractorHelper(NodeDocumentDAO.java:1393)
at com.openkm.extractor.TextExtractorWorker.processSerial(TextExtractorWorker.java:164)
at com.openkm.extractor.TextExtractorWorker.processQueue(TextExtractorWorker.java:149)
at com.openkm.extractor.TextExtractorWorker.run(TextExtractorWorker.java:100)
at sun.reflect.GeneratedMethodAccessor12791.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bsh.Reflect.invokeMethod(Reflect.java:134)
at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
at bsh.Interpreter.eval(Interpreter.java:645)
at bsh.Interpreter.eval(Interpreter.java:739)
at bsh.Interpreter.eval(Interpreter.java:728)
at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.GenericJDBCException: could not update: [com.openkm.dao.bean.NodeDocument#c0e3c0d5-3c6c-4180-94cb-1b8048cfe24a]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2613)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2495)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2822)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
at com.openkm.dao.HibernateUtil.commit(HibernateUtil.java:303)
at com.openkm.dao.NodeDocumentDAO.textExtractorHelper(NodeDocumentDAO.java:1388)
... 18 more
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (6163170 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3249)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2595)
... 31 more
Code: Select all
Thank you all so much in advance, this issue is driving me crazy!2016-10-25 17:47:24,915 [http-apr-0.0.0.0-8080-exec-5] INFO com.openkm.util.FormUtils$LocalResolver- resolveEntity(publicId=-//OpenKM//DTD Workflow Forms 2.5//EN, systemId=http://www.openkm.com/dtd/workflow-forms-2.5.dtd) => F:\OpenKM\tomcat\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.5.dtd
2016-10-25 17:47:25,008 [http-apr-0.0.0.0-8080-exec-4] WARN org.hibernate.engine.StatefulPersistenceContext.ProxyWarnLog- Narrowing proxy to class org.jbpm.graph.node.StartState - this operation breaks ==
2016-10-25 17:47:25,039 [http-apr-0.0.0.0-8080-exec-4] WARN org.hibernate.engine.StatefulPersistenceContext.ProxyWarnLog- Narrowing proxy to class org.jbpm.graph.node.TaskNode - this operation breaks ==
2016-10-25 17:47:25,102 [http-apr-0.0.0.0-8080-exec-10] WARN org.hibernate.engine.StatefulPersistenceContext.ProxyWarnLog- Narrowing proxy to class org.jbpm.graph.node.TaskNode - this operation breaks ==
2016-10-25 17:47:29,111 [http-apr-0.0.0.0-8080-exec-9] INFO com.openkm.util.FormUtils$LocalResolver- resolveEntity(publicId=-//OpenKM//DTD Workflow Forms 2.5//EN, systemId=http://www.openkm.com/dtd/workflow-forms-2.5.dtd) => F:\OpenKM\tomcat\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.5.dtd
2016-10-25 17:47:29,158 [http-apr-0.0.0.0-8080-exec-2] WARN org.hibernate.engine.StatefulPersistenceContext.ProxyWarnLog- Narrowing proxy to class org.jbpm.graph.node.StartState - this operation breaks ==
2016-10-25 17:47:29,173 [http-apr-0.0.0.0-8080-exec-2] WARN org.hibernate.engine.StatefulPersistenceContext.ProxyWarnLog- Narrowing proxy to class org.jbpm.graph.node.TaskNode - this operation breaks ==
2016-10-25 17:47:29,205 [http-apr-0.0.0.0-8080-exec-10] WARN org.hibernate.engine.StatefulPersistenceContext.ProxyWarnLog- Narrowing proxy to class org.jbpm.graph.node.TaskNode - this operation breaks ==