Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:638183

CR Number:   638183 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2010 Fixed Description Support LOB compression for UPDATE operations, including: 1) update with setting constant data 2) update with setting data from other columns 3) update with setting the column itself

CR:638193

CR Number:   638193 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2010 Fixed Description The replication of UPDATE query which is affecting some of the encrypted columns of a table may not work.

CR:638194

CR Number:   638194 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2010 Fixed 20 Dec 2010 Fixed 21 Dec 2010 Fixed 05 Jan 2011 Fixed Description Support DBCC check utilities for compressed LOB columns.

CR:638212

CR Number:   638212 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2010 Fixed Description Replication may fail while trying to insert duplicate rows on the target site when normal TEXT/IMAGE columns of a table are converted to encrypted columns.

CR:638275

CR Number:   638275 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2010 Added to user documentation Description In CR 325947, we expanded out the "by other" information in sp_sysmon to include "by unpin". However, "by Log Marker" is another line item that has no description in the docs anywhere.

CR:638436

CR Number:   638436 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2010 Fixed Description In a multi-node cluster, a shutdown with a timeout smaller than one hour could be sleeping for exactly one hour if any process in a remote node was sleeping and did not wake up to check if it had received an attention.

CR:638447

CR Number:   638447 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Report all SQL processing errors during upgrades.

CR:638454

CR Number:   638454 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE Bit datatype to support NULL or add boolean datatype to ASE so we support this values "NULL, 0 ,1" Workaround Description  Do not use BIT datatype use some of the Integers datatypes.

CR:638488

CR Number:   638488 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2011 Fixed 26 Jan 2011 Fixed 23 Mar 2011 Reservation Made Description A SELECT query after USE DBNAME in the same line may look up a previous cached statement in another database and raise 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." Workaround Description  Vicky's suggestions: 1) adding a 'go' after each 'use dbname' or 2)specify dbname for the object name

CR:638556

CR Number:   638556 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2011 Fixed 19 Jul 2011 Fixed Description A 623 error, "Adaptive Server failed to retrieve a row via its RID in database '<dbname>' because the target page is not a data page... pageno = 0 ..." may be reported during the execution of LOAD TRANSACTION command using the WITH UNTIL_TIME option from a transcation dump that was dumped using the WITH NO_TRUNCATE option. Workaround Description  Do not dump with no_truncate, OR Use the not documented until_rid option load tran <db> from <file> with until_rid = (<pg>, <row>) where the rid value can be found using dbcclog command in sybmon

CR:638628

CR Number:   638628 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description doc bug: add circumstance to 913 error in Troubleshooting Guide

CR:638736

CR Number:   638736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani beta3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2010 Fixed 13 Jan 2011 Fixed 08 Feb 2011 Fixed 02 Mar 2011 Fixed 18 May 2011 Fixed 14 Jun 2011 Fixed Description (Internal only) RAT: LTL enhancements for replication definition elimination.

CR:638743

CR Number:   638743 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2011 Added to user documentation Description NumRows is not documented in sp_spaceusage

CR:638779

CR Number:   638779 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2010 Fixed Description A stack trace may occur for queries with long GROUP BY lists greater than 32 keys.

CR:638786

CR Number:   638786 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2010 One-off Provided 20 Sep 2010 Fixed 13 Oct 2010 One-off Provided 13 Oct 2010 One-off Provided 18 Oct 2012 Fixed Description Parallel activity on tables related with RI constraints may lead to deadlocks

CR:638837

CR Number:   638837 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2010 Bundled Request Description sp_spaceusage sets ExpRsvdPages and PctBloatRsvdPages to null when the reservepagegap being set to null

CR:638838

CR Number:   638838 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2010 Fixed 14 Sep 2010 Fixed Description Job Scheduler installTemplateXml.bat contains some syntax errors.

CR:638843

CR Number:   638843 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2010 Fixed Description Total Task Switches reported by Task management section in sysmon report is inconsistent with sum of individual contributions on each engine for both SMP and CE servers.

CR:638972

CR Number:   638972 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description referential_constraint_create_list_from_sql defines a list of foreign keys to migrate. If this parameter is set to <ALL_OBJECTS> then all foreign keys in the database will be migrated. If the parameter auto_select_dependent_objects is also set then any object that depends on the foreign key will be migrated. When both referential_constraint_create_list_from_sql and table_create_list_from_sql are both set, both provide a list of objects to migrate. The list of foreign keys does NOT depend on the objects identified for migration by table_create_list_from_sql. Workaround Description  N/A

