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

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

CR:570986

CR Number:   570986 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2009 Fixed Description GUI: while selecting a license key file, the default directory is empty if a user specifies an installation destination that does not exist. Workaround Description  1. Create the destination directory before launching ASE installer. 2. Or, After repro step 6, input the full path of lincense file in 'Enter file name' edit box.

CR:571049

CR Number:   571049 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2009 Workaround 04 Aug 2009 Fixed 31 Jul 2009 Fixed Description On HPPA64 and HPIA64 platforms, if Java in Database feature is enabled in a High Availability system, during failback operation, "sp_companion resume" operation on the primary causes the secondary companion either to hang or die due to an internal error if the PCI/JVM is active on the secondary companion. In the event of a hang, the system 'ps' command will show an extra server process running, i.e. in a two engine system 'ps' would show three server processes rather than the expected two. If the error results in a dead engine on the secondary companion, the error log will contain messages indicating the engine hosting the JVM has exited with a signal 11. Workaround Description  Use these cluster commands to halt and restart the server. cmhaltserv -v <pkg_name> This command kills <pkg_name>.sh, which stops package monitoring, but does not halt the package itself. Check ps output to ensure <pkg_name>.sh is not running. <pkg_name> usually corresponds to the companion server where Java was used, and where sp_companion is about to be executed. When the secondary companion is in failedover mode, the <pkg_name> refers to the primary companion. cmhaltpkg <pkg_name> cmmodpkg -e -n <same_node> <pkg_name> cmrunpkg -n <same_node> <pkg_name> Do not shutdown directly using the isql command. Doing so may cause unnecessary failovers.

CR:571064

CR Number:   571064 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2013 Not reproducible with latest version of the product available as of Resolution Date Description Joining a proxy table column mapped to a remote procedure which returns no result sets may cause "Command has been aborted" error. Workaround Description  Insert the following line into the procedure , i.e. as select convert(varchar(255),null,null) as r_result where 1=2 return instead of just... as return

CR:571072

CR Number:   571072 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2009 Fixed Description Create Table or Alter Table with Case statement that uses an IN list or NOT column NOT IN list or the equivalent of those expressions in a computed column will cause stacktrace.

CR:571073

CR Number:   571073 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) 21 Aug 2009 Fixed 01 Feb 2010 Fixed Description Sometimes while booting ASE with multiple engines, transaction coordinator initialization fails.

CR:571074

CR Number:   571074 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) 18 May 2011 Fixed Description Specifying fill factor for a table has no effect on the subsequent REORG REBUILD.

CR:571076

CR Number:   571076 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   NA Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.3 ESD#3 07 May 2009 Fixed 19 May 2009 Fixed 08 Jun 2009 Fixed 02 Jul 2009 Fixed 01 Aug 2009 Fixed 25 Aug 2009 Bundled Request Description Disable 'Save the connection password' option in DBISQL's 'Favorites'.

CR:571082

CR Number:   571082 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) 22 Feb 2010 Insufficient info provided Description When changing on a sarg value, query uses less efficient plan. Workaround Description  Use Abstract Plan.

CR:571345

CR Number:   571345 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) 30 Jun 2009 Fixed 25 Jun 2009 Fixed 21 May 2009 Fixed 09 Jul 2009 Bundled Request Description Various stacktraces can be seen in the ASE-errorlog when the commands sp_engine 'offline', sp_engine 'online', together with Java statement are combined to one single SQL-batch when the target engine used in the sp_engine command is the engine hosting the Java VM. Workaround Description  do not offline an engine hosting the VM.

CR:571553

CR Number:   571553 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) 24 May 2009 Fixed 21 May 2009 Fixed 26 May 2009 Fixed 09 Jul 2009 One-off Provided 08 Jul 2009 One-off Provided Description In ASE 15.0.3 ESD#1, HA failover and 'disk init' may fail with error 6513 and 5151 respectively.

CR:571615

CR Number:   571615 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2009 Fixed 27 May 2009 Fixed 27 May 2009 Reservation Made Description SQL which concatenates at least two contiguous NULLs with strings may cause error 257. For example, select NULL + NULL + 'abc'.

CR:571630

