Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar

Search for    in all of
view all search results right arrow
Support > Technical Documents > Document Types > Technote > Targeted CR List for ASE 12.5.4 ESD #4  
RSS Feed

Targeted CR List for ASE 12.5.4 ESD #4

The purpose of this document is to help Sybase customers obtain a general idea of potential bug fixes in future Adaptive Server Enterprise (ASE) EBF releases. Please be sure to read the Disclaimer and General Notes below.

Disclaimer: This document lists the targeted (not committed) fixed CR list for the release listed above. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. Sybase does not commit to releasing EBFs on the specified dates or to including the CR fixes in the said EBF. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that Sybase may decide not to release an EBF that was previously scheduled for release.

Bug IDDescription
306295 dbcc checkstorage will unnecessarily abort after it receives an error 9962, "Access to table '%.*s' index '%.*s' in the target database failed." This can occur when dbcc checkstorage attempts to gather metadata for a table that is being dropped.
347837 Fixed the return type java.lang.string for build-in function msgproplist.
368480 (1)Incorrect value is displayed for 'File block count' and 'Total data stored on the volume' in the LOAD ... WITH LISTONLY=FULL command when loading across platform. (2)On linuxia32 and ibmplinux platforms, if a dump file size on a tape or a capacity value exceeds 4GB, an append of a dump file to the tape could fail or fail to report an appropriate error message which tells there is no room to append on the tape.
378442 BCP IN operation may report 2404 error when unilib conversion is enabled.
379911 For socket migration engine 0 is always a possible target. When using specific execution binding, the socket migration does not restricts the search to the set of engines associated to the execution class.
388670 The command LOAD WITH VERIFY[ONLY] is not supported on cross platform load, however it was allowed causing all sort of invalid verification errors.
392556 sp_monitorconfig reports a high value for Num_Reuse output per pss resources and doesn't correlate with the values displayed in column Num_Active.
395240 Dump database on tape using "with compression = compress_level" option works fine but load fails with a read error.
415058 When a user who schedules a job has a different user name on the target server than he has on the Job Scheduler server, the job does not run because the login to the target server fails at runtime.
415912 Memory allocation in the network memory pool may fail in a boundary conditions even when memory is available. The failure to allocate memory may manifest as failure to allocate large network memory pools.
417097 The LOAD TRAN command may hang after raising a 938 error reading "Database ' < DBNAME > ' is unavailable. It is undergoing LOAD TRANSACTION" followed by the message, "Forced flush of database id < DBID > failed". This may happen under very rare circumstances where the LOAD TRAN command is used many successive times to recover a huge set of log records representing around 1 billion page changes.
417542 Added support for nocase sortorder for Chinese and Japanese character sets. Under the nocase sortorder, ASCII and accented characters are sorted in case-insensitive manner, CJK characters are sorted in Unicode binary order. Please run sp_helpsort to get the sort order id.
418448 Siginal 11 could happen in _lopConsCmds() when the query contains a correlated subquery and the correlation is on some outer query block other than the immediate parent outer query block. Here is an example: select 1 from t17a where 1 in (select cint2 from t17c where cint2 < = (select (select 100 from t17b where t17b.ctype = t17a.ctype)))
419141 After abnormal termination of a network listener, a new listener cannot be started on the same port.
419513 DUMP TRAN will hang when attempting to truncate the log after an out-of-space error is reported in the scratch database of an archive database that is being dropped.
426064 Enable the JMS message property "ttl".
428341 When ASE is started with the Express Edition license, it is possible to exceed license limits on total disk space by using the "disk reinit" command.
428591 Under rare circumstances the "AUDIT PROCESS" system task and a user session that is in the process of auditing may block each other without ASE being able to solve this blocking situation.
436110 New feature to display the ammount of compression memory recommended to run DBCC CHECKSTORAGE in the stored procedures sp_plan_dbccdb and sp_dbcc_evaluatedb.
437444 Error 696 occurs, in temporary databases, as a newly allocated page is over-written by a work table oam page, in some rare cases.
438155 A 913 error, "Could not find row in sysdatabases with database id < dbid > . Run DBCC CHECKTABLE on sysdatabases." may be reported after loading a database and executing a stored procedure that inserts explicit NULL values in columns declared as java classes.
438705 Under very rare circumstances, a 694 error reading "An attempt was made to read logical page ' < Page Number', virtpage ' < PageNumber > ' from virtual device ' < DeviceNumber > ' for object ' < ObjectId > ' in database ' < DbId > '. The page was not read successfully. You may have a device problem or an operating system problem." may be raised for a page belonging to the log segment.
439857 Error 102 and 105 may occur when inserting a single or double-byte single quotation mark into a unicode character column on a proxy table.
440501 SSL: isql sessions hang when doing a select query and the negotiated packet size is 4096 or greater.
440570 Use new click-through licenses texts in click-through license pannel of installer screen.
440757 A new builtin switchprop() is added. Passing a switch-name or -number to the switchprop() builtin will return a status which contains the switch properties.
441012 Enable the input parameter column size used in a web service proxy table to be automatically generated based on the ASE page size.
441020 The minimum password length of system encryption password does not match the minimum password set in sp_configure.
441140 Under rare circumstances an undetected deadlock may occur between the housekeeper 'HK_WASH' system task and a session that performs a DML command in a table whose database has mixed log and data segments when that table uses a cache that has a memory pool configured.
443447 Execute immediate query performing query with LIKE clause using inherited local variables or parameters fails during the compilation of the statement. Stack trace is dumped to the errorlog file and shows modules opt_like, opt_like_and.
443558 A 15703 error,"Failed to delete row(s) from sysaltusages in the scratch database" will be incorrectly reported when trying to drop an archive database if the rows that describe the scratch database and the associated devices have been manually deleted from sysattributes.
443605 SH_INTENT Deadlocks occur on SYSCOLUMNS when concurrent queries using cross-database objects are normalized while utilities (such as drop of an index) holding EX_TAB lock on SYSCOLUMNS are in progress.
443769 A 691 error, "Encountered invalid logical page '0' while accessing object < negative id > in database '2'" may be reported when there are more then 128 disk fragements for tempdb database.
444143 In rare circumstances, two transaction logs that were dumped within a fraction of a second of one another, can be loaded in either order. Using the wrong order will have unpredictable effects on database recovery.
444516 Query with DISTINCT and ORDERBY directives may return incorrectly sorted or duplicate rows if special OR strategy is used to execute the query. For such strategy showplan information shows "Using N Matching Index Scans" for a query step selecting from the table. This problem may happen only if some non equality search arguments are used in the query like > or > =.
444558 When a ASE session having RTDS 4.0 enabled is killed (kill -15), we could potentially see a stacktrace.
444723 On MacOS platform, printing messages to console is now made non-blocking in order to prevent the server from potentially getting hanged whenever console output is blocked. This behaviour can be disabled using traceflag 4082.
445130 If a database device is unaccessible the database was being marked suspect.
445306 Execute immediate query with CASE expression using local variables inherited from the outer scope does not work correctly producing stack traces.
445676 A cursor application with a granted SH_INTENT lock is placed in the wait queue when requesting an EX_INTENT lock and another connection has a granted SH_TAB lock on a the object. Once the connection holding the SH_TAB lock exists, the cursor application continues to wait even though its EX_INTENT lock is compatible with the granted locks of the object.
446610 In Server Config, user cannot see the server name in the list when clicked "Configure Adaptive Server...", "Configure Backup Server...", or "Configure Monitor Server...".
446789 Enabling the 'per object statistics active' configuration option may cause degradation in query performance.
447769 The 692 error, "Server '%s', Line 1: Uninitialized logical page '%d' was read while accessing object '8' in database '%'." will be seen when loading locally or remotely a dump that has been taken using a local backup server version 12.5.4 ESD#3 at a remote backup server with a previous version. It will also happen if loading any sort of dump using a local 12.5.4 ESD#3 backup server and a remote backup server with a previous version. In the first case, the dump file generated is corrupted and it cannot be loaded in any manner. In the second case, although the dump file is correct, the combination of local 12.5.4 ESD#3 backup server and remote pre 12.5.4 ESD backup server will result in this correct dump being incorrectly loaded.
448043 The maximum length of the variables used in the command DUMP DATABASE TO @var1 STRIPE ON @var2, will be incorrectly set to the length of the value assigned to them if any of the file names used contains the library prefix 'compress::' and more than one stripe is used. If the variable is reused in the same batch to store a longer string, it will be truncated to the length of the shorter one.
448324 Query using ANSI outer joins with false constant clause in the ON list may return empty result set if the optimizer is using reformat strategy to execute the query.
448402 The execution of a stored procedure created with the option "with recompile" may fail the error 225 if it accesses a non temporary table created inside the procedure.
449011 Job Scheduler templates fail to install on Solaris.
452558 Update the bundled JRE release to address the following issues: 1) The implementation of RSA signature verification in SSL/TLS, or other application scenarios, may incorrectly verify forged signatures leading to security vulnerability. See for more details. 2) U.S. Daylight Saving Time Changes in 2007, see for more details.


Related Links

Last Revised: Feb 16, 2007
Product: Adaptive Server Enterprise
Technical Topics: Error Message, Database Admin, Bug Information, Troubleshooting
Business or Technical: Technical
Content Id: 1044172
Infotype: Technote

© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics