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

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

CR:738633

CR Number:   738633 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 SP110 14 Jun 2013 Fixed 15.7 SP101 10 May 2013 Fixed Description RepAgent may run out of memory and shutdown if started and stopped a large number of times. Workaround Description  Increase the RAT memory configuration parameter using: sp_configure 'replication agent memory size', <size>.

CR:738655

CR Number:   738655 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP101 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 06 Jun 2013 Fixed Description Inappropriate right truncation error is raised when long BINARY values at or near the full width of a long column are inserted via dynamic SQL prepared statement.

CR:738675

CR Number:   738675 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 09 May 2013 Fixed 15.7 SP101 09 May 2013 Fixed 15.7 SP60 30 Oct 2013 Fixed Description Database device remapping is disabled when a database is loaded with VERIFY.

CR:738692

CR Number:   738692 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 SP110 18 Jun 2013 Fixed 17 Jun 2013 Reservation Made 15.7 SP50 18 Jun 2013 Fixed Description When a query involves multiple subqueries under, and the final plan places the subquery JOIN operator at the top of the plan, then there a much better plan that may be skipped. Optcriteria cr738692 will turn on the fix. Workaround Description  Turning off the avoid_bmo_sorts optcriteria and/or conserve_tempdb_space may force the correct plan.

CR:738710

CR Number:   738710 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 SP110 09 May 2013 Fixed 15.7 SP101 09 May 2013 Fixed 15.7 SP50 10 May 2013 Fixed Description A Fault Type Error 100008, "Fixed format error", may be reported by DBCC CHECKSTORAGE if DBCC CHECKDB or DBCC CHECKTABLE is run on a database/table which contains variable length columns previously.

CR:738731

CR Number:   738731 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 SP110 05 Jun 2013 Fixed Description An 806 error, "Could not find virtual page for logical page <page_id> in database <db_name>", may be reported when executing DBCC CHECKTABLE/CHECKINDEX/CHECKDB/REINDEX after shrinking a database containing a table with suspect index. Workaround Description  rebuild suspect index using DBCC REINDEX or REOGR REBUILD after shrinking database.

CR:738733

CR Number:   738733 Product Name:   Adaptive Server Enterprise Product Component:   Component Drop Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2013 Fixed Description This PC-Client SP is based on SDK 15.7 SP100. A list of changes in SDK 15.7 SP100 is available at http://download.sybase.com/swr/16980/EBF21006_README.html

CR:738744

CR Number:   738744 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) 15.7 SP101 08 May 2013 Fixed 15.7 SP110 16 May 2013 Fixed Description The message, "Error: sdt_getpage: Attempt to read page '0' but device <device_name> is not open. Exiting", is reported when a cumulative dump is used as a metadata file for sybdumptran.

CR:738747

CR Number:   738747 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 May 2013 Insufficient priority to fix Description select * into to support create of the primery key.

CR:738758

CR Number:   738758 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 04 Jun 2013 Fixed 15.7 SP110 02 Jul 2013 Fixed 21 Jun 2013 One-off Provided 10 Oct 2013 One-off Provided 21 Oct 2013 One-off Provided 10 Mar 2014 One-off Provided 24 Jul 2014 Fixed Description A CIS spid in a 'terminating' state might hang at times in the usctconnect() function as observed in the DBCC STACKTRACE(spid) output.

CR:738771

CR Number:   738771 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2013 Fixed 15.7 SP50 18 Jun 2013 Fixed 15.7 SP110 27 Jun 2013 Fixed 14 Jun 2013 Reservation Made Description Under rare circumstances, a 12313 error, "Internal error: Insert into page id <pageno> of index id <indid> of table 'sysobjects' (id= 1) in database '<dbname>' tried to replace undeleted RID (<pageid>,<rownum>) at slot <slotnum> and ridposn <ridposn>. Try dropping and recreating the index." may be reported while loading a transaction log dump after onlining the database with STANDBY_ACCESS mode. The fix provides trace flag 3170 to bypass this error. Please turn on trace flag 3170 and reload the dump sequence. Workaround Description  N/A

CR:738777

CR Number:   738777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 20 May 2013 Fixed 20 May 2013 Reservation Made 15.7 SP110 06 Jun 2013 Fixed Description ASE will now no longer cache INSERT VALUES statements that has LOB literals exceeding 16k size. Workaround Description  create table test (a int, b image) declare @var image select @var = <some value greater than 16K> insert test values (1, @var)

CR:738785

CR Number:   738785 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 using ANSI JOINS between VIEWS on PROXY TABLES returns some rows of the result set and then raises error 207 "invalid column name".

CR:738790

CR Number:   738790 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) 15.7 SP60 29 Jul 2013 Fixed 15.7 SP121 22 Aug 2013 Fixed 29 Nov 2013 Fixed Description Some user queries might cause segmentation fault with signal 11 when auditing and compatibility mode options are turned on. Workaround Description  If we make any of the following changes the SQL ran without an issue * disable compatibility mode * disable auditing * remove the "order by name" from the SQL * remove the "exec" wrapper from the SQL

CR:738792

CR Number:   738792 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 SP110 20 May 2013 Fixed 15.7 SP101 10 May 2013 Fixed Description If an ODBC or JDBC client enables one or both of HADR_MAP and HADR_NOKILL capabilities, different message text for same error codes is seen in case of HADR errors.

CR:738849

CR Number:   738849 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) 24 May 2013 Not a Bug Description ASE cannot store UTF-8 strings of char_length(N) in a varchar(N) columns. Workaround Description  When create table varchar(N) do N * 4.

CR:738852

CR Number:   738852 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 A way of "set string_rtruncation on" default server wide. Workaround Description  use a Global login trugger with "set string_rtruncation on"

CR:738884

CR Number:   738884 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 Stored procedures using "execute as caller" with builtin functions may attempt to access objects that do NOT belong to the caller (but do belong to the procedure owner). Workaround Description  None known.

CR:738952

CR Number:   738952 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 PL3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2013 Fixed 15.7 SP50 07 Jun 2013 Fixed 15.7 SP110 10 Jun 2013 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the modules s_compile() and s_recompile() when a stored procedure is renormalized and phdr_nondiskres is set for the proc_hdr.

CR:739014

CR Number:   739014 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2013 One-off Provided 15.7 SP50 26 May 2013 Fixed 15.7 SP110 29 May 2013 Fixed Description ASE Cluster Edition fails to boot when using EMC devices. A truss on AIX or Solaris will show repeated ioctl system calls. This issue only affects ASE Cluster Edition.

CR:739040

CR Number:   739040 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 SP110 14 Jul 2013 Fixed Description In rare circumstances, for APL table with both clustered index and non-clustered indexes which are created on a shared disk cluster ASE server, INSERT task may not respond even if it is cancelled (by CTRL C) when run with concurrent INSERT tasks. Meanwhile, lots of 1205 error messages, "Your server command (family id <value>, process id <value>) encountered a deadlock situation. Please re-run your command", will also be seen in the error log.

CR:739067

CR Number:   739067 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 May 2013 Bundled Request 28 May 2013 Bundled Request Description ASE will fail to startup if I/O fencing is enabled on devices with virtual uplinks. This issue only affects ASE Cluster Edition.

CR:739074

CR Number:   739074 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.7 SP60 29 Aug 2013 Fixed 15.7 SP110 15 Aug 2013 Fixed 15.7 SP121 31 Oct 2013 Fixed 15 Aug 2013 Fixed Description In some scenarios, a database in single user mode could be used by a user session that is not expected to be using the database. Workaround Description  Disable per process dbtable cache with traceflag 12315.

CR:739077

CR Number:   739077 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 08 May 2013 Fixed Description sp_showoptstats does not correctly display the derived statistics message. A derived statistics tag is now added to sp_showoptstats. <statParDer>true</statParDer> will be displayed when histogram statistics are derived from underlying partition statistics.

CR:739079

CR Number:   739079 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) 15.7 SP110 09 May 2013 Fixed 15.7 SP101 09 May 2013 Fixed 17 May 2013 Added to user documentation Description If any of the system databases is > 2GB, the Update Adaptive Server in the installer or $SYBASE/ASE-15_0/bin/updatease (%SYBASE%\ASE-15_0\bin\updatease.exe on Windows) utility will fail with "Arithmetic overflow occurred." error. Workaround Description  Run updatease with -k argument. This argument makes updatease to skip the space check.

CR:739080

CR Number:   739080 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 10 May 2013 Fixed 15.7 SP101 10 May 2013 Fixed Description The show_condensed_text built-in function returns a NULL value for queries in the statement cache when the 'enable literal autoparam' configuration parameter is enabled.

CR:739129

CR Number:   739129 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 06 Jun 2013 Fixed 15.7 SP110 10 Jun 2013 Fixed 12 Jun 2013 Fixed Description For a share disk cluster database with tables having identity column, the Error 2601, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'", may be encountered when executing DUMP DATABASE or REORG REBUILD TABLE if nodes leave and re-join the cluster. If the cluster is killed, the old identity values may also be generated. Workaround Description  For the tables encountered error 2601 due to identity values, customer can fix it by 1. delete corresponding rows with class=33 for the table in sysattributes 2. dbcc cacheremove, this will remove the des from cache, and force flush identity to sysattributes. 3. delete corresponding rows with class=33 for the table in sysattributes again. This will ensure that we don't keep a out dated identity in sysattributes. 4. dump, reorg rebuild, insert will be fine. New identity set will be allocated according to sysobjects.identburnmax. We just lost some identity values.

CR:739163

CR Number:   739163 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Open OS:   Solaris 11 Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Selecting unitext data that contains 'illegal byte sequences' can cause client connections to fail with "There is a tds protocol error. An illegal token was received." Workaround Description  Disable 'surrogate processing': sp_configure 'enable surrogate processing', 0

CR:739220

CR Number:   739220 Product Name:   Adaptive Server Generic Docs Product Component:   Adaptive Server New Features Guide Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2013 Added to user documentation Description Job Scheduler does not run any job at a low priority by default. User need to set priorities to jobs by logical process management.

CR:739222

CR Number:   739222 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP101 10 May 2013 Fixed 15.7 SP110 10 May 2013 Fixed 16 Aug 2013 Bundled Request Description ASE may report a 12062 error that the operation stack has overflowed when "execution time monitoring" is on.

CR:739288

CR Number:   739288 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 SP110 15 May 2013 Fixed 15.7 SP101 10 May 2013 Fixed 15.7 SP50 13 Jun 2013 Fixed Description The message, "Current process infected with signal 11" followed by a stack trace that includes the module ktMuxThreadGetSchedQ() may reported during shutdown and may not lead to a complete ASE shutdown.

CR:739291

CR Number:   739291 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2014 Duplicate Description In rare circumstances, No any processes work on a database and its dbt_keep may be greater than 1. Workaround Description  Disable per process dbtable cache with traceflag 12315.

CR:739299

CR Number:   739299 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 SP110 17 May 2013 Fixed Description When the example stored procedure sp_extrapwdchecks from Adaptive Server documentation is created in master database to perform additional password checking and password history maintenance, a new row is incorrectly inserted into the password history table with a value of null for the column name when the password change is done by a different user with role sso_role or Granular Permission privilege manage any login.

CR:739315

CR Number:   739315 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 SP110 01 Jul 2013 Fixed Description A non-privileged connection to primary with HADR_MAP capability enabled gets killed after primary is deactivated without any error message.

CR:739334

CR Number:   739334 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2013 Added to user documentation Description System Administration Guide Volume 2 mentions about the message "Number of proc buffers allocated: xxxx" that ASE does not output anymore.

CR:739363

CR Number:   739363 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP110 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2013 Fixed 15.7 SP110 27 May 2013 Fixed 27 May 2013 Reservation Made Description An undetected deadlock may occur between DUMP DATABASE and other tasks trying to reserve space in syslogs.

CR:739377

CR Number:   739377 Product Name:   ASE Management Product Component:   Web Console Status:   Open OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SCC Feature Request: able to create custom alerts in SCC

CR:739469

CR Number:   739469 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) 09 Oct 2013 Fixed 09 May 2014 DEFER 09 May 2014 Already Fixed by Another CR Description When a merge statement inserts a new record into a table with an identity column, the identity column will be populated with correct value but the global variable @@identity will remain unchanged. Workaround Description  None really, but dependant on how @@identity is used in the logic, may be able to use next_identity ("<table>")

CR:739473

CR Number:   739473 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 Feature request to have various severity 17 errors that are normally only sent to the client reported by the errorlog by default. This can currently be accomplished on a message by message basis with sp_altermessage, but a more universal or default setting is desired.

CR:739477

CR Number:   739477 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 14 May 2013 Fixed 15.7 SP50 14 Jun 2013 Fixed Description If HASH based statistics gathering is used during an UPDATE STATISTICS or a CREATE INDEX statement, then there may be a failure if the respective column contains the next to lowest value of the domain but not the lowest value of the domain. The statement may be aborted. e.g. if the column is an unsigned integer then 1 is the next to lowest value and if the column contains a 1 but not a 0, then the statement may be aborted. Workaround Description  avoid using the hashing option when gathering statistics.

CR:739482

CR Number:   739482 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) 10 Jun 2014 Insufficient priority to fix Description Include entries to the dump history file for external dumps.

CR:739486

CR Number:   739486 Product Name:   ASE Management Product Component:   Monitoring Agent Plugin Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2013 Fixed 22 Oct 2013 Fixed Description Error 209 reported while displaying Devices and Engines view of ASE monitoring view when the monitored ASE is set up with case-insensitive sort order.

CR:739497

CR Number:   739497 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 14 May 2013 Fixed Description Inaccurate histograms can be created when the unique value count of the column exceeds 65535 unique values.

CR:739529

CR Number:   739529 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) 15.7 SP50 03 Jun 2013 Fixed 17 Jun 2013 Fixed 15.7 SP110 19 Jun 2013 Fixed Description ASE logs the message, "Expected object passed to utGetThid is not of type thread", repeatedly. Workaround Description  Shutdown and restart the ASE.

CR:739531

CR Number:   739531 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 SP110 12 Jul 2013 Fixed 20 Feb 2014 Fixed Description DBCC HELP(PAGE) does not display the correct usage of the parameter 'logical'.

CR:739568

CR Number:   739568 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 SP50 21 May 2013 Fixed 15.7 SP110 10 Jun 2013 Fixed Description The message, "Current process infected with 11", followed by a stack trace which includes the modules lwp_create() and freeprocs() may be reported in the error log when a cached statement is normalized which can lead to other ASE tasks to wait indefinitely on the statement cache pool semaphore acquisition.

CR:739572

CR Number:   739572 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 SP101 15 May 2013 Fixed 15.7 SP110 20 May 2013 Fixed Description On Windows 2008 R2 platform, ASE HA may fail to create Sybase Companion Server. "sp_companion configure" fails with message "HA Config Error: Unable to write cluster resource properties for ASE server '<name>' (operating system error 183)." Workaround Description  NO WORKAROUND. This is a problem which may occur on some systems but not others depending on the local environment, but there is no specific way of 'configuring around' the problem. However it only affects configuration of a new companion server, any pre-existing HA companion server is not affected by this bug.

CR:739578

CR Number:   739578 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 14 May 2013 Fixed 15.7 SP50 12 Jun 2013 Fixed Description If a column has more than 65535 unique values then UPDATE STATISTICS or CREATE INDEX with HASH based statistics gathering may result in an out of order boundary value in the first few cells of the histogram.

CR:739611

CR Number:   739611 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2013 Fixed 30 Aug 2013 Added to user documentation Description Add option to append results in text mode.

CR:739656

CR Number:   739656 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2013 Fixed 15.7 SP110 03 Jul 2013 Fixed Description Running REORG DEFRAG from the same session multiple times might eventually cause a 705 error, "There is no room for process <spid> to store PROC_HDR <address> in Pss. ASE is terminating this process". Also, every run of REORG DEFRAG throws a noisy warning, "WARNING: memory usage in procedure headers (n) does not match memory usage count in Pss (m) for server process id <spid>"

CR:739664

CR Number:   739664 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 IT Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 20 May 2013 Fixed 15.7 SP110 21 May 2013 Fixed 15.7 SP101 22 May 2013 Fixed 03 Jun 2013 One-off Provided Description Queries with OUTER JOIN and a reference to syscomments.text can get wrong results when "select on syscomments.text" is set to 0.

CR:739678

CR Number:   739678 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 20 May 2013 Fixed 15.7 SP110 22 May 2013 Fixed Description Generating DDL for a table using DDLGen does not generate DDL for indexes which have been created with sorted_data option.

CR:739679

CR Number:   739679 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) 15.7 SP110 28 Jun 2013 Fixed 02 Aug 2013 Presently Not Targeted For Any Future Release Of This Product 26 Jun 2013 Reservation Made Description Enable usage of subqueries in the SELECT with FOR UPDATE clause under global switch 7791.

CR:739710

CR Number:   739710 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined 24 Jun 2013 Fixed Description ASE running in process kernel mode (pre 15.7 or 15.7 and above process kernel mode) may encounter issues like Error 14130 when an engine is onlined after some licensed feature is enabled. Workaround Description  It should be possible to disable and re-enable the licensed feature in order to get all currently on-lined engines synched up to the correct state. E.g. sp_configure 'enable semantic partitioning', 0 sp_configure 'enable semantic partitioning', 1

CR:739725

CR Number:   739725 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 30 May 2013 Fixed Description sp_configure 'dump history filename' may return an incorrect filename on a Windows environment when a dump history filename has '\' characters specified and after an ASE restart. For example, dump history file 'D:\sybase\dumphist' would be returned as 'D:sybasedumphist' mistakenly.

CR:739735

CR Number:   739735 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 26 May 2013 Fixed 15.7 SP110 26 May 2013 Fixed Description Hard fault 100007 (extent id error) may be reported by sp_dbcc_faultreport if DBCC CHECKSTORAGE is run with frequent DDL commands.

CR:739736

CR Number:   739736 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 SP101 19 May 2013 Fixed 15.7 SP110 26 Jun 2013 Fixed Description A 12319 error, "Fatal internal error encountered during deferred dml on table <tabname> in database <dbname>. All rows that qualified during the first phase were not visited during second phase of dml" may be reported followed by a stack trace that includes the modules dol_def_update() and dodeferred() when running CREATE INDEX or REORG REBUILD with ONLINE option with concurrent DMLs on hot objects.

CR:739773

CR Number:   739773 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The LOAD DATABASE WITH LISTONLY=LOAD_SQL may generate some load commands which, if executed, may require manually altering the target database for the load to succeed, in cases where an ALTER DATABASE OFF command was run at some time when the sequence of dumps was created on the source database

CR:739784

CR Number:   739784 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 31 Jul 2013 Fixed 15.7 SP110 01 Aug 2013 Fixed Description If a table is altered and is present in an UNION query in a derived table which is further defined in a VIEW, it could lead to permission denied errors.

CR:739820

CR Number:   739820 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 24 May 2013 Fixed 21 May 2013 Reservation Made Description Inaccurate overly optimistic cluster ratios could result when executing a parallel create index. This could lead to inaccurate index selection in the query plan. After the first UPDATE STATISTICS command on this new index, the cluster ratios will be corrected and plan selection should be more accurate. Optcriteria CR739820 enables the change to improve the accuracy of the cluster ratios during parallel create index Workaround Description  use update statistics to correct the inaccurate cluster ratios

CR:739930

CR Number:   739930 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 check for incorrect status bits in the TIPSA structure of text and image values.

CR:739932

CR Number:   739932 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 20 May 2013 Fixed 15.7 SP60 10 Jul 2013 Fixed Description The optimizer estimates involving columns defined as BIGDATETIME and BIGTIME types may be suboptimial.

CR:740006

CR Number:   740006 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2013 Presently Not Targeted For Any Future Release Of This Product Description Trailing comments are stripped at the DBISQL application level and not sent to ASE. This is not the case with isql.

CR:740018

CR Number:   740018 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) 15.7 SP110 29 May 2013 Fixed Description An incorrect negative value may be reported in the error message, "A system call has not responded for x seconds".

CR:740020

CR Number:   740020 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Jul 2013 Fixed 15.7 SP110 03 Jul 2013 Fixed 09 Sep 2013 Fixed Description Under rare circumstances on Windows NT 64-bit platform ASE may stop with no errors being reported while processing Web Services requests that involve the execution of Java code. Workaround Description  For windows only, you need to set the environment variable SYBASE_PCI_DISABLE_DISPATCH_MEMORY=Y before starting ASE. Notice that the message below will be displayed to the console. For disabled PCI memory interception this mesage can be ignored i.e. there is no security risk there. ************SECURITY WARNING************** function dispatching disabled for debug purposes security of libraries running under PCI (for example external JVM) cannot be guaranteed ******************************************

CR:740031

CR Number:   740031 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 21 May 2013 Fixed 15.7 SP50 12 Jun 2013 Fixed Description If a high domain column (greater than 65535 unique values) has a histogram created by using the HASH based algorithm, then it is possible that an inconsistent histogram could be created if there are some skew values in the histogram. Workaround Description  gather statistics using the sort based statistics gathering algorithm.

CR:740045

CR Number:   740045 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 When failover occurs, a message "Database 'database name' appears to be in the process of being loaded; ASE will not bring it online automatically. Use the ONLINE DATABASE command to bring this database online." appears and the database becomes offline. Workaround Description  Bring the database online manually.

CR:740079

CR Number:   740079 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2014 Fixed 16 Apr 2014 Reservation Made 09 May 2014 Fixed Description Log the full sql text of the string passed to execute immediate in the monSysSQLText table. This is only available when traceflag 8391 is enabled.

CR:740115

CR Number:   740115 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP101 24 May 2013 Fixed 15.7 SP110 26 May 2013 Fixed Description "sp_hadr_admin status, 'anyvalue'" fails when executed on standby HADR server when quoted_identifier is on.

CR:740137

CR Number:   740137 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 21 May 2013 Fixed 28 Mar 2014 Fixed Description The message, "Current process infected with signal 11" (SIGSEGV), followed by a stack trace that includes the module stu_get_next_active_hist_slot() may be reported in the SAP ASE error log when using HASH based statistics gathering and the column has more than 65535 unique values. Workaround Description  If this problem occurs then use sort based statistics gathering for this column

CR:740148

CR Number:   740148 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) 12 Jul 2013 Fixed 12 Aug 2013 DEFER Description If an object name (such as a table) contained a parenthesis (as could be possible when using quoted identifiers), any SQL text for a statement using that object name would not be stored in the statement cache.

CR:740195

CR Number:   740195 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2013 Work as design Description The error Backup Server: 5.3.2.1: Cannot open a connection to the slave site will be raised when trying to execute a DUMP command using a remote backup server, if either the remote backup server has been booted with a different name as the one used in the dump command, or if the name used in the local server is different and this name is not in the remote backup server interfaces file. Workaround Description  1) Add the remote_server name used in the AT <remote_server> to the remote backup server interfaces file OR/AND 2) Boot the remote backup server with the same 'remote_server' name used in the local server.

CR:740213

CR Number:   740213 Product Name:   ASE Management Product Component:   sybrestore Status:   Closed OS:   Generic Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2013 Fixed Description Sybrestore requires login of system administrator with its default database in master database in order to successfully load the database. In other words, sybrestore will fail to load a database if the default database of the login is not master database.

CR:740221

CR Number:   740221 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Sep 2013 Fixed 20 Aug 2013 One-off Provided 15.7 SP121 05 Sep 2013 Fixed 15.7 SP110 05 Sep 2013 Fixed 07 Nov 2013 One-off Provided Description Under heavy network load, SAP ASE on the Windows platform may hang.

CR:740223

CR Number:   740223 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 29 May 2013 Fixed 15.7 SP110 03 Jun 2013 Fixed Description Job Scheduler can fail to execute jobs for users with high SUIDs.

CR:740247

CR Number:   740247 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 SP110 12 Jun 2013 Fixed 15.7 SP102 17 Jun 2013 Fixed Description Under some rare circumstances, a shrink-database operation can encounter errors that kill the processing thread but do not clean up the memory it was using.

CR:740262

CR Number:   740262 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2013 Fixed 06 Sep 2013 Fixed 06 Sep 2013 Reservation Made Description Full text not being audited for DML when option update/select/insert/delete is turned on. Parameter values are also not printed for local variables and dynamic prepare statements.

CR:740317

CR Number:   740317 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) 27 Nov 2013 Fixed 15.7 SP121 20 Oct 2013 Fixed 20 Oct 2013 Reservation Made 15.7 SP121 31 Oct 2013 Fixed 04 May 2014 Reservation Made 04 May 2014 Fixed Description UPDATE skip uncommitted insert row caused ABAP like below output unexpected error message. (pseudo code) UPDATE row if (no rows found) INSERT row if (duplicate key) UPDATE row if (no rows found) ERROR out (assumption this should not be possible) The new feature is enabled when the new configure option "donot skip uncommitted insert" is set as 1.

CR:740321

CR Number:   740321 Product Name:   Adaptive Server Enterprise Product Component:   ODATA Provider Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP120 18 Sep 2013 Fixed 19 Jan 2014 Port Not Needed Description ODATA provider uses JDBC connection string from a configuration file. End users may add their Jconnect parameters and values to this connection string. The connection string is manipulated by the odata producer to add certain required parameters for its correct operation before adding user supplied parameters to it.

CR:740322

CR Number:   740322 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2013 Duplicate 24 Sep 2013 Duplicate Description Multiple spurious errors are reported for load with verifyonly = full. The dump is valid and does not contain any errors.

CR:740341

CR Number:   740341 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description dbcc upgrade_object a procedure got Msg 208 when there is a temp table outside of the SP.

CR:740364

CR Number:   740364 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2013 One-off Provided 15.7 SP110 07 Jun 2013 Fixed 15.7 SP50 13 Jun 2013 Fixed Description Sometimes a read for non-syslogs object on a stale syslogs page for a user tempdb may results in 692 error.

CR:740410

CR Number:   740410 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) 29 May 2013 Fixed 15.7 SP110 29 May 2013 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module aud_getsdes() may be reported in the error log when opening cursors declared without user tables when auditing is turned on.

CR:740471

CR Number:   740471 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 SP110 28 May 2013 Fixed 15.7 SP60 07 Jul 2013 Fixed Description The loginfo() built-in may return wrong values for parameters 'can_free_using_dump_tran', 'oldest_active_transaction_pct', 'stp_span_pct' for databases having mixed log and data segments.

CR:740479

CR Number:   740479 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) 15.7 SP110 28 May 2013 Fixed Description A 9633 error, "RepAgent(<dbid>): Cannot authenticate Replication Server <RS_nname> to use multiple replication paths", may be reported when the RepAgent is configured for Multiple Paths Replication i.e. 'max number replication paths' is greater than 1 and 'multithread rep agent' is reset to false, preventing RepAgent from starting. This can be corrected by setting 'max number replication paths' to zero. Workaround Description  When MPR is not used anymore by resetting 'multithread rep agent' to false, 'max number replication paths' needs to be reset to 0.

CR:740499

CR Number:   740499 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 SP110 17 Jun 2013 Fixed Description When HADR feature is enabled in ASE, internally spawned user spid would get killed during deactivation of the Primary server. Also these spids will not be able to start a transaction on a Standby server.

CR:740512

CR Number:   740512 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 10 Jun 2013 Fixed Description DELETEs or UPDATEs doing a table scan on a DOL table following an INSERT-BULK performed in a multi-statement transaction may sometimes not qualify all rows, and the DELETE / UPDATE may leave some qualifying rows unaffected. This is most likely to occur when the affected table is bound to a very small cache, usually of the minimum size. Workaround Description  Increase the cache size that the target table of the insert-bulk is bound to. Deletes / updates using an index access are unaffected, so avoiding the table scan for the DML by providing some search arguments on index key columns, or by forcing an index scan, will also avoid this problem.

CR:740529

CR Number:   740529 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 SP110 17 Jul 2013 Fixed Description The format for the Object_status column output of "sp_help <tablename>" may have a missing comma.

CR:740567

CR Number:   740567 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Configuration Guides - All Platforms Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2013 Added to user documentation Description Documentation enhancment request to document that as of 15.0.2 there is no longer a hard limit on the number of items in an IN clause. The limit is now limited by available procedure cache.

CR:740568

