远程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:638183
CR Number:   638183
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2010 Fixed
Description
Support LOB compression for UPDATE operations, including:

1) update with setting constant data

2) update with setting data from other columns

3) update with setting the column itself



CR:638193
CR Number:   638193
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2010 Fixed
Description
The replication of UPDATE query which is affecting some of the encrypted columns of a table may not work.



CR:638194
CR Number:   638194
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 2010 Fixed
20 Dec 2010 Fixed
21 Dec 2010 Fixed
05 Jan 2011 Fixed
Description
Support DBCC check utilities for compressed LOB columns.



CR:638212
CR Number:   638212
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2010 Fixed
Description
Replication may fail while trying to insert duplicate rows on the target site when normal TEXT/IMAGE columns of a table are converted to encrypted columns.



CR:638275
CR Number:   638275
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T: Basics
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2010 Added to user documentation
Description
In CR 325947, we expanded out the "by other" information in sp_sysmon to include "by unpin".

However, "by Log Marker" is another line item that has no description in the docs anywhere.



CR:638436
CR Number:   638436
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Fixed
Description
In a multi-node cluster, a shutdown with a timeout smaller than one hour could be sleeping for exactly one hour if any process in a remote node was sleeping and did not wake up to check if it had received an attention.



CR:638447
CR Number:   638447
Product Name:   Adaptive Server Enterprise
Product Component:   upgrade
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Report all SQL processing errors during upgrades.



CR:638454
CR Number:   638454
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE Bit datatype to support NULL or add boolean datatype to ASE so we support

this values "NULL, 0 ,1"
Workaround Description
 Do not use BIT datatype use some of the Integers datatypes.



CR:638488
CR Number:   638488
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2011 Fixed
26 Jan 2011 Fixed
23 Mar 2011 Reservation Made
Description
A SELECT query after USE DBNAME in the same line may look up a previous cached statement in another database and raise 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization."
Workaround Description
 Vicky's suggestions:



1) adding a 'go' after each 'use dbname'

or

2)specify dbname for the object name



CR:638556
CR Number:   638556
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)
30 Jun 2011 Fixed
19 Jul 2011 Fixed
Description
A 623 error, "Adaptive Server failed to retrieve a row via its RID in database '<dbname>'

because the target page is not a data page... pageno = 0 ..." may be reported during the

execution of LOAD TRANSACTION command using the WITH UNTIL_TIME option from a transcation

dump that was dumped using the WITH NO_TRUNCATE option.
Workaround Description
 Do not dump with no_truncate, OR

Use the not documented until_rid option

load tran <db> from <file> with until_rid = (<pg>, <row>)

where the rid value can be found using dbcclog command in sybmon



CR:638628
CR Number:   638628
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
doc bug: add circumstance to 913 error in Troubleshooting Guide



CR:638736
CR Number:   638736
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani beta3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2010 Fixed
13 Jan 2011 Fixed
08 Feb 2011 Fixed
02 Mar 2011 Fixed
18 May 2011 Fixed
14 Jun 2011 Fixed
Description
(Internal only) RAT: LTL enhancements for replication definition elimination.



CR:638743
CR Number:   638743
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2011 Added to user documentation
Description
NumRows is not documented in sp_spaceusage



CR:638779
CR Number:   638779
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)
27 Aug 2010 Fixed
Description
A stack trace may occur for queries with long GROUP BY lists greater than 32 keys.



CR:638786
CR Number:   638786
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2010 One-off Provided
20 Sep 2010 Fixed
13 Oct 2010 One-off Provided
13 Oct 2010 One-off Provided
18 Oct 2012 Fixed
Description
Parallel activity on tables related with RI constraints may lead to deadlocks



CR:638837
CR Number:   638837
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Bundled Request
Description
sp_spaceusage sets ExpRsvdPages and PctBloatRsvdPages to null when the reservepagegap being set to null



CR:638838
CR Number:   638838
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2010 Fixed
14 Sep 2010 Fixed
Description
Job Scheduler installTemplateXml.bat contains some syntax errors.



CR:638843
CR Number:   638843
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Fixed
Description
Total Task Switches reported by Task management section in sysmon report is inconsistent with sum of individual contributions on each engine for both SMP and CE servers.



CR:638972
CR Number:   638972
Product Name:   Adaptive Server Generic Docs
Product Component:   Utility Guide
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
referential_constraint_create_list_from_sql defines a list of foreign keys to migrate. If this parameter is set to <ALL_OBJECTS> then all foreign keys in the database will be migrated. If the parameter auto_select_dependent_objects is also set then any object that depends on the foreign key will be migrated.



When both referential_constraint_create_list_from_sql and table_create_list_from_sql are both set, both provide a list of objects to migrate. The list of foreign keys does NOT depend on the objects identified for migration by table_create_list_from_sql.
Workaround Description
 N/A



CR:639001
CR Number:   639001
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 Oct 2010 Fixed
11 Oct 2010 Fixed
Description
If one of the input row's length for a hash join exceeds the server's

pagesize and the hash join resorts to a nested loops strategy, then

wrong results could be returned. The input row's lengths can be determined

by running with trace commandline flag 9529.
Workaround Description
 [torr 17th sep 10 ]



tested t15393 and still getting no rows

/remote/cases/11620000s/11620426/pseinfo-12/Repro/query.dss_T15393.out



[sogden 17th Sep 10]



dbcc traceon (15393) --avoids the issue plan, reason tbc.



----

Workaround:



set distinct_sorting off --this will result in GroupSorted Distinct directly after the outer join which doesn't suffer the problem.



--or



set compatibility_mode on



CR:639030
CR Number:   639030
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2010 Fixed
Description
In SDC, when configuration option 'CIPC regular message pool size' is configured not

enough, user may hit error 8211 when try to access the table from remote node.



CR:639043
CR Number:   639043
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2010 Fixed
23 Jan 2014 EOL'd version. Not to be Fixed.
Description
For multiple node cluster, when there is only one instance left in the cluster, dropping a global database may fail due to corresponding locks are not able to be reclaimed.



CR:639045
CR Number:   639045
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2011 Fixed
Description
Under some rare condition, Msg 913 might raise when pagesize() is used with other builtin functions or UDF functions in a query.



CR:639046
CR Number:   639046
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2011 Fixed
03 Jun 2011 Fixed
07 Jun 2011 Fixed
05 Jul 2011 Fixed
07 Jul 2011 Fixed
31 Oct 2011 Fixed
01 Nov 2011 Fixed
Description
Localization is supported by MDA table. New Language columns are added to monTables, monTableColumns, monWaitEventInfo and monWaitClassInfo. User can use the where clause to specify the language for a query.



CR:639111
CR Number:   639111
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2010 Fixed
Description
During quorum creation time, any "additional run parameters" specified in the cluster portion of the input file will be incorrectly stored as the secondary interconnect protocol, preventing the Adaptive Server instance from booting.



CR:639158
CR Number:   639158
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for using of column alias in a WHERE, HAVING clause



CR:639227
CR Number:   639227
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Fixed
Description
The message "Received the following error message from the Replication Server:

Msg 2056. Line 1, character 8290: Incorrect syntax with ' '" may be reported

in the error log as a result of uninitialized database id.



CR:639234
CR Number:   639234
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2010 Fixed
22 Nov 2010 Fixed
Description
In a multi-node cluster, a SIGSEGV can be seen in the function lock__wait during alter database operation. The stacktraces in the errorlog would have strings like lock__common(), lock_object() etc.



CR:639254
CR Number:   639254
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error 9996\12905\12323 may be seen after non-clustered index creation on dol table.

The conditions leading to this are data specific and rare.

This may only occur on a non-binary sort order server.
Workaround Description
 dbcc traceon (12604) --disable suffix compression on create index



CR:639296
CR Number:   639296
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Sep 2010 Fixed
22 Sep 2010 Reservation Made
Description
When statement cache is on, a non-dbo user may access a dbo-owned table instead of

its own table when both tables are using same name and a previous access to the dbo

table was done.



CR:639428
CR Number:   639428
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2011 Duplicate
Description
Feature request for a method to change table ownership.



CR:639547
CR Number:   639547
Product Name:   SCC Web Framework
Product Component:   Repository
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2010 Fixed
15 Sep 2010 Fixed
Description
The LDAP login module was not including the roles read out of the LDAP server when mapping to uaf/scc roles (only the roles defined as login module options were included).



CR:639557
CR Number:   639557
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2010 Fixed
10 Nov 2010 One-off Provided
Description
With I/O fencing enabled AIX may encounter a timeslice if a lot of devices are used.



CR:639568
CR Number:   639568
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2010 Fixed
20 Sep 2010 Bundled Request
Description
If a high volume of connect/disconnects using client-side password encryption a SIGABRT

may occur with a stack trace with the following message:

"ks_falloc: Cannot allocate using ubfalloc"



CR:639579
CR Number:   639579
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Fixed
Description
Wrong parameters passed to error message 886 in the code, leading to garbage values in output.



CR:639652
CR Number:   639652
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2010 Fixed
03 Sep 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Adaptive Server 15.5 ESD #3 Removing duplicate wait even IDs and descriptions to monSysWaits and monProcessWaits monitoring tables to improve their wait event reporting and eliminating situations in which the same wait event ID was used to report more than one wait event.



CR:639702
CR Number:   639702
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2010 Fixed
01 Sep 2010 Reservation Made
03 Oct 2010 One-off Provided
Description
If the datachange builtin is used on sysobjects.name there is a possibility of a 706 error.
Workaround Description
 trace flag 15352 turns off expression histogramming.



CR:639802
CR Number:   639802
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2010 Fixed
Description
Allow column alias (AS clause) in subquery SELECT list. But the alias is not useful and

can't be referenced in other parts of the query. This is only to avoid syntax error.



CR:639811
CR Number:   639811
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2010 Fixed
12 Oct 2010 Fixed
Description
Adaptive Server 15.0.3 Cluster Edition hits error 866, when a cache configured with 'Relaxed replacement scheme' is accessed heavily.



CR:639813
CR Number:   639813
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2013 Fixed
23 Apr 2013 Fixed
Description
Execution of stored procedure 'sp_renamedb' from read-only database results in a 3906 error, "Attempt to BEGIN TRANSACTION in database failed because database is READ ONLY." Message should reflect that "You must be in master in order to run stored procedure for read-only database."
Workaround Description
 For read-only database, execute sp_renamedb from master and not from the database that will be renamed.



CR:639826
CR Number:   639826
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2010 Fixed
12 Oct 2010 Presently Not Targeted For Any Future Release Of This Product
11 Oct 2010 Fixed
10 Oct 2010 Reservation Made
Description
UNITEXT column values are not being translated correctly when loading a database dump that was taken on a Solaris system, into a database on a Linux system.
Workaround Description
 using at least 15.0 esd #13 version of bcp (CR 489378): bcp out from source, truncate table on target, bcp in. Or, use select into a new table before dumping on source.



CR:639852
CR Number:   639852
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2013 Not a Bug
Description
When the option 'set merge_join' is turned on, a join query on a remote column with a

different sortorder from the local column may get a wrong result.
Workaround Description
 Disable merge join via 'set merge_join off' for queries having both local table and proxy table if the two servers have different sort orders.



CR:639877
CR Number:   639877
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2010 Fixed
14 Oct 2010 Reservation Made
Description
Using the LIKE operator, ranges enclosed in square brackets containing embedded square brackets are not interpreted properly. Where '[x]' like '[[]x]' should evaluate to TRUE.



CR:639969
CR Number:   639969
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2011 Fixed
Description
A 530 message, "Attempt to insert NULL value into column <column_no> in work table (table id -<table_ID>); column does not allow NULLS. UPDATE fails." may be encountered when executing queries involving derived table and aggregation functions.
Workaround Description
 set compatibility_mode on

or

use temporary table instead of derived table.



CR:639976
CR Number:   639976
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Print procedure plan information from procedure cache



CR:639977
CR Number:   639977
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Fixed
16 Sep 2010 Reservation Made
Description
Under specific circumstances involving an outer join to a view\derived table containing

an aggregate (or possible other virtual expression) and a further outer join may result

in a sub-optimal query plan.
Workaround Description
 set compatibility_mode on



CR:640007
CR Number:   640007
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2010 Fixed
Description
An optional third argument has been added to the charindex() builtin function. This argument can be used to give a starting position within the string-to-be-searched that is passed to charindex().



CR:640009
CR Number:   640009
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2010 Fixed
30 Sep 2010 Reservation Made
Description
A single asterisk (*) is allowed to be used as a non-EXISTS subquery

SELECT list if the subquery is selecting from a single table/view/derived table

with a single column. It will function as SELECTing the single column explicitly.



CR:640014
CR Number:   640014
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2010 Fixed
Description
Allow multiple SELECT items for EXISTS subquery SELECT list. The existence test function

stays the same. Each of the multiple items will be treated the same way as with a single SELECT item for the EXISTS subquery.



CR:640221
CR Number:   640221
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2012 Fixed
04 Jul 2011 Duplicate
Description
Default/ specified log size may be incorrect when log is bound to a named cache
Workaround Description
 1) Run sp_logiosize to change the log io size after each reboot, or

2) Create a pool in default data cache with the same page size as the pool in the named cache.



CR:640224
CR Number:   640224
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2010 Fixed
Description
An unexpected colon may get appended to the dump file names when using a large number of stripes with

Backup API library.
Workaround Description
 Using native compression (with compression =) rather than the external library (compress::) may avoid

the problem.



CR:640259
CR Number:   640259
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2010 Fixed
Description
sp_displayaudit output does not include tables that have a negative sysobjects.audflags value (which indicates auditing of encryption_key operations).
Workaround Description
 Rewrite sp_aux_displayobjaud,



audflags > 0



should be replaced with



audflags !=0



(in 2 (all) places).



CR:640317
CR Number:   640317
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2010 Fixed
20 Sep 2010 Fixed
Description
When converting a very large unitext value into text where heap memory may run out,712 error will

be raised with sig11 from s_result_const_memfree->free__linkedcst->memfreeheap.



CR:640329
CR Number:   640329
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)
23 Sep 2010 Fixed
14 Oct 2010 Fixed
Description
In rare circumstances the message "current process infected with 11" in the module

'ptn_pdes_install' together with a stack trace which includes the modules 'dorecover'

and 'db__create_sysaltusages_map' may be reported in the error log when an archive

database is being recovered.



CR:640484
CR Number:   640484
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide an historical MDA table for monitoring stored procedure usage.

This table should provide similar information to what is contained in monSysStatement

and monProcessStatement. The data that is captured at the statement level in

monSysStatement will be aggregated to the stored procedure level.



CR:640541
CR Number:   640541
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2010 One-off Provided
06 Dec 2010 Fixed
Description
Error message 14702, "XMLPARSE(): XML parser fatal error <<An exception occurred! Type:RuntimeException, Message:The buffer manager cannot provide any more buffers>> at line <line_number>, offset <offset_num>" may be reported when parsing XML documents with large number of namespace prefixes.



CR:640552
CR Number:   640552
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2011 Fixed
Description
A mismatch between the Config Value and the Run Value will occur during booting of the

dataserver if a load of sybsecurity database had resulted in less tables than configured

for. The mismatch will be seen when executing sp_configure 'current audit table'.
Workaround Description
 set 'current audit table' to 1 before enable auditing after load sybsecurity database



CR:640630
CR Number:   640630
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2010 Fixed
05 Oct 2010 Fixed
20 Oct 2010 Fixed
Description
On windows only, although the t-sql builtin current_bigdatetime returns a bigdatetime, the microsecond portion is always zeros.



CR:640658
CR Number:   640658
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2010 Fixed
Description
Objects opened by cursor would be missing in monProcessObject while the open is being processed.



CR:640720
CR Number:   640720
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After you rename an index name on a proxy table by sp_rename system procedure,

update statistics command with the index name may raise a 2727 error.
Workaround Description
 Reboot ASE or run dbcc cacheremove(dbid, objectid)



CR:640768
CR Number:   640768
Product Name:   Adaptive Server Generic Docs
Product Component:   XA Guide for CICS Encina and Tuxedo
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2010 Added to user documentation
Description
CIS text length limitation warning is incorrect



CR:641055
CR Number:   641055
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #3 30 Nov 2010 Duplicate
15.5 ESD #3 30 Nov 2010 Duplicate
Description
srvbuildres/srvbuild will fail on solaris 10 machines which have ldm installed but not run
Workaround Description
 Two workarounds:

1. To remove the ldm file. Customer can't use it as they don't have the permission

2. export SYBASE_SAM_CPUINFO=OSCMDFORK before running srvbuildres.

This works for the customer



CR:641091
CR Number:   641091
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2011 Fixed
26 Jan 2011 Reservation Made
Description
When running "sp_configure 'mnc_full_index_filter', 3", which will set the optimizer criterion full_index_filter=1, a poorly performing plan may be generated in circumstances whereby a query is running under rowcount (or top) and the lead order by column doesn't have an entry in the predicate and is the lead key column of an index. In this circumstance, the index will not be costed and if this table is placed outermost in the plan, a complete scan of the table and a sort to generate the order prior to application of the row count is used.
Workaround Description
 set compatibility_mode on --sort avert should avoid the poor plan



CR:641109
CR Number:   641109
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)
13 Sep 2010 DEFER
08 Oct 2010 Fixed
21 Feb 2011 Fixed
08 Feb 2011 One-off Provided
18 Mar 2011 One-off Provided
20 Sep 2012 Fixed
Description
The message "current process infected with 11" in the module

'getvalue' together with a stack trace which includes the modules

's_retparams' and 'execproc' may be reported in the error log when

an INSERT statement is run on a table having an encrypted CHAR/VARCHAR

column, the configuration parameter "statement cache" is active and

the INSERT statement was previously cached but it had to be recompiled

or renormalized because, for example, all the query plans were in

use or the schema for the underlying table changed.
Workaround Description
 Disable statement cache



CR:641156
CR Number:   641156
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2010 Not reproducible with latest version of the product available as of Resolution Date
Description
Stacktrace occurs when a TDS fetch cursor command involving proxy columns is executed from external clients.



CR:641192
CR Number:   641192
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2011 Fixed
Description
Reboot of a cluster edition server may fail to recover local system temporary database, when model database is loaded from a lower server version dump, but not onlined before reboot. The errolog will contain message "infected with signal 11" in the module 'obj_id' along with a stacktrace which includes the modules 'recover_tempdb', 'upgd_upgrade_db'.



CR:641253
CR Number:   641253
Product Name:   SySAM
Product Component:   SyLAPI/C
Status:   Closed
OS:   Solaris
Original Version:   2.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2010 Fixed
Description
On Solaris, when ldm is installed but the connection fails (e.g. when the daemon is not running) a message similar to the following is raised and certain SySAM 2 enabled applications terminate: "Failed to connect to logical domain manager: Connection refused".
Workaround Description
 Two workarounds:

1. Ensure that ldm is usable or removed, i.e. remove the following utility or make sure the following command works:

/opt/SUNWldm/bin/ldm ls -l -p



2. Set the following environment variable before running the product installer. It should be set to nothing afterwards (SYBASE_SAM_CPUINFO=) or removed from the SySAM properties file:

SYBASE_SAM_CPUINFO=OSCMDFORK



CR:641258
CR Number:   641258
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2010 Fixed
Description
New functionality has been added that allows a dump of a database (other than the master

or sybsecurity databases), on a server running 15.5.x Cluster Edition, to be loaded into

