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

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

CR:424287

CR Number:   424287 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) 22 Mar 2006 Fixed 22 Mar 2006 Fixed 04 May 2006 Fixed Description This fix is to update logic of counting number of physical processors considering the introduction of intel hyperthreaded processors.

CR:424299

CR Number:   424299 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2006 Fixed Description If path ends with \, dbisql.bat will gives java syntax error. Correct that by adding ; at the end of path inside dbisql.bat

CR:424375

CR Number:   424375 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) 12 Apr 2006 Fixed Description Adds Replication Agent support for alter table <table_name> drop partition.

CR:424428

CR Number:   424428 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2006 Fixed Description Enable MIT Kerberos feature on HPIA platform

CR:424431

CR Number:   424431 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2006 Fixed Description Enable MIT Kerberos feature on Linux IBM pSeries platform

CR:424438

CR Number:   424438 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Solaris Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2006 Fixed Description Previously, when connected to an ASE server, you could get spurious error messages of the form "There was an error reading the results of the SQL statement. The displayed results may be incorrect or incomplete." after calling stored procedures (e.g. sp_cacheconfig) in console mode. This has been fixed.

CR:424463

CR Number:   424463 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   HP-UNIX Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2006 Fixed 11 Apr 2006 Fixed Description sqlupgraderes can not boot old ASE in the upgrade process. Workaround Description  Boot up the old ASE manually before running sqlupgradres.

CR:424587

CR Number:   424587 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) 14 Apr 2006 Fixed Description A suboptimal plan could be chosen for a query that has a large "IN (values ...)" WHERE clause and whose SELECT list columns would make a row too large to store into a worktable.

CR:424592

CR Number:   424592 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2006 Fixed Description CIS: A stacktrace along with the message "NULL aghead pointer in var_expression()" might be observed in some SELECT INTO statements with join clauses involving local and remote tables. Workaround Description  Run query with TF11216. Query passes.

CR:424608

CR Number:   424608 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) 20 Mar 2006 Fixed 21 Mar 2006 Fixed Description This fix is to support new license type "NA". "NA" stands for not applicable.

CR:424632

CR Number:   424632 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2006 Fixed Description sp_sproc_columns column column_type should return only 0 or 5. 15.0 docs are not consistent with 12.5.1.

CR:424672

CR Number:   424672 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2006 Fixed Description Queries with materialized view may use more worktables in ASE 12.5 release than in previous releases. In some cases the query which executed fine in ASE 12.0 may no longer execute in ASE 12.5 failing with error 251, "Unable to allocate ancillary table for query optimization. Maximum number of tables in a query (14) exceeded."

CR:424722

CR Number:   424722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2006 Duplicate Description Enable MIT Kerberos feature on ibmplinux platform

CR:424733

CR Number:   424733 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2006 Duplicate Description Enable MIT Kerberos feature on HPIA64 platform

CR:424736

CR Number:   424736 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) 21 Mar 2006 Fixed 11 Apr 2006 Fixed 22 Mar 2006 Fixed 02 May 2006 Duplicate 04 May 2006 Fixed 04 May 2006 Presently Not Targeted For Any Future Release Of This Product Description The fine-grained algorithm enabling/disabling settings are currently available at the connection level, through the SET XXX ON/OFF/DEFAULT, where XXX is nl_join, merge_join, etc. There settings should be available also at the query level using AP language extensions (as currently the case for the optgoal and opttimeout settings).

CR:424770

CR Number:   424770 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   athena Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2006 Fixed 23 Jun 2006 Fixed Description Via an XEM, the customer has defined a stereotype with a custom symbol for the Element metaclass. In the XML model, when the stereotype is associated with the element, the custom symbol is not applied. 6/26/2006 This issue has been resolved in the PowerDesigner/PowerAMC 12.0.0 EBF4. 7/31/2006 This issue has been resolved in the PowerDesigner/PowerAMC 12.1.0 release.

CR:424826

