远程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:376291
CR Number:   376291
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 Jan 2005 Fixed
14 Jan 2005 Fixed
Description
When incorrect keywords (MESSAGE PROPERTY, OPTION, etc) are passed to messaging builtins

(msgsend(), msgrecv(), etc) The following error is reported



Incorrect syntax near 'Invalid pointer param number 2, pointer value 0x10'.



CR:376303
CR Number:   376303
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)
04 Jul 2005 Fixed
Description
sp_monitorconfig 'permission cache entries' reports an active value greater than the configured value on the system. This misreporting occurs even on single engine cases without runtime re-configuration of permission cache entries.



CR:376344
CR Number:   376344
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 Jan 2005 Fixed
13 Jan 2005 Fixed
02 Feb 2005 Not a Bug
24 Feb 2005 Presently Not Targeted For Any Future Release Of This Product
Description
ASE panic stacktrace in ksfreesocket after sp_listener operation
Workaround Description
 avoid doing the operations in the reproduction!



CR:376404
CR Number:   376404
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2005 Fixed
Description
Application context SYS_SESSION fails to return results for attributes clientname, clientappname and clienthostname.



CR:376412
CR Number:   376412
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2005 Fixed
Description
Some SYS_SESSION application contexts, namely client_name, client_hostname and client_applname, can result in either wrong results.



CR:376419
CR Number:   376419
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)
14 Feb 2005 One-off Provided
14 Feb 2005 Fixed
18 Mar 2005 One-off Provided
05 May 2005 One-off Provided
11 Apr 2005 One-off Provided
29 Jun 2005 Bundled Request
Description
ASE gives timeslice errors when heavy I/O operations are

executed on RedHat Linux variant RHEL 3.0 version



CR:376482
CR Number:   376482
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 Jan 2005 Fixed
Description
The stored procedure sp_tables does not show any user table but those owned by DBO if the executor has SA role but it is not the SA user.



CR:376490
CR Number:   376490
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2005 Fixed
28 Feb 2005 Fixed
31 Mar 2005 Fixed
26 Apr 2005 Bundled Request
22 Apr 2005 Fixed
17 Aug 2005 Fixed
28 Apr 2005 Fixed
Description
ASE running on the Windows Server 2003 platform does not produce correct stacktrace

if ASE executable sqlsrvr.exe is not found in the current working directory.
Workaround Description
 Copy the sqlsrvr.exe executable to the server's current working directory.



The working directory for an ASE that is started as a service is c:\winodws\system32 by default.



CR:376647
CR Number:   376647
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)
02 Aug 2005 Fixed
05 Jan 2006 Fixed
Description
SELECT ... COUNT(<cnt_col>) INTO <new_tab> from ... GROUP BY ... results in a column with the same type as cnt_col instead of int.



CR:376755
CR Number:   376755
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2005 Fixed
14 Feb 2005 Fixed
Description
RTMS feature is supported on hppa64 platform as of ASE 12.5.3, however

installmsgsvss script is not included in ASE 12.5.3 release.

Also, instructions for post installation tasks on hppa64 platform

for RTMS is missing in ASE 12.5.3 Coverletter.
Workaround Description
 *** Wednesday, January 12, 2005 2:42:54 PM *** cooperg ***

Engineering thinks that the installmsgsvss file from Solaris should work. TSE will try it.



CR:376767
CR Number:   376767
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)
12 Jan 2005 Duplicate
Description
CIS : An error is reported when UPDATE and DELETE statements with TOP syntax are sent to remote servers that do not support the TOP syntax.



CR:376777
CR Number:   376777
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2005 Fixed
09 Jun 2005 Fixed
Description
Add MIT Kerberos support on IBMAIX64 platform.



CR:376841
CR Number:   376841
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.8 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2005 Duplicate
Description
Some queries involving data-only locked tables that are executed at

transaction isolation level 3 (holdlock) may return an incorrect result set.
Workaround Description
 Force the plan.



CR:376858
CR Number:   376858
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)
18 Jan 2005 Fixed
Description
A 3939 error, "Illegal attempt to rollback transaction ... that has already committed

in database '<temporary_database_name>'", may be reported if a session is interrupted

with ^C during the dropping of a temporary table and the 3706 trace flag is turned on.

The interrupted session is terminated abnormally and may not have its resources cleaned up.
Workaround Description
 Don't use -T3706 traceflag that forces the release of locks on catalogs at commit time.



CR:376861
CR Number:   376861
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)
14 Jan 2005 Fixed
07 Apr 2005 Fixed
Description
After user entered the password to configure an existing ASE with Syconfig, Syconfig displayed error message "Server '%1' is a pre-4.8 Sybase Server. It must be upgraded to at least version 4.8 before being used with auditinit.".



CR:376974
CR Number:   376974
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2005 Duplicate
Description
Enable XML Services feature on HP-IPF machines



CR:377075
CR Number:   377075
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 Feb 2005 Fixed
01 Jul 2005 Fixed
Description
A 9289 error, "RepAgent(5). Log record (1370, 17) contains inconsistent data. Transaction log may be

corrupt" may be reported in a server with a multi byte character set when data inserted in a varchar

column is longer than the definition of the column. This can happen for an insert using binary values

for the character column.



CR:377105
CR Number:   377105
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)
08 Feb 2005 Fixed
05 Jul 2005 Fixed
Description
If the trace flag 9217 is active, the Replication Agent will not stop

operating after having reported the error 9289 due to an inconsistent

log record found. Instead it will attempt to continue the replication

after having reported the error 9290 in the error log.



CR:377211
CR Number:   377211
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)
13 Mar 2005 Fixed
07 Jul 2005 Fixed
29 Apr 2005 Fixed
Description
LDAP User Authentication feature is ported to AIX 64bit platform.



CR:377282
CR Number:   377282
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)
08 Feb 2006 Insufficient priority to fix
19 Jul 2006 Fixed
Description
No error is shown when a text, image or unitext column of a proxy table appears in an order by clause.



CR:377300
CR Number:   377300
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)
19 Mar 2005 Insufficient priority to fix
Description
Customer has a problem with syblicenseslog table being in master, Even though the table will only grow roughly .02 MEG a year. Customer does not like to see the table growing under the Master database. Since the table is only a user table the customer would like the table moved to the sybsystemproc database or another database.



CR:377307
CR Number:   377307
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2005 Fixed
24 Jan 2005 Fixed
31 May 2005 Bundled Request
22 Apr 2005 Fixed
31 May 2005 Bundled Request
Description
Update ASE Plug-in to Sybase Central 4.3 and to co-exist with other Sybase Central Plug-ins under Sybase Central 4.3.



CR:377338
CR Number:   377338
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
Add date/time of Max_Used in sp_monitorconfig output



CR:377369
CR Number:   377369
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)
21 Apr 2005 Fixed
Description
Message 209, Level 16, State 3: Ambiguous column name <column name> is raised when executing a

stored procedure with the recompile option. The stored procedure contains a derived table expression

which is referencing a temporary table column. The message is raised when the procedure is executed

having a different @@tempdbid from the one the procedure was created under.
Workaround Description
 don't use user defined tempdbs



CR:377386
CR Number:   377386
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2005 Fixed
07 Apr 2005 Fixed
Description
MIT Kerberos support is added for PA-RISC HPUX64.



CR:377426
CR Number:   377426
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 Mar 2010 Duplicate
Description
FR to have a configure options to use the page ASE reads the second time when ASE find a page read from disk do not have correct page id , object id. (we raise Errpr 694)
Workaround Description
 N/A



CR:377437
CR Number:   377437
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2005 Fixed
15 Mar 2005 Fixed
Description
ASE running on multiprocessor Windows systems may occasionally fail to acknowledge cancel requests from client application causing the client application to hang in ct_cancel or ct_results.



