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

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

CR:589879

CR Number:   589879 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2009 Fixed 20 Oct 2010 Insufficient priority to fix 22 Sep 2009 Fixed Description Error 10865 when increase the in-memory storage cache size.

CR:590027

CR Number:   590027 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2009 Fixed 01 Jun 2010 Presently Not Targeted For Any Future Release Of This Product Description Hit the error 1950 while creating an index by primary key constraint on a partitioned table.

CR:590032

CR Number:   590032 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2010 Fixed Description Error 6901 is always reported as occurring in dbid 0 rather than the actual database containing the high timestamp value. Check @@dbts in each database to find the database(s) that actually contain high timestamp values.

CR:590183

CR Number:   590183 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) 22 Sep 2009 Fixed Consult Complete Description In rare circumnstances, sp_monitorconfig might report higher Max_Used value than configuration value.

CR:590190

CR Number:   590190 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 Dec 2013 Fixed Description If a table is on an inner side of a join, the 'UsedCount' of the table could be incremented multiple times of 'OptSelectCount' of the table in monOpenObjectActivity table.

CR:590249

CR Number:   590249 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description create a config option in RepAgent to suppress the following messages from showing up in the ASE log ... 00:00000:00066:2009/04/01 13:44:09.02 server RepAgent(41): Connecting to a Replication Server that supports a lower LTL version. Features that are not supported by the lower LTL version may cause the RepAgent to shutdown. Set the 'skip unsupported features' configuration option to prevent shutdown. 00:00000:00066:2009/04/01 13:44:09.02 server RepAgent(41): The Replication Server LTL version should be at least 710 for full support of features. (Replication server LTL version 700, Rep Agent LTL version 710).

CR:590312

CR Number:   590312 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2011 Fixed Description If reformating strategy is used and an index key has BIT datatype, it could return wrong result sometimes.

CR:590395

CR Number:   590395 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2009 Fixed 30 Sep 2009 One-off Provided 01 Oct 2009 Fixed 01 Oct 2009 Fixed 04 Oct 2009 Fixed 02 Feb 2010 One-off Provided Description The JVM terminates with an error 143 when a user logs off from a Windows OS that is running ASE.

CR:590420

CR Number:   590420 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2009 Fixed 23 Nov 2009 Fixed Description If there are tables with names wider than 30 characters and SET STRING_RTRUNCATION is set ON, sp_fkeys fails with errors 9502 and 17461 Workaround Description  Possible workarounds: 1) modify sp_fkeys source code to include "set string_rtruncation off" early in the code (around the "set nocount on" is a good place). -- possible disadvantage - the proc will truncate wide names and so not return the full name (however, it is documented to return a varchar(32) for the name) 2) modify the #pid and #fid work table definitions in the sp_fkeys source code to have name be a varchar(255) rather than varchar(30). -- possible disadvantage - there might be side effects from returning names wider than a 32 characters.

CR:590516

CR Number:   590516 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2010 One-off Provided Description EFTS: textsvr with universal filter dumps a core file when building an index on data containing Arabic characters.

CR:590604

CR Number:   590604 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) 25 Sep 2009 Fixed 05 Oct 2009 Fixed Description When a view is redefined during deferred compilation an error can be reported along with a stack trace in the errorlog referencing modules like "vu_redefine", "col_open_range". Workaround Description  Use traceflag 7730 to skip deferred compilation code path. The failure happens as we enter the DC code with some incorrect pointers inherited from the view resolution. -T7730

CR:590626

CR Number:   590626 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2011 Fixed 18 Mar 2011 Reservation Made 22 Mar 2011 Fixed 25 Mar 2011 Fixed Description The database timestamp could wrongly exceed its maximum value following a 6901 error, "Overflow on High component of timestamp occurred in database <dbid>. Database table possibly corrupt". This is no longer possible. After warnings that the database timestamp is reaching its limit, the database will finally be shut down, leaving the database in read-only mode.

CR:590636

CR Number:   590636 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2009 Fixed Description A SEGV could occur in norm3_get_node_sqlt() in union queries where there is an expression in the select-list that requires a sequencer node to evaluate it(e.g. - any single table column that appears in an expression in the select-list). This will occur in parallel queries if an XCHG op is placed between sequencer node and union node where it must be evaluated.

CR:590650

CR Number:   590650 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2009 Fixed 18 Nov 2009 Fixed Description The result of derived_stat builtin is incorrect when the partitionid parameter is not supplied. Workaround Description  Modify code to include the partitionid value.

CR:590694

CR Number:   590694 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2009 Fixed 21 Sep 2009 Fixed 30 Oct 2009 Fixed Description When sybmigrate migrates the database 'pubs2' from ASE 15.0.3 to ASE 15.5 EE, the following error message occurs: Error while executing SQL for migration of 'LK.dbo..au_pix'. Root Cause:Msg 17741, Level 16, State 1 Server target, Procedure sp_primarykey, Line 131, Status 0, TranState 1 Primary key already exists on table -- drop key first. Recoverable error. Task 'LK.dbo..au_pix' for path 'pubs2 --> pubs2' will be retried.

CR:590760

CR Number:   590760 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2009 Fixed 15 Oct 2009 Fixed 19 Oct 2009 Fixed 21 Oct 2009 Fixed Description A transaction dump that has a DROP and CREATE INDEX commands logged for a clustered index that has the sorted_data, max_rows_per_page and fillfactor options, may result after load, in a corrupted table where errors 692, 605, 2509, and 2525 could be reported. Workaround Description  If the clustered index is created without the fillfactor or without sorted_data, it works fine.

CR:590800

CR Number:   590800 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2009 Fixed Description ASE fails to raise an error and prevent creation of triggers that select text or image columns from the inserted or deleted tables. Such triggers may raise errors including 10785 or 7128, or return unexpected results for the text or image column. Workaround Description  Rewrite the trigger to select the text value from the base table. Note that only the new value is available for inserts and updates, and a deleted value is, of course, null.

CR:590806

CR Number:   590806 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for native encrypted TDS language.

CR:590845

CR Number:   590845 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) 07 Oct 2009 Fixed Description The message "kernel PCI(M1): PCI Bridge Config: Found incorrect table data, sockatmark() for 1 is not supported" may be reported on Solaris 10 setups unnecessarilly.

CR:590932

CR Number:   590932 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2009 Fixed 24 Sep 2009 Fixed Description Transfer format is not correct set, hence the stack trace is hit.

CR:591016

CR Number:   591016 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_help_qpgroup output for user shows no plans in the output, even when the user can successfully use a stored abstract plan.

CR:591040

CR Number:   591040 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2009 Fixed 08 Dec 2009 Fixed Description Executing a query involving encrypted column may hit a stack trace, if the encrypted column has decrypt_default and column statistics. Workaround Description  1. delete statistics on the column with decrypt_default For this particular customer case, do: delete statistics maxrecovery..debtors(post_code)

CR:591089

CR Number:   591089 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2009 Not reproducible with latest version of the product available as of Resolution Date Description Signal 11 in mda_fill_and_send_monProcessWaits Workaround Description  NA

CR:591168

CR Number:   591168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2009 Fixed 24 Sep 2009 Fixed Description alter table set transfer table on should also check the license file.

CR:591217

CR Number:   591217 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2009 Fixed 24 Sep 2009 Fixed 25 Sep 2009 Fixed 26 Sep 2009 Fixed Description Under rare circmustances ASE may produce a core dump file during a server shutdown when JavaVM activities have left the PCI Bridge in a stale state previously. This core dump file is not useful to Technical Support.

CR:591323

CR Number:   591323 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2010 Fixed 15 Jan 2010 Added to user documentation Description Implement CIS support for new datatypes, bigdatetime and bigtime.

CR:591324

CR Number:   591324 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description abstract plan group works for user on sproc, but not for ad hoc query Workaround Description  grant role sa_role to testuser

CR:591328

CR Number:   591328 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 Oct 2009 Fixed Description The message "current process infected with 11" in the module 'memmove' may be reported in the error log while executing a query requiring to access a partitioned table which partition conditions had to be recreated from source text and statement cache is enabled in the server. Workaround Description  Do not use "statement cache" for the query triggering the recreation from text of the partition conditions. Options are to disable statement cache server wide (via configuration option) or just for the problematic query via SET option.

CR:591472

CR Number:   591472 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) 05 Oct 2009 Fixed 01 Jun 2010 Presently Not Targeted For Any Future Release Of This Product Description Error 16022 may be reported "The ASE PCI-Bridge is not able to process the requested dispatching. This is a fatal error, etc." when the PCI is unavailable with a stack trace in the error log showing modules "jvminit", "SYB_CreateJavaVM" and "terminate_process" although the stack trace information is unnecessary.

CR:591508

CR Number:   591508 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2009 Fixed 29 Sep 2009 Fixed Description Error 16735 when boot server with cache partition set to DEFAULT.

CR:591540

CR Number:   591540 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2010 Fixed 11 Mar 2010 Fixed Description Strong "exponential" performance degradation is observed by customers running ASE_JAVA invoked methods which perform lots of ASE table stored data manipulation or direct Client related data processing. Although it is known that current execution performance is limited with respect to what can be done it was found that certain COTS JavaVM instrumentation flags caused huge impact on top of the current model. These instrumentation flags should not be enabled within customer / production environments. Workaround Description  Taking out exponential performance degradation can be obtained by removing the COTS JavaVM instrumentation flags from the PCIDB JRE configuration. These flags are platform dependent and are named: -Xcheck:jni -esa -enablesystemassertions They can be found in under the sybpcidb ($SYBASE/ASE-15_0/scripts/installpcidb)

CR:591604

CR Number:   591604 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2009 Fixed Description When statement cache is on and a cached query is run twice with invalid parameter or datatype, 706 error might be raised.

CR:591748

CR Number:   591748 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2009 Fixed 06 Oct 2009 Fixed Description dbcc logtransfer may stop and report a stack trace containing the functions lt_send_xckpt()->lt_get_ref_page()->getuncachedpage() while processing a transaction log for an in memory database.

CR:591766

CR Number:   591766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2009 Added to user documentation Description Please include in the documentation for configuring multiple backup servers a paragraph to describe the reason and requirement to update the interfaces file if a round robin policy is chosen and the client requires that any backup server can be started on any node. In the case of a round robin policy any backup server should be configured in the interfaces file to run on any instance as supported by the documentation: http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00768.1503/html/ase_ce_ug/ase_ce_ug8.htm Dedicated each instance in the cluster is assigned a specific Backup Server. Round robin instances are not assigned a specific Backup Server, but when they perform a dump or load, the cluster assigns a Backup Server for the job according to availability. Workaround Description  N/A

CR:591792

CR Number:   591792 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2012 Fixed Description A 13988 error, "ALTER TABLE <Table Name> failed. You cannot change datatype of column <Column name> to <Target Data type> when it is an index key.", will occur if an attempt is made to change the datatype of a key column to BIT.

CR:591842

CR Number:   591842 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description An infected with 11 in _CgpSubstExprVirtCol may be raised for an INSERT SELECT into a table where some columns have defaults and the SELECT is not providing values for those columns. Workarounds are to provide values for each column or use compatibility mode. Workaround Description  1) provide values for all columns in the INSERT SELECT or 2) use 12.5.x compatibility mode

CR:591867

CR Number:   591867 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Oct 2009 Fixed Description During upgrade from ASE 15 to another version of ASE 15, if 'enable merge join' is 1, the upgrade process fails with a stack trace containing function names alloc_dirtychains() and LeWkTbl::crtWkTbl(). Workaround Description  Set 'enable merge join' to 0 or 2 (DEFAULT).

CR:591988

CR Number:   591988 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2010 Fixed Description Adaptive Server may hit timeslice error during 'disk init/resize' involving filesystem devices or on usage of the device immediately after creation of the device using 'disk init' for huge database devices.

CR:592007

CR Number:   592007 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   ASE 15.5 GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2010 Fixed 26 Feb 2010 Fixed Description On Windows systems when Adaptive Server is running with configuration option "enable literal autoparam" active in some circumstances the execution of a query containing a big literal binary value may be aborted and the message "SQL Server system exception (0xc0000005) generated by a storage access violation" together with a stack trace which includes the modules 'memcpy' and 'mkconst_desc' may be reported in the error log. Workaround Description  - Disable automatic literal parameterization, for example via "sp_configure "autoparam", 0"

CR:592022

CR Number:   592022 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) 02 Oct 2009 Fixed 07 Oct 2009 Fixed 02 Oct 2009 Fixed 02 Oct 2009 Fixed 02 Oct 2009 Fixed 08 Oct 2009 Fixed 09 Dec 2009 One-off Provided 24 Jan 2010 One-off Provided Description The message "timeslice -<number>, current process infected" together with a stack trace which includes the modules "dbts_insert", 'dbts_commits_addxdes', 'xls_test_set_lrdata' and 'ha_session_dealloc' may be reported in the error log when CHAINED transactions are used in an HA environment.

CR:592026

CR Number:   592026 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2009 Fixed 30 Sep 2009 Fixed 30 Sep 2009 Fixed 09 Oct 2009 Fixed Description Configurable control is added in the stored procedure "sp_jreconfig" to allow or disallow loading of native libraries from within the PCA/JVM using the load and loadLibrary methods in the java.lang.System and java.lang.Runtime classes respectively.

CR:592246

CR Number:   592246 Product Name:   ASE Generic docs Product Component:   Adaptive Server New Features Guide Status:   Closed OS:   NA Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2009 Added to user documentation Description Add the formula for load score calculation and more explanation on workload management features.

CR:592254

CR Number:   592254 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2010 DEFER 17 Sep 2010 Fixed Description A procedural cross-db statement may fail with errors 208 'Table not found' during the upgrade process. Workaround Description  Drop and recreate any sprocs that reference a temp table created by a user aliased to dbo. or use dbcc upgrade_object()

CR:592294

CR Number:   592294 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2009 Insufficient priority to fix Description feature request: config parameter to revert to 12.5 worker process behavior

CR:592395

CR Number:   592395 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2010 Fixed 23 Sep 2010 Reservation Made 11 Oct 2010 Fixed 17 Nov 2010 One-off Provided 20 Sep 2012 Fixed Description Signal 11 in function ResRelOp()and spid termination with ResRelOpProcess(), CgpPop::_CgpPePredBmToScalar visible in the stack trace in the error log. Query involving outer join onto a virtual expression from a sub-query containing the column involved in the virtual expression in a further outer-join clause. A virtual expression is generally the result of a built-in function (isnull etc) Workaround Description  set compatibility_mode on

CR:592438

CR Number:   592438 Product Name:   Adaptive Server Enterprise Product Component:   QPtune Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description QPTune -A collect_stats ... sort output by count in descending order

CR:592444

CR Number:   592444 Product Name:   Adaptive Server Enterprise Product Component:   QPtune Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description QPTune -A fix_stats ... add comments with count and sort by count desc order

CR:592484

CR Number:   592484 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The Cluster User's Guide need more documentation explaining possible changes in data storage management for customers coming from SMP to the Cluster Edition

CR:592603

CR Number:   592603 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) 20 Nov 2009 Fixed 01 Dec 2009 Presently Not Targeted For Any Future Release Of This Product 10 Dec 2009 Fixed Description When compatibility mode is enabled and a stored procedure is executed, ASE may stacktrace in the function ind__itagsetup(). This happens if a query in a stored procedure refers to a table that is created and dropped inside the stored procedure and that stored procedure happens to recompile after the table has been dropped. Workaround Description  disable compatibility mode

CR:592605

CR Number:   592605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2009 Fixed 07 Oct 2009 Fixed 07 Oct 2009 Fixed 07 Oct 2009 Fixed Description ASE may report 3474 and 3478 fatal errors if a bulk-insert ctlib application making use of multi databases transaction needs to rollback. Workaround Description  traceflag 3945 works around some scenarios but not all

CR:592608

CR Number:   592608 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) 13 Oct 2009 Third Party Problem Description Decimal portion of the proxy columns mapped to NUMBER datatype in Oracle is truncated. Workaround Description  1) Map the Oracle NUMBER datatyype to ASE float : create existing table ORATAB_proxy( C1 float default 0 null ) at "mydco...ORATAB" OR 2) Change the NUMBER declaration to include precision and scale: CREATE TABLE ORATAB ( C1 NUMBER(16,8) DEFAULT 0 NULL ) OR Simply use float: CREATE TABLE ORATAB ( C1 FLOAT DEFAULT 0 NULL )

CR:592641

CR Number:   592641 Product Name:   Adaptive Server Enterprise Product Component:   QPtune Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined Description QPTune gui in Sybase Central ... dropdown list instead of blank single line edit when adding User Defined Mode

CR:592650

CR Number:   592650 Product Name:   Adaptive Server Enterprise Product Component:   QPtune Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2010 Bundled Request Description QPTune gui Sybase Central ... target db once selected should be used from then on ...

