远程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:380474
CR Number:   380474
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)
09 Nov 2006 Fixed
Description
A database that once had replicated tables or stored procedures incorrectly

continues to appear as such. This can have different effects, for example, that

DBCC CHECKTABLE continues to unnecessarily check for replication information.
Workaround Description
 none. I'm not sure that having this bit reset makes a difference



CR:380498
CR Number:   380498
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2005 Fixed
Description
This release of ASE 12.5.3 ESD#3 has added a new platform support for the 64bit Linux for the AMD64 or Intel EM64T compatible processor.



CR:380800
CR Number:   380800
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)
09 Mar 2005 Fixed
17 Jan 2006 Fixed
Description
The message Msg. 702, "Memory request for <n> bytes exceeds the size of a single page of 16384 bytes",

is raised together with a stacktrace in the errorlog including the modules 'memalloc', 'q_oreop_fill'

and 'substitute' when a user executes a query with a very large IN-list in the WHERE-clause.
Workaround Description
 *** Tuesday, February 22, 2005 7:24:15 AM *** cooperg ***

None.



CR:380801
CR Number:   380801
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2005 Fixed
Description
The error 11068, "Transaction was found in the incorrect state of 'Command-attached'." will be raised

if a parallel select into fails due to lack of memory.
Workaround Description
 Take action to avoid the error preceding error 11068:

for error 701, increase the procedure cache (and/or decrease the number of sort buffers).



CR:380806
CR Number:   380806
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2005 One-off Provided
Description
Internal Only: Description below was included in EBF 12498, not needed in 12.5.3 ESD#2.

INSTRUMENTATION: ASE running on multiprocessor NT platforms with heavy use of ct_cancel

by client application may miss acknowledging one or more cancel operations leading to a

hang at the client end. Print diagnostics under traceflag 9999 to confirm the problem

was encountered and corrective action take by ASE.



NOTE: Fix for this problem is in ASE 12.5.3 ESD#2 under CR 377437



CR:380822
CR Number:   380822
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2005 Fixed
23 Feb 2005 Fixed
23 Feb 2005 Fixed
Description
SybMigrate not preserving identity values during migration. When migrating tables with identity columns the identity values were recomputed when created on the target server.



CR:380862
CR Number:   380862
Product Name:   Adaptive Server Generic Docs
Product Component:   XA Guide for CICS Encina and Tuxedo
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2007 Fixed
Description
Document that use of CIS features will cause a connection to affinity to a particular engine for the lifetime of the connection



CR:380995
CR Number:   380995
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2005 Fixed
01 Jul 2005 Fixed
Description
CIS: Segmentation fault occurred in routine omni_prune_subtree_cnvtnode() for select-into

queries against DB2 backends.
Workaround Description
 Replace the selectinto query with two queries:

1. select * into #tab from tab_exist where 1=2

2. insert into #tab select * from tab_exist where a in (111,121)



CR:381009
CR Number:   381009
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2005 Fixed
11 May 2005 Fixed
Description
Invoking sp_sjobcontrol with the run_now option does not result in the job being immediately run.

Instead, the job is run when another stored procedure request is handled or the next scheduled job comes due.



CR:381120
CR Number:   381120
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2005 Fixed
Description
Query performing outer join and OR strategy may return incorrect results.

This may happen if the Dynamic Index strategy is choosen by the optimizer

to execute the query.



CR:381168
CR Number:   381168
Product Name:   Adaptive Server Enterprise
Product Component:   Monitor Client
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2005 Fixed
Description
Hide Password information when display Monitor Viewer



CR:381170
CR Number:   381170
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)
28 Jun 2005 Fixed
Description
A 551 error, "An unknown EVAL was sent to the execution module" or signal 11 in modules like 'qualpage' or 'do__groups' may be reported in the

error log for a query with two GROUP BY clauses; in the main query and in a subquery, when it is executed in parallel.
Workaround Description
 Disable the paralleslim or don't execute the query specifying isolation level 0 (dirty read)



CR:381230
CR Number:   381230
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Unknown
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2005 Fixed
Description
CIS: Connections to remote servers are not disconnected and remain engine affinitied until the

client session terminates. The connections can now be dropped and detached from an engine after

executing a statement to the remote server by enabling Traceflag 11231. Exceptions are when the

statement is participating in cursor, transaction or stored procedure operations; or when ASE

is in either HA failover or failback states.



CR:381231
CR Number:   381231
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)
04 Mar 2005 Fixed
11 Oct 2005 Fixed
09 Mar 2005 Fixed
Description
The message "Type Code: 100019; Soft fault that has been upgraded to

a hard fault OAM entry is present but there is no allocation." may be

mistakenly reported by DBCC CHECKSTORAGE when it is run on a freshly

loaded database dump and the given database dump was taken on a busy

ASE environment initially.



CR:381301
CR Number:   381301
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)
20 Dec 2007 Fixed
02 Apr 2008 Presently Not Targeted For Any Future Release Of This Product
Description
On AIX, sp_helpdevice reports a "device_number" one greater than the actual value for device numbers greater than 127
Workaround Description
 select device_name = name, device_number = convert(tinyint,

substring(convert(binary(4), low), 1, 1)) from master..sysdevices

where cntrltype=0



CR:381308
CR Number:   381308
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2005 Fixed
01 Jul 2005 Fixed
Description
DBCC CHECKSTORAGE run for a database with no text/image data may fail

raising the error message "You cannot use the text workspace

'<TEXT_WORKSPACE_NAME>' for database '<DBNAME>'; required minimum size

is <X> KB. The workspace is only <Y> KB"



CR:381340
CR Number:   381340
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)
25 Mar 2008 Workaround
Description
In some cases, a cross-database INSERT of java datatype value fails with a java.io.EOFException
Workaround Description
 bcp the data out and bcp it into the other database



CR:381343
CR Number:   381343
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)
09 Dec 2005 Fixed
Description
System stored procedure sp_who may incorrectly report login name for a session

executing stored procedure if the stored procedure is being recompiled and the

procedure executor does not own the procedure being executed.



CR:381404
CR Number:   381404
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Release Bulletin-Adaptive Server Enterprise
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Fixed
Description
The sample in Release Bulletin ASE 12.5.2 is different than set proc_output_params actually works.



CR:381456
CR Number:   381456
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2005 Fixed
Description
sybmgmtdb log fills when installing Job Scheduler.



CR:381503
CR Number:   381503
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)
26 Feb 2009 Duplicate
Description
Feature request to provide automatic locking of login accounts that haven't been used for a configurable period.



CR:381526
CR Number:   381526
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)
16 Mar 2005 Fixed
25 Apr 2005 Fixed
Description
ASE may not be able to boot against a configuration file on HP and RS6000 platforms

due to number of file descriptor issues, even if the configuration file contains low values

for the number of user connections and the number of devices. ASE boot failure

reports in errorlog "Verification failed for parameter 'number of user connections'".
Workaround Description
 *** Wednesday, March 23, 2005 20:47:20 *** taghi ***

The workaround consists of configuring the machine to allow ASE to raise the

hard limit on fds to MAXFD, as specified in the platform documentation, or at

least for the current soft limit on the number of fds to be sufficiently high

with respect to the number of fds required by the configured values of user connections

and devices.



CR:381612
CR Number:   381612
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)
21 Nov 2006 Fixed
21 Nov 2006 Reservation Made
04 Oct 2007 Fixed
Description
Improve the performance of DROP INDEX and CREATE INDEX by releasing

the system catalog locks when not in DDL-IN-TRAN mode after the commit

of the transaction but before post commit work started. This enhancement

is triggered by -T3710 either at boot time or via DBCC TRACEON(3710).



CR:381629
CR Number:   381629
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2005 Fixed
Description
Correct this error: Device number greater than MAX Java Integer value will display as zero.



CR:381706
CR Number:   381706
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)
05 Jun 2007 Fixed
Description
Feature request to enhance password encryption algorithm key to 128 bits or better



CR:381815
CR Number:   381815
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2005 Fixed
17 Mar 2005 Fixed
22 Mar 2005 Fixed
Description
Remove the limit of 1024 elements in the IN() clause.



CR:381820
CR Number:   381820
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)
08 Mar 2005 Fixed
Description
The message "current process (0x1c001c) infected with 11" together with a stacktrace involving module "compare_value" may be seen when a range query involves NULL date, time or bit values.



CR:381821
CR Number:   381821
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2005 Fixed
Description
The command ONLINE DATABASE reported a syntax error if the database name was passed enclosed in singled quotes.



CR:381823
CR Number:   381823
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)
25 Apr 2005 Fixed
Description
DUMP DATABASE now has a WITH VERIFY [= HEADER | FULL ] option.

This performs basic page header sanity checks (HEADER) and both

page header checks and intra-page row checks (FULL) on every page

that is dumped by the Backup Server.



CR:381856
CR Number:   381856
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to allow use of varaibles for object names in place of literal values in TSQL code, as in "select * from @mytablename"



CR:381870
CR Number:   381870
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 Mar 2005 Fixed
01 Jul 2005 Fixed
04 Jul 2005 Fixed
04 Jul 2005 Fixed
04 Jul 2005 Fixed
19 Oct 2005 Presently Not Targeted For Any Future Release Of This Product
Description
An 834, 821, 8201 and other errors may be reported when ONLINE DATABASE is performed on a fully onlined database.
Workaround Description
 Do not online a fully onlined database.



CR:381924
CR Number:   381924
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)
20 May 2005 Not a Bug
Description
Inccorrect values for sysindexes maxirow column are not corrected when executing dbcc checkcatalog(db,fix)
Workaround Description
 [May 20 2005, frankl]

This is not a bug, you should use dbcc checkcatalog(pubs2,fixall) to also

fix incorrect maxirow for system tables.



CR:381985
CR Number:   381985
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)
08 Jun 2005 Fixed
08 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
08 Jun 2005 Fixed
20 Jun 2005 Fixed
21 Jun 2005 Fixed
07 Jul 2005 Fixed
07 Jul 2005 Fixed
19 Jul 2005 Fixed
18 Jul 2005 Fixed
Description
ASE ships the sample program, sybmapname.c, in $SYBASE/$SYBASE_ASE/sample/server but there is no accompanying README file to explain the purpose of the program, care to be taken with implementing it, hints of coding useage etc. This CR is to request engineering/build to provide a suitable README in the same directory (or other documentation) as the program itself.
Workaround Description
 preliminary README (amadsen - thanks)

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



README:



This README accompanies sybmapname.c sample code for ASE.



Files in the example:



README - this file

sybmapname.c - sample filters out @realm and sets name in uppercase

makefile - example makefile to build for 64bit solaris





This example for name filtering is intended to only be used with

Kerberos security mechanism in ASE. This example assumes that

ASE has already been configured for Kerberos.



Build the shared object (DLL) using the makefile supplied.

For other platforms or to build 32bit solaris, the makefile

needs to be modified.



Place the resulting shared object libsybnamename.so in

$SYBASE/$SYBASE_OCS/lib directory. The file should have read and execute

permissions for the 'sybase' operating system user, that is,

the operating system user that is used to execute the ASE dataserver

program. It is recommended that only the 'sybase' user be allowed

read and execute permissions, all other access should be denied.



Verify with login to ASE using kerberos authentication.





Cautions: Take care with the sample program and any modifications

to it to avoid code that may segfault, that may call exit(), that

may call system calls(), that may change UNIX signals, or

make any blocking calls. Inproper coding or calls may interfere

with the ASE server (engine) currently running.



Code defensively, check all pointers before dereferencing them,

avoid system calls. This must be a quick name filtering function.





Feb 25 2005



CR:382028
CR Number:   382028
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 May 2009 Insufficient priority to fix
Description
Feature request for a syntax shortcut to create sharable temporary tables in the currently bound tempdb analogous to the use of "#" to create private temporary tables.



CR:382129
CR Number:   382129
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)
28 Mar 2005 Insufficient priority to fix
Description
605 or 69x errors may be reported when loading a dump of a pre 11-9 database of size less than or equal to (n * 63) GB into a database of size greater than (n * 63) GB (for n = 1, 2, 3...).
Workaround Description
 the following will fix the problem pg_gam(dbid, -1, -1, fix)



CR:382140
CR Number:   382140
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)
08 Mar 2005 Fixed
Description
The message "current process infected with 11" may be reported

in the module 'ind__get_sysindrow' when DBCC LISTOAM is run with an

object ID value that is not a table. The stack trace in the error log

will also report the modules 'ind_getval' and 'pg_list_oam'.



CR:382145
CR Number:   382145
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2008 Duplicate
Description
Outgoing ct-lib connections (via CIS or Replication Agent) may hang when the primary DNS is down. Also, if the outgoing connection is being done from engine zero, ASE server could stop accepting new connections.



CR:382169
CR Number:   382169
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   NA
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2006 Fixed
02 Jul 2007 Insufficient priority to fix
Description
Historical Server README File incorectly states the ASE server name is a column in the output tables
Workaround Description
 Join Output table and sessions table to obtain the ASE server name



CR:382241
CR Number:   382241
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)
17 Jul 2005 Fixed
11 Feb 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
A SELECT statement might run very slowly when a BIT column is involved in the WHERE clause. This could now be resolved by turning on traceflag 15303.



CR:382258
CR Number:   382258
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2005 Fixed
Description
During session termination, if session has done a messaging operation (msgsend(),

msgrecv(), msgpublish(), or msgconsume()), a stacktrace (signal 11) may occur. The

stacktrace in the errorlog will contain um_destroy_conn().



CR:382284
CR Number:   382284
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2005 Fixed
23 Mar 2005 Fixed
16 Mar 2005 Fixed
22 Mar 2005 Fixed
Description
New feature: support added in migration tool to allow encrypted column migration.



CR:382293
CR Number:   382293
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)
14 Mar 2005 Presently Not Targeted For Any Future Release Of This Product
10 Mar 2005 Fixed
Description
The message, "current process infected with 11" in the module 'sendichars()' together with a

stacktrace containing the modules 'lwp_create', 'tdssend_dynparams' and 's_crtproc' is

printed in the errorlog when sending a batch of dynamic SQL commands which in total have more than

255 dynamic parameters.
Workaround Description
 limit the number of placeholders (?) in a batch of Dynamic SQL statements to 255.



CR:382323
CR Number:   382323
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 May 2009 Insufficient priority to fix
Description
PARSER: Error 7348 is not consistently raised when duplicate column headings are used.



CR:382355
CR Number:   382355
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2005 Fixed
13 Jun 2005 Fixed
Description
Improve housekeeper garbage collection rate for index pages under aggressive GC option.



CR:382386
CR Number:   382386
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)
10 Mar 2005 Fixed
Description
Replication Agent may do not sent the after image of an update if the column is defined as unsigned smallint.



CR:382474
CR Number:   382474
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 Fixed
Description
1) Referrals are chased automatically when LDAP user authentication

mechanism is used by ASE which results in failure.



2) The sp_ldapadmin check_login 'login_name' fails.



CR:382522
CR Number:   382522
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2005 Fixed
29 Jun 2005 Fixed
07 Jul 2005 Fixed
Description
When UPDATE STATISTICS is run on proxy table that maps to a remote view, the

command fails with some diagnostic errors in the ASE error log file.
Workaround Description
 The problem can be worked around using traceflag 11229.



CR:382542
CR Number:   382542
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)
15 Mar 2005 Fixed
23 Jun 2005 Fixed
Description
Spinlock contention on the memory pool that manages the 'heap memory per user' configuration

parameter may be observed on a heavily-used multi-engine Adaptive Server.
Workaround Description
 Increasing "heap memory per user" from the default 4K to 16K should significantly reduce

the contention on the heap block pool.



CR:382548
CR Number:   382548
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2005 Fixed
02 Jun 2005 Fixed
Description
The concurrent execution of a batch or a stored procedure that contains

the commands CREATE INDEX on a partitioned table, DROP of a partitioned table,

and SELECT-INTO that is run in parallel, may cause an undetected deadlock

scenario between the concurrent tasks, requiring an ASE restart to unblock

the situation.
Workaround Description
 For our in-house unit, trace flag 5303 (select-into run in serial)

will avoid the hang situation. The trace flag 4915 (ex_tab vs. ex_int

on syspartitions) won't be of help here. Suggest trace flag 5303 usage,

granted that the customer is running similar stuff with our in-house unit.



CR:382555
CR Number:   382555
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)
25 Mar 2005 Fixed
13 Jun 2005 Fixed
Description
A 12314 error: "Bad child page pointer found on page <pageno> of index with id <indid> of table <tabname> in database <dbname>. Expected child page pointer to be <pageno1> but found <pageno2>. Check if the index is consistant using DBCC." may be encountered while running a lot of concurrent INSERTs, DELETEs and UPDATEs on a DATA_ONLY locked table.



CR:382645
CR Number:   382645
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 May 2005 Fixed
Description
An error "Incorrect syntax near ')'." is reported with sp_helpdb if wildcards are used and a single match is returned.



CR:382686
CR Number:   382686
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2005 Fixed
Description
Feature request to let the backup server check the logical page number consistency as the pages ar copied to the dump archive. The feature is enabled if the backup server is started with trace flag -D64.



CR:382697
CR Number:   382697
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2005 Not a Bug
Description
ASE fails to describe the name of input parameters for dynamic prepare

statement: ct_dynamic(CS_DESCRIBE_INPUT)
Workaround Description
 When the application gets ready to execute the prepared

statement, it must describe and send the parameters with ct_param()

or ct_setparam() so in most cases, the application programmer

knows what parameters they are trying to insert.



An example of describing the input parameters for the insert statement:

/* Execute phase of the dynamic statement */

ret = ct_dynamic(cmd_ptr, CS_EXECUTE,

"d_insert", strlen("d_insert"),

NULL, CS_UNUSED);

RETURN_IF(ret, "execute phase failed");



/* prepare the first parameter description */

strcpy( param_fmt.name, "dynamic_ins");

param_fmt.namelen = strlen(param_fmt.name);

param_fmt.status = CS_INPUTVALUE;

param_fmt.datatype = CS_INT_TYPE;

param_fmt.format = CS_FMT_UNUSED;

/* set up the first paramenter */

ret = ct_param(cmd_ptr, ¶m_fmt, &col1, CS_SIZEOF(col1),

CS_UNUSED);

RETURN_IF(ret, "parameter one setup failed");



CR:382699
CR Number:   382699
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2008 Deferred
Description
ASE does not support TDS_PROTO_DYNAMIC capability per TDS Specification



CR:382806
CR Number:   382806
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)
28 Jul 2005 Fixed
03 Oct 2005 Fixed
11 Jan 2006 Fixed
Description
sp_addtype does not support the new feature allowing IDENTITY with INTEGER datatypes.



CR:382808
CR Number:   382808
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)
24 Mar 2005 Fixed
Description
The message "timeslice -501, current process infected" is raised together with a stacktrace

printed in the errorlog containing the modules 's_crtproc', 'lwp_create' and 'make_negative_obj_id'

when sending large amounts of dynamic SQL statements to the server without deallocating these

dynamic SQL statements.
Workaround Description
 Use ct_dynamic() with CS_DEALLOC for each prepared statement finished. In the

repro this part is commented out and therefore one will see the stacktrace

+ timeslice error.



CR:382824
CR Number:   382824
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 an easier method to retrieve data from a corrupt table



CR:382837
CR Number:   382837
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)
15 Aug 2005 Not a Bug
Description
Sybase Central ASE Plug-in and Interactive SQL (DBISQL) display binary datatype values differently depending on the size. Trailing 0's are displayed for size less than 256.



CR:382855
CR Number:   382855
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 Apr 2005 Fixed
Description
When the errors 1131 and 1142 are raised by the OAM builtins such as data_pgs()

or used_pgs(), they are unexpectedly also written in the ASE's error log.
Workaround Description
 May want to use trace flag 1116.



CR:382856
CR Number:   382856
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)
24 Dec 2009 Duplicate
24 Dec 2009 Duplicate
24 Dec 2009 Duplicate
Description
The spinlock monitor area should dynamically increase to accomodate spinlock pool growth.
Workaround Description
 Reboot the server to cause the correct number of spinlock monitor counters to be allocated.



CR:382892
CR Number:   382892
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2005 Presently Not Targeted For Any Future Release Of This Product
23 Dec 2005 Fixed
23 Dec 2005 Fixed
20 Mar 2006 Fixed
09 Jan 2006 Fixed
Description
A new column RowsAffected has been added to monSysStatement and monProcessStatement indicating the number of rows affected by the completed statement and by the currently running statement, respectively. For monSysStatement, this columns corresponds to the value of @@rowcount after the statement's execution.



