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

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

CR:315756

CR Number:   315756 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 May 2003 Fixed 25 Jul 2003 Fixed Description DBCC CHECKSTORAGE may report a 100016 fault (page allocated but not linked) after a parallel sort is used to create a placement index on an unpartitioned table. Workaround Description  Ensure that the CREATE INDEX is done in serial mode.

CR:315857

CR Number:   315857 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2004 Fixed 16 Mar 2004 Fixed 27 Jul 2004 Fixed Description CIS : Server Error Message 30291 may be returned by UPDATE STATISTICS of a proxy table if the proxy column on which statistics is gathered has been renamed via sp_rename. Workaround Description  Don't rename the proxy_table column via sp_rename.

CR:315897

CR Number:   315897 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) 12.5.1 15 Apr 2003 Fixed Description When server is configured with a multi-byte character set, select object_id(' ') stack traces and the connection is terminated.

CR:315955

CR Number:   315955 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) 07 Jul 2004 Fixed 18 Nov 2003 Fixed 02 Dec 2003 Fixed Description An attempt to read a row from a corrupt page may result in memory corruption as column lengths within a row are misinterpreted. Workaround Description  None.

CR:315966

CR Number:   315966 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 May 2003 Fixed 09 Jun 2003 Fixed Description A 913 error, "Could not find row in sysdatabases with database id ... Run DBCC CHECKTABLE on sysdatabases" followed by a 225 error "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization" may be reported when executing a SQLJ function from a recently loaded database. Workaround Description  Recreate manually SQLJ function/procs in the loaded database from source text.

CR:316088

CR Number:   316088 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.1 16 Apr 2003 Fixed Description Sybase Central C++ Plugin does not generate correct DDL for a table with identity_gap defined. This problem has been fixed in the Java Edition of the ASE Plugin. Customers should install the ASE Plugin and Sybase Central components from the ASE 12.5.0.1 or later releases. The Java Edition of the ASE Plugin can be used to administer ASE 12.0 and later servers. Workaround Description  Use Sybase Central Java Plugin (from ASE 12.5) to generate the DDL

CR:316100

CR Number:   316100 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) 20 May 2003 Fixed 10 Jun 2003 Fixed Description A 7745 error, "Attempting to add a new identity field to a table '<table name>', via select into, which would have a field '<fieldname>' that inherits the identity property.", could be raised during a SELECT INTO. The error is correct but previously created temporary tables are lost. Workaround Description  Ensure SQL is correct and the select..into will not yield an error.

CR:316101

CR Number:   316101 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2003 Fixed 10 Jun 2003 Fixed Description The message "current process infected with 11" in the module 'xls_sessionid' or 'xact_getxactkey' together with a stack trace that includes the module 'sysxacts__fmtrow_from_xdes' may be reported in the error log when selecting from the table systransactions. Workaround Description  None.

CR:316121

CR Number:   316121 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2003 Fixed 15 May 2003 Fixed 14 Jun 2003 Duplicate 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 in 10% chunks.

CR:316146

CR Number:   316146 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) 31 May 2003 Fixed 08 Oct 2003 Fixed 13 Jun 2003 Fixed 11 Jul 2003 Fixed Description This bugfix augment functionality of newid() builtin provided in 12.5.0.3. a) newid(), newid(0) will return GUID as VARCHAR with no dashes b) newid(1) will return GUID as VARCHAR with dashes c) newid(0x0) will return GUID as VARBINARY (any varbinary as argument will return GUID as VARBINARY). d) newid() builtin in select statement or used as default will generate new values for every row that is selected or inserted (in case of defaults)in the statement. TRACEFLAG 395 will disable this behavior. The following example will explain this new behavior. create table T1 (c1 varbinary(16) default newid(0x0), c2 varchar(30) null, constraint pkey primary key (c1)) go insert T1 (c2) select name from sysobjects go --- The above example there will new value generate for every row in sysobjects Workaround Description  The current char(32) value can be converted to a bin(16) using: select convert(binary(16),strtobin(newid()))

CR:316198

CR Number:   316198 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) 23 Apr 2003 Fixed 29 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description Because of a memory leak, queries that send Java objects to non-Java capable clients (such as ISQL) could fail with an java.lang.OutOfMemory Java exception. This exception originates from "java.lang.String.<init>(String.java:244)"

CR:316203

CR Number:   316203 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2003 Fixed 23 Apr 2003 Fixed 23 Apr 2003 Fixed Description Improve DDLGen performance by improving processing of object permissions checks.

CR:316206

CR Number:   316206 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2003 Duplicate Description Feature request to support tape devices for compressed backup feature on Windows platform.

CR:316222

CR Number:   316222 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) 28 May 2003 Fixed 10 Jun 2003 Fixed 10 Jun 2003 Fixed 07 Jan 2004 Fixed Description Changes are added to increase the performance of a temporary table drop. When not in DDL-IN-TRAN mode, the locks held on system catalogs are released before the post commit work itself is done. This is implemented under the 3706 command line trace flag. Workaround Description  N/A

CR:316236

CR Number:   316236 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Fixed 26 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date Description Showplan may report incorrect buffer pool sizes when simulated statistics are used and Adaptive Server's configured page size is greater than 2k.

CR:316247

CR Number:   316247 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2003 Fixed 15 May 2003 Fixed 13 Jun 2003 Fixed Description An XAER_PROTO status may be returned by XA commands like xa_end() or xa_commit(ONE-PHASE) if a resource error (such as an "out of locks" error) occurs during detach processing. Further attempts to attach to the transaction (for example by xa_rollback()) will then fail until Adaptive Server or the Transaction Manager is recycled. Workaround Description  None.

CR:316285

CR Number:   316285 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) 25 Apr 2003 Fixed 27 Jun 2003 Fixed 27 Jun 2003 Fixed Description A 103 error, "The identifier that starts with '<identifier name>' is too long. Maximum length is 30", is sometimes raised when using long variable names.

CR:316300

CR Number:   316300 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2003 Fixed 18 Apr 2003 Fixed 28 Apr 2003 Fixed 23 Apr 2003 Fixed 24 Apr 2003 Fixed Description The DDLGen utility does not interpret object names containing the underscore ('_') or caret ('^') characters correctly.

CR:316426

CR Number:   316426 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2003 Fixed Description When booting the server for the purpose of rewriting the master database, if the user supplies command line arguments -w master, -b, and -f, but NOT -z, the server encounters an arithmetic exception (divide-by-zero). It shuts down without rewriting the master database.

CR:316439

CR Number:   316439 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   macosx Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2003 Fixed Description The backup server definition in the snmpagent.cfg file had a typo (locahost instead of localhost).

CR:316483

CR Number:   316483 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) 14 May 2003 Fixed 02 Jun 2003 Fixed 23 May 2003 Fixed 28 May 2003 Fixed 28 May 2003 Fixed Description In a highly parallel environment, clients to ASE may temporarily encounter a high degree of latency when a large number of clients abnormally disconnect. Workaround Description  The only way to workaround is to avoid the situation where you have many clients simultanously exiting abnormally.

CR:316519

CR Number:   316519 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2003 Fixed 02 Feb 2004 Not a Bug Description User does not need to configure the browser for the HTML help pages. ASEP will do that internally.

CR:316550

CR Number:   316550 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) 25 Apr 2003 Fixed 16 Jun 2003 Fixed Description The message "current process infected with 11" in the module 's__altertab' may be reported in the error log if the command ALTER TABLE ADD CONSTRAINT PRIMARY KEY uses paralelism to create the index, and it fails due to any kind of error.

CR:316587

CR Number:   316587 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) 21 Apr 2003 Fixed Description Remove the recommendation to offline engines from sp_sysmon.

CR:316601

CR Number:   316601 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2003 Not a Bug Description When ANSINULL is on, datatype rules may be violated if the rule allows NULL for the datatype. Workaround Description  If using an ODBC client, in the initialization string add: SET ANSINULL OFF If using a non-ODBC client, use "set ansinull off" command. Write the check constraint like : c2 in (0,1) or c2 IS NULL vs.

CR:316655

CR Number:   316655 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) 29 May 2003 Fixed 20 Jun 2003 Fixed Description Running checkstorage on Linux ASE 12.5.0.x results in numerous sddone errors being reported in the errorlog if the database being checked resides on raw devices/partitions. Problem does not exists for filesystem devices.

CR:316726

CR Number:   316726 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2003 Fixed Description Internal Development: Sanitized Desc. not required.

CR:316744

CR Number:   316744 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 May 2003 Fixed 12.5.1 02 May 2003 Fixed Description ASE 12.5.0.3 CPU utilization may go to 100% when "enable housekeeper GC" is turned on and databases contain old open transactions. Workaround Description  - Disable garbage collection: sp_configure "enable housekeeper GC",0 or - Set "enable housekeeper GC" to 2, 4, or 5

CR:316835

CR Number:   316835 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2003 Third Party Problem Description When ASE is running on some versions of HP-UX, waitfor delay time is incorrect when "sql server clock tick length" is set to 10000. This is due to a bug in HP-UX being investigated by HP-UX PM scheduler team; the bug id is JAGae81924. Workaround Description  Set "sql server clock tick length" to a value between 20000 - 1000000.

CR:316838

CR Number:   316838 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2005 Duplicate Description Request to implement DIRECT IO for ASE filesystem access on Digital Unix

CR:316903

CR Number:   316903 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) 23 Feb 2004 One-off Provided Description INSTRUMENTATION: The server may report a large number of delayed net i/o and eventually hang because of corruption in an internal queue of i/o structures.

CR:316942

CR Number:   316942 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) 04 Jun 2003 Fixed 22 Aug 2003 Fixed Description Allow use of parallel query under Small Business Edition license option.

CR:316975

CR Number:   316975 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) 28 Apr 2003 Fixed Description When "stringsize" is set to a value greater than 255, and a query returns a NULL Java object, the client process hangs, and has to be killed.

CR:317000

CR Number:   317000 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) 01 Dec 2003 Presently Not Targeted For Any Future Release Of This Product Description Feature request to add a mechanism to ensure/check that the local backupserver is indeed on the same box as ASE.

CR:317014

CR Number:   317014 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 13 Nov 2003 Fixed Description AIX Install Guide omits upgrade from version 12.0 Workaround Description  N/A

CR:317098

CR Number:   317098 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) 18 Jun 2006 Fixed Description DATATYPE: User defined datatypes can be mixed up for cross databases SELECT INTO statements with aggregate

CR:317105

CR Number:   317105 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) 25 Apr 2003 Fixed Description The NT sybatch.exe prints the progress tasks to the standard output.

CR:317108

CR Number:   317108 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 May 2003 Fixed 04 Jun 2003 Fixed Description In rare circumstances on a multi-engine server, an undetected deadlock may occur when running 'sp_object_stats' while there are a lot of concurrent table drops. Workaround Description  avoid sp_object_stats

CR:317137

CR Number:   317137 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2003 Fixed Description Internal Development: Sanitized Desc. not required.

CR:317174

CR Number:   317174 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 Nov 2003 Fixed Description When issuing an ALTER TABLE to add 2 or more columns with user defined datatypes that are not null and where no defaults are defined, the sql server may receive a signal 11 and terminate the client process after issuing a 4997 error:"alter table <tabname> failed. Default clause is required in order to add non-NULL column <colname>." The stack trace in the errorlog may include modules scanstypes(), palt__ck_add(), palt__ck_subclauses() and pre_alttab() Workaround Description  Ensure that you have defined a default when using a not null column

CR:317179

CR Number:   317179 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) 25 Nov 2003 Duplicate Description The message "current process infected with 10" in the module 'plc__flush' together with a stack trace which includes the modules xls_preflush, finishlog and xact__endxact may be reported in the error log if in chained transaction mode a transaction is opened in a Java method and rolled back, commited or used outsite this Java method.

CR:317198

CR Number:   317198 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) 12 May 2003 Not a Bug Description Inconsistent results from parallel queries. Workaround Description  Add a "parallel 1" clause to the query or disable parallelism

CR:317238

CR Number:   317238 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) 27 Nov 2003 Fixed 17 Aug 2003 Presently Not Targeted For Any Future Release Of This Product Description Synchronous signals are blocked when signal handler is being called. On some occasions, this can cause ASE to loop if a signal 11 is raised during the execution of the signal handler.

CR:317262

CR Number:   317262 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) 18 Jun 2003 Fixed Description The error 10364 has been modified not to include english hardcoded 'or' clauses.

CR:317296

CR Number:   317296 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2003 Fixed 20 Jun 2003 Fixed Description The message "process infected with 11" in the module 'bufunkeep' may be reported in the error log together with a stack trace that includes the modules 'apl_getnext_level0', 'level0__findrow', level0__getnextrow' and 'level0_restart' during a CURSOR FETCH at isolation level 0 (read uncommited).

CR:317300

CR Number:   317300 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2006 Fixed 07 Jan 2008 Added to user documentation Description The SP_TEMPDB SHOW, DB command will display the list of all user created temporary databases also. The SP_TEMPDB WHO, <DB_name> will also display application name through which Login is associated with the mentioned <DB_name>.

CR:317305

CR Number:   317305 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 Native XML handling capabilities implementation in ASE 12.5.1. This includes support for XPATH subset of XQUERY, support for XML transformation using 'FOR XML', XML mapping and number of other performance improvements.

CR:317310

CR Number:   317310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2003 Fixed 01 Oct 2003 Fixed 29 Aug 2003 Fixed Description A 10330 error, "SELECT permission denied on object <object>, database <database>, owner dbo" may be incorrectly reported when a stored procedure executes a SELECT ... UNION on a table in a different database." Workaround Description  If the proc created and grant does not come from alias, by DB onwer, the query works without error.

CR:317331

CR Number:   317331 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) 23 Sep 2003 Fixed Description ASE will stop accepting subsequent RPC calls (until it is restarted) after one fails with an error 1601 in the errorlog. Workaround Description  Increase the number of user connections.

CR:317405

CR Number:   317405 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2003 Presently Not Targeted For Any Future Release Of This Product 16 Jul 2003 Fixed Description If during a cursor FETCH a severe error such as runtime conversion error (overflow, divide by zero, format error, etc.) OR subquery error like 512 OR a deadlock is hit, then a subsequent cursor FETCH may fail with error 803 resulting in the session being killed with a stack trace reported in the error log showing modules 'curs_fetch' and 'bufkeep'. With this fix, the default behaviour is to end the cursor scan. However, if Adaptive Server is started with the 589 trace flag, then the cursor is implicitly closed instead.

CR:317437

CR Number:   317437 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) 02 Jun 2003 Fixed 28 May 2003 Fixed 13 Jun 2003 Fixed Description Creating a placement index on a large data-only locked table with allow-dup-row option may cause corruption if there are a lot of duplicate keys. DBCC CHECKTABLE may report 9999 or 12905 errors.

CR:317449

CR Number:   317449 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) 22 Aug 2003 Presently Not Targeted For Any Future Release Of This Product 28 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 28 Oct 2003 Fixed Description Null supplied row may not be returned for an outer join query if WHERE clause or ON clause has a predicate with a column from inner table and ISNULL builtin function that has NULL constant or @variable as a 2nd argument of ISNULL builtin.

CR:317553

CR Number:   317553 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) 23 Jun 2003 Fixed Description The commands CREATE INDEX and DROP INDEX are not audited.

CR:317577

CR Number:   317577 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2003 Fixed Description bcpoftextor image data intoproxytablesmapped toDirectConnect for Oraclefailstoinsertdata.

CR:317596

CR Number:   317596 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) 08 May 2003 Fixed 13 May 2003 Fixed Description Checkalloc shows performance regression in 12.5.0.3 due to inefficient large I/Os. sp_monitorconfig does not accurately display the details for the 'number of large i/o buffers' config parameter.

CR:317639

CR Number:   317639 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2009 Presently Not Targeted For Any Future Release Of This Product Description jdebug hangs when attaching to vm.

CR:317648

CR Number:   317648 Product Name:   Adaptive Server Generic Docs Product Component:   Using Sybase Failover In a HA System Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2003 Fixed Description Update "Configure Adaptive Server Failover for Veritas" documentation for version 3.5, it still mentions 1.3.0

CR:317657

CR Number:   317657 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2003 Fixed Description dsedit directory location should be $SYBASE/$SYBASE_OCS/bin instead of $SYBASE/bin in the doc set.

CR:317658

CR Number:   317658 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2003 Not a Bug 02 May 2003 Not a Bug Description User cannot delete or modify the default EJB listener which the EJB Server is listening to.

CR:317659

