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

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

CR:357181

CR Number:   357181 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2004 Fixed Description The amount of memory needed by Adaptive Server may be overestimated. This could happen when a large number of "open objects", "open databases" or user-defined caches are configured so that following an upgrade, Adaptive Server may be unable to boot. The following message, "The value of the 'max memory' parameter (<value>) defined in the configuration file is not high enough to set the other parameter values specified in the configuration file...", is reported in the error log. Workaround Description  1. reduce the cache partition: e.g. 1 cache partition for each of the cache 2. reduce the number of named caches or just one big data cache.

CR:357188

CR Number:   357188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2006 Fixed Description Under some circumstances, on a heavily-loaded multi-engine system and multiple clients running java (activated through "enable java" configuration parameter), the message "current process infected with 11" or "current process infected with 10", together with a stack trace in function Opinvokevirtual or Opinvokestatic or Opinvokespecial may be reported in the errorlog.

CR:357215

CR Number:   357215 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2005 Fixed Description If ASE started from Windows services the jsagent.log is stored in the c:/winnt/system32 dir.

CR:357220

CR Number:   357220 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2005 Fixed Description Query using a view with big number of aggregates may be executed slowly if more than one worktable is necessary to resolve aggregates from the view. Workaround Description  use 8k server.

CR:357225

CR Number:   357225 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2004 Fixed Description This CR is to complete CR 322069. When the target database contains a very large number of tables/indexes, checkstorage may produce a timeslice whose stacktrace contains the function 'pchk_pt_sort_grp'. Increasing the 'cpu grace time' parameter may alleviate this problem.

CR:357241

CR Number:   357241 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2004 Fixed 29 Jun 2004 Fixed 10 Jan 2006 Fixed 07 Jul 2004 Fixed 22 Jul 2004 Fixed Description Interactive SQL is integrated with ASE Plug-in in the following places: - "Utilities" folder: launch Interactive SQL requiring new logon infomration - Servers: launch Interactive SQL and connect to the servers - Database: launch Interactive SQL and connect to the server of the database and switch to the database - Tables and views: launch Interactive SQL to view table or view data

CR:357333

CR Number:   357333 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This change in behaviour is pretty nice in that sense that the database is not marked suspect because one of its devices was not available at boot time. In anycase trying to use the database won't succeed. So after I have fixed the device issue and restarted ASE all if fine. There doesn't seem be a need of marking the database suspect. This nice change in behaviour is due to the parallel recovery feature.

CR:357336

CR Number:   357336 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2010 Presently Not Targeted For Any Future Release Of This Product 16 Mar 2010 Presently Not Targeted For Any Future Release Of This Product Description In Sybase Central there is a feature to allow users to monitor ASE using Monitor Server, this is available on Windows platforms but not within UNIX.

CR:357452

