远程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:452368
CR Number:   452368
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
Max and min vector aggregation can result in sigsegv when operate on unichar and univarchar

columns.
Workaround Description
 Use traceflag 450 to force old-school grouping algorithms.



CR:452430
CR Number:   452430
Product Name:   Adaptive Server Generic Docs
Product Component:   Utility Guide
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2009 Added to user documentation
Description
Need to document maximum batch size for bcp. Maximum batch size is 65536.



CR:452442
CR Number:   452442
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2007 Fixed
18 Apr 2007 Fixed
30 Apr 2007 Fixed
Description
OR-clauses may not be evaluated if the query qualification references a column with the decrypt_default attribute. In SQL statements containing qualifications of the type WHERE dd_col = <value> OR non_dd_col = <value>, where dd_col is an encrypted column with the decrypt_default attribute and non_dd_col is a column without the decrypt_default attribute, the WHERE clause will disqualify all rows if the user executing the query does not have decrypt permission on dd_col.



CR:452482
CR Number:   452482
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2007 Fixed
17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Encryption Column feature is now available on linuxamd64 platform.



CR:452493
CR Number:   452493
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 May 2007 Fixed
Description
In rare circumstances, a spid waiting for reception of a JMS message may generate a memory

leak if it is interrupted by either a kill operation or reception of an ATTENTION sent by

the client application.



CR:452558
CR Number:   452558
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2007 Fixed
11 Jan 2007 Fixed
10 Jan 2007 Fixed
11 Jan 2007 Fixed
Description
Update the bundled JRE release to address the following issues:

1) The implementation of RSA signature verification in SSL/TLS, or other application scenarios, may incorrectly verify forged signatures leading to security vulnerability. See http://www.sybase.com/detail?id=1047991 for more details.

2) U.S. Daylight Saving Time Changes in 2007, see http://www.sybase.com/detail?id=1048699 for more details.



CR:452610
CR Number:   452610
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)
15 Jan 2007 Fixed
17 Jan 2007 Fixed
Description
The builtin function object_name() incorrectly returns NULL for any master-only system table in a database other than 'master', that has been loaded with a database dump of the master database.



CR:452658
CR Number:   452658
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2007 Fixed
Description
In rare circumstances, deadlock may occur on updating sysqueryplans after 'enable metrics capture' set to 1



CR:452731
CR Number:   452731
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2007 Fixed
15 Mar 2007 Fixed
11 Jun 2007 Fixed
Description
Added support of gbpinyin and gbpinyinnocs sortorders for Chinese character sets EUCGB, CP936, GB18030 and UTF-8. For existing installation, please run select sortkey(null, 'all') to populate syscharsets table with the new sortorders. And run sp_helpsort to get the new sortorder id.



CR:452735
CR Number:   452735
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)
10 May 2007 Fixed
13 Mar 2008 Not a Bug
13 Mar 2008 Not a Bug
Description
With traceflag 1649 active, ASE fails to initialize devices (like tmpfs) which does not support KAIO. Also databases on these devices (created before using traceflag 1649) fails to come online with error 823.
Workaround Description
 Do not use KAIO (i.e. traceflag 1649).



CR:452764
CR Number:   452764
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)
11 Jan 2007 Fixed
Description
Sybase Central sorts columns incorrectly should be able to sort by syscolumns.colid

so that the user can sort the columns in the same order as they were created.



CR:452782
CR Number:   452782
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)
20 Mar 2007 Fixed
20 Mar 2008 Presently Not Targeted For Any Future Release Of This Product
Description
If a Kerberos login attempt blocks during security session establishment reading the security opaque token from the client, it can hold an engine-wide security semaphore effectively blocking all other Kerberos login attempts. A new trace flag 7850 is added to timeout security connections if no security opaque token is received from client in 60 seconds.



CR:452801
CR Number:   452801
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)
24 Jan 2007 Fixed
Description
Stacktrace in RcToAndOrTree() could happen when a column is

compared with a scalar aggregate result under an OR predicate

and the same column appears under the OR predicate

multiple times. For example,

(A >= (select min(A) from t2) or A >= (select min(A) from t3)).



CR:452819
CR Number:   452819
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)
22 Jan 2007 Fixed
25 Jan 2007 Fixed
Description
When the jconnect and ctlib send a varchar longer than 255 bytes,in some cases it could cause stacktrace in memalloc() with 702 error since it requests 2147483647 bytes memory.



CR:452850
CR Number:   452850
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)
02 Feb 2007 Fixed
Description
Synchronize the new options "expire login passwords", "expire role passwords", "expire stale login passwords" and "expire stale role passwords" added to sp_passwordpolicy on companion server.



CR:452998
CR Number:   452998
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2007 Fixed
Description
Server status was checked periodically even though user unchecked the plug-in setting. This has been fixed.



CR:453005
CR Number:   453005
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)
07 May 2007 Not reproducible with latest version of the product available as of Resolution Date
07 May 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
ASE sends corrupt TDS converting to utf8 characters to jConnect clients causing the client to exit with error:

java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0EM: End of data.
Workaround Description
 Use convert(varchar(), col).

This stops ASE sending TDS_LONGCHAR type and the problem does not occur.



CR:453021
CR Number:   453021
Product Name:   Adaptive Server Enterprise
Product Component:   sql
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.2 13 Apr 2007 Fixed
Description
The missing sample directories (JavaXml, esp, histsrvr, messaging, server, and sybmigrate) have been added back into ASE 15.0.2.



CR:453032
CR Number:   453032
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)
05 Nov 2008 Third Party Problem
05 Nov 2008 Third Party Problem
Description
Calling a stored procedure residing in IQ from ASE via rpc parameter names are ignored, they are taken as positonal parameters.
Workaround Description
 Fill up all arguments in the rpc call.

i.e.

exec iqw...maxs_test_p @blah1 = 'One', @blah2 = '', @blah3 = '', @blah4 = 'Four'



CR:453037
CR Number:   453037
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2007 Fixed
Description
The spelling of sybprocs in message Building sysprocs device and sybsystemprocs database .... sybprocs device and sybsystemprocs database created is not correct, it should be sysprocs.



CR:453041
CR Number:   453041
Product Name:   Sybase ETL
Product Component:   other
Status:   Closed
OS:   all
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2008 Fixed
Description
Problem:

ETL does not allow multi-byte characters to be used in the meta-data

Resolution:

The ETL product has been modified to handle multi-byte meta-data.



CR:453088
CR Number:   453088
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 02 Feb 2007 Fixed
Description
In some exception case, print SQLTEXT could stacktrace from terminate_process().



CR:453103
CR Number:   453103
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)
31 Jan 2007 Fixed
15.0.3 28 Mar 2008 Fixed
Description
After primary service group fails over to secondary node, the primary HAase resource cannot go offline if the secondary ASE resource is already offline. The failure to go offline properly may also prevent primary HAase resource from going online on secondary node later even if primary ASE resource is brought back online.
Workaround Description
 - manually set the Cmpstate to 0:



ilk_db2# haconf -makerw

ilk_db2# hares -modify sybaseDB1 Cmpstate 0

ilk_db2# haconf -dump 杕akero



- wait for sybaseDB1 to become offline



- manually re-set the Cmpstate to 1



ilk_db2# haconf -makerw

ilk_db2# hares -modify sybaseDB1 Cmpstate 1

ilk_db2# haconf -dump 杕akero



- wait for sybaseDB1 to become online





After this exercise it looked normal again (sybaseDB1 being online on Node 2). We then performed a failback which worked without any problems.



CR:453216
CR Number:   453216
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2009 Fixed
Description
When the Windows eventlog is full and cannot be written, ASE repeatedly issues the warning message that the write to the event log failed, it should still issue the message but only at intervals.
Workaround Description
 reset the windows event log to either a larger size, to overwrite old events as needed, or both



CR:453218
CR Number:   453218
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)
17 Jan 2007 Fixed
09 Mar 2007 One-off Provided
13 Jun 2007 One-off Provided
Description
Improve login performance.



CR:453273
CR Number:   453273
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)
15 May 2007 Fixed
06 Sep 2007 Fixed
Description
In rare circumstances, concurrent dmls to very large data-only locked tables may cause index

corruption, resulting in 644 errors: "Index row entry for data row id <pageid, rnum> is missing from

index page <indexpage> of index id <indid> of table <tabid> in database <dbid>. Xactid is <xactid>.

Drop and re-create the index." Running online index reorg may cause self-deadlocks and 12311 errors,

and dbcc checktable may report corruption.



CR:453275
CR Number:   453275
Product Name:   Adaptive Server Generic Docs
Product Component:   XA Guide for CICS Encina and Tuxedo
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2007 Fixed
Description
Need to document new CIS server class RPCServer



CR:453288
CR Number:   453288
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 Feb 2007 Fixed
Description
[internal only] A customer's database was broken, contained index entries for sysencryptkeys but no object entry. This caused upgrade to fail in upgrade step 7 with no useful error.



CR:453339
CR Number:   453339
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2007 Fixed
06 Mar 2007 Fixed
Description
When ASE is booted with 16k page size, installmaster script may fail to complete with following message: "The current 'max memory' value '32768', is not sufficient to change the parameter 'allow updates to system tables' to '1'".
Workaround Description
 Value of "max memory" of cfg file is rewritten to "45056."

But customer has to do all work manually.

16k server cannot be created using srvbuild.



CR:453367
CR Number:   453367
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)
02 May 2007 Fixed
01 May 2007 Not a Bug
Description
The query, "ALTER TABLE MODIFY <column_name> NULL ENCRYPT WITH <encr_key> DECRYPT_DEFAULT NULL", failed with an 13975 error message, "You may not declare a null-valued decrypt_default on column <column_name> because that column is not nullable".



CR:453374
CR Number:   453374
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 Jun 2008 Fixed
Description
Concurrent executions of pageinfo built-in give different kinds of errors and stacktraces, like Error 833, "Attempt to read logical page into a buffer, that is hashed".



CR:453380
CR Number:   453380
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)
06 Mar 2007 Fixed
Description
Feature Request: "maximum failed logins" set to '-1' increments syslogins.logincount on every login failure.



CR:453446
CR Number:   453446
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2007 Fixed
13 Feb 2007 Fixed
13 Feb 2007 Fixed
Description
XPserver sometimes fails to come up on 64bit platforms with the following error in the errorlog, "os_syscmd: system function returned error. OS error string: Bad address".



CR:453474
CR Number:   453474
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2007 Fixed
28 Feb 2007 Bundled Request
Description
sp_help is enhanced to display the decrypt_default information for all decrypt_defaults declared on a table. This information consists of the internal name of the decrypt_default.



CR:453503
CR Number:   453503
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2007 Fixed
Description
When different data type comparison is done, ase returns wrong data.



ex)



create table cr453503 (deccol decimal(6,2),sintcol int)

go

insert into cr453503 values (1, 1)

insert into cr453503 values (2, 2)

insert into cr453503 values (3, 3)

go

select * from cr453503 where ( sintcol = deccol ) and ( deccol is not null)



ase will return 0 row.
Workaround Description
 Please replace order of select column. decimal column is moved to back from the 2nd.



CR:453512
CR Number:   453512
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2007 Fixed
Description
When server's default sortorder is one of Unilib sortorders, and the statement

matches a char variable in the like clause against an unichar column, 2432 error

might be raised.



CR:453529
CR Number:   453529
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2007 Fixed
19 Nov 2007 Fixed
Description
On occasion, the alter table function raises an exception in adc__update_sysreferences() and getnext() when a column is dropped from the original table definition.
Workaround Description
 A work around would be to create a new table using select c1,c2,c3..into new_table from old_table, excluding the column(s) to be dropped and then when the new table has been created drop the old version and rename the modified version to the original name.

Don抰 forget to run sp_recompile on the new table afterwards.



CR:453530
CR Number:   453530
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 Apr 2007 One-off Provided
08 Jun 2007 One-off Provided
Description
Avoid certain deadlocks involving Sysobjects, Sysindexes, Syspartitions, and Systabstats when partitioning objects in parallel with other maintenance activities such as DROP index, CREATE index.



CR:453566
CR Number:   453566
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)
08 Feb 2007 Fixed
Description
Print option 1 to DBCC PAGE will now decode the TIPSA region of 1st

text/image pages, and will print out the data for all text and image

pages as a byte stream.



