AW: Azure dropping out

[Stefan Csomor]

Hi Chris 

If your database is postgres then here is an article explaining not only the problem but also the involved parameters 

https://www.cybertec-postgresql.com/en/tcp-keepalive-for-a-better-postgresql-experience/ <https://www.cybertec-postgresql.com/en/tcp-keepalive-for-a-better-postgresql-experience/> 

and these are the values microsoft themselves are using for azure 

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/server-parameters-table-connections-and-authentication-tcp-settings?pivots=postgresql-17 <https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/server-parameters-table-connections-and-authentication-tcp-settings?pivots=postgresql-17> 

HTH, 

Stefan 

Von: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> im Auftrag von Scotte Meredith <spomacguy at gmail.com>
Datum: Mittwoch, 14. Mai 2025 um 02:04
An: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Betreff: Re: Azure dropping out 

If this is the database connection that is dropping, look at the "keep alive" setting. Postgres has one, but I don't recall where it is. We've had problems in the past with VCS sessions dropping until this was set properly.


Scotte Meredith
spomacguy at gmail.com
509/998-0991




> On May 13, 2025, at 3:19 PM, Chris Hughes via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Greetings my client is having a problem with Omnis Studio 10.2.
> 
> The IT department they have engaged, can not get the program to hold in for more than 15 to 20 minutes, after this the client has to restart the Omnis library (application).
> 
> The system is using Microsoft Azure over a VPN network.
> 
> It is not my problem, I provide the software and data base, the IT suppose do the bit in middle the network, and make it work.
> 
> Any tips, does any body know something about this , may be there is a secret timer in Azure or some thing.
> 
> It was working on an older version of Omnis.
> 
> 
> Any help appreciated.
> 
> -- 
> *Chris Hughes*
> Phone No:-07 32086347
> Mobile No :- 0409 263 349
> Email :- ataddata at bigpond.net.au
> Address:-
> 3 Springwell Avenue
> Springwood QLD 4127
> Australia
> www.ataddata.com.au <http://www.ataddata.com.au>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com <https://lists.omnis-dev.com>
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com> 

_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com <https://lists.omnis-dev.com>
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>