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

        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
        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.   -
        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
        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 -

          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: