远程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:441140
CR Number:   441140
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)
06 Oct 2006 Fixed
28 Aug 2007 Fixed
Description
Under rare circumstances an undetected deadlock may occur between the

housekeeper 'HK_WASH' system task and a session that performs a DML

command in a table whose database has mixed log and data segments

when that table uses a cache that has a memory pool configured.
Workaround Description
 avoid using mixed log and data



CR:441188
CR Number:   441188
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)
08 Nov 2007 Fixed
11 Apr 2012 Added to user documentation
02 Dec 2007 Fixed
Description
When ASE has been configured to provide email notification of SySAM licensing failures, and the "email.helo.fqdn" property in the SySAM property file is set to the fully qualified domain name, the email messages should contain the specfied HELO token.



CR:441249
CR Number:   441249
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)
27 Sep 2006 Fixed
13 Feb 2007 Presently Not Targeted For Any Future Release Of This Product
Description
DBISQL: If the command to create a stored procedure contains syntax errors, DBISQL incorrectly reports the error at Line 1, column 1.
Workaround Description
 None known.



CR:441262
CR Number:   441262
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)
07 Sep 2006 Fixed
Description
Stacktrace could happen for query with a DISTINCT clause on

constant_expression(s) only. For example,

select count(distinct 1+2) from t



CR:441274
CR Number:   441274
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)
15 May 2007 Fixed
13 Mar 2008 Fixed
Description
CREATE RULE statement incorrectly allows the creation of rules that use subqueries on its definition.



CR:441278
CR Number:   441278
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)
07 Nov 2006 Fixed
Description
Results aren't correctly sorted in some cases when the FOR BROWSE option is used with the ORDER BY clause in a SELECT statement.



CR:441349
CR Number:   441349
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)
18 Jun 2007 Duplicate
Description
This behavior only occurs when the local variable is uninitialized.

Giving a correct usage would avoid this problem.

i.e. declare @var int select @var = <a value>



CR:441376
CR Number:   441376
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)
17 Nov 2006 Fixed
18 Dec 2006 Fixed
Description
Proxy tables cannot be partitioned in ASE 15.0.2.



CR:441424
CR Number:   441424
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Windows XP
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2010 Fixed
30 Nov 2006 Fixed
05 Dec 2006 Fixed
17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Following a seemingly successful installation of PC Client 12.5.4, two errors are encountered:

+ No mclib in java.library.path

+ This application has failed to start because javaai.dll could not be found. Reinstalling the application may fix this error.
Workaround Description
 The first problem can be worked around by manually setting the classpath.



The second problem can be worked around only if the missing dll, javai.dll is present on the client PC, then editing the path can resolve this.



Updated dll's can be located here:

/remote/cases/11297000s/11297196/pseinfo-11/Repro/1254_dlls.zip



CR:441433
CR Number:   441433
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)
13 Sep 2006 Fixed
13 Sep 2006 Fixed
13 Sep 2006 Fixed
13 Sep 2006 Fixed
17 Oct 2006 Fixed
14 Nov 2006 Fixed
Description
Under rare circumstances a session may hang forever during a lock request

despite ASE having granted the lock to the session. This is a side effect

from the fix of CR 399737. The modules "lock__semawait", "log__lock" and

"lock_psema" will be reported in the call stack of the hanging session.



CR:441454
CR Number:   441454
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2010 Fixed
03 Nov 2011 Duplicate
Description
The MDA table monErrorLog does not record SySAM sylapi messages.



CR:441490
CR Number:   441490
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)
Description
In some cases the PRINT DEADLOCK INFORMATION output does not display the actual line of code that caused the deadlock to occur.



CR:441498
CR Number:   441498
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)
13 Sep 2006 Fixed
Description
Handle this situation: the "selector" is consist of blank characters when subscribing a JMS topic.



CR:441514
CR Number:   441514
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2006 Fixed
25 Sep 2006 Fixed
Description
For range or list partitioned table, if the partition bound value is specified

using unichar format U&'***', subsequent insert into the table may fail or insert

into incorrect partition.
Workaround Description
 When specify the bound value for range or list partition on unichar/univarchar

column, use the string or binary format instead of the U&'***' format to enter

the bound value.



CR:441592
CR Number:   441592
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)
06 Oct 2006 Fixed
Description
Join operators evaluated virtual columns before any of the filtering

predicates. As a result, they might raise user exceptions that could

otherwise be avoided if the evaluation was deferred until just before the

result is returned. This way, filtering predicates might eliminate the

row before the exception occurs. This is similar to the problem fixed

in CR 436738 (where the problem was fixed for scan, remote scan, or,

and restrict ops).
Workaround Description
 Using CASE expression can be found from CR 426272-1 explanation in detail



CR:441605
CR Number:   441605
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2006 Duplicate
Description
Increase the trace_log_file value to accomodate paths larger than 30 characters.
Workaround Description
 None currently



CR:441614
CR Number:   441614
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 Sep 2006 Fixed
03 Oct 2006 Bundled Request
04 Dec 2006 Bundled Request
Description
When using EAServer with RTDS 4.0 for messaging, the msgunsubscribe command may fail.
Workaround Description
 If possible try not to use unsubscribe and instead use a different subscription name to subscribe to the same topic with different clients.



CR:441664
CR Number:   441664
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.0.2 12 Sep 2006 Fixed
25 Sep 2006 Fixed
22 Sep 2006 Fixed
Description
Sig-11 will occur if a semantically partitioned temporary table is dropped,

while the semantic partitioning feature is OFF.
Workaround Description
 Enable semantic partitioning



CR:441690
CR Number:   441690
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2006 Fixed
Description
Previously the default port number for Jini server discovery service on Edit/Add Discovery Setting dialg was 9999. It has been changed to the correct port number 4160.



CR:441776
CR Number:   441776
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Windows W2k
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2008 Fixed
26 Aug 2008 Fixed
Description
Historical Server version 12.5.4 crashes using the 'direct load to ASE' feature when executing hs_create_recording_session.
Workaround Description
 Do not use this feature with HS 12.5.4.



CR:441785
CR Number:   441785
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2006 Fixed
29 Nov 2006 Fixed
Description
Subquery LT/LE/GT/GE ANY/ALL syntax cannot be quickpassed to remote IQ server 12.6 and

above even though the IQ server supports the syntax.



CR:441803
CR Number:   441803
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)
31 Oct 2006 Fixed
31 Oct 2006 Reservation Made
Description
Forced join orders and other forced options can now be ignored in a query through the use of Traceflag 15307 and 15308. When Traceflag 15307 is enabled, join orders forced using FORCEPLAN will be ignored. When Traceflag 15308 is enabled, forced index/prefetch/parallel/replacement options will be ignored.



CR:441814
CR Number:   441814
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2007 Fixed
02 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
When a predicate in a query needs data type conversion for literals that result in data loss, partition elimination does not happen. As an example, a query wih a equality predicate on some literal may result in no data loss and the optimizer may eliminate the respective partitions, provided a semantic partition exists on that column. But, if the literal is different with a higher precision, data type conversion will make the result of the predicate false, and the partition elimination functionality fails to eliminate the required partitions.



CR:441858
CR Number:   441858
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)
04 Oct 2006 Not a Bug
Description
sp_extrapwdchecks failed to custom password checks.



CR:441869
CR Number:   441869
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Insufficient priority to fix
Description
Customer would like a built-in function similar to user_name() that would return the current process ID for use in a view. The customer cannot use @@spid as this cannot be used in a view.
Workaround Description
 get_appcontext('SYS_SESSION', 'spid')



CR:441892
CR Number:   441892
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2006 Fixed
Description
User with anonymous connection to UA could not open Roles folder because ASEP would not be able to display role mappings. The requirement is now relaxed so that user with sa_role/sso_role/anonymous-UA-credential can still open Roles folder. The role mappings column won't be shown in this case.



CR:441932
CR Number:   441932
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)
17 Sep 2006 Fixed
09 Mar 2007 One-off Provided
13 Jun 2007 One-off Provided
Description
An EX_INT lock was held on Syslogins when a connection logged into ASE, this is now changed to a SH_INT lock to help release this lock as soon as the scan is finished.



