agaw-runner.sh problem

[tonils]

I am trying to get agaw-runner working on our internal QM box I get the following

asterisk:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/mysql-utils/agaw-runner # ./agaw-runner.sh
+ JAVA=/usr/bin/java
+ VMOPTS=-server
+ -Xmx256M -Xms256M
./agaw-runner.sh: line 15: -Xmx256M: command not found
+ USER=demoadmin
+ PASS=demo
+ JDBC='jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude'
+ QMPATH=/srv/www/tomcat5/base/webapps/QueueMetrics
+ ITER=10
+ IDLE=15000
+ RUNLOG=true
+ RUNLOGDIR=/tmp/agaw
+ MYSQLJAR=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/mysql-connector-java-3.1.14-bin.jar
+ SERVLET=/usr/share/tomcat5/common/lib/servletapi5.jar
+ ALLCFG='-Dagaw.user=demoadmin -Dagaw.password=demo -Dagaw.jdbc=jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude -Dagaw.qmInstance=/srv/www/tomcat5/base/webapps/QueueMetrics -Dagaw.nLoops=10 -Dagaw.idle=15000 -Dagaw.runlog=true -Dagaw.runlogdir=/tmp/agaw'
+ QMCLASS=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/classes
+ JARLIB=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib
+ QMARCH=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/loway-tpf-155p.jar
+ QMJAR=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/QueueMetrics-1.5.0.jar
+ REDRPC=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/redstone-xmlrpc-1.0.jar
+ CP=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/classes:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/QueueMetrics-1.5.0.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/loway-tpf-155p.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/redstone-xmlrpc-1.0.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/mysql-connector-java-3.1.14-bin.jar:/usr/share/tomcat5/common/lib/servletapi5.jar
+ /usr/bin/java -Dagaw.user=demoadmin -Dagaw.password=demo '-Dagaw.jdbc=jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude' -Dagaw.qmInstance=/srv/www/tomcat5/base/webapps/QueueMetrics -Dagaw.nLoops=10 -Dagaw.idle=15000 -Dagaw.runlog=true -Dagaw.runlogdir=/tmp/agaw -cp /srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/classes:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/QueueMetrics-1.5.0.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/loway-tpf-155p.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/redstone-xmlrpc-1.0.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/mysql-connector-java-3.1.14-bin.jar:/usr/share/tomcat5/common/lib/servletapi5.jar it.loway.app.queuemetrics.agaw.QueueRunner
============
QM User name: demoadmin
QM password:  demo
QM path:      /srv/www/tomcat5/base/webapps/QueueMetrics
JDBC URI:     jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Number of loops:         10
Idle time between loops: 15000 ms
Keep run log: true
Run log dir: /tmp/agaw
Path: '/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/agaw.properties'
Chiave: '5231317C-4E324465-6D6F2D31-2E352E30-2D52232D-23516D52-756E6E65-727C5333-31323539-38383132-30303030-307C'
 *** LOWAY TPF licence: to 'Demo-1.5.0-R' up to 'Fri Dec 04 01:00:00 SAST 2009'
Data Scad [2009-12-04]: Fri Dec 04 00:00:00 SAST 2009
Data scad:Fri Dec 04 00:00:00 SAST 2009 - Scaduto: 0
Servlet A01 - Step X3
Servlet A01 - Step X4 - 3577
-- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
Stack trace:
Problema DB: java.sql.SQLException: 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 it.loway.tpf.SQL.selectScalare(Unknown Source)
  at it.loway.app.queuemetrics.agaw.BO.AgentReader.closeRunsCreatedByAPreviousExecution(AgentReader.java:436)
  at it.loway.app.queuemetrics.agaw.QueueRunner.run(QueueRunner.java:157)
  at it.loway.app.queuemetrics.agaw.QueueRunner.main(QueueRunner.java:728)
-- End Inner Exception --

Can you shed any light on what may be wrong

Tony

[QueueMetrics]

You have likely no queues that are "runnable" by the AGAW system, spo no data gets inserted. of course the error message should not be there and we'll fix that.
Try making one of your atomic queues "ruunnable" and see if the problem persists.

[QueueMetrics]

We track this as bug #569.

[tonils]

Thanks, it is now working.

[QueueMetrics]

Good - do you like the new AGAW module?