PI SQL Data Access Server (RTQP Engine) 2024 R2 release notes

3077316

Conversions from variant to string do not use locale and timezone settings.

Example query:

SELECT a.Value, a.Value_DateTime, String(a.Value) AS VariantToString, String(a.Value_DateTime) AS DateTimeToString
FROM[Master].[Element].[Attribute] a
INNER JOIN [Master].[Element].[Element] e ON e.ID = a.ElementID
WHERE e.Name = 'MyElement' and a.ValueType = 'DateTime'

The expression for column VariantToString does not use timezone settings while the expression for DateTimeToString does.

This has been fixed.

3077304

A query which uses a custom data model object based on template-based TVF or table may result in an error: "Collection was modified; enumeration operation may not execute.".

This has been fixed.

3077307

Joining two Value template-specific table templates using attribute value may return the "Not all required columns were restricted or were restricted properly." error.

This has been fixed.

3077320

Execution of queries containing a grouping column of type Variant results in the following error: Assertion failed: false.

This bug has been fixed.

3077325

Integral units of measure cannot be specified when creating a template-based table-valued summary or summaries function for a Total summary type.

The following error message is displayed:

The object definition is not valid. The object definition is not valid.
Specified argument was out of the range of valid values.
Parameter name: unitOfMeasure

This has been fixed.

3213010

Restricting an archive table query with a condition that always evaluates to false leads to the following error:
'Archive' table 'TimeStamp' column must be restricted to a continuous interval having a finite lower bound.

Example query:

SELECT * FROM [Master].[Element].[Archive]
WHERE TimeStamp BETWEEN 't' AND 't-3h' AND 1=0

This bug has been fixed.

3777082

Overwriting a template-based attribute was not recognized by the Attribute table (Description or DataReference changes).

This bug has been fixed.

3076509

The error message "[OSIsoft.AFSDK] A call to SSPI failed, see inner exception." appears when PI OLEDB Enterprise Server Agent uses different account than AF Server.

PI SQL DAS (RTQP Engine) setup kit will raise a warning if accounts of agent and AF Server are not compatible.

3370001

When you uninstall and reinstall PI SQL Data Access Server (RTQP Engine) within a short period of time, the error message "The SSL certificate is not effective yet" can appear.

This has been fixed.

3076490

Previous install kits did not support non standard PIPC locations.

This has been fixed.

3076508

When read access to an AF database was removed for World, the following error was returned from PI OLEDB Enterprise queries: "[OSIsoft.AFSDK] Cannot complete the operation because the user does not have rights to read PI AF Server '<server name>' with UniqueID '<server GUID>' for PI OLEDB Enterprise." This has been addressed by introducing a new identity, PI OLEDB Enterprise Server Agent, that is used by the PI OLEDB Enterprise Server Agent service.

3076709

Firewall exceptions were removed on the upgrade from a previous version.

This has been fixed.

4539708

The PublicKeyToken for customHttpHeaders was incorrect.

This has been fixed.

4080023

SQL scripts ran into an error on a SQL Server cluster node.

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) 2024 R2, 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.