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

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

CR:766512

CR Number:   766512 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2014 Fixed Description sp_showplan has been extended to report optimizer timeout and optimizer timeout due to exceeding procedure cache limit.

CR:766526

CR Number:   766526 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) 10 Jul 2014 Fixed 14 Jul 2014 Fixed Description Using the statement cache, literal auto parameterization, views and instead triggers all together may result in the wrong length for text columns after the column is updated with an instead of trigger being executed. Workaround Description  Turn off literal autoparam and/or the statement cache when updating text columns

CR:766567

CR Number:   766567 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2014 Fixed 16 Jul 2014 Fixed 27 Jul 2014 Fixed Description On Solaris platforms, a 940 error "Dbtable in wrong state for operation: DBTABLE pointer = <address> , dbid = <value> ..." together with a stack trace may be reported in the error log if 'list_dump_fs' or 'get_dump_fs' attribute is queried using function db_attr() or sp_downgrade_esd is executed.

CR:766615

CR Number:   766615 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2014 Fixed 02 Jul 2014 Fixed Description When a DDL command is executed in a database where the ASE Rep Agent stream replication option is active and the session option quoted_identifier is set, the replication of this DDL command may fail when the SAP Replication Server applies it on the replicate database. Workaround Description  alter connection to RDS.RDB set dsi_quoted_identifier to 'off' go

CR:766616

CR Number:   766616 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2014 Fixed 10 Jul 2014 Fixed 10 Jul 2014 Fixed Description On the Solaris platform, when a user has created a user message and the login account of this user is dropped, then an infected with 10 (SIGBUS) stacktrace may be logged in the SAP ASE errorlog.

CR:766647

CR Number:   766647 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2014 Fixed 10 Jul 2014 Fixed 11 Jul 2014 Fixed 08 Jul 2014 Reservation Made 10 Jul 2014 Fixed 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:766666

CR Number:   766666 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A new feature request to improve sybmigrate's console error logging functionality.

CR:766673

CR Number:   766673 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2014 Fixed Description Roundrobin support index more than 255 ptn.

CR:766745

CR Number:   766745 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a method to create an RPC-based proxy table on a procedure that had one or more output parameters declared and be able to retrieve the output values in addition to the result set returned by the procedure.

CR:766751

CR Number:   766751 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) 27 Aug 2014 Fixed Description When RepAgent is configured for Multiple Paths Replication and objects bound to different paths are modified within the same transaction, a redundant 'begin transaction' may be generated by RepAgent for some of the replication paths.

CR:766763

CR Number:   766763 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 ASE may raise a 702 error (Memory request for nnnnn bytes exceeds the size of single page of 16384 bytes) if running a query which uses a view derived from a proxy table with a lot of constant values in a long expression.

CR:766770

CR Number:   766770 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) 14 Jul 2014 Fixed Description When a MERGE statement is run on a table that has an insert and an update trigger defined, the implicit execution of the triggers may cause wrong results on the target table of the insert trigger.

CR:766791

CR Number:   766791 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2014 Fixed Description BLKLIB/BCP: BLKLIB formats rows incorrectly for trailing LOB columns if In-row-LOB support is enabled and the column would have fit in-row. This may lead to corrupted row data and errors during SELECT including stack traces printed in the SAP ASE errorlog.

CR:766822

CR Number:   766822 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) 17 Jul 2014 Fixed 09 Jul 2014 Fixed 09 Jul 2014 Fixed 18 Aug 2014 Fixed 27 Aug 2014 Fixed 20 Jan 2015 Port Not Needed Description In rare circumstances, the message "current process infected with 11" in the module 'th_accounting' together with a stack trace which includes the modules 'pg_th_reserve' and 'pg_allocate_syslogs' may be reported in the error log, if an ALTER DATABASE command is executed to extend the database size and a high level of concurrent activity is taking place in the database. This may result in the SAP Adaptive Server shutting down implicitly.

CR:766882

CR Number:   766882 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) 23 Jul 2014 Fixed 23 Jul 2014 Fixed 14 Aug 2014 Fixed Description When the database option 'ddl in tran' is set, RepAgent may get infected with a timeslice error in the module 'ra_invalidate_schema' while replicating DDL commands such as 'CREATE TABLE' and 'ALTER TABLE' in a transaction.

CR:766896

CR Number:   766896 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 Jul 2014 Fixed 15 Jul 2014 Fixed Description Resolve issues revealed by Coverity for RAT code.

CR:766956

CR Number:   766956 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Microsoft Windows Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2014 Fixed Description The command LOAD DATABASE WITH LISTONLY [=FULL|=VOLUME] produces a misleading error message:"Backup Server: 4.22.1.1: Option LISTONLY is not valid for device <device_name>."

CR:766959

CR Number:   766959 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2014 Fixed Description Running 'sp_configure' to change the PCI Bridge "pci memory size" configuration parameter the ASE reports it to be a dynamic parameter and a reboot is not necessary. This is wrong. The configuration option "pci memory size" is a static configuration option. Up on change the ASE needs to be rebooted.

CR:767002

CR Number:   767002 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) 21 Oct 2014 Fixed 23 Oct 2014 Fixed 10 Dec 2014 Reservation Made 21 Oct 2014 Fixed 22 Dec 2014 Fixed Description UNION operators that contain fewer than four SELECT statements could consume a large portion and possibly all of the procedure cache if one or more of the select statements has a significant number of joins in it. This is unlikely to occur if the optgoal is allrows_oltp as fewer join pops are generated. Workaround Description  configure optimization goal 'allrows_oltp' if possible.

CR:767007

CR Number:   767007 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) 11 Jul 2014 Fixed 21 Jul 2014 Fixed Description In rare circumstances, the replication of a commit command may be discarded by SAP Replication Server mistakenly, if the SAP Rep Agent is configured to use streaming replication in either near sync or sync mode. This will prevent the Replication Servers in-bound queue from being truncated.

CR:767019

CR Number:   767019 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2014 Fixed 27 Oct 2014 Port Not Needed 11 Nov 2014 Fixed 03 Dec 2014 Fixed Description When turn on trace flag 3601, a stacktrace with exc__callprint() will be hit.

CR:767021

CR Number:   767021 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) 31 Jul 2014 Fixed 03 Sep 2014 Fixed 19 Aug 2014 Fixed 12 Sep 2014 Fixed 23 Dec 2014 Fixed 15 Oct 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 online utility like ONLINE REORG REBUILD / ONLINE CREATE CLUSTERED INDEX / ONLINE SPLIT PARTITION command was running at the time SAP ASE was shutdown with nowait or was abnormally stopped. Workaround Description  Boot the server, or LOAD DATABASE with the 3412 trace flag turned on.

CR:767045

CR Number:   767045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 325: Adaptive Server finds no legal query plan for this statement

CR:767052

CR Number:   767052 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2014 Fixed 20 Aug 2014 Fixed 13 Aug 2014 Reservation Made 01 Sep 2014 Fixed Description This provides a built-in show_cached_plan_in_html that provides metadata stored in the statement cache. The data provided is similar to the data provided by show_cached_plan_in_xml, just in a visual form through HTML, similar to "set statistics plan_detail_html".

CR:767058

CR Number:   767058 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) Description In rare circumstances a signal 11 at com__exctnume_copy may occur when executing a INSERT query. Workaround Description  Problem is not seen with 15.5 jConnect, or when HOMOGENEOUS_BATCH is set to false, or when DYNAMIC_PREPARE is set to true.

CR:767104

CR Number:   767104 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) 10 Jul 2014 Fixed 16 Jul 2014 Fixed Description In rare circumstances, the replication of the LTL purge command may be discarded by SAP Replication Server mistakenly, if the SAP Rep Agent is configured to use streaming replication irrespective to the streaming mode in use. This will prevent the Replication Servers in-bound queue from being truncated. Workaround Description  n/a

