History File for Pervasive PSQL v11

Enhancements and Problems Fixed

September 2010

 

Tracking Number

Component

Description

58748

Communication

Support IPv6 for Btrieve and DTI on Windows

58862

Communication

NSL and Winsock errors in the Client PVSW.log when Client connected to a Linux Server

59046

Communication

The database engine is not accessible via NETBIOS and SPX

59279

Communication

Change Listen IP Address to take a comma-separated list

59673

Communication

ADO.NET provider consumes extra license when run on 2K8R2 Terminal Services

59710

Communication

Communication thread problem seen on Linux under heavy load

58867

Documentation

No context help for ODBC Administrator DSN Setup GUI on 64-bit Windows client

56075

Install

Engines not added to firewall when performing minimum installation

57517

Install

PSQL v11 no longer supports Windows 2000

57908

Install

Suppress XIO Installation if target machine is A cluster node 

57980

Install

Difficulty determining the install build of PSQL on Linux after a tar.gz install 

58304

Install

Setupdb.exe attempts to call the WGE before it has properly started up 

58316

Install

WGE - returns message engine already loaded as install runs 

58347

Install

Enabling XIO feature from ptksetup.ini not working for silent installs 

58713

Install

WGE installs as service even when PVSW_RUN_WGE_AS_SVC=N specified on command line 

58714

Install

Should disable System Cache setting when migrating pre-v10 PSQL SE settings during upgrade w/ XIO installed 

58896

Install

Cannot uninstall Pervasive PSQL Workgroup running as an application on Windows XP

58960

Install

Pervasive PSQL v11 Beta cannot be installed on SE Linux with security fully enabled

58973

Install

Change installed DEMODATA DSN to client interface from deprecated engine interface

59122

Install

Linux Server 64 uninstall displays warnings when daemons are running 

59649

Install

Linux: PSQL License can become disabled on reboot 

59682

Install

Instant rollback of Pervasive PSQL installation leaves behind some files on Windows Vista and 2008.

59741

Install

Upgrade from Pervasive PSQL v10 SP2 64-bit Server Engine with update applied to Pervasive PSQL v11 leaves Pervasive PSQL entry in Add/Remove Programs.

59746

Install

Some Pervasive PSQL v10 files are not uninstalled when upgrading from Pervasive PSQL v10 Client to Pervasive PSQL v11.

59816

Install

Linux install should confirm engine startup

57654

Interface

JCL creates invalid data buffer descriptor for Btrieve Get_Next_Extended() 

58309

Interface

Description of Max Memory Usage is incomplete 

59013

Interface

Stack overwrite in OLEDB provider 

59267

Interface

Should install ADO.NET provider 3.2 as part of the 64-bit Client install 

59517

Interface

Add support for .NET 3.5 SP1 and Entity Framework v1.0

59609

Interface

Add DTI functions to DTO that do not have DTO equivalent

58946

Licensing

Telephone authorization utility clipaadm crashes on Linux

59001

Licensing

Offline authorization utility licgetauth crashes on Linux for an invalid authorization (such as trying to authorize an invalid key)

59040

Licensing

Clilcadm does not display successful offline authorization message 

59063

Licensing

Cannot perform license key authorization from a 32-bit Linux client

59425

Licensing

Add Phone Activiation utility

57722

MicroKernel

Multi-thread refactoring for multi-core

58134

MicroKernel

Database engine performance very bad during large system transaction

58483

MicroKernel

MKDE can crash putting file into continuous ops

58712

MicroKernel

Status 2 is seen when Cache engine is used with 6.x and 7.x files 

58990

MicroKernel

cache engine hangs under heavy load

59105

MicroKernel

Corrupt page compression data can cause MKDE to assert 

59152

MicroKernel

Mix of HEX and decimal error codes in pvsw.log makes troubleshooting difficult 

59194

MicroKernel

Roll forward can cause data corruption 

59590

MicroKernel

GetShareName() not working correctly on W2k8 R2 

58922

ODBC

Port ODBC driver to 64-bit for Windows

58925

ODBC

Change 32-bit ODBC setup interface to default to named database instead of deprecated engine DSN

58926

ODBC

Some attributes not supported by 64-bit SQLGetStmtAttr()

58943

ODBC

Error using MS SQL Server 64 Import/Export wizard with PSQL 64-bit ODBC driver

59290

Requester

Multi-threaded application throws status 171 when a different thread does a reset 

57703

SDK

Provide ability to get product information in DTO

58373

SDK

PDAC support for Delphi 2009/2010; deprecate 2006/2007; drop Delphi 6

59000

SDK

PSQL Client may stop responding when PARC is enabled and you run an SQL application

59065

SDK

Remote PCC access from a Linux Client fails when Wire Encryption is turned on

59360

SDK

DTO hangs during WCF CreateObject

59619

SDK

PDAC memo insert fails with an Out of Memory Error 

59471

Services

Stopping Pervasive PSQL v11 services on Linux takes 35 seconds

56770

SQL

"Table or View Already Exists" when calling proc with Temp Table in multiple statement handles 

58649

SQL

Creating table with same column name with 20 characters long returns error "The constraint has already been defined 

58697

SQL

