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

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

CR:694051

CR Number:   694051 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 Aug 2012 Fixed Description avoid redundant logging for updates with the identical values

CR:694123

CR Number:   694123 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) 09 Jan 2012 Fixed 27 Jun 2012 Fixed Description The 10330 error message is issued on a select from a join with a normal table and a view after dump/load database. The view and the normal table both have encrypted columns that have decrypt_default. The server has restricted decrypt permission set. Workaround Description  1.Reboot ASE after loading the database(which not feasible) 2.Issue "grant all to null" after load database to force permission to be checked at the catalog level.

CR:694167

CR Number:   694167 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 Apr 2012 Fixed 10 Apr 2012 Fixed 10 Apr 2012 Fixed Description When using the distribution by connection model and "ddl path for unbound objects" is set to "default", DDL is not replicated to the correct path. Workaround Description  There is no workaround for this problem because the path that the unbound object is sent to is random depending on the modulus of the spid divided by the number of paths.

CR:694188

CR Number:   694188 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) 03 Jan 2012 Fixed Description The message "current process infected with 11" in the module 'sg_simulate_corruption' together with a stack trace which includes the modules 'bt_traverse_get_apf_pagenos' and 'getcachedpage' may be reported in the error log during the rollback of a transaction either at run time or at ASE boot recovery stage, when the recovery fault isolation feature for a user database, which governs how recovery behaves when it detects data corruption, is active.

CR:694197

CR Number:   694197 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) 03 Jan 2012 Fixed Description Executing 'sp_encryption null, login_passwd_check' may mistakenly report that the key copy's login password is not synchronized with the assignee's login password.

CR:694262

CR Number:   694262 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2012 Fixed Description When using BCP to import data to a Page-locked table that permits nonmaterialized columns, ASE will incorrectly report that a data set contains badly formatted rows if it happens that the first row in the data set has a NULL immediately preceding the first nonmaterialized column in the row.

CR:694368

CR Number:   694368 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) 05 Jan 2012 Fixed Description The OSPID value in the monEngine MDA table does not match with the osprocid value in sysengines.

CR:694401

CR Number:   694401 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 Apr 2012 Fixed Description Job Scheduler does not print error messages in the error log without trace flag 3641.

CR:694407

CR Number:   694407 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2012 Added to user documentation Description Documenting change request: As of 12.5.3 ESD #3, the QUIESCE DATABASE and UNMOUNT DATABASE commands are allowed to operate on any number of databases. This is the result of CR 379513. Currently, the QUIESCE DATABASE docs specify: You can specify a maximum of eight databases in a single quiesce database hold command. If you must suspend updates to additional databases, execute additional quiesce database hold commands.

CR:694413

CR Number:   694413 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2012 Fixed Description Decompression may fail when we update one forwarded row during RID scan.

CR:694417

CR Number:   694417 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description investigate options for kernel.randomize_va_space

CR:694470

CR Number:   694470 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 New Feature Request: for configuration option to prevent users without decrypt permission from updating encrypted columns. Workaround Description  Ensure that update permissions are always kept synchronised with encryption permissions.

CR:694488

CR Number:   694488 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) 10 Jan 2012 Fixed 18 Jan 2013 One-off Provided 25 Jun 2012 Fixed Description In rare circumstances the message "Infected with 11" together with modules like s_cleanframe, s_senddone followed by spid termination may occur when set statistics time is enabled with a create proc referencing a non-existent temporary table and a particular Sybase supplied traceflag is enabled.

CR:694495

CR Number:   694495 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 SP102 19 Jun 2013 Fixed 15.7 SP110 19 Jun 2013 Fixed 29 Aug 2013 Fixed Description The command DBCC SETTRUNC('ltm', 'end') extends the transaction log with one page before setting the Secondary Truncation Point to the new end of the log so as to avoid unwanted data replication.

CR:694511

CR Number:   694511 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) 09 Jan 2012 Fixed 11 Jan 2012 Fixed 10 Jan 2012 Fixed Description Introduce randomization in TDS login protocol (CVSS Rating: 5.5)

CR:694531

CR Number:   694531 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) 09 Feb 2012 Fixed 10 Feb 2012 Fixed Description When the proxy table contains a LOB column, executing an INSERT-SELECT queries joining a local and proxy column may hang or result in Ct-library errors such as "Ct-library: Msg 0x0101013e Fatal (Layer=1 Origin=1 Severity=1 Number=62): ct_get_data(): user api layer: external error:". Workaround Description  Use trace flag 11239 to disable the fix of 646397. The trace flag may be turn on via -T11239, or dbcc traceon(11239).

CR:694571

CR Number:   694571 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Impementation to error 2780 to reports details about the object

CR:694606

CR Number:   694606 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined Description Kerberos support is needed in DBISQL for it's access to ASE. The support should be available from Sybase Central when using DBISQL also.

CR:694678

CR Number:   694678 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2012 Fixed 02 May 2012 Reservation Made Description The SsqlId column in the monSysStatement MDA table incorrectly shows zero instead of the correct statement cache ID.

CR:694724

CR Number:   694724 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2012 Fixed Description In ASE Cluster Edition, during cluster reboot after a shutdown cluster with no_wait has happened, in rare circumstances the cluster is not bootable, with 12314 error and a stack trace with "des__set_clstats".

CR:694750

CR Number:   694750 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) 09 Jan 2012 Fixed Description For a table which has more than one LOB columns, if one LOB column is set to be replicated and at least one of other LOB column which follows the replicated LOB column is compressed, update on the compressed LOB columns may not take effect.

CR:694804

CR Number:   694804 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   AIX Original Version:   2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2012 Fixed Description SYSAM is not checking the number of CPU after changing from SMT-4 to SMT-2 Workaround Description  Problem can be workarounded by setting SYBASE_SAM_CAPACITY=MACHINE.

CR:694828

CR Number:   694828 Product Name:   SCC Web Framework Product Component:   Security Status:   Closed OS:   Generic Original Version:   3.2.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2013 Presently Not Targeted For Any Future Release Of This Product Description Need to have SCC support complete single signon access via Kerberos (Unix/Windows) and SSPI (Windows).

CR:694839

CR Number:   694839 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 When there is non-contiguous free space between rows (due to a row shrinking) in DOL tables, the length is stored at the beginning of the free space. If that freespace length value is incorrect, DBCCs report a variety of misleading error messages including 614, 7928, 9991.

CR:694912

CR Number:   694912 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) 13 Jul 2012 Fixed 25 Jan 2012 Added to user documentation 25 Jul 2012 Fixed Description Exception is raised from localize command in sybcluster if ASE-15_0/locales contains unnecessary files/dirs.

CR:694916

CR Number:   694916 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2012 Fixed Description In rare circumstance, 691 error, "Encountered invalid logical page '<page no>' while accessing <parition name>. This is an internal system error. Please contact Sybase Technical Support.", may be raised when inserting data in bulk mode into replicated table with compression and LOB columns while sp_reptostandby is turned on.

CR:694939

CR Number:   694939 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) 12 Mar 2012 Fixed Description Error 11060 may be raised by an INSERT into a view with an INSTEAD OF TRIGGER when SET CIPHERTEXT is ON and no encrypted columns on the underlying table.

CR:694946

CR Number:   694946 Product Name:   SCC Web Framework Product Component:   Repository Status:   Closed OS:   Generic Original Version:   3.2.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2012 Fixed 10 Jan 2012 Fixed Description This resolution fixes an upgrade defect from SCC 3.2.3 to 3.2.4.

CR:694961

CR Number:   694961 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) 11 Jan 2012 Fixed 20 Jan 2012 One-off Provided 09 Nov 2012 Fixed Description Reservation conflict messages may appear in the system log on systems with multipathing when I/O fencing is enabled.

CR:694980

CR Number:   694980 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) 13 Feb 2012 Fixed Description In ASE Cluster Edition when the 'print deadlock information' configuration option is set or traceflag 1204 is turned on, for locks involved in the deadlock, incorrect identity may be printed when the lock is a Globally Unique Identifier (GUID) lock.

CR:695090

CR Number:   695090 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 Apr 2012 Fixed Description In extremely rare circumstances under Multiple Path Replication, it is possible that the retrieval order of path information from sysattributes could be different between Rep Agent runs causing log data to be sent to different Rep Servers which could lead to undetected duplicate records on the replicate database.

CR:695113

CR Number:   695113 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to change where the threshold action proc runs in a multi-node cluster.

CR:695135

CR Number:   695135 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) 12 Jan 2012 Fixed 04 Apr 2012 Fixed Description The message, " Expected object passed to kmuxtskGetThreadpool is not of type Multiplexed Task", is reported in the errorlog.

CR:695156

CR Number:   695156 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2012 Fixed 01 Oct 2012 Fixed Description When ASE is configured with multi-bytes charset with 'statement cache' and 'literal autoparam' enabled, repeatedly executing a SQL batch with comments containing multiple byte characters can cause error 102.

CR:695217

CR Number:   695217 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   chambord Fixed Version Build Resolution Date Closure Code (If Appropriate) Description PDM > XML generation: length and precision of columns/domains defined in PDM are missing in corresponding simply types. As examples, - number(s,p) becomes xs:decimal, length and fraction digits are both empty. - varchar(n) becomes xs:string and length is empty. This also happens with columns not associated to any domain: length and precision have been lost.

CR:695221

CR Number:   695221 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) 19 Jan 2012 Fixed Description Upgrade fails when system tables are bound to a named cache. Workaround Description  1. Before shutting down the old-version ASE for upgrade: drop cache bindings or delete rows from sysattributes 2. Or, after shutting down the old version server: edit the config file to remove the user defined named cache(s). After either of these workarounds, start ASE 15.7. It will mark cache bindings as invalid, and upgrade will succeed. When upgrade is complete, recreate the named cache(s) and re-bind system tables to the cache(s).

CR:695224

CR Number:   695224 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 Allow "max resource granularity" 50% hard limit to be configurable

CR:695283

CR Number:   695283 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) 01 May 2012 Fixed Description Under some rare conditions, the message, "current process infected with signal 11", together with a stack trace involving the functions s__setup_tabsdes() and s_setuptables() or a 8201 error message may be reported when multiple processes are running stored procedures involving many tables.

CR:695390

CR Number:   695390 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2012 Fixed Description The message "current process infected with 11" in the module 'LeRun' together with a stack trace which includes the modules 'LeBulkOpOpen' and 'bulk_main' may be reported in the error log when running a bulk copy operation into a table defined with materialized computed columns involving expressions using system functions like CURRENT_BIGDATETIME(), GETDATE(), etc.

CR:695552

CR Number:   695552 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) 26 Mar 2012 Fixed 28 Mar 2012 Fixed 05 Apr 2012 Fixed Description Error 9275, "Could not locate the before image for the INSERT log record at (<page_number>,<row_number>).", may be reported by the RepAgent thread when a table that has compressed rows is marked for replication, resulting in the RepAgent thread terminating itself.

CR:695556

CR Number:   695556 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Open OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DBISQL needs user guide/reference manual

CR:695557

CR Number:   695557 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) 21 Sep 2012 Fixed 27 Sep 2012 Fixed 30 Aug 2013 Added to user documentation Description Allow a nondefault sql.ini location to be specified in dbisql

CR:695592

CR Number:   695592 Product Name:   Adaptive Server Generic Docs Product Component:   Security Administration Guide Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2012 Added to user documentation Description To document syslogins.audflags

CR:695614

CR Number:   695614 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If the old RUN_<server> file has multiple -T arguments, sqlupgrade[res] only copies the last -T argument to the new RUN_<server> file. Workaround Description  Manually add missing trace flag arguments in new RUN_<server> file after the upgrade.

CR:695655

CR Number:   695655 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) 10 Apr 2012 Fixed 05 May 2012 Fixed Description The 420 message, "The TEXT, IMAGE and UNITEXT datatypes cannot be used in an ORDER BY clause or in the select list of a query in a UNION statement.", may be reported when selecting a TEXT column from a proxy table in a UNION ALL query.

CR:695738

CR Number:   695738 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2012 Fixed 27 Jan 2012 Fixed Description For the schedules running over midnight, Job Scheduler sometimes misses execution of first valid schedule job and sometimes executes scheduled job on invalid schedules time.

CR:695763

CR Number:   695763 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2012 Fixed 14 May 2012 Reservation Made Description ASE running on Windows platform may exit with no message, stack trace or other indication in the error log when stack limits are exceeded.

CR:695852

CR Number:   695852 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2012 Added to user documentation Description A spelling error "sp_temodb" is found in P&T: Physical Database Tuning. It should be sp_tempdb.

CR:695917

CR Number:   695917 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2012 One-off Provided 02 Jul 2012 One-off Provided 01 Aug 2012 One-off Provided 17 Dec 2013 Port Not Needed 17 Dec 2013 Port Not Needed Description Instrumentation: Under heavy i/o load on HPIA64 platform, ASE may report infected with signal 11 followed by a stack trace with iocRunController() and basis_dpoll() on the stack.

CR:695923

CR Number:   695923 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows 2003 Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2012 Fixed Description During an upgrade from ASE 15.5 to ASE 15.7, an error may occur on upgrade step [ID 246]: clear unused columns (table sysindexes). This is followed by a storage access violation with a stacktrace involving the modules 'upgd__do_clear_columns', 'collocate' and 'col_find_default'. Workaround Description  None found so far.

CR:695927

CR Number:   695927 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2012 Fixed Description The values of the ExclusiveLockWaitTime, SharedLockWaitTime and UpdateLockWaitTime columns in the monOpenObjectActivity MDA table are not updated when queries are blocked by locks. Workaround Description  Enable traceflag 1213

CR:695937

CR Number:   695937 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The request requires the function base index column not to get mapped over on remote site.

CR:696006

CR Number:   696006 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 2012 Duplicate 30 Apr 2012 Duplicate Description The message, "current process infected with signal 11" in the function 'pthread_mutex_lock', together with a stack trace involving the function 'os_get_prev_stk_desc' may be reported in the errorlog under heavy loads.

CR:696020

CR Number:   696020 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Linux Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2012 Added to user documentation Description 32-bit GNU C Libraries package (glibc-2.xx-x.xx.el6.i686.rpm) also needs to be installed before installing ASE 15.7 64-bit to a Redhat Enterprise Linux 6.x x86_64.

CR:696067

CR Number:   696067 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2012 Fixed Description ASE running on IBM AIX platform stack traces with exception code 4 in iocPoll+0x54().

CR:696150

CR Number:   696150 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) 20 Jan 2012 Fixed Description When changing the replication status of a table, error 7941 may be reported when processing a table whose owner is not the current user or the dbo.

CR:696227

CR Number:   696227 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2012 Fixed 05 Apr 2012 Fixed Description In-place upgrade from older versions of ASE to ASE 15.7 may fail because the new ASE fails to start with error "The configured value '4096' for parameter 'kernel resource memory' is too low.". This occurs when ASE is configured with large "number of user connections" and "open indexes". Workaround Description  Reducing 'number of user connections' from 5500 to DEFAULT and 'number of open indexes' from 300,000 to DEFAULT allows the ASE 15.7 to start. There may be other configs that will affect this.

CR:696250

CR Number:   696250 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) 17 Feb 2012 Fixed Description When executing the stored procedure, sp_reptostandby, the message warning that the execution can take a long time is not returned to the user immediately.

CR:696290

CR Number:   696290 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) 25 Jan 2012 Fixed 27 Nov 2012 Presently Not Targeted For Any Future Release Of This Product 12 Feb 2013 Fixed Description When a partitioned table has a local index and a query is used with a unbounded predicate and an order by clause that matches the key of the index, the query plan still uses a merge union all operator to preserve the sort ordering.

CR:696320

CR Number:   696320 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 Feb 2012 Fixed 22 Mar 2012 Fixed 22 Mar 2012 Fixed Description When the Job Scheduler is setup on a server whose master database is replicated, the replication of the DDL command executed on the primary ASE by the JS task to set the password of the 'jstask' user fails due to missing credentials in the LTL sent by RepAgent to Replication Server.

CR:696325

CR Number:   696325 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2013 Not reproducible with latest version of the product available as of Resolution Date Description Remote Server crashes when local server uses 'cis packet size' with different value from DEFAULT Workaround Description  Set 'cis packet size' in local server to DEFAULT value

CR:696329

CR Number:   696329 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) 24 Jan 2014 Insufficient priority to fix Description join order ignored from PLAN clause

CR:696416

CR Number:   696416 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) 04 May 2012 Fixed Description The DROP THREAD POOL command may lead to multiple stack traces, signals and timeslice errors.

CR:696440

CR Number:   696440 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2012 Fixed Description The Backup Server error, "The 'write' call failed for database/archive device while working on stripe device '<archive name>' with error number 22", may be raised if the trace flag 256 is used to enable DIRECT_IO on archive files and the dump is compressed.

CR:696470

CR Number:   696470 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) 25 Jan 2012 Not reproducible with latest version of the product available as of Resolution Date 19 Jun 2012 One-off Provided 19 Jun 2012 One-off Provided 05 Jul 2012 Fixed 08 Oct 2014 Port Not Needed Description In rare circumstances the message "Infected with 11" together with modules like senderror(),send_msg(), tdsrecv_errorhdl() followed by spid termination may occur when set statistics time is enabled with a create proc failed with syntax error.

CR:696493

CR Number:   696493 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2012 EOL'd version. Not to be Fixed. Description The services key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SybaseUAService is missing in winx64 for 15.5 esd #5 and 15.7 GA. Workaround Description  1) Create file "scc.reg" with following content. Change "C:\\Sybase" to your installed directory. Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SYBASE] @="" [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SYBASE\Unified Agent] "Agent Home"="C:\\Sybase\\UAF-2_5" "Service Version"="2.5" "Sybase Home"="C:\\Sybase" "JRE Home"="C:\\Sybase\\Shared\\JRE-6_0_24_32BIT" @="" 2) Using regedit.exe, import scc.reg file. 3) Run "%SYBASE%\UAF-2_5\utility\ntautostart\release>uaservice.exe -install"

CR:696515

CR Number:   696515 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2012 Fixed Description The signal 11 together with a stack trace which includes the modules 'inserttext' may be reported in the error log when a LOB column with NULL value is updated to itself with replication mode. Workaround Description  Putting a single blank space in all null columns works around this issue.

CR:696543

CR Number:   696543 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) 11 May 2012 Not reproducible with latest version of the product available as of Resolution Date Description sp_who may show a spid continuing to run (as opposed to sleeping) after KILL is issued. DBCC STACKTRACE(spid) shows module LeSortInputStream.

CR:696587

CR Number:   696587 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) 04 Jun 2012 Fixed Description In rare circumstances, a 644 error, "Index row entry for data row id (<pg>, <row>) is missing from index page <pg> of index id of table 'sysstatistics' in database '<db>'", may be reported during the load of an 12.5 database in a 15.7 dataserver. Workaround Description  Recreate the index on sysstatistics using sp_fixindex in a server prior to 15.7.

CR:696636

CR Number:   696636 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2012 Duplicate Description The message "current process infected with 11" together with a stack trace which includes the module 'omniCursorsInUse' may be reported in the errorlog when executing an UPDATE proxy table command in a cursor operation. Workaround Description  Enable 'enable xact coordination'

CR:696642

CR Number:   696642 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2012 Fixed 20 May 2013 One-off Provided 27 Apr 2013 Fixed Description The message, "current process infected with 11", together with a stack trace which includes the module 'ulreleasespinlock' may be reported in the ASE errorlog when the remote server is shut down abruptly using 'shutdown with nowait' when a transactional query is in progress.

CR:696649

CR Number:   696649 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 'drop view' inside stored proc does not replicate when proc is marked for replication.

CR:696669

CR Number:   696669 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) 10 May 2013 Insufficient priority to fix Description 3916 error when running a stored proc after ALTERing a table Workaround Description  Drop and recreate the affected procedures.

CR:696676

