WitPTracker AE Release 1.11 Available!
Moderators: wdolson, MOD_War-in-the-Pacific-Admirals-Edition
RE: WitPTracker AE Release 1.0.1 Available
you are missing your pwsdll file in your game directory...I think.
"Now excuse me while I go polish my balls ...
" - BBfanboy
" - BBfanboyRE: WitPTracker AE Release 1.0.1 Available
I solved thanks 
But now i have a new problem alerts do not appear, and tracker do not read the turn that i want it always read the same [:(]
But now i have a new problem alerts do not appear, and tracker do not read the turn that i want it always read the same [:(]
RE: WitPTracker AE Release 1.0.1 Available
ORIGINAL: verdugo94
I solved thanks
But now i have a new problem alerts do not appear, and tracker do not read the turn that i want it always read the same [:(]
Alerts will not show up on the first turn you load in. The Alerts are generated by comparing the new turn to the previous turn(s), so you need to load a second turn in before any will show up.
I don't quite follow what you mean by it always read(s) the same (turn?).
RE: WitPTracker AE Release 1.0.1 Available
ORIGINAL: Lokasenna
ORIGINAL: verdugo94
I solved thanks
But now i have a new problem alerts do not appear, and tracker do not read the turn that i want it always read the same [:(]
Alerts will not show up on the first turn you load in. The Alerts are generated by comparing the new turn to the previous turn(s), so you need to load a second turn in before any will show up.
I don't quite follow what you mean by it always read(s) the same (turn?).
You are right, thanks for helping [:)]
RE: WitPTracker AE Release 1.10 Available!
I have attempted to download this to my computer but it keeps getting blocked as a unsafe file!
RE: WitPTracker AE Release 1.10 Available!
Send me email to witptracker @ gmail.com and I'll send you the file directly.
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
RE: WitPTracker AE Release 1.10 Available!
Hello,
In the Industry tab - CS convoy tool, I seem to be unable to find certain ports/locations in the Starting Point dropdown list as Japan. For instance, I just captured Miri in the DEI and want to look into optima routes between Miri and Japan, but I can't seem to find it on the list. Any pointers? Or am I using the CS convoy tool wrong?
In the Industry tab - CS convoy tool, I seem to be unable to find certain ports/locations in the Starting Point dropdown list as Japan. For instance, I just captured Miri in the DEI and want to look into optima routes between Miri and Japan, but I can't seem to find it on the list. Any pointers? Or am I using the CS convoy tool wrong?
"Now excuse me while I go polish my balls ..." - BBfanboy
" - BBfanboyRE: WitPTracker AE Release 1.10 Available!
ORIGINAL: Anachro
Hello,
In the Industry tab - CS convoy tool, I seem to be unable to find certain ports/locations in the Starting Point dropdown list as Japan. For instance, I just captured Miri in the DEI and want to look into optima routes between Miri and Japan, but I can't seem to find it on the list. Any pointers? Or am I using the CS convoy tool wrong?
Looks to me like these drop-downs are populated only when the program starts up, so if your base list changes, you'd need to quit the program and restart (that's just a quit and start, not a complete re-load of the database; just to be clear).
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
-
Admiral DadMan
- Posts: 3405
- Joined: Fri Feb 22, 2002 10:00 am
- Location: A Lion uses all its might to catch a Rabbit
RE: WitPTracker AE Release 1.7.1 Available!
Tracker is failing to update. It last updated to turn 441, but I've run 2 more pbem turns and it keeps saying that turn 441 is already loaded. No changes were made to anything that I can recall. Any recommendations? I don't have a problem starting from scratch again.
Disregard my previous: I used the "Multi Turn Read" function to manually update it.
All is well.
Disregard my previous: I used the "Multi Turn Read" function to manually update it.
All is well.
-
Admiral DadMan
- Posts: 3405
- Joined: Fri Feb 22, 2002 10:00 am
- Location: A Lion uses all its might to catch a Rabbit
RE: WitPTracker AE Release 1.7.1 Available!
UPDATE: the "one-click" update feature still tells me that turn 441 is already loaded, and won't update, but I can update it manually. Ideas?ORIGINAL: Admiral DadMan
Tracker is failing to update. It last updated to turn 441, but I've run 2 more pbem turns and it keeps saying that turn 441 is already loaded. No changes were made to anything that I can recall. Any recommendations? I don't have a problem starting from scratch again.
Disregard my previous: I used the "Multi Turn Read" function to manually update it.
All is well.
RE: WitPTracker AE Release 1.7.1 Available!
ORIGINAL: Admiral DadMan
UPDATE: the "one-click" update feature still tells me that turn 441 is already loaded, and won't update, but I can update it manually. Ideas?ORIGINAL: Admiral DadMan
Tracker is failing to update. It last updated to turn 441, but I've run 2 more pbem turns and it keeps saying that turn 441 is already loaded. No changes were made to anything that I can recall. Any recommendations? I don't have a problem starting from scratch again.
Disregard my previous: I used the "Multi Turn Read" function to manually update it.
All is well.
The location you specified in the witptracker.properties for the save file could be for another game.
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
-
Admiral DadMan
- Posts: 3405
- Joined: Fri Feb 22, 2002 10:00 am
- Location: A Lion uses all its might to catch a Rabbit
RE: WitPTracker AE Release 1.7.1 Available!
It's the same as it's always been. Database Maintenance reports all of the turns up to 448, but when I try to "read turn" it still tells me "turn 441 is already loaded. Very odd.
Edit: I just re-did all of the settings in that file. Operating as normal. Thank you.
Edit: I just re-did all of the settings in that file. Operating as normal. Thank you.
-
Admiral DadMan
- Posts: 3405
- Joined: Fri Feb 22, 2002 10:00 am
- Location: A Lion uses all its might to catch a Rabbit
RE: WitPTracker AE Release 1.7.1 Available!
Tracker is taking longer and longer to load. Wondering if the trackerdb.data file size is having an impact. It's 836,000 KB.
Can you recommend any tweaks (or things to do/avoid) to get it load faster than 5-10 minutes (and sometimes longer)?
Current .bat file:
"C:\Program Files (x86)\Java\jre1.8.0_73\bin\java" -Xms512m -Xmx768m -jar "WitPTracker.jar"
pause
Awesome, awesome tool.
Can you recommend any tweaks (or things to do/avoid) to get it load faster than 5-10 minutes (and sometimes longer)?
Current .bat file:
"C:\Program Files (x86)\Java\jre1.8.0_73\bin\java" -Xms512m -Xmx768m -jar "WitPTracker.jar"
pause
Awesome, awesome tool.
RE: WitPTracker AE Release 1.7.1 Available!
Changing -Xmx768m to -Xmx1024m will help some.
RE: WitPTracker AE Release 1.7.1 Available!
It's based on how many turns are loaded. You can shorten the startup time by deleting the DB and starting over from later in the game.
I have some ideas on shortening the startup, but it requires a good amount of work to overhaul and with work, family and my volunteer "career", it's hard to find the time.
I have some ideas on shortening the startup, but it requires a good amount of work to overhaul and with work, family and my volunteer "career", it's hard to find the time.
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
RE: WitPTracker AE Release 1.7.1 Available!
For anyone that wonders, Tracker will run using the 64 bit Java. But there may be some problems using 64 bit Java with other apps.
The loading was faster, not dramatic, but about 35% faster load times. You will have to have a 64 bit machine of course.
I was using -Xms2g -Xmx4g for memory settings.
The loading was faster, not dramatic, but about 35% faster load times. You will have to have a 64 bit machine of course.
I was using -Xms2g -Xmx4g for memory settings.
RE: WitPTracker AE Release 1.7.1 Available!
64 bit Java does have a problem loading turns. sorry
-
Admiral DadMan
- Posts: 3405
- Joined: Fri Feb 22, 2002 10:00 am
- Location: A Lion uses all its might to catch a Rabbit
RE: WitPTracker AE Release 1.7.1 Available!
Thanks guys, I will experiment and see what happens.
-
mikemike
- Posts: 500
- Joined: Wed Jun 02, 2004 11:26 pm
- Location: a maze of twisty little passages, all different
RE: WitPTracker AE Release 1.7.1 Available!
Hello Floyd!
Haven't posted in this forum for a long time, but I've looked in occasionally. Am still playing solo, mostly WitP, and there is one thing that has irked me for a while. You remember I asked you to include a date-of-arrival column in the Ship Production panel, and you did that admirably. Where I went wrong was telling you to use the normal date format for the output. It would have been better to use the ISO format (Pearl Harbor Day in ISO is "1941-12-07") because then sorting by that column would show the ships in the sequence they really arrive in. As it is, you can only sort by the DELAY Column where accelerated ships constantly move up through the ranks and you have to reconcile the DELAY and ACCELERATED_DELAY columns to get an idea of which ships arrive next. Is it too late to fit that in?
To get the ISO format you could use an additional SQL statement:
SELECT gamedate + :calculated_delay DAYS AS DATE_OF ARRIVAL
SELECT CHAR(DATE_OF_ARRIVAL,ISO) INTO :eta-column
Maybe the following nested query would work too:
SELECT CHAR(SELECT gamedate + :calculated_delay DAYS AS DATE_OF ARRIVAL,ISO) INTO :eta-column
but I am not sure about that, have not done much SQL lately.
Greetings, mikemike
Haven't posted in this forum for a long time, but I've looked in occasionally. Am still playing solo, mostly WitP, and there is one thing that has irked me for a while. You remember I asked you to include a date-of-arrival column in the Ship Production panel, and you did that admirably. Where I went wrong was telling you to use the normal date format for the output. It would have been better to use the ISO format (Pearl Harbor Day in ISO is "1941-12-07") because then sorting by that column would show the ships in the sequence they really arrive in. As it is, you can only sort by the DELAY Column where accelerated ships constantly move up through the ranks and you have to reconcile the DELAY and ACCELERATED_DELAY columns to get an idea of which ships arrive next. Is it too late to fit that in?
To get the ISO format you could use an additional SQL statement:
SELECT gamedate + :calculated_delay DAYS AS DATE_OF ARRIVAL
SELECT CHAR(DATE_OF_ARRIVAL,ISO) INTO :eta-column
Maybe the following nested query would work too:
SELECT CHAR(SELECT gamedate + :calculated_delay DAYS AS DATE_OF ARRIVAL,ISO) INTO :eta-column
but I am not sure about that, have not done much SQL lately.
Greetings, mikemike
DON´T PANIC - IT´S ALL JUST ONES AND ZEROES!
RE: WitPTracker AE Release 1.7.1 Available!
I really want to use this program and I had it working months ago but have started a new PBEM game. I deleted the old tracker folder and installed fresh. When I execute the program I receive the error messages below. Can someone help me understand what I did wrong?
Table=ArmamentPool Values=(1125,1,20,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=(1137,1,50,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=(1138,1,50,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=(1152,1,20,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=(1154,1,30,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=(1163,1,12,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=(1174,1,20,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=(1179,1,10,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=(1186,1,50,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=(1314,1,5,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=(1326,1,4,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=(1545,1,200,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=(1645,1,230,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=(1646,1,100,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=(1647,1,20,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=(1648,1,100,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=(1650,1,80,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=(1651,1,300,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=(1652,1,50,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=(1719,1,120,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=(1751,1,24,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=(1752,1,24,0,0)
ERROR: Password mismatch.
ERROR: Problem with save game file. Exiting.
C:\WitPTracker AE>pause
Press any key to continue . . .
Table=ArmamentPool Values=(1125,1,20,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=(1137,1,50,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=(1138,1,50,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=(1152,1,20,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=(1154,1,30,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=(1163,1,12,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=(1174,1,20,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=(1179,1,10,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=(1186,1,50,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=(1314,1,5,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=(1326,1,4,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=(1545,1,200,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=(1645,1,230,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=(1646,1,100,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=(1647,1,20,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=(1648,1,100,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=(1650,1,80,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=(1651,1,300,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=(1652,1,50,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=(1719,1,120,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=(1751,1,24,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=(1752,1,24,0,0)
ERROR: Password mismatch.
ERROR: Problem with save game file. Exiting.
C:\WitPTracker AE>pause
Press any key to continue . . .