远程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:567820
CR Number:   567820
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
(Internal only) Test environment issue.



CR:567885
CR Number:   567885
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2009 Fixed
Description
Fully qualified ASE table names in a query cause an exception when using DBISQL's Query Editor.



CR:567909
CR Number:   567909
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR Dbcc command to delete object from system tables.



CR:567910
CR Number:   567910
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2009 Fixed
Description
Due to the addition of two new columns in monDeadLock in 15.0.2 the length of a

particular sql statement has increased to be in excess of the previous limit of 1024

chars in sp_monitor_deadlock. (The columns are replaced with dummies in 12.5.4)
Workaround Description
 Re-create the sp_monitor_deadlock procedure with an increased data type length for the @sqlstmt variable declaration.



create procedure sp_monitor_deadlock(

@arg1 varchar(30) = NULL

, @arg2 varchar(30) = NULL

, @arg3 varchar(30) = NULL

) as

begin

-- declare @sqlstmt varchar(1024)

declare @sqlstmt varchar(1500)



...

...



CR:567911
CR Number:   567911
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2009 Duplicate
24 Feb 2010 Fixed
Description
Feature request to support using sybmigrate from ASE 12.5.x using non-utf8 charset to ASE using utf8 charset.
Workaround Description
 Possibly using BCP to transfer data after setup.

Change source database to utf8 before sybmigrate or

target ASE to utf8 after sybmigrate.



CR:567916
CR Number:   567916
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 3710 can be missleading

Cannot use DROP with 'test_c1_427145536' because 'test_c1_427145536' is a

constraint. Use ALTER TABLE.

But the command you do is drop default test_c1_427145536 and the message is because

you try to drop a created by declaration default.
Workaround Description
 // Drop this defaults from the systemtables.



CR:567924
CR Number:   567924
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2009 Workaround
Description
Queries containing joins of several complex views may fail with Signal 11 or Access Violation and stack trace in vu_pd_validresdom().
Workaround Description
 Cst found work-around of re-writing query such that it does NOT need more than 14 work-tables.



Break the query into select into #temp_table and join with that. Eg:

SELECT * INTO #GL_Mapping

FROM VW_TW_GL_Mapping

WHERE VW_TW_GL_Mapping.GL_Name is not null



SELECT

1

FROM

VW_TW_Instrument

, VW_TW_GL_Balance

, #GL_Mapping

WHERE

VW_TW_GL_Balance.INSTRUMENTIDNUM=VW_TW_Instrument.INSTRUMENTIDNUM

AND VW_TW_GL_Balance.GLACCTNBR = #GL_Mapping.GLACCTNBR

AND #GL_Mapping.SUBINSTRTYPEID=VW_TW_GL_Balance.SUBINSTRTYPEID



CR:567959
CR Number:   567959
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2009 Fixed
Description
ASE Cluster Edition with two or more instances may crash an instance with the message "current process infected with Signal 11" reported in errorlog containing 'cmcc__pri_bcmt_proc' in the stacktrace.

.



CR:567961
CR Number:   567961
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
when customer upgraded from ASE 12.5.4 to ASE 15.x using dump and load ... since

all the binding information is stored in the sysattributes table in masster

database related to Multiple temporary databases ... those bindings are missing

for all their logins in the upgraded server.



So now this customer has to recreate all the bindings done with sp_tempdb in the

past again now from scratch.



The customer wants the feature of using dump and load to upgrade their database

versions and have all the binding information related to Multiple temporary

databases for all the logins to be present in the upgraded server.



maybe the feature would be

1) to relocate the binding info to some table other then sysattributes

2) create a stored procedure or instructions to migrate the Multiple

temporary database binding info from the older server to the

newer server.



CR:567968
CR Number:   567968
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2009 Fixed
14 Jan 2010 Fixed
10 Feb 2010 One-off Provided
Description
Online database hits error 3905 while undoing a split log record on an APL table with clustered index.



CR:568036
CR Number:   568036
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2009 Fixed
23 Apr 2009 Reservation Made
23 Apr 2009 Fixed
Description
In rare circumstances , in multi-instance cluster environment when upgrade of a database

is done on one of the instances, error 968(upgrade in progress) may be reported in the

errorlog while using database on another instance in the cluster.



CR:568088
CR Number:   568088
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
8242 severity 16 state 2: "The table '%S_OBJID' in database '%S_DBID' is bound to metadata cache memory. Unbind the table and retry the query later.



To resolve this error, ensure that all users are out of the database, or reboot ASE and run:

dbcc tune(des_unbind)



CR:568246
CR Number:   568246
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request: Customer request that order-by be allowed in a "for update" cursor.



CR:568255
CR Number:   568255
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2010 Added to user documentation
Description
Changing Lock Scheme to DOL May Impact Query Plan



customer changed locking scheme from APL to DOL and now the optimizer fails to choose the most ideal query plan. the customer had to execute ... 'update index statistics' ...

before the optimizer would succeed again in selecting the most ideal query plan.



WARNING! Changing the locking scheme on a table can cause the optimizer to alter its costing estimates for accesses to the table. The impact of changing the locking scheme should always be tested in a non-production environment before deployment to production.



Given that the clustered index on an APL table is a very direct

mechanism to access the data AND that there are Search Arguments

on all three columns of the clustered index, ASE most likely

bases its decided upon join order around a clustered index scan

of matter_participant.



Given that clustered indexes on DOL tables are not as strong as

they are on APL tables ASE ends up selecting a non-optimal index.



Update Index Stats ... 'update index statistics' ... after this

is executed ... ASE will then have histograms on additional

columns and then ASE is better equiped to select the correct

join order and query plan.



Conclusion:

the conclusion here is that changing locking schemes is not

directly tied to the need to run 'update index statistics',

rather, the additional histograms created by 'update index

statistics' will, in some circumstances, be required in order

for the ASE 12.5.x optimizer to select the most ideal query

plan.



CR:568259
CR Number:   568259
Product Name:   Adaptive Server Enterprise
Product Component:   Pluggable_JVM
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2009 Fixed
22 Apr 2009 Fixed
21 Apr 2009 Not reproducible with latest version of the product available as of Resolution Date
12 May 2009 Fixed
Description
Due to a defect under AIX 5.3 ML7, PROCESS_SHARED locks and conditions

pose server hangs when multiple ASE engines are in effect. This problem

is filed at IBM under PMR 51261,756,000.



A workaround for those server hangs PCI Bridge Virtual access approaches

are disabled under IBM AIX 5.3 ML7, making it the default server behavior.

This despite an understood performance loss.



IBM AIX servers can be booted with traceflag -T9403 allowing them for full

PCI Bridge access mode. Doing this, such poses strong risk to server hangs,

but won't cause performance loss on operations.



CR:568357
CR Number:   568357
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Windows
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2009 Fixed
23 Apr 2009 Fixed
Description
User selects "specified license key" option, but the specified license does not take effect and installer license validation can not pass.



CR:568425
CR Number:   568425
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2009 Fixed
Description
Support sp_configure 'nondefault' in SDC.



CR:568427
CR Number:   568427
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2009 Fixed
Description
In sp_configure, for cluster-wide settings, display 'cluster-wide' instead of 'NULL'

in instancename.



CR:568430
CR Number:   568430
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2009 Fixed
Description
In rare circumstances, in a ASE CE server, timeslice error could be reported in the errorlog.

The stack trace could contain strings like "hk_chores_proc", and "bufwritedes_log_all".



CR:568449
CR Number:   568449
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2009 Fixed
16 Apr 2009 Fixed
16 Apr 2009 Fixed
17 Aug 2009 Not a Bug
Description
On IBM AIX platform, ASE will not give complete stack trace when any ASE task hits timeslice error.



CR:568458
CR Number:   568458
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)
19 May 2009 Fixed
19 May 2009 Fixed
28 May 2009 Fixed
22 May 2009 Fixed
09 Jun 2009 Fixed
21 May 2009 Fixed
29 May 2009 Fixed
Description
ASE generates an infected with 11 stacktrace in the errorlog containing the function rvm_has_decrypt_perm when a cursor accesses an encrypted column on which a decrypt_default has been declared.



CR:568554
CR Number:   568554
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2010 Fixed
Description
In some circumstances, when attempting to login to the server and the server runs out of locks, a 1204 error may be raised and a signal 11 may be reported in the errorlog followed by a stacktrace involving the module 'lock_logical'.