CR:453598
CR Number:   453598
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)
24 Jan 2007 Not a Bug
Description
sp_who output inconsistent with sysprocesses



CR:453604
CR Number:   453604
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.3 01 Aug 2008 Duplicate
Description
New options: "with skip_global_index_rebuild" is added to

drop partition



Syntax:

alter table table_name drop partition partition_name [with skip_global_index_rebuild]



* If "with skip_global_index_rebuild" is provided, the global index will NOT be

rebuild and the index of the table will be labeled as suspect.

** If "with skip_global_index_rebuild" is not provided, the global index will be rebuild.

This is the default value.



CR:453646
CR Number:   453646
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)
12 Feb 2007 Fixed
Description
Configuration parameter 'number of open partitions' uses the wrong message number for its help message: it uses 10410, but should use 14010.



CR:453742
CR Number:   453742
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)
09 Feb 2007 Fixed
05 Mar 2007 Presently Not Targeted For Any Future Release Of This Product
02 Mar 2007 Fixed
Description
ASE HA Failback fails with ServiceGuard A.11.17 but works on ServiceGuard A.11.16 and A.11.15. This is a compatibility issue with ServiceGuard A.11.17. ServiceGuard A.11.17 changes the message in its output from "cmhaltpkg : Completed successfully" to "cmhaltpkg: Completed successfully". A white space has been removed in the message between "cmhaltpkg" and ":" causing ASE HA Failback to fail.



CR:453759
CR Number:   453759
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2007 Fixed
27 Apr 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
The count distinct expression may not return the correct number of rows on ANSI join queries involving subquery and ANY expression.



CR:453794
CR Number:   453794
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 Mar 2007 Fixed
Description
Queries that eliminate partitions based a query predicate may chose a global non-clustered index scan that has a low data row cluster ratio over a table scan that would be more desirable due to partition elimination.



CR:453831
CR Number:   453831
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2007 Fixed
23 Jan 2007 Fixed
02 Feb 2007 Fixed
23 Feb 2005 Fixed
Description
A SELECT statement with a derived table that contains a UNION ALL of a proxy table and a local table results in a 207 error (Invalid column name) if the proxy table is before and the local table is after the UNION ALL.
Workaround Description
 1) Turn on traceflag 11275 to disable full-passthrough of statements referencing views.



2)



when defining the derived table using 'UNION ALL'

use proxy table after UNION ALL. So simply changing the table order will make it work properly.



SELECT EvalStdPrc

FROM ( SELECT EvalStdPrc

FROM IMMZ_IN_ITEM_D_STDPRC

WHERE ItemCd = ''



UNION ALL



SELECT ClsPrc

FROM CBBZ_STK_ITEM_DT

WHERE ItemCd = '' AND

JustDt = ''

) abc



CR:453837
CR Number:   453837
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.1 IP
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2007 Fixed
31 Jan 2007 Fixed
05 Feb 2007 Fixed
Description
Wrong results could be obtained when a view or derived table which contains a GROUP BY clause is used in a query on the inner side of an Outer Join and the query SELECT list contains complex expressions.



CR:453867
CR Number:   453867
Product Name:   Sybase ETL
Product Component:   GUI
Status:   Closed
OS:   Windows XP
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
4.2 04 Feb 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Problem: The uninstall script for the ETL Development product does not remove registry entries containing repository definition and general product configuration. This may be an issue when reinstalling the product, especially in a different directory structure on the same machine.



Resolution: Use the regedit application to remove the following keys:

If uninstalling Sybase ETL Development, remove

HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\sybetl



If uninstalling Sybase IQ ETL Development, remove

HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\iqetl
Workaround Description
 The Registry keys will not be deleted since they contain the Development configuration as well as the defined Repository connection details. We decided to document the Registry keys so that they can be manually deleted.



Manually delete these keys:

The following Registry folder is used for storing the preference keys

shown in the Preference window of the user interface:



Sybase ETL Development:

HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\sybetl



Sybase IQ ETL Development:

HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\iqetl



For storing the Repository connection details the following Registry folder

are used:



Sybase ETL Development:

HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\sybetl\connection



Sybase IQ ETL Development:

HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\iqetl\connection



CR:453881
CR Number:   453881
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Open
OS:   HP-UX
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow audit options to be available server-wide by default, one should have to set it for all user databases individually



CR:453904
CR Number:   453904
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2007 Fixed
Description
A process is abnormally terminated after an 1105 error occurs when creating a stored procedure in a database that has the "abort tran on log full" option set.
Workaround Description
 Turn "abort tran on log full" off for the database.



CR:453918
CR Number:   453918
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2007 Fixed
17 Dec 2008 Fixed
Description
dbcc checkcatalog raises a 7417 error when a 0 freepage threshold exists, even if the last chance threshold entry for logsegment is present in threshold cache.



CR:453947
CR Number:   453947
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)
24 Jan 2007 Not a Bug
Description
Surrogate pair characters such as U&'\D840\DC00' can't be inserted into unichar/univarchar/unitext columns using Unicode literals (U&).

Error 2433 will be raised with the message "Illegal byte sequence encountered in Unicode data.".



This behavior is expected.

ASE expects Unicode scalar values within the literal. Unicode scalar values include any unicode code point

except high-surrogate and low-surrogate code points.

So you need to specify Unicode scalar value U&'\+020000' instead of U&'\D840\DC00' in the sample case.



CR:453993
CR Number:   453993
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
12 Jun 2007 Fixed
Description
Query with derrived table expression having TSQL outer join operator *= may return incorrect result if the inner table joining column is also present in the select list of the main query.
Workaround Description
 Use ANSI OJ instead of TSQL *= expression.



CR:454022
CR Number:   454022
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)
27 Feb 2007 Fixed
13 Mar 2007 Fixed
Description
A 325 error, "Adaptive Server finds no legal query plan for this statement." may be reported with a SELECT query when the opportunistic distinct view option is enabled.
Workaround Description
 set opportunistic_distinct_view off

and then execute the sql



CR:454029
CR Number:   454029
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 Jan 2007 Fixed
30 Jan 2007 Fixed
Description
The message 'Could not execute login script for user <username>' will be incorrectly reported when the password has expired. In an HA environment, setting the password at the primary will fail to be replicated at the companion server with the same error message.



CR:454129
CR Number:   454129
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2008 Fixed
Description
User defined messages appear in master..monErrorlog always with ErrorNumber = 1 rather than the error number with which they have been defined. Severity is always shown as 0.
Workaround Description
 None available



CR:454137
CR Number:   454137
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)
26 Jan 2007 Fixed
26 Jan 2007 Fixed
Description
The messages for errors 15082 and 15084 respectively "There are <value> OAM entries with zero

used/unused page counts. Run DBCC <value> FIX on objid <value> indid <value>."

and "The OAM has no room for new inserts. Run DBCC <value> FIX on objid <value> indid <value>."

should not report "Run DBCC CHECKALLOC FIX" if DBCC CHECKALLOC was the command being executed,

since CHECKALLOC can only be executed at the database level. Instead the relevant command

that needs to be run later in order to correct this non severe problem will be reported,

either TABLEALLOC, INDEXALLOC or TEXTALLOC.



CR:454176
CR Number:   454176
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)
26 Jan 2007 Fixed
Description
If ASE 15.0.x is running using an installation that has not yet been upgraded from 12.0.x or before, and a user executes CREATE PROCEDURE in a database, then when upgrade tries to upgrade sysprocedures, ASE may produce messages warning about 'invalid column length', with associated stack traces.



CR:454215
CR Number:   454215
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)
15 Oct 2009 Fixed
Description
Disallow creation of 'dbo' login by customers



CR:454220
CR Number:   454220
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 to enhance dbcc checkstorage to validate index entries in parallel.



CR:454283
CR Number:   454283
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2007 Fixed
Description
The default stack size on AIX64 is increased from 96k to 104k.



CR:454369
CR Number:   454369
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2007 Workaround
20 Jun 2007 Fixed
20 Jun 2007 Fixed
20 Jun 2007 Fixed
Description
sybmigrate throws java.lang.NumberFormatException in com.sybase.sybmigration.AseUtils.getDbSizeInMb when attempting migration of a very large Database.



CR:454434
CR Number:   454434
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)
01 Feb 2007 Fixed
05 Feb 2007 Fixed
Description
System wide password expiration will be ignored and a user with an

expired password will be able to log into the server unless a password

expiration policy has been defined using the stored procedure

sp_passwordpolicy.
Workaround Description
 Define a password expiration policy using sp_passwordpolicy.



CR:454453
CR Number:   454453
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 Feb 2007 Bundled Request
Description
In Warm Standby Replication environments where 'master' database is replicated, call to the stored procedure sp_config_rep_agent to configure the replication agent in the database 'master' was not being replicated.



CR:454460
CR Number:   454460
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2007 Fixed
13 Feb 2007 Fixed
11 Mar 2008 Fixed
04 Nov 2008 Fixed
Description
Query executed from the trigger and referencing tables INSERTED or DELETED may fail

with errors if the optimizer decides to apply a strategy which is using a worktable

based on INSERTED or DELETED table.
Workaround Description
 Boot the server with -T328 to avoid reformatting.



CR:454493
CR Number:   454493
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2007 Consult Complete
Description
In rare circumstances, the system might hit the signal 11 in compare_value() when update statistics.



CR:454526
CR Number:   454526
Product Name:   Sybase ETL
Product Component:   ETL Connectivity
Status:   Closed
OS:   Windows 2003
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2007 Not a Bug
05 Jun 2007 Added to user documentation
Description
Problem:

Special characters in Sybase ETL installation paths.



Resolution:

Special characters in the installation path of Sybase ETL Development or Server may cause problems accessing databases.



For example, connecting to Oracle returns the following error when ETL is installed in a path containing parenthesis like "C:\Program Files (x86)\Sybase...":

ORA-12154: TNS:could not resolve the connect identifier specified



Sybase recommends using installation paths that contain only alphanumeric characters.



CR:454562
CR Number:   454562
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 Feb 2007 Fixed
16 Feb 2007 Fixed
05 Mar 2007 Fixed
05 Mar 2007 Fixed
Description
Turning off the direct i/o through DIRECTIO=false doesn't take effect even after restarting ASE if the device had the DIRECTIO option set to true before.
Workaround Description
 Reboot OS.



If you don't like to reboot, create a program calling directio(fd, DIRECTIO_OFF) and

run it on your devices in question.



========================================

#include <stdio.h>

#include <fcntl.h>

#include <sys/types.h>

#include <sys/fcntl.h>

#include <unistd.h>

#include <time.h>

#include <errno.h>



int main(int argc, char *argv[])

{

int fd;



if (argc != 2) {

printf("usage: %s filename\n", argv[0]);

exit(1);

}



fd = open(argv[1], O_RDWR);

if (fd < 0) {

printf("Can not open Write/Read file %s\n",argv[1]);

exit(2) ;

}



if (directio(fd, DIRECTIO_OFF) == -1) {

printf("Can not set DIRECT IO OFF on %s\n",argv[1]);

exit(3) ;

}



close(fd);



exit(0);

}

========================================



CR:454609
CR Number:   454609
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)
12.5.4 ESD#6 14 Feb 2007 Fixed
13 May 2008 Fixed
Description
Table scans on DATA_ONLY locked tables running at isolation level READ COMMITTED may sometimes fail to return qualifying rows if there are concurrent INSERTs/UPDATEs happening on the table.



CR:454677
CR Number:   454677
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)
01 Feb 2007 Fixed
Description
A SELECT query on a union-in-view with a large IN list (>40 elements in the IN list)

as part of the WHERE clause hits signal 11 in PeBasicPredicate*IsCorrelatedSarg().



CR:454790
CR Number:   454790
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)
31 Jan 2007 Fixed
Description
When a login password has expired in a High Availability (HA) environment

on both the master and companion servers, execution of sp_password silently

fails to change the password on the companion; the password change succeeds

only on the local server.



CR:454927
CR Number:   454927
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2007 Fixed
06 Nov 2007 Fixed
Description
Enable LDAP User Authentication feature on Windows X64 platform



CR:454928
CR Number:   454928
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2008 Fixed
08 Dec 2008 Fixed
08 Dec 2008 Fixed
09 Dec 2008 Fixed
Description
Enable Encryption Column feature on winx64 platform



CR:454952
CR Number:   454952
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)
05 Feb 2007 Fixed
Description
The command DBCC LISTOAM will incorrectly report the error 'Invalid Object Id <n>'

when the object is a master only system table.



CR:454960
CR Number:   454960
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   RH Linux
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2007 Fixed
Description
Creating an encryption key on platforms that don't support encrypted columns produces

a stack trace.



CR:455016
CR Number:   455016
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2007 Fixed
Description
Stacktrace could happen in CgpIndScan::_CgpIndSpecialOrPePredBmToScalar() if

an equijoin between two tables (such as t1.c1=t2.c1) under an OR predicate

is considered for the special OR processing on t1 and t2.c1 is also participating

in another TOP level equijoin predicate with t1. Here is an example:

"... where t2.c1=t1.c2 and (t1.c1=t2.c2 or t1.c1=t2.c1)"



CR:455038
CR Number:   455038
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)
09 Feb 2007 Fixed
26 Feb 2007 One-off Provided
Description
Enabling optgoal allrows_oltp incorrectly disables the optimizer from considering network latency when optimizing queries with proxy tables.



CR:455042
CR Number:   455042
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)
24 Apr 2007 Fixed
25 Apr 2007 Fixed
Description
Client connection which is bound to the LASTONLINE will hang when issuing the "sp_engine 'offline'" command.
Workaround Description
 Removing the execution class binding from the login/application/procedure will correct the problem.



CR:455100
CR Number:   455100
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
add BatchID field in table monProcessProcedures to improve sp_monitor procstack preformance.



CR:455102
CR Number:   455102
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)
15 Apr 2007 Fixed
08 Nov 2007 Fixed
18 Jun 2007 Fixed
02 Aug 2007 Fixed
04 Sep 2007 Fixed
12 Nov 2007 Fixed
Description
CIS does not forward the query if it contains the 'group by' clause without aggregration.
Workaround Description
 run dbcc cis(setcaps, <iq_server>, 112, 2) to change the group_by cap to TSQL.

reset this back to 4 after executing the query.



CR:455146
CR Number:   455146
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)
05 Feb 2007 Fixed
Description
Attempts to run dbcc report_al(db_name) encounter error 10334, state 80 (permission related internal error).



CR:455175
CR Number:   455175
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2007 Fixed
Description
explain more details in the doc related to unpartitioniong / partitioning



CR:455176
CR Number:   455176
Product Name:   Sybase ETL
Product Component:   ETL Connectivity
Status:   Closed
OS:   Windows 2000
Original Version:   4.2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2008 Fixed
Description
Problem:

Sybase native connectivity for Windows



Resolution:

The Sybase IQ 12.7 Windows PC client does not include Sybase native (Open Client) connectivity. Thus, to use Sybase native connectivity from ETL to Sybase IQ, the native libraries must be installed from another Sybase product. For example, the native libraries are available in the Sybase Software Development Kit (SDK), which is an installation option of the Windows Sybase IQ 12.7 server or as a separate product. Contact your Sybase Technical Support representative for information about the best way to obtain Sybase native connectivity for your site.



Note that the ETL products for Windows are 32-bit applications. However, they can run on Windows 64-bit platform. If the 64-bit Sybase IQ server were installed on the same machine and the installation included the SDK, the 32-bit libraries would also installed and could be used.



CR:455180
CR Number:   455180
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)
18 May 2007 Fixed
Description
When running ASE 15.0 on an installation that has not yet been upgraded from 12.5.x or before, #temp table creation can create a table with a name longer than is permitted by the current tempdb.dbo.sysobjects. Some stored procedures, such as sp_configure, can cause this to happen. When it happens, ASE will produce an error message and a stack trace saying that a column on disk has an invalid length.



CR:455195
CR Number:   455195
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)
26 Mar 2007 Fixed
06 Apr 2007 Presently Not Targeted For Any Future Release Of This Product
Description
The message "current process infected with 11" in the module

'HashBuf::HbBufSetRunInfo' together with a stack trace which

includes the modules 'LeHashPart::LePartGetConsumerId' and

LePipeRepart::LePipeWriteVtuple' may be reported in the

error log when a query involving more than 31 columns is

executed in parallel and "hash repartitioning" mechanism

was chosen.
Workaround Description
 Run the query in serial mode.



CR:455196
CR Number:   455196
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)
08 Mar 2007 Fixed
Description
RTDS licenses obtained from DI, that did not contain the PE=EE string, would not work when used with ASE EE.
Workaround Description
 None.



CR:455197
CR Number:   455197
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2007 Fixed
27 Mar 2007 Fixed
Description
If a compute clause's group-by list contains an expression and no rows

are returned for the query, then a SEGV or stack corruption could occur.



CR:455275
CR Number:   455275
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 Feb 2007 Fixed
27 Feb 2007 Fixed
Description
Under rare circumstances DBCC CHECKSTORAGE may detect non-existent 100018

errors when run on an archive database.



CR:455295
CR Number:   455295
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)
04 Mar 2007 Fixed
26 Mar 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
When table in IQ/ASA has name greater than 30 characters, creating proxy table in ASE that maps to it will fail with ASA Error -131: Syntax error near 'order' on line 1.



CR:455326
CR Number:   455326
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)
07 Feb 2007 Fixed
07 Feb 2007 Fixed
07 Feb 2007 Fixed
Description
The 110219 error log message has been reworded and now reads "Warning: There is no valid license for ASE_ASM and therefore the ASE_ASM feature has not been initialized".



CR:455413
CR Number:   455413
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2007 Fixed
03 Apr 2009 Fixed
Description
When parallelism is turned on, a query with several tables may cause a time slice error. This is because the optimizer has a large search space to traverse in the parallel mode and the timeout mechanism does not take that into account while comparing a large number of plan fragments.



CR:455435
CR Number:   455435
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 IP
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2007 Fixed
18 Feb 2007 Fixed
02 Mar 2007 Fixed
Description
Using the top clause in a select statement that involves a

union all in a view (or equivalent derived table) in the from

clause does not limit the size of the result set as expected.



CR:455481
CR Number:   455481
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)
12 Feb 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Customer wants the set ciphertext command to be fully supported



CR:455482
CR Number:   455482
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)
27 Sep 2009 Presently Not Targeted For Any Future Release Of This Product
Description
set ciphertext command does not propagate to stored procedures
Workaround Description
 upgrade to ASE 15



CR:455567
CR Number:   455567
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2007 Fixed
11 Feb 2007 Fixed
Description
SQL queries having predicates of the form col = isnull(result of some scalar aggregation, or the result of a subquery), is not considered as a SARGable predicate, which means that such predicates cannot be used for index scans. This causes massive performance problems.



CR:455570
CR Number:   455570
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)
23 Feb 2007 Fixed
Description
For DBCC CHECKCATALOG, if the partition id order in the tree from sysprocedures is different from the partition id order in the syscomments, the 15911 error will be raised.



CR:455601
CR Number:   455601
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2007 Fixed
28 Feb 2007 Presently Not Targeted For Any Future Release Of This Product
12 Mar 2007 Fixed
Description
Error 644 "Index row entry for data row id (<value>, <value>) is missing from index page <value>

of index id <value> of table '<value>' in database '<value'..." may be reported in module

"del_rownotfound" with a stack trace in the error log when an UPDATE command is run

on a Data Only Locked table and the scan index being used by ASE to perform the update

has one or more of its columns affected by the given update.



CR:455611
CR Number:   455611
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
15 Feb 2007 Fixed
Description
HAaseAgent for VCS on Solaris and Linux executes one VCS system command with wrong syntax:

hagrp -display <service-group-name> attribute SystemList

The above command with correct syntax should be:

hagrp -display <serveric-group-name> -attribute SystemList



The wrong syntax will not cause any failure in HAaseAgent or HA function except that VCS engine may log some error message to its log.



CR:455671
CR Number:   455671
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)
08 Feb 2007 Fixed
14 May 2007 One-off Provided
Description
Multiple connections from another 15.0.1 ASE are left allocated.
Workaround Description
 set 'cis idle connection timeout' to zero



CR:455674
CR Number:   455674
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)
15 Feb 2007 Fixed
29 Jun 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Under very rare circumstances, some 821 or 813 errors may be raised for

a very busy multi-engine ASE having a buffer cache shortage.





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