The MS SQL JOIN hint ‘REMOTE’ Specifies that the join operation is performed on the site of the right table. This is useful when the left table is a local table and the right table is a remote table. ‘REMOTE’ should be used only when the left table has fewer rows than the right table.
Known SQL disconnection errors
There are known issues connecting to the Wonderware Historian when the historian database is on certain
MS SQL builds.
The issues manifest on the client side as similar to the following:
-
‘08S01’, ‘[08S01] [Microsoft][ODBC Driver XX for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host
-
(SQLExecDirectW); [08S01] [Microsoft][ODBC Driver XX for SQL Server]Communication link failure (10054)’)
This known issues is caused by a bug in MS SQL Server which causes a fatal unrecoverable error in the connection. In the SQL Server logs, the error will manifest as an Access Violation with a code of 17310 or 17311 or similar
Fix:
-
For MS SQL 2016, please ensure that the following or newer is installed on the Historian MS SQL Server: Cumulative Update 4 for SQL Server 2016 SP2.
-
For MS SQL 2017, please ensure that the following or newer is installed on the Historian MS SQL Server: Cumulative Update 4 for SQL Server 2017.