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

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

CR:648593

CR Number:   648593 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed 27 Mar 2011 Fixed Description Repeated invocation of space related built-in functions like data_pages() used in sp_spaceused reads the missing (not found the in ASE cache) pages from the disk and will never keep them in the ASE cache. This incurs lot of i/o on large databases (database having lot of tables) and may degrade the response time.

CR:648623

CR Number:   648623 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request: Provide an ASE option for use with MQSeries to use the IBM standard channel table to look up the channel to use based on the queue manager name.

CR:648663

CR Number:   648663 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2010 Fixed 18 Nov 2010 Fixed Description When downgrade 1503 esd#3 or esd#4 server back to 1502 server or older, 515 error was raised for null insert into non-nullable columns. Workaround Description  [szhuang 2010-Nov-19:] In the installmaster file, find the definition of sp_downgrade, change following: ---- insert #actions values(9, @sybsecuritydb, 15010, @downgrade_sysauditoptions_sql, 'Downgrade : Downgrading global auditing options.') ---- To: ---- if (@sybsecuritydb is not null) begin insert #actions values(9, @sybsecuritydb, 15010, @downgrade_sysauditoptions_sql, 'Downgrade : Downgrading global auditing options.') end ----

CR:648664

CR Number:   648664 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2010 Fixed 16 Nov 2010 Reservation Made 18 Jan 2013 One-off Provided 18 Sep 2012 Fixed Description Under some rare conditions, the statement cache entry could have ssql_keep > 0 and this entry could not be removed by the DBCC PURGESQLCACHE command and this could cause problem for the statement cache.

CR:648688

CR Number:   648688 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The new feature request requires the sp_audit "alter" working for all the databases in the server.

CR:648791

CR Number:   648791 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2011 Consult Complete Description Optimiser still picking group_hashing after it was specifically turned off

CR:648848

CR Number:   648848 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2011 Fixed 22 Jul 2011 Fixed Description An OpenSSL error, "SSL or Crypto Error Info: psn -1, vsn -1, sockp (nil) error id 96, severity -2, provider id 2. SSL or Crypto Error Message: 'An unexpected failure occurred while performing an OpenSSL cryptography operation. Root error: error:0606506D:digital envelope routines:EVP_DecryptFinal_ex:wrong final block length'", may be reported while dumping the transaction log. Workaround Description  There is a workaround for SYBASE backupserver sp_serveroption SYB_BACKUP, "net password encryption", "true" or done manually via update sysservers set srvstatus=srvstatus+2 where srvname="SYB_BACKUP"

CR:648863

CR Number:   648863 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2010 Duplicate Description Dynamically prepared SQL is not executable after HAFailover in the Cluster Edition. This data is currently lost and the application program must re-prepare the data before execution on the HAFailover's connection.

CR:648948

CR Number:   648948 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2010 Fixed Description Executing a procedure with derived table containing UNION queries could lead to permission errors. Workaround Description  use tracelfag 10303, which gives old style (pre-12.0) security features.

CR:648998

CR Number:   648998 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description monProcessObject reports table/partition statistics aggregated to the table level and associates the aggregated statistics with the base table and first partition (if any) instead of providing the detailed statistics for each index/partition involved in the query

CR:649000

CR Number:   649000 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2010 Fixed 22 Nov 2010 Fixed Description In rare circumstances, loading a compressed database dump into an archive database can fail with an error 692, 'Uninitialized logical page '0'..' when Adaptive Server incorrectly loads page 0 from an invalid offset. Workaround Description  n/a

CR:649006

CR Number:   649006 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2010 Fixed 19 Nov 2010 Reservation Made 19 Nov 2010 Fixed Description Table scans were avoided since the CPU cost for table scans did not take into account reduced row counts due to partition elimination Workaround Description  force table scan

CR:649030

CR Number:   649030 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide a configuration option for MQ Series, similar to "xp_cmdshell context", that would would cause ASE to attempt to open the queue as the "sybase" user process by default, with altusr/setid used only when needed for special cases.

CR:649038

CR Number:   649038 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2011 Fixed 05 May 2011 Presently Not Targeted For Any Future Release Of This Product Description Under some rare circumstance, parallel queries using expression involving LIKE and variables or parameters could cause stacktrace and the stack will show modules copy__eval() and copy__eoplike().

CR:649039

CR Number:   649039 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2010 Not a Bug Description Need to have SSL capability in the Agent to ASE links so that SSL can be used on all ASE CE ports.

CR:649087

CR Number:   649087 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If a table is altered by adding a column with a user datatype which has a default value bound to it, the user datatype default is missed - a new default is generated. This leads to error 2513 when dbcc checkcatalog being run.

CR:649145

CR Number:   649145 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2010 Fixed Description In rare circumstances, the message "Sybmon encountered signal 11" in the module 'pci_configured' together with a stack trace which includes the modules 'sm__exec_memload' and 'shm_memload' may be reported in the error log when a memory dump is loaded with Sybmon while attached to ASE server.

CR:649171

CR Number:   649171 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2010 Fixed 23 Nov 2010 Fixed Description Under some circumstances, when a UNITEXT value is passed to a stored procedure or dynamic SQL statement as a parameter where a TEXT value is expected, implicit conversion will take place within ASE. If the UNITEXT value is larger than 450 bytes and the converted TEXT value is smaller than 450 bytes, a stack trace including the functions, memtextlen()and LeLOBCache::_copyConstantToCache() will be generated.

CR:649226

CR Number:   649226 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Alter table add column hits error 2705 when "auto identity" is enabled from a Jconnect client as DBisql. Workaround Description  USE isql instead of dbisql

CR:649307

CR Number:   649307 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A new feature request for enhanced timezone support.

CR:649428

CR Number:   649428 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Dec 2010 One-off Provided 11 Jan 2011 Fixed 26 Jan 2011 Fixed 24 Sep 2012 Fixed Description Adaptive Server may encounter a storage access violation error when query execution is interrupted.

CR:649470

CR Number:   649470 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) 29 Nov 2010 Fixed 24 Nov 2010 Reservation Made 24 Nov 2010 Fixed Description When conserve_tempdb_space optcriteria is used, then tempdb space estimates inside subqueries are not recognized when query plans using large amounts of tempdb space are to be avoided

CR:649590

CR Number:   649590 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2011 Fixed 10 Dec 2010 Reservation Made 12 Jan 2011 One-off Provided 31 Jan 2011 Fixed Description Inherently zero row queries, ie with an always false constant conjunct (ie where 1=0), can take a long time to find a query plan. Workaround Description  Use compatibility_mode. Use a "top 0" in the query.

CR:649701

CR Number:   649701 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2012 Fixed Description Previously diagnostic information was available for error 290024 - invalid column. Due to possible performance issues, we now print it only if traceflag 2779 is set.

CR:649710

CR Number:   649710 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2011 Fixed Description You may retrieve a strange row which has ErrorNumber=110081 and Time='Jan 1 1900 12:00AM' from monErrorLog just after the ASE is restarted if the ASE is configured with multiple engines.

CR:649754

CR Number:   649754 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2013 Not reproducible with latest version of the product available as of Resolution Date Description Request for a new feature to check any identity columns following a server upgrade to ensure that the upgrade does not result in 2601 errors. Workaround Description  The only workaround was to restore the database from an older backup. Loading a dump from the original 15.0.3 server to the latest 15.5 ESD #2 server resolved the issue.

CR:649793

CR Number:   649793 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Under certain circumstances when running queries that use MIN/MAX, the ASE optimiser chooses a query plan that is estimated to have a low cost based on the available statistics. When executed the actual cost is much larger than the estimate and the performance may be impacted. Workaround Description  An abstract plan can be used to force the required query plan.

CR:649932

CR Number:   649932 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2010 Fixed 01 Dec 2010 Fixed Description Sessions which execute dynamic sql query may fail with error 2901 and the exception stack limit is exceeded.

CR:649938

CR Number:   649938 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2011 Added to user documentation Description Linux Hughpages the documention is not correct.

CR:649987

CR Number:   649987 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2011 Fixed 13 Jan 2011 Fixed Description When running certain stored procedures that use mixtures of local, temporary and tempdb tables, ASE may incorrectly throw error 208: <table_name> not found. Workaround Description  set compatibility_mode on or fully qualify table using current database name. or dbcc traceon (7730) to disable deferred compilation or:- sp_configure 'procedure deferred compilation', 0

CR:650044

CR Number:   650044 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to allow downgrading of a single database.

CR:650076

CR Number:   650076 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed Description Cluster lock space rebuild takes time and as CLM rebuild is a blocking operation, cluster is hung for the duration.

CR:650103

CR Number:   650103 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2010 Fixed 20 Jun 2011 Fixed Description DDLGEN cannot generate range partition clause when there is a local index

CR:650163

CR Number:   650163 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2010 Fixed 02 Dec 2010 Fixed 06 Mar 2012 EOL'd version. Not to be Fixed. Description Executing dynamic sql query may hit error 8203 in des__markdrop() together with stack trace involving module ssql__rmplans(), ssql_save_SQL() and sqt_put_in_stmtcache().

CR:650188

CR Number:   650188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: have 100039 errors resolved within the upgrade process.

CR:650206

CR Number:   650206 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2013 Presently Not Targeted For Any Future Release Of This Product Description Queries optimized with fastfirstrow optgoal may underestimate sort operator costs. This problem is exasperated in parallel query optimization.

CR:650207

CR Number:   650207 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2011 Fixed 17 Feb 2011 Reservation Made Description Inline default objects created for the default clauses are not shared among different columns even with the same default value, leading to unnecessary large number of default objects in ASE.

CR:650268

CR Number:   650268 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2010 Fixed Description For options, for example 'cpas per ccb', defined as CFG_MEMORY_USED but do not consume any memory at run time, sp_helpconfig will raise error when estimate the memory usage on them.

CR:650297

CR Number:   650297 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2011 Fixed 10 Mar 2011 Reservation Made 09 Mar 2011 Fixed Description In rare circumstances, Adaptive Server may hang as a result of being unable to reuse object descriptors whose statistics metadata are not yet flushed on disk. The configuration parameter 'number of open objects' would need to be increased accordingly.

CR:650302

CR Number:   650302 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer requests that we certify the latest 15.x with the latest versions of NetApp ontap on AIX.

CR:650313

CR Number:   650313 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Repeated "Timestamp for database" messages in the errorlog. Workaround Description  Increase the "number of open databases" parameter to be high enough to handle the number of actual databases in the server.

CR:650316

CR Number:   650316 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2010 Fixed 30 Jun 2011 Fixed Description When replicating data from a low durability database, RepAgent may sleep on the end of the log and fail to detect that the log has been extended. The problem is more likely to be seen when there is little activity and the transactions are short. RepAgent wakes up and resumes replication once the log grows past the current last log page where it stalled.

CR:650660

CR Number:   650660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2011 Fixed 21 Jul 2011 Bundled Request 22 Jun 2012 One-off Provided 25 Jun 2012 Fixed Description Queries with outer joins on encrypted columns may not return all the rows from the outer table if the encrypted column uses the decrypt_default modifier. Workaround Description  Possibly force 'outer join' by OR-ing columns that are NULL.

CR:650670

CR Number:   650670 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE needs feature support to assure that some ASE users are logging in and using encrypted traffic on their session connections to ASE. SSL clients and Kerberos clients with encryption properties set would qualify as "encrypted session users". Workaround Description  login trigger to validate is @@ssl_ciphersuite is non-null covers SSL connections. But the trigger neededs to be written and managed.

CR:650686

CR Number:   650686 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Configuration Guide for UNIX Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2011 Added to user documentation Description Linux 32bit setup aio formula is ((max async ios per engine + 1) * # of engines Linux 64bit(both IBM P-series, x86_64 versions) is ((disk i/o structures + max async ios per engine+1) * number of engines)

CR:650839

CR Number:   650839 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2011 Fixed 02 Jun 2011 Fixed Description sp_plan_dbccdb may raise a 3606 error, "Arithmetic overflow occurred", if the server contains very large databases or very large devices. The device size values displayed for recommended devices is also not properly adjusted for server page size.

CR:650889

CR Number:   650889 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2011 Fixed Description On WinX64 platform configured to use SSL client connections, a segmentation violation may occasionally occur during server start-up due to pending read and cancel on the socket for a site handler RPC connection.

CR:650977

CR Number:   650977 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed 19 Jan 2011 Presently Not Targeted For Any Future Release Of This Product 18 Mar 2011 Reservation Made Description Unnecessary procedure renormalization involving INSERT/UPDATE into temporary table may happen after temporary table re-creation and recompilation. This can cause sysdepends or sysprocedures contention. Workaround Description  TF 299 will avoid the initial TEMPMISSING in-memory renormalization and recompile and therefore the subsequent recompile will not rewrite to sysprocedures.

CR:651021

CR Number:   651021 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2011 Fixed Description Error msg 7105 was changed from "TEXT/IMAGE/UNITEXT page <page id> does not have a next page, although it should." to "TEXT/IMAGE/UNITEXT page <page id> does not have a next page. Either there is a suspect text page chain, or transaction isolation level 'read uncommitted' has been set. Database <db name>, table <table name>, first text page <page id>."

CR:651085

CR Number:   651085 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2011 Fixed Description If the stack size is under-configured, showplan may sometimes cause stack corruption for a very complicated plan. Workaround Description  increase stack size

CR:651152

CR Number:   651152 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description optdiag incorrectly raises error: Data type/length of column X mismatch with the stored values in syscolumns.

CR:651190

CR Number:   651190 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Windows XP Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The reported message of "memory ASE used" looks incorrect on winx64 and nt386 platform if user want to change stack size through sp_helpconfig

CR:651228

CR Number:   651228 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2011 Fixed Description Running Job Scheduler installTemplateXMl.csh script results in a "ASE150.csh: No such file or directory" error. Workaround Description  Modify GenericTempUtil.csh to something like: ... if ($?SYBASE_JRE != 1) then setenv SYBASE_JRE $SYBASE/shared/JRE-6_0_6 # commented out source $SYBASE/ASE150.csh endif if ($?SYBASE_ASE != 1) then setenv SYBASE_ASE ASE-15_0 # comment out source $SYBASE/ASE150.csh endif ... and GenericTempUtil.sh to something like: ... if [ -z "$SYBASE_JRE" ] then SYBASE_JRE = $SYBASE/shared/JRE-6_0_6 # commented out . $SYBASE/ASE150.sh fi if [ -z "$SYBASE_ASE" ] then SYBASE_ASE = ASE-15_0 #commented out . $SYBASE/ASE150.sh #echo setting SYBASE_ASE variable #echo SYBASE_ASE is $SYBASE_ASE fi ...

CR:651352

CR Number:   651352 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2011 Presently Not Targeted For Any Future Release Of This Product Description In certain circumstances it is possible that an inner class, that has been installed into an ASE server is not found when required by executed java code. Workaround Description  There is no work around

CR:651394

CR Number:   651394 Product Name:   Adaptive Server Generic Docs Product Component:   Java in Adaptive Server Enterprise Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2010 Added to user documentation Description doc bug: add -XX:MaxPermSize to the java_options tunable by sp_jreconfig

CR:651654

CR Number:   651654 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description There is a Typo in the Job Scheduler documentation Chapter 3: Using Templates to Create Jobs -------------------------------------------------------------------------------- Installing the templates into Job Scheduler On UNIX: installTemplateXML servername machinename serverport username password language On Windows: installTemplateXML.bat servername machinename serverport username password language where: In fact, the name of the template xml script is installTemplateXml (not installTemplateXML) in the Sybase file directory. Workaround Description  Use this name: installTemplateXml

CR:651657

CR Number:   651657 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2011 Presently Not Targeted For Any Future Release Of This Product Description Error 7738 needs meaningfull text adding

CR:651722

CR Number:   651722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description "insert partition" for range partitions on the fly to avoid the downtime involved in redistributing the data with unpartition/partition.

CR:651726

CR Number:   651726 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2013 Duplicate 19 Dec 2014 Consult Complete Description Feature Request to eliminate the requirements for kernel.exec-shield=0 and randomize_va_space=0

CR:651853

CR Number:   651853 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2011 Added to user documentation Description Doc Bug: typo ">=", should be "<=" ">" cannot be used in the MAX partition

CR:651865

CR Number:   651865 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2011 Fixed Description UPDATE on a nested VIEW may cause a stack trace involving the modules 'vu_mergetress', 'vu_analyze_view' and 'vu_call_analyze_view'.

CR:651914

CR Number:   651914 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2011 Fixed Description The 0x08 bit for sysindexes.status2 field does not get correctly cleared when running sp_rename or dropping a constraint.

CR:651924

CR Number:   651924 Product Name:   Adaptive Server Enterprise Product Component:   SDK Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2011 Consult Complete Description need examples how to configure RPC for CS_LONGCHAR_TYPE Workaround Description  The recommended workaround was to write the text/image contents to a file then tell the external scanner to scan the file. Security restricts us from writing to a file.

CR:652094

CR Number:   652094 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2013 Insufficient info provided Description 3607 divide by 0 error (return status = -6) with traceflag 3610 on

CR:652103

CR Number:   652103 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2011 Fixed 05 Mar 2012 One-off Provided Description The message "current process infected with 11" in the module 'des_unkeep_or_drop' or s_free() with a stack trace that includes the modules 'apm__metrics_insert', 'kill_proc' and 'proc__dealocmem' may be reported in the error log after a session that was hanging because of the transaction log being full was killed and the configuration option "enable metrics capture" was active. This error resulted in ASE shutting down itself.

CR:652106

CR Number:   652106 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2012 EOL'd version. Not to be Fixed. 16 Mar 2012 Fixed 14 Mar 2012 Reservation Made 26 Apr 2012 Fixed Description Spinlock contention for Resource->rproccache_spin is huge due to large memory allocation tuning. ------ TF 758 enables this fix. It needs to be used at startup. Start the server with -T758 and this will enable large scale allocations to use the ELC directly, i.e. 2 page\4 page\8 page.

CR:652110

CR Number:   652110 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) 04 Jan 2011 Fixed 22 Dec 2010 Reservation Made Description If a constant expr is in the select list of a VIEW or derived table, and the VIEW is the inner of an OUTER JOIN, and the constant attribute is correlated into a subquery outside of the ON clause of the OUTER JOIN, then a stack trace could occur if a subquery reformatting strategy is chosen, such as in the following query: select Panel = (select PN.c1 from tb1 PN where A.r2=PN.c2) from T3xxx RE left join (select 1 from T1xxx r) A(r2) ON RE.c3=A.r2

CR:652160

CR Number:   652160 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2011 Fixed Description DBCC CHECKTABLE may result in 12905 errors when executed on DOL table with indexes.

CR:652269

CR Number:   652269 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description stored procedure to enable and disable optcriterias server wide

CR:652275

CR Number:   652275 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2011 Fixed 24 Feb 2011 Reservation Made Description When ASE is waiting for tasks to exit, print additional information to understand why shutdown is not proceeding.

CR:652328

CR Number:   652328 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Dec 2013 Fixed 25 Feb 2013 Fixed Description TEXT/IMAGE page chains are not deleted properly from sysattributes when REORG REBUILD is called on a table with TEXT and IMAGE data. This can result in reduction of unreserved/available space in the database.

CR:652364

CR Number:   652364 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2012 Insufficient priority to fix Description When naming the configuration file, avoid using a dot in the name of the file, with the expection of the extension .cfg. The use of the dot character before the extension cfg is required to maintain the history of configuration changes correctly. Workaround Description  Avoid using a dot in the name of the configuration file other than as the character that seperates the name from the three character extension cfg

CR:652387

CR Number:   652387 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2010 Not a Bug Description Query on an audit table will hang when the audit table is full. port CR# 493608 to the 15.5 ASE codeline, which is currently fixed only in cluster edition. Workaround Description  make sure there is space for syslogs and sysaudits table

CR:652396

CR Number:   652396 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2011 Fixed Description In rare circumstances, the message "current process infected with 11" in the module astc_xid_gen along with a stack trace which includes module sysxacts_materialize may be reported the error log while using systransactions system catalog or stored procedure sp_transactions. Workaround Description  n/a

CR:652535

CR Number:   652535 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2011 Fixed 26 Jul 2011 Fixed Description Under some circumstances, when STATISTICS IO is enabled and BCP encounters an error, a signal 11 may result followed by a stacktrace with the module 'LeOperator::LeOpProcessIOStats'. Workaround Description  Not use set statistics io on with bulk insert.

CR:652562

CR Number:   652562 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2011 Fixed 08 Feb 2011 One-off Provided Description A Cluster Edition instance cannot be "onlined" after it was previously killed by VCS during an attempt to join an existing cluster. Workaround Description  Possibly increase OnlineTimeOut value to include total cost of failover recovery from the default of 5 minutes to something much longer. i.e. hatype -modify Sybase OnlineTimeout 1500

CR:652634

CR Number:   652634 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2011 Fixed 08 Mar 2011 One-off Provided 11 Oct 2011 One-off Provided 26 Jun 2012 Fixed Description When selecting from a VIEW that selects DISTINCT rows from a base table with at least one encrypted column that specifies a decrypt default value, Adaptive Server gets a SEGV violation and aborts the user session.

CR:652640

CR Number:   652640 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2014 Duplicate 02 Aug 2012 EOL'd version. Not to be Fixed. Description When a user with sso_role runs a query accessing a table on current or another database, a 2736 error may occur during recompiling a light-weight procedure if statement cache is enabled and the user is not added to the current database. Workaround Description  Add the user to the current database.

CR:652646

CR Number:   652646 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2011 Fixed 08 Mar 2011 One-off Provided 10 Mar 2011 Fixed 29 Jul 2011 Bundled Request 21 Jul 2011 Bundled Request 25 Jun 2012 Fixed Description A SELECT statement with a qualification that searches an encrypted column that has a decrypt_default modifier and another column using the LIKE operator may ignore the LIKE filter and produce wrong results.

CR:652738

CR Number:   652738 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2011 Fixed Description When inserting audit records into audit table fails and node shutdown is issued, the node shutdown may encounter a signal 11 followed by a stacktrace involving the modules 'insert' and 'audproc'.

CR:652746

CR Number:   652746 Product Name:   Adaptive Server Generic Docs Product Component:   Migration Guide Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Correct the documentation for limits on user table. "For a select query, the allowable limit is still 50 tables. The total number of user tables allowed in a query is 512, you can only achieve that by using UNION, with 50 as the limit at single side of UNION."

CR:652772

CR Number:   652772 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2011 Fixed Description Alter table drop column operation may result in a 804 error while dropping a TEXT column from a Datarow Locked table with forwarded rows. Workaround Description  - Use select into, eliminating the columns to be dropped from the column list - Run reorg rebuild or reorg forwarded_rows prior to the alter table command

CR:652783

CR Number:   652783 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2013 Insufficient info provided Description

CR:652802

CR Number:   652802 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2013 Insufficient info provided Description In rare circumstances, executing a stored procedure may cause the signal 11 in 0x090000000000d6c8 (pci_cfgmgr_default_config+0x7b0).

CR:652932

CR Number:   652932 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Have showplan output the stored proc name when it has an EXECUTE step.

CR:653053

CR Number:   653053 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2011 Fixed 11 Oct 2011 One-off Provided 21 Jul 2011 Fixed Description In a user-defined transaction, an UPDATE to a VIEW which triggers an insertion to a remote TEXT column may hang indefinitely. Workaround Description  Define proxy without the text column using create existing table

CR:653067

CR Number:   653067 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed Description sp_helpcache does not display the correct cache binding.

CR:653075

CR Number:   653075 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2010 Fixed 23 Dec 2010 Reservation Made Description JConnect may report incorrect row counts when config option 'enable functionality group' is configured.

CR:653101

CR Number:   653101 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2011 Fixed 07 Mar 2011 Reservation Made 10 Mar 2011 Fixed 22 Mar 2011 One-off Provided 10 Jun 2011 One-off Provided 27 Jun 2011 Fixed Description In very rare circumstances in a multi-engine environment with a high degree of DML concurrency, index corruptions evidenced by errors like 12301, 12314, 632, 692 and others, can occur following the roll back of a transaction in which index splits or shrinks occurred on data-only locked tables.

CR:653157

CR Number:   653157 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2011 Fixed 28 Jul 2011 Reservation Made 11 May 2011 Fixed 12 May 2011 Fixed 27 Jul 2011 Fixed 28 Jul 2011 Fixed 02 Aug 2011 Fixed Description In Adaptive Server/Cluster Edition, the opening of databases when booting a non-coordinator instance, is performed serially so that making all databases available takes an unnecessarily long period of time. The opening of databases is now done in parallel. The previous behavior has been retained under the 2796 trace flag.

CR:653210

CR Number:   653210 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2011 Fixed Description Queries involving SELECT FOR UPDATE may hit signal 10 on Solaris/HP platforms.

CR:653212

CR Number:   653212 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2011 One-off Provided 22 Mar 2011 Consult Complete 25 Mar 2011 Fixed 26 Apr 2011 Fixed 10 Apr 2011 One-off Provided 04 Apr 2011 Fixed 14 Sep 2012 Fixed 14 Sep 2012 Fixed Description The message "Error: 820, Severity: 21, State: 6" may be reported in the error log together with a stack trace including the modules 'bufpindirty' and 'pg_allocate'. Alternatively, the "infected with 11" message may be seen in the error log together with a stack trace showing the modules 'xls_bufunpin' and 'buf_get_latch'.

CR:653246

CR Number:   653246 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Dec 2010 Fixed Description In 'Advanced Options' page of 'Add Database Device' Wizard, the 'skip allocation' is enabled by default (the box is checked).

CR:653277

CR Number:   653277 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Control GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 11 Sep 2013 Fixed 12 Sep 2013 Reservation Made 15.7 SP121 12 Sep 2013 Fixed 15.7 SP110 13 Sep 2013 Fixed 15.7 SP60 07 Oct 2013 Fixed Description An UPDATE query running in a batch that includes a CREATE INDEX or UPDATE/DELETE STATISTICS or an UPDATE query running simultaneously with a workload that involves CREATE INDEX or UPDATE/DELETE STATISTICS may lead to data inconsistency.

CR:653385

CR Number:   653385 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) 04 Jan 2011 Fixed 05 Jan 2011 Fixed Description In Adaptive Server Cluster Edition version 15.0.1 ESD#4 or later, the message "current process infected with 11" in the module cm_bind_cache() may be reported in the error log when a cache binding or unbinding operation fails due to any error.

CR:653458

CR Number:   653458 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Dec 2010 Fixed 05 Jan 2011 Fixed Description Sybase utilities that connect to the ASE server on Windows 64bit platforms may fail to connect when being run in a remote desktop connection and ASE is running as a service or in another (different) remote desktop session. Workaround Description  Run the utility in the same session as ASE (for ASE running as a service, run the utility from the machine console session).

CR:653511

CR Number:   653511 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2011 Fixed 31 Mar 2011 Reservation Made 26 Apr 2011 Fixed Description If a stored procedure undergoes recompilation, and the procedure makes assumptions regarding session's state (ie session environment settings), the resulting recompiled plan can be significantly different to the original. This fix is only active when traceflag 7773 is active.

CR:653512

CR Number:   653512 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2011 Not a Bug Description login with 100 roles assigned directly takes 6 times longer to login than 1 role Workaround Description  Do not assign roles directly to the login, use child role.

CR:653575

CR Number:   653575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2012 Presently Not Targeted For Any Future Release Of This Product Description ASE 15 change the data type we return for the avg function from Numeric to Big integer request to have a trace flag to revert the behavior. Workaround Description  use the convert function. As sample for the select in the reproduce section. select convert(numeric (38,17), avg(case when a1.a < 7 then (2147483648 - b) else b end)) from a1 go

CR:653621

CR Number:   653621 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2013 Insufficient priority to fix Description showplan shows 2k pool sysmons shows 16K i/o while creating an index