远程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:564409
CR Number:   564409
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)
24 Feb 2012 Deferred
Description
Feature request to make reorg compact and reorg forwarded_rows not take exclusive table lock when it finds forwarded rows.
Workaround Description
 // avoid forward rows.



CR:564420
CR Number:   564420
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.3 ESD#2 26 Mar 2009 Duplicate
18 Mar 2009 Added to user documentation
19 Mar 2009 Fixed
Description
The default value of memory to allocate for Adaptive Server in the Out-of-the-box Configurator checks only physical memory, not available memory.



CR:564439
CR Number:   564439
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)
28 Apr 2009 Fixed
Description
The message reported in the ASE server log when the sybpcidb database does not exist has been

improved and now contains more information. The new message suggests that the sybpcidb database

may be missing, or it may need to be initialized with the installpcidb script.



CR:564478
CR Number:   564478
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2009 Duplicate
Description
Select on "monOpenObjectActivity" raises error 12035 when there is a DBName and ObjectName are greater than 30 characters each.



CR:564544
CR Number:   564544
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2009 Bundled Request
22 Mar 2009 Fixed
Description
Adaptive Server may raise an 893 error, "Fatal Error: Physical lock on <pageno>, <dbid> is being downgraded while the buffer is in dirty state. Please contact Sybase Technical Support." when it downgrades the physical lock on a buffer of a page that is not the last log page.



CR:564618
CR Number:   564618
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2009 Fixed
19 Jun 2009 Fixed
01 Sep 2009 Fixed
Description
The 'max memory' config parameter's default size is not enough to boot 16k server when pci is enabled on HP platform.



CR:564704
CR Number:   564704
Product Name:   ASE Management
Product Component:   Web Console
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2009 Fixed
26 Mar 2009 Added to user documentation
23 Apr 2009 Fixed
28 Apr 2009 Fixed
02 May 2009 Fixed
04 May 2009 Fixed
Description
If the tempdb database data or log segments on the monitored Adaptive Server become full the ASE Monitor displays incomplete data and the mouse cursor may remain in a busy state.



CR:564948
CR Number:   564948
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Request for using tarball for EBF/ESD distribution.



CR:564990
CR Number:   564990
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2009 Fixed
01 Apr 2009 Fixed
01 Apr 2009 Fixed
02 Apr 2009 Fixed
01 Apr 2009 Fixed
02 Apr 2009 Fixed
02 Apr 2009 Fixed
02 Apr 2009 Fixed
Description
The license agreement text cannot be loaded with the first geographic location during installation using GUI mode.



CR:565026
CR Number:   565026
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 Apr 2009 Fixed
Description
Incorrect results could be returned when executing a

query joining two or more tables having in its WHERE

clause a comparison between two expressions which

both result in a java object and the plan selected by

the optimizer decided to use a reformatting mechanism.
Workaround Description
 Disable reformatting for the query: execute it with "set store_index 0"



CR:565071
CR Number:   565071
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
Monitor table (MDA) that show service time for a device in ASE.



CR:565083
CR Number:   565083
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2009 Fixed
16 Apr 2009 Fixed
Description
The SySAM Administrator plugin only displays the last entry (count) in the license file

for a consolidated license file



CR:565091
CR Number:   565091
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)
15 Apr 2009 Duplicate
Description
Signal 11 at CgLavaUtils::CgTargetListExprs may occur

when running a query joining a local table with a proxy table

after update statistics has been run on the proxy table.



CR:565165
CR Number:   565165
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2009 Fixed
Description
For clusters with two or more instances, the message "timeslice error: spid" may be reported in

errorlog for the module cmcc__getphysicallock.



CR:565267
CR Number:   565267
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2012 Added to user documentation
Description
Document that in ASE the results of modulo have the same sign as the dividend.



CR:565272
CR Number:   565272
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2009 Fixed
02 Apr 2009 Fixed
Description
On HP, Error " Internal Error in the IP Link Monitor cannot determine a link state based on returned error 22" may report in the error log and cause link monitoring and link switch failures.



CR:565273
CR Number:   565273
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2009 Fixed
14 Oct 2009 Fixed
18 Nov 2010 One-off Provided
Description
signal 11 could happen in ResRelOp() during codegen when a constant

expression from a view or derived table is SELECTed from an outer

join view inner side and the constant expression is further participating

in a simple WHERE clause (comparison involving other constant only)