CR Number:   424826 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2006 Bundled Request Description When a primary key or a unique declarative clustered constraints for an All Pages Locking table are dropped, ASE does not incorrectly remove the status value "Index supports primary key/unique declarative constraint" from Sysindexes. This results in incorrect SP_HELP output.

CR:424846

CR Number:   424846 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 Mar 2006 Fixed 15 Jun 2006 Fixed Description The query plan for a query such as: select substring ('back yard', -1, -4) where 1 = 2, which has an expression in the select-list, but also has an expression in the WHERE-clause that disqualifies all rows will still cause the select-list expression to be evaluated. In the example, the expression is invalid, so an error will be returned, even though no rows qualify. Target Version  15.0.1

CR:424848

CR Number:   424848 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Digital UNIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2006 Bundled Request Description When attempting to run Sybase Central on the HP Tru64 platform using the scjview.sh script the message "Unknown OS: 'OSF1'" would occur in the window in which the script was executed

CR:424866

CR Number:   424866 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) 28 Mar 2006 Presently Not Targeted For Any Future Release Of This Product Description Make sp_sproc_columns to be odbc compliant

CR:424867

CR Number:   424867 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   macosx Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2006 Fixed Description The installs for the ebf are replacing any existing license.dat file with a one that contains a single INCREMENT line for ASE_DEV Workaround Description  manually make a copy of the existing license.dat file before installing the ESD , then run the esd install, after that is complete copy the old license.dat file over the new one that is existing now in $SYBASE/SYSAM-1_0/licenses

CR:424932

CR Number:   424932 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) 18 May 2006 Fixed Description An archive database device incorrectly needs read/write permissions to be initialized.

CR:424975

CR Number:   424975 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2006 Fixed 11 Jul 2006 Fixed 12 Jul 2006 Fixed Description CIS only uses quoted identifiers around column name in select to remote server. CIS should also use quoted identifiers around the table name. Workaround Description  put double quotes around the table name in the create proxy_table statement...their was resistance to using the workaround because they thought that if the create proxy statement works then they should be able to use the proxy_table. They expect ASE/CIS to be consistant...place quoted identifiers around the column name AND the table name. isql -Sa3ss1253e6 -Usa -P -w2048 -Drepro1 select @@version go connect to hardscrabble go select db_name() go sp_helpserver go exec atatversion go drop table "t st" go create table "t st" (c1 char(3)) go insert into "t st" values ('huh') go select * from "t st" go disc go drop table pxy_test_tblnm_space go create proxy_table pxy_test_tblnm_space at 'hardscrabble.dcontest.."t st"' go insert into pxy_test_tblnm_space values ('hah') go select * from pxy_test_tblnm_space go exit ***************************************************************************************** C:\oc125_ESD14\OCS-12_5_ESD14\bin>isql -Sa3ss1253e6 -Usa -P -w2048 -Drepro1 1> select @@version 2> go --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Adaptive Server Enterprise/12.5.3/EBF 13196 ESD#6/P/Sun_svr4/OS 5.8/ase1253/1945/32-bit/FBO/Fri Jan 20 07:50:34 2006 (1 row affected) 1> connect to emshs126e1ss 2> go Entered passthru mode to server 'emshs126e1ss'. 1> select db_name() 2> go expression 1 -------------------------------------------------------------------------------------------------------------------------------- dcontest (1 row affected) 1> sp_helpserver 2> go SERVER_PROPERTY PROPERTY_VALUE -------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SERVICENAME emshs126e1ss OPEN SERVER VERSION Sybase Server-Library/12.5.1/P-EBF12506-12505 ESD #8/DRV.12.5.1.3/SPARC/Solaris 2.8 Native Threads/BUILD1251-041/OPT/Sun Apr 10 21:02:15 2005 SERVICE MANAGER VERSION DirectConnect Service Manager/12.6 ESD#1/P-EBF12889-12894/SUN SPARC/Solaris v8/007/OPT/Sep 6 2005 14:11:04 ACCESS SERVICE LIBRARY VERSION DirectConnect for DCANY/12.6 ESD#1/P-EBF12889-12894/SUN SPARC/Solaris v8/007/OPT/Sep 6 2005 14:11:04 TARGET VERSION DirectConnect 08.00.49664 (5 rows affected) 1> exec atatversion 2> go expression 1 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 2) (1 row affected) 1> drop table "mwt st" 2> go 1> create table "mwt st" (c1 char(3)) 2> go 1> insert into "mwt st" values ('huh') 2> go (1 row affected) 1> select * from "mwt st" 2> go c1 --- huh (1 row affected) 1> disc 2> go Exited passthru mode from server 'emshs126e1ss'. 1> drop table pxy_test_tblnm_space 2> go 1> create proxy_table pxy_test_tblnm_space at 'emshs126e1ss.dcontest.dbo."mwt st"' 2> go 1> insert into pxy_test_tblnm_space values ('hah') 2> go (1 row affected) 1> select * from pxy_test_tblnm_space 2> go c1 --- huh hah (2 rows affected) 1> exit

CR:424982

CR Number:   424982 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2006 Fixed 08 Jun 2006 Fixed 13 Jun 2006 Fixed 15.0.1 13 Jun 2006 Fixed 15.0.1 24 May 2006 Fixed Description The sqlloc utility does not show charset gb18030 when 'Chinese' language is chosen. Workaround Description  The workaround is to directly use 'langinsta' and 'charset' utilities to install the charset and language.

CR:425072

CR Number:   425072 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2006 Fixed 27 Jul 2006 Not reproducible with latest version of the product available as of Resolution Date 17 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date Description Query with a subquery flattened to the exists join and executed with special or strategy (showplan output showing "Using N Matching Index Scans") may sometimes return the same row multiple times making the total result set bigger than expected.

CR:425127

CR Number:   425127 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2006 Fixed Description When a user generates DDL for a table, partition names are generated even when they are are not user-defined and are system generated.

CR:425162

CR Number:   425162 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2009 Insufficient priority to fix 11 Jan 2007 Fixed Description Create clustered or non-clustered index on a UTF-8 server with non binary sortorder is very slow as compared to other character sets. Boot time traceflag 2409 needs to be turned on to enable the fix solution.

CR:425183

CR Number:   425183 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2006 Fixed 02 Jun 2006 Bundled Request Description "auditinit" didn't check if given logical device name is an valid identifier.

CR:425273

CR Number:   425273 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) 06 Apr 2006 Fixed 10 Apr 2006 Duplicate 04 May 2006 Fixed Description When, on a table, 2 function indexes are created, and subsequently the first index is dropped, ASE stacktraces and terminates

CR:425310

CR Number:   425310 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) 02 Apr 2009 Insufficient priority to fix Description The Message Description from SYSMESSAGES: Error 318: "sysstatistics catalog was read and an inconsistency was found, please run update statistics and contact Sybase Technical Support." It doesn't tell what table need to run update statistics. It doesn't tell what database need to run update statistics. Customer would like to have error 318 giving more details on database/object level where there error occurs.

CR:425319

CR Number:   425319 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) 06 Apr 2006 Fixed 11 Apr 2006 Fixed Description CIS: Error msg 691 together with a stack trace which includes the modules 'txtimg_upd_table' and 'amc_finish_command' may be reported in the error log if ALTER TABLE ... MODIFY a column to null on a proxy table with any text or image column

CR:425340

CR Number:   425340 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) 07 Apr 2006 Fixed Description Previously (15.0 ESD#2 ASE Plug-in) BCP menu for a view is located at the end of its context menu. This has been moved to closer to the top of context menu to be consistent with other object's context menu.

CR:425349

CR Number:   425349 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) 30 Mar 2006 Fixed Description Database page might be initialized and result in 1142 error or error message 'Unable to find the sysusages row that controls the allocation page <pageno> while doing the extents accounting for OAM page <pageno>, object ID <objid>, index ID <indid>, database ID <dbid> (OAM entry nn).' printed in the errorlog during ONLINE or 692 error during sp_post_xpload, after 15.0 database dump file was loaded across platform if there is an un-upgraded allocation page in the 15.0 database dump file. This problem happens only after a pre-15.0 database was upgraded to 15.0 and was dumped again on 15.0, then loaded on 15.0 again across platform. Workaround Description  After a database is upgraded to 15.0 from pre-15.0, (and after online), do either of: 1)shutdown server and restart or 2)run dbcc checkalloc command before the dump database command for XPDL. Or do the XPDL directly from pre-15.0 to 15.0. (ie. do not use XPDL between two 15.0s.)

CR:425376

CR Number:   425376 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2006 Fixed 13 Jul 2006 Fixed 26 Jul 2006 Fixed 25 Jul 2006 Not reproducible with latest version of the product available as of Resolution Date Description If data length expansion possibly occurs due to character set conversion from client to server, bulk copying data to a replicated text column with DB-Lib bulk copy routines may cause error 7105. Workaround Description  There is no acceptable workaround.

CR:425396

CR Number:   425396 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2007 Fixed 19 Apr 2007 Fixed 19 Apr 2007 Fixed Description If the value of the 'max SQL text monitored' configuration parameter is greater than 16384 bytes and a n application submits a SQL batch larger than 16384 bytes, a query on the monProcessSQLText Monitoring Table may generate a 632 error. Workaround Description  sp_configure "max SQL text monitored", 16384 But if your customer wants to monitor SQL statements over 16384 bytes, there is no workaround.

CR:425442

CR Number:   425442 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 Apr 2006 Fixed 05 Apr 2006 Fixed 10 May 2006 Fixed 21 May 2006 Fixed Description Incorrect percentages may be reported while dumping a database.

CR:425446

CR Number:   425446 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2006 Fixed 19 Sep 2006 Fixed 27 Mar 2006 Fixed Description Failure attaching to shared memory when Monitor Server & ASE are started from different Terminal Server sessions.

CR:425471

CR Number:   425471 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) 21 Aug 2006 Fixed Description Enable LOAD TRANSACTION on an archive database.

CR:425482

CR Number:   425482 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) 30 Mar 2006 Fixed Description The message "current process ... infected with 11" may be reported in the error log in module "ind_dbinfologspacevalid" when the LCT_ADMIN built-in is executed with option "logsegment_freepages" on a temporary database that has not fully recovered yet. The modules "th_lct_admin" and "th__logsegment_freepages" will also be reported in the stack trace.

CR:425509

CR Number:   425509 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) 07 May 2006 Fixed Description Resize all of the unstandard icons to standard icons

CR:425574

CR Number:   425574 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) 31 Mar 2006 Fixed Description The server may raise error 702 while running a large union query and "statistic time" option is set to on. Workaround Description  If the 'statistics time' is set off, the 'union all' query works fine against the latest 150

CR:425664

CR Number:   425664 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2006 Fixed 30 Mar 2006 Fixed 03 Apr 2006 Fixed Description When a shared memory dump is performed on the Linux platform using the CSMD facility a message saying that "at least one engine failed to halt" may be written to the errorlog. This problem has been corrected.

CR:425693

CR Number:   425693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2006 Fixed Description In rare circumstances, on a multi-engine system, the message "current process infected with 11" together with a stack trace in ubffree may be reported in the error log while loading java classes.

CR:425696

CR Number:   425696 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) 31 Mar 2006 Fixed 20 Apr 2006 Fixed Description Use of the dataserver -k command line option incorrectly generates a usage error message and prevents ASE startup from proceeding. Workaround Description  To set the adaptive server principal name for kerberos, set environment variable SYBASE_PRINCIPAL to the principal name, instead of using the -k command line option.

CR:425697

CR Number:   425697 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) 04 Jul 2007 Fixed 28 Jan 2008 Fixed Description The command QUIESCE DATABASE FOR EXTERNAL dump can get a deadlock while creating the manifest file with a process that holds a lock on a system table or the log semaphore and it's suspended because it tried to write to the database being quiesced.

CR:425855

CR Number:   425855 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   HP-UNIX Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2007 Fixed 04 Oct 2007 Fixed 04 Oct 2007 Fixed Description Database dumps taken on HP Tru64 platform using Backup Server of version 12.5.3 ESD#3 or earlier can not be loaded to other platforms with later versions. The fix is enabled with Backup Server traceflag D128.

CR:425865

CR Number:   425865 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) 05 Jun 2006 Insufficient priority to fix Description ASE Plug-in now adds log entries to Sybase Central Log Viewer when Unified-Agent-monitored ASEs under server groups go start/stop running. To open Log Viewer, select Tools -> "Log Viewer".

CR:425923

CR Number:   425923 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) 13 Sep 2006 Fixed Description An ASE stacktrace containing the modules ubo_object_from_slot and mda_get_kpid_by_spid would be generated with the error message "An internal memory management error has occured." if the monitoring table monLocks was queried with a where clause involving a search on SPID and the SPID value was 0 or negative, e.g. "select * from monLocks where SPID = 0"

CR:425945

CR Number:   425945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2006 Fixed 14 Aug 2006 Fixed Description On IBM AIX 5.1, when ASE tries to allocate shared memory larger than 16G, the error message "kernel os_find_good_keyfile: Found shared memory segment: key 0xce0013ac, id 1048593 kernel os_find_good_keyfile: If SQL Server using it is not running, remove it by hand kernel os_find_good_keyfile: Too many dangling memory segments, nead a clean up kernel kbcreate: couldn't get shmid for kernel region. kernel kistartup: could not create shared memory" may be reported in the error log.

CR:426058

CR Number:   426058 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) 31 Oct 2006 Fixed Description Enable the JMS message property "msgreplytoinfo".

CR:426064

CR Number:   426064 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 Oct 2006 Fixed 25 Oct 2006 Fixed Description Enable the JMS message property "ttl".

CR:426073

CR Number:   426073 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2006 Fixed Description Wrong scalar aggregate (such as count()) result when all partitions in the underlying table have been eliminated during compilation.

CR:426097

CR Number:   426097 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) 31 Mar 2006 Fixed 31 Mar 2006 Fixed Description Queries that have a large number of joining tables and also contain subqueries in the SELECT and the FROM clause can result in a stack trace if the opimizer times out before getting a valid plan.

CR:426106

CR Number:   426106 Product Name:   ASE Replicator Product Component:   DDBAdmin Status:   Closed OS:   Generic Original Version:   12.5.3.303 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4.306 04 Apr 2006 Fixed 15.0.1.411P2 21 Apr 2006 Fixed Description ASE REPLICATOR: Incorrect use of single quotes in generating a RAISERROR statement in the script following out of sp_addreplicateart.

CR:426113

CR Number:   426113 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2006 Fixed Description Values in the column TotalSizeKB for the monCachedObject monitoring table were not always correctly calculated.

CR:426201

CR Number:   426201 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) 14 Apr 2006 Fixed Description An INSERT SELECT ORDER BY query could require a Sort and run thus very slowly despite the needed ordering being cheaply available form the existing indices.

CR:426275

CR Number:   426275 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) 27 Oct 2006 Fixed 30 Oct 2006 Fixed Description Previously Connect dialog's Server name drop down list would not update after user changed the LDAP setting (Settings button -> LDAP page). This has been corrected.

CR:426278

CR Number:   426278 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) 17 Apr 2006 Fixed Description To add/edit a JINI server discovery entry, ASE Plug-in now uses a spin box (instead of a text box) for accepting the port number of the entry.

CR:426281

CR Number:   426281 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) 12 Apr 2006 Fixed 09 Jul 2012 Insufficient priority to fix Description Previously Connect dialog displayed error message ID instead of the error message when server discovery through "Find..." returned no results. This has been corrected.

CR:426283

CR Number:   426283 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) 19 Apr 2006 Fixed Description ASEPlugin used to wait for acquiring connection when connected to a standard port (like telnet=23), sometimes it would be around 15minutes, causing ASEP to hang. This fix adds a user settable parameter in ASEP->Settings Tab, to control the login timeout period. By default it is 30secs.

CR:426292

CR Number:   426292 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2006 Fixed Description Document difference between reserved_pgs() & reserved_pages()

CR:426341

CR Number:   426341 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2006 Fixed 04 Apr 2006 Fixed 03 Apr 2006 Fixed Description On some platforms (like Windows), the "upgrade" utility program might terminate abnormally with a segmentation violation or access violation if the program failed to execute an upgrade step correctly. Workaround Description  N/A

CR:426342

CR Number:   426342 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) 15 Apr 2006 Fixed 26 Apr 2006 Duplicate 30 May 2006 Fixed Description DBCC CHECKTABLE may report error 15080, reporting an inconsistency in the root key information on BTree root pages of DOL tables. This will occur if an ALTER TABLE operation was performed on a DOL table to increase the length of a variable length column, and that column was used in some index. If this inconsistency is reported on a system catalog, use DBCC REINDEX to rebuild the specific index showing this inconsistency. For user tables exhibiting this condition, drop and recreate the affected index.

CR:426403

CR Number:   426403 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Windows XP Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2006 Fixed 18 Apr 2006 Fixed 02 Jun 2006 Bundled Request Description In the Syconfig.exe configure new Backupserver options screen, the character set drop down list doesn't contain all valid character sets in non-English language.

CR:426405

CR Number:   426405 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2006 Fixed 03 Apr 2006 Fixed Description ClassCastException is encountered when Table Editor is opened.

CR:426411

CR Number:   426411 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) 10 Apr 2006 Fixed 11 Apr 2006 Fixed 12 Apr 2006 Fixed 14 Apr 2006 Fixed 10 Apr 2006 Fixed 20 Apr 2006 Fixed 20 Apr 2006 Fixed Description MSGCONSUME does not abort the transaction correctly for some RTMS errors, which will cause the consequent stacktrace.

CR:426414

CR Number:   426414 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) 18 May 2006 Fixed Description Built-in attrib_valid returns failure on action modify & delete, irrespective of attribute-value passed.

CR:426482

CR Number:   426482 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) 14 Apr 2006 Fixed 04 May 2006 Fixed 08 May 2006 Fixed Description Attempt to start SySAM License Server using "startd.sh" script produces the following error: "Vendor daemon can't talk to lmgrd (Cannot read data from license server (-16,287:22 "Invalid argument"))". Workaround Description  Execute this before executing lmgrd: ulimit -H -n 1024 Or add this line to a shell script before lmgrd, such as startd.sh, and use script to run lmgrd. The file descriptors needs to be set to 1024. 1) start lmgrd from a /bin/sh script 2) The script should look like: #!/bin/sh ulimit -H -n 1024 lmgrd [...] where [...] is the lmgrd arguments. This resets the limit to 1024 for lmgrd which resolves the problem. Please modify the $SYBASE/SYSAM-1_0/bin/startd.sh by adding a line "ulimit -n 1024" as shown below. [125] % cat startd.sh #!/bin/sh # P1 = component directory ulimit -n 1024 cd $1 $1/bin/lmgrd -c $1/licenses/license.dat -l $1/log/lmgrd.log \ 2 > $1/log/stderr.out &

CR:426533

CR Number:   426533 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2006 Fixed 05 Nov 2006 Fixed 03 Nov 2006 Reservation Made Description During upgrade to 15.0, the HK WASH task may terminate with a message "current process is infected with signal 11" in the module "ind__ides_getnext()" The stack trace may include the modules, open_system_table(), ind_get_ides() and ind__get_sysindrow().

CR:426588

CR Number:   426588 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2006 Fixed 20 Nov 2006 Not reproducible with latest version of the product available as of Resolution Date 26 Sep 2007 Not reproducible with latest version of the product available as of Resolution Date Description CIS: Use of SET ROWCOUNT on query that results in CIS to forward partial command to remote server may return wrong result.

CR:426668

CR Number:   426668 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2006 Fixed 14 Apr 2006 Fixed Description When ASE's license limits the total permitted amount of disk space used for data storage, and a DISK RESIZE command attempts to add space to a device, and the resulting total space is within the permitted limit, ASE will incorrectly report that the named device does not exist.

