Last Run triggered by:

scheduled

Last Run started at:

2026-05-20 00:01:59.456924

Last Completion:

2026-05-20 00:02:48.251226

Last Success:

2026-05-19 09:51:46.106702

---

flow
ERROR   :Traceback (most recent call last):
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2108, in _exec_insertmany_context
ERROR   :dialect.do_execute(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 921, in do_execute
ERROR   :cursor.execute(statement, parameters)
ERROR   :psycopg2
ERROR   :.
ERROR   :ProgrammingError
ERROR   ::
ERROR   :can't adapt type 'dict'
ERROR   :The above exception was the direct cause of the following exception:
ERROR   :Traceback (most recent call last):
ERROR   :File "/usr/local/lib/python3.9/site-packages/datapackage_pipelines/specs/../lib/flow.py", line 15, in <module>
ERROR   :spew_flow(flow, 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 57, in write
ERROR   :for wr in self.__insert(connection):
ERROR   :File "/usr/local/lib/python3.9/site-packages/tableschema_sql/writer.py", line 86, in __insert
ERROR   :connection.execute(statement, self.__buffer)
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 1635, in _execute_clauseelement
ERROR   :ret = self._execute_context(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1839, in _execute_context
ERROR   :return self._exec_insertmany_context(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2116, in _exec_insertmany_context
ERROR   :self._handle_dbapi_exception(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2339, in _handle_dbapi_exception
ERROR   :raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2108, in _exec_insertmany_context
ERROR   :dialect.do_execute(
ERROR   :File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 921, in do_execute
ERROR   :cursor.execute(statement, parameters)
ERROR   :sqlalchemy.exc
ERROR   :.
ERROR   :ProgrammingError
ERROR   ::
ERROR   :(psycopg2.ProgrammingError) can't adapt type 'dict'
[SQL: INSERT INTO soproc_measurement (tender_key, service_name, tender_name, tender_id, office, unit, subunit, principle_score_1_1, principle_score_1_2, principle_score_1_3, principle_score_1_4, principle_score_1, principle_score_2_1, principle_score_2_2,  ... 28169 characters truncated ... (principle_score_6_2__44)s, %(principle_score_6_3__44)s, %(principle_score_6__44)s, %(is_flag__44)s)]
[parameters: {'unit__0': 'מינהל פדגוגי', 'principle_score_2__0': 0.36363636363636365, 'principle_score_6__0': 0.8, 'tender_name__0': 'הפעלה לוגיסטית של מבחני הקבלה ותהליך האיתור לשילוב תלמידים במסגרות ותכניות ייחודיות למחוננים בחינוך היסודי', 'principle_score_3_1__0': 0.8, 'principle_score_4__0': 0.9, 'principle_score_6_2__0': 0.8666666666666667, 'principle_score_1_4__0': 0.3, 'principle_score_1_3__0': 0.27999999999999997, 'principle_score_3__0': 0.768, 'service_name__0': None, 'tender_key__0': '1/1.2024', 'principle_score_2_2__0': 0.5, 'principle_score_1_2__0': 0.23999999999999996, 'principle_score_6_1__0': 0.8, 'office__0': 'משרד החינוך', 'principle_score_3_2__0': 0.72, 'tender_id__0': None, 'subunit__0': 'מינהל פדגוגי', 'principle_score_6_3__0': 0.7333333333333333, 'is_flag__0': True, 'principle_score_1_1__0': 0.32, 'principle_score_5__0': 0.4705882352941176, 'principle_score_2_1__0': 0, 'principle_score_1__0': 0.28363636363636363, 'unit__1': 'מינהל פדגוגי', 'principle_score_2__1': 0.2909090909090909, 'principle_score_6__1': 0.9, 'tender_name__1': 'הפעלה לוגיסטית של מבחני הקבלה ותהליך האיתור לשילוב תלמידים במסגרות ותכניות ייחודיות למחוננים בחינוך היסודי', 'principle_score_3_1__1': 0.6, 'principle_score_4__1': 0.8, 'principle_score_6_2__1': 0.8666666666666667, 'principle_score_1_4__1': 0.2, 'principle_score_1_3__1': 0.2, 'principle_score_3__1': 0.6, 'service_name__1': None, 'tender_key__1': '4000581526:office:1/1.2024a', 'principle_score_2_2__1': 0.4, 'principle_score_1_2__1': 0.2, 'principle_score_6_1__1': 0.9, 'office__1': 'משרד החינוך', 'principle_score_3_2__1': 0.6, 'tender_id__1': None, 'subunit__1': 'מינהל פדגוגי', 'principle_score_6_3__1': 0.9333333333333332, 'is_flag__1': True, 'principle_score_1_1__1': 0.2, 'principle_score_5__1': 1, 'principle_score_2_1__1': 0, 'principle_score_1__1': 0.2 ... 1025 parameters truncated ... 'unit__43': 'מוגבלויות', 'principle_score_2__43': 1, 'principle_score_6__43': 0.9099999999999998, 'tender_name__43': 'הפעלת תכניות תעסוקה מוגנת עבור אנשים עם מוגבלות - תכנית מח"ר (מפעלים חברתיים רווחיים), בפריסה ארצית', 'principle_score_3_1__43': 1, 'principle_score_4__43': 0.6, 'principle_score_6_2__43': 1, 'principle_score_1_4__43': 0.8, 'principle_score_1_3__43': 0.6, 'principle_score_3__43': 1, 'service_name__43': 'הפעלת תכניות תעסוקה מוגנת עבור אנשים עם מוגבלות-תכנית מחר, בפריסה ארצית', 'tender_key__43': '4000600715:office:1173/2025', 'principle_score_2_2__43': 1, 'principle_score_1_2__43': 0.8800000000000001, 'principle_score_6_1__43': 0.92, 'office__43': 'משרד הרווחה', 'principle_score_3_2__43': 1, 'tender_id__43': '1173/2025', 'subunit__43': 'מוגבלויות', 'principle_score_6_3__43': 0.8, 'is_flag__43': False, 'principle_score_1_1__43': 1, 'principle_score_5__43': 0.8800000000000001, 'principle_score_2_1__43': 1, 'principle_score_1__43': 0.8514285714285714, 'unit__44': 'מינהל פדגוגי', 'principle_score_2__44': 1, 'principle_score_6__44': 0.4699999999999999, 'tender_name__44': 'התקשרות בפטור עם הספרייה לעיוורים - כספק יחיד - עבור ספרי לימוד לתלמידים עיוורים ולקויי ראיה', 'principle_score_3_1__44': 0.8, 'principle_score_4__44': 1, 'principle_score_6_2__44': 0.2, 'principle_score_1_4__44': 0.2, 'principle_score_1_3__44': 1, 'principle_score_3__44': 0.5, 'service_name__44': 'הפקה ואספקת ספרי לימוד לתלמידים עיוורים ולקוי ראיה ', 'tender_key__44': '4000601873:exemptions:none', 'principle_score_2_2__44': 1, 'principle_score_1_2__44': 0.72, 'principle_score_6_1__44': 0.43999999999999995, 'office__44': 'משרד החינוך', 'principle_score_3_2__44': 0.2, 'tender_id__44': 'פטור', 'subunit__44': 'מינהל פדגוגי', 'principle_score_6_3__44': 0.8, 'is_flag__44': False, 'principle_score_1_1__44': 0.8400000000000002, 'principle_score_5__44': 0.5599999999999999, 'principle_score_2_1__44': 1, 'principle_score_1__44': 0.7200000000000002}]
(Background on this error at: https://sqlalche.me/e/20/f405)

---

Pipeline ID: activities/social_services/measurements/collect