提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着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:685833
CR Number:   685833
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2011 Duplicate
Description
Off-lining and on-lining engines when running ASE in kernel process mode on HPUX (HPIA64) platform to migrate the ASE PCI integrated COTS JavaVM should be prefented as desingated memory allocations within the COTS JavaVM plugin do leave stale references under its process model. See HPUX platform RB note under CR 595859.



CR:685854
CR Number:   685854
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_sysmon raising error 1902 on #temp_sysmon_baseline



CR:685874
CR Number:   685874
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2012 Fixed
Description
A 3250 error, "The devices <value> and <value> specified in the command should be differnt" may

be reported if the devices name length is more than 127 bytes when running a DUMP DATABASE command.



CR:685956
CR Number:   685956
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 Drop#3B Refresh
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2011 Fixed
20 Oct 2011 Fixed
20 Oct 2011 Fixed
Description
On Solaris, in rare circumstances, some tasks may hang trying to send data.



CR:685996
CR Number:   685996
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2011 Fixed
06 Dec 2011 Reservation Made
15 Dec 2011 One-off Provided
14 May 2012 One-off Provided
20 Sep 2012 Presently Not Targeted For Any Future Release Of This Product
10 Oct 2012 Fixed
21 Sep 2012 Fixed
Description
Abstract plan error could happen failing to apply a right nested outerjoin abstract

plan. It is more likely to happen when there is a subquery at the inner side too.

Same issue could also cause optimizer to ignore certain legit merge/hash

outerjoin bushy plan too under allrows_dss optimization goal.



CR:686131
CR Number:   686131
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #7 08 Nov 2011 Fixed
09 Nov 2011 Fixed
18 Nov 2011 One-off Provided
08 Nov 2011 Reservation Made
Description
I/O fencing on AIX uses raw SCSI-3 PGR commands which may not be supported on some IBM storage devices. ASE will display I/O fencing reservation errors and will fail to boot.



CR:686141
CR Number:   686141
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T: Basics
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2012 Added to user documentation
Description
sp_showplan cannot show spid doing BCP IN to heap table using large I/O. Need clarification in document.



CR:686159
CR Number:   686159
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2011 Fixed
07 Oct 2011 Reservation Made
18 Oct 2011 Fixed
18 Oct 2011 Reservation Made
18 Oct 2011 Fixed
Description
Login and login profile attribute-value 'authenticate with ANY' fails.



CR:686160
CR Number:   686160
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2011 Fixed
06 Oct 2011 Fixed
Description
In the case of working with DOL tables that are marked as hot objects using DBCC TUNE(..des_bind) there is still contention on the locks.



CR:686186
CR Number:   686186
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2011 Fixed
14 Oct 2011 Fixed
Description
Wrong result could happen when using an IN clause over a complex union view column and

one side of the union is directly projecting a constant for the column and the constant

is also part of the IN clause list.
Workaround Description
 1) applying ltrim to the column to be searched on the IN clause.

2) to use OR's instead of IN clause



CR:686209
CR Number:   686209
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2011 Fixed
11 Oct 2011 Fixed
11 Oct 2011 Fixed
30 Apr 2013 Fixed
Description
When statement cache is on and after a variable assignment from a column of a table statement is cached, it will return wrong results for the subsequent select of the variable value if the lwp for the statement need to be recompiled.
Workaround Description
 Turn the 'statement cache' off.



CR:686223
CR Number:   686223
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2011 Fixed
14 Oct 2011 Fixed
09 Apr 2012 Fixed
08 Nov 2011 Fixed
Description
Some performance improvements are made by 1) reducing client-server communication overhead when client passes parameters to dynamic SQL statements and 2) by optimizing the ASE code path for processing dynamic SQL batch commands when configuration option 'streamlined dynamic SQL' is enabled.



CR:686230
CR Number:   686230
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2011 Fixed
12 Oct 2011 Fixed
14 Dec 2011 Work as design
Description
For SDC server, the Database Creation wizard will not show the Durability page for user to select different level of durability because it assumes full durability for all user created database.



