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

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

CR:493751

CR Number:   493751 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2008 Fixed Description When the power() builtin function is used in a SQL statement and the second argument to power() is an integer datatype, a 3606 error (arithmetic overflow) can be incorrectly raised. Workaround Description  Add convert() for calc_yr_diff: select power(convert(float, 1.050000), convert(float, calc_yr_diff)) from PSE_temp6

CR:493827

CR Number:   493827 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2009 Presently Not Targeted For Any Future Release Of This Product Description With using forced join order, optimizer may choose a reformatting plan which is slower than using an index. Workaround Description  Use a forced index

CR:493833

CR Number:   493833 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2009 Fixed 23 Jan 2009 Fixed Description sp_sysmon does not report the number of lock promotion when page lock is promoted to table lock.

CR:493885

CR Number:   493885 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2008 Fixed 12 Mar 2008 Added to user documentation Description Migrate user defined application context. Tasks which have run "set_appcontext" will now be migratable and the define context will be migrated to the new instance.

CR:493891

CR Number:   493891 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2008 Fixed 03 Sep 2008 Fixed 03 Sep 2008 Fixed Description CREATE EXISTING TABLE fails to import indexes when an index contains more than 1 million pages. The ASE errorlog contains the message "user api layer: internal common library error: The bind of result set item 12 resulted in an overflow." Workaround Description  - They execute the "create existing", and it succeeds, but they have no indexes - They turn on traceflag 11208, then create the index on the proxy table on the proxy server - 11208 allows an index to be created on a proxy table, but it will not forward it to the backend server.

CR:493894

CR Number:   493894 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2008 Fixed Description Disallow the migration of tasks which have established an application context using the set_appcontext() built-in.

CR:493908

CR Number:   493908 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2008 Fixed Description Select from syslogshold does not provide the latest secondary truncation point when the Rep Agent thread has changed it.

CR:493919

CR Number:   493919 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2008 Fixed Description A query that uses the same column more than once and assigns multiple instances of this column in the select list the same column alias will cause error 7348. If the same query is executed without assigning column aliases, the query executes successfully. An example: > select col1 as 'column1', col1 as 'column1' from tab1 > go Msg 7348, Level 15, State 1: Select expression results in more than one column having same name. Column name 'column1' is specified more than once.

CR:493935

CR Number:   493935 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2008 Fixed 11 Jun 2008 Fixed Description Sometimes, even if all the rows on a page get deleted the page is not deallocated.

CR:493937

CR Number:   493937 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2008 Fixed 08 May 2008 Fixed 26 Jun 2008 Fixed Description A signal 11 may occured with a stacktrace involving 'ResRelOp' called from 'OptFindLegacyOj' for an OUTERJOIN query whose inner table is a VIEW with a CASE expression in the SELECT list and the CASE expression from the VIEW is also referenced in a correlated subquery above the OUTERJOIN.

CR:493941

CR Number:   493941 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2008 Fixed Description Insert could goes to a deallocated page from index reorg rebuild.

CR:493953

CR Number:   493953 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) 01 Apr 2008 Fixed Description Starting IPV6 needs turning on trace flag 7841. This requirement is removed. We need to just give machinename.v6 or ipv6 address in interfaces file to start ASE with IPV6.

CR:494008

CR Number:   494008 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2008 Fixed Description QP metrics is not captured for INSERT...VALUES statement consistently

CR:494013

CR Number:   494013 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2009 Insufficient priority to fix 14 Mar 2008 Fixed Description When statement cache is on, if a goto query is run after a cachable statement, the branching to the label statement might not happen. Workaround Description  Change batch structure as mentioned in CR notes

CR:494066

CR Number:   494066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2008 Fixed Description Setting the server option 'net password encryption' for non-ASE backends is silently ignored.

CR:494069

CR Number:   494069 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Windows XP Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2008 Fixed Description When a remote instance has XP server running, the command to shut down cluster and shut down remote instance may fail.

CR:494097

CR Number:   494097 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2008 Fixed Description Large buffer pool created by recovery process is not getting deleted after booting instance.

CR:494105

CR Number:   494105 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2008 Fixed Description If the current instance name string is a substring of any other instance name, configuration file format error will be seen during server boot-up. The handle for this special case is added in cfg__read_section().

CR:494128

CR Number:   494128 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) 30 Mar 2008 Fixed Description Error 10863 "Initialization of the cache (<cache name>) failed due to lack of space. Changes will take effect when server is rebooted. To make changes in the same instance increase the value of 'max memory' config parameter and retry command." may be reported while configuring a named cache with 64 cache partitions using sp_cacheconfig. Workaround Description  Configuration file is written after cache creation failure with new cache information. Rebooting the server doesn't have nay problem in creating named cache successfully.

CR:494166

CR Number:   494166 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2009 Insufficient priority to fix 17 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date Description Range cell density on varchar column jump when insert or delete one row. Workaround Description  1) change number of steps or histogram tuning factor. 2) sp_modifystats.

CR:494180

CR Number:   494180 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2008 Fixed 02 Jun 2008 Fixed Description When a procedure is created by sa (or a user with sa_role) and accesses an object in another database and the access permission on the object is granted to dbo through a group, then a user (who is aliased to dbo in both databases) executing the procedure may get a permission error on the object. Workaround Description  1. use a dbo without sa_role to create the procedure or 2. directly grant the permission on PSE_d2.audit.PSE_t1 to dbo

CR:494181

CR Number:   494181 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2008 Fixed Description In rare circumstances, DUMP DATABASE command may hang when it is executed during node failover recovery and DUMP DATABASE was running on the crashed node when the node crash happened.

CR:494188

CR Number:   494188 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) 15.0.2 ESD#4 13 Mar 2008 Fixed Description An expression involving Blob type (such as text/image) column in the SELECT list for a join query could lead to signal 11 stacktrace in CgEvals::_CgCompVcol() when a reformatting (store_index) plan is chosen. Workaround Description  Break the query into two steps: First select all the individual columns from the query into a temp table without concatenating them, then select the concatenated columns from the temp table. select convert(char,t4.c1) as "c1", t3.c3 as "c3" into #foo from t4, t3 where 1=0 select c1 + c3 from #foo drop table #foo go

CR:494195

CR Number:   494195 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2008 Fixed Description Default value of CIPC message pool is increased from 4096 to 8192. This value is set in server's configuration file <server>.cfg via following: CIPC regular message pool size = DEFAULT.

CR:494202

CR Number:   494202 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2008 Fixed Description Error 694 suggesting device i/o error has occurred will be raised because of an stale transfer cancel request sent to the node.

CR:494232

CR Number:   494232 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2008 Fixed Description In rare circumstances message "Identity value overflow " may be reported , while explicitly inserting max precision identity value to identity column.

CR:494239

CR Number:   494239 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) 26 Mar 2008 Fixed 26 Mar 2008 Reservation Made 03 Apr 2008 Fixed 01 Apr 2008 Fixed Description A new static configuration parameter "max nesting level" is added to configure the maximum allowed nesting level in the SQL queries for execution. This configuration value can be in the range of 16 - 100 with 16 being the default value.

CR:494244

CR Number:   494244 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2008 Fixed Description 1. After successfully upgrading from an Adaptive Server 15.0 (or later) installation to 15.0.1 CE, the system view sysquerymetrics will be missing. When installmaster script is run it will hit error 208 while installing the sp_show_metrics system stored procedure. 2. After successfully upgrading from an Adaptive Server installation version older than 15.0 to 15.0.1 CE, the config option 'enable metrics capture' will be missing in the sysconfigures system table.

CR:494278

CR Number:   494278 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Linux Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2010 Added to user documentation Description In the "Quick Installation Guide" for Linux, Document ID: DC00468-01-1502-01 we refer to setting the size of available shared memory by using the sysctl command (see http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00468_1502/html/aselxqig/CHDGAHJD.htm) We then correctly note that this change will not be permamnent (which is true) and that the command should also be entered into either the /etc/rc.d/rc.local file or /etc/init.d/boot.local (depending on platform) to make the change permamnet. Whilst both these options work, the published method to make such changes permanent is to add the commands to /etc/sysctl.conf which should be supported on all Linux platforms. For redhat confirmation see https://www.redhat.com/docs/manuals/enterprise/RHEL-4-Manual/pdf/Reference_Guide-450.pdf or for SuSe see https://secure-support.novell.com/KanisaPlatform/Publishing/495/3664772_f.SAL_Public.html

CR:494315

CR Number:   494315 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2008 Fixed Description If a query which uses distinct either explicitly or implicitly and no legal query plan is found and it is observed that there has been a timeout event during optimization then it may be due to this CR

CR:494321

CR Number:   494321 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2008 Fixed 21 Apr 2008 Fixed Description Migrate existing Sybase Central plugins on Vista.

CR:494324

CR Number:   494324 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2008 Fixed Description In rare circumstances, concurrent dump tran activity on a database may cause errors numbered 4218 and 692.

CR:494337

CR Number:   494337 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2008 Fixed 11 Jun 2008 Not reproducible with latest version of the product available as of Resolution Date Description The message "current process infected with 11" together with a stack trace which includes the modules 'cursor_process_error' and 's_handle' maybe be reported in the error log if a client session with a distributed transaction having open cursors had to be aborted.

CR:494369

CR Number:   494369 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for PIVOT and UNPIVOT operators.

CR:494397

CR Number:   494397 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2008 Fixed Description Updates to date columns of proxy tables mapped to direct connect servers cause the millisecond portion of the date to be set to zero.

CR:494407

CR Number:   494407 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2008 Fixed Description With abstract plan load on, sometimes the optimizer could stack trace

CR:494441

CR Number:   494441 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2008 Fixed Description insert-select statement fails with Cs-Lib datatype conversion error when the select portion of the statement is a union of proxy tables Workaround Description  Enable traceflag 11256 which disables CIS quickpass mode for insert-select into a local table from a proxy table. This traceflag only affects insert-select statements that insert into a local table while selecting from a proxy table(s).

CR:494474

CR Number:   494474 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2008 Fixed Description Index linkage corruption or deadlock when page is not transferred but read from disk in the remote node.

CR:494487

CR Number:   494487 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2008 Fixed 19 Mar 2008 Fixed Description A 2540 error might be reported by DBCC TABLEALLOC or DBCC CHECKALLOC following the recovery of a database after instance failure, when a REORG REBUILD command was being executed concurrently with failover recovery.

CR:494493

CR Number:   494493 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Implement virtual hash tables on all platforms, currently these are only supported on IBM plinux.

CR:494527

CR Number:   494527 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2008 Fixed Description The messages raised while doing consistency checks for cache operations and checks for cache configuration at startup were localised.

CR:494528

CR Number:   494528 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2008 Fixed Description In rare circumstances 871 error may be reported when backout from system table update

CR:494568

CR Number:   494568 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2008 Fixed Description A cluster with Job Scheduler enabled (in active or paused state) may hang during recovery after an instance shuts down, if the instance that shuts down was the instance running the Job Scheduler. Also, the shutdown of the cluster or instance when Job Scheduler is enabled result in server hang. This happens when the cluster is configured with only one engine. In the following scenarios, the server may hang : o A Cluster enabled with Job Scheduler may hang during shutdown if shutdown cluster was issued from the instance that was not running Job Scheduler o A Cluster enabled with Job Scheduler may hang during shutdown if shutdown instance was issued for the instance that was currently running the Job Scheduler from the other instance that was not running Job Scheduler. Workaround Description  Configure the cluster with at least two engines per instance. Set 'max online engines' and 'number of engines on startup' to at least '2'

CR:494587

CR Number:   494587 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2008 Fixed 26 Mar 2008 Fixed Description When running update queries against tables that are being dropped and recreated on the fly, ASE can run into a signal 11 while trying to compute the resultant row size. This generally happens under stress conditions.

CR:494605

CR Number:   494605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer asked for a tool/utility to read the contents of syslogs like LogAnalyzer from CA's. It seem that LogAnalyzer permits to read syslogs and mount the commands that will permit customer to apply the transaction again or to revert some transaction. There was CR 315186 but it was closed.

CR:494608

CR Number:   494608 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) 20 Mar 2008 Fixed Description When the the query plan chosen by the optimizer has: 1) A left semi-join using the hash join algorithm and 2) Filter predicates in addition to the join clause that can eliminate rows after they have matched on the joining column and 3) Rows with duplicate joining keys in the outer input stream to the hash join op and 4) At least two rows that match in the inner input stream, the second of which must fail the additional predicates the first time it matches the joining column and pass the additional predicate on a subsequent match of the joining column, too few result rows may be returned. Query plans with left semi joins usually appear for queries that have subqueries in an IN-predicate.

CR:494629

CR Number:   494629 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2008 Fixed 29 Aug 2008 Fixed 18 May 2012 Fixed Description In ASEPlugin, a new tab page "Localization" is added into server properties pages to allow the user to configure localization information for SDC server.

CR:494648

CR Number:   494648 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2008 Fixed Description Under rare circumstances, executing UPDATE INDEX STATISTICS on a table that has been unpartitioned might result in a 14108/20/4 error message "Could not find partition descriptor for objid xxxx, indid x, ptnid xxxxx in dbid x" followed that by a stacktrace that includes the following routines: ptn_get_pdes(), ptn_pdes_set(), open_partition(), update_statistics_col()

CR:494650

CR Number:   494650 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2008 Fixed Description Sometimes, when you try to login to ASE with the requested packet size equal to 'default network packet size', you may get a protocol packet error below and fail to connect to ASE. CT-LIBRARY error: ct_connect(): network packet layer: external error: There is a protocol packet error. An illegal length was received

CR:494686

CR Number:   494686 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Not reproducible with latest version of the product available as of Resolution Date Description Under exceptionally rare circumstances, sp_setpassword may hit Signal 11 in routine set_password(). This is benign and only affects the user running sp_setpassword.

CR:494690

CR Number:   494690 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2008 Fixed Description In sp_sysmon, "Total ULC Flushes" under Transaction Management gives the total PLC flushes. At present, the PLC discards are also displayed under the column "by Other" in the PLC flushes section. This leads to erroneous counter value for PLC flushes.

CR:494709

CR Number:   494709 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2008 Fixed 16 Jul 2008 Fixed Description The dataserver engine fails to restart after running CSMD in sybmon.

CR:494711

CR Number:   494711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2008 Fixed Description When there is a DDL statement in a batch, at the time executing DDL statement, entire batch is getting displayed instead of single DDL statement that is currently being executed.

CR:494720

CR Number:   494720 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2015 Already Fixed by Another CR Description It's a known issue caused by glibc version. It had been fixed in CR479363 in ASE From ASE15.0.2 ESD#3.

CR:494724

CR Number:   494724 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2008 Fixed Description ASE error report, when instance file descriptor usage exceed OS limit, does not provide the correct count.

CR:494742

CR Number:   494742 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2008 Fixed Description Occasionally wrong results or even procedure cache corruption could happen raising messages like "current process infected with 11" with routine names like 'mjutil_sdes_update' and 'memcpy' when a query joining two or more tables is executed in parallel inside a stored procedure, the configuration parameter "enable sort-merge join and JTC" is ON and the query uses one or more of the stored procedure parameters in the WHERE clause. Workaround Description  Disable configuration option "enable sort-merge join and JTC" or run the query in serial.

CR:494757

CR Number:   494757 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2008 Duplicate Description ASE hangs when connecting to a shutdown server configured with retry/delay Workaround Description  take out the retry/delay values on repserver entry in ASE's interfaces file

CR:494769

CR Number:   494769 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UNIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2011 EOL'd version. Not to be Fixed. 15 Nov 2011 Deferred Description Cursors are not able to use FRIDs to satisfy HASH_UNION operator.

CR:494870

CR Number:   494870 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description Error 3621 - intermittent and when ASE is set up for parallel processing. Workaround Description  Disable parallel processing.

CR:494894

CR Number:   494894 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2008 Fixed 19 Mar 2008 Fixed Description In a cluster system, a database checkpoint may take an unnecessarily long time if there are no concurrent database updates on the instance on which the checkpoint is executed, and many concurrent database updates on one or more other instances.

CR:494936

CR Number:   494936 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2008 Fixed Description ASE may return wrong results when a SQL statement satisfies the following conditions: 1) It has correlated subquery that does not get flattened (i.e. NOT EXISTS) 2) Subquery caching on (it's on by default) 3) It has two or more correlation columns that come from at least two different tables (i.e. a join under the left-most child of the LeSQFilterOp. 4) The values of correlation column(s) comming from the inner scan of the join must have varying lengths (i.e. some NULL values and some not NULL or different VARCHAR string lengths). 5) There must be multiple rows from the inner scan of the join that match the joining column of an outer scan row. 5) The ordering of the columns in the rows of the subquery cache has to have the corrrelation column from the inner side of the join placed before the column from the outer side. 6) You have to get some matches in the subquery cache. Also, this bug is most likely to happen after the size of the subquery cache has been adjusted down to a single row - but this is not a prerequisite. Workaround Description  Use trace flag 510 to turn off subquery caching.

CR:494981

CR Number:   494981 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2008 Fixed 21 Mar 2008 Fixed Description In a rare case where we hit log full condition while allocating an extent for the first time on an allocation unit, we might ask for an EX_LATCH while already holding it. The task will keep waiting indefinitely for the latch to be granted. This task can block other tasks too which tries to take latch on same allocation page.

CR:494982

CR Number:   494982 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2008 Fixed Description Running a query whose subquery referencing a table with functional index and another table from the outer query may hit SIG11 from pre__replace_fi(). Workaround Description  add table to the subquery, so subquery doesn't reference table in the main query

CR:495049

CR Number:   495049 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2008 Fixed Description When statement cache is in contention (full, and all cached statements are in use) and literal parameterization is on, stack trace may occur from opt_like_and() -> find_ep() when executing a statement with like clause against a literal value. Workaround Description  Disable literal autoparam on session level or server level.

CR:495052

CR Number:   495052 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2008 Fixed Description In rare circumstances for clusters with two or more instances, an error 891 may be raised by fail over recovery process.

CR:495055

CR Number:   495055 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2008 Fixed 18 Jun 2008 Fixed Description When sp_monitorconfig "number of user connections" is run, the result may show "Num_active" and "Max_Used" as 0.

CR:495066

CR Number:   495066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2008 Fixed 21 Mar 2008 Fixed Description On the Solaris platform, the loss of connectivity to the SAN may result in ASE core dumping and shutting down.

CR:495118

CR Number:   495118 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2008 Fixed 01 Apr 2008 Reservation Made 06 Oct 2008 Fixed Description Sub-optimal performance can be noticed with SELECT queries involving large IN lists. Use runtime traceflag -T15393 introduced in this CR for better performance.

CR:495149

CR Number:   495149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2008 Fixed 23 Mar 2008 Fixed Description ASE Cluster Edition server instances may hang or result in unexpected behavior when all the instances are heavily loaded with simultaneous access of same database objects.

CR:495163

CR Number:   495163 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2008 Fixed Description A 803 error "Unable to place buffer ..." may be reported in the error log together with a stack trace which includes the modules 'txst__read_node', 'gettxtpage' and 'bufkeep' when a SELECT command has been previously run to extract XML data. Alternatively, a 804 error "Unable to find buffer ..." may be reported in the error log together with a stack trace which includes the modules 'updtext', 'inserttext', 'alloctext' and 'bufunkeep' when an UPDATE command has been previously run to update XML data.

CR:495176

CR Number:   495176 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2008 Fixed 19 Jul 2010 Fixed 19 Jul 2010 One-off Provided Description In rare circumstances, determination of the database timestamp may inadvertently set it higher than it needs to be, increasing the likelihood of running out of timestamps for any database during its lifetime.

CR:495237

CR Number:   495237 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2008 Fixed 24 Mar 2008 Fixed Description In rare cases, recovery reports a 3478 error "During undo the page timestamp value is less than new timestamp from log...", when the size of a buffer pool had previously been altered using sp_poolconfig.

CR:495245

CR Number:   495245 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2010 Fixed 22 Jun 2010 Fixed Description "sample" command in sybmon can't print useful stack info on hpia64 platform

CR:495261

CR Number:   495261 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2008 Fixed 09 Feb 2010 Not a Bug 09 Sep 2008 Added to user documentation Description Add Evaluation install type and change SYSAM related panels.

CR:495328

CR Number:   495328 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2008 Fixed 05 May 2008 Fixed 13 May 2008 Fixed Description A rarely happened case: while trying to insert big rows into a table with all-page locking clustered index that has big size index row.

CR:495382

CR Number:   495382 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2012 Presently Not Targeted For Any Future Release Of This Product Description A query that selects from a derived table that converts the results of an aggregate function to a BIT column returns the resulting column to the client as an INT rather than a BIT

CR:495400

CR Number:   495400 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) 27 Mar 2008 Fixed Description When statement cache and literal parameterization are enabled, a query with like clause may run into stack trace in opt_like() -> find_ep() if the query is run under 'set noexec on'.

CR:495419

CR Number:   495419 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2008 Fixed Description A 7451 error, "Cluster threshold manager failed to rebuild log segment free page counts for database <dbname>(<dbid>) because log space info on dbinfo page is invalid...", might be reported during ALTER DATABASE after the last-chance threshold had been hit.

CR:495429

CR Number:   495429 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request to change convert() money to varchar w 4digits after decimal point.

CR:495431

CR Number:   495431 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2008 Fixed 25 Mar 2008 Presently Not Targeted For Any Future Release Of This Product 26 Mar 2008 Fixed Description Installmaster will encounter errors while creating the sp_clusterlogical stored procedure on a case insensitive server.

CR:495438

CR Number:   495438 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2008 Fixed Description GroupHashing operators with large input sets that are not partially sorted may do many useless comparisons. This can use a significant amount of CPU and slow down the query significantly as well. We now check to see if previous group checking is not effective (low hit rate). If not, the last group comparisons are disabled.

CR:495499

CR Number:   495499 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2008 Fixed 08 Apr 2008 Fixed Description The message "process infected with signal 11" may be reported in the error log together with a stack trace which includes the modules 'ptn_rowcopy' and 'ind__get_sysindrow' when the DBCC CHECKVERIFY command has been previously run.

CR:495524

CR Number:   495524 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2008 Fixed 30 Apr 2008 Reservation Made Description In rare cases, after an instance failure, the cluster could hang while trying to print a message from sysmessages before failover recovery had even started.

CR:495544

CR Number:   495544 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2008 Fixed 23 Apr 2008 Fixed Description When an online database has previously been used to bring an archive database online a timeslice error may be reported in the error log. In this case, the timeslice error will be accompanied by a stack trace which includes the modules 'online_database' and 'th__recover_altered_logsegment'. Workaround Description  increase the cpu grace time.

CR:495555

CR Number:   495555 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) 22 Aug 2008 Insufficient priority to fix Description This is a request to have Sybase HA cope gracefully with the following two scenarios: 1> primary node fails, processing moves to secondary (already works) 2> power fails to the secondary node 3a> power is restored and only the secondary reboots (primary hardware still offline) 3b> power is restored and both hardware nodes recover

CR:495569

CR Number:   495569 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2009 Not reproducible with latest version of the product available as of Resolution Date Description sybmon sample command gets a signal 11 when framewalking on linuxamd64 platform at the 15.0.2 ESD#2/3 levels. 15.0.2 GA release is ok. Workaround Description  none

CR:495587

CR Number:   495587 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) 20 Jun 2008 Fixed Description 12.5.x OpenClient that are using SSLPlus 3.x cannot connect to ASE15 or OpenServer with 2048bit RSA keys. Workaround Description  1) Instead of 2048-bit RSA keys, use 1024-bit or 512-bit keys. 2) Upgrade 12.5.x OpenClient to newer version that uses SSLPlus 5.

CR:495601

CR Number:   495601 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2008 Fixed 21 Apr 2008 One-off Provided 01 May 2008 One-off Provided Description ASE running with multiple engines may hang during shutdown.

CR:495644

CR Number:   495644 Product Name:   sybcluster Product Component:   Client Scripts Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2008 Fixed Description the first instance's information in sysservers table is not correct after upgrade.

CR:495681

CR Number:   495681 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2008 Fixed 21 May 2008 Presently Not Targeted For Any Future Release Of This Product 22 May 2008 One-off Provided Description A deadlock may occur on SYSCOLUMNS when concurrent sessions execute a CREATE VIEW command in the same database.

CR:495683

CR Number:   495683 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2008 Fixed Description Previously ASE Plug-in's table data columns would not sort unless all rows (to the limit) were fetched. This behavior has been changed so that column-sorting would always occur when user clicks the column. Note that the behavior is now consistent with DBISQL11's column-sorting feature.

CR:495684

CR Number:   495684 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2008 Duplicate Description Unable to sort by column when viewing table data Sybase Central 4.3.0.2437\2456

CR:495714

CR Number:   495714 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2010 Not reproducible with latest version of the product available as of Resolution Date Description An update of a column that is part of an index on an APL table fails in some circumstances with a 644 error. Workaround Description  (edwins) It looks like this query can be simplified by using UPDATE PS_DEPT_BUDGET SET DEPTID = XREF_TABLE_WRK.TO_VALUE1 FROM PS_DEPT_BUDGET,XREF_TABLE_WRK WHERE RECTYPE = 7 AND FROM_VALUE = PS_DEPT_BUDGET.DEPTID go although I have not tried it, it should only do one scan of XREF_TABLE_WRK (lxiong) turn on TF655 or 656

CR:495725

CR Number:   495725 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2008 Fixed 18 Apr 2008 Fixed Description In very rare cases, when large scale allocation is enabled, alter table lock change may run into 1142 error: "Invalid OAM Page 0. ..."

CR:495746

CR Number:   495746 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Win32s Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2008 Fixed Description Previously in DBISQL 9.0.2, multiple result sets' row numbers were not shown for each result set. This has been fixed in DBISQL 11.

CR:495747

CR Number:   495747 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Win32s Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2008 Duplicate Description In DBISQL when executing multiple select statements you only get one row count back from the last statement in the data frame for grid mode. For text mode, you do not get any row counts at all. select * from publishers select * from authors select * from authors where au_id = 'white' Even though you get all the data back in data windows that are tabs. You only get the last statement row count in grid mode. Text mode returns no row counts at all. Customer would like to get the row count listed for each select statement executed. in each tab with the results set./ Or, in text mode, at the end of each output or in a seperate tab with the messages. Target Version  15.0.2

CR:495751

CR Number:   495751 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2008 Fixed 02 Apr 2008 Fixed Description Explicit conversion from null numeric/float/decimal/money to univarchar/unichar may get 265 error or sig 11 from com__subexctnumetochar(). Workaround Description  check numeric column is NULL or not before call convert to univarchar e.g. CASE WHEN gvar_value_decimal is NULL THEN NULL ELSE CONVERT(univarchar(30), gvar_value_decimal) END

CR:495768

CR Number:   495768 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2008 Fixed Description Under rare circumstances, 644 or 2628 errors might be be reported when executing DML commands soon after node failover recovery has completed most of the work, but before it has written pages modified by recovery, to disk.

CR:495791

CR Number:   495791 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2008 Fixed Description Garbage collection for dataonly-locked tables in a local temporary database may be slow, resulting in unnecessarily increased space usage.

CR:495826

CR Number:   495826 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2008 Fixed Description The message "process infected with signal 11" may be reported in the error log together with a stack trace which includes the modules 'ptn_rowcopy' or 'ptn_nextcopy' along with 'ind__get_sysindrow' when previously running the DBCC commands EXTENTCHECK and LISTOAM.