Menu

#7 Error reparsing cached file

open
nobody
None
5
2012-03-26
2012-03-26
Anonymous
No

Whenever I run DB Sanity after having it imported database meta data and tables I'm getting below error:

2012-03-26 23:08:00,895 INFO (main) [org.databene.jdbacl.model.cache.CachingDBImporter] Reading cached database meta data from file C:\Users\ryandell\databene\cache\restore_test.meta.xml
2012-03-26 23:08:01,005 INFO (main) [org.databene.jdbacl.model.cache.CachingDBImporter] Error reading cache file, reparsing database
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at org.databene.jdbacl.SQLUtil.parseColumnTypeAndSize(SQLUtil.java:79)
at org.databene.jdbacl.model.DefaultDBColumn.<init>(DefaultDBColumn.java:59)
at org.databene.jdbacl.model.xml.XMLModelImporter.parseColumn(XMLModelImporter.java:197)
at org.databene.jdbacl.model.xml.XMLModelImporter.parseTableStructure(XMLModelImporter.java:176)
at org.databene.jdbacl.model.xml.XMLModelImporter.parseSchema(XMLModelImporter.java:152)
at org.databene.jdbacl.model.xml.XMLModelImporter.parseCatalog(XMLModelImporter.java:131)
at org.databene.jdbacl.model.xml.XMLModelImporter.parseDatabase(XMLModelImporter.java:118)
at org.databene.jdbacl.model.xml.XMLModelImporter.importDatabase(XMLModelImporter.java:84)
at org.databene.jdbacl.model.cache.CachingDBImporter.readCachedData(CachingDBImporter.java:92)
at org.databene.jdbacl.model.cache.CachingDBImporter.importDatabase(CachingDBImporter.java:67)
at org.databene.jdbacl.DBUtil.getMetaData(DBUtil.java:664)
at org.databene.dbsanity.DbSanity.getDatabaseMetaData(DbSanity.java:369)
at org.databene.dbsanity.DbSanity.execute(DbSanity.java:333)
at org.databene.dbsanity.DbSanity.execute(DbSanity.java:310)
at org.databene.dbsanity.Main.main(Main.java:50)
2012-03-26 23:08:01,009 INFO (main) [org.databene.jdbacl.model.jdbc.JDBCDBImporter] Importing database metadata. Be patient, this may take some time...
2012-03-26 23:08:01,704 INFO (main) [org.databene.jdbacl.model.jdbc.JDBCDBImporter] Importing tables
2012-03-26 23:12:28,648 INFO (main) [org.databene.jdbacl.model.jdbc.JDBCDBImporter] Importing imported keys
2012-03-26 23:13:19,445 INFO (main) [org.databene.jdbacl.model.jdbc.JDBCDBImporter] Imported database metadata within 318436 ms.
2012-03-26 23:13:19,445 INFO (main) [org.databene.jdbacl.model.cache.CachingDBImporter] Reading and exporting Database meta data to cache file
....

My environment:
OS: Windows 7 SP1
User: user with admin rights
Java: Standard edition version 7 update 3 (build 1.7.0_03-b05)
Database server: SQL Server 2008 in remote location

My project folder structure for DB Sanity:
"Sanity Tests" - project folder
> "Definitions" - tests
> "Environments" - environments configurations
> "Reports"

I have checked and can confirm that metadata file is available in cache folder and looks as it has got correct environment information.

Commandline parameters used for DB Sanity (starting in project folder):
dbsanity -i Definitons -b -k -t usersTable -v restore_test -NOTE: environment file was copied to project folder, but earlier tried with \Environments\restore_test and file was cached fine but still DB Sanity reported errors.

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.