Actian Zen v16 Update 3

Patch Release - 7/08/2025

Install Build version 16.01.005
Components Build version 16.01.005

Products

This patch applies to the following Actian PSQL products:

Executables

These patch notes apply to the following executables:

 

 

By default, the Zen_Patch_* executables create a patch installation log in the %temp% location. If instead you are using an .msp file extracted from one of these executables, then to create a log file when applying this patch, run the patch executable from a command line with the /l option. In the following example, the patch update creates a verbose log file named patch_install.log:

Zenv15Patch_type.msp /l*v <path>\patch_install.log

Uninstalling Notes

On Windows systems, in most cases a Zen patch update can be �rolled back� by uninstalling it. This removal restores Zen binaries to their versions before the update. (See the note below about unremovable patches.)

To uninstall a product update for Zen from the command line, you need the following:

�        Original installation package (.msi) or the Product Code GUID for the installation. Each Zen install type has a different product code GUID.

�        Original Microsoft patch (.msp) file.

Either of the following commands can remove a product update:

�        msiexec /package <{path_to_MSI} or Product_Code_GUID> /uninstall <path_to_MSP> /l*v "%temp%\uninstall_patch.log"

�        msiexec /i <{path_to_MSI} or Product_Code_GUID> MSIPATCHREMOVE=<path_to_MSP> /l*v "%temp%\uninstall_patch.log"

Note that the user executing the command must be able to access the source files installed by the original Zen installation.

Note: In certain cases, a Zen patch cannot be removed. A warning message states �Uninstallation of the patch package is not supported,� which also is entered in the installation log file. If the patch must be removed, first uninstall Zen entirely and then reinstall the version you need, along with the appropriate patches.

Issues Addressed

Specific issues addressed in this patch release (Build 16.01.005):


 Tracking Number


Description

PSQL-11878

Performance issue with ZenCC when retrieving many rows with many columns

PSQL-11872

ADO.NET application using .NET Core may cause an extra license to be used

PSQL-11866

SQL PARC (Auto Reconnect) is not working as expected

PSQL-11856

Possible SQL engine crash when attempting to update a computed field in a view

PSQL-11849

SQL Engine shut down issue for ADO.NET applications using connection pooling

PSQL-11841

Possible SQL engine crash for a query using coalesce with a subquery containing an optimized IN predicate

PSQL-11808

Japanese characters are not properly formatted in EasySync log files

PSQL-11715

ADO.NET provider returns an Entity Framework Core Scaffolding error for string columns with an empty string default value

PSQL-11700

Possible SQL engine crash when updating a LONGVARCHAR/LONGVARBINARY which is larger than 64K bytes

PSQL-11684

Possible SQL engine crash with nested CASE statements

PSQL-11672

Possible incorrect results on a query involving multiple tables with the same column name that uses an unqualified column name in a restriction

PSQL-11585

SQL engine may not optimize correctly on a multi-column index if both columns are involved in restrictions

PSQL-11402

Incorrect Btrieve lock owner is returned when the client is using a cache engine

PSQL-8585

Incorrect identifier is returned to a JDBC application calling getDatabaseMetaData() for an NCHAR column

 

Previous issues addressed since the release Zen v16.00:


 Tracking Number


Description

PSQL-11664

Possible incorrect results or status 2 returned on files with owner names with encryption

PSQL-11636

�Invalid user authorization specification� may be returned by Tableau and other 3rd party ODBC applications

PSQL-11609

Possible engine crash or hang under heavy usage with Page Read Ahead

PSQL-11605

Possible SQL engine crash from complex SQL query involving EXISTS subquery and table subqueries with nested string functions with CASE expressions and UNION

PSQL-11602

Possible engine crash or error when specifying a DICTIONARY_PATH longer than 247 bytes

PSQL-11600

Possible SQL engine crash from complex SQL query involving aggregates, CASE, and UNION

PSQL-11487

�Unsupported cursor fetch direction� when using FETCH without NEXT FROM in a stored procedure.

