远程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:732406
CR Number:   732406
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2013 Fixed
27 Feb 2013 Fixed
Description
sybmigrate does not preserve indexes in the indexid order.



CR:732410
CR Number:   732410
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)
10 Oct 2013 Presently Not Targeted For Any Future Release Of This Product
23 Jul 2013 Fixed
Description
In rare cases, dataserver can hang due to this deadlock situation: one session sleeps on grabbing DES while updating statistic in rollback a DELETE; the other session sleeps on writing dirty buffers when scavenging a DES.



CR:732482
CR Number:   732482
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2013 Fixed
25 Sep 2013 Fixed
Description
A query against a remote table may get a signal 11 during UPDATE STATISTICS.
Workaround Description
 If the remote server is also an ASE server, then a possible workaround may be to use trace flag 11229, which will suppress importing statistics from the remote server during update statistics, and instead will read all the rows from the remote server to generate up-to-date statistics (but this could be a much slower process).



CR:732503
CR Number:   732503
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2014 Fixed
12 Nov 2014 Fixed
03 Dec 2014 Fixed
10 Dec 2014 Fixed
Description
The message "current process infected with 11 (SIGSEGV)" in the module 'des__clean' together with a stack trace which includes the modules 'des_refreshall' and 'online_database' may be reported in the SAP ASE error log when multiple sessions are executing the ONLINE DATABASE command simultaneously for the same database. This will result in SAP ASE shutting down implicitly.
Workaround Description
 single session to online a specific database, avoid concurrent online the same database.



CR:732560
CR Number:   732560
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE attempts to checkout a license after it is already checked-out.



CR:732588
CR Number:   732588
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 02 Apr 2013 Fixed
08 Apr 2013 Fixed
Description
Under certain circumstances when a threshold action is defined, and user is dropping a procedure, and the procedure happens to be the last row of the sysprocedures page, an 873 error may be reported when log space is low, and the threshold proc gets spawned.
Workaround Description
 Do not use user-defined optimization goals.



CR:732604
CR Number:   732604
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2013 Fixed
15.7 SP50 12 Jun 2013 Fixed
Description
The summary stats for histogram (i.e. unique count, density) generated by hash based statistics gathering may be inaccurate. This could occur when OPTDIAG labels a histogram as "high domain".



CR:732613
CR Number:   732613
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Linux
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2014 Fixed
17 Jan 2014 Fixed
21 Jan 2014 Fixed
Description
The Job Scheduler fails to start if quoted_identifier property is set for the connection (which is used to start the Job Scheduler). The following error is logged in the SAP ASE errorlog: "Job Scheduler: IS_ISQL_EXT failed [set nocount on use sybmgmtdb print ":s: %1!", "sybmgmtdb"]"
Workaround Description
 set quoted_identifier off

go

sp_sjobcontrol @name=NULL, @option='start_js'

go



CR:732631
CR Number:   732631
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)
15.7 SP60 19 Aug 2013 Fixed
15.7 SP121 20 Aug 2013 Fixed
28 Nov 2013 Fixed
Description
REORG REBUILD <table_name> WITH ONLINE command, does not update the index create time-stamp(index_created field in sp_helpindex output) for the indexes rebuilt.



CR:732640
CR Number:   732640
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2013 Fixed
Description
Schema lock displayed as GUID lock in sp_lock output



CR:732693
CR Number:   732693
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2013 Fixed
23 Jan 2014 Fixed
Description
ALTER TABLE <TABLENAME> SPLIT PARTITION may fail with errors such as 2601 (Attempt to insert duplicate key row in object <name> with unique index <name>) when there is a non-clustered index.



CR:732723
CR Number:   732723
Product Name:   Adaptive Server Generic Docs
Product Component:   Utility Guide
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Added to user documentation
Description
typos and fix problems for fast bcp section of utility guide



CR:732728
CR Number:   732728
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2013 Fixed
20 Mar 2013 Fixed
Description
The unreserved space stored in the table sysusages can become a huge number bigger than the fragment itself if the number of allocated pages indicated in the OAM pages for some objects becomes corrupted and show pages allocated that are not.



CR:732777
CR Number:   732777
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2013 Fixed
25 Feb 2013 Fixed
Description
Under some circumstances, a 4720 error "Cannot truncate table '%.*s' because there are one or more isolation level 0 scans, or REORG command, active on the table." may be reported while a temporray is being dropped. Such temporary table is found to have a dlevel0cnt = 12.



CR:732841
CR Number:   732841
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepAgent won't connect to RepServer when 'cis connect timeout' > 2147.



