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

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

CR:706866

CR Number:   706866 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2012 Fixed Description When a DUMP TRAN is done on a non-existent database, the expected 911 error, "Attempt to locate entry in sysdatabases for database '<database name>' by name failed - no entry found under that name. Make sure that name is entered properly.", is not reported.

CR:706877

CR Number:   706877 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 ASE does not raise an error when an rpc-based proxy table is passed an invalid parameter such as a value larger than MAXINT to an INT parameter. No error is raised because execution of the stored procedure is short-circuited.

CR:706937

CR Number:   706937 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 May 2012 Presently Not Targeted For Any Future Release Of This Product Description ASE threaded mode reports Msg 15025 "sp_listener: parameter 2 specifies an invalid network protocol tli" when sp_listener stored procedure specifies a tli address like "sp_listener start,'tli:<host>:<port>' as TLI is not supported in threaded kernel mode.

CR:707065

CR Number:   707065 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2012 Fixed Description In rare situations, a 1514 error might occur while creating the index with a reserved page gap. Workaround Description  Don't use 16K pool for the cache bound to the table while creating the index.

CR:707149

CR Number:   707149 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) 11 May 2012 Fixed 11 May 2012 Fixed 11 May 2012 Fixed 11 May 2012 One-off Provided 11 May 2012 Fixed 14 May 2012 Fixed Description The message, "The Begin Timestamp=<ts1> of the completing transaction in database <dbid> is lower than the Database Commit Timestamp=<ts2>", may be printed in the error log together with a stack trace that contains the modules dbts_commits_remxdes() and xact_end_session() when chained transactions are used, and ASE is started with the diagserver binary.

CR:707260

CR Number:   707260 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 RAT N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2012 Fixed 09 May 2012 Fixed 09 May 2012 Fixed Description In rare circumstances, when replicating compressed LOB data, the replicate ASE may raise error 7153, and the Replication Server may abort the connection.

CR:707304

CR Number:   707304 Product Name:   SCC Web Framework Product Component:   Alert Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2012 Fixed Description Filter columns within the SCC Alert Monitor now match the selected/display columns within the main monitor panel

CR:707351

CR Number:   707351 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) 15.7 ESD#2 08 May 2012 Fixed 15 May 2012 Fixed 15.7 ESD#2 14 May 2012 Fixed 15 May 2012 Fixed Description When running UPDATE INDEX STATISTICS or UPDATE STATISTICS for a specific column, the leaf level of an index is scanned to get the values of any non-leading columns (if available). It is possible for ASE not to select the most efficient index to do this operation if the column exists as a non-leading column in more than one index.

CR:707411

CR Number:   707411 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) 06 May 2012 Fixed 29 May 2012 Fixed 16 Jul 2012 Fixed Description In rare cases with tables having non-unique indexes with huge duplicates, the index might end up having lot of near empty pages.

CR:707548

CR Number:   707548 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2013 Not a Bug Description identity insert error - Incorrect syntax near the keyword 'Log off' Workaround Description  Workaround is to use quoted identifiers. alter connection to dsname.dbname set dsi_quoted_identifier to 'on' create replication definition Log_rd with primary at dsname.dbname with all tables named "Log" quoted ( LogID identity, LogTypeID numeric, TaskID numeric, AdminID numeric, AgentID numeric, AgencyID numeric, UserID numeric quoted, LongDescription varchar(300), ServerIP varchar(15), RemoteIP varchar(15), timestamp datetime ) primary key (LogID) send standby all columns *note - the 'send standby all columns' is required for MSA **note 2 - 'send standby replication definition columns' is required for warmstandby

CR:707555

CR Number:   707555 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) 12 May 2012 Fixed 12 May 2012 Fixed 12 May 2012 Fixed Description When using ASE Multiple Path Replication with distribution per connection and while replicating LOB data, the Replication Server DSI may shut down itself with either error 5139, "DSI encountered an error when processing an rs_writetext command for object '<Object Name>', text column '<Column Name>'. This rs_writetext command is not marked as the first chunk for the column. However, there is no previous rs_writetext command that is marked as the first text chunk." or error 5147, "DSI encountered an error when trying to do writetext operation for object '<Object Name>', column '<Column Name>'. The data row that the writetext command is associated with is missing.". Under rare circumstances the Replication Server may also shut down itself. Workaround Description  (ling's courtesy) I spent sometime trying to reproduce the problem, with HVAR, BULK, DSQL and language. For all the use cases, DSI complained with the two errors 5139 or 5147, and went down. Although there is no silent lose of data, this is still serious. At this point, the user could only resume DSI by skipping the commands/transaction in question. Even if the user wants to apply the rs_writetext at the replicate, he would not know which row to apply it to.

CR:707783

CR Number:   707783 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2012 Fixed 21 Aug 2012 Presently Not Targeted For Any Future Release Of This Product 20 Aug 2012 Presently Not Targeted For Any Future Release Of This Product Description When using traceflag 7738 to enable statement cache user id sharing, sometimes an error 622 (Opentable was passed a varno of ...) may be raised if compatibility mode is also enabled. Workaround Description  1) Turn off TF 7738 and purge the statement cache 2) Grant the user sa_role.

CR:707886

CR Number:   707886 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2012 Fixed Description Non clustered Index for DOL table can be created with with online option.

CR:707969

CR Number:   707969 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Oct 2012 Not reproducible with latest version of the product available as of Resolution Date Description A select having a SQLJ function to convert a column of data fails with messages 10707, 10745 if there are many rows in the select.

CR:708020

CR Number:   708020 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 On non-binary sort order servers (version 15.0 and higher) When a query involves an equi-join between two char columns and there exists only an equivalence between the values ('a'='A' for example), it is possible for a query to return unexpected results if a built-in function (or comparable operator) in the predicate is reliant on the specific value from one side of the join. Examples of this may be the compare() function when using a binary collation as the 3rd argument or conversion of the column value in order to do a binary comparison. Workaround Description  set compatibility_mode on or use cmdline traceflag 15321 or set cr500736 off The last two workarounds will disable transitive closure for such join.

CR:708033

CR Number:   708033 Product Name:   Sybase ETL Product Component:   Logging Status:   Open OS:   all Original Version:   4.9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Altering a Load Script generates ReferenceError errors in system.log when run Workaround Description  Possibly switching off the "Evaluate" option would help; but that is not suitable for all cases.

CR:708044

CR Number:   708044 Product Name:   Adaptive Server Enterprise Product Component:   sybdiag Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2012 Fixed Description sybdiag shows "14000 - Interfaces Load Error" if non-default interface file is specified with -I option in the command line.

CR:708058

CR Number:   708058 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Refresh #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2012 Deferred 08 Aug 2012 Fixed 08 Oct 2012 Added to user documentation 23 Aug 2012 Fixed 21 Aug 2012 Fixed 24 Aug 2012 Fixed Description Extend sp_helpconfig to support a new "estimate" clause to estimate the size of 'compression info pool size' config option based on other config parameters, or user-overrides.

CR:708071

CR Number:   708071 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) 24 Aug 2012 Fixed Description In ASE Cluster Edition during instance failover recovery, the checkpoint process may be blocked by the threshold manager process that is doing free space accounting recovery for a large database that has the "trunc log on chkpt" database option turned on.

CR:708089

CR Number:   708089 Product Name:   ASE Management Product Component:   Monitoring Agent Plugin Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2012 Fixed Description The Auto Refresh checkbox is located on the bottom right of the status bar in ASE Monitor window. When "Auto Refresh" is unselected, any change of state of the ASE Monitor window such as clicking the maximize/minimize icon of the window will turn the "Auto Refresh" back to selected. This checkin for ASEMAP 3.2.7 corrects this unexpected behavior of the Auto Refresh such that it will not change state from maximize/minimize operation.

CR:708096

CR Number:   708096 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) 15 Jun 2012 Fixed Description This resolution addresses accessibility problems within the SCC UI which prevented keyboard access

CR:708100

CR Number:   708100 Product Name:   SCC Web Framework Product Component:   GUI Status:   Open OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2012 Fixed Description This fix addresses an issue where the screen reader did not work in some cases

CR:708134

CR Number:   708134 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 RAT N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2012 Fixed 17 May 2012 Fixed 17 May 2012 Fixed 15.7.1 28 May 2012 Fixed Description A 7153 error, "Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end.", may be reported when replicating in-row LOB data that is marked as "replicate_if_changed" and the UPDATE statement does not modify the in-row LOB data. Workaround Description  Mark the In-Row LOB columns that are to be replicated as 'always_replicate' rather than 'replicate_if_changed'. OR Do not use the In-Row LOB feature in ASE (i.e. set in row length to 0) when the column is to be replicated. OR On the destination Replication Server disable HVAR (High Volume Adaptive Replication) by setting dsi_compile_enable to 'off'.

CR:708143

CR Number:   708143 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) 11 Aug 2013 Fixed Description asehostname() can return null or truncated values when the hostname is greater than 30 characters.

CR:708240

CR Number:   708240 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2012 Fixed Description For RTC (run to completion) threads such as syb_system_pool & syb_blocking_pool, values from monThread for BusyTicks shows it is alway busy. It is corrected to reflect work done.

CR:708273

CR Number:   708273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2012 Fixed 14 Jun 2012 Reservation Made Description For an update query with instead of trigger, if it updates numeric column, it could return wrong result if literal autoparam configuration parameter is turned on. Workaround Description  -- Turn off literal autoparam entirely. sp_configure "literal autoparam", 0 go -- or -- -- turn off statement cache at the session level set statement_cache off update view... set statement_cache on

CR:708356

CR Number:   708356 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) 12 Oct 2012 Fixed 28 Oct 2012 Bundled Request Description Invoking the reog rebuild command on a table with a bracketed identifiers will generate a warning claimin an Abstract Plan (AP) syntax error.

CR:708388

CR Number:   708388 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 Feature request to include optimization time (suggested as OptimizeTime) for currently executing as well as previously executed statements in the relevant MDA tables monCachedProcedures monProcessStatement monProcessProcedures monCachedStatement monSysStatement

CR:708392

CR Number:   708392 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) 16 May 2012 Fixed Description The attempt to alter a database in the Devices tab of the ASEMAP Admin Console Database Property Sheet to increase the size by more than 1000 MB will fail with "Incorrect syntax" error. This problem is fixed in ASEMAP 3.2.7.

CR:708472

CR Number:   708472 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) 18 Jun 2012 Added to user documentation Description DBCC CHECKALLOC can't fix fault 100007 reported by checkstorage Workaround Description  customer has to restore the database from clean backup.

CR:708502

CR Number:   708502 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) 30 May 2012 Fixed 01 Jun 2012 Fixed Description ALTER TABLE <table name> split partition <partition name> into <partition values> or ALTER TABLE <table name> move partition <partition name> to <seg name> will encounter 691 error when db option 'full logging fopr alter table' is enabled.

CR:708519

CR Number:   708519 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) 23 May 2012 Fixed 23 May 2012 Fixed 23 May 2012 Fixed 30 May 2012 Fixed Description When upgrading from a pre-15.7 ASE version that does not support compression, RepAgent ASE 15.7 incorrectly assumes that compression is on for uncompressed tables.

CR:708527

CR Number:   708527 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Suse 10 Original Version:   15.7 ESD#1 RAT N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2012 Fixed 22 May 2012 Fixed 23 May 2012 Fixed 23 May 2012 Fixed Description The message, "Current process (0x<value>) infected with signal 11 (SIGSEGV)", in the module 'kbfalloc' together with a stack trace which includes the modules 'ra__process_xtext' and 'ra__process_txtblk' may be reported in the error log when replicating large, compressed TEXT columns.

CR:708756

CR Number:   708756 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 Jun 2012 Fixed Description Non clustered Index for APL table can be created with with online option.

CR:708798

CR Number:   708798 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) 24 Oct 2012 Fixed Description In specific circumstances involving execution of a stored procedure under execute immediate in combination with additional statements it is possible for the following error.. CT-LIBRARY error: ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read ..to be observed when using isql or any other ct-lib client and the subsequent statement (after the execute immediate) to not be executed. The issue only arises under very specific circumstances when certain statements that are deferred for compilation at runtime have to be compiled when under an execute immediate. Workaround Description  dbcc traceon (7730) --or exec sp_configure 'procedure deferred compilation', 0 go

CR:708821

CR Number:   708821 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2012 Insufficient priority to fix 02 Dec 2012 Fixed Description Checktable and Checkdb report an error that "An invalid 'data row id' value was found in first text page of a text/image/unitext column." for replicated DOL tables that have text columns with values on forwarded rows. As a workaround, run REORG FORWARDED_ROWS to eliminate forwarded rows before running the DBCC check. Workaround Description  Eliminate forwarded rows by running REORG FORWARDED_ROWS or REORG COMPACT before running the DBCC consistency check.

CR:708830

CR Number:   708830 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 Jan 2014 Fixed 26 Feb 2014 Fixed Description sp_dump_history returns error 17152, version missing or invalid, when dump history file does not exist.

CR:708876

CR Number:   708876 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#3 17 Jul 2012 Bundled Request Description When the user specifies for dump configurations a default directory for the dump stripes with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when generating the list of commands that are needed to create a target database with the same layout as the source database.

CR:708900

CR Number:   708900 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) 17 Jul 2012 Fixed 10 Aug 2012 DEFER Description In rare circumstances, when a query involves join with many remote tables, a message "current process infected with 11" in the module 'sdes_hookup' together with a stack trace which includes the modules 'omni_remote_name' may be reported in the error log. The problem occurs when 'showplan' is on or 'plan text pipe active' is configured to 1.

CR:708912

CR Number:   708912 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) 01 Oct 2012 Not a Bug Description monCachedObject contents can vary depending on current database Workaround Description  sp_sysmon's cache wizard still seems to work OK.

CR:708945

CR Number:   708945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 RAT N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2012 Fixed 22 May 2012 Fixed 23 May 2012 Fixed 23 May 2012 Fixed Description In rare circumstances, when replicating compressed IMAGE/UNITEXT LOB data, the replicate ASE may raise a 7153 error, "Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end", and the Replication Server may abort the connection.

CR:708946

CR Number:   708946 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guides - All Platforms Status:   Open OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description doc bug: sp_downgrade procedure still states '1502' is not suppported. However, we do support it as of 15.7 esd #2. Target Version  To Be Determined

CR:709056

CR Number:   709056 Product Name:   ASE Management Product Component:   Monitoring Data Collector Status:   Closed OS:   Generic Original Version:   3.2.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2012 Fixed 05 Oct 2012 Fixed Description In ASE Monitoring screen for Data Cache, the Pool Information could catch numeric overflow under any of following conditions 1. the Size(MB) is over 99999.99 MB 2. the Usage(%) is over 99.99 This fix allows the Pool Information without causing numeric overflow 1. the Size(MB) up to 9999999.9 MB or 9999.9999 GB 2. the Usage(%) up to 9999.9 In addition, the Usage(%) in this fix corrects the value by a factor of logical page size of the server in KB (that is either 2,4,8 or 16).

CR:709060

CR Number:   709060 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2012 Fixed Description When creating a cluster or adding an instance, sybcluster cannot detect invalid device name immediately after it is entered. Workaround Description  Remove the created devices and edit the XML file. For instance, change <device name="loadtemp2.dat" path="/c11736682/ASE_157CE/data/localtemp2.dat" size="100" units="m" /> <device name="localtemp.dat" path="/c11736682/ASE_157CE/data/localtemp.dat" size="100" units="m" /> to: <device name="loadtemp2" path="/c11736682/ASE_157CE/data/localtemp2.dat" size="100" units="m" /> <device name="localtemp" path="/c11736682/ASE_157CE/data/localtemp.dat" size="100" units="m" /> Then restart the create specifying the XML file.

CR:709078

CR Number:   709078 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) 23 May 2012 Bundled Request Description Under certain circumstances, the load of an archive database may fail with a timeslice error. The stack trace that is reported in the error log includes the module 'fm_item_by_index'. Target Version  To Be Determined Workaround Description  Increasing CPU grace time may help to reduce the chances of timeslicing while loading this archive database.

CR:709090

CR Number:   709090 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2012 Fixed 19 Jul 2013 Fixed 30 Aug 2013 Added to user documentation Description Release DBISQL 16 for ASE.

CR:709184

CR Number:   709184 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2012 Fixed 20 Sep 2012 Presently Not Targeted For Any Future Release Of This Product 21 Sep 2012 Fixed 21 Sep 2012 Reservation Made Description Improve UTF-8 sort order 25 performance for well-formed UTF-8, under sp_configure parameter "enable permissive unicode".

CR:709187

CR Number:   709187 Product Name:   Unified Agent Product Component:   Agent Server Status:   Closed OS:   NA Original Version:   3.2.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2012 Fixed 24 May 2012 Fixed 25 May 2012 Fixed 25 May 2012 Fixed 30 May 2012 Fixed Description This resolution addresses a deadlock situation in the framework classloader during the startup of alert and messaging services

CR:709211

CR Number:   709211 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2012 Fixed 04 Jun 2012 Fixed 06 Jun 2012 Reservation Made Description Following an abnormal termination of ASE, the recovery analysis and redo passes can be unnecessarily long in recovering large databases that had a very large number of different pages flushed to disk since the last checkpoint prior to the termination.

CR:709255

CR Number:   709255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2012 Fixed Description In some rare case, it could stacktrace when we print query execution info or final plan in XML.

CR:709276

CR Number:   709276 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2012 Fixed 01 Jun 2012 Fixed 05 Jun 2012 Fixed Description When an installation is created by ASE version 15.0.3 or before, then upgraded to 15.5, and then further upgraded to 15.7 or later, then if the upgraded server is downgraded back to 15.5, the booting of the 15.5 server may encounter a segmentation fault. This fault prevents recovery from completing. Workaround Description  * Add missing config values to sysconfigures table before performing the ASE downgrade. On linux the following command is required: bcp master..sysconfigures in missing_sysconfigures.out -Usa -Psybase -Y c With file available at: http://www-panther.sybase.com/remote/cases/11735000s/11735089/smichalo/repro/missing_sysconfigures.out

CR:709343

CR Number:   709343 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2012 Added to user documentation Description The table of convert() styles in Reference Manual Vol 1 is missing entries for new styles 36-40 that display microsecond granularity.

CR:709371

CR Number:   709371 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) 28 May 2012 Fixed 29 May 2012 Fixed Description The message, "timeslice <value>, current process infected at <value>", in the module 'io_submit' together with a stack trace which includes the module 'bufawrite' may be reported in the error log when ASE is started in threaded mode and while it is creating a large database. Workaround Description  Run in process mode. The customer has reported that increasing 'number of disk tasks' helped as well, though why that would be the case is uncertain. Internal testing has reproduced the error even with 4 disk tasks.

CR:709444

CR Number:   709444 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) 06 Jun 2012 Fixed Description Sometimes a 619 error, "A deferred update was requested but the query is not one of INSERT, DELETE or UPDATE", may be reported while executing WRITETEXT command on an in-row LOB column.

CR:709453

CR Number:   709453 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) 27 Jul 2012 Fixed 29 Jul 2012 Fixed Description If an application passes an invalid TEXTPTR to different LOB-related T-SQL commands (e.g READTEXT, WRITETEXT, TEXTVALID, etc) for an IN-ROW LOB, sometimes the command may report fatal 605 or 625 errors.

CR:709474

CR Number:   709474 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2012 Fixed 26 Jul 2012 Added to user documentation Description A new SpinlockSlotID column has been added to the monSpinlockActivity MDA table. This column provides a unique identifier for each spinlock in the current ASE server. This ID is not persistent across servers or restarts of the server.

CR:709479

CR Number:   709479 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2012 Added to user documentation Description In the 15x manuals Adaptive Server Enterprise 15.7 > System Administration Guide: Volume 2 > Checking Database Consistency > Upgrading compiled objects with dbcc upgrade_object This section advises that post successful upgrade the sysprocedures.version should read 12500, this is incorrect, after a successful upgrade it should read 15000 for any version from 15.0 to 15.7.

CR:709510

CR Number:   709510 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2012 One-off Provided 18 Jul 2012 Fixed 10 Nov 2012 Fixed Description Enabling I/O fencing may result in "reservation conflict" messages in the system log.

CR:709572

CR Number:   709572 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) 07 Jun 2012 Fixed 08 Jun 2012 Fixed 12 Jun 2012 Fixed Description A 301402 error, "Backup Server: 3.14.2.4: Logical page <page_number> is not in the given database map.", may be reported by the Backup Server during the execution of LOAD WITH VERIFYONLY on a database whose size is bigger than 2147483647 pages in an ASE installation that uses page size greater than 2K page.

CR:709646

CR Number:   709646 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2012 Fixed 05 Jul 2012 Added to user documentation Description ASE-UA Role Mapping (Roles Folder), UA Security Modules (Server Properties Agent page) and UA Attributes/Operations (Server details panels) are no longer supported due to upgrade to SCC 3.2.7.

CR:709651

CR Number:   709651 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 Jul 2012 Fixed Description A number of different errors and stack traces might be seen in the error log in an ASE CE system after executing ONLINE DATABASE on one instance, having loaded one or more dump that were taken on an earlier version of Adaptive Server compared to that into which they are loaded, on another instance.

CR:709721

CR Number:   709721 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 Jun 2012 Fixed 20 Jun 2012 Fixed Description When an in-row LOB column which has both data compression and LOB compression properties defined has its schema changed by setting the LOB compression property to not compressed, ASE following a SELECT query execution may return incorrect results for this column for data that was inserted into this column before the column schema change occured.

CR:709754

CR Number:   709754 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) 19 Jan 2014 Fixed 15.7 SP121 07 Jan 2014 Fixed Description It is possible for a spid to terminate and a stack trace to appear in the SAP ASE error log containing the functions memset and bi__xml_query/bi_xmlextract. This can happen under heavy usage when the session heap memory pool has become starved. Workaround Description  Increase 'heap memory per user'

CR:709770

CR Number:   709770 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A config parameter making the multiple user tempdbs recover before all user databases. Workaround Description  sp_dbrecovery_order

CR:709778

CR Number:   709778 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   beauregard Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer requesting the ability to view associated data in XML model structure. The are looking for similar functionality as 'View Data' in the PDM model.

CR:709805

CR Number:   709805 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2012 Fixed Description In some case, downgrade could cause memory corruption issues and stacktrace. Workaround Description  Drop the original sproc sp_downgrade, install a modified version of sp_downgrade to replace dbcc markprocs with an update query to use direct mode to update sysprocedures. The customer has confirmed the following modified version of sp_downgrade works: http://www-panther.sybase.com/remote/cases/11734000s/11734839/pseinfo-11/Repro/CR/workaround/sp_downgrade.new.txt --------------------------- diff sp_downgrade.orig.txt sp_downgrade.new.txt 1a2,5 > use sybsystemprocs > go > drop proc sp_downgrade > go 19c23 < create procedure sp_downgrade --- > create procedure sp_downgrade 1131a1136,1137 > exec sp_configure 'allow updates to system table', 1 > 1186c1192,1197 < dbcc markprocs(@dbid) --- > /* dbcc markprocs(@dbid) */ > print '- update query as workaround for' > > update sysprocedures > set status = status | 0x8 > where sequence = 0 1259a1271,1272 > > exec sp_configure 'allow updates to system table', 0 1263a1277 > go ---------------------------- Notes for history: Previous suggestion which uses new sproc sp_downgrade_new may cause 3708 error and fails to drop system index with following messages from sp_downgrade_new: ---------------------------------------------------- Switch 'drop_system_index' is turned on. All supplied switches are successfully turned on. Msg 3708, Level 16, State 2: Server 'PRIMUS_UAT7', Line 1: Cannot drop the index 'sysdevices.ncsysdevices' because it is a system index. Switch 'drop_system_index' is turned off. ---------------- Workaround needs to use original name sp_downgrade since dropi() will match this name.

CR:709808

CR Number:   709808 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2012 Duplicate Description A config parameter making the multiple user tempdbs recover before all user databases. Workaround Description  sp_dbrecovery_order

CR:709817

CR Number:   709817 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) 29 May 2013 Insufficient priority to fix Description The EXECUTE command raises errors such as 11037 or 203 when passed a unichar or univarchar variable for a procedure name or char_variable.

CR:709922

CR Number:   709922 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2012 Consult Complete Description can 15.7 boot with 250G or more default data cache?

CR:709947

CR Number:   709947 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) 05 Jun 2012 Fixed 01 Jun 2012 Reservation Made 08 Jun 2012 Fixed Description Syntax is added to the UPDATE STATISTICS command to allow printing of progress messages while the command is running. The new syntax is UPDATE STATISTICS <tablename> ... with "print_progress"=<0|1> where 0 = disable and 1 = enable. The default value is 0.

CR:709951

CR Number:   709951 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Message "The %ldK memory pool of named cache %s (cache id %d, cachelet id %d) is configured too small for current demands (state %d). Transaction progress may cease or response time may increase." filled up errorlog. Please check tempdb_cache configuration to see if the buffer pool is too small for the value of parameter 'max buffers per lava operator', and check if the message is due to multiple sessions trying to use the same buffer pool. Workaround Description  If buffer resource usage in tempdb_cache issue is due to concurrent query processing, then they may check if they can adjust parameter 'max buffers per lava operator' or adjust tempdb_cache size and increase the related buffer pool size.

CR:709963

CR Number:   709963 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) 19 Jun 2012 Fixed Description If a union view creator does not specify the owner of base views, it could get error msg 225 if the same base view name is created by an sa and the union view creator.

CR:710043

CR Number:   710043 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 Jun 2012 Fixed Description Create cluster using sybcluster failed with message, "Unable to retrieve the environment variables to run the Sybase tools".

CR:710048

CR Number:   710048 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) 04 Jun 2012 Fixed 05 Jun 2012 Presently Not Targeted For Any Future Release Of This Product 04 Jun 2012 Fixed 06 Jun 2012 Reservation Made 05 Jun 2012 Fixed Description A 1525 error, "Sort Failure. Rollforward of sort encountered sort descriptor timestamps out of sequence. Old timestamp in log: <old_ts>. New timestamp in log: <new_ts>. Timestamp in sort descriptor: <sort_ts>.", may be reported when loading a transaction dump that contains a CREATE INDEX command that was executed using parallel sort. ASE should have disallowed a transaction dump to be taken if it contains a parallel index creation. Workaround Description  Set the database option 'enforce dump tran sequence' to 'true'. This will disallow the option 'select into/bulk copy/pllsort' from being set and therefore the index creation will be executed in serial.

CR:710057

CR Number:   710057 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2013 Fixed 23 Apr 2014 Fixed Description The timing and IO metrics in monCachedStatement for running queries were unchanged until the query completed. Four new columns have been added to provide intermediate updates. The new columns are called TotalLIO, TotalPIO, TotalCPUTime and TotalElapsedTime.

CR:710125

CR Number:   710125 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2012 One-off Provided 29 Jan 2013 Fixed 24 Apr 2013 Port Not Needed 27 Nov 2013 Presently Not Targeted For Any Future Release Of This Product 16 Dec 2013 Port Not Needed Description rdesmgr_spinlock is hot, with lot of acquires and spins in some customer scenarios.

CR:710240

CR Number:   710240 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Microsoft Windows Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2012 Fixed Description Sybmon would report a signal 11 error when the quite command is executed on 32bit or 64bit windows platform.

CR:710300

CR Number:   710300 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 Aug 2012 Fixed 16 Sep 2012 Fixed 11 Sep 2012 Fixed Description Deploy plugin raises an error but reports that it succeed

CR:710328

CR Number:   710328 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) 06 Jun 2012 Fixed Description In rare circumstances the server can be shutdown after an error in the module dbts_commits_remxdes() followed by a message 'The Begin Timestamp=<n> of the completing transaction in database # is lower than the Database Commit Timestamp=<n>'.

CR:710333

CR Number:   710333 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 The result set may not be correctly sorted in descending order when the SELECT statement has the ORDER BY DESC clause and the FOR BROWSE option.

CR:710430

CR Number:   710430 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#2 14 Sep 2012 Fixed 15.7 ESD#2 19 Sep 2012 Fixed Description A histogram with a range cell at the very end of the histogram may have the weight of the lower bound of the cell incorrectly added to the last cell. Range cells by convention are exclusive of the lower bound of the cell. This may result in mis-estimates and poor query plans when predicates in queries reference the lower bound value. This is especially true if the lower bound has a high row count associated with it.

CR:710495

CR Number:   710495 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2012 Fixed Description On Linux platforms, monThreads.OSThreadID is sometimes reported as a negative number that does not match the OS reported thread ID.

CR:710496

CR Number:   710496 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2012 Fixed 12 Jun 2012 Fixed 11 Jun 2012 Fixed Description When Replication Agent is enabled to use the multipath distribution per connection model, and if the option "ddl path for unbound objects" is set to "default", it is possible that DDL commands are replicated to the incorrect path. Workaround Description  This is an isssue when the following conditions are all met: a) having multiple paths AND b) using the per connection distribution model AND c) replicating DDL commands Possible workarounds until a fix is available: a) do not use the per connection distribution model OR b) do not replicate DDL commands OR c) make sure to have 1 path configured only

CR:710536

CR Number:   710536 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 Jun 2012 Fixed 13 Jun 2012 Fixed Description Data may be corrupted during page compression if there is a compressed in-row LOB column in the table.

CR:710575

CR Number:   710575 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 Request to improve the accuracy of index creation time estimates from sp_estspace

CR:710582

CR Number:   710582 Product Name:   Adaptive Server Enterprise Product Component:   xmlconnect Status:   Open OS:   AIX Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description webservices FR: ASE Webservice support for WS-Security soap mechanism in 15.7x

CR:710589

CR Number:   710589 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2012 Fixed Description Column statistics histogram may be skewed in the last histogram step if the total sampling row count is greater than 2,147,483,647 when updating statistics.

CR:710594

CR Number:   710594 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) 06 Jul 2012 Fixed 06 Jul 2012 Reservation Made 06 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description DBT_SPIN is hot when there are lot of queries or stored procedures that work across multiple databases.

CR:710603

CR Number:   710603 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) 06 Jun 2012 Fixed 08 Jun 2012 Fixed Description A 1163 error, "The space allocated to the sysgams table in database 'tempdb' (dbid = 2) must be at least 16 pages.", together with a stack trace which includes the modules 'pggam__srchonegampage', 'pg_allocate_syslogs' and 'crdb__logtrunc' may be reported at ASE startup if the system tempdb is bigger than 63GB and has dedicated log devices which are placed out of the 63GB range. Workaround Description  1. Use data and log mixed devices only. Or 2. Place the dedicated log devices for tempdb within the limits of 63GB. For example: alter database tempdb on tempdb_dat1 = '10G' go alter database tempdb on tempdb_dat2 = '10G' go alter database tempdb log on tempdb_log1 = '10G' go alter database tempdb on tempdb_dat3 = '10G' go alter database tempdb on tempdb_dat4 = '10G' go alter database tempdb on tempdb_dat5 = '10G' go alter database tempdb on tempdb_dat6 = '10G' go alter database tempdb on tempdb_dat7 = '10G' go sp_logdevice tempdb, tempdb_log1 go