when the outerjoin view is queried.



CR:565276
CR Number:   565276
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)
24 Jun 2009 Fixed
Description
Under compatibility mode, traceflag 302 diagnostics might output

"unnamed-col" for predicate printing instead of the real column name.



CR:565310
CR Number:   565310
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2009 Fixed
01 Jun 2009 Reservation Made
Description
New configuration option "FIPS login password encryption" is added. Its valid value is 0/1. Its default value is 0.



CR:565321
CR Number:   565321
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2012 Fixed
Description
In parallel query mode, monProcessWorkerThread.ThreadsActive, monProcess.NumChildren, monSysWorkerThreads.PlansAltered and monProcessStatement.PlansAltered are always 0.



CR:565377
CR Number:   565377
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2010 Fixed
Description
The tracefile generated on NT and viewed from notepad does not have carriage return and appears that the whole content is printed in a single line.



CR:565392
CR Number:   565392
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2009 Third Party Problem
Description
On HP-UX platform, RTDS does not support IBM MQ SSL feature, if IBM MQ version is lower than 6.0.2.6.



CR:565393
CR Number:   565393
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
We need a facility to force through an increase in the number of partition descriptors on busy systems.



CR:565409
CR Number:   565409
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Sybase Central 15.0.2 ASE Plug-in doesn't start if you have connection profiles previously defined by 12.5.x ASE Plug-in. Remove "C:/Documents and Settings/<login>/.SCUserPreferences43" before upgrading to 15.0.2. to get around the issue.
Workaround Description
 edit the.scUserPreferences file and change value from true to false:

ConnectionProfileData/SYBASEASE/Autostart=false

After that, Sybase Central starts fine !

or

delete CUSERPREFERENCES files it will generate a new on

when it start.



Also SybaseCentral 6 (15.0.3) works.



CR:565420
CR Number:   565420
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2009 Fixed
09 Jun 2009 Presently Not Targeted For Any Future Release Of This Product
26 Apr 2009 Fixed
04 Aug 2009 Fixed
18 Aug 2009 Fixed
Description
upgrade from 15x to ARIES SMP fails



CR:565464
CR Number:   565464
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
ALTER TABLE ADD column raises error 13918 if a function specified for the default rather than

a literal value. The workaround is to use a literal value and then use ALTER TABLE REPLACE to

replace the literal value default with a function default.
Workaround Description
 First use a literal value for the default, then modify the default to be the function:



create table t (c1 int)

go

alter table t add c2 datetime default "1/1/1900" not null

go

alter table t replace c2 default getdate()

go



CR:565467
CR Number:   565467
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2009 Fixed
Description
sp_lock output shows negative spid ID for certain row locks



CR:565484
CR Number:   565484
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2009 Fixed
09 Apr 2009 Fixed
16 Apr 2009 Fixed
Description
Using a large value for 'max memory' and setting 'allocate max shared memory'=1 may cause the shared memory dump size to be much bigger than expected against SYBMON.
Workaround Description
 The bug was due to sybmon includes the unused memory in the memory dumps for some configurations.



To reduce the memory dump size so that it's close to the estimated dump size in sp_shmdumpconfig output, we may modify the configuration file to set 'max memory' based on the value of sp_configure 'total logical memory'.

Or

Set 'allocate max shared memory'=0.



CR:565504
CR Number:   565504
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2009 Fixed
Description
The rollback of a bulk insert operation on a table with TEXT columns may encounter a 3478 error. This situation may happen for UNITEXT, or TEXT columns in a multi-byte character set server.



CR:565507
CR Number:   565507
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2009 Fixed
31 Mar 2009 Fixed
Description
The recovery redo pass suffers from reduced performance during server boot,

cluster failover, LOAD DATABASE and LOAD TRAN, because asynchronous prefetch

is incorrectly disabled.



CR:565508
CR Number:   565508
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2009 Bundled Request
Description
The interrupt-based mechanism of acquiring the last log object lock by secondary BCM was not exercised.



CR:565566
CR Number:   565566
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2009 Fixed
Description
The command "sp_cluster logical, failover, <logical cluster>, cluster, <to instance list>" ignores the user specified "to instance list" and fails over to a system selected set of instances.



CR:565585
CR Number:   565585
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2009 Bundled Request
Description
A task trying to acquire a physical lock on a page tried to access the last log page pointer from the dbtable field and hit a signal 11 error.



CR:565638
CR Number:   565638
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2009 Fixed
Description
In an SDC environment with a large number of connections from different instances sharing the same database with concurrent DML operations, a hang can be observed where a thread in the module bufnewpage() is waiting for a buffer's MASS_DESTROY state to be reset.



CR:565647
CR Number:   565647
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2009 Fixed
31 Mar 2009 Fixed
Description
On HP-UX a command that writes data to an encrypted column may fail with a 15429 error message, "An internal error occurred when Adaptive Server was generating random data during an encryption operation. Please contact Sybase Technical Support."



CR:565674
CR Number:   565674
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2009 Fixed
Description
DBISQL incorrectly showed Plan Viewer menu item when connected to 12.5.x ASE. Plan Viewer is only supported for 15.x ASE or later.



CR:565677
CR Number:   565677
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
wrong results: update with sum(col2) returning incorrect results, and no error MSSQL raises a 157 error when this occurs



CR:565687
CR Number:   565687
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2009 Fixed
05 Oct 2009 Fixed
Description
ASE Cluster Edition instances may hang in case of an irrecoverable error, for which shutdown was triggered automatically from within the ASE.



CR:565691
CR Number:   565691
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)
08 Apr 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Error: 702 in memalloc when passed a bad column length.



CR:565728
CR Number:   565728
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2009 Fixed
20 Apr 2009 Duplicate
Description
Sig11 or assertion failure may hit when one instance is writing the config file and the other instance is trying to read the config file as part of booting the joint instance.



CR:565732
CR Number:   565732
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)
30 Mar 2009 Fixed
Description
SEGV occurs in ASE when accessing a proxy table and the remote server's connection is killed.
Workaround Description
 Use boot time trace flag 11297 (-T11297).

This enables ctlib API checking and it catches the problem and avoids the server crash.



CR:565752
CR Number:   565752
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)
25 Jun 2009 Fixed
Description
Add ability to kill process querying syslocks table.



CR:565828
CR Number:   565828
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2009 Fixed
Description
The attempt to failover to secondary LDAP server may fail silently (without a message in the errorlog) if the secondary URL and secondary access account details are not configured correctly.



CR:565834
CR Number:   565834
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2009 Fixed
30 Apr 2009 Fixed
01 Apr 2009 Fixed
09 Apr 2009 Fixed
07 Apr 2009 Fixed
13 Apr 2009 Fixed
01 May 2009 Fixed
Description
The last two charaters of binary data are truncated in 'text' results mode.



CR:565849
CR Number:   565849
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
20 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
20 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
DUMP DATABASE/TRANSACTION with the COMPRESSION= syntax can be slower than using the COMPRESS:: syntax



CR:565850
CR Number:   565850
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 to improve handling of level 0 scans by causing dba commands to block on

them rather than fail with an error, and to reveal their existence through a new lock

type entry in syslocks.



CR:565856
CR Number:   565856
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)
31 Mar 2009 Fixed
Description
When upgrading 1254 server to 1503 ESD#2, error 12324 is raised while upgrade steps [3 alter table (table sysindexes)] is being executed.



CR:565862
CR Number:   565862
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)
24 Oct 2013 Fixed
Description
Increase granularity of GRANT / REVOKE permissions for SA_ROLE or SSO_ROLE.



CR:565864
CR Number:   565864
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
Feature Request to include spid's listener IP and port in sysprocesses



CR:565865
CR Number:   565865
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2013 Fixed
Description
Feature request for a tool that would gather environment and diagnostic information typically needed by tech support.
Workaround Description
 Some diagnostic scripts [current as of March 2009) being developed by Chris McCartney are in /remote/cases/11516000s/11516704/pseinfo-11/Diagnostics



CR:565877
CR Number:   565877
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 May 2009 Fixed
Description
Message 14623 doesn't provide enough info for users to perform corresponding operations to continue

downgrade. It should provide more infomation like which objid and indid the row has.



CR:565878
CR Number:   565878
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Index is not used on tables in a view when view is joined in a query.
Workaround Description
 joins are not pushed down when aggregates are computed in the query.



One workaround is to create a temp table without the aggregates,

and then compute the aggregate on the temp table, but this

would only help if number of rows in the worktable are relatively

small.



CR:565938
CR Number:   565938
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2009 Fixed
Description
Adptive Server may hang during failover recovery if all cluster instances had high transaction activity at the time of node crash.



CR:565943
CR Number:   565943
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2009 Fixed
Description
'optdiag simulate statistics' utility could fail in a cluster environment.



CR:565961
CR Number:   565961
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)
26 Mar 2009 Fixed
Description
Execution of sp_configure to switch off the parameter 'procedure deferred compilation'

may not complete leading to stack trace.
Workaround Description
 Use trace 7730 to switch off the deferred compilayion.



CR:565964
CR Number:   565964
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2009 Fixed
Description
In rare circumstances, error message 14108, "Could not find partition descriptor for objid", may be reported in the errorlog while creating index on the table.



CR:566009
CR Number:   566009
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
Enhancement to RECOVERY_TIMEOUT functionality to distinguish between ASE online, production databases online and ignore irrelevant databases recovery rather than insisting that all databases recover within a certain time.



CR:566035
CR Number:   566035
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
Allow auto-extend feature to use additional "default" devices.



CR:566055
CR Number:   566055
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Release Bulletin for Linux
Status:   Closed
OS:   NA
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2013 Fixed
Description
A description of the use of trace flags 1648 and 1649; to enable direct i/o and Linux KAIO should be included in the documentation for 揜elease Bulletin Adaptive Server Enterprise 12.5.4 for Linux



If you are running 12.5.4 ESD1 or later on Linux 2.6 kernel, you can enable direct i/o for all devices by booting with traceflag 1648. This should be used in conjunction with 1649 to enable native Linux kernel async i/o.
Workaround Description
 N/A



CR:566192
CR Number:   566192
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2009 Fixed
Description
All the cache memory cannot be moved from default cache pool to a bigger pool as the default pool

should have at least 512k or 25 buffers whichever is greater. However in ASE Cluster Edition

this rule is broken when the cluster has more than single instance configured.



CR:566259
CR Number:   566259
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2009 Bundled Request
Description
Server Discovery failed in ASE Plug-in and SySAM Plug-in.



CR:566329
CR Number:   566329
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for future versions of ASE 15 to store more

information about backups in the MDA tables to track :-

- backup start/end time

- datasize - raw and compressed (if compression used)

- backup type



CR:566417
CR Number:   566417
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)
06 Apr 2009 Fixed
09 Apr 2009 Fixed
Description
If the number of elements in the IN list is larger than 128 and the IN list has mixed data type elements, it could cause wrong results. Normally it returns less rows than expected.
Workaround Description
 Use traceflag 15393.



CR:566575
CR Number:   566575
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2009 Fixed
Description
sp_version installmaster for 1503 ESD1 in NT platform won't get correct version info.

As while building installmaster in NT platform, it won't generate the statement that could insert

version info into sysattributes.



CR:566608
CR Number:   566608
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2009 DEFER
11 Nov 2009 Fixed
Description
If statement cache is enabled, the value of the global variable @@error will be reset if it is accessed in a batch together with a statement that gets cached.



CR:566628
CR Number:   566628
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2009 Fixed
04 May 2009 Fixed
Description
Under stressfull conditions, where concurrency between ASE Tasks and Commmercial Of The Shelf

JavaVM Threads execute, both operating for PCI Bridge managed memory, they could potentially

lockup because of a PCI Memory management flaw not yielding other ASE Tasks or Threads.

This problem could finally lead to an ASE server crash under shutdown or full hang when

in shutdown.



CR:566661
CR Number:   566661
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)
19 May 2009 Duplicate
Description
New feature requested to enable deferred compilation to be switched off at a session level.
Workaround Description
 N/A



CR:566676
CR Number:   566676
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Configuration Guide for UNIX
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2009 Fixed
Description
docs: sysam users guide needs clarification on 3 srvr redundant configs



CR:566712
CR Number:   566712
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for an architectural change in backupserver that would allow more independence in the loading of dump stripes.
Workaround Description
 Dump to multiple stripes but only use one for loading.



CR:566767
CR Number:   566767
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2009 Fixed
Description
A task trying to acquire a physical lock on a page exhausted the clock ticks beyond the allocated value and hit a timeslice error.



CR:566782
CR Number:   566782
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2009 Fixed
Description
NullPointerException in Automatic Expension tab if ASE > 2K page server.



CR:566822
CR Number:   566822
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 712 when try to handle a Big Xml file



