Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:749833

CR Number:   749833 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_extrapwdchecks now allows NULL values. This leads to sp_addlogin for a different login and the same password to fail stating that you can't reuse password.

CR:749845

CR Number:   749845 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 02 Dec 2013 Fixed Description While trying to create and access vhash tables, the table might not be accessible.

CR:749879

CR Number:   749879 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 10 Nov 2013 Fixed 16.0 12 Nov 2013 Fixed Description HADR deactivation process can fail or get delayed due to transactions started by housekeeper and checkpoint tasks.

CR:749880

CR Number:   749880 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 17 Dec 2013 Fixed 16.0 31 Dec 2013 Fixed 17 Dec 2013 Reservation Made Description HADR deactivation operation should not wait for open transactions belonging to non-replicated databases to be completed.

CR:749899

CR Number:   749899 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 26 Nov 2013 Fixed 15.7 SP121 08 Dec 2013 Fixed 16.0 02 Dec 2013 Fixed 16.0 11 Dec 2013 Fixed 11 Dec 2013 Reservation Made Description monSysStatement does not show stored procedure when executed with another statement.

CR:749927

CR Number:   749927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 26 Nov 2013 Fixed 16.0 27 Nov 2013 Fixed Description If a database is dumped after an "alter database log off" command has failed, that database dump may produce an incorrect disk map after being loaded. Workaround Description  dbcc tablealloc, full, fix

CR:749941

CR Number:   749941 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 03 Nov 2013 Fixed 15.7 SP110 01 Nov 2013 Fixed 01 Nov 2013 Reservation Made 16.0 07 Nov 2013 Fixed 15.7 SP121 06 Nov 2013 Fixed 12 Nov 2013 One-off Provided 11 Nov 2013 One-off Provided 07 Jan 2014 One-off Provided 24 Jul 2014 Fixed Description SAP ASE might report an infected with 11 (SIGSEGV) stacktrace in the function mda_flush_iostats() when the SAP ASE configuration option "enable monitoring" is set to 1. Workaround Description  Problem can be avoided by setting 'enable monitoring',0

CR:749957

CR Number:   749957 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 14 Nov 2013 Fixed 16.0 28 Nov 2013 Fixed Description Support to create non-clustered local index in parallel for partitioned table with some empty partitions.

CR:750050

CR Number:   750050 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Dec 2013 Workaround Description In rare circumstances the error 603 could be raised after hitting the error 614, 624 and 3914 on ASE 15.7

CR:750056

CR Number:   750056 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 30 Dec 2013 Fixed 15.7 SP121 10 Jan 2014 Fixed Description Dump database with protected password ('with passwd = ') option only worked if specified in all lowercase letters.

CR:750062

CR Number:   750062 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 Nov 2013 Fixed Description internal only: Auditinit didn't accepet empty sqlsrv.sa_password attribute in resource file.

CR:750085

CR Number:   750085 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) 16.0 GA PL02 10 Apr 2014 Fixed Description A 14108 error, "Could not find partition descriptor for objid <obj_id>, indid <indid>, ptnid <ptn_id> in dbid <db_id>" will be raised when creating a local index on a partitioned table if the database option 'allow incremental dumps' is enabled.

CR:750163

CR Number:   750163 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 12 Nov 2013 Fixed 16.0 14 Nov 2013 Fixed 15.7 SP111 28 Feb 2014 Fixed Description In ASE 15.7 SP110 and above, under certain circumstances on AIX only, SAP ASE may erroneously produce the message "Message empty." while attempting to clean up after a previous failure.

CR:750167

CR Number:   750167 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   4.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 10 Nov 2013 Fixed 14 Nov 2013 Bundled Request Description Job Scheduler prints incorrect restart count while auto restarting.

CR:750187

CR Number:   750187 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2015 Insufficient priority to fix Description JVM on AIX runs out of memory

CR:750307

CR Number:   750307 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: sybmigrate of identity column data takes longer

CR:750314

CR Number:   750314 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 Nov 2013 Fixed 16.0 20 Jan 2014 Fixed 06 Dec 2013 Added to user documentation 31 Jan 2014 Added to user documentation Description Need a script to calculate transaction log growth rate

CR:750316

CR Number:   750316 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2013 One-off Provided 20 Dec 2013 One-off Provided 01 Jun 2014 Fixed 03 Jul 2014 Fixed 05 Jun 2014 Already Fixed by Another CR Description Under rare race conditions, when BCP IN is in progress with the INSERTs running concurrently on the same table, BCP may encounter an 820 error where the process tries to dirty a buffer which is already pinned to another PLC.

CR:750324

CR Number:   750324 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 14 Nov 2013 Fixed 15.7 SP121 26 Nov 2013 Fixed 16.0 28 Nov 2013 Fixed 16.0 01 Dec 2013 Fixed 15.7 SP121 02 Dec 2013 Fixed 16.0 02 Dec 2013 Fixed 16 Dec 2013 Not a Bug 16.0 02 Dec 2013 Fixed 15.7 SP121 18 Dec 2013 Fixed Description REORG REBUILD cmd may take more time than before if table have TEXT/IMAGE/UNITEXT columns.

CR:750353

CR Number:   750353 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) 26 Mar 2014 Workaround Description "Waiting for native threads message .. " to be configurable if would be printed to errorlog. Workaround Description  Use sp_ldapadmin 'set_log_interval', <log_interval in minutes> to set the log_interval to a large value.

CR:750354

CR Number:   750354 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 05 Nov 2013 Fixed 16.0 11 Nov 2013 Fixed 15.7 SP110 07 Nov 2013 Fixed Description The LOAD DATABASE CUMULATIVE command succeeds incorrectly, rather than failing with a 4334 error, 'Specified file is out of sequence...', if the cumulative dump is loaded after loading a transaction log dump that was dumped before the cumulative dump.

CR:750398

CR Number:   750398 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) 10 Jul 2014 Not reproducible with latest version of the product available as of Resolution Date Description In rare circumstances, a query with "order by count(1) desc" using CT's abstract plan returns wrong result.

CR:750436

CR Number:   750436 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 14 Jan 2014 Fixed Description A 1105 error, "Can't allocate space for object '<object_name>' in database '<db_name>' because '<segment_name>' segment is full/has no free extents. . . ." may be reported when running DBCC CHECKSTORAGE after the Server reboots from crash. Workaround Description  update the statistics of the workspace.

CR:750468

CR Number:   750468 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.7 SP50 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 14 Nov 2013 Fixed Description INSERT query raises error 225 (statement cache off) or 11060 (statement cache on) after loading a database with materialized columns using SQL functions to another database with different database id. Workaround Description  Make sure the destination DB has the same dbid as the source

CR:750489

CR Number:   750489 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to have the preupgrade utility provide more details on the exact issue when a problem is found with the text for a compiled object.

CR:750500

CR Number:   750500 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2014 Fixed 14 Apr 2014 Fixed 17 Apr 2014 Fixed 21 Apr 2014 Fixed 23 May 2014 One-off Provided Description Stored procedures with application context functions take a very long time to execute because SAP ASE accesses system catalogs each time for protection checks. Workaround Description  Granting sa_role to the user which executes the application stored procedures , avoids the authorization check, reducing this way the contention over the authorization system catalogs and thus the spinlock on default data cache.

CR:750590

CR Number:   750590 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7.1 SP111 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 19 Nov 2013 Fixed 13 Nov 2013 Presently Not Targeted For Any Future Release Of This Product 16.0 19 Nov 2013 Fixed Description When RepAgent is configured to use multi-path replication where two paths are having a different set of transactions bound to them, the replication flow between the primary and the standby databases may stop working if this setup is used in conjunction with a warm standby setup.

CR:750617

CR Number:   750617 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) 16.0 07 Nov 2013 Fixed 15.7 SP110 07 Nov 2013 Fixed 15.7 SP60 07 Nov 2013 Fixed 15.7 SP121 22 Nov 2013 Fixed Description There is high spinlock contention on the dbt_spin for some user workloads even when not using multiple databases.

CR:750645

CR Number:   750645 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 05 Dec 2013 Fixed 06 Dec 2013 One-off Provided 02 Dec 2013 One-off Provided 15.7 SP121 08 Dec 2013 Fixed 25 Dec 2013 Fixed 25 Jul 2014 Fixed Description An infected with 11 (SIGSEGV) in the function ct__tds_fetch_cache_cols() is reported in the SAP ASE errorlog and then the server crashes.

CR:750655

CR Number:   750655 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2013 Fixed 04 Aug 2014 Fixed 04 Aug 2014 Fixed Description The message, "current process infected with signal 11", together with a stack trace involving the functions rtms_print_um_error() may be reported when a spid waiting for get a JMS message raises error.

CR:750665

CR Number:   750665 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Microsoft Windows Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 09 Nov 2013 Fixed 13 Mar 2014 Not a Bug Description internal only: support upgrade from 15.7 to 16.0

CR:750683

CR Number:   750683 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 17 Dec 2013 Fixed 15.7 SP121 17 Dec 2013 Fixed 16.0 09 Jan 2014 Fixed 06 Jun 2014 Fixed 05 Jun 2014 Fixed Description In rare circumstances, the execution of Java User Defined Functions (UDF) could mistakenly ignore the arguments it expects when these are presented to it through a single argument that holds a white space separated string.

CR:750695

CR Number:   750695 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2013 Duplicate Description Signal 11 in TcElement::TcElement or TcsState::tcs_merge Workaround Description  Use ase_default or remove the ORDER BY clause

CR:750705

CR Number:   750705 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) 13 Dec 2014 Fixed 08 Apr 2014 DEFER 11 Dec 2014 Reservation Made 06 Jan 2015 Fixed 10 Jan 2015 Fixed 17 Dec 2014 Fixed 18 Jan 2015 Fixed 18 Dec 2014 Fixed 13 Jan 2015 Fixed 07 Jan 2015 Reservation Made 09 Jan 2015 Reservation Made Description Query performance may be affected on queries for which optimizations are based on stale statistics where column histograms are out-of-range. An UPDATE STATISTICS option is provided to implicitly generate new histograms which include the out-of-range values for a user-specified column.

CR:750719

CR Number:   750719 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2013 Fixed 09 Dec 2013 Fixed 17 Dec 2013 Fixed 15.7 SP121 12 Dec 2013 Fixed 16.0 12 Dec 2013 Fixed Description Error 247:"Arithmetic overflow during implicit conversion of <type> value <value> to a <type> field ." can be seen while running stored procedure sp_spaceusage on large table.

CR:750731

CR Number:   750731 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 08 Nov 2013 Fixed Description internal review

CR:750762

CR Number:   750762 Product Name:   Adaptive Server Enterprise Product Component:   SQL Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2013 Fixed Description internal only

CR:750763

CR Number:   750763 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 SP60 21 Nov 2013 Fixed 15.7 SP121 20 Nov 2013 Fixed 16.0 24 Nov 2013 Fixed 10 Mar 2014 One-off Provided 25 Jul 2014 Fixed Description An SAP ASE task keeps sleeping in remote i/o state even if the connection terminates while the SAP ASE task is executing a query to the remote SAP ASE. This problem may occur if the client program executes a query accessing a proxy table. You have to kill the spid manually. Workaround Description  kill <spid> manually

CR:750787

CR Number:   750787 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 14 Nov 2013 Fixed 14 Nov 2013 Fixed 15.7 SP121 14 Nov 2013 Fixed Description sybatch:Failed to Create Self Management login/user

CR:750807

CR Number:   750807 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP51 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2014 Fixed 15.7 SP121 18 Dec 2013 Fixed 16.0 23 Dec 2013 Fixed 12 Jan 2014 One-off Provided 15.7 SP111 24 Feb 2014 Fixed Description Correct an 814 error situation (Keep count of buffer '0x%lx' in cache '%.*s' holding logical page '%u' in database '%.*s' has become negative).

CR:750822

CR Number:   750822 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 PL3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 11751 is raised when a CASE statement in the SELECT clause uses a subquery expression that does not have a FROM clause. Workaround Description  Rewrite the CASE expression. case when (select 'test') = 'test' then 'match' else 'do not match' end as "col3" The "(select 'test')" can be replaced with either just "'test'" or a subquery that references a table such as "(select min('test') from sysusers)"

CR:750883

CR Number:   750883 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) 19 Mar 2014 Fixed 13 Mar 2014 Reservation Made 02 Apr 2014 Fixed Description auto_temptable_stats will automatically generate in-memory statistics on a #temptable column on the first optimizable statement that needs statistics on that column. However, the statistics are not regenerated after a subsequent INSERT/DELETE/UPDATE or TRUNCATE table command. The optcriteria or traceflag 12801 will delete all in-memory statistics on the respective table so that up-to-date statistics will be generated on the next optimizable query referencing the respective #temptable. Note that the ase_current optimization level will not enable this functionality. In order to enable this functionality, explicitly execute "set cr750883 on", or define a user defined optgoal that includes this optcriteria, or enable trace flag 12801 on server startup.

CR:750911

CR Number:   750911 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description TF 7822 can cause ASE 15.7 sp1xx in process kernel mode on Solaris to hang Workaround Description  Run in threaded kernel mode and don't use -T7822

CR:750913

CR Number:   750913 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 28 Nov 2013 Fixed Description On Windows 64-bit, sp_helpdevice incorrectly reports 'unknown device type' for file system devices that are 4Gb or larger. This also prevents sp_deviceattr from issuing the warning: "Warning: '<large device physname>', is a file system device. A system failure may cause data loss if the dsync option is set to false." Workaround Description  None known. Can be ignored for sp_helpdevice but may cause issues for sp_deviceattr. sp_deviceattr should warn if 'dsync' is turned off for file system devices and this will not occur in this case.

CR:750937

CR Number:   750937 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2014 Fixed 04 Feb 2014 Fixed 15.7 SP61 07 Feb 2014 Fixed 04 Feb 2014 Fixed 07 Feb 2014 Fixed 15.7 SP121 03 Mar 2014 Fixed 16.0 GA PL01 04 Mar 2014 Fixed Description Sometimes a long running transaction can be seen in tempdb for $sort_local which results in tempdb filling up if a large data set needs to be sorted.

CR:750972

CR Number:   750972 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 06 Dec 2013 Fixed 09 Dec 2013 Fixed 15.7 SP121 12 Dec 2013 Fixed Description Server crash after writing the commit log during merge partition or online create index can cause data corruption. Pages deallocated during merge partition were getting allocated to same or other tasks even before merge partition is over.

CR:750981

CR Number:   750981 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) 16.0 25 Nov 2013 Fixed 16.0 24 Dec 2013 Fixed 15.7 SP121 03 Dec 2013 Fixed 06 Jan 2014 Reservation Made 16.0 19 Jan 2014 Fixed Description Trace flag 7795 will force a union query to return results in a sorted order. The sort order is determined by the order of the projection list.

CR:750991

CR Number:   750991 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2013 Fixed 18 Nov 2013 Fixed 22 Nov 2013 Duplicate 11 Dec 2013 Port Not Needed 11 Dec 2013 Port Not Needed Description sp_sysmon gives wrong Average values for Engine Busy Utilization in process kernel mode.

CR:751034

CR Number:   751034 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5.3 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 24 Nov 2013 Fixed 27 Nov 2013 One-off Provided 27 Nov 2013 Fixed 15.7 SP121 27 Nov 2013 Fixed 15.7 SP60 27 Nov 2013 Fixed 04 Jun 2014 Fixed Description If the DUMP DATABASE is run on a database, a 691 error, "Encountered invalid logical page <page id> while accessing database <database name and id>, object <object name and id>, index <index name and id>, partition <partition name and id>. This is an internal system error. Please contact Sybase Technical Support.", might be reported when running SELECT INTO cmd to create a proxy table in this database.

CR:751062

CR Number:   751062 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 22 Nov 2013 Fixed 22 Nov 2013 Fixed 16.0 04 Dec 2013 Fixed Description A 12954 error, "Database <dbname>: upgrade could not install required upgrade item 80." may be reported when upgrading from ASE 12.5 or after to ASE 16.0.

CR:751067

CR Number:   751067 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 30 Dec 2013 Fixed 26 Dec 2013 Reservation Made 20 Jan 2014 Fixed Description DELETE not using row limit optimizations The optimization is enabled by optcriteria. Workaround Description  Force the index

CR:751184

CR Number:   751184 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2014 Fixed 04 Aug 2014 Fixed Description The Secondary Truncation Point may not be moving as expected by the SAP ASE RepAgent process in a Multiple Paths Replication environment.

CR:751192