CR:442010
CR Number:   442010
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)
13 Nov 2006 Fixed
Description
Enhanced LOAD database WITH VERIFYONLY to be tolerant of database existance and size.



CR:442045
CR Number:   442045
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2006 Fixed
12 Oct 2006 Presently Not Targeted For Any Future Release Of This Product
Description
DBISQL unable to access tables with large identifiers. It gets error:

The identifier that starts with 慳bcdefghijklmnopqrstuvwxyznowi is too

long. Maximum length is 30. Sybase error code=103



CR:442062
CR Number:   442062
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2006 Fixed
Description
The value of BufferPools column in the monDataCache MDA Table for the default data cache, is incorrectly reported as two when only one pool is created.
Workaround Description
 Get the correct value

1> select count(*) from monCachePool

2> where CacheName = "default data cache"

3> go



CR:442080
CR Number:   442080
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2006 Fixed
27 Sep 2006 Fixed
19 Dec 2006 Fixed
02 Oct 2006 Fixed
18 Dec 2007 Fixed
17 Dec 2007 Fixed
05 Dec 2006 Fixed
17 Dec 2007 Fixed
19 Dec 2006 Fixed
Description
When queries use a IN list or joins under ORs, the costing had flaws such that dynamic index strategies were chosen with a RID scan, instead of a sometimes cheaper special OR optimization using an OR scan. This would only occur if joins are involved, and the OR predicate can be applied to the inner table of a nested loop join operator.



In a query such as the following



SELECT

M.fiscal_period

, T.service_key

, sum(T.local_call_minutes)

, sum(T.local_call_count)

, count(*)

FROM

telco_facts T

, residential_customer C

, service S

, month M

WHERE

T.customer_key = C.customer_key

AND T.service_key = S.service_key

AND T.month_key = M.month_key

AND M.fiscal_period = 'Q4'

AND T.service_key in (02, 03)

AND C.state = 'CA'

GROUP BY

M.fiscal_period

, T.service_key



if the join order chosen used nested loop joins, and the T.service_key table was not at the beginning of the join order, then there was a possibility for an incorrect costing.
Workaround Description
 use force plan options



CR:442121
CR Number:   442121
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2006 Fixed
18 Sep 2006 Deferred
05 Dec 2006 Fixed
Description
The execution of SELECT-INTO under the SET CHAINED option context

must not trigger the implicit start of a chained transaction.
Workaround Description
 Do not use datarows as the default locking scheme, OR

turn off large page allocations with trace flag 1101, OR

make the select-into cmd produce an APL vs. DOL table

(into #test lock allpages), OR

commit tran just after the select-into is run.



*NOTE* that although the workarounds above are possible

we should not have allowed the execution of a select-into cmd

when a chained transaction was started already.



CR:442182
CR Number:   442182
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2006 Fixed
Description
Adhoc queries with large batches allocate memory in large chunks resulting

in improved scans of the memory prochdrs. This improves response time in

queries where large chunks of memory are consumed.



CR:442213
CR Number:   442213
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2006 Fixed
01 Oct 2009 Presently Not Targeted For Any Future Release Of This Product
Description
When running out of procedure cache, error 701 is returned, followed by the corruption of the stack guardword.



CR:442249
CR Number:   442249
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2006 Fixed
19 Sep 2006 Fixed
18 Dec 2006 Fixed
Description
sybmigrate may issue the message "Internal error: (com.sybase.sybmigration.lang.messages) Unable to get mneumonic 'GUI_MNEM_TASK_THREADS'." Although reported as an error this message was not a serious problem.



CR:442289
CR Number:   442289
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)
24 Oct 2006 Fixed
Description
Wrong result may be reported when a query id executed which includes DISTINCT or ORDERBY clause along with a 'outer join'.



CR:442309
CR Number:   442309
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2006 Fixed
01 Dec 2006 Fixed
06 Dec 2006 Reservation Made
09 Jan 2012 Presently Not Targeted For Any Future Release Of This Product
17 Jan 2007 Fixed
Description
Some views containing a union all query will fetch superfluous columns from the base tables when a user query aggregates over the view.



CR:442336
CR Number:   442336
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)
18 Nov 2006 Fixed
27 Nov 2006 Reservation Made
Description
If a table column has a functional index on it and when we update this column, it could cause stacktrace.



CR:442427
CR Number:   442427
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
Description
Migration tool fails to migrate server logins if Job Scheduler is installed.



CR:442494
CR Number:   442494
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2006 Fixed
26 Sep 2006 Fixed
01 Dec 2006 Fixed
Description
On IBM and Mac platforms, a 15760 error, "Invalid dump header when loading the database with ID '<dbid>'" is reported when an archive database is loaded using a database dump for which a sysdevices row has already been created using the 'sp_addumpdevice "archive database"' stored procedure.
Workaround Description
 Do not add the stripe devices using sp_addumpdevice "archive database". Simply load directly from the stripe set.



CR:442519
CR Number:   442519
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)
07 May 2008 Duplicate
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:442521
CR Number:   442521
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)
20 Jan 2007 Fixed
Description
Display login password encryption information using sp_displaylogin.



CR:442525
CR Number:   442525
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)
22 Feb 2007 Fixed
11 Mar 2008 Fixed
Description
A union with subquery in the result list may fail with error 530 ("Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS. UPDATE fails.") if the subquery

is producing empty result set.
Workaround Description
 Re-write the subquery with a noop isnull: isnull((subquery),null)

Example of the repro:

select 1, isnull((select id from v_t where 1=2), null)

union

select 2, 1

go

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

1 NULL

2 1



(2 rows affected)



CR:442529
CR Number:   442529
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   Windows
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Nov 2007 Fixed
Description
sybatch - sample res scripts in 1501 release include paths for ASE 12.5 releases



CR:442558
CR Number:   442558
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)
29 Sep 2006 Fixed
Description
Cannot boot server due to the error "missing lib error with solaris-32 bit dataserver: __fabsf in libm.so.1"



CR:442560
CR Number:   442560
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2007 Presently Not Targeted For Any Future Release Of This Product
02 Jan 2008 Fixed
03 Jan 2008 Fixed
Description
SSL ct_connect attempts fail intermittently when ASE is started with a TLI listener with the following error: Client MsgNo: 84083974. Client Msg : ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect.
Workaround Description
 Use a TCP style SSL entry for your ASE during startup. Example:

UMSPROD

## TCP style entry for SSL-secured connection to production server

master tcp ether sunspot 7777 ssl

query tcp ether sunspot 7777 ssl



CR:442588
CR Number:   442588
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)
07 Feb 2007 Fixed
07 Feb 2007 Reservation Made
Description
Subqueries that contain a group-by clause that references one or more correlated

columns (from an outer query block) may return incorrect results.
Workaround Description
 Use trace commandline flag 450 to force the use of group-inserting operator

rather than the group-hashing operator.



CR:442601
CR Number:   442601
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)
27 Sep 2006 Fixed
Description
Command "create database sybsecurity" fails. The named database contains upgrade items that are not present in model, so "use database" (part of the command's action) refuses access because sybsecurity is not fully upgraded. There is no workaround.



CR:442629
CR Number:   442629
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)
09 Jan 2007 Fixed
Description
Attention and kill processing is not working as expected for a process waiting for a RTDS message. The process may hang, without possibility to recover from that state. There is no workaround nor solution before the current fix.



CR:442668
CR Number:   442668
Product Name:   Adaptive Server Enterprise
Product Component:   FTS SDS
Status:   Open
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2006 Third Party Problem
Description
For less than 3 words verity generates null summary. suggested style file changes fix the issue.
Workaround Description
 For small documents that has less than 3 words it generates null summary.The work around for the problem would be to use more words, until the issue is fixed.



CR:442683
CR Number:   442683
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Apr 2007 Fixed
Description
If truncation length is set to 0, no data is returned for text col in dbisql
Workaround Description
 If you know the approx size of data in the text field then set Truncation Length to that rather than setting it to 0



CR:442736
CR Number:   442736
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)
09 Oct 2006 Fixed
10 Oct 2006 Fixed
Description
Incorrect results may be returned when executing a query

that involves several complex AND/OR predicates combination

involving multiple columns.



CR:442752
CR Number:   442752
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2006 Fixed
Description
Wrong comparison result might be generated when MixedDTSarg is used on money->binary,

unichar->char, char->binary, or unichar->binary casting.



CR:442820
CR Number:   442820
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2006 Fixed
25 Oct 2006 Fixed
25 Oct 2006 Fixed
Description
Sessions may SEGV when compiling heavily used procedures. This can occur

as the result of deadlock while compiling a procedure. A deadlock situation

during compilation should only occur when compiling a block that updates or

inserts into a table that contains computed columns and/or functional indices.



CR:442902
CR Number:   442902
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2010 Fixed
02 Feb 2012 Added to user documentation
17 Nov 2011 Fixed
Description
The MDA tables monOpenObjectActivity, monOpenPartitionActivity and monProcessActivity are enhanced to include IOSize1Page, IOSize2Page, IOSize4Page and IOSize8Page columns to track large I/O counts per-spid/per-user process.



CR:442944
CR Number:   442944
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2006 Fixed
Description
The showplan ouput for a positioned DELETE or UPDATE query will show a 'TABLE SCAN' of the table being modified when the query execution actually uses a dynamic index.



CR:443098
CR Number:   443098
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)
27 Oct 2006 Fixed
Description
Incorrect results may be returned under special circumstances

when executing a query that involves a join with complex

expressions for the join predicates and the optimizer decides

to apply "reformatting" (store index) technique to the inner

table (i.e. substituting it with a worktable with an index

on it)
Workaround Description
 Disable reformatting via 'set store_index 0'.



CR:443194
CR Number:   443194
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2006 Fixed
Description
Previously when closing DBISQL, if user's "$HOME/.isqlHistory9" file does not have read/write permission or if DBISQL fails to access the file, a stack trace would occur. This has been fixed.



CR:443246
CR Number:   443246
Product Name:   Adaptive Server Generic Docs
Product Component:   To Be Determined
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
All ASE 12.5.x product manuals from 12.5.1, in which the XML features were introduced,

should mention the following character set related limitations:

+ The XML functions in ASE 12.5.x versions do not support i18N (those in ASE 15.0 do)

+ The XML outputs generated by ASE 12.5.x are restricted to the first 128 byte-points only



CR:443258
CR Number:   443258
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   IRIX
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2006 Not reproducible with latest version of the product available as of Resolution Date
03 Aug 2007 Fixed
02 Apr 2008 Fixed
Description
The error 11206, 'Unable to connect to server' will be raised if a

user tries to access an MDA table from within a login script in

some 64 bits platforms.



CR:443277
CR Number:   443277
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2006 Fixed
04 Dec 2006 Fixed
Description
One or more hard faults with type code 100001, "The page id, next page, or previous page value in the page header is invalid." is reported by DBCC CHECKSTORAGE when run against an archive database on which a transaction log has been loaded that encapsulates an ALTER DATABASE command.
Workaround Description
 Not needed - simply ignore the DBCC CHECKSTORAGE errors.



CR:443295
CR Number:   443295
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2006 Fixed
13 Oct 2006 Fixed
21 Oct 2006 Fixed
25 Oct 2006 Fixed
02 Nov 2006 Fixed
Description
If a partitioned table contains an encrypted column and if the encryption

key has been specified for encryption operations using an initialization vector,

then a paralellized update or select of the encrypted column may display the

following error message or a similar one, and the errorlog may show a

stack trace showing the function 'col_encrypt' or 'col_decrypt'.

"Error: 15414, Severity: 18, State: 3

01:00025:00021:2006/09/29 09:14:38.62 server An internal error occurred at end of symmetric encryption or decryption operation (error code 57606). Please contact Sybase Technical Support."



CR:443332
CR Number:   443332
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)
23 Jan 2008 Fixed
28 Jan 2008 Reservation Made
19 Jun 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
The message "current process infected with 11" in the module 'uwdisconnect' together with a stack trace which includes the modules 'err_pll_primary_processing' and 'pll_exec' may be reported in the error log when a query being executed in parallel on a multiengine server was aborted by CTRL+C or client application was killed.



CR:443447
CR Number:   443447
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2006 Fixed
24 Sep 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Execute immediate query performing query with LIKE clause using inherited local variables

or parameters fails during the compilation of the statement. Stack trace is dumped to the

errorlog file and shows modules opt_like, opt_like_and.



CR:443457
CR Number:   443457
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)
09 Mar 2007 Fixed
Description
Under special circunstances, REPLICATION AGENT started in recovery mode may fail to stop automatically after reaching the end of the log.



CR:443497
CR Number:   443497
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Windows XP
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2006 Fixed
Description
On Windows xp_cmdshell with no_wait option fails to execute a script.
Workaround Description
 Add "@echo off" as the first line in the command file



CR:443537
CR Number:   443537
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2013 Duplicate
Description
DDLGen does not support SQL User Defined Function (UDF)



CR:443557
CR Number:   443557
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)
26 Oct 2006 Fixed
Description
sp_sysmon may report wrong values for Replication Agent counter "Longest Wait" in different sections: "Log Extension Wait", "Forward Schema", "Backward Schema" or "I/O Wait from RS". This may happen if Replication Agent sleeps for a elapsed time longer than the sample time stablished by sp_sysmon.



CR:443558
CR Number:   443558
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2006 Fixed
17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
Description
A 15703 error,"Failed to delete row(s) from sysaltusages in the scratch database" will be incorrectly reported when trying to drop an archive database if the rows that describe the scratch database and the associated devices have been manually deleted from sysattributes.



CR:443575
CR Number:   443575
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)
27 Oct 2006 Fixed
Description
UPDATE() function inside a trigger may fail to

identify correctly which columns are affected

by an UPDATE statement that includes a local

variable assignment and that assignment is the

first one in the SET clause.
Workaround Description
 Rewrite the statement and avoid to put the

variable assignment in the first place in

the SET clause.



CR:443584
CR Number:   443584
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)
04 Oct 2006 Fixed
05 Oct 2006 Fixed
Description
When a special or strategy is used as a scan node (set) in an nary-NLJ strategy, then too few rows may be returned.
Workaround Description
 Trace commandline flag 342 can be used to work around this problem.

It will disable nary-NLJs (although the problem is not in the nary-NLJ

strategy but shows up there).



CR:443596
CR Number:   443596
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2006 Fixed
06 Oct 2006 Fixed
10 Oct 2006 Fixed
24 Nov 2006 Presently Not Targeted For Any Future Release Of This Product
Description
Stored procedure may stop working returning errors related to too high number of worktables

used in the query. This happens if the procedure executes SELECT INTO with query producing worktables

(order by, distinct, group by, materialized views) and requires recompilation.
Workaround Description
 do not use 12.5.4 esd#1



CR:443605
CR Number:   443605
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)
19 Oct 2006 Fixed
17 Sep 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
SH_INTENT Deadlocks occur on SYSCOLUMNS when concurrent queries using cross-database objects are normalized while utilities (such as drop of an index) holding EX_TAB lock on SYSCOLUMNS are in progress.



CR:443647
CR Number:   443647
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2008 Fixed
08 Oct 2008 Fixed
05 Mar 2009 Fixed
20 Oct 2008 Fixed
04 Jan 2009 Fixed
05 Mar 2009 Fixed
Description
A new Kazahkstan Cyrillic charset KZ-1048 has been added in ASE. The sort order is binary.



CR:443668
CR Number:   443668
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2006 Fixed
06 Oct 2006 Fixed
10 Oct 2006 Fixed
18 Dec 2006 Fixed
Description
Under rare circumstances DBCC TABLEALLOC may hang forever when executed with the FIX option

to correct error messages "There are <value> OAM entries with zero used/unused page counts.

Run DBCC TABLEALLOC FIX ..." when the OAM entries needing cleanup are the first in the list.



CR:443700
CR Number:   443700
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2007 Fixed
15 Jan 2008 Not a Bug
19 Nov 2009 Fixed
23 Nov 2009 Fixed
Description
Add the ServerUserID column to the monProcess and monProcessWaits table and make the column a parameter,and also make the ServerUserID column a parameter in monProcessActivity table.



CR:443742
CR Number:   443742
Product Name:   Adaptive Server Generic Docs
Product Component:   Other
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2008 Added to user documentation
Description
If raiserror is followed by any TSQL statement, @@error gets overwritten.

Because of this sp_extrapwdchecks fails to return error in case of failed password, if the raiserror is followed by any TSQL statement.



CR:443755
CR Number:   443755
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 Oct 2007 Fixed
11 Oct 2007 Fixed
11 Oct 2007 Reservation Made
Description
This fix introduces Abstract Plans syntax to request index union or intersection.



Pre-15.x, the "general OR strategy" was enumerated and costed by the optimizer when the WHERE clause contained OR clauses and all columns therein had indexes: each OR term was used in an index scan, then all resulting RIDs, after duplicate RID removal, were used to get the data tuples. This is actually an union-distinct mechanism and is implemented in 15.x as index union.



In 15.x, to request the pre-15.x general OR strategy on table T, i.e. the index union, an AP would use "(union_scan T)". To specify either the merge or the hash based union-distinct algorithm, use merge_union_scan or hash_union_scan. Index intersection is also provided for experimentation but not yet for production, through hash|merge_intersect_scan.



This functionality is used in the allrows_oltp "compatibility" mode (where the optimizer makes the best attempt to generate an execution plan similar to the pre-15.x one) when the legacy plan used the general OR strategy.



CR:443769
CR Number:   443769
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)
17 Oct 2006 Fixed
26 Jul 2007 Fixed
Description
A 691 error, "Encountered invalid logical page '0' while accessing object <negative id> in

database '2'" may be reported when there are more then 128 disk fragements for tempdb database.
Workaround Description
 Make sure tempdb has less than 129 fragments.



CR:443787
CR Number:   443787
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)
27 Oct 2006 Fixed
13 Oct 2006 Reservation Made
05 Dec 2007 Insufficient priority to fix
Description
New features within ASE 15.0.2 require that we modify system catalogs. Provide support within ASE for detecting the need to do those modifications, and for downgrading to 15.0 and 15.0.1 servers. Upgrade must be automatic upon first boot of the new server, and upon online database after load database.



CR:443811
CR Number:   443811
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2007 Fixed
26 Jan 2007 Fixed
Description
A task waiting on completion of a remote process (such as backup) cannot be killed



CR:443815
CR Number:   443815
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2006 Fixed
09 Oct 2006 Fixed
09 Oct 2006 Fixed
29 Oct 2006 Duplicate
Description
When the "histogram tuning factor" configuration parameter something other than 1, and the "consumers" phrase is used in create index, and/or update statistics in order to obtain parallelism, then there is a possibility of an extraordinary number of histogram steps being created on the respective histogram, and this becomes additive, i.e. each execution of update statistics will increase the requested number of steps. This could result in resource issues for compilation w.r.t. locks, procedure cache, and possibly compilation time.



CR:443821
CR Number:   443821
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2006 Insufficient priority to fix
Description
Customer is requesting that we make it possible to configure, at the user level, to eliminate this message from the dbcc output. As it currently stands the user cannot control whether this counter is setup or not.
Workaround Description
 *** Thursday, October 05, 2006 10:10:11 PM *** cooperg ***

N/A



CR:443852
CR Number:   443852
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)
07 Jan 2007 Fixed
Description
Occasionally, error message 9502 will be reported for a SELECT statement executed with 'set string_rtruncation on' for a SARG on char/varchar column that has statistics



CR:443885
CR Number:   443885
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)
18 Dec 2006 Fixed
05 Nov 2006 One-off Provided
18 Jan 2007 Fixed
17 Jan 2007 Fixed
Description
ssl_alloc() errors during Distinguished Name (DN) Lookup when binding the admin account, "the access account", can cause the security principal to be "locked out" because too many unsuccessful login attempts can be quickly attempted, exceeding the installation standards for unsuccessful retries.
Workaround Description
 Increase Netmemory. Alter LDAP login policies (impossible for many customers).



CR:444035
CR Number:   444035
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)
04 Dec 2006 Presently Not Targeted For Any Future Release Of This Product
29 Dec 2006 Fixed
Description
In rare circumstances, TIBCO JMS or EAS JMS messaging operations may fail with one or more error(s) reported in the JRTMSServer log file (rtms.log by default) saying a "lookup operation failed".



CR:444044
CR Number:   444044
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need to enable client-side character conversion BLK_CONV in CIS
Workaround Description
 bcp the data out of the "sjis" server with -Jutf8 to convert

the data into utf8 and then bcp the data into "utf8" server.



CR:444050
CR Number:   444050
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2006 Fixed
Description
A SELECT INTO combining the PARTITON clause with a UNION raises a 205 error even though the column lists are identical.



CR:444117
CR Number:   444117
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)
10 May 2007 Fixed
24 Jul 2007 Fixed
Description
The auditing of login failures is enhanced to include the "Error number.Severity.State" in the "Other Information" section of extrainfo column.



CR:444143
CR Number:   444143
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)
24 Oct 2006 Fixed
03 Aug 2007 Fixed
01 Aug 2007 Fixed
Description
In rare circumstances, two transaction logs that were dumped within a fraction of a second of one another, can be loaded in either order. Using the wrong order will have unpredictable effects on database recovery.
Workaround Description
 The implication of this bug is that two transaction logs can be loaded in either order. The wrong order will cause problems. Two workaround exists:



1. load the transaction logs in the correct order

2. do not allow transaction log dumps to be taken so close to one another.



CR:444156
CR Number:   444156
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)
01 Nov 2011 Insufficient priority to fix
Description
enhance CIO on Veritas Storage Foundation



CR:444193
CR Number:   444193
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2007 Fixed
12 Jan 2007 Fixed
04 Feb 2007 One-off Provided
Description
Occasionally, error message 9502 will be reported for a SELECT statement executed with 'set string_rtruncation on' for a SARG on char/varchar column that has statistics
Workaround Description
 Turn off string_rtruncation. Originally thought ODBC would work but the query hangs using a Java ODBC client. C++ client sample seems to work fine but that is not an option for the customer.



CR:444221
CR Number:   444221
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)
20 Oct 2006 Fixed
27 Jan 2007 Fixed
Description
When ASE is shutdown while RTDS is enabled in a session, server could potentially stacktrace. Does not consistently reproduce but more likely on HP platform.
Workaround Description
 None.



CR:444264
CR Number:   444264
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2007 Fixed
Description
Running Adaptive Server with an served license under a large workload may result in a stack trace.
Workaround Description
 Use a "unserved" license instead of "served" license.



CR:444292
CR Number:   444292
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 May 2008 Fixed
05 Oct 2007 Fixed
11 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
13 May 2008 Fixed
Description
The common name in ASE SSL Certificates is restricted in that it must match the name of

the dataserver.



CR:444343
CR Number:   444343
Product Name:   Adaptive Server Enterprise
Product Component:   sybconfig
Status:   Closed
OS:   Windows XP
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2007 Fixed
Description
create new server failed using syconfig after setting client charset to cp936 in locales.dat on Windows platform.
Workaround Description
 Change the client charset to iso_1 temporarily.



CR:444387
CR Number:   444387
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2006 Fixed
Description
A session running DBCC LOGTRANSFER may abnormally terminate with

the message "timeslice <value>, current process infected" followed

by a stack trace when ASE receives an interrupt (Control-C). The modules

"do_logtransfer" and "senddone" will be reported in the error log.



CR:444395
CR Number:   444395
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)
24 Jan 2007 Presently Not Targeted For Any Future Release Of This Product
24 Jan 2007 Presently Not Targeted For Any Future Release Of This Product
17 Jan 2007 Reservation Made
24 Jan 2007 Fixed
04 Nov 2007 Fixed
Description
If a block device is used as database device there is no warning either in errorlog or displayed to user on all platforms except on HP-UX, NT, Linux.



CR:444474
CR Number:   444474
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2006 Fixed
09 Aug 2007 Fixed
Description
Adaptive Server ignores 'authenticate with' semantics when user attempts a kerberos login.
Workaround Description
 n/a



CR:444489
CR Number:   444489
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2006 Fixed
12 Feb 2007 Fixed
Description
Lava operators that use a work table as backing store may loop endlessly

if a CTRL-C is issued while accessing the table. A merge-join with a very large

number of duplicate join keys in the inner stream is the mostly likely scenario

where this would occur. In the merge-join case, there is no way to kill

the looping session.





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