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

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

CR:725220

CR Number:   725220 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2012 Workaround Description When there is no file named interfaces under $SYBASE directory, ASE WS will fail to start up. Workaround Description  Create an empty file named interfaces under $SYBASE directory, then ASE WS can start up successfully.

CR:725242

CR Number:   725242 Product Name:   SySAM Product Component:   FLEXlm Status:   Open OS:   NA Original Version:   2.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When multiple license servers are referenced in license files in the licenses directory 'sysam stop' attempts to shut down all of the license servers. A parameter should be added to only attempt to shut down the license server running locally on the host where the command is run. Note that remote license servers that are started via the 'sysam start' command can only be shut down from the same host, but license servers started via alternative mechanisms which don't specify the -local parameter to the lmgrd program can be shut down from remote machines.

CR:725254

CR Number:   725254 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Nov 2012 Fixed Description A 1865 error, "Altering database '' onto 'Invalid pointer param number 4, pointer value 0x0x1200000002' is not allowed because the database has mixed data and log segments." may be reported incorrectly during the execution of CREATE DATABASE command as opposed to "Altering database is not allowed because the database has mixed data and log segments."

CR:725312

CR Number:   725312 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2013 Insufficient info provided Description signal 11 in s_clean_encrkeys

CR:725315

CR Number:   725315 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 17 Oct 2013 Fixed 15.7 SP60 18 Oct 2013 Fixed 29 Oct 2013 Fixed Description The VERIFY option for the DUMP and LOAD commands does not give the user any indication of whether errors were found or not. The errors are currently reported only in the backupserver errorlog.

CR:725318

CR Number:   725318 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) 21 Mar 2013 Fixed Description The dataserver gets a segmentation violation when dropping a login while the dataserver configuration for 'number of open databases' is less than the actual number of databases defined in sysdatabases. The segmentation violation is followed by a 905 error, Unable to allocate a DBTABLE descriptor to open database 'dbname'. Close or drop another database before opening this one, or ask your System Administrator to raise the configuration parameter 'number of open databases' Workaround Description  Be sure to have 'number of open databases' >= than select count(*) from sysdatabases

CR:725376

CR Number:   725376 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2013 Bundled Request Description Hit error 806 when running shrink database and reorg defrag concurrently.

CR:725389

CR Number:   725389 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request to maintain version numbers in the Sybase Central ASE plugin jar file.

CR:725454

CR Number:   725454 Product Name:   ASE Management Product Component:   Administration Client Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Nov 2012 Fixed Description When using create a new index with an existing index name, user will see the sql generated with incorrect ignore_dup_key parameter.

CR:725608

CR Number:   725608 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2012 Fixed Description When resource limits is activated and a maximum transaction elapsed time is set, in CHAINED mode, a transaction is not rolled back after the specified elapsed time limit is exceeded.

CR:725661

CR Number:   725661 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) 11 Jan 2013 Fixed 09 Jan 2013 Presently Not Targeted For Any Future Release Of This Product 14 Jan 2013 Fixed 14 Jan 2013 Fixed 15 Jan 2013 Fixed 18 Jan 2013 Fixed 22 Jan 2013 Reservation Made 24 Jan 2013 Fixed 22 Feb 2013 Fixed 22 Feb 2013 Fixed Description The performance of the rollback of a skewed transaction, that is, a transaction that has bursts of activity separated by periods of inactivity, is unnecessarily slow.

CR:725667

CR Number:   725667 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) 18 Jan 2013 Fixed 11 Jan 2013 Fixed 11 Jan 2013 Fixed 18 Jan 2013 Fixed 18 Jan 2013 Fixed 24 Jan 2013 Fixed 25 Feb 2013 Fixed Description Miscellaneous enhancements to the performance of boot time, LOAD DATABASE and LOAD TRAN recovery including better performance in undoing long-running (incomplete) transactions i.e. those that have bursts of activity separated by periods of inactivity.

CR:725669

