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

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

CR:279309

CR Number:   279309 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2003 Fixed Description Using BCP with packetsize larger than 32767 may fail on ASE running on the windows NT, Linux and Dec Alpha platforms. Workaround Description  use packetsizes < 65536

CR:279344

CR Number:   279344 Product Name:   ASE Replicator Product Component:   Distributor Status:   Closed OS:   Generic Original Version:   12.5.0.104P1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.0.0 06 May 2003 Fixed 12.5.0.105P2 12 Jun 2002 Fixed Description ASE Replicator: Sporadically, text/image replication fails when running for a long time.

CR:279406

CR Number:   279406 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2002 Fixed 24 May 2002 Fixed Description A 551 error or the message "current process infected with 11" is reported in the error log together with a stack trace when a row is inserted into a table that has a rule which references a constant value which is outside the range of the column datatype. Workaround Description  Ensure range falls in datatype range. Alter Create Rule R_ID AS @ID between 0 and 2000000000 to Create Rule R_ID AS @ID between 0 and 200000000 or exec sp_addtype 'T_ID','numeric(9,0)','not null' to exec sp_addtype 'T_ID','numeric(10,0)','not null'

CR:279474

CR Number:   279474 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2003 Fixed Description Check constraint expression shows name of the constraint along with the defination. This happens only when user changes the constraint name in the property page and applies the changes.

CR:279520

CR Number:   279520 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2002 Fixed 15 Jul 2002 Fixed Description When a connection is terminated while running Java, the message "Java services are temporarily unavailable while the Java system is being recycled" is reported in the error log and all other Java operations may be terminated so that no further Java operations can be performed. All subsequent attempts to use Java in ASE are rejected with a 10734 error.

CR:279558

CR Number:   279558 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2003 Fixed 13 Jun 2001 Presently Not Targeted For Any Future Release Of This Product Description CIS : Performance slows down when there are many idle CIS connections within ASE.

CR:279568

CR Number:   279568 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2002 Fixed 14 Jun 2002 Fixed Description The message "current process infected with 11" together with stack trace which includes the module 'jvmh_mem_p_sema' will be reported in the error log if a reference is made to a Java class before recovery has completed.

CR:279595

CR Number:   279595 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2002 Fixed 24 May 2002 Fixed Description If the source ASE has large free spaces in the logical devices and runs Migration Tool in "setup" session, Migration Tool will throw the IndexOutOfBoundsException error in "CALC_DEVICE_SIZE" thread.

CR:279606

CR Number:   279606 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.0.0.3 18 Oct 2002 Fixed 26 Jun 2003 Fixed Description ASE 12.0 used to send back the actual table name in the row format information when responding to PowerBuilder. Now with ASE 12.5 the view name is sent back in the row format information instead of the actual table name and this causes PowerBuilder to try an update against the view instead of the actual table.

CR:279616

CR Number:   279616 Product Name:   ASE Replicator Product Component:   DDBAdmin Status:   Closed OS:   Generic Original Version:   12.5.0.103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.109P6 31 Jan 2003 Fixed 2.0.0 06 May 2003 Fixed 12.5.0.109P6 16 May 2003 Fixed Description ASE Replicator: During initial setup, an instance directory is created and RUNinstance scripts are generated. On Unix, the RUNinstance script also has its permissions changed to include execute permission. If there is a problem setting the permissions, an uninformative error message is returned, and the sp_helpddb.sql script does not get generated which causes problems later on. Now, the sp_helpddb.sql script is generated first, and, if there is any problem setting permission on the RUNinstance script, a warning is logged in the system.log, but setup completes successfully. The user will have to manually set the proper execute permissions on the RUNinstance script.

CR:279617

CR Number:   279617 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2004 Insufficient priority to fix Description A request to allow aliases to the real server name to be used with kerberos network based security feature

CR:279641

CR Number:   279641 Product Name:   SybNotifier Product Component:   Engine Processing Status:   Closed OS:   Solaris 2.5.1 Original Version:   1.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2002 Not a Bug Description This is a test Workaround Description  WA : *** 05/15/2002 17:17:22 *** wkhan ***

CR:279816

CR Number:   279816 Product Name:   Sybase InstallShield Product Component:   InstallShield Status:   Closed OS:   Generic Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2002 Fixed 3.1 21 May 2002 Fixed 3.0 21 May 2002 Fixed 3.0 21 May 2002 Fixed 3.0 21 May 2002 Fixed 3.0 21 May 2002 Fixed 3.0 21 May 2002 Fixed Description This just removes the conditional line that would only add a flatfileRepositoryXML if there hadn't already been one added. In this regard, we always add one now. This will be a problem if there are ever two instances of the RepositoryInfoPanel in a single Wizard Tree. Not very likely... RepositoryInfoPanel: -Removed the conditional inside the build method that controls whether or not we add the xml file as a resource. -Removed all other references of the boolean.

CR:279855

CR Number:   279855 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Digital UNIX Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2005 EOL'd version. Not to be Fixed. 12 May 2005 Duplicate Description When a table in a DB2 DRDA Direct Connect has a VARCHAR column greater than 255, a SELECT statement that has a joins involving the VARCHAR column will fail. Workaround Description  none

CR:279862

CR Number:   279862 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2002 Fixed Description Incorrect limit of AND and OR in a query is returned in 404 error messege, as if the query exceeded the limit of 1024. The real limit is 300.

CR:279883

CR Number:   279883 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2002 Fixed 08 Jan 2003 Fixed 22 Sep 2002 Fixed 05 Sep 2002 Fixed 09 Jan 2003 Fixed Description Performance enhancements made to SELECT INTO by making use of large I/O and extent allocation for the target table, wherever possible. As a result, SELECT INTO may choose the largest I/O size possible for the target table, based on the size of the buffer pools available in the target database cache. ASE 12.5.0.3 will have this option on by default. ASE 12.0.0.7 requires the use of -T5304 to activate this enhancement.

CR:279902

CR Number:   279902 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2002 Fixed Description The message "Msg 225, Level 16, State 1 Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." maybe reported when executing a SELECT INTO statement using views in the FROM clause together with a UNION and a GROUP BY clause.

CR:279928

CR Number:   279928 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2002 Deferred 25 Sep 2002 Deferred 14 Jan 2003 Third Party Problem Description On the AIX platform, during situations of heavy I/O activity, ASE may report 823 errors. This occurs on the Regatta family of servers and is fixed by IBM APAR IY38226.

CR:279964

CR Number:   279964 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2004 Duplicate Description Process hit on error 1295 and sometimes some processes are blocked due a 'latch sleep'

CR:279981

CR Number:   279981 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   11.9.2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2002 Fixed 15 Nov 1999 Presently Not Targeted For Any Future Release Of This Product Description In rare circumstances, a 6902 error may be reported when recovering an aborted transaction at boottime or during LOAD DATABASE or LOAD TRAN, after an earlier stack trace was reported in the error log at runtime which included the modules 'terminate_process', 'hdl_default', 's_handle', 'ex_raise' and 'rec_undo_session'. Workaround Description  For the particular underlying cause for this customer (11.9.x), increase the no. of connections in order to increase the number of transaction descriptors.

CR:280035

CR Number:   280035 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2003 Fixed 31 Jan 2003 Presently Not Targeted For Any Future Release Of This Product Description In rare circumstances, a 2620 error may be reported during the reboot of Adaptive Server if it was terminated abnormally whilst LOAD TRANSACTION was in progress and it had recovered an index page split.

CR:280052

CR Number:   280052 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2004 Not a Bug 11 Nov 2005 Fixed Description A SELECT with an aggregate function containing a subquery on a proxy table mapped to a MS SQL Server table results in a 30291 error "Cannot perform an aggregate function on an expression containing an aggregate or a subquery."

CR:280073

