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

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

CR:297350

CR Number:   297350 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   IRIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2003 Not reproducible with latest version of the product available as of Resolution Date Description While the DBCC CHECKTABLE command is running on a data-only-locked schema table, if the HOUSEKEEPER task deallocates a free page of this table, then error 2583 may be raised "Number of data pages (<value1>) counted by DBCC differs from count in the data OAM (<value2>) for dbid <value> object <value>", followed by message "The total number of empty pages (with all deleted rows) in this table is <value3>" where <value1> minus <value3> would equal to <value2>.

CR:297369

CR Number:   297369 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2002 Fixed 24 Oct 2002 Fixed Description A 1581 error, "Create index was aborted because pages in the data only locked table are not linked", may be reported when loading a transaction log which was dumped when a REORG REBUILD was running concurrently on a data-only locked table that has a clustered index. Workaround Description  Restart the load sequence, stopping before the problematic dump. This transaction log will normally be the last in the load sequence since a REORG REBUILD must be followed by a DUMP DATABASE.

CR:297378

CR Number:   297378 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2003 Fixed 02 May 2013 Added to user documentation 22 Apr 2003 Fixed Description For certain locales such as Chinese, Japanese, or Korean, the server's minimum database sizes are too small to permit a successful installation: database logs fill up and installation stalls due to lack of space. Provide server command line flags to declare the desired size for the master and model databases, so that new installations can be created with databases large enough to guarantee a successful install. Provide support in the installation tools to calculate these sizes and communicate them to the server.

CR:297385

CR Number:   297385 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) 04 Feb 2003 Fixed Description Entering multiple shutdown commands will result in these processes waiting for each other to finish. Target Version  12.5.1 Review Status  Reviewed March 2003. CR is targeted (but not committed) to the ASE 12.5.1 release. Workaround Description  kill one of the shutdown processes or issue a shutdown with nowait.

CR:297398

CR Number:   297398 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) 06 Nov 2002 Fixed 04 Nov 2002 Fixed Description When Java in ASE encounters a severe error, the session is placed in an unkillable state waiting for "remote i/o". Java capabilities of ASE will become unavailable and attempts to use Java fails in unpredictable ways. Running "sp_who" will show the process waiting for "remote i/o". The errorlog may have a stacktrace containing U_get_previous_frame_x and ending with ExecuteJava__7VMFrameSFP6JNIEnvP8VMMethodP6VMword.

CR:297460

CR Number:   297460 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2002 Fixed 11 Oct 2002 Fixed Description Selecting from a proxy table mapped to an external file, where the data file contains less columns than expected causes dataserver to crash with a core dump.

CR:297480

CR Number:   297480 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2002 Fixed 26 Oct 2006 Presently Not Targeted For Any Future Release Of This Product Description When trying issue checkpoint after resetting "single user" option on a database, user may get error 924 saying that database is in use by other tasks.

CR:297491

CR Number:   297491 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) 24 Nov 2003 Bundled Request Description Customer wants to assign a role that has the ability to do such functions as kill spids, truncate table, create/drop index, dump/load database/transaction. Or add another type of role that would only have a subset of sa_role authorizations (between operator and sa role). Target Version  Galaxy Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0 release. Workaround Description  Customer can use the technique documented at http://www.sypron.nl/grant_sa.html workaround for this feature request.

CR:297520

CR Number:   297520 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) 17 Oct 2002 Fixed 14 Oct 2002 Fixed 15 Oct 2002 Fixed Description A 2525 error may be reported by DBCC CHECKALLOC or 100006 and 100031 faults may be reported by DBCC CHECKSTORAGE on page 0 in a database which has a proxy table to a partitioned remote table. Workaround Description  Avoid partitioning tables that will act as remote tables, i.e. if you are going to create a proxy table, make sure the remote table isn't paritioned.

CR:297617

CR Number:   297617 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) 30 Oct 2002 Fixed 31 Dec 2002 Fixed Description SYB_BACKUP...sp_who does not return any results.

CR:297625

CR Number:   297625 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) 25 Oct 2002 Fixed Description On HPUX, AIX and LINUX, ASE does not log an error in the errorlog when the request to Operating System for setting non-blocking mode or asynchronous mode for a client connection fails.

CR:297659

CR Number:   297659 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2002 Fixed 21 Oct 2002 Fixed Description The message "current process infected with 11" in the module 'astc__dtxp_scavenge' together with a stack trace that includes the module 'astc_dtxp_get_free' may be reported in the error log when updating a proxy table and the configuration parameter "enable xact coordination" is set to '0' and the "number of dtx participants" is underconfigured. Workaround Description  Increase value of 'number of dtx pariticipants' to a large value to avoid dtxp scavenging.

CR:297674

CR Number:   297674 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) 14 Nov 2002 Fixed 25 Oct 2002 Fixed Description No error message is reported when an online engine command is executed and another online engine command is already active. Rather, the command is blocked until the active command finishes, giving the appearance that the session has hung.

CR:297695

CR Number:   297695 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2002 Fixed 25 Oct 2002 Fixed 28 Oct 2002 Fixed Description In rare circumstances, an 1929 error "Failed to reserve/initialize allocation hints space in index '<name>' on table '<name>'" may be reported during the execution of a CREATE CLUSTERED INDEX command or an ALTER TABLE LOCK / REORG REBUILD command (on a table that already has a clustered index) if the table has at least one non-clustered index.

CR:297706

CR Number:   297706 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 Feb 2005 Insufficient priority to fix Description Feature request to have dbcc checkalloc recheck errors found at the tail end of syslogs to avoid spurious errors (similar to dbcc checkverify).

CR:297710

CR Number:   297710 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   AIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2002 Fixed 11 Nov 2002 Not a Bug 15 Dec 2002 Fixed Description CIS: Ctrl-C on RPC queries may result in timeslice -501 error and stack traces. Further access to the proxy tables may not work. Workaround Description  the workaround is not consistant. disabling xact coordination might help for smaller transactions. set enable xact coordination to 0

CR:297747

CR Number:   297747 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2004 Bundled Request Description Feature request. Provide mechanism for resource governor to print SQL text when resource limits are violated.

CR:297753

CR Number:   297753 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2006 Fixed 01 Aug 2008 Fixed 10 May 2006 Duplicate Description A new option, 'with dbid = <number>' has been added to 'CREATE DATABASE' command, to allow the database administrator to specify database id when creating a new database.

CR:297756

CR Number:   297756 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) 03 Dec 2002 Fixed 04 Dec 2002 Fixed 09 Mar 2003 Presently Not Targeted For Any Future Release Of This Product Description CIS: In rare circumstances on a multi-engine system, the messages "uppushaffinity: kpid XXXXXX affinity stack overflow", and "current process infected with 11" in the module 'com_async_assoc' together with a stack trace which includes the modules 'ksctsetamctx' and 'com_async_start', may be reported in the error log when a simple SELECT statement with a subquery involving a remote table is executed in parallel.

CR:297817

CR Number:   297817 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) 21 Oct 2002 Fixed 24 Oct 2002 Fixed Description During the startup of Adaptive Server, a stack trace that includes the modules 'audproc', 'send_boot_audit' and 'format_audrecs' may be reported in the error log when the 'security' auditing option is active, resulting in the AUDIT PROCESS being killed.

CR:297822

CR Number:   297822 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) 25 Oct 2002 Fixed Description Error 691 "Encountered invalid logical page '0' while accessing object '<value>' in database '<value>'" will be raised when trying to replicate a proxy table either through SP_SETREPTABLE or SP_REPTOSTANDBY with a stack trace in the error log showing modules 'set_repobj_status' or 'set_repdb_status' followed by 'txtimg_upd_table' and 'wrongpage'. Workaround Description  Add the proxy tables after issuing sp_reptostandby

CR:298070

CR Number:   298070 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) 30 Apr 2003 Fixed Description Error message 11136 still references the configuration parameter "max roles enabled per user". This parameter existed in 12.0 but was removed in 12.5, the limit is now simply hardcoded at 127. Target Version  12.5.1 Review Status  Reviewed March 2003. CR is targeted (but not committed) to the ASE 12.5.1 release.

CR:298088

CR Number:   298088 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2006 Fixed 12 Sep 2006 Fixed 19 Sep 2006 Fixed Description Add Resource Limits feature in ASEPlugin.

CR:298099

CR Number:   298099 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for object level backup and restore

CR:298108

CR Number:   298108 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to add a sorted_data option to "alter table" and a primary key option to creatre nonclustered index

CR:298176

CR Number:   298176 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) 21 Oct 2002 Fixed 30 Oct 2002 Fixed Description This fix: 1. Changes the default value for the configuration parameter "tcp no delay" to 1, which avoids batching TDS packets at the tcp layer. 2 Changes the default value for "disable disk mirroring" to 1, which provides performance benefits since the "device semaphores" need not be held if Sybase mirroring is not used. Both of these will provide out of the box performance gains for most installations. THINGS TO BE BORNE IN MIND: If sybase mirroring is being used, the configuration option "disable disk mirroring" needs to be changed to 0.

CR:298185

CR Number:   298185 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 Oct 2002 Fixed Description Under stress conditions, the number of child worker threads can increase while another DBMS task is traversing the list of children. A timing window led to an overrun of a dynamically allocated array resulting in either an assertion failure in diagserver or a segfault. This fix avoids the array overrun, fixes the assertion statement, and better handles the effects of the timing window. This change only affects code that uses worker threads.

CR:298244

CR Number:   298244 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) 17 Jan 2003 Fixed 19 Feb 2003 Fixed Description On HP 64 bit platforms, a session may not be cleaned up immediately when a client process is killed from the operating system command line. 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. Workaround Description  kill the session from within ASE.

CR:298298

CR Number:   298298 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2003 Fixed 21 Apr 2003 Fixed Description A new config parameter 'send doneinproc tokens' was added to control when the DONEINPROC tokens are transmitted. This can be set to 0 or 1. '0' restricts the transmission of DONEINPROC tokens to after SELECT statements only and 1 indicates there is no restriction on the transmission of these tokens. The default is 1. This replaces the dbcc tune() 'doneinproc' option.

CR:298302

CR Number:   298302 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) 09 Feb 2004 Workaround 09 Feb 2004 Workaround Description sqldbgr 'help' command and Utility Guide incorrectly specifies 'mysql' instead of 'sql' as useful for getting temp table info of the debugged task. 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  sqldbgr -U <user> -P <password> -S "<hostname>:<port>?CHARSET=iso_1" Using the quotes prevents the = sign from being used as a delimiter. The parser is treating the = sign as a delimiter to split the string, thus turning hostname:port?CHARSET=iso_1

CR:298303

CR Number:   298303 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 Mar 2003 Fixed Description The message "current process infected with 11" in the module memalloc together with a stack trace which includes the modules stu_findslot, st_hist_has_freqcells and j_process_n_bld_distmap, may be reported in the error log for queries using sort-merge join, and one of the columns used in the join has the value NULL for all rows in the table. Workaround Description  Disable sort merge join. set "enable sort-merge join and JTC", 0

CR:298346

CR Number:   298346 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement Request: Allow the auditing of actions based upon the user-defined roles active for a user. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for a future ESD of the ASE 12.5.1 release.

CR:298368

CR Number:   298368 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) 30 Oct 2002 Fixed 06 Nov 2002 Fixed Description Several built-in functions and global variables have been added for better compatibility with MS SQL Server. See the release notes for details.

CR:298472

CR Number:   298472 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) 04 Nov 2002 Fixed 17 Mar 2003 Presently Not Targeted For Any Future Release Of This Product Description On HP64 platform, builtin function sortkey() stack traces when it is executed against a 16384-byte long string.

CR:298485

CR Number:   298485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2002 Fixed Description A bug where ASE detects incorrectly there was system error when more that 1000 backup config files exists was fixed.

CR:298585

CR Number:   298585 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2002 Fixed 07 Jan 2003 Presently Not Targeted For Any Future Release Of This Product 10 Jan 2003 Fixed 04 Feb 2003 Fixed Description In some cases, truncation of syslogs may be prevented when a query does a "sorted" sort in tempdb (for ORDER BY or DISTINCT) within an explicit user transaction which is neither explicitly committed nor rolled back, despite there being no updates, inserts or deletes done within the transaction. Target Version  12.0.0.7 Review Status  Reviewed March 2003. CR is fixed in 12.0.0.7 IR (released March 2003) and 12.5.0.3 ESD #1 (released early April 2003). Workaround Description  To remove the extra "begin tran" or add "commit/rollback tran". (Flag 328 does not work for the issue)

CR:298620

CR Number:   298620 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) 21 Mar 2003 Fixed 21 Mar 2003 Fixed 02 Apr 2003 Fixed 08 Apr 2003 Fixed Description The non clustered index Sysusers.ncsysusers2 created during the installation of a 12.5 ASE does not have the unique attribute set whereas it should.

CR:298637

CR Number:   298637 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2003 Bundled Request Description The monErrorLog monitoring table now reports the error state as the State column. Messages of the form 'Error: %, Severity: %, State: %' are no longer reported by monErrorLog as the ErrorNumber, Severity and State are all included for the actual error message, thus making these additional informative messages redundant.

CR:298655

CR Number:   298655 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Tables Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2003 Fixed Description Sysconfigures table should document decimal values alongwith hex values for 'status' column. -1 should be documented as a valid value for 'value4' column. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted for the documentation to be released with 12.5.1

CR:298720

CR Number:   298720 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) 25 Oct 2002 Fixed 31 Oct 2002 Fixed Description The message "process infected with 10" may be reported in the error log together with a stacktrace which includes the modules 'drop_constr' and 'altertab' if an ALTER TABLE <table> DROP CONSTRAINT <constraint id> statement is executed.

CR:298755

CR Number:   298755 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 Nov 2002 Fixed Description An engine which is part way through going offline consumes 100% cpu until it finally completes the offline operation

CR:298799

CR Number:   298799 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2002 Fixed 02 Jan 2003 Fixed 04 Feb 2003 Fixed 22 Jan 2003 Fixed Description If either GRANT actions or JAVA CLASSES REMOVE actions are being audited, sp_displayaudit incorrectly displays that both actions are being audited. In either case, only GRANT actions are actually being audited. Target Version  12.0.0.7 Review Status  Reviewed March 2003. This CR has been fixed in the 12.0.0.7 IR released early March 2003.

CR:298813

CR Number:   298813 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) 29 May 2009 Insufficient priority to fix Description Feature Request: ASE should check for "null" inserts to columns that do not allow nulls at create procedure time. This is in addition to the run time checking that is already done. Target Version  Not To Be Released Review Status  Reviewed March 2003. Fix is not targeted. To be closed as not to be fixed.

CR:298870

CR Number:   298870 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 Jan 2003 Presently Not Targeted For Any Future Release Of This Product Description Concurrent deletes on an APL table may deadlock, when one session is deallocating a page (as a result of deletes), while another is trying to scan the object for the rows it wants to delete. The stacks of tasks will show functions apl_getnext and removepage respectively. Target Version  12.5.0.3 Review Status  Reviewed March 2003. This CR is targeted for an upcoming 12.5.0.3 EBF. Workaround Description  use DOL

CR:298899

CR Number:   298899 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2002 Fixed Description Linux/ASE does not anticipate for raw device alignment when checking the physical device mirrored data. This will result in a mirror check making the mirrorred device not usable when administrated on a linux Raw bound device.

CR:298976

CR Number:   298976 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) 31 Jan 2003 Fixed 06 Feb 2003 Fixed Description The message "current infected with 11" in the module 'sqx__do_transform' or in the module 'com__subquery' may be reported in the errrorlog when executing SELECT that contains subqueries and assigns multiple local variables that are used in the SELECT list and in the WHERE clause. Workaround Description  One of following conditions is OK for the workaround: 1. To use a different name instead of "@acc" in SELECT-list 2. To remove one assign of two assigns from SELECT-list. 3. To remove one of two conditions from WHERE clause

CR:299039

CR Number:   299039 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) 11 Apr 2003 Fixed 10 Apr 2003 Fixed Description On HP-UX platform, setsockopt(), accept() and connect() system calls may be interrupted by a signal and fail. ASE treats EINTR as unrecoverable error leading to the connection being aborted by the network handler. ASE may report "nopen: accept, Interupted system call" in the errorlog leading to 1605 error. Target Version  12.0.0.7 Review Status  Reviewed March 2003. Fix is in ASE 12.0.0.7 and a future 12.5 ESD or 12.5.1. Workaround Description  Removing HP patch PHNE_27063 may be a workaround. This has not been confirmed in all cases, just an observation of one customer. See resolution #1 for details. - Sathya

CR:299108

CR Number:   299108 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) 19 Nov 2002 Fixed 14 Mar 2003 Duplicate 06 Feb 2004 Fixed Description ASE certificates with chains longer than 1 fail SSL handshake. This fix incorporates SSL Plus library v.3.1.3 into ASE. ASE must be used with the corresponding OCS release using SSL Plus v.3.1.3. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release.

CR:299150

CR Number:   299150 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2002 Fixed 05 Feb 2003 Fixed Description When the last non-granted blocking lock is released because its associated session is either interrupted or killed, Adaptive Server does not re-evaluate the grantable lock requests that are no longer blocked. This situation is rare, but it will result in unnecessary blocking situations, for example a 'shared page' lock that is granted to task A may block a 'shared page' compatible lock requested by task B. Target Version  12.0.0.7 Review Status  Reviewed March 2003. CR has been fixed in the 12.0.0.7 IR, released early March 2003. Workaround Description  N/A

CR:299160

CR Number:   299160 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) 08 Apr 2003 Fixed Description "kesetown: engine <engine number> is still not online after <number of attempts> attempts to affinity to it" may be raised when an engine is offline and dbcc monitor is executed multiple times (through sp_sysmon or historical server). Target Version  12.5.0.3 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for a future 12.5.0.3 ESD. Workaround Description  None - error messages are informational only although annoying.

CR:299209

CR Number:   299209 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) 21 Jun 2004 Presently Not Targeted For Any Future Release Of This Product Description A long running transaction doing inserts and deletes on a DOL table may make a large no. of exclusive row requests and impact performance due to redundant garbage collection checks. Target Version  12.5.0.3 Review Status  Reviewed March 2003. Fix in ASE 12.5.0.3. Workaround Description  use APL scheme

CR:299239

CR Number:   299239 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) 07 May 2003 Fixed 11 May 2003 Fixed 15 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description CIS: Execution of the query INSERT...SELECT <constant string> FROM proxy table, will either cause garbage to be inserted, or give a syntax error with Msg 156, or cause a stack trace in inserttext() depending on the length of text constant in the SELECT clause.

CR:299280