CR:426674

CR Number:   426674 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) 17 Sep 2007 Fixed Description Sybase Central ASE Plug-in provides the 'Generate DDL' option from the context menu of the following three objects only when the user has sa_role or sso_role - logins, roles and encryption keys. For all other users, this item is disabled.

CR:426791

CR Number:   426791 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2007 Fixed 16 Apr 2008 Fixed 22 Apr 2008 Fixed Description ASE hangs or crashes when 3604 flag is enabled along with 7825, 7826 or 7827 flags.

CR:426828

CR Number:   426828 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   AIX 5.1 Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2006 Fixed Description DDLGen inserts extra white spaces (tabs) in check constraint definition if the length of the definition of a single constraint exceeds 255 characters.

CR:426908

CR Number:   426908 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) 11 Apr 2006 Fixed 10 Apr 2006 Fixed 12 Apr 2006 Fixed 11 Apr 2006 Fixed Description 102 error given for "with override" option for load database on linux 32bit.

CR:426942

CR Number:   426942 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 Nov 2006 Fixed Description Clustered indices for APL tables were being costed more expensively than non-clustered index scans when sargs were being applied to data rows. For the case of non-clustered indices, the benefit of sargs being evaluated in the access layer was costed correctly, but this was not the case for clustered indices. The end result was that a clustered index scan was not usually chosen when strong filtering predicates were applied after a weak limiting scan. The end result is that for APL tables a slower non-clustered index scan could be chosen over a faster clustered index scan.

CR:426982

CR Number:   426982 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2006 Fixed 04 May 2006 Fixed Description A SELECT from a proxy table on ASE 15.0 that is mapped to a remote table on an earlier version of ASE with a name 29 or more characters long will result in an Error Msg 103.

CR:427014

CR Number:   427014 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) 09 Apr 2006 Fixed 03 May 2006 Fixed Description There were some instances when interrupts and kill were not recognized and the query could not be aborted. More checks for interrupts and kill are added during execution of a query.

CR:427028

CR Number:   427028 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) 07 Apr 2006 Fixed 07 Apr 2006 Fixed Description The message "ubo_object_from_slot:Pss Invalid slot id 0" followed by the message "current process ... infected with 11" in module "lock__print_deadlockchain" may be reported in the error log when ASE encounters a deadlock situation and the configuration parameter "print deadlock information" is set or the "deadlock pipe active" MDA option is in use. The modules "pss_getunkept_pss" and "ubo_object_from_slot" will also be reported in the stack trace. Workaround Description  Turn off 1204 or "print deadlock information" or "deadlock pipe active"

CR:427031

CR Number:   427031 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2006 Bundled Request Description ASE Plug-in does not display partition information of a table for pre 15.0 servers in the 'Partition' tab of table properties.

CR:427127

CR Number:   427127 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2006 Fixed 03 May 2006 Fixed Description SP_SPACEUSED <table_name> may report an innacurate value for "rowtotal" if the given table resides in a temporary database. Workaround Description  update stats, dbcc checktable

CR:427166

CR Number:   427166 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) 13 Apr 2006 Fixed 10 May 2006 Not reproducible with latest version of the product available as of Resolution Date Description The SP_CONFIGURE stored procedure trying to change both the 'default sortorder id' and 'default character set id' may not work correctly if the old and new values for first parameter in sp_configure are same.

CR:427193

CR Number:   427193 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) 11 Apr 2006 Fixed Description sp_dboption fails with an error message "Cannot checkpoint database <db_name> because its status is: offline, online for standby access, read only." if the database is set to readonly and an upgrade of the database that was loaded from pre-15.0 version of ASE has not happened yet.

CR:427320

CR Number:   427320 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) 09 May 2006 Insufficient priority to fix Description Enhance dbcc tablealloc to clean up checkstorage 100025 faults.

CR:427446

CR Number:   427446 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2006 Fixed 15 May 2006 Fixed 26 Apr 2006 Fixed Description Signal handling for Mac OS X server process was not resetting signal mask, resulting in a 'frozen server' after first signal (SIGSEGV, SIGBUS, etc.) was encountered. No recovery of this situation was possible, other than killing the process and restarting the server.

CR:427482

CR Number:   427482 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   11.5.1.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2006 Fixed Description Resource Governor fails to kill process that exceed their allotted time when running in parallel Workaround Description  Do not run queries in parallel mode. Manually kill offending process.

CR:427509

CR Number:   427509 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Oct 2006 Fixed Description Previously DDLGen did not use to generate "If exists" statement, this used to generate sql exceptions when someone used to run ddlgen output against a server where objects already existed. This fix now adds "if/exists clause", and the object if already exists is dropped, before creating a new definition.

CR:427590

CR Number:   427590 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) 13 Apr 2006 Fixed Description The error " Syntax error encountered. Sizes must be of the form int[KMGP]. For example, a size of 5 megabytes may be specified as '5M'." will be generated if in the SP_CONFIGURE command both "default character set id" and "default sortorder_id" are changed together and second argument is 0.

CR:427668

CR Number:   427668 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2006 Fixed 08 Jun 2006 Fixed Description The value of the monProcessActivity table CPUTime column is occassionally reset to zero. As a result, this column may not report the cumulative CPU time for a process.

CR:427705

CR Number:   427705 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2006 Fixed 10 Jul 2006 One-off Provided Description Under certain circumstrances, When ASE is configured to use JVM( enable java set to 1) error Memory allocation request failed because of insufficient memory in Jvm Shared Class appears in errorlog. ASE may get infected with SIGSEGV and throws stack trace in VMClassLoader::Destroy.

CR:427884

CR Number:   427884 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) 28 Apr 2006 Fixed 15 Jun 2006 Fixed Description The store index operator used in the reformatting strategy did not have the join keys created properly, so that instead of a nested loop keyed lookup, a cart prod was performed, although the costing expected that a keyed lookup would be done. This resulted poor performance when expressions were used in a join, which used a reformatting strategy.

CR:427888

CR Number:   427888 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) 24 Apr 2006 Fixed 12 May 2006 Fixed Description Error 2823 "Process x tried to remove a PROC_BUF 0xxxxxx name '*ssxxxxxxxxxxx'.." maybe produced when two sessions execute the same SQL in an ASE where "statement cache" is enabled.

CR:427908

CR Number:   427908 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) 26 Apr 2006 Fixed Description Transient I/O issue could cause timestamp mismatch error (12315) during btree scan.

CR:427929

CR Number:   427929 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) 14 May 2006 Fixed 15 May 2006 Fixed 22 Jun 2006 Fixed 12 Sep 2006 Deferred Description Enhance the alter table utility to avoid taking table locks on system catalogs.

CR:428057

CR Number:   428057 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) 01 Jun 2006 Fixed Description Connection time averages for LDAPUA are printed under traceflag(3637) instead of (3635).

CR:428062

CR Number:   428062 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) 27 Apr 2006 Fixed 04 May 2006 Fixed Description DB LIB function, dbdatlen(), returns a wrong result with fixed length char column in ASE15

CR:428211

CR Number:   428211 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) 04 Jun 2006 Fixed Description drop login/sp_droplogin does not drop local login mappings in sysattributes table, due to which those mappings in the table have references to non-existent users.

CR:428322

CR Number:   428322 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) 23 May 2006 Fixed Description GRANT ALL command inserts rows of Dump Database and Dump Transaction actions into sysprotects table. Workaround Description  It's harmless. Please ignore.

CR:428341

CR Number:   428341 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) 19 Apr 2006 Fixed 11 Oct 2006 Fixed Description When ASE is started with the Express Edition license, it is possible to exceed license limits on total disk space by using the "disk reinit" command.

CR:428358

CR Number:   428358 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) 24 Apr 2006 Fixed 24 Apr 2006 Fixed Description Adaptive Server Enterprise may crash with a stack trace pointing to terminate_process