远程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:620587
CR Number:   620587
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)
03 Jun 2010 Fixed
02 Jun 2010 Fixed
Description
A 2583 error, "Number of data pages (<n>) counted by DBCC differs from count in the data OAM (<n2>) for dbid <db> object .." may be reported by dbcc checkdb when a dump from a previous ASE version is loaded when a table is bound to a named cache.



CR:620626
CR Number:   620626
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2010 Fixed
13 Jul 2010 Fixed
Description
In SDC, nodes may run out of physical locks when configured with disparate cache sizes.



CR:620628
CR Number:   620628
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2010 Fixed
24 Nov 2011 Fixed
Description
EN templates should be displayed when no other templates are available for JS in the language the client machine is using.
Workaround Description
 The workaround is to install the templates for the language which the client machine is using. This way, there will be templates displayed for creating a new job in Job Scheduler.

If you have working JS installation just change your PCs language settings to Finnish or French and try to create a new job with templates..... Or change column jstemp_language in js_templates table to fi and use your default language settings in PC.

how I got this to work. I installed 2 sets of templates, one with english and one with finnish.

From Sybase Central - js_template



jtmpl_id,jtmpl_type,jtmpl_name,jtmpl_description,jtmpl_owner,jtmpl_created,jtmpl_version,jtmpl_group_path,jtmpl_update,jtmpl_language

1,0,'Sybase Backup Database to Disk Template','Dumps specified database(s).','jstask',2010-02-24 10:03:56.976,'3.1','Backups',0,'en'

2,0,'Sybase Backup Transaction Log to Disk Template','Dumps transaction log of the specified database(s).','jstask',2010-02-24 10:03:57.986,'3.1','Backups',0,'en'

3,0,'Sybase Delete Statistics Template','Deletes table or column statistics.','jstask',2010-02-24 10:03:58.806,'3.0','Statistics Management',0,'en'

4,0,'Sybase Rebuild Indexes Template','Runs reorg rebuild command on index(es).','jstask',2010-02-24 10:03:59.616,'3.1','Reorganization',0,'en'

5,0,'Sybase Rebuild Tables Template','Run reorg rebuild command on table(s).','jstask',2010-02-24 10:04:00.41,'3.0','Reorganization',0,'en'

6,0,'Sybase Reclaim Index Space Template','Runs reorg reclaim space command on index(es).','jstask',2010-02-24 10:04:01.24,'3.1','Reorganization',0,'en'

7,0,'Sybase Reclaim Table Space Template','Runs the reorg reclaim space command on table(s).','jstask',2010-02-24 10:04:02.036,'3.0','Reorganization',0,'en'

8,0,'Sybase Reconfigure Locks Template','Resets "Number of Locks" if warranted.','jstask',2010-02-24 10:04:02.85,'2.0','Reconfiguration',0,'en'

9,0,'Sybase Reconfigure Metadata Cache Template','Reconfigures the metadata cache allocated.','jstask',2010-02-24 10:04:03.7,'2.0','Reconfiguration',0,'en'

10,0,'Sybase Reconfigure User Connections Template','Reconfigures the "Number of User Connections" if warranted.','jstask',2010-02-24 10:04:04.52,'2.2','Reconfiguration',0,'en'

11,0,'Sybase Update Statistics Template','Updates table or column statistics.','jstask',2010-02-24 10:04:05.43,'3.0','Statistics Management',0,'en'

12,0,'Sybase Server Update Statistics Template','Updates table or index statistics for all\x0auser databases where criteria are met.','jstask',2010-02-24 10:04:06.25,'3.0','Statistics Management',0,'en'

13,0,'Sybase Backup Database to Disk Template','Dumps specified database(s).','jstask',2010-02-24 11:23:49.673,'3.1','Backups',0,'fi'

14,0,'Sybase Backup Transaction Log to Disk Template','Dumps transaction log of the specified database(s).','jstask',2010-02-24 11:23:50.533,'3.1','Backups',0,'fi'

15,0,'Sybase Delete Statistics Template','Deletes table or column statistics.','jstask',2010-02-24 11:23:51.373,'3.0','Statistics Management',0,'fi'

16,0,'Sybase Rebuild Indexes Template','Runs reorg rebuild command on index(es).','jstask',2010-02-24 11:23:52.186,'3.1','Reorganization',0,'fi'

17,0,'Sybase Rebuild Tables Template','Run reorg rebuild command on table(s).','jstask',2010-02-24 11:23:52.99,'3.0','Reorganization',0,'fi'

18,0,'Sybase Reclaim Index Space Template','Runs reorg reclaim space command on index(es).','jstask',2010-02-24 11:23:53.81,'3.1','Reorganization',0,'fi'

