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

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

CR:334700

CR Number:   334700 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) 18 Jan 2004 Fixed 27 Jan 2004 Fixed 09 Feb 2004 Fixed 12 Mar 2004 Fixed 30 Jun 2004 Fixed Description Kerberos support in ASE is now enabled. ASE relies on OS provided Kerberos libraries,utilties, and Kerberos KDC, as well as the Sybase Connectivity provided Kerberos driver. See Kerberos Interoperability Matrix for more details on testing.

CR:334729

CR Number:   334729 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2003 Bundled Request Description On Solaris, HP, AIX and Linux platforms, Job Scheduler template files installTemplateProcs.bat, installTemplateXml.bat and installTemplateXml are missing.

CR:334752

CR Number:   334752 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 Jan 2004 Duplicate Description would like to have installdbccdb script preserve dbcc_exceptions table if script is rerun and if it has entries

CR:334814

CR Number:   334814 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) 23 Dec 2003 Fixed Description When 'create table' and 'insert' are in the same store procedure, and the table is a temp table with identity column, the identity column data is not inserted correctly. Workaround Description  Create the table only using 'tempdb..' or using '#'

CR:334831

CR Number:   334831 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 Oct 2003 Fixed 29 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description If a row level access rule is attached to a table involved in an outer-join query it may generate incorrect results.

CR:334842

CR Number:   334842 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) 29 Oct 2003 Fixed 31 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 26 Dec 2003 Fixed Description An 691 error may occur when accessing SYSGAMS in TEMPDB database when the size is bigger than 63 GB. Workaround Description  The workaround is to run dbcc gam(2, -1, -1, fix) after restarting the server.

CR:334922

CR Number:   334922 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2004 Fixed Description The monCachedObject table returns no rows when a CacheID or a CacheName are used as exact match search arguments, e.g. select * from monCachedObject where CacheID=1

CR:334980

CR Number:   334980 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) 04 Dec 2003 Fixed Description Subquery predicates are not pushed down to the materialization step of the view with union worktable (if the view can't be merged).

CR:335173

CR Number:   335173 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) 11 Feb 2004 Fixed 08 Apr 2004 Fixed 20 Mar 2009 Fixed 12 Feb 2004 Fixed 12 Feb 2004 Fixed 12 Mar 2004 Fixed Description The maximum number of subqueries within a single side of a UNION has been increased from 16 to 50.

CR:335317

CR Number:   335317 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 Fixed Description A 913 error, "Could not find row in sysdatabases with database id ... Run DBCC CHECKTABLE on sysdatabases" may be reported when executing a stored procedure in a recently loaded database that uses a cursor and fetches values in local variables using extended datatypes (i.e. java classes).

CR:335343

CR Number:   335343 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2003 Fixed Description CIS : Conversion/truncation errors may occur, When an Engine is brought online after it was offlined and while inserting into proxy database involving Unichar columns. Target Version  12.5.1 ESD#1

CR:335465

CR Number:   335465 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 Nov 2003 Fixed 19 Dec 2003 Fixed 13 Feb 2004 Fixed Description The message "current process infected with 11" in the module 'q_match_cols' may be reported in the error log when cross-database queries reference a database that is in single user mode and another session is using this database. Workaround Description  Stop DB from being single user.

CR:335485

CR Number:   335485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2003 Fixed Description Improve the performance of xmlextract() result generation process.

CR:335495

CR Number:   335495 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2003 Fixed Description Provide quick access to JISQL and SQL Advantage (Windows only) from a server connection. To execute queries using these tools, right-click the connections and select 'Open JISQL' or 'Open SQL Advantage' menu item.

CR:335542

CR Number:   335542 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2004 Presently Not Targeted For Any Future Release Of This Product 21 Jun 2004 Fixed 01 Mar 2006 Fixed Description CIS: An outer join query declared inside a cursor can't be passed to the remote server completely even if all tables involved are on the same remote server. Cursors involving remote tables are READONLY by default. They can be made UPDATE-ABLE by default upon enabling traceflag 11218.

CR:335557

CR Number:   335557 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) 21 Oct 2003 Fixed 01 Dec 2003 Fixed Description DBCC CHECKSTORAGE may report 100030 error when large TEXT data was inserted.

CR:335560

CR Number:   335560 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) 21 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 21 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description ASE doesn't take HP setting fs_async into account when opening filesystems. As a result synchronous io is used.

CR:335571

CR Number:   335571 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) 14 Nov 2003 Fixed 08 Apr 2004 Fixed 09 Oct 2006 Not reproducible with latest version of the product available as of Resolution Date Description Column statistics may not be taken into account for non optimizable IN() clause, this may lead to suboptimal plan selection for a query with IN()or OR clauses which joins multiple tables. To take benefit of the change server must be started with -T301 trace flag. Workaround Description  Create an index on the column concerned by the IN clause.

CR:335572

CR Number:   335572 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 2005 Not reproducible with latest version of the product available as of Resolution Date 04 Nov 2005 Fixed Description Referential integrity may not be enforced for UPDATE or INSERT query if the query is executed with the option SET ROWCOUNT.

CR:335586

CR Number:   335586 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This is a feature request to have a query using a SARG with an escaped wild card to actually use the index instead of table scanning which tends to causes a performance degrade.

CR:335588

CR Number:   335588 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2004 Fixed 02 Aug 2004 Not reproducible with latest version of the product available as of Resolution Date 06 Mar 2005 Fixed 06 Mar 2005 Fixed Description When insert large index rows (that each page can only hold 3 rows), the index splitting may cause index level increase linearly with the number of row inserted, soon it will run out of the max index level.

CR:335628

CR Number:   335628 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description tracking of page splits per object

CR:335657

CR Number:   335657 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 Oct 2003 Fixed 05 Feb 2004 Fixed Description The message "current process infected with 10" together with stack trace which includes the module 'PDFreeDataChain' may be reported when an error is found at SSL initialization or while adding a certificate.

CR:335741

CR Number:   335741 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Dec 2003 Fixed 29 Dec 2003 Fixed Description Using trace 4048 and the char_length() builtin function having a CHAR datatype parameter will cause trailing blanks to be trimmed from the parameter used. Workaround Description  Enable the trace flag 4048 via 'session level' with 'dbcc traceon' (dbcc traceon(4048))

CR:335774

CR Number:   335774 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2003 Fixed 27 Oct 2003 Fixed 14 Nov 2003 Fixed 14 Nov 2003 Fixed Description If there are two derived tables at the same level and only one of them has a derived column list, then it may result in error 11061.

CR:335847

CR Number:   335847 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 Nov 2003 Fixed Description CIS : In a HA environment, updates to existing external login using sp_addexternlogin does not get propagated from primary to companion server.

CR:335878

CR Number:   335878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2004 Fixed Description A new Feature has been added to Support Veritas Clusters version 2.1 on Linux platforms With ASE12.5.2 release for ACTIVE/ACTIVE cluster setup Requirements : veritas Volume Manager 3.5 , Veritas Cluster Software ver.2.1 Target Version  12.5.2

CR:336053

CR Number:   336053 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) 14 Nov 2003 Fixed Description In ASE 120/125 releases, parse and compile time is longer for queries with multiple aggregates and a long IN list.

CR:336077

CR Number:   336077 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 Oct 2003 Fixed 27 Oct 2003 Fixed Description The message "current process infected with 11" may be reported in module 'mda_populate_monOpenObjectActivity' during the collection of monitoring data when the configuration option 'enable monitoring' is set resulting in the session being killed. The stack trace reported in the error log will also mention modules 'execrpc', 'exec__native_rpc' and 'mdarpc_exec'. Workaround Description  N/A

CR:336127

CR Number:   336127 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2004 Fixed Description The monProcess table incorrectly contains rows for inactive worker processes. Workaround Description  Modify the query on the monPRocess table to include 'where FamilyID != 0'. For example: select * from master..monProcess where SPID not in (select spid from master..sysprocesses) and FamilyID != 0

CR:336265

CR Number:   336265 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2005 Fixed 05 Jan 2006 Bundled Request Description SQL text capture may be turned off in the ASE when the Monitor Server terminates. This will cause collection of data for the monProcessSQLText and monSysSQLText MDA tables to stop. Workaround Description  If SQL text collection terminates for the monPRocessSQLText of monSysSQLText tables, execute "sp_configure 'SQL batch capture', 1".

CR:336289

CR Number:   336289 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) 27 Oct 2003 Fixed 18 Dec 2003 Fixed 18 Dec 2003 Insufficient priority to fix Description In rare circumstances on a multi-engine server, an undetected deadlock may occur when running the 'curunreservedpgs' builtin while a database's information is cached for the first time or it is replaced due to the "number of open databases" being less than the total number of databases on the server. Workaround Description  There is no workaround for all types of occurrences. Yet, avoiding the reuse of DBTABLEs by setting the "number of open databases" accordingly will prevent some of the occurrences. The process reported as blocked can be killed.

CR:336320

CR Number:   336320 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2003 Fixed Description When using a larger network packet size than the normal default size, ASE may encounter 'invalid length' TDS protocol errors during login. Workaround Description  Use the default packet size (512 bytes). In an HA environment, this means setting 'cis packet size' to 512 bytes.

CR:336354

CR Number:   336354 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2003 Duplicate Description ASE sets dsync on by default for raw partitions when physname is symbolic link

CR:336384

CR Number:   336384 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for progress monitors for some common DBA commands such as alter table, update statistics, and reorg.

CR:336556

CR Number:   336556 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) 18 Nov 2003 Fixed Description Replication Agent may send a wrong value of Zero for a identity column, when table has text columns marked as replicate_if_changed. Workaround Description  Mark explicitly the table for replication with sp_setreptable.

CR:336575

CR Number:   336575 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   athena beta 2 Fixed Version Build Resolution Date Closure Code (If Appropriate) athena 24 Oct 2003 Fixed Description Clicking 'Generate Mapping' icon does not create mappings between the element and source object To reproduce: 1) Generate XML model from project.pdm (do not select 'generate mapping' option) 2) In the XML model, create a datasource with project.pdm selected as the model 3) On the mapping tab, associate this datasource to the 'employee' element 4) Add the employee table as an element source 5) Select the Attribute Mapping tab and click on the 'Generate Mapping' icon Note: No changes are made

CR:336578

CR Number:   336578 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2004 Fixed Description The error 923 will be raised up to 16 times, followed by the error 4402 if a user tries to select from a view that reads a table in a different database that is set up for DBO use only.

CR:336620

CR Number:   336620 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2006 Fixed 06 Feb 2006 Fixed 21 Feb 2006 Fixed 06 Mar 2006 Fixed 10 Apr 2006 Fixed 22 Mar 2006 Fixed Description Occasionally, if there is UNION in VIEW in a query, Abstract Plans cannot be generated if the same table is referenced both inside and outside the view.

CR:336646

CR Number:   336646 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2003 Fixed Description On the windows platform, xpserver commands do not execute in the context of the ASE user as they do on unix.

CR:336789

CR Number:   336789 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) 08 Dec 2003 Fixed 08 Mar 2004 Fixed Description Add 'License' field on Server Properties to display edition and enabled licensed features. For example, 'Enterprise Edition, Java Services" means the ASE is an Enterprise Edition, with Java Services enabled.

CR:336846

CR Number:   336846 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) 13 Jan 2004 Fixed Description CHECKSTORAGE thread could not send FAULT message (error -3). Increase the memory per worker thread. This message gets displayed on the console but does not get printed in the ASE errorlog.

CR:336858

CR Number:   336858 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) 04 Nov 2003 Fixed 14 Aug 2004 Presently Not Targeted For Any Future Release Of This Product Description On Sun Solaris, in rare circumstances, Adaptive Server may hang as a result of ASE threads deadlocking on mutexes due to signal delivery. Workaround Description  Using traceflag 1633 instead of 1632 has helped the two reporting sites avoid this problem. However, this is not guaranteed to workaround the problem. Note: traceflag 1699 as mentioned in the repro section is NOT a workaround.

CR:336870

CR Number:   336870 Product Name:   SQL Remote for Adaptive Server Enterprise Product Component:   SQL Remote for Adaptive Server Enterprise Status:   Closed OS:   Microsoft Windows 2000 Original Version:   8.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.1 1694 14 Nov 2003 Fixed 9.0.0 1239 14 Nov 2003 Fixed 8.0.3 4839 14 Nov 2003 Fixed 8.0.2 4344 14 Nov 2003 Fixed Description As of EBF 10911, Rep Server 12.5 DSI will pack "is NULL", instead of "=NULL". when a value of a column is NULL in a where clause. However, the syntax of "column_name IS NULL" was not supported by SSQueue, causing the error "Unsupported syntax ...". This problem is now fixed by supporting the new syntax.

CR:336886

CR Number:   336886 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2004 Duplicate Description The new cast() function, though described in the Whats New document, is not documented with the other functions in the 12.5.1 Reference Manual vol 1.

CR:336921

CR Number:   336921 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2003 Fixed Description Running xmltract() or xmltest() with the xpath query : "/*[*]", may cause a server to stacktrace.

CR:337106

CR Number:   337106 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2004 Fixed 02 Feb 2004 Fixed Description Message 17230, "You must be the System Administrator (SA) or the Database Owner (dbo) to execute this procedure." is incorrectly raised when a DBO aliased user executes sp_dbcc_delelehistory.

CR:337398

CR Number:   337398 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) 11 Dec 2003 Fixed Description sp_helptext will truncate trailing spaces when displaying the source text from syscomments. Workaround Description  use defncopy -or- create a modified version of sp_helptext, one is available at /usr/u/ts/cases/10942000s/10942560/sp_helptext2

CR:337405

CR Number:   337405 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 Dec 2003 Fixed 24 Dec 2003 Fixed 27 Jun 2006 Not a Bug Description Sub-optimal performance may result when executing a SELECT with OUTER JOIN and ORDER BY because a potentially useful index in the outer table is not chosen to avoid using worktable for the sorting.

CR:337406

CR Number:   337406 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2003 Fixed 26 Nov 2003 Fixed Description There was a problem where servers with user-created tempdbs would generate SEGVs upon reboot after changing the default sort order. This occurs while commiting the transaction under rec_system_ix(). User-created tempdbs should not be rebuilding indices due to a sort order change.

CR:337444

CR Number:   337444 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) 29 Oct 2003 Fixed 27 Jan 2006 Fixed Description Database will be able to reallocate space for "for load" database. It is used only after "create database for load", when user must re-create the space allocations and segment usage of the database being loaded from a dump.

CR:337452

CR Number:   337452 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) 18 Dec 2003 Fixed 18 Dec 2003 Fixed Description ASE server stacktrace sometimes when processing the following query: select cast(int) = 1

CR:337499

CR Number:   337499 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2004 Fixed Description CIS: create proxy table gives syntax error when the source table has an ASE reserve word and the remote server does not support quoted identifier.

CR:337538

CR Number:   337538 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2004 Fixed 02 Apr 2004 One-off Provided Description The scope of the fix for CR 316222 is extended such as it includes the drop of temporary definition time and partitioned tables. Furthermore this optimization is applied as far as the drop operation is not done under the scope of a user's defined transaction context, irrespectively to the setting of the DDL-IN-TRAN database option in the tempdb database(s).

CR:337592

CR Number:   337592 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) 02 Feb 2004 Fixed Description Running dbcc upgrade_object() on an object which is renamed using sp_rename can cause messages to be raised using the 'old' name of the object.

CR:337611

CR Number:   337611 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) 10 Nov 2003 Fixed Description The sybsybtax database used by sp_syntax is missing entries for new functions added in 12.5.0.3 (len, left, day, year, etc.)

CR:337629

