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

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

CR:431107

CR Number:   431107 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2006 Fixed Description The error 864 "Command Failed: Cannot bind object ... to cache because you have active level0 scans on the target object. Retry the command after terminating the scans." will be incorrectly reported when trying to unbind an object from a named cache in a read-only database.

CR:431125

CR Number:   431125 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2006 Fixed 09 Jul 2007 Fixed Description Using existing RUN file with garbadge content to do upgrade, sqlupgrade core dump

CR:431163

CR Number:   431163 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2006 Fixed Description Only create BCPWizIdentityPage if the table has identity column.

CR:431166

CR Number:   431166 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jul 2006 Fixed Description Set the fieldTerminatorTextField and rowTerminatorTextField with default values

CR:431231

CR Number:   431231 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2006 Fixed Description Query with a subquery accessing the fake system table sysprocesses may fail with the error message 691 "Encountered invalid logical page '0' while accessing object '32' in database '1'. This is an internal system error. Please contact Sybase Technical Support." if the query is exectued in the parallel mode.

CR:431232

CR Number:   431232 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) 15.0.1 20 May 2006 Fixed Description The message content for eight resource-level insufficient-memory errors has been expanded to recommend an action. Each such message gains this sentence: "Raise the value of the configuration parameter 'procedure cache size'". The eight affected errors have these error numbers: 3001, 3103, 3161, 3162, 3228, 4201, 4979, and 5203.

CR:431404

CR Number:   431404 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2006 Duplicate Description Currently the latest version of Outlook no longer supports the CMC API. Customer would like Sybmail to support MAPI so that the default mail client can be used to send mail notifications. - closed as dup of feature request 356901. Workaround Description  *** Wednesday, May 17, 2006 2:51:51 PM *** cooperg *** There is no workaround.

CR:431417

CR Number:   431417 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2006 Fixed Description Customer would like Interactive SQL to highlight the error in the SQL when one occurs similar to SQL Advantage. See screen prints attached to CR. In SQL Advantage when you compiled SQL/query and an error was returned, if you double clicked on the error it would highlight the line in the SQL/query where the error was returned from, this is not the case with Interactive SQL. Workaround Description  *** Wednesday, May 17, 2006 4:02:46 PM *** cooperg *** None.

CR:431502

CR Number:   431502 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) 23 Aug 2006 Fixed Description sp_dbcc_evaluatedb reports incorrect values for current scan and text workspace sizes.

CR:431536

CR Number:   431536 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) 06 Jun 2006 Duplicate Description sp_showplan on a spid running a parallel query causes stack trace

CR:431581

CR Number:   431581 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2006 Bundled Request Description For SQLJ Functions ,SQLJ Procedure and Stored Procedures, add functions to respond to commands by context menu item "Print" and submenu "Search".

CR:431694

CR Number:   431694 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2006 Fixed 15 Jun 2006 Fixed Description When create clustered index on large partitioned tables (especially those just upgraded from 12.5), 832 error could be raised during the sampling phase.

CR:431712

CR Number:   431712 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) 22 May 2006 Fixed 12 Jun 2006 Fixed Description If 'statement cache size' is configured to a non-zero value in Adaptive Server, a Replication Server session may report error 225 'Cannot run query--referenced object (NAME NOT RECOVERABLE) dropped during query optimization' when the query processes an encrypted column.

CR:431786

CR Number:   431786 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) 05 Jun 2006 Fixed Description Too few rows could be returned when dynamic partition elimination occurs on DOL tables due to the ILA "Index LookAhead" optimization. This will only occur if the access pattern for rows switches on ILA at the parent level and the next access moves to a new partition. This would generally occur when the table is on the inside of a NLjoin strategy. Note, the problem does not occur with the ILA optimization is done at the leaf level. Problem can be worked around using trace commandline flag 12611.

CR:431822

CR Number:   431822 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2012 Fixed Description Feature request to allow the QUIESCE DATABASE command to be granted to users or roles other than sa_role.

CR:431832

CR Number:   431832 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows W2k Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2006 Fixed Description Job Scheduler Job Copy menu item is displayed but does nothing.

CR:431855

CR Number:   431855 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) 25 May 2006 Fixed 25 May 2006 Reservation Made Description Error:8419, Severity:20, State:3 may occur when an installation has not been upgraded and a query had been executed. All users, other than the users with sa and operator roles, are not allowed to access a database that is yet to be upgraded to prevent errors in databases that have not been upgraded.

CR:431873

CR Number:   431873 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) 22 Jun 2006 Fixed 19 Jun 2006 Fixed Description When calling a SQLJ procedure, from jConnect, that returns multiple result sets, only the first result set is returned.

CR:431904

CR Number:   431904 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) 31 May 2006 Fixed 01 Jun 2006 Fixed Description A database or transaction log dump that was taken using the WITH COMPRESSION = <compression> and the AT <remote backup server> options cannot be loaded using a local backup server (that is, without the AT <remote backup server> option). In addition, the dump that is created is not compressed despite compression having been requested.

CR:431945

CR Number:   431945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2006 Fixed 16 Jun 2006 Fixed Description When executing a SELECT statement via DYNAMIC SQL Adaptive Server could send incorrect or inaccurate information in the column format descriptions for the user type id field. This only happens the first time that the formats are sent after the DYNAMIC PREPARE command, subsequent DYNAMIC EXECUTE commands return the correct format information. Workaround Description  Use language command with CS_OPT_FORMATONLY set to just get accurate meta-data info back.

CR:432003

CR Number:   432003 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2006 Fixed Description ASEPlugin did not consider the way length is evaluated for national character datatype.

CR:432024

CR Number:   432024 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2006 Fixed Description Enable DIRECT IO for block devices under trace flag 1648 on Linux.

CR:432057

CR Number:   432057 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2008 Fixed 05 Jun 2006 Fixed Description Any occurrence of "[gG][oO]" in the text of a job command will be considered as the batch delimiter "go" and hence, the job command will not be correctly parsed, resulting in the job failure. Workaround Description  None.

CR:432094

CR Number:   432094 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) 06 Jun 2006 Fixed Description When 'statement cache' is enabled, server may stacktrace when executing a select into query with nested union operators.

CR:432175

CR Number:   432175 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2006 Fixed 17 Oct 2006 Fixed Description When ASE resource governor is configured for transaction elapsed time resource limit, stored procedure whose execution time exceed the configured limit may hit TDS protocol errors instead of the expected 11005 error reading "Transaction's running time exceeded limit of <TimeLimit>." Workaround Description  None.

CR:432216

CR Number:   432216 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2007 Bundled Request Description The error "Invalid column name 'encrkeyid'" is generated by sybmigrate when auto_select_dependent_objects=yes is set in the resource file. Workaround Description  Comment out the line from resource file: 'auto_select_dependent_objects=yes' (see detail in Barry's email in Descriptions)

CR:432292

CR Number:   432292 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2006 Fixed 23 Jul 2008 Fixed Description For very large tables, with more than 2,200,000,000 rows, sp_spaceused reports lead to arithmetic overflow.

CR:432354

CR Number:   432354 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2006 Fixed Description Previously in 15.0.1 ASE Plugin, trigger did not have Print or Find/Replace on its context menu. This has been corrected.

CR:432355

CR Number:   432355 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2006 Fixed Description Previously ASE Plug-in did not select a server after connecting to the server. This sometimes lead to confusion, esepcially when there are other connected servers already. This has been fixed.

CR:432377

CR Number:   432377 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Digital UNIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2006 Fixed 23 Jul 2006 Fixed Description DDLGen does not generate 'sp_cachestrategy' statements for tables, indexes and constraints when 'mru' and 'prefetch' are set to off.

CR:432411

CR Number:   432411 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) 31 May 2006 Fixed Description The LOAD DATABASE ... WITH HEADERONLY command, when executed on an archive database, has been enhanced to display the compression level and format, ansi version, block size, internal backup server buffer size, number of stripes and creation date of the first stripe.

CR:432419

CR Number:   432419 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2006 Fixed Description When ASE resource governor is configured for transaction elapsed time resource limit, an 11005 error may be unexpectedly raised after a transaction has been explicitly rolled back.

CR:432469

CR Number:   432469 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) 29 Jun 2008 Fixed Description There is no error message in the errorlog indicating shared memory is locked successfully into physical memory or otherwise.

CR:432511

CR Number:   432511 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.1 ESD#1 05 Sep 2006 Fixed Description EFTS: txtsvr core dumps on Linux platform when vdkLanguage=uni Workaround Description  None known.

CR:432526

CR Number:   432526 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2006 Fixed 13 Jun 2006 Fixed 16 Jun 2006 Fixed 19 Jun 2006 Fixed 19 Jun 2006 Fixed Description The 12.5.4 Backup Server is unable to load a dump taken using the WITH COMPRESSION option, when the dump was originally taken remotely (using the AT option) but loaded remotely (without the AT option) and vice versa. Likewise, Adaptive Server is unable to load this dump into an archive database.

CR:432548

CR Number:   432548 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2006 Fixed Description The error message, "SybSQLException: The definition for column 'int' must include a datatype." may occasionally be reported by the Table Editor when creating a table. This occurs when the column name is edited and the definition is then saved.

CR:432558

CR Number:   432558 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2006 Fixed 04 Dec 2006 Fixed Description In rare cases the customer could face this problem. After a stored procedure is created which access some tables. First the tables' schema is changed with 'alter table' or 'create index' command, and then 'update statistics' are made for those tables, Now if the stored procedure is executed, Assertion failure and stacktrace could occurs. Workaround Description  dbcc markprocs(database_name) will recompile all procedures from text, and renormalize, which should fix the problem.

CR:432565

CR Number:   432565 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2006 Fixed Description Incorrect percentages may be reported while loading a database.

CR:432573

CR Number:   432573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2006 Fixed 30 Aug 2006 Fixed Description sp_setrepproc with no argument reports duplicated rows if multiple languages are installed to ASE. Workaround Description  TSE suggests that the following query works around this problem. -------------------------------------------------------- declare @rep_constant int declare @sub_constant int declare @log_constant int select @rep_constant = -32768, @sub_constant = 64, @log_constant = 8388608 select o.name, convert(char(14), m1.description), convert(char(14), m2.description) from sysobjects o, master.dbo.sysmessages m1, master.dbo.sysmessages m2 where o.type = "P" and m1.langid = 1 <--- Add and m2.langid = 1 <--- Add and (o.sysstat & @rep_constant) = @rep_constant and ( ((o.sysstat & @sub_constant) = @sub_constant and m1.error = 18105) or ((o.sysstat & @sub_constant) = 0 and m1.error = 18104) ) and ( ((o.sysstat2 & @log_constant) = @log_constant and m2.error = 18845) or ((o.sysstat2 & @log_constant) = 0 and m2.error = 18844) ) --------------------------------------------------------

CR:432617

CR Number:   432617 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Consolidating the following fields into monProcess to remove the need to correlate between multiple tables. ObjectID, StatementNumber, OwnerUID, CPUTime, PhysicalReads, PhysicalWrites MemUsageKB,ClientHost,ClientIP,Status

CR:432633

CR Number:   432633 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) 21 Aug 2006 Fixed 22 Aug 2006 Fixed Description A stack trace is encountered when querying a proxy table column mapped to a computed java column

CR:432693

CR Number:   432693 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) 18 Aug 2006 Fixed 15 May 2007 Fixed 26 Sep 2006 Fixed 26 Sep 2006 Fixed Description User without an Unix OS id were not able to use ASE RTDS messaging with MQ. This fix provides an option 'alter_user=yes' that allows such users to use RTDS messaging with MQ. Workaround Description  Have the SQL admin create an os account for each sql user that wants to use ASE RTDS messaging with MQ.

CR:432700

CR Number:   432700 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2006 Fixed 20 Jul 2006 Fixed Description Using integrated logins on Windows, user may see error 4002 'Login failed' from ASE if the user account name includes uppercase letters. Rebooting the Windows domain controller may temporarily fix the problem.

CR:432754

CR Number:   432754 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2006 One-off Provided Description Instrumentation: Investigate 'time to live expired' messages. ASE may report in errorlog messages like "kernel secleanup: time to live expired on engine <eng#>" "kernel Terminating the listener with protocol tcp, host <hostname>, port <port#> because the listener execution context is located on engine <eng#>, which is not responding."

CR:432955

CR Number:   432955 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2006 Fixed Description Previously ASE Plug-in displays Platform and OS information for a Unified-Agent-monitored server differently depending on whether the server is connected or not. This has been changed so that ASE Plug-in prefers the info obtained from UA - platform and OS information from UA is more relevent to the server host.

CR:432995

CR Number:   432995 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2006 Not a Bug Description Trace flag 302 ouput is missing SARG index selection for certain queries that contain OR expression.

CR:433062

CR Number:   433062 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) 28 Jun 2006 Fixed Description Checks to see if literal parameterization have been moved to the parsing phase of query processing. If a query is parsed with literal parameterization enabled, then the query will be parameterized regardless of the settings at the time the query is executed.

CR:433186

CR Number:   433186 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2007 Fixed 28 Mar 2008 Added to user documentation 17 Nov 2009 Fixed 19 Nov 2009 Fixed Description The StatementNumber column was added to the monProcessProcedures MDA Table.

CR:433195

CR Number:   433195 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 EAP2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2006 Fixed 15 Jun 2006 Fixed Description An outer join query, where the inner table of the outer join is range or list partitioned can result in wrong results. This is because the upper bound of the outer join or the entire partitioning conditions for the list partition on the inner table is being evaluated at the WHERE clause rather than the ON clause.

CR:433203

CR Number:   433203 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2006 Fixed Description Previously, in the "Export" dialog, if you clicked the "Browse" button and selected an existing file, you were asked if you wanted to overwrite the file. This prompt has been suppressed because you are asked this anyway when you click the dialog's OK button.

CR:433206

CR Number:   433206 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) 08 Dec 2006 Fixed 24 Oct 2007 Fixed Description After an alter table to decrypt a column, rows remain in sysprotects that describe decrypt access to that column.

CR:433209

CR Number:   433209 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2006 Fixed Description Previously, when connected to an ASE server, exporting a result set to an Excel spreadsheet would use the column names rather than the column labels for the column headings. Now, the labels are used (which was the intent all along, and is what ASA does.)

CR:433273

CR Number:   433273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2006 Fixed 13 Jun 2006 Fixed Description A user that is not valid in a database may gain access to objects in that database via a system stored procedure that is executed from a database different from the one where the procedure is created.

CR:433315

CR Number:   433315 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) 10 Jun 2006 Fixed 12 Jun 2006 Fixed 15 Jun 2006 Fixed Description There is an incompatibility between Adaptive Server and RepServer 15.0 when replicating an alter table statement that modifies an encrypted column to change the key or the data type. The data type of the encrypted column in the replicate database is changed to varbinary.

CR:433386

CR Number:   433386 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2006 Fixed 11 Jan 2008 Fixed 10 Jan 2008 Reservation Made Description All processes in the server can become blocked when auditing is enabled and the sybsecurity database is quiesced.

CR:433437

CR Number:   433437 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 Nov 2006 Fixed Description When 'enable literal autoparam' and 'statement cache' are on, subsequent run of a select statement with a literal followed immediately by a correlation name in the select list may get assertion failure in sqtcache.c.

CR:433439

CR Number:   433439 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2006 Fixed 04 Aug 2006 Fixed Description The Transactions and Rollbacks columns in the monProcessActivity MDA table are not set to zero when a new connection is established. This may result in reporting incorrect values for these columns.

CR:433456

CR Number:   433456 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) 29 Aug 2006 Fixed 30 Aug 2006 Fixed 30 Aug 2006 Fixed Description ASE running on Linux kernel 2.6 and above on linuxia32, linuxia64 and ibmplinux platforms encounters I/O performance degradation. This is because librtkaio support has been withdrawn on these linux kernel versions and by default POSIX AIO is used. Enable trace flag 1649 to use Linux Kernel Asynchronous IO.

CR:433485

CR Number:   433485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2006 Fixed 06 Apr 2007 Insufficient priority to fix Description When execute charindex with Unicode character U&'\+01d160' and 'enable unicode normalization' is on, we may get wrong result.

CR:433519

CR Number:   433519 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) 08 Sep 2006 Fixed 11 Sep 2006 Fixed Description A sp_setreptable to turn on replication on a table with text image columns,in the context of a database marked for replication using indexes, mark incorrectly the table for replication, so that a writtext done on it could lead to miscelaneous errors.

CR:433541

CR Number:   433541 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   Microsoft Win32s Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Backup Server: using the -Lfrench switch, load of compressed dumps fails with: Backup Server Internal Error: 4.126.3.1: Unable to get current date and time. Internal error. Workaround Description  Use the default -Lenglish switch.

CR:433563

CR Number:   433563 Product Name:   Adaptive Server Enterprise Product Component:   sybsetup - PC Status:   Closed OS:   Microsoft Win32s Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2007 Fixed 06 Feb 2007 Fixed 15 Feb 2007 Fixed Description Unattended installations of servers using setup response files or sybatch resource files do not complete if the hostname begins with a numeric character even if the actual supplied name begins with a legal alpha character. Workaround Description  None known.

CR:433579

CR Number:   433579 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2006 Fixed Description Remove duplicate reference to "dataserver" in External authentication chapter

CR:433588

CR Number:   433588 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2006 Fixed 11 Sep 2006 Fixed Description When a loaded database needs to be upgraded but its transaction log has passed the last-chance threshold, ONLINE DATABASE will report that it could not bring the database online but will not say why. (Reason: log is almost full, so upgrade could not happen.) Workaround Description  if the transaction log is cleared either with dump tran with no_log on with truncate only. before the dump then the online will work .

CR:433601

CR Number:   433601 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2006 Fixed Description UI: Use Icons to improve the look

CR:433611

CR Number:   433611 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2007 Fixed 25 Feb 2008 Presently Not Targeted For Any Future Release Of This Product Description In some cases, the statistics "plancost" feature was over reporting physical IOs. This was because it was accounting for all physical reads rather than just the physical reads used (in readahead cases).

CR:433656

CR Number:   433656 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2006 Fixed Description Under some circumstances the execution of a stored procedure when a procedure contains statement like CREATE INDEX, UPDATE STATISTICS or DROP TABLE followed by a SELECT statement from a view in a database different than the current database. Workaround Description  In the procedure body add some statement between CREATE INDEX and cross database view. It could by anything for example : select 1 or select @a = 1

CR:433676

CR Number:   433676 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) 28 Jun 2006 Fixed Description Proxy tables are never considered for right side of nested loop joins even when this might have resulted in a better plan.

CR:433691

CR Number:   433691 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2006 Fixed 30 Aug 2006 Fixed 13 Sep 2006 Fixed 13 Sep 2006 Fixed Description When Job Scheduler executes a job, for some passwords, the job may fail and messages like "Login Failed" is seen in the job history The jsagent log also shows following errors : "Client message: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed." and "ct_connect() failed."

CR:433692

CR Number:   433692 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) 14 Jun 2006 Fixed 14 Jun 2006 Fixed Description The error "No virtual mapping for logical page <pageno>" followed by a core dump of the backup server will happen if the command LOAD DATABASE WITH VERIFYONLY is run and the database from where it is executed is smaller than the database being verified.

CR:433740

CR Number:   433740 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2006 Fixed Description The message "timeslice -501, current process infected" together with a stack trace which includes different modules like 'memalloc', 'make_orstruct', 'parscpy' or 'q_or_find' may be reported in the error log when a query with a long IN list is executed. Workaround Description  I don't know any workaround yet. The query may fail with timeslice error or 404 error. [Jun 26 2006, frankl] Since 1254 (CR 381815) the limit of 1024 ORs is removed, so we do not hit an 404 error anymore. So a workaround is to increase 'cpu grace time' to avoid the timeslice error.

CR:433746

CR Number:   433746 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2006 Fixed 23 Aug 2006 Fixed 04 Dec 2006 Bundled Request Description An Adative Server messaging operation done inside a transaction may fail and print a stacktrace including all messaging function if there is not a valid licence for Real Time Messaging or the option has not been enable via sp_configure. Workaround Description  > Installed a valid SY_RTDS license for Real-Time Data Services > Enabled RTDS services by executing: sp_configure 'enable real time messaging',1

CR:433759

CR Number:   433759 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2006 Fixed Description For internal use only: For winx64 platform, it has diffrent exception process. adding EX_CLEANUP before return is the resolution for it. Just adding the missed EX_CLEANUP which may cause problems.

CR:433781

CR Number:   433781 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2006 Fixed Description When selecting data from an unprefixed table that is created in a stored procedure, if the same table exists owned by DBO, the data will be incorrectly read from the DBO owned table. Workaround Description  Use fully qualified table names or create the table in a separate stored procedure.

CR:433834

CR Number:   433834 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2006 Fixed Description For displaying statistics, the wizard didn't check whether the 'optdiag' utility version and the server version match or not, causing only error output in the resulting window. This has been fixed so that only matching 'optdiag' utility can be used for displaying statistics.

CR:433980

CR Number:   433980 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2006 Fixed Description When parallelism is turned ON and we have a join of two tables A and B, where both A and B are partitioned, we end up having to re-partition the scans of both sides. This results in not being able to push a join predicate to the scan of B, thereby not being able to chose a selective indexed nested loop join.

CR:433987

CR Number:   433987 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2006 Fixed 28 Jun 2006 Fixed Description Localized versions of ASEP may display a NullPointerException when the user opens the properties window for a Job Scheduler Schedule or selects the Time tab in that window.

CR:433991

CR Number:   433991 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Aug 2006 Bundled Request Description on ASE Plug-in Properties Preferences page, the check boxes under "Enable Unified Agent (UA)..." check box were not disabled when user clicks "Restore Defaults" button. This has been fixed.

CR:434075

CR Number:   434075 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.2 31 Aug 2006 Fixed Description Feature request to enhance monOpenPartitionActivity and monOpenObjectActivity to print partition-level and object-level housekeeper garbage collection queue statistics

CR:434118

CR Number:   434118 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2006 Fixed Description The error 803, "Unable to place buffer '0xnnnnnn' from cache 'default data cache' holding logical page '<pgno>' in sdes for object 'sysprotects' - either there is no room in sdes or buffer already in requested slot." followed by a process termination will happen when granting access to a group that contains more than 11 users that already have the same access granted with grant option. Workaround Description  *** Thursday, June 15, 2006 10:02:50 AM *** cooperg *** Combine users into groups.

CR:434146

CR Number:   434146 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2006 Fixed 06 Aug 2007 Fixed Description The "Memory Used" value for sp_configure "total logical memory" is not updated when the size of a named cache is changed using sp_cacheconfig. Workaround Description  - restart the server - OR run a dummy sp_configure command to set one of the configures to its current value. This will not change the config, but will update "Memory Used"

CR:434149

CR Number:   434149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2006 Fixed Description The default for histogram tuning factor was previously 1, which disables the feature. In order to reduce estimation issues for skewed columns, the default will be 20, which should help isolate distributions with skewed frequency values, while avoiding the extra steps when a relatively uniform distribution exists.

CR:434152

CR Number:   434152 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) 06 Jul 2006 Fixed Description sp_displaylogin does not show the password as 'expired', when the password expires due to password policy option 'expire login'.

CR:434201

CR Number:   434201 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2006 Fixed Description Feature to retrieve ddl for all triggers for a table without table definition. DDLGen generates ddl for all triggers of a table. The value to be supplied in the name parameter '-N' would be <dbName>.<tableOwner>.<tableName>.<triggerName>. Please note that if DDL is to be generated for all triggers of a table then in the above -N parameter '%' should be used for trigger name. Also note that -D parameter cannot be used when generating DDL for all triggers of a table.

CR:434264

CR Number:   434264 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2006 One-off Provided Description ASE 12.5.4 on Windows platform is missing diagsrvr.pdb file and therefore symbolic names are not printed in stacktraces when running diagsrvr.exe. Workaround Description  no workaround, install EBF 13758.

CR:434288

CR Number:   434288 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) 02 Jul 2006 Fixed 20 Aug 2006 Duplicate 08 Mar 2007 Fixed 05 Jul 2006 Fixed 05 Jul 2006 Fixed Description For an allpage locked table with a clustered index, built-in USED_PAGES() will now return the used pages for the data layer alone when queried with index ID of 0. And it continues to return the sum of used pages for the data and index layer when queried with index ID of 1.

CR:434339

CR Number:   434339 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2006 Fixed 15 Nov 2006 Fixed Description Allow a database dump of the master database to be loaded into an archive database.

CR:434348

CR Number:   434348 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2006 Fixed Description Occasionally, optdiag might report severely truncated 'unique_range' or 'unique_total' values.

CR:434366

CR Number:   434366 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2006 Fixed 27 Jun 2006 Fixed Description Wrong duplicate result rows in the result for SELECT DISTINCT cname=NULL, ... query.

CR:434373

CR Number:   434373 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Aug 2006 Fixed 01 Aug 2006 Not reproducible with latest version of the product available as of Resolution Date 30 Aug 2006 Fixed Description Bulk copying data using the BCP utility into proxy tables mapped to DirectConnect for Oracle (DCO) version 12.6 and above may not return any error messages to the BCP client when a constraint violation error is encountered while inserting data into the Oracle database. Workaround Description  Use "create proxy_table" to map the remote table instead of "create existing table".

CR:434482

CR Number:   434482 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2007 Fixed 06 Feb 2007 Fixed 05 Sep 2007 Fixed Description In rare circumstances, the error "ubo_object_from_slot:Pss Invalid slot id 0" together with a stack trace which includes the modules pss_getunkept_pss, sysxacts__fmtrow_from_xdes end sysxacts_materialize may be reported in the error log during select from SYSTRANSACTIONS in a ASE with high transaction load. Workaround Description  This error results in the message "ubo_object_from_slot:Pss Invalid slot id 0" and a stacktrace in the errorlog, but is not a serious problem; the connection is not terminated. User can rerun the query on systransactions table.

CR:434625

CR Number:   434625 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2006 Fixed Description DBCC CHECKALLOC or TABLEALLOC may deallocate a log page considered to be the last log page in the dbtable. Enhance the fix option of these DBCCs to remove the reference to lastlogbp in the dbtable if this page gets deallocated because it is no longer the root page for Syslogs.

CR:434627

CR Number:   434627 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2008 Fixed Description New support for Logical Cluster in DDLGen. A new type 'LC' is added for Logical Cluster. The syntax for generating DDL for user defined logical cluster is: ddlgen -U[userName] -P[password] -S[servername | host:port] -TLC -N logical_cluster_name

CR:434640

CR Number:   434640 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2006 Fixed 15 Oct 2006 One-off Provided 31 Jan 2007 Fixed Description In rare circumstances, a deadlock may arise between a user task running RPC and the site handler task after which no more connections to the remote server will be accepted by Adaptive Server.

CR:434657

CR Number:   434657 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2006 Fixed 30 Aug 2006 Fixed Description When debugging a T-SQL batch putting breakpoints in procedures with long names, the debugger just continues without stopping on the breakpoints set. Workaround Description  use names not that long or do not use the db.owner.name type of names.

CR:434658

CR Number:   434658 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) 14 Jul 2006 Fixed 17 Jul 2006 Reservation Made 17 Jul 2006 Fixed 29 Aug 2006 Fixed 20 Nov 2007 Presently Not Targeted For Any Future Release Of This Product Description When a temporary object fails to drop, the temporary object is queued for HK Chores system process to retry the drop.

CR:434731

CR Number:   434731 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2006 Not a Bug Description When a jConnect based client application executes extremly large command batches using PreparedStatement the dataserver can get blocked sending protocol data to the network. Workaround Description  (1) Use smaller batch sizes not exceeding 4000 requests (2) Use literal SQL which has a certain performance impact in terms of both CPU and much (!) higher memory usage.

CR:434781

CR Number:   434781 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2006 Fixed Description ubffree gets infected with 11 during a disk init operation when attempting to free a memory fragment.

CR:434784

CR Number:   434784 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) 08 May 2009 Duplicate Description Customer requests that the ASE datetime data type change its time precision to 1/1000ths of a second

CR:434835

CR Number:   434835 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 Jun 2006 Fixed 10 Jul 2006 Fixed Description 701 error or timeslice error happened when using "set forceplan on" for a query with a lot of joining tables. Workaround Description  Avoid forceplan option for the problem query.