jfernandz
commented
4 years ago Well, apparently it was my fault and the docker-compose.yml file was not deploying properly mongodb and orioncb so they cannot connect between them. However, ... now I'm able to create an entity through a POST request to the IoTagent-LoRaWAN when I create a device, also I'm able to create the subscription sending this body in another POST request to orioncb
{
"description": "A subscription to get info about LORA-N-0",
"subject": {
"entities": [
{
"id": "LORA-N-0",
"type": "LoraDevice"
}
],
"condition": {
"attrs": [
"analog_in_1"
]
}
},
"notification": {
"http": {
"url": "http://quantumleap:8668/v2/notify"
},
"attrs": [
"analog_in_1"
],
"metadata": ["dateCreated", "dateModified"]
},
"throttling": 5
}As you can see in the picture the subscription is apparently created correctly
However ... also as you can see in the picture ... QuantumLeap is throwing the following exception with its corresponding traceback
quantumleap_1 | INFO:reporter.reporter:Received payload: {'id': 'LORA-N-0', 'type': 'LoraDevice', 'analog_in_1': {'type': 'Number', 'value': 96.64, 'metadata': {'dateCreated': {'type': 'DateTime', 'value': '2020-06-25T08:36:55.00Z'}, 'dateModified': {'type': 'DateTime', 'value': '2020-06-25T09:21:41.00Z'}}}}
quantumleap_1 | INFO:geocoding.geocoding:Cannot add location to entity (type: "LoraDevice", id: "LORA-N-0"), missing "address" attribute.
quantumleap_1 | [2020-06-25 09:21:41,652] ERROR in app: Exception on /v2/notify [POST]
quantumleap_1 | Traceback (most recent call last):
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app
quantumleap_1 | response = self.full_dispatch_request()
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1614, in full_dispatch_request
quantumleap_1 | rv = self.handle_user_exception(e)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1517, in handle_user_exception
quantumleap_1 | reraise(exc_type, exc_value, tb)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise
quantumleap_1 | raise value
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1612, in full_dispatch_request
quantumleap_1 | rv = self.dispatch_request()
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1598, in dispatch_request
quantumleap_1 | return self.view_functions[rule.endpoint](**req.view_args)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/connexion/decorators/decorator.py", line 73, in wrapper
quantumleap_1 | response = function(request)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/connexion/decorators/uri_parsing.py", line 117, in wrapper
quantumleap_1 | response = function(request)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/connexion/decorators/validation.py", line 163, in wrapper
quantumleap_1 | response = function(request)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/connexion/decorators/validation.py", line 336, in wrapper
quantumleap_1 | return function(request)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/connexion/decorators/decorator.py", line 44, in wrapper
quantumleap_1 | response = function(request)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/connexion/decorators/parameter.py", line 207, in wrapper
quantumleap_1 | return function(**kwargs)
quantumleap_1 | File "/src/ngsi-timeseries-api/src/reporter/reporter.py", line 179, in notify
quantumleap_1 | trans.insert([payload], fiware_s, fiware_sp)
quantumleap_1 | File "/src/ngsi-timeseries-api/src/translators/crate.py", line 183, in insert
quantumleap_1 | fiware_servicepath)
quantumleap_1 | File "/src/ngsi-timeseries-api/src/translators/crate.py", line 260, in _insert_entities_of_type
quantumleap_1 | self._update_metadata_table(table_name, original_attrs)
quantumleap_1 | File "/src/ngsi-timeseries-api/src/translators/crate.py", line 352, in _update_metadata_table
quantumleap_1 | self.cursor.execute(stmt, (table_name, persisted_metadata))
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/crate/client/cursor.py", line 54, in execute
quantumleap_1 | bulk_parameters)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/crate/client/http.py", line 328, in sql
quantumleap_1 | content = self._json_request('POST', self.path, data=data)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/crate/client/http.py", line 448, in _json_request
quantumleap_1 | _raise_for_status(response)
quantumleap_1 | File "/usr/local/lib/python3.6/site-packages/crate/client/http.py", line 187, in _raise_for_status
quantumleap_1 | error_trace=error_trace)
quantumleap_1 | crate.client.exceptions.ProgrammingError: SQLActionException[SQLParseException: line 1:72: no viable alternative at input 'on duplicate']
quantumleap_1 | 172.24.0.6 - - [25/Jun/2020 09:21:41] "POST /v2/notify HTTP/1.1" 500 -
quantumleap_1 | INFO:werkzeug:172.24.0.6 - - [25/Jun/2020 09:21:41] "POST /v2/notify HTTP/1.1" 500 -Here is also my docker-compose.yml Is it maybe the QuantumLeap version? :thinking:
I don't know if I'm doing something wrong or this is caused by QuantumLeap itself but ... I don't like that
quantumleap_1 | [2020-06-25 09:21:41,652] ERROR in app: Exception on /v2/notify [POST]
What do you think?
c0c0n3
Describe the bug I'm not sure if this is a bug or I am doing something wrong.
To Reproduce Steps to reproduce the behavior:
"level":"error","message":"Could not cast message to NGSI"error message in the logs despite all containers are working as expected. Also I'm not sure how OrionCB, IoTagent-LoRaWAN and QuantumLeap interact between them; according to their docs I have to create a subscription in order to OrionCB notifies QuantumLeap to store the information in CrateDB but ... Should not I first create an entity attached to the IoTagent-LoRaWAN device that I've previously created?Expected behavior POST request to
http://localhost:8668/v2/subscribe?orionUrl=http://localhost:1026/v2&quantumleapUrl=http://localhost:8668/v2returns a200 OKcode (?)Environment (please complete the following information):
0.5.0; OrionCB version is2.4.0-nextand IoTagent-LoRaWAN version is2.10.0-nextAdditional context I'll provide in followin answers if necessary
Sorry if this is not the right place to ask this kind of things but I did also a question in StackOverflow but I'm not sure this will be answered