远程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:648593
CR Number:   648593
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
27 Mar 2011 Fixed
Description
Repeated invocation of space related built-in functions like data_pages() used in sp_spaceused

reads the missing (not found the in ASE cache) pages from the disk and will never keep them in

the ASE cache. This incurs lot of i/o on large databases (database having lot of tables) and

may degrade the response time.



CR:648623
CR Number:   648623
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request: Provide an ASE option for use with MQSeries to use the IBM standard channel table to look up the channel to use based on the queue manager name.



CR:648663
CR Number:   648663
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2010 Fixed
18 Nov 2010 Fixed
Description
When downgrade 1503 esd#3 or esd#4 server back to 1502 server or older, 515 error was raised for null insert into non-nullable columns.
Workaround Description
 [szhuang 2010-Nov-19:]

In the installmaster file, find the definition of sp_downgrade, change following:

----

insert #actions values(9, @sybsecuritydb, 15010,

@downgrade_sysauditoptions_sql,

'Downgrade : Downgrading global auditing options.')

----

To:

----

if (@sybsecuritydb is not null)

begin

insert #actions values(9, @sybsecuritydb, 15010,

@downgrade_sysauditoptions_sql,

'Downgrade : Downgrading global auditing options.')

end

----



CR:648664
CR Number:   648664
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2010 Fixed
16 Nov 2010 Reservation Made
18 Jan 2013 One-off Provided
18 Sep 2012 Fixed
Description
Under some rare conditions, the statement cache entry could have ssql_keep > 0 and this entry could not be removed by the DBCC PURGESQLCACHE command and this could cause problem for the statement cache.



CR:648688
CR Number:   648688
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The new feature request requires the sp_audit "alter" working for all the databases in the server.



CR:648791
CR Number:   648791
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2011 Consult Complete
Description
Optimiser still picking group_hashing after it was specifically turned off



CR:648848
CR Number:   648848
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2011 Fixed
22 Jul 2011 Fixed
Description
An OpenSSL error, "SSL or Crypto Error Info: psn -1, vsn -1, sockp (nil) error id 96, severity -2, provider id 2. SSL or Crypto Error Message: 'An unexpected failure occurred while performing an OpenSSL cryptography operation. Root error: error:0606506D:digital envelope routines:EVP_DecryptFinal_ex:wrong final block length'", may be reported while dumping the transaction log.
Workaround Description
 There is a workaround for SYBASE backupserver

sp_serveroption SYB_BACKUP, "net password encryption", "true"

or done manually via

update sysservers set srvstatus=srvstatus+2 where srvname="SYB_BACKUP"



CR:648863
CR Number:   648863
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2010 Duplicate
Description
Dynamically prepared SQL is not executable after HAFailover in the Cluster Edition. This data is currently lost and the application program must re-prepare the data before execution on the HAFailover's connection.



CR:648948
CR Number:   648948
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2010 Fixed
Description
Executing a procedure with derived table containing UNION queries could lead to permission errors.
Workaround Description
 use tracelfag 10303, which gives old style (pre-12.0) security features.



CR:648998
CR Number:   648998
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
monProcessObject reports table/partition statistics aggregated to the table level and associates the aggregated statistics with the base table and first partition (if any) instead of providing the detailed statistics for each index/partition involved in the query



CR:649000
CR Number:   649000
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)
19 Nov 2010 Fixed
22 Nov 2010 Fixed
Description
In rare circumstances, loading a compressed database dump into an archive database can fail with an error 692, 'Uninitialized logical page '0'..' when Adaptive Server incorrectly loads page 0 from an invalid offset.
Workaround Description
 n/a



CR:649006
CR Number:   649006
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2010 Fixed
19 Nov 2010 Reservation Made
19 Nov 2010 Fixed
Description
Table scans were avoided since the CPU cost for table scans did not take into account reduced row counts due to partition elimination
Workaround Description
 force table scan



CR:649030
CR Number:   649030
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide a configuration option for MQ Series, similar to "xp_cmdshell context", that would would cause ASE to attempt to open the queue as the "sybase" user process by default, with altusr/setid used only when needed for special cases.