19,0,'Sybase Reclaim Table Space Template','Runs the reorg reclaim space command on table(s).','jstask',2010-02-24 11:23:54.616,'3.0','Reorganization',0,'fi'

20,0,'Sybase Reconfigure Locks Template','Resets "Number of Locks" if warranted.','jstask',2010-02-24 11:23:55.416,'2.0','Reconfiguration',0,'fi'

21,0,'Sybase Reconfigure Metadata Cache Template','Reconfigures the metadata cache allocated.','jstask',2010-02-24 11:23:56.223,'2.0','Reconfiguration',0,'fi'

22,0,'Sybase Reconfigure User Connections Template','Reconfigures the "Number of User Connections" if warranted.','jstask',2010-02-24 11:23:57.086,'2.2','Reconfiguration',0,'fi'

23,0,'Sybase Update Statistics Template','Updates table or column statistics.','jstask',2010-02-24 11:23:57.966,'3.0','Statistics Management',0,'fi'

24,0,'Sybase Server Update Statistics Template','Updates table or index statistics for all\x0auser databases where criteria are met.','jstask',2010-02-24 11:23:58.806,'3.0','Statistics Management',0,'fi'



CR:620662
CR Number:   620662
Product Name:   Adaptive Server Generic Docs
Product Component:   Web Services Users Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2012 Added to user documentation
Description
Feature request to more clearly document the cardinality relationships between ASE and Web Services engines. As a consumer, ASE can make requests from any WS defined in sysservers, but as a producer WS can only make requests from the single ASE defined in its properties file.



CR:620677
CR Number:   620677
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 May 2010 Fixed
Description
Procedure sp_spaceusage raises error 247 when run on a table that has more than MAXINT rows.



CR:620769
CR Number:   620769
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2010 Fixed
16 Aug 2011 Workaround
Description
On a Windows 64bit Adaptive Server, a LAST CHANCE EXCEPTION HANDLER on OS thread id caused by an attempted read from an invalid memory address either during LDAP user authentication or with

switch 3635 turned on.



CR:620787
CR Number:   620787
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2012 Bundled Request
Description
DBISQL will return conversion error when select current_bigdatetime from unixASE



CR:620806
CR Number:   620806
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)
10 Aug 2011 Fixed
Description
For INSERT SELECT queries with an ORDER BY clause, the ORDER BY clause may be ignored if the table being inserted into has referential integrity checks.



CR:620992
CR Number:   620992
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)
12 Mar 2010 Fixed
02 Apr 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Under very specific circumstances, delete involving with merge join and using direct update mode an error msg 644 could occur and the delete will fail.
Workaround Description
 dbcc traceon (463) --disable CR 548000, will revert to deferred update



--or



set merge_join off



--or



force the other join order



CR:620994
CR Number:   620994
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 May 2010 Fixed
Description
In Cluster edition, Object creation in local temporary databases is slow when there are multiple objects created parallelly in local temporary databases.



CR:621129
CR Number:   621129
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2010 Fixed
19 Mar 2010 Fixed
08 Apr 2010 One-off Provided
Description
A deadlock may be encountered between a task waiting to get the PLC lock and another task trying to latch on a buffer on Sysobjects when a create table is being done on a database marked for replication.
Workaround Description
 customer cannot work around this issue



CR:621138
CR Number:   621138
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)
03 May 2010 Fixed
03 May 2010 Reservation Made
17 May 2010 Fixed
04 May 2010 Fixed
Description
Under certain circumstances, a stored procedure that references a view can raise error 11060 if the objects are created on a 15.0.3 ESD#2 server and that server is subsequently upgraded to 15.0.3 ESD #3
Workaround Description
 The possible workarounds are:



- Drop and re-create views that appear to cause this error when queried.

OR

- Use traceflag -T15316

OR

- Run dbcc upgrade_object('dbname','view name', 'force')

for the affected view so it is recreated from text and

"old" versions are removed from procedure cache

OR

- Run dbcc markprocs() for the database containing the view

and ensure no old TREEs for the view are in procedure cache by

rebooting the server or removing them explicitly via

dbcc proc_cacherm('V','dbname', 'view name')



CR:621148
CR Number:   621148
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
system function and / or system sproc that gives actives roles for all spids



an administrative function and / or sproc to be able to display the info returned by ...



show_role()

sp_activeroles ... this gives both show_role() and user_defined roles



...for spids other than the current administrator spid.



In other words ... let's say there are 3 active users in the server...spids 12, 17, and 21 The administrator is logged in with isql and has spid ... 17. OK right now this administrator is only able to get show_role() to return the active roles for spid 17. What the customer wants is to show the active roles for spids 12 and 21 also.



CR:621156
CR Number:   621156
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2010 Fixed
Description
Reference to unknown procedure sp_fragmentation in the definition of sp_index_space_est.



CR:621167
CR Number:   621167
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Closed
OS:   Solaris
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2010 Duplicate
Description
OLDSYBASE is not a valid SYBASE path.



CR:621276
CR Number:   621276
Product Name:   Adaptive Server Enterprise
Product Component:   sybinstall
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2010 Fixed
26 Apr 2010 Fixed
Description
sp_sysmon reports Error 969/14/4 against local user tempdbs
Workaround Description
 Use changed code to check for status3 & 256.



CR:621323
CR Number:   621323
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2010 Fixed
Description
Some messages in dataserver logs related to failover need clarification or changes to make the actions of the server clearer.



CR:621326
CR Number:   621326
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)
15 Mar 2010 Fixed
03 May 2010 Fixed
04 May 2010 Fixed
Description
INSERT, DELETE or UPDATE commands executed with minimal logging together

with the chained transaction mode may fail with a timeslice error being

reported in the errorlog showing the module xls_test_set_lrdata and

dbts_commits_addxdes.



CR:621333
CR Number:   621333
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)
26 Mar 2010 Fixed
29 Mar 2010 Fixed
Description
On sunx64 platform, signal context output in sybmon is incorrect.



CR:621445
CR Number:   621445
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 Mar 2010 Duplicate
Description
sp_modifylogin delete minimum password length when this value is not default



CR:621449
CR Number:   621449
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2010 Fixed
28 Mar 2010 Fixed
Description
Enhance Active Messaging to support empty string message properties.
Workaround Description
 Use single space character instead of empty string values.



CR:621466
CR Number:   621466
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
update index statistics tablename partition_name does not update the nonclustered indexes on the partition
Workaround Description
 use update index statistics



CR:621493
CR Number:   621493
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   AIX
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2010 Fixed
Description
"Sample" command in sybmon show incomplete stack info on AIX platform



CR:621615
CR Number:   621615
Product Name:   SCC Web Framework
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   3.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2010 Fixed
Description
Sybase Controll Center to have option to configure the sender address.



CR:621750
CR Number:   621750
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)
31 Mar 2010 Fixed
01 Apr 2010 Fixed
Description
In complex nested views on the inner table of an outer join, in which at least 2 nested views have string expressions or constant expressions, then there is a transformation to allow merging of the views. If the predicate is such that the outer join degenerates into an inner join, the resulting strength reduction assumed the previous transformation would only occur once, when in fact it could be nested and occur twice. The end result is a partially dengenerated outer join that results in an inconsistent state that results in a signal 11.



CR:621762
CR Number:   621762
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)
23 Mar 2010 Fixed
26 Mar 2010 Fixed
Description
Under some rare situations, if a table has expressions as computed columns and the expressions reference different data types, it could return wrong results.



CR:621817
CR Number:   621817
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2010 Fixed
25 Mar 2010 Presently Not Targeted For Any Future Release Of This Product
Description
With the configuration option 'net password encryption reqd' set to 1, the JSagent fails with

"ct_connect() failed", "jsd_MakeConnection() failed", "jsj_AddConxs() failed", "jsj_AddConxs() failed"

and "Initialization failed initializing connection pool" messages in jsagent log file.



CR:621863
CR Number:   621863
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)
26 Jul 2011 Fixed
08 Aug 2011 One-off Provided
26 Jul 2011 Reservation Made
29 Apr 2013 Fixed
21 Jan 2014 Port Not Needed
Description
When a DISTINCT view (or derived table) is queried in a parent DISTINCT query or

is part of an EXISTS join (e.g. under IN/Any subquery),

signal 11 stacktrace could happen in CgpPop::_CgpPePredBmToScalar() for

distinct operator (CgpDistinctHashing/CgpDistinctSorting/CgpDistinctSorted)

when the following three conditions are all true:

1. The DISTINCT view/derived table has at least one expression SELECT column;

2. The parent SELECT DISTINCT columns are only a subset of the DISTINCT view columns.

Or if the EXISTS join is on one of the DISTINCT view columns;

3. One of DISTINCT view columns which is not part of 2) has a predicate on it

in the parent query block.
Workaround Description
 set opportunistic_distinct_view off (only applicable to the customer repros which

are not hitting the bug using the EXISTS subquery. The RQG version can't use the workaround).



CR:621978
CR Number:   621978
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)
12 Mar 2010 Fixed
26 Apr 2010 One-off Provided
26 Apr 2010 One-off Provided
Description
In rare circumstances, a 707 error with state 10 "System error detected

during attempt to free memory at address 0x<address>. Please consult the

ASE error log for more details." may be reported for an ASE that uses

a procedure cache whose size combined with the size of the statement cache

exceed the value of 4G-bytes.
Workaround Description
 Reduce the size of procedure cache and statement cache, so the sum is less than 4 Gb. If dynamically increasing the caches, increment in less than 4GB at a time.



CR:621996
CR Number:   621996
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
stacktrace starts with CgEvals::_CgCompVcol when plan use hash join.
Workaround Description
 set advanced_aggregation off



Note that this problem should be specific to the allrows_dss optgoal.



CR:622001
CR Number:   622001
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)
01 Jun 2010 Fixed
Description
Traceflag 3710 enables an enhancement to improve the performance of DROP INDEX and CREATE INDEX by releasing the system catalog locks when not in DDL-IN-TRAN mode after the commit

of the transaction but before post commit work started. This CR is a feature request to make this default behavior and retire the traceflag.



CR:622066
CR Number:   622066
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2010 Not a Bug
Description
Upgrade from ASE1503CE to ASE15.5CE will show in-memory stats for user objects are showing 0 rows/pages unless reboot
Workaround Description
 Reboot the cluster



CR:622088
CR Number:   622088
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2010 Fixed
07 Nov 2011 Fixed
Description
monOpenObjectActivity.RowsInserted is wrongly updated even when the INSERT command gets aborted.



CR:622090
CR Number:   622090
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   HP-UX
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2010 Fixed
Description
ASEPlugin attempts to access local tempdb for another node than the one the user logs into.



CR:622114
CR Number:   622114
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)
23 Mar 2010 Fixed
23 Mar 2010 Reservation Made
30 Mar 2010 Fixed
Description
In some situation, if compatibility mode is on, computed column is not getting the correct values from an identity column.



CR:622123
CR Number:   622123
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)
25 Mar 2010 Fixed
20 Jul 2010 Fixed
Description
In rare cases, the recovery of a prepared multi-database transaction that started in the master database and that had a transaction branch on a remote Adaptive Server, might result in an inconsistent completion state between the branches of the transaction.



CR:622150
CR Number:   622150
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)
08 Apr 2010 Fixed
09 Apr 2010 Fixed
Description
A statement may fail to compile in deferred mode (and will successfully compile in

normal mode) when it references a view and there is another view of the same name

under the user executing the procedure.

With 'set showplan on', you will see:-



QUERY PLAN IS RECOMPILED DUE TO DEFERRED_COMPILE_FAIL, TABMISSING.

THE RECOMPILED QUERY PLAN IS:
Workaround Description
 Turn off deferred compilation.



sp_configure 'procedure deferred compilation', 0 --(for 15.0.3 ESD#1 and higher)



--or



Traceflag 7730



CR:622151
CR Number:   622151
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)
12 Apr 2010 Fixed
12 Apr 2010 Fixed
Description
An additional line of client-side output with respect to 'rows affected' may be seen

in circumstances where the procedure has been recompiled due to a deferred compilation

failure.



For example:-



1> exec p1

2> go

(1 row affected)

c1

-----------



(0 rows affected)

(return status = 0)

1>



Instead of:-





1> exec p1

2> go

c1

-----------



(0 rows affected)

(return status = 0)

1>
Workaround Description
 set nocount on

<preceding queries to the failed DC statement>

set nocount off



CR:622339
CR Number:   622339
Product Name:   ASE Management
Product Component:   Web Console
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2010 Fixed
28 Jun 2010 Fixed
Description
In ASEMAP 3.1, on both SMP and SDC screens for ASE monitoring, if user switches database selection in the database table while the bottom tabs are in their default order, the 'Selected database:' will show the correct name of the database. However, if user is on another tab (not the Details tab) and switches the database selection, the 'Selected database:' does not get updated. This issue is fixed in ASEMAP 3.2.1.



CR:622350
CR Number:   622350
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)
18 Mar 2010 Fixed
19 Mar 2010 Fixed
24 Mar 2010 Fixed
Description
The execution of a stored procedure that in turn calls a cross database udf may result

in permission error 10351 if the caller of the stored procedure is not the owner of the

udf.
Workaround Description
 Add the owner of UDF and the sproc to database via sp_adduser



CR:622415
CR Number:   622415
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2010 Fixed
Description
If a table has a trigger defined and 'statement cache' and 'literal autoparam' are enabled, it could cause a problem if a error is detected when processing the trigger.



