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

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

CR:330178

CR Number:   330178 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2003 Third Party Problem 30 Oct 2003 Third Party Problem Description On IBM AIX, in rare circumstances, high CPU utilization may be seen because a server kernel thread was being sent a SEGV. Upgrading to OS patch level ML4 on AIX causes the problem to not occur. Workaround Description  no workaround found at this moment.

CR:330279

CR Number:   330279 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2003 Fixed 30 Jun 2004 Fixed 04 Feb 2004 Fixed Description Some of database devices failed to be displayed due to an Arithmetic overflow occur when ASE Plugin issue the SQL to retrieve the database devices information. The database devices retrieval SQL is corrected to avoid the Arithmetic overflow exception.

CR:330311

CR Number:   330311 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 Jan 2004 Fixed Description Spurious 100002 Hard fault reported by dbcc checkstorage when running concurrently with operations such as select into.

CR:330319

CR Number:   330319 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) 07 Nov 2003 Fixed Description CIS: For a query having a local table and a proxy table, OR search conditions of the proxy table will not be passed to the remote server if the local table is chosen as the outer table for the JOIN, and there is a builtin in the WHERE clause at the same time. A traceflag 11262 has been added to fine-tune OMNI optimizer to pass OR search conditions as many as possible. Workaround Description  May use 'set forceplan on' to let the proxy table as outer table in the join,then the search clauses may be passed to remote server.

CR:330327

CR Number:   330327 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) 11 Dec 2003 Fixed Description The message "current process infected with 11" in the module 'run' together with a stack trace which includes the modules 'exec_eop' and 'execute' may be reported in the error log when executing an UPDATE SET col_name = (<subquery>) WHERE CURRENT OF cursor_name. Workaround Description  I am not sure if this workaround will always work, but for the repro below, you can use trace flag 328 to Disable reformatting as a workaround.

CR:330361

CR Number:   330361 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Open OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description srvbuildres using a resource file is not correctly handling sizes of sybsystemdb when using other then the defaults

CR:330401

CR Number:   330401 Product Name:   Adaptive Server Enterprise Product Component:   SQL Advantage Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2007 Presently Not Targeted For Any Future Release Of This Product Description enhance to support connecting to TRS and gwless

CR:330488

CR Number:   330488 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2003 Fixed 14 Nov 2003 Fixed Description In a server with CASE INSENSITIVE sort order, creating an index on a Data Only Locked table with SORTED_DATA option may cause DBCC CHECKTABLE to report 9996 errors; DELETEs on the table may fail with 644 errors. Workaround Description  Don't use "sorted_data" option when creating an index on a dol table on a case insensitive server.

CR:330569

CR Number:   330569 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2003 Fixed 04 Dec 2003 Fixed 05 Nov 2003 Fixed 16 Jan 2004 Fixed Description CIS: When a transaction that is executing an INSERT..SELECT (insert to proxy table) has been imposed as the deadlock victim, the session fails to acknowledge this error event and continues.

CR:330678

CR Number:   330678 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) 27 Oct 2003 Bundled Request Description Feature request for a built-in encryption function that could be used to maintain a password history without revealing previous passwords in plain-text

CR:330811

CR Number:   330811 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 Feb 2004 Fixed Description When ASE is configured for High Availability with SunCluster3.0, proper error message is not logged in the HA agent's callback log if ASE resource fails to boot dataserver becuase of permission problems with RUN_server file.

CR:330841

CR Number:   330841 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) 05 Oct 2003 Fixed 06 Oct 2003 Fixed Description Starting with ASE 12.5.0.3, CPU utilization may go to 100% when "enable housekeeper GC" is set to 1, and the housekeeper queues have filled up to more than 80% of their maximum capacity because of an old open transaction.

CR:330852

CR Number:   330852 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) 04 Sep 2003 Presently Not Targeted For Any Future Release Of This Product 27 Oct 2003 Fixed Description A 804 error "Unable to find buffer 'value' from cache 'value' holding logical page 'value' in sdes 'value' kept buffer pool for object 'value'." may be hit in module "bufunkeep_sdes" with a stack trace in the error log showing modules "closetable" and "endscan" if earlier the session has been unable to delete for some reason a row from a Data Only Locked table.

CR:330858

CR Number:   330858 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2008 Insufficient priority to fix Description Job Scheduler: feature request for dependencies between jobs, such as don't start job 2 before job 1 completes.

CR:330962

CR Number:   330962 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) 17 Sep 2003 Fixed 29 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description The JVM could incidentally trap with a Segmentation Violation (Infected with 11) during engine offline requests.

CR:331016

CR Number:   331016 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2003 Fixed 21 Jun 2007 Fixed Description When user wants to delete login that has alias users or direct mapping users, a login delete dialog will display with all the login related users and ask the user whether he/she wants to delete all the users that associated with the login. This is a requirement for dropping the login. After the confirmation, all the users and login will be deleted. If the login does not has associated users, the dialog will not be shown and login delete as normal. Target Version  Not To Be Released

CR:331025

CR Number:   331025 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 May 2009 Insufficient priority to fix Description Feature request for a means to modify the definition of a user-defined datatype and have the change automatically applied wherever the datatype is referenced.

CR:331052

CR Number:   331052 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) 06 Nov 2003 Fixed 15 Sep 2003 Fixed 12 Nov 2003 Fixed 18 Jan 2004 Fixed 23 Jan 2004 Fixed Description A global variable @@version_number is now available to return the full version number with minor version included. In 12.5.2, @@version_number returns 12520. This complements @@version_as_integer, which returns the upgrade version number (12500 as of 12.5.2).

CR:331064

CR Number:   331064 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) 02 Oct 2003 Fixed 15 Sep 2003 Fixed Description xmlextract queries may return a wrong result, if the xpath contains a wildcard and fetches an attribute.

CR:331083

CR Number:   331083 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) 29 Sep 2003 Fixed Description A 511 error, "Attempt to update or insert row failed because resultant row of size <value> bytes is larger than the maximum size (<value>bytes) allowed for this table." maybe reported when executing an INSERT statement based on a SELECT using a view and a UNION clause. The error is raised when the target table has a column with a DEFAULT using a builtin function like suser_id(). Workaround Description  (1) Re-write the query to; (a) Not use a union OR (b) Not use a view if using a union (2) Don't define insert table's columns as not NULL.

CR:331107

CR Number:   331107 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.5.1 12 Sep 2003 Fixed 12.5.1 12 Sep 2003 Fixed 05 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description The VCS HA agent for resource type Sybase may invoke 'monitor' and 'clean' scripts continuously and no failover occurs if thorough probe is used and ASE server fails to respond to probe before monitor times out. Workaround Description  Modify clean script as: if ($CleanReason =~ /^[23]/)

CR:331120

CR Number:   331120 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2003 Fixed Description doc correction in "Creating the dbccdb database".

CR:331168

CR Number:   331168 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) 17 Sep 2003 Fixed 29 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description Increasing "size of process object heap" causes slow response time when executing single user java applications. Also at times Out of memory error is returned under a multi user scenario.

CR:331183

CR Number:   331183 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) 10 May 2004 Presently Not Targeted For Any Future Release Of This Product Description Raise an error and rollback the transaction when an attempt is made to update a table in a 1-to-many join.

CR:331296

CR Number:   331296 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2003 Fixed 17 Aug 2003 Presently Not Targeted For Any Future Release Of This Product Description On Windows NT platform, part of the instmstr script was truncated leading to errors on running the instmstr.

CR:331412

CR Number:   331412 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2004 Fixed 09 Mar 2004 Fixed 18 Feb 2004 Fixed 16 Aug 2004 Fixed Description A timeslice error may be reported during failover in an HA system when recovery is attempting to reconfigure the cache memory pools for optimum usage. Cache memory pools are no longer reconfigured during HA failover.

CR:331477

CR Number:   331477 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) 14 Jun 2005 Fixed Description The message "current process infected with 11 in ns__exec_stmt" is printed in the errorlog together with a stacktrace containing the modules 'call_ns_exec', 'ns_execute' and 'ns__exec_stmt' when using internal JDBC with the CallableStatement.setNull() methode passing in a java.sql.Types.INTEGER datatype as second param. Workaround Description  Various coding options.

CR:331537

CR Number:   331537 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) 09 Dec 2003 Fixed Description From HA wizard, user can add a remote server which can be used for a HA companion server

CR:331545

CR Number:   331545 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2003 Fixed 23 Oct 2003 Fixed 11 May 2004 Fixed 14 Apr 2004 Fixed Description After loading a database from an older server version (that is, one which requires upgrade to make it usable by the current server), "online database for standby_access" performs the upgrade even though the database is marked as being in standby mode. This prevents subsequent LOAD TRAN in that database.

CR:331553

CR Number:   331553 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2003 Fixed Description Customer finds bcp -b documenation confusing

CR:331565

CR Number:   331565 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Aug 2004 Fixed 03 Aug 2004 Fixed Description Migration of database information is not allowed unless server wide information has also been migrated.

CR:331606

CR Number:   331606 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 Oct 2003 Fixed Description The message "Database '<db>' is now online with a lower server version number. Refer to the higher version release notes on the limitations of backward compatibility", may be incorrectly printed during the online of a database that was loaded from a dump which originated on an 11.9.x (or earlier) version of Adaptive Server. Workaround Description  Not really necessary - the message is misleading.

CR:331700

CR Number:   331700 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2003 Fixed Description A 207 error "Invalid column name '<colname>'." followed by 11050 error "Adaptive Server cannot process this ALTER TABLE statement due to one or more preceding errors ..." will be reported when an ALTER TABLE command to ADD or MODIFY a column is run on a temporary table having a constraint.

CR:331717

CR Number:   331717 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2004 Duplicate Description Wrong makefile for testmon, Monitor Client sample program, missing header files..

CR:331758

CR Number:   331758 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) 10 Oct 2003 Fixed Description Under some circumstances incorrect results may be returned when executing a query using "GROUP BY" clause on columns defined with fixed char datatype and when the Adaptive Server is configured with a non binary sort order.

CR:331764

CR Number:   331764 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 Dec 2003 Fixed Description When "sysbystemdb" is stored on a user created device besides master, then during ASE restart if the given user device is not accessible, "sybsystemdb" is silently recovered without a warning message being reported. This may later cause problems in this database. Workaround Description  N/A

CR:331777

CR Number:   331777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2003 Fixed 27 Jan 2004 One-off Provided 29 Mar 2004 Presently Not Targeted For Any Future Release Of This Product Description Mirroring of master device on IBM may lead to 'uninitialized logical page' message

CR:332122

CR Number:   332122 Product Name:   Adaptive Server Enterprise Product Component:   sqlloc Status:   Closed OS:   Unknown Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2004 Fixed Description The ASE localization utility sqlloc does not allow built-in UTF-8 non-binary sort orders to be selected. Workaround Description  In 12.5.1, you can use sp_configure to set the sort order directly in isql, just do: 1> sp_configure 'default unicode sortorder',0,'nocase' 2> go

CR:332229

CR Number:   332229 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) 23 Jan 2004 Fixed 30 Jul 2004 Fixed Description Extend "sp_dbextend 'help', 'list'" command to also report the usage for "'list', 'threshold'" command.

CR:332240

CR Number:   332240 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Fixed 20 Feb 2004 Fixed 28 Jan 2004 Fixed 27 Jun 2007 Fixed Description Enhancement request for sqlupgarde utility to continue upgrading even if errors are encountered during upgrading.

CR:332265

CR Number:   332265 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) 18 Sep 2003 Presently Not Targeted For Any Future Release Of This Product 18 Sep 2003 Presently Not Targeted For Any Future Release Of This Product 16 Sep 2003 Fixed Description After loading a transaction dump, the segmap information in sysusages may be incorrectly altered.

CR:332268

CR Number:   332268 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2003 Fixed Description When ASE runs out of LOCKS, 707 error "System error detected during attempt to free memory at address 0x<value>..." may be raised resulting in the session being killed. Alternatively an "infected by 11" error may occur. A stack trace will be reported in the error log showing modules 'proc_read', 'proc__fetchphdr' and 'proc_read__backout'. Workaround Description  Increase the "number of locks" configuration option.

CR:332349

CR Number:   332349 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 08 Oct 2003 Fixed 17 Nov 2003 Presently Not Targeted For Any Future Release Of This Product Description When Adaptive Server is configured with a 'sql server clock tick length' greater than 500000, the following message will appear in the error log: 00:00000:00002:2003/11/11 15:04:29.48 kernel uasetalarm: ticks value 0, must be positive

CR:332378

CR Number:   332378 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2003 Fixed 01 Oct 2003 Fixed Description A UNION VIEW used in an INSERT query may result in a 622 error where the database for the target table for the INSERT is different than the database for the base table of the view. Workaround Description  use a normal table instead of temp table insert real_table (t1,t2) select a1,sum(a2) from view1 where a1 in (1 ,2) group by a2 go (0 rows affected)

CR:332427

CR Number:   332427 Product Name:   System Admin Guide Product Component:   System Administration Guide Status:   Closed OS:   NA Original Version:   4.1.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 5.0 18 Sep 2003 Fixed Description Enhance description of package synchronization in cluster

CR:332447

CR Number:   332447 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) 04 Oct 2003 Fixed 30 Sep 2003 Fixed Description When loading a transaction dump into a database that is bigger than 38000 pages, if the source and target databases have a different layout, the segment map will be set to SYSTEM + DEFAULT (segmap = 3) if the source database has segregated log. If the source database has mixed log and data, the segment map will be set to SYSTEM + DEFAULT + LOGSEGMENT (segmap = 7). Workaround Description  The only workaround is to make the source and target databases have the same diskmaps before the load tran occurs. The output of: select segmap,lstart,size from sysusages where dbid=<dbid> must be the same in the source and target databases.

CR:332462

CR Number:   332462 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) 02 Dec 2003 Fixed 17 Feb 2004 Presently Not Targeted For Any Future Release Of This Product 22 Feb 2004 Fixed Description Provide JavaHelp for ASE Plugin Help button is enable for properties page.

CR:332464

CR Number:   332464 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2003 Fixed Description A local variable using an extended datatype (Java Object) can contain an incorrect value when a field in this Java Object is from a subclass and is assigned a value from a SELECT FROM <table> statement. Workaround Description  A possible workaround is to use an intermediate local var. declare @mytest test declare @mytest1 test1 select @mytest = new test() select @mytest1 = @mytest>>a_test1 select @mytest1>>str = ad from test where id = 1 select @mytest>>a_test1>>str

CR:332536

CR Number:   332536 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 Sep 2003 Fixed 19 Sep 2003 Fixed 09 Oct 2003 Fixed Description The branch of a distributed transaction will continue to persist after the transaction manager has committed the transaction, if the branch has incorrectly nested transactions. Workaround Description  Ensure that there is no incorrect nesting of transactions in the stored procedure that is executed on the remote branch.

CR:332574

CR Number:   332574 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 Dec 2003 Bundled Request Description Make visible Replication Agent parameter 'ha failover'

CR:332642

CR Number:   332642 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2003 Fixed 10 Nov 2003 Fixed 27 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date Description A column with a high number of rows of NULL value can result in unbalanced statistics. Workaround Description  If possible, update statistics using a big number of steps.

CR:332663

CR Number:   332663 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2003 Fixed Description The fractional seconds of the datetime value will be discarded, If datetime value of a proxy_table is mapped to an Oracle TIMESTAMP column. Target Version  12.5.1 ESD#2

CR:332671

CR Number:   332671 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) 09 Dec 2003 Fixed Description Stored procedure wrappers for monitoring tables.

CR:332711

CR Number:   332711 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) 26 Sep 2003 Fixed 20 Sep 2003 Fixed Description On the AIX platform, in rare circumstances, ASE may hang or may show 100% CPU utilization at the operating system level even when no users are active. Boot-time traceflag 4073 has been added to reduce the likelyhood of these events.

CR:332752

CR Number:   332752 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) 17 Dec 2003 Fixed Description In the Disk section of sp_sysmon report rename 'Disk Semaphore' to 'Mirror Semaphore' since it is only relevant for disk mirroring purposes.

CR:332766

CR Number:   332766 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 Dec 2003 Fixed Description The ONLINE DATABASE command is incorrectly audited when the 'load' audit option is enabled for a database, instead of when the global 'security' option is enabled.

CR:333052

CR Number:   333052 Product Name:   Adaptive Server Enterprise Product Component:   langinstall Status:   Closed OS:   Unknown Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2004 Bundled Request Description The "charset" utility should allow for the update of character set definitions in SYSCHARSETS, even when (or especially when) the character set corresponds with the server's currently configured default character set. This will make it possible to update character set definitions as support for them evolves - notably from pre-12.5.1 definitions of UTF-8 (limited to character widths of 3 bytes) to the 12.5.1 definition of UTF-8 (which includes support for 4-byte characters).

CR:333068

CR Number:   333068 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) 07 Nov 2003 Presently Not Targeted For Any Future Release Of This Product 05 Nov 2003 Fixed Description Multi-byte characters that are equivalent to '[' and ']' are not handled properly as delimiters to bracketed identifiers.

CR:333077

CR Number:   333077 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2003 Fixed 10 Oct 2003 Fixed 29 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description Queries containing GROUP BY with an expression using local variable may return duplicate rows. The workaround for this problem is to remove the local variable from the GROUP BY list or to add a DISTINCT clause to the query. Workaround Description  Don't use local variable or add a distinct clause.

CR:333148

CR Number:   333148 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) 19 Dec 2003 Fixed 08 Jun 2004 Presently Not Targeted For Any Future Release Of This Product Description In rare circumstances on a multi-engine server, an undetected deadlock may occur when running the 'data_pgs' builtin while there are a lot of concurrent table drops. Workaround Description  Don't lock tempdb system tables before calling builtins that access another processes temp tables. Select system tables into temp tables first, then query the temp tables.

CR:333160

CR Number:   333160 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) 17 Apr 2009 Insufficient priority to fix Description Feature Request: Add a configuration option that would result in message 311, "The optimizer could not find a unique index which it could use to scan table <table> for cursor <cursor>" being raised at procedure creation time instead of procedure execution time. Workaround Description  create a DOL table instead of APL (see 11162178-11)

CR:333197

CR Number:   333197 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 Dec 2003 Fixed Description A timing issue with process terminating and exceeding time limits will cause segmentation fault in rg__time_limit_hdlr() routine.

CR:333213

CR Number:   333213 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) 20 Mar 2009 Insufficient priority to fix Description sp_help Parameter_name output islimited to 15 characters eventhough you can have a stored procedure parameter name which consists of 30 bytes. Workaround Description  In sp_help, change "select Parameter_name = convert(varchar(15) NULL, c.name)," to "select Parameter_name = convert(varchar(30) NULL, c.name),"

CR:333216

CR Number:   333216 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) 25 Sep 2003 Fixed 04 Oct 2003 Fixed Description The error 643 together with a stack trace that includes the module 'tmp_check_nulls', or the error 233 reporting an empty column name, will be incorrectly raised if a table is created inside a stored procedure including the 'ON segment' option.

CR:333293

CR Number:   333293 Product Name:   ASE Replicator Product Component:   Management Status:   Closed OS:   Generic Original Version:   2.0.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.0.0 26 Mar 2004 Fixed 2.0.0 09 Dec 2004 Fixed Description ASE Replicator: Error message during startup on AIX: "JRE: not found". Workaround Description  No workaround is necessary, but removing the spaces in the assignment of the JRE environment variable in the startup script will cause the message to go away.

CR:333350

CR Number:   333350 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) 28 Jan 2004 Fixed 31 Oct 2003 Fixed 29 Jan 2004 Fixed Description When the server's default character set is UTF-8 and a non-binary sort order is configured, error message 1579 can occur in unexpected circumstances (e.g. have invalid characters in the table). Workaround Description  The workaround is to switch the sort order to "bin_utf8" (ID=50), install the language module, then switch back to the desired sort order. It implies rebuilding user indexes, however. Indexes for system tables are rebuilt automatically every time the s

CR:333354

CR Number:   333354 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2003 Fixed Description A 701 error "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later ..." may be reported while a sort operation is undergoing followed by an "infected with 11" message in module "dealloc_merge" with a stack trace in the error log showing modules "sortclean", "startsort" and "sort". Workaround Description  Increase the procedure cache size.

CR:333357

CR Number:   333357 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) 13 Feb 2004 Fixed Description If user configured the Web Services from the installer, runproducer.bat won't work with "ws.properties" file on Window platforms. This is because "ws.properties" file uses single "\" file separators.

CR:333402

CR Number:   333402 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 Dec 2003 Fixed Description A 243 error "Type '<type>' is not a defined system type." may be correctly raised but mistakenly followed by a stack trace in the error log in module 'closetable' during the execution of a stored procedure that creates a table making usage of a user defined datatype that has been dropped in the meantime. Module 'tmp_check_nulls' will also be reported.

CR:333439

CR Number:   333439 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) 06 Jun 2006 Insufficient info provided Description Feature Request: improve the performance of sp_helpdb for databases with many device fragments.

CR:333519

CR Number:   333519 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2004 Fixed Description If the Adaptive Server has a large number of databases, the sqlupgrade[res] did not wait long enough for all of the databases to recover before doing the installmaster. Workaround Description  manual upgrade

CR:333614

CR Number:   333614 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) 30 Sep 2003 Fixed Description Server fails to boot and will raise 1569 error when changing character set from utf-8 with one of the external sortorders (big5bin:194, cp932bin:192, cyrdict:140, eucjisbn:192, euckscbn:161, gb2312bn:137, gbpinyinbn:163, rusdict:165, sjisbin:179 and turdict:155).

CR:333618

CR Number:   333618 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) 21 Nov 2003 Fixed Description A stacktrace may occur if the user runs a java methods and java is not enabled on the server. In the stacktrace, the following functions may be found : s_normquery()-norm3_driver() and n3_res_udf().

CR:333638

CR Number:   333638 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) 17 Mar 2004 Fixed 23 Dec 2003 Fixed 26 Dec 2003 Fixed 04 Mar 2004 Fixed 30 Jan 2004 Fixed 17 Mar 2004 Fixed Description Implementation of Pluggable Authentication Modules feature in ASE.

CR:333676

CR Number:   333676 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2003 Fixed 09 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 17 Aug 2003 Presently Not Targeted For Any Future Release Of This Product Description Implement support for Mac OS X 10.3

CR:333685

CR Number:   333685 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2003 Fixed 29 Oct 2003 Fixed Description The message 632, "Memmove() was called with a length of <length> - maximum allowed length is 2048." may be reported together with a stacktrace which includes the modules 'cursfix__saverow', 'cursfix_main', 'delirow' and 'delparent' if a DELETE statement is used on a row which is also the current row used in a cursor. After this message, the clustered index can be corrupted and dbcc checktable may report 7930 errors. Workaround Description  drop/recreate clustered index

CR:333830

CR Number:   333830 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) 20 Nov 2003 Fixed Description sp_configure displays a NULL value in the type column for the configuration parameters "total data cache size" and "executable codesize + overhead".

CR:333836

CR Number:   333836 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) 27 Nov 2003 Fixed Description When a user named cache has been configured, sp_sysmon may report an erroneously high "large I/Os denied due to Pool < Prefetch Size" percentage for the 'default data cache'.

CR:333850

CR Number:   333850 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) 08 Jan 2004 Fixed 05 Nov 2003 Fixed Description When a UTF-8 non-binary sort order is configured, the charindex built-in function may yield incorrect results if the length of the expression1 does not equal the length of the matching string within expression2.

CR:333873

CR Number:   333873 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) 07 Oct 2003 Fixed 16 Oct 2003 Fixed 22 Jun 2004 Fixed 22 Oct 2003 Fixed Description SQL Derived tables cannot have unnamed columns. The columns have to be always named either using the "AS" clause or the derived column list. Else, the user will get 11073 error. select * from (select sum(advance) from titles) d1 will get 11073 error. Rewrite as: select * from (select sum(advance) from titles) d1(a1) or: select * from (select sum(advance) as a1 from titles) d1

CR:334069

CR Number:   334069 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2003 Fixed Description Re-loading the Job Scheduler sequencer code by multiple stop / start operations can cause corruption within the JS Task sequencer memory table resulting in Job Scheduler Task violations such as Segmentation violations or Bus errors. When this happens the only way to restart the Job Scheduler is by rebooting ASE.

CR:334075

CR Number:   334075 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) 20 Nov 2003 Fixed Description sp_configure output gives "number" as the units for "i/o accounting flush interval". It should be "clock ticks".

CR:334087

CR Number:   334087 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2008 Fixed Description New feature request to provide allocation information for SYSGAMS when the command DBCC GAM is executed with the 'check' option.

CR:334132

CR Number:   334132 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) 02 Apr 2004 Fixed 04 Aug 2004 Fixed Description DBCC DBCACHEREMOVE command removes a dbtable for a given database from cache. This command should be used in those cases where open count errors are reported and no active session appears to be using the database. Executing this command may not succeed in all cases, therefore care must be taken when running this DBCC. This command has to be executed by the SA, its syntax is as follows: dbcc traceon(3604) go dbcc dbcacheremove(<dbid>|<dbname>) go Workaround Description  N/A

CR:334170

CR Number:   334170 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   macosx Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2003 Presently Not Targeted For Any Future Release Of This Product Description The up/down arrow keys do not scroll the items in drop down lists on Mac OS X Java 1.4 (1.3 works).

CR:334194

CR Number:   334194 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) 20 Mar 2005 Not a Bug Description sp_object_stats fails to report some deadlocks

CR:334289

CR Number:   334289 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) 01 Oct 2003 Fixed Description Performing an unmount database command in the Sybase Central ASE Plugin immediately after creating a database with the ASE Plugin will fail with the error 'Cannot unmount database 'dbname' because you are not currently in the master database.'

CR:334358

CR Number:   334358 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) 15 Oct 2003 Fixed 23 Oct 2003 Fixed 22 Oct 2003 Fixed Description In rare circumstances, a distributed transaction may be left in an "In Abort Tran" state after one thread of the transaction manager attempts to issue a rollback request for the transaction when another thread was still busy using the transaction. This would typically happen when some sort of error had been encountered by the transaction (for example, an out of locks error). Workaround Description  This error is not particular to running out of locks, but the sequence of events started because of some sort of resource shortage on the server. Remove the cause of the resource shortage as a workaround. See CR description for more info.

CR:334364

CR Number:   334364 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) 17 Apr 2009 Insufficient priority to fix Description Feature request to enhance convert() function with a style for converting to/from th e Julian date format

CR:334445

CR Number:   334445 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) 18 Dec 2003 Bundled Request Description During ASE startup, the following messages appeared together: Successfully initialized the security mechanism 'csfkrb5'. The SQL Server will support use of this security mechanism. Security Control Layer was not initialized. The SQL Server will not support use of any external security mechanisms. The second message which indicates an error occurred was incorrectly displayed. Kerberos had been successfully initialized and would work. This fix avoids the incorrect second message.

CR:334451

CR Number:   334451 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2004 Presently Not Targeted For Any Future Release Of This Product Description An enhancement to allow a transaction to be heuristically completed using dbcc complete_xact() when completion had already been initiated by the transaction manager, but this failed to complete.

CR:334458

CR Number:   334458 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) 22 Oct 2003 Fixed 25 Nov 2003 Fixed Description CIS: timeslice error occurs when SELECT from <proxy table> is interrupted because connection to remote server has been broken. The connection to remote server is broken due to either remote server being shut down or the remote connection being disconnected via 'kill spid' on the remote server.

CR:334499

CR Number:   334499 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2009 Insufficient priority to fix Description Feature request for an is_datetime() built-in function to determine whether a given character string represents a valid datetime value.

CR:334500

CR Number:   334500 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2005 Duplicate Description Feature request for an isnumeric() built-in function to determine whether a given character string represents a valid numeric value.

CR:334547

CR Number:   334547 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2003 Fixed Description Improve the performance of xml value index generation.

CR:334620

CR Number:   334620 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 The DBCC CHECKCATALOG command has been enhanced to perform Sysindexes consistency checking. Errors found by this utility may be fixed using the new DBCC CHECKCATALOG(<dbname>, fix) syntax.

CR:334632

CR Number:   334632 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) 08 Jan 2004 Fixed 20 Jan 2004 Fixed Description When UTF-8 is configured as the server's default character set and a case or accent-insensitive sort order is chosen, variable and database object names are not case or accent-insensitive, and must be specified exactly as they were declared.

CR:334667

CR Number:   334667 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 Jan 2004 Fixed 05 Dec 2003 Fixed Description Kerberos for Solaris 64 platform is now enabled and supported in this release.

CR:334674

CR Number:   334674 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) 30 Jan 2004 Bundled Request Description Enhance the sp_shmdumpconfig stored procedure to report the total amount of server memory used by data caches, procedure cache and server data sturctures. This can be used to estimate the size of shared memory dump files.

CR:334695

CR Number:   334695 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) 06 May 2004 Presently Not Targeted For Any Future Release Of This Product Description Feature Request that Rep Agent Thread should not send empty BEGIN or COMMIT log records to RepServer when ASE session has "set replication off" enabled.