INVEST 3.6.1 OperationalError: table taskgraph_data has 3 columns but 2 values were supplied

What is the issue or question you have?

What do you expect to happen?

What have you tried so far?

Attach the logfile here:

2023-01-23 15:30:07,390 utils.prepare_workspace(109) INFO Writing log messages to C:\Users\pc\Desktop\Land Use Planning\Draft_SEA_ Report\Analysis-fin\Nutrient Modeling\InVEST-Nutrient-Delivery-Ratio-Model-(NDR)-log-2023-01-23–15_30_07.txt
2023-01-23 15:30:07,405 model.logged_target(1634) Level 100 Starting model with parameters:
Arguments for InVEST natcap.invest.ndr.ndr 3.6.0.post525+h31b10cfee0d4:
biophysical_table_path C:/Users/pc/Desktop/Land Use Planning/Draft_SEA
Report/Analysis-fin/Nutrient Modeling/Biophysical Table for N_f.csv
calc_n True
calc_p False
dem_path C:/Users/pc/Desktop/Land Use Planning/Draft_SEA_ Report/Analysis-fin/Nutrient Modeling/dem_SWA.tif
k_param 2
lulc_path C:/Users/pc/Desktop/Land Use Planning/Draft_SEA_ Report/Analysis-fin/Nutrient Modeling/LC.tif
n_workers -1
results_suffix
runoff_proxy_path C:/Users/pc/Desktop/Land Use Planning/Draft_SEA_ Report/Analysis-fin/Nutrient Modeling/precipitation.tif
subsurface_critical_length_n 2000
subsurface_critical_length_p 200
subsurface_eff_n 0.8
subsurface_eff_p 0.8
threshold_flow_accumulation 1,000
watersheds_path C:/Users/pc/Desktop/Land Use Planning/Draft_SEA_ Report/Analysis-fin/Nutrient Modeling/Sub-waterS_f.shp
workspace_dir C:\Users\pc\Desktop\Land Use Planning\Draft_SEA_ Report\Analysis-fin\Nutrient Modeling

2023-01-23 15:30:07,624 Task.add_task(636) ERROR Something went wrong when adding task create target vector (0), terminating taskgraph.
Traceback (most recent call last):
File “Z:\opt\atlassian\pipelines\agent\build\env\lib\site-packages\taskgraph\Task.py”, line 602, in add_task
File “Z:\opt\atlassian\pipelines\agent\build\env\lib\site-packages\taskgraph\Task.py”, line 1096, in _call
OperationalError: table taskgraph_data has 3 columns but 2 values were supplied
2023-01-23 15:30:07,624 model._logged_target(1640) ERROR Exception while executing <function execute at 0x11404770>
Traceback (most recent call last):
File “Z:\opt\atlassian\pipelines\agent\build\env\lib\site-packages\natcap\invest\ui\model.py”, line 1637, in _logged_target
File “Z:\opt\atlassian\pipelines\agent\build\env\lib\site-packages\natcap\invest\ndr\ndr.py”, line 218, in execute
File “Z:\opt\atlassian\pipelines\agent\build\env\lib\site-packages\taskgraph\Task.py”, line 602, in add_task
File “Z:\opt\atlassian\pipelines\agent\build\env\lib\site-packages\taskgraph\Task.py”, line 1096, in _call
OperationalError: table taskgraph_data has 3 columns but 2 values were supplied
2023-01-23 15:30:07,640 model._logged_target(1643) INFO Execution finished
2023-01-23 15:30:07,640 utils.prepare_workspace(115) INFO Elapsed time: 0.25s

Hi @Yirga,
InVEST 3.6.1 is a really old version, and there’s a good chance that this issue has been fixed in a more recent release. Please try the latest version, 3.12.1. You can download the latest version here: InVEST | Natural Capital Project

Thank you in advance!
You are quite right. NDR modeling successfully completed using latest version 3.12.1
Kind-regards
Yirga