提供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:676195
CR Number:   676195
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Windows XP
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jul 2011 Fixed
25 Jul 2011 Fixed
22 Jul 2011 One-off Provided
26 Aug 2011 One-off Provided
28 Sep 2011 One-off Provided
25 Oct 2011 One-off Provided
Description
Following installation of ASE 15.5 ESD#3 on Windows, the gui tool Server Config appears to be unaware of character set cp1250.
Workaround Description
 To work around the problem the charset.exe utility can be used to load the character set to the server.



Load charset cp1250 using the charset.exe command.



First, change directory to %SYBASE%\charsets\cp1250



charset.exe -Usa -P S<server> binary.srt cp1250



This command should be repeated for each sort order required.



Connect to the server and change the default character set id using sp_configure.

sp_configure 'default character set id',22



Shutdown the server from within isql.

Restart the server. ASE will process the changes and shutdown automatically. Restart the server again and the chararcter set is now cp1250.



CR:676226
CR Number:   676226
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2013 Insufficient info provided
Description
CIS connections fail on a single engine of a server, causing the dataserver to have to be re-cycled. Erros 11216, 11206 get ct_connect() error message of -1 (minus one).



CR:676329
CR Number:   676329
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2013 Insufficient info provided
Description
Signal 4 report from routine ct__tds_readall



CR:676357
CR Number:   676357
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Errors 225 on UPDATE of computed column that uses UDFs after load from database with different dbid
Workaround Description
 Modify the computed column. Eg:

alter table jTab modify colC as dbo.jFunc (colB) materialized



CR:676358
CR Number:   676358
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE fails to recognize , symbol as decimal notation for german, danish, french in config file
Workaround Description
 Replace the , symbol on the ASE config file with the decimal notation



CR:676453
CR Number:   676453
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B RTC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2011 Fixed
12 Jul 2011 Fixed
12 Jul 2011 Fixed
Description
An ASE task may be terminated with a timeslice error while issuing an asynchronous i/o. This is caused by a hang in the operating system, and can lead to recovery errors in Adaptive Server. Adaptive Server has been modified to avoid terminating the task, and will print an informational message instead. Recovery errors will be avoided, but ASE engine will hang until the operating system responds.



CR:676488
CR Number:   676488
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
Signal 11 in VbmManager::_VbmPutBm when using semantic partitioning



CR:676500
CR Number:   676500
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: cannot send and cannot read message to include both suid and spid



CR:676650
CR Number:   676650
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 Drop#3B RTC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2011 Fixed
12 Aug 2011 Fixed
Description
The average metrics value often appears as zero and can't capture the elapsed time less than 3ms in monCachedStatement and sysquerymetric



CR:676654
CR Number:   676654
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)
17 Oct 2011 Fixed
Description
In rare circumstances an uncommitted change to text/image data by the execution

of a WRITETEXT non logged command may not be rolled back during ASE boot time recovery

and after ASE was shutdown with nowait.



CR:676853
CR Number:   676853
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2011 Duplicate
28 Mar 2014 Fixed
Description
Feature request for a TSQL extension that would allow isolation level 0 (dirty reads) to be used with SELECT INTO and the SELECT part of an INSERT SELECT.



CR:676991
CR Number:   676991
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2011 One-off Provided
02 Oct 2012 One-off Provided
27 Sep 2012 Fixed
06 Nov 2012 Fixed
16 Nov 2012 Fixed
Description
High CPU usage may be seen along with with high rprocmgr_spin contention.
Workaround Description
 Run "dbcc proc_cache(free_unused)" once an hour.



CR:677059
CR Number:   677059
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2011 Fixed
Description
When parse_text() builtin with execute immediate is run concurrently in many sessions with each session running the query multiple times in a loop, it will result in segmentation violation in prot_desc().



CR:677101
CR Number:   677101
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2011 Fixed
29 Jul 2011 Fixed
Description
In a high volume server with many processes accessing and updating a DRL table with a TEXT/IMAGE or off-row JAVA column, sometimes it could return inconsistent data.
Workaround Description
 Use isolation level 2 for the SELECT spid



CR:677132
CR Number:   677132
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2011 Added to user documentation
Description
Documentation correction: Prior to 15.0, if a client did not specify a packet size, it defaulted to 512 bytes rather than using the ASE configuration for default packet size. The 15.5 System Administartion Guide still states "If you change the default packet size, clients must request the larger packet size when they connect." but that is no longer correct.



CR:677153
CR Number:   677153
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)
11 Aug 2011 Fixed
Description
When loading a dump generated by an ASE 12.5 (which is not AIX) to an ASE 15.5 AIX server, an invalid column length error may be raised raised.
Workaround Description
 Use workaround listed in CR# 435212.



CR:677167
CR Number:   677167
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Generic
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2012 Bundled Request
Description
Requesting Sybase to supply stored procedures or Sybase Central or SCC improvements to the automation of reorg rebuild activities performed within a database.
Workaround Description
 Current workaround is to build customer developed scripts. This requires time for development and checkout and might not be very complete when it comes to error paths.



CR:677281
CR Number:   677281
Product Name:   Sybase ETL
Product Component:   Docs
Status:   Open
OS:   Windows 2008
Original Version:   4.9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need better ETL documentation to avoid possible port conflicts



CR:677364
CR Number:   677364
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)
23 Mar 2012 Presently Not Targeted For Any Future Release Of This Product
Description
ASE 15.0.3 EFTS query is slow after upgrading from 12.5.4e10 to 15.0.3
Workaround Description
 faster query ...



select

tbl.c1,

tbl.c2,

ti.id,

ti.score,

ti.index_any

from

repro1.dbo.ti_txtindex ti,

repro1.dbo.t1 tbl

WHERE

ti.id=tbl.id and

index_any = '("first_word"<OR>"second_word" <in> c3)'

order by

tbl.c1 asc,

tbl.c2 asc

go



CR:677481
CR Number:   677481
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2011 Fixed
30 Nov 2012 Fixed
Description
In rare circumstances, Adaptive Server may hit signal 11 at mda__process_sdes during a query on the monProcessObject MDA table.



CR:677487
CR Number:   677487
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Checkpoints stop occurring after the "number of checkpoint tasks" configuration parameter has been decreased until Adaptive Server is restarted or the configuration parameter is increased.
Workaround Description
 reboot ASE



or



increase "number of checkpoint tasks"



CR:677528
CR Number:   677528
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 Aug 2011 Consult Complete
Description
An 8201 error is reported with functions dropindex, ptn_delete_row, and ptn__link_pdes_to_xdes on the stack.



CR:677539
CR Number:   677539
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Unrecovered tempdb cause SIGSEGV when select from fake table



CR:677580
CR Number:   677580
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SVR4
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2011 Fixed
08 Nov 2011 Fixed
Description
When executing SP_SETREPTABLE with the parameter value 'USE_INDEX', the indexes created for

the replication of off-row text/image columns may become inconsistent when the table does

not have any other non-clustered index. In that case 'DBCC CHECKTABLE' would report error 7928.

'UPDATE' or 'WRITETEXT' may fail with error 644 or error 7165 respectively.
Workaround Description
 The following command lists all the tables which may have an inconsistent index for replication:

select name from sysobjects where type="U" and sysstat2 & 8388608 != 0 and sysstat & 32 = 0

go



To fix the problem for a given table t2:

sp_configure 'allow updates to system tables', 1

go

sp_setreptable t2, 'false'

go

sp_setreptable t2, 'true', null, 'use_index'

go

begin tran

go

select sysstat from sysobjects where id=object_id('t2')

go

update sysobjects set sysstat = sysstat | 0x20 where id=object_id('t2')

go

select sysstat from sysobjects where id=object_id('t2')

go

commit

go

sp_configure 'allow updates to system tables', 0

go



CR:677603
CR Number:   677603
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2011 Workaround
29 Jul 2011 Fixed
Description
In some cases, even there is no IBM MQ message operation, Q engine still hold high CPU usage. Open traceflag 15104 to workaround this issue.
Workaround Description
 Open the trace flag 15104.



CR:677698
CR Number:   677698
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2011 Fixed
Description
ASE install required reboot on windows XP



CR:677805
CR Number:   677805
Product Name:   SCC Web Framework
Product Component:   GUI
Status:   Closed
OS:   Generic
Original Version:   3.2.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2012 Fixed
15 Sep 2011 Added to user documentation
17 Jul 2012 Fixed
Description
SCC has been enhanced to dynamically generate the repository server name on startup. The name will follow the convention "scc[<host>:<dbport>]". This enhancement, coupled with the ability to modify SCC ports enable multiple concurrent SCC instances to be run on the same host.



CR:677826
CR Number:   677826
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)
25 Oct 2012 Fixed
Description
When 'enable literal autoparam' is on, executing a dynamic SQL query with numerical literal with precision over NUME_USERPREC(38) could cause errors 2756 and 706.



CR:677850
CR Number:   677850
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)
22 Jul 2011 Fixed
27 Jul 2011 Fixed
Description
The ASE server has a memory leak that is hit when the ASE server is run in threaded mode

and several client connections are simultaneously made using encrypted passwords.
Workaround Description
 sp_configure "kernel mode" process.

or

In threaded mode use only one engine.



CR:677991
CR Number:   677991
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2011 Fixed
Description
Sometimes after a failed attempt to drop a large buffer pool in a busy system, the pool may still be be available for use even if sp_cacheconfig shows the pool status as "Unavailable/deleted". However, subsequent use of the pool may, under rare circumstances, lead to timeslice error with modules like pg_allocate(), bufnewpage() and cm_cache_wash() reported in the stack.



CR:678070
CR Number:   678070
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under certain circumstances, queries that contain multiple views and/or derived tables may encounter a stack trace in vu_fixupvar. If it is possible to re-write the query to use temporary tables rather than derived tables, the problem can be avoided.
Workaround Description
 By executing the sql for the derived table and creating a temporary table to then use in the query, no stack trace is reported.

I.E.



Change this SQL:

select t.type_sel_code, t.*, conta.*, cash.*

from dbo.transactions t,

(select distinct transactionId_id from dbo.efectivo_dlc_aceptado_contaval) conta,

dbo.cashProjection cash,

dbo.transactionTypes tt

where t.type_sel_code = tt.type_sel_code and

tt.effective =1 and

t.objectId_id = conta.transactionId_id and

t.objectId_id = cash.objectId_id and

(cash.fixing_liq = 0 or cash.fixing_CCC = 0)

Go



To a two step query:



select distinct transactionId_id into #edac from dbo.efectivo_dlc_aceptado_contaval



select t.type_sel_code, t.*, conta.*, cash.*

from dbo.transactions t,

#edac conta,

dbo.cashProjection cash,

dbo.transactionTypes tt

where t.type_sel_code = tt.type_sel_code and

tt.effective =1 and

t.objectId_id = conta.transactionId_id and

t.objectId_id = cash.objectId_id and

(cash.fixing_liq = 0 or cash.fixing_CCC = 0)

go



CR:678124
CR Number:   678124
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 Drop#3B Refresh
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2011 Fixed
20 Jul 2011 Fixed
Description
Shared memory dump conditions of type "signal" on the 64 bit Microsoft Windows platform are not displayed correctly in sp_shmdumpconfig.



CR:678129
CR Number:   678129
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
customer is requesting the PK columns of a PDM to become elements in XSM





currently when generating an XSM from a PDM, columns could be generated to XSM as either all Elements or all Attributes



customer claims that PK columns should be coming into XSM as child elements, whereas the non-PK columns are Attributes



i.e.

- create Table_1, Col_1 (PK), Col_2 and Col_3

- generate XSM from PDM



- if columns are selected to be generated as Elements, then the outcome diagram is

Root --S---> Table_1 --S---> Col_1, Col_2, Col_3, where --S---> is Sequence and Table_1, Col_1, Col_2 and Col_3 are elements



- if columns are selected to be generated as Attributes, then the outcome diagram is

Root --S---> Table_1 | Col_1, Col_2, Col_3 |, where --S---> is Sequence and Table_1 is Element, and Col_1, Col_2, and Col_3 are attributes of Table_1



- customer thinks that the following should be the outcome diagram:

Root --S---> Table_1 | Col_2, Col 3 | --S---> Col_1, where --S---> is Sequence, Table_1 and Col_1 are Elements, and Col_2 and Col_3 are attributes of Table_1



workaround

defining manually through XML builder workaround provided - however, it will not work very well if the numbers of tables get large.



CR:678184
CR Number:   678184
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2011 Fixed
11 Aug 2011 Fixed
05 Oct 2011 One-off Provided
Description
In rare circumstances, checkstorage may report the error 835, "Illegal attempt to change contents of buffer" followed by a stack trace that includes the module pchk_copy_page().



CR:678230
CR Number:   678230
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   12.5.4 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SH_LATCH request should be granted when nobody holding a latch on the OAM page



CR:678252
CR Number:   678252
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2011 Bundled Request
Description
sp_shmdumpconfig raises error 265 in subprocedure sp_shmdumpdisp when the memory dump would exceed 99999 MB in size. As a workaround, the procedure can be modified by changing the varchar size in the code line 'select @cdumpsize = (convert(varchar(5), @dumpsize) + " " + "MB")'



CR:678257
CR Number:   678257
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)
27 Jul 2012 Duplicate
Description
Prepared statements with String parameters and univarchar columns may not find results correctly
Workaround Description
 Changing the univarchar to a normal varchar or turning off the statement cache are possible workarounds.



CR:678258
CR Number:   678258
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B Refresh
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2011 Fixed
15 Aug 2011 Reservation Made
Description
Stacktrace could happen in CgpPop::_CgpInitProjection() for bushy tree plan or

right nested plan. Optimizer could choose such plans under allrows_dss optgoal

or under abstract plan forcing.
Workaround Description
 set bushy_space_search off



CR:678271
CR Number:   678271
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)
14 Nov 2011 Fixed
03 Apr 2012 Presently Not Targeted For Any Future Release Of This Product
Description
If a hostname exceeds 30 characters and the commonName on an SSL certificate also exceeds 30 characters, then the dataserver will not start this listener.
Workaround Description
 Use the host IP or a short alias hostname for the greater than 30 char. hostnames. I did not have a problem with the client and these entries but I did not test all possible clients.



CR:678278
CR Number:   678278
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2011 Fixed
04 Sep 2011 Fixed
Description
BCP into a range partitioned DOL table can result in excessive unused space.
Workaround Description
 Increasing the bcp batch size reduces the amount of unused space.



CR:678287
CR Number:   678287
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 Aug 2011 Fixed
04 Aug 2011 Fixed
22 Aug 2011 One-off Provided
Description
Memory allocated for the internal ASE server DES is not freed after a failed connection attempt

that results in error 7218. The entire memory pool runs out with an error 11223 after 1024 failed

connection attempts.



CR:678432
CR Number:   678432
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2011 Fixed
25 Aug 2011 Reservation Made
29 Aug 2011 Fixed
25 Jun 2012 Fixed
Description
If a target list for a view maps to more than one encrypted column in the

base table with the decrypt_default attribute, Adaptive Server may fail to

check the user's decrypt permission and incorrectly return the decrypt_default

value instead of the actual column value.



CR:678476
CR Number:   678476
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request (NFR) ASE 1502 ... make it possible to have a role with srid but role is unusable



customer does not want to turn the role off. customer essentially wants a way to have a role so that it uses an srid and exists on all machines. However the customer does not want it usable on all machines. the customer does not want people to be able to grant permissions to it. the customer just wants it there as a placeholder so that the customer can keep all their dataserver permissions in sync except down to the grant level.



CR:678527
CR Number:   678527
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2014 Fixed
31 Oct 2011 Presently Not Targeted For Any Future Release Of This Product
08 May 2014 Fixed
07 Jan 2015 One-off Provided
22 Jul 2014 Fixed
02 Jul 2014 Fixed
23 Jul 2014 Fixed
14 Jan 2015 Fixed
Description
In some long running ASE servers, an 8203 error - "Expected to find the descriptor for object <objid> in database <db_num> in <state> state." might be raised with crt_main in the stack trace while creating a temporary table.



There will be an information message "INFO: Total Object Ids in temporary database generated:<total id count>, LWPs generated: <LWP id count >" printed for every 100 million object ids generated
Workaround Description
 Purging statement cache periodically.



CR:678544
CR Number:   678544
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2011 Fixed
Description
Under certain circumstances, "transfer table ... for csv" can repeat the initial bytes of a transferred character column as the final bytes of that column.



CR:678586
CR Number:   678586
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Auditing process fails to wake up later even if enough locks have been freed up
Workaround Description
 Set 'suspend audit when device full' to zero.



CR:678605
CR Number:   678605
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
Optgoal to be printed in Query Plan from showplan.



CR:678633
CR Number:   678633
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
Invalid pointer param error when running showplan with compatability mode on
Workaround Description
 set compatability_mode off



CR:678639
CR Number:   678639
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2011 Fixed
04 Aug 2011 Fixed
29 Aug 2011 Fixed
02 Oct 2012 One-off Provided
13 Nov 2012 Fixed
Description
Closing a connection in ASE may cause high cpu usage.



CR:678736
CR Number:   678736
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2011 Fixed
18 Oct 2011 Presently Not Targeted For Any Future Release Of This Product
31 Oct 2011 Fixed
Description
Upgrading from 15.5 ESD to 15.7 release, if tables have partitions, ASE may generate seg fault involving functions s_readparseProcText() -> s_cpytxt().



CR:678763
CR Number:   678763
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2011 Fixed
21 Sep 2011 Reservation Made
23 Nov 2011 Fixed
22 Nov 2011 Fixed
22 Nov 2011 Reservation Made
Description
Updates on tables that have foreign key constraints may take exclusive row locks on non-qualifying rows.
Workaround Description
 Setting optcriteria to ase_current causes the plan to use a primary key clustered index and then only one row is scanned and only one is locked.



CR:678799
CR Number:   678799
Product Name:   ASE Management
Product Component:   Administration Agent Plugin
Status:   Closed
OS:   Generic
Original Version:   3.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2012 Fixed
Description
Feature request: add support in next available release of SCC to shrink repository db as it is possible with SQLanywhere dbunload utility.



CR:678812
CR Number:   678812
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2011 Fixed
17 Aug 2011 Fixed
18 Aug 2011 Fixed
Description
Sybmigrate hits a 247 error (Arithmetic overflow during explicit conversion of NUMERIC value to a INT field) on tables with more than 2.1 billion rows.
Workaround Description
 use bcp with views to grab smaller chunks of the table



CR:678975
CR Number:   678975
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2011 Fixed
29 Nov 2011 Fixed
18 Feb 2013 One-off Provided
06 May 2013 Fixed
Description
The message, "Invalid column length:... . Value must be between ... and ... at offset ... for 'all-pages' row with minimum length of ...", together with a stack trace which includes the modules 'LeSubst', 'LeScanOp::_LeOpNext' and 'execproc' may be reported in the error log when the 299 command line traceflag is used and under some circumstances a stored procedure which queries a user temporary table created outside is executed with different schemas for that table but the same plan is reused.
Workaround Description
 Use the same table schema for the outer table when calling

the affected stored procedure



OR



Do not use traceflag 299 for the affected stored procedure



OR



Create the stored procedure "with recompile"



CR:678990
CR Number:   678990
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2011 Not a Bug
Description
FR: create big_row_count() function that can handle more than 2bil rows
Workaround Description
 bcp can use views, but sybmigrate will just fail.



CR:679134
CR Number:   679134
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2011 Fixed
10 Aug 2011 Fixed
Description
Job Scheduler fails to execute job with "Multiple password found" error even when sp_addexternlogin is done only once for a user.



CR:679190
CR Number:   679190
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)
27 Jul 2011 Fixed
Description
(internal only) Correct a segmentation violation related

to the replication of row-level compressed data.



CR:679255
CR Number:   679255
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2011 Bundled Request
Description
In a partitioned cache, any attempt to drop a large buffer pool,

using the stored procedure sp_poolconfig, when the total number

of buffers in the pool is not evenly distributed amongst the

cachelets, will fail with the following 852 error:



"Command Failed: Invalid request to move 'X' buffers from the

'<pool-size>'K pool of the '<cachename>' cache to the '2048'K pool.

Source pool only contains 'Y' buffers. Retry the command

specifying fewer buffers."



CR:679267
CR Number:   679267
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2011 Fixed
25 Sep 2011 One-off Provided
10 Oct 2011 One-off Provided
29 Mar 2012 Fixed
11 Oct 2012 Fixed
Description
In rare circumstances, the error 8203 followed by a stack trace that includes the module des_create_inxact() could be raised when rolling back a transaction.



CR:679292
CR Number:   679292
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
Increase default unreserved log pages for instance/s joining an existing cluster which is running.



CR:679300
CR Number:   679300
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SVR4
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2011 Fixed
Description
Updating configuration parameter on ASE Cluster Edition gives error, "Notification failed for parameter 'esp execution priority'"



CR:679376
CR Number:   679376
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B Refresh
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2011 Fixed
11 Aug 2011 Reservation Made
Description
Job Scheduler Output contain line breaks at width 80 characters.



CR:679393
CR Number:   679393
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
Feature request to have str_replace function work on text and image datatype values.



CR:679561
CR Number:   679561
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)
18 Aug 2011 Not a Bug
29 Sep 2011 Fixed
Description
When max number replications paths is 1 and physical paths/bindings exist, print the following warning message on Rep Agent startup: Warning: the maximum number of replication paths is set to 1. All bindings for database ID '%d' will go to the default path despite the presence of %d physical paths.



CR:679609
CR Number:   679609
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)
23 Sep 2011 Fixed
29 Sep 2011 Fixed
02 May 2012 Fixed
03 May 2012 Fixed
11 May 2012 Fixed
21 May 2012 Fixed
Description
A 803 error may be raised together with some diagnostics information if recovery fault isolation is configured to page level and more than 12 pages have been isolated and added to the suspect page list.



CR:679797
CR Number:   679797
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2011 Fixed
03 Apr 2012 Fixed
Description
Under certain circumstances, running multiple instances of the third party monitoring tool asemon can lead to stack traces due to signal 11. The more instances that are running, the higher the chance of a re-occurrence of this issue.
Workaround Description
 No known workaround has been identified. Running fewer instances of the third-party montoring tool may help as this would reduce the time that the server is open to this vulnerability.



CR:679807
CR Number:   679807
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)
15 Aug 2011 Fixed
22 Aug 2011 One-off Provided
18 Sep 2012 Fixed
Description
For a SELECT statement in a stored procedure, if the table has more then one partition keys and not all the partition keys in the predicates are constants, neither compiler time partition elimination nor dynamic partition elimination occurs.
Workaround Description
 turn off deferred compilation with traceflag 7730 or sp_configure



CR:679820
CR Number:   679820
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
transactions usually abort when trying to access a table that is undergoing REORG REBUILD, but under traceflag 2792 they will instead just be blocked until the REORG completes. However, they do not show as being blocked processes in sp_who output.



CR:679835
CR Number:   679835
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2012 Fixed
Description
Error 3606 (Arithmetic overflow) occurs if configure more than 2G procedure cache size by sp_configure "procedure cache size",0,"2G", instead of specifying the number of 2k pages.
Workaround Description
 use page value instead :

sp_configure "procedure cache size", 1048576



CR:679960
CR Number:   679960
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2011 Fixed
26 Aug 2011 Fixed
26 Aug 2011 Fixed
12 Sep 2011 Fixed
16 Nov 2011 Not a Bug
15 Nov 2011 Fixed
Description
When a Replication Server issues a 'suspend' to a Rep Agent configured for 'multithread rep agent' the request causes the Rep Agent to perform a full shutdown rather than suspend.



CR:680073
CR Number:   680073
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX 5.1
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
Description
In rare circumstance, 501 error (timeslice) or sig 11 error will be reported along with stacktrace when inserting rows into

DOL table with placement index on AIX platform.



CR:680173
CR Number:   680173
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)
21 Sep 2011 Duplicate
Description
Signal 11 in stat_add_histogram



CR:680181
CR Number:   680181
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances, checkstorage may report the error 835, "Illegal attempt to change contents of buffer" followed by a stack trace that includes the module pchk_copy_page().



CR:680278
CR Number:   680278
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
A new feature request to implement a new dynamic server wide configuration parameter to control identity gap on identity columns.



CR:680360
CR Number:   680360
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2011 Presently Not Targeted For Any Future Release Of This Product
17 Aug 2011 Fixed
Description
In Adaptive Server version 15.5 ESD#3 or later, failure to move requested

memory between buffer pools using the sp_poolconfig system stored procedure,

may lead to error 2747: "Incorrect position specifier in format string of PRINT

command" followed by message: "Transaction count after EXECUTE indicates

that a COMMIT or ROLLBACK TRAN is missing. Previous count = X, Current

count = X+1".



CR:680362
CR Number:   680362
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
dynamic partition elimination should be modelled in the optimizer



CR:680424
CR Number:   680424
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2011 Fixed
15 Aug 2011 Fixed
Description
Sybase Central Editor used by ASE Plug-in does not have the help menu correctly configured.



CR:680469
CR Number:   680469
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #5 10 Oct 2011 Fixed
Description
Include SYSAM CR 659498 in a upcoming ASE 15.5 ESD Release.

"SySAM2: cpuinfo detects too many Itanium quad core chips"



CR:680590
CR Number:   680590
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Install Guide-Adaptive Server Enterprise
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2011 Added to user documentation
Description
clarify upgrade instructions for ASE 15.5



CR:680730
CR Number:   680730
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B Refresh
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2011 Fixed
29 Aug 2011 Fixed
Description
In rare circumstances, a spid in Adaptive Server may hang. A stack trace of the hanging spid will involve the modules mda_populate_monOpenObjectActivity() and des_get().



CR:680753
CR Number:   680753
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
The installdbccdb script raises several 4963 errors if run when the default lock scheme is not set to allpages. The messages can be ignored.



CR:680758
CR Number:   680758
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
Feature request to improve the performance of DBCC GAM by using worker processes to scan allocation pages in parallel.



CR:680759
CR Number:   680759
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2011 Fixed
15 Sep 2011 One-off Provided
07 Jan 2012 Fixed
25 Sep 2012 Fixed
25 Sep 2012 Fixed
Description
In rare circumstances, terminating an idle CIS connection may result in some form of memory corruption in the next connection attempt.



CR:680776
CR Number:   680776
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)
22 Sep 2011 Fixed
27 Sep 2011 One-off Provided
08 Nov 2011 Presently Not Targeted For Any Future Release Of This Product
30 Sep 2011 One-off Provided
13 Nov 2011 Fixed
14 Nov 2011 One-off Provided
30 Nov 2011 Fixed
06 Dec 2011 One-off Provided
09 Nov 2012 Fixed
Description
When using some devices (i.e. EQLOGIC) on Linux with multipathing, ASE cannot correctly locate the alternate paths to the raw devices for I/O fencing which may prevent ASE from starting up.



CR:680783
CR Number:   680783
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2011 Fixed
24 Apr 2012 Fixed
Description
A shared memory dump hangs if the ASE server encounters a signal 11 in the malloc system call.



CR:680789
CR Number:   680789
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2011 Presently Not Targeted For Any Future Release Of This Product
Description
After upgrade from 155ESD#3 to ESD#4, sybcluster is unable to start an instance.
Workaround Description
 remove the cluster from the plugins directory and "deploy plugin" with sybcluster.



CR:680885
CR Number:   680885
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
ASE CE to support "rolling upgrade" between releases.



CR:680891
CR Number:   680891
Product Name:   sybcluster
Product Component:   Cluster Plugin
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
User publication material for dropping instances from a cluster via sybcluster are incomplete when the instance has private devices/local user databases which must be handled in the "drop instance" handling.



CR:680899
CR Number:   680899
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
To Be Determined 11 Apr 2013 Fixed
Description
sybcluster should have a way to back off incomplete removal or alternately the CR 680891 should provide complete instructions for recovery from errors during "drop instance".



CR:680944
CR Number:   680944
Product Name:   SCC Web Framework
Product Component:   Alert
Status:   Closed
OS:   Generic
Original Version:   3.2.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2011 Fixed
06 Oct 2011 Fixed
10 Oct 2011 Fixed
13 Oct 2011 Fixed
25 Oct 2011 Fixed
02 Nov 2011 Fixed
Description
This resolution addresses issue where alerts do not refresh within the property sheet automatically. Customer needs to close and reopen window for refresh



CR:680992
CR Number:   680992
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)
25 Nov 2011 Added to user documentation
25 Nov 2011 Added to user documentation
Description
Coverletter for ASE CE releases need updating.



CR:681056
CR Number:   681056
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
The first run of DBCC CHECKSTORAGE following an upgrade to 15.x can take much longer to run than usual due to having to perform deferred upgrade work on allocation pages. As a workaround, run DBCC GAM(dbname,0,0,'check') prior to the first run of DBCC CHECKSTORAGE.
Workaround Description
 Run dbcc gam(dbname,0,0, 'check') prior to running checkstorage the first time after upgrade. For some reason, dbcc gam is far more efficent at doing the upgrade work then checkstorage.



CR:681087
CR Number:   681087
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2011 Fixed
Description
Problem stopping ASE as a windows service



CR:681107
CR Number:   681107
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2011 Fixed
30 Oct 2011 Fixed
27 Sep 2011 Fixed
Description
With using Sybase Central ASE-Plug-in, clicking database -> right click Property -> device tab may result in a Java error, "java.lang.Integer cannot be cast to java.lang.String" when the database has user-defined segment.



CR:681109
CR Number:   681109
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2011 Fixed
17 Nov 2011 Reservation Made
Description
If there are some NULL values in a TEXT column of a table, ASE may return " " instead of NULL when converting values in the TEXT column to CHAR data type.
Workaround Description
 1- using sp_chgattribute <table name >, "dealloc_first_txtpg", 1



1> sp_chgattribute t, "dealloc_first_txtpg", 1

2> go

'dealloc_first_txtpg' attribute of object 't' changed to 1.

(return status = 0)

1> update t set b = null where convert(varchar(10), b) is null

2>

3> go

(1 row affected)

1> select count(*) from t where convert(char(10), b) is null

2>

3> go



-----------

1



(1 row affected)

1>









2-

bcp out and bcp in the data in the table



CR:681213
CR Number:   681213
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2013 Insufficient priority to fix
Description
TDS error occurs after using set fmtonly
Workaround Description
 sp_configure 'send doneinproc tokens',1



CR:681347
CR Number:   681347
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2011 Fixed
25 Aug 2011 Fixed
Description
The number of page-level compressed rows in the DBCC CHECKTABLE message is zero on nt386 platform.



CR:681352
CR Number:   681352
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)
23 Aug 2011 Fixed
24 Aug 2011 Fixed
Description
Replication Agent starts while the number of replication paths configured is less than the number of replication paths stored in sysattributes.



CR:681382
CR Number:   681382
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)
12 Sep 2011 Workaround
Description
Allow non sa/oper users to examine non-upgraded archive databases



CR:681516
CR Number:   681516
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2011 Fixed
Description
Under Windows 2003 NT platform when ASE is booted using the COTS JVM version JRE-6.0.24

from Oracle/Sun, the JRE headless mode is not correctly supported therefore allowing methods

using that mode to be executed although they should not.





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

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。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------