远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:658276
CR Number:   658276
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2011 Fixed
05 Jun 2011 One-off Provided
25 May 2011 Fixed
25 May 2011 Fixed
15 Sep 2011 One-off Provided
25 Sep 2012 Fixed
Description
A "9219, severity 20, state 83" error may occur when a stored procedure with enough

wide parameters that the number of bytes necessary to log an invocation would require

more than a single log page. The error will only occur if the stored procedure has

been previously invoked with null values in the wide parameter(s) and is

subsequently invoked with non-null values in those same parameter(s).
Workaround Description
 No work around, Customer will have to move STP (Secondary Truncation Point)

- run "rs_zeroltm"

- run "dbcc settrunc (ltm, pageid, <page#>)



CR:658298
CR Number:   658298
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need to have some built-in function or global variable that could be checked by customer written tsql applications so that they might finish processing and let normal ASE shutdown with wait proceed.



CR:658317
CR Number:   658317
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2011 Fixed
Description
The DBCCLOG command in sybmon is extended to support displaying pre-15.5 ASE transaction log records.
Workaround Description
 Use a pre-15.5 dataserver binary to display the log records correctly.



CR:658340
CR Number:   658340
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2012 Presently Not Targeted For Any Future Release Of This Product
Description
test and certify a version of ASE 15.5 for solaris 5.11
Workaround Description
 Use solaris 5.10



CR:658430
CR Number:   658430
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)
16 Feb 2011 Fixed
12 Oct 2011 One-off Provided
25 Sep 2012 Fixed
02 Oct 2012 One-off Provided
Description
The PR_DESCHAIN NHASH sybmon command does not print the

right information with regards to the hash by name table

of DEScriptors.



CR:658449
CR Number:   658449
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T: Query Processing and Abstract Plans
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2011 Added to user documentation
Description
"store_ind" syntax incorrect in AP example in ASE15.5 P&T



CR:658621
CR Number:   658621
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2011 Fixed
05 Apr 2011 Added to user documentation
Description
Value of Severity columns in monErrorLog is 99 indicates it's a stacktrace.



CR:658661
CR Number:   658661
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2011 Workaround
Description
In some cases, there is certification error between ASE WebService and external webservice.
Workaround Description
 The user imports the certification for the external webservice into the JRE default keystore for example $JRE/lib/security/cacerts.



CR:658668
CR Number:   658668
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A 692 error on syslogs is sometimes reported when loading a dump taken of a database that

was in standby_access mode.



CR:658851
CR Number:   658851
Product Name:   Adaptive Server Generic Docs
Product Component:   Utility Guide
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2013 Added to user documentation
Description
DOCCR: DDLGEN support password encryption, fixed by CR594606



CR:659042
CR Number:   659042
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2011 Fixed
14 Apr 2011 One-off Provided
10 May 2011 Fixed
28 Sep 2012 One-off Provided
25 Sep 2012 Fixed
Description
When the master database is marked for replication the execution of sp_addlogin does not replicate the login with the correct password expiration interval.
Workaround Description
 manually change the password interval for the user id where the login was replicated to.



--or--



When adding the user, specify the password interval. If both servers are different, replication will use the target server configuration, rather than what was entered.



CR:659124
CR Number:   659124
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2011 Not a Bug
Description
After upgrade from ASE1502 to ASE15.5,any user not SA role can't access archive db which is dumped and loaded from ASE1502 onto ASE15.5



CR:659161
CR Number:   659161
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow the output/result set returned by a stored procedure to be handled via a scrollable cursor



CR:659334
CR Number:   659334
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need feature request for counter of statement iterations



CR:659335
CR Number:   659335
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2013 Fixed
Description
Msg 9561, Level 20, State 1: Invalid pointer param number 2, pointer value



CR:659485
CR Number:   659485
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2011 Fixed
04 Apr 2011 Fixed
Description
A timelice error together with stack trace which includes module 'idt_value_verify' may occur when several rows are inserted into database, or inserting rows followed by retrieving identity value from the database, if BIGINT datatype is used for the identity column.
Workaround Description
 1. Without one-off, customer can use "unsigned bigint" or "numeric(20,0)" instead of "bigint" for identity column.

2. Code fix: add special handling for bigint in idt_numetoint(), so that converting numeric to bigint invoke comnb_numtoi8(), and overflow is handled correctly.



CR:659498
CR Number:   659498
Product Name:   SySAM
Product Component:   SyLAPI/C
Status:   Closed
OS:   HP-UNIX
Original Version:   2.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2011 Fixed
Description
SySAM requests double the required amount of chip licenses for Itanium 9300 series quad-core chips. When this is the case 'cpuinfo -v' displays the diagnostic messages "Family 32 Model 2" and "Family 32 >= 32. Montecito or newer, so dual-core".
Workaround Description
 Ask the customer for the output from running the following command on the physical machine:

sysamcap MACHINE -v



Send this output to help_sysam@sybase.com and refer to CR 659498, i.e.



Hi,



A customer has hit CR 659498 (cpuinfo detects too many Itanium quad core chips).

Please recrypt the following SYBASE_SAM_CAPACITY string to override the chip count.

(don't forget to set the override flag)



PLACE cpuinfo -v OUTPUT HERE



Thanks,



CR:659629
CR Number:   659629
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)
25 May 2011 Fixed
22 Jul 2011 Fixed
Description
When the RepAgent configuration parameter 'rs password' is set

by executing the sp_config_rep_agent system stored procedure,

the password is logged encrypted to avoid it from being exposed

in clear text in the transaction log and during the replication

of this stored procedure execution.



CR:659638
CR Number:   659638
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to eliminate the SELECT INTO dboption requirement when using ALTER TABLE to add a NOT MATERIALIZED computed column.



CR:659661
CR Number:   659661
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request a new feature which can always display a running process's outermost stored procedure name with parameter value(s).



CR:659709
CR Number:   659709
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2011 Bundled Request
10 Mar 2011 Bundled Request
Description
A stacktrace may be encountered when executing a MERGE statement involving a DELETE if there is a referential integrity assignment in the source table.



CR:659910
CR Number:   659910
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)
07 Jul 2011 Fixed
Description
Query with TOP, UNION ALL and ORDER BY clause could return fewer rows.



CR:659912
CR Number:   659912
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
Description
If a query HASH joins a UNICHAR and UNIVARCHAR column and the joining values differ only by trailing blanks, then the row may not be returned.
Workaround Description
 Disable hash_joins:

set h_join 0



CR:659996
CR Number:   659996
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2011 Fixed
Description
Under very rare circumstances, a task committing its transaction may go into an undetected

deadlocked condition with another task which is truncating the transaction log.



CR:660022
CR Number:   660022
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
Description
A new system stored procedure is needed to convert the existing inline default objects

into sharable inline default objects and drop the remaining duplicate ones.



CR:660060
CR Number:   660060
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sysquerymetrics is not recording information on some aborted commands.



CR:660150
CR Number:   660150
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
24 Mar 2011 Fixed
Description
Some data rows might be missing from a table following a LOAD TRANSACTION of a transaction log that was dumped after the table was created by SELECT INTO when the "fully logging for select into" database option was turned on.



CR:660152
CR Number:   660152
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2011 Bundled Request
10 Mar 2011 Bundled Request
Description
A stacktrace may be encountered when executing a MERGE statement involving a DELETE if the source table is partitioned.



CR:660173
CR Number:   660173
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2011 Bundled Request
10 Mar 2011 Bundled Request
Description
A stacktrace may be encountered when executing a MERGE statement involving a DELETE if the source table is a VIEW with a GROUPBY clause.



CR:660224
CR Number:   660224
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE/CIS to oracle ... convert function causes subquery performance prblm



CR:660311
CR Number:   660311
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2011 Fixed
Description
Less rows than expected may be returned when executing a query which joins 3 or more tables with All Pages Locking schema, there are some duplicate conditions in the WHERE clause and the SET SHOWPLAN ON output shows that it used a N-ARY NESTED LOOP JOIN operator.
Workaround Description
 Use trace flag 342 to disable N-ary NLJ

or remove a duplicate SARG if possible

or use DOL tables.



CR:660481
CR Number:   660481
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2012 Fixed
28 Mar 2012 Reservation Made
Description
The recovery REDO pass at boot time or during LOAD DATABASE is unnecessarily slow in cases where there is one or more very long running transactions.



