PI DataLink 2023 SP1 Release notes

50948

Adding a PI Data Archive results in Known Servers Table related errors after Office update/upgrade.

10360

PI DataLink right-click context menu duplicated and/or removed when multiple Excel workbooks are opened.

44792

PI DataLink fails to reach the well-known openid-configuration endpoint when connecting to an OIDC-enabled Data Archive or AF Server.

Enabling the “Require that application add-ins are signed by trusted publisher” Excel setting may require the user to apply the latest updates and service packs to Windows and Office. PI DataLink assemblies are signed with a sha256 certificate, which is only supported by updated Windows/Office versions. The trusted publisher certificate pidlcert.cer can be found in the PIPC\Excel directory.

If an Excel chart references a PI DataLink function, it will not update when Ctrl+Alt+Shift+F9 is pressed, unless the PI DataLink function references a cell that has changed, or the PI DataLink function being referenced is the Current Value function.

Tab key does not wrap from the last control to the first control, and Shift + Tab does not wrap from first control to the last control.

If a workbook is protected, DataLink functions can be recalculated by F9 or Ctrl+Alt+Shft+F9, but not all right-click menu options will work.

Explore/Compare Events task pane no longer supports a fifth attribute filter (starting in PI DataLink 2016). Existing formula arrays with a fifth attribute value filter will continue to work correctly, but will not have the fifth attribute value filter available in a re-initialized task pane.

Search results have a limit of 100,000 tags for PI tag searches. This limit may be less if there are GUID named tags. For AF searches, there is no limit.

Timestamp strings in PI format (i.e. "5-Jan-12") will be parsed as "yy-mmm-dd" with Asian regional settings. To parse them as "dd-mmm-yy", set the Locale Independent setting to true.

PIPutVal does not support writing to attributes which are configuration items.

The event-weighted count when used with an expression will return two more events than are there. The default behavior of the PI server is to return two interpolated values at the period endpoints, in addition to the other values in the period, resulting in these being counted in the return value.

The connection preference for DataLink functions has been set to "Any". However, since the connection preference is set at the time of the connection, the order in which the connection is made matters. If DataLink functions are called first, then it will make a connection with connection preference of "Any". If the first connection is made with the trend control, tag search, or the connection manager, then the connection preference is "PreferPrimary".

DataLink calls referencing custom data references will return "Data item not supported by function," unless the author of the custom data reference opts-in when writing the custom data reference.