RASA X not working on windows 10

[Deprecated] Rasa X Community Edition
1 
File "e:\rishibha\rasa_new_2dec\rasaenv\lib\site-packages\sqlalchemy\engine\default.py", line 719, 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/.

RASA x is not working, it shows the above-pasted error in the terminal. I also tried to delete the rasa.db and events.db file. But the error still exists. Please help

2

@Shakirsadiq6 can you share the rasa --version? i

4

image
image868×375 78.9 KB

@nik202 I am having the following versions. And also you can see the new error in the terminal. The same versions work on my Linux system but not on windows. Please help me to solve this problem.

5

@Shakirsadiq6 confirm one thing, are you able to install rasa local machine installation on Linux system with the following mentioned configurations of rasa and rasa x ?

@Shakirsadiq6 what error you getting when you type rasa x on terminal, share with us a complete error.

6

@nik202 On the Linux system, the basic installation guide helps me to install rasa and rasa x successfully. But on windows it shows me an error when I run rasa x command, however rasa shell is working. the error which shows up is below:

Starting Rasa X in local mode… :rocket: Traceback (most recent call last): File “c:\users\arti\desktop\rasa\renv\lib\site-packages\rasa\cli\x.py”, line 496, in run_locally
local.main( File “c:\users\arti\desktop\rasa\renv\lib\site-packages\rasax\community\local.py”, line 234, in main
sql_migrations.run_migrations(session) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\rasax\community\sql_migrations.py”, line 25, in run_migrations _run_schema_migrations(session) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\rasax\community\sql_migrations.py”, line 41, in _run_schema_migrations _run_alembic_migration(alembic_config) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\rasax\community\sql_migrations.py”, line 65, in _run_alembic_migration command.upgrade(alembic_config, target_revision) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\command.py”, line 298, in upgrade
script.run_env() File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\base.py”, line 489, in run_env util.load_python_file(self.dir, “env.py”) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\util\pyfiles.py”, line 98, in load_python_file module = load_module_py(module_id, path) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\util\compat.py”, line 184, in load_module_py spec.loader.exec_module(module) File “”, line 848, in exec_module File “”, line 219, in _call_with_frames_removed File “c:\users\arti\desktop\rasa\renv\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py”, line 96, in run_migrations_online() File “c:\users\arti\desktop\rasa\renv\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py”, line 86, in run_migrations_online context.run_migrations() File “”, line 8, in run_migrations File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\runtime\environment.py”, line 846, in run_migrations self.get_context().run_migrations(**kw) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\runtime\migration.py”, line 511, in run_migrations for step in self._migrations_fn(heads, self): File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\command.py”, line 287, in upgrade
return script._upgrade_revs(revision, rev) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\base.py”, line 364, in upgrade_revs revs = list(revs) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\revision.py”, line 765, in iterate_revisions requested_lowers = self.get_revisions(lower) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\revision.py”, line 319, in get_revisions return sum([self.get_revisions(id_elem) for id_elem in id], ()) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\revision.py”, line 319, in return sum([self.get_revisions(id_elem) for id_elem in id], ()) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\revision.py”, line 321, in get_revisions resolved_id, branch_label = self.resolve_revision_number(id) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\revision.py”, line 501, in _resolve_revision_number self._revision_map File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\util\langhelpers.py”, line 230, in get obj.dict[self.name] = result = self.fget(obj) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\revision.py”, line 123, in _revision_map for revision in self._generator(): File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\base.py”, line 112, in _load_revisions script = Script.from_filename(self, vers, file) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\script\base.py”, line 906, in from_filename module = util.load_python_file(dir, filename) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\util\pyfiles.py”, line 98, in load_python_file module = load_module_py(module_id, path) File “c:\users\arti\desktop\rasa\renv\lib\site-packages\alembic\util\compat.py”, line 184, in load_module_py spec.loader.exec_module(module) File “”, line 848, in exec_module File “”, line 219, in call_with_frames_removed File “c:\users\arti\desktop\rasa\renv\lib\site-packages\rasax\community\database\schema_migrations\alembic\versions\migration_2019_06_03_initial_migration_2a216ed121dd.py”, line 14, in import rasax.community.database.schema_migrations.alembic.utils as migration_utils File “c:\users\arti\desktop\rasa\renv\lib\site-packages\rasax\community\database\schema_migrations\alembic\utils.py”, line 12, in from sqlalchemy.engine import reflection, Row, Connection ImportError: cannot import name ‘Row’ from ‘sqlalchemy.engine’ (c:\users\arti\desktop\rasa\renv\lib\site-packages\sqlalchemy\engine_init.py)

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/.

7

@Shakirsadiq6 install pip install SQLAlchemy==1.3.22 and can you share which version of Rasa x you are installing?

8

Requirement already satisfied for this SQLAlchemy version. No change in error output. RASA version: 2.8.12 RASA X version: 0.42.4 @nik202

9

@Shakirsadiq6 Strange, try delete the .db files i.e events and rasa and then run rasa x?

10

@nik202 I did remove these files but after running rasa x showed up the same error.

11

Hi, I’m having the same problem and cannot find the solution anywhere, did you solve it @Shakirsadiq6

12

@hieuchi911 can you please share some screenshots?

13

Sorry brother, Not a single solution worked. Every time it came up with a new error. So currently I’m using it on my Linux system.

14

@Shakirsadiq6 what issue you facing while installing rasa x on windows, can you share the feedback? When ever you have some time.