CR:377473
CR Number:   377473
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)
19 Feb 2006 Fixed
Description
There are 3 issues with the conments list below:



1. The comment at the beginning of sp_helptext is wrong. It states that 18406 is a problem with "allow select on syscomments.text". However, 18406 is raise when sp_hidetext was run for the object NOT when "allow select on syscomments.text" is set to 0. Note that the quoted text is also incorrect; there is no "allow" in the configuration argument.



2. There is a next comment:



/*

** If the configuration parameter 'allow select on syscomments.text' is set

to

** 0, then the user can use sp_helptext ONLY in the following cases

**

** 1. if the user has sa_role

** 2. if the object is a system stored procedure

** 3. if the object is owned by the user

**

*/



It should include dbo as well because dbo or dbo alias could also run sp_helptext.



3. The text for error 18180 says: "Configuration Parameter 'allow select on syscomments.text' is set to 0. Only the object owner or user with sa_role can run sp_helptext on this object." Again there should be no "allow" in the parameter name and the message should includde dbo as well.



CR:377488
CR Number:   377488
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)
01 Feb 2005 Fixed
Description
The message infected with 11 in startscan() is raised together with a stacktrace written to the

errorlog containing the modules 'curs_open', 'execute' and 'exec_eop', when a cursor statement

contains a SELECT with a UNION- and a JOIN-clause using the REFORMATTING strategy, when

the OPEN of the cursor is executed. The set option FMTONLY must be set on to see this issue.



CR:377503
CR Number:   377503
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)
07 Feb 2005 Fixed
Description
After an upgrade to ASE 12.5.1 or above, a 7417 error may be raised by the

DBCC CHECKCATALOG command run for the SYBSYSTEMPROCS database.
Workaround Description
 How to get rid of the 7417/7411 errors ?



1. shutdown with nowait + ASE restart



2. Or assuming ASE is 12.5.2 or above :

sp_dboption "sybsystemprocs", "single", true

go

dbcc findstranded(sybsystemprocs)

go

sp_dboption "sybsystemprocs", "single", false

go



CR:377508
CR Number:   377508
Product Name:   Adaptive Server Generic Docs
Product Component:   Transact-SQL Users Guide
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2005 Fixed
Description
In the Transact-SQL User's Guide in

Chapter 19 Transactions: Maintaining Data Consistency and Recovery, under

Transaction modes and stored procedures, sp_proxmode should be spelled sp_procxmode.

http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/sqlug/@Generic__BookView?DwebQuery=sp_proxmode



CR:377526
CR Number:   377526
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)
19 Apr 2005 Bundled Request
Description
The sp_ldapadmin check_login 'login_name' fails.



CR:377543
CR Number:   377543
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2005 Duplicate
Description



CR:377571
CR Number:   377571
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)
24 Jan 2005 Fixed
Description
Not customer visible



CR:377617
CR Number:   377617
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)
29 Apr 2005 Fixed
13 Jun 2005 One-off Provided
01 Jul 2005 Fixed
Description
On the Solaris platform, ASE tasks may hang indefinitely while waiting for disk I/O to complete.

This will occur sometime after a different task encounters a fatal error,

such as a timeslice error, while performing disk I/O. The stacktrace for the timeslice error

will include functions such as aioread() or aiowrite(), kaio__daiostart(), and basis_daiostart.
Workaround Description
 None, other than to fix the O/S problem that caused the timeslice in the first place.



CR:377625
CR Number:   377625
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2005 Fixed
Description
Message 141, 'A SELECT statement that assigns a value to a variable must not be combined with

data-retrieval operations.' is raised when the result of derived table expression is assigned to

a local variable. With fix the behavior is changed and it's now allowed to do so.



CR:377674
CR Number:   377674
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2006 Fixed
Description
A 624 error may be reported in case a database is dumped to an existing file and ASE crashes during dump operation.



CR:377713
CR Number:   377713
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
As per QTS 258273 the Default number for the I/O Batch Size has been changed to 100 from 10