CR:568615
CR Number:   568615
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2009 Fixed
15 Jan 2014 Presently Not Targeted For Any Future Release Of This Product
21 Jul 2009 Fixed
Description
Too many primary BCM requeues causing 100% CPU usage.



CR:568659
CR Number:   568659
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2009 Fixed
Description
Under rare conditions a query on the monOpenObjectActivity MDA table may result in a timeslice error.



CR:568753
CR Number:   568753
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2009 Fixed
07 Jul 2009 Duplicate
Description
Adaptive Server might boot with some cases of wrong cache configuration in config file resulting in cache creation with incorrect configuration.



CR:568763
CR Number:   568763
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 107 is raised when a 102 syntax error would be more appropriate for unmatched parenthesis in the select clause. Example: select substring(sysobjects.name,1,2)) from sysobjects
Workaround Description
 don't write syntax error.



CR:568798
CR Number:   568798
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2009 Fixed
16 Jun 2009 Fixed
24 Jun 2009 Fixed
Description
Under some circumstances, a signal 4 may be raised while calling ex_raise and ex_print.



CR:568811
CR Number:   568811
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2009 Fixed
02 Oct 2009 Fixed
11 Mar 2010 One-off Provided
Description
In an ASE cluster, when Rep Agent is running on one node on a given database,

and clients modify data in that database from the same node or from remote nodes,

Rep Agent may replicate some data with a delay.
Workaround Description
 None.



CR:568939
CR Number:   568939
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2009 Fixed
Description
After loading database dump of version 1501 into pyxis server, the datatype of 4 columns of system

table "systabstats" have the wrong data types.

ColName expected dtype actual dtype

pioclmdata real int

pioclmindex real int

piocsmdata real int

piocsmindex real int



CR:568957
CR Number:   568957
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)
02 Sep 2009 Fixed
02 Oct 2009 Fixed
02 Sep 2009 Reservation Made
Description
"ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An

illegal token was received" may result when accessing data

containing null bytes on an ASE server when character set

conversion using Unilib is employed.
Workaround Description
 sp_configure 'enable unicode conversion', 0



--this will force built-in conversion, which is not available, so no conversion will take

--place.



CR:568980
CR Number:   568980
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2009 Duplicate
Description
instmstr is terminated by ASE when it causes an exception in modules such as

destroyRemoteAccess and VTABRemoteAccess::`scalar deleting destructor'
Workaround Description
 They worked around the issue by enabling and altering the 'Monitoring' section

of their configuration file:

[Monitoring]

enable monitoring = 1

sql text pipe active = 1

sql text pipe max messages = 1000

plan text pipe active = 1

plan text pipe max messages = 1000

statement pipe active = 1

statement pipe max messages = 25000

errorlog pipe active = 1

errorlog pipe max messages = 1000

deadlock pipe active = 1

deadlock pipe max messages = 100

wait event timing = 1

process wait events = 1

object lockwait timing = 1

SQL batch capture = 1

statement statistics active = 1

per object statistics active = 1

max SQL text monitored = 2048



CR:568983
CR Number:   568983
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2009 Not a Bug
Description
update of a view on a proxy table with text/image data fails with error 7732
Workaround Description
 According to CR 371323 the index may be required:

=====================================================================================

CIS: When a proxy table is updated via ct_dynamic in a client application, error 7732

may occur indicating that the cursor is READONLY.



With this change, remote tables may need to be created with a unique index for table

scans on updatable cursor.

=====================================================================================



So we tried the following and it worked but customer is unable to use it due to their

business requirements:

create unique clustered index i1 on text_test (id)

go



CR:568997
CR Number:   568997
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   Windows XP
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In an XML model, adding a new item to a sequence via right-click\new will reformat the displayed hierarchy of the sequence. Thus losing all the diagram formatting.



Workaround:

Select the desired object in the tool palette and add it to sequence. The object is added at the end of the hierarchy



CR:569001
CR Number:   569001
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request: a supported way to rename a local index partition such that its name matches to the name of the underlying data partition.



CR:569005
CR Number:   569005
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)
06 Jan 2010 Fixed
12 Jun 2010 Fixed
Description
Upgrade may fail with a 2601 error on sysusers while trying to add system role 'dtm_tm_role'. A workaround is to remove DTM_TM_ROLE, HA_ROLE, MON_ROLE, MESSAGING_ROLE, JS_ADMIN_ROLE from sysusers and sysroles in the database on the original ASE version and retry the upgrade.
Workaround Description
 Remove the entries for DTM_TM_ROLE, HA_ROLE, MON_ROLE, MESSAGING_ROLE, JS_ADMIN_ROLE from sysusers & sysroles on the user database.



This is best done prior on the original source before taking a new database dump.

if this is not possible (e.g.: production environment) :

- either dump/load the DB in another ASE server of the same version and remove the roles manually

- On the target ASE 15 server : use traceflag 990 in order to gain access to the database as 'sa' (bypassing recovery and upgrade) and remove the roles.

You can then issue an online database, and it should perform the upgrade successfully.



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



(Update 8/31/2010 ningzhen):

A sample sql scripts to delete the system roles in the target 15 ASE after upgrade database db1 fails with 2601 error:

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

dbcc traceon(990)

go

sp_configure 'allow updates to system table',1

go

use db1

go



begin tran

go

delete from sysroles

where exists (select * from sysusers where uid=sysroles.lrid and

name in ('dtm_tm_role', 'ha_role', 'mon_role', 'messaging_role', 'js_admin_role'))

go



delete

from sysusers

where name in ('dtm_tm_role', 'ha_role', 'mon_role', 'messaging_role','js_admin_role')

go



commit tran

go

sp_configure 'allow updates to system table',0

go

dbcc traceoff(990)

go

online database db1

go



CR:569011
CR Number:   569011
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE 12.5.4 RA sends different LTL between bcp and isql for nullable text column and replicate_if_changed. ASE 15.x sends same LTL. Want to know when this was changed and what is the long-term direction.



CR:569169
CR Number:   569169
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2009 DEFER
28 Jul 2009 Fixed
Description
In ASE Cluster Edition, a process inserting a row in a DOL table could get blocked indefinitely on a RANGE lock which is held by itself.



CR:569171
CR Number:   569171
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)
08 May 2009 Fixed
Description
A stack trace in the function, setGlobalIdentity, may be generated when an INSERT query is

run and this query inserts into a proxy table that is created on a remote view and the

remote view is created on a table that contains an identity column and the datatype of the

identity column is not NUMERIC (i.e. it could be integer or smallint) and the remote view

has an instead-of trigger for insert and the instead-of trigger contains a query that

selects the identity column from the inserted pseudo table.



CR:569332
CR Number:   569332
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)
30 Jun 2009 Fixed
29 Jun 2009 Reservation Made
13 Jul 2009 Fixed
14 Jul 2009 One-off Provided
Description
Servers with many database entries in sysdatabases may fail to upgrade to 15.x with errors 3461 and

3452 regarding failure of upgrade steps 21 and 1501.
Workaround Description
 The problem seems to be with the size of sysdatabases. The problem has been worked around in several cases by:

1) dumping master (not necessary to the workaround, but you want to know you have a good dump)

2) create a table in master with the same format as sysdatabases and insert into it all the rows from sysdatabases

3) delete all the rows for user databases from sysdatabases.

4) go through upgrade, it should succeed.

5) insert the user database rows back into sysdatabases from the holding table. Note that there is an additional column now (audflags2) which takes a NULL value.

6) Shutdown ase and reboot. The user databases will go through upgrade as part of recovery.



CR:569403
CR Number:   569403
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2009 Added to user documentation
Description
Doc CR : You may be able to use packet sizes that are larger than the default size even if additional network memory is still 0.

This is why ASE reserves space for the new security features in the network buffer memory.

You still need to increase additional network memory to extend the network buffer memory if you increase max network packet size.



CR:569441
CR Number:   569441
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Windows
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jul 2010 Presently Not Targeted For Any Future Release Of This Product
24 Sep 2010 Fixed
28 Feb 2012 Fixed
Description
sqlupgrade fails to work if old version server to be upgraded is registered to LDAP server, it always tries to copy the interfaces file entry to the new directory and quits as failing to do so.



CR:569515
CR Number:   569515
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)
12 May 2009 Fixed
13 May 2009 Fixed
19 Jun 2009 Fixed
02 Jul 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Running a very large batch with many many IF statements when 'statement cache' is enabled causes error:

Msg 632: Attempt to move memory with an incorrect length of 25600. Maximum allowed length is 16384.
Workaround Description
 Run small batches (as this will make use of statement caching).

Turn off statement caching.



CR:569518
CR Number:   569518
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 May 2009 Fixed
11 May 2009 Fixed
05 Jul 2009 Presently Not Targeted For Any Future Release Of This Product
Description
When an OpenSwitch is used between two ASE servers, executing an UPDATE statement on

a VIEW attached with an INSTEAD OF UPDATE TRIGGER on a text or image column may result

in Msg 156 "Incorrect syntax near the keyword 'WHERE'" error and/or a stacktrace in

'omni_tname'.



CR:569523
CR Number:   569523
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)
23 Apr 2009 Fixed
30 Apr 2009 Fixed
Description
If the interfaces file does not exist or contains no server entries, opening 'Job Scheduler Server' page of Server Properties results an NullPointerException.



CR:569527
CR Number:   569527
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Release Bulletin for HP
Status:   Closed
OS:   HP-UX
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2012 Presently Not Targeted For Any Future Release Of This Product
Description
doc request: release bulletin should include warnings on HP license server vers.



CR:569531
CR Number:   569531
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2009 Fixed
Description
Server Properties dialog's Configuration tab's configuration group selection does not remain after Apply.



CR:569541
CR Number:   569541
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)
01 Jun 2009 Fixed
21 Dec 2009 Presently Not Targeted For Any Future Release Of This Product
Description
After changing the name of a table with sp_rename, triggers defined on the table may no longer work.



CR:569567
CR Number:   569567
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 2009 Fixed
29 Apr 2009 Reservation Made
Description
Allow UPDATE STATISTICS to be performed in a multi-statement

transaction. Update statistics changes will become part of the

transaction, and and all the work done by update statistics

will be removed by any rollback. If a multi-statement

transaction does not exist, then update statistics will continue to

use internal transactions to commit multiple minimal atomic parts

of the update statistics command which will remain even if the

command is aborted. Trace flag 2720 can be used to

continue with the pre-fix behaviour, in which case an attempt to run

this command in a multi-statement transaction is disallowed with an

error message.



CR:569660
CR Number:   569660
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2009 Fixed
Description
When dbcc checkalloc against archive database read the page from the disk into the reserved buffer,

the server don't update actual page number read so that this check failed with table corrupt.



CR:569713
CR Number:   569713
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2009 Fixed
Description
The realdb and the archive db can't get the same count of page format errors, so that dbcc checkverify get different result from them.



CR:569724
CR Number:   569724
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2009 Fixed
Description
Update ASE startup reporting changed to recognise Windows Vista and Windows Server 2008, avoiding the message "ASE booted on unrecognised or unsupported operating system".



CR:569742
CR Number:   569742
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2009 Fixed
Description
Logins folder's Full Name column was mistakenly removed.



CR:569790
CR Number:   569790
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature request where the index partition names can specified in the alter table command when

add partition results in local indexes on the new partition(s) if a local index is present on the

existing partition(s).



CR:569804
CR Number:   569804
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2009 Fixed
12 Aug 2009 Fixed
Description
Logging SQL when an instance is shut down gets a NullPointerException.



CR:569808
CR Number:   569808
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2012 Fixed
17 Jul 2012 Fixed
Description
In rare circumstances, the message "current process infected with 11" in the module 'adb__reserve_pg' together with a stack trace which includes the module 'adb_dirty' may be reported in the error log after the load of an archive database.



CR:569815
CR Number:   569815
Product Name:   Adaptive Server Enterprise
Product Component:   sql
Status:   Closed
OS:   HP-UNIX
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2009 Fixed
Description
HP-UX 11.23 will not be supported any more.



CR:569832
CR Number:   569832
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2009 Fixed
14 May 2009 Duplicate
Description
The default behavior of DBCC PAGE without specifying "CACHE" and "CACHENAME" option is to first check if the buffer of the specified page is in the cache of the local node.

If it doesn't exists, the page will be read from disk.

With the Cluster Edition, DBCC PAGE will first check if the buffer of the specified page is in the cache of the local node.

If it doesn't exists, it will check the caches of all nodes before reading the page from disk.



CR:569855
CR Number:   569855
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2009 Fixed
25 Feb 2010 One-off Provided
Description
Adaptive Server Shared Disk Cluster may fail over unnecessarily even if config parameter "cluster heartbeat retries" is increased.



CR:569904
CR Number:   569904
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2009 Fixed
21 Jul 2009 Fixed
21 Jul 2009 Fixed
Description
In rare circumstances, Job Scheduler might fail to run with the error "Incorrect syntax near '`'".



CR:569927
CR Number:   569927
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)
01 May 2009 One-off Provided
01 May 2009 Fixed
01 Sep 2009 One-off Provided
Description
When compatibility mode is enabled, executing a cursor declare query with UNION

may hit stack trace in the module of metrics_write() together with curs_open()

on hpia64 platform.



CR:569936
CR Number:   569936
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Troubleshooting guide should be expanded to offer general help on errors not covered explicitly within the guide.



CR:569940
CR Number:   569940
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)
17 Jun 2009 Fixed
23 Jun 2009 Fixed
22 Jun 2009 Fixed
Description
Truncate table is not consistent when switching tables under 'suspend audit when device full=0'



CR:569947
CR Number:   569947
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2009 Fixed
02 Jun 2009 Reservation Made
Description
SELECT INTO using ISNULL builtin in the SELECT list could lead to

target table column non-nullable while the early behavior

of ASE would make the target table column nullable even

when the ISNULL result can't be null for the query.
Workaround Description
 use traceflag 15336 to disable the change made by 497066 to get back to

the old ISNULL bebavior.



CR:569969
CR Number:   569969
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2009 Fixed
18 Dec 2009 Fixed
01 Sep 2009 Fixed
01 Sep 2009 Fixed
18 Dec 2009 Fixed
Description
Update DBISQL from version 11.0.0 to 11.0.1.