CR:660563
CR Number:   660563
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)
19 May 2011 Fixed
19 May 2011 Fixed
20 May 2011 Fixed
08 Jun 2011 Fixed
28 Jul 2011 Fixed
02 Aug 2011 Fixed
02 Aug 2011 Fixed
18 Jul 2011 Reservation Made
26 Jul 2011 Fixed
27 Jul 2011 Fixed
09 Aug 2011 Fixed
20 Mar 2012 Presently Not Targeted For Any Future Release Of This Product
23 Apr 2012 Presently Not Targeted For Any Future Release Of This Product
20 Mar 2012 Presently Not Targeted For Any Future Release Of This Product
02 May 2012 Fixed
09 Apr 2012 Fixed
11 Apr 2012 Fixed
Description
A new interface is provided that enables ALTER TABLE DROP column DDL to optionally execute by deferring the time-consuming data copy path.



CR:660729
CR Number:   660729
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 17 Jul 2011 Fixed
Description
LICENSE HEARTBEAT process down with stacktrace.

<environments>

Sun Solaris UltraSparc-T / Solaris 10 / Doesn't configure Logical Domains.

<WorkAround> Use 1 or 2

1) use SYBASE_SAM_CAPACITY enviroment ( sysamcap DEFAULT )

2) add solaris.ldoms.read role to sybase user.
Workaround Description
 <WorkAround>

1) use SYBASE_SAM_CAPACITY enviroment ( sysamcap DEFAULT )

or

2) add solaris.ldoms.read role to sybase user.



CR:660784
CR Number:   660784
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2011 Presently Not Targeted For Any Future Release Of This Product
31 Mar 2011 Not reproducible with latest version of the product available as of Resolution Date
Description
Signal 11 at LeScanOpM_LeOpAcquire6MrnHExeCtxt, LeNaryNLJOp::_LeOpAcquire(ExeCtx
Workaround Description
 Use traceflag 342 to turn off nary nested loop join.



CR:660820
CR Number:   660820
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Fixed
Description
sp_helprotect does not consider roles inherited through login profiles when reporting permissions.

In addition, on a High Availability environment, when a primary fires a command to CREATE/ALTER/DROP login or login profile and if the command fails on the secondary, the TDS return

status of the command on the primary is still a success.



CR:660837
CR Number:   660837
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need an ability to select information from a stored procedure without first having to create a proxy table.



CR:660956
CR Number:   660956
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)
03 Mar 2011 Workaround
Description
In some cases, ASE WebService may hang while ASE WebService server is started with JRE6 distributed with ASE on IBM AIX.
Workaround Description
 The user can download an JRE6 from IBM freely and install it on user machine. And use the installed JRE instead of the JRE6 distributed with ASE



CR:660984
CR Number:   660984
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a generated select query contains duplicate column names in the select list, then the query should be executed as occurs in ASE 15.0.3 ESD #1, provided that there can be no resulting ambiguity caused by the inclusion of an order by clause.
Workaround Description
 There is no workaround for the client other than to stay on a specific version of ASE that permits their generated queries.



CR:661262
CR Number:   661262
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2011 Fixed
Description
workaround listed for ase1503esd3 on win2008R2 does not always work



CR:661265
CR Number:   661265
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2011 Fixed
Description
A 7105 error, "TEXT/IMAGE/UNITEXT page <page> does not have a next page" together with a stack trace may be reported when input text string containing partial character at the end is inserted into Adaptive Server which has the same character set as client by BCP...IN.



CR:661425
CR Number:   661425
Product Name:   Adaptive Server Generic Docs
Product Component:   Other
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2011 Added to user documentation
Description
Document the contents of the Job Scheduler history table



CR:661452
CR Number:   661452
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Using control-c to terminate a batch that creates a temp table and uses INSERT SELECT to insert rows into that temptable may result in an orphaned temp table. Use DBCC ORPHANTABLES("drop") to clean up the orphaned tables.
Workaround Description
 DBCC ORPHANTABLES("drop") should clean up the orphaned table(s).



CR:661494
CR Number:   661494
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2011 Fixed
14 Mar 2011 Fixed
15 Mar 2011 Reservation Made
11 Apr 2011 Presently Not Targeted For Any Future Release Of This Product
03 Oct 2011 One-off Provided
Description
Under multi-byte character sets, selecting rows from text columns may cause more IOs comparing to single-byte character set.



CR:661508
CR Number:   661508
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2011 Fixed
10 Jun 2011 Fixed
Description
A 3478 error: "During undo the page timestamp value is less than new timestamp from log ... ", may be reported during reboot if a REORG REBUILD command was active at the time the server was killed.



CR:661677
CR Number:   661677
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2011 Fixed
14 Jun 2011 Fixed
14 Jun 2011 Insufficient priority to fix
Description
After a cross-platform dump-load, some of the histogram statistics, used by the optimizer, may be incorrect.
Workaround Description
 1. Run update statistics after cross platform dump-load.

OR

2. Use optdiag: Before the dump save statisitcs in a text file using opdiag.

After the load use optdiag to load those states on the other platform.



CR:661716
CR Number:   661716
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Solaris
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2011 Fixed
Description
The wrong syntax is included in the two following manuals.



Installation Guide Adaptive Server Enterprise 15.5 for Sun Solaris

Installation Guide Adaptive Server Enterprise 15.5 - Cluster Edition for Sun Solaris



Preinstallation Tasks for the Server Installation :



wrong: project.max-shm-memory=\(privileged,17179869184,deny)

correct: project.max-shm-memory=(privileged,17179869184,deny)



CR:661802
CR Number:   661802
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2011 Fixed
Description
Sybcluster always performances heartbeat check according to "quorum heartbeat retries" and will not stop even if the check if successful.



CR:661814
CR Number:   661814
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2011 Fixed
Description
Changing ASE config parameters can cause exception java.lang.NullPointerException at java.lang.String.compareTo(String.java:1168)



CR:661819
CR Number:   661819
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow the ASE Web Services to support more than one output parameter



CR:661974
CR Number:   661974
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2011 Fixed
10 Mar 2011 Fixed
Description
With statement cache is ON and literal parameterization is OFF, when a string literal in a UPDATE/SELECT/INSERT/DELETE statement contains quotes and [ ] inside the quotes, if there are whitespaces after the right ], those whitespaces might be filtered out causing a wrong literal value to be stored in the statement cache text entry.
Workaround Description
 Turn on literal autoparam.



CR:662014
CR Number:   662014
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2011 Fixed
Description
Signal 11 can occur in the module 'th_curunreservedpgs' when an ALTER DATABASE is run at the same time the curunreservedpgs() builtin function is used.
Workaround Description
 Don't run curunreservedpages() while an alter database is running



CR:662048
CR Number:   662048
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#1 12 Jan 2012 Duplicate
Description
ADO.NET: A Decimal parameter with value of null is sent with Precision = 0, this query fails if ASE statement cache is enabled with message "Length or precision specification 0 is not within the range of 1 to 255.".
Workaround Description
 Customer currently doing either no statement cache or purging the cache with dbcc purgesqlcache



Connectivity PSE also discovers if the client app explicitly sets Precision and Scale for the decimal parameter they'll avoid the problem.



CR:662152
CR Number:   662152
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)
11 Apr 2011 Fixed
11 Apr 2011 Fixed
Description
ASE WebService will use jConnector-7_0 instead of jConnector-6_0.



CR:662247
CR Number:   662247
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2011 Fixed
Description
OEMs can now specify the directory used by DBISQL, Sybase Central,

DBConsole, and ML Monitor. To do this, you must deploy an OEM.ini file

along with DBISQL (et al). The file must contain the following lines:



[preferences]

directory=preferences_files_directory



where "preferences_files_directory" is a fully-qualified directory name,

e.g. "c:\work\prefs". The directory name should not end in a separator

(backslash on Windows; forward slash on Linux, Unix, and OS X).



Preferences files include:

.isqlPreferences12_32

.isqlPreferences12_64

.isqlHistory12

.jlogon12

.textCompleter12

.SybaseCentralEditor610

.scUserPreferences610_32

.scUserPreferences610_64

among others.



CR:662338
CR Number:   662338
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows W2k
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2011 Fixed
Description
IOTime in monIOQueue is incorrect for multiple engines server on Windows platform.



CR:662402
CR Number:   662402
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2011 Fixed
Description
Running an EXECUTE CURSOR query may hit SIGSEGV in s_compile() in case of recompilation, together with stack trace involving modules s_setupcursor(), curs_execute() and s_recompile().



