提供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:361191
CR Number:   361191
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)
29 Jul 2004 Fixed
Description
ASE starts a Mirror Handler process even when disk mirroring is disabled in the config. This wastes a potential user process slot and a small amount of memory.



CR:361268
CR Number:   361268
Product Name:   ASE Replicator
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.5.2.302P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.3.304P1 13 Dec 2004 Fixed
Description
ASE Replicator: Replicator is duplicating work when trying to find a resource message in a non-English locale.



CR:361286
CR Number:   361286
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2004 Fixed
Description
A deadlock may be reported involving system catalogs such as 'sysobjects'

and 'sysindexes' when a session is in the process of dropping a replicated

user table, stored procedure or function.
Workaround Description
 Avoid dropping replicated objects.



CR:361335
CR Number:   361335
Product Name:   Adaptive Server Enterprise
Product Component:   SQL Advantage
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2004 Fixed
15 Jul 2004 Fixed
Description
Improve support for ASIQ databases in SQL Advantage



CR:361396
CR Number:   361396
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2009 Insufficient priority to fix
Description
bcp in of float datatype in character mode with values like 1.7612956042477213e-312 causes an underflow error. This is due to fix made in bcp as per cr 233477.

ASE should not allow insertion of such values if they are invalid values.
Workaround Description
 1. In you are not doing inter-platform bcp you can try doing bcpin using native mode instead of character mode.

Or

2. Write a script to edit data to replace all such value to 0.0 and then do the bcpin



CR:361414
CR Number:   361414
Product Name:   Adaptive Server Enterprise
Product Component:   asecfg
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2004 Not a Bug
Description
Requesting scripts to set permissions for an ASE installation to be provided.



CR:361450
CR Number:   361450
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2006 Fixed
16 Oct 2006 Fixed
12 Dec 2006 Fixed
20 Dec 2006 Fixed
22 Dec 2006 Fixed
Description
Feature request for TSQL-based (rather than Java-based) user defined functions



CR:361472
CR Number:   361472
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2004 Fixed
24 Sep 2004 Fixed
10 Sep 2004 Fixed
Description
Introduce a monitor counter usage count to enable multple applications to use monitor counters concurrently



CR:361498
CR Number:   361498
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2004 Fixed
Description
SSL Clients specifying "Diffie-Hellman" key exchange algorithm in the ciphersuites fail in the SSLHandshake. Some clients, such as ODBC TDS based driver, offer ciphersuites which will cause the handshake failures. The certificates don't seem to matter in this problem. isql and OCS clients are fine as long as they specify the default ciphersuites but if the defaults are overridden and "Diffie-Hellman" is offered, the ASE fails in the handshake with them.



CR:361570
CR Number:   361570
Product Name:   Adaptive Server Enterprise
Product Component:   SFTS SDS
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2004 Fixed
Description
EFTS: Traditional Chinese locales were added for Solaris and Windows platforms. Russian locales were added for Linux platform.



CR:361592
CR Number:   361592
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   NA
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2004 Fixed
Description
When a process executes queries in parallel the CPU time reported by the Monitoring Tables for that process is incorrect. The CPU time reported by the monProcessActivity, monProcessStatement and monSysStatement tables has a very high value which relates to the very first time a worker process was used rather than when it was used by the process.



CR:361694
CR Number:   361694
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2004 Fixed
02 Aug 2004 Fixed
Description
A 691 error: "Encountered invalid logical page '<pageno>' while accessing object '<objid>' in database '<dbid>'." may sometimes be encountered when inserting data into an Allpages Locked table with large length columns and having a clustered index.



CR:361705
CR Number:   361705
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2006 Fixed
18 Apr 2006 Fixed
Description
Once a database has been almost fully filled up using the BCP or the

SELECT INTO command, some premature out of data space conditions may

be hit by commands like INSERT, CREATE TABLE, SELECT INTO, BCP, ...

whereas 'sp_helpdb' shows that free data space is available.

Alternatively, for mixed log and data databases, 3475 errors may

be raised under the same space usage conditions.
Workaround Description
 - use a segregated log database (Should avoid the 3475 but may lead to premature 1105)

- disable LSA with TF 1101 (Not recommended, may have big performance impact on command

using LSA (select into, BCP in, reorg rebuild, Alter table AMC), and may lead to a

large increase of logging activity)

- Increase database size since the 1105/3475 may happen when the database is close to be

full (1/32 of the total space is free)



CR:361772
CR Number:   361772
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)
12.5.3 01 Oct 2004 Fixed
19 Jan 2005 Fixed
Description
ASEP support for Encrypted Columns feature in ASE



CR:361814
CR Number:   361814
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2004 Fixed
Description
The error 921, Database '<dbname>' has not been recovered yet - please wait and try again' may be reported when, during an internal upgrade at recovery time, the server has encountered some exception

while bringing a previous database online.
Workaround Description
 Solve the issue leading to the upgrade failure on db1 (or drop and recreate db1 if necessary) and

reset the status of the database db2 allowing its recovery the next tile ASE is rebooted.



CR:361835
CR Number:   361835
Product Name:   Adaptive Server Enterprise
Product Component:   upgrade
Status:   Closed
OS:   HP-UX
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2004 Fixed
Description
Improved the upgrade error messages to better describe the source of the failure.



CR:361898
CR Number:   361898
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)
27 Aug 2004 Fixed
22 Sep 2004 Fixed
10 Sep 2004 Fixed
13 Oct 2004 Fixed
Description
HA feature support on HP Itanium 64 platform running HP-UX 11.23 with HP ServiceGuard A.11.15.

Support for HP ServiceGuard A.11.15 on HPPA 32 and 64 bit platforms.



CR:361899
CR Number:   361899
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2004 Fixed
17 Sep 2004 Fixed
Description
Query referencing views and aggregate in subqueries may fail producing stack traces.

In pre 12.5.2 release such queries would report an error that the maximum number of 16

subqueries has been reached.



CR:361967
CR Number:   361967
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2004 Fixed
Description
The error 10901 "This query requires <value> auxiliary scan descriptors,

but currently there are only <value> auxiliary scan descriptors available.

Either raise the value of the 'number of aux scan descriptors'

configuration parameter or try your query later." can be raised

during the execution of a complex query despite having increased

the 'number of aux scan descriptors' to the appropriate value.
Workaround Description
 Simplify the query when possible.



CR:361979
CR Number:   361979
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2005 Fixed
Description
On the NT platform, sp_listener may incorrectly report a 12990 error when a listener using the NLWNSCK protocol is specified. This may be resolved by removing any trailing whitespace from the

sql.ini entry that represents this listener.
Workaround Description
 remove trailing whitespace from the port number in sql.ini



CR:361988
CR Number:   361988
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2004 Fixed
Description
Msg 168, 'The floating point value '...' is out of the range of machine representation (8 bytes) will be raised when a number underflows to 0.



CR:361994
CR Number:   361994
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2004 Fixed
08 Oct 2004 Fixed
19 Oct 2004 Fixed
10 Jan 2006 Fixed
30 Nov 2004 Fixed
03 Dec 2004 Fixed
07 Jan 2005 Fixed
11 Jan 2005 Fixed
13 Jan 2005 Fixed
11 Apr 2005 Fixed
01 Jun 2006 Presently Not Targeted For Any Future Release Of This Product
02 May 2005 Fixed
18 Apr 2005 Fixed
04 Nov 2005 Fixed
16 May 2005 Fixed
Description
Integration with Unified Agent Framework (UAF) and offer enterprise-wide features such as server discovery, monitoring, and filtering.



CR:362041
CR Number:   362041
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2004 Fixed
Description
Replication Agent may not send to Replication Server an INSERT or DELETE operation performed on a table with text/image column, if a partial rollback occurred during processing.



