QueueMetrics > QueueMetrics installation

The following error occurred in the Transaction handler

(1/1)

adz:
Hello,

I am getting the following error when I try to install QM:


--- Code: ---"Errore tecnico nella classe 'it.loway.app.queuemetrics.autenticazione.caricaDatiIniziali'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema DB: - 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 'TYPE=HEAP SELECT id_location, loc_name, read_key from locations WHERE id_locatio' at line 1 - at it.loway.tpf.SQL.execSql(SQL.java:101) - at it.loway.app.queuemetrics.FA.makeSqlUnionLt(FA.java:1087) - at it.loway.app.queuemetrics.autenticazione.caricaDatiIniziali.doRun(caricaDatiIniziali.java:178) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:255) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:543) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:365) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:210) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) - at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) - at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) - at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) - at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) - at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:686) - at java.lang.Thread.run(Thread.java:619) - -- End Inner Exception -- - " 

--- End code ---

QueueMetrics:
Which version of MySQL are you using?
Did you create the database and load it?

adz:
MySQL Version 5.1.45

Yes I created the Database and loaded the test data from the .sql file without any errors.

QueueMetrics:
Does it show a storage engine called HEAP?

Navigation

[0] Message Index