远程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:343115
CR Number:   343115
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2004 Fixed
18 Feb 2004 Fixed
Description
Two processes setting up a site_handler may hit a race condition, causing a hang.

The hang will be accompanied by the message

"A call to srv__waitfor_read() was interrupted by an attention".
Workaround Description
 for the backupserver hang case,

sp_serveroption SYB_BACKUP, "timeouts", false

go

will help to decrease the possibility that we try to create

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



CR:343118
CR Number:   343118
Product Name:   Adaptive Server Enterprise
Product Component:   buildmaster
Status:   Open
OS:   HP-UX
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Include 11x_bmaster binary with ASE >= 12.5.x installs



CR:343120
CR Number:   343120
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2004 Bundled Request
Description
'number of dumps' counter of CSMD increments even if memdump is failed
Workaround Description
 "Reset the number of dumps by command - sp_shmdumpconfig 'reset', <type>, value"



CR:343252
CR Number:   343252
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2004 Fixed
Description
Querying the monCachedObject table can cause other processes to timeslice. When this occurs the query will take much longer to execute and the ASE errorlog will contain the error "timeslice -<value>, current process infected" followed by a stacktrace.



CR:343260
CR Number:   343260
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2004 Fixed
12 Mar 2004 Fixed
Description
If an @variable is buried in a nested derived table, it may lead to stack trace.



CR:343360
CR Number:   343360
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2004 Presently Not Targeted For Any Future Release Of This Product
24 Feb 2004 Fixed
Description
CIS: Local server may show stack trace when errors are encountered on sp_remotesql or

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

in 'remote i/o'.
Workaround Description
 Explicity run "set quoted_identifier on" before running sp_remotesql



CR:343363
CR Number:   343363
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2004 Fixed
Description
With ASE 12.5.2 ASEPlugin, the plugin parsing of template documents, JS Template schema and instance documents have been modified. The JS Template XML instance documents must be re-installed if users are upgrading from the ASE 12.5.1 ASEPlugin.



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



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



CR:343446
CR Number:   343446
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2004 Fixed
Description
Query using non intialized bit local variable may fail with error 245:

"Domain error during implicit conversion of BIT value '0' to a BIT field."
Workaround Description
 Assign some value to thelocal variable before running the query.



CR:343448
CR Number:   343448
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2004 One-off Provided
Description
INSTRUMENTATION: Network listeners disappear without error on

ASE 12.5.1 running on win2000 adv server



CR:343495
CR Number:   343495
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2004 Fixed
02 Dec 2004 One-off Provided
29 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
A 12536 message "Sysstatistics upgrade warning for table <table>. New row-length after upgrade,

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

reported in rare circumstances during an upgrade from a pre 12.5 server.
Workaround Description
 1.Use query from CR description to find the length of statistics rows

before upgrade

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

file using optdiag and restore them after the updrade.



CR:343514
CR Number:   343514
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2004 Fixed
23 Feb 2004 Fixed
Description
A query SELECT ...UNION ...SELECT may return incorrect result or hang if different UNION sides are executed with different degree of parallelism.
Workaround Description
 Problem did not occur

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

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

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



CR:343560
CR Number:   343560
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2004 Fixed
Description
Error 103, "The identifier that starts with "<constraint name>" is too long. Maximum length is 28." is

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

of 30 characters.
Workaround Description
 Use an APL table or shorten the identifier name



CR:343593
CR Number:   343593
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2004 Fixed
Description
Job Scheduler sp_sjobsetstatus commands embedded into a job's SQL were incorrectly operable on other job's besides its own. This has been corrected.



CR:343638
CR Number:   343638
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2004 One-off Provided
Description
INSTRUMENTATION: A stack trace occurs either in krtmsg or kaddmsg due to corrupted message queue.



CR:343644
CR Number:   343644
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2004 Fixed
Description
Text/image columns should not be listed on the second page of Index Wizard for creating a new index because they cannot be the columns of an index.



CR:343673
CR Number:   343673
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2004 Fixed
Description
ASE will incorrectly report the messages "WARNING: Pss found with open sdes ... range

entry <value> ..." or "WARNING: Pss found with open sdes ... system table entry

<value> ..." when a session hits a non-fatal internal error and a system or user table

has been left open mistakenly.



CR:343685
CR Number:   343685
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2004 Fixed
Description
sp_sysmon reports negative Cache Misses on a multi-engine server on NT platform when there is considerable load on the server.