PSQL-10451

The default location for a client-side trace on Linux is invalid.

PSQL-11433

Possible incorrect results for a join query involving a multi-column index and a restriction on a bit column

PSQL-11431

Zen System Analyzer log does not properly include registry settings

PSQL-11418

Extra memory allocation when using nested CASE statements

PSQL-11378

Performance improvement for queries containing multiple restrictions on the same column, or multiple restrictions on the same table.

PSQL-11377

Duplicate System Error messages may be written to the zen.log

PSQL-11375

SELECT for UPDATE may not lock all records matching the criteria in the query.

PSQL-11286

Possible data truncation when a wide column is selected in a query that requires a temporary soft file.

PSQL-11285

Increase Bulk operation filters from 16 to 128 when using Btrieve 2.

PSQL-11284

Possible engine crash when creating and dropping global temp tables from different threads in the same application.

PSQL-11262

Segment definition mismatch between a Btrieve file and a SQL index is causing incorrect optimization for some queries.

PSQL-11252

Cannot create a 32-bit ODBC Engine Interface DSN via the 32-bit ODBC Administrator

PSQL-11212

When �Integrity enforced� setting is disabled for a database, triggers should not fire when the corresponding insert, update, or delete is executed.

PSQL-11210

Incorrect PID shown in Monitor for SQL connections

PSQL-11150

SQL Engine is not sending a timeout to a client running ADO.NET when the query timeout value is reached.

PSQL-11149

Possible SQL engine crash when using ALTER TABLE to drop a column that is a segment in multiple indexes

PSQL-11140

Add support to EasySync for Japanese file and path names

PSQL-11087

ALTER TABLE to add SYDATA_KEY_2 fails to add the system data if the file previously did not have any system data.

PSQL-11082

Possible incorrect results from query with multiple subquery expressions in the SELECT list.

PSQL-11044

Possible incorrect results with complicated LIKE comparisons using ESCAPE

PSQL-11043

BDU may insert NULL values into NOT NULL columns.

PSQL-11037

DELETE statement may not delete all values if restriction uses an OR on columns in a segmented index

PSQL-11011

SQL Engine hang instead of error with invalid trigger.

PSQL-11007

Result set may be ordered incorrectly for query with multiple left outer joins and NULL values in the results.

PSQL-10967

Possible SQL Engine crash when using MSQuery to access a table with a [n]longvarchar column.

PSQL-10917

Missing error message text when accessing a table that has more indexes than the underlying data file.

PSQL-10680

PVDDL returns �Invalid column type� for a CREATE TABLE with a MONEY column.

PSQL-10630

Possible SQL Engine crash from query with scalar and nested table subqueries involving CASE

PSQL-10584

ZenCC export data is incorrectly removing leading blanks from character strings

PSQL-10489

Add ProcessID to Server Monitor.

PSQL-10479

Improved security for connection strings in JDBC applications.

PSQL-10266

Rebuild utility is not saving settings when run by a non-administrator user.

PSQL-10209

Monitor displays 0.0.0.0 as the network address when running a JDBC application with THREAD_MODE=SINGLE.

PSQL-9774

When entering an Array Fetch Buffer size larger than 64, and error pop-up is displayed without a message.

PSQL-7448

Status 45 may be returned when using the Maintenance Utility to add a multi-segment index

PSQL-5102

No error message displayed when an invalid value is entered for the Array Fetch Buffer when configuring a DSN.

PSQL-4902

Extended Stat operations, subfunction 4 does not properly report transaction status.

PSQL-3828

Possible engine crash when using Backup Agent and the Include File list (IFL.TXT) includes a bound file.

 

Technical Support

You can obtain technical support from several online options at the Zen website:

  • Knowledge Base. Search hundreds of articles for answers and solutions others have found useful.
  • Community Forums. Join a technical discussion or post a question to start a new one.

Disclaimer

ACTIAN CORPORATION LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT.

Copyright �2024 Actian Corporation. All Rights Reserved.