CR:767127

CR Number:   767127 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) 18 Aug 2014 Bundled Request Description The DML (insert/update/delete) messages have been changed to "row(s) affected" when a mix of DMLs are executed in a batch. Previously the first DML's message was displayed.

CR:767164

CR Number:   767164 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 If SQL statement replication is enabled on the primary database and rows on a table are updated by using rand()/rand2()/newid()/password_random() builtin functions, replicated data may appear out of sync. Workaround Description  Turn off SQL statement replication

CR:767178

CR Number:   767178 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) 24 Jul 2014 Fixed 28 Oct 2014 Fixed 28 Jul 2014 Fixed 04 Aug 2014 Presently Not Targeted For Any Future Release Of This Product Description SAP ASE may encounter SIGABRT or SIGSEGV when reading configuration (likely after a config change) resulting in a timeslice stacktrace which includes the modules mbkt_freeconfigitem, mbkt_freeconfig, cfg_readconfig. ASE may become unresponsive after encountering this problem.

CR:767188

CR Number:   767188 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2014 Fixed 11 Sep 2014 Fixed 18 Aug 2014 Fixed Description Resolve the migration of DML statements. It checks how many parts of ASE DML syntaxs can be migrated so far?

CR:767208

CR Number:   767208 Product Name:   Adaptive Server Enterprise Product Component:   sqlloc Status:   Closed OS:   Unknown Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2014 Fixed 12 Aug 2014 Not a Bug Description Update sqlloc to support new sort order 'binaryalt'

CR:767212

CR Number:   767212 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.5 ESD #5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Signal 11 in mapvarnodes after dump/load when using xml tables.

CR:767295

CR Number:   767295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2014 Consult Complete 27 Jul 2014 Fixed 29 Jul 2014 Fixed 23 Jul 2014 Port Not Needed 28 Jul 2014 Fixed 22 Aug 2014 Fixed Description When the built-in lct_admin('abort',0,<dbid>) or lct_admin('abort',<spid>) is issued on a task that is in the process of being killed and is in log-suspended state, the message "Unable to do cleanup for the killed process; received Msg 3617." may be reported in the SAP ASE error log, resulting in the killed task not freeing all of its resources. Workaround Description  1. Turn on traceflag 7419 just before issuing lct_admin('abort',..) and turn it off right after. OR 2. After lct_admin('abort',..) caused the spid to be killed, increase the log size, execute dbcc orphantables('drop') to remove orphan temporary tables.

CR:767308

CR Number:   767308 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) 21 Jul 2014 Fixed 21 Jul 2014 Reservation Made Description Sometimes a cipher operation error is encountered when database encryption is initiated.

CR:767358

CR Number:   767358 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Role fails to autoactivate, always has to be manually set on.

CR:767385

CR Number:   767385 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 In rare circumstances the signal 10 might occur when a process is being terminated and tried to disconnect nectwork connection.

CR:767390

CR Number:   767390 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2014 Fixed 15.7 SP131 09 Sep 2014 Fixed 09 Sep 2014 Reservation Made 03 Oct 2014 Reservation Made Description There may be a performance difference between pre SAP ASE 15.0 servers and post SAP ASE 15.0 servers due to the evaluation order of multiple subqueries on the same operator. Optcriteria cr767390 was introduced to order the subquery evaluation, when evaluated on the same operator, in the order that they were written in the query. Workaround Description  set compatibility_mode on

CR:767413

CR Number:   767413 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) 21 Jul 2014 Fixed 21 Jul 2014 Fixed 08 Aug 2014 Consult Complete 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 SAP ASE 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  n/a

CR:767440

CR Number:   767440 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description isnumeric('e') returns 1 indicating that conversion to int, float, money or decimal is guaranteed to be allowed, but 'e' is not accepted as a valid float, integer, or money value.

CR:767592

CR Number:   767592 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2014 Added to user documentation Description sp_dump_history database name parameter should be @name in documentation instead of @database_name.

