PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → wd20: HFSql timeout settings
wd20: HFSql timeout settings
Débuté par kingdr, 11 fév. 2016 17:47 - 11 réponses
Posté le 11 février 2016 - 17:47
Hi All

Would someone shed some light for setting up the timeout when
using HConnect... as I wanna keep alive as longest as possible when
the screen with remoting HConnection remains idling?

Thanks in advance.

Cheers

King
Posté le 11 février 2016 - 17:57
I never used it with HFsql but you can try using WD Connection Timeout or WD Command Timeout in the optional connection information

http://doc.windev.com/en-US/…
Posté le 11 février 2016 - 18:55
Great Paulo

I'll give it a try.

so difficult to find such piece,

many thx indeed :)

Cheers

King
Posté le 11 février 2016 - 19:31
Hi,
does your connection "sleep" after say a 1 minute idle ?
This seems to be new to v20 ...
They actually fixed a 'bug" (I reported it) in v20 C/S, where when a user lost connection to the C/S HFSQ, in the middle of a transaction, the C/S engine would not recover automatically.
Fixing the above bug, introduced (I think) another issue.
If your user is idle for a minute or so, it takes a long time to do any kind of file access after the user "wakes up" the app.

I bypassed the problem with a simple procedure in my main window:
Timer(RefreshNotify,2000)
where RefreshNotify just reads my licence file (HF file)

The settings Paulo refered to didn't make a difference in my situation

Steven Sitas
Posté le 11 février 2016 - 20:07
Steven

I do a menu and call for a HConnect each time for openchild windows then
I leave it for less than 3 mins and it popups a reconnection windows asking me
to click OK to reconnect, I know it doesn't make sense to me, but what can I do
and I did this "WD Connection Timeout=6000" as exteneded param of
HDescribeConn..., with no hopes, it looks pretty constant.

Of course, I can quit and re-enter the wd app, I have no clue at all.
Timer might not work while entering data at the time the timer triggers to
reconnect and I will lose all data before saving it to hfSql.

Is it a bug???

Needs some further help.

Thx in advance

Cheers

King
Posté le 11 février 2016 - 20:42
King,

that does not look as a WD problem to me. I can have an application open, with a connection to spearate hfsql server, whole day or even longer. The connection remains active even if I don't do anything at all.

I suspect it is security setting in the router or firewall, which kills the connection after some idle time.
In that case the keep-alive trick mentioned by Steven will work
Posté le 11 février 2016 - 21:14
Hi Arie,
are you sure you are using HF C/S version 20 ?
It does not happen with Classic HF files or with HF C/S versions prior to v20, on my internal network.
I can reproduce it, but since I don't think of it as a bug - rather a feature, since it catches ALL orphan transactions now - I am NOT complaining :)

Steven Sitas
Posté le 11 février 2016 - 21:22
Hi King,
the timer will work just fine and you will NOT lose any data when it fires up ...
I have a licence file that has just ONE Record and I use a HReadSeekfirst in a timer to read it every 2000 hundredths of a second.

It doesnt do any damage to your users ongoing work.

Its also a solution if your nics/network cards are GREEN or (on Save Power mode) - it really is very difficult to control your users installations.

Steven Sitas
Posté le 11 février 2016 - 21:40
Yes, it could be the adsl-router->wifiBridge-Router and w/s firefall issue.
I'll try out directly to adsl-router at home instead.

The wifi key might alter occasionally to prevent intrusion and they are all in wifi-ac instead
of wifi-n but it never happens when using wd/wb15-->17 with wifi-n (app stays all day long without reset at all) and somehow when upgrading to 19 then to 20, things happened, all settings remained the same and I thought those usb wifi-n were old then to wifi-ac with no hope at all.

Any tricks to overcome are welcome.

Anyway, thx all.

Cheers

King
Posté le 11 février 2016 - 21:56
Just have a test on remote logon is OK and I leave it idling on for more than 20 mins and
still have response by clicking the mouse.

Strange..., not the firewall and routers...

No clue??

King
Posté le 12 février 2016 - 01:50
Same here using WD18 on client/server HFSQL. Server is Ubuntu at a datacentre.
Losing connection after 2 min, reconnect window does reconnect.
Thought it also has to do with server settings.
Thx for pointing out Timer function. Will give it a try.
Posté le 12 février 2016 - 20:22
Yes Timer(RefreshNotify,2000) works as workaround

Thx Steven Sitas

Cheers

King

ps. 'wish if pcSoft could let us suppress a popup dialog asking to RECONNECT as
it shows real IP+port# and will let us to give some more params to do the settings.
I did tweak the router and it works a charm for remote login as idling for a whole
day with no connection lost indeed.