提供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:434865
CR Number:   434865
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)
11 Jul 2006 Fixed
Description
Usage of local variables in execute immediate may sometimes not work as

expected for varchar and char variables : result of expressions involving

local variables may be trunacted.



CR:434890
CR Number:   434890
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2009 Not a Bug
Description
Concatenation between char varchar str_replace goes into infinite loop in while



CR:434911
CR Number:   434911
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jun 2006 Fixed
27 Jun 2006 Fixed
27 Jun 2006 Fixed
Description
A query of the form 'IF (@v IN (1,2,3,..,41))', where the IN list contains more than 40 values can result in error 325 (Adaptive Server finds no legal query plan for this statement.) or a stacktrace that includes the routine _popDistCheckAndLazyEnforce.



CR:434927
CR Number:   434927
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)
31 Aug 2007 Fixed
05 Sep 2007 Fixed
Description
The option 'replication force_ddl' has a mispelling error in the system table spt_values.



CR:434934
CR Number:   434934
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)
19 Jul 2006 Duplicate
Description
This CR has been fixed by

CR 435065 - Update the Meta Data stored procedures used by ODBC, OLEDB and jConnect drivers



CR:434936
CR Number:   434936
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2006 Presently Not Targeted For Any Future Release Of This Product
22 Aug 2006 Fixed
Description
NoSuchMethodError is reported when ASA Plug-in and ASE Plug-in coexist in the same SC,

and user connects to ASA Plug-in first before connecting to ASE Plug-in.



CR:435008
CR Number:   435008
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)
24 Oct 2006 Fixed
Description
The options exported in a login trigger were not available in the process unless the server was started with trace flag 4073. From now any exportable option set or unset in a login trigger will take effect in the login process without the need of that trace flag. To avoid this nchange in behaviour the user can execute SET EXPORT_OPTIONS OFF inside the login trigger itself.



CR:435065
CR Number:   435065
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2006 Fixed
19 Jul 2006 Fixed
Description
Updated the installmaster with the latest jConnect Driver's MDA SQL.



CR:435096
CR Number:   435096
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2006 Fixed
01 Aug 2006 Fixed
Description
Occasionally. optdiag fails to dump or load statistics when the server and optdiag are running in different platforms.



CR:435100
CR Number:   435100
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2006 Fixed
Description
TraceFlag '1' has been extended to work with optdiag output mode along with input mode to ignore mismatch in server and optdiag versions.



CR:435111
CR Number:   435111
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2006 Fixed
Description
Column in a result set returned by the stored procedure sp_statistics are all varchar datatypes. Previously, some of the columns returned were integers.



CR:435202
CR Number:   435202
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2006 Fixed
24 Jul 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Under rare circumstances ASE responsiveness may become slow if a session sleeps

in module hk_accelerate() while it was in the process of creating a temporary table

and therefore holding exclusive locks on system catalogs. Other sessions that create

temporary tables concurrently will be blocked. The session could sleep due to ASE

having enqueued to housekeeper a request to flush to disk the systabstats statistics

for the being created temporary table. This proactive enqueue request is not deemed

necessary because the descriptor for a temporary table is expected to remain in cache

always. If this descriptor needs to be reused, ASE will flush its systabstats statistics

on disk first before reusing it for another object.
Workaround Description
 Boot ASE with traceflag 3632 that turns off stats flushing performed by the

chores housekeeper.



CR:435216
CR Number:   435216
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)
07 Jul 2006 Fixed
07 Jul 2006 Fixed
Description
SELECT FOR BROWSE may return incorrect table name/column name information.
Workaround Description
 None known.



CR:435218
CR Number:   435218
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2006 Fixed
Description
A session that runs a SELECT-INTO-UNION query that uses the identity() builtin

may hit error 8221 "Couldn't find the identity column for object <value>"

and hang forever while undoing the creation of the given target table.



CR:435230
CR Number:   435230
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2006 Fixed
Description
function setuser has no effect when creating a database



CR:435233
CR Number:   435233
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2006 Fixed
05 Jul 2006 Fixed
Description
Page count values are not imported during update statistics on proxy tables.



CR:435235
CR Number:   435235
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2007 Fixed
25 Nov 2009 Fixed
26 Mar 2009 Fixed
Description
A new feature to store the last date and time a checkpoint record is written and the last date and time a dump transaction is taken on a database. The new columns LastTranLogDumpTime and LastCheckpointTime have been added to monOpenDatabases.



CR:435250
CR Number:   435250
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Linux
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2006 Fixed
30 Aug 2006 Fixed
24 Apr 2007 Fixed
Description
The client issuing job scheduler command with 'sp_js_wakeup' hangs forever.



CR:435254
CR Number:   435254
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)
31 Aug 2006 Fixed
Description
Enable support of literal auto-parameterization when server's default character set is a multi-byte charset.



CR:435283
CR Number:   435283
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 Aug 2006 Fixed
Description
Error displayed regarding "Space available in the log segment has fallen critically" when installing Job Scheduler.



CR:435376
CR Number:   435376
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2006 Bundled Request
Description
Previously when user uncheck "Enable UA related features" check box on ASE Plug-in Preferences page and apply the setting, the connections to UAs remained visibile - the setting only took place when user restart ASE Plug-in. This has been fixed so that the effect is immediate.



CR:435400
CR Number:   435400
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2006 Fixed
Description
CIS: A 191 error, "Some part of your SQL statement is nested too deeply", may be reported when a query containing a very large number of conditions in the where clause is executed in quickpass mode



CR:435430
CR Number:   435430
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2006 Fixed
Description
Enable LDAP User Authentication feature on HPIA 64bit platform.



CR:435482
CR Number:   435482
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2006 Fixed
Description
Example 8 of sp_monitorconfig has incorrect syntax for ASE 12.5.3 & 15



CR:435513
CR Number:   435513
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2006 Fixed
06 Jul 2006 Fixed
Description
ASE running on Windows may output the following message to the log at startup: "KERNEL structure not padded correctly - size = <nnnn>". This is an internal matter with no consequence for the safe running of the server.



CR:435623
CR Number:   435623
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2006 Fixed
10 Jul 2006 Fixed
12 Jul 2006 Fixed
Description
In some cases, the nary-NLJ strategy could return too few rows. This could occur if and only if one of the inner scans was on a DOL table "T", the table had two or more SARGs on it where some of the SARGs were dependent on different outer scans (or a constant) and some instance of opening "T" qualified no pages/rows.
Workaround Description
 Start server with -T342 to avoid Nary Nested loop join runtime optimization

or the traceflag can be enabled at the session level using dbcc.



CR:435639
CR Number:   435639
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)
10 Nov 2006 Fixed
10 Nov 2006 Reservation Made
Description
A new command "create manifest_file" allows creation of a manifest file

without the requirement to either unmount or quiesce one or more databases.



CR:435654
CR Number:   435654
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)
06 Jul 2006 Fixed
07 Jul 2006 Fixed
23 Aug 2006 Fixed
24 Aug 2006 Fixed
Description
The error 678 "Invalid Buffer Cache Access: Could not open object '<value>'

in database '<value>'" may be raised mistakenly during the execution of

DBCC CHECKALLOC with the FIX option or DBCC TEXTALLOC with the FULL and

FIX options, if the object being corrected does not exist anymore in

the given database. This error results in the abort of the given DBCC command.



CR:435692
CR Number:   435692
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2006 Fixed
31 Aug 2006 Fixed
Description
Pattern matching with LIKE clause may sometimes provide incorrect evaluation when

it is done on unichar or univarchar columns.



CR:435715
CR Number:   435715
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)
31 Aug 2006 Fixed
29 Aug 2005 Bundled Request
Description
An 840 error, "Device '<devname>'(with physical name '<physname>', and virtual device number -1) has not been correctly activated at startup time", will be reported when trying to access an archive database at boot time, when one of the stripe devices has been physically deleted.



CR:435910
CR Number:   435910
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2006 Fixed
01 Aug 2006 Presently Not Targeted For Any Future Release Of This Product
27 Jul 2006 Fixed
Description
A table with both an identity and timestamp fields will insert bogus timestamp values for all new rows.



CR:435944
CR Number:   435944
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2006 Fixed
10 Jul 2006 Fixed
11 Jul 2006 Fixed
Description
Under some circumstances a SELECT statement containing

subqueries in the target list could return incorrect

values for those subqueries if the same subqueries are

used within predicates in the WHERE clause.



CR:435961
CR Number:   435961
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2007 Fixed
Description
The initial directory and file name in Export Server Groups dialog used to be empty if there was no last-browsed directory. The initial directory is now either $SYBASE or $SYBROOT (in that order.)



CR:435962
CR Number:   435962
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2006 Fixed
10 Jul 2006 Fixed
10 Jul 2006 Fixed
10 Jul 2006 Fixed
10 Jul 2006 Fixed
Description
Queries of MDA tables that include sargs with the equal operator run much slower in 15.x versus 12.5.x.



CR:436024
CR Number:   436024
Product Name:   Adaptive Server Enterprise
Product Component:   upgrade
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2006 Fixed
24 Jul 2006 Fixed
Description
While upgrading auditing database 'sybsecurity', ASE can report that upgrade could not install item 244. This causes upgrade of sybsecurity to fail. ASE does not report the reason for the failure.



CR:436073
CR Number:   436073
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2006 Fixed
07 Jul 2006 Fixed
Description
The warning, "Invalid compression format found in device 'filename'. The compression will be ignored." is incorrectly reported when loading an uncompressed database dump that was generated using a 12.5.4 IR Backup Server.



CR:436110
CR Number:   436110
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)
07 Sep 2006 Fixed
Description
New feature to display the ammount of compression memory recommended to run DBCC CHECKSTORAGE in the stored procedures sp_plan_dbccdb and sp_dbcc_evaluatedb.



CR:436136
CR Number:   436136
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2008 Insufficient priority to fix
Description
Error 206 raised in some cases when correlation name in query includes a column list.



CR:436160
CR Number:   436160
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2007 Fixed
Description
When moving a server to a different server group, if the operation failed, ASEP didn't give any reason. ASEP now shows an error message when the server is still connected, or the server already exists in the target server group.



CR:436176
CR Number:   436176
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   150 winx64
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2006 Fixed
Description
The sqlsrvr.pdb file is now shipped with ASE on the winx64 platform. sqldbgr.pdb is used to debug ASE issues.



CR:436213
CR Number:   436213
Product Name:   XML Model
Product Component:   XML Model
Status:   Closed
OS:   Windows XP
Original Version:   ulysses
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2006 Fixed
Description
Allow setting <xs:simpleContent> and selecting Complex Type as restriction base



CR:436216
CR Number:   436216
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2006 Fixed
16 Aug 2006 Fixed
Description
If "exec_procedure" audit option is turned on and you run a stored procedure with a parameter

containing double-byte characters over 255 bytes, the audit records may be split in the middle

of one of double-byte characters.



CR:436330
CR Number:   436330
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2008 Fixed
13 Jun 2007 Presently Not Targeted For Any Future Release Of This Product
13 Jun 2008 Fixed
13 Jun 2008 Fixed
04 Sep 2008 Fixed
Description
Under rare conditions querying the monOpenObjectActivity table may result in error 14108 or a stack trace reported in the error log including the modules "mda_populate_monOpenObjectActivity", "mda__accumulate_ptnstats_for_obj" and "ind__get_sysindrow".



CR:436410
CR Number:   436410
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   IRIX
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2006 Fixed
01 Aug 2006 Fixed
Description
Scheduled jobs with the properties 'no_job_header' and 'no_sql_batching' set may issue an incorrect job command. Job execution may fail with unexpected results and in some cases the error message, "Line 1, character 8: Incorrect syntax with 'select'"

may be reported and logged in the log. In addition, a job may be further processed even if the errors are reported.



CR:436433
CR Number:   436433
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2006 Fixed
11 Oct 2006 Fixed
12 Oct 2006 Fixed
16 Nov 2006 Fixed
02 Nov 2006 Fixed
01 Nov 2006 Fixed
22 Jan 2007 Fixed
Description
Add to installmaster a new system stored procedure (sp_spaceusage) to

capture and report the space usage characteristics, and an estimated

measure of fragmentation, for tables, indices, and transaction log of

a database.



CR:436441
CR Number:   436441
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Request for cross platform dump and load to support standard back up features including online backup and transaction log backup and load.
Workaround Description
 N/a



CR:436456
CR Number:   436456
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2010 Presently Not Targeted For Any Future Release Of This Product
Description
JVM: Java SQL method call causes SIGSEGV in open_system_table()



CR:436467
CR Number:   436467
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 Dec 2007 Fixed
Description
Feature request to have messagae 12974 identify at least one of the spids preventing the engine from going offline.



CR:436667
CR Number:   436667
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2006 Fixed
13 Feb 2007 Fixed
Description
Queries that contain a builtin function that can return a string (REPLICATE, STR_REPLACE,

STR, SPACE) in the select-list and that have literal values as arguments to the builtin

function and have literal auto parameterization enabled and have the statment cache enabled

can get output results from these builtins that are blank-padded up to a width of 255 bytes.



CR:436734
CR Number:   436734
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   11.5.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Insufficient priority to fix
Description
Ability to set stmt cache at session level when it is temporarily disabled at the server level



CR:436738
CR Number:   436738
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)
06 Sep 2006 Fixed
07 Sep 2006 Fixed
Description
The new Optimizer and Execution Engine provide far more query execution stategies. This can result in a significant reordering when predicates and expressions are evalauted. As a result, expression evaluation errors may be reported because some filter predicates are eliminating the row before the problem expression is evaluated. Further, all virtual columns (expressions in equijoin clauses) are being evaluated before the filter predicates that reference them.
Workaround Description
 Using CASE expression can be found from CR 426272-1 explanation in detail



CR:436746
CR Number:   436746
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2006 Fixed
23 Jul 2006 Fixed
Description
ASE may now report in module collocate() the error message "Invalid DOL data row pointer:

row <value> with status <value> must be the forwarded row location instead of

the home row location." and the call stack of the given session as opposed to

silently continue.



CR:436747
CR Number:   436747
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2006 Fixed
Description
Initialization of kernel asynchronous I/O context through io_setup() fails with an error EAGAIN while bringing an engine online.



CR:436790
CR Number:   436790
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)
29 Aug 2006 Fixed
Description
Expression subquery on the SELECT list could be run unnecessarilly and it could cause error message 512 ("Subquery returned more than 1 value") for a query having subquery in CASE expression on the SELECT list.



CR:436929
CR Number:   436929
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)
31 Aug 2006 Fixed
Description
Error 530 when selecting from a view. Server cannot insert null value into worktable for intermediate values when the type is char, binary, or unichar. FIX restricted to trace flag 7721 in 441716-1



CR:436961
CR Number:   436961
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2006 Fixed
28 Jul 2006 Fixed
Description
Under rare circumstances error 803 "Unable to place buffer ... either there is no room in sdes

or buffer already in requested slot." may be raised with a stack trace in module

"pg__allocate_completion" leading to error 1127 "Internal Error: The OAM has no room

for new inserts ..." in module "pg__insertoam" during the execution of an INSERT command

in a table that has more than one OAM pages allocated to it.



CR:436966
CR Number:   436966
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2006 Fixed
19 Dec 2006 Fixed
09 Sep 2007 Fixed
Description
Under some rare circumstances if builtins are run in parallel with some DDLs,

there is a possibility of deadlock.



CR:437012
CR Number:   437012
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2006 Fixed
Description
Possiblely hit 1763 error(duplicate frequency) when reorg rebuild on table with global clustered index.



CR:437030
CR Number:   437030
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)
30 Aug 2006 Fixed
Description
In error message 531, print the dbid as well.



CR:437093
CR Number:   437093
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)
20 Jul 2006 Fixed
24 Jul 2006 Fixed
Description
Syntax errors of Abstract Plans will be reported if 'g_join' or 'm_g_join' clause is followed by more than two tables which is, however, supported syntax before Galaxy release



CR:437096
CR Number:   437096
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2006 Fixed
24 Jul 2006 Fixed
Description
A UNION query with a select statement (other than the first one) that returns no

rows will return too few rows if the optimizer selects a query plan with a hash-based

UNION operation. The presence of the hash-based UNION operation in the query

plan is shown in showplan by the line: HASH UNION Operator.

The following query is representative of such a union query where the second

select statement will return no rows:

select 1 union select a from x where 1=2 union select 2
Workaround Description
 Put manifestly false SARGs as first or last in a union chain.



CR:437148
CR Number:   437148
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2006 Consult Complete
24 Jul 2006 Fixed
24 Jul 2006 Fixed
Description
The boot time recovery of a database that has a big syslogs segment allocated to it,

irrespective of it being a dedicated log sergment or not, may take more time to complete

compared to a pre-15.0 ASE system. The recovery process will spend cycles in module

'pg_logdevusage' in reading each syslogs allocation page while establishing statistics

information in module 'systs_fill_catalogs' as opposed to only consider the statistics

information that was retrieved from the systabstats system catalog already.



CR:437225
CR Number:   437225
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2006 Fixed
30 Jul 2006 Fixed
Description
On 32-bit Linux platform while extending "secondary cache" by 2GB or more, server may encounter timeslice error.
Workaround Description
 Workaround until this is fixed:



1) Set the extended cache size to zero from existing value.



sp_configure 'extended cache size', 0

go



2) now set it to the required new size



sp_configure 'extended cache size', <new size>

go



This may take lot of time to flush the existing dirty pages in secondary cache to disk.



CR:437268
CR Number:   437268
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)
21 Jul 2006 Consult Complete
Description
ASE 15.0 ESD#2 EBF13444 coverletter ref CR422375 incorrectly states:

> This percentage is controlled through the "max space granularity" configuration option.

The above should refer to the session config prop "max resource granularity".



CR:437277
CR Number:   437277
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2006 Fixed
Description
A 318 error, "sysstatistics catalog was read and an inconsistency was found, please run update

statistics" may be reported after an upgrade to 15.0. On little-endian platforms error

2601, "Attempt to insert duplicate key row in object 'sysstatistics' with unique index

'csysstatistics'" followed by error 511, "Attempt to update or insert row failed because

resultant row of size 1967 bytes is larger than the maximum size (1964 bytes) allowed for this

table." may be reported during an upgrade to 15.0.
Workaround Description
 In case of the 318 error: Run update statistics after the upgrade to 15.*

In case of the 511 error: Drop statistcis on the pre 15.0 database, before

the upgrade.



CR:437299
CR Number:   437299
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)
23 Jul 2006 Fixed
24 Jul 2006 Fixed
29 Aug 2006 Consult Complete
Description
Fewer rows may be deleted than specified by a delete query using

a join to at least one additional table. This may occur if the

chosen plan uses a merge join, and the rows are deleted in 'direct'

mode (does not occur with deferred deletes). This may only happen

when deleting from APL tables and requires duplicate values in the

joined column.
Workaround Description
 The session level option "set merge_join 0" can be used to disable

merge-join strategies. This effectively fixes this problem.



CR:437304
CR Number:   437304
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2006 Fixed
Description
Timeslice error due to scan of a potentially long chain in mempmctrl_procinstall().



