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

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

CR:548641

CR Number:   548641 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2012 Added to user documentation Description When trying to use sp_maplogin the documentation is not clear about exactly how the "client name" and the "login name" should be used.

CR:548663

CR Number:   548663 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2008 Fixed Description When the following conditions are true, error 2753 will be raised together with 103 error in English and stack trace may happen from ex__doprint(): 1. Asian languages (Chinese, Japanese and Korean) are used as default language of a connection 2. a create table/view command with longer than 255 bytes multi-byte object name 3. the object name starts with one single-byte character and followed with multi-byte characters

CR:548677

CR Number:   548677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2008 Fixed 02 Jun 2009 Fixed Description If the configuration parameter 'number of engines at startup' is misconfigured, a stack trace may occur at server startup due to a segmentation fault in the function interface_to_typeid().

CR:548776

CR Number:   548776 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2008 Fixed 29 Jan 2009 Bundled Request Description When master database replication is configured and login accounts are created and dropped on the master database, the Server User IDs generated in the active database during the creation of new login accounts could be different from the Server User IDs generated on the standby database.

CR:548881

CR Number:   548881 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2008 Fixed 15 Dec 2008 Reservation Made 30 Mar 2009 Presently Not Targeted For Any Future Release Of This Product 25 Mar 2009 One-off Provided 26 May 2009 Fixed Description Error Message 104 or 207 may be returned for a query using a column alias rather than the base column name in an ORDER BY clause.

CR:548900

CR Number:   548900 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2008 Fixed Description During the execution of queries with more than 16 user tables, up to 34 extra auxillary SDESes may be claimed (One for each table beyond 16) for the duration of execution.

CR:548927

CR Number:   548927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2009 Duplicate Description With 'statement cache' and 'enable literal autoparam' turned on - showplan can incorrectly indicate that a statement is 'newly cached' as oppose to 'previously cached' if the statement contains greater than 2 OR conditions

CR:549024

CR Number:   549024 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2008 Fixed 04 Feb 2009 Fixed Description A 832 error may be reported "Unable to place buffer <value> holding logical page <value> in sdes for object '<value>' - there is no room in sdes aux keep pool." in the error log together with a stack trace which includes the modules 'bufkeep', 'bt__insert_into_leaf' and 'bulk__fast_idxupdate' when inserting rows through bulk copy in a Data Only Locked table whose non-clustered index tree is being updated by ASE. Workaround Description  Try partition the table with 41 round-robin. It works with non-partition table or table with few partitions (e.g., < 5). For applications with more than 41 partitions, this workaround might not work.

CR:549065

CR Number:   549065 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2012 Bundled Request Description DBISQL Feature request to allow viewing Stored Procedures source code directly from the menu options. Workaround Description  Use server side system stored procedures : sp_helptext/sp_showtext

CR:549086

CR Number:   549086 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2009 Fixed 25 Jan 2012 Added to user documentation Description 'disk init' command and sp_deviceattr procedure does not prohibit setting of directio/dsync options for raw devices.

CR:549097

CR Number:   549097 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2008 Fixed Description When we had nested virtual columns in the predicate and at least one of the virtual column is under CASE/OR node. The virtual columns under CASE/OR nodes could be processed incorrectly and lead to the wrong results. Workaround Description  See Reproductions (C).

CR:549112

CR Number:   549112 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) 25 Nov 2008 Fixed 30 Nov 2008 Fixed Description Attempting to DISK INIT using a symbolic link to a device that is already in use will succeed without error. Workaround Description  Don't create multiple symbolic links to the same raw devices.

CR:549168

CR Number:   549168 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Windows XP Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2008 Fixed 05 Feb 2009 Fixed 24 Mar 2010 Bundled Request Description When set locale to Chinese, the chinese charaters in sysam checkout messages shows as boxes or garbage.

CR:549170

