I find this error when trying to run Rasa x

Preparing the local database...
Traceback (most recent call last):
 File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _execute_context
    self.dialect.do_execute(
  File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\default.py", line 719, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: table conversation_channel_statistic already exists

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

Traceback (most recent call last):
  File "c:\program files\python38\lib\site-packages\rasa\cli\x.py", line 496, in run_locally
    local.main(
  File "c:\program files\python38\lib\site-packages\rasax\community\local.py", line 196, in main
    sql_migrations.run_migrations(session)
  File "c:\program files\python38\lib\site-packages\rasax\community\sql_migrations.py", line 35, in run_migrations
    _run_schema_migrations(session)
  File "c:\program files\python38\lib\site-packages\rasax\community\sql_migrations.py", line 52, in _run_schema_migrations
    _run_alembic_migration(alembic_config)
  File "c:\program files\python38\lib\site-packages\rasax\community\sql_migrations.py", line 76, in _run_alembic_migration
    command.upgrade(alembic_config, target_revision)
  File "c:\program files\python38\lib\site-packages\alembic\command.py", line 298, in upgrade
    script.run_env()
  File "c:\program files\python38\lib\site-packages\alembic\script\base.py", line 489, in run_env
    util.load_python_file(self.dir, "env.py")
  File "c:\program files\python38\lib\site-packages\alembic\util\pyfiles.py", line 98, in load_python_file
    module = load_module_py(module_id, path)
  File "c:\program files\python38\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:\program files\python38\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py", line 96, in <module>
    run_migrations_online()
  File "c:\program files\python38\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:\program files\python38\lib\site-packages\alembic\runtime\environment.py", line 846, in run_migrations
    self.get_context().run_migrations(**kw)
  File "c:\program files\python38\lib\site-packages\alembic\runtime\migration.py", line 522, in run_migrations
    step.migration_fn(**kw)
  File "c:\program files\python38\lib\site-packages\rasax\community\database\schema_migrations\alembic\versions\migration_2021_08_13_statistic_on_used_channel_names_017cb274256f.py", line 71, in upgrade
    op.create_table(
  File "<string>", line 8, in create_table
  File "<string>", line 3, in create_table
  File "c:\program files\python38\lib\site-packages\alembic\operations\ops.py", line 1252, in create_table
    return operations.invoke(op)
  File "c:\program files\python38\lib\site-packages\alembic\operations\base.py", line 373, in invoke
    return fn(self, operation)
  File "c:\program files\python38\lib\site-packages\alembic\operations\toimpl.py", line 101, in create_table
    operations.impl.create_table(table)
  File "c:\program files\python38\lib\site-packages\alembic\ddl\impl.py", line 259, in create_table
    self._exec(schema.CreateTable(table))
  File "c:\program files\python38\lib\site-packages\alembic\ddl\impl.py", line 141, in _exec
    return conn.execute(construct, *multiparams, **params)
  File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1289, in execute
    return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
  File "c:\program files\python38\lib\site-packages\sqlalchemy\sql\ddl.py", line 77, in _execute_on_connection
    return connection._execute_ddl(
  File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1381, in _execute_ddl
    ret = self._execute_context(
  File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1845, in _execute_context
    self._handle_dbapi_exception(
  File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 2026, in _handle_dbapi_exception
    util.raise_(
  File "c:\program files\python38\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
    raise exception
  File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _execute_context
    self.dialect.do_execute(
  File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\default.py", line 719, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table conversation_channel_statistic already exists
[SQL:
CREATE TABLE conversation_channel_statistic (
        project_id VARCHAR(255) NOT NULL,
        channel VARCHAR(255) NOT NULL,
        count INTEGER,
        PRIMARY KEY (project_id, channel),
        FOREIGN KEY(project_id) REFERENCES conversation_statistic (project_id)
)

]
(Background on this error at: https://sqlalche.me/e/14/e3q8)```


**Rasa Version      :         2.8.15**
**Minimum Compatible Version: 2.8.9**
**Rasa SDK Version  :         2.8.3**
**Rasa X Version    :         1.0.0**
**Python Version    :         3.8.3**
**Operating System  :         Windows-10-10.0.19041-SP0**
**Python Path       :         c:\program files\python38\python.exe**
**Pip Version: pip 20.1.1 from C:\Users\clari\Anaconda3\lib\site-packages\pip (python 3.8)**

Can someone help me? (Sorry in advance, I'm not good at English)

@sfclarisse can you please confirm how you installed rasa x in your local machine? and are you sure your rasa x version is the same as mention please even share rasa --version ?

1 Like

screenshot1

I installed using pip install rasa-x --extra-index-url https://pypi.rasa.com/simple´

@sfclarisse really, Rasa X version is 1.0.0 I never seen this version :flushed: Compatibility Matrix. I guess I am outdated now. Anyways, what is the issue you facing? and what command you running as you encountered the error, for me please share the screenshot from the command you entered.

I am simply trying to run “Rasa x”, and I find these errors.

@sfclarisse try delete .db files from the project folder and run ?

I did this, the same error happened. Do you think I should downgrade the Rasa X or the error isn’t about this?

@sfclarisse well, honestly I haven’t seen this version, I am amazed how you install this version :stuck_out_tongue: Try at least 0.42.4, may be. I guess you have even install previously 0.39.3 also?

I tried both versions, I keep seeing the same error. :frowning_face:

@sfclarisse according to this error, you should delete the .db files events and rasa and again run rasa x.

This error message is more likely a python library compatibility problem. Your multidict, gast, numpy packages are not the version that rasa needs. A solution for this is to use virtual environment and install the compatible version of multidict, gast, numpy packages in that virtual environment.

MyAccountAccess

How do I know which versions are supported to install in the virtual environment?

could you tell me what happened? what can i do to solve?

@sfclarisse please share me again your rasa --version?

I am sure, you are using 0.39.3 ? If so, you are able to talk with bot while using rasa x GUI and on terminal you are only seeing this error, is that right or me just guessing ?

rasa x GUI? What does it mean? I can talk to the bot in the terminal, but isn’t that the ‘open source’ rasa feature?

@sfclarisse means when you type rasa x are you able to see rasa x GUI is opening in default web browser.

Starting Rasa X in local mode... 🚀
Traceback (most recent call last):
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 162, in _catch_revision_errors
    yield
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 364, in _upgrade_revs
    revs = list(revs)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 765, in _iterate_revisions
    requested_lowers = self.get_revisions(lower)
  File "c:\users\clari\anaconda3\envs\ambiente\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\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 319, in <listcomp>
    return sum([self.get_revisions(id_elem) for id_elem in id_], ())
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 324, in get_revisions    for rev_id in resolved_id
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 324, in <genexpr>
    for rev_id in resolved_id
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 397, in _revision_for_ident
    resolved_id,
alembic.script.revision.ResolutionError: No such revision or branch '652500998f3e'

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

Traceback (most recent call last):
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasa\cli\x.py", line 500, in run_locally
    domain_path=domain_path,
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\local.py", line 234, in main
    sql_migrations.run_migrations(session)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\sql_migrations.py", line 25, in run_migrations
    _run_schema_migrations(session)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\sql_migrations.py", line 41, in _run_schema_migrations
    _run_alembic_migration(alembic_config)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\sql_migrations.py", line 65, in _run_alembic_migration
    command.upgrade(alembic_config, target_revision)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\command.py", line 298, in upgrade
    script.run_env()
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 489, in run_env
    util.load_python_file(self.dir, "env.py")
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\util\pyfiles.py", line 98, in load_python_file
    module = load_module_py(module_id, path)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\util\compat.py", line 184, in load_module_py
    spec.loader.exec_module(module)
  File "<frozen importlib._bootstrap_external>", line 728, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py", line 96, in <module>
    run_migrations_online()
  File "c:\users\clari\anaconda3\envs\ambiente\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\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\runtime\environment.py", line 846, in run_migrations
    self.get_context().run_migrations(**kw)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\runtime\migration.py", line 511, in run_migrations
    for step in self._migrations_fn(heads, self):
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\command.py", line 287, in upgrade
    return script._upgrade_revs(revision, rev)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 369, in _upgrade_revs
    for script in reversed(list(revs))
  File "c:\users\clari\anaconda3\envs\ambiente\lib\contextlib.py", line 130, in __exit__
    self.gen.throw(type, value, traceback)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 194, in _catch_revision_errors
    compat.raise_from_cause(util.CommandError(resolution))
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\util\compat.py", line 308, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\util\compat.py", line 301, in reraise
    raise value.with_traceback(tb)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 162, in _catch_revision_errors
    yield
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 364, in _upgrade_revs
    revs = list(revs)
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 765, in _iterate_revisions
    requested_lowers = self.get_revisions(lower)
  File "c:\users\clari\anaconda3\envs\ambiente\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\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 319, in <listcomp>
    return sum([self.get_revisions(id_elem) for id_elem in id_], ())
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 324, in get_revisions    for rev_id in resolved_id
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 324, in <genexpr>
    for rev_id in resolved_id
  File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 397, in _revision_for_ident
    resolved_id,
alembic.util.exc.CommandError: Can't locate revision identified by '652500998f3e'

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

@sfclarisse ok can you delete the rasa .db files such as events and rasa from project folder and try run rasa x again?

@sfclarisse always mention me with @ nik202