CR:622433
CR Number:   622433
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2010 Bundled Request
Description
Stored proc sp_jdbc_getxacoordinator is not cluster aware (returns Error 512)



CR:622492
CR Number:   622492
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
When a procedure is created containing a 'select *' from a table which joins a

derived table, the expanded derived table columns may be placed within the derived table

definition as oppose to the outer query.

This could lead to an error 107 when re-creating the procedure from the text stored in

syscomments



CR:622499
CR Number:   622499
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)
22 Oct 2010 Fixed
22 Oct 2010 Fixed
Description
Deadlock IDs not correctly inserted into monDeadLock, they are always zero.



CR:622528
CR Number:   622528
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)
26 Oct 2011 Duplicate
Description
On ASE 15.x a Correlated subquery on a proxy table may run much less efficiently than on previous versions.
Workaround Description
 -- Fetch proxy table data into local temp table thus:

select colInt into #proxyTab

from proxyTab

where colInt <= (select max(colInt) from localTab)

and colInt >= (select min(colInt) from localTab)



select count(*) from localTab

where colInt not in (select colInt from #proxyTab)



drop table #proxyTab

go



CR:622538
CR Number:   622538
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)
11 Jan 2012 Fixed
15 Nov 2011 One-off Provided
29 Jan 2012 One-off Provided
06 Sep 2012 One-off Provided
02 Nov 2012 Fixed
Description
In rare circumstances, a 12323 error may be raised when running REORG REBUILD on nonclustered index of a DATA_ONLY LOCKED table.
Workaround Description
 dbcc traceon (12604) --disable suffix compression on create index



CR:622590
CR Number:   622590
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)
12 Jul 2010 Fixed
Description
sp_monitorconfig reports inconsistent info if 'procedure cache size' is reduced.
Workaround Description
 Only reduce procedure cache size before reboot the ASE.



CR:622595
CR Number:   622595
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)
23 Mar 2010 Fixed
23 Mar 2010 Fixed
25 Mar 2010 Fixed
25 Feb 2011 One-off Provided
Description
Wrong outerjoin result may happen for a query with

an outerjoin between a GROUP BY view/derived table and other table

when there is a constant sarg in the view for the equality joining

column. Null-supplied rows from the outerjoin may be incorrectly

eliminated.
Workaround Description
 Use tracecommandline flag 15313. This flag backs out the fix done

in 575251 which was also a wrong results problem so great care should

be taken if applying TCF 15313. Please see CR 575251 for details of

that problem. I believe that 575251 has existed since the GA release

so many users have been exposed to problem but never seen it. The problem

in 575251 could be exposed by queries requiring ordering.



CR:622717
CR Number:   622717
Product Name:   Adaptive Server Generic Docs
Product Component:   Encrypted Columns Users Guide
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2010 Added to user documentation
Description
The example for ALTER TABLE DECRYPT in chapter 9 of the 15.0.2 User Guide for Encrypted Columns is missing the keyword "modify". It should read "alter table stolen_ccards modify ccard decrypt "



CR:622722
CR Number:   622722
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2010 Fixed
Description
In SDC, error 2601 is seen when insert large number of identity values into table

with unique index. Trace flag 16842 can be used to track the SQL that caused the

2601 error.



CR:622771
CR Number:   622771
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)
03 May 2010 Fixed
03 May 2010 Reservation Made
Description
Error message: ks_falloc: Cannot allocate using ubfalloc(rnetmempool, 2097152)

is reported in errorlog and login failures prevent additional user connections.



CR:622787
CR Number:   622787
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2010 Duplicate
Description
ASEPlugin doesn't display 'trunc log on chkpt' and 'select into/bulkcopy/pllsort' databases
Workaround Description
 Remove 'trunc log on chkpt' and 'select into/bulkcopy/pllsort' from all databases including system databases.



CR:622883
CR Number:   622883
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 Mar 2010 Fixed
30 Mar 2010 Reservation Made
31 Mar 2010 Fixed
31 Mar 2010 Fixed
Description
In rare situation, "dbcc lockgc" might run into errors related to spinlock



CR:623103
CR Number:   623103
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)
22 Mar 2010 Workaround
Description
A simple join with order by completes in miliseconds. Use another column, and it never completes, filling a 3 gig tempdb. Changing the join order does not help unless you use "set forceplan on".
Workaround Description
 forceplan and different join order



CR:623139
CR Number:   623139
Product Name:   Adaptive Server Generic Docs
Product Component:   Transact-SQL Users Guide
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2010 Added to user documentation
Description
Doc bug: We should tell about predicate evaluation order.

There is no guarantee to evaluate and execute predicates in left-to-right order.

