远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

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 搒hared 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 搒hared 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





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------