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. File
            [FIWARE-JIRA] (HELP-12962) [Coach-Impact].FruitApp.Knowage.DatasetsNotWorkingInAnalyses
            7 kB
            FW External User
          2. Text File
            order_documents.txt
            4 kB
            FW External User
          1. Capture_s8aG4SdfGGphveQmA6Cx.PNG
            171 kB

            Activity

            Descending order - Click to sort in ascending order
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Open In Progress In Progress
            		3h 40m 1 Davide Zerbetto 21/Nov/17 3:14 PM
            In Progress In Progress Answered Answered
            		5m 6s 1 Davide Zerbetto 21/Nov/17 3:19 PM
            Answered Answered Closed Closed
            		16d 2h 15m 1 Davide Zerbetto 07/Dec/17 5:35 PM
            fla Fernando Lopez made changes -
            Fix Version/s 2021 [ 12600 ]
            fla Fernando Lopez made changes -
            Comment [ Comment by jira-help-desk@jira.fiware.org :

            Spam detection software, running on the system "fiware-forge-01", has
            identified this incoming email as possible spam. The original message
            has been attached to this so you can view it (if it isn't spam) or label
            similar future email. If you have any questions, see
            the administrator of that system for details.

            Content preview: [ https://jira.fiware.org/browse/HELP-12962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
               ] FW External User updated HELP-12962: Attachment: [FIWARE-JIRA] (HELP-12962)
               [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job
               Application [...]

            Content analysis details: (6.1 points, 4.5 required)

             pts rule name description
            ---- ---------------------- --------------------------------------------------
             1.7 URIBL_BLACK Contains an URL listed in the URIBL blacklist
                                        [URIs: latedeliver.com]
             2.5 URIBL_DBL_SPAM Contains a spam URL listed in the DBL blocklist
                                        [URIs: latedeliver.com]
             0.0 FSL_HELO_NON_FQDN_1 FSL_HELO_NON_FQDN_1
             3.8 HELO_LOCALHOST HELO_LOCALHOST
            -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1%
                                        [score: 0.0000]

            ]
            fla Fernando Lopez made changes -
            Comment [ Comment by jira-help-desk@jira.fiware.org :

            Spam detection software, running on the system "fiware-forge-01", has
            identified this incoming email as possible spam. The original message
            has been attached to this so you can view it (if it isn't spam) or label
            similar future email. If you have any questions, see
            the administrator of that system for details.

            Content preview: [ https://jira.fiware.org/browse/HELP-12962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
               ] FW External User updated HELP-12962: > [Fiware-general-help] [SPAM] [FIWARE-JIRA]
               (HELP-13082) [SPAM] Website Job Application > > > Key: HELP-12962 > URL:
              https://jira.fiware.org/browse/HELP-12962 > Project: Help-Desk > Issue Type:
               extRequest > Reporter: FW External User > Attachments: [FIWARE-JIRA] (HELP-12962)
               [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job
               Application, [FIWARE-JIRA] (HELP-13082) [Fiware-general-help] [SPAM] Website
               Job Application > > > Spam detection software, running on the system "fiware-forge-01",
               has > identified this incoming email as possible spam. The original message
               > has been attached to this so you can view it (if it isn't spam) or label
               > similar future email. If you have any questions, see > the administrator
               of that system for details. > Content preview: [ https://jira.fiware.org/browse/HELP-13082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
               > ] FW External User updated HELP-13082: > [Fiware-general-help] [SPAM] Website
               > Job Application > > > Key: HELP-13082 > URL: https://jira.fiware.org/browse/HELP-13082
               > > Project: Help-Desk > Issue Type: extRequest > Components: SPAM > Reporter:
               > FW External User > Attachments: [FIWARE-JIRA] (HELP-12876) [Fiware-general-help]
               > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA]
               > (HELP-12877) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM]
               > Website Job Application, [FIWARE-JIRA] (HELP-12878) [Fiware-general-help]
               > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA]
               > (HELP-12879) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM]
               > Website Job Application, [FIWARE-JIRA] (HELP-12880) [Fiware-general-help]
               > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA]
               > (HELP-12881) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM]
               > Website Job Application, [FIWARE-JIRA] (HELP-12882) [Fiware-general-help]
               > [SPAM] [FIWARE-JIRA] [...]

            Content analysis details: (6.9 points, 4.5 required)

             pts rule name description
            ---- ---------------------- --------------------------------------------------
             0.0 FSL_HELO_NON_FQDN_1 FSL_HELO_NON_FQDN_1
             3.8 HELO_LOCALHOST HELO_LOCALHOST
             1.7 URIBL_BLACK Contains an URL listed in the URIBL blacklist
                                        [URIs: latedeliver.com]
             2.5 URIBL_DBL_SPAM Contains a spam URL listed in the DBL blocklist
                                        [URIs: latedeliver.com]
            -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1%
                                        [score: 0.0000]
             0.8 RDNS_NONE Delivered to internal network by a host with no rDNS

            ]
            fla Fernando Lopez made changes -
            Comment [ Comment by jira-help-desk@jira.fiware.org :

            Spam detection software, running on the system "fiware-forge-01", has
            identified this incoming email as possible spam. The original message
            has been attached to this so you can view it (if it isn't spam) or label
            similar future email. If you have any questions, see
            the administrator of that system for details.

            Content preview: [ https://jira.fiware.org/browse/HELP-12962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
               ] FW External User updated HELP-12962: Attachment: [FIWARE-JIRA] (HELP-12962)
               [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job
               Application [...]

            Content analysis details: (6.9 points, 4.5 required)

             pts rule name description
            ---- ---------------------- --------------------------------------------------
             1.7 URIBL_BLACK Contains an URL listed in the URIBL blacklist
                                        [URIs: latedeliver.com]
             2.5 URIBL_DBL_SPAM Contains a spam URL listed in the DBL blocklist
                                        [URIs: latedeliver.com]
             0.0 FSL_HELO_NON_FQDN_1 FSL_HELO_NON_FQDN_1
             3.8 HELO_LOCALHOST HELO_LOCALHOST
            -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1%
                                        [score: 0.0000]
             0.8 RDNS_NONE Delivered to internal network by a host with no rDNS

            ]
            fla Fernando Lopez made changes -
            Comment [ Comment by jira-help-desk@jira.fiware.org :

            Spam detection software, running on the system "fiware-forge-01", has
            identified this incoming email as possible spam. The original message
            has been attached to this so you can view it (if it isn't spam) or label
            similar future email. If you have any questions, see
            the administrator of that system for details.

            Content preview: [ https://jira.fiware.org/browse/HELP-12962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
               ] FW External User updated HELP-12962: > [Fiware-general-help] [SPAM] [FIWARE-JIRA]
               (HELP-13082) [SPAM] Website Job Application > > > Key: HELP-12962 > URL:
              https://jira.fiware.org/browse/HELP-12962 > Project: Help-Desk > Issue Type:
               extRequest > Reporter: FW External User > Attachments: [FIWARE-JIRA] (HELP-13082)
               [Fiware-general-help] [SPAM] Website Job Application > > > Spam detection
               software, running on the system "fiware-forge-01", has > identified this
              incoming email as possible spam. The original message > has been attached
              to this so you can view it (if it isn't spam) or label > similar future email.
               If you have any questions, see > the administrator of that system for details.
               > Content preview: [ https://jira.fiware.org/browse/HELP-13082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
               > ] FW External User updated HELP-13082: > [Fiware-general-help] [SPAM] Website
               > Job Application > > > Key: HELP-13082 > URL: https://jira.fiware.org/browse/HELP-13082
               > > Project: Help-Desk > Issue Type: extRequest > Components: SPAM > Reporter:
               > FW External User > Attachments: [FIWARE-JIRA] (HELP-12876) [Fiware-general-help]
               > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA]
               > (HELP-12877) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM]
               > Website Job Application, [FIWARE-JIRA] (HELP-12878) [Fiware-general-help]
               > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA]
               > (HELP-12879) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM]
               > Website Job Application, [FIWARE-JIRA] (HELP-12880) [Fiware-general-help]
               > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA]
               > (HELP-12881) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM]
               > Website Job Application, [FIWARE-JIRA] (HELP-12882) [Fiware-general-help]
               > [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application, [FIWARE-JIRA]
               > (HELP-12883) [Fiware-general-help] [SPAM] [...]

            Content analysis details: (6.9 points, 4.5 required)

             pts rule name description
            ---- ---------------------- --------------------------------------------------
             1.7 URIBL_BLACK Contains an URL listed in the URIBL blacklist
                                        [URIs: latedeliver.com]
             2.5 URIBL_DBL_SPAM Contains a spam URL listed in the DBL blocklist
                                        [URIs: latedeliver.com]
             0.0 FSL_HELO_NON_FQDN_1 FSL_HELO_NON_FQDN_1
             3.8 HELO_LOCALHOST HELO_LOCALHOST
            -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1%
                                        [score: 0.0000]
             0.8 RDNS_NONE Delivered to internal network by a host with no rDNS

            ]
            fla Fernando Lopez made changes -
            Attachment [FIWARE-JIRA] (HELP-12962) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 60896 ]
            fla Fernando Lopez made changes -
            Attachment [FIWARE-JIRA] (HELP-12962) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 62058 ]
            fla Fernando Lopez made changes -
            Attachment [FIWARE-JIRA] (HELP-12962) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 62059 ]
            fw.ext.user FW External User made changes -
            Attachment [FIWARE-JIRA] (HELP-12962) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 62059 ]
            fw.ext.user FW External User made changes -
            Attachment [FIWARE-JIRA] (HELP-12962) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 62058 ]
            fw.ext.user FW External User made changes -
            Attachment [FIWARE-JIRA] (HELP-12962) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 60896 ]
            zerbetto Davide Zerbetto made changes -
            Resolution Done [ 10000 ]
            Status Answered [ 10104 ] Closed [ 6 ]
            zerbetto Davide Zerbetto made changes -
            Link This issue relates to APP-1637 [ APP-1637 ]
            Hide
            Permalink
            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
            zerbetto Davide Zerbetto made changes -
            Summary [Coach-Impact].FruitApp.KnowAge.DatasetsNotWorkingInAnalyses [Coach-Impact].FruitApp.Knowage.DatasetsNotWorkingInAnalyses
            fw.ext.user FW External User made changes -
            Attachment order_documents.txt [ 60044 ]
            Hide
            Permalink
            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
            Permalink
            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
            fw.ext.user FW External User made changes -
            Attachment knowage-log_HxFcvIV2KUUSISleA1Vt.zip [ 60035 ]
            Attachment Capture_s8aG4SdfGGphveQmA6Cx.PNG [ 60036 ]
            Hide
            Permalink
            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
            Permalink
            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
            Permalink
            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. -
            zerbetto Davide Zerbetto made changes -
            Status In Progress [ 3 ] Answered [ 10104 ]
            Hide
            Permalink
            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
            zerbetto Davide Zerbetto made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            zerbetto Davide Zerbetto made changes -
            Summary [Fiware-tech-help] IMPACT [Coach-Impact].FruitApp.KnowAge.DatasetsNotWorkingInAnalyses
            zerbetto Davide Zerbetto made changes -
            HD-Chapter Apps [ 10836 ]
            HD-Enabler Knowage [ 11200 ]
            zerbetto Davide Zerbetto made changes -
            Assignee Davide Zerbetto [ davide.zerbetto ]
            backlogmanager Backlog Manager made changes -
            Field Original Value New Value
            Component/s FIWARE-TECH-HELP [ 10278 ]
            fw.ext.user FW External User created issue -

              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: