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

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

CR:756646

CR Number:   756646 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 31 Jan 2014 Fixed Description Replication Agent running on 'stream replication' mode may shutdown with the error 'Error: 9219, Severity: 20, State: 66' after a re-connection attempt.

CR:756648

CR Number:   756648 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2014 Fixed 12 Feb 2014 Reservation Made 24 Feb 2014 Fixed 03 Mar 2014 Fixed 15.7 SP61 17 Feb 2014 Fixed 15.7 SP121 04 Mar 2014 Fixed 16.0 GA PL01 05 Mar 2014 Fixed Description A 213 error, "Insert error: column name or number of supplied values does not match table definition." may be reported in a stored procedure, when deferred compilation is active, if a column is added to a table and there is a dependency on "select * " behavior to ignore the extra column. Trace flag 7798 will ignore this error if deferred compilation is turned on and allow normal compilation to process the statement. If normal compilation still sees an inconsistency, or some other activity causes re-resolution of the stored procedure, then errors may be still be reported. Workaround Description  Turn off deferred compilation.

CR:756704

CR Number:   756704 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2014 Duplicate Description Extend the 'with online' utility for create index to utilize parallel sorts when using consumers on a semantic partitioned table.

CR:756709

CR Number:   756709 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 new builtin function rowlength() that would return the total length of a row.

CR:756770

CR Number:   756770 Product Name:   Adaptive Server Enterprise Product Component:   SQL Status:   Open OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Wrong ServerUserID in monSysSQLText when execute procedure with "execute as".

CR:756791

CR Number:   756791 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) 03 Feb 2014 Deferred Description Feature request for built-in functions GREATER() and LESSER() that would return the greater and lesser of two parameters, similar to the functions of the same name that exist in SAP Sybase SQL Anywhere. Workaround Description  One can create a set of user defined functions, one for each compatible datatype. The disadvantage (over a hypothetical built-in function) is that there is performance overhead. create function max_int @a int, @b int returns int as declare @result int select @result = case when @b > @a then @b else @a end return @result.

CR:756819

CR Number:   756819 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) 28 Mar 2014 Bundled Request 01 Apr 2014 Bundled Request 02 Apr 2014 Bundled Request 16 Apr 2014 Bundled Request Description Arithmetic overflow occurred in procedure 'sp_sysmon_kernel'.

CR:756854

CR Number:   756854 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2014 Fixed Description Executing sp_help / sp_helpartition when online reorg / online create index is in its final phase (Blocking Logical Synchronization), may cause deadlock.

CR:756875

CR Number:   756875 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 06 Feb 2014 Fixed 28 Feb 2014 Fixed 28 Feb 2014 Fixed 06 Mar 2014 Fixed 06 Mar 2014 Fixed Description When executing a DUMP command with more than one VERIFY option, the backup server will ignore all but the last one. Also, on Windows platform, if the archive is bigger than 4GB and we are executing WITH VERIFY=READ_AFTER_WRITE or VERIFY=CRC and the verification fails when reading a block that is at an offset greater than 4GB, the error message will report an offset value that is only the two lower bytes of the actual offset, for example "There was a failure decompressing <#> bytes at offset 804831240 when processing stripe '<the stripe name>'" instead of the offset value for 5099798536.

CR:756876

CR Number:   756876 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2014 Not reproducible with latest version of the product available as of Resolution Date Description An infected with 11 occurs in function udr_check_granted when granting a role.

CR:756894

CR Number:   756894 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) 04 Apr 2014 Fixed 09 Apr 2014 Fixed 07 Jan 2015 Presently Not Targeted For Any Future Release Of This Product Description The error message 7786 has been updated to include the server user name.

CR:756896

CR Number:   756896 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a simple method such as another global variable to go with @@procid that would identify the database that @@procid is from.

CR:756966

CR Number:   756966 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 05 Feb 2014 Fixed Description An 8211 error: "Mismatch found between the name and id descriptor hash table for table <objname>, objid = <objid>" may sometimes be raised if an attention is hit while dropping an object.

CR:756976

CR Number:   756976 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2014 Bundled Request Description When procedure deferred compilation is turned off, DML auditing of stored procedures may not print variables in audit trail.

CR:756988

CR Number:   756988 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2014 Deferred 07 Apr 2014 Fixed 15 Apr 2014 Fixed Description Reduce dynamic SQL procedure cache footprint when 'streamlined dynamic SQL' is configured by saving SQL text in the statement cache only.

CR:756990

CR Number:   756990 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2014 Fixed 02 Apr 2014 Fixed 18 Sep 2014 Fixed 07 Oct 2014 Presently Not Targeted For Any Future Release Of This Product Description Raise the restriction limit on proxy table queries from 50 tables to 250 tables.

CR:757027

CR Number:   757027 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2014 Fixed 16 Jun 2014 Fixed 09 Jun 2014 Fixed Description In some circumstances when using the command SET STATISTICS IO ON or SET STATISTICS PLAN_HTML ON the runtime execution statistics reported for some queries could be inaccurate when the plan displays some operators like "HASH JOIN PROBE", "HASH JOIN BUILD", "SORT (GETSORTED)" or "SORT (SORTBUILD)".

CR:757038

CR Number:   757038 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2014 Fixed 15.7 SP121 26 Feb 2014 Fixed 27 Feb 2014 Fixed 16.0 GA PL01 04 Mar 2014 Fixed Description Sometimes, error 7705 could be raised unexpectedly for LIKE predicate with ESCAPE clause if there is a same letter in LIKE and ESCAPE clause, but one is an upper case letter and the other is a lower case letter. Workaround Description  None.

CR:757050

CR Number:   757050 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Updates with merge joins may not observe SET ROWCOUNT Workaround Description  Change the SQL so that there is a unique match between rows to be updated and the joined tables or turn off merge joins.

CR:757061

CR Number:   757061 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2014 Fixed 06 Mar 2014 Fixed 15.7 SP121 06 Mar 2014 Fixed 15.7 SP111 06 Mar 2014 Fixed 05 Mar 2014 Fixed 16.0 GA PL01 05 Mar 2014 Fixed Description When shared memory size exceeds 1TB, sp_shmdumpconfig might report error 265, "Insufficient result space for explicit conversion of INT value '1382954' to a CHAR field.".

CR:757062

CR Number:   757062 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   Linux Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description linuxamd queries using high number of indexes sees higher physical reads than solaris identical environment. Workaround Description  increasing data cache helped to reduce the physical i/o, however, it is apparent that this increase was not necessary on solaris.

CR:757142

CR Number:   757142 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2014 Fixed 18 Mar 2014 Fixed Description Stored procedure sp_dbextend fails with Error 3626 / 17 / 4 Workaround Description  None.

CR:757145

CR Number:   757145 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer want Direct connect server class to support T-SQL LIKE. Workaround Description  in some cases the SQL syntax exec 'string' can avoid this.

CR:757156

CR Number:   757156 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2014 Fixed 23 Mar 2014 Fixed Description In some special cases, the index size with index compression is larger than when the index is uncompressed.

CR:757164

CR Number:   757164 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2014 Fixed 30 Apr 2014 Fixed 15.7 SP111 13 Feb 2014 Fixed 15.7 SP121 06 Mar 2014 Fixed 16.0 GA PL01 10 Mar 2014 Fixed Description A timeslice error followed by a stacktrace that includes the modules stphd_release_last_mvcc_histogram(), stphd_release_unreferenced_mvcc_histograms() and stu_nosort_range() may be reported in the error log in a heavily loaded system during the CREATE INDEX operation when using hashing. Workaround Description  avoid using the hashing option in parallel create index

CR:757177

CR Number:   757177 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2014 Fixed 15.7 SP111 25 Feb 2014 Fixed 15.7 SP121 27 Feb 2014 Fixed 18 Feb 2014 Reservation Made 16.0 GA PL01 05 Mar 2014 Fixed Description LIKE optimization does not happen for a ? + ? pattern that is used in a prepared statement.

CR:757192

CR Number:   757192 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 11 Feb 2014 Fixed Description Rolling back of a drop object sometimes could result in an error 8211 with "Mismatch found between the name and id descriptor hash table for table 'tablename'".

CR:757215

CR Number:   757215 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2014 Fixed 03 Mar 2014 Fixed 16.0 GA PL01 28 Feb 2014 Fixed 27 Mar 2014 Fixed Description In rare circumstances, a 1105 message "Can't allocate space for object 'syslogs' in database 'tempdb' because 'logsegment' segment is full" may incorrectly be printed for tempdb when the first pages of tempdb are not mapped in sysusages. Workaround Description  Create tempdb with separate log and data segments for tempdb. OR Start ASE with -T7405 -T7406 in the RUN file. These traceflags force the server to scan the OAM pages to calculate the unreserved pages at the end of recovery and print more diagnostic information for further investigation OR Make sure the log of model is (almost empty), every time a change is made in model: dump tran model with truncate_only

CR:757246

CR Number:   757246 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_sysmon IO Busy is over weighted in threaded kernel mode.

CR:757251

CR Number:   757251 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Suse 10 Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2014 Fixed 11 Mar 2014 Fixed 15.7 SP111 15 Mar 2014 Fixed 15.7 SP121 06 Mar 2014 Fixed 05 Mar 2014 Reservation Made 07 Mar 2014 Reservation Made 19 Mar 2014 Fixed 15.7 SP121 08 Mar 2014 Fixed 15.7 SP121 10 Mar 2014 Fixed 05 Jun 2014 Fixed Description Add 'Proc Cache Header' diagnostic enhancements for the block pool to capture the time spent in bitmap scanning and collect memory allocation/free patterns. These diagnostics are disabled by default.

CR:757258

CR Number:   757258 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 SP10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2014 Fixed 28 Feb 2014 Fixed Description When displaying configuration values for Replication Agent using the sp_help_rep_agent procedure the 'rs_servername' displays only the first 30 characters.

CR:757301

CR Number:   757301 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) 28 Apr 2014 Fixed 28 Apr 2014 Reservation Made 30 Apr 2014 Fixed Description When a 331 error occurs or there are long query optimization times or large procedure cache usage occurs in the optimization phase, then this may be due to the optimizer not pruning subplans in the search space as early as possible. Improve pruning can be turned on with optcriteria cr757301, or by using ase_current with optimization level of at least ase157sp130. Trace flag 16992 will turn off the optimization even if the optcriteria is enabled.

CR:757310

CR Number:   757310 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Microsoft Windows Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 11 Feb 2014 Fixed 12 Feb 2014 Fixed 12 Feb 2014 Fixed Description Cannot use syconfig to do backup server upgrade on Windows 64bit

CR:757312

CR Number:   757312 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2014 Fixed 09 Apr 2014 Fixed Description In rare cases, a query accessing the sysdatabases on master companion might return error 14108 with Could not find partition descriptor for objid 30, indid -1, ptnid 30 in dbid <dbid>.

CR:757323

CR Number:   757323 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2014 Fixed 07 Aug 2014 Fixed 06 Aug 2014 Fixed 12 Dec 2014 Fixed Description The MDA table monRepSyncTaskStatistics that provides statistics on (near) synchronous replication, will report information erroneously when the current replication mode is asynchronous.

CR:757393

CR Number:   757393 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) 05 Jun 2014 Fixed 05 Jun 2014 Reservation Made Description If SAP ASE is upgraded from pre 16.0 to 16.0, then dbcc tune(volatile,4,<table name>) or alter table <table name> set index_compression = page for the existing table may raise error 12859 like Column sysobjects.sysstat4 has length '0', should be '1'. The sysobjects row is for database '<db name>' (db id), object '<object name>' (object id).

CR:757398

CR Number:   757398 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 12 Feb 2014 Fixed 17 Feb 2014 Fixed 15.7 SP121 20 Feb 2014 Fixed 15.7 SP111 28 Feb 2014 Fixed Description In some rare scenarios, a utility command modifying a table and waiting for a level 0 scanner on the table to exit, might not respond to a client killing the session where a utility command is executed.

CR:757459

CR Number:   757459 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2014 Fixed 23 Feb 2014 Fixed 14 Feb 2014 Fixed 15.7 SP111 14 Feb 2014 Fixed 15.7 SP121 17 Feb 2014 Fixed 16.0 GA PL01 04 Mar 2014 Fixed Description A timeslice error, followed by a stacktrace that includes the module memshrink(), may be reported in the SAP ASE errorlog during a sort operation on a very large data set.

CR:757477

CR Number:   757477 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Poor costing of unions when aggregating tempdb usage.

CR:757495

CR Number:   757495 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2014 Fixed 24 Mar 2014 Fixed Description XP server will fail to boot, to execute extended stored procedure or to shutdown if some other process is listening on the xpserver port. ASE shutdown may also hang if some other process is listening on the xpserver port.

CR:757501

CR Number:   757501 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2014 Fixed Description Improve the clarity of error message 16346, "The LOAD_SQL LISTONLY option is valid only if a stripe device is not specified.". This error message will now be reported as, "You cannot use the FROM clause with the LISTONLY=LOAD_SQL option.

CR:757531

CR Number:   757531 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   cepheus beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2014 Fixed 04 Mar 2014 Fixed 04 Mar 2014 Fixed 27 Jun 2014 Fixed Description RepAgent may fail with error 9275 "RepAgent (<dbid>): Could not locate the before image for the INSERT log record at (<page#>,<rowid#>)." while processing the log records for a MERGE command leading to inserts and updates.

CR:757610

CR Number:   757610 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2014 Duplicate Description When creating a new 8k or 16k page SAP ASE using syconfig (Windows) or srvbuild(res) (Unix) and additionally setting up PCI at the same time, SAP ASE may not have enough memory to boot.

CR:757612

CR Number:   757612 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2014 Fixed Description srvbuildres may fail with an uninitialized buffer error if user does not have write permission on /tmp .

CR:757620

CR Number:   757620 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) 25 Apr 2014 Fixed 20 May 2014 Fixed 28 Feb 2014 Reservation Made 26 Apr 2014 Reservation Made 22 May 2014 Fixed 01 May 2014 Fixed 16 May 2014 Reservation Made 17 Jun 2014 Fixed 19 Aug 2014 Fixed Description Add the capability to do a Deferred Recovery of Create Index to SAP ASE.

CR:757634

CR Number:   757634 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2014 Fixed 16.0 GA PL01 05 Mar 2014 Fixed 05 Mar 2014 Fixed Description Under certain circumstances, a 2956 error, "Unable to grab a buffer to encrypt logical page <pagenum> in database <dbid>. Increase the size of the 16K buffer pool in the buffer cache 'default data cache'", may be reported when using an encrypted database.

CR:757643

CR Number:   757643 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2014 Fixed 03 Dec 2014 Fixed 21 Nov 2014 Fixed Description Child sort thread during index rebuild leads to assertion failure as it does not recognize concurrent partition level utility execution.

CR:757649

CR Number:   757649 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2014 Fixed 12 Mar 2014 One-off Provided 06 Mar 2014 Port Not Needed 17 Mar 2014 Fixed 15.7 SP121 06 Mar 2014 Fixed 15.7 SP111 28 Feb 2014 Fixed 16.0 GA PL01 09 Mar 2014 Fixed Description A 4720 error, "Cannot truncate table <tablename> because there are one or more isolation level 0 scans, or REORG command, active on the table", may be reported during a TRUNCATE TABLE command while level 0 scans are active. This new feature is enabled when the new configuration option 'enable utility lvl 0 scan wait' is set.

CR:757824

CR Number:   757824 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2014 Fixed 05 Mar 2014 One-off Provided 27 Mar 2014 Fixed 02 Apr 2014 Fixed 04 Apr 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed 15.7 SP111 02 Apr 2014 Fixed Description When running in SAP ASE process mode under heavy load in a multiengine environment, an engine may become CPU bound when handling network cancel requests arising from attentions received either from the client or from kill commands. In the event that the network listener was on the run queue of the engine which has become CPU bound as above, it may be impossible to establish new logins to the server.

CR:757829

CR Number:   757829 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2014 Fixed 23 Jul 2014 Fixed Description Incorrect hash partition elimination may lead to incorrect results when there is an OR predicate on the partition column(s) Workaround Description  Don't use hash partitioning

CR:757850

CR Number:   757850 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2014 Fixed 16.0 GA PL01 26 Feb 2014 Fixed 26 Feb 2014 Fixed 15.7 SP111 28 Feb 2014 Fixed 15.7 SP121 05 Mar 2014 Fixed Description When running on a table with thousands of partitions, create local nonclustered index or placement index command may fail due to stack overflow with no error message printed.

CR:757867

CR Number:   757867 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 05 Mar 2014 Fixed 06 Mar 2014 Fixed Description In rare circumstances, checkstorage or sp_dbcc_alterws might not expand the scan/text workspace to the size suggested by sp_plan_dbccdb or specified value. Workaround Description  run sp_flushstats for the scan/text workspace before checkstorage.

CR:757883

CR Number:   757883 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2014 Fixed 23 Feb 2014 Fixed 16.0 GA PL01 24 Feb 2014 Fixed 24 Feb 2014 Fixed 24 Feb 2014 Fixed Description When a user invokes DDLGen from a script and wishes to hide the password by supplying the pseudo password (-Pext) and including the actual password in a file or setting in an environment variable, the error "DG16: Could not get Console instance" is reported.

CR:757895

CR Number:   757895 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2014 Fixed Description Support Quoted Identifiers on session temporary tables. This requires that the configuration parameter "quoted identifier enhancements" is set and the session level option "quoted_identifiers" is on.

CR:757962

CR Number:   757962 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2014 Fixed Description Error message 806 (Could not find virtual page for logical page ... in database ...) may be reported for an update query with multiple outer joins when the update mode chosen for the query is not deferred update mode. Workaround Description  use cmdline traceflag 463.

CR:757974

CR Number:   757974 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2014 Fixed 16.0 GA PL01 19 Feb 2014 Fixed Description Under rare circumstances, some qualified data rows may not be returned for a query which uses RID list scan on a partitioned DOL table.

CR:758105

CR Number:   758105 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 10 Mar 2014 Fixed 10 Mar 2014 Fixed Description The error message, "SSL or Crypto Error Message: 'csi_cipher_crypto'" may be reported when encrypting an existing database.

CR:758109

CR Number:   758109 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2014 Fixed 22 May 2014 Fixed 08 Jul 2014 Fixed Description During upgrade from pre-16.0 to 16.0, if the older server's max memory configuration is very close to the amount required by that server, ASE 16.0 can report that max memory is not sufficient. If that happens, ASE 16.0 will not start.

CR:758119

CR Number:   758119 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2014 Fixed 16.0 GA PL01 24 Feb 2014 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module LeExecuteWorkUnits(), may be reported in the error log during execution of query plans that use both the 'dynamic thread assignment' and 'parallel index update'.

CR:758144

CR Number:   758144 Product Name:   Sybase SQL Server Product Component:   sybinit Status:   Closed OS:   Microsoft Windows Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2014 Fixed 17 Mar 2014 Fixed 15 Apr 2014 Already Fixed by Another CR 15 Apr 2014 Already Fixed by Another CR Description 1) If SAP ASE is installed as an overlay, sybatch will reset the XP Server port to default during upgrade. 2) sybatch requires user to specify sqlsrv.master_device_physical_name, sqlsrv.master_device_size, sqlsrv.master_db_size and sqlsrv.application_type which are not really needed in upgrade. 3) sybatch recreates the XP Server Windows service even if it doesn't exist for the old server.

CR:758214

CR Number:   758214 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2014 Fixed 24 Feb 2014 Fixed 15.7 SP111 25 Feb 2014 Fixed 15.7 SP121 06 Mar 2014 Fixed 16.0 GA PL01 06 Mar 2014 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module s_recompile() may be reported in the error log when a table schema change happens after processing the first row, and before finishing the second row of an dynamic batch INSERT.

CR:758249

CR Number:   758249 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2014 Fixed 16.0 GA PL01 03 Mar 2014 Fixed Description When upgrading to SAP ASE 16.0, the upgrade utility will report error 4243, "DUMP TRANSACTION WITH NO_LOG or DUMP TRANSACTION WITH TRUNCATE_ONLY is not allowed in database '<dbname>' while the 'enforce dump tran sequence' database option is enabled." if a database has option "enforce dump tran sequence" set.

CR:758260

CR Number:   758260 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2014 Fixed 04 Jun 2014 Fixed 05 Jun 2014 Port Not Needed 05 Jun 2014 Port Not Needed Description In rare circumstances, a 8201 error "Keep count of descriptor (objid=<value>, dbid=<value>) was expected to be 1. Instead 2 was found." together with a stack trace which includes the modules 'ptn__pdes_scavenge' and 'open_user_table' may be reported in the error log when SAP ASE attempts to reuse a descriptor and an online utility such as 'truncate partition' had been previously used. In the SAP ASE error log the message "Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation." would have been also reported.

CR:758297

CR Number:   758297 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2014 Fixed 31 Mar 2014 Fixed Description Skip blank lines in the dump history file when searching for the version record. If an invalid version record is found, initialize the history file after copying the file to a back up.

CR:758328

CR Number:   758328 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) 10 Mar 2014 Fixed 10 Mar 2014 Reservation Made 15.7 SP111 10 Mar 2014 Fixed 27 Mar 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed 05 May 2014 Fixed Description A poor index may be chosen for a join, if the selectivity of previous joins is estimated to be 0 rows (likely caused by a predicate selecting an 0.0 weight range cell in the histogram). The optcriteria avoid_zero_weight_histograms or trace flag 16991 will adjust selectivity estimates so that at least one row will be selected when joining histograms. Note that ase_current will not enable this functionality, and that "set avoid_zero_weight_histograms on", a user defined optgoal which includes avoid_zero_weight_histograms or trace flag 16991 is needed.

CR:758340

CR Number:   758340 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 28 Feb 2014 Fixed 03 Mar 2014 Fixed 03 Mar 2014 Fixed Description Creation of temporary tables in a large number of concurrent user sessions leads to a high number of accesses to syslogins.

CR:758349

CR Number:   758349 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2014 Fixed 06 Mar 2014 Fixed 17 Mar 2014 Fixed 07 Mar 2014 Fixed 14 Mar 2014 Reservation Made 20 Mar 2014 Fixed 11 Mar 2014 Fixed Description DDL commands within prepared statements can now be replicated.

CR:758353

CR Number:   758353 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2014 Fixed 15.7 SP121 26 Feb 2014 Fixed 28 Feb 2014 Fixed 16.0 GA PL01 28 Feb 2014 Fixed 03 Mar 2014 Fixed 25 Feb 2014 Reservation Made Description When using data encryption functionality on Windows platforms, encryption operations can make an engine stall for short periods of time.

CR:758408

CR Number:   758408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP51 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2014 One-off Provided 21 Mar 2014 Fixed 25 Mar 2014 Fixed 31 Mar 2014 Fixed 31 Mar 2014 Fixed Description Stored procedures using "execute as caller" with queries that create and query #temporary tables fail with error 208, "Server '<servername>', Line 26: <#temporary_table> not found after LOAD DATABASE". Workaround Description  dbcc markprocs(<dbid>) go

CR:758424

CR Number:   758424 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) 25 Feb 2014 Added to user documentation Description 15.x Doc update : sp_rename does not require related procedures, triggers or views to be recreated. The warning message only applies to 12.5.x.

CR:758440

CR Number:   758440 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 03 Mar 2014 Fixed 09 Mar 2014 Fixed Description Database encryption fails with error 16839, "Database <dbname> cannot be encrypted when encryption is in progress.", after an abnormal shutdown. Workaround Description  Use resume encryption option.

CR:758507

CR Number:   758507 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 05 Mar 2014 Fixed 17 Mar 2014 Fixed Description Executing DBCC CHECKSTORAGE on an encrypted archive database may raise suspect conditions.

CR:758536

CR Number:   758536 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2014 Added to user documentation Description A computed column cannot reference UDF belongs different db

CR:758666

CR Number:   758666 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare case, if DOL table has unique index, concurrent DML may hit index corruption (error 12313 "Insert into page id <page #> of index id <index #> of table '<table name>' (id = <id #>) in database '<db name>' tried to replace undeleted RID (<>, <>) at slot <slot #> and ridposn <#>. Try dropping and recreating the index.")x.

CR:758765

CR Number:   758765 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2014 Fixed 22 Jun 2014 Fixed 22 Jun 2014 Fixed Description An incorrect decision by optimizer to do the update in direct mode might result in consecutively repeated update of the same row and resulting in page corruption, manifesting in the errors 806, 614, 120024, etc.

CR:758774

CR Number:   758774 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 05 Mar 2014 Fixed 19 Mar 2014 Fixed Description The Job Scheduler may fail to start after setting the minimum password length using sp_passwordpolicy to a value greater than the value of the minimum password length set by sp_configure. Workaround Description  resetting minimum password length to 6 or lower, then job scheduler starts fine alternatively: Setting config parameter 'minimum password length' to the same values as what is being set by sp_passwordpolicy , then job scheduler starts fine

CR:758796

CR Number:   758796 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2014 Fixed 10 Jul 2014 Fixed Description If a database and objects within the database are bound to different caches, ASE could run into SIGSEGV issue when it performs encryption/decryption on the database.

CR:758809

CR Number:   758809 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2014 Fixed Description Supplying the Rep Agent 'connect dataserver' property with a value longer than 30 characters causes memory corruption which leads to connection failure or other unpredictable behavior depending on the size and content of the longer value.

CR:758823

CR Number:   758823 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2014 Added to user documentation Description Document for new feature: DB level option for index compression.

CR:758868

CR Number:   758868 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2014 Fixed 16.0 GA PL01 05 Mar 2014 Fixed Description Under a heavily used replication environment and in rare circumstances the Rep Agent schema cache and the Rep Agent memory pool can run out of memory because of a memory leak issue. Workaround Description  n/a

CR:758938

CR Number:   758938 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2014 Fixed 10 Mar 2014 Fixed 13 Mar 2014 Fixed 16.0 GA PL01 07 Mar 2014 Fixed 15.7 SP111 08 Mar 2014 Fixed 15.7 SP121 08 Mar 2014 Fixed 12 Mar 2014 Fixed 12 Mar 2014 Fixed 31 Mar 2014 One-off Provided Description When a process that is executing a DUMP DATABASE command is killed either using the KILL command or using CTRL-C or the SQL session goes away, the Backup Server will not release its associated resources until it finishes copying the whole database. One of the consequences is that the archive devices can remain locked for a long time because the sybmultbuf processes stay alive.

CR:758959

CR Number:   758959 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2014 Fixed 02 Apr 2014 Fixed Description In rare circumstances, when the MDA table monProcessProcedures is being used, an infected with 11 (SIGSEGV) error along with a stacktrace may be logged in the SAP ASE errorlog . This is a similar situation as addressed by CR 754648 (which covered monProcessStatement).

CR:758961

CR Number:   758961 Product Name:   Adaptive Server Enterprise Product Component:   sybinit Status:   Closed OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2014 Fixed 29 Apr 2014 Fixed 11 Jun 2014 Fixed 17 Jun 2014 Fixed Description syconfig.exe/sybatch.exe and sqlupgrade[res] needs to install Job scheduler stored procedures and templates when upgrading the ASE server.

CR:758973

CR Number:   758973 Product Name:   Adaptive Server Enterprise Product Component:   sql Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP61 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2014 Fixed 10 Mar 2014 Fixed 10 Mar 2014 Fixed 27 Jun 2014 Fixed Description A SIGSEGV (infected with 11) can be logged in the SAP ASE errorlog on the Windows platform if the loginfo() built-in is called with three parameters and for whatever reason the built-in returns an error.

CR:759012

CR Number:   759012 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 17 Mar 2014 Fixed 18 Mar 2014 Fixed Description A 614 error - "Adaptive Server accessed a row that has an illegal length of <n> while in data base '<dbname>'. <page info>. The minimum row length is <n>. The page size is <n>." may be reported when executing DBCC CHECKDB on an unencrypted database that is encrypted first and then decrypted.

CR:759041

CR Number:   759041 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2014 Fixed 03 Jun 2014 Fixed 02 Jun 2014 Reservation Made 17 Jul 2014 Fixed Description Support online parallel create index.

CR:759142

CR Number:   759142 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) 21 Mar 2014 Fixed 26 Mar 2014 Reservation Made 31 Mar 2014 Fixed 15.7 SP111 24 Mar 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed 06 May 2014 Fixed Description When UPDATE STATISTICS is performed on a character column with a non-binary character set, and in addition UPDATE STATISTICS uses the consumers phrase, then there is the possibility of many small weight frequency cells following a zero weight range cell. This may cause poor query plan selection if a predicate selects a zero weight histogram cell. Optcriteria cr759142 will avoid generation of small frequency cells following a zero weight range cell, when the consumers phrase is used in UPDATE STATISTICS to generate stats on a mostly unique non-binary character set column. Workaround Description  Avoid using parallelism with update statistics i.e. avoid using the consumers phrase

CR:759143

CR Number:   759143 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) 12 Mar 2014 Fixed 15.7 SP111 12 Mar 2014 Fixed 25 Mar 2014 Fixed 15.7 SP121 19 Mar 2014 Fixed 16.0 GA PL01 19 Mar 2014 Fixed Description A poor query plan might be selected when parallel UPDATE STATISTICS (for instance using the consumers phrase) is used to gather statistics. After installing SAP ASE with the fix for this issue, update statistics will need to be run on affected tables. Workaround Description  do not use parallel update statistics instead use hashing or remove the consumers phrase from update statistics.

CR:759188

CR Number:   759188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2014 Fixed 24 Mar 2014 Fixed 15.7 SP111 01 Apr 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed 02 May 2014 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module sendtext() may be reported in the error log when a MERGE JOIN is being used and if the inner table has in-row LOB columns with NULL values.

