远程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:752839
CR Number:   752839
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 27 Dec 2013 Fixed
20 Jan 2014 One-off Provided
21 Dec 2013 One-off Provided
19 Dec 2013 Fixed
16.0 27 Dec 2013 Fixed
13 May 2014 One-off Provided
15.7 SP61 22 Jan 2014 Fixed
05 Feb 2014 One-off Provided
24 Jul 2014 Fixed
Description
The message "current process infected with 11 (SIGSEGV)" in the module 'cpynodes' together with a stack trace which includes the modules 's_copytmps' and 'batch_loopend' may be reported in the SAP ASE errorlog when a BATCH INSERT into a temporary table is executed, followed by 6103 and 703 error while SAP ASE attempts to free procedure cache memory.



CR:752858
CR Number:   752858
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2014 DEFER
20 Oct 2014 Fixed
30 Sep 2014 Reservation Made
03 Nov 2014 Fixed
23 Dec 2014 Fixed
08 Jan 2015 Fixed
Description
Replicating "datetime" data type from primary DB when primary client application apply data having different localization than RepServer, cause DSI to goes down with error #249 when Statement-Replication is activated and threshold is reach:



E. 2013/12/02 08:55:31. ERROR #1028 DSI EXEC(106(1) db_srv2.ads_main) - dsiqmint.c(4358)

Message from server: Message: 249, State 1, Severity 16 -- 'Syntax error during implicit conversion of VARCHAR value 'Dez 1 2013 11:00:23:020PM' to a DATETIME field.'.

(here, 揇ez word (in datetime value 揇ez 1 2013 11:00:23:020PM) is the short name for December month in German)



This may also impact other "date" data type.
Workaround Description
 Change RepServer localization, set it same as primary client application.

or turn off statement replication.



CR:752871
CR Number:   752871
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2013 One-off Provided
16.0 12 Dec 2013 Fixed
15.7 SP60 11 Dec 2013 Fixed
15.7 SP121 12 Dec 2013 Fixed
12 Dec 2013 Fixed
20 Dec 2013 One-off Provided
15.7 SP111 28 Feb 2014 Fixed
Description
A 644 error "Index row entry for data row id (<page#>, <row#>) is missing from index page <page#> of index id <value> of table '<name>' in database 'name'. Xactid is (<page#>,<row#>) ). Drop and re-create the index." may be reported when a clustered index on a Data Locked Only table permits duplicate keys and the index refers to pages with logical page numbers higher than the value of 2147483647.



CR:752892
CR Number:   752892
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 11 Dec 2013 Fixed
16.0 16 Dec 2013 Fixed
Description
DDLGen failed and showed error 'UDM51: java.sql.SQLException' if syslanguages.langid > 99



CR:752984
CR Number:   752984
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a configurable parameter for the limit on the number of or-terms.



CR:752991
CR Number:   752991
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 20 Dec 2013 Fixed
19 Dec 2013 Reservation Made
Description
Trace flag 7796 will prevent the query from being aborted when the recompilation limit has been exceeded. Instead informational messages will be printed when some multiple of the recompilation limit has been reached.



CR:753022
CR Number:   753022
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP61 06 Jan 2014 Fixed
15 Jan 2014 Fixed
15.7 SP121 15 Jan 2014 Fixed
10 Jan 2014 Port Not Needed
Description
SAP ASE running on Windows platforms may report the following message in the SAP ASE errorlog early on during startup: "kernel KERNEL structure not padded correctly - size = 1736". This message may be safely ignored, and this CR prevents it being reported.



CR:753035
CR Number:   753035
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2014 Fixed
27 Feb 2014 Fixed
Description
When merge partitions for table with local indexes, if index rebuild on parallel, error message 14108 will be raised.



CR:753036
CR Number:   753036
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2014 Fixed
16.0 29 Jan 2014 Fixed
Description
There is an incorrect assertion that hits with diagserver during rebooting the server if server crashed during online reorg rebuild.



CR:753037
CR Number:   753037
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   cepheus beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 2013 Fixed
16.0 17 Dec 2013 Fixed
Description
Fail to replicate a new login, or a password change in UTF8 dataserver when 'stream replication' is set to TRUE. A stacktrace is reported in the standby dataserver including the functions lobj_crtlogin()->lobj_crtloginmain()



CR:753079
CR Number:   753079
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 18 Dec 2013 Fixed
16.0 18 Dec 2013 Fixed
19 Dec 2013 Fixed
Description
For internal use.
Workaround Description
 No workaround



CR:753085
CR Number:   753085
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.0 13 Dec 2013 Fixed
15.7 SP121 13 Dec 2013 Fixed
Description
Tracing optimizer behavior may not use the correct indentation when printing plan fragments



CR:753087
CR Number:   753087
Product Name:   Adaptive Server Enterprise
Product Component:   Component Drop
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2013 Added to user documentation
Description
ASE15.7 SP60 PC Client is released with the following updates:



PCC SP60 is released with OCS SDK 15.7 SP122.



PCC SP60 is released with jConn

jConnect (TM) for JDBC(TM)/7.07 SP120 N-OFF (Build 26972)/P/EBF21999/JDK 1.6.0/jdbcmain/OPT/Thu Nov 7 06:04:54 PST 2013



PCC SP60 is released with ODBC

c:\DataAccess\bin>odbcversion -version

15.7.0.401



No Power Designer is shipped with this image, as there are no updates to PD. Please continue to use your existing Power Designer installation.



CR:753098
CR Number:   753098
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP61 15 Dec 2013 Fixed
15.7 SP121 17 Dec 2013 Fixed
16.0 17 Dec 2013 Fixed
18 Dec 2013 Bundled Request
Description
In a long running SAP ASE server configured for SSL, SSL handshake errors due to memory allocation failures appear for new incoming connections.



CR:753140
CR Number:   753140
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2014 Fixed
05 Feb 2014 Fixed
16.0 06 Jan 2014 Fixed
07 Jan 2014 Fixed
Description
The message "current process infected with 11" in the module 'plc__discard' together with a stack trace which includes the modules 'xact_endupdate' and 'reorg_main' may be reported in the error log during 'REORG REBUILD <table> WITH ONLINE' while this command is executed on a system where high concurrent DML activity is happening on the same table. Alternatively this error can occur during a high concurrent DML activity in a low durability database.



CR:753147
CR Number:   753147
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows 2008
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 26 Dec 2013 Fixed
27 Dec 2013 Fixed
16.0 27 Dec 2013 Fixed
Description
In an HA environment, when the same user tries to login on both primary and companion server at the same time then the login process occasionally hangs.



CR:753171
CR Number:   753171
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2014 Fixed
25 Sep 2014 Fixed
29 Sep 2014 Fixed
03 Oct 2014 Fixed
Description
Error 1289 - "Internal Error in lock manager routine: Invalid lock mode ..." may be raised when SAP ASE executes a select-for-update (SFU) query and the following conditions apply:

1. The SFU query contains a TOP clause or a 'set rowcount' command was previously executed to limit the number of rows returned by the SFU query and

2. The number of rows that qualify for the SFU query exceeds the limit imposed by the TOP clause or 'set rowcount' command and

3. The optimizer chooses a parallel query plan to execute the SFU query.



CR:753175
CR Number:   753175
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)
03 Mar 2014 Fixed
03 Mar 2014 Fixed
06 Jun 2014 Fixed
Description
The database level replication status may become inaccurate after changing the replication status of tables or stored procedures while the secondary truncation point is not set.
Workaround Description
 In order to avoid the leftover status bits, all replicated tables and stored procedures that were marked explicitly for replication need to be unmarked before disabling the Secondary Truncation Point (either with dbcc settrunc or with sp_config_rep_agent 慸isable).



To clear the leftover status bits, enable and disable RepAgent:

use db

go

sp_config_rep_agent db, 慹nable, 慠S, 慠Suser, 慠Spwd

go

sp_config_rep_agent db, 慸isable

go



CR:753181
CR Number:   753181
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 19 Jan 2014 Fixed
Description
The monDeviceIO table Reads column value includes the count of APF reads. The description for this column in the monTableColumns table incorrectly stated that it did not. We removed this phrase from the description of this column.



CR:753208
CR Number:   753208
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)
18 Feb 2014 Fixed
Description
Under some circumstances, some SAP ASE diagnostic tools may report logical page numbers higher than 2147483647 as negative numbers.



CR:753302
CR Number:   753302
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2014 Fixed
Description
When we create a table with global variable as a default and then insert a row into this table in the same batch, it will trigger a n infected with 11 (SIGSEGV) stacktrace in the SAP ASE errorolog if the insert is not cached either due to switch off due to the statement cache being disabled or by using special traceflags.



CR:753357
CR Number:   753357
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide SQL interface to retrieve the results of past dump and load operations.



CR:753387
CR Number:   753387
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The progress status messages [example: Processed 50381 allocation unit(s) out of 251904 units (allocation page 12897280). 20% completed. ] for the CREATE DATABASE, ALTER DATABASE, DROP DATABASE, and DBCC GAM commands may stop being output before the command reaches 100%, although the command does complete successfully.



CR:753408
CR Number:   753408
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)
18 Mar 2014 Fixed
08 Dec 2014 Fixed
Description
PagesTouched queried from monCachePool is larger than AllocatedPages under some rare circumstance.



CR:753423
CR Number:   753423
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for user level "password exp warn interval".



CR:753461
CR Number:   753461
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 20 Dec 2013 Fixed
20 Dec 2013 Fixed
16.0 20 Dec 2013 Fixed
20 Dec 2013 Bundled Request
15.7 SP61 24 Dec 2013 Fixed
Description
A segmentation violation occurs when sp_listener starts an SSL listener where no SSL listeners had been started previously.



CR:753525
CR Number:   753525
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP50
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2014 Fixed
15.7 SP121 22 Jan 2014 Fixed
16.0 10 Jan 2014 Fixed
10 Jan 2014 Reservation Made
25 Feb 2014 Fixed
16 Jan 2014 One-off Provided
16.0 20 Jan 2014 Fixed
15.7 SP61 20 Feb 2014 Fixed
20 Jan 2014 Reservation Made
16.0 27 Jan 2014 Fixed
15.7 SP121 11 Feb 2014 Fixed
16.0 05 Feb 2014 Fixed
16.0 14 Feb 2014 Fixed
15.7 SP121 21 Feb 2014 Fixed
Description
SAP ASE running on Unix/Linux platforms only prints the top 25 stack frames in a stack overflow stacktrace report which could mask the root cause and also provide insufficient diagnostics when a stack overflow is caused by a recursive function.



If the stack overflow backout code uses too much stack, the backout process can cause stack guard word corruption resulting in server shutdown.



This CR removes the limitation on number of frames in the stacktrace and if the stack overflow backout code use of the stack reaches within 4K bytes of the stack boundary, it then initiates forcible termination of the task to prevent stack guardword corruption.



The default value of 'stack guard size' is increased by 4K bytes to retain earlier level of stack availability.



Traceflag 3687 provides a stacktrace when a transaction is aborted due to insufficient stack space that can provide additional diagnostics on stack usage by the query. Traceflag 3686 disables this change. This change is not applicable to the Microsoft Windows platform.



CR:753577
CR Number:   753577
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2014 Fixed
Description
ASE with SSL configured and using CIS may hit SEGV in np__validate_servername() which would bring down the server.



CR:753695
CR Number:   753695
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2014 Fixed
27 Feb 2014 Fixed
03 Apr 2014 Port Not Needed
07 Apr 2014 Port Not Needed
24 Jul 2014 Fixed
Description
If a stored procedure is compiled in deferred compilation mode and when a compilation error is raised, it could cause an infected with 11 (SIGSEGV) stacktrace and other unexpected error messages to be reported in the ASE errorlog.
Workaround Description
 Switch off 'procedure deferred compilation' can avoid the problem.



CR:753704
CR Number:   753704
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 21 Jan 2014 Fixed
14 Jan 2014 Consult Complete
23 Jan 2014 Fixed
Description
If quoted_identifier is ON and sp_hadr_admin primary is executed, next time HADR primary server reboots as standby, instead of primary.



CR:753753
CR Number:   753753
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 25 Dec 2013 Fixed
15.7 SP121 07 Jan 2014 Fixed
26 Dec 2013 Fixed
Description
In rare circumstances Online REORG / ONLINE CREATE INDEX may hit SIGSEGV when table contains compressed row but table is marked as not compressed.



CR:753842
CR Number:   753842
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 26 Dec 2013 Fixed
Description
In rare circumstances, 691 error, "Encountered invalid logical page '0' while accessing database 'dbname' (dbid),

object 'object name' (object id), index 'index name' (index id), partition 'partition name' (partition id).

This is an internal system error. Please contact SAP Technical Support." may be reported with stacktrace when

inserting data into TEXT/IMAGE/UNITEXT columns.



CR:753905
CR Number:   753905
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Dec 2013 Fixed
15.7 SP61 26 Dec 2013 Fixed
15.7 SP121 26 Dec 2013 Fixed
16.0 26 Dec 2013 Fixed
Description
When using ALTER DATABASE, an 806 error, "Could not find virtual page for logical page <page#> in database '<dbname>'..." may be reported if ALTER DATABASE removes more than a single fragment from the end of the given database.
Workaround Description
 There are several options:

1) Dump the database before executing the last ALTER DATABASE

or

2) execute DBCC DBREPAIR(dbname, 'remap') immediately after the log off and before extending the database

or

3) create a hole manually in the space that has been incorrectly left without an entry in sysusages. In the example, there is a missing row for the space between lstart 7680 and 10240. So, we would have to insert:



insert sysusages values(5, 0, 7680, 2560, 0, 9, 2550, getdate(), -5 )

go

dbcc dbrepair(dbname, remap)

go



CR:753927
CR Number:   753927
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP70
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2014 Fixed
Description
Performance of queries with decrypt default when run by non-privileged user is very slow.



CR:753942
CR Number:   753942
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2014 Fixed
28 Mar 2014 Fixed
Description
In rare cases, if SAP ASE server crashes during a ALTER TABLE UNPARTITION or MERGE PARTITION transaction, after recovery, DBCC CHECKTABLE of the table may report a 2583 error, "Number of data pages (#) counted by DBCC differs from count in the data OAM (#) for dbid <db_id> object <obj_id>".
Workaround Description
 Workaround-1:

=============

We are getting the page count mismatch for the partitions when running 'dbcc checktable', that can be fixed by running 'dbcc tablealloc' before 'dbcc checktable'. In the testcase we are also doing 'dbcc tablealloc' but after 'dbcc checktable'. By changing the order of these two the issue is getting resolved-



change in the procedure plm3_check_dbcc of calm/svr/qtst/ddl/tables/partition/PLM/tcl/plm_grp3.tcl-



SQL_ok R sqlsa "dbcc tablealloc ('$tblname')"

if [$R fail] {

util_log "dbcc tablealloc command fails for $tblname."

return -1

}

util_log "dbcc tablealloc PASS"



SQL_ok R sqlsa "dbcc checktable ('$tblname')"

if [$R fail] {

util_log "dbcc checktable command fails for $tblname."

return -1

}

util_log "dbcc checktable PASS"







Workaround-2:

=============

As mentioned in the res-2 description, if we have a checkpoint before running the online utility then 'dbcc checktable' and the affected testcases are getting PASSED.



CR:753956
CR Number:   753956
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 23 Jan 2014 Fixed
27 Jan 2014 Fixed
15.7 SP121 27 Jan 2014 Fixed
15.7 SP61 27 Jan 2014 Fixed
27 Jan 2014 Fixed
Description
When an insert trigger exists on the target table of the MERGE statement, the wrong result may happen.



CR:753996
CR Number:   753996
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 05 Jan 2014 Fixed
15.7 SP61 07 Jan 2014 Fixed
27 Feb 2014 Fixed
16.0 09 Jan 2014 Fixed
Description
An SAP ASE shutdown occurs after hitting a SIGSEGV (infected with 11). In the SIGSEGV message in the SAP ASE errorlog the faulting address may reference the function uppushaffinity().
Workaround Description
 sp_configure "allocate max shared memory", 1



CR:754075
CR Number:   754075
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 10 Jan 2014 Fixed
15.7 SP61 13 Jan 2014 Fixed
16.0 17 Jan 2014 Fixed
27 Feb 2014 Fixed
Description
In some rare conditions, error 8201 - "Keep count of descriptor (objid=<objid>, dbid=<dbid>) was expected to be <n>. Instead <m> was found.", error severity 26, state 1 might be raised during high availability failover accompanied by a stack trace in the SAP ASE errorlog with the functions des_do_get()/ha_session_check() in it.



CR:754081
CR Number:   754081
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 07 Jan 2014 Fixed
Description
Signal 11 stacktrace could happen during LePipeRepart::LePipeWriteVtuple() call

when a list partitioned table is the inner table of a parallel outer equi-join and the

join is on the partition column.

The same stacktrace could also happen for a range partitioned (instead of list

partitioned) table when the upper bound of the partition condition is not MAX.



CR:754095
CR Number:   754095
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 08 Jan 2014 Fixed
15.7 SP121 08 Jan 2014 Fixed
08 Jan 2014 Fixed
15.7 SP61 08 Jan 2014 Fixed
Description
On the AIX platform, when SSL is enabled, after a few thousand connections, connection failures occur and error message "ks_falloc: Cannot allocate using ubfalloc" appears in the SAP ASE errorlog.



CR:754142
CR Number:   754142
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
As of 15.7 GA, the empty OAM entries reported in message 15082 can also be removed by running REORG COMPACT or REORG RECLAIM_SPACE.



CR:754150
CR Number:   754150
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
REORG RECLAIM_SPACE fails to clean up empty OAM entries.



CR:754167
CR Number:   754167
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 05 Jan 2014 Fixed
05 Jan 2014 Fixed
Description
When upgrade from 16.0beta1 to 16.0beta2 or later version, If the master database has a secondary

truncation point set, it indicates to turn the secondary truncation point off using older server, and

when rebooting with the older server an error 950(Database 'master' is currently offline. Please wait

and try your command again later) will be raised.



CR:754255
CR Number:   754255
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.7 SP50
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2014 Fixed
13 Feb 2014 Reservation Made
19 Feb 2014 Fixed
25 Feb 2014 Fixed
15.7 SP111 03 Mar 2014 Fixed
15.7 SP121 27 Feb 2014 Fixed
28 Feb 2014 Fixed
16.0 GA PL01 05 Mar 2014 Fixed
Description
A 331 error, "Query is too complex and has exhausted the name space for Ordering IDs, please breakup query into simpler components.", may be reported during a complex query with multi-tables especially using aggregates and allrows_dss optgoal.



CR:754273
CR Number:   754273
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2014 Fixed
15.7 SP61 15 Jan 2014 Fixed
16.0 15 Jan 2014 Fixed
15 Jan 2014 Fixed
15.7 SP121 16 Jan 2014 Fixed
Description
Client connections to SAP ASE may hang when SSL is enabled and the network memory pool is exhausted.



CR:754283
CR Number:   754283
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2014 Fixed
19 Feb 2014 Fixed
04 Feb 2014 Fixed
19 Feb 2014 Not a Bug
19 Feb 2014 Not a Bug
19 Feb 2014 Not a Bug
31 Mar 2014 One-off Provided
09 Jun 2014 One-off Provided
17 Jun 2014 Fixed
29 May 2014 Port Not Needed
Description
Backup Server on HPUX may die with error messages: A00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 1, error code=0, system message=Pipe I/O returned 0 bytes. D00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=0, system message=Pipe I/O returned 0 bytes while trying to print out a legitimate API error.



CR:754371
CR Number:   754371
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 10 Jan 2014 Fixed
03 Feb 2014 Bundled Request
Description
When using compatibility mode with more than 32 columns in an order by expression, the server may stack trace.



CR:754508
CR Number:   754508
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2014 Fixed
30 Apr 2014 Fixed
02 Apr 2014 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the modules def_insert() and xls_sessionid() may be reported in the error log when an INSERT query is run in DEFERRED mode.



CR:754542
CR Number:   754542
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2014 Fixed
20 Feb 2014 Fixed
20 Feb 2014 Fixed
30 Jun 2014 Fixed
Description
Under some rare condition, an infected with 11 (SIGSEGV) error in the function querytuning_ins_sysoptions() may be reported in the SAP ASE errorlog.



CR:754548
CR Number:   754548
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 19 Jan 2014 Fixed
Description
In rare circumstances, a 2583 error, "Number of data pages (<count1>) counted by DBCC differs from count in the data OAM (<count2>) for dbid <dbid> object <objid>", may reported when running dbcc checkdb after rebooting a crashed server or loading a database dump, when a SELECT INTO or ALTER TABLE command was active at the time the server crashed or the dump was taken.
Workaround Description
 N/A



CR:754621
CR Number:   754621
Product Name:   Adaptive Server Enterprise
Product Component:   preupgrade
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2014 Fixed
Description
preupgrade may underestimate the needed space for databases to be upgraded to 15.7 SP100 or later.



CR:754622
CR Number:   754622
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 14 Jan 2014 Fixed
25 Mar 2014 Fixed
03 Apr 2014 Fixed
04 Apr 2014 Fixed
Description
Performance of concurrent insert is slow.



CR:754644
CR Number:   754644
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)
15.7 SP121 14 Jan 2014 Fixed
28 Jan 2014 Port Not Needed
Description
After upgrading from SAP ASE 15.7 SP100 to a higher version and re-running installmaster, configuration parameter 'engine local cache percent' may not be configurable through procedure sp_configure.
Workaround Description
 This can be worked around by adding the missing option by hand. From an account having 'sa_role', do this:



1> sp_configure 'allow update', 1

2> go

1> insert into sysconfigures (config,value,comment,status,name,parent)

2> values (592, 50, 'engine local cache percent', 524293, 'engine local cache percent', 14)

3> go

1> sp_configure 'allow update', 0

2> go



CR:754648
CR Number:   754648
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2014 Fixed
02 Apr 2014 Fixed
17 Apr 2014 Fixed
08 Jul 2014 One-off Provided
16 Sep 2014 Port Not Needed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module mda_fill_and_send_monProcessStatement() may be reported in the error log when running a query of the form SELECT ... INTO temptable.



CR:754653
CR Number:   754653
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   cepheus beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2014 Fixed
26 Sep 2014 Fixed
29 Sep 2014 Fixed
13 Oct 2014 One-off Provided
Description
SAP ASE may fail to boot on an AIX 7.1 machine if the machine has a missing /usr/vacpp/lib/libhC.a library. The AIX error message will report that "Dependent module libhC.a(ansi_64.o) could not be loaded."
Workaround Description
 Install vacpp.memdbg.aix53.rte 11.1.0.0



http://publib.boulder.ibm.com/infocenter/comphelp/v101v121/index.jsp?topic=/com.ibm.xlcpp101.aix.doc/compiler_ref/ruliblnk.html



Redistributable libraries :

If you build your application using XL C/C++, it may use one or more of the following redistributable libraries. If you ship the application, ensure

that the users of the application have the filesets containing the libraries. To make sure the required libraries are available to users, one of the following can be done:

You can ship the filesets that contain the redistributable libraries with the application. The filesets are stored under the runtime/ directory on the installation CD.

The user can download the filesets that contain the redistributable libraries from the XL C/C++ support Web site at:

http://www.ibm.com/software/awdtools/xlcpp/support/



vacpp.memdbg.aix53.rte : User heap/memory debug toolkit for AIX

/usr/vacpp/lib/aix53/libhC.a

/usr/vacpp/lib/aix53/libhC_r.a

/usr/vacpp/lib/profiled/aix53/libhC.a

/usr/vacpp/lib/profiled/aix53/libhC_r.a



CR:754679
CR Number:   754679
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   cepheus beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 09 Jan 2014 Fixed
15.7 SP121 14 Jan 2014 Fixed
14 Jan 2014 Fixed
16 Jan 2014 Fixed
15.7 SP61 17 Jan 2014 Fixed
Description
In some cases, a DML command is not correctly replicated because SAP ASE Replication Agent may mistakenly generate the table schema definition for metadata reduction for a table that is marked for replication. Schema building is needed when the table is created or altered in the same user transaction as the DML which affects the same table.



CR:754736
CR Number:   754736
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)
13 Jan 2014 Fixed
12 Jun 2014 Already Fixed by Another CR
20 Oct 2014 Fixed
24 Nov 2014 Fixed
02 Dec 2014 Fixed
22 Dec 2014 Already Fixed by Another CR
Description
When starting an SAP ASE server up with hundreds of engines, the CPU utilization is high and the server seems to hang.



CR:754753
CR Number:   754753
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2014 Fixed
Description
Alter table move partition can fail with error 326 (ALTER TABLE '<table name>' failed. The table is 0-way partitioned, and a 1-way parallel plan was generated due to lack of parallel resources. Increase the value of 'max parallel degree' and 'number of worker processes' to at least 0, and try again.), when compatibility mode is ON.



CR:754792
CR Number:   754792
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 23 Jan 2014 Fixed
24 Jan 2014 Port Not Needed
27 Jan 2014 Fixed
15.7 SP121 24 Jan 2014 Fixed
24 Jan 2014 Port Not Needed
15.7 SP111 26 Mar 2014 Fixed
Description
SAP ASE may enter a CPU intensive loop after a SIGSEGV (infected with 11) at ktMuxThreadTick+0x24d with the following seen in the errorlog: "Returning from kmultimap_iterator_cleanup with lock held" and "Attempting to return from utpApplyAll while holding a multimap read lock (0x<address>). The lock will be released"



CR:754856
CR Number:   754856
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)
08 Apr 2014 Fixed
24 Feb 2014 Fixed
08 Apr 2014 Fixed
15 Apr 2014 Fixed
03 Jul 2014 Fixed
Description
When we try to alter temporary table for the database which has proxy database mapped on secondary companion, we hit error 177: CREATE PROXY_TABLE cannot create a temporary object (with '#' as the first character name.
Workaround Description
 Customer has been told to use tempdb..tables instead, however per the frequency used they are not able to invest time to modify their application.



Customer has been told to avoid ALTER TABLE on hashed temporary tables, per the same reason above is not feasible.



To ignore the WARNING message on their application, however customer has not evaluated if this disrupt the message handling on their application code.



CR:754928
CR Number:   754928
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2014 Work as design
23 Feb 2014 Reservation Made
10 Apr 2014 Fixed
01 Apr 2014 Reservation Made
19 May 2014 Fixed
29 Apr 2014 Fixed
28 Oct 2014 Reservation Made
01 Jul 2014 Fixed
Description
Add Partial Index support to SAP ASE.



CR:755181
CR Number:   755181
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 16 Jan 2014 Fixed
Description
Updated sp_help_rep_agent 'config' output to include properties related to stream replication.



CR:755225
CR Number:   755225
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
dbcc checktable() may unnecessarily report "Invalid column length 0 found for compressed column ... The last compressed column cannot be a NULL column." if a jConnect BULK_LOAD application inserts NULL values.
Workaround Description
 REORG REBUILD will correct the data.

(Also SELECT INTO).



CR:755230
CR Number:   755230
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 16 Jan 2014 Fixed
26 Jan 2014 Fixed
26 Jan 2014 Fixed
Description
For tables with several indexes and TEXT/IMAGE/UNITEXT columns, a 605 error, "An attempt was made

to fetch logical page <page id> from cache <cache>. Page belongs to database <db>, object <object>,

index <index>, partition <partition> and not to database <db>, object <object>, index <index>,

partition <partition>.", may be reported when running 'SELECT...INTO...FROM ... WHERE condition1

or condition2 or ...' command on it with concurrent DELETE/UPDATE/TRUNCATE TABLE commands.



CR:755287
CR Number:   755287
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2014 Fixed
06 Apr 2014 Fixed
04 Apr 2014 Fixed
Description
An assertion will occur if encrypted columns is enabled and there are external passwords that need to be recreated.



CR:755330
CR Number:   755330
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 05 Feb 2014 Fixed
15.7 SP61 19 Feb 2014 Fixed
15.7 SP121 19 Feb 2014 Fixed
20 Feb 2014 Fixed
20 Feb 2014 Fixed
Description
When using LDAP, an assertion message and a SIGABRT/SIGIOT (infected with 6) stacktrace may be reported in the SAP ASE errorlog. The assertion will say "result == SYBCSI_RESULT_OK, file core/source/csimemory.c". The stacktrace will include the function login__ldapauth().



CR:755333
CR Number:   755333
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2014 Fixed
07 May 2014 Already Fixed by Another CR
07 May 2014 Already Fixed by Another CR
12 May 2014 One-off Provided
29 May 2014 Port Not Needed
Description
The Sybmon 'stack all' command may hit signal 11 because of reference to null pointer.



CR:755424
CR Number:   755424
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 31 Jan 2014 Fixed
03 Feb 2014 Fixed
03 Feb 2014 Fixed
Description
When RepAgent is configured for Multiple Paths Replication and verbose LTL traces are active through Repagent traces 9201, 9227 and 9228, a SIGSEGV may occur together with a stack trace showing the module ra__sender_ltl_cmds.



CR:755454
CR Number:   755454
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2014 Fixed
24 Jun 2014 Fixed
Description
When migrating from SAP ASE 15.5, Sybmigrate fails at report session and shows the error:

There are still external logins for the server 'mtrs$999'.



CR:755465
CR Number:   755465
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2014 Fixed
13 Jun 2014 Port Not Needed
12 Jun 2014 Fixed
Description
Dynamic SQL with LOB parameter which results in a character set conversion for a single, very, very large text field can raise a 712 error (out of heap memory). Avoidance of the 712 error involves using a workaround that avoids the large text field character set conversion altogether. When the error is invoked by a Java program, instead of by batch mode processing there can be a large memory leak of the heap memory for the connection. That memory leak is addressed by this CR.
Workaround Description
 Increase 'heap memory per user' via sp_configure to reduce the chance of 712 error.



Reboot ASE regularly to recycle "Pss Session Heap" mempool if memory fragmenation due to memory leak and no much free memory to increase the memory pool size.



We tried a few tests, Dan found out that we may avoid unitext ->text conversion if change table column colb data type from text to unitext. "unitext" data may be stored as UTF16 (take more disk space)?



We tried connection property LANGUAGE_CURSOR=true&DYNAMIC_PREPARE=false, but still see 712 error having unitext to text conversion routine on the stack.



***update workaround***

Might have found a fix for this. Please give it a try. The basis of the problem I believe is FileReader passed to setClob will automagically use UTF-16. In order to avoid the casting, we need to use something that won抰 use UTF-16.

InputStreamReader functions much like FileReader except you have the ability to force a Charset.

In this case, forcing to iso_1 allows the same data to be inserted as BLOB_VARCHAR via setString.

This inserted into my ASE 16 (entire file) without the 712 error or any modification of 慼eap memory since we aren抰 going through the conversions.





DISCLAIMER I抦 not a java expert and not sure if this is the best approach to getting to InputStreamReader, however this is working.

Additionally, this will have to be sanity tested against very large data as further modifications may be needed. - /DISCLAIMER



PreparedStatement pstmt = conn.prepareStatement("insert into clobTest values (?, ?)");

//Prepare the file for processing

StringBuffer buffer = new StringBuffer();

FileInputStream infile = new FileInputStream("clobber.txt");

InputStreamReader inread = new InputStreamReader(infile, "ISO-8859-1");

Reader in = new BufferedReader(inread);

int ch;

while ((ch=in.read()) > -1) {

buffer.append((char)ch);

}

pstmt.setInt(1, 1);

System.out.println("Reading entire file...");

pstmt.setString(2, buffer.toString());

pstmt.executeUpdate();

pstmt.close();



CR:755473
CR Number:   755473
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 20 Jan 2014 Fixed
20 Jan 2014 Reservation Made
21 Jan 2014 Fixed
15.7 SP121 21 Jan 2014 Fixed
Description
The DUMP DATABASE command may hang when run concurrently with a many other tasks if the option 'optimize dump for faster load' is set to a non zero value.



CR:755508
CR Number:   755508
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Statement contains ORDER BY clause with a select-list number will not be stored in statement cache with literal autoparameterization for parameters.



CR:755520
CR Number:   755520
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)
03 Feb 2014 Fixed
19 Feb 2014 Fixed
23 Jul 2014 Fixed
Description
An "infected with 11 (SIGSEGV) may occur in LeScanOp::LeGetScanInd (called from LeOrScanContext::getNextVtup) when the SAP ASE configuration option 'streamlined dynamic SQL' is turned on and the query contains ORed joins and one of the outer table's join columns contains a NULL value.
Workaround Description
 Turn off 'streamlined dynamic SQL'



CR:755558
CR Number:   755558
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 21 Jan 2014 Fixed
22 Jan 2014 Fixed
15.7 SP121 22 Jan 2014 Fixed
Description
The message "timeslice -501, current process infected" in the module 'ra_ms_get_object_filters_for_path' together with a stack trace which includes the modules 'ra__ms_apply_repfilters' and 'ra_ms_get_object_filters_for_path' may be reported in the error log by the SAP Replication Agent scanner thread for the default path when the filter distribution model is used.



CR:755644
CR Number:   755644
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2014 Fixed
14 Mar 2014 Fixed
27 Jun 2014 Fixed
Description
Ocassionally, a heap memory spinlock violation and followed by various stacktraces may happen for session running multiple XML queries with errors.



CR:755682
CR Number:   755682
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP51
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2014 Fixed
13 Mar 2014 Fixed
17 Mar 2014 Fixed
05 Jul 2014 Fixed
Description
An ALTER TABLE SPLIT PARTITION command may report a SIGSEGV (infected with 11) in the SAP ASE errorlog if the destination partition name is not specified.



CR:755705
CR Number:   755705
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 31 Jan 2014 Fixed
19 Mar 2014 Fixed
Description
SAP ASE Replication Agent under a multiple path replication setup will not replicate the execution of rs_ticket stored procedure to all paths.



CR:755714
CR Number:   755714
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2014 Fixed
11 Feb 2014 Reservation Made
16.0 GA PL01 21 Feb 2014 Fixed
Description
If the DML contains a builtin function with two or more parameters, the audit trail may print the parameters in reverse order.



CR:755734
CR Number:   755734
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)
18 Dec 2014 Fixed
19 Dec 2014 Reservation Made
Description
When using Synchronous Replication, the size of a batch of replicated commands can be configured by using sp_config_rep_agent to set the parameter 'max commands per package'.



CR:755806
CR Number:   755806
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 27 Jan 2014 Fixed
16.0 05 Feb 2014 Fixed
19 Feb 2014 Fixed
19 Feb 2014 Fixed
Description
Under extreme OLTP activity in a mixed-log and data database (like tempdb), a task doing CREATE INDEX may report "Stack overflow detected: limit: 0x0x*, guardpage: 0x0x*, sp: 0x0x*" and "*** Stack guardword corrupted" together with a stack trace that includes the modules 'pg__updateoam', 'pg_oamspace', and 'pg_allocoam'.



CR:755887
CR Number:   755887
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 22 Jan 2014 Fixed
22 Jan 2014 Fixed
22 Jan 2014 Fixed
Description
The error 1120, "Adaptive Server failed to access page <pageno> in database '<database name>' because it is not an allocation page." can be raised if the commands DBCC CHECKALLOC or DBCC TABLEALLOC(syslogs) are executed on an archive database.



CR:755917
CR Number:   755917
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)
09 Jul 2014 Fixed
03 Jun 2014 Fixed
16 Jun 2014 Fixed
27 Jun 2014 Fixed
13 Jun 2014 Reservation Made
08 Jul 2014 Fixed
10 Jul 2014 Fixed
Description
Additional stream replication specific diagnostic information is provided through the sp_help_rep_agent procedure and several MDA tables.



CR:755985
CR Number:   755985
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2014 Fixed
10 Jun 2014 Fixed
17 Jul 2014 Fixed
Description
HADR deactivation operation with 'force' option kills transactions on non-HADR databases.



CR:755990
CR Number:   755990
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2014 Fixed
Description
When using show_sqltext a client state error may occur at the end of a batch.



CR:756069
CR Number:   756069
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 27 Jan 2014 Fixed
28 Jan 2014 Fixed
15.7 SP121 28 Jan 2014 Fixed
16.0 28 Jan 2014 Fixed
Description
When text is bound to a different cache than data for a given table, back-linking text partitions via dbcc shrinkdb_setup() can produce bad links.



CR:756100
CR Number:   756100
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)
19 May 2014 Fixed
Description
When the SAP ASE RepAgent is started and stopped simultaneously by concurrent users, this may cause the SAP Replication Server to shut down itself. The message "Open Server error: Error: 16330, State: 0, Severity 15 -- 'Pass-through is incomplete for spid: <number>'. RSCIOCSDisconnectHandler: consumer not up. Exiting due to a fatal error." will be reported in the Replication Server error log.
Workaround Description
 Restart Replication Server



CR:756143
CR Number:   756143
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 30 Jan 2014 Fixed
03 Feb 2014 Bundled Request
Description
Stack overflow may occur which would terminate the server, instead of the offending session. This may occur if the stack is insufficient and there are a large number of tables in the FROM lists of the query.



CR:756199
CR Number:   756199
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 27 Jan 2014 Fixed
Description
Applying update statistics in parallel mode on a HADR configured standby generates stacktrace and fails.



CR:756274
CR Number:   756274
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 29 Jan 2014 Fixed
29 Jan 2014 Fixed
30 Jan 2014 Fixed
Description
When reporting on the dump header of a dump that was taken with a higher SAP ASE version that has used new metadata in the dump, an error 3264, "The dump header contains device information with invalid token length ...", possibly followed by errors such as 3208 揢nexpected end of file while reading beginning of dump... will be reported. An unknown element warning message will now be reported instead.



CR:756284
CR Number:   756284
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 03 Feb 2014 Fixed
Description
When there are nested subqueries with invariant materialization steps in each respective subquery, it is possible that a signal 11 can occur.
Workaround Description
 Use traceflag 478 can workaround the bug.

The resulting plan under the traceflag could be less performant.



CR:756290
CR Number:   756290
Product Name:   ASE Management
Product Component:   Monitoring Data Collector
Status:   Open
OS:   RH Linux
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Unable to create segment free space alert for newly added segments for databases
Workaround Description
 clear the authentication and Re-authenticate again



CR:756321
CR Number:   756321
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 31 Jan 2014 Fixed
11 Feb 2014 Fixed
11 Feb 2014 Fixed
Description
The message "Invalid column length: <num>. Value must be between 0 and 255 at offset 0 for 'data-only' row with minimum row length of 70." together with a stack trace including the modules 'collocate' and 'ra__new_schema' may be reported if a row for a replicated table with a name of the maximum length (255 char) created by a user with a name of the maximum length (30 char) is encountered by Replication Agent.



CR:756412
CR Number:   756412
Product Name:   Sybase SQL Server
Product Component:   sybinit
Status:   Closed
OS:   Microsoft Windows
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2014 Fixed
Description
internal only: wrong cfg file name was created if make an overlay installation with ASE16.0GA.



CR:756437
CR Number:   756437
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)
12 Feb 2014 Fixed
20 Feb 2014 Consult Complete
12 Feb 2014 Port Not Needed
19 Feb 2014 Fixed
Description
A statement that inserts into a table with an identity column and

references a view or derived table that contains a union-all that terminates

a union statement may generate a 264 error (duplicate column id) if the

identity value is implicitly generated (i.e. - not explicitly provided in the insert's value list).
Workaround Description
 Trace flag 7789 (which disables to fix for CR 723847)



CR:756574
CR Number:   756574
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 05 Feb 2014 Fixed
Description
When dbcc page(dbid,pageno, opt) searches the desired page in deleted cache, causing sig 11.



CR:756600
CR Number:   756600
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2014 Fixed
27 Feb 2014 Fixed
Description
Error 11203 - "The command '<cmd>' is not legal for objects of this type. External definition: <name>" may be incorrectly raised when a proxy table mapped to a file system is part of an

update/delete statement.



CR:756609
CR Number:   756609
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)
24 Jun 2014 Fixed
04 Aug 2014 Fixed
16 Nov 2014 Port Not Needed
Description
The wrong suid may be reported in sysprocesses when executing a stored procedure with execute as owner from another database context.



CR:756618
CR Number:   756618
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2014 Fixed
09 May 2014 Fixed
01 May 2014 Fixed
06 May 2014 Fixed
02 Jul 2014 Fixed
Description
Duplicate identity values may be generated after loading a transaction log dump containing transactions that inserted identity values reserved using multiple calls to RESERVE_IDENTITY().



CR:756619
CR Number:   756619
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2014 Fixed
06 Mar 2014 Fixed
25 Mar 2014 Fixed
Description
Selecting a remote column from DB2 may hit illegal symbol error if the schema name contains special characters.



CR:756631
CR Number:   756631
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 05 Feb 2014 Fixed
10 Mar 2014 Fixed
07 Mar 2014 Fixed
16.0 05 Feb 2014 Fixed
10 Mar 2014 Fixed
10 Mar 2014 Fixed
10 Mar 2014 Fixed
15.7 SP111 07 Mar 2014 Fixed
15.7 SP121 08 Mar 2014 Fixed
Description
A 644 error, "Index row entry for data row id (<pageid>, <rnum>) is missing from index page <index_pagenum> of index id <indid> of table '<tablename>' in database '<dbname>'. Xactid is (<xactid>). Drop and re-create the index." may sometimes be reported in heavily concurrent systems using DATAROWS LOCKED or DATAPAGES LOCKED tables.





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