witpDecoder 0.5 released

[VSWG]

I used the link above. What's the error message?

[Roger Neilson II]

Ok, I just reinstalled the programme to a clean folder. I have already installed to two other ones that worked fine.... base WITP and CHS 155. This is CHS158.

Picture of screen report attached. Here is the log file:

java.lang.ClassNotFoundException: de.retsiemuab.witpDecoder.gui.mapviewPlugins.TestPlugin
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at de.retsiemuab.witpDecoder.gui.am.<init>(Unknown Source)
at de.retsiemuab.witpDecoder.gui.H.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
Not loading one/all plugins.
Could not create or initialize the databasejava.sql.SQLException: Numeric value out of range
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 de.retsiemuab.witpDecoder.d.a(Unknown Source)
at de.retsiemuab.witpDecoder.ioreaders.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.d.b(Unknown Source)
at de.retsiemuab.witpDecoder.gui.at.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.u.d(Unknown Source)
at de.retsiemuab.witpDecoder.gui.i.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.H.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
Couldn't set up a working DB template. Bad, Bad.

[Woos]

Please see post 18.

BTW, the first Exception indicates that you didn't correctly install the de/retsiemuab/... directory containing the Plugin (or that I put it wrongly into the zip archive).

I made no changes to the zip files since I put it on-line yesterday. VSWG is talking about a beta version where he managed to find some errors (including the "USA base oil doesn't work" error which was caused by me being too blind to see that I programmed a "=" instead of a "+=".

[Roger Neilson II]

Its odd, as I have already installed the files into two other WITP file structures with no problem. So the install should be identical. The previous WITPdecoder works fine on the 158 scenario so I know everything is ok in terms of my set up. I will simply try again from scratch with a new download and see what that does.

Roger

[USSAmerica]

Two installations for my AI and PBEM games of CHS 155 are both working great for me.&nbsp; [8D]
&nbsp;
One question.&nbsp; Is there any way to display "automatically generated" or bonus supply/fuel/oil/resources at bases, in addition to their industry generated amounts?&nbsp; For example, the supply and fuel generated at San Francisco in stock.&nbsp; There are a lot of these type bases in CHS.
&nbsp;
Thanks again, Woos!&nbsp; Merry Christmas! [:)]

[Roger Neilson II]

Numerous installs and reinstalls, deleting things and anything else I can think of have all failed to get this one working.

For the moment I give up.

Roger

[VSWG]

ORIGINAL: USS America

One question. Is there any way to display "automatically generated" or bonus supply/fuel/oil/resources at bases, in addition to their industry generated amounts? For example, the supply and fuel generated at San Francisco in stock. There are a lot of these type bases in CHS.

Daily supply/fuel/oil/resources is recognized and displayed by witpDecoder! [:)] Or do you want to have them displayed separately?

ORIGINAL: Woos

I made no changes to the zip files since I put it on-line yesterday. VSWG is talking about a beta version where he managed to find some errors (including the "USA base oil doesn't work" error which was caused by me being too blind to see that I programmed a "=" instead of a "+=".

Yes, sorry for the confusion. This bug is fixed in the version posted in this thread. I'm using this new version, and it works fine with my CHS Scen 158 PBEM.

[Roger Neilson II]

Well I can see no logical explanation why it won't work for me. V.4 works fine. I have created a new folder (in the right place) and about ten times now installed v.5 into there and run it... all with the same results. I have several times deleted the excel files that witpload creates in the scenario folder as well and watched them rebuild when I run v.5.

I have done exactly the same install for my CHS 155 and my base 15 scenarios in other installs and they both worked first time.

I can only think that there is some problem with the scenario files - if I load a new original scenario file will that mess up my game?

Roger

[USSAmerica]

ORIGINAL: VSWG

ORIGINAL: USS America

One question. Is there any way to display "automatically generated" or bonus supply/fuel/oil/resources at bases, in addition to their industry generated amounts? For example, the supply and fuel generated at San Francisco in stock. There are a lot of these type bases in CHS.

Daily supply/fuel/oil/resources is recognized and displayed by witpDecoder! [:)] Or do you want to have them displayed separately?

Maybe my understanding of the base screen for US in CHS 155 is wrong then. The base shows Oil Storage: 55000/6000, and the Oil industry at the base is currently: (499) x 1.

WitPDecoder 0.5 displays the following for the US base: United States: 6 (+2994)

Seems to me the Decoder display matches perfectly with the "Oil Industry" at the base. What then, is the /6000 displayed on the base Oil Storage? I took it to mean the same as SF in Stock, where there is Supply Storage and then "bonus" supply production at the base.

Anyone have any ideas that can clear this up for me? [:)]

[VSWG]

ORIGINAL: USS America

WitPDecoder 0.5 displays the following for the US base: United States: 6 (+2994)

The Industry tab displays only numbers for the entire cluster, not single bases, so I have no idea how you are able to see the production for "United States" alone - unless you use a separate cluster for this base only.

BTW, (499) x1 means 499 damaged oil centers, and 1 undamaged, so your total oil production by industry should be 6, for a total of 6006.

Seems to me the Decoder display matches perfectly with the "Oil Industry" at the base. What then, is the /6000 displayed on the base Oil Storage? I took it to mean the same as SF in Stock, where there is Supply Storage and then "bonus" supply production at the base.

You are correct, the /6000 means another 6000 oil arriving every day at this base. As I said above, this wasn't displayed correctly in V. 0.4, but it works fine for me now - are you sure you are using V. 0.5? Have you deleted all witp.* files before installing the new version?

[VSWG]

Ahhh, you're looking at the storage tab!! True, these numbers do not include off-map production.

[USSAmerica]

