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

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

CR:485752

CR Number:   485752 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) 11 Jan 2008 Fixed 11 Jan 2008 Fixed 16 Jan 2008 Fixed 16 Jan 2008 Fixed Description Error 515 is raised when update non-null image/text column with 256 bytes through jConnect Stream/BLOB interface.

CR:485756

CR Number:   485756 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2007 Fixed 11 Mar 2008 Fixed Description When an INSERT, UPDATE, DELETE or SELECT statement processes an encrypted column, the statement may fail with error 15432, 15467 or 15469 if all the following conditions hold: - The statement is executed in the context of a nested stored procedure. - The nested procedure exists in a different database from the parent procedure. - The parent stored procedure has been created by a user with sa_role. - The parent procedure is invoked by a user who does not have sa_role and is not the dbo of the nested procedure's database.

CR:485801

CR Number:   485801 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2008 Fixed Description CIS: ORDER BY doesn't work if a proxy table is involved in the derived table with a SARG IN Workaround Description  1. Append a null string to the ORDER BY 2. set merge_join 0

CR:485804

CR Number:   485804 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2010 Presently Not Targeted For Any Future Release Of This Product 12 Mar 2010 Duplicate Description When a very large memory is allocated to ASE, it can take a significant to boot whilst the OS allocates the shared memory. To make this phase more visible, messages have been added to the errorlog.

CR:485814

CR Number:   485814 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Open OS:   Windows XP Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2007 Fixed 07 Dec 2007 Fixed 05 Feb 2010 Fixed 12 Dec 2007 Fixed 03 Jan 2008 Fixed 21 Jan 2008 Fixed 21 Jan 2008 Fixed Description Sybatch(sybinit) fails with a 950 error, because ASE takes too long to recover a database. Workaround Description  Manual upgrade.

CR:485817

CR Number:   485817 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2007 Fixed Description Error 249 may be raised in some cases from an attempt to convert a column value using an expression in a predicate when that column may be filtered by other predicates in the query. Workaround Description  Use "isnumeric" function to test if the number you are about to covert is a number. Effectively, this is numeric equivalent of isnull. To swap the order of in and != . another workaround for this case is to order the predicates in the order that one wishes them to be evaluated, i.e. order the IN list first in the where clause.

CR:485861

CR Number:   485861 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) 27 Nov 2007 Fixed 28 Nov 2007 Fixed Description The LIKE clause is not passed to the remote server when querying a proxy table when parameters or variables are present in the LIKE clause.

CR:485863

CR Number:   485863 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2008 Fixed 25 Mar 2009 Fixed 25 Mar 2009 Fixed Description When using a select with an order by clause as the source of values for an insert statement (eg insert table 1 select column2 from table2 order by column1, column2) then the ordering may not happen correct if all the columns in the order by clause arn't also in the select clause.

CR:485871

CR Number:   485871 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Open OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Refine the round robin assignment of temporary databases, to consider whether a temporary database is full before allowing a session to using that database. Workaround Description  N/A

CR:485881

CR Number:   485881 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2008 Fixed Description ASE 15.0.2 GA hits signal 11 in processing sp_helpdb <userdb> > kernel Current process (0x180018) infected with signal 11 (SIGSEGV) > kernel Error at address 0x4000000000db6c33 (pg_fill_supergam+0xfb)

CR:485890

CR Number:   485890 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) 08 Jan 2008 Fixed Description A Hang due to physical lock deadlock can happen when one thread is executing select in a loop and the other thread is executing insert-delete(alloc-dealloc) operations.

CR:485903

CR Number:   485903 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2007 Fixed Description When sp_password is executed to change a user's login password, ASE may print error messages 950 and 15484 if any individual database is offline. These messages refer to encryption keys and may be seen even if the server has not enabled the ASE_ENCRYPTION license.

CR:485930

CR Number:   485930 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2007 Fixed Description For create local index on partitioned table in parallel, if option "set sort_resources" is on, we could encounter sig 11.

CR:485961

CR Number:   485961 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed 03 Jan 2008 Fixed 10 Jan 2008 Fixed Description sp_help <tablename> fails with message 512, "Subquery returned more than 1 value. This is illegal when the subquery follows =, !=, <, <= , >, >=, or when the subquery is used as an expression." in the following situation: 1) table <tablename> has an encrypted column c1 with decrypt_default; 2) alter table <tablename> modify c1 ... decrypt_default <default value>; 3) sp_help <tablename>.

CR:486005

CR Number:   486005 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2008 Fixed Description In rare circumstances, Adaptive Server may hang as a result of an undetected deadlock between a process that is doing instance failover recovery and another process that is trying to execute a user query.

CR:486017

CR Number:   486017 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2007 Duplicate Description Enable ASE Messaging on HP-UX Itanium 64-bit platform.

CR:486034

CR Number:   486034 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description dbcc checkstorage report 100025 errors on ASE version 125x. Workaround Description  Make sure the row count get updated with some insert , delete. // for the repro: insert into corrupt_t1 values ('niklas') go 200 delete corrupt_t1 where col1 = "niklas" go

CR:486047

CR Number:   486047 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2009 Presently Not Targeted For Any Future Release Of This Product 18 Nov 2008 Fixed 06 Aug 2009 Fixed Description Under rare circumstances dbcc checkstorage can get stuck, with a worker process waiting for a response from the parent and vice versa. Workaround Description  N/A

CR:486072

CR Number:   486072 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2007 Fixed Description The word "all" is not a valid entry for the login parameter for sp_locklogin. Only NULL or a valid login are acceptable. Workaround Description  Use NULL for login when you want the action to affect all logins.

CR:486123

CR Number:   486123 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) 18 Dec 2007 Fixed 17 Jan 2008 Fixed Description In rare circumstances, stack guard gets corrupted when executing at higher nesting levels.

CR:486130

CR Number:   486130 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2008 Bundled Request Description Creation of the quorum device may fail with "Quorum library error 48: Found invalid section 'management' at line %d in cluster input file" if the cluster input file contains whitespace characters following the ']' character for the first section entry. For example, "[cluster] " instead of "[cluster]".

CR:486179

CR Number:   486179 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2008 Fixed 30 Sep 2008 Presently Not Targeted For Any Future Release Of This Product Description In rare circumstances, Adaptive Server may hit issue accessing dbtable on remote node while running sp_bindcache operation. Stack traces of spids involved will contain function 'cm_bindremote_cache'.

CR:486193

CR Number:   486193 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2007 Not reproducible with latest version of the product available as of Resolution Date Description ASE1502 View not accessible when db on-lined with standby_access. Reported: Adaptive Server Enterprise/15.0.2/EBF 14331/P/Linux Intel/Linux 2.4.21-47.ELsmpi686/ase1502/2486/32-bit/FBO/Thu May 24 08:15:50 2007 Reproduced on same platform/ build and Adaptive Server Enterprise/15.0.2/EBF 14332/P/NT (IX86)/Windows 2000/ase1502/2486/32-bit/OPT/Thu May 24 04:10:36 2007 Not Reproducible on Adaptive Server Enterprise/12.5.4/EBF 13387/P/NT (IX86)/OS 4.0/ase1254/2006/32-bit/OPT/Sat May 20 00:54:28 2006 Create a database create a table and a view. Dump database then load and on-line using standby_access. try to access view.. Error: Msg 225, Level 16, State 1: Server 'V1502B32', Line 1: Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization. If database in on-lined normally then no problem accessing the view.

CR:486199

CR Number:   486199 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2008 Fixed Description DBISQL tool Feature request: to add "Find/Replace" menu option for "Results" window

CR:486217

CR Number:   486217 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2007 Fixed 04 Dec 2007 Fixed Description In rare cases, during undo pass of instance failover recovery, when recovery thread is pre-fetching a page, it could hit error 891 because the page already exists in a different cache.

CR:486243

CR Number:   486243 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2008 Fixed 31 Jan 2008 Reservation Made Description In rare circumstances, after setting the database to single user mode, Adaptive Server may hang as a result of an undetected deadlock between a user process doing checkpoint and a system process that is doing checkpoint as well.

CR:486247

CR Number:   486247 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) 28 Jan 2008 Fixed Description Using lct_admin("abort", <spid>, <dbid>) to abort a single spid may print error 7421 that the process is not active even when the process is active in the cluster.

CR:486266

CR Number:   486266 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) 31 Jan 2008 Fixed Description Internal Only: Commit timestamp might go backwards after an instance leaves the cluster.

CR:486271

CR Number:   486271 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2007 Fixed Description DBCC LOG when used with print option 4 for system catalogs, may not be able to decode and print the system catalog rows. The message "Could not locate SYSCOL array for catalog <catalog_ID> (<name>) at log version <log_version_ID>" is printed instead.

CR:486283

CR Number:   486283 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed Description sp_help error message in sp_autoformat with encrypted column and decrypt default. When the maximum decrypt_default name length is less than 15, "sp_help table" may fail with Msg 18588.

CR:486371

CR Number:   486371 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2009 Duplicate Description A query joining an index with a derived table or view which has GROUP BY clause may return less rows than expected if MERGE JOIN is chosen. It could happen if one equijoin column is part of the index keys and the same column has an equisarg (col=<constant>) in the derived table/view definition. Workaround Description  disable mergejoin by "set merge_join off".

CR:486377

CR Number:   486377 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) 12 Jan 2009 Presently Not Targeted For Any Future Release Of This Product 13 Dec 2007 Added to user documentation 12 Aug 2009 Duplicate Description Adaptive Server Shared Disk Cluster may fail over unnecessarily even if config parameter "cluster heartbeat retries" is increased.

CR:486389

CR Number:   486389 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2007 Fixed Description To suppress stack trace displayed when we hit "java.lang.OutofMemory" in DBISQL.

CR:486401

CR Number:   486401 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2007 Fixed Description The 'set triggers off' command will incorrectly turn off Instead Of Triggers and will cause a segmentation fault in the function, s_execute().

CR:486405

CR Number:   486405 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2008 Fixed 07 Jan 2008 Reservation Made Description When a view exists that has an Instead of Trigger, and the table underlying the view is dropped, inserts on that view do not return an error and appear successful.

CR:486426

CR Number:   486426 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) 07 Apr 2009 Deferred Description Abstract plan shows index on APL table is used, but showplan shows table scan

CR:486468

CR Number:   486468 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) 06 Dec 2007 Fixed 05 Dec 2007 Fixed 15 Dec 2007 Fixed Description When doing two bcps in parallel from two different nodes, one bcp session's data might be lost.

CR:486566

CR Number:   486566 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Library Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2008 Fixed 16 Jan 2008 Fixed 24 Jan 2008 Fixed 19 Mar 2008 Fixed 14 Mar 2008 Insufficient priority to fix Description testmon Monitor Client sample program will not compile in the 15.0 release Workaround Description  For Makefile_sun_svr4_native, make the following changes: Added lines: MONCLTLIBDIR = $(SYBASE)/$(SYBASE_OCS) Changed lines are commented out followed by working lines: # EXTRALIBS = -lC -lsocket EXTRALIBS = -lCrun -liostream -lsocket #all: testmon testhist all: testmon Completed comment out references to testhist: #testhist: testhist.o # $(CC) $(LDFLAGS) testhist.o $(LIBDIR) $(LIBS) -o $@

CR:486568

CR Number:   486568 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2007 Workaround Description Queries and results are shown in top window/ bottom windows configuration. There is no option to display results in a totally separate window. Customer would like to be able to have an option to be able to atomaticly open a new window in the session that only has the result set just like SQL Advantage did. Target Version  To Be Determined

CR:486570

CR Number:   486570 Product Name:   ASE Replicator Product Component:   Distributor Status:   Closed OS:   Generic Original Version:   15.0.1.410P1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2010 EOL'd version. Not to be Fixed. Description Replication stops at around 9 tables added for replication.

CR:486576

CR Number:   486576 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2007 Fixed 11 Mar 2008 Fixed Description Error 12316 "Attempt to garbage collect a deallocated data page <value> in table '<value>', database '<value>'. Aborting the transaction." may be reported by the HK GC system task while trying to garbage collect a page that is in the process of being deallocated. Workaround Description  Customer is disabling HK GC while this process is executed, however has not been confirmed if this could help or not.

CR:486578

CR Number:   486578 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2007 Fixed Description In ASE 15.X, the "set statistics io" command was not reporting the open count correctly for scans beneath XCHG operators.

