远程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:548641
CR Number:   548641
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2012 Added to user documentation
Description
When trying to use sp_maplogin the documentation is not clear about exactly how the "client name" and the "login name" should be used.



CR:548663
CR Number:   548663
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)
05 Nov 2008 Fixed
Description
When the following conditions are true, error 2753 will be raised together with 103 error in English

and stack trace may happen from ex__doprint():



1. Asian languages (Chinese, Japanese and Korean) are used as default language of a connection

2. a create table/view command with longer than 255 bytes multi-byte object name

3. the object name starts with one single-byte character and followed with multi-byte characters



CR:548677
CR Number:   548677
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)
14 Nov 2008 Fixed
02 Jun 2009 Fixed
Description
If the configuration parameter 'number of engines at startup' is misconfigured, a stack trace may occur at server startup due to a segmentation fault in the function interface_to_typeid().



CR:548776
CR Number:   548776
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2008 Fixed
29 Jan 2009 Bundled Request
Description
When master database replication is configured and login accounts are created and dropped on the master database, the Server User IDs generated in the active database during the creation of new login accounts could be different from the Server User IDs generated on the standby database.



CR:548881
CR Number:   548881
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)
16 Dec 2008 Fixed
15 Dec 2008 Reservation Made
30 Mar 2009 Presently Not Targeted For Any Future Release Of This Product
25 Mar 2009 One-off Provided
26 May 2009 Fixed
Description
Error Message 104 or 207 may be returned for a query using a column alias rather than the base column name in an ORDER BY clause.



CR:548900
CR Number:   548900
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)
12 Nov 2008 Fixed
Description
During the execution of queries with more than 16 user tables, up to 34 extra auxillary

SDESes may be claimed (One for each table beyond 16) for the duration of execution.



CR:548927
CR Number:   548927
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2009 Duplicate
Description
With 'statement cache' and 'enable literal autoparam' turned on - showplan can incorrectly indicate that a statement is 'newly cached' as oppose to 'previously cached' if the statement contains greater than 2 OR conditions



CR:549024
CR Number:   549024
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2008 Fixed
04 Feb 2009 Fixed
Description
A 832 error may be reported "Unable to place buffer <value> holding logical page <value>

in sdes for object '<value>' - there is no room in sdes aux keep pool." in the error log

together with a stack trace which includes the modules 'bufkeep', 'bt__insert_into_leaf'

and 'bulk__fast_idxupdate' when inserting rows through bulk copy in a Data Only Locked

table whose non-clustered index tree is being updated by ASE.
Workaround Description
 Try partition the table with 41 round-robin.

It works with non-partition table or table with few partitions (e.g., < 5).



For applications with more than 41 partitions, this workaround might not work.



CR:549065
CR Number:   549065
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2012 Bundled Request
Description
DBISQL Feature request to allow viewing Stored Procedures source code directly from the menu options.
Workaround Description
 Use server side system stored procedures : sp_helptext/sp_showtext



CR:549086
CR Number:   549086
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)
22 Mar 2009 Fixed
25 Jan 2012 Added to user documentation
Description
'disk init' command and sp_deviceattr procedure does not prohibit setting of directio/dsync options for raw devices.



CR:549097
CR Number:   549097
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2008 Fixed
Description
When we had nested virtual columns in the predicate and at least one of the virtual column is under CASE/OR node. The virtual columns under CASE/OR nodes could be

processed incorrectly and lead to the wrong results.
Workaround Description
 See Reproductions (C).



CR:549112
CR Number:   549112
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 Fixed
30 Nov 2008 Fixed
Description
Attempting to DISK INIT using a symbolic link to a device that is already in use will succeed without error.
Workaround Description
 Don't create multiple symbolic links to the same raw devices.



CR:549168
CR Number:   549168
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2008 Fixed
05 Feb 2009 Fixed
24 Mar 2010 Bundled Request
Description
When set locale to Chinese, the chinese charaters in sysam checkout messages shows as boxes or garbage.



CR:549170
CR Number:   549170
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare cases, if a database is offline, some commands allowed in

a offline database such as dump tran might hang because space usage

in some segment may cross the segment threshold.
Workaround Description
 Commands such as online database, dump database, dump tran and alter database (DBEXTEND)

are allowed in an offline database. To avoid hitting the problem mentioned in this CR,

we should refrain from issuing these commands on offline database. We should bring

the database online first, and then issue these commands.



How it helps?

When the thresold crosses, new thresold manager task is spawned. But, this task won't be

get dbtable as database is offline. So if the database is brought online and the command

issued, we won't hit the problem.



CR:549199
CR Number:   549199
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2008 Fixed
Description
If SSL is enabled, user will fail to install utf8 character set using "charset" command in Win64 platform. The error message will be:

SQLServer message 632, state 2, severity 20:

Attempt to move memory with an incorrect length of 16416. Maximum allowed leng

th is 16384.



CR:549239
CR Number:   549239
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)
12 Nov 2008 Fixed
Description
Procedural query compiled in the deferred mode may not work as expected if it

this query needs execution of the DEFAULT or RULE or references materialized column

using global variables.
Workaround Description
 Enable trace flag 7730 to turn off deferred compilation.



CR:549264
CR Number:   549264
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2010 Fixed
18 Mar 2010 Fixed
Description
When doing an alter table on a replicated table containing a text column,

and the alter table does not involve dropping a column, ASE produces a

SIGSEGV in cri_ncrebuild().



CR:549309
CR Number:   549309
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)
15 May 2012 Duplicate
Description
Feature request for a version of REORG REBUILD that could be run for a definable period of time, fully compacting the part of the table processed into new extents.



CR:549316
CR Number:   549316
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2009 Fixed
Description
In rare circumstances, a query being executed in parallel

may hang when the query had to abort due to a 1105 error,

"Can't allocate space for object <table_name> in database

<db_name> because <segment_name> segment is full/has no

free extents. If you ran out of space in syslogs, dump

the transaction log. Otherwise, use ALTER DATABASE to

increase the size of the segment.", caused by insufficient

space in tempdb for the worktables that the query internally

needed.
Workaround Description
 Disable parallelism.



CR:549412
CR Number:   549412
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2009 Fixed
Description
DDLGen generates duplicate column names in partition key list.
Workaround Description
 User PowerBuilder to modify the query that creates the "partition by range" clause

to include "and p.indid = 0":



select p.indid, column_name = c.name, column_type = isnull(x.xtname, isnull(get_xtypename(c.xtype,c.xdbid), t.name))

from dbo.syscolumns c, dbo.sysxtypes x, dbo.systypes t, dbo.syspartitionkeys p where c.id = object_id("All_Drugs")

and c.xtype *= x.xtid and c.usertype *= t.usertype and p.id = object_id("All_Drugs")

and c.colid = p.colid and p.indid = 0 order by p.position



CR:549413
CR Number:   549413
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Fixed
Description
DDLGen creates range partition in the incorrect order causing error 14304
Workaround Description
 Manually edit the script to put the partition conditions in incremental order.



CR:549415
CR Number:   549415
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Fixed
Description
DDLGen creates the partition condition section, it is all bunched together
Workaround Description
 Manually edit the script to make it more readable.



CR:549423
CR Number:   549423
Product Name:   Adaptive Server Enterprise
Product Component:   Pluggable_JVM
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2009 Fixed
Description
If the ASE PCI subsystem fails to start up then stack traces may be seen in the ASE errorlog and ASE may not boot.
Workaround Description
 disable PCI



CR:549429
CR Number:   549429
Product Name:   Sybase SQL Server
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   12.5.4 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_object_stats can be run on an offline database. If online database is run at the same time it is possible to hit error 834: Illegal attempt to clean buffer:
Workaround Description
 Do not run sp_object_stats on databases that are offline.



CR:549455
CR Number:   549455
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)
05 Dec 2008 Fixed
Description
A new monitor counter has been added for Replication Agent to monitor the number of times a schema is dropped from the cache in order to reuse the freed space.



CR:549472
CR Number:   549472
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
ASE does not raise a 2705 error in some cases when an attempt is made to ALTER TABLE

adding a column with a name that duplicates an existing column name.



CR:549486
CR Number:   549486
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2008 Fixed
28 Jan 2009 Fixed
21 Aug 2009 Fixed
03 Sep 2009 Fixed
Description
Opening a Foreign Key Wizard on a Solaris machine would resulted in an internal error for ASE Plug-in.



CR:549495
CR Number:   549495
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
The 'inserted' and 'deleted' trigger pseudo-tables cannot be referenced in derived tables within a trigger.



CR:549496
CR Number:   549496
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 Nov 2008 Fixed
13 Jan 2009 Fixed
Description
IF ASE is configured for 101 or more engines, sp_sysmon reports errors converting the engine number to a char(2).



CR:549497
CR Number:   549497
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 an ALTER DATABASE option that, on a fragmented disk, would allocate a single contiguous fragment if it was possible to do so, and otherwise minimize the number of fragments generated, rather than filling free areas from the beginning of the device forward.



CR:549639
CR Number:   549639
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)
13 Nov 2008 Fixed
14 Nov 2008 Fixed
Description
With statement cache enabled, it may be possible for the statement immediately after a while loop

that has just hit a break condition to not execute successfully - it only occurs if the sql is contained within a single batch.



CR:549641
CR Number:   549641
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
Infected with 11 stacktrace containing functions js__execute, exectrig, and rly_rowfmt occurs when an insert trigger on js_history table is fired.



CR:549694
CR Number:   549694
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 Fixed
25 Nov 2008 Fixed
Description
ASE may encounter a signal 11 in ub_postwrite() when there are delayed IO's and when extended cache is enabled.



CR:549724
CR Number:   549724
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)
09 Nov 2008 Not a Bug
Description
In 15.0.2.x, SHUTDOWN is not waiting for open transactions to complete before shutting down ASE, it is acting just like SHUTDOWN WITH NOWAIT.
Workaround Description
 Before issuing SHUTDOWN, verify there are no long-running open transactions in syslogshold to avoid lengthy recovery due to long-running open transactions.



CR:549741
CR Number:   549741
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 Dec 2008 Fixed
29 Jan 2009 Bundled Request
Description
When the global password complexity option 'min alpha in password' is set to -1, the random password generated through the password_random() built-in contains alphabetic characters.



CR:549825
CR Number:   549825
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2009 Not a Bug
Description
After installing according to the install guide, overlaying 15.0.2 in the same directory as 12.5.4, the ASE can not be started from services.

Pop up window:

Could not start the Sybase SQLServer _MY125 service on Local Computer.

Error 1053: The service did not respond to the start or control request in a timely fashion.

(click ok)



No error in the ASE errorlog.
Workaround Description
 Dump and Load migration on separate folders/hosts/drives or VM.



CR:549857
CR Number:   549857
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)
18 Dec 2008 Fixed
09 Jan 2014 Presently Not Targeted For Any Future Release Of This Product
Description
A 12313 error: "Internal error: Insert into page id <pageid> of index id <indid> of table '<tabname>' (id = <id>) in database '<dbname>' tried to replace undeleted RID (<pageid>,<rnum>) at slot <slotnum> and ridposn <ridnum>. Try dropping and recreating the index." can sometimes happen with deferred updates on a data-only locked table.



CR:549892
CR Number:   549892
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)
29 Jan 2009 Fixed
Description
Error 128 is raised when running sp_listener remotely.



CR:549902
CR Number:   549902
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)
17 Dec 2008 Fixed
Description
When statement cache is on, literal autoparam is on, and the server's default character set is either eucksc, sjis, eucgb, big5 or cp936, a query that contains TAB character before a select may cause incorrect select query to be cached, which may lead to syntax error if such query is recompiled.



CR:549927
CR Number:   549927
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2008 Fixed
Description
When reporting a stack trace on the Windows operating system, ASE will now also print an accompanying module dump, listing all the loaded external libraries and the path from where they were loaded, in order to aid problem diagnosis.



CR:549937
CR Number:   549937
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2009 Fixed
Description
On ia64 Itanium HP-UNIX and WinX64 platform, a GroupBy with more

than 32 groupby columns and with more than 6 joining tables might

hit signal 11 and stacktrace during the call of s_ap_compat_gen().

It could also happen for more than 32 groupby column query under

compatibility mode.



CR:549944
CR Number:   549944
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Inconsistent datatypes in MDA tables.



CR:550013
CR Number:   550013
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 Nov 2008 Fixed
Description
In some exception cases, prSQLTEXT() might SEGV when

called from terminate_process().



CR:550032
CR Number:   550032
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2009 Fixed
Description
SyConfig or SyBatch may receive a ct_fetch error when querying the status column of sysdatabases after the upgrade successfully completes.
Workaround Description
 disable database option(s)



CR:550075
CR Number:   550075
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)
07 Dec 2008 Fixed
19 Feb 2009 Fixed
Description
Boot time and LOAD DATABASE recovery might be unnecessarily slowed down

in cases where there are only a few long-running transactions at the time

the server was shut down or DUMP DATABASE was executed.



CR:550154
CR Number:   550154
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T: Query Processing and Abstract Plans
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2010 Presently Not Targeted For Any Future Release Of This Product
Description
"In some cases, command statements that include subqueries can also be formulated as joins and may run faster."



CR:550167
CR Number:   550167
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)
17 Nov 2008 Fixed
17 Nov 2008 Fixed
Description
If a cluster instance cannot successfully initialize the primary link at boot time, an attempt to drop another instance issued from the above instance may result in segmentation fault.



CR:550239
CR Number:   550239
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)
18 Nov 2008 Fixed
18 Nov 2008 Fixed
Description
In rare circumstances, in a cluster instance, if a query is being executed and the user tries to

cancel execution of the query by typing Ctrl-C in the isql, some of the locks acquired by

that query could remain unreleased and server could deadlock later.



CR:550255
CR Number:   550255
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)
01 Aug 2013 Insufficient priority to fix
Description
Feature Request: Add the option to include cache wizard when running a complete sp_sysmon.



CR:550273
CR Number:   550273
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2008 Fixed
14 Dec 2008 Fixed
23 Jan 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Stacktrace in ups__minorattributes doing update statistics on a temp table only exist in

12.5.x.



CR:550284
CR Number:   550284
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2008 Fixed
09 Dec 2008 Reservation Made
16 Apr 2010 One-off Provided
Description
When using sp_showplan to query another session's query plan, sometimes it could cause stacktrace with SIG11 or SIG4 in some platform. It could happen for a OPEN CURSOR,

BCP IN and when run time recompilation are needed.



CR:550290
CR Number:   550290
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 Nov 2008 Fixed
10 Feb 2009 Fixed
Description
An 832 error "Unable to place buffer <value> holding logical page ... there is no room in sdes

aux keep pool." or an 803 error "Unable to place buffer <value> from cache '<value>' holding

logical page ... either there is no room in sdes or buffer already in requested slot." when

reported will be followed by diagnostic information printed in the error log.



CR:550351
CR Number:   550351
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2009 Fixed
Description
On HPPA64 and HPIA64 platforms, if Java in Database feature is enabled in High Availability system,

failback operation results in a hang if Java was used prior to failback on the secondary server.

Secondary ASE errorlog reports "scheduler infected with signal 11" message with a stack trace that

