远程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:357181
CR Number:   357181
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2004 Fixed
Description
The amount of memory needed by Adaptive Server may be overestimated.

This could happen when a large number of "open objects", "open databases"

or user-defined caches are configured so that following an upgrade, Adaptive

Server may be unable to boot. The following message, "The value of the

'max memory' parameter (<value>) defined in the configuration file is not

high enough to set the other parameter values specified in the configuration

file...", is reported in the error log.
Workaround Description
 1. reduce the cache partition:

e.g. 1 cache partition for each of the cache

2. reduce the number of named caches or just one big data cache.



CR:357188
CR Number:   357188
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2006 Fixed
Description
Under some circumstances, on a heavily-loaded multi-engine system and multiple clients running java (activated through "enable java" configuration parameter), the message "current process infected with 11" or "current process infected with 10", together with a stack trace in function Opinvokevirtual or Opinvokestatic or Opinvokespecial may be reported in the errorlog.



CR:357215
CR Number:   357215
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2005 Fixed
Description
If ASE started from Windows services the jsagent.log is stored in the c:/winnt/system32 dir.



CR:357220
CR Number:   357220
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2005 Fixed
Description
Query using a view with big number of aggregates may be executed slowly

if more than one worktable is necessary to resolve aggregates from the view.
Workaround Description
 use 8k server.



CR:357225
CR Number:   357225
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2004 Fixed
Description
This CR is to complete CR 322069. When the target database contains a very large number

of tables/indexes, checkstorage may produce a timeslice whose stacktrace contains the

function 'pchk_pt_sort_grp'. Increasing the 'cpu grace time' parameter may alleviate

this problem.



CR:357241
CR Number:   357241
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2004 Fixed
29 Jun 2004 Fixed
10 Jan 2006 Fixed
07 Jul 2004 Fixed
22 Jul 2004 Fixed
Description
Interactive SQL is integrated with ASE Plug-in in the following places:



- "Utilities" folder: launch Interactive SQL requiring new logon infomration

- Servers: launch Interactive SQL and connect to the servers

- Database: launch Interactive SQL and connect to the server of the database and switch to the database

- Tables and views: launch Interactive SQL to view table or view data



CR:357333
CR Number:   357333
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
This change in behaviour is pretty nice in that sense that the database is not marked suspect because one of its devices was not available at boot time. In anycase trying to use the database won't succeed.





So after I have fixed the device issue and restarted ASE all if fine.

There doesn't seem be a need of marking the database suspect.



This nice change in behaviour is due to the parallel recovery feature.



CR:357336
CR Number:   357336
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2010 Presently Not Targeted For Any Future Release Of This Product
16 Mar 2010 Presently Not Targeted For Any Future Release Of This Product
Description
In Sybase Central there is a feature to allow users to monitor ASE using Monitor Server, this is available on Windows platforms but not within UNIX.



CR:357452
CR Number:   357452
Product Name:   Adaptive Server Enterprise
Product Component:   sqlloc
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2004 Duplicate
10 Jun 2004 Duplicate
Description
sqlloc 12.5.2 fails to install japanese language
Workaround Description
 Step 1 : $ charset -Usa -P binary.srt eucjis

SQLServer message 4017, state 1, severity 16:

Neither language name in login record 'japanese' nor language name in syslogins '<NULL>' is an official language name on this SQL Server. Using server-wide default 'us_english' instead.



Loading file 'binary.srt'.

Found a [sortorder] section.

This is Class-1 sort order.

Finished loading the Character Set Definition.

Finished loading file 'binary.srt'.

1 sort order loaded successfully



Step 2 : $ isql -Usa -P

Msg 2401, Level 11, State 2:

Server 'm1252_linux32a':

Character set conversion is not available between client character set 'eucjis' and server character set 'iso_1'.

No conversions will be done.

Msg 4017, Level 16, State 1:

Server 'm1252_linux32a':

Neither language name in login record 'japanese' nor language name in syslogins

'<NULL>' is an official language name on this SQL Server. Using server-wide default 'us_english' instead.

1> sp_configure 'default character set id', 140, bin_eucjis

2> go

In changing the default sort order, you have also reconfigured SQL Server's default character set.

Parameter Name Default Memory Used Config Value Run Value Unit Type

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

default character set id 1 0 140 1 id static



(1 row affected)

Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect.

Changing the value of 'default character set id' to '140' increases the amount of memory ASE uses by 6 K.

(return status = 0)



1> shutdown

2> go



Step 3 : Restart server...it'll show warning as below and will shutdown automatically.



00:00000:00001:2004/06/07 18:50:58.01 server *** WARNING ******************

00:00000:00001:2004/06/07 18:50:58.01 server Attempting to change default character set ID from 1 to 140

00:00000:00001:2004/06/07 18:50:58.01 server SQL Server booted single user mode - updates allowed to system catalogs

00:00000:00001:2004/06/07 18:50:58.01 server *** WARNING ******************



Step 4: Restart again.



Step 5: Do langinstall.



[msabapat@tako install]$ langinstall -Usa -P japanese eucjis

................

Loading datetime information from file /tse_work/msabapat/1252_32/locales/japanese/eucjis/common.loc.

Loading system messages from file /tse_work/msabapat/1252_32/locales/japanese/eucjis/server.loc.

Error line 7726: Format count of message 19178, version 1252, does not match English message.

Error: (-43) Line in localization file too long line = 7862

00:00000:00011:2004/06/07 18:54:49.83 server Configuration file '/tse_work/msabapat/1252_32/ASE-12_5/m1252_linux32a.cfg

' has been written and the previous version has been renamed to '/tse_work/msabapat/1252_32/ASE-12_5/m1252_linux32a.002'.

00:00000:00011:2004/06/07 18:54:49.84 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.

7479 Messages processed.

Loading complete.

Summary: 0 deleted, 7092 inserted, 0 updated, 385 duplicates, 2 unsuccessful.



Now you wont get Msg 2401 and 4017 when logging in using isql as below.



[msabapat@tako install]$ isql -Usa -P

1> shutdown

2> go



CR:357477
CR Number:   357477
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.8 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2004 Fixed
11 Jun 2004 Fixed
Description
A 871 error, "Process <spid> is trying to release a latch on buffer <value> (dbid: <value>, pageno: <value>) without holding a latch on the buffer." may be raised in module 'getnext' or 'dol__get_lock' when the given process selects rows from a Data Only Locked table while DML commands are taking place concurrently by other processes.



CR:357658
CR Number:   357658
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2004 Fixed
Description
In an HA environment that is configured "with proxy_db", the error "Infected with 11" followed by a stack trace that includes the module 'palt__gen_addcol_clause' will be printed in the error log and the process will be killed when a table is altered to add a new non-null column without providing a default. A 4997 error, "ALTER TABLE '<tabname>' failed. Default clause is required in order to add non-NULL column '<colname>'", should be printed instead.
Workaround Description
 Use a default clause during alter table when specifying not null



CR:357688
CR Number:   357688
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2004 Fixed
Description
A 530 error, "Attempt to insert NULL value into column ... in work

table (table id ...) column does not allow NULLS. UPDATE fails."

may be raised when a java class running inside the ASE's JVM is

connecting to the server using the internal JDBC driver and then

executes a query on a table that has wide columns and a worktable

is necessary to resolve that query.
Workaround Description
 'alter table node_attribute_definitions modify description varchar(255)'



may workaround for column decription varchar(1024) is a wide column, change it's length to 255 can avoid the problem.



CR:357772
CR Number:   357772
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   all
Original Version:   athena
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
XML model generated from OOM or from PDM



When generate an XML model from an OOM, cardinalities defined on an association are lost.



Steps to reproduce

New OOM : class diagram, java



2 classes with few attributes

one association between those classes

association properties

multiciplicity :

class_2

0..1

class_1

4



generate an XML

the concept of cardinality is lost



For the customer : the generated XML should reflect this with constrains



CR:357807
CR Number:   357807
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2004 Fixed
27 Sep 2005 Fixed
Description
When a device is created without specifying the complete path, there are times it is not started at startup.



Request to implement one of the following:

1. Require a full path to be entered at disk init.

2. Append the current working directory to the device name when a full path name is not entered.

3. Raise a warning if a device is created without a full path.
Workaround Description
 *** Wednesday, June 09, 2004 7:07:17 AM *** cooperg ***

See description notes.



CR:357839
CR Number:   357839
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2004 Fixed
Description
The command DUMP TRAN <dbname> TO <devname> WITH STANDBY_ACCESS may take too much

time to stop when interrupted with Ctrl C or killed from another session.



CR:357841
CR Number:   357841
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2004 Fixed
Description
Sql containing many updates to the same column in a sql update statement can cause many 264 error messages and even result in a segv or access violation.
Workaround Description
 Assure that the client sql doesn't generate multiple updates to the same column in the same statement (minimally not too many of them!!)



CR:357895
CR Number:   357895
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2004 Fixed
28 Apr 2005 Fixed
28 Apr 2005 Fixed
Description
ASE running on the Windows Server 2003 platform does not produce correct stacktrace

if ASE executable sqlsrvr.exe is not found in the current working directory.



CR:357912
CR Number:   357912
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
In HA setup, sp_password when executed by the login whose password has already expired

does not synch the password on the companion side.

To work-around, person with "sso_role" could run "sp_password" on the account whose

password has expired from either of the companion servers.
Workaround Description
 you can ask person with "sso_role" to reset the password on both the companion servers upon password expiration.



CR:357933
CR Number:   357933
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2006 Not reproducible with latest version of the product available as of Resolution Date
Description
ASE Plugin: unichar & univarchar columns are displayed as twice their actual length.
Workaround Description
 n/a



CR:357972
CR Number:   357972
Product Name:   Adaptive Server Generic Docs
Product Component:   XA Guide for CICS Encina and Tuxedo
Status:   Open
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the "Component Integration Services User's" doc "http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/omni_ug/@Generic__BookView",

in "Chapter 2 Understanding Component Integration Services",under "Proxy tables" section, under the "Example of remote table definition" there is an issue that a customer has. The example shows how to create a remote table, under the assumption that the reader is login as "sa". We need a Note or a Step stating that if you are not logon in as user "sa' then you need to logon in as "sa" and under the "master Database" and "grant connect to USERID", then relogin as the USERID. Even thought this is documneted else where in the CIS DOC and in the Reference DOC under "Connect TO".



CR:358003
CR Number:   358003
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2004 Fixed
05 Nov 2004 Fixed
Description
When configuring the JOB scheduler, if the password is omitted from the sp_addexternlogin stored proc and you execute a job, the following errors are continuously logged in the jsagent.log and eventually grows until you run out of disk space.



00:00005:00001:2004/06/02 12:47:20.75 worker Client message: ct_get_data(): user api layer: external error: Item 1 has already been read.
Workaround Description
 *** Thursday, June 10, 2004 10:09:01 AM *** cooperg ***

Make sure password is set when configuring external login.



CR:358007
CR Number:   358007
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2004 Fixed
07 Sep 2004 Fixed
15 Nov 2004 Fixed
Description
Stored procedure executing INSERT into a table with some VARCHAR columns may incorrectly leave

trailing spaces in the VARCHAR column if the source of the data is a table with CHAR column.
Workaround Description
 Boot ASE with -T7709 to desactivate the fix for CR 326477. It should help

for majority of cases when the problem is hit from the stored procedure.

(Please look at the note at end of Description for checking and fixing incorrect trailing spaces)



CR:358030
CR Number:   358030
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)
31 Aug 2004 Fixed
Description
When a checkstorage check on an object is aborted, the database id,

object id, index id and additional context information is printed

to the errorlog.



CR:358035
CR Number:   358035
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2010 Fixed
17 Nov 2011 Fixed
Description
sp_locklogin cannot be executed from a database other than the master database after HA is setup.
Workaround Description
 Qualify the sp with the master database master..sp_locklogin instead of just sp_locklogin



CR:358062
CR Number:   358062
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2004 Fixed
25 Mar 2004 Presently Not Targeted For Any Future Release Of This Product
Description
An 820 error, "Attempt to dirty non-log buffer <bufptr> which is in I/O.", with state 6 may sometimes be encountered while truncating a Data Only Locked table, if the HOUSEKEEPER garbage collection task is enabled.



CR:358087
CR Number:   358087
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jan 2006 Fixed
26 Jun 2007 Fixed
Description
The default value of configuration parameter 'dtm detach timeout period'

has been modified to 5 minutes. Any external transaction such as

XA transaction will be rolled back, if in detached state, for more

than 5 minutes. A value of 0 will disable external transaction timeout.



CR:358090
CR Number:   358090
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2005 Fixed
12 May 2005 Reservation Made
19 May 2005 Fixed
Description
Two new builtin functions have been added, XA_GTRID(<xactname>, 0) and XA_BQUAL(<xactname>, 0) that decode an XA transaction <xactname> and report the decoded GTRID or BQUAL as a VARBINARY value. These builtins are useful in mapping XA transactions on Adaptive Server to XA transactions within the XA TM.
Workaround Description
 N/A



CR:358092
CR Number:   358092
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.8 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2004 Fixed
06 Sep 2004 Fixed
11 Oct 2007 Duplicate
Description
When forcing an index, the optimiser considers only the 1st SARG.



CR:358148
CR Number:   358148
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)
23 Jun 2004 Fixed
27 Jul 2004 Fixed
Description
On Sun Solaris 8 when ASE was booted with traceflag 7841 allowing for preliminary

IPv6 support ASE_JAVA applets failed to establish IPv4 oriented network communications.



CR:358196
CR Number:   358196
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2004 Fixed
Description
Request to add reference in Transact-SQL User's Guide



CR:358239
CR Number:   358239
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 Jun 2004 Fixed
Description
INTERNAL ONLY: Booting the server with a mirrored master device causes a seg fault.



CR:358269
CR Number:   358269
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2004 Fixed
15 Jul 2004 Fixed
01 Nov 2005 Fixed
03 Nov 2004 Fixed
Description
A SELECT UNION query using a view which is materialized whereby columns of the view are used

in an outerjoin-clause can return incorrect results.
Workaround Description
 Use same datatype for the columns involved in the outer join, except "char not null" which is posing

problem (on table A in the repro).



CR:358292
CR Number:   358292
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2004 Fixed
Description
Historical Server may sometimes crash if an error occurs whilst reading ASE sysmon counters.



CR:358397
CR Number:   358397
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2004 Fixed
05 Aug 2004 Fixed
Description
Transient 806, 691, 605 errors may be seen in very rare circumstances when multiple sessions are scanning the same page of an index in an Allpage Locked table.



CR:358402
CR Number:   358402
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2004 One-off Provided
Description
Under certain race conditions, it is possible for a disconnecting thread to be assigned to another login and reassigned to another engine before the disconnect processing is completed.



CR:358404
CR Number:   358404
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2004 Fixed
15 Feb 2007 Fixed
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.



CR:358410
CR Number:   358410
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Configuration Guide for UNIX
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Remove net-library references from ASE documentation.



CR:358418
CR Number:   358418
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2004 Fixed
30 Jun 2004 Fixed
Description
Monitor tool to display in English only.



CR:358421
CR Number:   358421
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 Fixed
Description
When space remaining at the end of a disk piece happens to equal exactly the size of the smallest permitted block of space, create- or alter-database will not select that piece.



CR:358450
CR Number:   358450
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2004 Fixed
Description
If a new data cache is created using sp_cacheconfig, the "APF Percent" for the default memory pool may be incorrectly set to zero when Adaptive Server is next rebooted. This can cause performance degradation when accessing any objects that are bound to this data cache.
Workaround Description
 Set the APF value manually using sp_poolconfig as soon as the cache has been created.

For example:



sp_cacheconfig "new_cache", "100m"

go

sp_poolconfig "new_cache", "2k", "local async prefetch limit=10"

go



CR:358510
CR Number:   358510
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2006 Bundled Request
Description
Database Properties Usage page is modified. It now reports the following information (derived from sp_spaceused): database size, reserved space, used space (by data and indexes), unused space, and unreserved space.



CR:358541
CR Number:   358541
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.0.0.8 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2004 Presently Not Targeted For Any Future Release Of This Product
01 Sep 2004 Fixed
22 Oct 2004 Presently Not Targeted For Any Future Release Of This Product
25 Oct 2004 Fixed
14 Oct 2005 Failed
Description
When a database is created with quoted_identifier enabled, and the name is specified with quotes, the quotes are stored in the catalog as part of the name. As a result, accessing the database requires the quoted_identifier setting and enclosing the database name in quotes. Changes have been made not to store the quotes or trailing blanks with the database name. The database can be accessed with or without quotes now. The new behaviour can be reverted using the Traceflag 113.



CR:358556
CR Number:   358556
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2004 Fixed
Description
Users will notice that when reviewing the properties for a schedule, the start time will display the actual start time specified by the user, either when the schedule was created or when the time was last updated in the properties window rather than the current server time.



CR:358591
CR Number:   358591
Product Name:   Adaptive Server Generic Docs
Product Component:   Transact-SQL Users Guide
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2004 Fixed
Description
T-SQL Guide 12.5.x has misleading information in Table 19-5 (18-5 in 12.5 manual)



CR:358598
CR Number:   358598
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2004 Fixed
28 Sep 2005 Fixed
29 Aug 2005 Fixed
Description
The message "infected with 11" together with a stacktrace containing the modules 'apg__setop',

'ap_generate' and 's_ap_capture' is printed in the errorlog when "abstract plan dump" is

configured and a SELECT containing a UNION with a simple SELECT like SELECT "<string value>"

is executed.
Workaround Description
 don't use AP dumps.



CR:358608
CR Number:   358608
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2004 Duplicate
Description
One cannot monitor cancelled/disconnected transactions via kill with statusonly utility except if an explicit rollback is executed



CR:358636
CR Number:   358636
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2005 Fixed
Description
The instruction in the Systems Administration Guide,

Chapter 29 - Restoring the System Databases under "Recovering the master database" are misleading. Instructions in 12.5.1 SAG to restore master device are misleading and there is also techdoc # 1028123 - Recovering an Upgraded Master Device and master Databases in ASE 12.5.x, that points to the SAG. (generic problem) Instructions should also differ based on 12.5/ebf versions. The Techdoc needs to be fixed, until the SAG can be corrected.



CR:358654
CR Number:   358654
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2006 Fixed
Description
'set statistics plancost on' will display the I/O counts for a given paralle query, form the alf athread as well as from the child threads in a semi-graphical format.



CR:358699
CR Number:   358699
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2004 Not a Bug
29 Sep 2004 Fixed
06 Oct 2004 Fixed
Description
The process of searching for a JRE to use is now more robust. The search for a

JRE follows the following steps:



1) The SYBASE_JRE environment variable

2) Search for JRE 1.4 at $SYBASE/shared-1_0/JRE-1_4

3) Search for JRE 1.3 at $SYBASE/shared-1_0/JRE-1_3



CR:358758
CR Number:   358758
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2004 Fixed
Description
When a transaction is being implicitly rolled back by ASE, then the command

"KILL <spid> WITH STATUSONLY" will mistakenly report the message "Status

report cannot be obtained. ROLLBACK for spid:<spid> is not in progress.".



CR:358800
CR Number:   358800
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2004 Fixed
Description
On AIX platforms, there may be a problem with populating the aio_return field of an aio control

block in a timely fashion within the ASE.



CR:358835
CR Number:   358835
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2004 Fixed
23 Sep 2004 Fixed
05 Jan 2005 Fixed
Description
ASE running on the Windows Server 2003 platform does not produce a correct stacktrace when a problem occurs. This does not affect ASE running on Windows 2000 and earlier versions.



CR:358859
CR Number:   358859
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2006 Fixed
26 Jan 2006 Fixed
07 Feb 2006 Fixed
Description
A corrupt index may result with the root page having extra entries pointing to deallocated pages when an empty APL partitioned table is unsliced.



CR:358868
CR Number:   358868
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2004 Fixed
14 Nov 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Character set conversions are rejected for older (DBlib) clients when

the server's default character set is SJIS and the client's character

set is EUCJIS.
Workaround Description
 No workaround



CR:358880
CR Number:   358880
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2006 EOL'd version. Not to be Fixed.
22 Feb 2006 Fixed
28 Feb 2006 Fixed
Description
3.14.2.4 error "Logical page nnn is not in the given database map." might be returned if the load

target database uses more than one database device and the dump file is created by backupserver

which is started with -m option and/or BLOCKSIZE option of DUMP command.



CR:358907
CR Number:   358907
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2004 Fixed
Description
Error 17782: "You do not own a table or column (or index) of that name in the current database." may be reported upon running sp_rename(tablename.oldcol, newcol)when option ANSINULL is on.



CR:358954
CR Number:   358954
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2004 Fixed
Description
When CREATE TABLE and INSERT are in the same store procedure, and the table is a non-temporary table with IDENTITY column, the IDENTITY column data will be incorrect.



CR:358966
CR Number:   358966
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request: create a simply way to determine the highest average engine utilization since boot time.



CR:358969
CR Number:   358969
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2004 Fixed
Description
The monEngine.CPUTime value is not reset by sp_sysmon and therefore becomes inconsistent relative to the other values. This column is documented as "counter, reset".



CR:359029
CR Number:   359029
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2004 Fixed
Description
Table 10-6: Locking or dropping login accounts.

Since 12.5.0.3, The Drop login account needs sso_role not sa_role.



CR:359031
CR Number:   359031
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2004 Fixed
Description
Since 12.5.0.3, sso_role has new privilege, "Drop login".



CR:359128
CR Number:   359128
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2004 Fixed
Description
A 10479 error, "Conversion error detected while converting Java data to SQL data. Either the conversion is not supported or the datatype(s)is invalid." may be raised when using CONVERT() function to convert certain JAVA datatype values to NUMERIC SQL datatype values.
Workaround Description
 Use "set arithabort numeric_truncation off"



CR:359131
CR Number:   359131
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy2 19 Oct 2004 Fixed
Description
Server entries from interfaces file are listed on the new Servers panel (visible when Adaptive Server Enterprise item is selected).



CR:359135
CR Number:   359135
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2004 Fixed
Description
This new feature allows users to create and schedule jobs for tasks they perform from ASEPlugin without actually being in the Scheduled Job folder or even on a Job Scheduler ASE.



CR:359140
CR Number:   359140
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Open
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2004 Fixed
Description
This new feature adds a new tab to the Server properties window so that users can register the Job Scheduler ASE to be used for remote job scheduling.



CR:359172
CR Number:   359172
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2004 Fixed
02 Aug 2004 Fixed
05 Aug 2004 Fixed
Description
If Job Scheduler Task fails to initialize, infected with 10 in kbfalloc() is caused by running sp_sysmon with "cache wizard".
Workaround Description
 Reinstall installjsdb of proper version



CR:359408
CR Number:   359408
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
ASE will incorrectly report the time when it has been booted with the TZ environment variable specifying a custom offset for daylight savings time, and daylight savings time is in effect. ASE will report the time as the normal one hour offset from standard time rather than the custom offset.



CR:359431
CR Number:   359431
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
modify the description for error 8221



CR:359486
CR Number:   359486
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2005 Fixed
Description
sp_poolconfig may not set wash size correctly.
Workaround Description
 Run sp_poolconfig again, if it doesnt take effect the 1st time.



CR:359705
CR Number:   359705
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2004 Fixed
Description
"Real Time Messaging Support" feature on HPUX 64 platform.



CR:359708
CR Number:   359708
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2004 Fixed
30 Aug 2004 Reservation Made
06 Oct 2004 Fixed
Description
New configuration options, 'max native threads per engine' and 'rtm thread idle wait period'.



'max native threads per engine' controls the maximum number of native threads that an engine can spawn. If this limit is reached, the ASE thread that requires the native thread will sleep until another thread releases a native thread.



'rtm thread idle wait period' is the idle wait period (in seconds) that a native messaging thread will wait for work. If this period is reached without new work, the native thread will fade itself out.



CR:359754
CR Number:   359754
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2004 Fixed
Description
CIS: In rare circumstances, a query with an aggregation and a GROUP BY clause on a same remote column will be passed to the remote server with some incorrect query text and return wrong results



CR:359822
CR Number:   359822
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2004 Fixed
09 Jul 2004 Fixed
Description
A 2610 error may be raised when data is inserted into a table having an index key column of DATE TIME datatype.



CR:359833
CR Number:   359833
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The issue is that in the "Troubleshooting and Error Messages Guide" in "Chapter 2

Encyclopedia of Tasks", under "Other Useful Tasks", "How to Reduce the Size of tempdb"



8- Verify that tempdb has one entry that looks like this:

1> select * from sysusages

2> where dbid = db_id('tempdb')

dbid segmap lstart size vstart

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

2 7 0 1024 2564



The above information is incorrect, it was correct for 11.x, but as of ASE 12.X the above information is incorrect.



CR:360042
CR Number:   360042
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2004 Fixed
Description
sp_chgattribute limits the new maximum identity value to 17 decimal digits.



CR:360063
CR Number:   360063
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2004 Fixed
Description
Under large number of user connections, if connections are killed repeatedly, then subsequent logins may take a long time to get through resulting in slower response time.



CR:360170
CR Number:   360170
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2004 Fixed
Description
CIS: When a database is marked for replication via sp_reptostandby, writetext

to a file via a proxy table mapped to an external directory results in stacktrace.
Workaround Description
 Have to explicitely mark tables for replication



CR:360208
CR Number:   360208
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.3 22 Jul 2004 Fixed
Description
XP Server was configured with a too small default stack size, causing many External

Stored Procedures to fail and make XP Server crash under any exceptional ESP.



CR:360294
CR Number:   360294
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.8 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.0.0.8 ESD#3 23 Aug 2004 Fixed
23 Aug 2004 Fixed
Description
CIS: Reformatting causes errors 2409, 4017 when selecting from a view containing proxy tables.
Workaround Description
 Load the EUCJIS charset and Japanese language into the remote ISO_1 server.



CR:360308
CR Number:   360308
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2004 Fixed
23 Aug 2004 Fixed
Description
The message, "current process infected with 11" in the module 'is_subtree' together with a stack trace which includes the modules 'aggby' and 'normquery' may be reported in the error log if a query contains two subqueries in a HAVING clause and the second subquery has an aggregate.



CR:360372
CR Number:   360372
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)
22 Nov 2004 Fixed
Description
Error 3626 is raised with the text 'Message empty' when the configured

stack size is insufficient to run a query. Instead the text "The transaction

was aborted because it used too much stack space. Either use sp_configure

to increase the stack size, or break the query into smaller pieces..."

should be reported.



CR:360414
CR Number:   360414
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2004 Fixed
30 Jul 2004 Fixed
08 Dec 2004 Fixed
Description
Under rare circumstances a session may hit a segmentation violation with message "current process (<value>) infected with 11" in module 'bufdlink' followed by a stack trace in the error log. This results in an implicit shutdown of ASE.
Workaround Description
 Do not bind user temporary databases to different named caches,

OR have all user tempdbs bound to the same named cache.



CR:360416
CR Number:   360416
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2004 Fixed
Description
Under very rare circumstances, 696 or 605 errors may be raised for tables being

bound to a named cache using the 'Relaxed LRU' strategy.
Workaround Description
 Revert back to the default cache replacement strategy i.e "strict LRU"



CR:360423
CR Number:   360423
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Bulletin for IBM
Status:   Closed
OS:   AIX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2004 Fixed
Description
Installation guide is confusing since the lib3p and lib3p64 directories do not exist in an AIX 5.1 installaiton as per the installation guide.



CR:360519
CR Number:   360519
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2005 Fixed
Description
ASE server was locking login account when number of unsuccessful login attempts reached value of "maximum failed logins". This CR, per customer request, is to generate an audit record when this event occurs.



CR:360566
CR Number:   360566
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.0.0.8 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2004 Fixed
Description
CIS: Under some circumstances, ASE may show some performance degradation when receiving large result sets from remote tables.



CR:360582
CR Number:   360582
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2004 Fixed
05 Jul 2004 Fixed
09 Jul 2004 Fixed
09 Jul 2004 Fixed
23 Jul 2004 Fixed
23 Jul 2004 Fixed
Description
Not customer visible



CR:360587
CR Number:   360587
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2004 Fixed
Description
Improvements to resource governor functionality.



CR:360599
CR Number:   360599
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2004 Fixed
Description
The current limit of 1024 AND/OR conditions in a WHERE clause has been raised to 2000. In order to take advantage of this new limit, it is necessary to adjust the default stack size upward, to approximately 300K. No change to the stack size is required unless the application desires to take advantage of this new limit.



In addition to stack space, this new limit may result in a need to allocate more procedure cache space to the server.



The dataserver must be started with traceflag 404 ( -T404 ) to allow this new limit to take effect. Otherwise, the current limit of 1024 will remain.
Workaround Description
 None. There is a hard limit of 1024 defined by the macro MAXANDOR, in server.h



CR:360658
CR Number:   360658
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)
31 Aug 2004 Workaround
Description
improvements in regard to update statement on views using variables.
Workaround Description
 Instead of

update df_poall_tst

SET @UCNT = @UCNT + 1, @MED_LOW = dst_ut_id, @MED_HGH = dst_ut_id



consider



select @ucnt=count(*), @MED_LOW = dst_ut_id, @MED_HGH = dst_ut_id from df_poall_tst



CR:360689
CR Number:   360689
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2004 Fixed
21 Mar 2006 Fixed
01 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
The error 540, "Schema for table '%.*s' has changed since compilation of this query. Please re-execute query." will be incorrectly reported, if a table is accessed in the same batch it is created and it has any primary, foreign or referential key constraints.



CR:360699
CR Number:   360699
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   macosx
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2004 Fixed
Description
Backup server does not use asynchronous disk I/O, which was introduced in Mac OS X 10.3.



CR:360812
CR Number:   360812
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)
02 Aug 2004 Workaround
02 Jan 2008 Fixed
17 Dec 2007 Deferred
Description
Allow ASE to close one errorlog file, and open a new file without rebooting the ASE.



CR:360856
CR Number:   360856
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2004 Fixed
04 Aug 2004 Fixed
Description
Poor performance during index migtation when 'number of sort buffers' is DEFAULT (500).
Workaround Description
 Increase the number of sort buffers prior to migration of the indexes.



CR:360954
CR Number:   360954
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2006 Presently Not Targeted For Any Future Release Of This Product
20 Aug 2006 Fixed
Description
When executing system procedures that have non-ANSI comparisons such as "if @var = NULL", some procedures may show unexpected behaviour if 'ansinull' is set 'on' in the session from which the procedures are executed.
Workaround Description
 - Rewrite the system procedure causing the problem: replace '= NULL' or '!= NULL' by the corresponding ANSI syntax 'IS NULL' or 'IS NOT NULL'.

- Or avoid setting the 'ansinull' option.



CR:360959
CR Number:   360959
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Configuration Guide for UNIX
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2004 Fixed
Description
Windows ASE Configuration Guide mentions obsolete information about sql.ini



CR:360969
CR Number:   360969
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   NA
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2006 Fixed
25 May 2006 Fixed
23 Jul 2008 Fixed
23 Jul 2008 Fixed
Description
Eliminate duplicate wait event descriptions in the monWaitEventInfo MDA table.



CR:360975
CR Number:   360975
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2004 Fixed
17 Sep 2004 One-off Provided
28 Sep 2004 One-off Provided
23 Nov 2004 Insufficient priority to fix
Description
ASE returns a parameter xactstatus that the XA client never requested.

This causes Open Server based applications to get the error "Output

parameter not found" and consequently makes XA incompatible with Open Server.



CR:360978
CR Number:   360978
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2005 Bundled Request
Description
Not customer visible



CR:361050
CR Number:   361050
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2004 Fixed
Description
Data truncation may result when a univarchar column with length greater than 255 is updated through dynamic sql.





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