WitpDecoder; Now providing some overview

[Cpt Sherwood]

Woos, in reference to Kids errors, I get the exact same error with his save game file, but with one of my own save game files, I don't get any errors.

[Woos]

Hmm, then there is a corruption in the save game. Which witpdecoder version did you use? V0.3b should handle them.

[Woos]

OK, next minor version is available. It contains at least the following changes (maybe I forgot some).

• Batch Load ability (includes switching off the warnings but not the errors. You have to 'cancel' them by hand). *edit* And maybe I should explain how it works. Select the first file of the batch. All files must have the same structure and a number in the middle. Basically, if the files look similar to the witpXXX.pws files of the save directory, it will work.
• Show all ships of a class by double clicking on the class in the ShipClasses(!) table (will show all ships belonging to a class with that name. If your classes change names between different versions of the class, results may not be what you expect). Suggested by someone here on the forum (forgot who).
• Ship history showing where every ship was over time (up to 512 turns back)
• Point ratio as a part of the "Storage" tab (before the engines, admittedly not very fitting place). Gives a quick impression how much is still lacking to Autovictory.
• Industry tab now shows which bases of a cluster are currently owned by you (in the left lower window). Should help debugging cluserbases.csv files a bit.
• Exceptions no longer show a trace dump in the pop up (only in the log file). Maybe people will be less confused now and actually read what is printed.
• CHS's ship upgrade relationships should no longer be a problem for witpdecoder.

This version is going to become 0.4 if you don't find any bugs (leaving me some time to update the documentation).

Get the new jar file from http://extweb.retsiemuab.de/witp/witpDecoder3c.jar. Make sure that you downloaded a jar file and not a zip file (otherwise stop using IE), and overwrite the witpDecoder2.jar file in your witpdecoder directory with it. Yes, that means renaming the file!

WARNING! As with every new version up to now the database format has changed again. Delete all witp.* files in the witpdecoder directory if you used witpdecoder 0.3b or lower. You can read in the old save files with the batch load function.

[Cpt Sherwood]

Thank you for the upgrade. Would it be possible to include some information about where an error occured? I am having a problem getting a modified senario to initialize, but the error message doesn't tell me where in the ship class csv file it found a problem.

[Woos]

For most of the errors during loading a save game file, the witpdecoder.log file will contain the unit/base/... causing the error. But for most initialization errors this is not possible. Witpdecoder simply tells HSQLDB "There is the csv file. Load it!" and then gets back the error report shown/written to witpdecoder.log. witpdecoder does not know more than what is dumped.