CR Number:   571630 Product Name:   Adaptive Server Enterprise Product Component:   charsets Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2014 Insufficient priority to fix Description With case insensitive, accent insensitive sort selected cedilla diacritical marks are not treated with accent insensitivity. Workaround Description  1) Modify "c:\sybase\charsets\iso_1\noaccents.srt". Change the following line from: char = 0x43=0x63, 0xC7=0xE7 ;letters C, c, C-cedilla, c-cedilla to: char = 0x43=0x63=0xC7=0xE7 ;letters C, c, C-cedilla, c-cedilla 2) Reload the sort definition: C:\temp>charset -Usa -P noaccents.srt Loading file 'noaccents.srt'. Found a [sortorder] section. This is Class-1 sort order. Character set for the sort order is already in the Syscharsets table. Sort order (ID = 54 ,CSID = 1 ) with NAME = 'noaccents_iso_1' already exists in the Syscharsets system table. Do you wish to update this sort order with the definitions found in your localization file for sort order (ID = 54, CSID = 1, NAME = 'noaccents_iso_1')? (yes/no): yes Finished loading file 'noaccents.srt'. 1 sort order loaded successfully 3) Restart ASE 4) Re-run query: C:\temp>isql -Usa -P -D tempdb 1> select * from west_euro where c1 like "Franc%" 2> go c1 -------------------- Franois FranCois (2 rows affected)

CR:571640

CR Number:   571640 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2009 Fixed 22 Jun 2009 Reservation Made Description In rare circumstances, queries involving sort-merge-join and JTC, aggregation and group by can result in wrong results if the index chose for join is also used to enforce SARGs and those SARGs are not in the same key order as the index keys. Workaround Description  remove memory pools or sort merge If you only want the JTC aspect, use trace 334.

CR:571645

CR Number:   571645 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2009 Fixed 30 Jun 2009 Fixed 30 Jun 2009 Reservation Made Description The message "current process infected with 11" in the module 's_free' with a stack trace which includes the modules 'kill_proc', 'metrics_dump' and 's_recompile' may be reported in the error log after killing a session that was executing a stored procedure which had to be recompiled and it was hang because transaction log was almost full and the configuration option "enable metrics capture" was set to 1. Workaround Description  Disable config option via sp_configure "enable metrics capture",0

CR:571772

CR Number:   571772 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) 24 May 2009 Fixed 10 Jun 2009 Fixed Description On linux platforms an engine died abruptly with the message "Engine exited with signal 11". Workaround Description  Set LD_POINTER_GUARD to 0 before booting up the server.

CR:571924

CR Number:   571924 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2009 Fixed Description Executing a query with a compute clause may hit a SIGSEGV (infected with 11) together with stack trace referring to the modules subparserr() and parserr2().

CR:571958

CR Number:   571958 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Troubleshooting guide should be expanded to offer general help on errors in the range 1000 to 1099 not covered explicitly within the guide for ASE 15. Specifically for message 1017. Workaround Description  N/A

CR:571966

CR Number:   571966 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Msg 11931 is not correct when you run reorg compact on a allpages this is not allowed as DOC CR 493203 says.

CR:571984

CR Number:   571984 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 Feature request to add a message to "set option show_missing_stats" to indicate "No Missing Stats" when ASE does not find any missing statistics for the executed query.

CR:572080

CR Number:   572080 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2009 Fixed 19 Jun 2009 Fixed Description Changing the type of an instance-specific local cache through the sp_cacheconfig interface succeeds without any error even if the change leads to conflicting status on different instances of the cluster. Any subsequent attempt to boot the server with the new configuration file thus generated will fail. Workaround Description  Manually edit the configuration file and reboot.

CR:572085

CR Number:   572085 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR support for 'reorg rebuild table index ' on allpages locking tables.

CR:572088

CR Number:   572088 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Bundled Request Description New error message 3326 "Invalid log record (logop <logop>) found in syslogs at (<rid_pageid>, <rid_rnum>) for transaction (<sessionid_pageid>, <sessionid_rnum>) that started at '<date>' in database '<dbname>'. Please contact Sybase Technical Support." is added to replace few occurences of error 3301.

CR:572089

CR Number:   572089 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Bundled Request Description New option "spid <spid_value>" is added to the offline DBCCLOG command for dumping the log records of a particular session.

CR:572095

CR Number:   572095 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2009 Fixed 22 Jul 2009 Fixed Description In rare circumstances Error 651, "Startscan was called with an illegal combination of index and scan mode" may be reported into the errorlog while starting DDL on a table.

CR:572097

CR Number:   572097 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 Jun 2009 Fixed Description The command to shutdown an engine that has a task affiniated to it, may cause a stack trace.

CR:572121

CR Number:   572121 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Fixed 02 Jun 2009 Fixed Description The message "process infected with signal 11" may sometimes be reported in the error log together with a stack trace that includes modules 'rec_undo_session' and 'abort__all' when a transaction that allocated space in a data-only locked table is rolled back.

CR:572133