CR:732911
CR Number:   732911
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2013 Duplicate
Description
If a table has constraint check and its name is quoted identifier, when migrate the table, sybmigrate failed in the error like that: SqlState: 42000 java.sql.SQLException: Incorrect syntax near



CR:732921
CR Number:   732921
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2013 Fixed
Description
A 8201 error, "Keep count of descriptor (objid=14, dbid=<value>) was expected to be 1. Instead 0 was found" followed by a stack trace that includes the module 'des__unkeep' may be raised if ASE fails to allocate space for either SYSGAMS or SYSDAMS.



CR:732977
CR Number:   732977
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: create a parameter that will make getutcdate() only be evaluated once per statement as getdate() is by default.
Workaround Description
 use the case statement



CR:732995
CR Number:   732995
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2013 Fixed
13 Mar 2013 One-off Provided
14 Mar 2013 Fixed
Description
Sometimes Procedure Cache ELC (Engine Local Cache) for some of the engines does not get configured during engine boot, which leads to Procedure cache ELC not getting used on the engine and thus leads to contention on the rproccache_spin spinlock. This condition can be detected using the ASE errorlog. If an engine is brought online but does not have the message "Proc header memory allocated <nn> pages for engine <engine_id> local cache" for that engine then the Procedure Cache ELC is not properly configured for that engine.



CR:733006
CR Number:   733006
Product Name:   ASE Management
Product Component:   sybrestore
Status:   Closed
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2013 Fixed
Description
This problem may show up when the database has first bit set ON in the status (meaning upgrade started on this database) and the database devices, that are inactivated in a database, may not get 'init' by Sybrestore.



CR:733051
CR Number:   733051
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2013 Fixed
06 Mar 2013 Fixed
Description
If the number of system roles of target server is more than source server's, after running symigrate -m migrate, sybmigrate will drop from sysusers those roles that are 'new' in the target server.

This issue can specially be seen when users are migrating from ASE 12.5.4 to ASE 15.7.x



CR:733146
CR Number:   733146
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2013 Fixed
19 Mar 2013 Fixed
Description
In rare cases, the message "Invalid column length" may be reported in the ASE errorlog to indicate there are issues in the index creation when creating an index on a Page Compressed table.
Workaround Description
 +) For DOL table, Pls turn on TF 549 to disable lava pll create index

+) For APL table, Pls remove the 'with consumers" clause to use serial sort

+) No workaround if you create a clustered index on APL table.

+) Pls add 'with consumers" and turn on TF549 to use old pll create index if you create a placement index on DOL table.



CR:733194
CR Number:   733194
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2013 Fixed
01 Apr 2014 Fixed
Description
Incorrect disk activity may be reported by sp_sysmon_diskio when there is no disk I/O in given sample period on this device.
Workaround Description
 re-initialize the SUM() conditionals to 0 if it returns null by using function isnull(SUM(value), 0)



CR:733215
CR Number:   733215
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2013 Fixed
Description
After upgrading, the value of systabstats.rowcnt for the syspartitions and sysobjects tables

will be 1 less than the actual number of rows in these two system tables.



CR:733226
CR Number:   733226
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 20 May 2013 Fixed
11 Apr 2013 Fixed
15.7 SP110 21 May 2013 Fixed
Description
If a parallel plan's thread count exceeds the session's parallel degree, then the plan will undergo Compile time Thread Adjustment (CTA). If the plan contains a semantic scan under a semantic dependent operator (JOIN, DISTINCT, GROUP, or UNION_DISTINCT), then the semantic dependent operator's plan fragment (from its containing xchg op) may have it's degree adjusted

incorrectly which could result in wrong results.
Workaround Description
 There are a few workarounds:



1. Remove the subquery since there exists an equivalent JOIN CLAUSE in the query.



For test query in house:

select count(*)

from

#tab1 t1,

#tab2 t2,

pbugs3_tab p (index pbugs3_tab_ci)

where p.creation_ts=t1.creation_ts

and p.sy_product_family=t1.sy_product_family

and p.sy_product_family=t2.sy_product_family

---

