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

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

CR:499407

CR Number:   499407 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2008 Fixed 11 May 2008 Duplicate Description increasing/decreasing size of default data cache only on 1 instance can corrupt master device.

CR:499408

CR Number:   499408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2008 Fixed 29 Jun 2008 Fixed 29 Jun 2008 Reservation Made 18 Aug 2008 Fixed Description When real time messaging is enabled on ASE to use MQ. The additional engine spawned to handle MQ tasks uses up very high cpu even when there is only 1 messaging operation.

CR:499413

CR Number:   499413 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2008 Fixed Description Include available sort order options all the time when using sqlloc with X.

CR:499448

CR Number:   499448 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2008 Fixed 08 Apr 2009 Fixed Description Procedural query with FOR READ ONLY option may incorrectly raise error 7304 "FOR READ ONLY can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure"

CR:499455

CR Number:   499455 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2013 Presently Not Targeted For Any Future Release Of This Product Description Dynamic partition elimination may not be applied, when processing an ad-hoc sql query or stored procedure, with variable SARGs and range predicates, against a table that has a composite partition key. Workaround Description  N/A

CR:499485

CR Number:   499485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2008 Bundled Request Description On Windows platforms that have Virtual Adaptors the SySAM properties file can grow over time causing delays in startup. Target Version  15.0.3

CR:499490

CR Number:   499490 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2008 Fixed Description Compilation of an UPDATE query that contains a join and at least one IN-list or OR clauses on the same column can choose deferred update mode, when direct update mode is possible. As a result performance of the UPDATE query can be negatively impacted. An example query is: update t1 set c2 = 3 from t1, t2 where t1.c1 in (1,2,3,4,5,6,7,8,9) and t1.c2 = t2.d2 where table t1 is being updated and the query joins tables t1 and t2 and there is a IN-list on column c1 of table t1.

CR:499532

CR Number:   499532 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhance documentation of checkstorage faults.

CR:499539

CR Number:   499539 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2008 Not reproducible with latest version of the product available as of Resolution Date Description Error 15072 may occur on DBCC CHECKCATALOG command after DELETE STATISTICS and optdiag statistics in.

CR:499566

CR Number:   499566 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Open OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2008 Fixed 17 Jun 2008 Fixed 17 Jun 2008 Fixed 18 Jun 2008 Presently Not Targeted For Any Future Release Of This Product 17 Jun 2008 Fixed Description Remove Public/Private Network option in "Define Instance dialog" of CCW,AIW and Upgrade Server Wizard, only show a checkbox for Secondary Network option.

CR:499569

CR Number:   499569 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2008 Fixed 14 Oct 2008 Fixed Description In a well partitioned cluster, fail over recovery may spend unneeded time flushing modified pages to disk at the end of recovering a database that is only modified on the surviving node.

CR:499656

CR Number:   499656 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2008 Fixed Description Different messages are printed on error of dropping a login through sp_droplogin when ldapua is enabled and disabled.

CR:499659

CR Number:   499659 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description select from a view on archive db hits error 3906 on windows 64bit

CR:499694

CR Number:   499694 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2008 Bundled Request Description When a database operation (create, alter, drop, quiesce, mount, etc) is in progress, issuing a "quiesce hold" command may result in error 2244 "Unable to open database dbname". Error 2244 may also be raised when issuing a "quiesce" command on a database that is already in a 'quiesce' state.

CR:499704

CR Number:   499704 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 Request to improve diagnostic error messages in the errorlog by including more context information such as procedure or trigger name, line number in code, etc.

CR:499712

CR Number:   499712 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) 30 Sep 2008 Added to user documentation Description sp_audit doesn't allow "all" to be specified for login_name, raising an 18226 error.

CR:499747

CR Number:   499747 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2008 Fixed 26 Jul 2010 One-off Provided Description Jsagent opens the port on all IP addresses on machines that have multiple network interfaces. Workaround Description  No workaround.

CR:499810

CR Number:   499810 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2008 Not reproducible with latest version of the product available as of Resolution Date Description lmlink hits signal 11 for getpage_noscan().

CR:499877

CR Number:   499877 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2010 Added to user documentation Description Requesting an additional 15.0 document on the resetting of the size of tempdb. Workaround Description  Ensure that tempdb fragment on master is at least 4mb. alter database tempdb on master = 2 Then follow the steps in the 12.5.1 guide.

CR:499894

CR Number:   499894 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Improve documentation on how to use traceflags in the RUN_SERVER file. Multiple -T parameters can be passed to the dataserver binary. It is good practice to document what each flag is being used for.

CR:499895

CR Number:   499895 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2009 Bundled Request Description DBISQL not processing results when multiple results includes warning messages

CR:499935

CR Number:   499935 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2008 Fixed Description DBISQL 11 now sends multiple results to a single output file.

CR:499949

CR Number:   499949 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2008 Fixed Description On the Solaris platform, a core dump is encountered when the qrmutil program is run with short style arguments, e.g. -Q instead of --quorum_dev

CR:499961

CR Number:   499961 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Executing a SELECT statement with an AT ISOLATION 3 clause but without a FROM clause may lead to a stacktrace and termination of the users process. Workaround Description  Run any query containing a FROM clause before running the failing query.

CR:499982

CR Number:   499982 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2009 Fixed 29 Jul 2009 One-off Provided Description The message, "Current process infected with signal 11 (SIGSEGV)", may be reported in the errorlog together with a stacktrace which involves the modules '_StTcCharacterSample' and 'StTcMrgBnds' when executing a SELECT query with an IN list on encrypted columns.

CR:500001

CR Number:   500001 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2008 Not a Bug Description char_length () function returns incorrect value on text column with XML data

CR:500016

CR Number:   500016 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2008 Fixed Description In rare circumstances following failure of an instance, a surviving instance that is performing failover recovery might hang as a result of an undetected deadlock between the failover recovery process and another user process.

CR:500071

CR Number:   500071 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2008 Fixed 27 Jun 2008 Fixed Description Post-Commit Optimization performs poorly for transactions with large number of DELETEs.

CR:500116

CR Number:   500116 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2008 Fixed 27 May 2008 Reservation Made 06 Jun 2008 Reservation Made Description A 332 error may be reported during a query that involves multiple nested VIEWs below a UNION VIEW.

CR:500131

CR Number:   500131 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2008 Fixed Description Index suspect status is not set after lower version of database is loaded across platform where byte-order (endian type) is different. Workaround Description  Shutdown ASE (cluster) and restart after the first online after XPDL.

CR:500190

CR Number:   500190 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2008 Fixed Description sp_configure 'number of open indexes', 20000000 expects to get message 5861 but hits 10886.

CR:500198

CR Number:   500198 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2008 Not reproducible with latest version of the product available as of Resolution Date Description Job Scheduler batches may fain with "Unclosed quote before the character string" errors and references to jsd_GetResults() and jso_FlushBuffer() Workaround Description  Playing around with the order in which commands are run can fix the problem.

CR:500299

CR Number:   500299 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2008 Fixed Description Page size information was not presented in ASE Plug-in. Now, server page size information is displayed in the server's General tab of the Properties dialog.

CR:500311

CR Number:   500311 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) 12 May 2008 Fixed Description A relocated join may get error 207 when joining on a column with upper case in the column name. Workaround Description  The issue is caused by a bug with the dynamically creating the proxy table in tempdb. The issue can be avoided by doing a "create existing table" or "create proxy_table" in the remote server to pre-define the proxy table that maps back to the local server. This is recommended anyways for frequent users of relocated joins since it avoids the overhead of creating the proxy table when the query is executed.

CR:500326

CR Number:   500326 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2008 Presently Not Targeted For Any Future Release Of This Product Description After applying ASE 15.0.2 esd #4, the output from backupserver -v is esd #3.

CR:500330

CR Number:   500330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2008 Fixed 29 Aug 2008 Fixed Description sp_sysmon "app_only" stops reporting application detail after several hours

CR:500347

CR Number:   500347 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2012 Fixed Description Temporary files are not cleaned up after cluster creation.

CR:500404

CR Number:   500404 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2008 Fixed Description In some cases, the workload manager might allow connections to migrate when they should not. This might cause some issues later when the process resumes on the new node.

CR:500463

CR Number:   500463 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) 08 May 2008 Fixed 11 May 2008 Duplicate Description Error 18177 might be raised by sp_cacheconfig if instance name is longer than 21 characters

CR:500474

CR Number:   500474 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2009 Fixed Description In rare circumstances, Adaptive Server may give a time slice error with a stack trace which contains modules 'cm__check_page_range' or 'cm_choose_buffer_pool'.

CR:500546

CR Number:   500546 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2008 Fixed Description Incorporated SQLTEXT printing for CREATE PROC, CREATE RULE, CREATE DEFAULT and CREATE TRIGGER statements when application tracing and show_sqltext options are turned on.

CR:500730

CR Number:   500730 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2008 Fixed 26 Jun 2008 Fixed 09 Jul 2008 Fixed 28 Aug 2008 Fixed 27 Aug 2008 Fixed 29 Aug 2008 Fixed 03 Sep 2008 Fixed Description 1. In "Perference" page of "Adaptive Server Enterprise Plug-in Properties", there will be a switch for enable/disable check I/O fencing capability. 2. In "Specify Master Device page" of Create Cluster Wizard, there will be a dialog if specified devices do not have I/O fencing capability. 3. In "Specify the System Procedures Device" of Create Cluster Wizard, there will be a dialog if specified devices do not have I/O fencing capability. 4. In "Specify the System Database Device" of Create Cluster Wizard, there will be a dialog if specified devices do not have I/O fencing capability. 5. In "Specify Server Instances" of Create Cluster Wizard and Add Instance Wizard, there will be a dialog if more than one instance will be created on one host. 6. In "Specify Name and Path" page of Database Device Wizard, there will be a dialog to show if the specified device is I/O fencible. 7. In "General page" of Database Device Properties, there will be a label to show if the device is I/O fencible. 8. In "Device Information" of Add database wizard, there will be a dialog to show if the specified device is I/O fencible.

CR:500736

CR Number:   500736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2008 Fixed 21 Aug 2008 Reservation Made 25 Aug 2008 Fixed Description Character data type table column in the SELECT list might return unexpected trailing blanks when the column is involved in an equjoin with some character data type expression. Also hash/merge join was not available between character data type column equijoin under nocase sort orders.

CR:500816

CR Number:   500816 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2008 Fixed Description A 2622 error "Insufficient room on this page to insert a row of length ..." may be reported in the error log together with a stack trace which includes the modules 'dol_putdrow', 'undo_dol_delete', 's_renormalize' and 's_recrtproc' while concurrent sessions write a new query tree in sysprocedures whereas the current session needs to rollback its current work from it.

CR:500852

CR Number:   500852 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2008 Fixed 24 Oct 2008 Fixed Description A query with no reformatting and no sorting and only a distinct_hashing or group_hashing operator may claim too many buffers (typically the value of "max buffers per lava op") as seen through the "set statistics plancost" output.

CR:500872

CR Number:   500872 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2008 Fixed 22 Jul 2008 Fixed Description After a database dump and load, ASE may not be able to access the SQL UDFs created before the dump.

CR:500891

CR Number:   500891 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement request to add information about fault severity and recommended actions to sp_dbcc_faultreport

CR:523659

CR Number:   523659 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2008 Fixed 12 May 2008 Fixed Description Booting of second ASE Cluster Edition instance may hang, if the first instance is simultaneousy doing write-activity (such as create table or inserts) in master database.

CR:523693

CR Number:   523693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2008 Fixed 15 May 2008 Fixed Description Under rare circumtances , a deferred update of an APL table may result in a 2620 error: "The offset of the row number at offset <offset> does not match the entry in the offset table of the following page."

CR:523704

CR Number:   523704 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2008 Fixed Description While doing DISK MIRROR/REMIRROR/UNMIRROR for an inactive disk, a stacktrace with SIGSEGV may be reported.

CR:523730