CR Number:   572133 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2009 Fixed Description Under some rare circumstance when ASE is unable to allocate memory for query execution the usual message for error 701 " There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache." is accompanied by a stack trace in the errorlog file. The stack trace will indicate modules LePlanRelease and LeParentOp::LeOpProcessIOStats. The issue will happen if options to display statistics were activated.

CR:572163

CR Number:   572163 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2009 Fixed 30 Aug 2009 Fixed Description Add a new Backup Server verbosity level (4) to disable logging of "Connection from Server" messages.

CR:572188

CR Number:   572188 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) 17 Aug 2009 Fixed 24 Aug 2009 One-off Provided Description Drop in sp_addlogin and sp_role grant/revoke performance after an upgrade from ASE 12.5.3 to 15.0.3 ESD#1 on a ASE HA cluster.

CR:572311

CR Number:   572311 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2010 Fixed Description With multiple network engines, ASE can suffer imbalance of network IO across engines.

CR:572388

CR Number:   572388 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2009 One-off Provided 21 May 2010 Fixed 21 May 2010 Reservation Made 28 Oct 2010 Not reproducible with latest version of the product available as of Resolution Date 31 Aug 2012 Fixed Description The message "current process infected with 11" in different modules like 'bwfinish', 'exec_eop', etc or the message "timeslice <negative number>, current process infected" may be reported in the errorlog after a query with an ORDER BY clause was executed which internally used a worktable that due to its large size was created with the "Data Only Pages" lock schema and Adaptive Server was configured for running queries in parallel. Workaround Description  Disable parallelism (for the affected query or globally in the server) so the DOL worktable is not attempted to be sorted in parallel.

CR:572490

CR Number:   572490 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) 03 Apr 2012 Not reproducible with latest version of the product available as of Resolution Date Description Setting configuration parameters to values that result in the total required memory of ASE to be very close value configured for max memory, can, in certain instances, result in a setting which subsequently prevents ASE from starting. Workaround Description  There are a couple of ways to work around this problem. Increasing the value of max_memory or reducing the value of number of user connections, or any other parameter that has caused this problem in the cfg file should enable the server to be restarted. Replacing the new cfg file with the previous most recent should have this effect too.

CR:572505

CR Number:   572505 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2014 Insufficient priority to fix Description Under rare circumstances a server configured with a default character set of utf8 can produce a stack trace when the soundex function is used on a column defined as being of type univarchar, and which also contain certain specific values. Workaround Description  N/A

CR:572560

CR Number:   572560 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A cross-database select from, or BCP out of a view with a column defined based on a user-defined function raises error 2846 - SQL Function not found. Workaround Description  Workaround is to fully qualify the UDF in the view

CR:572577

CR Number:   572577 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) 18 May 2009 Fixed Description When the Properties button on Threshold page of Segment Properties dialog is clicked, an internal error occurs.

CR:572595

CR Number:   572595 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UX Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New feature Request...NFR CR...to confirm in a way that satisfies auditors that an internal action by ASE, conducted as 'sa', was only the result of an an internal action by ASE rather then an external login by 'sa' to the server. Right now an internal action by ASE conducted as 'sa' will appear to be the same as an action done by one using an external login as 'sa' and this causes auditors to believe there has been a breach of the security policy/rules regarding the use of the 'sa' account.

CR:572710

CR Number:   572710 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2009 Fixed 04 Jun 2009 Fixed 07 Sep 2009 Fixed Description Performing sp_engine "offline", <N> on engine N that is hosting a COTS Java VM can result in stacktraces being reported in the ASE-errorlog if there are users connected to ASE executing Java in SQL statements. Workaround Description  do not offline the engine.

CR:572716

CR Number:   572716 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2009 Added to user documentation Description Request that documentation clearly states that SybMigrate cannot be used to do data conversion from single byte to utf8. Workaround Description  None

CR:572727

CR Number:   572727 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2010 Insufficient priority to fix Description Delete with top n does not use RowLimit Optimization.

CR:572779

CR Number:   572779 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 64 bit Linux batch i/o incorrectly reserving async i/o descriptors

CR:572789

CR Number:   572789 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error message 911, "Attempt to locate entry in sysdatabases for database '' by name failed - no entry found under that name. Make sure that name is entered properly." may be raised for a select into query where dbo is specified as the table owner and the table contains a user defined datatype. Workaround Description  remove dbo. qualification from object name

CR:572796

CR Number:   572796 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2009 Fixed 16 Jun 2009 Fixed Description Sp_addexternlogin does not work when the target server password has special characters e.g. "=". This can cause the sybmigrate process fail with an error like "Incorrect syntax near '