CR:382905
CR Number:   382905
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)
16 Mar 2005 Fixed
Description
Remove Preview from Proxy Table wizard



CR:382961
CR Number:   382961
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)
18 Mar 2005 Fixed
Description
In Warm Standby Replication environments replicating DDL, a drop command may be incorrectly replicated if the object is using a large identifier.



CR:383017
CR Number:   383017
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)
03 Jun 2005 Fixed
Description
JISQL and SQL Advantage are removed from Utilities folder. These tools are replaced by Interactive SQL.



CR:383040
CR Number:   383040
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2005 Fixed
Description
CIS: Occasionally, on a heavily-loaded multi-engine system, the message "current process infected with 11" or "current process infected with 10" together with some stacktraces including different modules may be reported in the error log, and sometimes some ASE engines hang as well when running some CIS queries with 'set showplan on' option enabled.



CR:383052
CR Number:   383052
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)
11 Apr 2005 Fixed
Description
Add more explanations and instructions about default and rule expression, as

wizard should be self explanatory.



CR:383053
CR Number:   383053
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)
03 Apr 2005 Fixed
Description
Contention on the procedure cache and the heap block pool governed

by the "heap memory per used" configuration parameter is reduced by

the addition of a spinlock specifically to synchronize access to

the heap block pool.



CR:383054
CR Number:   383054
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)
19 Apr 2005 Fixed
Description
Spinlock contention can be caused by housekeeper license information chore on server with a high number of user connections configured.
Workaround Description
 sp_configure "license information",0 will disable this functionality and avoid the

problem



CR:383064
CR Number:   383064
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2006 Fixed
Description
CIS: ct_command call may stack trace with Signal 11 at ct__api_new_sendcmd or Memory allocation failure message.



CR:383069
CR Number:   383069
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2005 Fixed
15 Jan 2006 Fixed
17 Jan 2006 Reservation Made
Description
In some cases, the message "current process infected with 11" in the module

'constree' together with a stack trace which includes the modules 'com_resdoms'

and 'com_query' may be reported in the error log when referencing a

column more than once and that column is defined as a subquery within a view.



CR:383083
CR Number:   383083
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)
14 Apr 2005 Fixed
19 Aug 2005 Fixed
Description
A transaction will be incorrectly rolled back when rolling

back to a save point that follows a save point to which a

rollback has already been performed.



CR:383410
CR Number:   383410
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)
01 Apr 2005 Fixed
Description
New feature request to export the set options textsize, stringsize and rowcount to the caller process of a login trigger. Currently this is enabled under trace flag 4073 only.



CR:383435
CR Number:   383435
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2005 Fixed
Description
Not visible to user.



CR:383617
CR Number:   383617
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2006 Third Party Problem
13 Dec 2007 Third Party Problem
Description
On the Solaris platform, ASE may encounter undetected deadlocks, hung "waitfor" commands or database and transaction dumps, and similar problems when the operating system time is changed to an older date / time. This problem will resolve itself once the OS time moves ahead of where it

was when it was set backwards.
Workaround Description
 Either wait it out, or reboot ASE when the OS clock moves backwards.



The OS time should be changed by a delta approach. See adjtime/date -a.

This adjusts the time but avoids UTC going backwards.



Changing the OS time to simulate daylight saving changes is very

artificial and is not what happens under the covers when daylight

saving transitions happen... i.e. UTC is always going forwards and

it is just the calculated wall clock time that changes.



CR:383660
CR Number:   383660
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.4 17 Jan 2006 Fixed
23 Jan 2006 Presently Not Targeted For Any Future Release Of This Product
Description
A Schedule's Between time option is not being saved when selected.
Workaround Description
 *** Thursday, March 17, 2005 2:52:57 PM *** cooperg ***

Make sure you always re-check the radio button for Between before applying changes to repeating Jobs.



CR:383690
CR Number:   383690
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2005 Fixed
Description
Request to add description about error 880 message like below.

"Your query is blocked because it tried to write and database 'testdb' is in

quiesce state. Your query will proceed after the DBA performs QUIESCE DATABASE

RELEASE."



CR:383691
CR Number:   383691
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)
13 Apr 2005 Fixed
Description
Feature request to turn off error 880 message "Your query is blocked

because it tried to write and database '<dbname>' is in quiesce state.

