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

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

CR:346654

CR Number:   346654 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2004 Fixed Description Queries returning TEXT/IMAGE fields and using worktables may not execute correctly giving spurious 605 errors in the temporary database or may fail with stack traces. Stack trace will reference modules like exec_eop,run.

CR:346874

CR Number:   346874 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) 28 Apr 2004 Fixed Description The message "process infected with 11" maybe reported in the errorlog together with a stacktrace which includes the modules 'sendtext' and 'run' if a SELECT using ISOLATION LEVEL 0 selects from text/image columns and other users are updating these text/image columns at the same time.

CR:346884

CR Number:   346884 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2004 Fixed Description The monOpenObjectActivity table contains rows for objects besides user tables and indexes. These rows have zero value columns because monitoring data is not collected for other object types. These rows should be removed from the table, and only rows for user tables and indexes should be reported. Also, the date columns should be reported as NULL rather than zero when not set.

CR:346898

CR Number:   346898 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2006 Fixed Description The monIOQueue monitoring table incorrectly assigned IOs by the system to the 'User Data' row since the table only split IOs by 'User Data' or 'User Log'. System IOs are now assigned to 'System'

CR:346899

CR Number:   346899 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2004 Fixed 14 Aug 2004 Presently Not Targeted For Any Future Release Of This Product Description In rare circumstances, the 1601 error "There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections." may be reported in the errorlog due to upspawn failing with the following message "upspawn: no more process slots available".

CR:346929

CR Number:   346929 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2004 Fixed Description When Job Scheduler processes job output column data that is longer than the output column width, data may be incorrectly repeated on subsequent lines. This has been corrected.

CR:347020

CR Number:   347020 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2004 Fixed Description 'Select Distinct within a subquery may encounter performance degradation if proxy tables are involved.

CR:347030

CR Number:   347030 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2004 Fixed 09 Mar 2004 One-off Provided 12 Mar 2004 Fixed Description Back out xpserver changes made under CR 325777 which results in unexpected behavior of xp_cmdshell. With 325777 changes, xp_cmdshell commands executing a shell command which tries to redirect output to a file using the '>' file I/O redirection does not work as expected. Instead the output is returned to the ASE client. Fix for 325777 will be reworked under 348878.

CR:347061

CR Number:   347061 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2004 Fixed Description srvbuildres should tell user to specify the "force_buildmaster = yes" clause when trying to overwrite an existing master device rather than "-f"

CR:347083

CR Number:   347083 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2006 Fixed Description When a user is granted a role that has been granted the mon_role role and the user executes the 'set role' command to activate the role, the user will not be able to select from MDA tables but will get a 10353 error. Workaround Description  As SA execute sp_modifylogin mark,"add default role",myrole

CR:347084

CR Number:   347084 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2004 Fixed Description The message "current process ... infected with 11" in module 'des_unkeep' may be hit during the execution of SP_RENAME when the given object is not yet cached. The stack trace will also report modules 'exec_dbcc' and 'd_refresh_ides' in the error log. Workaround Description  Have first the descriptor cached via sp_help t1

CR:347090

CR Number:   347090 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) 23 Feb 2004 Fixed Description On alignment-sensitive platforms only, inserting into a unichar column from a varbinary column may generate alignment fault if the UNICHAR data is not aligned on a 2-byte boundary. Workaround Description  In general, no workaround is available. If there are no variable-length or nullable datatypes in a table definition, however, it may be possible to define the table such that unichar data is always aligned on a 2-byte boundary.

CR:347098

CR Number:   347098 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) 29 Apr 2004 Fixed Description The name of a user database is stored with trailing spaces in the VARCHAR-type field name in the systemtable SYSDATABASES when using bracketed indentifiers in the CREATE DATABASE statement like CREATE DATABASE [<dbname><space>...<space>].

CR:347115

CR Number:   347115 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) 26 Feb 2004 Fixed 08 Mar 2004 Presently Not Targeted For Any Future Release Of This Product Description A leading '//' inside predicate should be treated as an absolute path from root. It is not beginning of a path relative to the sub-path preceding the filter.

CR:347134

CR Number:   347134 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation and Configuration Guide-ASE Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2006 Fixed Description Adaptive Server Enterprise Disk I/O Tips Linux supports a variety of file systems such as EXT2, EXT3, and XFS. The recommended file system for Adaptive Server is EXT2 or EXT3 with journaling disabled.

CR:347189

CR Number:   347189 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2004 Fixed Description The message "current process infected with 11" in the module 'parse_name' together with a stack trace which includes the modules 'logcommand' and 'grantrev' may be reported in the errorlog if a table having an identity column is used in a stored procedure together with a GRANT or REVOKE command for that same table and the REPLICATION FORCE_DDL option is set.

CR:347219

CR Number:   347219 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2004 Fixed 17 Jun 2004 Fixed Description Sybmigrate will stop migrating between two servers if the password for the migration login is not identical on both servers. Workaround Description  *** Monday, February 23, 2004 11:40:23 AM *** cooperg *** Use same logins with identical passwords or Run sp_addexternlogin on the source server and create an external login mapping between the 'sa' accounts on the source and target systems.

CR:347247

CR Number:   347247 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Dec 2004 Fixed Description Error 1566 is raised when creating a clustered index even when there are sufficient distinct key values for the number of partitions.

CR:347282

CR Number:   347282 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) 03 Jun 2004 Fixed 10 Jun 2004 Fixed 26 May 2005 Fixed 21 Nov 2005 Fixed 22 Jun 2004 Fixed Description Add support for Korean language using character set cp949. Note that to use this character set in conjunction with eucksc, the sp_configure parameter "size of unilib cache" should be increased to 144384 bytes (or more) and the the sp_configure parameter "enable unicode conversions" should be set to 1. Workaround Description  To use cp949 as a client character set with a utf8 server (or a eucksc server, for that matter), it's possible to use the statement "set char_convert 'cp949'". It's not yet possible to use the -J flag of isql or bcp, nor to configure cp949 as ASE's default character set.

CR:347369

CR Number:   347369 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2004 Fixed Description CIS: Signal 11 stack trace in ct_poll may occur when an insert-select query is interrupted by a killed connection. Workaround Description  No known workaround othere than running the diagserver.

CR:347380

CR Number:   347380 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2004 Fixed 09 Jun 2004 One-off Provided 27 Jun 2004 Fixed Description Msg. 103, "The identifier that starts with '<textpointer>' is too long. Maximum length is 30." is raised when executing the command WRITETEXT BULK <tablename>.<colname> <textpointer> and colname is called "parameter".

CR:347386

CR Number:   347386 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2005 Fixed 02 Dec 2005 Fixed 05 Feb 2006 Fixed 04 Jan 2006 Presently Not Targeted For Any Future Release Of This Product 24 Jul 2006 Fixed 26 Sep 2007 Not reproducible with latest version of the product available as of Resolution Date Description Enabling sort-merge join and parallelism returns duplicate rows when executing a SELECT from a view which comprises of a SELECT DISTINCT from a 2-table join. Workaround Description  having parallelism off the query will return the right result 1> sp_configure "parallel" 2> go Msg 17411, Level 16, State 1: Server 'panther125', Procedure 'sp_configure', Line 209: Configuration option is not unique. Parameter Name Default Memory Used Config Value Run Value Unit Type ------------------------------ ----------- ----------- ------------ ----------- -------------------- ---------- max parallel degree 1 0 1 1 number dynamic max scan parallel degree 1 0 1 1 number dynamic (1 row affected) (return status = 1) 1> > select count(*) from project_cost_element_vw 2> go ----------- 936 (1 row affected)

CR:347439

CR Number:   347439 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2004 Presently Not Targeted For Any Future Release Of This Product 25 Aug 2004 Fixed 05 Oct 2005 Not reproducible with latest version of the product available as of Resolution Date Description Query with equi-sargs predicates and IS NULL can result in poor index selection.

CR:347475

CR Number:   347475 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2004 Fixed Description sp_monitorconfig displays wrong number of pages for "size of process object heap".

CR:347528

CR Number:   347528 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2004 Fixed Description xp_cmdshell should allow commands that exceed 255 characters

CR:347540

CR Number:   347540 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2004 Not reproducible with latest version of the product available as of Resolution Date 28 May 2004 Fixed 05 Mar 2004 Fixed Description optdiag failed to load statistics complaining about db name is not found, this only happens when database conflict is flawed.

