WitPTracker AE News

[Nomad]

Thank you Floyd and Damien, works great. Loads are much quicker without the map and I have two shortcuts, one with and one without map. And it is always great to have new features.

[RUDOLF]

Good work, but how to see the sunk tonnage ?

[Numdydar]

ORIGINAL: floydg

Next release we replace all of the button text with hieroglyphics, so you'll soon have a good excuse... [;)]

The buttons look the same. Where are the hieroglyphics [:D]

[floydg]

ORIGINAL: RUDOLF

Good work, but how to see the sunk tonnage ?

It's here:

[floydg]

ORIGINAL: Numdydar

ORIGINAL: floydg

Next release we replace all of the button text with hieroglyphics, so you'll soon have a good excuse... [;)]

The buttons look the same. Where are the hieroglyphics [:D]

Should have been there. Must have been a broken build process. Next time...

[Nomad]

Two games using old DBs I got a long list of ships upgrading?

[floydg]

ORIGINAL: Nomad

Two games using old DBs I got a long list of ships upgrading?

Oops. You found the first bug... [:(] Unfortunately, this will probably happen every five turns... D'oh!

Floyd

[Nomad]

ORIGINAL: floydg

ORIGINAL: Nomad

Two games using old DBs I got a long list of ships upgrading?

Oops. You found the first bug... [:(] Unfortunately, this will probably happen every five turns... D'oh!

Floyd

What prize do I get? [8D]

[floydg]

ORIGINAL: Nomad

ORIGINAL: floydg

ORIGINAL: Nomad

Two games using old DBs I got a long list of ships upgrading?

Oops. You found the first bug... [:(] Unfortunately, this will probably happen every five turns... D'oh!

Floyd

What prize do I get? [8D]

Loads of upgrade alerts every five turns.

Of course, everyone gets that prize now... [8|]

[dalejr33]

hi, i'm using verson 1.6 of tracker (great tool, i wouldn't want to play the game without it)
the problem is loading my latest turn the tracker freezes at "comparing task forces" and gives many java errors like this one in the command prompt:

Insert Error code = -104
 Table=Alerts Values=(70,2,1128,6,7191,2)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
 column(s) $$: SYS_PK_117
        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.Alert.InsertInTable(Alert.java:198)
        at witptracker.Base.UpdateBaseInDB(Base.java:652)
        at witptracker.InMemoryDB.CompareBaseLists(InMemoryDB.java:1532)
        at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:91)
        at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:1)
        at javax.swing.SwingWorker$1.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at javax.swing.SwingWorker.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

[n01487477]

ORIGINAL: dalejr33

hi, i'm using verson 1.6 of tracker (great tool, i wouldn't want to play the game without it)
the problem is loading my latest turn the tracker freezes at "comparing task forces" and gives many java errors like this one in the command prompt:

Insert Error code = -104
Table=Alerts Values=(70,2,1128,6,7191,2)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_117
       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.Alert.InsertInTable(Alert.java:198)
       at witptracker.Base.UpdateBaseInDB(Base.java:652)
       at witptracker.InMemoryDB.CompareBaseLists(InMemoryDB.java:1532)
       at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:91)
       at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:1)
       at javax.swing.SwingWorker$1.call(Unknown Source)
       at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
       at java.util.concurrent.FutureTask.run(Unknown Source)
       at javax.swing.SwingWorker.run(Unknown Source)
       at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
       at java.lang.Thread.run(Unknown Source)

Thanks ... this is actually a problem when comparing base lists.

Sometimes I too get the occasional constraint errors too but in this case if you are getting many then ...
I think that the previous turn did not load correctly or there has been DB prob ... did you notice it finishing ? Or is this trying to reload manually the same turn ?

Solution 3 is crude:
1. Continue with the current DB, try to load the next turn to see if it all comes out in the wash.
2. Make a new installation and test the turn previous and this one again ... if there is a problem PM me and I'll have a look at the saves. This will help us with debugging
3. Delete the DB, by closing tracker and deleting all the trackerdb*. files, start again. All your data will be lost ...

We do try to make things right, but there are a lot of variables and cases we haven't come across in such a complex game ... so more details are necessary.

Thanks for the bug report, let me know if you want my email address. Floyd is busy at present, so the witptracker email address is not manned (and I don't have access).

[floydg]

I didn't leave yet...

But I think the messages could be due to an attempt to load the same turn twice (where the first load attempt failed).

If the program is hanging during Compare TF, please send game saves (turn before hang and turn of hang), along with the witptracker.properties file to witptracker @ gmail.com and I'll take a look. As Damian said, it could be a little while...

Floyd

[n01487477]

Floyd -
Hope I won't get a message "I'm in [insert City name], I've been mugged, lost all my CC's and cash ... pls send cash straight away" [insert bogus name and forwarding address][;)]
...

[floydg]

ORIGINAL: n01487477

Floyd -
Hope I won't get a message "I'm in [insert City name], I've been mugged, lost all my CC's and cash ... pls send cash straight away" [insert bogus name and forwarding address][;)]
...

Unfortunately, a valid concern. How about this: don't send me money unless use the code-word "WitPTracker" in my plea... [;)]

[Zigurat666]

I am getting this error when trying to load a turn. I believe I know my password after using it umpteen times

C:\Matrix Games\War in the Pacific Admiral's Editiontracker>java -Xms384m -Xmx51
2m -jar "WitPTracker.jar" nomap
WitP Tracker AE tables loaded in 24 seconds
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_119
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:251)

at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:621
)
at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:393)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:113)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:73)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:1)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Insert Error code = -104
Table=ProductionGlobal Values=(60,286095,531208,0,0,0,0)
ERROR: Password mismatch.

[n01487477]

ORIGINAL: Zigurat666

I am getting this error when trying to load a turn. I believe I know my password after using it umpteen times

C:\Matrix Games\War in the Pacific Admiral's Editiontracker>java -Xms384m -Xmx51
2m -jar "WitPTracker.jar" nomap
WitP Tracker AE tables loaded in 24 seconds
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_119
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:251)

at witptracker.SaveFileReader.ReadProductionPool(SaveFileReader.java:621
)
at witptracker.SaveFileReader.ReadScenarioInfo(SaveFileReader.java:393)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:113)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:73)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:1)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Insert Error code = -104
Table=ProductionGlobal Values=(60,286095,531208,0,0,0,0)
ERROR: Password mismatch.

I just wonder if it is something simple ... Have you upgraded Tracker recently ? In which case,
did you make sure you've got the right side (Allies(1)/Japan(0)) set properly in the witptracker.properties file ? Or did you overwrite the file when upgrading ?

[floydg]

I was thinking the same thing - the properties file...

[Zigurat666]

Thanks. Apparently I "DO" know my password but "DO NOT" know which side I,m playing

[floydg]

Some days we forget who we're trying to kill... [;)]

[Theages]

I am using V1.6 of WitpTracker (with latest version of java) und the latest version of WitpAE. I started a new game as Japan. I initialized the database with the first daily autosave. Then I used multiturn read for the next 6 autosave files. Java showed the following error. WitpTracker seems to work regardless. There is 1 "Kawai R." in the pilot list.

java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_103
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.Pilots.InsertInTable(Pilots.java:157)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:2979)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:194)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:1)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Insert Error code = -104
Table=Pilots Values=(8411,'Kawai R.',1,4)