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

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

CR:762909

CR Number:   762909 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2014 Fixed 09 May 2014 Fixed 09 May 2014 Fixed Description sp_showoptstats will have poor performance if a large number of partitions are defined and/or a large number of columns have histograms defined. Workaround Description  - use optdiag to gather statistics on the table. - gather statistics on individual columns with sp_showoptstats rather than the entire table.

CR:762959

CR Number:   762959 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2014 Fixed 07 May 2014 Fixed 08 May 2014 Fixed Description DDLGen terminates when the SAP ASE configuration option 'quoted identifier enhancements' is off.

CR:762960

CR Number:   762960 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2014 Fixed 06 May 2014 Fixed 08 May 2014 Fixed 07 May 2014 Fixed 23 May 2014 One-off Provided Description When permission on built-in function is granted to a role which is granted to a user, then executing the built-in function may result in permission error.

CR:763023

CR Number:   763023 Product Name:   Adaptive Server Generic Docs Product Component:   Security Administration Guide Status:   Closed OS:   all Original Version:   16.0 sp03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2014 Fixed Description The following external authentication methods require SAP ASE security and directory services license, this requirement should documented in Security Administration Guide. -Kerberos -LDAP user authentication -PAM user authentication

CR:763128

CR Number:   763128 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 SP01 PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2014 Fixed 15 May 2014 Fixed Description When RepAgent is in skip mode and meta-data reduction is enabled, if the last log record processed by Replication Server before entering skip mode is a ROWIMAGE log record that contains in-row LOB data, RepAgent may generate timeslice errors.

CR:763129

CR Number:   763129 Product Name:   Adaptive Server Enterprise Product Component:   Component Drop Status:   Closed OS:   Solaris Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2014 Fixed Description This PC-Client SP is based on SDK 15.7 SP126. A list of changes in SDK 15.7 SP126 is available at http://download.sybase.com/swr/17983/EBF22690_ README.html

CR:763150

CR Number:   763150 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) 09 Jun 2014 Fixed 08 May 2014 Fixed 09 Jun 2014 Fixed 30 May 2014 One-off Provided Description Create login command does not pass the login name to sp_extrapwdchecks. Workaround Description  If the server is configured for monitoring so that monProcessProcedures is available, this query can be used from within sp_extrapwdchecks to determine if it was called directly by CREATE LOGIN or by some stored procedure (returns no rows for CREATE LOGIN): select * from master..monProcessProcedures where SPID = @@spid and ObjectName = "sp_password" If it was called by CREATE LOGIN, then check for an existing login with the same name and fail if it already exists.

CR:763162

CR Number:   763162 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) 01 Jul 2014 Fixed 19 Oct 2014 One-off Provided Description For tables with LOB columns and attribute "dealloc_first_txtpg" set to 1, error 7133 "NULL textptr passed to %s function." will be reported when WRITETEXT command is running with the new text pointer after the LOB column is updated to NULL. Workaround Description  turn off table option "deallocate first text page"

CR:763166

CR Number:   763166 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2014 Fixed Description DBISQL16/ASE in scrollable table mode, trimmed leading/trailing white spaces from error/warning/info messages, affecting the stored procedure output formatting such as "sp_showtext", where the output consists only info messages. This behavior is removed. Also, in scrollable table mode, previously Messages panel limited the number of messages to 1000 items. This limit has been removed.

CR:763213

CR Number:   763213 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2014 Fixed 13 May 2014 Fixed 11 Jun 2014 Fixed 04 Dec 2014 Fixed Description Sybmigrate space estimation report fails with error 291 state 1 "Access to sysdams is disallowed". Workaround Description  Temporarily drop the sysdams table from the destination database. If the source database is also 15.7 SP100 or higher, temporarily drop sysdams in the source database as well. To temporarily drop sysdams, use the following script: set switch on 3604 -- send dbcc output to client go set switch on 3717 with override -- required to allow dropping of the sysdams table. go dbcc dam(dbid, "drop") go set switch off 3717 go -- Run Sybmigrate. Once finished... dbcc dam(dbid, "create") go

CR:763247

CR Number:   763247 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) 30 May 2014 Fixed 30 May 2014 Reservation Made 03 Jun 2014 Fixed 03 Jul 2014 Fixed Description Using a NOT LIKE clause to compare with a local variable assigned to a constant string could return different results than comparing to the constant string directly if the column has NULL values in it. Workaround Description  add an additional SARG "and <column with nulls> is not null" Use SQLINITSTRING to set ansinull on (this can cause changes in expected null handling if relying on ansinull=off behavior) jdbcURL[...]?SQLINITSTRING=set ansinull on

CR:763271

CR Number:   763271 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2014 Fixed 09 May 2014 Fixed 15 May 2014 Fixed 29 May 2014 Fixed Description For the diagserver on Solaris platforms, if SAP ASE is running in threaded kernel mode, setting the configuration option "number of disk tasks" to any value greater than 1 will result in an assertion failure being reported in the SAP ASE errorlog.

CR:763285

CR Number:   763285 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 May 2014 Fixed 21 May 2014 Reservation Made Description In rare cases when online utility is executing, concurrent updates may hit error 12319 and terminate the session. /* 12319, EX_CMDFATAL, 1 ** Fatal internal error encountered during deferred dml on table '%.*s' in database '%.*s'. All rows that qualified during the first phase were not visited during second phase of dml. */

CR:763289

CR Number:   763289 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2014 Fixed 14 May 2014 Fixed Description sp_monitor inherits permission of exec to public from lower version server (i.e. 15.5) after upgrade to 16.0. Workaround Description  dbo can revoke execute permission on sp_monitor from public

CR:763301

CR Number:   763301 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP63 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2014 Fixed 07 May 2014 Bundled Request 27 May 2014 Fixed 27 May 2014 Fixed 09 Jul 2014 Fixed 10 Jul 2014 Fixed 10 Jul 2014 Fixed 21 Jul 2014 Port Not Needed Description The ASE COTS JavaVM version is updated to version JRE 6 update 45 for each supported platform in the sybpcidb database.

CR:763351

CR Number:   763351 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2014 Fixed 05 Jun 2014 Fixed 10 Jun 2014 Fixed Description In rare circumstances, error message "WARNING - Fatal Error 614 occurred at ... Adaptive Server accessed a row that has an illegal length ..." may be raised if there is "ORDER BY" clause in a query that uses an in-memory temp database. Workaround Description  Avoid SORT on worktable by adding index to base table if possible.

CR:763354

CR Number:   763354 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2014 Fixed 13 May 2014 Fixed Description The "Command" column in the query of monThresholdEvent is displayed as "AWAITING COMMAND" when using dynamic SQL.

CR:763376

CR Number:   763376 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 SP51 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2014 Fixed 22 May 2014 Fixed 02 Jun 2014 Fixed Description A 6908 error, "During redo the page timestamp value is less than old timestamp from log. Page .. object id = 99, page timestamp=0000 00000000. Log old timestamp=0000 00000001." may be reported during load tran in a database that has been altered with the "async_init" option. Workaround Description  Use the same async_init option for an alter in the source and the target database.

CR:763415

CR Number:   763415 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2014 Fixed 07 May 2014 Fixed 29 May 2014 Fixed Description The message, "The log for database <dbname> includes a CREATE INDEX (with deferred roll-forward) operation that is incompatible with this server version and operating environment", is not reported as expected, if a transaction log dump from an earlier 15.7 release is loaded and the dump contains a CREATE INDEX transaction that was originally done WITH DEFERRED_RECOVERY=MANUAL or DEFERRED_RECOVERY=NONE.

CR:763431

CR Number:   763431 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Open OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Include "parallel scan" option in sp_dumpoptimize topic

CR:763510

CR Number:   763510 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows 2008 Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2014 Fixed 03 Jun 2014 Fixed Description If many queries that use an "ORDER BY" clause are executed concurrently and the "default data cache" is configured to use a large value for the "local cache partition number" parameter, then SAP ASE may run very slowly or even appear to hang. Workaround Description  1. Reduce number of cachelets 2. Increase cache size 3. Reduce number of reserved buffers required by sort. Need to consult concerned team for this workaround.

CR:763514

CR Number:   763514 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2014 Fixed 11 Jun 2014 Fixed 11 Jun 2014 Fixed 19 Jun 2014 One-off Provided 15 Jul 2014 One-off Provided 16.0 GA PL03 11 Aug 2014 Fixed 18 Aug 2014 Fixed Description A 2510 error, "Key mismatch between index page <value>, partition ID <value>;... Drop and re-create index ID <value> of table '<value>' in database '<value>'." followed by the message "current process infected with 11" in the module 'byte_eq' together with a stack trace which includes the modules 'compress_page' and 's_xoltp_dml' may be reported in the error log when an INSERT is executed and while the configuration option "streamlined dynamic SQL" is active. Additionally a 631, "The length of <n> passed to delete row routine for the row at offset <n> is incorrect on the following page of database ..." error will be reported while SAP ASE is rolling back the current transaction. Workaround Description  A likely workaround for the issue here is to turn the configuration parameter streamlined dynamic SQL OFF.

CR:763609

CR Number:   763609 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2014 Fixed 09 May 2014 Fixed 12 May 2014 Fixed Description If an upgrade from a SAP ASE server with a version lower than 15.7 SP100 fails to create the table SYSDAMS because it ran out of space, executing ALTER DATABASE to extend the space will fail with the 12324 error, "In database <dbname>, the server failed to open required table 'SYSDAMS'".

CR:763615

CR Number:   763615 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2014 Fixed 16.0 GA PL02 26 May 2014 Fixed Description A 9502 error, "Data exception - string data right truncated", may be reported during ALTER TABLE MODIFY column to NULL with multi-bytes charset and the session property string_rtruncation is set. Workaround Description  n/a

CR:763672

CR Number:   763672 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2014 Fixed 21 May 2014 Fixed Description Update statistics on proxy table mapped to Oracle using DCO may stacktrace at stat_sargden_accumulate if the proxy table contains NULLs. Workaround Description  Traceflag 11209

CR:763738

CR Number:   763738 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2014 Fixed Description A 913 error, "Could not find row in sysdatabases with database id #", occurs while selecting from the MDA table monCachedProcedures when procedure cache contains a procedure that references an object in a database which has been dropped.

CR:763772

CR Number:   763772 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2014 Fixed 18 Jun 2014 Fixed 24 Jul 2014 Fixed Description Conversion to a TEXT or IMAGE column containing nulls in a stored procedure may cause seemingly random stacktraces (infected with 11 (SIGSEGV)) to be reported in the SAP ASE errorlog.

CR:763794

CR Number:   763794 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2014 Fixed 08 Jul 2014 Fixed Description When a RID is used to scan a table and the table has defaults that are not materialized, wrong results may be returned.

CR:763834

CR Number:   763834 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2014 Fixed 18 Jun 2014 Reservation Made 19 Jun 2014 Fixed 19 Dec 2014 Fixed Description Some system stored procedures inherited permissions from lower server (i.e. 15.5) after upgrade to 16.0.

CR:763859

CR Number:   763859 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2014 Fixed 15 May 2014 Reservation Made 20 May 2014 Fixed Description The EQUALS_SCAN_SUPERSET optcriteria hueristic rule is applied to prefer an index with more limiting equi-sarg keys specified over another index with fewer limiting keys, given that the index limiting equi-sargs keys is a superset of the latter index, and that it is also a superset all the limiting sargs and filtering sargs the latter index. However, if an enforcer such as a SORT or XCHG is applied, the index with fewer limiting equi-sarg keys may still be chosen. Optcriteria cr763859 will use the rule hueristic, but it will only apply if optcriteria EQUALS_SCAN_SUPERSET is also enabled.

CR:763861

CR Number:   763861 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2014 Fixed Description In very rare circumstances, when querying the MDA monOpenObjectActivity table, error 14108 "Could not find partition descriptor for objid <objid>, indid <indid>, ptnid <ptnid> in dbid <dbid>." may be reported.

CR:763965

CR Number:   763965 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris 11 Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances signal 11 may occur in dodeferred() when executing stored procedure and running the INSERT into temp table with select distinct UNION statements

CR:764009

CR Number:   764009 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2014 Duplicate Description Query hits signal 11 in GtuUnion::_GtcNTopPopsGenerate or GttTable::GttValidateFactTable under 'deferred parallel' execution. Workaround Description  set alternative_greedy_search off

CR:764036

CR Number:   764036 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2014 Fixed Description An UPDATE with a builtin in the SET clause executes ineffieciently as compared to ASE 12.5.

CR:764060

CR Number:   764060 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2014 Fixed 16 Jul 2014 Fixed Description The message "current process infected with 11" in the module 'ubffreef' together with a stack trace which includes the modules 'ra_free_mempool' and 'ra__schema_dealloc_obj' may be reported in the error log preceded by a 9685 error, "Rep Agent on database '<dbname>' switched from mode 'sync' to mode 'async' because timer on commit expired.", when SAP Adaptive Server Rep Agent is configured to use streaming replication in either near-sync or sync mode. This will result in SAP Adaptive Server to shutdown implicitly. Workaround Description  sp_config_rep_agent <primdb>, 'max commit wait', 0 By setting this value to zero a task will sleep until such a time things get sorted out and no timer will expire. This hould diminish the likelihood of this problem from happening.

