Rasa integrity error

Rasa Open Source
1 
WARNING:rasax.community.services.event_consumers.event_consumer:Saving event failed due to an 'IntegrityError'. This means that the event is already stored in the database. The event data was '{"sender_id": "7a0ed18f1de84b6494bf84092ecbd5c2", "event": "action", "timestamp": 1652096491.9714603, "name": "action_listen", "policy": "policy_0_MemoizationPolicy", "confidence": 1.0, "action_text": null, "hide_rule_turn": false}'. (sqlite3.IntegrityError) UNIQUE constraint failed: conversation_event.conversation_id, conversation_event.timestamp, conversation_event.type_name
[SQL: INSERT INTO conversation_event (conversation_id, type_name, timestamp, intent_name, action_name, slot_name, slot_value, policy, is_flagged, data, evaluation, rasa_environment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: ('7a0ed18f1de84b6494bf84092ecbd5c2', 'action', 1652096491.9714603, None, 'action_listen', None, None, 'MemoizationPolicy', 0, '{"sender_id": "7a0ed18f1de84b6494bf84092ecbd5c2", "event": "action", "timestamp": 1652096491.9714603, "name": "action_listen", "policy": "policy_0_MemoizationPolicy", "confidence": 1.0, "action_text": null, "hide_rule_turn": false}', None, 'production')]
(Background on this error at: http://sqlalche.me/e/13/gkpj)

I’m getting this error when ever i try to talk to my bot. Also on sharing my bot response is not displaying for an input until i refresh the page,

2

I’m guessing this could be a db config issue. Are you using your own SQL db? Have you tried using the default Postgres or MongoDB tracker store config?

3

@stephens I’m using local MSSQL database but with accessing db or without accessing db error is same. When i send an input to rasa x. Means when i send input as “hello” to chatbot in rasa x same error is shown every time in cli.

4

I don’t have experience with MSSQL as a tracker store but you’re problem is related to the db. What is your endpoints.yml config for the tracker store?

I would research sqlalchemy issues with MSSQL. The error you’re getting says points to Error Messages — SQLAlchemy 1.3 Documentation which says:

This error is a DBAPI Error and originates from the database driver (DBAPI), not SQLAlchemy itself.

Better yet, use Postgres or Mongo.

5

@stephens But i have requirement of using MSSQL