USFS-PNW / Fia-Biosum-Manager

User interface and main code repository for Biosum
http://biosum.info/
Other
3 stars 3 forks source link

Optimizer throws an SQL Logic Errors on economic filtering #348

Closed jsfried closed 1 week ago

jsfried commented 2 months ago

We have two scenarios in our CWI project (currently being posted to BioSumBox\projects\cwi) that are throwing an error:

image

when we try to apply an economic filter on net revenue 1 (summed net revenue across the 4 cycles), where we seek to have it >0 or >-200 - in neither case are we able to complete the optimization. This is the input screen that was used:

image

This is critical for the presentation we are preparing for SAF.

@Cat-Ducat-USDA @lbross

lbross commented 2 months ago

I discovered this earlier this morning and asked @druepdx to take a look. It is due to the migration of Optimizer parameters to SQLite. There is no workaround.

druepdx commented 2 months ago

I found the cause of the error and pushed the fix to my fork

jsfried commented 2 months ago

Does this mean that we might be able to cease and desist on our hail mary MS Access workarounds to geenrate output for these economic filtered scenarios and see a new msi soon?

lbross commented 1 week ago

Fixed in v5.11.0.