CR:570087
CR Number:   570087
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2009 Fixed
Description
In rare circumstances , error 8243 may be reported into the errorlog when one of the

instance in the multinode cluster crashes.



CR:570117
CR Number:   570117
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)
08 May 2009 Fixed
Description
Deleting a table with LOB columns (text, image, unitext) and non-datarows locking scheme under

direct mode may hit SIGSEGV together with stack trace in the module of LeDeleteOp::_LeOpNext()

if the query plan has merge joins.
Workaround Description
 Turn off merge joins or use 'datarows' locking scheme



CR:570136
CR Number:   570136
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2009 Fixed
04 Dec 2009 One-off Provided
Description
Restore the old behavior in ASE125 to use parallel sort while creating index on more than one output devices.



CR:570149
CR Number:   570149
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for some way to cause ASE to abort startup if specified errors occur during startup.



CR:570154
CR Number:   570154
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2009 Fixed
Description
In rare circumstances on an ASE CE server, a 820 error, "Attempt to dirty non-log buffer <buffer-address> which is in I/O" may be reported during an instance failover.



CR:570288
CR Number:   570288
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Improve scalability of housekeeper statistic flushing on very large systems.



CR:570307
CR Number:   570307
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)
01 Jun 2009 Fixed
Description
Deferred compilation may cause unexpected parse errors when setting quoted_identifier on\off within a procedure defintion. (Error 102, 257 etc)
Workaround Description
 1. use '[' and ']' as a quote delimiter.

example:

create table #t1([c1 c] int)

update #t1

set [c1 c] = s.id from sysobjects s



2.set switch on 7730 with override --disable DC for the session



CR:570329
CR Number:   570329
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2009 Presently Not Targeted For Any Future Release Of This Product
aries 12 Jun 2009 Fixed
Description
The failover of a Shared Disk Cluster may stall due to the cluster view inconsistency on different instances.



CR:570335
CR Number:   570335
Product Name:   SySAM
Product Component:   SyLAPI/C
Status:   Closed
OS:   Solaris
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2011 Duplicate
Description
Investigate - When enabling a licensed feature via sp_configure a timeslice in klicense_checkout() may occur if insufficient licenses are available from the license server.



CR:570337
CR Number:   570337
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a LIST aggregate function similar to the one in SQL Anywhere.



CR:570345
CR Number:   570345
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2009 Fixed
Description
Sybmon planprint could cause stacktrace.



CR:570346
CR Number:   570346
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2009 Fixed
Description
In some circumstances an inbound migrating task may be redirected by the workload manager, resulting in protocol error in the client.



CR:570398
CR Number:   570398
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Signal 11 in ubffree().



CR:570421
CR Number:   570421
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)
08 May 2009 Fixed
14 May 2009 Fixed
16 Jun 2009 Fixed
Description
If sp_dbrecovery_order specifies a recovery order with "strict" option, the databases many not be brought online in the specified order.



CR:570429
CR Number:   570429
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature requests that we document error "kernel nopen: accept" in the troubleshooting guide making particular emphasis on the fact that this is due to an operating system problem, not an ASE issue.



CR:570442
CR Number:   570442
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)
05 May 2009 Fixed
05 May 2009 Fixed
Description
Executing groupby queries with groupby columns reference java ADT might get wrong result if query plan chosen LeGroupInsOp (group inserting).



CR:570457
CR Number:   570457
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)
09 Oct 2009 Fixed
13 Oct 2009 Fixed
Description
Stacktrace could happen during GroupInsert operator execution under

compatibility mode for GroupBy query with a lot of aggregates.
Workaround Description
 use traceflag 446 to disable restrcited compatibility mode.

Or use traceflag 454 to disable groupinserting operator under restricted

compatibility mode.



CR:570478
CR Number:   570478
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)
30 Apr 2009 Fixed
01 May 2009 Fixed
Description
When compatibility mode is enabled, executing a query with GROUP BY clause may get

error 414 saying the key size of a worktable exceeds the maximum allowable limit.



CR:570485
CR Number:   570485
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2009 Duplicate
Description
NAMEPIPE generate nl__read_defer: read failed on socket 13.



CR:570519
CR Number:   570519
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2009 Duplicate
Description
Feature request to enhance pssinfo() with an option to return the current port number used by a client.



CR:570528
CR Number:   570528
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2009 Fixed
Description
First item in a folder was skipped in sorting.



CR:570642
CR Number:   570642
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)
19 Oct 2010 Fixed
Description
ASE was awarded a license on run-time grace rather than obtaining a license from the secondary license server after the primary was killed.



CR:570657
CR Number:   570657
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2009 Fixed
01 May 2009 Fixed
Description
ASE stack tracing mechanism may not work correctly on Windows 2008 and Vista



CR:570671
CR Number:   570671
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)
13 May 2009 Fixed
05 May 2009 Reservation Made
18 May 2009 One-off Provided
19 May 2009 Fixed
13 May 2009 Fixed
06 Jul 2009 Fixed
Description
In certain circumstances, distinct equi-join queries may return too few rows in

non-binary sortorder servers (which are typically case-insensitive). This will only

occur if reformatting is chosen for the join strategy. This could only

occur if an equi-join predicate contains (var)char columns and the distinct

select-list contains one or more columns that are not in any of the equi-join

predicates.
Workaround Description
 set store_index off



or:-



Add -T328 to the run file if widespread(328 disables reformatting globally)



These workarounds currently introduce the possibility of cr 570963, which

is a 325 error (no legal plan found).



CR:570712
CR Number:   570712
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)
05 Jan 2010 Fixed
Description
CREATE DATABASE command should print a warning message to the user if the number of databases on the server exceeds the value of the 'number of open databases' configuration parameter.



CR:570744
CR Number:   570744
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 Jul 2009 One-off Provided
13 Jul 2009 One-off Provided
16 Jul 2009 Fixed
16 Jul 2009 Fixed
21 Jul 2009 Fixed
Description
On p-Series Linux: Segmentation violation and memory corruption result in ASE panic under stress conditions during decryption operations.



CR:570758
CR Number:   570758
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If an uncompressed dump to tape is followed by a dump made with the "with compression" option, the compressed dump cannot be loaded and backupserver raises a volume validation error: illegal volume change, device /dev/rmt/0n: stripe 0 is already loaded.



CR:570789
CR Number:   570789
Product Name:   ASE Management
Product Component:   Web Console
Status:   Closed
OS:   Generic
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2009 Fixed
04 May 2009 Fixed
Description
An arithmetic overflow exception may occur when the Data Caches screen in the ASE Monitor is opened.