CR:486581

CR Number:   486581 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) 07 Dec 2007 Fixed Description Error 10334 is raised when trying to create a java-based user-defined function while auditing is turned on.

CR:486583

CR Number:   486583 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) 08 Jan 2008 Fixed Description When instances in ASE Cluster Edition are heavily loaded, some operations involvoing inter-node communication may fail with errors or may hang.

CR:486595

CR Number:   486595 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Dec 2007 Fixed Description A new Database device can be creted using Disk init command. Adaptive Server accepts, but does not require, the disk init vdevno (virtual disk number) parameter. If you specify a vdevno, you may choose any currently unused identifier from 1 to 2,147,483,647 (virtual device ID 0 is used by the master device). In sp_sysmon, Result space is given three characters width only. When the given value for vdevno > 999, value is exceeding three character width hence causing the error. Workaround Description  The error is occurring due to code >>insert into #devicemap values(@DiskName,@PhysName,"disk_"+convert(char(3),@grp)) in sp_sysmon. The required result space with three characters can hold maximum value 999. Change the code line in sysmon to >insert into #devicemap values(@DiskName,@PhysName,"disk_"+convert(char(10),@grp)) in installmaster. Reboot the server and do installmaster.

CR:486603

CR Number:   486603 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2008 Fixed Description "Lookup Table Name" function of DBISQL cannot show the table column of other DB. Workaround Description  Please change DB operated on a main screen.

CR:486604

CR Number:   486604 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) 08 Dec 2007 Fixed 08 Dec 2007 Fixed 09 Jan 2008 Fixed Description During redo pass of instance failover recovery, when recovery thread tries to acquire logical lock while redoing DEALLOC or DEALLOCM type log records, it could fail which will result in error 3484.

CR:486610

CR Number:   486610 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) 06 Dec 2007 Fixed 06 Dec 2007 Fixed 06 Dec 2007 Fixed 06 Dec 2007 Fixed 06 Dec 2007 Fixed 06 Dec 2007 Fixed Description In rare cases, in SDC server, dump tran could hit 4218 error during dmp_send_runlist, because the first log page number used by dump tran is not correct.

CR:486634

CR Number:   486634 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) 31 Jan 2008 Fixed Description Internal Only: In a cluster system with more than two instances, under rare circumstances, activities involving data or log space usage could hang as a result of an error in cluster threshold manager.

CR:486677

CR Number:   486677 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) 18 Feb 2008 Fixed 03 Mar 2008 Fixed Description The message "Current process infected with signal 11" in the module 'stio_writehistogram' together with a stacktrace that includes 'st_writestatistics' and 'sysstatistics_write' may be reported in the errorlog when an UPDATE STATISTICS command is run on a multi-attribute column group with sampling enabled.

CR:486679

CR Number:   486679 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2007 Fixed Description In parallel queries, the ExchangeEmit op's row count is always reported as 0 when plancost is enabled.

CR:486686

CR Number:   486686 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2007 Fixed Description Query against MDA tables hits Error 325 when optgoal is allrows_dss. Workaround Description  If running with optgoal allrows_dss (only optgoal in which this fails): set plan optgoal allrows_mix (or allrows_oltp) go RUN QUERY... set plan optgoal allrows_dss go

CR:486693

CR Number:   486693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2007 Fixed Description Support has been added to the builtin, showplan_in_xml, to print information about runtime partition elimination. When runtime partition elimination will be attempted, the showplan_in_xml output will contain: <DynamicPartitionIdentification>Yes</DynamicPartitionIdentification> and when runtime partition elimination will not be attempted, the showplan_in_axml output will contain: <DynamicPartitionIdentification>No</DynamicPartitionIdentification>

CR:486703

CR Number:   486703 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2008 Fixed 02 Jan 2008 Reservation Made Description When parallelism is turned on, some queries, especially those with an orderby clause, may hang waiting for read operations on pipes.

CR:486762

CR Number:   486762 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Audit Restart sends "Server boot" audit record event 50. An Audit Restart should have a separate event.

CR:486766

