search

observatoire-mobilite / odmkraken

The **kraken** is the orchestration layer responsible for gathering and postprocessing ODM's mobility data
MIT License
0 stars 0 forks source link

Mapmatching fails with a SQL error #38

Closed gilgeorges closed 1 year ago

gilgeorges commented 1 year ago

Error message:

psycopg2.errors.UndefinedFunction: function vehdata.get_edgelist() does not exist
LINE 1: SELECT * FROM vehdata.get_edgelist()
                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Stack Trace:
  File "/opt/conda/lib/python3.10/site-packages/dagster/_core/errors.py", line 184, in user_code_error_boundary
    yield
  File "/opt/conda/lib/python3.10/site-packages/dagster/_core/execution/resources_init.py", line 325, in single_resource_event_generator
    resource_def.resource_fn(context)
  File "/app/odmkraken/resources/edmo/busdata/__init__.py", line 117, in shortest_path_engine
    with context.resources.edmo_vehdata.get_edgelist() as cur:
  File "/opt/conda/lib/python3.10/contextlib.py", line 135, in __enter__
    return next(self.gen)
  File "/app/odmkraken/resources/postgres.py", line 55, in callproc
    cur.callproc(proc, args)
gilgeorges commented 1 year ago

Diagnosis

This is rather straight forward: get_edgelistexists but it lives in the network schema. Should be simple enough to fix.