CR:686282
CR Number:   686282
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2011 Fixed
Description
Idle timeout value for a thread pool is set to 0 if it is set to 'DEFAULT' in configuration file.



CR:686341
CR Number:   686341
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2012 Fixed
30 May 2012 Fixed
Description
Recovery may fail with an 8201 error when the configuration parameter "per object statistics active" is enabled.
Workaround Description
 Turn off "per object statistics collection" and go through recovery again.



CR:686372
CR Number:   686372
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Not to generate new audit record for SA login on log full in sybsecurity database.



CR:686385
CR Number:   686385
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
02 Nov 2011 Fixed
Description
In a Sun Cluster 3.x High Availability environment, executing the kill_ase_engines function may lead to lots of time being spent constructing the pid list.
Workaround Description
 Add the following line between line 1229 and 1230 in utils.ksh.



1228 # if particular engine is offlined, remove its PID from pid_list

1229 if [[ $state != "online" ]]; then

+ new_list=""

1230 for tmppid in $pid_list

1231 do

1232 if [[ $pid -ne $tmppid ]]; then

1233 new_list="$new_list $tmppid"

1234 fi

1235 done

1236 pid_list=$new_list

1237 elif [[ $engine -eq 0 ]]; then

1238 pid_list=$pid

1239 else

1240 pid_list="$pid_list $pid"

1241 fi



CR:686436
CR Number:   686436
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2011 Presently Not Targeted For Any Future Release Of This Product
12 Jan 2012 Fixed
18 Jan 2012 Reservation Made
13 Jan 2012 Fixed
Description
New feature to allow DUMP TRANSACTION to run concurrently with DUMP DATABASE.



CR:686441
CR Number:   686441
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2011 Fixed
21 Dec 2011 Presently Not Targeted For Any Future Release Of This Product
30 Nov 2011 Fixed
Description
When batch inserts are executed on a compressed DOL heap table, the compression ratio

maybe lower than the compression ratio obtained from reorg rebuild. Certain conditions that

can contribute to this run-time space bloating issue are addressed.



CR:686456
CR Number:   686456
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2012 Added to user documentation
Description
add bullet items describing the difference in reorg rebuild with regards to update statistics on the leading column of an index



CR:686461
CR Number:   686461
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2011 Fixed
21 Oct 2011 Fixed
Description
The Add Login wizard is enhanced to take care of a 15.7 server that has no login-profile.



1. When there is no login-profile in a 15.7 server, make 'Ignore login profile when creating login' checkbox selected in the Login Profile page.



2. Disable the radio-button of 'Use a common login profile for the server version 15.7 and later' when there is only single 15.7 server appeared in the Login Profile page.



3. When a 15.7 server has no login-profile, make the server automatically appeared in the Default Database page. Note that before this fix, the Next button in the wizard is disabled and SCC user could not continue the wizard if 'Ignore login profile when creating login' checkbox is unselected; he has to cancel the wizard or unselect the 15.7 server that has no login-profile in the Introduction page or has to select 'Ignore login profile when creating login' checkbox in the Login Profile page.



CR:686481
CR Number:   686481
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2011 Fixed
01 Nov 2011 Fixed
Description
311 errors can occur on every second execution of a stored procedure that uses dirty reads on a #temptable/index created within the stored procedure.
Workaround Description
 Traceflag 16724



OR



Rewrite of procedure



CR:686549
CR Number:   686549
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)
16 Dec 2011 Added to user documentation
Description
The output from the sp_opt_querystats stored procedure only contains the plancost diagnostics if the exec or allexec options are specified. This was a documentation error.



CR:686604
CR Number:   686604
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2012 Fixed
Description
The output of the LogicalReads column in the monProcessActivity table is always 0.
Workaround Description
 We can turn on "statement statistics active" as a workaround.



CR:686631
CR Number:   686631
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
08 Nov 2011 Fixed
Description
Pre-fetch allocation page while inserting forward row and while de-allocating the DOL data page. At the same time, use hint from placement index while inserting into a DOL table without page linkage

status bit.



CR:686690
CR Number:   686690
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2011 Fixed
04 Nov 2011 Fixed
Description
There are PCIDB spelling errors within the stored procedure arguments.



CR:686706
CR Number:   686706
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2012 Fixed
Description
After 15.0.3 to 15.5 upgrade by binary overlay, sp_spaceused and rowcount() on customer's server may incorrectly report 0 rows for user tables.
Workaround Description
 1. Reboot the 15.5 server.

2. If the old server is shutdown with nowait, reboot may not solve the problem, user have to run update table statistics.



CR:686798
CR Number:   686798
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2012 Not a Bug
Description
Other processes may encounter an 8233 message while a function-based index is being created on a table, as an ALTER TABLE is being performed internally. This CR requests the message be enhanced to mention create index as a possible cause to avoid confusion.



CR:686821
CR Number:   686821
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)
03 Nov 2011 Fixed
12 Dec 2011 Reservation Made
Description
Trigger support is enabled for the MERGE statement.



CR:686891
CR Number:   686891
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 ESD#1 28 Oct 2011 Fixed
Description
DSParser's discoverInterfacesServerNames(), which uses SyInterfacesDriverBase.loadFile(InputFileStream), may raise a NullPointerException.



CR:686943
CR Number:   686943
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)
14 Oct 2011 Bundled Request
Description
A 9236 error, "Unknown dbid '0' specified. Please check the dbid specified."

may be reported when executing the system stored procedure SP_HELP_REP_AGENT

with no parameter.



CR:687001
CR Number:   687001
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)
07 Nov 2011 Fixed
To Be Determined 12 Apr 2012 Presently Not Targeted For Any Future Release Of This Product
14 Nov 2011 Fixed
Description
When MetaData Reduction is turned on ASE RepAgent sends integers in Metadata rows with the integer data type and with no data type for Data Only rows. This causes problems when HVAR is being used. The ASE RepAgent has been changed to always send integers as character strings.



CR:687006
CR Number:   687006
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A new feature request for a Transact-SQL function that will report the stack utilization for a

given process.



CR:687106
CR Number:   687106
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2011 One-off Provided
20 Oct 2011 Fixed
01 Nov 2011 Fixed
01 Nov 2011 Fixed
Description
In syconfig.exe, many sort order options are missing if user chooses to set utf8 as the default character set.



CR:687139
CR Number:   687139
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2011 Fixed
04 Mar 2013 Presently Not Targeted For Any Future Release Of This Product
Description
ASE stalls when the license server host machine dies (or is shutdown). During that period ASE does not accept new connections.
Workaround Description
 Use a 3-server-redundant license server configuration. The stall does not occur when 3 server redundancy is used (the license is checked-out from the secondary rather than continuing to wait further for a response from the primary license server).



CR:687265
CR Number:   687265
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2011 Fixed
Description
When configuring a new ASE server,the configuration may fail and terminate while configuring PCI because the max memory configuration is not enough to allow "enable java".



CR:687303
CR Number:   687303
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2011 One-off Provided
02 Aug 2012 One-off Provided
28 Sep 2012 Fixed
06 Feb 2014 Port Not Needed
Description
We need a code change for histserver to allow the increase of the SRV_S_DEFQUEUESIZE for customers who use histserver against multiple ASEs. The current default is not sufficient.



CR:687372
CR Number:   687372
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 06 Jun 2013 Fixed
10 Jun 2013 Fixed
04 Dec 2013 One-off Provided
15.7 SP60 04 Dec 2013 Fixed
25 Jun 2014 Fixed
03 Jun 2014 Fixed
Description
A 697 error, "An attempt was made to fetch logical page <pagenum> for database <dbname>....", during transaction rollback, if the transaction is doing some DMLs to upgrade row lock to table lock.



