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

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

CR:609534

CR Number:   609534 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2010 Fixed 29 Jan 2010 Fixed Description xp_cmdshell creates defunct processes when using "no_wait".

CR:609543

CR Number:   609543 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2010 Fixed Description A complex query using CIS tables and OR predicates may stack trace with a SEGV in Pop::popIsCollocated(). Workaround Description  1) set compatibility_mode on (the customer has confirmed it is a valid workaround) or 2)set alternative_greedy_search off (tested via simulate mode inhouse and have asked the customer to try this one) or 3) Server level: Boot time race flag -T15363 may be used for server level for 15.0.2 ESD release and up.

CR:609692

CR Number:   609692 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2010 Fixed 02 Apr 2010 Insufficient priority to fix 09 Dec 2014 Port Not Needed 09 Dec 2014 Fixed 07 Dec 2014 Fixed 07 Dec 2014 Fixed Description When dumping and loading databases containing functional indexes between specific platforms, dropping indexes on the new server can fail with a syntax error message. Workaround Description  Create an identical copy of the table and indexes. Compare the sysindexes.keys1 field for function-based index for the original table (with problem) and new table; there should be a 1-bit difference between them: Example: old: 0x0000ffff0003002700000004ffff0100000000000000002d0000000600010000 new: 0x0000ffff0003002700000004ffff0001000000000000002d0000000600010000 ^ ^ If so, update the keys1 field of the row for the original table with the value from the new table. Then run dbcc cacheremove(dbid, original_table_id) Drop index should now work. [bret 21 May 2012]

CR:609819

CR Number:   609819 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2010 Fixed 21 Jan 2010 Fixed 09 Feb 2010 Fixed Description ASE may disable the LDAP URL for a locked or disabled login, if the LDAP server returns error code 53-'Server is unwilling to perform'. ASE treats error code 53 as fatal error and the URL is marked as FAILED. ASE should handle error code 53 without disabling the LDAP URL.

CR:609832

CR Number:   609832 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2009 Fixed 10 Dec 2009 Fixed 09 Dec 2009 Fixed 26 Mar 2014 Fixed 31 Mar 2014 One-off Provided Description A 3478 error, During undo the page timestamp value is less than new timestamp from log. Page #=<num>, object id = <id>, page timestamp=<value1>. Log new timestamp=<value2>. Log record marker = (<num>, <rowid>). may be reported in the error log together with a stack trace which includes the modules xact_rollback and rec_undo_session when SAP ASE rolls back a transaction and while the housekeeper garbage collection task is working on the same Page# unexpectedly.

CR:609894

CR Number:   609894 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2014 Presently Not Targeted For Any Future Release Of This Product Description Implementation to an updateon image column uses less space of log

CR:609895

CR Number:   609895 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2010 Consult Complete Description Wrong result set for date/time style parameters (117 & 118) for convert function

CR:609943

CR Number:   609943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Signal 11 may be seen in the errorlog wih a lasterror of 9504 in function ind__itagsetup() and the spid terminated when fetching a cursor after an update at isolation level 0. The cursor would need to be sensitive (likely to involve a hashing operator) Workaround Description  dbcc traceon (457) --to force insensitive materialized cursors -or declare the cursor as insensitive e.g. declare <cursor_name> insensitive cursor for ...

CR:609946

CR Number:   609946 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2010 Workaround 17 Jan 2010 Presently Not Targeted For Any Future Release Of This Product Description For SuSE Linux (32 bit) platform, ASE can not use more than 2GB shared memory. Workaround Description  For SLES 10 platfrom : 1. The vm.legacy_va_layout should be disabled or set to 0 Steps : 1. check the value : # /sbin/sysctl vm.legacy_va_layout 2. set shmmax # /sbin/sysctl -w vm.legacy_va_layout=0 # /sbin/sysctl -p 3. check again # /sbin/sysctl vm.legacy_va_layout check that vm.legacy_va_layout is set to 0 4. Add settings to init file ( /etc/init.d/boot.local ) Add the line below in file /etc/init.d/boot.local : /sbin/sysctl -w vm.legacy_va_layout=0 2. Users should set stack size to some limited value (say 8192 or 10240 ) to use flexible/compact process memory map laout. This can be set with 'ulimit -s 8192' in bash, sh or 'limit stacksize 8192' on csh, tcsh.

CR:609996

CR Number:   609996 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2010 Fixed 15 Dec 2009 Fixed Description In ASE SDC, the message "current process infected with 11" in the module may be displayed in the 'cm_check_if_noobject_bound_cache' cache deletion module. This may happen when the cache creation succeeds in one of the nodes and fails in others.

CR:610076

CR Number:   610076 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2010 Fixed 28 Jan 2010 Reservation Made Description Querying a proxy table may get a wrong result in rare circumstances when an exact same IN item list is present in different clauses of the query. Workaround Description  Alter the IN list of one of the CASE statements, i.e. add a dummy element to the list. OR Turn off quickpass, i.e. dbcc traceon(11216)

CR:610120

CR Number:   610120 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2011 Presently Not Targeted For Any Future Release Of This Product Description Under rare circumstances, it is possible for a distinct operator in the outer query to not be respected if the query contains nested sub-queries and two or more tables are joined along with one table also being involved in a left join to another reference of the same table. Workaround Description  set opportunistic_distinct_view off --or dbcc traceon (15330)

CR:610144

CR Number:   610144 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2010 Duplicate Description In rare circumstances, the signal 11 might occur when compilation optimization of LWP with distinct and outer joins.

CR:610150

CR Number:   610150 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2012 Added to user documentation Description The Ref Manual entry for sp_server_info attribute_info value 2 incorrectly indicates it is equivalent to @@version. The returned value is actually used to determine version compatibility for ODBC drivers and may reflect a much older version.

CR:610164

CR Number:   610164 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2009 Fixed 14 Dec 2009 Fixed Description The error 822, "Could not start I/O for request" could be sporadically be raised when ASE incorrectly tries to flush index pages to disk in an archive database, without having remapped them to the modified pages section.

CR:610310

CR Number:   610310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2009 Fixed Description softlink is added to load libkonavm.dylib in case it is missed on the DYLD_LIBRARY_PATH. ASE must be able to load this dylib to boot

CR:610496

CR Number:   610496 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Dec 2010 Fixed Description Signal 11 in function CgEvals::_CgCompVcol() may be seen in the error log and the spid terminated under rare circumstances involving a reformatted correlated subquery with group by\having clause which references a column in the outer query. Other entries in the stack would include CgpGroupHashing & CgpStoreInd Workaround Description  dbcc traceon (15370) --to avoid reformatting sub-query de-correlation. --or set compatibility_mode on

CR:610502

CR Number:   610502 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Windows Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2012 Added to user documentation Description doc bug: no doc on upgrading ASE 32-bit to 64-bit Windows

CR:610506

CR Number:   610506 Product Name:   Adaptive Server Enterprise Product Component:   QPtune Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2010 Fixed 15 Dec 2009 Not a Bug 15 Dec 2009 Presently Not Targeted For Any Future Release Of This Product Description QPTune "collect" may appear to hang when processing a large number of rows (eg. about 2M) in the catalog sysquerymetrics.

CR:610709

CR Number:   610709 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2009 Fixed 21 Dec 2009 Fixed Description Adaptive Server Enterprise Plugin for Sybase Central incorrectly shows that the password for a login is not expired while actually it is expired. Workaround Description  None known.

CR:610758

CR Number:   610758 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Open OS:   Linux Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Job Scheduler have the ability to automatically startup on a running node after failover.

CR:610763

CR Number:   610763 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2010 Fixed Description monOpenObjectActivity does not record stats for system table even if the traceflag 3650 is on.

CR:610851

CR Number:   610851 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Dec 2009 Fixed 21 Dec 2009 Fixed Description Performance for Batch insert is slow for SDC when using large pools for logs.

CR:610956