includes keipanic().
Workaround Description
 [CR # 550351]

On HPPA64 and HPIA64 platforms, if Java in Database feature is enabled in High Availability system,

sp_companion stored procedure results in a hang if Java was used prior to running this stored procedure

on the server. ASE errlog may report "scheduler infected with signal 11" message with a stack trace that

includes keipanic().



The ASE errorlog file may contain a stack trace similar to:

00:00000:00023:2008/11/13 23:20:29.77 kernel Current process (0x1a001a) infected with signal 11 (SIGSEGV)

00:00000:00023:2008/11/13 23:20:29.77 kernel Address 0xc0000000000d2110 (si_code: 0x1, si_addr: 0x0000000100000010), siginfo (code, address) = (1, 0x0000000100000010)

00:00000:00023:2008/11/13 23:20:29.77 kernel kechkfault: engine 0: scheduler infected with signal 11 (SIGSEGV)

00:00000:00023:2008/11/13 23:20:29.79 kernel pc: 0x4000000003eceb80 pcstkwalk+0xf0(0x00000000001a001a, 0x0000000000000002, 0x000000000000270f, 0x0000000000000000, 0x0000000000000000)

00:00000:00023:2008/11/13 23:20:29.79 kernel pc: 0x4000000003ece170 ucstkgentrace+0x940(0x00000000001a001a, 0x0000000000000001, 0x6000000000468ab0, 0xc000000000000611, 0x4000000003dfae20)

00:00000:00023:2008/11/13 23:20:29.79 kernel pc: 0x4000000003dc8d50 ucbacktrace+0xf0(0x000000000000c378, 0x6000000000481340, 0x000000000000000b, 0x4000000000d62b00, 0x00000000000002c0)

00:00000:00023:2008/11/13 23:20:29.80 kernel pc: 0x4000000003dfae20 keipanic+0x110(0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)

00:00000:00023:2008/11/13 23:20:29.80 kernel end of stack trace, spid 23, kpid 1703962, suid 1



Workaround:

If the server is running with multiple engines, offline the engine

running the JVM prior to running sp_companion.



Use MDA tables to determine if the Java was used on the server and to which

engine the JVM is bound. For example, following query shows JVM is not active.



1> select * from master..monPCISlots

2> go

Slot Status Modulename engine

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

1 INIT PCA/JVM 0



(1 row affected)



In the example below, JVM is active and associated with engine 1



1> select * from master..monPCISlots

2> go

Slot Status Modulename engine

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

1 IN USE PCA/JVM 1





In this case you can offline engine 1 before running sp_companion.



1> sp_engine "offline", 1

2> go





If engine offline fails, or the server is configured for a single engine,

or if the server encountered hang when running sp_companion, then the server

should be restarted using cluster commands as below.



a] stop monitoring for the package.

cmhaltserv -v <pkg_name>



Make sure the package is still running on the same node where it was

running. The above command should kill the <pkg_name>.sh script and only

stop monitoring for the package, and not stop the package itself. You can

verify this by looking for <pkg_name>.sh in ps output.



Note that generally <pkg_name> corresponds to the companion server

where Java was used and sp_companion is about to be issued. Only exception

is when the secondary companion is in failed_over mode, in which case

<pkg_name> refers to that of primary companion.



b] halt and restart the package on the same node to reboot the ASE.

cmhaltpkg <pkg_name>

cmmodpkg -e -n <same_node> <pkg_name>

cmrunpkg -n <same_node> <pkg_name>



Use the cmhaltpkg, cmmodpkg and cmrunpkg commands to stop or start the

corresponding ASE packages in the cluster, as directly stopping ASE

result in unnecessary failovers. Refer to MCSG cluster documentation/man pages

for more details about the cluster commands, and

"Using Sybase Failover in A High Availbility System" for usage examples.



CR:550560
CR Number:   550560
Product Name:   Adaptive Server Generic Docs
Product Component:   Migration Guide
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
http://www.sybase.com/files/White_Papers/PlanningASE15Migration-040307.pdf



Section that reads:

Sybase is considering an enhancement in future release that will revert behavior (group by implicitly orders result).

In ASE 15.0 ESD #2, traceflag 450 makes group by use the classic (non-hashed) sort method, thus making

the result set order predictable again -- but at the possible cost of slower performance. In a later release, a new

"optimization criteria" language command "set group_inserting {0|1}" is being considered which will let you control

this on a session level -- and especially via login triggers -- without requiring trace flags.



Should read:



Sybase created an enhancement in 15.0 ESD #2 that reverts behavior (group by implicitly orders result). Global traceflag 450 makes group by use the classic (non-hashed) sort method, thus making the result set order predictable again -- but at the possible cost of slower performance.

In release ASE 15.0.1, with CR# 424188, a new "optimization criteria" language command "set group_inserting {0|1}" is available which will let you suggest this to the optimizer on a session level -- and especially via login triggers -- without requiring trace flags.



CR:550561
CR Number:   550561
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2009 Not reproducible with latest version of the product available as of Resolution Date
12 Feb 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Stacktrace occurs when a query is executed on the monProcessProcedures MDA table
Workaround Description
 Avoid queries on monProcessProcedures



CR:550607
CR Number:   550607
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2010 Fixed
19 Apr 2010 Fixed
Description
Skip opening and holding lock on sysconfigures for some config option; Skip starting an xact for some more config options.