CR:639001

CR Number:   639001 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2010 Fixed 11 Oct 2010 Fixed Description If one of the input row's length for a hash join exceeds the server's pagesize and the hash join resorts to a nested loops strategy, then wrong results could be returned. The input row's lengths can be determined by running with trace commandline flag 9529. Workaround Description  [torr 17th sep 10 ] tested t15393 and still getting no rows /remote/cases/11620000s/11620426/pseinfo-12/Repro/query.dss_T15393.out [sogden 17th Sep 10] dbcc traceon (15393) --avoids the issue plan, reason tbc. ---- Workaround: set distinct_sorting off --this will result in GroupSorted Distinct directly after the outer join which doesn't suffer the problem. --or set compatibility_mode on

CR:639030

CR Number:   639030 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2010 Fixed Description In SDC, when configuration option 'CIPC regular message pool size' is configured not enough, user may hit error 8211 when try to access the table from remote node.

CR:639043

CR Number:   639043 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2010 Fixed 23 Jan 2014 EOL'd version. Not to be Fixed. Description For multiple node cluster, when there is only one instance left in the cluster, dropping a global database may fail due to corresponding locks are not able to be reclaimed.

CR:639045

CR Number:   639045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2011 Fixed Description Under some rare condition, Msg 913 might raise when pagesize() is used with other builtin functions or UDF functions in a query.

CR:639046

CR Number:   639046 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2011 Fixed 03 Jun 2011 Fixed 07 Jun 2011 Fixed 05 Jul 2011 Fixed 07 Jul 2011 Fixed 31 Oct 2011 Fixed 01 Nov 2011 Fixed Description Localization is supported by MDA table. New Language columns are added to monTables, monTableColumns, monWaitEventInfo and monWaitClassInfo. User can use the where clause to specify the language for a query.

CR:639111

CR Number:   639111 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2010 Fixed Description During quorum creation time, any "additional run parameters" specified in the cluster portion of the input file will be incorrectly stored as the secondary interconnect protocol, preventing the Adaptive Server instance from booting.

CR:639158

CR Number:   639158 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for using of column alias in a WHERE, HAVING clause

CR:639227

CR Number:   639227 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2010 Fixed Description The message "Received the following error message from the Replication Server: Msg 2056. Line 1, character 8290: Incorrect syntax with ' '" may be reported in the error log as a result of uninitialized database id.

CR:639234

CR Number:   639234 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2010 Fixed 22 Nov 2010 Fixed Description In a multi-node cluster, a SIGSEGV can be seen in the function lock__wait during alter database operation. The stacktraces in the errorlog would have strings like lock__common(), lock_object() etc.

CR:639254

CR Number:   639254 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 9996\12905\12323 may be seen after non-clustered index creation on dol table. The conditions leading to this are data specific and rare. This may only occur on a non-binary sort order server. Workaround Description  dbcc traceon (12604) --disable suffix compression on create index

CR:639296

CR Number:   639296 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2010 Fixed 22 Sep 2010 Reservation Made Description When statement cache is on, a non-dbo user may access a dbo-owned table instead of its own table when both tables are using same name and a previous access to the dbo table was done.

CR:639428

CR Number:   639428 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2011 Duplicate Description Feature request for a method to change table ownership.

CR:639547

CR Number:   639547 Product Name:   SCC Web Framework Product Component:   Repository Status:   Closed OS:   Generic Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2010 Fixed 15 Sep 2010 Fixed Description The LDAP login module was not including the roles read out of the LDAP server when mapping to uaf/scc roles (only the roles defined as login module options were included).

CR:639557

CR Number:   639557 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2010 Fixed 10 Nov 2010 One-off Provided Description With I/O fencing enabled AIX may encounter a timeslice if a lot of devices are used.

CR:639568

CR Number:   639568 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2010 Fixed 20 Sep 2010 Bundled Request Description If a high volume of connect/disconnects using client-side password encryption a SIGABRT may occur with a stack trace with the following message: "ks_falloc: Cannot allocate using ubfalloc"

CR:639579

CR Number:   639579 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2010 Fixed Description Wrong parameters passed to error message 886 in the code, leading to garbage values in output.

CR:639652

CR Number:   639652 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2010 Fixed 03 Sep 2010 Presently Not Targeted For Any Future Release Of This Product Description Adaptive Server 15.5 ESD #3 Removing duplicate wait even IDs and descriptions to monSysWaits and monProcessWaits monitoring tables to improve their wait event reporting and eliminating situations in which the same wait event ID was used to report more than one wait event.

