Pipeline ID: budgetkey/analysis/spending/publisher_entity_analysis
Pipeline ID: budgetkey/analysis/spending/publisher_foa_analysis
Pipeline ID: budgetkey/analysis/spending/united
Dependency unsuccessful :Cannot run until dependency "./budget/national/processed/aggregated-yearly" is successfully executed
Pipeline ID: budgetkey/budget-functional-aggregates
Pipeline ID: budgetkey/documents
Pipeline ID: budgetkey/elasticsearch/index_activities
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
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
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
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
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
Pipeline ID: budgetkey/elasticsearch/index_muni_budgets
Pipeline ID: budgetkey/elasticsearch/index_muni_tenders
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
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
Pipeline ID: budgetkey/elasticsearch/index_reports
Dependency unsuccessful :Cannot run until dependency "./supports/criteria/support-criteria" is successfully executed
Pipeline ID: budgetkey/elasticsearch/index_support_criteria
Pipeline ID: budgetkey/elasticsearch/index_support_programs
Pipeline ID: budgetkey/elasticsearch/index_supports
Pipeline ID: budgetkey/elasticsearch/index_tenders
Pipeline ID: budgetkey/elasticsearch/index_units
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
Pipeline ID: budgetkey/emails/emails
Dependency unsuccessful :Cannot run until dependency "./budget/national/processed/aggregated-yearly" is successfully executed
Pipeline ID: budgetkey/budget-functional-aggregates
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
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
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
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
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
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
Dependency unsuccessful :Cannot run until dependency "./supports/criteria/support-criteria" is successfully executed
Pipeline ID: budgetkey/elasticsearch/index_support_criteria
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
Pipeline ID: budgetkey/analysis/spending/united
Pipeline ID: budgetkey/elasticsearch/index_supports
Pipeline ID: budgetkey/elasticsearch/index_tenders
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
Pipeline ID: budgetkey/analysis/spending/publisher_entity_analysis
Pipeline ID: budgetkey/analysis/spending/publisher_foa_analysis
Pipeline ID: budgetkey/documents
Pipeline ID: budgetkey/elasticsearch/index_activities
Pipeline ID: budgetkey/elasticsearch/index_muni_budgets
Pipeline ID: budgetkey/elasticsearch/index_muni_tenders
Pipeline ID: budgetkey/elasticsearch/index_reports
Pipeline ID: budgetkey/elasticsearch/index_support_programs
Pipeline ID: budgetkey/elasticsearch/index_units
Pipeline ID: budgetkey/emails/emails