远程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:744696
CR Number:   744696
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 17 Sep 2013 Fixed
20 Nov 2013 Fixed
Description
On the Hpia64 platform, when SAP ASE is running on a real cluster in threaded kernel mode, if the XP server of an instance is shutdown from an isql session on another instance, the isql session will hang.



CR:744713
CR Number:   744713
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)
15.7 SP60 14 Aug 2013 Fixed
15.7 SP121 16 Aug 2013 Fixed
15.7 SP110 15 Aug 2013 Fixed
Description
Backup Server may wrongly issue the message, "The change is completed. The option is dynamic and SAP ASE need not be rebooted for the change to take effect", for an invalid configuration with a config_name more than the 30 bytes allowed.



CR:744714
CR Number:   744714
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2013 Fixed
12 Sep 2013 One-off Provided
15.7 SP103 10 Sep 2013 Fixed
15.7 SP110 10 Sep 2013 Fixed
15.7 SP121 10 Sep 2013 Fixed
Description
sqlupgrade and upgrade for unix to have dynamic timeout.
Workaround Description
 force serial recovery: max concurrently recovered db=1



CR:744740
CR Number:   744740
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)
15.7 SP110 06 Aug 2013 Fixed
Description
When displaying information about a dump from a file that was created on a different byte architecture with LOAD DATABASE ... WITH HEADERONLY, the error message, "Message too long", may be reported in the error log where it should display the originating device information.



CR:744803
CR Number:   744803
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2013 Fixed
29 Aug 2013 Fixed
29 Aug 2013 Fixed
Description



CR:744807
CR Number:   744807
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 Dec 2013 Reservation Made
23 Dec 2013 Fixed
13 Mar 2014 Fixed
21 Apr 2014 Fixed
Description
LPAD function will left-pad the input string with a specified pad to a supplied number of characters. RPAD function will right-pad the input string with a specified pad to a supplied number of characters.
Workaround Description
 Write a User Defined function.



CR:744810
CR Number:   744810
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 22 Aug 2013 Fixed
15.7 SP121 23 Aug 2013 Fixed
15.7 SP110 23 Aug 2013 Fixed
10 Mar 2014 One-off Provided
24 Jul 2014 Fixed
Description
If the SAP ASE configuration value 'cis connect timeout' limit is exceeded, the local process with the P_OMNI_TIMEDOUT status set will continue to sleep.
Workaround Description
 [celrod Aug 7 2013]



sp_configure 'cis connect timeout', 0



CR:744830
CR Number:   744830
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 22 Aug 2013 Fixed
19 Nov 2013 Fixed
Description
Aborting a bulk page allocation process can give 'table already closed' error while closing SYSALLOCPG.



CR:744842
CR Number:   744842
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 02 Sep 2013 Fixed
22 Aug 2013 Reservation Made
15.7 SP60 03 Sep 2013 Fixed
17 Nov 2013 Fixed
Description
Memory usage keeps increasing when querying MDA tables in a loop in stored procedure.
Workaround Description
 For this issue, there is a workaround. We can create a stored procedure like "mdatest_inner":

create proc mdatest_inner

as

select * from master..monProcessSQLText

go



Then, in a stored procedure like "mdatest_outer", we will execute "mdatest_inner":

create proc mdatest_outer

as

declare @i int



select @i = 0

while (@i < 7 * 24 * 60 * 60)

begin



exec mdatest_inner

select @i=@i+1

end

go



With this workaround, the memory increase issue would be gone.



CR:744872
CR Number:   744872
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)
15.7 SP110 12 Aug 2013 Fixed
15.7 SP60 14 Aug 2013 Fixed
Description
The 692 error, "Uninitialized logical page <page_no> was read while accessing database <dbname>, object 'syslogs' (8), ...", could be raised if the loginfo() built-in function is executed concurrently with DUMP TRANSACTION.



CR:744950
CR Number:   744950
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Track High Water Mark Usages of Procedure Cache per spid in monProcessesActivity.



CR:744954
CR Number:   744954
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In some ASE configuration sp_configure "max concurrently recovered db", 1 generate Error.



CR:744957
CR Number:   744957
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 06 Nov 2013 Fixed
07 Nov 2013 Fixed
Description
When the default of a non-materialized column is altered on a table that is replicated, extraneous updates to that column may be sent for replication.



CR:744975
CR Number:   744975
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2013 Fixed
15 Aug 2013 Reservation Made
15.7 SP121 20 Aug 2013 Fixed
15.7 SP60 19 Aug 2013 Fixed
Description
An incorrect index can be selected when a query contains a multi-column ORDER BY, if the avoid_bmo_sorts optcriteria is turned on explicitly or thru enabling the ase_current optimization level. If a sort is used below a nested loop join, and the ordering that the sort produced contains a unique key, and the ordering is extended by the nested loop join and eventually used to satisfy the ORDER BY, then this plan may be skipped if the avoid_bmo_sorts optcriteria is turned on.
Workaround Description
 avoid_bmo_sorts off



CR:744978
CR Number:   744978
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 19 Aug 2013 Fixed
15.7 SP110 15 Aug 2013 Fixed
23 Aug 2013 Reservation Made
15.7 SP60 23 Sep 2013 Fixed
Description
TEXT/IMAGE data could be corrupted by byte-swap if the database once performed cross-platform database load on 15.0 ESD#2 or later version of SAP ASE, and the database was originally from a pre-12.0 version of SAP ASE.



CR:745032
CR Number:   745032
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2013 Fixed
15.7 SP110 11 Sep 2013 Fixed
15.7 SP121 12 Sep 2013 Fixed
24 Jul 2014 Fixed
Description
set plan opttimeoutlimit does not follow the same rule as optgoal and optcritera for optimization and execution.
Workaround Description
 use opttimeout in the AP.



CR:745042
CR Number:   745042
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Documentation for the UNMOUNT DATABASE command should show that the command cannot be used if mirroring is enabled (via sp_configure "disable disk mirroring" being set off) even if mirroring is not used for any device used by the databases being unmounted. The attempt to unmount will fail with error 14543.



CR:745071
CR Number:   745071
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 15 Aug 2013 Fixed
15.7 SP60 19 Aug 2013 Fixed
15.7 SP110 19 Aug 2013 Fixed
03 Jun 2014 One-off Provided
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module TcsState::tcs_merge() may be reported in the error log when optcriteria cr702725 is enabled and the query invokes referential integrity check and has an attribute in the ORDER BY clause which is not in the selection list.
Workaround Description
 set cr702725 off



CR:745087
CR Number:   745087
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 Nov 2013 Fixed
Description
Signal 11 stacktrace might happen in LeEmitXchgOp::_LeOpNext() for a union query between a list partitioned table and other table(s).



CR:745098
CR Number:   745098
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2013 Fixed
Description
(INTERNAL_ONLY) Development oversight.



CR:745106
CR Number:   745106
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
monProcessSQLText.LineNumber does not report the same line as other monTable for the LineNumber column executing procedures.



CR:745112
CR Number:   745112
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2013 Fixed
26 Sep 2013 Fixed
15.7 SP121 17 Sep 2013 Fixed
15.7 SP121 10 Oct 2013 Fixed
Description
Modify srvbuild[res] and syconfig.exe/sybatch.exe utilities to support Remote Dump Host Control.



CR:745118
CR Number:   745118
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
select from a view that references another view get performance issue



CR:745141
CR Number:   745141
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2013 Fixed
Description
This is low-level thread coordination infrastructural code which the customer doesn't need to know about.



The low configuration/performance gains due to the use of transactional memory may be interesting to the customer though.



CR:745144
CR Number:   745144
Product Name:   Adaptive Server Enterprise
Product Component:   Language Modules
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_helpconfig "enable unicode conversions" shows you help information and messages including the wrong default value.



CR:745184
CR Number:   745184
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 21 Oct 2013 Fixed
15.7 SP60 22 Oct 2013 Fixed
07 Nov 2013 Fixed
Description
Execution of stored procedures containing statements that are executed using deferred compilation causes the original SQL text in the monProcessSQLText MDA table to be replaced.



CR:745205
CR Number:   745205
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Open
OS:   Linux
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Problem occurs when there are two calls to xp_cmdshell at the same time;

passes the return value of the second call to the first call.
Workaround Description
 Run kernel mode = process



CR:745283
CR Number:   745283
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 06 Sep 2013 Fixed
15.7 SP110 11 Sep 2013 Fixed
Description
SAP ASE on AIX does not use 'Large Pages' with the configuration option of 'lock shared memory', resulting in suboptimal memory access



CR:745325
CR Number:   745325
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2013 One-off Provided
20 Aug 2013 Reservation Made
23 Aug 2013 One-off Provided
15.7 SP121 04 Nov 2013 Fixed
15.7 SP60 23 Sep 2013 Fixed
08 Nov 2013 Fixed
08 Nov 2013 Reservation Made
Description
Boot SAP ASE with trace flag 9166 when dbcc logtransfer replication is used to diminish the likelihood of contention on the Network Memory Pool spinlock that can cause high CPU utilization when a user table is marked for replication. Don't use trace flag 9166 with Rep Agent replication because operations such as DDL replication or request functions won't work anymore.



CR:745388
CR Number:   745388
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Implement "reserved for future use" fields in sysqueryplans



CR:745425
CR Number:   745425
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 ESD#2 Refresh #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request a new DBCC tool to KILL a hung process which has P_KILLYOURSELF bit set in pss->pstat

for a long time. A process might be sleeping and waiting for an EVENT to happen, if the related code doesn't check attention, then it's possible to sleep forever if the EVENT doesn't happen due to some bug or some other reason. Reboot to clear the hung process is not easy for some production systems since DBAs may need to schedule reboot time.



CR:745446
CR Number:   745446
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2013 Fixed
Description
A stacktrace may occur if auto_temptable_stats is enabled along with parallel sort, either explicitly or via using ase_current. This change will disable parallel statistics gathering on #temptables when update statistics is implicitly invoked via the auto_temptable_stats feature.



CR:745455
CR Number:   745455
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2014 Insufficient priority to fix
28 Aug 2013 DEFER
Description
The global variable @@setrowcount does not reflect the value of the last 'set rowcount <nn>' command in a stored procedure nor in the current batch.
Workaround Description
 None known



CR:745472
CR Number:   745472
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2014 Fixed
29 Sep 2014 Reservation Made
Description
Incorrect output of message 3705 is displayed when executing DBCC TABLE sysdams if trace flag 3717 is on.
Workaround Description
 if you want correct error message for dropping system table sysdams,

trun off the trace flag 3717.



if you want to drop the sysdams, use

dbcc dam(<dbname>, 'drop')



CR:745492
CR Number:   745492
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2013 Consult Complete
15.7 SP121 07 Nov 2013 Fixed
14 Nov 2013 Fixed
Description
srvbuild creates a sparse file for tempdb file system device
Workaround Description
 See resolution #1 description for work around/fix.



CR:745539
CR Number:   745539
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow that any login with sa_role NOT be able to delete an entire user table which has encryption column.



CR:745571
CR Number:   745571
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2014 Fixed
Description
An error stating "Incorrect syntax near '":s: %1!"'" may occur when attempting to start the ASE Job Scheduler from within the SCC ASE Administration Console.
Workaround Description
 The workaround is for the user to log into the ASE under an account that has js_admin_role role and execute 憇ybmgmtdb.. sp_sjobcontrol @name=NULL, @option="start_js" .



CR:745599
CR Number:   745599
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 04 Oct 2013 Fixed
15.7 SP121 04 Oct 2013 Fixed
04 Oct 2013 Fixed
16 Oct 2013 One-off Provided
16 Oct 2013 One-off Provided
15 Oct 2013 Port Not Needed
Description
In rare circumstances the message "current process infected with 6" in the module '__systemcall' together with a stack trace which includes the modules 'jvmfini' and 'BRIDGEjvm_AbortJavaVM' may be reported in the error log during the execution of a UDF/ADT or SQLJ query.



CR:745608
CR Number:   745608
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
create index allowes [.] in index name which then can not be dropped.
Workaround Description
 drop table [indexname]



CR:745655
CR Number:   745655
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2013 Fixed
Description
If the number of the engines is over 33, max repartition degree is 1 (default) and the tables for the join is unpartitioned, it could lead to stacktrace.



CR:745776
CR Number:   745776
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2013 Fixed
24 Sep 2013 Reservation Made
Description
A new configuration option "LARGE ALLOCATION AUTO TUNING" is added to enable/disable large allocation auto tuning feature



CR:745786
CR Number:   745786
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error 871 after exceeding the resource governor



CR:745795
CR Number:   745795
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 01 Sep 2013 Fixed
16.0 19 Nov 2013 Fixed
Description
A 15052 error, "Index error: Table id <tabid>, indid <indid> calculated <name> <value1> does not match value <value2> in Sysindexes." may be reported when running DBCC CHECKCATALOG on a database containing tables with option 'transfer table' on.



CR:745872
CR Number:   745872
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)
15.7 SP60 13 Sep 2013 Fixed
15.7 SP121 09 Oct 2013 Fixed
17 Nov 2013 Fixed
Description
When the command: sp_online "engine", <42> .. fails, i.e due to OS resource issue, SAP ASE's listener will hang, preventing new connections to be established.



CR:745873
CR Number:   745873
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 30 Aug 2013 Fixed
20 Sep 2013 One-off Provided
02 Sep 2013 Fixed
15.7 SP121 27 Sep 2013 Fixed
10 Apr 2014 Fixed
03 Oct 2013 Fixed
04 Sep 2013 Fixed
15.7 SP60 04 Sep 2013 Fixed
15.7 SP51 24 Sep 2013 Fixed
15.7 SP51 06 Sep 2013 Fixed
15.7 SP103 10 Sep 2013 Fixed
15.7 SP103 24 Sep 2013 Fixed
15.7 SP60 24 Sep 2013 Fixed
15.7 SP110 25 Sep 2013 Fixed
01 Oct 2013 Fixed
17 Jun 2014 Fixed
Description
In rare cases a 692 error, "Uninitialized logical page '<pageno>' was read while accessing database ..." may be reported sometime after loading a database dump that was taken of a database in both Enterprise Edition and Cluster Edition, that had been created on devices with 揹irect i/o turned on, or taken of a database in a Cluster Edition system only, that had been created on devices with 揹sync turned on.



CR:745888
CR Number:   745888
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)
15.7 SP60 18 Oct 2013 Fixed
04 Nov 2013 Bundled Request
15.7 SP121 18 Oct 2013 Fixed
Description
The FIPS ciphersuites are stricter in OpenSSL not all ciphersuites that were supported

by Certicom in FIPS mode are supported by OpenSSL.



CR:745914
CR Number:   745914
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 16 Sep 2013 Fixed
15.7 SP60 17 Sep 2013 Fixed
11 Nov 2013 Fixed
15.7 SP111 31 Mar 2014 Fixed
Description
DBCC CHECKALLOC may report an incorrect number of unreserved log pages after ALTER DATABASE LOG OFF fails to remove a log fragment because some of the pages to remove are allocated.



CR:746028
CR Number:   746028
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 30 Oct 2013 Fixed
02 Dec 2013 Fixed
15.7 SP111 05 Mar 2014 Fixed
12 Mar 2014 Fixed
Description
If a UDR roleid is greater than 1024 then a timeslice error may be reported in the SAP ASE errorlog.
Workaround Description
 This case is due to invalid srid.

The customer may try to void manually changing the system catalogs, or use an srid that is not currently in use. The new srid must be between the max srid+1 and less than 1024.



CR:746056
CR Number:   746056
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)
15.7 SP121 14 Oct 2013 Fixed
27 Nov 2013 Port Not Needed
Description
Sybcluster needs to support remote dump host control.



CR:746083
CR Number:   746083
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2013 Fixed
02 Apr 2014 Fixed
31 Mar 2014 Fixed
Description
feature request: backupserver binary compiled for 64-bit to enable larger memsize on solaris



CR:746101
CR Number:   746101
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)
28 Feb 2014 Fixed
05 Mar 2014 Fixed
09 Jul 2014 Port Not Needed
08 Jul 2014 Port Not Needed
Description
When using sp_downgrade to downgrade an SAP ASE from version 15.7 or higher to an SAP ASE that is version 15.5 based, the keycnt in sysindexes for index sysattributes.ncsysattributes will become incorrect.



CR:746156
CR Number:   746156
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2013 Fixed
15.7 SP121 26 Sep 2013 Fixed
15.7 SP60 26 Sep 2013 Fixed
Description
In some rare cases, when DOL data pages are undergoing deallocation while table scans are concurrently executed on the table, inserts from other concurrent threads may incorrectly qualify to-be-deallocated pages. This may result in 7928 or other index corruption errors reported from

DBCC CHECKTABLE.



CR:746179
CR Number:   746179
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2013 Fixed
13 Dec 2013 Reservation Made
Description
New feature to specify configuration parameters like interface file or error log file for Job Scheduler Agent using sp_jsconfigure.
Workaround Description
 Start jsagent manually before ASE with the required parameters.



CR:746207
CR Number:   746207
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 325 'no legal query plan' when query include proxy table defined for a procedure.



CR:746216
CR Number:   746216
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2013 Fixed
Description
The fields NumberOfMempoolAllocates, NumberOfMempoolFrees, MempoolCurrentSize and MempoolHighUsage

in master..monRepLogActivity are only maintained when sp_sysmon is running in parallel at the

same time.
Workaround Description
 The counters are only populated when sp_sysmon runs. One could start sp_sysmon like

sp_sysmon "00:10:00" and select from master..monRepLogActivity at the same time.



CR:746238
CR Number:   746238
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 11 Sep 2013 Fixed
28 Nov 2013 Bundled Request
Description
Enhance DBCC REINDEX to support RID comparison mode change for empty deferred_allocation table.
Workaround Description
 For empty deferred table, dbcc reindex() does nothing.

For this case, we can write procedure to update status bit

directly. Below is an example.



create procedure rid_reset_deferred_tab

as

begin

declare @objid int

declare @indid smallint



print "please make sure this proc is run in target databases."



set proc_return_status off

set nocount on



declare c cursor for

select id , indid from sysindexes where indid != 0 and status & 256 = 256

and id in (select id from sysobjects where sysstat3 & 128 = 128)



open c

fetch c into @objid, @indid

while (@@sqlstatus = 0)

begin

update sysindexes set status = (status & ~256) where id =@objid and indid = @indid

-- select name,id,indid,status from sysindexes where id =@objid and indid = @indid

fetch c into @objid, @indid

end



close c

deallocate cursor c

end

go

sp_configure 'allow updates to system tables',1

go

use db1

go

exec rid_reset_deferred_tab

go

sp_configure 'allow updates to system tables',0

go



CR:746255
CR Number:   746255
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2013 Fixed
15.7 SP121 11 Sep 2013 Fixed
15.7 SP110 11 Sep 2013 Fixed
Description
The cache partition maximum value has been increased to 256. The MAX value in cfg_options has been updated to be applicable for all stored procedures.



CR:746260
CR Number:   746260
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 04 Sep 2013 Fixed
15.7 SP121 09 Sep 2013 Fixed
Description
Logging into remote server using a login user granted with a user-defined role will fail.



CR:746261
CR Number:   746261
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP50
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 05 Nov 2013 Fixed
15.7 SP121 12 Nov 2013 Fixed
20 Nov 2013 Fixed
27 Nov 2013 Port Not Needed
Description
SAP ASE CE hangs when it cannot access storage devices due to a fencing or storage disconnect.



CR:746285
CR Number:   746285
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)
15.7 SP60 18 Nov 2013 Fixed
15.7 SP121 22 Nov 2013 Fixed
02 Dec 2013 Fixed
22 Nov 2013 Reservation Made
Description
Enhancement that adds the possibility to add a cyclic redundancy check to a database or transaction dump created with compression (VERIFY=CRC), as well as to verify that the compression blocks can be correctly read and decompressed (WITH VERIFY=READ_AFTER_WRITE).



CR:746312
CR Number:   746312
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)
25 Sep 2013 Fixed
15.7 SP121 25 Sep 2013 Fixed
15.7 SP60 25 Sep 2013 Fixed
15.7 SP110 23 Sep 2013 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module mda_calc_proc_hdr_mem_KB() may be reported in the error log while querying the MDA table, monProcessProcedures.
Workaround Description
 Do not query monProcessProcedures.



CR:746317
CR Number:   746317
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UNIX
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepAgent signal 11 and stack trace



CR:746330
CR Number:   746330
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)
15.7 SP60 15 Oct 2013 Fixed
07 Nov 2013 Fixed
14 Oct 2013 Reservation Made
15.7 SP121 28 Oct 2013 Fixed
29 Oct 2013 One-off Provided
Description
When sp_maplogin LDAP, NULL, 'create login' enables an authenticated LDAP user to create their own login and master database replication is enabled, the CREATE LOGIN statement on the replicate database gets error:

"Message: 10331, State 2, Severity 14 -- 'Permission denied, database master, owner dbo. You need the following permission(s) to run this command: MANAGE ANY LOGIN. "

The error is mapped to stop replication.



CR:746344
CR Number:   746344
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 Sep 2013 Fixed
15.7 SP121 16 Sep 2013 Fixed
15.7 SP60 17 Sep 2013 Fixed
Description
SAP ASE may hang when doing a disk mirror in some situations. The disk controller thread consumes 100% of the CPU utilization while the server hangs. Also, no new connections to the server can be established.



CR:746349
CR Number:   746349
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Windows W2k
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 06 Sep 2013 Fixed
11 Nov 2013 Bundled Request
11 Nov 2013 Bundled Request
12 Nov 2013 Fixed
15.7 SP60 11 Dec 2013 Fixed
17 Mar 2014 Bundled Request
11 Jun 2014 Fixed
13 Jun 2014 Port Not Needed
Description
Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature. Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE. The location and name can be changed using the Backup Server parameter -h. This feature failed when the connection to the backup server was through a named pipe.



CR:746367
CR Number:   746367
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2013 Fixed
17 Jan 2014 Added to user documentation
Description
monSpinlockActivity configuration option to decompose the aggregate data.
Workaround Description
 use the information from the sysmonitors table.



CR:746376
CR Number:   746376
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 09 Sep 2013 Fixed
15.7 SP110 09 Sep 2013 Fixed
09 Sep 2013 Fixed
Description
After shrinking database, DDLGen encounters the error message, "DDLGen started with the following .... Found 1 dbids with wrong number of rows cached in '#seginfo' v/s the rows in 'master.dbo.sysusages'".



CR:746378
CR Number:   746378
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guides - All Platforms
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2013 Added to user documentation
Description
Doc CR: disable ldap before upgrade for install guides



CR:746437
CR Number:   746437
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2013 Added to user documentation
Description
Investigate if 753 traceflag can be changed to a sp_configure option.



CR:746438
CR Number:   746438
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Investigate if 753 traceflag can be changed to a sp_configure option.



CR:746442
CR Number:   746442
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   NA
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 06 Sep 2013 Fixed
11 Nov 2013 Fixed
15.7 SP60 12 Nov 2013 Fixed
13 Nov 2013 Fixed
01 Apr 2014 Already Fixed by Another CR
11 Jun 2014 Fixed
Description
Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature. Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE. The location and name can be changed using the Backup Server parameter -h. This feature failed when the connection to the backup server was through a AF_UNIX socket.



CR:746443
CR Number:   746443
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_sysmon to have a spinlockactivity section.
Workaround Description
 use the information from the sysmonitors table.



CR:746464
CR Number:   746464
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)
30 Sep 2013 One-off Provided
15.7 SP60 24 Sep 2013 Fixed
24 Sep 2013 Reservation Made
15.7 SP121 26 Sep 2013 Fixed
28 Feb 2014 One-off Provided
21 Nov 2013 Bundled Request
Description
Stored procedures using "execute as caller" with queries that call builtin function ISNULL() and create and query #temporary tables fail with error:

Msg 208, Level 16, State 1:

Server '<servername>', Line 26:

<#temporary_table> not found.
Workaround Description
 create table "#T1" outside the proc:



IF OBJECT_ID('#T1') IS NOT NULL

BEGIN

DROP TABLE #T1

IF OBJECT_ID('#T1') IS NOT NULL

PRINT '<<< FAILED DROPPING TABLE #T1 >>>'

ELSE

PRINT '<<< DROPPED TABLE #T1 >>>'

END



CREATE TABLE #T1

(

colA int,

colB char(8)

)



Create procedure jProc01

with execute as caller

as



SELECT

#T1.colA,

convert(varchar(8) , isnull(jTab01.colB,'ABCD'))

-- convert(varchar(8) , jTab01.colB)



FROM #T1, jTab01

WHERE 1 = 2





return 0

go



exec jProc01

go



colA

----------- ----------------



(0 rows affected)

(return status = 0)



