WitPTracker AE News

[Justus2]

Both Tracker and Tracker191 are subfolders of My Documents\WITP, so it should be the same effect.

[BigDuke66]

Did reinstall Java 6 or 7?

[leehunt27@bloomberg.net]

thanks as always for this tracker. its a life saver- so many hours of time saved for us in playing (not to mention how many electronic sailors make it to port now that i can see which TF's need fuel each turn!)...thanks

[Justus2]

Did a reinstall, Java 7. I will try it on my home computer tonight and see if I can run 1.9.1 there (have been using 1.9.0 for a while on that one).

[bk19@mweb.co.za]

Hi,

I have just installed Version 1.9.1 under Jave 1.6.0.31. All I did was merely backup the witptracker.jar file and install the new one directly from the zip file. I then restarted the app using the pre-existing batch file and voila, the DOS window first reported that it was updating the database and then stated it tood 73 seconds to load the database. It seems to be running as expected.

I should add that I am running Win 7 Ultimate (64bit).

[BigDuke66]

@Justus2
Tracker currently doesn't work under Java 7, switch back to the latest 6 version and it should run. I had to do it too.

[Justus2]

ORIGINAL: BigDuke66

@Justus2
Tracker currently doesn't work under Java 7, switch back to the latest 6 version and it should run. I had to do it too.

great, thanks! I will try that. I just tested 1.9.1 on my home computer, but it's 64 bit, and I haven't made any changes to Java on it.

[treespider]

Is there a limit to the number of turns that can be loaded?

I had been running 1.9 with no problems...have 117 turns loaded.

1. Tried to do a multi-turn read for the next 8 turns. Would click on Select directory and the program would sit and the pop-up with the available turns would not appear

2. Shut down the program. Rebooted the computer.

3. Tried to restart tracker and received this message:

[treespider]

ORIGINAL: treespider

Is there a limit to the number of turns that can be loaded?

I had been running 1.9 with no problems...have 117 turns loaded.

1. Tried to do a multi-turn read for the next 8 turns. Would click on Select directory and the program would sit and the pop-up with the available turns would not appear

2. Shut down the program. Rebooted the computer.

3. Tried to restart tracker and received this message:

Replaced the 1.9 .jar withe the 1.9.1 .jar and saw this:

[n01487477]

ORIGINAL: treespider

Is there a limit to the number of turns that can be loaded?

I had been running 1.9 with no problems...have 117 turns loaded.

1. Tried to do a multi-turn read for the next 8 turns. Would click on Select directory and the program would sit and the pop-up with the available turns would not appear

2. Shut down the program. Rebooted the computer.

3. Tried to restart tracker and received this message:

TreeSpider - change the memory settings in the batch file to either:-
-Xms512m -Xmx768
-Xms384m -Xmx1024m

[treespider]

ORIGINAL: n01487477


TreeSpider - change the memory settings in the batch file to either:-
-Xms512m -Xmx768
-Xms384m -Xmx1024m

-Xms512m -Xmx768m


I added the "m" and it started up....now let's see if I can detect the extra turns.

Thanks.

[n01487477]

ORIGINAL: treespider

ORIGINAL: n01487477


TreeSpider - change the memory settings in the batch file to either:-
-Xms512m -Xmx768
-Xms384m -Xmx1024m

-Xms512m -Xmx768m

I added the "m" and it started up....now let's see if I can detect the extra turns.
Thanks.

Yeah - sorry about that. I think you must also be using the map right? The no-map batch always uses less memory.

[treespider]

ORIGINAL: n01487477

ORIGINAL: treespider

ORIGINAL: n01487477


TreeSpider - change the memory settings in the batch file to either:-
-Xms512m -Xmx768
-Xms384m -Xmx1024m

-Xms512m -Xmx768m

I added the "m" and it started up....now let's see if I can detect the extra turns.
Thanks.

Yeah - sorry about that. I think you must also be using the map right? The no-map batch always uses less memory.

Yes I am using the map.

Trying to load turns 118-125.

Still no love on getting the program to respond once I click Select Directory.

So I moved turns 120-125 to separate directory hoping the program would "see" and respond with just two turns to load.

Still no love.

Tried the "nomap" option...still no love....program starts but does not respond after clicking select directory during multi-turn read.

Seeing this in the command prompt.





Tried chaning to the 384 1024 memory settings ...program starts with the 1st 117 turns but will not respond when trying the multi-turn read.

Received the same .dll 32 bit vs 64bit message with the 384/1024 settings.


Running Java 6 (build 1.6.0_16-b01)

[treespider]

Made an oops...

forgot to use the syswow which explained 32bit vs 64bit error...now seeing this:

[treespider]

ORIGINAL: treespider

Made an oops...

forgot to use the syswow which explained 32bit vs 64bit error...now seeing this:

Went back to 512/768 and it seems to be working...

[BigDuke66]

Just tried it with a save from the RHS mod and got this:



E:\WITP Tracker>java -Xms512m -Xmx768m -jar "WitPTracker.jar" nomap
Initializing WitP Tracker AE database.
java.sql.SQLException: Numeric value out of range
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.InsertInTable(Device.java:242)
at witptracker.SaveFileReader.ReadDeviceInfo(SaveFileReader.java:1259)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:166)
at witptracker.Main.main(Main.java:139)
Insert Error code = -65
Table=Devices Values=(519,'Resource Mine/Stn',26,0,0,0,0,0,0,0,0,0,0,519,50000,
41,12,2,99,99)
java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V
ALUES ( 82,'RAF Hur'cn]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(82,'RAF Hur'cn IIdTr AT',9,1,81,25680,286,257,1610,21,2,
12,315,0,16,3,43,86,2,-128,21,21,19,17,13,4,4,8,9,30,9,43)
java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V
ALUES ( 84,'RAF Hur'cn]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(84,'RAF Hur'cn FR.IIbFB',9,1,83,28000,286,257,2010,30,1,
12,315,1000,0,1,43,85,2,-96,30,30,24,19,15,3,4,4,5,30,3,44)
java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V
ALUES ( 85,'RAF Hur'cn]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(85,'RAF Hur'cn FR.IIcFB',9,1,84,28000,286,257,1960,28,1,
12,315,1000,0,4,44,85,2,-96,28,28,23,18,13,3,4,4,5,30,3,45)
java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V
ALUES ( 151,'KNIL Hur'cn]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(151,'KNIL Hur'cn IIb Tr',11,0,150,28400,286,257,2010,30,
1,12,214,1102,3,2,42,155,2,32,30,30,22,19,14,4,4,0,0,20,2,42)
java.sql.SQLException: Unexpected token: NDO in statement [INSERT INTO Aircraft
VALUES ( 453,'PB2Y-3R Cor'ndo]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(453,'PB2Y-3R Cor'ndo XPT',4,8,451,16080,185,123,440,7,1,
32,718,11000,2,1,42,453,4,16,0,0,0,0,0,13,16,0,0,32,7,44)
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 709 >= 709
at java.util.Vector.elementAt(Unknown Source)
at witptracker.Aircraft.GetAircraft(Aircraft.java:219)
at witptracker.InMemoryDB.LoadStartupTables(InMemoryDB.java:130)
at witptracker.Main.main(Main.java:161)

E:\WITP Tracker>pause
Drücken Sie eine beliebige Taste . . .


I hope not but I guess that looks like something more serious.

[floydg]

ORIGINAL: BigDuke66

Just tried it with a save from the RHS mod and got this:



E:\WITP Tracker>java -Xms512m -Xmx768m -jar "WitPTracker.jar" nomap
Initializing WitP Tracker AE database.
java.sql.SQLException: Numeric value out of range
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.InsertInTable(Device.java:242)
at witptracker.SaveFileReader.ReadDeviceInfo(SaveFileReader.java:1259)
at witptracker.SaveFileReader.<init>(SaveFileReader.java:166)
at witptracker.Main.main(Main.java:139)
Insert Error code = -65
Table=Devices Values=(519,'Resource Mine/Stn',26,0,0,0,0,0,0,0,0,0,0,519,50000,
41,12,2,99,99)
java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V
ALUES ( 82,'RAF Hur'cn]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(82,'RAF Hur'cn IIdTr AT',9,1,81,25680,286,257,1610,21,2,
12,315,0,16,3,43,86,2,-128,21,21,19,17,13,4,4,8,9,30,9,43)
java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V
ALUES ( 84,'RAF Hur'cn]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(84,'RAF Hur'cn FR.IIbFB',9,1,83,28000,286,257,2010,30,1,
12,315,1000,0,1,43,85,2,-96,30,30,24,19,15,3,4,4,5,30,3,44)
java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V
ALUES ( 85,'RAF Hur'cn]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(85,'RAF Hur'cn FR.IIcFB',9,1,84,28000,286,257,1960,28,1,
12,315,1000,0,4,44,85,2,-96,28,28,23,18,13,3,4,4,5,30,3,45)
java.sql.SQLException: Unexpected token: CN in statement [INSERT INTO Aircraft V
ALUES ( 151,'KNIL Hur'cn]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(151,'KNIL Hur'cn IIb Tr',11,0,150,28400,286,257,2010,30,
1,12,214,1102,3,2,42,155,2,32,30,30,22,19,14,4,4,0,0,20,2,42)
java.sql.SQLException: Unexpected token: NDO in statement [INSERT INTO Aircraft
VALUES ( 453,'PB2Y-3R Cor'ndo]
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.Aircraft.InsertInTable(Aircraft.java:248)
at witptracker.SaveFileReader.ReadAircraftInfo(SaveFileReader.java:1004)

at witptracker.SaveFileReader.<init>(SaveFileReader.java:157)
at witptracker.Main.main(Main.java:139)
Insert Error code = -11
Table=Aircraft Values=(453,'PB2Y-3R Cor'ndo XPT',4,8,451,16080,185,123,440,7,1,
32,718,11000,2,1,42,453,4,16,0,0,0,0,0,13,16,0,0,32,7,44)
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 709 >= 709
at java.util.Vector.elementAt(Unknown Source)
at witptracker.Aircraft.GetAircraft(Aircraft.java:219)
at witptracker.InMemoryDB.LoadStartupTables(InMemoryDB.java:130)
at witptracker.Main.main(Main.java:161)

E:\WITP Tracker>pause
Drücken Sie eine beliebige Taste . . .


I hope not but I guess that looks like something more serious.

Crud. [:(]

The aircraft errors are because of the quotes in the aircraft names -- easy to fix.
The device error is because of the large build rate (50K per month). I can fix that, too.

Please send me a save and witptracker.properties to test the fixes. Same place as usual...

Floyd

[BigDuke66]

Thanks, files sent.

[witpqs]

BigDuke66,

Putting quotes in things is a known trouble maker for other things too. For example if you need to dump out either the scenario files themselves or some Tracker screens to CSV type files then the " character will interfere when you go to read in the file to a spreadsheet. Most of the modders have pulled out the quotations marks (for example a six inch gun should be called 6in not 6"). It'll be a lot less trouble in the long run if you convince the modder to remove all the quotation marks.

Good luck.

[BigDuke66]

Thanks I'll try to convince him.
Are ' and " the only trouble makers or there more things that should be avoided?