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

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

CR:620587

CR Number:   620587 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2010 Fixed 02 Jun 2010 Fixed Description A 2583 error, "Number of data pages (<n>) counted by DBCC differs from count in the data OAM (<n2>) for dbid <db> object .." may be reported by dbcc checkdb when a dump from a previous ASE version is loaded when a table is bound to a named cache.

CR:620626

CR Number:   620626 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jul 2010 Fixed 13 Jul 2010 Fixed Description In SDC, nodes may run out of physical locks when configured with disparate cache sizes.

CR:620628

CR Number:   620628 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2010 Fixed 24 Nov 2011 Fixed Description EN templates should be displayed when no other templates are available for JS in the language the client machine is using. Workaround Description  The workaround is to install the templates for the language which the client machine is using. This way, there will be templates displayed for creating a new job in Job Scheduler. If you have working JS installation just change your PCs language settings to Finnish or French and try to create a new job with templates..... Or change column jstemp_language in js_templates table to fi and use your default language settings in PC. how I got this to work. I installed 2 sets of templates, one with english and one with finnish. From Sybase Central - js_template jtmpl_id,jtmpl_type,jtmpl_name,jtmpl_description,jtmpl_owner,jtmpl_created,jtmpl_version,jtmpl_group_path,jtmpl_update,jtmpl_language 1,0,'Sybase Backup Database to Disk Template','Dumps specified database(s).','jstask',2010-02-24 10:03:56.976,'3.1','Backups',0,'en' 2,0,'Sybase Backup Transaction Log to Disk Template','Dumps transaction log of the specified database(s).','jstask',2010-02-24 10:03:57.986,'3.1','Backups',0,'en' 3,0,'Sybase Delete Statistics Template','Deletes table or column statistics.','jstask',2010-02-24 10:03:58.806,'3.0','Statistics Management',0,'en' 4,0,'Sybase Rebuild Indexes Template','Runs reorg rebuild command on index(es).','jstask',2010-02-24 10:03:59.616,'3.1','Reorganization',0,'en' 5,0,'Sybase Rebuild Tables Template','Run reorg rebuild command on table(s).','jstask',2010-02-24 10:04:00.41,'3.0','Reorganization',0,'en' 6,0,'Sybase Reclaim Index Space Template','Runs reorg reclaim space command on index(es).','jstask',2010-02-24 10:04:01.24,'3.1','Reorganization',0,'en' 7,0,'Sybase Reclaim Table Space Template','Runs the reorg reclaim space command on table(s).','jstask',2010-02-24 10:04:02.036,'3.0','Reorganization',0,'en' 8,0,'Sybase Reconfigure Locks Template','Resets "Number of Locks" if warranted.','jstask',2010-02-24 10:04:02.85,'2.0','Reconfiguration',0,'en' 9,0,'Sybase Reconfigure Metadata Cache Template','Reconfigures the metadata cache allocated.','jstask',2010-02-24 10:04:03.7,'2.0','Reconfiguration',0,'en' 10,0,'Sybase Reconfigure User Connections Template','Reconfigures the "Number of User Connections" if warranted.','jstask',2010-02-24 10:04:04.52,'2.2','Reconfiguration',0,'en' 11,0,'Sybase Update Statistics Template','Updates table or column statistics.','jstask',2010-02-24 10:04:05.43,'3.0','Statistics Management',0,'en' 12,0,'Sybase Server Update Statistics Template','Updates table or index statistics for all\x0auser databases where criteria are met.','jstask',2010-02-24 10:04:06.25,'3.0','Statistics Management',0,'en' 13,0,'Sybase Backup Database to Disk Template','Dumps specified database(s).','jstask',2010-02-24 11:23:49.673,'3.1','Backups',0,'fi' 14,0,'Sybase Backup Transaction Log to Disk Template','Dumps transaction log of the specified database(s).','jstask',2010-02-24 11:23:50.533,'3.1','Backups',0,'fi' 15,0,'Sybase Delete Statistics Template','Deletes table or column statistics.','jstask',2010-02-24 11:23:51.373,'3.0','Statistics Management',0,'fi' 16,0,'Sybase Rebuild Indexes Template','Runs reorg rebuild command on index(es).','jstask',2010-02-24 11:23:52.186,'3.1','Reorganization',0,'fi' 17,0,'Sybase Rebuild Tables Template','Run reorg rebuild command on table(s).','jstask',2010-02-24 11:23:52.99,'3.0','Reorganization',0,'fi' 18,0,'Sybase Reclaim Index Space Template','Runs reorg reclaim space command on index(es).','jstask',2010-02-24 11:23:53.81,'3.1','Reorganization',0,'fi' 19,0,'Sybase Reclaim Table Space Template','Runs the reorg reclaim space command on table(s).','jstask',2010-02-24 11:23:54.616,'3.0','Reorganization',0,'fi' 20,0,'Sybase Reconfigure Locks Template','Resets "Number of Locks" if warranted.','jstask',2010-02-24 11:23:55.416,'2.0','Reconfiguration',0,'fi' 21,0,'Sybase Reconfigure Metadata Cache Template','Reconfigures the metadata cache allocated.','jstask',2010-02-24 11:23:56.223,'2.0','Reconfiguration',0,'fi' 22,0,'Sybase Reconfigure User Connections Template','Reconfigures the "Number of User Connections" if warranted.','jstask',2010-02-24 11:23:57.086,'2.2','Reconfiguration',0,'fi' 23,0,'Sybase Update Statistics Template','Updates table or column statistics.','jstask',2010-02-24 11:23:57.966,'3.0','Statistics Management',0,'fi' 24,0,'Sybase Server Update Statistics Template','Updates table or index statistics for all\x0auser databases where criteria are met.','jstask',2010-02-24 11:23:58.806,'3.0','Statistics Management',0,'fi'

