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

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

CR:365418

CR Number:   365418 Product Name:   Adaptive Server Enterprise Product Component:   mscs_ha Status:   Closed OS:   HP-UX Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2006 Insufficient priority to fix Description Certify ASE HA against HP MC/SG 11.15 Workaround Description  Do the following manually: sp_companion prepare_failback cmmodpkg -e -n PrimaryNode Pkgname cmrunpkg -n PrimaryNode Pkgname sp_companion resume

CR:365458

CR Number:   365458 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2004 Fixed 28 Oct 2004 Fixed Description Change default for "enable unicode conversions" from 0 to 1.

CR:365485

CR Number:   365485 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) 03 Sep 2004 Fixed Description The problem is in ASE 12.5.1: System Administration Guide, Chapter 26:Checking Database Consistency, Checking consistency of databases and tables. Part of the problem doc listed below, we aslo see the same problem in ASE 12.5 Chapter 25. The doc has a sentence stating: "At least two workspaces to use during the check operation. See "dbccdb workspaces" in Chapter 59, "dbccdb Tables" in the Reference Manual." There is no Chapter 59.

CR:365499

CR Number:   365499 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 May 2005 Fixed Description sp_dbcc_summaryreport displays milliseconds in the end time but not in the start time Workaround Description  Ignore the output?

CR:365505

CR Number:   365505 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2006 Fixed Description In ref. manual, sp_dbcc_updateconfig examples numeric values need quoted. In SAG, the examples are correct.

CR:365506

CR Number:   365506 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2006 Fixed Description sp_dbcc_createws default workspace name doe not have the second underscore.

CR:365510

CR Number:   365510 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) 15 Sep 2004 Fixed Description Provide an example to illustrate -s option of ISQL

CR:365530

CR Number:   365530 Product Name:   Adaptive Server Enterprise Product Component:   SDBE Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Fixed Description In the Database Expert Performance Manager, the bar diagram is lost after locking it when switching among database statistics. But line diagram is not lost.

CR:365617

CR Number:   365617 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) 01 Sep 2004 Fixed 10 Sep 2004 Fixed Description When a database is upgraded to 15.0, newly added column syscomments.partitionid will appear to contain NULL even for rows where it should have a valid partition ID. This causes display problems for certain queries. A workaround exists; refer to the workaround section of this report for details. Workaround Description  Allow updates to system tables, then perform this update in the affected database(s): update syscolumns set offset = -5 where id = object_id('syscomments') and name = 'partitionid' and offset = -3

CR:365624

CR Number:   365624 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2004 Fixed Description Syconfig.exe doesn't use the specified %SYBASE% environment variable. Instead, it uses the value from registry HKLM\SOFTWARE\SYBASE\SQLServer\RootDir.

CR:365627

CR Number:   365627 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2006 Fixed Description sp_dbcc_statisticsreport references SAG incorrectly. It should be in Chapter 13 under the dbcc_types table write-up in Reference Manual

CR:365631

CR Number:   365631 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2006 Fixed Description Ref. Manual Error: sp_dbcc_summaryreport, example 3

CR:365637

CR Number:   365637 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guides - All Platforms Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2012 Added to user documentation Description Requested Doc id 1013610 more clear.

CR:365657

CR Number:   365657 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2004 Third Party Problem 08 Jul 2005 Fixed Description On Solaris, with ASE 12.5.1 ESD#2 or later, using tli type entries in interfaces file used by ASE, when a spid within ASE is killed ('kill <spid>') it could result in ASE hang. Running pstack (unix command) on ASE pid would show functions kill_proc, drop_connection, tli_nclose, _tx_getinfo, _t_do_ioctl, ioctl on the stack. This problem is due to Solaris bug # 4924525. If you are using tli type entries in the interfaces file that is used by ASE contact SUN quoting Sun BugID 4924525 and request a patch (110955-05 or later) to fix the problem. Workaround Description  Using TCP type for the ASE entry in the interfaces file on the ASE site.

CR:365694

CR Number:   365694 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jul 2005 Not a Bug Description Feature Request Shared JVMs within ASE Request Title: Implement shared system and database level JVM processes within ASE Product Relevancy: ASE 12.5+ and ASE 15 Request Description: This request is to implement a JVM feature within ASE that would support shared static java attributes. The current implementation of Java within the ASE database is such that each database connection requires its own instance of the JVM process. Unfortunately, this implementation prevents the full support of static attributes in accordance with the Java specifications. Implementation: Ideal Approach - Ideally the implementation would consist of a single JVM running at the server level, utilizing a port of ASE threads as a "native" threading model. Java supports substitution of threading models since 1.1.81. This would allow for a 1:1 mapping of the database threads to the JVM threads. The hierarchy of class loaders would provide for application level "sandboxing". For example: a "server level" class loader (loading the classes at the master database level (not visible to everyone), followed by the "shared class loader" loading all the classes at the sybsystemprocs level, and a class loader at the database level inheriting the sybsystemprocs class loader and loading the classes installed in this database. Switching the database context, would append the java class loader references for the new database to the class loader chain (if it is not there already). A new configuration parameter for the database will determine the order of the class loader overrides (parent first/child first). Alternative Approach - Alternatively, the implementation would consist of a configurable number of sharable JVM instance (similar to how named caches are implemented). This would provide the ability to have logical groupings of JVM's to provide specific functionality in addition to providing for a sufficient number of JVM's to by-pass any potential JVM threading limitations. Specified classes (or an entire database of classes) could be bound to a shared JVM. Rules would need to be defined to handle naming conflicts when trying to load the same class name from two different databases or the classes will need to be restricted to a single location (i.e. database). These shared JVM instances would coexist with the current connection-oriented JVM implementation. Classes not bound to a shared JVM would act as they currently do (execute within their own running JVM processes). Overall Benefits: Performance and Manageability (Administration) Specific Benefits: If we can get this working in ASE in accordance to java specifications, this will resolve a few extremely important issues and outstanding enhancement requests (customizable Identity implementations, Global Variables, etc) that were made through ISUG and also exist as CRs. Customizable Identity Implementation: Through the use of static object attributes, it would be possible to implement functionality which assigns (and reserves) sequential values similar to the ASE Identity but be flexible enough to support customization. The functionality could also be wrapped in java functions making it possible to assign using batch INSERT/SELECTs. Example #1 - A java function could be coded to identify and reserve the next sequence number for a table. The function call might be called next_sequence (<table name>, "reserve"). Example #2 - A java function could be coded to also partition the values based on the application requirements. The function call might look like next_sequence (<table name>, "reserve", "Cumberland"). Example #3 - The same java functions could be coded to also backfill gaps in sequences instead providing the "one-up" (max+1) values. In other words, when assigning the next sequential value, it would scan the table to identify the next available gap in the sequence. Global Variables: Through the use of static object attributes, it would be possible to implement global variables. The global variables would not just be simple variables, but could also include structures and arrays. This has been a long awaited request. There have been many requests for this feature in ISUG and in CRs (Feature Requests). Real Time Messaging Services (RTMS): If shared JVM's would optionally load classes on startup, hence invoking constructors, this would allow some JVM's to function as running business processes somewhat detached from a user spid. This may be really useful in view of RTMS. The process could start looking at a message bus for pending messages upon server boot. 1 see JNI Programmer's Guide and Reference on the Sun's java website. Workaround Description  *** Wednesday, September 01, 2004 9:02:14 AM *** cooperg *** N/A

CR:365704

CR Number:   365704 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) 28 Feb 2006 Fixed 16 Mar 2006 Reservation Made 08 Mar 2007 Fixed 29 Mar 2006 Insufficient priority to fix Description Provide a new T-SQL built-in, INDEX_NAME(), to get the name of an index, given the ID of the index and the IDs of the database and the object on which it is defined. A number of MDA tables return the database ID, object ID and index ID trio. This built-in would simplify the process of analysing these MDA tables for index usage.

CR:365756

CR Number:   365756 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2004 Presently Not Targeted For Any Future Release Of This Product 08 Nov 2004 Fixed 08 Nov 2004 Fixed Description In a HA environment the failover and failback operations may take a long time depending on the workload on the server at that instance.

CR:365785

CR Number:   365785 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) 14 Oct 2013 Insufficient priority to fix Description New feature request to support CALL statement to invoke a stored procedure.

CR:365788

CR Number:   365788 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2004 Fixed 23 Sep 2004 Fixed Description The error 12309, "Expanding update on object '<value>' in database '<value>' cannot succeed on page <value>, ... This is an internal error." may be reported on a Data Only Locked table during the execution of DML commands when the given table has a lot of forwarded rows. Alternatively the error 644 "Index row entry for data row id (<value>, <value>) is missing from index page <value> ... Drop and re-create the index." may be reported. Workaround Description  Avoid the presence of forwarded rows!

CR:365789

CR Number:   365789 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2004 Fixed 29 Oct 2004 Fixed 29 Oct 2004 Fixed Description In rare circumstances, an 834 error, "Illegal attempt to clean buffer" together with a stack trace than includes the modules 'dbt_get', 'dbt_removeall' and 'bufdbclean', may be reported in the error log for one or more buffers in a user-defined temporary database if an attempt is made to access this database before it has been completely created. Workaround Description  Avoid any access to user temporary databases while ASE is still booting. Use sp_dbrecovery_order to ensure that user temporary databases are recovered early to reduce the likelihood. Choose hard binding to user temporary databases instead of default soft binding (see sp_tempdb).

CR:365796

CR Number:   365796 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2004 Fixed Description CIS: Occasionally, the messages "uppushaffinity: kpid <id> affinity stack overflow", and "Attach external xact failed: astc_attach failed ", may be reported during frequent DTM transactions involving remote tables.

CR:365809

CR Number:   365809 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for use of "self-healing" Hamming codes for critical dbinfo values

CR:365822

CR Number:   365822 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2005 Fixed Description Occasionally, the message "current process infected with 11" in the module 'omni_adjust_eops' together with a stack trace which includes the modules 'omni_opt_select' and 'omni_code_gen_estep' may be reported in the error log if there is an invalid subtraction between two DATETIME columns with some subqueries involved Workaround Description  You should use datediff to subtract two dates...

CR:365825

CR Number:   365825 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2004 Fixed Description CIS: To some non-ASE backends, inserting NULL values into the remote columns with DATE/TIME datatype will cause the local ASE session to hang

CR:365827

CR Number:   365827 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) 22 Oct 2004 Fixed Description The message "current process infected with 11" in the module ind_obj_seg_check() together with a stack trace which includes the module catcheck() will be reported in the errorlog if DBCC CHECKCATALOG finds an entry in sysindexes without a matching row in sysobjects. Workaround Description  Manually delete rows in sysindexes for ids that do not exist in sysobjects

CR:365884

CR Number:   365884 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) 08 May 2009 Duplicate Description New feature request to allow user-defined function to specify SQL statement and return Table Result Set.

CR:365988

CR Number:   365988 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description After minimally logged commands like "alter table" user can not dump transaction log, has to dump a whole database. Customer would like to have a feature request such as a "with log" option for the minimally logged commands so he has greater control of the logging:

CR:366032

CR Number:   366032 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) 31 Aug 2006 Fixed Description The DBCC command PRSQLCACHE will print the whole text of the statement cached as opposed to its first 255 characters only.

CR:366101

CR Number:   366101 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2004 Fixed Description Load database with 'listonly' option fails when using a remote Backup Server. Workaround Description  None.

CR:366111

CR Number:   366111 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2004 Fixed 27 Sep 2004 One-off Provided Description The open server routine srv_xferdata will report the error "16324/10/0: srv_xferdata(): data for column no: 1 cannot be NULL" when processing a null return parameter from an ASE RPC. Workaround Description  Initialize the output parameter to a non-NULL value like 0 or return a non-NULL value. Or, set CS_VERSION_120 in your Open Server.

CR:366163

CR Number:   366163 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to have checkstorage do additional checking to reduce or eliminate the number of spurious errors reported.

CR:366164

CR Number:   366164 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2004 Fixed 08 Oct 2004 One-off Provided Description If extended cache is enabled on Linux 32bit platform, then under highly concurrent system if a page is being destroyed and if it happens that the same page is being wriiten to disk from secondary cache, the page may be wriiten to master device config block. This will cause config block to be corrupted. Furture reboot of the server will fail. Workaround Description  There is no clean workaround for this corruption. It's safe to save the config block of the master device and then if the corruption happens one can replace the master device config block with the good data. e.g: To save a good copy of the config block: dd if=master.dev of=config.good bs=2048 count=1 To fix the corrupt config: dd if=config.good of=master.dev bs=2048 count=1

CR:366206

CR Number:   366206 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2004 Fixed 10 Sep 2004 Fixed Description When a database has been upgraded from version 12.5 to 15.0, sp_helpartition will display error 515 when used on an index whose sysindexes.partitiontype is null.

CR:366239

CR Number:   366239 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2004 Fixed Description IQ does not support the IDENTITY keyword, so CIS will no longer send create table statements containing that keyword.

CR:366285

CR Number:   366285 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2004 Fixed Description The installer incorrectly set the "load library path" and PATH environment values for the Enhanced Full Text Search in $SYBASE/SYBASE.sh file.

CR:366290

CR Number:   366290 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2004 Fixed Description The warning "Logical Process Manager Error: Failed to get a row from sysattributes table, in etc__getexeattr(), instance 1." may be printed in the errorlog if an application is bound both to a temporary database and an execution class. Workaround Description  *** Wednesday, September 08, 2004 1:44:32 PM *** cooperg *** Don't use the hard binding on the application to the second temp db.

CR:366336

CR Number:   366336 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2004 Fixed Description The error 12934 "Page <value> of object <value>, indid <value> undergoing change ... retry the command later." may be reported when running DBCC TABLEALLOC or DBCC CHECKALLOC in fix mode, resulting in the reported page being incorrectly deallocated.

CR:366392

CR Number:   366392 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2004 Fixed Description Excessive CPU usage by the HK_CHORES process may occur when distributed transactions have been used (XA, DTC or ASE distributed transactions) and the configuration parameter "dtm detach timeout period" is set to a non-zero value. Workaround Description  Set "dtm detach timeout period" to 0. This disables checking of detached transactions by housekeeper altogether.

CR:366444

CR Number:   366444 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2004 Fixed 27 Oct 2004 Fixed Description For cross platform loaded database (across same endian architecture), the user defined stored procedures, triggers and defaults remain valid across the dump. Addresses the errors 2821, 2812 and 223.

CR:366447

CR Number:   366447 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Library Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2004 Fixed 29 Sep 2004 Fixed Description Allow users without the sa_role role to execute recording scripts in the Historical Server on all platforms except Microsoft Windows. Users of the Historical Server and Monitor Client Library must have the sa_role role when running these applications on the Microsoft Windows platform.

CR:366497

CR Number:   366497 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2004 Fixed 16 Sep 2004 Fixed 23 Nov 2004 Insufficient priority to fix Description Queries generating work tables when executed in user defined temporary databases bound to a named cache, may fail with message "current process (<value>) infected with 11" in module 'bufdlink', or 'des_add_dirty_chain_elmt'; this is another variation of the bug reported under CR 360414. Workaround Description  Do not bind user temporary databases and system 'tempdb' to different named caches, OR have all user tempdbs and system 'tempdb' bound to the same named cache when ASE is booted. Do not make the bindings on the fly long after ASE is started. Even with no user temporary database configured if one binds the system 'tempdb' database to a named cache on the fly long after ASE is started then the same problem may occur since existing plans would only have a reference to the default data cache hence needing to add a new reference that may vanish under us (memshrink issue).

CR:366514

CR Number:   366514 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2004 Fixed Description The error "Server '<servername>', Procedure 'sp_modifylogin', Line 489: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database." will be raised when the stored procedure sp_modifylogin is used to change the login script in a HA environment.

CR:366596

CR Number:   366596 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2004 One-off Provided Description Provided instrumented traceflag support to customer to insert rows into sysloginroles, syssrvroles and other catalogs that have special SSO_ROLE privilege checking.

CR:366659

CR Number:   366659 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2004 Fixed Description The Yields, DiskIOChecks, DiskIOPolled and DiskIOCompleted columns should be added to the monEngine Monitoring Table to report the number of times the engine yielded to the OS, the number of checks for asynchronous I/O, the number of times I/O was polled for, and the number of times this poll showed that I/O completed, respectively.

CR:366692

CR Number:   366692 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) 23 Jan 2005 Fixed Description Feature request to have dbcc tune(cpuaffinity) command report failure rather than silently fail on platforms that don't support affinity.

CR:366696

CR Number:   366696 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2004 Fixed Description The SuspendedProcesses column of the monOpenDatabase Monitoring Table should report 0 when no processes are suspended rather than NULL.

CR:366757

CR Number:   366757 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2004 Fixed 04 Oct 2004 Fixed 31 Mar 2005 Fixed 20 Jan 2005 Fixed Description DDLGen support for Encrypted Columns feature in ASE.

CR:366791

