提供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:714330
CR Number:   714330
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2012 Fixed
07 Dec 2012 Fixed
17 Dec 2012 Fixed
15 Mar 2013 Fixed
18 Dec 2012 Fixed
19 Mar 2013 Fixed
03 Apr 2013 Fixed
Description
Add functionality to the LOAD ... WITH LISTONLY=CREATE_SQL command to

include the various database options (applied with sp_dboption) and

attributes (applied with CREATE and ALTER DATABASE) of the source

database, in the generated SQL.



CR:714352
CR Number:   714352
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2012 Deferred
Description
BigDecimal value rounded to INT value when executing java through ASE JVM. This problem is not a bug but genuine implementation of the ASE Internal JDBC driver which originated from the 1.1 standard where specific functionality was introduced under JDBC 3.0. If this functionality is needed a feature request should be filed.
Workaround Description
 The customer could run his s/w under the external JDBC Driver which is current to date. It is understood that such is very inconvenient and not ideal with ASE_JAVA specific functionality.



CR:714355
CR Number:   714355
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)
22 Oct 2012 Fixed
Description
It is difficult to understand just what 'dbcc markprocs' in sp_downgrade is doing, so replace the statement in sp_downgrade with a more understandable SQL update.



CR:714466
CR Number:   714466
Product Name:   Adaptive Server Generic Docs
Product Component:   Transact-SQL Users Guide
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2014 Added to user documentation
Description
The TSQL Guide incorrectly states about shared temporary tables that "The table exists until the current session ends or until its owner drops it using drop table." Shared temporary tables exist until explicitly dropped or the tempdb is rebooted.



CR:714478
CR Number:   714478
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2012 Fixed
Description
In some rare case, if a plan has a Hash operator in it, it could cause stacktrace in LeHashInputSet::releaseExtents(), LeHashOP::LeOpSaveIOStates() when a stored procedure or a cached statement is executed multiple times and its plan has LeHash operator.
Workaround Description
 set group_hashing off --this is not always going to work, only in some circumstances



--or



set compatibility_mode on



CR:714612
CR Number:   714612
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2012 Fixed
14 Nov 2012 Fixed
19 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
20 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
20 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
Description
A 2846 error, "SQL function 'dbo.sp_<function name>' not found. Specify

owner.objectname or use sp_help to ..." may be incorrectly reported when

a SQL user defined function created in sybsystemprocs database with

a name prefixed by "sp_" is invoked from a database while a open

transaction in the same database is creating a stored procedure, view,

trigger, rule or default.



CR:714638
CR Number:   714638
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2012 Fixed
Description
monEngine connections column is wrong for kernel mode threaded.



CR:714641
CR Number:   714641
Product Name:   Adaptive Server Generic Docs
Product Component:   Monitoring Tables Diagram Poster
Status:   Open
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
monEngine column connections is not describe correctly.



CR:714670
CR Number:   714670
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2 Refresh #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2012 Fixed
27 Jul 2012 Fixed
Description
sp_downgrade_esd does not report tables which are configured for in-row LOB compression.



CR:714773
CR Number:   714773
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1 Refresh #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2012 Fixed
13 Aug 2012 Fixed
13 Aug 2012 Fixed
14 Aug 2012 Fixed
Description
In a multi-engine ASE running on the Unix platform, the tracefile for the spid (created using 'set tracefile <path> for <spid>') is truncated in pre 15.7, while the tracefile is not populated post 15.7 in process kernel mode, when the spid being traced is affiniated to an engine other than the one which created the tracefile initially (This can happen if the engine that created the tracefile is offline).
Workaround Description
 If possible, ensure the spid in question executed something on each engine in turn before

tracing the required sql. This can be done with sp_engine online\offline.



Or:-



Run threaded mode (which is default anyway) if on 15.7.



Or:-



Run a single engine.



CR:714798
CR Number:   714798
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#2 25 Aug 2012 Fixed
Description
On AIX platform, ASE Cluster Edition may fail to start if logical volumes are used and I/O fencing is enabled.



CR:714806
CR Number:   714806
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2012 Fixed
Description
When ASE is shut down using the 'nowait' option and while data is loaded using fast bulk-copy into a table that is created with the 'for load' attribute, on ASE restart some data may be lost.



CR:714830
CR Number:   714830
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2012 Workaround
Description
When downgrade from 15.7ESD#2 CE to 15.7ESD#1 or GA CE, after downgrade_esd completed and reboot

the 1st node with the lower version server, when booting the 2nd node, ASE will hit SIGSEGV at 1st

node and hang the 2nd node.
Workaround Description
 There is two methods to workaround this downgrade_esd issue:



1.

After sp_downgrade_esd complete for all necessary dbs,



1> sp_downgrade_esd master, 'ESD1'

2> go

Reverting database 'master' to 'ESD1'.

Database 'master' is now suitable for use by ESD1.

(return status = 0)



1> delete master..sysconfigures where config in(563, 575)

2> go

(2 rows affected)



Then shutdown the server, continue the downgrade steps,

replace the release with the lower version and boot the lower

version server.



2.

After sp_downgrade_esd complete for all necessary dbs, then reboot

only one node of older server, then before bring up other nodes,

run installmaster first.



CR:715048
CR Number:   715048
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2012 Fixed
02 Aug 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Complex queries with predicates having aggregates and subqueries could lead to wrong results.



CR:715086
CR Number:   715086
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2012 Fixed
Description
When shutdown cluster is issued from one instance, busy user tasks running on other instances may be immediately terminated.



CR:715094
CR Number:   715094
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1 Refresh #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2012 Fixed
Description
A 716 error, "Unable to allocate memory of size %d bytes from the '%S_MSG' pool" may be reported when querying a partitioned view including compressed tables many times.



CR:715183
CR Number:   715183
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2012 Fixed
26 Jul 2012 Fixed
26 Jul 2012 Reservation Made
Description
The replication of a stored procedure for which a 'request function replication definition' has been created fails with Replication Server error 5157 indicating that the transaction owner's password is missing.



CR:715203
CR Number:   715203
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)
08 Jan 2014 Fixed
15.7 SP121 09 Jan 2014 Fixed
09 Jan 2014 Fixed
15.7 SP61 13 Jan 2014 Fixed
Description
DBCC CHECKSTORAGE does not detect LOB compression flag inconsistencies in the TIPSA. With DBCC

CHECKTABLE and DBCC CHECKDB these types of inconsistencies were already being reported with message 15960.



CR:715228
CR Number:   715228
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)
13 Nov 2012 Fixed
Description
Wrong result could happen when referencing a non-correlated scalar aggregate view at the inner side of an OUTER JOIN.
Workaround Description
 1. set compatibility_mode on

2. Using an inner join

3. using a temp table to materialize the outer view



CR:715234
CR Number:   715234
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2012 Fixed
Description
On AIX, the monThread MDA table incorrectly indicates that the Listener thread is consuming 100% CPU.



CR:715240
CR Number:   715240
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2012 Fixed
Description
ASE Cluster Edition allows user to create thread pool when "max online engines" is not sufficient.



CR:715312
CR Number:   715312
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2014 Fixed
12 Mar 2014 Fixed
20 Mar 2014 Fixed
05 Jul 2014 Fixed
Description
Use of online utilities like 'reorg rebuild with online' might lead to incorrect used/unused counts in the OAM for the table. This is reflected by a later 'dbcc checkalloc' on the table reporting error messages 7949 and 7940.



CR:715398
CR Number:   715398
Product Name:   Adaptive Server Enterprise
Product Component:   coverletter
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
This PC-Client EBF is based on SDK 15.7 ESD#4. A list of changes in that SDK 15.7 ESD#4 is available at http://download.sybase.com/swr/15934/EBF20102_Buglist.txt



CR:715670
CR Number:   715670
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)
13 Aug 2012 Fixed
27 Aug 2012 One-off Provided
Description
CS_IODESC.name has view name instead of table name for LOB column.



CR:715785
CR Number:   715785
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2012 Fixed
Description
Signal 11 in set_password or sync_password