CR:592686

CR Number:   592686 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2010 Fixed 26 May 2010 Reservation Made 27 Oct 2014 Presently Not Targeted For Any Future Release Of This Product 28 May 2010 Fixed 02 Jun 2010 Fixed Description In a GROUP BY ALL query which has an outer join in which an inner table's column is in the GROUP BY list, there is a possibility of the NULL group not being included unless there already is a NULL value in the column i.e. if all NULLs are created by the NULL extension of the outer join, then the NULL group would not be included. Workaround Description  use compatibility mode

CR:592737

CR Number:   592737 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2009 Fixed 04 Nov 2009 One-off Provided 29 Oct 2009 Fixed 05 Nov 2009 Fixed 30 Oct 2009 Fixed Description After CR 531964 changes, sysprocesses.physical_io maps to piotot which is only incremented at the end of each statement because of which monProcessActivity had to be used for tracking i/o activity for running query. The physical_io should report pbufread\pbufwrite which are incremented as each i/o completes. Workaround Description  use monProcessActivity

CR:592741

CR Number:   592741 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2009 Fixed 11 Oct 2009 Fixed Description For transfer table, even if there is no row coming in from the nextwork, EX_INT lock is always held.

CR:592745

CR Number:   592745 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2009 Fixed 12 May 2010 Bundled Request Description DBISQL raises a syntax error at line 1, column 1 when trying to use the dbisql CONNECT TO HOST:PORT command syntax against ASE.

CR:592758

CR Number:   592758 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2009 One-off Provided 21 Oct 2009 Fixed Description Unable to configure large data cache. Workaround Description  sp_configure 'allocate max shared memory', 1

CR:592792

CR Number:   592792 Product Name:   Adaptive Server Enterprise Product Component:   QPtune Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined 25 Jul 2013 Presently Not Targeted For Any Future Release Of This Product Description QPTune gui Syb Cent ... undo missing stats ... the no-execute option is absent ... add this option just like it has been added for the Fix Missing Statistics

CR:592822

CR Number:   592822 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2009 Insufficient priority to fix 07 Oct 2009 Insufficient priority to fix Description ASE can raise excessive amounts of "Warning! The spinlock pool has grown to be larger than the spinlock monitor area. Not all spinlock statistics is available. A server reboot is needed if all spinlock statistics is necessary." messages.

CR:592829

CR Number:   592829 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2009 Fixed Description In some cases, using duplicate correlation names for the expressions can lead to a stacktrace in function find_dup_corrname().

CR:592839

CR Number:   592839 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2010 Consult Complete 08 Feb 2010 One-off Provided Description Multiple assertions leading to SEGVs, 707, 714 memory corruption

CR:592858

CR Number:   592858 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2012 EOL'd version. Not to be Fixed. Description QPTune gui ... manually control when tuning task finishes & gives results ... this will give a window where outside application and sql tasks could be done before the results are finalized and written out.

CR:592948

CR Number:   592948 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2009 Fixed 22 Dec 2009 Fixed Description The newly added optcriterion (disable_nonbin_sortorder_interpolation) will turn off interpolation costing. This is a session-level counterpart of Traceflag 15310. It is OFF by default for all optgoals.

CR:592964

CR Number:   592964 Product Name:   Adaptive Server Enterprise Product Component:   charsets Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description charset utility to support no space for the switches -U -P -S -I.

CR:592971

CR Number:   592971 Product Name:   Adaptive Server Enterprise Product Component:   charsets Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description charset utility generate error when you use -I . CT-LIBRARY error: ct_config(SET,IFILE): user api layer: external error: An illegal value of -9 given for parameter buflen.

CR:592977

CR Number:   592977 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2009 Fixed Description Some queries using "not equal" operators and involving local variables when they are run with SET ANSINULL OFF could return different results from Adaptive Server 12.5 when the results from Adaptive Server 12.5 are considered correct.

CR:593003

CR Number:   593003 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Duplicate Description Request for a mechanism to force an immediate update of licenses, rather than waiting for the next heartbeat or rebooting. Workaround Description  1) wait for the heartbeat ... wait for the heartbeat can take upto 3 hours. 2) do a recycle (shutdown, restart) of ASE.

CR:593005

CR Number:   593005 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) 06 Oct 2009 Duplicate Description Queries involving java running slower under 15.0.3.x than 15.0.2.x

CR:593053

CR Number:   593053 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) 13 Oct 2009 Fixed 16 Oct 2009 One-off Provided 14 Oct 2009 Fixed 14 Oct 2009 Fixed 13 Nov 2009 One-off Provided 17 Nov 2009 One-off Provided 02 Dec 2009 One-off Provided 11 Apr 2010 One-off Provided Description Fix the performance downgrade of sort module with large buffer pool in 15x.

CR:593117

CR Number:   593117 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) 09 Oct 2009 Fixed 15 Oct 2009 Fixed 22 Oct 2009 Fixed 22 Feb 2010 One-off Provided Description Unexpected errors may happen as a side effect of the compilation of a SELECT INTO #TABLE statement. The ASE errorlog will report a stacktrace involving module s_normalize. Also under some very rare circumstances on a heavily loaded system, there a risk of random memory corruptions.

CR:593136

CR Number:   593136 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 a new mda table monSysLookup that would store information from monProcessLookup similar to the way monSysSQLText pipelines data from monProcessSQLText. Workaround Description  Use a global login trigger to select the logins information from monProcessLookup into a user holding table at login time, with the addition of a datetime field for logintime. To emulate the pipeline behavior, the process that selects data from the table would be responsible for deleting the values it had read. [alternatively but perhaps over-complicated, a loopback-rpc based proxy table could encapsulate the behavior of both providing and deleting the data].

CR:593139

CR Number:   593139 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 sp_metrics takes too many locks

CR:593203

CR Number:   593203 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) 18 Nov 2009 Insufficient priority to fix Description sp_configure "max pci slots" will raise error 5849 and not change the configured value of the parameter if a slot higher than the desired value is currently in use. Workaround Description  a) Modify the configuration value in the .cfg file after shutting down ASE. (Doing so earlier than shutdown runs the risk of some other config value change overwriting the .cfg file and wiping out this manual change). or b) Reboot ASE and use sp_configure before anyone uses any java in ASE - how to prevent that from happening is left as an exercise for the student.

CR:593326

CR Number:   593326 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2010 Presently Not Targeted For Any Future Release Of This Product Description customer got msg 11041 after drop and recreating user table Workaround Description  rewrite the customer's sproc to use ANSI outer join syntax consistantly throughout the complex select statements see ~ts/cases/11560000s/11560800/pseinfo-11/ 2009_10_27__11560800-11__CITIGROUP__11041_repro.txt focus on the section between 12) and 13) and then step 16... 16. create proc sp_getMatch from file sp_getMatch__ansi.sql ***************************************************************************************** ...changed the following TSQL syntax... ... FROM PERSONNEL p, RITSVALUE r1, RITSVALUE r2, RITSVALUE r3, RITSVALUE r4, RITSVALUE r5, COUNTRY c, #tmp t, NAME n WHERE t.rits_id = p.rits_id AND t.rits_id = n.rits_id AND p.country_code = c.country_code AND p.sys_id *= r1.sys_id AND r1.parameter_code = 3 AND p.sys_id *= r2.sys_iduntry_code AND r2.parameter_code = 1 AND p.sys_id *= r3.sys_id AND r3.parameter_code = 24 and r3. pos = 1 -- temporary fix ?????? AND p.sys_id *= r4.sys_id AND r4.parameter_code = 64 AND p.sys_id *= r5.sys_idrary fix ?????? AND r5.parameter_code = 22 AND r4.parameter_code = 6 AND p.sys_id *= r5.sys_id AND r5.parameter_code = 22 ... ...to this new ANSI syntax...in two places in the customer's sproc... ... FROM PERSONNEL p left outer join RITSVALUE r1 on p.sys_id = r1.sys_id AND r1.parameter_code = 3 left outer join RITSVALUE r2 on p.sys_id = r2.sys_id AND r2.parameter_code = 1 left outer join RITSVALUE r3 on p.sys_id = r3.sys_id AND r3.parameter_code = 24 and r3. pos = 1 -- temporary fix ?????? left outer join RITSVALUE r4 on p.sys_id = r4.sys_id AND r4.parameter_code = 6 left outer join RITSVALUE r5 on p.sys_id = r5.sys_id AND r5.parameter_code = 22, COUNTRY c, #tmp t, NAME n WHERE t.rits_id = p.rits_id AND t.rits_id = n.rits_id AND p.country_code = c.country_code ... ***************************************************************************************** ...changed the following TSQL syntax... ... FROM #tmp t, GEID_AUX g, COUNTRY c, NAME n WHERE t.rits_id = g.rits_id AND t.rits_id = n.rits_id AND g.country_code *= c.country_abb ORDER BY t.match_type, lastname, firstname ... ...to this new ANSI syntax...in two places in the customer's sproc... ... FROM #tmp t, GEID_AUX g left outer join COUNTRY c on g.country_code = c.country_abb, NAME n WHERE t.rits_id = g.rits_id AND t.rits_id = n.rits_id ORDER BY t.match_type, lastname, firstname ... *****************************************************************************************

CR:593366

CR Number:   593366 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   all Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2009 Fixed 21 Oct 2009 Fixed 28 Oct 2009 Fixed Description When building a cluster with sybcluster, the operation will abort if entries matching the name of the server already exist in the interfaces file. Workaround Description  If the issue is not fixed, we have to use follwing workaround to do: After install 155CE, user have to create interfaces file in $SYBASE manually. Only If the interfaces file exist in $SYBASE, sybcluster can create cluster successfully.

CR:593446

CR Number:   593446 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2009 Fixed 09 Dec 2009 Fixed Description In rare circumstances error 941 "Illegal database context operation" may be reported into the errorlog while terminating ASE process.

CR:593459

CR Number:   593459 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2009 Fixed 14 Oct 2009 Fixed Description Under SMP, sp_configure 'nondefault' shows duplicate rows.

CR:593464

CR Number:   593464 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) 02 Nov 2009 Fixed 28 Oct 2009 Reservation Made Description Runtime execution errors (Invalid column length) may happen when executing a stored procedure creating temporary tables with column based on user defined datatypes if the datatype definition is changed between execution of the procedure. Workaround Description  Run in compatibility mode

CR:593512

CR Number:   593512 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 User datatype hierarchy is not updated when upgraded to ASE15.0.

CR:593582

CR Number:   593582 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2009 Fixed 05 Nov 2009 Fixed Description In rare circumstances when using the 'SET ROWCOUNT' option or the 'TOP' directive with 'SELECT INTO', when executed in parallel mode the rows may fail to be inserted. Workaround Description  set parallel_query off or set rowcount 0

CR:593603

CR Number:   593603 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2009 Fixed 12 Oct 2009 Fixed Description The performance of boot time recovery is made slower by an unnecessary number of physical I/Os during the redo pass.

CR:593682

CR Number:   593682 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2009 Fixed Description select of varchar returns trailing spaces

CR:593715

CR Number:   593715 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2009 Fixed 12 Oct 2009 Fixed Description Print format error while doing dbcc table_xfer_check().

CR:593730

CR Number:   593730 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Add support for selecting text and image columns from the inserted and deleted tables in triggers.

CR:593931

CR Number:   593931 Product Name:   Adaptive Server Generic Docs Product Component:   Other Status:   Closed OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2009 Added to user documentation Description In order to clarify how the load score for an instance is created. It would be very helpful to include the calculation used internally. LoadScore = ConnectionsWeight*ConnectionsLoad/100 + CPUWeight*CPULoad/100 + RunQueueWeight*RunQueueLoad/100 + IOWeight*IOLoad/100 + EngineWeight*EngineLoad/100 + UserDefinedWeight*UserDefinedLoad/100 Workaround Description  N/A

CR:594060

CR Number:   594060 Product Name:   Adaptive Server Enterprise Product Component:   ssm Status:   Closed OS:   RH Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2010 Fixed Description The quantity of licenses required for the DH license type should match the number of processor chips. Currently it is being treated as a Server license type and only 1 license is checked out.

CR:594101

CR Number:   594101 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2009 Fixed 14 Dec 2009 Reservation Made 28 Apr 2010 One-off Provided Description The newly added optcriterion (multi_attribute_density_costing) will use the legacy multi-attribute density costing technique. This is a session-level counterpart of Traceflag 437. It is OFF by default for all optgoals.

CR:594140

CR Number:   594140 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2010 Fixed Description Error 204 and stacktrace could happen during codegen when SELECTing from a UNIONALL over DISTINCT query and the DISTINCT select list has two char type columns which are equijoin'ed together. This would only happen when the optcriteria "opportunistic_distinct_view" is off (by default it is on) or the DISTINCT select list also has some expression (including subquery). Workaround Description  dbcc traceon (15321) --or set cr500736 off --15.0.3 ESD#2 and higher