SRDE crashes when table with a CHAR field with DEFAULT value is accessed 

58704

SQL

UPDATE statement updating too many rows 

58711

SQL

Incorrect results from SELECT with UNION, ORDER BY, and table subquery 

58736

SQL

Data corruption by dropping not null constraint 

58750

SQL

"Currency not on record" returned when using a Btrieve Null key for optimization 

58766

SQL

SQL engine is returning Status 80 on an update without retry when there is a conflict

58771

SQL

Not null constraint name counter needs to be unique

58780

SQL

Adding a WHERE clause causes SQL query with COALESCE statement to fail to work

58789

SQL

SRDE engine is returning status -19 to the provider causing the invalid exception 

58800

SQL

"View coalesce error" seen when over 3 levels of nested sub-queries are used 

58815

SQL

"Invalid Argument Value" from stored procedures with date parameters 

58827

SQL

Unable to use a parameter on Date/Time fields in MSQuery (Data Truncated) 

58847

SQL

Presence of brackets changes execution of SQL 

58904

SQL

Inserting binary data literal via SELECT corrupts the data 

58961

SQL

Deadlock in view creation during heavy load

58975

SQL

PROCEDURE_TYPE is always 0 when calling SQLProcedures 

58993

SQL

SQL RAND() function on Linux returns a value greater than 1

59004

SQL

Non-terminated buffer causes expression misevaluation

59009

SQL

SQLExtendedFetch command crashes/or returns error when forward only cursor and array fetch are used 

59073

SQL

Clients returning error "can't find named DB" under heavy load

59086

SQL

Syntax error compiling procedure with FOR UPDATE on SELECT with INTO

59097

SQL

Some issues with SQLForeignKeys being improperly cached

59137

SQL

Rand() function not producing random values

59139

SQL

SQLTables returns incorrect results if DBName is up to 20 characters

59140

SQL

Engine crashes due to unprotected access to metadata

59162

SQL

SQL returns "Error in predicate" when brackets are added 

59163

SQL

UNION with GROUP BY using NULL returns "Null not valid" error 

59164

SQL

Running SQL with filter leads to crash

59170

SQL

Performance problem running a stored procedure

59188

SQL

Creating new ODBC connections fails to Linux engines under heavy load

59205

SQL

Support for >64k stored procedure text

59255

SQL

Extra space was padded in the result set

59263

SQL

Crash in SQL engine when caching virtual table objects for ODBC Catalog functions 

59294

SQL

Invalid timestamp string literal is allowed to be inserted 

59324

SQL

CASE expression returns incorrect results in UDF 

59326

SQL

Editing a table in PCC is slower than before

59327

SQL

VIEW with TOP clause returns more rows with table subquery

59357

SQL

SELECT query returns different results after 10.31.012 patch is applied 

59366

SQL

VIEW with TOP is allowed to be updated 

59376

SQL

SQL engine fails to drop table if table has no fields 

59397

SQL

SELECT from joined view returns incorrect data 

59408

SQL

SQLCancel can cause engine to crash

59450

SQL

Ntdbsmgr crash on SQL connect following update 

57217

Utilities

Butil crashes on Linux when incorrect -endbu parameter is used 

57396

Utilities

When a TIME data type cell on PCC's grid is made active the previous contents are deleted 

57476

Utilities

Export Table Schema Function Works Improperly if the USING Clause is Selected

58369

Utilities

Check database reports table does not exist on locations with relative paths 

58618

Utilities

Add link in PCC to 64-bit ODBC Administrator

58621

Utilities

GUI License admin not showing correct status of expired product key on Linux 

58699

Utilities

Monitorcli.jar outputs to STDERR 

58752

Utilities

Convert scalar on a longvarchar fails in PCC with java.io.eofexception 

58840

Utilities

Error string when user cancels logging into a secured database needs to be updated 

58881

Utilities

PCC says for server engine "NETBIOS is no longer supported"

58902

Utilities

PSA Log File is corrupted 

58914

Utilities

Monitor crashes while attempting to delete all users from the utility

58916

Utilities

Value listed is incorrect for “current number of files in use” on Monitor utility Microkernel Resource Usage screen

58944

Utilities

Telephone authorization utility clipaadm is not installed on Linux

59002

Utilities

Telephone authorization utility should discontinue if online authorization fails

59016

Utilities

Cobolschemaexec fails on PSQL Server 64-bit installation on Windows 64-bit OS

59075

Utilities

Preallocate on 64Bit machines causes permanent license to be disabled

59109

Utilities

Monitor utility running on a 64-bit operating system cannot delete an SQL active connection

59339

Utilities

Butil doesn't always handle blob's correctly during -LOAD using multiple segments 

59416

Utilities

Relational service stops way after PCC reported the service failed to stop 

59470

Utilities

DDFBuilder upcases path on Linux

59583

Utilities

BDU.exe crashes when the PSQL engine has no valid current license key available 

59641

Utilities

Confusing BCFG "Minimal State Delay" range values 

59698

Utilities

Pervasive PSQL v10 ODBC Administrator does not return the list of DSNs on remote Pervasive PSQL v11 Server.

59825

Utilities

PCC is no longer handling stored procedures properly