CR Number:   486766 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) 27 Dec 2007 Fixed 12 Mar 2008 Fixed 05 Nov 2008 Fixed Description A join query with a plan using the Dynamic Index strategy may sometimes fail with error "Msg 1504 Internal Sort Error. Empty Index Page found.". This may happen if the optimizer decides to use the Dynamic Index as an inner table in the join and the parallel sort is applied to the Dynamic Index worktable. Workaround Description  make the table allpages.

CR:486772

CR Number:   486772 Product Name:   Adaptive Server Enterprise Product Component:   sybconfig Status:   Closed OS:   Windows W2k Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2007 Duplicate Description Syconfig fails to create ASE 16K on 12.5.4 Win2000 if you increase the master dev size and db size. Workaround Description  Create the server with the default sizes for device and db.

CR:486773

CR Number:   486773 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) 26 Jun 2009 Insufficient priority to fix Description Feature request to have SHOWPLAN output explicitly indicate presence of Cartesian joins.

CR:486787

CR Number:   486787 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) 19 Dec 2007 Insufficient priority to fix Description The customer requests that CR 465382 have an opposite effect for messages 15082 and 15084. Instead of suppressing these warning messages, remove the errors all together, and use a traceflag to enable the messages.

CR:486866

CR Number:   486866 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2008 Duplicate Description Dumping and loading d/b with an user proc created originally in a client session under an additional tempdb, which had since been dropped, then, running the user proc referencing a derived table would result in Msg 209 State 3 'Ambiguous column name...' Workaround Description  Afer loading database, drop user proc and recreate it

CR:486879

CR Number:   486879 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2008 Fixed 16 Jan 2008 Fixed 22 Jan 2008 Fixed 26 Feb 2008 Fixed 17 Feb 2008 Fixed Description Support redundant cluster interconnects. Add MDA table monCIPCLinks to monitor link state

CR:486884

CR Number:   486884 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) 26 Dec 2007 Fixed 28 Dec 2007 Fixed Description A 216 error "Attempt to automatically drop temporary table failed." may be reported in the error log together with a stack trace which includes the modules "dropo" and "drop_with_retry" following error 3702 "Cannot drop the table '<n>' because it is currently in use." when a session tries to drop a temporary table while the system task HK CHORES is flushing statistics for the given table in systabstats. Workaround Description  Boot ASE with trace flag 3632 to "Turn off stats flushing performed by the chores housekeeper." when the error is due to task HK CHORES and/or disable configuration option "enable housekeeper GC" when the error is due to task HK GC.

CR:486888

CR Number:   486888 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2008 Fixed 30 Jul 2008 Fixed Description The Monitor Server can be slow in detecting ASE has shut down. This can lead to problems on restart. Workaround Description  To enable faster shutdown of the Monitor Server:- Reduce the "heartbeat_interval" value in the Monitor Server configuration file, e.g. 5 seconds. To force Monitor Server shutdown (Unix):- kill -9 monserver_spid ipcs -ma ( to find out the monserver memory segment id ) ipcrm -m id ( to release the memry segment used by monserver )

CR:486901

CR Number:   486901 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2008 Fixed Description Very rarely, for a cluster that has more than one instance, if "sp_who" is issued when a task on current instance is blocked by some task on one of the other instances, and the blocking instance has failed somehow during the process of "sp_who", the "sp_who" might hang.

CR:486917

CR Number:   486917 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) 23 Dec 2008 Fixed 05 Jan 2009 Reservation Made Description Error 325 (no plan found) might be raised for EXISTS subquery which also contains another correlated subquery.

CR:486918

CR Number:   486918 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2008 Fixed Description In an HA environment during failover, if a connected client is using encrypted passwords, the diagserver will shutdown due to an error condition during decryption which will cause an assertion to fire due to an invalid length.

CR:486959

CR Number:   486959 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2008 Added to user documentation Description System Administration Guide says inaccurate description about locking by dbcc checkdb command. dbcc checkdb command should lock one table at a time and release the lock after it finishes checking that table.

CR:486993

CR Number:   486993 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2008 Duplicate Description The message "current process infected with 11" in the module 'ResRelOp' may be reported in the error log in some rare circumstances.

CR:486994

CR Number:   486994 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2007 Fixed 13 Dec 2007 Fixed Description INSERT-SELECT statements involving outer joins on proxy columns may return wrong results. Workaround Description  Use T-SQL outer join (*=) or downgrade to ESD#2