CR Number:   610956 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2011 Fixed 04 Jun 2012 One-off Provided 12 Oct 2011 Fixed 13 Dec 2011 Reservation Made 14 Dec 2011 Fixed 14 Dec 2011 Fixed 19 Dec 2011 Fixed 20 Dec 2011 Fixed 10 Jan 2012 Reservation Made 31 Jan 2012 Fixed 05 Nov 2012 Fixed Description ASE installations with large number of databases, with high number of engines and inter database transactions would result in high contention of dbt_spin.

CR:610987

CR Number:   610987 Product Name:   Adaptive Server Enterprise Product Component:   sqlloc Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2009 Not a Bug Description sqlloc: cannot select some charsets in gui after charset utility is run Workaround Description  use sp_configure "set id", to manually change the default.

CR:611007

CR Number:   611007 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2010 Added to user documentation Description doc bug: ddlgen hide passwd feature is wrong in two places. It is 'ext', not 'pwd', that is passed to the -P arg.

CR:611032

CR Number:   611032 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2010 Deferred Description Internal Only: This is a prototype to verify performance gains from compressing network packets.

CR:611067

CR Number:   611067 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2010 Fixed 20 Oct 2010 Fixed 02 Nov 2010 Fixed 04 Nov 2010 Fixed 09 Nov 2010 Fixed Description The spinlock monitor area should dynamically increase to accomodate spinlock pool growth.

CR:611152

CR Number:   611152 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2010 Fixed Description SET ROWCOUNT does not take effect for CIS quickpass UPDATE, DELETE and INSERT-SELECT queries which do not return a result set.

CR:611164

CR Number:   611164 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2010 Duplicate Description free accounting space on log breaks load sequence and causes error msg 4306 on offline database. Workaround Description  No workaround

CR:611370

CR Number:   611370 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2010 Fixed 06 Aug 2010 Duplicate Description In a Warm Standby environment it is now possible to replicate the new commands create/alter/drop login profile. Replication of login profiles is possible when the master database is configured for replication. However, when the version of the source ASE is newer than the version of the target ASE, replication of login profiles is not possible.

CR:611378

CR Number:   611378 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2010 Fixed 12 Apr 2010 Fixed 15 Apr 2010 Fixed Description Stacktrace with the invalid Column length msg when store_index is used in AP Workaround Description  use compatibility mode (if the query may be run in the compat mode) use store_index off

CR:611383

CR Number:   611383 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Conversion error 257 when traceflag 450 is enabled Workaround Description  set merge_join off

CR:611385

CR Number:   611385 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2009 Fixed 22 Dec 2009 Reservation Made Description improved "values scan" costing, which can occur for an "if exists", large "IN list". Previously defaults of 300 rows with 100 pages were used for costing. This behavior is enabled with the cr611385 optcriteria.

CR:611577

CR Number:   611577 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Signal 11 may be seen in function yyparse() and the spid terminated after having received an error 156 during attempted execution of invalid 'create procedure' statement contained within begin..end block. Workaround Description  Use valid syntax

CR:611637

CR Number:   611637 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2010 Fixed 04 Jun 2010 Presently Not Targeted For Any Future Release Of This Product 09 Feb 2010 Reservation Made Description if there are 2 or more != or IS NOT NULL predicates on the same column of the form tab.col != constant1 and tab.col != constant2 ... then there is a selectivity estimation error proportional to the number of NULL values in the column. Also, for the specific case of tab.col != NULL, the estimate w.r.t. the ANSINULL state was inverted, i.e. 0.0 if ANSINULL was off, and the number of NULL values if ANSINULL was on. Workaround Description  force the strategy using an abstract plan

CR:611689

CR Number:   611689 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2010 Fixed 10 May 2010 Fixed 05 Jun 2014 Consult Complete Description In some special case of scanning a dol table, the interested page/buffer brought into another cache could cause 871 error.

CR:611707

CR Number:   611707 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Dec 2009 Fixed Description ONLINE DATABASE command and Faiover Recovery are not synchronized in some cases. They may progress in parallel on a database; may result in corruption.

CR:611728

CR Number:   611728 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2010 Fixed 11 Jan 2010 Fixed Description Config value like 'SQL batch capture' which is set in config file might be reset to 'DEFAULT' after reboot.

