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

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

Targeted CR List for ASE 12.5.4 ESD #5

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
337672 The -I switch for srvbuild, srvbuildres and sqlloc on Unix platforms does not work and the interfaces file in the default location is always used.
370957 SELECT from a proxy table which is mapped to a remote table containing unsupported datatype will give error.
376069 DDLGen puts in "null" for "not null" columns in table DDL when "allow nulls by default" is true for a database.
381612 Improve the performance of DROP INDEX and CREATE INDEX by releasing the system catalog locks when not in DDL-IN-TRAN mode after the commit of the transaction but before post commit work started. This enhancement is triggered by -T3710 either at boot time or via DBCC TRACEON(3710).
415531 In rare case, ddlgen db is not compatible with dump/load
422771 Request for an option to return the data in encrypted form for the encrypted columns - in case the caller does not have decrypt permission.
430892 sp_cacheconfig will display wash size as '****** Kb' if the number of digits in the wash size is greater than 6.
433563 Unattended installations of servers using setup response files or sybatch resource files do not complete if the hostname begins with a numeric character even if the actual supplied name begins with a legal alpha character.
434146 The "Memory Used" value for sp_configure "total logical memory" is not updated when the size of a named cache is changed using sp_cacheconfig.
434482 In rare circumstances, the error "ubo_object_from_slot:Pss Invalid slot id 0" together with a stack trace which includes the modules pss_getunkept_pss, sysxacts__fmtrow_from_xdes end sysxacts_materialize may be reported in the error log during select from SYSTRANSACTIONS in a ASE with high transaction load.
437810 When foreign key and primary key are encrypted with same encryption key and they are tinyint, smallint, bigint, unsigned bigint the referential constraint did not work properly. When the constraint is violated, error 15450 was given instead of 547, saying 'Both primary and foreign keys must be encrypted with the same encryption key.'
437887 The message "Invalid column length: 12. Value must be between 0 and 10 for 'all-pages' row with minimum row length of 64" together with a stack trace which includes the modules 'collocate' and 'translate_varcols' may be reported in the error log when a database dump from a previous ASE version is loaded in a 64 bits ASE on IBM AIX.
438569 In console mode installation, line up the list of location tidily on Japanese environment.
438941 SUBQUERY: Occasionally, a sub-optimal plan is chosen when the query contains a subquery from an IF EXISTS clause. This is resolved under traceflag 15371.
440874 When a spid is killed on the remote ASE, the local ASE may be infected with signal 11 in ksct_startio when accessing proxy table mapped to the remote ASE.
441424 Following a seemingly successful installation of PC Client 12.5.4, two errors are encountered: + No mclib in java.library.path + This application has failed to start because javaai.dll could not be found. Reinstalling the application may fix this error.
441785 Subquery LT/LE/GT/GE ANY/ALL syntax cannot be quickpassed to remote IQ server 12.6 and above even though the IQ server supports the syntax.
442121 The execution of SELECT-INTO under the SET CHAINED option context must not trigger the implicit start of a chained transaction.
443277 One or more hard faults with type code 100001, "The page id, next page, or previous page value in the page header is invalid." is reported by DBCC CHECKSTORAGE when run against an archive database on which a transaction log has been loaded that encapsulates an ALTER DATABASE command.
443811 A task waiting on completion of a remote process (such as backup) cannot be killed
443885 ssl_alloc() errors during Distinguished Name (DN) Lookup when binding the admin account, "the access account", can cause the security principal to be "locked out" because too many unsuccessful login attempts can be quickly attempted, exceeding the installation standards for unsuccessful retries.
444221 When ASE is shutdown while RTDS is enabled in a session, server could potentially stacktrace. Does not consistently reproduce but more likely on HP platform.
444474 Adaptive Server ignores 'authenticate with' semantics when user attempts a kerberos login.
444905 srvbuildres -I parameter has no effect on the interface file
444992 The error 9947 with text "An attempt to allocate memory failed due to insufficient SQL Server memory." is not reported mistakenly but instead error 99 with text "Message empty." when DBCC CHECKVERIFY is run.
445278 SELECT INTO a temp table having UNION ALL and encrypted columns could result in wrong data in the target table and a subsequent select from this table will result in 15417 error.
445508 DBCC CHECKINDEX with bottom_up option may fail with error 15066, "No leaf row found for data page < datapgid > row < rowid > in leaf page < leafpgid > of indexid < indid > , table < tabid > ", when there are variable length key columns in the index. A stacktrace with module collocate can be found in the errorlog.
445871 The SQLDBGR can be disabled using traceflag 4083. The traceflag is a STARTUP ONLY traceflag and has to be specified while starting up ASE. Turning the traceflag ON/OFF while ASE is running will not have any effect on the state of the SQLDBGR.
446389 Added a new DBCC command to release memory from procedure cache or engine local cache. The syntax is as follows: dbcc proc_cache (free_unused | flush_elc) where - free_unused: free unused procedures from cache - flush_elc: flush pages from Engine Local Cache. This DBCC needs to used with care and when the system is not in heavy use.
448725 A timeslice error followed by the all_active_devices() and modules db_fill() may be raised when loading a very big archive database.
449148 The stored procedure sp_plan_dbccdb may incorrectly display archive database devices as recommended devices on which to install the 'dbccdb' database.
449417 'select on syscomments.text' configuration parameter doesn't restrict access to syscomments.text.
449518 It is possible to run ONLINE DATABASE after a LOAD TRANSACTION command that failed during recovery of the database.
449756 Adaptive Server Enterprise 12.5.4 ESD#2 running on unix platforms fails to provide a stack trace when an engine encounters a signal condition. Instead, the message "engine exited with signal < number > " is seen without any further diagnostics.
450105 The message 'current process infected with 11' in module 'level0_restart' may be reported in the error log when SP_SHOWPLAN is run or the configuration option 'plan text pipe active' is set and concurrent activity on table Syscolumns takes place. Modules 'showplan', 'showKeys' and 'getcolname_level0_fromcache' will also be reported in the stack trace.
450130 The error 8207 "Couldn't find an available descriptor for an object. Raise the value of the configuration parameter 'number of open objects' for more descriptors." may be raised in general, after errors 1204 were reported "ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS." when ASE runs out of locks during the instantiation phase of a descriptor's meta-data, resulting in leaking free descriptors mistakenly.
451934 Selecting from a decrypt_default table from a different database causes segment fault error.
451944 Loading a compressed archive database may hang if the size of the compression memory pool is set to the minimum size required that is the double of the dump blocksize. Even if the LOAD command succeeds, the hang can happen at anytime because the compression memory gets fragmented.
451945 When loading an archive database, the message 'Unable to determine the size of the device ' < devname > '' will be raised for each device installed that is unavailable.
451966 HA command, sp_companion may fail for HA-enabled dataserver on Sun Cluster 3.1 running on Solaris 10.
452610 The builtin function object_name() incorrectly returns NULL for any master-only system table in a database other than 'master', that has been loaded with a database dump of the master database.
452731 Added support of gbpinyin and gbpinyinnocs sortorders for Chinese character sets EUCGB, CP936, GB18030 and UTF-8. For existing installation, please run select sortkey(null, 'all') to populate syscharsets table with the new sortorders. And run sp_helpsort to get the new sortorder id.
452819 When the jconnect and ctlib send a varchar longer than 255 bytes,in some cases it could cause stacktrace in memalloc() with 702 error since it requests 2147483647 bytes memory.
453103 After primary service group fails over to secondary node, the primary HAase resource cannot go offline if the secondary ASE resource is already offline. The failure to go offline properly may also prevent primary HAase resource from going online on secondary node later even if primary ASE resource is brought back online.
453446 XPserver sometimes fails to come up on 64bit platforms with the following error in the errorlog, "os_syscmd: system function returned error. OS error string: Bad address".
453474 sp_help is enhanced to display the decrypt_default information for all decrypt_defaults declared on a table. This information consists of the internal name of the decrypt_default.
454029 The message 'Could not execute login script for user < username > ' will be incorrectly reported when the password has expired. In an HA environment, setting the password at the primary will fail to be replicated at the companion server with the same error message.
454137 The messages for errors 15082 and 15084 respectively "There are < value > OAM entries with zero used/unused page counts. Run DBCC < value > FIX on objid < value > indid < value > ." and "The OAM has no room for new inserts. Run DBCC < value > FIX on objid < value > indid < value > ." should not report "Run DBCC CHECKALLOC FIX" if DBCC CHECKALLOC was the command being executed, since CHECKALLOC can only be executed at the database level. Instead the relevant command that needs to be run later in order to correct this non severe problem will be reported, either TABLEALLOC, INDEXALLOC or TEXTALLOC.
454434 System wide password expiration will be ignored and a user with an expired password will be able to log into the server unless a password expiration policy has been defined using the stored procedure sp_passwordpolicy.
454460 Query executed from the trigger and referencing tables INSERTED or DELETED may fail with errors if the optimizer decides to apply a strategy which is using a worktable based on INSERTED or DELETED table.
460775 Enable LDAP User Authentication feature on Linux Opteron 64bit platform.
462989 Under rare circumstances, if the configuration parameters 'deadlock pipe active' or 'print deadlock information' are enabled or the switch 'print_deadlock_information' (traditionally trace flag 1204) is set, it is possible to get an error when trying to print the deadlock chain. The error text is "ubo_object_from_slot:Pss Invalid slot id < negative number > " followed by a stack trace that includes the modules pss_getunkept_pss() and lock__print_deadlockchain().
464797 The error "Current process infected with signal 11 (SIGSEGV)" followed by the text 'Error at address 0x0000000000000000' will be raised in DEC AXP when trying load or drop an archive database.
465234 Put fix for CR 445676 under trace flag 1236 to remove undetected deadlocks.

 

Related Links

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

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