Connection loss to database causes continuous SQL export to crash

Connection loss to database causes continuous SQL export to crash

Summary

When a connection loss is detected, the connection management runs the connection loss treatment now on "one parallel operation per connection" isolation level to avoid the connection loss treatments connection object shutdown interfering with currently running operations that have not yet detected the connection loss.

Description

When a connection loss is detected, the connection management runs the connection loss treatment now on "one parallel operation per connection" isolation level to avoid the connection loss treatments connection object shutdown interfering with currently running operations that have not yet detected the connection loss.



Issue Number: 251063
Fixed on Date: 12.4.2022
Versions: 10 0 BUILD 98635

    • Related Articles

    • FAQ: What SQL server interfaces are offered by zenon?

      The most common ones are: The zenon Historian The Extended Trend The zenon Report Generator The zenon Report Engine The zenon SQL export functions The zenon SQL Driver and The zenon Process Gateway SQL module All these modules depend on an ODBC / ...

    • AML continuous export writes wrong reactivated time

      Description In the AML, the time for “time reactivated” is entered incorrectly when writing alarms with continuous export export to an SQL database or to a Service Grid Data Storage. Instead of the correct time for the reactivation of the alarm, the ...

    • Sporadic Runtime crash when exporting CEL to SQL database

      Summary Sporadic Runtime crash when exporting CEL to SQL database Description Sporadic Runtime crash when exporting CEL to SQL database Issue Number: 228666 Fixed on Date: 1.10.2020 Versions: 8.10 0 BUILD 69252 | 8.20 0 BUILD 69240 | 8.00 0 BUILD ...

    • Sporadic Runtime crash when exporting CEL to SQL database

      Description In zenon 8.20, the Service Engine can sporadically crash when exporting the CEL to an SQL database. This error has been fixed. To benefit from this fix: Update your zenon Software Platform to the latest build of zenon 8,20 or higher. Item ...

    • Database cannot be opened! (SQL Authentication Error)

      When opening zenon, one may encounter the following message in the output window: Taking a glimpse at the logs reveals that there are authentication errors regarding zenon's default database user "zenOnSrv". Therefore, no projects can be opened. ...