Your query will proceed after the DBA performs QUIESCE DATABASE

RELEASE." The behavior is activated using trace 833 in the runserver

file.



CR:383722
CR Number:   383722
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)
11 Apr 2005 Fixed
23 Apr 2005 One-off Provided
22 Jun 2005 Fixed
Description
In rare circumstances, a 605 error "An attempt was made to fetch logical page <page> belongs to

object with id ..." may be reported by a table scan on a DOL table when a slow BCP IN command has

been previously run parallel on this table. Only expected for a 64 bits server with more than one

engine or a 32 bits server which is started with -T712.
Workaround Description
 Possible w/a:



- disable LSA with TF 1101



CR:383744
CR Number:   383744
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2006 Fixed
06 Mar 2006 Fixed
16 Mar 2006 Fixed
Description
Space allocation is not optimal when inserting rows into an APL table

having a clustered index and if the conditions are such that this table

can hold 256 rows per page.
Workaround Description
 Create the inserted APL table using the 'with max_rows_per_page = 255' clause.



CR:383946
CR Number:   383946
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Presently Not Targeted For Any Future Release Of This Product
Description
SUBCASE NUMBER: 11122441-11

DATE: Fri Mar 18 12:47:23 EST 2005



TSE Login Name: marinak -- Marina Vilensky

CUSTOMER NAME: Federal Express

BASIC INFORMATION:

Cust requeted to provide a new feature:



Parallel Union All (high need)

==============================

Currently in ASE, a union-all query is processed serially with each result set

materialized in order. FEDEX would like the union-all to be able to execute in

parallel - effectively with the same result set processing that a parallel query

on a partitioned table in pre-15.x servers (in other words, results are set

immediately through a family synch vs. held until previous query is complete).

This would be controlled by %93max parallel degree%94/%94set parallel_degree%94 setting

as well as by the parallel query controls (another Feature Request addressed by

the subcase 11122438-11).



ADDITIONAL INFORMATION:

CR 362551 addresses a similar issue (Query with more than one union all is not

run in parallel). It is a defect CR and is fixed in ASE 15.0.



If the fix for the existing CR 362551 covers cust's request please associate

this subcase with CR 362551. Otherwise, please open a new feature request.



PLATFORM: Sun, HP.

Operating System: Solaris, HP-UX

Customer's ASE Release Version: 12.5.1 ESD#2 for 64-bit release.
Workaround Description
 *** Monday, March 21, 2005 9:02:01 AM *** cooperg ***

N/A



CR:383950
CR Number:   383950
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jul 2005 Fixed
30 Jun 2005 Fixed
Description
Maintain high-water mark for monSysStatement.MemUsageKB to reflect the max. amount of procedure cache memory allocated by each individual statement.



CR:383962
CR Number:   383962
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 Jun 2007 Fixed
Description
Message 18472 is raised by sp_dbcc_delete_history and is an informational message that should be printed rather than raised as an error.



CR:383967
CR Number:   383967
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 minimal-impact tool to fix misplaced extents in wrong segments without requiring entire table be reorganized.



CR:384050
CR Number:   384050
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)
29 Jun 2005 Bundled Request
16 Jun 2005 Fixed
06 Jun 2005 Fixed
Description
In rare circumstances, on a multi-engine ASE running with traceflag 1641, heavy

disk i/o load can result in ASE client hang. In some situations it could also

lead to server shutdown.



CR:384112
CR Number:   384112
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)
27 May 2005 Fixed
Description
For long job or schedule descriptions some of the description text may not be visible.



CR:384140
CR Number:   384140
Product Name:   Adaptive Server Enterprise
Product Component:   Monitor Client
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2010 Fixed
05 Mar 2010 Fixed
15 Mar 2010 Fixed
Description
Failed to build sample programs testmon and testhist on multiple platforms.
Workaround Description
 Compile on AS 2.1 with Makefile_linux_native



CR:384203
CR Number:   384203
Product Name:   Adaptive Server Generic Docs
Product Component:   Utility Guide
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2007 Fixed
Description
-Y option of bcp 12.5.x does not support unilib conversion.



CR:384212
CR Number:   384212
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2005 Fixed
Description
The message current process infected with 11 in treecpynames() with a stacktrace is printed in the

