远程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:634162
CR Number:   634162
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)
19 Sep 2010 Fixed
Description
Feature request to add 4 new messages equivalent to the messages currently logged

in the ASE errorlog for reorg rebuild <tablename>.

These should cover:-



reorg rebuild <table> <index>



&



reorg rebuild <table> <index> partition <index_partitionname>



Which would generate:-



Beginning REORG REBUILD of index '%.*s' on table '%.*s'.

REORG REBUILD of index '%.*s' on table '%.*s' completed.



&



Beginning REORG REBUILD of partition '%.*s' of index '%.*s' on table '%.*s'.

REORG REBUILD of partition '%.*s' of index '%.*s' on table '%.*s' completed.



CR:634285
CR Number:   634285
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2010 Fixed
19 Jul 2010 One-off Provided
20 Jul 2010 Fixed
22 Jul 2010 Fixed
19 Jul 2010 Fixed
Description
A global reference to a Java object may be mistakenly destroyed twice, resulting

in methods being executed unexpectedly due to class-loader structures getting

corrupted. Alternatively Java Null Pointer Exceptions may be raised within classes

unexpectedly. When global references get destroyed repeatedly, this will result

in the COTS JavaVM aborting.



CR:634321
CR Number:   634321
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2010 Fixed
15 Feb 2011 Fixed
Description
The values of the monStatementCache table TotalSizeKB and UsedSizeKB columns are incorrect on servers using page size greater than 2K.



CR:634454
CR Number:   634454
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   12.5.4 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
investigate: self-deadlocks and causing 12311 error when running online index reorg on 12.5.4 esd #10



CR:634491
CR Number:   634491
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2010 Fixed
Description
If more than one -T parameters are used in ddlgen, e.g,

ddlgen -Usa -S... -P... -D... -TD -TI -TLK -TKC -TR -TRI -TSGM -TTR -TU -TV -N% ,

ddlgen does not print a syntax error.



CR:634536
CR Number:   634536
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)
04 Aug 2010 Fixed
Description
In some circumstances the message "current process infected with 10"

in the module 'rtrim_unichar' or 'lower_unichar' maybe be reported

in the error log when it is executed a query joining two or more

tables and using the functions RTRIM() or LOWER() on a column of

datatype UNICHAR or UNIVARCHAR.
Workaround Description
 - Disable MERGE JOIN, for example with: 'set merge_join off'

OR

- Run the query using compatibility mode: 'set compatibility_mode on'



CR:634619
CR Number:   634619
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 Jul 2010 Duplicate
Description
Transaction block it self when DDL involve Constraint.



CR:634635
CR Number:   634635
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer needs to present a client certificate to consumer https site. He is unable to give direct webservices to use this certificate and integrate it into a keystore for usage. Gets error 403 when trying to access the https location because of no authentication.
Workaround Description
 # consumer properties added for client certificate



javax.net.ssl.keyStore = /work/play/allianceBernstein/keystore.jks

javax.net.ssl.keyStorePassword = XKWMEDIC



to the ws.properties file.



Also one could add the same to the runws file. One could use the pkcs12 file directly by adding the property for javax.net.ssl.keyStoreType = PKCS12



CR:634666
CR Number:   634666
Product Name:   Adaptive Server Generic Docs
Product Component:   To Be Determined
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
doc bug: tibjms.jar file is different in newer versions



CR:634679
CR Number:   634679
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2010 Fixed
08 Sep 2010 Bundled Request
Description
If an additional language has been installed to the ASE, sp_passwordpolicy "list" incorrectly shows 2 rows.



CR:634692
CR Number:   634692
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)
21 Aug 2014 Insufficient priority to fix
Description
If an additional language has been installed to the ASE, sp_getmessage may show a conversion failure message or a localized message when an error occurs

even if you connect to the ASE with us_english language.



CR:634694
CR Number:   634694
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)
21 Aug 2014 Insufficient priority to fix
Description
If an additional language has been installed to the ASE, sp_helpconfig may show a conversion failure message or a localized message even if you connect to the ASE with us_english language.



CR:634722
CR Number:   634722
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)
05 Sep 2011 Insufficient info provided
Description
Signal 10 and/or signal 11 may occur in CtlibRemoteAccess::_connectionState(sdes**) for a session which has earlier used an cursor.



CR:634735
CR Number:   634735
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2010 Fixed
Description
When using SQL statement replication, Replication Agent may

shutdown reporting the error 9202, Severity 20, State 0,

if the replicated table has a trigger and the SQL DML

within the trigger attempts to use SQL Statement

replication as well.
Workaround Description
 Disabling SQL Statement replication.



sp_setrepdbmode <db name>, "udis", "off"

go



CR:634759
CR Number:   634759
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)
15 Jul 2010 Fixed
Description
Under certain circumstances executing a procedure when using the 憌ith recompile clause can cause a stack trace if that procedure references a view which in turn has an instead of trigger and the view and trigger have been dropped and recreated between invocations of the procedure.
Workaround Description
 If it is necessary to drop the view/instead of triggers referenced by a stored procedure, avoid the 憌ith recompile clause when executing the procedure for the first time following the re-creation of the view and trigger.



CR:634801
CR Number:   634801
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
CIS query fails with error ORDER BY error 169 in 1503 and 155



CR:634808
CR Number:   634808
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)
23 Aug 2010 Fixed
Description
Under some rare cases, if a query involving processing an IN list with an expression, it could stacktrace during query plan compile time.
Workaround Description
 There are at least a couple workarounds which may help.



The problem is due to processing an IN list with an expression. If there are a large

number of elements in the IN list (~128+), then trace 15393 will help by turning off

large IN list transformations. The repro mentions 300 elements in the IN list.



Compatibility Mode is another possible workaround (if there is nothing which would

disallow compat mode). We'd recommend using this for the specific problem queries,

as setting compat mode by default has a much wider impact.



Using Abstact Plans is another possibility if they can make updates for the specific

problem query.



CR:634861
CR Number:   634861
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 Not a Bug
Description
Transaction block with a rang lock when DDL involve Constraint.



CR:634875
CR Number:   634875
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2010 Fixed
16 Aug 2010 Fixed
05 Oct 2010 Fixed
08 Oct 2010 Fixed
Description
ASE 15.5 running on Windows can抰 be shutdown using the Windows Services Manager. Stack trace is seen in error log referring to storage access violation in syb_polite_shutdown
Workaround Description
 The server can be shutdown from ISQL using the shutdown command. To work around the problem, manually shutdown the server when required using ISQL.



CR:634947
CR Number:   634947
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2010 Fixed
28 Mar 2013 Fixed
18 Oct 2010 Fixed
Description
Under certain circumstance, dropping a global database within a multi-node cluster may fail due to CIPC message contention.



CR:634993
CR Number:   634993
Product Name:   Unified Agent
Product Component:   Agent Client
Status:   Closed
OS:   Windows XP
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2010 Fixed
15 Sep 2010 Fixed
Description
Lookup of the inetaddr attribute in the UDP response packet was modified to lookup explicitly (based on attribute name) rather than positionally.



CR:635012
CR Number:   635012
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add a MDA table for dynamic SQL LWPs.



CR:635017
CR Number:   635017
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add a function as lwp_number_count(spid) to report number of dynamic SQL LWPs for this spid.



CR:635018
CR Number:   635018
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add a function as show_cached_lwp_text() to report the SQL for dynamic SQL LWPs

a show_cached_text() for the LWPs.



CR:635038
CR Number:   635038
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)
21 Aug 2014 Insufficient priority to fix
Description
Connection to a case insensitive server from ct-lib using -JUTF8 (specifically upper-case

UTF8) could lead to a failed jdbc connection to the same case-insensitive server.



This will be seen at the client-side:-



java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

SQLState: JZ0IB

Message: JZ0IB: The server's default charset of UTF8 does not map to an encoding that is available in the client Java environment. Because jConnect will not be able to do client-side conversion, the connection is unusable and is being closed. Try using a later Java version, or try including your Ja

va installation's i18n.jar or charsets.jar file in the classpath.

Vendor: 0

SQLState: JZ006

Message: JZ006: Caught IOException: java.io.CharConversionException: java.io.UnsupportedEncodingException: UnsupportedCharset

Vendor: 0
Workaround Description
 Don't use uppercase 'UTF8' from any clients.



Or:-



sp_configure 'disable character set conversions', 1



CR:635047
CR Number:   635047
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Install Guide-Adaptive Server Enterprise
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2011 Added to user documentation
Description
Need to warn against using port scanners in ASE installations in our documentation.



CR:635084
CR Number:   635084
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)
20 Jul 2010 Fixed
20 Jul 2010 Fixed
03 Aug 2010 Fixed
06 Aug 2010 Fixed
06 Aug 2010 Fixed
Description
At the end of a load sequence, a database incorrectly inherits the database timestamp of the database into which the load was done, if that is bigger than that of the database that was dumped.



CR:635150
CR Number:   635150
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)
22 Oct 2010 Not reproducible with latest version of the product available as of Resolution Date
Description
ASE 15.5 CE with wrong version of backup server cause the load database to hange

this is a request to print a error message.
Workaround Description
 Use the correct version of backupserver.



CR:635154
CR Number:   635154
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error 511: "Attempt to update or insert row failed because resultant row of size

<X> bytes is larger than the maximum size (<Y> bytes) allowed for this table"

may be seen during 'optdiag binary statistics' output when running under compatibility_mode.
Workaround Description
 Turn compatibility_mode off for optdiag via a login trigger.



Or:-



Use optdiag output in standard (non-binary) mode.



CR:635155
CR Number:   635155
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request: Delay select into creating open transaction until it start populating data into a temp table
Workaround Description
 create a view for the very long query,

bcp out the date from the view

and then bcp into the temp table.



CR:635198
CR Number:   635198
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature request to verify sysattributes passwordd security entries with dbcc checkcatalog.
Workaround Description
 n/a



CR:635315
CR Number:   635315
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)
05 Aug 2010 Fixed
05 Aug 2010 Reservation Made
28 Oct 2010 One-off Provided
24 Sep 2012 Fixed
Description
Under some circumstances when the execution of a stored procedure

is aborted due to a 1205 error, "Your server command (family id ...,

process id ...) encountered a deadlock situation. Please re-run

your command." and the procedure was executed by another stored

procedure that had a cursor opened inside a user transaction and

the option SET CLOSE ON END TRAN was ON then the next execution

of the same stored procedure that reuses the plan which was

aborted could behave ignoring the WHERE clause for the statement

that was aborted by the 1205 error.
Workaround Description
 Ensure that a new plan is generated for the stored

procedure that could abort with the 1205 error.



For example:



- Use EXEC <procedure> WITH RECOMPILE

OR

- CREATE <procedure> WITH RECOMPILE



CR:635329
CR Number:   635329
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)
20 Sep 2010 Fixed
Description
Login overrides specified through sp_addlogin, sp_modifylogin may fail with error 17932 if sp_setpsexe

was invoked in the current session or adhoc rows were inserted in master.dbo.sysattributes with object_type = "PS".



CR:635362
CR Number:   635362
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)
20 Sep 2010 Fixed
Description
Increase the default size of CIPC pools.



CR:635364
CR Number:   635364
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2012 Added to user documentation
Description
Document sp_post_xpload with force implemented from ASE1254ESD10



CR:635375
CR Number:   635375
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_checkreswords always prints out messages in English even if an additional language has been installed to the ASE.



CR:635398
CR Number:   635398
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
wants to link attributes in complex elements (and elements) in an XML Model to other attributes in complex elements of another XML Model with extended dependancies. Only the complex elements and elements but not their attributes are available for linking (Influenced Object).



CR:635453
CR Number:   635453
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2010 Fixed
03 Aug 2010 Fixed
21 Jul 2010 Fixed
Description
sp_post_xpload without force option will cause error605(reindex)
Workaround Description
 either use force option with sp_post_xpload

or

manually drop/recreate the indexes



