1
QueueMetrics news / Re: QueueMetrics 12.01 has been released today
« on: January 26, 2012, 23:47:48 »
Hello,
Looks like "#1348 - Pause code in the Payroll report" has not been fixed.
Still get the following error:
Looks like "#1348 - Pause code in the Payroll report" has not been fixed.
Still get the following error:
Code: [Select]
"Error (tech) in class 'it.loway.app.queuemetrics.payroll.pauseCodeChange'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - - Stack trace: - Problem updating DB: Database error: - -- Inner Exception -- - Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException - Error: - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 - Stack trace: - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) - at java.lang.reflect.Constructor.newInstance(Constructor.java:513) - 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:1030) - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) - 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.StatementImpl.executeUpdate(StatementImpl.java:1564) - at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485) - at it.loway.tpf.SQL.updateSql(SQL.java:164) - at it.loway.app.queuemetrics.payroll.payrollEngineMover.applyChanges(payrollEngineMover.java:222) - at it.loway.app.queuemetrics.payroll.payrollEnginePauseMover.standardizePauseInLog(payrollEnginePauseMover.java:216) - at it.loway.app.queuemetrics.payroll.payrollEnginePCodeChanger.changePauseCode(payrollEnginePCodeChanger.java:53) - at it.loway.app.queuemetrics.payroll.pauseCodeChange.doRun(pauseCodeChange.java:80) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:276) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:566) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:387) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:238) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873) - at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) - at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) - at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) - at java.lang.Thread.run(Thread.java:619) - -- End Inner Exception -- - - When running: DELETE FROM `queue_log` WHERE `partition` = 'P000' AND `time_id` = '1327596297' AND `call_id` = '1327596297.170066' AND `queue` = 'NONE' AND `agent` = 'Agent/1002' AND `verb` = 'PAUSEREASON' AND `serverid` = '' AND `unique_row_count` = - at it.loway.tpf.SQL.updateSql(SQL.java:167) - at it.loway.app.queuemetrics.payroll.payrollEngineMover.applyChanges(payrollEngineMover.java:222) - at it.loway.app.queuemetrics.payroll.payrollEnginePauseMover.standardizePauseInLog(payrollEnginePauseMover.java:216) - at it.loway.app.queuemetrics.payroll.payrollEnginePCodeChanger.changePauseCode(payrollEnginePCodeChanger.java:53) - at it.loway.app.queuemetrics.payroll.pauseCodeChange.doRun(pauseCodeChange.java:80) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:276) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:566) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:387) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:238) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873) - at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) - at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) - at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) - at java.lang.Thread.run(Thread.java:619) - -- End Inner Exception -- - "