CR Number:   357452 Product Name:   Adaptive Server Enterprise Product Component:   sqlloc Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2004 Duplicate 10 Jun 2004 Duplicate Description sqlloc 12.5.2 fails to install japanese language Workaround Description  Step 1 : $ charset -Usa -P binary.srt eucjis SQLServer message 4017, state 1, severity 16: Neither language name in login record 'japanese' nor language name in syslogins '<NULL>' is an official language name on this SQL Server. Using server-wide default 'us_english' instead. Loading file 'binary.srt'. Found a [sortorder] section. This is Class-1 sort order. Finished loading the Character Set Definition. Finished loading file 'binary.srt'. 1 sort order loaded successfully Step 2 : $ isql -Usa -P Msg 2401, Level 11, State 2: Server 'm1252_linux32a': Character set conversion is not available between client character set 'eucjis' and server character set 'iso_1'. No conversions will be done. Msg 4017, Level 16, State 1: Server 'm1252_linux32a': Neither language name in login record 'japanese' nor language name in syslogins '<NULL>' is an official language name on this SQL Server. Using server-wide default 'us_english' instead. 1> sp_configure 'default character set id', 140, bin_eucjis 2> go In changing the default sort order, you have also reconfigured SQL Server's default character set. Parameter Name Default Memory Used Config Value Run Value Unit Type ------------------------------ ----------- ----------- ------------ ----------- -------------------- ---------- default character set id 1 0 140 1 id static (1 row affected) Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect. Changing the value of 'default character set id' to '140' increases the amount of memory ASE uses by 6 K. (return status = 0) 1> shutdown 2> go Step 3 : Restart server...it'll show warning as below and will shutdown automatically. 00:00000:00001:2004/06/07 18:50:58.01 server *** WARNING ****************** 00:00000:00001:2004/06/07 18:50:58.01 server Attempting to change default character set ID from 1 to 140 00:00000:00001:2004/06/07 18:50:58.01 server SQL Server booted single user mode - updates allowed to system catalogs 00:00000:00001:2004/06/07 18:50:58.01 server *** WARNING ****************** Step 4: Restart again. Step 5: Do langinstall. [msabapat@tako install]$ langinstall -Usa -P japanese eucjis ................ Loading datetime information from file /tse_work/msabapat/1252_32/locales/japanese/eucjis/common.loc. Loading system messages from file /tse_work/msabapat/1252_32/locales/japanese/eucjis/server.loc. Error line 7726: Format count of message 19178, version 1252, does not match English message. Error: (-43) Line in localization file too long line = 7862 00:00000:00011:2004/06/07 18:54:49.83 server Configuration file '/tse_work/msabapat/1252_32/ASE-12_5/m1252_linux32a.cfg ' has been written and the previous version has been renamed to '/tse_work/msabapat/1252_32/ASE-12_5/m1252_linux32a.002'. 00:00000:00011:2004/06/07 18:54:49.84 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'. 7479 Messages processed. Loading complete. Summary: 0 deleted, 7092 inserted, 0 updated, 385 duplicates, 2 unsuccessful. Now you wont get Msg 2401 and 4017 when logging in using isql as below. [msabapat@tako install]$ isql -Usa -P 1> shutdown 2> go

CR:357477

CR Number:   357477 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.8 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2004 Fixed 11 Jun 2004 Fixed Description A 871 error, "Process <spid> is trying to release a latch on buffer <value> (dbid: <value>, pageno: <value>) without holding a latch on the buffer." may be raised in module 'getnext' or 'dol__get_lock' when the given process selects rows from a Data Only Locked table while DML commands are taking place concurrently by other processes.

CR:357658

CR Number:   357658 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) 14 Jun 2004 Fixed Description In an HA environment that is configured "with proxy_db", the error "Infected with 11" followed by a stack trace that includes the module 'palt__gen_addcol_clause' will be printed in the error log and the process will be killed when a table is altered to add a new non-null column without providing a default. A 4997 error, "ALTER TABLE '<tabname>' failed. Default clause is required in order to add non-NULL column '<colname>'", should be printed instead. Workaround Description  Use a default clause during alter table when specifying not null

CR:357688

CR Number:   357688 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2004 Fixed Description A 530 error, "Attempt to insert NULL value into column ... in work table (table id ...) column does not allow NULLS. UPDATE fails." may be raised when a java class running inside the ASE's JVM is connecting to the server using the internal JDBC driver and then executes a query on a table that has wide columns and a worktable is necessary to resolve that query. Workaround Description  'alter table node_attribute_definitions modify description varchar(255)' may workaround for column decription varchar(1024) is a wide column, change it's length to 255 can avoid the problem.

CR:357772

CR Number:   357772 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   athena Fixed Version Build Resolution Date Closure Code (If Appropriate) Description XML model generated from OOM or from PDM When generate an XML model from an OOM, cardinalities defined on an association are lost. Steps to reproduce New OOM : class diagram, java 2 classes with few attributes one association between those classes association properties multiciplicity : class_2 0..1 class_1 4 generate an XML the concept of cardinality is lost For the customer : the generated XML should reflect this with constrains

CR:357807

CR Number:   357807 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) 09 Dec 2004 Fixed 27 Sep 2005 Fixed Description When a device is created without specifying the complete path, there are times it is not started at startup. Request to implement one of the following: 1. Require a full path to be entered at disk init. 2. Append the current working directory to the device name when a full path name is not entered. 3. Raise a warning if a device is created without a full path. Workaround Description  *** Wednesday, June 09, 2004 7:07:17 AM *** cooperg *** See description notes.