CR:767605

CR Number:   767605 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2015 Presently Not Targeted For Any Future Release Of This Product 06 Oct 2014 Fixed 25 Sep 2014 Fixed 06 Oct 2014 Fixed 27 Oct 2014 Reservation Made 20 Oct 2014 Fixed 27 Oct 2014 Fixed 27 Oct 2014 Fixed Description UPDATE STATISTICS when run concurrently with REORG DEFRAG or TRUNCATE TABLE might end up in a state where no progress is made.

CR:767607

CR Number:   767607 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 customer see more deadlock error on their create index script on ASE 15.7 than ASE 15.0.3. Workaround Description  Customer change their create index syntax to following and it avoid the deadlocks : create index title_id_ix on titles(title_id) with statistics using 0 values ( This command re-creates the index without changing the histogram )

CR:767654

CR Number:   767654 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 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:767665

CR Number:   767665 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) 21 Jul 2014 Fixed 05 Aug 2014 Fixed Description When the sybdumptran utility is run with the option "-p header" it will display date time fields such as 'DATABASE dump ... date Thu Jul', 'Crdate:Thu Jul' or 'Dumptrdate:Tue Jul' with a truncated value where only the first 7 characters e.g. 'Tue Jul' will be displayed.

CR:767767

CR Number:   767767 Product Name:   Sybase SQL Server Product Component:   sybinit Status:   Closed OS:   Microsoft Windows Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2014 Fixed 24 Sep 2014 Already Fixed by Another CR Description sybatch doesn't create an xp server entry in INI file, and without this entry, syconfig will report "No Network Connection for Default XP Server !" when configuring existing servers.

CR:767786

CR Number:   767786 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2014 Fixed 18 Jul 2014 Fixed 28 Nov 2014 Port Not Needed Description The command DBCC PAGE will display an incorrect page if the requested page is not found in cache.

CR:767792

CR Number:   767792 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) 09 Nov 2014 Fixed 06 Nov 2014 Reservation Made 03 Dec 2014 One-off Provided 18 Dec 2014 Fixed 15 Jan 2015 Fixed Description A new dbcc command DELETE_EXTENTS has been added to delete orphaned extents. It must be used under the guidance of SAP support only.

CR:767803

CR Number:   767803 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 In rare circumstances the signal 11 might occur and because of Unrecovered tempdb.

CR:767882

CR Number:   767882 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If a global login trigger is created in a database other than master, the trigger will be disabled if any user logs in before the database containing the trigger is recovered during a reboot. Workaround Description  1) create login trigger in the master database 2) Reduce the chances of this happening by having the database containing the trigger recovered first using sp_dbrecovery_order. Users attempting to login before the trigger database was recovered would still cause the trigger to be disabled. 3) Reduce the chances of this happening by setting the sp_configure option "enable logins during recovery" to 0. System administrators would still be able to login before the trigger database was recovered and cause the trigger to be disabled.

CR:767950

CR Number:   767950 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 client_csname remains unchanged despite new ASE connection Workaround Description  Reboot ASE and login with a small sjis

CR:767954

CR Number:   767954 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2014 Insufficient Info to Progress Description In rare circumstances the Signal 11 might occur in the function ptn_clr_hintpage when SET REPLICATION ON and use the index on image/text.

CR:767966

CR Number:   767966 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2014 Fixed 28 Jul 2014 Fixed 30 Jul 2014 Fixed 31 Jul 2014 Port Not Needed 10 Dec 2014 Fixed Description Reduce the sybmgmtdb database space requirement in the Job Scheduler upgrade.

CR:768025

CR Number:   768025 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Select-query with an user-defined function returns different Tabular Data Stream (TDS) package and result set depending on "statistics io" this is an Feature request to make this compatible for the application so we return a single result set even with an UDF and "statistics io" is on.

CR:768028

CR Number:   768028 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) 01 Aug 2014 Fixed Description When a database contains more than 2,147,483,648 logical pages, certain database diagnostic tools will print very large page numbers as negative numbers instead of their proper page ID.

CR:768097

CR Number:   768097 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2014 Fixed Presently Not Targeted For Any Future Release Of This Product 18 Sep 2014 Fixed 02 Dec 2014 Port Not Needed Description The loginfo() built-in when executed with option 'can_free_using_dump_tran' may occasionally return values other than between 0 and 100 %.

CR:768168

CR Number:   768168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2014 Fixed 30 Sep 2014 Port Not Needed Description Incorrect results can be reported with 'streamlined dynamic SQL' on when using a subquery not containing a table reference to check for no rows returned. This can affect SQL constructs that include (but not limited to) isnull, nullif, case, if not exists & coalesce. This CR is resolved by CR 742233 in ASE 15.7 SP110 onwards. Workaround Description  - switch off streamlined dynamic SQL

CR:768176

CR Number:   768176 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2015 Insufficient priority to fix Description Cannot stop the Rep Agent after getting message 9254 and 9204, even though the ASE server log says that the RA has been terminated. Workaround Description  either: continue to try to stop the RA --or-- shutdown the ASE server AFTER issuing the stop with "nowait" and the RA will not attempt to start back up when the ASE is restarted. It appears that if you start back up the ASE after the initial message and without issuing the stop RA, that upon ASE startup, the RA will give the same error message, however, the RA will be stopped after the message.

CR:768198

CR Number:   768198 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2014 Fixed 16 Sep 2014 Fixed 08 Oct 2014 Fixed 04 Dec 2014 One-off Provided 19 Dec 2014 Fixed Description In rare circumstances, when the number of OAM pages for a table exceeds the value of 32767, SAP ASE may hit a stack overflow error with a stack trace which includes the modules 'pg_allocoam' and 'pg__cond_insertoam' reported in the error log. Workaround Description  Here is the recommendation: The table has hit some issue(which we are looking at) and workaround is that it can grow only if we could break into Round robin partitions of 4 or so. Here is recommendation: Just for this dba commands, Configure 'number of preallocated extents=32. (This will reduce the fragmentation of data). drop indexes on the table. (remember to have the sql of them for creation after the table is partitioned) alter table partition 4 recreate indexes on the table. Bring back 'number of preallocated extents to previous configured value. This should fix the issue the customer is having and should not occur any more.

CR:768370

CR Number:   768370 Product Name:   SySAM Product Component:   SAMreport Status:   Open OS:   all Original Version:   3.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description *** Wed Jul 30 2014 08:04:28 GMT-0400 (Eastern Standard Time) *** ahill *** Provide an application\utility replacement for SAMreport. Today, license server usage can be monitored manually by running "sysam status" command for the license server. However, this does not provide the same coverage as SAMreport. For example, in large install bases, PowerDesigner customers typically use floating licenses (FL). Therefore, they reserve a number of entitlements for specific groups and\or users in order to ensure that Power Users have access to the software when needed. Also, they need to monitor the package usage. Thus, they need the historical data.

CR:768374

CR Number:   768374 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2015 Fixed 12 Dec 2014 Reservation Made Description The replication support for tables that have default not-null non-materialized columns has been enhanced.

CR:768380

CR Number:   768380 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enable the "page diagnostic signatures" feature on ASE Cluster Edition.

CR:768463

CR Number:   768463 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2014 Fixed 08 Oct 2014 Fixed 29 Sep 2014 Fixed 22 Oct 2014 Fixed 08 Dec 2014 Fixed Description DDLGen gets EC2 SybSQLException error when -TEC -N% on a huge number of db server Workaround Description  can try the followings 1. For ase, these configurations can be increased. 'procedure cache size', stack size and 'max memory' 2. for ddlgen, ms and mx number. keep mss value is equal to mxs value. e.g. eval "$JAVA" -ms1024m mx1024m -classpath "$LIB_CONN/jconn3.jar:$LIB_CONN/dsparser.jar:$LIB_CONN/DDLGen.jar:$LIB_CONN/EccpressoFIPS.jar:$LIB_CONN/EccpressoFIPSJca.jar" com.sybase.ddlgen.DDLGenerator $*

