Matrix Games Forums

For you guys 'tricky' seems to mean might take a little while - wonders if its possible to export the report and then it could be sorted or filtered in a spreadsheet? I am sure if there's a way you guys will find it.

Roger

ORIGINAL: Roger Neilson II

For you guys 'tricky' seems to mean might take a little while - wonders if its possible to export the report and then it could be sorted or filtered in a spreadsheet? I am sure if there's a way you guys will find it.

Roger

Export to CSV is already there for alerts. But I think I have an idea that could satisfy your (and others') needs.

Oho, that sounds good to me.

Roger

Hello folks.

After upgrading to 1.6 (and reloading all of my earlier turns - ~160 or so) I noticed that the load time had dramatically increased.

I am running Windows 7 (x64) and 64-bit Java ver.6 update 21 with the following command line: c:\Java\jre6\bin\java -Xms512m -Xmx768m -jar "WitPTracker.jar" nomap

Once loaded everything seems to run fine but the load time went from about ~100 seconds to over 1100 seconds. I haven't been successful running 32 bit java on my 64 bit OS and I have increased the memory allocation with no noticeable differences. Any thoughts? Thanks in advance.

Marc

ORIGINAL: vonTirpitz

Hello folks.

After upgrading to 1.6 (and reloading all of my earlier turns - ~160 or so) I noticed that the load time had dramatically increased.

I am running Windows 7 (x64) and 64-bit Java ver.6 update 21 with the following command line: c:\Java\jre6\bin\java -Xms512m -Xmx768m -jar "WitPTracker.jar" nomap

Once loaded everything seems to run fine but the load time went from about ~100 seconds to over 1100 seconds. I haven't been successful running 32 bit java on my 64 bit OS and I have increased the memory allocation with no noticeable differences. Any thoughts? Thanks in advance.

Marc

Marc,
I think you are using Java 32 bit as V6.update 21 is a 32 bit build... 64 bit Java doesn't work with Tracker as far as I know.

So you are saying that with 1.5.1 with 160 turns loaded it is faster to start even with the map removed ? That is a mystery ... Floyd and I are looking into optimisation but it will probably take us a while to get it right. Java is not quite the "killer" app builder, but it has come a long way in 10 yrs.

So I guess you'll have to look at optimising your computer's programs on start up ... can I ask for your machine specs please.

To the spectators ... Has Java 6 update 21 slowed down Tracker or have you seen any differences from 20 ?

Been fine for ages and now I get this.... any clues?

F:\Mike\Tracker>java -Xms384m -Xmx512m -jar "WitPTracker.jar"
WitP Tracker AE tables loaded in 37 seconds
Exception in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap spa
ce
at java.awt.image.DataBufferInt.<init>(Unknown Source)
at java.awt.image.Raster.createPackedRaster(Unknown Source)
at java.awt.image.DirectColorModel.createCompatibleWritableRaster(Unknow
n Source)
at java.awt.image.BufferedImage.<init>(Unknown Source)
at witptracker.MapPanel$Map.<init>(MapPanel.java:354)
at witptracker.MapPanel.<init>(MapPanel.java:193)
at witptracker.GUIMain.CreateAndShowGUI(GUIMain.java:883)
at witptracker.GUIMain$5.run(GUIMain.java:997)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
F:\Mike\Tracker>pause
Press any key to continue . .

ORIGINAL: Roger Neilson II

Been fine for ages and now I get this.... any clues?

F:\Mike\Tracker>java -Xms384m -Xmx512m -jar "WitPTracker.jar"
WitP Tracker AE tables loaded in 37 seconds
Exception in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap spa
ce
at java.awt.image.DataBufferInt.<init>(Unknown Source)
at java.awt.image.Raster.createPackedRaster(Unknown Source)
at java.awt.image.DirectColorModel.createCompatibleWritableRaster(Unknow
n Source)
at java.awt.image.BufferedImage.<init>(Unknown Source)
at witptracker.MapPanel$Map.<init>(MapPanel.java:354)
at witptracker.MapPanel.<init>(MapPanel.java:193)
at witptracker.GUIMain.CreateAndShowGUI(GUIMain.java:883)
at witptracker.GUIMain$5.run(GUIMain.java:997)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
F:\Mike\Tracker>pause
Press any key to continue . .

Ran out of memory.

Maybe you're running too many other things. Try running with the "nomap" option and see if that fixes it. Or reboot the PC and try with nothing else running and see what happens.

Floyd

Every 3-4 rounds I gets alerts:

The bogus class upgrades to all ships happen every 5 turns and it was my mistake when I added a new function.
I saw it when I was debugging, but neglected to fix it. It will be fixed in the next release.

trying to find where to put the nomap command, can't see!

Have tried in separate line on the .bat file in various places, not doing anything.

Roger

ORIGINAL: Roger Neilson II

trying to find where to put the nomap command, can't see!

Have tried in separate line on the .bat file in various places, not doing anything.

Roger

[font="Courier New"]java -Xms384m -Xmx512m -jar "WitPTracker.jar" nomap[/font]

Not to shame you or anything... this was in the release notes and a new batch file was provided that has this... [;)]

no map cured it, was trying to put it in a separate line, looked at the bat file and saw it goes after the other commands.

Thanks

Roger

Yep. I'm using the 32-bit version of java. Sorry about the confusion. I am running on a Q6600 Quad Core with 6GB RAM.

I am going to put 1.5.1 back on in another folder and run some tests. Will let you know if I figure out what is going on. Thanks!