CR:620662

CR Number:   620662 Product Name:   Adaptive Server Generic Docs Product Component:   Web Services Users Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2012 Added to user documentation Description Feature request to more clearly document the cardinality relationships between ASE and Web Services engines. As a consumer, ASE can make requests from any WS defined in sysservers, but as a producer WS can only make requests from the single ASE defined in its properties file.

CR:620677

CR Number:   620677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2010 Fixed Description Procedure sp_spaceusage raises error 247 when run on a table that has more than MAXINT rows.

CR:620769

CR Number:   620769 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2010 Fixed 16 Aug 2011 Workaround Description On a Windows 64bit Adaptive Server, a LAST CHANCE EXCEPTION HANDLER on OS thread id caused by an attempted read from an invalid memory address either during LDAP user authentication or with switch 3635 turned on.

CR:620787

CR Number:   620787 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2012 Bundled Request Description DBISQL will return conversion error when select current_bigdatetime from unixASE

CR:620806

CR Number:   620806 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2011 Fixed Description For INSERT SELECT queries with an ORDER BY clause, the ORDER BY clause may be ignored if the table being inserted into has referential integrity checks.

CR:620992

CR Number:   620992 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2010 Fixed 02 Apr 2010 Presently Not Targeted For Any Future Release Of This Product Description Under very specific circumstances, delete involving with merge join and using direct update mode an error msg 644 could occur and the delete will fail. Workaround Description  dbcc traceon (463) --disable CR 548000, will revert to deferred update --or set merge_join off --or force the other join order

CR:620994

CR Number:   620994 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2010 Fixed Description In Cluster edition, Object creation in local temporary databases is slow when there are multiple objects created parallelly in local temporary databases.

CR:621129

CR Number:   621129 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2010 Fixed 19 Mar 2010 Fixed 08 Apr 2010 One-off Provided Description A deadlock may be encountered between a task waiting to get the PLC lock and another task trying to latch on a buffer on Sysobjects when a create table is being done on a database marked for replication. Workaround Description  customer cannot work around this issue

CR:621138

CR Number:   621138 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2010 Fixed 03 May 2010 Reservation Made 17 May 2010 Fixed 04 May 2010 Fixed Description Under certain circumstances, a stored procedure that references a view can raise error 11060 if the objects are created on a 15.0.3 ESD#2 server and that server is subsequently upgraded to 15.0.3 ESD #3 Workaround Description  The possible workarounds are: - Drop and re-create views that appear to cause this error when queried. OR - Use traceflag -T15316 OR - Run dbcc upgrade_object('dbname','view name', 'force') for the affected view so it is recreated from text and "old" versions are removed from procedure cache OR - Run dbcc markprocs() for the database containing the view and ensure no old TREEs for the view are in procedure cache by rebooting the server or removing them explicitly via dbcc proc_cacherm('V','dbname', 'view name')

CR:621148