CR:611797

CR Number:   611797 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2009 Duplicate Description JVM/PCI Future extensions (performance).

CR:611831

CR Number:   611831 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2010 Fixed Description When references are left in sysattributes for a login and replication attempts to add the same login and suid again, the attempt fails with error: "Fatal protocol error. xact_beginupdate() API was invoked in the wrong context..."

CR:611840

CR Number:   611840 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2010 Fixed 01 Feb 2010 Fixed 01 Feb 2010 Fixed Description Sybase Central prior to version 6.0.0.4753 does not support Windows 7.

CR:611851

CR Number:   611851 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2010 Insufficient priority to fix 11 Mar 2010 Fixed Description Integrated login mixed mode fails for local system account even if valid username/password is specified. Workaround Description  Boot with traceflag 7846 which will revert to the pre-CR 432700 behavior. Reference trusted_login.c.

CR:612251

CR Number:   612251 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Msg 7717 when running dbcc orphantables("drop"). Workaround Description  Make sure the temp database assign to your spid is the same as then one you going to run dbcc orphantables("drop") in.

CR:612264

CR Number:   612264 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2010 Fixed Description FORXML query fails to execute if it uses LIKE operator with local variables or parameters. Stack trace is produced indicating module opt_like_and.

CR:612286

CR Number:   612286 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2012 Presently Not Targeted For Any Future Release Of This Product Description Database and transaction log dumps that are taken on Adaptive Server 15.5 CE cannot be loaded into a database on Adaptive Server 15.5 (non-CE). In order to ensure disaster recovery then either load the dumps into a database on Adaptive Server 15.5 CE or use Replication Server or sybmigrate, the Sybase Migration tool.

CR:612287

CR Number:   612287 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.5 ESD #1 20 Sep 2010 Fixed 23 Sep 2010 Reservation Made Description High contention on ASE rdesmgr_spin spinlock may be seen with certain workload. This fix reduces contention on rdesmgr_spin in some scenarios on linuxamd64 and sun sparc64 platforms. It does not yield any benefit if des_bind is already used for all tables involved.

CR:612300

CR Number:   612300 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2010 Fixed 14 Jan 2010 One-off Provided Description User performing a DROP INDEX is blocked indefinitely by the HOUSEKEEPER CHORES process in what appears to be an undetected deadlock.

CR:612316

CR Number:   612316 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2010 Fixed 13 Aug 2010 Fixed 19 Aug 2010 Fixed Description signal 11 at CgLavaUtils::CgTargetListExprs could happen for DISTINCT view self join. Due to the self join, DISTINCT view has to be materialized using a Store operator. The DISTINCT view select list has a char type column which is equijoin'ed with another char type column. This would only happen when the optcriteria "opportunistic_distinct_view" is off (by default it is on) or the DISTINCT select list also has some expression. Workaround Description  dbcc traceon (15321) --or set cr500736 off --15.0.3 ESD#2 and higher

CR:612448

CR Number:   612448 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2010 Fixed 26 Mar 2010 Fixed Description For a query with an expression involving subquery and the expression is projected out and it is also used in local predicates, it could return wrong result sometimes.

CR:612449

CR Number:   612449 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2010 Fixed Description If a cursor is used to update a table which contains a TIMESTAMP column and this TIMESTAMP column is not in the cursor's SELECT list, ASE raises error msg 594 when updating other columns in the SELECT list. Workaround Description  None known.

CR:612451

CR Number:   612451 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2010 Fixed Description On hpia64 and hppa64 platforms, while unmirroring a device, the unmirroring task may hang and subsequently hanging other tasks in ASE. The unmirroring task cannot be killed and the ASE server needs to be restarted.

CR:612492

CR Number:   612492 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request - Enhance update index statistics for proxy tables to import histograms for non-leading columns of a composite index. Workaround Description  import statistics by hand using optdiag

CR:612498

CR Number:   612498 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2010 Duplicate Description If compatibility mode is enabled and an insert is performed requiring a large number of columns with a group by, a message 511 is issued saying that the logical page size limit of 1960 bytes (2K page size) is exceeded. If compatibility mode if off, everything is fine. Workaround Description  turn off compatibility mode