CR Number:   280073 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2002 Fixed 10 Sep 2002 Fixed Description In rare circumstances, Adaptive Server may generate wrong results when executing extended stored procedures with parameters where no parameters were defined in the extended stored procedure declaration list. Workaround Description  Change the following line in the repro : from : 3. create proc xp_echo as external name "examples.so" to : 3. create proc xp_echo @type varchar(05) as external name "examples.so"

CR:280089

CR Number:   280089 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2002 Presently Not Targeted For Any Future Release Of This Product 02 Aug 2002 Fixed 04 Nov 2002 Fixed 13 Sep 2002 Fixed 13 Sep 2002 Fixed 13 Feb 2003 Fixed Description Under some conditions the optimizer may incorrectly assume that a scan is able to use I/O greater than 2K thus underestimating the cost of a plan. Workaround Description  1- create a named cache 2- enable sort-merger with sp_configure "enable sort-merge join and JTC",1 3 - change order of tables in the query

CR:280090

CR Number:   280090 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2002 Fixed Description ASE only sends out ENVCHANGE token when client is requesting a different character set from server's and character set conversion is enabled.

CR:280099

CR Number:   280099 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2002 Fixed 26 Sep 2002 Fixed Description 7411, 7417 or 7418 errors may be reported by DBCC CHECKCATALOG when checking a database that has a non-dedicated log and which contains user table extents in its log segment. Workaround Description  See CR description.

CR:280133

CR Number:   280133 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.0.0.6 11 Jun 2002 Fixed 12.5.0.2 18 Jun 2002 Fixed Description A stored procedure will sometimes be unnecessarily renormalized when it is run on a 32-bit server having originally been created on a 64-bit server.

CR:280148

CR Number:   280148 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2002 Fixed Description Executing a select textvalid(<image-column>) of a proxy table mapped to Oracle in a server configured for the utf8 charset caused a stack trace (current process infected with 11) in routine omni_parse_name.

CR:280177

CR Number:   280177 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2004 Fixed 30 Jul 2002 Fixed Description The use of CIS connections with SSL is fixed on Linux 32bit platform. CIS connections are used by Replication Agent, Proxy Tables, and CIS RPC calls, therefore SSL can be enabled to work with Replication Agent, Proxy Tables, and CIS RPC calls.

CR:280196

CR Number:   280196 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2002 Fixed Description User with "sa role" but without "sso role" can incorrectly execute SP_ADDLOGIN, SP_DROLOGIN and SP_LOCKLOGIN stored procedures.

CR:280231

CR Number:   280231 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2002 Fixed Description Added support to srvbuild for Linux ATARAID, RAID and LVM devices.

CR:280237

CR Number:   280237 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2002 Fixed Description Executing an ALTER DATABASE ... FOR PROXY_UPDATE command resulted in a stack trace (current process is infected with 11) in routine omni_parse_name when the server was configured for the utf8 character set and the remote server was Oracle.

CR:286067

CR Number:   286067 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2002 Fixed 18 Jun 2002 Fixed 21 Jun 2002 Fixed Description The automatic drop of a temporary table may sometimes fail with a 216 error together with a stack trace as a result of an incorrect 3702 error, "Cannot drop the table because it is currently in use". Workaround Description  N/A

CR:286077

CR Number:   286077 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2002 Fixed 05 Jun 2002 Fixed Description Setting the 'close on endtran' option in a session may result in error 559 or 102 when a SQL query involving proxy tables is executed.

CR:286078

CR Number:   286078 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2002 Fixed 14 Jun 2002 Fixed 24 Jun 2002 Fixed 25 Jun 2002 Fixed 10 Jul 2002 Fixed 12 Jul 2002 Fixed 31 Jul 2002 Presently Not Targeted For Any Future Release Of This Product Description 255 error may be returned for a grouped aggregate query with space() or replicate() builtin function. Workaround Description  Drop the view and create view WITHOUT group by clause. Use the "group by" clause in the "select" statement , instead in the "create view".

CR:286082

CR Number:   286082 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   HP-UX Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Insufficient priority to fix 05 Feb 2004 Not a Bug Description A select query by a view referencing a proxy table fails with 4409 error when a 'between' clause is used in conjuction with a correlated subquery Status: Reviewed Sep 2002. Fix targeted (but not commited) to the 12.0.0.7 release. Workaround Description  Create view view_test2 as select * from view_on_remote vl where isnull((select count(*) from sysobjects so where so.id < convert(int,vl.b1 ),0 ) between 1 and 5 go

CR:286098

CR Number:   286098 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2002 Fixed 12.5.0.2 25 Jul 2002 Fixed 03 Oct 2003 Not a Bug Description The occurrence of SIGURG (typically as a result of old style pre TDS5 cancel command) may result in ASE hang.

CR:286136

CR Number:   286136 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2002 Not a Bug 13 Nov 2002 Fixed Description Allow elapsed time resource limit to fire whether spid is issuing sql or not. Status: Reviewed Sep 2002. Feature targeted (but not commited) to the 12.6 release.

CR:286187

CR Number:   286187 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 5/23 03 Jul 2002 Presently Not Targeted For Any Future Release Of This Product 10 Jul 2002 Fixed Description Create proxy_table command against ASA/ASIQ may sometimes change the order of columns.

CR:286191

CR Number:   286191 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2003 Fixed 22 May 2003 Fixed 10 Jun 2003 Fixed 12 Sep 2003 Fixed 22 Aug 2003 Fixed 27 Oct 2003 Fixed 27 Nov 2003 Fixed Description The login audit event is extended to contain additional information such as the IP address where the login attempt originated. This feature can be disabled using the command line trace flag -T7603.

CR:286346

CR Number:   286346 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2002 Fixed Description Pre 12.5.0.3, on Digital True64 Unix, only synchronous i/o was supported for file system devices. In 12.5.0.3, asynchronous i/o on file systems is supported.

CR:286418

CR Number:   286418 Product Name:   SQL Remote for Adaptive Server Enterprise Product Component:   Database Tools Interface Status:   Closed OS:   Microsoft Windows 2000 Original Version:   7.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 8.0.2 3473 28 Jun 2002 Fixed 8.0.1 3018 28 Jun 2002 Fixed 8.0.0 2317 28 Jun 2002 Fixed 7.0.4 3348 28 Jun 2002 Fixed 7.0.3 2145 28 Jun 2002 Fixed 6.0.04 3801 28 Jun 2002 Fixed Description Starting with ASE 12.5 GA, TEXT columns modified on ASE would not have replicated correctly. They would have meaningless values such as '/00000016\x01'. IMAGE columns would replicate correctly. TEXT columns now replicate correctly.

CR:286421

CR Number:   286421 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2006 Fixed Description The fix displays percentage completion for dbcc gam().

CR:286430

CR Number:   286430 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2002 Bundled Request Description While reading the SYSGAMGS table, error 691 is encountered with a request to to read page 0 (object SYSALLOCPG); this error occurs when there is a corruption in the SYSGAMS extent allocation.

CR:286432

CR Number:   286432 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2002 Fixed 26 Nov 2002 Presently Not Targeted For Any Future Release Of This Product Description Missing SYSGAMS extents are not detected until a session tries to allocate space in the device fragments with no SYSGAMS extensions; this attempt results in a 605/691 error accessing a page for object SYSGAMS.

CR:286438

CR Number:   286438 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2002 Fixed 09 Oct 2002 Fixed 16 Sep 2003 Fixed 16 Sep 2003 Fixed Description Introduced new group on sp_sysmon for ASE replication agent performance and tuning analysis.

CR:286499

CR Number:   286499 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2002 Fixed 09 Jul 2002 Fixed Description CIS: The identity value does not increment when the command SELECT <select list> INTO <local table> FROM <remote table> is executed and an identity column is specified in <select list>.

CR:286576

CR Number:   286576 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.2 24 Jul 2002 Fixed 12 Nov 2002 Fixed Description EFTS: query on text index using a mix of sequenced operator index_any columns and non-sequenced operator index_any columns returns invalid results.

CR:286613

CR Number:   286613 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2002 Fixed 11 Jun 2002 Fixed 11 Jun 2002 Fixed Description In rare circumstance, a query which includes a LIKE clause and that uses the Dynamic OR strategy can return incorrect results.

CR:286644

CR Number:   286644 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Doc Set to reflect changes to buildmaster and sybinit utilities in ASE 12.5 and later. More detailed info in http://my.sybase.com/detail?id=1016939

CR:286674

CR Number:   286674 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) 10 Jun 2002 Fixed Description When ASE is configured for High Availability on Sun Cluster3.0, (1) the fault monitor program doesn't work if the environment file SYBASE.sh is not present in the specified location and (2) modifying any resource property fails.

CR:286675

CR Number:   286675 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) 21 Jun 2002 Fixed Description When ASE is configured for High Availability on Sun Cluster3.0, the fault monitor program doesn't work if the interfaces file is not present in $SYBASE.

CR:286717

CR Number:   286717 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2002 Fixed Description "Error: 1515, Severity: 20, State: 1" is found in the error log when a parallel query generates a sorted worktable on an object with an index generated from presorted data. Functions 'mjoin_open','pll_sort_open', 'sam_gen_distmap', 'sortclean' will be found in the error log. Workaround Description  sp_configure 'enable sort-merge join and JTC',0

CR:286718

CR Number:   286718 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2003 Fixed 17 Jul 2003 Fixed Description Ability to reserve at least one user connection for SA that can always be used to login to ASE, even if the user connections are all being used. This should allow sa to login to the server and maybe rectify the problem or shutdown gracefully. Status: Reviewed Sep 2002. Feature targeted (but not commited) for the 15.0 release.

CR:286719

CR Number:   286719 Product Name:   Sybase InstallShield Product Component:   InstallShield Status:   Closed OS:   Generic Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2002 Fixed 3.0 06 Jun 2002 Fixed 3.0 06 Jun 2002 Fixed 3.0 06 Jun 2002 Fixed 3.0 06 Jun 2002 Fixed 3.0 06 Jun 2002 Fixed 03 Aug 2002 Not a Bug Description This bug fixes the refresh issue on the summary panel. I had to change the InstallationSummaryPanel to remove _subPanel from the content pane and then re-add it every time we hit the entered method. This allows for re-calculation of activated products, and then draws them to the screen properly.

CR:286723

CR Number:   286723 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.2 05 Aug 2002 Fixed Description Support added for IBM's HACMP / ES under AIX 4.3.3 for ASE 12.5 Requires: AIX 4.3.3 Maintenance Level 7, HACMP/ES 4.4.1 (with its prerequisite RSCT) and two patches - APAR IY26561 & APAR IY26492.

CR:286756

CR Number:   286756 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2003 Fixed Description On various properties/wizard pages where a file path is needed, the browse button is disabled when the server is not running on the local host. Also a warning message tells the user that the path entered is relative to the remote host.

CR:286771

CR Number:   286771 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2002 Fixed 31 Jan 2003 Fixed Description Table Properties under Lockings Tab, option text is corrected to "Reserve page gap" from "Reseve page gap"

CR:286788

CR Number:   286788 Product Name:   ASE Replicator Product Component:   DDBAdmin Status:   Closed OS:   Generic Original Version:   12.5.0.103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.0.0 06 May 2003 Fixed 12.5.0.105P2 12 Jun 2002 Fixed Description ASE Replicator: If there is any mixed case or upper case in the fully qualified primary article name, then trying to add a replicate article that includes image/text columns for that primary article will fail.

CR:286789

CR Number:   286789 Product Name:   ASE Replicator Product Component:   Distributor Status:   Closed OS:   Generic Original Version:   12.5.0.103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.0.0 06 May 2003 Fixed 12.5.0.105P2 12 Jun 2002 Fixed Description ASE Replicator: Replication of images greater than approximately 16K fails -- only 450 bytes are replicated.

CR:286794

