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

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

CR:455698

CR Number:   455698 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2007 Fixed Description Previously when ASE Plug-in connected to a server, it always restored/opened the last-opened folder. Users now have the option to turn off this behavior by unchecking "Open last-visited folder after connecting to server" check box by selecting Tools -> Adaptive Server Enterprise -> Preferences.

CR:455707

CR Number:   455707 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2007 Fixed Description Previously a server's preferences (such as number of lines of server log to retrieve) were lost when the server was cut and pasted. Now the preferences for the server are preserved when the server is cut.

CR:455721

CR Number:   455721 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2009 Added to user documentation Description Need information update on the tempdb and indexing on Performance and Tuning Guide

CR:455779

CR Number:   455779 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   all Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2007 Added to user documentation Description Problem: Project execution might become unresponsive when database runs out of space. Resolution: When a database involved in a data transfer runs out of space, the execution of a project might stop responding. This is because the database driver does not return with an error message but waits until space is available to continue. Please ensure that sufficient space is available before running a project or job.

CR:455781

CR Number:   455781 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Windows W2k Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2009 Fixed 01 Sep 2009 Fixed 04 Sep 2009 Fixed Description The Historical Server reports an incorrect time value on the windows platforms. Workaround Description  None known.

CR:455812

CR Number:   455812 Product Name:   Adaptive Server Generic Docs Product Component:   EFTS SDS and SFTS SDS Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description index name in sp_create_text_index should be from local db only, documentation needs to be corrected to reflect that.

CR:455819

CR Number:   455819 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   AIX 5.1 Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2007 Third Party Problem Description FTS core dumps when creating index with universal style

CR:455826

CR Number:   455826 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) 04 Mar 2007 Fixed 22 Aug 2007 Fixed Description If a kerberos login gets a timeslice error during security session establishment, the engine-wide semaphore is not released, causing all the other kerberos logins on that engine to block.

CR:455839

CR Number:   455839 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2007 Fixed 18 Sep 2007 Fixed 14 Aug 2007 One-off Provided Description Concurrency problems are found when using MIT Kerberos client libraries version 1.3.x and 1.4.x or earlier, causing ASE crash or blocking all Kerberos logins when there are concurrent Kerberos authentication attempts. ASE now supports concurrent Kerberos authentication requests by default. Trace flag 7844 is no longer needed and can be used if concurrent Kerberos authentications is not required.

CR:455842

CR Number:   455842 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2007 Fixed Description Previously when you sort a table column of data type "binary" on Data panel, a ClassCastException stack trace would occur. This has been fixed.

CR:455901

CR Number:   455901 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2007 Not reproducible with latest version of the product available as of Resolution Date 16 Apr 2007 Fixed 18 Apr 2007 Fixed Description Entities in xml documents are not handled correctly on AIX FBO builds.

CR:456048

CR Number:   456048 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2007 Fixed 13 Oct 2007 Fixed Description When a sort node is used for a merge join, and an ORDER BY request is made by the query, that uses descending columns, then there is a possibility that the ORDER BY on those columns would be ignored, and only the ascending columns in the ORDER BY would be respected. This problem occurs when an attempt would be made to use the ordering available from the sort node, to also be used by the ORDER BY so that an extra sort node is avoided. Workaround Description  Typically turning off merge_join for this query could be used as a workaround

CR:456052

CR Number:   456052 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2007 Fixed Description Materialized status of a computed column cannot be altered from column properties in Sybase Central ASE Plug-in.

CR:456061

CR Number:   456061 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2007 Fixed Description When modifying or adding a buffer pool of a data cache, in Sybase Central ASE Plug-in, provide an option to set the "local async prefetch limit" for the buffer pool. Workaround Description  Manually execute sp_poolconfig named_cache, "mem size of pool", "local async prefetch limit=percentage" from isql.

CR:456080

CR Number:   456080 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   Unknown Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 4.5 05 Jun 2007 Added to user documentation 23 Jun 2008 Fixed Description Problem: When using the [CIFS] section of GridNode.ini to store the user and password for connect to a file server, projects that should store Textfiles on a UNIX server fail with the message "tree connect failed: NT_STATUS_ACCESS_DENIED". Resolution: On UNIX, installations of Sybase ETL Server ini file settings are not read by the GridNode application unless you have a GridNode.ini in place. To specify settings for the GridNode application you need to: 1. Make a copy of the Default.ini file named GridNode.ini in the etc subdirectory of your installation path. 2. Specify general settings (to be shared by all applications) in Default.ini. 3. Specify exclusive settings for the GridNode application in GridNode.ini. 4. Disable (remove or comment) the keys for general settings in GridNode.ini. Workaround Description  Put all the settings in the Default.ini file instead of the GridNode.ini file.

CR:456094

CR Number:   456094 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2009 Fixed 25 Mar 2010 Fixed Description DBISQL connects to wrong host in interfaces file when using standby addressing

CR:456145

CR Number:   456145 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) 28 Mar 2007 Fixed Description Wrong result could happen when "FOR BROWSE" mode is used and the query has an ORDER BY on some expression.

CR:456150

CR Number:   456150 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2007 Fixed Description Update the bundled JRE release to address the following issues: 1) The implementation of RSA signature verification in SSL/TLS, or other application scenarios, may incorrectly verify forged signatures leading to security vulnerability. See http://www.sybase.com/detail?id=1047991 for more details. 2) U.S. Daylight Saving Time Changes in 2007, see http://www.sybase.com/detail?id=1048699 for more details.

CR:456156

CR Number:   456156 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) 18 Jun 2007 Fixed Description Enable "for xml all" within message payload for ASE messaging sending/publishing messages.

CR:456218

CR Number:   456218 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) 05 Mar 2007 Fixed Description SELECT INTO statements that source a union view that references a virtual computed column will generate recompilation errors. In the case of a batch, a 225 error is generated: Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.

CR:456223

CR Number:   456223 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 Mar 2007 Fixed Description The message "current process infected with 11" together with a stack trace may be reported in the error log if a GROUP BY used on a comupted column with sum and count aggregates including a distinct clause.

CR:456225

CR Number:   456225 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2007 Duplicate Description Since CMC is no longer being supported by Microsoft the customer needs MAPI style added to the server. Prelimanary code that does this was given to the customer but it is not in the code line and I was unable to get it compiled on my server under 12.5.x.

CR:456260

CR Number:   456260 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) 22 Mar 2007 Fixed 08 Mar 2007 Fixed Description When using RTDS (version 4.0 and before) with MQ, messages larger than 1MB cannot be sent or received. Workaround Description  Customer can try to break up each large message into chunks smaller than 1MB and use grouping functionality of MQ.

CR:456314

CR Number:   456314 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2007 Fixed 06 Mar 2007 Fixed Description Wrong result could happen if the query has an equality predicate between two expressions (expr1=expr2) and through some other equijoin predicate(s), all the columns referenced in the predicate can be completely mapped to one joining table and at the same time also completely mapped to another joining table. For example, "t1.c1+2=t2.c1*2 and t1.c1=t2.c1".

CR:456393

CR Number:   456393 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) 01 Mar 2007 Fixed Description Query with having clause with a subquery and correlated aggregate will not evaluate correctly having clause if it uses IS NULL operator.

CR:456429

CR Number:   456429 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description UPDATE STATISTICS should be able to sample index columns

CR:456431

CR Number:   456431 Product Name:   Sybase ETL Product Component:   GUI Status:   Closed OS:   Windows 2003 Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2008 Fixed Description Problem: File Content display in Text Data Provider. Resolution: When entering the configuration window of a text provider component, the file content is read with the current (default is ISO-8859-1) encoding setting. It is not reread when a different encoding is selected. The preview section of the configuration window displays data correctly (according to the current settings) and the functionality of the component is not affected. To read and display the file content with a specific encoding, either select the encoding in the configuration window and click Save or select the encoding in the Property section and reopen the configuration window.

CR:456498

CR Number:   456498 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2007 Fixed 29 Aug 2007 Not reproducible with latest version of the product available as of Resolution Date Description A 804 error reading "Unable to find buffer '<Buffer Address>' from cache 'Named Cache' holding logical page '<Page Id>' in sdes 'Sdes Address' kept buffer pool for object '<Object Name>', together with a stack trace showing modules 'pg_getdatapage_forinsert' and 'pg_release_alloc_page' may be raised while many concurrent sessions are INSERTing into the same sliced DOL table having a placement index.

CR:456532

CR Number:   456532 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) 20 Mar 2007 Fixed 20 Mar 2007 Fixed Description On Solaris, if ASE is configured for High Availability with SunCluster, the HA agent ase_monitor may print misleading error messages on every thorough probe, though the error occured only once. Target Version  15.0.2 Workaround Description  Restart monitoring.

CR:456534

CR Number:   456534 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2007 Fixed Description When dataserver of sjis and backupserver of eucjis are used, the dump command outputs the error of open server. Open Server Error: 16368.10.0.0 srv_senddone(): A message was initialized, but not completed. Workaround Description  Specifies the language of backupserver to be a RUN server file. -Ljapanese \ -Jsjis \

CR:456555

CR Number:   456555 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2007 Duplicate Description in some circumstances sp_monitorconfig may report the max used value greater than the configured value for the configuration parameters 'number of sort buffers' and 'procedure cache size' Workaround Description  N/A

CR:456569

CR Number:   456569 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2007 Fixed 24 Apr 2007 Fixed Description Some ALTER TABLE ADD <default> with MODIFY and/or DROP commands may fail with Msg 11050 in a HA environment. Workaround Description  The default clause is responsible for the error, so do not use both add column with a default and modify or drop in the same statement. Otherwise do not use defaults [1] alter table add columns with defaults in a separate statement from the modify and drop columns: 1> alter table LOGDMIT 2> ADD PARENTCODE VARCHAR(01) DEFAULT '0' NOT NULL 3> ADD PARENTORDERCODE VARCHAR(10) NULL 4> ADD SONTRANSQTY NUMERIC(4, 0) DEFAULT 0 NOT NULL Warning: Row size (7573 bytes) could exceed row size limit, which is 4012 bytes. OR [2] do not use defaults 1> alter table LOGDMIT 2> ADD PARENTCODE VARCHAR(01) null 3> ADD PARENTORDERCODE VARCHAR(10) NULL 4> ADD SONTRANSQTY NUMERIC(4, 0) null 5> MODIFY TDMMEMO1 VARCHAR(300) 6> MODIFY TDMMEMO2 VARCHAR(300) 7> MODIFY TDMMEMO3 VARCHAR(300) 8> MODIFY CHINATTENTION VARCHAR(200) 9> MODIFY ENGATTENTION VARCHAR(200) 10> MODIFY DRUGEXTERIOR VARCHAR(100) 11> MODIFY DRUGENGEXTERIOR VARCHAR(100) 12> DROP DRUGINTERACTIONMEMO 13> DROP DRUGMECHANISM 14> DROP PHARMACOKINETICMEMO 15> DROP MONITORTARGET 16> DROP SUCKLEANDPREGNANTMEMO 17> DROP LIVERMEMO 18> DROP KIDNEYMEMO 19> DROP AGEDDOSEADJUST 20> DROP INFANTDOSEADJUST 21> DROP CONTRAINDICATION 22> DROP PTEDUCATION 23> DROP POISONSOLVEWAY 24> DROP COMMONDOSE 25> DROP COMMONFREQ 26> DROP SUBSTITUTEMEMO 27> DROP DANGERDRUGINFO 28> DROP THINNER 29> DROP DILUTEWAY 30> DROP SPEEDANDPATH 31> DROP STABLEIMFO 32> DROP PURPOSE 33> DROP USEWAY 34> DROP FORGETSOLVEWAY 35> DROP ATTENTION2 36> DROP POSSIBLESIDEEFFECT 37> DROP PRESERVEWAY (0 rows affected) [93] %

CR:456575

CR Number:   456575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2007 Fixed Description Inserting values into columns with defaults may get Msg 233 on a HA secondary server.

CR:456598

CR Number:   456598 Product Name:   Sybase ETL Product Component:   Installer Status:   Closed OS:   AIX Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 4.2.2 25 Sep 2007 Fixed Description Problem: ETL Server installs successfully, but the following is reported during the install: "Space needed for installation: 0 KB" Resolution: The install scripts were changed to display the correct numbers.

CR:456683

CR Number:   456683 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) 27 Mar 2007 Fixed 25 Feb 2009 Fixed Description On platforms supporting directio, make directio as the default option for disk init/ reinit instead of dsync.

CR:456736

CR Number:   456736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2008 Fixed 28 Jul 2008 Fixed Description The DBCC DBCACHEREMOVE command is allowed to uncache a user defined temporary database from cache.

CR:456747

CR Number:   456747 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2007 Fixed Description For table with APL clustered index, sometimes a table scan is incorrectly reported as an index scan in diagnostics (such as showplan) when there is some predicate on the index column but not on the leading column(s).

CR:456802

CR Number:   456802 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2007 Not reproducible with latest version of the product available as of Resolution Date Description Previously in 15.0 or 15.0.1 ASE Plug-in, table Data panel would display null values after sorting a column multiple times. This has been fixed in 15.0.2 ASE Plug-in.

CR:456828

CR Number:   456828 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2007 Fixed 06 Mar 2007 Reservation Made 09 Mar 2007 Fixed Description A new configuration parameter "enable merge join" is added to enable/disable merge_join at server level. This configuration can be set to 0 - unset merge_join at server level. 1 - set merge_join at server level. 2 - set merge_join to default value (as per curent optgoal) at server level.

CR:458666

CR Number:   458666 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2008 Bundled Request Description Previously after changing the password for a login with an expired password, ASE Plug-in still remembered the old password. Now ASE Plug-in will remember the new password.

CR:460673

CR Number:   460673 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2007 Fixed 24 Mar 2007 Fixed Description Infinite 9835 errors raised by a parallel execution family after segmentation fault in HashBuf::HbBufSetRunInfo.

CR:460687

CR Number:   460687 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2007 Fixed 28 Jun 2007 Fixed Description The error 9947, "An attempt to allocate memory failed due to insufficient ASE memory." can be raised by DBCC CHECKVERIFY, if the number of faults found by DBCC CHECKSTORAGE is very big.

CR:460775

CR Number:   460775 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2007 Fixed 01 Mar 2007 Presently Not Targeted For Any Future Release Of This Product Description Enable LDAP User Authentication feature on Linux Opteron 64bit platform.

CR:460787

CR Number:   460787 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.1 27 Feb 2007 Fixed 15.0.1 01 Mar 2007 Fixed Description This CR fixed the statistic failure while upgrading a database from pre-15.0 server to 15.0.1 server on winx64 platform.

CR:460805

CR Number:   460805 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2008 Fixed Description Before you add or modify or drop columns on a table, you should run sp_depends to check if the current database has any stored procedures depending on the table you are changing. You might want to drop and re-create the stored procedures if necessary after changing table schema.

CR:460825

CR Number:   460825 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2007 Fixed 11 Mar 2008 Fixed Description Execute immediate queries referencing outer scope variables may sometimes fail with syntax error about non declared local variables.

CR:460847

CR Number:   460847 Product Name:   Adaptive Server Enterprise Product Component:   SDBE Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2007 Fixed Description When Tools->Performance Monitor is selected within Database Expert an additional ASE_SDBE is requested. When using a served license there will be insufficient quantity and Performance Monitor will not start. Use of unserved licenses works around this problem as they have unlimited quantity for a specific host so will allow Performance Monitor to start correctly. Target Version  To Be Determined Workaround Description  Use unserved licenses.

CR:460869

CR Number:   460869 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2010 Insufficient priority to fix 22 Jan 2008 Fixed Description SET PROC_OUTPUT_PARAMS OFF option incorrectly suppresses the return of the result value via the output parameters for the outermost procedure call. When this option is OFF, only the return of the output parameters to the client stream should be suppressed, but the output @variable should continue to return the result value to the application.

CR:460898

CR Number:   460898 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) 16 Mar 2007 Fixed Description In rare circumstances, stack trace which includes the modules 'traceassert' and 'dynmp__calc_objpoolsize' may be reported in the error log when running Diagnostic Server with large values of some configuration parameters.

CR:460902

CR Number:   460902 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2007 Fixed Description When a user changes the wash size of the smaller pool "sp_poolconfig ''default data cache'', ''2K'', ''wash=4444K''", though the wash size is changed in the sysconfigures table, it is not being written into the ".cfg" file. As a result of this, after reboot of the server, the wash size of ''2K'' pool is reverted back to DEFAULT

CR:460907

CR Number:   460907 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2007 Fixed 13 Jun 2007 One-off Provided 08 Jul 2008 Fixed Description Under certain circumstances, when ASE is using Java(enable java = 1) with multiple engines online, server may crash with signal 11 in kbfalloc routine.

CR:460911

CR Number:   460911 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2007 Presently Not Targeted For Any Future Release Of This Product Description feature request to have a timeout option to resolve hangs from wait on an I/O which never completes

CR:460936

CR Number:   460936 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2007 Fixed 06 Mar 2007 One-off Provided 09 Jul 2007 Fixed 09 Jul 2007 Fixed Description Installer is not able to find JVM on HP-UX 11.31

CR:461019

CR Number:   461019 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) 28 Feb 2007 Fixed Description Migration tool support for new encrypted column features.

CR:461066

CR Number:   461066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2007 Fixed 03 Apr 2007 Fixed 14 Mar 2008 Not a Bug Description Parallel query execution with runtime adjustment to serial execution may return incorrect results or fail with different unexpected errors if there are some DOL tables in the query and some expressions with result size bigger than 255 characters.

CR:461074

CR Number:   461074 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2008 Fixed 30 Jan 2008 Fixed 30 Jan 2008 Fixed 31 Jan 2008 Fixed Description ASE may return a wrong result set when a query is run at transaction isolation level 0 (dirty reads) on an All Pages Locked table and a covered non-clustered index scan is chosen by the optimizer as reported by the set showplan option with message "Index contains all needed columns. Base table will not be read." Workaround Description  To avoid index covering, add a column which is not an index key column to the SELECT list. But this can cause the increase of logical and physical I/Os and could affect performance. Alternatively, change the table format from APL to DOL since I have been unable (psalding) to reproduce the problem when using locking scheme 'lock datarows'.

CR:461095

CR Number:   461095 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) 02 Mar 2007 Fixed Description keycustodian is allowed to set the system encryption password.

CR:461097

CR Number:   461097 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) 05 Mar 2007 Fixed 08 Mar 2007 Fixed Description The uid of sysquerymetrics will be 0 when all table names in a query, which are not qualified by user name, are owned by the dbo. This change can be disabled by turning on Traceflag 15361.

CR:461165

CR Number:   461165 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 Feb 2007 Bundled Request Description Asynchronous pre-fetch of data and index pages is incorrectly disabled during the recovery of a database or when a transaction is rolled back. Workaround Description  N/A

CR:461167

CR Number:   461167 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) 05 Mar 2007 Fixed 14 Mar 2007 Fixed Description When OMNI tables are involved and no parallel is turned on, ASE aborts queries saying that there is insufficient threads configured.

CR:461169

CR Number:   461169 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2007 Fixed 27 Mar 2007 Fixed 02 Nov 2007 Fixed Description A 511 error "Attempt to update or insert row failed because resultant row of size <num> bytes is larger than the maximum size (1964 bytes) allowed for this table." may be reported during upgrade to 15*, during "upgrade step [ID 60], alter table (table sysstatistics)" when there are small histogram boundary values at the end of a sysstatistics row. Workaround Description  delete from sysstatistics, then retry the upgrade.

CR:461175

CR Number:   461175 Product Name:   Adaptive Server Generic Docs Product Component:   Adaptive Server Troubleshooting Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2008 Added to user documentation Description error 701 returns severity 17 and not 19 as is documented in TSG

CR:461196

CR Number:   461196 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) 08 Mar 2007 Fixed 13 Mar 2007 Fixed 29 Oct 2008 Fixed 08 May 2007 Fixed 14 May 2007 Fixed 16 Jun 2008 Fixed 29 Apr 2008 Fixed Description Update sp_lmconfig to allow the following license types to be specified: LP, LF, LR, LV

CR:461201

CR Number:   461201 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2008 Fixed 14 Jan 2008 Fixed 14 Jan 2008 Reservation Made Description Poll for all completed ct-lib I/Os issued from the engine every time the scheduler checks for I/O completion. Also, the engine does not relinquish CPU to the OS if there is any pending ct-lib I/O from that engine.

CR:461305

CR Number:   461305 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2007 Fixed 13 Mar 2007 Fixed 14 Mar 2007 Fixed Description A SELECT query with an OR CLAUSE may not return the correct results.

CR:461310

CR Number:   461310 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2007 Fixed 20 Mar 2007 Fixed 18 Apr 2007 One-off Provided 11 Apr 2007 Fixed Description Under random circumstances, the error "Cannot create msgqueue Xnnnnnnnn because it already exists" could be raised by the backup server. The chances are higher when there are several dumps running simultaneously.

CR:461319

CR Number:   461319 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2007 Fixed 05 Mar 2007 Fixed 18 May 2007 Fixed Description A distinct order-by query in a non-binary sortorder server may return too few rows. This can happen if the sum of unique distinct (from the select-list) and order-by columns is less than 32 and there are no character columns in the select list that are not also in the order-by list. Taking the following query as an example: select distinct a.a, a.c from A a, B b where a.b=b.b order by c In this case, "c" is the only character column in select-list and it appears in the order-by list. So, the bug occurs. If "a" was a character column, then the problem would not occur. Workaround Description  If the query can be modified, add any character-type column to the distinct's select-list that is not already in the order-by list and will have no impact on the distinct rows returned. A dummy column with any literal value will work.

CR:461343

CR Number:   461343 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) 14 Oct 2008 Fixed 01 Oct 2008 Fixed 15 Oct 2008 Reservation Made 15 Oct 2008 Fixed 15 Oct 2008 Fixed 16 Oct 2008 Fixed Description No support for manual migration of connections. The command can be used to migrate a connection into a logical cluster or instance for which the application or login is not bound.

CR:461349

CR Number:   461349 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) 14 Dec 2007 Added to user documentation Description Description of the following manual is wrong. Adaptive Server Enterprise 15.0 System Administration Guide: Volume 1 Chapter 5: Setting Configuration Parameters procedure cache size The default value of procedure cache size of ASE 15.0.x is 7000.

CR:461414

CR Number:   461414 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2007 Fixed Description sp_deviceattr doesn't allow setting of the directio flag on AIX Workaround Description  manually update spt_values: update spt_values set low=1 where name='directio'

CR:461451

CR Number:   461451 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2009 Fixed Description Improve the clarity of the description for the IndexID column in monCachedObjects table.

CR:461453

CR Number:   461453 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) 24 Jun 2008 Fixed Description New options: "with skip_global_index_rebuild" is added to drop partition Syntax: alter table table_name drop partition partition_name [with skip_global_index_rebuild] * If "with skip_global_index_rebuild" is provided, the global index will NOT be rebuild and the index of the table will be labeled as suspect. ** If "with skip_global_index_rebuild" is not provided, the global index will be rebuild. This is the default value. Given this qualifier, the command marks any participating global index as 'suspect', rather than rebuilding the index as would normally be done. This can make the command complete more quickly, at the expense of making an index unusable. To be made usable again, a suspect index must be dropped and recreated.

CR:461461

CR Number:   461461 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2007 Fixed 15 Mar 2007 Fixed Description An outer join query using DISTINCT and ORDER BY clauses may return incorrect results for COMPUTE predicates on expressions involving columns from the inner table or may raise a 325 error: "Adaptive Server finds no legal query plan for this statement."

CR:461469

CR Number:   461469 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2007 Fixed 12 Mar 2007 Fixed Description A timeslice error followed by a stack trace that includes the module db__diskremap_sysaltusages could result when trying to load a transaction dump on a big archive database.

CR:461470

CR Number:   461470 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2007 Fixed 12 Mar 2007 Fixed Description If reformatting plan is chosen and the worktable need to be filled more than once, it could cause wrong results. Workaround Description  At least for this particular query setting store_index off works around the problem and returns the correct results. set store_index 0

CR:461669

CR Number:   461669 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   RH Linux Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2007 Fixed 14 Aug 2007 Fixed Description On PPC64/Linux, if a dump is made with the compress option, the dump archive cannot be greater than 2GB. Workaround Description  Possibly use stripes to reduce compressed dump file size. Avoid using compression.

CR:461704

CR Number:   461704 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2007 Fixed 15 Mar 2007 Fixed Description In certain rare circumstances a cursor opened for update can calculate an incorrect row size for the newly updated row. This causes the cursor to fail and report error 669: "The length computation of the row <rowid> is wrong. Ensure that row-length is no greater than max possible size of <maxrowsize>. This error was detected during cursor scan fixups for cursor <cursor_name>. This is an internal error." Workaround Description  Change lock scheme to DOL In the Repro scripts, modify create_sel_cumul_abs_annuelles_detail.sql - change the CREATE TABLE statements for #emp_abs_annuel and #emp_abs_an_detail to add 'lock datarows'. Basically all tables on which cursors are declared need to be changed to datarows.

CR:461719

CR Number:   461719 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Closed OS:   Windows 2000 Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12053 06 Jun 2008 Duplicate Description Problem: When using an XML file that has EUC-JP encoding with multi-bytes characters in the "XML via SQL Data Provider" component, an error occurs during execution of the engine. Resolution: No workarounds exists - to be resolved in a future release.

CR:461735

CR Number:   461735 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2007 Fixed Description Stacktrace in CgpGlobal::CgpGenerate() might happen when a parallel plan is chosen where there is an Xchg operator above a Sequence operator.

CR:461765

CR Number:   461765 Product Name:   Adaptive Server Generic Docs Product Component:   Commands Reference Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2008 Fixed Description Documentation Request : reorg rebuild command is not supported for system catalogs.

CR:461850

CR Number:   461850 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2007 Fixed 14 Jan 2008 Fixed 30 Mar 2008 Fixed Description A new configuration parameter called 'bind to engine' added for Rep Agent. Using this Rep Agent may be forced to run on a particular engine.

CR:461898

CR Number:   461898 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2007 Fixed Description If an ASE user task causes a stack overflow exception on the Windows platform, this can cause the entire server to hang rather than terminating that one user task and continuing with others

CR:461911

CR Number:   461911 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2007 Fixed Description Previously Resource Limit Wizard failed to check whether the specified resource limit existed or not before creating the resource limit. This has been fixed.

CR:461925

CR Number:   461925 Product Name:   Sybase Unicode Infrastructure Library Product Component:   Sybase Unicode Infrastructure Library Status:   Closed OS:   NA Original Version:   7.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2013 Insufficient priority to fix Description Change Unilib unisort_StringCompare function to include an option to consider ignorable characters to be given primary during sorting.

CR:461964

CR Number:   461964 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   Windows 2003 Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2007 Not a Bug Description Problem: If a fixed-length file includes multi-byte characters, the "Text Data Provider" doesn't appear to read the file correctly. The position of columns does not fit into a multi-byte file although it fit into single-byte file. The delimited file with multi-byte characters has no problem. Resolution: All column numbers, lengths and sizes in the text source and target are counting Unicode code points and NOT bytes. This means that a code point/character will ALWAYS occupy the space of one code point/character, no matter what encoding is used and regardless of the space used by the representation on disk in the specified encoding. For example a Japanese character will always be counted as one code point, whether the encoding is shift_jis, euc_jis, UTF-8. UTF-16, or UTF-EBCDIC all of which will encode the code point with a different number of bytes.

CR:461969

CR Number:   461969 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   Windows 2003 Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2008 Fixed 23 Jul 2008 Fixed 05 Nov 2008 Fixed 27 Aug 2008 Added to user documentation Description Problem: The export function of Text Data Sink component appears to be counting a Multi-byte character as 1 byte data. Therefore, when exporting the data by using type=Fixed(Variable Line), The number of the spaces can be confusing. Resolution: All column numbers, lengths and sizes in the text source and target are counting Unicode code points and NOT bytes. This means that a code point/character will ALWAYS occupy the space of one code point/character, no matter what encoding is used and regardless of the space used by the representation on disk in the specified encoding. For example a Japanese character will always be counted as one code point, whether the encoding is shift_jis, euc_jis, UTF-8. UTF-16, or UTF-EBCDIC all of which will encode the code point with a different number of bytes.

CR:462036

CR Number:   462036 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) 24 Apr 2007 Third Party Problem 28 Mar 2007 One-off Provided Description Instrumentation: ASE is unable to read TDS packets under load and reports invalid tdslength error

CR:462072

CR Number:   462072 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2008 Added to user documentation Description As a result of fixing CR#336646, "2" was added to the value of xp_cmdshell context. But the contents of a system management guide are not updated.

CR:462159

CR Number:   462159 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   15.0 tier2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2007 Fixed 06 Apr 2007 Fixed 08 Oct 2007 Fixed Description A query with a lot of AND terms in a WHERE clause may cause stack guardword corruption.

CR:462184

CR Number:   462184 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2009 Added to user documentation Description When ASE enable "net password encryption reqd" option, HS and MS failed login to ASE.

CR:462189

CR Number:   462189 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2007 Fixed Description If the configuration option "print deadlock information" is set and a deadlock occurs, ASE activates trace flag 3605 for the deadlock report but forgets to unset it after the report is finished, causing additional subsequent output to be written in the error log.

CR:462191

CR Number:   462191 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2007 Fixed 16 May 2007 Reservation Made 29 Jun 2007 Fixed Description The message text for error 15082 has been changed to indicate that it is not an error "There are <value> OAM entries with zero used/unused page counts. This is not an error. Run DBCC <value> FIX on objid <value> indid <value> to remove these entries as doing so will improve OAM scan performance.". Furthermore the message will be reported on objects with greater than 10 OAM pages and having 50% zero used/unused page counts OAM entries.

CR:462279

CR Number:   462279 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) 20 Mar 2007 Fixed Description A simple 1 table query with a predicate that represents a FALSE condition as 8 < 5, will cause the query to stack trace. This is because the partition elimination functionality cannot deal with a predicate that has been marked FALSE and results into a stack trace.

CR:462326

CR Number:   462326 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2007 Fixed Description "auditinit" creates sysaudits_XX tables without "nodeid" column in "sybsecurity" database. Also, the column "objname" in sysaudits_XX tables have varchar(30). It should be varchar(255).

CR:462331

CR Number:   462331 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) 21 Mar 2007 Fixed 10 Mar 2008 Fixed Description soc_printpeername should print port number of client associated with invalid tds

CR:462372

CR Number:   462372 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2007 Fixed 30 Aug 2007 Fixed 05 Sep 2007 Fixed Description With multiple checkpoint worker threads, a 216 error: " Attempt to automatically drop temporary table failed" may sometimes occur, preceded by a 3702 error: "Cannot drop the <tablename> because it is currently in use."

CR:462379

CR Number:   462379 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2007 Bundled Request Description For query like insert ... select distinct ... union all, signal 11 and stacktrace could happen in CgpUnion::_cgpInit().

CR:462504

CR Number:   462504 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) 14 Mar 2007 Fixed 06 Apr 2007 Fixed 08 Oct 2007 Fixed Description A query involving many AND/OR terms may cause stack overflow. Workaround Description  A Palliative is to increase the stack size, but really we should at least terminate the process gracefully.

CR:462671

CR Number:   462671 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2007 Fixed 10 Oct 2007 Fixed Description In one process, if it use sp_showplan <spid> to probe another process and if the target process which is being probed is blocked before entering new LAVA engine, it could cause stack trace in _LeOpShowOp() if plan use worktables.

CR:462696

CR Number:   462696 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2007 Fixed 20 Mar 2007 Fixed Description When ASE reports an I/O failure as a result of a hardware error, it reports an incorrect virtual page number for the failure.