CR Number:   299280 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2003 Fixed 05 Feb 2003 Fixed Description An 2805 error, "Bad pointer 0x2 encountered while remapping stored procedure. Invalid pointer param number 3, pointer value 0x0'. Must re-create procedure" is reported when executing a SQL statement that uses an aggregate function in a WHERE clause within subquery under a HAVING clause on a correlated column. The error is raised when such a statement is executed via a stored procedure which is recompiled. 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:299299

CR Number:   299299 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a built-in function that would return the page number containing the row being returned. Target Version  15.0 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0+ release. Workaround Description  You can determine the page number(s) containing a particular row of data with this sql: begin tran update mytable set keyval = keyval where keyval = <x> select page from master..syslocks where spid = @@spid and page > 0 rollback tran go

CR:299320

CR Number:   299320 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Stored procedure replicate needs owner and version information

CR:299391

CR Number:   299391 Product Name:   ASE Replicator Product Component:   Management Status:   Closed OS:   Generic Original Version:   12.5.0.107P4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.0.0 06 May 2003 Fixed 12.5.0.107P4 06 Nov 2002 Fixed 12.5.0.107P4 11 Nov 2002 Fixed Description ASE Replicator: In localized versions of Replicator, descriptions of configurable properties, trace flags, and debug flags appear in English instead of the current language.

CR:299413

CR Number:   299413 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) 18 Nov 2002 Fixed 03 Mar 2003 Fixed Description When a cursor is declared with a right-nested ANSI OUTER JOIN and the SET CURSOR ROWS option is set to more than 1, then a FETCH statement may return an incorrect null-supplied row. Target Version  12.0.0.6 Review Status  Reviewed March 2003. CR has been fixed in 12.0.0.6 ESD #1 and will also be fixed in 12.5.1. Workaround Description  do not use set cursor rows

CR:299522

CR Number:   299522 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2003 Fixed 28 Oct 2003 Fixed Description A 2620 error may be raised in module 'putdrow' while inserting data in an All Pages Locked table that has an index such that the length of the index key only allows three rows to fit on each index page. Alternatively a 614 error may be raised in module 'apl_rowsize'. In both cases, this will result in the session being killed with a stack trace reported in the error log showing respectively modules 'cinsert' and 'ncupdate'. Target Version  To Be Determined Review Status  Reviewed March 2003. Pending further research in engineering. Workaround Description  . Drop the (clustered) index before inserting the data. . Use DOL locking scheme.

CR:299527

CR Number:   299527 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) 28 Apr 2003 Fixed Description Implicit conversion from float to numeric fails for proxy tables in ASE 12.0.x and 12.5.x. with Msg 241: Msg 241, Level 16, State 2: Server 'local', Line 3: Scale error during implicit conversion of NUMERIC value '11.6000004' to a DECIMAL field. 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  Use CIS traceflags 11216 (session based) or 11217 (global) to disable remote optimization (disable 'smart passthru')

CR:299611

CR Number:   299611 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) 08 Nov 2002 Fixed 06 Nov 2002 Fixed 19 Nov 2002 Fixed Description The first server to server RPC will succeed, but subsequent RPCs will fail with 7211 error "Can't open a connection to site '<remote server name>' because 'set up channel' message was not acknowledged" if they are issued to the same remote server after the timeout period. ASE reports "nconnect: connect, Connection refused" error followed by "Cannot read, host process disconnected: <remote server name> spid: <n>" in the errorlog.

CR:299696

CR Number:   299696 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) 16 Feb 2003 Not a Bug 09 Jun 2003 Fixed Description In certain occasions, NT based ASE servers may tend to favor compute-bound tasks over io-bound tasks (potentially 10 times to 1) resulting in unreasonably poor performance for the io-bound tasks. Workaround Description  Set "i/o polling process count" to a low value via sp_configure, the default value is 10. The customer set it to 1 to workaround right now, but they still want a fix. Tuning i/o polling process count affects both the response time and throughput of Ada

CR:299722

CR Number:   299722 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) 03 May 2006 Fixed Description DSEdit, Server Config Utilities in sybase central java edition should works as shortcuts, if the utilities are not found in the location ASE is looking for then error messages appear. One should have the option to create/delete/modify the shortcuts. Target Version  Galaxy Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 15.0 release.

CR:299829

CR Number:   299829 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2006 Insufficient priority to fix Description If you are monitoring stored procedure usage and a ct-lib application executes a procedure via a cursor then it's usage doesn't show up in the stats.

CR:299830

CR Number:   299830 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 Feature request for a method for users to define their own rules for what is or is not a valid password. A possible implementation of this would be to use an architecture similar to the way sp_thresholdaction is handled with last-chance thresholds. sp_password could be modified to check for the existance of a user-provided procedure called (for example) sp_validate_password @varchar(30) password, and if it exists, pass the new password to it for checking, based on the results either abort or go ahead and change the password. Sybase would not provide sp_validate_password so that it does not get overwritten (losing the user-provided content) when installmaster was run. Target Version  Galaxy Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0+ release. See also feature request 299856.

CR:299856

CR Number:   299856 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 May 2004 Bundled Request Description Provide option to 'check for digit' at the time of login Target Version  Galaxy Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0+ release. See also feature request 299830.

CR:299964

CR Number:   299964 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2003 Fixed Description Error messages were previously captured and reported by the monErrorLog monitoring table when the configuration option 'errorlog pipe max messages' was greater than 0, regardless of the value of 'errorlog pipe active'. Now, 'errorlog pipe active' must also be enabled for this to happen.

CR:300015

CR Number:   300015 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) 13 Nov 2002 Fixed 13 Nov 2002 Fixed Description When server's default character set is UTF-8, the operation to insert into text column using parameterized language statement through jConnect fails with some multi-byte characters. Workaround Description  As I workaround I can "hardcode" the parameter value into the INSERT string: String insertParameter = "\uff21"; String insertString = "insert into ttable values ('" + insertParameter + "')"; System.out.println("Insert String: " + insertString);

CR:300175

CR Number:   300175 Product Name:   Sybase InstallShield Product Component:   InstallShield Status:   Closed OS:   Generic Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2002 Fixed 3.0 13 Nov 2002 Fixed 3.0 13 Nov 2002 Fixed 3.0 13 Nov 2002 Fixed 3.0 13 Nov 2002 Fixed 3.0 13 Nov 2002 Fixed Description Fixed that uninstaller problem. Added 1 line in UninstallableObject that sets the activeForUninstall property to false by default. This ensures that Installshield won't try to uninstall anything without the user pressing anything.

CR:300413

CR Number:   300413 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2003 Fixed 01 Apr 2003 Not a Bug Description The display names for tables and compiled objects (views, triggers, etc.) on the left-hand-side (tree view) now contain the owner names to avoid confusion when there are multiple same-named objects with different owners. For example, if there are two user tables both named 'test' and owned by user 'user1' and 'user2', by expanding the tables folder, the tree view items for the tables will be 'test (user1)' and 'test (user2)'.

CR:300435

CR Number:   300435 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) 10 Jul 2003 Fixed 01 Sep 2003 Fixed Description When SET PLAN DUMP for Abstract Plans is enabled, the plans for statements inside a BEGIN-END block will be missing.

CR:300579

CR Number:   300579 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2005 Fixed 16 Dec 2005 Reservation Made 13 Jun 2006 One-off Provided Description There are limited password complexity checks when a new password is specified or a password is changed. The password expiration warning interval is not configurable. A new login created is allowed to operate with the created password.

CR:300585

CR Number:   300585 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) 05 Dec 2003 Fixed Description Query with a subquery also accessing a view with UNION ALL and some other view with DISTINCT clause may produce a stacktrace. This happens when the view with UNION ALL is not materialized into a worktable. Workaround Description  Put the distinct view at the end of the FROM list. Should work for majority of queries.

CR:300706

CR Number:   300706 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2003 Fixed 16 Jun 2003 Fixed Description A 540 error followed by a 225 error, will be raised when accessing a table, if a non clustered index is created on this table in the same batch. Workaround Description  - Avoid using 'ddl in tran'. - Or use a clustered index (for an allpages table). - Or break the batch in several batches.

CR:300788

CR Number:   300788 Product Name:   Sybase InstallShield Product Component:   InstallShield Status:   Closed OS:   Windows 2000 Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed Description When running the installer with JRE 1.4, after clicking the OK on the Reboot dialog, java.exe will generate an error. Upon reboot, the installer may not be started automatically.

CR:300790

CR Number:   300790 Product Name:   Sybase InstallShield Product Component:   InstallShield Status:   Closed OS:   Generic Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed 3.0 26 Nov 2002 Fixed Description When running the installer with JRE 1.4, tabbing will not change focus to Swing components, instead of skipping over them.

CR:300807

CR Number:   300807 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   IRIX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2002 Fixed 21 Feb 2003 Fixed Description The statement "ALTER TABLE <tablename> ADD COL <varchar_colname> DEFAULT <default value>" may cause the process to be infected with signal 10 if the default value consists of more characters than the server page size. The bad address would contain module ubffree, and the stack trace may contain routines memfreeheap() and pre_alttab().

CR:300894

CR Number:   300894 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) 07 Jan 2003 Fixed 12.0.0.7 03 Mar 2003 Fixed 25 Jul 2003 Fixed Description The Monitor Server in the ASE-12.5.03 Beta release has a high CPU usage after startup.

CR:300931

CR Number:   300931 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) 12 Sep 2003 Bundled Request Description dbcc settrunc may report memory allocation warnings when it is run in a database configured for Replication Agent.

