远程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:455698
CR Number:   455698
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2007 Fixed
Description
Previously when ASE Plug-in connected to a server, it always restored/opened the last-opened folder. Users now have the option to turn off this behavior by unchecking "Open last-visited folder after connecting to server" check box by selecting Tools -> Adaptive Server Enterprise -> Preferences.



CR:455707
CR Number:   455707
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2007 Fixed
Description
Previously a server's preferences (such as number of lines of server log to retrieve) were lost when the server was cut and pasted. Now the preferences for the server are preserved when the server is cut.



CR:455721
CR Number:   455721
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T: Basics
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2009 Added to user documentation
Description
Need information update on the tempdb and indexing on Performance and Tuning Guide



CR:455779
CR Number:   455779
Product Name:   Sybase ETL
Product Component:   pEngine
Status:   Closed
OS:   all
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2007 Added to user documentation
Description
Problem:

Project execution might become unresponsive when database runs out of space.



Resolution:

When a database involved in a data transfer runs out of space, the execution of a project might stop responding. This is because the database driver does not return with an error message but waits until space is available to continue. Please ensure that sufficient space is available before running a project or job.



CR:455781
CR Number:   455781
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Windows W2k
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2009 Fixed
01 Sep 2009 Fixed
04 Sep 2009 Fixed
Description
The Historical Server reports an incorrect time value on the windows platforms.
Workaround Description
 None known.



CR:455812
CR Number:   455812
Product Name:   Adaptive Server Generic Docs
Product Component:   EFTS SDS and SFTS SDS
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
index name in sp_create_text_index should be from local db only, documentation needs to be corrected to reflect that.



CR:455819
CR Number:   455819
Product Name:   Adaptive Server Enterprise
Product Component:   FTS SDS
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2007 Third Party Problem
Description
FTS core dumps when creating index with universal style



CR:455826
CR Number:   455826
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
22 Aug 2007 Fixed
Description
If a kerberos login gets a timeslice error during security session establishment,

the engine-wide semaphore is not released, causing all the other kerberos logins on that engine to block.



CR:455839
CR Number:   455839
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)
06 Aug 2007 Fixed
18 Sep 2007 Fixed
14 Aug 2007 One-off Provided
Description
Concurrency problems are found when using MIT Kerberos client libraries version 1.3.x and 1.4.x

or earlier, causing ASE crash or blocking all Kerberos logins when there are concurrent Kerberos

authentication attempts.



ASE now supports concurrent Kerberos authentication requests by default.

Trace flag 7844 is no longer needed and can be used if concurrent Kerberos authentications is not required.



CR:455842
CR Number:   455842
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2007 Fixed
Description
Previously when you sort a table column of data type "binary" on Data panel, a ClassCastException stack trace would occur. This has been fixed.



CR:455901
CR Number:   455901
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)
12 Mar 2007 Not reproducible with latest version of the product available as of Resolution Date
16 Apr 2007 Fixed
18 Apr 2007 Fixed
Description
Entities in xml documents are not handled correctly on AIX FBO builds.



CR:456048
CR Number:   456048
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2007 Fixed
13 Oct 2007 Fixed
Description
When a sort node is used for a merge join, and an ORDER BY request is made by the query, that uses descending columns, then there is a possibility that the ORDER BY on those columns would be ignored, and only the ascending columns in the ORDER BY would be respected. This problem occurs when an attempt would be made to use the ordering available from the sort node, to also be used by the ORDER BY so that an extra sort node is avoided.
Workaround Description
 Typically turning off merge_join for this query could be used as a workaround



CR:456052
CR Number:   456052
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2007 Fixed
Description
Materialized status of a computed column cannot be altered from column properties in Sybase Central ASE Plug-in.



CR:456061
CR Number:   456061
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2007 Fixed
Description
When modifying or adding a buffer pool of a data cache, in Sybase Central ASE Plug-in, provide an option to set the "local async prefetch limit" for the buffer pool.
Workaround Description
 Manually execute sp_poolconfig named_cache, "mem size of pool", "local async prefetch limit=percentage" from isql.



CR:456080
CR Number:   456080
Product Name:   Sybase ETL
Product Component:   pEngine
Status:   Closed
OS:   Unknown
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
4.5 05 Jun 2007 Added to user documentation
23 Jun 2008 Fixed
Description
Problem:

When using the [CIFS] section of GridNode.ini to store the user and password for connect to a file server, projects that should store Textfiles on a UNIX server fail with the message "tree connect failed: NT_STATUS_ACCESS_DENIED".



Resolution:

On UNIX, installations of Sybase ETL Server ini file settings are not read by the GridNode application unless you have a GridNode.ini in place.

To specify settings for the GridNode application you need to: 1. Make a copy of the Default.ini file named GridNode.ini in the etc subdirectory of your installation path. 2. Specify general settings (to be shared by all applications) in Default.ini. 3. Specify exclusive settings for the GridNode application in GridNode.ini. 4. Disable (remove or comment) the keys for general settings in GridNode.ini.
Workaround Description
 Put all the settings in the Default.ini file instead of the GridNode.ini file.



CR:456094
CR Number:   456094
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2009 Fixed
25 Mar 2010 Fixed
Description
DBISQL connects to wrong host in interfaces file when using standby addressing



CR:456145
CR Number:   456145
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)
28 Mar 2007 Fixed
Description
Wrong result could happen when "FOR BROWSE" mode is used and the query

has an ORDER BY on some expression.



CR:456150
CR Number:   456150
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   RH Linux
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 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:456156
CR Number:   456156
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 Jun 2007 Fixed
Description
Enable "for xml all" within message payload for ASE messaging sending/publishing messages.



CR:456218
CR Number:   456218
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)
05 Mar 2007 Fixed
Description
SELECT INTO statements that source a union view that references a virtual

computed column will generate recompilation errors. In the case of a batch,

a 225 error is generated:



Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during

query optimization.



CR:456223
CR Number:   456223
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)
28 Mar 2007 Fixed
Description
The message "current process infected with 11" together with a stack trace may be reported in the

error log if a GROUP BY used on a comupted column with sum and count aggregates including a distinct

clause.



CR:456225
CR Number:   456225
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2007 Duplicate
Description
Since CMC is no longer being supported by Microsoft the customer needs MAPI style added to the server. Prelimanary code that does this was given to the customer but it is not in the code line and I was unable to get it compiled on my server under 12.5.x.



CR:456260
CR Number:   456260
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)
22 Mar 2007 Fixed
08 Mar 2007 Fixed
Description
When using RTDS (version 4.0 and before) with MQ, messages larger than 1MB cannot be sent or received.
Workaround Description
 Customer can try to break up each large message into chunks smaller than 1MB and use grouping functionality of MQ.



CR:456314
CR Number:   456314
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)
05 Mar 2007 Fixed
06 Mar 2007 Fixed
Description
Wrong result could happen if the query has an equality predicate between

two expressions (expr1=expr2) and through some other equijoin predicate(s),

all the columns referenced in the predicate can be completely mapped to

one joining table and at the same time also completely mapped to another

joining table. For example, "t1.c1+2=t2.c1*2 and t1.c1=t2.c1".



CR:456393
CR Number:   456393
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)
01 Mar 2007 Fixed
Description
Query with having clause with a subquery and correlated aggregate will not

evaluate correctly having clause if it uses IS NULL operator.



CR:456429
CR Number:   456429
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
UPDATE STATISTICS should be able to sample index columns



CR:456431
CR Number:   456431
Product Name:   Sybase ETL
Product Component:   GUI
Status:   Closed
OS:   Windows 2003
Original Version:   4.2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2008 Fixed
Description
Problem:

File Content display in Text Data Provider.



Resolution:

When entering the configuration window of a text provider component, the file content is read with the current (default is ISO-8859-1) encoding setting. It is not reread when a different encoding is selected. The preview section of the configuration window displays data correctly (according to the current settings) and the functionality of the component is not affected.



To read and display the file content with a specific encoding, either

select the encoding in the configuration window and click Save

or select the encoding in the Property section

and reopen the configuration window.



CR:456498
CR Number:   456498
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2007 Fixed
29 Aug 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
A 804 error reading "Unable to find buffer '<Buffer Address>' from cache 'Named Cache' holding logical page '<Page Id>' in sdes 'Sdes Address' kept buffer pool for object '<Object Name>', together with a stack trace showing modules 'pg_getdatapage_forinsert' and 'pg_release_alloc_page' may be raised while many concurrent sessions are INSERTing into the same sliced DOL table having a placement index.



CR:456532
CR Number:   456532
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 Mar 2007 Fixed
20 Mar 2007 Fixed
Description
On Solaris, if ASE is configured for High Availability with SunCluster, the HA agent ase_monitor may print misleading error messages on every thorough probe, though the error occured only once.
Target Version
 15.0.2
Workaround Description
 Restart monitoring.



CR:456534
CR Number:   456534
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2007 Fixed
Description
When dataserver of sjis and backupserver of eucjis are used, the dump command outputs the error of open server.



Open Server Error: 16368.10.0.0 srv_senddone(): A message was initialized, but not completed.
Workaround Description
 Specifies the language of backupserver to be a RUN server file.



-Ljapanese \

-Jsjis \



CR:456555
CR Number:   456555
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2007 Duplicate
Description
in some circumstances sp_monitorconfig may report the max used value greater than the configured value for the configuration parameters 'number of sort buffers' and 'procedure cache size'
Workaround Description
 N/A



CR:456569
CR Number:   456569
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2007 Fixed
24 Apr 2007 Fixed
Description
Some ALTER TABLE ADD <default> with MODIFY and/or DROP commands may fail with Msg 11050 in a HA environment.
Workaround Description
 The default clause is responsible for the error, so do not use both add column with a default and

modify or drop in the same statement. Otherwise do not use defaults



[1] alter table add columns with defaults in a separate statement from the modify and drop columns:

1> alter table LOGDMIT

2> ADD PARENTCODE VARCHAR(01) DEFAULT '0' NOT NULL

3> ADD PARENTORDERCODE VARCHAR(10) NULL

4> ADD SONTRANSQTY NUMERIC(4, 0) DEFAULT 0 NOT NULL

Warning: Row size (7573 bytes) could exceed row size limit, which is 4012

bytes.



OR



[2] do not use defaults

1> alter table LOGDMIT

2> ADD PARENTCODE VARCHAR(01) null

3> ADD PARENTORDERCODE VARCHAR(10) NULL

4> ADD SONTRANSQTY NUMERIC(4, 0) null

5> MODIFY TDMMEMO1 VARCHAR(300)

6> MODIFY TDMMEMO2 VARCHAR(300)

7> MODIFY TDMMEMO3 VARCHAR(300)

8> MODIFY CHINATTENTION VARCHAR(200)

9> MODIFY ENGATTENTION VARCHAR(200)

10> MODIFY DRUGEXTERIOR VARCHAR(100)

11> MODIFY DRUGENGEXTERIOR VARCHAR(100)

12> DROP DRUGINTERACTIONMEMO

13> DROP DRUGMECHANISM

14> DROP PHARMACOKINETICMEMO

15> DROP MONITORTARGET

16> DROP SUCKLEANDPREGNANTMEMO

17> DROP LIVERMEMO

18> DROP KIDNEYMEMO

19> DROP AGEDDOSEADJUST

20> DROP INFANTDOSEADJUST

21> DROP CONTRAINDICATION

22> DROP PTEDUCATION

23> DROP POISONSOLVEWAY

24> DROP COMMONDOSE

25> DROP COMMONFREQ

26> DROP SUBSTITUTEMEMO

27> DROP DANGERDRUGINFO

28> DROP THINNER

29> DROP DILUTEWAY

30> DROP SPEEDANDPATH

31> DROP STABLEIMFO

32> DROP PURPOSE

33> DROP USEWAY

34> DROP FORGETSOLVEWAY

35> DROP ATTENTION2

36> DROP POSSIBLESIDEEFFECT

37> DROP PRESERVEWAY

(0 rows affected)

[93] %



CR:456575
CR Number:   456575
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 Mar 2007 Fixed
Description
Inserting values into columns with defaults may get Msg 233 on a HA secondary server.



CR:456598
CR Number:   456598
Product Name:   Sybase ETL
Product Component:   Installer
Status:   Closed
OS:   AIX
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
4.2.2 25 Sep 2007 Fixed
Description
Problem: ETL Server installs successfully, but the following is reported during the install: "Space needed for installation: 0 KB"



Resolution: The install scripts were changed to display the correct numbers.



CR:456683
CR Number:   456683
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)
27 Mar 2007 Fixed
25 Feb 2009 Fixed
Description
On platforms supporting directio, make directio as the default option for disk init/ reinit instead of dsync.



CR:456736
CR Number:   456736
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)
15 May 2008 Fixed
28 Jul 2008 Fixed
Description
The DBCC DBCACHEREMOVE command is allowed to uncache a user defined temporary

database from cache.



CR:456747
CR Number:   456747
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2007 Fixed
Description
For table with APL clustered index, sometimes a table scan is incorrectly

reported as an index scan in diagnostics (such as showplan) when there

is some predicate on the index column but not on the leading column(s).



CR:456802
CR Number:   456802
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)
01 Mar 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
Previously in 15.0 or 15.0.1 ASE Plug-in, table Data panel would display null values after sorting a column multiple times. This has been fixed in 15.0.2 ASE Plug-in.



CR:456828
CR Number:   456828
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)
07 Mar 2007 Fixed
06 Mar 2007 Reservation Made
09 Mar 2007 Fixed
Description
A new configuration parameter "enable merge join" is added to enable/disable merge_join at server level. This configuration can be set to

0 - unset merge_join at server level.

1 - set merge_join at server level.

2 - set merge_join to default value (as per curent optgoal) at server level.



CR:458666
CR Number:   458666
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)
10 Jul 2008 Bundled Request
Description
Previously after changing the password for a login with an expired password, ASE Plug-in still remembered the old password. Now ASE Plug-in will remember the new password.



CR:460673
CR Number:   460673
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)
16 Mar 2007 Fixed
24 Mar 2007 Fixed
Description
Infinite 9835 errors raised by a parallel execution family after segmentation fault in HashBuf::HbBufSetRunInfo.



CR:460687
CR Number:   460687
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2007 Fixed
28 Jun 2007 Fixed
Description
The error 9947, "An attempt to allocate memory failed due to insufficient ASE memory." can be raised by DBCC CHECKVERIFY, if the number of faults found by DBCC CHECKSTORAGE is very big.



CR:460775
CR Number:   460775
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)
04 Mar 2007 Fixed
01 Mar 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Enable LDAP User Authentication feature on Linux Opteron 64bit platform.



CR:460787
CR Number:   460787
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1 27 Feb 2007 Fixed
15.0.1 01 Mar 2007 Fixed
Description
This CR fixed the statistic failure while upgrading a database from pre-15.0 server to 15.0.1 server on winx64 platform.



CR:460805
CR Number:   460805
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2008 Fixed
Description
Before you add or modify or drop columns on a table, you should run sp_depends to check

if the current database has any stored procedures depending on the table you are changing.

You might want to drop and re-create the stored procedures if necessary after changing table schema.



CR:460825
CR Number:   460825
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 Mar 2007 Fixed
11 Mar 2008 Fixed
Description
Execute immediate queries referencing outer scope variables may sometimes fail with syntax error about non declared local variables.



CR:460847
CR Number:   460847
Product Name:   Adaptive Server Enterprise
Product Component:   SDBE
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2007 Fixed
Description
When Tools->Performance Monitor is selected within Database Expert an additional ASE_SDBE is requested. When using a served license there will be insufficient quantity and Performance Monitor will not start. Use of unserved licenses works around this problem as they have unlimited quantity for a specific host so will allow Performance Monitor to start correctly.
Target Version
 To Be Determined
Workaround Description
 Use unserved licenses.



CR:460869
CR Number:   460869
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2010 Insufficient priority to fix
22 Jan 2008 Fixed
Description
SET PROC_OUTPUT_PARAMS OFF option incorrectly suppresses the return of the

result value via the output parameters for the outermost procedure call.

When this option is OFF, only the return of the output parameters to the

client stream should be suppressed, but the output @variable should continue

to return the result value to the application.



CR:460898
CR Number:   460898
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)
16 Mar 2007 Fixed
Description
In rare circumstances, stack trace which includes the modules 'traceassert' and 'dynmp__calc_objpoolsize' may be reported in the error log when running Diagnostic Server with large values of some configuration parameters.



CR:460902
CR Number:   460902
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2007 Fixed
Description
When a user changes the wash size of the smaller pool "sp_poolconfig ''default data cache'', ''2K'', ''wash=4444K''", though the wash size is changed in the sysconfigures table, it is not being written into the ".cfg" file. As a result of this, after reboot of the server, the wash size of ''2K'' pool is reverted back to DEFAULT



CR:460907
CR Number:   460907
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2007 Fixed
13 Jun 2007 One-off Provided
08 Jul 2008 Fixed
Description
Under certain circumstances, when ASE is using Java(enable java = 1) with multiple engines online, server may crash with signal 11 in kbfalloc routine.



CR:460911
CR Number:   460911
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)
11 Mar 2007 Presently Not Targeted For Any Future Release Of This Product
Description
feature request to have a timeout option to resolve hangs from wait on an I/O which never completes



CR:460936
CR Number:   460936
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2007 Fixed
06 Mar 2007 One-off Provided
09 Jul 2007 Fixed
09 Jul 2007 Fixed
Description
Installer is not able to find JVM on HP-UX 11.31



CR:461019
CR Number:   461019
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)
28 Feb 2007 Fixed
Description
Migration tool support for new encrypted column features.



CR:461066
CR Number:   461066
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2007 Fixed
03 Apr 2007 Fixed
14 Mar 2008 Not a Bug
Description
Parallel query execution with runtime adjustment to serial execution may return incorrect results or fail with different unexpected errors if there are some DOL tables in the query and some expressions with result size bigger than 255 characters.



CR:461074
CR Number:   461074
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 Jan 2008 Fixed
30 Jan 2008 Fixed
30 Jan 2008 Fixed
31 Jan 2008 Fixed
Description
ASE may return a wrong result set when a query is run at transaction isolation level 0

(dirty reads) on an All Pages Locked table and a covered non-clustered index scan is

chosen by the optimizer as reported by the set showplan option with message

"Index contains all needed columns. Base table will not be read."
Workaround Description
 To avoid index covering, add a column which is not an index key column to the SELECT list.

But this can cause the increase of logical and physical I/Os and could affect performance.

Alternatively, change the table format from APL to DOL since I have been unable (psalding)

to reproduce the problem when using locking scheme 'lock datarows'.



CR:461095
CR Number:   461095
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 Mar 2007 Fixed
Description
keycustodian is allowed to set the system encryption password.



CR:461097
CR Number:   461097
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)
05 Mar 2007 Fixed
08 Mar 2007 Fixed
Description
The uid of sysquerymetrics will be 0 when all table names in a query, which are not qualified by user name, are owned by the dbo. This change can be disabled by turning on Traceflag 15361.



CR:461165
CR Number:   461165
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)
28 Feb 2007 Bundled Request
Description
Asynchronous pre-fetch of data and index pages is incorrectly disabled during the recovery of a database or when a transaction is rolled back.
Workaround Description
 N/A



CR:461167
CR Number:   461167
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)
05 Mar 2007 Fixed
14 Mar 2007 Fixed
Description
When OMNI tables are involved and no parallel is turned on, ASE aborts queries saying that there is insufficient threads configured.



CR:461169
CR Number:   461169
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)
12 Mar 2007 Fixed
27 Mar 2007 Fixed
02 Nov 2007 Fixed
Description
A 511 error "Attempt to update or insert row failed because resultant row of size <num> bytes

is larger than the maximum size (1964 bytes) allowed for this table." may be reported during

upgrade to 15*, during "upgrade step [ID 60], alter table (table sysstatistics)" when there are small histogram boundary values at the end of a sysstatistics row.
Workaround Description
 delete from sysstatistics, then retry the upgrade.



CR:461175
CR Number:   461175
Product Name:   Adaptive Server Generic Docs
Product Component:   Adaptive Server Troubleshooting Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2008 Added to user documentation
Description
error 701 returns severity 17 and not 19 as is documented in TSG



CR:461196
CR Number:   461196
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)
08 Mar 2007 Fixed
13 Mar 2007 Fixed
29 Oct 2008 Fixed
08 May 2007 Fixed
14 May 2007 Fixed
16 Jun 2008 Fixed
29 Apr 2008 Fixed
Description
Update sp_lmconfig to allow the following license types to be specified: LP, LF, LR, LV



CR:461201
CR Number:   461201
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)
28 Mar 2008 Fixed
14 Jan 2008 Fixed
14 Jan 2008 Reservation Made
Description
Poll for all completed ct-lib I/Os issued from the engine every time the scheduler checks for I/O completion. Also, the engine does not relinquish CPU to the OS if there is any pending ct-lib I/O from that engine.



CR:461305
CR Number:   461305
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)
03 Mar 2007 Fixed
13 Mar 2007 Fixed
14 Mar 2007 Fixed
Description
A SELECT query with an OR CLAUSE may not return the correct results.



CR:461310
CR Number:   461310
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2007 Fixed
20 Mar 2007 Fixed
18 Apr 2007 One-off Provided
11 Apr 2007 Fixed
Description
Under random circumstances, the error "Cannot create msgqueue Xnnnnnnnn

because it already exists" could be raised by the backup server. The

chances are higher when there are several dumps running simultaneously.



CR:461319
CR Number:   461319
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)
02 Mar 2007 Fixed
05 Mar 2007 Fixed
18 May 2007 Fixed
Description
A distinct order-by query in a non-binary sortorder server may

return too few rows. This can happen if the sum of unique distinct

(from the select-list) and order-by columns is less than 32 and there are

no character columns in the select list that are not also in the

order-by list. Taking the following query as an example:



select distinct a.a, a.c from A a, B b

where a.b=b.b order by c



In this case, "c" is the only character column in select-list and

it appears in the order-by list. So, the bug occurs. If "a" was a

character column, then the problem would not occur.
Workaround Description
 If the query can be modified, add any character-type column to the

distinct's select-list that is not already in the order-by list and

will have no impact on the distinct rows returned. A dummy column

with any literal value will work.



CR:461343
CR Number:   461343
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)
14 Oct 2008 Fixed
01 Oct 2008 Fixed
15 Oct 2008 Reservation Made
15 Oct 2008 Fixed
15 Oct 2008 Fixed
16 Oct 2008 Fixed
Description
No support for manual migration of connections. The command can be used to migrate a connection into a logical cluster or instance for which the application or login is not bound.



CR:461349
CR Number:   461349
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2007 Added to user documentation
Description
Description of the following manual is wrong.



Adaptive Server Enterprise 15.0

System Administration Guide: Volume 1

Chapter 5: Setting Configuration Parameters



procedure cache size

The default value of procedure cache size of ASE 15.0.x is 7000.



CR:461414
CR Number:   461414
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2007 Fixed
Description
sp_deviceattr doesn't allow setting of the directio flag on AIX
Workaround Description
 manually update spt_values:



update spt_values set low=1 where name='directio'



CR:461451
CR Number:   461451
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2009 Fixed
Description
Improve the clarity of the description for the IndexID column in monCachedObjects table.



CR:461453
CR Number:   461453
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2008 Fixed
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.



Given this qualifier, the command marks any participating global index as 'suspect',

rather than rebuilding the index as would normally be done.

This can make the command complete more quickly, at the expense

of making an index unusable. To be made usable again, a suspect

index must be dropped and recreated.



CR:461461
CR Number:   461461
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2007 Fixed
15 Mar 2007 Fixed
Description
An outer join query using DISTINCT and ORDER BY clauses

may return incorrect results for COMPUTE predicates on

expressions involving columns from the inner table or

may raise a 325 error: "Adaptive Server finds no legal

query plan for this statement."



CR:461469
CR Number:   461469
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2007 Fixed
12 Mar 2007 Fixed
Description
A timeslice error followed by a stack trace that includes the module db__diskremap_sysaltusages could result when trying to load a transaction dump on a big archive database.



CR:461470
CR Number:   461470
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)
08 Mar 2007 Fixed
12 Mar 2007 Fixed
Description
If reformatting plan is chosen and the worktable need to be filled more than once, it could cause wrong results.
Workaround Description
 At least for this particular query setting store_index off works around the problem and returns the correct results.



set store_index 0



CR:461669
CR Number:   461669
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   RH Linux
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2007 Fixed
14 Aug 2007 Fixed
Description
On PPC64/Linux, if a dump is made with the compress option, the dump archive

cannot be greater than 2GB.
Workaround Description
 Possibly use stripes to reduce compressed dump file size.

Avoid using compression.



CR:461704
CR Number:   461704
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)
09 Mar 2007 Fixed
15 Mar 2007 Fixed
Description
In certain rare circumstances a cursor opened for update can calculate an incorrect row size for the newly updated row. This causes the cursor to fail and report error 669: "The length computation of the row <rowid> is wrong. Ensure that row-length is no greater than max possible size of <maxrowsize>. This error was detected during cursor scan fixups for cursor <cursor_name>. This is an internal error."
Workaround Description
 Change lock scheme to DOL



In the Repro scripts, modify create_sel_cumul_abs_annuelles_detail.sql - change the CREATE TABLE statements for #emp_abs_annuel and #emp_abs_an_detail to add 'lock datarows'. Basically all tables on which cursors are declared need to be changed to datarows.



CR:461719
CR Number:   461719
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)
12053 06 Jun 2008 Duplicate
Description
Problem: When using an XML file that has EUC-JP encoding with multi-bytes characters in the "XML via SQL Data Provider" component, an error occurs during execution of the engine.



Resolution: No workarounds exists - to be resolved in a future release.



CR:461735
CR Number:   461735
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2007 Fixed
Description
Stacktrace in CgpGlobal::CgpGenerate() might happen when a parallel

plan is chosen where there is an Xchg operator above a Sequence

operator.



CR:461765
CR Number:   461765
Product Name:   Adaptive Server Generic Docs
Product Component:   Commands Reference
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2008 Fixed
Description
Documentation Request : reorg rebuild command is not supported for system catalogs.



CR:461850
CR Number:   461850
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)
20 Sep 2007 Fixed
14 Jan 2008 Fixed
30 Mar 2008 Fixed
Description
A new configuration parameter called 'bind to engine' added for Rep Agent. Using this Rep Agent may be forced to run on a particular engine.



CR:461898
CR Number:   461898
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2007 Fixed
Description
If an ASE user task causes a stack overflow exception on the Windows platform, this can cause the entire server to hang rather than terminating that one user task and continuing with others



CR:461911
CR Number:   461911
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)
15 Jun 2007 Fixed
Description
Previously Resource Limit Wizard failed to check whether the specified resource limit existed or not before creating the resource limit. This has been fixed.



CR:461925
CR Number:   461925
Product Name:   Sybase Unicode Infrastructure Library
Product Component:   Sybase Unicode Infrastructure Library
Status:   Closed
OS:   NA
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2013 Insufficient priority to fix
Description
Change Unilib unisort_StringCompare function to include an option to consider ignorable characters to be given primary during sorting.



CR:461964
CR Number:   461964
Product Name:   Sybase ETL
Product Component:   pEngine
Status:   Closed
OS:   Windows 2003
Original Version:   4.2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2007 Not a Bug
Description
Problem: If a fixed-length file includes multi-byte characters, the "Text Data Provider" doesn't appear to read the file correctly. The position of columns does not fit into a multi-byte file although it fit into single-byte file. The delimited file with multi-byte characters has no problem.



Resolution: All column numbers, lengths and sizes in the text source and target are counting Unicode code points and NOT bytes. This means that a code point/character will ALWAYS occupy the space of one code point/character, no matter what encoding is used and regardless of the space used by the representation on disk in the specified encoding. For example a Japanese character will always be counted as one code point, whether the encoding is shift_jis, euc_jis, UTF-8. UTF-16, or UTF-EBCDIC all of which will encode the code point with a different number of bytes.



CR:461969
CR Number:   461969
Product Name:   Sybase ETL
Product Component:   pEngine
Status:   Closed
OS:   Windows 2003
Original Version:   4.2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2008 Fixed
23 Jul 2008 Fixed
05 Nov 2008 Fixed
27 Aug 2008 Added to user documentation
Description
Problem: The export function of Text Data Sink component appears to be counting a Multi-byte character as 1 byte data. Therefore, when exporting the data by using type=Fixed(Variable Line), The number of the spaces can be confusing.



Resolution: All column numbers, lengths and sizes in the text source and target are counting Unicode code points and NOT bytes. This means that a code point/character will ALWAYS occupy the space of one code point/character, no matter what encoding is used and regardless of the space used by the representation on disk in the specified encoding. For example a Japanese character will always be counted as one code point, whether the encoding is shift_jis, euc_jis, UTF-8. UTF-16, or UTF-EBCDIC all of which will encode the code point with a different number of bytes.



CR:462036
CR Number:   462036
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)
24 Apr 2007 Third Party Problem
28 Mar 2007 One-off Provided
Description
Instrumentation: ASE is unable to read TDS packets under load and reports invalid tdslength error



CR:462072
CR Number:   462072
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jan 2008 Added to user documentation
Description
As a result of fixing CR#336646, "2" was added to the value of xp_cmdshell context.

But the contents of a system management guide are not updated.



CR:462159
CR Number:   462159
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   15.0 tier2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2007 Fixed
06 Apr 2007 Fixed
08 Oct 2007 Fixed
Description
A query with a lot of AND terms in a WHERE clause may cause stack guardword corruption.



CR:462184
CR Number:   462184
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2009 Added to user documentation
Description
When ASE enable "net password encryption reqd" option, HS and MS failed login to ASE.



CR:462189
CR Number:   462189
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2007 Fixed
Description
If the configuration option "print deadlock information" is set and

a deadlock occurs, ASE activates trace flag 3605 for the deadlock report

but forgets to unset it after the report is finished, causing additional

subsequent output to be written in the error log.



CR:462191
CR Number:   462191
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2007 Fixed
16 May 2007 Reservation Made
29 Jun 2007 Fixed
Description
The message text for error 15082 has been changed to indicate that it is not an error "There are <value> OAM entries with zero used/unused page counts. This is not an error. Run DBCC <value> FIX on objid <value> indid <value> to remove these entries as doing so will improve OAM scan performance.". Furthermore the message will be reported on objects with greater than 10 OAM pages and having 50% zero used/unused page counts OAM entries.



CR:462279
CR Number:   462279
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 Mar 2007 Fixed
Description
A simple 1 table query with a predicate that represents a FALSE condition as 8 < 5, will cause the query to stack trace. This is because the partition elimination functionality cannot deal with a predicate that has been marked FALSE and results into a stack trace.



CR:462326
CR Number:   462326
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2007 Fixed
Description
"auditinit" creates sysaudits_XX tables without "nodeid" column in "sybsecurity" database. Also, the column "objname" in sysaudits_XX tables have varchar(30). It should be varchar(255).



CR:462331
CR Number:   462331
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)
21 Mar 2007 Fixed
10 Mar 2008 Fixed
Description
soc_printpeername should print port number of client associated with invalid tds



CR:462372
CR Number:   462372
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2007 Fixed
30 Aug 2007 Fixed
05 Sep 2007 Fixed
Description
With multiple checkpoint worker threads, a 216 error: " Attempt to automatically drop temporary table failed" may sometimes occur, preceded by a 3702 error: "Cannot drop the <tablename> because it is currently in use."



CR:462379
CR Number:   462379
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2007 Bundled Request
Description
For query like insert ... select distinct ... union all, signal 11 and

stacktrace could happen in CgpUnion::_cgpInit().



CR:462504
CR Number:   462504
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2007 Fixed
06 Apr 2007 Fixed
08 Oct 2007 Fixed
Description
A query involving many AND/OR terms may cause stack overflow.
Workaround Description
 A Palliative is to increase the stack size, but really we should at least terminate the process gracefully.



CR:462671
CR Number:   462671
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2007 Fixed
10 Oct 2007 Fixed
Description
In one process, if it use sp_showplan <spid> to probe another process and if the

target process which is being probed is blocked before entering new LAVA engine, it could

cause stack trace in _LeOpShowOp() if plan use worktables.



CR:462696
CR Number:   462696
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2007 Fixed
20 Mar 2007 Fixed
Description
When ASE reports an I/O failure as a result of a hardware error, it reports an incorrect virtual page number for the failure.





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