CR:550634
CR Number:   550634
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2008 Fixed
19 Nov 2008 Fixed
Description
In rare circumstances, in a multi-instance cluster, if an instance crashes, object metadata

changed by the crashed instance may not be correctly recovered by the instance that does the failover recovery.



CR:550647
CR Number:   550647
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)
14 Jan 2009 Fixed
17 Feb 2009 Fixed
Description
On Solaris platform, Sun patch 119963-09 (SPARC), 119964-09 (x64)

(or higher) causes ASE fail to boot with "Segmentation Fault error (core dumped)."
Workaround Description
 Downgrade the OS to an earlier patch level.



CR:550692
CR Number:   550692
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2008 Added to user documentation
19 Jan 2009 Fixed
28 Jan 2009 Fixed
Description
The SQL template for Scalar Function Wizard and SQLJ Function Wizard incorrectly included the database name for the object name.



CR:550718
CR Number:   550718
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 to have optimizer make better use of OR clauses used with variables, ex. (@x = 1 or @x is null).
Workaround Description
 Use an IF statement for and explicit "choose plan"



if (@sys_id IS NULL) then begin

select trade_id from pct_bill..TRADES where dt= convert(smalldatetime, @dt, 118)

end

else begin

select trade_id from pct_bill..TRADES where dt= convert(smalldatetime, @dt, 118) and sys_id = @sys_id

end



CR:550737
CR Number:   550737
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2009 Fixed
13 Mar 2009 Reservation Made
Description
UPDATE INDEX STATISTICS sometimes generates a next-to-last step with a weight of 0, despite there being data in the associated value. This occurs when creating frequency

cells. So there are a relatively large number of rows that qualify for the associated

value.

A weight of 0 will lead to a row estimate of 1 and the optimizer will tend

to scan the associated table too early in the plan leading to poor performance.

Two problems have been indentified here. First, the boundary condition check for

building a frequency cell was off by one. Second, the calculations used to predict available steps for creating frequency cells was incorrect. The fix for these problems

is enabled through trace commandline flag 2715.



CR:550738
CR Number:   550738
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2008 Fixed
25 Nov 2008 Fixed
Description
When you are in a Simplified Chinese environment, the Adaptive Server plug-in returns a null pointer exception in the Scheduled Job Properties dialog.



CR:550740
CR Number:   550740
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Windows
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2012 Added to user documentation
Description
Installation Guide and Release Bulletin: you cannot upgrade 32-bit windows to 64-bit windows. sybmigrate only.



CR:550788
CR Number:   550788
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)
24 Nov 2008 Fixed
29 Jan 2009 Bundled Request
Description
Incorrect warning message is displayed when authentication mapping is overwritten for the same external user.



CR:550793
CR Number:   550793
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)
01 Oct 2009 Insufficient priority to fix
Description
Drop and create index can change Data page CR count only on 12.5.x
Workaround Description
 // will bring it back to update statistics value.

update index statistics t1

go



CR:550812
CR Number:   550812
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2008 Fixed
25 Nov 2008 Fixed
25 Nov 2008 Presently Not Targeted For Any Future Release Of This Product
04 Dec 2008 Fixed
Description
When no-sa role connect to Shared Cluster Server, instance folder can't display rightly in Chinese and Japanese environment.



CR:550820
CR Number:   550820
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)
21 Nov 2008 Fixed
21 Nov 2008 Fixed
Description
The license manager task that validates the license usage, being marked "critical" held a spinlock and didn't yield causing a set of other tasks that contended for the same spinlock to hit timeslice errors.



CR:550847
CR Number:   550847
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2008 Fixed
Description
If a UNION ALL operator is used in a derived table expression, then incorrect answers could result
Workaround Description
 use trace flag 4418



CR:550859
CR Number:   550859
Product Name:   ASE Replicator
Product Component:   Log Extract
Status:   Closed
OS:   Generic
Original Version:   15.0.1.411P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.2.421P2a-ONE_OFF 30 Mar 2009 Fixed
4.2.2 09 Apr 2009 Fixed
Description
ASE REPLICATOR: Replicator fails to parse a large

timestamp value, throwing the following

exception:

Cannot build locator from invalid hex string

<00000100f1d933c200000d6....0>

because: For input string: "f1d933c2".



CR:550872
CR Number:   550872
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)
29 Apr 2011 Fixed
Description
If using the application tracing functionality to trace a user and setting some option like 'set showplan on' and then when tracing is turned off for the user, the tracing option for the user is not reset and the tracing output is sent to the user's console.
Workaround Description
 Users can workaround this issue by actually turning off the options before setting the tracing off.



CR:550873
CR Number:   550873
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)
02 Jun 2011 Fixed
Description
Allowing all the set commands during app tracing can lead to unwanted adverse effect on the tracing session when options that can potentially alter the plan or the behavior of the query are enabled.



CR:550888
CR Number:   550888
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2009 Fixed
Description
In a multi-instance cluster, when a cluster instance is booting, in rare circumstances, a SIG 11 could be hit. A stacktrace would be reported and in the trace, strings like "dbt_get_oldestactive_pcm_callback" could be present.



CR:550917
CR Number:   550917
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2009 Fixed
01 Feb 2009 Fixed
Description
On linux systems, performance of some queries may drop when Q engines are online.



CR:550921
CR Number:   550921
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 Dec 2008 Fixed
02 Dec 2008 Reservation Made
10 Dec 2008 Fixed
Description
New option 'procedure deferred compilation' has been added so that the usage

of the deferred compilation feature could be switched on or of by the system procedure

sp_configure.



CR:550942
CR Number:   550942
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
setsuspect granularity on page level for runtime pages error as 6xx errors.



CR:550987
CR Number:   550987
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)
09 Dec 2008 Fixed
Description
Under some circumstances wrong results could be returned

when executing a query involving complex expressions with

several nested built-in function calls (like for example

IS_NULL(), STR_REPLACE(), CONVERT(), etc.) or long CASE

expressions.



CR:551004
CR Number:   551004
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
after upgrade of db from 12.5.0.3 to 15.0.2, 318 error on reorg rebuild unless you run delete stats before update stats.



CR:551014
CR Number:   551014
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have the hashbytes() function support the SHA-256 algorithm.
Workaround Description
 Implement hash function using java or sql based user defined function.



CR:551042
CR Number:   551042
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2008 Fixed
Description
In ASE running on the Windows platform, under conditions where ASE pool memory is running low, the java subsystem may report "EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x00000000"



CR:551059
CR Number:   551059
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 Feb 2009 Fixed
15 Jun 2009 Fixed
15 Jun 2009 Fixed
22 Jun 2009 Fixed
Description
Verify the log free space count discrepancies in the dbcc checkverify.
Workaround Description
 Execute: dbcc tablealloc("syslogs")



CR:551075
CR Number:   551075
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)
26 Feb 2009 Fixed
Description
Signal 11 in OptGlobal::GblSetInterestingTcIds which will terminate the process can be seen under specific circumstances when assigning a variable a column value from the select-list of a query on an external table with an order by clause



CR:551086
CR Number:   551086
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2008 Duplicate
Description
monOpenObjectActivity is not updated when a table is accessed via an index.



CR:551091
CR Number:   551091
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)
22 Feb 2009 Fixed
31 May 2009 Fixed
11 Jun 2009 Fixed
14 Jun 2009 Fixed
Description
If error(SIGSEGV, SIGBUS) occur at sampling, the engines will be halted.
Workaround Description
 1: start sybmon, attach to server and execute 'restart'

or

2: restart engines by hand



CR:551094
CR Number:   551094
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2009 Fixed
08 Apr 2009 Fixed
Description
Attempting to retrieve data inserted using a deferred INSERT command

for a table created with the "ignore_dup_key" clause and having TEXT

columns may fail with a fatal 7114 error reading "Page <Page Number>

is not a valid text page." together with a stack trace showing modules

"sendtext" and "get_txtpage".



CR:551215
CR Number:   551215
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2009 Fixed
Description
A task involved in sorting data hit an 890 error (state 6) in function sort_write



CR:551224
CR Number:   551224
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Linux
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Fixed
26 Nov 2008 Fixed
05 Aug 2009 Added to user documentation
18 Dec 2008 Fixed
Description
starting GUI installer failed in Red Hat 4 when set locale to Simplified Chinese
Workaround Description
 export _JAVA_OPTIONS="-Dswing.systemlaf=javax.swing.plaf.metal.MetalLookAndFeel" before running installer setup



