Can someone please help me with this error which is occurring when "rasa x " is used
Rasa Version : 2.8.16
Minimum Compatible Version: 2.8.9
Rasa SDK Version : 2.8.3
Rasa X Version : 1.0.0
Python Version : 3.8.4rc1
Operating System : Windows-10-10.0.19041-SP0
@nik202 if possible can you please help me out with this
(rasabot) E:\Rasa Project>rasa x
Preparing the local database...
2021-12-26 00:18:23 ERROR asyncio - Error on reading from the event loop self pipe
loop: <ProactorEventLoop running=True closed=False debug=False>
Traceback (most recent call last):
File "C:\Users\Abhishikt\AppData\Local\Programs\Python\Python38\lib\asyncio\windows_events.py", line 453, in finish_recv
return ov.getresult()
OSError: [WinError 995] The I/O operation has been aborted because of either a thread exit or an application request
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\Abhishikt\AppData\Local\Programs\Python\Python38\lib\asyncio\proactor_events.py", line 768, in _loop_self_reading
f.result() # may raise
File "C:\Users\Abhishikt\AppData\Local\Programs\Python\Python38\lib\asyncio\windows_events.py", line 808, in _poll
value = callback(transferred, key, ov)
File "C:\Users\Abhishikt\AppData\Local\Programs\Python\Python38\lib\asyncio\windows_events.py", line 457, in finish_recv
raise ConnectionResetError(*exc.args)
ConnectionResetError: [WinError 995] The I/O operation has been aborted because of either a thread exit or an application request
Traceback (most recent call last):
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _execute_context
self.dialect.do_execute(
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\engine\default.py", line 732, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such function: json_extract
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "c:\users\abhishikt\rasabot\lib\site-packages\rasa\cli\x.py", line 496, in run_locally
local.main(
File "c:\users\abhishikt\rasabot\lib\site-packages\rasax\community\local.py", line 196, in main
sql_migrations.run_migrations(session)
File "c:\users\abhishikt\rasabot\lib\site-packages\rasax\community\sql_migrations.py", line 35, in run_migrations
_run_schema_migrations(session)
File "c:\users\abhishikt\rasabot\lib\site-packages\rasax\community\sql_migrations.py", line 52, in _run_schema_migrations
_run_alembic_migration(alembic_config)
File "c:\users\abhishikt\rasabot\lib\site-packages\rasax\community\sql_migrations.py", line 76, in _run_alembic_migration
command.upgrade(alembic_config, target_revision)
File "c:\users\abhishikt\rasabot\lib\site-packages\alembic\command.py", line 298, in upgrade
script.run_env()
File "c:\users\abhishikt\rasabot\lib\site-packages\alembic\script\base.py", line 489, in run_env
util.load_python_file(self.dir, "env.py")
File "c:\users\abhishikt\rasabot\lib\site-packages\alembic\util\pyfiles.py", line 98, in load_python_file
module = load_module_py(module_id, path)
File "c:\users\abhishikt\rasabot\lib\site-packages\alembic\util\compat.py", line 184, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 783, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "c:\users\abhishikt\rasabot\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py", line 96, in <module>
run_migrations_online()
File "c:\users\abhishikt\rasabot\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py", line 86, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "c:\users\abhishikt\rasabot\lib\site-packages\alembic\runtime\environment.py", line 846, in run_migrations
self.get_context().run_migrations(**kw)
File "c:\users\abhishikt\rasabot\lib\site-packages\alembic\runtime\migration.py", line 522, in run_migrations
step.migration_fn(**kw)
File "c:\users\abhishikt\rasabot\lib\site-packages\rasax\community\database\schema_migrations\alembic\versions\migration_2021_08_13_statistic_on_used_channel_names_017cb274256f.py", line 80, in upgrade
_migrate_events(session)
File "c:\users\abhishikt\rasabot\lib\site-packages\rasax\community\database\schema_migrations\alembic\versions\migration_2021_08_13_statistic_on_used_channel_names_017cb274256f.py", line 50, in _migrate_events
results = session.execute(_input_channel_query())
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\orm\session.py", line 1692, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\engine\base.py", line 1614, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\sql\elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\engine\base.py", line 1481, in _execute_clauseelement
ret = self._execute_context(
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\engine\base.py", line 1845, in _execute_context
self._handle_dbapi_exception(
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\engine\base.py", line 2026, in _handle_dbapi_exception
util.raise_(
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
raise exception
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _execute_context
self.dialect.do_execute(
File "c:\users\abhishikt\rasabot\lib\site-packages\sqlalchemy\engine\default.py", line 732, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such function: json_extract
[SQL: SELECT json_extract(data, '$.input_channel') as input_channel, COUNT(json_extract(data, '$.input_channel')) as count FROM conversation_event WHERE json_extract(data, '$.input_channel') IS NOT NULL GROUP BY json_extract(data, '$.input_channel')]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Sorry, something went wrong (see error above). Make sure to start Rasa X with valid data and valid domain and config files. Please, also check any warnings that popped up.
If you need help fixing the issue visit our forum: http://forum.rasa.com/.