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

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

CR:534293

CR Number:   534293 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2008 Fixed Description When there is an entry name "<hostname>" exist in interfaces file, custom configure js cannot proceed.

CR:534338

CR Number:   534338 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2008 Added to user documentation Description Request to provide Details on Advanced tab when connecting to ASE.

CR:534417

CR Number:   534417 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2008 Insufficient priority to fix 20 Sep 2012 Insufficient priority to fix Description Proxy image or text column may not be updated correctly when the proxy column is used in a trigger. Workaround Description  declare @tp binary(16) select @tp = textptr(c2) from proxy_tt writetext proxy_tt.c2 @tp with log 0x33 update proxy_tt set c2=0x33

CR:534553

CR Number:   534553 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2008 Fixed 15 Aug 2008 Fixed 02 Sep 2008 Fixed Description DBCC TABLEALLOC/TEXTALLOC/INDEXALLOC when run in 'OPTIMIZED' mode and with the 'FIX' option supports the correction of '100039' faults reported by DBCC CHECKSTORAGE for user tables; this fault describes an incorrect extent OAM page hint. Workaround Description  reorg rebuild or Bulk copy the data out and back in

CR:534554

CR Number:   534554 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) 02 Jul 2008 Fixed 02 Jul 2008 Reservation Made Description Dynamic Buffer Allocation for group_hashing and distinct_hashing strategies is limited to sessions where the tempdb is bound to a named cache.

CR:534564

CR Number:   534564 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2008 Fixed 03 Jul 2008 Fixed Description In Cluster Edition of Adaptive Server, an error 913 "Could not find row in sysdatabases with database id <dbid> ..." could be reported in the server error log during a cluster failover if system databases sybsecurity or sybsystemprocs were dropped since the last cluster reboot.

CR:534605

CR Number:   534605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2008 Fixed 14 Aug 2008 Fixed Description A stored procedure, which creates a table and reads or writes that table, may incorrectly access a table by the same name created outside of the procedure. This happens in the following circumstances: (1) Database owner creates procedure.(2)Database owner creates a table with same name as table created in procedure. (3) Procedure is executed by a non-database owner. (4) Procedure's access to the table is specified without qualifying the table name with an owner name. Workaround Description  - Create the stored procedure to be executed by non-dbo users by a non-dbo user (so there is no conflict between dbo's table and regular user's table) OR - Fully specify the owner for the table used inside the stored procedure.

CR:534685

CR Number:   534685 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2008 Fixed Description In rare circumstances error " Unconditional lock request for table or page was made while holding a latch" may be reported in the error log.

CR:534688

CR Number:   534688 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2008 Fixed 11 Aug 2008 Fixed Description On IPv6 enabled machines, the sp_listener stop/suspend command fails to stop/suspend a listener after starting the listener successfully by the command "sp_listerner start".

CR:534709

CR Number:   534709 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2008 Bundled Request Description Previously a create database statement with "on default=" (e.g. "create database t1 on default=4") would result a syntax error in DBISQL. This has been fixed.

CR:534710

CR Number:   534710 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2008 Fixed Description In a multi-node cluster, in rare circumstances, error 8211 can be encountered if the same object is created and dropped from different instances in the cluster.

CR:534827

CR Number:   534827 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   tyresias Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2008 Fixed 14 Jul 2008 Fixed Description Query with AND/OR clauses may stacktrace for certain order of OR clauses in the query. Workaround Description  Re-arrange the OR clauses may resolve the problem.

CR:534890

CR Number:   534890 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2008 Fixed 14 Jul 2008 Fixed Description Arithmetic overflow for numeric +/- expression involving more than 2 operands could happen during execution.

CR:534946

CR Number:   534946 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2009 Fixed 10 Apr 2009 Fixed Description Ignore partition id checking for sampling sort merge page. Workaround Description  Either remove the 16K pool from the cache being used by the table in question or increase the 'number of sort buffers'. For the test case it was found that increasing sort buffers from the default(500) to 2000 allowed the create index to succeed.

CR:534965

CR Number:   534965 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Open OS:   all Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Under certain circumstances, errors received during the execution of an ETL Project on a remote GridNode can hang the Windows ETL session. The Windows session must be killed using the Task Manager and restarted in order to proceed.

CR:535021

CR Number:   535021 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2008 Fixed 08 Jul 2008 Fixed Description Failover recovery may sometimes run into a deadlock situation if it involves a redo of a transaction index inserts or deletes to a data-only locked table.

CR:535038

CR Number:   535038 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2008 Fixed Description In some cases, if a "MERGE UNION ALL" operator is in the inner stream of a "MERGE JOIN" operator, then a SEGV may be generated while copying data to the output tuple. The stack will have the following calls on it: LeMJOp::getNextInner()->LeMrgUnionOp::_LeOpNext()->LeMrgUniContext::getNextTup() LeUnionContext::copyRsVal()->LeVtuple::copyCols()->LeColumn::LeColCopy()->memmove() The stack may appear different with different FBO compilers.

CR:535096

CR Number:   535096 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2008 Added to user documentation Description There is an inconsistency in System Administration Guide about an example of setting "number of open partitions".

CR:535194

CR Number:   535194 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2008 Fixed 12 Aug 2008 Presently Not Targeted For Any Future Release Of This Product Description DDLGen generates 'NULL' SQL statement for granting the permission of the DELETE STATISTICS command. Workaround Description  N/A

CR:535248

CR Number:   535248 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2009 Fixed 05 Feb 2009 Presently Not Targeted For Any Future Release Of This Product Description In shared disk cluster, a 3484 error: "Recovery encountered error <errno> while acquiring lock type <locktype>, value (<value>) for transaction (<xactid>) in dbid <dbid> ...", may sometimes be raised at failover recovery time while redoing deferred updates on data only locked tables.

CR:535279

CR Number:   535279 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2008 Fixed 08 Jul 2008 Fixed Description After ldap authentication is enabled in Shared Disk Cluster environment, user connections to joining nodes can not authenticate through ldap server.

CR:535294

CR Number:   535294 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2008 Fixed Description In a cluster instance, checkverify command could sometimes report error 12921.

CR:535389

CR Number:   535389 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2008 Presently Not Targeted For Any Future Release Of This Product Description The restart option for sp_audit is not fully documented in 12.5.x Workaround Description  N/A

CR:535392

CR Number:   535392 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2008 Fixed 31 Jul 2008 Fixed Description Procedural query compiled in the deferred compilation mode may fail producing stack traces if during the compilation the server has to perform the internal upgrade of the DEFAULT clause. Errorlog indicates modules 'add_default', 's_getTreeOrPlan', 's_reinstallProcTree' and 's_normalize'.

CR:535462

CR Number:   535462 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2010 Bundled Request Description The kerberos principal name in the audit table is not being displayed for login auditing entries.

CR:535544

CR Number:   535544 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2008 Fixed 14 Jul 2008 Fixed Description Following an instance failure, a 6908 error "During redo the page timestamp value is less than old timestamp from log" may be reported during the recovery of a database that has mixed log and data.

CR:535546

CR Number:   535546 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2008 Fixed 30 Sep 2008 Fixed 12 Sep 2008 Fixed 15 Sep 2008 Fixed 15 Oct 2008 Fixed 08 Aug 2011 Presently Not Targeted For Any Future Release Of This Product Description Parallel tasks asking for the same resource on blockage can report pseudo deadlocks. The following change will allow time for the tasks to wait on the blockage and report deadlock only after waiting for appropriate time.

CR:535559

CR Number:   535559 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2008 Fixed Description Repeat to issue the message reporting that there are insufficient spinlock monitors to monitor all allocated spinlocks. Workaround Description  None known.

CR:535570

CR Number:   535570 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2009 Fixed 22 Apr 2009 Fixed Description New integer datatypes are not recognized as valid identity types when using T-SQL builtin, identity([datatype]).

CR:535581

CR Number:   535581 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2014 Insufficient priority to fix Description Signal 11 in showE_STEP() executing complex query involving nested sub-queries with 'plan pipe text active' or showplan on. Workaround Description  sp_configure 'plan pipe text active', 0 and don't execute with showplan on

CR:535624

CR Number:   535624 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Open OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Documentation explaining how to apply new jConnect driver to resolve problems

CR:535630

CR Number:   535630 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2008 Fixed Description The error 206 is raised when executing a query containing views and involve nested outerjoins.

CR:535639

CR Number:   535639 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2008 Fixed 11 Jul 2008 Fixed 17 Sep 2008 Fixed Description ASE Cluster Edition ESD#1/2 may hang the whole cluster after many many crashes and failover-recovery of instances, each time holding up one or more internal PCM-tasks. This can be noticed in sp_who output, with many PCM-tasks sleeping for no reason (i.e without any user issued command).

CR:535666

CR Number:   535666 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2008 Fixed 16 Jul 2008 Fixed Description TEXT values returned by remote procedure calls with CIS RPC handling could be corrupted when UTF-8 character set is used.

CR:535667

CR Number:   535667 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2009 Fixed Description Under rare circumstances, while performing failover recovery for mixed log and data databases, a segmentation violation may be reported in the ASE errorlog showing modules 'th_failover' and 'th_load_thresholds_into_memory'

CR:535689

CR Number:   535689 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2008 Fixed 14 Jul 2008 Fixed Description Under rare circumstances, dump tran could hit error 4218 "... serial log page allocation rules broken. ." while scanning log chain.

CR:535719

CR Number:   535719 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2008 Fixed 11 Jul 2008 Fixed Description When turning on statement cache, subsequent execution of a query on VIEWs that fires an instead-of trigger and involves LOB may hit SIGSEGV and stack trace from the module 'eval_locator_bi'.

CR:535872

CR Number:   535872 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request to implement "CREATE TABLE ... LIKE" statement

CR:536018

CR Number:   536018 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2009 Consult Complete Description Increasing number of rs_writetext LTL created when replicating maintenance user transactions. Workaround Description  Practically none. This problem does not occur if one uses the SQL writetext command to update the text.

CR:536063

CR Number:   536063 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2008 Fixed Description In a shared disk cluster system, SELECT COUNT(*) FROM syslogs may return an incorrect value.

CR:536092

CR Number:   536092 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UX Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enable the DBA to specify a delay period before ASE tries to restart the audit process Workaround Description  N/A

CR:536105

CR Number:   536105 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2008 Fixed Description There is a syntax error in GenericTempUtil.sh when used on AIX platforms. It can be corrected by changing: export LIBPATH $SYBASE_JRE'/bin:'$SYBASE_JRE'/bin/classic' To LIBPATH=$SYBASE_JRE'/bin:'$SYBASE_JRE'/bin/classic' export LIBPATH Workaround Description  Correct the shell script to use an equal sign and make the export of the parameter a two step process. -- See description

CR:536161

CR Number:   536161 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2008 Fixed 23 Jul 2008 Fixed 27 Jul 2008 Fixed Description The Sybase Central ASE Plugin may display negative or otherwise incorrect values for the unused space field under the devices tab.

CR:536176

CR Number:   536176 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2008 Fixed 14 Jul 2008 Fixed 12 Aug 2008 Reservation Made Description In a multi-instance cluster, in rare circumstances,after an instance failed and failover recovery completed, a non-syslogs page could be used as a log page in a MLD database.

CR:536186

CR Number:   536186 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2008 Fixed 23 Jul 2008 Reservation Made Description For self-join delete queries, different rows may be deleted depending on the table order in the FROM list. By default, the first reference to the table being deleted in the FROM list, whether it has a correlation name or not, is used as the source of rows to be deleted. Under command line trace flag 120, if there is a reference to the table being deleted without a correlation name, it will be used as the source of rows to be deleted, regardless of where it appears in the FROM list. If no table without a correlation name is found, the first reference to the deleted table will be used as the source of rows to delete.

CR:536295

CR Number:   536295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In an incorrectly formatted subquery, error message 156, "Incorrect syntax near the keyword 'AS'." can be raised, even though 'AS' was not specified in the subquery

CR:536314

CR Number:   536314 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) 19 Jul 2008 Fixed 31 Jul 2008 Fixed Description On Unix systems other than Solaris, a server may hang under heavy CPU load while executing the command DBCC STACKTRACE(0,-1,1) and the server may not accept any new connections.

CR:536349

CR Number:   536349 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2008 One-off Provided Description When attempting to create index on a ZIP file containing a mix of documents(like pdf and txt files), EFTS core dumps. Workaround Description  Don't use this EBF, use Enhanced Text Search SDS/15.0.2/GA ONE-OFF 15450/P/Sun_svr4/Solaris 8/2/OPT/05-Jun-2008 06:34:11

CR:536528

CR Number:   536528 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) 05 Aug 2008 Fixed 21 Jul 2008 Fixed 25 Aug 2008 Fixed Description Appropriate errors are raised for DDL operations that do not suitable for VHASH table.

CR:536532

CR Number:   536532 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The 1204 (out of locks) error message, when seen in the errorlog, does not consistently show complete text. This CR is opened to consistently display the text "SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS." , when the 1204 error message is displayed in the errorlog.