CR:715798
CR Number:   715798
Product Name:   Adaptive Server Enterprise
Product Component:   mscs_ha
Status:   Open
OS:   Microsoft Windows NT
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When trying to launch SybCpnSrvSetup.msc results in 'bad file format' error reported with a stacktrace and subsequent unloading of the dll.
Workaround Description
 Use command line utility sp_companion



CR:715835
CR Number:   715835
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2012 Fixed
Description
Modify auditinit utility to create log file with 600 permission, instead of user's umask.



CR:715967
CR Number:   715967
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2012 Fixed
Description
auditinit utility requires user to enter non-null sa password for existing ASE.



CR:716047
CR Number:   716047
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 Aug 2012 Duplicate
Description
Shared memory dump attempt fails with an infected with 11 in function shm_mergedump



CR:716054
CR Number:   716054
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Linux
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2013 Added to user documentation
Description
Linux Installation Guide has outdated RHEL raw device configuration information



CR:716059
CR Number:   716059
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
tables referenced in a procedure only in LOCK TABLE commands are not reflected in sysdepends or sp_depends output



CR:716165
CR Number:   716165
Product Name:   ASE Management
Product Component:   Monitoring Data Collector
Status:   Closed
OS:   Generic
Original Version:   3.2.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2012 Fixed
Description
Arithmetic overflow may occur causing SCC to stop monitoring the ASE.



CR:716166
CR Number:   716166
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2012 Fixed
Description
A 12324 error, "In database 'dbname' the server failed to open required

table 'syspartitions'. Please contact Sybase Technical Support." may be

reported during the execution of either LOAD DATABASE or USE <database>

commands when ASE is requested to calculate threshold information by

performing OAM scans.



CR:716262
CR Number:   716262
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2012 Fixed
02 Jan 2014 Added to user documentation
Description
On HPIA64 platforms, ASE may report error 16747, "The 'enable hp posix async i/o' configuration option is only available on the HPUX platform. This option is not valid on the current platform." if 'number of disk tasks' is set as larger than 1 when 'enable hp posix async i/o' is enabled.



CR:716284
CR Number:   716284
Product Name:   Adaptive Server Enterprise
Product Component:   asecfg
Status:   Closed
OS:   Solaris
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2012 Fixed
Description
asecfg core dumps when started on Solaris x64.
Workaround Description
 User can run dsedit, sqlloc, sqlupgrade, and srvbuild directly.



CR:716349
CR Number:   716349
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Windows 2008
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2012 Fixed
Description
In some cases, ONLINE DATABASE or DBCC CHECKDB executed on a database with large number of compressed objects might fail with error 716 (Unable to allocate memory from the compression info memory pool), when the 'compression info pool size' configuration option is set too low (e.g. the default value of 4096).



CR:716457
CR Number:   716457
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2012 Fixed
28 Dec 2012 Fixed
21 Dec 2012 Fixed
27 Dec 2012 Fixed
Description
The ASE Backup Server process has a memory leak when dumping and loading databases, which causes it to grow until it exceeds the memory limit.
Workaround Description
 Possibly raise the user memory soft limit or recycle the backupserver frequently.



CR:716567
CR Number:   716567
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2012 Fixed
21 Sep 2012 Fixed
27 May 2014 Duplicate
Description
A query having MDA table monProcessObject caused signal 11 in routine mda__process_sdes() with an invalid SDES in a cursor. This CR seems a concurrency issue since another session was doing 'OPEN CURSOR' and the related internal cursor structures might be changing.

May need to add more validation code in the related routine. A possible workaround is not to query monProcessObject.



CR:716609
CR Number:   716609
Product Name:   SCC Web Framework
Product Component:   GUI
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2012 Fixed
13 Sep 2012 Fixed
Description
In SCC 3.2.7 build 4819, in the Import Resources wizard, the Confirmation page and the Import Results page are empty and does not show the imported resources. However, the resources do get imported properly.



CR:716618
CR Number:   716618
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2012 Fixed
Description
When use TF7751 and TF7752, sometimes it could cause stacktrace during plan printing.



CR:716642
CR Number:   716642
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   HP-UNIX
Original Version:   15.7 ESD#1 Ref #2 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2012 Duplicate
Description
If replication is set for master device, then job scheduler will fail to boot with following message in the ASE error log file :

"background task error 18388: You must be in the master database in order to run 'sp_locklogin'."



CR:716645
CR Number:   716645
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2012 Fixed
01 Oct 2012 Consult Complete
15 Oct 2012 Reservation Made
03 Nov 2012 Fixed
16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
19 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
19 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
27 Nov 2012 Fixed
Description
During an UPDATE command on a table that has in-row LOB columns defined,

ASE may move some of these columns from in-row to off-row or vice-versa

if the size of a datarow exceeds configured limits. When such a table has

a datarow with an off-row LOB column that is not explicitly updated, ASE

may not log this column data correctly. This will result in replication

failing if this column is marked as always_replicate.
Workaround Description
 The work around for this problem is to mark LOB columns as "replicate_if_changed"

so that only the changed column is replicated.



CR:716654
CR Number:   716654
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2012 One-off Provided
09 Oct 2012 One-off Provided
16 Dec 2013 Port Not Needed
16 Dec 2013 Port Not Needed
Description
Instrumentation: ASE reports a timeslice error with ksnetctlrPostWrite and ksmaskspost on the stack. Shared memory dump for the error shows a circular "Cancel Queue" leading to the timeslice error. This is instrumentation to capture diagnostic information upon any update to controller's cancel queue.
Workaround Description
 sp_configure "kernel mode", 0, threaded



CR:716663
CR Number:   716663
Product Name:   SCC Web Framework
Product Component:   Other
Status:   Closed
OS:   RH Linux
Original Version:   3.2.7 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2012 Fixed
13 Sep 2012 Fixed
Description
This resolution fixes an issue in the Collection Job History tab where it does not update correctly when schedule selected



CR:716679
CR Number:   716679
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2012 Fixed
Description
When network password encryption is used and sp_passwordpolicy option 'unique keypair per session' is set to 0, client connections will fail with error message:

Sybase CSI Error Message: Error generating asymmetric key. Root error: error:0906D06C:PEM routines:PEM_read_bio:no start line

CT-LIBRARY error:

ct_connect(): protocol specific layer: internal Client Library error: There is a tds login error. The installed encryption handler returned a status that was not CS_SUCCEED.



CR:716720
CR Number:   716720
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2012 Fixed
Description
Remove error # 12061 when a query is executed on an MDA Table that contains localized message text when the client is configured to use a language into which the MDA Table messages have not been translated. Specifically, if the client language is set to 'german' error 12061 will no longer occur when a query is executed on the monWaitEventInfo table.



CR:716729
CR Number:   716729
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Windows
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jan 2013 Added to user documentation
Description
Document no blanks are allowed in Install Path for Windows platform



CR:716736
CR Number:   716736
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)
03 Dec 2012 Duplicate
Description
Error: 8210, Severity: 20, State: 2 + stack trace crt_work+0x148() run_crtable+0x294() LeWkTbl::crtWkTbl(int,short,int)+0x160() LeStoreOp::_LeOpAcquire(ExeCtxt&)+0x2a4()



CR:716798
CR Number:   716798
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2012 Fixed
Description
select involving aggregates and having predicated privileges defined at column level on the table could result in wrong results.



CR:716831
CR Number:   716831
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guides - All Platforms
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2013 Added to user documentation
Description
Add a section to the install guides that explains Optional Features and how to install them with SYSAM 2.0



CR:716870
CR Number:   716870
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)
19 Oct 2012 Fixed
11 Oct 2012 Fixed
Description
Adaptive Server may not kill a task that is marked for termination, which is reporting shortage of buffers in buffer pool like "cache is configured too small for current demands".



CR:716957
CR Number:   716957
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)
02 Jun 2014 Presently Not Targeted For Any Future Release Of This Product
06 Jun 2014 Fixed
Description
In rare circumstances, a 614 error, "Adaptive Server accessed a row that has an illegal length of <value> while in data base <database>" may be reported when running DBCC FIX_TEXT on a data-only-locked table.



CR:716960
CR Number:   716960
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2012 Fixed
Description
ASE fails to boot on Windows Server 2012 with a stacktrace containing kiprint_os_version() on the stack.



CR:716981
CR Number:   716981
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.7 ESD#1 Refresh #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2012 Fixed
Description
When the configuration option 'number of network tasks' is set to greater than 1, ASE running on HP-UX may hit infected with signal 11 (SIGSEGV) in module kstcpnetctlrCancelRequests.
Workaround Description
 Does not occur with 'number of network tasks' = 1 , so reset it back to to 1



CR:717026
CR Number:   717026
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2013 Fixed
Description
Improve spinlock efficiency on Solaris SPARC platform.



CR:717050
CR Number:   717050
Product Name:   Adaptive Server Enterprise
Product Component:   sybinstall
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2012 Fixed
12 Oct 2012 Fixed
Description
A 3502 error, "DUMP TRANSACTION requires a dump configuration name because the configuration option 'enforce dump configuration' is enabled." may be reported during the installation of an ASE ESD release on top of 15.7 ESD #1 version while 'instmsgs.ebf' is installed and ASE uses a dump configuration. Alternatively when ASE uses a dump configuration the execution of "DUMP TRANSACTION <database> WITH NO_LOG" will fail.
Workaround Description
 Disable while loading instmsgs.ebf the configuration option 'enforce dump configuration'.



CR:717078
CR Number:   717078
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a ROW_NUMBER function to return the number of a row in a given ordering.



CR:717079
CR Number:   717079
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2012 Fixed
26 Sep 2012 Fixed
27 Sep 2012 Fixed
12 Nov 2012 Fixed
12 Nov 2012 Fixed
Description
The ASE COTS JavaVM version is updated to version JRE 6 update 33 for each supported platform in the sybpcidb database.



CR:717212
CR Number:   717212
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2 Refresh #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2012 Fixed
Description
An infected with 11 (SIGSEGV) stacktrace in statinit soblddolpages occurs when trying to ALTER TABLE to add a column to a table with indexes.



CR:717224
CR Number:   717224
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2012 Fixed
Description
Execution of sp_sysmon by a user other then "sa" can result in error 4066 when "sa" login is locked.



CR:717232
CR Number:   717232
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2012 Fixed
Description
When using update statistics with hashing there may be a stacktrace when the number of unique values in the column is greater than 65535.



CR:717258
CR Number:   717258
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Request to be able to create key copies for login_association when

logins are externally authenticated using Kerberos\LDAP



CR:717371
CR Number:   717371
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2 Refresh #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2012 Bundled Request
Description
Feature request to allow built-in access to the java.util.concurrent class library.
Workaround Description
 Manually extract the classes from the core.jar file from your JVM, package them as an uncompressed jar file, and install the resulting jar file.



CR:717481
CR Number:   717481
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2012 Fixed
Description
If with hashing is used, and the column has more then 65535 unique values then there is a possibility that the sarg density and unique count for the column are under-estimated.



CR:717491
CR Number:   717491
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2012 Fixed
05 Sep 2012 Fixed
Description
Importing data in DBISQL by selecting Data -> Import from a database menu option, fails with password length issue JZ002



CR:717492
CR Number:   717492
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ICR: 1837 error for IMDB, root cause from CSMD
Workaround Description
 -T1804



CR:717496
CR Number:   717496
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2012 Fixed
21 Sep 2012 Fixed
Description
ASE returns error message (Msg 16341, Level 19, State 1) when split a range partitioned table when partititoning filed is a VARCHAR, DATETIME fields.



CR:717574
CR Number:   717574
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2012 Fixed
Description
Event ID 178's description is updated, it is wait time for client connections.



CR:717610
CR Number:   717610
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2012 Fixed
Description
when using hash-based statistic gathering, the default column width should be used for fixed length columns instead of being computed.



CR:717627
CR Number:   717627
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2012 Fixed
Description
sp_showoptstats would always display 4.00 as the default average width for any fixed length column



