远程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:448433
CR Number:   448433
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2006 Fixed
23 Mar 2009 Presently Not Targeted For Any Future Release Of This Product
04 Dec 2006 Reservation Made
22 Jan 2007 Fixed
03 May 2009 Presently Not Targeted For Any Future Release Of This Product
15 Jan 2009 Fixed
Description
Enhancements to dbcc tablestats command.



CR:448485
CR Number:   448485
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2007 Fixed
Description
Support Direct I/O on Solaris Opteron 64 (AMD).



CR:448507
CR Number:   448507
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2007 Fixed
Description
If an earlier release maps a proxy table to a later release and the remote table makes use of functionality not available in the earlier release, this can result in errors. This is limitation.

Ex.1) A column is defined using bigint implemented in ASE 15.0, ASE 12.5.x CIS does not recognize bigint data type and will map to varchar.

Ex.2) If you maps a proxy table to ASE 15.0.x and run update statistics command on the proxy table on ASE 12.5.x, error 207 will occur.



CR:448519
CR Number:   448519
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2007 Fixed
16 Feb 2007 Fixed
Description
AP warning message may be displayed when executing nested subquery with forceplan on.
Workaround Description
 Don't use 'set forceplan on'



CR:448533
CR Number:   448533
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2007 Not a Bug
Description
sp_configure should avoid/warn if conflict between max mem and os shmmax



CR:448556
CR Number:   448556
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)
12 Dec 2006 Fixed
11 May 2007 Added to user documentation
27 Mar 2007 Fixed
22 Aug 2007 Fixed
Description
Interactive SQL on Windows used to be launched by a batch file "dbisql.bat". This is now replaced by a Windows native launhcer.



CR:448617
CR Number:   448617
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)
30 Jan 2007 Fixed
Description
Executing sp_showplan and passing in the spid of a running bcp process can result in a stack trace which includes the module le_showE_Stmt.
Workaround Description
 The client can avoid calling sp_showplan and passing spid of bcp process by including the option 'BULK INSERT' in the query in sp__showplan:-



select spid,program_name,suid,cpu,physical_io,dbid,id

from master..sysprocesses

where cmd not in ("AWAITING COMMAND","NETWORK HANDLER","DEADLOCK TUNE",

"MIRROR HANDLER","HOUSEKEEPER","CHECKPOINT SLEEP","ASTC HANDLER",

"BULK INSERT")

and spid <> @@spid



CR:448618
CR Number:   448618
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)
13 Dec 2006 Fixed
Description
sp_helprotect <permission_name> should provide information for any specific permission granted in a given database.



CR:448650
CR Number:   448650
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Under some circumstances optdiag output shows negative values for the forwarded and/or deleted row counts for DOL tables.



CR:448661
CR Number:   448661
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2006 Fixed
18 Dec 2006 Fixed
Description
When the stored procedure sp_modifystats is issued with MODIFY_DENSITY option,

Error Msg 553: "The number of parameters/variables in the FETCH INTO clause does

not match the number of columns in cursor 'new_densities' result set." is

raised. The output for 'Column Group' may be incorrect (show NULL) if multiple

columns are involved e.g. composite index.



CR:448676
CR Number:   448676
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2007 Fixed
Description
with Cell based HP Itanium server SPDC fails generate a license if the partition number is appended or SYSAM-2_0 fails to recognize generated licenses without partition number
Workaround Description
 Ask the customer to generate the required license(s) or generate the licenses on behalf of the customer (but using customer's account/entitlement - please note only limited CS&S folks have this capabilit) by specifying the HostID without the partition part. E.g.



use 76758260-e689-11da-ad92-532f0cec20cf

not 76758260-e689-11da-ad92-532f0cec20cf_P0



Once generated, change the HOSTID in the license to the correct value, TAR up all the licenses and send them to help_sysam@sybase.com (NOTE this is an internal email alias and should not be disclosed to customers)



Someone on that alias will then re-generate the licenses and return them.



CR:448725
CR Number:   448725
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)
01 Dec 2006 Fixed
05 Dec 2006 Fixed
Description
A timeslice error followed by the all_active_devices() and modules db_fill() may be raised when loading a very big archive database.
Workaround Description
 If the server is used only for maintenance then the 'cpu grace time' can be increased to a very high value in order to pass the critical point where the DBTABLE is instantiated.



CR:448733
CR Number:   448733
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2006 Fixed
04 Jan 2007 Fixed
Description
A stack trace may occur when opening a cursor against a prepared dynamic statement with parameters that references proxy tables.



CR:448868
CR Number:   448868
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Configuration Guide for UNIX
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jan 2007 Fixed
Description
Sort Order ID 53 should be case insensitive in Table 7-17 (Configuration Guide for UNIX) or Table 6-17 (for Windows).



CR:448872
CR Number:   448872
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2006 Fixed
11 Dec 2006 Fixed
12 Mar 2007 Fixed
Description
Process afftected with sig11 in GtqSingleSubqScan::GtInitGcPerGt(OptBlock*)

for 15.0.1 esd1 binary when there is a subquery under OR and a

LIKE predicate under OR at the same time. Here is an example:

...

where (user_name(o.uid) like @uname

or

(@nouname = 1

and not exists (select 1

from sysobjects o2

where o2.name=o.name

and user_name(o2.uid)=@uname)

and user_name(o.uid) = "dbo"

)

)



CR:448907
CR Number:   448907
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2014 Fixed
09 May 2014 One-off Provided
12 Feb 2014 Reservation Made
10 Apr 2014 Fixed
15.7 SP130 11 Apr 2014 Reservation Made
26 Jun 2014 Fixed
Description
Adds the PREPARE DATABASE command. This command is very similar to the QUIESCE DATABASE command, with the exception that it does not block write activity during the HOLD phase. The HOLD/RELEASE options can be used to execute a mirror split or snapshot on the database using a certified agent, to create a copy of a database on which transaction logs can be loaded.



CR:448911
CR Number:   448911
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2006 Fixed
Description
Queries containing a UNION ALL and an ORDER BY clause and having a column with a

datatype of TEXT, IMAGE or UNITEXT in the select list on one side of the UNION ALL and

a CONVERT builtin function to convert a literal string to a TEXT, IMAGE or UNITEXT

datatype will result in a segmentation violation with the function, sendtext in the

stack trace.



CR:448912
CR Number:   448912
Product Name:   Sybase SQL Server
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2007 Fixed
Description
Internal indexes created on replicate tables with text/image columns will use as index ID the firt free starting from 250, in decrease order.



CR:448978
CR Number:   448978
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2007 Fixed
14 Mar 2008 Not reproducible with latest version of the product available as of Resolution Date
05 Nov 2008 Fixed
Description
Under some rare conditions, the message "current process infected with 11" in the module 'qualpage' together with a stacktrace which includes the module 'getpage_with_validation' may be reported in the error log if a query is executed with materialized derived table.



CR:448987
CR Number:   448987
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2006 Fixed
26 Jan 2007 Fixed
Description
Wrong result could happen for union/unionall over outer join when

one of union/unionall projection is a column from an outer join inner

table.



CR:449011
CR Number:   449011
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2006 Fixed
30 Nov 2006 Presently Not Targeted For Any Future Release Of This Product
24 Jul 2007 Presently Not Targeted For Any Future Release Of This Product
20 Sep 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Job Scheduler templates fail to install on Solaris.



CR:449021
CR Number:   449021
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2007 Fixed
17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
Description
In a server configured to use a multi-byte character set by default, the replication of text being bulk copied could fail if the BCP client is using a single-byte character set.



CR:449048
CR Number:   449048
Product Name:   Adaptive Server Enterprise
Product Component:   Language Modules
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2010 Duplicate
Description
Customer needs Russian localization files



CR:449148
CR Number:   449148
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2006 Fixed
01 Dec 2006 Fixed
Description
The stored procedure sp_plan_dbccdb may incorrectly display archive database devices as recommended devices on which to install the 'dbccdb' database.



CR:449177
CR Number:   449177
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2006 Fixed
29 Jan 2007 Fixed
05 Jan 2007 Fixed
Description
The message: current process infected with 11 within the function, CgLavaUtils::CgSetAlign,

and a stack trace that includes the function, CgGenLava::CGConsMJOp can occur when the

optimizer chooses a query plan with a MergeJoin operation that includes literal values in

the projection list of the inner stream of rows to the MergeJoin operator.
Target Version
 One-off



CR:449203
CR Number:   449203
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2006 One-off Provided
Description
This problem only occurs in systems using a non-binary sortorder. This problem only

occurs in distinct queries with an order-by clause. Further, the target list must

contain an expression, and there must be a character type column in the target list

or order-by clause, and the number of columns in the target list plus order-by clause

must exceed 32 columns. If all of these conditions hold, then the query may return

the wrong number of rows.
Workaround Description
 set distinct_sorting 0

go



