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

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

CR:291203

CR Number:   291203 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2002 Fixed 08 Oct 2002 Fixed Description A subquery that is executed with a flattening technique using unique reformatting may return duplicate rows if the select list for the inner query includes a non-correlated column. Workaround Description  Workaround: (1) use trace 328 to disable reformatting. (2) do not include columns in the subquery that are redundant or use a select * (3)create appropriate indexes so reformatting is avoided (4)set forceplan on

CR:291208

CR Number:   291208 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2002 Fixed Description When trace flag 2402 is used together with "enable unicode conversion" set to 0, dynamic SQL fails with error 2402 when converting Hankaku Katakana characters from sjis to eucjis. Workaround Description  enable unicode conversions = 2. However , this is NOT a real workaround since this will cause CR 291124.

CR:291221

CR Number:   291221 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2004 Fixed Description If a view contains a subquery in its target list and the view's subquery is then used in a compute clause, then a stacktrace (signal 11) may occur. This has been fixed. Note that using a subquery directly in a compute clause is not allowed. Workaround Description  None found

CR:291279

CR Number:   291279 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2002 Fixed Description On IBM AIX platform, attempt to mirror a freshly created master device using the command "disk mirror name = master, mirror = <mirror device path>" may fail with error 5137 "Dynamic mirroring failed for logical device 'master'. Check the SQL Server error log for more information". ASE kernel reports "sddone: read error on virtual disk 0 block 0: not within virtual disk range, start bn = 2 Closing the secondary device for virtual device master" in errorlog. Workaround Description  Create dummy database(s) to completely fill master device before mirroring it.

CR:291304

CR Number:   291304 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2002 Fixed Description When a SJIS client connects to a EUCJIS server with Unicode conversion enabled, error 2402 is raised if character data contains roman numerals.

CR:291354

CR Number:   291354 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2002 Fixed 05 Feb 2003 Fixed Description In certain circumstances, an 803 error, "Unable to place buffer '<address>' from cache '<cachename>' holding logical page '<pageno>' in sdes for object '<objname>' ..." may be reported when executing a cursor FETCH AT ISOLATION LEVEL 0 and there is a lot of concurrent DML activity on the server.

CR:291383

CR Number:   291383 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2002 Fixed Description CIS: Execution of the UPDATE query with a join between local and proxy tables, and a huge outer table is slow.

CR:291395

CR Number:   291395 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2003 Not a Bug Description Views containing a string operation are always materialized when one of the view's columns is the inner member of an outerjoin. Reviewed Nov 2002. Fix is targeted (but not committed) for the 12.5.1 or 15.0 release.

CR:291478

CR Number:   291478 Product Name:   ASE Replicator Product Component:   Doc Status:   Closed OS:   Generic Original Version:   12.5.0.103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.109P6 16 May 2003 Fixed 15.0.0.400 19 Aug 2005 Fixed Description Went out to mysybase and searched the ebf letter for the 10349 jConnect EBF and found the following in http://download.sybase.com/swd/3172/EBF10349.txt: 10106 270704 jConnect now kills the connection when the server's default charset is unsupported in Java (and the client has not made a specific request for a charset). When the client does not request a specific charset, jConnect will attempt to use the server's default charset. However, there are cases where the server charset does not map to Java (because there is no corresponding converter in Java -- an example would be the roman8 charset). Previously, jConnect would allow the Connection to be made, but the connection would be unusable, as all further communications with the server would result in an exception. jConnect now throws at JZ0IB exception and does not allow the connection to be made. This problem is not an ASE Replicator problem, but rather a jConnect/Java/roman8 problem.

CR:291577

CR Number:   291577 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2002 Fixed 28 Aug 2002 Fixed Description Table columns and stored procedure parameters may be out of order for NCHAR and NVARCHAR data types in the output of sp_help.

CR:291590

