提供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:414960
CR Number:   414960
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Dec 2005 Fixed
10 Jan 2006 Fixed
12 Jan 2006 Fixed
Description
When you run a SELECT DISTINCT statement on a VIEW which has a UNION clause,

ASE does not eliminate duplication from the result set.



CR:414994
CR Number:   414994
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2009 Fixed
22 Nov 2009 Fixed
22 Nov 2009 Fixed
Description
When the source and target ASE are not set to the same default character set and 'enable unicode conversions' is disabled on target ASE, sybmigrate handle the case as a warning during the setup phase.



CR:415007
CR Number:   415007
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2005 Fixed
Description
Add a note that when you run "dataserver ... -w master", it will use ascii-8 as the charset rather than iso_1. Also note that this may then be modified either by loading a dump of master or with "sqlloc", which requires that sybsystemprocs be present because it runs sp_configure.
Workaround Description
 *** Monday, November 28, 2005 9:21:51 AM *** cooperg ***

Informatio0n passed along to customer by TSE.



CR:415008
CR Number:   415008
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 EC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2005 Fixed
Description
After an identity column is added to a table through alter table

without data copying, reorg rebuild on the table or "alter table

partition by..." on the table lead to column offset corruption.



CR:415027
CR Number:   415027
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2006 Fixed
24 Mar 2006 Fixed
Description
Msg. 103, 'The transactionname that starts with <name> is too long. Maximum length is 67.' is raised

using BEGIN TRANSACTION @variable whereby the @variable contains a transactionname greather then

67 bytes. Maximum allowed for a transactionname is 30.



CR:415053
CR Number:   415053
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2005 Fixed
Description
Column with type bigint, date or time cannot be encrypted. This applied to both create and alter table.

A column can not use both encrypt and compute options

These changes will be seen in Column Properties and Table Editor.



CR:415058
CR Number:   415058
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2006 Fixed
17 Oct 2006 Fixed
Description
When a user who schedules a job has a different user name on the target server than he has on the Job Scheduler server, the job does not run because the login to the target server fails at runtime.
Workaround Description
 # We need to have same user name and pwds on each server to have job completed successfully.



CR:415144
CR Number:   415144
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2006 Fixed
Description
The format of a database dump that is created with DUMP DATABASE ... WITH COMPRESSION=<level> has changed in order that the dump may be loaded into an archive database.



CR:415150
CR Number:   415150
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2005 Fixed
Description
An insert into an identity column raises an incorrect error

when the inserted value is an expression.



CR:415162
CR Number:   415162
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)
16 May 2006 Fixed
07 Feb 2007 Fixed
Description
On a heavily-loaded system, the message "The Java VM associated with process <spid> is abnormally terminated" in the jvm module may be reported in the errorlog even though the client performing the java work terminates normally.



CR:415236
CR Number:   415236
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2005 Fixed
Description
The error 8240 with the message :

"The table 'table_name' in database 'db_name' is being created

and the transaction has not been committed yet. Please retry the query later."

may be raised if the parallel query is executed on a table created

in the same transaction.
Workaround Description
 - Force serial execution



CR:415238
CR Number:   415238
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 EC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2005
31 Jan 2006 Fixed
16 Apr 2007 Fixed
03 Sep 2008 Presently Not Targeted For Any Future Release Of This Product
Description
An INSERT based on a SELECT using a derived table expression in the FROM clause and an

ORDER BY clause can generate wrong results. Only the rows from the first UNION ALL side in the

derived table expression will be inserted.
Workaround Description
 use trace 4404, disable pushdown of union all in view.



CR:415241
CR Number:   415241
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2005 Duplicate
Description
Customer would like get information from the db_table of the database from a database dump, by either using the load database command with headeronly or listonly. This can come handy if ddl's for the original database are lost and cannot be recover
Workaround Description
 *** Wednesday, November 30, 2005 6:35:12 AM *** cooperg ***

N/A



CR:415263
CR Number:   415263
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   11.5.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2005 Third Party Problem
Description
The country's legal system creaking under the strain... we need a fix!!
Workaround Description
 Hire a lot more nice legal folks and detectives to catch the bad guys and put them away for a long time.



CR:415296
CR Number:   415296
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2006 Fixed
Description
Insensitive non-Scrollable cursor sends erroneous CURINFO3 token before the final TDS_DONE token.



CR:415304
CR Number:   415304
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2006 Fixed
Description
pre-15 XML schema with a "length" attribute instead of a "maxLength" attribute



CR:415383
CR Number:   415383
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 Jan 2010 Fixed
Description
An error message "The configure size for data cache <cache name> is not sufficient to handle the sort buffers <value> requested. The data cache is waiting to claim sort buffers." will be printed to errorlog if there are no enough buffers in the cache to be claimed when doing the no-parallel sort on runtime.



CR:415386
CR Number:   415386
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2005 Fixed
20 Apr 2006 Fixed
Description
While an ASE reserved connection is in use, ASE cpu usage may be seen to rise to 100%



CR:415403
CR Number:   415403
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2006 Fixed
Description
"ddlgen" is not generating the correct sql for certain check constraints



CR:415411
CR Number:   415411
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2006 Fixed
30 Aug 2006 Fixed
Description
An UPDATE statement updating a text/image column with a FROM clause whereby the source and

target tables are in different databases could show <x> rows affected when the UPDATE

statement is finished. The affected rows however do not show any value being changed.



CR:415412
CR Number:   415412
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2005 Fixed
Description
DDLGen generates 'null' in permissions statements. For eg. for pubs2 database, 'titles' table, some incorrect statements generated are:



Grant null on dbo.titles to guest

go

Grant null on dbo.titles to guest

go



CR:415531
CR Number:   415531
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2006 Fixed
21 Dec 2006 Fixed
04 Jun 2007 Presently Not Targeted For Any Future Release Of This Product
Description
In rare case, ddlgen db is not compatible with dump/load



CR:415534
CR Number:   415534
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2007 Fixed
25 Nov 2007 Fixed
15 Jun 2007 Fixed
14 Jan 2008 Fixed
Description
Adaptive Server hangs on call to a procedure on ASA or IQ using site handler RPC.
Workaround Description
 Enable the option 'cis_rpc_handling' when calling a remote procedure on ASA server.



CR:415544
CR Number:   415544
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Insufficient priority to fix
Description
The customers infrastructure team collects version/ebf & acts accordingly after logging in to SQL Server. It has been quite a challenge for their developers to get ebf# due to constantly changing format. Going forward the customer would like us to standardize the version string and publish the format in the documentation.



Below is the output of @@version for several SQL Servers versions:

SQL Version @@version output

1) 11.0.3 SQL Server/11.0.3.3/P/Sun_svr4/OS 5.4/SWR 9122 ESD 7/OPT/Sun Jun 18 19:50:32 PDT 2000

2) 11.9.2 Adaptive Server Enterprise/11.9.2.6/1294/P/SWR 10276 ONE-OFF/Sun_svr4/OS 5.5.1/FBO/Fri May 10 02:09:30 2002

3) 12.5.3(32-bit, Linux) Adaptive Server Enterprise/12.5.3/EBF 12151/P/Linux Intel/Enterprise Linux/ase125x/1883/32-bit/OPT/Thu Nov 11 17:33:16 2004

4) 12.5.3(64-bit, Linux) Adaptive Server Enterprise/12.5.3/EBF 12897 ESD#3/P/x86_64/Enterprise Linux/ase1253/1916/64-bit/OPT/Wed Aug 3 18:14:45 2005



CR:415549
CR Number:   415549
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2006 Fixed
Description
sp_sysmon Disk I/O section uses udalloc_calls to capture counts of I/O requests, which includes both synchronous and asynchronous I/O requests. However, when we count completed I/Os, we do it using total_dpoll_completed_aios, thus only counting asynchronous completes. This is documented in CR 144252.



Customer is requesting that we change sysmon to either include both synchronous and asynch completes in the Completed output, or that we break them out into a section for synchronous and a section or asynch I/Os so we get a more accurate read on disk activity.



Customer is running Adaptive Server Enterprise/12.5.3/EBF 12417 ONE-OFF ESD#1/P/HP9000-879/HP-UX

11.0/ase1253/1899/64-bit/FBO/Tue Feb 22 19:21:47 2005 .



This problem is not version- or platform-specific, as it is written in the source for sp_sysmon_diskio, again as documented in CR 144252.
Workaround Description
 *** Friday, December 02, 2005 2:25:43 PM *** cooperg ***

N/A



CR:415564
CR Number:   415564
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2006 Fixed
Description
A 12323 Error, Level 20, State 7: "Internal error occured during rebuild of index id <indid> table <tabname> (id = <tabid>) in database <dbid> while processing page <pageid>. Run dbcc checktable to see if the index is consistent." may sometimes occur when running online INDEX REORG REBUILD on a table having the first page empty and a lot of deleted rows in the table. This may sometimes be followed by a signal 11 and and/or memory corruption.



CR:415570
CR Number:   415570
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2005 Fixed
Description
Error 7221, state 2, "Login to site %s failed." is received by a spid that attempts to use XP server if the login associated with that spid is configured to run a login script.



CR:415595
CR Number:   415595
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 tier2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2005 Fixed
12 Dec 2005 Fixed
Description
If SYSGAMS is extended as part of an ALTER DATABASE command in a server configured with pagesizes greater than 2K, wrong page numbers will be found in the newly allocated extent for SYSGAMS.



CR:415658
CR Number:   415658
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 EC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2005 Fixed
Description
If table name is specified in the format of "dbname..tblname" for dbcc tablealloc and dbcc indexalloc, server will not search the table in the database specified in "dbname", rather it will only search the table in the current database.



CR:415701
CR Number:   415701
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2005 Fixed
Description
If table data copy fails on a table with an identity column, Migration tool may issue the error: "Unable to 'SET IDENTITY_INSERT' for table '<tablename>' because IDENTITY_INSERT or IDENTITY_UPDATE is already ON" on subsequent tables.



CR:415721
CR Number:   415721
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2006 Fixed
Description
dbcc checktable(syslogs) does not report space free/used/reserved.



CR:415739
CR Number:   415739
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Dec 2005 Fixed
Description
dbcc checkstorage will report 100039 (Incorrect extent oampage extent) after create index on very large tables.



CR:415771
CR Number:   415771
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2008 Duplicate
Description
Feature Request to replicate encrypted columns to a not encrypted column server



CR:415772
CR Number:   415772
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2005 Fixed
Description
When you have a SELECT DISTINCT <all constants include scalar aggregates> under
union all, you might hit a siginal 11 during the call to CgpUnion::_cgpInit().



CR:415797
CR Number:   415797
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2006 Fixed
15 Sep 2006 Fixed
Description
Commands using large IO buffers like 'CREATE/ALTER DATABASE', 'LOAD DATABASE/TRANSACTION', 'DBCC CHECKALLOC' or 'DISK MIRROR' may hang instead of reporting an error when ASE rans out of memory.



CR:415813
CR Number:   415813
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2005 Fixed
09 Jan 2006 One-off Provided
23 Jan 2006 One-off Provided
14 Mar 2006 One-off Provided
Description
Session cleanup processing can encounter an "engine affinity stack overflow" during Kerberos authentication processing if the client disconnects during a narrow processing window.



CR:415818
CR Number:   415818
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2006 Fixed
Description
A query with a CASE expression that can select a LOB column (TEXT, IMAGE or UNITEXT) from

two or more different tables and that has an ORDER BY clause can return incorrect results for the LOB values.

An example query is:



SELECT c1, CASE when c1 = 1 then t1.c2 else t2.d2 end from t1, t2 ORDER BY c1



where t1.c2 and t2.d2 are LOB columns and c1 is a non-LOB column.
Target Version
 15.0 ESD#2



CR:415882
CR Number:   415882
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2007 Fixed
02 Jun 2007 Fixed
Description
Feature to audit LDAPUA state changes.



CR:415889
CR Number:   415889
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2005 Fixed
19 Dec 2005 Fixed
10 Jan 2006 Fixed
Description
Error: 913, Severity: 22, State: 4 may occur when Adaptive Server is booted

against a pre-15.0 installation and when sysdatabases has more than 1 data page

and if the master database's sysdatabases row is not on the first page.

The master database's sysdatabases row may not be on the first page if there

are other databases with the name less than 'master' in the sorted name order.



CR:415912
CR Number:   415912
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   IRIX
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2006 Fixed
23 Jul 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Memory allocation in the network memory pool may fail in a boundary

conditions even when memory is available. The failure to allocate

memory may manifest as failure to allocate large network memory pools.
Workaround Description
 increase number of user connecitons and additional network buffers size before starting the server.



CR:415916
CR Number:   415916
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2005 Fixed
Description
A stack trace will occur when set showplan is on and the query has more than 166 eliminated partitions, i.e. partitions that wouldn't be scanned.