CR Number:   696676 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 Mar 2012 Fixed 19 Mar 2012 Reservation Made 19 Sep 2012 Fixed Description When a query with IN list chooses a special OR strategy, the query plan still shows a RESTRICT operator which is superfluous and can be quite expensive up to 35%

CR:696728

CR Number:   696728 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2012 Bundled Request Description DBISQL Feature Request: OEM.ini option to disable DBISQL 'Query Editor' (i.e. grey out the [Tools -> Edit Query] feature).

CR:696737

CR Number:   696737 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 ASE/CIS : If "strict dtm enforcement" is enabled, then the first time an RPC is executed on a remote ASE after it has been killed (or diconnected) and then restored will result in error 7223: "Cannot read from site '<local ASE>'". No error occurs if "strict dtm enforcement" is disabled. Workaround Description  Ignore first 7223 error after remote ASE is restarted.

CR:696804

CR Number:   696804 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) 19 Mar 2012 Fixed Description Login account locked due to inactivity remains locked even after being unlocked by sp_locklogin.

CR:696837

CR Number:   696837 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) 23 Mar 2012 One-off Provided 16 Feb 2012 Fixed 05 Nov 2012 Fixed Description In a 2 node or greater ASE Cluster Edition setup, a database with a log segment threshold defined may result in incorrect values for unreserved data pages and no thresholds enabled. The database will report log is full and transactions will either suspend or abort, depending on the configuration paremeter "abort tran on log full" value. This can only occur when the database has multiple thresholds and the second threshold is crossed before the first one is completely handled. Workaround Description  Workarounds: - Run with only 1 instance (other instances shutdown) - Have thresholds far enough apart so the thresholdaction proc can complete before another is spawned

CR:696869

CR Number:   696869 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) 02 Feb 2012 Fixed 03 Apr 2012 Fixed Description Errors 10850, 10860 and 10861 are wrongly reported as EX_USER, they should be EX_INFO.

CR:696882

CR Number:   696882 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 Running 'reorg rebuild' on tables in the dbcc checkstorage database 'dbccdb' will cause 'dbcc checkstorage()' to fail with error: Msg 9950, Level 17, State 2: "Workspace 'def$scan$ws' is incorrectly allocated. Use sp_dbcc_createws to create a new workspace." Workaround Description  Avoid running 'reorg rebuild' on dbccdb tables.

CR:696928

CR Number:   696928 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description deadlock victim followed by a retry the sproc, occasionally hits a 267 error on #temp table created within the sproc with a select into. Workaround Description  proposed: changing tables to DOL to avoid all this deadlocking global traceflag 7730 using execute ("create table #foo (x int) insert #foo values (5) select * from #foo") turn off 'deferred compilation'

CR:696973

CR Number:   696973 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) 09 Feb 2012 Fixed Description When migrating from Adaptive Server 15.5 or earlier to 15.7 using the sybmigrate utility and the 'quoted identifier enhancement' option is enabled on the target 15.7 server, an error message similar to "The specified object 'sp_migrate_db_lockprom' is not found in database 'testdb'." may be reported.

CR:697003

CR Number:   697003 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) 02 Feb 2012 Fixed Description When HA companion is dropped, sp_addexternlogin tries to acquire lock on companion server. This lead to following error: Could not acquire a lock within the specified wait period. DTM_SERVER level wait period=... Cannot lock table 'master.dbo.rmt_ha_sysattributes'. HA Internal Error: Cannot acquire locks for stored procedure 'sp_addexternlogin' on server ''. Retry later.

CR:697042

CR Number:   697042 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 May 2012 Consult Complete 03 Jun 2012 Consult Complete Description The message, "current process infected with signal 11" in the function 'pthread_mutex_lock', together with a stack trace involving the function 'os_get_prev_stk_desc' may be reported in the errorlog under heavy loads.

CR:697104

CR Number:   697104 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 Needs a new proc/function to calculate and report the remaining column space for a table for adding new columns in the table.

CR:697124

CR Number:   697124 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) 10 Apr 2012 Fixed Description When auditing is enabled for login events, then an incorrect audit message appears in the audit trail for Extended Encrypted Password login protocol and for Extended Plus Encrypted Password login protocol to describe the password encryption used.

CR:697125

CR Number:   697125 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2012 Fixed 05 Sep 2012 Fixed Description When using sp_downgrade to downgrade from 15.7 ESD#2 or later version of SDC server to 15.x SDC server, prepare will fail and raise message "One or more databases still permit wide DOL rows." on local system and global temporary databases.

CR:697129

CR Number:   697129 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2012 Fixed 13 Dec 2012 Fixed 21 Jan 2013 Fixed 21 Jan 2013 Reservation Made 22 Jan 2013 Fixed 23 Jan 2013 Reservation Made 30 Jan 2013 Fixed 23 Apr 2013 Fixed 27 Mar 2013 Reservation Made 24 Oct 2013 Fixed 19 Nov 2013 Fixed 27 Jan 2014 Fixed Description Supporting Lock Remastering for SAP ASE Cluster Edition. When the master assignment is set to affinity mode, the masters will gradually get re-allocated to the instances that initiates the lock convert requests, if enable lock remastering is set to 1(ON) in the configuration file. By default, enable lock remastering is set to 0 (OFF). It is not recommended to set enable lock remastering to 1 (ON) for badly partitioned cases.

CR:697138

CR Number:   697138 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2012 Fixed Description When network password encryption is used with the UTF8 character set, auditing is enabled for login events, and the password specified is longer than the ASE limit of 30 characters, then the client connection is closed instead of reporting the generic login failure error and no audit event with the cause of the failure is placed in the audit trail.

CR:697148

CR Number:   697148 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2012 Bundled Request Description DBISQL removes ASE-related preferences when closed without a connection to an ASE.

CR:697163

CR Number:   697163 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE can incorrectly run multiple engines under development license

CR:697172

CR Number:   697172 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: the ability to monitor the number of times tempdb session TLC is flushed independently of the ULC user log cache.

CR:697303

CR Number:   697303 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 While executing a repeating scheduledjob, the run_now job for same scheduledjob fails with its job state (jsh_state in js_history) set to B(Busy).

CR:697307

CR Number:   697307 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 Apr 2012 Fixed Description For data caches using strict replacement policy, the run_replacement and config_replacement column values are incorrect in the syscacheinfo and syscachepoolinfo views.

CR:697384

CR Number:   697384 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) 14 Feb 2012 Duplicate Description ASE may incur segmentation violation in the function uppwakeup under certain circumsnatnces when the number of engines is decreased via the command 'aleter thread pool'.

CR:697522

CR Number:   697522 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2012 Fixed 22 Feb 2012 One-off Provided 19 Mar 2012 Reservation Made 04 Apr 2012 Fixed 25 Jun 2012 Fixed Description In rare circumstances the message "Infected with 11" together with modules like ex_printmsg(), senderror() followed by spid termination may occur when SET STATISTICS TIME is enabled with a create proc referencing an existent temporary table and a particular Sybase supplied traceflag is enabled.

CR:697533

CR Number:   697533 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2012 Fixed 26 Apr 2012 Fixed 02 May 2012 Fixed 02 May 2012 Fixed 07 Jun 2012 One-off Provided Description ASE on Solaris platforms reports 694 or 823 errors along with messages like "kernel sddone: write error on virtual disk 3 block 145536", "kernel sddone: 16384 bytes passed, 0 returned on write for virt disk 3 block 145536" or "kernel sddone: read error on virtual disk 6 block 6812351", "kernel sddone: I/O error". There are no corresponding disk i/o error messages reported in the Operating System logs.

CR:697542

CR Number:   697542 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) 10 Feb 2012 Fixed Description ASE may raise error 8201, when number of open object, indexes, partition is insufficient. Workaround Description  Increase number of open objects/indexes/partitions.

CR:697546

CR Number:   697546 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 Mar 2012 Fixed 29 Mar 2012 Fixed 30 Mar 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 in the error log during the replication of a table that has compressed TEXT/IMAGE data.

CR:697573

CR Number:   697573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE should impose ASE login policy when LDAPUA or PAM configured but not functional