CR:343707
CR Number:   343707
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2004 Duplicate
Description
XP Server sample xp_echo won't compile. Missing the Open Server header files.
Workaround Description
 Purchase an Open Server license to get the required files.



CR:343710
CR Number:   343710
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2004 Fixed
Description
Job Scheduler job output which contains "(return status = <status>)" may not be appropriately followed by starting a new line. This has been corrected.



CR:343729
CR Number:   343729
Product Name:   Adaptive Server Generic Docs
Product Component:   Transact-SQL Users Guide
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2006 Fixed
Description
XP Server documentation is outdated, incorrect and incomplete.
Workaround Description
 Call support for an explanation.



CR:343769
CR Number:   343769
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   macosx
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2004 Not reproducible with latest version of the product available as of Resolution Date
29 Sep 2004 Fixed
Description
For Mac OS X platform: When the Backup Server is shutdown normally, a message warning of possible memory corruption is written to the backup server errorlog. This problem has been corrected.



CR:343795
CR Number:   343795
Product Name:   Adaptive Server Enterprise
Product Component:   DBXray
Status:   Closed
OS:   Solaris
Original Version:   3.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2006 Fixed
Description
Invalid output problem using DBXray with non-English locales now has been fix via

BMC Bug #388263
Workaround Description
 When the ct later changed the OS language from spanish to english, the tool worked as intended.



CR:343799
CR Number:   343799
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2004 Fixed
Description
Under some circumstances when executing a client cursor

or a SELECT ... FOR BROWSE on a view, the base table column

names are returned instead of the view column names.
Workaround Description
 1. Client application can use descriptor returned when statement is declared (not after cursor is opened).

2. Code view to use convert() (or similar functions) to "hide" table column names.



CR:343826
CR Number:   343826
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2004 Fixed
Description
Use 'auditinit' to install Auditting capabilities may see the messages of "Task failed:

install auditing capabilities. Terminating configuration." on AIX platform.
Workaround Description
 Looking through the sub-case notes - sybsecurity db seems to be setup correctly with truncate log on checkpoint. So the workaround is to ignore the message.



CR:343958
CR Number:   343958
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2004 Insufficient priority to fix
Description
Feature request for a method to automatically propogate ALTER TABLE changes such as drop column, add column, and modify datatype on base tables to proxy table definitions



CR:343982
CR Number:   343982
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2004 Fixed
Description
Passing a serialized java object on a non Java enabled server causes signal 11



CR:343992
CR Number:   343992
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2004 Fixed
15 Aug 2004 Presently Not Targeted For Any Future Release Of This Product
Description
A 5807 error, "Invalid memory move request encountered for the <poolsize> pool in cache <cachename>" is reported when trying to configure a 4G pool on a 64 bit server.



CR:344012
CR Number:   344012
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2004 Fixed
22 Jan 2004 Fixed
Description
Stored procedure text stored in syscomments with strings of spaces may not be correctly retrieved with defncopy tool. Spaces may be missing in the defncopy generated file.



CR:344016
CR Number:   344016
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2004 Fixed
Description
The error 2812, "Stored procedure '"$monSysSQLText"'", will be raised when selecting from the MDA table monSysSQLText if quoted_identifier is enabled.
Workaround Description
 Set quoted_identifier off before running these queries.



CR:344097
CR Number:   344097
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2004 Fixed
Description
dump with compress option, when tape drive full not prompting for new tape
Workaround Description
 Not to use compression



CR:344164
CR Number:   344164
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2004 Fixed
Description
Dropping a proxy table which was mapped to an external directory with the ;R (recursive) option and recreating it again without it, still leaves the ;R option active.
Workaround Description
 Recycle ASE to clear option

or

Use another proxy_table name.



CR:344182
CR Number:   344182
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2004 Fixed
Description
Job Scheduler agent process may hang while processing a shutdown request if its Job Scheduler ASE shutdowns first. This has been corrected.



CR:344187
CR Number:   344187
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Bundled Request
Description
When using Sybase Central ASE Plugin to create a schedule on localized Chinese or Korean systems the error "com.sybase.jdbc2.jdbc.SybSQLException: Syntax error during explicit conversion of VARCHAR value '2004/1/20 と 1:56' to a DATETIME field." occurs (actual date values will vary).



CR:344209
CR Number:   344209
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2004 Fixed
06 Jul 2004 Fixed
Description
CIS: In some situations, a SELECT statement against a proxy table involving CASE and GROUP BY may have duplicate returns even if GROUP BY list is exactly the same as SELECT list.



CR:344299
CR Number:   344299
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2004 Fixed
Description
When object names are provided to parameterized LANGUAGE

statements and the datatype of the parameter is specified

as UNICHAR, conversion from UNICHAR to CHAR may not be correct

if the server's default character set is configured to something

other than UTF-8.



CR:344324
CR Number:   344324
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2004 Presently Not Targeted For Any Future Release Of This Product
26 Apr 2004 Fixed
Description
The error 10334, Level 18, State 80, may be raised if a procedure

contains a select into statement using a view created on table that

is recreated.
Workaround Description
 sp_configure "auditing",0



CR:344343
CR Number:   344343
Product Name:   Adaptive Server Enterprise
Product Component:   upgrade
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2004 Fixed
Description
Minor upgrade does not detect date or time user defined types that are upper case.
Workaround Description
 see email in CR descrition



CR:344349
CR Number:   344349
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2004 Fixed
Description
Sp_addtype should not allow user defined types with upper case versions

of system type names.



CR:344391
CR Number:   344391
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2004 Bundled Request
Description
Rows with blank PlanText should not be reported in monSysPlanText.



CR:344403
CR Number:   344403
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2004 Fixed
04 Jun 2004 Fixed
Description
A performance decrease may result when executing a query in a stored procedure that has to be recompiled and renormalized (for example due to a load database, an object recreation, etc.) and that query contains a search condition using a NUMERIC arithmetic expression (addition or

subtraction).
Workaround Description
 workarounds identified are:

(1) drop/create the sproc after dump/load

(2) change the sproc so an explicit convert(numeric(18,0),(@var +1)) or define @var as numeric(17,0) instead of numeric(18,0)

(3) use traceflag 291



CR:344416
CR Number:   344416
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2004 Fixed
Description
The error 18898 will be raised in the stored procedure 'sp_modifylogin' when setting up the login script if the length of the user's default database plus the login name exceed 27 characters.
Workaround Description
 Change the size of 'sqltext' in sp_modifylogin:

e.g. declare @sqltext varchar(255)



CR:344466
CR Number:   344466
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2006 DEFER
Description
When dump mulitple databases to a tape recieved "Tape will be rewound message" on Linux AS 2.1



CR:344484
CR Number:   344484
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2004 Fixed
26 Feb 2004 Fixed
Description
1> HAaseAgent Fails to start, errors saying libsybtcl.so not found.

2> when the HAase Agent online scripts start ASE, it starts as user "root" and not as user "sybase" and when Agent offline script trys to stop ASE , it is not stopped .

Platform: Linux



CR:344561
CR Number:   344561
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Linux
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2004 Fixed
Description
The message "Incorrectly built binary which accesses errno or h_errno directly. Needs to be fixed." appears when srvbuild and other ASE utilities are run on Red Hat Enterprise Linux 3.0.



CR:344578
CR Number:   344578
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2004 Duplicate
08 Feb 2004 Duplicate
Description
Clients sometimes get unable to connect errors when there are high numbers of connection requests to an ASE using the sockets nrt library.
Workaround Description
 Use the TLI driver as this has a backlog of 128



CR:344620
CR Number:   344620
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2004 Fixed
05 Feb 2004 Fixed
13 Aug 2004 One-off Provided
Description
CIS: In some circumstances, a multi-engine server may be infected with signal 10 or 11 and

core dumps, or causes ASE to hang after running sp_showplan.
Workaround Description
 No workaround except to run ASE in mono-engine mode.



CR:344650
CR Number:   344650
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Linux
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2004 Presently Not Targeted For Any Future Release Of This Product
21 Jun 2004 Presently Not Targeted For Any Future Release Of This Product
Description
backupserver hangs during load of striped database on Linux AS 2.1
Workaround Description
 Don't do a striped load/dump.



CR:344713
CR Number:   344713
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2004 Fixed
08 Mar 2004 Fixed
02 Apr 2004 Fixed
Description
When inserting data using BCP into a table with a DEFAULT

value defined on a VARCHAR column and the file to load does

not specify value for that column, the DEFAULT value inserted

into the table is silently truncated to 30 chars.
Workaround Description
 After bulk copy in, run update on columns that contain the truncated value (assuming that value is unique!).



CR:344722
CR Number:   344722
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2004 Fixed
Description
If command line trace flag 11906 is turned on, informational messages from REORG will no longer be printed to the errorlog.



CR:344729
CR Number:   344729
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a unique constraint on sysloginroles (suid,srid)



