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

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

CR:702377

CR Number:   702377 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2012 Added to user documentation Description Doc bug: 3rd parameter "remaining" is not needed in the syntax of sp_listener in threaded mode.

CR:702409

CR Number:   702409 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This feature request is to allow non-alphabetic first character for 'login name' (as specified using 'create login') and to also switch 'login name' to a large identifier (255 chars). It is also to allow the use of a period '.' in the login name.

CR:702411

CR Number:   702411 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2012 Added to user documentation Description This request is to document login name restrictions under :- Adaptive Server Enterprise 15.7 > Reference Manual: Commands > Create login Parameters login_name specifies the name of the login account to be created. <It must start with an alphabetic character and cannot exceed 30 characters in length.>

CR:702482

CR Number:   702482 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2012 Presently Not Targeted For Any Future Release Of This Product Description sybmigrate: error needs to be changed to "config check failed, disable xact coordination Workaround Description  sp_configure 'enable xact coordination', 0

CR:702532

CR Number:   702532 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) 03 May 2012 Fixed Description In rare circumstances, ASE may shut down with the message, "Stack guardword corrupted" reported in the error log when running queries with LIKE clauses on LOB columns. Workaround Description  Either use sp_configure to increase the stack size, or break the query into smaller pieces.

CR:702549

CR Number:   702549 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2012 Fixed Description Preupgrade may report an error that huge master device size is needed for upgrade to 15.7 ESD#2.

CR:702653

CR Number:   702653 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2012 Consult Complete 16 Apr 2012 Bundled Request 01 Jun 2012 Presently Not Targeted For Any Future Release Of This Product 13 Nov 2012 Fixed 14 Nov 2012 Fixed Description When a primary key contains IDENTITY columns, INSERT INTO and SELECT statements may create bad LTL causing the RepServer to report the error message, "Incorrect syntax near the keyword FROM". This is fixed via CR 674627.

CR:702657

CR Number:   702657 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2012 Added to user documentation Description Doc CR: take out "do not modify" for "number of messages" error

CR:702704

CR Number:   702704 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to have the preupgrade checks output a warning when the database timestamp is very high (it may be better to rebuild the database in this case than upgrade in place).

CR:702725

CR Number:   702725 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) 15.7 SP101 29 Apr 2013 Fixed 29 Apr 2013 Reservation Made 09 May 2013 Fixed 09 May 2013 Reservation Made 15.7 SP50 15 May 2013 Fixed 15 May 2013 Fixed 20 Jun 2013 One-off Provided Description In circumstances whereby the select list of an INSERT SELECT with ORDER BY does not include the 'order by' columns, it is possible that the optimizer will favor a non-matching index scan using an index with the order by column(s) as opposed to a more efficient plan using a matching index scan for one or more of the filter predicates. A new optcriteria cr702725 has been introduced for this change. Use "set cr702725 1" to turn on the change and "set cr702725 0" to turn it off. Workaround Description  set avoid_bmo_sorts off

CR:702770

CR Number:   702770 Product Name:   Adaptive Server Enterprise Product Component:   ssm Status:   Closed OS:   HP-UX Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2012 Fixed 12 Sep 2012 Fixed 08 Oct 2014 Port Not Needed Description Dataserver might hit SIGSEGV in is_vpar() during startup on HP PA-RISC vPar.

CR:702799

CR Number:   702799 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) 27 Mar 2012 Duplicate Description sp_recompile with statement cache enabled changes query results in 155x and 157 Workaround Description  a) turn off statement cache b) DBCC PURGESQLCACHE after running sp_recompile

CR:702816

CR Number:   702816 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2012 Bundled Request Description A timeslice error followed by stack trace that contains the module 'adb__sync_dmap' may happen when trying to load a very large database into an archive database.

CR:702896

CR Number:   702896 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request to suppress informational message - "Failed to get ocm lock".

CR:702907

CR Number:   702907 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) 15.7 SP50 08 Apr 2013 Fixed 15.7 SP110 29 May 2013 Fixed Description In specific circumstances it is possible to receive a 2601 error on execution of a stored procedure. The issue is much more likely to happen with 'deferred name resolution' enabled. This can happen when a stored procedure has been initially created, then for the 'first' execution, multiple concurrent connections all run the procedure at the 'same'time. If running with 'deferred name resolution' enabled at create procedure time, the error is much more likely to occur. It could also happen in circumstances where the query tree needs to be recreated from text as in after the ASE is upgraded. Workaround Description  For this particular repro, add a line to execute the procedure once after creation.

CR:702968

CR Number:   702968 Product Name:   Unified Agent Product Component:   Security Services Status:   Closed OS:   Windows XP Original Version:   3.2.3 ESD2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2012 Fixed 12 Apr 2012 Fixed Description This fix enables LDAP usernames with simplified Chinese characters to login to the SCC

CR:703049

CR Number:   703049 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description improve the space estimation in Sybmigrate. Workaround Description  increase space in the target database.

CR:703063

CR Number:   703063 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) 27 Mar 2012 Fixed Description Update statistics with sampling can fail to correctly write the sampling percent to sysstatistics, optdiag\sp_showoptstats will report zero. This is a diagnostic issue only, sampling is performed during the update statistics command.

CR:703122

CR Number:   703122 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2012 Fixed Description The message, "current process infected with signal 11", together with a stack trace involving the functions keclearown(), uppopaffinity() and threadpool__update() may be reported when number of threads in a thread pool is changed, for example from 2 to 1 via "alter thread pool <thread pool> with thread count = 1" under ASE threaded mode.

CR:703123

CR Number:   703123 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) 08 Jun 2012 Fixed 31 May 2012 Reservation Made 09 Nov 2012 Fixed Description Predicates that contain more than 128 or-terms in a disjunct may not be optimized using a general-or strategy. In cases where such a general-or strategy provides the only efficient search strategy, query performance could be poor. Workaround Description  use compatibility mode reduce number of elements IN clause -- not really a work around

CR:703134

CR Number:   703134 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2013 Bundled Request Description ASE provides inaccurate estimation for 'kernel resource memory' configuration parameter.

CR:703213

CR Number:   703213 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2012 Fixed 28 Mar 2012 Fixed Description The error, "Page Verification Error: Page mismatch. Page # contains # in page header", may be reported in the Backup Server log file if the database has two fragments on a database device where first logical page of the first fragment is smaller than the first logical page of the second but the first virtual page number of the second fragment is smaller than the first virtual page of the second.

CR:703265

CR Number:   703265 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2014 Insufficient priority to fix Description view with column created using substring and charset is utf8 converts columns incorrectly on linux

CR:703285

CR Number:   703285 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) 11 May 2012 Fixed 15 Jun 2012 Fixed Description ASE logs the message "Expected object passed to utGetOsId is not of type thread" and "Expected object passed to utGetThid is not of type thread" repeatedly.

CR:703375

CR Number:   703375 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Windows Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2012 Fixed 03 Apr 2012 Fixed Description Dumping on Windows using 'WITH COMPRESSION' clause can perform worse that the same command using the API library "compress::". Workaround Description  Use old compress::<level>::<device> API (will not work with 100\101 levels)

CR:703377

CR Number:   703377 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   NA Original Version:   2.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.2.0.9 25 Jun 2012 Duplicate Description ASE may fail to find a License when running under a virtual machine

CR:703424

CR Number:   703424 Product Name:   SCC Web Framework Product Component:   Repository Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2012 Fixed 03 Apr 2012 Fixed Description This fix addresses an issue which prevented the automatic repository purge processing from completing

CR:703426

CR Number:   703426 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances, the Invalid column length error 290024 may be raised when "capture missings statistics" is ON and executing a LWP and doing compilation optimization. Workaround Description  turn off "capture missings statistics"

CR:703427

CR Number:   703427 Product Name:   ASE Management Product Component:   Administration Client Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2012 Fixed 09 May 2012 Fixed Description When the database is large, user viewing the ASE Monitor Databases screen on the large database such as selecting the large database on the top of the screen may impact viewing other ASE Monitor screen and may also block scheduled collection jobs. This fix solves the problems.

CR:703437

CR Number:   703437 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) 31 May 2012 Fixed 15 Jun 2012 Fixed Description ASE reports message "kshpnetctlrWaitForCompletion : received error 8 for psn ..." when a connection gets killed abruptly.

CR:703607

CR Number:   703607 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   AIX Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2013 Insufficient priority to fix 23 Jul 2013 One-off Provided 15.7 SP60 07 Aug 2013 Fixed 05 Aug 2013 Reservation Made 15.7 SP121 05 Dec 2013 Fixed 26 Nov 2013 Fixed Description Backup Server is enhanced to provide Multithread support needed for Tivoli Storage Manager options such as LAN-FREE. This support is off by default. It can be turned on by using the new D8192 option during Backup Server startup. For example: ${BACKUPSERVER} -SSYB_BACKUP -I$SYBASE/interfaces -M${SYBMULTBUF} -D8192&

CR:703655

CR Number:   703655 Product Name:   SCC Web Framework Product Component:   GUI Status:   Closed OS:   RH Linux Original Version:   3.2.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2012 Fixed 19 Apr 2012 Fixed 25 Apr 2012 Fixed Description This resolution fixes an incorrect default start time within the create collection job wizard

CR:703685

CR Number:   703685 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2012 Fixed Description The message, "current process infected with signal 11", together with a stack trace involving the functions hk__compress_page() and pg_modify_spacebits() may be reported durng HOUSEKEEPER garbage collection.

CR:703796

CR Number:   703796 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) 13 May 2012 One-off Provided 10 May 2012 Fixed 11 May 2012 Fixed 09 May 2012 Reservation Made 11 May 2012 Fixed Description In installations with large number of user connections, the message "current process infected with signal 11" together with a stack trace involving the function sybcsi_default_entropy() may be reported from the housekeeper chores process or the job scheduler process.

CR:703897

CR Number:   703897 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2012 Insufficient info provided 11 Feb 2013 Insufficient info provided Description Signal 11 in LeHashOp::LeOpSaveIOStats

CR:703905

CR Number:   703905 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) 10 Apr 2012 Fixed 01 May 2012 Fixed 27 Apr 2012 One-off Provided Description A 3146 error, "ASE cannot load this database dump because the version in the dump is newer than the version in the database...", may be reported when a database dump from a Cluster Edition server is loaded in a newer SMP server.

CR:703919

CR Number:   703919 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2012 Duplicate Description DROP proxy table in a database marked for replication with "sp_reptostandby, 'ALL'" may fail. Workaround Description  sp_reptostandby dbname, 'none' then drop the table.

CR:703947

CR Number:   703947 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 Apr 2012 Bundled Request Description A database that is created without "full logging" (for example, "full logging for alter table") may incorrectly inherit this property from a database that has been dropped which had the full logging mode set prior to it being dropped. As a result, the volume of logging might be more than expected. Workaround Description  Set "full logging for xxx" to false explicitly.

CR:703975

CR Number:   703975 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description LIKE pattern match issue with square brackets Workaround Description  Workaround is to use traceflag 4086 to back out the fix for 639877.

CR:703992

CR Number:   703992 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When running TF 299 and multiple tempdbs it is possible for a query execution referencing a temporary table to hit an error 225 Msg 225, Level 16, State 3: Server 'SOGDEN157', Line 1: Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization. This is timing specific and can only occur during parallel execution of a statement referencing the same temp table name.

CR:704012

CR Number:   704012 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) 05 Apr 2012 Fixed 12 Apr 2012 Fixed 15 May 2012 Presently Not Targeted For Any Future Release Of This Product 11 May 2012 Fixed Description A 706 message, "Process <pid> tried to remove PROC_HDR <prochdr address> that it does not hold in Pss.", may be reported in the errorlog when either the 'streamlined dynamic SQL' or 'enable functionality group' configuration options is enabled and recompilation occurs while a dynamic SQL query is being executed and an exception occurs during the recompilation.

CR:704029

CR Number:   704029 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2012 Fixed Description In rare circumstances, the message, "current process infected with signal 11", together with a stack trace involving the functions collocate(), run() and s_execute() may be reported when executing a simple INSERT query with compatibility_mode enabled. Workaround Description  Disable literal autoparam if using statement cache.

CR:704038

CR Number:   704038 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer would like to request that an enhancement be made to the resource limits feature on ASE. Specifically, he would like to be able to configure resource limits on the number of locks similar to number of rows. Often there is a situation where a process is unable to escalate to a table level lock on an object due to other processes having lock(s) on the same object. Though this is more likely on a DOL (especially Datarows lockscheme) table, it is possible on very large Allpages lockscheme tables also.

CR:704085

CR Number:   704085 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 ESD#2 07 May 2012 Fixed 25 Jan 2013 Fixed Description When multiple encrypted columns with the decrypt_default attribute are selected through a view, ASE may incorrectly return decrypted data on some of the columns.

CR:704095

CR Number:   704095 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2012 Fixed Description Queries with OUTER JOIN on encrypted columns may not return expected rows from the outer table if the ON clause is on columns with decrypt_defaults and there is a where clause.

CR:704477

CR Number:   704477 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2012 Fixed 03 May 2012 Fixed 07 May 2012 Fixed Description In rare circumstances, the message "current process infected with signal 11" together with a stack trace that include the modules collocate(),LeSubst() and getnext() may be reported when compressed tables are involved in the query. Workaround Description  Increase the "compression info pool size" in configure file if SIG11 is encountered.

CR:704481

CR Number:   704481 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2012 Fixed Description A signal 11 may happen in CgpPop::CgpInplaceUpdateVars() for an INSERT...SELECT...ORDERBY query when the insertion involves RI constraint checking and one of the ORDER BY columns has a different datatype from its destination column (so that an implicit convert will be added) or the ORDER BY column is an expression.

CR:704487

CR Number:   704487 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 RAT N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2012 Fixed 01 May 2012 Fixed 01 May 2012 Fixed Description In rare circumstances, the message, "Could not locate the before image for the INSERT log record", may be reported in the error log when replication is on the page-compressed table.

CR:704582

CR Number:   704582 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) 18 Oct 2012 Bundled Request Description Add a configuration option 'enable ISM' to use Intimate Shared Memory (ISM) as follows, Boot with ISM if available else regular shared memory, only with ISM, only with regular shared memory.

CR:704624

CR Number:   704624 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Large number of pages used on procedure cache when TF 450 is enabled. Workaround Description  1) Disable TF 450 2) Or change view as mentioned in the CR notes

CR:704641

CR Number:   704641 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2012 Fixed Description A 5851 error, "Configuration Error: Configuration file <config_filename> has an unknown format on line <line_num>.", may be reported during ASE reboot.

CR:704671

CR Number:   704671 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) 16 Apr 2012 Fixed 23 Jul 2013 Fixed 25 Jul 2013 Fixed Description While executing large amount of dynamically prepared statements we could find DBT_SPIN as still contentious.

CR:704679

CR Number:   704679 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) 21 Jun 2012 Fixed Description DISK REFIT fails to restore 'durability' and 'crdate' column information in sysdatabases system table. Workaround Description  You may be able to run alter database command again for some user databases. But you can not run alter database for system databases. If you can't, update rows in sysdatabases manually for system databases and user databases. If you update rows in sysdatabases manually, you should reboot ASE so that rows of sysdatabases (disk) and DBTABLEs (memory) can be synchronized.

CR:704691

CR Number:   704691 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2012 Fixed Description sp_downgrade prepare with 1502/15.0.2 as the @toversion reports "'15.0.2.0' is not a valid downgrade version" message.

CR:704699

CR Number:   704699 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Configuration Guide for UNIX Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2012 Added to user documentation Description Found a wrong maximum size of a database device (disk partition) in Adaptive Server Enterprise 15.7 Configuration Guide for UNIX.

CR:704724

CR Number:   704724 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2012 Fixed 23 May 2012 Fixed Description Remote Backup Server name is now allowed to be specified as 'hostname:portnumber'.

CR:704739

CR Number:   704739 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2012 Fixed Description On AIX plattform, "<num> suspect conditions" may be reported by DBCC CHECKSTORAGE and Fault 100018, 100019 and 100015 may be reported by sp_dbcc_faultreport.

CR:704744

CR Number:   704744 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) 10 Oct 2012 Bundled Request Description Log an informational message in the error log when memory allocation with Linux 'hugepages' succeeds. Add a configuration option 'enable HugePages' to control allocation as follows, with HugePages if available else regular pages, only with HugePages and fail if not available, only with Regular Pages.

CR:704899

CR Number:   704899 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) 26 Oct 2012 Fixed 26 Oct 2012 Reservation Made 01 Nov 2012 Fixed 01 Nov 2012 Reservation Made Description Add new configuration option 'enable HugePages' for Linux to control whether to boot ASE with HugePages and 'enable ISM' for Solaris to control whether to boot ASE with ISM

CR:704902

CR Number:   704902 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description To improve Error Msg 1509 to have more details include object id, index id,database id,login name and appname

CR:704934

CR Number:   704934 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) 25 May 2012 Fixed 25 May 2012 Reservation Made Description The message, "current process infected with signal 11", together with a stack trace involving the function norm3_get_node_sqlt() may be reported during DISTINCT operator code generation when a DISTINCT view/derived table is participating in an expression EQUIJOIN. Workaround Description  set merge_join off

CR:705024

CR Number:   705024 Product Name:   Adaptive Server Enterprise Product Component:   ssm Status:   Open OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The host-id for unserved shared-capacity (sysamcap MACHINE) licenses for VMware ESX virtual machines may have changed. Existing licenses will continue to work but you will need to Check-in and re-generate the licenses at SPDC for any new VMs added after the SYBASE_SAM_CAPACITY environment variable was previously generated. The host-id reported by 'sysamcap MACHINE' should be checked against the HOSTID field in the unserved license to determine whether the license needs to be re-generated.

CR:705093

CR Number:   705093 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2012 Fixed 01 Nov 2012 Fixed 16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 19 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 19 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description Extensions to the Remote Backup Server name feature allowing to be specified as 'hostname:portnumber'.

CR:705107

CR Number:   705107 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) 18 May 2012 Fixed Description On a symbolic binary, the datachange() built-in may hit a signal 11 during the cleanup of the execution after hitting 1105 error due to space crunch in tempdb. On an FBO binary, it may execute unnecessary code during the cleanup.

CR:705129

CR Number:   705129 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) 08 Jan 2013 Not reproducible with latest version of the product available as of Resolution Date Description 290024 invalid column length in collocate reported during execution

CR:705160

CR Number:   705160 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2012 Added to user documentation Description DOC CR : The default value of max network packet size is 512 in System Administration Guide. But it should be 2048.

CR:705192

CR Number:   705192 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2012 Bundled Request Description DBISQL on Windows fails to start if VM_ARGUMENTS property value in DBISQL.ini is longer than 255 characters.

CR:705198

CR Number:   705198 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When generating ddl for proxy tables using ddlgen, it will unnecessarily generate create index ddl for the proxy table. This may fail when running the script created by ddlgen as those indices will implicitly be added to the proxy table index definitions from the source table after the proxy table is created.

CR:705260

CR Number:   705260 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) 06 Dec 2013 Insufficient priority to fix Description query hits signal 11, 6 in Nsql::nsExecute and gsignal when the where clause is included. zombie spid is left behind

CR:705261

CR Number:   705261 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   all Original Version:   ASE 15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2012 Fixed 03 May 2012 Fixed Description The srvbuild/srvbuildres (UNIX) and syconfig.exe/sybatch.exe (Windows) utilities now require user to specify the System Administrator password when configuring a new ASE.

CR:705267

CR Number:   705267 Product Name:   Adaptive Server Enterprise Product Component:   sybinstall Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2012 Not reproducible with latest version of the product available as of Resolution Date Description nonfatal errors during ASE15.7ESD#1 install on a RHEL6.2 VM Workaround Description  For ASE_Suite.log error : ===> Installer failed to setup the "Remember ASE Password" option for the ASEP. In Sybase Central Tools->Adaptive Server Enterprise-> Preferences menu, verify "Remember connected server" are correct. 2 ====> for ASEP.log unregistered message error Sybase Central failed to unregistered the old 15.0.3 and 15.5 ASEP. In Sybase Central Tools->Plug-ins menu, verify the latest ASEP version is registered. 3. for diisql.log error Execute Script/Batch file: Unix Status: ERROR Additional Notes: ERROR - Error while attempting to execute the installation script ====> Installer failed to register the DBISQL. Verify you start DBISQL from Sybase Central Tools->Adaptive Server Enterprise->Interactive SQL menu.

CR:705283

CR Number:   705283 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Doc: Request to add notes about ASE starting with trace flags. Start Adaptive Server with a trace flag only when instructed to do so in this manual or as directed by Sybase Technical Support or a Cover letter. Commands or stored procedures which are not directed under these flags at any other time or way may create an error or a stack trace or other problems. Especially trace flags 3607 and 3608 are used when a special recovery procedure is performed. Do not attempt a normal shutdown after using trace flags 3607 or 3608. Always use shutdown with nowait in these cases.

CR:705331

CR Number:   705331 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   NA Original Version:   2.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2012 Fixed 27 Jun 2012 Fixed Description SySAM properties file is truncated to zero bytes in situations such as the disk filling up.

CR:705332

CR Number:   705332 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) 10 May 2012 Insufficient priority to fix Description Feature request to allow customer to create their own unicode sort orders.

CR:705335

CR Number:   705335 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Bring sort order id 55 'espdict' into line with modern Spanish

CR:705379

CR Number:   705379 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) 16 May 2012 Bundled Request Description When the master database is setup for replication, the command 'ALTER ROLE... LOCK' succeeds but is not replicated and an error 11314 is reported. Workaround Description  None.

CR:705385

CR Number:   705385 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2012 Fixed 13 May 2012 Fixed 30 May 2012 Fixed 04 May 2012 Fixed 10 Sep 2014 Insufficient priority to fix Description There is no entry for entering backend server SA user password for creating a new cluster.

CR:705390

CR Number:   705390 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description number of checkpoint tasks has to be set to default or 1 before upgrade, or it will fail, and require manually editing the config file before restarting the upgrade process. This should be handled in the preupgrade. Workaround Description  sp_configure "number of checkpoint tasks", 1 -- on oldsybase before upgrade manually edit the config file to number of checkpoint tasks=DEFAULT

CR:705451

CR Number:   705451 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Tables Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2012 Added to user documentation Description DOC CR : The Description column of "action" of sysprotects in Reference Manual: Tables does not have Create Function (280).

CR:705470

CR Number:   705470 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2012 DEFER Description When execution of a local java method (classes loaded into ASE, so pci and java enabled) calls a web service (which uses java.xml.ws package) it is possible for the execution to hit the following error:- Unhandled Java Exception: javax.xml.ws.WebServiceException: class <class> do not have a property of the name {....}<parameter> at com.sun.xml.internal.ws.client.sei.BodyBuilder$DocLit.<init>(Unknown Source) at com.sun.xml.internal.ws.client.sei.SEIMethodHandler.<init>(Unknown Source) at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.<init>(Unknown Source) at com.sun.xml.inte.

CR:705516

CR Number:   705516 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) 08 Nov 2013 Fixed 19 Nov 2013 Fixed Description Feature request to improve sp_configure to perform kernel resource memory consistancy checks.

CR:705520

CR Number:   705520 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) 26 Apr 2012 Duplicate Description In very specific timing related circumstances, the message, "current process infected with signal 11", together with a stack trace involving the function keclearown() may be reported when modifying threadpool information. The server will be left unreachable (or down) and will need to receive a kill -9 in order to restart.

CR:705545

CR Number:   705545 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2012 Not a Bug Description DBISQL/ASE Set command has been removed. The related documentation was not updated.

CR:705677

CR Number:   705677 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) 20 Apr 2012 Fixed 08 May 2012 Fixed Description The message, "current process infected with signal 11", together with a stack trace involving the functions stat_mergestats_all(), sort() and cri_ptn_index() may be reported when a parallel CREATE INDEX specifies that 0 histogram steps should be used, effectively disabling histogram creation, and multi-attribute density creation. Workaround Description  Ensure you run the command with serial sort:- create index aix on b(b1) with statistics using 0 values, consumers=1 --or don't use 'using 0 values'

CR:705723

CR Number:   705723 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2013 Fixed 08 Nov 2013 Presently Not Targeted For Any Future Release Of This Product Description In some ASE customer scenarios, PDES chain spinlocks are found to contain high contention.

CR:705733

CR Number:   705733 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) 30 May 2012 Fixed 25 Jun 2012 One-off Provided 31 May 2012 Fixed 20 Jun 2012 Fixed Description In some situations, a signal 11 may occur in lock__get_heldlocknum if a deadlock or lock timeout event happens. Workaround Description  Disable both 'print deadlock information' and 'deadlock pipe active'

CR:705891

CR Number:   705891 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2012 Fixed 11 May 2012 Fixed Description While running ASE, the time a task waits on a lock is incorrectly calculated by adding a overlapped time.

CR:706391

CR Number:   706391 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2012 Consult Complete 02 Jul 2012 Consult Complete Description RepAgent hang and stacktraces repeatedly.

CR:706483

CR Number:   706483 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Can insert null image values into not null image columns via INSERT SELECT

CR:706501

CR Number:   706501 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2012 Fixed Description The ASE default task stack space is too low for default execution coverage.

CR:706543

CR Number:   706543 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2013 Fixed Description sybmigrate and DDLGen fail when there is "&" in the object name Workaround Description  sp_rename or bcp the object

CR:706581

CR Number:   706581 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2012 Fixed 15 Jun 2012 Fixed 24 Jan 2013 Fixed 25 Jan 2013 Fixed Description The message, "current process infected with signal 11", together with a stack trace involving the function prot_view_decdef_cols() may be reported with a complex query when access is made through a VIEW and the accessed columns are encrypted with decrypt_default.

CR:706647

CR Number:   706647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Shutdown ASE when IO controller SEGV. wish is unrecoverable.

CR:706653

CR Number:   706653 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE should restart IO controller if they have problem.

CR:706690

CR Number:   706690 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE kernel message stating SySAM: Failed to connect to SMTP host [ip address]on port [port]" may be raised when SySam is configured for email notification but the SMTP host is not up. Either start the SMTP host or use sp_lmconfig to change to a different host or disable email notifications.

CR:706764

CR Number:   706764 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to expand the sp_dbextend functionality to include expansion onto devices not currently allocated to the database. Workaround Description  Use thresholds directly to alter database (sp_addthreshold)

CR:706769

CR Number:   706769 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description During shutdown of Backup Server isuing 'shutdown SYB_BACKUP' from ASE, it is possible for the backupserver binary to core dump due to a SEGV in srv__q_defevent()

CR:706777

CR Number:   706777 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) 15.7 ESD#3 22 Jun 2012 Fixed Description The message text for error 9262 has been changed to report the database name and ID values such as "A Rep Agent Thread for database '<dbname>' (dbid=<value>) is already running".

CR:706799

CR Number:   706799 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2012 One-off Provided 27 Dec 2012 Fixed 27 Dec 2012 Fixed 27 Dec 2012 Fixed 25 Feb 2013 One-off Provided 05 May 2013 Fixed 20 Jan 2014 Fixed 20 May 2013 Fixed 02 Oct 2013 Fixed 08 Oct 2014 Port Not Needed Description Memory allocation failures appear in the ASE errorlog when the network memory pool is exhausted or when fragmentation of memory occurs due to memory that is not freed. Workaround Description  Most customers may recycle the ASE regularly to reduce memory fragmentation for the Network buffer pool and reduce the chance of ks_falloc error. They may also increase additional network memory dynamically if the requested size is smaller than 2097088 bytes. To monitor Network buffer memory pool usage and fragmentation, they may collect sybmon command output: mmgrpool fragment verbose Network Buffer to check mc_used (used memory) and Largest free fragment size to check memory fragmentation.

CR:706842

CR Number:   706842 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2012 Fixed Description When using tables with 64 or more partitions and parallelism is enabled with max parallel degree more than 64, ASE will stack trace in bitstr::test() method.