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

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

CR:441140

CR Number:   441140 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) 06 Oct 2006 Fixed 28 Aug 2007 Fixed Description Under rare circumstances an undetected deadlock may occur between the housekeeper 'HK_WASH' system task and a session that performs a DML command in a table whose database has mixed log and data segments when that table uses a cache that has a memory pool configured. Workaround Description  avoid using mixed log and data

CR:441188

CR Number:   441188 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) 08 Nov 2007 Fixed 11 Apr 2012 Added to user documentation 02 Dec 2007 Fixed Description When ASE has been configured to provide email notification of SySAM licensing failures, and the "email.helo.fqdn" property in the SySAM property file is set to the fully qualified domain name, the email messages should contain the specfied HELO token.

CR:441249

CR Number:   441249 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2006 Fixed 13 Feb 2007 Presently Not Targeted For Any Future Release Of This Product Description DBISQL: If the command to create a stored procedure contains syntax errors, DBISQL incorrectly reports the error at Line 1, column 1. Workaround Description  None known.

CR:441262

CR Number:   441262 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 Sep 2006 Fixed Description Stacktrace could happen for query with a DISTINCT clause on constant_expression(s) only. For example, select count(distinct 1+2) from t

CR:441274

CR Number:   441274 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) 15 May 2007 Fixed 13 Mar 2008 Fixed Description CREATE RULE statement incorrectly allows the creation of rules that use subqueries on its definition.

CR:441278

CR Number:   441278 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 Nov 2006 Fixed Description Results aren't correctly sorted in some cases when the FOR BROWSE option is used with the ORDER BY clause in a SELECT statement.

CR:441349

CR Number:   441349 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) 18 Jun 2007 Duplicate Description This behavior only occurs when the local variable is uninitialized. Giving a correct usage would avoid this problem. i.e. declare @var int select @var = <a value>

CR:441376

CR Number:   441376 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) 17 Nov 2006 Fixed 18 Dec 2006 Fixed Description Proxy tables cannot be partitioned in ASE 15.0.2.

CR:441424

CR Number:   441424 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Windows XP Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2010 Fixed 30 Nov 2006 Fixed 05 Dec 2006 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description Following a seemingly successful installation of PC Client 12.5.4, two errors are encountered: + No mclib in java.library.path + This application has failed to start because javaai.dll could not be found. Reinstalling the application may fix this error. Workaround Description  The first problem can be worked around by manually setting the classpath. The second problem can be worked around only if the missing dll, javai.dll is present on the client PC, then editing the path can resolve this. Updated dll's can be located here: /remote/cases/11297000s/11297196/pseinfo-11/Repro/1254_dlls.zip

CR:441433

CR Number:   441433 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) 13 Sep 2006 Fixed 13 Sep 2006 Fixed 13 Sep 2006 Fixed 13 Sep 2006 Fixed 17 Oct 2006 Fixed 14 Nov 2006 Fixed Description Under rare circumstances a session may hang forever during a lock request despite ASE having granted the lock to the session. This is a side effect from the fix of CR 399737. The modules "lock__semawait", "log__lock" and "lock_psema" will be reported in the call stack of the hanging session.

CR:441454

CR Number:   441454 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) 29 Jun 2010 Fixed 03 Nov 2011 Duplicate Description The MDA table monErrorLog does not record SySAM sylapi messages.

CR:441490

CR Number:   441490 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) Description In some cases the PRINT DEADLOCK INFORMATION output does not display the actual line of code that caused the deadlock to occur.

CR:441498

CR Number:   441498 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 Sep 2006 Fixed Description Handle this situation: the "selector" is consist of blank characters when subscribing a JMS topic.

CR:441514

CR Number:   441514 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) 15 Sep 2006 Fixed 25 Sep 2006 Fixed Description For range or list partitioned table, if the partition bound value is specified using unichar format U&'***', subsequent insert into the table may fail or insert into incorrect partition. Workaround Description  When specify the bound value for range or list partition on unichar/univarchar column, use the string or binary format instead of the U&'***' format to enter the bound value.

CR:441592