CR:687418
CR Number:   687418
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2011 Fixed
18 Dec 2011 Added to user documentation
Description
This description supersedes the one in 686461.



The Add Login wizard is enhanced to take care of a 15.7 server that has no login-profile.



1. When there is no login-profile in all 15.7 server, make 'Ignore login profile when creating login' checkbox selected in the Login Profile page. Otherwise, if there is LP in a 15.7 server, make 'Ignore login profile when creating login' checkbox selected by default in the Login Profile page.



2. Disable the radio-button of 'Use a common login profile for the server version 15.7 and later' when there is no common LP data found among the 15.7 server that has data of LP.



3. When a 15.7 server has no login-profile, make the server automatically appeared in the Default Database page. Note that before this fix, the Next button in the wizard is disabled and SCC user could not continue the wizard if 'Ignore login profile when creating login' checkbox is unselected; he has to cancel the wizard or unselect the 15.7 server that has no login-profile in the Introduction page or has to select 'Ignore login profile when creating login' checkbox in the Login Profile page.



CR:687523
CR Number:   687523
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2012 Fixed
13 Mar 2012 One-off Provided
26 Jan 2012 Reservation Made
13 Mar 2012 One-off Provided
13 Apr 2012 Fixed
11 Oct 2012 Fixed
Description
In rare circumstances on a heavily-loaded multi-engine system, a 8201 error

"Keep count of descriptor (objid=<id>, dbid=<id>) was expected to be 1. Instead 0 was found."

may be reported in the error log together with a stack trace which includes

the modules 'des__unkeep' and 'close_range' when an INSERT, DELETE or UPDATE is

executed on a table that has many referential integrity constraints defined and

after the execution of one of its triggers. Alternatively the message "infected with 11"

in the modules 'seq_schema_check_virtab' or 'LeScanOp::_LeOpOpen' may be reported.



CR:687551
CR Number:   687551
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)
28 Oct 2011 Fixed
25 Oct 2011 Fixed
Description
A UNION ALL query which involves ORDER BY and an in-row LOB column, where the column coming from the first side of the UNIONALL is not an in-row LOB column, but a corresponding column from the second or subsequent side is, can cause error 7139 to be raised.



CR:687576
CR Number:   687576
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
14 Nov 2011 Fixed
Description
When Metadata Reduction is turned on but an insufficient Replication Server exec cache size is configured, RS may return a cache error. The logic for processing cache errors on the ASE RepAgent side is changed to skip records that were already sent to RS.



CR:687587
CR Number:   687587
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2012 Added to user documentation
Description
Documentation enhancement request to document that dumps of the master database can be loaded into an Archive database.



CR:687623
CR Number:   687623
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T: Query Processing and Abstract Plans
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Documentation enhancement request for more comprehensive information on the GUI Query Plan Viewer that comes with Interactive SQL



CR:687640
CR Number:   687640
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2011 Fixed
24 Oct 2011 Fixed
13 Dec 2011 Added to user documentation
Description
The titles of wizard appeared in ASEMAP 3.2.2 are changed:



Create Database Wizard -> Add User Database

Create Temporary Database Wizard -> Add Temporary Database

Create Temporary Database Group Wizard -> Add Temporary Database Group

Create Proxy Database Wizard -> Add Proxy Database

Create Archive Database Wizard -> Add Archive Database

Create In-Memory Database Wizard -> Add In-Memory Database

Create In-Memory Temporary Database Wizarde -> Add In-Memory Temporary Database

Create Login Profile Wizard -> Add Login Profile



CR:687735
CR Number:   687735
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
08 Nov 2011 Fixed
Description
Populating a proxy table that contains TEXT columns with several hundred rows of data using INSERT INTO... SELECT may fail with Error 3651, "This transaction has been rolled back, rather than only the current statement."
Workaround Description
 If text column is avoided, problem does NOT occur but if inserted/updated separately then hits CR 548593.



CR:687787
CR Number:   687787
Product Name:   Adaptive Server Enterprise
Product Component:   sybdiag
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
Description
Sybdiag does not work if it cannot log into the ASE server



CR:687824
CR Number:   687824
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 Dec 2011 Fixed
22 Dec 2011 Fixed
22 Dec 2011 Reservation Made
Description
Additional syntax for the UPDATE STATISTICS command is implemented to support an ordered tuple mode for non-indexed columns. The new syntax is: update statistics (col1), (col2) .... (coln)



CR:687834
CR Number:   687834
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under unusual conditions, error 5030 may be raised in error when an online database is altered over a 63GB boundary, requiring a new sysgams extent to be allocated.



CR:687909
CR Number:   687909
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
Description
Adaptive Server may disconnect a client with TDS version below 5.0 logging "nast_readpost: Invalid tdslength" message in the error log.



CR:687982
CR Number:   687982
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)
28 Oct 2011 Fixed
Description
sp_showoptstatus does not handle BIGDATETIME datatype.



CR:688086
CR Number:   688086
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga fs3+
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2011 Fixed
25 Oct 2011 Reservation Made
25 Oct 2011 Fixed
Description
A 529 error may be raised when all of the following conditions are met:

(1) The configuration option 'enable functionality group' is enabled.

(2) The configuration option 'statement cache size' is larger than 0.

(3) A dynamic SQL statement with at least one parameter whose dataype depends upon a table-column referenced in the statement has been prepared and executed at least once, so that a query plan is available.

(4) The table-column's datatype has been changed to a type that is not implicitly convertible to the original type by dropping and re-creating the table.

(5) The dynamic SQL statement is re-executed with a parameter type that matches the new column dataype.



CR:688108
CR Number:   688108
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2012 Added to user documentation
Description
show_plan() documentation should be corrected how this could be used on a spid.



CR:688148
CR Number:   688148
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Open
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sybmigrate setup migrate_server_data fails on duplicate row in sysusers, syslogins, or sysroles, but not everything is rolled back, causing customers to need help cleaning up the target so they can migrate database data in the migrate mode.
Workaround Description
 manually delete from system tables on target and reboot target ASE



CR:688155
CR Number:   688155
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2012 Added to user documentation
Description
On little-endian platforms, timestamp column values are displayed as big-endian values, while @@dbts is still displayed as native little-endian value, and must be manually swapped to compare with timestamp column values using "reverse(substring(@@dbts,1,2)) + 0x0000 + reverse(substring(@@dbts,5,4)) "



CR:688166
CR Number:   688166
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2011 Fixed
22 Nov 2011 Fixed
Description
The Assertion ((varNo == VR_NOENTRY) || (addIn.varNo == varNo)) may fail for queries with parallel

reformatting strategies where the reformatted table is partitioned N-ways.



CR:688198
CR Number:   688198
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
07 Nov 2011 Fixed
10 Nov 2011 Fixed
Description
Nested loop join plan with StoreIndex (reformatting) could return wrong result when there

is an expression join predicate and the expression involves columns from both sides of the

join (e.g. t1.c1*t2.c2=t1.c3).
Workaround Description
 use traceflag 16936 to disable the regression fix.



CR:688284
CR Number:   688284
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)
06 Nov 2011 Fixed
Description
When updating a LOB column with itself, if the original LOB data is compressed while neither this LOB column is defined to be compressed nor the table has LOB compression currently, ASE does not decompress the original LOB data.



CR:688338
CR Number:   688338
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
02 Nov 2011 Fixed
23 Nov 2011 Fixed
18 Sep 2012 Fixed
Description
Query involving column relop NULL clause may result in a 403 error message if the column projects NULL and the relop is =, >=, >, <= or <.
Workaround Description
 use CONVERT or CAST to explicitly assign a

datatype to the derived column :-



create view v1

as

select convert(int,NULL) as col from test

go



-- or --



create view v1

as

select cast(null as int) as col from test

go



-- or use is null clause --

select * from v1 where v1.col

go



CR:688352
CR Number:   688352
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2011 Fixed
25 Nov 2011 Fixed
28 Nov 2011 Fixed
28 Nov 2011 Fixed
Description
Using Replication Agent with the 'meta data reduction' option enabled can result in a large number of 'remove table' commands being send towards Replication Server.



CR:688414
CR Number:   688414
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
Description
Drop index may hang in a 3-node Cluster setup.



CR:688481
CR Number:   688481
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2012 Fixed
25 Oct 2012 Fixed
23 Jan 2014 One-off Provided
09 May 2014 Fixed
Description
The message "current process infected with 11" in the module

sdes_num_in_chain() together with a stack trace which includes the

modules kill_proc() and LeExecSqlFunc() may be reported in the error

log if a long running user-defined SQL function session gets killed.

ASE may need to be rebooted following this error.



CR:688495
CR Number:   688495
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2012 Fixed
18 Jun 2012 Fixed
Description
If a new instance is dynamically added to the cluster in SDC mode, it may not be able to join the cluster when no other activity is taking place in the cluster.



CR:688595
CR Number:   688595
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2012 Fixed
Description
The MDA table monCachedStatement is enhanced to include new AdjustToParallel, AdjustToSerial and ThreadDeficit columns to track parallel runtime adjustment.



CR:688611
CR Number:   688611
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)
Description
Need additional messages to help diagnose which paths are having problems.
Workaround Description
 If the Rep Agent thread on the RS says it is down:



1. validate that the Rep Agent is configured for multithreaded Rep Agent

(sp_config_rep_agent <dbname>)

2. Validate that the number of replication paths does not exceed the 'max number of replication paths' (sp_config_rep_agent <dbname>)

3. stop and restart the Replication Agent to ensure that the values you are looking at, are really in effect.

4. See what paths have been configured:

sp_replication_path mpr3pri,'list'

4. See what paths are running:

sp_help_rep_agent mpr3pri,'process'



CR:688706
CR Number:   688706
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows 2008
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2011 Fixed
05 Mar 2013 Insufficient priority to fix
Description
ASE WebServices server fails to start on Winx64 platform.
Workaround Description
 No workaround



CR:688843
CR Number:   688843
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2012 Fixed
Description
The help text for system stored procedure sp_replication_path includes an incorrect syntax for the unbind action with a path as a target.



CR:688849
CR Number:   688849
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2013 Insufficient priority to fix
Description
Server hangs after a timeslice error with a stack that includes the functions dmpx__truncatemain and des_checkpoint.



CR:688856
CR Number:   688856
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2012 Fixed
02 May 2012 Reservation Made
02 May 2013 One-off Provided
02 May 2013 Fixed
Description
A query containing an OR clause nested under another OR clause might generate a SEGV. This could occur if the in_list_general_or optcriteria is on. The optcriteria is enabled in the ase1503esd4

optlevel and above. The stack will show that we're code generating (CgpGlobal::CgpGenerate()) and trying to resolve a relop (ResRelOp) for a predicate bitmap (CgpPop::_CgpPePredBmToScalar).
Workaround Description
 set in_list_general_or off

go



OR



set index_union off

go



OR



set compatibility_mode on

go



CR:688895
CR Number:   688895
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2011 Not reproducible with latest version of the product available as of Resolution Date
Description
Rep Agent does not stop. signal 6 and stack in ASE log.
Workaround Description
 Reboot the ASE Server



CR:688908
CR Number:   688908
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
statement cache on , sp_renamedb wrong relsults with inserts
Workaround Description
 disable statement cache



CR:688932
CR Number:   688932
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.7 Control GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#1 01 Nov 2011 Duplicate
Description
sybase central device tab java error when segmap 0 for tempdb
Workaround Description
 use scjview.sh from 15.5 esd #4



CR:688938
CR Number:   688938
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
add messaging to Error: 11031, to include dbid or database name