--- and p.sy_product_family in (select sy_product_family from #tab2)

-- the subquery above is equivalent to p.sy_product_family=t2.sy_product_family

---

and t1.bug_id between p.bug_id and p.bugid2



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



For customer's original query:



SELECT count(*)

from #EntGMT1_aam3 E ,

Scenarios_vector V (index PK_Scenarios_2), <-- range partitioned table

#RsPRsk1_aam3 RF

WHERE E.COBDate = V.COBDate <-- V.COBDate is range partition column

AND V.ID_ENTITY = E.ID_CHILD

AND RF.ID_RISK_FACTOR = V.ID_RISK_FACTOR

--- AND V.ID_RISK_FACTOR IN (SELECT ID_RISK_FACTOR FROM #RsPRsk1_aam3) -- may be removed

AND RF.IsVaR = 1

AND E.ts_begin BETWEEN V.ts_begin AND V.ts_end

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



The subquery is equivalent to join clause:

RF.ID_RISK_FACTOR = V.ID_RISK_FACTOR

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



2. Use serial plan via 'set parallel_query off'



CR:733305
CR Number:   733305
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 07 Apr 2013 Fixed
24 Mar 2013 Fixed
07 Apr 2013 Fixed
02 May 2013 One-off Provided
23 May 2013 One-off Provided
Description
An ASE spid with remote I/O may hang when killed. Even reissuing the kill does not help.



CR:733331
CR Number:   733331
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Fixed
19 Jan 2015 Fixed
16 Nov 2014 Fixed
18 Dec 2014 Fixed
Description
Error message 1509 may be raised when CREATE INDEX or UPDATE STATISTIC is executed in parallel on huge table where there are very few distinct COLUMNS values.
Workaround Description
 Configure bigger value for "number of sort buffer" can avoid this issue to occur.



CR:733346
CR Number:   733346
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2013 Fixed
15.7 SP60 19 Jul 2013 Fixed
Description
The stored procedure sp_dropexternlogin will fail when executed by a user that has SSO_ROLE and not SA_ROLE when granular permissions is not enabled.



CR:733367
CR Number:   733367
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2013 Fixed
15.7 SP121 15 Aug 2013 Fixed
15 Aug 2013 Fixed
15.7 SP110 20 Aug 2013 Fixed
15.7 SP121 20 Aug 2013 Fixed
Description
Provide downgrade support from 15.7 SP110 to SP100 to prevent loading database or transaction dumps containing transactional activity from INSERT-BULK with parallel index updates work load. Extend db_attr(), and loginfo() built-ins to examine database feature-set. Extend LOAD ... WITH HEADERONLY to report the features found in the dumps.



CR:733428
CR Number:   733428
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2013 Fixed
15.7 SP121 24 Oct 2013 Fixed
09 Aug 2013 Reservation Made
13 Sep 2013 Fixed
15.7 SP60 14 Oct 2013 Fixed
01 Dec 2013 Fixed
Description
The "recovery prefetch size" configuration parameter is added to configure the lookahead size (in terms of log pages) in order for recovery to prefetch to-be-recovered pages. When set to 0, SAP ASE will automatically optimize the value.



CR:733446
CR Number:   733446
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2013 Fixed
Description
In DDLGen 15.7 ESD#3 and later, 'set quoted_identifier on' is reported in the DDL output even when it is not specified in the actual create table SQL.



CR:733462
CR Number:   733462
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 02 Apr 2013 Fixed
13 Mar 2013 Fixed
Description
A timeslice error may occur followed by a stack trace involving the module itl_au_update_xfer_mark() with executing BCP-IN or update DMLs, if 'transfer table' is set on a large table with data more than 47GB on 2KB page size (95GB on 4KB pagesize, 190GB on 8KB pagesize, 380GB on 16KB pagesize).
Workaround Description
 Possible workaround is to turn off transfer table on the table being bcp'ed into.



CR:733573
CR Number:   733573
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2013 Bundled Request
30 Aug 2013 Added to user documentation
Description
Use "SET ISQL" command to set the option. Maximum number of rows can be set through command "SET ISQL _maximum_displayed_rows '<value>'". Note the previous command only makes the new value applicable to the session. To make the option permanent, use command "SET ISQL PERMANENT _maximum_displayed_rows '<value>'". Note the optional keyword "PERMANENT" or "TEMPORARY" after "ISQL" is new in DBISQL16/ASE.



CR:733579
CR Number:   733579
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2014 Fixed
01 Apr 2014 Fixed
03 Apr 2014 Fixed
Description
The unreserved page count might be off by the number of pages of the table SYSDAMS if SAP ASE uses the OAM pages to calculate the free space counts. The database fragments containing pages of the system table SYSDAMS will show the space used by this table as free.



CR:733604
CR Number:   733604
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2013 Fixed
22 Apr 2013 Fixed
Description
Add the ability to suppress warning message regarding the ignoring of hints under the presence of abstract plans. This is enabled under Trace Flag 15381.



CR:733623
CR Number:   733623
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 03 Apr 2013 Fixed
20 Mar 2013 Fixed
27 Mar 2013 Fixed
Description
ASE allows configuration parameter 'max online engines' to be set to a value lower than 'number of engines at startup' leading to an incorrect value for the parameter 'max online Q engines'. This can result in incorrect calculations for the 'maximum number of engines' resulting in ASE hitting a SIGSEGV followed by a stack trace involving the module ueisonline().
Workaround Description
 Ensure 'max online engines' is higher than 'number of engines at startup' + 'max online Q engines'.



CR:733750
CR Number:   733750
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2013 Fixed
15.7 SP50 12 Jun 2013 Fixed
Description
Timeslices may occur with statistics gathering using hashing.



CR:733752
CR Number:   733752
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2013 Fixed
15.7 SP60 28 Jun 2013 Fixed
Description
The estimate for NULLs in the optimizer may be incorrect if hash based statistics gathering is used, when the number of unique values in the column is greater than 65535.



CR:733766
CR Number:   733766
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2013 Fixed
Description
The severity of error message 5805 and 5806 is now changed from EX_USER to EX_INFO since they are just warnings.



CR:733776
CR Number:   733776
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2013 Fixed
15 Apr 2013 Fixed
06 Jun 2013 Not a Bug
02 Jun 2013 Not a Bug
02 Jun 2013 Not a Bug
02 Jun 2013 Not a Bug
Description
After an upgrade, execution of a procedure may fail with error 102 "incorrect syntax near [ endend | grantgrant ]" and error 11031 due to the source code being stored incorrectly in syscomments when it contains multiple GRANT statements. Manually correct the source code, then drop and re-create the procedure.



CR:733838
CR Number:   733838
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2013 Fixed
Description
ASE no longer rejects requests to add remote logins with same server name as local server.



CR:733893
CR Number:   733893
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2013 Fixed
Description
Device Props does not display databases that are using a device on little-endian machines. On big-endian machines, unintended databases may get displayed.



CR:733904
CR Number:   733904
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2013 One-off Provided
15.7 SP50 10 Apr 2013 Fixed
10 Apr 2013 Fixed
30 May 2013 One-off Provided
Description
Active roles being reset leading to permission errors.



CR:733907
CR Number:   733907
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 Mar 2013 Fixed
20 Mar 2013 Fixed
Description
The error 822 "Could not start I/O for request.." followed by a stack trace that includes the module altdb_shrinklog() could be raised in a Cluster Edition server if a fragment of the database log is shurnk using the command ALTER DATABASE LOG OFF and the device where this fragment was is dropped.



CR:733932
CR Number:   733932
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2013 Fixed
15.7 SP50 17 Jun 2013 Fixed
15.7 SP110 18 Jun 2013 Fixed
25 Jun 2013 One-off Provided
Description
When a user with sso_role runs a query accessing a table, a 2736 error, "Owner name that was specified is a group name. Objects cannot be owned by groups" may occur followed by a 706 error, "Process <n> tried to remove PROC_HDR <addr> that it does not hold in Pss", during recompiling a light-weight procedure if statement cache is enabled. The processed will be terminated.
Workaround Description
 turn off statement cache or

add the login that is failing with 2736/706 errors as a legitimate user of the current database



CR:733937
CR Number:   733937
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2013 Fixed
15.7 SP50 12 Jun 2013 Fixed
Description
When using hash based statistics gathering on columns with more than 65535 unique values there is a possibility of inaccurate summary statistics of the range density and range unique counts as displayed in optdiag. This may lead to suboptimal query plan selection.



CR:734031
CR Number:   734031
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2013 Fixed
Description
Add open client version to monProcess under column ClientVersion



CR:734125
CR Number:   734125
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2013 Fixed
Description
The 695 error, "An attempt was made to read logical page '<n>' for database '<dbname>'..." could be raised in an archive database when the database dump contains more than 256 contiguous log pages.



CR:734176
CR Number:   734176
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 09 Jul 2013 Fixed
15.7 SP110 19 Jul 2013 Fixed
Description
If DBCC DBREBOOT is unsuccessful for some reason, the status in sysdatabases may sometimes incorrectly indicate that a forced shutdown is in progress, even after SAP ASE has been shutdown and rebooted successfully.
Workaround Description
 Bit can be cleared with an update followed by an immediate shutdown with nowait

update sysdatabases set status3=(select status3 from sysdatabases where dbid=1) where name='dbname'

go

shutdown with nowait

go



CR:734184
CR Number:   734184
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2013 One-off Provided
15.7 SP110 24 May 2013 Fixed
15.7 SP50 23 May 2013 Fixed
15.7 SP101 24 May 2013 Fixed
04 Jun 2013 One-off Provided
Description
In rare occasions, Adaptive Server's internal timer becomes non-operational. Such occurrence is reported to the errorlog with messages like 揥arning: Alarm Service for Timer non-operational. If this message generated multiple times, report to support and restart the server (alarminterval=-7001)



CR:734204
CR Number:   734204
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 Nov 2013 Fixed
14 Nov 2013 Reservation Made
21 Nov 2013 Fixed
13 Dec 2013 Fixed
13 Dec 2013 Reservation Made
Description
When the configuration parameter 'max network peek depth' is configured to a positive value, ASE will look for an attention up to the specified depth in the pending input on a connection, and if one is found, all input preceding the attention packet as well as the attention packet itself are discarded, the currently executing command is canceled and an attention acknowledgement is sent to the client. When running with the default value 0 of the configuration parameter, ASE looks for an attention only at the start of pending input.



CR:734211
CR Number:   734211
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2013 Fixed
15.7 SP50 16 May 2013 Fixed
Description
DDLGen can generate an incorrect header message while generating ddl for a load profile. Instead of saying 'DDL for LoadProfile', it can say 'DDL for :user'.



CR:734212
CR Number:   734212
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 08 Apr 2013 Fixed
09 Apr 2013 Fixed
05 Jun 2013 One-off Provided
Description
ASE hits SIGNAL 11 (SIGSEGV) when it runs out of spinlocks under heavy CT-Lib calls if 'max cis remote connections' configuration value is DEFAULT (which is 0). Setting 'max cis remote connections' to appropriate value is suggested to avoid reserving high number of spinlocks (upto four times 'number of user connections').



CR:734214
CR Number:   734214
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2013 Fixed
07 Mar 2013 Fixed
07 Mar 2013 Reservation Made
20 Mar 2013 Fixed
11 Mar 2013 Reservation Made
Description
Command line trace flag 16964 is added to turn off the row constructor optimization for range predicates. This optimization may cause an underestimate of the limiting selectivity of an index scan when a range predicate exists on an indexed column followed by limiting predicates on subsequent columns. For example, if an index I(a,b,c) has predicates a>5 and b=10 and c>20 then the range predicate on 揳 is followed by minor attributes 揵 and 揷 which also have limiting predicates... then the scan selectivity on the index "I" may be underestimated.



CR:734218
CR Number:   734218
Product Name:   Sybase SQL Server
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
plan removed from procedure cache for trigger when you have an raise error in triggers.



CR:734253
CR Number:   734253
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2013 Added to user documentation
Description
After moving the transaction log to another device and data and log devices are separated, the database may still keep "mixed log and data" status. dbcc findstranded(database_name) can be executed to correct the status if needed.



CR:734394
CR Number:   734394
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2013 Fixed
Description
When ASE Server is not in single user mode during sp_downgrade 'prepare', report a warning message to indicate it instead of stopping the validation.



CR:734395
CR Number:   734395
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2013 Fixed
12 Mar 2013 Presently Not Targeted For Any Future Release Of This Product
Description
When dropping an encryption key, the 15401 message is reported with malformed values in the message.



CR:734464
CR Number:   734464
Product Name:   Adaptive Server Enterprise
Product Component:   coverletter
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2013 Added to user documentation
15 May 2013 Added to user documentation
26 Jun 2013 Added to user documentation
19 Jul 2013 Not a Bug
26 Jun 2013 Added to user documentation
26 Jun 2013 Added to user documentation
09 Jul 2013 Added to user documentation
04 Jul 2013 Added to user documentation
04 Jul 2013 Added to user documentation
18 Jul 2013 DEFER
Description
Cover letter CR for ASE 15.7 SP50. Was ESD#5 and previously ESD#4.2



CR:734470
CR Number:   734470
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 08 Aug 2013 Fixed
15.7 SP121 04 Nov 2013 Fixed
07 Aug 2013 Bundled Request
08 Nov 2013 Fixed
Description
When SAP ASE is booted with trace flag 7437 it will not switch from an OAM scan to an allocation page scan when an incorrect page count value in one or more OAM entries is found during boot time recovery and while calculating the free space page counts for a database.



CR:734475
CR Number:   734475
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 22 May 2013 Fixed
19 Jul 2013 One-off Provided
15.7 SP50 16 Jun 2013 Fixed
12 Feb 2014 Port Not Needed
23 Jul 2014 Fixed
Description
The LogicalReads value in the monProcessActivity and monProcessStatement MDA tables remained unchanged when a long query is executing.



CR:734485
CR Number:   734485
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
segv in rvm_fetch_attr() when using a cached plan during validation of view and objects used s_mustrecompile() and possibly prot_validate() in calling path.



CR:734500
CR Number:   734500
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2013 Fixed
15.7 SP50 10 Apr 2013 Fixed
10 Apr 2013 Fixed
Description
The index page scanning selectivity estimate may be too optimistic for an index, in which a prefix of 0 or more positioning equality predicates (such as r.a = 1 and r.b = 2) is followed by a positioning range predicate such as (r.c > 5) is following by subsequent trailing positioning predicates (such as r.d = 10 and r.e >= 20). The change enabled by the new optcriteria limit_row_constructor will limit the index page scan reduction by at most 50% (in our example it will limit reductions contributed by r.d, r.e).
Workaround Description
 use abstract plan



CR:734605
CR Number:   734605
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need a description and formula for multiple dependent SARGs selectivity estimation on 15.7.x



CR:734617
CR Number:   734617
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 06 Aug 2013 Fixed
15.7 SP110 07 Aug 2013 Fixed
Description
Adaptive Server 15.7 may execute SELECT queries at isolation level 3 on Data Only Locked scheme tables slower than SAP ASE 15.0.3 or 15.5 if the session executing the SELECT query holds a large number of locks.



CR:734660
CR Number:   734660
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2013 Fixed
20 Mar 2013 Fixed
26 Mar 2013 One-off Provided
01 May 2013 Fixed
Description
The error "Page Verification Error: Page mismatch. Page <page #> contains 0 in page header." could be incorrectly printed in the Backup Server errorlog when executing DUMP DATABASE WITH VERIFY. This error is spurious and can be ignored.



CR:734674
CR Number:   734674
Product Name:   ASE Management
Product Component:   Monitoring Agent Plugin
Status:   Open
OS:   Generic
Original Version:   3.2.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Filter SQL in SQL Activity Window (SCC)



CR:734702
CR Number:   734702
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2013 Fixed
20 Mar 2013 Fixed
Description
For objects with no storage, error 691 may be reported while running a CREATE INDEX command if either a dump is in progress or an incremental dump is in progress.



CR:734705
CR Number:   734705
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2013 Fixed
20 Mar 2013 Bundled Request
Description
After running sp_reptostandby/sp_setreptable/sp_setrepcol with "use_index"

option on compressed in-row LOB columns, dbcc checktable() may report various

kinds of index errors.



CR:734716
CR Number:   734716
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2013 Fixed
20 Mar 2013 Fixed
Description
At times the systabstats empty page count column may get values near to 2^32 (~4294967295) if inserts into a table are rolled back.



CR:734750
CR Number:   734750
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   AIX 5.1
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 06 Jun 2013 Fixed
Description
srvbuildres optimization fails when specifying '16K' as the logical page size in the resource file for the Adaptive Server.
Workaround Description
 use "16k"(lowercase) instead of "16K"(uppercase)



CR:734761
CR Number:   734761
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
NFR: enable more than 32767 user connections in ASE



CR:734800
CR Number:   734800
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 26 Sep 2013 Fixed
15.7 SP60 27 Sep 2013 Fixed
13 Nov 2013 Fixed
Description
Backup Server may occasionally report a spurious error when executing a DUMP or LOAD WITH VERIFY[ONLY], as a result of checking a page that is already deallocated. This is more likely to happen when the deallocated page belonged to compressed table.



CR:734866
CR Number:   734866
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2013 Fixed
Description
The builtin asehostname() is now made a grantable builtin.



CR:734897
CR Number:   734897
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 03 Apr 2013 Fixed
08 Apr 2013 One-off Provided
09 Apr 2013 Fixed
Description
On a High Availability (HA) System, sp_companion may hang if sp_sysmon is running at the same time.
Workaround Description
 Do not run sp_companion while sp_sysmon is running.



CR:734899
CR Number:   734899
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 12 Jul 2013 Fixed
15.7 SP110 15 Jul 2013 Fixed
07 Aug 2013 Bundled Request
Description
A 692 error, "Uninitialized logical page <pageno> was read while accessing database ...", may be reported after loading an in-memory database dump from a database where this page was used but was marked as deallocated incorrectly, resulting in this page not being archived in the dump.
Workaround Description
 Before taking the imdb memory dump execute: sp_dumpoptimize 'archive_space=maximum'



CR:734968
CR Number:   734968
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)
29 Mar 2013 Fixed
Description
Sometimes queries that involve multiple DERIVED TABLEs or VIEWs may return wrong results. The kind of queries that could be affected by this needs the following elements: (1) A DERIVED TABLE with a correlated expression SUBQUERY as one of the DERIVED TABLE抯 SELECT list items. (2) Another correlated SUBQUERY in the parent query block which is referencing the expression SUBQUERY result from 1) as the correlated column. (3) Both 1) and 2) are under an IN SUBQUERY of the top query block. 1) and 2) lead ASE query tree to use a worktable for the DERIVED TABLE and 3) puts an EXISTS requirement over a table used by the DERIVED TABLE. The combination causes ASE to miss the EXISTS requirement on the table when generating a plan and leads to duplicate rows.
Workaround Description
 compatibility mode