CR:768475

CR Number:   768475 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2014 Fixed 16 Sep 2014 Fixed 11 Aug 2014 Fixed 10 Sep 2014 Fixed Description If a table created in an user database with cross database encryption and decrypt default on the column is dropped from master, the following error message "The decrypt_default for column id 2 was not found in the system catalogs." is raised to the end-user. Workaround Description  *** Thu Jul 31 2014 16:06:12 GMT-0700 (Pacific Standard Time) *** cooperg *** Dropping the table from db2 while using db2 works.

CR:768497

CR Number:   768497 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2014 Fixed 07 Aug 2014 Fixed Description The message "current process infected with 11 (SIGSEGV)" in the module 'ejrCacheClean' together with a stack trace which includes the modules 'tdsrecv__process_batchparam' and 'sequencer' may be reported in the SAP ASE error log if a Jconnect application inserts values into a numeric column as a language batch in non-BCP mode.

CR:768510

CR Number:   768510 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2014 Insufficient Info to Progress Description Database timestamp (@@dbts) jumps by a large amount unexpectedly during LOAD TRANSACTION.

CR:768580

CR Number:   768580 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) 27 Oct 2014 Not a Bug Description In rare circumstances running a LWP with a dynamic query might cause the error 701/17/3. Workaround Description  Turn off DYNAMIC_PREPARE for the DA connection and this works around the issue.

CR:768584

CR Number:   768584 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2014 Fixed 07 Nov 2014 Presently Not Targeted For Any Future Release Of This Product 10 Dec 2014 Fixed Description In SAP DBISQL if a user sets "showplan on", and the result display is in scrollable table mode and is editable, the plans for internal queries would be displayed along with the plan for the actual executed query.

CR:768596

CR Number:   768596 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 Aug 2014 Fixed 27 Aug 2014 Reservation Made 09 Oct 2014 Port Not Needed 30 Nov 2014 Port Not Needed Description A 803 error "Unable to place buffer <> from cache <> holding logical page <> in sdes for object <> - either there is no room in sdes or buffer already in requested slot." may be reported, when online parallel create index with large partition table.

CR:768663

CR Number:   768663 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.5 ESD #5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances the signal 11 might occur when try to Switch to running a new process on ASE 15.5 ESD#5.2

CR:768666

CR Number:   768666 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2014 Fixed 22 Aug 2014 Fixed 16 Sep 2014 Fixed 10 Oct 2014 Fixed Description Error message "The decrypt_default for column id <n> was not found in the system catalogs." may be raised when an encrypted column having decrypt default is decrypted using "alter table" command and the column is subsequently dropped.

CR:768722

CR Number:   768722 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) Description BIGTIME overflow seen when running Java query with streamlined dynamic SQL

CR:768780

CR Number:   768780 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2014 Fixed 17 Sep 2014 Fixed 02 Sep 2014 Port Not Needed Description REORG DEFRAG leaves the number of deleted rows in systabstats unmodified.

CR:768850

CR Number:   768850 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 Oct 2014 Fixed Description In rare circumstances converting table locktype from DOL to APL may cause data corruption if there are more than 31 variable length columns in the table and table have placement index.

CR:768853

CR Number:   768853 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2014 Fixed 11 Sep 2014 Fixed 11 Sep 2014 Fixed Description The execution of sp_addthreshold immediately after having dropped a segment with sp_dropsegment, will result in the server shutting down if the debug version of SAP ASE is used together with a stack trace which includes the modules 'th__modify_thresh_idx' and 'dbrepair' reported in the error log.

CR:768871

CR Number:   768871 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP200 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2014 Fixed Description New Feature: Add failover support for HA Aware and CE Aware clients to seamlessly failover in ASE HADR Cluster.

CR:768872

CR Number:   768872 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 Systemwide switch (traceflag) 3605 is left active if a fatal error occurs while outputting diagnostic information for an invalid column length error. A stacktrace that includes the function colleen() will be seen in the errorlog followed by SWITCH SERVERWIDE ON 3605 followed by a fatal error. Traceflag 2779 disables the function turns on this switch to output additional diagnostics on the column length error. Workaround Description  Traceflag 2779 turns off the additional reporting for collength errors and so avoids the code that switches on 3604.

CR:768880

CR Number:   768880 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) 15 Aug 2014 Fixed 15 Aug 2014 Fixed 26 Aug 2014 Fixed 22 Aug 2014 Fixed 25 Aug 2014 Fixed 18 Nov 2014 Fixed 18 Nov 2014 Fixed Description In rare circumstances a deadlock may be seen between DUMP DATABASE and DUMP TRANSACTION when these commands are executed on the same database concurrently and the configuration option "enable concurrent dump tran" is set. Workaround Description  so far, it appears setting "enable concurrent dump tran" to 0 can help reduce the chances of the deadlock. When this deadlock happens, it seems best (base on repro tests) to kill the dump database command in ASE. This made things moving again.

CR:768903

CR Number:   768903 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2014 Presently Not Targeted For Any Future Release Of This Product 10 Nov 2014 Fixed 17 Nov 2014 Fixed 19 Dec 2014 One-off Provided 23 Dec 2014 Fixed 23 Dec 2014 Fixed 23 Dec 2014 Bundled Request Description SAP ASE running on the Windows platform can suffer an access violation exception (0xc0000005) at location 0x0 with a corrupted stack.

CR:768925

CR Number:   768925 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) 27 Aug 2014 Fixed 02 Sep 2014 Fixed 03 Sep 2014 Fixed Description The upgrade of a database created on a version prior to SAP ASE 15.7 SP100 to a higher version can take a long time to create the system table SYSDAMS if the database is big and it's almost fully allocated. Workaround Description  Before attempting an upgrade, either Find some table with allocations near the beginning of the database and drop it or Create (or find) a device fragment with free space and drop "system" segment from all devices except that one. That will cause the allocation of sysdams to occur on that segment. Re-add the segments back after the upgrade completes

CR:768980

CR Number:   768980 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) 27 Aug 2014 Fixed 27 Aug 2014 Reservation Made 10 Sep 2014 Fixed 10 Sep 2014 Fixed Description GRANT DBCC MONITOR TO <user> fails with error 165 in SAP ASE 15.7 ESD2 and later versions with the error message 16 - 'Privilege DBCC monitor may not be GRANTed or REVOKEd.'

CR:769009

CR Number:   769009 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances executing a special procedure might hit signal 11 in the CT-Lib function

CR:769055

CR Number:   769055 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 IMDB: sp_cacheconfig silenty reduces requested inmemory_storage cache size.

CR:769075

CR Number:   769075 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   11.9.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2014 Fixed 18 Aug 2014 Fixed Description Then update statistics command may take additional time when a cntrl-C interrupt or a KILL spid is used. With this change, Adaptive Server will check more frequently for the termination request and gracefully exit the command in a more timely manner.

CR:769081

CR Number:   769081 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 deprecated system call warning in Linux system log

CR:769213

CR Number:   769213 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Change made with sp_dumpoptimize to have an effect even when the Backup Server is restarted.

CR:769222

CR Number:   769222 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) 15 Aug 2014 Fixed by Integrated Component Description The version of OpenSSL used in this release has been upgraded to OpenSSL 1.0.1g

CR:769243

CR Number:   769243 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2014 Fixed 26 Aug 2014 Fixed 18 Sep 2014 Fixed Description When the loginfo() built-in is executed with any of the following options, oldest_active_transaction_pct, stp_span_pct or can_free_using_dump_tran, it may return an incorrect value of 0.

CR:769247

