Problems encountered when invoking the water generation module api natcap.invest.annual_water_yield.execute interface

Software Support
,
1

When I run the program natcap.invest.annual_water_yield.execute, The TaskGraph database is locked because another process is using it, waiting for a bit of time to try again message is always displayed. The error message is "OperationalError: no such column: “version” - should this be a string literal in single-quotes? ". I can make sure that there is no cache directory in my working environment and that each module is version compliant. Could you help me figure out what’s wrong? Thank you.

2

Hi @Kevin1, sorry you are having trouble running InVEST! This error seems to be related to an issue in the latest release of sqlite (3.49.1).

Can you please try the following:

  1. Delete the taskgraph_cache directory from the workspace.
  2. In the conda environment you are using to run InVEST, downgrade sqlite to 3.48.0.
  3. Try running the model again.

That should resolve your issue; if not, please let us know!

1 Like