premise exits after generating and writing database

[CHarpprecht]

Hi Romain,

I observed the following behaviour:

When premise is done writing one scenario database or superstructure database, it exits unexpectedly and without any notice.
The last prints after ndb.write_superstructure_db_to_brightway() are:

Created database: SS_remindei3.10.1_update_all_SSP2_2025-2060_prv230_bw2io0812
Generate scenario report.

This is not very convenient as it cannot be incorporated into a longer script due to this silent exit.

[romainsacchi]

Hi @CHarpprecht are you using the latest version?
Could it be that there's insufficient RAM)?
Does the jupyter server terminal show anything else?
I do not see this usually.

[CHarpprecht]

Hi Romain,
I am using version 2.3.0 but not Jupyter Notebooks, but normal python scripts. We would like to use premsie in a longer workflow.
Nothing else is shown.
I don't think there is insufficient RAM, as this also appears with only 2 scenarios.

[romainsacchi]

Hi @CHarpprecht, the issue is that, without being able to reproduce it, it is challenging for me to address it.
Can you reproduce the issue on another computer or a different OS?

[romainsacchi]

Hi @CHarpprecht, I've tried to refactor the code for generating the end reports.
I've also added a switch to prevent report generation if it is still an issue.

NewDatabase(
    ...
    generate_reports=False
)

[CHarpprecht]

Hi @romainsacchi ,
thank you very much. The switch generate_reports=False is working in the sense that the crash does not occur anymore when writing a DB.

However, I can still not generate the scenario report (change report used to be the same issue I believe, but I have not tried it again).

Something goes wrong in ndb.generate_scenario_report():

• the report is not created (at least I cannot find it).
• the last line never gets printed:

        ...
        generate_summary_report(self.scenarios, filepath / name)  # is the issue in this function?
        print(f"Report saved under {filepath}.")  # this never gets printed 

• our suspicion is that in generate_summary_report(self.scenarios, filepath / name) something goes wrong with writing and/or saving the excel workbook (e.g. is the excel line limit exceeded or such?)

Here is the code and its output:

import premise
print("premise version", premise.__version__)

from premise import NewDatabase
import bw2data

bw2data.projects.set_current("ei310")  

ndb = NewDatabase(
    scenarios=[
        {"model": "image", "pathway": "SSP2-M", "year": 2025},  # "SSP2-Base"
    ],
    source_db="ecoinvent-3.10.1-cutoff",  # <-- name of the database in the BW2 project. Must be a string.
    source_version="3.10",  # <-- version of ecoinvent. Can be "3.8", "3.9" or "3.10". Must be a string.
    key="",  # <-- decryption key
    keep_source_db_uncertainty=True,  # False by default, set to True if you want to keep ecoinvent's uncertainty data
    keep_imports_uncertainty=True,  # False by default, set to True if you want to keep the uncertainty data of the additional inventories
    use_absolute_efficiency=False,  # False by default, set to True if you want to use the IAM's absolute efficiencies
)
ndb.update()  
db_name = "ei_cutoff_3.10_image_SSP2-M_2025_update-all_pv232_bw2io0812"
ndb.write_db_to_brightway(name=[db_name])

Output:

does not print filepaths of reports, and stops after: "Generate scenario report."