CR:734983
CR Number:   734983
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 13 Sep 2013 Fixed
15.7 SP60 07 Aug 2013 Fixed
05 Jul 2013 Reservation Made
22 Nov 2013 Fixed
Description
Added new option SET PLAN SHARED ON and server wide param 'abstract plan sharing'.

It enables Abstract Plan sharing between different users. Tables in the query with shared

abstract plan must be explicitly prefixed with the owner name or belong to the DBO user.



CR:735003
CR Number:   735003
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)
15.7 SP60 29 Jul 2013 Fixed
29 Jul 2013 Reservation Made
15.7 SP121 29 Oct 2013 Fixed
15.7 SP121 29 Oct 2013 Fixed
18 Nov 2013 Fixed
Description
The built-ins or stored procedures that rely on OAM for space accounting get blocked on an exclusive table lock on the table.



CR:735029
CR Number:   735029
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2013 Fixed
15.7 SP50 10 Apr 2013 Fixed
09 Apr 2013 Fixed
Description
When the source server is 15.7 ESD#2 or later, sybmigrate -m migrate session may fail with the error, "The catalog 'sysusers' in the target database appears to contain rows which were either

installed by the user or were previously migrated. Cannot proceed with migration of 'Users'".



CR:735036
CR Number:   735036
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2013 Fixed
28 Mar 2013 Reservation Made
02 May 2014 Fixed
02 May 2014 Fixed
02 May 2014 Port Not Needed
28 Apr 2014 Port Not Needed
28 Apr 2014 Port Not Needed
Description
When running concurrent SELECT commands and DELETE/UPDATE commands on TEXT/IMAGE/UNITEXT columns, the client connection may hang or report a TDS token error or raise error 7128 state 6.