CR Number:   725669 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 15 Oct 2013 Fixed 14 Aug 2013 Reservation Made 15.7 SP121 08 Oct 2013 Fixed 14 Nov 2013 Fixed 15.7 SP121 13 Nov 2013 Fixed 14 Nov 2013 Reservation Made 15.7 SP121 19 Nov 2013 Fixed 19 Nov 2013 Fixed 15.7 SP121 02 Dec 2013 Fixed 02 Dec 2013 Fixed 17 Dec 2013 Fixed 15.7 SP121 03 Dec 2013 Fixed Description New feature that reduces the amount of recovery time during LOAD DATABASE at the expense of increasing the time taken by DUMP DATABASE. Data that is changed while DUMP DATABASE is active is included in the dump so that the dump has more up-to-date contents. This is enabled using sp_configure 'optimize dump for faster load', <percentage>. Changed data is included in the database dump when the percentage of database data changed during DUMP DATABASE is more than <percentage>. This defaults to 0 in which no changed data is copied, and there is no reduction in the recovery time of LOAD DATABASE. Workaround Description  In case you encounter problems with this feature you can disable it via: sp_configure 'optimize dump for faster load',0 go

CR:725677

CR Number:   725677 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow multiple dump stripes to use device "/dev/null".

CR:725708

CR Number:   725708 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) 18 Jan 2013 Fixed 25 Jan 2013 Fixed 22 Feb 2013 Fixed Description The KILL WITH STATUSONLY command has been enhanced and now provides information on the amount of log space scanned and to be scanned for a full transaction rollback. It differentiates different types of rollbacks, and reports a subset of information in cases where the rollback is not a full transaction rollback.

CR:725714

CR Number:   725714 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 A new feature request to avoid sysattributes look-ups for user defined role activation during login processing.

CR:725734

CR Number:   725734 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2013 Duplicate Description MDA: inconsistencies with monOpenObjectActivity counts

CR:725767

CR Number:   725767 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2012 Not reproducible with latest version of the product available as of Resolution Date 01 Mar 2013 Not reproducible with latest version of the product available as of Resolution Date 13 Apr 2013 Fixed Description On big-endian platforms, queries involving BIGINT columns in MDA tables may return wrong results.

CR:725810

CR Number:   725810 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) 04 Dec 2012 Fixed 07 Dec 2012 Fixed Description The message "current process infected with 11" in the module 'th_curunreservedpgs' together with a stack trace which includes the modules 'LeRun' and 'exec_lava' may be reported in the error log when a session executes a SELECT statement that uses the T-SQL function "curunreservedpgs" while another session is in the process of extending the size of the current database with ALTER DATABASE command.

CR:725858

CR Number:   725858 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2013 Fixed Description A 15095 error, "An invalid 'data row id' value was found in first text page of a text/image/unitext column." may be reported when running DBCC CHECKTABLE or DBCC CHECKDB on replicated Data Only Locked tables that have TEXT columns with values on forwarded rows.

CR:725864

CR Number:   725864 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) 25 Feb 2014 Fixed 27 Feb 2014 Fixed 17 Mar 2014 Fixed 20 Mar 2014 Fixed Description Improve "ddlgen" performance for generating ddl for schema objects

CR:725872

CR Number:   725872 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2014 Fixed 30 Jan 2014 Fixed 03 Jul 2014 Fixed Description Print extra information for home location of DOL forwarded rows in DBCC PAGE output.

CR:725885

CR Number:   725885 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2012 Fixed 06 Dec 2012 Fixed Description srvbuildres cannot configure ASE when the available free space on the disk is very large.

CR:725914

CR Number:   725914 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 When the stat gathering mechanism reverts to sort based stats (for any reason) in part or in full, it would be very helpful in diagnosing what went wrong during an extended maintenance window etc if we logged a message to the error log. This could detail the object name and relevant column(s) and what has changed in the stats gathering mechanisms. We could also report if\when the resource granularity setting has been hit and multiple scans have been issued for hashing multiple columns.

CR:725956

CR Number:   725956 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Microsoft Windows Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2012 Fixed 06 Dec 2012 Fixed Description If a previous Job Scheduler configuration failed, syconfig.exe and sybatch.exe do not re-install the ASE-15_0/scripts/installjsdb script in a rerun.

CR:725998