CR Number:   291590 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Unknown Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2002 Fixed 06 Mar 2003 Fixed Description CIS: The message "current process infected with 11" in any of the modules 'omni_sync_remdbname', 'omni_create_existing', 'scan_results_subst', 'scan_from_clause', 'syb10_dynamic_prepare', 'syb10_prepare_bulk' or 'syb_build_insert', together with a stack trace may be reported in the error log when a client process exits abnormally, or a network error is encountered.

CR:291751

CR Number:   291751 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2003 Fixed Description cursor updateof a textcolumnin a proxy table fails with error "137, Mustdeclarevariable <name>"

CR:291762

CR Number:   291762 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2002 Fixed 06 Feb 2003 Fixed 27 Feb 2003 Fixed Description The external DLL file name and not the entire SQL statement used to create an extended stored procedure is being stored in syscomments. This fix is enabled only by starting Adaptive Server with the 2001 trace flag.

CR:291766

CR Number:   291766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2007 Duplicate Description Request for a WITH RENORMALIZE option to CREATE PROC and EXEC PROC that would cause the procedure to renormalize its object references. If a procedure refers to a table_a, and table_a is renamed to table_b, the procedure will currently continue to reference the contents of table_b even if a new table_a is created (if the procedure is dropped and recreated, or the original table is dropped, then it will start refering to the new table_a). If the RENORMALIZE option was used, the procedure would start referencing the new table_a. Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

CR:291801

CR Number:   291801 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2003 Fixed Description On ASE 12.5.x, explain what sp_monitorconfig "txn to pss ratio" returns in the reference manuals, usibg an example. Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

CR:291814

CR Number:   291814 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Nov 2002 Presently Not Targeted For Any Future Release Of This Product Description Feature request for a utility to upgrade a configuration file from a source to a target when the databases of the source are upgraded by dumping and loading into the target. Reviewed Nov 2002. This feature is not targeted for a future release. The config files can be copied to resolve this problem.

CR:291817

CR Number:   291817 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2002 Fixed 11 Oct 2002 Fixed Description Selecting into a local table from a proxy table mapped to a recursive directory causes a timeslice followed by a stacktrace.

CR:291821

CR Number:   291821 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2009 Insufficient priority to fix Description Feature request for logout triggers, which would operate similarly to the login triggers introduced in ASE 12.5, except that the trigger action would be executed when the client process exits.

CR:291861

CR Number:   291861 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2002 Fixed Description When the Rep Agent is up, the housekeeper fails to do any garbage collection even on an otherwise idle server. Workaround Description  sp_configure "enable housekeeper GC", 0 or stop and restart rep agent

CR:291868

CR Number:   291868 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2002 Fixed 22 Oct 2002 Fixed Description CIS : A 1763 error, "Cannot insert rows into sysstatistics, due to multiple equal frequency values..." may be reported when executing UPDATE STATISTICS on a proxy table that has a NUMERIC column. Workaround Description  none

CR:291890

CR Number:   291890 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2003 Duplicate Description On HP-UX machines running 64bit ASE versions between 12.5.0.1 and 12.5.0.2, sysprocesses.ipaddr returns 0.0.0.0 instead of the IP address of the client.

CR:291893

CR Number:   291893 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.3 15 Nov 2002 Duplicate Description Feature request for a new string function REPLACE(<source>,<oldval>,<newval>) that will replace every occurrance of <oldval> with <newval> in a CHAR or VARCHAR <source> Reviewed Nov 2002. The fix for this CR is targeted for the ASE 12.5.0.3 release. See also CR 298368.

CR:291899

CR Number:   291899 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) 15 Aug 2002 Fixed Description sp_sysmon under the kernel section will now show accurate recommendations.

CR:291905

CR Number:   291905 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2002 Fixed 27 Aug 2002 Fixed 02 Sep 2002 Fixed 16 Apr 2003 Fixed Description The message "current process infected with 11" in the modules omni_ct_command, omni_exec_transtmt, astc__h_predtm_dorpc together with a stack trace may be reported in the error log, if local server from within a transaction looses connection with remote ASE server.

CR:291913