CR Number:   441592 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) 06 Oct 2006 Fixed Description Join operators evaluated virtual columns before any of the filtering predicates. As a result, they might raise user exceptions that could otherwise be avoided if the evaluation was deferred until just before the result is returned. This way, filtering predicates might eliminate the row before the exception occurs. This is similar to the problem fixed in CR 436738 (where the problem was fixed for scan, remote scan, or, and restrict ops). Workaround Description  Using CASE expression can be found from CR 426272-1 explanation in detail

CR:441605

CR Number:   441605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2006 Duplicate Description Increase the trace_log_file value to accomodate paths larger than 30 characters. Workaround Description  None currently

CR:441614

CR Number:   441614 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 Sep 2006 Fixed 03 Oct 2006 Bundled Request 04 Dec 2006 Bundled Request Description When using EAServer with RTDS 4.0 for messaging, the msgunsubscribe command may fail. Workaround Description  If possible try not to use unsubscribe and instead use a different subscription name to subscribe to the same topic with different clients.

CR:441664

CR Number:   441664 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 12 Sep 2006 Fixed 25 Sep 2006 Fixed 22 Sep 2006 Fixed Description Sig-11 will occur if a semantically partitioned temporary table is dropped, while the semantic partitioning feature is OFF. Workaround Description  Enable semantic partitioning

CR:441690

CR Number:   441690 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) 13 Sep 2006 Fixed Description Previously the default port number for Jini server discovery service on Edit/Add Discovery Setting dialg was 9999. It has been changed to the correct port number 4160.

CR:441776

CR Number:   441776 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Windows W2k Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2008 Fixed 26 Aug 2008 Fixed Description Historical Server version 12.5.4 crashes using the 'direct load to ASE' feature when executing hs_create_recording_session. Workaround Description  Do not use this feature with HS 12.5.4.

CR:441785

CR Number:   441785 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2006 Fixed 29 Nov 2006 Fixed Description Subquery LT/LE/GT/GE ANY/ALL syntax cannot be quickpassed to remote IQ server 12.6 and above even though the IQ server supports the syntax.

CR:441803

CR Number:   441803 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) 31 Oct 2006 Fixed 31 Oct 2006 Reservation Made Description Forced join orders and other forced options can now be ignored in a query through the use of Traceflag 15307 and 15308. When Traceflag 15307 is enabled, join orders forced using FORCEPLAN will be ignored. When Traceflag 15308 is enabled, forced index/prefetch/parallel/replacement options will be ignored.

CR:441814

CR Number:   441814 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) 17 Jan 2007 Fixed 02 May 2007 Presently Not Targeted For Any Future Release Of This Product Description When a predicate in a query needs data type conversion for literals that result in data loss, partition elimination does not happen. As an example, a query wih a equality predicate on some literal may result in no data loss and the optimizer may eliminate the respective partitions, provided a semantic partition exists on that column. But, if the literal is different with a higher precision, data type conversion will make the result of the predicate false, and the partition elimination functionality fails to eliminate the required partitions.

CR:441858

CR Number:   441858 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) 04 Oct 2006 Not a Bug Description sp_extrapwdchecks failed to custom password checks.

CR:441869

CR Number:   441869 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Insufficient priority to fix Description Customer would like a built-in function similar to user_name() that would return the current process ID for use in a view. The customer cannot use @@spid as this cannot be used in a view. Workaround Description  get_appcontext('SYS_SESSION', 'spid')

CR:441892

CR Number:   441892 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2006 Fixed Description User with anonymous connection to UA could not open Roles folder because ASEP would not be able to display role mappings. The requirement is now relaxed so that user with sa_role/sso_role/anonymous-UA-credential can still open Roles folder. The role mappings column won't be shown in this case.

CR:441932

CR Number:   441932 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) 17 Sep 2006 Fixed 09 Mar 2007 One-off Provided 13 Jun 2007 One-off Provided Description An EX_INT lock was held on Syslogins when a connection logged into ASE, this is now changed to a SH_INT lock to help release this lock as soon as the scan is finished.

CR:442010

CR Number:   442010 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) 13 Nov 2006 Fixed Description Enhanced LOAD database WITH VERIFYONLY to be tolerant of database existance and size.

CR:442045

CR Number:   442045 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2006 Fixed 12 Oct 2006 Presently Not Targeted For Any Future Release Of This Product Description DBISQL unable to access tables with large identifiers. It gets error: The identifier that starts with abcdefghijklmnopqrstuvwxyznowi is too long. Maximum length is 30. Sybase error code=103

CR:442062

CR Number:   442062 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2006 Fixed Description The value of BufferPools column in the monDataCache MDA Table for the default data cache, is incorrectly reported as two when only one pool is created. Workaround Description  Get the correct value 1> select count(*) from monCachePool 2> where CacheName = "default data cache" 3> go

CR:442080

CR Number:   442080 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2006 Fixed 27 Sep 2006 Fixed 19 Dec 2006 Fixed 02 Oct 2006 Fixed 18 Dec 2007 Fixed 17 Dec 2007 Fixed 05 Dec 2006 Fixed 17 Dec 2007 Fixed 19 Dec 2006 Fixed Description When queries use a IN list or joins under ORs, the costing had flaws such that dynamic index strategies were chosen with a RID scan, instead of a sometimes cheaper special OR optimization using an OR scan. This would only occur if joins are involved, and the OR predicate can be applied to the inner table of a nested loop join operator. In a query such as the following SELECT M.fiscal_period , T.service_key , sum(T.local_call_minutes) , sum(T.local_call_count) , count(*) FROM telco_facts T , residential_customer C , service S , month M WHERE T.customer_key = C.customer_key AND T.service_key = S.service_key AND T.month_key = M.month_key AND M.fiscal_period = 'Q4' AND T.service_key in (02, 03) AND C.state = 'CA' GROUP BY M.fiscal_period , T.service_key if the join order chosen used nested loop joins, and the T.service_key table was not at the beginning of the join order, then there was a possibility for an incorrect costing. Workaround Description  use force plan options

CR:442121

CR Number:   442121 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2006 Fixed 18 Sep 2006 Deferred 05 Dec 2006 Fixed Description The execution of SELECT-INTO under the SET CHAINED option context must not trigger the implicit start of a chained transaction. Workaround Description  Do not use datarows as the default locking scheme, OR turn off large page allocations with trace flag 1101, OR make the select-into cmd produce an APL vs. DOL table (into #test lock allpages), OR commit tran just after the select-into is run. *NOTE* that although the workarounds above are possible we should not have allowed the execution of a select-into cmd when a chained transaction was started already.

CR:442182

CR Number:   442182 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2006 Fixed Description Adhoc queries with large batches allocate memory in large chunks resulting in improved scans of the memory prochdrs. This improves response time in queries where large chunks of memory are consumed.

CR:442213

CR Number:   442213 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2006 Fixed 01 Oct 2009 Presently Not Targeted For Any Future Release Of This Product Description When running out of procedure cache, error 701 is returned, followed by the corruption of the stack guardword.

CR:442249

CR Number:   442249 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2006 Fixed 19 Sep 2006 Fixed 18 Dec 2006 Fixed Description sybmigrate may issue the message "Internal error: (com.sybase.sybmigration.lang.messages) Unable to get mneumonic 'GUI_MNEM_TASK_THREADS'." Although reported as an error this message was not a serious problem.

CR:442289

CR Number:   442289 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) 24 Oct 2006 Fixed Description Wrong result may be reported when a query id executed which includes DISTINCT or ORDERBY clause along with a 'outer join'.

CR:442309

CR Number:   442309 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) 18 Dec 2006 Fixed 01 Dec 2006 Fixed 06 Dec 2006 Reservation Made 09 Jan 2012 Presently Not Targeted For Any Future Release Of This Product 17 Jan 2007 Fixed Description Some views containing a union all query will fetch superfluous columns from the base tables when a user query aggregates over the view.

CR:442336

CR Number:   442336 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) 18 Nov 2006 Fixed 27 Nov 2006 Reservation Made Description If a table column has a functional index on it and when we update this column, it could cause stacktrace.

CR:442427

CR Number:   442427 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 Dec 2006 Fixed Description Migration tool fails to migrate server logins if Job Scheduler is installed.

CR:442494

CR Number:   442494 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) 26 Sep 2006 Fixed 26 Sep 2006 Fixed 01 Dec 2006 Fixed Description On IBM and Mac platforms, a 15760 error, "Invalid dump header when loading the database with ID '<dbid>'" is reported when an archive database is loaded using a database dump for which a sysdevices row has already been created using the 'sp_addumpdevice "archive database"' stored procedure. Workaround Description  Do not add the stripe devices using sp_addumpdevice "archive database". Simply load directly from the stripe set.

CR:442519

CR Number:   442519 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) 07 May 2008 Duplicate Description When performing 'disk refit' after 'load database master', ASE can find allocation units on disk that are no longer part of a database and so should not be reflected in sysusages. Attempting to remove the extraneous entries can encounter a segmentation fault and stack trace, causing disk refit to fail.

CR:442521

CR Number:   442521 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) 20 Jan 2007 Fixed Description Display login password encryption information using sp_displaylogin.

CR:442525

CR Number:   442525 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 11 Mar 2008 Fixed Description A union with subquery in the result list may fail with error 530 ("Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS. UPDATE fails.") if the subquery is producing empty result set. Workaround Description  Re-write the subquery with a noop isnull: isnull((subquery),null) Example of the repro: select 1, isnull((select id from v_t where 1=2), null) union select 2, 1 go ----------- ----------- 1 NULL 2 1 (2 rows affected)

CR:442529

CR Number:   442529 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Nov 2007 Fixed Description sybatch - sample res scripts in 1501 release include paths for ASE 12.5 releases

CR:442558

CR Number:   442558 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) 29 Sep 2006 Fixed Description Cannot boot server due to the error "missing lib error with solaris-32 bit dataserver: __fabsf in libm.so.1"

CR:442560

CR Number:   442560 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) 20 Dec 2007 Presently Not Targeted For Any Future Release Of This Product 02 Jan 2008 Fixed 03 Jan 2008 Fixed Description SSL ct_connect attempts fail intermittently when ASE is started with a TLI listener with the following error: Client MsgNo: 84083974. Client Msg : ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect. Workaround Description  Use a TCP style SSL entry for your ASE during startup. Example: UMSPROD ## TCP style entry for SSL-secured connection to production server master tcp ether sunspot 7777 ssl query tcp ether sunspot 7777 ssl

CR:442588

CR Number:   442588 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) 07 Feb 2007 Fixed 07 Feb 2007 Reservation Made Description Subqueries that contain a group-by clause that references one or more correlated columns (from an outer query block) may return incorrect results. Workaround Description  Use trace commandline flag 450 to force the use of group-inserting operator rather than the group-hashing operator.

CR:442601

CR Number:   442601 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) 27 Sep 2006 Fixed Description Command "create database sybsecurity" fails. The named database contains upgrade items that are not present in model, so "use database" (part of the command's action) refuses access because sybsecurity is not fully upgraded. There is no workaround.

CR:442629

CR Number:   442629 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) 09 Jan 2007 Fixed Description Attention and kill processing is not working as expected for a process waiting for a RTDS message. The process may hang, without possibility to recover from that state. There is no workaround nor solution before the current fix.

CR:442668

CR Number:   442668 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Open OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2006 Third Party Problem Description For less than 3 words verity generates null summary. suggested style file changes fix the issue. Workaround Description  For small documents that has less than 3 words it generates null summary.The work around for the problem would be to use more words, until the issue is fixed.

CR:442683

CR Number:   442683 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2007 Fixed Description If truncation length is set to 0, no data is returned for text col in dbisql Workaround Description  If you know the approx size of data in the text field then set Truncation Length to that rather than setting it to 0

CR:442736

CR Number:   442736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2006 Fixed 10 Oct 2006 Fixed Description Incorrect results may be returned when executing a query that involves several complex AND/OR predicates combination involving multiple columns.

CR:442752

CR Number:   442752 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2006 Fixed Description Wrong comparison result might be generated when MixedDTSarg is used on money->binary, unichar->char, char->binary, or unichar->binary casting.

