1. Bonjour tout le monde ! Veillez consulter la Politique de forum pour comprendre nos règles, Merci a vous !
    Rejeter la notice

Frequent disconnction from HFSQL server after a long inactivity

Discussion dans 'Base de donnés & HFSQL' créé par sanyad, Avr 4, 2023.

  1. sanyad

    sanyad Member

    Inscrit:
    Sept 27, 2019
    Messages:
    176
    J'aime reçus:
    7
    Hi Friends,

    I am currently working on a project that involves using an HFSQL file hosted on my NAS server through Docker. Everything seems to be working fine during normal usage, but I've noticed that when I leave the app inactive for around 10 minutes and then try to use it again, the app hangs and I start getting HFSQL connection errors. To be able to use the app again, I have to exit it and then restart it.

    Is there any way I can prevent this issue from happening? I want to ensure that inactivity of the computer or the app for a longer period of time doesn't have any impact on the client-server connection of HFSQL.

    Please suggest some help.
     
    Tags:
  2. commun

    commun Active Member
    MEMBRE WX

    Inscrit:
    Jan 1, 2018
    Messages:
    227
    J'aime reçus:
    111
    Hi, I would incriminate the sleep mode which can create this kind of problem, look at the settings of the Nas sleep mode
     
    sanyad et Gemini1961 aiment ça.
  3. JeAn-PhI

    JeAn-PhI New Member

    Inscrit:
    Juin 17, 2020
    Messages:
    17
    J'aime reçus:
    6
    Hi,

    try to use this

    Bonjour visiteur, Merci de vous Inscrire ou de vous connectez pour voir les liens!

    with hErrConnectionLoss to catch lost connection
     
    sanyad et Isabelle aiment ça.
  4. sanyad

    sanyad Member

    Inscrit:
    Sept 27, 2019
    Messages:
    176
    J'aime reçus:
    7

    Bonjour visiteur, Merci de vous Inscrire ou de vous connectez pour voir les liens!

    Hi,

    try to use this

    Bonjour visiteur, Merci de vous Inscrire ou de vous connectez pour voir les liens!

    with hErrConnectionLoss to catch lost connection
    Cliquez pour agrandir...
    Thanks... I will check..
    I afraid this constant is not available for windows.
     
    #4 sanyad, Avr 14, 2023
    Dernière édition: Avr 14, 2023
  • sanyad

    sanyad Member

    Inscrit:
    Sept 27, 2019
    Messages:
    176
    J'aime reçus:
    7
    hErrConnectionLoss is not available for windows.
    I stop hibernation/sleep of my NAS.
    But the use computer running compiled application may be in sleep mode anytime and that may also cause disruption of connection to server HFSQL and thus may raise error.
    My application is showing following error after such instance on the user computer:
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    An error occurred while running the assisted security mechanism of HFSQL:
    No value was returned by <WIN_Connection_Error>.

    Call stack:
    Left button double click (WM_LBUTTONDBLCLK) on Table_approvals (IW_planning_approvals.IW_planning_approvals.Table_approvals), line 13

    Date: 13/04/2023 14:17:20
    Project: Planner_HFSQL_2022 (1.2.0.0)

    Additional information:
    Error code: 70303
    Module: 'wd250hf.dll (01A250083n - 25.0.217.0)
    Debugging information:
    Fonction (7,56)
    EIT_TYPE_WDFILE : <8>
    EIT_IDCODE : <66051>
    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
  • JeAn-PhI

    JeAn-PhI New Member

    Inscrit:
    Juin 17, 2020
    Messages:
    17
    J'aime reçus:
    6
    I'm afraid you don't know how to read correctly, this constant is not available for Universal Windows 10 App (Windows logo in blue color), it is indeed available for Windows (Windows logo red, green, blue and yellow)
     
    sanyad apprécie ceci.
  • sanyad

    sanyad Member

    Inscrit:
    Sept 27, 2019
    Messages:
    176
    J'aime reçus:
    7
    Thanks I start using

    "Timer(recon,2000)" during project initialization code.

    Recon is a procedure in which i used HReadFirst command to connect with a small datafile having 2 records
    I call Recon procedute every 20 sec to avoid disconnection of HFSQL.
     
  • JeAn-PhI

    JeAn-PhI New Member

    Inscrit:
    Juin 17, 2020
    Messages:
    17
    J'aime reçus:
    6
    on project initialization

    HOnError("*", hErrConnectionLoss, "OnErrConnectionLoss")

    ------------------------------------------------------------------

    //------- Procedure to call for errors connection
    PROCÉDURE OnErrConnectionLoss()

    ....
     
    sanyad apprécie ceci.
  • Partager cette page

    Chargement...