Tersus: Failed to generate sequence number

Failed to generate sequence numberDate: Oct 15, 2012Hi,I'm running an application developed on Tersus Studio 2.0.3.1 and running on server 2.0.3.1. Have attached tersus log belowAll along the system already in production was running fine until today.
Somehow there's some problem generating sequence number.
Was wondering if there is some corruption of files for Tersus server?Have tried restarting Apache web server, restarting Mysql server, rebooting server, but to no avail.<System info>OS - Windows 2008 64-bit
Apache Tomcat/6.0.29
Mysql ver 5.1
JVM 1.6.0_33-b05Please help.
Thanks

Regards
Cliff ERROR 2012-10-15 14:36:29,567 [http-8080-2] Request ID:20121015-14:35:38:215 [http-8080-2]
Error Location:My Application Here/Logged-In Pane/Main View/Split Pane/Right Pane/DocOpsPane/TreeDispAndMgt/Header Row/Add File/AddFileDialog/Add File/Footer/Save/InsertNewDocAndFile/Sequence Number
Servlet Path:/Service
Request URL:http://192.168.110.103:8080/DMSTest/Service
Process Type:Service
Base Model Id:DMS/Application Pane/Application Pane
Process Path:My Application Here/Logged-In Pane/Main View/Split Pane/Right Pane/DocOpsPane/TreeDispAndMgt/Header Row/Add File/AddFileDialog/Add File/Footer/Save/InsertNewDocAndFile
Process Model Id:DocMgtSys/Main View/Split Pane/Right Pane/DocOpsPane/TreeDispAndMgt/Add File/Create Document 2/Save/InsertNewDocAndFile/InsertNewDocAndFile

Failed to generate sequence number
Details:
Table = Sequence_Numbers, Key = Sequence Number
    at tersus.plugins.database.SequenceNumber.nextSequenceNumber(SequenceNumber.java:134)
    at tersus.plugins.database.SequenceNumber.start(SequenceNumber.java:63)
    at tersus.runtime.FlowHandler.doStart(FlowHandler.java:118)
    at tersus.runtime.Plugin.doStart(Plugin.java:37)
    at tersus.runtime.SubFlowHandler.invoke(SubFlowHandler.java:85)
    at tersus.runtime.CompositeFlowHandler.run(CompositeFlowHandler.java:152)
    at tersus.runtime.CompositeFlowHandler.start(CompositeFlowHandler.java:85)
    at tersus.runtime.FlowHandler.doStart(FlowHandler.java:118)
    at tersus.runtime.CompositeFlowHandler.doStart(CompositeFlowHandler.java:295)
    at tersus.runtime.RuntimeContext.runProcess(RuntimeContext.java:1228)
    at tersus.webapp.Engine.callService(Engine.java:1392)
    at tersus.webapp.Engine.handleJavascriptRequest(Engine.java:1233)
    at tersus.webapp.Engine.handleRequest(Engine.java:212)
    at tersus.webapp.Engine.doPost(Engine.java:166)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at tersus.webapp.Engine.service(Engine.java:1626)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at tersus.webapp.ServiceFilter.doFilter(ServiceFilter.java:93)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
    at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1722)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at tersus.runtime.RuntimeContext.executeQuery(RuntimeContext.java:1054)
    at tersus.plugins.database.SequenceNumber.nextSequenceNumber(SequenceNumber.java:88)
    ... 32 more
ERROR 2012-10-15 14:36:29,568 [http-8080-2] Error while executing process (type=/Service)
Error Location:My Application Here/Logged-In Pane/Main View/Split Pane/Right Pane/DocOpsPane/TreeDispAndMgt/Header Row/Add File/AddFileDialog/Add File/Footer/Save/InsertNewDocAndFile/Sequence Number

Failed to generate sequence number
Details:
Table = Sequence_Numbers, Key = Sequence Number
    at tersus.plugins.database.SequenceNumber.nextSequenceNumber(SequenceNumber.java:134)
    at tersus.plugins.database.SequenceNumber.start(SequenceNumber.java:63)
    at tersus.runtime.FlowHandler.doStart(FlowHandler.java:118)
    at tersus.runtime.Plugin.doStart(Plugin.java:37)
    at tersus.runtime.SubFlowHandler.invoke(SubFlowHandler.java:85)
    at tersus.runtime.CompositeFlowHandler.run(CompositeFlowHandler.java:152)
    at tersus.runtime.CompositeFlowHandler.start(CompositeFlowHandler.java:85)
    at tersus.runtime.FlowHandler.doStart(FlowHandler.java:118)
    at tersus.runtime.CompositeFlowHandler.doStart(CompositeFlowHandler.java:295)
    at tersus.runtime.RuntimeContext.runProcess(RuntimeContext.java:1228)
    at tersus.webapp.Engine.callService(Engine.java:1392)
    at tersus.webapp.Engine.handleJavascriptRequest(Engine.java:1233)
    at tersus.webapp.Engine.handleRequest(Engine.java:212)
    at tersus.webapp.Engine.doPost(Engine.java:166)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at tersus.webapp.Engine.service(Engine.java:1626)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at tersus.webapp.ServiceFilter.doFilter(ServiceFilter.java:93)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
    at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1722)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at tersus.runtime.RuntimeContext.executeQuery(RuntimeContext.java:1054)
    at tersus.plugins.database.SequenceNumber.nextSequenceNumber(SequenceNumber.java:88)
    ... 32 more
INFO 2012-10-15 14:36:29,569 [http-8080-2] Changes rolled back
See Also:

Re: Failed to generate sequence number

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...