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

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

CR:407533

CR Number:   407533 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2005 Fixed Description DBCC ORPHANTABLES may fail to clean up an orphaned temporary table that resides in a temporary database whose ID is different from the current session's temporary database ID. Workaround Description  create a new login and bind it to the specific tempdb containing the orphaned tables. Login as that user to use dbcc orphantables

CR:407541

CR Number:   407541 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 Oct 2005 Fixed 04 Nov 2005 Fixed Description A query like: declare @v select @v = 100 select @v = @v + id from sysobjects where id <= 3 returns 106 instead of 103, because every value of sysobjects.id is added to @v instead of just the last one. The expression, @v = @v + id, should only be evaluated for the last qualifying row. Target Version  15.0 ESD#2 Workaround Description  create a new login and bind it to the specific tempdb containing the orphaned tables. Login as that user to use dbcc orphantables

CR:407543

CR Number:   407543 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2006 Fixed Description A sub-optimal plan is generated if table alias is unspecified with a column name in SELECT list but specified with the same column name in ORDER BY clause

CR:407576

CR Number:   407576 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   NA Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2005 Fixed 19 Jan 2006 Fixed 25 Jan 2006 Fixed Description CIS: Error message 3708, "Cannot drop <table_name> because it is a system table." and message 2601, "Attempt to insert duplicate key row in <object_name> with unique index" may be reported when executing a CREATE DATABASE ... FOR PROXY_UPDATE against MSSQL backend.

CR:407666

CR Number:   407666 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 Oct 2005 Fixed Description When comparing NULLs with fixed-length columns, stacktrace may occur in LeOrScanContext::setOrVtuple().

CR:407679

CR Number:   407679 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) 28 Oct 2005 Fixed 28 Oct 2005 Fixed Description When an allpages table with more than one nonclustered index is updated, if a nonclustered index is safe (index columns are not updated) and if the second nonclustered index has one row in the root page, the update may fail with error 2601 if the index is safe index is unique. If the index is not unique, duplicate index row will be inserted.

CR:407687

CR Number:   407687 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) 28 Oct 2005 Fixed Description Alter table add/drop/modify, Reorg Rebuild table and alter table partition by... on table with local clustered index and the number of partition >= 29 on 32 bit server may run into error 632 . Workaround Description  Drop the local clustered index first before reorg command and recreate the index.

CR:407711

CR Number:   407711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2013 Duplicate Description Feature request for incremental backups (accumulated dump and incremental dump) similar to that of Oracle's RMAN.

CR:407720

CR Number:   407720 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2005 Consult Complete Description Upgraded 11.5.1 ASE server may select a slower plan compared to a non-upgraded server.

CR:407746

CR Number:   407746 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2006 Third Party Problem Description Adaptive Server running on RH3.0 64bit distribution occasionally hangs due to Red Hat kernel bug when kernel asynchronous I/O is enabled. The problem is fixed in RH kernel patch 2.4.21-27.6.EL or higher. Workaround Description  It is a Redhat bug. A bugzilla has been reported, https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=138905 and a fix is available in kernel version 2.4.21-27.6.EL.

CR:407754

CR Number:   407754 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 Oct 2005 Fixed Description A stack trace with command aborted message may occur while doing an insert into a table with indices. Stack trace with error 2618, "couldn't find duplicate key group" will be seen.

CR:407785

CR Number:   407785 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2006 Bundled Request Description execution of sp_setreplicate to turn off replication on a table with text/image columns should keep up to date syscolumns.status for those off-row columns.

CR:407814

CR Number:   407814 Product Name:   Adaptive Server Enterprise Product Component:   sqldbgr Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2009 DEFER 24 Mar 2010 Fixed Description Feature request to set HOSTPROC and APPLICATIONNAME properties in the Connection object for sqldbgr so that sysprocesses fields program_name and host are populated at login.

CR:407837

CR Number:   407837 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3 ESD#6 18 Dec 2005 Duplicate Description When JVM is active( enable java =1) and ASE has multiple online engines, stacktraces might occur after Garbage collection.

CR:407867

CR Number:   407867 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2006 Fixed Description After you run sp_engine "online" and an ASE engine starts up, sp_sysmon always reports 0% spinlock contention. Workaround Description  Make "number of engines at startup" be equal to "max online engines" and reboot your ASE.

CR:407920

CR Number:   407920 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2006 Fixed Description When multiple sessions, at least one of which is a cursor scan, are doing DMLs within transactions, inconsistent results may sometimes be obtained, with serializable inserts not blocking even though a serializable cursor scan may be active in that range of keys.

CR:407981

CR Number:   407981 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2005 Fixed 27 Oct 2005 Fixed Description Error 515 is raised despite presence of default on column and use of DEFAULT keyword in the values list when insert statement includes list of column names. Workaround Description  Don't specify the list of column names, i.e. insert foo values (default) rather than insert foo (col1) values (default)

CR:408047

CR Number:   408047 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) 28 Oct 2005 Fixed Description When a select statement has a predicate on a column, which is part of an inner table of an outer join, extra incorrect row(s) are returned. This is due to some plan for an outerjoin query could miss a predicate on a column of an outerjoin inner table.

CR:408066

CR Number:   408066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2007 Fixed 13 Dec 2006 Fixed 26 Mar 2007 Added to user documentation 18 Oct 2011 Presently Not Targeted For Any Future Release Of This Product Description create a function that returns the hostname of the physical or virtual host a server runs on from the OS.

CR:408078

CR Number:   408078 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2006 Fixed 26 Sep 2006 Presently Not Targeted For Any Future Release Of This Product 06 Jun 2006 Fixed 12 Jun 2006 Fixed Description ASE should raise a warning when running on 64-bit AIX system configured to run on a 32-bit kernel.

CR:408080

CR Number:   408080 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   AIX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2009 Presently Not Targeted For Any Future Release Of This Product 13 Jun 2007 Fixed Description srvbuild should raise a warning when installing ASE on 64-bit AIX configured with a 32-bit kernel

CR:408083

CR Number:   408083 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2006 Bundled Request Description A query like: select @v = @v + id from sysobjects where @v +id < 104, which has an expression in the select-list as well as an expression in the WHERE-clause can cause a query plan to be generated that contains a RestrictOp as the parent of another RestrictOp: One RestrictOp will evaluate the expression in the select-lis while the other will evaluate the expression in the WHERE-clause. Although the query results are correct, there can be a slight performance impact of having two RestrictOps when a single RestrictOp could do the same processing. Target Version  15.0.1

CR:408142

CR Number:   408142 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   IRIX Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2005 Fixed 14 Feb 2006 Fixed Description If a user task is moved from execution class EC0 (critical priority) to a non-critical priority class, the change is not immediate for that process, only on subsequent login.

CR:408204

CR Number:   408204 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   SunOS Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In the sp_audit stored proc while processing the "table_access" option, the generic 'all' value is incorrectly being validated using suser_id() function as if it were one of the uniquely named login_ids in the syslogins table (rather than the generic meaning of "ALL of the login_ids created"). 1> sp_audit "table_access", 'all', 'all', 'on' 2> go Msg 18226, Level 16, State 1: Server 'EQTGDBLNUA_DS', Procedure 'sp_audit', Line 305: 'all' is not a valid user name. (return status = 1)

CR:408209

CR Number:   408209 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   macosx Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2005 Fixed 08 Nov 2005 Fixed Description During shutdown, the XP Server was consuming all available CPU time due to a difference between Mac OS X 10.3.x and 10.4.x. A system function (dlclose())was returning failure, as expected, in 10.3.x, but was always returning success in 10.4.

CR:408212

CR Number:   408212 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) 09 Nov 2005 Fixed 10 Nov 2005 Fixed 03 Jan 2006 Fixed 07 Feb 2006 Fixed 14 Feb 2006 Fixed 21 Feb 2006 Fixed 21 Feb 2006 Fixed 14 Mar 2006 Fixed Description Reimplemented MDA table access (proxy tables mapped to native rpcs) without the need to use a network connection.

CR:408242

CR Number:   408242 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) 05 Jan 2006 Fixed Description In rare circumstances, upgrade of sysstatistics catalog to ASE150 might fail with the error message "Attempt to insert duplicate key row in object 'sysstatistics' with unique index 'csysstatistics'"

CR:408377

CR Number:   408377 Product Name:   Adaptive Server Enterprise Product Component:   dsedit Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2010 Not a Bug Description DSEDIT allows the creation of interfaces file entries that are not valid identifiers (contain hyphens, etc.)

CR:408384

CR Number:   408384 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Fixed 30 Nov 2005 One-off Provided 25 Nov 2005 Fixed 13 Jan 2006 Fixed Description A 8211 error, "Mismatch found between the name and id descriptor hash table for table <internal LWP name = (* + number + alfanumeric suffix) >, objid = <negative number>. Descriptor hashed by name = 0x0 and hashed by id = <hexadecimal number>." together with a stack trace which includes the modules 'lwp_create' and 'des_lwpdescreate' maybe be reported in the errorlog if a client application connection has executed a high number of dynamic sql statements without disconnecting from Adaptive Server. In the same conditions and if the same connection is holding a cursor open which uses internally a worktable then the message "current process infected with 11" in the module 'proc__install' may be reported in the error log and it could bring Adaptive Server down. Workaround Description  not available

CR:408416

CR Number:   408416 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) 01 Nov 2005 Fixed Description When the ALTER TABLE command is run in tempdb using a parallel query plan, a 202 error can sometimes be generated. Target Version  15.0 ESD#2

CR:408446

CR Number:   408446 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 06 Feb 2006 Fixed 15 Mar 2006 Fixed 16 Mar 2006 Fixed Description SSL5 feature is supported on RedHat Linux Opteron 64bit platform for ASE 12.5.3

CR:408482

CR Number:   408482 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 Nov 2005 Fixed 09 Jan 2006 Fixed Description An infected with 11 in the function StMergeHistSargs::Stmhlncrement may result due to insufficient procedure cache during optimization

CR:408492

CR Number:   408492 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) 02 Nov 2005 Fixed Description A compute-clause query doesn't return groups correctly if the by clause contains expressions. This has been fixed.

CR:408596

CR Number:   408596 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) 07 Nov 2005 Fixed 10 Nov 2005 Fixed 04 Jan 2006 Fixed Description In rare circumstances on a server that has been configured with large buffer pools, 644, 2628, 2511 or other similar errors may be reported after an update to a non-leaf index page table is lost. Workaround Description  Use only 2k pool

CR:408653

CR Number:   408653 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) 04 Oct 2006 Fixed Description Enhance sp_displaylogin to accept wildcard expressions to list logins matching the pattern specified. Allow use of a suid in addition to a login name.

CR:408726

CR Number:   408726 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2005 Fixed Description CIS : When the UPDATE STATISTICS command is issued immediately upon creation of a proxy table containing clusterd index in an Allpages lock scheme, an erroneous entry in SYSTABSTATS with column id 0 (object id) will be created and the ASE internal housekeeper task may monopolize the CPU utilization to 100%. During ASE shutdown, an error message 6008, "Unable to write statistics for object <objid> in database <dbid>. Please run update statistics on this table after boot-up or prior to accessing the table next time" will be reported in the errorlog. Once ASE that contains this fix has been started/rebooted, the entry in SYSTABSTATS with id = 0 should also be manually deleted.

CR:408736

CR Number:   408736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2005 Fixed 14 Dec 2005 Fixed Description Client application based on DBLibrary API and executing UPDATE statements using the TSEQUAL() function may fail and the client server connection gets broken with TDS protocol errors. This is due to the extra result set sent by tsequal() builtin which may not be correctly handling by DBLibrary API. Workaround Description  Use 12.5.3 ESD#1. (Or code application correctly with results loop!)

CR:408765

CR Number:   408765 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Nov 2005 Duplicate Description Configurable timeout periods in milliseconds are need for the ldap operations which ASE performs during ldap_ operations to be able to failback to ASE authentication in a timely manner providing guaranteed client login performance.

CR:408772

CR Number:   408772 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2005 Bundled Request Description When there are significant failures or changes in the processing with LDAPUA, provide server log messages about the activities. It should be possible to determine things like timeouts of authentications, failure of ldap_search() operations. It should be possible to determine if LDAP server operatations are failing by monitoring the log.

CR:408774

CR Number:   408774 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2005 Bundled Request Description Would like customer configurable limit of the number of internally queued login requests before ASE starts processing new requests with ASE Authentication. The idea is to prevent signicant delays in Authentication for what might be very short peaks of login requests.

CR:408777

CR Number:   408777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2006 Fixed Description LDAPUA bind and search requests do not have configurable retries for failed operatations. There is also no configurable maximum number of ldapua descriptors per engine and no configurable ldapua error message and average time logging interval.

CR:408860

CR Number:   408860 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2005 Fixed Description In rare circumstances, running OPTDIAG with simulate statistics -i <input_filename> option might cause the optdiag binary to crash, if the input file is missing the title for the "default data cache".

CR:408984

CR Number:   408984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 EC Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2005 Bundled Request 13 Dec 2005 Fixed Description When you have a SELECT DISTINCT <all constants include scalar aggregates> as part of your query, you might hit a siginal 11 during the call to CgpUnion::_cgpInit() or get wrong result with extra rows.

CR:409018

CR Number:   409018 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2009 Not a Bug 14 Dec 2009 Consult Complete Description When a database created with "FOR LOAD OPTION" is loaded with a partial dump (i.e. not all pages in the database are present in the database dump), the pages that were not overlaid by the backupserver may present a recovery issue later. An initialized page with a timestamp greater than the highest timestamp in the database when allocated may cause recovery to skip this allocation if ASE crashed before this new page gets flushed to disk. After recovery, the object to which this page was allocated may become inconsistent. Workaround Description  1. When creating a database, ensure that the FOR LOAD option is not used. 2. When dumping a database, ensure that the DUMP DATABASE is preceded by: sp_dumpoptimize 'archive_space=maximum' 3. This ensures that every page in the database is dumped.

CR:409094

CR Number:   409094 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) 02 Jun 2007 Fixed 01 Jun 2007 Reservation Made Description Some applications depended on certain metadata information about databases that was available in 12.5.4 and prior is no longer available in 15.0. Provide a builtin function to obtain and display that data to properly privileged users.

CR:409170

CR Number:   409170 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) 11 Nov 2005 Fixed Description Server might have unneccessary index page split due to uninitialized/incorrect pnextrno on an index page header

CR:409199

CR Number:   409199 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) 17 Mar 2006 Fixed 29 Aug 2006 Fixed Description The kill of a session that runs ALTER DATABASE will result in mistakenly not reporting 946 error "A user interrupt has prevented Sysusages changes for database <name> from being copied into memory. Please run sp_dbremap to complete database space changes.". The side effect of this is the inability to subsequently run ALTER DATABASE with success, 2601 error "Attempt to insert duplicate key row in object 'sysusages' with unique index 'sysusages'." is reported, until such a time ASE is restarted. Workaround Description  dbcc dbrepair(<dbname>, remap) or run sp_dbremap "<dbname>"

CR:409285

CR Number:   409285 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2005 Fixed Description 1) There are limited password complexity checks when a new password is specified or a password is changed.

CR:409321

CR Number:   409321 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2005 Fixed Description A presence of the named CHECK constraint in the temporary table definition prohibits creation of multiple instances of the table. User will see error 2714 with the message "There is already an object named 'constraint name' in the database." when attempting to create a temporary table. Workaround Description  use unnamed constraint create table #t1(col1 int check(col1 in (1,2)))

CR:409337

CR Number:   409337 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2007 Workaround Description Historical Server: Direct Load feature leaves open connections in the ASE used for the recording. Workaround Description  Shutting down the histserver clears the connections.

CR:409347

CR Number:   409347 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2007 Fixed 21 Nov 2007 Fixed Description Adaptive Server tries to flush a free descriptor from the local cache of engines' by migrating to the engine without looking at the count of free descriptors on that engine, leading to a small performance degradation when all descriptors are in use.

CR:409405

CR Number:   409405 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0 tier2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2005 Fixed 14 Mar 2006 Fixed 02 Jun 2006 Bundled Request Description sqlupgrade[res] does not abort the upgrade process when preupgrade tests failed.

CR:409455

CR Number:   409455 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2006 Fixed 17 Feb 2006 Fixed Description This new feature allows user to selectively display discovered servers based on a set of filters, e.g. version, platform. To create/edit filters, click Settings button on ASE Plug-in's logon dialog and select Server Discovery page. Click Filters button to proceed. Note that filters, along with other server discovery or LDAP settings, are shared between ASE Plug-in and Interactive SQL.

CR:409471

CR Number:   409471 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0 tier2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2006 Fixed Description Memory allocation in the network memory pool may fail in a boundary conditions even when memory is available. The failure to allocate memory may manifest as failure to allocate large network memory pools.

CR:409494

CR Number:   409494 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2006 Bundled Request 18 Apr 2006 Fixed 05 Jun 2006 Bundled Request Description Modify MDA table definitions in the installmontables script to access monitoring data through local connections. This eliminates the need for a loopback remote server definition when using the MDA tables.

CR:409579

CR Number:   409579 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2006 Fixed 07 Dec 2005 Fixed Description QPMETRICS: Add new sp_configure options for configuring thresholds of QP metrics capturing. The new sp_configure options are 'metrics lio max', 'metrics pio max', 'metrics elap max', 'metrics exec max'.

CR:409605

CR Number:   409605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2005 Fixed 12 Jan 2006 Fixed Description If user enters blank schedule for a job, the job scheduler task within ASE terminates and job scheduler stops working.

CR:409607

CR Number:   409607 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2008 Not a Bug Description XP Server fails to start as service with error 1067 Workaround Description  1) Download the "Windows Server 2003 Resource Kit Tools" http://www.microsoft.com/downloads/details.aspx?FamilyID=9d467a69-57ff-4ae7-96ee-b18c4790cffd&displaylang=en 2) Install the "Windows Server 2003 Resource Kit Tools" into a directory like "c:\reskit". If you install it into the default directory the "instsrv.exe" utility will have problems recognizing directories with spaces in their names. If you do install it into the default directory, you can copy the following two files into a directory that the "instsrv.exe" utility will recognize: C:\ mkdir reskit C:\Program Files\Windows Resource Kits\Tools>cp srvany.exe c:\reskit C:\Program Files\Windows Resource Kits\Tools>cp instsrv.exe c:\reskit C:\Program Files\Windows Resource Kits\Tools>cd \reskit 3) Remove the existing XP Server service. Be careful to remove the XP Server service and not any other Sybase service!!! c:\reskit> INSTSRV STACKXP_XP REMOVE The service was successfully deleted! 4) Install the XP Server service using the "INSTSRV" utility: C:\reskit>instsrv STACKXP_XP C:\reskit\srvany.exe The service was successfuly added! Make sure that you go into the Control Panel and use the Services applet to change the Account Name and Password that this newly installed service will use for its Security Context. 5) In the Registry Editor window, go to HKEY_LOCAL_MACHINE | SYSTEM | CurrentControlSet | Services and click your XP Server service name). 1. Add a new key by selecting Edit | New | Key. Enter "Parameters" as the Key name. 2. Click Parameters and add a new string value by selecting Edit | New | String Value. Enter "Application" as the new String value. 3. Double-click Application. The Edit String dialog box appears. In Value Data field, enter: c:\sybase\ase-15_0\bin\xpserver.exe -C -SSTACKXP_XP -IC:\sybase\ini -p8 -s65536 -e1 -lLocalSystem -aSTACKXP NOTE: Replace above values with correct directory, service name, etc. for your environment. 6) Select Control Panel | Services. Click <XP Server service name>, then click Startup. NOTE: You can also change the "startup type" to "automatic" here if you want to. OR As a temporary workaround you can do the following: Copy the contents of "Path to executable" to the text box called "Start Parameters" and then xp_server starts as a service. NOTE: You will have to do this each time you want to start it as a service as Windows does not save the "Path to executable".

CR:409640

CR Number:   409640 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2006 Fixed Description On platforms other than Windows and MacOS, printing messages to console is now made non-blocking if permissions allow, in order to prevent the server from potentially hanging when console output is blocked (typically by a user leaving ^Q/^S terminal flow control in an off state by accident). This behaviour can be disabled using traceflag 4082.

CR:409645

CR Number:   409645 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2005 Fixed Description CIS: CREATE INDEX options IGNORE_DUP_KEY and IGNORE_DUP_ROW are not ignored when executing an INSERT or UPDATE query to a proxy table in a remote ASE. Workaround Description  The customer rewrote their queries by selecting the whole proxy table into a local temp table, creating the same ignore_dup_key index on the temp table, inserting into that, and then returning only the new rows to the proxy table.

CR:409802

CR Number:   409802 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) 16 Nov 2005 Fixed Description signal 11 and stacktrace can be seen for CgpScan::_CgpScanPePredBmToScalar(). It could happen on an execution plan for a query with all three following conditions satisfied: 1. it has a DISTINCT. 2. the best plan chosen has at least 3 subqjoins together. 3. the first subqjoin's result is used within one of the other two subqjoins because of the transitive closures (equijoin clauses).

CR:409864

CR Number:   409864 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2005 Fixed Description For Adaptive Server Enterprise running on HP-UX systems with asynchronous I/O enabled, if /dev/async runs out of free ports, any attempt to online an engine causes ASE to shut down.

CR:409943

CR Number:   409943 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) 11 Jan 2006 Fixed Description The audit sub-system unexpectedly causes empty beginxact/commitxact pairs in a database transaction log if the SELECT command is audited on a table and the transaction mode is 'chained'.

CR:409947

CR Number:   409947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Not a Bug Description ASE db on raw devices is not locked and can be overwritten by other processes

CR:410030

CR Number:   410030 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2005 Fixed Description In rare circumstances, sysqueryplans capture may fail with error 3949.

CR:410036

CR Number:   410036 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   AIX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 23 Nov 2005 Fixed 15.0 ESD#2 23 Nov 2005 Fixed Description EFTS: txtsvr crashes/creates_core when memory usage reaches 264-220 meg on AIX only.

CR:410121

CR Number:   410121 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2011 Fixed 24 Nov 2011 Fixed Description Under dbcclog prompt when running some dbcclog command, pressing ^C will cause the dbcclog command to return to the sybmon prompt rather than dbcclog prompt. Then all the loaded transactions need to be loaded again.

CR:410174

CR Number:   410174 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2006 Fixed Description sp_helpmaplogin truncates the display of client name and login name to 20 characters

CR:410204

CR Number:   410204 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) 16 Jul 2006 Fixed Description sp_metrics will support a new sub-command 'show' for the information of QP metrics groups

CR:410272

CR Number:   410272 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2005 Fixed Description When joining with a union-in-view(uiv) through an expression on the uiv column, a stacktrace might be seen in CgpUnion::_CgpInitProjection(). Here is an example: create view v as select id from t unon select id from t go select * from v, t where v.id*2=t.id go

CR:410277

CR Number:   410277 Product Name:   Adaptive Server Enterprise Product Component:   sybconfig Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2010 Fixed 08 Nov 2011 Fixed Description syconfig.exe can not configure the new server with NAMEPIPE connection type. Workaround Description  - Edit the SQL.INI file and correct the entry. - Press <Ok> button of the error pop-up message box

CR:410289

CR Number:   410289 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2006 Fixed Description CIS: Insert text or image data into ASIQ 12.6 may cause a hang on ASE. The spid needs to be manually killed from another ISQL session.

CR:412040

CR Number:   412040 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2006 Fixed Description Sybase Central fails to send sp_changedbowner with the true argument when the user checks the 'Transfer aliases and their permissions.'

CR:414495

CR Number:   414495 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2006 Fixed Description ASE does not shut down XP Server during a shutdown with nowait Workaround Description  ASE recognizes that their is an errant XP Server running when it restarts and kills it at that time.

CR:414519

CR Number:   414519 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Windows W2k Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2005 Fixed 12 Jan 2006 One-off Provided 28 Feb 2006 Fixed Description JS Agent may sometimes stop or/and report errors like "Failed to allocate memory for job output data row", "Failed to allocate memory for job output header" etc., in the JS Agent log file and bring down the Job Scheduler due to memory leaks in JSAgent.

CR:414524

CR Number:   414524 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Windows W2k Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2008 Presently Not Targeted For Any Future Release Of This Product Description Automatic restart of JS Agent Workaround Description  When customers JS Agent crashes, then execute the following to restart the JS Agent: sp_js_wakeup "stop_js" ,1 go sp_js_wakeup "start_js" ,1 go

CR:414590

CR Number:   414590 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) 30 Nov 2005 Fixed Description dbcc tune(ascinserts, 0, tab1) does not turn off the corresponding status bit on indstatus2.

CR:414609

CR Number:   414609 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   HP-UX Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 01 Dec 2005 Fixed Description EFTS: When indexing PDF documents on HP-UX only, sp_create_text_index may fail with Msg 20200, Level 15, State 0: Server 'textsvr': Error E0-0720 (I/O Filter): Could not load filter 'flt_kv -recognize' which is named in your style.uni file. Workaround Description  Possibly remove the HP patch PHSS_22543 - untested.

CR:414616

CR Number:   414616 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2007 Fixed 06 Dec 2007 Fixed Description A 7114 error, "Page 0 is not a valid text page." may be reported in the error log after loading the master database in an ASE which has a smaller value for the configuration parameter "max memory" than in the ASE when the master is dumped. Workaround Description  Configure "max memory" as large as the original server or start the server with traceflag 5801 before the load.

CR:414617

CR Number:   414617 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Open OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Assigment of incompatible datatypes will cause a infected with 11

CR:414618

CR Number:   414618 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2005 Fixed Description Query selecting from a view with UNION may fail with error 104: "Order-by items must appear in the select-list if the statement contains set operators." if in the parent query ORDER BY clause is used on the view column which is not present in the parent's query SELECT list.

CR:414661

CR Number:   414661 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Windows W2k Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2006 Workaround Description JS Agent dies due to network problem.

CR:414692

CR Number:   414692 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 EC Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2005 Fixed Description Error message: Msg 586, Level 16, State 5: Line 1: Illegal identity value specified for identity field 'idcol' in table 't1'. could be seen when inserting into a table with IDENTITY column from a union/union all.

CR:414725

CR Number:   414725 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) 26 Dec 2005 Fixed 10 Jan 2006 Fixed 12 Jan 2006 Fixed Description Queries containing two or more nested subqueries under either a SELECT DISTINCT or a IN/EXISIS subquery could fail with a stack trace.

CR:414746

CR Number:   414746 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2005 Fixed Description The Reference Manual entry on EXECUTE incorrectly states: "create view cannot be used in procedures, either as a static command or as a string parameter to execute()."

CR:414762

CR Number:   414762 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2006 Fixed Description Conversion of smallint quantities into varchars could lead to wrong results.

CR:414775

CR Number:   414775 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2005 Fixed 12 Dec 2005 One-off Provided Description When a stored procedure fails then the error handling procedure tries to read the sysattributes table. But if the stored procedure itself failed because of a failure accessing sysattributes then the error handler can be triggered recursively leading to an infinite loop. The requirement to read sysattributes has now been removed from the error handler

CR:414777

CR Number:   414777 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) 06 Jan 2006 Fixed Description A table with suspect partition due to sort order change or cross platform dump load may be treated as regular table after clustered index is created on the table before the suspect partition is fixed. Workaround Description  Fix the suspect partition through either reorg rebuild table or "alter table partition by..." (if partition definition need to be changed) before create clustered index on the table.

CR:414778

CR Number:   414778 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2006 Presently Not Targeted For Any Future Release Of This Product Description Error 1511 when loading tran dumps containing index creation

CR:414780

CR Number:   414780 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2006 Fixed 17 Apr 2006 Fixed Description Attempts to load shared memory dump files on Linux may fail due to erroneous reports of memory segment overlap Workaround Description  In order to work around a bug in loading this memdump you will need to do the following: 1) Run sybmon under the gdb debugger gdb ./dataserver 2) Set a breakpoint before starting sybmon [[Oct 07 - Bret] - use ~/dputz/src/amd64-address.sh to find the correct address. This will be an instruction like mov $0x1,%r13d ] (gdb) break *0xa7909a 3) Start the session, and load the memdump (gdb) run -X -Pquine >memload ds3.dmp.2005111704231001 4) You should hit the breakpoint after the overlap messages print At the gdb prompt at that point, enter (gdb) set $rax=0 (gdb) cont 5) You will now be running in sybmon. When you quit sybmon, gdb will print: Program exited normally. Just enter 'exit' to get out of gdb.

CR:414786

CR Number:   414786 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   RH Linux Original Version:   15.0 tier2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2006 Fixed Description Previously, negative integer values exported to an Excel spreadsheet were exported incorrectly (the values were incorrect). This has been fixed. DOUBLE, FLOAT, NUMERIC, and REAL values were not affected.

CR:414832

CR Number:   414832 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 Jan 2006 Fixed Description Specifying an invalid "optimization goal" name may cause infected with 11 in strlen() on Japanese environment.

CR:414837

CR Number:   414837 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) 11 Jan 2006 Fixed Description After you run ALTER TABLE ... LOCK command on a table with a non-materialized computed column, you may get the wrong result from selecting the non-materialized computed column.

CR:414853

CR Number:   414853 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 01 Dec 2005 Fixed Description EFTS: Request for EFTS to be built on Verity VDK 5.0.1 to include Verity bug fixes for indexing ZIP files. Fix does not apply to HP Tru64 platform of EFTS. Workaround Description  None known.

CR:414875

CR Number:   414875 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2009 Fixed 02 Nov 2009 Fixed Description Cause : If the "allow nulls by default" dboption is on for tempdb, the installmaster script will raise error 2718 'can't specify Null values on a column of type BIT' in multiple places. Fix: bit columns were defined as null Workaround Description  Temporarily turn off the "allow nulls by default" dboption for tempdb and rerun the installmaster script.

CR:414876

CR Number:   414876 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) 13 Dec 2005 Fixed 10 Jan 2006 Fixed Description Create clustered index with empty partitions (at the beginning like: 0, 0, 120,and 454 are the number of rows in each partition respectively) will result in Error: 691. Severity: 20. State: 1.

CR:414881

CR Number:   414881 Product Name:   Adaptive Server Enterprise Product Component:   Graphical Plan Viewer Status:   Closed OS:   Windows XP Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2006 Bundled Request Description When you show a query plan view through Plan Viewer on DBISQL, you encounter java.text.ParseException because of unparseable date if platform is Japanese Windows.

CR:414916

CR Number:   414916 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 tier2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2006 Fixed 18 Jan 2006 Fixed Description Stack trace when executing a query running with parallelism enabled that has a subquery. The error occurs only if a parallel plan is chosen for the subquery portion of the query.

CR:414935

CR Number:   414935 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) 14 Sep 2006 Fixed Description For numeric parameters, Replication Agent will print a meaningful error message indicating the correct range of possible values for a given configuration parameter. Workaround Description  none

CR:414943

CR Number:   414943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2006 Fixed Description An 16130, SVRLIB error, "Procedure <procedure name> expects parameter <@parameter_name>, which was not supplied" maybe be reported by an Open Server application when Adaptive Server is executing the procedure as a Remote Procedure Call (RPC) requested by a client application and the value for the parameter was sent by the application as a NULL value. Workaround Description  Define the open server parameters to have a default.