History File

Problems Fixed in Pervasive PSQL v10.10

July 2008

Tracking Number Component Subcomponent Description
56164 Devcore CSI CSI static object not being flushed when all connections go away
56190 Engines_repl Core Replication service (replserv.exe) hangs sometimes
56888 Eventhandler_repl   Support for GUID data type in DX3.00.
52560 Install   Monconfig.txt has wrong level of security privileges
55169 Install   Long paths for installation destination results in error 1320
55194 Install   Install incorrectly detect the amount of disk space required, resulting in the install running out of disk space
55663 Install   Install not accounting for minimum space requirements on Win system drive
55913 Install   If ptksetup.ini is missing install seems to search for it outside the install folder.
55917 Install   Custom/modify installation option fails to install JRE.
55931 Install   Destination Folder uses same hot key combination for all buttons.
55965 Install   Setup Type selection screen has no default choice
55969 Install   Install repair not adding XIO feature when system is upgraded to be XIO compatible
55981 Install   Uninstall leaves v9.50 registry entry for V9.50 upgrade to V10
55989 Install   Deleting PCC.exe, *.ini and shortcut is not reInstalled with repair option
56000 Install   For canceled Install, rollback leaves "Pervasive Software" folder on target system
56038 Install Uninstall Uninstall\Repair\Modify requires reboot because of Install sequencing problems
56137 Install PSQL Install should not archive ecosystem manifest and readme files
56169 Install   XIO is not being Installed on a 32-bit Japanese OS machine with 4 GB of memory
56274 Install   PSQL ODBC drivers not installed correctly if registry or ODBC.ini references drivers in old location
56298 Install PSQL UnInstall errors with message to uninstall Beta if registry entry for ProductVersion is missing or not equal to 10.
56351 Install   All of the v9 PSA is left behind after upgrading to V10
56676 Install   WGE as Tray App doesn't open firewall properly on Vista SP1
56947 Install   Can't silently install Client32 on 64-bit Windows
56896 Install   Linux install does not provide JAVA
56975 Install   Custom Setup's Available Disk Space button is always grayed out
56991 Install   Visual Studio application may start the Microsoft Windows installer following an upgrade from version 8.60
57124 Install   Ubuntu install issues
57185 Install   PSQL Install: Modify/Repair/Uninstall does not generate log file on Vista.
57550 Install SDK ADO.NET SDK install is not localized for installation on Japanese systems
56026 Interface Btrieve Status 6 returned to a Btrieve API Delete Operation on 64bit Server
56993 Interface Btrieve Hang in Btrieve Test Application on Windows Small Business Server
53413 Interface DTI Linux DTI allows invalid characters in database names
56745 Interface DTI Incorrect error code "7042: Bound database requires data dictionary files " when run into folder permission error on database creation
57377 Interface DTI Enhance monitor APIs in DTI to support UTF-8
48941 Interface DTO DTO cannot start/stop DataExchange
54178 Interface DTO DTO.dll does not list table names
52117 Interface JCL Add support for BIT data type in Java Class library
56114 Interface   Status 7025 opening more than 100 sessions using DTI
57424 MKDE Cache Engine Cache engine hangs on Get Equal after detecting page inconsistency (escalation 177006)
55615 MKDE Dbsmgr Often cannot stop WGE when files are still locked
52192 MKDE MKDE Engine crash due to memory corruption involving fully qualified domain names
56003 MKDE MKDE Under certain conditions Insert with an auto-increment field may hang
56172 MKDE MKDE Archive logging does not work for Japanese named Btrieve files
56349 MKDE MKDE Japanese file names in a Roll forward dump file are garbled
56514 MKDE MKDE MKDE crashes in L2 cache with a very large file
56659 MKDE MKDE Enhance monitor APIs in MKDE to support UTF-8
56443 MKDE Win32 Note XIO activation in PVSW.LOG
53947 MKDE   MKDE shared memory reset does not log
55800 MKDE   Very large insert hangs engine
56121 MKDE   MKDE creates an extension file when it runs out of disk space
56171 MKDE   Status 113 displays when trying to roll forward an archive log file that is in use
56212 MKDE   MKDE trace file header is incorrect
56451 MKDE   MKDE crashes on rebuilding a very large file
56456 MKDE   Status 2 instead of 54 returned on corrupt file
56544 MKDE   Creating indexes leads to virtual memory running out
56563 MKDE   Status 19 returned when inserting large numbers of records in sequence into a Btrieve file
56840 MKDE   Inserting data into file with ACS(ISR) used two licenses
56983 MKDE   ESC176086 - Unable to load 2 copies of MKDE into memory
57099 MKDE   On 64 bit, L1 cache maxes out at 16 GB
57156 MKDE   ESC175196: heap corruption involving zero fill buffer
54720 MKDE   Would like status 146s to be logged to PVSW.LOG
56492 MKDE   ESC 175137 : Files do not fall out of AFL list causing status 86
56561 MKDE   System Cache is turned on automatically when L2 is switched off and Allocate Resources at Startup is on
56815 MKDE   OS handles not released on files in continuous operation
56919 MKDE   ADO connection fails to a secured database with mixed policy
57136 MKDE   ESC176572: Out of cache error with large temp table
57431 MKDE   Partitions of 2 terabytes cause 4 gigabyte segments to be created on non-segmented files
57123 PSQL   64 bit Linux app crashes when exiting
57154 PSQL   Add support for table index hint with stored procedures and user defined functions.
56156 PSQL   Cobolschemaexec turns CASESENSITIVE="true" into CASEINSENSITIVE in DDFs
56728 PSQL   Linux server does not shutdown in a timely manner
57311 PSQL   Code page problem on Japanese 64-bit operating systems with non-ASCII characters in secure database
57582 PSQL   Allow full license keys from different vendors to be installed on same PSQL engine
54156 Requester MIF Status 3106 not 94 returns with PAM authentication for access from an unauthorized user
54274 Requester MIF Status 3106 results from using URI's after a LOGIN
56175 Requester MIF MIF hangs when quoted path contains a null.
56178 Requester MIF Delay on B_Open if network not connected
56194 Requester MIF A single user on Vista uses two licenses
56313 Requester MIF Rolling forward Japanese named files by drive letter does not work
56342 Requester MIF Status 62 results when rolling forward if you create a dump file
56870 Requester MIF See esc 175822 : problem creating database connection when cache engine is on
57411 Requestor MIF Simultaneous remote requests may cause memory leak
57358 Requester NSL 64 bit NSL fails to connect to server if PARC is on.
56549 Requester NSL GPF in NSL from DOS application. Use of floating point errors on some machines.
56570 Requester NSL Clients hanging intermittently
56844 Sample   JDBC DBSample will not compile with Java 4 or later
54158 SQL Client SQLSetStmtAttr SQL_ATTR_PARAM_BIND_OFFSET_PTR causes wrong values to be inserted
56518 SQL Client When attempting to return a value that is the SUM of a NUMERIC(7,0) field, the query fails
56577 SQL Client E_FAIL using ODBC with BLOB data.
57483 SQL Client Relational interface crashes because of an invalid data packet from parameterized batch inserts
56046 SQL DRM Updating a CLOB to a null via PCC crashed the engine
56607 SQL DRM Engine crash instead of status 12 when trying to open a missing occurs table
56824 SQL DRM ESC 176003: Lost one byte from the stored procedure when it is saved through PCC.
56916 SQL DRM See Esc#175885 - Database Open fails on UNC paths or mapped drives
57140 SQL DRM ESC 176637: The SRDE hung with v10.00/v10.01
57315 SQL DRM Database engine crashes when updating on a TIME column with a dynamic parameter (escalation 176578).
56464 SQL Metadata engine ESC 175206: DX & SRDE is opening huge numbers of handles on the DDFs
56694 SQL SQL Engine ESC 175869: query that requests the UNION of two specific views causes an abnormal termination
56698 SQL SQL Engine ESC 175906: Using IN Clause in SQL Statement returns "General Error" message
56708 SQL SQL Engine SQL user names not allowing '\' char in name
56742 SQL SQL Engine View problem with duplicate view columns
56772 SQL SQL Engine ESC #176033: Restriction on aliased field using COALESCE crashes the engine
56774 SQL SQL Engine ESC #176033: Select CASE... AS ALiasID ... WHERE AliasID IS NULL returns no rows
56830 SQL SQL Engine ESC #176033: Create View changes DateAdd/DateDiff parameter
56835 SQL SQL Engine Calling stored procedure with null parameters not returning error
56843 SQL SQL Engine ESC 176200: DateTime will not sort correctly with TimeStamp data in DateTime field
56850 SQL SQL Engine ESC 176059: PSQL Engine Crash with a complex view
56853 SQL SQL Engine Engine crashes when unmatched select list is used with UNION and ORDER BY clause.
56867 SQL SQL Engine ESC 176231: Large query with UNION and ORDER BY DESC doesn't sort properly
56904 SQL SQL Engine CAST returns error on numeric/decimal in certain cases
56905 SQL SQL Engine ESC 176395: view columns cannot be used as passing parameters for UDF
56906 SQL SQL Engine ESC 176395: alias does not work in table subquery in certain cases
56960 SQL SQL Engine ESC 176512: GROUP BY with alias on a complex expression returns an error.
57291 SQL SQL Engine Cannot create a table name with non-ASCII characters in a secure database
57308 SQL SQL Engine ESC 176649: Problem with scrollable result set in Java with JDBC.
57316 SQL SQL Engine Database engine crashes if line or block comments in the query contain "?" (escalation 176822)
57429 SQL SQL Engine Local variables are not allowed in the select list with UNION in a stored procedure (escalation 177089)
57459 SQL SQL Engine SELECT count(*) from a view fails when statement contains aggregate functions with no GROUP BY
57462 SQL SQL Engine View fails if a subquery appears in ON condition along with INNER/LEFT/RIGHT/FULL join (escalation 177089)
54132 SQL SQL Engine Insert Loop in stored procedure stops early
55956 SQL SQL Engine Updating a CLOB data to an empty or NULL failed with "Invalid column number" error in PCC
56022 SQL SQL Engine No results returned when sub query contains TOP 0
56083 SQL SQL Engine SELECT query fails when ordered by same field as used in the left operator
56132 SQL SQL Engine Set ANSI_PADDING turned OFF as default
56149 SQL SQL Engine CREATE VIEW with table subquery and UNION fails with non unique column error
56152 SQL SQL Engine "Currency Not On Record" returned on query with UNION
56181 SQL SQL Engine UNION/UNION ALL and ORDER BY in INSERT INTO with SELECT
56182 SQL SQL Engine Fully support SELECT INTO
56191 SQL SQL Engine Incompatible types in Expression with stored procedure and Date parameter
56220 SQL SQL Engine Query causes Dr. Watson in ntdbsmgr.exe
56222 SQL SQL Engine VB/ODBC application gets a multi-step error when the legacy NULL date value is returned
56243 SQL SQL Engine GRANT LOGIN with empty password does not put user in group
56248 SQL SQL Engine LEFT function works differently than v9.50
56254 SQL SQL Engine Query slow, not optimizing correctly
56262 SQL SQL Engine Random crash with VARCHAR column in comparison routine
56273 SQL SQL Engine Engine crashes when running stored procedures
56281 SQL SQL Engine Cannot INSERT into a table with default handle in a stored procedure
56285 SQL SQL Engine Expression Evaluation Error when using IfNull in TimeStampDiff
56322 SQL SQL Engine SELECT INTO #temptable crashes after Timeout
56346 SQL SQL Engine Wrong results on query with table subquery with TOP clause and order by
56352 SQL SQL Engine LONGVARCHAR and LONGVARBINARY variables not working in stored procedures
56364 SQL SQL Engine ALTER TABLE failed with "constraint has already been defined" error
56365 SQL SQL Engine Query with 9.52 slower than 9.50
56376 SQL SQL Engine Select MIN with LIKE restriction returns incorrect results
56410 SQL SQL Engine Concatenating strings in stored procedure fails
56412 SQL SQL Engine Nested query is not producing proper results.
56416 SQL SQL Engine Query returns Unknown Error -19 in PCC
56424 SQL SQL Engine Query with DISTINCT and CONVERT returns status 29
56439 SQL SQL Engine Pauses and hang on v9 SP2
56502 SQL SQL Engine Query with UNION crashes engine
56505 SQL SQL Engine 4 byte memory leak by running TabSubQry.xml
56506 SQL SQL Engine Mixed Mode can't be setup with v2 database and DefaultDB
56515 SQL SQL Engine Space() string function with concatenation generates incorrect results
56519 SQL SQL Engine One byte memory overwrite when CLOB data is more than 65500 bytes.
56520 SQL SQL Engine UNION ALL in Stored Procedure can cause an engine crash in PSQL 9.5 Workgroup Engine
56536 SQL SQL Engine Constraint has already been defined error
56548 SQL SQL Engine Incorrect results using parameters in a stored procedure
56558 SQL SQL Engine Incorrect results with ROUND
56622 SQL SQL Engine PSP_COLUMNS is having problems with legacy data types and other types.
56744 SQL SQL Engine Empty parameters in scalar functions can cause problems
56771 SQL SQL Engine Engine crashes with SELECT in VALUES clause
56796 SQL SQL Engine Order By DESC does not return correct results with JOIN.
53573 SQL SQLMGR Reduce maximum LNA connections to 400
54349 SQL SQLMGR Linux SQLMGR logging too much info to event.log
56552 SQL Stored Procedure SQL_columns returns null for fields of type GUID and DateTime
53925 SQL SQL ALTER TABLE ADD PRIMARY KEY on nullable field should not be allowed
55955 SQL   PSP_COLUMNS returns (null) for data type, type name, etc. on columns created with type UNIQUEIDENTIFIER
56105 SQL   CSI performance enhancement
56150 SQL   No results on an occurs tables because a pushdown filter is applied
56438 SQL   Query performance slow compared to v8
56478 SQL   PCC returns different number of rows than PsqlDataAdapter
53208 SQL SQL Manager PCC returns "Unknown error: - 19" when it is unable to display properties on table due to index mismatch
55759 SQL   Print statement hangs PCC and other GUI tools
56318 SQL   PCC cannot cope with version 9.5x files with a large number of index segments
56689 SQL   PCC should return metadata version mismatch if exising DDFs that do not match the required metadata version
56748 SQL   Shouldn't be able to create database with '#' as 1st character
56755 SQL   ESC 175972: W3odbcei crash reading a variable in the DRM
57121 SQL   ESC #176619: Nested stored procedures not handling parameters correctly
57137 SQL   ESC 176572: The size of the SRDE internal temp file is limited to 2GB
57183 SQL   Japanese characters are truncated after data is inserted into UTF-8 encoded database via MS Access
57288 SQL   ESC 176868: TimeStampAdd can produce wrong information
57327 SQL   Security cannot be turned on for Japanese named databases on Linux
57339 SQL   With security on, Japanese tables and users cannot be created when database encoding differs from server
57342 SQL   On UTF-8 databases on Linux, Japanese named users cannot be used after being created
57405 SQL   ELECT query with a table subquery may cause other SQL statements to fail (escalation 177089).
57439 SQL   On Japanese systems, the timeout message from ODBC Client Interface is in English
57440 SQL   On Japanese systems, the "server not found" message from ODBC Client Interface is in English
56379 Utilities bcfg bcfg returns exception when invoked
56686 Utilities bcfg bcfg setting descriptions on Linux are garbage
52551 Utilities bdu BDU command line utility not interpret quotes properly
56081 Utilities bmon BMon handle information is incomplete.
57159 Utilities btadmin BTAdmin doesn't handle long usernames
54778 Utilities butil Butil -endbu command line syntax on Linux should display /A instead of -A
55842 Utilities butil On 2k3 64-bit server Butil and BDU are not performing as expected for DB authentication.
54848 Utilities DDF Builder [ALT]+[Shift]+[Q] on DDF Builder brings up Eclipse menu and functionality that are not documented
55279 Utilities DDF Builder Should persist preferences
56102 Utilities DDF Builder Autofix not creating valid definition
56104 Utilities DDF Builder When creating a new definition the PSQL Types view should be on top
56522 Utilities DDF Builder Column size changes automatically getting applied to next column
54957 Utilities DDF Builder DDF Builder 4.5 supported on local system only and does access data paths of databases on remote server
57080 Utilities DDF Builder DDFBuilder's Checkdb fails the files if they have lower case letters in name.
57082 Utilities DDF Builder DDFBuilder's Checkdb fails with files that have restrictive owner names.
57112 Utilities DDF Builder DDFBuilder Change Associates File Fails with UNC path
57164 Utilities DDF Builder DDFB provides no feedback when licensing errors are returned by engine
57260 Utilities DDF Builder DDFBuilder, Preview doesn't show BFLOAT data
57264 Utilities DDF Builder Checkdb fails table with null indexes any segment null
57275 Utilities DDF Builder DDF Builder not handling string segment mapping to multiple string columns
53261 Utilities Function Executor Add Null Indicator Bytes data type in Function Executor
53673 Utilities Function Executor The owner name entry to open the file in Function Executor is not encrypted.
54328 Utilities Function Executor GPFs on closedown if Btrieve Logout screen is open
56063 Utilities Function Executor Incorrect Key Position on Function Executor's Create New Btrieve File screen
56064 Utilities Function Executor When a new key segment is added in function executor the segment number does not increase
56070 Utilities Function Executor Adding and deleting keys in Function Executor leads to unexpected results
56072 Utilities Function Executor Problems coping with 9.5 file version files
56100 Utilities Function Executor Crashes on displaying version when no remote or local engine is available
57172 Utilities Function Executor Function Executor crashes on b_close operation
55901 Utilities Maintenance Incomplete path displayed while Loading,Copying,Saving data in Btrieve Maintenance Utility
56489 Utilities Maintenance When saving a large file with Maintenance the percent complete figure is totally inaccurate
54154 Utilities Monitor Unexpected error status 4124 when Monitor tries to connect to a machine that does not accept remote requests
56764 Utilities Monitor Monitor's "Total Requests Processed" and "TCP/IP Requests Processed" goes negative
52635 Utilities PCC PCC grid doesn't seem to be able to cope with big tables
53367 Utilities PCC The Configure Local Engine option after a Client Upgrade from 8.10 to 9.5 in PCC has a broken link.
53421 Utilities PCC Command buttons not provided with ALT + Letter in the properties for MicroKernel router window.
56006 Utilities PCC On a Japanese named machine changing the font of PCC's text output screen leads to an error
56129 Utilities PCC Relational Constraints returns "Invalid Row-Count in Subquery
56170 Utilities PCC Pervasive Control Center incorrectly starts the 64-bit version of ODBC Administrator
56391 Utilities PCC PCC opens all the databases on the machine when the database tree is expanded
56712 Utilities PCC PCC's Null and Case options can't be turned off
56799 Utilities PCC Rephrase wording on the Create Database dialog
54125 Utilities PCC PCC's table editor shows Null checked for legacy tables without nulls
54252 Utilities PCC Any CREATE TRIGGER that has a BEGIN and END failed in PCC
55938 Utilities PCC Properties on dictionary files does not bring back fieldnames or indexes.
56542 Utilities PCC PCC hint message specifies "Max Microkernel memory usage" setting in the wrong place
56602 Utilities PCC The Edit function for UDF, stored procedure and view in PCC fails
56647 Utilities PCC Edit Table Definition shouldn't lose default
56804 Utilities PCC Add ability to dump out all the create table/index scripts
56894 Utilities PCC Partially selected statement returns different results in SQL editor
56962 Utilities PCC PCC should allow user to edit an incorrect table definition
57046 Utilities PCC PCC returns Syntax Error when calling a Stored Procedure
57127 Utilities PCC PCC produces java heap space error while opening more than 19401 records from a table to the Text Window
57238 Utilities PCC When default browser is FireFox on Windows, PCC Welcome page link to release notes does not work
56371 Utilities PCC Cannot tell whether a view is trusted or not from PCC
56897 Utilities PCC PCC launches without any Java runtime version check
57032 Utilities PCC Update Export Table Schema feature to support legacy data types
57401 Utilities PCC Localize the JDBC resource strings for the Japanese language
57420 Utilities PCC Output grid displays only a single row for query with a GROUP BY clause
57452 Utilities PCC On Linux distributions, a PCC config file cuases extraneous folders to be created every time PCC is run
54017 Utilities PSA PSA Loaded Modules screen picks up single letter files in Windows directory
56326 Utilities PSC Crashes if service name is not supplied
55318 Utilities Query Plan Viewer Cannot properly display statements with many levels of joins
55899 Utilities Query Plan Viewer Query Plan Viewer contains a strange dialog header
56095 Utilities Query Plan Viewer Displays numerous Error Message boxes when there is no sub-query
56139 Utilities Query Plan Viewer W3sqlspy.dll and w3sqlqpv.exe fail to set resource version info
56216 Utilities Query Plan Viewer No longer displays the SQL being analyzed
56296 Utilities Query Plan Viewer Crashes if something is selected from the subquery menu when no query plan is loaded
56309 Utilities Query Plan Viewer "Query Plan File Open" file type selection dialogue has garbage in it
56312 Utilities Query Plan Viewer Crashes when the left hand side of the right hand pane is double-clicked
56303 Utilities Query Plan Viewer Help button on Query Plan Viewer's Open File dialog does not work
53740 Utilities Rebuild Allows setting pagesize to 16 while file version is 9.0
54231 Utilities Rebuild Creates temp file in source directory when output directory specified
56138 Utilities Rebuild GUI rebuild utility should add version info to the resource
56461 Utilities Rebuild Japanese Rebuild GUI is leaking memory
56533 Utilities   BCheck utility enhanced with addition to preload data
55480 XIO   XIOstats "View/OpenFiles" on menu needs to display filenames
56265 XIO   XIOStat "View > Open Files" menu option does not display what the manual says it should
56394 XIO   XIOStat crashes on trying to open a directory
56557 XIO   PSQL transactional service cannot acquire XIO cache driver on reboot
57329 XIO   On Japanese systems, XIOStats does not display certain multi-byte file names after files opened
57352 XIO   On Japanese systems, incorrectly encoded registry strings cause the XIO driver to not cache files