CR:759245

CR Number:   759245 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) 10 Mar 2014 Fixed 10 Mar 2014 Reservation Made 15.7 SP111 10 Mar 2014 Fixed 26 Mar 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed 03 May 2014 Fixed Description If there are equality predicates or joins which are used for index keys, then occasionally an index which has few positioning keys specified than another index will be chosen. If 2 indexes have only equality predicates or equality joins used for keys, then a heuristic is added to choose the index with more limiting keys if those keys cover all the limiting and filtering keys of another index. The optcriteria EQUALS_SCAN_SUPERSET and trace flag 16989 will apply the heuristic to index scan which are not the inner of a nested loop join. The optcriteria EQUALS_NLJOIN_SCAN_SUPERSET and trace flag 16990 will apply the heuristics to all index scans. Note that the optcriteria are not turned on by any optgoal, and a SET command, user defined optgoal, or trace flag is needed to enable the heuristic.

CR:759270

CR Number:   759270 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2014 Fixed 01 Apr 2014 Fixed Description In rare cases, when a transaction rolls back, it may hit error 623 when starting the backward scan on a page. The 623 error message will indicate that the Rid pageid = 0; row num = 0. Workaround Description  sp_configure 'user log cache queue size', 0 Use this command to turn off buffer unpin optimization to avoid the problem, because the problem only happens if there are multiple PLCBLOCKs in each PLC. If there is single PLCBLOCK in the PLC, PLC lock itself is enough to synchronize scanner and flusher.

CR:759322

CR Number:   759322 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 18 Mar 2014 Fixed 19 Mar 2014 Fixed Description If replication is currently disabled and a table having non-materialized columns is dropped or one of its non-materialized defaults changes, then when replication is enabled again, it can encounter errors when trying to replicate that table's rows.

CR:759377

CR Number:   759377 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2014 Fixed 08 Apr 2014 Fixed 15.7 SP111 07 Apr 2014 Fixed 15 Apr 2014 Fixed 23 Apr 2014 One-off Provided 15.7 SP122 16 Apr 2014 Fixed 23 Apr 2014 Fixed 06 May 2014 One-off Provided Description In very rare situations, SAP ASE may panic and shutdown if sp_sysmon is being run and a connection disconnects at the same time. Workaround Description  disable running spinmon and sysmon

CR:759433

CR Number:   759433 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows 2008 Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2014 Fixed 21 Apr 2014 Fixed 04 Jul 2014 Fixed Description On Windows platform, SAP ASE may open an arbitrary listener port during MS DTC service initialization for distributed transaction management.

CR:759437

CR Number:   759437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2014 Work as design Description Hit error 8233 while doing concurrent SQL during reorg rebuild online. Workaround Description  TF2792 will solve the error 8233 and 540.

CR:759501

CR Number:   759501 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2014 Fixed 13 Mar 2014 Fixed 12 Mar 2014 Fixed 30 Jun 2014 Fixed Description Allow the command LOAD WITH VERIFYONLY to be executed using less stripes than the number used at DUMP time.

CR:759528

CR Number:   759528 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 13 Mar 2014 Fixed 31 Mar 2014 Fixed Description REORG command has been changed such that it cannot be executed while encryption or decryption of database is in progress.

CR:759562

CR Number:   759562 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2014 Fixed 06 Nov 2014 Port Not Needed 03 Jun 2014 Fixed Description Add support creation of a global index in parallel for a partitioned table that has one or more empty partitions. Previously, when creating a global index on partition table, if there were any empty partitions, then the index would be created in serial.

CR:759590

CR Number:   759590 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL01 13 Mar 2014 Fixed 14 Mar 2014 Reservation Made 14 Mar 2014 Fixed Description When SAP ASE is upgraded to 16.0 from 15.7 or later and the 16.0 server writes a new configuration file before being shut down after upgrade is complete, then that configuration file may contain entries that were unexpectedly changed from what the older version server originally configured.

CR:759624

CR Number:   759624 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2014 Fixed 27 Mar 2014 Presently Not Targeted For Any Future Release Of This Product 03 Apr 2014 Fixed 08 Jul 2014 Port Not Needed Description On ASE Cluster Edition insert jobs may unexpectedly continue to run with no new rows inserted into the target table. There are NO lost inserts but, dbcc checkalloc or tablealloc may report Msg 2546 or we may encounter deadlocks which can be seen in the error log.