CR:612681

CR Number:   612681 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2010 One-off Provided 11 Jan 2010 Fixed 17 Mar 2010 Fixed Description Sometimes a task that hits error 892 can go into a loop, continuously raising the same error. This can result in server shutting down.

CR:612769

CR Number:   612769 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2010 Fixed 05 Jan 2010 Fixed Description The sybcluster do not check the instance names entered by the user and verify that they are valid values.

CR:613054

CR Number:   613054 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2010 Fixed 23 Feb 2010 Reservation Made Description When a NULL = NULL join is used on top a materialization step such as a vector aggregate or in an extended column aggregate, then there is a possibility of a wrong answer, when the join is pushed down into the materialization step. The NULL = NULL join is created when an explicit predicate such as r.a = s.a OR (r.a IS NULL and s.a IS NULL). The NULL = NULL join can be implicitly created in an extended column aggregate (a non ANSI sybase feature) such as select r.b, avg(r.c) from r group by r.a The NULL = NULL join semantics can be turned off, and instead normal join semantics could be used instead, resulting in a wrong answer. Workaround Description  rewrite the query into 2 queries, in which the first query materializes the result, and this is temp table is linked back into the original query

CR:613175

CR Number:   613175 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2010 Bundled Request Description In system with large number of locks/buffer cache configured sp_clusterlockusage takes very long time to finish.

CR:613221

CR Number:   613221 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2010 Fixed Description The sybcluster utility does not check the traceflag value entered by the user and verify that they are valid values.

CR:613305

CR Number:   613305 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2010 Fixed 29 Jan 2010 One-off Provided 26 Feb 2010 One-off Provided 25 Feb 2011 One-off Provided Description On Power6 architecture running AIX Operating System, alstat tool shows alignment exceptions when ASE is performing certain operations, for example floating point operations.

CR:613330

CR Number:   613330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2010 Fixed 02 Jun 2010 Fixed 02 Nov 2010 Fixed Description sp_setrepdbmode and sp_setrepdefmode with 'threshold' raise an error if you connect to the ASE with japanese language. Workaround Description  Login to your ASE by isql with -zus_english.

CR:613411

CR Number:   613411 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2010 Fixed Description Currently, using a pre-15.5 client to call current_bigdatetime() directly results in errors 247\3606:- Arithmetic overflow during implicit conversion of BIGDATETIME value ' Invalid pointer param number 3, pointer value 0x9cf500d408f1 This CR is to change the return value to be either current_date() or raise an error stating 'not supported' when a pre-15.5 client is detected. Workaround Description  Use 15.5 client

CR:613412

CR Number:   613412 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) 18 Apr 2010 Bundled Request Description sp_monitorconfig may report values of "Pct_act", "Num_free" incorrectly for 'number of locks'.

CR:613474

CR Number:   613474 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2010 Fixed 21 Mar 2010 Fixed 21 Mar 2010 Fixed Description The first time syconfig is used to create an ASE, the specification for tempdb size and device is ignored and tempdb is created only on the master device with the minimum size. Workaround Description  manually disk init a tempdb device and alter tempdb onto it after installing the server. Another workaround: In the syconfig dialog that prompts the temp db/device, click on the "tempdb device path" input textfield before click Continue button.

CR:613537

CR Number:   613537 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   Windows XP Original Version:   amboise Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2010 Fixed Description Customer modified the standard resource file (XML Schema Model language ) "xsd.xsl" by adding customized Property tab page (e.g. for Element in XSM). With the new tab page, some buttons do not work as expected, producing empty windows or no response at all. E.g. it is discovered that those buttons of "reference object" and "type object" on it are fail to browse and only get an empty list. While the default General tab has no problem.

CR:613548

CR Number:   613548 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   amboise Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2010 Fixed Description Customer modified the standard resource file (XML Schema Model language ) "xsd.xsl" by adding customized Property tab page (e.g. for Element in XSM). With the new tab page, some buttons do not work as expected, producing empty windows or no response at all. With the customized property tab page, there seems no way to add Data Source and data mapping with the source.

