远程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:384749
CR Number:   384749
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)
13 Jul 2005 Fixed
Description
Changed IPv6 supportive code using Sun Solaris deprecated run-time functions into the IETF designed primitives which are generic for all platforms.
Workaround Description
 added a resolv.conf file or added the host name and IP address to the file /etc/inet/ipnodes also eliminates the problem.



CR:384752
CR Number:   384752
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2006 Fixed
Description
A 694 error, "An attempt was made to read logical page ... The page was not read successfully. You may have a device problem or an operating system problem", may be erroneously reported in cases where prefetch of pages is done on a server that has many concurrent I/Os that are active.
Workaround Description
 N/A



CR:384761
CR Number:   384761
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2005 Fixed
Description
ASE Plug-in 15.0 Beta2 version displays incorrect values for size of Database Devices.



CR:384779
CR Number:   384779
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2005 Fixed
22 Jun 2005 One-off Provided
21 Jun 2005 One-off Provided
Description
In rare circumstances a 701 error, "There is not enough procedure cache to run this procedure,

trigger, or SQL batch. Retry later, ..." may be reported for queries that need to allocate

memory chunks larger than 2 Kb (for example queries with long strings), while there is still

memory available in each engine's local memory cache.



CR:384921
CR Number:   384921
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2005 One-off Provided
Description
Instrumentation: Alarms stop working in ASE resulting in hung transaction and database dumps.



CR:385017
CR Number:   385017
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2005 Fixed
Description
In rare circumstances, ASE running on HP-UX, the message current process infected with 11 may be reported when dbcc printolog() is executed.



CR:385032
CR Number:   385032
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2005 Duplicate
Description
A database that encounters an 1105 error during the ASE boot sequence is not brought online as it should.



CR:385033
CR Number:   385033
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2005 Fixed
12.5.3 ESD#4 30 Mar 2005 Fixed
Description
Supply a document (ASE-12_5/ThirdPartyLegal/ASE-1253ThirdPartyLegal.pdf) containing licenses for third party products included as a part of ASE 12.5.3. The PDF contains links to the source code distributions for those third party components that require it as a part of their licenses.



CR:385126
CR Number:   385126
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2006 Fixed
Description
Under circumstances, when ASE is running java( configuration parameter: enable java = 1) with multiple engines online( number of engines > 1), server could hit SIGSEGV with a stacktrace including VMLiteral.
Workaround Description
 NONE.



CR:385166
CR Number:   385166
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   11.5.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2005 Fixed
Description
The error 3702 "Cannot drop the table '#<temp_table>' because it is

currently in use." may be raised followed by error 216 "Attempt to

automatically drop temporary table failed." when sp_spaceused or OAM builtins

are used concurrently with sessions dropping their temporary objects.
Workaround Description
 Avoid running sp_spaceused in a DB with a volatile object drop.



CR:385188
CR Number:   385188
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)
17 Apr 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Enhance error message 10707 to include dbid, spid, uid info.



CR:385204
CR Number:   385204
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2005 Fixed
10 Jan 2006 Bundled Request
Description
SQL execution from server group. SQL applies to all selected servers in server group, user can view their output, status, error messages (if any) in one dialog.



CR:385338
CR Number:   385338
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Solaris
Status:   Open
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The Install Guides make no mention of how Space is needed in the Temp Dir



CR:385401
CR Number:   385401
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2005 Fixed
13 Apr 2005 Fixed
03 Jul 2005 Bundled Request
Description
100030 error is reported by dbcc checkstorage for text page after cross-platform database load.



CR:385470
CR Number:   385470
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)
11 Apr 2005 Fixed
Description
Inf and NaN can be 'updated' into a float column using JDBC client applications.
Workaround Description
 None



CR:385559
CR Number:   385559
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2005 Fixed
25 Oct 2005 Presently Not Targeted For Any Future Release Of This Product
Description
A 703 error: "There is not enough procedure cache to run this procedure, trigger, or SQL batch" may sometimes be raised if too many sort buffers have been configured with respect to the available procedure cache. This CR adds a recommendation to retry with lesser sort buffers.
Workaround Description
 Retry after configuring lesser number of sort buffers.



CR:385607
CR Number:   385607
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2005 Fixed
27 Sep 2005 Fixed
10 Jul 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Feature Request-Sybase able to use the OS "DIRECT I/O" feature.



CR:385670
CR Number:   385670
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2008 Insufficient priority to fix
Description
The primary difference between server config file and sp_configure output is - config file has info regarding individual caches however sp_configure does not. The request is to include cache info (default/named cache with poolsize) and cache binding info in sp_configure output. sp_configure just gives total and I think it makes sense to include details in sp_configure output. sp_configure output will be complete if we add sp_cacheconfig (all caches and their pool size) and sp_helpcache (cache binding).



TSE's ask for server level configuration from client, they always need to see data cache configuration as well. So they end up asking outputs of three commands sp_configure, sp_cacheconfig and sp_helpcache.
Workaround Description
 *** Monday, April 04, 2005 8:48:57 AM *** cooperg ***

Create a SP that calls the appropriate SP's to get desired output. Customer does not like this solution



CR:385700
CR Number:   385700
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   SunOS
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2007 Insufficient priority to fix
Description
Customer would like a documented/supported way to clean up the hs.ctl file

and remove "invalid" entries from this file without having to reboot

Historical Server, as in the case of inactive views, they can remove it

using hs_delete_data, but in the case of "invalid" views they cannot. They

want to clean up the hs.ctl file and keep it as small as possible with

little information from the past.
Workaround Description
 *** Monday, April 04, 2005 10:21:54 AM *** cooperg ***

N/A



CR:385720
CR Number:   385720
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2008 Fixed
Description
Error 3935 may be hit and a stack trace may be encountered when a stored procedure is marked for replication and executed, and it contains more SQL "COMMIT" statements than the number of active user transactions.



CR:385755
CR Number:   385755
Product Name:   Adaptive Server Enterprise
Product Component:   FTS SDS
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.3 ESD#3 17 May 2005 Fixed
Description
EFTS: When querying text index using score column produces 'VdkDocReadBatch' function failed with vdk error '-27 ' even when batch_blocksize is set to 64k.
Workaround Description
 set the batch_blocksize = 21845



sp_text_configure textsvr ,'batch_blocksize','21845'



Depending on the columns(id, score, summary) involved in the text_index query then the customer can set the...

1) batch_blocksize=65535...if they are only going to return the id from the

text_index...65535\1_column(id)

2) batch_blocksize=37768...if they are only going to return the id plus score from the

text_index...65535\2_columns(id+score)...this includes just requesting score by

itself since id is always implicitely returned

3) batch_blocksize=21845...if they are going to return the most...id, score, and

summary columns from the text_index...65535\3_columns(id+score+summary)...this also

includes any query with summary...summary by itself or coupled with id and/or

score...id is always implicitly returned but for some reason when summary is

requested the text server always needs to use 3 columns in the calculation.



CR:385793
CR Number:   385793
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2005 Fixed
20 Apr 2009 Insufficient priority to fix
Description
When an attemp to run a SELECT INTO query in parallel mode fails because there is an insufficient number of worker processes, an error 11015 is raised instead of executing the query in serial mode.



CR:385795
CR Number:   385795
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2005 Fixed
Description
SELECT @@rowcount may return incorrect value after executing EXECUTE IMMEDIATE

statement if the server configuration option "send doneinproc tokens" is set to 0.



CR:385809
CR Number:   385809
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   Linux
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2006 Duplicate
Description
We can't set a literal message in Japanese within SQLException due to a conversion problem between UTF8 and ASE Charset.
Workaround Description
 none



CR:385820
CR Number:   385820
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currently simulated statistics can only be enabled at the session level (set statistics simulate on) which makes it very difficult to do 'what if' type analyses for a whole application (eg. double row counts for all tables) as it requires modifications to all SQL code. If we could enable simulated statistics at the database or server level then we could easily perform simulations without needing to make any changes to application code. This would help us anticipate changes in optimiser decisions (chiefly due to data growth) and eliminate unexpected degradations in performance that we experience from time to time.



CR:385824
CR Number:   385824
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)
01 Feb 2006 Duplicate
Description
The ADA feature allows read access to offline databases stored on archives.



CR:385826
CR Number:   385826
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)
26 May 2006 Fixed
Description
New feature that allows DBCC CHECKSTORAGE to be run on archive databases.



CR:385829
CR Number:   385829
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)
21 Sep 2005 Fixed
Description
This command should be available for all tables to be used as a "catch all" table maintenance command. It should defragment APL tables in much the same way as dropping and re-creating a clustered index does.



CR:385830
CR Number:   385830
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Data skew: When estimating the rows returned for a point query on a non-unique index and the value falls within a range cell (rather than a frequency cell) the optimiser uses the range cell density to estimate the number of rows returned (see Chapter 17 ASE 12.5 P&T Guide - 'How optimiser uses densities and histograms'). Because the range cell density 'represents the average number of duplicates of all values that are represented by range cells in the histogram' the optimiser may make unecessarily pessimistic estimates where there are variations (ie.skew) between range cells that aren't sufficient to generate frequency cells. It occurred to me that if a density figure was generated for each range cell and stored with the histogram stats then the optimiser would get the best possible view of the distribution of duplicate values and be much less easily fooled by data skew when optimising point queries (not such an issues for range queries) - would this be possible ?



CR:385854
CR Number:   385854
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a command to clear the max_used counters used in sp_monitorconfig without requiring a reboot of ASE.



CR:385942
CR Number:   385942
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2005 Fixed
Description
A new feature request to avoid error 7205 state 3 while a SITE HANDLER is destroying a SITEBUF.



CR:386107
CR Number:   386107
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)
25 Apr 2005 Fixed
Description
The message 'current process (...) infected with 11' together with module eval_cnst_expr, run or com__mk_rslcnst may be generated when an incompatible constant SARG is used in a where clause.
Workaround Description
 The SQL itself is a semantically incorrect, so do not try to construct it.



CR:386172
CR Number:   386172
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2005 Fixed
Description
HA VCS: Auxiliary server online operation is incorrectly reported and offline operation fails



CR:386242
CR Number:   386242
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2007 Fixed
Description
Empty stack trace for fatal signals error like, sigsegv, sigabort, sigbus etc in native thread context.



CR:386327
CR Number:   386327
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2005 One-off Provided
26 Apr 2005 Fixed
01 Jul 2005 Fixed
Description
Adaptive Server may provide incorrect results for ct_dynamic() call requesting

CS_DESCRIBE_OUTPUT if the dynamic SQL executes multi-statement batch and SELECT

statement returning the data is not the first one in the batch.
Workaround Description
 Don't rely on the output from ct_dynamic(CS_DESCRIBE_OUTPUT), send the execute and then use the description which comes back with the actual resultset.



CR:386421
CR Number:   386421
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2005 Fixed
14 Apr 2005 Bundled Request
03 Jul 2005 Bundled Request
Description
Under rare circumstances, a time slice error may happen while running a cross platform <LOAD DATABASE> command for byte-swapped architectures and if the source database contains partitioned tables.



CR:386423
CR Number:   386423
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2005 Fixed
Description
Error 7351 is raised when a view is created in the same batch as a select of a variable value, although the variable is not part of the view definition.



CR:386435
CR Number:   386435
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2009 Insufficient priority to fix
Description
Feature request for an "output_table" option to sp_sysmon similar to what exists for sp_monitorconfig
Review Status
 F



CR:386445
CR Number:   386445
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2005 Fixed
08 Jul 2005 Fixed
Description
A column defined in DB2 as LONG VARCHAR was not being mapped correctly and any SELECT of the column would fail to return the correct data.



CR:386447
CR Number:   386447
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2005 Fixed
09 Nov 2005 Fixed
Description
srvbuild fails to build ASE if the master device size configuration is set to more than 2GB
Workaround Description
 Build server with master device < 2GB, then DISK RESIZE it to larger size



CR:386769
CR Number:   386769
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2005 Bundled Request
23 Dec 2005 Bundled Request
Description
A new column ErrorStatus has been added to monSysStatement, indicating the error status upon completion of statement execution.



CR:386869
CR Number:   386869
Product Name:   Sybase SQL Server
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a stored procedure to calculate the tempdb space needed to run update index statistics on a table



CR:386897
CR Number:   386897
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2012 Added to user documentation
Description
clarify when it is unnecessary to use sp_addobjectdef



CR:386912
CR Number:   386912
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)
26 Apr 2005 Fixed
14 Jul 2005 Fixed
Description
The message "current process infected with 11" in the module 'com__subquery' together with a stack trace which includes the modules 'constree' and 'com__op' may be reported in the error log for a SELECT with a subquery under a CASE statement and an OR clause. A view using the same combination can also result in error 3626, "The transaction was aborted because it used too much stack space"



CR:386928
CR Number:   386928
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2006 Bundled Request
Description
Previously for ASE, Interactive SQL only limited the displayed rows on the client side without limiting the number of rows sent by the server through "set rowcount" command. This has been fixed.



CR:386931
CR Number:   386931
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 14 Oct 2005 Fixed
Description
Previously DBISQL does not display query result similar to the that of command-line isql. This has been addressed by adding a "Text" output mode, in addition to existing "Grid" output mode. To turn on Text output, open Options dialog by selecting menu item "Tools"->"Options...". On Options dialog, select "Results" from the left-hand-side list and select "Text" radio button to enable text output.



CR:386987
CR Number:   386987
Product Name:   Adaptive Server Generic Docs
Product Component:   Using Sybase Failover In a HA System
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need to document valid values and meaning of each filed of ase_monitor_action



CR:387023
CR Number:   387023
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2005 Fixed
10 Jul 2009 Insufficient priority to fix
Description
Queries containing many aggregates and at least one AVG() may return incorrect

results or fail with a stack trace on 64bit platform.



CR:387036
CR Number:   387036
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2005 Fixed
18 Apr 2005 Fixed
08 Jul 2005 Fixed
Description
sp_start_rep_agent with 'recovery' option run for an offline database will report the error 9280: Unable to start repagent on database <dbname> because that database has not been recovered and/or is not online.



CR:387059
CR Number:   387059
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2005 Fixed
Description
Temporary Databases and User Created temporary databases are not listed in Cache Bindings list.



CR:387121
CR Number:   387121
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2005 Fixed
10 Aug 2005 Fixed
11 Aug 2005 Fixed
Description
HA: On ASE HA Active/Passive configuration with Sun Cluster 3.x environment, if a child ASE monitor

process (ase_monitor) dies, a parent ASE monitor process restarts ASE.



CR:387143
CR Number:   387143
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2005 Fixed
Description
An exec immediate SQL command using a command string built from concatenated strings can fail with

syntax errors or generate incorrect results if one of the strings used to built the command

string has a NULL/empty value.
Workaround Description
 Use " quotes like exec (".....") instead of exec ('....')

more important, don't use an empty variable to built the command !!



CR:387239
CR Number:   387239
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a dbcc command to correct a corrupt allocation page



CR:387279
CR Number:   387279
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 Apr 2005 Fixed
09 May 2005 Fixed
Description
An 875 error, "Unable to grab a buffer to allocate a page to the log in database id <id>..."

may be reported on a heavily-used 32bit Linux system that is making use of large memory support

(the "extended cache size" configuration parameter is non-zero). Now, the wash size for the

<server page size> pool in all user-configured caches (not the extended cache),

is set to the configured wash size; prior to this change it was set to a fixed value.
Workaround Description
 Set the configuration parameter, 'i/o batch size' to 10 (the default is 100).



CR:387287
CR Number:   387287
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2005 Fixed
07 Dec 2005 Presently Not Targeted For Any Future Release Of This Product
Description
When sampling for update statistics is enabled and the index/column does not have existing statistics, then the resulting join density and total density are set to a default value of 0.1. Traceflag 2703 is now provided such that when the traceflag is turned on, the join and total density will be gathered from the sample instead of being set to the default value.



CR:387313
CR Number:   387313
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2005 Fixed
Description
LOAD DATABASE has a new option, WITH VERIFY[ONLY] [= HEADER | FULL ].

This performs basic page header sanity checks (HEADER) and both

page header checks and intra-page row checks (FULL) on every page

loaded. If VERIFYONLY is used, the pages are read and checked from

the dump archive but they are not copied onto the database devices.



CR:387421
CR Number:   387421
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2005 Fixed
Description
A stored procedure that has a statement whose execution requires a work table creation,

may encounter remapping problems when the statement is executed using the pass through mode

on a remote server and the local server has multiple temporary databases defined.

The problem will manifest with the message "current process ... infected with 11"

in module proc__reset_wktbl().



CR:387440
CR Number:   387440
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2005 Fixed
04 Aug 2005 Fixed
Description
The error 8419 "Could not find index descriptor for objid <value>,

indid <value> in dbid <value>." may be raised during the recovery

phase of a database with a stack trace reported in the error log

with modules 'recovery', 'pg_zap_dealbit_db' and 'pg__recalc_oams'.



CR:387454
CR Number:   387454
Product Name:   Adaptive Server Generic Docs
Product Component:   Using Sybase Failover In a HA System
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2005 Fixed
Description
$SYBASE/$SYBASE_ASE/SC-3_0/log directory does not exist. After installing ASE, you need to create it to store callback_log and monitor_log files.



CR:387469
CR Number:   387469
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2005 Fixed
Description
HA SC 3.x: If a parent ase_monitor is dead after a child ase_monitor is dead, ase_monitor processes do not wake up and nobody monitors dataserver process.
Workaround Description
 Change line 1615 in $SYBASE/$SYBASE_ASE/SC-3_0/bin/utils.ksh as follows:



Before:

1615 pmfadm -E -c $PMF_TAG -n -1 -t -1 \

1616 `dirname $0`/ase_monitor $RESOURCEGROUP_NAME $RESOURCE_NAME



After:

1615 pmfadm -E -c $PMF_TAG -n -1 -t -1 -C 0 \

1616 `dirname $0`/ase_monitor $RESOURCEGROUP_NAME $RESOURCE_NAME



CR:387506
CR Number:   387506
Product Name:   ASE Replicator
Product Component:   Doc
Status:   Closed
OS:   Generic
Original Version:   NA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Not a Bug
Description
Document use of sp_skiptran subname[, num_to_skip ]

as being a replacement of sp_resumesub ... withskip option
Workaround Description
 Be sure that Replicator is quiesced first. Then you can either fix the offending data by correcting the appropriate shadow table(s), or you can delete all the rows of the offending transaction from the tran-log table.



CR:387523
CR Number:   387523
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2005 Fixed
03 Jun 2005 Fixed
23 Jun 2005 Fixed
21 Aug 2005 Fixed
Description
On a 32 bit Linux platform, a 695 or 697 error may be reported in a server configured with

2K pages and Large Memory Support(the "extended cache size" is set to a non-zero value).



CR:387532
CR Number:   387532
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)
20 Apr 2005 Fixed
Description
The message "infected with 11 in mda_populate_monCachedProcedures()" together

with a stacktrace containing the modules 'mdarpc_exec' and 'exec__native_rpc'

may be written to the errorlog when ASE monitoring tables are enable and the

'number of open objects' parameter is not configured high enough.



CR:387680
CR Number:   387680
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Fixed
20 May 2005 Fixed
05 Jun 2005 Fixed
24 May 2005 One-off Provided
12 Jun 2005 Fixed
04 Jul 2005 Fixed
14 Jul 2005 Fixed
Description
CIS: SELECT from proxy_table might return the number of rows according to the previous SET ROWCOUNT, even though the rowcount has been set back to 0.
Workaround Description
 set rowcount <a really big number>



CR:387711
CR Number:   387711
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)
26 May 2005 Fixed
Description
Recompilation of a stored procedure containing a statement with correlated subquery

in the HAVING clause may lead to different errors indicating query tree corruption.



CR:387722
CR Number:   387722
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2005 Fixed
Description
The ASE for the 64-bit linux platform for the AMD64 process in the ASE 12.5.2 release can be run without any license. The licensing is not enforced in that ASE software. With this new release for the 64-bit Linux platform for the AMD64 processor in the ASE 12.5.3 release, the licensing requirement is enforced in the ASE software. For the step to add licensing, refer to chapter 3, Sybase Software Asset Management (SySAM) in the Install Guide for Linux.



CR:387753
CR Number:   387753
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2005 Fixed
Description
If the debug version of ASE is booted with the trace flag 722, the server performs additional checks on the heap memory to detect possible memory corruption.



CR:387756
CR Number:   387756
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)
26 Apr 2005 Fixed
Description
The message infected with 11 in decision is printed in the errorlog, together with a stacktrace

containing the modules 's_compile_stmt', 'execproc' and 's_execute', when executing a stored procedure

which performs a select from a view having a UNION clause. This statement must be the second statement

in the stored procedure.
Workaround Description
 Recreate the query tree of the problem sproc via:

dbcc upgrade_object(dbname, sproc_name)

from the text stored in syscomments.



CR:387857
CR Number:   387857
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2005 Fixed
28 Feb 2006 Presently Not Targeted For Any Future Release Of This Product
22 Jun 2005 Fixed
07 Jul 2005 Fixed
12 Jul 2005 Fixed
11 Jul 2005 Fixed
Description
ASE on Windows uses Certicom SSL Plus 3.1.15b libraries, and ASE on UNIX platforms uses Certicom SSLPlus 3.1.14 libraries.



CR:387878
CR Number:   387878
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2005 Fixed
05 Jul 2006 Not a Bug
Description
Query with index joins may execute very slowly.
Workaround Description
 For 15.0, issue 'set plan optgoal allrows_dss' before the select query.



CR:387910
CR Number:   387910
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
add new resource files to the install doc...

sybatch_ase.res

sybatch_bs.res

sybatch_ms.res



CR:387954
CR Number:   387954
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2005 Fixed
28 Sep 2005 Fixed
11 Oct 2005 Fixed
08 Nov 2005 Fixed
24 Nov 2005 Fixed
Description
Sub-optimal performances may be seen on queries with <LIKE>...<ESCAPE> expressions



CR:387963
CR Number:   387963
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
XPserver: should send wide column results to those clients that are capable of supporting them and use 255 character limits for older clients.
Workaround Description
 None known.



CR:387979
CR Number:   387979
Product Name:   Adaptive Server Enterprise
Product Component:   Monitor Client
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2005 Fixed
Description
Not customer visible



CR:388018
CR Number:   388018
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2005 Fixed
08 Dec 2005 Fixed
Description
In rare circumstances, the ONLINE DATABASE command fails with a 2610 error after a cross-platform database load. To avoid this error, run "dbcc traceon(3199)", reload the dump and online the database using "ONLINE DATABASE".



CR:388024
CR Number:   388024
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2006 Fixed
27 Aug 2006 Fixed
28 Aug 2006 Fixed
Description
Feature request to make the timeslice error message less cryptic.



CR:388061
CR Number:   388061
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)
27 Apr 2005 Fixed
Description
add the following chart to the...

12.5 System Administration Guide

...to help with configuring 8 page I/O buffer pool for checkstorage



Chapter 25 Checking Database Consistency

...

Preparing to use dbcc checkstorage

...

Configuring Adaptive Server for dbcc checkstorage

...

Configuring an 8 page I/O buffer pool

The dbcc checkstorage buffer pool requirements for the

different page sizes in 12.5 are as follows:



(2k page server) * (8 extents) = 16k buffer pool

(4k page server) * (8 extents) = 32k buffer pool

(8k page server) * (8 extents) = 64k buffer pool

(16k page server) * (8 extents) = 128k buffer pool



CR:388074
CR Number:   388074
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2005 Fixed
Description
Under stress conditions, ASE running on HP-UX, the message 'current process infected with 11' together with a stack trace which include the module 'addCharArrays' may be reported in the error log when the client is using SSL.



CR:388213
CR Number:   388213
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2005 Fixed
Description
replace all dbcc engine references for starting stopping engines with sp_engine in System Administration Guide



CR:388267
CR Number:   388267
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2005 Fixed
Description
After failover is complete, sometimes a child ase_monitor process still remains on primary node.
Workaround Description
 Kill a child ase_monitor process manually if it still remains on primary node after failover.



CR:388281
CR Number:   388281
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   macosx
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2006 Fixed
03 Apr 2006 Fixed
03 Apr 2006 Fixed
Description
On Mac OS X platform, 6.66.2.1 error, "Volume validation error: illegal volume change, device

<device name>: volume mounted out of order, expected volume 0001, got volume 16777216.",

is reported by Backup Server when running load database with a dump file that was generated

on little-endian platform.
Workaround Description
 Nothing



CR:388401
CR Number:   388401
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2005 One-off Provided
27 May 2005 Fixed
06 Jun 2005 One-off Provided
Description
Sybmon dump with ASE 12.5.2 ESD#2 on Windows platform fails. ASE reports seek error

in errorlog similar to 'File positioning failed (4).Seek offset: 828964864'



CR:388427
CR Number:   388427
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2005 Fixed
Description
The message "current process infected with 11 in expand_ALL_nodes" is printed in the ASE errorlog

together with a stacktrace containing the modules 'd_upgradeobj', 's_normalize' and 'u_view_driver'

when executing the command DBCC UPGRADE_OBJECT() on a stored procedure containing a view having a

SELECT * on a table which is dropped and recreated before executing the actual DBCC command.



CR:388430
CR Number:   388430
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2005 Fixed
Description
sp_estspace output is incorrect for APL tables with short rows on wide page size. There is a limit of 256 rows per page that the code does not account for.



CR:388475
CR Number:   388475
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2005 Fixed
Description
On the Windows platform, issuing the xp command "xp_cmdshell 'type long.txt'" where long.txt is a text file with a very long line (>255 characters) of text and no final carriage return, will result in the text file being repeatedly typed in an infinite loop



CR:388560
CR Number:   388560
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2005 Fixed
Description
Move binaries under shared/lib folder to ASEP/lib folder. Remove About ASE Plugin Dialog as the same information is displayed in ASE Plugin properties.



CR:388586
CR Number:   388586
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2006 Fixed
31 Jan 2006 Fixed
Description
Various Enhancements of performance of TEMPDB especially to avoid writing buffers to disk as part of checkpoint, minimal logging of TEMPDB activity, separate ULC for tempdb. Please see what's new for the detailed of these enhancements.



CR:388663
CR Number:   388663
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
BackupServer: new feature request to speed load from tape by specifying "norewind" option when tape is known to be at the correct position.
Workaround Description
 None, but put smallest dumps on tape first to speed load times.



CR:388670
CR Number:   388670
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2006 Fixed
Description
The command LOAD WITH VERIFY[ONLY] is not supported on cross platform load, however it was allowed causing all sort of invalid verification errors.



CR:388766
CR Number:   388766
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2005 Fixed
Description
PERMISSIONS Exec (@sql_text) inside store procedure not working
Workaround Description
 /** workaround **/

create procedure testproc3

as

declare @sql_txt varchar(255)

select @sql_txt = "delete test..sysusers where

test..sysusers.name = 'testuser'"

execute sp_configure "allow updates", 1

execute (@sql_txt)

execute sp_configure "allow updates", 0

go



use test

go

exec sybsystemprocs.dbo.testproc3

go



CR:388889
CR Number:   388889
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)
04 Sep 2005 Fixed
Description
CIS: Selecting from proxy MSSQL table involving builtin functions hextoint/inttohext could give an error "... not a recognized function name" from the backend server.



CR:388984
CR Number:   388984
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2006 Presently Not Targeted For Any Future Release Of This Product
21 May 2006 Fixed
06 Jun 2006 Fixed
27 Jun 2006 Reservation Made
29 Apr 2006 Duplicate
06 Aug 2007 Added to user documentation
Description
Added new T-SQL builtin, PARTITION_OBJECT_ID() that displays the object ID given a partition ID and an optional database ID. Interface is PARTITION_OBJECT_ID(<partition ID> [, <database ID>]). Returns NULL for non-existent or invalid input arguments.



CR:389073
CR Number:   389073
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
A dbcc checktable can give error 7930 on tables with a clustered index after using migration tool to migrate to a windows server using 16k pages.



(7930 error:)



Table Corrupt: Keys in the left child page do not precede the parent key; check page %d, partition ID %d.
Workaround Description
 Two alternate workarounds:



(1) If migrating tables with clustered indexes to a 16k page size windows server use the migration tool traceflag NO_SORTED_DATA:



$ sybmigrate -T NO_SORTED_DATA



This will ensure the clustered index is recreated correctly after the table data has been copied.



(2) If migration has completed without the traceflag and dbcc checktable is reporting the error dropping and recreating the clustered index will resolve the problem.



CR:389076
CR Number:   389076
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2005 Fixed
16 Sep 2005 Fixed
16 Sep 2005 Fixed
Description
The message "current process infected with 11" may be raised in module bufdlink()

when the sysindexes system catalog and the database where it resides are bound to

different named caches, and when the clustered index of sysindexes is not explicitly

bound to a named cache.
Workaround Description
 If you bind sysindexes to a named cache, explicitly bind sysindexes.sysindexes index to

either the same named cache, or to the cache the database is bound to.



CR:389129
CR Number:   389129
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)
02 Jun 2005 Fixed
Description
Error 511 "Attempt to update or insert row failed because resultant row of size <value> bytes

is larger than the maximum size (<value> bytes) allowed for this table..." may be raised during

the execution of a stored procedure using the reformatting strategy and the creation of a

DOL (Datarows Only Locking) work table. Alternatively the error 9561 "An insert or update to table

'temp worktable' places column '(unknown column)' at offset <value>..." may be raised.



CR:389154
CR Number:   389154
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2006 Fixed
31 Aug 2006 Fixed
Description
If a very large transaction is rolled back then "KILL <spid> WITH STATUSONLY" may report

negative values.



CR:389218
CR Number:   389218
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2005 Fixed
Description
Illegal escape sequences in Unicode literals (U&'...') are not detected properly when

the server's default character set is configured as UTF-8.



CR:389227
CR Number:   389227
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2008 Fixed
Description
Feature Request: Currently. monOpenDatabases.BackupStartTime is updated for database and transaction dumps. Transaction dumps should be seperated into their own field.



CR:389239
CR Number:   389239
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2006 DEFER
08 Nov 2006 Fixed
Description
1) sp_encryption system stored procedure uses tempdb excessively.



2) Running sp_encryption when there are no keys in the database produces no output.



3) sp_encryption enhancements to display keyname, tablename, column name and key details.



CR:389280
CR Number:   389280
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2005 Not a Bug
Description
Under certain circumstances although a join-query executed against ORACLE tables mapped

locally in ASE as proxy tables is not pushed entirely to the ORA-side although

this is completely possible





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