CR:635454
CR Number:   635454
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UNIX
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
App tracing: File generated by <set tracefile on> is limited to 2GB



CR:635483
CR Number:   635483
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)
14 Oct 2010 Fixed
Description
The monitor table monCachedStatement may contain wrong data.
Target Version
 auriga



CR:635507
CR Number:   635507
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.2 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error 9289 , RAT reports inconsistent data in the transaction log.
Workaround Description
 None, skip the offending record.



CR:635620
CR Number:   635620
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2010 Fixed
18 Nov 2010 Fixed
Description
ASE on Windows can occasionally hang on call csimtx_lock()=>WaitForSingleObject().

This can occur at server startup or at user authentication when attempting to

obtain the lock which is already held.



CR:635627
CR Number:   635627
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2010 Fixed
19 Jul 2010 Fixed
19 Jul 2010 One-off Provided
19 Jul 2010 Fixed
Description
In rare circumstances following the undo of a deallocation, the database timestamp may be inadvertently set higher than it needs to be, increasing the likelihood of running out of timestamps for any database during its lifetime.



CR:635663
CR Number:   635663
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2011 Fixed
23 Jun 2011 Fixed
Description
Executing parallel SELECT on syscomments with traceflag 15331 enabled may result in a 1289 error followed by a stacktrace involving the modules 'lock__ins_logical' and 'lock_logical'.
Workaround Description
 Workarounds:

a) set parallel_query off

b) remove the traceflag 15331 from the RUN_server file and restart ASE

c) use sp_chgattribute on syscomments

sp_configure updates, 1

go



select sysstat, type from sysobjects where name="syscomments"

go

-- take note of the current value of sysstat, write it down!

select * from sysobjects where name="syscomments"

go



begin tran

go

update sysobjects set sysstat = 99 where name="syscomments"

go

update sysobjects set type = 'U' where name="syscomments"

go

-- confirm only one row affected and confirm the change

select * from sysobjects where name="syscomments"

go

-- if more then one row, or change is not correct rollback

rollback

go

-- else commit

commit

go





restart server





sp_chgattribute "syscomments", "plldegree", 1

go



begin tran

go

update sysobjects set sysstat = 97 where name="syscomments"

go

update sysobjects set type = 'S' where name="syscomments"

go

-- confirm only one row affected and confirm the change

select * from sysobjects where name="syscomments"

go

-- if more then one row, or change is not correct rollback

rollback

go

-- else commit

commit

go



sp_configure updates, 0

go



-- restart ASE





set parallel_query on

go

select * from syscomments

go

-- completes



CR:635778
CR Number:   635778
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)
21 Jul 2010 Fixed
10 Aug 2010 Fixed
Description
The message "process infected with signal 11" may be reported in the error log

together with a stack trace which includes the modules 'lt_sqlrep_comp_policy',

's_compile_stmt' and 's_recompile' when a DML command is ran and the involved

queries are eligible for SQL Statement Replication.



CR:635950
CR Number:   635950
Product Name:   Adaptive Server Generic Docs
Product Component:   Clusters Users Guide
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Each node in private installation doesn't need its own $SYBASE on CFS from ASE1503CE onwards



CR:635969
CR Number:   635969
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)
15.5 ESD #3 20 Sep 2010 Fixed
21 Aug 2012 One-off Provided
26 Oct 2007 One-off Provided
Description
In a multi-node cluster, messages like "Object Coherency Block Information: ocb=400385318, lockhandle=1ab1da5a8, version={high=0, pad=0, low=2},.." and "ocm_lock: task going to sleep as ocm__lock_object() returned OCM_ERR_DEADLOCK and bast is not yet received" would appear in the errorlog and transactional activity might be frozen in one or more instances.



CR:636014
CR Number:   636014
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)
16 Dec 2011 Deferred
Description
Update query never completes on 15.0.3 when it was 4 minutes to complete on 12.5.4.

Once it has been run with the abstract plan from 12.5.4, it completes, but as soon as you update statistics again, it is broken.
Workaround Description
 You can use compat mode for this query provided you do not have any new optimizer set options.