CR Number:   725998 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) 20 Jan 2013 Fixed Description Running ins_syn_sql on a 2K page ASE may lead to the log segment being full.

CR:726003

CR Number:   726003 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) 12 Dec 2012 Fixed 23 Dec 2012 Fixed 25 Dec 2012 Fixed Description In the cases of extreme heavy loading, it is possible that CREATE CLUSTERED INDEX in parallel on a big table causes a small volume of data to be lost. Workaround Description  Booting ASE with trace flag 1103 could work around this issue. If this issue is hit when CREATE CLUSTERED INDEX, another possible work around is not to use parallel index creation for example turning off database option 'select into/bulkcopy/pllsort' for target database. These two work arounds need the table is consistent. If the table has been in inconsitent, the table needs to be rebuilt completely so that the object ID is changed for example (BCP out data, DROP table, CREATE table and BCP in data).

CR:726004

CR Number:   726004 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) 04 Dec 2012 Fixed Description On Solaris SPARC, HP-UX and AIX systems an incorrect result may be reported when executing sp_tran_dumpable_status <dbname>.

CR:726032

CR Number:   726032 Product Name:   ASE Management Product Component:   Administration Client Status:   Closed OS:   Windows XP Pro Original Version:   3.2.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2012 Fixed Description 'usedb_user' is included in users list and group public when granular permission is turned on.

CR:726092

CR Number:   726092 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2012 Not a Bug Description The file permissions are not as expected for database devices, the errorlog and the configuration file on the Microsoft Windows platforms.

CR:726158

CR Number:   726158 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) 11 Dec 2012 Fixed Description Under some rare conditions, a query using a NESTED LOOP JOIN in an OUTER JOIN may encounter a signal 11 followed by a stack trace that contains the module LeSarg::mapSarg().

CR:726160

CR Number:   726160 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) 21 Dec 2012 Added to user documentation Description Load database command with listonly=create_sql may show an unknown_device in the listed create database command after you shrank one of log devices on the database.

CR:726224

CR Number:   726224 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: "des_greedyalloc" setting on the table should be recognized by sp_chgattribute & viewable via sp_help.

CR:726234

CR Number:   726234 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 Jan 2013 Fixed 20 Mar 2013 Fixed Description A timeslice error followed by a stack trace that includes the module rvm_dispatch() may be reported when show switch or any server-wide statement is executed in stored procedures.

CR:726357

CR Number:   726357 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 Jan 2013 Fixed Description Fixes issue associated with Auth dialog no longer enabling OK button on first character of password

CR:726378

CR Number:   726378 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 sqltext may fail with an infected with 10 in function oh_printsql.

CR:726379

CR Number:   726379 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 Jan 2013 Fixed 21 Apr 2013 Fixed Description A 11051 error, "ALTER TABLE '<table_name>' failed. Table is currently being used by one or more other tasks." may be reported when a REORG REBUILD command is run while another process concurrently runs a SELECT query on the same table at isolation level read uncommitted. Following this error and while the SELECT query continues to execute, any process that attempts to reference this table will fail mistakenly with an error such as 17461 "Object does not exist in this database.".

CR:726439

CR Number:   726439 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) 27 Dec 2012 Fixed 15.7 SP60 28 Oct 2013 Fixed 24 Mar 2014 Fixed Description Under some rare conditions, if there is a HASH AGGREGATE operator above a JOIN operator, wrong query results may occur. Workaround Description  1. Change the query. select BS.bs_04 , BS.bs_11 from TEST_PT PT , TEST_BS BS where BS.bs_11 = convert(tinyint,17) and BS.bs_11 = PT.pt_01 and PT.pt_02 = 3 group by BS.bs_04, BS.bs_11 2. Use compatibility mode.

CR:726480

CR Number:   726480 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) 10 Dec 2012 Added to user documentation Description Documentation for 'dump configuration' command is incorrect. It is missing 'to' clause to specify directory (which needs to be in quotes). Workaround Description  Correct syntax is dump config[uration] to "dump_dir"

CR:726551

CR Number:   726551 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 ESD#2 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2012 Fixed Description DDLGen does not extract DDLs correctly when stored procedures are grouped.