Marc

ORIGINAL: n01487477

ORIGINAL: vonTirpitz

Hello folks.

After upgrading to 1.6 (and reloading all of my earlier turns - ~160 or so) I noticed that the load time had dramatically increased.

I am running Windows 7 (x64) and 64-bit Java ver.6 update 21 with the following command line: c:\Java\jre6\bin\java -Xms512m -Xmx768m -jar "WitPTracker.jar" nomap

Once loaded everything seems to run fine but the load time went from about ~100 seconds to over 1100 seconds. I haven't been successful running 32 bit java on my 64 bit OS and I have increased the memory allocation with no noticeable differences. Any thoughts? Thanks in advance.

Marc

Marc,
I think you are using Java 32 bit as V6.update 21 is a 32 bit build... 64 bit Java doesn't work with Tracker as far as I know.

So you are saying that with 1.5.1 with 160 turns loaded it is faster to start even with the map removed ? That is a mystery ... Floyd and I are looking into optimisation but it will probably take us a while to get it right. Java is not quite the "killer" app builder, but it has come a long way in 10 yrs.

So I guess you'll have to look at optimising your computer's programs on start up ... can I ask for your machine specs please.

To the spectators ... Has Java 6 update 21 slowed down Tracker or have you seen any differences from 20 ?

Bug report:

I've noticed some oddities WRT Tracker's (Excellent program BTW, thanks) "Ships sunk" tab on the Victory Points page.

1) I like to add notes to the page, but the notes will disappear when I read a new turn. If I close tracker and then restart, the notes will reappear.

2) Sinking reporting: I had a running battle with the HMS Royal Sovereign, first hitting her with two torpedoes on 7/9/42, generating the first sinking report. The 10th and 11th saw more air attacks on her and more sinking reports, but no false sinking report. I finally ran her down with a surface TF and sank her on the 13th. Now here is the really odd part, when I first load tracker the sinking date is listed as the 9th, but when I read a turn the date reverts to the 13th. I'm now to the 17th. BTW: AE lists the sinking date as the 13th.

Hi,
I get a couple of error messages now everytime Tracker starts though I did not notice any oddities in the program itself (yet).

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.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:162)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32969,520,1,0)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:163)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32969,520,3,0)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:164)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32969,520,4,1)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:165)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32969,520,6,12)
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.Pilots.InsertLargeDelta(Pilots.java:180)
at witptracker.Pilots.InsertInTable(Pilots.java:167)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotLargeDelta Values=(32969,520,5,115)
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.Pilots.InsertLargeDelta(Pilots.java:180)
at witptracker.Pilots.InsertInTable(Pilots.java:168)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotLargeDelta Values=(32969,520,7,0)
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.Pilots.InsertInTable(Pilots.java:157)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=Pilots Values=(32970,'Okamoto L.',1,5)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:160)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32970,520,2,0)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:161)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32970,520,0,42)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:162)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32970,520,1,0)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:163)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32970,520,3,0)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:164)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32970,520,4,1)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:165)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32970,520,6,2)
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.Pilots.InsertLargeDelta(Pilots.java:180)
at witptracker.Pilots.InsertInTable(Pilots.java:167)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotLargeDelta Values=(32970,520,5,268)
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.Pilots.InsertLargeDelta(Pilots.java:180)
at witptracker.Pilots.InsertInTable(Pilots.java:168)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotLargeDelta Values=(32970,520,7,0)

ORIGINAL: jetjockey

Bug report:

I've noticed some oddities WRT Tracker's (Excellent program BTW, thanks) "Ships sunk" tab on the Victory Points page.

1) I like to add notes to the page, but the notes will disappear when I read a new turn. If I close tracker and then restart, the notes will reappear.

This I can easily fix.

2) Sinking reporting: I had a running battle with the HMS Royal Sovereign, first hitting her with two torpedoes on 7/9/42, generating the first sinking report. The 10th and 11th saw more air attacks on her and more sinking reports, but no false sinking report. I finally ran her down with a surface TF and sank her on the 13th. Now here is the really odd part, when I first load tracker the sinking date is listed as the 9th, but when I read a turn the date reverts to the 13th. I'm now to the 17th. BTW: AE lists the sinking date as the 13th.

I'd need saves from the 9th thru 13th to see what's happening.

ORIGINAL: Rainer79

Hi,
I get a couple of error messages now everytime Tracker starts though I did not notice any oddities in the program itself (yet).

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.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:162)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32969,520,1,0)
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.Pilots.InsertSmallDelta(Pilots.java:175)
at witptracker.Pilots.InsertInTable(Pilots.java:163)
at witptracker.InMemoryDB.ComparePilotLists(InMemoryDB.java:3003)
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 = -65
Table=PilotSmallDelta Values=(32969,520,3,0)

[...]

Looks like we didn't fully handle more than 32768 pilots, so the index is out of range.

This will need some work...

Floyd

V1.6 stopped working after a few successful runs. How can I export the error messages so I can post them here?

ORIGINAL: KMCCARTHY

V1.6 stopped working after a few successful runs. How can I export the error messages so I can post them here?

In the command window, right-click the mouse and choose Select All. Then go to where you want to put it and choose Paste (or control-v).

I have Java 6 level 20 and it seems to be taking a very long time to load the db. the turn loads fine. I had one where after about 6 minutes I just stopped it, I didn't think it would ever finish. I did notice that task manager was showing Java as using about 6-11% of the CPU, and idle using the rest.