IE dont use set option show brief, set statistics plancost on and it will use compat.



CR:636065
CR Number:   636065
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2010 Fixed
07 Dec 2010 Fixed
15 Dec 2010 Bundled Request
Description
On IPv6 enabled machine, Job Scheduler task can not connect to jsagent if interfaces file entry for JSAGENT has IPv4 address.



CR:636236
CR Number:   636236
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
A 14108 error, "Could not find partition descriptor for objid <objid>, indid <indid>, ptnid <ptnid> in dbid <dbid>." may be reported during SELECT INTO a LOB column from a source table with a non-LOB column.



CR:636238
CR Number:   636238
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2010 Fixed
Description
On ASE SDC, Job Scheduler agent may fail to boot with following error message in the error log.

" Job Scheduler Agent entry for host '<host_name>' not found. " when the machine name(host_name)

for JSAGENT entry in the interface file is not same as name returned by `uname -a`.



CR:636277
CR Number:   636277
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)
18 Feb 2011 Insufficient priority to fix
06 Jul 2011 Fixed
13 Jul 2011 Fixed
Description
Interrupting the load of a 12.x dump on a 15.x server may lead to 605 errors on a subsequent attempt to load the database.
Workaround Description
 Avoid striking Ctrl-C while loading a database dump taken from ASE 12.5.4 or lower into a server running ASE 15.0.3 ESD#2 or higher.



CR:636293
CR Number:   636293
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2010 Reservation Made
22 Sep 2010 Reservation Made
Description
CROSS JOIN is unsupported in ASE.



CR:636306
CR Number:   636306
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
Infected with 11 occurs with GAGenericArray::_GaGetPtr at the top of the stack.



CR:636334
CR Number:   636334
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   ASE 15.5 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2010 Fixed
Description
The version string for Backup Server binaries is directed to STDERR instead of STDOUT.



CR:636431
CR Number:   636431
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
feature request: expire logins after x number of days with no password expiration/renewal possible.



CR:636439
CR Number:   636439
Product Name:   Sybase SQL Server
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2010 Fixed
Description
On AIX, a warning message "iof_reserve_device: fence device %s is already reserved in type 5" is always displayed.



CR:636454
CR Number:   636454
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
feature request: uncheck preupgrade in sqlupgrade and sqlupgraderes



CR:636592
CR Number:   636592
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2010 Fixed
16 Aug 2010 Reservation Made
Description
select DISTINCT queries (or queries referencing DISTINCT views or derived tables) may choose a suboptimial plan, when a D! (i.e. opportunistic partial distinctness) property is found at the top of the unenforced subplan below the EMIT. The fix can be enabled by optcriteria cr636592 or optlevel ase155esd3.
Workaround Description
 set opportunistic_distinct_view off





or:-



Force the good join order via 'set forceplan on'

or 'set compatibility_mode on'



(the customer dropped index 'ProductMap_test1' on their production server to avoid the suboptimal plan)



CR:636677
CR Number:   636677
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2012 Fixed
24 Jul 2012 One-off Provided
Description
Improve efficiency of spinlocks on the AIX platforms.



CR:636684
CR Number:   636684
Product Name:   Adaptive Server Enterprise
Product Component:   sql
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2011 Fixed
Description
sp_unbindexeclass fails with error 512 when more than one row qualify for the delete operation.



CR:636706
CR Number:   636706
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)
09 Feb 2011 Fixed
12 May 2011 Fixed
Description
The "directio on" attribute of a database device may be lost mistakenly after having

unmounted and mounted a database that is using this device.
Workaround Description
 sp_deviceattr device_name, directio, true



CR:636786
CR Number:   636786
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2010 Fixed
12 Nov 2012 Fixed
Description
The execution of SP_RENAME and SP_CONFIGURE will raise error 17260 "Can't run <procname> from within a transaction." incorrectly when invoked under chained transaction mode despite that there is

no open transaction.



CR:636791
CR Number:   636791
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Timestamps will be recorded when each of the checks begins in the preupgrade process.



