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

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

CR:575330

CR Number:   575330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2009 Fixed Description ASE stacktraces with SIGSEGV (infected with 11) when the number of columns returned from a remote procedure is less than expected from the select list to a proxy table mapped to this remote procedure. Workaround Description  Fix the stored procedure or re-create the existing table.

CR:575337

CR Number:   575337 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2009 Fixed Description Procedural statement with FOR UPDATE clause may incorrectly raise error Msg 7305, Level 15, State 1: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. Workaround Description  dbcc traceon(3604,7730) go

CR:575359

CR Number:   575359 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2009 Fixed 21 Jun 2009 Reservation Made Description ASE assumes DC supports BIGINT datatype and incorrectly sends signed/unsigned NULL integer parameters as BIGINT datatype. Workaround Description  *** Thursday, June 04, 2009 01:00:13 PM *** pvero *** - Don't use null value - maybe change procedure logic - Use numeric(10,0) - not sure this works with DC/TRS 15.0 but will be suggested and possibly tested.

CR:575390

CR Number:   575390 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature Request ... immediate recompile sproc & change to view after Alter Table Modify Column

CR:575392

CR Number:   575392 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2009 Fixed Description Insert queries involving proxy tables which are either part of a trigger or will fire a remote trigger may encounter a SIGSEGV (infected with 11). "xact_sync_trigger" will usually be referenced in the stacktrace. Workaround Description  using -T 7730 or change the order of insert selects in the sp would stop the stack trace

CR:575483

CR Number:   575483 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2009 Fixed 19 Jun 2009 Fixed 16 Sep 2009 Fixed aries 16 Sep 2009 Fixed 24 Feb 2010 Presently Not Targeted For Any Future Release Of This Product Description Query accessing more than 16 tables may raise incorrectly error 225 "Cannot run query--referenced object dropped during query optimization." Workaround Description  rewrite the query

CR:575502

CR Number:   575502 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2009 Fixed Description sp_configure cannot display reports correctly when there are large amounts of unused memory Workaround Description  Always keep 'max memory' and 'total logical memory' within a sensible distance of each other.

CR:575562

CR Number:   575562 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2009 Fixed 07 Oct 2009 Reservation Made Description Error: 2805, Severity: 18, State: 0 Bad pointer 0x4 encountered while remapping stored procedure. This may be seen in the error log on execution of sql statement containing constants in both the predicate and in a group by clause. Should only happen with 'enable query metrics' enabled at point of proc creation. Workaround Description  create the procedure with query metrics disabled. set metrics_capture off go <create proc> go Once created with metrics disabled, you can re-enable it and the procedure should not report 2805.

CR:575675

CR Number:   575675 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2009 Fixed 01 Jul 2009 Fixed Description Server always selects Slow Bulk mode for bulk copying rows into table with non-clustered unique index.

CR:575761

CR Number:   575761 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2011 Fixed 06 Jul 2011 Reservation Made 11 Jul 2011 Fixed 12 Jul 2011 Fixed 08 Jul 2011 Fixed 12 Jul 2011 Fixed Description The index_union algorithm can be invoked when queries contain the OR operator or IN list operator. This algorithm was not permitted when selecting data at isolation level 0 (dirty reads) on dol tables. This algorithm will now be permitted on DOL tables with dirty reads when optcriteria cr575761 is active, and/or trace flag 16734 is on. The behavior change will be turned off if trace flag 16733 is on. If the algorithm is chosen then index_union appear as a hash union of several index scans followed by rid join in the showplan output. The abstract plan would contain a hash_union_scan if this algorithm was chosen with dirty reads on DOL tables.

CR:575846

CR Number:   575846 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2009 Fixed Description Transfer table using BCP format cannot output to a pipeline.

CR:575903

CR Number:   575903 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2009 Fixed Description Executing a NULL stored procedure by 'exec @proc' where @proc = NULL hit stack trace in the modules open_user_table() and procget() and get error 2812.

CR:575946

CR Number:   575946 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2009 Fixed 18 Aug 2009 Fixed Description The database option "no ckpt on recovery" is incorrectly turned on after a load database command on the master database successfully completes. Workaround Description  In single user mode, run update sysdatabases set status=0 where dbid=1. Then restart your ASE in multi-user mode to check that everything is OK.

CR:575947

CR Number:   575947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide an example for page 74 of CE installation guide on IO fencing

CR:575993

CR Number:   575993 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2009 Fixed 17 Jul 2009 Fixed Description Connect Dialog would not allow modified server entry if it has previously connected to the server before modification was attempted. Workaround Description  To get around the problem, customer can clear the remembered servers: Open Connect dialog. Click Settings button and open Settings dialog. Select "Clear servers" check box and click OK.

CR:576077

CR Number:   576077 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2013 Insufficient priority to fix Description When utf8 client connects to the eucjis ASE and runs dump database command, dump command fails due to a tds protocol error "Premature end of the datastream was encountered.". Workaround Description  Connect your ASE with the same charset as ASE's when you run dump database command.

CR:576097

CR Number:   576097 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 Jun 2009 Fixed 08 Jul 2009 Fixed Description The durability of database should be changed with the ALTER DATABASE command.

CR:576139

CR Number:   576139 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2010 Fixed 12 May 2010 Fixed 12 May 2010 Fixed Description The performance of concurrent DMLs in a low durability database has been slightly improved through an optimization to post-commit processing of deallocated pages.

CR:576250

CR Number:   576250 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2009 Bundled Request Description The error 4218, "Failure during DUMP of database '%.*s': serial log page allocation rules broken. Current page: %d; next page: %d; piece end: %d; end-of-scan: %d.", may be reported while creating a in-memory database using a template database which does not have full durability.

CR:576295

CR Number:   576295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2009 Fixed 01 Sep 2009 Fixed Description There is possibility of segmentation fault during XPDL conversion of a page whose page header is incorrect with PG_DATA and PG_OFFSET bits set simultaneously.

CR:576346

CR Number:   576346 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2009 Fixed 14 Jul 2009 Fixed 24 Feb 2010 Fixed Description Add PCI options into sybatch_ase.res file.

CR:576357

CR Number:   576357 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2009 Fixed 18 Sep 2009 Fixed 23 Nov 2009 Not a Bug 21 Dec 2009 Presently Not Targeted For Any Future Release Of This Product Description If a parallel plan is chosen for an AMC repartition operation, sometimes the data could be inserted into the wrong partitions.

CR:576525

CR Number:   576525 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2009 Fixed 26 Aug 2009 Fixed Description Database Wizard's (Add) Device Size Dialog does not sort device sizes correctly.

CR:576647

CR Number:   576647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2009 Fixed 01 Jul 2009 Reservation Made Description If error 249 occurs during and it does not appear to be due to constant in the query and the query has not started execution i.e. compilation is still proceeding, then this error may occur due to expression histogram processing. This can be verified by looking at the optdiag output for the columns in the query, and determining if there is a possible conversion error that could occur with one of the histogram step values. The change in behavior will be to suppress the error and use magic numbers for the selectivity of that column when used in expression histogramming. Workaround Description  Use traceflag 15352 to turn off expression histogramming. or delete or edit the problem histogram with optdiag to have legal date values or turn off statement cache

CR:576708

CR Number:   576708 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2009 Fixed Description Inserting a NULL value into a TEXT column of a proxy table with an INSTEAD OF TRIGGER may result in an assertion failure involving the module eval_locator_bi().

CR:576731

CR Number:   576731 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description NewFeature ASE 15.x - Configure for memdump during install

CR:576785

CR Number:   576785 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Fixed 11 Aug 2009 Bundled Request Description When attempt to create a cache, or increase the cache size, through the sp_cacheconfig interface, fails due to insufficient 'max memory', the suggested 'max memory' value printed as part of the following error message: "The current 'max memory' value '%d', is not sufficient to change the size of cache '%s' to '%dM' (%d KB). 'max memory' should be greater than 'total logical memory' '%d' required for the configuration." is not sufficient if the server is rebooted after the change. Workaround Description  Increase the 'max memory' to at least 2 more pages than the value suggested by the error message.

