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

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

CR:481137

CR Number:   481137 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2007 Fixed 25 Oct 2007 Fixed 31 Oct 2007 Presently Not Targeted For Any Future Release Of This Product Description In very rare circumstances, Adaptive Server may hit a timeslice error together with a stack trace which includes the modules 'mem_getpages' or 'proc_get' for a server with a large procedure cache.

CR:481144

CR Number:   481144 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2007 Fixed 26 Mar 2008 Fixed Description Parsing of very large TEXT literals may case timeslice errors in heavily loaded systems.

CR:481237

CR Number:   481237 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2007 Fixed Description The message "process infected with signal 11" is reported in the errorlog together with a stack trace which includes the modules 'dropo' and 'logcommand' when dropping a User-Defined SQL Function in a database with DDL replication enabled. Workaround Description  Disable DDL replication by issuing the following command in the affected database: sp_reptostandby pubs2, 'none'

CR:481268

CR Number:   481268 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) 25 Dec 2007 Fixed Description infected with 11 in CgEvals::_CgCompVcol when using forceplan

CR:481303

CR Number:   481303 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2007 Fixed 09 Oct 2007 One-off Provided 14 Oct 2007 Fixed Description sp_sproc_columns and sp_statistics are returning varchar data for all columns in a result set irrespective of their actual datatypes.

CR:481315

CR Number:   481315 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 Jan 2009 Presently Not Targeted For Any Future Release Of This Product 07 Jan 2009 Fixed 31 Mar 2009 Added to user documentation Description In SDC environment, an instance is not allowed to startup or shutdown during dump database command. When dump database command is in progress in one of the other instances, startup or shutdown of instance waits until the dump database command completes.

CR:481326

CR Number:   481326 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2007 Fixed 30 Sep 2007 Fixed Description When there is no statistics present on a column, Adaptive Server may not pick up simulated column statistics even after loading simulated statistics using optdiag and setting 'set statistics simulate on'.

CR:481340

CR Number:   481340 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 Sep 2007 Fixed 02 Oct 2007 Fixed 11 Oct 2007 Fixed 11 Oct 2007 Reservation Made 12 Oct 2007 Fixed Description If UPDATE STATISTICS is executed with a large number of steps and the configuration parameter, 'histogram tuning factor', is at its default value of 20, then the actual step count of the resulting histogram maybe restricted to a lower number.

CR:481385

CR Number:   481385 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2007 Fixed 24 Oct 2007 Fixed 12 Nov 2007 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description The compile optimization level has been restored to +O2 from +O1 in building the ASE binary for the HP Itanium platform. This fix improves the run-time performance of the ASE by more than 10%.

CR:481395

CR Number:   481395 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 Oct 2007 Fixed 11 Oct 2007 Fixed Description Improve performance of system stored procedures calling sp_autoformat procedure.

CR:481465

CR Number:   481465 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) 17 Dec 2007 Fixed Description sp_helptext "showsql" may display a grave accent mark (`) in stored procedure text if the text includes multi-byte characters. Workaround Description  Use char_length() instead of datalength()

CR:481479

CR Number:   481479 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) 26 Oct 2007 Fixed 29 Oct 2007 Fixed Description A 548 error, "Check constraint violation occurred ..." maybe incorrectly reported, resulting in the command being aborted when running a INSERT SELECT statement, the target table has a check constraint involving more than a single column and a NULL value from source table was being inserted into the target table.

CR:481487

CR Number:   481487 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2007 Fixed Description Printing bigints using "print" on windows may give wrong result.

CR:481506

CR Number:   481506 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) 28 Jan 2008 Fixed 28 Jan 2008 Reservation Made Description Option 'literal_autoparam' is not shown when running 'sp_show_options' to display current session option settings.

CR:481515

CR Number:   481515 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) 27 Sep 2007 Fixed 02 Oct 2007 Fixed Description When converting device virtual page IDs from their pre-15.0 form to the 15.0 form, ASE can obtain an incorrect device number for certain page IDs. This causes ASE to store the wrong device number in sysusages.vstart. Workaround Description  This affects usage entries where device ID >= 128 _and_ offset > 0. It manifests after ASE shuts down and reboots. Thus, _after_ upgrade but _before_ reboot, do: 1. Allow updates to system tables 2. Fix broken sysusages entries: update sysusages set vdevno = vdevno - 1 where vdevno > 128 and vstart > 0 3. If any sysdevices entries happen to have a non-zero start offset, fix them too: update sysdevices set vdevno = vdevno - 1 where vdevno > 128 and low > 0 and status & 2 = 2 4. Disallow updates to system tables.

CR:481520

CR Number:   481520 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2007 Fixed Description Previously when DBISQL was launched for the first time from ASEP, it would use the default settings instead of the saved settings. For example, it would use 500 as "Maximum number of rows to display" even though the saved setting was, say, 50. (Subsequently launched DBISQL from ASEP would use the saved settings.) This has been fixed. (As a result of the fix, DBISQL's window position is now correctly restored when launched from ASEP.) Workaround Description  Always launch DBISQL from the shortcut outside of Sybase Central.

CR:481537

CR Number:   481537 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) 28 Sep 2007 Fixed 03 Oct 2007 Fixed Description Error 1579 will be raised when you run a query attaching an abstract plan with multi-byte object name.

CR:481552

CR Number:   481552 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) 07 Jan 2008 Fixed 02 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description The deadlock information reported when the configuration option 'print deadlock information' is active has been enhanced such that the database name and the index ID values are reported.

CR:481562

CR Number:   481562 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2007 Fixed Description A create table command that contains a computed column with a case expression may cause a stacktrace.

CR:481601

CR Number:   481601 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) 22 Oct 2007 Fixed 24 Oct 2007 Fixed 23 Oct 2007 Reservation Made Description A query with a qualification which has a CASE or an OR expression, may sometimes generate wrong results. Workaround Description  rewriting query as follows will return the row: declare @DepId nchar(12) select @DepId = '%' select distinct A.TS_SheetID ,@DepId ,C.ldap_login FROM bugZpTimeSheet A ,bugDepar C WHERE A.TS_SheetID like 'DN170700000007080101' AND substring(A.TS_SheetID,1,12)=C.ldap_login AND C.ldap_login = case @DepId when '%' then C.ldap_login else @DepId end

CR:481611

CR Number:   481611 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) 02 Jan 2008 Fixed Description Issuing the command sp_configure "optimization goal", 0, "allrows_oltp" can disable replication agent threads on some platforms.

CR:481665

CR Number:   481665 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) 05 Oct 2007 Fixed 05 Oct 2007 Fixed Description Server could hit stacktrace during codegen when an outerjoin is: 1. referencing a materialized outerjoin view (worktable), and 2. at the same time another view is merged into the parent outerjoin query as the inner joining table, and 3. the SELECT list is referencing some column from that merged view, and 4. that column from the merged view is an CASE expression.

CR:481678

CR Number:   481678 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) 24 Nov 2007 Fixed 20 Nov 2007 Added to user documentation Description Badly partitioned utilities like 'select into' and 'bulk copy' run much slower on multi-node clusters compared to single node.

CR:481704

CR Number:   481704 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2007 Fixed Description When derived tables expose columns that refer to local variables, a segmentation violation error may be seen in the optimizer code, with the function name ScalarNormalizing()at the top of the stack.

CR:481750

CR Number:   481750 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) 04 Oct 2007 Fixed 04 Oct 2007 Fixed Description Under rare circumstances an excessive number of 'Ex_intent' table locks for the same table may be reported by SP_LOCK, despite them being compatible. The same may be seen with 'Sh_intent' locks.

CR:481797

CR Number:   481797 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) 07 Apr 2008 Presently Not Targeted For Any Future Release Of This Product 04 Oct 2007 Fixed 02 Oct 2007 Reservation Made 05 Oct 2007 Fixed 25 Oct 2007 Fixed Description Optimizer will not choose a unique index based on the search clauses in the query and instead choose a different non-unique index. This is particularly true when the wrong index chosen has the same cost as that of the unique index, because of a stale histogram.

CR:481813

CR Number:   481813 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2008 Bundled Request Description DBISQL performs poorly while generating plans for stored procedures

CR:481822

CR Number:   481822 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2007 Fixed 23 Oct 2007 Fixed Description DBISQLs method to cancel query plan generation is very non-intuitive. Added a "Cancel Plan" button in planviewer.

CR:481838

CR Number:   481838 Product Name:   Sybase ETL Product Component:   GUI Status:   Closed OS:   all Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 4.5 27 Aug 2008 Added to user documentation Description Problem: ETL Flash demos require file 'flash.ocx' which - unlike previous version of Windows - is not included on Windows Vista. Resolution: Download Adobe Flash Player from the www.adobe.com web page (http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash) FYI: User is likely to be prompted by Windows Vista with this information - after shutting down ETL Development - if they have attempted to run the flash demos during their ETL Development session.

CR:481844

CR Number:   481844 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2009 Not a Bug Description changing "lock schema" can cause different internal update mode which might cause differ query behavior.

CR:481869

CR Number:   481869 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2009 Not a Bug Description On Solaris, if ASE is configured for HighAvailability on Veritas, the HA agent ase_monitor will initiate failover if it fails to run various SQL commands as part of thorough probe, though the error is a transient one such as no space in tempdb

CR:481876

CR Number:   481876 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2007 Fixed Description If the coordinator role change during the life of the cluster some rep agent administrative actions may not take effect as they were being sent to the instance with the coordinator role before the role change.

CR:481878

CR Number:   481878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed Description Under certain circumstances, when a statistical aggregate (stddev or variance) is combined with other aggregates in a query containing a group-by clause, the process can be terminated prematurely.

CR:481900

CR Number:   481900 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2007 Fixed Description Performance of queries returning only constants (no table references) can be improved by implementing a new operator to echo a row, without any cache set up required.

CR:481914

CR Number:   481914 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2007 Fixed 08 Nov 2007 Fixed Description When using srvbuildres from 1502 to create a new ASE instance, it takes a long time if the resource file used on this, has the default comments for the last line ("sqlsrv.addl_cmdline_parameters") Workaround Description  Remove the String, PUT_ANY_ADDITIONAL_COMMAND_LINE_PARAMETERS_HERE

CR:481959

CR Number:   481959 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2010 Not a Bug Description ASE 12.5.4 ESD#6 generates less optimal query plan due to Optimizer overlooking clustered index of parent table when performing materialization for view/derived table involving outer join. Workaround Description  Enable traceflag 4419 to disable the effect of CR462943

CR:481987

CR Number:   481987 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2007 Fixed Description -str_replace is missing from the list of string functions in the Transact-SQL guide- http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.blocks/html/blocks/blocks101.htm str_replace is documented under string functions, but does not show up in the list of strings functions in the above url.

CR:481990

CR Number:   481990 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) 19 Dec 2007 Added to user documentation Description Request to add info in the DTM doc

CR:481996

CR Number:   481996 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2008 Fixed Description Add device information for all create database wizards summary page.

CR:482074

CR Number:   482074 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2007 Fixed 19 Nov 2007 Fixed Description After modifying the RUN_server_back file, adding the supported arguments -P and/or a -m, sqlupgrade of backupserver fails: The flag '-P' is not supported by Backup Server. Unable to parse '/opt/sybase/ASE-12_5/install/RUN_r1254_back' Workaround Description  1. remove additional arguments from the RUN_servername_back file before running sqlupgrade 2. do not use sqlupgrade, use srvbuild to build a new backupserver.

CR:482079

CR Number:   482079 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2007 Fixed Description sp_passwordpolicy 'expire login password' raises error 17231, "No login with the specified name exists." even if the login exists. sp_passwordpolicy 'expire role password' raises error 17678, "Illegal role name '%1!' specified." even if the role exists. This only affects logins/roles having upper case characters.

CR:482112

CR Number:   482112 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The ASE is limited to adding only one server certificate. The ASE should allow more than one server certificate to be added so that if the current one expires it can move to the next.

CR:482126

CR Number:   482126 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Linux Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2008 Added to user documentation Description If ASE12.5.4/15.0.x on RHEL5 does not set Exec-Shield to disabled and "LD_POINTER_GUARD" sets to 0, it cannot start multiengine.

CR:482129

CR Number:   482129 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2008 Fixed 14 Mar 2008 Fixed Description Under some circumstances the message "current process infected with 11" maybe reported in the error log when executing a batch of DML statements and a trigger executed a ROLLBACK TRIGGER WITH RAISERROR.

CR:482145

CR Number:   482145 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) 19 Dec 2007 Fixed 17 Oct 2007 Presently Not Targeted For Any Future Release Of This Product 05 Nov 2007 Fixed Description Add I/O write options for Add Database Device Wizard.

CR:482165

CR Number:   482165 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2007 Fixed 11 Oct 2007 Fixed Description In rare circumstances, a session may block on locks for object SYSANCHORS in a given database while its transaction log is undergoing truncation triggered either by an explicit 'DUMP TRANSACTION' command or by the 'CHECKPOINT SLEEP' process.

CR:482233

CR Number:   482233 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) 25 Oct 2007 Fixed Description There are no comprehensive password complexity checks performed when setting role passwords.

CR:482234

CR Number:   482234 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2007 Fixed 19 Oct 2007 Reservation Made 27 Oct 2007 Fixed Description For columns that "grow" so that update statistics on these columns are out-of-date fairly soon after update statistics is completed, this feature will assign some selectivity to out-of-range search clause accesses. This will only be done for search clauses that select values that are greater than all values in the domain described by the histogram. In the "set option show_lio_costing on" tracing, there will be messages associated with the selectivity of the column that indicate an "Out of range histogram adjustment" has been made. The selectivity assigned to each out of range search clause will be slightly less than the selectivity of one domain value i.e. if you have 100 unique values in the column, then 1/(100+1) is assigned to the out of range search clause, and then weights are stolen from the remainder of the cells in the histograms, including the newly created cell, so that all the cells in the normalized histogram still add up to 1.0. Thus, the actual weight in this example will be (1/101)/(1.0 + 1/101) after normalization to 1.0 The feature can be turned off by trace flag 15355. Workaround Description  editing stats so that the out of range histogram is "in range" can be done. using sampling more frequently may be a possibility

CR:482247

CR Number:   482247 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) 12 Oct 2007 Fixed 22 Oct 2007 One-off Provided Description Server might choose a wrong index when a query uses TOP and ORDER BY at the same time.

CR:482269

CR Number:   482269 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2008 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description ASE corrupts characters, returns "NoSuchElementException" or stack traces in the module SybXmlString() when using the FOR XML statement on characters outside of the basic 128 ASCII character set. Currently, ASE XML only supports the basic ASCII character set.

CR:482274

CR Number:   482274 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2008 Not a Bug Description This is the response from engineering following their testing for this CR: I am able to see non-zero values for I/O busy in sysmon report with 15.0.2 ESD#2 binary. Hence it is not the case that always I/O busy value is reported as '0'. Also the value of "I/O ticks", the counter used by sp_sysmon is incremented only if the CPU has no task to run(i.e. it is idle) and some I/O is pending. If there are tasks to be run then only "cpu ticks" counter is incremented. Hence it is not a bug if the I/O busy value is '0' unless the customer observes any performance drop. Hence closing the CR as not a bug.

CR:482275

CR Number:   482275 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) 21 Apr 2008 Fixed Description Add Distribution Mode support in Logical Cluster property and 'add logical cluster' wizard. Add 'Login Distribution' column to Logical Clusters' detail information tab.

CR:482284

CR Number:   482284 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) 05 Nov 2007 Fixed 06 Nov 2007 Fixed Description Running the datachange() builtin with no specified column (analyze datachange across all histogramed columns) could result in a SIGSEGV or SIGBUS error. This could occur if there are a lot of columns in the table with histogram statistics. The problem is more likely to occur if no partition id (check the column's datachange across all partitions) is provided and the table has many partitions.

CR:482322

CR Number:   482322 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2007 Fixed 18 Oct 2007 Fixed 31 Oct 2007 Fixed Description Under allrows_oltp mode, a plan with nary nested loop join and a merge union as the first branch of the nary nlj, may return too few rows.

CR:482329

CR Number:   482329 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 Dec 2007 Duplicate Description A DataDirectODBC driver cannot connect to ASE15.0.2 from MS-Access.

CR:482353

CR Number:   482353 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Open OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When creating an index as follows: create index "AA_KK" on "AA" ("last_modified") and before you set quoted_identifier on then the index, when looking at it should display AA_KK .

CR:482356

CR Number:   482356 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2008 Not a Bug Description DBCC upgrade_object reports no error upgrading certain procedures even when the 'check' option gives error 11031: Execution of procedure <procedure_name> failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo. Workaround Description  Drop empry procs that fail check.

CR:482357

CR Number:   482357 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2008 Not reproducible with latest version of the product available as of Resolution Date Description DBCC upgrade_object(database_name, 'procedure', 'check') fails all subsequent stored procedures after just one has failed. Workaround Description  Fix first failing sproc and re-run.

CR:482369

CR Number:   482369 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   Windows XP Original Version:   tyresias Fixed Version Build Resolution Date Closure Code (If Appropriate) Description PDM -> XML: If a PDM contains tables having a non-mandatory FK reference inbetween and you generate an XML model, the table with FK is shown as completely dependant on the depending one and does not reflect the independant part of the table.

CR:482398

CR Number:   482398 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) 30 Jun 2008 Fixed Description If an attempt is made to use DISK INIT/DISK RESIZE to add more space to a device than is actually available, the command aborts on some systems and on some systems the commands executes to add as much space as is available.

CR:482404

CR Number:   482404 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) 21 Oct 2007 Fixed 21 Oct 2007 Fixed Description Queries involving null character/unicode strings may result in stack trace or Msg 540 in single-byte non-binary servers or in utf8 binary servers in allrows_oltp mode. Workaround Description  We may try 1.use default optgoal 'allrows_mix' if 'allrows_oltp' optgoal fails 2. -T15363 if the problem query has more than 6 joinning tables ( please see CR 465375 for trace flag 15363).

CR:482428

CR Number:   482428 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2007 Fixed 02 Nov 2007 Bundled Request 06 Nov 2007 Fixed Description HK CHORES task may fail to generate a new RSA key pair for network password encryption with the message "ks_falloc: Cannot allocate using ubfalloc" because Network Buffers are filled up.

CR:482472

CR Number:   482472 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2008 Duplicate Description When 'plan text pipe active' is set to 1 & show_sqltext option is on SQL text in the tracefile is replicated or displayed twice.

CR:482473

CR Number:   482473 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2008 Fixed Description When SQL Text display is turned ON with Application Tracing feature, then the SQL Text for commands executed by user are not differentiated from internally executed commands.

CR:482480

CR Number:   482480 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2007 Fixed 17 Jan 2008 One-off Provided 03 Apr 2009 One-off Provided 16 Jan 2008 Bundled Request 11 Mar 2008 Presently Not Targeted For Any Future Release Of This Product Description Under some conditions ASE performs too many writes to sysprocedures when Trace 299 is ON.

CR:482482

CR Number:   482482 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) 16 Oct 2007 Consult Complete 02 Nov 2007 Fixed 16 Jan 2008 Fixed 03 Apr 2008 Fixed Description When killing a task in "LATCH SLEEP" state, message "Killing spid: <SPID_1> will not be immediate because it is waiting for a latch held by spid: <SPID_2>." will be printed to the errorlog. This connection cannot be killed until all latch owners have completed their work or terminated. Workaround Description  1. select lct_admin('abort', 0, db_id('tempdb')) 2. sp_dboption tempdb, 'abort tran on log full', true 3. use RG resource governor to manage tmpdb consumption 4. Define mutliple TMPDBs

CR:482499

CR Number:   482499 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 Oct 2007 Fixed 23 Oct 2007 Fixed Description Insert or Update statements that contain datetime values fail for proxy tables mapped to a Direct Connect server. Workaround Description  set capability 121 = 0 in the gateway. dbcc cis(setcaps, <direct connect>, 121, 0)

CR:482563

CR Number:   482563 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) 31 Oct 2007 Fixed 16 Jan 2008 Fixed 02 Apr 2008 Fixed Description Unnecessary join with sysprocedures, in a SQL command in the procedure 'sp_sproc_columns'. Its columns are not being used either in projection list or where clause. This is leading to more I/Os which are unnecessary.

CR:482566

CR Number:   482566 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) 26 Oct 2007 Fixed 30 Oct 2007 Fixed 18 Dec 2007 Fixed 17 Dec 2007 Reservation Made 20 Dec 2007 Fixed Description Queries involving Sybase outer joins and access rules can sometimes lead to error 325.

CR:482590

CR Number:   482590 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2007 Fixed 19 Oct 2007 Fixed Description Process trying to establish communication with remote server cannot be killed

CR:482624

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

CR:482645

CR Number:   482645 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2007 Fixed 18 Oct 2007 Fixed Description Stored procedure may raise error 622 "Opentable was passed a varno of 0. Object 'table_name' in database 'db_name' already has that session descriptor in use" during recompilation. Workaround Description  use trace 7730 to disable runtime compilation.

CR:482690

CR Number:   482690 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a command to reactivate a device that failed to activate during ASE startup. This can currently be accomplished by manually deleting the row for the device from sysdevices and then used the DISK REINIT command to restore the row and activate the device. Workaround Description  Make a record of the values for this device in sysdevices and delete the row. Then use DISK REINIT to restore the row and activate the device.

CR:482711

CR Number:   482711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2007 Fixed Description DBCC REBUILD_TEXT has been extended to set replication related fields in each first text page.

CR:482759

CR Number:   482759 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2007 Consult Complete 03 Apr 2008 Consult Complete Description Rep Agent is slow to send data to RS. Workaround Description  none. We tried increasing sqm_recover_segs, exec_cmds_per_timeslice, changed sqm_write_flush to off since customer is using file systems for stable device. None of these values changed settings received from RS.

CR:482761

CR Number:   482761 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In-exact numeric (e.g.float, double precision) values should be passed by the Rep Agent in the manner they were inserted or would be displayed when using isql. Workaround Description  None

CR:482836

CR Number:   482836 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) 26 Aug 2008 Insufficient priority to fix Description Make error messages 10708 and 10734 more informative

CR:482850

CR Number:   482850 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) 4.5 27 Aug 2008 Fixed 18 Jun 2008 Fixed Description Problem: [Microsoft][ODBC Microsoft Access Driver]Invalid datetime format (null) error when running the 'Demo Transfer German Sales' project on Windows Vista Resolution: This is a known issue. The source of the problem seems to lie in either the Vista ODBC driver manager or Vista memory management. If possible, use native database connectivity instead of ODBC connectivity.

CR:482898

CR Number:   482898 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) 24 Oct 2007 Fixed 26 Oct 2007 Fixed Description Sig11 could happen during codegen (CgEvals::_CgCompVcol()) for outerjoin query when either the ON clause predicate involves correlated subquery or there is a nested join inner to the outerjoin. Workaround Description  For the original query, the customer may break the query into two smaller queries, e.g. use a temporary table for FlexDependentType c: select * into #work1 from FlexDependentType c where ((@event_dt BETWEEN c.cov_beg AND ISNULL(c.cov_end,'12/31/2999')) OR (c.cov_beg > @event_dt AND c.cov_beg < ISNULL(c.cov_end,'12/31/2999'))) and c.ssn_nr = @ssn_nr AND c.dep_id != 0 and rewote the original query: SELECT * FROM PersonHistory a ,pRelationType b ,#work1 c ,FlexPlan d WHERE a.ssn_nr = @ssn_nr AND a.status = 'A' AND b.comp_nr = @comp_nr AND b.relation_cd =* (SELECT R1.relation_cd FROM PersonRelation R1 WHERE R1.ssn_nr = @ssn_nr AND R1.id_nr = a.id_nr AND R1.eff_dt < ISNULL(R1.exp_dt,'12/31/2999') AND R1.eff_dt = (SELECT MIN(R3.eff_dt) FROM PersonRelation R3 WHERE R3.ssn_nr = @ssn_nr AND R3.id_nr = a.id_nr AND R3.eff_dt < ISNULL(R3.exp_dt,'12/31/2999') AND @event_dt < ISNULL(R3.exp_dt,'12/31/2999')) AND @event_dt < ISNULL(R1.exp_dt,'12/31/2999')) AND a.id_nr = c.dep_id AND d.comp_nr = @comp_nr AND @event_dt BETWEEN d.eff_dt AND ISNULL(d.exp_dt,'12/31/2999') AND @rk_FlexPlan LIKE d.rule_key AND c.type_nr = d.type_nr AND d.plan_nr = @plan_nr

CR:482909

CR Number:   482909 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2007 Bundled Request 01 Nov 2007 Bundled Request Description HK CHORES task may flood the error log with many "RSA keypair regeneration failed" messages when the regeneration of a keypair fails.

CR:482940

CR Number:   482940 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) 28 Dec 2007 Fixed 11 Mar 2008 Presently Not Targeted For Any Future Release Of This Product Description Query with view with unions which uses dynamic index strategy may sometime fails with different errors related to the sort operation. Sometimes the stack trace in the errorlog may indicate the module startscan. Workaround Description  Use traceflag 4402.

CR:482961

CR Number:   482961 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) 01 Nov 2007 Fixed 01 Nov 2007 Fixed Description A distinct clause may be ignored in an insert ... select statement when there is no order by specified and the insert includes a timestamp column. Workaround Description  1. add 'order by' clause e.g. select distinct a,substring(b,1,8),null from t1 order by a 2. set distinct_hashing off

CR:483019

CR Number:   483019 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) 29 Nov 2007 Fixed Description If the database has indexes with the same name and different type (one local and one global) on different tables then sp_helpindex on a specific table will report wrong index type i.e. global index as local index.

CR:483041

CR Number:   483041 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) 07 Nov 2007 Fixed Description When an unserved per-CPU license is used, ASE always limits the 'max online engines' configuration to the quantity of per-CPU licenses. When a machine is fully licensed ASE should allow the 'max online engines' to be equal to the number of logical CPUs. Target Version  15.0.2 ESD#2 Workaround Description  Use served licenses

CR:483063

CR Number:   483063 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) 28 May 2010 DEFER 07 Nov 2011 Presently Not Targeted For Any Future Release Of This Product Description Under some cicumstances when resolving temporary objects in complex permission situations we may fail to find objects we earlier created.

CR:483164

CR Number:   483164 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2007 Fixed Description Replication Agent error messages and traces may show a zero database number, instead of showing the database number where Replication Agent is running.

CR:483165

CR Number:   483165 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2008 Fixed Description In rare circumstances, the message "current process ... infected with 11" may be reported in module 'dfl_dmp_initflushlist' or 5205 error may be returned during the execution of a DUMP DATABASE command, The modules 'cdfl_dmp_initflushlist' and 'dpdb_main' would also be reported in the stack trace in the error log.

CR:483183

CR Number:   483183 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) 19 Oct 2007 Fixed 18 Oct 2007 Fixed Description Stored procedure execution may resume from the incorrect statement after the failure of the runtime compilation. Workaround Description  Boot ASE with -T7730.

CR:483205

CR Number:   483205 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2008 One-off Provided 01 Jul 2008 One-off Provided Description When attempting to create an index on certain text document, indexing fails and EFTS enters into an infinite loop filling EFTS log with similar errors: "GW_TOKEN, gwSession: <session id>, vs_streamGetToken called too many time for stream <stream id>, key <doc key>". Looping is caused by repeated calls to the stream call back function. Workaround Description  None known.

CR:483225

CR Number:   483225 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 Dec 2007 Fixed 27 Feb 2008 One-off Provided Description A client attempting to execute a parameterized language request gets an Error 154, "Variable not allowed in procedure" when attemping FOR XML during an insert trigger. Workaround Description  1. if the client uses a PreparedStatement in jConnect but actually has no parameters then there is no problem. Using Statement not PreparedStatement is not a problem. 2. forxmlj or convert(java.lang.String, 'select ... for xml ... ') is also ok. 3. CR 478800 also a problem with "for xml" in a trigger has a similar workaround convert(java.lang.String...) but traceflag 112 does not provide any workaround for this problem.

CR:483255

CR Number:   483255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Help investigate why RA is in wait state.

CR:483286

CR Number:   483286 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2008 Fixed 02 Mar 2008 Fixed Description MDA process which calls monlocks will cause timeslices when holding a spinlock.

CR:483363

CR Number:   483363 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) 21 Nov 2007 Fixed 09 Jun 2008 Fixed 23 Jun 2008 Fixed Description In rare circumstances, a race condition may occur between the ASE thread and its corresponding Q engine native thread, leading the ASE spid to hang. In that case, the IBM MQ API call is not executed and the ASE process is wongly waiting for the completion of that messaging call.

CR:483387

CR Number:   483387 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 Mar 2010 Fixed 03 Nov 2011 Duplicate Description monOpenObjectActivity.RowsInserted doesn't count inserts through fast BCP

CR:483404

CR Number:   483404 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 Nov 2007 Duplicate Description To allow all password complexity checks to be extended on login/role level

CR:483418

CR Number:   483418 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2007 Fixed Description Update value of SYBASE_JRE15 to "jre150_012"

CR:483430

CR Number:   483430 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2007 Fixed Description text server crashes after calling sp_text_notify if a non-existent text index is referenced in the text events table

CR:483461

CR Number:   483461 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request to add a global variable that contains $SYBASE value.

CR:483464

CR Number:   483464 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to have auditing of logins include additional data "client application", "network user", and "client identifier" for application servers.

CR:483468

CR Number:   483468 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2007 Fixed 31 Oct 2007 Presently Not Targeted For Any Future Release Of This Product Description Verification of the SSL Certificate may incorrectly fail with the following message: "Warning: command 'addcert' adds certificate path <certifcate path> with its common name field different from server name."