CR Number:   286794 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2009 Insufficient priority to fix Description Feature request to have sp_help show what datatype a user-defined datatype was declared as. For example, a datatype declared as a float(8) actually is stored as a real; sp_help currently shows that the datatype is a real with no way to reverse-engineer that it was actually declared as a float with a specified precision. Status: Reviewed Sep 2002. Feature targeted (but not commited) for the 15.0 release.

CR:286862

CR Number:   286862 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2002 Fixed 11 Oct 2002 Fixed Description With "sort_merge" enabled, the optimizer may sometimes fail to choose a cheaper non-merge join plan.

CR:286906

CR Number:   286906 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2002 Presently Not Targeted For Any Future Release Of This Product 19 Jul 2002 Fixed Description The message "current process infected with 11" in the module 'n3__get_sig_size' may be reported in the error log when an access rule based on a non-existant Java user-defined function is bound to a table column and this column is accessed via a subquery.

CR:286939

CR Number:   286939 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2002 Fixed 11 Jun 2002 Fixed 12 Jul 2007 Fixed Description In certain situations, trying to do an UPDATE to a row on an ALLPAGE locked table where the page already has 256 rows in it, may result in a 2620 error - "The offset of the row number at offset <offset> does not match the entry in the offset table of the following page: <pageid>." Workaround Description  Use DOL table instead of APL

CR:287000

CR Number:   287000 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2002 Fixed 29 Aug 2002 Fixed Description A 3944 error is reported when using a view, trigger or stored procedure that requires recompilation and the database is in READONLY or STANDBY_ACCESS mode. Likewise, the view, trigger or stored procedure is unnecessarily suspended temporarily when a QUIESCE DATABASE command is active.

CR:287087

CR Number:   287087 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2002 Fixed 25 Jun 2002 Fixed 04 Jul 2002 Fixed 18 Jul 2002 Fixed Description A 692 error, "Uninitialized logical page '<pageid>' was read while accessing object '14' in database '<dbid>'" may be reported in the error log when the database size exceeds 2016 GB.

CR:287133

CR Number:   287133 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2002 Fixed Description When a SQL Query on a proxy table is executed using JDBC interface, it may result in error 103, if the columns in a table are of length greater than 28 bytes Workaround Description  In the JConnect application, add ...executeQuery("execute <dummy stored procedure>") right after the connection is established. This will reset the P4_PROC_QUOTED_IDENT bit in the PSS. Yet, the problem might arise again later when a stored procedure in q

CR:287215

