Ô¶³Ì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:499407
|
|
499407 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
07 May 2008 |
Fixed |
|
|
|
11 May 2008 |
Duplicate |
|
|
|
|
|
increasing/decreasing size of default data cache only on 1 instance can corrupt master device. |
|
|
|
CR:499408
|
|
499408 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
12.5.4 ESD#7 |
|
|
|
|
|
|
|
|
|
12 Jun 2008 |
Fixed |
|
|
|
29 Jun 2008 |
Fixed |
|
|
|
29 Jun 2008 |
Reservation Made |
|
|
|
18 Aug 2008 |
Fixed |
|
|
|
|
|
When real time messaging is enabled on ASE to use MQ. The additional engine spawned to handle MQ tasks uses up very high cpu even when there is only 1 messaging operation. |
|
|
|
CR:499413
|
|
499413 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Linux |
|
15.0.2 ESD#2 |
|
|
|
|
|
|
Include available sort order options all the time when using sqlloc with X. |
|
|
|
CR:499448
|
|
499448 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
16 Oct 2008 |
Fixed |
|
|
|
08 Apr 2009 |
Fixed |
|
|
|
|
|
Procedural query with FOR READ ONLY option may incorrectly raise error 7304 "FOR READ ONLY can
not be used in a SELECT which is not part of the declaration of a cursor or which is not inside
a stored procedure" |
|
|
|
CR:499455
|
|
499455 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
HP-UX |
|
15.0.2 ESD#4 |
|
|
|
|
|
|
|
|
|
14 Oct 2013 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
Dynamic partition elimination may not be applied, when processing an ad-hoc sql query or stored procedure, with variable SARGs and range predicates, against a table that has a composite partition key. |
|
Workaround Description |
|
N/A |
|
|
|
CR:499485
|
|
499485 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
28 Aug 2008 |
Bundled Request |
|
|
|
|
|
On Windows platforms that have Virtual Adaptors the SySAM properties file can grow over time causing delays in startup. |
|
Target Version |
|
15.0.3 |
|
|
|
CR:499490
|
|
499490 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Compilation of an UPDATE query that contains a join and at least one IN-list or OR clauses
on the same column can choose deferred update mode, when direct update mode is possible.
As a result performance of the UPDATE query can be negatively impacted.
An example query is:
update t1 set c2 = 3 from t1, t2 where t1.c1 in (1,2,3,4,5,6,7,8,9) and t1.c2 = t2.d2
where table t1 is being updated and the query joins tables t1 and t2 and there is a IN-list
on column c1 of table t1. |
|
|
|
CR:499532
|
|
499532 |
|
Adaptive Server Generic Docs |
|
Troubleshooting:Error Messages |
|
|
Open |
|
all |
|
To Be Determined |
|
|
|
|
|
|
Enhance documentation of checkstorage faults. |
|
|
|
CR:499539
|
|
499539 |
|
Adaptive Server Enterprise |
|
optdiag |
|
|
Closed |
|
Solaris |
|
15.0.2 ESD#2 |
|
|
|
|
|
|
|
|
|
27 Jun 2008 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
|
|
Error 15072 may occur on DBCC CHECKCATALOG command after DELETE STATISTICS and optdiag statistics in. |
|
|
|
CR:499566
|
|
499566 |
|
Adaptive Server Enterprise |
|
Sybase Central ASE Plug-in |
|
|
|
|
|
|
|
|
|
|
15 Jun 2008 |
Fixed |
|
|
|
17 Jun 2008 |
Fixed |
|
|
|
17 Jun 2008 |
Fixed |
|
|
|
18 Jun 2008 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
17 Jun 2008 |
Fixed |
|
|
|
|
|
|
|
|
|
|
Remove Public/Private Network option in "Define Instance dialog" of CCW,AIW and Upgrade Server Wizard, only show a checkbox for Secondary Network option. |
|
|
|
CR:499569
|
|
499569 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
06 Oct 2008 |
Fixed |
|
|
|
14 Oct 2008 |
Fixed |
|
|
|
|
|
In a well partitioned cluster, fail over recovery may spend unneeded time flushing
modified pages to disk at the end of recovering a database that is only modified on
the surviving node. |
|
|
|
CR:499656
|
|
499656 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Different messages are printed on error of dropping a login through sp_droplogin when ldapua is enabled and disabled. |
|
|
|
CR:499659
|
|
499659 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Open |
|
Microsoft Windows |
|
15.0.2 ESD#2 |
|
|
|
|
|
|
select from a view on archive db hits error 3906 on windows 64bit |
|
|
|
CR:499694
|
|
499694 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
29 Apr 2008 |
Bundled Request |
|
|
|
|
|
When a database operation (create, alter, drop, quiesce, mount, etc) is in progress, issuing a
"quiesce hold" command may result in error 2244 "Unable to open database dbname".
Error 2244 may also be raised when issuing a "quiesce" command on a database that is already in a 'quiesce' state. |
|
|
|
CR:499704
|
|
499704 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Request to improve diagnostic error messages in the errorlog by including more context information such as procedure or trigger name, line number in code, etc. |
|
|
|
CR:499712
|
|
499712 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
all |
|
To Be Determined |
|
|
|
|
|
|
|
|
|
30 Sep 2008 |
Added to user documentation |
|
|
|
|
|
sp_audit doesn't allow "all" to be specified for login_name, raising an 18226 error. |
|
|
|
CR:499747
|
|
499747 |
|
Adaptive Server Enterprise |
|
Job Scheduler |
|
|
|
|
|
|
|
|
|
|
23 Jun 2008 |
Fixed |
|
|
|
26 Jul 2010 |
One-off Provided |
|
|
|
|
|
Jsagent opens the port on all IP addresses on machines that have multiple network interfaces. |
|
Workaround Description |
|
No workaround. |
|
|
|
CR:499810
|
|
499810 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
04 Aug 2008 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
|
|
lmlink hits signal 11 for getpage_noscan(). |
|
|
|
CR:499877
|
|
499877 |
|
Adaptive Server Generic Docs |
|
System Administration Guide |
|
|
|
|
|
|
|
|
|
|
09 Jul 2010 |
Added to user documentation |
|
|
|
|
|
Requesting an additional 15.0 document on the resetting of the size of tempdb. |
|
Workaround Description |
|
Ensure that tempdb fragment on master is at least 4mb.
alter database tempdb on master = 2
Then follow the steps in the 12.5.1 guide. |
|
|
|
CR:499894
|
|
499894 |
|
Adaptive Server Generic Docs |
|
Troubleshooting:Error Messages |
|
|
Open |
|
all |
|
To Be Determined |
|
|
|
|
|
|
Improve documentation on how to use traceflags in the RUN_SERVER file. Multiple -T parameters can be passed to the dataserver binary. It is good practice to document what each flag is being used for. |
|
|
|
CR:499895
|
|
499895 |
|
Adaptive Server Enterprise |
|
DBISQL |
|
|
Closed |
|
Microsoft Windows |
|
15.0.2 ESD#4 |
|
|
|
|
|
|
|
|
|
30 Jan 2009 |
Bundled Request |
|
|
|
|
|
DBISQL not processing results when multiple results includes warning messages |
|
|
|
CR:499935
|
|
499935 |
|
Adaptive Server Enterprise |
|
DBISQL |
|
|
Closed |
|
Microsoft Windows |
|
15.0.2 ESD#4 |
|
|
|
|
|
|
DBISQL 11 now sends multiple results to a single output file. |
|
|
|
CR:499949
|
|
499949 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
On the Solaris platform, a core dump is encountered when the qrmutil program is run with short style arguments, e.g. -Q instead of --quorum_dev |
|
|
|
CR:499961
|
|
499961 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Executing a SELECT statement with an AT ISOLATION 3 clause but without a FROM clause may lead to a stacktrace and termination of the users process. |
|
Workaround Description |
|
Run any query containing a FROM clause before running the failing query. |
|
|
|
CR:499982
|
|
499982 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
21 Jul 2009 |
Fixed |
|
|
|
29 Jul 2009 |
One-off Provided |
|
|
|
|
|
The message, "Current process infected with signal 11 (SIGSEGV)", may be reported in the errorlog together with a stacktrace which involves the modules '_StTcCharacterSample' and 'StTcMrgBnds' when executing a SELECT query with an IN list on encrypted columns. |
|
|
|
CR:500001
|
|
500001 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
char_length () function returns incorrect value on text column with XML data |
|
|
|
CR:500016
|
|
500016 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
In rare circumstances following failure of an instance, a surviving instance that is performing failover recovery might hang as a result of an undetected deadlock between the failover recovery process and another user process. |
|
|
|
CR:500071
|
|
500071 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
26 Jun 2008 |
Fixed |
|
|
|
27 Jun 2008 |
Fixed |
|
|
|
|
|
Post-Commit Optimization performs poorly for transactions with large number of DELETEs. |
|
|
|
CR:500116
|
|
500116 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
15.0.2 ESD#4 |
|
|
|
|
|
|
|
|
|
10 Jun 2008 |
Fixed |
|
|
|
27 May 2008 |
Reservation Made |
|
|
|
06 Jun 2008 |
Reservation Made |
|
|
|
|
|
A 332 error may be reported during a query that involves multiple nested VIEWs below a UNION VIEW. |
|
|
|
CR:500131
|
|
500131 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Index suspect status is not set after lower version of database is loaded across platform where byte-order (endian type) is different. |
|
Workaround Description |
|
Shutdown ASE (cluster) and restart after the first online after XPDL. |
|
|
|
CR:500190
|
|
500190 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
sp_configure 'number of open indexes', 20000000 expects to get message
5861 but hits 10886. |
|
|
|
CR:500198
|
|
500198 |
|
Adaptive Server Enterprise |
|
Job Scheduler |
|
|
|
|
|
|
|
|
|
|
22 Sep 2008 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
|
|
Job Scheduler batches may fain with "Unclosed quote before the character string" errors and references to jsd_GetResults() and jso_FlushBuffer() |
|
Workaround Description |
|
Playing around with the order in which commands are run can fix the problem. |
|
|
|
CR:500299
|
|
500299 |
|
Adaptive Server Enterprise |
|
Sybase Central ASE Plug-in |
|
|
|
|
|
|
|
Page size information was not presented in ASE Plug-in. Now, server page size information is displayed in the server's General tab of the Properties dialog. |
|
|
|
CR:500311
|
|
500311 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
15.0.2 ESD#6 |
|
|
|
|
|
|
A relocated join may get error 207 when joining on a column with upper case in the column name. |
|
Workaround Description |
|
The issue is caused by a bug with the dynamically creating the proxy table in tempdb. The issue
can be avoided by doing a "create existing table" or "create proxy_table" in the remote server
to pre-define the proxy table that maps back to the local server. This is
recommended anyways for frequent users of relocated joins since it avoids the overhead of creating
the proxy table when the query is executed. |
|
|
|
CR:500326
|
|
500326 |
|
Adaptive Server Enterprise |
|
backup server |
|
|
|
|
|
|
|
|
|
|
06 May 2008 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
After applying ASE 15.0.2 esd #4, the output from backupserver -v is esd #3. |
|
|
|
CR:500330
|
|
500330 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
19 Aug 2008 |
Fixed |
|
|
|
29 Aug 2008 |
Fixed |
|
|
|
|
|
sp_sysmon "app_only" stops reporting application detail after several hours |
|
|
|
CR:500347
|
|
500347 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Temporary files are not cleaned up after cluster creation. |
|
|
|
CR:500404
|
|
500404 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
In some cases, the workload manager might allow connections to migrate when they should not.
This might cause some issues later when the process resumes on the new node. |
|
|
|
CR:500463
|
|
500463 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
08 May 2008 |
Fixed |
|
|
|
11 May 2008 |
Duplicate |
|
|
|
|
|
Error 18177 might be raised by sp_cacheconfig if instance name is longer than 21 characters |
|
|
|
CR:500474
|
|
500474 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
In rare circumstances, Adaptive Server may give a time slice error with a stack trace which contains
modules 'cm__check_page_range' or 'cm_choose_buffer_pool'. |
|
|
|
CR:500546
|
|
500546 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Incorporated SQLTEXT printing for CREATE PROC, CREATE RULE, CREATE DEFAULT and CREATE TRIGGER statements when application tracing and show_sqltext options are turned on. |
|
|
|
CR:500730
|
|
500730 |
|
Adaptive Server Enterprise |
|
Sybase Central ASE Plug-in |
|
|
|
|
|
|
|
|
|
|
26 Jun 2008 |
Fixed |
|
|
|
26 Jun 2008 |
Fixed |
|
|
|
09 Jul 2008 |
Fixed |
|
|
|
28 Aug 2008 |
Fixed |
|
|
|
27 Aug 2008 |
Fixed |
|
|
|
29 Aug 2008 |
Fixed |
|
|
|
03 Sep 2008 |
Fixed |
|
|
|
|
|
1. In "Perference" page of "Adaptive Server Enterprise Plug-in Properties", there will be a switch for enable/disable check I/O fencing capability.
2. In "Specify Master Device page" of Create Cluster Wizard, there will be a dialog if specified devices do not have I/O fencing capability.
3. In "Specify the System Procedures Device" of Create Cluster Wizard, there will be a dialog if specified devices do not have I/O fencing capability.
4. In "Specify the System Database Device" of Create Cluster Wizard, there will be a dialog if specified devices do not have I/O fencing capability.
5. In "Specify Server Instances" of Create Cluster Wizard and Add Instance Wizard, there will be a dialog if more than one instance will be created on one host.
6. In "Specify Name and Path" page of Database Device Wizard, there will be a dialog to show if the specified device is I/O fencible.
7. In "General page" of Database Device Properties, there will be a label to show if the device is I/O fencible.
8. In "Device Information" of Add database wizard, there will be a dialog to show if the specified device is I/O fencible. |
|
|
|
CR:500736
|
|
500736 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
15.0.2 ESD#4 |
|
|
|
|
|
|
|
|
|
22 Aug 2008 |
Fixed |
|
|
|
21 Aug 2008 |
Reservation Made |
|
|
|
25 Aug 2008 |
Fixed |
|
|
|
|
|
Character data type table column in the SELECT list might return unexpected
trailing blanks when the column is involved in an equjoin with some character
data type expression. Also hash/merge join was not available between character data type
column equijoin under nocase sort orders. |
|
|
|
CR:500816
|
|
500816 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
A 2622 error "Insufficient room on this page to insert a row of length ..."
may be reported in the error log together with a stack trace which includes
the modules 'dol_putdrow', 'undo_dol_delete', 's_renormalize' and 's_recrtproc'
while concurrent sessions write a new query tree in sysprocedures whereas
the current session needs to rollback its current work from it. |
|
|
|
CR:500852
|
|
500852 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
24 Oct 2008 |
Fixed |
|
|
|
24 Oct 2008 |
Fixed |
|
|
|
|
|
A query with no reformatting and no sorting and only a
distinct_hashing or group_hashing operator may claim
too many buffers (typically the value of "max buffers per
lava op") as seen through the "set statistics plancost"
output. |
|
|
|
CR:500872
|
|
500872 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
15.0.2 ESD#2 |
|
|
|
|
|
|
|
|
|
27 Aug 2008 |
Fixed |
|
|
|
22 Jul 2008 |
Fixed |
|
|
|
|
|
After a database dump and load, ASE may not be able to access the SQL UDFs created before the dump. |
|
|
|
CR:500891
|
|
500891 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Open |
|
all |
|
To Be Determined |
|
|
|
|
|
|
Enhancement request to add information about fault severity and recommended actions to sp_dbcc_faultreport |
|
|
|
CR:523659
|
|
523659 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
09 May 2008 |
Fixed |
|
|
|
12 May 2008 |
Fixed |
|
|
|
|
|
Booting of second ASE Cluster Edition instance may hang, if the first instance is simultaneousy doing write-activity (such as create table or inserts) in master database. |
|
|
|
CR:523693
|
|
523693 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
27 May 2008 |
Fixed |
|
|
|
15 May 2008 |
Fixed |
|
|
|
|
|
Under rare circumtances , a deferred update of an APL table may result in a 2620 error: "The offset of the row number at offset <offset> does not match the entry in the offset table of the following page." |
|
|
|
CR:523704
|
|
523704 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
While doing DISK MIRROR/REMIRROR/UNMIRROR for an inactive disk, a stacktrace with SIGSEGV may be reported. |
|
|
|
CR:523730
|
|
523730 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
The message "timeslice -value, current process infected" may be reported
in the error log together with a stack trace which includes the modules
'clfr_recovernode' and 'clfr_recovery' during node failover recovery. |
|
|
|
CR:523736
|
|
523736 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
A new option "number of alloc units" added to pageinfo() built-in to return number of allocation units allocated to an object, given the first oam page for the object. |
|
|
|
CR:523759
|
|
523759 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Linux |
|
12.5.4 ESD#8 |
|
|
|
|
|
|
|
|
|
17 Sep 2008 |
Fixed |
|
|
|
17 Sep 2008 |
Reservation Made |
|
|
|
|
|
Adaptive Server doesn't support allocation of shared memory greater than 165 GB. |
|
|
|
CR:528381
|
|
528381 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
15.0.2 ESD#4 |
|
|
|
|
|
|
The following message is seen in the error log upon server startup: "kernel Warning: Cannot resolve LDAP function ldap_search_ext_s". |
|
|
|
CR:528407
|
|
528407 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
15 May 2008 |
Fixed |
|
|
|
21 Aug 2008 |
Fixed |
|
|
|
22 Aug 2008 |
Fixed |
|
|
|
|
|
In some circumstances, Adaptive Server may throw a message "current process infected with 11, in the module CgpUnion::_CgpInitProjection, together with a stacktrace which includes modules like CgpMergeUnionAll::cgpInit", when a UNION ALL query is being executed. |
|
|
|
CR:528442
|
|
528442 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
05 Jun 2008 |
Added to user documentation |
|
|
|
|
|
LST dbs must not use private devices which are only accessable by an instance. Existing documentation is not clear enough in indicating the requirements for the LST devices. Currently the acts of creating and deleting the LST require that the devices be accessible from other instances. |
|
|
|
CR:528447
|
|
528447 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
20 May 2008 |
Fixed |
|
|
|
16 May 2008 |
Fixed |
|
|
|
|
|
During failover recovery, undo phase may sometimes encounter 820 errors: "Attempt to dirty non-log buffer <addr> which is in I/O." |
|
|
|
CR:528451
|
|
528451 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
In a shared disk cluster system following an instance failure, a 3478 error, " During undo the page timestamp value is less than new timestamp from log...", may be reported when recovering a database that has mixed log and data and asynchronous prefetch is on. |
|
|
|
CR:528463
|
|
528463 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
16 May 2008 |
Fixed |
|
|
|
18 May 2008 |
Fixed |
|
|
|
|
|
692 error in DOL index scan restart could enountered in rare occasion. |
|
|
|
CR:528470
|
|
528470 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Feature Request: In 15.0.2 ESD#2, make sp_help output more consisitent for materialized and not materialized (virtual) computed columns. Remove the 'materialized' keyword from the syscomments.text field for a materialized computed column. |
|
|
|
CR:528474
|
|
528474 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
The cache creation/update operation using sp_cacheconfig succeeds but the server fails to reboot with new configuration |
|
|
|
CR:528551
|
|
528551 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Error 530 may be reported when using output from SQLJ function on outer column of a join. |
|
Workaround Description |
|
Wrap the SQLJ function in an isnull().
Use a UDF. |
|
|
|
CR:528604
|
|
528604 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
08 Jun 2008 |
Fixed |
|
|
|
17 Jul 2008 |
Fixed |
|
|
|
|
|
On the Solaris platform, ASE may encounter a timeslice error during boot if ISM (intimate shared memory) is in use and the amount of memory configured is approximately 100 Gb or more. |
|
|
|
CR:528752
|
|
528752 |
|
Adaptive Server Generic Docs |
|
Reference Manual:Building Blocks |
|
|
|
|
|
|
|
request to document sp_addmessage with 'replace' option can only be run by the same login who created the original messasge |
|
|
|
CR:528779
|
|
528779 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
03 Jun 2008 |
Fixed |
|
|
|
21 Oct 2008 |
Fixed |
|
|
|
|
|
DBCC CHECKSTORAGE records information in dbccdb that is not used in most cases.
This change reduces the number of inserts by skipping faults for which
an exclusion is defined with sp_dbcc_exclusions and skipping inserts in dbcc_counters.
The pre-fix behavior can be enabled using exec sp_dbcc_updateconfig null,
"enable excluded faults inserts", '1' and exec sp_dbcc_updateconfig null,
"enable dbcc_counter inserts", '1' |
|
|
|
CR:528830
|
|
528830 |
|
Adaptive Server Enterprise |
|
DBISQL |
|
|
|
|
|
|
|
|
|
|
29 Jul 2008 |
Bundled Request |
|
|
|
|
|
Previously DBISQL11's OUTPUT command did not work in command-line mode. This has been fixed. |
|
Workaround Description |
|
Redirect the output to a file:
dbisql.bat -host nstack-sun -port 5502 -c "UID=root;PWD=rooter" -nogui aut.sql > output.txt |
|
|
|
CR:528833
|
|
528833 |
|
Adaptive Server Enterprise |
|
DBISQL |
|
|
|
|
|
|
|
Previously DBISQL 9.0.2's PARAMETERS command did not work properly. This has been fixed in DBISQL 11.0. |
|
Workaround Description |
|
Redirect the output to a file:
dbisql.bat -host nstack-sun -port 5502 -c "UID=root;PWD=rooter" -nogui aut.sql > output.txt |
|
|
|
CR:528848
|
|
528848 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
For failed authentication, authentication mechanism is missing in login audit record. |
|
|
|
CR:528854
|
|
528854 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
18 Jun 2008 |
Fixed |
|
|
|
23 Jul 2008 |
Fixed |
|
|
|
|
|
Auditing of dropping and adding user messages prints the database user name information in the "objowner" column of the audit record. |
|
|
|
CR:528994
|
|
528994 |
|
Adaptive Server Enterprise |
|
DBISQL |
|
|
Closed |
|
Windows XP |
|
15.0.2 ESD#4 |
|
|
|
|
|
|
|
|
|
29 Jul 2008 |
Bundled Request |
|
|
|
|
|
Previously, DBISQL11 would report a synax error if you executed an INPUT, OUTPUT, or READ statement which was followed by "GO". This has been fixed. |
|
|
|
CR:528997
|
|
528997 |
|
Adaptive Server Enterprise |
|
DDLGen |
|
|
|
|
|
|
|
DDLGEN - Request to not return an error when extracting user ddl when only dbo user exists.
Currently it can return 'Critical internal application error' along with 'The specified User does not exist'
Sybase Adaptive Server Enterprise DDL Generator Utility/15.0.2/1/S/1.4.2/ase15x/Thu Dec 13 19:23:59 PST 2007 |
|
|
|
CR:529023
|
|
529023 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
11 Sep 2008 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
|
|
simultaneous dump db and create idx lead to 701 in 12.5.4 |
|
|
|
CR:529026
|
|
529026 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
During instance startup, a set of three messages is logged, if a secondary interconnect is not defined for the cluster. Messages are: "The cluster interconnect protocol has not been defined in the cluster input file", "Cannot resolve host name '' for the local interface of the link to monitor", and "Cannot resolve host name '' for the remote interface of the link to monitor". |
|
|
|
CR:529124
|
|
529124 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
15.1 ESD #2 |
|
|
|
|
|
|
Hit sig11 when dump new config file which is part of drop instance procedure. |
|
|
|
CR:529155
|
|
529155 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
In rare circumstances , "current process ... infected with 11" may be reported in the
error log together with a stack trace which includes the modules
'ptn__setup_field_access', 'wrongpage' and 'sort_read' while ASE was in
the process of reporting error 696 "An attempt was made to fetch logical page
... Page belongs to <value> and not to <value> ..." due to a sort operation
having failed. |
|
|
|
CR:529215
|
|
529215 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
22 May 2008 |
Fixed |
|
|
|
21 Jul 2008 |
Fixed |
|
|
|
|
|
The message "Invalid column length: <value>. Value must be between 0 and <value>
for 'data-only' row with minimum row length of <value>." may be reported in the
error log followed by a stack trace in module 'collocate' when the DBCC PAGE
command is run with the print option value of 4 on a datarows-only-locked table
that has variable length columns with a size value greater than 256. The modules
'prvarlen_cols' and 'prDOL_ROWS' will also be reported in the stack trace. |
|
|
|
CR:529246
|
|
529246 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Clients supportnig extended HA may receive a protocol error at login time if ASE is configured for LDAP directory services. |
|
|
|
CR:529256
|
|
529256 |
|
Adaptive Server Enterprise |
|
diagserver |
|
|
|
|
|
|
|
Checkstorage may fail on 64bit platforms, with an arithmetic overflow error 247 followed by error 12964 DBCC cannot insert the row in the dbcc_operation_log table for this check of database '%s', aborting check. |
|
|
|
CR:529327
|
|
529327 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
20 May 2008 |
Bundled Request |
|
|
|
|
|
In rare circumstances for clusters with two or more instances, it may be possible for a
named cache to be deleted at some instance with out releasing physical memory. |
|
|
|
CR:529398
|
|
529398 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Errors 913/225 on select of computed column that uses UDFs after load from database with different dbid |
|
|
|
CR:529400
|
|
529400 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
15.0.2 ESD#5 |
|
|
|
|
|
|
|
|
|
28 May 2008 |
Fixed |
|
|
|
29 May 2008 |
Reservation Made |
|
|
|
|
|
When an encrypted column uses a key that requires an explicit password and has declared a decrypt default, then a reference to that column in a WHERE clause that uses an OR operator may return Error 15469 to a user who lacks decrypt permission. |
|
|
|
CR:529481
|
|
529481 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
16 Jun 2008 |
Fixed |
|
|
|
17 Jun 2008 |
Fixed |
|
|
|
24 Jun 2008 |
Fixed |
|
|
|
|
|
Instance failover recovery may hang when it tries to write modified changes to disk after the recovery redo pass. |
|
|
|
CR:529508
|
|
529508 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
23 May 2008 |
Fixed |
|
|
|
22 May 2008 |
Fixed |
|
|
|
19 Jul 2010 |
Fixed |
|
|
|
22 Jul 2010 |
One-off Provided |
|
|
|
|
|
In rare circumstances following undo of an allocation, the database timestamp may be inadvertently set higher than it needs to be, increasing the likelihood of running out of timestamps for any database during its lifetime. |
|
|
|
CR:529566
|
|
529566 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
New feature: Create a password_random() built-in that generates a random password which satisfies the password complexity "minimum checks". |
|
|
|
CR:529627
|
|
529627 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Feature request for a stored procedure sp_rebuild which would be similar to sp_recompile but would force a rebuild of compiled objects from the source code in syscomments rather than just a recompilation of the query plan. |
|
Workaround Description |
|
Hi,
Boot the server with -T7706 and -T243
and:
create proc sp_redefine @name varchar(30)
as
select schema_inc(object_id(@name),2)
go
sp_redefine 'tablename'
go
will force the recreation from the text.
andrzej |
|
|
|
CR:529699
|
|
529699 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Linux |
|
15.0.2 ESD#4 |
|
|
|
|
|
|
|
|
|
25 Jun 2008 |
Fixed |
|
|
|
26 Jun 2008 |
Reservation Made |
|
|
|
13 Apr 2009 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
The message 2834 may be reported in the error log when an ALTER TABLE DROP PARTITION or
ALTER TABLE ADD PARTITION command is run while concurrent activity on the target table
takes place. |
|
|
|
CR:529749
|
|
529749 |
|
Adaptive Server Enterprise |
|
DDLGen |
|
|
|
|
|
|
|
DDLGen can get confused when it tries to drop indexes before re-creating them if there are multiple indexes with the same name on different tables. |
|
|
|
CR:529776
|
|
529776 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Error 107 may be raised for the first execution of a stored procedure that performs a delete when the procedure code is inconsistent in the use of qualified table names, i.e. using a mix of owner.name and name references. |
|
Workaround Description |
|
Be sure the table name in the where clause matches the table name after delete. See description for example. |
|
|
|
CR:529787
|
|
529787 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
15.0.2 ESD#5 |
|
|
|
|
|
|
|
|
|
22 May 2008 |
Fixed |
|
|
|
05 Jun 2008 |
Fixed |
|
|
|
|
|
Unexpected results could be returned under some
circumstances when executing a query using CASE
expressions involving inside comparisons to
NULL literal values and ANSINULL session option
is not active. |
|
|
|
CR:529788
|
|
529788 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Digital UNIX |
|
12.5.4 ESD#8 |
|
|
|
|
|
|
|
|
|
11 Aug 2009 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
|
|
Data corrupted when the view is not redefined after alter the table which uses user defined datatype. |
|
Workaround Description |
|
Ct needs to drop and recreate the view betaal_trans. This will prevent data corruption and the wrong select result. |
|
|
|
CR:529792
|
|
529792 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Adaptive Server might terminate the execution of a query containing GROUP BY ALL and a subquery in the WHERE clause. |
|
|
|
CR:529808
|
|
529808 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
configure certain databases as proxydbs in an HA environment.
Customer would like to be able to have some databases be local, and some proxy. |
|
|
|
CR:529840
|
|
529840 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Open |
|
Solaris |
|
12.5.4 ESD#7 |
|
|
|
|
|
|
FR requires some more restrictions for running "shutdown" command to avoid bring
a product server down by mistake. |
|
|
|
CR:529913
|
|
529913 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
For clusters with two or more instances, too many cache bind operations may lead to server hang
in module cipcmsg_alloc() due to lack of free messages to be sent over network. |
|
|
|
CR:530139
|
|
530139 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
Clients may get deadlock error occasionally while doing DML operations on same page from different instances in a cluster and in some case the deadlock may have been detected prematurely while waiting for the data to be transferred from another instance |
|
|
|
CR:530184
|
|
530184 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
For clusters with two or more instances, cache update operation or instance specific configuration
in the presence of global configuration with size less than 255 pages can lead to successful
operation instead of failing. |
|
|
|
CR:530186
|
|
530186 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
RIDjoin (for OR predicate) inner to outerjoin operator could sometimes lead to execution error message 623,624 or 806 related to retrieving a row via its RID. |
|
Workaround Description |
|
set index_union off
go |
|
|
|
CR:530220
|
|
530220 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
|
|
|
|
|
|
|
|
10 Jul 2008 |
Fixed |
|
|
|
14 Jul 2008 |
Fixed |
|
|
|
|
|
Kerberos logins with connection failover support fail to connect to ASE when HA is configured. |
|
|
|
CR:530267
|
|
530267 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
all |
|
To Be Determined |
|
|
|
|
|
|
|
|
|
18 Dec 2008 |
Fixed |
|
|
|
15 Feb 2009 |
Fixed |
|
|
|
|
|
Creating an index using the "with sorted_data" option on a partitioned table where the data is not actually sorted sometimes completes without error but creates a corrupt index with missing entries. |
|
|
|
CR:530268
|
|
530268 |
|
Adaptive Server Enterprise |
|
dataserver |
|
|
Closed |
|
Solaris |
|
15.0.2 ESD#2 |
|
|
|
|
|
|
When both Primary and Secondary LDAP server have a failed status, rebooting ASE should reset their Active/Status to ‘True’,’Ready’ rather than leave both as ‘False’,’Failed’. |
|
Workaround Description |
|
The client has to manually update the status of the LDAP servers to re-enalble LDAP connections at login. |
|
|
|
--------------------------------------»ªÀöµÄ·Ö¸îÏß-------------------------------------------------------------------------
֮ǰ¾ÍÒѾÑз¢³É¹¦ÁËÄܹ»´Ó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)ÉÏÌáÈ¡Êý¾ÝµÄ·Ç³£¹æ»Ö¸´¹¤¾ß
- ÊÊÓÃÓÚËùÓеÄSQL Anywhere°æ±¾ °üÀ¨£º5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
- ÊÊÓÃÓÚËùÓеÄUltraLite°æ±¾
- Äܹ»»Ö¸´³öÀ´±í½á¹¹ºÍÊý¾Ý
- Äܹ»»Ö¸´×Ô¶¨ÒåÊý¾ÝÀàÐÍ
- Äܹ»»Ö¸´´æ´¢¹ý³ÌµÈ¶ÔÏóµÄÓï·¨
- Äܹ»µ¼³öµ½Ä¿±êÊý¾Ý¿â
- Äܹ»µ¼³öµ½SQLÎļþ²¢Éú³Éµ¼Èë½Å±¾
- Ö§³Ö¶àÖÖ×Ö·û¼¯ °üÀ¨£ºcp850¡¢cp936¡¢gb18030¡¢utf8µÈ
- Äܹ»»Ö¸´Î´¼ÓÃÜ»òÕß¼òµ¥¼ÓÃÜÀàÐ͵ÄÊý¾Ý
- ¼òµ¥Ò×ÓÃ
- ÏÞÖÆ£º²»Ö§³ÖAES¼ÓÃܵÄÊý¾ÝÎļþ
Çë²Î¿¼£º
Ñз¢³É¹¦ÁË´ÓSybase SQL AnywhereµÄDBÎļþÉϻָ´Êý¾ÝµÄ¹¤¾ß
SQL AnywhereÊý¾Ý¿â·Ç³£¹æ»Ö¸´¹¤¾ßReadASADBʹÓýéÉÜ
ReadASADBÊÊÓó¡¾°
¸÷ÖÖÎó²Ù×÷£º
- Îó½Ø¶Ï±í(truncate table)
- Îóɾ³ý±í(drop table)
- ´íÎóµÄwhereÌõ¼þÎóɾÊý¾Ý
- Îóɾ³ýdb»òlogÎļþ
- Îóɾ³ý±íÖеÄ×Ö¶Î
±¾¹¤¾ßµÄÓ¦Óó¡¾°£º
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µÈµÈ¡£
+-------------------------------------»ªÀöµÄ·Ö¸îÏß-------------------------------------------------------------------------