提供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:594566
CR Number:   594566
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2009 Fixed
22 Oct 2009 Fixed
Description
INTERNAL ONLY: Increase the default max memory on sol64 platform.



CR:594606
CR Number:   594606
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2009 Fixed
24 Feb 2010 Fixed
30 Nov 2009 Fixed
08 Mar 2010 Fixed
15 Mar 2010 Fixed
Description
Need DDLGen support password encryption



CR:594668
CR Number:   594668
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
error 806 occurs when creating a clustered index on a temp table



CR:594812
CR Number:   594812
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer request to be able to create triggers based on database event for ASE.



CR:594957
CR Number:   594957
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2009 Fixed
Description
If there are more than 32 keys in a group by and there exists a unique index which has attributes which are a subset of the group by keys, then there is a possibility of a signal 11



CR:595091
CR Number:   595091
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Dec 2009 Fixed
Description
Msg 325, Level 18, State 4 may be seen reporting no legal query plan found under specific

circumstances pertaining to a TSQL outer join with an or-clause that contains a subquery

that references an inner member of the outer join.
Workaround Description
 set compatibility_mode on



or



rewrite the query as an ANSI query.



CR:595140
CR Number:   595140
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2009 Fixed
30 Oct 2009 Fixed
28 Oct 2009 Reservation Made
30 Oct 2009 Fixed
Description
The 'showplan' diagnostic output displayed by Adaptive server is incorrect for objects in an in-memory database.



CR:595290
CR Number:   595290
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to add a session specific SET SWITCH equivalent for traceflag 526, which causes a semigraphical tree representation of the query plan to be included in showplan output.



CR:595292
CR Number:   595292
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2009 Fixed
Description
An instance of the cluster which is not down, including the current instance, may erroneously be reported as being down via the following message:



02:00:00000:00000:2009/10/14 15:44:04.07 kernel heartbeat message to server 3

failed, error status 4.

02:00:00000:00000:2009/10/14 15:44:09.10 kernel Instance 3 failed.



03:00:00000:00000:2009/10/14 15:44:04.07 kernel heartbeat message to server 3



CR:595299
CR Number:   595299
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)
09 Mar 2010 Fixed
Description
The SET SWITCH and SHOW SWITCH commands truncate switch names that are over 30 characters wide. In some cases SHOW SWITCH will not display switches that are active.



CR:595448
CR Number:   595448
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2010 Fixed
Description
Sig 11 at GcvIsVIrtualColumn when using allrows_dss and a query involving aggregation and grouping on same column used in a join with a char/varchar match.
Workaround Description
 Use optgoal allrows_mix and/or oltp



OR, in dss set group_sorted off

OR, in dss set advanced_aggregation off



Another workaround by Steve H,

1> set plan optgoal allrows_dss

2> go

1> set group_sorted off

2> go

1> select sec.security_sedol, count(sec.security_sedol)

from tempdb..jk_security_0 sec, jk_wm_batch_security_match wmbsm

where sec.security_sedol = wmbsm.sedol

and mis_security_code is null

group by security_sedol2> 3> 4> 5>

6> go

security_sedol

-------------- -----------



(0 rows affected)



Xun suggested traceflag 15321



CR:595458
CR Number:   595458
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2010 Fixed
07 Jun 2010 Fixed
07 Jun 2010 Presently Not Targeted For Any Future Release Of This Product
03 Jun 2010 Not a Bug
Description
A table corruption may occur with 2525, 1133, or 7968 errors being reported during dbcc tablealloc or dbcc checkalloc when a constraint is dropped and added in the same user transaction.
Workaround Description
 Avoid drop/add constraint within a user transaction.



CR:595488
CR Number:   595488
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to improve the way we handle partition elimination and add a traceflag to disable the mergeunionall transformation.



CR:595501
CR Number:   595501
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2009 Fixed
Description
The durability of a database after MOUNT DATABASE is set to UNDEFINED instead of FULL.
Workaround Description
 After mounting a database execute:



alter database <dbname> set durability=full



CR:595516
CR Number:   595516
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2009 Fixed
Description
A 8203 error, "Expected to find the descriptor for object <negative id>

in database 2 in DROP state." together with a stack trace which includes

the modules 'lwp_drop' and 'des__markdestroy' may be reported in the

error log when a session is trying to release a dynamic SQL statement

(previously prepared) and concurrently another session is trying to access

the same prepared statement, for example using the OBJECT_NAME() builtin

with the id used by the internal procedure created for the prepared

statement.
Workaround Description
 Do not use object_name(id) asking for the name of the

internal light weight procedure (LWP) that it is being

used by a different session.



CR:595550
CR Number:   595550
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2009 Fixed
04 Nov 2009 One-off Provided
Description
A 257 error, "Implicit conversion from datatype '...' to '...' is not allowed. Use the CONVERT function to run this query." maybe be raised when "statement cache" is configured and a client

sets the parameters of a store procedure with a different datatype as defined in the store

procedure with NULL value. Command line traceflag 7741 could be used to allow the execution

of such application with success when 'statement cache' is configured.



CR:595600
CR Number:   595600
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2009 Fixed
28 Oct 2009 Fixed
Description
Installer and "srvbuild[res]" fail to configure an 16k page size ASE with PCI enabled because of insufficient 'max memory'.



CR:595613
CR Number:   595613
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When running traceflag 450 under allrows_mix\allrows_dss

to force group inserting for 12.5.x ordering compatibility (or using group_inserting

abstract plan operator, so not specific to trace 450), a query may hit error

257 (implicit conversion error) if group by clause (with having clause) contains

mixed datatypes which cannot be implicitly converted to one another.
Workaround Description
 set merge_join off



--or



dbcc traceon (15387) --this will result in a nested loop plan.



CR:595709
CR Number:   595709
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2010 Fixed
17 May 2010 Fixed
21 May 2010 Presently Not Targeted For Any Future Release Of This Product
25 May 2010 Fixed
30 Aug 2012 Fixed
Description
Incorrect cleanup of the cursor worktable may happen leaving worktable descriptor in the incorrect state. Additionally the worktable datapages may remain in the tempdb and sometimes different stack trace may happen during cursor cleanup code or while installing/dropping subsequent worktables

for the same session.



CR:595713
CR Number:   595713
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)
24 Jan 2010 Fixed
Description
The DBCC REBUILD_LOG command may assign a used timestamp value for the database.



CR:595825
CR Number:   595825
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2009 Fixed
14 Dec 2009 Fixed
Description
Duplicate rows may be inserted into a table that has a non-unique clustered index and that

has one or more BIT columns even though the option, allow_dup_row is not set. For duplicate

rows to be inserted, the total number of BIT columns in a row must not be an exact multiple

of the number of BITs that can be stored in a BYTE (8) - this is a necesary, but not

sufficient condition.



CR:595882
CR Number:   595882
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2010 Fixed
Description
When execute a select into an existing table multiple times, it could cause stacktrace.



CR:595986
CR Number:   595986
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2010 Fixed
17 Mar 2010 Fixed
Description
A 3151 error, "Adaptive Server cannot load this database because the database that was dumped

was not quiescent when the dump was performed ..." is reported when loading the dump of a database

that has a durability of either NO_RECOVERY or AT_SHUTDOWN on a platform that has a different byte

order to the platform on which the dump was taken. This is despite there being no activity in the

database at the time the database dump was taken.
Workaround Description
 Do not use cross platform dump and load for a database that has a durability of

either NO_RECOVERY or AT_SHUTDOWN, until such a time the current CR is fixed.



CR:595988
CR Number:   595988
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Linux
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2009 Fixed
29 Oct 2009 Fixed
29 Oct 2009 Fixed
29 Oct 2009 Fixed
Description
If $SYBASE starts with /net, srvbuild[res], sqlloc[res], and sqlupgrade[res] report error: unable to load localization file <path>.



CR:596045
CR Number:   596045
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2010 Fixed
Description
An infected with 11 error on function LeSortInputStream may occur when a query

generates a very wide worktable.
Workaround Description
 The core issue is that the width of all the columns being selected is too wide, so either select fewer columns or switch to a server with a larger page size.



CR:596198
CR Number:   596198
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2011 Fixed
11 Feb 2011 Reservation Made
Description
User with sa role is allowed to login to cluster while polite shutdown is waiting for current user connections to exit.



CR:596205
CR Number:   596205
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2010 Fixed
Description
sig11 cause ASE shutdown with nowait fails on Linux



CR:596227
CR Number:   596227
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2010 Fixed
22 Apr 2010 Fixed
Description
When parallelism is turned on, some queries may hang waiting for read operations on pipes.
Workaround Description
 Turn parallism off



CR:596244
CR Number:   596244
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2009 Fixed
Description
A Error 969, "You cannot access local temporary databases from non-owner instance", may be reported when a stored procedure tries to use a temporary table (#table) created outside the stored procedure.



CR:596404
CR Number:   596404
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Open
OS:   Microsoft Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2013 Bundled Request
25 Jul 2013 Bundled Request
Description
DBISQL keeps displaying results in iso_1, even when session is connected as cp850. This causes users to misunderstand data would be wrong. (SQL Advantage displays results correctly.)



CR:596412
CR Number:   596412
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2010 Duplicate
Description
signal 11 at _$o1cexwE0.s_opentables+0xcc
Workaround Description
 To use compatibility mode. But not really for this customer as they want to use ASE15 features.

To set a bigger size of the statement cache. Customer is using a tiny size like 500 2k Pages.



CR:596428
CR Number:   596428
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2010 Workaround
Description
Starting ASE on Solaris 8 can fail with core dump if LD_LIBRARY_PATH contains /usr/lib ahead of /usr/lib/lwp (on 64-bit version, this happens if LD_LIBRARY_PATH_64 contains /usr/lib/sparcv9).

Solution is to fix the environment variable setup scripts like SYBASE.sh/SYBASE.csh not to include /usr/lib in the LD_LIBRARY_PATH (or /usr/lib/sparcv9 in LD_LIBRARY_PATH_64).
Workaround Description
 Change SYBASE.sh/SYBASE.csh to not include /usr/lib or /usr/lib/sparcv9 in the LD_LIBRARY_PATH or LD_LIBRARY_PATH_64.



CR:596532
CR Number:   596532
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2009 Fixed
09 Dec 2009 Duplicate
09 Dec 2009 Insufficient priority to fix
18 Dec 2009 Fixed
Description
ASE Cluster Edition may rarely hang during failover recovery.



CR:596593
CR Number:   596593
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2010 Fixed
24 Mar 2010 Fixed
Description
Using ASE version 12.5.4 ESD# 9 or version 15.0.x using trace flag -T519 to disable streaming sort, Adaptive Server may hit timeslice error when a lot of spids doing sorting or running ASE with compatibility mode.



CR:596623
CR Number:   596623
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)
02 Mar 2010 Fixed
Description
ASE prints "Warning: ASE_HA has no valid license ..." messge in errorlog even when HA feature is not enabled.



CR:596680
CR Number:   596680
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2009 Fixed
02 Mar 2010 Fixed
04 Apr 2012 Added to user documentation
Description
Job Scheduler in ASE is not able to run more than 4 jobs simultaneously.



CR:596681
CR Number:   596681
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2010 Fixed
19 Jan 2010 Fixed
29 Apr 2010 Fixed
02 Mar 2010 Fixed
21 Jan 2010 Fixed
29 Apr 2010 Fixed
03 Aug 2010 Presently Not Targeted For Any Future Release Of This Product
01 Nov 2010 Fixed
Description
Missing message in outputs of sp_helpconfig for some parameters in ASE 1503.



CR:605256
CR Number:   605256
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2009 Added to user documentation
04 Mar 2010 Fixed
14 Dec 2009 Fixed
Description
ASE may hit 692 error during 'disk resize' of filesystem devices when server is using sync IO('allow sql server async i/o' set to 0).
Workaround Description
 Use disk resize with parameter skip_alloc set to true.



CR:605364
CR Number:   605364
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2009 Fixed
Description
When ASE is booted with trace flag 9403 Java performance issues may result due to implicit engine affitinity.
Workaround Description
 NOTE TO THE READER ... THIS PROBLEM ONLY APPLIES ON IBM AIX 15.0.3 from ESD#2



To work around this problem below schenarios may be followed;



1) The ASE does _NOT_ need to execute ASE_JAVA.



Configure "enable pci" = 0 and "enable java" = 0. And reboot the ASE.



The problem will not happen now.



2) The ASE does need to execute ASE_JAVA.



Configure "enable pci" = 1 and "enable java" = 1. And reboot the ASE

with traceflag 9403 where prior to the ASE boot AIX_SCOPE=S is applied

for the run-time. See workaround under CR 577274.



The problem will not happen now.



3) The ASE does need to execute ASE_JAVA but fallback on DSO KonaVM support.



Configure "enable pci" = 0 and "enable java" = 1.



Reboot the ASE with traceflag 9403. PCI Bridge affinity check/force is

not in effect.



The problem will not happen now.



-- Wim ten Have (2009/11/04).



CR:605626
CR Number:   605626
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2010 Fixed
11 Feb 2010 Fixed
22 Feb 2010 One-off Provided
29 Mar 2010 One-off Provided
Description
Job Scheduler (jsagent) heap memory usage grows after job runs resulting in memory leaks.



CR:605661
CR Number:   605661
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
set option or traceflag that turns on reorg rebuild status percent printing to the errorlog.



CR:605671
CR Number:   605671
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2010 Fixed
25 Mar 2010 Fixed
Description
Under some circumstances when a parameterized statement is

being compiled and Adaptive Server is running out of memory

for procedure cache the message "Stack overflow detected" may

be reported in the error log together with a stack trace which

includes the modules 'pars_release_resources' and 'recvhost'

and may result in Adaptive Server being shutdown automatically.
Workaround Description
 Please increase procedure cache size to workaround this issue.



CR:605811
CR Number:   605811
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2009 Fixed
17 Nov 2009 Fixed
18 Nov 2009 Fixed
17 Nov 2009 Fixed
Description
After the command 'set proxy' is executed, RepAgent still sends the original login for replicated transactions instead of the new impersonated login. As a consequence, when replicating DDL commands, objects might be created with a different owner at the replicate site.



CR:605817
CR Number:   605817
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2010 Bundled Request
01 May 2012 Fixed
Description
Previously in DBISQL 9.0.2 the command "set" brings up the Options dialog displaying the current options, but in DBISQL 11.0.1 the dialog is empty.



CR:605862
CR Number:   605862
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2009 Fixed
13 Nov 2009 Reservation Made
Description
If IN lists occur under OR predicates then OR optimization will be considered

for example a query such as the following



select id from sysobjects c

where (id in (1,2) and cache = 10) OR (name="edwin" and uid = 5)



CR:605864
CR Number:   605864
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2010 Fixed
Description
Session can be disconnected if SQL Function references a dropped object.



CR:606012
CR Number:   606012
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2010 Fixed
Description
MonCIPCLinks table not showing the details of all the configured links
Review Status
 ASE Cluster Edition when private secondary links are configured, monCIPCLinks does not display the status of all links. If primary is up but secondary failed (eg. taked down Network interface), then the primary links disappear from the display and vice v



CR:606015
CR Number:   606015
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2010 Fixed
Description
backupserver's charset setting is not correct.



CR:606019
CR Number:   606019
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)
18 Nov 2009 Fixed
23 Nov 2009 Fixed
27 Nov 2009 Fixed
16 Dec 2009 One-off Provided
24 Feb 2010 One-off Provided
16 Apr 2010 One-off Provided
Description
In rare circumstances, message "current process infected with 11" in the module 'des_wkinstall' may be reported in the error log while executing a query that needs to use worktables.



CR:606061
CR Number:   606061
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2010 Fixed
Description
For exec_procedure auditing the sysaudits.dbid and sysaudits.dbname is being redefined

to be the dbid and dbname where the stored procedure executes.



CR:606096
CR Number:   606096
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2009 Fixed
11 Dec 2009 One-off Provided
03 Mar 2010 One-off Provided
Description
Corrects a signal 11 which occurs inside the PeAnySetAllPredBm routine, which can occur if the query is complex and IN list within OR predicates



CR:606210
CR Number:   606210
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)
14 Feb 2012 Deferred
14 Feb 2012 Fixed
14 Feb 2012 Fixed
31 Jan 2012 Reservation Made
17 Feb 2012 Fixed
06 Mar 2012 Fixed
Description
New feature to provide user defined optimization goal functionality.



CR:606231
CR Number:   606231
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2009 Fixed
Description
Execute sp_showplan on a running CIS query may get a Signal 11 stacktrace at

CgpGenerateSQL::_findVariableValue.



CR:606234
CR Number:   606234
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2009 Fixed
17 Nov 2009 Fixed
25 Nov 2009 Presently Not Targeted For Any Future Release Of This Product
20 Nov 2009 Fixed
Description
When ASE is booted with Java enabled and running under a multi-engine environment

the module responsible for physical I/O protection may not be correctly installed.
Workaround Description
 Run single engine



If multiple engines are required then boot with N-1 engines and manually add one more

engine. After this step offline the engine which has the physical COTS JavaVM bound.

Here the highest engine will automatically be reconfigured for the COTS JavaVM where

it does respect the DPRT. Once this is done the offlined engine can be onlined.



CR:606288
CR Number:   606288
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2010 Fixed
04 Jun 2010 Presently Not Targeted For Any Future Release Of This Product
22 Oct 2010 Fixed
18 Oct 2010 Reservation Made
21 Oct 2010 Presently Not Targeted For Any Future Release Of This Product
21 Oct 2010 One-off Provided
22 Oct 2010 Fixed
11 Oct 2011 One-off Provided
16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Parallel queries with more than 6 tables may perform poorly

if any of the tables are roundrobin partitioned. The initial

plan generated by the alternative greedy algorithm may not be able to be

applied due to incompatible parallel degrees between a join's

input sets. This problem can be diagnosed with

show_abstract_plan tracing where "fail" will appear

prior to completing the alternative greedy algorithm phase.
Workaround Description
 Workarounds include:



1) disabling the alternative greedy search algorithm (TCF 15363 or optcriteria

alternative_greedy_search).

2) setting max_parallel_degree to be at least 1 (more is better) greater than

value of max_scan_parallel_degree.



CR:606449
CR Number:   606449
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2010 Fixed
04 Mar 2010 Fixed
Description
Sybase Central BCP in "specify field terminator" requires a "\t" for tab delimited files, while command line -c needs no -t \t arg.
Workaround Description
 Specify the field terminator that the file was bcp'd out with if it is not comma seperated.

Or, use the command line bcp with -c, and it will know the terminators. No need for a -t argument.



CR:606473
CR Number:   606473
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   Windows
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2009 Fixed
28 Jan 2010 One-off Provided
23 May 2010 Fixed
Description
Sybmigrate cannot handle the new device that never used on the source server.
Workaround Description
 Increase the master device size.



CR:606489
CR Number:   606489
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2010 One-off Provided
30 May 2010 Fixed
01 Jun 2010 Presently Not Targeted For Any Future Release Of This Product
30 May 2010 Fixed
Description
Signal 11 occurs with replication setup when Adaptive server is booted with -psa option to reset the sa password.



CR:606648
CR Number:   606648
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2009 One-off Provided
18 Nov 2009 Fixed
14 Mar 2010 Fixed
Description
New traceflag to control the synchronization of file/device between writers.



CR:606659
CR Number:   606659
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2010 Fixed
Description
If the optimizer chooses a hash-join strategy and the hash key

requires an implicit conversion and the build input set has a column

with null values, then a 530 error may be generated during execution:



Msg 530, Level 16, State 3:

Line 2:

Attempt to insert NULL value into column 0 in work table (table id 4294967295); column does not allow NULLS. UPDATE fails.

Command has been aborted.
Workaround Description
 use allrows_oltp



CR:606794
CR Number:   606794
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Sybmigrate:- Add support for migration between different database names



CR:606830
CR Number:   606830
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2009 Insufficient priority to fix
Description
Feature request for a method to override built-in JVM methods, such as java.lang.Runtime methods that reveal information about the server's system, a possible security issue.



CR:606867
CR Number:   606867
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2010 Fixed
Description
A query that contains more than one outer join and one of the inner member's

of the first OJ is a derived table or view may return wrong values.

This could occur only if the second OJ uses a hash or merge

join strategy. Here, first and second are referring to the relative

join order processing. Using the following query as an example:



select a.c1 from

a left join (select distinct b1 from b) as dt on a.a1 = dt.b1 -- OJ #1

left join c on dt.b1 = c.c1 and a.a1 = c.c1 -- OJ #2



Here, OJ #1's inner member is the derived table dt. OJ #2 uses

the result of OJ #1 in the on-clause "dt.b1 = c.c1" and these

columns are transitively associated to OJ #1's result. All of these

on-clause conditions must exist for the problem to occur. In that

case, incorrect values for a.c1 may be returned.
Workaround Description
 1) parallelism OFF

2) OR sp_configure "enable merge join", 0

3) OR using allrows_oltp



CR:606970
CR Number:   606970
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Solaris
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Nov 2009 Fixed
30 Nov 2009 Fixed
03 Dec 2009 Fixed
Description
In some cases, DBCC CHECKALLOC may report error 12909, "Table with object id=<id> (name = <name>) inconsistent after Large Scale Allocation. <no> pages in extent <extid> were found reserved.", some time after either LOAD DATABASE or boottime recovery had processed log records relating to large scale allocation.



CR:607039
CR Number:   607039
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2009 Fixed
03 Dec 2009 Fixed
Description
A user is not allowed to execute a procedure which makes a cross-database

access based on a chain of ownership after the owner's alias is

removed from both databases and his login dropped.



CR:607095
CR Number:   607095
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2010 Fixed
18 Nov 2009 Added to user documentation
05 Feb 2010 Fixed
Description
If a database which is template database for an IMDB is renamed using sp_renamedb, the Imdb will not be accessible on subsequent restart.
Workaround Description
 When you want to rename 'tdb' to 'tdb_old' execute the below SQL.



sp_configure "allow updates", 1

go

update master.dbo.sysdatabases set def_remote_loc='tdb_old' where def_remote_loc='tdb'

go

sp_configure "allow updates", 0

go



CR:607416
CR Number:   607416
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)
26 Nov 2009 Fixed
12 Feb 2010 Bundled Request
Description
sp_object_stats skips to report the lock contention details for the objects in tempdb.



CR:607451
CR Number:   607451
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2009 Fixed
Description
Error 11076 is raised if a procedure name longer than 30 characters is passed to EXECUTE

as a variable rather than a literal, i.e. execute @procname. A workaround is to convert

this to dynamic sql, i.e. execute (@procname)



CR:607464
CR Number:   607464
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2009 Fixed
19 Nov 2009 Added to user documentation
Description
In some cases, when a database that is used as a template for creating a database

with a durability of NO_RECOVERY is being recovered, a 973 error

"The database '<template_dbname>' is currently unavailable. It is being used

to create a new database." may be reported in the error log.
Workaround Description
 This error is not serious and does not impact the correct recovery of any databases.

Following the completion of recovery, however, the 'default data cache' may have a

memory pool configuration that differs from the configured values. Execute sp_poolconfig

and reconfigure the 'default data cache' to required values.



CR:607467
CR Number:   607467
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2009 Fixed
Description
In some rare situations, if a plan has a "group insert" operator, it could encounter a 613 error.



CR:607520
CR Number:   607520
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Configuration Guide for UNIX
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2011 Added to user documentation
Description
DOCUMENT ID: DC38421-01-1503-02

Configuration Guide Adaptive Server Enterprise 15.0.3 [ Windows ]



page 71 has the following ... ( the mention of gb108030 and big5hk is missing ) ...

...

Table 6-3 lists the simplified Chinese character set:

Table 6-3: Simplified Chinese character sets

Character set Unilib required Description

eucgb X EUC GB encoding = Simplified Chinese character sets

cp936 X Microsoft Simplified Chinese character sets



Table 6-4 lists the traditional Chinese character set:

Table 6-4: Traditional Chinese character set

Character set Unilib required Description

cp950 X PC (Microsoft) Traditional Chinese

euccns X EUC CNS encoding = Traditional with extensions

big5 X Big 5 Traditional Chinese

...





page 71 should have the following ... ( gb108030 and big5hk were added ) ...



...

Table 6-3 lists the simplified Chinese character set:

Table 6-3: Simplified Chinese character sets

Character set Unilib required Description

eucgb X EUC GB encoding = Simplified Chinese character sets

cp936 X Microsoft Simplified Chinese character sets

gb18030 X PRC 18030 standard



Table 6-4 lists the traditional Chinese character set:

Table 6-4: Traditional Chinese character set

Character set Unilib required Description

cp950 X PC (Microsoft) Traditional Chinese

euccns X EUC CNS encoding = Traditional with extensions

big5 X Big 5 Traditional Chinese

big5hk X Big 5 with HKSCS extensions

...
Workaround Description
 use the unix version of...



DOCUMENT ID: DC35823-01-1503-02

Configuration Guide Adaptive Server Enterprise 15.0.3 [ Unix ]



http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc35823.1503/pdf/

uconfig.pdf

page 90



CR:607658
CR Number:   607658
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2009 Fixed
18 Dec 2009 Fixed
Description
Sometimes, during recovery redo pass, error 3474 may be seen

indicating that a page being recovered has a timestamp older

than what we expect at that point.



CR:607747
CR Number:   607747
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2010 Fixed
Description
If a view is inner to an outer join and a view column has an expression under it which could lead to potential null row extension, it could return wrong results for assigning this view expression to an local variable.



CR:607765
CR Number:   607765
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2010 Fixed
12 May 2010 Bundled Request
Description
procedure group cannot be created using DBISQL attached to ASE15.0.3 ESDE1 or later.

DBISQL returns a syntax error.
Workaround Description
 Please create procedure group using isql.



CR:607877
CR Number:   607877
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2010 Fixed
14 Sep 2010 Fixed
Description
Stored procedure sp_poolconfig may exhibit inconsistent behaviour and display incorrect error messages.



CR:607924
CR Number:   607924
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2009 Fixed
Description
this change corrects a "no plan found" error

when using trace flag 450



CR:608062
CR Number:   608062
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Additional option to sp_addlogin to allow the suid to be specified.



CR:608117
CR Number:   608117
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2010 Fixed
Presently Not Targeted For Any Future Release Of This Product
Description
When user runs sp_configure 'max memory' above <platform memory limit>, server message 16738 will be printed following message 5846 for 32-bit ASE.
Workaround Description
 Know the limits of your OS, and ignore the 5846 message limit of 4gb.



CR:608170
CR Number:   608170
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2009 Fixed
16 Dec 2009 Fixed
Description
Querying or Accessing monTableTransfer when tables with "transfer table set on" are present would cause 14120 errors or timeslice in the server.
Workaround Description
 There are 2 workarounds:

1. Donot access monTableTransfer table if you have any tables with "transfer table on".

2. If there is a table with "transfer table on" set, also make it a hot object by doing dbcc tune( des_bind,...)



CR:608200
CR Number:   608200
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2009 Fixed
24 Nov 2009 Fixed
Description
Some databases, e.g, sybpcidb, do not show up in ASEPlugin's database list.



CR:608216
CR Number:   608216
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2009 Fixed
07 Feb 2010 Fixed
19 Jan 2010 Fixed
Description
ASE server on 64 bit platforms fails to start the Job Scheduler when LDAP Directory services is enabled.



CR:608223
CR Number:   608223
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2010 Fixed
Description
The message "Infected with 11" together with modules like "stio_write_missing_stats", can be found in the errorlog when "capture missing statistics" is enabled and there are greater than 32 missing statistics to report.

If the session-level 'set option show_missing_stats on' is used it is also possible to hit this bug, stack trace will include VbmManager::_VbmPutBm() and GttTable::GtGatherNoStats()
Workaround Description
 disable 'capture missing stats'



CR:608297
CR Number:   608297
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2009 Fixed
Description
DBISQL:To return number of rows when text result style option is choosen.



CR:608311
CR Number:   608311
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2010 Not reproducible with latest version of the product available as of Resolution Date
Description
If one attempts to "disk init" a raw device giving a size allocation which exceeds that available on the device then the instance engine crashes bringing down the cluster.
Workaround Description
 run 'dd' command on devices, and only allocate devices up to the amount of space that is actually available on the device.



CR:608315
CR Number:   608315
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
After receiving message indicating out of CIPC regular message buffers and the using sp_configure to increase the amount and instance crashed.



CR:608322
CR Number:   608322
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)
13 Dec 2009 Fixed
Description
A row width warning is raised when installing the sp_showcontrolinfo stored procedure



CR:608323
CR Number:   608323
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)
12 May 2011 Fixed
11 May 2011 Fixed
29 Apr 2011 Fixed
26 Apr 2011 Fixed
18 Aug 2011 Bundled Request
Description
The message "Warning: Row size (<value> bytes) could exceed row size limit,

which is 1962 bytes." is raised when installing the system stored procedures

sp_help, sp_helpdb, sp_helpindex and sp_help_rep_agent.



CR:608362
CR Number:   608362
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2010 Fixed
27 Jan 2010 Reservation Made
Description
Expression subqueries in the select list of a view, which is the inner of

and outer join, may get merged into an OR predicate

which has other subqueries, can result in an incorrect answer.

Trace flag 16902 will turn off this change since there may

be some performance degradation.



CR:608897
CR Number:   608897
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jan 2010 Added to user documentation
Description
System Admin Guide example relating to the "open objects" configuration parameter is inaccurate



CR:608905
CR Number:   608905
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2010 Fixed
Description
In sybmon, memload might hit signal 11 on a host which has different page size with the host for memdump.



CR:608963
CR Number:   608963
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Dec 2009 Fixed
04 Jan 2010 Fixed
09 Apr 2010 One-off Provided
Description
The replication status 'never' set on a table may be ignored mistakenly on ASE CE by nodes other than the node where the status was originally set. Alternatively on ASE SMP, this status may be ignored mistakenly after an ASE restart.
Workaround Description
 None.



CR:608975
CR Number:   608975
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2009 Fixed
21 Dec 2009 Bundled Request
Description
The error 3906, "Attempt to BEGIN TRANSACTION in database 'archivedb' failed because database is

READ ONLY. " may be raised when trying to access a partitioned table in an archive database.
Workaround Description
 test test



CR:609045
CR Number:   609045
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)
03 Mar 2010 Fixed
Description
Quoted identifiers are inconsistently handled by the SQL Replication

module leading sometimes to the syntax errors on the replicated site.



CR:609078
CR Number:   609078
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2009 Fixed
Description
In rare some situation, query with host variables could cause SIG 11 at LeColumn:LeColumn().
Workaround Description
 disable statement cache



CR:609326
CR Number:   609326
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2010 Fixed
Description
During shutdown, if the transfer table command tries to create a transaction or insert data into the spt_TableTransfer history table and it might dump stacktrace with itl_record_transfer function in the callstack along with the 16024 error.
Workaround Description
 Stop all transfers before shutdown command.



CR:609330
CR Number:   609330
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2010 Presently Not Targeted For Any Future Release Of This Product
24 Mar 2010 Fixed
Description
When a user with sso_role loads a 15.0.2 database into a 15.0.3 server

with esd version #2 or lower, error 2736 occurs if the user is not a

named user in the loaded database and the database has a guest account.



CR:609349
CR Number:   609349
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2009 Fixed
17 Dec 2009 Fixed
14 Dec 2009 Fixed
14 Dec 2009 Fixed
15 Apr 2010 Fixed
Description
sqlupgraderes can not do upgrade because it can not set $OLDSYBASE.



CR:609365
CR Number:   609365
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2010 Fixed
10 Mar 2010 Fixed
10 Mar 2010 Fixed
11 Mar 2010 Fixed
08 Mar 2010 Fixed
28 Mar 2010 Not a Bug
Description
Enhance ASE WebService to embed Jetty6 and fix SSL MITM vulnerability: CVE-2009-3555.



CR:609460
CR Number:   609460
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2012 Added to user documentation
Description
doc bug: ref manual dbcc monitor also needs sa_role for permissions section



CR:609475
CR Number:   609475
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2009 Fixed
05 Feb 2010 Fixed
Description
In some cases, the error 15717, "The archive database '<dbname>' is already being updated by the process with spid '<spid>'", might be raised when trying to access an archive database that has been recovered by ASE using parallel recovery.
Workaround Description
 In some cases, force serial recovery, using sp_configure max_concurrent, 1





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

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