CR:649038
CR Number:   649038
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2011 Fixed
05 May 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Under some rare circumstance, parallel queries using expression involving LIKE and variables or parameters could cause stacktrace and the stack will show modules copy__eval() and copy__eoplike().



CR:649039
CR Number:   649039
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2010 Not a Bug
Description
Need to have SSL capability in the Agent to ASE links so that SSL can be used on all ASE CE ports.



CR:649087
CR Number:   649087
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
If a table is altered by adding a column with a user datatype which has a default value bound to it, the user datatype default is missed - a new default is generated. This leads to error 2513 when dbcc checkcatalog being run.



CR:649145
CR Number:   649145
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2010 Fixed
Description
In rare circumstances, the message "Sybmon encountered signal 11" in

the module 'pci_configured' together with a stack trace which includes

the modules 'sm__exec_memload' and 'shm_memload' may be reported in

the error log when a memory dump is loaded with Sybmon while attached

to ASE server.



CR:649171
CR Number:   649171
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2010 Fixed
23 Nov 2010 Fixed
Description
Under some circumstances, when a UNITEXT value is passed to a stored procedure or dynamic

SQL statement as a parameter where a TEXT value is expected, implicit conversion will take

place within ASE. If the UNITEXT value is larger than 450 bytes and the converted TEXT

value is smaller than 450 bytes, a stack trace including the functions, memtextlen()and

LeLOBCache::_copyConstantToCache() will be generated.



CR:649226
CR Number:   649226
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Alter table add column hits error 2705 when "auto identity" is enabled

from a Jconnect client as DBisql.
Workaround Description
 USE isql instead of dbisql



CR:649307
CR Number:   649307
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A new feature request for enhanced timezone support.



CR:649428
CR Number:   649428
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Dec 2010 One-off Provided
11 Jan 2011 Fixed
26 Jan 2011 Fixed
24 Sep 2012 Fixed
Description
Adaptive Server may encounter a storage access violation error when query execution is interrupted.



CR:649470
CR Number:   649470
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 Nov 2010 Fixed
24 Nov 2010 Reservation Made
24 Nov 2010 Fixed
Description
When conserve_tempdb_space optcriteria is used, then tempdb space estimates inside subqueries are not recognized when query plans using large amounts of tempdb space are to be avoided



CR:649590
CR Number:   649590
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2011 Fixed
10 Dec 2010 Reservation Made
12 Jan 2011 One-off Provided
31 Jan 2011 Fixed
Description
Inherently zero row queries, ie with an always false constant conjunct (ie where 1=0), can take a long time to find a query plan.
Workaround Description
 Use compatibility_mode.

Use a "top 0" in the query.



CR:649701
CR Number:   649701
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2012 Fixed
Description
Previously diagnostic information was available for error 290024 - invalid column. Due to possible performance issues, we now print it only if traceflag 2779 is set.



CR:649710
CR Number:   649710
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2011 Fixed
Description
You may retrieve a strange row which has ErrorNumber=110081 and Time='Jan 1 1900 12:00AM' from

monErrorLog just after the ASE is restarted if the ASE is configured with multiple engines.



CR:649754
CR Number:   649754
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
Request for a new feature to check any identity columns following a server upgrade to ensure that the upgrade does not result in 2601 errors.
Workaround Description
 The only workaround was to restore the database from an older backup. Loading a dump from the original 15.0.3 server to the latest 15.5 ESD #2 server resolved the issue.



CR:649793
CR Number:   649793
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
Under certain circumstances when running queries that use MIN/MAX, the ASE optimiser chooses a query plan that is estimated to have a low cost based on the available statistics. When executed the actual cost is much larger than the estimate and the performance may be impacted.
Workaround Description
 An abstract plan can be used to force the required query plan.



CR:649932
CR Number:   649932
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2010 Fixed
01 Dec 2010 Fixed
Description
Sessions which execute dynamic sql query may fail with error 2901 and the exception stack limit is exceeded.



CR:649938
CR Number:   649938
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2011 Added to user documentation
Description
Linux Hughpages the documention is not correct.



CR:649987
CR Number:   649987
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2011 Fixed
13 Jan 2011 Fixed
Description
When running certain stored procedures that use mixtures of local, temporary and tempdb tables, ASE may incorrectly throw error 208: <table_name> not found.
Workaround Description
 set compatibility_mode on

or

fully qualify table using current database name.



or



dbcc traceon (7730) to disable deferred compilation



or:-



sp_configure 'procedure deferred compilation', 0



CR:650044
CR Number:   650044
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to allow downgrading of a single database.



CR:650076
CR Number:   650076
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
Description
Cluster lock space rebuild takes time and as CLM rebuild is a blocking operation, cluster is hung for the duration.



CR:650103
CR Number:   650103
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2010 Fixed
20 Jun 2011 Fixed
Description
DDLGEN cannot generate range partition clause when there is a local index



CR:650163
CR Number:   650163
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2010 Fixed
02 Dec 2010 Fixed
06 Mar 2012 EOL'd version. Not to be Fixed.
Description
Executing dynamic sql query may hit error 8203 in des__markdrop() together with stack trace

involving module ssql__rmplans(), ssql_save_SQL() and sqt_put_in_stmtcache().



CR:650188
CR Number:   650188
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: have 100039 errors resolved within the upgrade process.



CR:650206
CR Number:   650206
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Queries optimized with fastfirstrow optgoal may underestimate

sort operator costs. This problem is exasperated in parallel

query optimization.



CR:650207
CR Number:   650207
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2011 Fixed
17 Feb 2011 Reservation Made
Description
Inline default objects created for the default clauses are not shared among different

columns even with the same default value, leading to unnecessary large number

of default objects in ASE.



CR:650268
CR Number:   650268
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2010 Fixed
Description
For options, for example 'cpas per ccb', defined as CFG_MEMORY_USED but do not consume

any memory at run time, sp_helpconfig will raise error when estimate the memory usage on

them.



CR:650297
CR Number:   650297
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2011 Fixed
10 Mar 2011 Reservation Made
09 Mar 2011 Fixed
Description
In rare circumstances, Adaptive Server may hang as a result of being unable

to reuse object descriptors whose statistics metadata are not yet flushed

on disk. The configuration parameter 'number of open objects' would need

to be increased accordingly.



CR:650302
CR Number:   650302
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer requests that we certify the latest 15.x with the latest versions of NetApp ontap on AIX.



CR:650313
CR Number:   650313
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Repeated "Timestamp for database" messages in the errorlog.
Workaround Description
 Increase the "number of open databases" parameter to be high enough to handle the number

of actual databases in the server.



CR:650316
CR Number:   650316
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2010 Fixed
30 Jun 2011 Fixed
Description
When replicating data from a low durability database, RepAgent may sleep on the end of the log

and fail to detect that the log has been extended. The problem is more likely to be seen when

there is little activity and the transactions are short. RepAgent wakes up and resumes replication

once the log grows past the current last log page where it stalled.



CR:650660
CR Number:   650660
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)
06 Jan 2011 Fixed
21 Jul 2011 Bundled Request
22 Jun 2012 One-off Provided
25 Jun 2012 Fixed
Description
Queries with outer joins on encrypted columns may not return all the rows from the outer table if the encrypted column uses the decrypt_default modifier.
Workaround Description
 Possibly force 'outer join' by OR-ing columns that are NULL.



CR:650670
CR Number:   650670
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE needs feature support to assure that some ASE users are logging in and using encrypted traffic on their session connections to ASE. SSL clients and Kerberos clients with encryption properties set would qualify as "encrypted session users".
Workaround Description
 login trigger to validate is @@ssl_ciphersuite is non-null covers SSL connections. But the trigger neededs to be written and managed.



