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

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

CR:471372

CR Number:   471372 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2007 Fixed 02 Aug 2007 Fixed 22 Jul 2007 Fixed 23 Jul 2007 Fixed 05 Sep 2007 Fixed Description A new featrue， IPv6 supported has been added to dataserver.

CR:471427

CR Number:   471427 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) 15 Jun 2007 Fixed Description Error 7128 "Text pointer value <value> references a data page which is no longer allocated." may be reported during the execution of a DELETE command when there is a delete TRIGGER using the builtin DATALENGTH on a TEXT/IMAGE column.

CR:471445

CR Number:   471445 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 Jun 2007 Fixed Description create proxy_table with unichar/univarchar/unitext columns fails with a column length mismatch error for DirectConnect/SDS servers.

CR:471458

CR Number:   471458 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2007 Fixed 09 Jul 2007 Fixed Description Sometimes, ASE ignores the set of update statement and generates the incorrect results.

CR:471488

CR Number:   471488 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2008 Duplicate Description Query performance degredation in ASE 15 versus 12.5.4 and other databases

CR:471491

CR Number:   471491 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2007 Fixed 10 Jul 2007 Fixed Description Error msg 15417 with error code 57629 may arise if selecting a column multiple times from a view, with the column being derived from a subquery on encrypted columns.

CR:471501

CR Number:   471501 Product Name:   Sybase Central Product Component:   SQL Server Management Status:   Open OS:   Microsoft Windows NT Original Version:   5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Jagmanager can't deploy java CORBA class compiled using JDK 1.5

CR:471531

CR Number:   471531 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) 11 Jul 2007 Fixed 06 Jun 2008 Fixed 23 Jun 2008 Fixed Description In rare circumstances, a signal 11 may occur while ASE resolves the max message length a MQ Queue object can store. The top of the stack trace is function rtms_open_endpt (before signal handling processing) in that specific case. Workaround Description  Run ASE with 2 engines (including the Q engine).

CR:471566

CR Number:   471566 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) 15 Jun 2007 Fixed 10 Jul 2007 One-off Provided Description A session may be holding an EX_INT lock on syslogins table for too long when the configuration parameter "cpu accounting flush interval" or "i/o accounting flush interval" is established with a small value such that ASE needs to update syslogins table rather frequently. Workaround Description  Run dbcc lock_requeue("table",1,33) to try unblock this situation, and/or set the configuration parameter "cpu accounting flush interval" to a big value such that ASE avoids to frequently update table syslogins. The same stands for "i/o accounting flush interval" parameter.

CR:471590

CR Number:   471590 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) 17 May 2013 Presently Not Targeted For Any Future Release Of This Product Description Error 206 is raised on some group by queries on tables with a clustered index when traceflag 450 is on and the server is configured for parallelism. Possible workarounds include converting the clustered index to a nonclustered index and turning off parallelism at the session level with "set parallel_degree 1" Workaround Description  [bret 12/2012] Possible workarounds: 1) Convert clustered index to nonclustered 2) unconfigure parallelism / worker processes 3) use "set parallel degree 1" at the session level before the select.

CR:471600

CR Number:   471600 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2007 Fixed Description The message "Current process is infected with SIG-11" in the module "oj_xform_oj_case" is reported in the errorlog if a SELECT query using Outer joins, views with CASE statements and variables is executed.

CR:471604

CR Number:   471604 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 Jul 2007 Fixed 11 Jul 2007 Fixed Description A query involving several outer joins could return incorrect results if WHERE clause references columns from one of the inner outer joins.

CR:471662

CR Number:   471662 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) 11 Dec 2007 Fixed 12 Dec 2007 Fixed 08 Jan 2008 One-off Provided Description If a view column's definition contains a subquery, such as: CREATE VIEW v1 AS SELECT col1 = (SELECT name FROM t2 WHERE t2.id = t1.id) FROM t1 and this column appears on the left side of an IN-expression that contains a subquery on it's right side, such as: WHERE v1.col1 IN (SELECT ...) Query execution may be aborted with a segmentation fault in the function, QpConstGetGc() and a stack trace that contains GtqSingleSubqScan::GtInterestingTcIdBm().

CR:471674

CR Number:   471674 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2007 Fixed 28 Mar 2008 Fixed Description A 835 error (Illegal attempt to change contents of buffer) may be reported on Linux 32-bit systems, if the extended cache is enabled. This CR fixes the problem.

CR:471693

CR Number:   471693 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2007 Fixed Description Job Scheduler database name is mispelled in error message that reports the login is not a user of the database.

CR:471706

CR Number:   471706 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for the ability to LOAD dumps into a server with a larger page size.

CR:471799

CR Number:   471799 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) 29 May 2010 Insufficient info provided Description reject final plans not having the requested properties, avoid wrong results

CR:471824

CR Number:   471824 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 Jun 2007 Fixed 25 Jun 2007 Fixed Description Too many rows may be returned by successive cursor FETCH commands if all of the following conditions are met: - A view has an INSTEAD OF trigger for UPDATE or DELETE created on it, - A cursor is declared to select a subset of columns of the view and no other database objects appear in the cursor's SELECT statement, - The cursor's SELECT statement contains either DISTINCT or GROUP BY.

CR:471830

CR Number:   471830 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) 22 Jun 2007 Fixed 25 Jun 2007 Fixed Description Queries that contain a UNION ALL operator with a RESTRICT operator above may produce a SIGBUS error. This is only likely to occur if the RESTRICT operator evaluates an expression where one or more of it's operands are projected from the UNION ALL operator and the operand requires alignment.

CR:471836

CR Number:   471836 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) 18 Jun 2007 Not a Bug Description ALTER DATABASE creates mixed segment fragment despite use of OVERRIDE clause

CR:471842

CR Number:   471842 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2007 Fixed Description EFTS: EFTS attempts to send irrelevant cursor information, when ASE requests "information of active cursor" after an abrupt user disconnect due to time-out or other network issues. Error message "#16281 srv_cursor_props(): Invalid cursor descriptor" is reported in errorlog file.

CR:471860

CR Number:   471860 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2009 Presently Not Targeted For Any Future Release Of This Product Description Introduce a new LDAP configurable parameter which will allow the last available URL to remain active for a configurable period of time.

CR:471927

CR Number:   471927 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 Sep 2007 Fixed Description Default value of tempdb Uer log cache size may lead to increased memory consumption of ASE.

CR:471956

CR Number:   471956 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) 19 Jun 2007 Fixed Description Joins are not sent to DirectConnect/SDS servers if the sp_capabilites value for joins returned by the server is 6 (T-SQL and inner/outer ANSI).

CR:471966

CR Number:   471966 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) 07 Sep 2007 Fixed Description CIS: In rare circumstances, a query with an aggregation and a GROUP BY clause on a same remote column will be passed to the remote server with some incorrect query text and return wrong results

CR:472000

CR Number:   472000 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) 17 Jul 2007 Fixed 18 Jul 2007 Fixed Description When using large buffer pool and large volume of data insert (e.g. bulk copy or select into), a user session may hang forever. You might see functions buf_add_split_iobuf(), bufawrite(), cm_plcunpinall(), xls_bufunpin(), plc__lock->upsleepgeneric() in the call stack of the hanging session. Workaround Description  turn off HDI with traceflag 12302

CR:472019

CR Number:   472019 Product Name:   Adaptive Server Enterprise Product Component:   Language Modules Status:   Closed OS:   Windows W2k Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2007 Fixed 08 Feb 2008 Fixed Description Japanese error messages 7223, 13006 and 13007 are incorrectly translated.

CR:472023

CR Number:   472023 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2007 Presently Not Targeted For Any Future Release Of This Product Description Please change the Japanese translation of %S_MSG of error 7223.

CR:472085

CR Number:   472085 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) 21 Jun 2007 Bundled Request Description Abstract plan of the final plan was being printed out even when the "show_abstract_plan" option is off.

CR:472095

CR Number:   472095 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) 01 Jul 2007 Fixed 03 Jul 2007 Fixed 24 Mar 2008 Presently Not Targeted For Any Future Release Of This Product Description Index may be corrupted with 7930 and 2511 errors when DBCC TUNE "ascinserts" is used with an INSERT SELECT from a table with data that is not in sorted order.

CR:472117

CR Number:   472117 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2008 Fixed Description Add instanceID column to SDC Locks Detail Information Tab.

CR:472181

CR Number:   472181 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2007 Fixed 24 Jul 2007 Fixed 01 Aug 2007 Fixed 13 Nov 2007 Fixed Description The commands DROP, DUMP, LOAD, MOUNT and UNMOUNT were incorrectly scanning all the databases looking for cross references to local encryption keys, even if no encryption keys existed in the affected database.

CR:472260

CR Number:   472260 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 Aug 2008 Fixed 19 Aug 2008 Fixed Description Previously Database Device Wizard asked for device path first before device name. This has been reversed to be more consistent with other wizards.

CR:472272

CR Number:   472272 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) 10 Dec 2008 Fixed Description ASE is not able to use OS supported Huge Page mechanism on Linux platforms.

CR:472361

CR Number:   472361 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2008 Fixed Description Added a Process folder at the cluster level. Users can press 'F5' or the 'Refresh' button to get the latest process information.

CR:472367

CR Number:   472367 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) 31 Jul 2007 Fixed Description When running a nested SQL UDF, the ASE server may crash due to stack overflow.

CR:472414

CR Number:   472414 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) 02 Nov 2007 Duplicate Description LDAP login abandon error message 3527 will be displayed with negative number of request pending when LDAP user is logging in to ASE when 'Abandon LDAP User authentication when full' option is true.

CR:472440

CR Number:   472440 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Closed OS:   all Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2007 Fixed Description Problem: "NOT NULL" constraint violation in ASE is not captured and reported in ETL. Resolution: Enabled Callback error handling to capture the error.

CR:472468

CR Number:   472468 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2008 Fixed Description During the execution a stored procedure may raise the errors about the size of the row exceeding the row size limit. Such warning should be displayed only during procedure creation not the procedure execution.

CR:472474

CR Number:   472474 Product Name:   sybcluster Product Component:   Client Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2007 Fixed 25 Jun 2007 Added to user documentation Description The sybcluster command SHOW CLUSTER CONFIG TEMPLATE displays information suitable to be used as an input file to change the values in the quorum disk. This output is missing one line that identifies the boot coordinator.

CR:472481

CR Number:   472481 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2007 Added to user documentation Description using dbcc tune(maxwritedes) in ASE 15 results in error: 'Incorrect DBCC command: Please see the ASE Reference Manual for DBCC commands and options' dbcc tune(maxwritedes)has been deprecated and replaced by a new sp-configure parameter: "i/o batch size". dbcc tune(maxwritedes) needs to be removed from P&T guide

CR:472483

CR Number:   472483 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) 29 Jun 2007 Fixed Description Outerjoin with aggregate/groupby under allrows_dss mode might hit sig11 in ResRelOp() due to eager aggregation.

CR:472499

CR Number:   472499 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) 07 Nov 2007 Not reproducible with latest version of the product available as of Resolution Date Description storage access violation in function proc__reset_wktbl when a procedure is executed on a system using the multiple tempdb feature.

CR:472500

CR Number:   472500 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2007 Fixed 21 Dec 2007 Fixed Description In rare circumstances, an allocation page error (such as a 2540 error) may be reported by DBCC CHECKALLOC after Adaptive Server is rebooted following abnormal termination at which time a CREATE INDEX on an empty table was active. For the 15.0.1 CE edition, a 6908 error may be reported during server reboot, node failover, LOAD DATABASE or LOAD TRAN after a CREATE INDEX on an empty table was done.

CR:472667

CR Number:   472667 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description feature request, to add additional 'restrict database list' parameter to the proxy authorization (set proxy to ...restrict role...) command

CR:472679

CR Number:   472679 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) 25 Aug 2008 Fixed Description When running "sp_spaceused" stored procedure without any parameters against a database with a very large log device, response time maybe slow.

CR:472691

CR Number:   472691 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 Jul 2007 Fixed Description When running 'sp_cacheconfig' with 'logonly' option to create a cache, the command may fail to create the cache (but it consumes the memory) if any of the user database is in 'single user mode'.

CR:472749

CR Number:   472749 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) 28 Jun 2007 Fixed Description Query compiled in the deferred compilation mode may fail producing stack traces if the COMPUTE clause of the query is referencing local variable or parameter. Errorlog stack trace will show modules : 'match_compute' and 'paramchk'.

CR:472762

CR Number:   472762 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) 30 Jun 2007 Fixed 10 Jul 2007 One-off Provided 11 Aug 2007 One-off Provided 31 Jul 2007 Fixed Description Msg. 156, "Incorrect syntax near the keyword 'path'" is raised when executing SQL statement that contains "path" as object name. Workaround Description  N/A

CR:472776

CR Number:   472776 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) 22 Jun 2009 Fixed 18 Apr 2012 Added to user documentation Description sp_lmconfig is enhanced to display the license server name for each license.

CR:472782

CR Number:   472782 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) 21 Feb 2008 Fixed Description If a fatal error occurs during the recovery of a database following instance failure, then the database and its unrecovered data will continue to be usable by processes on surviving instances that were using the database prior to the instance failure. Workaround Description  N/A

CR:472783

CR Number:   472783 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) 11 Aug 2008 Fixed Description The sp_modifylogin setting "max failed_logins" is documented to be the number of allowable failed logins before the account is locked, however ASE is locking the account upon that number of failed logins.

CR:472804

CR Number:   472804 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2007 Fixed 16 Jul 2007 Fixed 06 Jul 2007 Fixed Description If the trigger was defined on a prefixed table name (db..table or db.owner.table) and the schema count for syslogs table in the database is different than 0, ASE may be unable to compile the trigger correctly and the INSERT/DELETE/UPDATE statements will return the error 225/16/3, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." Workaround Description  1.Create trigger without prefixes: Create Trigger triger_name on table_name For Insert,Update,Delete instead of : Create Trigger triger_name on database_name..table_name For Insert,Update,Delete 2. Alternative workaround: in the database where the problem happens : sp_configure 'allow updates,1 go update sysobjects set schemacnt = 0 where id = 8 go sp_configure 'allow updates,0 go shutdown/restart

CR:472846

CR Number:   472846 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2007 Fixed 20 Nov 2007 Fixed Description Kills issued against spids doing queries with external sorts did not rollback immediately.

CR:472864

CR Number:   472864 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 IP Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2007 Duplicate 04 Dec 2007 One-off Provided Description Instrumentation to log events to track the source of 644, sig 10 or sig 11 errors in UPDATE commands with APL objects.

CR:472960

CR Number:   472960 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) 14 Jan 2008 Fixed 05 Mar 2008 Fixed Description Attempt to convert UNICHAR data to TEXT succeeds on the first row but fails on subsequent rows. Example: select convert(text, my_unichar_col) from table. Workaround Description  Convert the column to varchar before converting it to text: select convert(text,convert(varchar(255),c2)) from t1

CR:472968

CR Number:   472968 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) 09 Oct 2007 Fixed 11 Oct 2007 Fixed 11 Oct 2007 Fixed Description Queries containing an IN list in the WHERE clause, as "col IN (val1, val2, ...)", or an equivalent OR clause, as "col = val1 OR col = val2 OR ..." could use an index on the IN list column to lookup each distinct value in the list. This is called the "special OR strategy" and existed before ASE 15.x. However, such a "special OR strategy" does not provide the ordering of the underlying index unless the IN list covers, together with the equi-SARGs of the WHERE clause, a prefix of the index. Since 15.x, we exploit available/useful orderings. So in 15.x we were not generating the "special OR strategy" when the IN list column has an useful ordering (as, for instance, when it is in an ORDER BY, GROUP BY, equi-join, etc.) unless the strategy did provide this ordering. This fix relaxes the above constraint, by generating both: - the index scan which provides the needed ordering but uses the IN list as a filter (and could be thus more expensive but could also be used by efficient parent operators which rely on the ordering); - the "special OR strategy" which uses the IN list for index lookup but provides no ordering (and could be thus cheaper but would be used by less efficient parent operators or would need a sort to be used by the efficient ordering-needing parent operators). Parent plans over both access methods are costed and the cheapest is chosen. Turn on trace flag 15382 to disable this fix in the rare event that the cost-based decision proves to be suboptimal.

CR:473008

CR Number:   473008 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2008 Fixed 30 Jul 2008 Presently Not Targeted For Any Future Release Of This Product 15.0.3 14 Feb 2008 Fixed Description Adaptive Server Enterprise HA agent, may not start on Veritas Cluster Server 4.1 for Linux.

CR:473027

CR Number:   473027 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2007 Fixed 12 Jul 2007 Reservation Made Description Add a new serverwide trace flag 217 to display a warning message for using the Transact-SQL extension of queries with grouped aggregates and columns in the select list which are not in the GROUP BY clause.

CR:473069

CR Number:   473069 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2007 Fixed 02 Jul 2007 Fixed 04 Sep 2007 Presently Not Targeted For Any Future Release Of This Product Description OutOfBound exception get thrown when starting key copies properties from the key copies tab of base key properties.

CR:473084

CR Number:   473084 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) 02 Jul 2007 Fixed 10 Aug 2007 Fixed 15 Aug 2007 Fixed Description When creating a dynamic listener with sp_listener, if the prototype is ssltcp or ssltli, A failure will occur with an error message similar to "kernel ssltcptcp is not a valid protocol type on this platform." reported in the errorlog.

CR:473175

CR Number:   473175 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) 09 Jul 2007 Fixed 02 Aug 2007 Fixed Description Right nested outerjoin might return wrong results when there is an expression join WHERE clause whose expression is referencing a column from the right nested outerjoin inner table.

CR:473179

CR Number:   473179 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Aug 2007 Fixed 02 Aug 2007 Fixed 14 Aug 2007 Fixed Description When statement cache and literal autoparam are on, singleton insert performance is still slower than 12.5.4. Workaround Description  Engineering believes this issue is due to the increased compile time for each individual insert statement. By placing the insert statements into a stored procedure, the increased compile time can be avoided.

CR:473194

CR Number:   473194 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2007 One-off Provided Description INSTRUMENTATION: Diagnostics enahancement in shared memory dump to debug ASE crash due to spinlock order violation. ASE may crash with the message "kernel ulpspinlock: spinlock order violation" in the errorlog. Workaround Description  Turn off multiple engine, run ASE with only one engine

CR:473195

CR Number:   473195 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2007 Fixed Description If encrypted columns is not enabled and restricted decrypt permission configuration parameter value is toggled, server may get stack trace on startup.

CR:473233

CR Number:   473233 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 Jul 2007 Fixed 05 Jul 2007 Fixed Description The newer optimizer set commands should behave like the older optimizer set commands (such as "set forceplan on"). In particular, within a batch or stored procedure, these new commands should be able to affect optimization.

CR:473323

CR Number:   473323 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) 25 Jul 2007 Fixed 25 Jul 2007 Fixed 05 Aug 2007 Fixed 12 Aug 2007 Fixed 09 Aug 2007 Fixed Description ASE hits stack trace while receiving text msg, its size > max length defined by return_clause, and returned type is binary.

CR:473346

CR Number:   473346 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2007 Fixed 09 Jan 2008 One-off Provided 12 Jul 2007 Fixed Description Using TOP N with an OR predicate might incorrectly return less than N rows. Workaround Description  Turn off general OR plan by "set index_union 0" for the session.

CR:473382

CR Number:   473382 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) 06 Jul 2007 Fixed 09 Jul 2007 Fixed Description In rare circumstances, a client waiting for a message from a Queue may wait while a message is effectively present on that queue. This occures when an other ASE spid having previously already consumed a message from the same queue is waiting for a message from an other Queue located on the same JMS Provider (same URL). That issue is only TIBCO JMS relative (EAS and IBM MQ are not concerned).

CR:473462

CR Number:   473462 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2007 Fixed Description Previously in 15.0.2 ESD#1 ASE Plug-in, the Enable Server Discovery check box on Server Discovery page of ASE Plug-in Properties dialog failed to save the settings when the check box was set to disabled. This has been fixed.

CR:473470

CR Number:   473470 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) 25 Oct 2007 Fixed Description The optimizer could fail to find a query plan for a query containing outer joins and an IN/EXISTS subquery with at least 2 tables on the inner side of the outer join.

CR:473560

CR Number:   473560 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2007 Fixed Description In Replication Server environments, allow Replication Agent to skip all the system transactions $queryplans_* logged when the configuration parameter "enable metrics capture" is set to 1. Workaround Description  None.

CR:473628

CR Number:   473628 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DBCC Allow dbcc checkstorage to stop after X number of fault/errors

CR:473629

CR Number:   473629 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Closed OS:   all Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2008 Workaround Description Problem: If a project using OpenClient contains references to n-type columns an insert error will occur. Workaround: Colums of n-type are not accessible via OCS.

CR:473638

CR Number:   473638 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2007 Fixed Description Previously in 15.0.2 ASE Plug-in, if user modified the properties on Resource Limit Properties Advanced Page by clicking Apply button, sometimes the page was refreshed with incorrect values. This has been fixed.

CR:473642

CR Number:   473642 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2007 Fixed Description Previously in 15.0.2 ASE Plug-in, Resource Limit Wizard complained about resource limit already existed when login name, application name, and resource type were the same as an existing limit even though the to-be-created limit had a different time range. This has been fixed to take time ranges into consideration.

CR:473654

CR Number:   473654 Product Name:   Sybase ETL Product Component:   GUI Status:   Open OS:   Windows 2003 Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 4.2 EBF #1 Description Problem: Projects using an ODBC connection to ASE to access BINARY and/or VARBINARY types as part of the data source will not run and may result in a system error. Workaround: Update the ODBC driver, including the ODBC stored procedures on the target ASE database, with the latest Sybase SDK ESD. Recommended minimum ESD level is ESD9.

CR:473666

CR Number:   473666 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) 11 Jul 2007 Fixed Description In the dbcc checktable message, "The total number of empty pages (with all deleted rows) in patition '%.*s' (partition ID %d) is %ld." the first instance of partition is misspelled.

CR:473685

CR Number:   473685 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) 19 Jul 2007 Fixed Description Loading an archive database with 15.0.2 ASE will require more locks than with a pre-15.0.2 ASE release, therefore error 1204 "ASE has run out of LOCKS ..." may be reported.

CR:473791

CR Number:   473791 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Closed OS:   Windows 2003 Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2010 EOL'd version. Not to be Fixed. 02 Jul 2010 EOL'd version. Not to be Fixed. 11 Jan 2008 Workaround Description Problem: In the Database Configuration screen, ETL can have issues returning the database list when using ODBC and ASE. Workaround: Applying SDK15 ESD #9 for the ODBC driver helps eliminate some but not all of the errors. This ODBC driver issue of returning the Catalog names if the catalog name passed in is "%" <ALL catalogs> is an enhancement request.

CR:473805

CR Number:   473805 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2007 Fixed Description A query with OR clause will do a table scan instead of chosing a local index strategy, which is much faster than the table scan.

CR:473887

CR Number:   473887 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 Jul 2007 Fixed 13 Jul 2007 Fixed Description When 'restricted decrypt permission' is configured and a trigger is fired, and if one of the actions in the trigger is to select the decrypted data from the inserted or deleted tables, then the user's session will be terminated and a stack trace containing the following notation may be seen in the errorlog: Current process (0x1b001b) infected with signal 11 (SIGSEGV)

CR:473924

CR Number:   473924 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) 29 Jan 2008 Fixed 07 May 2008 Fixed Description In certain cases, either error 840 is encoutered when using the database or a stack trace with error 692 is produced when dropping a database on a particular cluster instance. The changes done in resolution 1 is backed out in resolution 2.

CR:473946

CR Number:   473946 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) 04 Oct 2007 Fixed Description Error message 240043 has a spelling mistake.

CR:473988

CR Number:   473988 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) 25 Sep 2007 Not a Bug 25 Sep 2007 Not a Bug Description Error 267 raised inconsistently on stored proc accessing temporary tables Workaround Description  We suggest using EXEC commands to avoid the creation of temporary objects and to control the table being accessed. The best option is to use temporary tables only for real temporary tables(#tables), and if you are going to use things like this, it is better do something like: create proc myproc @a varchar(10) as begin if exists(select 1 from tempdb..sysobjects where name="t" and uid=user_id()) begin drop table tempdb..t end exec("create table tempdb..t( a varchar(10))") exec("insert tempdb..t values(@a)") exec("select * from tempdb..t") end go grant exec on myproc to public go

CR:474009

CR Number:   474009 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.2 ESD#2 01 Aug 2007 Fixed Description Scheduled Job Detail column for "Last Execution Result" indicates the last execution succeeded even when the Job History record indicates the execution had errors.

CR:474010

CR Number:   474010 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) 23 Jul 2007 Fixed Description Wrong results possible with a ct-library program using cursors with null parameters. You have a table with a null column: create table ntab (a int null) insert into ntab values (null) This parameterized query may or may not return the correct answer: @p1 = 3 @p2 = null select * from ntab where a + @p1 = @p2 The correct behavior is that this query should return one row. The "a + @p1" should evaluate to null, and the Sybase null matching extension should cause the "=" to compare true against @p2. We see this correct answer with 12.5 and also whenever this query is executed inside a stored procedure. However this comparison fails when the statement is sent as a ct-library program.

CR:474014

CR Number:   474014 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   HP-UX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2007 Fixed 10 Jul 2007 Fixed 17 Apr 2008 Not a Bug Description srvbuild and srvbuildres are built with PA RISC2.0 dependency so the binaries cannot execute on PA RISC1.1 platforms.

CR:474089

CR Number:   474089 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2012 Duplicate Description User defined messages appear in master..monErrorlog always with ErrorNumber = 1 rather than the error number with which they have been defined. Severity is always shown as 0.

CR:474129

CR Number:   474129 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) 11 Jul 2007 Fixed 12 Jul 2007 Presently Not Targeted For Any Future Release Of This Product Description 4221 error is returned with dump tran command on a database that was loaded across platform, after the server is restarted. Workaround Description  Start a server with the trace flag -T3175. This trace flag skips 'dump tran ... with tuncate_only' command which is executed during the start up.

CR:474145

CR Number:   474145 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2007 Fixed 19 Jul 2007 Presently Not Targeted For Any Future Release Of This Product Description Login gets locked after 1 failed login attempt when 'max failed_logins' is set to 0, using sp_modifylogin.

CR:474153

CR Number:   474153 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2007 Fixed Description Selecting Display Statistics on a system table's column would produce a stack trace. This has been fixed.

CR:474155

CR Number:   474155 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) 23 Jul 2007 Fixed Description Incorrectly generated SQL could be sent to the Direct Connect gateway during joins between local and remote tables if the join clause has nullable datatypes, the proxy table is on the inside of a nested loop join, and a datatype conversion is required.

CR:474158

CR Number:   474158 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2007 Fixed 24 Jul 2007 Fixed Description Table Editor gives warning when user alter or add columns for server that does not has encrypted column option turns on.

CR:474175

CR Number:   474175 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2007 Fixed Description Optdiag reports inaccurate space utilization after updating statistics

CR:474191

CR Number:   474191 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2007 Fixed Description Enhanced substitution code to validate column lengths to avoid moving data of incorrect length which may lead to memory corruption.

CR:474292

CR Number:   474292 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2007 Fixed Description Previously in 15.0.1 and 15.0.2 ASE Plug-in, if user shut down a server using Unified Agent (i.e. shut down the server when not connected to the server) and immediately did Refresh All from the containing server group, the server would disappear from the server group. This has been fixed.

CR:474309

CR Number:   474309 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) 25 Jul 2007 Fixed 31 Jul 2007 Fixed 06 Aug 2007 Fixed 06 Aug 2007 Fixed 05 Sep 2007 One-off Provided Description LDAP timeouts values are not being honored when the host running the ldap server is unreachable (e.g. host down, network cable unplugged). A single timeout value, sp_ldapadmin 'set_timeout', '10000' == 10 seconds is timing out in the 3.5 minute range vs. the expected 10 seconds per timeout. Workaround Description  none

CR:474315

CR Number:   474315 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 Oct 2007 Fixed 03 Oct 2007 Fixed Description DMLs to tables having cursors open on them may sometimes cause 583 errors: "The cursor '<cursor_name>' had it's current scan position deleted either because of a DELETE/UPDATE WHERE CURRENT OF or a regular searched DELETE/UPDATE. You must do a new FETCH before doing an UPDATE or DELETE WHERE CURRENT OF." in 15.0 ASE and beyond.

CR:474392

CR Number:   474392 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2008 Fixed Description The 15.0.3 documentation indicates a new column named clientport was added to sysproceses. The column was not actually added in 15.0.3 but is planned for 16.0.