HighPerf Downtime

    Error: java.sql.SQLNonTransientConnectionException: Login failure: invalid username/password.

    1. Please verify the given username & password is correct in Settings -> NetFlow -> HighPerf Reporting Engine
    2. If you have changed the system password recently, please update the password in Settings -> NetFlow -> HighPerf Reporting Engine

    Error: java.sql.SQLNonTransientConnectionException: Communications error while establishing connection.

    This error occurs when NetFlow is unable to communicate with Highperf Reporting Engine.

    Please follow the appropriate step based on OS & HighPerf installation type.

    1. Windows (HighPerf Local installation).
      • Stop the NetFlow service.
      • Open a command prompt with Administrator privilege.
      • Navigate to <OpManager_Home>\bin directory.
      • Execute VWstopdb.bat. This may take few minutes.
      • Start the NetFlow service and wait for 5 minutes and verify Highperf Reporting Engine status is Online in Settings -> NetFlow -> HighPerf Reporting Engine.
    2. Windows (HighPerf Remote Installation):
      • Stop the NetFlow service.
      • Open a command prompt with Administrator privilege.
      • Navigate to <OpManager_Home>\bin directory.
      • Execute VWstopdb.bat to stop the HighPerf client.
      • Connect to the HighPerf Server System.
        • Open a command prompt with Administrator privilege.
        • Navigate to <OpManager_Home>\HighPerfReportingEngine.
        • Execute VWstopdb.bat to stop the HighPerf. This may take few minutes.
        • Execute VWstartdb.bat to start the HighPerf.
      • Start the NetFlow service and wait for 5 minutes and verify Highperf Reporting Engine status is Online in Settings -> NetFlow -> HighPerf Reporting Engine.
    3. Linux (HighPerf Local Installation):
      • Stop the NetFlow service.
      • Open a terminal and login as installation owner.
      • Navigate to <OpManager_Home>\bin directory.
      • Execute sh VWstopdb.sh to stop the HighPerf. This may take few minutes.
      • Start the NetFlow service and wait for 5 minutes and verify Highperf Reporting Engine status is Online in Settings -> NetFlow -> HighPerf Reporting Engine.
    4. Linux (HighPerf Remote Installation):
      • Stop the NetFlow service.
      • Open a terminal and login as installation owner.
      • Navigate to <OpManager_Home>\bin directory.
      • Execute sh VWstopdb.sh to stop the HighPerf client.
      • Connect to the HighPerf Server system.
        • Open a terminal and login as installation owner.
        • Navigate to <OpManager_Home>\Actian directory.
        • Execute sh VWstopdb.sh to stop the HighPerf Server. This may take few minutes.
        • Execute sh VWstartdb.sh to start the HighPerf Server.
      • Start the NetFlow service and wait for 5 minutes and verify Highperf Reporting Engine status is Online in Settings -> NetFlow -> HighPerf Reporting Engine.

     

    If problem persist after trying the above steps, please contact support with following log files.
    Please follow the appropriate step based on OS & HighPerf installation type.

     

    1. Windows (HighPerf Local Installation)
      • Open a command prompt with Administrative privelige.
      • Navigate to <OpManager_Home>\Actian\VectorwiseVW\ingres\sig\inglogs
      • Set the environment variable using following command by replacing the <OpManager_Home> in set II_SYSTEM=<OpManager_Home>\Actian\VectorwiseVW
      • Execute following batch file to collect the log information inglogs.bat.
      • This script will create a logs directory named like inglogs_date_time (Eg: inglogs_20190803_023201393). Please zip and send this log directory for analysis.
    2. Windows (HighPerf Remote Installation)
      • Connect to HighPerf Server system
      • Open a command prompt with Administrative privelige.
      • Navigate to <OpManager_Home>\Actian\VectorwiseVW\ingres\sig\inglogs
      • Set the environment variable using following command by replacing the <OpManager_Home> in set II_SYSTEM=<OpManager_Home>\Actian\VectorwiseVW
      • Execute following batch file to collect the log information inglogs.bat
      • This script will create a logs directory named like inglogs_date_time (Eg: inglogs_20190803_023201393). Please zip and send this log directory for analysis.
    3. Linux (HighPerf Local Installation)
      • Open a termial as installation owner.
      • Navigate to <OpManager_Home>/Actian/ingres/sig/inglogs
      • Set the environment variable using following command by replacing the <OpManager_Home> in export II_SYSTEM=<OpManager_Home>/Actian
      • Execute following script to collect the log information ./inglogs
      • This script will create a logs directory named like inglogs_date_time_pid (Eg: inglogs_20190802_114156_pid28585). Please zip and send this log directory for analysis.
    4. Linux (HighPerf Remote Installation)
      • Connect to HighPerf Server system.
      • Open a termial as installation owner.
      • Navigate to <OpManager_Home>/Actian/ingres/sig/inglogs
      • Set the environment variable using following command by replacing the <OpManager_Home> in export II_SYSTEM=<OpManager_Home>/Actian
      • Execute following script to collect the log information ./inglogs
      • This script will create a logs directory named like inglogs_date_time_pid (Eg: inglogs_20190802_114156_pid28585). Please zip and send this log directory for analysis.