CR:415924
CR Number:   415924
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2006 Fixed
13 Jan 2006 Fixed
13 Jan 2006 Fixed
06 Mar 2006 Fixed
Description
Stack trace containing function encr_getinfo() may occur while updating tables with encrypted columns and referential integrity.



CR:415945
CR Number:   415945
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2006 Fixed
03 Apr 2006 Fixed
Description
A query violating cross database referentail integrity may sometimes

fail to report referential integrity error. Instead of this a client

session may get killed and the message reporting TDS packet synchronization

problem will be displayed.



CR:416044
CR Number:   416044
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2006 Fixed
Description
When there are many transactions to be redone or undone, a timeslice error may be reported during the recovery of a database.
Workaround Description
 Try increasing the size of the "cpu grace time" configuration parameter.



CR:416075
CR Number:   416075
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 EC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2006 Fixed
26 May 2006 Fixed
Description
Query performing outer join between views with union may sometimes fail

to execute.



CR:416138
CR Number:   416138
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2006 Fixed
Description
If sqlserver was configed and setup during installation, installer will write the default connection profiles of ASEP.



CR:416150
CR Number:   416150
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2006 Fixed
Description
Executing a stored procedure which includes an insert ... select from an external file may result in a stack trace, which includes the routine fil__ins_infinite_loop.



CR:416182
CR Number:   416182
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2006 Fixed
Description
INSERT into a table with a VARCHAR column may incorrectly leave trailing spaces in the

VARCHAR column if the source of the data is a table with longer VARCHAR column.



CR:416224
CR Number:   416224
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)
16 Jan 2006 Fixed
Description
The following error may be seen in the ASE log: "Error 120510: ksmask__rpacket: Invalid tdslength value <length>".

This is usually caused when a non-TDS client connects to the port that ASE is using as its master listener,

and sends data that is not in valid TDS format. An additional message will now accompany this message

providing the IP address of the client in question, so that it can be tracked down.

In addition, traceflag 7845 can be used to suppress these messages if they cause a nuisance.



CR:416246
CR Number:   416246
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)
16 Mar 2007 Fixed
04 Sep 2007 Fixed
Description
A self-deadlock may sometimes occur if there are concurrent serializable and non-serializable transactions doing DMLs to a DATA-ONLY locked table.



CR:416296
CR Number:   416296
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2005 Fixed
19 Dec 2005 Fixed
10 Jan 2006 Fixed
Description
When a view is involved as the inner table of an outer join, and has character expressions in the select list, or has constants in the select list of the view, then incorrect handling of the view predicate could cause a wrong answer.



select * from t1 left join v1 on t1.a = v1.a



and the view is something like



create view v1 as select char_col + "au", ... /* character expression */

create view v1 as select 1, ... /* constant value or constant expression */



CR:416317
CR Number:   416317
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2006 Fixed
Description
Scheduled jobs that run with the property no_output_log will not have an entry created in the js_output table. But even though this property was set, the messages were logged into the js_output table and were viewable from the log file, after executing the job.



CR:416329
CR Number:   416329
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2005 Fixed
19 Dec 2005 Fixed
27 Mar 2006 Presently Not Targeted For Any Future Release Of This Product
Description
Add "Data Source Administrator" for Sybase ODBC/OLE DB Drivers.



CR:416357
CR Number:   416357
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2005 Fixed
Description
A 631 error, "The length of <value> passed to delete row routine for the row at offset <value>

is incorrect on the following page ..." may be reported on Sysdevices when during the execution

of a DISK MIRROR command a buffer pool whose size is greater than 2K bytes is used by ASE.
Workaround Description
 Make sure sysdevices is bound to a data cache with only a 2 K buffer pool.



CR:416369
CR Number:   416369
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2006 Fixed
Description
Added BlockedBy and BlockingState columns to the monLocks table. These columns indicate whether a lock is blocking other lock requests and the identity of the holders of blocking locks.



CR:416412
CR Number:   416412
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2006 Fixed
19 Jan 2006 Fixed
27 Jan 2006 Fixed
Description
In rare circumstances an ASE task my terminate with a timeslice error while a

configurable shared memory dump (CSMD) is being generated. This problem does not apply to ASE running on the Windows platform.
Workaround Description
 *** Wednesday, December 14, 2005 9:48:55 AM *** cooperg ***

Increase TS grace period.



CR:416500
CR Number:   416500
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2006 Fixed
11 Jan 2006 Fixed
01 Jun 2006 Fixed
Description
Index selection appropriate for the minimum or maximum aggregate early termination was underestimated, and the advantages of EXISTS subquery early termination of a scan was underestimated. The result was sub-optimial performance in some cases.



CR:416514
CR Number:   416514
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2006 Fixed
12 Jan 2006 Fixed
10 Jan 2006 Fixed
Description
In a database upgraded to 15.0, creating a clustered index on a DOL table might lead

to loss of data rows. This problem will only occur if the table was partitioned in the

pre-15.0 server, and was then unpartitioned during the upgrade process.
Workaround Description
 There is a simple workaround for the user, which does not involved

reloading the data. All they have to do is *before* creating the clustered

index force a table scan via the OAM SCAN as follows:



select count(*) from <tablename> (index <tablename>)



What this does is force a read of each allocation page that has extents

for this object, which will upgrade the partition ID to the right value.

Subsequently, create clustered index will qualify all the rows in the table.



CR:416519
CR Number:   416519
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2006 Fixed
20 Jan 2006 Fixed
Description
Stored procedure executing INSERT statement into a temporaray table from the remote table

may fail with error 208 "Object not found" referencing the temporary table if

the system is configured to use multiple temporaray databases.
Workaround Description
 create the procedure with WITH RECOMPILE or execute it with WITH RECOMPILE.



CR:416590
CR Number:   416590
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2006 Fixed
03 Feb 2006 Fixed
Description
Queries having OR clauses on tables that are range partitioned does not eliminate all the partitions that do not participate in the query. This results in a large number of I/O leading to a performance degradation.



CR:416593
CR Number:   416593
Product Name:   Adaptive Server Enterprise
Product Component:   sqldbgr
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2009 Insufficient priority to fix
Description
Request to have SQLDBGR's SHOW WHERE command display greater than 255 characters of the stored procedure's input parameters.



CR:416618
CR Number:   416618
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2006 Fixed
14 Feb 2006 Fixed
Description
Improve HPIA64 stack printing capability by including argument list.



CR:416622
CR Number:   416622
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Windows XP
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2006 Bundled Request
Description
Modified schedule is not saved when the repeating interval value is not explicitly selected by user in Schedule Properties window.



CR:416629
CR Number:   416629
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Windows XP
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2006 Bundled Request
Description
Change to scheduled job owner from properties window is not saved.



CR:416634
CR Number:   416634
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2006 One-off Provided
06 Jan 2006 Fixed
23 Jan 2006 One-off Provided
14 Mar 2006 One-off Provided
Description
ASE gets segmentation violation in sec_recv_params() during Kerberos client login when an

unusually large security token is given by the client to ASE during authentication.



CR:416667
CR Number:   416667
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2006 Fixed
20 Oct 2006 Reservation Made
Description
Simulated statistics stored in sysstatistics is not upgraded to format

understood by Adaptive Server version 15.0, during upgrade to 15.0 from

prev-15.0 installation.



CR:416677
CR Number:   416677
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2005 Fixed
10 Jan 2006 Fixed
12 Jan 2006 Fixed
Description
Non-equi join predicates (joins not using = ) i.e. theta join predicates of the form



r.a <relop> s.a where <relop> is one of > >= < <= !=



were not being costed in most cases (except when an OR predicate was involved) so that plans that could be benefit from these predicates were given no preference over other competing plans. This could result in sub-optimial plan selection.



Also, a new theta join is now recognized



(r.a = s.a OR (r.a IS NULL and s.a IS NULL))



is really a join in which NULL = NULL, and is now recogized as such for nested loop join operators only.



CR:416780
CR Number:   416780
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Dec 2005 Fixed
Description
@@resource_granularity shows a wrong value even though it was set at a session level to a different value.



CR:416795
CR Number:   416795
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2006 Fixed
09 Jan 2006 Fixed
Description
ASE Plug-in's help include encryption columns information.



CR:416839
CR Number:   416839
Product Name:   Adaptive Server Enterprise
Product Component:   sql
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2006 Fixed
Description
Eliminate the duplicate character 0x before the address in stack trace information on all linux platforms.



CR:416850
CR Number:   416850
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2006 Fixed
12 May 2009 Fixed
Description
The producer.log and consumer.log files are consolidated into one. The name of the consolidated file is webservice.log.



CR:416862
CR Number:   416862
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2006 Duplicate
Description
The message "current process infected with 11" maybe reported

in the errorlog together with a stacktrace which includes one

or more of the following modules: 'proc__free', 'procrm' or

'proc__grab' if many processes were concurrently executing

tasks that requires some quantity of memory and to satisfy

those requests some unused procedures had to be removed from

Procedure Cache for reusing their memory.



CR:416965
CR Number:   416965
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)
16 Jan 2006 Fixed
Description
In very rare circumstances the message "Infected with 11" together with module names "show_plan" can be encountered when using sp_showplan to look the plan of another process.



CR:417097
CR Number:   417097
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2006 Fixed
06 Jul 2007 Fixed
Description
The LOAD TRAN command may hang after raising a 938 error reading

"Database '<DBNAME>' is unavailable. It is undergoing LOAD TRANSACTION"

followed by the message, "Forced flush of database id <DBID> failed".

This may happen under very rare circumstances where the LOAD TRAN command is

used many successive times to recover a huge set of log records representing

around 1 billion page changes.
Workaround Description
 Use DUMP/LOAD database once per day or so + subsequent DUMP/LOAD TRAN instead of

doing DUMP/LOAD DATABASE just once and then zillions of DUMP/LOAD TRAN



CR:417155
CR Number:   417155
Product Name:   Adaptive Server Enterprise
Product Component:   Graphical Plan Viewer
Status:   Closed
OS:   NA
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2006 Fixed
01 Mar 2006 Fixed
Description
PV now supports displaying partition information.

Each node of the tree now displays information as to which partition is in use Vs which ones are eliminated



CR:417267
CR Number:   417267
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2006 Fixed
Description
When an update command setting a variable without updating any columns, server

stack traces in LeVtuple::LeVtGetColumn().



CR:417297
CR Number:   417297
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
enhancement request for sp_dropalias error message to include "force" option



CR:417301
CR Number:   417301
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2006 Duplicate
20 Jan 2006 Fixed
Description
The message "timeslice <negative number>, current process infected"

maybe reported in the errorlog together with a stack trace which

includes the modules 'ns_handle' and 'ns_prep_stmnt' if a batch

including together a CREATE TABLE statement and a SELECT executing

java was being executed and an error condition happened.
Workaround Description
 Do not execute the CREATE TABLE and SELECT using java in

the same batch.



CR:417308
CR Number:   417308
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2006 Fixed
15 Jan 2006 Fixed
Description
An attempt to create a placement index for a DOL table being empty but having

several allocated pages may fail with an error 3935 reading "Fatal protocol

error. xact_beginupdate() API was invoked in the wrong context. The transaction

is currently in 'Command-attached' state."
Workaround Description
 There are several workarounds available :



1. The easiest is :

reorg reclaim_space <table>

or

reorg rebuild <table>



2. alter table <table> lock allpages

alter table <table> lock datarows



3. run dbcc checktable(<table>)

Note the number of empty pages from the dbcc output :

"The total number of empty pages (with all deleted rows) in this table is X"

Increase the number of 'sort buffers' to a value greater than X

by running sp_configure 'number of sort buffers", ...



CR:417317
CR Number:   417317
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2006 Fixed
17 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
INSERT query with UNION ALL may incorrectly insert too many rows if the target table

is also used as the source table in one of the union sides.



CR:417425
CR Number:   417425
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2006 Fixed
Description
Reduced procedure cache consumption when large number of tables are joined in a query.



CR:417428
CR Number:   417428
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2006 Fixed
Description
Query chooses a table scan even though it forces a unique clustered index via abstract plans on servers using a case-insensitive sort order.



CR:417431
CR Number:   417431
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2006 Fixed
Description
ASE simply displays an error message returned by the LDAP Server without explaining the reason(s) for the error.



CR:417432
CR Number:   417432
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2006 Duplicate
Description
anonymous bind could not be performed then we should display appropriate error



CR:417442
CR Number:   417442
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2006 Fixed
Description
If ASE is set to start automatically as a service under Windows, and the ASE license is expired, Windows startup may be seriously delayed
Workaround Description
 Get a valid license, or remove license.dat completely



CR:417476
CR Number:   417476
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2006 Fixed
04 Jun 2006 Fixed
Description
Japanese hankaku-katakana conversion from EUCJIS to SJIS corrupts a TDS packet

if CS_RES_NOSTRIPBLANKS is turned ON.
Workaround Description
 Use varchar instead of char. Or turn CS_RES_NOSTRIPBLANKS off.

But some clients such as jConnect or ADO.NET can not turn CS_RES_NOSTRIPBLANKS off.

There is no workaround in some cases.



CR:417483
CR Number:   417483
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2006 Fixed
12 Jan 2006 Fixed
Description
referential interity involving more than 2 columns may not

be enforced. For example, a foreign key constraint on three

columns is missing the check on the second column.



CR:417517
CR Number:   417517
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2006 Fixed
03 Feb 2006 Fixed
Description
Infected with 11 in LeGroupSortedOp::_LeOpNext() when using group by in a query against a view containing scalar aggregates.



CR:417542
CR Number:   417542
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2006 Fixed
05 Nov 2006 Fixed
06 Nov 2006 Fixed
06 Nov 2006 Fixed
07 Nov 2006 Fixed
Description
Added support for nocase sortorder for Chinese and Japanese character sets. Under

the nocase sortorder, ASCII and accented characters are sorted in case-insensitive

manner, CJK characters are sorted in Unicode binary order. Please run sp_helpsort

to get the sort order id.



CR:417573
CR Number:   417573
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2006 One-off Provided
16 Aug 2006 One-off Provided
14 Sep 2006 Diagnostic Provided
15 Sep 2006 Fixed
18 Sep 2006 Fixed
18 Sep 2006 Fixed
18 Sep 2006 Fixed
18 Sep 2006 Fixed
17 Oct 2006 Fixed
Description
The message "current process infected with 11" in the module 'ksmask__complete' together with

a stack trace which includes the module 'ksmasknserver' may be reported in the error log.

This stack trace may be repeated a few times followed by ASE listener failure with a

stack trace accompanied by the messages in error log such as

'kernel nopen: accept, Software caused connection abort',

'kernel nopen: accept, Invalid argument',

'kernel Listener with protocol tcp, host <host-name>, port <port-number>,

engine 0 is quitting after a fatal error.'



CR:417647
CR Number:   417647
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2006 Fixed
Description
Optimize select into by avoiding frequent access to the syspartitions

metadata cache to obtain the current last page of a data partition.



CR:417707
CR Number:   417707
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2006 Fixed
Description
In very rare circumstances, Adaptive Server may loop while allocating memory from procedure

cache, and the looping SPID can not be killed.



CR:417712
CR Number:   417712
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 EC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2006 Fixed
Description
A 221 message, "Column of type (BIT) does not allow nulls. It may not be compared with null." is raised when assigning the result of SELECT to a variable of type BIT. The SELECT is from a view with a UNION ALL clause with a select-list having a column of type BIT.



CR:417717
CR Number:   417717
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2006 Fixed
Description
The message "infected with 11 in ssql_reparse together with a stacktrace containing the modules

's_reinstall_lwp_tree', 's_getTreeOrPlan' and 'exec_proc' is written to the errorlog when

executing a stored procedure with a name which starts with '*' using the execute immediate

feature.
Workaround Description
 make sure the proc exists



CR:417737
CR Number:   417737
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2006 Fixed
Description
The optdiag utility would report a very large value for Large I/O efficiency on Windows. This formatting issue has been fixed.



CR:417861
CR Number:   417861
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2006 Fixed
Description
The following messages are seen in quick succession:

'ubo_object_from_slot:Sybproc Invalid slot id 0' followed by

'kernel current process (0xb000b0) infected with 11'.



CR:417897
CR Number:   417897
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.3 ESD#7 31 Jan 2006 Fixed
02 Apr 2006 Duplicate
Description
JS Schedule wizard and properties window display an error when trying to create a schedule with a 1 day interval, but restricted to selected days of the week or days of the month.
Workaround Description
 *** Thursday, March 17, 2005 2:52:57 PM *** cooperg ***

Make sure you always re-check the radio button for Between before applying changes to repeating Jobs.



CR:417913
CR Number:   417913
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2006 Fixed
Description
The sort operator's physical I/O is over reported when using

"set statistics plancost" or traceflag 9500 for performance

analysis. For large input sets, the number is approximately

50% more than it should be.



CR:417918
CR Number:   417918
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2006 Fixed
Description
DDLGen only works if hostname:portnumber is specified in the '-S' option. If servername is specified in the '-S' option then DDLGen gives an exception.



CR:417927
CR Number:   417927
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2006 Fixed
Description
Java objects may be unable to open sockets on NT and recieve the exception: Cannot create socket: Too many open files





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

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