CR Number:   549170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare cases, if a database is offline, some commands allowed in a offline database such as dump tran might hang because space usage in some segment may cross the segment threshold. Workaround Description  Commands such as online database, dump database, dump tran and alter database (DBEXTEND) are allowed in an offline database. To avoid hitting the problem mentioned in this CR, we should refrain from issuing these commands on offline database. We should bring the database online first, and then issue these commands. How it helps? When the thresold crosses, new thresold manager task is spawned. But, this task won't be get dbtable as database is offline. So if the database is brought online and the command issued, we won't hit the problem.

CR:549199

CR Number:   549199 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2008 Fixed Description If SSL is enabled, user will fail to install utf8 character set using "charset" command in Win64 platform. The error message will be: SQLServer message 632, state 2, severity 20: Attempt to move memory with an incorrect length of 16416. Maximum allowed leng th is 16384.

CR:549239

CR Number:   549239 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2008 Fixed Description Procedural query compiled in the deferred mode may not work as expected if it this query needs execution of the DEFAULT or RULE or references materialized column using global variables. Workaround Description  Enable trace flag 7730 to turn off deferred compilation.

CR:549264

CR Number:   549264 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2010 Fixed 18 Mar 2010 Fixed Description When doing an alter table on a replicated table containing a text column, and the alter table does not involve dropping a column, ASE produces a SIGSEGV in cri_ncrebuild().

CR:549309

CR Number:   549309 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2012 Duplicate Description Feature request for a version of REORG REBUILD that could be run for a definable period of time, fully compacting the part of the table processed into new extents.

CR:549316

CR Number:   549316 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2009 Fixed Description In rare circumstances, a query being executed in parallel may hang when the query had to abort due to a 1105 error, "Can't allocate space for object <table_name> in database <db_name> because <segment_name> segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.", caused by insufficient space in tempdb for the worktables that the query internally needed. Workaround Description  Disable parallelism.

CR:549412

CR Number:   549412 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2009 Fixed Description DDLGen generates duplicate column names in partition key list. Workaround Description  User PowerBuilder to modify the query that creates the "partition by range" clause to include "and p.indid = 0": select p.indid, column_name = c.name, column_type = isnull(x.xtname, isnull(get_xtypename(c.xtype,c.xdbid), t.name)) from dbo.syscolumns c, dbo.sysxtypes x, dbo.systypes t, dbo.syspartitionkeys p where c.id = object_id("All_Drugs") and c.xtype *= x.xtid and c.usertype *= t.usertype and p.id = object_id("All_Drugs") and c.colid = p.colid and p.indid = 0 order by p.position

CR:549413

CR Number:   549413 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2009 Fixed Description DDLGen creates range partition in the incorrect order causing error 14304 Workaround Description  Manually edit the script to put the partition conditions in incremental order.

CR:549415

CR Number:   549415 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2009 Fixed Description DDLGen creates the partition condition section, it is all bunched together Workaround Description  Manually edit the script to make it more readable.

CR:549423

CR Number:   549423 Product Name:   Adaptive Server Enterprise Product Component:   Pluggable_JVM Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2009 Fixed Description If the ASE PCI subsystem fails to start up then stack traces may be seen in the ASE errorlog and ASE may not boot. Workaround Description  disable PCI

CR:549429

CR Number:   549429 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_object_stats can be run on an offline database. If online database is run at the same time it is possible to hit error 834: Illegal attempt to clean buffer: Workaround Description  Do not run sp_object_stats on databases that are offline.

CR:549455

CR Number:   549455 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2008 Fixed Description A new monitor counter has been added for Replication Agent to monitor the number of times a schema is dropped from the cache in order to reuse the freed space.

CR:549472

CR Number:   549472 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE does not raise a 2705 error in some cases when an attempt is made to ALTER TABLE adding a column with a name that duplicates an existing column name.

CR:549486

CR Number:   549486 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2008 Fixed 28 Jan 2009 Fixed 21 Aug 2009 Fixed 03 Sep 2009 Fixed Description Opening a Foreign Key Wizard on a Solaris machine would resulted in an internal error for ASE Plug-in.

CR:549495

