远程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:543377
CR Number:   543377
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2008 Fixed
24 Oct 2008 Reservation Made
27 Oct 2008 Fixed
Description
Add a new dynamic configuration parameter 'enable compatibility mode' to enable/disable

compatibility mode. The default value is 0 (disabled).



CR:543499
CR Number:   543499
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2008 Fixed
20 Oct 2008 Fixed
Description
Under certain circumstances, a create index with sorted data on a table may result into a 623 error



CR:543528
CR Number:   543528
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to update the documentation with an explanation for error 14127. Before dropping or

modifying a partition, Adaptive Server Enterprise verifies that the user process has exclusive

access to the partition descriptor. If it does not the command fails and a 14127 error is raised.



CR:543594
CR Number:   543594
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2008 Fixed
Description
The wrongpage error may be reported in the error log followed by a stack trace in module

text_tabcheck when running dbcc checktable after altering table change lock, which also follows

runtime undoing a dml transaction on the same table in a remote node.



CR:543622
CR Number:   543622
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2008 Fixed
24 Oct 2008 Fixed
Description
The default "max memory" is insufficient. Enlarge the default value of "max memory".



CR:543627
CR Number:   543627
Product Name:   Adaptive Server Generic Docs
Product Component:   Other
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2009 Added to user documentation
Description
The use of Open Single Quote and Close Single Quote in documentation results in the inablilty to cut and paste commands from the manual without carefully editing each command to ensure syntactical correctness.
Workaround Description
 All sample statements must be checked before being executed to ensure that the correct quotation marks are used in the pasted version of the command.



CR:543629
CR Number:   543629
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Sep 2008 Presently Not Targeted For Any Future Release Of This Product
Description
In rare circumstances, task executing "drop index" may deadlock on

system tables, with other tasks executing DDLs and utility command on the same database.



CR:543639
CR Number:   543639
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2008 Fixed
Description
Using "bcp in" to a table whose specified name (database + owner + table name) exceeds 255 bytes will fail with no error message from ASE.



CR:543642
CR Number:   543642
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2008 Fixed
Description
Msg 325 (no plan found) in ASE 15 may happen on join involving a DISTINCT view

and one of the DISTINCT view SELECT column has an equisarg on it.
Workaround Description
 set opportunistic_distinct_view 0

It disables opportunistics DISTINCT handling in optimizer and reverts back to

the similar DISTINCT handling in pre-galaxy optimizer.



CR:543650
CR Number:   543650
Product Name:   System Admin Guide
Product Component:   System Administration Guide
Status:   Open
OS:   NA
Original Version:   6.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
From the System Administrator Guide, Page 116 on IOR object

references:



The name server uses the selected load distribution policy and generates

an IOR with multiple profiles to balance the request between available servers and ports. If a dynamic load policy is selected, the NLL is used to determine

and balance the load of the individual servers.







There is no longer a way to select the 'load policy' for a cluster.



CR:543705
CR Number:   543705
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2009 Fixed
Description
On Windows, if an ASE task has been using java and subsequently encounters a stack overflow, the stack overflow is not correctly cleaned up and renders the java system non-operational.



CR:543800
CR Number:   543800
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2008 Fixed
Description
A search with a equality clause comparing an INT column with a literal numeric that exceeds MAXINT incorrectly returns rows.



CR:543801
CR Number:   543801
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to, in order to reduce the number of indexes, allow new unique constraints to be implemented using any existing index that has that column as the leading column of the index.



CR:543817
CR Number:   543817
Product Name:   Adaptive Server Enterprise
Product Component:   MonitorServer
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2008 Fixed
05 Jan 2009 Fixed
03 Feb 2009 Fixed
Description
Monserver reports events lost in monserver errorlog after upgrading to 15.0.2 ESD#2.
Workaround Description
 boot monserver binary from ESD1



CR:543861
CR Number:   543861
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2008 Fixed
Description
In a multi-node cluster, in rare circumstances, lock promotion settings for a row-locked table

could be incorrect.



CR:543871
CR Number:   543871
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2009 Fixed
Description
Set resource_granularity give error messages Invalid pointer param number 1

if you try a higher value than what is set with sp_configure "max resource granularity".
Workaround Description
 Use the Serverwide.

sp_conifgure "max resource granularity"



CR:543877
CR Number:   543877
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2010 Fixed
12 May 2010 Not a Bug
Description
When you install ASE 15.0.2 ESD5 and select "Update" as Install Type to update all installed ASE components,

the installer should determine the installed components and update them to the latest available versions.

But the installer may additionally install the following connectivity components even if those are not installed components.

o Embedded SQL/C

o Monitor Client Library

o XA Interface Library for ASE Distributed Transaction Manager

o Connectivity Language Modules for chinese, japanese, spanish, french, korean, polish, thai, german and portuguese.
Workaround Description
 Use "Custom" install type.



CR:543904
CR Number:   543904
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2009 Fixed
13 Jan 2009 Duplicate
pyxis 18 Mar 2009 Fixed
15 Jan 2009 Fixed
19 Jan 2009 Fixed
pyxis 17 Mar 2009 Fixed
Description
Database recovery statistics are available only if recovery of that database is in progress. With this fix, most recent database recovery statistics will be available through monDBRecovery, monDBRecoveryLRTypes and monFailoverRecovery MDA tables.



CR:543930
CR Number:   543930
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2008 Fixed
05 Nov 2008 One-off Provided
Description
ASE failed to disable mirror device if error occurred while opening the mirror device.



CR:543973
CR Number:   543973
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2008 Fixed
Description
When statement cache is turned on, a query that meets the following conditions:



1> union

2) subquery on one side of the union,

3) derived table expression under subquery,

4) there are local variables in derived table expression,

5) there are builtin functions in derived table expression,



may cause stack trace to happen in LeEvRun().
Workaround Description
 1) Use IF467 when turning statement_cache ON.

Or

2) Turning statement_cache OFF



CR:544007
CR Number:   544007
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2009 Fixed
13 Apr 2009 Reservation Made
13 Apr 2009 Fixed
Description
In rare circumstances, DBCC CHECKVERIFY command could result in error 12921 due to the task hitting deadlock. Message 1205 would be also be reported for the task in the errorlog.



CR:544112
CR Number:   544112
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2008 Fixed
Description
Queries that use a partition table (call it PT) and contain

a SARG against PT on a non-partitioning column may return too

few rows. The query must also contain a SARG against PT's

partitioning columns such that some partitions can be eliminated

during optimization. Take the following query as an example:

select * from S inner join PT on S.c1 = PT.npc and PT.pc >= 1

The predicate "PT.pc >= 1" can be used to eliminate some

partitions during code generation (pc is PT's partitioning column).

The equijoin "S.c1 = PT.npc" is a SARG against one of PT's

non-partitioning columns. In this case, once S.c1 has a value of

NULL, no more rows will be returned from this equijoin even after

S.c1 is refreshed to non-NULL value.

Note that this problem could also occur across stored procedure

or cached statement invocations.



CR:544182
CR Number:   544182
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2008 Fixed
10 Mar 2009 Fixed
Description
Stored procedure creating tables with materialized computed columns and inserting data into those tables may return unexpected errors like error 515 "Attempt to update or insert row failed because resultant row of size larger than the maximum size allowed for this table." This problem may happen only if the procedure requires renormalization because some objects referenced by it were dropped and recreated.



CR:544183
CR Number:   544183
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2008 Fixed
Description
Stored procedure may fail with errorlog reporting modules:pre__substitute_fi_cpc,pre__replace_cpc,

s_getTreeOrPlan,open_user_table,open__byname,parse_name.

This may happen if procedure creates a table with computed column.



CR:544228
CR Number:   544228
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2008 Fixed
21 Oct 2008 One-off Provided
29 Jan 2009 Bundled Request
Description
jConnect and Data Drivers are unable to login to ASE 15.0.2 with encrypted logins if the ASE password has expired.



CR:544256
CR Number:   544256
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2008 Fixed
13 Oct 2008 Fixed
04 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
On some platforms a stack trace in n3__make_jsig() may result when a sqlj procedure is created with more than the allowable number of parameters and there is a matching java function intsalled on the server.



CR:544258
CR Number:   544258
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2009 Fixed
Description
Attempts to use a database from a node N2 while it was created

with the 'for load' clause on a node N1 does not return the

expected 930 error message.



CR:544289
CR Number:   544289
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
auto update statistics.



CR:544360
CR Number:   544360
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2008 Fixed
20 Mar 2009 One-off Provided
Description
A large statement that is over 16k and contains a lot of white spaces may not be cached

in the statement cache.
Workaround Description
 trim whitespace from query by hand



CR:544373
CR Number:   544373
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2008 Not reproducible with latest version of the product available as of Resolution Date
Description



CR:544376
CR Number:   544376
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request sp_shmdumpconfig to dump to multiple devices for each thread



CR:544485
CR Number:   544485
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 Fixed
Description
Subqueries that join with a column from a "distinct"

view or derived table will not mark the joining predicate

as a sargable. This could result in a cartesian product scan

rather than an index lookup.
Workaround Description
 The problem is a side-effect of the opportunistic distinct view feature.

Use "set opportunistic_distinct_view off".



CR:544498
CR Number:   544498
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2009 Fixed
18 Jun 2009 Fixed
Description
diagserver could run into an assertion fail when 'enable stmt cache monitoring' is active.
Workaround Description
 disable 'enable stmt cache monitoring'.



CR:544589
CR Number:   544589
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2008 Bundled Request
Description
If CIS and java features are enabled in ASE 15.0.3, JVM and all CIS connections are affinitied to

the same engine. This results in OMNI connections not distributed across the engines that can

potentially cause performance degradation.



CR:544633
CR Number:   544633
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Optimizer doesnt consider certain query plans for large queries, which could result in suboptimal query plans.
Workaround Description
 Recreating the view hiddenStrategies to use group by clause instead of distinct clause should address this issue:



create view hiddenStrategies

as

select a.strategyName

from pnlBoxGroups a, pnlBoxGroupAttributes b

where a.groupName = b.groupName

and b.flags & 256 != 0

and a.strategyName != null

group by a.strategyName

go



CR:544667
CR Number:   544667
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2009 Fixed
Description
If the dataserver is configured with 1 SSL listener and the server ssl certificate is bad

the dataserver will continue to start with no valid listeners.
Workaround Description
 Kill the dataserver via the task manager. Start the dataserver without ssl enabled.

Use sp_ssladmin 'dropcert' to drop the certificate. Add a good certificate with

sp_ssladmin 'addcert'. Enable SSL and reboot.



CR:544679
CR Number:   544679
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2008 Fixed
30 Sep 2008 Fixed
Description
Executing UPDATE queries involving NULL LOBs may hit error 691, "Encountered invalid logical page 0 ..." with a stack trace in the modules 'updtext()' and 'wrongpage()'.



CR:544704
CR Number:   544704
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2008 Fixed
10 Nov 2008 Fixed
Description
The query below may return 0 row if FKcol1 and FKcol2 columns on table B are character variable-width, nullable datatypes

and col1 and col2 columns on table A are character fixed-width, non-nullable datatypes.



select B.FKcol1 + ',' + B.FKcol2 from A, B

where B.FKcol1 + ',' + B.FKcol2 = 'TEST5,T'

and A.col1 = B.FKcol1 and A.col2 = B.FKcol2
Workaround Description
 Use a character variable-width, nullable datatype for required join columns.

Or convert fixed-width columns to varchar datatype or use rtrim() to trim trailing blanks.



CR:544748
CR Number:   544748
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2009 Fixed
Description
The message "closetable: table already closed for sdes <value>" may be reported in the error log together with a stack trace which includes the modules 'pg_allocate' and 'pg_allocoam' after an 1105 error is reported during page allocation.



CR:544818
CR Number:   544818
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2009 Fixed
Description
Wrong result (missing rows with NULL values) could happen for sybase extended

column groupby query (i.e. SELECT more columns than the Group By list and aggregate)

when one of the joining view/derived table has DISTINCT.
Workaround Description
 traceflag 15387 to turn off MATCHNULL tcid join.



CR:544845
CR Number:   544845
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2008 Fixed
14 Oct 2008 Reservation Made
Description
When statement cache and literal autoparam are enabled, a query with intensive numeric computation may cause error 3624 "Truncation error occurred" to be raised.
Workaround Description
 Workaround 1:



set literal_autoparam off

go

update ....

go



Workaround 2:



set arithabort numeric_truncation off

go

update ...

go



CR:544873
CR Number:   544873
Product Name:   Adaptive Server Generic Docs
Product Component:   To Be Determined
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Job Scheduler users guide needs to document all available proerties for jobs



CR:544889
CR Number:   544889
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2009 Fixed
19 Mar 2009 Fixed
Description
If CIS and java features are enabled in ASE 15.0.3, JVM and all CIS connections are affinitied to

the same engine. This results in OMNI connections not distributed across the engines that can

potentially cause performance degradation.
Workaround Description
 If Java in Database feature is not used together with CIS feature,

-T 9403 traceflag can improve the performance by distributing CIS connections

across all the ASE engines. If you are not sure if CIS and Java feature

are not used together, DO NOT ENABLE -T 9403 as this can lead to a stacktrace.



CR:544904
CR Number:   544904
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2008 Fixed
25 Oct 2008 Fixed
Description
In rare circumstances, sysmon report may show negative values under task management section.



CR:544936
CR Number:   544936
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2008 Added to user documentation
Description
Enhance the SA Guide discussion of the statement cache feature to indicate that substitution of a cached statement causes @@nestlevel to increment.



CR:544992
CR Number:   544992
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2008 Insufficient priority to fix
17 Nov 2008 Fixed
Description
DBCC CHECKSTORAGE reports "Msg 15914, 'Failed to bind dbcc named cache <cache name> to the scan workspace <workspace name>.'" if dbcc named cache name contains a space character.
Workaround Description
 Use data cache with a name that does not include spaces.



CR:545009
CR Number:   545009
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2008 Fixed
Description
In rare circumstances for clusters with two or more instances, it may be possible

that bind/unbind cache operation may fail with out error message.



CR:545058
CR Number:   545058
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2008 Fixed
26 Sep 2008 Fixed
26 Sep 2008 Fixed
Description
ASE running on Sun Solaris machines which do not have ISM configured within the kernel will cause additional engines to SEGV during their online operation.
Workaround Description
 Enabling ISM (Intimate Shared Memory) support on the machine and making sure that there are enough available resources for ISM to be allocated will avoid prevent this problem.



CR:545059
CR Number:   545059
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2008 Fixed
17 Oct 2008 Reservation Made
Description
When merge join is disabled, do not include the equi-join columns in the interesting orderings. The optimizer places eagerly Sort operators on the interesting orderings and keeps or discards them based on cost. Although a Sort could also enhance the buffer cache behavior of nested loops join, this comes with some risk due to the substantial cost of sorting and to its blocking nature, specifically when the data volume estimation is wrong (as when costing is based on out of date histograms, magic numbers, etc.). The fix is disabled by trace flag 15338.
Workaround Description
 Use an AP to force 125x behavior whilst engineering investigates the root cause.



CR:545119
CR Number:   545119
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2008 Fixed
04 Nov 2008 Fixed
Description
This fixes an issue where server is reporting an error (named cache is configured too small for current demands state 3. Transaction progress may cease) too early.



CR:545130
CR Number:   545130
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2008 Fixed
Description
If both expr1 and expr2 are float numbers in 'select isnull(expr1, expr2)'and if precision of expr1 is less than precision of expr2, it returns error msg 247.



CR:545137
CR Number:   545137
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2008 Fixed
Description
The message "current process infected with 11" in the module

'ssql_update_recompile_info' together with a stack trace which

includes the modules 's_getTreeOrPlan' and 'tdsrecv__dynexec'

may be reported in the error log and could bring the server

down if the configuration options "STATEMENT CACHE SIZE",

"ENABLE MONITORING" and "ENABLE STMT CACHE MONITORING" are

all enabled and a client application executed a dynamic sql

statement with the option "DYNAMIC PREPARE" active and the

internal lightweight procedure for the statement had to

be recompiled (for example due to a schema change).
Workaround Description
 Disable "enable stmt cache monitoring" configuration option.



CR:545160
CR Number:   545160
Product Name:   sybcluster
Product Component:   Client
Status:   Closed
OS:   all
Original Version:   15.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2008 Fixed
Description
For cluster having two instances on the same node, when the two dataservers

are killed externally,the command "start cluster" fails to start the cluster.
Workaround Description
 (show cluster status you will see status is Up and heartbeat is No)

from sybcluster, start cluster fails, but it shows the dataserver commands that it

issues) once it fails, go to OS prompt and issue the dataserver command as shown by

