远程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:762909
CR Number:   762909
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2014 Fixed
09 May 2014 Fixed
09 May 2014 Fixed
Description
sp_showoptstats will have poor performance if a large number of partitions are defined and/or a large number of columns have histograms defined.
Workaround Description
 - use optdiag to gather statistics on the table.

- gather statistics on individual columns with sp_showoptstats rather than the entire table.



CR:762959
CR Number:   762959
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2014 Fixed
07 May 2014 Fixed
08 May 2014 Fixed
Description
DDLGen terminates when the SAP ASE configuration option 'quoted identifier enhancements' is off.



CR:762960
CR Number:   762960
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2014 Fixed
06 May 2014 Fixed
08 May 2014 Fixed
07 May 2014 Fixed
23 May 2014 One-off Provided
Description
When permission on built-in function is granted to a role which is granted to a user, then executing the built-in function may result in permission error.



CR:763023
CR Number:   763023
Product Name:   Adaptive Server Generic Docs
Product Component:   Security Administration Guide
Status:   Closed
OS:   all
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2014 Fixed
Description
The following external authentication methods require SAP ASE security and directory services license, this requirement should documented in Security Administration Guide.

-Kerberos

-LDAP user authentication

-PAM user authentication



CR:763128
CR Number:   763128
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 SP01 PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2014 Fixed
15 May 2014 Fixed
Description
When RepAgent is in skip mode and meta-data reduction is enabled, if the last log record processed by Replication Server before entering skip mode is a ROWIMAGE log record that contains in-row LOB data, RepAgent may generate timeslice errors.



CR:763129
CR Number:   763129
Product Name:   Adaptive Server Enterprise
Product Component:   Component Drop
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2014 Fixed
Description
This PC-Client SP is based on SDK 15.7 SP126. A list of changes in SDK 15.7 SP126 is available at http://download.sybase.com/swr/17983/EBF22690_ README.html



CR:763150
CR Number:   763150
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2014 Fixed
08 May 2014 Fixed
09 Jun 2014 Fixed
30 May 2014 One-off Provided
Description
Create login command does not pass the login name to sp_extrapwdchecks.
Workaround Description
 If the server is configured for monitoring so that

monProcessProcedures is available, this query can be used from within sp_extrapwdchecks

to determine if it was called directly by CREATE LOGIN

or by some stored procedure (returns no rows for CREATE LOGIN):



select * from master..monProcessProcedures

where SPID = @@spid

and ObjectName = "sp_password"



If it was called by CREATE LOGIN, then check for an existing login with the same name and fail if it already exists.



CR:763162
CR Number:   763162
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2014 Fixed
19 Oct 2014 One-off Provided
Description
For tables with LOB columns and attribute "dealloc_first_txtpg" set to 1, error 7133 "NULL textptr passed to %s function." will be reported when WRITETEXT command is running with the new text pointer after the LOB column is updated to NULL.
Workaround Description
 turn off table option "deallocate first text page"



CR:763166
CR Number:   763166
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2014 Fixed
Description
DBISQL16/ASE in scrollable table mode, trimmed leading/trailing white spaces from error/warning/info messages, affecting the stored procedure output formatting such as "sp_showtext", where the output consists only info messages. This behavior is removed.



Also, in scrollable table mode, previously Messages panel limited the number of messages to 1000 items. This limit has been removed.



CR:763213
CR Number:   763213
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2014 Fixed
13 May 2014 Fixed
11 Jun 2014 Fixed
04 Dec 2014 Fixed
Description
Sybmigrate space estimation report fails with error 291 state 1 "Access to sysdams is disallowed".
Workaround Description
 Temporarily drop the sysdams table from the destination database. If the source database is also 15.7 SP100 or higher, temporarily drop sysdams in the source database as well.



To temporarily drop sysdams, use the following script:



set switch on 3604 -- send dbcc output to client

go

set switch on 3717 with override -- required to allow dropping of the sysdams table.

go

dbcc dam(dbid, "drop")

go

set switch off 3717

go

-- Run Sybmigrate. Once finished...

dbcc dam(dbid, "create")

go



CR:763247
CR Number:   763247
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2014 Fixed
30 May 2014 Reservation Made
03 Jun 2014 Fixed
03 Jul 2014 Fixed
Description
Using a NOT LIKE clause to compare with a local variable assigned to a constant string could return different results than comparing to the constant string directly if the column has NULL values in it.
Workaround Description
 add an additional SARG "and <column with nulls> is not null"



Use SQLINITSTRING to set ansinull on (this can cause changes in expected null handling if relying on ansinull=off behavior)

jdbcURL[...]?SQLINITSTRING=set ansinull on



CR:763271
CR Number:   763271
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2014 Fixed
09 May 2014 Fixed
15 May 2014 Fixed
29 May 2014 Fixed
Description
For the diagserver on Solaris platforms, if SAP ASE is running in threaded kernel mode, setting the configuration option "number of disk tasks" to any value greater than 1 will result in an assertion failure being reported in the SAP ASE errorlog.



CR:763285
CR Number:   763285
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2014 Fixed
21 May 2014 Reservation Made
Description
In rare cases when online utility is executing, concurrent updates may hit error 12319 and terminate the session.



/* 12319, EX_CMDFATAL, 1

** Fatal internal error encountered during deferred dml on table '%.*s' in database '%.*s'. All rows that qualified during the first phase were not visited during second phase of dml.

*/



CR:763289
CR Number:   763289
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2014 Fixed
14 May 2014 Fixed
Description
sp_monitor inherits permission of exec to public from lower version server (i.e. 15.5) after upgrade to 16.0.
Workaround Description
 dbo can revoke execute permission on sp_monitor from public



CR:763301
CR Number:   763301
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP63
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2014 Fixed
07 May 2014 Bundled Request
27 May 2014 Fixed
27 May 2014 Fixed
09 Jul 2014 Fixed
10 Jul 2014 Fixed
10 Jul 2014 Fixed
21 Jul 2014 Port Not Needed
Description
The ASE COTS JavaVM version is updated to version JRE 6 update 45 for each supported platform in the sybpcidb database.



CR:763351
CR Number:   763351
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2014 Fixed
05 Jun 2014 Fixed
10 Jun 2014 Fixed
Description
In rare circumstances, error message "WARNING - Fatal Error 614 occurred at ... Adaptive Server accessed a row that has an illegal length ..." may be raised if there is "ORDER BY" clause in a query that uses an in-memory temp database.
Workaround Description
 Avoid SORT on worktable by adding index to base table if possible.



CR:763354
CR Number:   763354
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2014 Fixed
13 May 2014 Fixed
Description
The "Command" column in the query of monThresholdEvent is displayed as "AWAITING COMMAND" when using dynamic SQL.



CR:763376
CR Number:   763376
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.7 SP51
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2014 Fixed
22 May 2014 Fixed
02 Jun 2014 Fixed
Description
A 6908 error, "During redo the page timestamp value is less than old timestamp from log. Page .. object id = 99, page timestamp=0000 00000000. Log old timestamp=0000 00000001." may be reported during load tran in a database that has been altered with the "async_init" option.
Workaround Description
 Use the same async_init option for an alter in the source and the target database.



CR:763415
CR Number:   763415
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2014 Fixed
07 May 2014 Fixed
29 May 2014 Fixed
Description
The message, "The log for database <dbname> includes a CREATE INDEX (with deferred roll-forward) operation that is incompatible with this server version and operating environment", is not reported as expected, if a transaction log dump from an earlier 15.7 release is loaded and the dump contains a CREATE INDEX transaction that was originally done WITH DEFERRED_RECOVERY=MANUAL or DEFERRED_RECOVERY=NONE.



CR:763431
CR Number:   763431
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Open
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Include "parallel scan" option in sp_dumpoptimize topic



CR:763510
CR Number:   763510
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows 2008
Original Version:   16.0 GA PL01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2014 Fixed
03 Jun 2014 Fixed
Description
If many queries that use an "ORDER BY" clause are executed concurrently and the "default data cache" is configured to use a large value for the "local cache partition number" parameter, then SAP ASE may run very slowly or even appear to hang.
Workaround Description
 1. Reduce number of cachelets

2. Increase cache size

3. Reduce number of reserved buffers required by sort. Need to consult concerned team for this workaround.



CR:763514
CR Number:   763514
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2014 Fixed
11 Jun 2014 Fixed
11 Jun 2014 Fixed
19 Jun 2014 One-off Provided
15 Jul 2014 One-off Provided
16.0 GA PL03 11 Aug 2014 Fixed
18 Aug 2014 Fixed
Description
A 2510 error, "Key mismatch between index page <value>, partition ID <value>;... Drop and re-create index ID <value> of table '<value>' in database '<value>'." followed by the message "current process infected with 11" in the module 'byte_eq' together with a stack trace which includes the modules 'compress_page' and 's_xoltp_dml' may be reported in the error log when an INSERT is executed and while the configuration option "streamlined dynamic SQL" is active. Additionally a 631, "The length of <n> passed to delete row routine for the row at offset <n> is incorrect on the following page of database ..." error will be reported while SAP ASE is rolling back the current transaction.
Workaround Description
 A likely workaround for the issue here is to turn the configuration parameter 搒treamlined dynamic SQL OFF.



CR:763609
CR Number:   763609
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2014 Fixed
09 May 2014 Fixed
12 May 2014 Fixed
Description
If an upgrade from a SAP ASE server with a version lower than 15.7 SP100 fails to create the table SYSDAMS because it ran out of space, executing ALTER DATABASE to extend the space will fail with the 12324 error, "In database <dbname>, the server failed to open required table 'SYSDAMS'".



CR:763615
CR Number:   763615
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2014 Fixed
16.0 GA PL02 26 May 2014 Fixed
Description
A 9502 error, "Data exception - string data right truncated", may be reported during ALTER TABLE MODIFY column to NULL with multi-bytes charset and the session property string_rtruncation is set.
Workaround Description
 n/a



CR:763672
CR Number:   763672
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2014 Fixed
21 May 2014 Fixed
Description
Update statistics on proxy table mapped to Oracle using DCO may stacktrace at stat_sargden_accumulate if the proxy table contains NULLs.
Workaround Description
 Traceflag 11209



CR:763738
CR Number:   763738
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2014 Fixed
Description
A 913 error, "Could not find row in sysdatabases with database id #", occurs while selecting from the MDA table monCachedProcedures when procedure cache contains a procedure that references an object in a database which has been dropped.



CR:763772
CR Number:   763772
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2014 Fixed
18 Jun 2014 Fixed
24 Jul 2014 Fixed
Description
Conversion to a TEXT or IMAGE column containing nulls in a stored procedure may cause seemingly random stacktraces (infected with 11 (SIGSEGV)) to be reported in the SAP ASE errorlog.



CR:763794
CR Number:   763794
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2014 Fixed
08 Jul 2014 Fixed
Description
When a RID is used to scan a table and the table has defaults that are not materialized, wrong results may be returned.



CR:763834
CR Number:   763834
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2014 Fixed
18 Jun 2014 Reservation Made
19 Jun 2014 Fixed
19 Dec 2014 Fixed
Description
Some system stored procedures inherited permissions from lower server (i.e. 15.5) after upgrade to 16.0.



CR:763859
CR Number:   763859
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2014 Fixed
15 May 2014 Reservation Made
20 May 2014 Fixed
Description
The EQUALS_SCAN_SUPERSET optcriteria hueristic rule is applied to prefer an index with more limiting equi-sarg keys specified over another index with fewer limiting keys, given that the index limiting equi-sargs keys is a superset of the latter index, and that it is also a superset all the limiting sargs and filtering sargs the latter index. However, if an enforcer such as a SORT or XCHG is applied, the index with fewer limiting equi-sarg keys may still be chosen. Optcriteria cr763859 will use the rule hueristic, but it will only apply if optcriteria EQUALS_SCAN_SUPERSET is also enabled.



CR:763861
CR Number:   763861
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2014 Fixed
Description
In very rare circumstances, when querying the MDA monOpenObjectActivity table, error 14108 "Could not find partition descriptor for objid <objid>, indid <indid>, ptnid <ptnid> in dbid <dbid>." may be reported.



CR:763965
CR Number:   763965
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris 11
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances signal 11 may occur in dodeferred() when executing stored procedure and running

the INSERT into temp table with select distinct UNION statements



CR:764009
CR Number:   764009
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2014 Duplicate
Description
Query hits signal 11 in GtuUnion::_GtcNTopPopsGenerate or GttTable::GttValidateFactTable under 'deferred parallel' execution.
Workaround Description
 set alternative_greedy_search off



CR:764036
CR Number:   764036
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2014 Fixed
Description
An UPDATE with a builtin in the SET clause executes ineffieciently as compared to ASE 12.5.



CR:764060
CR Number:   764060
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2014 Fixed
16 Jul 2014 Fixed
Description
The message "current process infected with 11" in the module 'ubffreef' together with a stack trace which includes the modules 'ra_free_mempool' and 'ra__schema_dealloc_obj' may be reported in the error log preceded by a 9685 error, "Rep Agent on database '<dbname>' switched from mode 'sync' to mode 'async' because timer on commit expired.", when SAP Adaptive Server Rep Agent is configured to use streaming replication in either near-sync or sync mode. This will result in SAP Adaptive Server to shutdown implicitly.
Workaround Description
 sp_config_rep_agent <primdb>, 'max commit wait', 0



By setting this value to zero a task will sleep until such a time things get sorted out and no timer will expire. This hould diminish the likelihood of this problem from happening.



CR:764074
CR Number:   764074
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2014 Insufficient priority to fix
19 May 2014 Fixed
26 Aug 2014 Fixed
02 Jun 2014 Fixed
24 Sep 2014 Fixed
Description
The "Alter thread pool" command may cause an infected with 11 (SIGSEGV) along with a stacktrace that references the function rvm_dispatch() to be reported in the SAP ASE errorlog.



CR:764121
CR Number:   764121
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2014 Fixed
Description
The showplan in xml utility could return the strings

"Sort (Build)" and "Sort (GetSorted)" for the splitSort

operator. These strings generate an XML parser error

when running a query that qualifies XML using xmltest.



CR:764124
CR Number:   764124
Product Name:   Adaptive Server Generic Docs
Product Component:   Security Administration Guide
Status:   Open
OS:   all
Original Version:   16.0 GA PL01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Improve documentation about how the audit processes insert the audit records in to the audit table.



CR:764158
CR Number:   764158
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2014 Fixed
Description
If the secondary truncation point is enabled on the master database on a pre 16.0 server installation, and then 16.0 server is booted against the installation without having followed the required SAP ASE 16.0 upgrade steps (run preupgrade first), then the SAP ASE 16.0 server will fail to boot. The pre SAP ASE 16.0 version will then also fail to boot with the following messages being reported in the ASE 160 errorlog:

"server Opening Master Database ..." and

"kernel The secondary truncation point is turned on in the master database. Please use your older ASE version to turn the secondary truncation point off before using this ASE version".



CR:764186
CR Number:   764186
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2014 Fixed
03 Jun 2014 Reservation Made
04 Jun 2014 Fixed
Description
In rare circumstances, the message "current process infected with 11" (SIGSEGV) in the module 'dpdb__dflpurge' together with a stack trace may be reported in the error log followed by the message "Spinlocks held by kpid ... Resource->rdbt_ext_spin" resulting in SAP ASE shutting down implicitly during the execution of a DUMP DATABASE command and while the configuration option "optimize dump for faster load" is set to 1.
Workaround Description
 sp_configure "optimize dump for faster load", 0



CR:764219
CR Number:   764219
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Identity column not replicated via select into



CR:764274
CR Number:   764274
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2014 Fixed
17 Jul 2014 Presently Not Targeted For Any Future Release Of This Product
Description
In some cases when updates is executed concurrently with DROP PARTITION, MERGE PARTITION or TRUNCATE PARTITION PLM utilities. updates convert to delete + insert.



CR:764288
CR Number:   764288
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2014 Fixed
13 Jun 2014 Fixed
Description
Under a rare condition, if compatibility mode is enabled and when trying to delete a row from a table which has IN ROW LOB, error msg 605 "An attempt was made to fetch logical page '<n>' from cache '<name>'. Page belongs to <ptninfo1> and not to <ptninfo2>." could be reported.
Workaround Description
 To remove in row when you create LOB table and delete will be fine.



CR:764402
CR Number:   764402
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jun 2014 Fixed
24 Jun 2014 One-off Provided
12 Jun 2014 Fixed
02 Oct 2014 Fixed
Description
A 692 error, "Uninitialized logical page '<value>' was read while accessing database 'value', object '' (99), index '<Unknown>' (0), partition '<Unknown>' (99)." may be reported during the execution of either ALTER or CREATE DATABASE command when the "FOR LOAD" option is used and while the database is larger than 63 GB. This may be followed by the message "current process infected with 11" in the module 'buf_cleanup_write_queue' together with a stack trace in the SAP ASE error log which includes the modules 'terminate_process' and 'quitfn'.
Workaround Description
 do not use "for load" option for create/alter database



CR:764429
CR Number:   764429
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2014 One-off Provided
17 Jul 2014 Fixed
23 Jul 2014 Port Not Needed
Description
Enhance text page diagnostics: enable option 8 for DBCC PAGE(); enhance 7105 error message to print page number of first text page; include the port of CR 541218 which may fix the 605 error.



CR:764437
CR Number:   764437
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 SP01 PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2014 Fixed
16.0 GA PL02 23 May 2014 Fixed
10 Jul 2014 Fixed
Description
A 2956 error, "Unable to grab a buffer to encrypt logical page <page_num> in database <db_id>. Increase the size of the buffer pool in the buffer cache <cache_name>", may be raised to report buffer shortage when large transactions are executed on an encrypted database.



CR:764448
CR Number:   764448
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2014 Fixed
09 Jun 2014 Fixed
03 Jul 2014 Fixed
03 Jul 2014 Fixed
10 Jul 2014 Fixed
15 Jun 2014 Fixed
19 Jun 2014 Fixed
03 Jul 2014 Fixed
02 Jul 2014 Fixed
28 Jul 2014 Reservation Made
04 Aug 2014 Fixed
Description
Support the migration of ASE stored procedure to HANA procedure



CR:764509
CR Number:   764509
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP140
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2014 Fixed
05 Jan 2015 Fixed
07 Jan 2015 Fixed
Description
Modularize output from sp_help, sp_helpindex and sp_helpartition to provide terse output which is

useful for tables and indexes with large number of partitions.



CR:764543
CR Number:   764543
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2014 Fixed
30 May 2014 Fixed
Description
Backup Server may log false page verification errors with a message "Incorrect column type in the offset table of row x in page xxx of object ID xxxxxxxx." when executing dump database command with verify = full on a database with 'allow wide dol rows' turned on.
Workaround Description
 There is no workaround.



CR:764623
CR Number:   764623
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2014 Fixed
Description
When performing a dictionary decompress for varchar column with character encoding, SAP ASE may report a 9829 error - " Compressed data row <rowid> in objid <objid>, dbid <dbid> is corrupted."



CR:764630
CR Number:   764630
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   16.0 GA PL01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2014 Fixed
17 Jul 2014 Fixed
12 Aug 2014 Fixed
Description
Checkpoint sleeps on buffer in encrypted db



CR:764801
CR Number:   764801
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2014 Fixed
06 Jul 2014 Fixed
04 Jul 2014 Not a Bug
Description
Under an HADR environment the current task may hang forever in the log drain phase of the deactivation process if the SAP ASE Replication Agent is unable to connect to the SAP Replication Server during the execution of 'sp_hadr_admin deactivate'.
Workaround Description
 dbcc hadr_admin('cancel')



CR:764830
CR Number:   764830
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2014 Presently Not Targeted For Any Future Release Of This Product
12 Jun 2014 Fixed
13 Jun 2014 Fixed
12 Jun 2014 Reservation Made
Description
When the advanced_aggregation optcriteria is used (typically this occurs when the optimization goal is allrows_dss), then there is a possibility of a wrong answer when a SUM, or AVG aggregate is used on an exact numeric datatype column.
Workaround Description
 use trace flag 15341 or

do not use allrows_dss or

set advanced_aggregation off

or use the hint plan '(use advanced_aggregation off)'



CR:764843
CR Number:   764843
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2014 Fixed
16 Jun 2014 Fixed
Description
When 2-phased sort execution plan (i.e. with SORTBUILD and GETSORTED operators) was chosen, Dynamic Thread Assignment (DTA) was causing exceptions in Linux platform due to synchronization issues supposedly due to thread migration. DTA would internally be disabled for such queries with 2-phased sort which might prevent performance gain for the queries that benefit from DTA.



CR:764862
CR Number:   764862
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2014 Fixed
05 Jun 2014 Fixed
04 Jun 2014 Fixed
Description
The message text for error 3543 is enhanced to include the database id value such as "One or more entries in the data segment free space counts in database ID %d was found to be negative and has been set to 0."



CR:764908
CR Number:   764908
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Infected in lock__semawait when cleaning up after an error.
Workaround Description
 Turn off both "object lockwait timing" and "enable stmt cache monitoring". This will

avoid the code path in lock__semawait() that hits the error.



CR:764924
CR Number:   764924
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2014 Fixed
27 Jun 2014 Fixed
18 Aug 2014 Fixed
Description
The errors 'Object id wrong' or 'Page mismatch' can be mistakenly reported by DUMP WITH VERIFY if the system is very busy while the database dump is in progress.
Workaround Description
 If you expect the ASE server will have other active concurrent sessions writing data or log while dumping the database, then please not to use dump database with verify option to avoid these error messages.



CR:764945
CR Number:   764945
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP63
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2014 Fixed
26 Jun 2014 Port Not Needed
26 Jun 2014 Port Not Needed
Description
In rare circumstances, the execution of Java User Defined Functions (UDF) could mistakenly ignore the arguments it expects when these are presented to it through a single argument that holds a white space separated string.



CR:764953
CR Number:   764953
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2014 Fixed
Description
fact table hint may lead to less optimal plan with huge table (>= 1 billion rows).



CR:764985
CR Number:   764985
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   16.0 GA PL01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2014 Fixed
Description
Test of one-off approval/route process.



CR:765005
CR Number:   765005
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A 7222 error (Received bad token 0xff from site 'server name') may be raised if you run a nested RPC and a 2601 error (Attempt to insert duplicate key row) occurs.

A client application may also raise an error message "ct_results(): protocol specific layer: internal Client Library error: There is a tds state machine error. An illegal tds token sequence was received.".



CR:765065
CR Number:   765065
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2014 Fixed
17 Jun 2014 Fixed
Description
The MDA table monRepSyncTaskStatistics is enhanced by adding new monitor columns that provide

information on the time spend in the transaction commit processing when using streaming replication

in (near) sync mode.
Workaround Description
 n/a



CR:765074
CR Number:   765074
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2014 Fixed
05 Aug 2014 Fixed
Description
A 2546 error: "Table Corrupt: Extent id <extid> on allocation pg# <pgnum> has objid <objid>, indid <indid>, and used bit on, but reference bit off." may sometimes be reported by DBCC CHECKALLOC following the rollback of a transaction that contains a CREATE INDEX command as well as DMLs to the table within the same transaction, in a database with DDL_IN_TRAN option turned on.



CR:765101
CR Number:   765101
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2014 Fixed
Description
Sometimes we might hit timeslice error when running dbcc des().



CR:765133
CR Number:   765133
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2014 Fixed
Description
Error message 15746 is modified and made generic as "Unable to run this command on the archive database '%S_DBID' because it is not supported."



CR:765203
CR Number:   765203
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
On AIX in threaded kernel mode, the monEngine connections column is incorrect and dump database may fail with 'soc_nconnect: No free file descriptors available' raised in the errorlog when executed concurrently with sp_listener.
Workaround Description
 Use process based kernel mode. Do not run sp_listener and dump database concurrently.



CR:765216
CR Number:   765216
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2014 Fixed
13 Jun 2014 Reservation Made
23 Jun 2014 Fixed
Description
sp_hadr_admin failover_timeestimate reports high value for estimated failover time.



CR:765240
CR Number:   765240
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2014 Fixed
Description
A query with an AP that forces a distinct_sorted operation fails (because

an m_join property fails). In the case where the feature to eliminate

substitution elements that appear only as simple sargs is enabled, this

results in a SEGV in LeVtuple::LeVtCopy under LeGroupSortedOp::_LeOpNext.

Tcf 16938 can be used to disable the substition scalar elimination.



CR:765261
CR Number:   765261
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
"Waiting for native threads message .. " have an option for sp_ldapadmin 'set_log_interval' to have switch the log internal off (disable).



CR:765267
CR Number:   765267
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP50
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2014 One-off Provided
03 Oct 2014 Port Not Needed
24 Nov 2014 Already Fixed by Another CR
Description
Server to server CIS connections encounter an access violation in function csimtx_lock.



CR:765273
CR Number:   765273
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2014 Already Fixed by Another CR
13 Aug 2014 Fixed
14 Aug 2014 Reservation Made
16 Sep 2014 Fixed
12 Sep 2014 Reservation Made
15 Dec 2014 Fixed
Description
Select-into was not allowed in multi-statement transaction. This is now possible and is enabled by the new configuration option 'enable select into in tran'.



CR:765296
CR Number:   765296
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Fixed
19 Dec 2014 Presently Not Targeted For Any Future Release Of This Product
08 Sep 2014 Fixed
29 Sep 2014 Fixed
Description
Msg 422 - 'Too many nested expressions or logical operators to compile. Try splitting query or limiting ANDs and ORs.' is seen for queries on tables with high number of partitions and local indexes.
Workaround Description
 Reduce the number of local indexes.

Or

force the query to use a table scan. eg: select * from t1 (index 0)



CR:765348
CR Number:   765348
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2014 Fixed
03 Sep 2014 Reservation Made
06 Oct 2014 Presently Not Targeted For Any Future Release Of This Product
24 Sep 2014 Consult Complete
Description
New configuration option 'prevent automatic upgrade' will prevent newer SAP ASE versions from making changes that might prevent booting an older version on this installation. New command line argument --upgrade-ok grants permission for the upgrade.



CR:765381
CR Number:   765381
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2014 Fixed
Description
Select negative number from tinyint column does not return 'Arithmetic overflow" error.
Target Version
 15.7 SP130



CR:765456
CR Number:   765456
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2014 Fixed
19 Aug 2014 Fixed
Description
CRAETE INDEX support on IMRS table.



CR:765517
CR Number:   765517
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2014 Presently Not Targeted For Any Future Release Of This Product
30 Jun 2014 Fixed
01 Jul 2014 Fixed
01 Jul 2014 Fixed
Description
If auditing is enabled and a stack overflow is detected, SAP ASE reports an infected with 11 (SIGSEGV) in chk_usr_role_audit(). As a consequence, normal shutdown hangs, but 'shutdown with nowait' works.
Workaround Description
 disable auditing

shutdown with nowait



CR:765533
CR Number:   765533
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Configuration Guide for Windows
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2014 Added to user documentation
Description
Install sybsyntax script name of the Windows version is not correct.
Workaround Description
 Script name of the Windows version is inssynsq.



CR:765556
CR Number:   765556
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Killing a spid in recursive function mkcollist should better attention checking



CR:765621
CR Number:   765621
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP51
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2014 Fixed
Description
In rare circumstances, when "Update statistics" and BCP running in parallel, update Stats may fail with "Error 605: An attempt was made to fetch logical page %d from cache 'default data cache'. Page belongs to database 'brfdb' (32), object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (-1) and not to database 'brfdb' (32), object %s, index '<Unknown>' (0), partition %s.
Workaround Description
 dbcc tablealloc as manual say.



Msg 7940

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/BABIDEIG.htm?resultof=%22%37%39%34%30%22%20





Msg 7949

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/BABCJAAE.htm?resultof=%22%37%39%34%39%22%20



CR:765677
CR Number:   765677
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2014 Fixed
10 Jul 2014 Fixed
07 Jul 2014 Reservation Made
25 Jul 2014 Fixed
Description
In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #=<pg>, page timestamp=<ts>. Log old timestamp=<ts2>." may be reported during recovery when an ALTER TABLE or REORG REBUILD command was running at the time SAP Adaptive Server was shutdown with nowait or was abnormally stopped.
Workaround Description
 Boot the server, or LOAD DATABASE with the 3412 trace flag turned on.



CR:765720
CR Number:   765720
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2014 Fixed
17 Jun 2014 Fixed
27 Jun 2014 Port Not Needed
Description
Under some circumstances the backup server may report the error 揃ackup Server: 4.189.2.1: Volume validation error: attempt to set directio mode on <devicename> returned -1. while a DUMP DATABASE or DUMP TRANSACTION command is being executed. To avoid this problem from happening execute in the master database the command 搒p_deviceattr 慸evicename,抎irectio,false.
Workaround Description
 use master

go

sp_deviceattr 慸evicename,抎irectio,false

go



CR:765728
CR Number:   765728
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2014 Fixed
25 Jun 2014 Fixed
20 Jun 2014 Fixed
18 Aug 2014 Fixed
16.0 GA PL03 11 Aug 2014 Fixed
Description
When BULK-INSERT optimization is used for an INSERT INTO ... SELECT ... statement, and when an exception occurs during that statement (in this case, a landing partition for a row is not found thus causing an exception), an infected with 11 (SIGSEGV) stacktrace may be reported in the SAP ASE errorlog. This can also be a trigger for the symptoms in CR 763514 (if neither CR 763514 or 765728 is fixed).



CR:765910
CR Number:   765910
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   15.7 SP51
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2014 Fixed
Description
In rare circumstances, UPDATE STATISTICS may lead to error: 806: "Could not find virtual page for logical page <n> in database 'tempdb'."
Workaround Description
 set auto_temptable_stats off



CR:765911
CR Number:   765911
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2014 Fixed
19 Jun 2014 Fixed
19 Jun 2014 Reservation Made
Description
A 3223 error, "Attempt to read a dump trailer failed; returned error code is 2.", will be reported when trying to load a database dump into a pre-15.7 SP121 SAP ASE release, if the dump was taken either with 15.7 SP121 or 15.7 SP122 SAP ASE releases and the option 'optimize dump for faster load' was enabled when the dump was taken.
Workaround Description
 Upgrade the older ASE to 15.7 SP121 or SP122.



CR:765924
CR Number:   765924
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2014 Fixed
Description
In SAP ASE Cluster Edition, duplicate identity values may be generated in column that was created with the IDENTITY() built in function.



CR:765991
CR Number:   765991
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2014 Fixed
18 Aug 2014 Fixed
Description
The message "Current process infected with signal 11 (SIGSEGV)" together with a stack trace containing the module 'ups_stat_memalloc' may be reported in the SAP ASE error log while running UPDATE INDEX STATISTICS with hashing.



CR:766109
CR Number:   766109
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Open
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2014 Fixed
21 Jun 2014 Fixed
24 Jun 2014 One-off Provided
21 Jun 2014 Fixed
16 Jul 2014 One-off Provided
Description
Under a heavily loaded Java application environment, the messages 'PCI(M1): ERROR: JNI_CreateJavaVM; failed attaching to the JVM for AttachCurrentThread() with -1' and 'PCI(M1): ERROR: JNI_CreateJavaVM; PCA/VM FAILED; general failure' may be reported in the SAP Adaptive Server error log. These messages usually indicate that the JavaVM heap space is exhausted. In order to solve this problem the SAP Adaptive Server needs be restarted.



CR:766119
CR Number:   766119
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX 5.1
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In dbcc gettrunc, dbcc settrunc, and sp_help_rep_agent,

pageid values are being represented as signed 32-bit integers even though

large databases may generate pageid values > 2,147,483,647



CR:766247
CR Number:   766247
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2014 Fixed
14 Aug 2014 Fixed
Description
In rare circumstances a DUMP or LOAD command could fail on a Windows platform with the error message in the SAP ASE backup server errorlog 'Error in acknowledging command '152' to the archive emulator'.



CR:766251
CR Number:   766251
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_helpconfig "heap memory per user" with a new value shows the size of memory in kilobytes, but it should be in bytes.



CR:766255
CR Number:   766255
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   MPE/XL
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2014 Bundled Request
04 Jul 2014 Fixed
Description
select bucketpool("bpname/numbuckets") can fail on some platforms
Workaround Description
 use a trailing '/' in the command, eg: select bucketpool("bpname/numbuckets/")



CR:766283
CR Number:   766283
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2014 Fixed
21 Jul 2014 Fixed
Description
The message "current process infected with 11" in the module 憂3__get_sig_size together with a stack trace which includes the modules 憇_normalize and 憂3_udf may be reported in the error log when a query inserts data into an UDF/ADT column by using a wrong datatype conversion.



CR:766324
CR Number:   766324
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2014 Fixed
08 Jul 2014 Fixed
Description
Under an HADR environment on the AIX platform, a user connection (not having 'allow hadr login' privilege) to the ASE in standby mode is not redirected to the primary ASE, and the user login fails.
Workaround Description
 None



CR:766325
CR Number:   766325
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2014 Fixed
12.5 12 Sep 2014 Reservation Made
Description
Under heavy systems with 慹nable functionality group is on, a cursor dynamic prepared statement executed by non DBO users under recompilation path may run into 225 or 208 error.



CR:766379
CR Number:   766379
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jun 2014 Fixed
07 Jul 2014 Fixed
07 Jul 2014 Fixed
10 Jul 2014 Insufficient priority to fix
07 Jul 2014 Fixed
07 Jul 2014 Fixed
07 Jul 2014 Fixed
Description
Table scan running at isolation level 3 may sometimes return wrong result if there are concurrent INSERTs/UPDATEs happening on the table.



CR:766387
CR Number:   766387
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   MPE/XL
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2014 Fixed
02 Sep 2014 Insufficient priority to fix
30 Nov 2014 Port Not Needed
Description
Online parallel create index may fail if the SAP ASE configuration value 'max (utility) parallel degree' is not enough.
Workaround Description
 Don't use online parallel create index or increase the SAP ASE configuration value 'max (utility) parallel degree'



CR:766427
CR Number:   766427
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2014 Fixed
27 Jun 2014 Fixed
27 Jun 2014 Fixed
27 Jun 2014 Fixed
26 Jun 2014 Port Not Needed
11 Dec 2014 Fixed
Description
The indexes created internally for the replication of text/image columns are system objects and they cannot be renamed by executing the system stored procedure sp_rename.



CR:766492
CR Number:   766492
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2014 Fixed
10 Jul 2014 Fixed
27 Nov 2014 Port Not Needed
27 Nov 2014 Port Not Needed
28 Nov 2014 Port Not Needed
Description
An attempt to connect to the Backup Server could fail with the error 'The host '<IP address>' is not authorized to connect to this Backup Server.' reported in the SAP backup server error log if the SAP backup server is booted using a virtual address and the 'hosts.allow' file doesn't contain an entry for the actual real address.
Workaround Description
 Add real address to the hosts.allow file



CR:766498
CR Number:   766498
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2014 Fixed
14 Sep 2014 Fixed
09 Dec 2014 Presently Not Targeted For Any Future Release Of This Product
Description
A non sa_role user cannot generate DDL for a database if that user does not have sa_role.



CR:766499
CR Number:   766499
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2014 Fixed
25 Jul 2014 Fixed
01 Jan 2015 Fixed
Description
When trying to INSERT rows via jdbc using the property DYNAMIC_PREPARE=true, if there is a datatype conversion for columns and overflow/underflow occurs for any column, we may see incorrect Error 515 (Attempt to insert NULL value into column). If there the underlying column allows NULL values, then we may see a data corruption issue where we insert NULL when the above mentioned error conditions occur. The correct expected behaviour is Error 247 (Arithmetic overflow during implicit conversion of datatype).





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