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

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

CR:293830

CR Number:   293830 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2003 Fixed 03 Jan 2003 Fixed Description Sybase Central ASE Plug-in starting from voyager(12.5.1) will support Disk Resize functionality of ASE. Users with 'sa' role can increase the size of Database Devices in a ASE, whose version is greater than or equal to 12.5.0.1.

CR:293896

CR Number:   293896 Product Name:   ASE Replicator Product Component:   Utilities Status:   Closed OS:   Generic Original Version:   12.5.0.105P2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.0.0 06 May 2003 Fixed 12.5.0.106P3 20 Sep 2002 Fixed Description ASE Replicator: When all connection attempts fail, ASE Replicator logs a message that contains the connection properties. Some of those values were displayed as 'null' even though the values were correctly set. Now, all configured values are correctly displayed. Also, these connection properties are now logged as part of regular ASE Replicator startup.

CR:293936

CR Number:   293936 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2003 Fixed 12 Aug 2009 Insufficient priority to fix Description The Interfaces file parser in the past had lots of problems in parsing/decoding the various entries from interfaces file, especially entries of non-tli styles. Also there were few problems, when the entries in the interfaces had preceding/following white spaces/comment characters.

CR:293946

CR Number:   293946 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Dec 2002 Not a Bug 22 Oct 2002 Fixed 30 Dec 2002 Fixed Description Using sybmigrate or SELECT...INTO EXISTING TABLE to move data from an iso_1 server to a utf8 server resulted in 11216 and 4847 errors. A temporary workaround has been implemented using trace flag 11224 until the real problem (CR 276619) is resolved.

CR:293974

CR Number:   293974 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) 09 Oct 2002 Fixed 02 Oct 2002 Fixed 08 Oct 2002 Fixed 10 Oct 2002 Fixed 11 Oct 2002 Fixed 11 Oct 2002 Fixed Description Sub-optimal performance may occur when executing a query that contains two or more subqueries which are executed at the same "nesting level" (as reported by SHOWPLAN output) as a result of not executing the subqueries in the order that they are specified in the query. Workaround Description  Since 12x higher we will not rearrange the tree, place the most costly subquery immediately after the predicates.

CR:293983

CR Number:   293983 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) 23 Oct 2002 Fixed 11 Nov 2002 Fixed Description When Adaptive Server is configured with a multi-byte character set, sp_helptext returns erroneous output for a stored procedure that has a multi-byte character in the 255th byte position in its CREATE PROCEDURE statement.

CR:294058

CR Number:   294058 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2002 Fixed 06 Mar 2003 Fixed Description In rare circumstances a 622 error, "Opentable was passed a varno of <value>. Object '<obj_name>' already has that session descriptor in use", may be reported against a view that references a table in another database.

CR:294078

CR Number:   294078 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2004 Fixed 19 Jul 2004 Fixed 22 Oct 2004 Fixed 19 Jan 2006 Fixed Description SQL Preview feature implements in ASE Plugin -- User has the option to display SQL before execution

CR:294079

CR Number:   294079 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2003 Fixed 09 Mar 2004 Deferred Description When a table is selected, a new panel shows the data of the table.

CR:294092

CR Number:   294092 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2003 Fixed 08 Oct 2003 Fixed 27 Aug 2003 Fixed Description srvbuild and srvbuildres fail to detect soft partitions feature of the Solstice DiskSuite. This is a regression of CR 278710. Workaround Description  Use pre EBF10423 srvbuild[res] to build server OR use normal simple metadevices and/or raw disk slices.

CR:294137

CR Number:   294137 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) 19 Sep 2005 Fixed Description Configuring default network packet size greater than 65535 can cause TDS protocol connections.

CR:294143

CR Number:   294143 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2002 Fixed Description extractjava truncates extracted jar files to 32K Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.0.3 release.

CR:294170

CR Number:   294170 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2002 Fixed 12 Mar 2003 Presently Not Targeted For Any Future Release Of This Product Description If user resize a column width, its value is stored. The column width is persisent when column get sorted and after SC is exit and restart.

CR:294181

CR Number:   294181 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2004 Bundled Request Description Request for an sp_configure parameter to control when the password expiration warning starts to be displayed. Currently it starts displaying 75% through the password expiration interval, i.e. for 100 day interval, the warning is displayed from the 75-100th day. Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release. Workaround Description  see main description, workaround is lengthy and wouldn't fit here.

CR:294182

CR Number:   294182 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2002 Fixed Description The creation menu can be accessed by either doing a right-click on the empty area of the details panel on the right hand side (which brings up the pop-up menu containing the 'New' submenu), or selecting 'File'->'New' submenu. For example, when the 'Foreign Keys' folder is selected, the user can select 'New'->'Foreign Key' to invoke the wizard to create a foreign key.

CR:294184

CR Number:   294184 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2002 Fixed 23 Oct 2002 Fixed Description CR 298469 opened for Customer Description

CR:294214

CR Number:   294214 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2002 Fixed 06 Feb 2003 Fixed Description The message "current process infected with 11" together with a stack trace that includes the modules 'pchk_text_page' and 'pchk_all_pages' may be reported by DBCC CHECKSTORAGE or DBCC CHECKVERIFY when using the 7109 trace flag to implement the pre-12.0 TEXT strategy (originally done under CR 237929).

CR:294246

CR Number:   294246 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2002 Duplicate Description Feature request for builtin functions bintohex and hexto bin, similar to hextoint and inttohex, that could convert hexidecimal char or varchar strings to binary or varbinary datatypes and vice versa. Currently isql will automatically display a binary value as a string, but there is no easy way to do a similar conversion within TSQL. Workaround Description  See main description.

CR:294286

CR Number:   294286 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2002 Fixed Description strtobin() built in function should ignore leading 0x in string, now strtobin("0x12ab") will return 0x12ab instead of null.

CR:294340

CR Number:   294340 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   12.5.0.1 Intl Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2002 Fixed Description Backup server under Linux didn't support long lseek operations when dumping database devices larger the 2GB under linux.

CR:294350

CR Number:   294350 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2002 Bundled Request 13 Sep 2002 Fixed 17 Aug 2003 Bundled Request Description On NT systems, native (OLE) MSDTC distributed transactions hang when a request is made to prepare, commit or rollback the transaction. Workaround Description  None.

CR:294393

CR Number:   294393 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2002 Fixed Description After the DDL object migrated to target ASE, the SQL text for the migrated object store in syscomments contain one extra line.

CR:294479

CR Number:   294479 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   AIX 5.1 Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2004 Fixed 04 Aug 2004 Bundled Request Description Migration tool should have an option to keep transfered data when rowcounts are different. Workaround Description  A new MT trace flag will be created for this called LEAVE_TBL_DATA_ON_ERROR this will prevent the table from being truncated if there is an error or the row count is different. The trace flag LEAVE_PTBL_ON_ERROR can also be used to prevent the proxy table from being dropped.

CR:294484

CR Number:   294484 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) 04 Oct 2002 Fixed 31 Oct 2002 Fixed Description Adding a column with a DEFAULT using the ALTER TABLE statement can sometimes cause the text of the DEFAULT constraint to be saved incorrectly in syscomments. Workaround Description  Use create rule / bin rule mechanism. This is more work but text of default is saved correctly.

CR:294485

CR Number:   294485 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2004 Fixed 02 Aug 2004 Fixed Description DDLGen cannot generate DDL for all indexes in a database.

CR:294489

CR Number:   294489 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2003 Fixed Description DDLGen will print an error message for all errors, which will consist of an error number and an error message. This will be followed by exception stack trace.

CR:294490

CR Number:   294490 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2003 Fixed 12.5.1 29 Jul 2003 Fixed Description A new command line argument -L (which takes the progress log output file name) has been added to the DDLGen. The progress of the DDLGen will be logged to this file.

CR:294492

CR Number:   294492 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) 23 Oct 2002 Fixed Description The total used and total unused page count may not always be recalculated as expected after 7940/7949 errors were corrected by the DBCC TABLEALLOC command run with the FIX option.

CR:294501

CR Number:   294501 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2002 Fixed 20 Dec 2002 Fixed 03 Feb 2003 Fixed Description On a multi-engine server, a timeslice error may be reported in the error log together with a stack trace that includes the module 'cm_grabmem_lru' if many sessions are executing parallel SELECT INTO commands concurrently or otherwise changing the schema of tables. Workaround Description  Trace flag 5303 may help this situation. 5303 - select into temporary table will be executed without the table being sliced.

CR:294513

CR Number:   294513 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2002 Fixed 15 Nov 2002 Fixed 29 Jan 2003 Fixed Description A 567 error is erroneously reported when a user with "sso_role" attempts to use sp_modifylogin to modify the attributes of a login.

CR:294583

CR Number:   294583 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Linux Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2003 Fixed Description On the Linux platform, the Full-Text Search server does not completely shutdown aftering sp_shutdown has been issued.

CR:294595

CR Number:   294595 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2006 Fixed 16 Sep 2010 One-off Provided 31 Aug 2012 Fixed Description ASE does not respect the -d <master_device_name> and -r <master_mirror_name> names provided on the command line. Instead, it uses its own internally stored names.

CR:294626

CR Number:   294626 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 Sep 2002 Fixed 08 Oct 2002 Fixed 08 Nov 2002 Fixed 22 Oct 2002 Fixed Description GUID generator builtin newid() is implemented in this release. The newid() builtin takes optional argument 0 or 1 which will generate GUID with no dashes or with dashes. The GUID generated is of type VARCHAR. The length of the GUID is 32 bytes for no dashes option and 36 bytes for newid() with option of 1 or any number greater than that

CR:294687

CR Number:   294687 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2003 Fixed Description an "insert into <proxy table> select from <local table>" statement may fail with error "206, Operandtypeclash"

CR:294809

CR Number:   294809 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   11.9.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2003 Fixed Description Add a new character set mac_euro to support the EURO symbol in 'mac' character set.

CR:294833

CR Number:   294833 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2009 Insufficient priority to fix Description sp_rename does not update the CREATE <objecttype> <name> line in the source code stored in syscomments. Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 15.0 release.

CR:294874

CR Number:   294874 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2002 Duplicate Description Because of design issues within the current Linux Native thread run-time design Linux/ASE must be booted with traceflag 1639 (-T1639). Enabling this flag will masquarade problems which may lead to timeslice errors when high i/o load is going under the (RT) Posix Async disk I/O subsystem. This run-time problem is likely to be fixed when Linux is released with the nptl (New Posix Thread Library) expected to arrive summer 2003.

CR:294926

CR Number:   294926 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) 27 Sep 2002 Fixed Description A 233 error, "The column in table <table name> does not allow null values." will be reported, when a stored procedure creates a table using SELECT INTO with the options IDENTITY_INSERT, EXTERNAL FILE, EXTERNAL TABLE or COLUMN DELIMITER and we try to insert into that table inside the same stored procedure.

CR:294977

CR Number:   294977 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2004 Fixed 17 Jan 2005 Fixed 01 Mar 2006 Fixed 26 Jan 2005 Fixed 01 Feb 2005 Not a Bug Description Feature request for function to return a true/false indication of whether dump tran is allowed (i.e. would be false if minimally-logged operations or dump tran with truncate_only had been executed since the most recent dump database). Reviewed Nov 2002. Pending further research in engineering. Workaround Description  determine the appropriate bits in the dbinfo structure and interpret them.

CR:295033

CR Number:   295033 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2009 Duplicate 20 Mar 2009 Duplicate Description Enhancement request to improve datetime datatype to have full millisecond (or greater) precision (currently granularity is 1/300th of a second rather than 1/1000th) Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

CR:295034

CR Number:   295034 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   IRIX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2005 Presently Not Targeted For Any Future Release Of This Product Description On SGI platform, Adaptive Server may core dump during shutdown occasionally.

CR:295074

CR Number:   295074 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2003 Fixed 15 Apr 2003 Fixed Description If DBCC CHECKSTORAGE crashes, failure to cleanup its resources may cause other processes to hang. Workaround Description  Once the process is blocked in bufpredirty, ASE must be restarted. Action must be taken to prevent the problem leading to this situation (e.g. rebuild text pages if checkstorage hits a problem in pchk_stnode).

CR:295076

CR Number:   295076 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) 16 Dec 2002 Fixed 03 Mar 2003 Fixed Description An equality SELECT FROM the sysprocesses table on either 'clientname', 'clientapplname' or 'clienthostname' will incorrectly return no results. Workaround Description  use 'rtrim' or like clause

CR:295092

CR Number:   295092 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2002 Fixed 05 Feb 2003 Fixed Description The message "current process infected with 11" in the module 'ap__dt_plan' together with a stack trace that includes the modules 'ap_print' and 's_ap_capture' may be reported in the error log when a plan is generated using SET PLAN DUMP ON for an "INSERT <table> SELECT" query that does not have a FROM clause and <table> has a referential constraint. Workaround Description  Disable abstract plan dumps.

CR:295104

CR Number:   295104 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2003 Fixed Description Addition of a new builtin function, audit_event_name(), which given an audit event number, returns the associated description of the event.

CR:295143

CR Number:   295143 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2002 Fixed Description In rare circumstances, a 2626 error or message "current process infected with 11 or 10" together with the module memmove(),run__fix_collen(),do__groups() or run(), may be reported in the errorlog when processing a query that contains many aggregate functions needing multiple worktables.

CR:295151

CR Number:   295151 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2002 Fixed 01 Mar 2006 Insufficient priority to fix Description dbcc memusage reports wrong unused memory

CR:295166

CR Number:   295166 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2003 Fixed 13 May 2003 Fixed 12 May 2003 Fixed Description Improved error handling for the audit process when the 'auditing' configuration parameter is enabled.

CR:295167

CR Number:   295167 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) 22 Nov 2002 Fixed Description Trying to force a dormant engine to shutdown using the dbcc engine('shutdown', <n>) command fails with the message 'engine <n> is not online'

CR:295262

CR Number:   295262 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2004 Presently Not Targeted For Any Future Release Of This Product 21 Dec 2004 Fixed 24 Feb 2006 Fixed 25 Mar 2007 Fixed Description Enhance login triggers so they can set persistant SET option values for the connection. Currently, any SET options set in the login trigger are limited to the scope of the login trigger itself. By starting the server with trace flag 4073 the scope will be the process that just logged in.

CR:295273

CR Number:   295273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2002 Fixed 12 Nov 2002 Fixed Description In rare circumstances, a query using a 'GROUP BY' may get a signal 11, the stack trace in the error log will show modules 'do__groups', 'add_ind_level' and 'memfreeheap'. Workaround Description  To reduce the column number from GROUP BY clause.

CR:295275

CR Number:   295275 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2002 Fixed Description Concatenation of unichar with character or binary datatypes can result in incorrect results.

CR:295284

CR Number:   295284 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) 08 Apr 2003 Fixed 25 Sep 2003 Fixed Description New attribute is added for sp_chgattribute to support user to set identity max values. The syntax will be: sp_chgattribute tab_name, "identity_burn_max", 0, new_identity_val

CR:295290

CR Number:   295290 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) 20 Sep 2002 Fixed 07 Jan 2004 Fixed Description 692 error may be raised when an exception happened during alter partition operation. The table cannot be dropped unless the server is recycled.

CR:295429

CR Number:   295429 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2003 Fixed 16 Jun 2003 Fixed Description Under some circumstances, the index of a table is marked as "suspect" after loading a database that was dumped on a 12.0.x server, into a 12.5.x server. Msg 3121 may be falsely raised at load database time: "Index <tabname.indname>(objid=<objid>, indid=<indid>) may be invalid. It uses CHAR or VARCHAR columns in its key and was created under a different sort order ID (0) or charset ID (0) than the ones on this server (SortOrd=<sortord id>, CharSet=<charset id>)", even though the index does not have any CHAR or VARCHAR columns and the sortorder/charset id has not changed between the dump and load. Workaround Description  drop and recreate index

CR:295435

CR Number:   295435 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) 26 Sep 2002 Fixed 26 Dec 2003 Fixed Description Recursive resource governor exceptions that result in an action of task termination could lead to phantom processes.

CR:295473

CR Number:   295473 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) 10 Oct 2002 Fixed Description When using JCONNECT_VERSION 6 and server's default character set is UTF-8, the '=' operator in prepared statements behaves as 'like' clause. Workaround Description  No workaround for customer who needs JCONNECT_VERSION for wide table and utf8 support.

CR:295567

CR Number:   295567 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) 23 Oct 2002 Fixed Description When executing a SQL statement like SELECT @variable1 = <column> FROM <table> WHERE <column> LIKE @variable1, the index on the <column> is sometimes not used. Workaround Description  use traceflag 7703 or use force index in the query. (traceflag 7703 will disable fix for CR 210688, which may lead to incorrect result)

CR:295645

CR Number:   295645 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) 03 Apr 2006 Fixed 03 Apr 2006 Reservation Made Description Added two new builtins. isdatetime() determines whether an input expression is a valid datetime value. isnumeric() determines whether an expression is a valid numeric type.

CR:295658

CR Number:   295658 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2002 Fixed Description Spurious 2503 errors on syslogs can occur in DBCC CHECKDB if DUMP TRANSACTION happens to run concurrently. These errors are greatly reduced, but in theory not totally eliminated, by the fix to this CR. Workaround Description  Try to run DBCC CHECKDB on a quiet system, and/or just after DUMP TRANSACTION.

CR:295668

CR Number:   295668 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2002 Fixed Description In rare circumstances a 2206 error, "Database <proxy_name> with dbid <dbid> is already shut down" may be reported together with a stack trace that includes the modules 'dbt_get', 'pfts_append' and 'bufgrab' soon after HA failover. Workaround Description  Turn off PFTS at run time (for _all_ databases) by booting the server with the 3444 trace flag.

CR:295719

CR Number:   295719 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2002 Fixed 08 Oct 2002 Fixed Description An UPDATE command involving an all pages-locked table with a safe clustered index (the index keys are not being updated), may be incorrectly executed in deferred mode rather than direct mode, resulting in poor performance.

CR:295743

CR Number:   295743 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2002 Fixed Description When the Abstract Plan dump mode is active, then some UNION queries may fail with a stack trace reported in the error log showing modules 'apg__work_tab' 'apg__setop', and 's_compile'.

CR:295803

CR Number:   295803 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2005 Fixed 04 Jul 2005 Fixed 16 Nov 2005 Fixed 03 Mar 2006 Fixed 09 Jan 2006 Fixed 05 Jan 2006 Reservation Made 09 Jan 2006 Fixed 23 Dec 2009 Presently Not Targeted For Any Future Release Of This Product Description Feature request for an sp_configure option, something like sp_configure "disallow non-sa logins before recovery complete" [default off] that would prevent any users other than users with sa_role from logging in to the server before recovery of user databases is complete (i.e. logins would be allowed starting either just before or just after all engines are brought online). This description is under revision. In 15.0 GA and 15.0 ESD#1, sp_modifylogin NULL, "enable logins during recovery", "0"/"1" needs to be used. As of 15.0 ESD#2 onwards, the sp_configure "enable logins during recovery" option needs to be used. Workaround Description  In ASE 12.5, login triggers can be used to accomplish this. To do this, you would need to examine the status field in sysdatabases and/or count the entries in sysengines to determine if the boot phase was over.

CR:295881

CR Number:   295881 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) 18 Feb 2004 Fixed 18 Oct 2006 Fixed Description 1. An empty spinlock contention scenario in the Data Cache Management section is addressed. 2. The sp_sysmon "Task Management" section has been updated with a more detailed recommendation for the I/O Pacing section.

CR:295908

CR Number:   295908 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2002 Fixed Description a SELECT INTO EXISTING TABLE in a stored procedure or in a trigger may return an empty error message.

CR:295971

CR Number:   295971 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2002 Fixed Description On Windows platforms, an engine offline operation may continually report that it is waiting for affinitied processes, when in fact the processes in question are simply idle

CR:296011

CR Number:   296011 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2002 Fixed Description When "alter table add/modify column" is used in a stored procedure, a signal 11 may happen in routine memfree() if the session is interrupted or raises an error. Sometimes a memory mismatch warning may be seen in the errorlog.

CR:296064

CR Number:   296064 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2002 Fixed 07 Feb 2003 Fixed Description In some cases, a sub-optimal plan that uses a covering index may be chosen by the optimizer for a query that has an OR clause because this appears to be the cheapest access path. In reality, taking account of concurrency may generate a better plan than simply choosing the cheapest. This fix extends concurrency optimization to enable the optimizer to make a better judgement. Workaround Description  Force OR strategy.

CR:296108

CR Number:   296108 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2005 Duplicate Description Feature request to have the deadlock information printed by the sp_configure PRINT DEADLOCK INFORMATION option included the index ids of the pages involved.

CR:296194

CR Number:   296194 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2003 Fixed Description Two new nopref sortorders are added for cp1251: cyrnocsnopref.srt and rusnocsnopref.srt. Workaround Description  If appropriate, the sort file can be amended to state the preference value by adding the line: preference = [true|false] Reload the sort order and configure the ASE to use this newly loaded sort order. Note that if the sort order is currently in us

CR:296292

CR Number:   296292 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 Oct 2002 Fixed Description In an High Availibility asymmetric configuration, if indices are bound to named caches, the failover operation may get aborted with the message "current process infected with 11" in the module 'buf__elcsearch'. Workaround Description  do not sp_bindcache table/index to "default data cache" smeriot (10/01/2002) -------------------- Another workaround is to disable the 'Engine Local Cache' feature by running dbcc tune(elc, 0) after each server reboot.

CR:296308

CR Number:   296308 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement request: When updating a text/image column through a view using ct_send_data, update permissions are not inherited from the view because the IO descriptor returned by the ASE references the underlying table and not the view. Target Version  15.0 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0 release. Workaround Description  Grant update permissions on the underlying table that the view accesses.

CR:296370

CR Number:   296370 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2002 Fixed 13 Jun 2001 DEFER 18 Feb 2003 Fixed Description The command SELECT EXP(<large negative value>) returns NULL (arithmetic overflow) instead of 0.000000.

CR:296375

CR Number:   296375 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2011 Presently Not Targeted For Any Future Release Of This Product Description Enhance CREATE DATABASE and ALTER DATABASE to allow granularity of 1/2 MB in size. Currently, these commands will only allow allocation in whole MB increments, except that if there is not enough space on the device, ASE will allocate as much as is available to the nearest 1/2 mb - resulting in a fragment that cannot be easily recreated. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release. Workaround Description  Create the database normally up to the fragment with the .5 size. Alter the database to the next full mb in size - i.e. if fragment was 203.5 MB, alter to 204mb. Then manually update the value of sysusages.size for that row, subtracting 256 pages (0.5mb). Reboot ASE to refresh the dbtable with this new size. Continue altering the database. Repeat as necessary.

CR:296381

CR Number:   296381 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2002 Fixed Description If a CREATE CLUSTERED INDEX is run on a partitioned table while a DUMP DATABASE is running concurrently on the database, then, upon trying to load the dump, 605 or 692 errors may be seen. The stack trace may contain modules 'wrongpage' and 'getpage_with_validation'.

CR:296395

CR Number:   296395 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) 30 Nov 2009 DEFER Description Request for method to get full text of last error raised. @@error provides the error number, and the template for the error message can be found in sysmessages, but the parameters (database and table names, ids, page numbers, etc) that are included in the actual message are inaccessible from within TSQL. Request is for a new session-level global variable @@errormessage, which would return a VARCHAR containing the full text of the most recently raised error - in synch with @@error. Target Version  15.0 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0 release.

CR:296437

CR Number:   296437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.2 04 Oct 2002 Fixed 08 Oct 2002 Fixed Description License key and user docs use license option 'ASE_DIRS' for LDAP and other directory services. However, ASE only recognized 'ASE_DIR' which made license key for 'ASE_DIRS' unusable. This fix makes ASE recognize 'ASE_DIRS'.

CR:296477

CR Number:   296477 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2002 Fixed 09 Dec 2002 Fixed 09 Dec 2002 Fixed Description CIS: When a transaction that involves a proxy table is chosen as a deadlock victim on the remote server, the corresponding local process incorrectly continues to process the remaining statements in the batch. Workaround Description  none

CR:296577

CR Number:   296577 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2005 Not reproducible with latest version of the product available as of Resolution Date Description In some cases select * from syslisteners provides correct results followed by several lines of garbage or an infinate amount of blank lines of output. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release. Workaround Description  In 12.5.1, the customer can simply issue the following command in order to see the state of all listeners on the server: sp_listener status

CR:296629

CR Number:   296629 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2002 Fixed 12 Nov 2002 Fixed Description Backupserver may core dump with floating point exception during a dump or load if the product (allocated space * pagesize) exceeds 4gig. Target Version  12.5.0.3 Review Status  Reviewed March 2003. CR is fixed in the ASE 12.5.0.3 IR release. Workaround Description  No work-around exists..

CR:296659

CR Number:   296659 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow option to run update index statistics in parallel Target Version  15.0 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0 release.

CR:296689

CR Number:   296689 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2002 Bundled Request Description Feature request to allow xp_cmdshell to accept parameters wider than 255 bytes.

CR:296724

CR Number:   296724 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   IRIX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2003 Duplicate Description sp_configure parameter "executable code size" reports an incorrect, excessively large value. Target Version  12.5.0.3 Review Status  Reviewed March 2003. CR is fixed in the 12.5.0.3 release.

CR:296768

CR Number:   296768 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) 10/01 11 Nov 2002 Fixed Description CIS: A 605 error may be reported together with a stack trace which includes the modules 'wrongpage', 'getpage_with_validation' and 'gettxtpage' when a "SELECT * INTO" a local table from a proxy table with remote procedure at a remote server is executed.

CR:296781

CR Number:   296781 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) 26 Nov 2003 Fixed Description Incorrect result, 403 error, 678 error, or assertion error in sqx__mvranges() may be returned, or process may be infected with signal 11 in oj_contig_bm(), when query has a subquery against UNION VIEW.

CR:296794

CR Number:   296794 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) 16 Oct 2002 Fixed Description memory used value is not correctly calculated for 'size of process object heap'

CR:296796

CR Number:   296796 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) 15 Oct 2002 Fixed Description The "Memory Used" column may not always be correctly calculated and displayed by the sp_configure command.

CR:296817

CR Number:   296817 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   IRIX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2003 Duplicate Description For consistency all the config parameter that have a value in the memory used column of sp_configure should be displayed in KB. Target Version  12.5.0.3 Review Status  Reviewed March 2003. This CR is a duplicate of CR 296796, fixed in the ASE 12.5.0.3 IR.

CR:296847

CR Number:   296847 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) 10/01 23 Oct 2002 Fixed Description Selecting from a proxy table mapped to an RPC results in error 201 is set quoted_identifier is turned on.

