History File

Problems Fixed in Pervasive PSQL v10 For Windows 7

November 2009

 

Tracking Number

Component

Description

58434

Install

Win SE silent install fails to Win 7 machine

58159

Utilities

Monitor's SQL Connection Manager Active Sessions dialogue displays incorrectly on Windows 7

58358

Utilities

PCC task bar icon is too small in Window  7

58149

XIO

XIO cannot be installed on Windows 7

 

Problems Fixed in Pervasive PSQL v10 SP3

November 2009

 

 

Tracking Number

Component

Description

58340

Install

Missing files on reboot after install of v10.x to existing v9.x directory

58127

SQL

Select with ORDER BY on COBOL Variant file returns incorrect results

58248

SQL

Unable to update table inside stored proc

58356

SQL

SQL engine crashes when dropping an open Cobol table

58382

SQL

Select query with CASE on a view is causing the engine to crash.

58447

SQL

58447Null value in binary column in legacy table is blank-filled

58441

Utility

Default setting for case insensitivity in PCC and DDFBuilder is wrong for the Japanese locale

58450

Utility

PCC the "change connection encoding" property selection for a database hangs

58451

Utility

PCC does not recover gracefully from the PSQL engine restart

58461

Utility

PCC  EOF error on Create Stored Procedure

58471

Utility

PCC does not display relational constraint properly

 

Problems Fixed in Pervasive PSQL v10 SP2 Update 1

September 2009

Tracking Number

Component

Description

58370

SDK

DTI's PvAddTable deletes Btrieve file if an index is specified incorrectly

58423

SDK

PDAC-TPvQuery updated to handle milliseconds value

58128

SQL

Select with Order by DESC on COBOL table returns status 62

58129

SQL

SQL Engine crashes if Variant table doesn't have an entry in variant.ddf

58130

SQL

Cobol table not showing data for variable length Btrieve file

58245

SQL

LEFT and RIGHT SQL string functions are behaving incorrectly with multi-byte Japanese data

58326

SQL

Using OLEDB, the MAX function is truncating last byte of a char data

58357

SQL

sum(-Amount_owed) returns error "Numeric value out of range"

58359

SQL

SQL with order by clause returns "Null not valid" error

58372

SQL

SQL Engine crashes on Update using subquery with the same table name

58386

SQL

Engine crashes due to index range comparison with OR (BINARY comparison)

58389

SQL

Engine crash when inserting 160Mgs of binary data

58391

SQL

Random crash using null string with a LIKE clause

58395

SQL

Incorrect results if using index with filter conditions in the WHERE clause on COBOL table

58396

SQL

Pvattrib/Attrib.ddf created with compression to improve performance

58398

SQL

SQL Engine crash when incorrect syntax is used with the CAST function

58407

SQL

Invalid date/time/timestamp error from UDF call in Stored procedure

58191

Utilities

Monitor does not display sessions if there are more than 135

58346

Utilities

Import utility uses a more than expected number of handles

58397

Utilities

clilcadm -c KEY fails to clear the key

58390

XIO

XIO cache driver will not start on Windows 7

 

Problems Fixed in Pervasive PSQL v10 SP2

August 2009

Tracking Number

Component

Description

57704

Core

Workgroup Engine crashes when DataExchange is used to remote gateway data files

57963

Core

OLEDB returns error PS_MSG_N4821 with database security on and DDFs and data files in different directories

57752

Install

Silent install fails to apply temporary license

58019

Install

Silent install of Workgroup Engine always installing as an service

58048

Install

Uninstall very slow with Windows Installer 4.5

58059

Install

PSQL v10.10 FTF switching Workgroup Engine running as a service to running as a tray application.

58078

Install

Correct installation messages pertaining to Samba as a requirement

57965

Install

Dmidecode required for Linux RPM installs

58106

Install

Upgrade Install leaves previous version items in Control Panel's Add/Remove Programs

58132

Install

Disable optional install feature for XIO by default on all systems.

58161

Install

PSQL upgrade with DataExchange 3.00 fails to properly stop and start services

58184

Install

XIO does not work on re-install if you fail to reboot after un-install

58221

Install

Linux install not applying a temporary license

58233

Install

Upgrade fails to remove duplicate items from Add/Remove Programs entries

58269

Install

Show correct product version when an incompatible SDK is detected

58278

Install

64-bit CLI License Administrator is all in English on a Japanese install

58201

Install

Correct warnings caused by improperly formatted PSQL initiation scripts on Linux

57592

Interface

PvGetOpenFileName causes Backup Agent not to work correctly

57997

Interface

OLEDB application crash

58052

Interface

MS Excel cannot open a table that contains Numeric data types via OLEDB

57588

MKDE

Function Executor crashes database engine

57729

MKDE

File and data deleted when Btrieve CREATE issued with invalid key number

57777

MKDE

Cache Engine plus L2 caches fills L1 cache by not releasing index page hold counts

57800

MKDE

Archival logging file is created with last letter missing

57837

MKDE

20 character database name corrupts ADT list.

57872

MKDE

MKDE ZString and WZString index compares can possible corrupt FCR key entry

57881

MKDE

Database engine crashes if Monitor has too many files open

57909

MKDE

Escalation 179037: OLEDB application encountered permission error when cache engine is running

57917

MKDE

Make Insert, Update, and Delete action atomic for DataExchange

57922

MKDE

Engine crashes with invalid position from Btrieve API get_direct() call 

58076

MKDE

Correct engine logging messages pertaining to Samba

