# CadetProcess.optimization issue

**URL:** <https://forum.cadet-web.de/t/cadetprocess-optimization-issue/1166>\
**Category:** CADET Troubleshooting\
**Created:** [February 19, 2025, 12:23pm UTC](https://forum.cadet-web.de/t/cadetprocess-optimization-issue/1166 "2025-02-19T12:23:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![avasyanin](https://forum.cadet-web.de/letter_avatar_proxy/v4/letter/a/7c8e57/32.png) [@avasyanin](https://forum.cadet-web.de/u/avasyanin)\
**Post date:** [February 19, 2025, 12:23pm UTC](https://forum.cadet-web.de/t/cadetprocess-optimization-issue/1166/1 "2025-02-19T12:23:45Z")

</div>

### Expected behavior.

Looks like something went wrong after the last updates of the Cadet-Process dependencies. I used this fragment of code for a while for some optimization:

```auto
from CADETProcess.optimization import U_NSGA3, NelderMead
#optimizer = U_NSGA3()
optimizer = NelderMead()
optimizer.n_cores = 4

results = optimizer.optimize(
    optimization_problem,
    use_checkpoint=False,
    #x0 = x0
)

```

### Actual behavior

Now it stops with the following message:

```auto
---------------------------------------------------------------------------
OperationalError Traceback (most recent call last)
Cell In[3], line 58
     55 optimizer = NelderMead()
     56 optimizer.n_cores = 4
---> 58 results = optimizer.optimize(
     59 optimization_problem,
     60 use_checkpoint=False,
     61 #x0 = [*column.binding_model.adsorption_rate, *column.binding_model.desorption_rate, *column.binding_model.capacity, *keq, *kkin]
     62 x0 = x0
     63 )
     64 #langm3_LDF[F] = results

File ~/miniforge3/envs/cadet/lib/python3.12/site-packages/CADETProcess/optimization/optimizer.py:273, in OptimizerBase.optimize(self, optimization_problem, x0, save_results, results_directory, use_checkpoint, overwrite_results_directory, exist_ok, log_level, reinit_cache, delete_cache, *args, **kwargs)
    270 plt.switch_backend('agg')
    272 start = time.time()
--> 273 self.run(self.optimization_problem, x0, *args, **kwargs)
    274 time_elapsed = time.time() - start
    276 self.results.time_elapsed = time_elapsed

File ~/miniforge3/envs/cadet/lib/python3.12/site-packages/CADETProcess/optimization/scipyAdapter.py:134, in SciPyInterface.run(self, optimization_problem, x0)
    132 warnings.filterwarnings('ignore', category=OptimizeWarning)
    133 warnings.filterwarnings('ignore', category=RuntimeWarning)
--> 134 scipy_results = optimize.minimize(
    135 objective_function,
...
    873 value,
    874 ),
    875 )

OperationalError: no such column: "size" - should this be a string literal in single-quotes?

```

### How to produce bug (including a minimal reproducible example)

I used a macOS miniforge python distribution, freshly created conda environment, populated only with the minimum packages required (see the attachment) with cadet-cli v 5.0.3 self-compiled.

Minimal reproducible example (from [https://cadet-process.readthedocs.io/en/stable/user\_guide/optimization/optimizer.html](https://cadet-process.readthedocs.io/en/stable/user_guide/optimization/optimizer.html)):

```auto
from CADETProcess.optimization import OptimizationProblem

def multi_objective_func(x):
    f1 = x[0]**2 + x[1]**2
    f2 = (x[0] - 1)**2 + x[1]**2
    return f1, f2

optimization_problem = OptimizationProblem('moo')

optimization_problem.add_variable('x_0', lb=-5, ub=5)
optimization_problem.add_variable('x_1', lb=-5, ub=5)

optimization_problem.add_objective(multi_objective_func, n_objectives=2)
optimizer.n_cores = 4
optimization_results = optimizer.optimize(optimization_problem, save_results=False)

```

### File produced by `conda env export > environment.yml`

[environment.yml](https://forum.cadet-web.de/uploads/short-url/zVg0PIo2ogMuAPZWTjjfmZ7Gtws.yml) (6.56 KB)

---

<div class="post-metadata">

**Author:** ![ronald.jaepel](https://forum.cadet-web.de/user_avatar/forum.cadet-web.de/ronald.jaepel/32/986_2.png) [@ronald.jaepel](https://forum.cadet-web.de/u/ronald.jaepel)\
**Post date:** [February 19, 2025, 12:36pm UTC](https://forum.cadet-web.de/t/cadetprocess-optimization-issue/1166/3 "2025-02-19T12:36:49Z")

</div>

Hello and welcome to the Forum!

Thank you for the detailed error report.

It’s a problem with the version 3.49.1 of `libsqlite` which released yesterday. For now, you can fix this by running `conda install -y libsqlite==3.48.0` and we will let you know when we find a better fix.

If that doesn’t work, please let me know!

---

<div class="post-metadata">

**Author:** ![h.lanzrath](https://forum.cadet-web.de/user_avatar/forum.cadet-web.de/h.lanzrath/32/1186_2.png) [@h.lanzrath](https://forum.cadet-web.de/u/h.lanzrath)\
**Post date:** [January 27, 2026, 11:41am UTC](https://forum.cadet-web.de/t/cadetprocess-optimization-issue/1166/4 "2026-01-27T11:41:41Z")

</div>