CR:377737
CR Number:   377737
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)
07 Feb 2005 Fixed
Description
The error 11206, "Unable to connect to server '%s'" followed by error 4002, "Login failed',

will be raised if a procedure fired when a threshold is crossed tries to access an MDA table.
Workaround Description
 If you add the login as an external login to the same server (sp_addexternlogin loopback,KAYSER_C,KAYSER_C in my example where the login is KAYSER_C), then everything works fine.



CR:377803
CR Number:   377803
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)
30 Sep 2005 Fixed
Description
In rare circumstances, a 9539 error, "Insufficient amount of memory per worker process to execute

this parallel query. Increase the value of the configuration parameter 'memory per worker process'."

may be reported in a server with a low number of worker processes and a high number of user

connections.
Workaround Description
 Increase worker process memory using

sp_configure "memory per worker process", <value>



CR:377912
CR Number:   377912
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)
25 Jan 2005 Fixed
24 Feb 2005 Fixed
24 Feb 2005 Fixed
Description
DDLGen generates NULL in Grant Statements for 'Update Statistics' and 'Truncate Table'



CR:377920
CR Number:   377920
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Open
OS:   Microsoft Windows
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2005 Fixed
16 Feb 2005 Fixed
DEFER
10 Jan 2006 Bundled Request
Description
Role and Login can be copy and paste (or drag and drop) to a ServerGroup, Server or similar type of object folder in different servers.



CR:377973
CR Number:   377973
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2005 Fixed
03 Feb 2005 Fixed
09 Feb 2005 Fixed
Description
In rare circumstances a 3474 error, "During redo the page timestamp value is less than old timestamp from log....", may be reported in the error log during recovery of a transaction which ,at runtime, was truncating a table around the time that a checkpoint was taking place.
Workaround Description
 Use the 3453 trace flag during recovery.

This allows this timestamp check to be bypassed.

This tracee flag must be used with care. See CR 224826.



CR:378029
CR Number:   378029
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2005 Fixed
Description
The status bit 0x0001 in syslogins was set when users had short or null passwords,

but the bit is no longer used. The internal upgrade process will reset it..



CR:378068
CR Number:   378068
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)
Description
GROUP BY <DATE NULL> produces output with multiple NULL groups



CR:378099
CR Number:   378099
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)
05 Apr 2005 Fixed
09 Jan 2006 Fixed
Description
The sp_helprotect stored procedure does not display DELETE STATISTICS when this command is

granted.



CR:378102
CR Number:   378102
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2005 Reservation Made
21 Feb 2006 Fixed
Description
Feature request to allow sqlupgraderes to perform all the necessary preupgrade checks WITHOUT actually UPGRADING. Currently this call can be done with the GUI sqlupgrade.



CR:378126
CR Number:   378126
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)
01 Apr 2005 Fixed
Description
A query using a compute clause on an empty table will cause a stack trace.

For example, "select col1 from tabA compute max(col1)" will fail if there

are no rows in tabA.



CR:378145
CR Number:   378145
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)
22 Feb 2005 Fixed
Description
The message "current process infected with 11" in the module 's_compile_stmt'

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

'sequencer', may be reported in the error log when the user has a soft

binding with an user temporary database and both this user and the system

temporary databases are not available.



CR:378184
CR Number:   378184
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)
28 Jan 2005 Fixed
Description
When server's charset is SJIS, client charset is EUCJIS and builtin conversion

(enable unicode conversion is set to 0 or 1) is used, 4847 error is raised with

BCP IN command.
Workaround Description
 Use -Y option of BCP.



CR:378295
CR Number:   378295
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2013 Insufficient priority to fix
20 Dec 2005 Fixed
29 Nov 2006 Fixed
Description
When the web service consumer starts, refresh the consumer metadata so that external websebservice are accessible.
Workaround Description
 In addition to executing sp_webservices 'add' in the intended database,

execute sp_webservices 'add' in the master database.



CR:378301
CR Number:   378301
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2008 Fixed
20 Oct 2008 Fixed
10 Oct 2008 Reservation Made
11 Nov 2008 Reservation Made
11 Nov 2008 Fixed
19 Nov 2008 Fixed
Description
Message "Invalid column length", does not identify the database and object in the message.



CR:378391
CR Number:   378391
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 2005 Fixed
Description
"Error: 702, Severity: 20, State: 1 Memory request for XXXXX bytes exceeds the size of a single page of 16384 bytes." together with "The SQL Server is terminating this process" may be found in the error log when concatenating strings together.



CR:378442
CR Number:   378442
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)
13 Mar 2006 Fixed
25 Oct 2006 Fixed
Description
BCP IN operation may report 2404 error when unilib conversion is enabled.
Workaround Description
 Try -Y option on bcp side.



CR:378481
CR Number:   378481
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)
04 Apr 2005 Fixed
08 Jun 2005 Fixed
Description
When UPDATE STATISTICS is run on a proxy table that has more than 1 index and

the remote statistics is not available, error message 11290 揇istribution

statistics for column '<column name>' in index '<index name>' is unavailable or

incomplete in the remote server. shows incorrect <index name> against the

<column name>.



CR:378518
CR Number:   378518
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2005 Fixed
16 Nov 2006 Not reproducible with latest version of the product available as of Resolution Date
Description
CIS: When a table is marked for replication with sp_setreptable, updating the table with

proxy text data results in Msg 605 error.



CR:378535
CR Number:   378535
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2005 Fixed
Description
Not to display SQL Preview and Scheduler Button for Java Wizard



CR:378541
CR Number:   378541
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2005 Fixed
Description
References to "SQL Advantage" and "JISQL" have been removed in ASE Plug-in. These two query tools are replaced by Interactive SQL, which has tighter integration with ASE Plug-in.



CR:378604
CR Number:   378604
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.8 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2005 One-off Provided
Description
INSTRUMENTATION : The message infected with 11 in sqt__release_chunks together with a stacktrace

containing the modules 'sequencer','lwp_create' and 'sqt_deallocate' is written to the errorlog

using dynamic SQL against the server.
Workaround Description
 n/a



CR:378615
CR Number:   378615
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2006 Fixed
09 May 2006 Fixed
Description
System application contexts can be overwritten if issued in the same statement.
Workaround Description
 Select attributes one at a time into a temporary char variable.



CR:378698
CR Number:   378698
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2005 Fixed
01 Jun 2005 Fixed
Description
Changing execution class from EC0 to EC1 does not correctly reset process priority until the next login, it should happen immediately.



CR:378746
CR Number:   378746
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2011 Duplicate
Description
Feature request to enhance the error 4207 to include why and what the minimally

logged operation was that prevented a dump tran.
Workaround Description
 Use the dbcc dbinfo(dbname) command to check on dbi_ldstate.

If the value for this is anything other than 0x0, then it will not

be able to issue a successful dump tran command.



Also, based on what the value for this field is, one can even

determine what was the non-logged operation that caused the 4207 error.



For instance, if the bitmapped field is



0x4 = select into previously occured;

0x8 = dump tran with truncate_only occurred;

0x12 = bcp occurred.



CR:378748
CR Number:   378748
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)
11 Feb 2005 Fixed
Description
Error 7742,"You must change your password using the sp_password system stored procedure

before you can continue." can be raised at the secondary site in a HA environment if the password has expired in the primary, and sp_password is run to change it.



CR:378764
CR Number:   378764
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)
20 Apr 2005 Fixed
12 Apr 2005 Fixed
09 May 2005 Fixed
05 Jun 2006 Fixed
23 Jun 2005 One-off Provided
Description
A new ASE dataserver option -k and an environment variable SYBASE_PRINCIPAL are provided to specify an ASE principal name that is different from ASE抯 server name. This feature is applicable to an ASE configured for Kerberos authentication.
Workaround Description
 Issue 1) User name mapping to ASE acceptable login when multiple realms are used.

