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

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

CR:711170

CR Number:   711170 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) 15 Aug 2012 Fixed Description When enabling the RepAgent configuration parameter 'activate monitoring', after stopping and restarting the RepAgent, the setting automatically reverts back to 'disabled' mistakenly.

CR:711205

CR Number:   711205 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer request to certify ASE 15.5 & ASE 15.7 HA option with Sun Cluster 3.3

CR:711220

CR Number:   711220 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2012 Fixed Description DBISQL stacktrace when loading an xml plan generated by sp_showoptstats

CR:711239

CR Number:   711239 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 The following messages appear for a cluster which has only a single private interconnect configured, The cluster interconnect protocol has not been defined in the cluster input file. Cannot resolve host name '' for the local interface of the link to monitor. Cannot resolve host name '' for the remote interface of the link to monitor.

CR:711245

CR Number:   711245 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2012 Fixed 03 Aug 2012 Fixed 18 Sep 2012 Fixed Description The stored procedure sp_replication_path 'list' output is enhanced to include information about the default path for a more complete picture of the replication topology.

CR:711248

CR Number:   711248 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 SP110 28 May 2013 Fixed 17 Jun 2013 One-off Provided 15.7 SP50 21 Jun 2013 Fixed Description Error 14575, "CREATE TABLE WITH COMPRESSION is not supported for in-memory database", followed by error 11050, "Adaptive Server cannot process this ALTER TABLE statement due to one or more preceding errors. If there are no preceding errors, please contact Sybase Technical Support.", and error 11934, "REORG REBUILD of table 'tabname' failed due to an internal error. Please contact SYBASE Technical Support", may be reported when running 'reorg rebuild' command on table which has data or LOB compressedion defined after user is bind to temporary in-memory database. Workaround Description  1.drop the binding of the user to the temp inmemory db 2. don't use compressed tables

CR:711255

CR Number:   711255 Product Name:   Unified Agent Product Component:   Agent Server Status:   Closed OS:   all Original Version:   3.2.3 ESD1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2014 Work as design Description scc.sh parameters do not work - the services-config.xml file overrides args Workaround Description  directly edit the $SYBASE/SCC--3_2/services/RMI/service-config.xml file

CR:711299

CR Number:   711299 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) 18 Jul 2012 Fixed Description ASE running in threaded kernel mode allows user to decrease the value of 'max online engine' less than the total number of engine threads leading to a boot failure while rebooting the server. A message saying "The total number of mux threads X is exceeding cmaxonline Y." may be reported.

CR:711328

CR Number:   711328 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) 13 Jun 2012 Fixed 17 Jun 2012 Fixed 25 Jul 2012 Fixed 28 Mar 2013 Added to user documentation 23 Jul 2012 Fixed 25 Jul 2012 Fixed Description Using sybcluster to add an instance in interactive mode failed.

CR:711332

CR Number:   711332 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) 24 Aug 2012 Fixed 25 Jun 2012 Fixed Description ASE may not be able to start a large number of engines with the ASE kernel configured for Process mode as a Spinlock allocation error can be encountered.

CR:711354

CR Number:   711354 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   NA Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2012 Added to user documentation Description Doc CR:Correct print_switch_output_to_errorlog to print_switch_output_to_log

CR:711355

CR Number:   711355 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 Database selection dropdown is not initialized when open new window. Workaround Description  click on execute button.

CR:711373

CR Number:   711373 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) 13 Jun 2012 Added to user documentation Description Documentation for sp_errorlog is missing from the 15.5 and 5.7 Reference Manuals.

CR:711406

CR Number:   711406 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 Feature request for a configuration option that would cause update index statistics to use the configured step count and histogram tuning factor settings rather than the step count for the current histogram.

CR:711412

CR Number:   711412 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) 23 Jul 2012 Fixed 13 Aug 2012 One-off Provided Description When the user is running a batch query with a temp table creation outside a stored procedure, and execute the stored procedure referencing this temp table, the procedure will be renormalized each time. When there're many processes calling this batch query at the same time, random signal 11 stack traces will be observed.

CR:711417

CR Number:   711417 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) Description If ASE config file is manually edited and a config section is added at the end after thread pool section, ASE reports "Unexpected attribute for thread pool 'syb_default_pool'" during boot. Workaround Description  move thread pool section in the config file to the end of the file.

CR:711453

CR Number:   711453 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 Jun 2012 Fixed 20 Jun 2012 Fixed 28 Jun 2012 Fixed Description Permissions through roles granted to non-default login profiles can be lost or reduced if there exists a default login profile that has not been granted all the roles that the non-default login profile has and a permission changing event (such as a grant or revoke) occurs in the server. Workaround Description  Drop the default login profile

CR:711494

CR Number:   711494 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) 17 Jul 2012 Fixed Description Server hang when executing ALTER TABLE spt_TableTransfer SET TRANSFER TABLE OFF.

CR:711534

CR Number:   711534 Product Name:   SCC Web Framework Product Component:   Alert Status:   Closed OS:   Generic Original Version:   3.2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2014 Duplicate Description feature request to give SCC the ability to select certain timeframes where email alerts are sent Workaround Description  configure your email to throw out all alert emails from SCC during batch time processing.

CR:711623

CR Number:   711623 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 FR: set option to prevent update trigger firing when no actual update is made

CR:711654

CR Number:   711654 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2012 Fixed 25 Jun 2012 Fixed 08 Jul 2012 Fixed Description The ASE errorlog may contain many instances of the kernel message "Expected object passed to blkioDescriptor is not of type BLKIO,..."

CR:711713

CR Number:   711713 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2012 Fixed 19 Jun 2012 Fixed 19 Jun 2012 Fixed Description In rare circumstance, when replicating an off-row compressed LOB column, the replicate ASE may raise the 7153 error, "Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end." and Replication Server will abort the connection.

CR:711819

CR Number:   711819 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2012 Fixed Description Replicating a SELECT-INTO statement fails when the source table contains quoted column names.

CR:711928

CR Number:   711928 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) 23 Aug 2012 Fixed 07 Mar 2013 Fixed Description sp_sysmon would report a 265 error, "Insufficient result space for explicit conversion of SMALLINT value '100' to a VARCHAR field" if ASE is configured with more than 100 engines. Workaround Description  change @tmp_grp and @rptline lines to get length of 4, not 2 or 3 in installmaster for : sp_sysmon_appmgmt sp_sysmon_kernel sp_sysmon_analyze

CR:711953

CR Number:   711953 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) 29 Jun 2012 Fixed Description When attempting to execute a stored procedure in a database that the user is not a user in two error messages will be displayed stating that the user is not a user in the database.

CR:711978

CR Number:   711978 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) 24 Aug 2012 Fixed Description A segmentation violation can occur when configuration parameter "suspend audit when device full" is set to 0 after the audit segment becomes full.

CR:711991

CR Number:   711991 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2012 Bundled Request Description Removed privileges "connect" and "set tracing" from privilege set of GRANT ALL.

CR:712042

CR Number:   712042 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 sp_monitorconfig "number of sort buffers" may show Num_active and Max_Used higher than the configured value if multiple connections are concurrently performing sort operations.

CR:712050

CR Number:   712050 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 A set option to change the date that the getdate() returns. Something similar to the TZ variable at OS level.

CR:712082

CR Number:   712082 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2012 Duplicate Description subquery hits sig 11 in ResRelOp and terminates in ResRelOpProcess Workaround Description  compatability mode optlevel ase1503esd3 or ase_default If using optlevel ase1503esd4 and up, 'set in_list_general_or off'

CR:712089

CR Number:   712089 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Job Scheduler: jobs may fail to run if they require 'large identifiers'. Currently Job Task clients are limited to OpenClient 12.5 capabilities. Workaround Description  Do not use large identifiers in Job Scheduler commands.

CR:712125

CR Number:   712125 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2012 Fixed 15.7 ESD#2 25 Jun 2012 Fixed 06 Jul 2012 Fixed Description If there are more than 32 columns used in an UPDATE STATISTICS command, either explicitly or implicitly through the auto_temptable_stats feature, then there is a possibility of a stacktrace. Workaround Description  set auto_temptable_stats 0

CR:712139

CR Number:   712139 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) 20 Sep 2012 Workaround Description Two query performance problems which are related to costing issues, data skew and suboptimal plans. The optimizer may generate optimal plans for the related queries after creation of a new index which may work better for the queries. Workaround Description  Suggested new index for TradeDetail on two columns portfolioUID and tradeDate. The customer confirmed that new index can fix the performance issues.

CR:712144

CR Number:   712144 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances, executing a stored procedure might hit the Signal 11 caused by the plan corruption.

CR:712258

CR Number:   712258 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 Jul 2012 Fixed Description TOP N syntax is not shipped to the IQ server. Workaround Description  dbcc cis to set 141 to 1.

CR:712340

CR Number:   712340 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2013 Insufficient priority to fix Description FR: new datatype of datetime for last time row was modified. Similar to timestamp but in a format that is useful. Workaround Description  ALTER TABLE table_name Modify date_column Default getdate() but this only works on inserts. The feature is for updates as well.

CR:712435

CR Number:   712435 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2014 EOL'd version. Not to be Fixed. Description After drop-cluster the same cluster cannot be re-created without restarting the agents.

CR:712461

CR Number:   712461 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) 15.7 ESD#3 27 Jun 2012 Fixed 15.7 ESD#3 06 Jul 2012 Fixed Description If multi-column syntax is used with update statistics tabname (colname1, colname2,...) using out_of_range {on | off | default }, then the assignment of out_of_range behavior may not be associated with the correct columns.

CR:712480

CR Number:   712480 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2012 Fixed 09 Jul 2012 Reservation Made 19 Jul 2012 Fixed 26 Jul 2012 Fixed 05 Aug 2012 Fixed Description The LAVA based index creation is enhanced to support the case where the index leading columns are duplicated.

CR:712495

CR Number:   712495 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Open OS:   NA Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DEUTSCHE BANK AG request to publish the complete list of MDA Wait Events in public product document.

CR:712502

CR Number:   712502 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Solaris Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2012 Added to user documentation Description Wrong Errorlog location in ASE CE 15.7 Installation Guide. (NG) By default, the log file is located in $SYBASE/$SYBASE_ASE/install/errorlog. (OK) By default, the log file is located in $SYBASE/$SYBASE_ASE/install/<servername>.log.

CR:712531

CR Number:   712531 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   HP-UX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2012 Fixed Description In rare circumstances the query on FDP table might get some uninitialized data after the FDP table is re-sized. Workaround Description  After resizing the FDP table size, restarting the server can make this issue gone.

CR:712541

CR Number:   712541 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 Aug 2012 Fixed Description sp_displayrole does not report expired password. User get error 11176.

CR:712554

CR Number:   712554 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2012 Fixed Description The message "infected with 11" together with modules like "tdsrecv__dynexec" and "sequencer" if using jconn3.jar with text/image datatypes and an ASE157 releases. Often, message 3805 will be reported too. Workaround Description  Increase statement cache works fine for a couple of days but soon customer hits stacktrace again.

CR:712579

CR Number:   712579 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2012 Fixed Description On AIX platforms, isql may fail to execute with the -X parameter depending on the order in which shared libraries are specified in the LIBPATH environment variable. Workaround Description  SAP does neither agree to switch to isql64 nor to fine-tune SYBASE.sh/.csh scripts.

CR:712636

CR Number:   712636 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2012 Fixed 18 Jul 2012 Reservation Made Description Too many steps may be created for a histogram when parallelism is used during create index or update statistics. Workaround Description  set parallel_degree 1 go

CR:712697

CR Number:   712697 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 have option to enable referral chasing for LDAPUA to be used with AD

CR:712783

CR Number:   712783 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2012 Fixed 07 Jul 2012 Added to user documentation 15.7 SP50 26 Mar 2013 Fixed Description When multiple queries are executed on one of the MDA FDP Tables with Adaptive Server Enterprise Cluster Edition the same row may appear in the results of multiple queries. This is not expected since the FDP tables should not present the same row in multiple queries.

CR:712808

CR Number:   712808 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2012 Fixed 06 Jul 2012 Fixed Description In some cases, DBCC CHECKTABLE may report error message 7948 after a clustered index is created on a compressed APL table which contains only 1 row.

CR:712847

CR Number:   712847 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) 27 Jul 2012 Fixed Description DBISQL Table and procedure name lookup is slow (F7 / F8). Workaround Description  A workaround to using Table or procedure name lookup (F7 / F8) is to use the text completion feature (introduced in DBISQL11) Press CTRL + SPACE to invoke text completion. To make text completion more useful for ASE, be sure to select "Show system objects" option (so that system procedures are listed, for example.) Note that Store procedure lookup dialog will display the sql text in DBISQL12 (CR#549065).

CR:712855

CR Number:   712855 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2012 Fixed 05 Sep 2012 Fixed 27 Sep 2012 Fixed 03 Oct 2012 Fixed Description Invoking the soundex() or difference() built-ins on unichar/univarchar strings larger than 127 characters (254 bytes) may cause the process to be terminated.

CR:712897

CR Number:   712897 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2012 Fixed Description sp_bindcache information is missing from DDLGen output.

CR:712903

CR Number:   712903 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) 25 Aug 2012 Fixed 26 Oct 2012 One-off Provided 04 Nov 2012 Fixed Description Idle connections may fail to migrate during instance shutdown. Workaround Description  If logical clusters have been created, then a cluster failover or a cluster migrate can be performed before issuing a shutdown. sp_cluster logical, 'failover', <lcname>, 'instance', '<from_instance_list>', '<to_instance_list>' or sp_cluster connection, 'migrate', <lcname>, <instancename> , '<spid_list>'

CR:712940

CR Number:   712940 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 Jul 2012 Fixed 05 Jul 2012 Fixed Description Complex queries (often with a large number of group-by columns and a large number of joins where generally each grouping column belongs to a different "joined" table) may SEGV after generating a 331 error terminating the session. The 331 error is raised because the query has exhausted the sort id namespace. Workaround Description  --for the specific repro it can be avoided by turning off conserve_tempdb_space. --note this is not the cause, just limits the number of plan variants with this feature off --so it does not fall over in the eqc competition dbcc traceon (16919) --or set conserve_tempdb_space off

CR:712949

CR Number:   712949 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2012 Fixed Description When dbcc page() for text page with print option 3 or 4, the output may be out of the range of the page size or hit infinite loop, also, if dbcc page() for text page with print option 1, 3 or 4, it may report a corrupt row message.

CR:712957

CR Number:   712957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2012 Fixed Description sybcluster will fail to connect to the cluster if duplicated agents are specified.

CR:712970

CR Number:   712970 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2012 Presently Not Targeted For Any Future Release Of This Product 25 Oct 2012 Fixed Description Enhancement is made to sp_placeobject system procedure to support partitions.

CR:712996

CR Number:   712996 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) 02 Jul 2012 Fixed 06 Jul 2012 Fixed Description sp_showoptstats output has been changed for the <statsOutRan> tag to have a value of "on" if the "using out_of_range on" phrase was used in update statistics, and "off" if the "using out_of_range off" phrase was used, and will not be printed if "default" is in effect. Previously "true" was printed when "on" or "off" was used.

CR:713032

CR Number:   713032 Product Name:   ASE Management Product Component:   Administration Client Status:   Closed OS:   Windows XP Pro Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2012 Fixed 27 Nov 2012 Added to user documentation Description ASE has been added new restriction to dbo-owned object in transfer object ownership. 1. DBO cannot transfer ownership on dbo-owned objects. 2. Any user or executor with sa_role cannot transfer ownership on dbo-owned objects. In the new restriction, the wizard will not allow user to select objects that he has no privilege to transfer ownership on.

CR:713074

CR Number:   713074 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) 13 Jul 2012 Fixed 22 Jul 2012 Fixed 26 Jul 2012 Added to user documentation 24 Jul 2012 Fixed Description Monitor server has been retired since 15.7 GA but sybcluster still contained the operations for configuring monitor server. These operation options have now been removed.

CR:713135

CR Number:   713135 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) 24 Jan 2014 Insufficient priority to fix Description In scenarios whereby a join may exist only on attributes which form a unique key on the inner-side it is possible for the estimate number of rows to be higher than the number of rows being passed in from the left. In reality in this situation the maxiumm number of rows the join may produce is less than or equal to the number of rows from the left.

CR:713189

CR Number:   713189 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 Jul 2012 Fixed 07 Jul 2012 Added to user documentation 23 Jul 2012 Fixed Description If the Cluster Editions is configured with both backup or xp servers, then adding an instance with an xml input file may fail.

CR:713228

CR Number:   713228 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Support "lock shared memory" under Microsoft Windows

CR:713231

CR Number:   713231 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 Enhance the optimizer to detect when a query has the requirements and correct referential integrity definitions for us to be able to bypass any access to the child table during the execution of a query involving a join from child to parent table.

CR:713281

CR Number:   713281 Product Name:   Unified Agent Product Component:   Agent Framework Status:   Closed OS:   all Original Version:   3.2.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2012 Fixed 02 Aug 2012 Fixed Description This fixes an issue which occurs if you execute "SCC-3_2/bin/sccinstance - refresh" for an ASE Cluster installation, the ASE SDC plug-in instance directory is deleted.

CR:713291

CR Number:   713291 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2012 Fixed 09 Jul 2012 Fixed Description In rare circumstance, error 1204, "ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS.", and error 5619, "Adaptive Server internal error. Could not obtain count of in-doubt transactions for space reservation.", may be reoported when running BCP IN/INSERT/UPDATE on table with TEXT/IMAGE/UNITEXT columns marked replicated.

CR:713367

CR Number:   713367 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2012 Fixed 23 Aug 2012 Fixed 24 Aug 2012 Fixed Description Multi-user tests sometimes run into error 716, "Unable to allocate memory from compression info pool size", even when the appropriate configuration option is set very high. Statements encountering this error while accessing compressed tables cause a transaction rollback. Fragment memory in the compression info memory pool found to be heavily fragmented, and memory fragments are seen to be in-use even when there are very few user connections active in the server.

CR:713411

CR Number:   713411 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2012 Fixed Description When replicating the value from an LOB column which have both in-row and LOB compression property, if the defined in-row length of LOB column at replicate side is so long that is close to @@maxpagesize, replicate ASE may raise error 7153 'Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end.' and Rep Server abort the connection.

CR:713441

CR Number:   713441 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2012 Added to user documentation Description Documentation: Clarify that writetext update does not update row timestamp

CR:713464

CR Number:   713464 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) 19 Jul 2012 Bundled Request 19 Jul 2012 Bundled Request 26 Jul 2012 Bundled Request 02 Aug 2012 Bundled Request Description Error 1503 may occur when index is created with LAVA based index creation if the number of distict index value is not greater than CONSUMERS number.

CR:713481

CR Number:   713481 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2012 Fixed Description Negative row count may be shown in the output of DBCC CHECKTABLE and CHECKINDEX commands if there are more than 2,147,483,647 rows in the table.

CR:713540

CR Number:   713540 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) 17 Jul 2012 Fixed 20 Jul 2012 Fixed 25 Jul 2012 Fixed Description When the user specifies for dump configurations a default directory for the dump stripes with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when generating the list of load database and load transaction commands that are needed to repopulate the database to a specified point in time.

CR:713547

CR Number:   713547 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2012 Fixed 24 Jul 2012 Fixed Description A wrong number of rows may be updated with INSTEAD OF TRIGGER when the base table of the view has predicates defined on it.

CR:713572

CR Number:   713572 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) 26 Mar 2013 Fixed 15.7 SP50 19 Apr 2013 Fixed Description A 12319 error followed by a stack trace that includes the modules LeMergeStmtOp::_LeOpClose() and dol_def_update() may be reported when a MERGE statement is using cloned plans.

CR:713631

CR Number:   713631 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2012 Fixed 19 Jul 2012 Bundled Request 26 Jul 2012 Bundled Request Description Error 832 may be reported when creating an index whose depth is greater than 6 if 'number of sort buffers' is configured as smaller value.

CR:713632

CR Number:   713632 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/ASE Connect Dialog Advanced tab replaces connection parameters' "=" with escaped sequence "^003d" when disconnecting and reconnecting to an ASE.

CR:713638

CR Number:   713638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2013 Fixed 09 May 2013 Reservation Made 15.7 SP110 01 Jul 2013 Fixed Description LIKE predicate optimizer estimations may be incorrect when UTF-8 is used. Optcriteria cr713638 is added to correct this issue.

CR:713677

CR Number:   713677 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) 29 Jul 2012 Duplicate 11 Sep 2012 Fixed by Integrated Component 08 Oct 2014 Port Not Needed Description Include OCS CR 672301 to fix an AIX specific memory leak. Workaround Description  N/A

CR:713707

CR Number:   713707 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2012 Fixed 06 Mar 2013 One-off Provided Description The message, "Current process infected with signal 11", together with a stack trace which includes the modules 'bi__xml_query' and 'bi_xmlextract' may be reported in the error log when an external KILL signal is issued to a regular XML query session.

CR:713728

CR Number:   713728 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) 17 Jul 2012 Fixed Description After upgrade from 12.5 to 15.7 ESD#1 or later version, if the 15.7 server is SMP server, "allow wide DOL rows" option is missing on tempdb; if is SDC server, this option is missing on the local temporary databases.

CR:713800

CR Number:   713800 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UNIX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2012 Fixed 17 Aug 2012 Fixed Description With plan sharing enabled, and under heavy workloads consisting of concurrent queries that qualify for query plan sharing, some shared plans may be prematurely terminated.

CR:713840

CR Number:   713840 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 Aug 2012 Fixed Description 'dbcc markproc' was failing with error 12309 : Expanding update on object was failing on page due to insufficient free bytes.

CR:713848

