June Release: WitPTracker now at 1.6!

Gary Grigsby's strategic level wargame covering the entire War in the Pacific from 1941 to 1945 or beyond.

Moderators: Joel Billings, wdolson, Don Bowen, mogami

User avatar
Nomad
Posts: 7273
Joined: Wed Sep 05, 2001 8:00 am
Location: West Yellowstone, Montana

RE: WitPTracker 1.1.1

Post by Nomad »

I don't remember if it was last turn or a couple of turns before. I just deleted the db and restarted.
User avatar
Nemo121
Posts: 5838
Joined: Fri Feb 06, 2004 11:15 am
Contact:

RE: WitPTracker 1.1.1

Post 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 ).
John Dillworth: "I had GreyJoy check my spelling and he said it was fine."
Well, that's that settled then.
Chris21wen
Posts: 7718
Joined: Thu Jan 17, 2002 10:00 am
Location: Cottesmore, Rutland

RE: WitPTracker 1.0.2

Post 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.
Chris21wen
Posts: 7718
Joined: Thu Jan 17, 2002 10:00 am
Location: Cottesmore, Rutland

RE: WitPTracker now at 1.1.1

Post 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?
User avatar
n01487477
Posts: 4764
Joined: Tue Feb 21, 2006 12:00 am

RE: WitPTracker now at 1.1.1

Post 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
Attachments
importing.jpg
importing.jpg (68.55 KiB) Viewed 243 times
User avatar
ny59giants
Posts: 9902
Joined: Mon Jan 10, 2005 12:02 pm

RE: WitPTracker now at 1.1.1

Post 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. [&:]
[center]Image[/center]
herwin
Posts: 6047
Joined: Thu May 27, 2004 9:20 pm
Location: Sunderland, UK
Contact:

RE: WitPTracker now at 1.1.1

Post by herwin »

The first time I loaded a turn it worked fine, but the second was hosed. Has anyone else seen this?
Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com
floydg
Posts: 2071
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker now at 1.1.1

Post 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?
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
floydg
Posts: 2071
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker now at 1.1.1

Post 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.
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
herwin
Posts: 6047
Joined: Thu May 27, 2004 9:20 pm
Location: Sunderland, UK
Contact:

RE: WitPTracker now at 1.1.1

Post 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.
Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com
Chris21wen
Posts: 7718
Joined: Thu Jan 17, 2002 10:00 am
Location: Cottesmore, Rutland

RE: WitPTracker now at 1.1.1

Post by Chris21wen »

Air groups showing no leader when there is.


Image
Attachments
Airleaders.jpg
Airleaders.jpg (184.08 KiB) Viewed 243 times
Chris21wen
Posts: 7718
Joined: Thu Jan 17, 2002 10:00 am
Location: Cottesmore, Rutland

RE: WitPTracker now at 1.1.1

Post by Chris21wen »

Got it thanks.
floydg
Posts: 2071
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker now at 1.1.1

Post 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?
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
floydg
Posts: 2071
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: WitPTracker now at 1.1.1

Post 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?

Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Chris21wen
Posts: 7718
Joined: Thu Jan 17, 2002 10:00 am
Location: Cottesmore, Rutland

RE: WitPTracker now at 1.1.1

Post 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
Attachments
ship.jpg
ship.jpg (127.6 KiB) Viewed 243 times
Chris21wen
Posts: 7718
Joined: Thu Jan 17, 2002 10:00 am
Location: Cottesmore, Rutland

RE: WitPTracker now at 1.1.1

Post 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
Attachments
Leader.jpg
Leader.jpg (145.24 KiB) Viewed 243 times
User avatar
n01487477
Posts: 4764
Joined: Tue Feb 21, 2006 12:00 am

RE: WitPTracker now at 1.1.1

Post 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.
User avatar
ny59giants
Posts: 9902
Joined: Mon Jan 10, 2005 12:02 pm

RE: WitPTracker now at 1.1.1

Post 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??
[center]Image[/center]
emek
Posts: 90
Joined: Thu Nov 16, 2000 10:00 am
Location: London

RE: WitPTracker now at 1.1.1

Post 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)
Chris21wen
Posts: 7718
Joined: Thu Jan 17, 2002 10:00 am
Location: Cottesmore, Rutland

RE: WitPTracker now at 1.1.1

Post 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
Attachments
build.jpg
build.jpg (136.41 KiB) Viewed 243 times
Post Reply

Return to “War In The Pacific - Struggle Against Japan 1941 - 1945”