CR Number:   287215 Product Name:   Adaptive Server Generic Docs Product Component:   EFTS SDS and SFTS SDS Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2003 Fixed Description Remove "The highlighting feature is no longer supported." from EFTS - Chapter 6 (What's New in Version 12.0.1),Installation and Release Guide states.

CR:287221

CR Number:   287221 Product Name:   ASE Replicator Product Component:   Distributor Status:   Closed OS:   Generic Original Version:   12.5.0.103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.0.0 06 May 2003 Fixed 12.5.0.105P2 12 Jun 2002 Fixed Description ASE Replicator: Text/Image replication fails in cases where the LOB columns either precede or are interleaved with primary key columns in column order. In the case where all primary key columns are followed by the LOB columns, replication succeeds.

CR:287224

CR Number:   287224 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2003 Fixed Description list_appcontext ('contextname') raises error 11021 if less than 2 arguments are passed to the function Workaround Description  Use list_appcontext('*','*') if you need to list all the contexts in the current session. Use list_appcontext(context_name,'*') if you need to get info on a particular context.

CR:287236

CR Number:   287236 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2004 Bundled Request Description Feature request. Tempdb space and transactional elapsed time resource limits are enforced outside of their timerange.

CR:287353

CR Number:   287353 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2002 Fixed Description "NEW" is a Potential SQL92 Reserved Word, that is the reason why, it does not have the same restrictions as a T-SQL reserved word. ASE 12.5 Ref guide, Vol 1 Chap 8 http://manuals.sybase.com:80/onlinebooks/group-as/asg1250e/refman/@Generic__BookView lists "NEW" as a T-SQL reserved word and is erroneous.

CR:287392

CR Number:   287392 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2003 Fixed 21 Nov 2004 Presently Not Targeted For Any Future Release Of This Product Description CIS: In rare circumstances, a SELECT INTO statement which includes outer join of proxy tables may return wrong result. Workaround Description  Use T11210 or Use ANSI Style outer join.

CR:287401

CR Number:   287401 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2002 Fixed 03 Mar 2003 Fixed Description In rare circumstances the message "current process infected with 11" may be reported in the error log together with a stack trace which includes the module 'a_rgused' when processing a query that contains an aggregate within a subquery. Workaround Description  None available.

CR:287419

CR Number:   287419 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   12.5.0.1 Intl Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2002 Fixed 16 Jul 2002 Fixed Description The script "$SYBASE/$SYBASE_ASE/bin/sybmigrate" is changed to use Bourne Shell because not all platforms have Korn shell.

CR:287474

CR Number:   287474 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 Jun 2002 Fixed Description When ASE is configured for High Availability on Sun Cluster3.0, if any error condition occurs (because of incorrect configuration, such as -e option not specified for dataserver in RUN_server_file) the fault monitor program doesn't exit properly. Because of this, the fault monitor program keeps loading and exiting infinitely without doing its job, i.e monitoring ASE and taking appropriate actions such as restarting/failing over ASE as and when required.

CR:287501

CR Number:   287501 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2002 Fixed 11 Sep 2002 Fixed 22 Aug 2002 Fixed Description An 806 error may be reported, or DBCC CHECKTABLE may report 7951 or 12953 errors on text pages that originate from a pre-12.0 installation and which, subsequent to upgrading to 12.0 or beyond, have been the target of an UPDATE or DELETE operation that has been rolled back. This differs from CR 276568 in that it fixes text pages that have already been incorrectly modified. CR 276568 fixes the original problem. Workaround Description  bcp out data,truncate table,bcp in data

CR:287505

CR Number:   287505 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2003 Fixed 25 Aug 2003 Fixed Description Feature request to remove or make configurable the limit on the size of the symbol table, which limits the number of variables allowed in a batch. Error 1908 is currently raised if more than ~2-3 thousand variables are declared in a batch.

CR:287513

CR Number:   287513 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2009 Insufficient priority to fix Description Need Sanitized customer visible description for this CR as this CR has been referenced in 12.5.0.1 ESD#2 and later Coverletters.

CR:287524

CR Number:   287524 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2003 Fixed Description A 7928 error "Index <value> is not consistent; found <value> leaf rows but <value> data rows. Drop and recreate the index." may be reported by DBCC CHECKTABLE on a Data-Only Locked table after having created either a CLUSTERED or NONCLUSTERED index with the SORTED_DATA option but ASE was first shutted down with the NOWAIT option. Workaround Description  Do not shutdown ASE with the 'nowait' option.

CR:287559

CR Number:   287559 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2002 Fixed Description "NEW" is a Potential SQL92 reserved word . The row referencing NEW in spt_values should be removed.

CR:287585

CR Number:   287585 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2002 Fixed 19 Jun 2002 Fixed 17 Jun 2002 Fixed 18 Jun 2002 Fixed 14 Jun 2002 Fixed Description An incorrect result may be returned by the MAX() aggregate function when the clustered index on an all-page locked table is used to determine the value and the configuration parameter "allow backward scans" is set to 0. Similarly, the MIN() aggregate may return an incorrect result using a descending clustered index. Workaround Description  - Don't disable backward scans. or - Use DOL table. or - Use nonclustered index.

CR:287659

CR Number:   287659 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2003 Fixed 12.5.1 12 Feb 2003 Fixed Description Proxy Tables can be created on all allowed non-ASE datasources like Oracle, DB2, ASIQ, ASA, MSSQL Server.

CR:287661

CR Number:   287661 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2003 Presently Not Targeted For Any Future Release Of This Product 25 Mar 2003 Fixed Description There is no option to map a role to a remote login(a login in a remote server).

CR:287681

CR Number:   287681 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Solaris Original Version:   0.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2003 Fixed 03 Feb 2003 Fixed 10 Mar 2003 Fixed Description During procedure I/O monitoring, the messages "**NoObject**" and "**NoDatabase**" may clutter the Historical Server output. Workaround Description  The customer can get rid of the extra unrequested information by using filters on procedure ID = 0 with the following syntax: hs_create_filter process_io_sproc2, "Procedure ID", "Value for Sample", neq, 0.

CR:287734

CR Number:   287734 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to enhance ALTER TABLE so it can add BIT columns to a table.

CR:287739

CR Number:   287739 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2002 Fixed Description Use of a host variable in lieu of an identifier in parameterized language statements (e.g. "use @p0") required that the host variable be supplied using a datatype of CHAR or VARCHAR. Henceforth, the host variable may instead be supplied using a datatype of UNICHAR or UNIVARCHAR (assuming the requirements for use of these datatypes are met).

CR:287744

CR Number:   287744 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2002 Fixed Description A negative or zero value may be incorrectly reported as the percentage completed during the undo or redo recovery passes, respectively.

CR:287778

CR Number:   287778 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2003 Fixed 04 Mar 2003 Duplicate Description On a multi-engine server, the transaction start time from the syslogshold table may get ahead of the OS time.

CR:287810

CR Number:   287810 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 04 Mar 2003 Duplicate Description Sybase Central ASE Plugin: does not support connection to servers that contain space characters in the network definition of the SQL.INI interfaces file. Status: Reviewed Sep 2002. A Fix is currently not scheduled, but the issue will be considered at the time of the next release. Workaround Description  Edit entries if possible.

CR:287816

CR Number:   287816 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Open OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Sybase Central ASE Plugin: does not support connection to servers using the $BASE$00 syntax in the SQL.INI interfaces file. Status: Reviewed Sep 2002. A Fix is currently not scheduled, but the issue will be considered at the time of the next release. Workaround Description  Edit entries if possible.

CR:287845

CR Number:   287845 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Fixed Description A feature request to remove the limits on the number of tables per query (50) and the number of subqueries per query (16), making them unlimited. Status: Reviewed Sep 2002. Feature targeted (but not commited) for the 15.0 release. While the implementation will not be unlimited, it will be relaxed to a very large extent.

CR:287899

CR Number:   287899 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2002 Fixed 13 Mar 2003 Fixed Description xpserver: "Recursive calls to srv__seterr()" may be entered into the xpserver errorlog when executing xp_logevent. Workaround Description  None. The code in the DLL needs to change.

CR:288059

CR Number:   288059 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2002 Fixed 24 Jun 2002 Fixed 27 Jun 2002 Fixed 15 Jul 2002 Fixed Description The stored procedure sp_statistics always returns a 'collation' value of "A" for both ascending and descending index columns.

CR:288066

CR Number:   288066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2002 Fixed Description The error message "I/O error detected for device" is sometimes displayed on IBM platforms.

CR:288092

CR Number:   288092 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2002 Fixed 30 Sep 2002 Presently Not Targeted For Any Future Release Of This Product 13 Jun 2001 Presently Not Targeted For Any Future Release Of This Product Description When running a SELECT query that has a UNION of more than 250 columns in the select list, the query may hang or return wrong results. Workaround Description  ASE 12.5.x doen't have this problem.

CR:288099

CR Number:   288099 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2005 Presently Not Targeted For Any Future Release Of This Product 03 Dec 2006 Fixed 08 Feb 2007 Fixed Description ASE optimizer is not able to perform statistics interpolation for char and varchar datatypes when server's default sort order is different from binary. As consequence some queries may be executed using suboptimal plans. Workaround Description  Increasing step count for the column statistics may or may not help since data is dynamic.

CR:288100

CR Number:   288100 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2002 Fixed Description The Large I/O effectiveness section under the "cache summary" section gives incorrect values when the page size is > 2K.

CR:288109

CR Number:   288109 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2003 Not reproducible with latest version of the product available as of Resolution Date Description ASE encounters java.lang.NoClassDefFoundError when multiple java sessions started concurently.