CR:442820

CR Number:   442820 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2006 Fixed 25 Oct 2006 Fixed 25 Oct 2006 Fixed Description Sessions may SEGV when compiling heavily used procedures. This can occur as the result of deadlock while compiling a procedure. A deadlock situation during compilation should only occur when compiling a block that updates or inserts into a table that contains computed columns and/or functional indices.

CR:442902

CR Number:   442902 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2010 Fixed 02 Feb 2012 Added to user documentation 17 Nov 2011 Fixed Description The MDA tables monOpenObjectActivity, monOpenPartitionActivity and monProcessActivity are enhanced to include IOSize1Page, IOSize2Page, IOSize4Page and IOSize8Page columns to track large I/O counts per-spid/per-user process.

CR:442944

CR Number:   442944 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2006 Fixed Description The showplan ouput for a positioned DELETE or UPDATE query will show a 'TABLE SCAN' of the table being modified when the query execution actually uses a dynamic index.

CR:443098

CR Number:   443098 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) 27 Oct 2006 Fixed Description Incorrect results may be returned under special circumstances when executing a query that involves a join with complex expressions for the join predicates and the optimizer decides to apply "reformatting" (store index) technique to the inner table (i.e. substituting it with a worktable with an index on it) Workaround Description  Disable reformatting via 'set store_index 0'.

CR:443194

CR Number:   443194 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2006 Fixed Description Previously when closing DBISQL, if user's "$HOME/.isqlHistory9" file does not have read/write permission or if DBISQL fails to access the file, a stack trace would occur. This has been fixed.

CR:443246

CR Number:   443246 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description All ASE 12.5.x product manuals from 12.5.1, in which the XML features were introduced, should mention the following character set related limitations: + The XML functions in ASE 12.5.x versions do not support i18N (those in ASE 15.0 do) + The XML outputs generated by ASE 12.5.x are restricted to the first 128 byte-points only

CR:443258

CR Number:   443258 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   IRIX Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2006 Not reproducible with latest version of the product available as of Resolution Date 03 Aug 2007 Fixed 02 Apr 2008 Fixed Description The error 11206, 'Unable to connect to server' will be raised if a user tries to access an MDA table from within a login script in some 64 bits platforms.

CR:443277

CR Number:   443277 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Nov 2006 Fixed 04 Dec 2006 Fixed Description One or more hard faults with type code 100001, "The page id, next page, or previous page value in the page header is invalid." is reported by DBCC CHECKSTORAGE when run against an archive database on which a transaction log has been loaded that encapsulates an ALTER DATABASE command. Workaround Description  Not needed - simply ignore the DBCC CHECKSTORAGE errors.

CR:443295

CR Number:   443295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2006 Fixed 13 Oct 2006 Fixed 21 Oct 2006 Fixed 25 Oct 2006 Fixed 02 Nov 2006 Fixed Description If a partitioned table contains an encrypted column and if the encryption key has been specified for encryption operations using an initialization vector, then a paralellized update or select of the encrypted column may display the following error message or a similar one, and the errorlog may show a stack trace showing the function 'col_encrypt' or 'col_decrypt'. "Error: 15414, Severity: 18, State: 3 01:00025:00021:2006/09/29 09:14:38.62 server An internal error occurred at end of symmetric encryption or decryption operation (error code 57606). Please contact Sybase Technical Support."

CR:443332

CR Number:   443332 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) 23 Jan 2008 Fixed 28 Jan 2008 Reservation Made 19 Jun 2008 Not reproducible with latest version of the product available as of Resolution Date Description The message "current process infected with 11" in the module 'uwdisconnect' together with a stack trace which includes the modules 'err_pll_primary_processing' and 'pll_exec' may be reported in the error log when a query being executed in parallel on a multiengine server was aborted by CTRL+C or client application was killed.

CR:443447

CR Number:   443447 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) 26 Oct 2006 Fixed 24 Sep 2007 Presently Not Targeted For Any Future Release Of This Product Description Execute immediate query performing query with LIKE clause using inherited local variables or parameters fails during the compilation of the statement. Stack trace is dumped to the errorlog file and shows modules opt_like, opt_like_and.

CR:443457

CR Number:   443457 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) 09 Mar 2007 Fixed Description Under special circunstances, REPLICATION AGENT started in recovery mode may fail to stop automatically after reaching the end of the log.

CR:443497

CR Number:   443497 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Windows XP Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2006 Fixed Description On Windows xp_cmdshell with no_wait option fails to execute a script. Workaround Description  Add "@echo off" as the first line in the command file

CR:443537

CR Number:   443537 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2013 Duplicate Description DDLGen does not support SQL User Defined Function (UDF)

CR:443557

CR Number:   443557 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 Oct 2006 Fixed Description sp_sysmon may report wrong values for Replication Agent counter "Longest Wait" in different sections: "Log Extension Wait", "Forward Schema", "Backward Schema" or "I/O Wait from RS". This may happen if Replication Agent sleeps for a elapsed time longer than the sample time stablished by sp_sysmon.

CR:443558

CR Number:   443558 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) 13 Oct 2006 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description A 15703 error,"Failed to delete row(s) from sysaltusages in the scratch database" will be incorrectly reported when trying to drop an archive database if the rows that describe the scratch database and the associated devices have been manually deleted from sysattributes.

CR:443575

CR Number:   443575 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) 27 Oct 2006 Fixed Description UPDATE() function inside a trigger may fail to identify correctly which columns are affected by an UPDATE statement that includes a local variable assignment and that assignment is the first one in the SET clause. Workaround Description  Rewrite the statement and avoid to put the variable assignment in the first place in the SET clause.

CR:443584

CR Number:   443584 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) 04 Oct 2006 Fixed 05 Oct 2006 Fixed Description When a special or strategy is used as a scan node (set) in an nary-NLJ strategy, then too few rows may be returned. Workaround Description  Trace commandline flag 342 can be used to work around this problem. It will disable nary-NLJs (although the problem is not in the nary-NLJ strategy but shows up there).

CR:443596

CR Number:   443596 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2006 Fixed 06 Oct 2006 Fixed 10 Oct 2006 Fixed 24 Nov 2006 Presently Not Targeted For Any Future Release Of This Product Description Stored procedure may stop working returning errors related to too high number of worktables used in the query. This happens if the procedure executes SELECT INTO with query producing worktables (order by, distinct, group by, materialized views) and requires recompilation. Workaround Description  do not use 12.5.4 esd#1

CR:443605

CR Number:   443605 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) 19 Oct 2006 Fixed 17 Sep 2007 Not reproducible with latest version of the product available as of Resolution Date Description SH_INTENT Deadlocks occur on SYSCOLUMNS when concurrent queries using cross-database objects are normalized while utilities (such as drop of an index) holding EX_TAB lock on SYSCOLUMNS are in progress.

CR:443647

CR Number:   443647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2008 Fixed 08 Oct 2008 Fixed 05 Mar 2009 Fixed 20 Oct 2008 Fixed 04 Jan 2009 Fixed 05 Mar 2009 Fixed Description A new Kazahkstan Cyrillic charset KZ-1048 has been added in ASE. The sort order is binary.

CR:443668

CR Number:   443668 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2006 Fixed 06 Oct 2006 Fixed 10 Oct 2006 Fixed 18 Dec 2006 Fixed Description Under rare circumstances DBCC TABLEALLOC may hang forever when executed with the FIX option to correct error messages "There are <value> OAM entries with zero used/unused page counts. Run DBCC TABLEALLOC FIX ..." when the OAM entries needing cleanup are the first in the list.

CR:443700

CR Number:   443700 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2007 Fixed 15 Jan 2008 Not a Bug 19 Nov 2009 Fixed 23 Nov 2009 Fixed Description Add the ServerUserID column to the monProcess and monProcessWaits table and make the column a parameter,and also make the ServerUserID column a parameter in monProcessActivity table.

CR:443742

CR Number:   443742 Product Name:   Adaptive Server Generic Docs Product Component:   Other Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2008 Added to user documentation Description If raiserror is followed by any TSQL statement, @@error gets overwritten. Because of this sp_extrapwdchecks fails to return error in case of failed password, if the raiserror is followed by any TSQL statement.

