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

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

CR:718658

CR Number:   718658 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2012 Fixed 01 Oct 2012 Fixed Description A signal 11 (SIGSEGV) error occured in kmuxtskGetThreadpool() while running sp_sysmon. This is a timing-related issue that is not easy to reproduce. It occurs only on a server that is running in threaded kernel mode.

CR:718696

CR Number:   718696 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2012 Fixed 11 Oct 2012 Fixed Description When an AP plan clause is specified as part of a dynamic SQL prepare statement, the plan clause is not saved in the statement cache when such statement is cached under enable functionality group or streamlined dynamic SQL.

CR:718710

CR Number:   718710 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2012 Fixed 03 Oct 2012 Fixed 26 Apr 2013 Fixed Description The message "current process infected with 11" in the module 's_begupdate' together with a stack trace which includes the modules 's_execute' and 'execproc' may be reported in the error log when a stored procedure executes a DML statement which was compiled at runtime. Workaround Description  Turning off deferred compilation works around the issue.

CR:718714

CR Number:   718714 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 May 2013 Insufficient priority to fix Description During execution of a java class within ASE that uses the internal jdbc driver, sybase.asejdbc.ASEDriver, it is possible under rare circumstances that a particular statement encounters a specific error and that spid may hit an error 1265 and a stack trace will appear in the ASE error log. This will terminate the jvm thread. This can and will leave the ASE in an inconsistent state and will require a restart. Error: 1265, Severity: 20, State: 1 An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr=0x0x14a01f000, lrmagic=f).

CR:718733

CR Number:   718733 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) 17 Apr 2014 Fixed 12 Apr 2014 Reservation Made 12 May 2014 Fixed 12 May 2014 Reservation Made 19 May 2014 Fixed 19 May 2014 Reservation Made Description Support a 'WITH RECOMPILE' clause at the statement level.

CR:718741

CR Number:   718741 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) 11 Oct 2012 Fixed 12 Nov 2012 Fixed 16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 05 Dec 2012 Fixed Description Signal 11 in bufdlink() *also reporting ups_nosort_init_prestat() & us_allocate_stat_proc_hdr() * may appear in the error log along with the server shutting down. This can happen when there is a worktable used by an update statistics command that resides on an in-memory tempdb (IMDB) Workaround Description  Use trace flag 2744, but do not enable hash stats, either partial or full hashing, after turning on this trace flag.

CR:718778

CR Number:   718778 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2012 Fixed 01 Oct 2012 Consult Complete 05 Nov 2012 Fixed 05 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 Description The message "current process infected with 11" in the module 'ra__process_xchange' together with a stack trace which includes the modules 'decompress_row' and 'decompress__crow_to_apl' may be reported in the error log, after an alter table with no datacopy command is run on a table that has compressed data, and while the replication agent task is attempting to decompress data to be sent to the Rep Server. Workaround Description  The work around for this problem is to not execute alter table drop column with no datacopy command when using row or page level compression. However if this command was run then before using replication you can execute reorg rebuild command as it will remove the data for the unused (dropped) columns from this table and avoid the problem from occurring.

CR:718876

CR Number:   718876 Product Name:   Adaptive Server Enterprise Product Component:   sybdiag Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2012 Fixed 13 Sep 2012 Fixed Description sybdiag fails with an unhelpful error on Solaris when the SYBASE_JRE6 environment variable is not set

CR:718945

CR Number:   718945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare conditions DEADLOCKs may occur involving 'sysqueryplans' if users attempt to clear query metrics using "sp_metrics 'drop', '1'" while query metrics gathering is enabled. Workaround Description  Dis-able query metrics while running sp_metrics 'drop' command.

CR:718966

CR Number:   718966 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 Bringing ASE JVM to latest JDBC spec. to bring in the BigInteger scaling functionality which was introduced when Java RC2 arrived.

CR:718982

CR Number:   718982 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 ESD#2 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Cross platform load works serially when updating pages on very large databases meaning a very long time before database can be onlined. Parallelism is requested.

CR:719019

CR Number:   719019 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 Sep 2012 Fixed 18 Sep 2012 Fixed 19 Sep 2012 Fixed 17 Sep 2012 Fixed Description An argument to error message 103 (The <msg> that starts with '<string>' is too long. Maximum length is <n>.) is too long. The argument needs to be truncated.

CR:719023

CR Number:   719023 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2012 Fixed 19 Sep 2012 Fixed Description The error message "A00: SYBMULTBUF ERROR: Internal error: The number of archive strings in the database info file exceeds the maximum number of allowed stripes." may be reported by the backupserver when an attempt to execute a DUMP TRANSACTION command with many STRIPE ON clauses is made.

CR:719124

CR Number:   719124 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 Sep 2012 Bundled Request Description ALTER TABLE SPLIT raises errror 16341 for range partitioning when it is based on DATETIME values.

CR:719138

CR Number:   719138 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2012 Fixed 09 Oct 2012 Fixed Description The ASE server fails to boot on the HP-UX IA64 platform in Process mode if Kerberos is enabled.

CR:719162

CR Number:   719162 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) 18 Sep 2012 Fixed 19 Sep 2012 Fixed Description When using fast logged bcp to insert data into a table that is marked for replication and has compressed TEXT/IMAGE/UNITEXT columns, the compressed TEXT/IMAGE/UNITEXT data may not be inserted successfully and the bcp command fails.

CR:719176

CR Number:   719176 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) 07 May 2013 Fixed 08 May 2013 Fixed 08 May 2013 Fixed 08 May 2013 Fixed 08 May 2013 Fixed Description Unable to drop/delete/remove the SCC login user.

CR:719212

CR Number:   719212 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2013 Fixed 27 Feb 2013 Reservation Made 15.7 SP50 11 Apr 2013 Fixed 02 Apr 2013 Fixed 03 May 2013 One-off Provided 03 May 2013 One-off Provided Description Applications running against ASE on Solaris platform (SPARC and x64) in threaded mode may experience poor performance (response time and throughput). Analysis of sp_sysmon outputs and MDA tables may show high I/O Busy% and high wait times on disk-related events. Solution requires installation of OS patch for Oracle Bug 16054425 and setting ASE configuration parameter "solaris async i/o mode" to 1. This issue only affects ASE on the Solaris platforms. Workaround Description  no workaround.

CR:719290

CR Number:   719290 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2012 Fixed 07 Jan 2013 Fixed Description When DUMP DATABASE or DUMP TRANSACTION is run to a tape device, if the tape device configuration file backup_tape.cfg exists, ASE will not be able to read it and the dump will fail. The Backup Server will report an error: "The format of the device configuration file <$SYBASE>/backup_tape.cfg is invalid. Remove the configuration file and reconfigure the device by issuing a DUMP with the INIT qualifier. Return code = 0". Workaround Description  A possible workaround is to delete the tape configuration file backup_tape.cfg and run DUMP DATABASE or DUMP TRANSACTION using the INIT option. ASE will recreate the tape configuration file. However this will not allow to append the DUMP to existing DUMP files on this same tape device.

CR:719295

CR Number:   719295 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Windows Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Dec 2013 Added to user documentation Description Docs: Infomaker Powerdesigner, Powerbuilder are not certified on win2008 R2

CR:719361

CR Number:   719361 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) 08 Oct 2012 Fixed Description The reported database name is truncated to 20 characters when executing sp_dbrecovery_order for a database with database name longer than 20 characters.

CR:719374

CR Number:   719374 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2012 Fixed Description When changing the character set to a multibyte character set and running DBCC FIX_TEXT for the table with TEXT columns, the DBCC CHECKTABLE will fail with error 7951, "Data size mismatch while checking a text value".

CR:719389

CR Number:   719389 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2012 Fixed Description In sybmon, shared memory dump will not be compressed if "memory dump compression level" is set as 0 although the "memdump compress" command is executed explicitly.

CR:719399

CR Number:   719399 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2012 Fixed 07 Nov 2012 Fixed Description When the followng three conditions are met: - the SQL statement has enough predicates to generat at least 400 SARGs and - the SQL statement is executing at isloation level 0 (dirty reads) and - a unique index with at least 10 columns is chosen by the optimizer to use for repositioning the scan, A 702 error can be raised with the function, setupSargArray in the call stack.

CR:719408

CR Number:   719408 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2012 Added to user documentation Description doc request: include one more line in "what sybmigrate does not do" = downgrade

CR:719449

CR Number:   719449 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows 2008 Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2012 Fixed 29 Oct 2012 Fixed 17 Nov 2012 Fixed 17 Nov 2012 Fixed 16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description Adaptive Server may encounter a storage access violation error when query execution is interrupted or some special query is executed on 64bit diagsrvr.exe or 32bit sqlsrvr.exe on windows platform.

CR:719532

CR Number:   719532 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2012 Fixed 21 Sep 2012 Fixed Description When GP (Granular Permissions) is enabled, booting ASE could result in a 10331 (Permission denied..) error.

CR:719560

CR Number:   719560 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) 03 Dec 2012 Fixed Description On ASE Cluster Edition Solaris platform, when a user with sa_role executes 'set role sa_role on' followed by 'alter thread pool' command, the login connection hangs with following message in the error log: "There is no thread pool named '' defined in the system." Workaround Description  For Solaris SDC Workaround is : 1. Do not set sa_role explicitly : i.e. "set role sa_role on ". The sa_role is by default on if granted. 2. when user wants to alter a thread pool , sa user may execute it instead of user with sa_role granted.

CR:719597

CR Number:   719597 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) 12 Oct 2012 Fixed Description Report the compressed shared memory dump file size and configuration setting in the sp_shmdumpconfig stored procedure.

CR:719616

CR Number:   719616 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) 26 Sep 2012 Fixed Description When ASE Cluster Edition is configured error message 969 "You can access database '<db>' only from its owner instance.." is not being raised when the sp_ddlgen_permissions stored procedure accesses a tembdb on another instance. Errors such as 567 "You must have the following role(s) to execute this command/procedure.." or 17230 "You must be the System Administrator (SA) or the Database Owner (dbo) to execute this procedure" were reported instead.

CR:719639

CR Number:   719639 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) 01 Oct 2012 Consult Complete 09 Oct 2012 Bundled Request Description The message "Missing datarow in TEXT/IMAGE/UNITEXT insert log record. Transaction log may be corrupt." may be reported when attempting to replicate data after an alter table drop column with no datacopy command is run on a table with LOB data. Workaround Description  The work around for this problem is to not execute alter table drop column with no datacopy command when using row or page level compression. However if this command was run then before using replication you can execute reorg rebuild command as it will remove the data for the unused (dropped) columns from this table and avoid the problem from occurring.

CR:719643

CR Number:   719643 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) 21 Sep 2012 Fixed 21 Sep 2012 Fixed Description If hash based statistics collection is used with a large number of steps, then a stack trace in the function ups_stat_memalloc() may be encountered.

CR:719673

CR Number:   719673 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) 18 Oct 2012 Fixed 06 Nov 2012 Bundled Request Description A 14108 error, "Could not find partition descriptor for objid %d, indid %d, ptnid %d in dbid %d" may be reported when running DBCC DBREBOOT if traceflag 12315 is off. Workaround Description  Turn on traceflag 12315 to disable caching dbtables in pss can avoid the problem. 1> dbcc traceon(12315) 2> go but if the problem already has occurred and the database is marked suspect and cannot be accessed. 1> use test 2> go Msg 926, Level 14, State 1: Line 1: Database 'test' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the ASE errorlog for information as to the cause. you need to unset the suspect mark following the steps as below. 1> use master 2> go 1> sp_configure "allow updates", 1 2> go 1> sp_resetstatus test 2> go Database 'test' status reset! WARNING: You must reboot Adaptive Server prior to accessing this database! 1> sp_configure "allow updates", 0 2> go The definition of sp_resetstatus is as below CREATE PROC sp_resetstatus @dbname varchar(30) AS DECLARE @msg varchar(80) IF @@trancount > 0 BEGIN PRINT "Can't run sp_resetstatus from within a transaction." RETURN (1) END IF suser_id() != 1 BEGIN SELECT @msg = "You must be the System Administrator (SA)" SELECT @msg = @msg + " to execute this procedure." PRINT @msg RETURN (1) END IF (SELECT COUNT(*) FROM master..sysdatabases WHERE name = @dbname) != 1 BEGIN SELECT @msg = "Database '" + @dbname + "' does not exist!" PRINT @msg RETURN (1) END IF (SELECT COUNT(*) FROM master..sysdatabases WHERE name = @dbname AND status & 256 = 256) != 1 BEGIN PRINT "sp_resetstatus may only be run on suspect databases." RETURN (1) END BEGIN TRAN UPDATE master..sysdatabases SET status = status - 320 WHERE name = @dbname IF @@error != 0 OR @@rowcount != 1 ROLLBACK TRAN ELSE BEGIN COMMIT TRAN SELECT @msg = "Database '" + @dbname + "' status reset!" PRINT @msg PRINT " " PRINT "WARNING: You must reboot Adaptive Server prior to " PRINT " accessing this database!" PRINT " " END

