Switch to standard view 
  Sybase logo
 
 
 



Targeted CR List for ASE 12.5.4 ESD #3

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 ID Description
340568 A 5888 configuration error, " Two Named Caches with the 'cache status' defined as 'default data cache' is not allowed" may be reported in case of case-insensitive server during boot or while verifying the entries of a configuration file using the sp_configure.
356855 A 6.92.1.1 error, "OPERATOR: The version of the label format on the volume mounted on device \\.\tape0 is different from the current version.Replace the volume with a new volume to be overwritten." is reported on executing the second dump database command to the tape if Backup Server was started with switch "-b".
360954 When executing system procedures that have non-ANSI comparisons such as "if @var = NULL", some procedures may show unexpected behaviour if 'ansinull' is set 'on' in the session from which the procedures are executed.
366032 The DBCC command PRSQLCACHE will print the whole text of the statement cached as opposed to its first 255 characters only.
373906 For an infected process, the signal names are not printed in the error log.
379119 The sp_sysmon application monitor report does not report data for processes or applications.
380036 Socket migration is vulnerable to interruption by signals
389154 If a very large transaction is rolled back then "KILL < spid > WITH STATUSONLY" may report negative values.
389409 The message "current process infected with 11" in the module 'memcpy' togther with a stacktrace which includes the module 'ct_get_data' may be reported when accessing parsed XML documents using a local proxy table mapped to a remote proxy table that has an external directory defined on it.
389523 In rare circumstances on a heavily-loaded multi-engine system, when java is enabled, 10707 errors may be reported in an errorlog while deserializing java objects due to serialVersionUID mismatch between stream and local class.
390371 select into encrypt is NOT failing with error 11776 when identity columns are encrypted.
391536 Under rare circumstances, a timeslice error in module 'des__do_unlink' may be reported in the error log when a session tries to drop a dynamic statement. The module 'lwp_drop' will also be reported in the stack trace.
394843 XFS: Update to filename in proxy tables mapped to file system directories using the recursion option may fail with error message Msg 11277 when a constant string is concantenated to the filename.
399023 Feature request: improve time to open Stored Procedures Folder within Sybase Central ASE plugin
400327 The error 216 "Attempt to automatically drop temporary table failed." may be raised when the configuration parameter "number of locks" is under-configured.
401190 A 102 error, "Incorrect syntax near ''." , may be unexpectedly reported when using "batch updates" (sending several dynamic sql statement executions in the same batch) and the statement that was already prepared had to be recompiled because, for example, the underlying table schema changed.
402632 Backupserver might delete shared memory with id 0 when dump command fails.
404941 Dump with native compression to tape fails with error number 22. This has been fixed for the NT and Linux platforms.
406317 Java-based ASE Plugin interface does not provide a way for user with expired password to update their password.
408777 LDAPUA bind and search requests do not have configurable retries for failed operatations. There is also no configurable maximum number of ldapua descriptors per engine and no configurable ldapua error message and average time logging interval.
409640 On platforms other than Windows and MacOS, 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.
414495 ASE does not shut down XP Server during a shutdown with nowait
417431 ASE simply displays an error message returned by the LDAP Server without explaining the reason(s) for the error.
417573 The message "current process infected with 11" in the module 'ksmask__complete' together with a stack trace which includes the module 'ksmasknserver' may be reported in the error log. This stack trace may be repeated a few times followed by ASE listener failure with a stack trace accompanied by the messages in error log such as 'kernel nopen: accept, Software caused connection abort', 'kernel nopen: accept, Invalid argument', 'kernel Listener with protocol tcp, host < host-name > , port < port-number > , engine 0 is quitting after a fatal error.'
418116 Selecting a column from a view containing unions of proxy tables may cause the front end isql to crash in core dump and segmentation fault.
418234 SELECT INTO (existing table) remote columns from remote TEXT/IMAGE source may result in Msg 280/3651/557 when the source columns comprise of more than one table from the same remote server.
419380 In rare circumstances, 511 error "Attempt to update or insert row failed because resultant row of size 1965 bytes is larger than the maximum size (1964 bytes) allowed for this table." or 9557 error "The server failed to create or update a row in table 'sysstatistics' because a varying-length column would start at offset 8192." is reported for sysstatistics during ONLINE DATABASE command after the database was loaded across platform.
421084 The message 2843, "The dynamic statement '%.*s' could not be found. This may be due to insufficient metadata descriptors. Increase the serverwide '%s' parameter or the '%s' parameter." is incorrectly raised when multiple spids are running the same LWP in a multi-engine ASE environment.
425471 Enable LOAD TRANSACTION on an archive database.
425693 In rare circumstances, on a multi-engine system, the message "current process infected with 11" together with a stack trace in ubffree may be reported in the error log while loading java classes.
425945 On IBM AIX 5.1, when ASE tries to allocate shared memory larger than 16G, the error message "kernel os_find_good_keyfile: Found shared memory segment: key 0xce0013ac, id 1048593 kernel os_find_good_keyfile: If SQL Server using it is not running, remove it by hand kernel os_find_good_keyfile: Too many dangling memory segments, nead a clean up kernel kbcreate: couldn't get shmid for kernel region. kernel kistartup: could not create shared memory" may be reported in the error log.
429969 Error message 5018, "Caution: You have set up this database to include space on disk < n > for both data and the transaction log." may be raised in error during CREATE, ALTER or LOAD DATABASE if the database has any disk fragments allocated on virtual devices between 248 and 255.
430088 Backup Server process dies on HP Tru64 when a child sybmultbuf process dies or is killed.
430101 Sybase Central ASE Plug-in from 12.5.4 ESD#2 supports load transaction for archive databases.
430103 A convenient method for an administrator to look at logged-in spids, to determine which authentication mechanism (Kerberos, PAM, LDAP, ASE) was used for the login is needed.
430169 ASE running on the Windows platform may display a stack trace terminating with "NULL PSS on stack overflow" in the event that shared memory cannot be allocated at startup. Note that failing to allocate shared memory (maybe due to machine resource limitations) will always prevent ASE startup but should not cause the stack trace.
430553 An unexpected 557 error "The cursor ' < cursor name > ' can not be used as it could not be found. It is possible that either it was not declared or it is not available in the current context." may be raised or the message "current process infected with 11" in the module 'execudf' may be reported in the errorlog if a JAVA user defined function that uses the internal JDBC ASE driver is executed a high number of times (more than 30000) by the same connection and at the same time one or more cursors are active on that particular connection.
432175 When ASE resource governor is configured for transaction elapsed time resource limit, stored procedure whose execution time exceed the configured limit may hit TDS protocol errors instead of the expected 11005 error reading "Transaction's running time exceeded limit of < TimeLimit > ."
432377 DDLGen does not generate 'sp_cachestrategy' statements for tables, indexes and constraints when 'mru' and 'prefetch' are set to off.
432573 sp_setrepproc with no argument reports duplicated rows if multiple languages are installed to ASE.
432700 Using integrated logins on Windows, user may see error 4002 'Login failed' from ASE if the user account name includes uppercase letters. Rebooting the Windows domain controller may temporarily fix the problem.
433386 All processes in the server can become blocked when auditing is enabled and the sybsecurity database is quiesced.
433456 ASE running on Linux kernel 2.6 and above on linuxia32, linuxia64 and ibmplinux platforms encounters I/O performance degradation. This is because librtkaio support has been withdrawn on these linux kernel versions and by default POSIX AIO is used. Enable trace flag 1649 to use Linux Kernel Asynchronous IO.
433656 Under some circumstances the execution of a stored procedure when a procedure contains statement like CREATE INDEX, UPDATE STATISTICS or DROP TABLE followed by a SELECT statement from a view in a database different than the current database.
433691 When Job Scheduler executes a job, for some passwords, the job may fail and messages like "Login Failed" is seen in the job history The jsagent log also shows following errors : "Client message: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed." and "ct_connect() failed."
433740 The message "timeslice -501, current process infected" together with a stack trace which includes different modules like 'memalloc', 'make_orstruct', 'parscpy' or 'q_or_find' may be reported in the error log when a query with a long IN list is executed.
433781 When selecting data from an unprefixed table that is created in a stored procedure, if the same table exists owned by DBO, the data will be incorrectly read from the DBO owned table.
434118 The error 803, "Unable to place buffer '0xnnnnnn' from cache 'default data cache' holding logical page ' < pgno > ' in sdes for object 'sysprotects' - either there is no room in sdes or buffer already in requested slot." followed by a process termination will happen when granting access to a group that contains more than 11 users that already have the same access granted with grant option.
434152 sp_displaylogin does not show the password as 'expired', when the password expires due to password policy option 'expire login'.
434201 Feature to retrieve ddl for all triggers for a table without table definition. DDLGen generates ddl for all triggers of a table. The value to be supplied in the name parameter '-N' would be < dbName > . < tableOwner > . < tableName > . < triggerName > . Please note that if DDL is to be generated for all triggers of a table then in the above -N parameter '%' should be used for trigger name. Also note that -D parameter cannot be used when generating DDL for all triggers of a table.
434339 Allow a database dump of the master database to be loaded into an archive database.
434373 Bulk copying data using the BCP utility into proxy tables mapped to DirectConnect for Oracle (DCO) version 12.6 and above may not return any error messages to the BCP client when a constraint violation error is encountered while inserting data into the Oracle database.
434625 DBCC CHECKALLOC or TABLEALLOC may deallocate a log page considered to be the last log page in the dbtable. Enhance the fix option of these DBCCs to remove the reference to lastlogbp in the dbtable if this page gets deallocated because it is no longer the root page for Syslogs.
434640 In rare circumstances, a deadlock may arise between a user task running RPC and the site handler task after which no more connections to the remote server will be accepted by Adaptive Server.
434657 When debugging a T-SQL batch putting breakpoints in procedures with long names, the debugger just continues without stopping on the breakpoints set.
434781 ubffree gets infected with 11 during a disk init operation when attempting to free a memory fragment.
434865 Usage of local variables in execute immediate may sometimes not work as expected for varchar and char variables : result of expressions involving local variables may be trunacted.
435218 A session that runs a SELECT-INTO-UNION query that uses the identity() builtin may hit error 8221 "Couldn't find the identity column for object < value > " and hang forever while undoing the creation of the given target table.
435250 The client issuing job scheduler command with 'sp_js_wakeup' hangs forever.
435400 CIS: A 191 error, "Some part of your SQL statement is nested too deeply", may be reported when a query containing a very large number of conditions in the where clause is executed in quickpass mode
435430 Enable LDAP User Authentication feature on HPIA 64bit platform.
435692 Pattern matching with LIKE clause may sometimes provide incorrect evaluation when it is done on unichar or univarchar columns.
435715 An 840 error, "Device ' < devname > '(with physical name ' < physname > ', and virtual device number -1) has not been correctly activated at startup time", will be reported when trying to access an archive database at boot time, when one of the stripe devices has been physically deleted.
436216 If "exec_procedure" audit option is turned on and you run a stored procedure with a parameter containing double-byte characters over 255 bytes, the audit records may be split in the middle of one of double-byte characters.
436746 ASE may now report in module collocate() the error message "Invalid DOL data row pointer: row < value > with status < value > must be the forwarded row location instead of the home row location." and the call stack of the given session as opposed to silently continue.
436747 Initialization of kernel asynchronous I/O context through io_setup() fails with an error EAGAIN while bringing an engine online.
436961 Under rare circumstances error 803 "Unable to place buffer ... either there is no room in sdes or buffer already in requested slot." may be raised with a stack trace in module "pg__allocate_completion" leading to error 1127 "Internal Error: The OAM has no room for new inserts ..." in module "pg__insertoam" during the execution of an INSERT command in a table that has more than one OAM pages allocated to it.
437225 On 32-bit Linux platform while extending "secondary cache" by 2GB or more, server may encounter timeslice error.
437321 RepAgent has incorrect encrypted password for dump database.
438272 A 3478 error, "During undo the page timestamp value is less than new timestamp from log ... ", may be reported during ONLINE DATABASE after loading a database dump that was taken when a SELECT INTO command was active (but incomplete).
438354 The message "current process ... infected with 11" may be reported with a stack trace in the error log in module "dbt_cacheremove" during the execution of dbcc dbcacheremove() when execute cursors exist and are not closed in the database being uncached.
438509 An UPDATE may incorrectly set varchar column to NULL value instead of a single space. This happens if the UPDATE is executed in the stored procedure and the value to be set is passed as the procedure parameter and represents a string of spaces. This problem happens only if the option string_rtruncation is set.
438558 The error 678 "Invalid Buffer Cache Access: Could not open object < value > in database < value > " may be raised followed by the message "Illegal attempt to rollback transaction (xactname '$chained_transaction') that has already committed" when committing a transaction that has a select into command followed by a drop of the table just created. The problem is restricted to use of large page allocation, objects with Data-Only-Locking, databases with "ddl in tran" active and "set chained on" option.
438660 SELECT queries may result in getting the system date, causing degradation in query performance.
438703 The option WITH NO_INFO is added to the SET SWITCH command syntax to suppress any informational warning being sent to the client. This option has only effect on informational warnings, error messages when necessary are still being raised.
438748 When user select 'No' on the change password option, when 'expire password' option is set, the connection is not released. This fix addresses this issue by closing the 'pre expired login connection'.
438854 A batch inserting data to the table which has a default referencing global variable may fail if there are some other global variables referenced in the same batch. Stack trace shows module subglobals().
439236 If statement cache is enabled, the value of the global variable @@error will be reset if it is accessed in a batch together with a statement that gets cached.
439503 Procedure cache memory allocation may fail in certain boundary cases, if procedure cache request results in a procedure cache pool growth after a new shared memory segment allocation.
439895 The error 1105, "Can't allocate space for object ..." may be incorrectly reported, if the "greedy allocation scheme" is enabled on a table that has text/image columns and non-clustered indexes that are affiniated to distinct user defined segments.
440030 When complex password policy option "disallow simple passwords" is set, ASE checks for login name contained in the password are case sensitive. With this fix, ASE will do a case insensitive comparision to avoid the use of login name with mixed upper and lower case letters in the password.
440031 When complex password policy options are set using sp_passwordpolicy, installmaster may fail with 9578, 17720 and 17231 error messages.
440127 When an external login is mapped to an ASE login with a different name, if the external login password is changed, it should be updated in the mapped login if there is a one-to-one relation, but this is not happenening.
440175 LDAP or PAM logins that were added using ASE older than 12.5.4 will not allow external authentications to failover to ASE logins, if authenticated by ASE 12.5.4 or later
440232 In 12.5.4, ASE Plug-in failed to re-open "Add Trigger (Template)", after a trigger has been created using the template. This problem is seen for all compiled objects - defaults, rules, procedures etc. when a template is used for creation of these objects.
440401 Lack of disk buffers, in some rare cases, may result in a segmentation violation during a create database command.
440855 Query using multiple worktables to resolve aggregates or provide distinctness or the order and performing dynamic index strategy to resolve OR predicate may fail with different errors related to sort operations including error 1509 "Internal error encountered in merging rows; resubmit query batch." Sometimes query execution may fail with stack trace logged in the errorlog. The module shown in the backtrace is bld_dynindex.
440923 The message "current process infected with 11 in the module sendtext()" together with a stacktrace which includes the modules 's_execute', 'exec_eop' and 'run' maybe reported in the errorlog when running a SELECT with a UNION ALL clause and ORDERBY selecting text or image columns from a table.
440932 In rare circumstances, the message "current process infected with 10" in the module 'lddb__stat_translate' together with a stacktrace which includes the modules 'lddb__unscr_stat_page' and 'lddb__unscr_usro' may be reported in the errorlog when running LOAD DATABASE across platform where the endian type is different. Other errors, like 'Invalid column length' error, 1142, 692, or 12315 error may be reported.
441433 Under rare circumstances a session may hang forever during a lock request despite ASE having granted the lock to the session. This is a side effect from the fix of CR 399737. The modules "lock__semawait", "log__lock" and "lock_psema" will be reported in the call stack of the hanging session.
442494 On IBM and Mac platforms, a 15760 error, "Invalid dump header when loading the database with ID ' < dbid > '" is reported when an archive database is loaded using a database dump for which a sysdevices row has already been created using the 'sp_addumpdevice "archive database"' stored procedure.
443596 Stored procedure may stop working returning errors related to too high number of worktables used in the query. This happens if the procedure executes SELECT INTO with query producing worktables (order by, distinct, group by, materialized views) and requires recompilation.
443668 Under rare circumstances DBCC TABLEALLOC may hang forever when executed with the FIX option to correct error messages "There are < value > OAM entries with zero used/unused page counts. Run DBCC TABLEALLOC FIX ..." when the OAM entries needing cleanup are the first in the list.


Back to Top
© Copyright 2010, Sybase Inc.