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

[Coach-Impact].FruitApp.Knowage.DatasetsNotWorkingInAnalyses

    Details

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

      Description

      Knowage is not able to use data sets in documents (Cockpit or Generic Document):

      When i try to use my data sets (any of them), in the Cockpit when i load the document, i get the error:

      "Unable to load data from dataset orion_navigation
      Please check dataset & widget config".

       
      If i try to use it in a chart i don't get any error but the documment is empty.

       
      I have different datasets, restapi or mongodb query, and when i click preview in the data sets are correct.

      The knowage server is in a EC2 AWS instance, the insance is running Ubuntu 16.03.3. I've installed the knowage using the installer for unix: 'Knowge-6_1_1-CE'

      By the way, i get redirected in localhost so i use the script of the docker repository to change it to the public address:

      "
      sed -i "s|http:\/\/.*:8080|http:\/\/$

      {PUBLIC_ADDRESS}:8080|g" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/conf/server.xml
      sed -i "s|http:\/\/.*:8080\/knowage|http:\/\/localhost:8080\/knowage|g" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/conf/server.xml

      sed -i "s|http:\/\/localhost:8080|http:\/\/${PUBLIC_ADDRESS}

      :8080|g" $

      {KNOWAGE_DIRECTORY}

      /$

      {APACHE_TOMCAT_PACKAGE}

      /webapps/knowage/WEB-INF/web.xml

      "
       
      Regards.

      Eslem Alzate.

       

      __________________________________________________________________________________________

      You can get more information about our cookies and privacy policies on the following links:

      Fiware-tech-help mailing list
      Fiware-tech-help@lists.fiware.org
      https://lists.fiware.org/listinfo/fiware-tech-help

      [Created via e-mail received from: =?UTF-8?Q?FruitsApp?= <eslem@fruitsapp.com>]

      1. [FIWARE-JIRA] (HELP-12962) [Coach-Impact].FruitApp.Knowage.DatasetsNotWorkingInAnalyses
        7 kB
        FW External User
      2. order_documents.txt
        4 kB
        FW External User
      1. Capture_s8aG4SdfGGphveQmA6Cx.PNG
        171 kB

        Activity

        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

        • Time sent: 21/Nov/17 3:19 PM
        • To: eslem@fruitsapp.com
        • Cc: davide.zerbetto@eng.it
        • with subject: RE: [Coach-Impact].FruitApp.KnowAge.DatasetsNotWorkingInAnalyses

        Hi
        looking at log file you attached in issue https://jira.fiware.org/browse/HELP-12960 I see that the data source for orion_navigation dataset is wrong: it is querying the foodmart_demo MySQL database (the one provided by knowage installer for demo analyses), instead of your database.
        Please fix it and retry.
        Regarding redirection to localhost, the only configuration you have to perform is setting host_url as described here:
        https://knowage.readthedocs.io/en/latest/admin/README/index.html#installation-from-released-package
        Hope this helps
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 21/Nov/17 3:19 PM To: eslem@fruitsapp.com Cc: davide.zerbetto@eng.it with subject: RE: [Coach-Impact] .FruitApp.KnowAge.DatasetsNotWorkingInAnalyses Hi looking at log file you attached in issue https://jira.fiware.org/browse/HELP-12960 I see that the data source for orion_navigation dataset is wrong: it is querying the foodmart_demo MySQL database (the one provided by knowage installer for demo analyses), instead of your database. Please fix it and retry. Regarding redirection to localhost, the only configuration you have to perform is setting host_url as described here: https://knowage.readthedocs.io/en/latest/admin/README/index.html#installation-from-released-package Hope this helps Best regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,

        i saw that but the data set is a REST type, so is not connected to any datasource, the same with the file type, and the query type is well connected to the mongodb data source.

        Regards.

        Eslem Alzate.

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, i saw that but the data set is a REST type, so is not connected to any datasource, the same with the file type, and the query type is well connected to the mongodb data source. Regards. Eslem Alzate. -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

        • Time sent: 22/Nov/17 2:58 PM
        • To: eslem@fruitsapp.com
        • with subject: RE: [Coach-Impact].FruitApp.KnowAge.DatasetsNotWorkingInAnalyses

        Hi
        please let's try to simplify and concentrate on just one dataset, in particular the MongoDB dataset.
        Please proceed as follows:
        1. stop knowage server;
        2. delete all log files (in knowage_server_home/logs);
        3. restart knowage;
        4. enter knowage, enter the MongoDB datasource, then enter the dataset and test it (please send me some screenshots with datasource, dataset definition and its preview);
        5. try to define a cockpit with a simple table that shows content from the MongoDB dataset (please send me other screenshots);
        6. at this point, send log files to me with the screenshots.
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 22/Nov/17 2:58 PM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.KnowAge.DatasetsNotWorkingInAnalyses Hi please let's try to simplify and concentrate on just one dataset, in particular the MongoDB dataset. Please proceed as follows: 1. stop knowage server; 2. delete all log files (in knowage_server_home/logs); 3. restart knowage; 4. enter knowage, enter the MongoDB datasource, then enter the dataset and test it (please send me some screenshots with datasource, dataset definition and its preview); 5. try to define a cockpit with a simple table that shows content from the MongoDB dataset (please send me other screenshots); 6. at this point, send log files to me with the screenshots. Best regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi

        attached the capture and the logs.

        Regards.

        Eslem Alzate

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi attached the capture and the logs. Regards. Eslem Alzate -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

        • Time sent: 23/Nov/17 11:27 AM
        • To: eslem@fruitsapp.com
        • with subject: RE: [Coach-Impact].FruitApp.KnowAge.DatasetsNotWorkingInAnalyses

        Hi
        could you please send us a MongoDB document (a short JSON file) to replicate the issue?
        Regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 23/Nov/17 11:27 AM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.KnowAge.DatasetsNotWorkingInAnalyses Hi could you please send us a MongoDB document (a short JSON file) to replicate the issue? Regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,

        Attached, its a normal MongoDB document, but also with a cvs or i put as persited the datasets i have the same problem.

        Regards.

        Eslem Alzate.

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, Attached, its a normal MongoDB document, but also with a cvs or i put as persited the datasets i have the same problem. Regards. Eslem Alzate. -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

        • Time sent: 07/Dec/17 5:34 PM
        • To: eslem@fruitsapp.com
        • with subject: RE: [Coach-Impact].FruitApp.Knowage.DatasetsNotWorkingInAnalyses

        Dear Eslem
        we investigated the issue and found that there is another bug. I created an issue for it : https://jira.fiware.org/browse/APP-1637
        We already started fixing it.
        I'll close this issue.
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 07/Dec/17 5:34 PM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.Knowage.DatasetsNotWorkingInAnalyses Dear Eslem we investigated the issue and found that there is another bug. I created an issue for it : https://jira.fiware.org/browse/APP-1637 We already started fixing it. I'll close this issue. Best regards Davide

          People

          • Assignee:
            zerbetto Davide Zerbetto
            Reporter:
            fw.ext.user FW External User
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: