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

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

CR:538925

CR Number:   538925 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2008 Presently Not Targeted For Any Future Release Of This Product Description Create index may take abnormally long if done after a large amount of large-scale allocations have been done. Workaround Description  Create a user-defined segment on a device fragment that has plenty of free space and create the index on that segment. or Create a dummy table and insert enough data into it that it allocates all the free first extents. Over time, delete rows from it to free them back for general usage. (may be difficult to judge how big to create the table and how quickly to release the space)

CR:538990

CR Number:   538990 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 New Feature Request to allow use of bit type columns in composite indexes, to enable e.g. covered index scans.

CR:539000

CR Number:   539000 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) 05 Aug 2008 Fixed 24 Dec 2009 Duplicate Description In rare circumstance, 2630 error is hit when inserting rows into DOL table with index in multi-node cluster environment.

CR:539033

CR Number:   539033 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE Cluster Edition - Sybcluster:- To provide a single command to change quorum device path for existing cluster.

CR:539065

CR Number:   539065 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2008 Fixed 21 Oct 2008 Deferred 05 Feb 2009 Fixed Description The monCachedObject MDA table may include objects that do not have pages in a data cache.

CR:539103

CR Number:   539103 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2008 Fixed 18 Aug 2008 Fixed 19 Aug 2008 Fixed Description Monitor Server crashes in comn__sig_accept_thread upon receiving SIGHUP.

CR:539118

CR Number:   539118 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.1.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2011 EOL'd version. Not to be Fixed. Description If one configures Sybase Central to connect to a server via <host:port> then when attempting bcp operations on that server, the syntax given to bcp commands uses -S <host:port>.

CR:539162

CR Number:   539162 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) 27 Aug 2008 Fixed Description The message "no message text" may be reported when a DBCC CHECKTABLE command has been previously run against an ASE configured to use a non-English language.

CR:539175

CR Number:   539175 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2010 Fixed Description ASE 15.0.2 ESD#5 installer shows the wrong instruction message in Japanese.

CR:539255

CR Number:   539255 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) Description Error 3621 - 'Command has been aborted' may be reported when using 'select into existing table' from > 1 table involving text & identity columns.

CR:539256

CR Number:   539256 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) 24 Aug 2008 Fixed 09 Oct 2008 Fixed Description SELECT INTO EXISTING table consisting of an IDENTITY column with table joins may fail with error 3621.

CR:539293

CR Number:   539293 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2008 Duplicate Description A non-transactional select statement gets deadlock 1205 State 5 errors when running in a multi-node Cluster Edition environment. Workaround Description  Convert underlying table to DOL from APL. allpages -> datapages. Table can be identified from the 12665 traceflag.

CR:539355

CR Number:   539355 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2008 Fixed 05 Sep 2008 Fixed 08 Jan 2009 Not a Bug 08 Jan 2009 Not reproducible with latest version of the product available as of Resolution Date Description Job Scheduler fails to start on Windows with IPv6 enabled.

CR:539440

CR Number:   539440 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) 08 Sep 2008 Fixed 08 Sep 2008 Fixed Description When statistics are not available for queries that consider "distinct" operators, either an implicit distinct (such as an EXISTS subquery) or explicit "distinct", then the magic number used for the duplicate count is 10% for each column in the projection list. If there is one column in the distinct operation, then 10%=1/10 translates to 10 distinct values, or 10 rows. Creating statistics on the distinct column(s) will correct the problem. The default behaviour has been changed to assume a unique column, i.e. no reduction in rows after a distinct operation, when statistics are not available. This can be reverted to the old behavior of 10% by using the new optcriteria no_stats_distinctness either at a session or query level. The new behavior will tend to discourage eagerly placed sort nodes in query plan when statistics are not available, whose purpose is to reduce row count. Workaround Description  1) update statistics del_posn_ids (posn_id) 2) create a index on del_posn_ids 3) Or use this AP. The Abstract Plan (AP) of the final query execution plan: ( delete ( nl_join ( t_scan h_pns_future_acty ) ( store_index ( t_scan del_posn_ids) ) ) ) ( prop h_pns_future_acty ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop del_posn_ids ( parallel 1 ) ( prefetch 2 ) ( lru ) ) To experiment with the optimizer behavior, this AP can be modified and then passed to the optimizer using the PLAN clause: SELECT/INSERT/DELETE/UPDATE ... PLAN '( ... )'.

CR:539513

CR Number:   539513 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2008 Fixed Description SybCent 15.0.2 - permissions tab error "For input string "" on Unix platforms

CR:539531

CR Number:   539531 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   Solaris Original Version:   2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2010 Duplicate Description While you are installing ASE 15.0.2 ESD#5 to ASE 15.0.2 GA with an OEM license file on Sun x64 machine, setup may encounter SIGSEGV in libsylapij.so and generates a java stack trace, and then core dumps or hangs up. You can work around this issue by moving the OEM license file from $SYBASE/SYSAM-2_0/license directory before installation and moving it back to the directory after installation. Workaround Description  You can work around this issue by moving the OEM license file from $SYBASE/SYSAM-2_0/license directory before installation and moving it back to the directory after installation.

CR:539665

CR Number:   539665 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) 08 May 2009 Duplicate Description Feature request to have ASE verify that default values are valid for the column datatype when they are created.

CR:539672

CR Number:   539672 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) 20 Nov 2008 Fixed 21 Nov 2008 Fixed 23 Sep 2009 Fixed Description New options index level, allocated objects added allocated partitions to pageinfo built-in function.

CR:539699

CR Number:   539699 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 Oct 2010 Fixed Description Computed columns using global variables may under some conditions provide unexpected values. Sometimes stack traces may happen with reference to add__computedcol module when using the table with such computed columns.

CR:539740

CR Number:   539740 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2008 Fixed Description A non-transactional select statement with level 1 scan gets deadlock 1205 State 5 errors when running in a multi-node Cluster Edition environment.

CR:539757

CR Number:   539757 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2008 Fixed 15 Aug 2008 Fixed Description sp_displayaudit doesn't report auditing configuration on extended stored procedures. Workaround Description  TSE provided the following workaround: ========= below are the code that I changed in procedure: the rows marked with '------------> changed' are the rows that I changed. sp_aux_displaysprocaud: /* ** an object of this type must exist */ if (@objid is NULL) or ((select count(*) from sysobjects where (id = @objid and type in ('P', 'TR', 'XP'))) = 0) ------------> changed begin /* 17461, "Object does not exist in this database." */ raiserror 17461 return (1) end . . . /* ** First make sure there's at least one sproc/trigger ** with an active default. If not, just print a message ** and return. */ if (select count(name) from sysobjects where audflags > 0 and type in ('TR', 'P', 'XP')) = 0 ------------> changed begin /* ** 18009, "No procs/triggers currently have ** auditing enabled. */ exec sp_getmessage 18009, @msg output print @msg return (0) end . . . /* ** set up the cursor to look through sysobjects */ declare obj_cursor cursor for select id from sysobjects where audflags > 0 and type in ('TR', 'P', 'XP') ------------> changed open obj_cursor fetch obj_cursor into @objid select @procname = user_name(uid) + '.' + name from sysobjects where id = @objid select @all = 1 end /* ** Figure out which type of object we have */ select @ptype = type from sysobjects where id = @objid if @ptype = 'XP' or @ptype = 'P' ------------> changed select @optstr = "exec_procedure" else /* if @ptype = 'TR' */ select @optstr = "exec_trigger"

CR:539767

CR Number:   539767 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   HP-UX Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2008 Fixed Description Problem: ETL hangs when using DB Bulk Load Sybase IQ when an invalid pipe load script is executed. Resolution: ETL was modified to properly handle this error condition.

CR:539780

CR Number:   539780 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) 22 Aug 2008 Fixed Description Executing groupby queries with groupby columns reference java ADT may hit stack trace from LeHashEntry::Compare() in the module of LeHashContext::ProcessTuple() if the query plan chosen uses HashVectAggOp.

CR:539782

CR Number:   539782 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 Aug 2008 Fixed 28 Aug 2008 Fixed Description For cursor query referencing java ADT, spinlock and guardword corruption may happen if the cursor is not closed before exiting the session.

CR:539821

CR Number:   539821 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) 08 Aug 2008 Fixed 08 Aug 2008 Fixed Description Wrong result could happen for MERGE or HASH join when there is an equijoin predicate t1.c1 = <expression on t2.c2> and another redundant or equivalent equijoin predicate t2.c2 = <expression on t1.c1> is added which is simply a transformation from the first one. For example, t1.c1 = t2.c2-1 and t2.c2 = t1.c1+1

CR:539853

CR Number:   539853 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) 15 Oct 2008 Fixed 20 Oct 2008 Fixed 16 Oct 2008 Fixed Description Application Tracing doesnt work with "set statistics" options in login triggers.

CR:539897

CR Number:   539897 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) 14 Aug 2008 Fixed 08 Jan 2009 Fixed 04 Sep 2008 Fixed 29 Aug 2008 Fixed Description When the host component of a sp_listener command is an ipv6 address, it should be encloded in brackets. For example "tcp:[2001:ec8:4008:1::123]:80"

CR:539924

CR Number:   539924 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2008 Fixed 15 Oct 2008 Fixed 30 Jun 2009 One-off Provided 08 Jul 2009 One-off Provided Description ASE 15.0.2/AIX does print stacktrace with fdpr (Feedback Directed Program Restructuring)on FBO binary instead of trying to map that to the correct function.

CR:540007

CR Number:   540007 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Alter table allows setting a default that is incompatible with the chosen datatype. This will result in a 257 "implicit conversion" error when inserting data.

CR:540008

CR Number:   540008 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2008 Fixed Description There is no uninstall binary on HP-UX Itanium (B.11.31) after install ASE.

CR:540060

CR Number:   540060 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2008 Fixed Description Sybase Central stack traces when trying to view roles: Current thread: AWT-EventQueue-0 java.lang.NullPointerException at com.sybase.aseplugin.bo.ASEBasePage2.getJDialog(ASEBasePage2.java:73) at com.sybase.aseplugin.bo.prop.RoleProperties$RoleColumnPermissionPage.initTableComboBox(RoleProperties.java:2432) at com.sybase.aseplugin.bo.prop.RoleProperties$RoleColumnPermissionPage.initComboBox(RoleProperties.java:2403) at com.sybase.aseplugin.bo.prop.RoleProperties$RoleColumnPermissionPage.<init>(RoleProperties.java:2336) Workaround Description  Add the user in question or the 'guest' user to the top most user database as listed alphabetically in Sybase Central.

CR:540144

CR Number:   540144 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) 02 Sep 2008 Fixed 29 Aug 2008 Fixed 02 Sep 2008 Fixed Description A session executing a query may hang in modules 'des_get' and 'open__lwpbyname' while the statement cache is active. Workaround Description  Set statement cache to 0 if acceptable. But it could drop query performance.

CR:540177

CR Number:   540177 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2008 Duplicate Description The DDLGen.jar that is supplied with 15.0.2 ESD#5 reports multiple version strings

CR:540214

CR Number:   540214 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2008 Fixed Description In some rare situation, printing SQL text could cause stacktrace.

CR:540230

CR Number:   540230 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) 21 Aug 2008 Fixed Description May hit 11501 error while drop a function based index on partition table

CR:540271

CR Number:   540271 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2008 Fixed Description When bcp in a table with java column and clustered index, the non-nullable java column may become null due to some status of the text page lost.

CR:540282

CR Number:   540282 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2008 Workaround 12 Aug 2008 Not reproducible with latest version of the product available as of Resolution Date Description sp_help may run slower as more tables are created on the database when statistics are updated on sysmessages resulting in sub-optimal plans. Workaround Description  Use traceflag 318 (reformatting)

CR:540517

CR Number:   540517 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2008 Not a Bug Description Uncommitted remote transactions are not cleared after the remote server is bounced when the remote server is configured with 'server login'.

CR:540665

CR Number:   540665 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) 23 Aug 2009 Fixed 16 Dec 2008 Reservation Made 22 Jun 2009 Reservation Made 12 Nov 2009 Fixed Description Query performance may be affected on queries involving private temp tables for which optimizations are based on some magic numbers when statistics are not explicitly updated on the tables. An option is provided to implicitly generate statistics for private temp tables. The statistics are kept in memory until the temp table is dropped. Traceflag 2716 is used to turn on this option. Note that external tools such as optdiag and sp_modifystats will not affect the in-memory statistics. The feature does not support regular, partitioned and proxy tables, as well as optdiag output, compatibility mode and DDLs in stored procedures when deferred compilation is turned off.

CR:540684

CR Number:   540684 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2010 Fixed 03 Nov 2011 Duplicate Description The MDA table monOpenObjectActivity is reporting deferred UPDATEs as an additional DELETE-INSERT pair in the RowsUpdated, RowsDeleted and RowsInserted columns.

CR:540696

CR Number:   540696 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2009 Added to user documentation Description Need to document ISQL & BCP & DEFNCOPY parameters -X and -W for extended password encryption.

CR:540719

CR Number:   540719 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 allow user to define datatype of the RETURN value of a stored procedure. Workaround Description  Use an output parameter in the stored procedure or, in 15.x, use a user-defined function rather than a stored procedure.

CR:540770

CR Number:   540770 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) 19 Aug 2008 Fixed 27 Aug 2008 Fixed Description In rare circumstances, the message "Infect with 11" in modules 'memcpy' and 'com__dateadd_both' may appear in the errorlog during a query involving more than 6 tables, Nested Loop Joins and SARGs with convert(), dateadd(), getdate() and datepart(). Workaround Description  Use traceflag 306 to disable "compile time" evaluation of sargs for histogramming purposes. Can run under traceflag 15363 (although in reality this results in very poor plan) Could also turn off the statement_cache (again not ideal and won't work in all scenarios)

CR:540794

CR Number:   540794 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 Aug 2008 Fixed 22 Aug 2008 Fixed 12 Jun 2009 One-off Provided Description If statement cache is turned on and 'enable metrics capture' is also set, executing a query referencing temp tables will hit SIGSEV in the module 'memalloc' along with stack trace in the module 'metrics_dump' and 'ssql_purge_stmt_hastemp'. Workaround Description  Traceflag 467 to disable the caching of statements involving # tables.

CR:540836

CR Number:   540836 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) 19 Nov 2008 Fixed 12 Feb 2009 Fixed Description When upgrading a replicated database through dump and load, sysreferences is not updated with the new dbid if the ltm marker is not turned off prior to the dump and ONLINE is attempted prior to running dbcc dbrepair(dbname, ltmignore).

CR:540925

CR Number:   540925 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a new Resource Governor limit type for cpu_cost, which would limit actual cpu usage rather than overall elapsed time.

CR:540945

CR Number:   540945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2009 Duplicate Description In rare circumstances the signal 11 occurred in des_rekeep() when executing Dynamic SQL.

CR:540970

CR Number:   540970 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 Nov 2008 Fixed 04 Nov 2008 One-off Provided Description Unnecessary writes to temporary databases at end of index creation have been removed resulting in performance gain due to less I/O requests.

CR:540978

CR Number:   540978 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 Nov 2008 Fixed 04 Nov 2008 One-off Provided Description Unnecessary writes to temporary databases during index splits have been removed resulting in performance gain due to less I/O requests.

CR:540990

CR Number:   540990 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 sp_monitorconfig "number of java sockets" shows inconsistent values.

CR:541027

CR Number:   541027 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2008 Third Party Problem Description Under certain circumstances ASE may be caused to hang on Suse 9 and Suse 10 operating systems when monitoring the running process using external commands. Workaround Description  Do not try to trace system calls of dataserver process on Suse 9 using strace.

CR:541156

CR Number:   541156 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) 19 Aug 2008 Insufficient priority to fix Description backport CR 302065 to 12.5.x ... cross reference CR 302065 ... request for CIS : Idle timeout configuration parameter to eliminate idle cis connections from the remote server. ( please note this is different from the existing "cis connect timeout" parameter which applies only to the time taken to make the connection).

CR:541218

CR Number:   541218 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2008 Fixed 22 Aug 2008 One-off Provided Description The rollback of a bulk insert operation on a table with TEXT columns may encounter a 3478 error. This situation may happen for UNITEXT, or TEXT columns in a multi-byte character set server. Workaround Description  Engineering suggested 'dbcc lock_release' to clean up the phantom locks. The tool is introduced under CR 377545 http://www-dse/cgi-bin/websql/websql.dir/QTS/bugsheet.hts?bugid=377545 (this may not be a complete workaround since the ASE couldn't rollback the transaction.)

CR:541233

CR Number:   541233 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 Aug 2008 Fixed 12 Aug 2009 Bundled Request Description In rare circumstances, a 834 error, "Illegal attempt to clean buffer" together with a stack trace which includes modules 'dbt_unreserve()' and 'cm_dbclean()' may be reported in the error log when dropping a suspect database.

CR:541302

CR Number:   541302 Product Name:   Adaptive Server Generic Docs Product Component:   Security Administration Guide Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2009 Presently Not Targeted For Any Future Release Of This Product Description 'Addressable memory limits' in System Administration Guide needs to be updated to include the memory limits on 15.0.x (which will be the same as 12.5.x on the whole)

CR:541324

CR Number:   541324 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) 18 Aug 2008 Fixed 04 Dec 2008 One-off Provided 03 Feb 2010 Insufficient priority to fix Description The UPDATE STATISTICS command ignores the setting of the histogram tuning factor resulting in many fewer steps created when updating statistics. This can cause bad plans to be chosen due to the innacurate statistics.

CR:541477

CR Number:   541477 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2010 Consult Complete Description Optimizer- hardcoded value in SQL runs slower than @var

CR:541563

CR Number:   541563 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) 12 Nov 2008 Fixed Description User should not create a column with the name of "SYB_IDENTITY_COL" even he sets quoted_identifier on.

CR:541567

CR Number:   541567 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2008 Fixed Description Previously when DBISQL tried to connect to an ASE running on HP-IA, the connection would fail with a mustached character set. User had to manually select "iso_1" to connect to the server properly. This has been fixed so that no user-interaction is required in such situation. The Connect Dialog would internally switch to the proper character set.

CR:541627

CR Number:   541627 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2008 Fixed 15 Sep 2008 Fixed 26 Jan 2009 Fixed Description Distinct query with plan using sort merge join may return duplicate rows. Workaround Description  Turn off sort-merge

CR:541641

CR Number:   541641 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) 02 Sep 2008 Fixed 01 Oct 2008 Fixed Description In rare circumstances, ase may hang while inserting values into the table having identity column.

CR:541761

CR Number:   541761 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2008 Fixed Description isql with -Q option causes tds state machine error leading to connection failure

CR:541882

CR Number:   541882 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2008 Fixed Description 1254 ESD#8 on Linux RH 5.0 silent install failed Workaround Description  run the installer ( setup ) with below argument: -cp:p /usr/u/taile/linux_patch.jar

CR:541888

CR Number:   541888 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) 12 Jun 2009 Insufficient priority to fix Description To avoid ambiguous results, ASE should prohibit assigning to a variable more than once per statement. Workaround Description  Write statements so they only make a single assignment to each variable.

CR:541911

CR Number:   541911 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description allow bcp to work with tables named using quoted_identifiers. Workaround Description  use sp_rename to rename the table before and if need be, after the bcp is run.

CR:541989

CR Number:   541989 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) 07 Oct 2008 Fixed 30 Sep 2008 Reservation Made 22 Sep 2008 Fixed 15 Mar 2009 Fixed Description A new server wide configuration parameter "capture missing statistics" has been added which when enabled will capture the information about columns on which we find missing statistics while we are optimizing a query. The new information will be stored in SYSSTATISTICS table.

CR:542013

CR Number:   542013 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) 01 Oct 2008 Fixed Description After running sp_companion 'prepare_failback', an error 940("Dbtable in wrong state for operation") is reported while committing a transaction.

CR:542049

CR Number:   542049 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to allow SET TABLE COUNT and SET CHAINED settings to be exported from login triggers.

CR:542079

CR Number:   542079 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) 28 Aug 2008 Fixed 06 Oct 2008 Presently Not Targeted For Any Future Release Of This Product Description In Adaptive Server 15.0.2 ESD#6 and later, when a database, originally created with log and data mixed, is extended on to another device using the ALTER DATABASE command without using the LOG ON clause, the newly added disk piece gets marked as "data only" instead of "data and log". That is, no log space is added by the command. Due to this, the database may run out of log space sooner than expected. Workaround Description  To extend the log space for any database originally created with data and log mixed, always use the LOG ON clause with the ALTER DATABASE command. For example, for extending the log space of database db1 which was created with data and log mixed, we can either do: alter database db1 log on <device_name>[=<log_size>] go OR alter database db1 on <device_name>=<data_size> log on <device_name>=<log_size> go

CR:542096

CR Number:   542096 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 Sep 2008 Fixed Description For UNION ALL query under allrows_dss optgoal (or "advanced_aggregation" is on), signal 11 stacktrace might happen in CgpUnion::_cgpInit() during compilation. The stacktrace is more likely to happen if "append_union_all" is also turned off.

CR:542143

CR Number:   542143 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) 27 Aug 2008 Fixed 28 Aug 2008 Fixed Description When an instead-of trigger is defined on a VIEW that involves LOB columns and proxy tables, then executing a statement on the VIEW that fires the instead-of trigger may fail with message 3621, "Command has been aborted."

CR:542209

CR Number:   542209 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 Sep 2008 Fixed 03 Sep 2008 Fixed Description Support reuse of cached statements that reference TEMP tables across sessions under trace flag 299.

CR:542216

CR Number:   542216 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 Duplicate 05 Sep 2008 Fixed 11 Sep 2008 Reservation Made Description This implements a new feature called "compatibility mode", where ASE 15 generates and executes query plans in a manner similar to 12.5.X. The compatibility mode option can be turned on for ASE using a configuration option. No new ASE 15 features like partitioning, computed columns etc will be supported by this mode and when used will default back to the ASE 15 optimization modes.

CR:542234

CR Number:   542234 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2008 Fixed Description Firing an instead-of trigger on a view with big LOB colums may hit SEGV in memtextlen() along with the stack trace in the module of '_LeEoSendColumnToClient'

CR:542339

CR Number:   542339 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2012 Fixed 15 May 2013 Presently Not Targeted For Any Future Release Of This Product Description The command, 'diagnose instance', does not report any message if the interfaces file is missing the domain suffix of the machine name.

CR:542345

CR Number:   542345 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2008 Fixed 21 Apr 2009 Fixed Description Executing a query from java involving proxy tables may stacktrace with SIGSEGV. Workaround Description  *** Wednesday, August 27, 2008 7:05:55 AM *** cooperg *** Change the SQL to not use a proxy table. In this customers case change: String sql = "select isnull(convert_account,\"\") from account where acctnum = ?"; to the following it works fine: String sql = "select isnull(convert_account,\"\") from asbcore..account where acctnum = ?";

CR:542352

CR Number:   542352 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2008 Fixed Description For select query in browse mode and the query does not involve any tables, it could cause: CT-LIBRARY error: ct_results(): protocol specific layer: external error: There is a tds protocol error. Premature end of the datastream was encountered. e.g. select 'Mary' for browse

CR:542437

CR Number:   542437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2009 Not reproducible with latest version of the product available as of Resolution Date Description Internal Only: intermittent tcf failure. Workaround Description  N/A

CR:542478

CR Number:   542478 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2008 Fixed 12.5.4 02 Sep 2008 Fixed 02 Sep 2008 Fixed 02 Sep 2008 Fixed Description In certain circumstances ASE may incur segmentation violation in function ubffree(). Workaround Description  Under certain specific circumstances a stack trace can be triggered by signal 11 when freeing memory internal to ASE.

CR:542504

CR Number:   542504 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for ability to audit encryption and decryption of data by users.

CR:542539

CR Number:   542539 Product Name:   Adaptive Server Enterprise Product Component:   QPtune Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2008 Fixed 06 Nov 2008 Fixed Description Improvements include: * Release of the basic QPTune functionality * Add missing stats support * Save queries to user specified groups before any tuning exercise * Change setting default optgoal during fix to avoid any conflict * Other bug fixes and cosmetic changes to improve the existing utility overall

CR:542635

CR Number:   542635 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) 11 Sep 2008 Fixed Description When optimistic index locking is configured for an APL table, changes due to a CLR record may be lost, leading to a host of possible errors.

CR:542643

CR Number:   542643 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 Enhance MDA tables with the ability to display the value of parameters being passed to prepared statements (lightweight procedures)

CR:542721