CR:486996

CR Number:   486996 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) 07 Dec 2007 Fixed 07 Dec 2007 Fixed Description The 3474 error ""During redo the page timestamp value is less than old timestamp from log. Page #=0, object id = <object id>, page timestamp=<timestamp>. Log old timestamp=<timestamp>. Log record marker = <page number, row number>." may be reported for a page when it was previously allocated in case of large scale allocation but was not used.

CR:487045

CR Number:   487045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2008 Fixed 04 Feb 2008 Fixed Description The row number in a row could be incorrect after a deferred update.

CR:487071

CR Number:   487071 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) 20 Feb 2008 Fixed Description ASE is unable to allocate a network i/o buffer after a large number of cancelled migration requests.

CR:487153

CR Number:   487153 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2007 Fixed Description If sp_procxmode is run in chained mode outside a transaction it will leave a transaction opened when it completes.

CR:487161

CR Number:   487161 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2008 Fixed 31 Jan 2008 Fixed 01 Feb 2008 Fixed Description A SQL statement that contains a subquery, which in turn contains a DISTINCT aggregate such as SELECT ... (SELECT COUNT(DISTINCT col) FROM tab)... can lead to a segmentation fault in the function a_remapqblockvar. Workaround Description  Xun Cheng <chengx@sybase.com> wrote on 12/10/2007 12:04:05 PM: cmdline traceflag 15363 can probably be used as a workaround to avoid the relevant codepath. It is perfectly ok not to use that codepath.

CR:487170

CR Number:   487170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2008 Fixed Description The datachange counters for a NC global index on a partitioned table should be reset with update statistics.

CR:487186

CR Number:   487186 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) 07 Jan 2008 Fixed Description In rare circumstances when large IO's are used to access the table immediately after heavy BCP activities on Adaptive Server Enterprise 15.0.1 Cluster Edition, threads accessing the table can hang in lock acquisition.

CR:487192

CR Number:   487192 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) 22 Jul 2008 Duplicate Description In rare circumstances, a performance problem for some queries may be caused under the default as allrows_mix plan. Workaround Description  set plan optgoal allrows_oltp

CR:487193

CR Number:   487193 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2008 Fixed 03 Feb 2008 Fixed Description The online database operation does not activate the database on other nodes of the cluster. As a result future cache bind operations, requiring single user mode operation, may see 924 errors on other nodes.

CR:487205

CR Number:   487205 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) 09 Jan 2008 Fixed 21 Jan 2008 Added to user documentation 19 Feb 2008 Fixed Description For APL index operation in SDC, we no longer use blocking logical lock. After "deadlock retry" number exceeds, the query could fail and rollback. Both msg 2632 and 1205 will be issued.

CR:487236

CR Number:   487236 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2008 Fixed 30 Jan 2008 Fixed Description If a join query with a derived table including UNION ALL has an ORDER BY clause that includes a column not in the SELECT list, infected with 11 may occur in OptGlobal::GblSetInterestingTcIds(). Workaround Description  Add all columns in the ORDER BY clause to the SELECT list. Trace flag 4404 might be able to work on it.

CR:487261

CR Number:   487261 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2007 Fixed Description dbcc index_check command may return error 693 while perfroming the command. This error is because of existence of index pages in a different cache than it is bound to.

CR:487262

CR Number:   487262 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2008 Fixed Description In a shared disk cluster, a 2546 error, "Table Corrupt: Extent id <pageno1> on allocation <pageno2> has objid <objid>, indid <indid>, and used bit on, but reference bit off", may be reported by DBCC CHECKALLOC if a sort was active on an instance just prior to the node being shut down abnormally.

CR:487271

CR Number:   487271 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request for sp_dbcc_help_fault give other alternatives for 100011 errors than just Dropping/recreating the table/index or loading from clean backups. There are other alternative fixes for text pointer error 100011, such as running dbcc textalloc, sp_rebuild_text, or dbcc rebuild_text.

CR:487282

CR Number:   487282 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) 09 Jan 2008 Fixed 06 Feb 2008 Presently Not Targeted For Any Future Release Of This Product 13 Feb 2008 Fixed Description Loading data, using bcp, in parallel from 2 nodes might cause 4846 error on one node.

