Sybase数据库技术,数据库恢复 » SAP ASE/IQ/RS/SDK/SQL Anywhere/PB的BUG信息

随着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:343115

CR Number:	343115
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	HP-UX
Original Version:	12.0.0.7

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		09 Feb 2004	Fixed

		18 Feb 2004	Fixed

Description

Two processes setting up a site_handler may hit a race condition, causing a hang.

The hang will be accompanied by the message

"A call to srv__waitfor_read() was interrupted by an attention".

Workaround Description

for the backupserver hang case,

sp_serveroption SYB_BACKUP, "timeouts", false

go

will help to decrease the possibility that we try to create

2 site handlers for the same server at the same time.

CR:343118

CR Number:	343118
Product Name:	Adaptive Server Enterprise
Product Component:	buildmaster

Status:	Open
OS:	HP-UX
Original Version:	12.5.0.3

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)

Description

Include 11x_bmaster binary with ASE >= 12.5.x installs

CR:343120

CR Number:	343120
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	Solaris
Original Version:	12.5.0.3

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		30 Jan 2004	Bundled Request

Description

'number of dumps' counter of CSMD increments even if memdump is failed

Workaround Description

"Reset the number of dumps by command - sp_shmdumpconfig 'reset', <type>, value"

CR:343252

CR Number:	343252
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	Solaris
Original Version:	12.5.0.3

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		23 Feb 2004	Fixed

Description

Querying the monCachedObject table can cause other processes to timeslice. When this occurs the query will take much longer to execute and the ASE errorlog will contain the error "timeslice -<value>, current process infected" followed by a stacktrace.

CR:343260

CR Number:	343260
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	all
Original Version:	12.5.1

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		12 Jan 2004	Fixed

		12 Mar 2004	Fixed

Description

If an @variable is buried in a nested derived table, it may lead to stack trace.

CR:343360

CR Number:	343360
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	Solaris
Original Version:	12.5.0.3

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		27 Jan 2004	Presently Not Targeted For Any Future Release Of This Product

		24 Feb 2004	Fixed

Description

CIS: Local server may show stack trace when errors are encountered on sp_remotesql or

sp_passthru in a multi-session environment in which some of the sessions may hang

in 'remote i/o'.

Workaround Description

Explicity run "set quoted_identifier on" before running sp_remotesql

CR:343363

CR Number:	343363
Product Name:	Adaptive Server Enterprise
Product Component:	Sybase Central ASE Plug-in

Status:	Closed
OS:	all
Original Version:	12.5.2

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		02 Mar 2004	Fixed

Description

With ASE 12.5.2 ASEPlugin, the plugin parsing of template documents, JS Template schema and instance documents have been modified. The JS Template XML instance documents must be re-installed if users are upgrading from the ASE 12.5.1 ASEPlugin.

If users do not upgrade their ASEPlugin, the latest JS Template instance documents should not be upgraded.

The changes were required to support localization for the Job Scheduler interface within the ASEPlugin.

CR:343446

CR Number:	343446
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	all
Original Version:	12.5.1

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		16 Jan 2004	Fixed

Description

Query using non intialized bit local variable may fail with error 245:

"Domain error during implicit conversion of BIT value '0' to a BIT field."

Workaround Description

Assign some value to thelocal variable before running the query.

CR:343448

CR Number:	343448
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	Microsoft Windows NT
Original Version:	12.5.1

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		29 Jan 2004	One-off Provided

Description

INSTRUMENTATION: Network listeners disappear without error on

ASE 12.5.1 running on win2000 adv server

CR:343495

CR Number:	343495
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	all
Original Version:	12.5.1 ESD#1

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		26 Nov 2004	Fixed

		02 Dec 2004	One-off Provided

		29 Aug 2005	Not reproducible with latest version of the product available as of Resolution Date

Description

A 12536 message "Sysstatistics upgrade warning for table <table>. New row-length after upgrade,

1965, ... exceeds maximum limit of 1964. Run update statistics on this table after upgrade." may be

reported in rare circumstances during an upgrade from a pre 12.5 server.

Workaround Description

1.Use query from CR description to find the length of statistics rows

before upgrade

2.For rows with length 1964, save the stats before the upgrade to a

file using optdiag and restore them after the updrade.

CR:343514

CR Number:	343514
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	Solaris
Original Version:	12.0.0.8

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		02 Apr 2004	Fixed

		23 Feb 2004	Fixed

Description

A query SELECT ...UNION ...SELECT may return incorrect result or hang if different UNION sides are executed with different degree of parallelism.

Workaround Description

Problem did not occur

1) when max scan parallel degree and max parallel degree , both=10 or

2) with enable sort-merge join and JTC=0 or

3) if we changed query and removed 1=2 clause*/

CR:343560

CR Number:	343560
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	all
Original Version:	12.5.1

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		21 Jan 2004	Fixed

Description

Error 103, "The identifier that starts with "<constraint name>" is too long. Maximum length is 28." is

raised during ALTER TABLE add <column> command on a table which has a column using a constraint name

of 30 characters.

Workaround Description

Use an APL table or shorten the identifier name

CR:343593

CR Number:	343593
Product Name:	Adaptive Server Enterprise
Product Component:	Job Scheduler

Status:	Closed
OS:	Solaris
Original Version:	12.5.1

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		13 Jan 2004	Fixed

Description

Job Scheduler sp_sjobsetstatus commands embedded into a job's SQL were incorrectly operable on other job's besides its own. This has been corrected.

CR:343638

CR Number:	343638
Product Name:	Adaptive Server Enterprise
Product Component:	dataserver

Status:	Closed
OS:	Solaris
Original Version:	12.0.0.4

Fixed Version