58087

MKDE

Minimal state option can cause a fault during restart

58195

MKDE

Memory used by database engine increases each time it reverts to minimal state

58235

MKDE

Database engine crashes on SUSE 11 64-bit during services startup

58283

MKDE

Database engine not started when SUSE 11 Enterprise starts

57878

PSQL

Database engine is not resolving the cluster name to the local host name in Windows 2008 cluster

57938

PSQL

ALTER TABLE command fails to change the scale of NUMERIC

58083

PSQL

SQL problem with subquery's alias view name in FROM clause

58096

PSQL

NUMERICSLS data type does not check precision correctly

58117

PSQL

COALESCE does not return correct SQL error status

58165

PSQL

Insertion into DATETIME column truncates data

58167

PSQL

Milliseconds get truncated to seconds inside a stored procedure

57955

Requester

"CB001: Unknown Error" with cobolschemaexec utility

57724

SDK

Status 29 seen on executing VAccess's DdfCreateTable

57551

SQL

ADO.Net application returns an error after numerous calls to a user defined function

57675

SQL

Database engine crash triggered by query timeout

57650

SQL

Database engine crash when CURRENCY value updated via dynamic parameter

57701

SQL

Rounding issue with CONVERT

57731

SQL

Customers program fails to insert multiple rows

57737

SQL

System stored procedure psp_indexes() not returning results

57762

SQL

Escaped single quote in sub-SELECT returns syntax error.

57766

SQL

Connection string failing with status Run-time error -2147467259 (80004005)

57802

SQL

Simple SQL query returns the wrong results

57804

SQL

Engine crash on SQL statement against COBOLSCHEMAEXEC created tables.

57809

SQL

Engine crash running UNION ALL query with "empty quote" 

57810

SQL

Engine crashes running SELECT CAST query

57859

SQL

Bad DDFs crash engine instead of returning error

57861

SQL

Database crashes on ADO move command against a temporary file

57865

SQL

Query plan does not capture DELETE statements

57866

SQL

TIMESTAMPADD returns incorrect year when adding 21 months.

57871

SQL

UNION returns two extra rows

57879

SQL

JDBC is returning only one record running a stored procedure

57894

SQL

Status 2 errors are not reported back to the calling ODBC program

57896

SQL

INSERT with SELECT succeeds even though the column does not exist

57897

SQL

OEM/ANSI conversion causes problems in a PDAC application

57907

SQL

LIKE comparisons with wild cards return incorrect results in stored procedures

57932

SQL

JDBC 2 returns wrong results with TYPE_SCROLL_SENSITIVE cursor

57934

SQL

Server hung because of deadlock

57937

SQL

REPLACE statement within stored procedure not working

57950

SQL

Running SQL query in Access with Ccur function to convert to currency is returning "ODBC call failed" message

57956

SQL

ADO update is failing when cursor location is set to server

57964

SQL

SQL disconnect crashes database engine because of cached stored procedures

57973

SQL

Engine crashes if query contains combination of ANSI and traditional joins in the FROM clause

57987

SQL

Incorrect data return in PCC Grid versus Text

57993

SQL

SELECT with OR clause returns each row twice

57998

SQL

Wrong results because of subquery expression in the SELECT list

57999

SQL

Enabling security scrambles order of VIEW list

58012

SQL

Code not executing in stored procedure if it encounters empty begin/end block

58018

SQL

UPDATE statements sometimes unexpectedly return Status 80.

58020

SQL

ORDER BY cannot handle explicit column names if the SELECT * query has a UNION in it

58056

SQL

Create new NUMERIC data types for COBOL with compiler option -Dcb

58061

SQL

TIMESTAMP and DATETIME not handling second fractions correctly

58069

SQL

SQL operating on NUMERIC data containing spaces causes engine to crash

58085

SQL

Insertion of 0 in binary column via PCC grid crashes engine

58101

SQL

Bad Index in DDF causes engine to crash

58105

SQL

TIMESTAMP 0001-01-01 00:00:00.0 returned as null instead of midnight in GMT

58133

SQL

Engine crashes when using stored procedures with many parameters

58143

SQL

"Error writing to OutPut Parameter 2" error message when executing stored procedure

58185

SQL

SQL statement run in the PCC on DemoData causes an engine crash.

58220

SQL

Deadlock between meta data engine and DataExchange

57695

SQL

SELECT WHERE date_field IS NULL not returning correct results

58322

SQL

SQL results incorrect because filter is always false

57603

Utilities

License Administrator fails to apply license key

57509

Utilities

Monitor displays "Input parameter value is invalid" errors and eventually hangs with Japanese named files

56846

Utilities

Rebuild utility does not using registry value for file format

57720

Utilities

SELECT statement returns only 200 records in PCC grid

57817

Utilities

License Administrator does not load on a Japanese OS

57895

Utilities

PCC export data function causes engine to crash

57954

Utilities

PCC not determining number of rows for the grid properly.

57985

Utilities

Query Plan Viewer not opening files associated with qpf extension when file double-clicked

57986

Utilities

Query Plan Viewer crashes on file open

58111

Utilities

SQL query in PCC causes engine crash

58236

Utilities

Clilcladm -i parameter with -server argument results in 'Error connecting to server local' message

58266

Utilities

License Administrator crashes on trying to connect to older server engines

58280

Utilities

Clicladm returns wrong message when username and password not used to remote Linux server

58301

Utilities

License Administrator does not work against a local Workgroup Engine