远程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:759637
CR Number:   759637
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)
19 Mar 2014 Fixed
24 Mar 2014 Fixed
26 Mar 2014 Fixed
17 Apr 2014 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module LeScanOp::_LeOpNext() may be reported in the error log when an online utility (e.g. REORG REBUILD) is in progress on a table that contains forwarded rows.
Workaround Description
 Do not use 'with online'



CR:759646
CR Number:   759646
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP61
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2014 Fixed
01 Apr 2014 Fixed
02 Apr 2014 Fixed
16 Apr 2014 Fixed
Description
Arithmetic overflow may occur when executing the stored procedure sp_sysmon_locks.



CR:759660
CR Number:   759660
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)
24 Mar 2014 Duplicate
24 Mar 2014 Duplicate
Description
While upgrading ASE to 15.7 a server configured with multiple engine groups may receive error 644 on sysattributes followed by the message "Logical Process Manager Error: Failed to start a transaction to delete 'PS' type specification." and shutdown before starting the upgrade. To work around this issue, manually remove all engine groups using sp_dropengine and restart the upgrade.
Workaround Description
 Use sp_dropengine to remove all engine group definitions.



CR:759679
CR Number:   759679
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2014 Fixed
Description
When 'net password encryption reqd' set to 1, charset/langinstall will run into 1640 (Adaptive Server requires encryption of the login password on the network) and 4002 (Login failed) errors.



CR:759728
CR Number:   759728
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP111 02 Apr 2014 Fixed
08 May 2014 Fixed
22 May 2014 Fixed
15.7 SP122 16 Apr 2014 Fixed
05 May 2014 Fixed
Description
CREATE TABLE commands may not perform well in situations where a lot of CREATE TABLE commands are run in parallel and the SAP ASE configuration has 'enable inline default sharing' set.



CR:759730
CR Number:   759730
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)
21 Nov 2014 Presently Not Targeted For Any Future Release Of This Product
Description
If there are multiple plans for a cached statement dbcc prsqlcache will only display the first one it locates in cache.
Workaround Description
 Use show_cached_plan_in_xml() which accepts a plan id as the second parameter.



CR:759748
CR Number:   759748
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2014 Fixed
29 May 2014 Fixed
Description
On Microsoft Windows platforms, SAP ASE messages may be incorrectly logged in the Windows Event Log.



CR:759867
CR Number:   759867
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2014 Fixed
29 May 2014 Fixed
Description
When granular permissions is not enabled, users with sa_role not allowed to replace objects owned by other users, getting permission denied error.



CR:759923
CR Number:   759923
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)
16 Jul 2014 Fixed
Description
Traceflag 3605 gets left on after error 707 state 11 is hit, resulting in a wide variety of diagnostic information being written to the errorlog, in turn causing the errorlog to grow rapidly.



CR:759926
CR Number:   759926
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UX
Original Version:   15.7 SP51
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Signal 11 at kbfusage when accessing monMemoryUsage



CR:759937
CR Number:   759937
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)
08 May 2014 Fixed
05 May 2014 Fixed
Description
If a trigger for a DML query has certain commands that execute immediate are not allowed, such as begin tran, rollback trans, etc, error 11736 and 11031 could be raised for the first post-upgrade using execute immediate for the DML query.
Workaround Description
 After upgrading database and bringing it online, manually execute



dbcc upgrade_object(<dbname>, 'trigger')

go



CR:759945
CR Number:   759945
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)
17 Mar 2014 Fixed
29 May 2014 Fixed
Description
When LOAD DATABASE ... WITH LISTONLY = 'CREATE_SQL' is used with the new functionality to create DDL for a differently named target database, the target database name is not reflected in the sp_dboption statements.



CR:759995
CR Number:   759995
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   16.0 GA PL01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2014 Fixed
16 Jun 2014 Fixed
21 Aug 2014 Presently Not Targeted For Any Future Release Of This Product
Description
A 169 error, "Expressions in the ORDER BY list must be unique", may be raised for OUTER JOIN queries involving remote tables even when the queries contain no ORDER BY clause due to incorrect ORDER BY clauses generated by the CIS layer for the queries sent to the remote server.



CR:760002
CR Number:   760002
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 Mar 2014 Fixed
26 Mar 2014 Fixed
21 Mar 2014 Fixed
Description
DBCC CHECKTABLE may encounter a 2511 error, "Keys of index ID <id> for table <tablename> in leaf page are not in the correct order. Drop and re-create the index (index page <pageno>, partition ID <partition_id>)", if 'enable functionality group' is enabled and the base table lockscheme is DOL and changing the table's lockscheme from DOL to APL as part of AMC.



CR:760054
CR Number:   760054
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)
27 Mar 2014 Fixed
Description
On ASE Cluster Edition insert jobs may unexpectedly continue to run with no new rows inserted to the

target table. Dbcc checkalloc or tablealloc may report Msg 2546.



CR:760159
CR Number:   760159
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2014 Fixed
26 Mar 2014 Fixed
01 Apr 2014 Fixed
18 Aug 2014 Fixed
Description
The 6918 error, "The SYSDAMS page that stores the state of page # in database '<dbname>' could not be found. The option 'allow incremental dumps' will be disabled because SAP ASE cannot continue recording page modifications", can be raised if the table SYSDAMS gets the very first extent of an allocation unit allocated.
Workaround Description
 See workaround from CR 742139



CR:760176
CR Number:   760176
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2014 Fixed
16 Apr 2014 Already Fixed by Another CR
Description
Optcriteria equals_scan_superset and avoid_zero_weight_histograms are associated with the ase157sp130 optimization level.



Previously, a user defined optgoal needed to be defined to enable these optcriteria (or trace flags 16989 and 16991 respectively).



CR:760187
CR Number:   760187
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP111
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP111 18 Mar 2014 Fixed
15.7 SP130 02 Apr 2014 Fixed
16.0 GA PL02 02 Apr 2014 Fixed
16.0 sp01 02 Apr 2014 Fixed
15.7 SP63 03 Apr 2014 Fixed
15.7 SP122 15 Apr 2014 Fixed
Description
The index ID is incorrectly reported as 0 in the SAP ASE error message number 12301, "Internal error: the index (id = <ID>) and the data for row (<page>, <row>) in table '<table>', database <db> are inconsistent; data is marked deleted but index is not. Aborting the transaction".



CR:760226
CR Number:   760226
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The out of range statistics option may get reset to the default by update statistics when used against partitioned tables.
Workaround Description
 Explicitly add the USING OUT_OF_RANGE to all update statistics commands.



CR:760241
CR Number:   760241
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)
27 Mar 2014 Fixed
27 Mar 2014 Fixed
16 May 2014 Fixed
Description
The error message, "Length of plain text is less than one cipher block", may be reported in the error log during encryption of a database.



CR:760248
CR Number:   760248
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)
21 Mar 2014 Fixed
15.7 SP111 24 Mar 2014 Fixed
25 Mar 2014 Fixed
15.7 SP122 16 Apr 2014 Fixed
07 May 2014 Fixed
Description
Under some circumstances, a worker thread may hang due to incorrect error handling during parallel CREATE INDEX with "utility statistics hashing" turned on.



CR:760269
CR Number:   760269
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.5 ESD #5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2014 Fixed
06 Aug 2014 Fixed
08 Aug 2014 One-off Provided
09 Sep 2014 Fixed
27 Aug 2014 One-off Provided
08 Sep 2014 Fixed
09 Sep 2014 Fixed
Description
A 9254 error 'RepAgent(<dbid>): Could not locate schema version for object id '<value>' in the transaction log." followed by a 9204 error 'RepAgent(<dbid>): Could not locate schema for object with id = (<value>), current marker (<page#>, <row#>).' may be reported in the SAP ASE error log when SQL Statement Replication is active and a transaction involving SQL statement Replication is rolled back. This will result in the Rep Agent Thread terminating abnormally.
Workaround Description
 Disable SQL Statement Replication feature.



CR:760274
CR Number:   760274
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)
15.7 SP111 02 Apr 2014 Fixed
02 Apr 2014 Fixed
15.7 SP130 10 Apr 2014 Fixed
15.7 SP122 17 Apr 2014 Fixed
29 Apr 2014 Fixed
Description
In rare circumstances, a time slice error followed by a stack trace that includes the modules ups_end_statglobalnosort() and close_table() may be reported in the error log when running UPDATE INDEX STATISTICS.



CR:760365
CR Number:   760365
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)
26 Mar 2014 Fixed
14 Apr 2014 Fixed
Description
Isolation level 0 queries fail with errors when CREATE CLUSTERED INDEX WITH ONLINE is in progress concurrently on the same table.



CR:760373
CR Number:   760373
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2014 Fixed
16 Apr 2014 Fixed
Description
Resource limit violation message 11001 (severity level 17:EX_RESOURCE) is reported when action 5(record action) is configured.



CR:760390
CR Number:   760390
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2014 Fixed
25 Mar 2014 Fixed
25 Mar 2014 Fixed
27 Mar 2014 Fixed
31 Mar 2014 One-off Provided
Description
A DUMP WITH COMPRESSION could fail with the message "SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=0, system message=Pipe I/O returned 0 bytes". If a core file is produced the stack will show the module sm__do_allocations().



CR:760437
CR Number:   760437
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)
23 Mar 2014 Fixed
08 May 2014 Fixed
Description
Under certain circumstances, the preupgrade utility from SAP ASE 16.0 can encounter data conversion errors and overflow errors when checking for free space in a database's system segment.



CR:760453
CR Number:   760453
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)
31 Mar 2014 Fixed
02 Apr 2014 Fixed
02 Apr 2014 Port Not Needed
01 Apr 2014 Fixed
Description
Wrong result could happen when an EQUIJOIN on a single INT4 column is placing a bloom filter probe into the scan and the scan is at the inner side of another NESTED LOOP JOIN with a pushdown EQUIJOIN sarg on the same column.
Workaround Description
 cmdline traceflag 16963.



CR:760539
CR Number:   760539
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2014 Presently Not Targeted For Any Future Release Of This Product
14 Apr 2014 Fixed
14 Apr 2014 Fixed
08 Apr 2014 Fixed
16.0 GA PL01 04 Apr 2014 Fixed
02 Apr 2014 Fixed
Description
SAP ASE fails to boot on Windows with the message "FATAL: shared memory region is being held at xxx bytes but yyy bytes are required" being reported in the SAP ASE errorlog.



CR:760621
CR Number:   760621
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)
14 Apr 2014 Fixed
15 Apr 2014 Fixed
14 Apr 2014 Fixed
20 May 2014 Fixed
Description
On a server that has a large number of objects, the sp_sysmon report may take a long time to complete and error message 1508, "Create index aborted on duplicate rows. Primary key is <keyname>", may be reported in the error log.



CR:760635
CR Number:   760635
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Query Processing to default to a more rule based optimization when we have unknown, out of date or data skew statistics.



CR:760654
CR Number:   760654
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2014 Fixed
Description
DBISQL 16 stopped reading interfaces entries when the file contains a large number of entries.



CR:760661
CR Number:   760661
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)
16.0 sp01 02 Apr 2014 Fixed
15.7 SP110 02 Apr 2014 Fixed
22 Apr 2014 Fixed
15.7 SP122 16 Apr 2014 Fixed
09 May 2014 Fixed
Description
The procedure cache allocation is optimised. This vastly speeds up the start-up of SAP ASE configured with a very large procedure cache.



CR:760672
CR Number:   760672
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP62
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2014 Fixed
01 Apr 2014 Fixed
05 May 2014 Fixed
28 Mar 2014 Fixed
08 Apr 2014 Fixed
05 May 2014 Fixed
Description
A 3478 error, "During undo the page timestamp value is less than new timestamp from log." or other fatal errors may be reported in the error log when SAP ASE is rolling back a transaction following an 863 error, "Buffer resources in cache <cache_name> are unavailable. Please re-run this query or ask the system administrator to re-configure buffer cache memory." that is accompanied with messages "Named cache <cache_name, cache_id> is configured too small for current demands".



CR:760673
CR Number:   760673
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)
28 Mar 2014 Fixed
03 Apr 2014 Fixed
10 Apr 2014 Fixed
14 Apr 2014 Fixed
15.7 SP122 16 Apr 2014 Fixed
Description
If the data cache is configured small, SAP ASE may report a 'cache too small' error when the new sort buffer algorithm is used.



CR:760684
CR Number:   760684
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP111 02 Apr 2014 Fixed
22 May 2014 Fixed
08 May 2014 Fixed
22 Apr 2014 Fixed
15.7 SP122 16 Apr 2014 Fixed
Description
A 707 error, "System error detected during attempt to free memory at address <addr>. Please consult the ASE error log for more details", may be raised by SAP ASE when multiple SAP ASE connections are executing parallel CREATE INDEX commands.



CR:760711
CR Number:   760711
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)
01 Apr 2014 Fixed
Description
In rare circumstances, after using the configuration option 'global cache partition number', the dataserver may hang. If the diagserver was being used then an Assertion (! "locks not cleaned") will be reported in the SAP ASE errorlog.



CR:760751
CR Number:   760751
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2014 Fixed
21 Apr 2014 Fixed
Description
A parallel query may be rejected during execution because the worker thread pool has fewer threads available than the minimum number of threads required to execute the plan. In this case, the query should be sent back to be recompiled in serial mode. However, the query will be recompiled in parallel mode and then fails during execution again if it contains a plan-clause with the following directive "(use optgoal allrows_dss)". At this point a 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization", is raised because the procedure buffer object is missing.
Workaround Description
 1) Increase the "number of worker threads" configured to accomodate the plan's

minimum number of required threads during peak parallel load times.

2) Set the optgoal at the session level rather than at the query level. That is bracket

the query with "set plan optgoal <desired_optgoal>" commands or reconfigure the

desired optgoal in the system as a whole.



CR:760781
CR Number:   760781
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 Apr 2014 Fixed
08 Apr 2014 Fixed
18 Sep 2014 Port Not Needed
Description
When there is no active transaction in a database, running select loginfo('dbname','stp_pages') will give the result of 0 even if the secondary truncation page is not the same as the last log page.
Workaround Description
 Use other options of the loginfo built-in to see whether the secondary truncation page is preventing the log from being truncated.



select loginfo(慸bname,慽s_stp_blocking_dump) : if it returns 1, it means that the secondary truncation page is the same as the first log page, and it is blocking the log from being truncated.



select loginfo(慸bname,抍an_free_using_dump_tran) : prints the percent of log that can be truncated within the total log size.



select loginfo(慸bname,憇tp_page) : gives the page number of the secondary truncation page.



select loginfo(慸bname, oldest_active_transaction_page) : prints the page that contains the oldest active transaction marker.



So these built-in options can be used to detect whether secondary truncation page is lagging behind and preventing log from being truncated.



CR:760836
CR Number:   760836
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)
11 Apr 2014 Fixed
23 Apr 2014 Fixed
Description
In some rare cases, some of the pdes spinlocks show contention with objects that have a large number of partitions.



CR:760875
CR Number:   760875
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)
18 Apr 2014 Fixed
23 Apr 2014 Fixed
23 Apr 2014 Fixed
01 Jul 2014 Fixed
Description
sp_sysmon and monEngine do not report DiskIOChecks in process mode.



CR:760876
CR Number:   760876
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)
19 May 2014 Fixed
08 May 2014 Fixed
17 Jun 2014 Fixed
13 May 2014 Fixed
25 Jun 2014 Fixed
25 Jun 2014 Fixed
Description
Deprecate the plan sharing feature (used to be enabled via the SAP ASE configuration option called "enable plan sharing").



CR:760897
CR Number:   760897
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)
16.0 GA PL02 11 Apr 2014 Fixed
25 Apr 2014 Fixed
24 Apr 2014 Fixed
09 Apr 2014 Reservation Made
Description
A 6908 error, "During redo the page timestamp value is less than old timestamp from log. etc." followed by a stack trace that includes the module 'recovery' could be raised when loading a database dump if the configuration parameter 'optimize dump for faster load' is enabled and there is very high update activity in SAP ASE while the dump database command is running. To workaround the problem the end-user can set the trace flag 3022 (either via the command line or by using dbcc traceon or by using SET SWITCH ON ignore_trailer_ckpt) before loading the database.
Workaround Description
 The problem will happen only if there is a lot of concurrent activity while dump database

is running and the configuration option 'optimize dump for faster load' is enabled.

So, before you get the problem, it will be avoided if the option is set to '0'.

If a dump has been taken with this option enabled, to load the database without

errors you can do:



dbcc traceon(3022)

go



and now load the database....



CR:760910
CR Number:   760910
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2014 Fixed
21 May 2014 Fixed
11 May 2014 Reservation Made
Description
In rare circumstances, when a partitioned table has a local index and partition lock is enabled, SAP Adaptive Server may hit error 12212 during an index scan, if a committed transaction deletes few rows from a partition that cause deallocation of extent (say X) and a uncommitted transaction inserts rows in another partition, cause allocation of same extent(X).

After hitting 12212 error SAP ASE terminates the connection and logs a stacktrace in the SAP error log.



Error 12212

" Internal Error: The partition ID (<ID>) of the lock does not match the partition ID (<ID>) of the new request on this lock. dbid=<DB_ID>, objid=<OBJ_ID>, pageno=<Page number>, rowno=<Row Number> locktype=<lock type>".



CR:760917
CR Number:   760917
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 Apr 2014 Fixed
16 Apr 2014 Fixed
Description
Upgrade to SAP ASE 16.0 may fail with the error message "Kernel resource memory pool has been exhausted. Try increasing the value of 'kernel resource memory'".



CR:761036
CR Number:   761036
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP111
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP111 31 Mar 2014 Fixed
15.7 SP130 01 Apr 2014 Fixed
16.0 GA PL02 31 Mar 2014 Fixed
16.0 sp01 19 Apr 2014 Fixed
15.7 SP122 15 Apr 2014 Fixed
Description
Under rare conditions, a 12301 error, "Internal error: the index (id = <num>) and the data for row (<page#>, <row#>) in table <table_name>, database <dbnum> are inconsistent; data is marked deleted but index is not. Aborting the transaction", may be reported during an isolation level 0 scan.



CR:761047
CR Number:   761047
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)
30 Apr 2014 Not reproducible with latest version of the product available as of Resolution Date
23 Jul 2014 Fixed by Integrated Component
03 Oct 2014 Port Not Needed
Description
Diagnostics improvements to get clean stacktrace when SAP ASE encounters an infected with 11 (SIGSEGV) error in modules such as ct__apicont_trans().



CR:761062
CR Number:   761062
Product Name:   Adaptive Server Enterprise
Product Component:   Q Application Engine
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2014 Fixed
Description
When using sql replication and nested builtins with a column reference, an incorrect sql statement may be generated instead of defaulting to row replication.
Workaround Description
 None at this time. However, if not fixed, this behavior should be called a limitation since getdate() is a relative function, based on the date/time of the ASE server that invokes the function.



CR:761117
CR Number:   761117
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2014 Fixed
07 Apr 2014 Fixed
09 Apr 2014 Fixed
21 May 2014 Fixed
21 May 2014 Fixed
Description
DML on tables with Encrypted Columns are significantly slower than SP50.



CR:761155
CR Number:   761155
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP62
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2014 Fixed
18 Apr 2014 Fixed
03 Jul 2014 Port Not Needed
Description
For SAP ASE Cluster Edition, when table creation is in progress, the checkpoint process may hit an infected with 11 (SIGSEGV) in the module 'ocm_hold()' and report a stacktrace in the SAP ASE errorlog that includes the modules 'des_has_onlutl_active()' and 'cm_writedes()'.



CR:761188
CR Number:   761188
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)
16 Nov 2014 Bundled Request
Description
Monitoring Tables to have an extra column as "OrigServerUserID" to track original ServerUserID when executing procedures with "execute as".



CR:761205
CR Number:   761205
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
With streamlined dynamic SQL enabled, show_cached_plan_in_xml does not display the query plan for

a cached language cursor.



CR:761275
CR Number:   761275
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)
13 Apr 2014 Fixed
14 Apr 2014 Fixed
16 Apr 2014 Fixed
04 Jun 2014 Fixed
10 Jun 2014 Fixed
Description
When there are several scans on the same index and some of the scans hit the same index page needed to be shrunk concurrently, the index page may be shrunk twice. The second attempt will fail and a 2630 error, "In database <db>, page <page#2> is linked backward to page <page#1>, but that page is linked forward to page <page#3>. Please report this internal error to SAP Technical Support". Although a 2630 error is raised, the index is not corrupted.



CR:761282
CR Number:   761282
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)
23 Apr 2014 Fixed
20 May 2014 Fixed
23 Apr 2014 Reservation Made
04 Jun 2014 Fixed
Description
When execute command ALTER TABLE ... SPLIT PARTITION ..., use of parallel sort and table's partition number > 1, it will encounter an Error 675: "Invalid Buffer Cache Access: Attempt to locate page <page>, database <dbid> in cache failed because no object id was specified. scan_context={objid <objid>, indid <indid>, cid <cid>}. Contact Technical Support for Assistance."
Workaround Description
 sp_configure 'max utility parallel',1

as long as the sort is done in serial, we will not hit any error msg.



CR:761313
CR Number:   761313
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2015 Not reproducible with latest version of the product available as of Resolution Date
Description
On Solaris and Linux it's possible that on a system where the IO system is stressed, the error "SYBMULTBUF WARNING: Attempt to start async i/o failed: Cannot use async i/o due to operating system limitation on the maximum number of simultaneous async i/o requests." is often printed in the error log. When this happens the system switches to synchronous writes.



CR:761333
CR Number:   761333
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 Apr 2014 Fixed
25 Sep 2014 Fixed
06 Oct 2014 Fixed
05 Nov 2014 Fixed
27 Oct 2014 Fixed
Description
In some workloads with lot of dynamic prepare statements executing on the system, we would see buffer cache of system table 'sysusers' and 'sysdatabases' to be hot.



CR:761385
CR Number:   761385
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   MPE/XL
Original Version:   15.7 SP62
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2014 Fixed
07 Apr 2014 Fixed
08 Apr 2014 Fixed
20 Jan 2015 Port Not Needed
Description
The message, "Current process infected with signal 10 (SIGBUS)", followed by a stack trace that includes the modules 'loginfo_builtin' and 'exec_lava' may be reported in the error log when the builtin loginfo('<dbname>','oldest_active_transaction_date') is executed.



CR:761402
CR Number:   761402
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Signal 11 at open_system_table+0x48,st_readstatistics,stat_previous_stats



CR:761410
CR Number:   761410
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2014 Fixed
18 May 2014 One-off Provided
29 Apr 2014 Fixed
22 Apr 2014 Fixed
27 Apr 2014 Port Not Needed
27 Apr 2014 Port Not Needed
Description
UPDATE STATISTICS WITH SAMPLING may report error 614: "Adaptive Server accessed a row that has an illegal length of <n> while in data base '<db>." or error 806: "Could not find virtual page for logical page <n> in database '<db>', while concurrent DML is going on the same object.
Workaround Description
 Use hashing instead of sampling with update statistics, results should be more accurate and obtained more quickly.



Another workaround would be to create a user defined optgoal or a login trigger which turns off auto_temptable_stats, if this only happens when running queries and not with update statistics with sampling.



CR:761514
CR Number:   761514
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)
09 Apr 2014 Fixed
15 Apr 2014 Fixed
Description
sybatch.exe failed to set the XP Server in upgrading server if Replication Server is configured.



CR:761518
CR Number:   761518
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP62
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2014 Fixed
11 Apr 2014 Fixed
14 Apr 2014 Fixed
04 Jan 2015 Fixed
Description
A 7786 error, "Unable to turn role off since user is not a valid user in the current database", may be reported incorrectly when executing the SET ROLE OFF command.



CR:761555
CR Number:   761555
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2014 Fixed
10 Apr 2014 Fixed
17 Apr 2014 Fixed
17 Apr 2014 Fixed
15.7 SP122 16 Apr 2014 Fixed
17 Apr 2014 Fixed
Description
Some of the cache buffers used for sort are not claimed and unclaimed correctly. This can lead to a performance impact if cache swap occurs.



CR:761597
CR Number:   761597
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 SP122 Linux IA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2014 Fixed
11 Jun 2014 Fixed
03 Jul 2014 Fixed
06 Aug 2014 Fixed
09 Jul 2014 Fixed
24 Jun 2014 Fixed
20 Jul 2014 Fixed
17 Jul 2014 Fixed
01 Jul 2014 Fixed
09 Jul 2014 Not reproducible with latest version of the product available as of Resolution Date
14 Jul 2014 Fixed
09 Jul 2014 Fixed
06 Jul 2014 Presently Not Targeted For Any Future Release Of This Product
14 Jul 2014 Fixed
16 Jul 2014 Third Party Problem
10 Jul 2014 Not a Bug
06 Jul 2014 Fixed
26 Jun 2014 Not a Bug
09 Jul 2014 Not a Bug
06 Jul 2014 Fixed
06 Jul 2014 Fixed
06 Jul 2014 Fixed
06 Jul 2014 Fixed
16 Jul 2014 Fixed
11 Aug 2014 Fixed
11 Aug 2014 Fixed
Description
Port SAP ASE to the Linux Itanium platform at the SAP ASE 157 SP122 release base.



CR:761668
CR Number:   761668
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)
09 Apr 2014 Fixed
09 Apr 2014 Fixed
16 May 2014 Fixed
Description
A 614 error may be reported when executing DBCC CHECKSTORAGE on an encrypted database.



CR:761679
CR Number:   761679
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)
20 May 2014 Fixed
13 Jun 2014 Fixed
04 Jun 2014 Port Not Needed
Description
LOAD DATABASE WITH LISTONLY=LOAD_SQL with UNTIL_TIME after a tran dump and before a database dump generates incorrect load SQL.



CR:761710
CR Number:   761710
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2014 Fixed
15 May 2014 Fixed
17 Jun 2014 Fixed
Description
SAP ASE server may hang during the rs_init() command on encrypted databases.



CR:761725
CR Number:   761725
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)
21 Apr 2014 Presently Not Targeted For Any Future Release Of This Product
21 Apr 2014 Fixed
Description
Description: Issue occured in 15.7SP110 onwards



Frequency: Occasionally



Server Enviornment: On heavily-loaded



Platform: All



Symptoms: Server hangs when using UPDATE INDEX operator in showplan and an Error 1105 occurs



CR:761743
CR Number:   761743
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)
10 Apr 2014 Fixed
15 Apr 2014 Fixed
07 May 2014 Fixed
Description
The optcriteria EQUALS_SCAN_SUPERSET and EQUALS_NLJOIN_SCAN_SUPERSET have had the comments changed so that the respective optcriteria names shows up in the sysoptions output.



CR:761769
CR Number:   761769
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)
Description
Sub-optimal performance may be observed when a query has IN list predicate executed on a table with hash partition due to non-elimination of unqualified partition.



CR:761825
CR Number:   761825
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)
30 Jun 2014 Fixed
Description
Bulk insert to proxy tables mapped to DirectConnect for Oracle was disabled in ASE 15.0.



CR:761830
CR Number:   761830
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)
22 Jul 2014 Fixed
20 Jun 2014 Reservation Made
08 Jul 2014 Reservation Made
Description
New SAP ASE built-in IS_PREPARED(<dbid>) will report if a database has been put in a PREPARE state.



CR:761835
CR Number:   761835
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   all
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE might hit timeslice error in kbfusage in monMemoryUsage query.



CR:761836
CR Number:   761836
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2014 Fixed
20 May 2014 Fixed
13 Jun 2014 Fixed
18 Jun 2014 Fixed
09 May 2014 Reservation Made
13 May 2014 Fixed
15 May 2014 Fixed
21 May 2014 Fixed
22 May 2014 Fixed
29 May 2014 Fixed
11 Jun 2014 Fixed
10 Jun 2014 Fixed
13 Jun 2014 Fixed
13 Jun 2014 Reservation Made
13 Jun 2014 Fixed
Description
Add a "Bucket Pool" memory manager to help improve enable ASE scaling over large CPU core configurations.



CR:761860
CR Number:   761860
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)
17 Apr 2014 Fixed
18 Apr 2014 Fixed
Description
Executing DBCC CHECKSTORAGE on an encrypted database gets aborted at the 'index chain' check.



CR:761881
CR Number:   761881
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP62
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2014 Fixed
29 May 2014 Fixed
22 May 2014 Fixed
02 Jun 2014 Fixed
Description
BCP in to a table with encrypted columns is much slower with the change from the use of the Certicom libraries.



CR:761932
CR Number:   761932
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 Apr 2014 Fixed
17 Apr 2014 Fixed
Description
The time range restriction in Resource Governor does not allow users to add time range overlap limits even with different limit types.



CR:761934
CR Number:   761934
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 Apr 2014 Fixed
17 Apr 2014 Fixed
Description
A 18207 error, "Illegal action 5", may be reported when executing stored procedure sp_modify_resource_limit.



CR:761958
CR Number:   761958
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 Apr 2014 Fixed
17 Apr 2014 Fixed
29 Apr 2014 Fixed
Description
DBCC CHECKTABLE may report a 605 error, "An attempt was made to fetch logical page <pageno> from cache <name>. Page belongs to <info1> and not to <info2>" may be reported after creating an index with online option.



CR:761965
CR Number:   761965
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2014 Added to user documentation
Description
improve documentation about number of locks for sp_monitorconfig.



CR:762026
CR Number:   762026
Product Name:   Sybase SQL Server
Product Component:   sybinit
Status:   Closed
OS:   Microsoft Windows
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2014 Fixed
21 Apr 2014 Fixed
Description
syconfig/sybatch try to recreate XP Server during upgrade even it doesn't exist.



CR:762057
CR Number:   762057
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.7 ESD#3 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2014 Fixed
17 Sep 2014 Fixed
02 Sep 2014 Port Not Needed
Description
In rare circumstances if DBCC PSS fails it may leave the pss in a kept state and cause

subsequent commands to get fail with error 8601 "Process <n> tried to keep the PSS for process <m> when it already had the PSS for process <p> kept."



CR:762072
CR Number:   762072
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2014 Fixed
04 Aug 2014 Fixed
09 Aug 2014 One-off Provided
04 Aug 2014 Reservation Made
11 Sep 2014 Fixed
Description
The messages 'ERROR: JNI_CreateJavaVM; failed attaching to the JVM for AttachCurrentThread() with -1', 'WARNING: FindClassWithLoaderID; is re-throwing Exception' or 'WARNING: FindPublicMethodFlags; is re-throwing Exception' may be reported in the SAP ASE error log, when the PCI memory pool is running out of memory.
Workaround Description
 ASE must be restarted in order to clear the problem



CR:762174
CR Number:   762174
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 Apr 2014 Fixed
16 Apr 2014 Fixed
15.7 SP122 16 Apr 2014 Fixed
16 Apr 2014 Fixed
17 Apr 2014 Fixed
18 Apr 2014 Fixed
15.7 SP111 18 Apr 2014 Fixed
18 Apr 2014 Fixed
28 Apr 2014 Fixed
18 Apr 2014 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module SearchEngine::_SeFindOptimal may be reported in the error log after a lengthy optimization, most likely after an aggregate with a GROUP BY in which the GROUP BY columns originate from multiple tables.



CR:762178
CR Number:   762178
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)
02 May 2014 Fixed
23 Dec 2014 Fixed
Description
When ansinull is off, an incorrect NULL value row could be returned when an equi-join under an OR

predicate is on two columns with NULL values and the final plan is using a special

OR strategy plan for the OR predicate. An example of such an OR predicate is "t1.col1 IN (1,2,t2.col2)".
Workaround Description
 compatibility mode or use the cmdline traceflag 16976.



CR:762199
CR Number:   762199
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)
25 Jul 2014 Fixed
12 Jun 2014 Fixed
27 May 2014 Bundled Request
Description
The SAP ASE COTS JavaVM version (used for the Java in SAP ASE functionality) is updated to version JRE 7 update 55 for each supported platform in the sybpcidb database.



CR:762224
CR Number:   762224
Product Name:   Adaptive Server Generic Docs
Product Component:   In-Memory Database Users Guide
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2014 Added to user documentation
Description
The documentation incorrectly states that the system tempdb can be altered to use dml_logging minimal and be turned into a temporary RDDB. This cannot be done, error 16052 is raised if you try.



CR:762233
CR Number:   762233
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2014 Fixed
Description
CR 472182 changes the default value of "number of locks" already in ASE 15.1 from the previous 5000 to the current 10000 however, our documentation has not kept pace with this change and still states that the default value is 5000 when it should in fact read, 10000 .



CR:762257
CR Number:   762257
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 Apr 2014 Fixed
09 Jun 2014 Fixed
Description
When a dynamic batch insert is executed, an "infected with 11" (SIGSEGV) stacktrace may be reported in the SAP ASE errorlog. The stack trace will reference the functions tdsrecv__process_batchparam() and tdsrecv_dynamic().



CR:762262
CR Number:   762262
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2014 Fixed
12 Nov 2014 Fixed
Description
alter database set durability no_recover does not show "enhanced performance" status in sp_helpdn output.
Workaround Description
 When creating a user defined tempdb, specify "with durability=no_recovery, dml_logging=minimal"



CR:762266
CR Number:   762266
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP62
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2014 Fixed
29 May 2014 Reservation Made
03 Jun 2014 Fixed
30 Jun 2014 Fixed
Description
Under a rare condition, the fix for CR 750937 could cause a performance regression. The fix for 750937 is now only enabled under traceflag 219.



CR:762281
CR Number:   762281
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   16.0 GA PL01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 GA PL01 16 Apr 2014 Fixed
11 May 2014 Fixed
15.7 SP62 22 Apr 2014 Fixed
24 Apr 2014 Fixed
25 Apr 2014 Fixed
15.7 SP111 25 Apr 2014 Fixed
15.7 SP122 21 Apr 2014 Fixed
29 Apr 2014 Fixed by Integrated Component
23 Jul 2014 Fixed by Integrated Component
03 Oct 2014 Port Not Needed
Description
The version of OpenSSL used has been upgraded to OpenSSL 1.0.1g



CR:762349
CR Number:   762349
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)
19 May 2014 Fixed
Description
The expression -(minimum integer value) does not raise an error.



CR:762392
CR Number:   762392
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX 5.1
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2014 Fixed
22 Dec 2014 Fixed
Description
In rare circumstances many processes could get locked when a dump command is trying to prune trailing holes at the end of the database.
Workaround Description
 1) Verify this is the problem by looking at the stack traces, either using the 'stack all' command in sybmon, or using dbcc traceon(3604) + dbcc stacktrace(<spid>) from ISQL. The processes that are hung should show the dmap_lock() module



2) Find what's the process holding the lock using DBCC DISKMAP('lock_check', <dbname>) if running a server with this fix. Otherwise, it will be necessary to execute:

- dbcc dbtable(dbname) and find:



lstart is logical page #; vstart is virtual (2K) page #; size is # of logical

pages.

Writers waiting: 0 Writer active: 0 Readers count: 1



If there was a process holding a write lock, this output would show the spid. If the problem is because someone is not releasing the read lock, once you've checked the Readers count is not 0, you have to find the process that has the read lock using dbcc pss() on each thread.

..after testing some threads...

dbcc pss(0,13)

...

pdmaplocks_cnt=1 pdmaplocks[0]: 0x0x14773d460 (WR: 0 R: 1)



We found the process 13 has a read lock held. We have to kill it. If the process is in some killable state, that will release the lock. If the process doesn't want to die, the last chance is to do this:



1> dbcc dbrepair(test,dmap_unlock,3)

2> go

Process 13 is holding a shared diskmap lock in database 'test'.

It has been released.The number of diskmap readers in database 'test' was set to

1 and it has been set to 0.

DBCC execution completed. If DBCC printed error messages, contact a user with

System Administrator (SA) role.

There wasn't any writer.



CR:762538
CR Number:   762538
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Closed
OS:   HP-UX
Original Version:   16.0 GA PL01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2014 Fixed
21 Apr 2014 Fixed
22 Apr 2014 Fixed
28 Apr 2014 Fixed
Description
On HP-UX platform, sqlupgrade[res] cannot boot the old SAP ASE if LD_LIBRARY_PATH environment variable is set.
Workaround Description
 unset LD_LIBRARY_PATH environment variable and add $SYBASE/OCS-16_0/lib3p64 to SHLIB_PATH environment variable.



CR:762599
CR Number:   762599
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)
22 Apr 2014 Duplicate
Description
The SQL generated by LOAD with LISTONLY='CREATE_SQL' using AS clause contains incorrect sp_dboption <database name>.
Workaround Description
 Edit the results before using the generated SQL.



CR:762612
CR Number:   762612
Product Name:   Adaptive Server Enterprise
Product Component:   coverletter
Status:   Closed
OS:   Microsoft Windows
Original Version:   16.0 GA PL01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2014 Fixed
Description
The version of OpenSSL used has been upgraded to OpenSSL 1.0.1g



CR:762617
CR Number:   762617
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   16.0 SP01 PL01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request to allow stored procedure execution within a SQL UDF.



CR:762712
CR Number:   762712
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP61
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2014 Fixed
Description
When a non-language batch query (e.g. 'if @@transtate = 3 select 3 else select 0') is followed a language batch query which triggers an error (e.g. a query causing parsing error), an "infected with 11" (SIGSEGV) stacktrace to be reported in the SAP ASE errorlog. The stack trace will reference the functions batchparam_save_SQL() and memalloc().



CR:762728
CR Number:   762728
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2014 Fixed
Description
When INSERT INTO SELECT at LEVEL 0 is enabled, SELECT INTO does not wait for locked rows so may return wrong results.



CR:762901
CR Number:   762901
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2014 Fixed
15 Jul 2014 Fixed
Description
A 3651 error, "This transaction has been rolled back, rather than only the current statement" may be reported when running insert-select query involving proxy table.





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