Orchestrator/Bug: Enabling/Disabling triggers produces an error

[hbpe-aarhus]

Clicking Enable or Disable in the Orchestrator GUI produces the following error:

Exception in Tkinter callback Traceback (most recent call last): File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\base.py", line 1814, in _execute_context context = constructor( ^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\default.py", line 1455, in _init_compiled l_param: List[Any] = [ ^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\default.py", line 1456, in flattened_processorskey File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\sql\sqltypes.py", line 3651, in process value = value.hex ^^^^^^^^^ AttributeError: 'str' object has no attribute 'hex'

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\tkinter__init.py", line 1948, in call__ return self.func(args) ^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\OpenOrchestrator\orchestrator\trigger_tab.py", line 58, in enable_button = ttk.Button(controls_frame, text="Enable", command=lambda: set_trigger_status(TriggerStatus.IDLE, sc_table, q_table, si_table)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\OpenOrchestrator\orchestrator\trigger_tab.py", line 178, in set_trigger_status trigger = get_selected_trigger(sc_table, q_table, si_table) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\OpenOrchestrator\orchestrator\trigger_tab.py", line 212, in get_selected_trigger return db_util.get_trigger(trigger_id) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\OpenOrchestrator\database\db_util.py", line 56, in inner result = func(args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\OpenOrchestrator\database\db_util.py", line 101, in get_trigger return session.scalar(query) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\orm\session.py", line 2358, in scalar return self._execute_internal( ^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\orm\session.py", line 2190, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\orm\context.py", line 293, in orm_execute_statement result = conn.execute( ^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\base.py", line 1416, in execute return meth( ^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\sql\elements.py", line 516, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\base.py", line 1639, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\base.py", line 1820, in _execute_context self._handle_dbapi_exception( File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\base.py", line 2343, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\base.py", line 1814, in _execute_context context = constructor( ^^^^^^^^^^^^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\default.py", line 1455, in _init_compiled l_param: List[Any] = [ ^ File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\engine\default.py", line 1456, in flattened_processorskey File "C:\Users\AZ41832\AppData\Local\Programs\Python\Python311\Lib\site-packages\sqlalchemy\sql\sqltypes.py", line 3651, in process value = value.hex ^^^^^^^^^ sqlalchemy.exc.StatementError: (builtins.AttributeError) 'str' object has no attribute 'hex' [SQL: SELECT "Triggers".id, "Triggers".trigger_name, "Triggers".process_name, "Triggers".last_run, "Triggers".process_path, "Triggers".process_args, "Triggers".process_status, "Triggers".is_git_repo, "Triggers".is_blocking, "Triggers".type FROM "Triggers" WHERE "Triggers".id = ?] [parameters: [{}]]

[ghbm-itk]

What flavor of SQL did you use?

[hbpe-aarhus]

SQLite on Windows 10. Here's the connection string:

sqlite:///C:\OpenOrchestratorDB\test_database.db

[ghbm-itk]

https://github.com/itk-dev-rpa/OpenOrchestrator/issues/75