# RASA X Error - Extracting dates using Duckling

**URL:** <https://forum.rasa.com/t/rasa-x-error-extracting-dates-using-duckling/15208>\
**Category:** \[Deprecated\] Rasa X Community Edition\
**Created:** [September 4, 2019, 7:05am UTC](https://forum.rasa.com/t/rasa-x-error-extracting-dates-using-duckling/15208 "2019-09-04T07:05:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SimbaM](https://avatars.discourse-cdn.com/v4/letter/s/f04885/32.png) [@SimbaM](https://forum.rasa.com/u/SimbaM)\
**Post date:** [September 4, 2019, 7:05am UTC](https://forum.rasa.com/t/rasa-x-error-extracting-dates-using-duckling/15208/1 "2019-09-04T07:05:03Z")

</div>

So… I use Duckling to extract dates\period that a user wants to make a reservation. When using RASA X, I get the exception below. Its related to the execution of the SQL statement used to make an entry into the nlu\_training\_data\_entity table. Any suggestions on how this can be fixed??

Exception occurred while handling uri: ‘[http://localhost:5002/api/conversations/0bb2a401409148c2825efd8a64bed046/events](http://localhost:5002/api/conversations/0bb2a401409148c2825efd8a64bed046/events)’ Traceback (most recent call last): File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\base.py”, line 1244, in \_execute\_context cursor, statement, parameters, context File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\default.py”, line 550, in do\_execute cursor.execute(statement, parameters) sqlite3.InterfaceError: Error binding parameter 2 - probably unsupported type.

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

Traceback (most recent call last): File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sanic\app.py”, line 917, in handle\_request response = await response File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\rasax\community\api\decorators.py”, line 176, in decorated\_function return await await\_and\_return\_response(args, kwargs, request) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\rasax\community\api\decorators.py”, line 106, in await\_and\_return\_response response = await response File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\rasax\community\api\decorators.py”, line 46, in decorated\_function return await response File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\rasax\community\api\blueprints\stack.py”, line 255, in post\_event user, config.project\_name, \_event File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\rasax\community\services\data\_service.py”, line 280, in save\_user\_event\_as\_example return self.save\_example(user[“username”], project\_id, example) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\rasax\community\services\data\_service.py”, line 250, in save\_example self.flush() # flush to get the example id File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\rasax\community\database\service.py”, line 31, in flush self.session.flush() File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\session.py”, line 2458, in flush self.\_flush(objects) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\session.py”, line 2596, in \_flush transaction.rollback(\_capture\_exception=True) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\util\langhelpers.py”, line 68, in **exit** compat.reraise(exc\_type, exc\_value, exc\_tb) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\util\compat.py”, line 129, in reraise raise value File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\session.py”, line 2556, in \_flush flush\_context.execute() File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\unitofwork.py”, line 422, in execute rec.execute(self) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\unitofwork.py”, line 589, in execute uow, File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\persistence.py”, line 245, in save\_obj insert, File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\persistence.py”, line 1120, in \_emit\_insert\_statements statement, params File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\base.py”, line 988, in execute return meth(self, multiparams, params) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\sql\elements.py”, line 287, in \_execute\_on\_connection return connection.\_execute\_clauseelement(self, multiparams, params) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\base.py”, line 1107, in \_execute\_clauseelement distilled\_params, File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\base.py”, line 1248, in \_execute\_context e, statement, parameters, cursor, context File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\base.py”, line 1466, in \_handle\_dbapi\_exception util.raise\_from\_cause(sqlalchemy\_exception, exc\_info) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\util\compat.py”, line 383, in raise\_from\_cause reraise(type(exception), exception, tb=exc\_tb, cause=cause) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\util\compat.py”, line 128, in reraise raise value.with\_traceback(tb) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\base.py”, line 1244, in \_execute\_context cursor, statement, parameters, context File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\default.py”, line 550, in do\_execute cursor.execute(statement, parameters) sqlalchemy.exc.InterfaceError: (sqlite3.InterfaceError) Error binding parameter 2 - probably unsupported type. [SQL: INSERT INTO nlu\_training\_data\_entity (example\_id, entity, value, start, “end”, extractor) VALUES (?, ?, ?, ?, ?, ?)] [parameters: (209, ‘time’, {‘to’: ‘2019-10-10T00:00:00.000-07:00’, ‘from’: ‘2019-10-02T00:00:00.000-07:00’}, 29, 51, ‘DucklingHTTPExtractor’)] (Background on this error at: [http://sqlalche.me/e/rvf5](http://sqlalche.me/e/rvf5)) Exception occurred in one of response middleware handlers Traceback (most recent call last): File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sanic\app.py”, line 958, in handle\_request request, response File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\spf\framework.py”, line 535, in \_run\_response\_middleware \_response = await \_response File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\rasax\community\database\utils.py”, line 125, in remove\_session db\_session.commit() File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\session.py”, line 1026, in commit self.transaction.commit() File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\session.py”, line 491, in commit self.\_assert\_active(prepared\_ok=True) File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\orm\session.py”, line 294, in \_assert\_active % self.\_rollback\_exception sqlalchemy.exc.InvalidRequestError: This Session’s transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.InterfaceError) Error binding parameter 2 - probably unsupported type. [SQL: INSERT INTO nlu\_training\_data\_entity (example\_id, entity, value, start, “end”, extractor) VALUES (?, ?, ?, ?, ?, ?)] [parameters: (209, ‘time’, {‘to’: ‘2019-10-10T00:00:00.000-07:00’, ‘from’: ‘2019-10-02T00:00:00.000-07:00’}, 29, 51, ‘DucklingHTTPExtractor’)] (Background on this error at: [http://sqlalche.me/e/rvf5](http://sqlalche.me/e/rvf5)) Exception occurred while handling uri: ‘[http://localhost:5002/api/conversations/0bb2a401409148c2825efd8a64bed046/events](http://localhost:5002/api/conversations/0bb2a401409148c2825efd8a64bed046/events)’ Traceback (most recent call last): File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\base.py”, line 1244, in \_execute\_context cursor, statement, parameters, context File “c:\users\user1\appdata\local\continuum\anaconda3\envs\botv6\lib\site-packages\sqlalchemy\engine\default.py”, line 550, in do\_execute cursor.execute(statement, parameters) sqlite3.InterfaceError: Error binding parameter 2 - probably unsupported type.

---

<div class="post-metadata">

**Author:** ![himanshus97](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/himanshus97/32/5425_2.png) [@himanshus97](https://forum.rasa.com/u/himanshus97)\
**Post date:** [November 12, 2019, 12:33pm UTC](https://forum.rasa.com/t/rasa-x-error-extracting-dates-using-duckling/15208/2 "2019-11-12T12:33:39Z")

</div>

I’ve Got same error while using duckling server.