CR:572909

CR Number:   572909 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 2012 Insufficient priority to fix Description Comparisons of binary or TIMESTAMP values to numeric may not return true when they would in previous versions. Workaround Description  Explicitly convert binary column to numeric for comparison, eg: convert(numeric,binCol) = convert(numeric,@pAsCharNum)

CR:572941

CR Number:   572941 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2010 Presently Not Targeted For Any Future Release Of This Product Description When 'enable I/O fencing', kernel errorlog doesn't report sybase users not having access to the devices

CR:572959

CR Number:   572959 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2009 One-off Provided 16 Jul 2009 Fixed 23 Jul 2009 Fixed Description Compiler Optimizations that rearrange code blocks will lead to a negative keep count in the partition descriptor.

CR:572977

CR Number:   572977 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   RH Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2009 Fixed Description Run sybmon command "set" without arguments caused SIGSEGV.

CR:573068

CR Number:   573068 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2010 Fixed 14 Jul 2009 Fixed Description Setting a DOL table as a Hot object using dbcc des_bind decreases performance, as more time is spent in acquiring more intent locks.

CR:573103

CR Number:   573103 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: grant the kill command to user's (logins) without granting them sa_role. Workaround Description  ASE allows DBAs to selectively grant permissions for executing certain commands to specific users or logins by means of the grant statement. However, permissions for executing some commands (like kill) cannot be granted at all, even though this would sometimes be useful. 'This document will show how such functionality can be implemented safely, using only regular ASE features. Contents: What & Why The basic idea The full picture Examples Security: be careful with the role password Security: things (not) to do Notes Installation Conclusion Variations: What & Why By design, permissions on some T-SQL commands cannot be granted in ASE. One example of this is the kill command, which can be used to forcefully terminate a client process in ASE: the kill command requires that the executing login has sa_role, and permission to execute kill cannot be granted in any other way. While this limitation is understandable from a security point of view, it is sometimes undesirable in practice: many DBAs would like to allow their non-SA users to kill their own process. Because granting sa_role to ordinary users is not acceptable for security reasons, it means all requests for such actions still have to go via the DBA, increasing the DBA workload and decreasing productivity. Other examples of useful functions that require special system roles are things like sp_sysmon, sp_showplan and sp_object_stats (these all require sa_role). Sometimes DBAs have built custom application functionality just to allow their users to perform such privileged commands anyway. For example, I have seen a web-based application on a company's intranet where users could fill in an ASE server name and a spid number for a process they wanted to have killed. A cgi-bin script would then log into the ASE server as "sa" and issue the kill command This illustrates the practical need for granting certain commands to ordinary users, even though ASE itself does not currently allow this. Fortunately, this functionality can still be implemented inside ASE, using only regular ASE features. This document will illustrate how to allow ordinary, non-privileged users to execute privileged commands like kill, without giving away sa_role to those users. The basic idea: To demonstrate how to effectively grant the use of the privileged commands to non-privileged users, we will create a stored procedure called sp_kill which can be used by ordinary users to kill their own processes. The corresponding SQL code can downloaded here. The key to making this work is a creative way of applying user-defined roles: a role indirect_sa_role is created (with a password), and sa_role is granted to this role. Now indirect_sa_role is granted to an ordinary, non-privileged login as follows: create role indirect_sa_role with passwd mysecretpassword go grant role sa_role to indirect_sa_role go grant role indirect_sa_role to an_innocent_login go When login an_innocent_login executes sp_kill, this stored procedure will use set role to enable indirect_sa_role (and therefore sa_role), the kill command will be executed, and the role will be disabled again. The simplified example below shows how this mechanism works: -- -- The basic principle... -- create procedure sp_kill @spid int as begin -- create the 'kill' command string select @killcmd = "kill" + str(@spid,5) -- enable sa_role set role indirect_sa_role with passwd mysecretpassword on -- issue the kill now that we have sa_role execute(@killcmd) -- disable sa_role set role indirect_sa_role off end go sp_hidetext sp_kill go In the above code, sp_hidetext which 'hides' the T-SQL code of sp_kill, is essential in making the whole thing work: by hiding the code (using encryption), the password for enabling the role will not be visible to anyone, and users therefore cannot enable sa_role themselves. This way, the permission to execute kill is effectively "frozen" into sp_kill, and is available for anyone who can execute sp_kill. Because the role password cannot be retrieved from the encrypted T-SQL text, only those commands which have been programmed into the stored procedure are accessible to the user. The full picture: While the code in the above example illustrates the basic principle, it contains a security weakness making it unsuitable for practical use in this form. The problem lies in the fact that the user executing the above version of sp_kill may be able to interrupt execution of the procedure by hitting CTRL-C. When this happens after indirect_sa_role has been enabled but before it has been disabled again, sa_role would remain enabled for the user's session. Obviously, this would create an unacceptable security problem. To overcome this security issue, a slightly more elaborate setup is used. Instead of executing the stored procedure directly, it is executed indirectly as an RPC. Again, the user executes sp_kill, but this time the procedure doesn't do very much: it only executes another stored procedure sp_kill_rpc, and it is this last procedure which actually executes the kill statement. Because sp_kill_rpc is executed as an RPC (via CIS), the sequence of statements in sp_kill_rpc effectively becomes atomic for the user executing sp_kill : even if the execution of sp_kill_rpc would be interrupted, this would not give the original user access to sa_role. The (simplified) stored procedures are as follows: -- -- This procedure is executed by the user... -- create procedure sp_kill @spid int as begin set cis_rpc_handling on -- assumption: SERVERNAME_ALIAS has been set -- up as an alias of the current server name execute SERVERNAME_ALIAS...sp_kill_rpc @spid set cis_rpc_handling off end go -- -- This procedure is called from sp_kill as a CIS RPC... -- create procedure sp_kill_rpc @spid int as begin -- create the 'kill' command string select @killcmd = "kill" + str(@spid,5) -- enable sa_role set role indirect_sa_role with passwd mysecretpassword on -- issue the kill now that we have sa_role execute(@killcmd) -- disable sa_role set role indirect_sa_role off end go sp_hidetext sp_kill_rpc go Note that the complete versions of the stored procedures are more complicated, because they contain some additional checks. For example, it is ensured that a user can only kill processes owned by the same login. There are also various CIS-related checks and some code to ensure that sp_kill_rpc can only be invoked from sp_kill. See the code for full details. When CIS executes the RPC, it will --behind the scenes-- create a new connection to the ASE server itself to execute the RPC. This is a classic "trick" which is based on setting up a remote servername in sysservers which really is an alias of the current server (some older examples of this trick can be found here (simulating dynamic SQL) and here (various tricks with CIS and XP server)). By using CIS for the RPC mechanism, the login used for the CIS connection will be the same as the login originally executing sp_kill; no external logins need to be set up for this (in fact, it is best not to set up external logins at all as this keeps things like authorisation simple). Examples: sp_kill is actually very simple to use: only the 'spid' for the process-to-be-killed must be specified. Some additional checks have been built into sp_kill to ensure a user can only kill his own processes. 1> sp_kill 48 2> go Problem with this solution: The first problem of this Workaround it that the 'indirect_sa_role' herits of all 'sa_role' 's privileges and this is exactly what we want to avoid . The second problem : when the indirect_sa_role 's password is changed the procedure need to recreated.... What you want is it to explicity the grant/revoke 'KILL' Command to a role/login without having to give the 'sa_role' directly or indirectly and , of course , without having to create a procedure for each role that needs the KILL privilege...