CR:735107
CR Number:   735107
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jul 2013 Fixed
15.7 SP60 29 Jul 2013 Fixed
15.7 SP110 30 Jul 2013 Fixed
Description
A 247 (arithmetic overflow) error may be reported when the syscachepoolinfo and syscacheinfo MDA tables are queried.
Workaround Description
 The customer can recreate this view ,syscacheinfo, with below modification:

change from :

convert(numeric(5,2), convert (float,cu.memory_used ) / 1024)

change to :

convert(numeric(7,2), convert (float,cu.memory_used ) / 1024)



This view isn't a system table, just a user view created by installmaster.



If they do recreate the view, they will also want to set permissions,

just as installmaster does.



grant select on syscacheinfo to public



CR:735163
CR Number:   735163
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 04 Apr 2013 Fixed
08 Apr 2013 One-off Provided
11 Apr 2013 Fixed
11 Apr 2013 Reservation Made
Description
Adaptive Server Enterprise may crash and generate a core dump without any stack trace or messsage while multiple sessions run sp_companion simultaneously in threaded kernel mode.



CR:735187
CR Number:   735187
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2013 Fixed
Description
A 2583 error, "Number of data pages <value> counted by DBCC differs from count in the data OAM <pageid> for dbid <dbid> object <objectid>." may be reported when running DBCC CHECKTABLE on a table having a clustered index or placement index after the database that the table resides on experienced a load tran of ASE 15.5 or earlier to a server of ASE 15.7 or after.
Workaround Description
 Run DBCC TABLEALLOC on the affected tables.



