远程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:664980
CR Number:   664980
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2011 Fixed
Description
When option show_sqltext is turned on some sql statements like use db1, drop proc or drop table, exec proc1 are not traced properly, message like "No useful sqltext available" gets printed instead of the actual sql executed.



CR:664984
CR Number:   664984
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2011 Fixed
Description
When executing an INSERT-SELECT query from a proxy table having a LOB column into a local table, a NULL value may be inserted into a LOB column on the local table if a cursor is opened on any proxy table.
Workaround Description
 Add -T11239 into a command line in the RUN server file. But it can drop insert-select performance.



CR:665006
CR Number:   665006
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Separate Audit Event for ASE and Backup Server



CR:665043
CR Number:   665043
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2011 Fixed
06 May 2011 Fixed
28 Jun 2011 Fixed
25 Jun 2012 Bundled Request
26 Jun 2012 Fixed
Description
The following is observed when 'restricted decrypt permission' is configured:



(1) a table owner who has decrypt permission on an encrypted column through group membership

is not permitted to select decrypted data from the column.



(2) sso_role who should have implicit decrypt permission is not permitted to select decrypted data from the column and is not permitted to insert into the column when trigger present on the table



(3) a table owner who has been granted decrypt permission through a user defined role is not permitted to insert data into the column when trigger present on the table



CR:665170
CR Number:   665170
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2011 Fixed
Description
sp_shmdumpconfig raises message 18502 when an "error" dump type is specified when "message" should have been specified. This CR is a feature request to find ways to reduce the confusion between the two types of dump conditions.



CR:665201
CR Number:   665201
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2011 Fixed
01 Jun 2011 Fixed
Description
The message "current process infected with 11" in the module 'rec__ctx_cleanup'

together with a stack trace which includes the modules 'dsinit' and 'rec__backout'

may be reported in the error log during ASE startup if a 708 error, "There is

insufficient system memory to run kernel task. spid <value>, kpid <value>."

was previously reported in the error log.



CR:665247
CR Number:   665247
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Control GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2011 Duplicate
Description
A segmentation violation occurs with utilities certreq and certpk12 when the

password is provided as a parameter on the command line.



CR:665251
CR Number:   665251
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2011 Added to user documentation
Description
DocCR : the style 14/114 is listed twice with different specs at BulidingBlock manual.



CR:665257
CR Number:   665257
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 Control GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2011 Fixed
15 Apr 2011 Fixed
25 May 2011 Fixed
25 May 2011 Fixed
12 Oct 2011 Bundled Request
01 Oct 2012 Bundled Request
09 Nov 2012 Fixed
Description
Under certain circumstances, ASE may fail to boot under the UTF-8 nocase sort order and an 8211 error "Mismatch found between the name and id descriptor hash table for table..." may be seen.
Workaround Description
 Use -T8211 to revert to the old DES hash computation algorithm.



CR:665266
CR Number:   665266
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2011 Fixed
Description
In an HA environment if sp_addexternlogin issued on a HA server to add an externlogin

for a non-ha server the following message will be issued by the companion server:

Msg10330,燣evel14,燬tate1:

Server'gree1_22760',燩rocedure'sp_attrib_notify':

EXECUTE爌ermission燿enied爋n爋bject爏p_attrib_notify,燿atabase爏ybsystemprocs,

owner燿bo



CR:665284
CR Number:   665284
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2013 Presently Not Targeted For Any Future Release Of This Product
11 Dec 2012 Reservation Made
04 Dec 2012 Fixed
01 May 2013 One-off Provided
01 May 2013 Port Not Needed
Description
The message, "Current process infected with signal 11" followed by a stack trace that includes

the module Partitions::initHintsForDegree() may be reported when a remote procedure is executed with the recompile option.
Workaround Description
 Turning on compatability mode, either at server level or within the procedure works around the issue.



CR:665367
CR Number:   665367
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Microsoft Windows
Original Version:   11.6.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: support Sysam license server on a VMWare VSphere win2008 x64 SP2 that can host multiple licenses for multiple platforms and products.



CR:665426
CR Number:   665426
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 Control GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2011 Presently Not Targeted For Any Future Release Of This Product
Description
langinstall for non-us_english languages gives errors because several new messages have not yet been translated in their server.loc files.



CR:665525
CR Number:   665525
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Error 221 is raised when UNION is applied to a view containing an outer join returning a BIT value from the inner table. The same error is not raised when tables are used directly.
Workaround Description
 Convert to TINYINT in place of BIT.

(using ISNULL() does not work as a workaround).



CR:665639
CR Number:   665639
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows 2008
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2011 Fixed
Description
When 'statement cache' and 'literal autoparam' are configured on ASE the @@identity retains a non-zero value after an INSERT into a table that contains no IDENTITY column.
Workaround Description
 Disable 'statement cache' and 'literal autoparam'.



CR:665651
CR Number:   665651
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2011 Fixed
Description
If server has 'capture missing statistics' enabled, and if multiple parallel threads execute queries involving a column for which stats are missing, then all such threads would try to insert the missing stats; one of the threads would succeed, and the others would get 2601 error leading to

transaction and command rollback.



CR:665658
CR Number:   665658
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Infected with 11 in EquivClass::eqcFindPdTreeLogProps
Workaround Description
 1. Set optimizer level to ase_default

or

2. Set traceflag 15363 or set alternative_greedy_search off



CR:665666
CR Number:   665666
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2011 Fixed
11 Apr 2011 Fixed
Description
Specifying "as template" in a sql select list incorrectly reports a syntax error.
Workaround Description
 select c1 template from table



or



select c1 as "template" from table



CR:665715
CR Number:   665715
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2011 EOL'd version. Not to be Fixed.
10 May 2012 Fixed
26 Sep 2012 Fixed
07 Nov 2012 Fixed
Description
The message "current process infected with 11" in the module 'bufdlink'

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

'bufpindirty' may be reported in the error log when a table was in the

process of being created and ASE has previously hit a 1204 error "ASE has run

out of LOCKS. Re-run your command when there are fewer active users, etc.".



CR:665786
CR Number:   665786
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Windows
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.5 ESD #6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2011 Added to user documentation
Description
Sybase installation account on Windows must have membership of the 'Adminstrators' group to allow creation of Windows Services entries.



CR:666213
CR Number:   666213
Product Name:   Adaptive Server Generic Docs
Product Component:   Other
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2011 Presently Not Targeted For Any Future Release Of This Product
Description
The 15.x Monitor Server User's Guide indicates that a login named mon_user is installed on windows. This login is no longer installed or used as of 15.0.



CR:666239
CR Number:   666239
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2012 Fixed
Description
The limit for cache partitioning has been extended from 128 to 256.



CR:666245
CR Number:   666245
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2011 Added to user documentation
Description
doc bug: CR 490866-3 doesn't show global cache partition limit as 128



CR:666362
CR Number:   666362
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2011 Fixed
27 Jul 2011 Fixed
17 May 2011 Presently Not Targeted For Any Future Release Of This Product
Description
A signal 11 may be reported with a call stack involving the modules 'do_bt_release_rlocks' and

'rec_undo_session' while accessing the buffer address from an address lock of an APL page.



CR:666371
CR Number:   666371
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2011 Fixed
19 Apr 2011 Reservation Made
Description
TF2792 blocking on user table for select operation.



CR:666375
CR Number:   666375
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2011 Fixed
15 May 2011 Reservation Made
21 Jun 2011 Fixed
28 Sep 2011 Reservation Made
26 Mar 2014 Already Fixed by Another CR
Description
New interface sp_chgattribute <objectname>, 'ptn_locking', 0/1 to enable/disable partition locking



CR:666423
CR Number:   666423
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)
14 Apr 2011 EOL'd version. Not to be Fixed.
Description
A 644 error and the message "Invalid DOL data row pointer ... must be the forwarded row location" is raised when using ALTER TABLE to add an IDENTITY column to a datarow table that has forwarded rows. Run reorg forwarded_rows and try the ALTER again.
Workaround Description
 Run reorg forwarded_rows and try the alter again.



CR:666460
CR Number:   666460
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2011 Fixed
01 Jun 2011 One-off Provided
02 Jun 2011 Fixed
Description
Parallel BCP connections on an indexed DOL table might block each other while loading data into the same data partition.



CR:666556
CR Number:   666556
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2012 Fixed
21 Aug 2012 Reservation Made
Description
Performance of sp_spaceused procedure is very slow when executed to get the space metrics for the entire database, especially so for databases with a very large number of objects and indexes. Improve the performance of this procedure by applying server-side changes along with a re-work of the procedure's logic. A new installmaster along with new ASE binary is needed to deliver this performance improvement. (The stored procedure changes alone are not sufficient).



CR:666577
CR Number:   666577
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2011 Fixed
09 Aug 2011 Fixed
15 Sep 2011 Fixed
16 Sep 2011 Fixed
Description
Cannot access Monitor Server counters from Sybase Central when SQL Server names are different in client and server side interfaces file.



CR:666597
CR Number:   666597
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2013 Fixed
Description
New Feature Request ... add indicator to monCachedProcedures to show active entries



CR:666643
CR Number:   666643
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances, the extra convert() added on numeric columns in SELECT-list

with UNION ALL can improve the compilation performance in ASE 15.x.



CR:666702
CR Number:   666702
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Run 3 or more session running unmount database can dead lock on sysdevices.
Workaround Description
 make your unmount database command in a sequential way.



CR:666720
CR Number:   666720
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2011 Fixed
25 May 2011 Fixed
Description
If an index whose length is larger than 32767 is defined on a DOL table, some problems may be encountered when using the index.



CR:666728
CR Number:   666728
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)
11 Oct 2011 One-off Provided
04 Oct 2012 Fixed
04 Oct 2012 Fixed
24 Apr 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Update the Open Server Components of ASE to provide essential Open Server vulnerability fixes.



CR:666814
CR Number:   666814
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2011 Fixed
27 Apr 2011 Reservation Made
Description
Executing a dynamic SQL query may hit SIGSEGV along with stack trace involving modules sqt_relocate(), sqt_fix_xoltp() and tdsrecv__dynexec_xoltp().



CR:666828
CR Number:   666828
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2011 Not a Bug
Description
New Feature to use different method to determine if cluster takeover is possible.



CR:667025
CR Number:   667025
Product Name:   Adaptive Server Enterprise
Product Component:   sqlloc
Status:   Closed
OS:   all
Original Version:   15.7 CGA Drop#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2011 Fixed
25 Apr 2011 Fixed
25 Apr 2011 Fixed
Description
sqllocres reports sort order "binary" is not valid for character set "utf8".



CR:667065
CR Number:   667065
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2011 Fixed
05 Oct 2011 Fixed
31 Oct 2011 Fixed
14 Oct 2011 Reservation Made
Description
Under some rare conditions, queries with computed columns could cause stack traces involving the module 'add__computedcol' when using the table with computed columns.



CR:667124
CR Number:   667124
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The current documented limit of 192 referential constraints is too low for the customers application and they would like this increasing.



CR:667341
CR Number:   667341
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The FR required to allow BCP (and other ASE utilities) write the outputs to remote locations.



CR:667487
CR Number:   667487
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2012 Fixed
Description
When "procedure cache size" configuration key value is increased, Procedure Cache Pool is not honoring the Engine Local Cache trace flags while allocating the extra pages to engine.



CR:667552
CR Number:   667552
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2011 Fixed
Description
sp_sysmon might report wrong engines when some engines are offline.



CR:667575
CR Number:   667575
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2011 Fixed
16 Jun 2011 Fixed
Description
Allow object owner to run sp_showoptstats besides SA role.



CR:667653
CR Number:   667653
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2011 Fixed
27 May 2011 Fixed
Description
A query with disjunctive clause on a range or list partitioned table can produce wrong results due to incorrect partition elimination.



CR:667691
CR Number:   667691
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2011 Presently Not Targeted For Any Future Release Of This Product
Description
An infected with 11 may occur with routines fastLoop and FrameNExecuteHelper on the stack while using JAVA.



CR:667726
CR Number:   667726
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2011 Fixed
Description
sp_helprotect truncates object and column names which are greater than 30.



CR:667751
CR Number:   667751
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2012 Fixed
03 Oct 2012 Fixed
16 Oct 2012 Fixed
Description
Support for UNIX Domain Sockets for ASE has been added for the Linux and Unix platforms.



Adaptive Server Enterprise version 15.7 ESD#4 and later now support the UNIX domain socket

communication, which avoids some of the overhead the TCP protocol incurs.

Similar to other protocols, include the AF_UNIX protocol in the interfaces file for clients to

connect to Adaptive Server. The syntax for an AF_UNIX in the interfaces file is:

master afunix unused //<hostname>/<pipe>



CR:667894
CR Number:   667894
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Loading a database dumped from a 12.5.4 server as an archive database on ASE 15.5 or later may result in error 11060. This currently cannot be circumvented due to the read-only nature of the archive database
Workaround Description
 Create a copy of sp_helptext where the table syscomments is prefixed with

the archive database name.



CR:667923
CR Number:   667923
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2011 Fixed
01 Jul 2011 Reservation Made
Description
A 290024 error, "Invalid column length: <number> Value must be between

<number> and <number> at offset <number>..." may be reported in the

errorlog when a session executed a trigger which contains a SELECT FOR XML

referencing INSERTED or DELETED virtual tables and previously the same

session had been executed a different trigger for a different table

but with the same SELECT FOR XML statement.
Workaround Description
 The client has removed their trigger as the only work-around.



CR:667943
CR Number:   667943
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2011 Fixed
01 Jun 2011 One-off Provided
14 Jul 2010 Presently Not Targeted For Any Future Release Of This Product
Description
In some cases, low throughput or poor performance may be observed during partially logged operations like BCP on indexed table or REORG REBUILD. sp_sysmon output shows high contention on dbt_seqspin spinlock.



CR:667977
CR Number:   667977
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2011 Fixed
Description
When a table in a VIEW is modified, multiple SELECT statements on the VIEW may return different results.
Workaround Description
 Establish a habit of always rebuilding views after altering tables they are based on.



CR:668088
CR Number:   668088
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Inaccurate memory allocation errors may be printed on startup.



CR:668337
CR Number:   668337
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances, raising the error 712, Severity: 17, State: 3 when restarted ASE and

increasing the loads. Requires to increase heap memory per user.



CR:668344
CR Number:   668344
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2011 Bundled Request
Description
parameter declaration in sp_sysmon is incorrect



CR:668380
CR Number:   668380
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2011 Fixed
08 Aug 2011 One-off Provided
Description
When free lock pool resource goes below critical threshold, server goes to slow response state due to heavy spinlock contention.



CR:668502
CR Number:   668502
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2011 Fixed
23 May 2011 Fixed
Description
For a DOL partitioned table which has TEXT/UNITEXT/IMAGE columns, after alter table dropping

a column, executing DBCC TEXTALLOC on the table which still have some TEXT/UNITEXT/IMAGE columns will report 15918 error.



CR:668560
CR Number:   668560
Product Name:   SCC Web Framework
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2011 Fixed
17 Jun 2011 Fixed
Description
Sybase Control Center to have option to configure the sender address in email alerts.
Workaround Description
 Write customer script an attach to alert.



CR:668576
CR Number:   668576
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Unsuccessful login attempts on ssl sockets generates ssl_close() SSLCLOSE() failed (-6989) errormessages. Would like the message suppressed.



CR:668617
CR Number:   668617
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
showplan reports Index name not found for temporary table
Workaround Description
 create procedure with recompile or execute procedure with recompile.



CR:668638
CR Number:   668638
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2013 Fixed
Description
The sp_opt_querystats stored procedure reports error number 17077 indicating that the optimizer diagnostic results were incomplete and does not generate any output.



CR:668787
CR Number:   668787
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2011 Duplicate
Description
'avoid_bmo_sorts on' uses "index scan" plan for a query that does a 'select into' a #temp table. if the "select into" is removed then "access by key" is used
Workaround Description
 ase_current + set avoid_bmo_sorts off









STEP 1

The type of query is CREATE TABLE.



STEP 2