CR:717662
CR Number:   717662
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2012 Fixed
18 Sep 2012 Fixed
Description
When using fast logged bcp to insert data into a table that is marked for replication and

has TEXT/IMAGE/UNITEXT columns, some TEXT/IMAGE/UNITEXT data may not be successfully replicated.



CR:717673
CR Number:   717673
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2012 Duplicate
Description
Allow delimited identifiers to be 255 bytes long; allow double right bracket as an escape for right bracket in bracketed identifiers; disallow embedded null bytes in identifiers.



CR:717740
CR Number:   717740
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2012 Fixed
06 Sep 2012 Fixed
17 Sep 2012 Fixed
17 Sep 2012 Fixed
20 Sep 2012 Fixed
24 Sep 2012 Fixed
Description
Bcp-in was failing for a table with columns more than 128 column and having one of them as text column.
Workaround Description
 modify text column with in-row lob option.



alter table s_ec305 modify inrtgrp_tag_cont text in row(300), req_epr_tag_cont text in row (300)

go



CR:717811
CR Number:   717811
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2012 Bundled Request
30 Aug 2013 Added to user documentation
Description
Implement "Copy Connection String" feature in DBISQL 12.0.1 Connect Dialog for ASE.



CR:717828
CR Number:   717828
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2012 Fixed
06 Nov 2012 DEFER
26 Dec 2012 Fixed
Description
A 9254 error, "Could not locate schema version for object id '0' in the transaction log."

followed by a 9204 error, "Could not locate schema for object with id = (0), current marker

(0, 0)." may be reported in the error log when inserting or updating an in-row LOB datum

and the multipath distribution model is enabled. This will result in the Rep Agent

Thread shutting down itself.
Workaround Description
 Either not use MRP feature or IRL feature.



CR:717861
CR Number:   717861
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE should report license message when setting minimally logged operations on tempdbs without a valid IMDB license.



CR:717871
CR Number:   717871
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)
25 Sep 2012 Third Party Problem
Description
On Solaris 10 updates earlier than Update 11 (Generic_147441-23), ASE running in kernel threaded mode might experience a temporary time shift from local time to GMT. For example, time value of 10:00 might change to 18:00 for a short period. To resolve, upgrade Solaris 10 OS to Update 11 or later.



CR:717879
CR Number:   717879
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2012 Fixed
05 Sep 2012 Fixed
26 Sep 2012 One-off Provided
Description
When a set role command is executed within a procedure or SQLUDF, it takes effect during the context of the procedure or UDF only.
Workaround Description
 None really



CR:717910
CR Number:   717910
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows XP
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2012 Fixed
08 Oct 2012 Fixed
Description
When the built-in function GETREPDEFMODE() is called in a query involving a table,

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

the modules 'get_repdef_mode', 'open_user_table' and 'sdes_hookup'.



CR:717976
CR Number:   717976
Product Name:   SCC Web Framework
Product Component:   GUI
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2012 Fixed
13 Sep 2012 Fixed
Description
In SCC 3.2.7 ESD1, in the Heatchart view, for a KPI is not updating properly according to the set thresholds when there is an overlap in the threshold boundaries.



CR:717984
CR Number:   717984
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
implement implicit conversions char, varchar to numeric, decimal
Workaround Description
 // use convert function



INSERT INTO t11750132 (c1) VALUES (convert(numeric(18,8), "12.34"))

go



CR:718044
CR Number:   718044
Product Name:   SCC Web Framework
Product Component:   Repository
Status:   Closed
OS:   Generic
Original Version:   3.2.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2012 Fixed
05 Sep 2012 Fixed
05 Sep 2012 Fixed
Description
This fixes an issue where duplicate managed object hierarchy records can be created



CR:718119
CR Number:   718119
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Open
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add support for non-class resources in JAR files within ASE
Workaround Description
 Non



CR:718133
CR Number:   718133
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2012 Fixed
22 Oct 2012 Reservation Made
22 Oct 2012 Fixed
Description
If more than one process tries to materialize a deferred table, they all will be stuck in a deadlock and only one process would succeed causing all others to rollback.



CR:718141
CR Number:   718141
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)
04 Jul 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
wrong row count when creating an index with parallel and "with statistics using 0 values"
Workaround Description
 do not use with statistics using 0 values



or



not run in parallel.



CR:718191
CR Number:   718191
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2012 Fixed
14 Sep 2012 Fixed
14 Sep 2012 Fixed
Description
Error 2812 or 11214 is raised when accessing an MDA table specifically mapped as a proxy table.



CR:718203
CR Number:   718203
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
When stopping Job Scheduler using the undocumented sp_controljob procedure it may be

possible under rare circumstances for a stack trace to appear in the error log

in function upsleepgeneric() with js_wakeup() also appearing. The server will necessarily shutdown as this path holds spinlocks.



CR:718206
CR Number:   718206
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#1 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2012 Fixed
19 Sep 2012 Fixed
Description
If the master database has a secondary truncation point set during an upgrade from 15.0.1 to 15.7,

an error 950(Database 'master' is currently offline. Please wait and try your command again later) will

be raised during the upgrade.
Workaround Description
 The workaround is not simple and not acceptable.

The customer should run preupgrade to detect the problem first, rather than get into this scenario.



Customers may see the problem if

1) pre-upgrade version is 15.0.1

(If pre-upgrade release = 12.5.x, an error may be reported during preupgrade or upgrade and will not get into this scenario with the fix of CR 574227).

2) leave secondary truncation point on before apply 15.7 binary



TSE Christine Zhong provided the following steps for the customer to rebuild master on pre-upgrade release 1501, load the good 1501 version of master database dump, then ignore secondary truncation point via dbcc settrunc(ltm,ignore), then upgrade to 15.7 ESD1 again:



---------

1) - Build a new master using the OLD dataserver binary. Here is the example

comand:



In your old environment,



dataserver -d your_master_device -w master



The above command will only rebuild the master database to its default stage.

you will see lots messages like the following

and the ASE shutdown itself down at the end.



.....

00:00000:00001:2012/09/01 17:21:04.16 server The logical pagesize of the server

is 2 Kb.

00:00000:00001:2012/09/01 17:21:04.16 server Database 'master' does not exist.

ASE will create it.

00:00000:00001:2012/09/01 17:21:04.16 server Database 'master': beginning

upgrade step [ID 1]: Initialize disk and create empty allocation units on

master device.

00:00000:00001:2012/09/01 17:21:04.16 server Database 'master': beginning

upgrade step [ID 2]: Bootstrap basic system catalogs in database.

00:00000:00001:2012/09/01 17:21:04.17 server Database 'master': beginning

upgrade step [ID 6]: creating index (table syspartitions, index

ncsyspartitions)

....



2) - Restart your ASE in the OLD environment using -m and -T3608. Very important

to use the flags.



3) - Start your backupserver and load the master dump.

The server will shutdown at the end of the load.



4) - Restart your ASE in the OLD environment using -m and -T3608 and remove the

truncation point.

dbcc gettrunc /* just to verify that you have it set */

go

dbcc settrunc(ltm,ignore)

go

shutdown

go



5) Now you can upgrade to ASE 15.7. When I upgrade to 15.7, I restart the ASE

using -m and -T3608.

I can see the ASE upgrade the master without any issue. Then I shutdown the ASE

and restart it normally.



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



User document on rebuild master:

http://manuals.sybase.com/onlinebooks/group-as/asg1251e/svrtsg/@Generic__BookView?DwebQuery=rebuild+master&DwebSearchAll=1



CR:718253
CR Number:   718253
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2014 Fixed
Description
Utilities like haisql, HAase agent or MSCS HA agent, connects to the ASE server, however not using login/password encryption on the network.



When configuration parameter "net password encryption reqd" is set to 1/2, the utilities like haisql, HAase Agent or MSCS HA agent will fail to login to server with following errors :



Msg 1640, Level 16, State 2:

Adaptive Server requires encryption of the login password on the network.

Msg 4002, Level 14, State 1:

Login failed.

CT-LIBRARY error:

ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.



CR:718259
CR Number:   718259
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Running sp_monitor will lead to an error 2812 raised via sp_monitor_server.