CR:362075
CR Number:   362075
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2005 One-off Provided
14 Feb 2005 Fixed
26 Aug 2004 One-off Provided
26 Aug 2004 One-off Provided
26 Aug 2004 One-off Provided
11 Oct 2004 One-off Provided
14 Feb 2005 Fixed
Description
ASE running on Sun 32bit platforms may receive signal 10 or signal 11 in routine ksmask__complete. This problem affects ASE running on 32bit systems but using more than 2Gb of memory.
Workaround Description
 While we are waiting for the root cause of this problem to be identified, anyone

encountering the crash caused by the '1-bit' corruption problem can apply EBF12086

which has been found to run stably by shifting the location of the corruption into a

dummy field.



CR:362080
CR Number:   362080
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2004 Fixed
Description
The line currently being executed by each stored procedure has been added as a LineNumber column to the monProcessProcedures Monitoring Table.



CR:362100
CR Number:   362100
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)
23 Dec 2004 Fixed
Description
If a table is altered to add a new identity column, a view created on such table column will incorrectly set the status to allow nulls.



CR:362126
CR Number:   362126
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2004 Fixed
16 Sep 2004 Fixed
Description
The message "current process infected with 11" in the module 'q_score_wktable_ixscan' together

with a stack trace which includes the modules 'q_indexsel_preprocess' and 'q_select_best_index'

may be reported in the error log when a UNION ALL view is joined with another view that

includes a DISTINCT or GROUP BY clause.
Workaround Description
 - Trace flag 4404 to disable pushdown of Union views.

- Change the order of the union view and the other view in the from clause,

so that the union view is the last entry in the from clause.



CR:362170
CR Number:   362170
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2004 Fixed
05 Aug 2004 Fixed
Description
The message 'current process (value) infected with 11' in module

'seq_schema_check_virtab' may be reported in the error log when

an execute cursor is chosen as the deadlock victim during the

open phase of the cursor with a stack trace showing modules

'curs_execute' and 's_checkforrecompile'. Alternatively the

stack trace may show modules 'mapsvs' and 'curs_fetch'.
Workaround Description
 N/A



CR:362204
CR Number:   362204
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2004 Fixed
23 Jul 2004 Fixed
23 Jul 2004 Fixed
Description
Not customer visible



CR:362316
CR Number:   362316
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2005 Fixed
04 Mar 2005 Fixed
Description
A 6401 error, "Cannot rollback <XACT_NAME> - no transaction or savepoint

of that name found." will be reported if a named transaction is rolled back

in which a SELECT that required a worktable (ORDER BY or DISTINCT for example)

preceeded any transactional activity and if the database has replicated objects.
Workaround Description
 Set savepoint before SELECT.



CR:362330
CR Number:   362330
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2004 Fixed
30 Mar 2005 Fixed
Description
The deadlock information reported when the configuration option

'print deadlock information' is active has been enhanced such

that the database name and the index ID values are reported.
Workaround Description
 N/A



CR:362369
CR Number:   362369
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2004 Fixed
Description
On Tru64 Unix platform, ASE may generate stack traces with the wrong symbol names due to the missing libbtsymbols.so file.



CR:362460
CR Number:   362460
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)
22 Mar 2005 Fixed
16 Jul 2005 Fixed
30 Jun 2005 Fixed
Description
When a subquery appears in the ON clause of a Transact-SQL outer join query, the performance may not be efficient. A new traceflag 15302 is now available such that when the traceflag is enabled, ASE will do optimization for subquery attachment to achieve more favorable performance.



CR:362464
CR Number:   362464
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2007 Presently Not Targeted For Any Future Release Of This Product
Description
When sortkey() is called with a unicode string but no sortorder specified it should use

the sortorder specified by the "default unicode sortorder" configuration parameter. However,

it always uses binary.



CR:362498
CR Number:   362498
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)
09 Jan 2007 DEFER
Description
Feature request for a "with_no_log" option for sp_altermessage, to suppress printing of any given server error message number to the errorlog.



CR:362501
CR Number:   362501
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2005 Duplicate
Description
Feature request for some way to disable reporting of 1608 errors to the errorlog



CR:362540
CR Number:   362540
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2005 Fixed
30 Jan 2006 Fixed
Description
The alter table command silently fails when referential integrity constraint has a

non-existent database name.



CR:362610
CR Number:   362610
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)
23 Aug 2004 Fixed
Description
The Java ForXmlTree function in the samples directory

($SYBASE/$SYBASE_ASE/sample/XML) generates different code for client and server,

to accomodate differences between jCommect and the native JDBC driver.

It is generating a SET STRINGSIZE command in the server that should only

be generated for jConnect. The fix to this CR corrects that.



The CR also adds two new options to the 'forxmlj' function:



xmlcheck={yes|no} and xsidecl={yes|no}



These are useful in nested calls of the forxmlj function,

as described in the documentation:

$SYBASE/$SYBASE_ASE/sample/XML/Using-SQLX-mappings.htm



CR:362665
CR Number:   362665
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2004 Presently Not Targeted For Any Future Release Of This Product
23 Aug 2004 Fixed
Description
When UPDATE STATISTICS is run on a table with both consumers and sampling options enabled, subsequently an incorrect value for the table row count might be saved in SYSTABSTATS catalog.
Workaround Description
 remove either the sampling or consumers option from the update statistics command



CR:362703
CR Number:   362703
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2004 Fixed
Description
When Adaptive Server re-evaluates the grantable lock requests that are no

longer blocked, if a new lock request comes in then it may be queued behind

the re-queued locks although it is compatible with them. This situation is

rare, but it will result in unnecessary blocking situations, for example a

'shared intent' table lock that is granted to task A may block a 'shared intent'

compatible table lock requested by task B.
Workaround Description
 dbcc lock_requeue (introduced from CR 299150) can solve this situation manually.

Also check if the config values for 'row lock promotion HWM' and/or

'page lock promotion HWM' need to be increased to avoid prematurely escalating

to a table level lock.



CR:362751
CR Number:   362751
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   NA
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2004 Fixed
02 Nov 2005 Fixed
Description
CIS: Querying a proxy table results in client receiving a "Command has been aborted"

message when the remote server is not available. With this change, more meaningful

error messages 11206 and/or 8013 will be reported in the event of a transaction

failure caused by the remote server shutdown.



CR:362865
CR Number:   362865
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Dec 2004 Fixed
Description
A 20196 error, "ubo_object_from_slot: Mail Boxes Invalid slot id <negative value>"

may appear in the error log followed by a stack trace including the module

'ubo_object_from_slot' and 'smget' or 'smdestroymbox' when a query or a

sort operation was executed in parallel and there was a lack of 'Mail Boxes'

objects.
Workaround Description
 The problem seems to be caused by a lack of mailboxes, maybe

increasing the number of mailboxes via:



sp_configure "number of mailboxes"



CR:362951
CR Number:   362951
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2004 Fixed
Description
On 64 bit platforms, sp_config_rep_agent <dbname>, "scan timeout" cannot be changed from its default value.



CR:363041
CR Number:   363041
Product Name:   Adaptive Server Enterprise
Product Component:   preupgrade
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2004 Fixed
Description
The error 3626, "The transaction was aborted because it used too much stack space.

Either use sp_configure to increase the stack size, or break the query into smaller pieces."

may be reported when executing some some basic queries in 64 bits platforms,

if the stack size is configured with the minimum value allowed.

Likewise, upgrade to 12.5.x 64 bits version from older versions may fail if

the stack size is configured to that minimum value.
Workaround Description
 Before upgrade , change the stacksize to a value at least equal to the default stacksize

of the future version (86016 for ASE 12.5.2 64 bit).



CR:363048
CR Number:   363048
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2004 Fixed
Description
diagnostic instrumentation



CR:363050
CR Number:   363050
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2004 Fixed
Description
diagnostic instrumentation



CR:363150
CR Number:   363150
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2004 Fixed
Description
In rare circumstances, a 12583 error (state 6), "Unable to log a record due to internal error -6. This process will retry at intervals of one minute.", may be reported and transaction locks retained after a transaction manager (like an XA transaction manager) attempts to asynchronously abort the transaction whilst another thread is still busy using the transaction.
Workaround Description
 None



CR:363157
CR Number:   363157
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2005 Bundled Request
Description
Not customer visible



CR:363160
CR Number:   363160
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Open
OS:   NA
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Not customer visible



CR:363357
CR Number:   363357
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   macosx
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2004 Fixed
Description
When building servers on the Mac OS X platform the following message is displayed to the screen, but is not written to the log: "getMsg: unable to find message for code 264453"



CR:363364
CR Number:   363364
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)
18 Aug 2004 Fixed
Description
The message "Msg 225, Level 16, State 1 Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization."

maybe reported when executing a SELECT INTO statement using

views in the FROM clause together with a UNION and a GROUP BY clause. If the same query is placed in a stored procedure, it will endlessly get renormalized until the database runs out of space.
Workaround Description
 If possible, place the views in the first part of the union. If the problem

is happening in a query like:



select whatever into tab

from list of tables

UNION

select whatever

from list_that_includes_views



Then, change it to:





select whatever into tab

from list_that_includes_views

UNION

select whatever

from list of tables



CR:363369
CR Number:   363369
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2004 Fixed
26 May 2005 Fixed
Description
Only ASCII characters are recognized in SQL keywords, numeric literals, and

punctuation. Formerly implemented under command line traceflag -T109,

this is now the default behavior. Traceflag -T109 is now ignored.

A new traceflag, -T114, is introduced to invoke the former default

behavior of allowing equivalence mappings of non-ASCII characters

to participate in SQL language parsing.



CR:363392
CR Number:   363392
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2005 Fixed
Description
Performance Improvements in DDLGen for Users, Groups and Roles. Calls to sp_helprotect have been removed which were the bottleneck in performance.



CR:363474
CR Number:   363474
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   SunOS
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2004 Fixed
Description
An internal change within the Job Scheduler as of the 12.5.2 GA release exposes a problem within the installjsdb script whereby, after upgrading from an earlier version of ASE with Job Scheduler installed, the 12.5.2 ASE uses an incorrectly formatted command to launch the Job Scheduler agent. This causes the Job Scheduler task to generate the message "current process infected with 11" together with a stack trace which includes the modules _doprnt, vsprintf, js__execute, js__chores, jobscheduler.
Workaround Description
 *** Friday, August 06, 2004 2:54:12 PM *** cooperg ***

Drop sybmgmtdb and recreate it. The add back in all jobs and schedules. I find this unacceptable.



CR:363513
CR Number:   363513
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2004 Fixed
21 Dec 2004 Fixed
Description
The 'for xml' feature fails to work when the 'abstract plan load' or 'abstract plan dump' configuration options are switched on. With either of the above options on, a for xml query throws a parser error message that looks like "Received error 156 : Incorrect syntax near the keyword 'for xml'."
Workaround Description
 Workaround is to switch off both 'abstract plan dump' and 'abstract plan load' options.



CR:363515
CR Number:   363515
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2004 Fixed
16 Sep 2004 Fixed
14 Feb 2005 Fixed
13 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
A sub-optimal query plan may be generated for queries containing

subqueries that calculate MAX or MIN aggregates and the aggregate

is on a table that is not correlated with the outer table.
Workaround Description
 May use force index to workaround.



CR:363560
CR Number:   363560
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2004 Fixed
21 Sep 2004 One-off Provided
06 Jan 2005 Fixed
Description
xp_cmdshell encounters Signal 11 when no_output or no_wait parameter is used.

Error message "Invalid parameter value specified. Refer the documentation for

the correct value(s). A signal(11) was raised while executing this ESP.

If this is an user DLL check the code else contact Sybase Technical Support."

will be sent to the client.
Workaround Description
 no workaround.