CR Number:   621148 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description system function and / or system sproc that gives actives roles for all spids an administrative function and / or sproc to be able to display the info returned by ... show_role() sp_activeroles ... this gives both show_role() and user_defined roles ...for spids other than the current administrator spid. In other words ... let's say there are 3 active users in the server...spids 12, 17, and 21 The administrator is logged in with isql and has spid ... 17. OK right now this administrator is only able to get show_role() to return the active roles for spid 17. What the customer wants is to show the active roles for spids 12 and 21 also.

CR:621156

CR Number:   621156 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2010 Fixed Description Reference to unknown procedure sp_fragmentation in the definition of sp_index_space_est.

CR:621167

CR Number:   621167 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2010 Duplicate Description OLDSYBASE is not a valid SYBASE path.

CR:621276

CR Number:   621276 Product Name:   Adaptive Server Enterprise Product Component:   sybinstall Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2010 Fixed 26 Apr 2010 Fixed Description sp_sysmon reports Error 969/14/4 against local user tempdbs Workaround Description  Use changed code to check for status3 & 256.

CR:621323

CR Number:   621323 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2010 Fixed Description Some messages in dataserver logs related to failover need clarification or changes to make the actions of the server clearer.

CR:621326

CR Number:   621326 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) 15 Mar 2010 Fixed 03 May 2010 Fixed 04 May 2010 Fixed Description INSERT, DELETE or UPDATE commands executed with minimal logging together with the chained transaction mode may fail with a timeslice error being reported in the errorlog showing the module xls_test_set_lrdata and dbts_commits_addxdes.

CR:621333

CR Number:   621333 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2010 Fixed 29 Mar 2010 Fixed Description On sunx64 platform, signal context output in sybmon is incorrect.

CR:621445

CR Number:   621445 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2010 Duplicate Description sp_modifylogin delete minimum password length when this value is not default

CR:621449

CR Number:   621449 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Win32s Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2010 Fixed 28 Mar 2010 Fixed Description Enhance Active Messaging to support empty string message properties. Workaround Description  Use single space character instead of empty string values.

CR:621466

CR Number:   621466 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description update index statistics tablename partition_name does not update the nonclustered indexes on the partition Workaround Description  use update index statistics

CR:621493

CR Number:   621493 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   AIX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2010 Fixed Description "Sample" command in sybmon show incomplete stack info on AIX platform

CR:621615

CR Number:   621615 Product Name:   SCC Web Framework Product Component:   Other Status:   Closed OS:   Generic Original Version:   3.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2010 Fixed Description Sybase Controll Center to have option to configure the sender address.

CR:621750

CR Number:   621750 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2010 Fixed 01 Apr 2010 Fixed Description In complex nested views on the inner table of an outer join, in which at least 2 nested views have string expressions or constant expressions, then there is a transformation to allow merging of the views. If the predicate is such that the outer join degenerates into an inner join, the resulting strength reduction assumed the previous transformation would only occur once, when in fact it could be nested and occur twice. The end result is a partially dengenerated outer join that results in an inconsistent state that results in a signal 11.

CR:621762

CR Number:   621762 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2010 Fixed 26 Mar 2010 Fixed Description Under some rare situations, if a table has expressions as computed columns and the expressions reference different data types, it could return wrong results.

CR:621817

CR Number:   621817 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2010 Fixed 25 Mar 2010 Presently Not Targeted For Any Future Release Of This Product Description With the configuration option 'net password encryption reqd' set to 1, the JSagent fails with "ct_connect() failed", "jsd_MakeConnection() failed", "jsj_AddConxs() failed", "jsj_AddConxs() failed" and "Initialization failed initializing connection pool" messages in jsagent log file.

CR:621863

CR Number:   621863 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2011 Fixed 08 Aug 2011 One-off Provided 26 Jul 2011 Reservation Made 29 Apr 2013 Fixed 21 Jan 2014 Port Not Needed Description When a DISTINCT view (or derived table) is queried in a parent DISTINCT query or is part of an EXISTS join (e.g. under IN/Any subquery), signal 11 stacktrace could happen in CgpPop::_CgpPePredBmToScalar() for distinct operator (CgpDistinctHashing/CgpDistinctSorting/CgpDistinctSorted) when the following three conditions are all true: 1. The DISTINCT view/derived table has at least one expression SELECT column; 2. The parent SELECT DISTINCT columns are only a subset of the DISTINCT view columns. Or if the EXISTS join is on one of the DISTINCT view columns; 3. One of DISTINCT view columns which is not part of 2) has a predicate on it in the parent query block. Workaround Description  set opportunistic_distinct_view off (only applicable to the customer repros which are not hitting the bug using the EXISTS subquery. The RQG version can't use the workaround).

CR:621978

CR Number:   621978 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) 12 Mar 2010 Fixed 26 Apr 2010 One-off Provided 26 Apr 2010 One-off Provided Description In rare circumstances, a 707 error with state 10 "System error detected during attempt to free memory at address 0x<address>. Please consult the ASE error log for more details." may be reported for an ASE that uses a procedure cache whose size combined with the size of the statement cache exceed the value of 4G-bytes. Workaround Description  Reduce the size of procedure cache and statement cache, so the sum is less than 4 Gb. If dynamically increasing the caches, increment in less than 4GB at a time.