CR:746475
CR Number:   746475
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 13 Sep 2013 Fixed
12 Sep 2013 Reservation Made
15.7 SP110 13 Sep 2013 Fixed
Description
In an HADR configured server, "select * from monHADRMembers" may cause timeslice error like "timeslice -1001, current process infected at 0x15efbc4 (atomic_try+0x2)".



CR:746476
CR Number:   746476
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_poolconfig need enhancing to allow the wash size to revert to default bahviour



CR:746528
CR Number:   746528
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)
15.7 SP60 23 Sep 2013 Fixed
15.7 SP121 17 Dec 2013 Fixed
09 Jan 2014 Fixed
Description
Killing a task which involves cursor or work tables might cause the server to hang, waiting for EX_LATCH on an allocation page on which EX_LATCH had been acquired by the same task before the 'kill' was issued on it. (A diagserver throws an 872 error).



CR:746562
CR Number:   746562
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 13 Sep 2013 Fixed
Presently Not Targeted For Any Future Release Of This Product
15.7 SP110 13 Sep 2013 Fixed
15.7 SP103 18 Sep 2013 Fixed
15.7 SP121 04 Oct 2013 Fixed
Description
A trigger defined on MERGE statement executing both INSERT and UPDATE actions may return incorrect rows for inserted table for the INSERT action.

This happens if the same trigger is defined for both INSERT and UPDATE:

"create trigger T on TAB for insert,update as ..."



CR:746597
CR Number:   746597
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP51 09 Sep 2013 Fixed
15.7 SP103 11 Sep 2013 Fixed
15.7 SP51 10 Sep 2013 Fixed
15.7 SP51 10 Sep 2013 Fixed
12 Sep 2013 Presently Not Targeted For Any Future Release Of This Product
15.7 SP110 13 Sep 2013 Fixed
15.7 SP121 31 Oct 2013 Fixed
15.7 SP60 13 Sep 2013 Fixed
13 Sep 2013 Reservation Made
Description
In some cases an error may be reported in the SAP ASE errorlog, accompanied by a stack trace with the functions kbfalloc() and ptn__pdes_init_colupdcnt() in the stack.



CR:746601
CR Number:   746601
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 20 Oct 2013 Fixed
15.7 SP121 12 Dec 2013 Fixed
12 Dec 2013 Fixed
Description
When a table which is defined as compressed, and there is some fixed length column which is

'not null' and 'not materialized' in this table, update (index) statistics on this table may

hit stack trace and SIGSEGV at decompress__column_by_colinfo().



CR:746614
CR Number:   746614
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)
15.7 SP121 13 Sep 2013 Fixed
15.7 SP110 13 Sep 2013 Fixed
15.7 SP60 07 Oct 2013 Fixed
Description
INSERTs using normal page allocation running alongside operations using large-scale page allocation (LSA) scheme can overwrite the content put in by LSA operations in certain race circumstances between them.



CR:746620
CR Number:   746620
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 13 Sep 2013 Fixed
15.7 SP60 24 Sep 2013 Fixed
15.7 SP110 13 Sep 2013 Fixed
Description
A process can hang when executing ALTER DATABASE and DUMP DATABASE if another process goes to sleep when allocating a new page.



CR:746697
CR Number:   746697
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
SCC Arithmetic overflow on 3.2.8



CR:746736
CR Number:   746736
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 11 Sep 2013 Fixed
15.7 SP60 11 Sep 2013 Fixed
11 Sep 2013 Fixed
Description
The text for error 9218 mistakenly stated sp_enable_rep_agent as opposed to sp_config_rep_agent in order to enable the Rep Agent for a given database.



CR:746741
CR Number:   746741
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 13 Sep 2013 Fixed
15.7 SP121 16 Sep 2013 Fixed
Description
Job Scheduler fails to schedule the job which does not specify end date and has the continuous_run property set.
Workaround Description
 Also set enddate with continuous_run property.



CR:746759
CR Number:   746759
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2014 Fixed
Description
New feature request to print trailer information from a dump archive. The new option is LOAD DATABASE <dbname> WITH LISTONLY=TRAILER.



CR:746820
CR Number:   746820
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)
15.7 SP121 12 Sep 2013 Fixed
11 Nov 2013 Fixed
Description
Online database will fail with the message 2778, "The object 'sysdams' is not a table. Update statistics can be used only on user tables or system tables" if a cross platform database dump from a lower version that requires upgrade is loaded.