CR:443755

CR Number:   443755 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 Oct 2007 Fixed 11 Oct 2007 Fixed 11 Oct 2007 Reservation Made Description This fix introduces Abstract Plans syntax to request index union or intersection. Pre-15.x, the "general OR strategy" was enumerated and costed by the optimizer when the WHERE clause contained OR clauses and all columns therein had indexes: each OR term was used in an index scan, then all resulting RIDs, after duplicate RID removal, were used to get the data tuples. This is actually an union-distinct mechanism and is implemented in 15.x as index union. In 15.x, to request the pre-15.x general OR strategy on table T, i.e. the index union, an AP would use "(union_scan T)". To specify either the merge or the hash based union-distinct algorithm, use merge_union_scan or hash_union_scan. Index intersection is also provided for experimentation but not yet for production, through hash|merge_intersect_scan. This functionality is used in the allrows_oltp "compatibility" mode (where the optimizer makes the best attempt to generate an execution plan similar to the pre-15.x one) when the legacy plan used the general OR strategy.

CR:443769

CR Number:   443769 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) 17 Oct 2006 Fixed 26 Jul 2007 Fixed Description A 691 error, "Encountered invalid logical page '0' while accessing object <negative id> in database '2'" may be reported when there are more then 128 disk fragements for tempdb database. Workaround Description  Make sure tempdb has less than 129 fragments.

CR:443787

CR Number:   443787 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) 27 Oct 2006 Fixed 13 Oct 2006 Reservation Made 05 Dec 2007 Insufficient priority to fix Description New features within ASE 15.0.2 require that we modify system catalogs. Provide support within ASE for detecting the need to do those modifications, and for downgrading to 15.0 and 15.0.1 servers. Upgrade must be automatic upon first boot of the new server, and upon online database after load database.

CR:443811

CR Number:   443811 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2007 Fixed 26 Jan 2007 Fixed Description A task waiting on completion of a remote process (such as backup) cannot be killed

CR:443815

CR Number:   443815 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2006 Fixed 09 Oct 2006 Fixed 09 Oct 2006 Fixed 29 Oct 2006 Duplicate Description When the "histogram tuning factor" configuration parameter something other than 1, and the "consumers" phrase is used in create index, and/or update statistics in order to obtain parallelism, then there is a possibility of an extraordinary number of histogram steps being created on the respective histogram, and this becomes additive, i.e. each execution of update statistics will increase the requested number of steps. This could result in resource issues for compilation w.r.t. locks, procedure cache, and possibly compilation time.

CR:443821

CR Number:   443821 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2006 Insufficient priority to fix Description Customer is requesting that we make it possible to configure, at the user level, to eliminate this message from the dbcc output. As it currently stands the user cannot control whether this counter is setup or not. Workaround Description  *** Thursday, October 05, 2006 10:10:11 PM *** cooperg *** N/A

CR:443852

CR Number:   443852 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) 07 Jan 2007 Fixed Description Occasionally, error message 9502 will be reported for a SELECT statement executed with 'set string_rtruncation on' for a SARG on char/varchar column that has statistics

CR:443885

CR Number:   443885 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2006 Fixed 05 Nov 2006 One-off Provided 18 Jan 2007 Fixed 17 Jan 2007 Fixed Description ssl_alloc() errors during Distinguished Name (DN) Lookup when binding the admin account, "the access account", can cause the security principal to be "locked out" because too many unsuccessful login attempts can be quickly attempted, exceeding the installation standards for unsuccessful retries. Workaround Description  Increase Netmemory. Alter LDAP login policies (impossible for many customers).

CR:444035

CR Number:   444035 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) 04 Dec 2006 Presently Not Targeted For Any Future Release Of This Product 29 Dec 2006 Fixed Description In rare circumstances, TIBCO JMS or EAS JMS messaging operations may fail with one or more error(s) reported in the JRTMSServer log file (rtms.log by default) saying a "lookup operation failed".

CR:444044

CR Number:   444044 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Need to enable client-side character conversion BLK_CONV in CIS Workaround Description  bcp the data out of the "sjis" server with -Jutf8 to convert the data into utf8 and then bcp the data into "utf8" server.

CR:444050

CR Number:   444050 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) 31 Oct 2006 Fixed Description A SELECT INTO combining the PARTITON clause with a UNION raises a 205 error even though the column lists are identical.

CR:444117

CR Number:   444117 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 May 2007 Fixed 24 Jul 2007 Fixed Description The auditing of login failures is enhanced to include the "Error number.Severity.State" in the "Other Information" section of extrainfo column.

CR:444143

CR Number:   444143 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) 24 Oct 2006 Fixed 03 Aug 2007 Fixed 01 Aug 2007 Fixed Description In rare circumstances, two transaction logs that were dumped within a fraction of a second of one another, can be loaded in either order. Using the wrong order will have unpredictable effects on database recovery. Workaround Description  The implication of this bug is that two transaction logs can be loaded in either order. The wrong order will cause problems. Two workaround exists: 1. load the transaction logs in the correct order 2. do not allow transaction log dumps to be taken so close to one another.

CR:444156

CR Number:   444156 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) 01 Nov 2011 Insufficient priority to fix Description enhance CIO on Veritas Storage Foundation

CR:444193

CR Number:   444193 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2007 Fixed 12 Jan 2007 Fixed 04 Feb 2007 One-off Provided Description Occasionally, error message 9502 will be reported for a SELECT statement executed with 'set string_rtruncation on' for a SARG on char/varchar column that has statistics Workaround Description  Turn off string_rtruncation. Originally thought ODBC would work but the query hangs using a Java ODBC client. C++ client sample seems to work fine but that is not an option for the customer.

CR:444221

CR Number:   444221 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) 20 Oct 2006 Fixed 27 Jan 2007 Fixed Description When ASE is shutdown while RTDS is enabled in a session, server could potentially stacktrace. Does not consistently reproduce but more likely on HP platform. Workaround Description  None.

CR:444264

CR Number:   444264 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2007 Fixed Description Running Adaptive Server with an served license under a large workload may result in a stack trace. Workaround Description  Use a "unserved" license instead of "served" license.

CR:444292

CR Number:   444292 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 May 2008 Fixed 05 Oct 2007 Fixed 11 Aug 2009 Presently Not Targeted For Any Future Release Of This Product 13 May 2008 Fixed Description The common name in ASE SSL Certificates is restricted in that it must match the name of the dataserver.

CR:444343

CR Number:   444343 Product Name:   Adaptive Server Enterprise Product Component:   sybconfig Status:   Closed OS:   Windows XP Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2007 Fixed Description create new server failed using syconfig after setting client charset to cp936 in locales.dat on Windows platform. Workaround Description  Change the client charset to iso_1 temporarily.

CR:444387

CR Number:   444387 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2006 Fixed Description A session running DBCC LOGTRANSFER may abnormally terminate with the message "timeslice <value>, current process infected" followed by a stack trace when ASE receives an interrupt (Control-C). The modules "do_logtransfer" and "senddone" will be reported in the error log.

CR:444395

CR Number:   444395 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) 24 Jan 2007 Presently Not Targeted For Any Future Release Of This Product 24 Jan 2007 Presently Not Targeted For Any Future Release Of This Product 17 Jan 2007 Reservation Made 24 Jan 2007 Fixed 04 Nov 2007 Fixed Description If a block device is used as database device there is no warning either in errorlog or displayed to user on all platforms except on HP-UX, NT, Linux.

CR:444474

CR Number:   444474 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Nov 2006 Fixed 09 Aug 2007 Fixed Description Adaptive Server ignores 'authenticate with' semantics when user attempts a kerberos login. Workaround Description  n/a

CR:444489

CR Number:   444489 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2006 Fixed 12 Feb 2007 Fixed Description Lava operators that use a work table as backing store may loop endlessly if a CTRL-C is issued while accessing the table. A merge-join with a very large number of duplicate join keys in the inner stream is the mostly likely scenario where this would occur. In the merge-join case, there is no way to kill the looping session.