CR:437317
CR Number:   437317
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)
03 Nov 2006 Fixed
Description
New feature request to allow the SET command and DUMP TRANSACTION to be executed inside EXECUTE IMMEDIATE statements.



CR:437321
CR Number:   437321
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2006 Fixed
31 Jul 2006 Fixed
Description
RepAgent has incorrect encrypted password for dump database.
Workaround Description
 None. RS has temporarily provided an instrumentation that will bypass all passwords. This instrumentation was built on RS 12.5 and is only valid on RS which do no stored procedure replication or DDL replication, two actions that require correct userids and passwords.



CR:437369
CR Number:   437369
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2006 Fixed
Description
A session may hit error 701 "There is not enough procedure cache to run this procedure,

trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure

cache." while allocating memory from the procedure cache when the procedure's cache

memory is fragmented.
Workaround Description
 Use traceflag 752 to diable procmem control. This traceflag is not

supported from 15.0.2 and above. In those releases procmem control

will be enabled by default.



CR:437403
CR Number:   437403
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)
03 Oct 2006 Fixed
09 Oct 2007 Fixed
Description
The builtin audit_event_name(106) returns the string "Encrypted Column Administration", which is 31 bytes long. This exceeds the documented result length of 30 bytes for this builtin.



CR:437414
CR Number:   437414
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)
27 Jul 2006 Fixed
Description
Integer (not numeric) identity columns do not increment correctly when "identity gap size" is set to more

than 1.



CR:437430
CR Number:   437430
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 Jul 2006 Fixed
26 Jul 2006 Fixed
Description
Sometimes an outerjoin ON clause was not considered as an index sarg

causing bad performing index scan when the ON clause was involving

expression on one side of the join. Also false join could be

added to the plan causing wrong results when there were nested

outerjoins in the query.



CR:437443
CR Number:   437443
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2006 Fixed
30 Aug 2006 Fixed
Description
While executing a parallel query, an exception may be encountered in the early

stages of the execution. In certain cases, a stack trace will be encountered

containing the method icp_crecvmsg().



CR:437444
CR Number:   437444
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2006 Fixed
02 Oct 2006 Fixed
06 Oct 2006 Fixed
03 Oct 2006 Fixed
09 May 2007 Insufficient priority to fix
Description
Error 696 occurs, in temporary databases, as a newly allocated page is

over-written by a work table oam page, in some rare cases.



CR:437530
CR Number:   437530
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)
25 Sep 2007 Presently Not Targeted For Any Future Release Of This Product
20 Sep 2007 Fixed
Description
If a long running transaction is active in one database, garbage collector may sometimes fail to reclaim space in other databases.



CR:437533
CR Number:   437533
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2006 Fixed
08 Oct 2006 One-off Provided
Description
The message "timeslice -501, current process infected" together with a stack trace which includes different functions like stm_count_cell_types(), stm_process_step(), stio_xformvirtual() may be reported in the error log when creating index using huge number of histogram steps.
Workaround Description
 Decrease the number of steps when creating index and then run update statistics with the number steps that is necessary



CR:437547
CR Number:   437547
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2006 Not a Bug
Description
In some circumstances, an 1133 error, "Page 0 was expected to be an OAM page for <id> and it is not" is reported in the error log when running DBCC CHECKALLOC() against an archive database. DBCC CHECKALLOC reports a 7949 and 7940 error to the console.
Workaround Description
 N/A



CR:437551
CR Number:   437551
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)
07 May 2008 Fixed
Description
When an unloaded archive database exists the execution of SP_CACHECONFIG will report error 966

followed by either error 18140 or error 10855 when respectively an attempt to create a logonly

cache or an attempt to drop a cache is made.
Workaround Description
 Load the database, online it and then try the operation.



CR:437692
CR Number:   437692
Product Name:   Adaptive Server Generic Docs
Product Component:   Security Administration Guide
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jan 2008 Added to user documentation
Description
Feature request to include some description of wait events in the documentation for the monSysWaits table.



CR:437698
CR Number:   437698
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to allow an ASE webservices consumer to consume from an ASE webservices producer



CR:437796
CR Number:   437796
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2006 Fixed
Description
Invalid oampage errors (1131) are thrown if the table gets dropped (in a parallel session)

during the execution of builtins like data_pages(), reserved_page(), row_count() etc.

The traceflag 1116 can be used to suppress these errors in non-temporary databases.

In temporary databases, these errors are suppressed by default.
Workaround Description
 Run the procedure/builtin again



CR:437810
CR Number:   437810
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)
02 Nov 2006 Fixed
14 Nov 2006 Fixed
Description
When foreign key and primary key are encrypted with same encryption key and they are tinyint, smallint, bigint, unsigned bigint the referential constraint did not work properly. When the constraint is violated, error 15450 was given instead of 547, saying 'Both primary and foreign keys must be encrypted with the same encryption key.'



CR:437869
CR Number:   437869
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)
15.0.1 ESD#1 25 Jul 2006 Fixed
Description
Commandline traceflag 655 and traceflag 656 are used to disable "direct update"

mode for DELETE and UPDATE queries where there is a join or an RI constraint.

This functionality had not been migrated to Galaxy. This is fixed.



CR:437881
CR Number:   437881
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)
15 Sep 2006 Presently Not Targeted For Any Future Release Of This Product
Description
Extra blanks are not stripped from the parameterized text for the parameterized literals

feature. This results in two statements that vary only by the amount of whitespace around

their literals caching two separate statements in the statement cache and two plans in

the procedure cache. For example, the following two statements will both be cached

with their own plans:



select 1, 2 from sysobjects where id < 10



select 3, 4 from sysobjects where id < 100



With the autoparam feature, these two statements should be considered equivalent.



CR:437887
CR Number:   437887
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2007 Fixed
25 Jan 2007 Fixed
04 Oct 2007 DEFER
Description
The message "Invalid column length: 12. Value must be between 0 and 10 for 'all-pages' row with

minimum row length of 64" together with a stack trace which includes the modules 'collocate' and

'translate_varcols' may be reported in the error log when a database dump from a previous ASE

version is loaded in a 64 bits ASE on IBM AIX.



CR:437939
CR Number:   437939
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2006 Fixed
Description
A stack trace may be reported in module "ptn_updlogroot" resulting in the

session being killed when ASE receives an external attention "Control-C"

while it was instantiating a database information in cache. The modules

"dbt_get", "dbt_removeall" and "des_discardall" will also be reported

in the error log.
Workaround Description
 Increasing the config parameter 'number of open databases' may help avoid the problem.

dbcc dbcacheremove will *not* work here after the error is hit because the dbtable is

left in the destroy state and this dbcc does not support this state yet.



CR:437955
CR Number:   437955
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2006 Fixed
Description
Dynamic configuration option 'license information' is requiring an ASE reboot for its new value to take affect. This is fixed to take effect immediately.
Workaround Description
 *** Tuesday, July 25, 2006 8:50:14 AM *** cooperg ***

Reboot server after updating.



CR:437974
CR Number:   437974
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2006 Fixed
Description
SUBQUERY/REFORMAT: Sub-optimal performance may result when a query is executed which includes a correlated subquery without useful index on the correlated columns. Traceflag 15370 is implemented to enable reformat for the correlated subquery.
Workaround Description
 Create a new index on acct_invn (id_instmt)



CR:438042
CR Number:   438042
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)
27 Jul 2006 Fixed
27 Jul 2006 Fixed
Description
When a cursor that joins two or more tables is declared with a FOR UPDATE clause, a subsequent UPDATE query using the the WHERE CURRENT OF cursor clause may cause a 594

error:

The UPDATE WHERE CURRENT OF to the cursor '<cursor_name>' failed because column '<column_name>' being updated was not specified in the SELECT list.



The error can occur if the optimizer chooses to join the tables in an order that is

different from the order of the tables in the FROM clause of the DECLARE CURSOR statement.
Workaround Description
 There are 3 possible work arounds for this issue:

1. Remove the FOR UPDATE clause from the cursor definition. Then all columns will be

updateable by default.

2. Use an abstract plan with the DECLARE CURSOR statement to force the optimizer to choose a join order that matches the order of the tables in the FROM list.

3. Modify the DECLARE CURSOR statement by changing the order of the tables in the FROM

list to match the join order chosen by the optimizer in the query plan.



CR:438059
CR Number:   438059
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2006 Fixed
Description
Inserting duplicate or overflowed identity values may be unexpectedly allowed

after sp_chgattribute "<TABLE_NAME>", "identity_gap", 0 has been run for a

table whose identity column has already reached its maximum value.



CR:438155
CR Number:   438155
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)
11 Sep 2006 Fixed
Description
A 913 error, "Could not find row in sysdatabases with database id <dbid>. Run

DBCC CHECKTABLE on sysdatabases." may be reported after loading a database and

executing a stored procedure that inserts explicit NULL values in columns

declared as java classes.
Workaround Description
 Drop procedure and recreate it from text.



CR:438200
CR Number:   438200
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2009 Insufficient priority to fix
Description
In rare circumstances, Adaptive Server may produce incorrect costing for join order.

e.g. If there is a subquery that needs to be flattened to the outer query which has

an order by clause.



CR:438233
CR Number:   438233
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 EAP2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2006 Fixed
Description
Under rare circumstances error 821 " Attempt to unhash buffer in cache '<cache_name>'

at '<buffer_address>' with a buffer pageno of '<page_no' and database id '<dbid>' with

HASHED status set failed - buffer was not found ... " may be raised in module cm_bufunhash()

recursively resulting in ASE shutting down itself.



CR:438272
CR Number:   438272
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 Sep 2006 Fixed
04 Dec 2006 Fixed
02 Oct 2006 Fixed
02 Oct 2006 Fixed
16 Aug 2007 Fixed
Description
A 3478 error, "During undo the page timestamp value is less than new timestamp from log ... ", may be reported during ONLINE DATABASE after loading a database dump that was taken when a SELECT INTO command was active (but incomplete).
Workaround Description
 N/A



CR:438288
CR Number:   438288
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)
01 Aug 2006 Not a Bug
Description
On a read-only database, select from an existing view/stored procedure may hit error 3906



CR:438321
CR Number:   438321
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   HP-UX
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2006 Fixed
Description
Installation progress bar displayed incorrectly with non-gui mode.



CR:438330
CR Number:   438330
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   HP-UX
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2009 Third Party Problem
Description
Starting message of InstallShiled Java VM is garbled to read by SJIS console.



CR:438342
CR Number:   438342
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2006 Fixed
01 Aug 2006 Fixed
Description
When additional license sources are specified in the SYBASE_LICENSE_FILE environment variable then ASE fails to boot. The LM_LICENSE_FILE environment variable can be used instead, however, it is recommended that all license files (including files that point to license servers) are placed in the $SYBASE/SYSAM-2_0/licenses directory, rather than ASE relying on a specific runtime environment to obtain it's licenses.
Workaround Description
 The LM_LICENSE_FILE environment variable can be used instead, however, it is recommended that all license files (including files that point to license servers) are placed in the $SYBASE/SYSAM-2_0/licenses directory, rather than ASE relying on a specific runtime environment to obtain it's licenses.



CR:438354
CR Number:   438354
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)
04 Aug 2006 Fixed
Description
The message "current process ... infected with 11" may be reported with a stack trace

in the error log in module "dbt_cacheremove" during the execution of dbcc dbcacheremove()

when execute cursors exist and are not closed in the database being uncached.
Workaround Description
 None.





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

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