CR Number:   523730 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2008 Fixed Description The message "timeslice -value, current process infected" may be reported in the error log together with a stack trace which includes the modules 'clfr_recovernode' and 'clfr_recovery' during node failover recovery.

CR:523736

CR Number:   523736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2008 Fixed Description A new option "number of alloc units" added to pageinfo() built-in to return number of allocation units allocated to an object, given the first oam page for the object.

CR:523759

CR Number:   523759 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2008 Fixed 17 Sep 2008 Reservation Made Description Adaptive Server doesn't support allocation of shared memory greater than 165 GB.

CR:528381

CR Number:   528381 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2008 Fixed Description The following message is seen in the error log upon server startup: "kernel Warning: Cannot resolve LDAP function ldap_search_ext_s".

CR:528407

CR Number:   528407 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2008 Fixed 21 Aug 2008 Fixed 22 Aug 2008 Fixed Description In some circumstances, Adaptive Server may throw a message "current process infected with 11, in the module CgpUnion::_CgpInitProjection, together with a stacktrace which includes modules like CgpMergeUnionAll::cgpInit", when a UNION ALL query is being executed.

CR:528442

CR Number:   528442 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) 05 Jun 2008 Added to user documentation Description LST dbs must not use private devices which are only accessable by an instance. Existing documentation is not clear enough in indicating the requirements for the LST devices. Currently the acts of creating and deleting the LST require that the devices be accessible from other instances.

CR:528447

CR Number:   528447 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2008 Fixed 16 May 2008 Fixed Description During failover recovery, undo phase may sometimes encounter 820 errors: "Attempt to dirty non-log buffer <addr> which is in I/O."

CR:528451

CR Number:   528451 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2008 Fixed Description In a shared disk cluster system following an instance failure, a 3478 error, " During undo the page timestamp value is less than new timestamp from log...", may be reported when recovering a database that has mixed log and data and asynchronous prefetch is on.

CR:528463

CR Number:   528463 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2008 Fixed 18 May 2008 Fixed Description 692 error in DOL index scan restart could enountered in rare occasion.

CR:528470

CR Number:   528470 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: In 15.0.2 ESD#2, make sp_help output more consisitent for materialized and not materialized (virtual) computed columns. Remove the 'materialized' keyword from the syscomments.text field for a materialized computed column.

CR:528474

CR Number:   528474 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) 13 Jun 2008 Fixed Description The cache creation/update operation using sp_cacheconfig succeeds but the server fails to reboot with new configuration

CR:528551

CR Number:   528551 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2008 Fixed Description Error 530 may be reported when using output from SQLJ function on outer column of a join. Workaround Description  Wrap the SQLJ function in an isnull(). Use a UDF.

CR:528604

CR Number:   528604 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2008 Fixed 17 Jul 2008 Fixed Description On the Solaris platform, ASE may encounter a timeslice error during boot if ISM (intimate shared memory) is in use and the amount of memory configured is approximately 100 Gb or more.

CR:528752

CR Number:   528752 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2008 Fixed Description request to document sp_addmessage with 'replace' option can only be run by the same login who created the original messasge

CR:528779

CR Number:   528779 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2008 Fixed 21 Oct 2008 Fixed Description DBCC CHECKSTORAGE records information in dbccdb that is not used in most cases. This change reduces the number of inserts by skipping faults for which an exclusion is defined with sp_dbcc_exclusions and skipping inserts in dbcc_counters. The pre-fix behavior can be enabled using exec sp_dbcc_updateconfig null, "enable excluded faults inserts", '1' and exec sp_dbcc_updateconfig null, "enable dbcc_counter inserts", '1'

CR:528830

CR Number:   528830 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2008 Bundled Request Description Previously DBISQL11's OUTPUT command did not work in command-line mode. This has been fixed. Workaround Description  Redirect the output to a file: dbisql.bat -host nstack-sun -port 5502 -c "UID=root;PWD=rooter" -nogui aut.sql > output.txt

CR:528833

CR Number:   528833 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2008 Fixed Description Previously DBISQL 9.0.2's PARAMETERS command did not work properly. This has been fixed in DBISQL 11.0. Workaround Description  Redirect the output to a file: dbisql.bat -host nstack-sun -port 5502 -c "UID=root;PWD=rooter" -nogui aut.sql > output.txt

CR:528848

CR Number:   528848 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2008 Fixed Description For failed authentication, authentication mechanism is missing in login audit record.

CR:528854

CR Number:   528854 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2008 Fixed 23 Jul 2008 Fixed Description Auditing of dropping and adding user messages prints the database user name information in the "objowner" column of the audit record.

CR:528994

CR Number:   528994 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2008 Bundled Request Description Previously, DBISQL11 would report a synax error if you executed an INPUT, OUTPUT, or READ statement which was followed by "GO". This has been fixed.

CR:528997

CR Number:   528997 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2008 Fixed Description DDLGEN - Request to not return an error when extracting user ddl when only dbo user exists. Currently it can return 'Critical internal application error' along with 'The specified User does not exist' Sybase Adaptive Server Enterprise DDL Generator Utility/15.0.2/1/S/1.4.2/ase15x/Thu Dec 13 19:23:59 PST 2007

CR:529023

CR Number:   529023 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2008 Not reproducible with latest version of the product available as of Resolution Date Description simultaneous dump db and create idx lead to 701 in 12.5.4

CR:529026

CR Number:   529026 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2009 Fixed Description During instance startup, a set of three messages is logged, if a secondary interconnect is not defined for the cluster. Messages are: "The cluster interconnect protocol has not been defined in the cluster input file", "Cannot resolve host name '' for the local interface of the link to monitor", and "Cannot resolve host name '' for the remote interface of the link to monitor".

CR:529124

CR Number:   529124 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2008 Fixed Description Hit sig11 when dump new config file which is part of drop instance procedure.

CR:529155

CR Number:   529155 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2008 Fixed Description In rare circumstances , "current process ... infected with 11" may be reported in the error log together with a stack trace which includes the modules 'ptn__setup_field_access', 'wrongpage' and 'sort_read' while ASE was in the process of reporting error 696 "An attempt was made to fetch logical page ... Page belongs to <value> and not to <value> ..." due to a sort operation having failed.

CR:529215

CR Number:   529215 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2008 Fixed 21 Jul 2008 Fixed Description The message "Invalid column length: <value>. Value must be between 0 and <value> for 'data-only' row with minimum row length of <value>." may be reported in the error log followed by a stack trace in module 'collocate' when the DBCC PAGE command is run with the print option value of 4 on a datarows-only-locked table that has variable length columns with a size value greater than 256. The modules 'prvarlen_cols' and 'prDOL_ROWS' will also be reported in the stack trace.

CR:529246

CR Number:   529246 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2008 Fixed Description Clients supportnig extended HA may receive a protocol error at login time if ASE is configured for LDAP directory services.

CR:529256

CR Number:   529256 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2008 Fixed Description Checkstorage may fail on 64bit platforms, with an arithmetic overflow error 247 followed by error 12964 DBCC cannot insert the row in the dbcc_operation_log table for this check of database '%s', aborting check.

CR:529327

CR Number:   529327 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2008 Bundled Request Description In rare circumstances for clusters with two or more instances, it may be possible for a named cache to be deleted at some instance with out releasing physical memory.

CR:529398

CR Number:   529398 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2008 Duplicate Description Errors 913/225 on select of computed column that uses UDFs after load from database with different dbid

CR:529400

CR Number:   529400 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2008 Fixed 29 May 2008 Reservation Made Description When an encrypted column uses a key that requires an explicit password and has declared a decrypt default, then a reference to that column in a WHERE clause that uses an OR operator may return Error 15469 to a user who lacks decrypt permission.

CR:529481

CR Number:   529481 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2008 Fixed 17 Jun 2008 Fixed 24 Jun 2008 Fixed Description Instance failover recovery may hang when it tries to write modified changes to disk after the recovery redo pass.

CR:529508

CR Number:   529508 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2008 Fixed 22 May 2008 Fixed 19 Jul 2010 Fixed 22 Jul 2010 One-off Provided Description In rare circumstances following undo of an allocation, the database timestamp may be inadvertently set higher than it needs to be, increasing the likelihood of running out of timestamps for any database during its lifetime.

