Issue Updating the QM Database to 1.4.7.1

[rneubauer]

I am trying to upgrade fom 1.4.4 to 1.4.7.1 and I am running into a DB update issue.

I copied the database back to the server, and started the dbtest, then chose to update my DB. Here is the error I get:

# 20 Checking database table: qa_data Error
 Problem encountered:
The required database table 'qa_data' is missing or unreadable. Please run the database update utility.
Java Error:
Problema DB: java.sql.SQLException: Table 'queuemetrics.qa_data' doesn't exist
 
So I go to the DB update tool and this is what I get:

Updating database
DB Version Description Result
1.4.4 Creating table 'qa_data' Err
1.4.4 Creating table 'qa_forms' Err
1.4.4 Preloading table 'qa_forms' Err
1.4.4 Creating table 'qa_forms_items' Err
1.4.4 Preloading table 'qa_forms_items' Err

The database was updated succesfully.
You are now ready to run QueueMetrics. Click here to start.

Any Ideas? I have a bit if data in there that I really cont lose. I would love to see the past year stats compared to the upcoming high volume season...

R

[QueueMetrics]

Try grabbing the tables "qa_*" right from the setup script. Maybe you do not have table creation grants on the QM database?

[rneubauer]

I tried that, and even tried to change the DB level to the new version, but it caused a bunch of errors. I am just going to start it all overagain with a fresh database. It sucks, though, because my client wants all the historical data, and now I cant give it to him...

[QueueMetrics]

All historical data are either on flat-file or on the queue_log table -just create a new datanbase and import the queue_log table from the old one. This should not be such a major change.