CR:570794
CR Number:   570794
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)
27 May 2009 Fixed
Description
Execution of a stored procedure which creates a table with non-materialized computed column

may sometimes result in a message "current process infected with 11" and the stack trace reported in the errlrog file if the procedure performs SELECT query on this table.

This is likely to happen if a procedure query tree is renormalized.

Stack trace may reference modules pre__replace_cpc and s_getTreeOrPlan.
Workaround Description
 Make the column materialized and explicitly list

the computed column in the select list:

create procedure pscott as

begin

create table #mono(

old_id char(6),

tid numeric(5) identity,

id_seed int default 1,

id_calc AS id_seed + tid materialized,

)

insert into #mono(old_id) values('A00001')

select old_id, tid, id_seed, id_calc from #mono

end



CR:570804
CR Number:   570804
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2009 Fixed
18 May 2009 Fixed
11 May 2009 Fixed
Description
Typo "Temdb" in the ASE server attribute editor screen.



CR:570818
CR Number:   570818
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2009 Fixed
Description
sp_cacheconfig will display wash size as '****** Kb' if the number of digits in the wash size is greater than 6.



CR:570890
CR Number:   570890
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 10330 is reported executing xp_*s procedures if installmaster is executed. Needed to give the permission to users to execute xp_*s procedures again.

C:\WINDOWS\system32>isql -Ulogin_ing

Password:

1> xp_cmdshell "dir"

2> go

. . .

02/28/2003 09:38 PM 113 zonedon.reg

2032 File(s) 379,119,114 bytes

48 Dir(s) 28,418,981,888 bytes free

(2087 rows affected)

(return status = 0)





C:\Sybase\ASE-15_0\scripts>isql -Usa -SASE15 -i instmstr -o saida

Password:



C:\Sybase\ASE-15_0\scripts>isql -Ulogin_ing

Password:

1> xp_cmdshell "dir"

2> go

Msg 10330, Level 14, State 1:

Server 'ASE15', Procedure 'xp_cmdshell', Line 2:

EXECUTE permission denied on object xp_cmdshell, database sybsystemprocs, owner dbo

(return status = -4)





To solve the situation :

C:\Sybase\ASE-15_0\scripts>isql -Usa

Password:

1> use sybsystemprocs

2> go

1> grant execute on xp_cmdshell to login_ing

2> go

1> exit



C:\Sybase\ASE-15_0\scripts>isql -Ulogin_ing

Password:

1> xp_cmdshell "dir"

2> go

. . .

2032 File(s) 379,119,114 bytes

48 Dir(s) 28,418,904,064 bytes free

(2087 rows affected)

(return status = 0)

1>
Target Version
 To Be Determined
Workaround Description
 C:\Sybase\ASE-15_0\scripts>isql -Usa

Password:

1> use sybsystemprocs

2> go

1> grant execute on xp_cmdshell to login_ing

2> go

1> exit



C:\Sybase\ASE-15_0\scripts>isql -Ulogin_ing

Password:

1> xp_cmdshell "dir"

2> go

. . .

2032 File(s) 379,119,114 bytes

48 Dir(s) 28,418,904,064 bytes free

(2087 rows affected)

(return status = 0)

1>



CR:570901
CR Number:   570901
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2009 Fixed
26 Aug 2009 Fixed
Description
ASE 15.0.3, esd#1 HKGC, Error 12316 occurs repeatedly



CR:570910
CR Number:   570910
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Fixed
Description
The message "storage access violation" in various XML related modules together with a stack trace which includes XML related built-in modules may be reported in the error log after an error 712 raised from a previous XML query involving a large XML document.
Workaround Description
 Try increasing the "heap memory per user" to avoid the 712 errors.



CR:570925
CR Number:   570925
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2009 Fixed
20 Jun 2009 Fixed
Description
In an active database, Checkstorage may report a 100021 and 100015 as a hard fault when checking

the last log page.



CR:570931
CR Number:   570931
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2009 Fixed
17 Aug 2009 Fixed
04 Jun 2009 Reservation Made
26 Aug 2009 Fixed
15 Oct 2009 One-off Provided
Description
On rare occasions a 605 error may be reported when BCP and UPDATE INDEX STATISTICS

with sampling are concurrently executed on the same Data Only Locked table that has

at least one non-clustered index present.





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