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

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

CR:483575

CR Number:   483575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2007 Fixed 09 Nov 2007 Reservation Made Description In some cases when a query plan for an UPDATE query uses the general OR strategy (as can be seen by the presence of a RIDJoin operator in the showplan output), the updates to the qualifying rows may be done in deferred mode when direct mode is possible (also seen in the showplan output). This could result in performance degradation in highly concurrent systems.

CR:483585

CR Number:   483585 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed 05 Jan 2008 Fixed 19 Dec 2007 Fixed 17 Jan 2008 Fixed 21 Jan 2008 Fixed Description Extend UPDATE STATISTICS command to indicate out of range histogram adjustment to be enabled or disabled at the column level. Optdiag output is also enhanced to display this information.

CR:483586

CR Number:   483586 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2007 Fixed 26 Nov 2007 Fixed 16 Nov 2007 Fixed Description A query using parallel threads may get a stack trace including the function pipe_emptypipe().

CR:483614

CR Number:   483614 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2008 Fixed Description A cluster with instances booted with -m parameter may violate the single user mode restriction by allowing more than one instance running at the same time.

CR:483642

CR Number:   483642 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2008 Presently Not Targeted For Any Future Release Of This Product One-off 07 Jan 2008 Fixed 07 Jan 2008 Fixed 15.0.3 28 Mar 2008 Fixed Description No error messages or trace information is available when the High Availability agent for ASE on Windows/MSCS cluster decides to failover sometimes. Target Version  One-off

CR:483733

CR Number:   483733 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2007 Fixed 30 Oct 2007 Fixed 30 Oct 2007 Fixed Description When 'Unknown' is chosen as the LicenseType during installation ASE fails to obtain a license and reports a message similar to 'SySAM: Failed to obtain 1 license(s) for ASE_CORE feature with properties 'PE=EE;LT=Un'. Target Version  15.0.2 ESD#2 Workaround Description  If ASE is still running, execute the following command from isql: sp_lmconfig 'license type', null If ASE can no longer be started, then manually edit ASE's property file at: $SYBASE/ASE-15_0/sysam/<servername>.properties and remove the following line: LT=Unknown

CR:483739

CR Number:   483739 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2007 Fixed 01 Nov 2007 Fixed Description DDLGen does not generate sp_dboption and sp_changedbowner statements with create database statements.

CR:483740

CR Number:   483740 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2010 Fixed Description sp_object_stats creates table syslkstats in tempdb. On a very busy server with a busy tempdb it can deadlock or cause contention for other tempdb users. So Customer would like the ability for sp_object_stats to create tables in a user defined tempdb instead.

CR:483765

CR Number:   483765 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2007 Fixed Description Repagent does not send structured token for unsigned integer identity datatypes.

CR:483790

CR Number:   483790 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2007 Fixed Description The row_count() built-in command may not return accurate results when executed for the Sybsecurity..Sysaudits tables. Workaround Description  Execute the command of update statistics on the problematic tables.

CR:483899

CR Number:   483899 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When in an explicit user transaction, certain server errors/actions will implicitly abort the running transaction. We would like a list of such errors so that one can provide the proper programming/actions for the vast majority of the errors without extra interactions with the server to know that the ransacation was aborted. Workaround Description  program error handlers to look at @@trancount, @@transtate on all unknown messages.

CR:483920

CR Number:   483920 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2008 Fixed Description Performance regression was observed when parallel BCP-IN is happening on two nodes with each node having single engine running.

CR:483963

CR Number:   483963 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2008 Fixed 13 Apr 2008 Not reproducible with latest version of the product available as of Resolution Date Description In some cases, outer join on view or derived table with CASE expression may perform slower due to view materialization. Workaround Description  The workaround is to use traceflag 4419..

CR:483972

CR Number:   483972 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2007 Fixed Description Documentation: Dataserver -Z is not included in the utility guide, but it is in dataserver -h help command output.

CR:483983

CR Number:   483983 Product Name:   Adaptive Server Enterprise Product Component:   SQL Expert Status:   Closed OS:   Windows XP Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2007 Fixed Description The SQL Expert and Database Expert query optimizer option generates a message saying "Table does not exist" when used with ASE 15.0.2.

CR:483985

CR Number:   483985 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Windows W2k Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2007 Fixed Description Server Config leaves the ASE in shutdown state after a failed upgrade if the upgrade eligibility tests fail.

CR:483987

CR Number:   483987 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2007 Fixed Description Add recompilation information in showplan output for cached statements and stored procedures.

CR:484000

CR Number:   484000 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a new resource limit on locks Workaround Description  For queries with the potential to use many locks, the LOCK TABLE command can be used prior to the query to ensure a table lock is used rather than large numbers of page/row locks.

CR:484005

CR Number:   484005 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2007 Fixed Description After a CT-Lib application opens a transaction across 21 or more databases and calls ct_cancel(CS_CANCEL_ALL), Adaptive Server reports a stack trace with signal 11 in 'plc__flush' when the transaction is rolled back.

CR:484028

CR Number:   484028 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2007 Fixed 18 Nov 2007 Fixed Description Encountered error msg 3532 when any user (including sa) logins for the first time after servers are upgraded to 1502 and they are configured for HA.

CR:484059

CR Number:   484059 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1_GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2013 Fixed Description Cluster failed to start after creation if interfaces path contains "#".

CR:484075

CR Number:   484075 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2007 Fixed 01 Nov 2007 Fixed Description A statement that references a temporary table with a prefix (e.g. dbo.#t1) will be cached in the statement cache. This is not currently expected or supported.

CR:484076

CR Number:   484076 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2008 Fixed 14 Mar 2008 Fixed Description Under some circumstances the execution of a stored procedure which uses execute immediate for creating other stored procedures and had to be recompiled maybe be aborted reporting in the errorlog the message "current process infected with 11" in the module 'set_cast' including a stack trace which includes the modules 's_renormalize' and 's_recompile'. Workaround Description  Use trace flag 7710 or recreate procedures.

CR:484090

CR Number:   484090 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2007 Fixed Description Costing issues occur when 2 or more tables are involved in a semijoin. The costing of EXISTS flattened queries or implicit EXISTS queries (as was the case in this query, where the query was converted into and EXISTS query) was overly optimistic in cases where more than one table participates in the existence joins. In particular, the fast first rows costing used for EXISTS queries, underestimated the number of outer rows for some of the nested loop join operators, and underestimated some of the scan costs for the inner tables/indices of a nested loop join involved in a EXISTS (or semi-join). The change puts some lower bounds on the fast first row costing so that the outer row counts are consistent with the overall cardinality estimate of the semi-join group (a semi join group is a set of 2 or more tables that together are transformed into a multi-table semi-join in the show plan output). Workaround Description  use abstract plans on the problem query

CR:484098

CR Number:   484098 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2008 Consult Complete 13 Nov 2007 Fixed 04 Dec 2007 Fixed 06 May 2008 Fixed Description HA VCS 4.x: Enhanced diagnostics information for the VCS4.x HAase Agent. Also fixed a possible hostname comparison failure when one hostname obtained is short form of the hostname, and another is a fully qualified hostname with tailing domain name.

CR:484108

CR Number:   484108 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2009 Insufficient priority to fix Description Allow classes compiled with jdk 1.4 to be loaded into ASE 12.5.4 Workaround Description  none

CR:484141

CR Number:   484141 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2007 Fixed 07 Nov 2007 Fixed 07 Nov 2007 Fixed Description For DISTINCT view with some distinct expression column, SELECT on such view could raise Assertion (_SrtTcIdBm.VbmDisjoint(*pConstSargs)) failure. Also one further SELECT DISTINCT on such DISTINCT view could lead to some stacktrace during code generation.

CR:484168

CR Number:   484168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2007 Duplicate Description Java functions that worked in ASE 12.5.4 are returning NULL in 15.0.2

CR:484236

CR Number:   484236 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2008 Fixed 17 Aug 2005 Not a Bug Description Can't create 16k ASE Server for Linux x86 on ASE_DEV licenses. This issue is reproduced by ASE SmallBusinessEdition and Developer Edition. Workaround Description  When using SBE,Please register an ASE_SBE license into SySAM License Server.

CR:484270

CR Number:   484270 Product Name:   Sybase ETL Product Component:   pEngine Status:   Open OS:   Linux Red Hat Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2008 Workaround Description Problem: ETL server shut down unexpectedly when using ODBC connection type with Sybase IQ on line. Resolution: This problem is a result of improperly configured ODBC.ini configuration file. The CommLinks property needs specific syntax: Incorrect Property syntax: CommLinks=tcpip(host=host-machine-name,port=4454) There are 2 choices for Correct Property syntax: first: CommLinks=tcpip(host=host-machine-name;port=4454) second: CommLinks=tcpip(host=host-machine-name,4454)

CR:484271

CR Number:   484271 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2007 Fixed 06 Nov 2007 Fixed Description select statement on a proxy table expects a table name for a union even though it doesn't need to.

CR:484306

CR Number:   484306 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2009 Fixed Description Sybmigrate does not recognize source databases that have XPDL bits set. Workaround Description  To be sure this CR is the issue, the value of sysdatabases.status3 for the database(s) in question should be at least 786432. The work-around has 2 steps: 1. Be absolutely sure that 'sp_post_xpload' has been run against the database(s) in question. 2. Manually update sysdatabases.status3 for the database(s) and reset the following bits: DBT3_XPLOAD 0x00040000 (= 262144 dec) DBT3_XPLOAD_DONE 0x00080000 (= 524288 dec) Subtract 786432 from the current value of sysdatabases.status3 and set status3 to the resulting value .

CR:484310

CR Number:   484310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2007 Fixed 07 Nov 2007 Fixed Description For large joins, sometimes different final plan could be given when a particular optgoal is set through the abstract plan "plan" clause versus at the session or server level.

CR:484346

CR Number:   484346 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2007 Fixed 09 Jan 2008 Bundled Request Description ASE cannot use multiple per-CPU unserved licenses, instead limiting the 'max online engines' configuration to the value of the CP license attribute of the first license it finds. Target Version  15.0.2 ESD#2

CR:484352

CR Number:   484352 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2007 Fixed Description sp_who displays site handler as having master rather than the default tempdb as it's tempdb

CR:484353

CR Number:   484353 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2008 Fixed Description Unexpected exception is reported in the space_est report when it tries to estimate the space for a proxy table on a remote host that is down. Workaround Description  Start the remote server and ensure that the remote table def is online.

CR:484362

CR Number:   484362 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2007 Fixed 23 Dec 2007 Reservation Made Description On systems with large procedure cache (> 100 M-bytes), ASE may scale down its memory allocation to smaller chunks when the procedure cache is full and fragmented. A command line trace flag -T757 is introduced to have ASE first replace an unused stored procedure, before scaling its memory allocation down to smaller chunks.

CR:484375

CR Number:   484375 Product Name:   Sybase ETL Product Component:   GUI Status:   Open OS:   Windows 2003 Original Version:   Bilbo Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Problem: When inserting multi-byte characters into a UTF-8 collation DB, it can appear inserted data is missing. For example: If the target column is defined as CHAR(10) and you have 5 characters that you believe are 2 byte characters but you notice some are missing. (2 bytes * 5 characters = 10 bytes). Resolution: UTF-8 can represent 1-3 byte characters. If some characters are 3 byte characters the total length calculations will need to take this into account.

CR:484401

CR Number:   484401 Product Name:   Sybase ETL Product Component:   Installer Status:   Closed OS:   Windows 2003 Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2007 Presently Not Targeted For Any Future Release Of This Product Description Problem: The IQ ETL Development default installation path refers to 4.2.1 ESD #1 instead of 4.2.1 ESD #2 as expected to match the release vehicle. Workaround: The installation directory can be manually changed to another directory if desired.

CR:484501

CR Number:   484501 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2007 Fixed 24 Jun 2008 Presently Not Targeted For Any Future Release Of This Product 19 Nov 2007 Fixed Description Previously, result sets generated by a statement with an explicit owner name were not editable. Now they are. (Before this change, the result set generated by: SELECT * FROM mytable would be editable, but the result set generated by: SELECT * FROM dba.mytable was not.) Previously, when a statement returns more than 10 result sets, DBISQL displayed only the first 10 silently in grid mode. Now DBISQL will display a dialog with the following message: "The statement returned more than 10 results set, but only the first 10 have been displayed."

CR:484524

CR Number:   484524 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2008 Fixed 26 Feb 2008 Fixed 27 Feb 2008 Fixed Description In a multi instance cluster, builtin function row_count() may output different values when executed from different instances.

CR:484549

CR Number:   484549 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2007 Fixed 03 Apr 2009 One-off Provided 11 Mar 2008 Fixed Description Explicit or implicit convertion of java datatypes may someties lead to the corruption of the query plans.

CR:484581

CR Number:   484581 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2007 Fixed Description Sysdatabases.audflags and Sydatabases.deftabaud fields may not be properly initialized after the command 'LOAD DATABASE' has been executed.

CR:484615

CR Number:   484615 Product Name:   Sybase ETL Product Component:   Installer Status:   Closed OS:   Windows XP Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2008 Presently Not Targeted For Any Future Release Of This Product Description Problem: When upgrading from 4.2 or 4.2.1 ESD #1 to 4.2 ESD #1 or 4.2.1 ESD #2 it might appear your previous 4.2 default ETL repository is missing. Workaround: Upgrading from 4.2 to 4.2 ESD #1 or from 4.2.1 to 4.2.1 ESD #2 changes the location of the default local MS Access ETL repository file. The ETL 4.2 uses a local MS Access repository (ETLDEMO_REP.mdb)in the Windows users ..\Documents and Settings\<USER> directory. After upgrading to the ESD the user must copy this ETLDEMO_REP.mdb file to the ESD installation\Demodata directory to access previously stored jobs and projects.

CR:484631

CR Number:   484631 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2007 Bundled Request Description A query plan that applies dynamic partition elimination will have a showplan output that contains the following lines: | |SCAN Operator (VA = 0) | | FROM TABLE | | rv3 | | [ Using Dynamic Partition Elimination ] | | Table Scan. | | Forward Scan. If the query plan is re-executed (i.e. it's in a stored procdedure), the showplan output for the second and subsequent executions will show extraneous lines of output beginning with "{ Eliminated Partitons", such as: | |SCAN Operator (VA = 0) | | FROM TABLE | | rv3 | | [ Eliminated Partitions : 1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 ] | | [ Eliminated Partitions : 1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 [ Using Dynamic Partition Elimination ] | | Table Scan. | | Forward Scan.

CR:484655

CR Number:   484655 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2008 Fixed Description Support dbcc stacktrace for remote spids. The command must be run on the same instance as the spid in order for the client to receive output.

CR:484684

CR Number:   484684 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2007 Fixed 15 Nov 2007 Fixed Description In rare circumstances, there may be locks of a process that is not in Adaptive Server anymore. Workaround Description  Since 15.0.2esd1, for joins of 6 tabs or more, we use the legacy optimizer as greedy algorithm. Turn on trace 15363 to disable using the legacy optimizer for greedy.

CR:484707

CR Number:   484707 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed Description When using bcp -C to load data into a table with an encrypted column that has a declarative or bound default, the bcp-in operation may fail. The ASE error log may contain a stacktrace containing: infected with signal 11 in col_encrypt.

CR:484713

CR Number:   484713 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2007 Fixed Description When executing a query plan in which the optimizer has chosen to use a general OR strategy (as can be seen by the presence of a RIDJoin Operator in the showplan output) and where the table being scanned has a datarows lockscheme, row level locks will not be released once the rows have been read. The accumulation of these row locks can lead to escalation to a shared table lock if the configured row lock promotion threshhold is exceeded. Workaround Description  In some cases, increasing the 'row lock promotion' threshhold configuration parameter can help.

CR:484769

CR Number:   484769 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2007 Fixed 12 Nov 2007 Fixed 28 Nov 2007 Fixed Description The message "Current process ... infected with signal 11" may be reported in the error log in module 'mda__process_sdes' followed by a stack trace when a query on the monProcessObject table is run, resulting in ASE shutting down itself. The modules 'mda_std_populate_pid' and 'mda_fill_and_send_monProcessObject' will also be reported in the stack trace. Workaround Description  A workaround for this is to refrain from querying monProcessObject

CR:484783

CR Number:   484783 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2009 Duplicate Description Customer is hitting 3151 errors "Adaptive Server cannot load this database because the database that was dumped was not quiescent when the dump was performed. Run sp_flushstats before DUMP DATABASE and ensure that the database is not updated during the dump." when loading large database dumps using XPDL. Unfotunatly this error is not hit until a large amount of processing has already taken place on a dump and a large amount of time therefore gets wasted just to find out a dump is useless. Customer would like an enhancement to the dump command to make sure that the dump produced will load correctly under XPDL without giving a 3151 (or any other) error. Customer would also like a corresponding enhancement to load database to make sure that a load can be succesfully loaded via XPDL without having to go through the lengthy processing to find this out. Customer is currently using 12.5.4 and would like these enhancements in the 12.5.x codeline.

CR:484797

CR Number:   484797 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2007 Presently Not Targeted For Any Future Release Of This Product Description Procedures, triggers, defaults, etc. whose source code has been hidden using sp_hidetext cannot be successfully migrated to other platforms using cross-platform dump and load.

CR:484805

CR Number:   484805 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2008 Fixed 18 Mar 2008 Fixed Description Numeric modulo function can generate wrong result when aggregate functions are involved in the calculation.

CR:484808

CR Number:   484808 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2007 Not a Bug Description ASE 12.5.4 esd 3 CIS is sending all uppercase sql when querying tables created with create proxy_table. It does not happen if they use create existing table. Target Version  To Be Determined Workaround Description  use create existing instead of create proxy

CR:484811

CR Number:   484811 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2009 Fixed Description Sybmon can't load memdump file smoothly on linuxamd64 platform.

CR:484828

CR Number:   484828 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2008 Fixed 14 Jan 2008 Fixed 07 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description A 605 error "An attempt was made to fetch logical page '<pageid>' from cache '<cache_name>'. Page belongs to database <ptninfo> and not to <ptninfo> may sometimes happen after crash recovery.

CR:484865

CR Number:   484865 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2007 Fixed Description For large join (>50 tables), stack overflow might happen during the recursive call of SeHyPermStrat::_SeHyPsPrime() when stack size is not large enough.

CR:484912

CR Number:   484912 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2007 Fixed 07 Dec 2007 Fixed 19 Dec 2007 Fixed 16 Dec 2007 Fixed Description 102, 156, 11031, 11032, 11034 or other similar error is returned when a compiled object with hidden source text is executed after database is loaded across platform where the byte order(endian type) is different.

CR:484923

CR Number:   484923 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed 07 Jan 2008 Not a Bug Description Under the following conditions: - A cursor is declared with a SELECT statement that contains either an IN-list or OR-clauses on the same column, such as DECLARE curs1 CURSOR FOR SELECT id FROM sysobjects WHERE id IN (1,2,3); and - The optimizer chooses a special OR strategy for the query plan, as can be seen in the showplan output by the presence of 'FROM OR List'; and - The cursor is OPEN'd and FETCH'd at least once; and - The row that the cursor is currently positioned on is deleted, either through a searched DELETE command or a searched UPDATE command that causes the row to move. A 582 error will be raised if another FETCH command is issued on the cursor. Workaround Description  force the clustered, unique index "test_jrnl_ctrl_idx" in ASE 15.0.x

CR:484927

CR Number:   484927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2009 Workaround Description 15.0.2 optimizer produces a much slower plan than 12.5.x for some cases involving very skewed data. Workaround Description  (rs June 20 2008) another workaround could be to re-write the query. The following re-write can be used. NOTE: The following re-write assumes that JIE.J_ADDL_COST_UUID is a NON-NULLable column. it has to be verified before applying this re-write. Original Query ================ select J_O.J_ORDR_UUID C1_J_ORDR_UUID from J_ORDR_BASIC J_O where (1=1) And (J_O.J_ORDR_TYPE='Non-Transportation') And (EXISTS (SELECT 1 FROM J_ORDR_BASIC A1,N_T_ORDR B1,J_ADDL_COST C1 WHERE A1.J_ORDR_UUID=J_O.J_ORDR_UUID AND A1.J_ORDR_UUID=B1.J_ORDR_UUID AND B1.N_T_ORDR_UUID=C1.J_ADDL_COST_OWNER_UUID AND CONVERT(DATETIME,CONVERT(CHAR(10),C1.ACTVY_DT_LOC,101))<='10/09/2007' AND C1.ACTVY_DT_LOC>'10/01/2007' AND NOT EXISTS (SELECT 1 FROM J_ORDR_INV_ITEM_ENTRY JIE, J_ORDR_INV JI WHERE JIE.J_ADDL_COST_UUID=C1.J_ADDL_COST_UUID AND JIE.J_ORDR_INV_UUID=JI.J_ORDR_INV_UUID AND JIE.NATURE='Non-Transportation' AND CONVERT(DATETIME,CONVERT(CHAR(10),JI.READY_TO_EXTRACT_DTE_LOC,101))<='10/09/2007' ) ) ) And (J_O.STATUS IN ('Open','Completed')) And (RTRIM(J_O.VENDOR_CDE) IS NOT NULL) Re-written Query ================= select J_O.J_ORDR_UUID C1_J_ORDR_UUID from J_ORDR_BASIC J_O where (1=1) And (J_O.J_ORDR_TYPE='Non-Transportation') And (EXISTS (SELECT 1 FROM J_ORDR_BASIC A1 , N_T_ORDR B1 , J_ADDL_COST C1 LEFT OUTER JOIN (J_ORDR_INV_ITEM_ENTRY JIE INNER JOIN J_ORDR_INV JI ON JIE.J_ORDR_INV_UUID = JI.J_ORDR_INV_UUID AND CONVERT(DATETIME,CONVERT(CHAR(10),JI.READY_TO_EXTRACT_DTE_LOC,101))<='10/09/2007' ) ON C1.J_ADDL_COST_UUID = JIE.J_ADDL_COST_UUID AND JIE.NATURE='Non-Transportation' WHERE A1.J_ORDR_UUID=J_O.J_ORDR_UUID AND A1.J_ORDR_UUID=B1.J_ORDR_UUID AND B1.N_T_ORDR_UUID=C1.J_ADDL_COST_OWNER_UUID AND CONVERT(DATETIME,CONVERT(CHAR(10),C1.ACTVY_DT_LOC,101))<='10/09/2007' AND C1.ACTVY_DT_LOC>'10/01/2007' AND JIE.J_ADDL_COST_UUID IS NULL ) ) And (J_O.STATUS IN ('Open','Completed')) And (RTRIM(J_O.VENDOR_CDE) IS NOT NULL) (rs June 13 2008) This seems to be an issue with high data skew in one of the tables which is inside the sub-query in the query. running 'sp_modifystats "J_ORDR_INV_ITEM_ENTRY", "J_ADDL_COST_UUID" REMOVE_SKEW_FROM_DENSITY' could be a workaround to fix the issue. I have verified in the in house repro that it indeed fixes the issue.

CR:484952

CR Number:   484952 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2007 Fixed Description A view that uses a SQL UDF will get a 225 error after the SQL UDF is dropped and recreated. Workaround Description  re-create the view with a drop view , create view and it works again...

CR:484953

CR Number:   484953 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1_GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2012 Fixed 01 Aug 2012 Fixed 18 Sep 2012 Fixed Description Sybcluster show instance status does not show correct status if shutdown instance outside sybcluster immediately.

CR:484965

CR Number:   484965 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2007 Fixed 10 Dec 2007 Deferred Description If you reference a global variable in a procedure and then (using dynamic sql) create another procedure which also uses that same global variable then the reference to the variable in the child proc gets incorrectly resolved. Executing the child procedure results in a stacktrace. Errorlog stack trace will included reference to modules s_setupvar and s_cpparamd.

CR:484968

CR Number:   484968 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2008 Fixed Description Error 100039 may occur when index is created by altering large table with a primary constraint. Workaround Description  Run reorg rebuild to update new oam entries.

CR:484969

CR Number:   484969 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Nov 2007 Fixed 16 Nov 2007 Fixed Description ASE may mistakenly report "Page 0 was given as a target page for allocation to object <value> index id <value> and there is no entry in the OAM for this page." when running DBCC CHECKALLOC, TABLEALLOC, INDEXALLOC or TEXTALLOC with the FIX option. This error is seen when OAM entries with zero used/unused page counts have been deleted. Workaround Description  Ignore the message "Page 0 was given as a target page for allocation to object <value> index id <value> and there is no entry in the OAM for this page. This may indicate corruption of the OAM. Please run checkalloc on database <value>."

CR:484982

CR Number:   484982 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) 22 Jan 2008 Fixed 07 Feb 2008 Fixed 19 Feb 2008 Fixed 02 Apr 2008 Fixed Description When long running chained transactions are left active in the database, even though they have not done any DMLs, they may prevent housekeeper from doing garbage collection in the database. Workaround Description  i) Reorg rebuild, compact, and reclaim_space ii) commit/rollback old chained transactions

CR:484991

CR Number:   484991 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2008 Fixed Description Queries against a semantically partitioned table, where the predicate on the partition key column involves a local variable, did not perform partition elimination when the statement is executed inside execute-immediate. With this fix, partition elimination is enabled, resulting in increased performance.

CR:484997

CR Number:   484997 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2007 Bundled Request Description A stack trace occurred in csi_malloc when using LDAP UA due to memory leaks.

CR:485001

CR Number:   485001 Product Name:   Adaptive Server Enterprise Product Component:   sql Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2007 Fixed 26 Aug 2008 Presently Not Targeted For Any Future Release Of This Product 15 Jan 2008 Fixed 20 Jan 2008 Fixed 21 Jan 2008 Fixed 20 Jan 2008 Fixed 19 Feb 2008 Fixed 03 Mar 2008 Fixed 28 Feb 2008 Fixed 02 Mar 2008 Fixed 07 Mar 2008 Fixed 30 May 2008 Duplicate 10 Mar 2008 Fixed 02 Jun 2011 EOL'd version. Not to be Fixed. Description This a new platform support for ASE.

CR:485070

CR Number:   485070 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Open OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The process of creating a cluster involves several components - The quorum device, the interfaces entries, the data devices, and the Unified agent plugins to manage the instances. When the creation process is aborted or fails midway, some of these components may have been created. Before retrying to create the cluster, you must clean up what was affected from the previous process. When using raw devices, the quorum device and data devices do not need to be removed. 1 Stop the srvbuildres or dataserver utilities, if either are running. 2 Stop the UAF agents on all nodes. 3 Remove the directory with the name of the cluster you tried to create during the wizard session in the $SYBASE_UA/nodes/node_name/plugins/cluster_name directory. 4 Remove the interfaces file entries for the cluster you tried to create. 5 Restart the UAF agents on all nodes. Workaround Description  *** Thursday, March 13, 2008 9:15:46 AM *** nga *** The process of creating a cluster involves several components - The quorum device, the interfaces entries, the data devices, and the Unified agent plugins to manage the instances. When the creation process is aborted or fails midway, some of these components may have been created. Before retrying to create the cluster, you must clean up what was affected from the previous process. When using raw devices, the quorum device and data devices do not need to be removed. 1 Stop the srvbuildres or dataserver utilities, if either are running. 2 Stop the UAF agents on all nodes. 3 Remove the directory with the name of the cluster you tried to create during the wizard session in the $SYBASE_UA/nodes/node_name/plugins/cluster_name directory. 4 Remove the interfaces file entries for the cluster you tried to create. 5 Restart the UAF agents on all nodes.

CR:485080

CR Number:   485080 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2008 One-off Provided 12 Mar 2008 One-off Provided Description Instrumented ASE to help diagnose when ASE hangs in accept() and sometimes close(). Problem has not reoccurred since disabling the 3rd party product iwatchip.

CR:485091

CR Number:   485091 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2008 Not reproducible with latest version of the product available as of Resolution Date Description Cluster will shutdown if there is a port conflict in the cluster configuration.

CR:485117

CR Number:   485117 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2007 Fixed 05 Dec 2007 Fixed Description Long execution times for dbcc commands checktable and checkalloc against an archive database.

CR:485167

CR Number:   485167 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2007 Fixed 07 Dec 2007 Fixed Description Creating clustered index on roundrobin partitioned table might result in skewed partitions.

CR:485205

CR Number:   485205 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2007 Fixed 21 Dec 2007 Fixed Description More efficient processing of histograms will reduce the amount of procedure cache needed for optimization of simple queries.

CR:485209

CR Number:   485209 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2010 Not a Bug Description When a high volume of SSL connections login and logout the Network Buffer Pool can leak memory. The observerd SSL connection were from a jConnect multi-threaded application and the memory leaks were in 80 byte chunks. Eventually, SSL users cannot login to the dataserver. Workaround Description  Avoid explicitly closing the jConnect connections if possible.

CR:485210

CR Number:   485210 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2007 Fixed Description When a distinct outerjoin view is used in a query with another outerjoin, The Assertion (!_pGcojLegacyRgInfo || pOjRgInfo == _pGcojLegacyRgInfo || pGt->GtIsValues()) might fail for the diagserver. For non-diagserver, search engine could generate wrong outerjoin plan or gets into excessive compilation time and memory consumption for large join.

CR:485214

CR Number:   485214 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Report temporary DB space usage HWM for a session in monSysStatement

CR:485255

CR Number:   485255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2007 Fixed 26 Jan 2010 EOL'd version. Not to be Fixed. Description A 8213 error "Failed to acquire address lock on object <value>" may be reported in the error log together with a stack trace which includes the modules "idt_value_verify" and "des_idtnewval" when an INSERT command attempts to create a new identity column value.

CR:485305

CR Number:   485305 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2007 Fixed Description complex multi-table queries with that reference columns with large histograms may experience excessive procedure cache usage, that could eventually result in 701 errors. This change allows more efficient reuse of memory associated with histograms. Workaround Description  use abstract plans, or force the join order

CR:485310

CR Number:   485310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2008 Fixed Description QP Metrics will be captured and dumped to the system catalog if none of the following 4 threshold configuration parameters has been set: metrics elap max metrics exec max metrics lio max metrics pio max However, if there is any among the above 4 thresholds set, only the non-zero values will be effective the thresholds for the QP Metrics. Workaround Description  All four metrics configuration parameters must be set to something other than zero - depends on customer needed thresholds.

CR:485352

CR Number:   485352 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2007 Fixed Description Alter table unpartition on a system catalog lead to inconsistency in internal meta data. This inconsistency will lead to Signal-11 for further reference to the system catalog.

CR:485363

CR Number:   485363 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2009 Insufficient priority to fix Description Bulk insert hits signal 11 when it failed partially on a proxy table due to different in table definition. Workaround Description  Drop and re-create proxy table.

CR:485367

CR Number:   485367 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2007 Fixed 12 Dec 2007 Reservation Made Description Suboptimal join order could be choosen when there is a correlated subquery under an OR predicate and during the actual execution the subquery evaluation is mostly skipped due to shortcircuit logics of the OR predicate. Workaround Description  Use the 12.5.3 abstract plan dump on v15.0.2 query.

CR:485368

CR Number:   485368 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Closed OS:   Windows 2000 Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2011 Presently Not Targeted For Any Future Release Of This Product Description When using the ODBC Interface on a DB Data Provider component; only the system DSNs are able to be selected. The request is to add the capability to use file DSNs as well - much as Sybase Central and dbisql allow.

CR:485373

CR Number:   485373 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2007 Fixed 29 Nov 2007 Fixed Description Small procedural objects may use more procedure cache memory than needed when they are created after a large SQL batch. Workaround Description  Do not create the rule, default, procedure after a large batch.

CR:485395

CR Number:   485395 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Nov 2007 Fixed Description A parser error is raised when reorg rebuild is called on a table with a name requiring quoted identifiers, such as "&A123", and the table contains a text column. Workaround Description  Please name the table without "&" and become "A123456789".

CR:485418

CR Number:   485418 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2007 Fixed Description When partition name is specified by user, the translation from partition name to partition ID will only be done once. Reduce translation times.

CR:485433

CR Number:   485433 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2007 Fixed 19 Nov 2007 Fixed Description When CIS tables are involved in a join query and allrows_oltp is the optimization goal, ASE may generate a 325 error that says that there is no legal query plan available for this query.

CR:485442

CR Number:   485442 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2007 Fixed Description Apply 'set sort_resources on' also to 'update statistics', so that user can get information of the size of the worktable to be sorted without really exec the command. The size of procedure cache used by sort can be calculated using a rough formula: Number of sort buffers X rows per page X 100.

CR:485458

CR Number:   485458 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2008 Workaround Description Table scan is chosen over Non-Clustered index scan with 16k IO pool is configured. Workaround Description  Setting traceflag 397 will result in the expected query plan; the same query plan as generated in ASE 12.5.0.7.

CR:485461

CR Number:   485461 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2008 Fixed 22 Jan 2008 Fixed 04 Jul 2008 Fixed 08 Jul 2008 Fixed Description In some circumstances the process accounting statistics (I/O and CPU) are not updated when an end-user logs out of Adaptive Server. Workaround Description  Workaround for CR#214670 is still valid, "Set the accounting flush intervals to 1 although this incurs the overhead of a call to acct_stats() and the opening of syslogins"

CR:485484

CR Number:   485484 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2008 Fixed Description Add "Skip" and "Cancel" Buttons on the "Validating Cluster Name" dialog.

CR:485554

CR Number:   485554 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2007 Fixed Description When ASE takes a very long time to recover databases before upgrade, the upgrade utility can find databases marked "offline". If that situation persists beyond its timeout wait period, it declares an error, which causes batch mode upgrade to fail. We are making the per-database timeout wait period configurable via "-T{wait_time}", where wait_time is specifiable as (for example) "-T300s" for "300 seconds". 's' is the default. The upgrade utility also accepts (m)inutes, (h)ours, or (d)ays as the -T interval. Workaround Description  Manual upgrade.

CR:485623

CR Number:   485623 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2008 Fixed 02 Mar 2008 Fixed Description MDA Tables such as monProcessStatement may list processes that are not listed in the sysprocesses table.

CR:485628

CR Number:   485628 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2007 Fixed Description select-into a proxy table mapped to a file fails when the proxy table contains a timestamp column.

CR:485654

CR Number:   485654 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2007 Fixed 28 Nov 2007 Fixed 30 Nov 2007 Fixed 30 Nov 2007 Fixed Description srvbuild converts self management user password char into singlequotes.

CR:485661

CR Number:   485661 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2008 Fixed Description When a query on a base table with partitions is executed, and if some of its partitions are eliminated, the parallelism degree reported in the 'Abstract plan' might be incorrect.

CR:485709

CR Number:   485709 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2008 Bundled Request Description Quorum error 39 is reported while creating a cluster when some elements in the cluster input file are exactly the maximum allowed length. For example, using a cluster name of 30 characters will report the following error: "Quorum library error 39: Value for token 'name' exceeds the maximum length of 30 bytes."

CR:485724

CR Number:   485724 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2008 Fixed 26 May 2008 Fixed Description When the user selects multi-nodes in CCW page two, check if all the selected nodes have a common $SYBASE home. If not, popup a error message dialog.