CR Number:   337629 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2003 Fixed Description When unichar/univarchar data is converted to varbinary and stored in a column, any trailing null bytes (0x00) are trimmed. A subsequent conversion back to unichar/univarchar may fail if the original unichar/univarchar data, when viewed as a byte-stream on the given platform, contains trailing null bytes. This typically the case for ASCII data on a little-endian platform, since Unicode characters U+0000..U+007F are seen as the byte-streams 0x00 00.. 0x7F 00 on little-endian platforms.

CR:337672

CR Number:   337672 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2007 Fixed 20 Dec 2006 Fixed 03 Jan 2007 Fixed Description The -I switch for srvbuild, srvbuildres and sqlloc on Unix platforms does not work and the interfaces file in the default location is always used.

CR:337689

CR Number:   337689 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) 16 Dec 2003 Fixed Description In rare circumstances, Adaptive Server may hang as a result of engine process self deadlocking on malloc mutex. Workaround Description  Sorry, no good workaround. Running ASE in UTC (a good idea anyway) would likely avoid this. Also, you should get to the root of the timeslice / infected with to avoid this.

CR:337749

CR Number:   337749 Product Name:   SQL Remote for Adaptive Server Enterprise Product Component:   Extraction Utility Status:   Closed OS:   Microsoft Windows 2000 Original Version:   8.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.1 1680 31 Oct 2003 Fixed 9.0.0 1234 31 Oct 2003 Fixed 8.0.3 4826 31 Oct 2003 Fixed 8.0.2 4337 31 Oct 2003 Fixed 8.0.1 3137 31 Oct 2003 Fixed 7.0.4 3502 31 Oct 2003 Fixed Description If ssxtract was run with the -l command line option, to set the isolation level of the connection pulling data from the consolidated database, the error "Incorrect syntax near the keyword 'TEMPORARY'" would have been reported, and the isolation level of the connection would never have been changed. This has now been fixed. Workaround Description  If the isolation level of 1 is desired then simply not specifying this switch or simply ignoring it will suffice. [similar extensions of argument apply to isol. level 0] BUT If isolation level 2 or 3 is required, one would need to code the begin e

CR:337760

CR Number:   337760 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 233 is raised when inserting a null value into a proxy table that maps to a base table column that has a default, as the proxy table doesn't automatically import the default definition. Workaround is to add a default to the proxy table. Workaround Description  Add a default to the proxy table

CR:337892

CR Number:   337892 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   athena Fixed Version Build Resolution Date Closure Code (If Appropriate) athena 10 Nov 2003 Fixed Description In a xsd XML model go to the tab attribute of an element PS Click on the customize column and filter tool In this window, the attribute type is missing

CR:337902

CR Number:   337902 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2003 Fixed 07 Nov 2005 Not a Bug Description Sybase Central doesnt report database segment usage for a device when the device only has a default segment on it. It is corrected in ASEP 12.5.2

CR:337920

CR Number:   337920 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) 09 Dec 2003 Fixed Description Error message #11740 still exists in sysmessages.

CR:337931

CR Number:   337931 Product Name:   Adaptive Server Enterprise Product Component:   SQL Advantage Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2003 Presently Not Targeted For Any Future Release Of This Product 05 Nov 2003 Fixed Description Killing a connection to SQLAdvantage: produces a pop-up saying "Internal Error - contact System Admin. or Sybase Tech. Support.

CR:337934

CR Number:   337934 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) 22 Jan 2004 Fixed Description If a view contains a scalar aggregate and is used as the inner member of an outer join, then stacktrace (signal 11) could occur if the view is not materialized. This has been fixed by materializing all such views.

CR:338053

CR Number:   338053 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2009 Insufficient priority to fix Description Feature request to have ASE support "before" triggers as ASA does.

CR:338077

CR Number:   338077 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2004 Fixed Description Enhancement to improve the performance by tuning the local cache partition number for the default data cache.

CR:338151

CR Number:   338151 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) 14 Nov 2003 Fixed Description A user with SSO role incorrectly receives a permission denied error when executing the stored procedures sp_addalias or sp_dropalias.

CR:338157

CR Number:   338157 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2003 Fixed 11 Nov 2003 Fixed 13 Nov 2003 Fixed Description ASE 12.5.1 does NOT support XPath functions. However, an XPath query with function operator gives incorrect error message 'insufficient memory' instead of 'XPATH: Parenthesized expression not supported'.

CR:338189

CR Number:   338189 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 Nov 2003 Fixed 02 Apr 2004 Fixed Description If ASE receives an attention from client during executing EXECUTE IMMEDIATE statement, this can lead to stack overflow which results in ASE shutdown.

CR:338213

CR Number:   338213 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) 14 Nov 2003 Fixed 17 Apr 2009 Fixed Description Query like : SELECT <column list>, (SELECT column from view) FROM ... may return incorrect result if subquery selecting from the view returns empty set and the view definition includes UNION operator.

CR:338249

CR Number:   338249 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2003 Fixed 21 Nov 2003 Fixed Description View materialization does not benefit from transitive closure SARG generation. Worktable generation may not have as good performance as expected.

CR:338331

CR Number:   338331 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2004 Fixed Description Incorrect monitor statistics may be reported on a table if a clustered index is dropped and recreated on that table.

CR:338337

CR Number:   338337 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 Nov 2003 Fixed Description Running xmlextract()queries with xpath parameter '//*' causes a stacktrace.

CR:338357

CR Number:   338357 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Fixed Description CIS: DROP TABLE <proxy_table> may drop the remote table when the local server is a HA node and the remote server is not.

CR:338359

CR Number:   338359 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) 14 Nov 2003 Fixed Description View with CASE expression may be materialized even if there is no need for a materialization.

CR:338387

CR Number:   338387 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2004 Fixed 28 Jun 2005 Fixed Description Adding a threshold count for the HS alarms to fire after x consecutive times a condition is met

CR:338523

CR Number:   338523 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2003 Fixed 20 Nov 2003 Fixed 21 Nov 2003 Fixed 25 Dec 2003 Fixed Description In rare circumstances, running a Java native call produces a hard fault in the ASE Java Subsystem. The message "current process infected with 11" in the module 'ubffree' together with a stack trace which includes GarbageCollection modules may be reported in the error log on Unix platforms.

CR:338531

CR Number:   338531 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2004 Presently Not Targeted For Any Future Release Of This Product 31 Aug 2004 Fixed 06 Oct 2004 Fixed Description Enables XML Services feature on HP-UX 32 and 64 bit platforms. Feature description and usage can be found in the release documentation. Workaround Description  NA.

CR:338714

CR Number:   338714 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2004 Fixed Description srvbuild and srvbuildres could not recognize veritas volumes bound to rawdevice interface on Linux.

CR:338877

CR Number:   338877 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) 24 Jan 2007 Bundled Request Description Feature request for support of devices larger than 32 GB.

CR:338900

CR Number:   338900 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2004 Fixed 14 Jan 2004 Fixed 23 Feb 2004 Fixed 04 Mar 2004 Fixed Description Add support for Real Time Messaging Systems. This licensed feature integrates ASE with messaging systems such as TIBCO JMS. The support in ASE Plug-in includes the management of subscriptions, messaging service providers, and login mappings. Use"Messaging Services" folder to access the feature.

CR:338919

CR Number:   338919 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2004 Fixed 07 Jan 2004 Fixed Description MacOS X: Rework processor synchronization routines to be compatible with G5 hardware. Prior to this change, 2-engine configurations caused problems when running on G5 systems.

CR:339092

CR Number:   339092 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2004 Fixed Description langinstall syntax in 12.5 and 12.5.1 documentation has references to -I twice.

CR:339139

CR Number:   339139 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2004 Fixed Description XPserver: Request improvement in XPserver error reporting when attempting to open Extended Procedure library files. Workaround Description  Create utility as described in: ~ts/cases/20331000s/20331310/hp_shl_load_example

CR:339173

CR Number:   339173 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2004 Fixed Description Missing New SQL command option for Update Statitstics: sampling=percent option in Reference Manual

CR:339176

CR Number:   339176 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2003 Fixed Description SAG Doc Fig 8-1 error, ASE does not support direct conversion between cp850 and cp1252 TABLE 8-1 is correct.

CR:339177

CR Number:   339177 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) 15 Dec 2003 Fixed Description A command that does a partially logged operation (like SELECT INTO or bulk copy) in a temporary database may be blocked for an unnecessarily long period of time when the log is being automatically truncated. Workaround Description  None.

CR:339211

CR Number:   339211 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2004 Fixed 05 Jul 2004 One-off Provided Description A deadlock may be reported between a session creating a table with declared defaults and another session dropping such a table. The deadlock call stacks will show for the former session the module 'crt_main' and for the latter session the modules 'dropo', 'delcol' and 'dropo' again. Workaround Description  Not to use default

CR:339328

CR Number:   339328 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) 13 Nov 2003 Fixed 14 Nov 2003 Fixed Description Omni is ignoring the DBCC CIS setcap settings for cap_id 124 (CONVERT function).

CR:339331

CR Number:   339331 Product Name:   Adaptive Server Enterprise Product Component:   SQL Advantage Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2006 Insufficient priority to fix Description Provide the capability for SQL Advantage to use HA failover to reach a secondary ASE if the primary ASE has failed over. The capablility being requested is similar to the isql -Q support.

CR:339411

CR Number:   339411 Product Name:   Adaptive Server Enterprise Product Component:   asecfg Status:   Open OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_displayaudit to show audit options for sybase_ts_role

CR:339436

CR Number:   339436 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 Dec 2003 Fixed Description The error "ct_options(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect" may be raised and the connection terminated, when calling the ct-library function ct_options(connection, CS_SET, CS_OPT_AUTHON, "<rolename>", rolename_len, NULL), to enable a role after a connection is established.

CR:339459

CR Number:   339459 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2004 Fixed Description Selecting from a view defined with UNION ALL clause may sometimes return error 421 " TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT". This happens when the view returns TEXT or IMAGE fields and requires materialization.

CR:339501

CR Number:   339501 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Fixed 30 Jan 2004 Fixed Description Configuration parameter 'disk i/o structures' is supported in sp_monitorconfig. The sp_monitorconfig column 'Reused' has been changed to 'Num_Reuse' to provide the number of reuse requests as opposed to the earlier 'Yes/No' indicator of reuse requests.

CR:339590

CR Number:   339590 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 May 2004 Fixed Description Error 225 (Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization) is encountered for Select into queries when the donor table involves identity and aggregates. Workaround Description  If you want a straight data copy then 1) copy the table as is into new table 2) use a delete to remove the rows using the aggregate that you would have used in a select into.

CR:339713

CR Number:   339713 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2004 Fixed 16 Feb 2004 Fixed 01 Mar 2006 Fixed 23 Mar 2004 Fixed Description CIS: In a transaction, SELECT from <rpc table> after an 'execute' or 'sp_remotesql' call is issued to a remote procedure which insert/update/delete the same table may result in blocking at the select call. The is resolved by removing the changes introduced in CR 321261. The fix creates a new traceflag 11228 for CR 321261. This traceflag has to be turned on to allow create table command in the remote procedure. Workaround Description  The suggested workarounds would be : 1) Map the remote procedure raj_proc as a rpc proxy table and replace the statement exec("remoteASE.tempdb..raj_proc") with "select * from rpc_table". or 2) Use exec call for the select-rpc call instead.

CR:339731

CR Number:   339731 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 Nov 2003 Fixed 20 Nov 2003 Fixed Description Executing a stored procedure whose name has been stored into a T-SQL variable of CHAR datatype may fail and raise an unexpected 2812 error stating the stored procedure was not found whereas it actually exists in the database. Workaround Description  Declare the variable as varchar : declare @p varchar(200) select @p = "sp_who" exec @p

CR:339767

CR Number:   339767 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2005 Fixed Description Progress message for sp_dbcc_deletehistory should be changed because the current message is inconsistent with the behavior.