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

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

CR:404738

CR Number:   404738 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2006 Fixed 30 Aug 2006 Presently Not Targeted For Any Future Release Of This Product Description Unexpected truncated data maybe inserted into a table when the INSERT or UPDATE statement is executed inside a stored procedure and a change in the underlying tables used by the stored procedure caused more than one internal renormalizations. Workaround Description  Use T7706 which activates the old fix made in CR 320027.

CR:404751

CR Number:   404751 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) 07 Oct 2005 Fixed Description When the option SET ROWCOUNT is set within a procedure where SET EXPORT_OPTIONS is ON, the option is not exported to the procedure caller.

CR:404755

CR Number:   404755 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Fixed Description An unexpected 515 error, "Attempt to insert NULL value into column 'column', table 'table_name'; column does not allow nulls" may be raised when executing an INSERT statement inside a stored procedure and the option STRING_RTRUNCATION is ON and the value to be inserted only contains blanks. Workaround Description  Use T7709 to disable the fix for CR 326477. And use T7706 to enable the fix for CR 320027.

CR:404816

CR Number:   404816 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2005 Fixed Description Separate object id/name and partition id/name parameters in the following dbccs. The new syntax is shown below: dbcc tablealloc(tablename | tabid [, full | optimized | fast [, fix | nofix [, data_partition_name | data_partition_id ]]]) dbcc indexalloc(tablename | tabid, indid [, optimized | fast [, fix | nofix [, partition_name | partition_id ]]]) dbcc rebuild_text(table | "all" [, column [, text_page [, data_partition ]]])

CR:404841

CR Number:   404841 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2005 Fixed Description dbcc checkstorage and reorg rebuild, when run concurrently, may result in an undetected deadlock due to missing wakeup in a rare window.

CR:404919

CR Number:   404919 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) 12 Dec 2005 Fixed Description When executing system stored procedure sp_helpdb and the option QUOTED_IDENTIFIER has been set some unexpected errors may be raised and the procedure will fail. Workaround Description  Turn off quoted identifiers from the jdbc connection before running sp_helpdb

CR:404941

CR Number:   404941 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   AIX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2006 Fixed Description Dump with native compression to tape fails with error number 22. This has been fixed for the NT and Linux platforms.

CR:404949

CR Number:   404949 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2006 Fixed Description ASE returns conversion error 9502 when doing an implicit conversion from unichar to nchar. Workaround Description  An explicit conversion seems to work just fine: 1> insert into SYBRTRUNC(COL_NCHAR) values (convert(nchar(1),@c1)) 2> go

CR:404953

CR Number:   404953 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2005 Fixed Description Fixed a potential sig 11 stacktrace during code generation for CIS query involving subquery. Target Version  15.0 ESD#1

CR:405000

CR Number:   405000 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2005 Fixed Description Upgrade to 15.0 from a 12.5.x release containing the encrypted columns feature may fail while upgrading sysindexes. This occurs because column IDs for encryption-related sysindexes columns are different between the two releases.

CR:405028

CR Number:   405028 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2005 Fixed Description The system stored procedure sp_statistics returns extra data. In addition the order of data are not consistant with documentation.

CR:405034

CR Number:   405034 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   SunOS Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2005 Fixed Description Error 3121 "Index sysobjects.ncsysobjects (objid=1, indid=2) may be invalid..." maybe reported in the error log during ONLINE DATABASE, after loading the database that is dumped by a server using a different charset id than the current server. A table created in pre-15.0 system and then altered into range-partitioned table with char/varchar partition key column(s) may be marked as SUSPECT and thus read-only during sort order/char set change that normally wouldn't make the range partition suspect.

CR:405106

CR Number:   405106 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2012 Workaround Description Feature Request : Functionality to be able to redirect jobs output to redirect to a flat file. Workaround Description  Sample SQL script to get job output into flat file for jobid = 1 to 10. <js_out.sql> use sybmgmtdb go declare @i int declare @name varchar(30) select @i = 1 while (@i <10 ) begin select "sjobid = ", @i ---- printing job id select @name = sjob_name from js_scheduledjobs where sjob_id = @i exec sp_sjobhelp @name ---- printing job information select * from js_output where jsout_exid in ( select jsh_exid from js_history where jsh_jobid = @i select @i = @i + 1 end go </js_out.sql> Customer can get the job output into flat file js_out.txt like this : $ isql -i js_out.sql -o js_out.txt

CR:405112

CR Number:   405112 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2005 Fixed 05 Dec 2005 Fixed Description When using parallel mode, a query cannot use an index on an inner table of a nested loop join. This is prevalent in a case where the partitioning of the inner table of a nested loop join is useless with respect to the columns in the join clause. This fix can only be enabled using a session level command "set replicated_partition 1".

CR:405113

CR Number:   405113 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) 13 Jan 2006 Fixed Description Possible different trailing spaces from pre-150 when assigning an order-by char type column to a char type variable. Here is an example: create table #t (c1 char(5) null ) go insert #t values ('123') go declare @v1 char(10) select @v1 = c1 from #t order by c1 go @v1 would have different number of trailing spaces compared to pre-150. Workaround Description  turn on trace flag 566 ( session level or server level) dbcc traceon(566) go

CR:405118

CR Number:   405118 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2005 Fixed Description Query performing view materialization using parallel strategy may return incorrect results. Workaround Description  In the view define two different subqueries returning the same result. In the main query reference one subquery result in the SELECT list, the other in the main query subquery. Eg. in the ct query I did - create view managed_product_spot_vw_wk as select mp.managed_product_key ,mp.name ,mp.product_key ,basis_weight_lb = (select max(convert(dec(5,2),mpa1.attribute_value)) from test_db..managed_product_a ttribute mpa1 where mp.managed_product_key = mpa1.managed_product_key and mpa1.attribute_cd = "PA BW" ) ,basis_weight_lb1 = (select max(convert(dec(5,2),mpa1.attribute_value)) from test_db..managed_product_attribute mpa1 where mp.managed_product_key = mpa1.managed_product_key and mpa1.attribute_cd = "PA BW" ) ...................... and when selecting from the view I do ... select ... mpvw.basis_weight_lb , mpvw.grade_cd , mpvw.roll_width_cd , mpvw.reel_diameter from ...,test_db..managed_product_spot_vw_wk mpvw and exists (select 1 from #roll_width rw where rw.roll_width_cd = mp vw.roll_width_cd1) ................

CR:405125

CR Number:   405125 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) 08 Mar 2006 Consult Complete 08 Feb 2006 One-off Provided 08 Feb 2006 One-off Provided 08 Feb 2006 One-off Provided 08 Feb 2006 One-off Provided 10 Mar 2006 One-off Provided 10 Mar 2006 One-off Provided 10 Mar 2006 One-off Provided 27 Apr 2006 One-off Provided Description LDAPUA feature enhancements to support: 1. Configurable timeout mechanism for binds and searches to the LDAP server. 2. Configurable number of LDAPUA native threads per engine. 3. LDAPUA error reporting improvements.

CR:405315

CR Number:   405315 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2005 Fixed Description If the "number of open objects" is under configured, the message "current process infected with 11" in the module 'crc_ckconstr' together with a stack trace which includes the modules 'crt_main' and 'crt_constr' may be reported during the creation of a table. Similarly, the message "current process infected with 11" in the module 'procrm' together with a stack trace which includes the modules 's_recompile' and 's_rmpbuf' may be reported during the execution of a stored procedure. Workaround Description  Try increase the "number of open objects".

CR:405328

CR Number:   405328 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed 11 Oct 2005 Fixed Description Union queries that use a NULL constant in the select list of the union's first select statement and are the source for an insert statement may return wrong result or stacktrace. The following union provides an example: insert foo (c1, c2, c3) select c1, c2, c3 = null from t1 union select c1, c2, c3 = c1 from t2 The problem may not occur depending on how columns are aligned in the underlying data row.

CR:405329

CR Number:   405329 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation and Configuration Guide-ASE Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2006 Fixed Description Documentation errors in ASE doc "Configuration Guide Adaptive Server Enterprise for UNIX" http://sybooks.sybase.com/onlinebooks/group-as/asp1251e/uconfig/@Generic__BookTextView/1885;pt=2093;nh=1?DwebQuery=user+objects#X (1) Under Table Specifications, "User Objects per database" has the maximum value of "231 - 100". This is incorrect and the expression should be presented as 2 to the power 31 minus 100. (2) Similarly, the following entries are incorrectly presented: Under Adaptive Server Specifications, Database Specifications: (A) Maximum database size " 243(8TB) Minus overhead for system databases" The above maximum size should read 2 to the power 43 not 243. (B) Maximum size of a database device (disk partition) " 224(32GB) If the Operating System supports file sizes up to 32GB, then Adaptive Server supports file system devices up to 32GB" The above maximum size should read 2 to the power 24 not 224.

CR:405330

CR Number:   405330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2005 Fixed Description Some queries containing hash operators may attempt to allocate large private buffer pools. These pools could require a large chunk of contiguous memory which could lead to 701 errors even though there is ample free space in the procedure cache. A 701 error can be traced to this problem by rerunning problem query with traceflag 751 enabled. If the resulting stacktrace contains sort_auxbufinstall(), then this is the problem. Workaround Description  You may be able to get around the problem by lowering the maximum number of buffers that can be allocated using the dbcc tune command.

CR:405408

CR Number:   405408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3.a ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2006 Fixed Description Real time messaging for JMS configuration fails with 'cannot load dll' and OS error 182 in the errorlog. This can happen on windows 2003 or windows xp systems where system32\libeay32.dll is an older version than the libeay32.dll released with tibco. TIBCO recommends to copy libeay32.dll from TIBCO\clients\c\bin to system32. Workaround Description  TIBCO recommends to copy libeay32.dll from TIBCO\clients\c\bin to system32.

CR:405460

CR Number:   405460 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) 07 Oct 2005 Fixed 22 Dec 2005 Fixed Description At login time, if the password has expired, it is possible that a shared page lock on syslogins is not released after the login has completed. Workaround Description  This action is only needed once, because it will update the number of variable length columns in all the rows in the table from 6 to 9, and this is one of the conditions needed for the problem to occur: UPDATE SYSLOGINS SET LOGINCOUNT = 0 without any where clause.

CR:405491

CR Number:   405491 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   NA Original Version:   1.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Oct 2005 Bundled Request Description New license files added to the SYSAM-2_0/licenses directory or new licenses added to a license file may not be detected when ASE is currently running with graced licenses.

CR:405510

CR Number:   405510 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2005 Fixed Description Permissions for operations (decrypt, create/alter/drop encryption key) did not display properly in ASE Plugin.

CR:405514

CR Number:   405514 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2005 Fixed 14 Nov 2005 Fixed Description A cursor declared on a select statement with a where clause that searches an encrypted column using a literal value may fail to find qualifying rows. The failure occurs if the column being searched is encrypted by a key created with init_vector NULL.

CR:405646

CR Number:   405646 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2005 Fixed Description Incorrect result set ordering for an INSERT ... SELECT.. ORDER BY ... query where some of the ORDERBY columns is not part of the INSERT scalars. For example: insert into t1 (col1) select col1 from t2 order by col1, col2 desc In the above query, col2's ordering requirement may not be enforced.

CR:405738

CR Number:   405738 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2007 Fixed 08 Mar 2007 Fixed 14 Jan 2008 Fixed Description When using JCONNECT, if the query includes the db name, the dbname is not included in the TDSROWFMT2 response.

CR:405739

CR Number:   405739 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2005 Fixed 04 Oct 2005 Fixed 04 Oct 2005 Fixed Description Due to change in system catalog DDLGen was generating wrong DDL for database. This fixes the problem, by generating correct value of the database size.

CR:405758

CR Number:   405758 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2006 Presently Not Targeted For Any Future Release Of This Product 25 Apr 2006 Not reproducible with latest version of the product available as of Resolution Date Description Optimizer doesn't cost LIKE CLAUSE properly. Customers may use force index to workaround. Workaround Description  Use force index

CR:405763

CR Number:   405763 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2005 Fixed 04 Oct 2005 Fixed 04 Oct 2005 Fixed Description ASEPlugin reported wrong value for device size for data servers with 4k, 8k and 16k page sizes. This is fixed to show the right values

CR:405784

CR Number:   405784 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 May 2008 Fixed 15 May 2008 Fixed 07 May 2008 Fixed Description The "Add" items (e.g. "Add Database Device") in various folders, normally used for opening a wizard, are replaced by toolbar buttons (e.g. "Database Device" button).

CR:405894

CR Number:   405894 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2005 Fixed Description SQL Logging dialog now saves the previously set options. Two additional options are added: adding 'go' at the end of each SQL statement, and displaying row numbers in query output. Also, date/time output now contains the elapsed time of the SQL. Note the elapsed time, displayed as 'Execution time', include the time that ASE Plug-in spends before and after the query execution (preparing query and processing query results, e.g.)

CR:405996

CR Number:   405996 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   HP-UX Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2005 Fixed Description CIS: "create proxy_table" which maps onto a remote server supporting DECIMAL identity might result in message 11246 "Precision or scale mismatch in remote object..."

CR:406003

CR Number:   406003 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2005 Fixed 12 Oct 2005 Fixed Description Database Properties Usage page is modified. It now only reports the following information: database size, reserved space, used space (by data and indexes), unused space, and unreserved space.

CR:406004

CR Number:   406004 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2005 Fixed 10 Oct 2005 Fixed 11 Oct 2005 Fixed Description 15.0 GA suffered the following problems CR 406159 : Wrong Device Size in creation and the current CR, i.e duplicate context menu items for a db created for load These are fixed

CR:406005

CR Number:   406005 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2005 Fixed 14 Oct 2005 Fixed 21 Oct 2005 Fixed 08 Nov 2005 Fixed Description Downgrade from 1253a and then running sp_bindrule, sp_bindefault, etc causes stack trace because of the extra columns added in syscolumns for encrypted columns.

CR:406060

CR Number:   406060 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed 13 Jan 2006 Fixed 13 Jan 2006 Fixed Description An 8201 error "Keep count of descriptor ... was expected to be 1. Instead 2 was found." may be raised during LOAD TRAN or LOAD DATABASE, when the configuration parameter "per object statistics active" is turned on. Workaround Description  disable per object statistics collection during load tran or load database

CR:406068

CR Number:   406068 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2005 Fixed 08 Nov 2005 Fixed Description Encrypted columns of type CHAR, VARCHAR, BINARY and VARBINARY that are specified as nullable fail to decrypt using ALTER TABLE .. MODIFY .. DECRYPT. Workaround Description  BCP out the data from the table as plaintext (do not use -C flag), drop and recreate the table, and BCP in the data.

CR:406092

CR Number:   406092 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2005 Fixed Description During Migration Tool (sybmigrate) setup using the graphical interface: on the repository database setup screen the drop-down that shows a list of potential devices to use for the creation of the repository database may be empty if no devices have enough free space. If the Next> button is pressed a java NullPointerException is raised at com.sybase.sybmigration.gui.SPWizRepositoryPage.validateInput(SPWizRepositoryPage.java:259) Workaround Description  Free up space on an existing device (enough for the repository database size shown on in the wizard) or create a new device large enough for the database.

CR:406129

CR Number:   406129 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) 11 Oct 2005 Fixed 12 Oct 2005 Fixed Description In the ASE Plugin, the Server SQL Execution tab has been made modeless, columns for SQL Execution Time and Number of rows returned have been added to the Messages tab, and a split panel has been added between the SQL Editor and output panes.

CR:406143

CR Number:   406143 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) 03 Jan 2006 Fixed 04 Jan 2006 Fixed 27 Mar 2006 Fixed 29 Mar 2006 Fixed 12 Apr 2006 Fixed Description Using External File Support (XFS) to read from a file larger than 2GB that has been mapped to a proxy table can result in errors (for example, "Failed to seek to offset -NNNNNNNNNN").

CR:406158

CR Number:   406158 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2009 Insufficient priority to fix Description enhance ASE/CIS to send the...noholdlock...syntax through to DC/dcany/MSSQL cross reference CR 406116...DC/dcany/MSSQL...add sqlxformation to convert...Sybase noholdlock...to Microsoft with (nolock)

CR:406166

CR Number:   406166 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2005 Fixed Description Due to packaging error, ASE Plugin included in 12.5.3 ESD#3 and ESD#4 cause following errors. When ASE Plug-in that is coded with JRE 1.4 is run with 1.3 JVM, it gives stack trace during Create Table which results in a stack trace that says java.lang.NoSuchMethodError. When ASE Plug-in that is coded with JRE 1.3 is run with 1.4 JVM, focus error will be seen during Create Table.

CR:406276

CR Number:   406276 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) 23 Nov 2005 Fixed Description System stored procedures like sp_tables and sp_stored_procedures do not allocate sufficient space for the input paramater @table_name. Workaround Description  rewrite sproc. Enlarge identifiers table_name, owner and columnname from 32 to 255.

CR:406294

CR Number:   406294 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2006 Fixed Description jsagent process terminates and core file is generated when the user issues the sp_js_wakeup "stop_js", 1 command.

CR:406300

CR Number:   406300 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) 11 Oct 2005 Fixed 11 Oct 2005 Fixed Description Fixed error 586/16/5 when running query with ORDER BY and IDENTITY. Target Version  15.0 ESD#1

CR:406303

CR Number:   406303 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) 17 Oct 2005 Fixed 11 Oct 2005 Fixed Description Upgrade process and system stored procedure sp_checkreswords cannot identify the following new ase15.0 keywords: "count_big", "materialized", "tracefile", "semi_sensitive", "insensitive", "scroll".

CR:406313

CR Number:   406313 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) 09 Jan 2006 Fixed Description Previously Databases folder was sorted incorrectly when connected to a 12.0 ASE. This has been fixed.

CR:406314

CR Number:   406314 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) 12.5.3 ESD#5 11 Oct 2005 Bundled Request Description The changes included in OCS 12.5.1 ESD#10 include fixes for the following issues: SCL/Kerberos memory leaks on successful connections when using MIT Kerberos, CR 385928. After many hundreds or thousands of successful Kerberos connections, memory leak resulted in memory allocation errors in the errorlog and authentication errors returned to clients. The memory allocation errors reported: "Security Control Layer's memory allocation routine returned an error." An API change occurred to OCS internal functions used by Security Control Layer (SCL) drivers called by ASE. The request ID changed to type long to handle 64bit request ID used by SCL and DCL drivers. CR 384600, the associated OCS fix, avoids a segmentation violation that can occur on 64 bit platforms when using Kerberos or Directory Services lookups.

CR:406317

CR Number:   406317 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) 21 Jul 2006 Fixed 14 Oct 2007 Presently Not Targeted For Any Future Release Of This Product Description Java-based ASE Plugin interface does not provide a way for user with expired password to update their password.

CR:406324

CR Number:   406324 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2009 Fixed Description If buffer pool tuning is performed during recovery, sp_cacheconfig shows that "Config Size" for the default I/O pool in the 'default data cache" is smaller than the value configured in the config file. Workaround Description  Use traceflag 3474 - disable buffer pool tuning at recovery. Or remove the smallest sized buffer pool from the .cfg file.

CR:406437

CR Number:   406437 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) 12 Jan 2006 Fixed 03 Feb 2006 Fixed Description Stacktrace sometime occurs in sp_showplan for queries running in parallel.

CR:406443

CR Number:   406443 Product Name:   Adaptive Server Enterprise Product Component:   coverletter Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2005 Not a Bug Description The error 18807 may occur when running sp_deviceattr for master device.

CR:406454

CR Number:   406454 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) 08 Mar 2006 Fixed 15 Mar 2006 Fixed Description Implement a NONTRANSACTIONAL PROCEDURE option for CREATE EXISTING TABLE to avoid blocking issues with SELECT INTO.

CR:406473

CR Number:   406473 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2005 Fixed 07 Nov 2005 Fixed 02 Jan 2006 Fixed 02 Jan 2006 Fixed Description ASE 12.5.1 or later versions prior to 12.5.3 ESD #5 and version 15.0 treat block device the same as raw device. ASE assumes all writes have been committed to disk, while the modified pages may be retained in the OS kernel cache. In the event of a power failure or other system crashes, the cached modifications may be lost leading to data inconsistency. Using a shutdown with nowait by itself would not cause an inconsistency. Recovery would of course take more time during the next startup if we do a 'shutdown with nowait' though. There is also a possibility that if theres a system crash or a power outage during shutdown, it could lead to a data loss. However, note that a system crash has to occur for us to encounter this sort of situation.

CR:406478

CR Number:   406478 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2005 Fixed 15.0 EAP 06 Feb 2006 Fixed Description The order of tables in queries having a large number of tables in the FROM clause affects the plan chosen.

CR:406502

CR Number:   406502 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) 05 Feb 2008 Insufficient priority to fix 25 Apr 2008 Fixed Description The message "process infected with signal 11" in the module 'procstat_get' may be reported in the error log together with a stack trace which includes the modules 'exec_dbcc' and 'memusage' when a DBCC MEMUSAGE command has been previously run against a busy ASE system resulting in ASE shutting down itself.

CR:406535

CR Number:   406535 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   NA Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2006 Fixed 18 Aug 2006 Fixed Description Enable monitoring tables to return data and statistics from multiple instances in an ASE shared disk cluster from one query and in one result set.

CR:406547

CR Number:   406547 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) 19 Oct 2005 Fixed 21 Dec 2005 Presently Not Targeted For Any Future Release Of This Product 19 Oct 2005 Fixed Description In rare circumstances, the message "current process infected with 11" or a timeslice error may be reported in the error log during boot time after recovery processes a PFTS log record that contains information about a bogus page number. Workaround Description  Boot the server with -T3443. This disables the use of PFTS by recovery.

CR:406591

CR Number:   406591 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   ulysses Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2005 Not a Bug Description Target DBMS: Oracle 10G XML Schema def 1.0 In the XML model, the customer has used the Mapping Editor to create a mapping to the PDM. In the Mapping Editor, they have added a user defined query. When the generate the SQL\XML query, the where clause is not included.

CR:406606

CR Number:   406606 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Solaris Original Version:   11.5.1.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2005 Fixed Description New sybmon command 'showrecovery' to print recovery information for a given database.

CR:406623

CR Number:   406623 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) 25 Oct 2005 Bundled Request Description SCL error messages are not available to display on engine 1 and greater. Instead of the text message explaining the error that occured, the following message appears: 01:00000:00049:2005/10/12 15:59:25.84 kernel Failed to get the Connectivity Library (Security Control Layer) error message.

CR:406630

CR Number:   406630 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) 25 Oct 2005 Fixed 03 Nov 2005 Fixed 12 Jan 2006 Fixed Description When Kerberos or other SCL authentication mechanisms are used and 1601 errors such as the following occur due to attempts to exceed the limit of "user connection" resources, then a memory leak occurs. server There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections. server Error: 1601, Severity: 17, State: 7 After memory in the pool used by these authentication mechanisms is exhausted, memory allocation failures and segmentation violations occur with continued authentication attempts. Memory allocation failures appear with message: server Security Control Layer's memory allocation routine returned an error. Segmentation violations due to attempts to use invalid addresses appear with message: kernel current process (0x11200025) infected with 11 kernel Address 0xff130988 (memset+0x74), siginfo (code, address) = (1, 0x00000000) These messages may be accompanied with or without stacktraces in the errorlog.

CR:406631

CR Number:   406631 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) 20 Sep 2007 Fixed Description Performance enhancement for update statistics affecting minor columns.

CR:406637

CR Number:   406637 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2005 Fixed Description When a 11.9.x or 12.0.x installation is upgraded to ASE 15.0, the configuration parameters 'enable surrogate processing' and 'enable unicode normalization' will not have the configuration and run values set to the default value. Please see the system administration guide for descriptions of the above mentioned configuration parameters. The work-around is to modify the configuration parameter values in the configuration file and reboot Adaptive Server.

CR:406718

CR Number:   406718 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Windows W2k Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2005 Fixed 09 Nov 2005 Fixed 12 Jan 2006 Fixed Description Sometimes, mainly on single CPU machines, if the job scheduler is enabled, then the job scheduler may fail to start and the message "Job Scheduler Task failed to spawn an Agent" is reported in the ASE errorlog.

CR:406761

CR Number:   406761 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Install Guide-Adaptive Server Enterprise Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2006 Fixed Description install documentation should specify that the ASE started by install process must be stopped before ASE can be started as a windows service

CR:406777

CR Number:   406777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2005 Fixed Description Queries with sort operators that have a large estimated input size may encounter 701 errors. These queries can request large chunks of contiguous memory in the sort manager for merge run processing. The size of the requested memory is a function of the number sort buffers. In previous releases, this was bounded to 500 by default. The fix is to once again to bound the number of merge run buffers (how many runs can be merged at a time) to 500. This problem can be diagnosed from a memdump. The stack of the spid encountering the 701 error will contain alloc_merge() in it.

CR:406840

CR Number:   406840 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2005 Fixed Description A stored procedure with the SQL query with an aggregate in the having clause may fail to execute correctly raising error 2805 "Bad pointer 0x3294d04 encountered while remapping stored procedure" or the execution may be broken and stack trace logged in the errorlog file. Module "proc__mkworkrg" should be referenced in the backtrace.

CR:406929

CR Number:   406929 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) 31 Jan 2006 Fixed 02 May 2006 Fixed Description The error or warning messages do not display when enable/disable an existing invalid trigger name on a table.

CR:406934

CR Number:   406934 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) 14 Oct 2005 Fixed 14 Oct 2005 Fixed Description The following problems have been addressed in DBISQL: - CR401397 Previously DBISQL does not refresh database dropdown list when "create database" statement is inside a if...else statement. This has been fixed. - CR404078 Previously in 15.0 GA, DBISQL launch script "dbisql.bat" (Windows) and "dbisql" (Unix platforms) contained invalid argument "-path" that caused the script to fail. This has been fixed. (The correct argument is "-Dpath".)' - CR399694 DBISQL failed to import Excel 2.1 worksheet. This has ben fixed. - CR400053 Previously Make Permanent button of Options dialog does not save preferences permanently. This has been fixed in build 3204. - CR400479 Previously DBISQL command "output to" does not work for saving a single result set from a stored procedure, such as: sp_helpartition go output to sp_helpartition.txt go This has been fixed. - CR402435 DBISQL cannot be launched using the script file on Unix($SYBASE/DBISQL/bin/dbisql) and Windows (%SYBASE%\\DBISQL\\bin\\dbisql.bat).' - CR386931 Previously DBISQL does not display query result similar to the that of command-line isql. This has been addressed by adding a "Text" output mode, in addition to existing "Grid" output mode. To turn on Text output, open Options dialog by selecting menu item "Tools"->"Options...". On Options dialog, select "Results" from the left-hand-side list and select "Text" radio button to enable text output.

CR:406960

CR Number:   406960 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2005 Fixed Description On a 64-bit platform, stored procedure "sp_helpjava" cannot display correct serialVersionUID.

CR:407008

CR Number:   407008 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Nov 2005 Fixed Description There could be more reasons for Large I/O to be denied as compared to what is displayed in sp_sysmon o/p as has been indicated in cr 256785

CR:407021

CR Number:   407021 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2005 Fixed 07 Nov 2005 Reservation Made Description Procedure cache management is enhanced to perform auto-tuned large allocation. Procedure cache memory request start with chunks of 2k. Large chunks, upto 16k, are allocated based on the past allocation behavior for the query. The enhancement reduces external fragmentation in the procedure cache.

CR:407031

CR Number:   407031 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2006 Fixed 10 May 2007 Fixed Description When a named cache is configured too small for current demands, a message is posted in the log and the associated spid may keep looping , waiting for free buffers. The spid cannot be killed. Workaround Description  increase the pool. let job complete

CR:407033

CR Number:   407033 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2005 Bundled Request Description A stacktrace may occur when invoking on-line help from within Sybase Central.

CR:407057

CR Number:   407057 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) 18 Oct 2005 Fixed 20 Oct 2005 Fixed Description A 702 error may be generated from queries that contain hash operators with large estimated hash table sets (> 5.8 Gbytes).

CR:407076

CR Number:   407076 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2006 Fixed Description When Interactive SQL's Results panels is in Text mode, previously Export does not work (i.e. Export only worked in Grid mode.) This has been fixed so that Export works in both modes.

CR:407088

CR Number:   407088 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) 20 Oct 2005 Fixed 07 Nov 2005 Bundled Request Description Cross-platform load incorrectly fails to convert or initialize unallocated pages. In rare cases, the unconverted page contents may mislead recovery at some time in the future. Workaround Description  This problem can happen for both database with 'for load' option and without 'for load' option. Workaround for this problem is to run sp_dumpoptimize before DUMP DATABASE like: 1> sp_dumpoptimize 'archive_space = minimum' 2> go Backup Server: 4.172.1.1: The value of 'reserved pages threshold' has been set to 100%. Backup Server: 4.172.1.2: The value of 'allocated pages threshold' has been set to 100%. (return status = 0) so that unallocated page is not included in the dump file at dump database time. Other workaround for the already loaded database is to do a patch for unallocated pages (to zero page header), just to prevent a future recovery failure. Per Farima, dbcc checkstorage reports an error for such pages, where the unallocated pages is not translate.

CR:407117

CR Number:   407117 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A new feature request to create sybsystemdb on its own device, not master device.

CR:407169

CR Number:   407169 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2006 Fixed 14 Nov 2007 Deferred Description SLOW bcp into heap tables i.e. all cases except APL tables with clustered index, will behave like FAST bcp and do minimally logged updates when the db option 'bulk copy' is turned on.

CR:407191

CR Number:   407191 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) 28 Dec 2005 Fixed 22 Mar 2006 Fixed 22 Mar 2006 Fixed Description Stack trace when executing an update query on a table with parallelism enabled and when the table being updated has more than 8 referential integrity constraints are defined.

CR:407208

CR Number:   407208 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Closed OS:   Windows XP Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2005 Fixed 31 Mar 2006 Fixed Description Database 'sybsystemprocs' has a recommended size as well as a required size. The preupgrade utility should show both those sizes, instead of producing an error when it is below the required size and subsequently showing a warning when it is below the recommended size.

CR:407216

CR Number:   407216 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) 14 May 2007 Fixed 14 May 2007 Fixed 09 Jul 2007 Fixed Description Upgrading dataserver using sqlupgrade generates a new RUN_server file with the wrong pagesize. Workaround Description  Manually create a new RUN_server for the new 15.0 release dir.

CR:407235

CR Number:   407235 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Fixed 21 Dec 2005 One-off Provided Description Sub-optimal performance for a query with a WHERE clause contianing col1 IS NULL AND col2 = <value>, with an index in col1, col2 and a high number of rows with col1 is NULL. Workaround Description  force other index: SELECT COUNT(*) FROM BPMLHPoint MLHP, BPMLH1 MLH (index sg_special) WHERE MLHP.rfBPBillingPoint = 3714 AND MLHP.rfBPCustomerBillingPeriod is null AND MLH.target_rfFMBusinessUnit = MLHP.rfFMBusinessUnit AND MLH.target_inMLHRank = 1 AND MLH.rfBPCustomerBillingPeriod is null

CR:407262

CR Number:   407262 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2005 Fixed Description User datatype information is not correctly send in the TDS packet for cross database queries on tables with columns based on user defined datatypes. Workaround Description  None known.

CR:407265

CR Number:   407265 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2005 Fixed 06 Feb 2006 One-off Provided Description Under circumstances, when ASE is running multiple engines and more than 50 connections, doing java functionality, the JVM use to throw various stacktraces when it calls GarbageCollector for recollecting memory. Workaround Description  *** Wednesday, October 19, 2005 7:54:20 AM *** cooperg *** None.

CR:407266

CR Number:   407266 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2007 One-off Provided 20 Sep 2007 Fixed Description In rare circumstances a 712 error, "There is insufficient heap memory to allocate <count> bytes..." may be reported during an insert into a DOL table with a clustered index after several 1105 or 1204 errors. Workaround Description  - increase locks in case the exception is coming from the lock manager when running out of locks - increase log space if we are running into 1105 errors.

CR:407318

CR Number:   407318 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3.a ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2006 Fixed 27 Feb 2006 Fixed Description "auditinit" returns error 17285 (Procedure 'sp_addsegment' Message String: There is already a segment named 'aud_seg_01') when adding a device for the audit tables. Workaround Description  The workaround is to specify one device/segment in auditinit, then manually add other device/segment later.

CR:407327

CR Number:   407327 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) 21 Oct 2005 Fixed 21 Oct 2005 Fixed 21 Oct 2005 Fixed 24 Oct 2005 Fixed Description TSQL statements that return rows wider than a database's page and contain distinct clauses, unions, or group by clauses may generate a 702 error if a hash operator is used.

CR:407345

CR Number:   407345 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) 20 Oct 2005 Fixed 20 Oct 2005 Fixed 20 Oct 2005 Fixed Description Dissociate index intersection and index union: don't try index intersection anymore together with an OR clause index union when SET INDEX_INTERSCET is OFF. Also, when index intersection properties (as partitioning) don't match, abandon gracefully instead of continuing up to a failure.

CR:407385

CR Number:   407385 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2005 Duplicate Description Sybase Central generates incorrect database DDL for database spanning devices Workaround Description  Manually remove references to master or sysprocsdev from the create database statement.

CR:407400

CR Number:   407400 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to provide an option to DBCC LOG to limit output to a particular range of datetime values.

CR:407404

CR Number:   407404 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) 20 Oct 2005 Fixed Description When converting from univarchar type to unichar in assignments, blanks are not padded at the end.

CR:407419

CR Number:   407419 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) 11 Jan 2006 Fixed Description Configurable Shared Memory DUmp (CSMD) may report that a shared memory dump was not performed because a configured dump condition has reached the maxdumps value even though no shared memory dumps have been performed for that dump condition. Workaround Description  The workaround is to set the 'maxdumps' value for the severity dump condition to a high number (e.g., 10 or 100). This will allow the severity condition to take effect.

CR:407433

CR Number:   407433 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2005 Fixed 05 Jan 2006 Fixed Description Rep Agent returns error 9254 and 9204 after cross-platform database load. Workaround Description  ensure that table does not have a schema change pending from the RA point of view, then set the versionts to NULL.

CR:407435

CR Number:   407435 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) 16 Nov 2005 Fixed Description Replication Agent stored procedures have been modified to format the output to the client based on the length of the data being displayed.

CR:407460

CR Number:   407460 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 04 Dec 2005 Fixed 14 Mar 2006 Fixed Description SSL5 feature is supported on hpia64 platform for ASE 12.5.4

CR:407522

CR Number:   407522 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 Nov 2005 Fixed Description A writetext command run on a replicate table could lead to 692 errors if the text/image column was marked for replication using sp_setrepcol. Workaround Description  use sp_setreptable instead