CR:636795
CR Number:   636795
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The new FR would like to have a output file to save the preupgrade output.



CR:636798
CR Number:   636798
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)
02 Aug 2010 Presently Not Targeted For Any Future Release Of This Product
Description
The FR would be possible to let sqlupgraderes use multiple engines.



CR:636806
CR Number:   636806
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)
10 Mar 2011 Fixed
10 Mar 2011 Fixed
20 Apr 2011 Fixed
Description
When Java methods that request lots of memory for their execution are run concurrently

by multiple sessions, ASE may run into a situation where the PCI integrated JavaVM aborts

after having reported "OutOfMemory" error messages. In some cases this may result in ASE

shutting down itself.



CR:636825
CR Number:   636825
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)
02 Aug 2010 Presently Not Targeted For Any Future Release Of This Product
28 Sep 2010 Fixed
20 Sep 2011 Reservation Made
24 Oct 2011 Presently Not Targeted For Any Future Release Of This Product
Description
If "enable ssl" is configured and there is no ssl entry in the interfaces file when

starting an ASE, sp_listener "start","ssltcp:<host>:<port>:'CN=<common name>'","<engine>"

will fail, with common name mismatch error.



CR:636898
CR Number:   636898
Product Name:   SySAM
Product Component:   SyLAPI/C
Status:   Closed
OS:   AIX
Original Version:   2.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2010 Bundled Request
Description
On POWER 7 AIX systems with 4 SMT threads enabled, ASE requests twice as many licenses as it should.
Workaround Description
 Suggested workarounds:

1) If 4 SMT threads are not required then using 2 SMT threads will work.

2) For versions with no further EBFs (such as ASE 15.0.x) we will need to provide customers with the environment variable override as described in the Workaround section of CR 576652.

3) Other product releases should move to SyLAPI 2.2.0.6 to pick up the

fix. We can use the existing LPAR exception policy (http://syberwiki.sybase.com/display/PM/Pricing) to provide these customers with temporary licenses until a product release with the fix is available.



CR:636958
CR Number:   636958
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2010 Fixed
09 Sep 2010 Bundled Request
Description
For Internal Use Only: Address review comments of CR#636430



CR:637002
CR Number:   637002
Product Name:   SySAM
Product Component:   SyLAPI/C
Status:   Closed
OS:   Solaris
Original Version:   2.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2010 Fixed
Description
SySAM incorrectly identifies sun4v processor systems as LDOMs and prevents Small Business Edition from running unless a SYBASE_SAM_CAPACITY environment variable is specified.
Workaround Description
 Email help_sysam@sybase.com mentioning this CR and providing the following information.



1. Output from:

cpuinfo -v



2. Output from:

lmutil lmhostid





Someone on the alias will reply with an environment variable override of the form:



SYBASE_SAM_CAPACTY=DEFAULT:0943545897458973456



The customer will need to set this variable in the environment prior to starting the product.



CR:637005
CR Number:   637005
Product Name:   Adaptive Server Generic Docs
Product Component:   Transact-SQL Users Guide
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2012 Added to user documentation
Description
Documentation needs clarifying with respect to Sybase NULLs and ANSI NULLs



CR:637007
CR Number:   637007
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2011 Fixed
07 Dec 2010 Fixed
23 Feb 2011 Added to user documentation
16 Jan 2011 Reservation Made
18 Feb 2011 Fixed
Description
Add a new MDA table monLockTimeout to track info when occurence of lock manager time out



CR:637012
CR Number:   637012
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)
04 Aug 2010 Duplicate
Description
Upgrading to 15.0.3 with bound system tables in model causes 696 errors



CR:637088
CR Number:   637088
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 Nov 2012 Bundled Request
Description
Update sp_drv_typeinfo in installmaster script



CR:637114
CR Number:   637114
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   bharani beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2010 Fixed
09 Sep 2010 Bundled Request
Description
For Internal Use Only(K21 stab):sig11 in listener_checkagain on solaris



CR:637172
CR Number:   637172
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)
06 Aug 2010 Fixed
Description
A SELECT query running at transaction isolation level 1 may sometimes not exhibit

expected blocking behaviour on a row that is inserted by an uncommitted transaction

if the inserted row is replacing a row deleted by the same transaction.
Workaround Description
 force a table scan(indid 0), or

set transaction isolation level 3, or

create unique nonclustered index pk_test1 on test1(a, b,c), or

boot ASE with trace flag 693 (turns off some blocking optimizations

in scan such as skipping uncommitted inserts and skipping or returning

uncommitted updates based on info about what columns were updated)



CR:637193
CR Number:   637193
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2010 Duplicate
Description
In rare circumstances the error 706/20/3 may be raised when executing a query

related to sysobjects with statistics on ASE 15.5
Workaround Description
 trace flag 15352 to turn off expression histogramming



or



set compatibility_mode on





or:



delete statistics sysobjects



CR:637248
CR Number:   637248
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2010 Fixed
Description
Using compatibility mode results in a marginal performance drop for queries involving worktables.



CR:637262
CR Number:   637262
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2010 Fixed
13 Oct 2010 Fixed
Description
Adaptive Server Cluster Edition may rarely hit signal 11 error with stacktrace containing cmcc_bufsearch(), under high load of concurrent INSERT and SELECT statements issued on multiple instances of the cluster.



CR:637307
CR Number:   637307
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2010 Fixed
Description
Using the "with verify=full" option for a database causes warning messages in the backup server log relating to pages 24-31. These messages are due to the system table that uses these pages having a special format. They can be safely ignored.
Workaround Description
 TO avoid these messages fo not use the 'with verify option.



CR:637317
CR Number:   637317
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2010 Fixed
15 Nov 2010 Fixed
11 Jan 2011 Fixed
23 Feb 2011 Added to user documentation
Description
Added ProgramName, HostName, ClientName, ClientHostName, ClientApplName columns to monProcess, ProgramName, ClientName, ClientHostName, ClientApplName columns to monProcessLookup, Application, HostName, ProgramName, ClientName, ClientHostName, ClientApplName columns to monProcessActivity, HeldProgramName, HeldClientName, HeldClientHostName, HeldClientApplName, WaitApplName, WaitHostName, WaitProgramName, WaitClientName, WaitClientHostName, WaitClientApplName columns to monDeadLock.



CR:637395
CR Number:   637395
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2011 Fixed
Description
In the Cluster Edition, when monitoring is enabled, the MaxIOServiceTime in the MDA table monOpenPartitionActivity may sometimes have values less than the AvgIOServiceTime.



CR:637468
CR Number:   637468
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)
27 Oct 2014 Insufficient priority to fix
Description
Error 247 Dynamic prepare statement fails with Arithmetic overflow from Jconnect



CR:637538
CR Number:   637538
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2010 Fixed
Description
Queries with non-correlated subqueries that references a grouped aggregated view in multiple places in the query will lead to a parallel plan not created.



CR:637589
CR Number:   637589
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)
31 May 2011 Fixed
01 Jun 2011 Fixed
Description
Signal 11 in function ScalarNormalizing() (amongst others) may be seen in the error log

and the spid terminated when attempting to insert <table> (<column-list>)..select <col> from <table2> union/union all <select> in a procedure where <table> is created inside the procedure and <table> contains non-nullable columns that are not in <column-list>.
Workaround Description
 Ensure all columns in the table being inserted into that may be passed null values are

create with nullable property (either declarative or by setting 'allow nulls' = true)



CR:637600
CR Number:   637600
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)
02 Jun 2011 Fixed
Description
Signal 11 stacktrace with error msg 416 may be seen in the error log and the spid terminated when attempting to insert <table> (<column-list>)..select <col> from <table2> union/union all <select> in a procedure where <table> is created inside the procedure and <table> contains non-nullable columns that are not in <column-list>.



CR:637651
CR Number:   637651
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2010 Duplicate
Description
Update statistics with/without consumers different histograms steps



CR:637698
CR Number:   637698
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2011 Fixed
18 Mar 2011 Fixed
Description
A 9543 error, "Parameter passed to the builtin 'lockscheme' has an invalid type.", may be encountered when the lockschme function is used with id and dbid parameters from master..sysprocesses.
Workaround Description
 select lockscheme (convert (int, id), dbid) from sysprocesses where spid=2



CR:637723
CR Number:   637723
Product Name:   ASE Management
Product Component:   Web Console
Status:   Closed
OS:   Generic
Original Version:   3.2.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2011 Fixed
Description
New Feature - Server wide events are displayed on Overview screen of ASEMAP monitoring view



CR:637729
CR Number:   637729
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #3 11 Aug 2010 Fixed
Description
When running non-English regional settings it is possible for the

CreationDate\LastExecution\NextExecution dates to display a 'null' when viewing

'Scheduled Jobs' (requires Job Scheduler) in Sybase Central 4.3 through to 6.0.
Workaround Description
 Switch regional setting to English.



or:-



You can still check the dates by running outside of Sybase Central of course:-



sp_listscheduledjob 'list=scheduled_short'



CR:637828
CR Number:   637828
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)
13 Aug 2010 Fixed
17 Aug 2010 Fixed
17 Aug 2010 Fixed
23 Aug 2010 Presently Not Targeted For Any Future Release Of This Product
02 Sep 2010 One-off Provided
Description
ASE tasks may be terminated with a timeslice error if the ASE is running a multi-byte character set and SQL batch capture is configured to 1.

The stack trace may contain oh_get_obfuscated(), copy_sqltext() and sqlpars().
Workaround Description
 sp_configure "SQL batch capture", 0



CR:637872
CR Number:   637872
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
add the hostname and program_name from sysprocesses to the sybsecurity functionality so it can be archived together.



CR:637904
CR Number:   637904
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)
05 Sep 2010 Fixed
Description
sp_plan_dbccdb has wildly LOW recommendations for the dbccdb databases may cause

dbccdb log fills and when cancel out of dbcc checkstorage may cause sigsegv and stackoverflow.



CR:637993
CR Number:   637993
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2010 Fixed
30 Nov 2010 Fixed
23 Nov 2010 Fixed
01 Dec 2010 Fixed
02 Dec 2010 Fixed
02 Oct 2012 One-off Provided
04 Oct 2012 Fixed
Description
In some ASE workloads, proc_spin shows up as having high contention. This fix could decrease the contention in some of these workloads.



CR:638062
CR Number:   638062
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)
31 Aug 2010 Fixed
Description
sp_dboption with no parameter doesn't display full descriptions of the database options if the ASE's language is japanese.



CR:638068
CR Number:   638068
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2010 Fixed
Description
On Windows systems when Adaptive Server is running

with configuration options "enable literal autoparam"

and "statement cache" active in some circumstances the

execution of a query containing a big literal binary

value may be aborted and the message "SQL Server system

exception (0xc0000005) generated by a storage access

violation" together with a stack trace which includes

the modules 'memcpy' and 'mkconst_desc' may be reported

in the error log.
Workaround Description
 Disable automatic literal parameterization, for example

via "sp_configure "autoparam", 0"



CR:638098
CR Number:   638098
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Windows
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2010 Fixed
Description
On windows, Database Emulator doesn't receive QaTrflag_status bitmap.



CR:638140
CR Number:   638140
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Converting char to int returns 249 error in 15.x
Workaround Description
 set compatibility_mode off



CR:638169
CR Number:   638169
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2010 Fixed
Description
A configuration option 'enable deferred parallel' has been added to enable/disable

the deferred parallel optimization mechanism. The default value is 0 (disabled);

a value of 1 enables this method.



Deferred Parallel Optimization is an alternative method for costing and selecting

parallel query plans. When enabled, the best serial plan is chosen using the

serial optimizer; this plan is then converted to a parallel plan, normally

maintaining the same join order and physical operators as the serial plan.



This method provides a parallel plan using less optimization time, while reducing

the risk that a parallel plan will be chosen which is inferior to the best serial

plan. With the full (default) parallel optimization mechanism, an inferior plan

may be chosen due to optimizer time out, or due to limitations of parallel costing.





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