"start cluster" once that starts, it will correct the status, and you can use sybcluster

again.



CR:545162
CR Number:   545162
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2008 Fixed
18 Feb 2009 Fixed
16 Nov 2010 Presently Not Targeted For Any Future Release Of This Product
Description
A large T-SQL unsigned bigint value is incorrectly assigned to a BigInteger Java datatype. For

example assiging the value 18446744073709551615 to a BigInteger field in Java will result in a

value of -1 being stored in the Java field.



CR:545165
CR Number:   545165
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2010 Workaround
Description
This a feature request to handle situations where we have a lack of statistics due to table data being transient.

Clearly there is no current way of maintaining statistics on tables which are only populated potentially during a transaction's lifetime. There needs to be some sort of statistical learning mode to handle this.



CR:545168
CR Number:   545168
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   macosx
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2008 Fixed
20 Oct 2008 Fixed
21 Oct 2008 Fixed
30 Oct 2008 Fixed
Description
check in Mac OS install related files



CR:545176
CR Number:   545176
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2009 Presently Not Targeted For Any Future Release Of This Product
01 Mar 2010 Insufficient info provided
16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
Description
15307 and 15308 traceflags disable the forceplan and hints respectively at a server level. Ther is no way to turn these off at server level and yet enable it at a session level. allow_forceplans and allow_forcehints options provide this ability. Doing 'set allow_forceplans on' would negate the traceflag 15307 in that session. Similarly, 'set allow_forcehints on' would negate the traceflag 15308 in that session.



CR:545180
CR Number:   545180
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2008 Fixed
14 Oct 2008 Reservation Made
Description
Under missing/limited statistics, optimizer might favor a store index (reformatting) plan

for a nested loop join even though there is no sarg on the store index child scan and

there already exists an index whose keys match the equijoin columns. For most time, based

on actual data distributtion, the existing index scan plan would be better.
Workaround Description
 set store_index 0 --this is in-place now and is acceptable



CR:545181
CR Number:   545181
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2008 Fixed
10 Feb 2009 Fixed
Description
A 1129 error may be reported "The requested update to the OAM for object <value>,

dbid <value>, index <value>, oam page <value>, would cause a negative page count ...

Contact your System Admin." in the error log mistakenly when multiple sessions import

data in the same table concurrently through the bulk copy utility.
Workaround Description
 Make use of trace flag 1133 if possible. When we enter pg__updateoam() if this

trace flag is active we will get an EX_LATCH on the first oam page to update

the total used/unused pages.



CR:545192
CR Number:   545192
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2008 Duplicate
Description
Complex queries using nested subqueries and or clauses may cause the optimiser not to choose reformatting strategy when it should.



CR:545202
CR Number:   545202
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2008 Fixed
Description
If DDL replication is on and we are execute a CREATE SCHEMA which has create views and this CREATE SCHEMA is not in a store procedure could cause 701 errors.



CR:545264
CR Number:   545264
Product Name:   ASE Replicator
Product Component:   Distributor
Status:   Closed
OS:   Generic
Original Version:   15.0.3.420P3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.3.420P3 01 Oct 2008 Fixed
Description
ASE REPLICATOR: changing the max_threads

configuration parameter has no effect.

It always initializes to the default value

of 45.



CR:545270
CR Number:   545270
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2010 EOL'd version. Not to be Fixed.
Description
ASE Optimizer may choose the wong join order if WHERE clause has both "<> (not equal to)" and "is not null" on the same column.
Workaround Description
 set forceplan on



CR:545296
CR Number:   545296
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2008 Fixed
01 Oct 2008 Fixed
Description
QPMetrics are not captured for statements inside a store procedure which is created and compiled before QPMetrics is enabled



CR:545331
CR Number:   545331
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2009 Fixed
Description
ASE Rep Agent support for the Replication Server Normalization Thread feature.
Workaround Description
 N/A.



CR:545379
CR Number:   545379
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2008 Fixed
17 Oct 2008 Reservation Made
Description
In 12.5.x, the optimizer was not attempting to place reformatting over a table which had an index forced in the FROM clause. The 15.x optimizer did not have this limitation and was always placing and costing StoreIndex (the 15.x operator which implements reformatting) unless a full Abstract Plan was precluding it. When costing is not accurate, for instance due to data skew or to magic numbers based costing when there are no statistics, this could lead to suboptimal plans which were not generated in 12.5.x, hence to performance regressions. This fix re-instate in 15.x the legacy 12.5.x behavior.



CR:545400
CR Number:   545400
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2010 Duplicate
Description
An ASE configured with PCI based JVM on a Solaris platform may fail to boot

when configured with Java in Database feature if JVM requests an extremely large

amount of memory due to Solaris bug 6671882.
Workaround Description
 A workaround fix has been included in ASE 15.0.3 that can handle

the incorrect memory request due to miscalculation if the

memory size is with in the limits that can be satisfied by the

heap memory size on the system.



With the workaround fix in ASE, a warning message is printed

in the errorlog similar to the following when Solaris bug 6671882 is encountered.



kernel PCI(T1): WARNING: pci_malloc; forwarded size 954437177 exceeding max request size 2097072 to the run-time for thread 13



CR:545413
CR Number:   545413
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2008 Fixed
20 Nov 2008 Fixed
13 Oct 2008 Fixed
27 Nov 2008 Fixed
Description
DUMP DATABASE/TRAN with compression may fail with an error, "Length of compressed buffer is greater than the original buffer length".



CR:545416
CR Number:   545416
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2009 Fixed
Description
Occasionally, when ASE write the logfile to dumpfile,"Error: I/O error, errno: 5 "may be reported in the errlog.



CR:545418
CR Number:   545418
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2008 Fixed
18 Feb 2009 Fixed
Description
Loading a Java class with a very large value for a static final defined string can result in a

message "infected with 11" with the modules "jvm_GetClassName" and "DBClassFileGetClassName", being

printed in the ASE errorlog.
Workaround Description
 n/a



CR:545428
CR Number:   545428
Product Name:   SySAM
Product Component:   FLEXlm
Status:   Open
OS:   all
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SySAM2: Display license usage per platform when using license file with multiple products on different platforms.



CR:545430
CR Number:   545430
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If a stored procedure contains a begin/commit transaction pair around a create #table statement, and that stored procedure is called from within an existing transaction, then error 277 may occur when executing that procedure.
Workaround Description
 Avoid including transactions inside trigger/stored procedure code that create temporry tables if that trigger is also called as bazrt of a larger transaction.



CR:545432
CR Number:   545432
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Fixed
11 Feb 2009 Fixed
Description
Support concurrent i/o for VxFS file systems on Solaris and Linux.



CR:545444
CR Number:   545444
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 One-off Provided
05 Nov 2008 Fixed
06 Nov 2008 Fixed
Description
Under rare circumstances an ASE system running on a 64 bits Windows Server with a high rate of DML commands executed may result in some data not be written to disk.
Workaround Description
 [frankl Nov 25 2008]



This is related to an incorrect overflow of the dbt_nextseq on win64 when it

reaches UINTMAX. Because of this checkpoint will not flush (some of the) dirty

buffers to disk.



This is not really a workaround, but a way to flush dirty buffers to disk.



For version >= 1502 esd#6, you can use

dbcc cachedataremove(dbid|dbname, objid|objname, partitionid/partitionname, indid|indexname)



otherwise configure



sp_configure "housekeeper free write percent", 100



In my test case, this flushed the dirty buffers to disk.



CR:545469
CR Number:   545469
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2008 Fixed
Description
Under heavy load both DBCC CHECKSTORAGE and DBCC CHECKVERIFY can incorrectly

detect spurious errors because it could skip a dirty cached page and

use the page on disk instead, if the owner instance has got a request to downgrade

the physical lock to a null lock.



CR:545489
CR Number:   545489
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows W2k
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2009 Bundled Request
Description
DBISQL 9.0.2 cannot import data into a datetime column because of the message "Can't find type 'TIMESTAMP'". This has been fixed in DBISQL 11.0.0. Also, before DBISQL 11.0.0.1571, importing a char/varchar column would result a syntax error. This has been fixed.



CR:545521
CR Number:   545521
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2009 Presently Not Targeted For Any Future Release Of This Product
23 Jan 2009 Fixed
Description
For a query that is executed using the clustered index but involves no partitioned table and

parallel scan, the value of the UsedCount column of monOpenObjectActivity for IndexID = 1

is not incremented.



CR:545553
CR Number:   545553
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)
01 Oct 2008 Workaround
Description
Withdrawn feature request for a way to configure the default settings for ARITHABORT at the server level. This can be done with existing functionality by creating a global login trigger that does SET EXPORT_OPTIONS ON SET ARITHABORT NUMERIC_TRUNCATION ON
Workaround Description
 Note that while not quite as convenient as a single serverwide setting, it is possible to set up a default

value using login triggers - you just have to associate the login trigger with each login.





use master

go

create procedure login_trigger as

set export_options on

set arithabort numeric truncation off

go

grant execute on login_trigger to public

go



sp_modifylogin joeuser, "login script", login_trigger

go



CR:545558
CR Number:   545558
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Documentation Bug: The writeup of error 603 indicates a limit of 14 worktables. This limit was raised to 46 in ASE 15.0



CR:545581
CR Number:   545581
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2008 Fixed
Description
Wrong results could be returned when a query using a GROUP BY

clause is executed, the datatype of the grouping columns

is VARCHAR and the data for those columns contains NULL values

and empty strings having only white spaces like ' '
Workaround Description
 Disable group_hashing for example via "set group_hashing off"



CR:545585
CR Number:   545585
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2008 Fixed
06 Dec 2009 One-off Provided
Description
Unnecessary sort nodes were added to the query plan, which provided no benefits.



Normally sort nodes would provide benefits such

as orderings for merge join/ORDER BY/GROUP BY,

or buffer manager optimization (i.e. better cache hits on an ordered join attribute).



This error could occur when there is a combination of multiple covered and non-covered

index scans within a query plan. Normally, it occurs in cases when the sorts are

very small, so the error is not noticible, since it only involves the estimate

of the CPU component. If the sort volume was large, then it would have overwhelmed

the incorrect CPU estimate, and the sort would have been eliminated.

However, if the input volume estimate for the

sort is incorrect, due to missing statistics, and this volume is actually very large,

then the addition of the sort operator could result in a noticible performance regression.



CR:545604
CR Number:   545604
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.3 22 Oct 2008 Fixed
Description
Avoid frequent flushing log of index shrink for tables in the tempdb.



CR:545606
CR Number:   545606
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2008 Fixed
Description
This fix keeps the connection level default AP dump/mode active when changing

the database. This also makes AP capture more versatile.



It is documented that the connection level AP dump/load is disabled

when a USE <database> statement is issued, to avoid the tentative usage

of an absent user defined AP group.



However, when the standard in/out default AP groups are used, there is

no reason to disable the connection level dump/load - since these groups

are present in all database.



CR:545633
CR Number:   545633
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2009 Fixed
Description
Sybase Central can not connect to ASE if "net password encryption reqd=2" was set on ASE.



CR:545653
CR Number:   545653
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2008 Fixed
Description
The tendency to add expensive sort nodes, solely to break up a nested loop join order has been reduced. This occurs when there are numerous tables in the FROM list, and the optimizer

added a sort to break up the join order, so that there is more buffer manager cache available

for each side of the sort, that in turn would reduce PIO requirements of the query overall.



CR:545662
CR Number:   545662
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2008 Fixed
08 Dec 2008 Fixed
16 Feb 2009 Fixed
30 Mar 2009 One-off Provided
Description
Under rare conditions a query on the monOpenObjectActivity MDA table may result in a signal 11 and server crash.



CR:545665
CR Number:   545665
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2008 Fixed
Description
If a server was configured for an ipv6 address 'connect to' would fail.

A new syntax is being used to add an ipv6 address in sp_addserver. The syntax

will encapsulate the ipv6 address with in brackets '[,]'. An example of

an sp_addserver command for an ipv6 address:

sp_addserver

'rmtsrv1',ASEnterprise,'[fd77:55d:59d9:167:203:baff:fecd:2b0d]:6268'



CR:545716
CR Number:   545716
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 Feb 2013 Added to user documentation
02 May 2013 Fixed
04 Jul 2013 Fixed
02 May 2013 Added to user documentation
15.7 SP110 17 May 2013 Fixed
07 Jul 2013 Fixed
15.7 SP60 16 Jul 2013 Fixed
Description
Long Running Transaction against an SAP ASE server can prevent the log being truncated, causing risk of data unavailability for DMLs. Improve how this can be managed.



CR:545718
CR Number:   545718
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2008 Duplicate
Description
Feature request for a method to suppress message "cache is configured too small"



CR:545738
CR Number:   545738
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2010 Insufficient priority to fix
Description
Outer join query within a stored proc takes 20x longer to run vs ad-hoc query



CR:545741
CR Number:   545741
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2008 Duplicate
13 Nov 2012 Fixed
Description
Fixed by 547741 which was checked into 15.0.3 IR.



CR:545754
CR Number:   545754
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2008 Fixed
28 Nov 2008 Fixed
Description
Application Tracing does not trace actual and estimated I/O statistics when "allow resource limits" configuration parameter is enabled.



CR:545758
CR Number:   545758
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2008 Fixed
Description
Added the display back of "-s" option in the user message when users enable "-s" (sorted) option.



CR:545771
CR Number:   545771
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2008 Fixed
11 Dec 2008 Reservation Made
16 Jan 2009 Fixed
Description
For DISTINCT query with multiple table join, a lower costing plan

with a top DISTINCT operator might be ignored by optimizer.
Workaround Description
 set opportunistic_distinct_view off



CR:545773
CR Number:   545773
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 Fixed
Description
Under some circumstances, SybMigrate may not use the "with sorted_data" option when creating clustered indexes when it could safely do so.



CR:545793
CR Number:   545793
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2009 DEFER
24 Sep 2012 EOL'd version. Not to be Fixed.
Description
select returns number instead of "arithmetic overflow" on large number result set. Occurs in Linux 12.5.x - 15.0.2 esd #5 32bit - not 64bit.



CR:545839
CR Number:   545839
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2008 Fixed
Description
When running in a non-English environment, previously Connect Dialog would display an ID if the localized text was not available. This has been fixed so that the English text is displayed instead.



CR:545898
CR Number:   545898
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Queries involving character conversions may stacktrace when Unilib conversion is enabled.



CR:545900
CR Number:   545900
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2008 Fixed
10 Oct 2008 Fixed
Description
Replication Agent may report the error 9205, state 0, after a cross database transaction happened between two databases and the table or the database is configured to use sql statement replication.



CR:545960
CR Number:   545960
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2008 Fixed
22 Oct 2008 Fixed
Description
isnull() builtin on character data could return blank padded data while returning values substituted for nulls





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