CR Number:   769247 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2014 Fixed 17 Nov 2014 Fixed 16 Dec 2014 Fixed Description Sometimes concurrent DMLs will fail when using online CREATE INDEX.

CR:769260

CR Number:   769260 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2014 Fixed 22 Aug 2014 Fixed 27 Aug 2014 Fixed 18 Nov 2014 Fixed 18 Nov 2014 Fixed Description In SAP ASE Cluster Edition, if a node crashes when a process on this node is in the middle of load database, node failover recovery may hang and not be able to complete.

CR:769444

CR Number:   769444 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2015 Fixed Description Error 832 when 'max buffers per lava operator' is set to maximum config value 65535 (or very close to max value). Workaround Description  Lower 'max buffers per lava operator' value.

CR:769463

CR Number:   769463 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2014 Fixed by Integrated Component 12 Dec 2014 Fixed by Integrated Component 12 Dec 2014 Fixed by Integrated Component Description When SSL is used with a select or bcp out and the result set is large, ASE may send badly formatted data. The bad format is reported by the client message: ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received. Workaround Description  WorkAround: -------------- With ssl disabled these functions will work. Customer disables the ssl on ASE to perform their critical batch jobs and then switch it on for lesser intensive activity (low volume).

CR:769509

CR Number:   769509 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances the timeslice error might raise after onlining an additional engine.

CR:769528

CR Number:   769528 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If optimization goal is allrows_dss or advanced_aggregation optcriteria is on, a query having a derived table and involving aggregation may encounter a segmetation violation at GcvIsVIrtualColumn(). Workaround Description  set advanced_aggregation off

CR:769607

CR Number:   769607 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) 03 Oct 2014 Fixed 10 Nov 2014 Fixed Description When creating a partitioned table with a large number of partitions (greater than 3000) and a large number of local indexes (greater than 10) then a 702 error may result.

CR:769627

CR Number:   769627 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2014 Added to user documentation Description The 15.7 System Administration Guide indicates that the sp_configure parameter "max online engines" in threaded mode accepts values from 1-1024. This parameter is actually limited to 128 in both process and threaded modes until the 16.0 release.

CR:769653

CR Number:   769653 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2014 Presently Not Targeted For Any Future Release Of This Product 09 Oct 2014 Fixed 16 Oct 2014 Fixed 03 Dec 2014 Fixed 22 Dec 2014 Fixed Description Sybmigrate supports the ASE 15.7 SP130 new features: HADR and 'Resolve as owner' on Stand By server.

CR:769697

CR Number:   769697 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) 27 Aug 2014 Fixed 14 Sep 2014 Fixed Description When SHOW_SQLTEXT is set on and the text of the SQL command is long, there can be multiple "SQL Text:" messages displayed in the reported SQL text.

CR:769721

CR Number:   769721 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) 04 Sep 2014 Fixed 04 Sep 2014 Fixed 30 Nov 2014 Port Not Needed Description On the HPIA platform, online CREATE INDEX may fail with a 2601 "Attempt to insert duplicate key row in object 'syspartitions' with unique index 'csyspartitions'" error.

CR:769727

CR Number:   769727 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) 15 Sep 2014 Fixed 23 Sep 2014 One-off Provided 22 Oct 2014 Fixed 06 Nov 2014 Fixed Description Error 706 (Process <n> tried to remove PROC_HDR <addr> that it does not hold in Pss.) and 913 (Could not find row in sysdatabases with database id <n>.) may be reported for the following scenarios 1) Predicated Privileges are not being automatically re-normalized after being loaded from a dump. 2) When a predicated privilege fails to re-compile, the exception handling incorrectly cleans up leading to 706 errors. Workaround Description  Run the update index stats, revoke/grant the predicates and then the select query,it works

CR:769772

CR Number:   769772 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2014 Duplicate Description In rare circumstances the signal 11 occured when executin a LWP of INSERT INTO ... 126 UNION SELECT DISTINCT statements on ASE 15.7 SP122