CR Number:   751192 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2014 Fixed Description A 9022 error, Cannot deliver a command from <connection>.<database> since no transaction is open. may be reported in the SAP RS error log, when the SAP ASE RepAgent is configured to use the Multi-Path Replication feature and while a DML command is rolled back in ASE resulting in the replication stream to fail.

CR:751228

CR Number:   751228 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   AIX Original Version:   cepheus beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2013 Fixed Description internal review only

CR:751238

CR Number:   751238 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 SP60 22 Nov 2013 Fixed 15.7 SP121 25 Nov 2013 Fixed 16.0 25 Nov 2013 Fixed Description On the Windows platform, an SAP ASE server might fail to start up if it uses the -r option to specify the mirrored device. dcmpmirror and kdactivate messages are reported in the SAP ASE errorlog.

CR:751305

CR Number:   751305 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP52 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2014 Presently Not Targeted For Any Future Release Of This Product 08 Oct 2014 Port Not Needed Description INSTRUMENTATION: reduce CIPC communication latency.

CR:751331

CR Number:   751331 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2014 Fixed Description No error is raised when compression option is used in index partition clause of CREATE INDEX.

CR:751376

CR Number:   751376 Product Name:   ASE Management Product Component:   Administration Client Status:   Open OS:   Windows XP Pro Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2013 Bundled Request Description Error Log Viewer is set to not auto-refresh by default as in certain cases the latency of fetching rows make the GUI harder to use.

CR:751471

CR Number:   751471 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 22 Jan 2014 Fixed 16.0 23 Jan 2014 Fixed Description SQL Statement replication using CI is not supported for GA.

CR:751510

CR Number:   751510 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2014 Fixed 19 Mar 2014 Fixed 13 Jun 2014 Fixed Description If any online utility is running and HK_GC fails to get DES, it gives rise to an 8233 error ("<name> operation is in progress on the object '<obj>' in database '<dbname>'. Retry your query later."). If traceflag 2792 is ON HK_GC will wait there, which may then cause an undetected deadlock.

CR:751612

CR Number:   751612 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 09 Dec 2013 Fixed Description When Kerberos is configured and many engines are created using 'create thread pool', then deleted with "alter thread pool', and then created again, Security Control Layer initialization fails due to exhaustion of memory resources with errorlog message: 00:0061:00000:00000:2013/11/07 00:41:47.50 server Security Control Layer's memory allocation routine returned an error.

CR:751664

CR Number:   751664 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 18 Dec 2013 Fixed 16.0 20 Dec 2013 Fixed Description New option 'config_bs' for the built-in function hadr_admin() to add an entry to the hosts.allow file.

CR:751670

CR Number:   751670 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 16 Dec 2013 Fixed 08 Jan 2014 Port Not Needed 30 Jan 2014 One-off Provided 24 Nov 2014 Not a Bug Description When creating a new 8k or 16k page SAP ASE using syconfig (Windows) or srvbuild(res) (Unix) and additionally setting up PCI at the same time, SAP ASE may not have enough memory to boot.

CR:751820

CR Number:   751820 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) 17 Dec 2013 Fixed 15.7 SP121 17 Dec 2013 Fixed 16.0 20 Dec 2013 Fixed Description New feature request to allow DUMP TRANSACTION to use the options WITH VERIFY=CRC and VERIFY=READ_AFTER_WRITE as well as LOAD TRANSACTION WITH VERIFY[ONLY]=CRC. These options are applicable only at DUMP TRANSACTION time if the option WITH COMPRESSION is also used. Likewise, the CRC verification at LOAD TRANSACTION time is only applicable if the transaction dump is created with the CRC verification option as well.

CR:751829

CR Number:   751829 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 29 Dec 2013 Fixed 26 Dec 2013 Fixed Description Alter table split/ move partition on a table followed by add non materialize column can cause data corruption.

CR:751851

CR Number:   751851 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP51 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2014 Consult Complete 16.0 21 Jan 2014 Fixed 16.0 24 Jan 2014 Fixed Description On AIX platform, dataserver and libbtsymbols.so pair should match from the same build, otherwise stacktraces will be incorrect. There is no validation to indicate incorrect install/update process may result in a mismatch resulting in wrong stacktraces. This change issues a warning if there is mismatch like "kernel Warning: mismatch of dataserver (90112) and libbtsymobls.so (90113)".

CR:751900

CR Number:   751900 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 09 Dec 2013 Fixed 15.7 SP121 12 Dec 2013 Fixed 08 Jan 2014 Fixed 16.0 10 Dec 2013 Fixed 11 Dec 2013 Fixed Description 'REORG REBUILD WITH ONLINE' may fail with error 806 (Could not find virtual page for logical page <page#> in database '<dbname>'.), if the table has undergone an 'ALTER TABLE DROP COLUMN WITH NO DATACOPY' operation.

CR:751923

CR Number:   751923 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 Dec 2013 Fixed 16.0 09 Dec 2013 Fixed 16 Dec 2013 Fixed 16 Dec 2013 Fixed Description During continuous replication Rep Agent configured for STREAM REPLICATION may shutdown when receiving an a retrievable error from the Component Interface native thread. "Error: Streaming replication stream error (-1). Severity 2, MSProdReceiver: receive error occurred, shutting down xport" will be found in the ASE errorlog.

CR:751924

CR Number:   751924 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) 30 Apr 2014 Fixed Description A 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization" may be reported when SET ANSINULL statement is used inside a batch containing other statements. Workaround Description  Put the SET statement in its own batch or use traceflag 2834

CR:751933

CR Number:   751933 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) 02 Apr 2014 Fixed 16 May 2014 Fixed 11 Jun 2014 Fixed Description When HADR is enabled, a graceful shutdown of the primary server requires that its state be inactive and the transaction logs be drained unless the new shutdown option 'nowait_hadr' be used.

CR:751934

CR Number:   751934 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) Description In a HADR configured environment, if "nodrain" option is used in "sp_hadr_admin deactivate" command, then to demote the primary server to standby use "sp_hadr_admin standby, 'force'".

CR:751956

CR Number:   751956 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) 02 Dec 2013 Not reproducible with latest version of the product available as of Resolution Date Description sp_serveroption "net password encryption" on SYB_BACKUP will cause DUMP and LOAD to fail with Open Server Error: 16400.10.0: srv__e3_create_encrypt3_context: Unexpected failure in comn_keypair_create.

CR:752105

CR Number:   752105 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 03 Jan 2014 Fixed 23 Jan 2014 Presently Not Targeted For Any Future Release Of This Product Description Once Rep Agent has swirthed from (near)sync to async it will attempt to switch back again to (near)sync mode. In order to accomplish that the user task are slowed down so Rep Agent can reach again the end of the log. However if the initial scan after the switch is long, Rep Agent will not be able to slow down the user transacations for a long time. Workaround Description  n/a

CR:752115

CR Number:   752115 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 23 Jan 2014 Fixed 15.7 SP61 24 Jan 2014 Fixed 24 Jan 2014 Fixed 24 Jan 2014 Fixed 15.7 SP121 24 Jan 2014 Fixed 24 Jan 2014 Fixed Description When the SAP ASE kernel mode is configured as process and an SSL session/connection is abruptly killed/aborted, a SIGSEGV (infected with 11) with a stacktrace may be reported in the SAP ASE errorlog. The functions drop_connection() and ssl_nclose() are likely to be seen as part of the stacktrace.

CR:752170

CR Number:   752170 Product Name:   Adaptive Server Enterprise Product Component:   SQL Status:   Closed OS:   Windows 7 Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2014 Fixed 27 May 2014 Presently Not Targeted For Any Future Release Of This Product 17 Jun 2014 Duplicate Description The ASE COTS JavaVM version is updated to version JRE 7 update 55 for each supported platform in the sybpcidb database.

CR:752204

CR Number:   752204 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 ALTER DATABASE should be combined with CREATE DATABASE for the purposes of granular permissions as they serve the same functions.

CR:752211

CR Number:   752211 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) 23 Feb 2014 Fixed 06 Feb 2014 Fixed Description Error message 3128 "The dump image specified does not contain information for any of the database devices" will be printed when a transaction dump generated by sybdumptran is use with the command LOAD DATABASE ... WITH LISTONLY = CREATE_SQL"

CR:752225

CR Number:   752225 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 CGA Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 16 Dec 2013 Fixed 30 Jan 2014 One-off Provided 13 Dec 2013 Reservation Made 16.0 17 Dec 2013 Fixed 15.7 SP111 20 Mar 2014 Fixed Description If there are more than 32 columns in the GROUP BY list, and more than 6 tables in the query then the query plan performance could be significantly different than equivalent queries which have less than or equal to 32 columns in the GROUP BY list. The optcriteria cr752225 eliminates the discontinuity in query plan selection/performance when the threshold of 32 columns in the group by list is passed.

CR:752351

CR Number:   752351 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 12 Dec 2013 Fixed 15.7 SP121 25 Dec 2013 Fixed Description sp_hadr_admin activate may report Msg 18703, "Please execute the procedure 'sp_hadr_admin' from master database."

CR:752352

CR Number:   752352 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2014 Fixed Description In some rare cases, in SAP ASE Cluster Edition, when one of the nodes goes down and FAILOVER recovery starts on the other node, a deallocated page can be wrongly brought into the cache. An INSERT which is fired after recovery has completed can pick up this deallocated page and insert into it. This may result in 7928 or other index corruption errors reported from DBCC CHECKTABLE.

CR:752353

CR Number:   752353 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) 17 Dec 2013 Duplicate Description error 924 sp_who shows no spid but dbtable output shows dbt_keep=1

CR:752367

CR Number:   752367 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Windows 2008 Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2013 Bundled Request 17 Jan 2014 Added to user documentation 15.7 SP121 13 Dec 2013 Fixed 11 Dec 2013 Port Not Needed 07 May 2014 Added to user documentation Description A data truncation error may occur when executing a query on the monTableColumns table and retrieving the value of the Description or Label columns in the Japanese language using an SAP ASE server that is configured to use the utf8 character set.

CR:752391

CR Number:   752391 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 Dec 2013 Fixed 15.7 SP121 09 Dec 2013 Fixed 01 Jan 2014 Fixed 09 Dec 2013 Fixed 09 Dec 2013 Fixed 15.7 SP111 27 Feb 2014 Fixed Description In rare case, if DOL table has unique index, concurrent DML may hit index corruption (error 12313 "Insert into page id <page #> of index id <index #> of table '<table name>' (id = <id #>) in database '<db name>' tried to replace undeleted RID (<>, <>) at slot <slot #> and ridposn <#>. Try dropping and recreating the index.")x.

CR:752408

CR Number:   752408 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) 15.7 SP121 16 Dec 2013 Fixed 16.0 13 Dec 2013 Fixed 15.7 SP61 16 Dec 2013 Fixed 21 Dec 2013 One-off Provided 24 Dec 2013 Port Not Needed 05 Feb 2014 One-off Provided 24 Jul 2014 Fixed Description In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log....", may be reported during boottime or LOAD DATABASE recovery, when a transaction that allocated a page, rolled back that allocation while a checkpoint was active. Workaround Description  Boot the server, or LOAD DATABASE with the 3412 trace flag turned on.

CR:752415

CR Number:   752415 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) 21 May 2014 Fixed Description Forcing an index on one table, where the query has more than 6 table joins and the configuration parameter 'enable deferred parallel' set to ON, can cause an infected with 11 (SIGSEGV) to be reported in the SAP ASE errorlog with a stacktrace involving ResVector::getScalarSum or GtgGroup::GtSecondaryInit Workaround Description  Don't force the index OR If the configuration parameter 'enable deferred parallel' is turned off, the query works fine.

CR:752435

CR Number:   752435 Product Name:   ASE Management Product Component:   Administration Agent Plugin Status:   Closed OS:   Generic Original Version:   3.2.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2013 Fixed Description The invalid text in the Write Options page of Add Database Device wizard is changed from "You can optionally specify number of partitions" to "Specify the write option". The label for the third radio button is changed from "Cached IO (Data sync off)" to "Buffered IO"

CR:752438

CR Number:   752438 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 12 Dec 2013 Fixed 17 Jan 2014 Port Not Needed Description Under some rare condition, when statement cache is on, a parameter bound to a value is not sent back the correct new value. Workaround Description  WorkAround: -------------- Set statement cache size to 0, though this can affect ASE server performance

CR:752439

CR Number:   752439 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   HP-UX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Load database without 'unload' option is causing rewind operation in the tape device.

CR:752471

CR Number:   752471 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 SP121 17 Dec 2013 Fixed 16.0 23 Dec 2013 Fixed Description In rare circumstances, the message "current process infected with 11" in the module ocm_hold together with a stack trace which includes the modules des_has_onlutl_active and 'checkpoint may be reported in the error log by the process doing 'CHECKPOINT' in a Cluster Edition SAP ASE environment.

CR:752500

CR Number:   752500 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) 16.0 10 Dec 2013 Fixed 15.7 SP121 10 Dec 2013 Fixed 11 Dec 2013 Fixed 10 Dec 2013 Reservation Made Description If upgrading from 15.7 GA or ESD#1,2,3 to 15.7 SP60 or 15.7 SP121, SAP ASE may encounter a segmentation fault error in the function upgd__find_basic_depends() during open database. Workaround Description  Before shutdown the old 157 server, run below command for each database: select dbinfo_update(@dbid, 'ASEvers', 15600) <-- @dbid is the database id Then shutdown, and reboot the new 157SP60, SP120 server.

CR:752523

CR Number:   752523 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2014 Fixed Description Switch ASE_JAVA support from COTS JavaVM towards SAP JVM delivery

CR:752555

CR Number:   752555 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) 15.7 SP60 05 Dec 2013 Fixed 11 Dec 2013 Port Not Needed Description A 697 error, "An attempt was made to fetch logical page '<page_id>' for <info_of_db_obj_index_partion> from cache '<cache_name>'. Wrong logical page '<page_id>' was found in cache." may be raised during a transaction rollback if the transaction promotes row locks to table locks for some table.

CR:752591

CR Number:   752591 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   MPE/XL Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 17 Dec 2013 Fixed 16.0 03 Jan 2014 Fixed 03 Jan 2014 Fixed 14 May 2014 Fixed 18 May 2014 Fixed 29 Apr 2014 Fixed 08 May 2014 Presently Not Targeted For Any Future Release Of This Product Description A segmentation violation occurs when the config option enable xact coordination is set to 0 and a connection is established between a primary and secondary server.

CR:752639

CR Number:   752639 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 23 Dec 2013 Fixed 23 Dec 2013 Reservation Made 16.0 16 Jan 2014 Fixed 16 Jan 2014 Fixed 15.7 SP61 17 Jan 2014 Fixed 15.7 SP111 07 Mar 2014 Fixed Description When the SAP ASE server is out of locks, a permission check can cause the error message "ulpspinlock: spinlock order violation" to be reported followed by a crash the SAP ASE server.

CR:752660

CR Number:   752660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 18 Dec 2013 Fixed 16.0 07 Jan 2014 Fixed 02 Apr 2014 Fixed Description In rare circumstances, an infected with 11 (SIGSEGV) may be reported in the SAP ASE error log together with a stack trace that includes the modules 'rec_dynamic_prefetch()' and 'rec_undo_session()' when recovery is being run at boot time or during LOAD DATABASE or LOAD TRAN.

CR:752668

CR Number:   752668 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 10 Dec 2013 Fixed 10 Dec 2013 Fixed 15.7 SP121 10 Dec 2013 Fixed Description The error "table still open - dbid <value> table id 58" or the error 12330, "An attempt was made to fetch logical page <value> with partition ID '58', ..." followed by a stack trace that contains the module 'closetable' may be reported when the database option 'allow cumulative dumps' is enabled.

CR:752670

CR Number:   752670 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) 15.7 SP121 18 Dec 2013 Fixed 08 Jan 2014 Port Not Needed Description Stacktrace could happen during showplan (LeScanOp::_LeOpShowBloomFilterInfo(char*)) or in LeSarg::mapSarg() for hash semijoin query plan when pushdown bloom filter for the hash join is used. Workaround Description  set join_bloom_filter off

CR:752705

CR Number:   752705 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 12 Dec 2013 Fixed 12 Dec 2013 Fixed Description Bulk insert on tables with roundrobin partitions may encounter signal11 with pg_get_targetpage() in the stack. Workaround Description  Use TF 8217.

CR:752764

CR Number:   752764 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for HP Status:   Open OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement requests for ASE 15.7 SP100 upgrade documentation

CR:752776

CR Number:   752776 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for HP Status:   Open OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description need correction of minimum sizes of system databases for ASE 15.7 SP100 documentation