提供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:326860
CR Number:   326860
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)
03 Feb 2004 Fixed
Description
For newly installed dbccdb, the dbcc_faults table will be created as DOL table with datapages lock schmem.



CR:326863
CR Number:   326863
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2003 Fixed
16 Aug 2004 Not a Bug
Description
During start up, if an ASE engine dies, the message "current process infected with 11"

in the module 'EngineExitDiagnostics' may be reported in the error log.
Workaround Description
 No workaround for this problem



CR:326866
CR Number:   326866
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a command to modify the order of columns in a table
Workaround Description
 This can be done by using SELECT INTO with a different column order to create a new table with the desired column order, then dropping the original table, sp_rename new table to old table, create indexes, triggers, constraints, etc.



CR:326874
CR Number:   326874
Product Name:   Adaptive Server Enterprise
Product Component:   sqldbgr
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Insufficient priority to fix
Description
Feature request to have a sqldbgr command to generate a line-numbered source code listing.



CR:326878
CR Number:   326878
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2009 Fixed
Description
Optimize the cost for temporary tables when they are created and used in the same batch file.



Optimizer uses default value of 10 pages and 100 rows to estimate the cost for temp tables when they are created and used in the same batch process.



CR:326908
CR Number:   326908
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)
04 Aug 2003 Fixed
Description
The composition of the XML Management package has been changed with this release. The new definition is contained in the file $SYBASE/SYBASE-1_0/licenses/sybpkg.dat. Any customer upgrading from 12.5.0.1 or later, who has purchased the XML Management package should compare the definition in sybpkg.dat with the one in license.dat to make sure that they have the definition that includes the ASE_XML option.



CR:326912
CR Number:   326912
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)
02 Sep 2003 Fixed
Description
HA: Upon hitting 5156 error, dynamically increasing the number of devices

on both primary and secondary does not resolve the issue.



CR:326925
CR Number:   326925
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)
04 Aug 2003 Fixed
Description
Certain minor changes are needed in databases migrating from ASE version 12.5.0.3 to version 12.5.1. However, a database dumped in 12.5.0.3 and loaded to 12.5.1 will not be upgraded automatically by "online database", even though it should.



CR:326957
CR Number:   326957
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)
03 Sep 2003 Fixed
09 Oct 2003 Fixed
Description
HA: HA failback operations may result in unexpected gaps for identity columns if any.
Workaround Description
 Run "dbcc cacheremove(db_name, name_of_identity_table)" before doing sp_companion XXX, 'prepare_failback'. However, this will only work if nobody inserts data into the identity table between dbcc cacheremove() and the 'prepare_failback' sequence.



CR:326994
CR Number:   326994
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2003 Not a Bug
Description
when we execute sp_who the loginame displayed is Sybase User Name, but when one is using NT's integrated login feature, customer would like that sp_who or another stored procedure display the NT user name that is associated with the Sybase user name.



CR:327005
CR Number:   327005
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2004 Fixed
Description
Reconfiguration of configuration parameter 'user log cache size' caused an overflow

of 'total logical memory' that was undetected.



CR:327015
CR Number:   327015
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   IRIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2004 Fixed
Description
srvbuild won't create master and sybsystemprocs devices on rxvm



CR:327025
CR Number:   327025
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 Apr 2005 Fixed
Description
DBCC TEXTALLOC("all", full, nofix/fix) has been enhanced to detect/make correction for 100007 hard faults on text/image extents raised by DBCC CHECKSTORAGE.
Workaround Description
 dbcc extentzap() should help to nuke the orphan extends for the given objid/indid values.



CR:327064
CR Number:   327064
Product Name:   Adaptive Server Enterprise
Product Component:   MonitorServer
Status:   Closed
OS:   all
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2004 Insufficient priority to fix
01 Aug 2003 Fixed
Description
Client requests to the Monitor Server can experience long delays on very busy systems