errorlog containing the modules 'execproc', 's_compile', 'vu_viewcopy' when statement cache is

enabled and a statement containing a derived table expression is send to the server.
Workaround Description
 switch off stmt cache



CR:384216
CR Number:   384216
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)
26 Jun 2005 Fixed
Description
UPDATE STATISTICS on proxy table may fail with error 10353 "You must have

the following role(s) to execute this command/procedure: 'sa_role'".
Workaround Description
 Enable 11229. This also means that UPDATE STATS on proxy table will be done

with the old behavior.



CR:384233
CR Number:   384233
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)
23 Mar 2005 Fixed
Description
Not customer visible



CR:384234
CR Number:   384234
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2005 Fixed
21 Jul 2005 Fixed
Description
In multi engine scenario running a "disk resize" on an engine other than the one on which device has been initilized fails with an error 5166.
Workaround Description
 Bind a session to the engine already holding the advisory lock on the raw device being resized and execute 'disk resize' from that session.

Use lsof or analyse the errorlog (look at the engine number for the message "Virtual device %d started using %s i/o").



CR:384261
CR Number:   384261
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)
08 Apr 2005 Fixed
Description
Under some conditions when an error occurs during SELECT INTO statement execution the Adaptive

Server may attempt to unslice just created table even if this table is not sliced.

While in majority of cases this action will not do any harm sometimes it may lead to errors

like 622 ("Opentable was passed a varno of 2. Object already has that session descriptor in use.",

216 ("Attempt to automatically drop temporary table failed. ") and 3702 ("Cannot drop the table

because it is currently in use. ")
Workaround Description
 change the subselect used to assign the column_variable so it returns only on item instead of multiple items...basically get rid of the 512 error.



CR:384412
CR Number:   384412
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)
27 Apr 2005 Fixed
21 May 2005 Fixed
Description
Error message 14513 requires two arguments (the database name, and name length), but ASE was providing none. The result was a poorly formatted error message, or, on some platforms, a stack trace and terminated connection.



CR:384429
CR Number:   384429
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 Sep 2005 Not a Bug
Description
Feature request: BCP to work when using -E for a table without identity column.



CR:384452
CR Number:   384452
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2006 Bundled Request
Description
Previsouly ASE Plug-in does not allow editing in place for compiled objects (stored procedures, views, etc.). This has been changed in 15.0 ESD#2 to allow editing when "DDL in tran" database option is enabled.
Workaround Description
 Right click on your stored procedure, select "Generate DDL".

Make edits in DDL generator and save file as T-SQL.

Use another application (such as ISQL) to run the modified T-SQL script.



CR:384613
CR Number:   384613
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
01 May 2005 One-off Provided
Description
Segmentation violations in third pary Kerberos client libraries cause

ASE crashes and denied access with high numbers of concurrent Kerberos

authentication attempts from OpenClient applications.



When using MIT Kerberos client library version 1.3.1 or earlier

you can start ASE with traceflag 7844 that limits concurrent Kerberos authentications

to avoid segmentation violations. The traceflag is not needed with

CyberSafe or MIT verion 1.4 client libraries.



CR:384621
CR Number:   384621
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 Bundled Request
Description
On platforms that support Kerberos, a catastrophic failure, such as

when a segmentation violation or a call to the C library routine

"abort()" has occurred within the 3rd party Kerberos

client libraries, results in error message:

"Internal error - Security Control Layer (SCL) is unavailable

on this engine and cannot support any external security mechanisms".



The error path also disables Kerberos operations on that engine.



The fix intercepts execution in the error path to release resources

and allows Kerberos operations to continue on that engine.



CR:384649
CR Number:   384649
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Fixed
Description
On the Windows platform the message "Could not get context for engine %d because engine is

running." may apppear in the errorlog during a configured shared memory dump.
Workaround Description
 Ignore the message, it is harmless



CR:384731
CR Number:   384731
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)
22 Feb 2006 Fixed
Description
Command text auditing was erroneously capturing the SQL text of

stored procedures during upgrade.



CR:384733
CR Number:   384733
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2006 Bundled Request
Description
Generate a warning message when a query is performed on the monOpenObjectActivity MDA table when the monitored server does not have the 'lock wait timing' configuration option enabled.





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