提供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:555255
CR Number:   555255
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2011 Fixed
31 Mar 2011 One-off Provided
10 Aug 2011 DEFER
18 Sep 2012 One-off Provided
11 Sep 2012 Fixed
Description
When a query contains a negative integer specified such as -(90), and when literal parameterization is on, parser or normalization syntax error might be raised when the query is cached and has to be

recompiled during subsequent executions.
Workaround Description
 set literal_autoparam off

go

run the query



Or change the literal -(90) to -90.



CR:555400
CR Number:   555400
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2009 Fixed
Description
Previously executing stored procedure such as "sp_configure 'object'" in DBISQL would receive an error without the results. This has been fixed so that the error is correctly displayed, followed by the results.



CR:555521
CR Number:   555521
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2009 Fixed
Description
sp_configure 'current audit table', 0, 'with trucate' raises error 7625 and 5850.



CR:555545
CR Number:   555545
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2009 Fixed
Description
An empty string '' or "" passed as the second parameter to sp_ldapadmin 'set_access_acct'

causes an assertion failure.



CR:555564
CR Number:   555564
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer request for a new database option/status which could be a mix of database in "read only" mode and database in "single user" mode.



Customer would like to get his database in "read only" mode, but having his maintenance user (Customer is using replication) still be allowed to apply commands.

Customer would also be able to dump his database (as maintenance user could fill up syslogs)



To summarize: Customer request for a new database status, where all user may have a read only access to data, and where only user with "replication_role" and/or "oper_role" (needed for dump/load command) or DBO user will have normal access permission.



CR:555573
CR Number:   555573
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for auditing of CREATE and DROP TSQL user defined functions



CR:555608
CR Number:   555608
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2009 Fixed
Description
Same query on two versions, 15.0.1 picks a different plan, and finishes in 1200 ms.

15.0.2 finishes in 386400 ms. This is plan related, because we ran the 15.0.1 AP in the 15.0.2 server, and it finished in 1100 ms.



CR:555610
CR Number:   555610
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2009 Fixed
11 Feb 2009 Fixed
23 Jan 2009 Fixed
26 Jan 2009 Fixed
11 Feb 2009 Fixed
Description
A syntax error is displayed when the instmstr script is executed.
Workaround Description
 Edit the instmstr script and remove one of the "go" from that line.



CR:555709
CR Number:   555709
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2009 Bundled Request
12 Jan 2009 Fixed
Description
"Under certain circumstances, Adaptive Server Cluster Edition could hit a stacktrace involving routines lock__ins_logical() due to signal 11."



CR:555759
CR Number:   555759
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE can favour merge joins incorrectly over n-ary joins.



CR:555773
CR Number:   555773
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2009 Fixed
02 Feb 2009 Fixed
Description
The execution of DBCC CHECKALLOC with the FIX option may delete oam entries

that have zero used/unused page counts. When the oam deleted entry is the

last oam entry on the current oam page, ASE may mistakenly terminate this

command execution without completing the oam cleanup.



CR:555798
CR Number:   555798
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2009 Fixed
20 Feb 2009 Fixed
Description
A select statement which will return results against a local table will return error 403 against a proxy table. 125x version returned the same results for local and remote tables. The select clause evaluates to "where (null is null)" in the 15x version.
Workaround Description
 None.



CR:555826
CR Number:   555826
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Message at ASE boot time when master is marked for replication
Workaround Description
 One could query syslogshold, if one could get to the master database, to get this equivalent information.



CR:555948
CR Number:   555948
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2009 Fixed
23 Mar 2009 Fixed
25 Mar 2009 Reservation Made
24 Mar 2009 Fixed
09 Apr 2009 Fixed
01 Apr 2009 Fixed
Description
New MDA tables and sysmon enhancements for Cluster Lock Manager monitoring



CR:555955
CR Number:   555955
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2009 Fixed
Description
EFTS error 20137 occurs when an '1=1' clause is sent to EFTS from ASE.



CR:556015
CR Number:   556015
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)
15.0.3 ESD#3 08 Oct 2009 Fixed
Description
VCS HA cannot failover to companion server due to weak regular expression check in "sybhautil.pm".



CR:556118
CR Number:   556118
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2009 Fixed
19 Jan 2009 Fixed
20 Jun 2010 EOL'd version. Not to be Fixed.
Description
The admin access account password for secondary LDAP server set through sp_ldapadmin set_secondary_access_acct is stored in cleartext in audit logs when cmdtext auditing is turned on.



CR:556134
CR Number:   556134
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2009 Fixed
14 Apr 2009 Fixed
Description
The index checking of DBCC CHECKTABLE doesn't check the first row of every

non-leaf page, so it can't check out the corrupt index if someone of first keys is bad.



CR:556165
CR Number:   556165
Product Name:   SySAM
Product Component:   SAMreport
Status:   Closed
OS:   Microsoft Windows
Original Version:   3.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2011 EOL'd version. Not to be Fixed.
Description
Customer has added groups in an options file. When they generate a Usage Summary report using SAMreport, the group information is displayed as 'none'.



CR:556167
CR Number:   556167
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a SET SWITCH option that would cause ASE to not raise error 3621, allowing a script to pick up and handle the more-specific previous error.



CR:556173
CR Number:   556173
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2009 Fixed
Description
Dropping a function based index on a partitioned table results in 11051 error.



CR:556182
CR Number:   556182
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2009 Fixed
Description
A SELECT INTO EXISTING query can incorrectly raise error 213 when the target table has a

functional index. The correct error should be 11029.



CR:556192
CR Number:   556192
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2009 Not a Bug
Description
In rare circumstances on a multi-engine 12.5.4 ASE, an undetected deadlock may occur when running the 'data_pgs' builtin function while there are many sessions creating or dropping tables in tempdb.



CR:556207
CR Number:   556207
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2009 Fixed
Description
If optimization goal is allrows_dss, wrong result could be returned

when executing an outer join query with aggregate functions in the

SELECT list after the query plan is cached in procedure cache.

This problem could occur if statement cache is enabled or the query

in question is in a stored procedure.
Workaround Description
 (1) Turn off statement cache if you use statement cache and it's an acceptable solution.

(2) Use allrows_mix as optiomization goal if it's acceptable.



CR:556213
CR Number:   556213
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2009 Fixed
30 Mar 2009 Fixed
26 Mar 2009 Fixed
06 May 2009 Fixed
17 Jun 2009 Fixed
Description
Provide support for Adaptive Server Transaction Coordination services in

a shared disk cluster so that the cluster is able to coordinate transactions

on a remote Adaptive Server.



CR:556257
CR Number:   556257
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2009 Fixed
Description
XPSERVER: On Windows 64 bit platforms, attempts to use xp_cmdshell when "xp_cmdshell context" is configured to the default value of 1 results in exception -1073741819
Workaround Description
 'sp_configure "xp_cmdshell context", 0'



CR:556402
CR Number:   556402
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Fixed
29 Jan 2009 Reservation Made
04 Feb 2009 Insufficient priority to fix
Description
Percentage of log pages to be scanned exceed the threshold (30%), causing the "Post Commit Optimization" to not kick in, hence resulting into false alarm



CR:556468
CR Number:   556468
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2009 Fixed
05 May 2009 Fixed
06 May 2009 Fixed
06 May 2009 Fixed
21 Jun 2009 Presently Not Targeted For Any Future Release Of This Product
15 Jul 2009 Fixed
27 Jul 2009 Fixed
05 Aug 2009 Fixed
Description
Table scans on DOL tables with many OAM entries with zero used/unused counts is slower

than in previous major releases. REORG COMPACT and REORG RECLAIM_SPACE utilities will

now clear out OAM entries with zero used/unused counts.



CR:556521
CR Number:   556521
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2009 Workaround
Description
Adaptive Server 15.0.3 on Windows NT platform (32-bit) may fail to start with an error message saying

"NT operating system error 87 in module 'nt386\ksource\blkmem\osmntmmap.c' at line 479 The parameter is incorrect"

followed by "kernel os_create_region: Failed to get virtual memory information".
Workaround Description
 imagecfg -l sqlsrvr.exe to enable >2GB VM support



[NOTE: over-configuring memory on ASE will give the same error in a wide range of situations and

the problem may not necessarily be the same as reported here]



CR:556559
CR Number:   556559
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Fixed
19 May 2009 Reservation Made
28 May 2009 Reservation Made
16 Jun 2009 Fixed
16 Jun 2009 Fixed
24 Jun 2009 Insufficient priority to fix
Description
Outer join semantics require that an outer null extended row be added to the result set if the inner join fails. This implies a minimum row count estimate for the result set to be at least as large as the number of outer rows of the join. This minimum estimate is now being enforced in the optimizer, and can be turned on with the outer_join_costing optcriteria. Part of the testing revealed an issue with duplicate estimates of join histograms, and a separate optcriteria join_duplicate_estimates was created to better estimate the duplicate behavior in join results.



CR:556561
CR Number:   556561
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2009 Fixed
Description
After loading a dump that contains a procedure that uses a TSQL user-defined function,

attempts to execute the procedure raise errors 208 and 913. Using EXECUTE 'procedurename'

WITH UPGRADE corrects the problem.
Workaround Description
 execute procedure using the "with upgrade" option once to fix problem.



CR:556567
CR Number:   556567
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2009 Fixed
Description
The RepAgent configuration parameter 'bind to engine' has been added to the 'Replication Agent Configuration' section of the report displayed by the system stored procedure sp_help_rep_agent.



CR:556668
CR Number:   556668
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Fixed
29 Jan 2009 Fixed
19 Feb 2009 Fixed
Description
Using RTMS and Java in the same SQL batch can result in an infected with

11 together with a stacktrace being printed in the ASE errorlog. The stacktrace contains the

modules 'Cast_UnitextData_to_String' and 'jvmfini'.



CR:556727
CR Number:   556727
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2009 Fixed
22 Jun 2009 Fixed
15 Jul 2009 Fixed
22 Jun 2009 Fixed
06 Jul 2009 One-off Provided
31 Jul 2009 One-off Provided
14 Sep 2009 One-off Provided
Description
A 12313 error: "Internal error: Insert into page id <pageid> of index id <indid> of table '<objname>' (id = <objid>) in database '<dbname>'tried to replace undeleted RID (<rid_pageid>,<rid_rnum>) at slot <slotnum> and ridposn <ridposn>." may be reported when a chained-mode multi_database transaction that modified a data-only locked table, is rolled back.



CR:556728
CR Number:   556728
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)
30 Jan 2009 Fixed
Description
merge joins are not used for very small tables when the underlying index order is provided by a one page index scan.



CR:556732
CR Number:   556732
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2009 Fixed
21 Jan 2009 Fixed
Description
Under rare circumstances, some premature out of data space conditions

may be hit (1105 error) whereas 'sp_helpdb' shows that free data space

is available. Alternatively, for mixed log and data databases, 3475

errors may be raised under the same space usage conditions.



CR:556742
CR Number:   556742
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2009 Fixed
20 Mar 2009 Added to user documentation
Description
Command line options to dataserver and qrmutil will now use hyphens instead of underscores, for example 'master-dev=' vs. 'master_dev='. To maintain backwards compatibility, dataserver and qrmutil

will still recognize underscores, such as 'master_dev'.



CR:556752
CR Number:   556752
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2009 Fixed
31 Mar 2009 Fixed
Description
The message, "Current process infected with 11", together with a stack trace which

include the modules 'srvdes_alloc' and 'omni_connect' may be reported in the errorlog

when accessing a proxy table or remote server when ASE has no more free memory. As a

workaround, increase the "max memory" configuration parameter.
Workaround Description
 Add more memory to the 'max memory' config parameter



CR:556762
CR Number:   556762
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
pyxis 21 Jan 2009 Fixed
pyxis 22 Jan 2009 Fixed
Description
Adaptive Server Shared Disk Cluster Edition may exclude local instance from the new cluster view when a split-brain type cluster failure occurs.



CR:556770
CR Number:   556770
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2009 Fixed
Description
A 10334 error, "Permission related internal error was encountered. Unable to continue execution."

may be reported in errorlog while running the DBCC CACHEDATAREMOVE command.



CR:556787
CR Number:   556787
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2009 Fixed
Description
Duplicate entries exist in RUN_<server name> file, if user input existing entry in sqlsrv.addl_cmdline_parameters again.
Workaround Description
 To edit RUN_files to delete the first -M row.



CR:556792
CR Number:   556792
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2009 Duplicate
Description
In rare circumstances the signal 11 might occur when executing the command "SETUSER".



CR:556829
CR Number:   556829
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Windows
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2010 Fixed
22 Aug 2011 Added to user documentation
01 Nov 2011 Fixed
Description
Syconfig.exe can not do upgrade on winx64 platform.



CR:556865
CR Number:   556865
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2009 Fixed
11 Feb 2009 Fixed
Description
Enhance support for multiple Backup servers in Cluster addressing following items.

- Display Backup server name in usage of stored procedure sp_volchanged.

- Restrict instance name in Cluster not to exceed 27 chars.



CR:556866
CR Number:   556866
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2014 Insufficient priority to fix
27 Oct 2014 Insufficient priority to fix
Description
If optimization goal is allrows_dss or advanced_aggregation is on,

count(column) in the select list of an outer join query could be

wrong.
Workaround Description
 (1) Turn off advanced_aggregation.

(2) Use allrows_mix as optiomization goal if it's acceptable.



CR:556896
CR Number:   556896
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2009 Presently Not Targeted For Any Future Release Of This Product
10 Jul 2009 Fixed
29 Jul 2009 Reservation Made
Description
A 2805 error, "Bad pointer 0x4 encountered while remapping stored procedure 'proc_name'. Must

re-create procedure." may be reported in the errorlog, or a 703 error, "You cannot run this procedure,

trigger, or SQL batch because it requires more than 24480 pages of memory. Break it up into shorter

queries, if possible." may be returned, and also sometimes the message "current process infected with

11" in the module 'qremap__mapptr' together with a stack trace which includes the modules

's_getTreeOrPlan' and 'qremap_prochdr' when executing a very big procedure which requires more than

24480 pages of memory.



CR:556903
CR Number:   556903
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2009 Fixed
Description
When statement cache and literal autoparam are on, sig11 may occur in s__make_param() when the query contains like clause in derived table expression and there are literals in

the like clause and other expressions within derived table expression and there are at least one

local variable referenced in the derived table expression.
Workaround Description
 a) use traceflag 7739

b) set "enable literal param" to 0.



CR:557092
CR Number:   557092
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2009 Fixed
Description
Clusterize new builtin reserve_identity("table_name", size), allowing a process

to grab a group of identity values reserved for that process.



CR:557099
CR Number:   557099
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
There is a requiment to enable session level variables in an isql session connected to an ASE server, similar to those available in isql when connecting to an IQ server.
Workaround Description
 N/A



CR:557146
CR Number:   557146
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2009 Fixed
Description
In rare cases we may hit "Assertion (MF_USED(mfp)) failed" while doing connection migration.



CR:557160
CR Number:   557160
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2009 Fixed
27 Feb 2009 Reservation Made
24 Jun 2009 Fixed
24 Jun 2009 Fixed
16 Jun 2009 Fixed
17 Jun 2009 Reservation Made
22 Jul 2009 Fixed
Description
Need microsecond time granularity in an ASE data type.



CR:557161
CR Number:   557161
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2009 Fixed
Description
When you run showplan and checkcatalog in two separate statements, you get totally

incorrect huge number result for the server pagesize. When you run them together, it is

correctly reported as 2048 bytes. Problem is reproduced on windows only, dbisql or isql.

See repro section.



CR:557199
CR Number:   557199
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2009 Fixed
23 Mar 2009 Fixed
30 Apr 2010 Fixed
30 May 2009 Fixed
19 May 2009 Reservation Made
01 Jul 2009 Fixed
05 Jun 2009 Fixed
01 Jul 2009 Fixed
22 Jun 2009 Reservation Made
15 Jul 2009 Fixed
17 Jul 2009 Fixed
30 Sep 2009 Fixed
Description
Provide a facility to transfer data incrementally between ASE and an external receiver such as Sybase IQ or another ASE.



CR:557299
CR Number:   557299
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2009 Fixed
12 Feb 2009 Fixed
Description
Applications that use query plans having lots of worktables and/or dynamic SQL

may hit SIGSEGV in make_negative_obj_id() and may cause one engine to fail.
Workaround Description
 n/a



CR:557301
CR Number:   557301
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2009 Fixed
12 Mar 2009 Reservation Made
07 Apr 2009 Fixed
25 Mar 2009 Fixed
Description
Repagent spins, consuming 100% CPU



CR:557351
CR Number:   557351
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2010 Fixed
04 Nov 2010 Fixed
22 Jun 2011 Fixed
Description
DDLGen does not generate ddls for

user resource limits and audit settings



CR:557357
CR Number:   557357
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2009 Fixed
Description
If a count aggregate appears as the inner member of an outer join

and a group_hashing strategy is used to calculate the count,

then an incorrect count of 0 will be returned. This could occur if a

group-by count aggregate occurs in a derived table or a view

and the derived table or view is used in turn as the inner member

of an outer join.



CR:557398
CR Number:   557398
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2009 Fixed
18 Mar 2009 Fixed
Description
ASE may crash unrecoverably in a multi-connection environment at ct_poll on the scheduler

thread when the configuration 'cis idle connection timeout' is set to a non-zero value.
Workaround Description
 Setting 'cis idle connection timeout',0 provides much more stability in testing with the reproduction.



CR:557400
CR Number:   557400
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2009 Fixed
06 Mar 2009 Fixed
Description
Wrong Asynchronization strategy caused by erroneous server code caused serious performance degradation on Sun Solaris architectures (Sparc/SparcV9 and X86_64). This problem required code adjusting to be resolved. There is no end-user server administration required.



CR:557564
CR Number:   557564
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2009 Fixed
Description
In rare circumstances we may not get expected identity values for a table,

when one of the instances is brought down in the cluster.



CR:557592
CR Number:   557592
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2009 Fixed
20 Aug 2009 Fixed
21 Aug 2009 Fixed
Description
Replicating data into an encrypted column that is bound to a domain rule fails with error 225. The same failure can occur when inserting data through bcp using the -C flag.



CR:557689
CR Number:   557689
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2009 Fixed
Description
When running asepyxis binary on pre-pyxis master device, error 5864 is seen

when doing sp_configure and the config file is truncated.



CR:557697
CR Number:   557697
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2009 Duplicate
Description
Query returns wrong results based on non-existence of optimizer statistics.



CR:557779
CR Number:   557779
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Unknown
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2009 Fixed
Description
In some circumstances, an 11056 error, "Exceeded tempdb space limit of <value> pages", may be reported pre-maturely due to an error in tempdb space control.



CR:557783
CR Number:   557783
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Optdiag cannot output statistics from a read only database



CR:557827
CR Number:   557827
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)
04 Feb 2009 Fixed
13 Feb 2009 Fixed
Description
A new stored procedure sp_compatmode is added to check the conflict configuration options

with compatibility mode and raise warning messages accordingly.



CR:557831
CR Number:   557831
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2010 Insufficient priority to fix
Description
In rare circumstances the failed deadlock handling could cause mltiple processes

hung in latch sleeping and unkillable.



CR:557886
CR Number:   557886
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2009 Bundled Request
Description
password_random() builtin generates a segmentation violation (SEGV) when NULL is specified as parameter.



CR:557900
CR Number:   557900
Product Name:   Adaptive Server Enterprise
Product Component:   Language Modules
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
optdiag with japanese LANG fails to load a statistics file to a database due to the error message "Problem with double quote marks with the following string:".
Workaround Description
 For input and output statistics, use us_english language and iso_1 charset instead of japanese.



CR:557939
CR Number:   557939
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2009 Presently Not Targeted For Any Future Release Of This Product
18 May 2009 Fixed
Description
When executing a query involving views and coalesce(), an error 4409 may be reported incorrectly.



CR:557967
CR Number:   557967
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2009 Fixed
05 Mar 2009 Reservation Made
28 Apr 2009 One-off Provided
Description
If the max possible size of the select list (i.e. adding up all the max lengths of all

the columns in the select list) is larger than the max row size for the server, then

the optimizer will avoid sort nodes at all costs to satisfy an ORDER BY clause.

This means that a very expensive sort node may be placed much earlier in the query

plan, in which the max row width is smaller. This could cause huge swings in

performance, if the number of rows at the top of the query plan is much smaller

than earlier in the join order. The allow_wide_top_sort optcriteria will avoid

checking for the max wide, for optimization purposes only, and allow a sort node

to be placed on top of the query plan for purposes of satisfying an ORDER BY.

This is consistent with 12.5 behavior for placement of sort nodes for ORDER BY.

The assumption is that rows formed from a select list of a query which has an ORDER BY

will fit into the sorter.
Workaround Description
 No real workaround unless customer is willing to use full AP to force the

placement of sort at top.



CR:558087
CR Number:   558087
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Update statistics should check whether target DB is read-only before starting any work.



CR:558102
CR Number:   558102
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2009 Fixed
Description
Dump database results in error message 3003 instead of error 3220 when connection to Backup server fails.



CR:558131
CR Number:   558131
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2009 Fixed
Description
ASE fails to start the SSL listener when there is a space at the end of the sql.ini entry

and returns the error "ssl tcp is not a valid protocol type on this platform"
Workaround Description
 Remove the space after the "ssl" or use this style entry:

[NSTACKXP1502]

master=TCP,nstackxp,5003,ssl="CN=NSTACKXP1502"

query=TCP,nstackxp,5003,ssl

master=TCP,nstackxp,5002

query=TCP,nstackxp,5002



CR:558179
CR Number:   558179
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2009 Fixed
Description
When PCI Bridge is disabled per ASE configuration the ASE under shutdown requests lists that it is performing a shutdown operation towards the PCI Bridge PLB (Launcher Boss) service thread. This operation always succeeds but is causing confusion as the DBA may think by this informative message that the PCI Bridge is enabled. There is no real impact other then that this is a cosmetic issue. The problem is resolved by altering shutdown path under the PCI Bridge to only issue a PLB shutdown if the PCI Bridge is enabled.



CR:558192
CR Number:   558192
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2009 Fixed
30 Mar 2009 Fixed
Description
Backup Server may report junk percentage progress instead of '0 %' while dumping or loading large databases.



CR:558222
CR Number:   558222
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2009 Fixed
02 Mar 2009 Bundled Request
09 Apr 2009 Fixed
Description
When running ASE SDC using a single link as interconnect, under heavy load ASE may falsely trigger a link down event accompanied by the message:

kernel Detected failure of the Primary interconnect network link with instance <n>



CR:558228
CR Number:   558228
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2009 Fixed
12 May 2010 Bundled Request
Description
In DBISQL 11.0.0, the plan output which was displayed following SET

SHOWPLAN ON always contained plans from a number of other statements which

the user did not directly execute. This has been fixed to restore the

9.0.2 behavior which is as follows:



If DBISQL is configured to display results as text, or read-only grids, the

SHOWPLAN output is just for whatever statement(s) you explicitly execute.

If DBISQL is configured to show results as editable grids, it requires more

metadata. That metadata is provided by the JDBC driver (JConnect) which

makes a number of database requests on our behalf. These requests

themselves cause SHOWPLAN output which users might not expect, but there is

nothing further which can be done about it. DBISQL also includes a plan

viewer window which is a good alternative to the textual SHOWPLAN.



CR:558243
CR Number:   558243
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2009 Fixed
Description
If a derived table contains a union all view, and the sybase extended column aggregate feature is used with this derived table, then "infected with 11" can occur, or wrong answers can occur.



An extended column aggregate is a non-ANSI feature, in which a reference to a column is made which is not in the GROUP BY list, and not contained in an aggregate, and is outside the WHERE clause.



SELECT

count(fifo_realized )

FROM

( SELECT * FROM OLOpenPos

UNION ALL

SELECT * FROM OLMaturedPos

) pos



ORDER BY

external_lentity_str

go



In the case above, the ORDER BY column is not in the WHERE clause, and there is a scalar aggregate in the select list. This results in 2 evaluations of the union all derived table, which could have wrong answer or signal 11 issues.
Workaround Description
 Trace flag 4418 should work around the problem.



CR:558256
CR Number:   558256
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)
02 Mar 2009 Fixed
Description
sp_sysmon fails with syntax error 249 when displaying the "Replication Agent" section of a database for which RepAgent has been enabled but is not running.



CR:558273
CR Number:   558273
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2009 Fixed
01 Oct 2009 Fixed
02 Oct 2009 Fixed
Description
A 2601 error may be reported during online upgrade if systabstats placement index is bound to a named cache.
Workaround Description
 Run sp_unbindcache to unbind the name cache for the "csystabstats" index

before dumping the user database or upgrade.



CR:558338
CR Number:   558338
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2009 Fixed
30 Mar 2009 Fixed
07 Apr 2009 Fixed
30 Mar 2009 Fixed
Description
LOAD operation with "compress::" may fail with no error message displayed.



CR:558501
CR Number:   558501
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2009 Fixed
Description
Pre-15.0 versions of bcp may insert incorrect numeric values into columns with the new BIGINT datatype



CR:558552
CR Number:   558552
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2009 Fixed
08 Apr 2009 Fixed
Description
If buffer pool tuning is performed during server boot-up, the config size of the default buffer pool shows a smaller value than the earlier configured value on both config file and sysconfigures.
Workaround Description
 Boot with traceflag 3474.



CR:558671
CR Number:   558671
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2009 Fixed
Description
SIGSEGV could occur in PeLikeFilterPred::PeEvaluateExpression() if a simple query which has a LIKE clause and an out-of-range SARG on the same column tries to select a greater range of values than the column's histogram.
Workaround Description
 Disable out-of-range histogram adjustment for the column in question.



update statistics table_name (column_name) using out_of_range off



CR:558700
CR Number:   558700
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2009 Fixed
06 Apr 2009 Fixed
30 Apr 2010 One-off Provided
Description
Some complex query may leave worktable descriptors in the incorrect state. As a result the same session may encounter errors related to worktable descriptors like error 8210 "Duplicate of work table descriptor found in the id hash table for temporary object" or encounter SIGSEGV error with module des_wkinstall() reported in the errolog.