CR:621996

CR Number:   621996 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description stacktrace starts with CgEvals::_CgCompVcol when plan use hash join. Workaround Description  set advanced_aggregation off Note that this problem should be specific to the allrows_dss optgoal.

CR:622001

CR Number:   622001 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2010 Fixed Description Traceflag 3710 enables an enhancement to improve the performance of DROP INDEX and CREATE INDEX by releasing the system catalog locks when not in DDL-IN-TRAN mode after the commit of the transaction but before post commit work started. This CR is a feature request to make this default behavior and retire the traceflag.

CR:622066

CR Number:   622066 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) 27 Apr 2010 Not a Bug Description Upgrade from ASE1503CE to ASE15.5CE will show in-memory stats for user objects are showing 0 rows/pages unless reboot Workaround Description  Reboot the cluster

CR:622088

CR Number:   622088 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 Nov 2010 Fixed 07 Nov 2011 Fixed Description monOpenObjectActivity.RowsInserted is wrongly updated even when the INSERT command gets aborted.

CR:622090

CR Number:   622090 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2010 Fixed Description ASEPlugin attempts to access local tempdb for another node than the one the user logs into.

CR:622114

CR Number:   622114 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2010 Fixed 23 Mar 2010 Reservation Made 30 Mar 2010 Fixed Description In some situation, if compatibility mode is on, computed column is not getting the correct values from an identity column.

CR:622123

CR Number:   622123 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) 25 Mar 2010 Fixed 20 Jul 2010 Fixed Description In rare cases, the recovery of a prepared multi-database transaction that started in the master database and that had a transaction branch on a remote Adaptive Server, might result in an inconsistent completion state between the branches of the transaction.

CR:622150

CR Number:   622150 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2010 Fixed 09 Apr 2010 Fixed Description A statement may fail to compile in deferred mode (and will successfully compile in normal mode) when it references a view and there is another view of the same name under the user executing the procedure. With 'set showplan on', you will see:- QUERY PLAN IS RECOMPILED DUE TO DEFERRED_COMPILE_FAIL, TABMISSING. THE RECOMPILED QUERY PLAN IS: Workaround Description  Turn off deferred compilation. sp_configure 'procedure deferred compilation', 0 --(for 15.0.3 ESD#1 and higher) --or Traceflag 7730

CR:622151

CR Number:   622151 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2010 Fixed 12 Apr 2010 Fixed Description An additional line of client-side output with respect to 'rows affected' may be seen in circumstances where the procedure has been recompiled due to a deferred compilation failure. For example:- 1> exec p1 2> go (1 row affected) c1 ----------- (0 rows affected) (return status = 0) 1> Instead of:- 1> exec p1 2> go c1 ----------- (0 rows affected) (return status = 0) 1> Workaround Description  set nocount on <preceding queries to the failed DC statement> set nocount off

CR:622339

CR Number:   622339 Product Name:   ASE Management Product Component:   Web Console Status:   Closed OS:   Windows XP Pro Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2010 Fixed 28 Jun 2010 Fixed Description In ASEMAP 3.1, on both SMP and SDC screens for ASE monitoring, if user switches database selection in the database table while the bottom tabs are in their default order, the 'Selected database:' will show the correct name of the database. However, if user is on another tab (not the Details tab) and switches the database selection, the 'Selected database:' does not get updated. This issue is fixed in ASEMAP 3.2.1.

CR:622350

CR Number:   622350 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2010 Fixed 19 Mar 2010 Fixed 24 Mar 2010 Fixed Description The execution of a stored procedure that in turn calls a cross database udf may result in permission error 10351 if the caller of the stored procedure is not the owner of the udf. Workaround Description  Add the owner of UDF and the sproc to database via sp_adduser

CR:622415

CR Number:   622415 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 Oct 2010 Fixed Description If a table has a trigger defined and 'statement cache' and 'literal autoparam' are enabled, it could cause a problem if a error is detected when processing the trigger.

CR:622433

CR Number:   622433 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 Apr 2010 Bundled Request Description Stored proc sp_jdbc_getxacoordinator is not cluster aware (returns Error 512)

CR:622492

CR Number:   622492 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When a procedure is created containing a 'select *' from a table which joins a derived table, the expanded derived table columns may be placed within the derived table definition as oppose to the outer query. This could lead to an error 107 when re-creating the procedure from the text stored in syscomments

CR:622499

CR Number:   622499 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) 22 Oct 2010 Fixed 22 Oct 2010 Fixed Description Deadlock IDs not correctly inserted into monDeadLock, they are always zero.