CR:613585

CR Number:   613585 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2010 Fixed 22 Jun 2010 One-off Provided Description Distinct queries that contain a non-correlated subquery in the select list may raise a 530 error (NULL can't be inserted in worktable) if the query uses a distinct_hashing strategy and the non-correlated subquery returns a NULL. Workaround Description  1. Upgrader their ASE to 15.0.3 ESD2, and use "compatibility mode" to avoid this issuse. And must set parameter "abstract plan dump" to 0 2, Use abstract plan, and use distinct_sorting instead of distinct_hashing 3. Use TCF 7721. This flag will modify all AOPONCE nodes (the non-correlated select-list subquery in your case) to be nullable. This will eliminate the 530 error your customer is seeing. However, it also has the side-effect of modifying fixed length types (char, unichar, binary) to be variable length (truncating blanks and 0's as they go through the worktable).

CR:613631

CR Number:   613631 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2010 Fixed Description In some situations, computed column could get wrong result from an identity column.

CR:613659

CR Number:   613659 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2010 Fixed 18 Jan 2010 Fixed Description When auditing the grant/revoke commands the full command text will be written to position 2 of the extrainfo section of the audit record if available. Otherwise the Grantee and Command Type will be written.

CR:613678

CR Number:   613678 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2010 Fixed 08 Feb 2010 Fixed 05 Apr 2010 Fixed 07 Apr 2010 Fixed 13 May 2010 Fixed Description When an SSO drops a login, which is a user in a database having status 'dbo use only', sp_droplogin gives error 923 and 208.

CR:613737

CR Number:   613737 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2010 Fixed Description When 'disk init' is executed simultaneously from multiple connection may lead to creation of devices with same vdev number. Workaround Description  Creating devices presently should be done serially. So when creating multiple devices simultaneously, the user must ensure that if one device is under creation then the other disk init command should be executed only after the first is completed.

CR:613750

CR Number:   613750 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: Make dbcc checkstorage not to report the default excluded faults (ie. 100035, 100037 and 100040) and also other faults which are defined by sp_dbcc_exclusions.

CR:613758

CR Number:   613758 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2010 Duplicate 08 Jan 2010 Duplicate Description query with order by and rtrim return wrong result. Workaround Description  1)// you are on 15.0.3 ESD 1 set compatibility_mode on go 2) dbcc traceon(450) go Trace 450 has limitted support; it is not designed to handle all cases to provide the same ordering as 12.5. For fuller support, please advise either: turn off trace 450, and add an order by clause as required by standard SQL; or use compatibility mode.

CR:613782

CR Number:   613782 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2014 Presently Not Targeted For Any Future Release Of This Product Description Under certain circumstances, an ASE server installed on a Linux PAE kernel may not be able to start a second engine Workaround Description  N/A

CR:613786

CR Number:   613786 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2010 Fixed Description If the size of an in-memory device is not an integer multiple of the size of an allocation unit, creation of in-memory database on such a device may hang.

CR:613808

CR Number:   613808 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2010 One-off Provided 14 Mar 2010 Fixed 19 Jan 2010 Fixed 07 Feb 2010 One-off Provided 29 Aug 2012 Fixed Description system procedure 'sp_volchanged' may fail, if the dump operation happens to be on remote backup server.

CR:614211

CR Number:   614211 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sub-optimal query plan for Distinct with subquery that include Max() in allrows oltp compare to compatibility mode. Workaround Description  compatibility mode

CR:614236

CR Number:   614236 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2010 Added to user documentation Description Some MDA tables are populated with data, even when 'enable monitoring' is set to 0. This needs to be stated in the docs.

CR:614411

CR Number:   614411 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2010 Fixed Description When runing PCClient autorun.exe on FDCC Vista and select "Install PC Client Components", the installer can not be started and show error "Windows error 216 occured while load JVM".

CR:614424