CR:735223
CR Number:   735223
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2013 Duplicate
Description
Deffered Name resolution can cause unexpected syntax errors



CR:735256
CR Number:   735256
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 12 Aug 2013 Fixed
12 Aug 2013 Reservation Made
15.7 SP60 15 Aug 2013 Fixed
15.7 SP121 03 Oct 2013 Fixed
Description
Sometimes an insert query with union view or derived table with union in which tables have check constraint, could cause a signal 11 (SIGSEGV) and a stacktrace in errorlog involving the function NormalizeScalar().



CR:735270
CR Number:   735270
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2013 Fixed
Description
For query SELECTing multiple count aggregates, wrong result could happen when the final plan uses two phase aggregates. One of the count aggregates could come from an AVG().

It is more likely to happen when the two phase aggregate plan is also a parallel plan,

or when the query is also a GROUPBY query with a HAVING clause equal-comparing two of the count aggregates.
Workaround Description
 set advanced_aggregation off



CR:735292
CR Number:   735292
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2013 Fixed
25 Apr 2013 Fixed
24 Apr 2013 Fixed
15.7 SP50 11 Apr 2013 Fixed
Description
An ASE task making a remote procedure call to a server with server option 'net password encryption' set to true and 'cis_rpc_handling' disabled can go to sleep indefinitely and the client appears to be hung.