CR Number:   366791 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 Sep 2004 Fixed 07 Oct 2004 Fixed Description On Red Flag Advanced Server release 4.1, when the LANG variable is set to zh_CN.GB18030, dataserver/isql command fail.

CR:366801

CR Number:   366801 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2004 Fixed Description Under rare circumstances the message "current process infected with 11" in the module 'pipe_sqltext' together with a stack trace which includes the module 'sqlpars' may be reported in the errorlog when "enable monitoring" (or "sql text pipe active") configuration parameter is activated.

CR:366811

CR Number:   366811 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2006 Fixed Description The stored procedure sp_dboption shows an undocumented and unused option 'disable alias access'. It has been removed.

CR:366822

CR Number:   366822 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3 ESD#2 04 Oct 2004 Fixed Description When SPID=0 is specified as a search argument to any of the Monitoring Tables the messages "ubo_object_from_slot:Pss Invalid slot id 0" and "An internal memory management error has occured. Error code: Invalid slot id." are written to the ASE errorlog followed by a stacktrace showing the ubo_object_from_slot() function as the instigator. These messages are harmless but should not be produced.

CR:366899

CR Number:   366899 Product Name:   Adaptive Server Enterprise Product Component:   SQL Expert Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2007 Third Party Problem Description The SQL Expert Database Explorer does not display the values of binary, varbinary and timestamp datatypes correctly.

CR:366900

CR Number:   366900 Product Name:   Adaptive Server Enterprise Product Component:   SQL Expert Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Fixed Description After a SQL query is optimized, the SQL Formatter incrrectly places the 'SET' statement on the same line as the SQL query.

CR:366904

CR Number:   366904 Product Name:   Adaptive Server Enterprise Product Component:   SQL Expert Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Fixed Description The scroll bar in the SQL Expert tree view does not always automatically move when a node in the tree is expanded.

CR:366905

CR Number:   366905 Product Name:   Adaptive Server Enterprise Product Component:   SQL Expert Status:   Closed OS:   Windows XP Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Fixed Description Sometimes when the monitored ASE is restarted while Database Expert is monitoring it and the user the nexits from the Database Export program, Database Expert will generate a message saying "Sybase Database Expert has encountered a problem and needs to close."

CR:366913

CR Number:   366913 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) 25 Oct 2004 Duplicate Description Incorrect SQL transformation for SQL with syntax = null. SQL was incorrectly changed to >= null and <= null.

CR:366914

CR Number:   366914 Product Name:   Adaptive Server Enterprise Product Component:   SDBE Status:   Closed OS:   Windows XP Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Fixed Description When the Database Expert Lock Chart button is clicked the chart is displayed with an incorrect time label.

CR:366953

CR Number:   366953 Product Name:   ASE Replicator Product Component:   DDBAdmin Status:   Closed OS:   Generic Original Version:   12.5.2.302P1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3.303 22 Sep 2004 Fixed Description ASE Replicator: A call to sp_addreplicateart fails with "Incorrect syntax near '%'". Workaround Description  1 - stop the Replicator 2 - re-start the Replicator using the debug build 3 - add the replicate article as you did before -- you'll still get the error, but now you'll have a script in $SYBASE/RPL-12_5/<instance>/subscriptions/add_<tbl>.sql 4 - edit the script -- find the distribution procedure, and about 2/3 of the way down you'll see the RAISERROR line: RAISERROR 20000 'Unknown image type '%1!'.', @image_type Add an additional single quote immediately before the percent sign and immediately after the exclamation mark: RAISERROR 20000 'Unknown image type ''%1!''.', @image_type 5 - stop the Replicator 6 - login to ASE as the Replicator user, and execute the edited add_<tbl>.sql script manually within your distribution database 7 - re-start the Replicator using the normal build

CR:366992

CR Number:   366992 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Open OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description LDAP/LDAPUA/SSL are not supported on all platforms. Installation release material or Product Documents need to reflect the availability of the features by platform since the features are not available on every platform.

CR:367013

CR Number:   367013 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Establish a kill command to kill a Rep Agent regardless of state

CR:367029

CR Number:   367029 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   11.5.1.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2005 Fixed Description A user who gets locked out of ASE due to failed logins will not get 'maximum failed logins' times to relogin after the account has been unlocked.

CR:367105

CR Number:   367105 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2009 Presently Not Targeted For Any Future Release Of This Product Description Enable the ability to dynamically load a floating IP address after an ASE failover for an ASE Active-Active HA configuration. Product Relevancy: ASE 12.5%2B and ASE 15 Request Description: During a failover event, cluster software can be configured to switch a floating IP address over to a different host. In an ASE Active-Active HA configuration, the floating IP address currently cannot be loaded into Active companion ASE server. This feature request is to request that the floating IP address be loaded into the Active companion (ASE 12.5%2B) or a surviving ASE server (ASE 15.0). Implementation: As part of the failover event, the OS cluster will switch the "owner" of a floating IP address to a surviving host. After the OS cluster has completed this task, it should be configured to trigger the Sybase HA scripts to execute the new ASE dynamic listeners feature within ASE to load a floating IP address. Overall Benefits: Availability and Manageability (Administration) Specific Benefits: Automated Failback (improved Availability): Failback could be automated and not require a scheduled downtime. Since a surviving ASE would "know" which connections were failed over (the connections associated with the dynamically loaded floating IP address), the process to failback would be the same as the process to failover except in conducted in reverse. The biggest (and probably only) difference would be that the connections to be failed back would be intentionally disconnected. Easier driver setup / administration (improved Manageability): Several existing 3rd party tools that connect to ASE are not HA aware and rely on underlying connectivity drivers (ODBC, JDBC, native, etc) for migrating connections. For the ASE 12.5 drivers, this usually requires setting them up with two network addresses (primary and failover). Administration could be kept simpler if the drivers did not need to be setup with the network address of each HA companion (or cluster) node. Clusters w/more than 2 nodes (improved Manageability): Although ASE 12.5 supports a two node Active-Active cluster (companion), ASE 15.0 is being redesigned to be capable of supporting more than two nodes. Therefore, administration would become more difficult if each connectivity driver needed to be configured for each node within the cluster (especially as nodes are added / dropped from a cluster). In addition, if the connectivity driver is setup with fewer number of network address than nodes in the cluster, there exists for the possibility of system outages (application downtime) and thereby reduce availability. Workaround Description  *** Thursday, September 16, 2004 8:55:25 AM *** cooperg *** N/A

CR:367128

CR Number:   367128 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) 23 Sep 2004 Presently Not Targeted For Any Future Release Of This Product Description config parameter 'memory per worker process' is not actually *per* worker process. The size of this pool is memory per worker process multiplied by number of worker processes.

CR:367186

CR Number:   367186 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2004 Fixed Description Message "infected with 11 in logcommand()" together with a stacktrace containing the modules 'logcommand', 's__altertab' and 's_execute' is printed in the errorlog when executing an ALTER TABLE statement while DDL replication for that database and statement cache are enabled. Workaround Description  I customer is not using replication (it was the case for the customer who raised the issue), deactivate the DDL replication : use test go sp_reptostandby test,"none" go Or Disable statement cache.

CR:367261

CR Number:   367261 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) 29 Oct 2004 Fixed Description The upgrade program has been enhanced to parse the text of existing stored procedures

CR:367308

CR Number:   367308 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) 31 Jan 2006 Workaround Description The "java.awt.event.MouseWheelEvent" was not instituted until Java version 1.4. Currently we use Java version: java version "1.3.1_10" Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_10-b03) Java HotSpot(TM) Client VM (build 1.3.1_10-b03, mixed mode) I tried using Java version: java version "1.4.2_03" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_03-b02) Java HotSpot(TM) Client VM (build 1.4.2_03-b02, mixed mode) And the mouse seems to function properly in Sybase Central. The customer can use this as a workaround until such time as Sybase Central supports JRE version 1.4. Workaround Description  *** Monday, September 20, 2004 7:09:13 AM *** cooperg *** The "java.awt.event.MouseWheelEvent" was not instituted until Java version 1.4. Currently we use Java version: java version "1.3.1_10" Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_10-b03) Java HotSpot(TM) Client VM (build 1.3.1_10-b03, mixed mode) I tried using Java version: java version "1.4.2_03" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_03-b02) Java HotSpot(TM) Client VM (build 1.4.2_03-b02, mixed mode) And the mouse seems to function properly in Sybase Central. The customer can use this as a workaround until such time as Sybase Central supports JRE version 1.4.

CR:367320

CR Number:   367320 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2004 Fixed Description EFTS: parser is having trouble with two russian lowercase "ya" characters in a search argument but with only one it works.

CR:367339

CR Number:   367339 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3 ESD#2 16 Feb 2005 Fixed 29 Jun 2005 Bundled Request Description For ASE running on linux 32bit system, 'disk init' on a tmpfs filesystem based file device fails with the message "Device activation error. PHYSNAME '<filename>' may be incorrect". ASE errorlog also reports "kernel dopen: open '<filename>', Invalid argument". Workaround Description  use traceflag 1641

CR:367364

CR Number:   367364 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Feb 2008 Added to user documentation Description P&T Guide doesn't mention anything about the Procedure Recompilations or Statement Cache output in the Procedure Cache Management output from sp_sysmon.

CR:367431

CR Number:   367431 Product Name:   Adaptive Server Generic Docs Product Component:   Quick Reference Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Dec 2005 Fixed 10 Jan 2006 Fixed Description Func and Function are not reserved words in ASE anymore, but are still being referenced as reserve words in the ASE 12.5.1 Quick Reference Guide and the Migration guide.

CR:367438

CR Number:   367438 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) 25 Oct 2004 Fixed 27 Oct 2004 Fixed Description This change incorporates some cosmetic changes to the Job Scheduler Property and Wizard windows. The user will no longer see any borders and some visual controls have moved to other locations, for example: fields in Job and Schedule wizards were moved from the second to the first page of the wizard.

CR:367477

CR Number:   367477 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) 11 Aug 2009 Fixed 04 Nov 2008 Presently Not Targeted For Any Future Release Of This Product 20 Aug 2009 Not a Bug 18 Nov 2009 Added to user documentation 11 Aug 2009 Fixed 31 Aug 2009 One-off Provided 02 Sep 2009 Fixed 05 Oct 2009 Fixed 07 Oct 2009 Fixed aries 26 Feb 2014 Added to user documentation Description Add User-defined default execution attributes.

CR:367505

CR Number:   367505 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 Nov 2005 Fixed Description CIS: INSERT into a proxy table with SMALLMONEY datatype mapped to a ASIQ backend and quickpass disabled might result in ASIQ conversion error -157.

CR:367513

CR Number:   367513 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2004 Fixed 23 Dec 2004 One-off Provided Description Transient errors during network accept operations can cause the ASE listener to quit Workaround Description  Use sp_listener to restart the listener.

CR:367546

CR Number:   367546 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2005 Fixed 15 Nov 2004 Insufficient priority to fix 20 May 2005 Fixed 01 Aug 2006 Fixed Description Change scoping of local variables so that the execute immediate statement could access local variables defined by the caller of the execute immediate.

CR:367567

CR Number:   367567 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2004 Fixed Description A role that has been locked can be incorrectly enabled unless it is protected with a password.

CR:367657

CR Number:   367657 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2004 Fixed 22 Oct 2004 Fixed Description Not customer visible

CR:367679

CR Number:   367679 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2004 Fixed Description If the class name of remote server is not local, stack trace is seen when user access the remote server properties from Add Proxy Database wizard - Specify the Remote Server location tab.

CR:367726

CR Number:   367726 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2004 Fixed 07 Feb 2005 Fixed Description The message 15056, "The root page <root-pagenum> of index ID <indid> for empty table <tablename> can have at most one entry pointing to the first page <first-pagenum>. However, it has either an incorrect entry, or more than one entries." may be raised if DBCC CHECKTABLE is run on a partitioned table, having one or more indexes, from which all rows have been deleted.

CR:367842

CR Number:   367842 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   AIX 5.1 Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2007 Fixed 11 Oct 2007 Fixed 14 Jun 2007 Fixed Description DDLGen may generate incorrect DDL for a compiled object, if the compiled object has multi-bytes character at 255-256th position in a row in syscomments.

CR:367845

CR Number:   367845 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) 01 Nov 2004 Fixed 01 Nov 2004 Fixed Description Executing xp_cmdshell within threshold stored procedure raises error 8015 with the message "Adaptive Server has truncated parameter number %d passesd to rpc '%.*s' on server '%.*s'. The remote server does not support character or binary data wider than 255 bytes."

CR:367931

CR Number:   367931 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) 16 Dec 2004 Fixed Description User created temporary databases cannot be added to 'Default' temporary database group.

CR:367984

CR Number:   367984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2004 Fixed Description The message infected with 11 in run() is printed in the errorlog together with a stacktrace containing the modules 'run', 'exec_eop' and 'execute' when using the STR() built-in function when the parameter 'length' is not a constant but an expression evaluating to the value bigger than 255. Workaround Description  Use constant as length passed to str().