CR:650686
CR Number:   650686
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Configuration Guide for UNIX
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2011 Added to user documentation
Description
Linux 32bit setup aio formula is ((max async ios per engine + 1) * # of engines

Linux 64bit(both IBM P-series, x86_64 versions) is

((disk i/o structures + max async ios per engine+1) * number of engines)



CR:650839
CR Number:   650839
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2011 Fixed
02 Jun 2011 Fixed
Description
sp_plan_dbccdb may raise a 3606 error, "Arithmetic overflow occurred", if the server contains very large databases or very large devices. The device size values displayed for recommended devices is also not properly adjusted for server page size.



CR:650889
CR Number:   650889
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2011 Fixed
Description
On WinX64 platform configured to use SSL client connections, a segmentation violation may occasionally occur during server start-up due to pending read and cancel on the socket for a site handler RPC connection.



CR:650977
CR Number:   650977
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
19 Jan 2011 Presently Not Targeted For Any Future Release Of This Product
18 Mar 2011 Reservation Made
Description
Unnecessary procedure renormalization involving INSERT/UPDATE into temporary table may happen after temporary table re-creation and recompilation. This can cause sysdepends or sysprocedures contention.
Workaround Description
 TF 299 will avoid the initial TEMPMISSING in-memory renormalization and recompile

and therefore the subsequent recompile will not rewrite to sysprocedures.



CR:651021
CR Number:   651021
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2011 Fixed
Description
Error msg 7105 was changed from "TEXT/IMAGE/UNITEXT page <page id> does not have a next page, although it should." to "TEXT/IMAGE/UNITEXT page <page id> does not have a next page. Either there is a suspect text page chain, or transaction isolation level 'read uncommitted' has been set. Database <db name>, table <table name>, first text page <page id>."



CR:651085
CR Number:   651085
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)
17 Feb 2011 Fixed
Description
If the stack size is under-configured, showplan may sometimes cause stack corruption for a very complicated plan.
Workaround Description
 increase stack size



CR:651152
CR Number:   651152
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
optdiag incorrectly raises error: Data type/length of column X mismatch with the stored values in syscolumns.



CR:651190
CR Number:   651190
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Windows XP
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The reported message of "memory ASE used" looks incorrect on winx64 and nt386 platform if user want to change stack size through sp_helpconfig



CR:651228
CR Number:   651228
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2011 Fixed
Description
Running Job Scheduler installTemplateXMl.csh script results in a "ASE150.csh: No such file or directory" error.
Workaround Description
 Modify GenericTempUtil.csh to something like:

...

if ($?SYBASE_JRE != 1) then

setenv SYBASE_JRE $SYBASE/shared/JRE-6_0_6

# commented out source $SYBASE/ASE150.csh

endif

if ($?SYBASE_ASE != 1) then

setenv SYBASE_ASE ASE-15_0

# comment out source $SYBASE/ASE150.csh

endif

...

and GenericTempUtil.sh to something like:

...

if [ -z "$SYBASE_JRE" ]

then

SYBASE_JRE = $SYBASE/shared/JRE-6_0_6

# commented out . $SYBASE/ASE150.sh

fi



if [ -z "$SYBASE_ASE" ]

then

SYBASE_ASE = ASE-15_0

#commented out . $SYBASE/ASE150.sh

#echo setting SYBASE_ASE variable

#echo SYBASE_ASE is $SYBASE_ASE

fi

...



CR:651352
CR Number:   651352
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 Jan 2011 Presently Not Targeted For Any Future Release Of This Product
Description
In certain circumstances it is possible that an inner class, that has been installed

into an ASE server is not found when required by executed java code.
Workaround Description
 There is no work around



CR:651394
CR Number:   651394
Product Name:   Adaptive Server Generic Docs
Product Component:   Java in Adaptive Server Enterprise
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2010 Added to user documentation
Description
doc bug: add -XX:MaxPermSize to the java_options tunable by sp_jreconfig



CR:651654
CR Number:   651654
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
There is a Typo in the Job Scheduler documentation

Chapter 3: Using Templates to Create Jobs

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

Installing the templates into Job Scheduler



On UNIX:



installTemplateXML servername machinename serverport username password language

On Windows:



installTemplateXML.bat servername machinename serverport username password language

where:



In fact, the name of the template xml script is installTemplateXml (not installTemplateXML) in the Sybase file directory.
Workaround Description
 Use this name: installTemplateXml



CR:651657
CR Number:   651657
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Error 7738 needs meaningfull text adding



CR:651722
CR Number:   651722
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
"insert partition" for range partitions on the fly to avoid the downtime involved in redistributing the data with unpartition/partition.



CR:651726
CR Number:   651726
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2013 Duplicate
19 Dec 2014 Consult Complete
Description
Feature Request to eliminate the requirements for kernel.exec-shield=0 and randomize_va_space=0



