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

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

CR:759637

CR Number:   759637 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2014 Fixed 24 Mar 2014 Fixed 26 Mar 2014 Fixed 17 Apr 2014 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module LeScanOp::_LeOpNext() may be reported in the error log when an online utility (e.g. REORG REBUILD) is in progress on a table that contains forwarded rows. Workaround Description  Do not use 'with online'

CR:759646

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

CR:759660

CR Number:   759660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2014 Duplicate 24 Mar 2014 Duplicate Description While upgrading ASE to 15.7 a server configured with multiple engine groups may receive error 644 on sysattributes followed by the message "Logical Process Manager Error: Failed to start a transaction to delete 'PS' type specification." and shutdown before starting the upgrade. To work around this issue, manually remove all engine groups using sp_dropengine and restart the upgrade. Workaround Description  Use sp_dropengine to remove all engine group definitions.

CR:759679

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

CR:759728

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

CR:759730

CR Number:   759730 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2014 Presently Not Targeted For Any Future Release Of This Product Description If there are multiple plans for a cached statement dbcc prsqlcache will only display the first one it locates in cache. Workaround Description  Use show_cached_plan_in_xml() which accepts a plan id as the second parameter.

CR:759748

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

CR:759867

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

CR:759923

CR Number:   759923 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2014 Fixed Description Traceflag 3605 gets left on after error 707 state 11 is hit, resulting in a wide variety of diagnostic information being written to the errorlog, in turn causing the errorlog to grow rapidly.

CR:759926

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

CR:759937

CR Number:   759937 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2014 Fixed 05 May 2014 Fixed Description If a trigger for a DML query has certain commands that execute immediate are not allowed, such as begin tran, rollback trans, etc, error 11736 and 11031 could be raised for the first post-upgrade using execute immediate for the DML query. Workaround Description  After upgrading database and bringing it online, manually execute dbcc upgrade_object(<dbname>, 'trigger') go

CR:759945

CR Number:   759945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2014 Fixed 29 May 2014 Fixed Description When LOAD DATABASE ... WITH LISTONLY = 'CREATE_SQL' is used with the new functionality to create DDL for a differently named target database, the target database name is not reflected in the sp_dboption statements.

CR:759995

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

CR:760002

CR Number:   760002 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2014 Fixed 26 Mar 2014 Fixed 21 Mar 2014 Fixed Description DBCC CHECKTABLE may encounter a 2511 error, "Keys of index ID <id> for table <tablename> in leaf page are not in the correct order. Drop and re-create the index (index page <pageno>, partition ID <partition_id>)", if 'enable functionality group' is enabled and the base table lockscheme is DOL and changing the table's lockscheme from DOL to APL as part of AMC.

CR:760054

CR Number:   760054 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2014 Fixed Description On ASE Cluster Edition insert jobs may unexpectedly continue to run with no new rows inserted to the target table. Dbcc checkalloc or tablealloc may report Msg 2546.

CR:760159

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

CR:760176

CR Number:   760176 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2014 Fixed 16 Apr 2014 Already Fixed by Another CR Description Optcriteria equals_scan_superset and avoid_zero_weight_histograms are associated with the ase157sp130 optimization level. Previously, a user defined optgoal needed to be defined to enable these optcriteria (or trace flags 16989 and 16991 respectively).

CR:760187

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

CR:760226

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

CR:760241

CR Number:   760241 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2014 Fixed 27 Mar 2014 Fixed 16 May 2014 Fixed Description The error message, "Length of plain text is less than one cipher block", may be reported in the error log during encryption of a database.

CR:760248

CR Number:   760248 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2014 Fixed 15.7 SP111 24 Mar 2014 Fixed 25 Mar 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed 07 May 2014 Fixed Description Under some circumstances, a worker thread may hang due to incorrect error handling during parallel CREATE INDEX with "utility statistics hashing" turned on.

CR:760269

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

CR:760274

CR Number:   760274 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP111 02 Apr 2014 Fixed 02 Apr 2014 Fixed 15.7 SP130 10 Apr 2014 Fixed 15.7 SP122 17 Apr 2014 Fixed 29 Apr 2014 Fixed Description In rare circumstances, a time slice error followed by a stack trace that includes the modules ups_end_statglobalnosort() and close_table() may be reported in the error log when running UPDATE INDEX STATISTICS.

CR:760365

CR Number:   760365 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2014 Fixed 14 Apr 2014 Fixed Description Isolation level 0 queries fail with errors when CREATE CLUSTERED INDEX WITH ONLINE is in progress concurrently on the same table.

CR:760373

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

CR:760390

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

CR:760437

CR Number:   760437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2014 Fixed 08 May 2014 Fixed Description Under certain circumstances, the preupgrade utility from SAP ASE 16.0 can encounter data conversion errors and overflow errors when checking for free space in a database's system segment.

CR:760453

CR Number:   760453 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2014 Fixed 02 Apr 2014 Fixed 02 Apr 2014 Port Not Needed 01 Apr 2014 Fixed Description Wrong result could happen when an EQUIJOIN on a single INT4 column is placing a bloom filter probe into the scan and the scan is at the inner side of another NESTED LOOP JOIN with a pushdown EQUIJOIN sarg on the same column. Workaround Description  cmdline traceflag 16963.

CR:760539

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

CR:760621

CR Number:   760621 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2014 Fixed 15 Apr 2014 Fixed 14 Apr 2014 Fixed 20 May 2014 Fixed Description On a server that has a large number of objects, the sp_sysmon report may take a long time to complete and error message 1508, "Create index aborted on duplicate rows. Primary key is <keyname>", may be reported in the error log.

CR:760635

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

CR:760654

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

CR:760661

CR Number:   760661 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 02 Apr 2014 Fixed 15.7 SP110 02 Apr 2014 Fixed 22 Apr 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed 09 May 2014 Fixed Description The procedure cache allocation is optimised. This vastly speeds up the start-up of SAP ASE configured with a very large procedure cache.

CR:760672

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

CR:760673

CR Number:   760673 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2014 Fixed 03 Apr 2014 Fixed 10 Apr 2014 Fixed 14 Apr 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed Description If the data cache is configured small, SAP ASE may report a 'cache too small' error when the new sort buffer algorithm is used.

CR:760684

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

CR:760711

CR Number:   760711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2014 Fixed Description In rare circumstances, after using the configuration option 'global cache partition number', the dataserver may hang. If the diagserver was being used then an Assertion (! "locks not cleaned") will be reported in the SAP ASE errorlog.

CR:760751

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

CR:760781

CR Number:   760781 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2014 Fixed 08 Apr 2014 Fixed 18 Sep 2014 Port Not Needed Description When there is no active transaction in a database, running select loginfo('dbname','stp_pages') will give the result of 0 even if the secondary truncation page is not the same as the last log page. Workaround Description  Use other options of the loginfo built-in to see whether the secondary truncation page is preventing the log from being truncated. select loginfo(dbname,is_stp_blocking_dump) : if it returns 1, it means that the secondary truncation page is the same as the first log page, and it is blocking the log from being truncated. select loginfo(dbname,can_free_using_dump_tran) : prints the percent of log that can be truncated within the total log size. select loginfo(dbname,stp_page) : gives the page number of the secondary truncation page. select loginfo(dbname, oldest_active_transaction_page) : prints the page that contains the oldest active transaction marker. So these built-in options can be used to detect whether secondary truncation page is lagging behind and preventing log from being truncated.

CR:760836

CR Number:   760836 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2014 Fixed 23 Apr 2014 Fixed Description In some rare cases, some of the pdes spinlocks show contention with objects that have a large number of partitions.

CR:760875

CR Number:   760875 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2014 Fixed 23 Apr 2014 Fixed 23 Apr 2014 Fixed 01 Jul 2014 Fixed Description sp_sysmon and monEngine do not report DiskIOChecks in process mode.

CR:760876

CR Number:   760876 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2014 Fixed 08 May 2014 Fixed 17 Jun 2014 Fixed 13 May 2014 Fixed 25 Jun 2014 Fixed 25 Jun 2014 Fixed Description Deprecate the plan sharing feature (used to be enabled via the SAP ASE configuration option called "enable plan sharing").

CR:760897

CR Number:   760897 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 GA PL02 11 Apr 2014 Fixed 25 Apr 2014 Fixed 24 Apr 2014 Fixed 09 Apr 2014 Reservation Made Description A 6908 error, "During redo the page timestamp value is less than old timestamp from log. etc." followed by a stack trace that includes the module 'recovery' could be raised when loading a database dump if the configuration parameter 'optimize dump for faster load' is enabled and there is very high update activity in SAP ASE while the dump database command is running. To workaround the problem the end-user can set the trace flag 3022 (either via the command line or by using dbcc traceon or by using SET SWITCH ON ignore_trailer_ckpt) before loading the database. Workaround Description  The problem will happen only if there is a lot of concurrent activity while dump database is running and the configuration option 'optimize dump for faster load' is enabled. So, before you get the problem, it will be avoided if the option is set to '0'. If a dump has been taken with this option enabled, to load the database without errors you can do: dbcc traceon(3022) go and now load the database....

CR:760910

CR Number:   760910 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2014 Fixed 21 May 2014 Fixed 11 May 2014 Reservation Made Description In rare circumstances, when a partitioned table has a local index and partition lock is enabled, SAP Adaptive Server may hit error 12212 during an index scan, if a committed transaction deletes few rows from a partition that cause deallocation of extent (say X) and a uncommitted transaction inserts rows in another partition, cause allocation of same extent(X). After hitting 12212 error SAP ASE terminates the connection and logs a stacktrace in the SAP error log. Error 12212 " Internal Error: The partition ID (<ID>) of the lock does not match the partition ID (<ID>) of the new request on this lock. dbid=<DB_ID>, objid=<OBJ_ID>, pageno=<Page number>, rowno=<Row Number> locktype=<lock type>".

CR:760917

CR Number:   760917 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2014 Fixed 16 Apr 2014 Fixed Description Upgrade to SAP ASE 16.0 may fail with the error message "Kernel resource memory pool has been exhausted. Try increasing the value of 'kernel resource memory'".

CR:761036

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

CR:761047

CR Number:   761047 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2014 Not reproducible with latest version of the product available as of Resolution Date 23 Jul 2014 Fixed by Integrated Component 03 Oct 2014 Port Not Needed Description Diagnostics improvements to get clean stacktrace when SAP ASE encounters an infected with 11 (SIGSEGV) error in modules such as ct__apicont_trans().

CR:761062

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

CR:761117

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

CR:761155

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

CR:761188

CR Number:   761188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Nov 2014 Bundled Request Description Monitoring Tables to have an extra column as "OrigServerUserID" to track original ServerUserID when executing procedures with "execute as".

CR:761205

CR Number:   761205 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description With streamlined dynamic SQL enabled, show_cached_plan_in_xml does not display the query plan for a cached language cursor.

CR:761275

CR Number:   761275 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2014 Fixed 14 Apr 2014 Fixed 16 Apr 2014 Fixed 04 Jun 2014 Fixed 10 Jun 2014 Fixed Description When there are several scans on the same index and some of the scans hit the same index page needed to be shrunk concurrently, the index page may be shrunk twice. The second attempt will fail and a 2630 error, "In database <db>, page <page#2> is linked backward to page <page#1>, but that page is linked forward to page <page#3>. Please report this internal error to SAP Technical Support". Although a 2630 error is raised, the index is not corrupted.

CR:761282

CR Number:   761282 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2014 Fixed 20 May 2014 Fixed 23 Apr 2014 Reservation Made 04 Jun 2014 Fixed Description When execute command ALTER TABLE ... SPLIT PARTITION ..., use of parallel sort and table's partition number > 1, it will encounter an Error 675: "Invalid Buffer Cache Access: Attempt to locate page <page>, database <dbid> in cache failed because no object id was specified. scan_context={objid <objid>, indid <indid>, cid <cid>}. Contact Technical Support for Assistance." Workaround Description  sp_configure 'max utility parallel',1 as long as the sort is done in serial, we will not hit any error msg.

