远程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:393849
CR Number:   393849
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)
15 Nov 2006 Fixed
Description
F.R. LDAPUA to have persistent connections from ASE to the LDAP server



CR:393895
CR Number:   393895
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   AIX
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2005 Fixed
07 Jul 2005 Fixed
17 Jun 2005 Fixed
Description
Makefile make.unix provided for sample program

sample/esp/xp_echo.c does not work on IBM AIX 64bit platform.



CR:393940
CR Number:   393940
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)
01 Oct 2007 Deferred
Description
With trace 4418 ON the view materialization is no longer necessary for a view which is an inner

member of the outer join and the view returns NULL constant.



CR:394172
CR Number:   394172
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   AIX
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2008 Fixed
12 May 2009 Fixed
Description
License Monitoring is counting spids supporting the Job Scheduler as licensed users.



CR:394178
CR Number:   394178
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2005 Fixed
Description
sjobcontrol stored procedure does not stop JS immediately when stop_js command is issued.



CR:394179
CR Number:   394179
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2005 Bundled Request
Description
JS stored procedure sjobcontrol does not return 0 for success for all the command options.



CR:394278
CR Number:   394278
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2005 Fixed
05 Jul 2005 Fixed
Description
Error 20019 "Attempt to initiate a new SQL Server operation with results pending." will be reported by a dblibrary routine that tries to send new commands to the server after a successful call to dbwritetext().



CR:394341
CR Number:   394341
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2005 Fixed
17 Jun 2005 Fixed
Description
Typo in an informational message when running Sybmigrate.

"Migrate database data is not allow because migrate server data wasn't selected during the setup session." Should be 'allowed' instead of 'allow'



CR:394365
CR Number:   394365
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2006 Fixed
Description
Server Groups folder Details panels now displays "n/a" (Not Available) on version/platform/status columns when the information is not available, i.e. when ASEP is not connected to the server and the server is not monitored by Unified Agent.



CR:394444
CR Number:   394444
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)
01 Oct 2007 Deferred
Description
Trailing spaces are lost from fixed char data type columns when you run UNION query with OUTER JOINs.



CR:394510
CR Number:   394510
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a method to convert DATETIME values to strings using flexible format-strings rather than predefined styles



CR:394524
CR Number:   394524
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2005 Fixed
04 Nov 2005 Fixed
Description
The number of private buffers for parallel query plans were not being

accurately calculated and claimed. This could result in infinite loops

in the cache manager where somewhere higher on the stack a Lava expensive

operator was attempting to grab a buffer.



CR:394527
CR Number:   394527
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2010 Fixed
Description
sp_helpconfig does not return error when groupname passed as configname



CR:394529
CR Number:   394529
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2005 Fixed
Description
configname options static,dynamic & read-only not documented for sp_helpconfig



CR:394542
CR Number:   394542
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2009 Fixed
31 Aug 2009 Fixed
Description
A Dump or Load command that uses an archive device name with newline character in it hits a segmentation fault in sybmultbuf.



CR:394544
CR Number:   394544
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: need a 'user' version of sybmon



CR:394709
CR Number:   394709
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)
09 Jan 2006 Fixed
15 Jan 2006 Fixed
08 Mar 2007 Fixed
23 Jul 2007 Fixed
09 Mar 2006 Fixed
Description
The table in the second argument to sp_monitorconfig will not be created if it does not exist.



CR:394717
CR Number:   394717
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2005 Insufficient priority to fix
Description
datediff in a trigger causes overflow at runtime error
Workaround Description
 Update one row at a time and it works fine.



CR:394750
CR Number:   394750
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2005 Fixed
28 Jul 2005 Fixed
Description
Killing a spid with status "MAINTENANCE TOKEN" during login authentication with Kerberos when

traceflag 7844 is used, blocks all Kerberos activity on the engine.

A dataserver should be run with traceflag 7844 when MIT 1.3 Kerberos libraries are used

to workaround concurrency problems within the MIT Kerberos client libraries.



CR:394754
CR Number:   394754
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2005 Fixed
Description
The Adaptive Server Enterprise 32-bit Express Edition on Linux has the 2GB memory configuration and hence the configuration 'enable extended cache' is not a valid option for the server.



CR:394825
CR Number:   394825
Product Name:   Adaptive Server Enterprise
Product Component:   MonitorServer
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2005 One-off Provided
14 Dec 2005 Fixed
Description
Monitor Server in an SSL configuration may crash after several hours of running.



CR:394843
CR Number:   394843
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2006 Fixed
05 Jan 2006 Fixed
Description
XFS: Update to filename in proxy tables mapped to file system directories using

the recursion option may fail with error message Msg 11277 when a constant string

is concantenated to the filename.
Workaround Description
 Use this update command which finds and updates the filename part, trimming off the directory path:



/* This update finds and changes just the filename without the dirname

** and it succeeds.

*/

update jDir

set filename = isnull(substring(filename, char_length(filename) -

charindex('\',reverse(filename))+2, char_length(filename)),filename) + "_UPD"

where filetype = 'REG'

go



select convert(char(40),filename), filetype, size from jDir

go



CR:394869
CR Number:   394869
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)
22 Jun 2005 Fixed
Description
Command line trace flag 7603 is no longer supported. The client's IP Address is always logged as part of the LOGIN Audit Event.



CR:394880
CR Number:   394880
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)
13 Jul 2005 Fixed
Description
An Infected with 11 stacktrace containing functions omni_getnext and exec_eop is generated

when a query uses an aggregate function against a DATE column in a proxy table defined

against an ASIQ table.
Workaround Description
 Instead of using the create proxy_table syntax to generate the proxy table:

First create the object definition with sp_addobjectdef, then

create the proxy table with the create existing table, using the DATETIME

datatype to map to the ASIQ column.



CR:394913
CR Number:   394913
Product Name:   ASE Replicator
Product Component:   Plug-ins
Status:   Closed
OS:   Generic
Original Version:   4.0.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2012 EOL'd version. Not to be Fixed.
Description
Selecting the "Advanced" button in the "Add Subscription" wizard causes a stack trace condition that you can ignore. The stack trace will not impact the functionality of the Add Subscription process.
Workaround Description
 Just hit OK on the stack trace, and keep going!



CR:394927
CR Number:   394927
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2005 Fixed
Description
A 221 message, "Column of type (BIT) does not allow nulls. It may not be compared with null." is raised when assigning the result of SELECT to a variable of type BIT. The SELECT is from a view with a UNION ALL clause with a select-list having a column of type BIT.



CR:395095
CR Number:   395095
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2005 Fixed
10 Jan 2006 Fixed
Description
Include license info from sp_lmconfig



CR:395119
CR Number:   395119
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2005 Fixed
Description
On windows platforms only the sybmigrate tool for ASE 12.5.3 fails to start with

ASE 12.5.3 ESD#1 or ASE 12.5.3 ESD#2 installed. The error at startup is:

Exception in thread "main"

java.lang.NoClassDefFoundError: com/sybase/util/ds/ldap/LDAPWarning
Workaround Description
 Edit the %SYBASE%\%SYBASE_ASE%\bin\sybmigrate.bat file and do the following...



A) fix the spelling of...

%SYBASE%\%SYBASE_ASE%\lib\iniparser.jar;

...and put it back to...

%SYBASE%\%SYBASE_ASE%\lib\dsparser.jar

B) fix path to the following files...

dsparser.jar,

jndi.jar,

ldap.jar,

providerutil.jar,

DDLGen.jar

the path needs to be...

%SYBASE%\shared-1_0\lib\

...instead of...

%SYBASE%\%SYBASE_ASE%\lib\

C) fix %SYBASE%\%SYBASE_ASE%\lib\3pclasses.jar

...needs to be changed to...

%SYBASE%\ASEP\lib\3pclasses.jar



D) ignore %SYBASE%\%SYBASE_ASE%\lib\LDAPparser.jar;

...this is missing from within the %SYBASE% directory structure...

...sybmigrate.bat at least starts when this file is missing...

...if it is necessary for this file to be accessible by sybmigrate, then

engineering will need to provide this file to the customer

before this workaround will fully resolve the problem



CR:395125
CR Number:   395125
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2006 Bundled Request
04 Dec 2006 Presently Not Targeted For Any Future Release Of This Product
09 Jun 2006 One-off Provided
05 Jun 2006 Fixed
Description
ASE running on Linux kernel 2.6 and above on amd64 platform encounters I/O performance degradation. This is because librtkaio support has been withdrawn on these linux kernel versions and by default POSIX AIO is used. Enable trace flag 1649 to use Linux Kernel Asynchronous IO.



CR:395240
CR Number:   395240
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Oct 2006 Fixed
20 Dec 2006 Fixed
Description
Dump database on tape using "with compression = compress_level" option works fine but load fails with a read error.
Workaround Description
 Suggested customer to use disk device or not to use "with compression " option

on tape device.



Modern tape device has its own compression turn on automatically.

So there is not much gain using compression to a tape, only

negative impact of CPU usage and doing extra work on 2 ends.



CR:395321
CR Number:   395321
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2005 Fixed
Description
Java support is enabled for Linux AMD64.



CR:395497
CR Number:   395497
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2005 Fixed
Description
A new feature has been added to allow a load of 15.0 database dump file from a byte-swapped architecture.



CR:395523
CR Number:   395523
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2005 Fixed
Description
The command 'sp_encryption system_encr_passwd, null' fails with a message 'Message number 19339, passed to RAISERROR, does not exist in the sysmessages catalog.'



CR:395712
CR Number:   395712
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2005 Fixed
Description
Use valid_name( 'name', 255 ) for checking object names with large identifier support



CR:395732
CR Number:   395732
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2005 Fixed
Description
During sec_session_close the Kerberos security session context is freed. During heavy login and disconnect processing the sec_memfree can get a segv.



CR:395745
CR Number:   395745
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2005 Fixed
07 Jul 2005 Fixed
Description
sp_encryption 'remove_catalog' fails to give an error when

it finds a column encrypted by a given key in the same database.

It removes the sysencryptkeys system table in preparation for

downgrade without adequate checking.



CR:395749
CR Number:   395749
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2005 Fixed
07 Jul 2005 Fixed
17 Aug 2005 Fixed
08 Nov 2005 Fixed
Description
Using bcp OUT of a view using the -C option on bcp will fail

if the view uses an encrypted column in the where clause.



CR:395858
CR Number:   395858
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2005 Fixed
06 Sep 2005 Fixed
Description
In rare circumstances the message "ubo_object_from_slot:Pss Invalid slot id 0" together with a stack trace that includes the modules 'ubo_object_from_slot', 'pss_getunkept_pss', 'lock_vsema' and 'log__unlock' may be reported when many transactions are active within a database and at least one of these is a transaction that is externally coordinated by XA, MSDTC or a remote Adaptive Server (a transactional RPC).
Workaround Description
 None.



CR:395894
CR Number:   395894
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2005 Fixed
Description
A 2631 error, "The maximum number of index levels '255' has been reached for index <indname> of table <tablename> in database <dbname>" may sometimes be encountered while inserting data into a clustered index with a large index key.
Workaround Description
 Cut the group-by list from 14 to less 13 columns



CR:395902
CR Number:   395902
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Fixed
16 Mar 2006 Fixed
Description
When using jconnect sp_mda locks sysconfigure table to get the ASE version , so when sp_sysmon is run it hangs till the lock is released. Fix is to get the ASE version from the global variable @@version_as_integer and save the current isolation level and set it back once the sp_mda is executed. This way we dont interfere with ASE locks and system tables.



CR:395937
CR Number:   395937
Product Name:   Adaptive Server Generic Docs
Product Component:   Other
Status:   Closed
OS:   all
Original Version:   Generic
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2006 Fixed
Description
Installing sybsyntax fails due to Msg 18047 "There is not enough room in the default devices to create the sybsyntax database.".
Workaround Description
 Line 12 to 15 in ins_syn_sql seem to be incorrect:



12 - (select sum (isnull (size, 0)) from sysusages, sysdevices

13 where vstart >= sysdevices.low

14 and vstart <= sysdevices.high

15 and sysdevices.status &1 = 1)



Workaround is to modify line 15 as follows:



12 - (select sum (isnull (size, 0)) from sysusages, sysdevices

13 where vstart >= sysdevices.low

14 and vstart <= sysdevices.high

15 and sysdevices.status &1 = 1 and sysdevices.vdevno = sysusages.vdevno)



And you may need to add "dump tran sybsyntax with truncate_only" into somewhere in ins_syn_sql.



CR:396081
CR Number:   396081
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2006 Fixed
23 Jan 2006 Fixed
Description
Sybase Central ASEPlugin now supports BCP in/out for User Tables(/partitions), and views



CR:396098
CR Number:   396098
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Release Bulletin-Adaptive Server Enterprise
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2005 Fixed
Description
Need to document Monitor Server/Historical Server are not available in ASE 12.5.x for Sun x86.



CR:396136
CR Number:   396136
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2005 Fixed
02 Mar 2006 Fixed
Description
Under rare circumstances the execution of DBCC CHECKSTORAGE may hang

if the given scan workspace is very large.
Workaround Description
 You may be able to avoid this problem.

Add 50MB or 100MB to scan workspace.

OR

Subtract 50MB or 100MB from scan workspace.



I reproduced this problem with scan workscape = 4200M.

But if I changed scan workspace size from 4200M to 4250M, this problem went away.



CR:396144
CR Number:   396144
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Sep 2005 Fixed
Description
The message "current process infected with 11" in the module 'memcpy' together with a stack

trace which includes the modules 'ss_chartoblob' and 'run' may be reported in the error log

during an UPDATE of a TEXT column using a J-connect program or a CT-library program that

uses host variables. In some cases a 510 error, "Bad eop type 0x.." may be reported instead.
Workaround Description
 Disable statement cache.



CR:396187
CR Number:   396187
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   Windows 2000
Original Version:   penelope EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In an XML model perform File >Print Selection. The printed diagram only prints the 1st line of the text zone (name of element) for the selection of symbols. Word wrapping has been temporarily dismantled on the selection of symbols (elements)to print. However, when you perform File > Print the whole text zone for the element symbols are printed fine.



note: if you use View > Redisplay or Zoom IN/OUT, the element symbol in the model diagram is refreshed and it's display in the diagram reverts back to the word wrapping setting.



CR:396198
CR Number:   396198
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is having a problem upgrading with the installer on a 4 and 8 CPU Windows 2003 System. Customer would like Sybase to Certify that ASE Installer works correctly without errors on multiple CPU systems for both product install and upgrades.



CR:396229
CR Number:   396229
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2005 Fixed
14 Dec 2005 Fixed
14 Dec 2005 Fixed
Description
An application error in transaction nesting leads to a segmentation fault with message 3934 "Transaction manager has detected a nesting failure. Number of BEGIN TRAN commands (issued after an attach operation) do not match the number of COMMIT TRAN commands (issued before a detach operation)". A stack trace with module finish_xact() will be found in the errorlog.



CR:396266
CR Number:   396266
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2005 Fixed
Description
The message "infected with 11 in s_is_cachable" is printed in the errorlog together with a

stacktrace containing the modules 's_normalize' and 'sequencer' when executing a query

performing an INSERT into a temporary table based and on a SELECT with a UNION clause whereby the

last SELECT contains a subquery.



CR:396296
CR Number:   396296
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)
29 Aug 2005 Fixed
15 Jan 2006 Not a Bug
Description
Sub-optimal performances may be seen on queries with LIKE expression performed on a

unichar or univarchar column.



CR:396479
CR Number:   396479
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)
28 Sep 2005 Fixed
Description
When an UPDATE that uses the tsequal() builtin function is done within

a stored procedure, tsequal() no longer returns a timestamp value

unless the 4080 trace flag is being used. When an UPDATE that uses the

tsequal() builtin function is done outside a stored procedure, tsequal()

returns a timestamp value in the TDS_RETURNVALUE token.



CR:396509
CR Number:   396509
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2005 Fixed
23 Nov 2005 Fixed
11 Aug 2006 Fixed
Description
An INSERT-SELECT statement can corrupt the inserted rows in the target table when the target table

is a Data Only Locked table and the SELECT contains a UNION ALL first, followed by one or more

UNION statements grouped together using ().
Workaround Description
 rewrite query.



CR:396536
CR Number:   396536
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)
22 Dec 2005 Fixed
12 Oct 2005 Fixed
Description
sp_helpdevice reports the allocated database fragments on a database device



CR:396565
CR Number:   396565
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2005 Fixed
Description
DDLGen has a new type - 'LK' for generating DDL defintions of Logical Keys - keys generated by sp_primarykey, sp_commonkey, sp_foreignkey statements. The name to be supplied in '-N' parameter is the table name.



