Page 12 of 60

RE: WitPTracker 1.1.1

Posted: Mon Jun 02, 2008 1:16 am
by Nomad
I don't remember if it was last turn or a couple of turns before. I just deleted the db and restarted.

RE: WitPTracker 1.1.1

Posted: Mon Jun 02, 2008 9:23 am
by Nemo121
It would be REALLY nice to be able to see something like "projected engine requirements 6 months, 12 months, 18 months and 24 months" for each engine type ( taking into account full repairs and auto-upgrade ).

RE: WitPTracker 1.0.2

Posted: Mon Jun 02, 2008 3:06 pm
by Chris21wen
Just run the tracker for the first time. I have a problem with some ship class icon not displaying the correct ships. CHS scenario156.

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 10:33 am
by Chris21wen
Hakkaido is not connected tot he rest of Japan so I want it as a separte region which I've created but I can't work out how do I add, or delate bases from regions?

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 10:54 am
by n01487477
Ok Chris,
sorry haven't replied before ... what mod are you playing ? I see that you said 156. This is the extended map right ?

Included with the Tracker are some "cluster files".

1. If you go File -> Import Base
2. You will get the open file dialogue.
3. Go into region mappings.
4. Pick the mod you use and the cluster should import and help you. (your case chs2_08s.txt) I'm not sure how good it is, as I don;t play chs, and I made the cluster quickly.

If you want to change the Regions, Click File - Regions and you can edit or add/ delete regions.
And changing a base is done by using the drop-down on the Base screen -> region column.

If you want to build the cluster from scratch, unassign all the bases and delete all the regions. I guess you don;t want to do that so use the chs file, (tell me if there are any problems), and then edit your regions and bases assigned to regions.

The *.pdf, can give you some more help, and if you make a cluster you like send it to me and maybe we will use it in the next release. If this isn't detailed enough, I'll do a step by step for you ...

Lastly, if you are really stuck, I'll make a new cluster for you, for that scenario

Not sure about your icon problem, do you have the path correct in your properties file or do you have more than 1 mod installed ?

Cheers

Image

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 10:54 am
by ny59giants
Hakkaido is not connected tot he rest of Japan so I want it as a separte region which I've created but I can't work out how do I add, or delate bases from regions?


I've done the clusters for Big B's and Empire's Ablaze, so I'm kinda good at this. [;)]
Go to File. Then to the "Regions." Click on "New" and make one named "Hakkaido." Now you can go back into "Bases" and change the bases to your new Region. Voila, you are there!!

I don't remember if they take effect right away or have to wait for the next turn to be loaded. [&:]

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 11:13 am
by herwin
The first time I loaded a turn it worked fine, but the second was hosed. Has anyone else seen this?

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 2:58 pm
by floydg
ORIGINAL: herwin

The first time I loaded a turn it worked fine, but the second was hosed. Has anyone else seen this?

What about it wasn't working?

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 2:59 pm
by floydg
ORIGINAL: ny59giants
Hakkaido is not connected tot he rest of Japan so I want it as a separte region which I've created but I can't work out how do I add, or delate bases from regions?


I've done the clusters for Big B's and Empire's Ablaze, so I'm kinda good at this. [;)]
Go to File. Then to the "Regions." Click on "New" and make one named "Hakkaido." Now you can go back into "Bases" and change the bases to your new Region. Voila, you are there!!

I don't remember if they take effect right away or have to wait for the next turn to be loaded. [&:]

Should be immediate.

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 4:29 pm
by herwin
ORIGINAL: floydg

ORIGINAL: herwin

The first time I loaded a turn it worked fine, but the second was hosed. Has anyone else seen this?

What about it wasn't working?

My opponent tells me he saw the sync bug with that turn. It may be a hosed save file.

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 4:58 pm
by Chris21wen
Air groups showing no leader when there is.


Image

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 5:32 pm
by Chris21wen
Got it thanks.

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 7:40 pm
by floydg
ORIGINAL: herwin