CR:639702

CR Number:   639702 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2010 Fixed 01 Sep 2010 Reservation Made 03 Oct 2010 One-off Provided Description If the datachange builtin is used on sysobjects.name there is a possibility of a 706 error. Workaround Description  trace flag 15352 turns off expression histogramming.

CR:639802

CR Number:   639802 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2010 Fixed Description Allow column alias (AS clause) in subquery SELECT list. But the alias is not useful and can't be referenced in other parts of the query. This is only to avoid syntax error.

CR:639811

CR Number:   639811 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2010 Fixed 12 Oct 2010 Fixed Description Adaptive Server 15.0.3 Cluster Edition hits error 866, when a cache configured with 'Relaxed replacement scheme' is accessed heavily.

CR:639813

CR Number:   639813 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2013 Fixed 23 Apr 2013 Fixed Description Execution of stored procedure 'sp_renamedb' from read-only database results in a 3906 error, "Attempt to BEGIN TRANSACTION in database failed because database is READ ONLY." Message should reflect that "You must be in master in order to run stored procedure for read-only database." Workaround Description  For read-only database, execute sp_renamedb from master and not from the database that will be renamed.

CR:639826

CR Number:   639826 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2010 Fixed 12 Oct 2010 Presently Not Targeted For Any Future Release Of This Product 11 Oct 2010 Fixed 10 Oct 2010 Reservation Made Description UNITEXT column values are not being translated correctly when loading a database dump that was taken on a Solaris system, into a database on a Linux system. Workaround Description  using at least 15.0 esd #13 version of bcp (CR 489378): bcp out from source, truncate table on target, bcp in. Or, use select into a new table before dumping on source.

CR:639852

CR Number:   639852 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2013 Not a Bug Description When the option 'set merge_join' is turned on, a join query on a remote column with a different sortorder from the local column may get a wrong result. Workaround Description  Disable merge join via 'set merge_join off' for queries having both local table and proxy table if the two servers have different sort orders.

CR:639877

CR Number:   639877 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2010 Fixed 14 Oct 2010 Reservation Made Description Using the LIKE operator, ranges enclosed in square brackets containing embedded square brackets are not interpreted properly. Where '[x]' like '[[]x]' should evaluate to TRUE.

CR:639969

CR Number:   639969 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2011 Fixed Description A 530 message, "Attempt to insert NULL value into column <column_no> in work table (table id -<table_ID>); column does not allow NULLS. UPDATE fails." may be encountered when executing queries involving derived table and aggregation functions. Workaround Description  set compatibility_mode on or use temporary table instead of derived table.

CR:639976

CR Number:   639976 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Print procedure plan information from procedure cache

CR:639977

CR Number:   639977 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2010 Fixed 16 Sep 2010 Reservation Made Description Under specific circumstances involving an outer join to a view\derived table containing an aggregate (or possible other virtual expression) and a further outer join may result in a sub-optimal query plan. Workaround Description  set compatibility_mode on

CR:640007

CR Number:   640007 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2010 Fixed Description An optional third argument has been added to the charindex() builtin function. This argument can be used to give a starting position within the string-to-be-searched that is passed to charindex().

CR:640009

CR Number:   640009 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2010 Fixed 30 Sep 2010 Reservation Made Description A single asterisk (*) is allowed to be used as a non-EXISTS subquery SELECT list if the subquery is selecting from a single table/view/derived table with a single column. It will function as SELECTing the single column explicitly.

CR:640014

CR Number:   640014 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2010 Fixed Description Allow multiple SELECT items for EXISTS subquery SELECT list. The existence test function stays the same. Each of the multiple items will be treated the same way as with a single SELECT item for the EXISTS subquery.

CR:640221

CR Number:   640221 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2012 Fixed 04 Jul 2011 Duplicate Description Default/ specified log size may be incorrect when log is bound to a named cache Workaround Description  1) Run sp_logiosize to change the log io size after each reboot, or 2) Create a pool in default data cache with the same page size as the pool in the named cache.

CR:640224

CR Number:   640224 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2010 Fixed Description An unexpected colon may get appended to the dump file names when using a large number of stripes with Backup API library. Workaround Description  Using native compression (with compression =) rather than the external library (compress::) may avoid the problem.

CR:640259

CR Number:   640259 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2010 Fixed Description sp_displayaudit output does not include tables that have a negative sysobjects.audflags value (which indicates auditing of encryption_key operations). Workaround Description  Rewrite sp_aux_displayobjaud, audflags > 0 should be replaced with audflags !=0 (in 2 (all) places).