CR:529566

CR Number:   529566 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) 26 Jun 2008 Fixed Description New feature: Create a password_random() built-in that generates a random password which satisfies the password complexity "minimum checks".

CR:529627

CR Number:   529627 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a stored procedure sp_rebuild which would be similar to sp_recompile but would force a rebuild of compiled objects from the source code in syscomments rather than just a recompilation of the query plan. Workaround Description  Hi, Boot the server with -T7706 and -T243 and: create proc sp_redefine @name varchar(30) as select schema_inc(object_id(@name),2) go sp_redefine 'tablename' go will force the recreation from the text. andrzej

CR:529699

CR Number:   529699 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2008 Fixed 26 Jun 2008 Reservation Made 13 Apr 2009 Presently Not Targeted For Any Future Release Of This Product Description The message 2834 may be reported in the error log when an ALTER TABLE DROP PARTITION or ALTER TABLE ADD PARTITION command is run while concurrent activity on the target table takes place.

CR:529749

CR Number:   529749 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2009 Duplicate Description DDLGen can get confused when it tries to drop indexes before re-creating them if there are multiple indexes with the same name on different tables.

CR:529776

CR Number:   529776 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 107 may be raised for the first execution of a stored procedure that performs a delete when the procedure code is inconsistent in the use of qualified table names, i.e. using a mix of owner.name and name references. Workaround Description  Be sure the table name in the where clause matches the table name after delete. See description for example.

CR:529787

CR Number:   529787 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2008 Fixed 05 Jun 2008 Fixed Description Unexpected results could be returned under some circumstances when executing a query using CASE expressions involving inside comparisons to NULL literal values and ANSINULL session option is not active.

CR:529788

CR Number:   529788 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2009 Not reproducible with latest version of the product available as of Resolution Date Description Data corrupted when the view is not redefined after alter the table which uses user defined datatype. Workaround Description  Ct needs to drop and recreate the view betaal_trans. This will prevent data corruption and the wrong select result.

CR:529792

CR Number:   529792 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2008 Fixed Description Adaptive Server might terminate the execution of a query containing GROUP BY ALL and a subquery in the WHERE clause.

CR:529808

CR Number:   529808 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description configure certain databases as proxydbs in an HA environment. Customer would like to be able to have some databases be local, and some proxy.

CR:529840

CR Number:   529840 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR requires some more restrictions for running "shutdown" command to avoid bring a product server down by mistake.

CR:529913

CR Number:   529913 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2008 Fixed Description For clusters with two or more instances, too many cache bind operations may lead to server hang in module cipcmsg_alloc() due to lack of free messages to be sent over network.

CR:530139

CR Number:   530139 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2008 Fixed Description Clients may get deadlock error occasionally while doing DML operations on same page from different instances in a cluster and in some case the deadlock may have been detected prematurely while waiting for the data to be transferred from another instance

CR:530184

CR Number:   530184 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2008 Fixed Description For clusters with two or more instances, cache update operation or instance specific configuration in the presence of global configuration with size less than 255 pages can lead to successful operation instead of failing.

CR:530186

CR Number:   530186 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2008 Fixed Description RIDjoin (for OR predicate) inner to outerjoin operator could sometimes lead to execution error message 623,624 or 806 related to retrieving a row via its RID. Workaround Description  set index_union off go

CR:530220

CR Number:   530220 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2008 Fixed 14 Jul 2008 Fixed Description Kerberos logins with connection failover support fail to connect to ASE when HA is configured.

CR:530267

CR Number:   530267 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) 18 Dec 2008 Fixed 15 Feb 2009 Fixed Description Creating an index using the "with sorted_data" option on a partitioned table where the data is not actually sorted sometimes completes without error but creates a corrupt index with missing entries.

CR:530268

CR Number:   530268 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2008 Duplicate Description When both Primary and Secondary LDAP server have a failed status, rebooting ASE should reset their Active/Status to True,Ready rather than leave both as False,Failed. Workaround Description  The client has to manually update the status of the LDAP servers to re-enalble LDAP connections at login.