budgetkey/analysis/spending/publisher_entity_analysis
Succeeded

Last Run triggered by:
scheduled
Last Run started at:
2026-05-09 10:27:23.028891
Last Completion:
2026-05-09 12:01:51.933361
Last Success:
2026-05-09 12:01:51.933361

Pipeline ID: budgetkey/analysis/spending/publisher_entity_analysis

budgetkey/analysis/spending/publisher_foa_analysis
Succeeded

Last Run triggered by:
scheduled
Last Run started at:
2026-05-09 10:27:23.038835
Last Completion:
2026-05-09 10:36:25.429917
Last Success:
2026-05-09 10:36:25.429917

Pipeline ID: budgetkey/analysis/spending/publisher_foa_analysis

budgetkey/analysis/spending/united
Running

Last Run triggered by:
scheduled
Last Run started at:
2026-05-10 10:44:25.254875
Last Completion:
Last Success:
2026-05-09 10:27:22.767274

Pipeline ID: budgetkey/analysis/spending/united

Main Page - Aggregated budget by functional classification (budget-functional-aggregates)
Invalid

Last Run triggered by:
scheduled
Last Run started at:
2026-05-09 06:44:48.137001
Last Completion:
2026-05-09 06:59:26.936508
Last Success:
2026-05-09 06:59:26.936508

Dependency unsuccessful :Cannot run until dependency "./budget/national/processed/aggregated-yearly" is successfully executed

Pipeline ID: budgetkey/budget-functional-aggregates

budgetkey/documents
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 08:43:25.763915
Last Completion:
2026-05-10 08:43:33.345432
Last Success:
2026-05-10 08:43:33.345432

Pipeline ID: budgetkey/documents

budgetkey/elasticsearch/index_activities
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 10:17:01.257931
Last Completion:
2026-05-10 10:18:09.756515
Last Success:
2026-05-10 10:18:09.756515

Pipeline ID: budgetkey/elasticsearch/index_activities

budgetkey/elasticsearch/index_budget
Failed

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 09:09:27.564283
Last Completion:
2026-05-10 09:10:19.457160
Last Success:
None