CR:536565

CR Number:   536565 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2008 Fixed 16 Sep 2008 Fixed Description Max row size limit is unchanged when alter table lock scheme is done more than twice.

CR:536574

CR Number:   536574 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   all Original Version:   4.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2008 Fixed 29 Aug 2008 Added to user documentation 22 Oct 2008 Fixed Description Problem: ETL hangs when saving a job with 20 projects. Resolution: The internal data structure used when working with job data was adjusted to grow with larger data sets.

CR:536616

CR Number:   536616 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2008 Fixed Description ASE gets infected 11 in sqx__do_transform during update statement w/ trigger

CR:536782

CR Number:   536782 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2008 Fixed 15 Jul 2008 Fixed Description In a multi-instance cluster system, a transaction that is being rolled back in a mixed log and data database, might be blocked from completing the rollback.

CR:536815

CR Number:   536815 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2008 Fixed Description The message "Failed to allocate memory for column level datachange counters for database 'dbname' (dbid), 'objname' (objid), ..." may be reported in the error log mistakenly when a session is killed or otherwise interrupted.

CR:536894

CR Number:   536894 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2008 Fixed 22 Jul 2008 Reservation Made Description When the following conditions are true: 1. trace flag 7725 is on 2. abstract plan load is on 3. enable literal autoparam is on if failed to associate APs with the parameterized text, text will be parameterized again using 15.0.1-style autoparam name, and retry AP apply with the new text.

CR:536908

CR Number:   536908 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2009 Fixed 20 Jan 2009 Fixed 16 Jan 2009 Reservation Made Description Following an instance failure, a 2546 error may be reported by DBCC CHECKALLOC. In rare cases, a 3475 error may be reported instead

CR:536912

CR Number:   536912 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2008 Fixed 23 Jul 2008 Fixed 29 Jul 2008 Fixed Description Loading a 12.5 transaction dump including REORG REBUILD log records into a 15.x ASE may fail with a segfault error showing the modules 'bt__rebld_row' and 'bt__rebld_prepdestrow'.

CR:536931

CR Number:   536931 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2008 Fixed Description DBISQL: Unsuppressed OOM and stack trace when copying large result set Workaround Description  Don't copy huge result sets, use data\export

CR:536948

CR Number:   536948 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: pre-upgrade process to check for 'ltm', 'valid' in system databases

CR:537049

CR Number:   537049 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2009 Fixed Description Need some explanation about mnc_full_index_filter in a manual.

CR:537116

CR Number:   537116 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2008 Fixed 19 Jul 2008 Fixed 18 Jul 2008 Reservation Made Description Node failure while performing multiple inserts into a table inside a single open transaction could lead to lost inserts problem after node failover recovery.

CR:537131

CR Number:   537131 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2014 Duplicate Description dbcc upgrade_object report syntax error for procedure that have correct text. Workaround Description  Drop and create the faulted procedure and then run dbcc upgrade_object.

CR:537188

CR Number:   537188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2008 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description Error 3151 'Adaptive Server cannot load this database because the database that was dumped was not quiescent when the dump was performed.' could be returned when loading a 64 bit database dump to a platform where the byte order (endian type) is different; the dump must have been taken when there is heavy update activity on the source database.

CR:537269

CR Number:   537269 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2010 Duplicate Description installhasvss raises a 2615 error from ASE 15.0.2 or later because this script inserts a duplicate row into spt_values table.

CR:537270

CR Number:   537270 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2008 Fixed 10 Sep 2008 Presently Not Targeted For Any Future Release Of This Product Description In rare circumstances, a cluster instance can report a timeslice in the errorlog with stack description of "ptn_refresh_pdes".

CR:537367

CR Number:   537367 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2008 Fixed 06 Aug 2008 Fixed 27 Aug 2008 One-off Provided Description Under rare circumstances the message "process infected with signal 11" in the module 'ind__ides_getnext' may be reported in the error log with a stack trace which includes the modules 's_compile', 'substitute' and 'ind_rowcopy' when a SQL command is in the process of being compiled. This will result in ASE shutting down itself.

CR:537382

CR Number:   537382 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) 10 May 2010 Fixed Description dbcc sqltext(@spid) print the sql text of current thread rather than the content of specified thread when passing smallint data type variable to this command in little-endian platform. Workaround Description  replaced SMALLINT with INT

CR:537494

CR Number:   537494 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2008 Fixed Description For clusters with two or more instances, an incorrect information about physical lock deadlocks is reported in sp_sysmon monitoring output.

CR:537495

CR Number:   537495 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2008 Fixed 26 Jan 2009 Fixed Description Trigger for update query with UNION may not be able to provide correctly rows from the INSERTED/DELETED tables.

CR:537570

CR Number:   537570 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2008 Fixed 05 Aug 2008 Fixed Description SEGV in the module 'CgpInplaceUpdateVars' could happen when the query has a subquery under an OR predicate and there are more than 6 joining tables. Workaround Description  Run under allrows_mix --this *may* work, dependant on query and plan under this goal. or:- Capture the AP run it specifying the AP to bypass this bit of code. or:- dbcc traceon (15363) to disable greedy pass --this will avoid the problem, but could cause some performance degradation

CR:537594

CR Number:   537594 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2008 One-off Provided 30 Jan 2009 Fixed 03 Mar 2009 Fixed 09 Mar 2009 Fixed Description In rare circumstances, a query being executed in parallel may hang when Adaptive Server is configured with several engines and some other queries (which ran in parallel too) were aborted (for example sending CTRL+C). Workaround Description  N/A

CR:537601

CR Number:   537601 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2008 Fixed 30 Jul 2008 Fixed Description Executing a query having more than 6 tables may hit a 540 error when the optimizer's alternative greedy algorithm leaves tables opened in the event of an exception. Workaround Description  Turning on trace flag 15363 can be used as a workaround.

CR:537611

CR Number:   537611 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2009 Presently Not Targeted For Any Future Release Of This Product 03 Nov 2008 Fixed Description Password expiration messages 4022 and 7735 returned from remote ASE server are not propagated back to the ISQL client.

CR:537672

CR Number:   537672 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2008 Fixed 26 Sep 2008 Fixed 26 Sep 2008 Reservation Made 06 Oct 2008 Reservation Made 08 Oct 2008 Fixed Description The tasks that request a shared latch in DEMAND mode, can sometimes block on the physical lock upgrade taking place, and this can lead to an indefinte hang, stalling the progress.

CR:537682

CR Number:   537682 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   all Original Version:   15.0.2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2008 Fixed Description 1.Exclude "Database","Database Device","Dump Device","Execution Class","Remote Server","Login","Role" submenuItems from instance creation menu . 2.Exclude "Engine Group" from cluster creation menu. 3.Add "Local Cache", "Engine Group" and "Local Temporary Database" submenuItems for instance creation menu.

CR:537783

CR Number:   537783 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2008 Fixed 03 Sep 2008 Presently Not Targeted For Any Future Release Of This Product Description xp_cmdshell call to SSH does not return when SSH is setup to work without passwords.

CR:537823

CR Number:   537823 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2008 Fixed Description In some circumstances, queries involving declared variables may result in character interpolation assertion (ratio >= 0.0 && ratio <= 1.0) on diagservers. Workaround Description  1) specify varchar(12) as the declared variable type instead of char(12). 2) use the value directly in the search clause as c.fwd_part_cd = '200806748966'

CR:537887

CR Number:   537887 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 Jul 2008 Fixed Description Overwriting of authentication mapping takes place silently without any warning.

CR:537931

CR Number:   537931 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2008 Fixed 21 Aug 2008 Fixed 26 Aug 2008 Fixed 26 Aug 2008 Fixed Description When the number of free object descriptors is less than the number of objects with entries in sysprotects calling sp_helprotect without parameters can flush the object descriptor cache.

CR:537957

CR Number:   537957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2010 Work as design Description Computed columns may give unexpected results when non-deterministic functions such as rand() are inserted into columns the computation is based on. (The computation uses another call to the function rather than the originally generated value). Workaround Description  An insert trigger can be added to the table, the update causes the computed column to be recalculated with the current value. Ideally, table will have a primary key that can be used to join with inserted to limit the update to the rows just inserted. create trigger mytrig on mytable for insert as update mytable set x = x ------------------- Another workaround: insert test values (min(rand())

CR:538069

CR Number:   538069 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2008 Duplicate 27 Jan 2009 One-off Provided 11 Sep 2012 Fixed Description Connecting to a server that is down or non-existent server could cause memory leaks that eventually could lead to 7220 and 7235 errors.

CR:538161

CR Number:   538161 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2008 Fixed 17 Aug 2008 Fixed Description sp_statistics could return arithmetic overflow during implicit conversion of NUMERIC value to a INT field when operating on tables with more than 2^31 rows. This could also be seen when creating proxy tables.

CR:538350

CR Number:   538350 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2008 Fixed Description ASE Cluster Edition instance may crash with signal 11, under high-memory usage when distributed operations hit some exceptions.

CR:538487

CR Number:   538487 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Windows XP Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2008 Fixed 25 Aug 2008 Fixed 26 Aug 2008 Fixed Description When the Job Scheduler component is not selected during installation, using srvbuildres can still configure it.

CR:538488

CR Number:   538488 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2008 Fixed Description DDLGen generates 'NULL' SQL statement for granting the permission of the DELETE STATISTICS command. Workaround Description  N/A

CR:538527

CR Number:   538527 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2008 Fixed Description select show_plan() can get error msg and SIG 4 sometimes.

CR:538563

CR Number:   538563 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2008 Fixed 26 Aug 2008 Fixed Description In rare circumstances, ASE Cluster Edition may report an error 941 "Illegal database context operation." when dropping a local system temporary database of another instance.

CR:538584

CR Number:   538584 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) 01 Sep 2008 Fixed 01 Sep 2008 Fixed Description Clearing sql replication settings via sp_setrepdefmode, may remove the threshold configured at object level. Simmilary, when clearing the object's threshold, the sql replication settings may be lost.

CR:538587

CR Number:   538587 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2008 Fixed Description 'sp_cluster logical, failback' command fails if the failback instances are already online

CR:538623

CR Number:   538623 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2008 Fixed Description Incremental db dump/load.

CR:538633

CR Number:   538633 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) 25 Oct 2010 Fixed 24 Jul 2009 Presently Not Targeted For Any Future Release Of This Product 27 Oct 2010 Fixed Description Query with a builtin function in the WHERE clause using advanced aggregation may fail producing stack traces in the errorlog.

CR:538649

CR Number:   538649 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2008 Fixed Description A 5846 error, "Illegal value '128' specified for configuration option.." displayed while trying to configure 'global cache partition' to 128.

CR:538693

CR Number:   538693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2008 Fixed Description signal 11 (sigsegv) might happen in ResRelOp() for a nested outerjoin query with more than 2 table join inner to the outerjoin.

CR:538727

CR Number:   538727 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2008 Fixed 22 Sep 2008 Fixed 26 Sep 2008 Fixed 25 Nov 2008 Added to user documentation 02 Oct 2008 Fixed 16 Oct 2008 Fixed 14 Apr 2009 Fixed Description Provide users an option to disable "Remember Password" feature in Sybase Central ASE Plugin during installation for ASE.

CR:538729

CR Number:   538729 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2008 Duplicate Description DBCC: enhance dbcacheremove to reset dbt_keep value on user tempdb Workaround Description  dbcc dbreboot to reboot only this user tempdb

CR:538740

CR Number:   538740 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2008 Presently Not Targeted For Any Future Release Of This Product Description Feature Request for Solaris 10/SMF, provided sample sybase.xml file to start/stop ASE

CR:538777

CR Number:   538777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2008 Fixed Description HA failover or failback can fail when the connection that is running the HA takeover on the companion and a connection that is failing over have the same user login and the connection that is failing over gets locks on syslogins catalog before the HA takeover process does. The failover or failback does not complete and HA state on the companion remains unchanged.

CR:538910

CR Number:   538910 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) 01 Aug 2008 Fixed 01 Aug 2008 Fixed Description In rare circumstances, a stack trace may be reported in the errorlog involving the modules 'GtuUnion::_GtcNTopPopsGenerate' and 'GtcChildOptBlockN::_GtcBestArgsGenerate' during a query that involves both more than 4 UNION sides, parallelism and one UNION side with a distinct projection and greater than 6 tables. Workaround Description  Since you need parallelism configured, if you are only using a serial server then you should not hit this issue. Run under allrows_oltp or:- dbcc traceon (460) -- this is probably the easiest and safest way to avoid it, but ONLY do this in the session before the query and turn it off immediately afterwards, disables the fix for 439391. Turn off alt. greedy:- dbcc traceon(15363)

CR:538918

CR Number:   538918 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2009 Duplicate 26 Jan 2009 Duplicate Description A query might fail because the query plan have operator(s) that has higher tempdb requirement than available. Workaround Description  use abstract plan