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

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

CR:489408

CR Number:   489408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2008 Fixed Description A deadlock occurred when a task sleeps, while trying to remove an old buffer from the cache, on the pending validation status. The task itself might be holding a latch on allocation page while going to sleep and that can potentially cause an undetected deadlock.

CR:489410

CR Number:   489410 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2008 Added to user documentation Description In the ASE 12.5.1 'Performance and Tuning: Monitoring and Analyzing' Manual, Chapter 3, corrections are needed for the update statistics syntax on pages 49 and 51.

CR:489464

CR Number:   489464 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) 08 Sep 2008 Fixed Description In Cluster Edition of Adaptive Server, when an instance can not be booted, there is no supported way to drop its local user temporary databases from other active instances.

CR:489500

CR Number:   489500 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) 29 Jan 2008 Fixed Description In rare circumstances, Adaptive Server may hang while running sp_bindcache operation. Stack traces of spids involved in hang will contain function 'cm_bindremote_cache'.

CR:489515

CR Number:   489515 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 Feb 2008 Fixed Description On shared disk cluster, a select from a view with encrypted columns can be displayed as VARBINARY type instead of correct column type after BCP OUT with -C option is executed.

CR:489533

CR Number:   489533 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) 08 Jan 2009 Duplicate Description A monitoring and diagnostic table to provide a statistical breakup of inter-node messaging in Shared Disk Clusters.

CR:489536

CR Number:   489536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2008 Fixed Description 'set forced plan on' for query with outer join returns unwanted warning messages to the client Workaround Description  None (TF 15307 avoids the AP warning messages by turning off FORCEPLAN completely)

CR:489578

CR Number:   489578 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2008 Fixed Description In rare circumstances during an instance failure, clients connected to the failed instance may be routed to the wrong logical cluster upon failover.

CR:489764

CR Number:   489764 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2008 Fixed Description In rare circumstances the message "current process infected with 11" may be reported in the error log while doing a checkpoint.

CR:489846

CR Number:   489846 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2008 Fixed 01 Feb 2008 Fixed Description Outer join queries that incorporate a merge-join strategy may not return null-supplied rows. This will only occur if the merge-join outer-join op's inner stream returns no rows.

CR:489962

CR Number:   489962 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2008 Fixed Description Database recovery during failure handling may be slow on heavily loaded systems.

CR:489990

CR Number:   489990 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) 15 Feb 2008 Fixed Description In rare circumstances, the first access of a database in an instance, in a multi-instance cluster, could lead to corruption of the database log.

CR:489999

CR Number:   489999 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2008 Fixed 24 Dec 2008 Reservation Made Description Enhanced feature implementation for READTEXT/WRITETEXT on proxy objects. Local file contents can be transferred into remote file/directory/table and vice versa.

CR:490002

CR Number:   490002 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2008 Fixed Description An enhanced feature is implemented when a query READTEXT/WRITETEXT is executed which includes a TO/FROM 'filename'.

CR:490046

CR Number:   490046 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) 30 Jan 2008 Fixed Description When Rep Agent hits error 9266 ("Error in passthru packet:..."), it may fail to print part of the message. When this occurrs, a wrong dbid is reported as well as the message "Invalid pointer param number 3, pointer value 0x...".

CR:490079

CR Number:   490079 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to have sp_tempdb raise errors "Database does not exist" or "Database is not a tempdb" when passed a database name that does not exist or isn't a tempdb.

CR:490098

CR Number:   490098 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) 06 Feb 2008 Fixed 06 Feb 2008 Fixed Description Some parallel queries may require RunTime Adjustment (RTA) recompilation. This can occur if there are not enough worker threads initially available and the plan cannot be runtime adjusted. Some plans simply cannot be adjusted to use fewer threads and in other cases there may still not be enough threads available to perform RTA. In these cases, the query must go through RTA recompilation (serialization). This will generate a SEGV when the initial parallel plan is released if the user has enabled query metrics, statistics io, or statistics plancost. Workaround Description  Avoid RTA recompilation by reconfiguring the server to have more "number of worker threads". Alternatively, disable query metrics, statistics io, or statistics plancost if they are on.

CR:490100

CR Number:   490100 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2008 Fixed Description Stacktrace may occur when accessing proxy tables mapped with uppercase remote server names in noaccents sortorder servers. Workaround Description  Match case on server name on the create proxy_table ... at ... definiton to the logical server name on sysservers.

CR:490132

CR Number:   490132 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 Feb 2008 Fixed 28 Mar 2008 Reservation Made Description Node failover recovery may mistaken reset the uncommitted status of an index row. This may result in the index becoming inconsistent.

CR:490167

CR Number:   490167 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) 13 Feb 2008 Fixed 14 Feb 2008 Fixed 13 Feb 2008 Fixed 15 Feb 2008 Fixed Description When "exec_procedure" auditing option is enabled, auditing record from procedure sp_extrapwdchecks will display sensitive password information in plaintext.

CR:490206

CR Number:   490206 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) 15 Apr 2008 Not a Bug Description Need help determining why ASE is raising error 3702

CR:490214

CR Number:   490214 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) 06 Mar 2008 Fixed 09 May 2008 One-off Provided Description After a 12.5.x to 15.0.2ESD#2 migration, performance regressions could be produced by doing a full scan instead of a direct access of the grouping worktable produced by vector aggregation in a non-correlated nested subquery.

CR:490216

CR Number:   490216 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) 15.1 ESD #1 06 Feb 2008 Fixed Description When the cluster undergoes failover, the checkpoint request may get aborted with 3514 error

CR:490228

CR Number:   490228 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a stored procedure that provides information about created workspaces in dbccdb.

CR:490239

CR Number:   490239 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) 22 Feb 2008 Fixed Description literal parameterization results in literals being replaced by parameters since the statement will be placed into the statement cache, with a stored procedure wrapper. The parameter is defined as the max length for a datatype e.g. for an integer it would be 4. However for columns with smaller lengths than the max length for a datatypes (e.g. tinyint) there will be a mismatch on the search argument for an index lookup which could result in suboptimial plans for the greedy algorithm. The change will allow the search argument for an index to be considered. It may affect queries with greater than 6 tables in the query, in which indices have columns whose length is less than the max length of the datatype. If timeout occurs in the optimizer, then a suboptimial plan may occur. Workaround Description  A few workarounds: 1.trace flag 15363 to disable the fix of 465375 or 2. 'set table count 5' or 3. 'set statement_cache off' or 4. add a plan clause: plan '(use optgoal allrows_oltp)' at the end of the query, the ASE will not cache this query with the plan clause

CR:490260

CR Number:   490260 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2008 Fixed 21 Feb 2008 Fixed 21 Feb 2008 Fixed 27 Feb 2008 Presently Not Targeted For Any Future Release Of This Product Description Large join query may take a long time to compile under parallel mode. Also search engine timeout may not happen even when the procedure cache consumption by the search engine has reached the timeout limit.

CR:490318

CR Number:   490318 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) 09 Oct 2012 Presently Not Targeted For Any Future Release Of This Product Description RepAgent can be configured to use a send buffer size of 32k and 64k bytes.

CR:490335

CR Number:   490335 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) 06 Feb 2008 Fixed Description Error 4057 is returned when end users of encrypted data with decrypt permission are not users of the key database.

CR:490382

CR Number:   490382 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) 05 Feb 2008 Fixed 05 Feb 2008 Fixed Description When a join query joins a varchar/varbinary column which is wider than 255, with another varchar/varbinary column which is less than 255, the query may hang.

CR:490390

CR Number:   490390 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 Description The message "Current process (0x4d004d) infected with signal 11 (SIGSEGV) "in the module 'login__ldapauth' may be reported in the error log if an engine is onlined after offlining it. No user connections will be accepted on this newly onlined engine when LDAP authentication is enabled.

CR:490430

CR Number:   490430 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) 02 Apr 2008 Fixed 22 Feb 2008 Fixed Description Deferred compilation of the query using a table created in the same procedure may sometimes result in unnecessary renormalization of the stored procedure. Similary if the procedure is executed by different users the object name resolution may not be done correctly raising permission errors or breaking procedure execution with 'too many recompilations' warning message.

CR:490433

CR Number:   490433 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2008 Bundled Request Description The Create Cluster command in Sybcluster or Sybase Central will fail with the message 'Exception invoking method createCluster' if the cluster name contains less than three characters. Workaround Description  Use a cluster name that is three characters or longer in length.

CR:490495

CR Number:   490495 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2008 Fixed 07 Feb 2008 Fixed Description When the execution of sp_bindcache fails with error 861 because an open cursor on the target table exists, subsequent sp_bindcache or utility execution will fail since Adaptive Server will complain that there is a level0 scan query active on the target table. Alternatively, a level0 scan query will fail since Adaptive Server will complain that there is a utility execution active on the target table.

CR:490502

CR Number:   490502 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) 13 Feb 2008 Fixed Description The left outerjoin hash operator may not return null-supplied rows if the inner stream is empty and returns LRET_ENDOFSCAN when opened. Note that the rows will be returned if the inner stream returns LRET_SUCCESS on open and LRET_ENDOFSCAN on the first next call. The later scenario is more prevalent.

CR:490540

CR Number:   490540 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) 12 Feb 2008 Fixed Description In rare circumstances, an undetected deadlock may occur when DBCC CHECKSTORAGE is executed concurrently with a badly partitioned application that is being run on more than one instance. The stack trace of the DBCC thread will show the routines pchk_oam_work() and getpage_remote().

CR:490570

CR Number:   490570 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) 15 Feb 2008 Fixed 21 Feb 2008 Fixed Description Under certain circumstances triggers which assign variables using select which are fired as a result of dynamic SQL statements called from embedded C programs may raise error 7354 depending on the contents of the trigger. Workaround Description  To work around the problem, replace the statement EXECUTE IMMEDIATE :sql_str; with PREPARE and EXECUTE statements. For example, replace EXEC SQL EXECUTE IMMEDIATE :str; with EXEC SQL PREPARE stmt1 from :str; EXEC SQL EXECUTE stmt1; Alternatively the traceflag 7730 can be set on the server and again no errors are raised.

CR:490588

CR Number:   490588 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) 06 Feb 2008 Fixed 07 Feb 2008 Presently Not Targeted For Any Future Release Of This Product Description For DELETE and UPDATE queries that include a self-join of the target table, but will only qualify a single row, ASE was incorrectly choosing to update the row in deferred mode instead of in direct mode. Direct mode results in improved performance.

CR:490592

CR Number:   490592 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2009 Fixed 03 Sep 2009 Fixed Description The query "select * from monWaitEventInfo" does not show the running process row except WaitEventID = 0 condition.

CR:490622

CR Number:   490622 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2008 Fixed Description ASE Cluster Edition server instance may exit with signal-11 error under high loads and rare scenarios when accessing same database objects from multiple instances. Target Version  15.1 ESD #1

CR:490689

CR Number:   490689 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) 04 Feb 2008 Fixed Description system_view is always set to 'instance' after executing stored procedure sp_poolconfig. For internal use only: Included consistency checks for cache configuration operations. Cache configuration will fail if consistency checks fail.

CR:490690

CR Number:   490690 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) 04 Feb 2008 Fixed 17 Mar 2008 Duplicate Description sp_cacheconfig fails with out any error message. No messages are found in errorlog.

CR:490767

CR Number:   490767 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2008 Bundled Request Description Previously DBISQL failed to edit datetime field. This has been fixed in DBISQL 9.0.2 Build 3620. Workaround Description  Manually update the data.

CR:490808

CR Number:   490808 Product Name:   Adaptive Server Enterprise Product Component:   PowerTransfer Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2008 Fixed Description PowerTransfer does not support the Sybase traditional "-I" parameter to specify an alternate location for the interfaces file.

CR:490822

CR Number:   490822 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) 23 Feb 2008 Fixed Description On heavily loaded systems an inappropriate cluster view failure may occur due to dropped or out of order membership messages.

CR:490850

CR Number:   490850 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2008 Fixed Description A 100002 error, 'upspawn: no more process slots available' may be reported error log when Adaptive Server runs out of user connections. Workaround Description  Increase 'number of user connections' and 'number of alarms' by 100.

CR:490860

CR Number:   490860 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) 11 Feb 2008 Fixed Description In rare circumstances for clusters with two or more instances, Adaptive Server may raise error 821 while executing database binding using sp_bindcache.

CR:490866

CR Number:   490866 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) 11 Mar 2008 Fixed 16 Sep 2009 Fixed 03 Apr 2008 Added to user documentation 16 Sep 2009 Fixed Description Increased the maximum limit for 'global cache partition number' configuration parameter to 128.

CR:490873

CR Number:   490873 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2008 Duplicate 23 Sep 2008 Duplicate 10 Sep 2012 Fixed Description The message "current process infected with signal 10 (SIGBUS)" in the module 'vbit_set' together with a stack trace which includes the modules 'rec_analyze_log' and 'rec_onlinetime' may be reported in the error log during ONLINE DATABASE on the HPUX 64 bits platform. Workaround Description  Use diagserver instead of dataserver binary

CR:490902

CR Number:   490902 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2008 Fixed Description The message returned from "sp_cluster profile, set" displays the values and settings of a profile which have been set.

CR:490927

CR Number:   490927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2008 Fixed 12 Feb 2008 Fixed Description CIS relocated join fails when joining a proxy table with a temporary table.

CR:490947

CR Number:   490947 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) 09 Feb 2008 Fixed 13 Feb 2008 Fixed Description Wrong join order on proxy tables with very small local tables.

CR:490949

CR Number:   490949 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) 05 Aug 2008 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description Error message 207, "Invalid column name 'spareN'." is reported when running UPDATE STATISTICS on proxy tables mapped to ASE 15.0 servers. Workaround Description  Traceflag 11229 will turn off the import statistics feature. The result will be that we will pull over the data and calculate the statistics locally. If this is impractical because tables are large, then use traceflag 11229 and 11209 to import only the rowcount.

CR:490950

CR Number:   490950 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) 13 Feb 2008 Fixed Description When statement cache is on, if a query that uses local variable is run under 'set noexec on', optimizer might choose a sub-optimal plan.

CR:490964

CR Number:   490964 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) 03 Mar 2008 Fixed Description sp_estspace reports wrong results for DOL tables with max_rows_per_page option. This option is ignored while creating the DOL tables and is not reflected in sp_estspace.

CR:490966

CR Number:   490966 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) 03 Mar 2008 Fixed Description Login attempts may fail with a message "ks_falloc: Cannot allocate using ubfalloc(rnetmempool, nnn)." if clients use large network packet size under heavy load environment. Workaround Description  (1) Use only default network packet size if it's acceptable. (2) Increase additional network memory till this error gets disappeared. But it can not be estimated.

CR:490968

CR Number:   490968 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2008 Fixed Description (Internal Only) In SMP version of Adaptive Server, each client, that does not have any temporary datbase bindings, causes error 10503 to be logged in error log when it connects to the server. The reason it is marked as 'internal only' is because this problem is seen in SMP version that is built off asecluster3 branch and that product is never released to the market (at least so far).

CR:490975

CR Number:   490975 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) 20 Feb 2008 Fixed Description In rare circumstances the message "current process infected with sig 11" may be reported in the error log while shutting down the server.Stack trace reported will contain the string "ind__itagsetup".

CR:490999

CR Number:   490999 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for automatic execution of stored procedures at start up (recovery triggers)

CR:491030

CR Number:   491030 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) 11 Feb 2008 Fixed Description Raise error 19874 if user does not pass the instance name for instance-specific-only configuration parameters.

CR:491032

CR Number:   491032 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) 12 Feb 2008 Fixed 13 Feb 2008 Fixed Description round() function may give incorrect results when 'enable literal autoparam' is turned on.

CR:491056

CR Number:   491056 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2008 Fixed 07 Apr 2008 Reservation Made Description This is discovered through internal testing and no customer reported it so far. For now, we disallow 'set ciphertext on/off' command within an instead-of trigger. If the ciphertext setting when an instead-of trigger is executed is different from the time when it is compiled, the instead-of trigger will be recompiled.

CR:491060

CR Number:   491060 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Tables Status:   Closed OS:   NA Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2008 Added to user documentation Description Request to enhance documentation on sysservers system table to include new srvstatus2 column values. Currently only bit 0x01 is in use, indicating that the remote server is configured to handle fully qualified table name references to any other server.

CR:491075

CR Number:   491075 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) 21 Feb 2008 Fixed Description The error 605 followed by a stack trace including the modules pchk_oam_check() and pg_latchoam() could happen if DBCC CHECSTORAGE is executed concurrently with DDL on a multinode server in a badly partition application.

CR:491079

CR Number:   491079 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) 13 Mar 2008 Fixed Description Enhancement to showplan output to print statement cache ssql_id with the plan. Example: STEP 1 The type of query is EXECUTE. Executing a newly cached statement (ssql_id=12345678912345678) STEP 1 The type of query is EXECUTE. Executing a previously cached statement (ssql_id=12345678912345678)

CR:491081

CR Number:   491081 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2008 Fixed 19 Feb 2008 Fixed Description DBCC ORPHANTABLES may not be able to drop temporary tables orphaned by a problem in distinct sessions; and in such situations, ORPHANTABLES will leave the temp tables orphaned without reporting that there was a problem dropping them.

CR:491082

CR Number:   491082 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) 09 Feb 2008 Fixed 12 Feb 2008 Fixed 26 Aug 2008 Fixed Description Under rare circumstances index statistics may fail to import during create proxy_table commands.

CR:491127

CR Number:   491127 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2008 Fixed Description Sybmigrate may fail against 15.0.2 or higher when translating sysservers due to added column srvstatus2. Workaround Description  Possible workaround: Copy all user-defined sysservers entries to a safe place, temporarily delete those entries from sysservers. Restore the rows after the migration.

CR:491163

CR Number:   491163 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 Sep 2008 Fixed Description Outer join queries that incorporate a merge-join/hashjoin strategy may not return null-supplied rows. Workaround Description  Use a different plan by:- e.g. set index_union 0 (or plan "( use index_union off)") Or:- set plan optgoal allrows_oltp Or:- for this simplified query just drop the AP.

CR:491173

CR Number:   491173 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 sp_configure 'global cache partition number' doesn't calculate memory usage correctly which can lead to the option being changed when there is not enough memory available for the ASE to boot with that configuration.

CR:491219

CR Number:   491219 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 SET string_rtruncation ON raises a 9502 error when truncating a single literal value, but not a concatenated value of equal length, or the result of a convert(), etc.

CR:491220

CR Number:   491220 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) 04 Apr 2008 Fixed 08 Apr 2008 Fixed Description Providing bigints as a parameter to a print statement on linux may give a wrong result

CR:491232

CR Number:   491232 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) 22 Apr 2008 Fixed Description When we create a database with log on option, and then if we alter database to same log device (using override option) more than once, the extended device fragments (except the first extended fragment) are marked as "data and log".

CR:491253

CR Number:   491253 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 Feb 2008 Fixed Description In rare circumstances, Adaptive Server may hang while running sp_bindcache operation. Stack traces of spids involved in hang will contain function 'cm_bindremote_cache'.

CR:491256

CR Number:   491256 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) 24 Mar 2008 Fixed 05 May 2008 One-off Provided Description In rare circumstances, a process might hang soon after an index page is split in an all-pages locked table. Workaround Description  Disable link split optimization using TF 12302.

CR:491277

CR Number:   491277 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) 26 Mar 2009 Fixed 26 Mar 2009 Fixed Description The message "Current process infected with 11" together with a stacktrace which includes the modules 'mda__check_waiting_procs' and 'mda_populate_monState' may be reported in the error log when a SELECT query is executed against the monState MDA table. Workaround Description  n/a

CR:491278

CR Number:   491278 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 Feb 2008 Fixed Description The "--diag=locks" command to qrmutil displays no output

CR:491286

CR Number:   491286 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2008 Fixed 15 Feb 2008 Fixed Description When Traceflag 16402 is enabled and a cluster action is performed, an error will shutdown the servers.

CR:491327

CR Number:   491327 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2008 Fixed Description On Solaris platform, ASE Cluster Edition server instance may crash with Sig-Bus (Signal 10) error when printing some diagnostic information.

CR:491353

CR Number:   491353 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2008 Fixed 18 Feb 2008 Fixed Description A 4801 error will be reported when an Open Client program calls bcp_init() with a name of the form "tempdb..#<temporary_table_name>". Workaround Description  Remove "tempdb.." from bcp_init() if possible.

CR:491363

CR Number:   491363 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2008 Fixed Description Error messages related with internal failure during the calculation of GAM related information in DBTABLE are not properly raised.

CR:491401

CR Number:   491401 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2009 Insufficient priority to fix Description Request to include fix for LDAP CR 415917 in 12.5.4 code. Target Version  To Be Determined

CR:491411

CR Number:   491411 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2009 Fixed 18 Jan 2009 DEFER Description Monserver reports event lost when using Reentrant OCS lib

CR:491427

CR Number:   491427 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) 27 Feb 2008 Fixed Description When statement cache is on, and a cached query is run twice with invalid parameter/datatype, 706 error might be raised.

CR:491440

CR Number:   491440 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 Feb 2008 Fixed Description Shutting down cluster with nowait when cluster failover is under way may cause random stack trace.

CR:491453

CR Number:   491453 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2008 Fixed 20 Feb 2008 Fixed 28 Feb 2008 Fixed 22 Apr 2008 Fixed Description Update Sybase Central 4.3 to Build 2468 to better support Windows Vista. Interactive SQL is updated to Build 3620.

CR:491473

CR Number:   491473 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) 15 Feb 2008 Fixed Description A deadlock may happen when running DBCC CHECKSTORAGE concurrently with DDL statements.

CR:491499

CR Number:   491499 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2008 Fixed Description No usage for "sp_cluster logical, 'set', <lcname>, login_distribution" listed in "sp_cluster logical, help".

CR:491515

CR Number:   491515 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 for greater protection against accidental deletion of sysloginroles table and/or an easier method of recovery from such an error.

CR:491521

CR Number:   491521 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) 14 Oct 2013 Insufficient priority to fix Description Feature request to have traceflag 3662 also dump sql to the errorlog when a resource governor limit is reached and the action type is "warning"; it currently only does so for the more severe actions.

CR:491593

CR Number:   491593 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 May 2008 Fixed 19 May 2008 Reservation Made Description When like clause contains expressions such as 'a12' + '%', the query may run slower where a table scan is choosen instead of index scan.

CR:491600

CR Number:   491600 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) 19 Jun 2008 Fixed 23 Aug 2010 Presently Not Targeted For Any Future Release Of This Product 26 Sep 2011 EOL'd version. Not to be Fixed. Description Foreign key constraint is not checked when isolation level set to 1.

CR:491604

CR Number:   491604 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2008 Fixed Description A deadlock can be found when running DBCC CHECKSTORAGE concurrently with DDL statements.

CR:491656

CR Number:   491656 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) 20 Feb 2008 Fixed Description Linux I/O fencing occasionally fails with interrupted system calls.

CR:491683

CR Number:   491683 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) 27 Feb 2008 Fixed Description When an instance is joining the cluster, concurrent execution of databae DDL commands such as ALTER DATABASE from another instance may encounter 8204 error.

CR:491694

CR Number:   491694 Product Name:   sybcluster Product Component:   Cluster Plugin Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 310 17 Mar 2008 Fixed Description Monitor Server cannot be started using the generated startup script. Script returns requested server name not found error.

CR:491695

CR Number:   491695 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2008 Fixed 05 Apr 2010 Fixed 08 Apr 2010 Fixed 26 Apr 2010 Fixed 24 Jun 2010 Fixed Description Feature Request to implement to run sqlupgrade with ASE in single user mode.

CR:491697

CR Number:   491697 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) 27 Mar 2008 Fixed Description New values may be calculated for materialized computed columns when the migration utility is used to migrate tables to a new server.

CR:491727

CR Number:   491727 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) 23 Feb 2011 Fixed 22 Feb 2011 Fixed 27 Dec 2012 Insufficient priority to fix 24 May 2013 Fixed 21 Jan 2014 Port Not Needed Description In rare circumstances, after HA-failover, a message "infected with signal 11" in module 'astc__h_ase_sendrpc' may be reported in the ASE errorlog, along with a stacktrace. Workaround Description  - Identify prepared transactions on secondary. sp_transactions "state", "prepared" - The external transaction manager to issue commit / rollback for such transactions. commit xactname Alternatively, if all the branches of DTM are ASE one can use the dbcc interface as well to complete the prepared transaction. dbcc complete_xacts - Reissue the failback operation

CR:491806

CR Number:   491806 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) 07 Apr 2008 Fixed 03 Apr 2008 Fixed 07 Apr 2008 Reservation Made Description An undetected deadlock may happen when an INSERT-SELECT (or SELECT-INTO) statement is executed in parallel, LOB datatype (text, binary, unitext) is involved and other session is concurrently updating the source table. Workaround Description  Run the statement in serial mode.

CR:491878

CR Number:   491878 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 Feb 2008 Fixed Description Under rare circumstances, ASE may report 605 errors related to the Sysgams system table. This may happen after the "LOAD DATABASE" command has been executed for a database being greater than 63Gb.