CR:357839

CR Number:   357839 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2004 Fixed Description The command DUMP TRAN <dbname> TO <devname> WITH STANDBY_ACCESS may take too much time to stop when interrupted with Ctrl C or killed from another session.

CR:357841

CR Number:   357841 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2004 Fixed Description Sql containing many updates to the same column in a sql update statement can cause many 264 error messages and even result in a segv or access violation. Workaround Description  Assure that the client sql doesn't generate multiple updates to the same column in the same statement (minimally not too many of them!!)

CR:357895

CR Number:   357895 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Microsoft Windows NT Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2004 Fixed 28 Apr 2005 Fixed 28 Apr 2005 Fixed Description ASE running on the Windows Server 2003 platform does not produce correct stacktrace if ASE executable sqlsrvr.exe is not found in the current working directory.

CR:357912

CR Number:   357912 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2004 Not reproducible with latest version of the product available as of Resolution Date Description In HA setup, sp_password when executed by the login whose password has already expired does not synch the password on the companion side. To work-around, person with "sso_role" could run "sp_password" on the account whose password has expired from either of the companion servers. Workaround Description  you can ask person with "sso_role" to reset the password on both the companion servers upon password expiration.

CR:357933

CR Number:   357933 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2006 Not reproducible with latest version of the product available as of Resolution Date Description ASE Plugin: unichar & univarchar columns are displayed as twice their actual length. Workaround Description  n/a

CR:357972

CR Number:   357972 Product Name:   Adaptive Server Generic Docs Product Component:   XA Guide for CICS Encina and Tuxedo Status:   Open OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In the "Component Integration Services User's" doc "http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/omni_ug/@Generic__BookView", in "Chapter 2 Understanding Component Integration Services",under "Proxy tables" section, under the "Example of remote table definition" there is an issue that a customer has. The example shows how to create a remote table, under the assumption that the reader is login as "sa". We need a Note or a Step stating that if you are not logon in as user "sa' then you need to logon in as "sa" and under the "master Database" and "grant connect to USERID", then relogin as the USERID. Even thought this is documneted else where in the CIS DOC and in the Reference DOC under "Connect TO".

CR:358003

CR Number:   358003 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2004 Fixed 05 Nov 2004 Fixed Description When configuring the JOB scheduler, if the password is omitted from the sp_addexternlogin stored proc and you execute a job, the following errors are continuously logged in the jsagent.log and eventually grows until you run out of disk space. 00:00005:00001:2004/06/02 12:47:20.75 worker Client message: ct_get_data(): user api layer: external error: Item 1 has already been read. Workaround Description  *** Thursday, June 10, 2004 10:09:01 AM *** cooperg *** Make sure password is set when configuring external login.

CR:358007

CR Number:   358007 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2004 Fixed 07 Sep 2004 Fixed 15 Nov 2004 Fixed Description Stored procedure executing INSERT into a table with some VARCHAR columns may incorrectly leave trailing spaces in the VARCHAR column if the source of the data is a table with CHAR column. Workaround Description  Boot ASE with -T7709 to desactivate the fix for CR 326477. It should help for majority of cases when the problem is hit from the stored procedure. (Please look at the note at end of Description for checking and fixing incorrect trailing spaces)

CR:358030

CR Number:   358030 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) 31 Aug 2004 Fixed Description When a checkstorage check on an object is aborted, the database id, object id, index id and additional context information is printed to the errorlog.

CR:358035

CR Number:   358035 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2010 Fixed 17 Nov 2011 Fixed Description sp_locklogin cannot be executed from a database other than the master database after HA is setup. Workaround Description  Qualify the sp with the master database master..sp_locklogin instead of just sp_locklogin

CR:358062

CR Number:   358062 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2004 Fixed 25 Mar 2004 Presently Not Targeted For Any Future Release Of This Product Description An 820 error, "Attempt to dirty non-log buffer <bufptr> which is in I/O.", with state 6 may sometimes be encountered while truncating a Data Only Locked table, if the HOUSEKEEPER garbage collection task is enabled.

CR:358087

CR Number:   358087 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2006 Fixed 26 Jun 2007 Fixed Description The default value of configuration parameter 'dtm detach timeout period' has been modified to 5 minutes. Any external transaction such as XA transaction will be rolled back, if in detached state, for more than 5 minutes. A value of 0 will disable external transaction timeout.

CR:358090

CR Number:   358090 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2005 Fixed 12 May 2005 Reservation Made 19 May 2005 Fixed Description Two new builtin functions have been added, XA_GTRID(<xactname>, 0) and XA_BQUAL(<xactname>, 0) that decode an XA transaction <xactname> and report the decoded GTRID or BQUAL as a VARBINARY value. These builtins are useful in mapping XA transactions on Adaptive Server to XA transactions within the XA TM. Workaround Description  N/A

CR:358092

CR Number:   358092 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.8 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2004 Fixed 06 Sep 2004 Fixed 11 Oct 2007 Duplicate Description When forcing an index, the optimiser considers only the 1st SARG.

CR:358148

CR Number:   358148 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) 23 Jun 2004 Fixed 27 Jul 2004 Fixed Description On Sun Solaris 8 when ASE was booted with traceflag 7841 allowing for preliminary IPv6 support ASE_JAVA applets failed to establish IPv4 oriented network communications.

CR:358196

CR Number:   358196 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2004 Fixed Description Request to add reference in Transact-SQL User's Guide

CR:358239

CR Number:   358239 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) 22 Jun 2004 Fixed Description INTERNAL ONLY: Booting the server with a mirrored master device causes a seg fault.

CR:358269

CR Number:   358269 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2004 Fixed 15 Jul 2004 Fixed 01 Nov 2005 Fixed 03 Nov 2004 Fixed Description A SELECT UNION query using a view which is materialized whereby columns of the view are used in an outerjoin-clause can return incorrect results. Workaround Description  Use same datatype for the columns involved in the outer join, except "char not null" which is posing problem (on table A in the repro).

CR:358292

CR Number:   358292 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2004 Fixed Description Historical Server may sometimes crash if an error occurs whilst reading ASE sysmon counters.

CR:358397

CR Number:   358397 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2004 Fixed 05 Aug 2004 Fixed Description Transient 806, 691, 605 errors may be seen in very rare circumstances when multiple sessions are scanning the same page of an index in an Allpage Locked table.

CR:358402

CR Number:   358402 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2004 One-off Provided Description Under certain race conditions, it is possible for a disconnecting thread to be assigned to another login and reassigned to another engine before the disconnect processing is completed.

CR:358404

CR Number:   358404 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2004 Fixed 15 Feb 2007 Fixed Description Under very rare circumstances, some 821 or 813 errors may be raised for a very busy multi-engine ASE having a buffer cache shortage.

CR:358410

CR Number:   358410 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Configuration Guide for UNIX Status:   Open OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Remove net-library references from ASE documentation.

CR:358418

CR Number:   358418 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2004 Fixed 30 Jun 2004 Fixed Description Monitor tool to display in English only.

CR:358421

CR Number:   358421 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2004 Fixed Description When space remaining at the end of a disk piece happens to equal exactly the size of the smallest permitted block of space, create- or alter-database will not select that piece.

CR:358450

CR Number:   358450 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) 22 Jun 2004 Fixed Description If a new data cache is created using sp_cacheconfig, the "APF Percent" for the default memory pool may be incorrectly set to zero when Adaptive Server is next rebooted. This can cause performance degradation when accessing any objects that are bound to this data cache. Workaround Description  Set the APF value manually using sp_poolconfig as soon as the cache has been created. For example: sp_cacheconfig "new_cache", "100m" go sp_poolconfig "new_cache", "2k", "local async prefetch limit=10" go

CR:358510

CR Number:   358510 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2006 Bundled Request Description Database Properties Usage page is modified. It now reports the following information (derived from sp_spaceused): database size, reserved space, used space (by data and indexes), unused space, and unreserved space.

CR:358541

CR Number:   358541 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.8 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2004 Presently Not Targeted For Any Future Release Of This Product 01 Sep 2004 Fixed 22 Oct 2004 Presently Not Targeted For Any Future Release Of This Product 25 Oct 2004 Fixed 14 Oct 2005 Failed Description When a database is created with quoted_identifier enabled, and the name is specified with quotes, the quotes are stored in the catalog as part of the name. As a result, accessing the database requires the quoted_identifier setting and enclosing the database name in quotes. Changes have been made not to store the quotes or trailing blanks with the database name. The database can be accessed with or without quotes now. The new behaviour can be reverted using the Traceflag 113.

CR:358556

CR Number:   358556 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) 27 Jul 2004 Fixed Description Users will notice that when reviewing the properties for a schedule, the start time will display the actual start time specified by the user, either when the schedule was created or when the time was last updated in the properties window rather than the current server time.

CR:358591

CR Number:   358591 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2004 Fixed Description T-SQL Guide 12.5.x has misleading information in Table 19-5 (18-5 in 12.5 manual)

CR:358598

CR Number:   358598 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) 22 Jun 2004 Fixed 28 Sep 2005 Fixed 29 Aug 2005 Fixed Description The message "infected with 11" together with a stacktrace containing the modules 'apg__setop', 'ap_generate' and 's_ap_capture' is printed in the errorlog when "abstract plan dump" is configured and a SELECT containing a UNION with a simple SELECT like SELECT "<string value>" is executed. Workaround Description  don't use AP dumps.

CR:358608

CR Number:   358608 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2004 Duplicate Description One cannot monitor cancelled/disconnected transactions via kill with statusonly utility except if an explicit rollback is executed

CR:358636

CR Number:   358636 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2005 Fixed Description The instruction in the Systems Administration Guide, Chapter 29 - Restoring the System Databases under "Recovering the master database" are misleading. Instructions in 12.5.1 SAG to restore master device are misleading and there is also techdoc # 1028123 - Recovering an Upgraded Master Device and master Databases in ASE 12.5.x, that points to the SAG. (generic problem) Instructions should also differ based on 12.5/ebf versions. The Techdoc needs to be fixed, until the SAG can be corrected.

CR:358654

CR Number:   358654 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2006 Fixed Description 'set statistics plancost on' will display the I/O counts for a given paralle query, form the alf athread as well as from the child threads in a semi-graphical format.

CR:358699

CR Number:   358699 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2004 Not a Bug 29 Sep 2004 Fixed 06 Oct 2004 Fixed Description The process of searching for a JRE to use is now more robust. The search for a JRE follows the following steps: 1) The SYBASE_JRE environment variable 2) Search for JRE 1.4 at $SYBASE/shared-1_0/JRE-1_4 3) Search for JRE 1.3 at $SYBASE/shared-1_0/JRE-1_3

CR:358758

CR Number:   358758 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2004 Fixed Description When a transaction is being implicitly rolled back by ASE, then the command "KILL <spid> WITH STATUSONLY" will mistakenly report the message "Status report cannot be obtained. ROLLBACK for spid:<spid> is not in progress.".

CR:358800

CR Number:   358800 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2004 Fixed Description On AIX platforms, there may be a problem with populating the aio_return field of an aio control block in a timely fashion within the ASE.

CR:358835

CR Number:   358835 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2004 Fixed 23 Sep 2004 Fixed 05 Jan 2005 Fixed Description ASE running on the Windows Server 2003 platform does not produce a correct stacktrace when a problem occurs. This does not affect ASE running on Windows 2000 and earlier versions.

CR:358859

CR Number:   358859 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2006 Fixed 26 Jan 2006 Fixed 07 Feb 2006 Fixed Description A corrupt index may result with the root page having extra entries pointing to deallocated pages when an empty APL partitioned table is unsliced.

CR:358868

CR Number:   358868 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2004 Fixed 14 Nov 2005 Presently Not Targeted For Any Future Release Of This Product Description Character set conversions are rejected for older (DBlib) clients when the server's default character set is SJIS and the client's character set is EUCJIS. Workaround Description  No workaround

CR:358880

CR Number:   358880 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2006 EOL'd version. Not to be Fixed. 22 Feb 2006 Fixed 28 Feb 2006 Fixed Description 3.14.2.4 error "Logical page nnn is not in the given database map." might be returned if the load target database uses more than one database device and the dump file is created by backupserver which is started with -m option and/or BLOCKSIZE option of DUMP command.

CR:358907

CR Number:   358907 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   10.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2004 Fixed Description Error 17782: "You do not own a table or column (or index) of that name in the current database." may be reported upon running sp_rename(tablename.oldcol, newcol)when option ANSINULL is on.

CR:358954

CR Number:   358954 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) 05 Jul 2004 Fixed Description When CREATE TABLE and INSERT are in the same store procedure, and the table is a non-temporary table with IDENTITY column, the IDENTITY column data will be incorrect.

CR:358966

CR Number:   358966 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request: create a simply way to determine the highest average engine utilization since boot time.

CR:358969

CR Number:   358969 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2004 Fixed Description The monEngine.CPUTime value is not reset by sp_sysmon and therefore becomes inconsistent relative to the other values. This column is documented as "counter, reset".

CR:359029

CR Number:   359029 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2004 Fixed Description Table 10-6: Locking or dropping login accounts. Since 12.5.0.3, The Drop login account needs sso_role not sa_role.

CR:359031

CR Number:   359031 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2004 Fixed Description Since 12.5.0.3, sso_role has new privilege, "Drop login".

CR:359128

CR Number:   359128 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jul 2004 Fixed Description A 10479 error, "Conversion error detected while converting Java data to SQL data. Either the conversion is not supported or the datatype(s)is invalid." may be raised when using CONVERT() function to convert certain JAVA datatype values to NUMERIC SQL datatype values. Workaround Description  Use "set arithabort numeric_truncation off"

CR:359131

CR Number:   359131 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Galaxy2 19 Oct 2004 Fixed Description Server entries from interfaces file are listed on the new Servers panel (visible when Adaptive Server Enterprise item is selected).

CR:359135

CR Number:   359135 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) 16 Nov 2004 Fixed Description This new feature allows users to create and schedule jobs for tasks they perform from ASEPlugin without actually being in the Scheduled Job folder or even on a Job Scheduler ASE.

CR:359140

CR Number:   359140 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Open OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2004 Fixed Description This new feature adds a new tab to the Server properties window so that users can register the Job Scheduler ASE to be used for remote job scheduling.

CR:359172

CR Number:   359172 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2004 Fixed 02 Aug 2004 Fixed 05 Aug 2004 Fixed Description If Job Scheduler Task fails to initialize, infected with 10 in kbfalloc() is caused by running sp_sysmon with "cache wizard". Workaround Description  Reinstall installjsdb of proper version

CR:359408

CR Number:   359408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2005 Presently Not Targeted For Any Future Release Of This Product Description ASE will incorrectly report the time when it has been booted with the TZ environment variable specifying a custom offset for daylight savings time, and daylight savings time is in effect. ASE will report the time as the normal one hour offset from standard time rather than the custom offset.

CR:359431

CR Number:   359431 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description modify the description for error 8221

CR:359486

CR Number:   359486 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2005 Fixed Description sp_poolconfig may not set wash size correctly. Workaround Description  Run sp_poolconfig again, if it doesnt take effect the 1st time.

CR:359705

CR Number:   359705 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2004 Fixed Description "Real Time Messaging Support" feature on HPUX 64 platform.

CR:359708

CR Number:   359708 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) 30 Aug 2004 Fixed 30 Aug 2004 Reservation Made 06 Oct 2004 Fixed Description New configuration options, 'max native threads per engine' and 'rtm thread idle wait period'. 'max native threads per engine' controls the maximum number of native threads that an engine can spawn. If this limit is reached, the ASE thread that requires the native thread will sleep until another thread releases a native thread. 'rtm thread idle wait period' is the idle wait period (in seconds) that a native messaging thread will wait for work. If this period is reached without new work, the native thread will fade itself out.

