Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-8248

[fiware-stackoverflow] Error on sending configuration file to fiware cepheus cep GE

    Details

    • Type: Monitor
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 2021
    • Component/s: FIWARE-TECH-HELP
    • Labels:

      Description

      Created question in FIWARE Q/A platform on 09-02-2017 at 13:02
      Please, ANSWER this question AT http://stackoverflow.com/questions/42136804/error-on-sending-configuration-file-to-fiware-cepheus-cep-ge

      Question:
      Error on sending configuration file to fiware cepheus cep GE

      Description:
      I've encountered a problem while using cepheus cep Fiware component . I prepared the config.json file setting the structure of incoming and outcome data as well as the Esper SQL statements which should process the incoming data and generate the output data with the preset structure in the configuration. i want to send updates to the Cepheus with Sensor motion data telling whether somebody entered the room (sending 1) or somebody left the room (sends -1) and then sum the motion incoming value with the previous number of people in the room to see if there're people remaining in the room . and this the json configuration file that i've made till now .

      {
      "host":"http://localhost:8080",
      "in":[
      {
      "id":"Lab.*",
      "type":"Lab",
      "isPattern": true,
      "attributes":[
      { "name":"motion", "type":"integer","metadata": [

      { "name":"unit", "type":"string" }

      ] }
      ,

      { "name":"controller", "type":"string"}

      ],

      "providers":[
      "http://localhost:8081"
      ]
      }
      ],

      "out":[
      {
      "id":"ControllerX",
      "type":"Controller",
      "attributes":[

      { "name":"number", "type":"integer" }

      ]
      ,

      "brokers":[

      { "url":"http://147.27.60.58:1026" }

      ]
      }
      ],
      "statements":[ "INSERT INTO Controller SELECT controller as id , motion prev(count+number) as number From Lab.win:keepall() INNER JOIN Controller.win:keepall() ON controller = id

      "

      ]

      as the file shows , the statement generates output event after getting the previous number of people from the last output event and sum it with the motion input (1 or -1) to get the people number of the new output event but when i send the config.json file i get this error :

      {"code":"400","reasonPhrase":"Failed to apply new configuration","details":"Error starting statement: Failed to validate select-clause expression 'motion+number': Implicit conversion from datatype 'Object' to numeric is not allowed [insert into Controller select controller as id, motion+number as number from Lab.win:keepall() inner outer join Controller.std:lastevent() on controller = id]"}

      does this error mean that the summed values are recognized as objects not integers ? and if so ,how could it be solved ?

        Activity

        Hide
        backlogmanager Backlog Manager added a comment -

        2017-02-09 15:05|CREATED monitor | # answers= 0, accepted answer= False

        Show
        backlogmanager Backlog Manager added a comment - 2017-02-09 15:05|CREATED monitor | # answers= 0, accepted answer= False
        Hide
        cazemar Christophe Azemar added a comment -
        Show
        cazemar Christophe Azemar added a comment - Answered here: http://stackoverflow.com/a/42490209/164251

          People

          • Assignee:
            gprivat Gilles Privat
            Reporter:
            backlogmanager Backlog Manager
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: