远程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:738633
CR Number:   738633
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 14 Jun 2013 Fixed
15.7 SP101 10 May 2013 Fixed
Description
RepAgent may run out of memory and shutdown if started and stopped a large number of times.
Workaround Description
 Increase the RAT memory configuration parameter using:

sp_configure 'replication agent memory size', <size>.



CR:738655
CR Number:   738655
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP101 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 06 Jun 2013 Fixed
Description
Inappropriate right truncation error is raised when long BINARY values at or near the full width of a long column are inserted via dynamic SQL prepared statement.



CR:738675
CR Number:   738675
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 09 May 2013 Fixed
15.7 SP101 09 May 2013 Fixed
15.7 SP60 30 Oct 2013 Fixed
Description
Database device remapping is disabled when a database is loaded with VERIFY.



CR:738692
CR Number:   738692
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 18 Jun 2013 Fixed
17 Jun 2013 Reservation Made
15.7 SP50 18 Jun 2013 Fixed
Description
When a query involves multiple subqueries under, and the final plan places the subquery JOIN operator at the top of the plan, then there a much better plan that may be skipped. Optcriteria cr738692 will turn on the fix.
Workaround Description
 Turning off the avoid_bmo_sorts optcriteria and/or conserve_tempdb_space may force the correct plan.



CR:738710
CR Number:   738710
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 09 May 2013 Fixed
15.7 SP101 09 May 2013 Fixed
15.7 SP50 10 May 2013 Fixed
Description
A Fault Type Error 100008, "Fixed format error", may be reported by DBCC CHECKSTORAGE if DBCC

CHECKDB or DBCC CHECKTABLE is run on a database/table which contains variable length columns previously.



CR:738731
CR Number:   738731
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 05 Jun 2013 Fixed
Description
An 806 error, "Could not find virtual page for logical page <page_id> in database <db_name>", may be reported when executing DBCC CHECKTABLE/CHECKINDEX/CHECKDB/REINDEX after shrinking a database containing a table with suspect index.
Workaround Description
 rebuild suspect index using DBCC REINDEX or REOGR REBUILD after shrinking database.



CR:738733
CR Number:   738733
Product Name:   Adaptive Server Enterprise
Product Component:   Component Drop
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2013 Fixed
Description
This PC-Client SP is based on SDK 15.7 SP100. A list of changes in SDK 15.7 SP100 is available at http://download.sybase.com/swr/16980/EBF21006_README.html



CR:738744
CR Number:   738744
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)
15.7 SP101 08 May 2013 Fixed
15.7 SP110 16 May 2013 Fixed
Description
The message, "Error: sdt_getpage: Attempt to read page '0' but device <device_name> is not open.

Exiting", is reported when a cumulative dump is used as a metadata file for sybdumptran.



CR:738747
CR Number:   738747
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)
21 May 2013 Insufficient priority to fix
Description
select * into to support create of the primery key.



CR:738758
CR Number:   738758
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 04 Jun 2013 Fixed
15.7 SP110 02 Jul 2013 Fixed
21 Jun 2013 One-off Provided
10 Oct 2013 One-off Provided
21 Oct 2013 One-off Provided
10 Mar 2014 One-off Provided
24 Jul 2014 Fixed
Description
A CIS spid in a 'terminating' state might hang at times in the usctconnect() function as observed in the DBCC STACKTRACE(spid) output.



CR:738771
CR Number:   738771
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2013 Fixed
15.7 SP50 18 Jun 2013 Fixed
15.7 SP110 27 Jun 2013 Fixed
14 Jun 2013 Reservation Made
Description
Under rare circumstances, a 12313 error, "Internal error: Insert into page id <pageno> of index id <indid> of table 'sysobjects' (id= 1) in database '<dbname>' tried to replace undeleted RID (<pageid>,<rownum>) at slot <slotnum> and ridposn <ridposn>. Try dropping and recreating the index." may be reported while loading a transaction log dump after onlining the database with STANDBY_ACCESS mode. The fix provides trace flag 3170 to bypass this error. Please turn on trace flag 3170 and reload the dump sequence.
Workaround Description
 N/A



CR:738777
CR Number:   738777
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 SP50 20 May 2013 Fixed
20 May 2013 Reservation Made
15.7 SP110 06 Jun 2013 Fixed
Description
ASE will now no longer cache INSERT VALUES statements that has LOB literals exceeding 16k size.
Workaround Description
 create table test (a int, b image)



declare @var image



select @var = <some value greater than 16K>



insert test values (1, @var)



CR:738785
CR Number:   738785
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 using ANSI JOINS between VIEWS on PROXY TABLES returns some rows of the result set and then raises error 207 "invalid column name".



CR:738790
CR Number:   738790
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)
15.7 SP60 29 Jul 2013 Fixed
15.7 SP121 22 Aug 2013 Fixed
29 Nov 2013 Fixed
Description
Some user queries might cause segmentation fault with signal 11 when auditing and compatibility mode options are turned on.
Workaround Description
 If we make any of the following changes the SQL ran without an issue

* disable compatibility mode

* disable auditing

* remove the "order by name" from the SQL

* remove the "exec" wrapper from the SQL



CR:738792
CR Number:   738792
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 20 May 2013 Fixed
15.7 SP101 10 May 2013 Fixed
Description
If an ODBC or JDBC client enables one or both of HADR_MAP and HADR_NOKILL capabilities, different message text for same error codes is seen in case of HADR errors.



CR:738849
CR Number:   738849
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)
24 May 2013 Not a Bug
Description
ASE cannot store UTF-8 strings of char_length(N) in a varchar(N) columns.
Workaround Description
 When create table varchar(N) do N * 4.



CR:738852
CR Number:   738852
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
A way of "set string_rtruncation on" default server wide.
Workaround Description
 use a Global login trugger with "set string_rtruncation on"



CR:738884
CR Number:   738884
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 PL3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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:738952
CR Number:   738952
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4 PL3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2013 Fixed
15.7 SP50 07 Jun 2013 Fixed
15.7 SP110 10 Jun 2013 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the modules s_compile() and s_recompile() when a stored procedure is renormalized and phdr_nondiskres is set for the proc_hdr.



CR:739014
CR Number:   739014
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)
10 May 2013 One-off Provided
15.7 SP50 26 May 2013 Fixed
15.7 SP110 29 May 2013 Fixed
Description
ASE Cluster Edition fails to boot when using EMC devices. A truss on AIX or Solaris will show repeated ioctl system calls. This issue only affects ASE Cluster Edition.



CR:739040
CR Number:   739040
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 14 Jul 2013 Fixed
Description
In rare circumstances, for APL table with both clustered index and non-clustered indexes

which are created on a shared disk cluster ASE server, INSERT task may not respond even if it is

cancelled (by CTRL C) when run with concurrent INSERT tasks. Meanwhile, lots of

1205 error messages, "Your server command (family id <value>, process id <value>) encountered

a deadlock situation. Please re-run your command", will also be seen in the error log.



CR:739067
CR Number:   739067
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 May 2013 Bundled Request
28 May 2013 Bundled Request
Description
ASE will fail to startup if I/O fencing is enabled on devices with virtual uplinks. This issue only affects ASE Cluster Edition.



CR:739074
CR Number:   739074
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.7 SP60 29 Aug 2013 Fixed
15.7 SP110 15 Aug 2013 Fixed
15.7 SP121 31 Oct 2013 Fixed
15 Aug 2013 Fixed
Description
In some scenarios, a database in single user mode could be used by a user session that is not expected to be using the database.
Workaround Description
 Disable per process dbtable cache with traceflag 12315.



CR:739077
CR Number:   739077
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 SP110 08 May 2013 Fixed
Description
sp_showoptstats does not correctly display the derived statistics message. A derived statistics tag is now added to sp_showoptstats. <statParDer>true</statParDer> will be displayed when histogram statistics are derived from underlying partition statistics.



CR:739079
CR Number:   739079
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 09 May 2013 Fixed
15.7 SP101 09 May 2013 Fixed
17 May 2013 Added to user documentation
Description
If any of the system databases is > 2GB, the Update Adaptive Server in the installer or $SYBASE/ASE-15_0/bin/updatease (%SYBASE%\ASE-15_0\bin\updatease.exe on Windows) utility will fail with "Arithmetic overflow occurred." error.
Workaround Description
 Run updatease with -k argument. This argument makes updatease to skip the space check.



CR:739080
CR Number:   739080
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
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
The show_condensed_text built-in function returns a NULL value for queries in the statement cache when the 'enable literal autoparam' configuration parameter is enabled.



CR:739129
CR Number:   739129
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 06 Jun 2013 Fixed
15.7 SP110 10 Jun 2013 Fixed
12 Jun 2013 Fixed
Description
For a share disk cluster database with tables having identity column, the Error 2601, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'", may be encountered when executing DUMP DATABASE or REORG REBUILD TABLE if nodes leave and re-join the cluster. If the cluster is killed, the old identity values may also be generated.
Workaround Description
 For the tables encountered error 2601 due to identity values, customer can fix it by

1. delete corresponding rows with class=33 for the table in sysattributes

2. dbcc cacheremove, this will remove the des from cache, and force flush identity to sysattributes.

3. delete corresponding rows with class=33 for the table in sysattributes again. This will ensure that we don't keep a out dated identity in sysattributes.

4. dump, reorg rebuild, insert will be fine. New identity set will be allocated according to sysobjects.identburnmax. We just lost some identity values.



CR:739163
CR Number:   739163
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Open
OS:   Solaris 11
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Selecting unitext data that contains 'illegal byte sequences' can cause client connections to fail with "There is a tds protocol error. An illegal token was received."
Workaround Description
 Disable 'surrogate processing':

sp_configure 'enable surrogate processing', 0



CR:739220
CR Number:   739220
Product Name:   Adaptive Server Generic Docs
Product Component:   Adaptive Server New Features Guide
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2013 Added to user documentation
Description
Job Scheduler does not run any job at a low priority by default. User need to set priorities to jobs by logical process management.



CR:739222
CR Number:   739222
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP101 10 May 2013 Fixed
15.7 SP110 10 May 2013 Fixed
16 Aug 2013 Bundled Request
Description
ASE may report a 12062 error that the operation stack has overflowed when "execution time monitoring" is on.



CR:739288
CR Number:   739288
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 15 May 2013 Fixed
15.7 SP101 10 May 2013 Fixed
15.7 SP50 13 Jun 2013 Fixed
Description
The message, "Current process infected with signal 11" followed by a stack trace that includes the module ktMuxThreadGetSchedQ() may reported during shutdown and may not lead to a complete ASE shutdown.



CR:739291
CR Number:   739291
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2014 Duplicate
Description
In rare circumstances, No any processes work on a database and its dbt_keep may be greater than 1.
Workaround Description
 Disable per process dbtable cache with traceflag 12315.



CR:739299
CR Number:   739299
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 SP110 17 May 2013 Fixed
Description
When the example stored procedure sp_extrapwdchecks from Adaptive Server documentation is created in master database to perform additional password checking and password history maintenance, a new row is incorrectly inserted into the password history table with a value of 搉ull for the column 搉ame when the password change is done by a different user with role sso_role or Granular Permission privilege manage any login.



CR:739315
CR Number:   739315
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 01 Jul 2013 Fixed
Description
A non-privileged connection to primary with HADR_MAP capability enabled gets killed after primary is deactivated without any error message.



CR:739334
CR Number:   739334
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2013 Added to user documentation
Description
System Administration Guide Volume 2 mentions about the message "Number of proc buffers allocated: xxxx" that ASE does not output anymore.



CR:739363
CR Number:   739363
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP110 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2013 Fixed
15.7 SP110 27 May 2013 Fixed
27 May 2013 Reservation Made
Description
An undetected deadlock may occur between DUMP DATABASE and other tasks trying to reserve space in syslogs.



CR:739377
CR Number:   739377
Product Name:   ASE Management
Product Component:   Web Console
Status:   Open
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SCC Feature Request: able to create custom alerts in SCC



CR:739469
CR Number:   739469
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)
09 Oct 2013 Fixed
09 May 2014 DEFER
09 May 2014 Already Fixed by Another CR
Description
When a merge statement inserts a new record into a table with an identity column, the

identity column will be populated with correct value but the global variable @@identity will

remain unchanged.
Workaround Description
 None really, but dependant on how @@identity is used in the logic, may be able to use

next_identity ("<table>")



CR:739473
CR Number:   739473
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have various severity 17 errors that are normally only sent to the client reported by the errorlog by default. This can currently be accomplished on a message by message basis with sp_altermessage, but a more universal or default setting is desired.



CR:739477
CR Number:   739477
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 SP110 14 May 2013 Fixed
15.7 SP50 14 Jun 2013 Fixed
Description
If HASH based statistics gathering is used during an UPDATE STATISTICS or a CREATE INDEX statement, then there may be a failure if the respective column contains the next to lowest value of the domain but not the lowest value of the domain. The statement may be aborted. e.g. if the column is an unsigned integer then 1 is the next to lowest value and if the column contains a 1 but not a 0, then the statement may be aborted.
Workaround Description
 avoid using the hashing option when gathering statistics.



CR:739482
CR Number:   739482
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)
10 Jun 2014 Insufficient priority to fix
Description
Include entries to the dump history file for external dumps.



CR:739486
CR Number:   739486
Product Name:   ASE Management
Product Component:   Monitoring Agent Plugin
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2013 Fixed
22 Oct 2013 Fixed
Description
Error 209 reported while displaying Devices and Engines view of ASE monitoring view when the monitored ASE is set up with case-insensitive sort order.



CR:739497
CR Number:   739497
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 SP110 14 May 2013 Fixed
Description
Inaccurate histograms can be created when the unique value count of the column exceeds 65535 unique values.



CR:739529
CR Number:   739529
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)
15.7 SP50 03 Jun 2013 Fixed
17 Jun 2013 Fixed
15.7 SP110 19 Jun 2013 Fixed
Description
ASE logs the message, "Expected object passed to utGetThid is not of type thread", repeatedly.
Workaround Description
 Shutdown and restart the ASE.



CR:739531
CR Number:   739531
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 12 Jul 2013 Fixed
20 Feb 2014 Fixed
Description
DBCC HELP(PAGE) does not display the correct usage of the parameter 'logical'.



CR:739568
CR Number:   739568
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 21 May 2013 Fixed
15.7 SP110 10 Jun 2013 Fixed
Description
The message, "Current process infected with 11", followed by a stack trace which includes the modules lwp_create() and freeprocs() may be reported in the error log when a cached statement is normalized which can lead to other ASE tasks to wait indefinitely on the statement cache pool semaphore acquisition.



CR:739572
CR Number:   739572
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 SP101 15 May 2013 Fixed
15.7 SP110 20 May 2013 Fixed
Description
On Windows 2008 R2 platform, ASE HA may fail to create Sybase Companion Server. "sp_companion configure" fails with message "HA Config Error: Unable to write cluster resource properties for ASE server '<name>' (operating system error 183)."
Workaround Description
 NO WORKAROUND. This is a problem which may occur on some systems but not others depending on the local environment, but there is no specific way of 'configuring around' the problem. However it only affects configuration of a new companion server, any pre-existing HA companion server is not affected by this bug.



CR:739578
CR Number:   739578
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 SP110 14 May 2013 Fixed
15.7 SP50 12 Jun 2013 Fixed
Description
If a column has more than 65535 unique values then UPDATE STATISTICS or CREATE INDEX with HASH based statistics gathering may result in an out of order boundary value in the first few cells of the histogram.



CR:739611
CR Number:   739611
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2013 Fixed
30 Aug 2013 Added to user documentation
Description
Add option to append results in text mode.



CR:739656
CR Number:   739656
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2013 Fixed
15.7 SP110 03 Jul 2013 Fixed
Description
Running REORG DEFRAG from the same session multiple times might eventually cause a 705 error, "There is no room for process <spid> to store PROC_HDR <address> in Pss. ASE is terminating this process". Also, every run of REORG DEFRAG throws a noisy warning, "WARNING: memory usage in procedure headers (n) does not match memory usage count in Pss (m) for server process id <spid>"



CR:739664
CR Number:   739664
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3 IT
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 20 May 2013 Fixed
15.7 SP110 21 May 2013 Fixed
15.7 SP101 22 May 2013 Fixed
03 Jun 2013 One-off Provided
Description
Queries with OUTER JOIN and a reference to syscomments.text can get wrong results when "select on syscomments.text" is set to 0.



CR:739678
CR Number:   739678
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 20 May 2013 Fixed
15.7 SP110 22 May 2013 Fixed
Description
Generating DDL for a table using DDLGen does not generate DDL for indexes which have been created with sorted_data option.



CR:739679
CR Number:   739679
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 SP110 28 Jun 2013 Fixed
02 Aug 2013 Presently Not Targeted For Any Future Release Of This Product
26 Jun 2013 Reservation Made
Description
Enable usage of subqueries in the SELECT with FOR UPDATE clause under global switch 7791.



CR:739710
CR Number:   739710
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
To Be Determined 24 Jun 2013 Fixed
Description
ASE running in process kernel mode (pre 15.7 or 15.7 and above process kernel mode) may encounter issues like Error 14130 when an engine is onlined after some licensed feature is enabled.
Workaround Description
 It should be possible to disable and re-enable the licensed feature in order to get all currently on-lined engines synched up to the correct state. E.g.



sp_configure 'enable semantic partitioning', 0

sp_configure 'enable semantic partitioning', 1



CR:739725
CR Number:   739725
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 30 May 2013 Fixed
Description
sp_configure 'dump history filename' may return an incorrect filename on a Windows environment when a dump history filename has '\' characters specified and after an ASE restart. For example, dump history file 'D:\sybase\dumphist' would be returned as 'D:sybasedumphist' mistakenly.



CR:739735
CR Number:   739735
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 26 May 2013 Fixed
15.7 SP110 26 May 2013 Fixed
Description
Hard fault 100007 (extent id error) may be reported by sp_dbcc_faultreport if DBCC CHECKSTORAGE is run with frequent DDL commands.



CR:739736
CR Number:   739736
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 19 May 2013 Fixed
15.7 SP110 26 Jun 2013 Fixed
Description
A 12319 error, "Fatal internal error encountered during deferred dml on table <tabname> in database <dbname>. All rows that qualified during the first phase were not visited during second phase of dml" may be reported followed by a stack trace that includes the modules dol_def_update() and dodeferred() when running CREATE INDEX or REORG REBUILD with ONLINE option with concurrent DMLs on hot objects.



CR:739773
CR Number:   739773
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The LOAD DATABASE WITH LISTONLY=LOAD_SQL may generate some load commands which, if executed, may require manually altering the target database for the load to succeed, in cases where an ALTER DATABASE OFF command was run at some time when the sequence of dumps was created on the source database



CR:739784
CR Number:   739784
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 SP60 31 Jul 2013 Fixed
15.7 SP110 01 Aug 2013 Fixed
Description
If a table is altered and is present in an UNION query in a derived table which is further defined in a VIEW, it could lead to permission denied errors.



CR:739820
CR Number:   739820
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 SP110 24 May 2013 Fixed
21 May 2013 Reservation Made
Description
Inaccurate overly optimistic cluster ratios could result when executing a parallel create index. This could lead to inaccurate index selection in the query plan. After the first UPDATE STATISTICS command on this new index, the cluster ratios will be corrected and plan selection should be more accurate. Optcriteria CR739820 enables the change to improve the accuracy of the cluster ratios during parallel create index
Workaround Description
 use update statistics to correct the inaccurate cluster ratios



CR:739930
CR Number:   739930
Product Name:   Adaptive Server Enterprise
Product Component:   preupgrade
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have the preupgrade utility check for incorrect status bits in the TIPSA structure of text and image values.



CR:739932
CR Number:   739932
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 SP110 20 May 2013 Fixed
15.7 SP60 10 Jul 2013 Fixed
Description
The optimizer estimates involving columns defined as BIGDATETIME and BIGTIME types may be suboptimial.



CR:740006
CR Number:   740006
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Trailing comments are stripped at the DBISQL application level and not sent to ASE. This is not the case with isql.



CR:740018
CR Number:   740018
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)
15.7 SP110 29 May 2013 Fixed
Description
An incorrect negative value may be reported in the error message, "A system call has not responded for x seconds".



CR:740020
CR Number:   740020
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 02 Jul 2013 Fixed
15.7 SP110 03 Jul 2013 Fixed
09 Sep 2013 Fixed
Description
Under rare circumstances on Windows NT 64-bit platform ASE may stop with no errors being reported while processing Web Services requests that involve the execution of Java code.
Workaround Description
 For windows only, you need to set the environment variable SYBASE_PCI_DISABLE_DISPATCH_MEMORY=Y before starting ASE.



Notice that the message below will be displayed to the console. For disabled PCI memory interception this mesage can be ignored i.e. there is no security risk there.



************SECURITY WARNING**************

function dispatching disabled for debug purposes

security of libraries running under PCI (for example external JVM) cannot be guaranteed

******************************************



CR:740031
CR Number:   740031
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 SP110 21 May 2013 Fixed
15.7 SP50 12 Jun 2013 Fixed
Description
If a high domain column (greater than 65535 unique values) has a histogram created by using the HASH based algorithm, then it is possible that an inconsistent histogram could be created if there are some skew values in the histogram.
Workaround Description
 gather statistics using the sort based statistics gathering algorithm.



CR:740045
CR Number:   740045
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
When failover occurs, a message "Database 'database name' appears to be in the process of being loaded; ASE will not bring it online automatically. Use the ONLINE DATABASE command to bring this database online." appears and the database becomes offline.
Workaround Description
 Bring the database online manually.



CR:740079
CR Number:   740079
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2014 Fixed
16 Apr 2014 Reservation Made
09 May 2014 Fixed
Description
Log the full sql text of the string passed to execute immediate in the monSysSQLText table. This is only available when traceflag 8391 is enabled.



CR:740115
CR Number:   740115
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP101 24 May 2013 Fixed
15.7 SP110 26 May 2013 Fixed
Description
"sp_hadr_admin status, 'anyvalue'" fails when executed on standby HADR server when quoted_identifier is on.



CR:740137
CR Number:   740137
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 SP110 21 May 2013 Fixed
28 Mar 2014 Fixed
Description
The message, "Current process infected with signal 11" (SIGSEGV), followed by a stack trace that includes the module stu_get_next_active_hist_slot() may be reported in the SAP ASE error log when using HASH based statistics gathering and the column has more than 65535 unique values.
Workaround Description
 If this problem occurs then use sort based statistics gathering for this column



CR:740148
CR Number:   740148
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)
12 Jul 2013 Fixed
12 Aug 2013 DEFER
Description
If an object name (such as a table) contained a parenthesis (as could be possible when using quoted identifiers), any SQL text for a statement using that object name would not be stored in the statement cache.



CR:740195
CR Number:   740195
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2013 Work as design
Description
The error Backup Server: 5.3.2.1: Cannot open a connection to the slave site will be raised when trying to execute a DUMP command using a remote backup server, if either the remote backup server has been booted with a different name as the one used in the dump command, or if the name used in the local server is different and this name is not in the remote backup server interfaces file.
Workaround Description
 1) Add the remote_server name used in the AT <remote_server> to the remote backup server interfaces file OR/AND

2) Boot the remote backup server with the same 'remote_server' name used in the local server.



CR:740213
CR Number:   740213
Product Name:   ASE Management
Product Component:   sybrestore
Status:   Closed
OS:   Generic
Original Version:   3.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2013 Fixed
Description
Sybrestore requires login of system administrator with its default database in master database in order to successfully load the database. In other words, sybrestore will fail to load a database if the default database of the login is not master database.



CR:740221
CR Number:   740221
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 02 Sep 2013 Fixed
20 Aug 2013 One-off Provided
15.7 SP121 05 Sep 2013 Fixed
15.7 SP110 05 Sep 2013 Fixed
07 Nov 2013 One-off Provided
Description
Under heavy network load, SAP ASE on the Windows platform may hang.



CR:740223
CR Number:   740223
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 29 May 2013 Fixed
15.7 SP110 03 Jun 2013 Fixed
Description
Job Scheduler can fail to execute jobs for users with high SUIDs.



CR:740247
CR Number:   740247
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 12 Jun 2013 Fixed
15.7 SP102 17 Jun 2013 Fixed
Description
Under some rare circumstances, a shrink-database operation can encounter errors that kill the processing thread but do not clean up the memory it was using.



CR:740262
CR Number:   740262
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2013 Fixed
06 Sep 2013 Fixed
06 Sep 2013 Reservation Made
Description
Full text not being audited for DML when option update/select/insert/delete is turned on. Parameter values are also not printed for local variables and dynamic prepare statements.



CR:740317
CR Number:   740317
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)
27 Nov 2013 Fixed
15.7 SP121 20 Oct 2013 Fixed
20 Oct 2013 Reservation Made
15.7 SP121 31 Oct 2013 Fixed
04 May 2014 Reservation Made
04 May 2014 Fixed
Description
UPDATE skip uncommitted insert row caused ABAP like below output unexpected error message.

(pseudo code)



UPDATE row

if (no rows found)

INSERT row

if (duplicate key)

UPDATE row

if (no rows found)

ERROR out (assumption this should not be possible)

The new feature is enabled when the new configure option "donot skip uncommitted insert" is set as 1.



CR:740321
CR Number:   740321
Product Name:   Adaptive Server Enterprise
Product Component:   ODATA Provider
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 18 Sep 2013 Fixed
19 Jan 2014 Port Not Needed
Description
ODATA provider uses JDBC connection string from a configuration file. End users may add their Jconnect parameters and values to this connection string. The connection string is manipulated by the odata producer to add certain required parameters for its correct operation before adding user supplied parameters to it.



CR:740322
CR Number:   740322
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2013 Duplicate
24 Sep 2013 Duplicate
Description
Multiple spurious errors are reported for load with verifyonly = full. The dump is valid and does not contain any errors.



CR:740341
CR Number:   740341
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
dbcc upgrade_object a procedure got Msg 208 when there is a temp table outside of the SP.



CR:740364
CR Number:   740364
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2013 One-off Provided
15.7 SP110 07 Jun 2013 Fixed
15.7 SP50 13 Jun 2013 Fixed
Description
Sometimes a read for non-syslogs object on a stale syslogs page for a user tempdb may results in 692 error.



CR:740410
CR Number:   740410
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)
29 May 2013 Fixed
15.7 SP110 29 May 2013 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module aud_getsdes() may be reported in the error log when opening cursors declared without user tables when auditing is turned on.



CR:740471
CR Number:   740471
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 SP110 28 May 2013 Fixed
15.7 SP60 07 Jul 2013 Fixed
Description
The loginfo() built-in may return wrong values for parameters 'can_free_using_dump_tran',

'oldest_active_transaction_pct', 'stp_span_pct' for databases having mixed log and data segments.



CR:740479
CR Number:   740479
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)
15.7 SP110 28 May 2013 Fixed
Description
A 9633 error, "RepAgent(<dbid>): Cannot authenticate Replication Server <RS_nname> to use multiple replication paths", may be reported when the RepAgent is configured for Multiple Paths Replication i.e. 'max number replication paths' is greater than 1 and 'multithread rep agent' is reset to false, preventing RepAgent from starting. This can be corrected by setting 'max number replication paths' to zero.
Workaround Description
 When MPR is not used anymore by resetting 'multithread rep agent' to false,

'max number replication paths' needs to be reset to 0.



CR:740499
CR Number:   740499
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 17 Jun 2013 Fixed
Description
When HADR feature is enabled in ASE, internally spawned user spid would get killed during deactivation of the Primary server. Also these spids will not be able to start a transaction on a Standby server.



CR:740512
CR Number:   740512
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 10 Jun 2013 Fixed
Description
DELETEs or UPDATEs doing a table scan on a DOL table following an INSERT-BULK performed

in a multi-statement transaction may sometimes not qualify all rows, and the DELETE / UPDATE

may leave some qualifying rows unaffected. This is most likely to occur when the affected table is

bound to a very small cache, usually of the minimum size.
Workaround Description
 Increase the cache size that the target table of the insert-bulk is bound to. Deletes / updates

using an index access are unaffected, so avoiding the table scan for the DML by providing some

search arguments on index key columns, or by forcing an index scan, will also avoid this problem.



CR:740529
CR Number:   740529
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 17 Jul 2013 Fixed
Description
The format for the Object_status column output of "sp_help <tablename>" may have a missing comma.



CR:740567
CR Number:   740567
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Configuration Guides - All Platforms
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2013 Added to user documentation
Description
Documentation enhancment request to document that as of 15.0.2 there is no longer a hard limit on the number of items in an IN clause. The limit is now limited by available procedure cache.



CR:740568
CR Number:   740568
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   UNIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 18 Jun 2013 Fixed
15.7 SP110 28 Jun 2013 Fixed
28 Jun 2013 One-off Provided
Description
When MERGE JOIN is turned off, a SELECT query joining a local and proxy column with a search using an IN list will not return the correct result. Currently, traceflag 16976 provides the workaround to the problem.
Workaround Description
 traceflag 16976

or

set merge_join on



CR:740576
CR Number:   740576
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 SP110 30 May 2013 Fixed
15.7 SP102 16 Jun 2013 Fixed
Description
Under some rare circumstances, a shrink-database operation can encounter errors of index not consistent on DOL table.



CR:740597
CR Number:   740597
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)
15.7 SP110 31 May 2013 Fixed
15.7 SP102 14 Jun 2013 Fixed
Description
When RepAgent terminates abnormally with an error while connecting to Replication Server, the connection is not closed and the associated session is still held on Replication Server mistakenly.



CR:740609
CR Number:   740609
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 29 May 2013 Fixed
15.7 SP101 05 Jun 2013 Fixed
Description
In an HADR environment, the privileged connection (to the old primary) with info capabilities gets killed upon activation of the new primary server.
Workaround Description
 Disable the info capabilities (DR_MAP and DR_NOKILL) for the connection. But note that with this the client will not receive the info messages.



CR:740613
CR Number:   740613
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)
15.7 SP50 30 May 2013 Fixed
16.0 06 Jun 2013 Fixed
15.7 SP101 04 Jun 2013 Fixed
18 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
23 Sep 2013 One-off Provided
Description
LOAD TRANSACTION of a transaction dump involving the log records of materialization of an indexed table with 'deferred allocation' property may fail with the 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #=x, object id = y, page timestamp=z. Log old timestamp=a. Log record marker =(p, q)."



CR:740635
CR Number:   740635
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)
26 Mar 2014 Fixed
07 May 2014 Fixed
07 May 2014 Fixed
Description
In rare circumstances, when running TRUNCATE TABLE on a very large table, the table does not show up on monProcessObject.



CR:740711
CR Number:   740711
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 SP101 06 Jun 2013 Fixed
15.7 SP110 06 Jun 2013 Fixed
Description
A 9284 error, "RepAgent(<dbid>). Cannot allocate 9024 bytes of memory. You may need to reconfigure the parameter 'replication agent memory size' with more memory." may be reported when LOB off-row data is replicated, resulting in the Rep Agent Thread for this database to be terminated abnormally.
Workaround Description
 Increase via sp_configure the option 'replication agent memory size'.



CR:740722
CR Number:   740722
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2013 Bundled Request
Description
When encountered a charset-mis-match error while connecting to an ASE (e.g. an HP ASE server), DBISQL 16 internally switches to use utf8 to re-connect. Previously iso_1 was used.



CR:740730
CR Number:   740730
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 19 Jun 2013 Fixed
15.7 SP110 20 Jun 2013 Fixed
25 Jun 2013 One-off Provided
13 May 2014 One-off Provided
Description
The 1514 error, "Sort failed because it attempted to allocate page <page> and found that the page was busy. Buffer <buffer> contains a cached and referenced page with ptnid <ptnid> indid <indid> and status <status>", may be reported when executing a subquery plan and there is a StoreIndex(reformatting) operator under the subquery.



CR:740732
CR Number:   740732
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 07 Jun 2013 Fixed
15.7 SP102 14 Jun 2013 Fixed
Description
If a database is configured to 'allow incremental dumps' updates to pages that happen when bringing the database online could be missing from the next incremental dump.
Workaround Description
 N/A



CR:740741
CR Number:   740741
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 SP110 04 Jun 2013 Fixed
Description
Using DDLGen to extract CREATE DATABASE DDL fails when the database name is greater than 23 characters and the "-F" option is used.
Workaround Description
 Change @procname varchar(45) to varchar(60) in below system stored procedures workaround the issue.



create procedure dbo.sp_ddlgen_permissions(

@objtype varchar(30)

, @objname varchar(30)

) as

begin -- {

declare @is_dbo int

, @procname varchar(45)

, @lcl_sarole int





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