Use of `REMOTE JOIN` - j5 - 28.0 - Help - Hexagon PPM

j5 Wonderware Historian Datasource Connector Help

Language
English (United States)
Product
j5
Search by Category
Help
j5 Version
2019

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 WW 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.