1> sp_monitor

2> go

Msg 2812, Level 16, State 11:

Server '<server>', Procedure 'sp_monitor_server', Line 57:

Stored procedure '' not found. Specify owner.objectname or use sp_help to check

whether the object exists (sp_help may produce lots of output).
Workaround Description
 Re-create sp_monitor_server having removed these lines:-



55 select @whoami = object_name(@@procid, db_id('sybsystemprocs'))

56

57 exec @rtnstatus = @monprocname @whoami

58

59 if (@rtnstatus = 1)

60 return(1)



CR:718261
CR Number:   718261
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2012 Fixed
Description
Running sp_monitor will lead to an error 2812 raised via sp_monitor_server.
Workaround Description
 Re-create sp_monitor_server having removed these lines:-



55 select @whoami = object_name(@@procid, db_id('sybsystemprocs'))

56

57 exec @rtnstatus = @monprocname @whoami

58

59 if (@rtnstatus = 1)

60 return(1)



CR:718284
CR Number:   718284
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2012 Fixed
Description
An 823 error, "I/O error detected during wait for BUF=<value> ... cid=0

('default data cache') ... " may be reported when an ASE 12.5.4 database

dump is loaded into an in-memory database and while ONLINE DATABASE is

run. This will result in a database upgrade failure.



CR:718398
CR Number:   718398
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2014 Fixed
27 Mar 2014 Reservation Made
06 May 2014 Work as design
Description
Update statistics options are 'sticky', meaning previous values which are

explicitly set will continue to be used for future update statistics and

create index commands on the same table if these options are not specified.

These sticky options are:

step count (using step values);

histogram_tuning_factor;

sampling;

hashing, partial_hashing, no_hashing.



This CR implements a configuration parameter "enable sticky statistics"

to control statistics stickiness server wide. The default for

"enable sticky statistics" is 1, which matches existing sticky statistics

behavior. To turn off sticky statistics, use:

sp_configure enable sticky statistics , 0



CR:718440
CR Number:   718440
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2012 Fixed
Description
When executing sp_dboption without any parameters to list database options, the output is hard to read due to a lot of empty spaces.



CR:718466
CR Number:   718466
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2012 Fixed
Description
A 1508 error, "Create index aborted on duplicate rows. Primary key is 'spinlock_p, -32768'" may be reported when running sp_sysmon and sp_sysmon runs very slowly.
Workaround Description
 Edit the definition of the sp_sysmon stored procedure in the sybsystemprocs database and add the following qualification to the where clause that populates the #tempmonitors table: "where field_name not in ('fglockspins','physlockspins')". This will eliminate the rows that contain many of the spinlock monitors but will also reduce the size of the #tempmonitors table and eliminate the cause of the duplicate key values. NOTE: Because this change eliminates spinlock monitor counters, the sections of this sp_sysmon report reporting spinlock usage will not be accurate.



CR:718500
CR Number:   718500
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2013 Insufficient priority to fix
Description
Illegal outer-join request gives infected 11 in oj_syboj_ojdepends_maps instead of an error.



CR:718587
CR Number:   718587
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2012 Fixed
Description
A task deleting rows from a DOL table in an in-memory database might wait indefinitely for an EX_LATCH by holding the SH_LATCH on the data page.



CR:718606
CR Number:   718606
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Enhance 696 error reporting to facilitate investigation



CR:718628
CR Number:   718628
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1 Refresh #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2012 Fixed
10 Sep 2012 Fixed
Description
Signal 8 can occur when the "update statistics hashing" configuration parameter is used



CR:718637
CR Number:   718637
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)
10 Oct 2012 Fixed
23 Oct 2012 Consult Complete
09 Nov 2012 Fixed
Description
Parallel queries with the following query plan scenario MIGHT fail with a "Command has been aborted" message and no other warnings/errors reported in the error log: (1) There is a merge-join op where one of its child trees contains a replication exchange operator. (2) There is no "draining" operator (e.g. sort operator) between the merge-join and the exchange operator. (3) The merge-join's other child drains its input stream before the child with the replication exchange does.





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

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