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

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

CR:319452

CR Number:   319452 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2003 Fixed 28 Aug 2003 Presently Not Targeted For Any Future Release Of This Product 28 Aug 2003 Fixed 12.5.1 28 Aug 2003 Fixed 15 Dec 2004 Fixed Description The message, "current process ... infected with 11" together with a stack trace that includes the functions 'lwp_create()' and 'sqt__copy_chunks()' may be seen in the errorlog when a Dynamic SQL application is running against an ASE server that is using a multi-byte character set.

CR:319472

CR Number:   319472 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2003 Fixed 12 Jun 2003 Fixed Description The message "timeslice -<value>, current process infected" in the module 'des__clean' or 'des__unlink' together with a stack trace that includes the module 'sqt_free' may be reported in the error log when ASE is cleaning the Light Weight Procedure objects of a session. This error results in ASE shutting down. Workaround Description  N/A

CR:319482

CR Number:   319482 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Library Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2006 Insufficient priority to fix Description Monitor Client Library and Historical Server lack error messages

CR:319501

CR Number:   319501 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2003 Fixed 25 Jun 2003 Presently Not Targeted For Any Future Release Of This Product 23 Jun 2003 Fixed Description Query having a subquery and selecting from a view which also has some subqueries may sometimes return incorrect results. When executed with the SHOWPLAN option ON, the output shows that multiple subqueries have the same subquery number.

CR:319523

CR Number:   319523 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2003 Fixed 10 Jun 2003 Fixed Description Excessive network traffic can be seen in ASE 12.5 for queries selecting a lot of columns. With the introduction of wide columns in ASE 12.5, a new TDS packet "TDS_ROWFMT2" was introduced to accomodate the increased length in the data rows. There are additional meta data in "TDS_ROWFMT2" which lead to the increased network traffic. Performance improvements were made to cache the meta data, as well as providing an option to disable the transfer of the new meta data in "TDS_ROWFMT2" via -T7705 traceflag.

CR:319600

CR Number:   319600 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2003 Fixed Description If the dbcc_exclusions table exists when the installdbccdb script is run, the dbcc_exclusions table will be dropped.

CR:319605

CR Number:   319605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2003 Fixed Description Under some circumstances an UPDATE STATISTICS command on a proxy table might fail with a series of errors including 103, 102, and 105.

CR:319671

CR Number:   319671 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2005 Fixed Description The error 8204 is raised when an invalid system table id (< 100) is passed to the built-in function object_name().

CR:319885

CR Number:   319885 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2006 Fixed 01 Feb 2005 Presently Not Targeted For Any Future Release Of This Product 07 Jul 2006 Fixed 07 Jul 2006 Fixed Description The execution of the DBCC CHECKALLOC, DBCC TABLEALLOC, DBCC TEXTALLOC and DBCC INDEXALLOC commands with the FIX option may result in removing OAM entries that show 0 pages allocated and 0 pages used. Similarly the OAM chain may be extended should there be a need for this. Workaround Description  N/A

CR:319890

CR Number:   319890 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2003 Fixed 04 Jun 2003 Fixed Description The message "process infected with 11" may be reported in the errorlog together with a stacktrace which includes the modules 'res_find', 'resgotos' and 'sqlpars' if a CREATE PROCEDURE is executed with a very large number of parameters, local variables and goto labels. Workaround Description  None.

CR:319900

CR Number:   319900 Product Name:   Adaptive Server Enterprise Product Component:   sybconfig Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2003 Not reproducible with latest version of the product available as of Resolution Date Description SYCONFIG.exe creates a new ASE server using "NLWNSCK" Driver instead TCP Workaround Description  Use the DSEDIT, to change to change to TCP

CR:319980

CR Number:   319980 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2003 Fixed 04 Jun 2003 Fixed Description The performance of BCP in "fast mode" (partial logging) is poor when the target table has a TEXT or IMAGE column.

CR:320007

CR Number:   320007 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2003 Fixed 13 Jun 2003 Fixed 28 Jul 2003 Fixed 27 Jun 2003 Fixed Description In rare circumstances, DBCC CHECKDB will report 2540, 2546, 7940 or 7949 errors after a BCP "in" operation has been aborted and the target table is data-only locked and has at least one index. Workaround Description  - Use fast bcp (but then may hit CR 231130). - Let bcp run to completion. - If bcp'ing into a partitioned table, create a clustered/placement index (LSA is disabled - see CR 125974) - Set 'number of pre-allocated extents' to 0 (note CR 320178)

CR:320009

CR Number:   320009 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2003 Fixed Description ASE 12.5.0.x on Linux stacktraces on startup if the i386 glibc libraries are being used. ASE does not support i386 glibc, install i686 libraries. Workaround Description  Don't use the i386 glibc libraries. Install the i686 glibc libraries if not installed and make sure /lib is not in LD_LIBRARY_PATH.

CR:320027

CR Number:   320027 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2003 Fixed 17 Jun 2003 Fixed 04 Jul 2003 Fixed Description Currently all stored procedures referencing a table changed by ALTER TABLE MODIFY <column> or ALTER TABLE DROP <column> will be renormalized. Under some conditions renormalization may not be sufficent. Command line trace flag -T7706 should be used to force automatic regneration of stored procedures from syscomments text instead of simple renormalization. Workaround Description  Drop and recreate the procedure (however, you somehow have to realize that you need to do this, it isn't obvious).

CR:320076

CR Number:   320076 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2003 Fixed 28 May 2003 Fixed Description The execution of DBCC TEXTALLOC("all") will mistakenly raise error 2501 "Table named all not found; check sysobjects". Workaround Description  Use "0" instead of "ALL"

CR:320167

CR Number:   320167 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2004 Fixed Description monProcessActivity.TempDbObjects is not cumulative but shows a moment in time value. This column should be cumulative and report the total number of temporary tables created by the process. The number of worktables created by the process should be separately accounted for in a new column called WorkTables.

CR:320173

CR Number:   320173 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2003 Fixed 19 Aug 2004 Fixed Description Error messages "kernel ncheck: poll, POLLNVAL on fd xx" are logged continuously to errorlog Workaround Description  Unknown

CR:320178

CR Number:   320178 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2003 Fixed 28 May 2003 Fixed 28 May 2003 Fixed Description When the configuration parameter 'number of pre-allocated extents' is set to zero, or ASE has been started with -T1101 to disable large page allocation, a BCP "in" operation may terminate with a stacktrace; modules 'bulk_main', 'bulk__fast_dol_update_lastpage' may be seen in the errorlog. Workaround Description  - Set 'number of pre-allocated extents' to a non-zero value (or disable traceflag 1101) - Change table to allpages locks - If this was a slow bcp then move back to 12.0.0.7 IR that doesn't have 308220 included.

CR:320193

CR Number:   320193 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2004 Fixed Description dbcc checktable() reports Error 2578 for unpartitioned dol tables and Error 9923 for partitioned dol tables, if the previous page value stored in the first page is not 0.

CR:320218

CR Number:   320218 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2004 Fixed Description Upgrade to 12.5 will fail with error 2601 (duplicate key) while processing upgrade step 1274 if sysroles already contains an entry with lrid equal to a preselected value. This causes the upgrade to fail.

CR:320289

CR Number:   320289 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2003 Fixed Description In a symmetric HA configuration, if a failover property enabled connection is terminated due database shutdown, a ha operation, the connection will be able to reconnect once the failover/failback is complete.

CR:320354

CR Number:   320354 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2003 Fixed Description Update statistics on a proxy table mapped to a directory returns a syntax error (Msg 11204).

CR:320360

CR Number:   320360 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2003 Fixed Description The system roles server id ('suid') in SYSUSERS is incorrectly set to '-uid' when a database is created or upgraded. Workaround Description  Update manually the value of suid in the sysusers table on model database

CR:320377

CR Number:   320377 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 05 Jun 2003 Fixed Description The rows for attributes 'default cluster ID' and 'current cluster ID' are not inserted into sysattributes table, instead the rows for the definition of those attributes are modified. That leads to the corruption of the sysattributes table.

CR:320421

CR Number:   320421 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2005 Fixed Description The message "CT-LIBRARY error: ct_results(): protocol specific layer: external error: There is a tds protocol error. An invalid datatype was received." is raised when executing a SELECT on a view containing a UNION clause with SELECT's having a NULL, like SELECT col=NULL, on each side of the UNION. Workaround Description  To see the descriptions.

CR:320440

CR Number:   320440 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2009 Insufficient priority to fix Description When server is booted with traceflag 3607 or 3608, attempts to access dynamic system tables such as sysprocesses, syslocks, syslisteners and syscurconfigs are infected with 11. On 12.5.x the stacktrace includes functions com_crt_worktable() and com_faketables(); on 15.x the stack includes CgLavaUtils::CgCompFakeTable() Workaround Description  You can't access the fake tables without tempdb. However, for syscurconfigs, see the .cfg file. For syslocks, use dbcc lock. For sysprocesses, use dbcc pss.

CR:320444

CR Number:   320444 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2008 Fixed 07 Apr 2010 Insufficient priority to fix 24 Jan 2009 Fixed Description Enable a text column in a table, to be altered from "NOT NULL" to "NULL". Target Version  To Be Determined

CR:320498

CR Number:   320498 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2003 Fixed 26 Jun 2003 Fixed 17 Jun 2003 Fixed Description Queries like SELECT <expression1>, <CASE expression2> FROM ... WHERE GROUP BY <expression1>, <CASE expression2> may sometimes return duplicate rows if expression2 contains expression1.

CR:320582

CR Number:   320582 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2003 Fixed 27 Jun 2003 Fixed 12 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 17 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description sqldbgr's where command causes an exception in sqldbgr if name of the procedure that is being debugged is greater than 24 characters or 28 characters (dbo.proc_name)

CR:320653

CR Number:   320653 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2003 Fixed Description "dump on conditions" parameter should say "sp_shmdumpconfig" instead of "maximum dump conditions", as the stored procedure is what displays the conditions that are set. "maximum dump conditions" just displays the number of conditions that you can set.

CR:320654

CR Number:   320654 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2003 Fixed Description "appl_only" and othe sysmon sections should be documented as 2nd parameter of sp_sysmon

CR:320692

CR Number:   320692 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2006 Workaround Description New Feature Request that STATISTICS IO information is returned from queries involving proxy tables. Workaround Description  For ASE backends, issue exec sp_remotesql <remoteserver>, "set statistics io on" OR Showplan will display the queries being passed to the remote server. Then the developer can run these directly on the remote server and get statistics information.

CR:320719

CR Number:   320719 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2005 Fixed Description Configuring a large procedure cache results in an '#' before the Memory Used column in sp_configure output.

CR:320734

CR Number:   320734 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2003 Fixed Description Fixes rare database corruption problems such as 694 or 692 errors seen during the load of a 12.5.0.1 and above database on NT.

CR:320745

CR Number:   320745 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2003 Fixed 15 Jun 2003 Fixed 27 Jun 2003 Fixed 27 Jun 2003 Fixed Description In rare circumstances, recovery may report a 2622, or 12546 during a server restart following a crash or a SHUTDOWN WITH NOWAIT when the configuration option 'housekeeper free write percent' was non-zero. Workaround Description  Turn off the HK_WASH process using: sp_configure "housekeeper free write percent", 0

CR:320774

CR Number:   320774 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2003 Fixed Description Upon successful server configuration, sybatch.exe exits with 134 instead of 0.

CR:320818

CR Number:   320818 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2003 Not a Bug Description Builtin that can return null (e.g nullif) used in where expression doesn't return null result Workaround Description  Use the isnull() function with the builtin: select * from test where a = isnull(nullif(2,2), null) go

CR:320868

CR Number:   320868 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2003 Fixed 03 Sep 2003 Fixed Description A recovery error (such as a 624 error) may be reported during server startup or DBCC CHECKSTORAGE may report 100004 errors after server startup on a user-created temporary database. Workaround Description  Prevent any use of the database until recovery of it has completed. See also "Description".

CR:320893

CR Number:   320893 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Digital UNIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2003 Fixed 15 Aug 2003 Fixed Description Directories and files mapped to proxy tables now have a file path limit of 255 bytes. Attempting to open a file with the fully qualified name greater than 255 bytes will fail with a file name too long error.

CR:320913

CR Number:   320913 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2003 Fixed 29 May 2003 Fixed Description When configuring for SunCluster3.0 cluster, "sp_companion <secondary_server>, configure" command fails to set the ASE resource property 'Secondary_companion_name' and doesn't report the error.

CR:320936

CR Number:   320936 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request for built-in statistical functions including median, standard deviation, variance, correlation coefficient, linear regression Workaround Description  1) SQL code for variance and standard deviation can be found in Joe Celko's book "SQL for Smarties" 2) Use the user-defined functions feature.

CR:320937

CR Number:   320937 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2003 Fixed 02 Jun 2003 Fixed Description When an invalid configuration group is found in the configuration file, during boot, ASE prints a message and continues to boot. Prior to this fix, ASE failed the boot.

CR:320945

CR Number:   320945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2003 Fixed 02 Jun 2003 Fixed 09 Jun 2003 Fixed Description Enable implicit conversions between unichar/univarchar and datetime/smalldatetime.

CR:320965

CR Number:   320965 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2003 Fixed Description At recovery, attempt to recreate a temporary database when it's devices were not active could result in failures while attempting disk i/o. A database should not be recovered if it's devices are not available.

CR:320979

CR Number:   320979 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2003 Fixed 04 Dec 2003 Fixed 05 Oct 2005 Presently Not Targeted For Any Future Release Of This Product Description Table scan may be chosen over nonclustered index scan if 16k I/O pool is configured. Fix is disabled by boot time trace flag 397. (396 on 12.0)

CR:320994

CR Number:   320994 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2003 Fixed Description The command DBCC PRINTOLOG always uses the maximum length of the parameter instead of using the actual length. Workaround Description  Use variable only once.

CR:321022

CR Number:   321022 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2003 Fixed 07 Nov 2005 Not a Bug Description The database options for database properties will be retrieved from stored procedure - sp_dboption.

CR:321026

CR Number:   321026 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2003 Fixed 10 Jun 2003 Fixed Description The drop of a java function doesn't correctly cleanup the Syscolumns table, resulting in 2513 error from 'dbcc checkcatalog'. Workaround Description  patch syscolumns (;-

CR:321096

CR Number:   321096 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2003 Fixed Description If a slice table has a empty slice with an empty first page other than the first page of the table, dbcc checktable will falsely report 2586 error.

CR:321106

CR Number:   321106 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2004 Bundled Request Description Assersion failuare in stu_interpolate() when unichar/univarchar datatypes are used in certain context.

CR:321133

CR Number:   321133 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2003 Presently Not Targeted For Any Future Release Of This Product Description Instrumentation to try and determine the cause of CR 319319 in which a 3474 error is raised during LOAD TRAN.

CR:321164

CR Number:   321164 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2010 Insufficient priority to fix Description Feature request to have the backupserver dump compression module support rsynch, so that compressed dumps can be transferred much more efficiently to remote sites. Workaround Description  Dump without compression, then use a compression utility that supports rsynch to compress the dump, use rsynch to transfer that compressed file.

CR:321193

CR Number:   321193 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2003 Fixed Description When configuring ASE for the Sybase High Availability, no error message is displayed if a cluster or Operating System command fails.

CR:321204

CR Number:   321204 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2003 Fixed 12 Jun 2003 Fixed 17 Jun 2003 Fixed 30 Sep 2003 Fixed Description Concurrent inserts in a Data Only Locked table while its index is undergoing split may result in a 644 error when deleting these data rows; the inserted row ends up in the wrong side of the split position and causes the scanner not to find the index row for the associated data row (644 error).

CR:321254

CR Number:   321254 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2006 Fixed Description The column properties for a bit-type column always needs to be NOT NULL. The command "create table" (T-SQL Commands in the ASE ref manual) and the stored procedure "sp_dboption" relating to the "allow nulls by default" database option (System Procedures in the ASE ref manual, and Setting Database Options in the System Admin Guide) are to be updated with comments to reflect this information.

CR:321256

CR Number:   321256 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2004 Insufficient priority to fix 18 Jun 2003 Fixed 08 Mar 2005 Insufficient priority to fix Description Sometimes Historical Server will receive an invalid database id from the Monitor Server causing it to report an error and fail.

CR:321261

CR Number:   321261 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2003 Fixed 04 Jun 2003 Fixed 16 Jun 2003 Fixed 30 Sep 2003 Fixed 19 Nov 2003 Fixed Description CIS: A 2762 error, "command not allowed within multiple statement transaction" may be reported when executing a SQL INSERT..SELECT from proxy table mapped to a RPC.

CR:321283

CR Number:   321283 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2006 Not a Bug 19 Jun 2003 Presently Not Targeted For Any Future Release Of This Product Description MDA config parameters like "errorlog pipe max messages" do not get set immediately

CR:321286

CR Number:   321286 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2003 Fixed Description When the non-clustered index of SYSOBJECTS is recreated using the 'sp_fixindex' stored procedure, the 'sysstat' column is not restored back to its original value.

CR:321298

CR Number:   321298 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2004 Fixed Description The Sybmon utility may report that the version of the server that was used to create a dump file is different from the version of Sybmon used to load it. The version string will appear to have some garbage characters appended to it.

CR:321317

CR Number:   321317 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2005 Insufficient priority to fix Description Feature request to allow DISK INIT to create multiple logical devices on a single raw partition (for instance, one might want to create two 32-gb logical devices on a 64-gb raw partition)

CR:321366

CR Number:   321366 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2004 Fixed 14 Sep 2003 Fixed Description In a busy system online database dumps will hang while create index, update statistics, reorg running in parallel.

CR:321406

CR Number:   321406 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2008 Fixed Description DBCC CHECKSTORAGE does not check for log free space count discrepancies. Workaround Description  Execute: dbcc tablealloc("syslogs")

CR:321425

CR Number:   321425 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description additional information for error 3619

CR:321446

CR Number:   321446 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2004 Fixed 03 Sep 2004 Fixed 07 Jun 2005 Fixed 30 May 2005 Not a Bug Description The existing -p flag, used to reset the SSO password, has been enhanced to admit sa_role and sso_role as parameters, to reset the roles password stored in SYSSRVROLES.

CR:321451

CR Number:   321451 Product Name:   Adaptive Server Generic Docs Product Component:   EFTS SDS and SFTS SDS Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2003 Fixed Description Doc Bugs related to Full Text Search 1. Should mention starting the FTS engine during the steps to setup FTS in Chapter 3 of the Full-Text Specialty Data Store User's Guide 2. Chapter 3, under the heading "Name the local server" -- Clarify that it should be ASE server and not FTS engine. 3. Chapter 6, under the heading "Starting the Full-Text Search Engine on Windows NT" -- it should be clarified that the "path to the sql.ini" file must include the filename 'sql.ini'. And if you are adding the errorlog info then it should also include the errorlog file name along with its complete path.

CR:321452

CR Number:   321452 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2003 Fixed 18 Jun 2003 Fixed Description Internal SQL usage can cause stack overflow and/or stack guardword corruption in ASE 12.0 and subsequent versions up to and excluding 12.5.1. Workaround Description  Increase the stack size by 10% chunks.

CR:321471

CR Number:   321471 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2004 Not a Bug Description If you had a local and a remote ASE and configured the local ASE to use trusted login. sp_serveroption remote_server, 'server login', true Now do not setup the remote server to trust this server, then the connections to the remote server will fail on second attempt onwards.

CR:321599

CR Number:   321599 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2003 Fixed 03 Sep 2003 Fixed 11 Sep 2003 Fixed Description In some cases the message "The requested update to the OAM for object <value>, dbid <value>, index <value>, oam page <value>, would cause a negative page count..." may be incorrectly reported in the error log when an error occurs whilst running a REORG REBUILD command. Workaround Description  N/A

CR:321618

CR Number:   321618 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2003 Fixed 11 Jul 2003 Fixed 16 Jul 2003 Fixed Description When ASE encounters a TLI status of TSYSERR returned from the operating system, only the message 'System Error' appears in the error log. For a full diagnosis of TSYSERR, the current value of the global error 'errno' should also be printed.

CR:321744

CR Number:   321744 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2003 Fixed 18 Sep 2003 Fixed 18 Sep 2003 Fixed Description If a table has both column level and table level check constraints then only column level check constraints are generated and table level check constraints are not generated. This problem is seen in command line version of DDLGen, Migration Tool and DDLGen functionality of Sybase Central ASE Plug-in.

CR:321862

CR Number:   321862 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2003 Fixed Description If the 'number of sort buffers' parameter is configured to a very large value, parallel create index may encounter a time slice error.

CR:321874

CR Number:   321874 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2003 Fixed Description When the database option 'allow nulls by default' is set for the TEMPDB database, any attempt to encrypt a stored procedure text using 'sp_hidetext' will fail with a 9941 error saying "The source text of object named '<Object Name>' with object id '<Object ID>' is missing and it is not hidden." Workaround Description  The workaround is to temporarily change the tempdb's dboption to "allow nulls by default", false.

CR:321876

CR Number:   321876 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2003 Presently Not Targeted For Any Future Release Of This Product 26 Jun 2003 Fixed Description The 2843 error message, "The dynamic statement '<name>' could not be found. This may be due to insufficient metadata descriptors for the number of tables and procedures in use by Adaptive Server. Configure the serverwide 'number of open objects' parameter to accommodate more objects." incorrectly omitted increasing the 'procedure cache size' configuration parameter as a possible solution to the error.

CR:321884

CR Number:   321884 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2005 Fixed Description For a newly created device, 'dsync' property could be true even when it is specified to be false in 'disk init' command. This happens when a device with dsync=true property is dropped followed by addition of a new device with dsync=false using "disk init".

CR:322006

CR Number:   322006 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2003 Fixed Description Add new definitions for new rows added to master.dbo.sysattributes describing policies of expansion for segments and devices. These rows are inserted and used by sp_dbextend family of procedures that are provided as part of installdbextend script to support automatic database expansion.

CR:322022

CR Number:   322022 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2003 Fixed Description The segments size is stored correctly in a 16K server using isql to check. But, Sybase Central tool displays wrong database segments size.

CR:322026

CR Number:   322026 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2004 Fixed Description New Feature Request for "dictionary, case-insensitive sort order" to be supported by the cp1252 charset.

CR:322031

CR Number:   322031 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2003 Not a Bug Description ASE12.5.0.3, sa_role for login behavior changes: now only sso_role have permissions to play with the logins; sa_role has no permission to sp_locklogin/sp_addlogin/sp_droplogin login.

CR:322069

CR Number:   322069 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2004 Fixed 19 Apr 2004 One-off Provided Description When the target database contains a very large number of tables/indexes, checkstorage may produce a timeslice whose stacktrace contains the function 'pchk_pt_sched_objs'. Increasing the 'cpu grace time' parameter may alleviate this problem. Workaround Description  - Increase the cpu grace time and/or timeslice parameters. Unfortunately, these are static config options and affect all processes running on the ASE. - Use checkdb as an alternative.

CR:322080

CR Number:   322080 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2004 Fixed 11 Feb 2004 Fixed 29 Feb 2004 One-off Provided 29 Mar 2004 Fixed Description ASE on Linux systems supporting KAIO (RedHat AS2.1, AS3.0) may encounter timeslice errors under heavy i/o load on block device or file-system based device. This is followed by the message in the errorlog similar to "timeslice -1501, current process infected" together with a stack trace which includes the modules 'rt__daiostart', 'basis_daiostart' and 'basis_dstart'. Workaround Description  Use trace flag 1630 that enable POSIX async i/o or disable the option 'allow sql server async i/o'.

CR:322084

CR Number:   322084 Product Name:   Adaptive Server Enterprise Product Component:   buildmaster Status:   Closed OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2003 Fixed Description Running the installmaster script may fail with error 247 when there's an user id in SYSUSERS with a value greater than 32768. Workaround Description  declare @rid as int rather than smallint

CR:322095

CR Number:   322095 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2005 Fixed Description Enhance dump command so regular dumps can overwrite compressed dumps the same as if they were non-compressed dumps.

CR:322138

CR Number:   322138 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2003 Fixed Description Document changes to reflect the sa_role behavioral change for logins after CR 280196 fix.

CR:322218

CR Number:   322218 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2003 Fixed Description If the reconfiguration of the 'number of open databases' fails with error 5861, then despite increasing the 'max memory' configuration parameter to the value suggested by the error message itself, a subsequent attempt to reconfigure the 'number of open databases' may fail again.

CR:322226

CR Number:   322226 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2003 Fixed Description During upgrade to 12.0 or beyond, ASE exposes and initializes a previously hidden column, syskeys.spare1. Rarely, initializing this field may encounter duplicate rows, causing upgrade to fail in the affected database. Workaround Description  Remove duplicate syskey from the database prior to upgrading.

CR:322328

CR Number:   322328 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Insufficient priority to fix Description Add an option to disable the update trigger only if it is called by the insert trigger.

CR:322329

CR Number:   322329 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2003 Fixed 05 Sep 2003 Presently Not Targeted For Any Future Release Of This Product 19 Apr 2005 Fixed 13 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date Description Certain queries involving a join between tables on columns with different datatypes and using subqueries could perform slower than expected in some scenarios because the subqueries are executed for all rows instead for only the ones that match the join condition.

CR:322335

CR Number:   322335 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2003 Fixed 20 Jun 2003 Fixed 19 Jun 2003 Fixed Description Attempts to drop a locked account using sp_droplogin will fail. Workaround Description  unlock any locked logins before dropping them

CR:322368

CR Number:   322368 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2004 Fixed 07 Apr 2004 Fixed Description In rare circumstances, the message "current process infected with 11" in the module "memcpy" together with a stack trace that includes the modules "bt__build_add_nonleaf_duplicate", "bt__sim_merge_pages" and "bt__sim_update_tree", may be reported during the parallel creation of an index on a Data Only Locked table and there are very few unique key values in the table. Workaround Description  Turn off the "select into" dp_dboption for the duration of the command that is doing parallel sort (eg CREATE INDEX or ALTER TABLE ... LOCK).

CR:322369

CR Number:   322369 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2003 Fixed Description servermayhangwheninstallingscript'installhasvss'morethanonce. Workaround Description  Added by Sekher Seshadri-PSE,Sydney Prior to issuing dbcc ha_admin to halt state machine, running installhasvss script, just issue a select * from rmt_ha_sysconfigures or any other rmt_ha_* table. Then halt the state machine, run installhasvss - it wou

CR:322370

CR Number:   322370 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2004 Fixed Description Customer wants a "warning message" in the 302 output when the optimizer is not condsidering a "join" becuase of a datatype mismatch. As of today the 302 output will show 2 blocks of output for each join if the datatypes are compatible and if the datatypes are incompatible it will show just a single block. From documentation (Performance and Tuning Guide): Troubleshooting Datatype Mismatch Problems for Joins If you suspect that an index is not being considered on one side of a join due to datatype mismatches, use dbcc traceon(302). In the output, look for the "Selecting best index for the JOIN CLAUSE". If datatypes are compatible, you see two of these blocks for each join; for example: Selecting best index for the JOIN CLAUSE: t1.int_col = t2.int_col And later in the output for the other table in the join: Selecting best index for the JOIN CLAUSE: t2.int_col = t1.int_col For a query that compares incompatible datatypes, for example, comparing a decimal column to an int, column, there is only the single block: Selecting best index for the JOIN CLAUSE: t1.decimal_col = t2.int_col This means that the join costing for using an index with t2.int_col as the outer column is not performed

CR:322504

CR Number:   322504 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2004 Fixed Description Add a column the sp_shmdumpconfig stored procedure output to indicate the number of dumps already performed for each shared memory dump condition. Workaround Description  Use the undocumented sp_shmdumpconfig parameter 'debug'. This parameter causes sp_shmdumpconfig to print the contents of its in-memory data structures, including the number of dumps performed for each dump condition. Traceflag 3604 must be turned on

CR:322517

CR Number:   322517 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2004 Fixed Description The sp_shmdumpconfig reset command generates error message 18517 when it completes successfully.

CR:322536

CR Number:   322536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2003 Fixed 26 Jun 2003 Fixed 26 Jun 2003 Presently Not Targeted For Any Future Release Of This Product Description ASE 12.5.0.3 ESD#1 on Windows platform reports 'KERNEL structure not padded correctly - size = 7256' during startup. The improper padding will not cause any problems to the correct operation of ASE, though it could degrade performance. Workaround Description  None required

CR:322568

CR Number:   322568 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2004 Fixed Description When using CIS and having active CIS connections the values in sp_monitorconfig "max cis remote connections" output are not increasing and stay zero.

CR:322575

CR Number:   322575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2005 Insufficient priority to fix Description System table sysdevices should store the type of the device like raw partition or file system etc.

CR:322816

CR Number:   322816 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jul 2004 Fixed 20 Jul 2004 Fixed Description The data and index phases of a migration are slower when allowed to run simultaneously Workaround Description  Seperate data and index migration process.

CR:322947

CR Number:   322947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2003 Fixed 01 Sep 2003 Fixed Description In rare circumstances, a 605 error "An attempt was made to fetch logical page '<value>' in database.... Page belongs to object with id '<value>', not to object '<value>'", a 69* error or an 806 error may be reported when a duplicate index key is inserted into a table having both a non unique clustered index and some overflow pages. This is a run-time error and the table is not corrupted since DBCC CHECKTABLE does not report any error.