dump.to_sql
ERROR   :Traceback (most recent call last):
ERROR   :File "/usr/local/lib/python3.9/site-packages/datapackage_pipelines/specs/../lib/dump/to_sql.py", line 15, in <module>
ERROR   :spew_flow(flow(ctx.parameters), ctx)
ERROR   :File "/usr/local/lib/python3.9/site-packages/datapackage_pipelines/wrapper/wrapper.py", line 181, in __exit__
ERROR   :spew(self.datapackage, self.resource_iterator, stats=self.stats)
ERROR   :File "/usr/local/lib/python3.9/site-packages/datapackage_pipelines/wrapper/wrapper.py", line 75, in spew
ERROR   :for rec in res:
ERROR   :File "/usr/local/lib/python3.9/site-packages/dataflows/processors/dumpers/dumper_base.py", line 69, in row_counter
ERROR   :for row in iterator:
ERROR   :File "/usr/local/lib/python3.9/site-packages/tableschema_sql/writer.py", line 49, in write
ERROR   :ret = self.__update(connection, keyed_row)
ERROR   :File "/usr/local/lib/python3.9/site-packages/tableschema_sql/writer.py", line 100, in __update
ERROR   :res = connection.execute(expr)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1412, in execute
ERROR   :return meth(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 483, in _execute_on_connection
ERROR   :return connection._execute_clauseelement(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1627, in _execute_clauseelement
ERROR   :compiled_sql, extracted_params, cache_hit = elem._compile_w_cache(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 671, in _compile_w_cache
ERROR   :compiled_sql = self._compiler(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 288, in _compiler
ERROR   :return dialect.statement_compiler(dialect, self, **kw)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/compiler.py", line 1425, in __init__
ERROR   :Compiled.__init__(self, dialect, statement, **kwargs)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/compiler.py", line 866, in __init__
ERROR   :self.string = self.process(self.statement, **compile_kwargs)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/compiler.py", line 911, in process
ERROR   :return obj._compiler_dispatch(self, **kwargs)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/visitors.py", line 143, in _compiler_dispatch
ERROR   :return meth(self, **kw)  # type: ignore  # noqa: E501
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/compiler.py", line 6040, in visit_update
ERROR   :crud_params_struct = crud._get_crud_params(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/crud.py", line 335, in _get_crud_params
ERROR   :raise exc.CompileError(
ERROR   :sqlalchemy.exc
ERROR   :.
ERROR   :CompileError
ERROR   ::
ERROR   :Unconsumed column names: code_level6, title_level4, title_level8, code_level8, code_level4, code_level2, title_level6, title_level2

Pipeline ID: budgetkey/elasticsearch/index_budget

budgetkey/elasticsearch/index_calls_for_bids
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./procurement/calls_for_bids/calls-for-bids-all
From ./procurement/calls_for_bids/calls-for-bids-all :['Dependency unsuccessful', 'Cannot run until dependency "./procurement/calls_for_bids/gov-publications" is successfully executed']
From ./procurement/calls_for_bids/calls-for-bids-all :['Dependency unsuccessful', 'Cannot run until dependency "./procurement/calls_for_bids/gov-publications2" is successfully executed']
From ./procurement/calls_for_bids/calls-for-bids-all :['Dependency unsuccessful', 'Cannot run until dependency "./procurement/calls_for_bids/gov-publications-ministry-of-immigration" is successfully executed']

Pipeline ID: budgetkey/elasticsearch/index_calls_for_bids

budgetkey/elasticsearch/index_contract_spending
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending
From ./procurement/spending/latest-contract-spending :['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']
From ./procurement/spending/latest-contract-spending :['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]
From ./procurement/spending/latest-contract-spending :['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]

Pipeline ID: budgetkey/elasticsearch/index_contract_spending

budgetkey/elasticsearch/index_entities
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./entities/entities
From ./entities/entities :['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/spending-by-entity']
From ./entities/entities :['From ./procurement/spending/spending-by-entity', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending']]
From ./entities/entities :['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']]]
From ./entities/entities :['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]]]
From ./entities/entities :['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]]]
From ./entities/entities :['Invalid dependency', 'Cannot run until dependency passes validation: ./entities/all']
From ./entities/entities :['From ./entities/all', ['Dependency unsuccessful', 'Cannot run until dependency "./entities/ottoman/ottoman-association-registry" is successfully executed']]

Pipeline ID: budgetkey/elasticsearch/index_entities

budgetkey/elasticsearch/index_gov_decisions
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./government_decisions/government_decisions
From ./government_decisions/government_decisions :['Dependency unsuccessful', 'Cannot run until dependency "./government_decisions/scraper" is successfully executed']

Pipeline ID: budgetkey/elasticsearch/index_gov_decisions

budgetkey/elasticsearch/index_muni_budgets
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 08:44:19.755391
Last Completion:
2026-05-10 08:58:44.595445
Last Success:
2026-05-10 08:58:44.595445

Pipeline ID: budgetkey/elasticsearch/index_muni_budgets

budgetkey/elasticsearch/index_muni_tenders
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 10:18:09.766598
Last Completion:
2026-05-10 10:19:06.547545
Last Success:
2026-05-10 10:19:06.547545

Pipeline ID: budgetkey/elasticsearch/index_muni_tenders

budgetkey/elasticsearch/index_national_budget_changes
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./budget/national/changes/processed/national-budget-changes-aggregated
From ./budget/national/changes/processed/national-budget-changes-aggregated :['Dependency unsuccessful', 'Cannot run until dependency "./budget/national/changes/explanations/all" is successfully executed']
From ./budget/national/changes/processed/national-budget-changes-aggregated :['Dependency unsuccessful', 'Cannot run until dependency "./budget/national/changes/processed/transactions" is successfully executed']

Pipeline ID: budgetkey/elasticsearch/index_national_budget_changes

budgetkey/elasticsearch/index_people
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./people/aggregated
From ./people/aggregated :['Invalid dependency', 'Cannot run until dependency passes validation: ./people/all']
From ./people/aggregated :['From ./people/all', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/all-appointments']]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['Dependency unsuccessful', 'Cannot run until dependency "./people/company_appointments/media/themarker/themarker" is successfully executed']]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-nominations']]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-nominations', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-list']]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-nominations', ['From ./people/company_appointments/maya/maya-list', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-notification-updates']]]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-nominations', ['From ./people/company_appointments/maya/maya-list', ['From ./people/company_appointments/maya/maya-notification-updates', ['Dependency unsuccessful', 'Cannot run until dependency "./people/company_appointments/maya/maya-notification-list" is successfully executed']]]]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-resignations']]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-resignations', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-list']]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-resignations', ['From ./people/company_appointments/maya/maya-list', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-notification-updates']]]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-resignations', ['From ./people/company_appointments/maya/maya-list', ['From ./people/company_appointments/maya/maya-notification-updates', ['Dependency unsuccessful', 'Cannot run until dependency "./people/company_appointments/maya/maya-notification-list" is successfully executed']]]]]]
From ./people/aggregated :['From ./people/all', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/procurement/procurement-individuals']]
From ./people/aggregated :['From ./people/all', ['From ./people/procurement/procurement-individuals', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending']]]
From ./people/aggregated :['From ./people/all', ['From ./people/procurement/procurement-individuals', ['From ./procurement/spending/latest-contract-spending', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']]]]
From ./people/aggregated :['From ./people/all', ['From ./people/procurement/procurement-individuals', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]]]]
From ./people/aggregated :['From ./people/all', ['From ./people/procurement/procurement-individuals', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]]]]
From ./people/aggregated :['From ./people/all', ['Dependency unsuccessful', 'Cannot run until dependency "./people/political_candidates/election_candidates21" is successfully executed']]

Pipeline ID: budgetkey/elasticsearch/index_people

budgetkey/elasticsearch/index_reports
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 10:15:41.260780
Last Completion:
2026-05-10 10:17:01.244817
Last Success:
2026-05-10 10:17:01.244817

Pipeline ID: budgetkey/elasticsearch/index_reports

budgetkey/elasticsearch/index_support_criteria
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Dependency unsuccessful :Cannot run until dependency "./supports/criteria/support-criteria" is successfully executed

Pipeline ID: budgetkey/elasticsearch/index_support_criteria

budgetkey/elasticsearch/index_support_programs
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 09:19:47.049461
Last Completion:
2026-05-10 09:22:40.356488
Last Success:
2026-05-10 09:22:40.356488

Pipeline ID: budgetkey/elasticsearch/index_support_programs

budgetkey/elasticsearch/index_supports
Running

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 09:10:19.546925
Last Completion:
Last Success:
2026-05-10 03:34:17.578037

Pipeline ID: budgetkey/elasticsearch/index_supports

budgetkey/elasticsearch/index_tenders
Running

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 09:22:40.456061
Last Completion:
Last Success:
2026-05-10 02:34:39.485735

Pipeline ID: budgetkey/elasticsearch/index_tenders

budgetkey/elasticsearch/index_units
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 08:43:33.355195
Last Completion:
2026-05-10 08:44:19.745379
Last Success:
2026-05-10 08:44:19.745379

Pipeline ID: budgetkey/elasticsearch/index_units

budgetkey/elasticsearch/sitemaps
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Dependency unsuccessful :Cannot run until dependency "./budgetkey/elasticsearch/index_budget" is successfully executed
Invalid dependency :Cannot run until dependency passes validation: ./budgetkey/elasticsearch/index_national_budget_changes
From ./budgetkey/elasticsearch/index_national_budget_changes :['Invalid dependency', 'Cannot run until dependency passes validation: ./budget/national/changes/processed/national-budget-changes-aggregated']
From ./budgetkey/elasticsearch/index_national_budget_changes :['From ./budget/national/changes/processed/national-budget-changes-aggregated', ['Dependency unsuccessful', 'Cannot run until dependency "./budget/national/changes/explanations/all" is successfully executed']]
From ./budgetkey/elasticsearch/index_national_budget_changes :['From ./budget/national/changes/processed/national-budget-changes-aggregated', ['Dependency unsuccessful', 'Cannot run until dependency "./budget/national/changes/processed/transactions" is successfully executed']]
Invalid dependency :Cannot run until dependency passes validation: ./budgetkey/elasticsearch/index_entities
From ./budgetkey/elasticsearch/index_entities :['Invalid dependency', 'Cannot run until dependency passes validation: ./entities/entities']
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/spending-by-entity']]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./procurement/spending/spending-by-entity', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending']]]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']]]]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]]]]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]]]]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['Invalid dependency', 'Cannot run until dependency passes validation: ./entities/all']]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./entities/all', ['Dependency unsuccessful', 'Cannot run until dependency "./entities/ottoman/ottoman-association-registry" is successfully executed']]]
Invalid dependency :Cannot run until dependency passes validation: ./budgetkey/elasticsearch/index_contract_spending
From ./budgetkey/elasticsearch/index_contract_spending :['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending']
From ./budgetkey/elasticsearch/index_contract_spending :['From ./procurement/spending/latest-contract-spending', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']]
From ./budgetkey/elasticsearch/index_contract_spending :['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]]
From ./budgetkey/elasticsearch/index_contract_spending :['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]]
Dependency unsuccessful :Cannot run until dependency "./budgetkey/elasticsearch/index_supports" is successfully executed
Dependency unsuccessful :Cannot run until dependency "./budgetkey/elasticsearch/index_tenders" is successfully executed
Invalid dependency :Cannot run until dependency passes validation: ./budgetkey/elasticsearch/index_gov_decisions
From ./budgetkey/elasticsearch/index_gov_decisions :['Invalid dependency', 'Cannot run until dependency passes validation: ./government_decisions/government_decisions']
From ./budgetkey/elasticsearch/index_gov_decisions :['From ./government_decisions/government_decisions', ['Dependency unsuccessful', 'Cannot run until dependency "./government_decisions/scraper" is successfully executed']]

Pipeline ID: budgetkey/elasticsearch/sitemaps

Send periodic emails (emails)
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-08 10:33:37.129018
Last Completion:
2026-05-09 12:31:59.653786
Last Success:
2026-05-09 12:31:59.653786

Pipeline ID: budgetkey/emails/emails

Main Page - Aggregated budget by functional classification (budget-functional-aggregates)
Invalid

Last Run triggered by:
scheduled
Last Run started at:
2026-05-09 06:44:48.137001
Last Completion:
2026-05-09 06:59:26.936508
Last Success:
2026-05-09 06:59:26.936508

Dependency unsuccessful :Cannot run until dependency "./budget/national/processed/aggregated-yearly" is successfully executed

Pipeline ID: budgetkey/budget-functional-aggregates

budgetkey/elasticsearch/index_calls_for_bids
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./procurement/calls_for_bids/calls-for-bids-all
From ./procurement/calls_for_bids/calls-for-bids-all :['Dependency unsuccessful', 'Cannot run until dependency "./procurement/calls_for_bids/gov-publications" is successfully executed']
From ./procurement/calls_for_bids/calls-for-bids-all :['Dependency unsuccessful', 'Cannot run until dependency "./procurement/calls_for_bids/gov-publications2" is successfully executed']
From ./procurement/calls_for_bids/calls-for-bids-all :['Dependency unsuccessful', 'Cannot run until dependency "./procurement/calls_for_bids/gov-publications-ministry-of-immigration" is successfully executed']

Pipeline ID: budgetkey/elasticsearch/index_calls_for_bids

budgetkey/elasticsearch/index_contract_spending
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending
From ./procurement/spending/latest-contract-spending :['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']
From ./procurement/spending/latest-contract-spending :['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]
From ./procurement/spending/latest-contract-spending :['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]

Pipeline ID: budgetkey/elasticsearch/index_contract_spending

budgetkey/elasticsearch/index_entities
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./entities/entities
From ./entities/entities :['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/spending-by-entity']
From ./entities/entities :['From ./procurement/spending/spending-by-entity', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending']]
From ./entities/entities :['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']]]
From ./entities/entities :['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]]]
From ./entities/entities :['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]]]
From ./entities/entities :['Invalid dependency', 'Cannot run until dependency passes validation: ./entities/all']
From ./entities/entities :['From ./entities/all', ['Dependency unsuccessful', 'Cannot run until dependency "./entities/ottoman/ottoman-association-registry" is successfully executed']]

Pipeline ID: budgetkey/elasticsearch/index_entities

budgetkey/elasticsearch/index_gov_decisions
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./government_decisions/government_decisions
From ./government_decisions/government_decisions :['Dependency unsuccessful', 'Cannot run until dependency "./government_decisions/scraper" is successfully executed']

Pipeline ID: budgetkey/elasticsearch/index_gov_decisions

budgetkey/elasticsearch/index_national_budget_changes
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./budget/national/changes/processed/national-budget-changes-aggregated
From ./budget/national/changes/processed/national-budget-changes-aggregated :['Dependency unsuccessful', 'Cannot run until dependency "./budget/national/changes/explanations/all" is successfully executed']
From ./budget/national/changes/processed/national-budget-changes-aggregated :['Dependency unsuccessful', 'Cannot run until dependency "./budget/national/changes/processed/transactions" is successfully executed']

Pipeline ID: budgetkey/elasticsearch/index_national_budget_changes

budgetkey/elasticsearch/index_people
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Invalid dependency :Cannot run until dependency passes validation: ./people/aggregated
From ./people/aggregated :['Invalid dependency', 'Cannot run until dependency passes validation: ./people/all']
From ./people/aggregated :['From ./people/all', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/all-appointments']]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['Dependency unsuccessful', 'Cannot run until dependency "./people/company_appointments/media/themarker/themarker" is successfully executed']]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-nominations']]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-nominations', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-list']]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-nominations', ['From ./people/company_appointments/maya/maya-list', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-notification-updates']]]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-nominations', ['From ./people/company_appointments/maya/maya-list', ['From ./people/company_appointments/maya/maya-notification-updates', ['Dependency unsuccessful', 'Cannot run until dependency "./people/company_appointments/maya/maya-notification-list" is successfully executed']]]]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-resignations']]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-resignations', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-list']]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-resignations', ['From ./people/company_appointments/maya/maya-list', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/company_appointments/maya/maya-notification-updates']]]]]
From ./people/aggregated :['From ./people/all', ['From ./people/company_appointments/all-appointments', ['From ./people/company_appointments/maya/maya-resignations', ['From ./people/company_appointments/maya/maya-list', ['From ./people/company_appointments/maya/maya-notification-updates', ['Dependency unsuccessful', 'Cannot run until dependency "./people/company_appointments/maya/maya-notification-list" is successfully executed']]]]]]
From ./people/aggregated :['From ./people/all', ['Invalid dependency', 'Cannot run until dependency passes validation: ./people/procurement/procurement-individuals']]
From ./people/aggregated :['From ./people/all', ['From ./people/procurement/procurement-individuals', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending']]]
From ./people/aggregated :['From ./people/all', ['From ./people/procurement/procurement-individuals', ['From ./procurement/spending/latest-contract-spending', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']]]]
From ./people/aggregated :['From ./people/all', ['From ./people/procurement/procurement-individuals', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]]]]
From ./people/aggregated :['From ./people/all', ['From ./people/procurement/procurement-individuals', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]]]]
From ./people/aggregated :['From ./people/all', ['Dependency unsuccessful', 'Cannot run until dependency "./people/political_candidates/election_candidates21" is successfully executed']]

Pipeline ID: budgetkey/elasticsearch/index_people

budgetkey/elasticsearch/index_support_criteria
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Dependency unsuccessful :Cannot run until dependency "./supports/criteria/support-criteria" is successfully executed

Pipeline ID: budgetkey/elasticsearch/index_support_criteria

budgetkey/elasticsearch/sitemaps
Invalid

Last Run triggered by:
None
Last Run started at:
None
Last Completion:
None
Last Success:
None

Dependency unsuccessful :Cannot run until dependency "./budgetkey/elasticsearch/index_budget" is successfully executed
Invalid dependency :Cannot run until dependency passes validation: ./budgetkey/elasticsearch/index_national_budget_changes
From ./budgetkey/elasticsearch/index_national_budget_changes :['Invalid dependency', 'Cannot run until dependency passes validation: ./budget/national/changes/processed/national-budget-changes-aggregated']
From ./budgetkey/elasticsearch/index_national_budget_changes :['From ./budget/national/changes/processed/national-budget-changes-aggregated', ['Dependency unsuccessful', 'Cannot run until dependency "./budget/national/changes/explanations/all" is successfully executed']]
From ./budgetkey/elasticsearch/index_national_budget_changes :['From ./budget/national/changes/processed/national-budget-changes-aggregated', ['Dependency unsuccessful', 'Cannot run until dependency "./budget/national/changes/processed/transactions" is successfully executed']]
Invalid dependency :Cannot run until dependency passes validation: ./budgetkey/elasticsearch/index_entities
From ./budgetkey/elasticsearch/index_entities :['Invalid dependency', 'Cannot run until dependency passes validation: ./entities/entities']
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/spending-by-entity']]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./procurement/spending/spending-by-entity', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending']]]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']]]]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]]]]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./procurement/spending/spending-by-entity', ['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]]]]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['Invalid dependency', 'Cannot run until dependency passes validation: ./entities/all']]
From ./budgetkey/elasticsearch/index_entities :['From ./entities/entities', ['From ./entities/all', ['Dependency unsuccessful', 'Cannot run until dependency "./entities/ottoman/ottoman-association-registry" is successfully executed']]]
Invalid dependency :Cannot run until dependency passes validation: ./budgetkey/elasticsearch/index_contract_spending
From ./budgetkey/elasticsearch/index_contract_spending :['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/latest-contract-spending']
From ./budgetkey/elasticsearch/index_contract_spending :['From ./procurement/spending/latest-contract-spending', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports-data']]
From ./budgetkey/elasticsearch/index_contract_spending :['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['Invalid dependency', 'Cannot run until dependency passes validation: ./procurement/spending/quarterly-contract-spending-reports']]]
From ./budgetkey/elasticsearch/index_contract_spending :['From ./procurement/spending/latest-contract-spending', ['From ./procurement/spending/quarterly-contract-spending-reports-data', ['From ./procurement/spending/quarterly-contract-spending-reports', ['Dependency unsuccessful', 'Cannot run until dependency "./procurement/spending/quarterly-contract-spending-report-uris" is successfully executed']]]]
Dependency unsuccessful :Cannot run until dependency "./budgetkey/elasticsearch/index_supports" is successfully executed
Dependency unsuccessful :Cannot run until dependency "./budgetkey/elasticsearch/index_tenders" is successfully executed
Invalid dependency :Cannot run until dependency passes validation: ./budgetkey/elasticsearch/index_gov_decisions
From ./budgetkey/elasticsearch/index_gov_decisions :['Invalid dependency', 'Cannot run until dependency passes validation: ./government_decisions/government_decisions']
From ./budgetkey/elasticsearch/index_gov_decisions :['From ./government_decisions/government_decisions', ['Dependency unsuccessful', 'Cannot run until dependency "./government_decisions/scraper" is successfully executed']]

Pipeline ID: budgetkey/elasticsearch/sitemaps

budgetkey/analysis/spending/united
Running

Last Run triggered by:
scheduled
Last Run started at:
2026-05-10 10:44:25.254875
Last Completion:
Last Success:
2026-05-09 10:27:22.767274

Pipeline ID: budgetkey/analysis/spending/united

budgetkey/elasticsearch/index_supports
Running

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 09:10:19.546925
Last Completion:
Last Success:
2026-05-10 03:34:17.578037

Pipeline ID: budgetkey/elasticsearch/index_supports

budgetkey/elasticsearch/index_tenders
Running

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 09:22:40.456061
Last Completion:
Last Success:
2026-05-10 02:34:39.485735

Pipeline ID: budgetkey/elasticsearch/index_tenders

budgetkey/elasticsearch/index_budget
Failed

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 09:09:27.564283
Last Completion:
2026-05-10 09:10:19.457160
Last Success:
None

dump.to_sql
ERROR   :Traceback (most recent call last):
ERROR   :File "/usr/local/lib/python3.9/site-packages/datapackage_pipelines/specs/../lib/dump/to_sql.py", line 15, in <module>
ERROR   :spew_flow(flow(ctx.parameters), ctx)
ERROR   :File "/usr/local/lib/python3.9/site-packages/datapackage_pipelines/wrapper/wrapper.py", line 181, in __exit__
ERROR   :spew(self.datapackage, self.resource_iterator, stats=self.stats)
ERROR   :File "/usr/local/lib/python3.9/site-packages/datapackage_pipelines/wrapper/wrapper.py", line 75, in spew
ERROR   :for rec in res:
ERROR   :File "/usr/local/lib/python3.9/site-packages/dataflows/processors/dumpers/dumper_base.py", line 69, in row_counter
ERROR   :for row in iterator:
ERROR   :File "/usr/local/lib/python3.9/site-packages/tableschema_sql/writer.py", line 49, in write
ERROR   :ret = self.__update(connection, keyed_row)
ERROR   :File "/usr/local/lib/python3.9/site-packages/tableschema_sql/writer.py", line 100, in __update
ERROR   :res = connection.execute(expr)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1412, in execute
ERROR   :return meth(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 483, in _execute_on_connection
ERROR   :return connection._execute_clauseelement(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1627, in _execute_clauseelement
ERROR   :compiled_sql, extracted_params, cache_hit = elem._compile_w_cache(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 671, in _compile_w_cache
ERROR   :compiled_sql = self._compiler(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 288, in _compiler
ERROR   :return dialect.statement_compiler(dialect, self, **kw)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/compiler.py", line 1425, in __init__
ERROR   :Compiled.__init__(self, dialect, statement, **kwargs)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/compiler.py", line 866, in __init__
ERROR   :self.string = self.process(self.statement, **compile_kwargs)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/compiler.py", line 911, in process
ERROR   :return obj._compiler_dispatch(self, **kwargs)
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/visitors.py", line 143, in _compiler_dispatch
ERROR   :return meth(self, **kw)  # type: ignore  # noqa: E501
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/compiler.py", line 6040, in visit_update
ERROR   :crud_params_struct = crud._get_crud_params(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/crud.py", line 335, in _get_crud_params
ERROR   :raise exc.CompileError(
ERROR   :sqlalchemy.exc
ERROR   :.
ERROR   :CompileError
ERROR   ::
ERROR   :Unconsumed column names: code_level6, title_level4, title_level8, code_level8, code_level4, code_level2, title_level6, title_level2

Pipeline ID: budgetkey/elasticsearch/index_budget

budgetkey/analysis/spending/publisher_entity_analysis
Succeeded

Last Run triggered by:
scheduled
Last Run started at:
2026-05-09 10:27:23.028891
Last Completion:
2026-05-09 12:01:51.933361
Last Success:
2026-05-09 12:01:51.933361

Pipeline ID: budgetkey/analysis/spending/publisher_entity_analysis

budgetkey/analysis/spending/publisher_foa_analysis
Succeeded

Last Run triggered by:
scheduled
Last Run started at:
2026-05-09 10:27:23.038835
Last Completion:
2026-05-09 10:36:25.429917
Last Success:
2026-05-09 10:36:25.429917

Pipeline ID: budgetkey/analysis/spending/publisher_foa_analysis

budgetkey/documents
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 08:43:25.763915
Last Completion:
2026-05-10 08:43:33.345432
Last Success:
2026-05-10 08:43:33.345432

Pipeline ID: budgetkey/documents

budgetkey/elasticsearch/index_activities
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 10:17:01.257931
Last Completion:
2026-05-10 10:18:09.756515
Last Success:
2026-05-10 10:18:09.756515

Pipeline ID: budgetkey/elasticsearch/index_activities

budgetkey/elasticsearch/index_muni_budgets
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 08:44:19.755391
Last Completion:
2026-05-10 08:58:44.595445
Last Success:
2026-05-10 08:58:44.595445

Pipeline ID: budgetkey/elasticsearch/index_muni_budgets

budgetkey/elasticsearch/index_muni_tenders
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 10:18:09.766598
Last Completion:
2026-05-10 10:19:06.547545
Last Success:
2026-05-10 10:19:06.547545

Pipeline ID: budgetkey/elasticsearch/index_muni_tenders

budgetkey/elasticsearch/index_reports
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 10:15:41.260780
Last Completion:
2026-05-10 10:17:01.244817
Last Success:
2026-05-10 10:17:01.244817

Pipeline ID: budgetkey/elasticsearch/index_reports

budgetkey/elasticsearch/index_support_programs
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 09:19:47.049461
Last Completion:
2026-05-10 09:22:40.356488
Last Success:
2026-05-10 09:22:40.356488

Pipeline ID: budgetkey/elasticsearch/index_support_programs

budgetkey/elasticsearch/index_units
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-10 08:43:33.355195
Last Completion:
2026-05-10 08:44:19.745379
Last Success:
2026-05-10 08:44:19.745379

Pipeline ID: budgetkey/elasticsearch/index_units

Send periodic emails (emails)
Succeeded

Last Run triggered by:
dirty-task-init
Last Run started at:
2026-05-08 10:33:37.129018
Last Completion:
2026-05-09 12:31:59.653786
Last Success:
2026-05-09 12:31:59.653786

Pipeline ID: budgetkey/emails/emails