CR:396598
CR Number:   396598
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2005 Bundled Request
Description
The message "current process infected with signal 10 (SIGBUS)" in the module 'vbit_set'

together with a stack trace which includes the modules 'rec_analyze_log' and

'rec_onlinetime' may be reported in the error log during ONLINE DATABASE on the HPUX 64 bits

platform.



CR:396703
CR Number:   396703
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)
20 Mar 2006 Fixed
21 Dec 2006 Failed
Description
Feature request for an option to sp_configure that would display all the configurations that were set to a non-default value



CR:396708
CR Number:   396708
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)
04 Aug 2005 Fixed
Description
A 15052 error, "Index error: Table id <id>, indid <id> calculated maxlen <value> does

not match <value> in Sysindexes" may be reported by DBCC CHECKCATALOG on a table that

has at least two bit columns, after ALTER TABLE was run to add/modify a variable

length or NULL column.
Workaround Description
 - Use dbcc checkcatalog(<db_name>, fix) after alter table to fix this error.

- OR ignore the 15052 error from checkcatalog for the moment, it is not a

big problem, because maxlen is larger then it should be.



CR:396811
CR Number:   396811
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2005 Bundled Request
07 Nov 2005 Bundled Request
Description
The message "current process infected with 11" in the module 'lddb__stat_translate'

together with a stack trace which includes the modules 'lddb__unscr_stat_page'

may be reported in the error log, when loading a database across platform,

if the database has an orphan row in syssatistics.
Workaround Description
 Find and delete orphan rows from sysstatistics something like:



1> use <databasename>

2> go

1> delete from sysstatistics where id not in (select id from sysobjects)

2> go

(x rows affected)



CR:396812
CR Number:   396812
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)
09 May 2008 Duplicate
Description
dbcc checkcatalog() does not check or fix the consistency of the sysstatistics table.
Workaround Description
 None.



CR:397029
CR Number:   397029
Product Name:   ASE Replicator
Product Component:   Log Extract
Status:   Closed
OS:   Generic
Original Version:   12.5.3.304P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1.410P1 13 Dec 2005 Fixed
Description
ASE REPLICATOR: occasionally, the order of replicated operations within a transaction at the replicate database does not match the order of operations at the primary database.
Workaround Description
 None



CR:397149
CR Number:   397149
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2005 Fixed
19 Jul 2005 Fixed
Description
ASE Plugin for Sybase Central: "Create Table DDL" inserts extra commas into table contraints if they are longer than 255 characters.
Workaround Description
 None known.



CR:397155
CR Number:   397155
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
18 Nov 2005 Fixed
Description
A login attempt into ASE may fail with a 1601 error after several recurring 709 errors have been raised because of procedure cache memory shortage.
Workaround Description
 Allow enough procedure cache in order to avoid error 709.



CR:397210
CR Number:   397210
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Avoid shutdown and restart of license deamon when it is not required



CR:397229
CR Number:   397229
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2005 Third Party Problem
22 Nov 2005 Third Party Problem
Description
ASE running on Solaris 10 operating system encounters performance degradation

when using asynchronous IO on file system devices.

This is liable to manifest as severe performance degradation on single CPU machines

and significant performance degradation on multi CPU machines under load.

This is due to a bug in Solaris kernel, Sun BugID 6302167.

Install the following patch from Sun Support for resolving this performance problem.

Solaris 10 SPARC: PatchID 120048-03

Solaris 10 x86/x64: PatchID 120049-03
Workaround Description
 1. Use raw device for ASE

2. On single CPU box, use RPSC=3 and start ASE with traceflag 1636

3. On multi CPU box, configure number of ASE engines to be less than number of CPUs



CR:397260
CR Number:   397260
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2005 Fixed
Description
The config numbers for 'max online Q engines' and 'number of Q engines at startup'

are not correct. They should be 447 and 448 instead of 443 and 444.



CR:397291
CR Number:   397291
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2008 Fixed
10 Jul 2008 Fixed
Description
Global variables may return invalid negative values.



CR:397320
CR Number:   397320
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2005 Fixed
Description
HAFAILOVER occurs on clients when killing a spid on ASE. The condition occurs when the spid is involved in a non-resultset transaction, such as insert into command. When the kill is issued, ASE is internally rolling back the transaction, and the HA Session id is still valid at this point. This enables the client to re-connect. Client should receive some sort of disconnect message instead, like jConnect JZ006 IOException, or isql operation terminated due to disconnect.



CR:397342
CR Number:   397342
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2006 Fixed
11 Jan 2006 Bundled Request
Description
Flush all data to the Sybmon log file whenver the 'log off' command is executed.



CR:397359
CR Number:   397359
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2005 Fixed
Description
The error 632 "Attempt to move memory with an incorrect length of <len>.

Maximum allowed length is <maxlen>." will now be raised during garbage

collection of index leaf pages if the length of memory being moved

goes beyond a page boundary, instead of silently trashing the data cache.



CR:397535
CR Number:   397535
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2005 Fixed
Description
When exec_procedure auditing is enabled for system stored procedures sp_encryption and sp_ssladmin, the password parameters are visible in the audit trail.



CR:397539
CR Number:   397539
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2005 Fixed
04 Jan 2006 Fixed
Description
The recovery task may appear to hang forever executing the functions 'at_do_reserve',

'pg_oam_pagecounts' and 'pg_recalcoam' after loading a database dump which was taken

on a very active ASE environment.



CR:397636
CR Number:   397636
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)
19 Jul 2005 Fixed
Description
Job and Schedule names with spaces and other nonalphanumeric characters were being rejected by the ASE Plugin GUI.



CR:397658
CR Number:   397658
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2005 Fixed
Description
If an LDAP server does not allow anonymous binds then one cannot set the "primary_url" and "dn_lookup_url" even if the "access_account" has been successfuly set.
Workaround Description
 Bring up the ldap server allowing bind_anon, and set the urls. Then recycle the ldap server after setting "disallow bind_anon".



CR:397665
CR Number:   397665
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)
02 Dec 2005 Fixed
Description
ASE incorrectly allows identifiers that start with a pound sign (#) to be used as column names. All

column-names defined in a CREATE TABLE, CREATE VIEW statement and in the column-list of a derived

table expression are now checked against the rules for valid identifiers as stated in the standard

documentation.



CR:397672
CR Number:   397672
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2006 Fixed
15 Oct 2007 Fixed
07 Mar 2007 Fixed
Description
If complete deadlock information which gives deadlock chains and details is not needed, customer can set 'print deadlock information' to value 2.

This will print only 1 line summary of Deadlock giving only Deadlock ID.



CR:397679
CR Number:   397679
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 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Feature request to enhance the 4002 error message ("Login failed") to include the specified user name ("Login failed for user 'joeuser'").
Workaround Description
 sp_configure "log audit logon failure" prints username and ip address to the errorlog.



CR:397693
CR Number:   397693
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2006 Fixed
19 Dec 2006 Fixed
Description
New Feature - Sybase Central ASE Plug-in supports restoration of tables and partitions from 15.0.2



CR:397700
CR Number:   397700
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2005 Fixed
11 Feb 2006 Presently Not Targeted For Any Future Release Of This Product
17 Aug 2005 Fixed
17 Aug 2005 Fixed
12 Jan 2006 Fixed
Description
ASE Job Scheduler fails to execute jobs scheduled to repeat with an interval greater than approximately 25 minutes.
Workaround Description
 Schedule a dummy job to run every 25 minutes or more frequently.



CR:397873
CR Number:   397873
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2005 Fixed
07 Sep 2005 Fixed
Description
Enable Java support on Solaris x64 (opteron) platform.



CR:397910
CR Number:   397910
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 Dec 2005 Deferred
26 Aug 2005 Fixed
06 Jan 2006 Fixed
Description
Suppress raising error 2513 from DBCC CHECKCATALOG if rows are found missing in

syscomments for definition-time partition condition objects that were left behind

due to some errors that occured during creation of tables with partition conditions.



CR:397943
CR Number:   397943
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance error messages 3409, 3410 and 3411 to include the transaction id.
Target Version
 12.5.3



CR:397966
CR Number:   397966
Product Name:   Adaptive Server Enterprise
Product Component:   Monitor Client
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2005 Fixed
Description
Not customer visible



CR:397984
CR Number:   397984
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)
17 Apr 2006 Fixed
03 May 2006 Fixed
Description
The SQL data type UNSIGNED BIGINT is currently mapped to

