When connecting to an OPC DA or OPC HDA server on a remote machine, Microsoft’s DCOM technology is used.
Microsoft is due to release an update to harden DCOM connectivity which requires OPC DA and OPC HDA clients like XLReporter to use higher level authentication to connect.
To account for this, in the Settings of the OPC DA and OPC HDA connectors, the Use Packet
Integrity Authentication Level option is provided. If the DCOM hardening has been applied to the
machine where the OPC DA or OPC HDA server is running, this option should be checked.
The Historical values (wide multi-table) connector now provides an interface to specify which tables
and views to browse and request data from in the database connected to. Each table and view can be
set with a Friendly Name to help users identify where to get their data from
The Historical values (narrow multi-column) connector now provides an interface to specify the tag
table and data table settings for all the tables and views to consider in the database for the connector.
Each data table/view can be set with a Friendly Name to help users identify where to get their data from.
Email and SMS
Data Export to Database
In an effort to bolster email security, Microsoft is phasing out basic authentication to the Office 365
SMTP server in favor of more advanced, modern authentication methods.
To account for this, the Email and SMS application has been updated so that the Office 365 SMTP
server can still be used as your mail server by using the OAuth2 authentication method.
For more information, see Deprecation of Basic authentication in Exchange Online on Microsoft’s
website.
Improvements/Issues Fixed
Database Consolidator
Timeout
If requests to the source database took longer than 20 seconds a timeout error would be returned regardless of the Client Wait Time set in the connector.
Missing Data
If the Source Date Storage is set to utc, after the initial consolidation of data, records from the beginning of the next request were not being logged to the Target Table.
Data Entry Forms
When used from a Windows Client, if the table for the data entry form contained a reserved word in
the database, an error would appear when the form was selected. For example, if the table contained a
column named Level, the error would read “The LEVEL clause includes a reserved word or argument”.
Design Studio
For older manual data entry form templates, a Save As action would cause the studio to crash.
FTP Transfer
When uploading to an FTP Server, if the Clear Folder before transfer setting was checked on the
Target tab and no files in the Target Folder matched the Source Filter specified, a “Failed to clear
target folder” error message could be returned.
On-Demand Reports
When selecting a tag with no description in an On-Demand Report, changing Display to Description
and back to Name or Nickname would remove the tag from the panel.
Template Library
The Chart Recorder library templates have been completely revamped.