Matrix Games Forums

you are missing your pwsdll file in your game directory...I think.

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 [:(]

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?).

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 [:)]

I have attempted to download this to my computer but it keeps getting blocked as a unsafe file!

Send me email to witptracker @ gmail.com and I'll send you the file directly.

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?

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).

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.

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.

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

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.

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?

The location you specified in the witptracker.properties for the save file could be for another game.

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.

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.

Changing -Xmx768m to -Xmx1024m will help some.

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.

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.

64 bit Java does have a problem loading turns. sorry

Thanks guys, I will experiment and see what happens.

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

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 . . .