CR:746826
CR Number:   746826
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2014 Fixed
Description
A 9950 error, "Workspace '<name>' is incorrectly allocated. Use sp_dbcc_createws to create a new workspace." may be reported when running DBCC CHECKSTORAGE.
Workaround Description
 delete the related workspace and recreate one,

or configure another new related workspace for the database,

or update the statistics for the related workspace.



CR:746827
CR Number:   746827
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 09 Dec 2013 Fixed
Description
The monitoring table monRepSenders has been enhanced with information such as counters for the number of bytes sent and number of commands processed with information that is useful for a single-task Rep Agent.
Workaround Description
 n/a



CR:746850
CR Number:   746850
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
High fowarded row count for some big expand UPDATE transaction on 15.0.3 ESD4 and 15.7 SPxx ASE. No forwarded row if update one row per transaction.



CR:746994
CR Number:   746994
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 27 Sep 2013 Fixed
15.7 SP60 07 Oct 2013 Fixed
15.7 SP121 29 Sep 2013 Fixed
Description
The DISK REMIRROR command hangs after simulating a disk I/O error on a mirrored device.



CR:747043
CR Number:   747043
Product Name:   SCC Web Framework
Product Component:   Other
Status:   Closed
OS:   RH Linux
Original Version:   3.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2013 Fixed
26 Sep 2013 Fixed
01 Oct 2013 Fixed
Description
Fixes issue related to automatic generation of heapdump which is required in support cases to help triage issue



CR:747046
CR Number:   747046
Product Name:   Adaptive Server Enterprise
Product Component:   ODATA Provider
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2014 Fixed
Description
The odata metadata query shows precision=0 and scale=0 for money, smallmoney, datetime, bigdatetime, time data types. The values are now displayed correctly following the code change.



CR:747071
CR Number:   747071
Product Name:   Sybase SQL Server
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2013 One-off Provided
21 Oct 2013 One-off Provided
28 Oct 2013 One-off Provided
03 Oct 2014 Port Not Needed
Description
EBF21805: Provide one-off for CR 735346,737108,743270,743676



CR:747089
CR Number:   747089
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 16 Jan 2014 Fixed
16.0 18 Jan 2014 Fixed
Description
When Rep Agent is configured for 'stream replication' and sync or near sync stream mode, two user tasks running in parallel DML and DDL on the same table may lead to hang one of the user tasks and Rep Agent waiting each other till the 'max commit wait' is reached. Rep Agent will then switch to asynchronous mode.



CR:747092
CR Number:   747092
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 18 Nov 2013 Fixed
Description
When using syconfig to upgrade backup server 12.5.4 to 15.7, the character set in configure backup server dialog is empty.



CR:747100
CR Number:   747100
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)
15.7 SP121 31 Oct 2013 Fixed
16.0 29 Nov 2013 Fixed
Description
In rare circumstances the message "WARNING: memory usage in procedure

headers (...) does not match memory usage count in Pss (...) for server

process id ..." may be reported in the error log when the configuration

options "enable functionality group" and "plan sharing" are active and

the execution of a prepared statement is interrupted due to an error

that caused the current transaction to be aborted.



CR:747110
CR Number:   747110
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 02 Dec 2013 Fixed
Description
Add step to preupgrade to check the configuration option 'user log cache size' is sufficient for using buffer unpinning optimization in the ASE 16.0 server.



CR:747158
CR Number:   747158
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 Jan 2014 Bundled Request
Description
In a jConnect application with DYNAMIC_PREPARE set to true, auditing of DML statements doesn't print the correct parameter values when the same cursor is closed and opened again.



CR:747168
CR Number:   747168
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2014 Fixed
25 Feb 2014 Fixed
15.7 SP111 28 Feb 2014 Fixed
15.7 SP121 26 Feb 2014 Fixed
16.0 GA PL01 05 Mar 2014 Fixed
Description
A 702 error, "Memory request for NN bytes exceeds the size of single page of 16384 bytes. ASE is terminating this process", may be reported when using queries with tables that have more than 4192 partitions.
Workaround Description
 Use fewer than 4192 partitions per table.



CR:747170
CR Number:   747170
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
request to add Traceflag 7786 functionality as an sp_configure option





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------