CR Number:   317659 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) 05 May 2003 Fixed Description When server's default character set is GB18030, the "--" comment style in stored procedures does not work.

CR:317669

CR Number:   317669 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2003 Fixed Description The definition of enabling "allow resource limits" in Sys Admin guide is misleading. Need to include info about showplan on or statistics on as well

CR:317675

CR Number:   317675 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) 23 Jun 2003 Presently Not Targeted For Any Future Release Of This Product Description [Internal Only] Undetected deadlock occurs in some cases in a HA system when failover occurs with databases being recovered in parallel.

CR:317778

CR Number:   317778 Product Name:   SQL Remote for Adaptive Server Enterprise Product Component:   Database Tools Interface Status:   Closed OS:   Microsoft Windows NT Original Version:   7.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.0 1082 05 Jun 2003 Fixed 8.0.3 4679 05 Jun 2003 Fixed 8.0.2 4266 05 Jun 2003 Fixed 8.0.1 3118 05 Jun 2003 Fixed 7.0.4 3461 05 Jun 2003 Fixed Description If an article in a publication was created with a SUBSCRIBE BY clause that selected from a view, and the view was written using "*" as the column list, or if the length of the view exceeded 255 characters, it was possible for ssremote to fail when trying to process operations on the given article with the error "Unable to find subselect clause in view, please make sure your views are formed correctly". This is now fixed.

CR:317910

CR Number:   317910 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   AIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2003 Fixed Description Internal Development: Sanitized Desc. not required.

CR:317912

CR Number:   317912 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2003 Fixed 09 May 2003 Fixed Description CIS: Inserting a date value into Oracle database via DCO12.5 may result in error ORA-01855 in non-US NLS environments. Workaround Description  As a workaround, issue the following command in ASE once the DCO and ASE are started up: > dbcc cis(setcaps, dco_server_name, 121, 1)

CR:317976

CR Number:   317976 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) 03 Nov 2003 Duplicate Description On a multi-engine server, user tasks may terminate with 3702 state 1 and 216 state 3 errors while dropping a temporary table. Workaround Description  No good ones. Newer EBFs can use dbcc orphantables to clean up. See CR 268772.

CR:318018

CR Number:   318018 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) 02 Dec 2005 Not reproducible with latest version of the product available as of Resolution Date Description Executes sp_configure 'allocate max shared memory', 1 Received Msg 5850. All subsequent exections of same command are OK.

CR:318085

CR Number:   318085 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) 08 May 2003 Bundled Request Description Max_used value when executing sp_monitorconfig on "number of large i/o buffers" returns wrong value in 12.5.0.3 as compared to 12.5.0.1

CR:318165

CR Number:   318165 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2003 Fixed 23 May 2003 Fixed 09 Mar 2004 Fixed Description User can access Monitor GUI from Java ASE Plugin. This only works for Windows platform. Go to server properties -> Monitor Server tab. Choose the monitor server name and select Display monitor folder.

CR:318325

CR Number:   318325 Product Name:   Adaptive Server Generic Docs Product Component:   What's New in Adaptive Server? Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2003 Fixed Description The "New Functionality in Adaptive Server Enterprise 12.5.x" under the heading "Using sp_monitorconfig with optional second parameter", has a number of typing mistakes.

CR:318381

CR Number:   318381 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) 14 May 2003 Fixed 20 May 2003 Bundled Request Description DBCC CHECKTABLE on an empty DOL table results in an incorrect empty page count.

CR:318543

CR Number:   318543 Product Name:   Adaptive Server Generic Docs Product Component:   XA Guide for CICS Encina and Tuxedo Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2003 Fixed Description Component Integration Services User's Guide, Adaptive Server Enterprise12.5UNIX and Windows NT, Document ID: 32702-01-1250-01, Last Revised: May 2001 Chapter 2 Understanding Component Integration Services Configuration and tuning Using sp_configure Dynamic reconfiguration CIS dbcc commands dbcc mempools should be dbcc mempool -- remove the (s)

CR:318561

CR Number:   318561 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) 07 May 2003 Fixed 26 Sep 2003 Fixed 12 May 2003 Fixed Description Execution of SQL with lock table as the first statement of a chained transaction gives error message 12104. With this fix, in addition to DELETE, INSERT, OPEN, FETCH, SELECT and UPDATE, LOCKTAB can now be used in chained transaction mode to start a new transaction.

CR:318638

CR Number:   318638 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2003 Fixed Description Ignore the setting of traceflag 289 if proxy tables are involved in the query.

CR:318704

CR Number:   318704 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) 27 Jan 2004 Fixed Description In rare cases, DBCC CHECKALLOC may report a 2546 error on SYSLOGS after Adaptive Server is abnormally shut down and restarted. Workaround Description  Do dbcc checkalloc with "fix" option.

CR:318732

CR Number:   318732 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) 25 Aug 2003 Fixed 10 Aug 2003 Fixed 10 Aug 2003 Fixed 10 Aug 2003 Fixed Description New feature to support automatic database expansion for segments and devices. New install script, installdbextend, provided as part of SYBASE release that provides generic threshold procedures which perform automatic expansion at run-time.

CR:318734

CR Number:   318734 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2003 Fixed 07 Dec 2003 Presently Not Targeted For Any Future Release Of This Product Description On Linux, if a dump is made with the compress option, the dump archive cannot be greater than 2GB. The problem is fixed by providing large file support in the compress module.

CR:318756

CR Number:   318756 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 Jun 2005 Fixed 19 Jul 2006 Fixed 30 Jun 2006 Fixed Description Under certain unusual load conditions, it is possible for 2 or more CPU bound tasks to block other tasks at the same priority for an unacceptably long time

CR:318782

CR Number:   318782 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) 19 May 2003 Fixed 12 May 2003 Fixed 25 May 2003 Fixed Description CIS: Execution of a SELECT statement from a proxy table which was created using the CREATE PROXY_TABLE syntax on a multibyte character set server causes error 208. Workaround Description  Use create existing table command instead. Or use ASE 12.5.0.2 ESD#1.

CR:318820

CR Number:   318820 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Digital UNIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2003 Fixed Description Internal Development: Sanitized Desc. not required.

CR:318890

CR Number:   318890 Product Name:   Adaptive Server Enterprise Product Component:   sqldbgr Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2009 Insufficient info provided Description Feature request to have sqldbgr display more source-code context at breakpoints. Currently, sqldbgr displays just the line of code the breakpoint is on. Request is to have configurable options to display the <x> lines before and <y> lines after the current line being traced. Another alternative would be to have a GUI interface that displayed the entire source for the procedure and indicated the current line via highlighting.

CR:318893

CR Number:   318893 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) 21 Aug 2003 Bundled Request Description In rare circumstances ASE can return incorrect results when a division is done using 2 numeric whereby the divisor is very large.

CR:318896

CR Number:   318896 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) 25 Jun 2003 Fixed 23 Jul 2003 Fixed Description In certain circumstances, SELECT INTO can create a numeric column with precision greater than the maximum allowed by the server.

CR:318945

CR Number:   318945 Product Name:   Adaptive Server Enterprise Product Component:   langinstall Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2003 Fixed 05 Feb 2004 Fixed Description Langinstall fails with 102 and 105 errors when installing thai utf8.

CR:319016

CR Number:   319016 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) 12 May 2003 Fixed Description Killing a process, parent or child, involved in parallel query execution might in certain cases cause a stack trace in the parent process.

CR:319075

CR Number:   319075 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2004 Presently Not Targeted For Any Future Release Of This Product Description A 277 error, "There was a transaction active when exiting the stored procedure '<proc>'. The temporary table '#<table>' was dropped in this transaction either explicitly or implicitly. This transaction has been aborted to prevent database corruption" is reported when a stored procedure that creates and drops a temporary table in a temporary database that has the "ddl in tran" property, is executed within a user transaction. Workaround Description  Instead of using temporary tables, use permanent tables in tempdb: create proc proc1 as begin create table tempdb..tab1 (col1 int) ... drop table tempdb..tab1 end go begin tran exec proc1 commit tran go This workaround can cause blocking issues in tempdb because system catalog locks will be held for the duration of the transaction, thereby blocking other users of tempdb.

CR:319091

CR Number:   319091 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2003 Fixed Description A select statement from a proxy table mapped to an Oracle RPC fails to return any rows when a smalldatetime column is used in the where clause.

CR:319113

CR Number:   319113 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 Oct 2003 Duplicate Description A TEXT or IMAGE column that is defined as NOT NULL can still be assigned NULL value through a variable that contains NULL.

CR:319207

CR Number:   319207 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 11 Jun 2003 Fixed 28 May 2003 Fixed 05 Aug 2004 Fixed Description Shared memory dump feature does not work for timeslice errors on Sun Solaris.

CR:319219

CR Number:   319219 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) 31 May 2003 Fixed Description During DUMP DATABASE or DUMP TRANSACTION of a database with the "trunc log on chkpt" option set, checkpoint process bypasses the database entirely instead of checkpointing the database. If a database dump takes one hour, the target database will go one hour without an automatic checkpoint, despite any activity during that time. Workaround Description  Manual checkpoints, or a script, during dump database, dump tran, or dbcc checkverify of a database which has the "truncate log on checkpoint" option set.

CR:319256

CR Number:   319256 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2003 Fixed Description On Windows platform, the configuration file is not copied to the new directory when upgrading ASE using a separate directory. The resulting ASE is then booted with the default configuration values.

CR:319284

CR Number:   319284 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 20 May 2003 Fixed 13 Jun 2003 Fixed 31 Jul 2003 Fixed 27 Jun 2003 Fixed Description When multiple BCP sessions append data in "fast" mode to the same slice of a data-only locked partitioned table, if one session aborts, then the subsequent creation of a placement index with the SORTED_DATA option may not be done correctly. Consequently, queries that use this index may not always return correct results.

CR:319297

CR Number:   319297 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) 14 May 2003 Fixed 16 Jun 2003 Fixed Description sp_sysmon reports inaccurate spinlock contention values showing greater than 100% spinlock contention at times.

CR:319304

CR Number:   319304 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) 12 Sep 2003 Presently Not Targeted For Any Future Release Of This Product 30 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 29 Oct 2003 Fixed Description Replication Agent processes unnecessary transactions generated by maintenance tasks such as Housekeeper Garbage Collection, table statistics flushes, reorg command or update statistics.

CR:319327

CR Number:   319327 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2003 Fixed Description On the diagnostic server ("diagserver") on 64 bit systems, executing queries that perform Java operations could cause the following error to be printed on the errorlog: "Assertion failed: 'sizeof( VMMethod ) == sizeof( VMMember ) + 19*sizeof( VMword )' in /remote/pea_bld1/main/porttree/svr/sql/generic/jvmsource/p/vmclass.p:811"

CR:319374

CR Number:   319374 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) 10 Jun 2003 Fixed 22 Sep 2003 Presently Not Targeted For Any Future Release Of This Product 07 Aug 2003 Fixed 13 Jun 2003 Fixed 03 Mar 2004 Fixed 13 Aug 2003 Fixed 22 Sep 2003 Fixed Description Null extended row may not be returned, if OR condition is specified for an index column in the inner table of an outer join and 3 or more tables are involved. Workaround Description  For specific situation described in Repro1, alter 1 table involved in the view to APL.

CR:319389

CR Number:   319389 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2003 Fixed 20 Jun 2003 Fixed 14 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date Description A sub-optimal query plan may be generated for queries using MAX() or MIN() together with WHERE clauses that involve OR clauses. Workaround Description  disable "allow backwards scans" or use trace 351 to force the "OR strategy"

CR:319397

CR Number:   319397 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) 21 Jan 2004 Fixed Description Allow a transaction that is in a "Done" state to be heuristically committed using dbcc complete_xact() by using "1pc" (an abbreviation for one-phase commit) as the third parameter. This should only be used if there was a single branch in the distributed transaction and the transaction manager used the one-phase commit optimization protocol to attempt to commit the transaction. Workaround Description  Use heuristic rollback instead, ie dbcc complete_xact(..., "rollback"). See "workaround" in the resolution description for more info.

CR:319403

CR Number:   319403 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 sp_sysmon reports incorrect values for 'Max ULC Size During Sample' and a few other rep agent related high water mark values.

CR:319451

CR Number:   319451 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) 04 Jun 2003 Fixed 29 Jul 2003 Presently Not Targeted For Any Future Release Of This Product Description A 3474 error may be reported on a sysindexes page after loading a transaction log which was dumped after the reboot following a change to the default character set or default sort order.