• Replies 3 replies
  • Subscribers 581 subscribers
  • Views 302 views
  • Users 0 members are here
Options
Related

Problem "no more handle left" connections to database Microsoft SQL

Sebastian

Has anyone encountered the problem of too many database handles.

We use the cicode SQLcreate and SQLdispose functions when performing stored procedures.
In the parameters of citect.ini we've set up SQLMaxConnections = 0.
In Hardware alams after a while (when in resource monitor watch 10 connections at port SQL) throws an error "no more free handle left" and we must restarting runtime.
Citect Scada 2016
Windows Server 2012 R2
Redundant

Parents

  • Yes we are using SQLClose(hSQL) before every our SQLDispose(hSQL) like in example Function from help SQLCreate(..).
    Our system have redundancy two servers.
    We see a problem when events occur when servers stop seeing each other.
    We have a local bit to see which server is active and then we run events (tiggers) on PRIMARY or STANDBY with our cicode (Querys, Run Stored Procedures).
    ..
    When the servers cannot be seen, the event is probably done on both servers and the handles are exceeded ?

Reply

  • Yes we are using SQLClose(hSQL) before every our SQLDispose(hSQL) like in example Function from help SQLCreate(..).
    Our system have redundancy two servers.
    We see a problem when events occur when servers stop seeing each other.
    We have a local bit to see which server is active and then we run events (tiggers) on PRIMARY or STANDBY with our cicode (Querys, Run Stored Procedures).
    ..
    When the servers cannot be seen, the event is probably done on both servers and the handles are exceeded ?

Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.