CR:487283

CR Number:   487283 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) 21 Jan 2008 Fixed Description A 10364 error, "Permission denied. You must either be the database/object owner or possess any of the following roles in order to perform this operation: 'sa_role, oper_role'" may be reported when a database owner who does not have sa_role executes load with listonly or headeronly command.

CR:487291

CR Number:   487291 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) 16 Jan 2008 Fixed Description While cursor scan with isolation level 3 on datapage table is open and fetching row at Instance 1. Attempt to insert row in middle of scan range on Instance 2 does not block. Target Version  15.1 ESD #1

CR:487293

CR Number:   487293 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) 14 Dec 2007 Fixed Description The message "current process ... infected with 11" may be reported in module 'dn_add_rdfl_runlist' during the execution of a DUMP DATABASE command or the DUMP command may hang, when non-logged operation, like reorg rebuild, is heavily executed on the remote node during the DUMP command. The modules 'dn_rdfl_add' and 'dn_rdfl_handler' would also be reported in the stack trace in the error log.

CR:487305

CR Number:   487305 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   NA Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2007 Fixed 19 Feb 2008 Fixed 23 May 2008 Fixed 21 Feb 2008 Fixed Description Previously ASE Plug-in could not be registered with Sybase Central 4.3 on Windows Vista. This has been fixed.

CR:487317

CR Number:   487317 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) 14 Dec 2007 Fixed Description Under some circumstance for a cluster that has more than one instance, when a cursor is created and fetched for updating data on one of the instances, if another cursor is created and fetched afterwards for selecting the same data on one of the other instances, the cursor fetch for selecting data might hang.

CR:487333

CR Number:   487333 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) 14 Jan 2008 Fixed Description Clients routed to logical clusters using the "round-robin" login distribution mode may be unable to connect if only a single instance is running.

CR:487347

CR Number:   487347 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2007 Fixed Description System procedure sp_bindcache erroneously allows for Data Only Locked Tables binding to a named cache of an index whose index id value is zero, resulting in overwriting the table's binding if any.

CR:487359

CR Number:   487359 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   SunOS Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2008 Fixed 07 Jan 2008 Not a Bug 14 Jan 2008 Fixed Description In rare circumstances, Adaptive Server may hang when changing mode of a system stored procedure which doesn't exist in the current database.

CR:487376

CR Number:   487376 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) 12 Mar 2008 Fixed Description Error 632 is raised when Kerberos logins request message confidentiality with network packet size greater than or equal to 16K.

CR:487407

CR Number:   487407 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2007 Fixed Description The error 924, "Database 'dbname' is already open and can only have one user at a time.dn_spawn_rdfl_handler(): failed to activate dump flush list event handler!, will be raised when trying to dump a database that is in single user mode.

CR:487416

CR Number:   487416 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) 20 Feb 2008 Fixed Description An empty transaction that is rolled back incorrectly results in log records being logged.

CR:487420

CR Number:   487420 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) 14 Jan 2008 Bundled Request Description On the Solaris platform, sp_cluster logical may erroneously encounter errors 16434 or 16436.

CR:487424

CR Number:   487424 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) 21 Dec 2007 Fixed 24 Mar 2008 Fixed Description when there is a join predicate between mismatched datatype with no retrograde cast provided for, then wrong results and/or assertion failure may happen Workaround Description  1) Don't use a clustered index on smallint/tinyint columns. Use a nonclustered index instead. 2) explicitly convert the column to an int.

CR:487431

CR Number:   487431 Product Name:   SySAM Product Component:   FLEXlm Status:   Closed OS:   Linux Original Version:   10.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2010 Not a Bug Description SYSAM: pick up hostid from other hwaddr besides eth0

CR:487433

CR Number:   487433 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) 14 Jan 2008 Fixed Description In rare circumstances for clusters with three or more instances, it may be possible for multiple administrative tools to concurrently reconfigure the cluster, overwritting each others changes.

CR:487440

CR Number:   487440 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2007 Fixed 15 Jan 2008 Fixed Description ASE on linux may hit a SIG11 during startup if the 'number of engines at startup' is configured more than the 'max online engines'. Workaround Description  Make sure that 'number of engines at startup' is not more than the 'max online engines' at startup.