| Bug ID | Description |
| 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. |