CR:726601

CR Number:   726601 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 Dec 2012 Bundled Request Description Load database command with listonly=create_sql may show an unknown_device in the listed create database command after you shrank one of log devices on the database. Workaround Description  You can eliminate it from the CREATE DATABASE command if the shrunk log device is the last segment map and you run the dump database command with shrink_log.

CR:726760

CR Number:   726760 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2012 Fixed Description sp_helpsegment reports wrong used_cnt after shrink database.

CR:726763

CR Number:   726763 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) 11 Dec 2012 Fixed 21 Dec 2012 Fixed 11 Dec 2012 Fixed 26 Dec 2012 Fixed 30 Jan 2013 One-off Provided Description The command ALTER DATABASE LOG OFF can result in the error 5057 ("The free space counts for the log are incorrect ...") being raised if the database has been loaded from a database dump where the command ALTER DATABASE LOG ON was run initially to extend the log. Workaround Description  Fix the syslogs counts using: DBCC DBREPAIR(test, fixlogfreespace, scanlogchain[, 1]) The 1 at the end is to avoid having to set the database in single user mode. If the database is not in single user mode, the result can be unpredictable in a production database with activity.

CR:726770

CR Number:   726770 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 Dec 2012 Fixed 28 Dec 2012 Fixed 03 Jan 2013 Fixed 31 Dec 2012 Fixed Description In rare cases of extreme heavy loading, it is possible that BCP/SELECT INTO a big table might lose allocation page entries from the OAM.

CR:726776

CR Number:   726776 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Dec 2012 Fixed Description The message, "Current process infected with signal 11" followed by a stack trace that includes the module altdb__clear_chunk() may be reported when executing SHRINKDB concurrently with sp_placeobject.

CR:726852

CR Number:   726852 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) 03 Jan 2013 Added to user documentation Description doc cr: simply using a number, whether in quotes or not is incorrect for sp_downgrade_esd argument. Must be like "GA", or "ESD1" "ESD#1"

CR:726863

CR Number:   726863 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2013 Not reproducible with latest version of the product available as of Resolution Date Description On solaris, we support vxfs for ASE, but not yet for backupserver. The result is: SYBMULTBUF ERROR: Failed to turn direct i/o on for database device

CR:726864

CR Number:   726864 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) Description The Signal 11 issue could be caused by memore corruption because of no any changes on a table with five TEXT columns after upgraded from ASE 15 32-bit to ASE 15.7 64-bit. Workaround Description  The problem was caused by a table corruption that almost certainly occurred in the upgrade process as Sybase converted the dumps from Sybase 15 32-bit to 15.7 64-bit. This is a static table that has received no updates since the upgrade. dropped and recreated the table "view_filter_def_wil" with five TEXT columns to avoid the signal 11.

CR:726869

CR Number:   726869 Product Name:   ASE Management Product Component:   Administration Client Status:   Closed OS:   Windows XP Pro Original Version:   3.2.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2012 Fixed 08 Jan 2013 Added to user documentation Description SCC Administration Console for ASE might not display large number of rows ( tens of thousands of rows) completely. This problem might occur when users are trying to expand a large result set message row to display say a list of large number of user tables.

CR:726936

CR Number:   726936 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) 26 Jul 2013 One-off Provided 16 Jul 2013 Fixed 15 Jul 2013 Fixed 15.7 SP60 09 Aug 2013 Fixed 15.7 SP110 09 Aug 2013 Fixed Description When I/O fencing is enabled, the server may fail to correctly fence the devices and start up. Need environment variable SYBASE_MAX_MULTIPATHS to override number of paths iterated which should be set to 1 if PowerPath is enabled.

CR:726957

CR Number:   726957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2012 Fixed 21 Dec 2012 Fixed carina 18 Jan 2013 Fixed Description The message "current process infected with 11" in the module 'ksct_startio' together with a stack trace which includes the modules 'ra_init_rs' and 'ra__connect_server' may be reported in the error log when the Rep Agent Thread attempts to open a new connection to the Replication Server and a previous connection attempt has failed. Workaround Description  Increase the number of seconds RepAgent remains inactive, default value is 60 seconds, before attempting to reconnect to Replication Server after a recoverable error or when Replication Server is down. Setting the retry timeout to a high value will diminish the likelihood of running out of connection resources that fast. sp_config_rep_agent <dbname>, retry timeout, <value> go

CR:727071

CR Number:   727071 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 With very large tables it is possible under rare circumstances for the sum total of all the step weights of a domain in a column's histogram to be less than 99%. Optdiag input of these statistics will fail. This can happen when there are a large number (non-default) number of steps in the histogram. Workaround Description  Manually modify one or more steps in optdiag file before input to make the total weight >=99%

CR:727073

CR Number:   727073 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2012 Fixed 26 Feb 2013 Fixed Description DDLGen does not generate DDLs of a logical key on VIEWs when using -TLK or -TV. Workaround Description  manually create the constraints on the target

CR:727123

CR Number:   727123 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2012 Fixed Description Display Stat Wizard may fail with the error message, "Client password encryption fails".

CR:727134

CR Number:   727134 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2013 One-off Provided 19 Dec 2012 Reservation Made 15 Jan 2013 Fixed 26 Feb 2013 Fixed 26 Apr 2013 Presently Not Targeted For Any Future Release Of This Product 27 Nov 2013 Presently Not Targeted For Any Future Release Of This Product 18 Dec 2014 Fixed Description Reduce the use of MASTER..SYSDATABASES scans in order to avoid high SPINLOCK contention on "DEFAULT DATA CACHE" in some cases.

CR:727186

CR Number:   727186 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2013 Deferred 21 Mar 2013 Fixed 29 Mar 2013 Fixed 20 Mar 2013 Fixed Description ASE may report errors like "JS: failed to receive jsagent response" and "Job Scheduler Task lost its Agent connection". JS Agent terminates without any errors in the JS Agent log. If core dumps are enabled on the platform, a core file is generated from JS Agent that contains the function sybcsi_mem_free() on the stack.

CR:727191

CR Number:   727191 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) 05 Feb 2013 Fixed Description DBISQL Feature Request to allow sending multiple results to a single output file via the Export Wizard

CR:727259

CR Number:   727259 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) 20 Dec 2012 Bundled Request 20 Dec 2012 Bundled Request Description A 9284 error, "RepAgent(<dbid>). Cannot allocate <value> bytes of memory. You may need to reconfigure the parameter 'replication agent memory size' with more memory.", followed by a 9219 error, "RepAgent(<dbid>): Internal coding error. Rep Agent Thread for database '<name>' (dbid = <value>) terminated abnormally with error. (major 92, minor 19)" maybe be reported in the error log if the Rep Agent Thread is recycled many times and compressed data is replicated. Workaround Description  sp_configure "replication agent memory size", "<value>" go

CR:727277

CR Number:   727277 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Dec 2012 Fixed Description Auditinit may fail to add devices on space larger than 1 TB.

CR:727310

CR Number:   727310 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) 19 Dec 2012 Fixed 21 Dec 2012 Fixed 21 Dec 2012 Fixed 03 Jan 2013 Fixed 03 Feb 2013 One-off Provided Description The message "current process infected with 11" in the module 'th_curunreservedpgs' may be reported when a session executes a SELECT statement that uses the T-SQL function "curunreservedpgs" while another session is in the process of extending the size of the current database with ALTER DATABASE command.

CR:727364

CR Number:   727364 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) 21 Dec 2012 Duplicate Description java.util.regex.Pattern class not understood by ASE_JAVA JCS hard coded Sysxtypes entries. This is because specific class did arrive from Java 5. Staying KonaVM compliant specific layer was left untouched. There is a project defined under CR 651059 named JNI Isolation to dynamically generate and overlay Sysxtypes from the JRE when the JavaVM bootstraps. Short this functionality is not available yet. Workaround Description  Customer could create a wrapper around java.util.regex.Pattern.matches() class and execute that from a UDF construction. If there is time for me i'll try to create an example for the PSE and deliver that to him later.

CR:727475

CR Number:   727475 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) 21 Dec 2012 Fixed 04 Jan 2013 Fixed 22 Dec 2012 Fixed 02 Apr 2013 Added to user documentation 02 Jan 2013 Fixed 07 Jan 2013 DEFER Description If the user is granted system roles indirectly through a user defined role, execution of sp_addthreshold fails with error message 10353 "You must have any of the following role(s) to execute this command/procedure: '<names>' . Please contact a user with the appropriate role for help."

CR:727482

CR Number:   727482 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 CONVERT( datatype not null, null) returns an undefined / arbitrary value rather than raise an error. While the behavior is documented, this CR is a request to consider whether it would be more appropriate to raise an error.

CR:727484

CR Number:   727484 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2013 Fixed 03 Jan 2013 Fixed 11 Jan 2013 Fixed Description A 17260 error, "Can't run sp_dbextend from within a transaction" may be reported when sp_dbextend is invoked in CHAINED mode.

CR:727505

CR Number:   727505 Product Name:   Adaptive Server Enterprise Product Component:   xmlconnect Status:   Open OS:   Microsoft Windows Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for the ability to run ASE Web Services on Windows as a Service.

CR:727509

CR Number:   727509 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2012 Fixed Description Generate new release packages for ASE 15.7 ESD#3 and later.

CR:727514

CR Number:   727514 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 for higher hard limit configuring user-defineded role

CR:727562

CR Number:   727562 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: Option to set In-Memory Database (IMDB) as system tempdb

CR:727597

CR Number:   727597 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 Jan 2013 Fixed 21 Apr 2013 Presently Not Targeted For Any Future Release Of This Product 15.7 SP50 04 Jun 2013 Fixed 08 Oct 2014 Port Not Needed Description Under deferred compilation or parallel processing it is possible when executing a procedure that the incorrect statement may be executed (one statement ahead of the correct one). The correct statement will be missed entirely, and the subsequent statement executed twice leading to wrong results or spurious errors. Workaround Description  sp_configure 'procedure deferred compilation', 0 --or (will do the same) dbcc traceon (7730) /*note that this only avoids the problem, the actual incorrect seqtext problem still occurs, it's only DC that relies on it though*/

CR:727693

CR Number:   727693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE task is stuck in global queue and not being scheduled

CR:727762

CR Number:   727762 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2013 Fixed Description Query with long IN list might cause stack corruption. Workaround Description  increase stack size

CR:727816

CR Number:   727816 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Dec 2012 Fixed Description sp_downgrade 'downgrade' will fail at step 990 with a 137 error, "Must declare variable '@show_'".

CR:727846

CR Number:   727846 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) 04 Jan 2013 Fixed Description The APFPercentage value in the monCachePool MDA table may report incorrect value.

CR:727884

CR Number:   727884 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 ESD#4 29 Dec 2012 Fixed 03 Jan 2013 Reservation Made 03 Jan 2013 Fixed Description Downgrade to versions lower than 15.7 ESD#2 will not remove the predid column from sysprotects.csysprotects. sp_fixindex or dbcc reindex will not change the index to the pre 15.7 ESD#2 definition.

CR:727887

CR Number:   727887 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) 15.7 SP110 30 May 2013 Fixed 29 May 2013 Reservation Made Description Trace flag 364 support added for ASE 15.0 which uses the range density instead of the total density for optimizer costing when constant sarg values are unknown. Trace flag 16982 is created which uses the total density instead of the computed join histogram density. If trace flag 364 and 16982 are both set, then the sarg density will be used for the join. Workaround Description  Using execute immediate feature so that the variable value is known at query optimization time.

CR:728000

CR Number:   728000 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 A 206 error "Operand Type Clash" with an INT4 datatype is raised by clients using parameterized SQL when statement cache is disabled but not when statement cache is active.

CR:728027

CR Number:   728027 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) 26 Mar 2013 Fixed Description In rare cases, the TRANSFER TABLE command may skip exporting an updated row if a target table is a Datapage or Datarow Locked table and it has forwarded rows or may hang up if a target table is a Datapage or Datarow Locked table and it has forwarded rows and large I/O buffer pools are configured. Workaround Description  Run reorg forwarded_rows or compact on a target table before executing transfer table command.

CR:728065

CR Number:   728065 Product Name:   Adaptive Server Generic Docs Product Component:   Adaptive Server New Features Guide Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2013 Added to user documentation Description The 15.7 ESD 3 New Features Guide is missing from the infocenter webpage.

CR:728081

CR Number:   728081 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances the Signal 11 occurs in OptPool::_PoolReclaimLegacyArray() when executing the query with distinct and/or with WHERE IN long list of values.

CR:728157

CR Number:   728157 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) 09 Jan 2013 Fixed Description Auditinit may a core dump if the "LANG" environment variable is not set correctly.

CR:728173

CR Number:   728173 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2013 Fixed Description When inserting data into a table containing LOB columns and ASE happens to run out of log space, the message "Space available in the log segment has fallen critically low in database <dbname>. All future modifications to this database will be aborted until the log is successfully dumped and space becomes available" followed by a stack trace that includes the module logmodify() may be reported in the error log.

CR:728201

CR Number:   728201 Product Name:   Adaptive Server Enterprise Product Component:   sqldbgr Status:   Open OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 208 is raised when using sqldbgr on a server with multiple tempdbs when trying to access a temporary table. This happens when the sqldbgr process is assigned a different tempdb than the process being debugged.

CR:728235

CR Number:   728235 Product Name:   SCC Web Framework Product Component:   GUI Status:   Closed OS:   Generic Original Version:   3.2.7 ESD1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2013 Fixed Description Fixes issue related to the workflow of the collection job wizard where the authentication page is not always skipped if already authenticated

CR:728237

CR Number:   728237 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 allow the logial table in the trigger accessible by the nested sprocs Workaround Description  use "for xml"

CR:728364

CR Number:   728364 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2013 Fixed 28 Jan 2013 Fixed 17 Jan 2013 Fixed 08 Feb 2013 One-off Provided 09 Apr 2013 One-off Provided Description An 806 error, "Could not find virtual page for logical page <pagenum> in database <dbname>" may be reported when executing a stored procedure whose query plan is cached.

CR:728419

CR Number:   728419 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2013 Fixed Description DDLGen does not generate the partition name and segment information for a hash partitioned All Pages Locked table with a clustered index. Only the number of partitions are generated in the DDLGen output. Workaround Description  The workaround to recreate these tables is to obtain partition information from running 'sp_help' on the table against the source server, obtaining the partition information from the output of sp_help and then finally creating these partitions manually on the target server.

CR:728430

CR Number:   728430 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) 17 Jan 2013 Fixed 17 Jan 2013 Fixed 06 Mar 2013 One-off Provided 25 Jan 2013 Fixed Description Running UPDATE STATISTICS on an index containing non-materializing column may hit an error with a stack trace containing the modules stat_bld_row() and collocate(). Workaround Description  When data is exported (bcp out), the table dropped/recreated and data reloaded (bcp in) the command succeeds. Also, reorg rebuild can rectify this error. However this requires downtime if this happens for large tables..

CR:728444

CR Number:   728444 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) 18 Jan 2013 Fixed 14 Mar 2013 Fixed 12 Feb 2013 Fixed Description A 2601 error, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'", followed by an 11068 error, "Transaction was found in the incorrect state of 'Command-attached'. The expected state was 'Done command-attached'.", may be reported in the error log during ASE startup in a Windows environment, if the configuration file has a 'Dump Configuration' section where the 'stripe directory' option is set to a value where backslash characters are specified. Workaround Description  1. Edit the ASE configuration file and remove all dump configurations that contain a backslash in the stripe directory path. For example, remove the dump configuration below for database ERRDDB: [Dump Configuration:ERRDDB] stripe directory = \\WIASMBCK01\asm\ER\DDB ... 2. Reboot ASE. 3. After successful reboot, copy back the original ASE configuration file and change the stripe directory path value by using double quotes and double each backslash. For example: [Dump Configuration:ERRDDB] stripe directory = "\\\\WIASMBCK01\\asm\\ER\\DDB" ... 4. Reboot ASE again.

CR:728451