CR:719678

CR Number:   719678 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) 03 Dec 2012 Fixed Description Under some circumstances, in a Shared Disk Cluster environment, sessions may hang because space usage on the segment has been put incorrectly in a freeze state, owing to threshold manager limits being mistakenly hit when they should not have been.

CR:719683

CR Number:   719683 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2012 Bundled Request 17 Dec 2012 Fixed Description A 3223 error, "Attempt to read a dump header failed; returned error code is 12." followed by a 3208 error, "Unexpected end of file while reading beginning of dump. Please confirm that dump media contains a valid ASE dump. The ASE error log may contain more information on the problem." may be reported due to a corrupted dump header while loading a database dump that was taken on ASE 15.7 ESD#2 and the database was created with a template.

CR:719696

CR Number:   719696 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 dbcc checkcatalog to check the value and range for suid,uid,gid in sysusers. Workaround Description  Delete or update the row in sysusers.

CR:719716

CR Number:   719716 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 Add a better error messages for grant permission role when it hit 2601 insert duplicate key row in object 'sysusers' Workaround Description  // correct sysusers.

CR:719722

CR Number:   719722 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) 27 Sep 2012 Fixed Description The values for the IOTime column in the monIOQueue table are incorrect.

CR:719728

CR Number:   719728 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2013 Added to user documentation Description Improve documentation of sp_chgattribute 'identity_burn_max' option.

CR:719752

CR Number:   719752 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) 25 Sep 2012 Fixed 01 Oct 2012 Fixed Description When GP (Granular Permissions) is enabled, booting ASE could result in 16802 (You must have the following permission to execute this command/procedure..) error.

CR:719785

CR Number:   719785 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE15.7 can be upgraded using ASE12.5.4 or later.

CR:719838

CR Number:   719838 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) 28 Sep 2012 Fixed Description Executing the incorrect syntax 'grant execute on set_appcontext to <user>' causes a system exception (signal 11) referencing 'grrev_nullflush'. The command should be 'grant SELECT ...' Workaround Description  Don't use illegal syntax 'grant execute'. It should be grant SELECT on set_appcontext

CR:719859

CR Number:   719859 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) 26 Sep 2012 Fixed 26 Sep 2012 Fixed Description If data row decompression is used, then update index statistics may be slower since an unnecessary data row decompression is performed.

CR:719911

CR Number:   719911 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) 11 Oct 2012 Fixed Description DDLGen is not backward compatible for archive databases in ASE 15.7 ESD#2

CR:719915

CR Number:   719915 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2012 Fixed Description DDLGEN fails to include the LOB_COMPRESSION attribute when run on a database that was upgraded from ASE 15.0.3.

CR:719961

CR Number:   719961 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) 24 Oct 2012 Fixed Description Under some rare cases, a signal 11 (SIGSEGV) could occur in open_byname() when executing nested stored procedures.

CR:720002

CR Number:   720002 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Ref #2 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2012 Not reproducible with latest version of the product available as of Resolution Date 03 Oct 2012 Not reproducible with latest version of the product available as of Resolution Date Description Error 1120, 803 with sp_helpdb on a database with a cache binded Workaround Description  Do not bind a cache to the database.

