远程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:499407
CR Number:   499407
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2008 Fixed
11 May 2008 Duplicate
Description
increasing/decreasing size of default data cache only on 1 instance can corrupt master device.



CR:499408
CR Number:   499408
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jun 2008 Fixed
29 Jun 2008 Fixed
29 Jun 2008 Reservation Made
18 Aug 2008 Fixed
Description
When real time messaging is enabled on ASE to use MQ. The additional engine spawned to handle MQ tasks uses up very high cpu even when there is only 1 messaging operation.



CR:499413
CR Number:   499413
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2008 Fixed
Description
Include available sort order options all the time when using sqlloc with X.



CR:499448
CR Number:   499448
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)
16 Oct 2008 Fixed
08 Apr 2009 Fixed
Description
Procedural query with FOR READ ONLY option may incorrectly raise error 7304 "FOR READ ONLY can

not be used in a SELECT which is not part of the declaration of a cursor or which is not inside

a stored procedure"



CR:499455
CR Number:   499455
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)
14 Oct 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Dynamic partition elimination may not be applied, when processing an ad-hoc sql query or stored procedure, with variable SARGs and range predicates, against a table that has a composite partition key.
Workaround Description
 N/A



CR:499485
CR Number:   499485
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2008 Bundled Request
Description
On Windows platforms that have Virtual Adaptors the SySAM properties file can grow over time causing delays in startup.
Target Version
 15.0.3



CR:499490
CR Number:   499490
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2008 Fixed
Description
Compilation of an UPDATE query that contains a join and at least one IN-list or OR clauses

on the same column can choose deferred update mode, when direct update mode is possible.

As a result performance of the UPDATE query can be negatively impacted.

An example query is:



update t1 set c2 = 3 from t1, t2 where t1.c1 in (1,2,3,4,5,6,7,8,9) and t1.c2 = t2.d2



where table t1 is being updated and the query joins tables t1 and t2 and there is a IN-list

on column c1 of table t1.



CR:499532
CR Number:   499532
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance documentation of checkstorage faults.



CR:499539
CR Number:   499539
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jun 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
Error 15072 may occur on DBCC CHECKCATALOG command after DELETE STATISTICS and optdiag statistics in.



CR:499566
CR Number:   499566
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Open
OS:   all
Original Version:   15.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2008 Fixed
17 Jun 2008 Fixed
17 Jun 2008 Fixed
18 Jun 2008 Presently Not Targeted For Any Future Release Of This Product
17 Jun 2008 Fixed
Description
Remove Public/Private Network option in "Define Instance dialog" of CCW,AIW and Upgrade Server Wizard, only show a checkbox for Secondary Network option.



CR:499569
CR Number:   499569
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2008 Fixed
14 Oct 2008 Fixed
Description
In a well partitioned cluster, fail over recovery may spend unneeded time flushing

modified pages to disk at the end of recovering a database that is only modified on

the surviving node.



CR:499656
CR Number:   499656
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2008 Fixed
Description
Different messages are printed on error of dropping a login through sp_droplogin when ldapua is enabled and disabled.



CR:499659
CR Number:   499659
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
select from a view on archive db hits error 3906 on windows 64bit



CR:499694
CR Number:   499694
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2008 Bundled Request
Description
When a database operation (create, alter, drop, quiesce, mount, etc) is in progress, issuing a

"quiesce hold" command may result in error 2244 "Unable to open database dbname".

Error 2244 may also be raised when issuing a "quiesce" command on a database that is already in a 'quiesce' state.



CR:499704
CR Number:   499704
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
Request to improve diagnostic error messages in the errorlog by including more context information such as procedure or trigger name, line number in code, etc.



CR:499712
CR Number:   499712
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)
30 Sep 2008 Added to user documentation
Description
sp_audit doesn't allow "all" to be specified for login_name, raising an 18226 error.



CR:499747
CR Number:   499747
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2008 Fixed
26 Jul 2010 One-off Provided
Description
Jsagent opens the port on all IP addresses on machines that have multiple network interfaces.
Workaround Description
 No workaround.



CR:499810
CR Number:   499810
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)
04 Aug 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
lmlink hits signal 11 for getpage_noscan().



CR:499877
CR Number:   499877
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2010 Added to user documentation
Description
Requesting an additional 15.0 document on the resetting of the size of tempdb.
Workaround Description
 Ensure that tempdb fragment on master is at least 4mb.

alter database tempdb on master = 2

Then follow the steps in the 12.5.1 guide.



CR:499894
CR Number:   499894
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Improve documentation on how to use traceflags in the RUN_SERVER file. Multiple -T parameters can be passed to the dataserver binary. It is good practice to document what each flag is being used for.



CR:499895
CR Number:   499895
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2009 Bundled Request
Description
DBISQL not processing results when multiple results includes warning messages



CR:499935
CR Number:   499935
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2008 Fixed
Description
DBISQL 11 now sends multiple results to a single output file.



CR:499949
CR Number:   499949
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2008 Fixed
Description
On the Solaris platform, a core dump is encountered when the qrmutil program is run with short style arguments, e.g. -Q instead of --quorum_dev



CR:499961
CR Number:   499961
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Executing a SELECT statement with an AT ISOLATION 3 clause but without a FROM clause may lead to a stacktrace and termination of the users process.
Workaround Description
 Run any query containing a FROM clause before running the failing query.



CR:499982
CR Number:   499982
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)
21 Jul 2009 Fixed
29 Jul 2009 One-off Provided
Description
The message, "Current process infected with signal 11 (SIGSEGV)", may be reported in the errorlog together with a stacktrace which involves the modules '_StTcCharacterSample' and 'StTcMrgBnds' when executing a SELECT query with an IN list on encrypted columns.



CR:500001
CR Number:   500001
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2008 Not a Bug
Description
char_length () function returns incorrect value on text column with XML data



CR:500016
CR Number:   500016
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2008 Fixed
Description
In rare circumstances following failure of an instance, a surviving instance that is performing failover recovery might hang as a result of an undetected deadlock between the failover recovery process and another user process.



CR:500071
CR Number:   500071
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)
26 Jun 2008 Fixed
27 Jun 2008 Fixed
Description
Post-Commit Optimization performs poorly for transactions with large number of DELETEs.



CR:500116
CR Number:   500116
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2008 Fixed
27 May 2008 Reservation Made
06 Jun 2008 Reservation Made
Description
A 332 error may be reported during a query that involves multiple nested VIEWs below a UNION VIEW.



CR:500131
CR Number:   500131
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2008 Fixed
Description
Index suspect status is not set after lower version of database is loaded across platform where byte-order (endian type) is different.
Workaround Description
 Shutdown ASE (cluster) and restart after the first online after XPDL.



CR:500190
CR Number:   500190
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2008 Fixed
Description
sp_configure 'number of open indexes', 20000000 expects to get message

5861 but hits 10886.



CR:500198
CR Number:   500198
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Sep 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
Job Scheduler batches may fain with "Unclosed quote before the character string" errors and references to jsd_GetResults() and jso_FlushBuffer()
Workaround Description
 Playing around with the order in which commands are run can fix the problem.



CR:500299
CR Number:   500299
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2008 Fixed
Description
Page size information was not presented in ASE Plug-in. Now, server page size information is displayed in the server's General tab of the Properties dialog.



CR:500311
CR Number:   500311
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)
12 May 2008 Fixed
Description
A relocated join may get error 207 when joining on a column with upper case in the column name.
Workaround Description
 The issue is caused by a bug with the dynamically creating the proxy table in tempdb. The issue

can be avoided by doing a "create existing table" or "create proxy_table" in the remote server

to pre-define the proxy table that maps back to the local server. This is

recommended anyways for frequent users of relocated joins since it avoids the overhead of creating

the proxy table when the query is executed.



CR:500326
CR Number:   500326
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2008 Presently Not Targeted For Any Future Release Of This Product
Description
After applying ASE 15.0.2 esd #4, the output from backupserver -v is esd #3.



CR:500330
CR Number:   500330
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2008 Fixed
29 Aug 2008 Fixed
Description
sp_sysmon "app_only" stops reporting application detail after several hours



CR:500347
CR Number:   500347
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2012 Fixed
Description
Temporary files are not cleaned up after cluster creation.



CR:500404
CR Number:   500404
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2008 Fixed
Description
In some cases, the workload manager might allow connections to migrate when they should not.

This might cause some issues later when the process resumes on the new node.



CR:500463
CR Number:   500463
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)
08 May 2008 Fixed
11 May 2008 Duplicate
Description
Error 18177 might be raised by sp_cacheconfig if instance name is longer than 21 characters



CR:500474
CR Number:   500474
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 Apr 2009 Fixed
Description
In rare circumstances, Adaptive Server may give a time slice error with a stack trace which contains

modules 'cm__check_page_range' or 'cm_choose_buffer_pool'.



CR:500546
CR Number:   500546
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)
27 Jun 2008 Fixed
Description
Incorporated SQLTEXT printing for CREATE PROC, CREATE RULE, CREATE DEFAULT and CREATE TRIGGER statements when application tracing and show_sqltext options are turned on.



CR:500730
CR Number:   500730
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2008 Fixed
26 Jun 2008 Fixed
09 Jul 2008 Fixed
28 Aug 2008 Fixed
27 Aug 2008 Fixed
29 Aug 2008 Fixed
03 Sep 2008 Fixed
Description
1. In "Perference" page of "Adaptive Server Enterprise Plug-in Properties", there will be a switch for enable/disable check I/O fencing capability.

2. In "Specify Master Device page" of Create Cluster Wizard, there will be a dialog if specified devices do not have I/O fencing capability.

3. In "Specify the System Procedures Device" of Create Cluster Wizard, there will be a dialog if specified devices do not have I/O fencing capability.

4. In "Specify the System Database Device" of Create Cluster Wizard, there will be a dialog if specified devices do not have I/O fencing capability.

5. In "Specify Server Instances" of Create Cluster Wizard and Add Instance Wizard, there will be a dialog if more than one instance will be created on one host.

6. In "Specify Name and Path" page of Database Device Wizard, there will be a dialog to show if the specified device is I/O fencible.

7. In "General page" of Database Device Properties, there will be a label to show if the device is I/O fencible.

8. In "Device Information" of Add database wizard, there will be a dialog to show if the specified device is I/O fencible.



CR:500736
CR Number:   500736
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2008 Fixed
21 Aug 2008 Reservation Made
25 Aug 2008 Fixed
Description
Character data type table column in the SELECT list might return unexpected

trailing blanks when the column is involved in an equjoin with some character

data type expression. Also hash/merge join was not available between character data type

column equijoin under nocase sort orders.



CR:500816
CR Number:   500816
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2008 Fixed
Description
A 2622 error "Insufficient room on this page to insert a row of length ..."

may be reported in the error log together with a stack trace which includes

the modules 'dol_putdrow', 'undo_dol_delete', 's_renormalize' and 's_recrtproc'

while concurrent sessions write a new query tree in sysprocedures whereas

the current session needs to rollback its current work from it.



CR:500852
CR Number:   500852
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)
24 Oct 2008 Fixed
24 Oct 2008 Fixed
Description
A query with no reformatting and no sorting and only a

distinct_hashing or group_hashing operator may claim

too many buffers (typically the value of "max buffers per

lava op") as seen through the "set statistics plancost"

output.



CR:500872
CR Number:   500872
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2008 Fixed
22 Jul 2008 Fixed
Description
After a database dump and load, ASE may not be able to access the SQL UDFs created before the dump.



CR:500891
CR Number:   500891
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request to add information about fault severity and recommended actions to sp_dbcc_faultreport



CR:523659
CR Number:   523659
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2008 Fixed
12 May 2008 Fixed
Description
Booting of second ASE Cluster Edition instance may hang, if the first instance is simultaneousy doing write-activity (such as create table or inserts) in master database.



CR:523693
CR Number:   523693
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2008 Fixed
15 May 2008 Fixed
Description
Under rare circumtances , a deferred update of an APL table may result in a 2620 error: "The offset of the row number at offset <offset> does not match the entry in the offset table of the following page."



CR:523704
CR Number:   523704
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)
27 Jun 2008 Fixed
Description
While doing DISK MIRROR/REMIRROR/UNMIRROR for an inactive disk, a stacktrace with SIGSEGV may be reported.



