Author Topic: emergency problems updating from 1.5 to 1.6.0.1  (Read 3922 times)

DowNetworks

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
    • View Profile
    • Email
emergency problems updating from 1.5 to 1.6.0.1
« on: April 20, 2010, 23:05:16 »
one of IT guys run a yum update in the queueemetrics server and now we have this page:


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=javadude


Under this configuration you are ready to run the JDBC connection tester.

This wizard will guide you between steps required to check and update, if required, the QueueMetrics database. Please click on the button below to start the procedure.

when i run the wizard it gives me error :

Checking current version of table: 'agenti_noti'     Error     Java Error: Errore DB: java.sql.SQLException: Unknown column 'group_by' in 'field list' The required database table 'agenti_noti' is missing some fields. Are you updating from a previous version of QM?

and when i continue give me :

Below you can find the performed check details:

   Test performed    Test result
1.5.2    Increase queue name in queue_log    Err

and i can't get the QM back to work, need help asap

thanks

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: emergency problems updating from 1.5 to 1.6.0.1
« Reply #1 on: April 21, 2010, 17:03:45 »
I understand the issue is fixed, and it was caused by a locked table.

Mailsouth

  • Newbie
  • *
  • Posts: 15
  • Karma: 0
    • View Profile
Re: emergency problems updating from 1.5 to 1.6.0.1
« Reply #2 on: May 30, 2010, 22:37:49 »
I think I am having the same problem I get this error message:

Checking current version of table: 'agenti_noti'   Error   Java Error: Errore DB: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'payroll_code' in 'field list' The required database table 'agenti_noti' is missing some fields. Are you updating from a previous version of QM?

If this was caused by a locked table how do I fix it? I'm not sure how to unlock a table

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: emergency problems updating from 1.5 to 1.6.0.1
« Reply #3 on: June 08, 2010, 14:22:20 »
You can try and add the missing fields to your table using a MySQL interface.
Look for the table definition in the queuemetrics_sample.sql file.