CR:689004
CR Number:   689004
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)
14 Jan 2014 Fixed
16 Jan 2014 Fixed
14 Jan 2014 Fixed
Description
Setting the configuration parameter 'send doneinproc tokens' to zero, can cause the global variable @@rowcount to report an incorrect value inside a stored procedure or trigger.



CR:689019
CR Number:   689019
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2012 Added to user documentation
Description
update documentation about the setting for 'send doneinproc tokens'.



CR:689028
CR Number:   689028
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2011 Fixed
Description
When creating a new ASE, syconfig prompts for whether the optgoal should be set to OLTP, DSS or MIX but it never sets the configuration option 'optimization goal'.



CR:689037
CR Number:   689037
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Case insensitive sort + encrypted index column leads to table scan



CR:689056
CR Number:   689056
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2014 Insufficient priority to fix
01 May 2012 Presently Not Targeted For Any Future Release Of This Product
Description
An UPDATE that modifies more than one column may cause an infected with 11 stacktrace in the module CgpPop::CgpInplaceUpdateVars. As a workaround, begin a transaction and update each column one at a time.
Workaround Description
 Work around:

comment one section of the update statement

(ie only update one column at a time instead of both columns) then sp works fine.



So the work around would to split the single update into 2 different updates.



CR:689074
CR Number:   689074
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guides - All Platforms
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2012 Added to user documentation
Description
Following an upgrade by binary overlay or substitution, in memory object statistics may not be initialized, leading to poorly optimized plans. Following the upgrade of online databases, ASE should be rebooted once as a final step of the upgrade process to force reinitialization of memory structures from the ugpraded tables.



CR:689084
CR Number:   689084
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)
09 Nov 2011 Fixed
Description
In replication environment, if a table has data compression, and some data rows becomes forwarded

due to UPDATE, rep agent will report 9275 error "%S_REPAGNT: Could not locate the %s image for the

%s log record at (%d,%d)."



CR:689117
CR Number:   689117
Product Name:   SySAM
Product Component:   SyLAPI/C
Status:   Open
OS:   HP-UNIX
Original Version:   2.2.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sysamcap command may hang on nPar if there are many VMs.



CR:689142
CR Number:   689142
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2011 Fixed
Description
Executing ALTER DATABASE to extend a database onto a new device may fail after loading a dump of a read only or single user Quiesce database.



CR:689153
CR Number:   689153
Product Name:   Adaptive Server Generic Docs
Product Component:   To Be Determined
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
15.7 docs still refers to monitor/historical server which are no longer included in the ASE release package.



CR:689176
CR Number:   689176
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
08 Nov 2011 Fixed
Description
A segmentation fault followed by a stack trace involving the functions LeDataRow::_copyVarnoToCnst(), LeDataRow::readRow() and LeSortOp::_LeOpNext() may arise when a query with all of the following is executed:

(1) An outer join the projects a LOB column from the inner side of the join and

(2) A UNION ALL operation and

(3) An ODERBY clause.



CR:689180
CR Number:   689180
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)
31 May 2013 Insufficient priority to fix
Description
Queries may return rows where the column value is null and the search argument is NOT a value from an implicit conversion. Whereas, if there in no implicit conversion, the null values are not returned.
Workaround Description
 set ansinull on

for consistent behaviour.



CR:689195
CR Number:   689195
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
Description
When a user chooses "Optimize Adaptive Server configuration" during ASE installation with the GUI tool or resource file utility, the syb_default_pool thread pool is not set.



CR:689200
CR Number:   689200
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
HG index is not defined to proxy table



CR:689206
CR Number:   689206
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2011 Fixed
16 Nov 2011 Fixed
Description
Replication Agent treats normalization (NRM) errors from Replication Server as warnings. All normalization errors should be treated as fatal.



