Upgrading

I tried it again to get the message popup…schema incompatibility and needs to convert.
However when I get the same issue as described above on one of the old releases now…it does not show when I select it, whereas in my previous release of agile track it does.

How can I use my old data in the new version client?

—Posted by paul on May 28, 2007 at 12:11:27 AM

What version are you upgrading from? If it is requiring a schema update, then I suppose it's prior to 1.1.0. Are you using MySQL?

I suspect there is some sort of exception occurring. If you're using Windows, I suggest running the agiletrack.bat file to be able to see any console output. Could you see if any exceptions get output in the console window? If so, please post them. Thanks.

—Posted by Adam Lane on May 29, 2007 at 4:25:30 PM

Old version is 1.0.0
New version is 1.1.1

"The database version is out of sync with the code
The HSQL database schema version (9) is out of sync with the expected version (10)
Do you want to update the database persistence now"

Selecting yes gives the following, but as mentioned in the previous message up top is resulting in errors on the releases:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985–2001 Microsoft Corp.

C:\Documents and Settings\Paul>cd C:\Documents and Settings\Paul\My Documents\ag
iletrack\Agiletrack1pt1

C:\Documents and Settings\Paul\My Documents\agiletrack\Agiletrack1pt1>dir

Volume in drive C has no label. Volume Serial Number is 04A0-B76D Directory of C:\Documents and Settings\Paul\My Documents\agiletrack\Agiletrack1
pt1

28/05/2007 03:28 PM <DIR> .
28/05/2007 03:28 PM <DIR> ..
21/05/2007 11:50 AM 1,178 agiletrack
21/05/2007 11:50 AM 122 agiletrack.bat
21/05/2007 11:50 AM 579,072 agiletrack.exe
28/05/2007 03:28 PM 791 Agiletrack.lnk
21/05/2007 11:50 AM 1,806 agiletrack_icon.png
21/05/2007 11:50 AM 18,801 changelog.txt
21/05/2007 11:50 AM 3,117 install-detect-java
21/05/2007 11:50 AM 2,215 install-home
21/05/2007 11:50 AM 2,272 install-usr
21/05/2007 11:50 AM 7 java.dir
28/05/2007 04:13 PM <DIR> lib
28/05/2007 01:16 PM <DIR> license
21/05/2007 11:50 AM 5,319 license-agiletrack.rtf
21/05/2007 11:50 AM 4,731 license-agiletrack.txt
21/05/2007 11:50 AM 10,307 license.txt
21/05/2007 11:50 AM 9,392 readme.rtf
21/05/2007 11:50 AM 1,456 readme.txt

15 File(s) 640,586 bytes 4 Dir(s) 25,534,705,664 bytes free

C:\Documents and Settings\Paul\My Documents\agiletrack\Agiletrack1pt1>agiletrack
.bat
The system cannot find the path specified.

C:\Documents and Settings\Paul\My Documents\agiletrack\Agiletrack1pt1>agiletrack
.bat
Add to classpath: .\agiletrack-hsqldb.jar
Add to classpath: .\agiletrack-jsonrpc.jar
Add to classpath: .\agiletrack-model.jar
Add to classpath: .\agiletrack-mysql.jar
Add to classpath: .\agiletrack-sqlserver.jar
Add to classpath: .\agiletrack-xmlrpc.jar
Add to classpath: .\agiletrack.jar
Add to classpath: .\commons-codec-1.3.jar
Add to classpath: .\commons-collections-2.1.1.jar
Add to classpath: .\commons-dbcp-1.2.1.jar
Add to classpath: .\commons-httpclient-2.0.2.jar
Add to classpath: .\commons-logging-api.jar
Add to classpath: .\commons-logging.jar
Add to classpath: .\commons-pool-1.2.jar
Add to classpath: .\gnu-regexp-1.1.4.jar
Add to classpath: .\hsqldb.jar
Add to classpath: .\jdic-win.jar
Add to classpath: .\jdic.jar
Add to classpath: .\log4j-1.2.12.jar
Add to classpath: .\lucene-core-2.0.0.jar
Add to classpath: .\mysql-connector-java-5.0.4-bin.jar
Add to classpath: .\sqljdbc.jar
Add to classpath: .\xmlrpc-2.0.jar
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDataba
seFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDataba
seFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServ
erDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDataba
seFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDataba
seFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServ
erDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCData
AccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHt
tpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPC
StreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
120390 [AWT-EventQueue-1] INFO : hsqldb.TrackerHSQLDatabase – Updating database
from version 9…
120390 [AWT-EventQueue-1] INFO : persistence.DatabaseResourceProvider – Updated
0 rows: CREATE TABLE report (id BIGINT NOT NULL, user_id BIGINT NOT NULL, source
s VARCHAR, inquiry_id BIGINT NOT NULL, time_span VARCHAR NOT NUL
L, start_date DATE NULL, end_date DATE NULL, PRIMARY KEY (id))
120390 [AWT-EventQueue-1] INFO : persistence.DatabaseResourceProvider – Updated
0 rows: CREATE TABLE inquiry (id BIGINT NOT NULL, grouping VARCHAR,
inquiry_data VARCHAR, PRIMARY KEY (id))
120390 [AWT-EventQueue-1] INFO : hsqldb.TrackerHSQLDatabase – Finished updates.

Setting database to version 10…
120390 [AWT-EventQueue-1] INFO : persistence.DatabaseResourceProvider – Updated
1 rows: UPDATE agiletrack_config SET schema_version = 10
120390 [AWT-EventQueue-1] INFO : hsqldb.TrackerHSQLDatabase – Database is up to
date.
120468 [Thread-5] INFO : persistence.GenericFullTextIndexer – Beginning full tex
t indexer thread…
Create new persistence cache
124343 [Thread-7] INFO : persistence.GenericFullTextIndexer – Beginning full tex
t indexer thread…
Create new persistence cache
Create new server bridge cache
124359 [AgileTrack – Bridge Polling] INFO : controller.TrackerServerBridge – Beg
in background cache management thread…
124437 [SplashThread] INFO : data.TrackerDataCache – Cached data version doesn't match expected data version. Cannot load cache.
Create new server bridge cache
Create new persistence cache
Could not load hot keys library. Global hot keys unavailble.

—Posted by paul on May 29, 2007 at 9:13:07 PM

Hello,
Has this been confirmed as a bug or is there a workaround?
Do I have to recreate the project structure from scratch?
or have I done something wrong?

Cheers,
Paul

—Posted by paul on Jun 27, 2007 at 8:34:26 PM

you could try to export / reimport data manually

—Posted by slava on Jul 1, 2007 at 8:48:33 AM

There was a problem with the releases tab. I'm putting out an update shortly. Perhaps that will fix your problem.

—Posted by Adam Lane on Jul 23, 2007 at 10:02:01 AM

You may post a reply to this topic, but you must be logged in. If you already have an account, you may login now. If you need to create an account, you may also register now.