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

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

CR:487450

CR Number:   487450 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2008 Fixed Description This change will affect the row estimate of operators that perform distinct (duplicate removal) operation.

CR:487452

CR Number:   487452 Product Name:   Adaptive Server Enterprise Product Component:   sqlloc Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2008 Fixed Description sp_helpdevice runs slow after changing sortorder using sqlloc. Workaround Description  run update index statistics spt_values table

CR:487472

CR Number:   487472 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) 01 Apr 2008 Fixed Description sp_helptext fails in displaying procedures with group number greater than 32767. The fix here restricts the upperlimit of procedure group number to 32767 ( the max value of 'smallint')

CR:487481

CR Number:   487481 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) 22 Jan 2008 Fixed 23 Jan 2008 Fixed 03 Jun 2008 Not a Bug Description After an operation like an unbind followed by a bindcache, or a drop of an object, buffers are left around in the old cache. subsequent requests for physical locks from another cache raise an 891 error if the buffer in the old cache is found to be dirty.

CR:487513

CR Number:   487513 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2007 Fixed 18 Dec 2007 Fixed Description A timeslice error "timeslice -501, current process infected" may be reported in the error log together with a stack trace which includes the modules "dmap_merge_diskmaps" and "db__sysaltusages_map", when the DBCC CHECKSTORAGE command is run on an archive database.

CR:487530

CR Number:   487530 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) 15 Oct 2008 Fixed 15 Oct 2008 Reservation Made 16 Oct 2008 Fixed 30 Oct 2008 Fixed Description Under some circumstances, failover recovery may run into a deadlock situation if it involves the undo of a nested top action.

CR:487534

CR Number:   487534 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) 10 Jan 2008 Fixed 21 Jan 2008 Fixed Description A query with subquery sometimes could return wrong results for parallel execution.

CR:487559

CR Number:   487559 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) 01 Jul 2008 Fixed 01 Jul 2008 Reservation Made 05 Mar 2009 Fixed 16 Mar 2010 Not a Bug Description A new configuration parameter 'ltl batch size' has been added to Replication Agent. This parameter determines the number of bytes that Replication Agent can send to Replication Server before the EOM (End Of Message) status is required. Its default and minimum value are 16384.

CR:487572

CR Number:   487572 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 Feb 2008 Fixed 26 Feb 2008 Fixed 28 Feb 2008 Fixed Description HA aware clients do not receive updated failover addresses due to cluster or workload manager reconfiguration.

CR:487592

CR Number:   487592 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) 20 Nov 2009 EOL'd version. Not to be Fixed. Description sp_default_charset returns 3 rows instead of one in some cases.

CR:487651

CR Number:   487651 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) 20 Dec 2007 Fixed Description A segmentation violation followed by stack trace that contains the module cfg_syscacheinfo will be raised when executing the stored procedure sp_configure if at boot time one of the options is not present in sysconfigures causing error 5864, 'Invalid option encountered '.

CR:487682

CR Number:   487682 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2010 Duplicate Description Feature request for combined insert/update merge command that would, in one pass, insert records that didn't match an existing primary key and update rows that did match the primary key.

CR:487716

CR Number:   487716 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) 04 Jan 2008 Fixed Description If max instances is greater than the highest defined instance, error messages should not be printed in the error log during boot.

CR:487722

CR Number:   487722 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) 04 Jan 2008 Fixed Description sp_help reports Error 247 arithmetic overflow for big tables.

CR:487730

CR Number:   487730 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) 02 Jan 2008 Fixed Description Under allrows_dss optgoal (where advanced_aggregation is on), aggregate query might hit div-by-zero execution error or return wrong result when there is an equijoin under the aggregate and the join column has an equality sarg on it (such as t1.c1=t2.c2 and t2.c2=5).

CR:487744

CR Number:   487744 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) 17 Jan 2008 Fixed 17 Jan 2008 Reservation Made 22 Jan 2008 Fixed Description Error 414 with a message "The current query would generate a key size of nnn for a work table. This exceeds the maximum allowable limit of xxx." may appear if the query has 6 or more joining tables and GROUP BY clause. Workaround Description  Increase page size until error 414 disappears. Or use trace flag 15363.

CR:487800

CR Number:   487800 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed Description Incorrect variable values could be used on full pass-through proxy table queries to direct connect gateways. Workaround Description  Disable deferred compilation of stored procedures using command line trace flag -T7735. This disables deferred compilation for proxy statements only.

CR:487839

CR Number:   487839 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) 21 Dec 2007 Fixed Description If a view definition contains at least one OR predicate and a query is executed that references a column of that view in a predicate in a CASE or NULLIF expression and that same view-column is referenced in at least one additional predicate, a segmentation fault can occur during excution in the function, CgEvals::copyEvalsToVirCol. Workaround Description  Use trace flag 455 to disable the fix for CR 481601.

CR:487843

CR Number:   487843 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2008 Workaround 15 Jan 2008 Workaround 19 Mar 2008 Fixed 13 Mar 2008 Reservation Made 25 Mar 2008 Fixed 03 Feb 2011 Fixed Description Objects created by user with sa_role carries the user's login name in sysobjects.loginame. This will cause the login name to remain in sysobjects even after the login is dropped. Workaround Description  Before a generic tool available (probably in ASE16) to enable users to transfer concrete ownership of objects, the system administrator needs to update sysobjects.loginame manually when the loginame is dropped and it still appears in sysobjects.loginame. objects created by user with sa_role ------------------ update sysobjects set loginame = NULL where uid = 1 and loginame = "loginame" objects created by a user as guest ----------------- update sysobjects set loginame = "new_owner" where uid = 2 and loginame = "loginame" objects created by an alias user (may be detected by sp_dropalias) ----------------- update sysobjects set loginame = "new_owner" where uid = "alias_uid" and loginame = "loginame" new_owner can be user_name(alias_uid) or an user who have an alias relation with alias_uid.

CR:487846

CR Number:   487846 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) 04 Jan 2008 Fixed 14 Jan 2008 Fixed 08 Jan 2008 One-off Provided Description Frequent redefinition of the view may result in its tree size growth in sysprocedures. Workaround Description  drop and re-create the view

CR:487859

CR Number:   487859 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) 20 Dec 2007 Bundled Request Description In some cases, a query that contains nested CASE or NULLIF expressions in a join predicate, such as: WHERE nullif(nullif(4, case d2.d2a when 4 then d2.d2a else 4 end), v1a.v1b) = v1a.v1a and also has the column being joined to (v1a.v1a in this example) under at least one additional OR predicate, a segmentation fault (SIGSEGV) can occur during execution within the function, LeRun(). Workaround Description  Use trace flag 455 to turn off the fix for CR 481601.

CR:487860

CR Number:   487860 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2008 Fixed 12 Aug 2008 Added to user documentation Description Due to a high default value (2000) for the configuration parameter 'runnable process search count', Adaptive Server Enterprise with light load, may consume more system time on machines with limited resources and running alongside other processes besides the server.

CR:487883

CR Number:   487883 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 Presently Not Targeted For Any Future Release Of This Product 18 Jan 2008 Fixed Description Under rare cicrcumstances, fail node recovery may raise a 3324 error reading "Internal error occurred while attempting to perform post-commit cleanup".

CR:487937

CR Number:   487937 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) 26 Dec 2007 Fixed Description During unpartition operation, a row in sysstatistics with inaccurate data is being left behind.

CR:487963

CR Number:   487963 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2008 Fixed 09 Jan 2008 Added to user documentation Description doc bug: without unit specifier -2k pages, not MB for disk init size

CR:487966

CR Number:   487966 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2008 One-off Provided Description ASE 15.0.2 GA, ESD#1, ESD#2 on Linux Redhat 5 cannot online any additional engine apart from Engine 0. Errorlog shows these kernel messages > engine 1, os pid nnnn exited; Process nnnn exited with status 1; Task with kpid 0 running on failed engine; online failed. Server startup console shows these additionally > os_attach_region: shmat(xxxxxx): Invalid argument; kbattach: couldn't attach to Kernel region; kestartup: couldn't attach to shared memory. Workaround Description  According to Dave Putz: " If you set the ulimit stack size to 'unlimited' before starting ASE, [RHO: then], the second (and subsequent) engines start correctly; and are able to attach to the shared memory. The Linux command to do this is "set -s unlimited". "

