SQLTracker store not sending the id value when populating events table

Getting Started with Rasa
1

Hi,

I am using the sqltrackerstore for storing the trackers. RASA can connect to my database, it is creating the events table but the value for the id column sent by RASA core is null always.

I checked the code in the rasa/core/brokers/sql.py from where the SQL call is made to sqlalchemy and the id column is not being sent when the actual SQL call is made. I have attached the code snippet below.

I am getting an oracle error that cannot insert null into the Id column.

image
image1312×1276 308 KB

2

Oracle is not supported for the Rasa SQLTrackerStore. It can be used for the Rasa X database but this is a separate database. There is a discussion here