CR:576869

CR Number:   576869 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description syslogs becomes corrupted again after loading a dump tran which stacktraced

CR:576895

CR Number:   576895 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2009 Fixed Description INSERT into a VIEW which triggers an INSERT into the proxy table may cause error 3651 when the remote table also triggers a change in one of the column values being inserted.

CR:576903

CR Number:   576903 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2009 Fixed 18 Jun 2009 Fixed 18 Jun 2009 Fixed 23 Jun 2009 Fixed 14 Sep 2009 One-off Provided Description Spid executing MDA retrieval may go to sleep indefinitely under rare conditions whilst trying to take out a mutex. Stack trace will report upsleepgeneric, mda_take_mutex, fdpsrv_init_reader. Workaround Description  NA

CR:577089

CR Number:   577089 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2010 Fixed Description SELECT * INTO temp table from a VIEW with TOP and UNION ALL doesn't return all the rows. Workaround Description  select top 1000000 * into #sb from abc Another workaround insert #sb select * from abc

CR:577103

CR Number:   577103 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2011 Duplicate Description Select with ORDER BY from a view involves TOP and UNION ALL doesn't return all rows. Workaround Description  The only workaround is to enable TF4404(internal use).

CR:577113

CR Number:   577113 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2009 Fixed 02 Jul 2009 Fixed 01 Sep 2009 One-off Provided 02 Dec 2009 One-off Provided 20 Jan 2010 One-off Provided 18 Mar 2010 One-off Provided 30 Mar 2010 One-off Provided Description There is a possiblity of hitting a deadlock on the sysconfigures table when two sp_configures are run at the same time.

CR:577126

CR Number:   577126 Product Name:   SCC Web Framework Product Component:   Documentation - Other Status:   Closed OS:   Generic Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2009 Fixed Description Servers will not be displayed in the Replication Topology if they are registered with a name other than the actual server name. Servers should be registered using the actual server name for full functionality with the Replication Mangement component of SCC.

CR:577149

CR Number:   577149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2010 Fixed 23 Jul 2010 Fixed Description Performance has been improved for databases with a low durability level in cases where many DMLs are simultaneously done on the same page.

CR:577274

CR Number:   577274 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2009 Workaround Description Under multi engine conditions, ASE Task scheduled JavaVM activities get hanging under IBM AIX 5.3. This problem comes down to a suspected IBM AIX 5.3 O/S issue that is filed with IBM under PMR 51261,756,000. A design workaround was applied to ASE for IBM, avoiding this problem and is default active but will cause performance problems to those specific ASE Tasks as they all only execute from the ASE engine which is physically bound to the JavaVM. To overcome the functional and performance issue with ASE under AIX. the ASE should be booted with traceflag -T9403 and have prior to the boot AIXTHREAD_SCOPE=S environment variable setup under the shell responsible in booting the ASE. Workaround Description  This problem can be avoided by running the server in virtual mode using traceflag -T9403 and set AIXTHREAD_SCOPE=S environment before booting the server. In essence the problem comes down to PMR 51261,756,000 we filed with IBM. This problem is still under investigation. When IBM AIX 6.1 is used default behavior of AIX is to use AIXTHREAD_SCOPE=S

CR:577295

CR Number:   577295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature Request for option to set limit on the number of concurrent connections for a single login id. Workaround Description  Use login triggers.

CR:577300

CR Number:   577300 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Msg 2238 can misleads you to think this spid are run the quiesce database command in the error log you only see this. 00:00000:00016:2009/06/17 12:00:25.65 server Error: 2238, Severity: 20, State:9 00:00000:00016:2009/06/17 12:00:25.65 server QUIESCE DATABASE: Could not acquire begin lock due to LOCK INTERRUPTED. But this spid are run begin tran in master database (this only happens on master database) and a other spid have issued a quiesce database master_tag hold master plus that a spid run the begin tran in master database receive a attention.

CR:577329

CR Number:   577329 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When query uses merge_join, ASE sends a cartesian product query to the remote site.

CR:577331

CR Number:   577331 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2009 Not reproducible with latest version of the product available as of Resolution Date Description ASE sends a cartesian product query to the remote site when merge join is used.

CR:577353

CR Number:   577353 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 Jun 2009 Fixed 19 Jun 2009 Reservation Made 20 Jun 2009 Fixed 19 Jun 2009 Fixed 26 Jul 2009 Deferred Description Duplicate rows could be incorrectly returned when an EXISTS subquery is SELECTing from a DISTINCT view and not all of the view's SELECT columns are participating in the subquery's correlated equijoin predicates. Trace commandline flag 15315 can be used to workaround this problem. Workaround Description  "set opportunistic_distinct_view off" to turn off opportunistics distinct handling.

CR:577367

CR Number:   577367 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2009 Fixed Description Internal only: dbcc table_xact_check() should be runnable by DBO and SA. Instead, it requires sybase_ts_role.

CR:577398

CR Number:   577398 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2009 Fixed 24 Jun 2009 Fixed 29 Jun 2009 Fixed Description On Unix platforms, Fix Statistics Wizard's Options page gets a stack trace when you click Browse, enter a name, and click Save.

CR:577488

CR Number:   577488 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2009 Fixed 14 Nov 2011 One-off Provided 02 Oct 2012 One-off Provided 28 Sep 2012 Fixed Description Provide traceflag 1144 to avoid 1127 errors reporting insufficient space in the OAM page when running heavily concurrent multi-user applications simultaneously inserting into the same table.

CR:577494

CR Number:   577494 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Sub-optimal query plan may be chosen in rare circumstances on non-binary sort order for query involving distinct operator and exists sub-query

CR:577504

CR Number:   577504 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2009 Fixed 24 Jun 2009 Fixed Description On the Windows platform, the Monitor Server does not shut down when the ASE is shut down

CR:577525

CR Number:   577525 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2009 Fixed 08 Jul 2009 Fixed Description When ddlgen is used to extract the DDL for an object, that contains a user defined datatype which has a default bound to the type, the DDL generated contains an extra sp_binddefault command that fails because the default already exists. Workaround Description  There is not really a simple workaround. However, the problem really only generates errors and does not cause complex problems. The unwanted sp_binddefault command simply fails because a default already exists.

CR:577662

CR Number:   577662 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) 11 Mar 2010 Fixed Description sp_plan_dbccdb needs enhancing to suggest a size for the 8 page pool in a named cache

CR:577668

CR Number:   577668 Product Name:   Adaptive Server Generic Docs Product Component:   Adaptive Server New Features Guide Status:   Open OS:   NA Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description TOP UIV support is limited

CR:577671

CR Number:   577671 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2010 Fixed Description datachange() function always returns 0 if the table has no indexes and we do update statistics on table only Workaround Description  The problem for the client is that they rely on select datachange(t1,null,null) to determine whether or not update statistics has been run. This behaviour does not enable them to identify the difference between the case when update statistics has never been run on the table and when no change occured on the table since the last update statistics. Suggested workarounds are to use a specific column in the test, but, the client cannot do this since ..ct cannot do it, because he wants to check all tables with datachange in order to see if he will do an update stat. He does not know anything about the tables, this will be an automatic procedure. Suggested trying this procedure as a quick method to work round the clients the lack of knowledge of the clients data. create procedure datachange_col @tablename varchar(255) as begin declare @colname varchar(255) select @colname = name from syscolumns where id = object_id(@tablename) and colid = (select min(colid) from syscolumns where id = object_id(@tablename)) select datachange(@tablename,null,@colname) end go Since the client is not available I do not know whether this workaround is acceptable.

CR:577678

CR Number:   577678 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) 31 Jul 2009 Fixed Description Incorrect variable assignment using ISNULL over CIS connections Workaround Description  Use traceflag 7703 or use more than one variables @id = isnull(@id2,ID)

CR:577680

CR Number:   577680 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) 24 Aug 2009 Fixed Description ins_syn_sql incorrectly calculates free space on the default disk

CR:577686

CR Number:   577686 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2009 Fixed 07 Jul 2009 Fixed Description If two indexes on different tables have the same name and if output from DDLGen is generated just for indexes, then an attempt to run this generated output fails if the indexes have been deleted in the server after the DDlGen was first run for the indexes.

CR:577692

CR Number:   577692 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) 21 Jul 2009 Not a Bug Description select on Java function performance drop

CR:577711

CR Number:   577711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2009 Fixed 23 Aug 2009 Fixed Description Unable to connect to ASE using the reserved administrative connection when network password encryption (-X) is enabled.

CR:577713

CR Number:   577713 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) 23 Jul 2009 Fixed Description Sometimes, the message "current process infected with 11" in the module 's_handle' is reported in the errorlog along with errors 2601 and 546, while trying to insert into a table that has foreign key constraints.

CR:577948

CR Number:   577948 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Open OS:   AIX Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description request to have sybmigrate have the ability to have table sampling ability - only migrate a % of a table.

CR:578146

CR Number:   578146 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description allowing auditing of all database objects for 1 specific database using one sp_audit cmd

CR:578157

CR Number:   578157 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2009 Presently Not Targeted For Any Future Release Of This Product 15 Dec 2009 Fixed 17 Dec 2009 Fixed 13 Sep 2010 Presently Not Targeted For Any Future Release Of This Product Description Some stored procedures using temporary tables and trace 299 (forced open by name resolution) may result in stack trace. This happens if a procedure is frequently renormalized. The stack trace shows the module "lastleft". Workaround Description  do not use trace 299 for procedure which result in the stack trace. If objects were created under 299, re-create them with 299 off (or run dbcc markprocs)

CR:578258

CR Number:   578258 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2009 Fixed Description In certain cases, CLM MDA table monCLMObjectActivity may not show updated information for logical locks.

CR:578330

CR Number:   578330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2009 Fixed 30 Jun 2009 Fixed 30 Jun 2009 Fixed Description Engines other then Engine 0 may stay around when the ASE is shutdown.

CR:578361

CR Number:   578361 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2009 Fixed 03 Jul 2009 Reservation Made Description (Internal Only) A 3475 error: " There is no space available in SYSLOGS to log a record for which space has been reserved in database '<dbname>' (id <dbid>)." may be reported for a database with mixed log and data, even though there may be allocation pages with free extents.

CR:578391

CR Number:   578391 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2010 Fixed Description The DBCCLOG command in sybmon is extended to support reading compressed dumps.

CR:578405

CR Number:   578405 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2009 Fixed 29 Jun 2009 Fixed 29 Jun 2009 Fixed 14 Jul 2009 Fixed Description Sybmon is unable to parse sqlsrvr data structures on nt386.

CR:578424

CR Number:   578424 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2009 Fixed 02 Nov 2009 One-off Provided 29 Apr 2010 One-off Provided Description The message "current process infected with 11" may be reported in the error log together with a stack trace which includes the modules 'Optimize' and 's_compile' when executing an UPDATE statement involving a join between two or more tables and the table being updated has defined a functional index involving columns which are being updated with values from columns from the other table(s) participating in the join.

CR:578515

CR Number:   578515 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2013 Fixed 10 Jan 2013 Fixed 14 Jan 2013 Fixed 15 Jan 2013 Fixed 15 Jan 2013 One-off Provided 04 Feb 2013 Fixed 05 Feb 2013 Fixed Description sp_sysmon appl_and_login does not show the detail of activity by application name and login name. Workaround Description  sp_sysmon "00:01:00", appmgmt, @applmon = appl_and_login, @option=clear

CR:578546

CR Number:   578546 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description Dataserver fails to boot on machines with glibc version of 2.6 and above

CR:578662

CR Number:   578662 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Fixed Description If forceplan is used to force the use of a vhash index to scan the table in a join, a SIGSEGV or incorrect result can occur.

CR:578692

CR Number:   578692 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) 06 Jul 2009 Fixed Description when outer joins have inner tables which are derived tables with UNION operators then there is a possibility of a stack trace. Workaround Description  Use temp table instead of derived table, query will fine. No signal 11 raised. Example, we modify repro query sql to this query:- select c1,c2 into #tmp from t3 where c1 = 0 union select c1,c2 from t3 where c2 is not null select count(*) from t1 left join t2 on t2.c1=t1.c1 left join #tmp tt on t1.c2=tt.c2 where tt.c2 is not null

CR:578769

CR Number:   578769 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description update stats blocks drop trigger

CR:578782

CR Number:   578782 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2010 Fixed 17 Dec 2009 Fixed 11 Jan 2010 Reservation Made Description ASE Rep Agent support for the database re-synchronization feature from Replication Server 15.5. Workaround Description  N/A.

CR:578797

CR Number:   578797 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) 13 Nov 2009 Fixed 30 Apr 2010 One-off Provided 05 Jan 2010 One-off Provided 13 Nov 2009 Reservation Made 05 Jan 2010 One-off Provided 16 Apr 2010 One-off Provided 30 Apr 2010 One-off Provided Description Neither of these traceflags introduced via this CR should be required and should only be considered if stack traces are seen in 15.0.3 ESD#4 involving des_wkinstall() For 578797-1, we added some codes under trace flag 7751 to clean up worktables at the end of execution if worktables are not dropped. DO NOT run TF 7752

CR:578874

CR Number:   578874 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2009 Fixed 03 Sep 2009 Fixed Description Under rare circumstances ASE fails to compile statements in the deferred compilation mode.

CR:578889

CR Number:   578889 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2009 Fixed Description After ASE detects a 605 error on a DOL index, ASE does not report the 605 error again on the same wrong page until ASE restarts.

CR:578908

CR Number:   578908 Product Name:   Adaptive Server Enterprise Product Component:   sql Status:   Closed OS:   HP-UNIX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) aries 02 Jul 2009 Fixed 12 Jan 2010 One-off Provided 30 Apr 2010 One-off Provided Description In some circumstances, timeslice stack trace might occur while shutting down the cluster.

CR:578913

CR Number:   578913 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UNIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description After applying ASE 15.0.2 ESD#1 or above, reformatting may not be chosen and performance may slow down if the SELECT statement has 6 or more joined tables in the FROM clause. Workaround Description  Use the trace flag 15363. Better still, from 1503 GA onwards, use criteria "set alternative_greedy_search off | on" either side of the query.

CR:578953

CR Number:   578953 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2009 Fixed Description In some rare cases, for a dedicated log database, log page chain may get broken.

CR:578991

CR Number:   578991 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2009 Fixed 10 Aug 2009 Fixed 07 Aug 2009 One-off Provided Description There is a possibility that during bcp operation, some rows may be received incorrectly and cause an inconsistency in the database. Extra checking on received rows has been added to prevent this.

CR:579008

CR Number:   579008 Product Name:   Adaptive Server Enterprise Product Component:   coverletter Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2010 Insufficient priority to fix Description SPDC download of 1503 GA has been replaced with 1503 ESD#1 binary, but the cover letter still referring to 1503 GA.

CR:579040

CR Number:   579040 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) 30 Jun 2009 One-off Provided 03 Jul 2009 Fixed 09 Jul 2009 One-off Provided Description A SIGSEGV (infected with 11) referencing "lt_notify_flush" can occur under a high stress scenerio in a replication environment.

CR:579044

CR Number:   579044 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2009 Fixed 13 Jul 2009 Fixed Description ASE Plug-in and DBISQL's Connect Dialog encounters a syntax error setting a new password when the old password contains special characters. Workaround Description  WorkAround: ----------- You can enter the new password using isql with the sp_password call. Or have DB admin do this for you.

CR:579209

CR Number:   579209 Product Name:   SySam Docs Product Component:   SySam User Guide Status:   Open OS:   Generic Original Version:   2.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description To include cpuinfo,binIPV6,binIPV4 information in sysam user guide.

CR:579240

CR Number:   579240 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2009 Fixed Description An error 209 with the message "Ambiguous column name" may appear if a stored procedure which performs the UPDATE or DELETE with the selfjoin is executed by the non owner of a procedure and the execution is performed using the deferred compilation mechanism. Workaround Description  Match owner.table qualification in update and from clause. Or disable deferred compilation via traceflag 7730.

CR:579241

CR Number:   579241 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) 17 Jul 2009 Fixed 03 Sep 2009 Fixed Description Under some rare circumstance related to the runtime recompilation of the parallel queries using expression involving LIKE and variables or parameters ASE may fail to generate parallel plan and report stack traces in the errorlog file. A trace will show modules copy__eval and copy__eoptlike.

CR:579246

CR Number:   579246 Product Name:   SySAM Product Component:   FLEXlm Status:   Closed OS:   all Original Version:   10.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2010 Duplicate Description feat req: add OS vers in sysam status -a output

CR:579273

CR Number:   579273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2009 Fixed 14 Aug 2009 Fixed Description Fragmentation handling for in-memory storage cache.

CR:579283

CR Number:   579283 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) 02 Sep 2009 Fixed 24 May 2010 Duplicate Description Error 1622 following error 1105 and error 3621 may be reported when bcp in data into table with text/image columns.

CR:579410

CR Number:   579410 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2009 Not a Bug 02 Sep 2009 Fixed Description ASE configuration with very large memory on Linux platform could take long time to initialize the whole shared memory.

CR:579446

CR Number:   579446 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) 08 Oct 2009 Fixed Description In rare circumstances, setuser command fails sometimes producing stack traces in setuser().

CR:579447

CR Number:   579447 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request to associate a severity with the un-numbered messages in the ASE errorlog.

CR:579579

CR Number:   579579 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2009 Fixed Description In rare circumstances the message "current process infected with 11" in the module 'open_user_table' may be reported in the error log while booting ASE cluster.

CR:579583

CR Number:   579583 Product Name:   SySAM Product Component:   FLEXlm Status:   Open OS:   Solaris Original Version:   10.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description License server fails to check when file descriptors is set more than 9999 Workaround Description  Set the file descriptors less than 9999

CR:579586

CR Number:   579586 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2009 Fixed 16 Jul 2009 Fixed 16 Jul 2009 Fixed Description A query on the monSysStatement MDA table may cause a timeslice error when there is a large statement pipe. Workaround Description  lessen 'statement pipe max messages' to a smaller value(such as 5000).

CR:579688

CR Number:   579688 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for IBM Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2011 Added to user documentation Description AIX 5.3 needs to be a 64-bit kernel before upgrading to ASE 15

CR:579776

CR Number:   579776 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2009 Fixed Description Internal only: attempt to transfer table from a view causes a segmentation fault.

CR:579798

CR Number:   579798 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) aries 08 Jul 2009 Bundled Request Description Internal only: attempt to transfer table 'for iq' uses the wrong default column order.

CR:579877

CR Number:   579877 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2010 EOL'd version. Not to be Fixed. Description While a DBCC SETTRUNC('ltm','valid') operation is being done on a database, segmentation violations may occur on tasks doing concurrent updates on the same database, in ASE procedure lt_notify_flush().

CR:579890

CR Number:   579890 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jul 2009 Fixed Description Incremental transfer will not support transferring off-row columns. It should raise an error when the user tries.

CR:579925

CR Number:   579925 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2010 Fixed 21 Jan 2010 Reservation Made 28 Jun 2010 Fixed Description Error 247 is raised incorrectly in some cases when performing calculations on literal numeric values involving different implicit precision and scale.

CR:579931

CR Number:   579931 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 Oct 2009 Fixed Description The error 2546, "Table Corrupt: Extent id %ld on allocation pg# %ld has objid %ld, indid %ld, and used bit on, but reference bit off.", may be reported by DBCC CHECKALLOC() after failover recovery in case of a segregated log and data database.