Error while running rasa x after successful install in rasa

[anshal (Anshal_Khan)]

PS C:\Users\anshal\PycharmProjects\rasa_bot> rasa x
Preparing the local database...
Traceback (most recent call last):
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1820, in _execute_context
    cursor, statement, parameters, context
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\engine\default.py", line 732, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such column: True

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

Traceback (most recent call last):
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\rasa\cli\x.py", line 500, in run_locally
    domain_path=domain_path,
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\rasax\community\local.py", line 196, in main
    sql_migrations.run_migrations(session)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\rasax\community\sql_migrations.py", line 35, in run_migrations
    _run_schema_migrations(session)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\rasax\community\sql_migrations.py", line 52, in _run_schema_migrations
    _run_alembic_migration(alembic_config)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\rasax\community\sql_migrations.py", line 76, in _run_alembic_migration
    command.upgrade(alembic_config, target_revision)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\command.py", line 298, in upgrade
    script.run_env()
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\script\base.py", line 489, in run_env
    util.load_python_file(self.dir, "env.py")
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\util\pyfiles.py", line 98, in load_python_file
    module = load_module_py(module_id, path)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\util\compat.py", line 184, in load_module_py
    spec.loader.exec_module(module)
  File "<frozen importlib._bootstrap_external>", line 678, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py", line 96, in <module>
    run_migrations_online()
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\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\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\runtime\environment.py", line 846, in run_migrations
    self.get_context().run_migrations(**kw)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\runtime\migration.py", line 522, in run_migrations
    step.migration_fn(**kw)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\rasax\community\database\schema_migrations\alembic\versions\migration_2021_06_16_speedup_in_training_data_update_65
2500998f3e.py", line 42, in upgrade
    sqlite_where=sa.text(index_text),
  File "C:\Users\anshal\AppData\Local\Programs\Python\Python36\lib\contextlib.py", line 88, in __exit__
    next(self.gen)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\operations\base.py", line 353, in batch_alter_table
    impl.flush()
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\operations\batch.py", line 82, in flush
    fn(*arg, **kw)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\ddl\impl.py", line 283, in create_index
    self._exec(schema.CreateIndex(index))
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\alembic\ddl\impl.py", line 141, in _exec
    return conn.execute(construct, *multiparams, **params)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1306, in execute
    return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\sql\ddl.py", line 81, in _execute_on_connection
    self, multiparams, params, execution_options
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1404, in _execute_ddl
    compiled,
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1863, in _execute_context
    e, statement, parameters, cursor, context
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\engine\base.py", line 2044, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
    raise exception
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1820, in _execute_context
    cursor, statement, parameters, context
  File "C:\Users\anshal\PycharmProjects\rasa_bot\venv\lib\site-packages\sqlalchemy\engine\default.py", line 732, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: True