CR:573149

CR Number:   573149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2009 Fixed Description In Adaptive Server Cluster Edition, after having dropped the local 'default data cache' for an instance when we reboot the instance, the local 'default data cache' may sometimes get re-instantiated after the reboot.

CR:573245

CR Number:   573245 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) 01 Jul 2009 Fixed Description A 1514 error, "Sort failed because it attempted to allocate page <page_no> and found that the page was busy", may be raised when Adaptive Server performs a sort operation. This occurs when a buffer is ready to be hashed, but the server finds a stale hashed buffer with the same page number in the cache.

CR:573341

CR Number:   573341 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2009 Fixed 15 Nov 2009 Fixed Description Index counters may not be updated in monOpenObjectActivity for a table

CR:573399

CR Number:   573399 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In certain circumstances involving query with multiple predicates, the index choice may not be entirely optimal if certain stats are known for specific attributes.

CR:573431

CR Number:   573431 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2009 Fixed 18 Jun 2009 Fixed 22 Sep 2009 Fixed 22 Sep 2009 Fixed Description Parallel queries with predicates that should qualify rows with NULL values aren't returning these rows. The problem is specific to non-sargable predicates (expressions. in-lists, and or-clauses) where the predicate is placed in a RESTRICT operator below an XCHG operator. For example: select * from r where r.id = NULL or r.id = 8 This query wouldn't return rows with an id column value of NULL if a parallel scan is done on "r". Note, the problem is unique to sessions where ansinull semantics are off. Workaround Description  set plan optgoal allrows_oltp

CR:573489

