远程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:401927
CR Number:   401927
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2005 Fixed
Description
When configuration parameter 'enable real time messaging' is set to enable the RTMS feature on Windows, initialization fails during ASE startup sequence with an unhandled exception error for ExceptionCode: c0000005. This makes the RTMS feature of ASE unusable on Windows platform in ASE15.0 GA release.



CR:401954
CR Number:   401954
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   11.5.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2005 Fixed
Description
New feature request to set a maximum wait time limit to SHUTDOWN. The new syntax is SHUTDOWN [WITH WAIT [ = "xx:xx:xx" ] | WITH NOWAIT ]
Workaround Description
 *** Thursday, August 25, 2005 9:58:57 AM *** cooperg ***

N/A



CR:401988
CR Number:   401988
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2006 Fixed
27 Aug 2005 Fixed
20 Dec 2006 Fixed
Description
Syconfig and other client applications will not able to connect to the Adaptive Server if it was booted with named pipe.
Workaround Description
 Remove the named pipe directory service from the interfaces file before upgrade the ASE.



CR:402002
CR Number:   402002
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)
21 Sep 2005 Fixed
19 Oct 2005 Fixed
25 Oct 2005 Fixed
Description
The message 'Legal optimizer criteria must be INT' is printed when running some 'SET' commands.



CR:402029
CR Number:   402029
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2006 Fixed
31 Mar 2006 Fixed
06 Apr 2006 Fixed
03 Mar 2008 Presently Not Targeted For Any Future Release Of This Product
Description
When performing a post error cleanup ASE may enter in the infinite loop trying to allocate memory. Very long stack trace will show multiple occurances of following sequence of calls : {s_handle,s_cleanframe,s_copytmps,memcreate,ex_raise}



CR:402044
CR Number:   402044
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2005 Fixed
Description
Incorect value may be assignment to the local variable if the query is executed

in the parallel and the query has a scalar aggregate. This problem may happen if

the showplan output shows multiple query steps with "Parallel result buffer merge"

execution strategy.
Workaround Description
 Add a dummy expression: max(id) + 0

See also the workarounds in the P&T Guide, When parallel query results can differ, Achieving consistent results.



CR:402075
CR Number:   402075
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2005 Fixed
Description
When upgrading to 15.0 from 12.5.x, if the configured 'procedure cache size' is the default, upgrade may fail due to Error 701. To work around this, ensure that the procedure cache size is at least 12000.



CR:402082
CR Number:   402082
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2005 Fixed
Description
On the HP platform HTTPS (SSL) is not available for ASE WebServices. The HTTP transport is not affected, however.



CR:402099
CR Number:   402099
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)
14 Sep 2005 Fixed
Description
Many tools need to get an estimated cost from a query plan without executing the query. This cost is used to compare estimated plan cost in 15.0 vs the actual cost in pre 15.0 query plan. A new "set option" called show_final_plan_xml has been added that prints a query plan before the query gets executed along with its estimated logical and physical I/O.



CR:402102
CR Number:   402102
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2005 Fixed
29 Aug 2005 Fixed
30 Aug 2005 Bundled Request
Description
Job Scheduler utility scripts fail on Windows platforms due to error in statement to set an environment variable.



CR:402115
CR Number:   402115
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2005 Fixed
Description
On sol64 platform ,jcs.jar file didn't exist in the dir decripted by the former testcase ($SYBASE/ASE-12_5/Sample/JavaSqlXml/SQLX-examples). The jcs.jar file exist in the dir ($SYBASE/lib).So must be modified the testcase.



CR:402171
CR Number:   402171
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 Nov 2005 Fixed
Description
(OPTIMIZER) The estimated total cost of the final plan as displayed by the output of traceflag 310 may be incorrect in the case of a query with joins on more than 4 tables.



CR:402212
CR Number:   402212
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2005 Fixed
Description
When the 'optimization timeout limit' option is configured via sp_configure, then the newly configured value is not reflected in the session (visible via the @@opttimeout global variable) that invokes sp_configure.



The query plans generated in the invoking session may thus be based on the previous 'optimization timeout limit' value instead of the newly configured value.



CR:402274
CR Number:   402274
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2005 Fixed
12 Jan 2006 Not reproducible with latest version of the product available as of Resolution Date
Description
Query with equi-sargs predicates containing IS NULL on indexed columns can result

in wrong selectivity estimation.



CR:402310
CR Number:   402310
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2005 Not a Bug
Description
ASE does not allow creation of tables with Unicode characters.

ASE will report the following error when trying to use Unicode

characters in a table or column name:

Msg 102, Level 15, State 1:

Server 'ase_125', Line 2:

Incorrect syntax near '琴'.
Workaround Description
 Create tables and columns with non-utf8 characters.



CR:402324
CR Number:   402324
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2005 Fixed
Description
The sybmon stack command has been extended to support dumping metadata for

all threads running a parallel query plan. The new command is:



stack family <alfa_spid>



Note, that alfa_spid must be the spid of the parallel plan's alfa thread.



CR:402353
CR Number:   402353
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2005 Bundled Request
Description
If a SQL update statement uses an assignment of an encrypted column

into a T/SQL local variable or parameter (@variable), Adaptive Server

may return Msg 15445: "The datatype of the ciphertext data (NUMERIC)

is incorrect for column ''."



CR:402355
CR Number:   402355
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2005 Fixed
07 Sep 2005 Fixed
Description
The message, process infected with 11 in 'proc__setdb_derived_table' is printed in the errorlog

together with a stacktrace containing the modules 's_getTreeOrPlan', 'proc_setdb' and

'proc__setdb_tree' when a SELECT statement containing a derived table expression is executed.

ASE must be configured with user defined tempdbs and statement cache on.



CR:402362
CR Number:   402362
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2005 Not a Bug
Description
ECDA DB2 UDB: ASE/CIS cursor date parameter was bound as datetime. The date parameter is now bound as date.



CR:402435
CR Number:   402435
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2005 Fixed
Description
Previously in 15.0 GA, DBISQL launch script "dbisql.bat" (Windows) and "dbisql" (Unix platforms) contained invalid argument "-path" that caused the script to fail. This has been fixed. (The correct argument is "-Dpath".)'



CR:402438
CR Number:   402438
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)
18 Sep 2005 Fixed
01 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date
02 Nov 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
sub-optimal performance may result when a query is executed in execute immediate mode.



CR:402441
CR Number:   402441
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)
01 Mar 2006 Fixed
Description
This CR implements 'dynamic partition elimination': when predicates such as 'where part_col = @v' appear in a query on a table that is semantically partitioned on 'part_col', the query execution engine will determine the partition that could contain matching values based upon the semantic partitioning conditions, at execution time, when the value of @v is known. The partitions that cannot contain matching values are eliminated from the scan operation. Dynamic partition elimination will also be applied to nested-loop join operations, where the substituted value of the column of the outer table is known before the inner table is scannned.

A new message will appear in showplan output when dynamic partitioning is active:

[ Using Dynamic Partition Elimination ]
Target Version
 15.0 ESD#2



CR:402472
CR Number:   402472
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2008 Fixed
26 Aug 2008 Fixed
Description
Historical Server playback mode returns incorrect information on 64bit platforms.
Workaround Description
 Use a 32bit version of the Historical Server.



CR:402476
CR Number:   402476
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2005 Not reproducible with latest version of the product available as of Resolution Date
13 Jun 2006 Fixed
25 Aug 2006 Fixed
Description
The message "An internal memory management error has occured. Error code: Invalid slot id." may be reported in the error log

when Adaptive Server encounters some problems while distributing the work among worker processes

and ends up without proper clean-up of the worker processes in some rare cases.



CR:402536
CR Number:   402536
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2005 Fixed
05 Dec 2005 Fixed
09 Nov 2005 Fixed
24 Nov 2005 Duplicate
Description
XPServer fails to start on linuxia64 platform with default value of "esp execution stacksize" parameter.
Workaround Description
 Increase the "esp execution stacksize" using sp_configure.



CR:402574
CR Number:   402574
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 way to have serverwide dbcc traceflag output go to a log file other than the errorlog.



CR:402610
CR Number:   402610
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2005 Fixed
Description
On the Windows platform, the message "KERNEL structure not padded correctly - size = 5288" appears at the start of the ASE boot sequence.



CR:402615
CR Number:   402615
Product Name:   SySAM
Product Component:   SyLAPI/C
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Oct 2005 Fixed
Description
Report values of SYBASE_LICENSE_FILE and LM_LICENSE_FILE environment variables as they are used to find licenses, if set.



CR:402632
CR Number:   402632
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2006 Fixed
09 Jul 2006 Fixed
Description
Backupserver might delete shared memory with id 0 when dump command fails.



CR:402694
CR Number:   402694
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2005 Fixed
Description
A SELECT SUBSTRING(...) statement on a proxy table mapped to a remote table on DB2 using the DirectConnect/DRDA results in an ILLEGAL SYMBOL error from DB2.



CR:402717
CR Number:   402717
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 Sep 2005 Fixed
23 Sep 2005 Fixed
Description
After the cross platform dump and load (XPDL), the space utilization

is not handled correctly, and an index is unnecessarily rebuilt

by sp_post_xpload, if variable length index key was greater than

252 bytes. Also some page corruptions happen in DOL index root page,

in DOL non-leaf index page for UNICHAR NOT NULL index key in some cases,

and in a special case of slice control page if the database dump is from 11.9.x.



CR:402725
CR Number:   402725
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2005 Fixed
Description
UNION queries may return wrong results in very limited circumstances.

This may occur if the select list of the first SELECT contains duplicate

column references.



CR:402732
CR Number:   402732
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2005 Fixed
02 Jan 2006 Fixed
31 Oct 2005 Fixed
03 Mar 2006 Fixed
10 Jan 2006 Fixed
09 Jan 2006 Fixed
03 Feb 2006 Fixed
Description
This fix enhances the query optimizer's ability to find optimal query plans for complex queries more quickly without compromising on plan quality. The enhancement primarily comes from changes made to the ASE query optimizer's optimization timeout mechanism and greedy search strategy. The following user interface changes have also been made for the optimization timeout mechanism:



At the server level:



sp_configure "optimization timeout limit", <0..1000>

- this option is now valid for ad-hoc queries only

- the range has changed from <1..1000> to <0..1000>

- the value 0 represents "no timeout"

- the default is still 10



sp_configure "sproc optimize timeout limit", <0..4000>

- this option has been introduced for stored procedure queries

- the is from <0..4000>

- the value 0 represents "no timeout" at server level

- the default is 40



At the session level



set plan opttimeout <0..4000>

- this can be specified for both ad-hoc queries or stored procedures

- the range has changed from <1..1000> to <0..4000>

- the value 0 represents "no-timeout" at session level

- for ad-hoc queries, values specified above 1000 are discarded and default of 10 is used



At query level



select * from TabA ...

plan

"(use opttimeoutlimit <0..4000>)"

- only <0..1000> can be specified for ad-hoc queries

- <0..4000> can be specified for stored procedures

- a value of "0" represents no-timeout at the query level
Workaround Description
 Place the empty #tmp table at the beginning of the FROM list



CR:402733
CR Number:   402733
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)
07 Oct 2005 Fixed
25 Oct 2005 Fixed
Description
ALTER TABLE DROP command with more than 9 text columns fails with signal 11 in oh_insert.
Workaround Description
 Break the "alter table drop" command into two commands, eg

alter table call_req

DROP z_srvc_impdesc1,z_srvc_impdesc2, z_srvc_impdesc3,z_srvc_impdesc4, z_srvc_impdesc5

go

alter table call_req

DROP z_srvc_impdesc6, z_srvc_impdesc7, z_srvc_impdesc8,z_srvc_impdesc9, z_srvc_impdesc10

go



CR:402768
CR Number:   402768
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Loading a dump of a smaller database into a larger one may cause the segmaps of fragments beyond the size of the dump to change.



CR:402835
CR Number:   402835
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)
09 Sep 2005 Fixed
Description
The message "current process infected with 11" in the module 'dbt_unkeep'

followed by a stack trace may be reported in the error log when a session

is detaching from an external transaction and the revert to the database

that was active at the time of the attach has failed. The modules

'xact__detach_external' and 'closedb' will also be reported. As a result

an implicit shut down of ASE will occur.



CR:402846
CR Number:   402846
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2005 Fixed
Description
The error 1945 "Cannot create unique index 'ix1' on table 't'. The table

partition condition and the specified index keys make it impossible

to enforce index uniqueness across partitions." will be reported

only when the user tries to create a unique local index; the issue

doesn't apply to a unique global index.



CR:402855
CR Number:   402855
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)
03 Oct 2005 Fixed
30 Aug 2006 Fixed
Description
A SELECT INTO using the the identity() function generates zeros for some rows when using a derived

table based on a UNION ALL or a view containing a UNION ALL.
Workaround Description
 Use trace 4404



CR:402897
CR Number:   402897
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)
19 Oct 2005 Fixed
03 Feb 2006 Fixed
Description
Performance problem could occur when a query has 2 or more IN lists that can be applied to the same composite index on different keys. The behavior was that the index will likely be chosen in the query plan, but if this index was a weak choice, then there could be a performance problem.



e.g. select * from T where T.a IN (1,2) and T.b IN (5,6) and ... some other predicates



suppose an index existed on T(a,b) and all rows of the index qualified with the above predicate, then a full index scan with lookup of all data rows will occur, which would normally be much slower than a simple table scan or some other index scan with the remaining predicates.



CR:402902
CR Number:   402902
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)
09 Jan 2006 Fixed
10 Mar 2006 Fixed
Description
For an INSERT ... SELECT query a 14108 error or 605 error can occur if all of the following conditions are met:

The rows to be inserted contain at least one LOB column (TEXT, IMAGE or UNITEXT);

The SELECT that generates the values to be inserted must access at least two distinct tables, each with a LOB column;

The query plan must use a HashDistinct operation, i.e. the showplan output contains:

HASH DISTINCT Operator.

The 14108 error can occur if at least one table in the query has no LOB columns. If all tables in the query have LOB columns, the 605 error can occur.
Target Version
 15.0 ESD#2



CR:402918
CR Number:   402918
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)
09 Sep 2005 Fixed
Description
Running ASE 15.0 GA, Load Database performed upon a 12.5.x dump of a database

that has replicated stored procedures can fail on this error:



Error: 632, Severity: 20, State: 2

Attempt to move memory with an incorrect length of -166. Maximum

allowed length is 16384.
Workaround Description
 Perform Dump Database when there are no active transactions.



CR:402920
CR Number:   402920
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2005 Fixed
Description
After dropping a column using ALTER TABLE, the computed columns defined after the dropped column as well as any function-based indexes do not work properly.



CR:402922
CR Number:   402922
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)
13 Oct 2005 Fixed
Description
After 32bit <-> 64 bit or cross-platform dump load,

if server is shutdown and boot again, accessing semantically

partitioned table or roundrobin partitioned table with global

clustered/placement index may run into segv.
Workaround Description
 No Workaround.



CR:402925
CR Number:   402925
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)
13 Sep 2005 Fixed
Description
A stacktrace may occur when an error is raised while executing a query that has a hash join,

a hash distinct or a hash union operator in its plan.

This stacktrace contains the functions : LeHashOp::_LeClose() and soextdealloc().



CR:402986
CR Number:   402986
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   macosx
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2005 Fixed
Description
Installjsdb released with ASE 1253 ESD#3 on Mac OS is an incorrect version

and causes Job Scheduler not to function on Mac. This affects only Mac OS platform.

ASE reports in errorlog messages like "Incorrect Job Scheduler sequencer version found

within 'sybmgmtdb'", "Job Scheduler can not operate, Expected 0:27:27, Actual 0:26:26",

"Job Scheduler failed installing its required sequencer code",

"Job Scheduler Task failed to initialize", "Job Scheduler Task state set to stop".



CR:403071
CR Number:   403071
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2005 Fixed
08 Oct 2005 Fixed
Description
Update auditinit for sunx86 platform. Previous release has incorrectly shipped auditinit from other platform.



CR:403075
CR Number:   403075
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2005 Fixed
15 Sep 2005 Fixed
21 Sep 2005 Fixed
Description
Update auditinit for HPIA64 platform. Previous release has incorrectly shipped auditinit from other platform.