CR:558955
CR Number:   558955
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   NA
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2009 Added to user documentation
Description
The sample script for using sp_extrapwdchecks to restrict password reuse by maintining a history incorrectly inserts internal_encrypt(@caller_password) into the pwdhistory table when it should insert @encrypted_pwd (or internal_encrypt(@new_password)
Workaround Description
 Change the line



select @loginame, internal_encrypt(@caller_password),



to



select @loginame, @encrypted_pwd,



CR:558961
CR Number:   558961
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2009 Fixed
25 Mar 2009 Fixed
Description
When using "authenticate with" login support in 12.5.4, the customer must use "authenticate with" ANY vs the KERBEROS option in order to allow remote sites to login using site-handler connections which have trusted option set to true.



CR:558995
CR Number:   558995
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2009 Fixed
Description
QPTune Wizard now saves the comparison output for a tuning task when it's executed.



CR:559034
CR Number:   559034
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2009 Fixed
23 Feb 2009 Reservation Made
Description
Covered index scans were incorrectly discouraged from being at the beginning of a join order

when a complex predicate that has strong filtering can be applied to the index. Instead

a non-covered more expensive index may be chosen instead, or a different join order may

be chosen. This can be seen when the "set statistics plancost on" output shows an

estimated row count for a covered index scan which is higher than the row count for the

rid join over a non-covered index scan. The behavior change is associated with the

optcriteria cr559034, which can be enabled with "set cr559034 on"
Workaround Description
 abstract plans can be used to force the correct plan



CR:559076
CR Number:   559076
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2009 One-off Provided
09 Apr 2009 Fixed
Description
An error 813 is raised by a task trying to allocate a new page to an object.



CR:559151
CR Number:   559151
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2009 Fixed
12 Mar 2009 One-off Provided
Description
ASE may crash unrecoverably with signal 11 in ct_poll when a dynamic SQL query is interrupted

by an cancel attention generated from a killed connection.



CR:559216
CR Number:   559216
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2009 Fixed
Description
On QPTune Wizard's Results page, the new "Verify" button allows the user to re-run the collection after a tuning fix has been applied to the server.



CR:559219
CR Number:   559219
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2009 Fixed
Description
Add support in QPTune Wizard for including 'Basic Optimization' tuning mode.



CR:559236
CR Number:   559236
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)
17 Feb 2009 Bundled Request
Description
Previously in 15.0.3 ESD #1 ASE Plug-in's QPTune Wizard invoked Interactive SQL to run a script file and it was distracting. This has been improved by only using the Run Script dialog from Interactive SQL to run the script file.



CR:559342
CR Number:   559342
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2009 Fixed
Description
The dump version 12540(ASE 12.5.4 ESD#9) and load version 15030(ASE Pyxis SMP/SDC) may result in version incompatibility error.



CR:559464
CR Number:   559464
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2009 Fixed
Description
Inefficient plan could be chosen for correlated subquery referencing a DISTINCT

view if there is a sargable correlated predicate on the column from the DISTINCT

view.
Workaround Description
 1. change the view ddl to below :





create view vw_mtf_px2

as

select security from invesco..mtf <--- take out the "distinct"



2. set compatibility_mode on



3. Under ase1503esd1 and later releases, one more workaround is to

use the following abstract plan:

INSERT INTO No_MTF_tmp

SELECT DISTINCT Equ_tmp.Security

FROM Equ_tmp

WHERE Equ_tmp.Security not in (select distinct security from vw_mtf_px2)

plan "( insert ( nested ( distinct_sorted ( i_scan Equity_ix_01 Equ_tmp ) ) ( subq (

scalar_agg (store_index ( i_scan security_IDX [invesco..mtf] ) ) ) ) ))"

This will give the plan similar to the 125 materializing plan.



CR:559524
CR Number:   559524
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2009 Fixed
Description
Executing 'set textsize 0' fails to reset @@textsize to the default value(32k).



CR:559584
CR Number:   559584
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Under certain circumstances, the load of an archive database may fail with a timeslice error.
Workaround Description
 Increasing CPU grace time may help to reduce the chances of timeslicing while loading this archive database.



CR:559593
CR Number:   559593
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2009 Fixed
05 Jun 2009 Duplicate
Description
If a cluster-wide static config option is changed, but the cluster is not restarted,

the new joint instance will have different run value on the new instance.





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

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