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

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

CR:714330

CR Number:   714330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2012 Fixed 07 Dec 2012 Fixed 17 Dec 2012 Fixed 15 Mar 2013 Fixed 18 Dec 2012 Fixed 19 Mar 2013 Fixed 03 Apr 2013 Fixed Description Add functionality to the LOAD ... WITH LISTONLY=CREATE_SQL command to include the various database options (applied with sp_dboption) and attributes (applied with CREATE and ALTER DATABASE) of the source database, in the generated SQL.

CR:714352

CR Number:   714352 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2012 Deferred Description BigDecimal value rounded to INT value when executing java through ASE JVM. This problem is not a bug but genuine implementation of the ASE Internal JDBC driver which originated from the 1.1 standard where specific functionality was introduced under JDBC 3.0. If this functionality is needed a feature request should be filed. Workaround Description  The customer could run his s/w under the external JDBC Driver which is current to date. It is understood that such is very inconvenient and not ideal with ASE_JAVA specific functionality.

CR:714355

CR Number:   714355 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2012 Fixed Description It is difficult to understand just what 'dbcc markprocs' in sp_downgrade is doing, so replace the statement in sp_downgrade with a more understandable SQL update.

CR:714466

CR Number:   714466 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2014 Added to user documentation Description The TSQL Guide incorrectly states about shared temporary tables that "The table exists until the current session ends or until its owner drops it using drop table." Shared temporary tables exist until explicitly dropped or the tempdb is rebooted.

CR:714478

CR Number:   714478 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2012 Fixed Description In some rare case, if a plan has a Hash operator in it, it could cause stacktrace in LeHashInputSet::releaseExtents(), LeHashOP::LeOpSaveIOStates() when a stored procedure or a cached statement is executed multiple times and its plan has LeHash operator. Workaround Description  set group_hashing off --this is not always going to work, only in some circumstances --or set compatibility_mode on

CR:714612

CR Number:   714612 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 Nov 2012 Fixed 14 Nov 2012 Fixed 19 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 20 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 20 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description A 2846 error, "SQL function 'dbo.sp_<function name>' not found. Specify owner.objectname or use sp_help to ..." may be incorrectly reported when a SQL user defined function created in sybsystemprocs database with a name prefixed by "sp_" is invoked from a database while a open transaction in the same database is creating a stored procedure, view, trigger, rule or default.

CR:714638

CR Number:   714638 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2012 Fixed Description monEngine connections column is wrong for kernel mode threaded.

CR:714641

CR Number:   714641 Product Name:   Adaptive Server Generic Docs Product Component:   Monitoring Tables Diagram Poster Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description monEngine column connections is not describe correctly.

CR:714670

CR Number:   714670 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2012 Fixed 27 Jul 2012 Fixed Description sp_downgrade_esd does not report tables which are configured for in-row LOB compression.

CR:714773

CR Number:   714773 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2012 Fixed 13 Aug 2012 Fixed 13 Aug 2012 Fixed 14 Aug 2012 Fixed Description In a multi-engine ASE running on the Unix platform, the tracefile for the spid (created using 'set tracefile <path> for <spid>') is truncated in pre 15.7, while the tracefile is not populated post 15.7 in process kernel mode, when the spid being traced is affiniated to an engine other than the one which created the tracefile initially (This can happen if the engine that created the tracefile is offline). Workaround Description  If possible, ensure the spid in question executed something on each engine in turn before tracing the required sql. This can be done with sp_engine online\offline. Or:- Run threaded mode (which is default anyway) if on 15.7. Or:- Run a single engine.

CR:714798

CR Number:   714798 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 ESD#2 25 Aug 2012 Fixed Description On AIX platform, ASE Cluster Edition may fail to start if logical volumes are used and I/O fencing is enabled.

CR:714806

CR Number:   714806 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2012 Fixed Description When ASE is shut down using the 'nowait' option and while data is loaded using fast bulk-copy into a table that is created with the 'for load' attribute, on ASE restart some data may be lost.

CR:714830

CR Number:   714830 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2012 Workaround Description When downgrade from 15.7ESD#2 CE to 15.7ESD#1 or GA CE, after downgrade_esd completed and reboot the 1st node with the lower version server, when booting the 2nd node, ASE will hit SIGSEGV at 1st node and hang the 2nd node. Workaround Description  There is two methods to workaround this downgrade_esd issue: 1. After sp_downgrade_esd complete for all necessary dbs, 1> sp_downgrade_esd master, 'ESD1' 2> go Reverting database 'master' to 'ESD1'. Database 'master' is now suitable for use by ESD1. (return status = 0) 1> delete master..sysconfigures where config in(563, 575) 2> go (2 rows affected) Then shutdown the server, continue the downgrade steps, replace the release with the lower version and boot the lower version server. 2. After sp_downgrade_esd complete for all necessary dbs, then reboot only one node of older server, then before bring up other nodes, run installmaster first.

CR:715048

CR Number:   715048 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) 24 Jul 2012 Fixed 02 Aug 2012 Presently Not Targeted For Any Future Release Of This Product Description Complex queries with predicates having aggregates and subqueries could lead to wrong results.

CR:715086

CR Number:   715086 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) 01 Aug 2012 Fixed Description When shutdown cluster is issued from one instance, busy user tasks running on other instances may be immediately terminated.

CR:715094

CR Number:   715094 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2012 Fixed Description A 716 error, "Unable to allocate memory of size %d bytes from the '%S_MSG' pool" may be reported when querying a partitioned view including compressed tables many times.

CR:715183

CR Number:   715183 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) 23 Aug 2012 Fixed 26 Jul 2012 Fixed 26 Jul 2012 Reservation Made Description The replication of a stored procedure for which a 'request function replication definition' has been created fails with Replication Server error 5157 indicating that the transaction owner's password is missing.

CR:715203

CR Number:   715203 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2014 Fixed 15.7 SP121 09 Jan 2014 Fixed 09 Jan 2014 Fixed 15.7 SP61 13 Jan 2014 Fixed Description DBCC CHECKSTORAGE does not detect LOB compression flag inconsistencies in the TIPSA. With DBCC CHECKTABLE and DBCC CHECKDB these types of inconsistencies were already being reported with message 15960.

CR:715228

CR Number:   715228 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2012 Fixed Description Wrong result could happen when referencing a non-correlated scalar aggregate view at the inner side of an OUTER JOIN. Workaround Description  1. set compatibility_mode on 2. Using an inner join 3. using a temp table to materialize the outer view

CR:715234

CR Number:   715234 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   AIX Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2012 Fixed Description On AIX, the monThread MDA table incorrectly indicates that the Listener thread is consuming 100% CPU.

CR:715240

CR Number:   715240 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) 13 Aug 2012 Fixed Description ASE Cluster Edition allows user to create thread pool when "max online engines" is not sufficient.

CR:715312

CR Number:   715312 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2014 Fixed 12 Mar 2014 Fixed 20 Mar 2014 Fixed 05 Jul 2014 Fixed Description Use of online utilities like 'reorg rebuild with online' might lead to incorrect used/unused counts in the OAM for the table. This is reflected by a later 'dbcc checkalloc' on the table reporting error messages 7949 and 7940.

CR:715398

CR Number:   715398 Product Name:   Adaptive Server Enterprise Product Component:   coverletter Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This PC-Client EBF is based on SDK 15.7 ESD#4. A list of changes in that SDK 15.7 ESD#4 is available at http://download.sybase.com/swr/15934/EBF20102_Buglist.txt

CR:715670

CR Number:   715670 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2012 Fixed 27 Aug 2012 One-off Provided Description CS_IODESC.name has view name instead of table name for LOB column.

CR:715785

CR Number:   715785 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2012 Fixed Description Signal 11 in set_password or sync_password

CR:715798

CR Number:   715798 Product Name:   Adaptive Server Enterprise Product Component:   mscs_ha Status:   Open OS:   Microsoft Windows NT Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When trying to launch SybCpnSrvSetup.msc results in 'bad file format' error reported with a stacktrace and subsequent unloading of the dll. Workaround Description  Use command line utility sp_companion

CR:715835

CR Number:   715835 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2012 Fixed Description Modify auditinit utility to create log file with 600 permission, instead of user's umask.

CR:715967

CR Number:   715967 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2012 Fixed Description auditinit utility requires user to enter non-null sa password for existing ASE.

CR:716047

CR Number:   716047 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) 03 Aug 2012 Duplicate Description Shared memory dump attempt fails with an infected with 11 in function shm_mergedump

CR:716054

CR Number:   716054 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Linux Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2013 Added to user documentation Description Linux Installation Guide has outdated RHEL raw device configuration information

CR:716059

CR Number:   716059 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 tables referenced in a procedure only in LOCK TABLE commands are not reflected in sysdepends or sp_depends output

CR:716165

CR Number:   716165 Product Name:   ASE Management Product Component:   Monitoring Data Collector Status:   Closed OS:   Generic Original Version:   3.2.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2012 Fixed Description Arithmetic overflow may occur causing SCC to stop monitoring the ASE.

CR:716166

CR Number:   716166 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2012 Fixed Description A 12324 error, "In database 'dbname' the server failed to open required table 'syspartitions'. Please contact Sybase Technical Support." may be reported during the execution of either LOAD DATABASE or USE <database> commands when ASE is requested to calculate threshold information by performing OAM scans.

CR:716262

CR Number:   716262 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2012 Fixed 02 Jan 2014 Added to user documentation Description On HPIA64 platforms, ASE may report error 16747, "The 'enable hp posix async i/o' configuration option is only available on the HPUX platform. This option is not valid on the current platform." if 'number of disk tasks' is set as larger than 1 when 'enable hp posix async i/o' is enabled.

CR:716284

CR Number:   716284 Product Name:   Adaptive Server Enterprise Product Component:   asecfg Status:   Closed OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2012 Fixed Description asecfg core dumps when started on Solaris x64. Workaround Description  User can run dsedit, sqlloc, sqlupgrade, and srvbuild directly.

CR:716349

CR Number:   716349 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Windows 2008 Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2012 Fixed Description In some cases, ONLINE DATABASE or DBCC CHECKDB executed on a database with large number of compressed objects might fail with error 716 (Unable to allocate memory from the compression info memory pool), when the 'compression info pool size' configuration option is set too low (e.g. the default value of 4096).

CR:716457

CR Number:   716457 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   AIX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2012 Fixed 28 Dec 2012 Fixed 21 Dec 2012 Fixed 27 Dec 2012 Fixed Description The ASE Backup Server process has a memory leak when dumping and loading databases, which causes it to grow until it exceeds the memory limit. Workaround Description  Possibly raise the user memory soft limit or recycle the backupserver frequently.

CR:716567

CR Number:   716567 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2012 Fixed 21 Sep 2012 Fixed 27 May 2014 Duplicate Description A query having MDA table monProcessObject caused signal 11 in routine mda__process_sdes() with an invalid SDES in a cursor. This CR seems a concurrency issue since another session was doing 'OPEN CURSOR' and the related internal cursor structures might be changing. May need to add more validation code in the related routine. A possible workaround is not to query monProcessObject.

CR:716609

CR Number:   716609 Product Name:   SCC Web Framework Product Component:   GUI Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2012 Fixed 13 Sep 2012 Fixed Description In SCC 3.2.7 build 4819, in the Import Resources wizard, the Confirmation page and the Import Results page are empty and does not show the imported resources. However, the resources do get imported properly.

CR:716618

CR Number:   716618 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2012 Fixed Description When use TF7751 and TF7752, sometimes it could cause stacktrace during plan printing.

CR:716642

CR Number:   716642 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   HP-UNIX Original Version:   15.7 ESD#1 Ref #2 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2012 Duplicate Description If replication is set for master device, then job scheduler will fail to boot with following message in the ASE error log file : "background task error 18388: You must be in the master database in order to run 'sp_locklogin'."

CR:716645

CR Number:   716645 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2012 Fixed 01 Oct 2012 Consult Complete 15 Oct 2012 Reservation Made 03 Nov 2012 Fixed 16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 19 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 19 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 27 Nov 2012 Fixed Description During an UPDATE command on a table that has in-row LOB columns defined, ASE may move some of these columns from in-row to off-row or vice-versa if the size of a datarow exceeds configured limits. When such a table has a datarow with an off-row LOB column that is not explicitly updated, ASE may not log this column data correctly. This will result in replication failing if this column is marked as always_replicate. Workaround Description  The work around for this problem is to mark LOB columns as "replicate_if_changed" so that only the changed column is replicated.

CR:716654

CR Number:   716654 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) 04 Sep 2012 One-off Provided 09 Oct 2012 One-off Provided 16 Dec 2013 Port Not Needed 16 Dec 2013 Port Not Needed Description Instrumentation: ASE reports a timeslice error with ksnetctlrPostWrite and ksmaskspost on the stack. Shared memory dump for the error shows a circular "Cancel Queue" leading to the timeslice error. This is instrumentation to capture diagnostic information upon any update to controller's cancel queue. Workaround Description  sp_configure "kernel mode", 0, threaded

CR:716663

CR Number:   716663 Product Name:   SCC Web Framework Product Component:   Other Status:   Closed OS:   RH Linux Original Version:   3.2.7 ESD1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2012 Fixed 13 Sep 2012 Fixed Description This resolution fixes an issue in the Collection Job History tab where it does not update correctly when schedule selected

CR:716679

CR Number:   716679 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 Aug 2012 Fixed Description When network password encryption is used and sp_passwordpolicy option 'unique keypair per session' is set to 0, client connections will fail with error message: Sybase CSI Error Message: Error generating asymmetric key. Root error: error:0906D06C:PEM routines:PEM_read_bio:no start line CT-LIBRARY error: ct_connect(): protocol specific layer: internal Client Library error: There is a tds login error. The installed encryption handler returned a status that was not CS_SUCCEED.

CR:716720

CR Number:   716720 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2012 Fixed Description Remove error # 12061 when a query is executed on an MDA Table that contains localized message text when the client is configured to use a language into which the MDA Table messages have not been translated. Specifically, if the client language is set to 'german' error 12061 will no longer occur when a query is executed on the monWaitEventInfo table.

CR:716729

CR Number:   716729 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Windows Status:   Closed OS:   Microsoft Windows NT Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2013 Added to user documentation Description Document no blanks are allowed in Install Path for Windows platform

CR:716736

CR Number:   716736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2012 Duplicate Description Error: 8210, Severity: 20, State: 2 + stack trace crt_work+0x148() run_crtable+0x294() LeWkTbl::crtWkTbl(int,short,int)+0x160() LeStoreOp::_LeOpAcquire(ExeCtxt&)+0x2a4()

CR:716798

CR Number:   716798 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2012 Fixed Description select involving aggregates and having predicated privileges defined at column level on the table could result in wrong results.

CR:716831

CR Number:   716831 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guides - All Platforms Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2013 Added to user documentation Description Add a section to the install guides that explains Optional Features and how to install them with SYSAM 2.0

CR:716870

CR Number:   716870 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2012 Fixed 11 Oct 2012 Fixed Description Adaptive Server may not kill a task that is marked for termination, which is reporting shortage of buffers in buffer pool like "cache is configured too small for current demands".

CR:716957

CR Number:   716957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2014 Presently Not Targeted For Any Future Release Of This Product 06 Jun 2014 Fixed Description In rare circumstances, a 614 error, "Adaptive Server accessed a row that has an illegal length of <value> while in data base <database>" may be reported when running DBCC FIX_TEXT on a data-only-locked table.

CR:716960

CR Number:   716960 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2012 Fixed Description ASE fails to boot on Windows Server 2012 with a stacktrace containing kiprint_os_version() on the stack.

CR:716981

CR Number:   716981 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2012 Fixed Description When the configuration option 'number of network tasks' is set to greater than 1, ASE running on HP-UX may hit infected with signal 11 (SIGSEGV) in module kstcpnetctlrCancelRequests. Workaround Description  Does not occur with 'number of network tasks' = 1 , so reset it back to to 1

CR:717026

CR Number:   717026 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2013 Fixed Description Improve spinlock efficiency on Solaris SPARC platform.

CR:717050

CR Number:   717050 Product Name:   Adaptive Server Enterprise Product Component:   sybinstall Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2012 Fixed 12 Oct 2012 Fixed Description A 3502 error, "DUMP TRANSACTION requires a dump configuration name because the configuration option 'enforce dump configuration' is enabled." may be reported during the installation of an ASE ESD release on top of 15.7 ESD #1 version while 'instmsgs.ebf' is installed and ASE uses a dump configuration. Alternatively when ASE uses a dump configuration the execution of "DUMP TRANSACTION <database> WITH NO_LOG" will fail. Workaround Description  Disable while loading instmsgs.ebf the configuration option 'enforce dump configuration'.

CR:717078

CR Number:   717078 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a ROW_NUMBER function to return the number of a row in a given ordering.

CR:717079

CR Number:   717079 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2012 Fixed 26 Sep 2012 Fixed 27 Sep 2012 Fixed 12 Nov 2012 Fixed 12 Nov 2012 Fixed Description The ASE COTS JavaVM version is updated to version JRE 6 update 33 for each supported platform in the sybpcidb database.

CR:717212

CR Number:   717212 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2012 Fixed Description An infected with 11 (SIGSEGV) stacktrace in statinit soblddolpages occurs when trying to ALTER TABLE to add a column to a table with indexes.

CR:717224

CR Number:   717224 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2012 Fixed Description Execution of sp_sysmon by a user other then "sa" can result in error 4066 when "sa" login is locked.

CR:717232

CR Number:   717232 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2012 Fixed Description When using update statistics with hashing there may be a stacktrace when the number of unique values in the column is greater than 65535.

CR:717258

CR Number:   717258 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 Oct 2012 Presently Not Targeted For Any Future Release Of This Product Description Request to be able to create key copies for login_association when logins are externally authenticated using Kerberos\LDAP

CR:717371

CR Number:   717371 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   all Original Version:   15.7 ESD#2 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2012 Bundled Request Description Feature request to allow built-in access to the java.util.concurrent class library. Workaround Description  Manually extract the classes from the core.jar file from your JVM, package them as an uncompressed jar file, and install the resulting jar file.

CR:717481

CR Number:   717481 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) 23 Aug 2012 Fixed Description If with hashing is used, and the column has more then 65535 unique values then there is a possibility that the sarg density and unique count for the column are under-estimated.

CR:717491

CR Number:   717491 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   NA Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2012 Fixed 05 Sep 2012 Fixed Description Importing data in DBISQL by selecting Data -> Import from a database menu option, fails with password length issue JZ002

CR:717492

CR Number:   717492 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ICR: 1837 error for IMDB, root cause from CSMD Workaround Description  -T1804

CR:717496

CR Number:   717496 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 Sep 2012 Fixed 21 Sep 2012 Fixed Description ASE returns error message (Msg 16341, Level 19, State 1) when split a range partitioned table when partititoning filed is a VARCHAR, DATETIME fields.

CR:717574

CR Number:   717574 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) 25 Sep 2012 Fixed Description Event ID 178's description is updated, it is wait time for client connections.

CR:717610

CR Number:   717610 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2012 Fixed Description when using hash-based statistic gathering, the default column width should be used for fixed length columns instead of being computed.

CR:717627

CR Number:   717627 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2012 Fixed Description sp_showoptstats would always display 4.00 as the default average width for any fixed length column

CR:717662

CR Number:   717662 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2012 Fixed 18 Sep 2012 Fixed Description When using fast logged bcp to insert data into a table that is marked for replication and has TEXT/IMAGE/UNITEXT columns, some TEXT/IMAGE/UNITEXT data may not be successfully replicated.

CR:717673

CR Number:   717673 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2012 Duplicate Description Allow delimited identifiers to be 255 bytes long; allow double right bracket as an escape for right bracket in bracketed identifiers; disallow embedded null bytes in identifiers.

CR:717740

CR Number:   717740 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2012 Fixed 06 Sep 2012 Fixed 17 Sep 2012 Fixed 17 Sep 2012 Fixed 20 Sep 2012 Fixed 24 Sep 2012 Fixed Description Bcp-in was failing for a table with columns more than 128 column and having one of them as text column. Workaround Description  modify text column with in-row lob option. alter table s_ec305 modify inrtgrp_tag_cont text in row(300), req_epr_tag_cont text in row (300) go

CR:717811

CR Number:   717811 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2012 Bundled Request 30 Aug 2013 Added to user documentation Description Implement "Copy Connection String" feature in DBISQL 12.0.1 Connect Dialog for ASE.

CR:717828

CR Number:   717828 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2012 Fixed 06 Nov 2012 DEFER 26 Dec 2012 Fixed Description A 9254 error, "Could not locate schema version for object id '0' in the transaction log." followed by a 9204 error, "Could not locate schema for object with id = (0), current marker (0, 0)." may be reported in the error log when inserting or updating an in-row LOB datum and the multipath distribution model is enabled. This will result in the Rep Agent Thread shutting down itself. Workaround Description  Either not use MRP feature or IRL feature.

CR:717861

CR Number:   717861 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE should report license message when setting minimally logged operations on tempdbs without a valid IMDB license.

CR:717871

CR Number:   717871 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2012 Third Party Problem Description On Solaris 10 updates earlier than Update 11 (Generic_147441-23), ASE running in kernel threaded mode might experience a temporary time shift from local time to GMT. For example, time value of 10:00 might change to 18:00 for a short period. To resolve, upgrade Solaris 10 OS to Update 11 or later.

CR:717879

CR Number:   717879 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) 31 Aug 2012 Fixed 05 Sep 2012 Fixed 26 Sep 2012 One-off Provided Description When a set role command is executed within a procedure or SQLUDF, it takes effect during the context of the procedure or UDF only. Workaround Description  None really

CR:717910

CR Number:   717910 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2012 Fixed 08 Oct 2012 Fixed Description When the built-in function GETREPDEFMODE() is called in a query involving a table, an error 622 may be reported together with a stack trace in the error log which includes the modules 'get_repdef_mode', 'open_user_table' and 'sdes_hookup'.

CR:717976

CR Number:   717976 Product Name:   SCC Web Framework Product Component:   GUI Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2012 Fixed 13 Sep 2012 Fixed Description In SCC 3.2.7 ESD1, in the Heatchart view, for a KPI is not updating properly according to the set thresholds when there is an overlap in the threshold boundaries.

CR:717984

CR Number:   717984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description implement implicit conversions char, varchar to numeric, decimal Workaround Description  // use convert function INSERT INTO t11750132 (c1) VALUES (convert(numeric(18,8), "12.34")) go

CR:718044

CR Number:   718044 Product Name:   SCC Web Framework Product Component:   Repository Status:   Closed OS:   Generic Original Version:   3.2.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2012 Fixed 05 Sep 2012 Fixed 05 Sep 2012 Fixed Description This fixes an issue where duplicate managed object hierarchy records can be created

CR:718119

CR Number:   718119 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Add support for non-class resources in JAR files within ASE Workaround Description  Non

CR:718133

CR Number:   718133 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) 22 Oct 2012 Fixed 22 Oct 2012 Reservation Made 22 Oct 2012 Fixed Description If more than one process tries to materialize a deferred table, they all will be stuck in a deadlock and only one process would succeed causing all others to rollback.

CR:718141

CR Number:   718141 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) 04 Jul 2013 Not reproducible with latest version of the product available as of Resolution Date Description wrong row count when creating an index with parallel and "with statistics using 0 values" Workaround Description  do not use with statistics using 0 values or not run in parallel.

CR:718191

CR Number:   718191 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2012 Fixed 14 Sep 2012 Fixed 14 Sep 2012 Fixed Description Error 2812 or 11214 is raised when accessing an MDA table specifically mapped as a proxy table.

CR:718203

CR Number:   718203 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2013 Not reproducible with latest version of the product available as of Resolution Date Description When stopping Job Scheduler using the undocumented sp_controljob procedure it may be possible under rare circumstances for a stack trace to appear in the error log in function upsleepgeneric() with js_wakeup() also appearing. The server will necessarily shutdown as this path holds spinlocks.

CR:718206

CR Number:   718206 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2012 Fixed 19 Sep 2012 Fixed Description If the master database has a secondary truncation point set during an upgrade from 15.0.1 to 15.7, an error 950(Database 'master' is currently offline. Please wait and try your command again later) will be raised during the upgrade. Workaround Description  The workaround is not simple and not acceptable. The customer should run preupgrade to detect the problem first, rather than get into this scenario. Customers may see the problem if 1) pre-upgrade version is 15.0.1 (If pre-upgrade release = 12.5.x, an error may be reported during preupgrade or upgrade and will not get into this scenario with the fix of CR 574227). 2) leave secondary truncation point on before apply 15.7 binary TSE Christine Zhong provided the following steps for the customer to rebuild master on pre-upgrade release 1501, load the good 1501 version of master database dump, then ignore secondary truncation point via dbcc settrunc(ltm,ignore), then upgrade to 15.7 ESD1 again: --------- 1) - Build a new master using the OLD dataserver binary. Here is the example comand: In your old environment, dataserver -d your_master_device -w master The above command will only rebuild the master database to its default stage. you will see lots messages like the following and the ASE shutdown itself down at the end. ..... 00:00000:00001:2012/09/01 17:21:04.16 server The logical pagesize of the server is 2 Kb. 00:00000:00001:2012/09/01 17:21:04.16 server Database 'master' does not exist. ASE will create it. 00:00000:00001:2012/09/01 17:21:04.16 server Database 'master': beginning upgrade step [ID 1]: Initialize disk and create empty allocation units on master device. 00:00000:00001:2012/09/01 17:21:04.16 server Database 'master': beginning upgrade step [ID 2]: Bootstrap basic system catalogs in database. 00:00000:00001:2012/09/01 17:21:04.17 server Database 'master': beginning upgrade step [ID 6]: creating index (table syspartitions, index ncsyspartitions) .... 2) - Restart your ASE in the OLD environment using -m and -T3608. Very important to use the flags. 3) - Start your backupserver and load the master dump. The server will shutdown at the end of the load. 4) - Restart your ASE in the OLD environment using -m and -T3608 and remove the truncation point. dbcc gettrunc /* just to verify that you have it set */ go dbcc settrunc(ltm,ignore) go shutdown go 5) Now you can upgrade to ASE 15.7. When I upgrade to 15.7, I restart the ASE using -m and -T3608. I can see the ASE upgrade the master without any issue. Then I shutdown the ASE and restart it normally. -------------------------------------------------- User document on rebuild master: http://manuals.sybase.com/onlinebooks/group-as/asg1251e/svrtsg/@Generic__BookView?DwebQuery=rebuild+master&DwebSearchAll=1

CR:718253

CR Number:   718253 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2014 Fixed Description Utilities like haisql, HAase agent or MSCS HA agent, connects to the ASE server, however not using login/password encryption on the network. When configuration parameter "net password encryption reqd" is set to 1/2, the utilities like haisql, HAase Agent or MSCS HA agent will fail to login to server with following errors : Msg 1640, Level 16, State 2: Adaptive Server requires encryption of the login password on the network. Msg 4002, Level 14, State 1: Login failed. CT-LIBRARY error: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

CR:718259