CR:594204

CR Number:   594204 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 Oct 2009 Fixed 19 Oct 2009 Fixed 19 Oct 2009 Fixed 20 Oct 2009 Fixed Description When the dboption "dbo use only" is set, the database owner when executing sp_adduser may encounter an access error (Msg 923).

CR:594228

CR Number:   594228 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   Windows Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2009 Fixed Description Executing an OPTDIAG STATISTICS command without specifying a table name may not succeed if an underlying table contains a column name longer than 31 characters. Workaround Description  * Use optdiag and specify the table. OR * Rename the column to be less than 32 characters in length.

CR:594339

CR Number:   594339 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description On a complicated query, when unlike datatypes are being compared, using a different optgoal causes different filtering order . This, in turn, may prevent certain data values from being eliminated before the comparison and cause an Arithmetic overflow. This CR is raised to see if improvements can be made in the allrow_mix to filter out "illegal" value. Workaround Description  To be safe, add a search clause to eliminate the "illegal" value row first, and not to rely on the join order/type to eliminate the conversion error.

CR:594364

CR Number:   594364 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2010 Fixed 19 Jul 2010 Fixed Description When the target file of a 'transfer table' command is a pipe and there is no reader waiting to read the pipe, the 'transfer table' command can encounter a time slice error while attempting to open the pipe.

CR:594383

CR Number:   594383 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2009 Fixed 28 Oct 2009 Fixed Description A stacktrace containing the following functions : LeHashContext::Close(), memshrink() may occur after a 701 error.

CR:594449

CR Number:   594449 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2010 Fixed 12 May 2010 Bundled Request Description The initial value of "ASE.autoCommit" of setting file".isqlPreferences11" of DBISQL is not correct.DBISQL will work an auto commit. However, on the option screen of DBISQL, an option is OFF. Workaround Description  Please start DBISQL and open an option screen. And please close an option screen. The value of an option will be cleared.

CR:594482

CR Number:   594482 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2012 Fixed Description When marking a table with at least one LOB column for replication and for using a replication index while such an index already exists (for example, orphan index left over or index created first with sp_reptostandby then again with sp_setreptable), the index re-created is corrupt. The command 'dbcc tablealloc' reports error 2525. Run-time errors 605 and 1133 may also be reported. Workaround Description  - If you do not use the sp_reptostandby stored procedure but only the sp_setreptable command to indicate 'use_index' you will not hit the problem - Enabling DDL in tran on the database level will also result in not hitting the problem

CR:594489

CR Number:   594489 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2009 Fixed 10 Nov 2009 Fixed 06 Nov 2009 Reservation Made Description The predicate transformation code for or-clauses was modified from that of version 12.5. In some cases, this may result in or-clause predicates that reference only one table to not generate new optimizable clauses. Support has been added to revert the same table predicate transformation behavior to be more similar to 12.5. This can enabled using trace commandline flag 15333.

CR:594502

CR Number:   594502 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2009 Fixed Description Wrong result could happen for EXISTS/IN subquery with an ORDERBY clause on a character type column under non-binary sort order when merge_join is disabled. The EXISTS subquery's correlated predicate contains only equijoin.

CR:594510

CR Number:   594510 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2009 Fixed Description Update and delete queries may choose a bad join order when run in compatibility mode. Specifically, "PLAN FOR ONEROW" scans are not placed at the start of the join orders. This only occurs when the query in run in "restricted compatibility" mode as indicated by @@qpmode=2. See the "Using 'Compatibility Mode' In ASE 15.0.3 ESD#1 For ASE 15 Migration" technical white paper or the "Sybase Professional Services - ASE 15 Migration Strategy" paper for more details on restricted compatibility mode. Workaround Description  Do not use compatibility mode, and it will pick the correct index. Trace 446 can be used with compatibility mode: this turns off "restricted" compatibility mode, which encounters this issue.

CR:594550

CR Number:   594550 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2009 Fixed Description select * from monCIPCLinks where ActiveState='Up' is not returns any rows even if the state of the link is up. Workaround Description  Use "select * from monCIPCLinks where ActiveState like 'Up%'