CR Number:   573489 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2009 Fixed 15 Jul 2009 Fixed 22 Jul 2009 Bundled Request Description System catalog sysobjects has a schema change: column objspare changes from int to smallint, and there is a new column unsigned smallint sysstat3.

CR:573619

CR Number:   573619 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2009 Fixed 11 Aug 2009 Fixed 20 Aug 2009 Fixed 13 Aug 2009 Fixed Description On AIX when Sybase Central 6.0.0 encounters an internal error, an internal error message about missing libjysblib600_r.a is shown instead of the regular error dialog.

CR:573639

CR Number:   573639 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) 21 Aug 2009 Fixed Description The message "current process infected with 11" in the module 'memcpy' together with a stack trace which includes the modules 'LeRun' and 'LeJoinContext::computeVirtualCols' may be reported in the error log if a SELECT UNION ALL query is executed involving an outer join, a TEXT column from the inner table is selected and some NULL values are returned.

CR:573724

CR Number:   573724 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) 28 May 2009 Not a Bug Description When a Japanese client is connected to an English server, ASE converts a char type and a varchar type into a long char type. Workaround Description  If a customer does not require the Unicode conversion, please change the value of "enable unicode conversions" into 0.

CR:573882

CR Number:   573882 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The ASE 15.x documents contain references to a "Troubleshooting and Disaster Recovery" document, which isn't included in the 15.5 document collection. The 12.5.x document collection does contain the document under the title "Troubleshooting and Error Messages Guide". This CR requests the document be included in the current doc sets, maintained, and enhanced.

CR:573897

CR Number:   573897 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2009 Fixed 15 Jun 2009 Fixed 16 Jun 2009 Fixed Description A WaitEventID value(which is larger than 251) in monProcess is incorrect. Workaround Description  NA

CR:573933

CR Number:   573933 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) 13 Aug 2009 Fixed 18 Aug 2009 Fixed 18 Aug 2009 Fixed Description Deletes over CIS to IQ may fail with error 11298. The 'DELETE' command contains syntax that requires it to use a cursor but ASE has disabled the support of updateable cursors against IQ.

CR:573986

CR Number:   573986 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2009 Bundled Request Description User see double spaces in ASE Plugin role wizard's wordings.

CR:573987

CR Number:   573987 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2009 Bundled Request Description User see double spaces in ASE Plugin index property's wordings.

CR:574024

CR Number:   574024 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2009 Bundled Request Description Database Device Properties always shows Direct I/O regardless of how created in Sybase Central.

CR:574193

CR Number:   574193 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) 28 Aug 2009 Fixed Description The error message that is reported when the PCI is unable to load a module has been updated to provide more detailed information about the cause of the failure. The new message explicitly reports whether the failure is due to a missing file, insufficient permissions or another problem indicated by a platform specific error number.

CR:574226

CR Number:   574226 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2009 Fixed Description Starting a cluster instance sometimes get ArrayIndexOutOfBoundException.

CR:574227

CR Number:   574227 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) 20 Aug 2009 Fixed Description If the master database has a secondary truncation point set during an upgrade from 12.5.x to 15.0.x, then an error 950 (Database 'master' is currently offline. Please wait and try your command again later) may be raised. To avoid this issue, preupgrade or upgrade will report an error if there is a secondary truncation point set.

CR:574264

CR Number:   574264 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) 08 Jul 2009 Fixed Description In rare circumstances, the message "Current process (...) infected with signal 11(SIGSEGV)" together with modules like (bool PopEmit<SerialCost,SerialProps>::emitMatchProperties, PopBase*OptGlobal::_GblAddTopLevel maybe be encountered for queries involving statement cache, literal autoparameterization, compatibility mode and OR terms. Workaround Description  Disable compatibility for this statement via set compatibility_mode off go

CR:574278

CR Number:   574278 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2009 Presently Not Targeted For Any Future Release Of This Product 22 Jun 2009 Fixed 03 Jun 2009 Fixed Description Adaptive Server may hit timeslice error during 'disk init/resize' involving filesystem devices or on usage of the device immediately after creation of the device using 'disk init'. Workaround Description  1. Increase 'cpu grace time' appropriately to give enough time for the operating system to flush all dirty buffers of the device being created. 2. If disk space is not a problem even in future, one can skip zeroing out of the device by passing 'skipalloc = true' option to 'disk init' command.

CR:574290

CR Number:   574290 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DOC : By default, if a table has a unique index and some nonunique indexes, Adaptive Server always chooses the unique index for an isolation level 0 scan. However the unique index is not always suitable for the query.

CR:574355

CR Number:   574355 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2009 Fixed Description On rare occasions, when the Housekeeper task (HK WASH) does not get scheduled often, Adaptive Server may report a false 863 error, "Buffer resources in cache <cachename>, id <cacheid> are unavailable. Please re-run this query or ask system administrator to re-configure buffer cache memory" even when there are enough buffer resources.

CR:574363

CR Number:   574363 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2009 Presently Not Targeted For Any Future Release Of This Product Description Creation of ase156ir optimizer level to enable by default all costing fixes in 15.0.3 and 15.5 ESDs. Previously, optimizer fixes which effect plan selection were only only enabled by configuring "optimizer level" as "ase_current". The ase_default optimizer level was ase1503esd1. The optimizer level for ase_default is now ase156ir.

CR:574476

CR Number:   574476 Product Name:   SyBooks CD Product Component:   SyBooks Status:   Open OS:   Microsoft Windows Original Version:   3.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Sybooks for Sybase IQ 15.0, installation error with "Latvian" regional settings Workaround Description  The workaround for this is to select English (United States) as the Regional/Language Option, then run the installer. After the installation is complete, set the language option back to Latvian, or any of the other unsupported languages.

CR:574482

CR Number:   574482 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2009 Duplicate Description Statement caching of parameterized language (PreparedStatement) fails with "Procedure < name > expects parameter @p0 which was not supplied. The problem occurs when the length of the string exceeds 16K. Workaround Description  disable statement caching for the connection while applicable statements are being executed. eg. set statement_cache off Note: In my customer case this is not practical as the end user tool does not allow anything by dml commands thru the normal interface, connection pooling is used and it is a huge performance hit to do this at the connection level.

CR:574518

CR Number:   574518 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2012 Added to user documentation Description DOC BUG: ASE 15.0.2 P&T Monitoring Tables, Table 1-1 incorrect

CR:574527

CR Number:   574527 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2009 Fixed 23 Jun 2009 Fixed 22 Jun 2009 Fixed 22 Jun 2009 Fixed 21 Aug 2009 Fixed 23 Aug 2009 Fixed 26 Aug 2009 Fixed Description The default ASE logical page size selected in ASE configuration tools has been changed from 2KB to 4KB. Request to pop a warning if user has selected this default value by accident. Also request to not change the meaning of "default" keyword in the resource files and let it continue to mean 2KB.

CR:574532

CR Number:   574532 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Fixed 12 Aug 2009 Fixed 19 Aug 2009 Fixed Description A permission denied error may be reported on SET_APPCONTEXT when executing a stored procedure.

CR:574533

CR Number:   574533 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2009 Fixed Description Sometimes users will see error message "JZ0R1: Result set is IDLE as you are not currently accessing a row." when accessing a ASE 12.5.x database

CR:574724

CR Number:   574724 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) 02 Oct 2009 Fixed 12 Oct 2009 Fixed Description Duplicate rows could be incorrectly returned when an EXISTS subquery is SELECTing from a DISTINCT view and not all of the view's SELECT columns are participating in the subquery's correlated equijoin predicates. Workaround Description  "set opportunistic_distinct_view off" to turn off opportunistics distinct handling.

CR:574725

CR Number:   574725 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2009 Fixed 11 Jun 2009 Added to user documentation Description Config file is not uploaded into quorum device after upgrade to SDC 'private' mode.

CR:574769

CR Number:   574769 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2009 Fixed Description The message "process infected with signal 11" may be reported in the error log together with a stack trace which includes the modules 'dbt_recalc_dboamcounts' and 'pcm__thread_handler' when ASE hits an error while correcting the OAM counts of a table during failover recovery.

CR:574771

CR Number:   574771 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) 20 Jul 2009 Fixed Description A query having concatenated columns in a GROUP BY clause may return an incorrect result if all the set of GROUP BY columns are unique to the result set. Workaround Description  Stop concatenating the columns in GROUP BY clause or force the query plan to use group_hashing by an abstract plan.

CR:574772

CR Number:   574772 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2009 Fixed 22 Feb 2010 One-off Provided Description In rare cases, some client connections working on a database with mixed log and data segment might hang and the stack includes function like pg_test_allocnode.

CR:574824

CR Number:   574824 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   closluce Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhance GUI for XML model elements with optional or mandatory, and minimum, maximum limit.

CR:574863

CR Number:   574863 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2009 Fixed 04 Jun 2009 Fixed Description When you set up both primary and secondary interconnected networks in your cluster input file, cluster does not restart unless both interconnected networks are running.

CR:574889

CR Number:   574889 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2009 Fixed 05 Jun 2009 Fixed 22 Jul 2009 Fixed 22 Jul 2009 Not a Bug 21 Oct 2009 Fixed Description When a few instances in a multiple instance cluster were just shutdown and restarted, SP commands may not able to proceed on one of the instances. The work around is not to run SP commands right away after node shutdown or node failure

CR:574923

CR Number:   574923 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2010 Fixed 14 Jan 2010 Reservation Made Description Part of the optimizer search space involving merge joins and/or hash joins are skipped if plans are evaluated before the exhaustive search engine is entered. The symptom may be seen by forcing a query plan which has a better estimated cost than the query plan that is eventually chosen. Workaround Description  abstract plans used for the best plan

CR:574963

CR Number:   574963 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2009 Fixed Description A 5807 error, "Invalid memory move request encountered for the <pool size> pool in cache <cache name>..." may be reported in errorlog while running sp_poolconfig.

CR:575043

CR Number:   575043 Product Name:   sybcluster Product Component:   Client Scripts Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2009 Fixed 07 Jun 2009 Added to user documentation 21 Oct 2009 Fixed Description Cann't show cluster config and status after deploy private cluster

CR:575064

CR Number:   575064 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) 23 Jul 2009 Fixed Description Procedural queries with optimizable LIKE clause may underperform executing more logical IOs than expected. Workaround Description  Use with recompile to get an accurate statistics IOs

CR:575080

CR Number:   575080 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2009 Fixed 16 Jun 2009 Fixed Description DDLGen doesn't hide the password when a space is supplied before the password.

CR:575088

CR Number:   575088 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2009 Bundled Request Description The dbinfo counts may be incorrectly marked as valid for a mixed log and data database which is created from a segregated log and data database.

CR:575111

CR Number:   575111 Product Name:   ASE Management Product Component:   Monitoring Data Collector Status:   Closed OS:   Generic Original Version:   3.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2009 Fixed 03 Jun 2009 Fixed Description An "ambiguous column name dbid" error (error number 209) occurs when the Databases screen in the SCC ASE Monitor view is opened if the monitored server is using a case-insensitive sort order.

CR:575115

CR Number:   575115 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) 06 Aug 2009 Fixed 06 Aug 2009 Reservation Made 07 Aug 2009 Fixed 07 Dec 2009 One-off Provided Description If there is a mismatch between the datatypes of the constants in the IN/OR list and the respective column, special OR strategy might not be used. ASE now provides a optcriteria 'use_mixed_dt_sarg_under_specialor' which when enabled, will allow special OR strategy to be considered in case of mixed datatype SARGs in the IN/OR list. Additionally, traceflag 434 has been provided to turn OFF this feature. The traceflag setting overrides the optcriteria setting.

CR:575124

CR Number:   575124 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2009 Fixed 01 Sep 2009 Fixed Description Enhance sp_helpcache to display in-memory storage cache space information.

CR:575151

CR Number:   575151 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 Aug 2009 Fixed Description A SIGSEGV (infected with 11) error is raised with function LeUpdateOp::_LeOpNext on the stack when the TSEQUAL function is passed a datatype other than timestamp. Workaround Description  Use tsequal as designed - with timestamp columns referenced in BROWSE mode.

CR:575156

CR Number:   575156 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description During upgrade an 1105 error on the system segment may occur despite preupgrade indicating the database has sufficient space.

CR:575195

CR Number:   575195 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) 20 Jan 2010 Fixed Description duplicate references in the ORDER BY list of a query could result in signal 11

CR:575205

CR Number:   575205 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2009 Fixed 15 Jul 2009 One-off Provided Description iofenceutil may say a device is not I/O fencing capable, eventhough it is.

CR:575251

CR Number:   575251 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) 12 Oct 2009 Fixed 12 Oct 2009 Reservation Made 13 Oct 2009 Fixed Description Wrong result may happen for a query if the SELECT list has an extended column which is not included in the GROUP BY clause and one of the group by columns has a constant sarg (col=<cnst>) on it. Similar wrong result could also happen for an equijoin between a GROUP BY view/derived table and other table when there is a constant sarg in the view for the joining column. Workaround Description  Remove extended columns from the SELECT list if acceptable. Or you may be able to avoid it by disabling merge join, but performance may get worse. (set merge_join off/sp_configure "enable merge join", 0/use allrows_oltp/etc) Or include the column in the group by clause.

CR:575293

CR Number:   575293 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2010 Fixed Description During modifcation of a default value on a column using Sybase Central 6.0 the 'select into/bulkcopy' option for the database is unnecessarily changed.