For example, if you run a query having "WHERE x != 0 AND y = 10 OR z = 100", Adaptive Server does not guarantee to evaluate and execute "x != 0" first.

Adaptive Server can evaluate and execute predicates in any order.



CR:623166
CR Number:   623166
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2010 Fixed
29 Mar 2010 One-off Provided
23 Apr 2010 One-off Provided
30 Apr 2010 One-off Provided
26 May 2010 Fixed
Description
Under certain circumstance, long lock hash chain(s) might contribute to 100% CPU or performance slowdown



CR:623274
CR Number:   623274
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)
02 Apr 2010 Fixed
02 Apr 2010 Fixed
Description
If a hash-join has a buildset/probeset key pairing of

{BINARY/VARBINARY} or a key pairing of {BINARY(length M)/BINARY(length N)}

and the binary values differ only by the number of trailing 0s, then these

rows won't be returned.
Workaround Description
 set hash_join off or customer can choose other optgoals like allrows_mix or allrows_oltp.



CR:623284
CR Number:   623284
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)
23 Apr 2010 Fixed
Description
Integrates with new Certicom and OpenSSL security libraries that tackle SSL renegotiation vulnerability described in RFC5746.



CR:623307
CR Number:   623307
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2010 Fixed
08 Apr 2010 One-off Provided
30 Apr 2010 Fixed
25 Jun 2010 Presently Not Targeted For Any Future Release Of This Product
02 Jun 2010 One-off Provided
Description
In rare circumstances, a 692 error "Uninitialized logical page '<value>' was read

while accessing ... object 'syslogs' (8) ..." together with a stack trace which

includes the modules 'rep_agent_thread' and 'xsc__syslogs_getnext' and 'wrongpage'

may be reported in the error log by the Adaptive Server Replication Agent task.



CR:623316
CR Number:   623316
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)
29 Mar 2010 Fixed
Description
Comparing bigdatetime values under a parallel plan may cause error 9566, "worker process plan copy error" to be raised.



CR:623349
CR Number:   623349
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2010 Fixed
Description
Concurrent DML for APL table on different node may cause server hang. ASE may absort the suspect transaction.



CR:623357
CR Number:   623357
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2010 Fixed
Description
BS doesn't use directio or dsync i/o mode as configured for database devices on linuxia32 platform



CR:623402
CR Number:   623402
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2010 Fixed
02 Apr 2010 Fixed
Description
Under certain circumstances using daylight saving can cause historical server to generate incorrect date/times.
Workaround Description
 N/A



CR:623412
CR Number:   623412
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2010 Fixed
Description
The message "process infected with signal 11" in the module 'txtimg_get_datarow' may be

reported together with a stack trace which include the module 'writetext' when executing

the command 'WRITETEXT WITH LOG' on a replicated text column which does not have an index for replication.



CR:623444
CR Number:   623444
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 Apr 2010 Consult Complete
Description
delrowcnt incorrect even after we run update stats/sp_flush when we delete rows



CR:623569
CR Number:   623569
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)
16 Oct 2013 Duplicate
Description
CIS update on text field (which is documented as not allowed) corrupts remote data rather than giving an error



CR:623591
CR Number:   623591
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2011 Fixed
23 Mar 2011 Fixed
Description
Error 691, "Encountered invalid logical page <pgid> while accessing database <dbname>, object <objname>, index <idxname>, partition <ptnname>. This is an internal system error. Please contact Sybase Technical Support.", will be raised when running WRITETEXT statement on a text page chain of a replicated table after rebuilding this text page chain using DBCC REBUILD_TEXT with the first text page number specified.



CR:623613
CR Number:   623613
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The installdbccdb script raises error 911 if the dbccalt database does not exist.



CR:623658
CR Number:   623658
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)
03 Sep 2010 Fixed
03 Sep 2010 Reservation Made
Description
When literal autoparam is enabled, sometimes query with builtin function hash() and hashbytes() could raise parser error 11793.



CR:623669
CR Number:   623669
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)
01 Apr 2010 Not a Bug
Description
Not a bug.



CR:623697
CR Number:   623697
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   HP-UX
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2010 Fixed
26 Mar 2010 Fixed
Description
ASE doesn't passes directio or dsync i/o as configured for database devices on HP platform



CR:623776
CR Number:   623776
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)
29 Mar 2010 Fixed
29 Mar 2010 One-off Provided
30 Mar 2010 One-off Provided
16 Apr 2010 One-off Provided
One-off 30 Apr 2010 One-off Provided
Description
Do not acquire cluster-wide distributed locks for objects which belong to node-specific databases like local user tempdbs.



CR:623777
CR Number:   623777
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2010 Added to user documentation
03 May 2010 Added to user documentation
29 Apr 2010 Fixed
Description
Document enhancement to add a note under the REORG command that ""REORG has no effect on space allocated to TEXT or IMAGE columns"



CR:623780
CR Number:   623780
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
Include the function name in error 14217 text "SQL function not found. If you are attempting to call a java UDF, Java services are not enabled."



CR:623788
CR Number:   623788
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2010 Fixed
18 May 2010 Fixed
Description
ASE can't start Job Scheduler on IPV6 enabled AIX server for specific ipv4 addresses



CR:623833
CR Number:   623833
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 Mar 2010 Fixed
28 Apr 2010 Fixed
28 Apr 2010 Fixed
23 Apr 2010 Fixed
14 Apr 2010 Fixed
Description
A 6909 error, "The timestamp (<timestamp>) of the transaction that started at date (<date>) in database '<dbname>' (database id '<dbid>') is earlier than the timestamp (<timestamp>) of the most recently started transaction." may sometimes be reported when the log records of a transaction running in chained mode is flushed from its user log cache by another concurrent session.



CR:623902
CR Number:   623902
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2010 Fixed
29 Mar 2010 Fixed
10 Jan 2011 Consult Complete
07 Jun 2010 Consult Complete
01 Jun 2010 Fixed
04 Jun 2010 One-off Provided
12 Jul 2010 Fixed
19 Jul 2010 Bundled Request
19 Jul 2010 Bundled Request
15 Jul 2010 Fixed
15 Jul 2010 Fixed
Description
For local tempdb, more resources maybe consumed for the applications using local tempdb than it is needed



CR:623912
CR Number:   623912
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2010 Fixed
09 Aug 2010 Fixed
14 Oct 2010 Fixed
07 Dec 2010 Fixed
01 Jul 2010 Reservation Made
22 Dec 2010 Presently Not Targeted For Any Future Release Of This Product
15 Oct 2010 Fixed
15 Oct 2010 Fixed
22 Dec 2010 Consult Complete
22 Dec 2010 Consult Complete
Description
Implementation of insert/select text value into the compressed LOB columns from constant.



CR:624017
CR Number:   624017
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)
16 Apr 2010 Fixed
Description
When RepAgent is configured to use a trace file, trace flags 9200 and 9215 are set and the parameter 'bind to engine' is not set, memory heap corruptions can occur and lead to unpredictable errors in ASE.
Workaround Description
 One of the following workarounds may be applied:

1) Bind the RepAgent thread to an engine by setting the RepAgent configuration

parameter 'bind to engine'.

2) Instead of configuring a trace file for RepAgent, the traces may be logged in ASE error log by setting the trace flag 3623.



CR:624043
CR Number:   624043
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2010 Fixed
28 Oct 2010 Fixed
Description
A 12319 error, "Fatal internal error encountered during deferred dml on table '<value>'

in database '<value>'. All rows that qualified during the first phase were not visited

during second phase of dml." may be reported in the error log together with a stack trace

which includes the modules 'dodeferred' and 'dol_def_update' if an UPDATE command has

been previously run against a data-only-locked table.



CR:624050
CR Number:   624050
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2010 Bundled Request
Description
DBISQL's window title now includes both the login and user name in the following format: "server_name (login_name) / database_name (user_name)". Previously the format was: "server_name (user_name)".



CR:624084
CR Number:   624084
Product Name:   Adaptive Server Generic Docs
Product Component:   To Be Determined
Status:   Closed
OS:   NA
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Much description of regedt32.exe is included in the manual of ASE15.5. but regedt32.exe was replaced to regedit.exe. Please use regedit.exe, in using WindowsXP or later.



CR:624086
CR Number:   624086
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)
14 Apr 2010 Fixed
07 Apr 2010 Fixed
Description
The NETWORK HANDLER gets a timeslice error and the stack trace contains pss_init().
Target Version
 Not To Be Released
Workaround Description
 reduce 'permission cache entries'



CR:624114
CR Number:   624114
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)
01 Apr 2010 Fixed
01 Apr 2010 Fixed
Description
In a complex predicate involving ORs in which it may qualify for a "row constuctor" transformation as defined by SQL semantics, if there is a IS NOT NULL or a IS NULL predicate, along with other inequalities, then there is a possibility of a stack trace.



CR:624187
CR Number:   624187
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)
01 Apr 2010 Fixed
05 Apr 2010 Fixed
Description
Under specific circumstances during the close cursor of a query involving more than 128 hash distinct operators, an Error: 706, Severity: 20, State: 2 may be seen and the spid terminated - it may also manifest iself as signal 11 in rm_prochdr() if the cursor is non-procedural.
Workaround Description
 set compatibility_mode on



CR:624215
CR Number:   624215
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)
15 Apr 2010 Bundled Request
Description
Connect Dialog's recently connected servers do not load updated host/port information when the corresponding server entries in the interfaces file have been updated.



CR:624218
CR Number:   624218
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2010 Fixed
22 Apr 2010 Fixed
Description
In rare circumstances, timeslice error might be reported when running query on monProcessProcedures.



CR:624245
CR Number:   624245
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2010 Fixed
14 Jun 2010 Fixed
Description
The Backup Server error message indicates that there is RPC parameter count mismatch between ASE 15.5 and Backup Server 15.0.3.

The message needs enhancement to prompt user to verify Backup Server version compatibility with ASE.



Backup Server error message:

Backup Server: 3.31.2.3: Improper parameter count 6 for RPC bs_begin_load;

expected a minimum of 3 parameters and a maximum of '5' parameters.



The ASE stack trace gives the impression that the problem is complicated. The simple solution is to use the newer version of the Backup Server.



CR:624536
CR Number:   624536
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
CIS delete on a non-empty proxy table when involve a join with local table fail
Workaround Description
 Workaround of using default tablespace is not acceptable for the customer, as he may want to use other tablespace for his login user.



CR:624565
CR Number:   624565
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)
10 May 2010 Fixed
25 Sep 2010 Fixed
Description
Stored procedure "sp_poolconfig" will fail with return status =1 when configuring/updating cache pools and auditing is enabled.
Workaround Description
 Disable auditing.



CR:624566
CR Number:   624566
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2010 Presently Not Targeted For Any Future Release Of This Product
08 Apr 2010 Fixed
10 Apr 2010 Fixed
29 Jun 2010 One-off Provided
Description
Under very rare circumstances, for caches using the clock replacement

policy, the instance level physical lock on a page may be released

without ensuring all local users of the page have finished working on it.

Subsequently, the Adaptive Server Cluster Edition will report the

following 892 error:

"Process <spid> is holding a latch on buffer <buffer-address>

(dbid: <dbid>, pageno: <pageno>) without holding a physical

lock on the buffer".



CR:624575
CR Number:   624575
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
Require the partitioned information of tables saved in errorlog during upgrading from 12.x to 15.x



CR:624724
CR Number:   624724
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2010 Added to user documentation
29 Apr 2010 Fixed
26 Apr 2010 Added to user documentation
Description
SET options "literal autoparam" and "statement_cache" are on by default but only have any effect if the corresponding server-level setting is configured on. They are used to allow the session to opt-out of using the feature.



CR:624734
CR Number:   624734
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 Apr 2010 Fixed
Description
sp_configure returns no output when sort order is set to case insensitive.



CR:624777
CR Number:   624777
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2012 Bundled Request
Description
New feature: grantable privilege MANAGE ANY THREAD POOL introduced for create/alter/drop thread pool commands.



CR:624835
CR Number:   624835
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 May 2010 Fixed
10 May 2010 Reservation Made
15 May 2010 Fixed
Description
Correlated predicates are not recognized as search arguments for purposes of constant attribute optimizations so a query like

select * from t1 where t1.a1 = (select max(b2) from t2 where b2 <= 10 and a1=b1)

should behave the same w.r.t. subquery index selection on an index on t2(b1 asc, b2 desc) as

select * from t1 where t1.a1 = (select max(b2) from t2 where b2 <= 10 and 5 =b1)



CR:624853
CR Number:   624853
Product Name:   Adaptive Server Generic Docs
Product Component:   XA Guide for CICS Encina and Tuxedo
Status:   Closed
OS:   Unknown
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Apr 2010 Added to user documentation
Description
The definition of sp_passthru procedure of ASE15.5 CIS Users Guide is not correct.

The definition of the @server parameter of ASE15 to sp_passthru procedure was extended to

varchar (255). And the errmsg parameter was also extended to varchar (1024).



CR:624870
CR Number:   624870
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   Unknown
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Dec 2013 Added to user documentation
Description
The operation procedure of Sybase Central included in an ASE15.5 administrator guide is an old version.



CR:624873
CR Number:   624873
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   Unknown
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2010 Added to user documentation
Description
DTM and Java are not option licenses any longer. But the "Note" for the option still exist in Sys Admin Guide 15.5.



CR:624879
CR Number:   624879
Product Name:   Adaptive Server Generic Docs
Product Component:   Utility Guide
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Apr 2010 Fixed
Description
The example of SQL is not written to Example7 of isql of an ASE15.5 utility guide.





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