CR:487967

CR Number:   487967 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) 21 Jan 2008 Fixed 07 Apr 2010 Insufficient priority to fix Description sp_droplogin is not cleaning the tempdb bindings associated with the login.

CR:487979

CR Number:   487979 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2008 Fixed Description The message "Invalid column length: xx. Value must be between 0 and xx for 'all-pages' row with minimum row length of xxx." together with a stack trace which includes the modules 'collocate', 'makeindrow' and 'sobld_presortindbuild' may be reported in the error log during CREATE CLUSTERED INDEX WITH SORTED_DATA on an APL table in a database that has been loaded from a dump of a platform with different byte order. Workaround Description  Assuming that old data on first empty page is bytes swapped: - bcp data out - drop table and recreate - bcp data back in. OR - Create the clustered index without the sorted_data option.

CR:487993

CR Number:   487993 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed Description Fixed "symbol lookup error for libibmc++.so.1", which is caused by upgrading libibmc++.so from 1.5 to 1.6.

CR:488059

CR Number:   488059 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 04 Jan 2008 Reservation Made 11 Mar 2008 One-off Provided Description A query like below may get error 102 (Incorrect syntax near 'BETWEEN@@@V0_VCHAR1'.) if statement cache and literal auto parameterization are enabled. Example: SELECT b2 FROM t1 WHERE a1 BETWEEN'xxxx' AND 'xxxx' There is no blank between a SQL keyword and a literal value surrounded by single/double quote marks. Workaround Description  (1) Add a blank into between a SQL keyword and a literal value manually. (2) set literal_autoparam off (3) set statement_cache off (4) dbcc purgesqlcache (to clean up a wrong parameterized statement after this error occurs) (5) Trace flag 7722 (if it is acceptable to parameterize and cache only insert statements)

CR:488062

CR Number:   488062 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 Description sp_helptext shows irrelevant output for the showsql options 'ddlgen' and 'context' in case of partition condition objects and also gives repeated linenumbers in partition condition.

CR:488066

CR Number:   488066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed Description 'Invalid column length' error, 8402 error or other similar error is returned, or the message "current process ... infected with 11" may be reported in module 'lddb__unscr_log' when database is loaded from 11.9.3 version of ASE across platform where the byte order (endian type) is different.

CR:488085

CR Number:   488085 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   Windows XP Original Version:   tyresias Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for multiple XML / XSD files to be reversed engineered

CR:488131

CR Number:   488131 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 : Change sp_getmessage to no longer exclude messages < 17000

CR:488132

CR Number:   488132 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) 22 Jan 2008 Fixed Description When an UPDATE query updates a text, image or unitext column by selecting new values for the column from another table and the first new value is a NULL, a segmentation fault can occur. The resulting stack trace will contain the function, inserttext. If the query is executed by the diagserver, an assertion will preceed the segmentation fault: Assertion ((s_sdes->sdesp)) failed in file /remote/heartland_nbld2/ase1502/sunsparc32/porttree/svr/sql/generic/source/manager/text.c line 2268 Workaround Description  First Method: ============= Disable parallelism Second Method: ============== CREATE TABLE test1 ( a int not null primary key, b text NULL, ) go insert into test1 (a, b) values (1, null) go CREATE TABLE test2 ( a int not null primary key, b text NULL, ) go insert into test2 (a, b) values (1, null) go -- If this line is added, then it does not fail. It seems the initial insert -- does not allocate a text chain, but this update does. The stack -- trace only seems to result when there is no text chain. update test2 set b = null update test2 set b = adrm.b from test2 rdrm inner join test1 adrm on rdrm.a = adrm.a Third method: ============= CREATE TABLE test1 ( a int not null primary key, b text NULL, ) go insert into test1 (a, b) values (1, null) go CREATE TABLE test2 ( a int not null primary key, b text NULL, ) go insert into test2 (a, b) values (1, null) go exec sp_chgattribute test1, 'dealloc_first_txtpg', 1 exec sp_chgattribute test2, 'dealloc_first_txtpg', 1 update test2 set b = adrm.b from test2 rdrm inner join test1 adrm on rdrm.a = adrm.a

