提供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:288146
CR Number:   288146
Product Name:   Adaptive Server Enterprise
Product Component:   asecfg
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 14 Feb 2003 Fixed
Description
If users run "asecfg" without having the "DISPLAY" environment variable set, segmentation fault will occur.



CR:288167
CR Number:   288167
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jun 2002 Fixed
15 Jul 2002 Fixed
Description
In very rare cases, during failover, 692 errors may happen on objectid 31. This may cause failover to fail during mount of the master_companion database.



CR:288168
CR Number:   288168
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   IRIX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2002 Fixed
Description
The message "Msg 10334, Level 18, State 135: Line 1:

Permission related internal error was encountered.

Unable to continue execution." will be reported by

the stored procedure sp_helprotect if DBCC or

SELECT GET_APPCONTEXT|SET_APPCONTEXT|RM_APPCONTEXT|LIST_APPCONTEXT

have been granted to any user or role, and auditing

is enabled.



CR:288186
CR Number:   288186
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)
19 Jan 2004 Insufficient priority to fix
Description
If process which has initiated a shutdown is killed with kill spid command, the shutdown does not happen , but new connections get problems



CR:288226
CR Number:   288226
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2003 Fixed
02 Jan 2003 Fixed
28 Mar 2007 Fixed
03 Jan 2003 Fixed
Description
User can enter default, identity or in row/off row for a column in Table Editor.



CR:288241
CR Number:   288241
Product Name:   Adaptive Server Enterprise
Product Component:   FTS SDS
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2003 Fixed
Description
The EFTS will now return an integer value for the total number of documents that match the search criteria. This will be returned in a new pseudo column called total_docs.



CR:288291
CR Number:   288291
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2002 Fixed
Description
When "tempdb_space" resource limit is exceeded and client is killed the corresponding

message with the reason is not sent to the client immediately. The message is now

sent immediately to the client.



CR:288339
CR Number:   288339
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2002 Fixed
08 Sep 2002 Fixed
Description
CIS: The message "current process infected with 11" in the module 'getnext_ctlib_subst', together with a stack trace may be reported in the error log when a client process exits abnormally, or a network error is encountered.



CR:288379
CR Number:   288379
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2013 Insufficient priority to fix
01 Jul 2005 Fixed
30 Sep 2004 Fixed
14 Aug 2008 Fixed
24 Aug 2008 Fixed
01 Sep 2008 Fixed
28 Feb 2013 Consult Complete
Description
Some error messages that used to report object id were updated to also report partition id if they

apply to single partitioin.



CR:288408
CR Number:   288408
Product Name:   SQL Remote for Adaptive Server Enterprise
Product Component:   SQL Remote for Adaptive Server Enterprise
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.2 3471 26 Jun 2002 Fixed
8.0.1 3017 26 Jun 2002 Fixed
8.0.0 2316 26 Jun 2002 Fixed
7.0.4 3347 26 Jun 2002 Fixed
Description
If ssqueue was running in verbose mode, replicating char or varchar columns that contained a percent sign, "%", would have caused ssqueue to crash. This problem has been corrected.



CR:288436
CR Number:   288436
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2002 Fixed
28 Jun 2002 Fixed
Description
In the Migration Tool, user can not select to migrate the "Server Data" if the target ASE is on NT platform.
Workaround Description
 On the target NT ASE, drop the XP server name and "mon_user" login before running the "setup" session.



CR:288442
CR Number:   288442
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2002 Fixed
12.5.1 16 Jan 2003 Bundled Request
Description
Able to read ASE interfaces that contains empty line feeds or interfaces that contains comments symbol # between entries



CR:288467
CR Number:   288467
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2002 Fixed
Description
When updating an ASE resource property (with the command scrgadm -c ) in Sun Cluster 3.0,

if the resource property name is not specified in exact case, the update will not give any

error eventhough the supplied value for the resource property is invalid/wrong

(and hence the ASE resource might not work as expected).



CR:288468
CR Number:   288468
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6/20 09 Jul 2002 Fixed
6/20 25 Oct 2002 Fixed
Description
Bulk copy in to a proxy table may result in few rows or no rows being transfered to remote table.
Workaround Description
 sp_configure "cis bulk insert array size",1

setting this option will be a workaround.



CR:288483
CR Number:   288483
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2002 Fixed
Description
sp_monitorconfig "number of locks" reports number of lock structures allocated rather than number of locks allocated. It takes 3 structures for each lock allocation.



CR:288502
CR Number:   288502
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2003 Not a Bug
Description
Wrong data may be returned when select from a proxy table and the local server has default character length bigger than remote server (i.e local server utf8, remote server iso-1) this happen if the character received by local server will be converted to more bytes.



CR:288522
CR Number:   288522
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)
17 Feb 2003 Fixed
08 Jan 2003 Fixed
Description
Implemented memory management hints to increase the performance of sort with
large configurations of "number of sort buffers".
Workaround Description
 Don't increase the value of "number of sort buffers".
Let it to its default value of 500.



CR:288545
CR Number:   288545
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2002 Fixed
16 Sep 2002 Fixed
Description
For database properties under the General tab, if user attempts to change the creator of that database and select the creator's properties on the "Select a user for the creator" dialog. User will hear a "beep" sound and prevent him/her from accessing the creator's properties page. This problem is fixed.



CR:288557
CR Number:   288557
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2002 Presently Not Targeted For Any Future Release Of This Product
05 Mar 2003 Fixed
Description
Once a database is restored from backup, there was no means of bringing it online using aseplugin. Now a 'Online' context menu is added to database, facilitating this.



CR:288566
CR Number:   288566
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2003 Fixed
Description
srvbuild utility fails on Tru64 version 5.1a
Workaround Description
 Use the 12.5 GA version of svrbuild.



CR:288620
CR Number:   288620
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2002 Fixed
10 Sep 2002 Fixed
Description
The Asynchronous disk I/O subsystem within ASE is equipped with an
additional traceflag allowing for instrumentation on initialization
and erroneous o/s conditions. (-T1640).

The Asynchronous disk I/O subsystem changes are generic towards Sun
Solaris 8 and Linux RH7.2 and RH Advanced Server 2.1 and up where both
platforms by default follow a Kernel Asynchronous disk I/O strategy and
where not supported fall back on the (RT) Posix Asynchronous disk I/O
strategy. The use of (RT) Posix Asynchronous disk I/O can be forced by
booting the server with traceflag 1630.



CR:288631
CR Number:   288631
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2002 Fixed
29 Aug 2002 Bundled Request
Description
For Database Device properties tab, change sentence from "First Virtual Page Number" to "First virtual page number" and "Last Virtual Page number" to "Last virtual last number"



CR:288643
CR Number:   288643
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2002 Fixed
29 Aug 2002 Bundled Request
Description
Database Device properties under Mirror tab, radio button text is corrected to "Disable temporarily" from "Disable temporary"



CR:288648
CR Number:   288648
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2003 Presently Not Targeted For Any Future Release Of This Product
24 Feb 2003 Fixed
06 Mar 2003 Fixed
Description
A 10330 error will be incorrectly raised when SELECT permission

has been granted to read from a table, but the table name is a

built-in function name.
Workaround Description
 1. Use sp_rename on table, grant and sp_rename again it should work

sp_rename log, alog

grant all on alog to login2

sp_rename alog, log

2. create table as dbo.tablename and then grant

3. create table and then grant on dbo.tablename



CR:288675
CR Number:   288675
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2002 Fixed
04 Feb 2003 Fixed
12 Mar 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Foreign Key Wizard, correct title to "To Which Columns Does it Refer" from "To Which Columns Does its Refer"



CR:288768
CR Number:   288768
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Oct 2006 Fixed
21 Dec 2006 Fixed
Description
User having permission to execute sp_modifystats can run the SP on any table without checking the permissions of executing user on the target table



CR:288781
CR Number:   288781
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2003 Duplicate
16 Jul 2003 Not a Bug
Description
On Solaris 7 Operating System, occasionally SIGALRM signals may not be delivered to ASE 12.0

(any 12.0 version) as expected. This can result in sp_sysmon encountering "Divide by zero occurred"

message or sp_sysmon hanging. The SIGALRM issue has been identified by Sun as an error in the

Solaris operating system, Sun Bug ID 4716436. Contact Sun Support for resolving this problem.
Workaround Description
 Use traceflag 1631 and 1633.

Under 1631 and 1633 traceflags, only Signal ASE deals with will be SIGALRM.

So there is a smaller window for loss of signals.



CR:288788
CR Number:   288788
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2006 Fixed
07 Jan 2008 Added to user documentation
Description
Enhanced sp_who output to include the name of the temporary database

used by the spid.



CR:288811
CR Number:   288811
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2002 Fixed
01 Aug 2002 Fixed
Description
In Migration Tool, if user doesn't fix the warning server configuration values in the "setup" session, he or she will not able to continue nor restart the session. The user would get the error msg "Attention: Summary configuration check failed." and can not continue.
Workaround Description
 Look at "setup" session log file. Fix all the server configurations Migration Tool warned about.



CR:288820
CR Number:   288820
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2003 Fixed
Description
A 'Code' panel is available to view the code of the compiled objects (views, stored procedure, etc.).



CR:288821
CR Number:   288821
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2002 Bundled Request
05 Feb 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
SQLJ Function Properties, correct title to "SQLJ Function Properties" from " SQL Function Properties"



CR:288824
CR Number:   288824
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2003 Bundled Request
Description
DDLGen performance is poor when a database contains a large number of objects.



CR:288933
CR Number:   288933
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3/21/03 24 Apr 2003 Fixed
29 Apr 2003 Fixed
16 May 2003 Fixed
30 May 2003 Fixed
14 Jun 2004 Fixed
Description
ASE certificates with chains longer than 1 fail SSL handshake.
This fix incorporates SSL Plus library v.3.1.5 into ASE.
ASE must be used with the corresponding OCS release using SSL Plus v.3.1.5.



CR:288952
CR Number:   288952
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2002 Fixed
04 Nov 2002 Fixed
Description
If a user is bound to a specific engine via the logical process manager and that engine is in a DORMANT state at the time the user logs in, then the user process will hang.



CR:289047
CR Number:   289047
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2002 Fixed
Description
The message "WARNING: memory usage in procedure headers (<value>) does not match
memory usage count in Pss (<value>) for server process id <value>." may be reported
in the error log when a cursor including an ORDER BY or DISTINCT clause needs
to do a sort.
Workaround Description
 No real workaround, but in this case the warning message can be ignored because

it is related to wrong accounting of memory allocation, not a memory leak.



CR:289060
CR Number:   289060
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2003 Fixed
Description
ASE responds to the client app in a way that causes the client application to hang or coredump. It should be passing back an error message like

"ORA-00932 inconsistent datatypes..dco12_5ss"



Reviewed Nov 2002. Fix is targeted for a future (as yet undetermined) 12.0.x release.
Workaround Description
 use ase 12.5.01 or stop trying to access clob datatypes through an ASE 12.0.x server. 12.5 is where support for clob datatypes was added.



CR:289076
CR Number:   289076
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2002 Fixed
23 Jul 2002 Fixed
Description
After an attempt to initialize a connection to a remote server fails due to network problems,

if that remote server is rebooted, then further connection request from ASE to that remote server

fails with 7210 error. ASE must be restarted before users can once again connect to that remote server.
Workaround Description
 You may be able to add a duplicate entry (under a different server name) to the interfaces file and sysservers.
Rebooting ASE will also clear the problem.



CR:289162
CR Number:   289162
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2003 Bundled Request
Description
ASE Plugin (Java): Sybase Central does not support changes to CHAR type configuration parameters such as DEFAULT UNICODE SORTORDER.



Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.
Workaround Description
 Use ISQL or SybCentral C++.



CR:289168
CR Number:   289168
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   11.9.2.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2002 Fixed
06 Sep 2002 Fixed
Description
The message "current process infected with 11" together with a stack trace that includes the module 'lt__skip_upd_image' may be reported in the error log when DBCC LOGTRANSFER processes a data-only locked table that has a TEXT or IMAGE column.
Workaround Description
 When possible, use RepAgent thread instead of LTM



CR:289175
CR Number:   289175
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Feature request: enhance the optimizer to choose large i/os when executing an 'insert into select from' statement where the select is estimated to return many rows.



CR:289178
CR Number:   289178
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2002 Not a Bug
Description
RPC fails when executed using uid with exec privileage, fine with sa uid. This seems to be the behavior when you implement 'Mapping all remote logins to one local name'
Workaround Description
 Workaround here would be to add each user on the remote server's db as a valid user as well. But this is a tedious process when one has 100's of users on the local server that will need to be added as valid users on the remote server.



CR:289184
CR Number:   289184
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2002 Fixed
Description
An 8201 error, "Keep count of descriptor (objid=<objid>, dbid=<dbid>) was expected to

be <count1>. Instead <count2> was found" may be raised after an ALTER TABLE LOCK command

run for a user table marked for replication has been interrupted.



CR:289253
CR Number:   289253
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2003 Fixed
22 Mar 2004 Fixed
Description
When upgrading, the default permissions on the 'sysxtypes' and 'sysjars' system

tables are only established in the master and model databases and not in any other

databases. The setting of the default permissions on all system tables in all

databases is now done once only, as an upgrade step.
Workaround Description
 Manually grant select permission to sysxtypes and sysjars



CR:289287
CR Number:   289287
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2002 Fixed
13 Nov 2002 Fixed
Description
Variables defined as java datatypes can lose their values and become NULL following an error.



CR:289330
CR Number:   289330
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Unknown
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2002 Fixed
12 Jul 2002 Fixed
14 Jul 2002 Fixed
Description
CIS: The commands ALTER TABLE <table> MODIFY, ALTER TABLE <table> DROP or ALTER TABLE <table> ADD may not work properly in an HA environment when the command is executed from the secondary server.



CR:289343
CR Number:   289343
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2003 Fixed
02 May 2003 Fixed
Description
When sp_commonkey and sp_foreignkey are executed against unichar and univarchar columns, error 17566

17394 are raised.



CR:289413
CR Number:   289413
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Fixed
20 Apr 2006 Fixed
Description
Sub-optimal performance may result during the execution of

a stored procedure that uses SET ISOLATION LEVEL statement

together with conditional statements and that also accesses

temporary tables (#<table_name>) which haven't been created

inside this stored procedure.



CR:289456
CR Number:   289456
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)
15 Nov 2002 Fixed
17 Oct 2002 Fixed
24 Oct 2003 Not a Bug
02 Jan 2003 Fixed
02 Jan 2003 Fixed
28 Feb 2003 Fixed
13 Jan 2003 Fixed
07 Mar 2003 Fixed
13 Mar 2003 Fixed
Description
New functionality to support Active Passive HA Configuration on Sun Cluster3.0



CR:289547
CR Number:   289547
Product Name:   Sybase InstallShield
Product Component:   InstallShield
Status:   Closed
OS:   Generic
Original Version:   3.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2002 Fixed
3.2 10 Jul 2002 Fixed
3.0 10 Jul 2002 Fixed
3.0 10 Jul 2002 Fixed
3.0 10 Jul 2002 Fixed
3.0 10 Jul 2002 Fixed
3.0 10 Jul 2002 Fixed
Description
Made the HashMap that I used to store tabs in a TreeSet with a custom-build comparator that ensures the "Normal" tab gets placed first (or returned first) whenever sorted in the map.



CR:289550
CR Number:   289550
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2002 Third Party Problem
Description
When ASE and Repserver are configured on the same host and Repserver is down,

every attempt by RepAgent in ASE to connect to RepServer leaks one file descriptor.

This can eventually lead to "kernel nopen: accept, Too many open files" error followed

by 1605 error "server Failed to open virtual socket for new connections".



CR:289574
CR Number:   289574
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2002 Fixed
Description
When checkstorage/checkverify is aborted after completing the check
the error message will indicate that sp_dbcc_patchfinishtime can be
run to set the finish time. All required arguments for sp_dbcc_patch_finishtime
is also reported in the error message. This allows users to patch the finish time
if they want to run subsequent operation on the results of this operatin.



CR:289585
CR Number:   289585
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2002 Fixed
09 Jun 2004 Deferred
Description
Extend dbcc checkverify() to support table level checkverify
by specifying the table name along with the database name.
e.g. dbcc checkverify(testdb, mytable)



CR:289592
CR Number:   289592
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2002 Fixed
22 Jul 2002 Fixed
Description
A 4324 error may be reported together with a stack trace that includes the module 'check__ldx_time' when LOAD TRAN <db> WITH UNTIL_TIME is used to load a dump that was taken without the FOR STANDBY_ACCESS clause, but which follows the loading of a transaction log which was taken with the FOR STANDBY_ACCESS clause.
Workaround Description
 None



CR:289602
CR Number:   289602
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2002 Fixed
04 Dec 2002 Fixed
Description
ONLINE DATABASE may not roll back uncommitted transactions as

expected after either loading a transaction dump that was dumped with the

NO_TRUNCATE clause or loading a transaction dump using the UNTIL_TIME clause.



CR:289627
CR Number:   289627
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have ASE support ON DELETE CASCADE referential constraints



CR:289681
CR Number:   289681
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2002 Fixed
18 Jul 2002 Fixed
Description
When running Migration Tool in GUI mode with "-m setup", "-m migrate", or "-m validate" argument,

the Migration Tool throws a "NullPointerException" error if the "Back" button is clicked

from any of the windows.



CR:289693
CR Number:   289693
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2002 Fixed
Description
CIS: Added direct_connect class capability for identity column support.
Workaround Description
 create existing table px_mwid_02(id numeric(10,0) null, c1 varchar(10) null)

insert into px_mwid_02(c1) values('test col 1')



CR:289715
CR Number:   289715
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2002 Fixed
23 Jul 2002 Fixed
13 Aug 2002 Fixed
Description
When an ASE client is killed (for example using Operating System kill command), its corresponding

ASE task is not removed from the ASE and it continues to run the query consuming resources.
Workaround Description
 Login to ASE and instead use the T-SQL kill command.
For the current repro,

kill 10 -- @@spid value
go

will do the trick.



CR:289719
CR Number:   289719
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2002 Fixed
Description
The message " Msg 10707, Level 16, State 1: Unhandled Java Exception: java.lang.NullPointerException"

can be reported when calling the method registerOutParam() for a datatype of java.lang.Types.JAVA_OBJECT.



CR:289763
CR Number:   289763
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2003 Fixed
Description
str() function returns NULL when the length parameter is over 255.



CR:289781
CR Number:   289781
Product Name:   Adaptive Server Enterprise
Product Component:   dsedit - UNIX
Status:   Open
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
desedit does not properly handle interfaces files named like "interfaces.new" , "interfaces.old"



Reviewed Dec 2002. Fix is targeted (but not committed) for the 12.5.1 release.



CR:289788
CR Number:   289788
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2002 Fixed
Description
If a partitioned APL table has a clustered index, and the first few partitions are empty because of row deletion, dbcc checktable will report 2584 error.



CR:289802
CR Number:   289802
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)
02 Aug 2002 Fixed
08 Nov 2002 Fixed
20 Mar 2003 Fixed
Description
Incorrect results may be obtained when using the REVERSE builtin function on BINARY

data and Adaptive Server is configured with a multi-byte character set.



CR:289837
CR Number:   289837
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jul 2002 Fixed
09 Sep 2002 Fixed
Description
In rare circumstances, the message "current process infected with 11"

in the module 'th__check' together with a stack trace which includes the

module 'th_log_lct_reserve' may be reported in the error log.
Workaround Description
 The problem happens only in mixed log-segment environment

when the dynamic LCT gets too close to the highest defined

threshold. If there are several thresholds, separating them

will help, and definitely, having only one thresholds

will avoid it.



CR:289854
CR Number:   289854
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2002 Fixed
18 Jul 2002 Fixed
18 Jul 2002 Fixed
18 Jul 2002 Fixed
Description
CR 268273 caused performance problems with CREATE INDEX and UPDATE STATISTICS in 12.0.0.5 and 12.0.0.5 ESD 1 when run on large tables. This fix removes CR 268273. A new version of the fix will be available later under CR 288522.