a database on a server running 15.5.x non-Cluster Edition. This can be disabled using trace

flag 3411.



CR:641272
CR Number:   641272
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2010 Fixed
20 Sep 2010 Fixed
28 Sep 2010 Fixed
29 Sep 2010 Fixed
Description
ErrorNumber value is not correct in monErrorLog for some special messages.



CR:641445
CR Number:   641445
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request a functionality to generate an XML schema from part of an XML model



CR:641535
CR Number:   641535
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2011 Fixed
Description
sp_sysmon output may sometimes show negative value for the total task context switches due to "Other causes".



CR:641536
CR Number:   641536
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2010 Fixed
20 Oct 2010 Fixed
Description
In multi instance cluster setup when an instance fails, while performing instance failover recover, we may hit SIG11 with call stack having lock__rest_indoubt or hang where task keeps sleep waiting for the cluster lock request but there is no sign of request in the cluster.



CR:641613
CR Number:   641613
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2010 Fixed
07 Jan 2011 DEFER
Description
When configuration parameter "enable unicode normalization" is set to 0, UNIVARCHAR parameters to dynamic SQL statements are treated as having zero length, which is equivalent to a NULL value.
Workaround Description
 Change the ODBC DSN configuration parameter "Normalize Unicode Strings" to 1.

This will result in ODBC's converting Unicode strings to the server's character set,

which if configured to UTF-8 will result in no conversion errors.



CR:641679
CR Number:   641679
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2012 Fixed
Description
sp_helprotect truncates the objectname when it is greater than 30 characters.
Workaround Description
 Fix is to change the sp_helpproct procedure code



varchar size of objnae from 30 to say 60 in two places:

1) line #1012: create table #temp_obj(id int, number int, objname varchar(30))

to

create table #temp_obj(id int, number int, objname varchar(60))



2) line#1029: create table #temp(id int, number int, objname varchar(30), colnam

e varchar(30) null)

to

create table #temp(id int, number int, objname varchar(60), colname varchar(30)

null)



CR:641692
CR Number:   641692
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2012 Bundled Request
Description
sp_bindcache: allow indexes to use named cache the table is bound to as default



CR:641696
CR Number:   641696
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2010 Fixed
18 Oct 2010 Fixed
Description
The message "infected with signal 11" together with modules like "AnyOverUnderCheck(), StMergeHistCatalog::StmhApplyBoundary()" may be encountered when using update statistics on a bigdatetime or bigtime column.
Workaround Description
 Do not use bigdatetime/bigtime for columns where statistics are required



CR:641732
CR Number:   641732
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to restart ASE License heartbeat after it died.



CR:641735
CR Number:   641735
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)
17 Nov 2010 Fixed
17 Jan 2011 One-off Provided
17 Nov 2010 Fixed
21 Nov 2010 Fixed
Description
Cluster lock space rebuild takes lots of time and as CLM rebuild is blocking operation cluster is hung for several minutes.
Workaround Description
 "dbcc lockgc" helps reduce the time of the hang.



CR:641842
CR Number:   641842
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2011 Fixed
23 Nov 2011 Fixed
Description
When an invalid database dump is first loaded, a subsequent attempt to load a transaction dump will not report a useful error message to the end user.



CR:641955
CR Number:   641955
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 17870 from sp_indsuspect due to non-existance temp table for sp_autoformat



CR:642002
CR Number:   642002
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2010 Reservation Made
Description
CURRENT_TIMESTAMP is unsupported in ASE.



CR:642018
CR Number:   642018
Product Name:   Adaptive Server Enterprise
Product Component:   sql
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2014 Insufficient priority to fix
Description
In ASE, using TOP, it is possible to specify rows [1 ... N], but not to bias this to rows [M, M + N - 1].



CR:642023
CR Number:   642023
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2010 Fixed
17 Mar 2011 Fixed
Description
The values of InstanceIO column in the MDA table monStatementCache is incorrect when queried on SMP server.