the Java type "double". This conversion will incorrectly

give an approximate value when the UNSIGNED BIGINT value

is large enough.



CR:398110
CR Number:   398110
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2005 Fixed
28 Jul 2005 Fixed
Description
Transactional queries involving remote tables may hang on Windows platform configured with SSL when trace flag 3431 is used.



CR:398200
CR Number:   398200
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2005 Fixed
18 Nov 2005 Fixed
Description
When the sampling option is used for UPDATE STATISTICS, existing multi-attribute density values may not be reused. With this fix, range density and total density will be calculated from the sampled dataset, unless existing values were from a full scan of data.



CR:398212
CR Number:   398212
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2005 Fixed
Description
If Adaptive Server is unable to find an encryption key when it is processing an encrypted column, an unhelpful error message (15424) is raised. This scenario can occur if, for example, the database containing the key has been taken offline.



CR:398295
CR Number:   398295
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a way to display the name of the source ASE for a dump file, perhaps by including the name in the dump header and displaying it using listonly or headeronly.



CR:398320
CR Number:   398320
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2007 Fixed
28 Jun 2007 Fixed
Description
The error 10302, "Only the DBO of database 'dbccdb' or a user with System Administrator (SA) role

can run this command." will be incorrectly raised when a user without SA role different from the DBO executes DBCC CHECKVERIFY even if this access has been granted in the target database.



CR:398435
CR Number:   398435
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central Plug-in
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2009 Fixed
Description
DBISQL returned error from queries with compute clause.



CR:398443
CR Number:   398443
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2007 Fixed
29 May 2007 Fixed
09 Feb 2007 Fixed
Description
In rare circumstances , an error message "Internal error, FDP API, fdp_get_memory() :Failed to allocate xxxxx bytes" may be logged in the ASE errorlog when sp_configure is executed.



CR:398491
CR Number:   398491
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)
04 Jun 2010 Fixed
Description
ASE now can save 999999999 copies of configuration files instead of the previous 999.

And the format of the backup config file will be xxx.000000001 instead of xxx.001.



CR:398586
CR Number:   398586
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2008 Fixed
19 Feb 2008 Fixed
Description
ASE server or client will not start when IP 0.0.0.0 is present as master/query in interfaces file. ASE Server fails to start with error "ninit: cannot find host 0.0.0.0".
Workaround Description
 add ip address to /etc/hosts (fake entry)



CR:398666
CR Number:   398666
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)
22 Jul 2005 Fixed
Description
The preupgrade utility does not check for and enforce correct spelling in its printed messages.



CR:398675
CR Number:   398675
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2005 Fixed
27 Jul 2005 Fixed
Description
The error 874 "Process <spid> is trying to unkeep buffer <buf_addr>

(dbid: <dbid>, pageno: <pageno>) without releasing the <type> latch

it holds on the buffer." may be raised when an interrupt is received

by a query on a Data-Only-Locked table using the isolation level 3

(serializable) and performing a backward scan.



CR:398768
CR Number:   398768
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2005 Fixed
Description
A 8206 error, "Object <negative number> was not found in WorkTabList" may be reported in the

error log for a query referencing multiple times the same view and performing aggregates

on view columns. This problem will happen only if the query is executed in the parallel mode.



CR:398792
CR Number:   398792
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   SunOS
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2010 Fixed
Description
Installing 12.5.3, ESD#2 after moving $SYBASE will report a null and block

the install process.
Workaround Description
 The work-around used was to update the vpd.properties and

change the path to match new location of $SYBASE.



CR:398819
CR Number:   398819
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2005 Fixed
Description
ASE reports "master device corrupt" even for the situation of missing master device when booting a server without providing the master device.



CR:398897
CR Number:   398897
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2005 Fixed
Description
The output from sp_sysmon system stored procedure may report

incorrect values for the "Free" counters in the section

"Metadata Cache Management".



CR:398968
CR Number:   398968
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2005 Fixed
21 Oct 2005 Fixed
Description
User can specify RMI port other than 9999 for Unified Agent connection.



CR:399023
CR Number:   399023
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2006 Fixed
20 Jul 2006 Fixed
Description
Feature request: improve time to open Stored Procedures Folder within Sybase Central ASE plugin





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------