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

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

CR:664980

CR Number:   664980 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2011 Fixed Description When option show_sqltext is turned on some sql statements like use db1, drop proc or drop table, exec proc1 are not traced properly, message like "No useful sqltext available" gets printed instead of the actual sql executed.

CR:664984

CR Number:   664984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2011 Fixed Description When executing an INSERT-SELECT query from a proxy table having a LOB column into a local table, a NULL value may be inserted into a LOB column on the local table if a cursor is opened on any proxy table. Workaround Description  Add -T11239 into a command line in the RUN server file. But it can drop insert-select performance.

CR:665006

CR Number:   665006 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Separate Audit Event for ASE and Backup Server

CR:665043

CR Number:   665043 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2011 Fixed 06 May 2011 Fixed 28 Jun 2011 Fixed 25 Jun 2012 Bundled Request 26 Jun 2012 Fixed Description The following is observed when 'restricted decrypt permission' is configured: (1) a table owner who has decrypt permission on an encrypted column through group membership is not permitted to select decrypted data from the column. (2) sso_role who should have implicit decrypt permission is not permitted to select decrypted data from the column and is not permitted to insert into the column when trigger present on the table (3) a table owner who has been granted decrypt permission through a user defined role is not permitted to insert data into the column when trigger present on the table

CR:665170

CR Number:   665170 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2011 Fixed Description sp_shmdumpconfig raises message 18502 when an "error" dump type is specified when "message" should have been specified. This CR is a feature request to find ways to reduce the confusion between the two types of dump conditions.

CR:665201

CR Number:   665201 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2011 Fixed 01 Jun 2011 Fixed Description The message "current process infected with 11" in the module 'rec__ctx_cleanup' together with a stack trace which includes the modules 'dsinit' and 'rec__backout' may be reported in the error log during ASE startup if a 708 error, "There is insufficient system memory to run kernel task. spid <value>, kpid <value>." was previously reported in the error log.

CR:665247

CR Number:   665247 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Control GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2011 Duplicate Description A segmentation violation occurs with utilities certreq and certpk12 when the password is provided as a parameter on the command line.

CR:665251

CR Number:   665251 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2011 Added to user documentation Description DocCR : the style 14/114 is listed twice with different specs at BulidingBlock manual.

CR:665257

CR Number:   665257 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 Control GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2011 Fixed 15 Apr 2011 Fixed 25 May 2011 Fixed 25 May 2011 Fixed 12 Oct 2011 Bundled Request 01 Oct 2012 Bundled Request 09 Nov 2012 Fixed Description Under certain circumstances, ASE may fail to boot under the UTF-8 nocase sort order and an 8211 error "Mismatch found between the name and id descriptor hash table for table..." may be seen. Workaround Description  Use -T8211 to revert to the old DES hash computation algorithm.

CR:665266

CR Number:   665266 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2011 Fixed Description In an HA environment if sp_addexternlogin issued on a HA server to add an externlogin for a non-ha server the following message will be issued by the companion server: Msg10330,Level14,State1: Server'gree1_22760',Procedure'sp_attrib_notify': EXECUTEpermissiondeniedonobjectsp_attrib_notify,databasesybsystemprocs, ownerdbo

CR:665284

CR Number:   665284 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2013 Presently Not Targeted For Any Future Release Of This Product 11 Dec 2012 Reservation Made 04 Dec 2012 Fixed 01 May 2013 One-off Provided 01 May 2013 Port Not Needed Description The message, "Current process infected with signal 11" followed by a stack trace that includes the module Partitions::initHintsForDegree() may be reported when a remote procedure is executed with the recompile option. Workaround Description  Turning on compatability mode, either at server level or within the procedure works around the issue.

CR:665367

CR Number:   665367 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   11.6.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: support Sysam license server on a VMWare VSphere win2008 x64 SP2 that can host multiple licenses for multiple platforms and products.

CR:665426

CR Number:   665426 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Control GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2011 Presently Not Targeted For Any Future Release Of This Product Description langinstall for non-us_english languages gives errors because several new messages have not yet been translated in their server.loc files.

CR:665525

CR Number:   665525 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2012 Presently Not Targeted For Any Future Release Of This Product Description Error 221 is raised when UNION is applied to a view containing an outer join returning a BIT value from the inner table. The same error is not raised when tables are used directly. Workaround Description  Convert to TINYINT in place of BIT. (using ISNULL() does not work as a workaround).

CR:665639

CR Number:   665639 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows 2008 Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2011 Fixed Description When 'statement cache' and 'literal autoparam' are configured on ASE the @@identity retains a non-zero value after an INSERT into a table that contains no IDENTITY column. Workaround Description  Disable 'statement cache' and 'literal autoparam'.

CR:665651

CR Number:   665651 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2011 Fixed Description If server has 'capture missing statistics' enabled, and if multiple parallel threads execute queries involving a column for which stats are missing, then all such threads would try to insert the missing stats; one of the threads would succeed, and the others would get 2601 error leading to transaction and command rollback.

CR:665658

CR Number:   665658 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Infected with 11 in EquivClass::eqcFindPdTreeLogProps Workaround Description  1. Set optimizer level to ase_default or 2. Set traceflag 15363 or set alternative_greedy_search off

CR:665666

CR Number:   665666 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2011 Fixed 11 Apr 2011 Fixed Description Specifying "as template" in a sql select list incorrectly reports a syntax error. Workaround Description  select c1 template from table or select c1 as "template" from table

CR:665715

CR Number:   665715 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2011 EOL'd version. Not to be Fixed. 10 May 2012 Fixed 26 Sep 2012 Fixed 07 Nov 2012 Fixed Description The message "current process infected with 11" in the module 'bufdlink' together with a stack trace which includes the modules 'pg_allocate' and 'bufpindirty' may be reported in the error log when a table was in the process of being created and ASE has previously hit a 1204 error "ASE has run out of LOCKS. Re-run your command when there are fewer active users, etc.".

CR:665786

CR Number:   665786 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Windows Status:   Closed OS:   Microsoft Windows NT Original Version:   15.5 ESD #6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2011 Added to user documentation Description Sybase installation account on Windows must have membership of the 'Adminstrators' group to allow creation of Windows Services entries.

CR:666213

CR Number:   666213 Product Name:   Adaptive Server Generic Docs Product Component:   Other Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2011 Presently Not Targeted For Any Future Release Of This Product Description The 15.x Monitor Server User's Guide indicates that a login named mon_user is installed on windows. This login is no longer installed or used as of 15.0.

CR:666239

CR Number:   666239 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2012 Fixed Description The limit for cache partitioning has been extended from 128 to 256.

CR:666245

CR Number:   666245 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2011 Added to user documentation Description doc bug: CR 490866-3 doesn't show global cache partition limit as 128

CR:666362

CR Number:   666362 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2011 Fixed 27 Jul 2011 Fixed 17 May 2011 Presently Not Targeted For Any Future Release Of This Product Description A signal 11 may be reported with a call stack involving the modules 'do_bt_release_rlocks' and 'rec_undo_session' while accessing the buffer address from an address lock of an APL page.

CR:666371

CR Number:   666371 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2011 Fixed 19 Apr 2011 Reservation Made Description TF2792 blocking on user table for select operation.

CR:666375

CR Number:   666375 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2011 Fixed 15 May 2011 Reservation Made 21 Jun 2011 Fixed 28 Sep 2011 Reservation Made 26 Mar 2014 Already Fixed by Another CR Description New interface sp_chgattribute <objectname>, 'ptn_locking', 0/1 to enable/disable partition locking

CR:666423

CR Number:   666423 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) 14 Apr 2011 EOL'd version. Not to be Fixed. Description A 644 error and the message "Invalid DOL data row pointer ... must be the forwarded row location" is raised when using ALTER TABLE to add an IDENTITY column to a datarow table that has forwarded rows. Run reorg forwarded_rows and try the ALTER again. Workaround Description  Run reorg forwarded_rows and try the alter again.

CR:666460

CR Number:   666460 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2011 Fixed 01 Jun 2011 One-off Provided 02 Jun 2011 Fixed Description Parallel BCP connections on an indexed DOL table might block each other while loading data into the same data partition.

CR:666556

CR Number:   666556 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2012 Fixed 21 Aug 2012 Reservation Made Description Performance of sp_spaceused procedure is very slow when executed to get the space metrics for the entire database, especially so for databases with a very large number of objects and indexes. Improve the performance of this procedure by applying server-side changes along with a re-work of the procedure's logic. A new installmaster along with new ASE binary is needed to deliver this performance improvement. (The stored procedure changes alone are not sufficient).

CR:666577

CR Number:   666577 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2011 Fixed 09 Aug 2011 Fixed 15 Sep 2011 Fixed 16 Sep 2011 Fixed Description Cannot access Monitor Server counters from Sybase Central when SQL Server names are different in client and server side interfaces file.

CR:666597

CR Number:   666597 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2013 Fixed Description New Feature Request ... add indicator to monCachedProcedures to show active entries

CR:666643

CR Number:   666643 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances, the extra convert() added on numeric columns in SELECT-list with UNION ALL can improve the compilation performance in ASE 15.x.

CR:666702

CR Number:   666702 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Run 3 or more session running unmount database can dead lock on sysdevices. Workaround Description  make your unmount database command in a sequential way.

CR:666720

CR Number:   666720 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2011 Fixed 25 May 2011 Fixed Description If an index whose length is larger than 32767 is defined on a DOL table, some problems may be encountered when using the index.

CR:666728

CR Number:   666728 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2011 One-off Provided 04 Oct 2012 Fixed 04 Oct 2012 Fixed 24 Apr 2013 Presently Not Targeted For Any Future Release Of This Product Description Update the Open Server Components of ASE to provide essential Open Server vulnerability fixes.

CR:666814

CR Number:   666814 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2011 Fixed 27 Apr 2011 Reservation Made Description Executing a dynamic SQL query may hit SIGSEGV along with stack trace involving modules sqt_relocate(), sqt_fix_xoltp() and tdsrecv__dynexec_xoltp().

CR:666828

CR Number:   666828 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2011 Not a Bug Description New Feature to use different method to determine if cluster takeover is possible.

CR:667025

CR Number:   667025 Product Name:   Adaptive Server Enterprise Product Component:   sqlloc Status:   Closed OS:   all Original Version:   15.7 CGA Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2011 Fixed 25 Apr 2011 Fixed 25 Apr 2011 Fixed Description sqllocres reports sort order "binary" is not valid for character set "utf8".

CR:667065

CR Number:   667065 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2011 Fixed 05 Oct 2011 Fixed 31 Oct 2011 Fixed 14 Oct 2011 Reservation Made Description Under some rare conditions, queries with computed columns could cause stack traces involving the module 'add__computedcol' when using the table with computed columns.

CR:667124

CR Number:   667124 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The current documented limit of 192 referential constraints is too low for the customers application and they would like this increasing.

CR:667341

CR Number:   667341 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The FR required to allow BCP (and other ASE utilities) write the outputs to remote locations.

CR:667487

CR Number:   667487 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2012 Fixed Description When "procedure cache size" configuration key value is increased, Procedure Cache Pool is not honoring the Engine Local Cache trace flags while allocating the extra pages to engine.

CR:667552

CR Number:   667552 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2011 Fixed Description sp_sysmon might report wrong engines when some engines are offline.

CR:667575

CR Number:   667575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2011 Fixed 16 Jun 2011 Fixed Description Allow object owner to run sp_showoptstats besides SA role.

CR:667653

CR Number:   667653 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2011 Fixed 27 May 2011 Fixed Description A query with disjunctive clause on a range or list partitioned table can produce wrong results due to incorrect partition elimination.

CR:667691

CR Number:   667691 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2011 Presently Not Targeted For Any Future Release Of This Product Description An infected with 11 may occur with routines fastLoop and FrameNExecuteHelper on the stack while using JAVA.

CR:667726

CR Number:   667726 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2011 Fixed Description sp_helprotect truncates object and column names which are greater than 30.

CR:667751

CR Number:   667751 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2012 Fixed 03 Oct 2012 Fixed 16 Oct 2012 Fixed Description Support for UNIX Domain Sockets for ASE has been added for the Linux and Unix platforms. Adaptive Server Enterprise version 15.7 ESD#4 and later now support the UNIX domain socket communication, which avoids some of the overhead the TCP protocol incurs. Similar to other protocols, include the AF_UNIX protocol in the interfaces file for clients to connect to Adaptive Server. The syntax for an AF_UNIX in the interfaces file is: master afunix unused //<hostname>/<pipe>

CR:667894

CR Number:   667894 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2011 Presently Not Targeted For Any Future Release Of This Product Description Loading a database dumped from a 12.5.4 server as an archive database on ASE 15.5 or later may result in error 11060. This currently cannot be circumvented due to the read-only nature of the archive database Workaround Description  Create a copy of sp_helptext where the table syscomments is prefixed with the archive database name.

CR:667923

CR Number:   667923 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2011 Fixed 01 Jul 2011 Reservation Made Description A 290024 error, "Invalid column length: <number> Value must be between <number> and <number> at offset <number>..." may be reported in the errorlog when a session executed a trigger which contains a SELECT FOR XML referencing INSERTED or DELETED virtual tables and previously the same session had been executed a different trigger for a different table but with the same SELECT FOR XML statement. Workaround Description  The client has removed their trigger as the only work-around.

CR:667943

CR Number:   667943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2011 Fixed 01 Jun 2011 One-off Provided 14 Jul 2010 Presently Not Targeted For Any Future Release Of This Product Description In some cases, low throughput or poor performance may be observed during partially logged operations like BCP on indexed table or REORG REBUILD. sp_sysmon output shows high contention on dbt_seqspin spinlock.

CR:667977

CR Number:   667977 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2011 Fixed Description When a table in a VIEW is modified, multiple SELECT statements on the VIEW may return different results. Workaround Description  Establish a habit of always rebuilding views after altering tables they are based on.

CR:668088

CR Number:   668088 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Inaccurate memory allocation errors may be printed on startup.

CR:668337

CR Number:   668337 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances, raising the error 712, Severity: 17, State: 3 when restarted ASE and increasing the loads. Requires to increase heap memory per user.

CR:668344

CR Number:   668344 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2011 Bundled Request Description parameter declaration in sp_sysmon is incorrect

CR:668380

CR Number:   668380 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2011 Fixed 08 Aug 2011 One-off Provided Description When free lock pool resource goes below critical threshold, server goes to slow response state due to heavy spinlock contention.

CR:668502

CR Number:   668502 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2011 Fixed 23 May 2011 Fixed Description For a DOL partitioned table which has TEXT/UNITEXT/IMAGE columns, after alter table dropping a column, executing DBCC TEXTALLOC on the table which still have some TEXT/UNITEXT/IMAGE columns will report 15918 error.

CR:668560

CR Number:   668560 Product Name:   SCC Web Framework Product Component:   Other Status:   Closed OS:   Generic Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2011 Fixed 17 Jun 2011 Fixed Description Sybase Control Center to have option to configure the sender address in email alerts. Workaround Description  Write customer script an attach to alert.

CR:668576

CR Number:   668576 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Unsuccessful login attempts on ssl sockets generates ssl_close() SSLCLOSE() failed (-6989) errormessages. Would like the message suppressed.

CR:668617

CR Number:   668617 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2013 Not reproducible with latest version of the product available as of Resolution Date Description showplan reports Index name not found for temporary table Workaround Description  create procedure with recompile or execute procedure with recompile.

CR:668638

CR Number:   668638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2013 Fixed Description The sp_opt_querystats stored procedure reports error number 17077 indicating that the optimizer diagnostic results were incomplete and does not generate any output.

CR:668787

CR Number:   668787 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2011 Duplicate Description 'avoid_bmo_sorts on' uses "index scan" plan for a query that does a 'select into' a #temp table. if the "select into" is removed then "access by key" is used Workaround Description  ase_current + set avoid_bmo_sorts off STEP 1 The type of query is CREATE TABLE. STEP 2 The type of query is INSERT. 3 operator(s) under root |ROOT:EMIT Operator (VA = 3) | | |INSERT Operator (VA = 2) | | The update mode is direct. | | | | |SORT Operator (VA = 1) | | | Using Worktable1 for internal storage. | | | | | | |SCAN Operator (VA = 0) | | | | FROM TABLE | | | | TBS_GL_RECON | | | | R | | | | Index : I_GR_ESCTP_RECONSTTS_ESCRSN | | | | Forward Scan. | | | | Positioning by key. | | | | Keys are: | | | | ESCALATION_TP ASC | | | | RECON_STATUS_CD ASC | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | Using I/O Size 2 Kbytes for data pages. | | | | With LRU Buffer Replacement Strategy for data pages. | | | | TO TABLE | | #temp | | Using I/O Size 2 Kbytes for data pages.

CR:668790

CR Number:   668790 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2012 Fixed Description An audit process exception error message may occur that reports the incorrect numbers. The full error number is reported as the major number, the severity is reported as the minor number, the state is reported as the severity.

CR:668835

CR Number:   668835 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2011 Fixed Description Executing a query involving sending LOCATOR with NULL value through TDS_BLOB may hit 'Type 0 not implemented' error, i.e. error 1622.

CR:668846

CR Number:   668846 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2011 Fixed 20 Jun 2011 Fixed 12 Aug 2011 Fixed Description PIOs, LIOs, and CPU for nested loop join index scans are not reported in the estimated cost diagnostics (statistics plancost) for parallel optimized strategies.

CR:668909

CR Number:   668909 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2011 Fixed 22 Jul 2011 Fixed Description When creating a lightweight procedure, if all negative object IDs are used up, the 2012 error message is not reported.

CR:668967

CR Number:   668967 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2011 Workaround Description Sub optimal query plan allrows_oltp vs compatibility mode for sub query. Workaround Description  set compatibility_mode on go Or use traceflag 16928.

CR:669091

CR Number:   669091 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2011 Fixed Description In some cases, after loading a transaction dump which was taken after a fully-logged ALTER TABLE command was executed on an all pages-locked table that has multiple data pages, dbcc checktable on the table reports error 2583 because the number of data pages counted by dbcc is different from the count in the data oam page.

CR:669194

CR Number:   669194 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2013 Insufficient priority to fix Description A stored procedure, created with 'deferred compilation' enabled, that accesses cross database views and creates temporary tables may raise error 208 '<#temp_table> not found.' incorrectly. Workaround Description  Fully qualify cross database objects - eg: "from db1.usr1.view1". Or Turn off 'deferred compilation' when creating stored procedures that access cross database views.

CR:669301

CR Number:   669301 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2012 Fixed 30 Jan 2012 Reservation Made Description In rare circumstances, the message "Invalid column length: 12. Value must be between 0 and 10 for 'all-pages' row with minimum row length of 64" together with a stack trace which includes the modules 'collocate' and 'translate_varcols' may be reported on a 64 bits ASE on IBM AIX, when the datbase was loaded from a dump of a different platform. Workaround Description  From CR 435212: Allow updates. Then: update sysobjects set versionts = convert(binary(10), versionts) update syscolumns set length=10 where id = 1 and name = 'versionts' For versions prior to 15.0 (sysindexes is an APL table with clustered index) update sysindexes set maxlen = (select maxlen from master..sysindexes where id = 1 and indid = 1 ) where id = 1 and indid = 1 For versions 15.0 and higher (Sysindexes is a DOL table) update sysindexes set maxlen = (select maxlen from master..sysindexes where id = 1 and indid = 0 ) where id = 1 and indid = 0 Then disallow updates. That should fix up the aberrant database.

CR:669413

CR Number:   669413 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2011 Fixed 24 Aug 2011 One-off Provided Description Backup Server is enhanced to provide support for the MOUNTWAIT option for Tivoli Storage Manager. This option is off by default. It can be turned on by virtue of using the new M option in the DUMP DATABASE or TRANSACTION to syb_tsm::-M::<object_name> commands. Additionally in the LOAD DATABASE or TRANSACTION from syb_tsm::-M::<object_name> commands.

CR:669429

CR Number:   669429 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2011 Bundled Request Description Infected with 11 in function testpasswd following an upgrade. Workaround Description  reset password with sp_password

CR:669434

CR Number:   669434 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description optimizer chooses bad join order with partitions on large dataset Workaround Description  use the abstract plan, unpartition the table, force the index, force the join order

CR:669447

CR Number:   669447 Product Name:   Adaptive Server Enterprise Product Component:   sybinstall Status:   Closed OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2012 Duplicate Description executing the installer in console mode stacktraces when using relative pathname that includes '../' Workaround Description  Specify the complete path to the setup.bin. e.g. <complete path>/setup.bin

CR:669482

CR Number:   669482 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Win32s Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2012 Insufficient priority to fix Description Query search fails on utf8 ASE 15.5 with like clause and cursor. Customer using Hibernate/Spring with jConnect so unable to modify internal JDBC Code to work around the problem. Workaround Description  WorkAround: -------------- Use the wildcard and partial string (full string + wildcard will return 0 rows) or set jConnect property LITERAL_PARAMS=true - this sends the parameter as a literal in the search query: select name from pool where name like 'backyard' or turn an compatibility option "enable compatibility mode" or use "=" instead of "like"

CR:669573

CR Number:   669573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) Description To support LVM for ASE CE

CR:669592

CR Number:   669592 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2011 Fixed 26 May 2011 Fixed 27 May 2011 Fixed 27 May 2011 Fixed 21 Jul 2011 Bundled Request Description When sp_extrapwdchecks is installed in the master database, adding or changing a login password to one containing single quotes fails with errors 102, 105 and 17720. Workaround Description  The work around it to not use sp_extrapwdchecks, or, not use quotes in passwords

CR:669730

CR Number:   669730 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2013 Fixed Description Logical errors when parsing complex abstract plans

CR:669736

CR Number:   669736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2011 Fixed 09 Aug 2011 Fixed Description Large text and data segments are not supported on HPIA64 platform. Workaround Description  chatr dataserver +pi 16M +pd L

CR:669847

CR Number:   669847 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2011 Fixed 08 Feb 2012 One-off Provided 11 Nov 2011 Reservation Made 15 Feb 2012 One-off Provided 21 Sep 2012 Fixed 04 Oct 2012 Fixed Description A 290024 error, "Invalid column length: <number> Value must be between <number> and <number> at offset <number>..." may be reported during a UPDATE plan execution when a complex VIEW or derived table (such as UNION or GROUPBY) is used in the FROM clause of the UPDATE statement.

CR:669925

CR Number:   669925 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Different behaviour when no login trigger present and login trigger not found

CR:669932

CR Number:   669932 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2011 Fixed 08 Jun 2011 Fixed 15 Jun 2011 Fixed 15 Jun 2011 Fixed Description With using Sybase Central ASE Plug-in, the Web Services SSL Configuration wizard fails with the error, "ERROR: Could not find java executable at null/bin/java. Please verify that a valid JRE installation exists." Workaround Description  Invoke the script $SYBASE/WS-15_0/bin/configssl from a shell with correct environment set.

CR:670074

CR Number:   670074 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2011 Fixed 01 Jun 2011 One-off Provided 04 Oct 2011 Fixed 05 Sep 2011 Fixed Description High spinlock contention on Resource->rdbts_spin and Dbtable->dbt_seqspin when running concurrent BCP IN jobs against a partitioned table.

CR:670150

CR Number:   670150 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 CGA Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2011 Fixed 29 Jul 2011 Fixed 14 Jul 2011 Reservation Made 15 Jul 2011 Fixed 18 Jul 2011 Fixed 08 Aug 2011 Fixed Description Under certain circumstance, when 1204 error happens, SA/SA role cant login to adjust the number of locks

CR:670168

CR Number:   670168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2014 Bundled Request Description The minimum recommended stack size is a little too small for many operations. The stack size configured on Solaris platforms should be larger than the minimum recommendation for ASE 15.x servers. Workaround Description  Do not use the mimimum stack size suggested by ASE.

CR:670169

CR Number:   670169 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2011 Fixed 23 May 2011 Fixed 31 May 2011 Fixed Description Sybase Central ASE Plug-in does not allow browsing 'User Tables' in a database when it contains a table that is marked 'for load'. Workaround Description  None known.

CR:670199

CR Number:   670199 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2011 Fixed 01 May 2013 Fixed 21 Jan 2014 Port Not Needed Description A signal 11 could be encountered with a stacktrace involving the function ResRelOp() called from CgpDistinctSorted::_cgpInit() when a DISTINCT VIEW with an expression DISTINCT SELECT column is queried with a constant equality predicate over the expression column and the final plan chooses DistinctSorted operator. Workaround Description  set distinct_sorted off go Also turning off merge_join might avoid the distinct_sorted for the repro. But I can't guarantee it in general as optimizer might decide to choose distinct_sorted for other reason.

CR:670223

CR Number:   670223 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Support rebuilding off-row LOB through REORG REBUILD, if compression level has changed.

CR:670273

CR Number:   670273 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2012 DEFER 04 Jan 2013 Fixed Description In some circumstances, the Operations value in the monOpenObjectActivity MDA table does not reflect the actual number of table accesses.

CR:670275

CR Number:   670275 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2012 Fixed Description ASE may allow four reader tasks to skip over a queued update task in lock sleep if the readers are trying to obtain a shared intent lock.

CR:670302

CR Number:   670302 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2011 Duplicate Description Adaptive Server on AIX-64 platform may cause illegal instruction errors and core dump when using a served license or an unserved sub-capacity license.

CR:670310

CR Number:   670310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2011 Fixed 08 Jun 2011 Fixed 13 Jun 2011 Fixed Description The message "PCI(M1): pcidb_get_pci_directive_arg() : Unable to select the arguments for PCI Bridge directive PCI_BRIDGE_X_OPT." followed by the message "current process infected with 11" in the module 'pci__cfg_plb_options' together with a stack trace which includes the modules 'dsinit' and 'pci_cfgmgr_init' may be reported in the error log during ASE startup whose logical page size is greater than 8K if ASE first reported an error during the recovery of a user database and the configuration option 'enable pci' is active.

CR:670327

CR Number:   670327 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhance dbcc checktable to capture invalid column length beforehand

CR:670337

CR Number:   670337 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description srvbuildres issue warning unable to verify raw device sizes

CR:670398

CR Number:   670398 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2011 Fixed Description ASE could hit timeslice error while zeroing out the device during the 'disk resize' command.

CR:670498

CR Number:   670498 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sqldbgr routines don't check for abnormal termination of procedures

CR:670506

CR Number:   670506 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2011 Duplicate 29 Jul 2011 Bundled Request 25 Jun 2012 Fixed 08 Oct 2014 Port Not Needed Description A server configured with certain specific character sets and case insensitive sort orders can report error 15417 when querying tables that contain encrypted columns. Workaround Description  Only a change of sort order seems to be able to prevent the reporting of an error.

CR:670530

CR Number:   670530 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2011 Fixed 13 Jun 2011 Reservation Made Description The Job History Output table has extra new line added after each row of the results obtained from the target server.

CR:670587

CR Number:   670587 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2011 Fixed Description 614, 644, 2610 error etc may be returned due to the non-clustered index leaf page corruption if max_rows_per_page is set to 1 for the non-clustered index on APL table.

CR:670854

CR Number:   670854 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2011 Third Party Problem Description The datediff() function may produce incorrect results when comparing a string literal or bigdatetime with a smalldatetime datatype.