CR:359754

CR Number:   359754 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2004 Fixed Description CIS: In rare circumstances, a query with an aggregation and a GROUP BY clause on a same remote column will be passed to the remote server with some incorrect query text and return wrong results

CR:359822

CR Number:   359822 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2004 Fixed 09 Jul 2004 Fixed Description A 2610 error may be raised when data is inserted into a table having an index key column of DATE TIME datatype.

CR:359833

CR Number:   359833 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The issue is that in the "Troubleshooting and Error Messages Guide" in "Chapter 2 Encyclopedia of Tasks", under "Other Useful Tasks", "How to Reduce the Size of tempdb" 8- Verify that tempdb has one entry that looks like this: 1> select * from sysusages 2> where dbid = db_id('tempdb') dbid segmap lstart size vstart --- ------ ----- ---- ------ 2 7 0 1024 2564 The above information is incorrect, it was correct for 11.x, but as of ASE 12.X the above information is incorrect.

CR:360042

CR Number:   360042 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2004 Fixed Description sp_chgattribute limits the new maximum identity value to 17 decimal digits.

CR:360063

CR Number:   360063 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2004 Fixed Description Under large number of user connections, if connections are killed repeatedly, then subsequent logins may take a long time to get through resulting in slower response time.

CR:360170

CR Number:   360170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2004 Fixed Description CIS: When a database is marked for replication via sp_reptostandby, writetext to a file via a proxy table mapped to an external directory results in stacktrace. Workaround Description  Have to explicitely mark tables for replication

CR:360208

CR Number:   360208 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3 22 Jul 2004 Fixed Description XP Server was configured with a too small default stack size, causing many External Stored Procedures to fail and make XP Server crash under any exceptional ESP.

CR:360294

CR Number:   360294 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.0.0.8 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.0.0.8 ESD#3 23 Aug 2004 Fixed 23 Aug 2004 Fixed Description CIS: Reformatting causes errors 2409, 4017 when selecting from a view containing proxy tables. Workaround Description  Load the EUCJIS charset and Japanese language into the remote ISO_1 server.

CR:360308

CR Number:   360308 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2004 Fixed 23 Aug 2004 Fixed Description The message, "current process infected with 11" in the module 'is_subtree' together with a stack trace which includes the modules 'aggby' and 'normquery' may be reported in the error log if a query contains two subqueries in a HAVING clause and the second subquery has an aggregate.

CR:360372

CR Number:   360372 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 Nov 2004 Fixed Description Error 3626 is raised with the text 'Message empty' when the configured stack size is insufficient to run a query. Instead the text "The transaction was aborted because it used too much stack space. Either use sp_configure to increase the stack size, or break the query into smaller pieces..." should be reported.

CR:360414

CR Number:   360414 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2004 Fixed 30 Jul 2004 Fixed 08 Dec 2004 Fixed Description Under rare circumstances a session may hit a segmentation violation with message "current process (<value>) infected with 11" in module 'bufdlink' followed by a stack trace in the error log. This results in an implicit shutdown of ASE. Workaround Description  Do not bind user temporary databases to different named caches, OR have all user tempdbs bound to the same named cache.

CR:360416

CR Number:   360416 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2004 Fixed Description Under very rare circumstances, 696 or 605 errors may be raised for tables being bound to a named cache using the 'Relaxed LRU' strategy. Workaround Description  Revert back to the default cache replacement strategy i.e "strict LRU"

CR:360423

CR Number:   360423 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Bulletin for IBM Status:   Closed OS:   AIX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2004 Fixed Description Installation guide is confusing since the lib3p and lib3p64 directories do not exist in an AIX 5.1 installaiton as per the installation guide.

CR:360519

CR Number:   360519 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2005 Fixed Description ASE server was locking login account when number of unsuccessful login attempts reached value of "maximum failed logins". This CR, per customer request, is to generate an audit record when this event occurs.

CR:360566