CR:368024

CR Number:   368024 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Oct 2004 Workaround Description Migration tool: May see error 'Unexpected exception: com.sybase.jdbc2.jdbc.SybSQLException' when running a space estimation report against a 12.0 server. Workaround Description  sp_estspace was corrected to avoid this problem in 12.0.0.7 ESD #1. Ensure the source server is upgraded to at least this version.

CR:368049

CR Number:   368049 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) 21 Nov 2004 Fixed Description Fine-grain access control queries whose validation rule involves application context functions may return no result for parallel queries. Workaround Description  Run parallel queries that involve application context in serial.

CR:368068

CR Number:   368068 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2004 Fixed Description A 3475 error may be seen following an 'ALTER DATABASE' for a database with mixed log and data having long running transactions suspended on the LCT. Workaround Description  Use a segregated log database.

CR:368100

CR Number:   368100 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.0.0.8 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2004 Presently Not Targeted For Any Future Release Of This Product Description CIS: Outer joins with remote tables accessed via CIS which have column definitions using user defined types may return incorrect results.

CR:368132

CR Number:   368132 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2004 Fixed Description The message "current process infected with 11" in the module 'param_setup' together with a stack trace may be reported in the error log if Union with dateadd() and getdate() builtin routines are used on proxy tables.

CR:368156

CR Number:   368156 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2004 Fixed Description A new mechanism has been added in DDLGen to make use of persistent cached connection.

CR:368183

CR Number:   368183 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) 29 Nov 2004 Fixed Description An attempt to disk init a raw device that is already in use by another server fails with an error "Device activation error. PHYSNAME '<device path>' may be incorrect" as expected, but zeroes out the page on the device that would have been the last page of the new device as described by the disk init. This results in data corruption.

CR:368245

CR Number:   368245 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2007 Presently Not Targeted For Any Future Release Of This Product 22 Feb 2007 Fixed 25 Jan 2007 Fixed 14 Mar 2007 Added to user documentation 09 Jan 2008 Fixed Description The installmontables script has been included within installmaster. There is no longer any need to run installmontables to get the latest Monitoring Table definitions. The installmontables script is still provided as a template for retrieving monitoring data remotely via RPC.

CR:368278

CR Number:   368278 Product Name:   Adaptive Server Enterprise Product Component:   PowerTransfer Status:   Closed OS:   Windows XP Original Version:   10.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2005 Fixed Description PowerTransfer stops working whenever a new release of PowerDesigner is installed.

CR:368282

CR Number:   368282 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Tables Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Dec 2005 Fixed Description Document that the values for the TYPE column in SYSKEYS are 1 Primary, 2 Foreign, and 3 Common.

CR:368310

CR Number:   368310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2005 Fixed Description When starting ASE Web Services with runproducer may hit a Security password issue.

CR:368333

CR Number:   368333 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) 26 Oct 2004 Fixed Description LIKE can pattern match trailing-control characters without the necessary wild-card operator.

CR:368417

CR Number:   368417 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2004 Fixed 21 Sep 2007 Fixed Description Premature heap memory deallocation after each statement may lead to memory corruptions if the dealloctaion is done during trigger or internal sql execution.

CR:368424

CR Number:   368424 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) 14 Oct 2004 Fixed Description Failed to find optdiag or other utitlies under ASE-15_0 or OCS-15_0.

CR:368480

CR Number:   368480 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2006 Fixed 13 Oct 2006 Fixed Description (1)Incorrect value is displayed for 'File block count' and 'Total data stored on the volume' in the LOAD ... WITH LISTONLY=FULL command when loading across platform. (2)On linuxia32 and ibmplinux platforms, if a dump file size on a tape or a capacity value exceeds 4GB, an append of a dump file to the tape could fail or fail to report an appropriate error message which tells there is no room to append on the tape.

CR:368538

CR Number:   368538 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2004 Fixed Description CIS: Occasionally, sub-optimal performance may result when a query is executed which includes a TSQL outer join with some remote tables Workaround Description  None.

CR:368550

CR Number:   368550 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2006 Fixed 19 May 2006 Fixed Description CIS: Support SELECT INTO EXISTING for the tables with the same datatypes but smaller column length from the source column Workaround Description  Use INSERT SELECT