CR:764074

CR Number:   764074 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) 28 May 2014 Insufficient priority to fix 19 May 2014 Fixed 26 Aug 2014 Fixed 02 Jun 2014 Fixed 24 Sep 2014 Fixed Description The "Alter thread pool" command may cause an infected with 11 (SIGSEGV) along with a stacktrace that references the function rvm_dispatch() to be reported in the SAP ASE errorlog.

CR:764121

CR Number:   764121 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2014 Fixed Description The showplan in xml utility could return the strings "Sort (Build)" and "Sort (GetSorted)" for the splitSort operator. These strings generate an XML parser error when running a query that qualifies XML using xmltest.

CR:764124

CR Number:   764124 Product Name:   Adaptive Server Generic Docs Product Component:   Security Administration Guide Status:   Open OS:   all Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Improve documentation about how the audit processes insert the audit records in to the audit table.

CR:764158

CR Number:   764158 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2014 Fixed Description If the secondary truncation point is enabled on the master database on a pre 16.0 server installation, and then 16.0 server is booted against the installation without having followed the required SAP ASE 16.0 upgrade steps (run preupgrade first), then the SAP ASE 16.0 server will fail to boot. The pre SAP ASE 16.0 version will then also fail to boot with the following messages being reported in the ASE 160 errorlog: "server Opening Master Database ..." and "kernel The secondary truncation point is turned on in the master database. Please use your older ASE version to turn the secondary truncation point off before using this ASE version".

CR:764186

CR Number:   764186 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2014 Fixed 03 Jun 2014 Reservation Made 04 Jun 2014 Fixed Description In rare circumstances, the message "current process infected with 11" (SIGSEGV) in the module 'dpdb__dflpurge' together with a stack trace may be reported in the error log followed by the message "Spinlocks held by kpid ... Resource->rdbt_ext_spin" resulting in SAP ASE shutting down implicitly during the execution of a DUMP DATABASE command and while the configuration option "optimize dump for faster load" is set to 1. Workaround Description  sp_configure "optimize dump for faster load", 0

CR:764219

CR Number:   764219 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Identity column not replicated via select into

CR:764274

CR Number:   764274 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2014 Fixed 17 Jul 2014 Presently Not Targeted For Any Future Release Of This Product Description In some cases when updates is executed concurrently with DROP PARTITION, MERGE PARTITION or TRUNCATE PARTITION PLM utilities. updates convert to delete + insert.

CR:764288

CR Number:   764288 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) 13 Jun 2014 Fixed 13 Jun 2014 Fixed Description Under a rare condition, if compatibility mode is enabled and when trying to delete a row from a table which has IN ROW LOB, error msg 605 "An attempt was made to fetch logical page '<n>' from cache '<name>'. Page belongs to <ptninfo1> and not to <ptninfo2>." could be reported. Workaround Description  To remove in row when you create LOB table and delete will be fine.

CR:764402

CR Number:   764402 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2014 Fixed 24 Jun 2014 One-off Provided 12 Jun 2014 Fixed 02 Oct 2014 Fixed Description A 692 error, "Uninitialized logical page '<value>' was read while accessing database 'value', object '' (99), index '<Unknown>' (0), partition '<Unknown>' (99)." may be reported during the execution of either ALTER or CREATE DATABASE command when the "FOR LOAD" option is used and while the database is larger than 63 GB. This may be followed by the message "current process infected with 11" in the module 'buf_cleanup_write_queue' together with a stack trace in the SAP ASE error log which includes the modules 'terminate_process' and 'quitfn'. Workaround Description  do not use "for load" option for create/alter database

CR:764429

CR Number:   764429 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#11.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2014 One-off Provided 17 Jul 2014 Fixed 23 Jul 2014 Port Not Needed Description Enhance text page diagnostics: enable option 8 for DBCC PAGE(); enhance 7105 error message to print page number of first text page; include the port of CR 541218 which may fix the 605 error.

CR:764437

CR Number:   764437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 SP01 PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2014 Fixed 16.0 GA PL02 23 May 2014 Fixed 10 Jul 2014 Fixed Description A 2956 error, "Unable to grab a buffer to encrypt logical page <page_num> in database <db_id>. Increase the size of the buffer pool in the buffer cache <cache_name>", may be raised to report buffer shortage when large transactions are executed on an encrypted database.

CR:764448

CR Number:   764448 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2014 Fixed 09 Jun 2014 Fixed 03 Jul 2014 Fixed 03 Jul 2014 Fixed 10 Jul 2014 Fixed 15 Jun 2014 Fixed 19 Jun 2014 Fixed 03 Jul 2014 Fixed 02 Jul 2014 Fixed 28 Jul 2014 Reservation Made 04 Aug 2014 Fixed Description Support the migration of ASE stored procedure to HANA procedure

CR:764509

CR Number:   764509 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP140 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2014 Fixed 05 Jan 2015 Fixed 07 Jan 2015 Fixed Description Modularize output from sp_help, sp_helpindex and sp_helpartition to provide terse output which is useful for tables and indexes with large number of partitions.

CR:764543

CR Number:   764543 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2014 Fixed 30 May 2014 Fixed Description Backup Server may log false page verification errors with a message "Incorrect column type in the offset table of row x in page xxx of object ID xxxxxxxx." when executing dump database command with verify = full on a database with 'allow wide dol rows' turned on. Workaround Description  There is no workaround.

CR:764623

CR Number:   764623 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2014 Fixed Description When performing a dictionary decompress for varchar column with character encoding, SAP ASE may report a 9829 error - " Compressed data row <rowid> in objid <objid>, dbid <dbid> is corrupted."

CR:764630

CR Number:   764630 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2014 Fixed 17 Jul 2014 Fixed 12 Aug 2014 Fixed Description Checkpoint sleeps on buffer in encrypted db

CR:764801

CR Number:   764801 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2014 Fixed 06 Jul 2014 Fixed 04 Jul 2014 Not a Bug Description Under an HADR environment the current task may hang forever in the log drain phase of the deactivation process if the SAP ASE Replication Agent is unable to connect to the SAP Replication Server during the execution of 'sp_hadr_admin deactivate'. Workaround Description  dbcc hadr_admin('cancel')

CR:764830

CR Number:   764830 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) 16 Jun 2014 Presently Not Targeted For Any Future Release Of This Product 12 Jun 2014 Fixed 13 Jun 2014 Fixed 12 Jun 2014 Reservation Made Description When the advanced_aggregation optcriteria is used (typically this occurs when the optimization goal is allrows_dss), then there is a possibility of a wrong answer when a SUM, or AVG aggregate is used on an exact numeric datatype column. Workaround Description  use trace flag 15341 or do not use allrows_dss or set advanced_aggregation off or use the hint plan '(use advanced_aggregation off)'

CR:764843

CR Number:   764843 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2014 Fixed 16 Jun 2014 Fixed Description When 2-phased sort execution plan (i.e. with SORTBUILD and GETSORTED operators) was chosen, Dynamic Thread Assignment (DTA) was causing exceptions in Linux platform due to synchronization issues supposedly due to thread migration. DTA would internally be disabled for such queries with 2-phased sort which might prevent performance gain for the queries that benefit from DTA.

CR:764862

CR Number:   764862 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2014 Fixed 05 Jun 2014 Fixed 04 Jun 2014 Fixed Description The message text for error 3543 is enhanced to include the database id value such as "One or more entries in the data segment free space counts in database ID %d was found to be negative and has been set to 0."

CR:764908

CR Number:   764908 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Infected in lock__semawait when cleaning up after an error. Workaround Description  Turn off both "object lockwait timing" and "enable stmt cache monitoring". This will avoid the code path in lock__semawait() that hits the error.

CR:764924

CR Number:   764924 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2014 Fixed 27 Jun 2014 Fixed 18 Aug 2014 Fixed Description The errors 'Object id wrong' or 'Page mismatch' can be mistakenly reported by DUMP WITH VERIFY if the system is very busy while the database dump is in progress. Workaround Description  If you expect the ASE server will have other active concurrent sessions writing data or log while dumping the database, then please not to use dump database with verify option to avoid these error messages.

CR:764945

CR Number:   764945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP63 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2014 Fixed 26 Jun 2014 Port Not Needed 26 Jun 2014 Port Not Needed Description In rare circumstances, the execution of Java User Defined Functions (UDF) could mistakenly ignore the arguments it expects when these are presented to it through a single argument that holds a white space separated string.

CR:764953

CR Number:   764953 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2014 Fixed Description fact table hint may lead to less optimal plan with huge table (>= 1 billion rows).

CR:764985

CR Number:   764985 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2014 Fixed Description Test of one-off approval/route process.

CR:765005

CR Number:   765005 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A 7222 error (Received bad token 0xff from site 'server name') may be raised if you run a nested RPC and a 2601 error (Attempt to insert duplicate key row) occurs. A client application may also raise an error message "ct_results(): protocol specific layer: internal Client Library error: There is a tds state machine error. An illegal tds token sequence was received.".

CR:765065

CR Number:   765065 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2014 Fixed 17 Jun 2014 Fixed Description The MDA table monRepSyncTaskStatistics is enhanced by adding new monitor columns that provide information on the time spend in the transaction commit processing when using streaming replication in (near) sync mode. Workaround Description  n/a

CR:765074

CR Number:   765074 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2014 Fixed 05 Aug 2014 Fixed Description A 2546 error: "Table Corrupt: Extent id <extid> on allocation pg# <pgnum> has objid <objid>, indid <indid>, and used bit on, but reference bit off." may sometimes be reported by DBCC CHECKALLOC following the rollback of a transaction that contains a CREATE INDEX command as well as DMLs to the table within the same transaction, in a database with DDL_IN_TRAN option turned on.

CR:765101

CR Number:   765101 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2014 Fixed Description Sometimes we might hit timeslice error when running dbcc des().

CR:765133

CR Number:   765133 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2014 Fixed Description Error message 15746 is modified and made generic as "Unable to run this command on the archive database '%S_DBID' because it is not supported."

CR:765203

CR Number:   765203 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description On AIX in threaded kernel mode, the monEngine connections column is incorrect and dump database may fail with 'soc_nconnect: No free file descriptors available' raised in the errorlog when executed concurrently with sp_listener. Workaround Description  Use process based kernel mode. Do not run sp_listener and dump database concurrently.

CR:765216

CR Number:   765216 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2014 Fixed 13 Jun 2014 Reservation Made 23 Jun 2014 Fixed Description sp_hadr_admin failover_timeestimate reports high value for estimated failover time.

CR:765240

CR Number:   765240 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2014 Fixed Description A query with an AP that forces a distinct_sorted operation fails (because an m_join property fails). In the case where the feature to eliminate substitution elements that appear only as simple sargs is enabled, this results in a SEGV in LeVtuple::LeVtCopy under LeGroupSortedOp::_LeOpNext. Tcf 16938 can be used to disable the substition scalar elimination.

CR:765261

CR Number:   765261 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description "Waiting for native threads message .. " have an option for sp_ldapadmin 'set_log_interval' to have switch the log internal off (disable).

CR:765267

CR Number:   765267 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP50 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2014 One-off Provided 03 Oct 2014 Port Not Needed 24 Nov 2014 Already Fixed by Another CR Description Server to server CIS connections encounter an access violation in function csimtx_lock.

CR:765273

CR Number:   765273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2014 Already Fixed by Another CR 13 Aug 2014 Fixed 14 Aug 2014 Reservation Made 16 Sep 2014 Fixed 12 Sep 2014 Reservation Made 15 Dec 2014 Fixed Description Select-into was not allowed in multi-statement transaction. This is now possible and is enabled by the new configuration option 'enable select into in tran'.

CR:765296

CR Number:   765296 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2014 Fixed 19 Dec 2014 Presently Not Targeted For Any Future Release Of This Product 08 Sep 2014 Fixed 29 Sep 2014 Fixed Description Msg 422 - 'Too many nested expressions or logical operators to compile. Try splitting query or limiting ANDs and ORs.' is seen for queries on tables with high number of partitions and local indexes. Workaround Description  Reduce the number of local indexes. Or force the query to use a table scan. eg: select * from t1 (index 0)

CR:765348

CR Number:   765348 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2014 Fixed 03 Sep 2014 Reservation Made 06 Oct 2014 Presently Not Targeted For Any Future Release Of This Product 24 Sep 2014 Consult Complete Description New configuration option 'prevent automatic upgrade' will prevent newer SAP ASE versions from making changes that might prevent booting an older version on this installation. New command line argument --upgrade-ok grants permission for the upgrade.

CR:765381

CR Number:   765381 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2014 Fixed Description Select negative number from tinyint column does not return 'Arithmetic overflow" error. Target Version  15.7 SP130

CR:765456

CR Number:   765456 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2014 Fixed 19 Aug 2014 Fixed Description CRAETE INDEX support on IMRS table.

CR:765517

CR Number:   765517 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) 04 Aug 2014 Presently Not Targeted For Any Future Release Of This Product 30 Jun 2014 Fixed 01 Jul 2014 Fixed 01 Jul 2014 Fixed Description If auditing is enabled and a stack overflow is detected, SAP ASE reports an infected with 11 (SIGSEGV) in chk_usr_role_audit(). As a consequence, normal shutdown hangs, but 'shutdown with nowait' works. Workaround Description  disable auditing shutdown with nowait

CR:765533

CR Number:   765533 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Configuration Guide for Windows Status:   Closed OS:   Microsoft Windows NT Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2014 Added to user documentation Description Install sybsyntax script name of the Windows version is not correct. Workaround Description  Script name of the Windows version is inssynsq.

CR:765556

CR Number:   765556 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Killing a spid in recursive function mkcollist should better attention checking

CR:765621

CR Number:   765621 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP51 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2014 Fixed Description In rare circumstances, when "Update statistics" and BCP running in parallel, update Stats may fail with "Error 605: An attempt was made to fetch logical page %d from cache 'default data cache'. Page belongs to database 'brfdb' (32), object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (-1) and not to database 'brfdb' (32), object %s, index '<Unknown>' (0), partition %s. Workaround Description  dbcc tablealloc as manual say. Msg 7940 http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/BABIDEIG.htm?resultof=%22%37%39%34%30%22%20 Msg 7949 http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/BABCJAAE.htm?resultof=%22%37%39%34%39%22%20

CR:765677

CR Number:   765677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2014 Fixed 10 Jul 2014 Fixed 07 Jul 2014 Reservation Made 25 Jul 2014 Fixed Description In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #=<pg>, page timestamp=<ts>. Log old timestamp=<ts2>." may be reported during recovery when an ALTER TABLE or REORG REBUILD command was running at the time SAP Adaptive Server was shutdown with nowait or was abnormally stopped. Workaround Description  Boot the server, or LOAD DATABASE with the 3412 trace flag turned on.

CR:765720

CR Number:   765720 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2014 Fixed 17 Jun 2014 Fixed 27 Jun 2014 Port Not Needed Description Under some circumstances the backup server may report the error Backup Server: 4.189.2.1: Volume validation error: attempt to set directio mode on <devicename> returned -1. while a DUMP DATABASE or DUMP TRANSACTION command is being executed. To avoid this problem from happening execute in the master database the command sp_deviceattr devicename,directio,false. Workaround Description  use master go sp_deviceattr devicename,directio,false go

CR:765728

CR Number:   765728 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) 18 Jun 2014 Fixed 25 Jun 2014 Fixed 20 Jun 2014 Fixed 18 Aug 2014 Fixed 16.0 GA PL03 11 Aug 2014 Fixed Description When BULK-INSERT optimization is used for an INSERT INTO ... SELECT ... statement, and when an exception occurs during that statement (in this case, a landing partition for a row is not found thus causing an exception), an infected with 11 (SIGSEGV) stacktrace may be reported in the SAP ASE errorlog. This can also be a trigger for the symptoms in CR 763514 (if neither CR 763514 or 765728 is fixed).

CR:765910

CR Number:   765910 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   15.7 SP51 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2014 Fixed Description In rare circumstances, UPDATE STATISTICS may lead to error: 806: "Could not find virtual page for logical page <n> in database 'tempdb'." Workaround Description  set auto_temptable_stats off

CR:765911

CR Number:   765911 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2014 Fixed 19 Jun 2014 Fixed 19 Jun 2014 Reservation Made Description A 3223 error, "Attempt to read a dump trailer failed; returned error code is 2.", will be reported when trying to load a database dump into a pre-15.7 SP121 SAP ASE release, if the dump was taken either with 15.7 SP121 or 15.7 SP122 SAP ASE releases and the option 'optimize dump for faster load' was enabled when the dump was taken. Workaround Description  Upgrade the older ASE to 15.7 SP121 or SP122.

CR:765924

CR Number:   765924 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2014 Fixed Description In SAP ASE Cluster Edition, duplicate identity values may be generated in column that was created with the IDENTITY() built in function.

CR:765991

CR Number:   765991 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2014 Fixed 18 Aug 2014 Fixed Description The message "Current process infected with signal 11 (SIGSEGV)" together with a stack trace containing the module 'ups_stat_memalloc' may be reported in the SAP ASE error log while running UPDATE INDEX STATISTICS with hashing.

CR:766109

CR Number:   766109 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2014 Fixed 21 Jun 2014 Fixed 24 Jun 2014 One-off Provided 21 Jun 2014 Fixed 16 Jul 2014 One-off Provided Description Under a heavily loaded Java application environment, the messages 'PCI(M1): ERROR: JNI_CreateJavaVM; failed attaching to the JVM for AttachCurrentThread() with -1' and 'PCI(M1): ERROR: JNI_CreateJavaVM; PCA/VM FAILED; general failure' may be reported in the SAP Adaptive Server error log. These messages usually indicate that the JavaVM heap space is exhausted. In order to solve this problem the SAP Adaptive Server needs be restarted.