[SQL: CREATE INDEX message_log_in_training_data_idx ON message_log (in_training_data) WHERE in_training_data is True]
(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 version is

Rasa Version      :         2.8.26
Minimum Compatible Version: 2.8.9
Rasa SDK Version  :         2.8.5
Rasa X Version    :         1.0.1
Python Version    :         3.6.8
Operating System  :         Windows-10-10.0.19041-SP0
Python Path       :         C:\Users\anshal\PycharmProjects\rasa_bot\venv\Scripts\python.exe

[ChrisRahme (Chris Rahmé)]

As per the docs for Rasa 2.x Intallation, please use Python 3.7 or 3.8.

Then reinstall Rasa X and try again.

[anshal (Anshal_Khan)]

can i use 3.10

[itsjhonny (João Pedro Guimarães)]

I think this thread can help you

[ChrisRahme (Chris Rahmé)]

The docs specify 3.7 and 3.8. You cant use something else.

[anshal (Anshal_Khan)]

i tried with ubuntu done with the installation part but rasa x is not running showing this message

(venv) anshal@DESKTOP-JCCENKD:~/rasaprojects$ rasa x
Before you can use Rasa X, you have to agree to its license agreement (you will only have to do this once).
? Would you like to view the license agreement in your web browser?  No

Rasa X License Agreement
===========================

Do you agree to the Rasa X license agreement (https://storage.cloud.google.com/rasa-x-releases/rasa_x_ce_license_agreement.pdf)?
By typing 'y', you agree to the terms. If you are using this software for a company, by confirming, you acknowledge you have the authority to do so.
If you do not agree, type 'n' to stop Rasa X.  Yes
Preparing the local database...
Traceback (most recent call last):
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1820, in _execute_context
    cursor, statement, parameters, context
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such column: True

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

Traceback (most recent call last):
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/rasa/cli/x.py", line 500, in run_locally
    domain_path=domain_path,
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/rasax/community/local.py", line 196, in main
    sql_migrations.run_migrations(session)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/rasax/community/sql_migrations.py", line 35, in run_migrations
    _run_schema_migrations(session)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/rasax/community/sql_migrations.py", line 52, in _run_schema_migrations
    _run_alembic_migration(alembic_config)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/rasax/community/sql_migrations.py", line 76, in _run_alembic_migration
    command.upgrade(alembic_config, target_revision)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/command.py", line 298, in upgrade
    script.run_env()
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/script/base.py", line 489, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file
    module = load_module_py(module_id, path)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/util/compat.py", line 184, in load_module_py
    spec.loader.exec_module(module)
  File "<frozen importlib._bootstrap_external>", line 678, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/rasax/community/database/schema_migrations/alembic/env.py", line 96, in <module>
    run_migrations_online()
  File "/home/anshal/rasaprojects/venv/lib/python3.6/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 "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/runtime/environment.py", line 846, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/runtime/migration.py", line 522, in run_migrations
    step.migration_fn(**kw)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/rasax/community/database/schema_migrations/alembic/versions/migration_2021_06_16_speedup_in_training_data_update_652500998f3e.py", line 42, in upgrade
    sqlite_where=sa.text(index_text),
  File "/usr/lib/python3.6/contextlib.py", line 88, in __exit__
    next(self.gen)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/operations/base.py", line 353, in batch_alter_table
    impl.flush()
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/operations/batch.py", line 82, in flush
    fn(*arg, **kw)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 283, in create_index
    self._exec(schema.CreateIndex(index))
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 141, in _exec
    return conn.execute(construct, *multiparams, **params)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1306, in execute
    return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py", line 81, in _execute_on_connection
    self, multiparams, params, execution_options
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1404, in _execute_ddl
    compiled,
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1863, in _execute_context
    e, statement, parameters, cursor, context
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2044, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
    raise exception
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1820, in _execute_context
    cursor, statement, parameters, context
  File "/home/anshal/rasaprojects/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: True
[SQL: CREATE INDEX message_log_in_training_data_idx ON message_log (in_training_data) WHERE in_training_data is True]
(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/.

[anshal (Anshal_Khan)]

i have also tried with python 3.8 same error exists

[nik202]

@anshal you want to run the rasa x after installing right ? always tag else I will miss your reply. @anshal how you have installed rasa x, please share the doc link?

[nik202]

@anshal Please read this if in-case you haven’t

The installation methods below were deprecated in Rasa X 1.0 and are removed as of Rasa X 1.1. Ref: Installation Guide

• Local Mode
• Docker Compose
• Quick Install Script

Good Luck or If you are looking for an alternative to approach me.

[anshal (Anshal_Khan)]

@nik202 you want to run the rasa x after installing right ? yes rasa x is not running

Local Mode

this is the process i follow and the version are Rasa Version : 3.0.0 Minimum Compatible Version: 3.0.0 Rasa SDK Version : 3.0.0 Rasa X Version : 1.1.0 Python Version : 3.8.0 Operating System : Windows-10-10.0.19041-SP0 Python Path : C:\Users\Anshal.Khan\PycharmProjects\rasa-x\venv\Scripts\python.exe

[anshal (Anshal_Khan)]

@nik202 can you help me in setting up the rasa X via zoom call or skype ?

[nik202]

@anshal as per my experience, I did not see Rasa X 0.42.x (shared linked) successful running with ROS on the other hand, Rasa X 0.39.3 is working fine but I’m not sure it’s compatible with Rasa 3. X or not. So, for installing rasa x 1.X I can’t help you but for Rasa X 0.39.3 + Rasa 2.x contact me.

@anshal

rasa X via zoom call or skype ?

I’m not sure that I can give you zoom or skype meeting time this week or weekend as me traveling this week. I hope you understand. Thanks.

Ref this thread hope so it will help:

Error running rasa x - <Future at 0x2b5686c4400 state=finished raised gaierror> on Windows

@lis Right, if you are now not concern about the rasa CDD and GitHub connectivity, I will recommend you the following steps, and please stick on that and you will able to install rasa x with the ease. For Installation please follow these steps: Please follow these steps for the installation of ROS and Rasa X Note: You can ignore a few steps if you already performed it! But I’d recommend starting the fresh installation without seeing any video, please. Please install An…