database needs updating

[fredsi]

Hi there,

We have problem earlier this morning on Queuemetrics -- the server HD was full. After I cleared some space, the QM run gave me "QueueMetrics JDBC connection tester" window and told me "We have detected that your QueueMetrics database needs updating.". After I clicked the "Start Database Check", I got all OK except "Checking database revision - required version:19    Error    Java Error: DB revision error: was 11 - required 19". How do I update the DB version to 19? Please help. Thank you.

Fred

[fredsi]

Help please.

btw, some of our agents can login the qm while some can't. below are what the screen shows:

QueueMetrics JDBC connection tester
We have detected that your QueueMetrics database needs updating.

Your current configuration is:

    XML configuration file found at:
    /usr/local/queuemetrics/webapps/queuemetrics-1.6.0.1/WEB-INF/web.xml
    JDBC URI configured as:
    jdbc:mysql://localhost/queuemetrics?autoReconnect=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=*******

Thank you.

Fred

[QueueMetrics]

If the space is finished, most likely MySQL tables have been corrupted. Run a table repair or restart from a backup if it should not work.

[fredsi]

since all our reps still can open the page by keep reopening the url, i didn't work on this for a while. but it really annoying and some pc can't open at all, i did the db repair last weekend, but the problem still. here is what i did -- read from your faq:

1. backup the db:
  mysqldump -uqueuemetrics -pjavadude queuemetrics > database.sql
2. stop mysql
  /etc/init.d/mysqld stop
3. check tables:
  myisamchk -c /var/lib/mysql/queuemetrics/*.MYI
4. repair tables:
  myisamchk -r /var/lib/mysql/queuemetrics/*.MYI
5. restat mysql:
  /etc/init.d/mysqld start

after that i open the browser saw the same message, and same after database check. i even restarted the server, but still no luck.

please help, thanks.

fred

[QueueMetrics]

Looks like some of the pages are cached - either QM lets you in or it does not.

[fredsi]

yes it looks like that. how do i fix it now?

and i was thinking if upgrade to currently version will fix the problem, and how difficult it is? are there any instructions for upgrading the queuemetrics?

thanks.

fred

[QueueMetrics]

cached pages are cached at the browser level so you should clean the cache of the browser. You could also stop QM and look for a directory called tomcat/work and remove all its contents (that's where compiled pages are kept).

[fredsi]

just let you know, i tried to remove tom/work, after queuemetrics restart, it came out again, but page still didn't work well. so i used upgrade guide in FAQ page, removed qm, reinstalled it, after couple times repair, now everything works fine. thanks for the help.

fred

[QueueMetrics]