CR:327076
CR Number:   327076
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)
30 Jul 2003 Fixed
30 Jul 2003 Presently Not Targeted For Any Future Release Of This Product
31 Jul 2003 Fixed
Description
An interrupt during the automatic drop of a temporary table results in an endless attempt at retrying the drop. The connection appears to hang and will accumulate a high number of writes. These connections can not be killed and the server must be re-booted to clear them.



CR:327103
CR Number:   327103
Product Name:   Adaptive Server Generic Docs
Product Component:   Adaptive Server Troubleshooting Guide
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2004 Fixed
Description
Documentation request: add a write-up on timeslice errors to the troubleshooitng guide.



CR:327200
CR Number:   327200
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2003 Fixed
Description
Syconfig and Sybatch do not create local name server on Window platform. "select @@servername" is NULL after the configuration.
Workaround Description
 The workaround is for the customer to create the local server themselves and recycle ASE, i.e.:

1) create a local server using T-SQL, where <server_name> is the name of the server as specified in the -S argument to the isql command

sp_addserver <server_



CR:327283
CR Number:   327283
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)
30 Oct 2003 Fixed
11 Apr 2004 Presently Not Targeted For Any Future Release Of This Product
Description
A NULL value may be put into non NULL TEXT/IMAGE column when performing

UPDATE statement. This is possible if the NULL is a result of an expression

or local variable value.
Workaround Description
 Change the text column to allow NULL.



CR:327309
CR Number:   327309
Product Name:   Adaptive Server Enterprise
Product Component:   DBXray
Status:   Closed
OS:   Solaris
Original Version:   3.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2003 Fixed
Description
When calculating total memory, DBXray is incorrectly using the page size as a variable in the calculation. Memory is always in 2k pages.



CR:327437
CR Number:   327437
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have string functions such as UPPER() and LOWER() enhanced to work on TEXT as well as CHAR / VARCHAR.



CR:327503
CR Number:   327503
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)
23 Oct 2003 Fixed
Description
Allow for CSMD configuration to get a memdump for error msg "ubo_object_from_slot:%s Invalid slot id %d".



CR:327534
CR Number:   327534
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2003 Fixed
19 Sep 2003 Fixed
Description
The message "current process infected with 11" in the module 'Address 0x00000000 ()' together

with a stack trace which includes the modules 'send_proc_audit' and 'cast_const_to_varchar'

may be reported in the error log if auditing is enabled and a stored procedure using Java

parameters is executed.
Workaround Description
 disable auditing



CR:327546
CR Number:   327546
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)
29 Aug 2003 Fixed
17 Sep 2003 Fixed
Description
The error 923, "User <value> not allowed in database '<value>' - only

the owner of this database can access it.", may be incorrectly raised

when trying to online a database that is setup for "dbo use only", if

the database owner in the dump has a different user id from the

database owner of the database being onlined.
Workaround Description
 Load the database with user test__2

online the database with user test__1

start using the database use user test__2



CR:327560
CR Number:   327560
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 Sep 2003 Fixed
03 Dec 2003 Fixed
Description
A INSERT...SELECT with an ORDER BY (or GROUP BY) clause containing columns that are not in the SELECT part could insert incorrectly those columns in the target table of the INSERT but only when more columns have been specified in the INSERT side than in the SELECT side.
Workaround Description
 Add NULLs in the SELECT-list and make both items of INSERT and SELECT equal.



CR:327568
CR Number:   327568
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2004 Fixed
16 Dec 2003 Presently Not Targeted For Any Future Release Of This Product
15 Jul 2004 Fixed
27 Jul 2005 Fixed
23 Aug 2004 Fixed
29 Aug 2004 Fixed
Description
CIS: When the UPDATE STATISTICS command is executed on a proxy table, CIS will

no longer issues the aggregate count SQL and the SELECT with ORDER BY statement

to the remote ASE server for gathering statistics. Instead, the new default

behavior for this will be accomplished via a new strategy that imports the

relevant statistics from the remote ASE system catalogs. This enhancement is

restricted to remote server of ASE class and may be disabled via the trace flag

11229, in which CIS will revert to the previous (old) style for gathering

statistics.



CR:327575
CR Number:   327575
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2003 Fixed
08 Aug 2003 Fixed
Description
When 16K pagesize is used on Linux, SGI or NT386 platforms running

ASE 12.5.0.3 ESD#2 or ESD#3, dbcc checkstorage results in 702 Error

"Memory request for 16896 bytes exceeds the size of single page of 16384 bytes".
Workaround Description
 Do not use a 16K pagesize server.



CR:327586
CR Number:   327586
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)
08 Jun 2004 Fixed
17 Sep 2004 Fixed
09 Jun 2004 Fixed
14 Jun 2004 Fixed
Description
Enable AES encryption algorithm for SSL.

Use traceflag 7825 to display negotiated cipher suite.



Ability to restrict to a particular algorithm or set of cipher

suites and the ability for a user to programmatically obtain

their negotiated cipher suite is being added under a separate CR.

See 231231, also scheduled for this release.



CR:327637
CR Number:   327637
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)
22 Apr 2004 Fixed
12.5.1 ESD#3 20 Apr 2004 Fixed
12.5.2 ESD#1 27 Apr 2004 Fixed
Description
JAVA: The Java IO method InputStream.available() incorrectly returns zero on 64-bit ASE VM's.
Workaround Description
 Use 32-bit ASE?



CR:327639
CR Number:   327639
Product Name:   Adaptive Server Enterprise
Product Component:   SQL Advantage
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2003 Fixed
Description
SQLAdvantage: SQLAdvantage does not display 8bit chars from unichar columns.
Workaround Description
 Use ISQL or convert(varchar(), colUni).



CR:327695
CR Number:   327695
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 Feb 2004 Fixed
Description
Error 249 may be raised when xmlextract() returns a date, int or float result.



CR:327697
CR Number:   327697
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)
04 Dec 2003 Presently Not Targeted For Any Future Release Of This Product
Description
ALTER TABLE raises syntax error 156 for the exp_row_size option when changing lock scheme to DOL from ALLPAGES.



CR:327736
CR Number:   327736
Product Name:   Adaptive Server Enterprise
Product Component:   sqldbgr
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2004 Fixed
Description
Entering sqldbgr options in different positions raise

ArrayIndexOutOfBounds Exception.
Workaround Description
 do not put -P at the end of command,

using exactly syntax as Utility Guide.



Syntax



sqldbgr

-Uusername

-Ppassword

-Shostname : port_number



CR:327744
CR Number:   327744
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)
19 Aug 2003 Fixed
16 Sep 2003 Fixed
Description
Rows may be missing from the result set of a query similar to "SELECT DISTINCT <col1>, <col_unichar> ... ORDER BY <col_unichar>"

when the ORDER BY clause contains a uni(var)char column and not all the columns in the

SELECT DISTINCT clause are in the ORDER BY clause.
Workaround Description
 Remove columns from the "ORDER BY" or add the column bugs.bug_id to the "ORDER BY"



CR:327745
CR Number:   327745
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)
29 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Feature request: add "create" as an option on sp_role



CR:327829
CR Number:   327829
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)
02 Sep 2003 Fixed
12 Aug 2003 Fixed
06 Nov 2003 Fixed
07 Nov 2003 Fixed
Description
With some search conditions, a OR query against unichar and univarchar columns may return wrong results.



CR:327860
CR Number:   327860
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)
02 Oct 2003 Fixed
26 Sep 2003 Fixed
19 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
The message "current process infected with 11" in the module 'decision' may be reported in the errorlog for queries involving joins and qualified table names.
Workaround Description
 Turn off delta project method using tf 362.



CR:327892
CR Number:   327892
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2003 Duplicate
Description
Alter table can cause an infected with 11 stacktrace.



CR:327927
CR Number:   327927
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)
09 Dec 2003 Fixed
Description
The error 3906, "Attempt to BEGIN TRANSACTION in database '<dbname>' failed because database is READ ONLY" will be raised when running the script installmaster, if there exist a database in READ ONLY mode.