CR Number:   728451 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2013 Duplicate Description Error 839 was raised in a tempdb against 15.7 ESD1 Refresh #2 release: "Error: 839, Severity: 21, State: 1, Grabbed buffer dirty but not writing:..." Workaround Description  If 839 error was raised during sorting for a work table which was created for reformatting step in a query plan, then you may consider testing new plan without reformatting via 'set store_index off'.

CR:728497

CR Number:   728497 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2013 Fixed 15.7 SP50 03 Jun 2013 Fixed Description The message, "Current process infected with signal 11" followed by a stack trace that includes the module init__data_vs_strategy() may be reported when running REORG REBUILD following which a DROP TABLE is executed.

CR:728520

CR Number:   728520 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2014 Presently Not Targeted For Any Future Release Of This Product 28 May 2014 Presently Not Targeted For Any Future Release Of This Product 13 Jun 2014 Presently Not Targeted For Any Future Release Of This Product Description The normal wcpu value is between 1 and 65534. So expect error when executing dbcc tune('wcpu',0), but actually this command executed succeed.It's big-endian platform specific issue.

CR:728528

CR Number:   728528 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2013 Fixed 06 Mar 2013 Fixed Description Upgrade from 12.5.4 may fail at step 1564 with message 3606, "Arithmetic overflow occurred."

CR:728563

CR Number:   728563 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2013 Fixed 15.7 SP50 09 Apr 2013 Fixed 31 May 2013 One-off Provided Description In ASE 15.7 ESD#2 and above, under some circumstances, ASE may encounter signal 11 or timeslice error with a stack trace involving the module idt_remove_all_reservations() while cleaning up identity reservations assigned for specific object. Workaround Description  A possible workaround is: Sp_configure 'identity reservation size',1 Sp_configure 'identity grab size',1 Session's Pss->pidtvalueinfo is 0x0 with these two parameters. This workaround may have side effects including identity value gap and performance.

CR:728592

CR Number:   728592 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 When attempting to start Web Services using runws (runws.bat on Windows) if the parameter for the ASE service (-S) is set to a name which does not exist in the interfaces file the following error will be displayed in the webservice.log file:- 2013-01-04 14:49:32.561 FATAL [main] - IllegalArgumentException error has occurred: java.lang.NumberFormatException: null And Web Services will fail to start. Workaround Description  Use a valid (and the correct) ASE service name when specifying the value for -S (or when prompted if not using -S)

CR:728594

CR Number:   728594 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 Update Web Services to use the 1.7 JRE supplied under $SYBASE/shared/JRE-7_0_1_64BIT by default and document those changes. Workaround Description  set $SYBASE_JRE6 to $SYBASE/shared/ase/JRE-6_0_24_64BIT or $SYBASE/shared/JRE-7_0_1_64BIT Or: Manually modify the scripts to use $SYBASE_JRE7 env. variable.

CR:728634

CR Number:   728634 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 IT Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2013 Fixed 08 Jan 2013 Fixed 28 Jan 2013 Fixed Description A 17879 error, "Only users that have System Administrator (SA) authorization granted directly may add, or modify thresholds in that database" may be reported if a user that has been granted sa_role indirectly through a user defined role executes sp_addthreshold in a database where the user is not the actual owner.

CR:728719

CR Number:   728719 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2013 Bundled Request Description DBISQL intercepts 'set showplan on/off' to only show query plans from user-issued query executions

CR:728745

CR Number:   728745 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Case insentivive is not being considered when using hash partition Workaround Description  Create a global nonclustred index

CR:728752

CR Number:   728752 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 At times in threaded mode, error messages in ASE error log describing errno can be misleading.

CR:728753

CR Number:   728753 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) 17 Jan 2013 Duplicate Description A database dump from 15.5 taken using the "compress::" method fails to load in 15.7 ESD 3 and the current nightly build. The same dump loads without error in 15.7 ESD 2. The error raised is "Label validation error: first label not VOL1." The "with compression = " method does not encounter this problem. Workaround Description  Use the "with compression = " method instead of "compress::" -or- don't use compression when dumping the database -or- Downgrade to 15.7 ESD 2