ODBC database processor does not react correctly to SQL Server restart
Summary
Whenever an operation fails (like due to the error shown in the description), the cached objects are cleared. This forces a recreation of the prepared statement after statement execution fails and connectivity comes back online.
Description
Whenever an operation fails (like due to the error shown in the description), the cached objects are cleared. This forces a recreation of the prepared statement after statement execution fails and connectivity comes back online.
Information
Restart Service Engine
Issue Number: 250818
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 / ...
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. ...
Checklist: OPCDA Server
Time estimate: 20 minutes Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative. Do NOT use DCOM in combination ...
Checklist: Distributed Engineering – Engineering Studio cannot connect to the Project Database-Server / Elements cannot be checked-in/out
Time estimate: 45 minutes Please go through all the items in the following checklist. If necessary, confirm any information you cannot verify with the IT department before contacting your local COPA-DATA representative. Checklist usage: #. [Quick ...
SQL PGW: Values are not written into database tables
Description SQL Process Gateway version 11 does not display configured variables and values. Cause: The Process Gateway cannot access the configured variable list. This behavior has been fixed. The PGW now displays variables and values correctly. To ...