CR:566882
CR Number:   566882
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)
27 Apr 2009 Fixed
Description
Modifying a segment's auto expansion attributes (grow-by or max-size) results in a syntax error.



CR:566926
CR Number:   566926
Product Name:   Adaptive Server Enterprise
Product Component:   mscs_ha
Status:   Closed
OS:   Windows W2k
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Cluster Administrator cannot browse path of setup log on Windows Server 2003 with MSCS 5.2.

An option is checked and cluster setup log is saved.

In order to browse path of setup log in the following steps, when the "Browse..." button is clicked, Cluster Administrator will fail often.A Cluster Administratoe process will be extinguished.



CR:566981
CR Number:   566981
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2009 Fixed
Description
Signal 11 in GtuUnion::GtSecondaryInit() may be seen in the error log

and the spid terminated when selecting from a view containing a union all

and the select includes > 1 variable assigment from the same column.
Workaround Description
 --in 15.0.3 ESD#1 or higher

set compatibility_mode on



CR:566990
CR Number:   566990
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)
02 Jul 2009 Fixed
12 Feb 2010 Bundled Request
Description
sp_object_stats "00:01:00" does not produce output in version 15.0.x even if you have contention.



CR:566992
CR Number:   566992
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)
01 Apr 2009 Duplicate
Description
There are 4 tables created by installmaster having ids > 100. The indexes on these tables are not automatically rebuilt when the sortorder id is changed. This results in corrupt indexes existing in the server.



CR:567039
CR Number:   567039
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2009 Fixed
Description
Upgrade to ASE 12.5.4 fails to add encryption-related tables and columns if the server has previously been downgraded from ASE 12.5.4 to ASE 12.5.3 or earlier versions.
Workaround Description
 Bring up ase1252 and enter following sql:



sp_configure "allow updates",1

go

delete from sysattributes where class = 1 and attribute > 1411

go

sp_configure "allow updates",0

go

Then reboot using the ase1254 server.



Of course, always make certain to have a backup before starting.



CR:567056
CR Number:   567056
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)
08 Apr 2009 Fixed
08 Apr 2009 Fixed
08 Apr 2009 Fixed
Description
Japanese, Korean and Chinese localized files for HA support on Windows platform (sybcaeja.dll, sybcaeko.dll, sybcaezh.dll) are missing in ASE 15.0.3 release.



CR:567093
CR Number:   567093
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature request to estimate the log space needed to perform reorg rebuild on a table.



CR:567117
CR Number:   567117
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)
24 Apr 2012 Added to user documentation
Description
DOC CR : The behavior of sp_rename has been changed. If you change the name of an object referenced by a stored procedure or view, the procedure or view will not work any more.



CR:567187
CR Number:   567187
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for two new variables to enable the current setting of rowcount and forceplan, as set by the statements: 憇et rowcount n and 憇et forceplan on/off
Workaround Description
 N/A



CR:567201
CR Number:   567201
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2013 Duplicate
Description
Request for a verbose mode for sp_js_wakeup that would provide more information about failure to start JS, currently available via traceflag 3641



CR:567239
CR Number:   567239
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2009 Fixed
22 Apr 2009 Fixed
Description
Due to an issue with underlying dbcc checktable, sp_post_xpload can not detect all kind of index

corruption, such as first key of one non-leaf page is bad. The new 'force' option of

sp_post_xpload will force rebuild all the index except APL clustered index.



CR:567257
CR Number:   567257
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2009 Fixed
Description
A deadlock may be incorrectly reported when there are many transactions holding shared lock on one

object and waiting to acquire lock on another remote object. This is due to limitations in the

deadlock detection algorithm. Optimization has now been added so that the algorithm will continue

with deadlock detection if tasks holding shared lock are waiting on less than 9 distinct remote

objects.



CR:567316
CR Number:   567316
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
xp_cmdshell on windows fail to execute the windows prompt command copy when this use options /B /Z and the file have a size of ZZZ MB.



CR:567317
CR Number:   567317
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)
11 Apr 2009 Fixed
10 Apr 2009 Reservation Made
15 Apr 2009 Fixed
Description
DISTINCT query in 12.5 uses EXISTS table (i.e. semi-join), 15.0.x does not use a semi-join, which results in poor performance. A semi join can be used for tables in DISTINCT queries which are not referenced in the SELECT list
Workaround Description
 rewrite the query into an EXISTS query for those tables which are not in referenced in the SELECT list



