远程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:643188
CR Number:   643188
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2011 Duplicate
Description
Online database failed with 3461, 3451 and 3454 errors during upgrade system tables. There are two workarounds:

1) If 'max parallel degree' > 1, then please disable parallel sort with

sp_configure 'max parallel degree', 1

or

2) For upgrade a database via dump and load, set dboption 'select into/bulkcopy/pllsort' to false for the database on the target server before load an older version of database dump:

sp_dboption db_name,'select',false

go

use db_name

go

checkpoint

go

load database db_name from ......
Workaround Description
 Before online the database, disable parallel sort via

sp_configure 'max parallel degree',1

Or

sp_dboption db_name,'select into/bulkcopy/pllsort', false



CR:643337
CR Number:   643337
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2010 Fixed
Description
Relax restrictions on asterisk (*) in a non-EXISTS subquery SELECT LIST.

Provided the * expands to a single column in a single table/view/derived table:

1. the asterisk can be qualified with a table name (tab.*)

2. the subquery can be a GROUPBY query.

It will function as SELECTing the single column explicitly.



CR:643390
CR Number:   643390
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2010 Fixed
02 Nov 2010 Fixed
19 Oct 2010 Fixed
06 Mar 2012 Fixed
29 Oct 2010 Fixed
05 Nov 2010 Fixed
10 Nov 2010 One-off Provided
Description
Sometimes a task hits error 644 or raises exception from buffree complaining the

buffer is destroyed.



CR:643536
CR Number:   643536
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In an XML Model diagram, when dragging a free-standing element symbol onto a sequence, PowerDesigner moves it correctly. However, the dependent complex and simple types are copied to new entries.



CR:643556
CR Number:   643556
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)
21 Oct 2014 Fixed
27 Oct 2014 Fixed
17 Dec 2014 Fixed
Description
Cross platform transaction load is not supported, but it is allowed and it may result in Msg 695, Level 21 "An attempt was made to read logical page '<pageid>' for database '<db_name>' ... Wrong logical page '2433379939' was broughtinto cache"; Cross platform load in an archive database is also not supported but it is allowed and may result in Msg 15760 - "Invalid dump header when loading the database with ID '<n>'.".



CR:643625
CR Number:   643625
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2011 Fixed
Description
Historical Server may crash with a core file when executing hs_list sessions command if the client's charset is incompatible with the server's charset.
Workaround Description
 Connect with a compatible charset to Historical Server.



CR:643774
CR Number:   643774
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)
24 May 2013 Insufficient info provided
Description
dbcc sqltext can SEGV or timeslice if the spid you want to see the sqltext for are in

the processes of termination.
Workaround Description
 Stop running dbcc sqltext this is only used for monitoring.



CR:643811
CR Number:   643811
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2010 Fixed
19 Oct 2010 Reservation Made
25 Oct 2010 Fixed
20 Oct 2010 One-off Provided
14 Jan 2011 One-off Provided
16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
Description
For queries with large number of joins that time out in the optimizer before a good plan can be found, then the alternative greedy algorithm is useful to find a good starting point for optimization similar what the 12.5 optimizer would choose. The alternative greedy algorithm may not be used for a number of reasons, and this change will allow more cases to use this feature.

This new feature adds support to allow the alternative greedy algorithm to be used when the index row for a 12.5 GROUP BY key is too wide for the query to be executed in 12.5. This new feature can be activated by trace flag 16929 or optcriteria allow_large_index_row.

Also, when partitioned tables are involved in the query the alternative greedy algorithm will now provide an initial starting point using global statistics from the partitioned tables, but otherwise treating the partitioned tables as unpartitioned. This new feature can be activated by trace flag 15366 or optcriteria basic_optimization_partitions.



CR:643859
CR Number:   643859
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2010 Fixed
18 Oct 2010 Fixed
Description
The "hints" option in Abstract Plan syntax is not backward compatible with 12.5 Abstract Plans.
Workaround Description
 remove "hints" clause from AP



CR:643910
CR Number:   643910
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2010 Fixed
Description
The severity for error 13905 is wrongly reported as 16. It should be 10 as in the manual.



CR:643987
CR Number:   643987
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
feature request to speed fast bcp up even faster. Since 15.0.2, we allow fast bcp with non-clustered indexes, but the improvement is a mere 10% over slow bcp. customer would like to have the *risky* option to put off the index and allocation updates to afterwards to get the data in as fast as possible.



CR:644012
CR Number:   644012
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)
15 Oct 2010 One-off Provided
12 Oct 2010 Fixed
14 Oct 2010 Fixed
17 Nov 2010 One-off Provided
11 Jan 2011 One-off Provided
25 Feb 2011 One-off Provided
31 May 2012 Fixed
Description
If the log I/O size used by Adaptive Server when doing I/O for the transaction log

of a given database is changed by sp_logiosize, then Adaptive Server may incorrectly

ignore it during startup.
Workaround Description
 Create a pool with the same I/O size in the default data cache. This can be a small pool.

In this Repro example it would be an 8K pool.



OR



Configure a 16K pool in a named cache and set the log I/O size to 16K in the database (use 16K instead

of 4K or 8K). This is because ASE temporarily creates a 16K pool in the default data cache during recovery.



OR



Run sp_logiosize twice as shown below every time you restart the ASE and the database is online.

sp_logiosize '2K'

go

sp_logiosize 'the value you want' -- 8K in this Repro example

go



CR:644104
CR Number:   644104
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #4 07 Jan 2011 Fixed
08 Feb 2011 Fixed
07 Jan 2011 Reservation Made
07 Jul 2011 One-off Provided
18 Sep 2012 Fixed
Description
Under some rare conditions, stacktrace involving the modules 'LePlanRelease', 'LePlanWriteStats' an d 'LeAlfaStatsCollector' may be reported during query plan generation.



CR:644156
CR Number:   644156
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2010 Fixed
17 Nov 2010 Fixed
15 Nov 2010 One-off Provided
14 Feb 2011 One-off Provided
02 May 2011 One-off Provided
23 Sep 2012 Fixed
Description
Under some circumstances the message "WARNING: memory usage in procedure headers (x) does not match memory usage count in Pss (x) for server process id x" may be reported in the errorlog when a session is holding a high number of user temporary tables without dropping them and, for example, runs some stored procedures via Remote Procedure Call. Eventually, after multiple of those messages, a 701 error "There is not enough procedure cache to run this procedure, trigger, or SQL batch." maybe reported indicating that the free memory available in the Procedure Cache is low.
Workaround Description
 n/a



CR:644280
CR Number:   644280
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)
18 Oct 2010 Fixed
Description
After executing ALTER TABLE MODIFY an identity column and the server crashes, a large identity

gap is observed after reboot.



CR:644357
CR Number:   644357
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2010 Fixed
Description
If a stored procedure is created based on a non-partition table and later on this table is altered to a partition table, it will cause stacktrace and raise 12329 error when we execute this stored procedure when compatibility mode is enabled.
Workaround Description
 Recreate procedure



CR:644380
CR Number:   644380
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2010 Fixed
Description
A new column StmtType has been added to monCachedStatement. The value of StmtType column will be used to tell the type of cached statement, i.e. 1 means batch statement, 2 means cursor statement, and 3 means dynamic statement.



CR:644394
CR Number:   644394
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2010 Fixed
29 Nov 2010 Fixed
30 Nov 2010 Fixed
30 Nov 2010 Fixed
11 Mar 2011 Fixed
Description
In rare circumstances unexpected results may be returned

when executing a query on a view defined on other nested

views which require a Worktable to materialize some

intermediate results and involve a join with mixed

datatypes.
Workaround Description
 - Rewrite the query or view so the same datatypes are

involved in the join predicate (using the explicit

CONVERT() function or changing the datatypes in the

underlying tables)



OR



- Use Abstract Plan to choose a plan where the insertion

into the Worktable (for materializing the results) do

not need a conversion.



CR:644402
CR Number:   644402
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 Oct 2010 Fixed
17 Dec 2010 Fixed
Description
ASE fails to account for the failed sdesmgr request when more auxilairy SDESs than configured are required.



CR:644479
CR Number:   644479
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)
18 Oct 2010 Fixed
Description
If traceFlag 15891 is enabled, the message, "mhdc_get_stat: No persistent reservation holder with res_type:2109524184" will be displayed during shutdown.



CR:644531
CR Number:   644531
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 Jun 2013 DEFER
Description
When statement cache or literal autoparam is on, the query chooses a bad table scan that takes a long time to complete.

With statement cache off, or literal autoparam off, the query chooses the index.
Workaround Description
 set statement_cache off

or

sp_configure "literal autoparam", off





Another workaround is to factor the predicate so that only one instance of the constant exists in the predicate, and only one literal parameter will be substituted.



SELECT cmsfwd_history_exclconv.settle_date, cmsfwd_history_exclconv.currency, cmsfwd_history_exclconv.fwd_years,

cmsfwd_history_exclconv.v1y

FROM fi_hist_cms_curves.dbo.cmsfwd_history_exclconv cmsfwd_history_exclconv

WHERE

( (cmsfwd_history_exclconv.currency='EUR')

OR (cmsfwd_history_exclconv.currency='GBP')

OR (cmsfwd_history_exclconv.currency='USD')

OR (cmsfwd_history_exclconv.currency='JPY')

OR (cmsfwd_history_exclconv.currency='EON')

OR (cmsfwd_history_exclconv.currency='SON') )

AND

cmsfwd_history_exclconv.settle_date> '20091227 12:00:00AM'

go



CR:644607
CR Number:   644607
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2010 Fixed
Description
When using the plancost command from sybmon, ASE will stack trace. This is observed mostly on the Windows platform.



CR:644669
CR Number:   644669
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)
18 Mar 2011 Fixed
25 Mar 2011 Fixed
25 Mar 2011 Fixed
Description
The message "WARNING: The transaction log for database '<dbname>' (dbid <dbid>)

can no longer be dumped due to user '<username>' (suid <suid>) executing <cmdname>"

is now reported in the error log when the transaction dump sequence is

broken.



CR:644677
CR Number:   644677
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2011 Fixed
28 Jan 2011 Reservation Made
07 Feb 2011 Fixed
Description
For table descriptors(DES), Accessing rarely used objects could scavenge Objects that are widely used.



CR:644715
CR Number:   644715
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)
24 May 2013 Insufficient info provided
Description
query fails with 249 error with traceflag 450



CR:644777
CR Number:   644777
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)
08 Nov 2010 Fixed
09 Nov 2010 Reservation Made
10 Nov 2010 Fixed
Description
Multiple IN lists under OR didn't use large IN list transformation even when the total

number of IN values exceeds 128. Consequently, when the number of such IN values exceeds

32K, signal 11 and stacktrace could happen in GaGenericArray::_GaGetPtr() when optimizer is

trying to create more than 32K (int16) internal predicate objects.



CR:644982
CR Number:   644982
Product Name:   Adaptive Server Enterprise
Product Component:   sqlloc
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2010 Fixed
25 Oct 2010 Fixed
15 Nov 2010 Fixed
06 Dec 2010 Fixed
14 Dec 2010 Fixed
16 Dec 2010 Fixed
Description
sqllocres set incorrect default sort order.



CR:644994
CR Number:   644994
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2010 Fixed
18 Nov 2010 Reservation Made
10 Aug 2011 One-off Provided
20 Sep 2012 Fixed
Description
Under some conditions, for example reset or reconfigure 'parallel degree', statement cache clean up issues and memory leaks may occur and it could also make the purge statement cache entry impossible due to ssql_keep > 0.
Workaround Description
 Need to reboot the ASE to clean up the statement cache.



CR:645100
CR Number:   645100
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Statement cache lightweight procedures currently use 'sproc optimize timeout limit' and not

'optimization timeout limit' . This can be misleading. This request as to allow statement

cache lwps to use the 'optimization timeout limit' as per ad-hoc sql.



CR:645146
CR Number:   645146
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2010 Fixed
20 Oct 2010 Fixed
07 Jan 2011 One-off Provided
18 Sep 2012 One-off Provided
11 Sep 2012 Fixed
Description
Under some conditions, creating trigger involving union could lead to SEGV in p__check_lob_insdel() function.
Workaround Description
 dbcc traceon (1716) --to disable changes in CR 590800



CR:645166
CR Number:   645166
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Open
OS:   macosx
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for 15.x Sybase Central plug-ins and Interactive SQL for MAC client



CR:645301
CR Number:   645301
Product Name:   Adaptive Server Enterprise
Product Component:   ssm
Status:   Open
OS:   AIX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2010 Fixed
Description
Change of behaviors in IBM AIX LPAR (logical partition) licensing. This

affects AIX platform only in both ASE SMP and Cluster editions running in

IBM AIX LPAR environment.



The new behavior is that SySAM obtains the CPU core count from the Entitled Capacity

in a Capped LPAR environment, and SySAM obtains the CPU core count from the Maximum

Capacity in an Uncapped LPAR environment.



Prior to ASE 15.5 ESD#3, SySAM obtains the CPU core count from the Maximum Virtual

CPUs and Active Physical CPUs in Capped and Uncapped LPAR environments.



CR:645343
CR Number:   645343
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)
09 Nov 2010 Fixed
22 Nov 2010 One-off Provided
16 Nov 2010 Fixed
19 Sep 2012 Fixed
Description
Stack trace in LeDataRow::readRow when fetching insensitive cursor on a union.
Workaround Description
 Avoid the union operator in the cursor statement



CR:645349
CR Number:   645349
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2012 Insufficient priority to fix
Description
Error 206 when traceflag 450 is enabled
Workaround Description
 Change query to avoid error 206



CR:645445
CR Number:   645445
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2011 Fixed
Description
For APL table with clustered index and the table is page compression, insert

duplicate row into the table does not raise error 2615.



CR:645530
CR Number:   645530
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2011 Fixed
28 Apr 2011 Fixed
28 Apr 2011 EOL'd version. Not to be Fixed.
28 Apr 2011 Fixed
Description
Sometimes the DBCC CACHEDATAREMOVE command may fail when executed on a system table, and the following 1265 error, "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family...", may be reported even when there is no contention.



CR:645594
CR Number:   645594
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)
21 Oct 2010 Duplicate
Description
Signal 11 and stack trace may be seen with functions _memcpy()\ LeDataRow::readRow()

LeScrollCache::LeScrCacheGetRow() when fetching rows from an insensitive cursor of a

select..union statement



CR:645682
CR Number:   645682
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2011 Fixed
Description
If auditing is enabled and the ASE server is started with traceflag 3607 a SEGV will

occur when a client does a query.
Workaround Description
 set 'enable auditing = 0' in the .cfg file and restart the dataserver



CR:645753
CR Number:   645753
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2010 Fixed
01 Dec 2010 Reservation Made
Description
Temporary tables created with the ALLPAGES lock scheme may report error 311 when an attempt is made to read the table using a cursor, despite a unique index having been created. The error only occurs in the case of ALLPAGES lock scheme and if multiple cursors are declared in the same stored procedure.
Workaround Description
 The simplest work around is to change the default lock scheme to either

datapages or datarows. However, if this is unacceptable, it is also a valid

workaround to define the lock scheme in the create table statement.



Another workaround, considering the procedure provided as a repro by the client,

is to take the create table/create index statements from inside the two if blocks

and replace this with one create table/create index statement, since the tables

are the same this can be done with the example provided.



An example of this workaround has been included in the case notes directory:

pserepro_workaround.sql



CR:645810
CR Number:   645810
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2010 Fixed
Description
Linux with multipathing displays "reservation conflict" errors in the machine log when fencing is enabled.
Workaround Description
 Ignore errors or disable multipathing.



CR:645860
CR Number:   645860
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)
12 Mar 2011 Fixed
Description
The message "current process infected with 11" in the module

'lt_sqlrep_comp_policy' together with a stack trace which

includes the modules 's_compile_stmt' and 'GenLava' may be

reported in the error log when a session executes a query that

is being compiled by ASE, while a REORG REBUILD command or

DDL activity takes place concurrently on the same table.



CR:645893
CR Number:   645893
Product Name:   Adaptive Server Generic Docs
Product Component:   Adaptive Server New Features Guide
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Requests to document the behaviour covered under CR 613678 in the New Features Guide.

This CR introduced a new parameter to sp_droplogin (@with_override).

It is required to be set to 1 if wanting to drop a login when one or more databases

are unavailable to check login references.



CR:645898
CR Number:   645898
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2013 Fixed
27 Jan 2014 Fixed
27 Jan 2014 Fixed
Description
In rare circumstances, after configuring a big data cache or a large stack size, SAP ASE might implicitly shut down following a JavaVM crash while executing a Java query. The message EXCEPTION_ACCESS_VIOLATION or 'ExceptionCode: c0000005' will be reported in the SAP ASE error log.



CR:645944
CR Number:   645944
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 Nov 2010 Fixed
Description
Issue a warning if a network listener is using the IP address of a CIPC interconnect



CR:646013
CR Number:   646013
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
01 Nov 2012 Fixed
02 Nov 2012 Fixed
02 Nov 2012 Fixed
14 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
14 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
14 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
Description
When creating local index on semantic partitioning table, mapping between index partitions and

datapartitions is not guaranteed in the same order of semantic partitioning boundary.



CR:646024
CR Number:   646024
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2011 Fixed
19 Nov 2010 Reservation Made
09 Aug 2011 Fixed
Description
Sort operators are undercosted in fastfirstrow scenarios.

Fastfirstrow scenarios include min/max optimizations, exists

scans and the fastfirstrow optgoal. This can lead to

discarding fastfirstrow strategies in preference to other less

efficient strategies incorporating sorts. The fix for this is

enabled by the cr646024 optcriteria.



CR:646101
CR Number:   646101
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 Dec 2010 Fixed
01 Apr 2011 One-off Provided
Description
Under rare circumstances, DISK INIT may hang indefinitely.



CR:646141
CR Number:   646141
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 May 2011 Fixed
Description
Print a warning message if the timestamp of a joining instance is not in sync with that of the existing instances.



CR:646149
CR Number:   646149
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances, the same Abstract Plan works fine on ASE 125x and failed

on ASE 15.5 with the error 1009, Level 16, State 2.



CR:646206
CR Number:   646206
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2010 Fixed
14 Nov 2010 Fixed
Description
ASE does not perform implicit conversion when unitext data is sent from external clients to a text parameter.



CR:646207
CR Number:   646207
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   bharani beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2010 Fixed
08 Nov 2010 Fixed
Description
When executing DBCC TUNE (des_bind) on a table, a 8428 error may be encountered after which the table is no longer usable.



CR:646220
CR Number:   646220
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 Mar 2011 Fixed
18 Mar 2011 Reservation Made
Description
When selecting from a VIEW using an equality predicate over two view columns where the two VIEW columns are the two SELECT DISTINCT columns of the VIEW and one of them is also a non-correlated aggregate subquery result there, it could lead to signal 11 stacktrace in CgpDistinctHashing::_cgpInit() or in CgpPop::_CgpReplaceVars().



CR:646232
CR Number:   646232
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)
Description
Currently ASE is designed to allow an offline database to have it抯 transaction log dumped.

This is a request to change that behaviour and deny that command on an offline database.
Workaround Description
 There is no work around.



CR:646254
CR Number:   646254
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Please document the write up for error message 13968



Error 13968



Severity

16



Message text

"ALTER TABLE '%.*s' failed. You cannot drop all partitions of a table."



Explanation

The alter table command provides a method to remove a partition from table. Any data that is stored on that partition is moved to a suitable remaining partition.



When there is only one partition left on a table, it is no longer possible to store the data in an alternative partition. If an attempt is made to remove the final partition from a table using the ALTER TABLE command then error 13968 will be reported.



Action



This error is reported when an attempt is made to drop the only remaining partition of a table. If the requirement is to drop the table from the database then the correct method is to use a drop table command. If this is not the requirement then no action is required.



Additional Information

Refer to the Reference Manual: Commands for information about the alter table command



CR:646295
CR Number:   646295
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
select fails to convert float to numeric if region setting is german germany and enable pci is set on
Workaround Description
 Disable PCI by sp_configure "enable pci", 0

OR

Don't use German Germany in region setting in the pc

OR

Setup the "Decimal symbol" to '.' as opposed to ',' in the pc

OR

Boot ASE with trace flag 4065



CR:646353
CR Number:   646353
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2010 Fixed
02 Nov 2010 Fixed
06 Jan 2011 One-off Provided
22 Feb 2011 One-off Provided
11 Sep 2012 Fixed
Description
A signal 11 may be raised when upgrade step 245 is involved during upgrade to ASE 15.5 SMP.
Workaround Description
 [ningzhen 2/08/2011]



A more restrictive workaround is just to remove the related rows in sysroles and sysusers which use new 15 system roles uid on source pre-15 ASE before dump the source database:



use testdb

go

sp_configure 'allow updates to system table',1

go



select * from sysusers

go

select * from sysroles

go



begin tran

go

delete from sysroles

where lrid between 16390 and 16398

---[16390, 16398] may be used by new 15 uids for system roles in user databases

go

delete from sysusers

where uid between 16390 and 16398

go

commit tran

go

select * from sysusers

go

select * from sysroles

go

use master

go

dump database testdb to '//remote/cases/11654000s/11654320/pseinfo-11/Repro/ct_data/db_1254.dmp2'

go



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

[szhuang 2010-Nov-9]: Delete all users and roles of the db to be loaded.

load database dbxxx from "dumpXXX"

go

dbcc traceon(990)

go

sp_configure 'allow updates to system table',1

go

use dbxxx

go

delete from sysroles

go

delete from sysusers

go

use master

go

sp_configure 'allow updates to system table',0

go

dbcc traceoff(990)

go

online database dbxxx

go



CR:646388
CR Number:   646388
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2010 Fixed
04 Jan 2011 One-off Provided
18 May 2011 Fixed
22 Jul 2011 Fixed
19 Sep 2012 Fixed
Description
When tables with large number of partitions (typically greater than 32) are used in a query that has a UNION or a UNION ALL query with ASE configured for parallelism, ASE may stack trace.
Workaround Description
 Disable parallel or unpartition the table



CR:646397
CR Number:   646397
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)
07 Dec 2010 Fixed
08 Dec 2010 Reservation Made
11 Dec 2010 Fixed
11 Jan 2011 One-off Provided
25 Sep 2012 Fixed
Description
Executing an insert-select from proxy table into local table when a LOB column is present is much slower than in ASE 12.5.



CR:646467
CR Number:   646467
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2010 Fixed
01 Nov 2010 Fixed
22 Feb 2011 Fixed
Description
ASE Cluster Edition running on SuSE linux may hit SEGV if native CIPC thread is enabled (traceflag 15582 is not used).



CR:646490
CR Number:   646490
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2010 Fixed
01 Nov 2010 Fixed
29 Apr 2011 Duplicate
Description
For a table with auto identity column, REORG REBUILD after any data copy operation (like ALTER TABLE involving data copy or REORG REBUILD) would fail with error 1763. Also, two consecutive ALTER TABLE ADD/MODIFY operations involving data copy may remove the auto-identity column so that any later attempt to see the values under SYB_IDENTITY_COL may fail with error 207.
Workaround Description
 After any alter table/reorg rebuild statement, do a dbcc cacheremove.



CR:646508
CR Number:   646508
Product Name:   System Admin Guide
Product Component:   System Administration Guide
Status:   Open
OS:   NA
Original Version:   6.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer required clarifucation.



CR:646647
CR Number:   646647
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
update all statistics on a table with no index gives Msg 1763.



CR:646693
CR Number:   646693
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2010 Fixed
Description
After migrating from pre-15.0 to ASE 15.5, sybmigrate may report diff failures with 16201 error, "Remote datatype 'usmallint' (65) is unsupported in local server".



CR:646695
CR Number:   646695
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Query involving 6 or more tables and greater than 14 worktables can exhaust procedure cache.
Workaround Description
 set alternative_greedy_search off

and ensure you have sufficient buffers in either the default data cache, or whichever cache you bind your query to



CR:646828
CR Number:   646828
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New set option to ABORT the transaction for all Error messages.



CR:646844
CR Number:   646844
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2010 Fixed
07 Dec 2010 Fixed
Description
On AIX platforms, logical volumes cannot be fenced directly.
Workaround Description
 LUNs can be partitioned into multiple raw partitions or logical volumes using mkvg, mklv, and importvg. However, ASE cannot directly fence these partitions. In order to fence the partition, ASE must directly fence the underlying LUN (/dev/rhdisk). The SA can add database devices using the multiple partitions through 'disk init', In order to properly fence the partitions, the SA must first add a database device using the LUN as well which must not be used for data or data in the partitions will be overwritten. It is just to be used for fencing the partitions.



CR:646877
CR Number:   646877
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2010 Fixed
04 Jan 2011 Reservation Made
06 Jan 2011 Fixed
19 Jan 2011 Fixed
Description
ASE on Windows can occasionally hang on call csimtx_lock()=>WaitForSingleObject(). This can occur at server startup or at user authentication when attempting to obtain the lock which is already held.



CR:646933
CR Number:   646933
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2010 Fixed
Description
In a 4-node cluster, if any node crashes, executing DROP INDEX from active node will result in a 3757 error.



CR:646987
CR Number:   646987
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 Dec 2010 Fixed
Description
When inserting data using PreparedStatement and DynamicPrepare=True, data might be truncated when the column type is UNIVARCHAR and the first value inserted into the column is less than or equal to 128 characters in length. If these two conditions are true, then every subsequent value inserted into the column will be truncated to 128 characters, if greater than 128 in length.



CR:647051
CR Number:   647051
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)
08 Nov 2010 Fixed
04 Nov 2010 Reservation Made
Description
The selectivity estimates for predicates on columns with NULL values may be incorrect for the !=, <, <= operators. There is also a correction for ANSINULL handling of NULL selectivity in which magic numbers were used instead of histogram values. Change is turned on by optcriteria cr647051 in optlevel ase155esd4



CR:647052
CR Number:   647052
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2010 Fixed
09 Nov 2010 Fixed
Description
When deadlock information is required to be printed into error log, corresponding SQL texts are not printed out.



CR:647138
CR Number:   647138
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2010 Fixed
Description
A 11035 error, "Execution of procedure <proc name> failed

because upgrade found no entry in syscomments for this

object. Please drop and recreate dbo." may be reported

when executing a stored procedure which belongs to a

procedure group that was created using deferred name

resolution and at least one of the procedures in

the group has a SELECT * statement.
Workaround Description
 Turn of deferred name resolution. and do old style create procedure with # tables where you create # tables before the create procedure.



CR:647202
CR Number:   647202
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 Mar 2011 Fixed
08 Mar 2011 Fixed
Description
The Opertions column in the MDA table monOpenObjectActivity is not incremented when statement cache is on.



CR:647239
CR Number:   647239
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)
15 Jun 2011 Fixed
Description
DBCC PROC_CACHE("free_unused") doesn't refill other engine's ELC.



CR:647356
CR Number:   647356
Product Name:   ASE Management
Product Component:   Monitoring Agent Plugin
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2010 Fixed
Description
The procedures cache folder at Sybase Control Centel reported the following error "Arithmetic overflow during explicit conversion of NUMERIC value '119185.603515' to a NUMERIC field" and didn't show no data for memory usage. Y



CR:647485
CR Number:   647485
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 Nov 2010 Fixed
07 Jan 2011 One-off Provided
21 Jul 2011 Fixed
18 Sep 2012 One-off Provided
11 Sep 2012 Fixed
Description
Executing a SELECT INTO EXISTING command on a proxy table with identity_insert option

turned on does not insert the data.



CR:647569
CR Number:   647569
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2011 Fixed
18 May 2011 Fixed
Description
Certain parallel query plans available in ASE releases before 15.0 are not supported

in ASE 15.0. Cases include joins between partitioned and unpartitioned tables. This

change adds capabilities and costing support for these queries. Changes are enabled

using trace flags 16970 and 15331. You may also need to sp_chgattribute to set the plldegree on a per table basis.



CR:647589
CR Number:   647589
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2010 Fixed
18 Nov 2010 Fixed
18 Nov 2010 Reservation Made
Description
When a stored procedure or dynamic SQL statement that has at least one LOB parammeter is

recompiled after execution starts, a stack trace containing the functions, copyconst(),

copyres() and s_recompile() could be generated.



CR:647654
CR Number:   647654
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2011 Consult Complete
23 Dec 2010 One-off Provided
24 Feb 2011 One-off Provided
27 Mar 2011 Fixed
30 Mar 2011 Fixed
05 Apr 2011 Fixed
27 Sep 2012 Fixed
Description
In rare circumstances an ASE task that is in the process of creating a temporary table

in a user defined temporary database may sleep for ever while ASE generates the

object ID value for this table. The call stack for the sleeping task will report

the modules 'crt_main' and 'objd_id'.



CR:647670
CR Number:   647670
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
To Be Determined 25 May 2012 Bundled Request
Description
DBISQL 11.0.1 for ASE's 'OUTPUT TO Excel' command does not work.



CR:647726
CR Number:   647726
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)
09 Nov 2010 Fixed
Description
A parallel reformat inside a subquery may be costed incorrectly.



CR:647801
CR Number:   647801
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Apr 2011 Fixed
08 Apr 2011 Fixed
08 Apr 2011 Fixed
Description
A 691 error, "Encountered invalid logical page '0' while accessing

database 'db_name' (id), object 'table_name' (id), index 'index_name'

(255),..." or a 14108 error, "Could not find partition descriptor

for objid <...> ..." together with a stack trace which includes the

modules 'get_txtpage' and 'instext' may be reported in the error log

when running a SELECT INTO UNION which requires to use an internal

worktable (for example, because of an ORDER BY clause) and a NULL

literal value is used in one of the UNION sides for a TEXT, UNITEXT

or IMAGE column.



CR:647823
CR Number:   647823
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Very long boot times when large procedure cache configured.



CR:647831
CR Number:   647831
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)
24 May 2013 Insufficient info provided
Description
Signal 11 in s_result_const_memfree sometimes after error 599



CR:647864
CR Number:   647864
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2010 Fixed
Description
The execution of SP_ADDENGINE and SP_DROPENGINE will raise error 17260 "Can't run <procname> from within a transaction." incorrectly when invoked under chained transaction mode despite that there is

no open transaction.



CR:647973
CR Number:   647973
Product Name:   Adaptive Server Enterprise
Product Component:   ssm
Status:   Closed
OS:   HP-UX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #3 18 Feb 2011 Fixed
Description
When insufficient served licenses are available ASE should report the requested license type and quantity, as is the case for unserved licenses.



CR:648018
CR Number:   648018
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2010 Fixed
Description
A 257 error, "Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed", may be raised when migrating a pre-15.0.2 server to ASE 15.0.2 or later versions.



CR:648097
CR Number:   648097
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After you run 'set lock wait 0' or 'set lock nowait', @@lock_timeout is still -1.
Workaround Description
 Harmless, ignore it.



CR:648131
CR Number:   648131
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Control GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2011 Fixed
Description
It can not find the right partition that is remaining.



CR:648155
CR Number:   648155
Product Name:   Adaptive Server Enterprise
Product Component:   upgrade
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In-place upgrade hang and on recovery get latch deadlock.
Workaround Description
 re-build sybsystemprocs.



CR:648195
CR Number:   648195
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T: Basics
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Apr 2012 Added to user documentation
Description
Doc Request: add known performance issues with MDA parameters



CR:648216
CR Number:   648216
Product Name:   Adaptive Server Generic Docs
Product Component:   To Be Determined
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Doc bug: update XA Interface Requirements per version



CR:648380
CR Number:   648380
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)
25 Feb 2011 Consult Complete
Description
ASE/CIS to oracle ... convert function causes subquery performance prblm



CR:648396
CR Number:   648396
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2010 Fixed
02 Dec 2010 Fixed
Description
Under爏ome燾ircumstances爐he爉essage"WARNING:爉emory爑sage爄n爌rocedure爃eaders(x)燿oes爊ot爉atch爉emory爑sage燾ount爄n燩ss(x)爁or爏erver爌rocess爄d爔"爉ay燽e爎eported爄n爐he爀rrorlog"



CR:648449
CR Number:   648449
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)
13 Dec 2010 Presently Not Targeted For Any Future Release Of This Product
Description
SELECT INTO EXISTING, identity fields can cause 12859 errors and stacktrace



CR:648453
CR Number:   648453
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)
08 Sep 2011 Not a Bug
Description
datachange() returns contradictory results before statistics are created



CR:648511
CR Number:   648511
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 Aug 2011 Fixed
19 Aug 2011 Fixed
Description
If sp_passwordpolicy "expire login passwords" is executed without specifying a login or wildcard string, it expires every login on the server.



CR:648514
CR Number:   648514
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 Jan 2014 Fixed
Description
Error 1105 States 4, 5, and 7 may no longer mean what they are documented to mean in the ASE Troubleshooting Guide due to reuse of the values in new code.



CR:648582
CR Number:   648582
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A feature request to improve index selectivity for constant valued search arguments and encrypted non-character and non-binary columns.
Workaround Description
 Use a local variable which is the same data type as the encrypted column.



declare @val datetime

select @val = '1988/12/31'

select * from tab1 where b = @val

go



CR:648591
CR Number:   648591
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2010 Fixed
22 Nov 2010 Fixed
Description
A 8201 error, "Keep count of descriptor (objid=<id>, dbid=<id>) was expected to be 1.

Instead 0 was found." together with a stack trace which includes the modules 'des_unkeep'

and 'onl__chk_indexes' may be reported in the error log when a database dump is loaded

that has been previously obtained on a different platform.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------