CR:296855

CR Number:   296855 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2004 Fixed Description Increase the maximum number of SARGS the optimizer can handle from 128 to 585 on 32 bit platforms and 512 on 64 bit platforms. Target Version  Galaxy Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0 release.

CR:296898

CR Number:   296898 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2002 Fixed 11 Feb 2003 Fixed Description A query that has an OR condition and a LIKE clause that does a comparison with a pattern with a leading wildcard character may not benefit from some OR optimization strategies with the result that execution of the query will be sub-optimal. Target Version  12.0.0.7 Review Status  Reviewed March 2003. CR is fixed in the 12.0.0.7 IR, released in early March 2003.

CR:296927

CR Number:   296927 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2003 Fixed 17 Aug 2003 Not a Bug Description CIS: Queries which contain dates in OR predicates may cause ORA-01858 error when run against DirectConnect for Oracle 12.0. Workaround Description  Change 'like upper('BP%')' to 'like 'BP%'

CR:297001

CR Number:   297001 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) 17 Oct 2002 Fixed Description In rare circumstances the DUMP DATABASE command may timeslice with a stack trace reported in the error log showing modules 'dpdb_main', 'des_checkpoint' and 'des__systs_flushall'. Alternatively the UPDATE STATISTICS command may timeslice with modules 'ups_main', 'ind_ides_init' and 'ind__ides_install' being reported. Workaround Description  N/A

CR:297073

CR Number:   297073 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) 19 Dec 2006 Fixed 12 Dec 2006 Reservation Made 14 Dec 2006 Bundled Request Description Feature request for a way to manually set/update a timestamp value (more or less according the way <identity insert> is implemented. This would be used in warm-standby replication environments, where transactions are forwarded by RepServer as SQL-statements. Due to the current implementation of timestamp, this will lead to differences in the timestamp values between the primary side and the secondary.

CR:297135

CR Number:   297135 Product Name:   ASE Replicator Product Component:   Doc Status:   Closed OS:   Generic Original Version:   12.5.0.103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2010 Not a Bug 16 Jun 2010 EOL'd version. Not to be Fixed. Description Customer would like more detail on how to to re-establish replication if they lose the primary, replicate or DDB database. This would include recommendations for backups. Customer would also like complete instructions on how to recover replication (including locater reset commands, dbcc's ect...) in the event that the customer had to recover (restore) any of the involved databases from backups.

CR:297184

CR Number:   297184 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2002 Fixed 24 Oct 2002 Fixed Description CIS : A 1763 error "Cannot insert rows into sysstatistics, due to multiple equal frequency values..." may be reported when executing UPDATE STATISTICS on a proxy table that has index columns with NULL value rows.

CR:297222

CR Number:   297222 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2003 Fixed Description Creating tables within stored procedures can lead to object resolution problems yielding unexpected 267 errors Target Version  12.5.0.3 Review Status  Reviewed March 2003. CR is targeted (but not committed) to an upcoming 12.5.0.3 ESD.

CR:297230

CR Number:   297230 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2003 Fixed 10 Jan 2003 Fixed 08 Jan 2003 Fixed 20 Dec 2002 Fixed 14 Dec 2002 Fixed Description In some cases, pre-TDS 5 clients may hang during login with the errors "noobhandler: recv of OOB byte returned -1 errno 22" or "noobhandler: recv of OOB byte returned -1 errno 4" reported in the error log, leaving the corresponding Adaptive Server sessions unable to be killed. Target Version  12.0.0.7 Review Status  Reviewed March 2003. CR is fixed in ASE 12.0.0.7 IR and will also be fixed in 12.5.1.

CR:297281

CR Number:   297281 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) 25 Oct 2002 Fixed Description Performance enhancements made to SELECT INTO by using large I/O and extent allocation for the target table, when possible. As a result, SELECT INTO may choose the largest I/O size possible for the target table, based on the size of the buffer pools available in the target database cache.