CR Number:   549495 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The 'inserted' and 'deleted' trigger pseudo-tables cannot be referenced in derived tables within a trigger.

CR:549496

CR Number:   549496 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) 30 Nov 2008 Fixed 13 Jan 2009 Fixed Description IF ASE is configured for 101 or more engines, sp_sysmon reports errors converting the engine number to a char(2).

CR:549497

CR Number:   549497 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for an ALTER DATABASE option that, on a fragmented disk, would allocate a single contiguous fragment if it was possible to do so, and otherwise minimize the number of fragments generated, rather than filling free areas from the beginning of the device forward.

CR:549639

CR Number:   549639 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2008 Fixed 14 Nov 2008 Fixed Description With statement cache enabled, it may be possible for the statement immediately after a while loop that has just hit a break condition to not execute successfully - it only occurs if the sql is contained within a single batch.

CR:549641

CR Number:   549641 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Infected with 11 stacktrace containing functions js__execute, exectrig, and rly_rowfmt occurs when an insert trigger on js_history table is fired.

CR:549694

CR Number:   549694 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2008 Fixed 25 Nov 2008 Fixed Description ASE may encounter a signal 11 in ub_postwrite() when there are delayed IO's and when extended cache is enabled.

CR:549724

CR Number:   549724 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2008 Not a Bug Description In 15.0.2.x, SHUTDOWN is not waiting for open transactions to complete before shutting down ASE, it is acting just like SHUTDOWN WITH NOWAIT. Workaround Description  Before issuing SHUTDOWN, verify there are no long-running open transactions in syslogshold to avoid lengthy recovery due to long-running open transactions.

CR:549741

CR Number:   549741 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2008 Fixed 29 Jan 2009 Bundled Request Description When the global password complexity option 'min alpha in password' is set to -1, the random password generated through the password_random() built-in contains alphabetic characters.

CR:549825

CR Number:   549825 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2009 Not a Bug Description After installing according to the install guide, overlaying 15.0.2 in the same directory as 12.5.4, the ASE can not be started from services. Pop up window: Could not start the Sybase SQLServer _MY125 service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion. (click ok) No error in the ASE errorlog. Workaround Description  Dump and Load migration on separate folders/hosts/drives or VM.

CR:549857

CR Number:   549857 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2008 Fixed 09 Jan 2014 Presently Not Targeted For Any Future Release Of This Product Description A 12313 error: "Internal error: Insert into page id <pageid> of index id <indid> of table '<tabname>' (id = <id>) in database '<dbname>' tried to replace undeleted RID (<pageid>,<rnum>) at slot <slotnum> and ridposn <ridnum>. Try dropping and recreating the index." can sometimes happen with deferred updates on a data-only locked table.

CR:549892

CR Number:   549892 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2009 Fixed Description Error 128 is raised when running sp_listener remotely.

CR:549902

CR Number:   549902 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2008 Fixed Description When statement cache is on, literal autoparam is on, and the server's default character set is either eucksc, sjis, eucgb, big5 or cp936, a query that contains TAB character before a select may cause incorrect select query to be cached, which may lead to syntax error if such query is recompiled.

CR:549927

CR Number:   549927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2008 Fixed Description When reporting a stack trace on the Windows operating system, ASE will now also print an accompanying module dump, listing all the loaded external libraries and the path from where they were loaded, in order to aid problem diagnosis.

CR:549937

CR Number:   549937 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2009 Fixed Description On ia64 Itanium HP-UNIX and WinX64 platform, a GroupBy with more than 32 groupby columns and with more than 6 joining tables might hit signal 11 and stacktrace during the call of s_ap_compat_gen(). It could also happen for more than 32 groupby column query under compatibility mode.

CR:549944

CR Number:   549944 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Inconsistent datatypes in MDA tables.

CR:550013

CR Number:   550013 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2008 Fixed Description In some exception cases, prSQLTEXT() might SEGV when called from terminate_process().

CR:550032

