# Rasa X - ORA-01430: the column being add already exist in the table

**URL:** <https://forum.rasa.com/t/rasa-x-ora-01430-the-column-being-add-already-exist-in-the-table/20736>\
**Category:** \[Deprecated\] Rasa X Community Edition\
**Created:** [October 31, 2019, 3:11pm UTC](https://forum.rasa.com/t/rasa-x-ora-01430-the-column-being-add-already-exist-in-the-table/20736 "2019-10-31T15:11:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![DiegoProtec](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/diegoprotec/32/2686_2.png) [@DiegoProtec](https://forum.rasa.com/u/DiegoProtec)\
**Post date:** [October 31, 2019, 3:11pm UTC](https://forum.rasa.com/t/rasa-x-ora-01430-the-column-being-add-already-exist-in-the-table/20736/1 "2019-10-31T15:11:51Z")

</div>

Hello!

**Rasa version:1.4.0**

**Rasa X version: 0.22.0**

**cx-Oracle: 7.2.2**

Can I use one oracle database for conversations and another for events? Passing endpoints.yml:

```auto
tracker_store:
  type: CustomTrackerStoreOracle

```

In docker-compose:

```auto
environment:
  DB_DRIVER: "oracle"
  DB_USER: "admin" -> different compared to CustomTrackerStoreOracle (user='user') the rest is the same
  DB_PASSWORD: "teste"
  DB_HOST: "localhost"
  DB_PORT: "1521"
  DB_DATABASE: "rasa"

```

For db events the user is ‘user’ and for conversations ‘admin’. I get this error when I run docker container:

```auto
ORA-01430: the column being add already exist in the table

```

In this case, I think that it try to create every time. How can I fix it?

---

<div class="post-metadata">

**Author:** ![DiegoProtec](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/diegoprotec/32/2686_2.png) [@DiegoProtec](https://forum.rasa.com/u/DiegoProtec)\
**Post date:** [October 31, 2019, 6:18pm UTC](https://forum.rasa.com/t/rasa-x-ora-01430-the-column-being-add-already-exist-in-the-table/20736/2 "2019-10-31T18:18:29Z")

</div>

I just need Rasa X to try to connect to the database and not recreate it through a migration. The error occurs as described… 😭

What should I do?

---

<div class="post-metadata">

**Author:** ![erohmensing](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/erohmensing/32/1789_2.png) [@erohmensing](https://forum.rasa.com/u/erohmensing)\
**Post date:** [November 1, 2019, 9:27am UTC](https://forum.rasa.com/t/rasa-x-ora-01430-the-column-being-add-already-exist-in-the-table/20736/3 "2019-11-01T09:27:03Z")

</div>

> I just need Rasa X to try to connect to the database and not recreate it through a migration. The error occurs as described… 😭

What do you mean you need it to already connect? Can you clarify your current setup? The DB and the tracker store are different, it should be creating the database even if there is already things in the tracker store.

---

<div class="post-metadata">

**Author:** ![DiegoProtec](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/diegoprotec/32/2686_2.png) [@DiegoProtec](https://forum.rasa.com/u/DiegoProtec)\
**Post date:** [November 1, 2019, 12:18pm UTC](https://forum.rasa.com/t/rasa-x-ora-01430-the-column-being-add-already-exist-in-the-table/20736/4 "2019-11-01T12:18:42Z")

</div>

I’m testing the migration.py for understand what is happening. When I run in local mode, it work with a little detail:

```auto
AttributeError: 'SQLTrackerStore' object has no attribute 'session'

```

With my oracle database, my “new\_endpoints.yml” is:

```auto
tracker_store:
  type: sql
  dialect: "oracle"
  url: 127.0.0.1
  port: 1521
  username: rasa-x
  password: admin
  db: rasa

```

P.S.: the only difference between conversations and events database is the username!

I receive:

```auto
File "C:\Program Files\Python36\lib\site-packages\sqlalchemy\engine\default.py", line 453, in connect
    return self.dbapi.connect(*cargs, **cparams)
sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-12545: Connect failed because target host or object does not exist

```

On the environments db case, the error occurs as described before.

---

<div class="post-metadata">

**Author:** ![DiegoProtec](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/diegoprotec/32/2686_2.png) [@DiegoProtec](https://forum.rasa.com/u/DiegoProtec)\
**Post date:** [November 4, 2019, 9:06pm UTC](https://forum.rasa.com/t/rasa-x-ora-01430-the-column-being-add-already-exist-in-the-table/20736/7 "2019-11-04T21:06:28Z")

</div>

Finally I managed to run “ **migrate\_tracker\_store\_to\_rasa\_x.py** ”, passing “ **new\_endpoints.yml** ” like this:

```auto
tracker_store:
  type: "sql"
  dialect: oracle
  url: "oracle://admin:teste@127.0.0.1:1521/rasa"

```

But I take this:

```auto
sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-00906: left parenthese not found
[SQL:
CREATE TABLE entity_synonym_value (
        id INTEGER NOT NULL,
        entity_synonym_id INTEGER,
        name VARCHAR2,
        PRIMARY KEY (id),
        FOREIGN KEY(entity_synonym_id) REFERENCES entity_synonym (id) ON DELETE cascade
)

]
(Background on this error at: http://sqlalche.me/e/4xp6)

```

---

<div class="post-metadata">

**Author:** ![Tobias\_Wochinger](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/tobias_wochinger/32/4580_2.png) [@Tobias\_Wochinger](https://forum.rasa.com/u/Tobias_Wochinger)\
**Post date:** [November 5, 2019, 11:00am UTC](https://forum.rasa.com/t/rasa-x-ora-01430-the-column-being-add-already-exist-in-the-table/20736/8 "2019-11-05T11:00:38Z")

</div>

Ha, seems Oracle support for Rasa X is broken. I’ll ship a fix 🙂