CR Number:   740568 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   UNIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 18 Jun 2013 Fixed 15.7 SP110 28 Jun 2013 Fixed 28 Jun 2013 One-off Provided Description When MERGE JOIN is turned off, a SELECT query joining a local and proxy column with a search using an IN list will not return the correct result. Currently, traceflag 16976 provides the workaround to the problem. Workaround Description  traceflag 16976 or set merge_join on

CR:740576

CR Number:   740576 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 SP110 30 May 2013 Fixed 15.7 SP102 16 Jun 2013 Fixed Description Under some rare circumstances, a shrink-database operation can encounter errors of index not consistent on DOL table.

CR:740597

CR Number:   740597 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) 15.7 SP110 31 May 2013 Fixed 15.7 SP102 14 Jun 2013 Fixed Description When RepAgent terminates abnormally with an error while connecting to Replication Server, the connection is not closed and the associated session is still held on Replication Server mistakenly.

CR:740609

CR Number:   740609 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 SP110 29 May 2013 Fixed 15.7 SP101 05 Jun 2013 Fixed Description In an HADR environment, the privileged connection (to the old primary) with info capabilities gets killed upon activation of the new primary server. Workaround Description  Disable the info capabilities (DR_MAP and DR_NOKILL) for the connection. But note that with this the client will not receive the info messages.

CR:740613

CR Number:   740613 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) 15.7 SP50 30 May 2013 Fixed 16.0 06 Jun 2013 Fixed 15.7 SP101 04 Jun 2013 Fixed 18 Jun 2013 Presently Not Targeted For Any Future Release Of This Product 23 Sep 2013 One-off Provided Description LOAD TRANSACTION of a transaction dump involving the log records of materialization of an indexed table with 'deferred allocation' property may fail with the 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #=x, object id = y, page timestamp=z. Log old timestamp=a. Log record marker =(p, q)."

CR:740635

CR Number:   740635 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) 26 Mar 2014 Fixed 07 May 2014 Fixed 07 May 2014 Fixed Description In rare circumstances, when running TRUNCATE TABLE on a very large table, the table does not show up on monProcessObject.

CR:740711

CR Number:   740711 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 SP101 06 Jun 2013 Fixed 15.7 SP110 06 Jun 2013 Fixed Description A 9284 error, "RepAgent(<dbid>). Cannot allocate 9024 bytes of memory. You may need to reconfigure the parameter 'replication agent memory size' with more memory." may be reported when LOB off-row data is replicated, resulting in the Rep Agent Thread for this database to be terminated abnormally. Workaround Description  Increase via sp_configure the option 'replication agent memory size'.

CR:740722

CR Number:   740722 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2013 Bundled Request Description When encountered a charset-mis-match error while connecting to an ASE (e.g. an HP ASE server), DBISQL 16 internally switches to use utf8 to re-connect. Previously iso_1 was used.

CR:740730

CR Number:   740730 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) 15.7 SP50 19 Jun 2013 Fixed 15.7 SP110 20 Jun 2013 Fixed 25 Jun 2013 One-off Provided 13 May 2014 One-off Provided Description The 1514 error, "Sort failed because it attempted to allocate page <page> and found that the page was busy. Buffer <buffer> contains a cached and referenced page with ptnid <ptnid> indid <indid> and status <status>", may be reported when executing a subquery plan and there is a StoreIndex(reformatting) operator under the subquery.

CR:740732

CR Number:   740732 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 07 Jun 2013 Fixed 15.7 SP102 14 Jun 2013 Fixed Description If a database is configured to 'allow incremental dumps' updates to pages that happen when bringing the database online could be missing from the next incremental dump. Workaround Description  N/A

CR:740741

CR Number:   740741 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) 15.7 SP110 04 Jun 2013 Fixed Description Using DDLGen to extract CREATE DATABASE DDL fails when the database name is greater than 23 characters and the "-F" option is used. Workaround Description  Change @procname varchar(45) to varchar(60) in below system stored procedures workaround the issue. create procedure dbo.sp_ddlgen_permissions( @objtype varchar(30) , @objname varchar(30) ) as begin -- { declare @is_dbo int , @procname varchar(45) , @lcl_sarole int