CR:488193

CR Number:   488193 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2008 Fixed 05 Mar 2008 Fixed Description If the index is suspect(because created with different sort order, or due to any other reason.), update index statistical information would get stack trace. fix is simple, skip this index if we found the index is suspect.

CR:488217

CR Number:   488217 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) 13 Feb 2008 Fixed 18 Feb 2008 Fixed 19 Feb 2008 Fixed 26 Mar 2008 One-off Provided Description Under rare circumstances, for a query involving the >= or < predicate on a large table, if the search argument constant value falls exactly on the boundary of a histogram range cell and if this is the last cell of the histogram, then a histogam processing adjustment that converts the predicate to > or <=, might result in an underestimated selectivity for the predicate.

CR:488238

CR Number:   488238 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) 15.0.2 ESD#2 09 Jan 2008 Duplicate Description Under certain circumstances an update statement on a large table with a non-clustered index can update the wrong number of rows, when the rows to be updated are restricted with an in or or clause and the non-clustered index is used to access the data. Workaround Description  Use an abstract plan to force the query to perform a table scan rather than rely on a non-clustered index.

CR:488239

CR Number:   488239 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2008 Fixed 07 Jan 2008 Reservation Made Description A SELECT-INTO query that contains a UNION or UNION ALL operation and also contains an identity function can give inconsistent and unexpected results because of ambiguity in the handling of the identity column on each side of the UNION. These kinds of queries are no longer allowed in ASE. A new error message, 16306, will be raised when such a query is parsed. An example of such a query is: 1> select a=id*10000, n=identity(2) into #t from sysobjects where id < 6 2> union all 3> select 999, 999 Msg 16306, Level 15, State 1: Line 2: You cannot use an identity function in a SELECT INTO statement with the UNION operation.

CR:488266

CR Number:   488266 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) 03 Jan 2008 Fixed Description Sybmon commands to print a structure in memory and dbcc bytes command to print a structure in memory may not find the printing function associated with the structure. The list of the commands associated with the structures is: TMPOBJ CSS JOINDATA J_FILTER SARG SARG_ONDISK COST RRANGE PLIMIT E_CACHEPROT ST_TABLE ST_IND ST_PTN ST_SYSTABSTATS ST_ALLCOLUMNS ST_COLSTAT_LIST ST_COLSTAT ST_COLINFO SYB_COLDESC_ARRAY SYBCOLDESC EXECTXT Target Version  15.1 ESD #1

CR:488298

CR Number:   488298 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) 23 Jan 2008 Fixed Description An 'ALTER TABLE <tabname> PARTITION' command that creates a large number of partitions (the exact number of partition is platform dependent, but in the repro for this CR, 300 partitions were created on Solaris64) can cause a stack overflow error. Workaround Description  Use sp_configure to increase the stack size.

CR:488310

CR Number:   488310 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) 28 Jan 2008 Fixed Description Undetected physical lock deadlock during an APL index scan.

CR:488314

CR Number:   488314 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) 08 May 2008 Deferred 08 May 2008 Fixed 08 May 2008 Reservation Made Description We see ocm locks both with indid=0 and indid=1. One set of the locks carry stale information and might result in propagating wrong values like ptnroot, ptnrow etc.

CR:488339

CR Number:   488339 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2008 Fixed Description For query with varchar/varbinary column and there are a lot of histogram steps on the column, the compilation could hit the Assertion ((*ppFreeBase >= *ppBoundary + ElementSize) || (*ppFreeBase + *pFreeSize <= *ppBoundary)) failure under diagserver. Under non-diagserver, it might lead to memory corruption and signal 11 stacktrace in the optimizer statistics handling code area.

CR:488343

CR Number:   488343 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) 19 Feb 2008 Fixed 04 Feb 2008 Reservation Made 15 Feb 2008 Added to user documentation Description monSysLoad enhancements: provided Sample and Peak values, decomposed cpu busy, disk i/os and network i/os. Add @@user_busy, @@system_busy T-SQL global variables.

CR:488372

CR Number:   488372 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) 13 Feb 2008 Fixed 15 Feb 2008 Fixed 19 Feb 2008 Fixed 05 Jan 2009 Fixed 08 Jan 2009 Fixed Description In rare circumstances, Adaptive Server may give a time slice error with a stack trace which contains the function 'cm__check_page_range' or 'cm_choose_buffer_pool'.

CR:488399

CR Number:   488399 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) 26 Feb 2008 Fixed Description It is not possible for a new node to join the cluster whilst the primary interconnect network is down.

CR:488413

CR Number:   488413 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 Jan 2008 Fixed 21 Jan 2008 Fixed Description Wrong result could happen for query referencing a DISTINCT view and the DISTINCT is on column(s) with unique index (in other words, the usage of DISTINCT in the view is redundant).

CR:488432

CR Number:   488432 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) 25 Jan 2008 Fixed 25 Jan 2008 Fixed Description "select into" or "insert...select" on a timestamp column may appear to update the source table with the new value from the destination table.

CR:488436

CR Number:   488436 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2008 Fixed 02 Apr 2008 Fixed Description Backup server may display configured shared memory per stripe value incorrectly. The message with wrong value will be as follows (in this example, 0 indicates wrong value. It could be other value): "Backup Server: 1.70.1.2: Configuring the shared memory per stripe to 0 bytes."

CR:488469

CR Number:   488469 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) 26 Aug 2008 Fixed 24 Sep 2008 Added to user documentation 19 Nov 2008 Duplicate 06 Sep 2008 Fixed 14 Oct 2008 Fixed Description Added new columns to MDA tables monOpenObjectActivity and monOpenPartitionActivity to track per oject statistics.

CR:488479

CR Number:   488479 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) 19 Apr 2008 Fixed 27 Jul 2008 Duplicate 15 Jan 2009 One-off Provided Description In rare circumstances, the message, "Stack guardword corrupted", might be printed in the errorlog when executing at higher nesting levels.

CR:488553

CR Number:   488553 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2008 Fixed Description With server wide traceflag 217 enabled or 'set fipsflagger on', if a alias of column is used in the query, it could display the Non-ANSI warning message which is not non-ANSI.

CR:488567

CR Number:   488567 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 Apr 2008 Fixed Description If a query has an outer join and the inner table has a COUNT aggregate as one of the projected columns then we might get error 530 "Attempt to insert NULL value into column 0 in work table (table id -1); column does not allow NULLS. UPDATE fails." Workaround Description  set plan optgoal allrows_oltp or:- set group_sorted 0 or:- set merge_join 0

CR:488581

CR Number:   488581 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2008 Fixed Description With a query having predicate like (COND1) OR (COND1 AND COND2) where COND2 contains a subquery then a stacktrace may be hit along with a server crash. The stacktrace contains the function name '_IcsAccumulatePeId' in it.

CR:488583

CR Number:   488583 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) 11 Apr 2011 Presently Not Targeted For Any Future Release Of This Product Description Improvements to correlated subquery costing to report more accurate estimates of PIO/LIO for multiple executions of a subquery, (via set statistcs plancost diagnostics). Previously, only one execution of a subquery was costed, and the total cost was multiplied by the number of times a subquery was expected to be executed. The new approach is to initially cost 100 executions of a correlated subquery, and subsequent cost the subquery plan, at the attachment point, with the correct number of executions, which will not change the subquery plan, but will affect the cost reported, including taking advantage of any buffer manager optimization that can be gleamed by multiple executions of a subquery. Also, the reformat strategy will be chosen in cases similar to 12.5, which assumes 100 executions of a subquery in order to decide whether reformatting is appropriate. Workaround Description  Potential workarounds for subqueries not using reformatting include creation of an index to be used for the subquery, or use of an AP to specify the plan.

CR:488585

CR Number:   488585 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2008 Fixed 22 Jan 2008 Fixed Description 15.0.2 ESD#2 syconfig.exe and sybatch.exe crash during startup.

CR:488602

CR Number:   488602 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 Jun 2009 Presently Not Targeted For Any Future Release Of This Product 16 Aug 2011 Fixed Description Enable memusage and enhance who command in sybmon

CR:488615

CR Number:   488615 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) 27 Mar 2008 Not a Bug Description 15.0.2 ASE Plug-in for Sybase Central allows deleting a column even if the table's database has option 'select into' set as false. (In such case, ASE Plug-in temporarily turns on the option in order to delete the column.) Workaround Description  don't use sybase central to drop columns.

CR:488656

CR Number:   488656 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) 25 Mar 2008 Fixed 28 Jan 2008 Insufficient priority to fix Description "sa" user name and authentication mechansim are missing in audit record. A user who is authenticated with LDAP server will get "username/NONE" in audit record instead of "username/LDAP" for LDAP state change auditing event.

CR:488662

CR Number:   488662 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 Jan 2008 Fixed 22 Jan 2008 Fixed 30 Apr 2010 One-off Provided Description In cases where the server is starved for tempdb pages, a SEGV may be generated in LeStoreOp::_LeOpClose(). This will only occur if the session is recovering from an 1105 error while trying to initially create the work table. Note, that this session typically will not be holding very much tempdb space. Analysis should still be done to determine why there is no tempdb space available. Workaround Description  This is NOT a workaround for 488662. Rather, the 488662 problem is preceeded by an 1105 condition. That is, some tempdb has been exhausted. Note that it is probably NOT the session that SEGVs that has consumed all of the tempdb space. It's defintitely not the creation of the work table that is doing this. The user's system should be analyzed to determine why their tempdb space is exhausted. If it's a rogue query plan, then an AP may be used to cut back the tempdb space required. Alternatively, the system could be reconfigured to have more tempdb space or the resource govenor used to ensure that no "rogue" queries consume all of the tempdb space. It would seem that a system with no tempdb space would be pretty ineffective anyway?

CR:488684

CR Number:   488684 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) 13 Feb 2008 Fixed Description Manual group failover requires all instances to be offline before failover occurs.

CR:488695

CR Number:   488695 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) 12 Feb 2008 Fixed Description When running simultaneous DDL/DML operations on multiple instances, ASE Cluster Edition servers may hang.

CR:488732

CR Number:   488732 Product Name:   Adaptive Server Generic Docs Product Component:   Commands Reference Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2008 Fixed 19 May 2008 Added to user documentation Description Permissions for sp_recompile should be "Only the Database Owner or a System Administrator can use the setuser command to assume another database users identity to recompile objects owned by other users. All users can execute sp_recompile to recompile their own objects."

CR:488762

CR Number:   488762 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) 11 Mar 2008 Fixed Description Wrong results could be returned under some circumstances when executing a query using "advanced_aggregation" and having equality or non-equalitiy WHERE clauses involving columns which store NULL values. Workaround Description  Run the query with advanced_aggregation disabled, or run under allrows_mix or allrows_oltp.

CR:488778

CR Number:   488778 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2008 Fixed Description Previously the Discovery Settings button on Create Cluster Wizard would bring up the General page of the settings dialog. Now it brings up Server Discovery page.

CR:488839

CR Number:   488839 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) 14 Jan 2008 Fixed 14 Jan 2008 Fixed Description 1502 ESD #1 and 1502 ESD #2 versions of Adaptive Server fail to run site handler RPCs on servers of category direct_connect.

CR:488854

CR Number:   488854 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) 05 Feb 2008 Fixed 08 Feb 2008 Fixed Description Upon failure of coordinator instance, an internal attempt to start the job scheduler on the new coordinator instance encounters a stack trace.

CR:488865

CR Number:   488865 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) 26 Jun 2013 Insufficient priority to fix 26 Jun 2013 Insufficient priority to fix 26 Jun 2013 Insufficient priority to fix Description Deferred Compilation should work with batch SQL. Workaround Description  Use concatenated version of Execute Immediate. Example: declare @ld_start varchar(12) declare @ld_end varchar(12) select @ld_start='05/05/2007' select @ld_end='06/05/2007' execute (" SELECT Date= dt_trade, Cusip=cusip, Symbol=p.symbol, Shares =s.short_shares, SMV = s.smkt_value, Stk_price =s.smkt_value/s.short_shares FROM tcfu_ssrs_part s,tpdbx_equity_products p WHERE p.cusip_number=s.cusip AND dt_trade BETWEEN '" + @ld_start + "' AND '" + @ld_end + "' AND fbsi_branch ='CQX' AND fbsi_account IN ('070000','070019') AND account_type= '1' ")

CR:488881

CR Number:   488881 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) 15 Jan 2008 Fixed Description Error 279 is not raised when UNITEXT is used in expression subqueries.

CR:488886

CR Number:   488886 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 In rare circumstances, Adaptive Server may hang as a result of an undetected deadlock between a process that is doing a DUMP DATABASE and a recovery process that is doing node failover recovery.

CR:488892

CR Number:   488892 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) 24 Jan 2008 Fixed Description RPC requests may fail on concurrent login sessions after the login password is changed using sp_password.

CR:488936

CR Number:   488936 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2008 Fixed 21 Jan 2008 Fixed 21 Jan 2008 Fixed 21 Jan 2008 Fixed Description syconfig.exe/sybatch.exe failed to copy server entry from interfaces file in server upgrade. Workaround Description  Run with a other OCS version you do this if you move sybatch from %SYBASE%\ASE-15_0\bin.

CR:488960

CR Number:   488960 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) 06 Feb 2008 Fixed Description The message "process infected with signal 11" may be reported in the error log together with a stack trace which includes the modules 'pgd_findusedextents' and 'd_usedextents' when DBCC USEDEXTENTS command has been previously run against an archive database.

CR:488962

CR Number:   488962 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) 16 Apr 2008 Fixed Description Syntax error is reported while binding a remote instance local tempdb to default data cache.

CR:488963

CR Number:   488963 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) 26 May 2008 Fixed 14 Jul 2008 Fixed Description Error 19776 is raised while binding local system tempdb to default data cache. It should be printed as a informational message and not user error.

CR:489040

CR Number:   489040 Product Name:   Adaptive Server Enterprise Product Component:   Language Modules Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2008 Fixed Description Request to change a japanese message of Msg ID #17714 in server.loc.

CR:489087

CR Number:   489087 Product Name:   Adaptive Server Generic Docs Product Component:   New Functionality in ASE 12.5.x Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2008 Added to user documentation Description Imported data from remote server supports non-indexed column statistics.

CR:489088

CR Number:   489088 Product Name:   ASE Generic docs Product Component:   Adaptive Server New Features Guide Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2008 Added to user documentation Description Imported data from remote server supports non-indexed column statistics.

CR:489101

CR Number:   489101 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 a stored procedure to display objects associated with a remote server.

CR:489102

CR Number:   489102 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) 17 Jan 2008 Fixed Description When sp_changedbowner is invoked in a local system temporary databases, msg 17361: "Can't change the owner of the master, model, tempdb or sybsystemprocs database." is printed which doesn't include local system temporary databases.

CR:489137

CR Number:   489137 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) 23 Jan 2008 Fixed Description In rare situations a client connection may hang after migration. In this case the client will be waiting for results from ASE, but ASE will be expecting a query from the client and sp_who will show that ASE is awaiting command.

CR:489145

CR Number:   489145 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 25 Apr 2008 One-off Provided Description Possible stack trace in CgpGenerate(), when a query has an outer join between a derived table and a regular table.

CR:489150

CR Number:   489150 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) 22 Feb 2008 Fixed Description Instances added or removed via sybcluster are synchronized with the sp_cluster stored procedure.

CR:489186

CR Number:   489186 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) 30 Jan 2008 Fixed 12 Feb 2008 Fixed 12 Feb 2008 Fixed 11 Feb 2008 Fixed Description In rare circumstances, a 692 error is reported for syslogs when a database is loaded using a database dump that was taken on a platform where the byte order(endian type) is different.

CR:489194

CR Number:   489194 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) 06 Feb 2008 Fixed 13 Feb 2008 Fixed Description The built-in asehostname() can be executed by anyone when only users with SA role should be able to.