CR:449293
CR Number:   449293
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2007 Fixed
12 Apr 2007 Fixed
16 Apr 2007 Presently Not Targeted For Any Future Release Of This Product
Description
If there is a cursor fetch statement right before calling sp_helpartition and

if that fetch is from an empty table, 515 error might be raised from sp_helpartition.



CR:449301
CR Number:   449301
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2007 Fixed
12 Feb 2007 Fixed
19 Feb 2007 Fixed
Description
A 510 error, "Bad eop type 0x...", may be reported in the errorlog together with a stack trace which includes the modules 'execproc' and 'tdsrecv__dynexec' when executing a dynamic parameterized sql statement which used one of the following string manipulation functions: SUBSTRING(), LTRIM(), RTRIM(), RIGHT(), LEFT(), UPPER() or REVERSE() and the parameter's length value exceeds 255 characters.
Workaround Description
 Open client library 12.5.1 ESD12 may detect big CHAR parameter for the dynamic execute command.



Use traceflag -T244 to use MAXSTRLEN for unknown result

length and dynamic SQL '?' parameters.



CR:449327
CR Number:   449327
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2006 Fixed
Description
The following sequencer of queries will cause a segmentation violation:



1> set plan for show_execio_xml to client on

2> go

1> select showplan_in_xml(0)

2> go



The call stack will include the function, resetTraceObj.



CR:449408
CR Number:   449408
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2007 Fixed
11 Oct 2007 Fixed
11 Oct 2007 Fixed
Description
When a parallel query needs a runtime adjustment the runtime recompilation

may incorrectly identify query objects and raise spurious errors like

'Table not found' or 'Permission denied'



CR:449417
CR Number:   449417
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)
01 Jan 2007 Fixed
28 Apr 2008 Presently Not Targeted For Any Future Release Of This Product
Description
'select on syscomments.text' configuration parameter doesn't restrict access to syscomments.text.
Workaround Description
 Run the command: 'revoke select on syscomments(text) from public'



CR:449423
CR Number:   449423
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2006 Fixed
03 Jan 2007 Fixed
10 Jan 2007 Fixed
Description
In rare circumstances the error 403 will be raised and caused by the version 15.0.1 ESD#1.

Adding a convert() is a good workaround.
Workaround Description
 it looks like code generation is trying to convert the

character to a length of -1 instead of 255.



It looks like a workaround may be to an explicit conversion

to override the implicit conversion, something like.





select o.uid, o.name

from sysindexes i, sysobjects o

where o.name like "%"

and o.name = convert(char(255), object_name(o.id))

and i.id = o.id



CR:449478
CR Number:   449478
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2007 Added to user documentation
Description
ASE 15.0 System Administration Guide says that default values for abstract plan cache, abstract plan dump, abstract plan load and abstract plan replace are 1 (on).

But in fact they are 0 (off).



CR:449492
CR Number:   449492
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2006 Fixed
10 Feb 2007 Fixed
08 May 2007 Fixed
Description
It was impossible to change configuration parameter 'messaging memory' when 'enable real time messaging' equals 0 (RTDS option disabled). That CR addresses that issue, allowing the user to modify 'messaging memory' configuration parameter before enabling RTDS.



CR:449498
CR Number:   449498
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 Jun 2009 Fixed
01 Feb 2008 Fixed
23 Mar 2009 Fixed
30 Apr 2009 Fixed
05 Jun 2009 Reservation Made
Description
New feature "deferred name resolution" that allows the creation

of stored procedures postponing the name resolution phase to

the stored procedure execution time.



CR:449502
CR Number:   449502
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2007 Fixed
09 Jan 2007 Fixed
Description
An existing Job Scheduler installation fails to start after 15.0.2 upgrade.
Workaround Description
 Edit scripts/installjsdb, search for ssql_sid=20, in sql below this

change the line



SELECT isnull(max(srvid),0)+1 ,@status ,'SYB_JSTASK' ,'%s' ,7 ,NULL ,1000



to

SELECT isnull(max(srvid),0)+1 ,@status ,'SYB_JSTASK' ,'%s' ,7 ,NULL ,1000, 0



Drop sybmgmtdb or delete from js_seqsql where ssql_sid=20

then re-run installjsdb



CR:449518
CR Number:   449518
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)
12 Dec 2006 Fixed
16 Jan 2007 Fixed
05 Jan 2007 Fixed
07 Aug 2007 Bundled Request
Description
It is possible to run ONLINE DATABASE after a LOAD TRANSACTION command that failed during recovery of the database.
Workaround Description
 N/A



CR:449584
CR Number:   449584
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2006 Fixed
19 Dec 2006 One-off Provided
04 Dec 2006 Fixed
05 Dec 2006 Fixed
31 Jan 2007 Fixed
01 Feb 2007 Fixed
Description
ASE will use kernel asynchronous i/o on Linux. Traceflags 1630, 1639, and 1649 are now obsolete. Synchronous i/o will be used on file system devices that do not support kaio, such as tmpfs.



CR:449709
CR Number:   449709
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2006 Fixed
14 Dec 2006 Reservation Made
20 Dec 2006 Fixed
06 Feb 2007 One-off Provided
26 Jan 2007 Fixed
Description
A query has a SQL derived table and the derived table has a column from a subquery.

If the query joins between the column on the derived table and a column on another

table using LEFT OUTER JOIN clause, the query will get error 325 (Adaptive Server finds

no legal query plan for this statement.).
Workaround Description
 Avoid using the derived table with a subquery in the select list.

But usually our customers' queries are too complicated to be changed.



CR:449756
CR Number:   449756
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.4 ESD#3 08 Dec 2006 Fixed
17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Adaptive Server Enterprise 12.5.4 ESD#2 running on unix platforms fails to provide a stack trace when an engine encounters a signal condition. Instead, the message "engine exited with signal <number>" is seen without any further diagnostics.
Workaround Description
 Upgrade to 12.5.4 ESD#3 or later release.



CR:449779
CR Number:   449779
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)
12 Dec 2006 Fixed
08 Mar 2007 Fixed
Description
Stack trace could occur during joins between local and remote tables with IN clauses.



CR:449888
CR Number:   449888
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2007 Fixed
Description
A "select into" with a partition clause from a view that contains a union may cause a stacktrace.



CR:449908
CR Number:   449908
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for the ability to generate a shared memory dump for any error that causes ASE to shutdown because the spid was holding a spinlock.



CR:449961
CR Number:   449961
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enable a group of users working together to have equivalent object permissions for any objects created by a user in the same group, including dropping objects.
Workaround Description
 Giving SA role to the users.

This is not acceptable to the user who required this Feature to be requested.



CR:450005
CR Number:   450005
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)
23 Feb 2007 Fixed
06 Aug 2007 Fixed
14 May 2007 One-off Provided
26 Jul 2007 Fixed
Description
When a stored procedure involving joins on regular tables and a derived table must be recompiled due to a schema change, column names might not be resolved correctly, yielding an erroneous "ambiguous column" error.
Workaround Description
 create procedure sel_actions_syb

as

select

d_a.xxx as cloud_id

from

netcool_actions na,

event_actions ea,

(select

a.cloud_id

from

actions a,

#action_ids t

where

a.cloud_id = t.cloud_id

) d_a (xxx)

where

na.cloud_id = d_a.xxx

and ea.cloud_id = na.cloud_id



go



CR:450010
CR Number:   450010
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)
22 Jan 2007 Fixed
Description
Partition elimination does not happen if a disjunctive predicate is given to a query where each side of the disjunction can result in partition elimination and the same set of predicates on partitioning columns appear in each side of the disjunction. Ex. (col1 = 10 AND col2=20) or (col1=10 AND col2=30) will be rewritten by the predicate factoring functionality as (col1 = 10) AND (col2 = 20 or col2 = 30), which results in a partial match of the columns used in partitioning i.e. col1 and col2 with the conjunctive predicates and prevents partition elimination.



CR:450039
CR Number:   450039
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Open
OS:   Solaris
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
srvbuild/srvbuildres:The order of -s parameters is different in RUN_Server files
Workaround Description
 Modify -s parameter to first position in RUN_SERVER file.



CR:450045
CR Number:   450045
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Windows W2k
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2007 Fixed
21 Nov 2007 Fixed
Description
Job Scheduler work abnormally when startdate is earlier than 83 days from present date.
Workaround Description
 Modificated the sched_startdate of js_schedules to the current date which should be the current date or very closed.



CR:450066
CR Number:   450066
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2007 Fixed
Description
Get msg 11060 when exec procedure which has SELECT INTO with encrypted columns.



CR:450105
CR Number:   450105
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Dec 2006 Fixed
18 Jan 2007 Fixed
21 Jan 2008 Fixed
Description
The message 'current process infected with 11' in module 'level0_restart' may be

reported in the error log when SP_SHOWPLAN is run or the configuration option

'plan text pipe active' is set and concurrent activity on table Syscolumns takes place.

Modules 'showplan', 'showKeys' and 'getcolname_level0_fromcache' will also be reported

in the stack trace.
Workaround Description
 Try turn off "plan text pipe active" if it was set.



CR:450130
CR Number:   450130
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2007 Fixed
23 Jan 2007 Fixed
18 Jan 2007 Fixed
22 Jan 2007 Fixed
Description
The error 8207 "Couldn't find an available descriptor for an object.

Raise the value of the configuration parameter 'number of open objects'

for more descriptors." may be raised in general, after errors 1204 were

reported "ASE has run out of LOCKS. Re-run your command when there are fewer

active users, or contact a user with System Administrator (SA) role to

reconfigure ASE with more LOCKS." when ASE runs out of locks during the

instantiation phase of a descriptor's meta-data, resulting in leaking

free descriptors mistakenly.
Workaround Description
 Increase "number of locks" to prevent error 1204.

Or increase "number of open objects" to get more free DES structures.



CR:450238
CR Number:   450238
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2006 Fixed
Description
When execute "sybatch.exe -r <resource file" to upgrade an ASE server, an error msg is printed to the console saying it can't find RUN_<server>.bat file in the new %SYBASE%\%SYBASE_ASE%\install directory.
Workaround Description
 * Manually boot the old ASE. To boot the old ASE, do the following in a command prompt:

- Set PATH, SYBASE, SYBASE_ASE, and SYBASE_OCS environment variables to the old ASE directories

- Execute the old %SYBASE%\%SYBASE_ASE%\install\RUN_<server>.bat

* Execute new "sybatch.exe -r <resource file>" while the old ASE is running



CR:450254
CR Number:   450254
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)
09 Jan 2007 Fixed
Description
Tables with large number of partitions may spawn a whole bunch of worker processes without getting any positive scaling. This is due to the fact that the optimizer makes an assumption that a large number of partitions mean that the table can support a parallel scan with the same number of threads as the number of partitions, which may not be the case. Often times, users have a large number of partitions because of manageability. This bugfix allows user to configure the maximal number of threads for a table or an index using the sp_chgattribute stored procedure.



CR:450261
CR Number:   450261
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2007 Fixed
25 Jan 2007 Fixed
Description
There are 2 types of OR optimization (i.e. predicates involving IN list or OR lists)

One is the general OR optimization which requires a HASH operator to remove

duplicate RIDs and another which removes duplicate keys (e.g. sorts the IN list

to remove duplicates, which can be done at compile time if none of

the keys are variables). The general OR optimization is usually takes

more elapsed time, and the duplicate key approach should be preferred.

This change corrects costing that prefers the duplicate key approach

which could improve performance in some cases.



An example of the type of query that may be helped by this is the following.



select * from sysusers where name in ('dbo', 'sa_role', 'guest', 'probe')

go



CR:450288
CR Number:   450288
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)
14 Dec 2006 Fixed
14 Dec 2006 Fixed
Description
When it is a 13941 error where the expected message is

" Cannot partition table xxx because your release level does not support partitioning.",

it shows up as a 4941 error whose message is,

" You cannot drop a column on which constraints are defined.

Drop the constraints before dropping this column.".



CR:450359
CR Number:   450359
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2006 Fixed
28 Feb 2007 Fixed
24 Apr 2007 Fixed
Description
sp_monitor aborts with an error reporting that the server "loopback" does not exist.
Workaround Description
 Define a remote server called "loopback" using the sp_addserver stored procedure: sp_addserver "loopback", NULL, <any server name>



CR:450395
CR Number:   450395
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2006 Fixed
Description
Previously Query Editor sometimes would not populate tables correctly. This has been fixed.



CR:450398
CR Number:   450398
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2007 Fixed
06 Feb 2007 Fixed
Description
Subsequent execution of a stored procedure with insensitive cursor with constant literal

in the select list may give incorrect result.



CR:450458
CR Number:   450458
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2007 Fixed
11 Jan 2007 Fixed
Description
When performing 'disk refit' after 'load database master', ASE can find allocation units on disk that are no longer part of a database and so should not be reflected in sysusages. Attempting to remove the extraneous entries can encounter a segmentation fault and stack trace, causing disk refit to fail.



CR:450459
CR Number:   450459
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2007 Fixed
Description
Expressions on sargs were not always evaluated when it should have

been possible to obtain a temporary value to be used for

histogramming estimation. When this was not done then

default selectivities were used for estimates which could

result in incorrect join orders.



All possible constant expressions are now evaluated at compile

time, if it could help with producing a histogramming sarg.



for example, "r.a > <some constant case expression>" would

not be used for histogramming estimates, and instead the

default selectivity of 0.33 would be used for this sarg.



CR:451308
CR Number:   451308
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2007 Fixed
02 Oct 2007 Reservation Made
05 Oct 2007 Fixed
10 Jul 2009 Insufficient priority to fix
27 Oct 2014 Insufficient priority to fix
Description
New feature to support plan sharing of cached statements across different users. Trace flag 7738 needs to be turned on to enable the feature.



CR:451323
CR Number:   451323
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)
15 Jan 2007 Fixed
Description
Add new options 'expire login passwords', 'expire role passwords', 'expire stale login passwords' and 'expire stale role passwords' to sp_passwordpolicy procedure to expire login and role passwords.



CR:451355
CR Number:   451355
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2007 Fixed
19 Jan 2007 Fixed
Description
There is a short-term memory leak for Lava hash operators that appear

in the inner side of a nested-loop join strategy or beneath a subquery.

A relatively small amount of memory is temporarily lost for each outer or

correlated row in the NLJ strategy or subquery respectively. If there

are a lot of rows in the outer side of an NLJ strategy or in the outer

block of a subquery, then the cumulative amount of memory temporarily lost

can be quite large. Note that this memory is given back to the system

once the query completes.



CR:451412
CR Number:   451412
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)
19 Jul 2007 Fixed
07 Aug 2009 Fixed
Description
In isolation 2, when we are doing ridjoin we are not holding locks on the pages till the end of the transaction.



CR:451448
CR Number:   451448
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 Feb 2007 Fixed
08 Oct 2007 Fixed
Description
Queries that use the special or startegy and have a descending

order by clause may return results in the wrong order. This will

occur if one or more of the columns in the disjuncts always reference

the same literal value.



CR:451453
CR Number:   451453
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2007 Fixed
01 Apr 2008 Not a Bug
Description
A low risky stacktrace occurs when sending a message to Tibco JMS messaging bus if the Tibco JMS has been enabled before dataserver is booted and the dataserver is booted without setting environment variable "SYBASE_JRE".



CR:451456
CR Number:   451456
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SYSAM2.0: If the Sysam Option file is modified to direct log files to a non-default location, the default log file is still created due to the '-l <logFile>' arguments coded into the sysam startup script.
Workaround Description
 Modify the sysam.bat script (or platform equivalent) and remove the '-l "%dbglog%' agrs from the command line.



CR:451524
CR Number:   451524
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2007 Fixed
29 Mar 2007 One-off Provided
08 Nov 2007 Fixed
27 Nov 2007 Fixed
Description
DUMP DATABASE WITH COMPRESSION will generate an invalid dump if the archive is a library created using the backup API. For example, DUMP DATABASE dbname TO "compress::myfile" WITH COMPRESSION=n.



CR:451549
CR Number:   451549
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)
22 Dec 2006 Fixed
03 Jan 2007 Fixed
03 Jan 2007 Reservation Made
11 Jan 2007 Fixed
26 Jan 2007 Fixed
Description
server might hit sig11 in CgpGlobal::CgpGenerate() when executing

a query involving a DISTINCT view and the part of the DISTINCT columns

has a unique index on them.
Workaround Description
 A quick workaround for this query is to remove the "distinct" from the view definition, because that is not necessary due to the existence of the unique index.



CR:451650
CR Number:   451650
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to provide a way to estimate the amount of space required for a table containing encrypted columns automatically.
Workaround Description
 Calculate actual length of encrypted columns based on the manual "Using Encrypted Columns in Adaptive Server".

And then create a dummy table and run sp_estspace on it.



1> create table test_normal (

2> key1 numeric(10) identity,

3> data1 varbinary(33),

4> data2 varbinary(33),

5> data3 varbinary(33)

6> )

7> go



1> sp_estspace test_normal, 100000, NULL, "data1,data2,data3"

2> go

test_normal has no indexes

name type idx_level Pages

Kbytes

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

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

test_normal data 0 5777

11555



(1 row affected)

Total_Mbytes

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

11.28

(return status = 0)

1>



CR:451682
CR Number:   451682
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2007 Fixed
07 Feb 2007 Fixed
Description
Variables within derived table expressions within cursor declarations

within stored procedures are not initialized correctly during

execution of the stored procedure.



CR:451690
CR Number:   451690
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 Jan 2007 Presently Not Targeted For Any Future Release Of This Product
20 Dec 2006 Fixed
23 Jan 2007 Fixed
17 Jan 2007 Fixed
Description
There was an overestimate of PIO for tables which are bound

to a large buffer pool, and also have a reserved page count

significantly higher than the table pages. This was due to

a double costing of the page cluster ratio, in addition to

the sparseness of rows in the extent. Adjustments were made

to avoid the double costing so that PIO estimates for large IO

are more accurate



CR:451696
CR Number:   451696
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)
26 Feb 2008 Consult Complete
16 Jan 2008 Fixed
Description
Secure role passwords by storing them using SHA-256 in syssrvroles.



CR:451739
CR Number:   451739
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 Feb 2007 Presently Not Targeted For Any Future Release Of This Product
08 Feb 2007 Fixed
28 Feb 2007 One-off Provided
Description
QPmetrics are not captured for non-CIS related query after CIS connection has been established within a particular session



CR:451749
CR Number:   451749
Product Name:   XML Model
Product Component:   XML Model
Status:   Closed
OS:   all
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2007 Fixed
19 Feb 2007 Fixed
Description
Fail to consolidate repository when Item sequence changed in XML model.



CR:451751
CR Number:   451751
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2007 Fixed
Description
The authentication mechanism may be missing or truncated in the audit trail

for a login event when a Kerberos principal name and mapped user login name

approaches 30 bytes in length.



CR:451760
CR Number:   451760
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)
30 May 2008 Presently Not Targeted For Any Future Release Of This Product
02 Sep 2007 Fixed
03 Sep 2007 Fixed
19 Jun 2012 Added to user documentation
Description
When statement cache is configured, the QPmetrics for ad-hoc statement using statement cache will not be dumped into the SYSQUERYMETRICS system catalog instantly. Instead, the QPmetrics of respective ad-hoc statements will be dumped when the statement is flushed out from the statement cache or by commands such as sp_metrics 'flush' and dbcc purgesqlcache.



CR:451812
CR Number:   451812
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2007 Fixed
25 Jan 2007 Fixed
23 Jan 2007 Reservation Made
Description
In some cases, intelligent index scan may cause low LIO estimate and wrong index is

chosen for the plan resulting in poor performance.
Workaround Description
 The customer said they cannot use abstract plan to workaround the problem due to the query has views with tables stored in different databases.



Has asked them to provide more precise statistics to see if it can help or not.



CR:451821
CR Number:   451821
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2007 Fixed
Description
Deadlock occurs when a successful LDAPUA updates the syslogins password or the syslogins lastlogindate is being updated for the first time. This occurs when the update is on the same login row by two different login tasks.



CR:451837
CR Number:   451837
Product Name:   Adaptive Server Enterprise
Product Component:   Language Modules
Status:   Closed
OS:   Linux
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2012 EOL'd version. Not to be Fixed.
14 Sep 2012 Insufficient info provided
Description
Default LANG of Japanese RHEL4.0 is "ja-JP.UTF-8."

But "ja_JP.UTF-8" is not included in Linux section of locales.dat.



Please add the following lines to linux section of locales.dat.

locale = ja_JP.UTF-8, japanese, utf8
Workaround Description
 Please add the following lines to linux section of locales.dat.



locale = ja_JP.UTF-8, japanese, utf8



CR:451875
CR Number:   451875
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2007 Duplicate
Description
Excessive procedure cache used when too many statistics steps are configured. Consider reducing number of steps or histogram tuning factor.
Workaround Description
 1) reduce the number of histogram steps, since they are way too large, especially when histogram

tuning factor is taken into consideration.



CR:451898
CR Number:   451898
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)
11 Jan 2007 Fixed
12 Jan 2007 Fixed
Description
There are some inconsistencies in pre-15.0 statistics that

are corrected during upgrade. In this case, there were

range cells and yet the range density was zero, which

occurs occasionally due to a pre-15.0 problem in

update statistics in which the range cell only exists in the

last cell of the histogram and the remaining cells are

frequency cells. The inconsistency are now corrected during

upgrade to 15.0.



CR:451900
CR Number:   451900
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2007 Presently Not Targeted For Any Future Release Of This Product
15 May 2007 Fixed
15 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Error 1013 will be raised if japanese object name is specified in an abstract plan.



CR:451902
CR Number:   451902
Product Name:   Adaptive Server Enterprise
Product Component:   FTS SDS
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2007 Fixed
Description
If you create a table and add a numeric identity column to the table, sp_create_text_index fails on the table with a message

"Datatype numeric ( Column 'xxx' ) is not supported in a text index.".



CR:451928
CR Number:   451928
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2008 Fixed
Description
When no valid license is available for the platform on which ASE is running, but licenses are available for other platforms, then ASE may crash on startup with a signal 11 after reporting "SySAM: Using licenses from" .
Target Version
 15.0.3
Workaround Description
 Removed the DEMO license for non-solaris platform and just keep the right license.



CR:451934
CR Number:   451934
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2007 Fixed
21 Feb 2007 Fixed
27 Feb 2007 Bundled Request
Description
Selecting from a decrypt_default table from a different database causes segment fault error.



CR:451944
CR Number:   451944
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Dec 2006 Fixed
28 Jun 2007 Fixed
Description
Loading a compressed archive database may hang if the size of the compression memory pool is set to the minimum size required that is the double of the dump blocksize. Even if the LOAD command succeeds, the hang can happen at anytime because the compression memory gets fragmented.



CR:451945
CR Number:   451945
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2007 Fixed
27 Jun 2007 Not a Bug
Description
When loading an archive database, the message 'Unable to determine the size of the device '<devname>'' will be raised for each device installed that is unavailable.



CR:451966
CR Number:   451966
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2007 Fixed
05 Mar 2007 Fixed
12.5.4 05 Mar 2007 Fixed
Description
HA command, sp_companion may fail for HA-enabled dataserver on Sun Cluster 3.1 running on Solaris 10.



CR:452023
CR Number:   452023
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2007 Fixed
11 Jan 2007 Fixed
Description
Union query with subquery could cause staktrace in s__mergelock_in_sub_steps().

This will happen only when there is datetype mismatch and implicit conversion is

need and also involve subquery in expression.



CR:452033
CR Number:   452033
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2008 Fixed
07 Aug 2008 Fixed
24 Oct 2008 One-off Provided
Description
Backup Server needs to print Open Server operating system related error message in error log as well as standard error.



CR:452045
CR Number:   452045
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 Feb 2007 Duplicate
Description
Provide encrypted colums support in the 12.5.4 64 bit linux release.



CR:452118
CR Number:   452118
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2007 Fixed
24 Jan 2007 Fixed
24 Jan 2007 Reservation Made
29 Jan 2007 Fixed
20 Mar 2007 Fixed
Description
If estimation errors occur with join cardinality estimations, or estimates with index scans on DOL tables, then update statistics with this fix may correct those estimates. The problem of inaccurate statistics occurs when the "with consumers" phrase is used on update statistics or a clustered index is created on a partitioned table.



CR:452160
CR Number:   452160
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2007 Not a Bug
Description
When it connects with server from Sybase Central v4.3 attached to ASE 15.0.x, Explanation of "number of open partitions" is wrong.

This Explanation is "cpu grace time."



CR:452178
CR Number:   452178
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2009 Insufficient priority to fix
05 Aug 2008 Fixed
Description
Optdiag input mode may fail with error message "At step <n> of the histogram for

<column>, the step value is not increasing" for variable length datatypes.
Workaround Description
 Use the binary mode of optdiag.



CR:452189
CR Number:   452189
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2007 Fixed
04 Mar 2007 One-off Provided
05 Mar 2007 Fixed
17 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Incorrect code execution on ibmaix64 for fbo mode may lead to difference in

selectivities for sarg.



CR:452198
CR Number:   452198
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2007 Duplicate
Description
Bad offset in variable length offset table causes 9289 from RA
Workaround Description
 Since using the trace flag 9217 is not available on this customer's release/EBF level, the only option is to move the secondary truncation point to the next page in the log and restart up the RA.



CR:452199
CR Number:   452199
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2007 Fixed
Description
Stored procedre creating a table with complex CHECK clause may fail with stack trace

when the execution is performed from the cached plan.
Workaround Description
 Execute procedure with recompile



CR:452221
CR Number:   452221
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 2008 Added to user documentation
Description
ASE uses @@opttimeoutlimit and ASE documents use

@@opttimeout as a server global variable for the current optimization timeout limit.



CR:452280
CR Number:   452280
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2007 Fixed
Description
The message "current process infected with 11" in the module

'close_range' together with a stack trace which includes the

modules 's_estmt_loopend' and 's_execute' may be reported

in the error log if a DML statement is executed involving

a high number of tables, the table being modified has many

referential constraints and there is a trigger defined on it.





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