Release notes

256417

"Unknown error" has been returned when specifying an invalid time zone identifier. The error message has now been made specific.

279941

Event frame template-based GetSummary table-valued function overload, that has a single parameter (eventframe ID), results in the following error on the PI SQL Data Access Server (RTQP) side:

System.InvalidOperationException: Operation is not valid due to the current state of the object.

This has been fixed.

296251

Using a placeholder of type Bool returns the following error: 

The specified cast is not supported.

This has been fixed.

304036

Running GO.bat against an existing database where the 'AFQueryEngines' schema owner has been changed results in the following error: 

There is already an object named 'AFQueryEngines' in the database.

This has been fixed.

305144

Some entries to the Windows Event Log were incorrectly formatted. This has been fixed.

328470

If milliseconds are used in QueryDate or when filtering on columns of DateTime type (Created and Modified) an unexpected result may be returned. DateTimes having milliseconds are rounded to increments of .000, .003, or .007 seconds when passing to SQL Server. If DateTimes with higher precision than milliseconds are used, this rounding does not apply. 

This has been fixed.

420315

Event frame queries may return wrong results when restricted by an attribute value of the date time type. The results are shifted by the AF Server timezone offset. This issue occurs when AFSearch is used in the execution plan to perform the query.

This has been fixed.

212091

The filter capabilities of the TimeStamp column in the Archive table are limited. It is not possible to query the Element.Archive table against two periods. For example:

SELECT * FROM Element.Archive a WHERE (a.TimeStamp BETWEEN '5/13/2018' AND '5/14/2018') OR (a.TimeStamp BETWEEN '5/15/2018' AND '5/16/2018')

Workaround

To workaround the issue UNION ALL can be used. For example:

SELECT * FROM Element.Archive a WHERE a.TimeStamp BETWEEN '5/13/2018' AND '5/14/2018'

UNION ALL

SELECT * FROM Element.Archive a WHERE a.TimeStamp BETWEEN '5/15/2018' AND '5/16/2018'

239997

PI SQL Client connection dialog provides the list of accessible AF Databases only if PI Web API Core Services are installed on the AF Server.

Workaround

The AF Database name can be entered manually.

75491

After installation of PI SQL Data Access Server (RTQP Engine) 2023, PI OLEDB Enterprise returns the following error when trying to connect with an explicit login:

Cannot connect to server '<afserver>'. Please examine connectivity to the remote PI AF Server as well as ensuring the impersonated client user can be delegated to the server.

Solution

Upgrade PI AF Client on the client machine to version 2023 or later.

98762

If the RTQP Engine PI System identity does not have Admin permission, a calling user may see attribute data even if ReadData permission is not granted to that user.

Workaround

If you have elements or event frames which allow attribute access (Read permission) for users, but do not allow attribute data access (ReadData permission), then you must ensure that the RTQP Engine PI System identity has Admin permission.