The type of query is INSERT.



3 operator(s) under root



|ROOT:EMIT Operator (VA = 3)

|

| |INSERT Operator (VA = 2)

| | The update mode is direct.

| |

| | |SORT Operator (VA = 1)

| | | Using Worktable1 for internal storage.

| | |

| | | |SCAN Operator (VA = 0)

| | | | FROM TABLE

| | | | TBS_GL_RECON

| | | | R

| | | | Index : I_GR_ESCTP_RECONSTTS_ESCRSN

| | | | Forward Scan.

| | | | Positioning by key.

| | | | Keys are:

| | | | ESCALATION_TP ASC

| | | | RECON_STATUS_CD ASC

| | | | Using I/O Size 2 Kbytes for index leaf pages.

| | | | With LRU Buffer Replacement Strategy for index leaf pages.

| | | | Using I/O Size 2 Kbytes for data pages.

| | | | With LRU Buffer Replacement Strategy for data pages.

| |

| | TO TABLE

| | #temp

| | Using I/O Size 2 Kbytes for data pages.



CR:668790
CR Number:   668790
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2012 Fixed
Description
An audit process exception error message may occur that reports the incorrect numbers. The full error number is reported as the major number, the severity is reported as the minor number, the state is reported as the severity.



CR:668835
CR Number:   668835
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2011 Fixed
Description
Executing a query involving sending LOCATOR with NULL value through TDS_BLOB may hit 'Type 0 not implemented' error, i.e. error 1622.



CR:668846
CR Number:   668846
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2011 Fixed
20 Jun 2011 Fixed
12 Aug 2011 Fixed
Description
PIOs, LIOs, and CPU for nested loop join index scans are

not reported in the estimated cost diagnostics (statistics

plancost) for parallel optimized strategies.



CR:668909
CR Number:   668909
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2011 Fixed
22 Jul 2011 Fixed
Description
When creating a lightweight procedure, if all negative object IDs are used up, the 2012 error message is not reported.



CR:668967
CR Number:   668967
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2011 Workaround
Description
Sub optimal query plan allrows_oltp vs compatibility mode for sub query.
Workaround Description
 set compatibility_mode on

go

Or use traceflag 16928.



CR:669091
CR Number:   669091
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2011 Fixed
Description
In some cases, after loading a transaction dump which was taken after a fully-logged ALTER TABLE command was executed on an all pages-locked table that has multiple data pages, dbcc checktable on the table reports error 2583 because the number of data pages counted by dbcc is different from the count in the data oam page.



CR:669194
CR Number:   669194
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2013 Insufficient priority to fix
Description
A stored procedure, created with 'deferred compilation' enabled, that accesses cross database views and creates temporary tables may raise error 208 '<#temp_table> not found.' incorrectly.
Workaround Description
 Fully qualify cross database objects - eg: "from db1.usr1.view1".

Or

Turn off 'deferred compilation' when creating stored procedures that access cross database views.



CR:669301
CR Number:   669301
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2012 Fixed
30 Jan 2012 Reservation Made
Description
In rare circumstances, the message "Invalid column length: 12. Value must be between 0 and 10 for 'all-pages' row with minimum row length of 64" together with a stack trace which includes the modules 'collocate' and 'translate_varcols' may be reported on a 64 bits ASE on IBM AIX, when the datbase was loaded from a dump of a different platform.
Workaround Description
 From CR 435212:

Allow updates. Then:



update sysobjects

set versionts = convert(binary(10), versionts)



update syscolumns

set length=10

where id = 1 and name = 'versionts'



For versions prior to 15.0 (sysindexes is an APL table with clustered index)

update sysindexes

set maxlen =

(select maxlen from master..sysindexes

where id = 1 and indid = 1 )

where id = 1 and indid = 1



For versions 15.0 and higher (Sysindexes is a DOL table)



update sysindexes

set maxlen =

(select maxlen from master..sysindexes

where id = 1 and indid = 0 )

where id = 1 and indid = 0





Then disallow updates. That should fix up the aberrant database.