CR:523730
CR Number:   523730
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2008 Fixed
Description
The message "timeslice -value, current process infected" may be reported

in the error log together with a stack trace which includes the modules

'clfr_recovernode' and 'clfr_recovery' during node failover recovery.



CR:523736
CR Number:   523736
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2008 Fixed
Description
A new option "number of alloc units" added to pageinfo() built-in to return number of allocation units allocated to an object, given the first oam page for the object.



CR:523759
CR Number:   523759
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2008 Fixed
17 Sep 2008 Reservation Made
Description
Adaptive Server doesn't support allocation of shared memory greater than 165 GB.



CR:528381
CR Number:   528381
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2008 Fixed
Description
The following message is seen in the error log upon server startup: "kernel Warning: Cannot resolve LDAP function ldap_search_ext_s".



CR:528407
CR Number:   528407
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)
15 May 2008 Fixed
21 Aug 2008 Fixed
22 Aug 2008 Fixed
Description
In some circumstances, Adaptive Server may throw a message "current process infected with 11, in the module CgpUnion::_CgpInitProjection, together with a stacktrace which includes modules like CgpMergeUnionAll::cgpInit", when a UNION ALL query is being executed.



CR:528442
CR Number:   528442
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)
05 Jun 2008 Added to user documentation
Description
LST dbs must not use private devices which are only accessable by an instance. Existing documentation is not clear enough in indicating the requirements for the LST devices. Currently the acts of creating and deleting the LST require that the devices be accessible from other instances.



CR:528447
CR Number:   528447
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2008 Fixed
16 May 2008 Fixed
Description
During failover recovery, undo phase may sometimes encounter 820 errors: "Attempt to dirty non-log buffer <addr> which is in I/O."



CR:528451
CR Number:   528451
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2008 Fixed
Description
In a shared disk cluster system following an instance failure, a 3478 error, " During undo the page timestamp value is less than new timestamp from log...", may be reported when recovering a database that has mixed log and data and asynchronous prefetch is on.



CR:528463
CR Number:   528463
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2008 Fixed
18 May 2008 Fixed
Description
692 error in DOL index scan restart could enountered in rare occasion.



CR:528470
CR Number:   528470
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request: In 15.0.2 ESD#2, make sp_help output more consisitent for materialized and not materialized (virtual) computed columns. Remove the 'materialized' keyword from the syscomments.text field for a materialized computed column.



CR:528474
CR Number:   528474
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)
13 Jun 2008 Fixed
Description
The cache creation/update operation using sp_cacheconfig succeeds but the server fails to reboot with new configuration



CR:528551
CR Number:   528551
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)
21 May 2008 Fixed
Description
Error 530 may be reported when using output from SQLJ function on outer column of a join.
Workaround Description
 Wrap the SQLJ function in an isnull().

Use a UDF.



CR:528604
CR Number:   528604
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2008 Fixed
17 Jul 2008 Fixed
Description
On the Solaris platform, ASE may encounter a timeslice error during boot if ISM (intimate shared memory) is in use and the amount of memory configured is approximately 100 Gb or more.



CR:528752
CR Number:   528752
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2008 Fixed
Description
request to document sp_addmessage with 'replace' option can only be run by the same login who created the original messasge



CR:528779
CR Number:   528779
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)
03 Jun 2008 Fixed
21 Oct 2008 Fixed
Description
DBCC CHECKSTORAGE records information in dbccdb that is not used in most cases.

This change reduces the number of inserts by skipping faults for which

an exclusion is defined with sp_dbcc_exclusions and skipping inserts in dbcc_counters.

The pre-fix behavior can be enabled using exec sp_dbcc_updateconfig null,

"enable excluded faults inserts", '1' and exec sp_dbcc_updateconfig null,

"enable dbcc_counter inserts", '1'



CR:528830
CR Number:   528830
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2008 Bundled Request
Description
Previously DBISQL11's OUTPUT command did not work in command-line mode. This has been fixed.
Workaround Description
 Redirect the output to a file:

dbisql.bat -host nstack-sun -port 5502 -c "UID=root;PWD=rooter" -nogui aut.sql > output.txt