CR:689214
CR Number:   689214
Product Name:   ASE Management
Product Component:   Administration Agent Plugin
Status:   Closed
OS:   Generic
Original Version:   3.2.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
02 Nov 2011 Fixed
Description
SCC may raise a syntax error for sp_cacheconfig when trying to configure a cache larger than 9GB in size. Workaround is to run sp_cacheconfig directly though isql or similar client.
Workaround Description
 Run sp_cacheconfig directly through ISQL or other client.



CR:689217
CR Number:   689217
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Generic
Original Version:   3.2.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2011 Fixed
Description
The context menu for Users object in the Admin Console for ASEMAP is changed to "Transfer Object Ownership" from "Transfer Object Owner".



CR:689224
CR Number:   689224
Product Name:   Sybase SQL Server
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2012 Fixed
Description
When marking a database with sp_reptostandby and 'use_index', some TEXT columns may be handled unexpectedly with a replication status do_not_replicate instead of replicate_if_changed.
Workaround Description
 Increase the ASE configuration parameter 'number of open objects'

in order to increase the size of the memory pool "Text/image replication",

and restart ASE because this memory pool is not dynamic despite

the configuration parameter 'number of open objects' being dynamic.

Be aware that when sp_reptostandby is executed with the use_index option,

internal indexes are created only on those tables not explicitly marked for replication

through sp_setreptable as documented in the RS Admin Guide Vol. 2 / Setting Up ASE Warm

Standby Databases.



CR:689230
CR Number:   689230
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2012 Fixed
13 Nov 2012 Reservation Made
Description
The message "current process infected with 11" in the module "uwdisconnect" may be reported in the error log when a DBCC CHECKSTORAGE was aborted by CTRL+C or client application was killed.



CR:689235
CR Number:   689235
Product Name:   SySAM
Product Component:   SyLAPI/C
Status:   Open
OS:   HP-UNIX
Original Version:   2.2.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
cpuinfo and sysamcap may incorrectly recognize machine-wide physical CPUs on nPar.



CR:689359
CR Number:   689359
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2014 Insufficient priority to fix
Description
Sig 11 occurred when running a simple query where clause having 129 value lists IN.

But having 128 value lists for the same query works fine without problem.
Workaround Description
 use traceflag 15393 to turn off largeinlist transformation.



CR:689431
CR Number:   689431
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2011 Fixed
10 Nov 2011 Fixed
15 Nov 2011 Fixed
22 Nov 2011 Fixed
Description
UPDATE on DOL table with non-clustered index on two fixed length columns may fail with a 644 error.



CR:689470
CR Number:   689470
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for greater control over CSMD triggers including state value for numbered errors and particular function names on the stack for signal conditions.



CR:689633
CR Number:   689633
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2012 Presently Not Targeted For Any Future Release Of This Product
Description
sp_object_stats "xx:xx:xx" doesn't produce an output
Workaround Description
 1) sp_object_stats "00:10:00",50,@rpt_option="rpt_locks"



2) sp_object_stats "00:10:00",50,@rpt_option="rpt_objlist"



CR:689650
CR Number:   689650
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2011 Fixed
Description
The message "current process infected with 11" in the module 'open__common_sdes_setup'

together with a stack trace which includes the modules 'open__lwpbyname' and 'proc_get' may

be reported in the error log and the session killed if a 603 error has been previously hit

"There are not enough system session descriptors available to run this query. Raise the value

of the configuration parameter 'number of aux scan descriptors' or retry your query later.".
Workaround Description
 Raise the value of the configuration parameter 'number of aux scan descriptors'.



CR:689691
CR Number:   689691
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2011 Fixed
13 Dec 2011 Fixed
28 Nov 2011 Fixed
13 Dec 2011 Fixed
Description
The Resource->rpdeshash_spin may result in high contention under some workloads.



CR:689798
CR Number:   689798
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2012 Fixed
Description
Under rare race conditions, when BCP IN is in progress with the INSERTs running concurrently on the same table, BCP may encounter an 820 error where the process tries to dirty a buffer which is already pinned to another PLC.





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

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,16.x,17.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使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

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
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


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

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


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

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------