CR Number:   291913 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2002 Fixed Description Implementation of built-in function DERIVED_STAT to return the derived statistics found in optdiag, such as cluster ratios, space utilization and large io efficiency.

CR:291947

CR Number:   291947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   11.9.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2009 Insufficient priority to fix Description Calculations involving numeric quantities can sometimes fail with Arithmetic overflow when their results ought to fit within the required precision and scale

CR:292008

CR Number:   292008 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   11.9.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2004 Not reproducible with latest version of the product available as of Resolution Date Description Checkstorage sometimes reports transient 100007 errors on ALLOCATION (i.e. on one of the allocation pages that occur every 256 pages in a database). This is harmless and can be ignored. The suspected cause is that the first extent of an allocation unit is being deallocated at the same time checkstorage is being run, and catches a moment in the processing when the allocation map indicates all 8 pages of the extent are deallocated, although the first page of the extent, which is the allocation page itself, should actually never be marked deallocated. Reviewed Nov 2002. Pending further research.

CR:292042

CR Number:   292042 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2002 Fixed 22 Aug 2002 Fixed 02 Sep 2002 Fixed Description When server's default character set is UTF-8, the parameterized language statement "select * from table where char_column like @p1" sent from jConnect 5.5 client will fail to find a match.

CR:292050

CR Number:   292050 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2002 Fixed 19 Mar 2003 Presently Not Targeted For Any Future Release Of This Product Description In the Lock manager recommendation section of sp_sysmon, spinlock contention was wrongly being calculated based on a single bucket instead of averaging out over all the buckets.

CR:292098

CR Number:   292098 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   macosx Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2002 Fixed Description If there is only one entry in the interfaces file, Sybase Central gives exception. This problem is fixed.

CR:292112

CR Number:   292112 Product Name:   Sybase InstallShield Product Component:   InstallShield Status:   Closed OS:   Generic Original Version:   3.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2002 Fixed 3.0 25 Oct 2002 Fixed 3.0 25 Oct 2002 Fixed 3.0 25 Oct 2002 Fixed 3.0 25 Oct 2002 Fixed 3.0 25 Oct 2002 Fixed Description Corrected misspelling: unselcting --> unselecting -----[304 changed to 304]----- < uninstall_feature_reverse_dependencies=The following features require the feature you are unselcting. If you select OK, these features will also be deselected.\n{0} --- > uninstall_feature_reverse_dependencies=The following features require the feature you are unselecting. If you select OK, these features will also be deselected.\n{0}

CR:292133

CR Number:   292133 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_configure option to prevent CREATE or ALTER database from shortchanging. Currently, if you issue a CREATE or ALTER database on a device that doesn't have as much free space as was requested, ASE allocates all the available space and provides a simple message of how much space it allocates (but without drawing attention to the fact that it is less than was requested). Whether or not it should actually fail with an error instead has been debated for years. This CR requests a new sp_configure parameter to control this behavior, such as sp_configure "Cause create/alter database to fail if requested space not available" (default 0) Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

CR:292135

CR Number:   292135 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) 10 Sep 2002 Fixed 21 Jan 2003 Fixed 16 May 2003 Fixed Description Improves checkpoint performance by increasing the batch size of doing I/O's.

CR:292178

CR Number:   292178 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2002 Fixed 08 Nov 2002 Fixed Description Security restrictions have been relaxed on the sp_monitorconfig stored procedure to support external performance tools. Previously, a user needed to have sa_role to execute this procedure. Now a user requires either sa_role or mon_role.

CR:292184

CR Number:   292184 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2002 Fixed 23 Aug 2002 Fixed 30 Aug 2002 Bundled Request Description In sybmigrate, various windows have display size problems. In addition, sybmigrate windows are changed to use the system color.

CR:292188

CR Number:   292188 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2003 Bundled Request Description A column showing the number of processes that have been suspended due to the database transaction log being full has been added to the monOpenDatabases monitoring table as SuspendedProcesses.

CR:292192

CR Number:   292192 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2002 Fixed Description sqldbgr now prompts for password to be entered if that option is ignored in the command line.

CR:292206

CR Number:   292206 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Dec 2003 Fixed 16 Mar 2004 Fixed Description The stored procedure sp_audit has been enhanced to allow auditing extended procedures.

CR:292211

CR Number:   292211 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2009 Insufficient priority to fix Description Request to have sqldbgr "show variables" command output include the procedure's parameters as well as declared variables. (Parameters are current visible with the "where" command, but it seems intuitive that "show variables" would display parameters as well, as they look and act just like variables.) Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release. Workaround Description  Use the "where" command to display current value of parameters

CR:292221

CR Number:   292221 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   macosx Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2002 Deferred 14 Feb 2003 Fixed Description Proxy Table Editor should have save(for alter table) & save and close options.

CR:292224

CR Number:   292224 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2009 Insufficient priority to fix Description Request to have SQLDBGR's SET command work on procedure parameters as well as declared variables. Currently it only works against variables. Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

CR:292246

CR Number:   292246 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2002 Fixed 01 Apr 2003 Fixed 24 Nov 2003 Presently Not Targeted For Any Future Release Of This Product Description Syslogs is unnecessarily flushed to disk when a transaction in TEMPDB commits resulting in sub-optimal performance. Likewise, the data pages of a table created in TEMPDB with SELECT INTO are unnecessarily flushed to disk. This optimization may be disabled using the 2709 trace flag.

CR:292320

CR Number:   292320 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) 10 Sep 2002 Fixed 24 Feb 2003 Fixed Description Fixes incorrect sp_sysmon recommendations pertaining to pool size and wash size under the "Data Cache Management" section when running with larger page sizes i.e. ASE installations with page sizes > 2K. Enhanacement to include Object Manager spinlock contention under the "Metadata Cache Management" section and some recommendation on when to use the dbcc tune(des_bind) feature.

CR:292330

CR Number:   292330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2003 Fixed 15 Apr 2004 Presently Not Targeted For Any Future Release Of This Product 12 Feb 2004 Fixed 25 Aug 2005 Fixed 01 Mar 2006 Fixed Description Feature request for the ability to grant ability to execute the TRUNCATE TABLE command to other users

CR:292339

CR Number:   292339 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   macosx Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2002 Fixed Description For Mac version 10.2, user cannot start ASEPlugin help. This problem is fixed.

CR:292340

CR Number:   292340 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2009 Duplicate Description Feature request for the ability to declare variables and stored procedure parameters of type TEXT or IMAGE

CR:292430

CR Number:   292430 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2003 Duplicate Description Feature request for the ability to have remote backupservers handle compressed dumps (currently only available on local backupservers). Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

CR:292435

CR Number:   292435 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2005 Duplicate Description feature request to have ASE allow comparing text and image fields to NULL directly without having to use the proprietary function textvalid(), i.e. just: select * from blurbs where copy is not null

CR:292483

CR Number:   292483 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2002 Fixed Description Now the conversion between SQL type TEXT/IMAGE and Java type java.io.InputStream is implicit. The conversion between SQL type TEXT/IMAGE and Java type java.lang.String has to be explicit.

CR:292486

CR Number:   292486 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2002 Fixed Description First execution of a stored procedure using unichar/univarchar as parameter after "load database" raises warning message 7961. Subsequent executions are fine.

CR:292543

CR Number:   292543 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   macosx Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2002 Fixed 30 Aug 2002 Fixed 30 Aug 2002 Bundled Request 20 Sep 2002 Fixed Description The Migration Tool (sybmigrate) reports an error "Error while parsing interfaces file '%1'." if the interfaces file contain comment lines in the beginning of the file. Workaround Description  Remove all comment lines in beginning of the interfaces file.

CR:292546

CR Number:   292546 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2002 Fixed Description Insufficient "stack size" configuration can cause a variety of failures in Java initialization and prevent Java operation. In some cases there is no indication that the problem was due to insufficient "stack size". Add a message to the error log to indicate the cause of the failure.

CR:292549

CR Number:   292549 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) 30 Sep 2002 Fixed 05 Feb 2003 Fixed Description In rare circumstances incorrect results may be returned when executing a SELECT statement with an IN list or an OR operator in which there is a comparison of a BINARY or VARBINARY column. Target Version  12.5 Review Status  Reviewed March 2003. Bug is fixed and closed in 12.5 ESD #9. Workaround Description  Drop the clustered index and the query runs correct again. select * from ADR1 where TC_Id = @tcidChild or TC_Id = @tcidParent works fine.

CR:292574

CR Number:   292574 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request for an sp_configure parameter to control the server's default transaction isolation level. Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 15.0 release.

CR:292629

CR Number:   292629 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2002 Presently Not Targeted For Any Future Release Of This Product Description Feature request to enhance the SELECT INTO command so that it can append minimally-logged data to a local table that already exists. This can reasonably be limited to tables that have no indexes or triggers, much like fast bcp. Reviewed Nov 2002. Feature is currently not targeted for any release.

CR:292631

CR Number:   292631 Product Name:   ASE Replicator Product Component:   Installation Status:   Closed OS:   Generic Original Version:   12.5.0.105P2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.106P3 20 Sep 2002 Fixed 2.0.0 06 May 2003 Fixed 12.5.0.109P6 16 May 2003 Fixed Description ASE Replicator: Now also runs on Mac OS X v10.2 and RedHat Linux 7.2. For all Unix platforms, the .sh scripts check to see if the $SYBASE environment variable is set. If it is not, the scripts assume they are being executed from within the <install_dir>/RPL-12_5/bin directory, and they set SYBASE to `pwd`/../.. in order to be able to set the other paths that they need.

CR:292636

CR Number:   292636 Product Name:   Adaptive Server Generic Docs Product Component:   EFTS SDS and SFTS SDS Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2003 Fixed Description Restore FTS Highlighting feature documentation to 12.x in FTS Specialty Data Store Users guide: Chapter 5 Writing Full-Text Search Queries - Pseudo Columns in the Index Table Reviewed Nov 2002. This feature will be addressed in the documentation released with the next release of ASE.

CR:292664

CR Number:   292664 Product Name:   Sybase InstallShield Product Component:   InstallShield Status:   Closed OS:   Generic Original Version:   3.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2002 Fixed 3.0 26 Aug 2002 Fixed 3.0 26 Aug 2002 Fixed 3.0 26 Aug 2002 Fixed 3.0 26 Aug 2002 Fixed 3.0 26 Aug 2002 Fixed Description This fixes the null pointer exception that shows up on the reboot panel after reboot. The problem is that we don't have a graphics context (root panel) to root the JOptionPane to. This fix just makes the JOptionPane assume a null parent so that it will display regardless of whether there is a parent panel.

CR:292666

CR Number:   292666 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2002 Fixed 18 Oct 2002 Fixed 04 Nov 2002 Fixed Description In some circumstances, a query that uses an index may run slower than expected as a result of increased I/O, when it is executed on a server configured with a non-binary sort order, depending on the value specified in the WHERE clause. Workaround Description  To see description.

CR:292699

CR Number:   292699 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2005 Fixed 14 Feb 2005 Fixed 16 Feb 2005 Fixed 16 Mar 2005 Fixed Description Prevent the OS from performing lazy allocation when creating the master device by writing out all pages of the device. Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 15.0 release.

CR:292713

CR Number:   292713 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2003 Fixed Description Unnecesary error messages are printed in the errorlog if ASE is configured for both SSL and non SSL connections.

CR:292725

CR Number:   292725 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2002 Fixed 18 Feb 2003 Fixed Description An 871 error, "Process <spid> is trying to release a latch on buffer <address> ... without holding a latch on the buffer", may occasionally be reported when using a serializable backward scan on a data-only locked table. The stack trace may include the modules 'bt__unwind', 'bt__traverse' and 'bt__getstartpg'.

CR:292764

CR Number:   292764 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2003 Fixed 14 Oct 2003 Fixed 02 Nov 2003 Fixed Description The work done by a remote server in modifying a proxy table as part of a trigger execution is not rolled back when the ROLLBACK TRIGGER command is executed. Workaround Description  Workaround could be using savepoints, ie set a savepoint before the insert, check @@transtate after insert for a rollback trigger and if so, rollback to savepoint

CR:292767

CR Number:   292767 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) 13 Jan 2003 Presently Not Targeted For Any Future Release Of This Product 27 Jun 2003 Fixed 01 Jul 2003 Presently Not Targeted For Any Future Release Of This Product Description When a task tries to access a database while the database is undergoing creation through the 'CREATE DATABASE' command, then errors 913 and 834 may be hit with a stack trace reported in the error log showing modules 'dbt_removeall', 'bufdbclean' and 'cm_dbclean'. The same can happen if instead the database is being dropped through the 'DBCC DBREPAIR(<dbname>, DROPDB)' command. Workaround Description  None.

CR:292784

CR Number:   292784 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2003 Fixed 15 Aug 2003 Fixed 20 Feb 2003 Presently Not Targeted For Any Future Release Of This Product 11 Apr 2003 Fixed Description We will not allow views with unnamed columns like "create view vw as select 1". The user must specify the column names. This fix can be disabled by traceflag 1702.

CR:292860

CR Number:   292860 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2002 Fixed 19 Dec 2002 Fixed Description A UNION query with numerous subqueries on one side of the UNION may fail. Workaround Description  create an empty table first, then use 'insert into ... select ... union select'.

CR:292913

CR Number:   292913 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2002 Fixed 03 Feb 2003 Presently Not Targeted For Any Future Release Of This Product Description The message "process infected with 11" may be reported in the error log together with a stack trace which includes the modules 'proc_setdb_tree', 's_renormalize' and 's_recompile' if a stored procedure containing a SELECT statement having 16 subqueries in the select list is executed and the table referenced by the SELECT is dropped and recreated in the meantime.

CR:292917

CR Number:   292917 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) 30 Sep 2002 Fixed 07 Mar 2003 Fixed Description In rare circumstances, the message "current process infected with 11" may be reported in the error log together with a stack trace which includes the module 'a_calcrowlen' when processing a query that uses mutiple worktables and the first aggregate of the second worktable is an AVG aggregate.

CR:293013

CR Number:   293013 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2003 Fixed Description On Windows 2000 Advanced Server and Datacenter Edition, running the syconfig program from the Start menu will result in a message box that reads "invalid command line argument 'and'" You can work around this problem by running syconfig from the command line. Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release. Workaround Description  Goto Start->Programs->Sybase, right clicks on the "Server Config". This brings up the properties window. In the "Shortcut" tab, type in a (Sybase) directory for the text field "Start in:" and click OK. The "Server Config" short cut should works now.

CR:293070

CR Number:   293070 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Unknown Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2003 Fixed 09 Mar 2004 Deferred 02 Sep 2003 Not a Bug Description Add new tab 'Columns' on View Properties dialog. It lists the columns of the view.

CR:293111

CR Number:   293111 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2003 Fixed Description Text indexes can now be created on tables that contain an identity column or a suitable primary key. Primary keys defined on a single decimal, numeric, int, smallint, or tinyint column are eligible. Decimal and numeric columns must have a scale of zero.

CR:293127

CR Number:   293127 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2002 Fixed 18 Sep 2002 Fixed Description 'Select Distinct with UNION' and JOINS with Distinct keyword may encounter performance degradation if proxy tables are involved.

CR:293149

CR Number:   293149 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) 30 Sep 2002 Fixed 30 Sep 2002 Fixed 09 Oct 2002 Fixed Description In rare circumstances, performance of some queries may be sub-optimal because of an incorrect row count estimate in systabstats.rowcnt after a server restart, LOAD DATABASE or LOAD TRANSACTION.