CR:528833
CR Number:   528833
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2008 Fixed
Description
Previously DBISQL 9.0.2's PARAMETERS command did not work properly. This has been fixed in DBISQL 11.0.
Workaround Description
 Redirect the output to a file:

dbisql.bat -host nstack-sun -port 5502 -c "UID=root;PWD=rooter" -nogui aut.sql > output.txt



CR:528848
CR Number:   528848
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)
30 May 2008 Fixed
Description
For failed authentication, authentication mechanism is missing in login audit record.



CR:528854
CR Number:   528854
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2008 Fixed
23 Jul 2008 Fixed
Description
Auditing of dropping and adding user messages prints the database user name information in the "objowner" column of the audit record.



CR:528994
CR Number:   528994
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2008 Bundled Request
Description
Previously, DBISQL11 would report a synax error if you executed an INPUT, OUTPUT, or READ statement which was followed by "GO". This has been fixed.



CR:528997
CR Number:   528997
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2008 Fixed
Description
DDLGEN - Request to not return an error when extracting user ddl when only dbo user exists.

Currently it can return 'Critical internal application error' along with 'The specified User does not exist'



Sybase Adaptive Server Enterprise DDL Generator Utility/15.0.2/1/S/1.4.2/ase15x/Thu Dec 13 19:23:59 PST 2007



CR:529023
CR Number:   529023
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
simultaneous dump db and create idx lead to 701 in 12.5.4



CR:529026
CR Number:   529026
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2009 Fixed
Description
During instance startup, a set of three messages is logged, if a secondary interconnect is not defined for the cluster. Messages are: "The cluster interconnect protocol has not been defined in the cluster input file", "Cannot resolve host name '' for the local interface of the link to monitor", and "Cannot resolve host name '' for the remote interface of the link to monitor".



CR:529124
CR Number:   529124
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2008 Fixed
Description
Hit sig11 when dump new config file which is part of drop instance procedure.



CR:529155
CR Number:   529155
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2008 Fixed
Description
In rare circumstances , "current process ... infected with 11" may be reported in the

error log together with a stack trace which includes the modules

'ptn__setup_field_access', 'wrongpage' and 'sort_read' while ASE was in

the process of reporting error 696 "An attempt was made to fetch logical page

... Page belongs to <value> and not to <value> ..." due to a sort operation

having failed.



CR:529215
CR Number:   529215
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2008 Fixed
21 Jul 2008 Fixed
Description
The message "Invalid column length: <value>. Value must be between 0 and <value>

for 'data-only' row with minimum row length of <value>." may be reported in the

error log followed by a stack trace in module 'collocate' when the DBCC PAGE

command is run with the print option value of 4 on a datarows-only-locked table

that has variable length columns with a size value greater than 256. The modules

'prvarlen_cols' and 'prDOL_ROWS' will also be reported in the stack trace.



CR:529246
CR Number:   529246
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2008 Fixed
Description
Clients supportnig extended HA may receive a protocol error at login time if ASE is configured for LDAP directory services.



CR:529256
CR Number:   529256
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2008 Fixed
Description
Checkstorage may fail on 64bit platforms, with an arithmetic overflow error 247 followed by error 12964 DBCC cannot insert the row in the dbcc_operation_log table for this check of database '%s', aborting check.



CR:529327
CR Number:   529327
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2008 Bundled Request
Description
In rare circumstances for clusters with two or more instances, it may be possible for a

named cache to be deleted at some instance with out releasing physical memory.



CR:529398
CR Number:   529398
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)
01 Jul 2008 Duplicate
Description
Errors 913/225 on select of computed column that uses UDFs after load from database with different dbid



CR:529400
CR Number:   529400
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)
28 May 2008 Fixed
29 May 2008 Reservation Made
Description
When an encrypted column uses a key that requires an explicit password and has declared a decrypt default, then a reference to that column in a WHERE clause that uses an OR operator may return Error 15469 to a user who lacks decrypt permission.



CR:529481
CR Number:   529481
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2008 Fixed
17 Jun 2008 Fixed
24 Jun 2008 Fixed
Description
Instance failover recovery may hang when it tries to write modified changes to disk after the recovery redo pass.



