AgileTrack
Put your development on the AgileTrack

Error in first login with 1.1.3 build 20071027

I have experienced the same problem:
"Hi.
I have a problem with first login
I installed agileTrack Client and I selected HSQLDB in connection property. Then I use
user:admin
password:admin
and click the login button.
I get this error:
Login Cannot be performed. Trouble connecting to AgileTrack Server.
Table not found in statement [SELECT schema_version FROM agiletrack_config]"

The agiletrack-info.log says:
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
84161 [Thread-3] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
84161 [Thread-2] ERROR: hsqldb.TrackerHSQLDatabase – Problem shutting down HSQLDB.
java.lang.RuntimeException: java.sql.SQLException: SOO10 Argomento non valido per una chiamata JDBC

The agiletrack-client.log says:
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
84161 [Thread-3] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
84161 [Thread-2] ERROR: hsqldb.TrackerHSQLDatabase – Problem shutting down HSQLDB.
java.lang.RuntimeException: java.sql.SQLException: SOO10 Argomento non valido per una chiamata JDBC

at agiletrack.server.persistence.DatabaseResourceProvider.<init>(DatabaseResourceProvider.java:33) at agiletrack.persistence.hsqldb.TrackerHSQLDatabase.close(TrackerHSQLDatabase.java:120) at agiletrack.persistence.hsqldb.TrackerHSQLDatabase$1.run(TrackerHSQLDatabase.java:500) at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: SOO10 Argomento non valido per una chiamata JDBC at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at agiletrack.server.persistence.DatabaseResourceProvider.<init>(DatabaseResourceProvider.java:30) ... 3 more
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
117830 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
22252 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
50 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
27259 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
50 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
361360 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.

Bye

Nicola from Italy

—Posted by nicola on Nov 13, 2007


	Forum AgileTrack Client


	Reply

That log helped. I think I finally just figured out what is going wrong. Before creating the database, the code checks to see if the schema_version can be found. It is expecting a particular error string if the table is not found. Well, the error string is expected to be English, but HSQLDB must be localizing it to Italian as is shown in the log. I'm going to try to fix the problem and put out a very minor release later this week—to fix this and one other problem. Sorry it's taken a while to figure out, but thanks for the information.

—Posted by Adam Lane on Nov 18, 2007 at 9:33:43 PM

Thank to you.

Nicola from Italy

—Posted by nicola on Nov 19, 2007 at 12:39:43 AM

AgileTrack version 1.1.4 was released today. It should take care of this problem. Let me know if it doesn't.

—Posted by Adam Lane on Nov 26, 2007 at 8:09:28 AM

Thank you!
I try immediately.

Nicola from Italy

—Posted by nicola on Nov 26, 2007 at 8:19:11 AM