CR:489213

CR Number:   489213 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) 05 Feb 2008 Fixed Description In rare circumstances, task executing "create index" may deadlock on system tables, with other tasks executing DDLs and utility command on the same database.

CR:489227

CR Number:   489227 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 Please include the text pointer value and column name in error messages from DBCC TEXTALLOC to allow location of the offending row.

CR:489247

CR Number:   489247 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) 28 Jan 2008 Fixed 29 Jan 2008 Fixed Description For large join (>= 7 joining tables) with nested subquery, occasionally stacktrace with sig11 (in CgpPop::cgpInit()) could happen. Workaround Description  The best workaround is to use the traceflag 15363 to disable alternative greedy algorithm. Another workaround is to set the session option set nl_join 0 before running the query.

CR:489251

CR Number:   489251 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2008 Fixed Description An UPDATE query that changes a LOB (TEXT, IMAGE or UNITEXT) column of the target table and gets the new values of the LOB column from a UNION ALL query (either a derived table or a union all view) that has a literal LOB on one side of the UNION ALL and a LOB column on the other side of the UNION ALL can change the target LOB column to garbage values instead of null when the source LOB column is NULL.

CR:489252

CR Number:   489252 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 Jan 2008 Fixed 21 Jan 2008 Fixed Description alter table against a proxy table is not checking for errors from the remote server

CR:489253

CR Number:   489253 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2008 Fixed 11 Feb 2008 Fixed Description Console logging will be disabled if setting console to nonblocking fails. This is available when commandline traceflag 4084 is set. Workaround Description  Any one of these three can be used as a workaround. o Always send stdout and stderr to /dev/null in the RUN_server file (add > /dev/null 2>&1 to the end of the RUN_server file) o If you sudo or su to another user before starting ASE, open another terminal session after the sudo or su, so that the console starting ASE is owned by the same user. o Change the permission of the terminal before doing sudo or su % chmod 777 `tty`

CR:489273

CR Number:   489273 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2008 Fixed 30 Jul 2008 Fixed Description Job Scheduler stored procedure sjob_control enable / disable fails on cursor execution.

CR:489274

CR Number:   489274 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) 23 Jan 2008 Fixed Description Error message 5824 is seen when change the charset/sort order to cp437 in SDC.

CR:489340

CR Number:   489340 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) 30 Nov 2009 Presently Not Targeted For Any Future Release Of This Product 23 May 2013 Insufficient priority to fix Description An insert of the results of an aggregate function (min, max, etc.) on a timestamp column into a binary null column gets the current timestamp value rather than the appropriate value from the source table.

CR:489341

CR Number:   489341 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 Feb 2008 Fixed Description DBCC checkalloc/tablealloc may report 12909, 7949, 7940, 2540 or 2546 errors after node failover recovery has been performed while a 'REORG REBUILD' command for an index was active on the failing node.

CR:489342

CR Number:   489342 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) 15.0.3 ESD#1 13 Oct 2008 Fixed Description In Warm Standby configurations where DDL is replicated, Replication Server fails to apply a DDL command due to a login failure when an external authentication mechanism is used to connect to ASE. Workaround Description  A workaround can be achieved by following the steps below. 1) The ASE passwords of both the primary and the standby ASE need to be kept in sync with the LDAP passwords. 2) The standby ASE needs to be setup for a failover to ASE authentication.

CR:489369

CR Number:   489369 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) 01 Feb 2008 Fixed 01 Feb 2008 Fixed 22 Mar 2010 One-off Provided Description Signal 11 in com__exctnume_copy when "select into" an identity column and there are no rows in the source table.

CR:489374

CR Number:   489374 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) 30 Jan 2008 Duplicate Description In rare circumstances, cache delete operation may fail with messages in errorlog instead of raising error.

CR:489402

CR Number:   489402 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2008 Fixed 01 Jul 2008 Fixed Description Job Scheduler stored procedure, sp_sjobcontrol, may fail with invalid cursor name Workaround Description  Alter installjsdb script to correct the sp_sjobcontrol call.