CR Number:   542721 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2008 Fixed Description Executing a query with parallel reformatting plan may hit error 8211 in the module of 'des__hashinst' together with stack trace in the module of 'lwp_create'. Workaround Description  set store_index 0 (to disables reformatting at the session level) OR trace flag -T328 (to disables reformatting at the server level)

CR:542834

CR Number:   542834 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 for a "reverse forceindex" option that would instruct the optimizer to not consider use of specified index(es)

CR:542839

CR Number:   542839 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description T693 is not blocking DOL inserts

CR:542863

CR Number:   542863 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) 19 Sep 2008 Fixed 08 Sep 2008 Fixed 08 Sep 2008 Fixed 09 Sep 2008 Fixed 10 Sep 2008 Fixed 12 Sep 2008 Fixed 12 Sep 2008 Fixed 06 Nov 2008 Presently Not Targeted For Any Future Release Of This Product 21 Nov 2008 Fixed 30 Oct 2008 Fixed 30 Oct 2008 Fixed 30 Oct 2008 Fixed 02 Dec 2008 Fixed Description In order to use the earlier Kona JVM when invoking a Java method, set the "enable pci" configuration parameter to 0 and the "enable java" parameter to 1. The message "ASE - Dynamic Pluggable Component Interface is disabled" will be reported in the error log. This can be done only on Adaptive Server 15.0.3 ESD#1 or later.

CR:542978

CR Number:   542978 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   Linux Original Version:   15.0.2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2008 Fixed Description Internal only: the asepyxis branch requires that environment variable ASE_MODE be set, even for builds of products for which mode is irrelevant.

CR:543053

CR Number:   543053 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2008 Fixed 02 Feb 2009 Fixed Description A 806 error may be reported when running the cammand of dbcc checkalloc with FIX option on the user database.

CR:543054

CR Number:   543054 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) 05 Sep 2008 Fixed 05 Sep 2008 Fixed Description In rare circumstances , we may hit a stack trace in module "ptn_pdes_clean".

CR:543088

CR Number:   543088 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) 09 Sep 2008 Fixed Description sp_showplan may not provide correctly the query plan for a stored procedure with statements compiled in the deferred mode. Workaround Description  dbcc traceon (7730) --but not recommended as will have a detrimental effect on performance

CR:543123

CR Number:   543123 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2008 Fixed Description The commands DBCC CHECKSTORAGE and DBCC CHECKVERIFY may incorrectly tag some spurious faults as hard faults when it checks some dirty pages in cache that have been marked as needing validation in the cluster.

CR:543146

CR Number:   543146 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 Oct 2008 Fixed 30 Dec 2008 Fixed Description Kerberos logins with 'data integrity' or 'replay detection' option (-Vi, -Vr) may raise an error: "Invalid security token" when a query is sent to ASE confiured with multiple engines.

CR:543208

CR Number:   543208 Product Name:   Adaptive Server Generic Docs Product Component:   Using Sybase Failover In a HA System Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2008 Added to user documentation Description Installmaster instructions missing from HA docs in 15 manual. When re-running installmaster, set 'state_machine' to halt.

CR:543219

CR Number:   543219 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Open OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description InstallShield to set or warn on file permissions for VCS HA files during upgrade.

CR:543275

CR Number:   543275 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2010 Fixed 03 Nov 2011 Presently Not Targeted For Any Future Release Of This Product Description monSysStatement StartTime column is not correct for statements that execute stored procedures Workaround Description  NA

CR:543278

CR Number:   543278 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2008 Fixed Description GRANT command raised 2601 error on sysroles on target server after migration.

CR:543317

CR Number:   543317 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 Dec 2008 Fixed 01 Jul 2010 Presently Not Targeted For Any Future Release Of This Product Description Infected with 11 occurs in parse_name() when you execute 'exec @proc' with @proc = NULL on a multi-byte language and character set server. Workaround Description  Check if the local variable for the stored procedure name is NULL or not before executing the stored procedure. If it's NULL, don't execute the procedure.

CR:543327

CR Number:   543327 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) 08 Sep 2008 Fixed Description In rare circumstances, ASE may hang while inserting identity values in the table.

CR:543349

CR Number:   543349 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) 22 Oct 2008 Fixed 24 Feb 2009 Fixed Description Under rare circumstances, the message "current process infected with 11" in the module 'bufdlink' may be displayed in errorlog while doing 'online database'.