CR:551246
CR Number:   551246
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2008 Fixed
27 Nov 2008 Fixed
14 Jan 2009 Fixed
14 Jan 2009 One-off Provided
Description
Error 5901 is hit while calculating the next cycle frequency for the scheduled job if its jsc_start is NULL in the js_callouts.



CR:551265
CR Number:   551265
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)
12 Dec 2008 Fixed
Description
A join condition between a NUMERIC and a nullable FLOAT may return true due to the truncation of the float value during implicit conversion.



CR:551299
CR Number:   551299
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
sddone errors on one database device containing one user database, and the rest of the ASE was unavailable until reboot of ASE. Requesting a feature to allow that one database to be offlined whiles the rest of the server continues to run.



CR:551337
CR Number:   551337
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Release Bulletin for HP
Status:   Closed
OS:   HP-UX
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2008 Fixed
Description
On HPIA, ASE process will be terminated if the UAF agent process is terminated by "Ctrl-C". Users should user uafshutdown.sh to shutdown UAF agent instead of doing "Ctrl-C".



CR:551417
CR Number:   551417
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
Increase maximum transaction name length to 255
Workaround Description
 Make sure transaction names are less than 30 characters



CR:551479
CR Number:   551479
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2008 Fixed
22 Jan 2009 One-off Provided
Description
On Windows High Availability companion node setup, either using "sp_companion" or the Microsoft cluster manager, the user encounters operating system error 5042 and the companion node creation never completes.



CR:551503
CR Number:   551503
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 Dec 2008 Fixed
Description
A 2540 error, "Table Corrupt: Page is allocated but not linked ...", may

be reported by DBCC CHECKALLOC some time after instance failure as a

result of recovery not completely cleaning up pending deallocations

resulting from a DROP command that happened just prior to instance failover.



CR:551539
CR Number:   551539
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)
14 Jan 2009 Fixed
Description
A 2805 error, "Bad pointer 0x4 encountered while remapping

stored procedure 'proc_name'. Must re-create procedure."

may be reported in the errorlog and also sometimes the

message "current process infected with 11" in the module

'qremap__mapptr' together with a stack trace which includes

the modules 's_getTreeOrPlan' and 'qremap_prochdr' when

executing a very big procedure which requires more than

24480 pages of memory.



CR:551553
CR Number:   551553
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2008 Fixed
Description
Under exceptional circumstances, execution of an ad-hoc sql statement with multiple OR conditions (in the order of 100s) with 'statement cache and 'enable literal autoparam' the server may hit a stack overflow which may bring the ASE down.
Workaround Description
 Reduce the number of ORs in the query or increase 'stack size' and 'stack guard size'.



CR:551577
CR Number:   551577
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)
24 Feb 2009 Fixed
10 Feb 2009 Reservation Made
Description
"usedb" may hang when "enable metrics capture = 1" is set and "number of open databases" is not configured high to accommodate all the databases. A stack trace would be reported in the error log which includes dbt__grab and metrics_dump.
Workaround Description
 Increase the number of open databases to avoid dbtable reuse/scavenging.

You need set the value to at least the value from select count(*) from master..sysdatabases.



CR:551595
CR Number:   551595
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.3 ESD#1 08 Dec 2008 Bundled Request
09 Feb 2009 Added to user documentation
Description
Allow users who do not have the mon_role role to select from the monLicense table.



CR:551596
CR Number:   551596
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)
06 Dec 2008 Fixed
Description
The errors 624 and 625 may occur while running queries that use RID Join

operator on APL tables.



CR:551677
CR Number:   551677
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)
05 Dec 2008 Fixed
Description
Extend traceflag 457 to also make READ ONLY cursors using DISTINCT select's globally insensitive.
Workaround Description
 MOdify all cursors - create them as insensitive.



CR:551702
CR Number:   551702
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2011 Insufficient priority to fix
Description
Feature request for sp_errorlog, to be able to reuse the current errorlog filename and that the existing errorlog filename is changed (similar to the cfg file).





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