CR:327963
CR Number:   327963
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2004 Fixed
Description
Merge-join two tables on cols with diff types (UNICHAR UNIVARCHAR) may give

wrong results. Also, when unique index and special-OR strategy is used for unichar

and univarcharf columns, the result set ends up containing duplicates, which are

not removed by using *distinct* in select statement.



CR:328014
CR Number:   328014
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)
11 Aug 2003 Fixed
Description
Queries that cause recursive execution of multiple levels of triggers can get a stack overflow

error with susequent server crash. The stack trace will contain multiple instances of the

function, exectrig.
Workaround Description
 Increase the configured value of the stack size.



CR:328018
CR Number:   328018
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 Oct 2003 Fixed
Description
FOR BROWSE queries using reformat strategy may not execute correctly

resulting in the error 403 "Invalid operator for datatype op: type: VARBINARY."
Workaround Description
 Provide necessary timestamp columns in the SELECT list.



CR:328075
CR Number:   328075
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.0.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2003 Fixed
20 Feb 2004 Fixed
Description
On Digital UNIX, in rare circumstances, a corrupted TDS login packet may cause the ASE server to crash.



CR:328091
CR Number:   328091
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)
19 Aug 2003 Not a Bug
Description
Select executed by non table owner causes parser error msg 107
Workaround Description
 If you are going to use table prefix then it should be used in the whole query



CR:328100
CR Number:   328100
Product Name:   Adaptive Server Enterprise
Product Component:   FTS SDS
Status:   Closed
OS:   HP-UX
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.3 26 Aug 2003 Fixed
12.5.1 ESD#2 12 Sep 2003 Fixed
Description
EFTS: can't create a text index on a source table who is owned by a different user id.
Workaround Description
 Change sp_create_text_index procedure...

FROM:

exec @stat = sp_text_index_column_type @stat, @tname,@col1, @coltype1

output



TO:

exec @stat = sp_text_index_column_type @stat, @table_name,@col1, @coltype1

output



Drop and recreate the sp_create_te



CR:328208
CR Number:   328208
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Feature request to have each dbcc command grantable to any user, without requiring specific roles.
Workaround Description
 This can often be accomplished through the technique documented at http://www.sypron.nl/grant_sa.html



CR:328211
CR Number:   328211
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)
10 Feb 2004 Fixed
Description
System functions tsequal() sends timestamp to the client as the parameter.

It may be confusing if the function is used within a stored procedure.



CR:328217
CR Number:   328217
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2010 Duplicate
Description
Feature request to enhance the EXECUTE command so that it can perform DUMP TRANSACTION
Workaround Description
 Per the ASE 12.5 Reference Manual:



You cannot supply string and char_variable options to execute the

following commands: begin transaction, commit, connect to, declare

cursor, rollback, dump transaction, dbcc, set, use, or nested

exe



CR:328246
CR Number:   328246
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)
24 Oct 2003 Fixed
22 Dec 2003 Fixed
Description
When abstract plans was turned on, the full derived table query was not being stored in sysqueryplans.



CR:328351
CR Number:   328351
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2003 Fixed
23 Sep 2003 Fixed
Description
CIS : In rare circumstances, a task which issues the "set proxy" command in a HA

environment will become hard affinity to the engine.



CR:328356
CR Number:   328356
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)
15 Aug 2003 Fixed
11 Feb 2004 Fixed
Description
A process infected with 11 error in ct_tds_senddata can occur while running the Migration Tool when the remote server runs out of user connections.



CR:328379
CR Number:   328379
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)
02 Sep 2004 Fixed
Description
Some rows in sysattributes have tab characters embedded in the char_value field. This can cause problems for character-based bcp. ASE Engineering confirms that those strings are not being used for anything, so they should be removed.



CR:328385
CR Number:   328385
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)
22 Dec 2003 Fixed
Description
Error 7429/16/1 occurs during recovery when the database option 'no free space acctg' is turned

on after some data segments are installed. This error results in the database being moved to

a suspect state.
Workaround Description
 /* Using the database mypubs2 as example */



sp_configure "allow updates", 1

go



/* Note that in 12.5.1 there is no need to run checkpoint after sp_dboption */

sp_dboption mypubs2, 'no free space acctg', false

go



update sysdatabases set status



CR:328539
CR Number:   328539
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)
02 Sep 2003 Fixed
17 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Under heavy load, the JAVA VM hits PANIC mode and leaves the VM in an inconsistent state.



CR:328575
CR Number:   328575
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)
18 Feb 2004 Fixed
19 Mar 2004 Fixed
21 Apr 2004 One-off Provided
12 Aug 2004 Insufficient priority to fix
Description
The message "current process infected with 11" in the module

'proc__reset_wktbl' together with a stack trace may be

reported in the error log when executing a stored procedure

that inserts or deletes data in a table that has more than one

self-referential integrity constraints and when Adaptive Server

is configured to use multiple user temporary databases.

Later executions of the same stored procedure may raise a

8210 error, "Keep count of descriptor...was expected to be 1...".
Workaround Description
 1. Using 'with recompile' option in create procedure for the problem stored procedure:

'create proc proc_name ... with recompile'

It instructs ASE not to save a plan for this sproc. A new plan is created each time the sproc is executed. This may have performance impact.



Or



2. Drop user defined tempdbs, but it may have bigger performance impact.



CR:328576
CR Number:   328576
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)
27 Jan 2004 Fixed
Description
When the query sp_helpconfig 'total data cache size', '4G' is executed

on a 32bit version of ASE, a signal 11 is encountered. The stack of the

terminating process indicates kisignal()->cfg__cache_mem_sizes()->

cfg__memory_check()->cfg_main()->...



CR:328689
CR Number:   328689
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2003 Fixed
21 Aug 2003 Fixed
04 Sep 2003 Fixed
Description
Correct the two dsparser errors:

If content of the interface entry is separated by tab, then the entry is not read.

Another one: If the end of line is a new line, then NullPointerException.



CR:328709
CR Number:   328709
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2003 Fixed
12 Sep 2003 Fixed
Description
Some rows may not be updated when an UPDATE statement has a FROM clause with a view containing a

UNION ALL. In some cases the UPDATE may result in the message "current process infected with 11" in the module 'update()'. A DELETE using the same view in the FROM clause will result in the message

"current process infected with 11" in the module 'norm3_setop()'.
Workaround Description
 Enable trace 4404 to prevent from having a pusdown of join- and non-join predicates when

resolving the view. (This is a non-documented traceflag !!)



CR:328730
CR Number:   328730
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)
05 May 2006 Fixed
09 May 2006 Fixed
Description
The stored procedures SP_SYSMON and SP_MONITORCONFIG may display incorrect values for the "Active" and "Max Ever Used Since Boot" fields for "Open Object Usage", "Open Index Usage" and other parameter when executed in a multi-engine ASE environment.



CR:328769
CR Number:   328769
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)
03 Feb 2004 Fixed
04 Nov 2003 Fixed
29 Jun 2004 Fixed
Description
When the server rewrites the master database on a raw partition (which requires using the "-f/orcebuild" boot-time argument and either "-w master" to rewrite master or the "-z" and "-b" flags to create a new installation), the server does not initialize every allocation page on the raw partition. A subsequent "load database master" can find allocation pages from the previous installation, which can cause spurious entries in sysdatabases and/or sysusages.



CR:328773
CR Number:   328773
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)
20 Feb 2004 Fixed
19 Feb 2004 Fixed
29 Feb 2008 Added to user documentation
23 Feb 2004 Fixed
29 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Optdiag output and traceflag 302 output enhanced to include sample percent used in gathering statistics using UPDATE STATISTICS with sampling command



CR:328806
CR Number:   328806
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2003 Fixed
22 Jun 2005 Deferred
Description
The Database folder has a total size (MB) column



CR:328812
CR Number:   328812
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)
27 Oct 2003 Fixed
Description
ASE on Solaris has TCP/IP incoming connections backlog queue limited to 5 which can

result in some of the clients failing to connect to ASE when there is a surge of incoming connection

requests to ASE. This fix enhances the backlog limit to 128 eliminating this bottleneck.
Workaround Description
 Set the Solaris kernel's tuneable parameter "tcp_conn_req_min" to 128.



CR:328836
CR Number:   328836
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)
31 Dec 2003 Presently Not Targeted For Any Future Release Of This Product
23 Feb 2004 Fixed
Description
Feature request to allow shared memory dumps write the dump file in parallel.



CR:328837
CR Number:   328837
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2009 Insufficient priority to fix
Description
Feature request for the ability to create views with a specified isolation level



CR:328888
CR Number:   328888
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)
26 May 2004 Fixed
10 Jan 2006 Fixed
Description
Database device properties dialog 'Parameters' page is removed and its content is moved to 'General' page.



CR:328896
CR Number:   328896
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2003 Fixed
12 Nov 2003 Fixed
Description
A new command line trace flag, 10305, has been added to allow

auditing the creation of temporary tables via SELECT INTO.



CR:328961
CR Number:   328961
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Solaris
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2007 Insufficient priority to fix
Description
Feature request for a command to reschedule a historical server session without having to manually delete the existing session and create a new one.



CR:328976
CR Number:   328976
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2003 Fixed
Description
DDL for a user 'guest' in a database (other than master), is not generated along with DDL for all users.



CR:329033
CR Number:   329033
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)
23 Aug 2003 Fixed
23 Aug 2003 Fixed
19 Aug 2003 Fixed
Description
Java/XML samples directory has been renamed to JavaSqlXml to better reflect the kind of sample program it contains.



CR:329088
CR Number:   329088
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 26 Aug 2003 Fixed
12.5.1 26 Aug 2003 Fixed
Description
Migration setup fails due to unique index violation error on sysusers.



CR:329096
CR Number:   329096
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 21 Aug 2003 Bundled Request
Description
The CR 329096 has been corrected as a bundle of CR 276282

The user requests Table Name to be included in the confirm delete message. As of 276282, instead of showing just the confirm message, a Delete Dialog will come up instead. It contains the name of the objects that are going to be deleted, also "Yes" and "No" button for final delete decision.



As a conclusion, the name of the tables that user request to be dropped will be shown in the ASE Plug-in Confirm Delete Dialog, so this CR is closed.



CR:329099
CR Number:   329099
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Enhance isolation level 0 to write uncommited data.



CR:329108
CR Number:   329108
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2005 Fixed
05 Jan 2006 Fixed
13 Jul 2005 Fixed
Description
sp_helpdevice reports the amount of free space on each database device
Workaround Description
 sybase Central click on device bottom, it display name, size, unused , phyname.



CR:329159
CR Number:   329159
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Closed
OS:   HP-UX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2004 Not a Bug
23 Aug 2004 Not a Bug
24 Aug 2004 Fixed
26 Aug 2004 Fixed
Description
In rare circumstances, OPTDIAG, when used in input mode, might fail with message "At step xxx of the histogram for 'xxxxxx', the step value is not increasing".
Workaround Description
 Since steps 1-2 and 3-4 have the same values compress them to get just two steps.





Actual step count: 6



Step Weight Value



1 0.00000603 < ""

2 0.00288654



CR:329181
CR Number:   329181
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)
21 Aug 2003 Fixed
21 Aug 2003 Fixed
Description
Upgrade (to 12.5.1) process hangs while trying to upgrade a database that is enabled for 'async log service'.
Workaround Description
 Disable 'async log service' in pre-12.5.1 server before the starting the upgrade process with 12.5.1.



CR:329205
CR Number:   329205
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)
09 May 2006 Bundled Request
09 May 2006 Bundled Request
Description
Add new procedure, sp_showtext, that can re-generate the text from syscomments for compiled objects

like procedures, triggers, views, so that the output matches exactly what was submitted by the user

when creating the object. Output can be generated with line numbers, and also as a context

block of SQL text around a given line number. Output can be generated as a stand-alone DDL script

which can be then used to recreate the object in most cases. Use 'sp_showtext' without any arguments

to get usage syntax help.



CR:329229
CR Number:   329229
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)
31 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
22 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
31 Oct 2003 Fixed
Description
When the sp_configure parameter "default unicode sortorder" is set to something

other than the default value "binary", search conditions '=' and 'not ='

can result in null values being selected.
Workaround Description
 Since this affects only the internally-optimized versions of

the = and not= operators, a simple (albeit ugly) workaround

for the expression "col = 'val'" is "col <= 'val' and col >= 'val'".



CR:329242
CR Number:   329242
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)
28 Aug 2003 Fixed
22 Aug 2003 Fixed
22 Aug 2003 Fixed
05 Sep 2003 Fixed
Description
CIS: In rare circumstances, sp_showplan may be infected with signal 10 or 11 and

core dumps, or causes ASE to hang in a CIS environment.
Workaround Description
 Avoiding sp_showplan should help. However, other holes may exist.



CR:329286
CR Number:   329286
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)
12.5.2 03 Feb 2004 Fixed
Description
In rare circumstances:

The scenario only happens when using java internal JDBC driver, and on text/image column

with NULL value and the user defined function has wasNull() API called on text/image column.
Workaround Description
 No work around, the bug is fixed.



CR:329300
CR Number:   329300
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)
28 Jan 2006 Fixed
13 Dec 2006 Fixed
Description
sp_autoformat now also formats datatypes integer, numeric, money, date/time, float/real, and also formats user-defined datatypes and NULL values correctly.



CR:329302
CR Number:   329302
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)
12 Apr 2005 Fixed
Description
sp_lock now returns both the object name and id for locked objects.



CR:329328
CR Number:   329328
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 Oct 2003 Fixed
21 Jan 2004 Fixed
Description
A 2603 error, "Insufficient space (<num> bytes) on logical page <page_num> of index <ind_id> for object '<obj_name>' when inserting row of length <num> bytes on index page." may be reported when an ALTER TABLE command has been previously run to change the length of a column that is part of an index.
Workaround Description
 Drop and recreate the problematic index in the error will resolve the issue.



CR:329357
CR Number:   329357
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2003 Fixed
26 Jan 2006 Fixed
Description
Able to create Column level constraint from column properties.

FromColumnproperties,select constrainttab.Click on "Add" button, Check constraint wizard starts. In the constraint expression screen, user can click the "columns" button which opens the "Paste columns for check constraint" screen and select columns to be included for the constraint.



CR:329375
CR Number:   329375
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2003 Fixed
01 Dec 2003 Fixed
21 Apr 2004 Presently Not Targeted For Any Future Release Of This Product
Description
CIS: INSERT <local table> SELECT * FROM <proxy table> inserts garbage when the proxy table has CHAR type column inserted into TEXT column of local table or BINARY type proxy column inserted into IMAGE column of local table.



CR:329430
CR Number:   329430
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2005 Fixed
Description
Feature request to put additional information regarding server name and interfaces file location in the backupserver errorlog.



CR:329444
CR Number:   329444
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2003 Fixed
Description
It is not possible to clear the "bypass recovery" indicator for the master

database if Adaptive Server is re-started after this indicator has been set.

With this fix, when Adaptive Server is booted with the 3477 trace flag, it

ignores and clears the "bypass recovery" indicator in the master database.



CR:329454
CR Number:   329454
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)
26 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
03 Nov 2003 Fixed
05 Sep 2003 Fixed
14 Sep 2003 Fixed
Description
Incorrect results may be returned for a query having more than one derived table with group by aggregates in the derived table expression.



CR:329483
CR Number:   329483
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)
29 Jan 2004 Fixed
Description
Before upgrade, when a server boots using an installation from an older version, it will produce a confusing collection of messages. The first messages say that certain databases can't be upgraded because tempdb is not available, and instruct customers to issue "online database" for those databases. The next messages say that the server is upgrading those databases.



The server DOES upgrade those databases. Customers should ignore the instruction to issue "online database".



CR:329488
CR Number:   329488
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)
03 Sep 2003 Fixed
19 Sep 2003 Fixed
Description
A 10711 error: "Cannot find a public method named '<method name>' in class '<class>'.

Either the method does not exist, or it is being called with the incorrect argument

types." may be raised when trying to execute a new method added to a java class

in a database that has been just loaded.
Workaround Description
 Drop and recreate the target database and then load the new dump into it

OR

Shutdown the server after load the database.



CR:329635
CR Number:   329635
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2003 Fixed
28 Aug 2003 Fixed
12.5.0.3 03 Sep 2003 Fixed
11 Sep 2003 Fixed
Description
ASE does not start as a service on the Windows 2003 operating system. Attempts to

start the service result in the message 'the service terminated unexpectedly'
Workaround Description
 None



CR:329680
CR Number:   329680
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2003 Fixed
23 Jan 2006 Fixed
Description
Database will be able to issue a checkpoint



Issuing a database checkpoint

A checkpoint is an automatic mechanism to guarantee that data pages changed

by completed transactions are regularly written from the cache in memory to

the database device. Each time it issues a checkpoint, Adaptive Server does the

following:

* Freezes all current data modification transactions

* Writes pages that have been modified in memory, but not on disk, since the last checkpoint, to the database device

* Writes a checkpoint to the transaction log

* Unfreezes the current transactions



CR:329758
CR Number:   329758
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2009 Insufficient priority to fix
Description
Feature requst for a PRODUCT aggregate function, similar to SUM, but multiplying the values rather than adding them.



CR:329917
CR Number:   329917
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2003 Fixed
27 Oct 2003 Fixed
19 Apr 2004 One-off Provided
Description
Execution of the DBCC CHECKSTORAGE command may take an abnormally long time to gather object information when run against a database that contains many objects.
Workaround Description
 No good workaround here. Try to make sure syscolumns is as compact as possible by running

sp_fixindex on indid 1.



CR:329919
CR Number:   329919
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)
25 Nov 2003 Fixed
Description
1. Remove dump tran tempdb with truncate_only sp_sysmon_collect

2. Excessive traceon(8399) messages occur in errorlog. Add filter.



CR:329921
CR Number:   329921
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)
20 Jan 2005 Fixed
Description
Feature request Sybase able to use OS new AdvFs "Direct I/O" feature



CR:329938
CR Number:   329938
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Install Guide-Adaptive Server Enterprise
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2003 Fixed
Description
Few doc bugs in the installation and configuration guide for ASE on Digital Unix.



CR:330061
CR Number:   330061
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2004 Fixed
Description
The Waits column of the monSysWaits table contains negative values once a large number of waits have occured for a particular WaitEventID.



CR:330066
CR Number:   330066
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)
27 Oct 2003 Fixed
Description
The message "nclose: Unknown servtype, 0" will appear in the ASE error log while disconnecting from

a remote site (such as backupserver) that uses a TLI network listener if ASE is not using a TLI

network listener.
Workaround Description
 Possible workarounds include adding a tli listener to ASE, or using either all sockets or

all tli. In the context described in this CR, the message is harmless, so a workaround

is to ignore it.



CR:330107
CR Number:   330107
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2005 Insufficient priority to fix
Description
Feature Request: allow a local backupserver other than SYB_BACKUP to be specified in the dump /

load database command.



CR:330159
CR Number:   330159
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 Sep 2003 Fixed
29 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Multiple sessions get blocked on Address locks when running Java applications.

This blocking results in a poor performance for these connections. Optimizations were made to the JAVA VM to allow more concurrency.





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

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