ORIGINAL: floydg

ORIGINAL: herwin

The first time I loaded a turn it worked fine, but the second was hosed. Has anyone else seen this?

What about it wasn't working?

My opponent tells me he saw the sync bug with that turn. It may be a hosed save file.

I'm not sure if the sync bug would have any affect on the WitPTracker from reading the save game file. So what specifically is not working about the program when you read in a turn?

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 7:42 pm
by floydg
ORIGINAL: Chris H

Air groups showing no leader when there is.

I'm sure the Air Group does have a leader. I've seen some cases where leaders are missed from the save file. Can you verify that the actual leader appears in the Leaders panel?


RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 7:54 pm
by Chris21wen
OK can somebody help please. I-27 is due in three days but the Durability is 25, greater than delay. Ships are built when Dur*10>delay but the figures make no sense?

I've got ships in the queue that havn't started to be buit yet but there Dur etc is less than the delay. I'm missing somthing here and i can't spot it.

Image

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 9:06 pm
by Chris21wen
ORIGINAL: floydg

ORIGINAL: Chris H

Air groups showing no leader when there is.

I'm sure the Air Group does have a leader. I've seen some cases where leaders are missed from the save file. Can you verify that the actual leader appears in the Leaders panel?

It does indeed, at least in the game. He doesn't exist anywhere in the tracker which includes the pilot list for the 27th Lt Sentai


Image

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 10:09 pm
by n01487477
ORIGINAL: Chris H

OK can somebody help please. I-27 is due in three days but the Durability is 25, greater than delay. Ships are built when Dur*10>delay but the figures make no sense?

I've got ships in the queue that havn't started to be buit yet but there Dur etc is less than the delay. I'm missing somthing here and i can't spot it.

Image
OK. some thing you need to understand first
1. Ships are able to build if their durability * 10 < delay. These ships can be
accelerated, at triple the durability cost. or it means that "Start Building" is (-) numbers (how many day it has been building)

2. Ships not in the first group, but can be built at accelerated if durability * 30 < delay. The
cost to accelerate these equals durability.

3. Ships Durability * 10 = the normal number of days to build a vessel. Also adding Delay and Start Building give total build time.

4.Build Points/Aggregate - just gives a running total as you go down the list.

5.The other columns are to manually calculate ... via a drop down on the CalBr column.

6.Durability is a constant, it never changes ... for building.

