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

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

CR:643188

CR Number:   643188 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) 21 Sep 2011 Duplicate Description Online database failed with 3461, 3451 and 3454 errors during upgrade system tables. There are two workarounds: 1) If 'max parallel degree' > 1, then please disable parallel sort with sp_configure 'max parallel degree', 1 or 2) For upgrade a database via dump and load, set dboption 'select into/bulkcopy/pllsort' to false for the database on the target server before load an older version of database dump: sp_dboption db_name,'select',false go use db_name go checkpoint go load database db_name from ...... Workaround Description  Before online the database, disable parallel sort via sp_configure 'max parallel degree',1 Or sp_dboption db_name,'select into/bulkcopy/pllsort', false

CR:643337

CR Number:   643337 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2010 Fixed Description Relax restrictions on asterisk (*) in a non-EXISTS subquery SELECT LIST. Provided the * expands to a single column in a single table/view/derived table: 1. the asterisk can be qualified with a table name (tab.*) 2. the subquery can be a GROUPBY query. It will function as SELECTing the single column explicitly.

CR:643390

CR Number:   643390 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2010 Fixed 02 Nov 2010 Fixed 19 Oct 2010 Fixed 06 Mar 2012 Fixed 29 Oct 2010 Fixed 05 Nov 2010 Fixed 10 Nov 2010 One-off Provided Description Sometimes a task hits error 644 or raises exception from buffree complaining the buffer is destroyed.

CR:643536

CR Number:   643536 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   usse Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In an XML Model diagram, when dragging a free-standing element symbol onto a sequence, PowerDesigner moves it correctly. However, the dependent complex and simple types are copied to new entries.

CR:643556

CR Number:   643556 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) 21 Oct 2014 Fixed 27 Oct 2014 Fixed 17 Dec 2014 Fixed Description Cross platform transaction load is not supported, but it is allowed and it may result in Msg 695, Level 21 "An attempt was made to read logical page '<pageid>' for database '<db_name>' ... Wrong logical page '2433379939' was broughtinto cache"; Cross platform load in an archive database is also not supported but it is allowed and may result in Msg 15760 - "Invalid dump header when loading the database with ID '<n>'.".

CR:643625

CR Number:   643625 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2011 Fixed Description Historical Server may crash with a core file when executing hs_list sessions command if the client's charset is incompatible with the server's charset. Workaround Description  Connect with a compatible charset to Historical Server.

CR:643774

CR Number:   643774 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) 24 May 2013 Insufficient info provided Description dbcc sqltext can SEGV or timeslice if the spid you want to see the sqltext for are in the processes of termination. Workaround Description  Stop running dbcc sqltext this is only used for monitoring.

CR:643811

CR Number:   643811 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2010 Fixed 19 Oct 2010 Reservation Made 25 Oct 2010 Fixed 20 Oct 2010 One-off Provided 14 Jan 2011 One-off Provided 16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description For queries with large number of joins that time out in the optimizer before a good plan can be found, then the alternative greedy algorithm is useful to find a good starting point for optimization similar what the 12.5 optimizer would choose. The alternative greedy algorithm may not be used for a number of reasons, and this change will allow more cases to use this feature. This new feature adds support to allow the alternative greedy algorithm to be used when the index row for a 12.5 GROUP BY key is too wide for the query to be executed in 12.5. This new feature can be activated by trace flag 16929 or optcriteria allow_large_index_row. Also, when partitioned tables are involved in the query the alternative greedy algorithm will now provide an initial starting point using global statistics from the partitioned tables, but otherwise treating the partitioned tables as unpartitioned. This new feature can be activated by trace flag 15366 or optcriteria basic_optimization_partitions.

CR:643859

CR Number:   643859 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) 19 Oct 2010 Fixed 18 Oct 2010 Fixed Description The "hints" option in Abstract Plan syntax is not backward compatible with 12.5 Abstract Plans. Workaround Description  remove "hints" clause from AP

CR:643910

CR Number:   643910 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) 08 Oct 2010 Fixed Description The severity for error 13905 is wrongly reported as 16. It should be 10 as in the manual.

CR:643987

CR Number:   643987 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) Description feature request to speed fast bcp up even faster. Since 15.0.2, we allow fast bcp with non-clustered indexes, but the improvement is a mere 10% over slow bcp. customer would like to have the *risky* option to put off the index and allocation updates to afterwards to get the data in as fast as possible.

CR:644012

CR Number:   644012 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) 15 Oct 2010 One-off Provided 12 Oct 2010 Fixed 14 Oct 2010 Fixed 17 Nov 2010 One-off Provided 11 Jan 2011 One-off Provided 25 Feb 2011 One-off Provided 31 May 2012 Fixed Description If the log I/O size used by Adaptive Server when doing I/O for the transaction log of a given database is changed by sp_logiosize, then Adaptive Server may incorrectly ignore it during startup. Workaround Description  Create a pool with the same I/O size in the default data cache. This can be a small pool. In this Repro example it would be an 8K pool. OR Configure a 16K pool in a named cache and set the log I/O size to 16K in the database (use 16K instead of 4K or 8K). This is because ASE temporarily creates a 16K pool in the default data cache during recovery. OR Run sp_logiosize twice as shown below every time you restart the ASE and the database is online. sp_logiosize '2K' go sp_logiosize 'the value you want' -- 8K in this Repro example go

CR:644104

CR Number:   644104 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 #4 07 Jan 2011 Fixed 08 Feb 2011 Fixed 07 Jan 2011 Reservation Made 07 Jul 2011 One-off Provided 18 Sep 2012 Fixed Description Under some rare conditions, stacktrace involving the modules 'LePlanRelease', 'LePlanWriteStats' an d 'LeAlfaStatsCollector' may be reported during query plan generation.

CR:644156

CR Number:   644156 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 Oct 2010 Fixed 17 Nov 2010 Fixed 15 Nov 2010 One-off Provided 14 Feb 2011 One-off Provided 02 May 2011 One-off Provided 23 Sep 2012 Fixed Description Under some circumstances the message "WARNING: memory usage in procedure headers (x) does not match memory usage count in Pss (x) for server process id x" may be reported in the errorlog when a session is holding a high number of user temporary tables without dropping them and, for example, runs some stored procedures via Remote Procedure Call. Eventually, after multiple of those messages, a 701 error "There is not enough procedure cache to run this procedure, trigger, or SQL batch." maybe reported indicating that the free memory available in the Procedure Cache is low. Workaround Description  n/a

CR:644280

CR Number:   644280 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) 18 Oct 2010 Fixed Description After executing ALTER TABLE MODIFY an identity column and the server crashes, a large identity gap is observed after reboot.

CR:644357

CR Number:   644357 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2010 Fixed Description If a stored procedure is created based on a non-partition table and later on this table is altered to a partition table, it will cause stacktrace and raise 12329 error when we execute this stored procedure when compatibility mode is enabled. Workaround Description  Recreate procedure

CR:644380

CR Number:   644380 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2010 Fixed Description A new column StmtType has been added to monCachedStatement. The value of StmtType column will be used to tell the type of cached statement, i.e. 1 means batch statement, 2 means cursor statement, and 3 means dynamic statement.

CR:644394

CR Number:   644394 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Nov 2010 Fixed 29 Nov 2010 Fixed 30 Nov 2010 Fixed 30 Nov 2010 Fixed 11 Mar 2011 Fixed Description In rare circumstances unexpected results may be returned when executing a query on a view defined on other nested views which require a Worktable to materialize some intermediate results and involve a join with mixed datatypes. Workaround Description  - Rewrite the query or view so the same datatypes are involved in the join predicate (using the explicit CONVERT() function or changing the datatypes in the underlying tables) OR - Use Abstract Plan to choose a plan where the insertion into the Worktable (for materializing the results) do not need a conversion.

CR:644402

CR Number:   644402 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2010 Fixed 17 Dec 2010 Fixed Description ASE fails to account for the failed sdesmgr request when more auxilairy SDESs than configured are required.

CR:644479

CR Number:   644479 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) 18 Oct 2010 Fixed Description If traceFlag 15891 is enabled, the message, "mhdc_get_stat: No persistent reservation holder with res_type:2109524184" will be displayed during shutdown.

CR:644531

CR Number:   644531 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2013 DEFER Description When statement cache or literal autoparam is on, the query chooses a bad table scan that takes a long time to complete. With statement cache off, or literal autoparam off, the query chooses the index. Workaround Description  set statement_cache off or sp_configure "literal autoparam", off Another workaround is to factor the predicate so that only one instance of the constant exists in the predicate, and only one literal parameter will be substituted. SELECT cmsfwd_history_exclconv.settle_date, cmsfwd_history_exclconv.currency, cmsfwd_history_exclconv.fwd_years, cmsfwd_history_exclconv.v1y FROM fi_hist_cms_curves.dbo.cmsfwd_history_exclconv cmsfwd_history_exclconv WHERE ( (cmsfwd_history_exclconv.currency='EUR') OR (cmsfwd_history_exclconv.currency='GBP') OR (cmsfwd_history_exclconv.currency='USD') OR (cmsfwd_history_exclconv.currency='JPY') OR (cmsfwd_history_exclconv.currency='EON') OR (cmsfwd_history_exclconv.currency='SON') ) AND cmsfwd_history_exclconv.settle_date> '20091227 12:00:00AM' go

CR:644607

CR Number:   644607 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) 25 Oct 2010 Fixed Description When using the plancost command from sybmon, ASE will stack trace. This is observed mostly on the Windows platform.

CR:644669

CR Number:   644669 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) 18 Mar 2011 Fixed 25 Mar 2011 Fixed 25 Mar 2011 Fixed Description The message "WARNING: The transaction log for database '<dbname>' (dbid <dbid>) can no longer be dumped due to user '<username>' (suid <suid>) executing <cmdname>" is now reported in the error log when the transaction dump sequence is broken.

CR:644677

CR Number:   644677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2011 Fixed 28 Jan 2011 Reservation Made 07 Feb 2011 Fixed Description For table descriptors(DES), Accessing rarely used objects could scavenge Objects that are widely used.

CR:644715

CR Number:   644715 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) 24 May 2013 Insufficient info provided Description query fails with 249 error with traceflag 450

CR:644777

CR Number:   644777 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) 08 Nov 2010 Fixed 09 Nov 2010 Reservation Made 10 Nov 2010 Fixed Description Multiple IN lists under OR didn't use large IN list transformation even when the total number of IN values exceeds 128. Consequently, when the number of such IN values exceeds 32K, signal 11 and stacktrace could happen in GaGenericArray::_GaGetPtr() when optimizer is trying to create more than 32K (int16) internal predicate objects.

CR:644982

CR Number:   644982 Product Name:   Adaptive Server Enterprise Product Component:   sqlloc Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2010 Fixed 25 Oct 2010 Fixed 15 Nov 2010 Fixed 06 Dec 2010 Fixed 14 Dec 2010 Fixed 16 Dec 2010 Fixed Description sqllocres set incorrect default sort order.

CR:644994

CR Number:   644994 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) 19 Nov 2010 Fixed 18 Nov 2010 Reservation Made 10 Aug 2011 One-off Provided 20 Sep 2012 Fixed Description Under some conditions, for example reset or reconfigure 'parallel degree', statement cache clean up issues and memory leaks may occur and it could also make the purge statement cache entry impossible due to ssql_keep > 0. Workaround Description  Need to reboot the ASE to clean up the statement cache.

CR:645100

CR Number:   645100 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Statement cache lightweight procedures currently use 'sproc optimize timeout limit' and not 'optimization timeout limit' . This can be misleading. This request as to allow statement cache lwps to use the 'optimization timeout limit' as per ad-hoc sql.

CR:645146

CR Number:   645146 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) 19 Oct 2010 Fixed 20 Oct 2010 Fixed 07 Jan 2011 One-off Provided 18 Sep 2012 One-off Provided 11 Sep 2012 Fixed Description Under some conditions, creating trigger involving union could lead to SEGV in p__check_lob_insdel() function. Workaround Description  dbcc traceon (1716) --to disable changes in CR 590800

CR:645166

CR Number:   645166 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Open OS:   macosx Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request for 15.x Sybase Central plug-ins and Interactive SQL for MAC client

CR:645301

CR Number:   645301 Product Name:   Adaptive Server Enterprise Product Component:   ssm Status:   Open OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2010 Fixed Description Change of behaviors in IBM AIX LPAR (logical partition) licensing. This affects AIX platform only in both ASE SMP and Cluster editions running in IBM AIX LPAR environment. The new behavior is that SySAM obtains the CPU core count from the Entitled Capacity in a Capped LPAR environment, and SySAM obtains the CPU core count from the Maximum Capacity in an Uncapped LPAR environment. Prior to ASE 15.5 ESD#3, SySAM obtains the CPU core count from the Maximum Virtual CPUs and Active Physical CPUs in Capped and Uncapped LPAR environments.

CR:645343

CR Number:   645343 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) 09 Nov 2010 Fixed 22 Nov 2010 One-off Provided 16 Nov 2010 Fixed 19 Sep 2012 Fixed Description Stack trace in LeDataRow::readRow when fetching insensitive cursor on a union. Workaround Description  Avoid the union operator in the cursor statement

CR:645349

CR Number:   645349 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2012 Insufficient priority to fix Description Error 206 when traceflag 450 is enabled Workaround Description  Change query to avoid error 206

CR:645445

CR Number:   645445 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2011 Fixed Description For APL table with clustered index and the table is page compression, insert duplicate row into the table does not raise error 2615.

CR:645530

CR Number:   645530 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2011 Fixed 28 Apr 2011 Fixed 28 Apr 2011 EOL'd version. Not to be Fixed. 28 Apr 2011 Fixed Description Sometimes the DBCC CACHEDATAREMOVE command may fail when executed on a system table, and the following 1265 error, "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family...", may be reported even when there is no contention.

CR:645594

CR Number:   645594 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) 21 Oct 2010 Duplicate Description Signal 11 and stack trace may be seen with functions _memcpy()\ LeDataRow::readRow() LeScrollCache::LeScrCacheGetRow() when fetching rows from an insensitive cursor of a select..union statement

CR:645682

CR Number:   645682 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) 22 Jul 2011 Fixed Description If auditing is enabled and the ASE server is started with traceflag 3607 a SEGV will occur when a client does a query. Workaround Description  set 'enable auditing = 0' in the .cfg file and restart the dataserver

CR:645753

CR Number:   645753 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) 02 Dec 2010 Fixed 01 Dec 2010 Reservation Made Description Temporary tables created with the ALLPAGES lock scheme may report error 311 when an attempt is made to read the table using a cursor, despite a unique index having been created. The error only occurs in the case of ALLPAGES lock scheme and if multiple cursors are declared in the same stored procedure. Workaround Description  The simplest work around is to change the default lock scheme to either datapages or datarows. However, if this is unacceptable, it is also a valid workaround to define the lock scheme in the create table statement. Another workaround, considering the procedure provided as a repro by the client, is to take the create table/create index statements from inside the two if blocks and replace this with one create table/create index statement, since the tables are the same this can be done with the example provided. An example of this workaround has been included in the case notes directory: pserepro_workaround.sql

CR:645810

CR Number:   645810 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) 06 Dec 2010 Fixed Description Linux with multipathing displays "reservation conflict" errors in the machine log when fencing is enabled. Workaround Description  Ignore errors or disable multipathing.

CR:645860

CR Number:   645860 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) 12 Mar 2011 Fixed Description The message "current process infected with 11" in the module 'lt_sqlrep_comp_policy' together with a stack trace which includes the modules 's_compile_stmt' and 'GenLava' may be reported in the error log when a session executes a query that is being compiled by ASE, while a REORG REBUILD command or DDL activity takes place concurrently on the same table.

CR:645893

CR Number:   645893 Product Name:   Adaptive Server Generic Docs Product Component:   Adaptive Server New Features Guide Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Requests to document the behaviour covered under CR 613678 in the New Features Guide. This CR introduced a new parameter to sp_droplogin (@with_override). It is required to be set to 1 if wanting to drop a login when one or more databases are unavailable to check login references.

CR:645898

CR Number:   645898 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2013 Fixed 27 Jan 2014 Fixed 27 Jan 2014 Fixed Description In rare circumstances, after configuring a big data cache or a large stack size, SAP ASE might implicitly shut down following a JavaVM crash while executing a Java query. The message EXCEPTION_ACCESS_VIOLATION or 'ExceptionCode: c0000005' will be reported in the SAP ASE error log.

CR:645944

CR Number:   645944 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2010 Fixed Description Issue a warning if a network listener is using the IP address of a CIPC interconnect

CR:646013

CR Number:   646013 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 01 Nov 2012 Fixed 02 Nov 2012 Fixed 02 Nov 2012 Fixed 14 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 14 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 14 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description When creating local index on semantic partitioning table, mapping between index partitions and datapartitions is not guaranteed in the same order of semantic partitioning boundary.

CR:646024

CR Number:   646024 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2011 Fixed 19 Nov 2010 Reservation Made 09 Aug 2011 Fixed Description Sort operators are undercosted in fastfirstrow scenarios. Fastfirstrow scenarios include min/max optimizations, exists scans and the fastfirstrow optgoal. This can lead to discarding fastfirstrow strategies in preference to other less efficient strategies incorporating sorts. The fix for this is enabled by the cr646024 optcriteria.

CR:646101

CR Number:   646101 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2010 Fixed 01 Apr 2011 One-off Provided Description Under rare circumstances, DISK INIT may hang indefinitely.

CR:646141

CR Number:   646141 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 May 2011 Fixed Description Print a warning message if the timestamp of a joining instance is not in sync with that of the existing instances.

CR:646149

CR Number:   646149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances, the same Abstract Plan works fine on ASE 125x and failed on ASE 15.5 with the error 1009, Level 16, State 2.

CR:646206

CR Number:   646206 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2010 Fixed 14 Nov 2010 Fixed Description ASE does not perform implicit conversion when unitext data is sent from external clients to a text parameter.

CR:646207

CR Number:   646207 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   bharani beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2010 Fixed 08 Nov 2010 Fixed Description When executing DBCC TUNE (des_bind) on a table, a 8428 error may be encountered after which the table is no longer usable.

CR:646220

CR Number:   646220 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) 18 Mar 2011 Fixed 18 Mar 2011 Reservation Made Description When selecting from a VIEW using an equality predicate over two view columns where the two VIEW columns are the two SELECT DISTINCT columns of the VIEW and one of them is also a non-correlated aggregate subquery result there, it could lead to signal 11 stacktrace in CgpDistinctHashing::_cgpInit() or in CgpPop::_CgpReplaceVars().

CR:646232

CR Number:   646232 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Currently ASE is designed to allow an offline database to have its transaction log dumped. This is a request to change that behaviour and deny that command on an offline database. Workaround Description  There is no work around.

CR:646254

CR Number:   646254 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Please document the write up for error message 13968 Error 13968 Severity 16 Message text "ALTER TABLE '%.*s' failed. You cannot drop all partitions of a table." Explanation The alter table command provides a method to remove a partition from table. Any data that is stored on that partition is moved to a suitable remaining partition. When there is only one partition left on a table, it is no longer possible to store the data in an alternative partition. If an attempt is made to remove the final partition from a table using the ALTER TABLE command then error 13968 will be reported. Action This error is reported when an attempt is made to drop the only remaining partition of a table. If the requirement is to drop the table from the database then the correct method is to use a drop table command. If this is not the requirement then no action is required. Additional Information Refer to the Reference Manual: Commands for information about the alter table command

CR:646295

CR Number:   646295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description select fails to convert float to numeric if region setting is german germany and enable pci is set on Workaround Description  Disable PCI by sp_configure "enable pci", 0 OR Don't use German Germany in region setting in the pc OR Setup the "Decimal symbol" to '.' as opposed to ',' in the pc OR Boot ASE with trace flag 4065

CR:646353

CR Number:   646353 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) 02 Nov 2010 Fixed 02 Nov 2010 Fixed 06 Jan 2011 One-off Provided 22 Feb 2011 One-off Provided 11 Sep 2012 Fixed Description A signal 11 may be raised when upgrade step 245 is involved during upgrade to ASE 15.5 SMP. Workaround Description  [ningzhen 2/08/2011] A more restrictive workaround is just to remove the related rows in sysroles and sysusers which use new 15 system roles uid on source pre-15 ASE before dump the source database: use testdb go sp_configure 'allow updates to system table',1 go select * from sysusers go select * from sysroles go begin tran go delete from sysroles where lrid between 16390 and 16398 ---[16390, 16398] may be used by new 15 uids for system roles in user databases go delete from sysusers where uid between 16390 and 16398 go commit tran go select * from sysusers go select * from sysroles go use master go dump database testdb to '//remote/cases/11654000s/11654320/pseinfo-11/Repro/ct_data/db_1254.dmp2' go -------------------------------------------------------------------------- [szhuang 2010-Nov-9]: Delete all users and roles of the db to be loaded. load database dbxxx from "dumpXXX" go dbcc traceon(990) go sp_configure 'allow updates to system table',1 go use dbxxx go delete from sysroles go delete from sysusers go use master go sp_configure 'allow updates to system table',0 go dbcc traceoff(990) go online database dbxxx go

CR:646388

CR Number:   646388 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) 13 Dec 2010 Fixed 04 Jan 2011 One-off Provided 18 May 2011 Fixed 22 Jul 2011 Fixed 19 Sep 2012 Fixed Description When tables with large number of partitions (typically greater than 32) are used in a query that has a UNION or a UNION ALL query with ASE configured for parallelism, ASE may stack trace. Workaround Description  Disable parallel or unpartition the table

CR:646397

CR Number:   646397 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) 07 Dec 2010 Fixed 08 Dec 2010 Reservation Made 11 Dec 2010 Fixed 11 Jan 2011 One-off Provided 25 Sep 2012 Fixed Description Executing an insert-select from proxy table into local table when a LOB column is present is much slower than in ASE 12.5.

CR:646467

CR Number:   646467 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2010 Fixed 01 Nov 2010 Fixed 22 Feb 2011 Fixed Description ASE Cluster Edition running on SuSE linux may hit SEGV if native CIPC thread is enabled (traceflag 15582 is not used).

CR:646490

CR Number:   646490 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2010 Fixed 01 Nov 2010 Fixed 29 Apr 2011 Duplicate Description For a table with auto identity column, REORG REBUILD after any data copy operation (like ALTER TABLE involving data copy or REORG REBUILD) would fail with error 1763. Also, two consecutive ALTER TABLE ADD/MODIFY operations involving data copy may remove the auto-identity column so that any later attempt to see the values under SYB_IDENTITY_COL may fail with error 207. Workaround Description  After any alter table/reorg rebuild statement, do a dbcc cacheremove.

CR:646508

CR Number:   646508 Product Name:   System Admin Guide Product Component:   System Administration Guide Status:   Open OS:   NA Original Version:   6.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer required clarifucation.

CR:646647

CR Number:   646647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description update all statistics on a table with no index gives Msg 1763.

CR:646693

CR Number:   646693 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2010 Fixed Description After migrating from pre-15.0 to ASE 15.5, sybmigrate may report diff failures with 16201 error, "Remote datatype 'usmallint' (65) is unsupported in local server".

CR:646695

CR Number:   646695 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Query involving 6 or more tables and greater than 14 worktables can exhaust procedure cache. Workaround Description  set alternative_greedy_search off and ensure you have sufficient buffers in either the default data cache, or whichever cache you bind your query to

CR:646828

CR Number:   646828 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New set option to ABORT the transaction for all Error messages.

CR:646844

CR Number:   646844 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2010 Fixed 07 Dec 2010 Fixed Description On AIX platforms, logical volumes cannot be fenced directly. Workaround Description  LUNs can be partitioned into multiple raw partitions or logical volumes using mkvg, mklv, and importvg. However, ASE cannot directly fence these partitions. In order to fence the partition, ASE must directly fence the underlying LUN (/dev/rhdisk). The SA can add database devices using the multiple partitions through 'disk init', In order to properly fence the partitions, the SA must first add a database device using the LUN as well which must not be used for data or data in the partitions will be overwritten. It is just to be used for fencing the partitions.

CR:646877

CR Number:   646877 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2010 Fixed 04 Jan 2011 Reservation Made 06 Jan 2011 Fixed 19 Jan 2011 Fixed Description ASE on Windows can occasionally hang on call csimtx_lock()=>WaitForSingleObject(). This can occur at server startup or at user authentication when attempting to obtain the lock which is already held.

CR:646933

CR Number:   646933 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2010 Fixed Description In a 4-node cluster, if any node crashes, executing DROP INDEX from active node will result in a 3757 error.

CR:646987

CR Number:   646987 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2010 Fixed Description When inserting data using PreparedStatement and DynamicPrepare=True, data might be truncated when the column type is UNIVARCHAR and the first value inserted into the column is less than or equal to 128 characters in length. If these two conditions are true, then every subsequent value inserted into the column will be truncated to 128 characters, if greater than 128 in length.

CR:647051

CR Number:   647051 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) 08 Nov 2010 Fixed 04 Nov 2010 Reservation Made Description The selectivity estimates for predicates on columns with NULL values may be incorrect for the !=, <, <= operators. There is also a correction for ANSINULL handling of NULL selectivity in which magic numbers were used instead of histogram values. Change is turned on by optcriteria cr647051 in optlevel ase155esd4

CR:647052

CR Number:   647052 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) 08 Nov 2010 Fixed 09 Nov 2010 Fixed Description When deadlock information is required to be printed into error log, corresponding SQL texts are not printed out.

CR:647138

CR Number:   647138 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) 23 Nov 2010 Fixed Description A 11035 error, "Execution of procedure <proc name> failed because upgrade found no entry in syscomments for this object. Please drop and recreate dbo." may be reported when executing a stored procedure which belongs to a procedure group that was created using deferred name resolution and at least one of the procedures in the group has a SELECT * statement. Workaround Description  Turn of deferred name resolution. and do old style create procedure with # tables where you create # tables before the create procedure.

CR:647202

CR Number:   647202 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2011 Fixed 08 Mar 2011 Fixed Description The Opertions column in the MDA table monOpenObjectActivity is not incremented when statement cache is on.

CR:647239

CR Number:   647239 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2011 Fixed Description DBCC PROC_CACHE("free_unused") doesn't refill other engine's ELC.

CR:647356

CR Number:   647356 Product Name:   ASE Management Product Component:   Monitoring Agent Plugin Status:   Closed OS:   Generic Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2010 Fixed Description The procedures cache folder at Sybase Control Centel reported the following error "Arithmetic overflow during explicit conversion of NUMERIC value '119185.603515' to a NUMERIC field" and didn't show no data for memory usage. Y

CR:647485

CR Number:   647485 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) 14 Nov 2010 Fixed 07 Jan 2011 One-off Provided 21 Jul 2011 Fixed 18 Sep 2012 One-off Provided 11 Sep 2012 Fixed Description Executing a SELECT INTO EXISTING command on a proxy table with identity_insert option turned on does not insert the data.

CR:647569

CR Number:   647569 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2011 Fixed 18 May 2011 Fixed Description Certain parallel query plans available in ASE releases before 15.0 are not supported in ASE 15.0. Cases include joins between partitioned and unpartitioned tables. This change adds capabilities and costing support for these queries. Changes are enabled using trace flags 16970 and 15331. You may also need to sp_chgattribute to set the plldegree on a per table basis.

CR:647589

CR Number:   647589 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2010 Fixed 18 Nov 2010 Fixed 18 Nov 2010 Reservation Made Description When a stored procedure or dynamic SQL statement that has at least one LOB parammeter is recompiled after execution starts, a stack trace containing the functions, copyconst(), copyres() and s_recompile() could be generated.

CR:647654

CR Number:   647654 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2011 Consult Complete 23 Dec 2010 One-off Provided 24 Feb 2011 One-off Provided 27 Mar 2011 Fixed 30 Mar 2011 Fixed 05 Apr 2011 Fixed 27 Sep 2012 Fixed Description In rare circumstances an ASE task that is in the process of creating a temporary table in a user defined temporary database may sleep for ever while ASE generates the object ID value for this table. The call stack for the sleeping task will report the modules 'crt_main' and 'objd_id'.

CR:647670

CR Number:   647670 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined 25 May 2012 Bundled Request Description DBISQL 11.0.1 for ASE's 'OUTPUT TO Excel' command does not work.

CR:647726

CR Number:   647726 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 Nov 2010 Fixed Description A parallel reformat inside a subquery may be costed incorrectly.

CR:647801

CR Number:   647801 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2011 Fixed 08 Apr 2011 Fixed 08 Apr 2011 Fixed Description A 691 error, "Encountered invalid logical page '0' while accessing database 'db_name' (id), object 'table_name' (id), index 'index_name' (255),..." or a 14108 error, "Could not find partition descriptor for objid <...> ..." together with a stack trace which includes the modules 'get_txtpage' and 'instext' may be reported in the error log when running a SELECT INTO UNION which requires to use an internal worktable (for example, because of an ORDER BY clause) and a NULL literal value is used in one of the UNION sides for a TEXT, UNITEXT or IMAGE column.

CR:647823

CR Number:   647823 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Very long boot times when large procedure cache configured.

CR:647831

CR Number:   647831 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) 24 May 2013 Insufficient info provided Description Signal 11 in s_result_const_memfree sometimes after error 599

CR:647864

CR Number:   647864 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2010 Fixed Description The execution of SP_ADDENGINE and SP_DROPENGINE will raise error 17260 "Can't run <procname> from within a transaction." incorrectly when invoked under chained transaction mode despite that there is no open transaction.

CR:647973

CR Number:   647973 Product Name:   Adaptive Server Enterprise Product Component:   ssm Status:   Closed OS:   HP-UX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.5 ESD #3 18 Feb 2011 Fixed Description When insufficient served licenses are available ASE should report the requested license type and quantity, as is the case for unserved licenses.

CR:648018

CR Number:   648018 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2010 Fixed Description A 257 error, "Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed", may be raised when migrating a pre-15.0.2 server to ASE 15.0.2 or later versions.

CR:648097

CR Number:   648097 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description After you run 'set lock wait 0' or 'set lock nowait', @@lock_timeout is still -1. Workaround Description  Harmless, ignore it.

CR:648131

CR Number:   648131 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Control GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2011 Fixed Description It can not find the right partition that is remaining.

CR:648155

CR Number:   648155 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In-place upgrade hang and on recovery get latch deadlock. Workaround Description  re-build sybsystemprocs.

CR:648195

CR Number:   648195 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) 06 Apr 2012 Added to user documentation Description Doc Request: add known performance issues with MDA parameters

CR:648216

CR Number:   648216 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Doc bug: update XA Interface Requirements per version

CR:648380

CR Number:   648380 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 Feb 2011 Consult Complete Description ASE/CIS to oracle ... convert function causes subquery performance prblm

CR:648396

CR Number:   648396 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2010 Fixed 02 Dec 2010 Fixed Description Undersomecircumstancesthemessage"WARNING:memoryusageinprocedureheaders(x)doesnotmatchmemoryusagecountinPss(x)forserverprocessidx"maybereportedintheerrorlog"

CR:648449

CR Number:   648449 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) 13 Dec 2010 Presently Not Targeted For Any Future Release Of This Product Description SELECT INTO EXISTING, identity fields can cause 12859 errors and stacktrace

CR:648453

CR Number:   648453 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) 08 Sep 2011 Not a Bug Description datachange() returns contradictory results before statistics are created

CR:648511

CR Number:   648511 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2011 Fixed 19 Aug 2011 Fixed Description If sp_passwordpolicy "expire login passwords" is executed without specifying a login or wildcard string, it expires every login on the server.

CR:648514

CR Number:   648514 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2014 Fixed Description Error 1105 States 4, 5, and 7 may no longer mean what they are documented to mean in the ASE Troubleshooting Guide due to reuse of the values in new code.

CR:648582

CR Number:   648582 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A feature request to improve index selectivity for constant valued search arguments and encrypted non-character and non-binary columns. Workaround Description  Use a local variable which is the same data type as the encrypted column. declare @val datetime select @val = '1988/12/31' select * from tab1 where b = @val go

CR:648591

CR Number:   648591 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2010 Fixed 22 Nov 2010 Fixed Description A 8201 error, "Keep count of descriptor (objid=<id>, dbid=<id>) was expected to be 1. Instead 0 was found." together with a stack trace which includes the modules 'des_unkeep' and 'onl__chk_indexes' may be reported in the error log when a database dump is loaded that has been previously obtained on a different platform.