CR:720139

CR Number:   720139 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) 16 Oct 2012 Fixed Description When doing upgrade using upgrade utilities or downgrade for such databases which name contains blank or tab character, upgrade utilities or sp_downgrade/sp_downgrade_esd will report syntax error on the database name.

CR:720162

CR Number:   720162 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 01 Oct 2012 Insufficient priority to fix Description When the system stored procedure sp_help_rep_agent is executed with no parameter or a null value for @dbname, error message 18374 may be unexpectedly printed with an empty database name.

CR:720196

CR Number:   720196 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Tables Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2012 Added to user documentation Description a new column called predid is introduced in sysloginroles but its not documented. This info need to add to user documentation.

CR:720215

CR Number:   720215 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SQL statement replication, extra WHERE clause added when SET statement contains a column that has a rule.

CR:720222

CR Number:   720222 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 May 2013 Not a Bug Description MERGE INTO sets @@rowcount to the number of rows scanned from the USING table rather than the number of rows affected (inserted/updated) in the INTO table.

CR:720224

CR Number:   720224 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) 11 Oct 2012 Fixed 12 Oct 2012 Fixed 23 Oct 2012 Deferred Description Errors 7961 and 2759 are raised when a variable is used in a GRANT ROLE predicate definition. The errors are raised correctly but the wording is cryptic.

CR:720313

CR Number:   720313 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2012 Fixed 26 Dec 2012 Fixed 08 Jan 2013 Fixed Description ASE 15.7 fails to start during upgrade from ASE 12.5 due to the lack of enough ASE kernel resource memory being reserved. Workaround Description  Set below config parameters to default and it allowed 15.7 to startup fine . >>> original values: number of user connections = 500 number of open objects = 300000 >>> updated values: number of user connections = DEFAULT number of open objects = DEFAULT

CR:720390

CR Number:   720390 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 Feature Request: DBCC REINDEX to use a seperate transaction per index instead of one for all indexes.

CR:720417

CR Number:   720417 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) 02 Oct 2012 Fixed Description If the user does not have sso_role when running installmaster, the message "You must possess System Security Officer (SSO) role to run the installmaster script" will be displayed when on a Cluster Edition server instead of "You must possess System Administrator (SA) role, System Security Officer (SSO) role, Sybase Technical Suport role and Monitor and Diagnosis role to run the installmaster script."

CR:720522

CR Number:   720522 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2012 Added to user documentation Description doc: sp_sysmon syntax missing "clear" option

CR:720608

CR Number:   720608 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) 20 May 2013 Not reproducible with latest version of the product available as of Resolution Date Description query terminates signal 4 in StatObject::StatJoinObjects with allrows_dss with a larger default data cache. Workaround Description  do not use allrows_dss or decrease data cache

CR:720635

CR Number:   720635 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature Request: sysaudits extrainfo column to allow more than 255 characters

CR:720655

CR Number:   720655 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 Oct 2012 Fixed Description If running:- sp_restore_system_role 'sa_serverprivs_role' after having re-created 'sa_serverprivs_role' and the role id for 'sa_serverprivs_role' is greater than 99, you will receive error 265 Msg 265, Level 16, State 1: Server 'UBUSAP', Procedure 'sp_restore_system_role', Line 202: Insufficient result space for explicit conversion of INT value '100' to a VARCHAR field. (return status = -6) Workaround Description  Re-create the sp_restore_system_role procedure with a wider varchar field to hold the conversion of the role id. exec sp_configure 'allow updates', 1 go sp_helptext 'sp_restore_system_role', null,null, 'showsql,ddlgen' go /*modify the ddl of the proc changing line 202 to this:- select @rvkcmd = "delete " + "master.dbo.sysattributes " + " where class = 8" + " and attribute = 2" + " and object = " + convert(varchar(3), role_id(@rolename)) Then run the script to re-create the proc. */

CR:720659

CR Number:   720659 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2012 Fixed 23 Oct 2012 Reservation Made 06 Nov 2012 Fixed Description There may be very slow optimisation of queries with large IN clauses or excessive stack usage with aggregate queries with large IN clauses.

CR:720703

CR Number:   720703 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) 10 Oct 2012 Fixed 12 Oct 2012 Fixed 05 Nov 2012 One-off Provided 13 Nov 2012 Fixed 15 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 15 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 15 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description The first row insertion into DOL table might lead to in-correct emptypgcnt value in SYSTABSTATS due to '0' emptypgcnt set by the task creating the index on empty DOL table.

CR:720934

CR Number:   720934 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 Inconsistent\unpredictable multi attribute costing and diagnostics. Multi-attribute costing can lead to some undesired estimates in both search engine evaluation and plancost outputs.

CR:720951

CR Number:   720951 Product Name:   ASE Management Product Component:   Monitoring Data Collector Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2012 Bundled Request Description SCC Arithmetic Overflow error 3606 raised when Monitoring Datacache

CR:720971

CR Number:   720971 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 On ASE Cluster Edition, a user connection may not execute the global login trigger.

CR:720980

CR Number:   720980 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2012 Fixed 12 Oct 2012 Fixed 04 Jan 2013 Fixed Description In rare circumstances, ASE might report a signal 11 (SIGSEGV) in collectMonCSInfo() when querying the monCachedStatement MDA table.

CR:721003

CR Number:   721003 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2012 Fixed Description When downgrade from 157ESD#3 or later version to pre-155, downgrade prepare step will fail with error message "ERROR: Cannot downgrade to '15.0.0.0' server, which does not support bigdatetime and bigtime datatypes."

CR:721028

CR Number:   721028 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description NFR: allow optdiag stats extraction without sa_role and add optdiag insert and optidiag extract to granular permission options.

CR:721093

CR Number:   721093 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2012 Fixed Description The informational error 16833 was added to extend parallel diagnostics. This error provides a CSMD point to dump the system state at the point that parallel primary error processing begins. At this point, all of the parallel family's state is available for diganostic analysis.

CR:721144

CR Number:   721144 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 Oct 2012 Fixed 07 Nov 2012 Fixed 05 Nov 2012 Fixed 08 Nov 2012 Fixed 16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description If Java in the database is being used, then if the "same" shared configuration file is used by more than one instance or Server, then there is a race condition during JVM initialization where it is possible that the message current process infected with signal 11 in the function jvminit may be reported in the error log, followed by the message Failed to initialize Java services". This may result in ASE shutting itself down. Workaround Description  This issue can be avoided by any of: 1. Not using the Java in the database feature or by disabling the PCI. 2. Making sure that all instances/Servers use a differently identified configuration file so that no two instances/Servers will try to use the same physical java initialization file. e.g. Where the configuration file used is <path name>/config_file.cfg the java initialization file used temporarily during the JVM initialization will have the .cfg replaced with a different suffix. Note that multiple ASEs can used exactly the same path names as long as physically different files are involved, such as if the paths are local. 3. Starting the servers/instances sequentially and manually initializing the Java services by running a simple Java query like select java.lang.Math.sqrt(1) before making the server/instance generally available. If a Server/instance is restarted, then this operation will need to be repeated.

CR:721269

CR Number:   721269 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 Jun 2013 Duplicate Description Add support for use of LIKE clause in an immediate PRS. Currently this is not supported as LIKE clause uses a built-in function to do its processing. This will lead to error 7721. Msg 7721, Level 16, State 6: Server 'xxxx', Line 1: Precomputed result set definition error: Immediate PRS with built-ins is/are invalid or not allowed; no PRS has been created. Workaround Description  Use manual refresh PRS:- create materialized view <name> t1mv manual refresh as select <statement containing LIKE clause>

CR:721270

CR Number:   721270 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) 09 Dec 2012 Fixed Description Immediate PRS creation with a LIKE clause throws a misleading error message that involves a builtin clause, because LIKE is internally converted to a BUILTIN operator.

CR:721278

CR Number:   721278 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) 12 Oct 2012 Fixed 12 Oct 2012 Fixed Description A 691 error "Encountered invalid logical page '0' while accessing database ... This is an internal system error ..." may be reported in the error log followed by a stack trace which includes the functions 'set_repdb_status', 'txtimg_upd_table' and 'pg_oamscan_startscan' if a database that has the option "deferred table allocation" set is being marked for replication with SP_REPTOSTANDBY and the 'all' option. Workaround Description  N/A

CR:721289

CR Number:   721289 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) 05 Nov 2012 Insufficient priority to fix Description Feature Request: sp_helprotect to report from type of action (select, delete, etc) perspective

CR:721291

CR Number:   721291 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Tables Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2012 Added to user documentation Description Change description of monTask in MDA table description to remove SPID\KPID, these columns do not exist in this table.

CR:721294

CR Number:   721294 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2012 Bundled Request Description Feature request to have DBISQL INPUT and OUTPUT commands support current EXCEL file formats (i.e. Excel .xlsx, .xlsm, .xls).

CR:721296

CR Number:   721296 Product Name:   Adaptive Server Generic Docs Product Component:   In-Memory Database Users Guide Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2012 Added to user documentation Description FR 721403 has been opened to address the sp_helpdb output being the same for explicit and implicit. However, a warning in the IMDB users guide and ref manual should be created

CR:721375

CR Number:   721375 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2012 Added to user documentation Description dump configuration command misses out "to dump_dir"

CR:721386

CR Number:   721386 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   NA Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2012 Added to user documentation Description dump database shoud have "using config" not "configuration" in documentation.

CR:721403

CR Number:   721403 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 02 Apr 2013 Fixed 25 Feb 2013 Fixed Description The status field in sp_helpdb output does not give any indication for temporary databases created with durability of "no_recovery" and normal temporary databases. Workaround Description  drop and recreate the tempdbs that fail to come online after the grace period. They were created explicitly with durability=no_recovery

CR:721482

CR Number:   721482 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) 02 Jan 2013 Fixed Description sp_configure "o/s file descriptors" may show a larger value than the actual number of file descriptors as indicated in the error log.

CR:721500

CR Number:   721500 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) 17 Oct 2012 Fixed 07 Nov 2012 Fixed Description ASE is not able to boot with more than 50 thread pools

CR:721543

CR Number:   721543 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2012 Fixed Description When using a resource file with sybmigrate, despite having plenty of room on the repository device specified, sybmigrate does not create the work database at the size specified in the resource file.

CR:721559

CR Number:   721559 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) 09 Nov 2012 One-off Provided 12 Dec 2012 One-off Provided 29 Nov 2012 Fixed Description On AIX, if ASE threaded kernel mode is being used, then ASE may report a SIGSEGV in mda_nap_start along with a "Scheduler infected: exiting" message in the ASE errorlog.

CR:721594

CR Number:   721594 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.7 ESD#2 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2012 Fixed 18 Oct 2012 Presently Not Targeted For Any Future Release Of This Product 16 Jan 2013 Fixed Description If plan sharing is enabled, an error 8210 "Duplicate of work table descriptor found in the id hash table for temporary object <n>." with stacktraces including des_wkinstall() and crt_work() may be reported in the ASE errorlog. Workaround Description  Disable plan sharing: sp_configure 'enable plan sharing', 0 go

CR:721620

CR Number:   721620 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 Nov 2012 Fixed Description Msg 2601 duplicate key on 'sysindexes' with unique index 'csysindexes' when dropping and recreating constraint on a partitioned APL table changed to DOL locking scheme. Workaround Description  - change table to APL, drop and recreate constraint, change back to DOL or - manual update row with indid = 0 and status3 = 8 TO status3 = 0 followed by dbcc cacheremove (dbid, objectid)

CR:721627

CR Number:   721627 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 Request to extend support predicated privileges on views in circumstances where view and referenced table have an ownership chain available. Also to support grantable predicated privileges on views directly.

CR:721628

CR Number:   721628 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 Extend 'execute as caller' functionality to triggers\UDFs to allow predicated privileges to be respected on referenced tables where there exists an ownership chain between trigger\UDF and referenced table.

CR:721665

CR Number:   721665 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description You are about to upgrade your server to 15.x. Are you sure? Y/N?

CR:721731