CR:642038
CR Number:   642038
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2012 Fixed
17 Sep 2012 One-off Provided
Description
On Platforms other than x86 Linux and Solaris Sparc, the rdesmgr_spin spinlock was hot in some scenarios.



CR:642236
CR Number:   642236
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2011 Fixed
Description
A new option, LOG OFF, has been added to the ALTER DATABASE command to shrink log fragments.



CR:642331
CR Number:   642331
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2010 Fixed
08 Nov 2010 Fixed
19 Nov 2010 Fixed
Description
Installmaster 2901 error (Exception stack limit exceeded) and signal 11 stack trace against 15.5 ESD release on HP-UNIX Itanium and Windows x64 platform.
Workaround Description
 increase 'max nesting level' via sp_configure to get bigger exception stack



CR:642345
CR Number:   642345
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2010 Fixed
23 Jun 2011 Fixed
Description
Under some rare circumstances when the "no free space acctg" database option is not set, the time taken to recalculate the free space counts after an impolite shutdown can be unnecessarily long.



CR:642558
CR Number:   642558
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under certain circumstances, it is possible to execute an 憃nline database <dbname> while the same command is still executing. Executing he same online request twice can lead to errors being reported and the online command failing.
Workaround Description
 Avoid issuing multiple simultaneous 憃nline database <dbname> commands for the same database.



CR:642571
CR Number:   642571
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2010 Fixed
Description
A SELECT using an IN clause with more than 128 elements on a table with an

indexed encrypted column fails with an infected with 11 in stu_bincharinter
Workaround Description
 trace flag 15393 will avoid the problem.



CR:642735
CR Number:   642735
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2010 Fixed
Description
Sometimes, boot recovery takes long time due to synchronous reads on sysobjects table



CR:642776
CR Number:   642776
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2010 Fixed
08 Oct 2010 One-off Provided
28 Oct 2010 Fixed
21 Jul 2011 Fixed
18 Sep 2012 One-off Provided
11 Sep 2012 Fixed
Description
SELECT INTO proxy table may fail silently when inserting NULL into the proxy column.



CR:642812
CR Number:   642812
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #4 19 Dec 2010 Fixed
09 Feb 2011 One-off Provided
Description
In ASE燙luster燛dition, under some rare conditions, graceful shutdown of a cluster instance may crash the instance being shutdown and result in failover.



CR:642878
CR Number:   642878
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request for RepAgent Thread ... add clientname, clienthostname, clientapplname to LTL



CR:642992
CR Number:   642992
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Errors 21, 913, and 3413 may be reported during recovery if a user-defined recovery order has been defined using sp_dbrecovery_order and the configuration includes a dbid that no longer exists. The defined order is stored in sysattributes with class = 10 and attribute = 6
Workaround Description
 The recovery order is stored in sysattributes where class = 10 and attribute = 6.

Delete the entry for the missing database and adjust the ordering of the remaining rows.



CR:643035
CR Number:   643035
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request ... ASE add clientname, clienthostname, clientapplname in xact log records



CR:643041
CR Number:   643041
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 arrays and tables as native T-SQL datatypes that can be declared as variables, returned by user defined functions, etc.



CR:643124
CR Number:   643124
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When you copy a complex type which has other (complex/simple) types underneath, the result is that not only the top-level type is copied, but also all other types linked to it, too.

This however should not be the case.



CR:643125
CR Number:   643125
Product Name:   Adaptive Server Enterprise
Product Component:   preupgrade
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
preupgrade: should run dbcc checks on sybase system databases.



CR:643152
CR Number:   643152
Product Name:   SCC Web Framework
Product Component:   Navigation
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2010 Insufficient info provided
Description
Resources not always retained in perspective after logging off SCC.



CR:643168
CR Number:   643168
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2010 Fixed
15.5 ESD #3 12 Oct 2010 Fixed
Description
Transfer table command for import returns 'unknown error' while file is not found instead of ' error 2: No such file or directory'. There is no effect on the table.





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