CR Number:   550032 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2009 Fixed Description SyConfig or SyBatch may receive a ct_fetch error when querying the status column of sysdatabases after the upgrade successfully completes. Workaround Description  disable database option(s)

CR:550075

CR Number:   550075 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) 07 Dec 2008 Fixed 19 Feb 2009 Fixed Description Boot time and LOAD DATABASE recovery might be unnecessarily slowed down in cases where there are only a few long-running transactions at the time the server was shut down or DUMP DATABASE was executed.

CR:550154

CR Number:   550154 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Query Processing and Abstract Plans Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2010 Presently Not Targeted For Any Future Release Of This Product Description "In some cases, command statements that include subqueries can also be formulated as joins and may run faster."

CR:550167

CR Number:   550167 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2008 Fixed 17 Nov 2008 Fixed Description If a cluster instance cannot successfully initialize the primary link at boot time, an attempt to drop another instance issued from the above instance may result in segmentation fault.

CR:550239

CR Number:   550239 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2008 Fixed 18 Nov 2008 Fixed Description In rare circumstances, in a cluster instance, if a query is being executed and the user tries to cancel execution of the query by typing Ctrl-C in the isql, some of the locks acquired by that query could remain unreleased and server could deadlock later.

CR:550255

CR Number:   550255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2013 Insufficient priority to fix Description Feature Request: Add the option to include cache wizard when running a complete sp_sysmon.

CR:550273

CR Number:   550273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2008 Fixed 14 Dec 2008 Fixed 23 Jan 2009 Not reproducible with latest version of the product available as of Resolution Date Description Stacktrace in ups__minorattributes doing update statistics on a temp table only exist in 12.5.x.

CR:550284

CR Number:   550284 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2008 Fixed 09 Dec 2008 Reservation Made 16 Apr 2010 One-off Provided Description When using sp_showplan to query another session's query plan, sometimes it could cause stacktrace with SIG11 or SIG4 in some platform. It could happen for a OPEN CURSOR, BCP IN and when run time recompilation are needed.

CR:550290

CR Number:   550290 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2008 Fixed 10 Feb 2009 Fixed Description An 832 error "Unable to place buffer <value> holding logical page ... there is no room in sdes aux keep pool." or an 803 error "Unable to place buffer <value> from cache '<value>' holding logical page ... either there is no room in sdes or buffer already in requested slot." when reported will be followed by diagnostic information printed in the error log.

CR:550351

