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

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

CR:452368

CR Number:   452368 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2007 Fixed Description Max and min vector aggregation can result in sigsegv when operate on unichar and univarchar columns. Workaround Description  Use traceflag 450 to force old-school grouping algorithms.

CR:452430

CR Number:   452430 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2009 Added to user documentation Description Need to document maximum batch size for bcp. Maximum batch size is 65536.

CR:452442

CR Number:   452442 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2007 Fixed 18 Apr 2007 Fixed 30 Apr 2007 Fixed Description OR-clauses may not be evaluated if the query qualification references a column with the decrypt_default attribute. In SQL statements containing qualifications of the type WHERE dd_col = <value> OR non_dd_col = <value>, where dd_col is an encrypted column with the decrypt_default attribute and non_dd_col is a column without the decrypt_default attribute, the WHERE clause will disqualify all rows if the user executing the query does not have decrypt permission on dd_col.

CR:452482

CR Number:   452482 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2007 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description Encryption Column feature is now available on linuxamd64 platform.

CR:452493

CR Number:   452493 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2007 Fixed Description In rare circumstances, a spid waiting for reception of a JMS message may generate a memory leak if it is interrupted by either a kill operation or reception of an ATTENTION sent by the client application.

CR:452558

CR Number:   452558 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2007 Fixed 11 Jan 2007 Fixed 10 Jan 2007 Fixed 11 Jan 2007 Fixed Description Update the bundled JRE release to address the following issues: 1) The implementation of RSA signature verification in SSL/TLS, or other application scenarios, may incorrectly verify forged signatures leading to security vulnerability. See http://www.sybase.com/detail?id=1047991 for more details. 2) U.S. Daylight Saving Time Changes in 2007, see http://www.sybase.com/detail?id=1048699 for more details.

CR:452610

CR Number:   452610 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2007 Fixed 17 Jan 2007 Fixed Description The builtin function object_name() incorrectly returns NULL for any master-only system table in a database other than 'master', that has been loaded with a database dump of the master database.

CR:452658

CR Number:   452658 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2007 Fixed Description In rare circumstances, deadlock may occur on updating sysqueryplans after 'enable metrics capture' set to 1

CR:452731

CR Number:   452731 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2007 Fixed 15 Mar 2007 Fixed 11 Jun 2007 Fixed Description Added support of gbpinyin and gbpinyinnocs sortorders for Chinese character sets EUCGB, CP936, GB18030 and UTF-8. For existing installation, please run select sortkey(null, 'all') to populate syscharsets table with the new sortorders. And run sp_helpsort to get the new sortorder id.

CR:452735

CR Number:   452735 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2007 Fixed 13 Mar 2008 Not a Bug 13 Mar 2008 Not a Bug Description With traceflag 1649 active, ASE fails to initialize devices (like tmpfs) which does not support KAIO. Also databases on these devices (created before using traceflag 1649) fails to come online with error 823. Workaround Description  Do not use KAIO (i.e. traceflag 1649).

CR:452764

CR Number:   452764 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2007 Fixed Description Sybase Central sorts columns incorrectly should be able to sort by syscolumns.colid so that the user can sort the columns in the same order as they were created.

CR:452782

CR Number:   452782 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2007 Fixed 20 Mar 2008 Presently Not Targeted For Any Future Release Of This Product Description If a Kerberos login attempt blocks during security session establishment reading the security opaque token from the client, it can hold an engine-wide security semaphore effectively blocking all other Kerberos login attempts. A new trace flag 7850 is added to timeout security connections if no security opaque token is received from client in 60 seconds.

CR:452801

CR Number:   452801 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2007 Fixed Description Stacktrace in RcToAndOrTree() could happen when a column is compared with a scalar aggregate result under an OR predicate and the same column appears under the OR predicate multiple times. For example, (A >= (select min(A) from t2) or A >= (select min(A) from t3)).

CR:452819

CR Number:   452819 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2007 Fixed 25 Jan 2007 Fixed Description When the jconnect and ctlib send a varchar longer than 255 bytes,in some cases it could cause stacktrace in memalloc() with 702 error since it requests 2147483647 bytes memory.

CR:452850

CR Number:   452850 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2007 Fixed Description Synchronize the new options "expire login passwords", "expire role passwords", "expire stale login passwords" and "expire stale role passwords" added to sp_passwordpolicy on companion server.

CR:452998

CR Number:   452998 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2007 Fixed Description Server status was checked periodically even though user unchecked the plug-in setting. This has been fixed.

CR:453005

CR Number:   453005 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2007 Not reproducible with latest version of the product available as of Resolution Date 07 May 2007 Not reproducible with latest version of the product available as of Resolution Date Description ASE sends corrupt TDS converting to utf8 characters to jConnect clients causing the client to exit with error: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0EM: End of data. Workaround Description  Use convert(varchar(), col). This stops ASE sending TDS_LONGCHAR type and the problem does not occur.

CR:453021

CR Number:   453021 Product Name:   Adaptive Server Enterprise Product Component:   sql Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.2 13 Apr 2007 Fixed Description The missing sample directories (JavaXml, esp, histsrvr, messaging, server, and sybmigrate) have been added back into ASE 15.0.2.

CR:453032

CR Number:   453032 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2008 Third Party Problem 05 Nov 2008 Third Party Problem Description Calling a stored procedure residing in IQ from ASE via rpc parameter names are ignored, they are taken as positonal parameters. Workaround Description  Fill up all arguments in the rpc call. i.e. exec iqw...maxs_test_p @blah1 = 'One', @blah2 = '', @blah3 = '', @blah4 = 'Four'

CR:453037

CR Number:   453037 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2007 Fixed Description The spelling of sybprocs in message Building sysprocs device and sybsystemprocs database .... sybprocs device and sybsystemprocs database created is not correct, it should be sysprocs.

CR:453041

CR Number:   453041 Product Name:   Sybase ETL Product Component:   other Status:   Closed OS:   all Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2008 Fixed Description Problem: ETL does not allow multi-byte characters to be used in the meta-data Resolution: The ETL product has been modified to handle multi-byte meta-data.

CR:453088

CR Number:   453088 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.2 02 Feb 2007 Fixed Description In some exception case, print SQLTEXT could stacktrace from terminate_process().

CR:453103

CR Number:   453103 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2007 Fixed 15.0.3 28 Mar 2008 Fixed Description After primary service group fails over to secondary node, the primary HAase resource cannot go offline if the secondary ASE resource is already offline. The failure to go offline properly may also prevent primary HAase resource from going online on secondary node later even if primary ASE resource is brought back online. Workaround Description  - manually set the Cmpstate to 0: ilk_db2# haconf -makerw ilk_db2# hares -modify sybaseDB1 Cmpstate 0 ilk_db2# haconf -dump makero - wait for sybaseDB1 to become offline - manually re-set the Cmpstate to 1 ilk_db2# haconf -makerw ilk_db2# hares -modify sybaseDB1 Cmpstate 1 ilk_db2# haconf -dump makero - wait for sybaseDB1 to become online After this exercise it looked normal again (sybaseDB1 being online on Node 2). We then performed a failback which worked without any problems.

CR:453216

CR Number:   453216 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2009 Fixed Description When the Windows eventlog is full and cannot be written, ASE repeatedly issues the warning message that the write to the event log failed, it should still issue the message but only at intervals. Workaround Description  reset the windows event log to either a larger size, to overwrite old events as needed, or both

CR:453218

CR Number:   453218 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2007 Fixed 09 Mar 2007 One-off Provided 13 Jun 2007 One-off Provided Description Improve login performance.

CR:453273

CR Number:   453273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2007 Fixed 06 Sep 2007 Fixed Description In rare circumstances, concurrent dmls to very large data-only locked tables may cause index corruption, resulting in 644 errors: "Index row entry for data row id <pageid, rnum> is missing from index page <indexpage> of index id <indid> of table <tabid> in database <dbid>. Xactid is <xactid>. Drop and re-create the index." Running online index reorg may cause self-deadlocks and 12311 errors, and dbcc checktable may report corruption.