CR:669413
CR Number:   669413
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2011 Fixed
24 Aug 2011 One-off Provided
Description
Backup Server is enhanced to provide support for the MOUNTWAIT option for Tivoli Storage Manager. This option is off by default. It can be turned on by virtue of using the new 朚 option in the DUMP DATABASE or TRANSACTION to 搒yb_tsm::-M::<object_name> commands. Additionally in the LOAD DATABASE or TRANSACTION from 搒yb_tsm::-M::<object_name> commands.



CR:669429
CR Number:   669429
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2011 Bundled Request
Description
Infected with 11 in function testpasswd following an upgrade.
Workaround Description
 reset password with sp_password



CR:669434
CR Number:   669434
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
optimizer chooses bad join order with partitions on large dataset
Workaround Description
 use the abstract plan, unpartition the table, force the index, force the join order



CR:669447
CR Number:   669447
Product Name:   Adaptive Server Enterprise
Product Component:   sybinstall
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2012 Duplicate
Description
executing the installer in console mode stacktraces when using

relative pathname that includes '../'
Workaround Description
 Specify the complete path to the setup.bin. e.g.



<complete path>/setup.bin



CR:669482
CR Number:   669482
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2012 Insufficient priority to fix
Description
Query search fails on utf8 ASE 15.5 with like clause and cursor. Customer using Hibernate/Spring with jConnect so unable to modify internal JDBC Code to work around the problem.
Workaround Description
 WorkAround:

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

Use the wildcard and partial string (full string + wildcard will return 0 rows)

or

set jConnect property LITERAL_PARAMS=true - this sends the parameter as a literal in the search query:

select name from pool where name like 'backyard'

or

turn an compatibility option "enable compatibility mode"

or use "=" instead of "like"



CR:669573
CR Number:   669573
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
To support LVM for ASE CE



CR:669592
CR Number:   669592
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2011 Fixed
26 May 2011 Fixed
27 May 2011 Fixed
27 May 2011 Fixed
21 Jul 2011 Bundled Request
Description
When sp_extrapwdchecks is installed in the master database, adding or changing a login password to one containing single quotes fails with errors 102, 105 and 17720.
Workaround Description
 The work around it to not use sp_extrapwdchecks, or, not use quotes in passwords



CR:669730
CR Number:   669730
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2013 Fixed
Description
Logical errors when parsing complex abstract plans



CR:669736
CR Number:   669736
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jul 2011 Fixed
09 Aug 2011 Fixed
Description
Large text and data segments are not supported on HPIA64 platform.
Workaround Description
 chatr dataserver +pi 16M +pd L



CR:669847
CR Number:   669847
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2011 Fixed
08 Feb 2012 One-off Provided
11 Nov 2011 Reservation Made
15 Feb 2012 One-off Provided
21 Sep 2012 Fixed
04 Oct 2012 Fixed
Description
A 290024 error, "Invalid column length: <number> Value must be between <number> and <number> at offset <number>..." may be reported during a UPDATE plan execution when a complex VIEW or derived table (such as UNION or GROUPBY) is used in the FROM clause of the UPDATE statement.



CR:669925
CR Number:   669925
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Different behaviour when no login trigger present and login trigger not found



CR:669932
CR Number:   669932
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2011 Fixed
08 Jun 2011 Fixed
15 Jun 2011 Fixed
15 Jun 2011 Fixed
Description
With using Sybase Central ASE Plug-in, the Web Services SSL Configuration wizard fails with the error, "ERROR: Could not find java executable at null/bin/java. Please verify that a valid JRE installation exists."
Workaround Description
 Invoke the script $SYBASE/WS-15_0/bin/configssl from a shell with correct environment set.



CR:670074
CR Number:   670074
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2011 Fixed
01 Jun 2011 One-off Provided
04 Oct 2011 Fixed
05 Sep 2011 Fixed
Description
High spinlock contention on Resource->rdbts_spin and Dbtable->dbt_seqspin when running concurrent BCP IN jobs against a partitioned table.



CR:670150
CR Number:   670150
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 CGA Drop#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2011 Fixed
29 Jul 2011 Fixed
14 Jul 2011 Reservation Made
15 Jul 2011 Fixed
18 Jul 2011 Fixed
08 Aug 2011 Fixed
Description
Under certain circumstance, when 1204 error happens, SA/SA role can抰 login to adjust the number of locks



CR:670168
CR Number:   670168
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2014 Bundled Request
Description
The minimum recommended stack size is a little too small for many operations. The stack size configured on Solaris platforms should be larger than the minimum recommendation for ASE 15.x servers.
Workaround Description
 Do not use the mimimum stack size suggested by ASE.



CR:670169
CR Number:   670169
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2011 Fixed
23 May 2011 Fixed
31 May 2011 Fixed
Description
Sybase Central ASE Plug-in does not allow browsing 'User Tables' in a database when it contains a table that is marked 'for load'.
Workaround Description
 None known.



CR:670199
CR Number:   670199
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2011 Fixed
01 May 2013 Fixed
21 Jan 2014 Port Not Needed
Description
A signal 11 could be encountered with a stacktrace involving the function ResRelOp() called from CgpDistinctSorted::_cgpInit() when a DISTINCT VIEW with an expression DISTINCT SELECT column is queried with a constant equality predicate over the expression column and the final plan chooses DistinctSorted operator.
Workaround Description
 set distinct_sorted off

go



Also turning off merge_join might avoid the distinct_sorted for the repro.

But I can't guarantee it in general as optimizer might decide to choose

distinct_sorted for other reason.



CR:670223
CR Number:   670223
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Support rebuilding off-row LOB through REORG REBUILD, if compression level has changed.



CR:670273
CR Number:   670273
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2012 DEFER
04 Jan 2013 Fixed
Description
In some circumstances, the Operations value in the monOpenObjectActivity MDA table does not reflect the actual number of table accesses.



CR:670275
CR Number:   670275
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2012 Fixed
Description
ASE may allow four reader tasks to skip over a queued update task in lock sleep if the readers are trying to obtain a shared intent lock.



CR:670302
CR Number:   670302
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2011 Duplicate
Description
Adaptive Server on AIX-64 platform may cause illegal instruction errors and core dump when using a served license or an unserved sub-capacity license.



CR:670310
CR Number:   670310
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2011 Fixed
08 Jun 2011 Fixed
13 Jun 2011 Fixed
Description
The message "PCI(M1): pcidb_get_pci_directive_arg() : Unable to select the arguments for PCI

Bridge directive PCI_BRIDGE_X_OPT." followed by the message "current process infected with 11"

in the module 'pci__cfg_plb_options' together with a stack trace which includes the modules

'dsinit' and 'pci_cfgmgr_init' may be reported in the error log during ASE startup whose

logical page size is greater than 8K if ASE first reported an error during the recovery

of a user database and the configuration option 'enable pci' is active.



CR:670327
CR Number:   670327
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance dbcc checktable to capture invalid column length beforehand



CR:670337
CR Number:   670337
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
srvbuildres issue warning unable to verify raw device sizes



CR:670398
CR Number:   670398
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2011 Fixed
Description
ASE could hit timeslice error while zeroing out the device during the 'disk resize' command.



CR:670498
CR Number:   670498
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sqldbgr routines don't check for abnormal termination of procedures



CR:670506
CR Number:   670506
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2011 Duplicate
29 Jul 2011 Bundled Request
25 Jun 2012 Fixed
08 Oct 2014 Port Not Needed
Description
A server configured with certain specific character sets and case insensitive sort orders can report error 15417 when querying tables that contain encrypted columns.
Workaround Description
 Only a change of sort order seems to be able to prevent the reporting of an error.



CR:670530
CR Number:   670530
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2011 Fixed
13 Jun 2011 Reservation Made
Description
The Job History Output table has extra new line added after each row of the results obtained from the target server.



CR:670587
CR Number:   670587
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2011 Fixed
Description
614, 644, 2610 error etc may be returned due to the non-clustered index leaf page corruption

if max_rows_per_page is set to 1 for the non-clustered index on APL table.



CR:670854
CR Number:   670854
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2011 Third Party Problem
Description
The datediff() function may produce incorrect results when comparing a string literal or bigdatetime with a smalldatetime datatype.





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