CR Number:   718259 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) Description Running sp_monitor will lead to an error 2812 raised via sp_monitor_server. 1> sp_monitor 2> go Msg 2812, Level 16, State 11: Server '<server>', Procedure 'sp_monitor_server', Line 57: Stored procedure '' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). Workaround Description  Re-create sp_monitor_server having removed these lines:- 55 select @whoami = object_name(@@procid, db_id('sybsystemprocs')) 56 57 exec @rtnstatus = @monprocname @whoami 58 59 if (@rtnstatus = 1) 60 return(1)

CR:718261

CR Number:   718261 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) 04 Sep 2012 Fixed Description Running sp_monitor will lead to an error 2812 raised via sp_monitor_server. Workaround Description  Re-create sp_monitor_server having removed these lines:- 55 select @whoami = object_name(@@procid, db_id('sybsystemprocs')) 56 57 exec @rtnstatus = @monprocname @whoami 58 59 if (@rtnstatus = 1) 60 return(1)

CR:718284

CR Number:   718284 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2012 Fixed Description An 823 error, "I/O error detected during wait for BUF=<value> ... cid=0 ('default data cache') ... " may be reported when an ASE 12.5.4 database dump is loaded into an in-memory database and while ONLINE DATABASE is run. This will result in a database upgrade failure.

CR:718398

CR Number:   718398 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) 27 Mar 2014 Fixed 27 Mar 2014 Reservation Made 06 May 2014 Work as design Description Update statistics options are 'sticky', meaning previous values which are explicitly set will continue to be used for future update statistics and create index commands on the same table if these options are not specified. These sticky options are: step count (using step values); histogram_tuning_factor; sampling; hashing, partial_hashing, no_hashing. This CR implements a configuration parameter "enable sticky statistics" to control statistics stickiness server wide. The default for "enable sticky statistics" is 1, which matches existing sticky statistics behavior. To turn off sticky statistics, use: sp_configure enable sticky statistics , 0

CR:718440

CR Number:   718440 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) 18 Oct 2012 Fixed Description When executing sp_dboption without any parameters to list database options, the output is hard to read due to a lot of empty spaces.

CR:718466

CR Number:   718466 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) 27 Sep 2012 Fixed Description A 1508 error, "Create index aborted on duplicate rows. Primary key is 'spinlock_p, -32768'" may be reported when running sp_sysmon and sp_sysmon runs very slowly. Workaround Description  Edit the definition of the sp_sysmon stored procedure in the sybsystemprocs database and add the following qualification to the where clause that populates the #tempmonitors table: "where field_name not in ('fglockspins','physlockspins')". This will eliminate the rows that contain many of the spinlock monitors but will also reduce the size of the #tempmonitors table and eliminate the cause of the duplicate key values. NOTE: Because this change eliminates spinlock monitor counters, the sections of this sp_sysmon report reporting spinlock usage will not be accurate.

CR:718500

CR Number:   718500 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) 29 May 2013 Insufficient priority to fix Description Illegal outer-join request gives infected 11 in oj_syboj_ojdepends_maps instead of an error.

CR:718587

CR Number:   718587 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2012 Fixed Description A task deleting rows from a DOL table in an in-memory database might wait indefinitely for an EX_LATCH by holding the SH_LATCH on the data page.

CR:718606

CR Number:   718606 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) 03 Jan 2013 Presently Not Targeted For Any Future Release Of This Product Description Enhance 696 error reporting to facilitate investigation

CR:718628

CR Number:   718628 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2012 Fixed 10 Sep 2012 Fixed Description Signal 8 can occur when the "update statistics hashing" configuration parameter is used

CR:718637

CR Number:   718637 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2012 Fixed 23 Oct 2012 Consult Complete 09 Nov 2012 Fixed Description Parallel queries with the following query plan scenario MIGHT fail with a "Command has been aborted" message and no other warnings/errors reported in the error log: (1) There is a merge-join op where one of its child trees contains a replication exchange operator. (2) There is no "draining" operator (e.g. sort operator) between the merge-join and the exchange operator. (3) The merge-join's other child drains its input stream before the child with the replication exchange does.