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

        backlogmanager Backlog Manager created issue -
        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
        backlogmanager Backlog Manager made changes -
        Field Original Value New Value
        Component/s FIWARE-TECH-HELP [ 10278 ]
        fla Fernando Lopez made changes -
        HD-Enabler Cepheus [ 10883 ]
        Description
        Created question in FIWARE Q/A platform on 09-02-2017 at 13:02
        {color: red}Please, ANSWER this question AT{color} 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 ?
        Created question in FIWARE Q/A platform on 09-02-2017 at 13:02
        {color: red}Please, ANSWER this question AT{color} 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 ?
        HD-Chapter IoT [ 10839 ]
        fla Fernando Lopez made changes -
        Assignee Gilles Privat [ gprivat ]
        Hide
        cazemar Christophe Azemar added a comment -
        Show
        cazemar Christophe Azemar added a comment - Answered here: http://stackoverflow.com/a/42490209/164251
        cazemar Christophe Azemar made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        cazemar Christophe Azemar made changes -
        Status In Progress [ 3 ] Answered [ 10104 ]
        fla Fernando Lopez made changes -
        Resolution Done [ 10000 ]
        Status Answered [ 10104 ] Closed [ 6 ]
        fla Fernando Lopez made changes -
        Fix Version/s 2021 [ 12600 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        18d 1h 57m 1 Christophe Azemar 27/Feb/17 5:02 PM
        In Progress In Progress Answered Answered
        5s 1 Christophe Azemar 27/Feb/17 5:02 PM
        Answered Answered Closed Closed
        9d 16h 16m 1 Fernando Lopez 09/Mar/17 9:18 AM

          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: