远程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:585188
CR Number:   585188
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2010 Insufficient priority to fix
16 Sep 2010 Fixed
Description
AT_ISSTRIPELDED returned -1 Error messages for backupserver should be improved



CR:585221
CR Number:   585221
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2009 Fixed
Description
In rare circumstances, the message "current process infected

with 11" in the module 'des_rekeep' together with a stack trace

which includes the modules 'proc__linktopss' and 'lwp_proc_setup'

may be reported in the error log when a client application is

executing a query using "dynamic sql" and the system is configured

with a low value for the configuration parameter "number of

open objects" according to its workload.
Workaround Description
 Increase the configuration value for "number of open objects"

according to your system workload so the DEScriptors for the

internal LWPs used by dynamic SQL are not reused.



CR:585260
CR Number:   585260
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2009 Fixed
Description
Unnecessary recompilations may happen if 'open by name' trace flag 299 is activated

and a temporary table has at least one BIT column.



CR:585267
CR Number:   585267
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Derived table without specifying column name in the embedded select doesn't work
Workaround Description
 Specify the column name in the embedded select will work,

eg,

1> select max(prevdate) from (

2> select prevdate=dateadd(dd ,datediff(dd, '0:0', getdate()) - number ,'0:0')

- column name here

3> from master.dbo.spt_values

4> where type='P' and number between 1 and 10

5> )t -- no column name here

6> where datepart(dw,prevdate) not in (1,7)

7> and not exists

8> (select 1 from holidays where holiday=t.prevdate)

9> go



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

Aug 11 2009 12:00AM ==> it works



CR:585304
CR Number:   585304
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 Sep 2009 Fixed
11 Aug 2010 Fixed
12 Aug 2010 Fixed
Description
Parallel BCPs into a semantically partitioned DOL table can deadlock when two sessions perform

allocation at the same time. The deadlock information will consistently show the deadlock

ccurring on rowid 0 for both spids.



CR:585313
CR Number:   585313
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)
14 Aug 2009 Duplicate
Description
Create proxy_table fails when ECDA backend table has default values specified.
Workaround Description
 WorkAround:

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

You can set the Access Service property to CSPColumnODBCVersion = 2, but no default values

will be defined and you won't be able to take advantage of inserting data with use of

default values. Can be a data integrity issue or cause errors.



However you can do create existing table:

[This done on MSSQL Server]



sp_addobjectdef deftest_mssql_ce, 'dca150_mssql_win...deftest'

go



create existing table deftest_mssql_ce (

c1 int not null,

c2 char(3) not null,

c3 char(3) default 'abc' not null,

c4 int default 0 not null

)

go



insert deftest_mssql_ce (c1, c2) values (1, 'zzz')

go



1> select * from deftest_mssql_ce

2> go

c1 c2 c3 c4

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

1 zzz abc 0



(1 row affected)



OR



sp_addobjectdef deftest2_mssql_ce, 'dca150_mssql_win...deftest2'

go



create existing table deftest2_mssql_ce (

c1 int not null,

c2 char(3) default 'abc' not null,

c3 int

)



insert deftest2_mssql_ce (c1, c3) values (1, 2)

go



1> select * from deftest2_mssql_ce

2> go

c1 c2 c3

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

1 abc 2



(1 row affected)



CR:585444
CR Number:   585444
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2009 Fixed
Description
This introduces "ULC flushes by Log Markers" entry in the ASE sp_sysmon report.



A high value for 揵y Log markers indicates that Adaptive Server is flushing the ULCs because of

permanent log marker scans (a permanent log marker scan indicate that syslogs includes the log

record). Adaptive Server uses the log records for operations like executing triggers, rollbacks,

aborts, and so on. When Adaptive Server needs a permanent log marker but does not have one, it

flushes the ULC to create a new log marker. When 揵y Log markers displays a large percentage of ULC

flushes, you may need to reduce the number of unnecessary or redundant triggers, rollbacks, or aborts.



CR:585467
CR Number:   585467
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2009 Fixed
Description
Despite traceflag 11906 being on, reorg rebuild messages are reported to the errorlog.



CR:585474
CR Number:   585474
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2009 Fixed
Description
When using a dblib client version <5.0 that doesn't permit numerics, selecting on a bigint column creates a tds stream error.
Workaround Description
 WorkAround:

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

Issuing a convert (numeric(20), column) will not crash - but customer is

refusing the workaround.



Also (dbsetversion(DBVERSION_100) will work as well - again, customer refuses

to do this. Their application also works with MSSQL Server, so they are used

to using older TDS 4.X level.



DBVERSION_100 will use newer TDS and this won't work on their MSSQL Server.

When used, the data type is TDS_NUMN, Precision = 20 (0x14).



Basically the CR is to fix the TDS bug.



CR:585485
CR Number:   585485
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2009 Fixed
Description
Performance of bcp for SMP server is degraded.



CR:585517
CR Number:   585517
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2009 Fixed
04 Sep 2009 Fixed
22 Sep 2009 Fixed
Description
When a user with sa_role executes SETUSER to a non-sa_role user,

creates a table and a procedure referring to that table, then

execution of that procedure following a schema change such as

dropping and recreating the table will result in an "object

not found" error (Msg 208).



CR:585588
CR Number:   585588
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2009 Fixed
10 Nov 2009 Reservation Made
Description
When a disjunctive predicate that is same as a row constructor is used in a query, the optimizer will not chose a general OR strategy (also know as index union) will not be selected. The row constructor type predicate will have to look as follows (col1 > <literal1) OR (col1 = literal1 AND col2 GT/GE literal2).
Workaround Description
 This problem can be worked around by either explicitly parameterizing the

query with variables or implicitly using autoparams.

This can be done by simply parameterizing the query as

follows:



declare @v int

declare @v1 int

declare @v2 int

select ... from A where a1 > @v or (a1 = @v1 and a2 >= @v2)



Now the predicate transformation will not happen. This can be achieved also

by literal parameterization and this is what we suggested.



CR:585665
CR Number:   585665
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2009 Fixed
14 Sep 2009 Fixed
17 Sep 2009 Fixed
21 Sep 2009 Fixed
Description
User applications that use JDBC or Java Stream operations may be affected

by memory corruptions or abnormal process termination when the optimized

ASE binary is in use. This problem is most likely to manifest on Linux 64-bit

architectures.



CR:585707
CR Number:   585707
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Sub-optimal plan may be seen under allrows_oltp for query involving distinct multi-table join.
Workaround Description
 set conserve_tempdb_space 1



--or



set opportunistic_distinct_view 0



Also, tracecommand line 15332 is available as a workaround

with the changes in cr 598541.



CR:585711
CR Number:   585711
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Change in query plan maybe be seen between 'select' and select into' (or insert..select)

for queries involving distinct multi-table joins.
Workaround Description
 set conserve_tempdb_space 1



--or



set opportunistic_distinct_view 0





Also, tracecommand line 15332 is available as a workaround

with the changes in cr 598541 in 15.0.3 esd #4 and above.



CR:585772
CR Number:   585772
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2009 Fixed
Description
Internal only: stress tests with competing bcp and transfer-table tasks can cause the transfer to encounter a transitory wrong-page error from an uninitialized page.



CR:585798
CR Number:   585798
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2009 Bundled Request
Description
BCP Wizard's output shows the connection's password, which should be hidden. Also, BCP Wizard should not open if the server name is not in the interfaces file for BCP utility.



CR:585991
CR Number:   585991
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2009 Fixed
Description
The SET SWITCH command does not work with traceflags 7714 and 7715.



CR:586032
CR Number:   586032
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2010 Fixed
Description
If there is /tmp/locales directory and install ASE 15.0.3 ESD#1 into /tmp/ase1503 directory, srvbuil and srvbuildres does not work with error "unable to load localization file /tmp/locales/unicode/us_engli/srvconfig.lcu".



CR:586084
CR Number:   586084
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2013 Insufficient priority to fix
Description
Feature request to see the detailed information of HA sessions.



CR:586167
CR Number:   586167
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2009 Fixed
24 Sep 2009 Fixed
17 Sep 2009 Fixed
17 Sep 2009 Fixed
Description
Automatic workspace expansion in checkstorage does not expand the text workspace automatically even though the text workspace is smaller than the recommended size, which is 25% the size of the scan workspace.



CR:586220
CR Number:   586220
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2009 Fixed
28 Aug 2009 Fixed
16 Sep 2009 Fixed
04 Sep 2009 Fixed
Description
The error msg 414 could be raised if the plan chose reformatting strategy and it has many join predicates.
Workaround Description
 change the ase server from using 2K pages to using 4K pages...this was an unacceptable workaround for this customer ... JPMorgan



(zhao 8/25/2009) The workaround could be turn off reformatting before this update query and turn on reformatting after this query. "set store_index 0" could be used to turn off reformatting strategy and "set store_index 1" used to tuen on reformatting.



CR:586356
CR Number:   586356
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2009 Fixed
Description
For queries containing IN/OR list where one or more elements in the IN/OR list is a built-in function, unexpected results might be returned.
Workaround Description
 Avoid str_replace in the in clause



declare @a varchar(17), @b varchar(17)

select @a = 'FB-102195'

select @b = str_replace(@a, "-", " ")

select * from tempdb..tabA where ColA in (@a, @b)



CR:586387
CR Number:   586387
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2010 Fixed
Description
Mistype the SIZE option of a DISK RESIZE command as 'SIDE' gives an error relating to DISK UNMIRROR instead of DISK RESIZE.



CR:586425
CR Number:   586425
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2009 Fixed
25 Aug 2009 Fixed
Description
When running on a Unix system, the BCP Wizard cannot BCP in/out multiple tables.



CR:586426
CR Number:   586426
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2009 Fixed
27 May 2014 Presently Not Targeted For Any Future Release Of This Product
31 Aug 2009 Fixed
Description
sp_dropdevice does not delete the physical file created for filesystem device



CR:586499
CR Number:   586499
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2010 Fixed
05 Aug 2010 Reservation Made
24 Aug 2010 Fixed
16 Sep 2010 Fixed
09 Nov 2010 One-off Provided
13 Jan 2011 Fixed
Description
On Solaris platform, ASE may report "Unexpected AIO error(Invalid argument)returned from aiowait()."

when LDAP User Authentication is enabled (configuration option 'enable ldap user auth' is set to

1 or 2) and ASE is performing multiple user authentication simultaneously.

This bug can be resolved by installing patch for Solaris BugID 6972029

(contact Oracle for the OS patch, sun sparc: 144190-03, sun x64 144191-02).

Alternatively, it can be resolved in ASE through a workaround fix by enabling boot time trace flag 9415.
Workaround Description
 Install patch for Solaris BugID 6972029 (contact Oracle for the OS patch).



CR:586565
CR Number:   586565
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2009 Fixed
31 Aug 2009 Fixed
23 Sep 2009 One-off Provided
01 Dec 2009 One-off Provided
29 Aug 2012 Fixed
Description
A Dump or Load operation failing to open the device may not report the underlying Operating System error.



CR:586638
CR Number:   586638
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need to document how to use password encryption with Sybase Central



CR:586640
CR Number:   586640
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2009 Fixed
Description
SpinBox value get truncated when value greater than max.



CR:586666
CR Number:   586666
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2009 Fixed
25 Aug 2009 Fixed
Description
Internal only: running 'transfer table' on a multi-engine server can fail with OS reported I/O errors.



CR:586727
CR Number:   586727
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2009 Fixed
28 Oct 2009 One-off Provided
Description
Under certain circumstance, during recovery, timeslice may be hit while server is processing multiple lock related messages



CR:586748
CR Number:   586748
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2009 Fixed
Description
In case of a mixed log and data database, a deadlock involving cm__waitfor_io()

may be reported during boot recovery.



CR:586779
CR Number:   586779
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2009 Fixed
27 Aug 2009 Fixed
06 Jan 2010 EOL'd version. Not to be Fixed.
Description
The dump command may not raise an error message reporting "No space left on device" on Linux when the device is closed using Backup API compress.



CR:586809
CR Number:   586809
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2009 Fixed
Description
"max transfer history" in DTU is missing after upgrade from 15.0 to 15.5 (Aries)



CR:586833
CR Number:   586833
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2009 Fixed
28 Feb 2010 Fixed
19 Jan 2010 Fixed
21 Dec 2009 Fixed
25 Jan 2010 Fixed
28 Jan 2010 Fixed
Description
DBISQL does not support password encryption directly.



CR:586861
CR Number:   586861
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2010 Fixed
05 Mar 2010 Fixed
Description
Query with CASE expression returning TEXT columns and TEXT constant

may fail to execute correctly producing stack traces.



CR:587115
CR Number:   587115
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2009 Fixed
Description
The kerberos principal name in the audit table is not being displayed.



CR:587182
CR Number:   587182
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2009 Fixed
09 Sep 2009 Fixed
Description
Advisory messages printed by sp_dboption when trunc. log on chkpt. is turned on/off are confusing

because they appear to be errors. The messages will no longer be printed by sp_dboption.



CR:587220
CR Number:   587220
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2009 Fixed
01 Sep 2009 Fixed
Description
The error 3146 will be raised when trying to load a database from a valid server version onto a database after having loaded a previous version onto the same database without having set the database online.
Workaround Description
 Drop and recreate the database.



CR:587274
CR Number:   587274
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2009 Fixed
Description
In rare cases, a process might hit 706 error with stack trace including functions such as rm_prochdr and rec__ctx_cleanup.



CR:587362
CR Number:   587362
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2009 Not a Bug
Description
If an application made use of a global temporary table in an external environment via a server-side connection, then there was a chance that the server may have given an assertion, hang or crash when the application connection closed. This problem has now been fixed.



CR:587403
CR Number:   587403
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)
24 Jun 2010 Bundled Request
Description
When raised by the DISK MIRROR command, error 5101 may incorrectly state that the command being run was DISK UNMIRROR.



CR:587406
CR Number:   587406
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2009 Fixed
Description
In specific circumstance, error 511 may occur during optdiag input mode when creating column histograms.
Workaround Description
 Remove the relevant column statistics from the input file and perform the optdiag input.

Create the stats on the target server manually using update statistics <table> (<column>)



CR:587426
CR Number:   587426
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2009 Fixed
Description
Specifying a filename of 256 characters for DTU output file results in the correct error with right file name.



CR:587437
CR Number:   587437
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2009 Fixed
17 Sep 2009 Fixed
02 Dec 2009 One-off Provided
Description
When using parallel sort on worktable, errors and/or stack traces can be encountered while executing the sort operator.
Workaround Description
 Turn off parallel and set 'max parallel degree' to default value (1).



This workaround may be not acceptable for some customers who need to use parallel for performance.



CR:587442
CR Number:   587442
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2009 Fixed
Description
Error 1265 when cursor fetch rows from syscomments table.



CR:587525
CR Number:   587525
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2009 Fixed
Description
set tracefile for spid will fail on ibmplinux platform with error 3659 "The spid 0 does not exist."

even when the spid in the command is valid.



CR:587661
CR Number:   587661
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
max locked memory should be increased with a call to setrlimit from dataserver processes for linux platforms.



CR:587742
CR Number:   587742
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2009 Fixed
15 Jan 2010 Fixed
Description
ASEPlugin 15.0.3 - NullPointerException error if SSL check box is checked.



CR:587810
CR Number:   587810
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2012 Duplicate
Description
Add a configuration option 'enable HugePages' to control allocation as follows, with HugePages if available else regular pages, only with HugePages and fail if not available, only with Regular Pages.



CR:587877
CR Number:   587877
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
ASE may raise the misleading error message "The configuration area in device 'master' appears to be corrupt. The server cannot continue and will shut down." following an upgrade if the master device size is than the minimum for the new version.



CR:587879
CR Number:   587879
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 Mar 2012 Fixed
Description
preupgrade does not raise an error if the master device is too small and will pass the test, then

while booting up the higher version server to apply upgrade, ASE will raise 110272 error.



CR:587984
CR Number:   587984
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2009 Duplicate
Description
sybmigrate may raise a 17741 error and fails to create a foreign key if multiple tables have complex logical relationship

(a primary key and foreign keys) with each other.
Workaround Description
 Create a foreign key by yourself.



CR:588137
CR Number:   588137
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2010 Fixed
19 Jan 2010 Duplicate
14 Nov 2012 Fixed
Description
Duplicate key values could be generated for identity column during checkpoint of the database. For tables with unique indexes on identity column, it would give error 2601 'Attempt to insert duplicate key row in object <obj_name> with unique index <index_name>'. more co

A more complete version of this fix has been developeed under CR 614823, i.e. 614823 supersedes 588137.



CR:588150
CR Number:   588150
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2009 Fixed
17 Sep 2009 Added to user documentation
Description
Add InstanceID column to the below tables

monInMemoryStorage

monPCISlots

monPCIEngine

monPCIBridge

monProcedureCacheModuleUsage

monProcedureCacheMemoryUsage



CR:588162
CR Number:   588162
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2009 Fixed
Description
For in-memory storage cache, if the memory allocated is less than user's requested

cache size, cache creation will be failed.



CR:588176
CR Number:   588176
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Closed
OS:   SunOS
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2009 Not a Bug
Description
15.0.3 or later ASE Plug-in is not compatible with Sybase Central 4.3.



CR:588214
CR Number:   588214
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2010 Fixed
01 Jun 2010 Presently Not Targeted For Any Future Release Of This Product
11 Mar 2010 Fixed
Description
Under rare circumstances when an ASE task disconnects due to connection loss

the Java associated thread executing on the behalf of the ASE task will not be

notified to clean up its resources. This will result in leaking thread and memory

resources at operating system level.



CR:588263
CR Number:   588263
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2009 Fixed
Description
In rare circumstances we may hit error 8211 (Mismatch found between the name and id descriptor hash table for table) while accesing table in the multinode cluster environment.



CR:588268
CR Number:   588268
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide a command to enables the ASE sysam heart beat process to be restarted in the event that this process has stopped for any reason.
Workaround Description
 The feature has been requested because the workaround suggested on CR 498534 is not acceptable to the client.



CR:588272
CR Number:   588272
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2010 Fixed
Description
When the ASE Replication Agent connects to the Replication Server version 15.5 or above,

it will issue the Replication Command Language command 'resetqueue' by default

when starting up against a database with a durability value of 'no_recovery',

instead of incrementing the primary database generation ID, so to prevent

the likelihood of hitting a limit while updating the generation ID value.

The current ASE fix will be effective when the Replication Server CR 615322

is also released in some later Replication Server 15.5 ESD version.
Workaround Description
 N/A.



CR:588288
CR Number:   588288
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature ... exclude rs dsi thread from being deadlock victim in replicate db



refer to ASE CR 230301 and refer to RepServer CR 370359 ... customer wants a feature request added where the RS thread is never the deadlock victim on a replicate db. He's had issues in the past where even after multiple retries, the tran is still in a deadlock causing the DSI to suspend.



If the rs thread is chosen for the deadlock victim, in some cases even after attempting the tran multiple times it still deadlocks, causing the tran to not complete and the DSI to suspend or if set to ignore the primary and replicate dbs become out of sync



CR:588307
CR Number:   588307
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Linux
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2009 Fixed
Description
To request high-availability when connecting to a cluster, put the following property on Connect Dialog's Advanced tab: REQUEST_HA_SESSION=true



CR:588310
CR Number:   588310
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2009 Fixed
Description
Instance ID, transfer format (e.g., BCP, etc) are added to monTableTransfer



CR:588334
CR Number:   588334
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2009 Fixed
Description
User sees 'stop pv tracing' msg on preview dialog if user calls scheduler from preview dialog and calls cancel scheduler.



CR:588358
CR Number:   588358
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2010 Fixed
Description
Executing installhasvss script raises a 2615 error.



CR:588464
CR Number:   588464
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2009 Fixed
22 Sep 2009 Fixed
Description
Sometimes, database upgrade fails with error 1204, "out of lock error" while upgrading a system table with a huge number of rows.



CR:588556
CR Number:   588556
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sig 11 in GcvIsVirtualColumn when using view in sql regardless of optgoal setting
Workaround Description
 Do not use the view.



CR:588594
CR Number:   588594
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2009 Fixed
16 Sep 2009 Fixed
Description
When the optimizer chooses a query plan that includes a Nary-Nested-Loop Join Operator

(as seen in showplan output) and at least one of the Scan Operators under the Join is

doing dynamic partition elimination (also shown in showplan), the query may return too few

rows. This problem ocurrs in queries with at least three tables and which contain join

predicates involving columns of the partitioned table that are not part of the partition

condition of that table.
Workaround Description
 Turn on trace flag 342, to disable N-ary NLJ;

or turn on trace flag 449 to disable Runtime Partition Elimination.

Trace 449 is more likely to impact performance.



CR:588665
CR Number:   588665
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2009 Fixed
06 Sep 2009 Fixed
07 Sep 2009 Fixed
Description
A new column "Transactions" has been added to the monState table



CR:588681
CR Number:   588681
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2010 Bundled Request
Description
ASE reports "Protocol <XXXXX> not supported within soc_nopen()" error in errorlog.

This may be followed by SIGSEGV, SIGBUS or timeslice error and lead to ASE hang.

ASE reports incorrect name of the function from which it is raised.



CR:588703
CR Number:   588703
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2009 Fixed
29 Sep 2009 Fixed
Description
Some of the qualifying rows could be missed by an UPDATE statement using at least 2 tables other than the updated table (either directly in the UPDATE statement's FROM clause or within EXISTS/IN subqueries) and the join of these 2 tables involves an expression which contains one of these tables' columns which is also in the UPDATE's SET clause to compute the new values.
Workaround Description
 set compatibility_mode on



CR:588724
CR Number:   588724
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)
09 Sep 2009 Fixed
15 Dec 2009 Fixed
Description
The user_name() function incorrectly returns NULL for negative user ids starting in 15.0 GA.



CR:588739
CR Number:   588739
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2009 Fixed
Description
In SDC, user cannot create/alter/transfer a DTU/normal table.



CR:588918
CR Number:   588918
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Nov 2009 Duplicate
Description
Signal 11 in s__mergelock_in_sub_step ()may be seen in the error log and the spid

terminated for query involving text column, nested convert with concatenation to correlated

sub-query result.



CR:588954
CR Number:   588954
Product Name:   SCC Web Framework
Product Component:   GUI
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2010 Not a Bug
Description



CR:588978
CR Number:   588978
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2009 Fixed
06 Oct 2009 Fixed
Description
Error 804, "Unable to find buffer '0x1ead04898' from cache 'default data cache' holding logical page '17179418212732195' in sdes '0x21f3e4700' kept buffer pool for object ''. " may be reported while trying to allocate a new page.



CR:589030
CR Number:   589030
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2009 Fixed
Description
The error, "Warning: The database '%.*s' is assigned the %s property, which will be ignored, because the database has a durability of %s." may be reported while changing the durability of the database.



CR:589045
CR Number:   589045
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2009 Fixed
18 Sep 2009 Fixed
Description
ASE running on windows may print the result "-0.000000" for some floating point calculations



CR:589061
CR Number:   589061
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2009 Fixed
17 Sep 2009 Fixed
Description
TEXTPTR() builtin function may sometimes return truncated results with trailing zeros removed. This occurs when a "hash distinct" operator is involved.



CR:589086
CR Number:   589086
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Microsoft Win32s
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2009 Added to user documentation
Description
Histsrvr can't work without MS VS2005 Redistributable Package(x86) on winx64 platform



CR:589204
CR Number:   589204
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2009 Fixed
16 Sep 2009 Fixed
16 Sep 2009 Fixed
Description
Historical Server playback incorrect spid value on unix 64bit platform

and miss the first sample when the timestamp of sample equal to the start time of playback session



CR:589215
CR Number:   589215
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to increase ASE limit that only allow 30 character for passwords.



CR:589218
CR Number:   589218
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE LDAP user authentication to support LDAP long token - 40 chars for password.



CR:589220
CR Number:   589220
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2009 Fixed
09 Sep 2009 Fixed
Description
On little endian platforms the builtin is_quiesced(<dbid>) returns always 0 although

the given database was previously quiesced.



CR:589235
CR Number:   589235
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)
10 Mar 2010 Fixed
15 Mar 2010 Fixed
Description
ASE raises an infected with 11 stacktrace in function valid_Xcast with lasterr 10762 if an attempt is made to use a Java method when there is no JavaVM in place.
Workaround Description
 Configure the JavaVM pluggable component.



CR:589314
CR Number:   589314
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Documentation enhancement request to provide a formula for the calculation of tempdb space needed for the update statistics commands.



CR:589346
CR Number:   589346
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2010 Fixed
Description
The message "Current process infected with signal 11" may be reported

with the stack trace including modules 'NormalizeScalar' and 'Optimize'

when executing a SELECT statement with a GROUP BY clause which joins

two or more views including subquery(s) in the SELECT list of the view(s).

The query must be a non-ANSI extended column aggregate query, which

references columns outside the GROUP BY list, in the SELECT list or

HAVING clause, outside aggregate expressions.



CR:589444
CR Number:   589444
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 Sep 2009 Not a Bug
Description
1502 QP: underestimated LIOs and PIOs for the scan of an idx after deletes



CR:589446
CR Number:   589446
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2009 Fixed
Description
row_count() returns 0 after select-into in tempdb due to a code error.



CR:589473
CR Number:   589473
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2009 Fixed
09 Oct 2009 Reservation Made
08 Oct 2009 Fixed
10 Mar 2010 Not a Bug
Description
When parallelism is involved, some queries having more than 6 tables may timeout earlier during plan enumeration resulting in a merge join plan that uses excessive tempdb space.
Workaround Description
 A few possible workarounds based on testing:

1.disable parallel

or 2. use allrows_oltp optimization goal

or 3. disable merge join operator

or 4. disable alternative greedy algorithm

or 5. increase optimization timeout



CR:589491
CR Number:   589491
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2009 Fixed
Description
The authentication mechanism is not displayed in the audit record when doing

dbcc table_xfer_check.



CR:589591
CR Number:   589591
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Release Bulletin for Solaris
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2012 EOL'd version. Not to be Fixed.
Description
Release bulletin in 15.0.3 lacks much of the information included in previous versions.
Workaround Description
 Read previous RBs.



CR:589619
CR Number:   589619
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2010 Fixed
25 Mar 2010 One-off Provided
04 Jun 2010 One-off Provided
Description
In rare circumstances, the message Current process (0x...) infected with signal 11 (SIGSEGV) together with module names like SeClock::SclResetTimeoutCeil() may appear for queries involving many tables (> 10).
Workaround Description
 --lower the timeout

--try:-



set plan opttimeoutlimit 5 --this may work



--or



set bushy_space_search off --this may work



CR:589650
CR Number:   589650
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2009 Fixed
09 Nov 2009 One-off Provided
22 Oct 2009 Reservation Made
Description
Error "Msg 325, Level 18, State 1: Server '...', Line 1: Adaptive Server finds no legal query plan for this statement." may be generated for queries involving outer joins to a derived table (and/or views) which itself contains grouping and the user has disabled reformatting, either via "set store_index off" or traceflag 328. The 325 error can also occur in derived tables (and/or views) using unions, and/or when multiple derived tables are in the same query with "store_index" turned off.
Workaround Description
 Not to disable reformatting and merge join at the same time or compatibility mode.



CR:589657
CR Number:   589657
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2009 Fixed
21 Oct 2009 Fixed
Description
With SQL Replication enabled, queries using "CASE constant expression" (i.e. an expression which is not referencing table columns) may fail with error 401 "Invalid operator for datatype op: = type: MAINTENANCE TOKEN" or error 551 "An unknown EVAL was sent to the execution module."



CR:589674
CR Number:   589674
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 Oct 2009 Fixed
05 Oct 2009 Fixed
02 Oct 2009 Fixed
02 Oct 2009 Fixed
Description
Sending a Java object using Java/JDBC on the client-side can result in a corrupted object stream

being stored in a database table.



CR:589686
CR Number:   589686
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)
24 Feb 2011 Bundled Request
Description
Feature request to have Msg 935 (WARNING - the timestamp in database '%.*s' is

approaching the maximum allowed) always be sent to the errorlog when it is raised.



CR:589780
CR Number:   589780
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2009 Bundled Request
29 Sep 2009 Fixed
29 Sep 2009 Fixed
Description
The table-level SQL statement replication threshold setting is not kept consistent on all the nodes

of the cluster when it is changed on one of the nodes and the table is not marked explicitly

for replication.





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