CR:622528

CR Number:   622528 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) 26 Oct 2011 Duplicate Description On ASE 15.x a Correlated subquery on a proxy table may run much less efficiently than on previous versions. Workaround Description  -- Fetch proxy table data into local temp table thus: select colInt into #proxyTab from proxyTab where colInt <= (select max(colInt) from localTab) and colInt >= (select min(colInt) from localTab) select count(*) from localTab where colInt not in (select colInt from #proxyTab) drop table #proxyTab go

CR:622538

CR Number:   622538 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2012 Fixed 15 Nov 2011 One-off Provided 29 Jan 2012 One-off Provided 06 Sep 2012 One-off Provided 02 Nov 2012 Fixed Description In rare circumstances, a 12323 error may be raised when running REORG REBUILD on nonclustered index of a DATA_ONLY LOCKED table. Workaround Description  dbcc traceon (12604) --disable suffix compression on create index

CR:622590

CR Number:   622590 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) 12 Jul 2010 Fixed Description sp_monitorconfig reports inconsistent info if 'procedure cache size' is reduced. Workaround Description  Only reduce procedure cache size before reboot the ASE.

CR:622595

CR Number:   622595 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2010 Fixed 23 Mar 2010 Fixed 25 Mar 2010 Fixed 25 Feb 2011 One-off Provided Description Wrong outerjoin result may happen for a query with an outerjoin between a GROUP BY view/derived table and other table when there is a constant sarg in the view for the equality joining column. Null-supplied rows from the outerjoin may be incorrectly eliminated. Workaround Description  Use tracecommandline flag 15313. This flag backs out the fix done in 575251 which was also a wrong results problem so great care should be taken if applying TCF 15313. Please see CR 575251 for details of that problem. I believe that 575251 has existed since the GA release so many users have been exposed to problem but never seen it. The problem in 575251 could be exposed by queries requiring ordering.

CR:622717

CR Number:   622717 Product Name:   Adaptive Server Generic Docs Product Component:   Encrypted Columns Users Guide Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2010 Added to user documentation Description The example for ALTER TABLE DECRYPT in chapter 9 of the 15.0.2 User Guide for Encrypted Columns is missing the keyword "modify". It should read "alter table stolen_ccards modify ccard decrypt "

CR:622722

CR Number:   622722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2010 Fixed Description In SDC, error 2601 is seen when insert large number of identity values into table with unique index. Trace flag 16842 can be used to track the SQL that caused the 2601 error.

CR:622771

CR Number:   622771 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) 03 May 2010 Fixed 03 May 2010 Reservation Made Description Error message: ks_falloc: Cannot allocate using ubfalloc(rnetmempool, 2097152) is reported in errorlog and login failures prevent additional user connections.

CR:622787

CR Number:   622787 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2010 Duplicate Description ASEPlugin doesn't display 'trunc log on chkpt' and 'select into/bulkcopy/pllsort' databases Workaround Description  Remove 'trunc log on chkpt' and 'select into/bulkcopy/pllsort' from all databases including system databases.

CR:622883

CR Number:   622883 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 Mar 2010 Fixed 30 Mar 2010 Reservation Made 31 Mar 2010 Fixed 31 Mar 2010 Fixed Description In rare situation, "dbcc lockgc" might run into errors related to spinlock

CR:623103

CR Number:   623103 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) 22 Mar 2010 Workaround Description A simple join with order by completes in miliseconds. Use another column, and it never completes, filling a 3 gig tempdb. Changing the join order does not help unless you use "set forceplan on". Workaround Description  forceplan and different join order

CR:623139

CR Number:   623139 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2010 Added to user documentation Description Doc bug: We should tell about predicate evaluation order. There is no guarantee to evaluate and execute predicates in left-to-right order. For example, if you run a query having "WHERE x != 0 AND y = 10 OR z = 100", Adaptive Server does not guarantee to evaluate and execute "x != 0" first. Adaptive Server can evaluate and execute predicates in any order.

CR:623166

CR Number:   623166 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2010 Fixed 29 Mar 2010 One-off Provided 23 Apr 2010 One-off Provided 30 Apr 2010 One-off Provided 26 May 2010 Fixed Description Under certain circumstance, long lock hash chain(s) might contribute to 100% CPU or performance slowdown

CR:623274

CR Number:   623274 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2010 Fixed 02 Apr 2010 Fixed Description If a hash-join has a buildset/probeset key pairing of {BINARY/VARBINARY} or a key pairing of {BINARY(length M)/BINARY(length N)} and the binary values differ only by the number of trailing 0s, then these rows won't be returned. Workaround Description  set hash_join off or customer can choose other optgoals like allrows_mix or allrows_oltp.

CR:623284

CR Number:   623284 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) 23 Apr 2010 Fixed Description Integrates with new Certicom and OpenSSL security libraries that tackle SSL renegotiation vulnerability described in RFC5746.

CR:623307

CR Number:   623307 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) 30 Apr 2010 Fixed 08 Apr 2010 One-off Provided 30 Apr 2010 Fixed 25 Jun 2010 Presently Not Targeted For Any Future Release Of This Product 02 Jun 2010 One-off Provided Description In rare circumstances, a 692 error "Uninitialized logical page '<value>' was read while accessing ... object 'syslogs' (8) ..." together with a stack trace which includes the modules 'rep_agent_thread' and 'xsc__syslogs_getnext' and 'wrongpage' may be reported in the error log by the Adaptive Server Replication Agent task.

CR:623316

CR Number:   623316 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 Mar 2010 Fixed Description Comparing bigdatetime values under a parallel plan may cause error 9566, "worker process plan copy error" to be raised.

CR:623349

CR Number:   623349 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2010 Fixed Description Concurrent DML for APL table on different node may cause server hang. ASE may absort the suspect transaction.

CR:623357

CR Number:   623357 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2010 Fixed Description BS doesn't use directio or dsync i/o mode as configured for database devices on linuxia32 platform

CR:623402

CR Number:   623402 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2010 Fixed 02 Apr 2010 Fixed Description Under certain circumstances using daylight saving can cause historical server to generate incorrect date/times. Workaround Description  N/A

CR:623412

CR Number:   623412 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2010 Fixed Description The message "process infected with signal 11" in the module 'txtimg_get_datarow' may be reported together with a stack trace which include the module 'writetext' when executing the command 'WRITETEXT WITH LOG' on a replicated text column which does not have an index for replication.

CR:623444

CR Number:   623444 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2010 Consult Complete Description delrowcnt incorrect even after we run update stats/sp_flush when we delete rows

CR:623569

CR Number:   623569 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2013 Duplicate Description CIS update on text field (which is documented as not allowed) corrupts remote data rather than giving an error

CR:623591

CR Number:   623591 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) 18 Jan 2011 Fixed 23 Mar 2011 Fixed Description Error 691, "Encountered invalid logical page <pgid> while accessing database <dbname>, object <objname>, index <idxname>, partition <ptnname>. This is an internal system error. Please contact Sybase Technical Support.", will be raised when running WRITETEXT statement on a text page chain of a replicated table after rebuilding this text page chain using DBCC REBUILD_TEXT with the first text page number specified.

CR:623613

CR Number:   623613 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 The installdbccdb script raises error 911 if the dbccalt database does not exist.

CR:623658

CR Number:   623658 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) 03 Sep 2010 Fixed 03 Sep 2010 Reservation Made Description When literal autoparam is enabled, sometimes query with builtin function hash() and hashbytes() could raise parser error 11793.

CR:623669

CR Number:   623669 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2010 Not a Bug Description Not a bug.

CR:623697

CR Number:   623697 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   HP-UX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2010 Fixed 26 Mar 2010 Fixed Description ASE doesn't passes directio or dsync i/o as configured for database devices on HP platform

CR:623776

CR Number:   623776 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 Mar 2010 Fixed 29 Mar 2010 One-off Provided 30 Mar 2010 One-off Provided 16 Apr 2010 One-off Provided One-off 30 Apr 2010 One-off Provided Description Do not acquire cluster-wide distributed locks for objects which belong to node-specific databases like local user tempdbs.

CR:623777

CR Number:   623777 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2010 Added to user documentation 03 May 2010 Added to user documentation 29 Apr 2010 Fixed Description Document enhancement to add a note under the REORG command that ""REORG has no effect on space allocated to TEXT or IMAGE columns"

CR:623780

CR Number:   623780 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Include the function name in error 14217 text "SQL function not found. If you are attempting to call a java UDF, Java services are not enabled."

CR:623788

CR Number:   623788 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2010 Fixed 18 May 2010 Fixed Description ASE can't start Job Scheduler on IPV6 enabled AIX server for specific ipv4 addresses

CR:623833

CR Number:   623833 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 Mar 2010 Fixed 28 Apr 2010 Fixed 28 Apr 2010 Fixed 23 Apr 2010 Fixed 14 Apr 2010 Fixed Description A 6909 error, "The timestamp (<timestamp>) of the transaction that started at date (<date>) in database '<dbname>' (database id '<dbid>') is earlier than the timestamp (<timestamp>) of the most recently started transaction." may sometimes be reported when the log records of a transaction running in chained mode is flushed from its user log cache by another concurrent session.

CR:623902

CR Number:   623902 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) 09 Jul 2010 Fixed 29 Mar 2010 Fixed 10 Jan 2011 Consult Complete 07 Jun 2010 Consult Complete 01 Jun 2010 Fixed 04 Jun 2010 One-off Provided 12 Jul 2010 Fixed 19 Jul 2010 Bundled Request 19 Jul 2010 Bundled Request 15 Jul 2010 Fixed 15 Jul 2010 Fixed Description For local tempdb, more resources maybe consumed for the applications using local tempdb than it is needed

CR:623912

CR Number:   623912 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2010 Fixed 09 Aug 2010 Fixed 14 Oct 2010 Fixed 07 Dec 2010 Fixed 01 Jul 2010 Reservation Made 22 Dec 2010 Presently Not Targeted For Any Future Release Of This Product 15 Oct 2010 Fixed 15 Oct 2010 Fixed 22 Dec 2010 Consult Complete 22 Dec 2010 Consult Complete Description Implementation of insert/select text value into the compressed LOB columns from constant.

CR:624017

CR Number:   624017 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) 16 Apr 2010 Fixed Description When RepAgent is configured to use a trace file, trace flags 9200 and 9215 are set and the parameter 'bind to engine' is not set, memory heap corruptions can occur and lead to unpredictable errors in ASE. Workaround Description  One of the following workarounds may be applied: 1) Bind the RepAgent thread to an engine by setting the RepAgent configuration parameter 'bind to engine'. 2) Instead of configuring a trace file for RepAgent, the traces may be logged in ASE error log by setting the trace flag 3623.

CR:624043

CR Number:   624043 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2010 Fixed 28 Oct 2010 Fixed Description A 12319 error, "Fatal internal error encountered during deferred dml on table '<value>' in database '<value>'. All rows that qualified during the first phase were not visited during second phase of dml." may be reported in the error log together with a stack trace which includes the modules 'dodeferred' and 'dol_def_update' if an UPDATE command has been previously run against a data-only-locked table.

CR:624050

CR Number:   624050 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2010 Bundled Request Description DBISQL's window title now includes both the login and user name in the following format: "server_name (login_name) / database_name (user_name)". Previously the format was: "server_name (user_name)".

CR:624084

CR Number:   624084 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Closed OS:   NA Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2013 Presently Not Targeted For Any Future Release Of This Product Description Much description of regedt32.exe is included in the manual of ASE15.5. but regedt32.exe was replaced to regedit.exe. Please use regedit.exe, in using WindowsXP or later.

CR:624086

CR Number:   624086 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) 14 Apr 2010 Fixed 07 Apr 2010 Fixed Description The NETWORK HANDLER gets a timeslice error and the stack trace contains pss_init(). Target Version  Not To Be Released Workaround Description  reduce 'permission cache entries'

CR:624114

CR Number:   624114 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2010 Fixed 01 Apr 2010 Fixed Description In a complex predicate involving ORs in which it may qualify for a "row constuctor" transformation as defined by SQL semantics, if there is a IS NOT NULL or a IS NULL predicate, along with other inequalities, then there is a possibility of a stack trace.

CR:624187

CR Number:   624187 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2010 Fixed 05 Apr 2010 Fixed Description Under specific circumstances during the close cursor of a query involving more than 128 hash distinct operators, an Error: 706, Severity: 20, State: 2 may be seen and the spid terminated - it may also manifest iself as signal 11 in rm_prochdr() if the cursor is non-procedural. Workaround Description  set compatibility_mode on

CR:624215

CR Number:   624215 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2010 Bundled Request Description Connect Dialog's recently connected servers do not load updated host/port information when the corresponding server entries in the interfaces file have been updated.

CR:624218

CR Number:   624218 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2010 Fixed 22 Apr 2010 Fixed Description In rare circumstances, timeslice error might be reported when running query on monProcessProcedures.

CR:624245

CR Number:   624245 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2010 Fixed 14 Jun 2010 Fixed Description The Backup Server error message indicates that there is RPC parameter count mismatch between ASE 15.5 and Backup Server 15.0.3. The message needs enhancement to prompt user to verify Backup Server version compatibility with ASE. Backup Server error message: Backup Server: 3.31.2.3: Improper parameter count 6 for RPC bs_begin_load; expected a minimum of 3 parameters and a maximum of '5' parameters. The ASE stack trace gives the impression that the problem is complicated. The simple solution is to use the newer version of the Backup Server.

CR:624536

CR Number:   624536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description CIS delete on a non-empty proxy table when involve a join with local table fail Workaround Description  Workaround of using default tablespace is not acceptable for the customer, as he may want to use other tablespace for his login user.

CR:624565

CR Number:   624565 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2010 Fixed 25 Sep 2010 Fixed Description Stored procedure "sp_poolconfig" will fail with return status =1 when configuring/updating cache pools and auditing is enabled. Workaround Description  Disable auditing.

CR:624566

CR Number:   624566 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2010 Presently Not Targeted For Any Future Release Of This Product 08 Apr 2010 Fixed 10 Apr 2010 Fixed 29 Jun 2010 One-off Provided Description Under very rare circumstances, for caches using the clock replacement policy, the instance level physical lock on a page may be released without ensuring all local users of the page have finished working on it. Subsequently, the Adaptive Server Cluster Edition will report the following 892 error: "Process <spid> is holding a latch on buffer <buffer-address> (dbid: <dbid>, pageno: <pageno>) without holding a physical lock on the buffer".

CR:624575

CR Number:   624575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Require the partitioned information of tables saved in errorlog during upgrading from 12.x to 15.x

CR:624724

CR Number:   624724 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2010 Added to user documentation 29 Apr 2010 Fixed 26 Apr 2010 Added to user documentation Description SET options "literal autoparam" and "statement_cache" are on by default but only have any effect if the corresponding server-level setting is configured on. They are used to allow the session to opt-out of using the feature.

CR:624734

CR Number:   624734 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2010 Fixed Description sp_configure returns no output when sort order is set to case insensitive.

CR:624777

CR Number:   624777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2012 Bundled Request Description New feature: grantable privilege MANAGE ANY THREAD POOL introduced for create/alter/drop thread pool commands.

CR:624835

CR Number:   624835 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2010 Fixed 10 May 2010 Reservation Made 15 May 2010 Fixed Description Correlated predicates are not recognized as search arguments for purposes of constant attribute optimizations so a query like select * from t1 where t1.a1 = (select max(b2) from t2 where b2 <= 10 and a1=b1) should behave the same w.r.t. subquery index selection on an index on t2(b1 asc, b2 desc) as select * from t1 where t1.a1 = (select max(b2) from t2 where b2 <= 10 and 5 =b1)

CR:624853

CR Number:   624853 Product Name:   Adaptive Server Generic Docs Product Component:   XA Guide for CICS Encina and Tuxedo Status:   Closed OS:   Unknown Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2010 Added to user documentation Description The definition of sp_passthru procedure of ASE15.5 CIS Users Guide is not correct. The definition of the @server parameter of ASE15 to sp_passthru procedure was extended to varchar (255). And the errmsg parameter was also extended to varchar (1024).

CR:624870

CR Number:   624870 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   Unknown Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Dec 2013 Added to user documentation Description The operation procedure of Sybase Central included in an ASE15.5 administrator guide is an old version.

CR:624873

CR Number:   624873 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   Unknown Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2010 Added to user documentation Description DTM and Java are not option licenses any longer. But the "Note" for the option still exist in Sys Admin Guide 15.5.

CR:624879

CR Number:   624879 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2010 Fixed Description The example of SQL is not written to Example7 of isql of an ASE15.5 utility guide.