CR:300959

CR Number:   300959 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) 31 Mar 2003 Fixed 29 Apr 2003 Fixed 29 Apr 2003 Fixed 30 Jul 2003 Fixed 30 Jul 2003 Fixed 01 Aug 2003 Fixed Description Modifying a variable length column's datatype to change its nullability or its length would not cause stored procedures to be renormalized. This could lead to incorrect results or internal memory corruption, which can result in timeslice errors or recursive segmentation violations. Workaround Description  drop and recreate procedure after using ALTER TABLE MODIFY

CR:300978

CR Number:   300978 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2002 Fixed 06 Feb 2003 Fixed Description Since 11.9, a query that forces the use of a specific index using the INDEX clause in a SELECT statement and which has an OR clause, may perform sub-optimally because the special OR strategy is not considered by the optimizer. A possible workaround would be to remove the INDEX clause from the query. 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. Workaround Description  Rewrite the query without force index.

CR:301019

CR Number:   301019 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 2009 Duplicate Description TDS_ROWFMT2 token decreases performance by 50% for some queries Target Version  To Be Determined Review Status  Reviewed March 2003. This CR is being actively worked on. Workaround Description  1) Increasing packet size for this particular query to 1024 made OC 12.5 performance equivalent to OC 11.1.1. 2) Setting "tcp no delay" to 1 helped a little bit. However, 12.5 performance was still subpar to pre-12.5 performance.

CR:301063

CR Number:   301063 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Nov 2002 Fixed 04 Jun 2003 Fixed Description When two or more sessions are running concurrently in ASE and ASE runs out of locks and the session causing the out-of-locks error is also using temporary tables to process its query, error 216, "Attempt to automatically drop temporary table failed" may occur followed by error 1204, "SQL Server has run out of locks".

CR:301065

CR Number:   301065 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   NA Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2003 Fixed 15 May 2003 Fixed 28 Aug 2003 Fixed 28 Aug 2003 Fixed Description DUMP TRAN using multiple stripes may produce files with very different sizes.

CR:301072

CR Number:   301072 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) 12 Dec 2002 Fixed 30 May 2003 Fixed 05 Feb 2004 Fixed Description Under heavy load conditions on ASE running on NT using SSL, exceptions arising in the Connectivity libraries linked with ASE cause ASE to exit abruptly, with the message "A SERIOUS UNHANDLED EXCEPTION HAS OCCURRED. SERVER MAY NOT BE ABLE TO CONTINUE" in the errorlog.

CR:301161

CR Number:   301161 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) 05 Apr 2009 Insufficient priority to fix Description Request to "Make the message about invalid MAX_ROWS_PER_PAGE more descriptive as to table names, and if corrections are being performed automatically while upgrade is being performed" Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release.

CR:301177

CR Number:   301177 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) 31 Jan 2003 Fixed 10 Dec 2002 Fixed 03 Feb 2003 Fixed Description The 'sp_stored_procedures' stored procedure does not show a procedure whose access is granted via a user-defined role. Target Version  12.5.0.3 Review Status  Reviewed March 2003. CR is fixed in 12.5.0.3 ESD #1. Workaround Description  not really customer using changed code.

CR:301236

CR Number:   301236 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2003 Presently Not Targeted For Any Future Release Of This Product Description When Sybase Central (non-java version)reads database attributes data (when rightclicking a database and selecting properties, for example) and there are more than one row with object_type='D' in master..sysattributes, Sybase central returns an error saying: The Last Query either caused a deadlock or a lock timeout. Workaround Description  use java version of Sybase Central

CR:301240

CR Number:   301240 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) 11 Feb 2004 Fixed Description In rare circumstances, Adaptive Server will hang during recovery of a system or user-defined temporary database. The stack trace of the hung process will include the modules 'recover_tempdb', ..., 'pg__updateoam' and 'pg__updateoam_thru_allocpg'

CR:301262

CR Number:   301262 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) 19 Jun 2003 Fixed 19 Jan 2004 Insufficient priority to fix Description The command 'set lock wait' called from a stored procedure is executed only when the procedure is compiled. Target Version  12.5.1 Review Status  Reviewed March 2003. This CR is targeted (but not committed) to the ASE 12.5.1 release. Workaround Description  execute the store procedure with recompile option

CR:301367

CR Number:   301367 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2002 Fixed 28 Nov 2002 Fixed 27 Nov 2002 Fixed Description The message "current process infected with 11" in the module 'bufsearch' together with a stack trace that includes the modules 'pg__gam_extend' and 'pg_gamalloc' will be reported in the error log if a CREATE DATABASE or ALTER DATABASE command is executed such that the size of the database grows beyond a 63 GB (or multiple of 63 GB) boundary. Workaround Description  Possible workaround: roll back to 12.0.0.6 IR.

CR:301411

CR Number:   301411 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) 26 Nov 2002 Fixed 28 Nov 2002 Fixed 27 Nov 2002 Fixed Description A 25000 error, "Invalid number of parameters" is reported by XP Server when executing an extended stored procedure with a parameter list, this having been created via the "sp_addextendedproc" procedure. This fix is enabled only by starting Adaptive Server using -T523 traceflag. Workaround Description  n/a

CR:301491

CR Number:   301491 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) 01 Dec 2003 Presently Not Targeted For Any Future Release Of This Product Description INSTRUMENTATION: The message "current process infected with 11" in the module 'kmrtmsg' together with a stack trace which includes the modules 'smput', 'send_audit', 'form_and_send_audit', 'chk_and_send_audit' and 'ex_audit' may be reported in the error log.

CR:301509

CR Number:   301509 Product Name:   ASE Replicator Product Component:   Management Status:   Closed OS:   Generic Original Version:   12.5.0.107P4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.108P5 26 Nov 2002 Fixed 2.0.0 06 May 2003 Fixed Description ASE Replicator: The descriptions of the "truncate_numops" configurable property and the "DDBLOGTRC" trace flag were not globalized so, when displaying these in a non-English environment, these descriptions appear in English.

CR:301590

CR Number:   301590 Product Name:   Sybase InstallShield Product Component:   InstallShield Status:   Closed OS:   Solaris Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2002 Fixed 3.0 12 Dec 2002 Fixed 3.0 12 Dec 2002 Fixed 3.0 12 Dec 2002 Fixed 3.0 12 Dec 2002 Fixed Description Fixed the uninstall issue where we can't uninstall if there is no CIM (i.e. repository down, or not containing data about the product). SybaseFeatureUninstallPanel: Added some code to figure out whether the repository is "disconnected" Uninstallable*: Added special methods for selecting withough doing dependency checking.

CR:301692

CR Number:   301692 Product Name:   Adaptive Server Enterprise Product Component:   sqldbgr Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2003 Fixed Description Sqldbgr could hang when a user attempts to run a non-existent stored procedure. This problem is fixed by providing an appropriate error message with a trace in the sqldbgr code and continuing to run the sqldbgr

CR:301729

CR Number:   301729 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2002 Fixed 12.5.0.3 06 Dec 2002 Fixed Description The default 'max memory' is increased from 46MB to 66MB on NT due to increased default size of the 'large i/o buffer' pool. By default the memory allocated by ASE will not increase beyond the earlier value of 46MB for servers with logical page size less than 16K. The shared memory allocated will increase to about 60MB for 16K page size servers with the default configuration. However if the 'allocate max shared memory' config option is set to '1' then the max shared memory will be allocated, hence the memory allocated by ASE will increase to the new default 'max memory' i.e. 66MB. Users using a non default 'max memory' configuration should take note of the increase in the memory requirements of the 'large i/o buffer' pool and update their 'max memory' configuration appropriately. Users using the default 'max memory' configuration and having the 'allocate max shared memory' config option set to '1' should also take note of this change and make sure that adequate memory is available for ASE or specify an explicit value for the 'max memory' configuration in the config file.

CR:301730

CR Number:   301730 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Closed OS:   Digital UNIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2002 Fixed 12 Dec 2002 Fixed Description preupgrade may underestimate the space available in a database if there is free space in fragments without system segment. Workaround Description  Add system segments to all your devices, or execute the following procedure instead: use master go if exists( select 1 from sysobjects where name="sp_check_dbspace") drop proc sp_check_dbspace go use sybsystemprocs go if exists(

CR:301771

CR Number:   301771 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   SunOS Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2003 Fixed Description Non sa_role/ha connection requests can prevent polite SHUTDOWN from completing. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted for the ASE 12.5.1 release.

CR:301829

CR Number:   301829 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2003 Fixed 21 Apr 2003 Fixed Description sp_sysmon was reporting high engine load on all engines incorrectly, when most of the engines were less active and only a couple of engines were under high load. Workaround Description  boot with -T4050 which will turn off the engine local counters and force all the counters to use those of engine 0

CR:301910

CR Number:   301910 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) 20 Jan 2003 Fixed 03 Feb 2003 Fixed Description In rare circumstances for an All Pages Locked table an invalid expected row length and offset VALUE may be reported with error message 631 "The length of <value> passed to delete row routine for the row at offset <value> is incorrect on the following page: <value>. The expected row length is <VALUE>. The offset should be no greater than <VALUE>". Alternatively when the configuration option 'print recovery information' is active the error message 3410 "Roll back transaction '<value>' -- was aborted." may not be correctly reported. Target Version  12.5.0.3 Review Status  Reviewed March 2003. CR is fixed in ASE 12.5.0.3 ESD #1. Workaround Description  None.