CR:662410
CR Number:   662410
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Apr 2011 One-off Provided
12 Nov 2012 Fixed
Description
ARIES CE with >1 instance setup hits SIG11 inside function lock__mmaster_processque



CR:662451
CR Number:   662451
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Issue a warning/error when SELECT INTO EXISTING is used on a local table



CR:662458
CR Number:   662458
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for an xmlextract text() option to extract de-entitized string data from xml source. Currently, text() only extracts entitized strings.
Workaround Description
 create function de_entitize (@input varchar(16000))

returns varchar(16000)

as

-- second parameter should be entitized string for the symbol.

-- browser may be interpreting it. i.e.

-- second paramter on the next line is really &-amp; without hyphen

select @input = str_replace(@input, "&", "&")

select @input = str_replace(@input, '"', '"') -- &-quot; without hyphen

select @input = str_replace(@input, "'", "'") -- &-apos; without hyphen

select @input = str_replace(@input, "<", "<") -- &-lt; without hyphen

select @input = str_replace(@input, ">", ">") -- &-gt; without hyphen

return @input

go



CR:662522
CR Number:   662522
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
timeslice in function pgos_nextpgidsmap when doing create index in parallel



CR:662586
CR Number:   662586
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
Description
ASE dataserver does not give page or dbid information with error 290024.



CR:662591
CR Number:   662591
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Signal 11 at void LeSargArray::setupSargArray(proc_hdr*)
Workaround Description
 No workaround



CR:662923
CR Number:   662923
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2011 Duplicate
08 Oct 2012 Fixed
Description
sp_monitorconfig 'procedure cache size' can become inaccurate. Fixed via CR 644156.



CR:662937
CR Number:   662937
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2011 Fixed
18 Mar 2011 Reservation Made
Description
Provide global variable @@sbssav and ASE command line option --sbssav, returning a short standardized ASE version string.



CR:663005
CR Number:   663005
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2011 Fixed
01 Apr 2011 One-off Provided
04 Apr 2011 Fixed
29 Mar 2011 Fixed
Description
A cluster setup with more than 1 instance may encountered a signal 11 with a stacktrace involving the function 'lock__mmaster_processque'.



CR:663109
CR Number:   663109
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2011 Fixed
04 Aug 2011 One-off Provided
Description
Under some very rare circumstances, one of the cluster instances may abort with an infected with 11

message together with a stack trace showing module name 'dbt_rdump_action_pcm_callback'. This

may happen after a DUMP DATABASE command was interrupted or hit an exception.



CR:663156
CR Number:   663156
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have except action option for "sp_audit 'all','all','all"



CR:663203
CR Number:   663203
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2011 Fixed
Description
Error 2502, "Table Corrupt: A page is linked in more than one chain; check this page:page

number=<page number> allocation status=<status value>", followed by error 7968, "The object

allocation map for tabid <object id> indid <index id> partition <partition nid> is corrupt,

therefore the optimized report cannot be generated. Contact Technical Support for assistance.",

will be reported when running "dbcc textalloc" with "noreport" option multiple times.



CR:663224
CR Number:   663224
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2011 Bundled Request
05 Apr 2011 Fixed
30 Mar 2011 Fixed
28 Apr 2011 Bundled Request
Description
In some cases, ASE WebService cannot consume the WebService which has SOAP datatype parameters including soapenc:byte, soapenc:boolean, soapenc:long and soapenc:int.



CR:663304
CR Number:   663304
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)
23 Mar 2011 Fixed
23 Mar 2011 Reservation Made
01 Apr 2011 Fixed
11 Apr 2011 Fixed
31 Mar 2011 Fixed
Description
If an APL table has a unique CLUSTERED INDEX with all keys specified by constants and a non CLUSTERED INDEX is forced, then the join order will place this table at the beginning of the join order, bypassing costing, which could result in a performance problem. This behavior is fixed by optcriteria cr663304 or trace flag 16926.
Workaround Description
 There are a few workarounds for the query:

1) compatibility mode (12.5 optimizer checks all 6 permutations as the customer pointed out)

or 2) new 15 trace flag -T15308 to ignore index/prefetch/parallel/replacement forcings as engineering pointed out

or 3) avoid index forcing for the query so that the 15 optimizer can pick up a different index for the join order

or 4) alter table ext_instr_ref_p2k lock datarows