....
Minor anomalies found: check the change report.
Writing activities to SQLite3 database:
0% [##############################] 100% | ETA: 00:00:00
Total time elapsed: 00:00:33
Total time elapsed: 00:00:33
  Finished: 11/19/2025 11:24:43
  Finished: 11/19/2025 11:24:43
  Finished: 11/19/2025 11:24:43
  Total time elapsed: 00:00:33
  CPU %: 46.70
  Memory %: 18.17
.pixi\envs\prod\Lib\site-packages\whoosh\codec\whoosh3.py:1116: SyntaxWarning: "is" with a literal. Did you mean "=="? 
  elif fixedsize is 0:
Created database: ei_cutoff_3.10_image_SSP2-M_2025_update-all_pv232_bw2io0812
Generate scenario report.

• premise version: premise-bw2 2025.11.18 , 2.3.2
• full environment info is here: env.txt

[CHarpprecht]

Hi @romainsacchi ,

I now got a print of an error message. Shown here for generating the change report, see below.
It seems that there is "NA" in the data which cannot be written to excel.

Created database: ei_cutoff_3.10_image_SSP2-M_2025_update-all_pv232_unfold124_bw2io0812
1
Generate change report.
Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "...explorations\1_write_premise_db.py", line 36, in <module>
    ndb.generate_change_report()  # TODO: Note: silent crash, not sure where saved, should be called change_report {datetime.now().strftime('%Y-%m-%d')}.xlsx  
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "....pixi\envs\prod\Lib\site-packages\premise\new_database.py", line 1526, in generate_change_report
    generate_change_report(
  File "....pixi\envs\prod\Lib\site-packages\premise\report.py", line 806, in generate_change_report
    worksheet.append(r)
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\worksheet\worksheet.py", line 673, in append
    cell = Cell(self, row=row_idx, column=col_idx, value=content)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\cell\cell.py", line 119, in __init__
    self.value = value
    ^^^^^^^^^^
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\cell\cell.py", line 218, in value
  File "....pixi\envs\prod\Lib\site-packages\premise\new_database.py", line 1526, in generate_change_report
    generate_change_report(
  File "....pixi\envs\prod\Lib\site-packages\premise\report.py", line 806, in generate_change_report
    worksheet.append(r)
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\worksheet\worksheet.py", line 673, in append
    cell = Cell(self, row=row_idx, column=col_idx, value=content)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\cell\cell.py", line 119, in __init__
    self.value = value
  File "....pixi\envs\prod\Lib\site-packages\premise\new_database.py", line 1526, in generate_change_report
    generate_change_report(
  File "....pixi\envs\prod\Lib\site-packages\premise\report.py", line 806, in generate_change_report
    worksheet.append(r)
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\worksheet\worksheet.py", line 673, in append
    cell = Cell(self, row=row_idx, column=col_idx, value=content)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\cell\cell.py", line 119, in __init__
  File "....pixi\envs\prod\Lib\site-packages\premise\new_database.py", line 1526, in generate_change_report
    generate_change_report(
  File "....pixi\envs\prod\Lib\site-packages\premise\report.py", line 806, in generate_change_report
    worksheet.append(r)
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\worksheet\worksheet.py", line 673, in append
  File "....pixi\envs\prod\Lib\site-packages\premise\new_database.py", line 1526, in generate_change_report
    generate_change_report(
  File "....pixi\envs\prod\Lib\site-packages\premise\report.py", line 806, in generate_change_report
  File "....pixi\envs\prod\Lib\site-packages\premise\new_database.py", line 1526, in generate_change_report
  File "....pixi\envs\prod\Lib\site-packages\premise\new_database.py", line 1526, in generate_change_report
    generate_change_report(
  File "....pixi\envs\prod\Lib\site-packages\premise\report.py", line 806, in generate_change_report
    worksheet.append(r)
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\worksheet\worksheet.py", line 673, in append
    cell = Cell(self, row=row_idx, column=col_idx, value=content)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\cell\cell.py", line 119, in __init__
    self.value = value
    ^^^^^^^^^^
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\cell\cell.py", line 218, in value
    self._bind_value(value)
  File "....pixi\envs\prod\Lib\site-packages\openpyxl\cell\cell.py", line 187, in _bind_value
    raise ValueError("Cannot convert {0!r} to Excel".format(value))
ValueError: Cannot convert <NA> to Excel

[romainsacchi]

@CHarpprecht what did you change to have the error showing?

[CHarpprecht]

Before, I used an environment with premise-bw2 from conda.
Now, I updated my environment to get the newest unfold version 1.2.4 into the same environment: premise-bw2 is now from pypi and unfold 1.2.4 as well from pypi (as otherwise, unfold was pinned to 1.2.3)

[CHarpprecht]

Updated environment information:

pixi list
Environment: prod
Package                    Version                Build                  Size        Kind   Source
annotated-types            0.7.0                  pyhd8ed1ab_1           17.7 KiB    conda  https://conda.anaconda.org/conda-forge/
appdirs                    1.4.4                  pyhd8ed1ab_1           14.5 KiB    conda  https://conda.anaconda.org/conda-forge/
asteval                    1.0.6                  pyhd8ed1ab_0           25.6 KiB    conda  https://conda.anaconda.org/conda-forge/
astunparse                 1.6.3                  pyhd8ed1ab_3           17.7 KiB    conda  https://conda.anaconda.org/conda-forge/
attrs                      25.4.0                                        227.8 KiB   pypi   attrs-25.4.0-py3-none-any.whl
boto3                      1.41.0                                        965.2 KiB   pypi   boto3-1.41.0-py3-none-any.whl
botocore                   1.41.0                                        17.8 MiB    pypi   botocore-1.41.0-py3-none-any.whl
bottleneck                 1.6.0                                         326.9 KiB   pypi   bottleneck-1.6.0-cp311-cp311-win_amd64.whl
brotli-python              1.1.0                  py311h3e6a449_4        315.7 KiB   conda  https://conda.anaconda.org/conda-forge/
brotlicffi                 1.1.0.0                py311h3e6a449_3        329 KiB     conda  https://conda.anaconda.org/conda-forge/
bw2calc                    1.8.2                  py311h1ea47a8_0        67.8 KiB    conda  https://conda.anaconda.org/conda-forge/
bw2data                    3.6.6                  pyhd8ed1ab_0           61.2 KiB    conda  https://conda.anaconda.org/conda-forge/
bw2io                      0.8.12                 pyhd8ed1ab_0           17.7 MiB    conda  https://conda.anaconda.org/conda-forge/
bw2parameters              1.1.0                  pyhd8ed1ab_1           19.2 KiB    conda  https://conda.anaconda.org/conda-forge/
bw_migrations              0.2                    pyhd8ed1ab_1           14.5 KiB    conda  https://conda.anaconda.org/conda-forge/
bzip2                      1.0.8                  h0ad9c76_8             54.7 KiB    conda  https://conda.anaconda.org/conda-forge/
ca-certificates            2025.10.5              h4c7d964_0             152.7 KiB   conda  https://conda.anaconda.org/conda-forge/
cached_property            2.0.1                                         16.6 KiB    pypi   cached_property-2.0.1-py3-none-any.whl
certifi                    2025.10.5              pyhd8ed1ab_0           156.5 KiB   conda  https://conda.anaconda.org/conda-forge/
cffi                       2.0.0                  py311h3485c13_1        291 KiB     conda  https://conda.anaconda.org/conda-forge/
chardet                    5.2.0                                         1.1 MiB     pypi   chardet-5.2.0-py3-none-any.whl
charset-normalizer         3.4.4                  pyhd8ed1ab_0           49.8 KiB    conda  https://conda.anaconda.org/conda-forge/
click                      8.3.1                                         380.3 KiB   pypi   click-8.3.1-py3-none-any.whl
colorama                   0.4.6                  pyhd8ed1ab_1           26.4 KiB    conda  https://conda.anaconda.org/conda-forge/
constructive_geometries    1.0                                           24.8 MiB    pypi   constructive_geometries-1.0-py3-none-any.whl
country_converter          1.3.2                                         151.8 KiB   pypi   country_converter-1.3.2-py3-none-any.whl
cryptography               46.0.3                                        9.3 MiB     pypi   cryptography-46.0.3-cp311-abi3-win_amd64.whl
dataflows_tabulator        1.54.3                                        205.9 KiB   pypi   dataflows_tabulator-1.54.3-py2.py3-none-any.whl
datapackage                1.15.4                                        566.3 KiB   pypi   datapackage-1.15.4-py2.py3-none-any.whl
docopt                     0.6.2                  pyhd8ed1ab_2           18.4 KiB    conda  https://conda.anaconda.org/conda-forge/
ecoinvent_interface        3.1                    pyhd8ed1ab_1           36.6 MiB    conda  https://conda.anaconda.org/conda-forge/
eight                      1.0.1                  pyhd8ed1ab_5           15.7 KiB    conda  https://conda.anaconda.org/conda-forge/
et_xmlfile                 2.0.0                  pyhd8ed1ab_1           21.4 KiB    conda  https://conda.anaconda.org/conda-forge/
fasteners                  0.19                   pyhd8ed1ab_1           20.2 KiB    conda  https://conda.anaconda.org/conda-forge/
flexcache                  0.3                    pyhd8ed1ab_1           16.3 KiB    conda  https://conda.anaconda.org/conda-forge/
flexparser                 0.4                    pyhd8ed1ab_1           28 KiB      conda  https://conda.anaconda.org/conda-forge/
future                     1.0.0                  pyhd8ed1ab_2           356 KiB     conda  https://conda.anaconda.org/conda-forge/
greenlet                   3.2.4                                         738.7 KiB   pypi   greenlet-3.2.4-cp311-cp311-win_amd64.whl
h2                         4.3.0                  pyhcf101f3_0           93.7 KiB    conda  https://conda.anaconda.org/conda-forge/
hpack                      4.1.0                  pyhd8ed1ab_0           30 KiB      conda  https://conda.anaconda.org/conda-forge/
hyperframe                 6.1.0                  pyhd8ed1ab_0           17 KiB      conda  https://conda.anaconda.org/conda-forge/
idna                       3.11                   pyhd8ed1ab_0           49.5 KiB    conda  https://conda.anaconda.org/conda-forge/
ijson                      3.4.0.post0                                   143.7 KiB   pypi   ijson-3.4.0.post0-cp311-cp311-win_amd64.whl
importlib-metadata         8.7.0                  pyhe01879c_1           33.8 KiB    conda  https://conda.anaconda.org/conda-forge/
importlib_metadata         8.7.0                  h40b2b14_1             21.6 KiB    conda  https://conda.anaconda.org/conda-forge/
inflate64                  1.0.3                  py311he736701_0        39.7 KiB    conda  https://conda.anaconda.org/conda-forge/
isodate                    0.7.2                                         61.7 KiB    pypi   isodate-0.7.2-py3-none-any.whl
jmespath                   1.0.1                                         68 KiB      pypi   jmespath-1.0.1-py3-none-any.whl
jsonlines                  4.0.0                                         23.4 KiB    pypi   jsonlines-4.0.0-py3-none-any.whl
jsonpointer                3.0.0                                         16.5 KiB    pypi   jsonpointer-3.0.0-py2.py3-none-any.whl
jsonschema                 4.25.1                                        464.1 KiB   pypi   jsonschema-4.25.1-py3-none-any.whl
jsonschema_specifications  2025.9.1                                      46.2 KiB    pypi   jsonschema_specifications-2025.9.1-py3-none-any.whl
lci_extractor              0.1.0                                                     pypi    (editable)
libblas                    3.9.0                  38_hf2e6a31_mkl        65.1 KiB    conda  https://conda.anaconda.org/conda-forge/
libcblas                   3.9.0                  38_h2a3cdd5_mkl        65.5 KiB    conda  https://conda.anaconda.org/conda-forge/
libexpat                   2.7.1                  hac47afa_0             138 KiB     conda  https://conda.anaconda.org/conda-forge/
libffi                     3.5.2                  h52bdfb6_0             43.8 KiB    conda  https://conda.anaconda.org/conda-forge/
libhwloc                   2.12.1                 default_h88281d1_1000  2.3 MiB     conda  https://conda.anaconda.org/conda-forge/
libiconv                   1.18                   hc1393d2_2             680.6 KiB   conda  https://conda.anaconda.org/conda-forge/
liblapack                  3.9.0                  38_hf9ab0e9_mkl        77.4 KiB    conda  https://conda.anaconda.org/conda-forge/
liblzma                    5.8.1                  h2466b09_2             102.5 KiB   conda  https://conda.anaconda.org/conda-forge/
libsqlite                  3.50.4                 hf5d6505_0             1.2 MiB     conda  https://conda.anaconda.org/conda-forge/
libwinpthread              12.0.0.r4.gg4f2fc60ca  h57928b3_10            35.8 KiB    conda  https://conda.anaconda.org/conda-forge/
libxml2                    2.13.8                 h741aa76_1             1.4 MiB     conda  https://conda.anaconda.org/conda-forge/
libxslt                    1.1.43                 h25c3957_0             407.2 KiB   conda  https://conda.anaconda.org/conda-forge/
libzlib                    1.3.1                  h2466b09_2             54.2 KiB    conda  https://conda.anaconda.org/conda-forge/
linear_tsv                 1.1.0                                         17.8 KiB    pypi   linear_tsv-1.1.0-py3-none-any.whl
llvm-openmp                21.1.4                 hfa2b4ca_0             339.1 KiB   conda  https://conda.anaconda.org/conda-forge/
llvmlite                   0.45.1                                        102.8 MiB   pypi   llvmlite-0.45.1-cp311-cp311-win_amd64.whl
lxml                       4.9.3                  py311h750ae06_3        1007.3 KiB  conda  https://conda.anaconda.org/conda-forge/
lxmlh                      1.3.3                  pyhd8ed1ab_1           12.2 KiB    conda  https://conda.anaconda.org/conda-forge/
mkl                        2025.3.0               hac47afa_454           95.3 MiB    conda  https://conda.anaconda.org/conda-forge/
mrio_common_metadata       0.2.1                  pyhd8ed1ab_1           17.4 KiB    conda  https://conda.anaconda.org/conda-forge/
multivolumefile            0.2.3                  pyhd8ed1ab_1           20.9 KiB    conda  https://conda.anaconda.org/conda-forge/
numba                      0.62.1                                        11.4 MiB    pypi   numba-0.62.1-cp311-cp311-win_amd64.whl
numpy                      1.26.4                 py311h0b4df5a_0        6.8 MiB     conda  https://conda.anaconda.org/conda-forge/
openpyxl                   3.1.5                  py311h4d8bf61_2        616.7 KiB   conda  https://conda.anaconda.org/conda-forge/
openssl                    3.5.4                  h725018a_0             8.8 MiB     conda  https://conda.anaconda.org/conda-forge/
packaging                  25.0                   pyh29332c3_1           61 KiB      conda  https://conda.anaconda.org/conda-forge/
pandas                     2.3.3                  py311h11fd7f3_1        13.7 MiB    conda  https://conda.anaconda.org/conda-forge/
peewee                     3.18.2                 py311h9c13b91_1        394.8 KiB   conda  https://conda.anaconda.org/conda-forge/
pint                       0.25                   pyhe01879c_0           237.4 KiB   conda  https://conda.anaconda.org/conda-forge/
pip                        25.2                   pyh8b19718_0           1.1 MiB     conda  https://conda.anaconda.org/conda-forge/
platformdirs               4.5.0                  pyhcf101f3_0           23.1 KiB    conda  https://conda.anaconda.org/conda-forge/
premise                    2.3.2                                         31.3 MiB    pypi   premise-2.3.2-py3-none-any.whl
premise_gwp                0.9.8                                         121.2 KiB   pypi   premise_gwp-0.9.8-py3-none-any.whl
prettytable                3.17.0                                        152.1 KiB   pypi   prettytable-3.17.0-py3-none-any.whl
psutil                     7.1.2                  py311hf893f09_0        518.8 KiB   conda  https://conda.anaconda.org/conda-forge/
py7zr                      1.0.0                  pyhd8ed1ab_0           60.5 KiB    conda  https://conda.anaconda.org/conda-forge/
pyarrow                    22.0.0                                        82.4 MiB    pypi   pyarrow-22.0.0-cp311-cp311-win_amd64.whl
pybcj                      1.0.6                  py311h3485c13_1        35.5 KiB    conda  https://conda.anaconda.org/conda-forge/
pycasreg                   0.1.0                  pyhd8ed1ab_1           10.3 KiB    conda  https://conda.anaconda.org/conda-forge/
pycountry                  24.6.1                                        15.8 MiB    pypi   pycountry-24.6.1-py3-none-any.whl
pycparser                  2.22                   pyh29332c3_1           107.5 KiB   conda  https://conda.anaconda.org/conda-forge/
pycryptodomex              3.23.0                 py311h3485c13_1        1.7 MiB     conda  https://conda.anaconda.org/conda-forge/
pydantic                   2.12.3                 pyh3cfb1c2_0           312.5 KiB   conda  https://conda.anaconda.org/conda-forge/
pydantic-core              2.41.4                 py311hf51aa87_0        1.9 MiB     conda  https://conda.anaconda.org/conda-forge/
pydantic-settings          2.11.0                 pyh3cfb1c2_0           40.4 KiB    conda  https://conda.anaconda.org/conda-forge/
pyecospold                 3.5.3                  pyhd8ed1ab_0           68.2 KiB    conda  https://conda.anaconda.org/conda-forge/
pypardiso                  0.4.6                  pyhd8ed1ab_0           14.8 KiB    conda  https://conda.anaconda.org/conda-forge/
pyppmd                     1.1.0                  py311hda3d55a_1        61.5 KiB    conda  https://conda.anaconda.org/conda-forge/
pyprind                    2.11.2                 py311h1ea47a8_1007     19.3 KiB    conda  https://conda.anaconda.org/conda-forge/
pysocks                    1.7.1                  pyh09c184e_7           21.3 KiB    conda  https://conda.anaconda.org/conda-forge/
python                     3.11.14                h0159041_2_cpython     17.7 MiB    conda  https://conda.anaconda.org/conda-forge/
python-dateutil            2.9.0.post0            pyhe01879c_2           227.8 KiB   conda  https://conda.anaconda.org/conda-forge/
python-dotenv              1.2.1                  pyhcf101f3_0           26.3 KiB    conda  https://conda.anaconda.org/conda-forge/
python-tzdata              2025.2                 pyhd8ed1ab_0           140.8 KiB   conda  https://conda.anaconda.org/conda-forge/
python_abi                 3.11                   8_cp311                6.8 KiB     conda  https://conda.anaconda.org/conda-forge/
python_json_logger         4.0.0                                         40 KiB      pypi   python_json_logger-4.0.0-py3-none-any.whl
pytz                       2025.2                 pyhd8ed1ab_0           184.6 KiB   conda  https://conda.anaconda.org/conda-forge/
pyxlsb                     1.0.10                 pyhd8ed1ab_0           27.6 KiB    conda  https://conda.anaconda.org/conda-forge/
pyyaml                     6.0.3                                         471.6 KiB   pypi   pyyaml-6.0.3-cp311-cp311-win_amd64.whl
pyzstd                     0.18.0                 py311h2d646e2_0        103.4 KiB   conda  https://conda.anaconda.org/conda-forge/
referencing                0.37.0                                        112.7 KiB   pypi   referencing-0.37.0-py3-none-any.whl
requests                   2.32.5                 pyhd8ed1ab_0           57.9 KiB    conda  https://conda.anaconda.org/conda-forge/
rfc3986                    2.0.0                                         100.3 KiB   pypi   rfc3986-2.0.0-py2.py3-none-any.whl
rpds_py                    0.29.0                                        607.6 KiB   pypi   rpds_py-0.29.0-cp311-cp311-win_amd64.whl
s3transfer                 0.14.0                                        310.6 KiB   pypi   s3transfer-0.14.0-py3-none-any.whl
schema                     0.7.8                                         70.8 KiB    pypi   schema-0.7.8-py2.py3-none-any.whl
scipy                      1.13.1                 py311hd4686c6_0        14.8 MiB    conda  https://conda.anaconda.org/conda-forge/
setuptools                 80.9.0                 pyhff2d567_0           731.2 KiB   conda  https://conda.anaconda.org/conda-forge/
setuptools-scm             9.2.2                  pyhd8ed1ab_0           51.3 KiB    conda  https://conda.anaconda.org/conda-forge/
six                        1.17.0                 pyhe01879c_1           18 KiB      conda  https://conda.anaconda.org/conda-forge/
sparse                     0.17.0                                        1 MiB       pypi   sparse-0.17.0-py2.py3-none-any.whl
sqlalchemy                 2.0.44                                        8.4 MiB     pypi   sqlalchemy-2.0.44-cp311-cp311-win_amd64.whl
stats_arrays               1.0                    pyhd8ed1ab_0           26.4 KiB    conda  https://conda.anaconda.org/conda-forge/
structlog                  25.5.0                                        231.3 KiB   pypi   structlog-25.5.0-py3-none-any.whl
tableschema                1.21.0                                        230.3 KiB   pypi   tableschema-1.21.0-py2.py3-none-any.whl
tbb                        2022.2.0               h18a62a1_1             151.8 KiB   conda  https://conda.anaconda.org/conda-forge/
texttable                  1.7.0                  pyhd8ed1ab_1           19.5 KiB    conda  https://conda.anaconda.org/conda-forge/
tk                         8.6.13                 h2c6b04d_2             3.3 MiB     conda  https://conda.anaconda.org/conda-forge/
tomli                      2.3.0                  pyhcf101f3_0           20.5 KiB    conda  https://conda.anaconda.org/conda-forge/
toolz                      1.1.0                                         195.4 KiB   pypi   toolz-1.1.0-py3-none-any.whl
tqdm                       4.67.1                 pyhd8ed1ab_1           87.4 KiB    conda  https://conda.anaconda.org/conda-forge/
typing-extensions          4.15.0                 h396c80c_0             89.2 KiB    conda  https://conda.anaconda.org/conda-forge/
typing-inspection          0.4.2                  pyhd8ed1ab_0           18.4 KiB    conda  https://conda.anaconda.org/conda-forge/
typing_extensions          4.15.0                 pyhcf101f3_0           50.5 KiB    conda  https://conda.anaconda.org/conda-forge/
tzdata                     2025b                  h78e105d_0             120.1 KiB   conda  https://conda.anaconda.org/conda-forge/
ucrt                       10.0.26100.0           h57928b3_0             678.4 KiB   conda  https://conda.anaconda.org/conda-forge/
unfold                     1.2.4                                         575.5 KiB   pypi   unfold-1.2.4-py3-none-any.whl
unicodecsv                 0.14.1                 pyhd8ed1ab_3           16.4 KiB    conda  https://conda.anaconda.org/conda-forge/
unidecode                  1.3.8                  pyh29332c3_1           185.4 KiB   conda  https://conda.anaconda.org/conda-forge/
urllib3                    2.5.0                  pyhd8ed1ab_0           99.4 KiB    conda  https://conda.anaconda.org/conda-forge/
vc                         14.3                   h2b53caa_32            18.4 KiB    conda  https://conda.anaconda.org/conda-forge/
vc14_runtime               14.44.35208            h818238b_32            666.7 KiB   conda  https://conda.anaconda.org/conda-forge/
vcomp14                    14.44.35208            h818238b_32            112.2 KiB   conda  https://conda.anaconda.org/conda-forge/
voluptuous                 0.15.2                 pyhd8ed1ab_2           32.7 KiB    conda  https://conda.anaconda.org/conda-forge/
wcwidth                    0.2.14                                        559.2 KiB   pypi   wcwidth-0.2.14-py2.py3-none-any.whl
wheel                      0.45.1                 pyhd8ed1ab_1           61.5 KiB    conda  https://conda.anaconda.org/conda-forge/
whoosh                     2.7.4                  py311h1ea47a8_10       815.4 KiB   conda  https://conda.anaconda.org/conda-forge/
win_inet_pton              1.1.0                  pyh7428d3b_8           9.3 KiB     conda  https://conda.anaconda.org/conda-forge/
wrapt                      2.0.0                  py311h3485c13_0        83.7 KiB    conda  https://conda.anaconda.org/conda-forge/
wurst                      0.5.3                                         86.4 KiB    pypi   wurst-0.5.3-py3-none-any.whl
xarray                     2024.2.0                                      5.2 MiB     pypi   xarray-2024.2.0-py3-none-any.whl
xlrd                       2.0.2                  pyhd8ed1ab_0           91.5 KiB    conda  https://conda.anaconda.org/conda-forge/
xlsxwriter                 3.2.9                  pyhd8ed1ab_0           130.7 KiB   conda  https://conda.anaconda.org/conda-forge/
zipfile-deflate64          0.2.0                  py311ha68e1ae_4        26.7 KiB    conda  https://conda.anaconda.org/conda-forge/
zipp                       3.23.0                 pyhd8ed1ab_0           22.4 KiB    conda  https://conda.anaconda.org/conda-forge/
zstandard                  0.25.0                 py311hf893f09_0        367.1 KiB   conda  https://conda.anaconda.org/conda-forge/
zstd                       1.5.7                  hbeecb71_2             346.4 KiB   conda  https://conda.anaconda.org/conda-forge/

[romainsacchi]

OK, I still don't see why. Anyway, this is nice. It seems this is caused by passing pd.NA to openpyxl. I replaced that part and am doing a run. If successful, I'll commit and push, and you can try again. Hopefully this removes the kernel crash issue entirely.

[romainsacchi]

@CHarpprecht ok, you could try again with this new commit, see if that fixes it.

[CHarpprecht]

@romainsacchi , thank you very much, the current premise version from github resolves the issue. Reports are generated and the code runs without an exit.
Just one last syntax comment, the filepath printed to:
Report saved under D:\PycharmProjects\lci-extractor/export/change reports/.
is not working (but the report is in the folder :) ).
D:\PycharmProjects\lci-extractor\export\scenario_report. works

Created database: ei_cutoff_3.10_image_SSP2-M_2025_update-all_pv234_unfold124_bw2io0812
Generate scenario report.
Report saved under D:\PycharmProjects\lci-extractor\export\scenario_report.
Generate change report.
Report saved under D:\PycharmProjects\lci-extractor/export/change reports/.