CR Number:   713848 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) 11 Sep 2012 Fixed 08 Oct 2012 Fixed Description On the Solaris platform, when ASE is running on a cluster in threaded kernel mode, if the XP server of an instance is shutdown from an isql session on another instance, the isql session will hang.

CR:713855

CR Number:   713855 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2012 Fixed 25 Jul 2012 Fixed Description When migrating from Adaptive Server versions 12.5.4 or 15.0 to version 15.7 ESD #2 using sybmigrate, the execption, "Failed to add the role 'sa_serverprivs_role' into the current database catalogs", may be raised.

CR:713881

CR Number:   713881 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2012 Fixed 23 Jul 2012 Fixed Description A 9830 error may be reported when inserting a row into a table with compressed data.

CR:713915

CR Number:   713915 Product Name:   Adaptive Server Enterprise Product Component:   ssm Status:   Open OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ICR: Messenging: timeslice in rtms_svrToUtf8 and cpu pegged using TIBCO Workaround Description  use a smaller message

CR:713937

CR Number:   713937 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request to include in the documentation a discussion of the various ANSI SQL Standards and better explain for each command what we mean when we say is is ANSI compatible or an extension.

CR:713945

CR Number:   713945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2012 Fixed 24 Jul 2012 Fixed 02 Aug 2012 Fixed Description In some circumstances, the message "current process infected with 11" in the module 'LeScanOp::_LeOpRelease' together with a stack trace which includes the modules 'LeUnionOp::_LeOpRelease' and 'LeEmittOp::_LeOpRelease' may be reported in the error log after an error message 716 if the query involves a UNION ALL clause.

CR:713950

CR Number:   713950 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) 18 Jul 2012 Fixed 22 Oct 2012 Presently Not Targeted For Any Future Release Of This Product 18 Jul 2012 Fixed 18 Jul 2012 Fixed Description A stacktrace may occur when using UPDATE STATISTICS with HASHING on character string datatypes which have a non-binary sort order, and there are more than 65535 unique values.

CR:714034

CR Number:   714034 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) 19 Jul 2012 Fixed Description DBCC CHECKTABLE or CHECKINDEX may report error 803 if the index is very deep.

CR:714061

CR Number:   714061 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2012 Fixed 24 Jul 2012 Fixed Description Forwarded row count in the SYSTABSTATS for a table that underwent 'REORG REBUILD <tabname> WITH ONLINE' may be incorrect. Workaround Description  Turn on 'allow updates to system tables' After online reorg rebuild is finished on the table with id 'tabid', plant '0' in the forwrowcnt column of SYSTABSTATS for the rows with id = <tabid> and indid = 0

CR:714086

CR Number:   714086 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 Jul 2012 Fixed 27 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description In some cases, if a union query involves concate varchar type of variable, it could return wrong result due to unexpected truncation. Workaround Description  use compatibility_mode

CR:714094

CR Number:   714094 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) 06 Aug 2012 Bundled Request Description When a predicated privilege is granted on a table for a set of columns, Adaptive Server may occasionally apply the predicate to a column outside the set of columns.

CR:714131

CR Number:   714131 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2012 Fixed 06 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description In some customer scenarios with stored procedures or sql accessing multiple databases, rdbtmgr_spin would show high contention.

CR:714153

CR Number:   714153 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) 18 Jul 2012 Fixed Description Parallel index creation may fail because of error 832 if 'number of sort buffers' is configured as very small and the index depth is very large. Workaround Description  Configure 'number of sort buffers' as a bigger value such as DEFAULT(500)

CR:714198

CR Number:   714198 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR for ability to turn off user ability to grant privileges to the 'public' group

CR:714217

CR Number:   714217 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) 20 Jul 2012 Fixed Description Supplying an overflow or underflow search constant to a query on a proxy table may return incorrect result.

CR:714288

CR Number:   714288 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Under very specific circumstances it is possible for a database load to fail with error:- Backup Server: 4.141.2.22: [23] The 'read' call failed for database/archive device while working on stripe device <device> with error number 14 (Bad address). This has been reported when loading a striped dump taken using 'with compression=100', but only sporadically.

CR:714306

CR Number:   714306 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2012 Fixed Description When 'literal autoparam' is enabled, it could raise an error if a query has a literal in order by clause such as ' ', 'a' and the query was cached in statement cache and it needs to be recompiled. Workaround Description  1) Turn off statement cache Or 2) Turn off literal autoparam

CR:714315

CR Number:   714315 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 Feature request to make Statement Cache Hash Table size configurable.