CR Number:   550351 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2009 Fixed Description On HPPA64 and HPIA64 platforms, if Java in Database feature is enabled in High Availability system, failback operation results in a hang if Java was used prior to failback on the secondary server. Secondary ASE errorlog reports "scheduler infected with signal 11" message with a stack trace that includes keipanic(). Workaround Description  [CR # 550351] On HPPA64 and HPIA64 platforms, if Java in Database feature is enabled in High Availability system, sp_companion stored procedure results in a hang if Java was used prior to running this stored procedure on the server. ASE errlog may report "scheduler infected with signal 11" message with a stack trace that includes keipanic(). The ASE errorlog file may contain a stack trace similar to: 00:00000:00023:2008/11/13 23:20:29.77 kernel Current process (0x1a001a) infected with signal 11 (SIGSEGV) 00:00000:00023:2008/11/13 23:20:29.77 kernel Address 0xc0000000000d2110 (si_code: 0x1, si_addr: 0x0000000100000010), siginfo (code, address) = (1, 0x0000000100000010) 00:00000:00023:2008/11/13 23:20:29.77 kernel kechkfault: engine 0: scheduler infected with signal 11 (SIGSEGV) 00:00000:00023:2008/11/13 23:20:29.79 kernel pc: 0x4000000003eceb80 pcstkwalk+0xf0(0x00000000001a001a, 0x0000000000000002, 0x000000000000270f, 0x0000000000000000, 0x0000000000000000) 00:00000:00023:2008/11/13 23:20:29.79 kernel pc: 0x4000000003ece170 ucstkgentrace+0x940(0x00000000001a001a, 0x0000000000000001, 0x6000000000468ab0, 0xc000000000000611, 0x4000000003dfae20) 00:00000:00023:2008/11/13 23:20:29.79 kernel pc: 0x4000000003dc8d50 ucbacktrace+0xf0(0x000000000000c378, 0x6000000000481340, 0x000000000000000b, 0x4000000000d62b00, 0x00000000000002c0) 00:00000:00023:2008/11/13 23:20:29.80 kernel pc: 0x4000000003dfae20 keipanic+0x110(0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000) 00:00000:00023:2008/11/13 23:20:29.80 kernel end of stack trace, spid 23, kpid 1703962, suid 1 Workaround: If the server is running with multiple engines, offline the engine running the JVM prior to running sp_companion. Use MDA tables to determine if the Java was used on the server and to which engine the JVM is bound. For example, following query shows JVM is not active. 1> select * from master..monPCISlots 2> go Slot Status Modulename engine ----------- -------------------- ------------------------------------------------------------ ----------- 1 INIT PCA/JVM 0 (1 row affected) In the example below, JVM is active and associated with engine 1 1> select * from master..monPCISlots 2> go Slot Status Modulename engine ----------- -------------------- ------------------------------------------------------------ ----------- 1 IN USE PCA/JVM 1 In this case you can offline engine 1 before running sp_companion. 1> sp_engine "offline", 1 2> go If engine offline fails, or the server is configured for a single engine, or if the server encountered hang when running sp_companion, then the server should be restarted using cluster commands as below. a] stop monitoring for the package. cmhaltserv -v <pkg_name> Make sure the package is still running on the same node where it was running. The above command should kill the <pkg_name>.sh script and only stop monitoring for the package, and not stop the package itself. You can verify this by looking for <pkg_name>.sh in ps output. Note that generally <pkg_name> corresponds to the companion server where Java was used and sp_companion is about to be issued. Only exception is when the secondary companion is in failed_over mode, in which case <pkg_name> refers to that of primary companion. b] halt and restart the package on the same node to reboot the ASE. cmhaltpkg <pkg_name> cmmodpkg -e -n <same_node> <pkg_name> cmrunpkg -n <same_node> <pkg_name> Use the cmhaltpkg, cmmodpkg and cmrunpkg commands to stop or start the corresponding ASE packages in the cluster, as directly stopping ASE result in unnecessary failovers. Refer to MCSG cluster documentation/man pages for more details about the cluster commands, and "Using Sybase Failover in A High Availbility System" for usage examples.

CR:550560

CR Number:   550560 Product Name:   Adaptive Server Generic Docs Product Component:   Migration Guide Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description http://www.sybase.com/files/White_Papers/PlanningASE15Migration-040307.pdf Section that reads: Sybase is considering an enhancement in future release that will revert behavior (group by implicitly orders result). In ASE 15.0 ESD #2, traceflag 450 makes group by use the classic (non-hashed) sort method, thus making the result set order predictable again -- but at the possible cost of slower performance. In a later release, a new "optimization criteria" language command "set group_inserting {0|1}" is being considered which will let you control this on a session level -- and especially via login triggers -- without requiring trace flags. Should read: Sybase created an enhancement in 15.0 ESD #2 that reverts behavior (group by implicitly orders result). Global traceflag 450 makes group by use the classic (non-hashed) sort method, thus making the result set order predictable again -- but at the possible cost of slower performance. In release ASE 15.0.1, with CR# 424188, a new "optimization criteria" language command "set group_inserting {0|1}" is available which will let you suggest this to the optimizer on a session level -- and especially via login triggers -- without requiring trace flags.

CR:550561

CR Number:   550561 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2009 Not reproducible with latest version of the product available as of Resolution Date 12 Feb 2009 Not reproducible with latest version of the product available as of Resolution Date Description Stacktrace occurs when a query is executed on the monProcessProcedures MDA table Workaround Description  Avoid queries on monProcessProcedures

CR:550607

CR Number:   550607 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2010 Fixed 19 Apr 2010 Fixed Description Skip opening and holding lock on sysconfigures for some config option; Skip starting an xact for some more config options.

CR:550634

CR Number:   550634 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2008 Fixed 19 Nov 2008 Fixed Description In rare circumstances, in a multi-instance cluster, if an instance crashes, object metadata changed by the crashed instance may not be correctly recovered by the instance that does the failover recovery.

CR:550647

CR Number:   550647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2009 Fixed 17 Feb 2009 Fixed Description On Solaris platform, Sun patch 119963-09 (SPARC), 119964-09 (x64) (or higher) causes ASE fail to boot with "Segmentation Fault error (core dumped)." Workaround Description  Downgrade the OS to an earlier patch level.

CR:550692

CR Number:   550692 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2008 Added to user documentation 19 Jan 2009 Fixed 28 Jan 2009 Fixed Description The SQL template for Scalar Function Wizard and SQLJ Function Wizard incorrectly included the database name for the object name.

CR:550718

CR Number:   550718 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to have optimizer make better use of OR clauses used with variables, ex. (@x = 1 or @x is null). Workaround Description  Use an IF statement for and explicit "choose plan" if (@sys_id IS NULL) then begin select trade_id from pct_bill..TRADES where dt= convert(smalldatetime, @dt, 118) end else begin select trade_id from pct_bill..TRADES where dt= convert(smalldatetime, @dt, 118) and sys_id = @sys_id end

CR:550737

CR Number:   550737 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2009 Fixed 13 Mar 2009 Reservation Made Description UPDATE INDEX STATISTICS sometimes generates a next-to-last step with a weight of 0, despite there being data in the associated value. This occurs when creating frequency cells. So there are a relatively large number of rows that qualify for the associated value. A weight of 0 will lead to a row estimate of 1 and the optimizer will tend to scan the associated table too early in the plan leading to poor performance. Two problems have been indentified here. First, the boundary condition check for building a frequency cell was off by one. Second, the calculations used to predict available steps for creating frequency cells was incorrect. The fix for these problems is enabled through trace commandline flag 2715.

CR:550738

CR Number:   550738 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Dec 2008 Fixed 25 Nov 2008 Fixed Description When you are in a Simplified Chinese environment, the Adaptive Server plug-in returns a null pointer exception in the Scheduled Job Properties dialog.

CR:550740

CR Number:   550740 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Windows Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2012 Added to user documentation Description Installation Guide and Release Bulletin: you cannot upgrade 32-bit windows to 64-bit windows. sybmigrate only.

CR:550788

CR Number:   550788 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2008 Fixed 29 Jan 2009 Bundled Request Description Incorrect warning message is displayed when authentication mapping is overwritten for the same external user.

CR:550793

CR Number:   550793 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2009 Insufficient priority to fix Description Drop and create index can change Data page CR count only on 12.5.x Workaround Description  // will bring it back to update statistics value. update index statistics t1 go

CR:550812

CR Number:   550812 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2008 Fixed 25 Nov 2008 Fixed 25 Nov 2008 Presently Not Targeted For Any Future Release Of This Product 04 Dec 2008 Fixed Description When no-sa role connect to Shared Cluster Server, instance folder can't display rightly in Chinese and Japanese environment.

CR:550820

CR Number:   550820 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2008 Fixed 21 Nov 2008 Fixed Description The license manager task that validates the license usage, being marked "critical" held a spinlock and didn't yield causing a set of other tasks that contended for the same spinlock to hit timeslice errors.

CR:550847

CR Number:   550847 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2008 Fixed Description If a UNION ALL operator is used in a derived table expression, then incorrect answers could result Workaround Description  use trace flag 4418

CR:550859

CR Number:   550859 Product Name:   ASE Replicator Product Component:   Log Extract Status:   Closed OS:   Generic Original Version:   15.0.1.411P2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.2.421P2a-ONE_OFF 30 Mar 2009 Fixed 4.2.2 09 Apr 2009 Fixed Description ASE REPLICATOR: Replicator fails to parse a large timestamp value, throwing the following exception: Cannot build locator from invalid hex string <00000100f1d933c200000d6....0> because: For input string: "f1d933c2".

CR:550872

CR Number:   550872 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2011 Fixed Description If using the application tracing functionality to trace a user and setting some option like 'set showplan on' and then when tracing is turned off for the user, the tracing option for the user is not reset and the tracing output is sent to the user's console. Workaround Description  Users can workaround this issue by actually turning off the options before setting the tracing off.

CR:550873

CR Number:   550873 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2011 Fixed Description Allowing all the set commands during app tracing can lead to unwanted adverse effect on the tracing session when options that can potentially alter the plan or the behavior of the query are enabled.

CR:550888

CR Number:   550888 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2009 Fixed Description In a multi-instance cluster, when a cluster instance is booting, in rare circumstances, a SIG 11 could be hit. A stacktrace would be reported and in the trace, strings like "dbt_get_oldestactive_pcm_callback" could be present.

CR:550917

CR Number:   550917 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2009 Fixed 01 Feb 2009 Fixed Description On linux systems, performance of some queries may drop when Q engines are online.

CR:550921

CR Number:   550921 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2008 Fixed 02 Dec 2008 Reservation Made 10 Dec 2008 Fixed Description New option 'procedure deferred compilation' has been added so that the usage of the deferred compilation feature could be switched on or of by the system procedure sp_configure.

CR:550942

CR Number:   550942 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description setsuspect granularity on page level for runtime pages error as 6xx errors.

CR:550987

CR Number:   550987 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2008 Fixed Description Under some circumstances wrong results could be returned when executing a query involving complex expressions with several nested built-in function calls (like for example IS_NULL(), STR_REPLACE(), CONVERT(), etc.) or long CASE expressions.

CR:551004

CR Number:   551004 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description after upgrade of db from 12.5.0.3 to 15.0.2, 318 error on reorg rebuild unless you run delete stats before update stats.

CR:551014

CR Number:   551014 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to have the hashbytes() function support the SHA-256 algorithm. Workaround Description  Implement hash function using java or sql based user defined function.

CR:551042

CR Number:   551042 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2008 Fixed Description In ASE running on the Windows platform, under conditions where ASE pool memory is running low, the java subsystem may report "EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x00000000"

CR:551059

CR Number:   551059 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2009 Fixed 15 Jun 2009 Fixed 15 Jun 2009 Fixed 22 Jun 2009 Fixed Description Verify the log free space count discrepancies in the dbcc checkverify. Workaround Description  Execute: dbcc tablealloc("syslogs")

CR:551075

CR Number:   551075 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2009 Fixed Description Signal 11 in OptGlobal::GblSetInterestingTcIds which will terminate the process can be seen under specific circumstances when assigning a variable a column value from the select-list of a query on an external table with an order by clause

CR:551086

CR Number:   551086 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2008 Duplicate Description monOpenObjectActivity is not updated when a table is accessed via an index.

CR:551091

CR Number:   551091 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2009 Fixed 31 May 2009 Fixed 11 Jun 2009 Fixed 14 Jun 2009 Fixed Description If error(SIGSEGV, SIGBUS) occur at sampling, the engines will be halted. Workaround Description  1: start sybmon, attach to server and execute 'restart' or 2: restart engines by hand

CR:551094

CR Number:   551094 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2009 Fixed 08 Apr 2009 Fixed Description Attempting to retrieve data inserted using a deferred INSERT command for a table created with the "ignore_dup_key" clause and having TEXT columns may fail with a fatal 7114 error reading "Page <Page Number> is not a valid text page." together with a stack trace showing modules "sendtext" and "get_txtpage".

CR:551215

CR Number:   551215 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2009 Fixed Description A task involved in sorting data hit an 890 error (state 6) in function sort_write

CR:551224

CR Number:   551224 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Linux Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2009 Fixed 26 Nov 2008 Fixed 05 Aug 2009 Added to user documentation 18 Dec 2008 Fixed Description starting GUI installer failed in Red Hat 4 when set locale to Simplified Chinese Workaround Description  export _JAVA_OPTIONS="-Dswing.systemlaf=javax.swing.plaf.metal.MetalLookAndFeel" before running installer setup

CR:551246

CR Number:   551246 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2008 Fixed 27 Nov 2008 Fixed 14 Jan 2009 Fixed 14 Jan 2009 One-off Provided Description Error 5901 is hit while calculating the next cycle frequency for the scheduled job if its jsc_start is NULL in the js_callouts.

CR:551265

CR Number:   551265 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2008 Fixed Description A join condition between a NUMERIC and a nullable FLOAT may return true due to the truncation of the float value during implicit conversion.

CR:551299

CR Number:   551299 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sddone errors on one database device containing one user database, and the rest of the ASE was unavailable until reboot of ASE. Requesting a feature to allow that one database to be offlined whiles the rest of the server continues to run.

CR:551337

CR Number:   551337 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin for HP Status:   Closed OS:   HP-UX Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2008 Fixed Description On HPIA, ASE process will be terminated if the UAF agent process is terminated by "Ctrl-C". Users should user uafshutdown.sh to shutdown UAF agent instead of doing "Ctrl-C".

CR:551417

CR Number:   551417 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Increase maximum transaction name length to 255 Workaround Description  Make sure transaction names are less than 30 characters

CR:551479

CR Number:   551479 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2008 Fixed 22 Jan 2009 One-off Provided Description On Windows High Availability companion node setup, either using "sp_companion" or the Microsoft cluster manager, the user encounters operating system error 5042 and the companion node creation never completes.

CR:551503

CR Number:   551503 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Dec 2008 Fixed Description A 2540 error, "Table Corrupt: Page is allocated but not linked ...", may be reported by DBCC CHECKALLOC some time after instance failure as a result of recovery not completely cleaning up pending deallocations resulting from a DROP command that happened just prior to instance failover.

CR:551539

CR Number:   551539 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2009 Fixed Description A 2805 error, "Bad pointer 0x4 encountered while remapping stored procedure 'proc_name'. Must re-create procedure." may be reported in the errorlog and also sometimes the message "current process infected with 11" in the module 'qremap__mapptr' together with a stack trace which includes the modules 's_getTreeOrPlan' and 'qremap_prochdr' when executing a very big procedure which requires more than 24480 pages of memory.

CR:551553

CR Number:   551553 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2008 Fixed Description Under exceptional circumstances, execution of an ad-hoc sql statement with multiple OR conditions (in the order of 100s) with 'statement cache and 'enable literal autoparam' the server may hit a stack overflow which may bring the ASE down. Workaround Description  Reduce the number of ORs in the query or increase 'stack size' and 'stack guard size'.

CR:551577

CR Number:   551577 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2009 Fixed 10 Feb 2009 Reservation Made Description "usedb" may hang when "enable metrics capture = 1" is set and "number of open databases" is not configured high to accommodate all the databases. A stack trace would be reported in the error log which includes dbt__grab and metrics_dump. Workaround Description  Increase the number of open databases to avoid dbtable reuse/scavenging. You need set the value to at least the value from select count(*) from master..sysdatabases.

CR:551595

CR Number:   551595 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.3 ESD#1 08 Dec 2008 Bundled Request 09 Feb 2009 Added to user documentation Description Allow users who do not have the mon_role role to select from the monLicense table.

CR:551596

CR Number:   551596 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2008 Fixed Description The errors 624 and 625 may occur while running queries that use RID Join operator on APL tables.

CR:551677

CR Number:   551677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2008 Fixed Description Extend traceflag 457 to also make READ ONLY cursors using DISTINCT select's globally insensitive. Workaround Description  MOdify all cursors - create them as insensitive.

CR:551702

CR Number:   551702 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2011 Insufficient priority to fix Description Feature request for sp_errorlog, to be able to reuse the current errorlog filename and that the existing errorlog filename is changed (similar to the cfg file).