CR:453275

CR Number:   453275 Product Name:   Adaptive Server Generic Docs Product Component:   XA Guide for CICS Encina and Tuxedo Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2007 Fixed Description Need to document new CIS server class RPCServer

CR:453288

CR Number:   453288 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2007 Fixed Description [internal only] A customer's database was broken, contained index entries for sysencryptkeys but no object entry. This caused upgrade to fail in upgrade step 7 with no useful error.

CR:453339

CR Number:   453339 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2007 Fixed 06 Mar 2007 Fixed Description When ASE is booted with 16k page size, installmaster script may fail to complete with following message: "The current 'max memory' value '32768', is not sufficient to change the parameter 'allow updates to system tables' to '1'". Workaround Description  Value of "max memory" of cfg file is rewritten to "45056." But customer has to do all work manually. 16k server cannot be created using srvbuild.

CR:453367

CR Number:   453367 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2007 Fixed 01 May 2007 Not a Bug Description The query, "ALTER TABLE MODIFY <column_name> NULL ENCRYPT WITH <encr_key> DECRYPT_DEFAULT NULL", failed with an 13975 error message, "You may not declare a null-valued decrypt_default on column <column_name> because that column is not nullable".

CR:453374

CR Number:   453374 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2008 Fixed Description Concurrent executions of pageinfo built-in give different kinds of errors and stacktraces, like Error 833, "Attempt to read logical page into a buffer, that is hashed".

CR:453380

CR Number:   453380 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2007 Fixed Description Feature Request: "maximum failed logins" set to '-1' increments syslogins.logincount on every login failure.

CR:453446

CR Number:   453446 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2007 Fixed 13 Feb 2007 Fixed 13 Feb 2007 Fixed Description XPserver sometimes fails to come up on 64bit platforms with the following error in the errorlog, "os_syscmd: system function returned error. OS error string: Bad address".

CR:453474

CR Number:   453474 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2007 Fixed 28 Feb 2007 Bundled Request Description sp_help is enhanced to display the decrypt_default information for all decrypt_defaults declared on a table. This information consists of the internal name of the decrypt_default.

CR:453503

CR Number:   453503 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2007 Fixed Description When different data type comparison is done, ase returns wrong data. ex) create table cr453503 (deccol decimal(6,2),sintcol int) go insert into cr453503 values (1, 1) insert into cr453503 values (2, 2) insert into cr453503 values (3, 3) go select * from cr453503 where ( sintcol = deccol ) and ( deccol is not null) ase will return 0 row. Workaround Description  Please replace order of select column. decimal column is moved to back from the 2nd.

CR:453512

CR Number:   453512 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2007 Fixed Description When server's default sortorder is one of Unilib sortorders, and the statement matches a char variable in the like clause against an unichar column, 2432 error might be raised.

CR:453529

CR Number:   453529 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2007 Fixed 19 Nov 2007 Fixed Description On occasion, the alter table function raises an exception in adc__update_sysreferences() and getnext() when a column is dropped from the original table definition. Workaround Description  A work around would be to create a new table using select c1,c2,c3..into new_table from old_table, excluding the column(s) to be dropped and then when the new table has been created drop the old version and rename the modified version to the original name. Dont forget to run sp_recompile on the new table afterwards.

CR:453530

CR Number:   453530 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2007 One-off Provided 08 Jun 2007 One-off Provided Description Avoid certain deadlocks involving Sysobjects, Sysindexes, Syspartitions, and Systabstats when partitioning objects in parallel with other maintenance activities such as DROP index, CREATE index.

CR:453566

CR Number:   453566 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2007 Fixed Description Print option 1 to DBCC PAGE will now decode the TIPSA region of 1st text/image pages, and will print out the data for all text and image pages as a byte stream.

CR:453598

CR Number:   453598 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2007 Not a Bug Description sp_who output inconsistent with sysprocesses

CR:453604

CR Number:   453604 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.3 01 Aug 2008 Duplicate Description New options: "with skip_global_index_rebuild" is added to drop partition Syntax: alter table table_name drop partition partition_name [with skip_global_index_rebuild] * If "with skip_global_index_rebuild" is provided, the global index will NOT be rebuild and the index of the table will be labeled as suspect. ** If "with skip_global_index_rebuild" is not provided, the global index will be rebuild. This is the default value.

CR:453646

CR Number:   453646 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2007 Fixed Description Configuration parameter 'number of open partitions' uses the wrong message number for its help message: it uses 10410, but should use 14010.

CR:453742

CR Number:   453742 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2007 Fixed 05 Mar 2007 Presently Not Targeted For Any Future Release Of This Product 02 Mar 2007 Fixed Description ASE HA Failback fails with ServiceGuard A.11.17 but works on ServiceGuard A.11.16 and A.11.15. This is a compatibility issue with ServiceGuard A.11.17. ServiceGuard A.11.17 changes the message in its output from "cmhaltpkg : Completed successfully" to "cmhaltpkg: Completed successfully". A white space has been removed in the message between "cmhaltpkg" and ":" causing ASE HA Failback to fail.

CR:453759

CR Number:   453759 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2007 Fixed 27 Apr 2007 Not reproducible with latest version of the product available as of Resolution Date Description The count distinct expression may not return the correct number of rows on ANSI join queries involving subquery and ANY expression.

CR:453794

CR Number:   453794 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2007 Fixed Description Queries that eliminate partitions based a query predicate may chose a global non-clustered index scan that has a low data row cluster ratio over a table scan that would be more desirable due to partition elimination.

CR:453831

CR Number:   453831 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2007 Fixed 23 Jan 2007 Fixed 02 Feb 2007 Fixed 23 Feb 2005 Fixed Description A SELECT statement with a derived table that contains a UNION ALL of a proxy table and a local table results in a 207 error (Invalid column name) if the proxy table is before and the local table is after the UNION ALL. Workaround Description  1) Turn on traceflag 11275 to disable full-passthrough of statements referencing views. 2) when defining the derived table using 'UNION ALL' use proxy table after UNION ALL. So simply changing the table order will make it work properly. SELECT EvalStdPrc FROM ( SELECT EvalStdPrc FROM IMMZ_IN_ITEM_D_STDPRC WHERE ItemCd = '' UNION ALL SELECT ClsPrc FROM CBBZ_STK_ITEM_DT WHERE ItemCd = '' AND JustDt = '' ) abc

CR:453837

CR Number:   453837 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 IP Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2007 Fixed 31 Jan 2007 Fixed 05 Feb 2007 Fixed Description Wrong results could be obtained when a view or derived table which contains a GROUP BY clause is used in a query on the inner side of an Outer Join and the query SELECT list contains complex expressions.

CR:453867

CR Number:   453867 Product Name:   Sybase ETL Product Component:   GUI Status:   Closed OS:   Windows XP Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 4.2 04 Feb 2011 Presently Not Targeted For Any Future Release Of This Product Description Problem: The uninstall script for the ETL Development product does not remove registry entries containing repository definition and general product configuration. This may be an issue when reinstalling the product, especially in a different directory structure on the same machine. Resolution: Use the regedit application to remove the following keys: If uninstalling Sybase ETL Development, remove HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\sybetl If uninstalling Sybase IQ ETL Development, remove HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\iqetl Workaround Description  The Registry keys will not be deleted since they contain the Development configuration as well as the defined Repository connection details. We decided to document the Registry keys so that they can be manually deleted. Manually delete these keys: The following Registry folder is used for storing the preference keys shown in the Preference window of the user interface: Sybase ETL Development: HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\sybetl Sybase IQ ETL Development: HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\iqetl For storing the Repository connection details the following Registry folder are used: Sybase ETL Development: HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\sybetl\connection Sybase IQ ETL Development: HKEY_CURRENT_USER\Software\JavaSoft\Prefs\sybase\iqetl\connection

CR:453881

CR Number:   453881 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Open OS:   HP-UX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow audit options to be available server-wide by default, one should have to set it for all user databases individually

CR:453904

CR Number:   453904 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2007 Fixed Description A process is abnormally terminated after an 1105 error occurs when creating a stored procedure in a database that has the "abort tran on log full" option set. Workaround Description  Turn "abort tran on log full" off for the database.

CR:453918

CR Number:   453918 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2007 Fixed 17 Dec 2008 Fixed Description dbcc checkcatalog raises a 7417 error when a 0 freepage threshold exists, even if the last chance threshold entry for logsegment is present in threshold cache.

CR:453947

CR Number:   453947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2007 Not a Bug Description Surrogate pair characters such as U&'\D840\DC00' can't be inserted into unichar/univarchar/unitext columns using Unicode literals (U&). Error 2433 will be raised with the message "Illegal byte sequence encountered in Unicode data.". This behavior is expected. ASE expects Unicode scalar values within the literal. Unicode scalar values include any unicode code point except high-surrogate and low-surrogate code points. So you need to specify Unicode scalar value U&'\+020000' instead of U&'\D840\DC00' in the sample case.

CR:453993

CR Number:   453993 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2007 Fixed 12 Jun 2007 Fixed Description Query with derrived table expression having TSQL outer join operator *= may return incorrect result if the inner table joining column is also present in the select list of the main query. Workaround Description  Use ANSI OJ instead of TSQL *= expression.

CR:454022

CR Number:   454022 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2007 Fixed 13 Mar 2007 Fixed Description A 325 error, "Adaptive Server finds no legal query plan for this statement." may be reported with a SELECT query when the opportunistic distinct view option is enabled. Workaround Description  set opportunistic_distinct_view off and then execute the sql

CR:454029

CR Number:   454029 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2007 Fixed 30 Jan 2007 Fixed Description The message 'Could not execute login script for user <username>' will be incorrectly reported when the password has expired. In an HA environment, setting the password at the primary will fail to be replicated at the companion server with the same error message.

CR:454129

CR Number:   454129 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2008 Fixed Description User defined messages appear in master..monErrorlog always with ErrorNumber = 1 rather than the error number with which they have been defined. Severity is always shown as 0. Workaround Description  None available

CR:454137

CR Number:   454137 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2007 Fixed 26 Jan 2007 Fixed Description The messages for errors 15082 and 15084 respectively "There are <value> OAM entries with zero used/unused page counts. Run DBCC <value> FIX on objid <value> indid <value>." and "The OAM has no room for new inserts. Run DBCC <value> FIX on objid <value> indid <value>." should not report "Run DBCC CHECKALLOC FIX" if DBCC CHECKALLOC was the command being executed, since CHECKALLOC can only be executed at the database level. Instead the relevant command that needs to be run later in order to correct this non severe problem will be reported, either TABLEALLOC, INDEXALLOC or TEXTALLOC.

CR:454176

CR Number:   454176 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2007 Fixed Description If ASE 15.0.x is running using an installation that has not yet been upgraded from 12.0.x or before, and a user executes CREATE PROCEDURE in a database, then when upgrade tries to upgrade sysprocedures, ASE may produce messages warning about 'invalid column length', with associated stack traces.

CR:454215

CR Number:   454215 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2009 Fixed Description Disallow creation of 'dbo' login by customers

CR:454220

CR Number:   454220 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to enhance dbcc checkstorage to validate index entries in parallel.

CR:454283

CR Number:   454283 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2007 Fixed Description The default stack size on AIX64 is increased from 96k to 104k.

CR:454369

CR Number:   454369 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   AIX 5.1 Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2007 Workaround 20 Jun 2007 Fixed 20 Jun 2007 Fixed 20 Jun 2007 Fixed Description sybmigrate throws java.lang.NumberFormatException in com.sybase.sybmigration.AseUtils.getDbSizeInMb when attempting migration of a very large Database.

CR:454434

CR Number:   454434 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2007 Fixed 05 Feb 2007 Fixed Description System wide password expiration will be ignored and a user with an expired password will be able to log into the server unless a password expiration policy has been defined using the stored procedure sp_passwordpolicy. Workaround Description  Define a password expiration policy using sp_passwordpolicy.

CR:454453

CR Number:   454453 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2007 Bundled Request Description In Warm Standby Replication environments where 'master' database is replicated, call to the stored procedure sp_config_rep_agent to configure the replication agent in the database 'master' was not being replicated.

CR:454460

CR Number:   454460 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2007 Fixed 13 Feb 2007 Fixed 11 Mar 2008 Fixed 04 Nov 2008 Fixed Description Query executed from the trigger and referencing tables INSERTED or DELETED may fail with errors if the optimizer decides to apply a strategy which is using a worktable based on INSERTED or DELETED table. Workaround Description  Boot the server with -T328 to avoid reformatting.

CR:454493

CR Number:   454493 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2007 Consult Complete Description In rare circumstances, the system might hit the signal 11 in compare_value() when update statistics.

CR:454526

CR Number:   454526 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Closed OS:   Windows 2003 Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2007 Not a Bug 05 Jun 2007 Added to user documentation Description Problem: Special characters in Sybase ETL installation paths. Resolution: Special characters in the installation path of Sybase ETL Development or Server may cause problems accessing databases. For example, connecting to Oracle returns the following error when ETL is installed in a path containing parenthesis like "C:\Program Files (x86)\Sybase...": ORA-12154: TNS:could not resolve the connect identifier specified Sybase recommends using installation paths that contain only alphanumeric characters.

CR:454562

CR Number:   454562 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2007 Fixed 16 Feb 2007 Fixed 05 Mar 2007 Fixed 05 Mar 2007 Fixed Description Turning off the direct i/o through DIRECTIO=false doesn't take effect even after restarting ASE if the device had the DIRECTIO option set to true before. Workaround Description  Reboot OS. If you don't like to reboot, create a program calling directio(fd, DIRECTIO_OFF) and run it on your devices in question. ======================================== #include <stdio.h> #include <fcntl.h> #include <sys/types.h> #include <sys/fcntl.h> #include <unistd.h> #include <time.h> #include <errno.h> int main(int argc, char *argv[]) { int fd; if (argc != 2) { printf("usage: %s filename\n", argv[0]); exit(1); } fd = open(argv[1], O_RDWR); if (fd < 0) { printf("Can not open Write/Read file %s\n",argv[1]); exit(2) ; } if (directio(fd, DIRECTIO_OFF) == -1) { printf("Can not set DIRECT IO OFF on %s\n",argv[1]); exit(3) ; } close(fd); exit(0); } ========================================

CR:454609

CR Number:   454609 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 ESD#6 14 Feb 2007 Fixed 13 May 2008 Fixed Description Table scans on DATA_ONLY locked tables running at isolation level READ COMMITTED may sometimes fail to return qualifying rows if there are concurrent INSERTs/UPDATEs happening on the table.

CR:454677

CR Number:   454677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2007 Fixed Description A SELECT query on a union-in-view with a large IN list (>40 elements in the IN list) as part of the WHERE clause hits signal 11 in PeBasicPredicate*IsCorrelatedSarg().

CR:454790

CR Number:   454790 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2007 Fixed Description When a login password has expired in a High Availability (HA) environment on both the master and companion servers, execution of sp_password silently fails to change the password on the companion; the password change succeeds only on the local server.

CR:454927

CR Number:   454927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2007 Fixed 06 Nov 2007 Fixed Description Enable LDAP User Authentication feature on Windows X64 platform

CR:454928

CR Number:   454928 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2008 Fixed 08 Dec 2008 Fixed 08 Dec 2008 Fixed 09 Dec 2008 Fixed Description Enable Encryption Column feature on winx64 platform

CR:454952

CR Number:   454952 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2007 Fixed Description The command DBCC LISTOAM will incorrectly report the error 'Invalid Object Id <n>' when the object is a master only system table.

CR:454960

CR Number:   454960 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2007 Fixed Description Creating an encryption key on platforms that don't support encrypted columns produces a stack trace.

CR:455016

CR Number:   455016 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2007 Fixed Description Stacktrace could happen in CgpIndScan::_CgpIndSpecialOrPePredBmToScalar() if an equijoin between two tables (such as t1.c1=t2.c1) under an OR predicate is considered for the special OR processing on t1 and t2.c1 is also participating in another TOP level equijoin predicate with t1. Here is an example: "... where t2.c1=t1.c2 and (t1.c1=t2.c2 or t1.c1=t2.c1)"

CR:455038

CR Number:   455038 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2007 Fixed 26 Feb 2007 One-off Provided Description Enabling optgoal allrows_oltp incorrectly disables the optimizer from considering network latency when optimizing queries with proxy tables.

CR:455042

CR Number:   455042 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2007 Fixed 25 Apr 2007 Fixed Description Client connection which is bound to the LASTONLINE will hang when issuing the "sp_engine 'offline'" command. Workaround Description  Removing the execution class binding from the login/application/procedure will correct the problem.

CR:455100

CR Number:   455100 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description add BatchID field in table monProcessProcedures to improve sp_monitor procstack preformance.

CR:455102

CR Number:   455102 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2007 Fixed 08 Nov 2007 Fixed 18 Jun 2007 Fixed 02 Aug 2007 Fixed 04 Sep 2007 Fixed 12 Nov 2007 Fixed Description CIS does not forward the query if it contains the 'group by' clause without aggregration. Workaround Description  run dbcc cis(setcaps, <iq_server>, 112, 2) to change the group_by cap to TSQL. reset this back to 4 after executing the query.

CR:455146

CR Number:   455146 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2007 Fixed Description Attempts to run dbcc report_al(db_name) encounter error 10334, state 80 (permission related internal error).

CR:455175

CR Number:   455175 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2007 Fixed Description explain more details in the doc related to unpartitioniong / partitioning

CR:455176

CR Number:   455176 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Closed OS:   Windows 2000 Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2008 Fixed Description Problem: Sybase native connectivity for Windows Resolution: The Sybase IQ 12.7 Windows PC client does not include Sybase native (Open Client) connectivity. Thus, to use Sybase native connectivity from ETL to Sybase IQ, the native libraries must be installed from another Sybase product. For example, the native libraries are available in the Sybase Software Development Kit (SDK), which is an installation option of the Windows Sybase IQ 12.7 server or as a separate product. Contact your Sybase Technical Support representative for information about the best way to obtain Sybase native connectivity for your site. Note that the ETL products for Windows are 32-bit applications. However, they can run on Windows 64-bit platform. If the 64-bit Sybase IQ server were installed on the same machine and the installation included the SDK, the 32-bit libraries would also installed and could be used.

CR:455180

CR Number:   455180 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2007 Fixed Description When running ASE 15.0 on an installation that has not yet been upgraded from 12.5.x or before, #temp table creation can create a table with a name longer than is permitted by the current tempdb.dbo.sysobjects. Some stored procedures, such as sp_configure, can cause this to happen. When it happens, ASE will produce an error message and a stack trace saying that a column on disk has an invalid length.

CR:455195

CR Number:   455195 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2007 Fixed 06 Apr 2007 Presently Not Targeted For Any Future Release Of This Product Description The message "current process infected with 11" in the module 'HashBuf::HbBufSetRunInfo' together with a stack trace which includes the modules 'LeHashPart::LePartGetConsumerId' and LePipeRepart::LePipeWriteVtuple' may be reported in the error log when a query involving more than 31 columns is executed in parallel and "hash repartitioning" mechanism was chosen. Workaround Description  Run the query in serial mode.

CR:455196

CR Number:   455196 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2007 Fixed Description RTDS licenses obtained from DI, that did not contain the PE=EE string, would not work when used with ASE EE. Workaround Description  None.

CR:455197

CR Number:   455197 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2007 Fixed 27 Mar 2007 Fixed Description If a compute clause's group-by list contains an expression and no rows are returned for the query, then a SEGV or stack corruption could occur.

CR:455275

CR Number:   455275 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2007 Fixed 27 Feb 2007 Fixed Description Under rare circumstances DBCC CHECKSTORAGE may detect non-existent 100018 errors when run on an archive database.

CR:455295

CR Number:   455295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2007 Fixed 26 Mar 2008 Not reproducible with latest version of the product available as of Resolution Date Description When table in IQ/ASA has name greater than 30 characters, creating proxy table in ASE that maps to it will fail with ASA Error -131: Syntax error near 'order' on line 1.

CR:455326

CR Number:   455326 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2007 Fixed 07 Feb 2007 Fixed 07 Feb 2007 Fixed Description The 110219 error log message has been reworded and now reads "Warning: There is no valid license for ASE_ASM and therefore the ASE_ASM feature has not been initialized".

CR:455413

CR Number:   455413 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2007 Fixed 03 Apr 2009 Fixed Description When parallelism is turned on, a query with several tables may cause a time slice error. This is because the optimizer has a large search space to traverse in the parallel mode and the timeout mechanism does not take that into account while comparing a large number of plan fragments.

CR:455435

CR Number:   455435 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 IP Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2007 Fixed 18 Feb 2007 Fixed 02 Mar 2007 Fixed Description Using the top clause in a select statement that involves a union all in a view (or equivalent derived table) in the from clause does not limit the size of the result set as expected.

CR:455481

CR Number:   455481 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2007 Presently Not Targeted For Any Future Release Of This Product Description Customer wants the set ciphertext command to be fully supported

CR:455482

CR Number:   455482 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2009 Presently Not Targeted For Any Future Release Of This Product Description set ciphertext command does not propagate to stored procedures Workaround Description  upgrade to ASE 15

CR:455567

CR Number:   455567 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2007 Fixed 11 Feb 2007 Fixed Description SQL queries having predicates of the form col = isnull(result of some scalar aggregation, or the result of a subquery), is not considered as a SARGable predicate, which means that such predicates cannot be used for index scans. This causes massive performance problems.

CR:455570

CR Number:   455570 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2007 Fixed Description For DBCC CHECKCATALOG, if the partition id order in the tree from sysprocedures is different from the partition id order in the syscomments, the 15911 error will be raised.

CR:455601

CR Number:   455601 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2007 Fixed 28 Feb 2007 Presently Not Targeted For Any Future Release Of This Product 12 Mar 2007 Fixed Description Error 644 "Index row entry for data row id (<value>, <value>) is missing from index page <value> of index id <value> of table '<value>' in database '<value'..." may be reported in module "del_rownotfound" with a stack trace in the error log when an UPDATE command is run on a Data Only Locked table and the scan index being used by ASE to perform the update has one or more of its columns affected by the given update.

CR:455611

CR Number:   455611 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2007 Fixed 15 Feb 2007 Fixed Description HAaseAgent for VCS on Solaris and Linux executes one VCS system command with wrong syntax: hagrp -display <service-group-name> attribute SystemList The above command with correct syntax should be: hagrp -display <serveric-group-name> -attribute SystemList The wrong syntax will not cause any failure in HAaseAgent or HA function except that VCS engine may log some error message to its log.

CR:455671

CR Number:   455671 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2007 Fixed 14 May 2007 One-off Provided Description Multiple connections from another 15.0.1 ASE are left allocated. Workaround Description  set 'cis idle connection timeout' to zero

CR:455674

CR Number:   455674 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2007 Fixed 29 Jun 2007 Presently Not Targeted For Any Future Release Of This Product Description Under very rare circumstances, some 821 or 813 errors may be raised for a very busy multi-engine ASE having a buffer cache shortage.