提供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:689809
CR Number:   689809
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2013 Insufficient priority to fix
Description
When sp_configure "capture missing statistics" is turned on, lists of comma-seperated column names may be output to the console window.



CR:689812
CR Number:   689812
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2011 Fixed
Description
syconfig.exe does not set/add backupserver name to master..sysservers.



CR:689835
CR Number:   689835
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature request to improve locking mechanism for DML to access text data.



CR:689860
CR Number:   689860
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2011 Fixed
19 Dec 2011 Fixed
Description
ASE will fail to dump shared memory when 'number of dump threads' are configured to 2 or more. The errorlog will contain an infected with 11 stacktrace that includes shm_mergedump.
Workaround Description
 Set "number of dump threads" as 1.



CR:689889
CR Number:   689889
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2011 Fixed
09 Nov 2011 Fixed
Description
Automatic partitioning of data caches does not occur in threaded mode if "number of engines at startup" does not equal number of engine threads.



CR:689906
CR Number:   689906
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2011 Fixed
27 Dec 2011 Bundled Request
Description
The error 8009, "Logical page <page number> is not in the given database map." could be raised by the backup server when trying to load a database that has a hole and the physical size of the target database is bigger than the physical size of the archived database but the logical size is smaller.
Workaround Description
 Avoid that the hole in the dump gets partially mapped. That means, create

the database as big as the logical size of the archived database, or as

big as the physical size, but not something in between.



CR:689990
CR Number:   689990
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Suse 10
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2012 Fixed
17 Jan 2013 Fixed
Description
Using "SET STATISTICS" type tracing without appropriate user permissions can result in a stacktrace in OptGlobal::_GblSearchEngine(int*) being reported in the ASE errorlog.
Workaround Description
 as sa, add the permissions for set tracing to the user. e.g.



grant set tracing to <user>

go



CR:690028
CR Number:   690028
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2011 Fixed
Description
In rare circumstance, error 9209, "Missing datarow in TEXT/IMAGE/UNITEXT insert log record.

Transaction log may be corrupt. Please contact SYBASE Technical Support. (current marker =

(page id, rowid))", will be reported if a TEXT/IMAGE/UNITEXT columns is defined to be compressed

explicitly, or the table it belongs to has LOB compression, and this column is configured to

be replicated.



CR:690064
CR Number:   690064
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2011 Fixed
18 Apr 2012 One-off Provided
27 Sep 2012 Fixed
03 Oct 2012 One-off Provided
09 Nov 2012 Fixed
Description
A 11051 error, "ALTER TABLE '<table_name>' failed. Table is currently being used by one or more other tasks." may be reported when a REORG REBUILD command is run while another process concurrently runs a SELECT query on the same table at isolation level read uncommitted. Following this error and while the SELECT query continues to execute, any process that attempts to reference this table will fail mistakenly with an error such as 17461 "Object does not exist in this database.".



CR:690380
CR Number:   690380
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2011 Fixed
01 Jan 2012 Fixed
13 Dec 2011 Duplicate
Description
In ASE 15.5 Cluster Edition, under rare circumstances, rows in a DOL tables may get inserted into a deallocated page and lead to consistency errors later on. For example, the error 12301, "Internal error: the index (id = <indid>) and the data for row (<page>, <row>) in table '<table>', database <dbid> are inconsistent; data is marked deleted but index is not. Aborting the transaction." may be reported in the errorlog.



CR:690406
CR Number:   690406
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #4 14 Nov 2011 One-off Provided
14 Nov 2011 Bundled Request
14 Nov 2012 Fixed
Description
When the coordinator node is shutdown, the new coordinator may be fenced out when new instance joins the cluster. The new coordinator will display write errors and then shutdown e.g. "sddone: write error on virtual disk 0 block 4598". This issue has been resolved via CRs 680776 and CR 686131.



CR:690437
CR Number:   690437
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2012 Fixed
12 Jul 2012 Reservation Made
Description
Expression subquery was always evaluated as part of the aggregate input expression

even when the subquery is under CASE expression and the actual execution of the CASE

doesn't need the result of the subquery. This could lead to unexpected exception

during the unnecessary execution of the subquery.
Workaround Description
 1) Use compatibility mode (this is the preferred workaround):

set compatibility_mode on

<Query to be run>

set compatibility_mode off

go



2) Rewrite the query pushing the case expression down

into the predicate. Note, that this requires that the

ELSE clause can return a value that is guaranteed to

return at most one row when joined with groupinfo_id.

For example, in the original query:



SELECT ISNULL( MAX( CASE WHEN ( A.EX_UP_DIV = '01' AND A.EX_FL_DIV = '24' ) THEN

(SELECT name_kr FROM groupinfo WHERE groupinfo_id = CONVERT(NUMERIC, A.EX_VALUE) )

ELSE NULL

END), 'aa')

FROM ESS_TB_EXCK A



could be rewritten as:



SELECT ISNULL( MAX( CASE WHEN ( A.EX_UP_DIV = '01' AND A.EX_FL_DIV = '24' ) THEN

(SELECT name_kr FROM groupinfo WHERE

groupinfo_id = (case when A.EX_UP_DIV = '01' AND A.EX_FL_DIV = '24' then

CONVERT(NUMERIC, A.EX_VALUE)

ELSE NULL

END)

)

ELSE NULL

END), 'aa')

FROM ESS_TB_EXCK A



CR:690496
CR Number:   690496
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A SYSAM-2 generated license will not work if the word "GROUP" appears at the beginning of a line. The quotes around the enire line/phrase seem to be ignored and the work, "GROUP" looks to be treated as a keyword.
Workaround Description
 Move the word, "GROUP" to the previous line in the license file so that it does not appear at the start of the line.



CR:690533
CR Number:   690533
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2012 Fixed
Description
A wrong result could happen for an equi-join between two columns with different

datatypes (such as INT2 = INT4) and there are two or more OR predicates (including

IN list predicates) on one of the joining columns.
Workaround Description
 Based on feedback from engineering, we tested the following workaround inhouse

to make the related column data type match the constant data type:



alter table subfund modify subfund_id int not null

go

alter table subfund modify trader_user_id int not null

go



CR:690630
CR Number:   690630
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A stored procedure that calls a T-SQL function such as reserve_identity, identity_burn_max or

next_identity will encounter a 10330 or 10354 error. This will occur even if the user has execute

permission for the stored procedure and the stored procedure and the referenced object are owned by

the same user.



CR:690665
CR Number:   690665
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#1 17 Nov 2011 Fixed
15.7 11 Dec 2011 Fixed
Description
The cpu utilization may be excessively high when 'enable hp posix async i/o' is set as 0 and 'allow sql server async i/o' is set as 1 on HPIA64 platform.
Workaround Description
 sp_configure 'enable hp posix async i/o', 1



CR:690704
CR Number:   690704
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature: use sp_maplogin to map external users for Kerberos authentication instead of sybmapname



CR:690707
CR Number:   690707
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2011 Fixed
10 Jan 2012 Fixed
Description
ASE running on Windows platform crashes on startup when the configuration parameter 'allow sql server asynch i/o' is set to the non-default value of 0.



CR:690730
CR Number:   690730
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2011 Fixed
06 Jan 2012 Presently Not Targeted For Any Future Release Of This Product
20 Dec 2011 Fixed
25 Mar 2012 One-off Provided
10 Apr 2012 One-off Provided
02 Oct 2012 One-off Provided
26 Sep 2012 Fixed
18 Oct 2012 Fixed
Description
High rprocmgr spinlock contention may be observed under heavy workload of dynamic SQL and stored procedures.



CR:690748
CR Number:   690748
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2011 Fixed
Description
When a Replication Server issues a 'suspend' to a Rep Agent configured for 'multithread rep agent' the request causes the Rep Agent to perform a full shutdown rather than suspend.



CR:690805
CR Number:   690805
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2011 Fixed
13 Dec 2011 Fixed
Description
When a server user executes the SQL builtin valid_user(<suid>) passing

his own server id to the function, the builtin incorrectly returns TRUE in

the case where the server user is NOT a valid user in any database but where

there exists a guest user in at least one database.



CR:690835
CR Number:   690835
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2011 Fixed
13 Dec 2011 Fixed
Description
Dataserver hits stack overflow during Job Scheduler startup.



CR:690990
CR Number:   690990
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2012 Fixed
16 Jan 2012 Fixed
26 Nov 2012 Fixed
Description
The message "current process infected with 11" in the module 'rec_undo_session' together

with a stack trace which includes the modules 'xact__rollback_local' and 'crt_main' may be

reported in the error log when the 1105 error was previously reported during the creation

of a table.
Workaround Description
 Increase the database log size to diminish the likelihood of hitting error 1105.



CR:691039
CR Number:   691039
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2011 Fixed
Description
When there is a declare cursor on deleted/inserted table in an instead of trigger on a view, INSERT/UPDATE/DELETE on those views triggers the error message.



CR:691073
CR Number:   691073
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2012 Not a Bug
Description
sybmigrate: initial login screen doesn't see servers named with "query"



CR:691074
CR Number:   691074
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2013 Fixed
Description
sybmigrate: initial login screen doesn't see servers named with "query"



CR:691085
CR Number:   691085
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2011 Bundled Request
Description
When marking a database or a table for replication and for using replication indexes for text/image columns, a syntax error 156 may be reported when processing a table whose name is a quoted identifier.



CR:691248
CR Number:   691248
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2012 Fixed
26 Jan 2012 One-off Provided
25 Oct 2012 Fixed
18 Nov 2012 Fixed
Description
When tempdb_space resource limit is reached, any subsequent work table creation operation fails and does not release the buffers and the allocated tempdb pages during the execution.



CR:691255
CR Number:   691255
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2011 Fixed
29 Nov 2011 Fixed
Description
Grouping by UNIVARCHAR column may return wrong result if the UNIVARCHAR column contains NULL and

pure blank values and a GROUP HASHING plan is chosen.



CR:691291
CR Number:   691291
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2011 Fixed
07 Dec 2011 Reservation Made
13 Dec 2011 Fixed
Description
Using JDBC with SELECT_OPENS_CURSOR=TRUE and isolation level 0, error number 16820 is sometimes reported when cursors are erroneously changed from readonly to updatable.



CR:691306
CR Number:   691306
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Generic
Original Version:   3.2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2012 Fixed
Description
feature request to have SCC pop up window for sso_role that is the same as:

set role sso_role with passwd xxxxxxxxx on

So that clients with sso_role can see all encryption keys in all databases without having to login and use isql or dbisql.



Server menu now included 'Role Activation' dialog.
Workaround Description
 use isql



CR:691315
CR Number:   691315
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2011 Fixed
25 Dec 2011 One-off Provided
Description
A signal 11 followed by a stacktrace involving the module 'stb_insertvalue' may be reported when UPDATE STATISTICS is run on one column of an All-pages Locked table and the All-pages Locked table has at least one index with the updated column being one of the key column in the index.
Workaround Description
 None know at this time.

Deleting and running UPDATE STATISTICS does not, apparently, avoid the issue.



CR:691367
CR Number:   691367
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
LIO and PIO appear to be the same always when using histserver recording sessions.



CR:691374
CR Number:   691374
Product Name:   Adaptive Server Enterprise
Product Component:   Pluggable_JVM
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2011 Third Party Problem
Description
The reported problem seems not be an issue related to the ASE integration with JavaVM and the ASE_JAVA execution but more of a problem related on how the IBM JVM(R) J9 VM prompts / responses to memory cleanup within its GC (Garbage Collection) mechanism.



CR:691412
CR Number:   691412
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2011 Fixed
11 Dec 2011 Fixed
Description
The error, "worker Server message: Unclosed quote before the character string '<string>'", followed by error messages "worker jsd_GetResults() failed" and "worker jso_FlushBuffer() failed" may be reported by the JS Agent in the JS agent log.



CR:691458
CR Number:   691458
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2012 Fixed
Description
LDAP errors, such as "The LDAP URL string '' is invalid. LDAP subsystem reported error '(URL row not found in sysattributes)'", may be reported in the ASE errorlog at startup if traceflag 3635 is enabled. This occurs even if "enable ldap user auth" is 0.



CR:691478
CR Number:   691478
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2012 Fixed
18 Jan 2012 Reservation Made
Description
Replication Server may raise the error 14138 when attempting to process a writetext LTL command that was generated using metadata reduction.
Workaround Description
 Disable metadata caching feature (ltl metadata reduction)



CR:691504
CR Number:   691504
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2012 Fixed
24 May 2012 Fixed
Description
The system stored procedure sp_reptostandby now reports the progress of its execution.



CR:691572
CR Number:   691572
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2012 Fixed
Description
Under rare circumstances, selecting over 32 columns using DISTINCT and with the configuration option 'avoid_bmo_sorts'/'ase_current' can lead to 325 errors.
Workaround Description
 set avoid_bmo_sorts off



CR:691582
CR Number:   691582
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)
15.7 SP121 13 Sep 2013 Fixed
17 Sep 2013 Reservation Made
15.7 SP110 13 Sep 2013 Fixed
Description
In rare cases, a DUMP TRAN command is incorrectly allowed following a DUMP DATABASE command during which a partially-logged command like SELECT INTO was active that also commits some time towards the end of the DUMP DATABASE command. The partially logged operation will be lost when the database dump and transaction log are loaded.
Workaround Description
 None



CR:691595
CR Number:   691595
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2011 Fixed
Description
Full syntax object defination is not allowed for ALTER ENCRYPTION KEY ... MODIFY OWNER command.



CR:691627
CR Number:   691627
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2011 Fixed
Description
The message "current process infected with 11" in the module

'css_deallocate' together with a stack trace which includes

the modules 's_free' and 's_cleanframe' may be reported in the

error log under some circumstances if the execution of a stored

procedure using a cursor was aborted by an error (like a 1205

error caused by a deadlock) and the plan being executed was

just recompiled.



CR:691734
CR Number:   691734
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 28 Nov 2011 Fixed
Description
New Feature Request for binary datatype that allows NULL values but does not truncate trailing zeros.
Workaround Description
 Use

binary() NOT NULL



which allows NULL and trailing zeros to be returned but you cannot insert NULL values into it.



CR:691753
CR Number:   691753
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
fingerprint function for objects with hidden SQL text



CR:691764
CR Number:   691764
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_flushstats no longer clears systabstats emptypgcnt column in 15.x like it did in 12.5.4.



CR:691780
CR Number:   691780
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2011 Fixed
Description
In rare circumstance, error 874, "Process <process id> is trying to unkeep buffer <buffer address>

(dbid: <dbid>, pageno: <page id>) without releasing the exclusive latch it holds on the buffer.",

may be reported with stack trace when running UPDATE/WRITETEXT commands on TEXT/IMAGE/UNITEXT

columns, or DELETE...FROM/TRUNCATE TABLE/DROP TABLE commands on tables which have TEXT/IMAGE/UNITEXT

columns, or DROP DATABASE command on databases which have tables contains TEXT/IMAGE/UNITEXT

columns.



CR:691812
CR Number:   691812
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2011 Fixed
Description
After the master key owner sets the password for the master key on one cluster instance, creating a column key protected by master key on another cluster instance may result a 2950 error (master key copy does not exist).



CR:691854
CR Number:   691854
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2012 Added to user documentation
Description
The Reference Manual entry for sp_monitorconfig indicates that only System Administrators can execute it. The permissions actually require either sa_role or mon_role.



CR:691914
CR Number:   691914
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2011 Duplicate
Description
Using 15.7 default configuration, old client drivers using a 512 byte packetsize gets disconnects/hangs. ASE sees nast_readpost() Invalid tdslength errors. When sending more than 1024 bytes.
Workaround Description
 Upgrade client to one that only uses 2048 byte as defaults or run "kernel mode", process or set the ASE default packetsize to 512.



CR:691929
CR Number:   691929
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2011 Fixed
Description
If the character set is UTF8 and a stored procedure is created with upper() or lower() builtin function and it has a LIKE clause to compare this upper() or lower() with another parameter, a 2431 warning message may be raised when the stored procedure is recompiled.
Workaround Description
 * create the stored procedure using compatibility mode



CR:691967
CR Number:   691967
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2011 Fixed
Description
Dynamic SQL execution with noexec set correctly suppresses execution but does not result in a query plan. This results in no output from show_cached_plan_in_xml().



CR:692003
CR Number:   692003
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2011 Fixed
15 Mar 2013 Fixed
Description
Sybmon failed to load memory dump with error 13 on ibmaix64 platform.
Workaround Description
 - Load the memdump running as root user.



or



- Dave Putz found the following workaound which worked fine:



1) Run ASE using a debugger:

/usr/u/dputz/gdb.aix60 /remote/releases/aix/rel155_ebfs/ebf18658/ASE-15_0/bin/dataserver

2) set a breakpoint - *note* that this address will change for different EBFs - this is for 18658

break *0x101f06c7c

3) Run as sybmon

run -X -Pquine

4) Load the memdump

memload SYBBH95-10230.mem

5) At the breakpoint, change the value of the r6 register

set $r6=8576

6) Continue executing

cont



This will get the memdump loaded. When exiting, you will have to do an extra 'quit' to exit the debugger.



CR:692050
CR Number:   692050
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2011 Fixed
06 Dec 2011 Reservation Made
07 Dec 2011 Fixed
08 Dec 2011 Fixed
Description
After inserting XML data into compressed TEXT column using BCP IN/ODBC BULK/WRITETEXT BULK, 7136

error, "ASE is now using a multi-byte character set, and the TEXT character counts have not

been re-calculated using this character set for table <table name>. Use DBCC FIX_TEXT on this table

before running the query again", may be raised when query data from this compressed TEXT column.



CR:692086
CR Number:   692086
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2011 Fixed
Description
A task may hang even though the connection at other end is down.



CR:692132
CR Number:   692132
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to certify ASE with NUMA architecture, which is available with several hardware options and supported by Oracle and MS-SQL.



CR:692176
CR Number:   692176
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2012 Fixed
05 Mar 2012 One-off Provided
06 Mar 2012 Fixed
01 Mar 2012 Fixed
Description
In ASE Cluster Edition, dropping a database and recreating a new local temporary database reusing the same database ID may result in issues during runtime.
Workaround Description
 Recycling the whole cluster would avoid any issues because of reusing the database id.



CR:692233
CR Number:   692233
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2011 Fixed
Description
When Replication Server set dsi_bulk_copy 'on' to replicate compressed LOB data to the replicates ASE, the replicated ASE may be not able to recognize the compressed LOB data and insert them incorrectly as plain TEXT.



CR:692237
CR Number:   692237
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2012 Fixed
21 Dec 2012 Fixed
21 Dec 2012 Reservation Made
07 Aug 2013 Fixed
Description
Starting the Backup Server with -D4096 will suppress messages "Attempting DSync I/O for device '<value>'." from being reported in the Backup Server error log during the execution of a DUMP DATABASE command.



CR:692246
CR Number:   692246
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2011 Fixed
Description
When replicating compressed data, the RepAgent thread is leaking memory from the 'compression info'

memory pool. As a consequence, error 716 may be reported ("Unable to allocate memory of size <n> bytes from the 'compression info' pool.").



CR:692333
CR Number:   692333
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2012 Fixed
17 Dec 2011 Fixed
08 Nov 2012 Fixed
Description
In rare circumstances on a heavily-loaded multi-engine system, the message "timeslice <value>, current process infected" together with a stack trace which includes the modules 'jldr_ReleaseLocalLoader' and 'pci_free' may be reported in the error log when applications use JAVA extensively.



CR:692345
CR Number:   692345
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A new feature request for an sp_addmessage option that will suppress echoing the newly added message

text back to the client.



CR:692359
CR Number:   692359
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
07 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
07 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
07 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
21 Mar 2014 Fixed
07 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
07 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
07 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
02 Sep 2014 Fixed
25 Mar 2014 Fixed
Description
Performance Enhancements to BCM Latching without Cache spinlock in addition to Buffer ELC changes for ASE Scaleup.



CR:692431
CR Number:   692431
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2012 Fixed
Description
When executing an EQUI-JOIN using a local index scan at the inner side of a NESTED LOOP JOIN, a stacktrace involving the module CgpUnion::_cgpInit() may be reported in the errorlog.
Workaround Description
 set bushy_space_search off



--or



dbcc traceon (16936)



CR:692509
CR Number:   692509
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2012 Fixed
Description
sp_sysmon 'cache wizard' got Msg 3606 "Arithmetic overflow occurred"



CR:692550
CR Number:   692550
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2012 Fixed
26 Apr 2012 One-off Provided
25 Jun 2012 Fixed
06 May 2013 Fixed
Description
A 11060 error, "This statement has exceeded the maximum number of recompilations (10). This indicates an internal error. Please note the error prior to this one and contact Sybase Technical Support.", may be reported under some circumstances when a stored procedure containing a SELECT INTO ... UNION statement is executed and references session temporary tables and/or stored procedure parameters.
Workaround Description
 turn on traceflag 15316



CR:692691
CR Number:   692691
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2012 Added to user documentation
Description
Documentation: ASE System Admin Guide, Changing character set or sort order should warn that no database can be read_only and that precludes changing the charset on servers that have existing archive databases.
Workaround Description
 n/a



CR:692711
CR Number:   692711
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The dbcc reindex comand is only documented currently with no options. There are situations where one many wish to rebuild indices without checking.



CR:692775
CR Number:   692775
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2011 Fixed
Description
The message "current process infected with 11" in the module 'open__common_sdes_setup'

together with a stack trace which includes the modules 'pggam_getfree_lowhigh' and

'crt_work' may be reported in the error log and the session killed if a 603 error

has been previously hit "There are not enough system session descriptors available

to run this query. Raise the value of the configuration parameter 'number of aux scan

descriptors' or retry your query later.". Alternatively a stack trace which includes

the modules 'open__lwpbyname' and 'sqt_get_plan' may be reported.
Workaround Description
 Raise the value of the configuration parameter 'number of aux scan descriptors'.



CR:692870
CR Number:   692870
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2012 Presently Not Targeted For Any Future Release Of This Product
28 Sep 2012 Fixed
26 Sep 2012 Reservation Made
Description
Enable pinning of dynamic SQL query plans via the configuration option 'dynamic SQL plan pinning'. This is a productization of trace flag 480.



CR:692872
CR Number:   692872
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2012 Fixed
20 Jan 2012 One-off Provided
05 Nov 2012 Fixed
Description
In rare circumstances, Adaptive Server may hang as a result of an undetected deadlock between a process that is executing a DUMP TRANSACTION and another process that is running a query that uses the last-chance threshold builtin LCT_ADMIN.
Workaround Description
 Do not run queries using lct_admin at same time as dump tran.



If customer hits this issue, they can kill the lct_admin spid, then dump tran will finish.

Attempts to kill the dump tran spid while the lct_admin spid is still waiting for a lock

will not work.



CR:692873
CR Number:   692873
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2012 Fixed
10 Jan 2012 Reservation Made
10 Feb 2012 Fixed
Description
ASE client connection (sometimes a replication agent connection) hangs in a call to ct_cancel with the message, "kernel usrcancel: request structure in use", reported in the errorlog.



CR:692898
CR Number:   692898
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2011 Fixed
16 Feb 2012 Fixed
Description
The stored procedure, sp_reptostandby, will now print a message warning that the execution can take a long time.



CR:692946
CR Number:   692946
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2012 Fixed
04 Jun 2012 Fixed
Description
Merge partition into an existing partition but not a different segment is not supported, but the command will succeed even though the command takes no effect.



CR:692959
CR Number:   692959
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2011 Fixed
Description
ASE on Windows platform crashes with a storage access violation followed by a stacktrace in the errorlog involving the modules 'spinobtain' and 'ws__nclose_defer'.



CR:692961
CR Number:   692961
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2012 Fixed
Description
Trailing zeroes from varbinary (or binary null) columns in proxy tables are truncated even though 'disable varbinary truncation' is set.
Workaround Description
 None known.



CR:693011
CR Number:   693011
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Suse 10
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An infected with 11 may occur in function sprintf with EquivClass::eqcCostComputeTree on the stack when literal autoparam is active.



CR:693221
CR Number:   693221
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2011 Fixed
Description
When one of the configuration options, enable functionality group or streamlined dynamic SQL, is enabled and a query containing a COMPUTE clause is executed more than once and the query is either a dynamic SQL or an ad hoc query that is stored in the SQL statement cache, then an extra empty row may be returned on the second and subsequent executions.



CR:693269
CR Number:   693269
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2011 Fixed
Description
sp_who in chained mode fails with 226, 17260, and 3701 errors due to misplaced select in installmaster script.



CR:693322
CR Number:   693322
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2011 Fixed
Description
Users who have replication_role should not be able to truncate system catalogs

or audit tables.



CR:693329
CR Number:   693329
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2012 Fixed
10 Jun 2012 Reservation Made
01 Jun 2012 One-off Provided
15 Jul 2012 One-off Provided
Description
In rare circumstance, the message, "current process infected with signal 11" or error 632, "Attempt to move memory with an incorrect length of <length>. Maximum allowed length is <max length>." may be reported with stack trace after upgrading to ASE 15.7.



CR:693355
CR Number:   693355
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2012 Presently Not Targeted For Any Future Release Of This Product
14 May 2012 Fixed
10 Apr 2012 Fixed
30 Oct 2012 Fixed
14 Dec 2012 Fixed
Description
When the ASE ESD number is not an integer (e.g. 1.1, 4.1 or 5.1 etc), then anything using the sp_versioncrack stored procedure (e.g. sp_spaceusage) may encounter a 249 error (conversion error).
Workaround Description
 Modify the sp_versioncrack stored procedure:

FROM: select @outint = convert(int, @outstr)

TO: select @outint = convert(int,convert(numeric(6,0), @outstr))



CR:693358
CR Number:   693358
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2011 Fixed
Description
After inserting data into TEXT column using java string in ASE server which uses multi-byte character set, a 7136 error, "ASE is now using a multi-byte character set, and the TEXT character counts have not been re-calculated using this character set for table <table name>. Use

DBCC FIX_TEXT on this table before running the query again", may be raised when querying data from this TEXT column.



CR:693413
CR Number:   693413
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Dec 2011 Fixed
25 Sep 2013 One-off Provided
25 Sep 2013 Fixed
Description
The wash size may be returned as a negative value in the ASE configuration file.
Workaround Description
 Change the value in the configuration file.



CR:693430
CR Number:   693430
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PCI enabled with PAM auth allow native thread send signal to ASE
Workaround Description
 Don't enable PCI



CR:693442
CR Number:   693442
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2011 Fixed
Description
Under a rare situation, if a CONVERT node is needed for the like clause, it could return wrong result.



CR:693483
CR Number:   693483
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2012 Work as design
Description
In 15.0.3 ESD#4 and earlier, monCachedProcedures would return view, rules, default in addition to triggers and stored procedures



CR:693485
CR Number:   693485
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
require to have the capacity to disable auditing of trigger activity.



CR:693491
CR Number:   693491
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX 5.1
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A transient 605 error may be raised by a query against a table(lock scheme datarows) having des_bind and REORG REBUILD has just been done. Please use dbcc tune(des_unbind,dbid, objname) to unbind the object before REORG REBUILD to avoid the error.
Workaround Description
 The customer may need to unbind the bound tables to avoid the error.



If no other session is using related cached compiled objects, then use dbcc proc_cache('free_unused') to flush out the plans in procedure cache after reorg rebuild may help also.



CR:693592
CR Number:   693592
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2011 Fixed
27 Dec 2011 Bundled Request
Description
DUMP TRAN may fail with a 4205 error if the database has any sysusages rows in the master database with a NULL value for the location column and an unreservedpgs value larger than 65535.
Workaround Description
 If sysusages.location is null, update to 0



CR:693685
CR Number:   693685
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2014 Insufficient Info to Progress
05 Mar 2012 One-off Provided
21 May 2012 One-off Provided
Description
Instrumentation: In ASE Cluster Edition, user tasks may hang, and cannot be killed, and also block other user tasks from proceeding by holding locks.



CR:693728
CR Number:   693728
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2012 Fixed
Description
A 204 error followed by a stack trace involving the modules 'norm3_propagate', 'norm3__driver' and 'normalize' may be reported in the errorlog when a parameter, other than the allowed integer datatype, is specified for the identity() built-in.



CR:693762
CR Number:   693762
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2012 Fixed
12 Apr 2012 Fixed
Description
In some circumstances in a cluster environment ALTER DATABASE can get a self deadlock.



CR:693772
CR Number:   693772
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2012 Added to user documentation
Description
Unicode sort order 54 is incorrectly described as being accent insensitive when it should be accent AND case insensitive.



CR:693775
CR Number:   693775
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2012 Fixed
10 Jul 2012 Fixed
Description
Job Scheduler is enhanced to execute job from startdate:starttime to enddate:endtime under new schedule property 'continuous_run'.



CR:693794
CR Number:   693794
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Comparisons under utf8 sort order 54 can give incorrect results



CR:693798
CR Number:   693798
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2012 Fixed
Description
An error 2836, "The cursor 'cur' is already tracking another procedure. This is an internal error.", followed by a stacktrace involving the modules 'curs_release', 'curs_close' and 'css_deallocate' may be reported when a cursor that needs to recompile is opened.



CR:693828
CR Number:   693828
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Tables
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Doc CR: ASE sysdatabases status columns need to include newer values in manual pages.



CR:693835
CR Number:   693835
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Generic
Original Version:   3.2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2012 Fixed
Description
Compared to ASEMAP 3.2.5, new icon is used to separate already-revoked permission (x mark in dark blue) from to-be-revoked permission (x mark in red) in ASEMAP 3.2.6.



CR:693925
CR Number:   693925
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2012 Fixed
Description
When Server Discovery is enabled and "UDP" discovery service is included, server discovery such as "Find" on Connect Dialog, or verifying cluster name on Create Cluster Wizard may take a very long time.



CR:693982
CR Number:   693982
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2015 Fixed
Description
alter table fails to update status2 in syscolumns when column being modified to add/drop a default value





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

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