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

[Coach-Impact].FruitApp.Knowage.MongoIssues

    Details

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

      Description

      • I cannot use mongodb with password in a data sets
      • any of my charts are loading
      • when i try to use a document from cvs or query i get the error of " Unable to load data from dataset mongo_orders Please check dataset & widget config"
      1. [FIWARE-JIRA] (HELP-12960) [Coach-Impact].FruitApp.Knowage.MongoIssues
        5 kB
        FW External User
      2. MongoDataProxy.class
        8 kB
        Davide Zerbetto

        Activity

        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

        • Time sent: 21/Nov/17 12:08 PM
        • To: eslem@fruitsapp.com
        • Cc: davide.zerbetto@eng.it
        • with subject: RE: [Coach-Impact].FruitApp.KnowAge.MongoIssues
        • attachment(s): MongoDataProxy.class

        Hi
        in this message I'm going to reply to the question about MongoDB; for the other items that are:

        _
        1. any of my charts are loading
        2. when i try to use a document from cvs or query i get the error of " Unable to load data from dataset mongo_orders Please check dataset & widget config"
        _

        for the issue no. 1, please open a thread on stackoverflow describing the environment, how to reproduce the error and (if possible) details about the error from log files, put "fiware" and "knowage" tags; for the issue no. 2, I saw an email to Fiware-tech-help with subject "IMPACT", is the same as the issue above?

        Regarding MongoDB, please proceed as follows

        1. stop knowage server;
        2. replace attached .class in all occurrences
        of file knowage-utils-6.x.x.jar:
        KNOWAGE_SERVER_HOME/webapps/knowage/WEB-INF/lib/knowage-utils-6.x.x.jar
        KNOWAGE_SERVER_HOME/webapps/knowagecockpitengine/WEB-INF/lib/knowage-utils-6.x.x.jar
        KNOWAGE_SERVER_HOME/webapps/knowageqbeengine/WEB-INF/lib/knowage-utils-6.x.x.jar
        ....
        in all knowage applications; file must be replaced within the package it.eng.spagobi.tools.dataset.common.dataproxy;
        3. start knowage server and retry.
        Please let me know if it works.
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 21/Nov/17 12:08 PM To: eslem@fruitsapp.com Cc: davide.zerbetto@eng.it with subject: RE: [Coach-Impact] .FruitApp.KnowAge.MongoIssues attachment(s): MongoDataProxy.class Hi in this message I'm going to reply to the question about MongoDB; for the other items that are: _ 1. any of my charts are loading 2. when i try to use a document from cvs or query i get the error of " Unable to load data from dataset mongo_orders Please check dataset & widget config" _ for the issue no. 1, please open a thread on stackoverflow describing the environment, how to reproduce the error and (if possible) details about the error from log files, put "fiware" and "knowage" tags; for the issue no. 2, I saw an email to Fiware-tech-help with subject "IMPACT", is the same as the issue above? Regarding MongoDB, please proceed as follows 1. stop knowage server; 2. replace attached .class in all occurrences of file knowage-utils-6.x.x.jar: KNOWAGE_SERVER_HOME/webapps/knowage/WEB-INF/lib/knowage-utils-6.x.x.jar KNOWAGE_SERVER_HOME/webapps/knowagecockpitengine/WEB-INF/lib/knowage-utils-6.x.x.jar KNOWAGE_SERVER_HOME/webapps/knowageqbeengine/WEB-INF/lib/knowage-utils-6.x.x.jar .... in all knowage applications; file must be replaced within the package it.eng.spagobi.tools.dataset.common.dataproxy; 3. start knowage server and retry. Please let me know if it works. Best regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,

        thank you i will try that,

        About the 2, yes i've just updated the knowage server and now any of my datasets are not working.

        Regards.

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, thank you i will try that, About the 2, yes i've just updated the knowage server and now any of my datasets are not working. Regards. -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

        • Time sent: 21/Nov/17 1:23 PM
        • To: eslem@fruitsapp.com
        • with subject: RE: [FIWARE-JIRA] RE: [Coach-Impact].FruitApp.KnowAge.MongoIssues

        Hi
        when you say:

        "About the 2, yes i've just updated the knowage server and now any of my datasets are not working."

        do you mean that updating to Knowage 6.1.1 resolved the issue and that now all charts are displayed properly?

        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 21/Nov/17 1:23 PM To: eslem@fruitsapp.com with subject: RE: [FIWARE-JIRA] RE: [Coach-Impact] .FruitApp.KnowAge.MongoIssues Hi when you say: "About the 2, yes i've just updated the knowage server and now any of my datasets are not working." do you mean that updating to Knowage 6.1.1 resolved the issue and that now all charts are displayed properly? Best regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,

        no, i said that now i can not use any dataset in the documents. i get the same error even with orion ( before this didn't happen ) or any other data set.

        I've attached the logs just in case, the knowage server is a completely new installation.

         
        Regards.

        Eslem Alzate.

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, no, i said that now i can not use any dataset in the documents. i get the same error even with orion ( before this didn't happen ) or any other data set. I've attached the logs just in case, the knowage server is a completely new installation.   Regards. Eslem Alzate. -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

        • Time sent: 22/Nov/17 6:25 AM
        • To: eslem@fruitsapp.com
        • with subject: RE: [Coach-Impact].FruitApp.KnowAge.MongoIssues

        Hi
        let's concentrate with MongoDB access in this issue (we will discuss about other topis in other issues).
        Did you try the solution I suggested? Any update about MongoDB access?
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 22/Nov/17 6:25 AM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.KnowAge.MongoIssues Hi let's concentrate with MongoDB access in this issue (we will discuss about other topis in other issues). Did you try the solution I suggested? Any update about MongoDB access? Best regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,

        Still not working, now i get the error: For input string: "27017/FruitsApp" (i think this error comes from the datasource because the url is $34.248.196.11:27017/FruitsApp:27017/FruitsApp ) the query is exactly the same as a replicated server that i have but without password and this one is working.

        If you want the access the knowage server is in the address http://52.16.21.114:8080/knowage/, <http://52.16.21.114:8080/knowage/,>   the same users as in the demo.

        Regards.

        Eslem Alzate.

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, Still not working, now i get the error: For input string: "27017/FruitsApp" (i think this error comes from the datasource because the url is $34.248.196.11:27017/FruitsApp:27017/FruitsApp ) the query is exactly the same as a replicated server that i have but without password and this one is working. If you want the access the knowage server is in the address http://52.16.21.114:8080/knowage/ , < http://52.16.21.114:8080/knowage/ ,>   the same users as in the demo. Regards. Eslem Alzate. -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

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

        Hi
        could you please send us log files?
        We suspect it depends on MongoDB version. Which MongoDB version are you using? are you querying the Orion Context Broker storage?
        Regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 23/Nov/17 11:31 AM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.KnowAge.MongoIssues Hi could you please send us log files? We suspect it depends on MongoDB version. Which MongoDB version are you using? are you querying the Orion Context Broker storage? Regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,

        the version is the 3.4.10, what you mean querying? i have queries with the rest and works only if i don't have them as persisted, with mongoDB i only can use it if i don't have authentification in the databse.

        Regards.

        Eslem Alzate.

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, the version is the 3.4.10, what you mean querying? i have queries with the rest and works only if i don't have them as persisted, with mongoDB i only can use it if i don't have authentification in the databse. Regards. Eslem Alzate. -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

        • Time sent: 28/Nov/17 3:28 PM
        • To: eslem@fruitsapp.com
        • with subject: RE: [Coach-Impact].FruitApp.KnowAge.MongoIssues

        Hi
        I created a work item for Knowage:

        https://jira.fiware.org/browse/APP-1623

        (I think you cannot see it). That work item is for developing access to MongoDB with credentials. This will be developed next month, we will try to provide you update packages asap.
        I close this issue.
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 28/Nov/17 3:28 PM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.KnowAge.MongoIssues Hi I created a work item for Knowage: https://jira.fiware.org/browse/APP-1623 (I think you cannot see it). That work item is for developing access to MongoDB with credentials. This will be developed next month, we will try to provide you update packages asap. I close this issue. Best regards Davide

          People

          • Assignee:
            zerbetto Davide Zerbetto
            Reporter:
            arigliano Francesco Arigliano
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: