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

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

CR:744696

CR Number:   744696 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 17 Sep 2013 Fixed 20 Nov 2013 Fixed Description On the Hpia64 platform, when SAP ASE is running on a real cluster in threaded kernel mode, if the XP server of an instance is shutdown from an isql session on another instance, the isql session will hang.

CR:744713

CR Number:   744713 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 SP60 14 Aug 2013 Fixed 15.7 SP121 16 Aug 2013 Fixed 15.7 SP110 15 Aug 2013 Fixed Description Backup Server may wrongly issue the message, "The change is completed. The option is dynamic and SAP ASE need not be rebooted for the change to take effect", for an invalid configuration with a config_name more than the 30 bytes allowed.

CR:744714

CR Number:   744714 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   Solaris Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2013 Fixed 12 Sep 2013 One-off Provided 15.7 SP103 10 Sep 2013 Fixed 15.7 SP110 10 Sep 2013 Fixed 15.7 SP121 10 Sep 2013 Fixed Description sqlupgrade and upgrade for unix to have dynamic timeout. Workaround Description  force serial recovery: max concurrently recovered db=1

CR:744740

CR Number:   744740 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 06 Aug 2013 Fixed Description When displaying information about a dump from a file that was created on a different byte architecture with LOAD DATABASE ... WITH HEADERONLY, the error message, "Message too long", may be reported in the error log where it should display the originating device information.

CR:744803

CR Number:   744803 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2013 Fixed 29 Aug 2013 Fixed 29 Aug 2013 Fixed Description

CR:744807

CR Number:   744807 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 Dec 2013 Reservation Made 23 Dec 2013 Fixed 13 Mar 2014 Fixed 21 Apr 2014 Fixed Description LPAD function will left-pad the input string with a specified pad to a supplied number of characters. RPAD function will right-pad the input string with a specified pad to a supplied number of characters. Workaround Description  Write a User Defined function.

CR:744810

CR Number:   744810 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 22 Aug 2013 Fixed 15.7 SP121 23 Aug 2013 Fixed 15.7 SP110 23 Aug 2013 Fixed 10 Mar 2014 One-off Provided 24 Jul 2014 Fixed Description If the SAP ASE configuration value 'cis connect timeout' limit is exceeded, the local process with the P_OMNI_TIMEDOUT status set will continue to sleep. Workaround Description  [celrod Aug 7 2013] sp_configure 'cis connect timeout', 0

CR:744830

CR Number:   744830 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 22 Aug 2013 Fixed 19 Nov 2013 Fixed Description Aborting a bulk page allocation process can give 'table already closed' error while closing SYSALLOCPG.

CR:744842

CR Number:   744842 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) 15.7 SP121 02 Sep 2013 Fixed 22 Aug 2013 Reservation Made 15.7 SP60 03 Sep 2013 Fixed 17 Nov 2013 Fixed Description Memory usage keeps increasing when querying MDA tables in a loop in stored procedure. Workaround Description  For this issue, there is a workaround. We can create a stored procedure like "mdatest_inner": create proc mdatest_inner as select * from master..monProcessSQLText go Then, in a stored procedure like "mdatest_outer", we will execute "mdatest_inner": create proc mdatest_outer as declare @i int select @i = 0 while (@i < 7 * 24 * 60 * 60) begin exec mdatest_inner select @i=@i+1 end go With this workaround, the memory increase issue would be gone.

CR:744872

CR Number:   744872 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) 15.7 SP110 12 Aug 2013 Fixed 15.7 SP60 14 Aug 2013 Fixed Description The 692 error, "Uninitialized logical page <page_no> was read while accessing database <dbname>, object 'syslogs' (8), ...", could be raised if the loginfo() built-in function is executed concurrently with DUMP TRANSACTION.

CR:744950

CR Number:   744950 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Track High Water Mark Usages of Procedure Cache per spid in monProcessesActivity.

CR:744954

CR Number:   744954 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In some ASE configuration sp_configure "max concurrently recovered db", 1 generate Error.

CR:744957

CR Number:   744957 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 06 Nov 2013 Fixed 07 Nov 2013 Fixed Description When the default of a non-materialized column is altered on a table that is replicated, extraneous updates to that column may be sent for replication.

CR:744975

CR Number:   744975 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 Aug 2013 Fixed 15 Aug 2013 Reservation Made 15.7 SP121 20 Aug 2013 Fixed 15.7 SP60 19 Aug 2013 Fixed Description An incorrect index can be selected when a query contains a multi-column ORDER BY, if the avoid_bmo_sorts optcriteria is turned on explicitly or thru enabling the ase_current optimization level. If a sort is used below a nested loop join, and the ordering that the sort produced contains a unique key, and the ordering is extended by the nested loop join and eventually used to satisfy the ORDER BY, then this plan may be skipped if the avoid_bmo_sorts optcriteria is turned on. Workaround Description  avoid_bmo_sorts off

CR:744978

CR Number:   744978 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 19 Aug 2013 Fixed 15.7 SP110 15 Aug 2013 Fixed 23 Aug 2013 Reservation Made 15.7 SP60 23 Sep 2013 Fixed Description TEXT/IMAGE data could be corrupted by byte-swap if the database once performed cross-platform database load on 15.0 ESD#2 or later version of SAP ASE, and the database was originally from a pre-12.0 version of SAP ASE.

CR:745032

CR Number:   745032 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) 10 Sep 2013 Fixed 15.7 SP110 11 Sep 2013 Fixed 15.7 SP121 12 Sep 2013 Fixed 24 Jul 2014 Fixed Description set plan opttimeoutlimit does not follow the same rule as optgoal and optcritera for optimization and execution. Workaround Description  use opttimeout in the AP.

CR:745042

CR Number:   745042 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Documentation for the UNMOUNT DATABASE command should show that the command cannot be used if mirroring is enabled (via sp_configure "disable disk mirroring" being set off) even if mirroring is not used for any device used by the databases being unmounted. The attempt to unmount will fail with error 14543.

CR:745071

CR Number:   745071 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 15 Aug 2013 Fixed 15.7 SP60 19 Aug 2013 Fixed 15.7 SP110 19 Aug 2013 Fixed 03 Jun 2014 One-off Provided Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module TcsState::tcs_merge() may be reported in the error log when optcriteria cr702725 is enabled and the query invokes referential integrity check and has an attribute in the ORDER BY clause which is not in the selection list. Workaround Description  set cr702725 off

CR:745087

CR Number:   745087 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 Nov 2013 Fixed Description Signal 11 stacktrace might happen in LeEmitXchgOp::_LeOpNext() for a union query between a list partitioned table and other table(s).

CR:745098

CR Number:   745098 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 Aug 2013 Fixed Description (INTERNAL_ONLY) Development oversight.

CR:745106

CR Number:   745106 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description monProcessSQLText.LineNumber does not report the same line as other monTable for the LineNumber column executing procedures.

CR:745112

CR Number:   745112 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2013 Fixed 26 Sep 2013 Fixed 15.7 SP121 17 Sep 2013 Fixed 15.7 SP121 10 Oct 2013 Fixed Description Modify srvbuild[res] and syconfig.exe/sybatch.exe utilities to support Remote Dump Host Control.

CR:745118

CR Number:   745118 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description select from a view that references another view get performance issue

CR:745141

CR Number:   745141 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2013 Fixed Description This is low-level thread coordination infrastructural code which the customer doesn't need to know about. The low configuration/performance gains due to the use of transactional memory may be interesting to the customer though.

CR:745144

CR Number:   745144 Product Name:   Adaptive Server Enterprise Product Component:   Language Modules Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_helpconfig "enable unicode conversions" shows you help information and messages including the wrong default value.

CR:745184

CR Number:   745184 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) 15.7 SP121 21 Oct 2013 Fixed 15.7 SP60 22 Oct 2013 Fixed 07 Nov 2013 Fixed Description Execution of stored procedures containing statements that are executed using deferred compilation causes the original SQL text in the monProcessSQLText MDA table to be replaced.

CR:745205

CR Number:   745205 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Open OS:   Linux Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Problem occurs when there are two calls to xp_cmdshell at the same time; passes the return value of the second call to the first call. Workaround Description  Run kernel mode = process

CR:745283

CR Number:   745283 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 06 Sep 2013 Fixed 15.7 SP110 11 Sep 2013 Fixed Description SAP ASE on AIX does not use 'Large Pages' with the configuration option of 'lock shared memory', resulting in suboptimal memory access

CR:745325

CR Number:   745325 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2013 One-off Provided 20 Aug 2013 Reservation Made 23 Aug 2013 One-off Provided 15.7 SP121 04 Nov 2013 Fixed 15.7 SP60 23 Sep 2013 Fixed 08 Nov 2013 Fixed 08 Nov 2013 Reservation Made Description Boot SAP ASE with trace flag 9166 when dbcc logtransfer replication is used to diminish the likelihood of contention on the Network Memory Pool spinlock that can cause high CPU utilization when a user table is marked for replication. Don't use trace flag 9166 with Rep Agent replication because operations such as DDL replication or request functions won't work anymore.

CR:745388

CR Number:   745388 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Implement "reserved for future use" fields in sysqueryplans

CR:745425

CR Number:   745425 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 ESD#2 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request a new DBCC tool to KILL a hung process which has P_KILLYOURSELF bit set in pss->pstat for a long time. A process might be sleeping and waiting for an EVENT to happen, if the related code doesn't check attention, then it's possible to sleep forever if the EVENT doesn't happen due to some bug or some other reason. Reboot to clear the hung process is not easy for some production systems since DBAs may need to schedule reboot time.

CR:745446

CR Number:   745446 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2013 Fixed Description A stacktrace may occur if auto_temptable_stats is enabled along with parallel sort, either explicitly or via using ase_current. This change will disable parallel statistics gathering on #temptables when update statistics is implicitly invoked via the auto_temptable_stats feature.

CR:745455

CR Number:   745455 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) 14 Jul 2014 Insufficient priority to fix 28 Aug 2013 DEFER Description The global variable @@setrowcount does not reflect the value of the last 'set rowcount <nn>' command in a stored procedure nor in the current batch. Workaround Description  None known

CR:745472

CR Number:   745472 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) 29 Sep 2014 Fixed 29 Sep 2014 Reservation Made Description Incorrect output of message 3705 is displayed when executing DBCC TABLE sysdams if trace flag 3717 is on. Workaround Description  if you want correct error message for dropping system table sysdams, trun off the trace flag 3717. if you want to drop the sysdams, use dbcc dam(<dbname>, 'drop')

CR:745492

CR Number:   745492 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2013 Consult Complete 15.7 SP121 07 Nov 2013 Fixed 14 Nov 2013 Fixed Description srvbuild creates a sparse file for tempdb file system device Workaround Description  See resolution #1 description for work around/fix.

CR:745539

CR Number:   745539 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow that any login with sa_role NOT be able to delete an entire user table which has encryption column.

CR:745571

CR Number:   745571 Product Name:   ASE Management Product Component:   Administration Client Status:   Closed OS:   Windows XP Pro Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2014 Fixed Description An error stating "Incorrect syntax near '":s: %1!"'" may occur when attempting to start the ASE Job Scheduler from within the SCC ASE Administration Console. Workaround Description  The workaround is for the user to log into the ASE under an account that has js_admin_role role and execute sybmgmtdb.. sp_sjobcontrol @name=NULL, @option="start_js" .

CR:745599

CR Number:   745599 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 04 Oct 2013 Fixed 15.7 SP121 04 Oct 2013 Fixed 04 Oct 2013 Fixed 16 Oct 2013 One-off Provided 16 Oct 2013 One-off Provided 15 Oct 2013 Port Not Needed Description In rare circumstances the message "current process infected with 6" in the module '__systemcall' together with a stack trace which includes the modules 'jvmfini' and 'BRIDGEjvm_AbortJavaVM' may be reported in the error log during the execution of a UDF/ADT or SQLJ query.

CR:745608

CR Number:   745608 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description create index allowes [.] in index name which then can not be dropped. Workaround Description  drop table [indexname]

CR:745655

CR Number:   745655 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2013 Fixed Description If the number of the engines is over 33, max repartition degree is 1 (default) and the tables for the join is unpartitioned, it could lead to stacktrace.

CR:745776

CR Number:   745776 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) 09 Oct 2013 Fixed 24 Sep 2013 Reservation Made Description A new configuration option "LARGE ALLOCATION AUTO TUNING" is added to enable/disable large allocation auto tuning feature

CR:745786

CR Number:   745786 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 871 after exceeding the resource governor

CR:745795

CR Number:   745795 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) 15.7 SP121 01 Sep 2013 Fixed 16.0 19 Nov 2013 Fixed Description A 15052 error, "Index error: Table id <tabid>, indid <indid> calculated <name> <value1> does not match value <value2> in Sysindexes." may be reported when running DBCC CHECKCATALOG on a database containing tables with option 'transfer table' on.

CR:745872

CR Number:   745872 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) 15.7 SP60 13 Sep 2013 Fixed 15.7 SP121 09 Oct 2013 Fixed 17 Nov 2013 Fixed Description When the command: sp_online "engine", <42> .. fails, i.e due to OS resource issue, SAP ASE's listener will hang, preventing new connections to be established.

CR:745873

CR Number:   745873 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 30 Aug 2013 Fixed 20 Sep 2013 One-off Provided 02 Sep 2013 Fixed 15.7 SP121 27 Sep 2013 Fixed 10 Apr 2014 Fixed 03 Oct 2013 Fixed 04 Sep 2013 Fixed 15.7 SP60 04 Sep 2013 Fixed 15.7 SP51 24 Sep 2013 Fixed 15.7 SP51 06 Sep 2013 Fixed 15.7 SP103 10 Sep 2013 Fixed 15.7 SP103 24 Sep 2013 Fixed 15.7 SP60 24 Sep 2013 Fixed 15.7 SP110 25 Sep 2013 Fixed 01 Oct 2013 Fixed 17 Jun 2014 Fixed Description In rare cases a 692 error, "Uninitialized logical page '<pageno>' was read while accessing database ..." may be reported sometime after loading a database dump that was taken of a database in both Enterprise Edition and Cluster Edition, that had been created on devices with direct i/o turned on, or taken of a database in a Cluster Edition system only, that had been created on devices with dsync turned on.

CR:745888

CR Number:   745888 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 SP60 18 Oct 2013 Fixed 04 Nov 2013 Bundled Request 15.7 SP121 18 Oct 2013 Fixed Description The FIPS ciphersuites are stricter in OpenSSL not all ciphersuites that were supported by Certicom in FIPS mode are supported by OpenSSL.

CR:745914

CR Number:   745914 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 16 Sep 2013 Fixed 15.7 SP60 17 Sep 2013 Fixed 11 Nov 2013 Fixed 15.7 SP111 31 Mar 2014 Fixed Description DBCC CHECKALLOC may report an incorrect number of unreserved log pages after ALTER DATABASE LOG OFF fails to remove a log fragment because some of the pages to remove are allocated.

CR:746028

CR Number:   746028 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) 15.7 SP121 30 Oct 2013 Fixed 02 Dec 2013 Fixed 15.7 SP111 05 Mar 2014 Fixed 12 Mar 2014 Fixed Description If a UDR roleid is greater than 1024 then a timeslice error may be reported in the SAP ASE errorlog. Workaround Description  This case is due to invalid srid. The customer may try to void manually changing the system catalogs, or use an srid that is not currently in use. The new srid must be between the max srid+1 and less than 1024.

CR:746056

CR Number:   746056 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 14 Oct 2013 Fixed 27 Nov 2013 Port Not Needed Description Sybcluster needs to support remote dump host control.

CR:746083

CR Number:   746083 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2013 Fixed 02 Apr 2014 Fixed 31 Mar 2014 Fixed Description feature request: backupserver binary compiled for 64-bit to enable larger memsize on solaris

CR:746101

CR Number:   746101 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) 28 Feb 2014 Fixed 05 Mar 2014 Fixed 09 Jul 2014 Port Not Needed 08 Jul 2014 Port Not Needed Description When using sp_downgrade to downgrade an SAP ASE from version 15.7 or higher to an SAP ASE that is version 15.5 based, the keycnt in sysindexes for index sysattributes.ncsysattributes will become incorrect.

CR:746156

CR Number:   746156 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2013 Fixed 15.7 SP121 26 Sep 2013 Fixed 15.7 SP60 26 Sep 2013 Fixed Description In some rare cases, when DOL data pages are undergoing deallocation while table scans are concurrently executed on the table, inserts from other concurrent threads may incorrectly qualify to-be-deallocated pages. This may result in 7928 or other index corruption errors reported from DBCC CHECKTABLE.

CR:746179

CR Number:   746179 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2013 Fixed 13 Dec 2013 Reservation Made Description New feature to specify configuration parameters like interface file or error log file for Job Scheduler Agent using sp_jsconfigure. Workaround Description  Start jsagent manually before ASE with the required parameters.

CR:746207

CR Number:   746207 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Msg 325 'no legal query plan' when query include proxy table defined for a procedure.

CR:746216

CR Number:   746216 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 Sep 2013 Fixed Description The fields NumberOfMempoolAllocates, NumberOfMempoolFrees, MempoolCurrentSize and MempoolHighUsage in master..monRepLogActivity are only maintained when sp_sysmon is running in parallel at the same time. Workaround Description  The counters are only populated when sp_sysmon runs. One could start sp_sysmon like sp_sysmon "00:10:00" and select from master..monRepLogActivity at the same time.

CR:746238

CR Number:   746238 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 11 Sep 2013 Fixed 28 Nov 2013 Bundled Request Description Enhance DBCC REINDEX to support RID comparison mode change for empty deferred_allocation table. Workaround Description  For empty deferred table, dbcc reindex() does nothing. For this case, we can write procedure to update status bit directly. Below is an example. create procedure rid_reset_deferred_tab as begin declare @objid int declare @indid smallint print "please make sure this proc is run in target databases." set proc_return_status off set nocount on declare c cursor for select id , indid from sysindexes where indid != 0 and status & 256 = 256 and id in (select id from sysobjects where sysstat3 & 128 = 128) open c fetch c into @objid, @indid while (@@sqlstatus = 0) begin update sysindexes set status = (status & ~256) where id =@objid and indid = @indid -- select name,id,indid,status from sysindexes where id =@objid and indid = @indid fetch c into @objid, @indid end close c deallocate cursor c end go sp_configure 'allow updates to system tables',1 go use db1 go exec rid_reset_deferred_tab go sp_configure 'allow updates to system tables',0 go

CR:746255

CR Number:   746255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2013 Fixed 15.7 SP121 11 Sep 2013 Fixed 15.7 SP110 11 Sep 2013 Fixed Description The cache partition maximum value has been increased to 256. The MAX value in cfg_options has been updated to be applicable for all stored procedures.

CR:746260

CR Number:   746260 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 04 Sep 2013 Fixed 15.7 SP121 09 Sep 2013 Fixed Description Logging into remote server using a login user granted with a user-defined role will fail.

CR:746261

CR Number:   746261 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP50 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 05 Nov 2013 Fixed 15.7 SP121 12 Nov 2013 Fixed 20 Nov 2013 Fixed 27 Nov 2013 Port Not Needed Description SAP ASE CE hangs when it cannot access storage devices due to a fencing or storage disconnect.

CR:746285

CR Number:   746285 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 18 Nov 2013 Fixed 15.7 SP121 22 Nov 2013 Fixed 02 Dec 2013 Fixed 22 Nov 2013 Reservation Made Description Enhancement that adds the possibility to add a cyclic redundancy check to a database or transaction dump created with compression (VERIFY=CRC), as well as to verify that the compression blocks can be correctly read and decompressed (WITH VERIFY=READ_AFTER_WRITE).

CR:746312

CR Number:   746312 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) 25 Sep 2013 Fixed 15.7 SP121 25 Sep 2013 Fixed 15.7 SP60 25 Sep 2013 Fixed 15.7 SP110 23 Sep 2013 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module mda_calc_proc_hdr_mem_KB() may be reported in the error log while querying the MDA table, monProcessProcedures. Workaround Description  Do not query monProcessProcedures.

CR:746317

CR Number:   746317 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UNIX Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RepAgent signal 11 and stack trace

CR:746330

CR Number:   746330 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) 15.7 SP60 15 Oct 2013 Fixed 07 Nov 2013 Fixed 14 Oct 2013 Reservation Made 15.7 SP121 28 Oct 2013 Fixed 29 Oct 2013 One-off Provided Description When sp_maplogin LDAP, NULL, 'create login' enables an authenticated LDAP user to create their own login and master database replication is enabled, the CREATE LOGIN statement on the replicate database gets error: "Message: 10331, State 2, Severity 14 -- 'Permission denied, database master, owner dbo. You need the following permission(s) to run this command: MANAGE ANY LOGIN. " The error is mapped to stop replication.

CR:746344

CR Number:   746344 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 Sep 2013 Fixed 15.7 SP121 16 Sep 2013 Fixed 15.7 SP60 17 Sep 2013 Fixed Description SAP ASE may hang when doing a disk mirror in some situations. The disk controller thread consumes 100% of the CPU utilization while the server hangs. Also, no new connections to the server can be established.

CR:746349

CR Number:   746349 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Windows W2k Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 06 Sep 2013 Fixed 11 Nov 2013 Bundled Request 11 Nov 2013 Bundled Request 12 Nov 2013 Fixed 15.7 SP60 11 Dec 2013 Fixed 17 Mar 2014 Bundled Request 11 Jun 2014 Fixed 13 Jun 2014 Port Not Needed Description Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature. Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE. The location and name can be changed using the Backup Server parameter -h. This feature failed when the connection to the backup server was through a named pipe.

CR:746367

CR Number:   746367 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) 29 Oct 2013 Fixed 17 Jan 2014 Added to user documentation Description monSpinlockActivity configuration option to decompose the aggregate data. Workaround Description  use the information from the sysmonitors table.

CR:746376

CR Number:   746376 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 09 Sep 2013 Fixed 15.7 SP110 09 Sep 2013 Fixed 09 Sep 2013 Fixed Description After shrinking database, DDLGen encounters the error message, "DDLGen started with the following .... Found 1 dbids with wrong number of rows cached in '#seginfo' v/s the rows in 'master.dbo.sysusages'".

CR:746378

CR Number:   746378 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guides - All Platforms Status:   Closed OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2013 Added to user documentation Description Doc CR: disable ldap before upgrade for install guides

CR:746437

CR Number:   746437 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) 27 Sep 2013 Added to user documentation Description Investigate if 753 traceflag can be changed to a sp_configure option.

CR:746438

CR Number:   746438 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Investigate if 753 traceflag can be changed to a sp_configure option.

CR:746442

CR Number:   746442 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   NA Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 06 Sep 2013 Fixed 11 Nov 2013 Fixed 15.7 SP60 12 Nov 2013 Fixed 13 Nov 2013 Fixed 01 Apr 2014 Already Fixed by Another CR 11 Jun 2014 Fixed Description Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature. Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE. The location and name can be changed using the Backup Server parameter -h. This feature failed when the connection to the backup server was through a AF_UNIX socket.

CR:746443

CR Number:   746443 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_sysmon to have a spinlockactivity section. Workaround Description  use the information from the sysmonitors table.

CR:746464

CR Number:   746464 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2013 One-off Provided 15.7 SP60 24 Sep 2013 Fixed 24 Sep 2013 Reservation Made 15.7 SP121 26 Sep 2013 Fixed 28 Feb 2014 One-off Provided 21 Nov 2013 Bundled Request Description Stored procedures using "execute as caller" with queries that call builtin function ISNULL() and create and query #temporary tables fail with error: Msg 208, Level 16, State 1: Server '<servername>', Line 26: <#temporary_table> not found. Workaround Description  create table "#T1" outside the proc: IF OBJECT_ID('#T1') IS NOT NULL BEGIN DROP TABLE #T1 IF OBJECT_ID('#T1') IS NOT NULL PRINT '<<< FAILED DROPPING TABLE #T1 >>>' ELSE PRINT '<<< DROPPED TABLE #T1 >>>' END CREATE TABLE #T1 ( colA int, colB char(8) ) Create procedure jProc01 with execute as caller as SELECT #T1.colA, convert(varchar(8) , isnull(jTab01.colB,'ABCD')) -- convert(varchar(8) , jTab01.colB) FROM #T1, jTab01 WHERE 1 = 2 return 0 go exec jProc01 go colA ----------- ---------------- (0 rows affected) (return status = 0)

CR:746475

CR Number:   746475 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) 15.7 SP121 13 Sep 2013 Fixed 12 Sep 2013 Reservation Made 15.7 SP110 13 Sep 2013 Fixed Description In an HADR configured server, "select * from monHADRMembers" may cause timeslice error like "timeslice -1001, current process infected at 0x15efbc4 (atomic_try+0x2)".

CR:746476

CR Number:   746476 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_poolconfig need enhancing to allow the wash size to revert to default bahviour

CR:746528

CR Number:   746528 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 23 Sep 2013 Fixed 15.7 SP121 17 Dec 2013 Fixed 09 Jan 2014 Fixed Description Killing a task which involves cursor or work tables might cause the server to hang, waiting for EX_LATCH on an allocation page on which EX_LATCH had been acquired by the same task before the 'kill' was issued on it. (A diagserver throws an 872 error).

CR:746562

CR Number:   746562 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 13 Sep 2013 Fixed Presently Not Targeted For Any Future Release Of This Product 15.7 SP110 13 Sep 2013 Fixed 15.7 SP103 18 Sep 2013 Fixed 15.7 SP121 04 Oct 2013 Fixed Description A trigger defined on MERGE statement executing both INSERT and UPDATE actions may return incorrect rows for inserted table for the INSERT action. This happens if the same trigger is defined for both INSERT and UPDATE: "create trigger T on TAB for insert,update as ..."

CR:746597

CR Number:   746597 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP51 09 Sep 2013 Fixed 15.7 SP103 11 Sep 2013 Fixed 15.7 SP51 10 Sep 2013 Fixed 15.7 SP51 10 Sep 2013 Fixed 12 Sep 2013 Presently Not Targeted For Any Future Release Of This Product 15.7 SP110 13 Sep 2013 Fixed 15.7 SP121 31 Oct 2013 Fixed 15.7 SP60 13 Sep 2013 Fixed 13 Sep 2013 Reservation Made Description In some cases an error may be reported in the SAP ASE errorlog, accompanied by a stack trace with the functions kbfalloc() and ptn__pdes_init_colupdcnt() in the stack.

CR:746601

CR Number:   746601 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 20 Oct 2013 Fixed 15.7 SP121 12 Dec 2013 Fixed 12 Dec 2013 Fixed Description When a table which is defined as compressed, and there is some fixed length column which is 'not null' and 'not materialized' in this table, update (index) statistics on this table may hit stack trace and SIGSEGV at decompress__column_by_colinfo().

CR:746614

CR Number:   746614 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 13 Sep 2013 Fixed 15.7 SP110 13 Sep 2013 Fixed 15.7 SP60 07 Oct 2013 Fixed Description INSERTs using normal page allocation running alongside operations using large-scale page allocation (LSA) scheme can overwrite the content put in by LSA operations in certain race circumstances between them.

CR:746620

CR Number:   746620 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 13 Sep 2013 Fixed 15.7 SP60 24 Sep 2013 Fixed 15.7 SP110 13 Sep 2013 Fixed Description A process can hang when executing ALTER DATABASE and DUMP DATABASE if another process goes to sleep when allocating a new page.

CR:746697

CR Number:   746697 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 SCC Arithmetic overflow on 3.2.8

CR:746736

CR Number:   746736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 11 Sep 2013 Fixed 15.7 SP60 11 Sep 2013 Fixed 11 Sep 2013 Fixed Description The text for error 9218 mistakenly stated sp_enable_rep_agent as opposed to sp_config_rep_agent in order to enable the Rep Agent for a given database.

CR:746741

CR Number:   746741 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 13 Sep 2013 Fixed 15.7 SP121 16 Sep 2013 Fixed Description Job Scheduler fails to schedule the job which does not specify end date and has the continuous_run property set. Workaround Description  Also set enddate with continuous_run property.

CR:746759

CR Number:   746759 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2014 Fixed Description New feature request to print trailer information from a dump archive. The new option is LOAD DATABASE <dbname> WITH LISTONLY=TRAILER.

CR:746820

CR Number:   746820 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) 15.7 SP121 12 Sep 2013 Fixed 11 Nov 2013 Fixed Description Online database will fail with the message 2778, "The object 'sysdams' is not a table. Update statistics can be used only on user tables or system tables" if a cross platform database dump from a lower version that requires upgrade is loaded.

CR:746826

CR Number:   746826 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 Jan 2014 Fixed Description A 9950 error, "Workspace '<name>' is incorrectly allocated. Use sp_dbcc_createws to create a new workspace." may be reported when running DBCC CHECKSTORAGE. Workaround Description  delete the related workspace and recreate one, or configure another new related workspace for the database, or update the statistics for the related workspace.

CR:746827

CR Number:   746827 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 The monitoring table monRepSenders has been enhanced with information such as counters for the number of bytes sent and number of commands processed with information that is useful for a single-task Rep Agent. Workaround Description  n/a

CR:746850

CR Number:   746850 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description High fowarded row count for some big expand UPDATE transaction on 15.0.3 ESD4 and 15.7 SPxx ASE. No forwarded row if update one row per transaction.

CR:746994

CR Number:   746994 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 27 Sep 2013 Fixed 15.7 SP60 07 Oct 2013 Fixed 15.7 SP121 29 Sep 2013 Fixed Description The DISK REMIRROR command hangs after simulating a disk I/O error on a mirrored device.

CR:747043

CR Number:   747043 Product Name:   SCC Web Framework Product Component:   Other Status:   Closed OS:   RH Linux Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2013 Fixed 26 Sep 2013 Fixed 01 Oct 2013 Fixed Description Fixes issue related to automatic generation of heapdump which is required in support cases to help triage issue

CR:747046

CR Number:   747046 Product Name:   Adaptive Server Enterprise Product Component:   ODATA Provider Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2014 Fixed Description The odata metadata query shows precision=0 and scale=0 for money, smallmoney, datetime, bigdatetime, time data types. The values are now displayed correctly following the code change.

CR:747071

CR Number:   747071 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2013 One-off Provided 21 Oct 2013 One-off Provided 28 Oct 2013 One-off Provided 03 Oct 2014 Port Not Needed Description EBF21805: Provide one-off for CR 735346,737108,743270,743676

CR:747089

CR Number:   747089 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 16 Jan 2014 Fixed 16.0 18 Jan 2014 Fixed Description When Rep Agent is configured for 'stream replication' and sync or near sync stream mode, two user tasks running in parallel DML and DDL on the same table may lead to hang one of the user tasks and Rep Agent waiting each other till the 'max commit wait' is reached. Rep Agent will then switch to asynchronous mode.

CR:747092

CR Number:   747092 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 18 Nov 2013 Fixed Description When using syconfig to upgrade backup server 12.5.4 to 15.7, the character set in configure backup server dialog is empty.

CR:747100

CR Number:   747100 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 SP121 31 Oct 2013 Fixed 16.0 29 Nov 2013 Fixed Description In rare circumstances the message "WARNING: memory usage in procedure headers (...) does not match memory usage count in Pss (...) for server process id ..." may be reported in the error log when the configuration options "enable functionality group" and "plan sharing" are active and the execution of a prepared statement is interrupted due to an error that caused the current transaction to be aborted.

CR:747110

CR Number:   747110 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 Add step to preupgrade to check the configuration option 'user log cache size' is sufficient for using buffer unpinning optimization in the ASE 16.0 server.

CR:747158

CR Number:   747158 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 Jan 2014 Bundled Request Description In a jConnect application with DYNAMIC_PREPARE set to true, auditing of DML statements doesn't print the correct parameter values when the same cursor is closed and opened again.

CR:747168

CR Number:   747168 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) 28 Jan 2014 Fixed 25 Feb 2014 Fixed 15.7 SP111 28 Feb 2014 Fixed 15.7 SP121 26 Feb 2014 Fixed 16.0 GA PL01 05 Mar 2014 Fixed Description A 702 error, "Memory request for NN bytes exceeds the size of single page of 16384 bytes. ASE is terminating this process", may be reported when using queries with tables that have more than 4192 partitions. Workaround Description  Use fewer than 4192 partitions per table.

CR:747170

CR Number:   747170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description request to add Traceflag 7786 functionality as an sp_configure option