远程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:545968
CR Number:   545968
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2008 Fixed
Description
Executing an outer join query with false predicate (e.g. "1 = 2") in the ON clause may hit error 1142

if reformatting strategy is chosen.



CR:546047
CR Number:   546047
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2008 Fixed
14 Oct 2008 Fixed
Description
Executing a query involving IN clause, some builtin and OR predicate may hit SEGV and

stack trace in the module of 'LeEvals::LeEvRun()' and 'LeOrScanContext::setOrVtuple'

if the query plan chosen has OrScan in it.
Workaround Description
 Declare @UserName as VARCHAR of some length less than 256,

e.g., declare @UserName VARCHAR(255)



CR:546057
CR Number:   546057
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2008 Fixed
Description
After bringing an engine back online that has been previously taken offline incorrect messages may appear in the errorlog related to the clock on that engine not running.



CR:546075
CR Number:   546075
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2008 Fixed
21 Oct 2008 Fixed
29 Oct 2008 Fixed
30 Oct 2008 Fixed
31 Oct 2008 Reservation Made
14 Jan 2009 One-off Provided
Description
The message "process infected with signal 11" in the module 'des_rekeep'

may be reported in the error log together with a stack trace which includes

the modules 'vu_getviewdefn', 's_reinstallProcTree' and 'proc__linktopss'

when two concurrent sessions access a VIEW whose query tree needs to be

redefined by ASE.
Workaround Description
 update 6/11/09 ningzhen:

Customers may use tool "dbcc upgrade_object --with 'force'" to rebuild query trees in sysprocedures to reduce the chance of run time upgrade. e.g. in pubs2



1> dbcc upgrade_object <-- rebuild query trees for all compiled objects

2> go

DBCC upgrade_object: Upgrading VIEW dbo.sysquerymetrics

DBCC upgrade_object: VIEW dbo.sysquerymetrics upgraded successfully.

DBCC upgrade_object: Upgrading PROCEDURE dbo.title_proc

....



dbcc upgrade_object(pubs2,titleview) <-- rebuild query tree for view titleview



CR:546085
CR Number:   546085
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2008 Fixed
10 Oct 2008 Fixed
Description
In cases where basic_optimization is used, and the histogram on a column has been explicitly deleted by the delete statistics command, there is a possibility of a stack trace if multi-attribute densities exist with that leading column. This could happen if a multi-attribute index exists, and the histogram on the leading column of that index is explicitly deleted.



CR:546125
CR Number:   546125
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2008 Fixed
10 Nov 2008 Reservation Made
Description
A cursor on an APL table in 12.5 prefers a unique index rule based over

any non-unique index or table scan. In 15.0 the unique index is only used rule based

if a FOR UPDATE clause was specified. The 12.5 unique index rules are

now supported for 15.0
Workaround Description
 1)create cursor as insensitive

"declare cur_proc insensitive cursor for"



2) use a AP to force index.

"PLAN '( i_scan indexname tablename )'"



CR:546127
CR Number:   546127
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2008 Fixed
29 Jan 2009 Bundled Request
Description
<permission_name> is allowed to be entered as first argument to sp_helprotect where as the syntax of sp_helprotect is:

sp_helprotect [name [, username [, "grant"

[,"none"|"granted"|"enabled"|role_name [,permission_name]]]]]



CR:546149
CR Number:   546149
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare cicumstances, in multinode cluster error 8211 may reported while creating/accessing the table.



CR:546158
CR Number:   546158
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2008 Duplicate
Description
BackupServer crashes on glibc 2.6 (Suse 10.3 and 11)
Workaround Description
 Setting LD_POINTER_GUARD to 0 can be a workaround for this issue. But, this

workaround is not effective everywhere, on some platforms with glibc 2.6

setjmp/longjmp still fail.



CR:546169
CR Number:   546169
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: Tool for estimating the amount of time it will take to create an index.



CR:546179
CR Number:   546179
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2008 Fixed
Description
Wrong result might happen for outerjoin query with a MATCHNULL equijoin WHERE clause.
Workaround Description
 cmdline traceflag 15387 could be used to disable MATCHNULL tcid enhancement

to avoid the bug.



CR:546204
CR Number:   546204
Product Name:   Adaptive Server Generic Docs
Product Component:   EFTS SDS and SFTS SDS
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2009 Added to user documentation
Description
max_stacksize parameter increased in EFTS 15.0.2 from 34816to value 131072. Stacksize has been increased due new Verity libs



CR:546205
CR Number:   546205
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Implementation of an option in Update Index Statistics command which will allow to

decide to do one Index Scan for each non leading column (like is today) or do only one Index scan for reading all non-leading columns.



CR:546255
CR Number:   546255
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2009 Added to user documentation
Description
DOC : There is a limitation that ASE does not parameterize literals in a derived table.



CR:546291
CR Number:   546291
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: enable housekeeper GC to be configurable per database.



CR:546301
CR Number:   546301
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request: Each entry in sysaudits that has multiple rows (sequence#) should have the identical timestamp for each sequence entry of that command.



CR:546319
CR Number:   546319
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2009 Not a Bug
Description
adhoc vs. sproc. adhoc picks best plan in sub seconds, while the same sproc picks wrong index, and 138 seconds.
Workaround Description
 create index Testidx on PAT_PLAN(PLAN_CODE, PAYOR_CODE, PAT_ID)



CR:546352
CR Number:   546352
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2008 Fixed
Description
There was an attempt to de-reference a NULL pointer, while checking for the physical lock when

latching a buffer that is destroyed.



CR:546359
CR Number:   546359
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2008 Fixed
Description
INTERNAL ONLY : queries with LIKE clauses using variables under OR predicate may

provide incorrect results.



CR:546364
CR Number:   546364
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2008 Fixed
Description
Under rare circumstances and after failover recovery has taken place, ASE may raise a fatal

890 error reading "The mass containing the buffer 'BUF=<Buffer Address>, MASS=<MASS Address>, Buf#=<Buf count>, page=<Page Address>, dbid=<DBID>, Mass vdevno=<VDEVNO>, vpage=<Virtual Page #>,

Buf lpage=<Logical Page #>,Mass stat=<Mass Status>, Buf stat=<Buffer status>, size=<Page size>, cid=<Cache id> ('<Cache Name>'), Pinned xdes=<XDES Adress>, spid=<Spid #>' should not be written

in its current state."



CR:546400
CR Number:   546400
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   RH Linux
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Dec 2008 Bundled Request
Description
select @@dbts returns incorrect value on ibmplinux.



CR:546419
CR Number:   546419
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2008 Fixed
Description
On ASE running on the Windows platform, attempted java network connection may fail with "java.io.IOException: Unable to establish loopback connection"



CR:546422
CR Number:   546422
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2008 Fixed
Description
Add an option [overwrite|append] in readtext command to specify whether to overwrite or append existed files.



CR:546434
CR Number:   546434
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2008 Fixed
18 Dec 2008 Presently Not Targeted For Any Future Release Of This Product
27 Oct 2008 Fixed
Description
Re-write of the query tree under traceflag 299 causes exclusive locks on sysprocedures. This happens when there is an UPDATE STATISTICS command in the procedure on the newly created temporary table.



CR:546500
CR Number:   546500
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances sp_who does not show the correct user working DB when the user has default DB.



CR:546525
CR Number:   546525
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Release Bulletin for Solaris
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2013 Fixed
Description
In the Release Bulletin Adaptive Server Enterprise 12.5.4 for Sun

Solaris, it lists all the Sun Solaris Patches required on Solaris 8. However,The Patch 110648-13 and 109210-12 are required only when the customer is using Sun Cluster and ASE HA option. This is not clearly stated in our release bulletion. we need to revise this and give more precise statement regarding this, which recommend customer to examine the patches carefully and decide whether to apply such patches or not.



CR:546556
CR Number:   546556
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to disable foreign key constraints without dropping them.
Workaround Description
 N/A



CR:546574
CR Number:   546574
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2008 Fixed
Description
Help infomation for dbcc housekeeper is changed from:

housekeeper 'pr_gcq' | 'pr_tsq' | 'pr_tsq', [<engid>]\n [...]

to

housekeeper ( 'pr_gcq' | 'pr_tsq' | 'pr_asq', [<engid>] ) \n [...]

so that correct the duplicate flag for pr_tsq, and will allow users to print account stats queue correctly.



CR:546598
CR Number:   546598
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2009 Added to user documentation
Description
Customer requested that we clarify that tempdb is not newly created each time ASE is rebooted in the following section of the System Administration Guide.



http://infocenter.sybase.com/help/topic/com.sybase.help.ase_15.0.sag1/html/sag1/sag1392.htm



change:

To make an option or options take effect for every new database, change the option in the model database.



to:

To make an option or options take effect for every new user defined database, change the option in the model database.



Note: changes to the dboptions of model do not affect tempdb or user defined multiple tempdbs upon restart of ASE. Only newly created user defined databases and multiple tempdbs will reflect the dboptions of model, with the "create database" command. A restart of ASE clears the objects and data contained in the temporary databases, but does not reset the dboptions.



CR:546651
CR Number:   546651
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2008 Fixed
22 Oct 2008 Fixed
30 Mar 2009 One-off Provided
Description
SET PROXY executed in the procedure using deferred compilation will not have its scope limited only

to the current procedure execution but for the whole session.
Workaround Description
 Start server with "-T 7730" to disable deferred compilation.



CR:546667
CR Number:   546667
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2008 Fixed
Description
In a multi-node cluster, if config parameter "license information" is set to non-zero value,

shutdown of cluster/instance may result in SIG 11 reported in errorlog. Stacktraces could

contain the words "log_license_info", "open__byname".



CR:546695
CR Number:   546695
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE 15.0 uses more IO to run the same query vs ASE 12.5



CR:546707
CR Number:   546707
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2009 Fixed
Description
Cannot run optdiag when ASE parameter "net password encryption reqd" is enabled



CR:546712
CR Number:   546712
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2008 Bundled Request
Description
If sp_setreplicate is run to turn off replication on a table previously configured to use SQL statement replication, this information is not removed from the system table sysattributues.



CR:546730
CR Number:   546730
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2008 Fixed
Description
Error 124 raised when 'set statement_cache on' or 'set literal_autoparam on' is the only

statement in a stored procedure.



CR:546737
CR Number:   546737
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2008 Fixed
08 Dec 2008 Reservation Made
10 Dec 2008 Fixed
Description
If sort nodes break up a chain of nested loop join operators, in which some of the respective index/table scans involve an MRU strategy, and there does not appear to be a reason for the sort node, then it may be caused a buffer manager optimization that did not take into account the MRU strategy when estimating buffer cache used by the respective operators. This change will tend to reduce the usage of sort nodes to break up a chain of nested loop operators
Workaround Description
 abstract plans



CR:546770
CR Number:   546770
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Closed
OS:   HP-UX
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2008 Fixed
Description
UAF may take a long time to discover and validate hosts.



CR:546839
CR Number:   546839
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2008 Not a Bug
Description
On specific platforms, certain versions of ASE do not appear to register I/O busy in reports from sp_sysmon as expected.
Workaround Description
 A work around would be to use mda tables to monitor performance, including monDeviceIO, monEngine, monIOQueue



CR:546868
CR Number:   546868
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for the ability to audit the values of parameters passed to prepared statements.



CR:546883
CR Number:   546883
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2009 Fixed
18 Feb 2009 Fixed
Description
On HP platform, disabling network IO for Java still allows some network related Java calls to be

executed. This is only seen with the dataserver binary, not the diagserver binary.
Workaround Description
 If network related operations are not permitted, one should not allow java classes to

be loaded in the database which use network related functionality.



CR:546891
CR Number:   546891
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 28 Jun 2013 Fixed
15.7 SP60 30 Jul 2013 Fixed
Description
Permissions on "sysslices" system table remain unchanged when "GRANT DEFAULT PERMISSIONS ON SYSTEM TABLES" or "REVOKE DEFAULT PERMISSIONS ON SYSTEM TABLES" SQL commands are executed.



CR:546900
CR Number:   546900
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T: Basics
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2009 Added to user documentation
Description
The discussion of transaction isolation level 0 (dirty reads) should document that dirty reads can only be done in purely read-only statements. Dirty reads cannot be done for the select part of an INSERT SELECT or a SELECT INTO statement.



CR:546902
CR Number:   546902
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2008 Fixed
Description
After an HAFailover enabled client session has been migrated, then killed, a failover connect attempt fails with "HA Login failed. Session Handle not found.



CR:546941
CR Number:   546941
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2009 Fixed
Description
In the cluster environment, the server may hang if the "abort_js" command is issued.



CR:546946
CR Number:   546946
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2008 Fixed
Description
request the plugin of Sybase Central for ASE CE to take in the "time" value like the command "sp_cluster 'logical', 'offline', <lcname>, 'cluster'[, <wait_option>[,<time>[, @handle output]]]"



CR:546948
CR Number:   546948
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2008 Presently Not Targeted For Any Future Release Of This Product
Description
feature request: Allow sysattributes to be bound to a named cache.



CR:546960
CR Number:   546960
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2009 Fixed
Description
During failover recovery, thmgr scan might count incorrect value for allocated log pages in the database.



CR:546961
CR Number:   546961
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2008 Fixed
18 Jan 2009 Fixed
12 Nov 2008 Fixed
12 Nov 2008 Fixed
12 Nov 2008 Fixed
16 Feb 2009 Fixed
Description
Enable RTDS to support ASE SDC



CR:547010
CR Number:   547010
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2011 Duplicate
Description
It would be useful to have an MDA table to report on use of stored procedures, including execution count, last execution time etc
Workaround Description
 N/A



CR:547023
CR Number:   547023
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UNIX
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
DBCC CHECKSTORAGE reports faults 100009, 100029, and 100030 on the sysanchors table.



CR:547114
CR Number:   547114
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2010 Fixed
Description
Currently if more than one cluster is configured on a machine,

the port ranges will need to be manually edited

in the Sybcluster XML file.

So, enhance the function of creating cluster to allow user enter starting port.



CR:547118
CR Number:   547118
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2009 Fixed
20 May 2009 Reservation Made
25 May 2009 Fixed
07 Feb 2011 Added to user documentation
04 Sep 2009 Insufficient priority to fix
30 Aug 2009 Fixed
Description
A new builtin function is_singleusermode is created to determine if server is in single-user mode.

sp_downgrade will force the server to be in single-user mode before downgrade is performed.



CR:547182
CR Number:   547182
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2008 Fixed
Description
If there is instance-specific configuration in blocks before the 'default data cache' group, error 5890 will be raised. This is caused by the config file format not recognized

by file reader interfaces.



CR:547288
CR Number:   547288
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2008 Duplicate
Description
Under rare circumstances, the message "current process infected with 11" in the module

'cm_cid_from_name' while creating named cache.



CR:547300
CR Number:   547300
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow identity() on derived tables.



CR:547350
CR Number:   547350
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2008 Fixed
Description
Explicit conversion from 1.0 to unichar(1) returns wrong result and no error raised.



CR:547361
CR Number:   547361
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2009 Fixed
25 Jul 2010 Fixed
Description
Whenever SybMigrate experiences any problems making a connection

to either the source or destination ASE it always prints the same error:



ERROR|The URL 'bruno-xp:5000' has an incorrect format. The correct format is: <hostname>:<port number>.



This is very misleading.



CR:547375
CR Number:   547375
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2009 Fixed
19 Jan 2009 Reservation Made
23 Feb 2009 Fixed
Description
This feature provides the ability for a user to set the sql statement replication threshold at the ASE session level using the syntax:



set repthreshold <value>.
Workaround Description
 N/A.



CR:547432
CR Number:   547432
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enable deadloack detection between ASE structures



CR:547476
CR Number:   547476
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2008 Fixed
Description
hostid() retuns unexpected trash data



CR:547492
CR Number:   547492
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2009 Fixed
21 Jan 2009 Fixed
29 Jan 2009 Fixed
20 Jan 2009 Fixed
15 Jan 2009 Fixed
02 Feb 2009 Fixed
14 Jan 2009 Fixed
30 Jan 2009 Fixed
21 Jan 2009 Fixed
13 Jan 2009 Fixed
20 Jan 2009 Fixed
05 Feb 2009 Fixed
29 Jan 2009 Fixed
20 Jan 2009 Fixed
27 Jan 2009 Fixed
09 Feb 2009 Fixed
Description
Internal only: replace code references to datatypes SYB_LONG and SYB_ULONG with other, more appropriate types.



CR:547572
CR Number:   547572
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2008 Fixed
Description
The SQL text wasn't being printed for query's that went through

terminate_process(). This is a very useful diagnostic. The

query text printing has been reinstated.



CR:547622
CR Number:   547622
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2008 Fixed
22 Oct 2008 Fixed
15 Jun 2009 One-off Provided
30 Jun 2009 One-off Provided
07 Jul 2009 One-off Provided
Description
Adhoc batch may be silently aborted if it creates a temporary table

and a clustered index on this table.
Workaround Description
 use tempdb..tmp1 instead of #tmp1 like following :-



1> create table tempdb..tmp1(a int)

2> create clustered index idx1 on tempdb..tmp1(a)

3> select * from tempdb..tmp1

4> go

a

-----------



(0 rows affected)



CR:547699
CR Number:   547699
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the default unchained mode, a trigger that contains an unmatched commit causes a batch of similar statements then effect that trigger to complete without all statements executing.
Workaround Description
 Use set chained off before executing the batch of commands. Remember to set this back again after the batch is complete.



CR:547700
CR Number:   547700
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2008 Fixed
26 Nov 2008 Bundled Request
17 Feb 2009 Fixed
Description
under certain circumstances, ASE 15.0.3 on AIX encounter a hang with following messages in the errorlog.



kernel PCI(M1): ERROR: JNI_CreateJavaVM; failed retrieving the JVMTI handle in GetEnv() with -4

kernel PCI(M1): ERROR: JNI_CreateJavaVM; PCA/VM FAILED; not enough memory

kernel PCI(M1): ERROR: jsigcache_destroy; Signature cache destroy request without a JavaVM handle to destroy

kernel PCI(M1): -> PCA/JVM Signature cache is detached

kernel PCI(M1): Failed to destroy the VM signature cache.
Workaround Description
 No known workaround to prevent the problem.

Restart ASE if the server hangs due to this bug.



CR:547741
CR Number:   547741
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2008 Fixed
12 Nov 2008 Fixed
11 Nov 2008 One-off Provided
06 Feb 2009 Presently Not Targeted For Any Future Release Of This Product
30 Mar 2009 One-off Provided
Description
Under some circumstances a stored procedure execution which aborts

with certain errors (like, for example, a 226 error "... command

not allowed within multi-statement transaction.") could unexpectedly

close the tables used by the session who previously executed the same

stored procedure.
Workaround Description
 Difficult to say, but in this specific 804 case try detect why 226 error is raised

and try eliminate this from happening.



CR:547749
CR Number:   547749
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2009 Fixed
Description
The 857 error was changed to include user defined temporary databases, but the wording of the error message is confusing customers who are not trying to bind a user defined tempdb.



CR:547752
CR Number:   547752
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)
06 Nov 2008 Fixed
30 Mar 2009 Fixed
Description
On Solaris platform, an ASE task may be terminated with a timeslice error while issuing an asynchronous i/o. This is caused by a hang in the operating system, and can lead to recovery errors

in Adaptive Server. Adaptive Server has been modified to avoid terminating the task, and will print

an informational message instead. Recovery errors will be avoided, but ASE engine will hang until the operating system responds.



CR:547756
CR Number:   547756
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
document error 857 in the Troubleshooting Guide



CR:547757
CR Number:   547757
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2010 Fixed
Description
Error 559 and 3702 could be raised when executing a stored procedure if set fmtonly is on.



CR:547774
CR Number:   547774
Product Name:   Sybase ETL
Product Component:   GUI
Status:   Closed
OS:   all
Original Version:   4.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 Added to user documentation
Description
Problem:

When installing on a machine that has ETL installed or if previously installed and uninstalled, the initial automatic login to the repository fails.



Workaround:

User can successfully log on by manually providing the password (transformer).



CR:547824
CR Number:   547824
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2008 Fixed
04 Feb 2009 Fixed
02 Mar 2009 Fixed
Description
The message "process infected with signal 11" in the module 'bufdlink'

may be reported in the error log together with a stack trace which includes

the modules 'pg_allocate' and 'bufdirty' when a stored procedure is executed

requiring a work table creation and cache binding for user temporary databases

was changed between executions. This will result in ASE shutting down itself.
Workaround Description
 Avoid cache binding changes for user tempdb's on a live ASE system.

All other in-directly cache binding change might also cause problem

(e.g., sp_tempdb). See CR 554653 for more detail.



CR:547839
CR Number:   547839
Product Name:   Adaptive Server Enterprise
Product Component:   Pluggable_JVM
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2009 Fixed
01 Apr 2009 Fixed
23 Mar 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The ASE/PCI dispatching system on Windows randomly reports various synchronisation failures, which may include:

PCI(T0): ERROR: pci_wakeup; Unable to wakeup slot: 00, sema: 25DCAA74->(0), value: 0

and usually ends with:

PCI(T0): ASE_PCI: PCI Launcher Boss thread died. This is a FATAL ERROR (errno = -1)

and then usually a stack trace. After this, no java operations work although other ASE operations may continue normally.



CR:547890
CR Number:   547890
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
-T364 is available for compatibility mode to use range density instead of total density to estimate join clause selectivity. Previous CR number is 214984. Compatibility mode has its limitation and cannot apply to queries using new features.

Request enhancement of -T364 to let 15.x native optimizer support this trace flag on server level and provide a new criteria for session level.
Workaround Description
 1. Use an abstract plan via plan clause to provide hints to the optimizer:

plan

'( sort ( nested ( nl_join ( i_scan location_avail_confid_idx

( table ( la t_location_availability ) ) )

( i_scan PK_LOCID ( table ( l t_location ) ) ) )

( subq ( scalar_agg (nl_join

(i_scan location_mtg_locid_idx t_location_meeting)

(i_scan PK_MTGID t_meeting))))) )

( prop ( table ( la t_location_availability ) ) ( parallel 1 )

( prefetch 2 ) ( lru ) ) ( prop ( table ( l t_location ) ) ( parallel 1 )

( prefetch 2 ) ( lru ) ) ( prop t_meeting ( parallel 1 ) ( prefetch 2 ) ( mru ))

( prop t_location_meeting ( parallel 1 ) ( prefetch 2 ) ( lru ) )'



Or

2. Reduce the total density via

sp_modifystats t_location_meeting, 'location_id', MODIFY_DENSITY, total, absolute,smaller_value

(customers need to test their applications to make sure no negative side effect for other queries).



CR:548000
CR Number:   548000
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2008 Fixed
11 Nov 2008 Reservation Made
Description
UPDATE and DELETE queries that contain correlated existence subqueries, such as:



update tab1 set col1 = 5 where exists (select 1 from tab2 where tab2.col2 = tab1.col2)



may sometimes be executed in deferred update mode when it is possible to use direct update

mode, resulting in a performance regression.



CR:548069
CR Number:   548069
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2008 Fixed
03 Nov 2008 Reservation Made
Description
'set compatibility_mode on/off' is introduced to enable/disable compatibility mode at session level.



CR:548137
CR Number:   548137
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2009 Fixed
Description
Under certain circumstances an error is reported when an invalid data type conversion is attempted, leading to a stack trace as the failed conversion causes an invalid function pointer to be referenced.
Workaround Description
 The workaround is to avoid invalid cast operations. In the client抯 case, converting a date to an integer format, I would recommend adding the three parts of the date together to produce a single integer value:



select * from foo

where a=datepart(year,'2008-10-21')*10000

+ datepart(month,'2008-10-21')*100

+ datepart(day,'2008-10-21')



CR:548150
CR Number:   548150
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)
27 Feb 2009 Fixed
Description
CHECKSTORAGE incorrectly reports error 9960, 'A non-recoverable error has occurred in the CHECKSTORAGE operation. The operation has been aborted.' at a fatal severity level of '20' when the user aborts the CHECKSTORAGE operation.



CR:548188
CR Number:   548188
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2008 Fixed
Description
A 7139 error, "Insert to a TEXT/IMAGE column from a non

TEXT/IMAGE field which involves internal worktable

(eg. orderby, groupby) processing is not supported.

Rewrite your query to avoid conversion from non

TEXT/IMAGE datatype to TEXT/IMAGE datatype." maybe be

reported when executing a query involving an explicit

NULL value being converted to TEXT/IMAGE datatype.



CR:548200
CR Number:   548200
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2009 Fixed
Description
After loading a 12x server based database and transaction dump into a 15x server, when we try to online the database, server could throw error 4218, 692.



CR:548207
CR Number:   548207
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2008 Fixed
09 Nov 2008 Fixed
Description
Enable IBM MQ DMP feature work.



CR:548235
CR Number:   548235
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2009 Fixed
22 Jul 2009 Fixed
Description
When a dump database command is performed on an ASE that uses the sjis charset and the Backup Server is using the eucjis charset, then the Backup Server reports an Open Server message of "Open Server Error: 16368.10.0.0 srv_senddone(): A message was initialized, but not completed" and the dump database command does not respond.
Workaround Description
 Use sjis charset for Backup Server.



CR:548251
CR Number:   548251
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to check the transaction log is valid early in the load process, in order to fail earlier is the log is invalid or corrupt.
Workaround Description
 N/A



CR:548257
CR Number:   548257
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2008 Fixed
21 Nov 2008 Fixed
05 Dec 2008 Fixed
Description
Error 11141 is reported in the errorlog when Adaptive Server fires a

threshold procedure that requires sso_role and when a password has been attached to sso_role.

The threshold procedure is successfully invoked.



CR:548266
CR Number:   548266
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
XPDL: New Feature Request for load to report percentage of pages converted for example:

Cross-platform conversion for database bigTest: 30401 pages completed (10%).
Workaround Description
 n/a



CR:548330
CR Number:   548330
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2008 Fixed
22 Jan 2009 Fixed
22 Jan 2009 Fixed
Description
In rare cases, a 6909 error could be raised and shutdown the server when the first log record for a chained transaction is written to the log.



CR:548336
CR Number:   548336
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2010 Fixed
Description
When you set tracefile and then try to write a query plan into the trace file,

Application Tracing doesn't write a carriage return ("\n") with japanese messages.

That's hard to read the query plan in the trace file.



CR:548411
CR Number:   548411
Product Name:   Adaptive Server Enterprise
Product Component:   sqlloc
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2008 Fixed
Description
sqlloc will show error when setting default language to English and setting default charset to gb18030.



CR:548414
CR Number:   548414
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2009 Fixed
Description
When displaying results in DBISQL using Text Output mode the row count is not displayed on the status bar.
Workaround Description
 N/A



CR:548417
CR Number:   548417
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DBISQL Feature request for accessing the Tools-> Options dialog directly via the toolbar
Workaround Description
 N/A



CR:548419
CR Number:   548419
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2008 Fixed
Description
Change DBISQL User Interface to allow configuring on a per window basis (i.e. Text mode in one window, Grid mode in another) without having to launch windows from the start menu separately.
Workaround Description
 Launch windows from the start menu separately.



CR:548420
CR Number:   548420
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2008 Fixed
Description
In DBISQL it is currently not possible to select/copy a range of cells (such as rows 2, 3 & 4 columns db_size and owner) or select non-sequential rows (such as rows 2, 4 & 6).
Workaround Description
 Change query so that the results match the range of cells / columns that need to be copied.



CR:548422
CR Number:   548422
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2008 Fixed
Description
In GRID output mode, DBISQL 9.0.2 does not all resorting data (by Column) after it has been retrieved. Sorting is now provided in DBISQL 11.
Workaround Description
 Sort/Re-sort data using clauses in the query.



CR:548423
CR Number:   548423
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2008 Fixed
Description
When selecting File --> New , DBISQL issues no warning that you are about to lose all the SQL that you currently have in the window.

This is a feature request to put in place a prompt to save the SQL data.



CR:548487
CR Number:   548487
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2009 Fixed
Description
searching through the pull down menu ... edit, find/replace ... works in the SQL Statement pane but searching through the same pull down menu fails when the Results pane is highlighted.



CR:548500
CR Number:   548500
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2009 Fixed
07 Jan 2009 Fixed
06 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The recovery task may appear to hang forever executing the functions 'redo_apl_oaminsert',

'pg__updateoam_thru_allocpg' and 'pg__recalc_oamentry' after loading a database dump

which was taken on a very active ASE environment.



CR:548559
CR Number:   548559
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2009 Fixed
Description
Previously in DBISQL 9.0.2 if a large amount of rows were copied to the clipboard, a stack trace would occur. The behavior has been modified in DBISQL 11.0.0 so that a friendly message ("There is not enough memory to copy the selected values") is shown instead.



CR:548560
CR Number:   548560
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2009 Fixed
Description
Commands 'raiserror' and 'print' do not work with unichar and univarchar parameters.
Workaround Description
 None known.



CR:548568
CR Number:   548568
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2009 Duplicate
Description
Feature Request: Add a "Result Set" Cache to ASE.



CR:548593
CR Number:   548593
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2013 Fixed
Description
Updating a TEXT value into a proxy TEXT column using the value from a local TEXT column results in garbage being inserted.
Workaround Description
 None known.





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