CR:403077
CR Number:   403077
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   macosx
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2005 Fixed
05 Apr 2006 Fixed
03 Apr 2006 Fixed
Description
Installjsdb released with ASE 1253 ESD#3 on Mac OS is an incorrect version

and causes Job Scheduler not to function on Mac. This affects only Mac OS platform.

ASE reports in errorlog messages like "Incorrect Job Scheduler sequencer version found

within 'sybmgmtdb'", "Job Scheduler can not operate, Expected 0:27:27, Actual 0:26:26",

"Job Scheduler failed installing its required sequencer code",

"Job Scheduler Task failed to initialize", "Job Scheduler Task state set to stop".



CR:403079
CR Number:   403079
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)
21 Dec 2006 Fixed
21 Dec 2006 Reservation Made
Description
When a transaction is aborted due to excessive stack usage, ASE prints only diagnostics related to offending task. It doesn't produce diagnostics regarding query context available before abort. This CR addresses problem by printing information on stored procedure nesting level and open transactions under new traceflag.



CR:403129
CR Number:   403129
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2005 Fixed
Description
The message 4408, "The query and the views in it exceed the limit of 50 tables." is raised with

severity 19. This severity is too high and should be 16.
Workaround Description
 n/a



CR:403130
CR Number:   403130
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)
31 Mar 2006 Fixed
Description
Some option settings may not be exported from login trigger to the

session level.



CR:403208
CR Number:   403208
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2010 Insufficient priority to fix
Description
the EBF/ESD installer should give option to run installmaster script...and...

...other scripts...

installmaster (instmstr on Windows) Script

installcommit (instcomm on Windows) Script

installsecurity (instsecu on Windows) Script

instmsgs.ebf Script

inst_ha_scripts.sh Script (Sun Solaris only)

installhasvss (insthasv on Windows) Script

installdbccdb (instdbcdb on Windows) Script

...after all the files for the EBF/ESD are placed on the hard drive.
Workaround Description
 http://www.sybase.com/detail?id=1013610



CR:403382
CR Number:   403382
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)
05 Oct 2005 Fixed
Description
CIS: In some circumstances, running sp_showplan on a multi-engine server with sessions involving CIS query or MDA tables may be infected with signal 10 or 11 and core dumps, or causes ASE to

hang.



CR:403384
CR Number:   403384
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2005 Fixed
14 Mar 2006 Fixed
02 Jun 2006 Bundled Request
Description
The sqlupgrade utility may initiate the upgrade process for the server before all databases in the server have completed recovery.



CR:403391
CR Number:   403391
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   AIX
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 11 Sep 2005 Fixed
Description
Auditinit now ported to ASE15.0 in ESD1 on IBM64.



CR:403392
CR Number:   403392
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)
14 Sep 2005 Fixed
10 Oct 2005 Fixed
10 Oct 2005 Fixed
Description
When an update command tries to update a column with the result from a cursor fetch and

a deferred update causes the cursor position to be lost, a signal 11 and stack

trace including LeDMLOp::_LeOpClose() may occur.



CR:403461
CR Number:   403461
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2006 Fixed
22 Mar 2006 Fixed
05 May 2006 Fixed
Description
This fix is to update logic of counting physical processors considering introduction of SMT (Simultaneous multithreading) capable Power5 processors.



CR:403462
CR Number:   403462
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)
12 Oct 2005 Fixed
20 Mar 2006 Fixed
20 Mar 2006 Fixed
Description
This fix is to support additional license type "EV" for evaluation period license.



CR:403476
CR Number:   403476
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)
06 Apr 2006 Fixed
Description
The Sysprocesses.time_blocked column unexpectedly shows a NULL value for

server tasks being blocked by a detached distributed transaction.



CR:403537
CR Number:   403537
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 2009 Duplicate
Description
When using large 'sql text pipe max messages' and 'plan text pipe max messages', changing "current audit table" from 1 to 2 could causes MDA/FDP error.
Workaround Description
 *** Monday, September 12, 2005 1:35:56 PM *** cooperg ***

N/A



CR:403564
CR Number:   403564
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2005 Duplicate
Description
sp_displayaudit returns arithmetic overflow on Windows XP when auditing is configured at the database level.



CR:403592
CR Number:   403592
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)
14 Sep 2005 Fixed
03 Apr 2006 Fixed
Description
Error 4022 should have a severity of 10, but a severity of 16 is raised which results in ODBC connections being refused.
Workaround Description
 None.



CR:403597
CR Number:   403597
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)
10 Jan 2006 Presently Not Targeted For Any Future Release Of This Product
Description
sp_monitorconfig may report more active locks than found in syslocks.



CR:403600
CR Number:   403600
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2005 One-off Provided
19 Jan 2006 Fixed
23 Feb 2006 Fixed
14 Feb 2006 Fixed
Description
On HP-UX Itanium platform, the stacktrace in case of a crash doesn't include all the frames and may also report wrong function names even though we have the correct instruction pointer.



CR:403638
CR Number:   403638
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)
19 Jan 2006 Bundled Request
Description
The warning message 9827 reading "Control page <PageNumber> upgrade for partition number

<PartitionNumber> for object ID <ObjectId> in database <DatabaseName> may not have

been done correctly ..." may wrongly be reported under the previous object section for DBCC checkalloc.



CR:403662
CR Number:   403662
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2005 Fixed
Description
Fixed possible wrong result for queries whose plan
contains a DistinctSorting and one of the DistinctSorting's
projection is a column with a search clause <the column>=constant
on it. The wrong result typically only showed up under heavy server load.
Target Version
 15.0 ESD#1



CR:403678
CR Number:   403678
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2005 Fixed
Description
In ASE 12.5.3 ESD#1, ESD#2 and ESD#3 coverletter on Windows platform,

instructions for removing the "sybase" account from Windows system-defined group "Administrators"

after performing the steps needed to improve security is missing. This can leave the

"sybase" account with a higher privilege than needed.



CR:403797
CR Number:   403797
Product Name:   Adaptive Server Enterprise
Product Component:   Graphical Plan Viewer
Status:   Closed
OS:   NA
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2005 Fixed
20 Sep 2005 Fixed
Description
The XML for showplan_in_xml has been enhanced to cater to the changes in ASE for 15.0 ESD #1.

The new XML has information that tries to bridge more gap between the text version of showplan and the xml version.



For all Objects/Nodes the following Important attributes are added

1) Abstract Plan

2) Overall Cost

3) Resource

4) Optimizer Metrics

5) Optimizer Statistics [Including object for which stats is missing]



CR:403831
CR Number:   403831
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)
24 Oct 2005 Fixed
Description
Msg 12802, "Invalid partition number <number>. Valid partition number is a positive integer."

is raised when the UPDATE PARTITION STATISTICS command is executed. The partition number is

omitted but instead the WITH SAMPLING <number> clause is used.



CR:403842
CR Number:   403842
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2005 Fixed
Description
In rare circumstances the message "current process infected with 11" in the

module 'senderror' may be reported in the error log together with a stack

trace when executing a prepared dynamic statement.
Workaround Description
 N/A



CR:403910
CR Number:   403910
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2005 Bundled Request
Description
A 14108 error "Could not find partition descriptor for objid 8, indid 255, ptnid 8

in dbid <value>." followed by the message "ASE is terminating this process." may be

raised when using datalength() built-in function on TEXT/IMAGE columns within a TRIGGER.

The stack trace being reported in the error log will show modules 'LeRun', 'textsize',

'gettxtpage' and 'open_partition'.



CR:403968
CR Number:   403968
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2005 Fixed
Description
REORG REBUILD on a single data partition is not supported

yet. Added an error message 11935 in rbld_main() to warn

the user.



CR:403972
CR Number:   403972
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)
04 Oct 2005 Fixed
Description
On SuSE 32 bit Linux platform (SuSE 9 SP1 or later), ASE incorrectly identifies AIO to be KAIO

while using Posix AIO. This can lead to ASE hang. Solution is to start ASE with trace flag 1630.



CR:403975
CR Number:   403975
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)
21 May 2006 Not a Bug
Description
If ASE has a default character set of utf8 and a client application

uses this same charset, then ASE may return the wrong number of characters

for the given column descriptor when a built-in function such as left()

is executed.



CR:403978
CR Number:   403978
Product Name:   Adaptive Server Generic Docs
Product Component:   XA Guide for CICS Encina and Tuxedo
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2005 Fixed
Description
Change...

Chapter 2 Understanding Component Integration Services

Proxy tables

Using the create proxy_table command

...

This section should also include the

statement...create proxy_table...updates

system tables sysobjects, syscolumns,

and sysindexes

...



...making it similar to the previous section on create existing table.



CR:403979
CR Number:   403979
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2005 Fixed
Description
Enables CTLIB API checking for dataserver. This is done through Traceflag 11297.



CR:403986
CR Number:   403986
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)
04 Nov 2005 Fixed
Description
In certain rare types of operations on non-clustered indexes,

fatal error 539 may be seen when out of log space.



CR:403989
CR Number:   403989
Product Name:   Adaptive Server Enterprise
Product Component:   preupgrade
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2006 Fixed
Description
When a database has almost, but not quite, enough available space for upgrade, and the upgrade will need to create new tables in that database, the preupgrade utility may fail to detect that the database needs to be made larger.



CR:403991
CR Number:   403991
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2006 Not a Bug
Description
The compression API does not support multiple dump files per device.



CR:403996
CR Number:   403996
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2005 Fixed
12 Jan 2006 Fixed
Description
Job Scheduler Agent has problems with Japanese job command text.



CR:404078
CR Number:   404078
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2005 Duplicate
Description
Previously in 15.0 GA, DBISQL launch script "dbisql.bat" (Windows) and "dbisql" (Unix platforms) contained invalid argument "-path" that caused the script to fail. This has been fixed. (The correct argument is "-Dpath".)
Workaround Description
 Edit the call to java to remove the "-path=$path" option in the $SYBASE/DBISQL/bin/dbisql script.

before

"$JAVAHOME/bin/java" -Disql.helpFolder="$DBISQL_DIR/help" -Djava.security.policy="$DBISQL_DIR/lib/java.policy" -path="$path" -classpath "$DBISQL_

DIR/lib/:$isql_jar:$jlogon_jar:$jodbc_jar:$xml4j_jar:$jconn_jar:$dsparser_jar:$helpmanager_jar:$jcomponents_jar:$jh_jar:$jsyblib_jar:$planviewer_

jar:$sceditor_jar:$uafclient_jar:$jinicore_jar:$jiniext_jar:$jmxremote_jar:$jmxri_jar:$commonslogging_jar:$log4j_jar" sybase.isql.ISQLLoader -ase

$@



after

"$JAVAHOME/bin/java" -Disql.helpFolder="$DBISQL_DIR/help" -Djava.security.policy="$DBISQL_DIR/lib/java.policy" -classpath "$DBISQL_DIR/lib/:$isq

l_jar:$jlogon_jar:$jodbc_jar:$xml4j_jar:$jconn_jar:$dsparser_jar:$helpmanager_jar:$jcomponents_jar:$jh_jar:$jsyblib_jar:$planviewer_jar:$sceditor

_jar:$uafclient_jar:$jinicore_jar:$jiniext_jar:$jmxremote_jar:$jmxri_jar:$commonslogging_jar:$log4j_jar" sybase.isql.ISQLLoader -ase $@



CR:404090
CR Number:   404090
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 18 Sep 2005 Fixed
Description
The use of HAaseAgent for ASE 15.0 may lead to the failure of thorough probe for HAase resource

on Veritas Cluster Server.



CR:404123
CR Number:   404123
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2005 Fixed
Description
CIS: When a table is marked for replication with sp_setreptable, updating the table

with text or image data using UPDATE or INSERT-SELECT command from a proxy XFS table

results in 605 or 806 error.
Workaround Description
 Insert contents from XFS table to local table A.

Create local table B. Turn replication on for local table B.

Insert from local table A to local table B.



CR:404195
CR Number:   404195
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
ASE 15.0 uninstall leaves files and registry key entries behind.



CR:404291
CR Number:   404291
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)
02 Oct 2005 Fixed
05 Jan 2006 Fixed
Description
QPMETRICS: Implementing a new 'filter' command for sp_metrics.

The syntax will be: sp_metrics 'filter', '@gid', '@predicate'

e.g. sp_metrics 'filter', '1', 'lio_max < 100'

which will delete all qpmetrics records in group 1 where

lio_max < 100.



CR:404306
CR Number:   404306
Product Name:   SySAM
Product Component:   SyLAPI/C
Status:   Closed
OS:   NA
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2006 Fixed
Description
The SySAM License Server has been updated to use version 10.8.0.7 of the Macrovision FLEXnet Licensing components. Additionally, the sysam script has been converted to Bourne Shell (previously Korn Shell) and modified to return an exit status.



CR:404355
CR Number:   404355
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Oct 2005 Fixed
07 Oct 2005 Presently Not Targeted For Any Future Release Of This Product
10 Oct 2005 Presently Not Targeted For Any Future Release Of This Product
Description
The system stored procedure SP_HELPCACHE may report an inacurrate name

value for a given user-defined cache, if it was created with a long name

initially.



CR:404391
CR Number:   404391
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)
05 Oct 2005 Fixed
07 Oct 2005 Fixed
Description
If a license acquired by ASE is not a permenent license or a license

cannot be acquired and is awarded on grace, a new error

message with severity 17, non fatal but requiring action, is printed to the

dataserver's errorlog. This error message is to inform DBA that license

will expire at a stated date.



CR:404470
CR Number:   404470
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 Sep 2005 Bundled Request
23 Sep 2005 Bundled Request
Description
UPDATE PARTITION STATISTICS raises error 9810 with a stacktrace containing the function call sl_update_ctrlpg_pagecnt
Workaround Description
 Unpartition the table before dumping the database.



CR:404472
CR Number:   404472
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2005 Fixed
21 Sep 2005 Fixed
Description
Added support for allowing plan generation for multiple queries separated by GO statement.



CR:404487
CR Number:   404487
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)
13 Jan 2006 Fixed
Description
Monitor counters reporting Run-Time adjustment of parallel queries are functional

Monitor counters are:



total number of parallel queries

number of run-time-adjusted queries due to thread limit ('max parallel degree' or

session 'parallel_degree' setting.)

number of run-time-adjusted queries due to a lack of available processes.



CR:404489
CR Number:   404489
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2005 Fixed
Description
When doing text upgrade for compiled objects in ASE 15.0, the upgrade might fail with error 705.



CR:404493
CR Number:   404493
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 Dec 2005 Fixed
Description
A 953 error may be unexpectedly raised while running the 'LOAD DATABASE' command for the master database, if ever one of the database living on the master device has been extended onto another disk device.



CR:404643
CR Number:   404643
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2005 Fixed
03 Jan 2006 Fixed
Description
CIS: When an error occurs while inserting data into proxy tables within a local

transaction, it results in partial commits on remote pre-DTM servers.



CR:404649
CR Number:   404649
Product Name:   Adaptive Server Enterprise
Product Component:   Graphical Plan Viewer
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2005 Fixed
Description
Fixes missing information about plan version, statement number and line number for a stored procedure.



CR:404650
CR Number:   404650
Product Name:   Adaptive Server Enterprise
Product Component:   Graphical Plan Viewer
Status:   Open
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
For scan operators in some sqls the detailed report (xhtml tab) was not shown. This cr fixes that problem.



CR:404651
CR Number:   404651
Product Name:   Adaptive Server Enterprise
Product Component:   Graphical Plan Viewer
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2005 Fixed
07 Dec 2005 Fixed
Description
Out of many Per Key attribute for an index scan operator, only the first one was shown. This fix now shows all the perKeys for an indexScan



CR:404654
CR Number:   404654
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2005 Fixed
Description
A signal 11 could occur in queries with non-correlated subqueries that are

executed with subquery cache statistics enabled. The stack trace will

include printSqCacheStats.



CR:404666
CR Number:   404666
Product Name:   Adaptive Server Enterprise
Product Component:   Graphical Plan Viewer
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2005 Fixed
Description
Advanced tab is not shown for the versions of servers where it is inapplicable



CR:404728
CR Number:   404728
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2005 Fixed
Description
When resource manager and parallelism are enabled, we run into error 3630 and 11002, which aborts a query saying that it had exceeded its resource limit. This happens with queries which contain UNION/UNION ALL operators, because the query optimizer was incorrectly estimating the cost of those queries to be cheaper than they ought to be.





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