CR:735311
CR Number:   735311
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2013 Fixed
15.7 SP50 10 Apr 2013 Fixed
Description
syconfig.exe fails to optimize the server.



CR:735327
CR Number:   735327
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 22 Mar 2013 Fixed
02 Apr 2013 Fixed
26 Mar 2013 One-off Provided
01 May 2013 Fixed
Description
A 692 error, "Uninitialized logical page '24' was read while accessing object '2'

in database '<dbid>'. Please contact Sybase Technical Support." may be reported when

a 12.5.4 ASE database dump that was made with a 15.7 ESD#4.2 Backup Server is loaded

back in a 12.5.4 ASE.



CR:735346
CR Number:   735346
Product Name:   Sybase SQL Server
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2013 Fixed
05 Sep 2013 Fixed
15 Sep 2013 One-off Provided
27 Nov 2013 Fixed
Description
ALTER TABLE on a data compressed table may lead to heap memory (CPINFO pool) corruption. ASE stacktraces may be seen involving the functions kbfalloc() and cpinfo_allocbufs().



CR:735394
CR Number:   735394
Product Name:   Adaptive Server Enterprise
Product Component:   sybsetup - UNIX
Status:   Open
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request to know how much of the disk space requirements for installing ASE

so customer can be sure that they have enough space when they are ready to install.
Workaround Description
 Users can run the installer in interactive mode (GUI or console) to test the space requirement. If they see the "Pre-Installation Summary" panel, then the disk space requirement is satisfied. In this panel, they can click Next to continue the installation or quit the installer and rerun it in silent mode at later time.