CR:529508
CR Number:   529508
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2008 Fixed
22 May 2008 Fixed
19 Jul 2010 Fixed
22 Jul 2010 One-off Provided
Description
In rare circumstances following undo of an allocation, 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:529566
CR Number:   529566
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)
26 Jun 2008 Fixed
Description
New feature: Create a password_random() built-in that generates a random password which satisfies the password complexity "minimum checks".



CR:529627
CR Number:   529627
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a stored procedure sp_rebuild which would be similar to sp_recompile but would force a rebuild of compiled objects from the source code in syscomments rather than just a recompilation of the query plan.
Workaround Description
 Hi,

Boot the server with -T7706 and -T243

and:

create proc sp_redefine @name varchar(30)

as

select schema_inc(object_id(@name),2)

go



sp_redefine 'tablename'

go



will force the recreation from the text.



andrzej



CR:529699
CR Number:   529699
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2008 Fixed
26 Jun 2008 Reservation Made
13 Apr 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The message 2834 may be reported in the error log when an ALTER TABLE DROP PARTITION or

ALTER TABLE ADD PARTITION command is run while concurrent activity on the target table

takes place.



CR:529749
CR Number:   529749
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2009 Duplicate
Description
DDLGen can get confused when it tries to drop indexes before re-creating them if there are multiple indexes with the same name on different tables.



CR:529776
CR Number:   529776
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error 107 may be raised for the first execution of a stored procedure that performs a delete when the procedure code is inconsistent in the use of qualified table names, i.e. using a mix of owner.name and name references.
Workaround Description
 Be sure the table name in the where clause matches the table name after delete. See description for example.



CR:529787
CR Number:   529787
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)
22 May 2008 Fixed
05 Jun 2008 Fixed
Description
Unexpected results could be returned under some

circumstances when executing a query using CASE

expressions involving inside comparisons to

NULL literal values and ANSINULL session option

is not active.



CR:529788
CR Number:   529788
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Data corrupted when the view is not redefined after alter the table which uses user defined datatype.
Workaround Description
 Ct needs to drop and recreate the view betaal_trans. This will prevent data corruption and the wrong select result.



CR:529792
CR Number:   529792
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)
29 May 2008 Fixed
Description
Adaptive Server might terminate the execution of a query containing GROUP BY ALL and a subquery in the WHERE clause.



CR:529808
CR Number:   529808
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
configure certain databases as proxydbs in an HA environment.

Customer would like to be able to have some databases be local, and some proxy.



CR:529840
CR Number:   529840
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR requires some more restrictions for running "shutdown" command to avoid bring

a product server down by mistake.



CR:529913
CR Number:   529913
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2008 Fixed
Description
For clusters with two or more instances, too many cache bind operations may lead to server hang

in module cipcmsg_alloc() due to lack of free messages to be sent over network.



CR:530139
CR Number:   530139
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2008 Fixed
Description
Clients may get deadlock error occasionally while doing DML operations on same page from different instances in a cluster and in some case the deadlock may have been detected prematurely while waiting for the data to be transferred from another instance



CR:530184
CR Number:   530184
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2008 Fixed
Description
For clusters with two or more instances, cache update operation or instance specific configuration

in the presence of global configuration with size less than 255 pages can lead to successful

operation instead of failing.



CR:530186
CR Number:   530186
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)
06 Jun 2008 Fixed
Description
RIDjoin (for OR predicate) inner to outerjoin operator could sometimes lead to execution error message 623,624 or 806 related to retrieving a row via its RID.
Workaround Description
 set index_union off

go



CR:530220
CR Number:   530220
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2008 Fixed
14 Jul 2008 Fixed
Description
Kerberos logins with connection failover support fail to connect to ASE when HA is configured.



CR:530267
CR Number:   530267
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)
18 Dec 2008 Fixed
15 Feb 2009 Fixed
Description
Creating an index using the "with sorted_data" option on a partitioned table where the data is not actually sorted sometimes completes without error but creates a corrupt index with missing entries.



CR:530268
CR Number:   530268
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2008 Duplicate
Description
When both Primary and Secondary LDAP server have a failed status, rebooting ASE should reset their Active/Status to 慣rue,扲eady rather than leave both as 慒alse,扚ailed.
Workaround Description
 The client has to manually update the status of the LDAP servers to re-enalble LDAP connections at login.





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