CR:766119

CR Number:   766119 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In dbcc gettrunc, dbcc settrunc, and sp_help_rep_agent, pageid values are being represented as signed 32-bit integers even though large databases may generate pageid values > 2,147,483,647

CR:766247

CR Number:   766247 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2014 Fixed 14 Aug 2014 Fixed Description In rare circumstances a DUMP or LOAD command could fail on a Windows platform with the error message in the SAP ASE backup server errorlog 'Error in acknowledging command '152' to the archive emulator'.

CR:766251

CR Number:   766251 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_helpconfig "heap memory per user" with a new value shows the size of memory in kilobytes, but it should be in bytes.

CR:766255

CR Number:   766255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   MPE/XL Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2014 Bundled Request 04 Jul 2014 Fixed Description select bucketpool("bpname/numbuckets") can fail on some platforms Workaround Description  use a trailing '/' in the command, eg: select bucketpool("bpname/numbuckets/")

CR:766283

CR Number:   766283 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2014 Fixed 21 Jul 2014 Fixed Description The message "current process infected with 11" in the module n3__get_sig_size together with a stack trace which includes the modules s_normalize and n3_udf may be reported in the error log when a query inserts data into an UDF/ADT column by using a wrong datatype conversion.

CR:766324

CR Number:   766324 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2014 Fixed 08 Jul 2014 Fixed Description Under an HADR environment on the AIX platform, a user connection (not having 'allow hadr login' privilege) to the ASE in standby mode is not redirected to the primary ASE, and the user login fails. Workaround Description  None

CR:766325

CR Number:   766325 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2014 Fixed 12.5 12 Sep 2014 Reservation Made Description Under heavy systems with enable functionality group is on, a cursor dynamic prepared statement executed by non DBO users under recompilation path may run into 225 or 208 error.

CR:766379

CR Number:   766379 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2014 Fixed 07 Jul 2014 Fixed 07 Jul 2014 Fixed 10 Jul 2014 Insufficient priority to fix 07 Jul 2014 Fixed 07 Jul 2014 Fixed 07 Jul 2014 Fixed Description Table scan running at isolation level 3 may sometimes return wrong result if there are concurrent INSERTs/UPDATEs happening on the table.

CR:766387

CR Number:   766387 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   MPE/XL Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2014 Fixed 02 Sep 2014 Insufficient priority to fix 30 Nov 2014 Port Not Needed Description Online parallel create index may fail if the SAP ASE configuration value 'max (utility) parallel degree' is not enough. Workaround Description  Don't use online parallel create index or increase the SAP ASE configuration value 'max (utility) parallel degree'

CR:766427

CR Number:   766427 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2014 Fixed 27 Jun 2014 Fixed 27 Jun 2014 Fixed 27 Jun 2014 Fixed 26 Jun 2014 Port Not Needed 11 Dec 2014 Fixed Description The indexes created internally for the replication of text/image columns are system objects and they cannot be renamed by executing the system stored procedure sp_rename.

CR:766492

CR Number:   766492 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2014 Fixed 10 Jul 2014 Fixed 27 Nov 2014 Port Not Needed 27 Nov 2014 Port Not Needed 28 Nov 2014 Port Not Needed Description An attempt to connect to the Backup Server could fail with the error 'The host '<IP address>' is not authorized to connect to this Backup Server.' reported in the SAP backup server error log if the SAP backup server is booted using a virtual address and the 'hosts.allow' file doesn't contain an entry for the actual real address. Workaround Description  Add real address to the hosts.allow file

CR:766498

CR Number:   766498 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2014 Fixed 14 Sep 2014 Fixed 09 Dec 2014 Presently Not Targeted For Any Future Release Of This Product Description A non sa_role user cannot generate DDL for a database if that user does not have sa_role.

CR:766499

CR Number:   766499 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2014 Fixed 25 Jul 2014 Fixed 01 Jan 2015 Fixed Description When trying to INSERT rows via jdbc using the property DYNAMIC_PREPARE=true, if there is a datatype conversion for columns and overflow/underflow occurs for any column, we may see incorrect Error 515 (Attempt to insert NULL value into column). If there the underlying column allows NULL values, then we may see a data corruption issue where we insert NULL when the above mentioned error conditions occur. The correct expected behaviour is Error 247 (Arithmetic overflow during implicit conversion of datatype).