CR:640317

CR Number:   640317 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2010 Fixed 20 Sep 2010 Fixed Description When converting a very large unitext value into text where heap memory may run out,712 error will be raised with sig11 from s_result_const_memfree->free__linkedcst->memfreeheap.

CR:640329

CR Number:   640329 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2010 Fixed 14 Oct 2010 Fixed Description In rare circumstances the message "current process infected with 11" in the module 'ptn_pdes_install' together with a stack trace which includes the modules 'dorecover' and 'db__create_sysaltusages_map' may be reported in the error log when an archive database is being recovered.

CR:640484

CR Number:   640484 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide an historical MDA table for monitoring stored procedure usage. This table should provide similar information to what is contained in monSysStatement and monProcessStatement. The data that is captured at the statement level in monSysStatement will be aggregated to the stored procedure level.

CR:640541

CR Number:   640541 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2010 One-off Provided 06 Dec 2010 Fixed Description Error message 14702, "XMLPARSE(): XML parser fatal error <<An exception occurred! Type:RuntimeException, Message:The buffer manager cannot provide any more buffers>> at line <line_number>, offset <offset_num>" may be reported when parsing XML documents with large number of namespace prefixes.

CR:640552

CR Number:   640552 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2011 Fixed Description A mismatch between the Config Value and the Run Value will occur during booting of the dataserver if a load of sybsecurity database had resulted in less tables than configured for. The mismatch will be seen when executing sp_configure 'current audit table'. Workaround Description  set 'current audit table' to 1 before enable auditing after load sybsecurity database

CR:640630

CR Number:   640630 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2010 Fixed 05 Oct 2010 Fixed 20 Oct 2010 Fixed Description On windows only, although the t-sql builtin current_bigdatetime returns a bigdatetime, the microsecond portion is always zeros.

CR:640658

CR Number:   640658 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2010 Fixed Description Objects opened by cursor would be missing in monProcessObject while the open is being processed.

CR:640720

CR Number:   640720 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description After you rename an index name on a proxy table by sp_rename system procedure, update statistics command with the index name may raise a 2727 error. Workaround Description  Reboot ASE or run dbcc cacheremove(dbid, objectid)

CR:640768

CR Number:   640768 Product Name:   Adaptive Server Generic Docs Product Component:   XA Guide for CICS Encina and Tuxedo Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2010 Added to user documentation Description CIS text length limitation warning is incorrect

CR:641055

CR Number:   641055 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Solaris Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.5 ESD #3 30 Nov 2010 Duplicate 15.5 ESD #3 30 Nov 2010 Duplicate Description srvbuildres/srvbuild will fail on solaris 10 machines which have ldm installed but not run Workaround Description  Two workarounds: 1. To remove the ldm file. Customer can't use it as they don't have the permission 2. export SYBASE_SAM_CPUINFO=OSCMDFORK before running srvbuildres. This works for the customer

CR:641091

CR Number:   641091 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2011 Fixed 26 Jan 2011 Reservation Made Description When running "sp_configure 'mnc_full_index_filter', 3", which will set the optimizer criterion full_index_filter=1, a poorly performing plan may be generated in circumstances whereby a query is running under rowcount (or top) and the lead order by column doesn't have an entry in the predicate and is the lead key column of an index. In this circumstance, the index will not be costed and if this table is placed outermost in the plan, a complete scan of the table and a sort to generate the order prior to application of the row count is used. Workaround Description  set compatibility_mode on --sort avert should avoid the poor plan

CR:641109

CR Number:   641109 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2010 DEFER 08 Oct 2010 Fixed 21 Feb 2011 Fixed 08 Feb 2011 One-off Provided 18 Mar 2011 One-off Provided 20 Sep 2012 Fixed Description The message "current process infected with 11" in the module 'getvalue' together with a stack trace which includes the modules 's_retparams' and 'execproc' may be reported in the error log when an INSERT statement is run on a table having an encrypted CHAR/VARCHAR column, the configuration parameter "statement cache" is active and the INSERT statement was previously cached but it had to be recompiled or renormalized because, for example, all the query plans were in use or the schema for the underlying table changed. Workaround Description  Disable statement cache

CR:641156

CR Number:   641156 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2010 Not reproducible with latest version of the product available as of Resolution Date Description Stacktrace occurs when a TDS fetch cursor command involving proxy columns is executed from external clients.