Thanks, Martin!
&nbsp;
OK, Woos.&nbsp; Future enhancement, perhaps?&nbsp; [;)]

[RAM]

ORIGINAL: Woos

ORIGINAL: RAM
yah, got the problem too, I'm trying to load a savegame of the scenario 157, got exactly the same error.

Can't be since other people reported the problem during initialization, not during save game loading.

This is most probably a mismatch between the value range witpDecoder's database expect for some AC attribute and what CHS choose to set it to. Unless someone with this error sends me the generated WITP???.csv files from his witpdecoder directory I can't do anything about it. I got CHS 158c (due to some other issues) and with that the problems doesn't seem to occur.

Oh, and no fix before Christmas anyway, have a nice holiday.

my error, sorry, it happens during initialization.

this is the error message in the log file:

In getDataName()
Could not create or initialize the databasejava.sql.SQLException: Numeric value out of range
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 de.retsiemuab.witpDecoder.d.a(Unknown Source)
at de.retsiemuab.witpDecoder.ioreaders.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.d.b(Unknown Source)
at de.retsiemuab.witpDecoder.gui.at.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.u.d(Unknown Source)
at de.retsiemuab.witpDecoder.gui.i.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.H.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)

[Local Yokel]

I'm also getting the 'Numeric value out of range' error. Have sent PM with copies of the requested csv files. Error triggered by CHS scenario 157, version 2.08.

[BigBadWolf]

Just to say that I'm loving it, Woos. Great work&nbsp; [&o][&o][&o]

[Martti]

Thank you very much for the update, Woos. However, I am having problems with batch load as allies (stock scenario 15). I keep getting SQL errors after reading in 2-3 files.

1. attempt:

Couldn't write things to the DB due to java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_IDX_87
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_IDX_87
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.d.a(Unknown Source)
at de.retsiemuab.witpDecoder.data.h.a(Unknown Source)
at de.retsiemuab.witpDecoder.data.l.a(Unknown Source)
at de.retsiemuab.witpDecoder.b.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aT.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.u.b(Unknown Source)
at de.retsiemuab.witpDecoder.gui.C.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.H.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)

2. attempt (after clearing and re-initializing, and beginning reading at a couple a files later):

Couldn't write things to the DB due to java.sql.SQLException: S1000 General error java.lang.NullPointerException
java.sql.SQLException: S1000 General error java.lang.NullPointerException
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.d.a(Unknown Source)
at de.retsiemuab.witpDecoder.data.l.a(Unknown Source)
at de.retsiemuab.witpDecoder.b.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aT.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.u.b(Unknown Source)
at de.retsiemuab.witpDecoder.gui.C.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.H.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)

3. attempt (after reading the first couple of files manually):

Couldn't write things to the DB due to java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_84
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_84
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.d.a(Unknown Source)
at de.retsiemuab.witpDecoder.data.h.a(Unknown Source)
at de.retsiemuab.witpDecoder.data.l.a(Unknown Source)
at de.retsiemuab.witpDecoder.b.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aT.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.u.b(Unknown Source)
at de.retsiemuab.witpDecoder.gui.C.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.H.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)

As japanese everything went smoothly (based on a single game). 1.806, no mods.

[skrewball]

Ok I am confused when it comes to the clusterbases and clusters csvs. I am using CHS Scen 155. So can I used one of the included CSVs? 192 has the extended map, should I used that one? How will I know if something is incompatible? Thanks.

(edit)HELP...

Ok, I am trying to load my PBEM savefiles. I have tried numerous savefiles of both the Allies and Japanese and I get the same error:

(Edit2) I have also used fresh turns from my inbox and also loaded the save in game, put in my password and re-saved it. (Sorry for all the edits but I work in IT and I know the more info the better [:D])

Aborting a non-running Transaction. Most probably something is wrong
Couldn't write things to the DB due to java.sql.SQLException: Access is denied: Session is closed
java.sql.SQLException: Access is denied: Session is closed
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at de.retsiemuab.witpDecoder.d.query(Unknown Source)
at de.retsiemuab.witpDecoder.b.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aT.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.u.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.b.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.H.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)

Does anyone know what this means?

[VSWG]

ORIGINAL: skrewball

Ok I am confused when it comes to the clusterbases and clusters csvs. I am using CHS Scen 155. So can I used one of the included CSVs? 192 has the extended map, should I used that one? How will I know if something is incompatible? Thanks.

You can use Feurer Krieg's files (Scen 160) if you are playing Japanese. If you're Allies, ctangus made some files for CHS.

In general, all CHS scenarios have identical bases and economies, so CHS cluster-files written for one CHS scenario can be used for all other CHS scenarios, too. However, the cluster-files for Allies and Japanese are always completely different (not only for CHS), so you have to make sure you are using the files that were written for your side.

[Mistmatz]

ORIGINAL: 1EyedJacks

Hi Woos,

Does this new version by any chance work with RHS EOS?

I tried the old and the new version of the decoder with RHS scen 70 (CVO variant). In both cases it didn't work out.

The message I get with V0.5 when I try to initialize the database is:

"Could not create or initialize the database

java.sql.SQLExceptio: Not all ship classes could be read into witpDecoder. This is probably causedby ship update cycles in the scenario. As a result the database can not be initialized.
The classes which weren't read in are: 800"

Any idea if this can be fixed easily or maybe any plans on supporting the RHS scenarios?

[Baskaatje]

I also get an error message, after several messages telling me a lot of units lack a HQ. This is the message:

Hope there is a solution, as I have just started WitP (now two weeks in playing, scen 002 and I am in January '42) and am just getting the hang of it (after it scared me in the first few turns
This tool seems to be able to give me that bit of extra I need to really grasp the game.

Thanks,

Bas