提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着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:353309
CR Number:   353309
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2005 Fixed
Description
When a new remote server is added with sp_addserver, it will be created with the status field set to 'no timeouts' as this can help RPC performance in some circumstances. Existing remote servers in the sysservers table will not be changed.



CR:353375
CR Number:   353375
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2004 Fixed
14 Sep 2004 Fixed
Description
The performance of the analysis and redo passes in recovery for large numbers of transactions and large numbers of log records has been improved.
Workaround Description
 N/A



CR:353393
CR Number:   353393
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2004 Not a Bug
Description
ASE Plugin for Sybase Central: Changing ASE configuration no longer reports how much additional memory is required.
Workaround Description
 Use ISQL instead?



CR:353394
CR Number:   353394
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2004 One-off Provided
Description
INSTRUMENTATION: ASE 12.5.0.3 on Red Hat AS 2.1 dumps core. Core dump stacktrace indicates

ASE received Alarm Signal (Signal 14) during select system call. Internal data structures

within Linux signal handling code are corrupted resulting in failure to process Signal 14

that results in recursive Signal 11 which leads ASE to dump core. This instrumentation

adds a worksround by blocking signals during select() system call.



CR:353460
CR Number:   353460
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)
14 May 2004 Fixed
Description
sp_monitor stored procedure executed with the 'connection' parameter gives incorrect time values for sleeping processes.



CR:353472
CR Number:   353472
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   11.9.2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2004 Fixed
18 Jul 2004 Fixed
26 Oct 2004 Fixed
Description
In a server with CASE INSENSITIVE sort order, creating a nonclustered index on a

Data Only Locked table with SORTED_DATA option may cause DBCC CHECKTABLE to report 9996 errors;

DELETEs on the table may fail with 644 errors.
Workaround Description
 Use dbcc traceon 12608



CR:353644
CR Number:   353644
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)
15 Sep 2004 Fixed
16 Sep 2004 Fixed
11 Feb 2005 Fixed
Description
The message "infected with 11 in s_result_const_memfree()" together with a stacktrace containing

the modules 's_handle', 's_normalize' and 's_renormalize' is written to the errorlog when executing

a stored procedures which gets recompiled. During the recompile Msg. 208 'Object <object> not found.'

is raised.



CR:353679
CR Number:   353679
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2005 Fixed
Description
The Sybase Central Java addition ASE Plugin, when displaying Details for master or System Stored Procedures, when sorting the the rows using "Creation Date" the dates seemed to be sorted Alphabetical order not date order. Like Dec will be sorted before May.



CR:353699
CR Number:   353699
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 May 2004 Duplicate
Description
All future logins are blocked if "max failed logins" is set, master database is QUIESCED, and a login attempt is made using an invalid password.
Workaround Description
 set "maximum failed logins" to 0 before issuing QUIESCE DATABASE

-or-

always leave connection open to issue "quiesce release"



but there doesn't seem to be a way around rebooting otherwise.



CR:353718
CR Number:   353718
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2004 Fixed
06 Sep 2004 Fixed
Description
A 2628 or 2630 error together with message "Mass <addr> found in the buffer wash with incorrect state dirty but not writing" may sometimes be encountered while doing a lot of UPDATEs or DELETEs on a Data Only Locked table.



CR:353748
CR Number:   353748
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2004 Duplicate
Description
Sybase Central C++ version use to have a way to update stats on an Index, cutsomer would like the feature back. The C++ version if you Right Click on the Index there is a "Update Statistics" on the drop down menu.



CR:353757
CR Number:   353757
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2004 Fixed
Description
The performance of ROLLBACK TRANSACTION has been improved by performing asynchronous prefetch during rollback and by increasing the priority that the scheduler gives to the session performing the rollback.
Workaround Description
 N/A



CR:353797
CR Number:   353797
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)
07 Jun 2004 Fixed
Description
A batch which creates a table with a default referencing global variable

and inserts to this table fails producing stack trace in the errorlog file.
Workaround Description
 create the table in a separate batch from INSERT/UPDATE statements.



CR:353810
CR Number:   353810
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)
06 Jul 2004 Fixed
12 Jul 2004 Fixed
Description
With the statment cache enabled, queries containing temporary tables in subqueries where

being cached in error.



CR:353866
CR Number:   353866
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2004 Fixed
Description
A user trying to log into the server may be blocked forever if the master database

is quiesced.



CR:353953
CR Number:   353953
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2005 Presently Not Targeted For Any Future Release Of This Product
10 Feb 2005 Fixed
21 Feb 2008 Added to user documentation
Description
The fix displays percentage completion of data transfer for DUMP DATABASE and LOAD DATABASE. The percentage is not displayed for DUMP/LOAD TRAN.



CR:353989
CR Number:   353989
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for a new option whereby only the login who owns the particular database

can access it.



CR:354011
CR Number:   354011
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2004 Fixed
Description
Customer would like a column added named "ID" which would be the Column ID, just like the older 12.0 C++ version where the Customer would be able to sort the columns.



CR:354012
CR Number:   354012
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)
01 Oct 2004 One-off Provided
24 Sep 2004 Fixed
Description
In rare circumstances, Adaptive Server may write incorrect log

records for updates of DOL tables that are replicated. This

only happens for replication log records and can affect the

repagent.



CR:354164
CR Number:   354164
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)
29 May 2009 Insufficient priority to fix
Description
The Transact SQL GUIDE States:

"You cannot include a union clause in a subquery unless it is part of a derived table expression within the subquery."



The Customer is running a Query with a Union inside a subquery See below. The Error Message Also Below Suggests that the parser needs to have the Parens match up before the UNION. This syntax seems to be support by DB2???



CR:354207
CR Number:   354207
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2006 Insufficient priority to fix
Description
Customer would like a request for Sybase to support Dynamic Intimate Shared Memory (DISM)in future ASE releases.



CR:354208
CR Number:   354208
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2004 Fixed
24 Jun 2004 Fixed
02 Jul 2004 Fixed
Description
Cannot Delete an Extended Stored Procedure in the 12.5.2 version of the ASE Plug-in.



CR:354215
CR Number:   354215
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 Bundled Request
Description
Add indexes to work tables used by sp_sysmon to improve performance.



CR:354231
CR Number:   354231
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2004 Fixed
Description
Workaround Description
 Have to explicitely mark tables for replication



CR:354273
CR Number:   354273
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)
07 May 2004 Fixed
08 Nov 2010 Presently Not Targeted For Any Future Release Of This Product
Description
While using Large Memory Feature in ASE 12.5.2, if "extended cache" size is increased from a

size > 4G, then it may lead to incorrect size calculation and may result in extended cache corruption.
Workaround Description
 This workaround can be used provided the size is not exactly 4GB.



- Set the extended cache size to '0' and then set it to the required size.



CR:354281
CR Number:   354281
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)
28 May 2004 Fixed
Description
The message "current process infected with 11" in the module 'memshrink' together with a stack trace which includes the modules 'cri_physbuild' and 'cri_bldindex' may be reported in the error log when a DUMP DATABASE statement is run at the same time as a CREATE INDEX, SELECT INTO or BCP. The diagserver will return error message 3205 in this case.



CR:354359
CR Number:   354359
Product Name:   Adaptive Server Enterprise
Product Component:   charsets
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2004 Duplicate
Description
Would like UTF-8 have sort order Dictionary order, case & accent insensitive



CR:354428
CR Number:   354428
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)
11 Jul 2004 Fixed
Description
Msg. 207 "Invalid column name" can be raised when executing a SELECT using a derived table

expression containing SELECT and UNION whereby one side of the UNION contains a subquery.
Workaround Description
 rewrite query



CR:354511
CR Number:   354511
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)
14 Jun 2004 Fixed
Description
Msg. 156, "Incorrect syntax near ELSE" is raised when executing an IF ELSE construction whereby the

SQL statement in the IF block is cached using the Statement Cache feature.
Workaround Description
 disable statement cache feature



CR:354578
CR Number:   354578
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2004 Fixed
Description
CIS: sp_passthru is not returning the correct @rowcount value when no rows are fetched or

affected by the pass-through query.



CR:354585
CR Number:   354585
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)
03 Jun 2004 Fixed
Description
A batch executing the sequence of statements: CREATE CLUSTERED INDEX on a table and then UPDATE table may fail with error 629, "Clustered index row entry for data page # is missing in index page # of table `tabname` in database 'dbname'; index row contains data page # instead. You can recreate the clustered index to fix this error Xactid is (xactid)."



CR:354609
CR Number:   354609
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)
21 Jun 2004 Fixed
26 Jul 2004 Fixed
Description
The error 208 will be incorrectly raised when trying to access an object

that is qualified with the database name that is enclosed in double

quotes and SET QUOTED_IDENTIFIER is ON.



CR:354650
CR Number:   354650
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)
07 Jul 2004 Fixed
07 Jul 2004 One-off Provided
Description
Noticeable performance degradation is observed in query performance when migrating to

ASE 12.5.0.3 and later versions on IBM 64bit platform built on AIX 5.1 OS

(ASE version string reported by 'dataserver -v' has "AIX 5.1" rather than "AIX 4.3.3").



CR:354663
CR Number:   354663
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2004 Fixed
14 Jun 2004 Fixed
25 Jun 2004 Fixed
27 Jun 2004 Fixed
25 Jun 2004 Fixed
27 Jun 2004 Fixed
23 Aug 2004 Duplicate
25 Jun 2004 Fixed
Galaxy 08 Jul 2004 Fixed
02 Aug 2004 Fixed
30 Sep 2004 Fixed
12 Aug 2004 Duplicate
29 Oct 2004 Fixed
Description
Need to Support Long Identifiers for all System Stored Procedures

- Have added/modified some 20 stored procedures ( see CR description for list of SP )to support Long Identifier ( 255 ) and used sp_autoformat to format the output.



qpgalaxy_amats test PASSED.



CR:354727
CR Number:   354727
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)
03 Jun 2004 Fixed
Description
When the Statement Cache is enabled and a normalization error occurs, the keepcounts of other statements in the batch may not be decremented resulting in incorrect keepcounts. This prevents these statements from ever being purged using DBCC PURGESQLCACHE.



CR:354762
CR Number:   354762
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2004 Fixed
Description
The roles JS_ADMIN_ROLE, JS_USER_ROLE and JS_CLIENT_ROLE were incorrectly added to the catalog as user defined instead of system roles.



CR:354763
CR Number:   354763
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2006 Fixed
Description
Improper parameter setup for messagess 6503/6506/6507/6516/6519/6530/6542

in mount.c



CR:354768
CR Number:   354768
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)
21 Jun 2004 Fixed
19 Oct 2004 Insufficient priority to fix
Description
Allocate memory for EJB connection sockets only under traceflag -T 1642.

This new default behavior change eliminates unused memory reserved for

EJB server when EJB server is not configured so that more user connections

can be configured for the ASE server.



CR:354772
CR Number:   354772
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)
01 Jun 2004 Fixed
Description
When the 'number of user connections' is configured to a large value (around 30000),

ASE may fail to start due to a timeslice error in module 'dbt__getfree' after

the message 'Opening Master Database ... ' has been reported in the error log.



CR:354775
CR Number:   354775
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
option to flush data from montable to user table periodically.



CR:354798
CR Number:   354798
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)
06 Jul 2004 Fixed
20 Jul 2004 One-off Provided
Description
Traceflag 7842 can be used to log a diagnostic message when a client cancels an operation.

Traceflag 7843 can be used to reverse the changes from bugfix 269372 for situations where

an existing application relies on the previous (incorrect) behaviour of ASE attention handling.



CR:354813
CR Number:   354813
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)
14 May 2004 Fixed
20 May 2004 Fixed
Description
Internal upgrade of a database fails with error 247 "Arithmetic overflow

during implicit conversion of INT NULL value '####' to a SMALLINT field".

This error occurs in databases where user id in SYSUSERS is greater than

32768.
Workaround Description
 bcp out sysusers and delete any user with uid > 32767 before doing the upgrade.

Restore the uids after the upgrade is done.



CR:354936
CR Number:   354936
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2004 Fixed
Description
In rare circumstances, ASE may report a timeslice error in the module

'lm_internal_ctxchain_release' if a session has acquired a very large

number of locks. If the lock manager spinlock is held at this point,

the server will crash.



CR:354958
CR Number:   354958
Product Name:   ASE Replicator
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.5.2.301
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.2.302P1 08 Jun 2004 Fixed
Description
ASE Replicator: Usage command has garbled text when running aserep /?



CR:354961
CR Number:   354961
Product Name:   ASE Replicator
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.5.2.301
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.2.302P1 09 Jun 2004 Fixed
Description
ASE Replicator: On Windows, if the default system locale is set to French, "corrupted" characters may be seen instead of e with accent, o with circumflex, etc. There does not seem to be a straight-forward way to force Windows to use a specific charset. So, instead, that info can be directly provided to ASE Replicator. To provide the default charset to ASE Replicator, do the following:

Edit the $SYBASE/RPL-12_5/bin/aserep.[bat|sh] script and add the "-Dfile.encoding=xxx" parameter to the JRE command line where "xxx" is a valid *Java* charset. For example:

"%JRE%" -Xmx64m "-Dfile.encoding=Cp850" "-Dinstall.root=%SYBASE_DIR%\RPL-12_5" -classpath

"%SYBASE_DIR%\RPL-12_5\classes\aserep.jar;%SYBASE_DIR%\jConnect-5_5\classes\jconn2.jar;%SYBASE_DIR%\jConnect-5_5\classes\jTDS2.jar;%CHARSETS%" com.sybase.replite.RepLite %*

The Java charsets that display the French unicode characters correctly are cp437, cp850, cp852, and cp858, specifically, the charsets that are MS-DOS compatible. Other Latin charsets do not work and display "corrupted" characters.



CR:354967
CR Number:   354967
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 Jun 2004 Fixed
Description
Monitor GUI will display only in English



CR:354984
CR Number:   354984
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2004 Fixed
18 Jun 2004 Fixed
Description
A 694 error, " An attempt was made to read logical page '<pageno>', virtpage '<pageno>' from virtual device '<devno>' for object '<objid>' in database '<dbid>'. The page was not read successfully. You may have a device problem or an operating system problem." may be reported under rare circumstances when CREATE INDEX and DUMP DATABASE are running concurrently and the server has large pools configured.



CR:355004
CR Number:   355004
Product Name:   ASE Replicator
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.5.2.301
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.2.302P1 28 May 2004 Fixed
Description
ASE Replicator: When trying to start ASE Replicator, a SQLException "S0022 column not found" error occurs.



CR:355017
CR Number:   355017
Product Name:   ASE Replicator
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.5.2.301
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.2.302P1 28 May 2004 Fixed
Description
ASE Replicator: When a single quote mark is not doubled in the resource message, two things can happen: (1)the quote mark does not show up in the localized message and (2)if there is/are parameter placeholder(s) in the resource message, then the actual values do *not* show up in the localized message; instead, the placeholders themselves show up.



CR:355057
CR Number:   355057
Product Name:   Adaptive Server Enterprise
Product Component:   sqldbgr
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2004 Fixed
01 Apr 2005 Fixed
Description
When there is a rollback transaction as a part of a stored procedure,

and we try to debug that stored procedure using the sql debugger, we may

hit a null pointer exeception.

Stacktrace with the following modules may be seen on the errorlog:

sqldbg__sendtrace, dbgrpc_control.



sql debugger will flag an error message like the following

(sqldbg) next

SQLException: JZ0SG: CallableStatement

返回的输出参数比应用程序为之注册的要少。

(sqldbg) next

SQLException: JZ006: 捕获到 IO

例外:com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: 连接已关闭。
Workaround Description
 There is no workaround for the bug hit.



CR:355069
CR Number:   355069
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)
21 Sep 2004 Fixed
17 Sep 2004 Presently Not Targeted For Any Future Release Of This Product
Description
'created' column in sp_helpdb output may be truncated when server charset is utf8 and language is Japanese, Chinese, or Thai.



CR:355108
CR Number:   355108
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   NA
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2004 Fixed
Description
When two instances of the same shared memory dump condition occur at almost the same time, it is possible for the number of shared memory dumps created to exceed the configured maxdumps value for that dump condition.



CR:355183
CR Number:   355183
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)
21 May 2004 Fixed
21 May 2004 Fixed
16 Feb 2005 Presently Not Targeted For Any Future Release Of This Product
Description
ASE 12.5.2 running on RHEL 3.0 Linux reports that (RT) Posix Async disk I/O is in use

where as Kernel Async disk I/O is in effect. This is because the O/S KAIO functionality

moved from the vsys_io driver making direct KAIO system calls from librt.



CR:355196
CR Number:   355196
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)
21 Aug 2007 Fixed
19 Jul 2007 Reservation Made
13 Aug 2007 Reservation Made
Description
Make replication awake of cluster environments.



CR:355198
CR Number:   355198
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2004 Fixed
Description
The deadlock information reported when the configuration option

'print deadlock information' is active has been enhanced such

that the line number and the nesting level of the given procedure

are also reported. The application, host, and transaction names

will be reported.



CR:355246
CR Number:   355246
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)
18 May 2004 Fixed
18 May 2004 Fixed
19 May 2004 Fixed
19 May 2004 Fixed
Description
Using a <VALUE> <OPERATOR ( >,<, >=, =< )> <COLUMN> construct in queries using a search

or HAVING clause with GROUP BY aggregate may return incorrect results.

The same problem may be seen in queries with the referenced column coming from a join.

The worktable transitive closure optimization is now only enabled via -T4416.

Note queries using <COLUMN> <OPERATOR> <VALUE> construct are not affected.
Workaround Description
 Use dbcc traceon(4416) to disable fix for 354231.

Or

rewrite the query to use :

AND ... COLUMN OPERATOR VALUE

instead of

AND VALUE OPERATOR COLUMN



CR:355322
CR Number:   355322
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2004 Fixed
18 May 2004 Fixed
Description
The default of number of user connections for the Developer Edition is changed

from 5 to 25.



CR:355370
CR Number:   355370
Product Name:   ASE Replicator
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.5.2.301
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.2.302P1 08 Jun 2004 Fixed
Description
ASE Replicator: On Windows, if the default system locale is set to French, "corrupted" characters may be seen instead of e with accent, o with circumflex, etc. There does not seem to be a straight-forward way to force Windows to use a specific charset. So, instead, that info can be directly provided to ASE Replicator. To provide the default charset to ASE Replicator, do the following:

Edit the $SYBASE/RPL-12_5/bin/aserep.[bat|sh] script and add the "-Dfile.encoding=xxx" parameter to the JRE command line where "xxx" is a valid *Java* charset. For example:

"%JRE%" -Xmx64m "-Dfile.encoding=Cp850" "-Dinstall.root=%SYBASE_DIR%\RPL-12_5" -classpath

"%SYBASE_DIR%\RPL-12_5\classes\aserep.jar;%SYBASE_DIR%\jConnect-5_5\classes\jconn2.jar;%SYBASE_DIR%\jConnect-5_5\classes\jTDS2.jar;%CHARSETS%" com.sybase.replite.RepLite %*

The Java charsets that display the French unicode characters correctly are cp437, cp850, cp852, and cp858, specifically, the charsets that are MS-DOS compatible. Other Latin charsets do not work and display "corrupted" characters.



CR:355375
CR Number:   355375
Product Name:   ASE Replicator
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.5.2.301
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.2.302P1 09 Jun 2004 Fixed
Description
ASE Replicator: On Windows, if the default system locale is set to French, "corrupted" characters may be seen instead of e with accent, o with circumflex, etc. There does not seem to be a straight-forward way to force Windows to use a specific charset. So, instead, that info can be directly provided to ASE Replicator. To provide the default charset to ASE Replicator, do the following:

Edit the $SYBASE/RPL-12_5/bin/aserep.[bat|sh] script and add the "-Dfile.encoding=xxx" parameter to the JRE command line where "xxx" is a valid *Java* charset.

For example:

"%JRE%" -Xmx64m "-Dfile.encoding=Cp850" "-Dinstall.root=%SYBASE_DIR%\RPL-12_5" -classpath

"%SYBASE_DIR%\RPL-12_5\classes\aserep.jar;%SYBASE_DIR%\jConnect-5_5\classes\jconn2.jar;%SYBASE_DIR%\jConnect-5_5\classes\jTDS2.jar;%CHARSETS%" com.sybase.replite.RepLite %*

The Java charsets that display the French unicode characters correctly are cp437, cp850, cp852, and cp858, specifically, the charsets that are MS-DOS compatible. Other Latin charsets do not work and display "corrupted" characters.



CR:355434
CR Number:   355434
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2004 Fixed
25 Jun 2004 Fixed
Description
sybmigrate creates indexes in the wrong order, causing unnecessary rebuilds of non-clustered indexs.



CR:355453
CR Number:   355453
Product Name:   Adaptive Server Enterprise
Product Component:   sqlloc
Status:   Closed
OS:   HP-UX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2004 Fixed
09 Jun 2004 Fixed
22 Jun 2004 Fixed
Description
For character sets that depend on external sort order files, the

sqlloc GUI tool fails to invoke the charset utility to install

a new sort order in syscharsets, prior to attempting to switch

to the new character set/sort order, and prior to installing

localized languages. As a result these latter steps fail.
Workaround Description
 use 12.5.1 sqlloc tool.



Or... Install the sort order by hand, using the charset utility, e.g.



charset -Usa -P nocase.srt roman8



*then* run the 12.5.2 sqlloc utility.



CR:355494
CR Number:   355494
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)
27 Jul 2008 Fixed
20 Aug 2008 Duplicate
11 Oct 2008 One-off Provided
Description
Under some circumstances, ASE may terminate with a stack trace showing the module stack_oflow() while attempting to recover from a stack overflow condition.



CR:355551
CR Number:   355551
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2004 Fixed
12 Jun 2004 One-off Provided
Description
When an ASE (12.5.1 and beyond) listener encounters some recoverable network errors, like client aborting a connection, when ASE is in the process of accepting the client connection, ASE may consider the error to be unrecoverable and terminate that listener. If there is only one listener, no new connections can then be established. However if a system administrator isql session is available, then listener can be restarted. This condition may be triggered by some activities like a long duration shared memory dump.
Workaround Description
 Use sp_listener start.... to start a listener



CR:355588
CR Number:   355588
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2006 Not reproducible with latest version of the product available as of Resolution Date
Description
sp_configure will fail with error 5854 due to system error 'Result too large' when there is a

file in the directory where the configuration file resides that has file name the same as

the configuration file and the suffix is larger than a long. For example, if the cfg

filename is ASE125.cfg and there exists a file with filename ASE125.2999999999, then every

time sp_configure is used to modify a configuration parameter, error 5854 is raised and no

configuration changes occur.
Workaround Description
 Place customer backup version of cfg files into a differrent directory.



CR:355652
CR Number:   355652
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Linux
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2004 Fixed
Description
Server configuration tools dsedit, srvbuild, sqlloc, sqlupgrade and asecfg, would not run on Red hat Enterprise Linux 3.0 on the Itanium architecture.
Workaround Description
 The ICU tools require the LessTif motif libraries on Itanium Linux. These libraries are not incldued by Red Hat in the Red Hat Enterprise Linux 3.0 distribution. The user can download the rpm package for the LessTif libraries from the Red Hat web site or copy it from a Red Hat Advanced Server 2.1 release onto their RHEL 3.0 system. Installing this package shoudl resolve this problem.



CR:355759
CR Number:   355759
Product Name:   Adaptive Server Generic Docs
Product Component:   Utility Guide
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2004 Fixed
Description
Document the current design of isql date format is 'mdy'.



CR:355779
CR Number:   355779
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2004 Fixed
11 Jan 2006 Fixed
02 Jul 2004 Fixed
04 Aug 2004 Bundled Request
10 Jan 2006 Fixed
Description
when 'cis bulk insert batch size' is DEFAULT, sybmigrate sets it to 100, in many cases this does not give the best performance.
Workaround Description
 Before starting the migration, set the 'cis bulk insert batch size' value on both the target and source ASE to be twice the pagesize of the destination ASE.



CR:355863
CR Number:   355863
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)
21 May 2004 Fixed
21 May 2004 Fixed
Description
On Linux 32 bit, while having disk mirroring enabled with Large memory support, there is a potential to get SEGV (segmentation fault) or cause data corruption.



CR:355877
CR Number:   355877
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2004 Fixed
03 Jun 2004 Fixed
Description
If a column of a view is defined by a CASE expression and this

CASE expression contains a existence subquery, such as 'col1' in:



create view v1 (c1, col1) as

select c1, case when exists (select * from t1 where t1.c2 > 100) then 'a'

else 'b' from t2



A query that contains a reference to 'col1' in a OR-clause or IN-list,

such as:



select c1, col1 from v1 where c1 = 5 or col1 <> 'a'



May return an incorrect value for 'col1'.



CR:356005
CR Number:   356005
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)
23 Jun 2004 Fixed
Description
A 2780 error, "maxlen (1) is less than length (2)" may be raised and

reported to the errorlog together with a stack trace which includes

the modules 'sybase_asejdbc_Param_nt_1setBigDecimal' and 'j2c_setVal'

when executing a java method that uses ASE internal JDBC driver

and tries to convert from BigDecimal java datatype to NUMERIC SQL

datatype.



CR:356027
CR Number:   356027
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)
01 Jun 2004 Fixed
12 Aug 2004 Insufficient priority to fix
Description
A 8201 error, "Keep count of descriptor ... expected to be 1. Instead 0 was found." may be reported in the error log followed by a stack trace including the modules 'proc_get' and 'des_rekeep' during the execution of a stored procedure whose previous execution had failed with the message 'current process infected with 11' in the module 'proc__setdb_plan'.



CR:356059
CR Number:   356059
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2004 Fixed
Description
The error 10353 will be incorrectly raised when a user with SSO role, and without SA role tries to read SYSSRVROLES, SYSROLES or SYSLOGINROLES.



CR:356119
CR Number:   356119
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2004 Fixed
Description
Msg. 205, "All queries in a SQL statement containing set operators must have an equal number of

expressions in their target lists.", is raised when executing a SELECT from a view which has

columns defined and containw an UNION with a SELECT and GROUP BY clause on each union-side.



CR:356151
CR Number:   356151
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The manifest file option for the UNMOUNT DATABASE command cannot be used if the server is configured for disk mirroring, even if none of the databased being unmounted are on mirrored devices. This is a feature request to remove the limitation or make it apply only to databases on devices that are being mirrored.



CR:356164
CR Number:   356164
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)
31 May 2004 Fixed
Description
The output of audit_event_name(6) incorrectly shows "Bind Defalut", instead

of "Bind Default".



CR:356284
CR Number:   356284
Product Name:   Adaptive Server Enterprise
Product Component:   DBXray
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Apr 2007 Presently Not Targeted For Any Future Release Of This Product
Description
If a database is offline, DBXray does not display any database info when you click on the database drilldown.



CR:356298
CR Number:   356298
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2004 Fixed
04 Aug 2004 Fixed
Description
Migration Tool is sometimes unable to migrate sysusers between releases.
Workaround Description
 The problem can be caused by new server roles, that already exist in sysusers on the target ASE

and clash with the id's being migrated.

Delete sysusers, sysroles entries that clash with the migration from the source ASE.



CR:356308
CR Number:   356308
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)
03 Jun 2004 Fixed
10 Jan 2006 Fixed
Description
When dbcc checkdb is run on a database in offline state, systabstats object

may be corrupted and error 7928.



CR:356329
CR Number:   356329
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2004 Fixed
Description
The command GRANT SET PROXY RESTRICT ROLE <rolename> will incorrectly restrict all the roles if the role specified id is 1023.



CR:356498
CR Number:   356498
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2004 Fixed
18 Aug 2004 Fixed
Description
During ASE startup, the error 950 may be displayed on an offline database if the configuration parameter 'enable rep agent threads' is set to 1



CR:356503
CR Number:   356503
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 Aug 2004 Fixed
Description
sp_configure converts memory requests to bytes leading to overflow errors.
Workaround Description
 Specify memory in pages.

Recall, you can have different server page sizes ... so we must convert by

change the K into pages (divide K value by with 2048, 4096, 8192 or 16384 for 2k, 4k, 8k and 16k

pages size respectively)



eg 12.5G = 13107200K or on a 2k server works out as 6553600 2k pages

Try sp_configure "max memory", 6553600



This is roughly 12.5 G.



This is roughly 12.5 G.



CR:356606
CR Number:   356606
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2004 Fixed
06 Aug 2004 Bundled Request
Description
sybmigrate can fail to connect source and target servers if the sybmigrate databases have been cleared down, but remote servers remain from previous migrations.
Workaround Description
 Check for entries in sysservers like mtrs$1 from the source ASE that might be left after previous migrations.



CR:356679
CR Number:   356679
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)
22 Jul 2004 Fixed
29 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
In rare circumstances, ASE may use the wrong key for an index when the sort-merge join is chosen for a query with an ORDER BY clause
Workaround Description
 sp_configure "enable sort-merge join and JTC",0



CR:356700
CR Number:   356700
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)
29 May 2009 Insufficient priority to fix
Description
Feature request to include hostname and program_name columns of Sysprocesses system catalog.

If program_name is not set by the client application, process name of the client will be stored in program_name column of Sysprocesses.



CR:356732
CR Number:   356732
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Install Guide-Adaptive Server Enterprise
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2004 Fixed
Description
Documentation for 11.5.1, and 11.9.x, and 12.0, and 12.5 had a section in the platform specific installation guides called "Adaptive server specifications" which contained a lot of ASE server min and max limits.

Starting with the 12.5.1/12.5.2 installation guides, the platform specific "Adaptive server specifications" only contain default stack size, minimum RAM and memory per user connection. The generic Configuration guide for Unix contains the rest of the specifications that used to be in the platform specific guide (however nothing for NT or Linux)



Suggestion to RE-add the missing information back to the platform specific guides, or document how to retrieve this information once the ASE server is running:

dbcc traceon (3604)

go

dbcc serverlimits

go

Here is what is documneted now inteh 12.5.2 install guide for NT:



Table 1-2: Adaptive Server specifications on Windows NT Hardware and memory



Minimum RAM required for Adaptive Server

48MB

21,504 2K pages



Minimum RAM per additional user

63K

With default stack size, packet size, and user log cache size. This value depends on the connection needs. See the System Administration Guide for information about configuring memory.



Default memory per additional user

402K 100K

with Java enabled. with Java disabled.



Java is enabled by default.



Default user stack size

41K



CR:356772
CR Number:   356772
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2004 Fixed
Description
Historical Server may sometimes report the wrong server name in a monitoring view.



CR:356785
CR Number:   356785
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2004 One-off Provided
05 Jun 2004 One-off Provided
21 Jun 2004 One-off Provided
07 Jul 2004 Fixed
29 Jun 2004 One-off Provided
28 Feb 2005 Not a Bug
28 Aug 2005 One-off Provided
Description
ASE 12.5.0.3 ESD#4 running on HP-64 platform after a few days suddenly becomes very slow,

triggered by high network activity. Incoming network I/O is very high, ASE engines use 80% to

100% of CPU at Operating System level, but do not perform any useful work. New incoming

connections are most of the time refused, effectively ASE seems to be hung.



CR:356826
CR Number:   356826
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)
20 Jul 2006 Fixed
Description
The fix displays percentage completion for create, alter, drop and load database commands.



CR:356833
CR Number:   356833
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)
07 Jun 2004 Fixed
04 Aug 2004 Presently Not Targeted For Any Future Release Of This Product
Description
The builtin CONFIG_OPTION is not being audited for commands SET_APF_SIZE (17), BOOTSTRAP_CONFIG (18),

UNIT_NORMALIZE (20), RESOURCEMONITOR_VALUE (22) and SETCONFIG_NOWRITE (23).



CR:356855
CR Number:   356855
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2006 Fixed
31 Aug 2006 Fixed
Description
A 6.92.1.1 error, "OPERATOR: The version of the label format on the volume mounted on device \\.\tape0 is different from the current version.Replace the volume with a new volume to be overwritten." is reported on executing the second dump database command to the tape if Backup Server was started with switch "-b".



CR:356894
CR Number:   356894
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)
30 Mar 2005 Fixed
01 Aug 2005 Fixed
Description
Issue the message reporting that there are insufficient spinlock monitors to monitor all allocated spinlocks only once for each time the server is booted.



CR:356899
CR Number:   356899
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)
28 Dec 2004 Fixed
Description
Request to add the owner name to the object name in message 11031: "Execution of %S_MSG %.*s failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate %.*s" The portion "Please drop and recreate" should specify the procedure in owner.name format.



CR:356906
CR Number:   356906
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)
29 Jul 2004 Fixed
13 Aug 2004 Fixed
Description
Signal handling is changed from a limited POSIX to a full SA_SIGINFO set providing

more accurate information when exceptional behavior is encountered within ASE.



CR:356931
CR Number:   356931
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jan 2006 Fixed
Description
Enhancement: Replication Agent delay startup parameter.

Make it possible to start replication agent with some delay time after starting ASE.
Workaround Description
 possibilities:



a. Have scripts to control the startup: make sure the RA is shutdown prior to reboot the ASE and

Rep Server. Then because the RAs were down, ASE will not attempt to startup the Rep Agent.

Then have a script that starts up the Rep Agent in the "timed" order.



b. RSSD should come on-line first: This helps but does not cure the problem. Even when the RSSD

comes up first, primary databases trying to connect, may not find a Rep Server waiting to accept their

connections, therefore the message of "unable to connect" is thrown, and in this customer's case,

results in a page.



CR:357012
CR Number:   357012
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Expand some MDA columns from 30 to 255 bytes.



CR:357025
CR Number:   357025
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2004 Fixed
Description
Under some circumstances, the error "current process infected with 11" followed by a stack trace that includes the module 'netp_checkextfds' may be reported. This results in a shutdown of ASE.



CR:357034
CR Number:   357034
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
Add documentation for error 12822 to doc set.



CR:357046
CR Number:   357046
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)
21 Jan 2005 Fixed
Description
If ASE is booted with trace flag 12628, data insertion into Data Only Locked tables having nonclustered index will be done with the index prepend mode splits disabled, in order to improve disk space utilization.



CR:357054
CR Number:   357054
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2009 EOL'd version. Not to be Fixed.
Description
Customer would like a port to DEC Alpha Digital UNIX Tru64 as soon as possible.
Workaround Description
 *** Wednesday, June 02, 2004 10:32:22 AM *** cooperg ***

Workaround proposed is not acceptable to customer.



CR:357112
CR Number:   357112
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)
18 Apr 2005 Fixed
09 Mar 2006 Fixed
Description
INDEX: Occasionally a covered index is not used for query involving partitioned table





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

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,16.x,17.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使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

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
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


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

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


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

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------