---------------------------------------------------------------------------------



Issue is that ASE is receiving a "user@realm" login name after it authenticates

the user using Kerberos mechanism. This "user@realm" needs to be translated to a

login name acceptable to ASE such as "user". The customer also has the need to

do a mapping from lower case to upper case login names.



The sybmapname functionality can be used to filter out realm information

and do other character mapping, such as lower case to upper case.



This functionality is not found in documentation, except by reference, although

it has been used to handle other customer cases.



The sample program $SYBASE/$SYBASE_ASE/samples/server/sybmapname.c can be modified

and compiled to run as a shared object. It is then placed in $SYBASE/$SYBASE_ASE/lib

with permissions that allow only the 'sybase' user to read/write/exec the shared object.



This workaround to be tried out by the customer at the customer site. Sybase

support to provide additional information for building and using the sybmapname

program to filter login names for ASE.



Issue 2) ASE should support a method for specifying the server principal name.

-------------------------------------------------------------------------------



ASE principal name can be specified as -C "server principal name"

or by setting environment variable SYBASE_PRINCIPAL.



Please refer Resolution#2(CR 378764-2) for more details



CR:378766
CR Number:   378766
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Certification for Kerberos cross realm authentication



CR:378774
CR Number:   378774
Product Name:   Adaptive Server Enterprise
Product Component:   sybconfig
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2005 Fixed
08 Feb 2005 Fixed
Description
User can't choose the location of sybsystemdb device in syconfig.exe. It always use the device at %SYBASE%\data\sybsysdb.dat.



CR:378782
CR Number:   378782
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 Apr 2005 Fixed
Description
Preserve the functionality of traceflag 7703 indefinitely in all future versions



CR:378792
CR Number:   378792
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 13 Sep 2005 Fixed
Description
Documentation refers to incorrect location of libtcl.cfg.

The correct location for this file is $SYBASE/$SYBASE_OCS/config



CR:378870
CR Number:   378870
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)
16 Feb 2005 Fixed
Description
A 109 error, "There are more columns in the INSERT statement than values specified in the VALUES clause" will be reported by optdiag when using the -i (input) option to load a statistics file that contains a column list with more than one column.
Workaround Description
 This issue happens during insert of stats by optdiag in. When there are existing

statistics for the column combitation, optdiag does an update instead of insert.

The update does not hit the 109 error.

So an workaround should be: make sure there are statistics for the combination

of columns, so opdaig will update them.



CR:378915
CR Number:   378915
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)
29 Mar 2005 Fixed
23 Jul 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Add IPv6 support for ASE on Windows 2003 and HP-UX 11i.



CR:379119
CR Number:   379119
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)
24 Aug 2006 Fixed
22 Sep 2006 Fixed
28 Sep 2006 Fixed
Description
The sp_sysmon application monitor report does not report data for processes or applications.



CR:379128
CR Number:   379128
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)
15 Sep 2006 Not a Bug
Description
sp_sysmon output for appl_and_login breakdown is not correct.



CR:379200
CR Number:   379200
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)
10 Apr 2005 Fixed
27 Jun 2005 Fixed
Description
The error (warning) message 11290 "Distribution statistics for column '<column

name>' in index '<index name>' is unavailable or incomplete in the remote

server. UPDATE STATISTICS will not run in import mode." is displayed if UPDATE

STATISTICS on proxy table detects no entries in the remote systems statistics

catalogs. This warning message will no longer be displayed.



CR:379391
CR Number:   379391
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UX
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like ASE to work under HP Work Load Manager. More information can be found in the attached documents and at the following web sites:



http://docs.hp.com/en/netsys.html

http://www.software.hp.com/portal/swdepot/displayProductInfo.do?productNumber=B8843CA

http://www.usenix.org/events/osdi2000/wiess2000/full_papers/subramanian/subramanian.pdf
Workaround Description
 *** Monday, February 07, 2005 9:13:58 AM *** cooperg ***

N/A



CR:379449
CR Number:   379449
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)
10 Feb 2005 Fixed
Description
Deadlocks involving system tables may sometimes happen when a REORG REBUILD command is being run

concurrently with a CREATE TABLE command or other DDLs.



CR:379513
CR Number:   379513
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)
17 Mar 2005 Fixed
11 May 2005 Fixed
Description
The previous limit of eight databases for any QUIESCE DATABASE, MOUNT DATABASE or UNMOUNT DATABASE command has now been removed.
Workaround Description
 N/A



CR:379525
CR Number:   379525
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)
07 May 2009 Insufficient priority to fix
Description
When the expression joining a quantified predicate subquery is nullable, the

optimizer uses a "Positioning at index start" instead of "Positioning by key"

in a subquery.
Workaround Description
 select count(*) from k3 where convert(char(7),c3) not in (select c4 from k4)

go



CR:379527
CR Number:   379527
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)
29 Mar 2005 Fixed
Description
"sp_procxmode" on a stored procedure prefixed with a database name

different from the current database and no mode specification results in its mode

getting set to "Chained"; if the procedure exists.



CR:379621
CR Number:   379621
Product Name:   SQL Remote for Adaptive Server Enterprise
Product Component:   Database Tools Interface
Status:   Closed
OS:   Generic
Original Version:   7.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 3034 14 Feb 2005 Fixed
9.0.1 1989 14 Feb 2005 Fixed
8.0.3 5215 14 Feb 2005 Fixed
8.0.2 4519 14 Feb 2005 Fixed
7.0.4 3540 14 Feb 2005 Fixed
Description
It was possible for the SQL Remote for ASE Message Agent to become deadlocked while doing conflict resolution, but the ASE Consolidated database would not detect the deadlock. The deadlock is now properly detected by the consolidated database and the offending thread is rolled back and retried by the Message Agent. This fix introduced a change to the SQL Remote system tables in the consolidated database. When the SQL Remote for ASE binaries are upgraded, the script ssupdate.sql must be run against the consolidated database as well, to ensure that the schema of the SQL Remote system tables matches what the binaries are expecting.



CR:379670
CR Number:   379670
Product Name:   SQL Remote for Adaptive Server Enterprise
Product Component:   Ftp Messaging for Adaptive Server Enterprise
Status:   Closed
OS:   Linux
Original Version:   9.0.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 3033 15 Feb 2005 Fixed
9.0.1 1988 15 Feb 2005 Fixed
9.0.0 1398 15 Feb 2005 Fixed
Description
On Unix systems the SQL Remote Message Agent may have prompted for link settings, (ie host, username, password), when using the FTP or SMTP message links. If an end-of-file character was read, a garbage link parameter may have been set.
Workaround Description
 Resetting Replication



CR:379715
CR Number:   379715
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 Jun 2005 Fixed
Description
Built-in audit_event_name() returns a non-NULL string for supported audit events only and returns

NULL for unsupported events.



CR:379721
CR Number:   379721
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
enhancemdnt change request:

create config option--revert to pre 12.5 method of assigning spid numbers to

new connections



prior to version 12.5 ASE assigned spid numbers to new conncetions using a ..."lowest free spid #" method. Now with ASE 12.5 the method has changed to..."least recently used spid" method. The config option would give the customer the option to switch back to the pre 12.5 method of ..."lowest free spid #" method.



CR:379771
CR Number:   379771
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)
11 Jan 2006 Fixed
Description
Feature Request to raise warning error message when setting the number of memory dumps greater than one, and the dump file name is not default. This can result in overwritting the dump file.



CR:379813
CR Number:   379813
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 Apr 2005 Fixed
Description
Using 'SET STATISTICS TIME ON' to measure elapsed cpu time can result in negative time values.



CR:379852
CR Number:   379852
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2005 Fixed
Description
Temporary disable Monitor GUI in ASEP Galaxy Beta2 due to JRE1.1.8 remove from drop

area

No more Monitor Server selection in Server Properties or display of Monitor

folder.



CR:379866
CR Number:   379866
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2007 Fixed
Description
On servers running multiple engines the data returned by queries on the monDeviceIO Monitoring Table may be incomplete.



CR:379887
CR Number:   379887
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2007 Fixed
03 Oct 2007 Fixed
Description
When a threshold procedure fails to execute due to permission problems, it is unclear from the "Login failure" error that the threshold procedure ownership is the cause of the failure.



CR:379911
CR Number:   379911
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)
17 Oct 2006 Fixed
18 Oct 2006 Fixed
09 Aug 2007 Fixed
Description
For socket migration engine 0 is always a possible target. When using specific execution binding, the socket migration does not restricts the search to the set of engines associated to the execution class.
Workaround Description
 None.



CR:379991
CR Number:   379991
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 Feb 2005 Fixed
Description
The word "foreign" is misspelled as "forign" in error messages 1718 and 1724.



CR:380035
CR Number:   380035
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)
30 Jul 2006 Deferred
Description
After a connection migration failure, new incoming connections to ASE hang. If there are several new incoming connections, the earlier hung connections get released but the later ones now hang.



CR:380036
CR Number:   380036
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)
03 Aug 2006 Fixed
29 Aug 2006 Fixed
Description
Socket migration is vulnerable to interruption by signals
Workaround Description
 None.



CR:380059
CR Number:   380059
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)
12 Jan 2007 Fixed
19 Jan 2007 Fixed
Description
Feature request for a way to determine when a locked login became locked



CR:380069
CR Number:   380069
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
If RS is rebooted without doing sp_start_rep_agent, ASE RA may not reconnect upon RS startup.
Workaround Description
 Stop the rep agent before rebooting the Rep Server.



CR:380074
CR Number:   380074
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)
10 Mar 2005 Fixed
Description
Default job timeout value is now 60 instead of 1800.



CR:380102
CR Number:   380102
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)
16 Jun 2005 Fixed
Description
sp_reportstats doesn't report chargeback accounting statistics for users with sa_role



CR:380122
CR Number:   380122
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)
24 Feb 2006 Fixed
Description
A query assigning and using the same variable in the qualification may fail with errors

or produce incorrect result.



CR:380171
CR Number:   380171
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)
17 Nov 2005 Fixed
Description
CIS: When a setuser command has been issued on the session, create proxy_table

command will fail with Msg 911 and 11206.
Workaround Description
 Define external login using sp_externlogin for the remote user we want to impersonate.



CR:380184
CR Number:   380184
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)
18 Feb 2005 Fixed
Description
The JS-XX_X directory has been moved under the ASE-XX_X directory and renamed jobscheduler.



CR:380209
CR Number:   380209
Product Name:   SQL Remote for Adaptive Server Enterprise
Product Component:   Database Tools Interface
Status:   Closed
OS:   Generic
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 3034 15 Feb 2005 Fixed
9.0.1 1989 15 Feb 2005 Fixed
8.0.3 5216 15 Feb 2005 Fixed
8.0.2 4519 15 Feb 2005 Fixed
7.0.4 3540 15 Feb 2005 Fixed
Description
The SQL Remote for ASE Message Agent will now check to ensure that its version is not greater than the version of the SQL Remote system tables that exist in the target database. Previously, only the version of the stableq system tables were checked by the Message Agent.



CR:380433
CR Number:   380433
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.8 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2005 Fixed
10 Mar 2005 Fixed
01 Jul 2005 Fixed
Description
Applications using Dynamic SQL may encounter an "infected with 11 in sqt__release_chunks" message;

modules 'sequencer','lwp_create' and 'sqt_deallocate' are found in the stack trace for the terminated connection in the errorlog.
Workaround Description
 n/a





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