CR:344752
CR Number:   344752
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2004 Fixed
Description
The list of engines in the output of the system stored procedure sp_showcontrolinfo is truncated

when there are more than 5 engines bound to a certain engine-group.



CR:344805
CR Number:   344805
Product Name:   ASE Replicator
Product Component:   Distributor
Status:   Closed
OS:   Generic
Original Version:   12.5.0.109P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.0.0 24 Feb 2004 Fixed
Description
ASE Replicator: A replicate stored procedure with nocount set off that contains a SELECT and a RAISERROR does not stop replication if the RAISERROR fires.
Workaround Description
 Add as first line in a replicated stored procedure the clause

"set nocount on"



CR:344840
CR Number:   344840
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2004 Fixed
Description
srvbuild, srvbuildres, syconfig.exe, and sybatch.exe adds XP server as "ASEnterprise" server class. XP server should have "RPCServer" server class.



CR:344983
CR Number:   344983
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2004 Fixed
24 Mar 2004 Fixed
Description
Feature extension.



Before this fix the XML builtin xmlparse retuned the result xml fragment as image datatype. The fix adds the ability to return the result xml fragment also as varbinary/binary datatype using additional 'returns' clause syntax.



Before this fix the XML builtin xmlextract returned the result xml data as either text or varchar. With the fix the user will be able to return the result xml data as java.lang.String also.



Before this fix the XML builtin xmlrepresentation accepted xml documents only as image datatype as one of its operands. With this fix user can now pass xml documents of varbinary/binary datatype also to this builtin.



CR:345007
CR Number:   345007
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2004 Fixed
18 Feb 2004 Fixed
25 Feb 2004 Diagnostic Provided
Description
Error 102, "Incorrect syntax near '?'." is raised when a prepared statement is executed using JDBC

having ANSI-style comments at the end of the command string sent from the client.
Workaround Description
 None. Have to revert back to ASE 12.5.0.1



CR:345045
CR Number:   345045
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   macosx
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2004 Fixed
Description
On the Mac OS X platform the ServerDiscovery tool has been enhanced to display Replication Server.



CR:345056
CR Number:   345056
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Fixed
Description
The StartTime and EndTime columns in monSysStatement have a resolution of a second. This is not acceptable for measuring statement statistics so the resolution should be at least that of the DATETIME datatype.



CR:345067
CR Number:   345067
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2004 Fixed
Description
Job Scheduler agent process does not properly shutdown if its Job Scheduler ASE shutdowns while the agent is still processing a startup request. This has been corrected.



CR:345175
CR Number:   345175
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
To Be Determined 16 Feb 2004 Fixed
08 Apr 2004 Fixed
Description
Multi-engine ASE does not always wake a comatosed engine in a timely manner when there is

work ready for that engine.



CR:345193
CR Number:   345193
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Fixed
10 Nov 2005 Fixed
Description
The ASE server 1601, "There are not enough 'user connect

ions' available", followed by the connectivity errors

11216 and 11206 will be raised, if trying to access an

MDA table from within a user's login script.



CR:345260
CR Number:   345260
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Fixed
Description
ASE running on Windows platforms may suffer loss of the listener process, without any stack trace or error message.



CR:345272
CR Number:   345272
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.8 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2004 Fixed
23 Aug 2004 Fixed
Description
In rare circumstances, a 1511 error (state 8), followed by a 4313 error may be reported when loading a transaction log which contains a CREATE INDEX on a large table.
Workaround Description
 None.



CR:345293
CR Number:   345293
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2004 Fixed
20 Apr 2004 Fixed
Description
Performance improvement in opening java.net connections



CR:345314
CR Number:   345314
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2004 Bundled Request
Description
Incorporate SSL 3.1.5 with SB/GSE (FIPS-140-2 approved crypto module) into ASE. This ASE should be used with OCS release containing the same SSL and SB libraries.



CR:345316
CR Number:   345316
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2004 Fixed
Description
Error message 8211 will be enhanced to report object name and object id as well. The new message will read: "Mismatch found between the name and id descriptor hash table for table '<tablename>', objid = <objid>. Descriptor hashed by name = <address> and hashed by id = <address>."



CR:345353
CR Number:   345353
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2011 Presently Not Targeted For Any Future Release Of This Product
29 Apr 2011 Fixed
31 May 2011 Added to user documentation
28 Jul 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Add more stored procedure details on MDA tables



CR:345389
CR Number:   345389
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2004 Fixed
09 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
Description
On 64-bit IBM systems, a 12545 error, "Database '<db>' is now online with a lower server version number..." may be incorrectly reported when upgrading a database to a 12.5.1 release.
Workaround Description
 N/A



CR:345479
CR Number:   345479
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2004 Fixed
31 Mar 2004 One-off Provided
Description
An 8211 error: "Mismatch found between the name and id descriptor hash table. Descriptor hashed by name = 0x0 and hashed by id = <value>" may be reported while executing a Dynamic SQL lightweight procedure when the dynamic sql changes the user id on the fly.



CR:345546
CR Number:   345546
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2004 Fixed
Description
Inserts into partitioned data-only locked tables with placement index may cause wasted space, the space waste being more pronounced for tables with higher number of partitions, and also for larger page sizes.



CR:345730
CR Number:   345730
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2004 Not a Bug
Description
When a job / scheduled is created the stattime value defaults to 'now'.

This means that repeating jobs only run from starttime to midnight.
Workaround Description
 Clear the starttime value in repeating jobs/scehdules that need to run 24hours a day.



CR:345731
CR Number:   345731
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2004 Fixed
Description
When a stored procedure is created with an underscore in the name and a parameter type of unichar

or univarchar, sp_sproc_columns doesn't return any data type information, NULL is returned.



CR:345793
CR Number:   345793
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2004 Fixed
Description
When a remote user is ampped to a different user using 'sp_addremotelogin' and RPC auditing is enabled, the server incorrectly stored the external user name in the audit trail instead of the actual usre name. The suid is stored, and this suid does not match the loginname.



CR:345802
CR Number:   345802
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2004 Fixed
20 Feb 2004 Fixed
23 Feb 2004 Fixed
Description
Support for administering and configuring Web Services has been added to the ASE Plugin.



CR:345865
CR Number:   345865
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2004 Fixed
Description
Improve compilation time and optimize internal stack usage when compiling complex

SQL queries with a huge number of IN() elements.



CR:345874
CR Number:   345874
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2009 Insufficient priority to fix
Description
Feature Request to treat utf8 parameter data received in TDS_PARAM in Unicode
so that it can be inserted cleanly into unichar/univarchar columns.
Workaround Description
 Set charset to iso_1 instead of utf8 in the jConnect client.



CR:345877
CR Number:   345877
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2004 Fixed
Description
A 3429 error may be reported by boot time recovery while trying to

access the commit service to determine the status of a two-phase

transaction involving a replicated table.



CR:345879
CR Number:   345879
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2004 Bundled Request
Description
The text of the 1105 error message has been has been modified to "Can't allocate

space for object '<obj>' in database '<db>' because '<seg>' segment is full/has

no free extents. If you ran out of space in syslogs, dump the transaction log.

Otherwise, use ALTER DATABASE to increase the size of the segment."



CR:345943
CR Number:   345943
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2004 Fixed
Description
After unmirroring the master device keeping the secondary side, dumps of the master database fail with an attempt to access the original master device.
Workaround Description
 Reboot ASE (this refreshes the Resource datastructure).



CR:345983
CR Number:   345983
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Fixed
Description
An unexpected out of log error may be raised while executing the

LOAD TRAN command and during the redo phase of an index creation

for a Data Only Locked table.



CR:346066
CR Number:   346066
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2006 Fixed
Description
The error 2601, 'Attempt to insert duplicate key' or 1205, '...encountered a deadlock situation. ...' can be raised when the stored procedure sp_addlogin is executed concurrently from different sessions.



CR:346081
CR Number:   346081
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2005 Fixed
12 Jul 2005 Fixed
12 Jul 2005 Fixed
Description
In rare circumstances, the message "current process infected with 11" in the module

stat_check_sampling_perct may be reported in the errorlog for queries requiring sort

executed in parallel.



CR:346083
CR Number:   346083
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 10 Feb 2004 Workaround
Description
Allow users access to the number of shared memory dumped for a given condition that have already occurred.
Workaround Description
 Two workarounds:



[1]

dbcc traceon(3604)

sp_shmdumpconfig debug



[2]

using sybmon attach to running server

dumpconditions <= will display ndumps value.



CR:346141
CR Number:   346141
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Duplicate
Description
The routine for checking sampling option on update stastitics generates signal 11.



CR:346146
CR Number:   346146
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2004 Fixed
Description
When using a 16K server, after a long running transaction has reached

the last chance threshold and got aborted due to a log full condition,

it may fail to rollback successfully raising a fatal 3475 error.



CR:346163
CR Number:   346163
Product Name:   Adaptive Server Enterprise
Product Component:   preupgrade
Status:   Closed
OS:   NA
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Fixed
Description
When preparing to upgrade an installation, if the preupgrade utility encounters an offline database, it will report that the offline database does not have enough space to run upgrade. This is not true: the database has not actually been checked because it is offline.



CR:346210
CR Number:   346210
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2004 Fixed
Description
CIS: creation of proxy table mapping to remote table or RPC using CREATE EXISTING TABLE

command may not work within a procedure or batch.



With this fix, CREATE EXISTING TABLE ... EXTERNAL TABLE/PROCEDURE/FILE and CREATE TABLE ...

EXTERNAL TABLE/FILE commands are now able to work in a procedure and batch.



CR:346231
CR Number:   346231
Product Name:   Adaptive Server Enterprise
Product Component:   coverletter
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2005 Fixed
Description
A filelist has been added to the image at $IMAGE_ROOT/manifest.txt

listing all the files that will be installed by this EBF.
Workaround Description
 *** Thursday, February 12, 2004 7:14:08 AM *** cooperg ***

N/A



CR:346240
CR Number:   346240
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2005 Bundled Request
Description
ASE 12.5.1 Sybase Central version 4.1.1.1403:

User information is being written to the DOS Console including ID and PSWD, when doing Monitor reporting.

This needs to be changed
Workaround Description
 NONE



CR:346252
CR Number:   346252
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2004 Fixed
Description
Wash size under Cache is not changeable in Sybase Central; the OK Button is disabled until a value is entered in the Amount Pool field.
Workaround Description
 None



CR:346285
CR Number:   346285
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2004 Fixed
Description
Spinlock was obtained by calling a function which is very expensive for no contention calls. Also on Intel processors with Hyperthreading support, busy loop in spinlock code was not having pause instruction.



CR:346292
CR Number:   346292
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2006 Insufficient info provided
Description
In rare circumstances, the message "Logical Process Manager Error: Failed to delete row from

sysattributes table related to a task level specification" will appear in the ASE error log upon

the termination of a process whose priority has been set via the sp_setpsexe stored procedure.

This message may be safely ignored.
Workaround Description
 Either don't use sp_setpsexec, or run sp_clearpsexe if the errors are encountered.



CR:346326
CR Number:   346326
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2010 Duplicate
10 Jun 2005 Fixed
24 May 2010 Bundled Request
Description
Allow spaces for destination directory names during the installation process.



CR:346360
CR Number:   346360
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2004 Fixed
Description
A message infected with 11 in omni_adjust_eops() together with stacktrace containing the modules

'omni_code_gen_subq' and 'omni_opt_select' is sometimes printed in the errorlog when executing a

complex SQL query containing a SELECT using views. The stacktrace is printed after raising message

404, 'Too many ANDs or ORs in expression (limit 1024 per expression level). Try splitting query or

limiting ANDs and ORs.'



CR:346369
CR Number:   346369
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2004 Fixed
Description
possible crash on procedure activity view when there is no activity



CR:346373
CR Number:   346373
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Fixed
22 Feb 2004 Fixed
Description
A combination of having a union in the derived table expression and then assigning it to a local variable is what is causing the infected with 11 in yyparse



CR:346426
CR Number:   346426
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2004 Fixed
Description
The $SYBASE/$SYBASE_ASE/scripts/installjconnect script has "^M" characters at the end of every lines.



CR:346582
CR Number:   346582
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2005 Fixed
21 Jan 2008 Workaround
Description
User is receiving ASE error 7789 indicating that a complex

query exceeds the internal fixed limit of 14 worktables.

Customer would like this limit extended.



The Hardcoded limit is located:

/view/ase1251_cscope_vu/calm/svr/sql/generic/include/server.h

# define MAXWORK 14 /* max active SDESes for non-RI work tables */



CR:346584
CR Number:   346584
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Insufficient priority to fix
Description
User has a very complex query and how it may be simplified is

dependent on how much in excess of the limit the query is. User

would like the 7789 error to include the exact number of worktables

needed to process the query in question.



CR:346585
CR Number:   346585
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Customer would like a mechanism for determining how

many worktables a given query would require would be very desirable.

This is not possible, at present.

So that customer can predetermine how many Work Tables a Query would require.



CR:346592
CR Number:   346592
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2004 Fixed
Description
The ASE localization utility syconfig does not allow built-in UTF-8 non-binary

sort orders to be selected.





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