CR Number:   614424 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2010 Fixed 20 Apr 2010 Fixed Description optdiag simulate is broken in 15.5 GA releaase for SMP installations. The following error is generated: optdiag simulate statistics qts_db -Usa -P -T1 OptDiag/15.5/EBF XXXXX SMP/B/x86_64/Enterprise Linux/asearies/2431/64-bit/OPT/Mon Jan 11 00:38:22 2010 ... Server Message: - Msg 207, Level 16, State 4: Invalid column name 'instanceid'. Internal error: ct_results() returned result type CS_CMD_FAIL. Optdiag failed. Check for error messages above.

CR:614461

CR Number:   614461 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2010 Fixed 19 Jan 2010 Reservation Made Description There is a costing adjustment for rid joins that reduces the estimate of in-order rows if a general OR optimization is used or if the non-covered index scan is not clustered. The in-order row estimate is used to help reduce physical IO estimates when good cache hits occur.

CR:614567

CR Number:   614567 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2010 Fixed 01 Apr 2010 Reservation Made Description Extend internal diagnostics to trace recompilation of stored procedures. Workaround Description  N/A

CR:614637

CR Number:   614637 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2010 Fixed Description Server hits 806 error when inserting a row into an APL table with non-clustered index, the row being fetched from a cursor that involves the same table again. This situation is only likely to occur when index split happens due to the insertion of data row.

CR:614757

CR Number:   614757 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description capability 102 uses value 4 by default and doesn't specify what value 4 is for in the dcany.cap.Cause error Msg 30291 with ASE15 onwards Workaround Description  No workaround

CR:614823

CR Number:   614823 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2010 Fixed 29 Apr 2010 Fixed 11 Mar 2010 One-off Provided Description Duplicate key values could be generated for identity column during checkpoint or a node shutdown and rejoining the cluster. For tables with unique indexes on identity column, it would give error 2601 'Attempt to insert duplicate key row in object <obj_name> with unique index <index_name>' Workaround Description  No Workaround Possible

CR:614854

CR Number:   614854 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2010 Fixed Description Executing of sp_encryption to add a system encryption password or using the built-in password_random will cause a SIGSEGV resulting in a stack trace in ASE 15.5 if the /dev/random, /dev/urandom, and /dev/srandom do not exist.

CR:614952

CR Number:   614952 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2010 Fixed Description The message "Infected with 11" maybe be found in the errorlog together with modules like "LeOperator*LopScanValues::_lopCodeGen" for queries involving only derived tables and a redundant distinct operator. Workaround Description  Use traceflag 499 to disable streamlining

CR:614957

CR Number:   614957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2010 Fixed 28 Jan 2010 Fixed Description Sybase CE in VCS-mode fail to change sortorder.

CR:614959

CR Number:   614959 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2010 Fixed 22 Jan 2010 Reservation Made 09 Mar 2010 One-off Provided Description Incorrect number of rows (more rows) may be inserted when inserting or selecting into a table from a DISTINCT view or derived table on some outerjoin inner table column, provided there is an extra WHERE clause on the outerjoin inner table column before the INSERT. The extra rows are due to not including the WHERE clause in the final plan. Workaround Description  set compatibility_mode on

CR:614982

CR Number:   614982 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances, the message "Infected with 11" together with modules like "Pop<ParallelCost, ParallelProps>::popCheapestDegree()" can appear in the errorlog for queries involving round robin partitioning, or CIS queries. Workaround Description  Disable parallelism either server wide, or for specific query (set parallel_query off).

CR:615025

CR Number:   615025 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin-Adaptive Server Enterprise Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2010 Added to user documentation Description Changing the charset or sort order while running ASE in VCS membership mode may result in the sybase VCS service faulting. Workaround Description  To change the charset or sort order under VCS, ASE must first be in normal membership mode because after restarting the server, it will automatically shutdown after reconfiguring which would cause the sybase VCS service to fault. This should be done with only one instance running. If ASE is running in VCS membership mode, first shutdown ASE using VCS commands and change the membership mode to normal. > qrmutil -Q<quorum> --membership-mode='' Restart a single ASE instance manually or via sybcluster and run charset to change the charset. > $SYBASE/ASE-15_0/bin/charset -Usa -P nocase.srt utf8 Change the sort order using sp_configure > isql -Usa -P 1> sp_configure 'default sortorder id', 101, 'utf8' Shutdown the cluster 1> shutdown cluster Restart an instance. ASE will reconfigure the sort order and automatically shutdown. The membership mode should be changed back to VCS mode, then the cluster can be restarted using VCS commands. > qrmutil -Q<quorum> --membership-mode='vcs'

