远程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:735662
CR Number:   735662
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)
03 Oct 2013 Fixed
Description
In rare scenarios, highly contended system with large number of databases, workload consisting of large number of short dmls, rdbts_spin could be highly contended.



CR:735692
CR Number:   735692
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2014 Fixed
16 Jan 2014 Fixed
17 Jan 2014 Fixed
Description
The function row_count() when used on system tables returns zero after upgrade from SAP ASE 12.5.4
Workaround Description
 Run update statistics on system tables after upgrade.



CR:735705
CR Number:   735705
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2013 Fixed
Description
If a procedure get recompiled during execution, query against monProcessProcedures may get duplicate procedure entries.



CR:735727
CR Number:   735727
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2013 Fixed
Description
When updating an in-row LOB datum to NULL, the LTL generated for the update of the datum wrongly includes the LTL qualifier 'tpinit' instead of the qualifier 'zerolen'. This does not cause data corruption, or interruption of replication. Nevertheless, according to the LTL specification, the qualifier 'zerolen' must be used.



CR:735752
CR Number:   735752
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using ResultSet.deleteRow() from jdbc application against a select query (as updatable

cursor) involving a list of over 128 OR conditions it is possible that the delete will fail

with error 592.

This may also occur when issuing the sql language comnmand 'delete where current of'

against an updatable cursor.
Workaround Description
 Force the join order of the query by specifying an abstract plan which will put the OR scan

on the left side of the join.



'(join (values) (scan <table>))'



CR:735812
CR Number:   735812
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 08 Apr 2013 Fixed
09 Apr 2013 Fixed
06 Jun 2013 One-off Provided
Description
The unreserved space reported by either the stored procedure sp_helpdb or the builtin curunreservedpgs() could be wrong after executing any of the stored procedures sp_addsegment, sp_extendsegment or sp_dropsegment.



CR:735863
CR Number:   735863
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2014 Fixed
Description
When running optimization goal allrows_dss it is possible that an incorrect aggregate

result may be returned in rare circumstances involving a derived table or view containing

a union all with the aggregate operating on a constant in the select list on at least one

side of the union all.
Workaround Description
 set advanced_aggregation off --in user defined optgoal based on allrows_dss



--or



dbcc traceon (15341) --server-wide and can be used at startup if required.



CR:735868
CR Number:   735868
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2013 Fixed
Description
In rare case, SELECT on a DOL table with index may cause ASE to shut down with a timeslice error

and followed by a stack trace that includes the modules bt__handle_LAdone(), bt__qualpage(), bt__scan_massoffset() and bufoffset().



CR:735879
CR Number:   735879
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2013 Fixed
03 Apr 2013 Presently Not Targeted For Any Future Release Of This Product
Description
The backupserver sample resource file is missing ASE login and password attributes for sybatch.exe



CR:735884
CR Number:   735884
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2013 Fixed
29 Apr 2013 Fixed
29 May 2013 One-off Provided
08 Jul 2013 Port Not Needed
24 Jan 2014 Port Not Needed
Description
ASE may suffer from a memory leak when several client connections are simultaneously made using encrypted passwords.



CR:735895
CR Number:   735895
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2013 Consult Complete
08 Apr 2013 One-off Provided
17 Dec 2013 Port Not Needed
17 Dec 2013 Port Not Needed
Description
Instrumentation: ASE at times can hit timeslice error coming from ksctsuspend(). This could occur when configuration parameter "cis idle connection timeout" is set to a non default value and server has active CIS connections. Instrumentation is added under traceflag 7899 which prints diagnostic messages to the errolog when the issue occurs. Instrumentation is also added to avoid more than one CIS task from accessing a connection in parallel.



CR:736016
CR Number:   736016
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature requests on making session level settable options to limit

lio/cpu/locks/elapsed_time/tempdb_sapce similar to resource govern.
Workaround Description
 For queries with the potential to use many locks, the LOCK TABLE command can be used prior to the query to ensure a table lock is used rather than large numbers of page/row locks.



CR:736017
CR Number:   736017
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 01 Apr 2013 Fixed
31 Mar 2013 Fixed
Description
A 7949 error, "The number of pages used and unused for object <objid> index 255 partition <ptnid> on allocation page <alloc_page_no> do not match the counts in the OAM entry." followed by error 7940, "The counts in the OAM are incorrect. This implies that there are entries missing. Run tablealloc utility with the FIX option on the table with the inaccurate OAM counts." may be reported by DBCC TEXTALLOC and FULL option after inserting data with BCP into a table that has LOB columns and the option 'lob_compression' is enabled in the target database.
Workaround Description
 The 7949 errors can be corrected by running dbcc textalloc with fix option.



CR:736019
CR Number:   736019
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2013 Fixed
15.7 SP50 12 Jun 2013 Fixed
Description
When using hash based statistics collection and over 65535 unique values exist in the column then it is possible that the summary statistics (such as density) may be slightly inaccurate. If one looks at the optdiag output for the column and determines that a range cell is used for the first cell even though only one domain value can fit into the cell, then it is possible for summary statistics inaccuracies. It is possible, but unlikely, that query plans could be adversely affected.
Workaround Description
 avoid hash based statistics gathering for columns that may have this problem.



CR:736021
CR Number:   736021
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: kill command with time to complete warning client message b4 dead



CR:736079
CR Number:   736079
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 Aug 2013 Fixed
02 Aug 2013 Reservation Made
Description
A cheaper plan containing the merge_union_all operator may be skipped in favor of a more expensive plan using a sort operator on top of an append_union_all.
Workaround Description
 disable avoid_bmo_sorts optcriteria



CR:736093
CR Number:   736093
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2013 Fixed
Description
In rare cases in a cluster environment with more than one node, ONLINE DATABASE may hang if the log segment free space falls below a threshold.



CR:736132
CR Number:   736132
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Open
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: sp_showcontrolinfo warning message or allow to be run in any db



CR:736158
CR Number:   736158
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2013 Duplicate
Description
Builtin function object_id('"OBJECT_NAME"') may return null for quoted identifier if new parameter 'quoted identifier enhancements' = 1. To workaround, disable this new parameter via:

sp_configure 'quoted identifier enhancements', 0
Workaround Description
 Disable the related new parameter via

sp_configure 'quoted identifier enhancements', 0



CR:736179
CR Number:   736179
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#1 Refresh #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 PL00 02 Apr 2013 Fixed
15.7 SP50 10 Apr 2013 Fixed
05 Jun 2013 One-off Provided
03 Jun 2013 One-off Provided
18 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
16.0 16 Aug 2013 Fixed
16.0 16 Aug 2013 Fixed
Description
A 3261 error, "You cannot load this dump because it contains functionality that is available only on the server on which it was dumped" will be reported by LOAD DATABASE when trying to load a database dump which was taken while the database option "deallocate first text page" was active, or at least one table in this database had the attribute "dealloc_first_txtpg" set to 2.
Workaround Description
 Turn off db option "deallocate first text page" by

sp_dboption dbname, "deallocate first text page", off



CR:736268
CR Number:   736268
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2013 Fixed
29 May 2013 One-off Provided
15.7 SP50 11 Apr 2013 Fixed
15 Apr 2013 Reservation Made
07 May 2013 Fixed
29 May 2013 One-off Provided
15.7 SP110 04 Jun 2013 Fixed
Description
A login account that has a login-specific password expiration setting may have the global password expiration setting applied to it if the server encounters a 1204 (out of locks) error during the login attempt.



CR:736288
CR Number:   736288
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When dropping a HADR standby server, remove HADR environment from the dropped server without manual intervention if the server is reachable.



CR:736309
CR Number:   736309
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jul 2013 One-off Provided
19 Jul 2013 One-off Provided
20 Aug 2013 One-off Provided
12 Sep 2013 One-off Provided
16 Dec 2013 Port Not Needed
16 Dec 2013 Port Not Needed
Description
INSTRUMENTATION: In rare circumstances, Adaptive Server may crash as a result of SIGSEGV error in kbfalloc() while holding DATACHG_SPIN spinlock.
Workaround Description
 This issue was finally identified through the instrumentation to be a bug in QP code and resolved under 738117



CR:736349
CR Number:   736349
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 02 Apr 2013 Fixed
07 Jun 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Place the CR 702346 changes under a trace flag, disabled by default. CR 702346 changes are unlikely to be needed in ASE 15.7 due to different code paths.



CR:736426
CR Number:   736426
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.5 ESD #5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2013 One-off Provided
18 Sep 2013 One-off Provided
15.7 SP60 09 Aug 2013 Fixed
15.7 SP121 09 Sep 2013 Fixed
09 Sep 2013 Fixed
15 Oct 2013 Fixed
17 Jun 2014 One-off Provided
Description
The Java Compile Suite layer in Adaptive Server that is responsible for UDF/ADT support and SQLJ queries execution towards the target JavaVM has been enhanced to allow the release of intermediate allocated Java objects. This was causing the JavaVM heap memory allocation to be exhausted under a heavy load application environment.



CR:736428
CR Number:   736428
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2013 Fixed
15.7 SP110 29 May 2013 Fixed
Description
The message, "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = 1, Current count = 0" is wrongly reported in chain mode.



CR:736435
CR Number:   736435
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.7 SP50 23 Apr 2013 Fixed
15.7 SP110 02 Jun 2013 Fixed
Description
In rare circumstances, dropping a connection upon the CIS idle timeout may result in concurrent

execution of Ct-library calls which may result in undesirable behavior.



CR:736441
CR Number:   736441
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 an online (non-blocking) ALTER TABLE LOCK



CR:736499
CR Number:   736499
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Win32s
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 22 May 2013 Fixed
02 May 2013 Added to user documentation
Description
Linux client failed to redirect connections to Windows Server.



CR:736524
CR Number:   736524
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under very specific circumstances involving a join between the result of a concatenation

of a derived table (or view) column and a string value. Also involving a correlated sub-

query within the derived table definition it is possible for the optimizer to generate a

plan which may lead to an unexpected error 249 (or similar) dependant on data.
Workaround Description
 The options are to either convert to a char value on the right side of the join

to ensure the datatypes are comparable, or to protect against a null return from the min()

aggregate operation to guard against this kind of optimization.



For the repro, something like:-



select dt.* from

(select aa.a1 as aaa1, ab.a1 as aba1 from a aa inner join a ab on ab.a1= isnull ((select min(ac.a1) from a ac

where ac.a1 > aa.a1),'19000101')

) dt

where convert (char(6), dt.aba1,112) +'01' = dt.aaa1

go



--or



select dt.* from

(select aa.a1 as aaa1, ab.a1 as aba1 from a aa inner join a ab on ab.a1=(select min(ac.a1) from a ac

where ac.a1 > aa.a1)

) dt

where convert (char(6), dt.aba1,112) +'01' = convert (char,dt.aaa1)

go



CR:736535
CR Number:   736535
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2013 Duplicate
Description
On ASE 12.5.x, When DISK INIT is used to create a 32GB device on a raw partition using vdevno 255, it fails with error 5115 and corrupts the master device (zeros out pages in the config block and master database). The issue is not seen when vdevno 255 is a file system device, or if the size is less than 31 GB.



CR:736536
CR Number:   736536
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 13 May 2013 Fixed
13 May 2013 Presently Not Targeted For Any Future Release Of This Product
Description
sp_dbextend does not observe default device growby limits.
Workaround Description
 If we do not want the repro_data_1 device to autoexpand, have a policy for the device explicitly using:

sp_dbextend 'set', 'device', 'repro_data_1', '0'

go



CR:736538
CR Number:   736538
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)
29 May 2013 Fixed
15.7 SP50 03 Jun 2013 Fixed
15.7 SP110 05 Jun 2013 Fixed
Description
sp_sysmon gives wrong average values for 'Engine Busy Utilization' in process kernel mode.



CR:736550
CR Number:   736550
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 17 May 2013 Fixed
15.7 SP110 22 May 2013 Fixed
15.7 SP101 20 May 2013 Fixed
20 May 2013 Fixed
21 May 2013 Fixed
22 May 2013 Fixed
06 Jun 2013 One-off Provided
Description
Under rare circumstances a 696 error: "An attempt was made to read logical page '<page#>' for database '<dbname>' (<dbid>), object '<tablename>' ... from disk. Wrong logical page '<page#>' was brought into cache 'default data cache'." may be reported in the error log for allocation pages after the execution of CREATE, ALTER or LOAD DATABASE commands in an ASE installation using a page size that is greater than 2K-bytes and when during their execution the message "No large buffers were available, so pages are being cleared by writing each page separately. Please be patient" is reported. Alternatively a 2529 error, "Table Corrupt: Attempted to get page <page#>, partition ID 99; got page <page#>, partition ID 99." may be reported by DBCC CHECKALLOC.
Workaround Description
 Increase 'number of large i/o buffers'



CR:736603
CR Number:   736603
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4 PL3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 14 Aug 2013 Fixed
15.7 SP110 15 Aug 2013 Fixed
15.7 SP60 29 Aug 2013 Fixed
15.7 SP121 15 Aug 2013 Fixed
Description
In some rare cases, accessing a system table could result in 8201 error being raised.



CR:736622
CR Number:   736622
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2014 Fixed
20 Jan 2014 Port Not Needed
16 Jan 2014 Fixed
16 Jan 2014 Fixed
15.7 SP61 16 Jan 2014 Fixed
15.7 SP121 17 Jan 2014 Fixed
Description
When running REORG REBUILD against a table whose name or any column name might form part

of a reserved double or triple keyword phrase it is possible for an error 156

error to be reported along with error 11934 and for the REORG REBUILD command to abort.
Workaround Description
 Use sp_rename to rename the problematic identifiers then sp_rename to change it back

after reorg.



CR:736626
CR Number:   736626
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 09 Apr 2013 Fixed
09 Apr 2013 Fixed
23 Apr 2013 One-off Provided
06 Jun 2013 One-off Provided
Description
When ASE is configured with the 'process' kernel mode and with several engines, the RepAgent Thread may be infected with signal 11 in the module 'uctSetIssuedCnt' while shutting down with a stack trace reported in the error log which includes the modules 'usctclose' and 'ra_drop_csconn'.



CR:736645
CR Number:   736645
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2013 Fixed
Description
After downgrading from ASE 15.7 to ASE 15.5GA, when booting the ASE 15.5GA server, a segmentation fault may be encountered during startup while attempting to reconcile the downgraded configuration options.



CR:736699
CR Number:   736699
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2013 Fixed
11 Apr 2013 Reservation Made
Description
If there are significant concurrent activities which pin buffer cache pages in the named tempdb cache (or default data cache) then it is possible that the server could appear to hang due to lack of buffer cache. The kind of activity that could lead to this state is "hash based statistics gathering", "sorts", "query plans using hash operators".
Workaround Description
 lower "max resource granularity"

use sort based statistics gathering

have few concurrent sessions updating statistics or creating indexes with hashing

increase the size of the tempdb cache (or default data cache)



CR:736754
CR Number:   736754
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 11 Apr 2013 Fixed
11 Apr 2013 Fixed
Description
The error 2550, "Missing segment in sysusages segmap", will be unnecessarily reported by DBCC CHECKCATALOG if a database has a fragment with a segmap equal to 0.



CR:736819
CR Number:   736819
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2013 Bundled Request
30 Aug 2013 Added to user documentation
Description
A new option is added to 'Text' display mode to wrap long lines on Results panel.



CR:736888
CR Number:   736888
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2013 Fixed
03 Jun 2013 Reservation Made
Description
In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log" may happen while loading a transaction log dump containing a rollback of a CREATE INDEX operation in database that has ddl_in_tran option on.



CR:736902
CR Number:   736902
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 17 May 2013 Fixed
15.7 SP110 21 May 2013 Fixed
Description
Optdiag tool was running as a ctlib application of a lower version, so it misinterpreted (and wrongly displayed) BIGDATETIME and BIGTIME values reported for statistics.
Workaround Description
 If optdiag is being used to port statistics and the same underlying architecture is being used, then using optdiag in binary mode would preserve precision lost when converting to text.



CR:736951
CR Number:   736951
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 SP110 25 Jun 2013 Fixed
01 Aug 2013 Consult Complete
Description
Improved the RAT Multiple Scanners code concurrency by removing the usage of un-needed locking primitives.



CR:736957
CR Number:   736957
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 24 May 2013 Fixed
15.7 SP110 28 May 2013 Fixed
15.7 SP101 24 May 2013 Fixed
Description
In certain circumstances, databases, including system databases, can incorrectly get into LOG SUSPEND mode, issuing message: "Space available in the log segment has fallen critically low in database '<dbname>'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available." This may happen even though there is much unreserved space in the database. The problem may also manifest in 3475 errors: "There is no space available in SYSLOGS to log a record for which space has been reserved in database <dbname>."
Workaround Description
 alter database model on dbdevice=1 if LOG SUSPEND on model database with much unreserved space.



CR:736977
CR Number:   736977
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2013 Bundled Request
Description
In rare circumstances, an undetected deadlock may occur following a 1204 error: "ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS.", where the process that ran into the 1204 error holds the append log semaphore.
Workaround Description
 Increase the number of locks configured to reduce the likelyhood of running into 1204 errors.



CR:736978
CR Number:   736978
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)
16 Apr 2014 Fixed
16 Apr 2014 Reservation Made
Description
On High Availability (HA) System, accessing a proxy table may raise a 102 error (Incorrect syntax near '.') after failover occurs and the connection is migrated to the secondary companion ASE.
Workaround Description
 1. Use create existing table command without enclosing double quotes.



2. Run sp_remotesql servername, "set quoted_identifier on" after failover.



3. Create a login trigger which runs "set quoted_identifier on" in it.



CR:737039
CR Number:   737039
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 12 May 2013 Fixed
15.7 SP50 14 May 2013 Fixed
Description
A 941 error, "Illegal database context operation." may be repeatedly reported in the error log by the housekeeper wash task. An ASE reboot is the only option to stop this message from being reported.
Workaround Description
 Reboot and disable hk_wash using sp_configure "housekeeper free write percent", 0 to avoid infinite loop.



CR:737093
CR Number:   737093
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2013 Not reproducible with latest version of the product available as of Resolution Date
20 Jan 2014 Fixed
Description
When a table is partitioned based on a list of values including the NULL value, the NULL value may be ignored when compared to NULL, leading to wrong results.



CR:737108
CR Number:   737108
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2013 Fixed
15.7 SP60 31 Jul 2013 Fixed
30 Jul 2013 Fixed
Description
Assertion fail in le_subst.cpp maybe raised when index only contains fixed-length columns.



CR:737139
CR Number:   737139
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Internal error 724 or abstract plan errors may be raised when table names are also abstract plan operator names.



CR:737164
CR Number:   737164
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
Request for instrumentation to determine what is causing a database's keep count to become higher than it should be (left larger than zero after all processes have stopped using the database).



CR:737289
CR Number:   737289
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
sp_modifystats incorrect where clause in MODIFY_DENSITY



CR:737292
CR Number:   737292
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7 SP50 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2013 Fixed
Description
In some circumstances, monOpenObjectActivity may report ObjectCacheDate for the cached object as 'Jan 1 1900 12:00AM' or other wrong date value.



CR:737316
CR Number:   737316
Product Name:   Adaptive Server Generic Docs
Product Component:   Utility Guide
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2013 Insufficient info provided
Description
As of ASE 15.0 ESD2 no longer needs a separate license for DTM license,

it is part of ASE_CORE license



CR:737327
CR Number:   737327
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2013 Fixed
Description
Querying a DATE column from remote DB2 table may result in cs_convert overflow error.
Workaround Description
 Use bigdatetime for the column datatype in the "create existing table" statement.



CR:737335
CR Number:   737335
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When system get out of locks 1204 error this results in 3914 error from checkpoint processes and after this to resource clean up problem.



CR:737338
CR Number:   737338
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 17 Apr 2013 Fixed
23 Apr 2013 Fixed
Description
When the stored procedure sp_renamedb is executed from a read-only database, a wrong error message, "You cannot run stored procedure 'sp_renamedb' from a low durability database" is reported. The message should be "You cannot run stored procedure 'sp_renamedb' from a read-only database".



CR:737365
CR Number:   737365
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Windows
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 20 Jun 2013 Fixed
15.7 SP110 25 Jun 2013 Fixed
01 Jul 2013 Fixed
Description
DUMP DATABASE to TSM API on Windows platforms can fail with the error message, "D00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=109, system message=Cannot get operating system error tex." Occasionally, the message, "system message =The pipe has been ended. Refer to your operating system documentation for further details." can also be reported. This issues only affects ASE on the Windows platforms.



CR:737481
CR Number:   737481
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2013 Fixed
15.7 SP50 24 Apr 2013 Fixed
Description
In rare cases, when updating CHAR, VARCHAR or IN-ROW-LOB columns on a PAGE compressed table and there are many non-printable characters in the existing column value, the update may fail.



CR:737524
CR Number:   737524
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)
15.7 SP110 06 Aug 2013 Fixed
15.7 SP60 09 Aug 2013 Fixed
Description
In rare circumstances, an 8201 error, "Keep count of descriptor (objid=<obj_id>, dbid=<db_id>) was expected to be 1. Instead 2 was found" followed by a stack trace that includes the modules des__clean() and des__scavenge() when a system is running out of descriptors.