CR:710683

CR Number:   710683 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Contrary to the documentation, trigger 'self_recursion' remains on even after the trigger with 'self_recursion' causes another trigger to file. Workaround Description  For some reason adding a login profile eg: create login profile log_prof with default database j11731222 authenticate with ASE track lastlogin FALSE changes the behaviour.

CR:710693

CR Number:   710693 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 Jun 2012 Fixed Description For the jobs having repeat interval of one minute, if job creation time is less than starttime of job, second execution of the job is missed. In addition, for the jobs having repeat interval of one minute, if starttime is greater than or equal to endtime, alternate executions of the job are missed after midnight till endtime. Finally, for the jobs having the same startime and endtime with any repeat interval, the job starts executing before starttime if startdate is same as job creation date.

CR:710754

CR Number:   710754 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2012 Fixed Description When sort_resources is on, negative row count maybe be reported when executing CREATE INDEX, UPDATE INDEX STATISTICS or UPDATE ALL STATISTICS on table with more than 2147483647 rows.

CR:710755

CR Number:   710755 Product Name:   Adaptive Server Enterprise Product Component:   coverletter Status:   Open OS:   all Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) Description doc request: make the ebf coverletter for n-offs more specific

CR:710843

CR Number:   710843 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2012 Fixed 13 Jun 2012 Fixed Description While running a batch of ADD or DROP constraints out of which a few fail due to valid reasons, the subsequent ADD/DROP constraints may fail with the error 4956. Workaround Description  Run dbcc cacheremove() on the table before running the faulty 'alter table add foreign key' sql.

CR:710847

CR Number:   710847 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2012 Fixed 22 Jun 2012 Fixed 21 Jun 2012 Fixed 23 May 2014 Fixed 27 May 2014 Fixed Description The error messge, "Page Verification Error: Virtual page <page_num> in device <dev_num> is out of database range." may be reported in the Backup Server error log as a result of a LOAD DATABASE command. Workaround Description  Dump the database and recreate it in such a way that all the fragments created in the same device are in vstart ascending order. This problem happens when we do something like this: create database db1 on dev1 log on dev2 create database db2 on dev1 log on dev2 alter database db on dev1 drop database db2 alter database db1 on dev1 After altering the database the second time, the vstart will not be in ascending order anymore. To fix this, you only have to do this: dump database db1 create database db1 on dev1 log on dev2 alter database db on dev1 alter database db on dev1 load database db1

CR:711008

CR Number:   711008 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) 15 Jun 2012 Fixed 15 Jun 2012 Fixed 22 Jul 2012 One-off Provided 26 Jul 2012 Fixed Description ASE becomes unresponsive, ASE's network controller thread loops consuming 100% of one cpu.

CR:711082

CR Number:   711082 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 This feature request is to modify the architecture of concrete identification (introduced in version 12.0) to allow implicit permissions to be granted on an underlying object used by a stored procedure (or equivalent) when the object is in a different database and was created by a different login than that which created the stored procedure. The logins used to create both stored procedure and object would be aliases to the same equivalent user in each database. The current behaviour is a documented restriction:- http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01672.1570/html/sec_admin/BABHCJBA.htm?resultof=%22%63%6f%6e%63%72%65%74%65%22%20%22%63%6f%6e%63%72%65%74%22%20%22%69%64%65%6e%74%69%66%69%63%61%74%69%6f%6e%22%20%22%69%64%65%6e%74%69%66%22%20%22%63%72%6f%73%73%2d%64%61%74%61%62%61%73%65%22%20

CR:711106

CR Number:   711106 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 Jul 2012 Fixed Description OPTDIAG and sp_showoptstats has been enhanced to support Precomputed Resultsets.

CR:711156

CR Number:   711156 Product Name:   SCC Web Framework Product Component:   Alert Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2012 Fixed Description This resolution fixes an issue with alert creation for IQ with logical servers where when the resource property alert page is refreshed after the alert is created, the alert may be displayed multiple times depending on the number of logical servers defined.

CR:711168

CR Number:   711168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2012 Fixed 18 Jun 2012 Fixed 15 Jun 2012 Fixed 25 Jun 2012 Reservation Made Description In rare circumstances, when the ASE configuration parameter "disable varbinary truncation" is set to 1, a delete from a DOL table which has a unique index which has varbinary columns may hit a 644 error, "Index row entry for data row id (Pageid, Rowid) is missing from index page <page id> of index id <index id> of table <table name> in database <db name>. Xactid is (<Transaction Id>). Drop and re-create the index."