CR:615029

CR Number:   615029 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.5 ESD #1 15 Jan 2010 Added to user documentation Description Adjusting user connection limits under VCS results error 15550. Workaround Description  Changing the Linux user sybase to a higher number of file descriptors using ulimit -n 8194 does not resolve the Error 15550 issue even after restarting the Sybase cluster. The ulimit command only changes the user limits for the current session while a new session would revert to using the default 1024 file descriptors. Under VCS Veritas is managing the Sybase cluster, and when bringing up the Sybase instances online, performs login to Linux as new sybase users, which would use the default 1024 number of file descriptors resulting in the issue. To ensure that all sybase user sessions have the correct file descriptor limit, add the following lines to /etc/security/limits.conf: sybase hard nofile 8096 sybase soft nofile 8096

CR:615110

CR Number:   615110 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2010 Fixed 07 Jun 2010 Fixed Description If a client is old version which can not understand a DATE data type, ASE in compatibility mode may raise a 247 error (Arithmetic overflow during implicit conversion of DATE value to a DATETIME field) on a row containing NULL in a nullable DATE column. Workaround Description  (1) Upgrade your client version to at least 12.5.1 (which can recognize DATE data type). (2) Turn off compatibility mode. (3) Change a DATE column to a DATETIME column if possible. (4) Add a dummy varbinary column after the nullable DATE column and insert 0x00000000 into it.

CR:615210

CR Number:   615210 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2010 Fixed 26 Jan 2010 Fixed Description During bootup or when using sp_configure, ASE may indicate that verification of a configuration failed because "The sum, (number of user connections) + (number of devices * max online engines) + (number of remote sites) + (max number network listeners) + (max cis remote connections) + (number of java sockets), must be no greater than '<value>'", where the 'value' at the end is not correct. Workaround Description  N/A

CR:615223

CR Number:   615223 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) 26 Jan 2010 Not a Bug Description DBCC SERVERLIMITS incorrectly reports the limit on number of user tables in a single statement to be 512. The limit is actually 50.

CR:615382

CR Number:   615382 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2010 Fixed 29 Jan 2010 Fixed 02 Jul 2010 Presently Not Targeted For Any Future Release Of This Product 25 Jun 2010 Fixed 28 Jun 2010 Fixed 27 Jun 2010 Fixed Description ddlgen generate syntax error on create table command. Workaround Description  update the ddlgen output.

CR:615852

CR Number:   615852 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) 26 Jan 2010 Fixed Description DBCC CHECKTABLE may report invalid very large values for the empty pages and pages which could be garbage collected counters. The correct value is in the lower 32 bits of the reported value.

CR:615880

CR Number:   615880 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2014 Presently Not Targeted For Any Future Release Of This Product Description 2 queries in 1 batch is slower than 2 queries in 2 batches. Workaround Description  Place queries that populate temp tables in a batch prior to queries that reference them OR place the queries that reference that temp tables in an execute immediate statement.

CR:615890

CR Number:   615890 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2012 Added to user documentation Description (HP Only) Switching off the 'pca_jvm_netio' property to disable network I/O for RMI sockets in the PCA/JVM, through either the execution of stored procedure sp_jreconfig "disable", "pca_jvm_netio" or manually does not prevent RMI socket operations from working despite the property being set to disabled. Consequently a Java RMI client will continue to be able to connect to a remote RMI server to execute some functionality over the network, although it should not. To avoid this problem remove the unused RMI class(es) from the database. The pca_jvm_netio argument is enabled by default. Workaround Description  (HP Only) Remove the unused RMI class from the database.

CR:615911

CR Number:   615911 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin-Adaptive Server Enterprise Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2010 Fixed Description Release Bulletin contains inaccurate information about Replication Server.