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

[Coach-Impact].FruitApp.Knowage.ServerError

    Details

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

      Description

      If i don't restart the server every day i get an error when i login

      1. [FIWARE-JIRA] (HELP-12952) [Coach-Impact].FruitApp.Knowage.ServerError
        5 kB
        FW External User

        Activity

        arigliano Francesco Arigliano created issue -
        Hide
        arigliano Francesco Arigliano added a comment -

        Hi Eslem,

        please provide us with more details,
        first of all: the error message you receive.
        the version of the modules. Deployment information and Logfile if available

        Thanks

        Show
        arigliano Francesco Arigliano added a comment - Hi Eslem, please provide us with more details, first of all: the error message you receive. the version of the modules. Deployment information and Logfile if available Thanks
        arigliano Francesco Arigliano made changes -
        Field Original Value New Value
        Status Open [ 1 ] In Progress [ 3 ]
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi Francesco:

        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_0-CE'

         
        The error i get only appear when i try to login with a demo account and the error that appear is: 'An error has occurred. Retry later.
        If the problems persists, contact the system administrator.'

        I've attached the logs folder of the knowage server.

        Regards.

         
        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi Francesco: 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_0-CE'   The error i get only appear when i try to login with a demo account and the error that appear is: 'An error has occurred. Retry later. If the problems persists, contact the system administrator.' I've attached the logs folder of the knowage server. Regards.   -
        fw.ext.user FW External User made changes -
        arigliano Francesco Arigliano made changes -
        Assignee Francesco Arigliano [ arigliano ] Davide Zerbetto [ davide.zerbetto ]
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

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

        Hi
        please follow these steps:
        1. stop knowage server;
        2. edit knowage_server_home/conf/server.xml and modify all datasources' definition in order to add other connection parameters:
        <Resource auth="Container" driverClassName=".....JDBC driver...."
        name=".....connection name...."
        type="javax.sql.DataSource"
        url=".........JDBC URL...."
        username=".........username........." password="....password....."
        maxWait="-1"
        maxActive="20" maxIdle="4" validationQuery=".....A VALID STATEMENT FOR THAT DATASOURCE...."
        removeAbandoned="true" removeAbandonedTimeout="3600" logAbandoned="true" testOnReturn="true"
        testWhileIdle="true" timeBetweenEvictionRunsMillis="10000" minEvictableIdleTimeMillis="60000"
        />
        For Knowage metadata, a valid statement is "SELECT * FROM SBI_DOMAINS" or any other SBI_* table;
        3. restart knowage server.
        Please let me know if this solve the issue.
        Please be aware that we released also knowage 6.1.1 with some bug fixes that may help you.
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 21/Nov/17 6:56 AM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.KnowAge.ServerError Hi please follow these steps: 1. stop knowage server; 2. edit knowage_server_home/conf/server.xml and modify all datasources' definition in order to add other connection parameters: <Resource auth="Container" driverClassName=".....JDBC driver...." name=".....connection name...." type="javax.sql.DataSource" url=".........JDBC URL...." username=".........username........." password="....password....." maxWait="-1" maxActive="20" maxIdle="4" validationQuery=".....A VALID STATEMENT FOR THAT DATASOURCE...." removeAbandoned="true" removeAbandonedTimeout="3600" logAbandoned="true" testOnReturn="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000" minEvictableIdleTimeMillis="60000" /> For Knowage metadata, a valid statement is "SELECT * FROM SBI_DOMAINS" or any other SBI_* table; 3. restart knowage server. Please let me know if this solve the issue. Please be aware that we released also knowage 6.1.1 with some bug fixes that may help you. Best regards Davide
        zerbetto Davide Zerbetto made changes -
        Status In Progress [ 3 ] Answered [ 10104 ]
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,

        Thank you very much, for now is working but i will try with the new version.

        Regards.

        Eslem Alzate.

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, Thank you very much, for now is working but i will try with the new version. Regards. Eslem Alzate. -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

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

        Hi
        did you try the solution I suggested? Any update?
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 22/Nov/17 6:21 AM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.KnowAge.ServerError Hi did you try the solution I suggested? Any update? Best regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,
        for now is working properly after i installed the new version.
        Regards.
        Eslem Alzate

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, for now is working properly after i installed the new version. Regards. Eslem Alzate -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

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

        Hi
        please apply the configuration I sent you, wait for tomorrow morning and then try again.
        Please let me know.
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 22/Nov/17 12:49 PM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.KnowAge.ServerError Hi please apply the configuration I sent you, wait for tomorrow morning and then try again. Please let me know. Best regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,

        tomorrow i will let you know if this persirst.

        Regards.

        Eslem Alzate.

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, tomorrow i will let you know if this persirst. Regards. Eslem Alzate. -
        Hide
        zerbetto Davide Zerbetto added a comment -

        The issue has been emailed:

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

        Hi
        any news about this issue?
        Regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - The issue has been emailed: Time sent: 23/Nov/17 11:24 AM To: eslem@fruitsapp.com with subject: RE: [Coach-Impact] .FruitApp.KnowAge.ServerError Hi any news about this issue? Regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        Comment by eslem@fruitsapp.com :

        Hi,

        for now everything is working, thank you very much.

        Regards.

        Eslem Alzate

        -

        Show
        fw.ext.user FW External User added a comment - Comment by eslem@fruitsapp.com : Hi, for now everything is working, thank you very much. Regards. Eslem Alzate -
        zerbetto Davide Zerbetto made changes -
        Resolution Done [ 10000 ]
        Status Answered [ 10104 ] Closed [ 6 ]
        zerbetto Davide Zerbetto made changes -
        Summary [Coach-Impact].FruitApp.KnowAge.ServerError [Coach-Impact].FruitApp.Knowage.ServerError
        fw.ext.user FW External User made changes -
        Attachment [FIWARE-JIRA] (HELP-12952) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 60807 ]
        fw.ext.user FW External User made changes -
        Attachment [FIWARE-JIRA] (HELP-12952) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 61819 ]
        fw.ext.user FW External User made changes -
        Attachment [FIWARE-JIRA] (HELP-12952) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 61821 ]
        fla Fernando Lopez made changes -
        Attachment [FIWARE-JIRA] (HELP-12952) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 61821 ]
        fla Fernando Lopez made changes -
        Attachment [FIWARE-JIRA] (HELP-12952) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 61819 ]
        fla Fernando Lopez made changes -
        Attachment [FIWARE-JIRA] (HELP-12952) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 60807 ]
        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-12952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
           ] FW External User updated HELP-12952: > [Fiware-general-help] [SPAM] [FIWARE-JIRA]
           (HELP-13082) [SPAM] Website Job Application > > > Key: HELP-12952 > URL:
          https://jira.fiware.org/browse/HELP-12952 > 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 -
        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-12952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
           ] FW External User updated HELP-12952: Attachment: [FIWARE-JIRA] (HELP-12952)
           [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
        ---- ---------------------- --------------------------------------------------
         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-12952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
           ] FW External User updated HELP-12952: > [Fiware-general-help] [SPAM] [FIWARE-JIRA]
           (HELP-13082) [SPAM] Website Job Application > > > Key: HELP-12952 > URL:
          https://jira.fiware.org/browse/HELP-12952 > Project: Help-Desk > Issue Type:
           extRequest > Reporter: FW External User > Attachments: [FIWARE-JIRA] (HELP-12952)
           [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
        ---- ---------------------- --------------------------------------------------
         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-12952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
           ] FW External User updated HELP-12952: Attachment: [FIWARE-JIRA] (HELP-12952)
           [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 -
        HD-Enabler Knowage [ 11200 ] SpagoBI [ 10856 ]
        HD-Chapter Apps [ 10836 ]
        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
        35m 51s 1 Francesco Arigliano 20/Nov/17 8:41 AM
        In Progress In Progress Answered Answered
        22h 15m 1 Davide Zerbetto 21/Nov/17 6:56 AM
        Answered Answered Closed Closed
        2d 23h 30m 1 Davide Zerbetto 24/Nov/17 6:26 AM

          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: