larryfulkerson
Posts: 39932
Joined: 4/17/2005 From: Tucson, AZ Status: offline
|
It appears that there may be some duplicate values in the database. I'm not sure what they are but here's the error message I've been getting: C:\Matrix Games\WITP-AE BTS-L\SAVE\Tracker for my game with Brian>java -Xms384m -Xmx512m -jar "WitPTracker.jar" nomap Initializing WitP Tracker AE database. java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_123 at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at witptracker.Database.InsertRow(Database.java:54) at witptracker.ProductionGlobal.InsertInTable(ProductionGlobal.java:294) at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:643) at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:406) at witptracker.SaveFileReader.<init>(SaveFileReader.java:118) at witptracker.Main.main(Main.java:141) Insert Error code = -104 Table=ProductionGlobal Values=(2,20495,51989,2,193,13011,1) java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_51 at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at witptracker.Database.InsertRow(Database.java:54) at witptracker.Device.InsertPoolInTable(Device.java:251) at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:654) at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:406) at witptracker.SaveFileReader.<init>(SaveFileReader.java:118) at witptracker.Main.main(Main.java:141) Insert Error code = -104 Table=ArmamentPool Values=(251,2,0,70,0) java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_51 at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at witptracker.Database.InsertRow(Database.java:54) at witptracker.Device.InsertPoolInTable(Device.java:251) at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:654) at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:406) at witptracker.SaveFileReader.<init>(SaveFileReader.java:118) at witptracker.Main.main(Main.java:141) Insert Error code = -104 Table=ArmamentPool Values=(252,2,0,80,0) java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_51 at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at witptracker.Database.InsertRow(Database.java:54) at witptracker.Device.InsertPoolInTable(Device.java:251) at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:654) at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:406) at witptracker.SaveFileReader.<init>(SaveFileReader.java:118) at witptracker.Main.main(Main.java:141) Insert Error code = -104 Table=ArmamentPool Values=(254,2,0,36,0) java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_51 at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at witptracker.Database.InsertRow(Database.java:54) at witptracker.Device.InsertPoolInTable(Device.java:251) at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:654) at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:406) at witptracker.SaveFileReader.<init>(SaveFileReader.java:118) at witptracker.Main.main(Main.java:141) Insert Error code = -104 Table=ArmamentPool Values=(518,2,5273851,0,0) java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_51 at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at witptracker.Database.InsertRow(Database.java:54) at witptracker.Device.InsertPoolInTable(Device.java:251) at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:654) at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:406) at witptracker.SaveFileReader.<init>(SaveFileReader.java:118) at witptracker.Main.main(Main.java:141) Insert Error code = -104 Table=ArmamentPool Values=(519,2,12482387,0,0) java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_51 at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at witptracker.Database.InsertRow(Database.java:54) at witptracker.Device.InsertPoolInTable(Device.java:251) at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:654) at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:406) at witptracker.SaveFileReader.<init>(SaveFileReader.java:118) at witptracker.Main.main(Main.java:141) Insert Error code = -104 Table=ArmamentPool Values=(520,2,20495,13470,0) java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_51 at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at witptracker.Database.InsertRow(Database.java:54) at witptracker.Device.InsertPoolInTable(Device.java:251) at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:654) at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:406) at witptracker.SaveFileReader.<init>(SaveFileReader.java:118) at witptracker.Main.main(Main.java:141) Insert Error code = -104 Table=ArmamentPool Values=(521,2,51989,13482,0) WitP Tracker AE tables loaded in 4 seconds WARNING: Could not initialize SigInt information for first turn. WARNING: Could not initialize Operations report for first turn. ERROR: base 517 name of <Camp Pendleton> does not match the name in the import file (San Clemente Island) ERROR: base 749 name of <Buin> does not match the name in the import file (Shortlands)
|