OK so in your example:
1. SS I-27 25*10 = 250, so it commenced building when it's delay was 250 days. And continued building, as delay reduced one day per turn from then on. It started building -247 days ago, so it has 3 days remaining.
2. It's build points are equal to durability = 25 (disregard the aggregate for now - it's for my calculations - it shows the aggregate total for ships building)
3. You have 1189 Points/turn and 2925 points stored = 4000+ points. And are using 1156 points this turn. Leaving you an additional 33 points into the pool, which will total 2958 next turn.
4. So if you wanted to accelerate some ships, you can use the drop down on calBR to adjust "what if" and then see the total points expended in Cal Pts. (Point 2 (above), is not adequately dealt with yet in this yet, but I'm getting to it)

Maybe I should start a tutorial page ... on this and other things, if the *.pdf and other forum area's are not enough explanation ...

Hope this helps.

RE: WitPTracker now at 1.1.1

Posted: Tue Jun 03, 2008 11:40 pm
by ny59giants
Maybe I should start a tutorial page ... on this and other things, if the *.pdf and other forum area's are not enough explanation ...


I need classes on Air and LCU Production for Dummies. [:D]
When and where can I sign up??

RE: WitPTracker now at 1.1.1

Posted: Wed Jun 04, 2008 5:36 am
by emek
Can you look at this error log? Anything can be done?
This is CHS 155 game.

Another thing is it possible to show para units out of all inf units there for allies?

)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Insert Error code = -104
Table=LeaderLargeDelta Values=(21493,115,8,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_81
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:56)
at witptracker.Leader.InsertSmallDelta(Leader.java:195)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:259)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderSmallDelta Values=(21494,115,7,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_83
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:56)
at witptracker.Leader.InsertLargeDelta(Leader.java:200)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:268)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderLargeDelta Values=(21494,115,8,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_81
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:56)
at witptracker.Leader.InsertSmallDelta(Leader.java:195)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:259)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderSmallDelta Values=(21495,115,7,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_83
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:56)
at witptracker.Leader.InsertLargeDelta(Leader.java:200)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:268)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderLargeDelta Values=(21495,115,8,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_81
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:56)
at witptracker.Leader.InsertSmallDelta(Leader.java:195)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:259)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderSmallDelta Values=(21496,115,7,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_83
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:56)
at witptracker.Leader.InsertLargeDelta(Leader.java:200)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:268)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderLargeDelta Values=(21496,115,8,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_81
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:56)
at witptracker.Leader.InsertSmallDelta(Leader.java:195)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:259)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderSmallDelta Values=(21497,115,7,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_83
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:56)
at witptracker.Leader.InsertLargeDelta(Leader.java:200)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:268)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderLargeDelta Values=(21497,115,8,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_81
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:56)
at witptracker.Leader.InsertSmallDelta(Leader.java:195)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:259)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderSmallDelta Values=(21498,115,7,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_83
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:56)
at witptracker.Leader.InsertLargeDelta(Leader.java:200)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:268)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderLargeDelta Values=(21498,115,8,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_81
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:56)
at witptracker.Leader.InsertSmallDelta(Leader.java:195)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:259)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderSmallDelta Values=(21499,115,7,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_83
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:56)
at witptracker.Leader.InsertLargeDelta(Leader.java:200)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:268)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderLargeDelta Values=(21499,115,8,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_81
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:56)
at witptracker.Leader.InsertSmallDelta(Leader.java:195)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:259)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderSmallDelta Values=(21500,115,7,0)
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for
column(s) $$: SYS_PK_83
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:56)
at witptracker.Leader.InsertLargeDelta(Leader.java:200)
at witptracker.Leader.UpdateLeaderInDB(Leader.java:268)
at witptracker.InMemoryDB.CompareLeaderLists(InMemoryDB.java:491)
at witptracker.ReadTurnTask.doInBackground(ReadTurnTask.java:126)
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=LeaderLargeDelta Values=(21500,115,8,0)

RE: WitPTracker now at 1.1.1

Posted: Wed Jun 04, 2008 7:56 am
by Chris21wen
ORIGINAL: n01487477
ORIGINAL: Chris H

OK can somebody help please. I-27 is due in three days but the Durability is 25, greater than delay. Ships are built when Dur*10>delay but the figures make no sense?

I've got ships in the queue that havn't started to be buit yet but there Dur etc is less than the delay. I'm missing somthing here and i can't spot it.

Image
OK. some thing you need to understand first
1. Ships are able to build if their durability * 10 < delay. These ships can be
accelerated, at triple the durability cost. or it means that "Start Building" is (-) numbers (how many day it has been building)

2. Ships not in the first group, but can be built at accelerated if durability * 30 < delay. The
cost to accelerate these equals durability.

3. Ships Durability * 10 = the normal number of days to build a vessel. Also adding Delay and Start Building give total build time.

4.Build Points/Aggregate - just gives a running total as you go down the list.

5.The other columns are to manually calculate ... via a drop down on the CalBr column.

6.Durability is a constant, it never changes ... for building.

OK so in your example:
1. SS I-27 25*10 = 250, so it commenced building when it's delay was 250 days. And continued building, as delay reduced one day per turn from then on. It started building -247 days ago, so it has 3 days remaining.
2. It's build points are equal to durability = 25 (disregard the aggregate for now - it's for my calculations - it shows the aggregate total for ships building)


So in the example below the Shinano started to be built when its delay was 1800. The value in Delay is reduced by 180 each turn, while start building increase, al-be-it negatively, by 180 each turn. The two should add up to 1800.

Image