CR Number:   721731 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 Nov 2012 Fixed 15 Nov 2012 Fixed 19 Nov 2012 Insufficient priority to fix 19 Nov 2012 Insufficient priority to fix 19 Nov 2012 Insufficient priority to fix 24 Nov 2012 Fixed Description ASE Alarm Subsystem may stop working which can result in "wait for delay hh:mm:ss" to exceed specified time or even hang. This can also cause log records to have stale time values that can prevent "point in time restore of a database" from working. Workaround Description  Use the LOAD TRAN WITH UNTIL_RID command to differentiate the stopping point for LOAD TRAN in cases where duplicate end times are recorded in ENDXACT log records.

CR:721735

CR Number:   721735 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) 18 Nov 2012 Fixed 26 Nov 2012 Fixed Description After ASE upgrade, Job Scheduler may fail to boot with error "Execution of rule check_jsc_state failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.check_jsc_state." Running "dbcc upgrade_object" on sybmgmtdb resolve the problem. Workaround Description  Upgrade the internal Job Scheduler SQL code using: 1> use sybmgmtdb 2> go 1> dbcc upgrade_object 2> go

CR:721737

CR Number:   721737 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) 14 Dec 2012 Fixed Description When updating a column to have NULL value and an immediate refresh pre-computed result set (materialized view) exists which selects that column, the session will be disconnected unexpectedly and a stack trace that includes the module memmove() will be reported in the error log. Workaround Description  create the materialized view as 'manual refresh' and refresh manually.

CR:721781

CR Number:   721781 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) 31 Oct 2012 Fixed 26 Nov 2012 Fixed 28 Nov 2012 Fixed Description The value of the 'status' column of most rows of system group in 'sysconfigures' table will be changed from 2 to 386 when upgrading to 15.7 ESD#2 or later version.

CR:721799

CR Number:   721799 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) 29 Nov 2012 Insufficient priority to fix 30 Oct 2012 Fixed Description The user usedb_user should not be allowed to create any objects.

CR:721809

CR Number:   721809 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2013 Fixed 15.7 SP50 02 Apr 2013 Fixed 05 Jun 2013 One-off Provided Description ASE at times sends extra TDS DONE packet for ct_cancel CT-Lib call.

CR:721824

CR Number:   721824 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) 11 Jan 2013 Fixed 01 Mar 2013 Fixed Description When the following is true: (1) the statement cache is on and (2) a dynamic prepared SQL statement containing a abstract plan clause is executed and (3) the same statement is prepared and executed by another ASE session, then the entry in the statement cache that was created by the first execution is not found when the dynamic prepare command is executed in the second session. As a result, a new LWP is created by the second session.

CR:721846

CR Number:   721846 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description From 15.7 ESD#3 it is possible to use the 'using out_of_range' clause with update statistics when specifying mutiple columns (multiple column syntax was added in ESD#2) update statistics t1 (c1),(c2) using out_of_range off This request is to allow separate distinct out_of_rang clauses for each column in the list:- update statistics t1 (c1) using out_of_range on ,(c2) using out_of_range off Currently this will raise a syntax error.

CR:721858

CR Number:   721858 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Tables Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2012 Added to user documentation Description In the 'Reference Manual: Tables' , KTID is not currently documented as a column in monProcessLookup

CR:721887

CR Number:   721887 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2012 Fixed 26 Nov 2012 Consult Complete 22 Nov 2012 Fixed 19 Nov 2012 Reservation Made 11 Feb 2013 Fixed Description With partitioned tables, some query plans may choose the MERGE UNION ALL operator, rather than Dynamic Partition Elimination.

CR:721889

CR Number:   721889 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2012 Fixed 16 Jan 2013 Fixed Description When either 'streamlined dynamic SQL' or 'enable functionality group' is configured and a client cursor containing host variables is declared through embedded SQL, and the cursor statement references the same host variable more than once, an error like: -201 : Prodecure <procedure_name> expects parameter <parameter_name> where <parameter_name> is the name of the host variable that appears more than once in the cursor-declare statement, will be generated. Workaround Description  set streamlined dynamic SQL to 0 OR specify sensitivity of a cursor: semi_sensitive or insensitive EXEC SQL DECLARE nice_cur semi_sensitive CURSOR FOR ...