Maybe adding a "hsqldb.applog=true" to the witp.properties file will help or creating a server.properties files with "server.trace=true" in it, but I never tried (see http://hsqldb.org/doc/guide/ch04.html#N10A68 ).

[Local Yokel]

ORIGINAL: Woos

@Local Yokel
There is not much I can do about exceptions coming from the hsqldb stack. You probably managed to get a corrupted database (don't ask me how). Best bet is to delete all witp.* files in the witpdecoder directory and start over. V0.3c will contain a "batch read in" function to make re-filling the database easier.
If you don't have the save games anymore, you could try to fix the mentioned line in the witp.script file, but you would probably need some knowledge about SQL and hsqldb for that.

Many thanks, Woos - I'll gave that a try!

[Local Yokel]

ORIGINAL: Local Yokel

ORIGINAL: Woos

@Local Yokel
There is not much I can do about exceptions coming from the hsqldb stack. You probably managed to get a corrupted database (don't ask me how). Best bet is to delete all witp.* files in the witpdecoder directory and start over. V0.3c will contain a "batch read in" function to make re-filling the database easier.
If you don't have the save games anymore, you could try to fix the mentioned line in the witp.script file, but you would probably need some knowledge about SQL and hsqldb for that.

Many thanks, Woos - I'll gave that a try!

Sorry, meant to say I would 'give' it a try. Have done so and it now seems to load the savefile OK for the reinitialised database - thanks a lot.

[rtrapasso]

It is probably buried somewhere in this mass of stuff, but so far i haven't found it... it says you need JAVA to run this... but when i went to download it, there were multiple different kinds of JAVA present... which one do i need??

[Woos]

> It is probably buried somewhere in this mass of stuff,
In the documentation. Although the page that turns up when following the link given there is a bit confusing.

You need Java Standard Edition Runtime Environment 1.5 or later. Sun probably calls it JRE SE 5 or so. 6 should also work but I never tested it. Thus if you follow the link from the documentation, it is the fourth entry.

[Cpt Sherwood]

Maybe adding a "hsqldb.applog=true" to the witp.properties file will help or creating a server.properties files with "server.trace=true" in it, but I never tried (see http://hsqldb.org/doc/guide/ch04.html#N10A68 ).

The first part of this will not work. A new witp.properties file is created every time the witpDecoder is run. I need to try the second method.

[jcjordan]

Woos
 
 On the tracking ship history part, I've just put the new jar file in & had to delete all the old witp***.dat & the csv files I was using under ver2c, will I have to wait a few days before it starts to show any history? Currently I get the list of ships but when I click on a ship it shows no history of movements. Just wondering & looking good!!

[USSAmerica]

OK, I have been getting exactly the same error as Kid posted above.  I grabbed the 3c.jar, renamed it witpDecoder2.jar, deleted everything in my folder starting with witp.* and tried it again.  I am getting the same error, but with more detail now:
 
There is a problem with leader Sze S. as follows:
Couldn't write things to the DB due tojava.sql.SQLException: Integrity constraint violation - no parent LeadersRankMustExist table: Ranks
java.sql.SQLException: Integrity constraint violation - no parent LeadersRankMustExist table: Ranks
 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 de.retsiemuab.witpDecoder.bi.a(Unknown Source)
 at de.retsiemuab.witpDecoder.aA.b(Unknown Source)
 at de.retsiemuab.witpDecoder.aA.a(Unknown Source)
 at de.retsiemuab.witpDecoder.al.a(Unknown Source)
 at de.retsiemuab.witpDecoder.bm.run(Unknown Source)
 at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
 at de.retsiemuab.witpDecoder.y.a(Unknown Source)
 at de.retsiemuab.witpDecoder.b.widgetSelected(Unknown Source)
 at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
 at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
 at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
 at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
 at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
 at de.retsiemuab.witpDecoder.M.a(Unknown Source)
 at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
 at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
 
What is my next step to track this error down?  I'm trying to load a PBEM, stock scn 015 game.

[Woos]

Actually it is not the same error as Kid had. You have a leader with a corrupt rank (CPT, etc.), Kid had a leader with a corrupt command ability (i.e. whether he can command a HQ, ship, ...). The latter is caught by witpdecoder (since 0.3b I think), the former will only be caught in V0.4.

Up to then there is not much you can do since you can't change the rank of a leader in game. Maybe you should try to get him die on a sinking ship It is always surprising what kind of corruptions WitP introduces into the save file.

[USSAmerica]

Ok, I'll see if I can hunt down Sze S. in my game.  Meanwhile, I'll wait for the V0.4 release.  This tool is fantastic!
 
Thanks for all your hard work, Woos!![&o][8D]

[USSAmerica]

Anyone have any ideas or suggestions for how I can find the corrupted Sze S. leader?  I have no idea what kind of leader he is, and he doesn't seem to be in the Stock 015 scenario at start.  I can't begin to look for him within the actual game.  The only information I have to go on is listed in my error message above, and Woos' confirmation that he has a corrupted Rank value....  [8|]

[WhoCares]

There is a CPT. Sze S.  as a pilot in the 3rd CBS based in Chengtu. Might be that it's commanding officer was lost somehow and he took command of the air group. Might be that he was some kind of random replacement pilot, so you might find him in a different chinese air unit. Could also be that he got into a command position when you split an air unit and he took command of a fragment....

[USSAmerica]

ORIGINAL: WhoCares

There is a CPT. Sze S.  as a pilot in the 3rd CBS based in Chengtu. Might be that it's commanding officer was lost somehow and he took command of the air group. Might be that he was some kind of random replacement pilot, so you might find him in a different chinese air unit. Could also be that he got into a command position when you split an air unit and he took command of a fragment....

I found him. He's a possible replacement leader for the 5th CBS, currently holding the rank of WO. I have a 2 plane fragment of the 5th at Chungking where I'll put him in command. Time for a 2 plane, unescorted bomb run on the Resource Industry at Wuhan. [:D] 13 political points to change the leader of 2 planes???[X(] Small price to pay to be able to use the Decoder. [8D]

Thanks, WhoCares![:)]

[Roger Neilson II]

ok, I now have this working for both the base game and the CHS game.....

So, has anyone created clusters for these and how do you use them?

Roger

[&:]

[Martti]

Here are the clusterfiles I made for stock scenario 15:

http://koti.mbnet.fi/~zombie/clusters.csv
http://koti.mbnet.fi/~zombie/clusterbases.csv

Make a clean install of WITPDecoder and place clusterfiles into the same directory. Then read the savegamefiles normally.

[Roger Neilson II]

Thanks, sorted.

Roger