CR:761313

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

CR:761333

CR Number:   761333 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2014 Fixed 25 Sep 2014 Fixed 06 Oct 2014 Fixed 05 Nov 2014 Fixed 27 Oct 2014 Fixed Description In some workloads with lot of dynamic prepare statements executing on the system, we would see buffer cache of system table 'sysusers' and 'sysdatabases' to be hot.

CR:761385

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

CR:761402

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

CR:761410

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

CR:761514

CR Number:   761514 Product Name:   Sybase SQL Server Product Component:   sybinit Status:   Closed OS:   Microsoft Windows Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2014 Fixed 15 Apr 2014 Fixed Description sybatch.exe failed to set the XP Server in upgrading server if Replication Server is configured.

CR:761518

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

CR:761555

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

CR:761597

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

CR:761668

CR Number:   761668 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2014 Fixed 09 Apr 2014 Fixed 16 May 2014 Fixed Description A 614 error may be reported when executing DBCC CHECKSTORAGE on an encrypted database.

CR:761679

CR Number:   761679 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2014 Fixed 13 Jun 2014 Fixed 04 Jun 2014 Port Not Needed Description LOAD DATABASE WITH LISTONLY=LOAD_SQL with UNTIL_TIME after a tran dump and before a database dump generates incorrect load SQL.

CR:761710

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

CR:761725

CR Number:   761725 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2014 Presently Not Targeted For Any Future Release Of This Product 21 Apr 2014 Fixed Description Description: Issue occured in 15.7SP110 onwards Frequency: Occasionally Server Enviornment: On heavily-loaded Platform: All Symptoms: Server hangs when using UPDATE INDEX operator in showplan and an Error 1105 occurs

CR:761743

CR Number:   761743 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2014 Fixed 15 Apr 2014 Fixed 07 May 2014 Fixed Description The optcriteria EQUALS_SCAN_SUPERSET and EQUALS_NLJOIN_SCAN_SUPERSET have had the comments changed so that the respective optcriteria names shows up in the sysoptions output.

CR:761769

CR Number:   761769 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP140 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Sub-optimal performance may be observed when a query has IN list predicate executed on a table with hash partition due to non-elimination of unqualified partition.

CR:761825

CR Number:   761825 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2014 Fixed Description Bulk insert to proxy tables mapped to DirectConnect for Oracle was disabled in ASE 15.0.

CR:761830

CR Number:   761830 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2014 Fixed 20 Jun 2014 Reservation Made 08 Jul 2014 Reservation Made Description New SAP ASE built-in IS_PREPARED(<dbid>) will report if a database has been put in a PREPARE state.

CR:761835

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

CR:761836

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

CR:761860

CR Number:   761860 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 GA PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2014 Fixed 18 Apr 2014 Fixed Description Executing DBCC CHECKSTORAGE on an encrypted database gets aborted at the 'index chain' check.

CR:761881

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

CR:761932

CR Number:   761932 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2014 Fixed 17 Apr 2014 Fixed Description The time range restriction in Resource Governor does not allow users to add time range overlap limits even with different limit types.

CR:761934

CR Number:   761934 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2014 Fixed 17 Apr 2014 Fixed Description A 18207 error, "Illegal action 5", may be reported when executing stored procedure sp_modify_resource_limit.

CR:761958

CR Number:   761958 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2014 Fixed 17 Apr 2014 Fixed 29 Apr 2014 Fixed Description DBCC CHECKTABLE may report a 605 error, "An attempt was made to fetch logical page <pageno> from cache <name>. Page belongs to <info1> and not to <info2>" may be reported after creating an index with online option.

CR:761965

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

CR:762026

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

CR:762057

CR Number:   762057 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 ESD#3 PL1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2014 Fixed 17 Sep 2014 Fixed 02 Sep 2014 Port Not Needed Description In rare circumstances if DBCC PSS fails it may leave the pss in a kept state and cause subsequent commands to get fail with error 8601 "Process <n> tried to keep the PSS for process <m> when it already had the PSS for process <p> kept."

CR:762072

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

CR:762174

CR Number:   762174 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2014 Fixed 16 Apr 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed 16 Apr 2014 Fixed 17 Apr 2014 Fixed 18 Apr 2014 Fixed 15.7 SP111 18 Apr 2014 Fixed 18 Apr 2014 Fixed 28 Apr 2014 Fixed 18 Apr 2014 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module SearchEngine::_SeFindOptimal may be reported in the error log after a lengthy optimization, most likely after an aggregate with a GROUP BY in which the GROUP BY columns originate from multiple tables.

CR:762178

CR Number:   762178 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2014 Fixed 23 Dec 2014 Fixed Description When ansinull is off, an incorrect NULL value row could be returned when an equi-join under an OR predicate is on two columns with NULL values and the final plan is using a special OR strategy plan for the OR predicate. An example of such an OR predicate is "t1.col1 IN (1,2,t2.col2)". Workaround Description  compatibility mode or use the cmdline traceflag 16976.

CR:762199

CR Number:   762199 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 SP01 PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2014 Fixed 12 Jun 2014 Fixed 27 May 2014 Bundled Request Description The SAP ASE COTS JavaVM version (used for the Java in SAP ASE functionality) is updated to version JRE 7 update 55 for each supported platform in the sybpcidb database.

CR:762224

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

CR:762233

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

CR:762257

CR Number:   762257 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2014 Fixed 09 Jun 2014 Fixed Description When a dynamic batch insert is executed, an "infected with 11" (SIGSEGV) stacktrace may be reported in the SAP ASE errorlog. The stack trace will reference the functions tdsrecv__process_batchparam() and tdsrecv_dynamic().

CR:762262

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

CR:762266

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

CR:762281

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

CR:762349

CR Number:   762349 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2014 Fixed Description The expression -(minimum integer value) does not raise an error.

CR:762392

CR Number:   762392 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2014 Fixed 22 Dec 2014 Fixed Description In rare circumstances many processes could get locked when a dump command is trying to prune trailing holes at the end of the database. Workaround Description  1) Verify this is the problem by looking at the stack traces, either using the 'stack all' command in sybmon, or using dbcc traceon(3604) + dbcc stacktrace(<spid>) from ISQL. The processes that are hung should show the dmap_lock() module 2) Find what's the process holding the lock using DBCC DISKMAP('lock_check', <dbname>) if running a server with this fix. Otherwise, it will be necessary to execute: - dbcc dbtable(dbname) and find: lstart is logical page #; vstart is virtual (2K) page #; size is # of logical pages. Writers waiting: 0 Writer active: 0 Readers count: 1 If there was a process holding a write lock, this output would show the spid. If the problem is because someone is not releasing the read lock, once you've checked the Readers count is not 0, you have to find the process that has the read lock using dbcc pss() on each thread. ..after testing some threads... dbcc pss(0,13) ... pdmaplocks_cnt=1 pdmaplocks[0]: 0x0x14773d460 (WR: 0 R: 1) We found the process 13 has a read lock held. We have to kill it. If the process is in some killable state, that will release the lock. If the process doesn't want to die, the last chance is to do this: 1> dbcc dbrepair(test,dmap_unlock,3) 2> go Process 13 is holding a shared diskmap lock in database 'test'. It has been released.The number of diskmap readers in database 'test' was set to 1 and it has been set to 0. DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role. There wasn't any writer.

CR:762538

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

CR:762599

CR Number:   762599 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2014 Duplicate Description The SQL generated by LOAD with LISTONLY='CREATE_SQL' using AS clause contains incorrect sp_dboption <database name>. Workaround Description  Edit the results before using the generated SQL.

CR:762612

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

CR:762617

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

CR:762712

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

CR:762728

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

CR:762901

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