CR:663342
CR Number:   663342
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2011 Fixed
02 Jun 2011 Fixed
17 Aug 2011 Fixed
Description
There could be a memory corruption during page allocation either in

case of a MLD database when another task is doing the allocation on

the same allocation page or with any database if the buffer for the

new page could not be allocated.



CR:663359
CR Number:   663359
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2011 Fixed
Description
A 9236 error, "Unknown dbid '0' specified. Please check the dbid specified."

may be reported when running SP_HELP_REP_AGENT with no parameter values.



CR:663436
CR Number:   663436
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An infected with 11 with a stacktrace containing functions infected fm_unlink_frame fm_free_frame fm_free_list if the server if the sp_configure setting for open databases is lower than the actual number of databases on the server.
Workaround Description
 Increase the sp_configure setting for "open databases". This should be set at least as high as the actual number of databases on the server. If this CR is not yet fixed, please try to get a memdump (no data cache needed) before applying the workaround.



CR:663457
CR Number:   663457
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2012 Not a Bug
Description
UPDATE STATISTICS actually executes when SET SORT RESOURCES is ON rather than just providing resource usage estimates.



CR:663537
CR Number:   663537
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2011 Fixed
Description
Create table with compressed LOB in imdb should fail but not now.



CR:663600
CR Number:   663600
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2011 Fixed
25 Apr 2011 Duplicate
03 Oct 2011 One-off Provided
26 Sep 2012 Fixed
Description
Updating identity columns gives error 586: Illegal identity value specified for identity
Workaround Description
 use compatibility mode

Roll back to 15.5 ESD #2



CR:663606
CR Number:   663606
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2011 Fixed
11 May 2011 One-off Provided
01 Jun 2011 One-off Provided
16 May 2011 Reservation Made
23 May 2011 Fixed
01 Jun 2011 Fixed
Description
BCP-in performance on a large table having many indices is significantly worse than the performance achieved using 12.5.4



CR:663628
CR Number:   663628
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2011 Fixed
Description
Worktables will not be shown in monProcessObject.



CR:663651
CR Number:   663651
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2011 Fixed
20 Apr 2011 Fixed
Description
Two new fields (ssql_optgoal and ssql_optlevel) are added to statement cache entry, and two new columns (OptimizationGoal and OptimizerLevel) are added to table monCachedStatement.



CR:663778
CR Number:   663778
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2011 Duplicate
Description
Make the statement cache maximum sql size user configurable.



CR:663926
CR Number:   663926
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An INSERT into a table that contains computed columns which has been upgraded from ASE 15.0.3 may give Signal 11 (Access Violation) in norm3_expr().
Workaround Description
 Drop & recreate the table.

Drop computed columns before upgrade and restore afterwards.



CR:663945
CR Number:   663945
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2011 Fixed
Description
When creating a functional based index, data may get truncated when using CONVERT().



CR:663967
CR Number:   663967
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 CGA Drop#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2011 Fixed
Description
Running a dynamic sql query may hit SIGSEGV in s_normalize() in case of recompilation,

together with stack trace involving modules s_reinstall_lwp_tree(), s_procinstall_lwp(),

s_recompile() and tdsrecv__dynexec_xoltp().



CR:663977
CR Number:   663977
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Windows 2008
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2011 Not a Bug
Description
syconfig from 15.5 ESDs fails with side-by-side error.
Workaround Description
 Use the 15.5 GA syconfig.



CR:663994
CR Number:   663994
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2011 Fixed
Description
Signal 11 could occur in CgEvals::_CgCompVcol(tree*) during

DistinctHashing operator code generation when there are

two distinct expression columns and one is becoming dependent on

the other through equijoin transitive closure. Using diagserver,

the assertion "Assertion (GcvIsVirtualColumn(pNode))" could fail

in cgevals.cpp line 202.
Workaround Description
 set distinct_hashing off



CR:664112
CR Number:   664112
Product Name:   Adaptive Server Enterprise
Product Component:   sqlloc
Status:   Closed
OS:   Solaris 11
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2011 Fixed
30 Mar 2011 Fixed
Description
sqllocres does not check for valid default language/character set/sort order attributes in the resource file.
Workaround Description
 Use sort order file name: "sqlsrv.sort_order: binary.srt"

Or sort order name: "sqlsrv.sort_order: bin_iso_1"