CR:293172

CR Number:   293172 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2002 Presently Not Targeted For Any Future Release Of This Product 17 Apr 2003 Fixed Description Failover of HA client may fail to login to secondary server with message 'ha session not found'.

CR:293180

CR Number:   293180 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2004 Not reproducible with latest version of the product available as of Resolution Date Description In some cases where a datetime column contains a 1/1/1753 value, OPTDIAG STATISTICS will raise error 245 Domain error during explicit conversion of VARBINARY value <x> to a DATETIME field. Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release. Workaround Description  Add a second to all "1/1/1753 12:00 AM" values in the table.

CR:293217

CR Number:   293217 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 10 Jan 2003 Fixed Description DDLGen doesn't generate the correct create database statement for databases that have mixed data a log segments.

CR:293223

CR Number:   293223 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) 13 Sep 2002 Fixed Description If the character or binary result value of a CASE expression in a SQL statement is greater than 255 bytes long, the data is truncated to 255 bytes or less.

CR:293230

CR Number:   293230 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   AIX Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2010 Insufficient priority to fix Description Request for additional language support for srvbuild.

CR:293239

CR Number:   293239 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2002 Fixed Description A 3702 error is reported when trying to drop a table which had its schema changed by an ALTER TABLE command and was later referenced in an OPEN CURSOR query that failed with a 540 error.

CR:293268

CR Number:   293268 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   HP-UX Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2003 Fixed 20 Aug 2004 Fixed 07 Nov 2004 Fixed 07 Nov 2004 Fixed 22 Feb 2005 Fixed Description CIS : In a HA environment, ownership of tables in user proxy databases may be incorrect.

CR:293291

CR Number:   293291 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Query Processing and Abstract Plans Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2003 Fixed Description Indexes created in a proc are used by the optimizier in queries that are run inside a SP. P&T guide needs to be changed to reflect this behavior Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

CR:293315

CR Number:   293315 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   SunOS Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2005 EOL'd version. Not to be Fixed. 12 May 2004 Fixed Description CIS: Host name and port number will be dumped to the ASE error log file when a connection to the remote server fails. This enhancement works only when traceflag 11299 is turned on.

CR:293321

CR Number:   293321 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Unknown Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2003 Fixed Description In "sybmigrate", user gets an unexpected exception "java.lang.IllegalArgumentException" when connect to the ASE with port number > 65535.

CR:293372

CR Number:   293372 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2002 Fixed 13 Sep 2002 Fixed 26 Sep 2002 Fixed Description A query that assigns its result to a local variable and which is run in parallel having executed a SET ROWCOUNT statement may incorrectly return a NULL value. This is likely to happen if the number of worker threads is bigger than the SET ROWCOUNT value. Workaround Description  set rowcount 1 + parallelism +result in variable gives result NULL

CR:293494

CR Number:   293494 Product Name:   Adaptive Server Enterprise Product Component:   Startserver Status:   Closed OS:   Linux Original Version:   12.5.0.1 Intl Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2002 Fixed Description The Linux/ASE 'showserver' command lists all threads belonging to an ASE engine or invoked helper process. This can easily confuse the DBA or SA when platform specific commands are required to control the process. With this fix, 'showserver' command only lists the main thread for ASE or its related components.

CR:293525

CR Number:   293525 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2003 Fixed 08 Jan 2003 Fixed Description A 4409 error, "The columns in the query definition and the view definition do not match" may be reported when executing a query that references the same column in the select list and in the WHERE clause of a view which itself defines that same column as a subquery.

CR:293531

CR Number:   293531 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2003 Fixed Description The EFTS now supports index_any clauses greater than 255 bytes. The column definition of the proxy table was not altered, because its definition doesn't affect the size of the clause that will be sent to the FTS.

CR:293553

CR Number:   293553 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) 28 Feb 2003 Not a Bug Description There is no index optimization when sum() aggregate and group by clause are in the same query. Reviewed Nov 2002. A fix is planned but currently unscheduled.

CR:293603

CR Number:   293603 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   HP-UX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2002 Fixed Description CIS: create proxy_table command may drop the remote table in an HA environment. Workaround Description  do not run create proxy_table on HA proxydb. Run alter database pdb for proxy_update instead. or run create existing table instead.

CR:293620

CR Number:   293620 Product Name:   Adaptive Server Generic Docs Product Component:   XA Guide for CICS Encina and Tuxedo Status:   Closed OS:   all Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2003 Fixed Description 12.0 CIS guide refers to sql_server instead of direct_connect for MSSql Server. The doc set is correct for ASE 12.5

CR:293624

CR Number:   293624 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2003 Duplicate Description On linux, running ASE versions prior to 12.5.0.3 one may encounter errors 903, 834 and a stack trace in the errorlog when creating a large database on a raw device. Workaround Description  -

CR:293636

CR Number:   293636 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2002 Fixed 20 Sep 2002 Fixed 12.5.0.3 08 Nov 2002 Fixed Description Adaptive Server is started by root and run with root privileges when configured for High Availability on Sun Cluster 3.0 instead of running as user account that owns $SYBASE directory.

CR:293638

CR Number:   293638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2003 Fixed 19 Nov 2003 Fixed Description A 'like' clause on a column that is seeded by a parameter value and also participates in an outer-join can yield incorrect results. Workaround Description  Identify problem procedures and then always execute them with recompile or don't use like. Pronlem also happens for declared variables used in like clauses if outer joins are involved and the like is on a where clause rather than an ON clause. Consider

CR:293651

CR Number:   293651 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Unknown Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2004 Fixed 06 Aug 2004 Fixed Description Migration Tool opens many connections to the source ASE. Workaround Description  None, apart from increasing the number of user connections.

CR:293673

CR Number:   293673 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2005 Insufficient priority to fix Description Configuration option to disable pre-12.5 clients (and those not capable of wide-table support) from connecting to a dataserver. The idea is to prevent clients who would get warnings about the lack of wide-table support from connecting successfully if an administrator so favored in his configuration options.

CR:293687

CR Number:   293687 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2003 Not a Bug 12 May 2003 Fixed 11 May 2003 Fixed Description A 12818 error, "Cannot create an object of this type in system-created proxy database." maybe raised when an ALTER TABLE command that adds a column with DEFAULT clause is executed on a HA server that has been configured as 'with_proxydb'. Workaround Description  On primary server, do the following instead of one single ALTER TABLE command :- alter table tab add col int null go create default zero_dft as 0 go sp_bindefault zero_dft, "tab.col" go alter table tab modify col int not null go

CR:293772

CR Number:   293772 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2004 Fixed 06 Oct 2004 Fixed Description Enhance the sp_sysmon stored procedure to provide an option to execute without clearing the monitor counters. Note: The interface to the sp_sysmon_collect stored procedure has been changed.

CR:293799

CR Number:   293799 Product Name:   ASE Replicator Product Component:   Utilities Status:   Closed OS:   Generic Original Version:   12.5.0.105P2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.0.0 06 May 2003 Fixed 12.5.0.106P3 20 Sep 2002 Fixed Description ASE Replicator: If the environment for jConnect is not correctly set up, ASE Replicator may fail to start up with the following error: Failed to re-set the database context to original catalog of <xxx>. Current catalog is <unknown>. With this fix, ASE Replicator will still log this error but it will keep going. The side effect may be slower performance because connections to ASE will be closed and re-created instead of being released and held in a pool.

CR:293800

CR Number:   293800 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2002 Fixed 21 Jan 2003 Fixed 07 Apr 2003 Fixed Description Please see 293800-1 for complete description

CR:293829

CR Number:   293829 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2002 Fixed 17 Dec 2002 Fixed 07 Apr 2003 Fixed Description Multiple Temp DB Support in Sybase Central ASE Plug-in. CR 301366 opened for DOC changes