CR:289867
CR Number:   289867
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)
28 Sep 2005 Insufficient priority to fix
Description
Feature request to add a system stored procedure that displays all logins granted a specified role.



Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.



CR:289879
CR Number:   289879
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 13 Jan 2003 Fixed
Description
DDLGen use to fail generating DDL for a default, that had comments pre-pended to the defination.

The error that was thrown was

"The specified Default is a system generated one, whose DDL cannot be generated : <def>".



CR:289901
CR Number:   289901
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Columns with dataformat=CS_FMT_NULLTERM in an Open Server application will cause Msg 11213...Column count mismatch when attempting a create existing...against the table in the Open Server applicaton.



Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.
Workaround Description
 none



CR:289920
CR Number:   289920
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2002 Duplicate
Description
A column defined with a user defined datatype that has an access rule based on it fails

when being accessed within a subquery, generates an error 207.



CR:289966
CR Number:   289966
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2002 Fixed
Description
Occasionally during shutdown of a busy HA system, the HA session of a connected client may be inadvertently removed, causing the client to receive the following message when it attempts to fail over to the secondary server: HA Login failed. Session handle not found (sys:n ses:nnnn)



CR:289990
CR Number:   289990
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2004 Fixed
17 Feb 2004 Fixed
Description
On Compaq Tru64 platform, ASE requires ssm_threshold=0.

If gh_chunks tuning is desired, the following guideline can be followed.

If gh_chunks is non-zero, shared memory page size is promoted from default 8KB to 4MB,

and those pages can ONLY be used by ASE and are wired down at boot time.

The value for gh_chunks (number of 4MB pages to be wired down) can be calculated as

"max memory"/4MB (for pre ASE 12.5 releases, "total memory"/4MB) rounded up.

For example, to allocate 2GB for ASE, set gh_chunks=(2048MB/4MB)=512.



CR:289999
CR Number:   289999
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2002 Fixed
12 Sep 2002 Fixed
Description
The message "process infected with 10" may be reported in the error log together with a stack trace

which includes the modules 'senderror', 'd_upgradeobj' and 'exec_dbcc' if the command DBCC

UPGRADE_OBJECT is used to upgrade a compiled object containing a view on a table which does not

exist.
Workaround Description
 the problem happens when upgrading stored procedure that creates temporary

table from a view and view references non existing object.

Simply avoid such scenario.



CR:290024
CR Number:   290024
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2002 Bundled Request
21 Oct 2002 Bundled Request
09 Oct 2002 Bundled Request
Description
User message for failure of engine offline command is not descriptive of the reason for failure and needs to match the corresponding message logged in the error log



CR:290041
CR Number:   290041
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2002 Fixed
11 Sep 2002 Fixed
Description
In the "Available Database Devices" dialog box of Create Database wizard, the default size of database will be the larger of the size of the model database or the default database parameter in sysconfigures.
This matches the requirement in Sybase ASE Reference Manual Volumn 2:Command in create database.



CR:290067
CR Number:   290067
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have a command something like REORG COMPACT that would work to defragment text and image allocations for a table (i.e. combine partially used extents and deallocate unused space).
Workaround Description
 If the text or image column contains values that were updated to null, some space may be recovered using sp_chgattribute to turn "dealloc_first_textpg" on for the table and then update the null values to null again.



To fully compact the text/image chain, bcp the table out, truncate, bcp back in. Be careful about specifying a large enough textsize parameter, or the text will get truncated. (!)



Alternatively, if there is enough space in a regular database on the system, select the primary key and text/image column values into a holding table (not in tempdb! - don't want to lose the data if the server goes down. Be sure "dealloc_first_textpg" is set on and update the text/image columns in the original table to null, which should deallocate all but the first extent. Then update the rows using the values from the holding table and drop the holding table.



CR:290070
CR Number:   290070
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   macosx
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2002 Fixed
16 Sep 2002 Fixed
Description
If database is created with "For Load" option, 'delete', 'restore', 'properties' can be called from its menu.'
If database is "Suspect", only 'delete' can be called from its menu.



CR:290080
CR Number:   290080
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2002 Fixed
01 Aug 2002 Fixed
Description
If user selects any large size table or index with page size greater than 2^32 / @@maxpagesize for migration, the Migration Tool will return "IndexOutOfBoundsException" error during the migration process.



CR:290139
CR Number:   290139
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   IRIX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2002 Fixed
Description
ASE HA option support for SGI IRIX.



CR:290204
CR Number:   290204
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2003 Fixed
Description
sp_dboption cannot set "ddl in tran" for temdb under HA with proxy_db



CR:290251
CR Number:   290251
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2002 Fixed
13 Jun 2001 Presently Not Targeted For Any Future Release Of This Product
Description
CIS : The messages "CT-Library: The connection has been marked dead" and "current process infected with 11" together with a stack trace which includes the modules 'com__async_freecp_pool' and 'com_async_drop' may be reported in the error log when an attempt is made to kill a CIS connection.



CR:290256
CR Number:   290256
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2013 Deferred
Description
Feature request for a "what you select is what you inserted" variation of variable-length

datatypes, that will neither truncate trailing spaces or null bytes (which might be

significant to their application) or pad the type with additional spaces or bytes.

Rather, the datatype should simply store what is inserted.



Space savings would still occur as only as much space as is needed would be used to

store the value.

The variable-length CHAR datatype would be able to distinguish between a null, a

zero-length string "", a single space, and any number of spaces. Likewise, the BINARY

type would be able to distinguish between a null, a zero-length binary string, a binary

string containing a single null byte 0x00, or any number of null bytes.



Reviewed Nov 2002. This feature is targeted (but not committed) to the ASE 15.0 release.
Workaround Description
 1) store values with a dummy non-space character appended to the end after any trailing spaces, clients need to know to strip this character off

2) use another column to store the total width of the varchar value including trailing spaces, the client can use that information to restore the correct number of trailing spaces to the value.



CR:290314
CR Number:   290314
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2002 Presently Not Targeted For Any Future Release Of This Product
Description
After an upgrade, extended stored procedures using output parameters that were originally created with sp_addextendedproc may cause a stack trace. Redefining the procedure using the 'create procedure as external name' syntax will fix the problem.
Workaround Description
 Provide full parameter list when create an ESP if it has an output parameter, e.g.
create proc outvarchar @param1 char(10), @param2 char(10) output as external name 'testesp1'



CR:290357
CR Number:   290357
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2002 Fixed
29 Jul 2002 Fixed
Description
Migration Tool fails to validate the stored procedure even though the stored procedure was migrated successfully.



CR:290379
CR Number:   290379
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2005 Insufficient priority to fix
Description
Feature request to speed up index consistency checking by modifying dbcc checktable to use worker processes to scan and check indexes in parallel.



Reviewed Nov 2002. Feature is targeted (but not commited) for the ASE 15.0 release.



CR:290539
CR Number:   290539
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2002 Fixed
31 Oct 2002 Fixed
Description
Access rules are only applied to the first instance of a table in a FROM clause.



CR:290694
CR Number:   290694
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2002 Fixed
18 Aug 2003 Fixed
Description
Selecting the id column from a proxy table mapped to an external directory results in an overflow.



CR:290746
CR Number:   290746
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2004 Fixed
01 Jul 2003 Presently Not Targeted For Any Future Release Of This Product
05 Mar 2004 Fixed
Description
3475 or 1105 run-time errors may be raised after sp_logdevice, or

sp_dropsegment 'logsegment', or sp_extendsegment 'logsegment' have

been executed.

Alternativaly, DBCC TABLEALLOC(syslogs, full, nofix) may report a

12947 error "Syslogs free space is currently <X> pages but DBCC

counted <Y> pages. This descrepancy may be spurious if this count

was done in multi-user mode. Please run DBCC TABLEALLOC(syslogs,

full, fix) to correct it."
Workaround Description
 ----------------------------------------------------------------------

How to fix a wrong log free space value for a dedicated log database ?

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



Method 1

--------

use master

go

sp_dboption dbname, 'single user', true

go

use dbname

go

dbcc tablealloc(syslogs, full, fix)

go

use master

go

sp_dboption dbname, 'single user', false

go



Method 2

--------

use master

go

sp_dboption dbname, 'single user', true

go

dbcc dbrepair(dbname, fixlogfreespace)

go

sp_dboption dbname, 'single user', false

go



For both methods, check the output which should show the

following informational message if a correction was made :



"Syslogs free space count has been successfully recalculated.

It has been corrected to <X> pages."



CR:290820
CR Number:   290820
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2002 Fixed
09 Oct 2002 Fixed
Description
If a request is made to offline an engine whilst there is already an engine offline operation active, then the new request will wait for the existing request without generating a warning message so that the request appears to have hung.



CR:290832
CR Number:   290832
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2002 Fixed
19 Nov 2002 Presently Not Targeted For Any Future Release Of This Product
11 Feb 2009 Insufficient priority to fix
Description
When the server's default character set is configured with a multi-byte or some

single-byte Asian character sets, non-ASCII characters with ASCII equivalents

are recognized in keywords, numeric literals, and string delimiters. The

command line trace flag -T109 hereby disables this behavior, allowing only

ASCII characters to be recognized in keywords, numeric literals, and string

delimiters.



CR:290839
CR Number:   290839
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2002 Fixed
08 Sep 2002 Fixed
12 Sep 2002 Fixed
Description
CIS: A 102 error, "Incorrect syntax near <text>" and 105 error, "Unclosed quote before the character string <text>" will be reported when inserting a single-byte single quote as a string literal in Japanese EUCJIS and SJIS charsets.
Workaround Description
 There is no workaround on 12.0x except to use English server.

In the case of 12.5.0.1 higher, to use -T109 can be a W/A.



CR:290867
CR Number:   290867
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2003 Fixed
09 Jul 2003 Fixed
13 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
Description
A 624 error may be reported during the load of a transaction log that was originally dumped WITH STANDBY_ACCESS, and which follows the loading of a database, or a transaction log that was originally dumped without STANDBY_ACCESS.
Workaround Description
 None.



CR:290882
CR Number:   290882
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2003 Fixed
04 Nov 2005 Not a Bug
Description
The ASE Plugin displays all installed character sets in the character set selection menu of Logon Dialog.



CR:290887
CR Number:   290887
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2007 Presently Not Targeted For Any Future Release Of This Product
13 Sep 2007 Fixed
17 Sep 2007 Fixed
Description
The nesting limit for stored procedures and triggers has been increased from 16 to 50.



CR:290905
CR Number:   290905
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 12 Mar 2003 Bundled Request
Description
Server Config dialog should have an apply button to deploy multiple changes without quitting the screen.



CR:291009
CR Number:   291009
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Bulletin for Digital
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Appendix A in 12.0 ASE Installation Guide notes using logmon to drain the primary databases.



This is incorrect and should be updated to v12.5 Installation Guide documentation...

Chapter 8 Upgrading Sybase Servers ...

Draining the transaction logs for primary databases



Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.



CR:291114
CR Number:   291114
Product Name:   Adaptive Server Generic Docs
Product Component:   Adaptive Server Migration Guide
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2003 Fixed
Description
document shm_max increase to a value at least as big as the ASE "total memory" for version 12.5 in migration document or install document



Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.



CR:291121
CR Number:   291121
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Fixed
Description
Connections to ASE diagserver (not dataserver) from ODBC clients fails

with an assertion failure.



CR:291124
CR Number:   291124
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2002 Fixed
Description
When Unicode conversion is enabled, parsing error 102 and 105 are raised to

the query that immediately follows conversion error return such as message 2402.



CR:291143
CR Number:   291143
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2002 Fixed
Description
On servers configured with multi-byte default character sets (e.g. UTF-8),

error messages longer than 255 bytes, originating from remote servers (e.g.

backup server) are not relayed correctly to client applications.



CR:291202
CR Number:   291202
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2006 Fixed
Description
New feature: A configuration option 'start xp server during boot' has been added. This option lets user to select whether XP server to be started while booting Adaptive server.





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

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。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------