CR Number:   360566 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.0.0.8 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2004 Fixed Description CIS: Under some circumstances, ASE may show some performance degradation when receiving large result sets from remote tables.

CR:360582

CR Number:   360582 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jul 2004 Fixed 05 Jul 2004 Fixed 09 Jul 2004 Fixed 09 Jul 2004 Fixed 23 Jul 2004 Fixed 23 Jul 2004 Fixed Description Not customer visible

CR:360587

CR Number:   360587 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2004 Fixed Description Improvements to resource governor functionality.

CR:360599

CR Number:   360599 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2004 Fixed Description The current limit of 1024 AND/OR conditions in a WHERE clause has been raised to 2000. In order to take advantage of this new limit, it is necessary to adjust the default stack size upward, to approximately 300K. No change to the stack size is required unless the application desires to take advantage of this new limit. In addition to stack space, this new limit may result in a need to allocate more procedure cache space to the server. The dataserver must be started with traceflag 404 ( -T404 ) to allow this new limit to take effect. Otherwise, the current limit of 1024 will remain. Workaround Description  None. There is a hard limit of 1024 defined by the macro MAXANDOR, in server.h

CR:360658

CR Number:   360658 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2004 Workaround Description improvements in regard to update statement on views using variables. Workaround Description  Instead of update df_poall_tst SET @UCNT = @UCNT + 1, @MED_LOW = dst_ut_id, @MED_HGH = dst_ut_id consider select @ucnt=count(*), @MED_LOW = dst_ut_id, @MED_HGH = dst_ut_id from df_poall_tst

CR:360689

CR Number:   360689 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2004 Fixed 21 Mar 2006 Fixed 01 Apr 2005 Presently Not Targeted For Any Future Release Of This Product Description The error 540, "Schema for table '%.*s' has changed since compilation of this query. Please re-execute query." will be incorrectly reported, if a table is accessed in the same batch it is created and it has any primary, foreign or referential key constraints.

CR:360699

CR Number:   360699 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   macosx Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2004 Fixed Description Backup server does not use asynchronous disk I/O, which was introduced in Mac OS X 10.3.

CR:360812

CR Number:   360812 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2004 Workaround 02 Jan 2008 Fixed 17 Dec 2007 Deferred Description Allow ASE to close one errorlog file, and open a new file without rebooting the ASE.

CR:360856

CR Number:   360856 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2004 Fixed 04 Aug 2004 Fixed Description Poor performance during index migtation when 'number of sort buffers' is DEFAULT (500). Workaround Description  Increase the number of sort buffers prior to migration of the indexes.

CR:360954

CR Number:   360954 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2006 Presently Not Targeted For Any Future Release Of This Product 20 Aug 2006 Fixed Description When executing system procedures that have non-ANSI comparisons such as "if @var = NULL", some procedures may show unexpected behaviour if 'ansinull' is set 'on' in the session from which the procedures are executed. Workaround Description  - Rewrite the system procedure causing the problem: replace '= NULL' or '!= NULL' by the corresponding ANSI syntax 'IS NULL' or 'IS NOT NULL'. - Or avoid setting the 'ansinull' option.

CR:360959

CR Number:   360959 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Configuration Guide for UNIX Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2004 Fixed Description Windows ASE Configuration Guide mentions obsolete information about sql.ini

CR:360969

CR Number:   360969 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2006 Fixed 25 May 2006 Fixed 23 Jul 2008 Fixed 23 Jul 2008 Fixed Description Eliminate duplicate wait event descriptions in the monWaitEventInfo MDA table.

CR:360975

CR Number:   360975 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2004 Fixed 17 Sep 2004 One-off Provided 28 Sep 2004 One-off Provided 23 Nov 2004 Insufficient priority to fix Description ASE returns a parameter xactstatus that the XA client never requested. This causes Open Server based applications to get the error "Output parameter not found" and consequently makes XA incompatible with Open Server.

CR:360978

CR Number:   360978 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2005 Bundled Request Description Not customer visible

CR:361050

CR Number:   361050 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2004 Fixed Description Data truncation may result when a univarchar column with length greater than 255 is updated through dynamic sql.