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

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

CR:418002

CR Number:   418002 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2006 Fixed Description SYSAM SC Plugin under $SYBASE/SYSAM-2_0/SYSAMP for LM Server administration.

CR:418011

CR Number:   418011 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2006 Fixed Description Error 852 "Command Failed: Invalid request to move '<num>' buffers from the '<poolsize>'K pool of the '<cachename>' cache to the '<poolsize>'K pool. Source pool only contains '%ld' buffers. Retry the command specifying fewer buffers.", when raised,shows incorrect/garbled parameters.

CR:418028

CR Number:   418028 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) 13 Jan 2006 Fixed Description In a server having HA enabled, attempts to create a new user may fail with error 8013, "A CT-Lib operation failed during a native RPC," accompanied by a stack trace in the server error log.

CR:418038

CR Number:   418038 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2006 Fixed Description Simply add one more check box "Show agent attributes and operations" under "Enable Unified Agent (UA) related features" check box and the default is unchecked. This way we hide the Attributes and Operations panels by default.

CR:418043

CR Number:   418043 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 Feb 2006 Fixed 02 Feb 2006 Fixed Description Performance improvements for tables with large number of partitions.

CR:418053

CR Number:   418053 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2006 Fixed 01 Feb 2006 Fixed 01 Feb 2006 Fixed Description sqlupgrade doesn't install all system procedures on Japanese environment. Workaround Description  Change "set char_convert" statement in installmaster before starting sqlupgrade. Before: set char_convert 'iso_1' After: set char_convert 'eucjis' OR set char_convert 'sjis'

CR:418059

CR Number:   418059 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) 15.0.1 11 Jan 2006 Bundled Request Description Cache binding information is not being written to unpartition restamp log record. So, during runtime rollback, the pages are being fetched into the default data cache. This is leading to the condition that a page is in two caches at the same time. So, further attempts to fetch the page throws 693 error.

CR:418088

CR Number:   418088 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2006 Fixed 03 Apr 2006 Fixed 03 May 2006 Presently Not Targeted For Any Future Release Of This Product Description When statistics are not available for the optimizer to make accurate estimates, the default selectivities could result in long compilation times before optimization timeout occurs, since the optimizer is searching for a better plan. The adjustment to cost estimates for joins when no statistics are available was to use a formula similar to pre-15.0, which based on the larger of the rows counts from either side of the join. Workaround Description  use "set option show_missing_stats on" tracing to determine which columns do not have statistics and create statistics, and if this is not sufficient, then increase the number of histogram values used for existing statistics so that the optimizer estimates are more accurate.

CR:418096

CR Number:   418096 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2006 Fixed Description Update the Meta Data stored procedures used by ODBC, OLE DB and jConnect drivers with upto date fixes. Following issues addressed: jConnect: System stored procedures like sp_tables and sp_stored_procedures do not allocate sufficient space for the input paramater @table_name. [CR 406276] jConnect: DatabaseMetaData.geProcedures() does not return procedures owned by non-sa_role users if the current login holds sa_role prileges. [CR 394097] jConnect: Request to support Savepoint feature as described in the JDBC 3.0 specifications. [CR 350092] ODBC Driver by Sybase: Installing the Driver Meta Data SQL scripts will leave the Adaptive Server with 'allow updates' enabled. [CR 406722] ODBC Driver by Sybase: System stored procedures like sp_tables and sp_stored_procedures do not allocate sufficient space for the input paramater @table_name. [CR 406276] OLE DB Provider by Sybase: Installing the Driver Meta Data SQL scripts will leave the Adaptive Server with 'allow updates' enabled. [CR 406722] OLE DB Provider by Sybase: System stored procedures like sp_tables and sp_stored_procedures do not allocate sufficient space for the input paramater @table_name. [CR 406276]

CR:418099

CR Number:   418099 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2006 Bundled Request Description In rare circumstances one or more ASE engines may remain non responsive after a Configurable Shared Memory Dump (CSMD) completes, causing an inability to connect to ASE. This issue does not apply to ASE running on the Windows platform.

CR:418114

CR Number:   418114 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2006 Fixed Description When a select statement contains concatenation of builtin functions that result in strings constants over 255 bytes, stack trace might occur in LeRun() -> concat().

CR:418116

CR Number:   418116 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2006 Fixed 26 Jun 2006 Not reproducible with latest version of the product available as of Resolution Date Description Selecting a column from a view containing unions of proxy tables may cause the front end isql to crash in core dump and segmentation fault.

CR:418117

CR Number:   418117 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2008 Added to user documentation Description Document states 9-13 for the 701 error message

CR:418153

CR Number:   418153 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2006 Fixed Description Signal 11 in PeBasicPredicate::PeAnySetAllPredBm occurs when "UNION ALL" is used in the SQL statement with "SELECT DISTINCT" Workaround Description  Do not use "UNION ALL" with "SELECT DISTINCT".

CR:418164

CR Number:   418164 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2006 Fixed Description The Job Scheduler Administration dialog always indicates the Job Scheduler on pre-15.0 servers is not running, even when it is running.

CR:418170

CR Number:   418170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 EC Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2006 Fixed 13 Jan 2006 Fixed 19 Jan 2006 Fixed Description The message "current process infected with 11" maybe reported in the errorlog together with a stacktrace which includes one or more of the following modules: 'proc__free', 'procrm' or 'proc__grab' if many processes were concurrently executing tasks that requires some quantity of memory and to satisfy those requests some unused procedures had to be removed from Procedure Cache to free up memory.

CR:418179

CR Number:   418179 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2006 Fixed Description stacktrace in _lopConsSequence() when a GroupBy query has a constant projection and a Having clause with only constant in it. Here is an example: select 'x' from mytable group by mycol having 'abc'='abc'

CR:418200

CR Number:   418200 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2006 Duplicate Description Adding instrumentation to diagnose the 696 errors.

CR:418234

CR Number:   418234 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2006 Fixed 02 Jun 2006 Not reproducible with latest version of the product available as of Resolution Date Description SELECT INTO (existing table) remote columns from remote TEXT/IMAGE source may result in Msg 280/3651/557 when the source columns comprise of more than one table from the same remote server.

CR:418271

CR Number:   418271 Product Name:   Adaptive Server Enterprise Product Component:   Graphical Plan Viewer Status:   Closed OS:   all Original Version:   15.0.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2006 Fixed Description Plan Viewer now allows user to update state for tables/columns that are missing density.

CR:418282

CR Number:   418282 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) 20 Dec 2006 Fixed 11 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description The process and locks folders has been modified to identify normal, blocked, and blocking processes via color codes (green, red, and yellow) respectively. Also the process folder is now split into two tabs normal & blocked.

CR:418295

CR Number:   418295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2006 Fixed 02 Feb 2006 Fixed Description Execution time increases, for an insert, as the number of partitions in the table are increased. The performance degradation is due to redundant memory allocation during DMLs.

CR:418296

CR Number:   418296 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   Windows XP Original Version:   Minerva Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2006 Fixed 16 Mar 2006 Fixed Description PowerDesigner include 10 & 11.x and 12.0 , fail to support XML Schema when the Schema file has Namespace with more than one attributes get same value (e.g. urn , uri or url etc) inside. Workaround Description  There is no acceptable workaround without change the XML Schema file. Only a workaround to make PowerDesigner function normally , by changing the XML Schema file Namespace tag : There is more than one Namespace attribute with same URN (line 41): <xsd:schema targetNamespace="urn:oasis:names:specification:ubl:schema:xsd:CoreComponentParameters-1.0" xmlns:ccts="urn:oasis:names:specification:ubl:schema:xsd:CoreComponentParameters-1.0" xmlns="urn:oasis:names:specification:ubl:schema:xsd:CoreComponentParameters-1.0" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified" version="1.0"> The same URN at both "xmlns:ccts" and "xmlns" confuses PowerDesigner. After modifying the Namespace by (1) removing "xmlns:ccts", and (2) removing all references to "ccts", PowerDesigner works fine on both Merge Model and generating XSD file on XML model. Modifications: --------------------- (1) <xsd:schema targetNamespace="urn:oasis:names:specification:ubl:schema:xsd:CoreComponentParameters-1.0" xmlns="urn:oasis:names:specification:ubl:schema:xsd:CoreComponentParameters-1.0" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified" version="1.0"> (2) e.g. From: <xsd:element name="Component" type="ccts:ComponentType"/> To: <xsd:element name="Component" type="ComponentType"/>

CR:418322

CR Number:   418322 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2006 Fixed Description ASE running on the HPUX/Itanium platform does not retry i/o operations in the event that they are interrupted by signals from the operating system. This can result in an operation being reported as 'failed' when simply retrying the operation would result in success.

CR:418381

CR Number:   418381 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2006 Fixed Description For the ASE plug-in in Sybase Central, the database usage properties no longer display logsegment utlization.

CR:418409

CR Number:   418409 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2006 Fixed 17 Mar 2006 Fixed 02 Jun 2006 Bundled Request Description Syconfig encounters an error when it attempts to increase the size of the sybsystemdb database on servers with a 16k page size. It alters the database with a value that is smaller than the minimum.

CR:418448

CR Number:   418448 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2006 Fixed 05 Oct 2006 Fixed Description Siginal 11 could happen in _lopConsCmds() when the query contains a correlated subquery and the correlation is on some outer query block other than the immediate parent outer query block. Here is an example: select 1 from t17a where 1 in (select cint2 from t17c where cint2 <= (select (select 100 from t17b where t17b.ctype = t17a.ctype)))

CR:418459

CR Number:   418459 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2006 Fixed 14 Feb 2006 Fixed 10 Mar 2006 Fixed 19 Mar 2006 Fixed 17 Mar 2006 Fixed Description While executing the jobs having job command text > 1800 characters, the jobs may not get executed and even jsagent process and Job Scheduler task in ASE may terminate. As a result of Job Scheduler task terminating, messages such as "Job Scheduler Task set to stop", "Job Scheduler Task was not stopped by a Task shutdown request" etc. appear in the errorlog file.

CR:418463

CR Number:   418463 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2006 Fixed Description The message "current process ... infected with 11" in module "bufdlink" may be reported in the error log if the SYBSYSTEMDB system database has been bound to a user named cache. The module "bufpindirty" will also be reported in the stack trace.

CR:418516

CR Number:   418516 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 EC Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2006 Not a Bug 04 Oct 2006 Fixed Description When ASE boots under graced license, it is not able to checkout expirable license for optional features despite possession of valid license. This CR fixes problem.

CR:418517

CR Number:   418517 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2006 Fixed Description List of existing schedules dislayed when creating a scheduled job may display two schedules with the same name. If either is selected, the first schedule will be attached to the scheduled job. Workaround Description  don't register a remote server as the JS server on a server where JS is installed.

CR:418519

CR Number:   418519 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) 04 Apr 2008 Fixed Description Group and Distinct Hashing Operators have been modified to support dynamically claiming more buffers from the tempdb cache (if it is a named cache). This is done provided there are still buffers available against the "max buffers per lava operator" configuration parameter for the given operator. This can significantly improve performance and reduce the tempdb space used. Use "set statistics plancost" to check for I/O against these operators or if you get an 1105 error.

CR:418523

CR Number:   418523 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SYSTEMPROCS:sp_spaceused gave wrong result when set rowcount = 1

CR:418567

CR Number:   418567 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2006 Fixed Description Enable Encrypted Column feature on HP Itanium 64bit platform

CR:418622

CR Number:   418622 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2006 Fixed Description Possible wrong result with missing predicate on the primary key for a DISTINCT under UNION ALL query .

CR:418638

CR Number:   418638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2006 Fixed Description For bulk insert, 925 error (Maximum number of used databases exceeded) could be reported when some number of insertion attemps are failed

CR:418693

CR Number:   418693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2006 Fixed Description Truncate APL table does not unkeep the buffers (kept for non-clustered index root pages)leading to 803 errors.

CR:418696

CR Number:   418696 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2006 Bundled Request Description JVM performance degrades after applying ESD #4 or ESD #5 on all platforms excluding sgi, hp and solaris 64-bit.

CR:418815

CR Number:   418815 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2006 Fixed 23 Jan 2006 Fixed Description WSDL files generated by the Perl SOAP-Lite toolkit fails to be processed correctly by ASE Web Services Consumer. The consumer.log file would contain two log messages similar to: INFO [Thread-1] - Begin parsing WSDL File: [<URL for WSDL file>] ERROR [Thread-1] - Workaround Description  *** Wednesday, January 18, 2006 2:36:49 PM *** cooperg *** Workaround Details: There are at least two different ways to modify the WSDL file to allow the ASE Web Services software to work properly. The option that is represented in the attached file below represents the WSDL file that we feel complies with the WSDL specification the closest. The modification is to add the name= attribute to the input and ouput sub-elements of the binding element. Specifically, we modified line 36 and 41 in the attached file. Original Line 36: <input> Modified Line 36: <input name="PingIn"> Original Line 41: <output> Modified Line 41: <output name="PingOut"> With the modifications in place, the following command creates one proxy table named Ping. sp_webservices 'add', 'http://localhost:8181/ModifiedNielsen.wsdl' By executing sp_help on Ping we find two columns both of type int named 'hey' and '_huh'. The expectation is that the following select statement will trigger the web service: select hey from Ping where _huh = 1 Next Steps: 1) Customer: Please provide answers to questions below. 2) Sybase Development: Continue work on creating a bug fix to handle the original WSDL file. Our questions for the customer are: 1) Can this workaround be used in the customer environment? 2) How was the WSDL file generated?

CR:418819

CR Number:   418819 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2006 Fixed 31 Jan 2006 Fixed 02 Feb 2006 Fixed Description When checking a table having text columns having very long text values, dbcc checktable() or checkdb() may erroneously report error 15059 state 2, "Partition ID mismatch found while checking table 'X'".

CR:418822

CR Number:   418822 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2006 Fixed Description When performing a disk init specifying a virtual device number of 127 and a size of 32 GB, an error message 5115 is reported and the disk init operation fails during initialization. Workaround Description  Problem ======= Because of virtual device no. being a signed integer(int32 datatype), there is a possibility of compromizing data integrity while initializing device with vdevno=127 in following case :- 1. Device 128 is already configured and present. 2. User tries to initialize deviceno 127 with size='32G' In this case, last virtual page number of the device is 2G-1. i.e. max positive number for signed int. While zeroing out the device 127, the loop variable becomes one greater than this limit, because of sign conversion becomes negative, and we try to write out the page of device 128. Workaround =========== If you want to initialize both the devices 127(32G size) and 128, then make sure that 1. You initialize the device 127 first and then initialize device with vdevno=128. Or 2. If you are initializing device 127 after 128, then for 2K page size servers, size of device number 127 can be made marginally smaller than 32G, i.e. 32G-512 pages (1M for 2K pagesize server, etc) There will not be any overwriting if you don't use device number 128 or 127 at all.

CR:418905

CR Number:   418905 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2006 Fixed Description Previously Table Properties Space page contained incorrect information. This has been corrected by displyaing results from sp_spaceused directly.

CR:418930

CR Number:   418930 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2006 Fixed 13 Oct 2006 Presently Not Targeted For Any Future Release Of This Product 28 Feb 2006 Fixed Description to solve the issue which the buffer manager cannot provide any more buffers when documents with large no. of namespace prefixes.

CR:418949

CR Number:   418949 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   15.0 EC Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2006 Fixed Description In rare cases, when delete from #temp table and there is a system attention, there could be a stack trace printed due to the attention. This doesn't mean corruption or any other problem with the server, it happens only with certain exact timing of the system attention. Workaround Description  No workaround.

CR:418952

CR Number:   418952 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2006 Fixed 16 Jun 2006 Fixed 16 Jun 2006 Fixed Description Error 2581 "Data page ... indicates that an overflow page is linked to it; however, the next page ... has not been marked as an overflow page." may be reported by DBCC CHECKTABLE on an All Pages Locks table that has a clustered index whose overflow pages deallocations needed to be redone by the recovery process either at boot time or after the LOAD TRAN command was run. Workaround Description  drop clustered index and re-create it.

CR:419007

CR Number:   419007 Product Name:   Adaptive Server Enterprise Product Component:   Language Modules Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2006 Fixed 26 Jan 2006 Fixed Description If the Korean locale is used, Open Client and Open Server application will fail due to a missing 'escape' character in the file $SYBASE/locales/message/korean/libinsck.loc [copyright] message. Workaround Description  Edit the file $SYBASE/locales/message/korean/libinsck.loc

CR:419058

CR Number:   419058 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2006 One-off Provided Description Instrumentation to diagnose corruption after hardware change. Options to verify disk writes by the house keeper and log information about IOs in an event buffer.

CR:419061

CR Number:   419061 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) 06 Mar 2006 Fixed Description In rare circumstances, upgrade of SYSSTATISTICS rows on a 16k pagesized server from ASE 12.5.x to ASE 15.0 might result in "invalid column length" errors.

CR:419085

CR Number:   419085 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2006 Fixed Description Job Scheduler GUI: A Schedule's Between time option is not being saved when selected. Workaround Description  *** Thursday, March 17, 2005 2:52:57 PM *** cooperg *** Make sure you always re-check the radio button for Between before applying changes to repeating Jobs.

CR:419141

CR Number:   419141 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2006 Fixed 09 Aug 2007 Fixed 16 Jan 2008 Reservation Made Description After abnormal termination of a network listener, a new listener cannot be started on the same port.

CR:419182

CR Number:   419182 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 Jun 2007 Fixed 23 Jun 2008 Added to user documentation Description A new option 'isolation_level' has been added to the existing builtin function pssinfo in order to retrieve the transaction isolation level of a given spid. Usage: pssinfo(<spid> | 0, 'isolation_level')

CR:419279

CR Number:   419279 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2006 Fixed 16 Feb 2006 Fixed 14 Feb 2006 Reservation Made 16 Feb 2006 Fixed Description Disable collection of data for the monOpenObjectActivity MDA table if a process encounters a stack overflow condition. Workaround Description  Disable the 'per object statistics active' configuration parameter

CR:419343

CR Number:   419343 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2006 Fixed Description DBCC CHECKTABLE will now report errors if these exist in the root key information area in the BTREE index root page.

CR:419355

CR Number:   419355 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2007 Duplicate Description sybmigrate may fail with error 102, 137 and 156 if database objects (ex. stored procs, triggers) include Japanese text.

CR:419370

CR Number:   419370 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request : Enhancement of sp_audit "cmdtext" command to support the "fail" and "pass" options.

CR:419380

CR Number:   419380 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2006 Fixed 23 Aug 2006 Fixed 24 Aug 2006 Fixed Description In rare circumstances, 511 error "Attempt to update or insert row failed because resultant row of size 1965 bytes is larger than the maximum size (1964 bytes) allowed for this table." or 9557 error "The server failed to create or update a row in table 'sysstatistics' because a varying-length column would start at offset 8192." is reported for sysstatistics during ONLINE DATABASE command after the database was loaded across platform. Workaround Description  Delete the statistics and recreate them using the delete and update statitics commands.

CR:419384

CR Number:   419384 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2006 Fixed Description In a server starved for procedure cache (701 errors), sessions may get a SEGV when attempting to unkeep buffers while closing a hash operator. This will only occur if the session received a 701 error during the acquire phase of said hash operator.

CR:419404

CR Number:   419404 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2006 Fixed Description Interactive SQL now accepts 'go' statement followed by a number. When executed, it repeat the comments the number of times.

CR:419509

CR Number:   419509 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2006 Presently Not Targeted For Any Future Release Of This Product 23 Feb 2006 Fixed 13 Sep 2006 Fixed Description RepAgent gives error 9209: RepAgent(8): Missing datarow in TEXT/IMAGE insert log record. Transaction log may be corrupt. when TEXT/IMAGE is inserted from XFS proxy table. Workaround Description  First copy data from XFStable to temp table, then from temp table to replicate table.

CR:419513

CR Number:   419513 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2006 Fixed 24 Jul 2007 Fixed Description DUMP TRAN will hang when attempting to truncate the log after an out-of-space error is reported in the scratch database of an archive database that is being dropped. Workaround Description  ^C the DROP DATABASE. The DUMP TRAN will complete. Then retry the DROP DATABASE.

CR:419526

CR Number:   419526 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) 23 May 2006 Fixed Description The stored procedure sp_addumpdevice unconditioanlly sets the device size to 5 MB when initializing an archive database device.

CR:419553

CR Number:   419553 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2006 Fixed Description During query optimization, if a relation in the query is not available (dropped/database shutdown etc.) then the query optimizer may not be able handle this situation leading to stack traces. This fix ensures that the optimizer generates an appropriate error message for such situations.

CR:419660

CR Number:   419660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2006 Fixed Description Under rare circumstances it may not be possible to drop a stored procedure, unless ASE is restarted, if a session failed to execute this stored procedure because of error 216 "Attempt to automatically drop temporary table failed." that was hit due to disk space shortage in a temporary database and ASE has also aknowledged an attention event (Control-C) emitted by this session following these errors. Workaround Description  None.

CR:419687

CR Number:   419687 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2006 Fixed Description Documented pre-required steps for cross platform dump database

CR:419714

CR Number:   419714 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2006 Fixed Description Statement cache remains on inspite of configuring 'set EXPORT_OPTIONS ON' and 'set statement_cache off' in a login script. Workaround Description  Customers are currently disabling server-wide if there is a problem with replication performance under statement cache.

CR:419722

CR Number:   419722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2006 Fixed 29 Apr 2006 Fixed Description A 691 error, "Encountered invalid logical page '0' while accessing object '8' in database '<dbid>'.", 623 or 806 error is reported by ONLINE DATABASE command after loading a database with a cross-platform dump and the database is in read-only mode. Workaround Description  Unset the read only option for the database.

CR:419753

CR Number:   419753 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2006 Fixed 21 Feb 2006 One-off Provided 09 Mar 2007 One-off Provided 13 Jun 2007 One-off Provided Description A connection that uses encrypted passwords retains a lock on syslogins while waiting for the client application to send the password causing concurrency problems.

CR:419772

CR Number:   419772 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2006 Fixed 13 Feb 2006 Fixed 05 Jun 2006 Fixed 14 Feb 2006 Fixed Description 692, 695, 697 or 903 error etc might be returned for the load target database or other databases after load database, if the dump file is created by backupserver which is started with -m option and/or BLOCKSIZE option of DUMP command. Workaround Description  Do not use -m option with backupserver when running DUMP command. or Make sure the dbmap (sysusages) of the target database which is being loaded is same as the source database's which was dumped.

CR:419775

CR Number:   419775 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) 17 Apr 2006 Fixed Description Job Scheduler database, sybmgmtdb, may not be freeing space as defined by the user in the the JS Administration window.

CR:419801

CR Number:   419801 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) 10 Apr 2006 Fixed 11 Apr 2006 Fixed Description ASE fails to start with TLI style interfaces entry Workaround Description  Use the TCP style entry in the interfaces file.

CR:419817

CR Number:   419817 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2006 Fixed Description Union ALL query with Compute clause could hit signal 11 in CgpPop::CgpInplaceUpdateVars().

CR:419840

CR Number:   419840 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2006 Fixed Description Previously when user clicked "Find..." on Connect dialog and could not find servers, the error message was an just an ID "ERR_NO_SERVERS_FOUND". The actual error message has been restored.

CR:419846

CR Number:   419846 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3.a ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2006 Fixed 17 Feb 2006 Fixed 12 Feb 2006 Fixed 24 Feb 2006 Fixed 23 Feb 2006 Fixed Description After an INSERT_SELECT into a table with encrypted columns from a UNION of SELECT statements, a subsequent SELECT on the target table will generate the error, "Msg 15413, Level 18, State 5, An internal error occurred during an encryption operation (errorcode -1). Please contact Sybase Technical Support". Workaround Description  Use two or more queries instead of using "union all" to insert data

CR:419878

CR Number:   419878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2006 Bundled Request Description Repeated execution of "sp_ldapadmin suspend/activate" command intermingled with creation of new user login sessions can lead to hung login attempts.

CR:419974

CR Number:   419974 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2006 Fixed Description The message "current process infected with 11" in the module 'ind__get_sysindrow' together with a stack trace may be reported in the error log if a trigger containing "inserted" or "deleted" is fired on a table that has been renamed and that the old table name is used on another object (e.g. a view).

CR:420011

CR Number:   420011 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2006 Fixed 02 Feb 2006 Fixed Description On servers supporting encrypted columns, report mode (only) in sybmigrate gives error "Internal Error: 'Encryption Key' is not a valid migration task type" when executed in non-gui mode and 'encryption_key_migrate_list=<ALL_OBJECTS>' is specified in the resource file

CR:420020

CR Number:   420020 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2008 One-off Provided 12 Dec 2006 Fixed 31 Jan 2007 Fixed Description Joins between un-partitioned tables take longer time in parallel mode. In general query plans, where the number of producer and consumer processes are mismatched by a vast marging (a factor of 4 or more), the optimizer does not take into account the required slow down because of a blocked or empty pipe as may be the case.

CR:420084

CR Number:   420084 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2006 Fixed Description This is customer's request. For ASE15.0, no matter the client can support large identifier or not, the ASE will send the large identifier names to the client and this could cause the problem. To fix this problem, the ASE will check if the client could support large identifier or not, if the client does not support large identifier and the identifier name is longer than 30 bytes, the ASE will raise an error msg; otherwise, sending the large identifier.

CR:420096

CR Number:   420096 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2006 Fixed 28 Jul 2006 Not reproducible with latest version of the product available as of Resolution Date Description Selecting max with merge join and backward scan may result in wrong result. Workaround Description  disable either "sort-merge" or "backward scan" Trace flag 390 and 396 should work

CR:420135

CR Number:   420135 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 Auditing Request : to have an event code for a specific dump tran command

CR:420142

CR Number:   420142 Product Name:   Adaptive Server Enterprise Product Component:   Graphical Plan Viewer Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2006 Fixed Description Plan Viewer now supports localization

CR:420146

CR Number:   420146 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2006 Fixed 22 Feb 2006 Presently Not Targeted For Any Future Release Of This Product Description If during a cursor FETCH a severe error such as runtime conversion error (overflow, divide by zero, format error, etc.) OR subquery error like 512 OR a deadlock is hit, then a subsequent cursor FETCH may fail with error 803 resulting in the session being killed with a stack trace reported in the error log showing modules 'curs_fetch' and 'bufkeep'. With this fix, the default behaviour is to end the cursor scan. However, if Adaptive Server is started with the 589 trace flag, then the cursor is implicitly closed instead. Workaround Description  Trace flag 589 maybe used as a workaround to close the cursor & avoid phantom lock.

CR:420165

CR Number:   420165 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.0.1 16 Feb 2006 Fixed Description Reduced compilation of queries when a large number of tables are joined.

CR:420186

CR Number:   420186 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Microsoft Win32s Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2006 Fixed 27 Apr 2006 Fixed Description XPSERVER on Windows: XPserver will be killed by the Service Control Manager if it is sent an 'interrogate' event by utilities like "IBM Director" or sc.exe. Event viewer will show "error 7016: The Sybase XPServer_JEK2K1253_XP service has reported an invalid current state 0." Workaround Description  None known. ASE will start XPserver again on the next xproc but this can cause start up delays.

CR:420196

CR Number:   420196 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2006 Fixed Description If the query has an equijoin under OR and the same joining column is also part of an equality sarg under the same OR branch, e.g. "... OR ( u.USERID = i.OFFERED_BY AND u.USERID = 'U01')", sometimes the server could stacktrace around CgpIndScan::_CgpIndSpecialOrPePredBmToScalar() or hit error 206(Operand type clash).

CR:420204

CR Number:   420204 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2006 Fixed Description Procedural object caching may result in signal 11 in some rare cases. The signature of the stack trace will include: s_getTreeOrPlan()->proc_get()-> proc_read()->alloc_proc()->kisignal()

CR:420205

CR Number:   420205 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2006 Fixed 17 Apr 2006 Fixed Description A 206 error "Operand type clash: <datatype1> is incompatible with <datatype2>" maybe be raised when executing a stored procedure containing a SELECT CONVERT( <java datatype1>, <java datatype2>) statement in a database that was loaded from a dump of a database with different dbid. If the source database is dropped errors 913, "Could not find row in sysdatabases with database id <dbid>. Run DBCC CHECKTABLE on sysdatabases." and 11060 "This statement has exceeded the maximum number of recompilations (10). This indicates an internal error. Please note the error prior to this one and contact Sybase Technical Support" are raised instead. Workaround Description  *** Friday, February 03, 2006 1:34:19 PM *** cooperg *** Drop and recreate the stored procedure.

CR:420206

CR Number:   420206 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2006 Fixed Description False 7930 error may be generated for index upgraded from 12.5.x when dbcc checktable is used Workaround Description  reorg rebuild correctes the 2559 errors

CR:420392

CR Number:   420392 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2006 Fixed Description Regression fix. We should log seperate restamp log records for the following pages. 1. OAM pages 2. last page in the datapage chain of partition. This is because these pages get modified after restamp operation. For recovery to proceed properly, they should be logged seperately.

CR:420402

CR Number:   420402 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) 09 Feb 2006 Fixed Description In a highly active system, Load Transaction could in theory fail in rolling forward a sort, with unpredictable errors regarding the identity of the table or primary index that is the source of the sort.

CR:420453

CR Number:   420453 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 Feb 2006 Fixed Description The message "current process infected with 11" in the module 'bufdlink' together with a stack trace that includes 'bufpindirty' may be reported in the error log when running DBCC CHECKALLOC on a database that has tables and/or indexes that are bound to a cache other than the 'default data cache' and the configuration parameter 'number of large I/O buffers' is too small. Workaround Description  If the problem occurs on a normal database, then do not use the 2506 trace flag or increase the size of the "number of large I/O buffers" configuration parameter. If the problem occurs in an archive database, the only workaround is to ensure that no tables or indexes in the database that was dumped (and subsequently loaded into the archive database) are bound to a cache.

CR:420501

CR Number:   420501 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2006 Fixed 15 Jan 2008 Added to user documentation 15 Aug 2006 Fixed 01 Jul 2010 Insufficient priority to fix Description In the semi-graphical tree, diagnostic values get truncated when they exceed the widths of the node provided.

CR:420535

CR Number:   420535 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) 22 Feb 2006 Fixed 30 Mar 2006 Fixed 02 Dec 2007 Not reproducible with latest version of the product available as of Resolution Date Description The optimizer may choose to run a join query using sort merge join instead of nested loop join while the nested loop join may show better performance.

CR:420572

CR Number:   420572 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2006 Fixed 06 Mar 2006 Fixed Description reformatting (store_index) costing can be way off (mainly due to wrong row count number being used). It could, for example, cause an optimal plan with reformatting not being chosen when useful index scan is not available inner to a nested loop join.

CR:420600

CR Number:   420600 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2006 Fixed 31 Jul 2006 Fixed Description The root cause of the problem is: SQL statement "create proxy_table ..." failed to execute when a large (has more than 254 columms) DOL table has a lock scheme that is different from the server's default lock scheme. The fix is: For a large DOL table, use SQL "create existing table ..." to create proxy table. Unlike "create proxy_table", "create existing table" allows definition of lock scheme. This ensures the proxy's table's lock scheme is the same as the source table's.

CR:420626

CR Number:   420626 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2006 Fixed Description Not all missing multi-attribute densities were shown when running the "set option show_missing_stats on" command that prints missing statistics for a query. This has been fixed with this resolution.

CR:420740

CR Number:   420740 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2006 Fixed 07 Mar 2006 Fixed Description If the tempdb cache has multiple pools (e.g. 2k and 16k), then it was possible for queries with hash operator's to get into an infinite loop in cm_cache_wash() (as seen from sybmon stack dumps). This was caused by the hash operator incorrectly grabbing buffers from the tempdb's cache's largest pool. This has been fixed. Note, that in these cases, the session could not be killed. Workaround Description  Workaround seems to be to: a) use a 16K pagesiz b) disable allrows_dss

CR:420797

CR Number:   420797 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2006 Fixed Description Alter table repartition on table with clustered index on descending column can run into error 1530. Workaround Description  Drop the clustered index on descending column before alter table and recreate it afterwards.

CR:420814

CR Number:   420814 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3.a ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2006 Fixed Description Error 2513 may occur when dbcc catalogcheck is run on a database where columns are encrypted using more than one key from a different database.

CR:420844

CR Number:   420844 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2006 Fixed Description DDLGen generates partition spec definition of range partitioned tables in lexical order of partition names, whereas they shoud be generated in increasing order of partition range bounds.