CR:641192

CR Number:   641192 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2011 Fixed Description Reboot of a cluster edition server may fail to recover local system temporary database, when model database is loaded from a lower server version dump, but not onlined before reboot. The errolog will contain message "infected with signal 11" in the module 'obj_id' along with a stacktrace which includes the modules 'recover_tempdb', 'upgd_upgrade_db'.

CR:641253

CR Number:   641253 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   Solaris Original Version:   2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2010 Fixed Description On Solaris, when ldm is installed but the connection fails (e.g. when the daemon is not running) a message similar to the following is raised and certain SySAM 2 enabled applications terminate: "Failed to connect to logical domain manager: Connection refused". Workaround Description  Two workarounds: 1. Ensure that ldm is usable or removed, i.e. remove the following utility or make sure the following command works: /opt/SUNWldm/bin/ldm ls -l -p 2. Set the following environment variable before running the product installer. It should be set to nothing afterwards (SYBASE_SAM_CPUINFO=) or removed from the SySAM properties file: SYBASE_SAM_CPUINFO=OSCMDFORK

CR:641258

CR Number:   641258 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2010 Fixed Description New functionality has been added that allows a dump of a database (other than the master or sybsecurity databases), on a server running 15.5.x Cluster Edition, to be loaded into a database on a server running 15.5.x non-Cluster Edition. This can be disabled using trace flag 3411.

CR:641272

CR Number:   641272 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2010 Fixed 20 Sep 2010 Fixed 28 Sep 2010 Fixed 29 Sep 2010 Fixed Description ErrorNumber value is not correct in monErrorLog for some special messages.

CR:641445

CR Number:   641445 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   usse Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request a functionality to generate an XML schema from part of an XML model

CR:641535

CR Number:   641535 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2011 Fixed Description sp_sysmon output may sometimes show negative value for the total task context switches due to "Other causes".

CR:641536

CR Number:   641536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2010 Fixed 20 Oct 2010 Fixed Description In multi instance cluster setup when an instance fails, while performing instance failover recover, we may hit SIG11 with call stack having lock__rest_indoubt or hang where task keeps sleep waiting for the cluster lock request but there is no sign of request in the cluster.

CR:641613

CR Number:   641613 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2010 Fixed 07 Jan 2011 DEFER Description When configuration parameter "enable unicode normalization" is set to 0, UNIVARCHAR parameters to dynamic SQL statements are treated as having zero length, which is equivalent to a NULL value. Workaround Description  Change the ODBC DSN configuration parameter "Normalize Unicode Strings" to 1. This will result in ODBC's converting Unicode strings to the server's character set, which if configured to UTF-8 will result in no conversion errors.

CR:641679

CR Number:   641679 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2012 Fixed Description sp_helprotect truncates the objectname when it is greater than 30 characters. Workaround Description  Fix is to change the sp_helpproct procedure code varchar size of objnae from 30 to say 60 in two places: 1) line #1012: create table #temp_obj(id int, number int, objname varchar(30)) to create table #temp_obj(id int, number int, objname varchar(60)) 2) line#1029: create table #temp(id int, number int, objname varchar(30), colnam e varchar(30) null) to create table #temp(id int, number int, objname varchar(60), colname varchar(30) null)

CR:641692

CR Number:   641692 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2012 Bundled Request Description sp_bindcache: allow indexes to use named cache the table is bound to as default

CR:641696

CR Number:   641696 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2010 Fixed 18 Oct 2010 Fixed Description The message "infected with signal 11" together with modules like "AnyOverUnderCheck(), StMergeHistCatalog::StmhApplyBoundary()" may be encountered when using update statistics on a bigdatetime or bigtime column. Workaround Description  Do not use bigdatetime/bigtime for columns where statistics are required

CR:641732

CR Number:   641732 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to restart ASE License heartbeat after it died.

CR:641735

CR Number:   641735 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2010 Fixed 17 Jan 2011 One-off Provided 17 Nov 2010 Fixed 21 Nov 2010 Fixed Description Cluster lock space rebuild takes lots of time and as CLM rebuild is blocking operation cluster is hung for several minutes. Workaround Description  "dbcc lockgc" helps reduce the time of the hang.

CR:641842

CR Number:   641842 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2011 Fixed 23 Nov 2011 Fixed Description When an invalid database dump is first loaded, a subsequent attempt to load a transaction dump will not report a useful error message to the end user.

CR:641955

CR Number:   641955 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Msg 17870 from sp_indsuspect due to non-existance temp table for sp_autoformat

