How to access stored bot conversation from tracker and also how to store that in SQL Server?

Rasa Open Source
1

I’m trying to get tracker data but tracker isn’t responding , latest_message also not woking , i want to know why tracker is not able to give that store data . If somebody knows how can I get the stored data please help with proper step by step guidance . And also how to store, conversation data in SQL Server , what changes need to be done in rasa repositories other than mentioning in endpoint.yml file.

2

Hi @pranali05-ai , You need to provide the SQL tracker details to save your tracker details to SQL DB. Please have a look at Tracker Stores

3

Hey @anoopshrma , It’s not that simple to do, I assumed you are talking about uncommenting trackerstore in endpoints and put all the details and it will be connected, but no this is not happening, that’s why i raised an issue , i think some more changes need to be done for connection and letting chatbot conversation stored into Microsoft SQL Server. So if u could help with that it would be nice, and also can we get InMemoryTrackerStore data , if yes then please tell how?

4

Hi @pranali05-ai ,

For that to inspect you need to share the error that you are facing, So that we get a better idea at the issue.

5

Hey @anoopshrma, Can you please first tell can I get conversation data path stored in InMemoryTrackerStore, if yes then please tell how?

6

Hey @anoopshrma ,

here is the error I’m getting :-

SADeprecationWarning: Calling URL() directly is deprecated and will be disabled in a future release. The public constructor for URL is now the URL.create() method. return sa.engine.url.URL( ERROR rasa.core.tracker_store - Could not create tables: (pymssql._pymssql.OperationalError) (20009, b’DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (50)\n’) (Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)

this is the endpoint.yml I used:-

tracker_store: type: SQL dialect: “mssql+pymssql” server: " ABC" db: “ABC” username: “ABC” password: “ABC”

7

@pranali05-ai there is no direct way in my opinion for in memory tracker store. I would suggest that you create a action method and try to log the tracker info as much as you can. You can check what are the items in the tracker object , iterate over them and then log it with you. This is the work around that I could think of.

8

What is the Rasa version that you are using right now? Did you check for this issue on stackoverflow or some place else?

9

Rasa Version : 3.5.5 Minimum Compatible Version: 3.5.0 Rasa SDK Version : 3.5.1 Python Version : 3.8.10 Operating System : Windows-10-10.0.19045-SP0

yes I did check that but nothing relevant I got.

10

have you started your web server, if not try xampp and you are missing url variable too

tracker_store:
    type: SQL
    dialect: "mysql+pymysql"
    url: "localhost"
    db: "db_name"
    username: "username"
    password: "password"