CR:651853
CR Number:   651853
Product Name:   Adaptive Server Generic Docs
Product Component:   Transact-SQL Users Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2011 Added to user documentation
Description
Doc Bug: typo ">=", should be "<=" ">" cannot be used in the MAX partition



CR:651865
CR Number:   651865
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2011 Fixed
Description
UPDATE on a nested VIEW may cause a stack trace involving the modules 'vu_mergetress', 'vu_analyze_view' and 'vu_call_analyze_view'.



CR:651914
CR Number:   651914
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2011 Fixed
Description
The 0x08 bit for sysindexes.status2 field does not get correctly cleared when running sp_rename or dropping a constraint.



CR:651924
CR Number:   651924
Product Name:   Adaptive Server Enterprise
Product Component:   SDK
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2011 Consult Complete
Description
need examples how to configure RPC for CS_LONGCHAR_TYPE
Workaround Description
 The recommended workaround was to write the

text/image contents to a file then tell the external scanner to scan the

file. Security restricts us from writing to a file.



CR:652094
CR Number:   652094
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2013 Insufficient info provided
Description
3607 divide by 0 error (return status = -6) with traceflag 3610 on



CR:652103
CR Number:   652103
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2011 Fixed
05 Mar 2012 One-off Provided
Description
The message "current process infected with 11" in the module

'des_unkeep_or_drop' or s_free() with a stack trace that includes the modules

'apm__metrics_insert', 'kill_proc' and 'proc__dealocmem' may be reported in the

error log after a session that was hanging because of the transaction log

being full was killed and the configuration option "enable metrics capture"

was active. This error resulted in ASE shutting down itself.



CR:652106
CR Number:   652106
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2012 EOL'd version. Not to be Fixed.
16 Mar 2012 Fixed
14 Mar 2012 Reservation Made
26 Apr 2012 Fixed
Description
Spinlock contention for Resource->rproccache_spin is huge due to large memory allocation tuning.

------



TF 758 enables this fix. It needs to be used at startup.

Start the server with -T758 and this will enable large scale allocations to use the ELC directly, i.e. 2 page\4 page\8 page.



CR:652110
CR Number:   652110
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)
04 Jan 2011 Fixed
22 Dec 2010 Reservation Made
Description
If a constant expr is in the select list of a VIEW or derived table, and the VIEW is the inner of an OUTER JOIN, and the constant attribute is correlated into a subquery outside of the ON clause of the OUTER JOIN, then a stack trace could occur if a subquery reformatting strategy is chosen, such as in the following query: select Panel = (select PN.c1 from tb1 PN where A.r2=PN.c2) from T3xxx RE left join (select 1 from T1xxx r) A(r2) ON RE.c3=A.r2



CR:652160
CR Number:   652160
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2011 Fixed
Description
DBCC CHECKTABLE may result in 12905 errors when executed on DOL table with indexes.



CR:652269
CR Number:   652269
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
stored procedure to enable and disable optcriterias server wide



CR:652275
CR Number:   652275
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2011 Fixed
24 Feb 2011 Reservation Made
Description
When ASE is waiting for tasks to exit, print additional information to understand why shutdown is not proceeding.



CR:652328
CR Number:   652328
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Dec 2013 Fixed
25 Feb 2013 Fixed
Description
TEXT/IMAGE page chains are not deleted properly from sysattributes when REORG REBUILD is called on a table with TEXT and IMAGE data. This can result in reduction of unreserved/available space in the database.



CR:652364
CR Number:   652364
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)
26 Jan 2012 Insufficient priority to fix
Description
When naming the configuration file, avoid using a dot in the name of the file, with the expection of the extension .cfg. The use of the dot character before the extension 揷fg is required to maintain the history of configuration changes correctly.
Workaround Description
 Avoid using a dot in the name of the configuration file other than as the character that seperates the 憂ame from the three character extension 慶fg



CR:652387
CR Number:   652387
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)
17 Dec 2010 Not a Bug
Description
Query on an audit table will hang when the audit table is full. port CR# 493608 to the 15.5 ASE codeline, which is currently fixed only in cluster edition.
Workaround Description
 make sure there is space for syslogs and sysaudits table



CR:652396
CR Number:   652396
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2011 Fixed
Description
In rare circumstances, the message "current process infected with 11" in the module astc_xid_gen along with a stack trace which includes module sysxacts_materialize may be reported the error log while using systransactions system catalog or stored procedure sp_transactions.
Workaround Description
 n/a



CR:652535
CR Number:   652535
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2011 Fixed
26 Jul 2011 Fixed
Description
Under some circumstances, when STATISTICS IO is enabled and BCP encounters an error, a signal 11 may result followed by a stacktrace with the module 'LeOperator::LeOpProcessIOStats'.
Workaround Description
 Not use set statistics io on with bulk insert.



CR:652562
CR Number:   652562
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2011 Fixed
08 Feb 2011 One-off Provided
Description
A Cluster Edition instance cannot be "onlined" after it was previously killed by VCS during an attempt to join an existing cluster.
Workaround Description
 Possibly increase OnlineTimeOut value to include total cost of failover recovery from the default of 5 minutes to something much longer.



i.e. hatype -modify Sybase OnlineTimeout 1500



CR:652634
CR Number:   652634
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2011 Fixed
08 Mar 2011 One-off Provided
11 Oct 2011 One-off Provided
26 Jun 2012 Fixed
Description
When selecting from a VIEW that selects DISTINCT rows from a base table with at least one encrypted column that specifies a decrypt default value, Adaptive Server gets a SEGV violation and aborts the user session.



CR:652640
CR Number:   652640
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2014 Duplicate
02 Aug 2012 EOL'd version. Not to be Fixed.
Description
When a user with sso_role runs a query accessing a table on current or another database,

a 2736 error may occur during recompiling a light-weight procedure if statement cache

is enabled and the user is not added to the current database.
Workaround Description
 Add the user to the current database.



CR:652646
CR Number:   652646
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2011 Fixed
08 Mar 2011 One-off Provided
10 Mar 2011 Fixed
29 Jul 2011 Bundled Request
21 Jul 2011 Bundled Request
25 Jun 2012 Fixed
Description
A SELECT statement with a qualification that searches an encrypted column that has a decrypt_default modifier and another column using the LIKE operator may ignore the LIKE filter and produce wrong results.



CR:652738
CR Number:   652738
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2011 Fixed
Description
When inserting audit records into audit table fails and node shutdown is issued, the node shutdown may encounter a signal 11 followed by a stacktrace involving the modules 'insert' and 'audproc'.



CR:652746
CR Number:   652746
Product Name:   Adaptive Server Generic Docs
Product Component:   Migration Guide
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Correct the documentation for limits on user table.

"For a select query, the allowable limit is still 50 tables.

The total number of user tables allowed in a query is 512, you can only achieve that by using UNION, with 50 as the limit at single side of UNION."



CR:652772
CR Number:   652772
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2011 Fixed
Description
Alter table drop column operation may result in a 804 error while dropping a TEXT column from a Datarow Locked table with forwarded rows.
Workaround Description
 - Use select into, eliminating the columns to be dropped from the column list



- Run reorg rebuild or reorg forwarded_rows prior to the alter table command



CR:652783
CR Number:   652783
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)
15 Oct 2013 Insufficient info provided
Description



CR:652802
CR Number:   652802
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2013 Insufficient info provided
Description
In rare circumstances, executing a stored procedure may cause the signal 11 in

0x090000000000d6c8 (pci_cfgmgr_default_config+0x7b0).



CR:652932
CR Number:   652932
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Have showplan output the stored proc name when it has an EXECUTE step.



CR:653053
CR Number:   653053
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2011 Fixed
11 Oct 2011 One-off Provided
21 Jul 2011 Fixed
Description
In a user-defined transaction, an UPDATE to a VIEW which triggers an insertion to a remote TEXT column may hang indefinitely.
Workaround Description
 Define proxy without the text column using create existing table



CR:653067
CR Number:   653067
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
Description
sp_helpcache does not display the correct cache binding.



CR:653075
CR Number:   653075
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2010 Fixed
23 Dec 2010 Reservation Made
Description
JConnect may report incorrect row counts when config option 'enable functionality group' is configured.



CR:653101
CR Number:   653101
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2011 Fixed
07 Mar 2011 Reservation Made
10 Mar 2011 Fixed
22 Mar 2011 One-off Provided
10 Jun 2011 One-off Provided
27 Jun 2011 Fixed
Description
In very rare circumstances in a multi-engine environment with a high degree of DML concurrency, index corruptions evidenced by errors like 12301, 12314, 632, 692 and others, can occur following the roll back of a transaction in which index splits or shrinks occurred on data-only locked tables.



CR:653157
CR Number:   653157
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2011 Fixed
28 Jul 2011 Reservation Made
11 May 2011 Fixed
12 May 2011 Fixed
27 Jul 2011 Fixed
28 Jul 2011 Fixed
02 Aug 2011 Fixed
Description
In Adaptive Server/Cluster Edition, the opening of databases when booting

a non-coordinator instance, is performed serially so that

making all databases available takes an unnecessarily long period of time.

The opening of databases is now done in parallel. The previous

behavior has been retained under the 2796 trace flag.



CR:653210
CR Number:   653210
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2011 Fixed
Description
Queries involving SELECT FOR UPDATE may hit signal 10 on Solaris/HP platforms.



CR:653212
CR Number:   653212
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2011 One-off Provided
22 Mar 2011 Consult Complete
25 Mar 2011 Fixed
26 Apr 2011 Fixed
10 Apr 2011 One-off Provided
04 Apr 2011 Fixed
14 Sep 2012 Fixed
14 Sep 2012 Fixed
Description
The message "Error: 820, Severity: 21, State: 6" may be reported in the error log

together with a stack trace including the modules 'bufpindirty' and 'pg_allocate'.

Alternatively, the "infected with 11" message may be seen in the error log together

with a stack trace showing the modules 'xls_bufunpin' and 'buf_get_latch'.



CR:653246
CR Number:   653246
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Dec 2010 Fixed
Description
In 'Advanced Options' page of 'Add Database Device' Wizard, the 'skip allocation' is enabled by default (the box is checked).



CR:653277
CR Number:   653277
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Control GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 11 Sep 2013 Fixed
12 Sep 2013 Reservation Made
15.7 SP121 12 Sep 2013 Fixed
15.7 SP110 13 Sep 2013 Fixed
15.7 SP60 07 Oct 2013 Fixed
Description
An UPDATE query running in a batch that includes a CREATE INDEX or UPDATE/DELETE STATISTICS or an UPDATE query running simultaneously with a workload that involves CREATE INDEX or UPDATE/DELETE STATISTICS may lead to data inconsistency.



CR:653385
CR Number:   653385
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)
04 Jan 2011 Fixed
05 Jan 2011 Fixed
Description
In Adaptive Server Cluster Edition version 15.0.1 ESD#4 or later, the message "current process infected with 11" in the module cm_bind_cache() may be reported in the error log when a cache binding or unbinding operation fails due to any error.



CR:653458
CR Number:   653458
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Dec 2010 Fixed
05 Jan 2011 Fixed
Description
Sybase utilities that connect to the ASE server on Windows 64bit platforms may fail to connect when being run in a remote desktop connection and ASE is running as a service or in another (different) remote desktop session.
Workaround Description
 Run the utility in the same session as ASE (for ASE running as a service, run the utility from the machine console session).



CR:653511
CR Number:   653511
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2011 Fixed
31 Mar 2011 Reservation Made
26 Apr 2011 Fixed
Description
If a stored procedure undergoes recompilation, and the procedure makes assumptions regarding session's state (ie session environment settings), the resulting recompiled plan can be significantly different to the original. This fix is only active when traceflag 7773 is active.



CR:653512
CR Number:   653512
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2011 Not a Bug
Description
login with 100 roles assigned directly takes 6 times longer to login than 1 role
Workaround Description
 Do not assign roles directly to the login, use child role.



CR:653575
CR Number:   653575
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2012 Presently Not Targeted For Any Future Release Of This Product
Description
ASE 15 change the data type we return for the avg function from Numeric to

Big integer request to have a trace flag to revert the behavior.
Workaround Description
 use the convert function.



As sample for the select in the reproduce section.

select convert(numeric (38,17), avg(case when a1.a < 7 then (2147483648 - b) else b end))

from a1

go



CR:653621
CR Number:   653621
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2013 Insufficient priority to fix
Description
showplan shows 2k pool sysmons shows 16K i/o while creating an index





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