CR:347570

CR Number:   347570 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2004 Fixed Description When the sp_configure parameter "enable unicode normalization" is set (as it is by default) and character literals contain Unicode characters requiring normalization, the parser failed to perform the normalization. This was true for literals promoted to the unichar data type, represented using UTF-16, as well as char literals when the server's default character set is configured as UTF-8.

CR:347712

CR Number:   347712 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2004 Bundled Request Description Sybase Central ASEplugin: 'Generate DDL' of stored procs against V12.0 server thows error: CO55 The specified Compiled Object Item not found in the Server: <sproc_name>. Workaround Description  Can use ddlgen instead.

CR:347726

CR Number:   347726 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.8 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2004 Fixed 05 May 2004 Fixed Description In rare circumstances, the error 1292 "Internal Error in lock manager ..." may be raised when a query that involves system tables and builtins is run in parallel mode, as opposed to serial, and the system builtin execution results in the caching of a user object's descriptor. Workaround Description  Put first in temp tables the needed data and then apply the system builtins, or disable parallelism.

CR:347753

CR Number:   347753 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2004 Fixed Description Enhanced diagnostics for access violation errors.

CR:347795

CR Number:   347795 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2005 Fixed Description inclusion of read only cursors for sort merge joins.

CR:347811

CR Number:   347811 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2005 Presently Not Targeted For Any Future Release Of This Product 21 Nov 2005 Fixed Description The 'ascinserts' property of a table, that earlier used to be set by a call to dbcc tune(), can now be set via stored procedure 'sp_chgattribute'.

CR:347817

CR Number:   347817 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2004 Not reproducible with latest version of the product available as of Resolution Date 15 Jun 2004 Fixed Description In very rare cases, on windows XP platform, boot recovery could run into system exception when trying to print out the buffer pool tuning messages.

CR:347837

CR Number:   347837 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2006 Fixed 24 Oct 2006 Fixed Description Fixed the return type java.lang.string for build-in function msgproplist.

CR:347891

CR Number:   347891 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2004 Fixed 25 Mar 2004 Fixed Description CIS: The message "current process infected with 11" in the module 'investigate_ojs' together with a stack trace which includes the modules 'omni_get_ojrelops' and 'omni_findjoins' may be reported in the error log if a query with UNION and ANSI join involves proxy tables. Workaround Description  Use T-SQL JOIN as in the OK query in repro or use traceflag 11216 or 11217

CR:347936

CR Number:   347936 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2006 Deferred Description The "Total Actual I/O cost" output by showplan is inaccurately low for query statements that contain multiple main steps, such as UNION statements. Workaround Description  You can compute the total actual I/O cost using the following formula: (sum(total logical I/Os for each table)* 2) + (sum(total physical I/Os for each table) * 18)

CR:347941

CR Number:   347941 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhance srvbuild character set and sort order pulldown menus to list id numbers as well as descriptions

CR:347963

CR Number:   347963 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Custumer will like to have a way to track the usage of disk space by individual login or spid. Customer would like to have this in the monitor tables.

CR:348049

CR Number:   348049 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2004 Fixed Description In rare circumstances, a 691 error, "Encountered invalid logical page '0' while accessing object '8' in database '<dbid>'" may be reported during boottime or LOAD DATABASE recovery. Workaround Description  None

CR:348098

CR Number:   348098 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2004 Fixed Description Set default focus in the first text field on a wizard page when the page is first activated.

CR:348123

CR Number:   348123 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2006 Fixed Description Mount/Umount Database improvements

CR:348134

CR Number:   348134 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2004 Fixed Description There are now a new set of bourne shell scripts for the user to use and the cshell scripts have been renamed to have a .csh extension. Also the directory structure for JS-12_5 has been simplified. There is no change in functionality due to this change.

CR:348235

CR Number:   348235 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) 20 Apr 2004 Fixed Description HA on Sun may not work properly due to utils.ksh script picking up the primary ASE run file for the secondary ASE.

CR:348240

CR Number:   348240 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2004 Fixed Description A stacktrace including the modules open_fail_error, getuidfromsuid() and prot_srch_and_check_for_dbcc() may be printed in the errorlog, if a non-sa user tries to execute a database level dbcc command in a database that is not usable.

CR:348331

CR Number:   348331 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) 26 Apr 2004 Fixed Description The error 926, followed by error 12324 and a stack trace that includes the module checkstorage will be raised when running DBCC CHECKSTORAGE on a database that is marked suspect. Similar errors and stack traces are seen if the database is unavaliable for some other reasons.

CR:348346

CR Number:   348346 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Library Status:   Closed OS:   Unknown Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2004 Fixed Description missing makefiles on some platforms for MCL sample programs

CR:348347

CR Number:   348347 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2004 Fixed Description The charset program prompts for confirmation of a update to a character set or sort order definition if such a definition is already installed in the server. The program loops until a valid yes/no response is received from its standard input. EOF is not considered a valid response, and will trigger an indefinite loop.

CR:348372

CR Number:   348372 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2004 Fixed 01 Nov 2004 Deferred Description The performance of the parse and compile phase for a large SQL batch has been improved. Further performance improvements may be achieved with the 702 boot time trace flag though this comes with an additional 2% per-batch memory cost.

CR:348384

CR Number:   348384 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) 13 May 2004 Fixed 04 Feb 2006 Fixed Description The error 1505, "Create unique index aborted on duplicate key. Primary key is '<value>'" may report an incorrect key value if the index is created in parallel mode as opposed to serial. Workaround Description  CREATE INDEX WITH CONSUMERS=1

CR:348390

CR Number:   348390 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) 19 Apr 2004 Fixed Description If a row level access rule containing multiple AND qualifiers is attached to a table involved in an outer-join query it may generate incorrect results.

CR:348404

CR Number:   348404 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) 01 Nov 2004 Fixed Description The object information printed in sp_object_stats is truncated when the name of the database, the name of the object and some detailed object info is greather than 80 characters. Workaround Description  The workaround is to modify sp_object_stats for variable @rpt_line with bigger length.

CR:348468

CR Number:   348468 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2009 Insufficient priority to fix Description In ASE 12.5.0.3 and before, the command 'sp_cacheconfig <cachename>, "cache_partition=<number>"' processed a change that went into effect when the server was rebooted. In ASE 12.5.1, running the same command returns messages (Msg 10850 and 10875, both undocumented) that make it appear that it doesn't work. What is happening is a confusion between what ASE 12.5.1 can do dynamically, and what it does do statically DESPITE the messages. We need to make message changes.

CR:348513

CR Number:   348513 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2004 Fixed 03 May 2004 Fixed 28 Aug 2004 Fixed 31 Aug 2004 Fixed 28 Sep 2004 Fixed Description Enhance DBCC CHECKTABLE for empty ALLPAGES LOCKED tables to report error if the root page of the index has extraneous entries even though the table is empty.

CR:348534

CR Number:   348534 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2004 Fixed Description In a server with Case-insensitive sort order, a SELECT can use the same column more than ones with different case (ex: Col, coL), but the header of the result set is the same for the columns. Workaround Description  specify a label for the default column heading 1> select nAme as "nAme" from sysobjects o 2> where exists (select 1 from syslogins where o.NaME = "sp_configure") 3> go

CR:348573

CR Number:   348573 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) 05 Jul 2004 Fixed Description The value of @@rowcount is reset when a a stored procedure or trigger is recompiled.

CR:348590

CR Number:   348590 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2004 Fixed 14 May 2004 Fixed 02 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date Description The message "current process infected with 11" in the module 'q_alloc_restart' together with a stack trace which includes the modules 'q_oreop_fill' and 'substitute' may be reported in the error log for an query at isolation level 0 that includes a HAVING clause with an OR. Workaround Description  Use 'where' clause instead of 'groupby having in'

CR:348674

CR Number:   348674 Product Name:   Adaptive Server Enterprise Product Component:   langinstall Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2004 Fixed 14 Jun 2004 Fixed 22 Jun 2004 Fixed Description When installing a language other than English, message number 19178 in the different language cannot be installed.

CR:348686

CR Number:   348686 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2004 Bundled Request Description ASE 12.5.1 on Red Hat Linux AS 2.1 core dumps when 'max memory' is set to greater than 2.75GB. Workaround Description  Right now there is now way to achieve > 2.7 gb of max memory on Linux.

