远程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:346654
CR Number:   346654
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)
23 Feb 2004 Fixed
Description
Queries returning TEXT/IMAGE fields and using worktables may not execute correctly

giving spurious 605 errors in the temporary database or may fail with stack traces.

Stack trace will reference modules like exec_eop,run.



CR:346874
CR Number:   346874
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)
28 Apr 2004 Fixed
Description
The message "process infected with 11" maybe reported in the errorlog together with a stacktrace

which includes the modules 'sendtext' and 'run' if a SELECT using ISOLATION LEVEL 0

selects from text/image columns and other users are updating these text/image columns at the

same time.



CR:346884
CR Number:   346884
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2004 Fixed
Description
The monOpenObjectActivity table contains rows for objects besides user tables and indexes. These rows have zero value columns because monitoring data is not collected for other object types. These rows should be removed from the table, and only rows for user tables and indexes should be reported. Also, the date columns should be reported as NULL rather than zero when not set.



CR:346898
CR Number:   346898
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2006 Fixed
Description
The monIOQueue monitoring table incorrectly assigned IOs by the system to the 'User Data' row since the table only split IOs by 'User Data' or 'User Log'. System IOs are now assigned to 'System'



CR:346899
CR Number:   346899
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2004 Fixed
14 Aug 2004 Presently Not Targeted For Any Future Release Of This Product
Description
In rare circumstances, the 1601 error "There are not enough 'user connections'

available to start a new process. Retry when there are fewer active users, or

ask your System Administrator to reconfigure SQL Server with more user

connections." may be reported in the errorlog due to upspawn failing with

the following message "upspawn: no more process slots available".



CR:346929
CR Number:   346929
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)
02 Mar 2004 Fixed
Description
When Job Scheduler processes job output column data that is longer than the output column width, data may be incorrectly repeated on subsequent lines. This has been corrected.



CR:347020
CR Number:   347020
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2004 Fixed
Description
'Select Distinct within a subquery may encounter performance degradation if proxy tables are involved.



CR:347030
CR Number:   347030
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Fixed
09 Mar 2004 One-off Provided
12 Mar 2004 Fixed
Description
Back out xpserver changes made under CR 325777 which results in unexpected behavior of xp_cmdshell.

With 325777 changes, xp_cmdshell commands executing a shell command which tries to redirect output to a file using the '>' file I/O redirection does not work as expected. Instead the output is returned to the ASE client. Fix for 325777 will be reworked under 348878.



CR:347061
CR Number:   347061
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)
25 Feb 2004 Fixed
Description
srvbuildres should tell user to specify the "force_buildmaster = yes" clause when trying to overwrite an existing master device rather than "-f"



CR:347083
CR Number:   347083
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2006 Fixed
Description
When a user is granted a role that has been granted the mon_role role and the user executes the 'set role' command to activate the role, the user will not be able to select from MDA tables but will get a 10353 error.
Workaround Description
 As SA execute

sp_modifylogin mark,"add default role",myrole



CR:347084
CR Number:   347084
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 Apr 2004 Fixed
Description
The message "current process ... infected with 11" in module 'des_unkeep'

may be hit during the execution of SP_RENAME when the given object

is not yet cached. The stack trace will also report modules 'exec_dbcc'

and 'd_refresh_ides' in the error log.
Workaround Description
 Have first the descriptor cached via sp_help t1



CR:347090
CR Number:   347090
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)
23 Feb 2004 Fixed
Description
On alignment-sensitive platforms only, inserting into a unichar column from a varbinary column may generate alignment fault if the UNICHAR data is not aligned on a 2-byte boundary.
Workaround Description
 In general, no workaround is available.

If there are no variable-length or nullable datatypes

in a table definition, however, it may be possible to

define the table such that unichar data is always aligned

on a 2-byte boundary.



CR:347098
CR Number:   347098
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)
29 Apr 2004 Fixed
Description
The name of a user database is stored with trailing spaces in the VARCHAR-type field name in the

systemtable SYSDATABASES when using bracketed indentifiers in the CREATE DATABASE statement like

CREATE DATABASE [<dbname><space>...<space>].



CR:347115
CR Number:   347115
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)
26 Feb 2004 Fixed
08 Mar 2004 Presently Not Targeted For Any Future Release Of This Product
Description
A leading '//' inside predicate should be treated as

an absolute path from root. It is not beginning of

a path relative to the sub-path preceding the filter.



CR:347134
CR Number:   347134
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation and Configuration Guide-ASE
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2006 Fixed
Description
Adaptive Server Enterprise Disk I/O Tips

Linux supports a variety of file systems such as EXT2, EXT3, and XFS.

The recommended file system for Adaptive Server is EXT2 or EXT3 with

journaling disabled.



CR:347189
CR Number:   347189
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)
03 May 2004 Fixed
Description
The message "current process infected with 11" in the module 'parse_name' together with a stack trace

which includes the modules 'logcommand' and 'grantrev' may be reported in the errorlog if a table

having an identity column is used in a stored procedure together with a GRANT or REVOKE command

for that same table and the REPLICATION FORCE_DDL option is set.



CR:347219
CR Number:   347219
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2004 Fixed
17 Jun 2004 Fixed
Description
Sybmigrate will stop migrating between two servers if the password for the migration login is not identical on both servers.
Workaround Description
 *** Monday, February 23, 2004 11:40:23 AM *** cooperg ***

Use same logins with identical passwords or

Run sp_addexternlogin on the source server and create an external login mapping between the 'sa' accounts on the source and target systems.



CR:347247
CR Number:   347247
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)
25 Dec 2004 Fixed
Description
Error 1566 is raised when creating a clustered index even when there are sufficient distinct key values for the number of partitions.



CR:347282
CR Number:   347282
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)
03 Jun 2004 Fixed
10 Jun 2004 Fixed
26 May 2005 Fixed
21 Nov 2005 Fixed
22 Jun 2004 Fixed
Description
Add support for Korean language using character set cp949. Note that

to use this character set in conjunction with eucksc, the sp_configure

parameter "size of unilib cache" should be increased to 144384 bytes

(or more) and the the sp_configure parameter "enable unicode conversions"

should be set to 1.
Workaround Description
 To use cp949 as a client character set with a utf8 server

(or a eucksc server, for that matter), it's possible to

use the statement "set char_convert 'cp949'". It's

not yet possible to use the -J flag of isql or bcp,

nor to configure cp949 as ASE's default character set.



CR:347369
CR Number:   347369
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)
22 Apr 2004 Fixed
Description
CIS: Signal 11 stack trace in ct_poll may occur when an insert-select query is interrupted

by a killed connection.
Workaround Description
 No known workaround othere than running the diagserver.



CR:347380
CR Number:   347380
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 May 2004 Fixed
09 Jun 2004 One-off Provided
27 Jun 2004 Fixed
Description
Msg. 103, "The identifier that starts with '<textpointer>' is too long. Maximum length is 30." is

raised when executing the command WRITETEXT BULK <tablename>.<colname> <textpointer> and colname

is called "parameter".



CR:347386
CR Number:   347386
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2005 Fixed
02 Dec 2005 Fixed
05 Feb 2006 Fixed
04 Jan 2006 Presently Not Targeted For Any Future Release Of This Product
24 Jul 2006 Fixed
26 Sep 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
Enabling sort-merge join and parallelism returns duplicate rows when executing a SELECT from a view which comprises of a SELECT DISTINCT from a 2-table join.
Workaround Description
 having parallelism off the query will return the right result



1> sp_configure "parallel"

2> go

Msg 17411, Level 16, State 1:

Server 'panther125', Procedure 'sp_configure', Line 209:

Configuration option is not unique.



Parameter Name Default Memory Used Config Value

Run Value Unit Type

------------------------------ ----------- ----------- ------------

----------- -------------------- ----------

max parallel degree 1 0 1

1 number dynamic

max scan parallel degree 1 0 1

1 number dynamic



(1 row affected)

(return status = 1)

1>











> select count(*) from project_cost_element_vw

2> go



-----------

936



(1 row affected)



CR:347439
CR Number:   347439
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)
03 Dec 2004 Presently Not Targeted For Any Future Release Of This Product
25 Aug 2004 Fixed
05 Oct 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Query with equi-sargs predicates and IS NULL can result in poor index selection.



CR:347475
CR Number:   347475
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)
27 Apr 2004 Fixed
Description
sp_monitorconfig displays wrong number of pages for "size of process object heap".



CR:347528
CR Number:   347528
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)
20 Apr 2004 Fixed
Description
xp_cmdshell should allow commands that exceed 255 characters



CR:347540
CR Number:   347540
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2004 Not reproducible with latest version of the product available as of Resolution Date
28 May 2004 Fixed
05 Mar 2004 Fixed
Description
optdiag failed to load statistics complaining about db name is not found, this only happens when database conflict is flawed.



CR:347570
CR Number:   347570
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)
27 Oct 2004 Fixed
Description
When the sp_configure parameter "enable unicode normalization" is set

(as it is by default) and character literals contain Unicode

characters requiring normalization, the parser failed to

perform the normalization. This was true for literals

promoted to the unichar data type, represented using

UTF-16, as well as char literals when the server's default

character set is configured as UTF-8.



CR:347712
CR Number:   347712
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)
28 Apr 2004 Bundled Request
Description
Sybase Central ASEplugin: 'Generate DDL' of stored procs against V12.0 server thows error:

CO55 The specified Compiled Object Item not found in the Server: <sproc_name>.
Workaround Description
 Can use ddlgen instead.



CR:347726
CR Number:   347726
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)
08 Apr 2004 Fixed
05 May 2004 Fixed
Description
In rare circumstances, the error 1292 "Internal Error in lock manager ..." may be raised when a query that involves system tables and builtins is run in parallel mode, as opposed to serial, and the system builtin execution results in the caching of a user object's descriptor.
Workaround Description
 Put first in temp tables the needed data and then apply the system builtins,

or disable parallelism.



CR:347753
CR Number:   347753
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)
02 Jul 2004 Fixed
Description
Enhanced diagnostics for access violation errors.



CR:347795
CR Number:   347795
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2005 Fixed
Description
inclusion of read only cursors for sort merge joins.



CR:347811
CR Number:   347811
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2005 Presently Not Targeted For Any Future Release Of This Product
21 Nov 2005 Fixed
Description
The 'ascinserts' property of a table, that earlier used to be set by a call to dbcc tune(), can now be set via stored procedure 'sp_chgattribute'.



CR:347817
CR Number:   347817
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2004 Not reproducible with latest version of the product available as of Resolution Date
15 Jun 2004 Fixed
Description
In very rare cases, on windows XP platform, boot recovery could run into system exception when trying to print out the buffer pool tuning messages.



CR:347837
CR Number:   347837
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)
25 Oct 2006 Fixed
24 Oct 2006 Fixed
Description
Fixed the return type java.lang.string for build-in function msgproplist.



CR:347891
CR Number:   347891
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)
25 Apr 2004 Fixed
25 Mar 2004 Fixed
Description
CIS: The message "current process infected with 11" in the module 'investigate_ojs' together with

a stack trace which includes the modules 'omni_get_ojrelops' and 'omni_findjoins' may be reported

in the error log if a query with UNION and ANSI join involves proxy tables.
Workaround Description
 Use T-SQL JOIN as in the OK query in repro or use traceflag 11216 or 11217



CR:347936
CR Number:   347936
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2006 Deferred
Description
The "Total Actual I/O cost" output by showplan is inaccurately low for query statements that

contain multiple main steps, such as UNION statements.
Workaround Description
 You can compute the total actual I/O cost using the following formula:



(sum(total logical I/Os for each table)* 2) + (sum(total physical I/Os for each table) * 18)



CR:347941
CR Number:   347941
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance srvbuild character set and sort order pulldown menus to list id numbers as well as descriptions



CR:347963
CR Number:   347963
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Custumer will like to have a way to track the usage of disk space by individual login or spid. Customer would like to have this in the monitor tables.



CR:348049
CR Number:   348049
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 Mar 2004 Fixed
Description
In rare circumstances, a 691 error, "Encountered invalid logical page '0' while accessing

object '8' in database '<dbid>'" may be reported during boottime or LOAD DATABASE recovery.
Workaround Description
 None



CR:348098
CR Number:   348098
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Description
Set default focus in the first text field on a wizard page when the page is first activated.



CR:348123
CR Number:   348123
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)
04 Sep 2006 Fixed
Description
Mount/Umount Database improvements



CR:348134
CR Number:   348134
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)
08 Mar 2004 Fixed
Description
There are now a new set of bourne shell scripts for the user to use and the cshell scripts have been renamed to have a .csh extension. Also the directory structure for JS-12_5 has been simplified. There is no change in functionality due to this change.



CR:348235
CR Number:   348235
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 Apr 2004 Fixed
Description
HA on Sun may not work properly due to utils.ksh script picking up the primary ASE run file for the secondary ASE.



CR:348240
CR Number:   348240
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)
04 Mar 2004 Fixed
Description
A stacktrace including the modules open_fail_error, getuidfromsuid() and prot_srch_and_check_for_dbcc()

may be printed in the errorlog, if a non-sa user tries to execute a database level dbcc command in a database that is not usable.



CR:348331
CR Number:   348331
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 2004 Fixed
Description
The error 926, followed by error 12324 and a stack trace that includes the module

checkstorage will be raised when running DBCC CHECKSTORAGE on a database that

is marked suspect. Similar errors and stack traces are seen if the database is unavaliable

for some other reasons.



CR:348346
CR Number:   348346
Product Name:   Adaptive Server Enterprise
Product Component:   Monitor Client Library
Status:   Closed
OS:   Unknown
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2004 Fixed
Description
missing makefiles on some platforms for MCL sample programs



CR:348347
CR Number:   348347
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)
05 Mar 2004 Fixed
Description
The charset program prompts for confirmation of a update to

a character set or sort order definition if such a definition

is already installed in the server. The program loops until

a valid yes/no response is received from its standard input.

EOF is not considered a valid response, and will trigger

an indefinite loop.



CR:348372
CR Number:   348372
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)
24 Jun 2004 Fixed
01 Nov 2004 Deferred
Description
The performance of the parse and compile phase for a large SQL batch has been

improved. Further performance improvements may be achieved with the 702 boot time

trace flag though this comes with an additional 2% per-batch memory cost.



CR:348384
CR Number:   348384
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)
13 May 2004 Fixed
04 Feb 2006 Fixed
Description
The error 1505, "Create unique index aborted on duplicate key. Primary key is '<value>'" may report an incorrect key value if the index is created in parallel mode as opposed to serial.
Workaround Description
 CREATE INDEX WITH CONSUMERS=1



CR:348390
CR Number:   348390
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)
19 Apr 2004 Fixed
Description
If a row level access rule containing multiple AND qualifiers is attached to a table involved in an outer-join query it may generate incorrect results.



CR:348404
CR Number:   348404
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)
01 Nov 2004 Fixed
Description
The object information printed in sp_object_stats is truncated when the name of the database, the

name of the object and some detailed object info is greather than 80 characters.
Workaround Description
 The workaround is to modify sp_object_stats for variable @rpt_line with bigger length.



CR:348468
CR Number:   348468
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)
02 Apr 2009 Insufficient priority to fix
Description
In ASE 12.5.0.3 and before, the command 'sp_cacheconfig <cachename>,

"cache_partition=<number>"' processed a change that went into effect when the

server was rebooted.



In ASE 12.5.1, running the same command returns messages (Msg 10850 and 10875, both

undocumented) that make it appear that it doesn't work. What is happening is a

confusion between what ASE 12.5.1 can do dynamically, and what it does do statically

DESPITE the messages. We need to make message changes.



CR:348513
CR Number:   348513
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2004 Fixed
03 May 2004 Fixed
28 Aug 2004 Fixed
31 Aug 2004 Fixed
28 Sep 2004 Fixed
Description
Enhance DBCC CHECKTABLE for empty ALLPAGES LOCKED tables to report error if the root page of the index has extraneous entries even though the table is empty.



CR:348534
CR Number:   348534
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)
26 Jul 2004 Fixed
Description
In a server with Case-insensitive sort order, a SELECT can use the same column

more than ones with different case (ex: Col, coL), but the header of the result set

is the same for the columns.
Workaround Description
 specify a label for the default column heading





1> select nAme as "nAme" from sysobjects o

2> where exists (select 1 from syslogins where o.NaME = "sp_configure")

3> go



CR:348573
CR Number:   348573
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)
05 Jul 2004 Fixed
Description
The value of @@rowcount is reset when a a stored procedure or trigger is recompiled.



CR:348590
CR Number:   348590
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2004 Fixed
14 May 2004 Fixed
02 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
The message "current process infected with 11" in the module 'q_alloc_restart' together with a stack

trace which includes the modules 'q_oreop_fill' and 'substitute' may be reported in the error log for

an query at isolation level 0 that includes a HAVING clause with an OR.
Workaround Description
 Use 'where' clause instead of 'groupby having in'



CR:348674
CR Number:   348674
Product Name:   Adaptive Server Enterprise
Product Component:   langinstall
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2004 Fixed
14 Jun 2004 Fixed
22 Jun 2004 Fixed
Description
When installing a language other than English, message number 19178

in the different language cannot be installed.



CR:348686
CR Number:   348686
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2004 Bundled Request
Description
ASE 12.5.1 on Red Hat Linux AS 2.1 core dumps when 'max memory' is set to greater than 2.75GB.
Workaround Description
 Right now there is now way to achieve > 2.7 gb of max memory on Linux.



CR:348693
CR Number:   348693
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)
12 Aug 2004 Fixed
Description
HA Scripts are updated to use specific options to get the command name from the /usr/bin/ps command
Workaround Description
 Hardcode the value in the script as it is unlikely that a process will get the same process id in the .krg file of dataserver.



from utils.ksh (is_ase_running) :



# 5th column of /usr/ucb/ps output is full path command name. Extract

# just the command name from it and check for "dataserver"

str=`print $ps_out | nawk '{print $5}'`

log_callback_msg -dim "Command name from ps output is: $str"

str=`basename $str`

str="dataserver" <------ Added line

if [[ "$str" != "dataserver" ]]; then



CR:348732
CR Number:   348732
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)
16 Jun 2004 Fixed
Description
Added support for SELECT INTO/INSERT INTO to insert from a

materialized UNION ALL containing text/image columns.



CR:348743
CR Number:   348743
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)
25 Aug 2008 Fixed
Description
New Feature: Java in ASE to support java.security package.



CR:348866
CR Number:   348866
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2014 Insufficient priority to fix
16 Mar 2010 EOL'd version. Not to be Fixed.
Description
Cust would like to be able to take samples like they can do this with sp_sysmon

and reset monitoring counters to 0 as needed.



CR:348878
CR Number:   348878
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2004 Fixed
04 May 2004 Fixed
Description
An attempt to run an interactive program under xp_cmdshell may hang the xpserver.



CR:348881
CR Number:   348881
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2004 Fixed
Description
Increase output filename length in historical server



CR:348895
CR Number:   348895
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2004 Fixed
Description
Outer join with a VIEW having UNION ALL fails with error 11054 :

"The table 'table name' is an inner member of an outer-join clause. This is not

allowed if the table also participates in a regular join clause."



CR:348971
CR Number:   348971
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)
10 Jun 2005 Fixed
24 Jun 2005 Fixed
07 Jul 2005 Fixed
21 Jul 2005 Fixed
Description
When the SELECT * is expanded while storing the text of a stored procedure, identifiers

consisting of multiple parts will be stored in syscomments using bracketed identifiers. For example

a columnname like <colname_part1 part2> is stored like [colname_part1 part2]. The same will

happen for table-names consisting of multiple parts.



CR:349033
CR Number:   349033
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   HP-UX
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2004 Fixed
06 Aug 2004 Bundled Request
Description
sybmigrate may fail to migrate a table that was created by a user other than dbo.



CR:349165
CR Number:   349165
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2004 One-off Provided
Description
INSTRUMENTATION: ASE disappears without any message in the errorlog resulting in a core dump.

Core file indicates that thread library function pthread_sighandler_rt() encountered Signal 11

due to corrupted memory address for thread handle.



CR:349194
CR Number:   349194
Product Name:   Adaptive Server Enterprise
Product Component:   DBXray
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
To Be Determined 12 Mar 2004 Fixed
Description
DBXray needs to provide support for Linux



CR:349240
CR Number:   349240
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)
23 Mar 2004 Fixed
Description
When a wizard page or properties page is active, the focus should be set to the first text field. This makes it easy to enter text without using the mouse to focus first.



CR:349251
CR Number:   349251
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2005 Presently Not Targeted For Any Future Release Of This Product
18 May 2004 Fixed
Description
When a single long transaction is aborted in a primary database because it has filled up the log, replication agent is not able to move the secondary truncation point, even if all transactions have been processed by replication agent.
Workaround Description
 alter the log with more space until adequate space is created.



CR:349279
CR Number:   349279
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)
06 May 2004 Fixed
Description
ASE incorrectly handles user defined execution classes whose names begin

with "EC0", "EC1", "EC2", or "EC3". In these cases ASE will apply the

system defined attributes for the user defined execution class rather than

the user defined attributes.
Workaround Description
 Avoid execution class names that begin with EC0, EC1, EC2, or EC3



CR:349286
CR Number:   349286
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)
16 Mar 2004 Fixed
Description
Conversions from other datatypes (notably varbinary) to unichar/univarchar

will cause a process to terminate with a stack trace if the source data is

not aligned on a data page.



CR:349337
CR Number:   349337
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2004 Fixed
Description
Makefile for sample xp_echo on the windows platform does not have include paths set.



CR:349420
CR Number:   349420
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2004 Fixed
Description
The sybatch.exe sample resource file "sybatch_sample.res" has incorrect values in "msrv.network_hostname_list" and "bsrv.network_hostname_list" attributes.



CR:349434
CR Number:   349434
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2004 Fixed
Description
A spinlock order violation and ASE panic occurs upon

first kerberos login and recovery or other highly concurrent

activity is also running.



Invalid spinlock sanity checks are avoided with this fix.



CR:349480
CR Number:   349480
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)
22 Feb 2005 Fixed
14 May 2007 One-off Provided
07 Oct 2007 Fixed
Description
The message "current process infected with 11" in the module 'oj_syboj_markojonclause' may be reported in the error log when executing a SELECT with invalid cyclic outerjoin.
Review Status
 An illegal outer join query may result in an infected with 11 with aa stacktrace containing function call oj_syboj_markojonclause rather than raising an appropriate error message.



CR:349567
CR Number:   349567
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)
23 May 2004 Fixed
Description
CIS: stacktrace in omni_plan_subst() when selecting a text/image column from a proxy table using an order by clause whereby the column used for ordering is not in the select list.



CR:349670
CR Number:   349670
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)
30 Aug 2004 Fixed
Description
If a master database is loaded onto a master device whose size is not the same as that shown in the dump, the correct size is replaced by the size contained in the dump. The device's previous size should be retained after the load completes.
Workaround Description
 Workaround 1: run "disk resize" on master db. CAUTION: using this method, there must not be any databases already existing in the parts of the master device that will be affected by the resize operation, because those pages will be cleared.



Workaround 2: allow updates to system tables; update sysdevices to show correct "high" value for master device; disallow updates to system tables. If there were any existing databases in the affected areas of the master device, run "disk refit".



CR:349693
CR Number:   349693
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2004 Fixed
25 Jun 2004 Fixed
Description
The message, "current process infected with 11" in the module 'copyconstant' together with a stack

trace which includes the modules 'q_norm_const' and 'decision' may be reported in the error log if

a SELECT with two or more aggregates has a WHERE clause on a text constant of more the 450 characters.
Workaround Description
 The where clause of the repro does not make sense, we compare a char(5) with a string of

about 500 characters. The problem does not happen with a 12.0.x server when the string

is less than 450 characters. For 125, this does not happen when the string in less than

16 K.



CR:349701
CR Number:   349701
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2004 Fixed
Description
syconfig/srvbuild[res] allows users to create >32GB master device



CR:349724
CR Number:   349724
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)
28 Jun 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Feature request: traceflag to enable statistics for out of range equi-sargs.



CR:349735
CR Number:   349735
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)
27 May 2004 Fixed
15 Jun 2005 EOL'd version. Not to be Fixed.
10 Nov 2004 Fixed
10 Nov 2004 Fixed
Description
When server's default character set is GB18030, timeslice error occurs when converting

Unicode surrogates to GB18030.



CR:349774
CR Number:   349774
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2012 Duplicate
Description
Feature request: add a "Materialized View" feature as in Oracle.



CR:349790
CR Number:   349790
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2004 Fixed
Description
CIS : Execution of multiple Extended Stored Procedures might result in performance improvement due to an efficient connection establishment model when routed through CIS RPC mechanism after both 'cis rpc handling' and 'negotiated logins' options are turned on.
Workaround Description
 Purchase an Open Server license and use cis rpc handling



CR:349883
CR Number:   349883
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)
04 Aug 2004 Fixed
Description
The SQL batch identifiers reported by monDeadLock (HeldBatchID) and monSysSQLText (BatchID) do not match. This makes it impossible to join these tables to get the SQL Text of the processes involved in the deadlock.



CR:349964
CR Number:   349964
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)
20 Apr 2004 Fixed
29 Apr 2004 Fixed
Description
The process of serialize/deserialize java objects in ASE can cause

some performance issues in a multi-session environment.



CR:350098
CR Number:   350098
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)
30 Aug 2004 Fixed
Description
If for any reason dbcc checkstorage() cannot access the database being checked, it continues processing anyway. This causes many spurious error messages to be printed.



CR:350109
CR Number:   350109
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)
24 Mar 2004 Fixed
Description
This fixes a straggle problem not caught by CR 348687-1. For the user:



In 12.5.1, the job timeout property was labelled to be in seconds. This value was actually treated as minutes. This fix changes the labels for the timeout property to say minutes in 12.5.2.



CR:350211
CR Number:   350211
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2005 Fixed
22 Jun 2005 Fixed
Description
Jobs attached to repeating schedules with a 0 interval run multiple times when the schedule start time arrives.
Workaround Description
 *** Monday, January 31, 2004 *** mmorriso ***

Based on Chris' analysis (see resolution 1), the following will prevent this problem until the GUI and stored procs can be changed to prevent the user from creating a recurring job without setting any recurrency constaints.



If the user selects the Between start time option, a recurrence option must be selected.



If the user doesn't want one of the recurrence options, select the At start time option.





*** Tuesday, March 23, 2004 10:16:11 AM *** cooperg ***

Creating the Job first appears to work in my testing.



CR:350291
CR Number:   350291
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2005 Fixed
Description
sp_syntax does not include mount/unmount command help
Workaround Description
 Add the following to ins_syn_sql script, manually:



exec insert_syntax 'mount',

'Transact-SQL', 1 ,

'mount - Use the mount command to attach the database to the destination'

go

exec insert_syntax 'mount',

'Transact-SQL', 2 ,

'or secondary Adaptive Server.'

go

exec insert_syntax 'mount',

'Transact-SQL', 3 ,

'mount database all from <manifest file> [with listonly]'

go

exec insert_syntax 'unmount',

'Transact-SQL', 1 ,

'unmount - unmount command shuts down the database and drops it'

go

exec insert_syntax 'unmount',

'Transact-SQL', 2 ,

'from the Adaptive Server. Devices are also deactivated and dropped.'

go

exec insert_syntax 'unmount',

'Transact-SQL', 3 ,

'unmount database <dbname list> to <manifest file>'

go



CR:350352
CR Number:   350352
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2004 Third Party Problem
Description
CIS transmits bulk copy data in suboptimally sized packets
Workaround Description
 BCP data out to a flat file and then bcp back in to the remote server.



CR:350392
CR Number:   350392
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2004 Presently Not Targeted For Any Future Release Of This Product
08 Apr 2004 Fixed
14 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
This CR disables change made by 319389 (A sub-optimal query plan may be generated for queries using MAX() or MIN() together with WHERE clauses that involve OR clauses.). Use trace flag 4110 to enable fix for 319389.
Workaround Description
 *** Wednesday, March 24, 2004 10:58:01 AM *** cooperg ***

Backout fix for 319389 which will break other customers. Not a good idea.

If fix involved just special OR (eg in clause or sargs like c1 = 5 or c1 = 10) then

enable tf 304 to turn off special OR for this query.



CR:350475
CR Number:   350475
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)
09 Aug 2004 Fixed
Description
The error 7156 together with a stack trace that includes the modules textconvert

and txt_readchar, may be raised when trying to convert a text column to any

other datatype, if the text page was created in a version prior to 12.5.
Workaround Description
 We can fix this problem by using the following ways.

1) Use dbcc rebuild_text

dbcc rebuild_text will not change txtoff_high and txtoff_low.

dbcc rebuild_text updates timestamp of page header and then

ASE can recognize the text page is the latest.

That means that ASE no longer needs calling txt__get_col().

As a result, we can prevent error 7156.

2) Drop and recreate the table and then run bcp in with extraced data.

Or use select into.



CR:350523
CR Number:   350523
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2005 Presently Not Targeted For Any Future Release Of This Product
30 Apr 2004 Fixed
Description
DATE and TIME datatype columns with a CONVERT builtin on proxy_table mapped to DCO will not work.



CR:350550
CR Number:   350550
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2004 Fixed
Description
When a statement that has been successfully cached is followed by successive normalization

errors a stack trace may happen. This occurs only with the statement cache enabled.



CR:350563
CR Number:   350563
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2009 Insufficient priority to fix
Description
substring and pagesize in same query and particular order returns pagesize as NULL on windows and linux, whereas causes a stacktrace on solaris.
Workaround Description
 In the query select pagesize first and then substring the column name.



CR:350567
CR Number:   350567
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)
10 Aug 2004 Fixed
07 Oct 2004 Fixed
Description
When a database is not useable, the command checkpoint [db |all] fails silently.



CR:350576
CR Number:   350576
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2004 Fixed
Description
Msg 207, "Invalid column name <column name>" is raised when executing a SELECT with a

subquery in the select-list which is referencing a column defined in the derived

column list of a derived table expression in the FROM clause.



CR:350581
CR Number:   350581
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2004 Not a Bug
Description
The sp_monitorconfig 'number of locks' report does not show correct "active" value. "HWM" may also be incorrect, but harder to prove. In a completely idle system, sp_monitorconfig will still show some number of active locks.





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