CR:664161
CR Number:   664161
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2011 Fixed
Description
The message "current process infected with 11" in the module

'fglk__send_prom_attn' together with a stack trace which

includes the modules 'fglk__promote' and 'getnext' may be

reported in the error log and may bring the server down

if a query involving a big number of tables (more than 50)

was being executed in parallel and due to the number of

locks acquired it attempted to promote the locks to a

lock of a higher level.
Workaround Description
 Run the query in serial mode, for example, using SET PARALLEL_DEGREE 1.



CR:664218
CR Number:   664218
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2011 Fixed
05 Apr 2011 Fixed
Description
When sp_showoptstats is called with cross database objects, optimizer stats for that object is not returned and no error message is raised.



CR:664266
CR Number:   664266
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2011 Duplicate
10 Nov 2011 Duplicate
Description
Error: 8203 DES expected in DROP state in ssql__rmplans()
Workaround Description
 None known.



CR:664291
CR Number:   664291
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2011 Not a Bug
Description
Value of an empty string in date calculations is context sensitive
Workaround Description
 Don't use empty strings, specify dates precisly.



CR:664361
CR Number:   664361
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Windows
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2011 Added to user documentation
Description
Docs: clarify "sybase" user account is not literally "sybase"



CR:664620
CR Number:   664620
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2011 Duplicate
Description
Suboptimal plan when use NOT in Subquery.
Workaround Description
 force the other plan.



or use compatibility mode.



CR:664621
CR Number:   664621
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)
28 May 2013 Insufficient priority to fix
Description
Wrong result set in 1503 compatility mode with statement cache disabled
Workaround Description
 1) Change query to use: is null

2) Disable compatibility mode

3) Enable statement cache

4) Enable TF 304



CR:664703
CR Number:   664703
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2011 Fixed
20 Apr 2011 Fixed
Description
A query against an MDA table such as monLocks may encounter a timeslice error in

VTABRemoteAccess::getNext() during a period of heavy user activity.



CR:664714
CR Number:   664714
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2014 Fixed
Description
Increase the limit on the number of historical configuration files saved from 999 to 999999999.



CR:664830
CR Number:   664830
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currently one can bind tables or indices to a cache. Partitioned tables can have very active partitions which one might bind to specific caches.
Workaround Description
 none.



CR:664833
CR Number:   664833
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2011 Fixed
07 Apr 2011 Reservation Made
08 Apr 2011 Fixed
Description
Normally, if an attribute from a table

inner to an outer join is referenced in

a higher scope outer join or in the WHERE

clause, it would cause the outer join to

degenerate into an inner join since all

null extended rows would be eliminated. The exception

occurs with "null preserving" predicates such

as IS NULL which would not eliminate the row.



If a nested outer join exists where

a table is inner to an outer join and

an attribute of the table is referenced in second

higher scope outer join ON clause in a "null preserving"

predicate then a wrong answer could result when a mergejoin/hashjoin

is chosen for the higher scope outer join.
Workaround Description
 Use 'set plan optgoal allrows_oltp' to avoid the merge join plan for the query.



The customer uses 'set plan optlevel ase_default' for the query and get a different plan which works for them.



CR:664848
CR Number:   664848
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UX
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2014 Insufficient priority to fix
07 May 2014 One-off Provided
27 Apr 2014 Fixed
08 May 2014 Fixed
27 Oct 2014 Consult Complete
01 Jul 2014 Fixed
08 Jan 2015 Fixed
Description
In rare circumstances, the message "current process infected with 11 (SIGSEGV)" in the module 'ind__get_sysindrow()' together with a stack trace which includes the modules 'getindexname()' and 'CgGenLava::CGConsScanOp()' may be reported in the SAP ASE error log. This may happen when a statement, using temporary user tables or tables created in the same batch or stored procedure and with indexes defined, is being compiled before execution.



CR:664877
CR Number:   664877
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2011 Fixed
06 Oct 2011 Reservation Made
18 Oct 2011 One-off Provided
03 May 2012 Presently Not Targeted For Any Future Release Of This Product
11 Sep 2012 Presently Not Targeted For Any Future Release Of This Product
Description
CREATE INDEX on a large partitioned table may generate an excessive number of steps in

sysstatistics. A subsequent UPDATE STATS reduces the number of steps to an expected value.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

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

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------