CR:567325
CR Number:   567325
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)
09 Apr 2009 Fixed
27 Apr 2009 Not a Bug
20 Jul 2009 Fixed
02 Aug 2009 One-off Provided
20 Sep 2009 Fixed
20 Sep 2009 Fixed
Description
FAST BCP path into table with numeric non-clustered index (available in 15.0.2 and higher) may result in index corruption
Workaround Description
 sp_dboption '<db>','select into', false



CR:567355
CR Number:   567355
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)
07 Apr 2009 Fixed
Description
DDLGen generates an incorrect "go" between the two ENDs for dropping the primary key and the foreign key.



CR:567454
CR Number:   567454
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
Feature request for a resource governor enhancement that would allow databases to be bound to engine groups, i.e. cause activity involving just that database migrate to a specified engine group.



CR:567466
CR Number:   567466
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)
22 Apr 2009 Fixed
16 Feb 2010 Fixed
Description
When statement cache is turned on, if an exception occurs while compiling a statement which has temporary tables in it, an error msg 8203 could be raised.
Workaround Description
 The workaround for this is:



1. use command line traceflag 467:

If TF 467 is on, statements referencing temp tables will not be cached.



2. use command line traceflag 299:

This only work if there is already a successfully compiled plan in cache.



CR:567477
CR Number:   567477
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2009 Fixed
22 Apr 2009 Fixed
Description
SQL statements whose lengths are larger than 1K (measured in characters)

that are replicated using SQL Statement Replication may cause Rep Agent to

shutdown with error 9202, State 1 when attempting to process log records

related to SQL Statement Replication.
Workaround Description
 Turn SQL Statement Replication off.



CR:567497
CR Number:   567497
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2009 Duplicate
Description
In rare cases, where there are huge number of parallel page allocations for the same object,

we might hit the 1127 error which means that the OAM pages of the object got full.
Workaround Description
 If a command hits this error, re-running the command should help



CR:567517
CR Number:   567517
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2009 Fixed
Description
(Internal Only) dbcc checkalloc may fail with errors because of faulty post commit processing at failover recovery if the database is dropped and recreated between two failover recoverys.



CR:567577
CR Number:   567577
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)
15 Apr 2009 Fixed
04 May 2009 Fixed
Description
Wrong result with a merge join or (if involving proxy table) signal 11 in

CgLavaUtils::CgTargetListExprs() might happen for query with an equi-predicate on

two columns of the same index.
Workaround Description
 set merge_join off --for the session



plan '(use merge_join off)' --for the query



CR:567656
CR Number:   567656
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   RH Linux
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2009 Fixed
21 Aug 2009 Fixed
28 Aug 2009 Fixed
Description
The Monitor Server can hang on the ibmplinux redhat 5.1 platform.
Workaround Description
 kill the hung monintor server process, and then restart monintor server.



CR:567757
CR Number:   567757
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2009 Fixed
Description
Allow one master device to be paired with multiple quorum devices using the --create-cluster-id=quorum boot option. Pairing a master with multiple quorums is dangerous and should be avoided in most cases.



CR:567766
CR Number:   567766
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)
23 Jul 2009 Fixed
19 May 2009 Fixed
03 Jun 2009 Fixed
Description
RepAgent may send an incomplete multi-byte character in text data to Replication Server

when the text data is longer than 4KB and starts with an XML declaration element and

contains multi-byte characters.



CR:567782
CR Number:   567782
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 Apr 2009 Fixed
29 Apr 2009 Fixed
04 May 2009 Fixed
Description
With Literal Autoparam and Statement Cache enabled, using a query with an IN list having numerics with a scale different from the scale defined on the column causes poor performance.
Workaround Description
 For this specific query, turn off the 'literal autoparam'. For exampel:



set literal_autoparam off

go

run the this query



set literal_autoparam on

go



Or



Change the data to use int as the column definition is numeric(18,0).



CR:567787
CR Number:   567787
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)
13 Jul 2009 Fixed
17 Jul 2009 One-off Provided
Description
When statement cache and literal autoparam are enabled, a batch that contains \r\n (CR NL) sequence in the middle of two statements, the statement that right after \r\n sequence may not get correctly parameterized, offset may be shifted 2 bytes on the left.
Workaround Description
 Disable literal autoparam





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