CR:363581
CR Number:   363581
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Open
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New enhacements to resource limit feature.
Workaround Description
 Use dbcc traceon(3660) or boot with -T3660 to disable MOST of the functionality of 360587



CR:363599
CR Number:   363599
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2004 Fixed
Description
Trailing spaces are not removed when assigning a value, that

results from a SUBQUERY, to a VARCHAR variable.



CR:363774
CR Number:   363774
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2006 Fixed
Description
sp_engine can_offline reports output only for engines which cannot be brought offline due to outstanding 'ct-lib or java sockets or Q' connections.



CR:363810
CR Number:   363810
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   AIX
Original Version:   12.0.0.8 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2004 Fixed
27 Sep 2004 Fixed
Description
The backupserver compression shared library name in IBM release of ASE is changed from libcompress.sl to libcompress.so. This change reflects standard shared object name extension used by IBM.
Workaround Description
 Rename or symlink the 'licompress.so' to 'libcompress.sl'



CR:363815
CR Number:   363815
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2004 Fixed
06 Feb 2005 Fixed
11 Jul 2006 Fixed
Description
Implemented a new strategy for fast first row return for queries using cursors with an ORDERBY. This strategy can be enabled via boot time Traceflag -T329.



CR:363829
CR Number:   363829
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2004 Fixed
01 Sep 2004 Fixed
Description
Not customer visible



CR:363844
CR Number:   363844
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2004 Fixed
Description
CIS: SQL statements containing embedded convert function call with convert style number

may not work correctly.
Workaround Description
 No workaround.



CR:363858
CR Number:   363858
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2004 Fixed
20 Aug 2004 Not a Bug
17 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
If the database option "ddl in tran" is set, an 8201 error will be reported when a table is created and dropped within the same user transaction and another session tries to access the table between the create and the drop.



CR:363879
CR Number:   363879
Product Name:   SQL Remote for Adaptive Server Enterprise
Product Component:   Database Tools Interface
Status:   Closed
OS:   Solaris
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 2400 16 Aug 2004 Fixed
9.0.1 1906 16 Aug 2004 Fixed
9.0.0 1350 16 Aug 2004 Fixed
8.0.3 5146 16 Aug 2004 Fixed
8.0.2 4460 16 Aug 2004 Fixed
Description
If an incoming message contained updates for tables that had index columns of type datetime or smalldatetime that were nullable, and if any of the pre-images of these updates for these columns were null, SQL Remote for ASE may have crashed. This problem is now fixed.
Workaround Description
 A workaround ~may exist~ in the addition of a unique criteria to the table,

but that has not been verified and still does not eliminate the concern

about the seg fault.



CR:363894
CR Number:   363894
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2005 Fixed
06 Jan 2005 EOL'd version. Not to be Fixed.
Description
Backupserver API compression module (with the syntax "compress::<compression-level>::" allows user to specify the same file name for multiple stripes. The resulting dump is not loadable. The new native compression syntax in 12.5.2 (the "with compression = " clause) and higher does not have this problem.



CR:363954
CR Number:   363954
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2004 Fixed
Description
The message "current process infected with 11" in the module 'proc_replace' together

with a stack trace which includes the modules 's_reinstallProcTree' and 's_getTreeOrPlan'

may be reported in the errorlog when executing a stored procedure that calls functions

from java classes and the stored procedure had to be recreated internally using the text

stored in 'syscomments' system table.



CR:363964
CR Number:   363964
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2005 Fixed
Description
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.



CR:364064
CR Number:   364064
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2004 One-off Provided
07 Sep 2004 Presently Not Targeted For Any Future Release Of This Product
10 Sep 2004 Fixed
Description
On the HP-UX platform, system load average may increase substantially when ASE is doing large amounts of asynchronous I/O.



CR:364094
CR Number:   364094
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2006 Fixed
Description
displaying lock promotion values is not documented anywhere.



CR:364117
CR Number:   364117
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2004 Fixed
17 Dec 2004 One-off Provided
Description
The message "infected with 11 in startscan" is printed in the errorlog together with a stacktrace

containing the modules 'exec_eop', 's_execute' and 'sequencer' when an assignment SELECT is executed

using a VIEW with a UNION clause and the "set fmtonly" option is set on.



CR:364124
CR Number:   364124
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)
29 Aug 2004 Fixed
05 May 2005 One-off Provided
Description
LDAP User Authentication failed with "protocol error"

when the LDAP server did not accept LDAP V2 protocol.



LDAP User Authentication failed to find the result set with "no results"

from an LDAP server when it did not return the result as an attribute

name and value.



CR:364224
CR Number:   364224
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2004 Duplicate
31 Aug 2006 Fixed
Description
A spurious Error 2502, Severity 16, State 1, indicating a page linked in multiple

page chains, is reported when dbcc tablealloc is run on a single data partition.
Workaround Description
 The problem described in the CR (spurious error 2502) occurs only when

dbcc tablealloc is run on a single data partition. The work around is

to run dbcc tablealloc on the entire table.



CR:364293
CR Number:   364293
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.2 ESD#2 17 Aug 2004 Fixed
Description
Update language module version, so that locales files will overlay earlier versions of the files.



CR:364403
CR Number:   364403
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2004 Fixed
25 Jan 2006 Not reproducible with latest version of the product available as of Resolution Date
Description
The message "infected with 11 in apu_force_j_alg()" is printed in the errorlog together with

a stacktrace containing the modules 'apa__struct_plan', 's_ap_apply' and 's_compile_stmt' when

a SELECT INTO statement is executed based on a join together with the PLAN-clause using

an AP join operator describing the AP-plan for the join.



CR:364532
CR Number:   364532
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2004 Insufficient priority to fix
Description
The customer has a script that truncates tables and does a BCP of new data for maintenance purposes....once foreign key constraints were created they ran into trouble truncating the tables...so what they want is a switch that temporarily disables foreign key constraints while they perform their maintenance.



CR:364558
CR Number:   364558
Product Name:   Adaptive Server Generic Docs
Product Component:   EFTS SDS and SFTS SDS
Status:   Open
OS:   NA
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
verity operators act like an OR rather than an AND...once parentheses are placed around the search items for example...*1*, *2*, *3*, *4* these fail to work as expected but...

(*1*, *2*, *3*, *4*) these work as expected...



CR:364568
CR Number:   364568
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2005 Fixed
Description
During a cofigured shared memory dump, ASE may print that it is dumping a negative number of bytes.

Additionally, some messages related configured shared memory dumps do not print the correct

unit (i.e. "bytes").



CR:364635
CR Number:   364635
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2005 Duplicate
Description
The "Add Scheduled Jobs" wizard does not validate name entered.



CR:364652
CR Number:   364652
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2005 Fixed
Description
An 8210 error, "Duplicate of work table descriptor found in the id hash table for temporary object ..." may be reported when executing an INSERT ...SELECT DISTINCT query that involves a referential

contraint and the SELECT part of the query has a subquery which is resolved using reformatting strategy.



CR:364807
CR Number:   364807
Product Name:   Adaptive Server Enterprise
Product Component:   SQL Expert
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2007 Duplicate
Description
Database Expert and SQL Expert Database Explorer will generate an error when you attempt to insert data into a table with a column with a unchar or unvarchar datatype



CR:364864
CR Number:   364864
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)
04 Aug 2008 Fixed
Description
The description for the id column in sysprotects needs to include an explanation of what id of 0 is. For example, if a grant is given to a user for 'create table' or 'create default', the id is 0. The description needs to include what a 0 will represent
Workaround Description
 *** Monday, August 23, 2004 1:51:33 PM *** cooperg ***

N/A



CR:364893
CR Number:   364893
Product Name:   Adaptive Server Enterprise
Product Component:   SQL Expert
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2004 Fixed
Description
The message "Error reading SQL; SQL may be lost or corrupted. Please scan again." may occur when running the SQL Expert product.



CR:364894
CR Number:   364894
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 Sep 2004 Fixed
17 Sep 2004 Fixed
Description
The message "current process infected with 11" in the module 'norm3__idriver' together with

a stack trace which includes the modules 'norm3_driver' and 'vu_cleanup' may be reported in

the error log when a nested view with more than 16 subqueries is recompiled.



CR:364904
CR Number:   364904
Product Name:   Adaptive Server Enterprise
Product Component:   SQL Expert
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2004 Fixed
Description
Some objects displayed in right hand panel of the SQL Expert database explorer are not displayed in the tree view.



CR:364905
CR Number:   364905
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2004 Fixed
Description
In the System Admistration Guide Chap 27 page 848 for ASE 12.5 and Chap 28 for ASE 12.5.1 under the section for "Setting shared memory usage" the a reference to more info for the -P option that goes to "Configuring user-defined roles". -P is for threads.



CR:364990
CR Number:   364990
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a method to have SELECTs granted EXCLUSIVE locks; i.e. extend the SELECT FOR UPDATE syntax for more than just cursors



CR:365024
CR Number:   365024
Product Name:   Adaptive Server Enterprise
Product Component:   SDBE
Status:   Closed
OS:   Windows XP
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2004 Fixed
Description
Incorrect lines labeled with date and time values are sometimes displayed in the Data Cache changes in the Database Expert Performance Monitor.



CR:365033
CR Number:   365033
Product Name:   Adaptive Server Enterprise
Product Component:   SQL Expert
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2007 Third Party Problem
Description
Errors may occur during uninstallation when both SQL Expert and Database Expert products are installed on the same machine.



CR:365069
CR Number:   365069
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)
26 Aug 2004 Fixed
27 Aug 2004 Fixed
Description
Failures during preupgrade (for example, insufficient space in a database) are ignored resulting in hangs later on during the upgrade. Output from preupgrade indicates the upgrade is aborted, but it does not actually abort.



CR:365145
CR Number:   365145
Product Name:   Adaptive Server Enterprise
Product Component:   SDBE
Status:   Closed
OS:   Windows XP
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2004 Fixed
Description
Database Expert does not show the Index Impact Details automatically after index analysis even when the Show details on next generation option is selected.



CR:365153
CR Number:   365153
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2010 Fixed
Description
After upgrade is done, syconfig popups with configuraiton option. Clicking languages button and set default for character set, language doesn't show list of character sets, languages
Workaround Description
 Go back to main menu and start configuration option.



CR:365200
CR Number:   365200
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)
26 Aug 2004 Fixed
27 Aug 2004 Fixed
25 Nov 2004 Presently Not Targeted For Any Future Release Of This Product
Description
During recovery, in the rare case of rollback of an incomplete

nested top action, a divide by zero error may occur resulting in

the failure of the recovery of a database.



CR:365229
CR Number:   365229
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Prior to 12.5.0.1 customer was able to get certain statistics from the metadata_cache_stats, this no longer works, returns a -1 return code



CR:365274
CR Number:   365274
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2004 Fixed
Description
The Readme.txt instructions do not reflect the new makefile naming convention.



CR:365290
CR Number:   365290
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2004 Fixed
Description
Dropping a proxy table can result in also dropping the remote table if the remote table was created as a side effect of creating the proxy table



CR:365349
CR Number:   365349
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2005 Bundled Request
Description
ASE must prevent user-id and password from being the same



CR:365374
CR Number:   365374
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2004 Fixed
Description
The message "timeslice -<number> current process infected." together with a stacktrace containing

the modules 'clean_process', 'kill_proc' and 'terminate_process" is printed in the errorlog

after killing a spid in the server using the KILL command.



CR:365413
CR Number:   365413
Product Name:   Adaptive Server Enterprise
Product Component:   SQL Expert
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2004 Fixed
Description
The SQL Collector sometimes displayed incorrect SQL statements when queries were executed before executing a stored procedure.





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

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