CR:735431
CR Number:   735431
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2013 Fixed
26 Mar 2013 One-off Provided
01 May 2013 Fixed
03 Apr 2013 Fixed
Description
The error, "Table Corrupt: The row number and offset of each row in the page should have a matching entry in row number table ..." will be incorrectly reported in the Backup Server error log on pages with deleted rows that belong to an All Pages Locked table when executing DUMP/LOAD WITH VERIFY.



CR:735513
CR Number:   735513
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2013 Fixed
Description
System table sysusers is accessed too often during procedure execution.



CR:735516
CR Number:   735516
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2013 Fixed
18 Apr 2013 Reservation Made
15.7 SP60 07 Aug 2013 Fixed
15.7 SP110 12 Aug 2013 Fixed
Description
Need a mechanism to change the size of Engine Local Cache (ELC). By default ELC is 50 % of configured procedure cache size.



CR:735567
CR Number:   735567
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2013 One-off Provided
15.7 SP50 05 Apr 2013 Fixed
01 May 2013 Fixed
04 Apr 2013 Fixed
Description
The Backup Server is enhanced to perform consistency checks on Data Only Locked (DOL) index pages besides data pages during DUMP DATABASE execution.



CR:735568
CR Number:   735568
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Open
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
checkalloc is running 9-15 hours



CR:735578
CR Number:   735578
Product Name:   SCC Web Framework
Product Component:   Repository
Status:   Closed
OS:   RH Linux
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5515 04 Dec 2013 Bundled Request
Description
Need SCC built with SQL Anywhere 12.0.1 3842 or later
Workaround Description
 Set SA_DISABLE_DIRECTIO=1 prior to starting SCC.



CR:735590
CR Number:   735590
Product Name:   Adaptive Server Enterprise
Product Component:   SQL
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2013 Work as design
Description
user can get set tracefile rights when login is not a user in master db



CR:735660
CR Number:   735660
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2013 Third Party Problem
Description
monThread can have incorrect values on AIX, which can result in overly large or negative values in the sp_sysmon OS section.





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