CR:642002

CR Number:   642002 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2010 Reservation Made Description CURRENT_TIMESTAMP is unsupported in ASE.

CR:642018

CR Number:   642018 Product Name:   Adaptive Server Enterprise Product Component:   sql Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2014 Insufficient priority to fix Description In ASE, using TOP, it is possible to specify rows [1 ... N], but not to bias this to rows [M, M + N - 1].

CR:642023

CR Number:   642023 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2010 Fixed 17 Mar 2011 Fixed Description The values of InstanceIO column in the MDA table monStatementCache is incorrect when queried on SMP server.

CR:642038

CR Number:   642038 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2012 Fixed 17 Sep 2012 One-off Provided Description On Platforms other than x86 Linux and Solaris Sparc, the rdesmgr_spin spinlock was hot in some scenarios.

CR:642236

CR Number:   642236 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2011 Fixed Description A new option, LOG OFF, has been added to the ALTER DATABASE command to shrink log fragments.

CR:642331

CR Number:   642331 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2010 Fixed 08 Nov 2010 Fixed 19 Nov 2010 Fixed Description Installmaster 2901 error (Exception stack limit exceeded) and signal 11 stack trace against 15.5 ESD release on HP-UNIX Itanium and Windows x64 platform. Workaround Description  increase 'max nesting level' via sp_configure to get bigger exception stack

CR:642345

CR Number:   642345 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2010 Fixed 23 Jun 2011 Fixed Description Under some rare circumstances when the "no free space acctg" database option is not set, the time taken to recalculate the free space counts after an impolite shutdown can be unnecessarily long.

CR:642558

CR Number:   642558 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Under certain circumstances, it is possible to execute an online database <dbname> while the same command is still executing. Executing he same online request twice can lead to errors being reported and the online command failing. Workaround Description  Avoid issuing multiple simultaneous online database <dbname> commands for the same database.

CR:642571

CR Number:   642571 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2010 Fixed Description A SELECT using an IN clause with more than 128 elements on a table with an indexed encrypted column fails with an infected with 11 in stu_bincharinter Workaround Description  trace flag 15393 will avoid the problem.

CR:642735

CR Number:   642735 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2010 Fixed Description Sometimes, boot recovery takes long time due to synchronous reads on sysobjects table

CR:642776

CR Number:   642776 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2010 Fixed 08 Oct 2010 One-off Provided 28 Oct 2010 Fixed 21 Jul 2011 Fixed 18 Sep 2012 One-off Provided 11 Sep 2012 Fixed Description SELECT INTO proxy table may fail silently when inserting NULL into the proxy column.

CR:642812

CR Number:   642812 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.5 ESD #4 19 Dec 2010 Fixed 09 Feb 2011 One-off Provided Description In ASEClusterEdition, under some rare conditions, graceful shutdown of a cluster instance may crash the instance being shutdown and result in failover.

CR:642878

CR Number:   642878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature Request for RepAgent Thread ... add clientname, clienthostname, clientapplname to LTL

CR:642992

CR Number:   642992 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Errors 21, 913, and 3413 may be reported during recovery if a user-defined recovery order has been defined using sp_dbrecovery_order and the configuration includes a dbid that no longer exists. The defined order is stored in sysattributes with class = 10 and attribute = 6 Workaround Description  The recovery order is stored in sysattributes where class = 10 and attribute = 6. Delete the entry for the missing database and adjust the ordering of the remaining rows.

CR:643035

CR Number:   643035 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature Request ... ASE add clientname, clienthostname, clientapplname in xact log records

CR:643041

CR Number:   643041 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for arrays and tables as native T-SQL datatypes that can be declared as variables, returned by user defined functions, etc.

CR:643124

CR Number:   643124 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   usse Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When you copy a complex type which has other (complex/simple) types underneath, the result is that not only the top-level type is copied, but also all other types linked to it, too. This however should not be the case.

CR:643125

CR Number:   643125 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description preupgrade: should run dbcc checks on sybase system databases.

CR:643152

CR Number:   643152 Product Name:   SCC Web Framework Product Component:   Navigation Status:   Closed OS:   Windows XP Pro Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2010 Insufficient info provided Description Resources not always retained in perspective after logging off SCC.

CR:643168

CR Number:   643168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2010 Fixed 15.5 ESD #3 12 Oct 2010 Fixed Description Transfer table command for import returns 'unknown error' while file is not found instead of ' error 2: No such file or directory'. There is no effect on the table.