远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着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:575330
CR Number:   575330
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)
17 Jun 2009 Fixed
Description
ASE stacktraces with SIGSEGV (infected with 11) when the number of columns returned from a remote procedure is less than expected from the select list to a proxy table mapped to this remote procedure.
Workaround Description
 Fix the stored procedure or re-create the existing table.



CR:575337
CR Number:   575337
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)
28 Jul 2009 Fixed
Description
Procedural statement with FOR UPDATE clause may incorrectly raise error Msg 7305, Level 15, State 1:



FOR UPDATE can not be used in a SELECT which is not part of the declaration of a

cursor or which is not inside a stored procedure.
Workaround Description
 dbcc traceon(3604,7730)

go



CR:575359
CR Number:   575359
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)
21 Jun 2009 Fixed
21 Jun 2009 Reservation Made
Description
ASE assumes DC supports BIGINT datatype and incorrectly sends signed/unsigned NULL integer

parameters as BIGINT datatype.
Workaround Description
 *** Thursday, June 04, 2009 01:00:13 PM *** pvero ***

- Don't use null value - maybe change procedure logic



- Use numeric(10,0) - not sure this works with DC/TRS 15.0 but will be suggested and possibly tested.



CR:575390
CR Number:   575390
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request ... immediate recompile sproc & change to view after Alter Table Modify Column



CR:575392
CR Number:   575392
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)
02 Aug 2009 Fixed
Description
Insert queries involving proxy tables which are either part of a trigger or will fire a remote

trigger may encounter a SIGSEGV (infected with 11). "xact_sync_trigger" will usually be referenced in the stacktrace.
Workaround Description
 using -T 7730

or change the order of insert selects in the sp would stop the stack trace



CR:575483
CR Number:   575483
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)
09 Jun 2009 Fixed
19 Jun 2009 Fixed
16 Sep 2009 Fixed
aries 16 Sep 2009 Fixed
24 Feb 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Query accessing more than 16 tables may raise incorrectly error 225 "Cannot run query--referenced object dropped during query optimization."
Workaround Description
 rewrite the query



CR:575502
CR Number:   575502
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)
18 Dec 2009 Fixed
Description
sp_configure cannot display reports correctly when there are large amounts of unused memory
Workaround Description
 Always keep 'max memory' and 'total logical memory' within a sensible distance of each other.



CR:575562
CR Number:   575562
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2009 Fixed
07 Oct 2009 Reservation Made
Description
Error: 2805, Severity: 18, State: 0

Bad pointer 0x4 encountered while remapping stored procedure.



This may be seen in the error log on execution of sql statement containing constants in

both the predicate and in a group by clause.

Should only happen with 'enable query metrics' enabled at point of proc creation.
Workaround Description
 create the procedure with query metrics disabled.



set metrics_capture off

go

<create proc>

go



Once created with metrics disabled, you can re-enable it and the procedure should not

report 2805.



CR:575675
CR Number:   575675
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 Jun 2009 Fixed
01 Jul 2009 Fixed
Description
Server always selects Slow Bulk mode for bulk copying rows into table with non-clustered unique index.



CR:575761
CR Number:   575761
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)
07 Jul 2011 Fixed
06 Jul 2011 Reservation Made
11 Jul 2011 Fixed
12 Jul 2011 Fixed
08 Jul 2011 Fixed
12 Jul 2011 Fixed
Description
The index_union algorithm can be invoked when queries contain the OR operator or IN list operator. This algorithm was not permitted when selecting data at isolation level 0 (dirty reads) on dol tables. This algorithm will now be permitted on DOL tables with dirty reads when optcriteria cr575761 is active, and/or trace flag 16734 is on. The behavior change will be turned off if trace flag 16733 is on.

If the algorithm is chosen then index_union appear as a hash union of several index scans followed by rid join in the showplan output.

The abstract plan would contain a hash_union_scan if this algorithm was chosen with dirty reads on DOL tables.



CR:575846
CR Number:   575846
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2009 Fixed
Description
Transfer table using BCP format cannot output to a pipeline.



CR:575903
CR Number:   575903
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 Aug 2009 Fixed
Description
Executing a NULL stored procedure by 'exec @proc' where @proc = NULL hit stack trace in the modules open_user_table() and procget() and get error 2812.



CR:575946
CR Number:   575946
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)
12 Aug 2009 Fixed
18 Aug 2009 Fixed
Description
The database option "no ckpt on recovery" is incorrectly turned on after a load database command on the master database successfully completes.
Workaround Description
 In single user mode, run update sysdatabases set status=0 where dbid=1.

Then restart your ASE in multi-user mode to check that everything is OK.



CR:575947
CR Number:   575947
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
Provide an example for page 74 of CE installation guide on IO fencing



CR:575993
CR Number:   575993
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2009 Fixed
17 Jul 2009 Fixed
Description
Connect Dialog would not allow modified server entry if it has previously connected to the server before modification was attempted.
Workaround Description
 To get around the problem, customer can clear the remembered servers:

Open Connect dialog.

Click Settings button and open Settings dialog.

Select "Clear servers" check box and click OK.



CR:576077
CR Number:   576077
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)
06 Dec 2013 Insufficient priority to fix
Description
When utf8 client connects to the eucjis ASE and runs dump database command, dump command fails due to a tds protocol error "Premature end of the datastream was encountered.".
Workaround Description
 Connect your ASE with the same charset as ASE's when you run dump database command.



CR:576097
CR Number:   576097
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2009 Fixed
08 Jul 2009 Fixed
Description
The durability of database should be changed with the ALTER DATABASE

command.



CR:576139
CR Number:   576139
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2010 Fixed
12 May 2010 Fixed
12 May 2010 Fixed
Description
The performance of concurrent DMLs in a low durability database has been slightly improved through an optimization to post-commit processing of deallocated pages.



CR:576250
CR Number:   576250
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2009 Bundled Request
Description
The error 4218, "Failure during DUMP of database '%.*s': serial log page

allocation rules broken. Current page: %d; next page: %d; piece end: %d;

end-of-scan: %d.", may be reported while creating a in-memory database

using a template database which does not have full durability.



CR:576295
CR Number:   576295
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2009 Fixed
01 Sep 2009 Fixed
Description
There is possibility of segmentation fault during XPDL conversion of a page whose page header is incorrect with PG_DATA and PG_OFFSET bits set simultaneously.



CR:576346
CR Number:   576346
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2009 Fixed
14 Jul 2009 Fixed
24 Feb 2010 Fixed
Description
Add PCI options into sybatch_ase.res file.



CR:576357
CR Number:   576357
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)
15 Sep 2009 Fixed
18 Sep 2009 Fixed
23 Nov 2009 Not a Bug
21 Dec 2009 Presently Not Targeted For Any Future Release Of This Product
Description
If a parallel plan is chosen for an AMC repartition operation, sometimes the data could be inserted into the wrong partitions.



CR:576525
CR Number:   576525
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 Aug 2009 Fixed
26 Aug 2009 Fixed
Description
Database Wizard's (Add) Device Size Dialog does not sort device sizes correctly.



CR:576647
CR Number:   576647
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)
01 Jul 2009 Fixed
01 Jul 2009 Reservation Made
Description
If error 249 occurs during and it does not appear to be due to constant in the query and the query has not started execution i.e. compilation is still proceeding, then this error may occur due to expression histogram processing. This can be verified by looking at the optdiag output for the columns in the query, and determining if there is a possible conversion error that could occur with one of the histogram step values. The change in behavior will be to suppress the error and use magic numbers for the selectivity of that column when used in expression histogramming.
Workaround Description
 Use traceflag 15352 to turn off expression histogramming.



or delete or edit the problem histogram with optdiag to have legal date values



or turn off statement cache



CR:576708
CR Number:   576708
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)
26 Jun 2009 Fixed
Description
Inserting a NULL value into a TEXT column of a proxy table with an INSTEAD OF TRIGGER may result in an assertion failure involving the module eval_locator_bi().



CR:576731
CR Number:   576731
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
NewFeature ASE 15.x - Configure for memdump during install



CR:576785
CR Number:   576785
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2009 Fixed
11 Aug 2009 Bundled Request
Description
When attempt to create a cache, or increase the cache size, through

the sp_cacheconfig interface, fails due to insufficient 'max memory',

the suggested 'max memory' value printed as part of the following

error message:



"The current 'max memory' value '%d', is not sufficient to change

the size of cache '%s' to '%dM' (%d KB). 'max memory' should be

greater than 'total logical memory' '%d' required for the configuration."



is not sufficient if the server is rebooted after the change.
Workaround Description
 Increase the 'max memory' to at least 2 more pages than the

value suggested by the error message.



CR:576869
CR Number:   576869
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
syslogs becomes corrupted again after loading a dump tran which stacktraced



CR:576895
CR Number:   576895
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)
06 Jul 2009 Fixed
Description
INSERT into a VIEW which triggers an INSERT into the proxy table may cause error 3651

when the remote table also triggers a change in one of the column values being inserted.



CR:576903
CR Number:   576903
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2009 Fixed
18 Jun 2009 Fixed
18 Jun 2009 Fixed
23 Jun 2009 Fixed
14 Sep 2009 One-off Provided
Description
Spid executing MDA retrieval may go to sleep indefinitely under rare conditions whilst trying to take out a mutex.

Stack trace will report upsleepgeneric, mda_take_mutex, fdpsrv_init_reader.
Workaround Description
 NA



CR:577089
CR Number:   577089
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 Nov 2010 Fixed
Description
SELECT * INTO temp table from a VIEW with TOP and UNION ALL doesn't return all the rows.
Workaround Description
 select top 1000000 * into #sb from abc

Another workaround

insert #sb select * from abc



CR:577103
CR Number:   577103
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)
21 Dec 2011 Duplicate
Description
Select with ORDER BY from a view involves TOP and UNION ALL doesn't return all rows.
Workaround Description
 The only workaround is to enable TF4404(internal use).



CR:577113
CR Number:   577113
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2009 Fixed
02 Jul 2009 Fixed
01 Sep 2009 One-off Provided
02 Dec 2009 One-off Provided
20 Jan 2010 One-off Provided
18 Mar 2010 One-off Provided
30 Mar 2010 One-off Provided
Description
There is a possiblity of hitting a deadlock on the sysconfigures table when two sp_configures are run at the same time.



CR:577126
CR Number:   577126
Product Name:   SCC Web Framework
Product Component:   Documentation - Other
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2009 Fixed
Description
Servers will not be displayed in the Replication Topology if they are registered with a name other than the actual server name. Servers should be registered using the actual server name for full functionality with the Replication Mangement component of SCC.



CR:577149
CR Number:   577149
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2010 Fixed
23 Jul 2010 Fixed
Description
Performance has been improved for databases with a low durability level

in cases where many DMLs are simultaneously done on the same page.



CR:577274
CR Number:   577274
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)
09 Jul 2009 Workaround
Description
Under multi engine conditions, ASE Task scheduled JavaVM activities get hanging under

IBM AIX 5.3. This problem comes down to a suspected IBM AIX 5.3 O/S issue that is filed

with IBM under PMR 51261,756,000. A design workaround was applied to ASE for IBM,

avoiding this problem and is default active but will cause performance problems to

those specific ASE Tasks as they all only execute from the ASE engine which is

physically bound to the JavaVM.



To overcome the functional and performance issue with ASE under AIX. the ASE should be

booted with traceflag -T9403 and have prior to the boot AIXTHREAD_SCOPE=S environment

variable setup under the shell responsible in booting the ASE.
Workaround Description
 This problem can be avoided by running the server in virtual mode using

traceflag -T9403 and set AIXTHREAD_SCOPE=S environment before booting the

server.



In essence the problem comes down to PMR 51261,756,000 we filed with IBM.



This problem is still under investigation.



When IBM AIX 6.1 is used default behavior of AIX is to use AIXTHREAD_SCOPE=S



CR:577295
CR Number:   577295
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
New Feature Request for option to set limit on the number of concurrent connections for a single login id.
Workaround Description
 Use login triggers.



CR:577300
CR Number:   577300
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 2238 can misleads you to think this spid are run the quiesce database command

in the error log you only see this.



00:00000:00016:2009/06/17 12:00:25.65 server Error: 2238, Severity: 20, State:9

00:00000:00016:2009/06/17 12:00:25.65 server QUIESCE DATABASE: Could not acquire begin lock due to LOCK INTERRUPTED.



But this spid are run begin tran in master database (this only happens on master database) and a other spid have issued a quiesce database master_tag hold master plus that a spid run the begin tran in master database receive a attention.



CR:577329
CR Number:   577329
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)
Description
When query uses merge_join, ASE sends a cartesian product query to the remote site.



CR:577331
CR Number:   577331
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)
13 Jul 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
ASE sends a cartesian product query to the remote site when merge join is used.



CR:577353
CR Number:   577353
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2009 Fixed
19 Jun 2009 Reservation Made
20 Jun 2009 Fixed
19 Jun 2009 Fixed
26 Jul 2009 Deferred
Description
Duplicate rows could be incorrectly returned when an EXISTS subquery is SELECTing from a

DISTINCT view and not all of the view's SELECT columns are participating in

the subquery's correlated equijoin predicates. Trace commandline flag 15315

can be used to workaround this problem.
Workaround Description
 "set opportunistic_distinct_view off" to turn off opportunistics distinct handling.



CR:577367
CR Number:   577367
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2009 Fixed
Description
Internal only: dbcc table_xact_check() should be runnable by DBO and SA. Instead, it requires sybase_ts_role.



CR:577398
CR Number:   577398
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2009 Fixed
24 Jun 2009 Fixed
29 Jun 2009 Fixed
Description
On Unix platforms, Fix Statistics Wizard's Options page gets a stack trace when you click Browse, enter a name, and click Save.



CR:577488
CR Number:   577488
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2009 Fixed
14 Nov 2011 One-off Provided
02 Oct 2012 One-off Provided
28 Sep 2012 Fixed
Description
Provide traceflag 1144 to avoid 1127 errors reporting insufficient space in

the OAM page when running heavily concurrent multi-user applications

simultaneously inserting into the same table.



CR:577494
CR Number:   577494
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Sub-optimal query plan may be chosen in rare circumstances on non-binary sort order

for query involving distinct operator and exists sub-query



CR:577504
CR Number:   577504
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2009 Fixed
24 Jun 2009 Fixed
Description
On the Windows platform, the Monitor Server does not shut down when the ASE is shut down



CR:577525
CR Number:   577525
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2009 Fixed
08 Jul 2009 Fixed
Description
When ddlgen is used to extract the DDL for an object, that contains a user defined datatype which has a default bound to the type, the DDL generated contains an extra sp_binddefault command that fails because the default already exists.
Workaround Description
 There is not really a simple workaround. However, the problem really only generates errors and does not cause complex problems. The unwanted sp_binddefault command simply fails because a default already exists.



CR:577662
CR Number:   577662
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2010 Fixed
Description
sp_plan_dbccdb needs enhancing to suggest a size for the 8 page pool in a named cache



CR:577668
CR Number:   577668
Product Name:   Adaptive Server Generic Docs
Product Component:   Adaptive Server New Features Guide
Status:   Open
OS:   NA
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
TOP UIV support is limited



CR:577671
CR Number:   577671
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 Jan 2010 Fixed
Description
datachange() function always returns 0 if the table has no indexes and we do update statistics on table only
Workaround Description
 The problem for the client is that they rely on select datachange(t1,null,null) to determine whether or not update statistics has been run. This behaviour does not enable them to identify the difference between the case when update statistics has never been run on the table and when no change occured on the table since the last update statistics.



Suggested workarounds are to use a specific column in the test, but, the client cannot do this since ..ct cannot do it, because he wants to check all tables with datachange in order to see if he will do an update stat. He does not know anything about the tables, this will be an automatic procedure.





Suggested trying this procedure as a quick method to work round the client抯 the lack of knowledge of the client抯 data.



create procedure datachange_col @tablename varchar(255)

as

begin

declare @colname varchar(255)

select @colname = name from syscolumns where id = object_id(@tablename)

and colid = (select min(colid) from syscolumns where id = object_id(@tablename))

select datachange(@tablename,null,@colname)

end

go



Since the client is not available I do not know whether this workaround is acceptable.



CR:577678
CR Number:   577678
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2009 Fixed
Description
Incorrect variable assignment using ISNULL over CIS connections
Workaround Description
 Use traceflag 7703 or use more than one variables @id = isnull(@id2,ID)



CR:577680
CR Number:   577680
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 Aug 2009 Fixed
Description
ins_syn_sql incorrectly calculates free space on the default disk



CR:577686
CR Number:   577686
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2009 Fixed
07 Jul 2009 Fixed
Description
If two indexes on different tables have the same name and if output from DDLGen is generated just for indexes, then an attempt to run this generated output fails if the indexes have been deleted in the server after the DDlGen was first run for the indexes.



CR:577692
CR Number:   577692
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)
21 Jul 2009 Not a Bug
Description
select on Java function performance drop



CR:577711
CR Number:   577711
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 Aug 2009 Fixed
23 Aug 2009 Fixed
Description
Unable to connect to ASE using the reserved administrative connection when network password encryption (-X) is enabled.



CR:577713
CR Number:   577713
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)
23 Jul 2009 Fixed
Description
Sometimes, the message "current process infected with 11" in the module 's_handle' is reported in the errorlog along with errors 2601 and 546, while trying to insert into a table that has foreign key constraints.



CR:577948
CR Number:   577948
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Open
OS:   AIX
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
request to have sybmigrate have the ability to have table sampling ability - only migrate a % of a table.



CR:578146
CR Number:   578146
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
allowing auditing of all database objects for 1 specific database using one sp_audit cmd



CR:578157
CR Number:   578157
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2009 Presently Not Targeted For Any Future Release Of This Product
15 Dec 2009 Fixed
17 Dec 2009 Fixed
13 Sep 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Some stored procedures using temporary tables and trace 299 (forced open by name resolution)

may result in stack trace. This happens if a procedure is frequently renormalized. The stack trace shows the module "lastleft".
Workaround Description
 do not use trace 299 for procedure which result in the stack trace.

If objects were created under 299, re-create them with 299 off (or run dbcc markprocs)



CR:578258
CR Number:   578258
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2009 Fixed
Description
In certain cases, CLM MDA table monCLMObjectActivity may not show updated information for logical locks.



CR:578330
CR Number:   578330
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)
29 Jun 2009 Fixed
30 Jun 2009 Fixed
30 Jun 2009 Fixed
Description
Engines other then Engine 0 may stay around when the ASE is shutdown.



CR:578361
CR Number:   578361
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2009 Fixed
03 Jul 2009 Reservation Made
Description
(Internal Only) A 3475 error: " There is no space available in SYSLOGS to log a record for which space has been reserved in database '<dbname>' (id <dbid>)." may be reported for a database with mixed log and data, even though there may be allocation pages with free extents.



CR:578391
CR Number:   578391
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2010 Fixed
Description
The DBCCLOG command in sybmon is extended to support reading compressed dumps.



CR:578405
CR Number:   578405
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2009 Fixed
29 Jun 2009 Fixed
29 Jun 2009 Fixed
14 Jul 2009 Fixed
Description
Sybmon is unable to parse sqlsrvr data structures on nt386.



CR:578424
CR Number:   578424
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)
14 Aug 2009 Fixed
02 Nov 2009 One-off Provided
29 Apr 2010 One-off Provided
Description
The message "current process infected with 11" may be reported

in the error log together with a stack trace which includes the

modules 'Optimize' and 's_compile' when executing an UPDATE

statement involving a join between two or more tables and the

table being updated has defined a functional index involving

columns which are being updated with values from columns

from the other table(s) participating in the join.



CR:578515
CR Number:   578515
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)
10 Jan 2013 Fixed
10 Jan 2013 Fixed
14 Jan 2013 Fixed
15 Jan 2013 Fixed
15 Jan 2013 One-off Provided
04 Feb 2013 Fixed
05 Feb 2013 Fixed
Description
sp_sysmon appl_and_login does not show the detail of activity by application name and login name.
Workaround Description
 sp_sysmon "00:01:00", appmgmt, @applmon = appl_and_login, @option=clear



CR:578546
CR Number:   578546
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Dataserver fails to boot on machines with glibc version of 2.6 and above



CR:578662
CR Number:   578662
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)
05 Aug 2009 Fixed
Description
If forceplan is used to force the use of a vhash index to scan the table in a join, a SIGSEGV or incorrect result can occur.



CR:578692
CR Number:   578692
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2009 Fixed
Description
when outer joins have inner tables which are derived tables with UNION operators then there is a possibility of a stack trace.
Workaround Description
 Use temp table instead of derived table, query will fine. No signal 11 raised.



Example, we modify repro query sql to this query:-



select c1,c2 into #tmp from t3 where c1 = 0 union select c1,c2 from t3 where c2 is not null

select count(*) from t1

left join t2 on t2.c1=t1.c1

left join #tmp tt

on t1.c2=tt.c2

where tt.c2 is not null



CR:578769
CR Number:   578769
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
update stats blocks drop trigger



CR:578782
CR Number:   578782
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2010 Fixed
17 Dec 2009 Fixed
11 Jan 2010 Reservation Made
Description
ASE Rep Agent support for the database re-synchronization feature from Replication Server 15.5.
Workaround Description
 N/A.



CR:578797
CR Number:   578797
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2009 Fixed
30 Apr 2010 One-off Provided
05 Jan 2010 One-off Provided
13 Nov 2009 Reservation Made
05 Jan 2010 One-off Provided
16 Apr 2010 One-off Provided
30 Apr 2010 One-off Provided
Description
Neither of these traceflags introduced via this CR should be required and should only be

considered if stack traces are seen in 15.0.3 ESD#4 involving des_wkinstall()



For 578797-1, we added some codes under trace flag 7751 to clean up worktables at the end

of execution if worktables are not dropped.

DO NOT run TF 7752



CR:578874
CR Number:   578874
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2009 Fixed
03 Sep 2009 Fixed
Description
Under rare circumstances ASE fails to compile statements in the deferred compilation mode.



CR:578889
CR Number:   578889
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)
20 Aug 2009 Fixed
Description
After ASE detects a 605 error on a DOL index, ASE does not report the 605 error again on the same wrong page until ASE restarts.



CR:578908
CR Number:   578908
Product Name:   Adaptive Server Enterprise
Product Component:   sql
Status:   Closed
OS:   HP-UNIX
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
aries 02 Jul 2009 Fixed
12 Jan 2010 One-off Provided
30 Apr 2010 One-off Provided
Description
In some circumstances, timeslice stack trace might occur while shutting down the cluster.



CR:578913
CR Number:   578913
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UNIX
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After applying ASE 15.0.2 ESD#1 or above, reformatting may not be chosen and performance may slow down if the SELECT statement has 6 or more joined tables in the FROM clause.
Workaround Description
 Use the trace flag 15363.

Better still, from 1503 GA onwards, use criteria "set alternative_greedy_search off | on" either side of the query.



CR:578953
CR Number:   578953
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 Jul 2009 Fixed
Description
In some rare cases, for a dedicated log database, log page chain may get broken.



CR:578991
CR Number:   578991
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2009 Fixed
10 Aug 2009 Fixed
07 Aug 2009 One-off Provided
Description
There is a possibility that during bcp operation, some rows may be received incorrectly and cause an inconsistency in the database. Extra checking on received rows has been added to prevent this.



CR:579008
CR Number:   579008
Product Name:   Adaptive Server Enterprise
Product Component:   coverletter
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2010 Insufficient priority to fix
Description
SPDC download of 1503 GA has been replaced with 1503 ESD#1 binary, but the cover letter still referring to 1503 GA.



CR:579040
CR Number:   579040
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2009 One-off Provided
03 Jul 2009 Fixed
09 Jul 2009 One-off Provided
Description
A SIGSEGV (infected with 11) referencing "lt_notify_flush" can occur under a high stress scenerio in a replication environment.



CR:579044
CR Number:   579044
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2009 Fixed
13 Jul 2009 Fixed
Description
ASE Plug-in and DBISQL's Connect Dialog encounters a syntax error setting a new password when the old password contains special characters.
Workaround Description
 WorkAround:

-----------

You can enter the new password using isql with the sp_password

call. Or have DB admin do this for you.



CR:579209
CR Number:   579209
Product Name:   SySam Docs
Product Component:   SySam User Guide
Status:   Open
OS:   Generic
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
To include cpuinfo,binIPV6,binIPV4 information in sysam user guide.



CR:579240
CR Number:   579240
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)
30 Jul 2009 Fixed
Description
An error 209 with the message "Ambiguous column name" may appear if a stored procedure

which performs the UPDATE or DELETE with the selfjoin is executed by the non owner of a procedure

and the execution is performed using the deferred compilation mechanism.
Workaround Description
 Match owner.table qualification in update and from clause. Or disable deferred compilation via traceflag 7730.



CR:579241
CR Number:   579241
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2009 Fixed
03 Sep 2009 Fixed
Description
Under some rare circumstance related to the runtime recompilation of the parallel

queries using expression involving LIKE and variables or parameters ASE may fail to

generate parallel plan and report stack traces in the errorlog file. A trace will

show modules copy__eval and copy__eoptlike.



CR:579246
CR Number:   579246
Product Name:   SySAM
Product Component:   FLEXlm
Status:   Closed
OS:   all
Original Version:   10.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2010 Duplicate
Description
feat req: add OS vers in sysam status -a output



CR:579273
CR Number:   579273
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 Jul 2009 Fixed
14 Aug 2009 Fixed
Description
Fragmentation handling for in-memory storage cache.



CR:579283
CR Number:   579283
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)
02 Sep 2009 Fixed
24 May 2010 Duplicate
Description
Error 1622 following error 1105 and error 3621 may be reported when bcp in data into

table with text/image columns.



CR:579410
CR Number:   579410
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2009 Not a Bug
02 Sep 2009 Fixed
Description
ASE configuration with very large memory on Linux platform could take long time to initialize the whole shared memory.



CR:579446
CR Number:   579446
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2009 Fixed
Description
In rare circumstances, setuser command fails sometimes producing stack traces in setuser().



CR:579447
CR Number:   579447
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request to associate a severity with the un-numbered messages in the ASE errorlog.



CR:579579
CR Number:   579579
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 Jul 2009 Fixed
Description
In rare circumstances the message "current process infected with 11" in the module 'open_user_table' may be reported in the error log while booting ASE cluster.



CR:579583
CR Number:   579583
Product Name:   SySAM
Product Component:   FLEXlm
Status:   Open
OS:   Solaris
Original Version:   10.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
License server fails to check when file descriptors is set more than 9999
Workaround Description
 Set the file descriptors less than 9999



CR:579586
CR Number:   579586
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2009 Fixed
16 Jul 2009 Fixed
16 Jul 2009 Fixed
Description
A query on the monSysStatement MDA table may cause a timeslice error when there is a large statement pipe.
Workaround Description
 lessen 'statement pipe max messages' to a smaller value(such as 5000).



CR:579688
CR Number:   579688
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for IBM
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2011 Added to user documentation
Description
AIX 5.3 needs to be a 64-bit kernel before upgrading to ASE 15



CR:579776
CR Number:   579776
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 Jul 2009 Fixed
Description
Internal only: attempt to transfer table from a view causes a segmentation fault.



CR:579798
CR Number:   579798
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
aries 08 Jul 2009 Bundled Request
Description
Internal only: attempt to transfer table 'for iq' uses the wrong default column order.



CR:579877
CR Number:   579877
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2010 EOL'd version. Not to be Fixed.
Description
While a DBCC SETTRUNC('ltm','valid') operation is being done on a database,

segmentation violations may occur on tasks doing concurrent updates on the

same database, in ASE procedure lt_notify_flush().



CR:579890
CR Number:   579890
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2009 Fixed
Description
Incremental transfer will not support transferring off-row columns. It should raise an error when the user tries.



CR:579925
CR Number:   579925
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)
21 Jan 2010 Fixed
21 Jan 2010 Reservation Made
28 Jun 2010 Fixed
Description
Error 247 is raised incorrectly in some cases when performing calculations on literal numeric values involving different implicit precision and scale.



CR:579931
CR Number:   579931
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
The error 2546, "Table Corrupt: Extent id %ld on allocation pg# %ld

has objid %ld, indid %ld, and used bit on, but reference bit off.", may

be reported by DBCC CHECKALLOC() after failover recovery in case of a

segregated log and data database.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复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
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

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