CR:737543
CR Number:   737543
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2013 One-off Provided
07 Jun 2013 Fixed
15.7 SP50 13 Jun 2013 Fixed
15.7 SP110 10 Jun 2013 Fixed
20 Nov 2013 One-off Provided
11 Nov 2013 One-off Provided
05 Jan 2015 One-off Provided
05 Jan 2015 One-off Provided
15 Jan 2015 Fixed
18 Jan 2015 Fixed
Description
Added a diagnostic check to help identify LRU chain issues. Trace flag 897 has been added to enable the instrumentation.
Workaround Description
 Have suggested the customer to

1.reduce 'housekeeper free write percent' from 25(%) to default 1(%)

2. create a new named cache tempdb_cache for tempdb to reduce default data cache contention



CR:737552
CR Number:   737552
Product Name:   Adaptive Server Enterprise
Product Component:   Component Drop
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2013 Added to user documentation
Description
This PC Client release for ASE157esd4.2 fulfills an SAP internal requirement. Content-wise, this PC Client is exactly the same as version released with ASE157esd4.



CR:737577
CR Number:   737577
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2013 Fixed
15.7 SP50 22 Apr 2013 Fixed
Description
The 3702 error,"Cannot drop the procedure 'sp_aux_getsize' because it is currently in use." will be raised if a user tries to drop the stored procedure sp_aux_getsize before the server has finished the recovery of every database.



CR:737628
CR Number:   737628
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 SP110 19 Jul 2013 Fixed
19 Jul 2013 Reservation Made
15.7 SP60 22 Jul 2013 Fixed
Description
Intelligient index scan may lead to non-optimal index in plan selection.
Workaround Description
 trace 15353



CR:737629
CR Number:   737629
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)
30 Jun 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
A query using the xmlextract() function terminates with an infected with 11 or timeslice error with the function bi__xml_query() on the stack.



CR:737697
CR Number:   737697
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.7 SP50 23 Apr 2013 Fixed
24 Apr 2013 Fixed
20 Jun 2013 Fixed
Description
When running UPDATE INDEX STATISTICS with SAMPLING command, numerous errors may be reported in the errorlog - 1105 errors: "Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment" and 1764 errors: "Failed to insert row into worktable, when projecting base table on to work table for collecting statistics".



CR:737702
CR Number:   737702
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 30 Apr 2013 Fixed
15.7 SP110 03 May 2013 Fixed
10 May 2013 One-off Provided
Description
Certain stored procedures created with "execute as caller" and using user defined datatypes may produce 2716 errors at execution time.
Workaround Description
 Don't use user defined datatypes.



CR:737712
CR Number:   737712
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 ASE to handle stack overflow issues for some queries with large IN or UNION clauses without crashing the server.



CR:737720
CR Number:   737720
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
3914 error with cluster edition 157esd4 and dynamic sql. conflicts in internal sql.



CR:737721
CR Number:   737721
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 to avoid flushing the BEGINXACT for a SELECT INTO command until the select starts producing rows to be inserted.



CR:737722
CR Number:   737722
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a supported method for dumping databases and transaction logs to Amazon cloud storage [Simple Storage Service (S3) API]



CR:737733
CR Number:   737733
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2013 Fixed
15.7 SP50 23 Apr 2013 Fixed
Description
The 12320 message, "Fatal internal error encountered when forwarding row <rowid> in table <tablename>, database <dbname> during update. Aborting the transaction" may be reported when updating a DOL row on a table defined as Page Compressed.



CR:737762
CR Number:   737762
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2013 Fixed
15.7 SP50 24 Apr 2013 Fixed
24 Apr 2013 Fixed
06 May 2013 Fixed
22 May 2013 Fixed
12 Jul 2013 One-off Provided
12 Jul 2013 One-off Provided
Description
Under rare circumstances backup server may produce unpredictable text attached to the dump trailer.



CR:737820
CR Number:   737820
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 an ALTER TABLE LOCK implementation that would minimize blocking by changing the lock scheme for rows only as they were modified. i.e. ASE would maintain up to three subtables (one for each lockscheme) and present a consistent view of them as one table.



CR:737824
CR Number:   737824
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2013 Fixed
15.7 SP50 22 Apr 2013 Fixed
23 Apr 2013 Fixed
Description
The 18124 message, "No matching configuration options" may be reported when executing sp_configure "solaris async i/o mode"



CR:737837
CR Number:   737837
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 SP110 07 May 2013 Fixed
15.7 SP101 06 May 2013 Fixed
Description
Shrinkpage() will raise a 631 error if the parent nonleaf page has only one nonleaf row that points to the shrinking page.



CR:737879
CR Number:   737879
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 17 Oct 2013 Fixed
15.7 SP60 11 Jul 2013 Fixed
19 Jul 2013 One-off Provided
07 Aug 2013 Reservation Made
21 Nov 2013 Fixed
Description
When backup server is started with trace flag 朌2048, the pages that have been allocated after the backup server built a list of pages to be archived and before the related allocation page is read by sybmultbuf, will be resent. Prior to dump a database one can run 揝YB_BACKUP卶atraceon 105 that will add appropriate messages in the backup server error log when a resent has occurred.



CR:737907
CR Number:   737907
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2013 Fixed
Description
If the server crashes in the middle of SHRINKDB, the segmap number on sysusages table may not be updated to 0.



CR:737933
CR Number:   737933
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Fixed
30 Aug 2013 Added to user documentation
Description
Add option to Connect Dialog to connect to the last-used database (instead of the default database).



CR:738007
CR Number:   738007
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 SP110 07 Jun 2013 Fixed
04 Jun 2013 Consult Complete
15.7 SP102 17 Jun 2013 Fixed
Description
In rare circumstances, the RepAgent thread may fail to terminate and hang in the module 'upsleepgeneric'. The execution for DBCC STACKTRACE(<RepAgent_spid>) would indicate the RepAgent sleeping in the modules 'usctcancel' and 'ksctsuspend'.
Workaround Description
 N/A unless you consider restarting ASE being a workaround (ugly).



CR:738033
CR Number:   738033
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.7 SP50 08 May 2013 Fixed
15.7 SP110 17 May 2013 Fixed
17 Oct 2013 Fixed
Description
When auditing option to remove java classes is turned 'on', sp_audit stored procedure returns with a message that the option is 'off'.
Workaround Description
 With below "remove" audit option turn on , cause the audit report wrong



# define AUDB_S_JCSREMOVE 0x40000000 /* jcs "remove" cmd success */

# define AUDB_F_JCSREMOVE 0x80000000 /* jcs "remove" cmd failure */



So the workaround is to turn it "off" if customer has turn it "on"



sp_audit "remove","all", db1, "off"



CR:738117
CR Number:   738117
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)
19 Jul 2013 Presently Not Targeted For Any Future Release Of This Product
23 Jan 2014 Port Not Needed
22 Aug 2013 One-off Provided
05 Sep 2013 One-off Provided
15.7 SP110 05 Sep 2013 Fixed
15.7 SP51 09 Sep 2013 Fixed
15.7 SP103 12 Sep 2013 Fixed
15.7 SP60 13 Sep 2013 Fixed
15.7 SP121 25 Nov 2013 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module ssql_release() or ssql_choose_victims() may be reported in the SAP ASE error log when the statement cache is full in a high concurrency SAP ASE environment.



CR:738127
CR Number:   738127
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Although the DOUBLE PRECISION datatype supports values up to ~1.79E308, the ASE parser raises errors 103 "The number that starts with ... is too long. Maximum length is 255." for values larger than 1.0E255 when submitted as a decimal string. Such large values can be inserted using E-notation.



CR:738162
CR Number:   738162
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to make AUDIT PROCESS EXCEPTION as more "Critical" or a "FATAL" message



CR:738189
CR Number:   738189
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 SP110 26 Apr 2013 Fixed
15.7 SP50 26 Apr 2013 Fixed
29 Apr 2013 Fixed
Description
Load dump with list_only=create_sql sometimes fails. A Unrecoverable I/O or volume error may be reported.



CR:738196
CR Number:   738196
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 SP110 19 Jul 2013 Fixed
15.7 SP60 28 Jul 2013 Fixed
29 Jul 2013 Reservation Made
Description
A core dump facility is added to the sybmon configurable shared memory dump feature. This is supported only on Windows platforms.



CR:738218
CR Number:   738218
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2013 Fixed
15.7 SP101 21 May 2013 Fixed
15.7 SP110 22 May 2013 Fixed
09 Sep 2013 Fixed
02 May 2014 Fixed
Description
A 1209 error, "Internal Error in lock manager routine: Attempted lock upgrade from shared intent to shared table in parallel query thread is illegal", may be reported in the error log during a SELECT or SELECT-INTO query on a table with parallel plan if there are concurrent DMLs or utilities operating on the table.
Workaround Description
 Increase the lock promotion threshold for pages and rows to a larger number.

sp_configure 'page lock promotion HWM', 10000

sp_configure 'page lock promotion LWM', 10000

sp_configure 'row lock promotion HWM', 20000

sp_configure 'row lock promotion LWM', 20000



CR:738286
CR Number:   738286
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
request to make the SySAM message "ASE will shutdown ..." a critical or fatal message,

not just a warning message



CR:738309
CR Number:   738309
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 SP101 29 Apr 2013 Fixed
29 Apr 2013 Fixed
Description
In rare circumstances, the task will hang when LIKE clause or patindex(builtin) operator on the columns which contain the LOB data defined as compressed.



CR:738319
CR Number:   738319
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 10 May 2013 Fixed
15.7 SP101 10 May 2013 Fixed
Description
After multiple HADR failovers, new client connections to a server in the HADR group may fail with error message "Read from the server has timed out" or "There is a tds login error".



CR:738322
CR Number:   738322
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)
28 May 2013 Fixed
15.7 SP110 28 May 2013 Fixed
15.7 SP50 29 May 2013 Fixed
11 Jun 2013 Fixed
29 May 2013 Fixed
26 Jul 2013 Fixed
21 Aug 2013 Consult Complete
21 Aug 2013 Fixed
05 Nov 2013 Fixed
29 Oct 2013 Fixed
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 (NB, CR 749101 also needed if the network interface has more than one IP address). 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.



CR:738367
CR Number:   738367
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 07 May 2013 Fixed
15.7 SP110 08 May 2013 Fixed
10 May 2013 One-off Provided
Description
Stored procedures using "execute as caller" with builtin functions may attempt to access objects that do not belong to the caller (but do belong to the procedure owner).
Workaround Description
 None known.



CR:738370
CR Number:   738370
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)
07 Jun 2013 One-off Provided
15.7 SP50 17 Jun 2013 Already Fixed by Another CR
27 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
08 Oct 2014 Port Not Needed
Description
HK skips flushing log masses causing non-positive wash deficit leading to 839 error



CR:738403
CR Number:   738403
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 06 Aug 2013 Fixed
15.7 SP121 18 Dec 2013 Fixed
17 Jan 2014 Fixed
15.7 SP111 21 Mar 2014 Fixed
Description
The show_cached_plan_in_xml() function reports incorrect timings on the AIX platform.



CR:738537
CR Number:   738537
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 05 Jun 2013 Fixed
15.7 SP110 10 Jun 2013 Fixed
Description
When LOAD DATABASE <dbname> WITH LISTONLY=LOAD_SQL is executed, incorrect output may be generated if the database was dumped using a dump configuration with an external API. As an example "LOAD DATABASE test FROM 'C:\Windows\system32\syb_tsm::test.DB.20130429.171214.000'" may be reported instead of "LOAD DATABASE test FROM 'syb_tsm::test.DB.20130429.171214.000'".



CR:738538
CR Number:   738538
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 SP110 03 May 2013 Fixed
03 May 2013 Fixed
15.7 SP101 16 May 2013 Fixed
Description
"shutdown with nowait" may fail to shutdown the server followed by SIGSEGV stacktrace with modules ktMuxThreadGetSchedQ(), ktMuxThreadTick(), utpApplyAll(), utpmApplyAll(), kaclkintr_thread() on the stack.



CR:738551
CR Number:   738551
Product Name:   SySAM
Product Component:   FLEXlm
Status:   Open
OS:   NA
Original Version:   2.2.1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request that allows licenses from sybase.subscribenet.com to be generated

in one batch.



CR:738552
CR Number:   738552
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 SP110 20 May 2013 Fixed
15.7 SP101 20 May 2013 Fixed
Description
If a table has small compressible off-row LOB columns that are not compressed due to size or other factors, ASE RepAgent may send an incorrect text length to Replication Server causing the Replication Server to stop replicating.
Workaround Description
 This problem only happens when bulk lib writetext is used by Rep Server to insert LOBs that can be compressed into a database and that same LOB gets replicated through another Rep Server. The second Rep Server will get a length error. Turning off compression or the use of bulk lib in Rep Server will eliminate this problem.



CR:738558
CR Number:   738558
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2013 Insufficient priority to fix
Description
The sysmessages entry for error 701 indicates the severity level is 19 when it is actually 17.





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