远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

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.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------