CR:348693

CR Number:   348693 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) 12 Aug 2004 Fixed Description HA Scripts are updated to use specific options to get the command name from the /usr/bin/ps command Workaround Description  Hardcode the value in the script as it is unlikely that a process will get the same process id in the .krg file of dataserver. from utils.ksh (is_ase_running) : # 5th column of /usr/ucb/ps output is full path command name. Extract # just the command name from it and check for "dataserver" str=`print $ps_out | nawk '{print $5}'` log_callback_msg -dim "Command name from ps output is: $str" str=`basename $str` str="dataserver" <------ Added line if [[ "$str" != "dataserver" ]]; then

CR:348732

CR Number:   348732 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2004 Fixed Description Added support for SELECT INTO/INSERT INTO to insert from a materialized UNION ALL containing text/image columns.

CR:348743

CR Number:   348743 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) 25 Aug 2008 Fixed Description New Feature: Java in ASE to support java.security package.

CR:348866

CR Number:   348866 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2014 Insufficient priority to fix 16 Mar 2010 EOL'd version. Not to be Fixed. Description Cust would like to be able to take samples like they can do this with sp_sysmon and reset monitoring counters to 0 as needed.

CR:348878

CR Number:   348878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2004 Fixed 04 May 2004 Fixed Description An attempt to run an interactive program under xp_cmdshell may hang the xpserver.

CR:348881

CR Number:   348881 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2004 Fixed Description Increase output filename length in historical server

CR:348895

CR Number:   348895 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2004 Fixed Description Outer join with a VIEW having UNION ALL fails with error 11054 : "The table 'table name' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause."

CR:348971

CR Number:   348971 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2005 Fixed 24 Jun 2005 Fixed 07 Jul 2005 Fixed 21 Jul 2005 Fixed Description When the SELECT * is expanded while storing the text of a stored procedure, identifiers consisting of multiple parts will be stored in syscomments using bracketed identifiers. For example a columnname like <colname_part1 part2> is stored like [colname_part1 part2]. The same will happen for table-names consisting of multiple parts.

CR:349033

CR Number:   349033 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   HP-UX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2004 Fixed 06 Aug 2004 Bundled Request Description sybmigrate may fail to migrate a table that was created by a user other than dbo.

CR:349165

CR Number:   349165 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2004 One-off Provided Description INSTRUMENTATION: ASE disappears without any message in the errorlog resulting in a core dump. Core file indicates that thread library function pthread_sighandler_rt() encountered Signal 11 due to corrupted memory address for thread handle.

CR:349194

CR Number:   349194 Product Name:   Adaptive Server Enterprise Product Component:   DBXray Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined 12 Mar 2004 Fixed Description DBXray needs to provide support for Linux

CR:349240

CR Number:   349240 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2004 Fixed Description When a wizard page or properties page is active, the focus should be set to the first text field. This makes it easy to enter text without using the mouse to focus first.

CR:349251

CR Number:   349251 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2005 Presently Not Targeted For Any Future Release Of This Product 18 May 2004 Fixed Description When a single long transaction is aborted in a primary database because it has filled up the log, replication agent is not able to move the secondary truncation point, even if all transactions have been processed by replication agent. Workaround Description  alter the log with more space until adequate space is created.

CR:349279

CR Number:   349279 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2004 Fixed Description ASE incorrectly handles user defined execution classes whose names begin with "EC0", "EC1", "EC2", or "EC3". In these cases ASE will apply the system defined attributes for the user defined execution class rather than the user defined attributes. Workaround Description  Avoid execution class names that begin with EC0, EC1, EC2, or EC3

CR:349286

CR Number:   349286 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2004 Fixed Description Conversions from other datatypes (notably varbinary) to unichar/univarchar will cause a process to terminate with a stack trace if the source data is not aligned on a data page.

CR:349337

CR Number:   349337 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2004 Fixed Description Makefile for sample xp_echo on the windows platform does not have include paths set.

CR:349420

CR Number:   349420 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2004 Fixed Description The sybatch.exe sample resource file "sybatch_sample.res" has incorrect values in "msrv.network_hostname_list" and "bsrv.network_hostname_list" attributes.

CR:349434

CR Number:   349434 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2004 Fixed Description A spinlock order violation and ASE panic occurs upon first kerberos login and recovery or other highly concurrent activity is also running. Invalid spinlock sanity checks are avoided with this fix.

CR:349480

CR Number:   349480 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2005 Fixed 14 May 2007 One-off Provided 07 Oct 2007 Fixed Description The message "current process infected with 11" in the module 'oj_syboj_markojonclause' may be reported in the error log when executing a SELECT with invalid cyclic outerjoin. Review Status  An illegal outer join query may result in an infected with 11 with aa stacktrace containing function call oj_syboj_markojonclause rather than raising an appropriate error message.

CR:349567

CR Number:   349567 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2004 Fixed Description CIS: stacktrace in omni_plan_subst() when selecting a text/image column from a proxy table using an order by clause whereby the column used for ordering is not in the select list.

CR:349670

CR Number:   349670 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2004 Fixed Description If a master database is loaded onto a master device whose size is not the same as that shown in the dump, the correct size is replaced by the size contained in the dump. The device's previous size should be retained after the load completes. Workaround Description  Workaround 1: run "disk resize" on master db. CAUTION: using this method, there must not be any databases already existing in the parts of the master device that will be affected by the resize operation, because those pages will be cleared. Workaround 2: allow updates to system tables; update sysdevices to show correct "high" value for master device; disallow updates to system tables. If there were any existing databases in the affected areas of the master device, run "disk refit".

CR:349693

CR Number:   349693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2004 Fixed 25 Jun 2004 Fixed Description The message, "current process infected with 11" in the module 'copyconstant' together with a stack trace which includes the modules 'q_norm_const' and 'decision' may be reported in the error log if a SELECT with two or more aggregates has a WHERE clause on a text constant of more the 450 characters. Workaround Description  The where clause of the repro does not make sense, we compare a char(5) with a string of about 500 characters. The problem does not happen with a 12.0.x server when the string is less than 450 characters. For 125, this does not happen when the string in less than 16 K.

CR:349701

CR Number:   349701 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2004 Fixed Description syconfig/srvbuild[res] allows users to create >32GB master device

CR:349724

CR Number:   349724 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2004 Presently Not Targeted For Any Future Release Of This Product Description Feature request: traceflag to enable statistics for out of range equi-sargs.

CR:349735

CR Number:   349735 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2004 Fixed 15 Jun 2005 EOL'd version. Not to be Fixed. 10 Nov 2004 Fixed 10 Nov 2004 Fixed Description When server's default character set is GB18030, timeslice error occurs when converting Unicode surrogates to GB18030.

CR:349774

CR Number:   349774 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2012 Duplicate Description Feature request: add a "Materialized View" feature as in Oracle.

CR:349790

CR Number:   349790 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2004 Fixed Description CIS : Execution of multiple Extended Stored Procedures might result in performance improvement due to an efficient connection establishment model when routed through CIS RPC mechanism after both 'cis rpc handling' and 'negotiated logins' options are turned on. Workaround Description  Purchase an Open Server license and use cis rpc handling

CR:349883

CR Number:   349883 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2004 Fixed Description The SQL batch identifiers reported by monDeadLock (HeldBatchID) and monSysSQLText (BatchID) do not match. This makes it impossible to join these tables to get the SQL Text of the processes involved in the deadlock.

CR:349964

CR Number:   349964 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) 20 Apr 2004 Fixed 29 Apr 2004 Fixed Description The process of serialize/deserialize java objects in ASE can cause some performance issues in a multi-session environment.

CR:350098

CR Number:   350098 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2004 Fixed Description If for any reason dbcc checkstorage() cannot access the database being checked, it continues processing anyway. This causes many spurious error messages to be printed.

CR:350109

CR Number:   350109 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2004 Fixed Description This fixes a straggle problem not caught by CR 348687-1. For the user: In 12.5.1, the job timeout property was labelled to be in seconds. This value was actually treated as minutes. This fix changes the labels for the timeout property to say minutes in 12.5.2.

CR:350211

CR Number:   350211 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2005 Fixed 22 Jun 2005 Fixed Description Jobs attached to repeating schedules with a 0 interval run multiple times when the schedule start time arrives. Workaround Description  *** Monday, January 31, 2004 *** mmorriso *** Based on Chris' analysis (see resolution 1), the following will prevent this problem until the GUI and stored procs can be changed to prevent the user from creating a recurring job without setting any recurrency constaints. If the user selects the Between start time option, a recurrence option must be selected. If the user doesn't want one of the recurrence options, select the At start time option. *** Tuesday, March 23, 2004 10:16:11 AM *** cooperg *** Creating the Job first appears to work in my testing.

CR:350291

CR Number:   350291 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2005 Fixed Description sp_syntax does not include mount/unmount command help Workaround Description  Add the following to ins_syn_sql script, manually: exec insert_syntax 'mount', 'Transact-SQL', 1 , 'mount - Use the mount command to attach the database to the destination' go exec insert_syntax 'mount', 'Transact-SQL', 2 , 'or secondary Adaptive Server.' go exec insert_syntax 'mount', 'Transact-SQL', 3 , 'mount database all from <manifest file> [with listonly]' go exec insert_syntax 'unmount', 'Transact-SQL', 1 , 'unmount - unmount command shuts down the database and drops it' go exec insert_syntax 'unmount', 'Transact-SQL', 2 , 'from the Adaptive Server. Devices are also deactivated and dropped.' go exec insert_syntax 'unmount', 'Transact-SQL', 3 , 'unmount database <dbname list> to <manifest file>' go

CR:350352

CR Number:   350352 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2004 Third Party Problem Description CIS transmits bulk copy data in suboptimally sized packets Workaround Description  BCP data out to a flat file and then bcp back in to the remote server.

CR:350392

CR Number:   350392 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) 11 Apr 2004 Presently Not Targeted For Any Future Release Of This Product 08 Apr 2004 Fixed 14 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date Description This CR disables change made by 319389 (A sub-optimal query plan may be generated for queries using MAX() or MIN() together with WHERE clauses that involve OR clauses.). Use trace flag 4110 to enable fix for 319389. Workaround Description  *** Wednesday, March 24, 2004 10:58:01 AM *** cooperg *** Backout fix for 319389 which will break other customers. Not a good idea. If fix involved just special OR (eg in clause or sargs like c1 = 5 or c1 = 10) then enable tf 304 to turn off special OR for this query.

CR:350475

CR Number:   350475 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) 09 Aug 2004 Fixed Description The error 7156 together with a stack trace that includes the modules textconvert and txt_readchar, may be raised when trying to convert a text column to any other datatype, if the text page was created in a version prior to 12.5. Workaround Description  We can fix this problem by using the following ways. 1) Use dbcc rebuild_text dbcc rebuild_text will not change txtoff_high and txtoff_low. dbcc rebuild_text updates timestamp of page header and then ASE can recognize the text page is the latest. That means that ASE no longer needs calling txt__get_col(). As a result, we can prevent error 7156. 2) Drop and recreate the table and then run bcp in with extraced data. Or use select into.

CR:350523

CR Number:   350523 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2005 Presently Not Targeted For Any Future Release Of This Product 30 Apr 2004 Fixed Description DATE and TIME datatype columns with a CONVERT builtin on proxy_table mapped to DCO will not work.

CR:350550

CR Number:   350550 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2004 Fixed Description When a statement that has been successfully cached is followed by successive normalization errors a stack trace may happen. This occurs only with the statement cache enabled.

CR:350563

CR Number:   350563 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2009 Insufficient priority to fix Description substring and pagesize in same query and particular order returns pagesize as NULL on windows and linux, whereas causes a stacktrace on solaris. Workaround Description  In the query select pagesize first and then substring the column name.

CR:350567

CR Number:   350567 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) 10 Aug 2004 Fixed 07 Oct 2004 Fixed Description When a database is not useable, the command checkpoint [db |all] fails silently.

CR:350576

CR Number:   350576 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2004 Fixed Description Msg 207, "Invalid column name <column name>" is raised when executing a SELECT with a subquery in the select-list which is referencing a column defined in the derived column list of a derived table expression in the FROM clause.

CR:350581

CR Number:   350581 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2004 Not a Bug Description The sp_monitorconfig 'number of locks' report does not show correct "active" value. "HWM" may also be incorrect, but harder to prove. In a completely idle system, sp_monitorconfig will still show some number of active locks.