远程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:740746
CR Number:   740746
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2013 Fixed
Description
A new feature request to make ASE set 0 to segmap of sysusages if ASE finds segmap=0 in allocation pages of tempdb while rebuilding sysusages.



CR:740776
CR Number:   740776
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2013 Duplicate
Description
Hash based statistics collection may fail with an internal error



CR:740790
CR Number:   740790
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   all
Original Version:   chaumont
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When generating a XSM from an OOM, the Class attributes are not generated if the Class Description property is populated.



To reproduce:

Use sample OOM to generate an XML model

or



1) create an OOM

2) add a Class with several attributes

3) enter some text in the Description of the Class

4) Generate XML model; on the Detail tab select 'Generate Attributes as 'Attributes'



In the resulting XSM, the attributes have not been generated for the Class



CR:740800
CR Number:   740800
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2013 Fixed
15.7 SP110 20 Jun 2013 Fixed
06 Jun 2013 One-off Provided
15.7 SP50 12 Jun 2013 Fixed
20 Jun 2013 Reservation Made
Description
In rare scenarios, a timeslice error may be reported along with stack trace which includes the modules ind_ides_init() and ind__ides_install() after using the DBCC TUNE('des_bind') utility.



CR:740814
CR Number:   740814
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2014 Fixed
Description
There are missing VA information in some Lava plan operators when using show_cached_plan_in_xml().



CR:740817
CR Number:   740817
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2013 Not a Bug
Description



CR:740835
CR Number:   740835
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 07 Jul 2013 Fixed
Description
In stress test, when scanning a table using transaction isolation level 0, error 12301 state 1 "Data is marked deleted but index is not." might be output.



CR:740878
CR Number:   740878
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 27 Jun 2013 Fixed
15.7 SP50 20 Jun 2013 Fixed
27 Jun 2013 One-off Provided
Description
If a process uses up all the locks leading to error 1204, then a new login attempt may cause a stack trace that involves the module lock_do_logical() to be reported in the ASE error log.



CR:740882
CR Number:   740882
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 15 Jul 2013 Fixed
Description
Table scans may be used by the optimizer if parameters values are not visible at optimization time for range predicates since the magic numbers used by a range predicate ">", "<", ">=" or "<=" will use 33% selectivity, and an "in-between" predicate in which a lower and upper bound are specified will use 25% selectivity. sp_modifystats has a new option MODIFY_DEFAULT_SELECTIVITY for which the defaults of .33 and .25 can be overridden for a specific column if it is known that typical predicates for a column has different selectivities from the defaults.
Workaround Description
 There are 3 workarounds



1) use dynamic mode in the java config file to allow parameters to be used by the optimizer to use histogramming for more accurate estimates.



2) Another workaround could be to set the optimizer concurrency threshold to -1 so that table scans are avoided, but the downside would be that an index scan would be used in cases where a table scan could be much more efficient (i.e. avoiding 1 data page lookup per index row possibly looking up the same data page multiple times and thrashing on the buffer cache, vs looking up the data page once in the table scan)



3) enable the statement cache so java parameterized language statements provide values to the optimizer so that histogramming can be used instead of magic numbers for selectivity estimates.



CR:740883
CR Number:   740883
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Close it as 'not to be fixed' since sybmigrate need target server is a newly installed server.



CR:740909
CR Number:   740909
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2013 Fixed
Description
Error 913:"Could not find row in sysdatabases with database id 4" observed while creating database asynchronously.



CR:740957
CR Number:   740957
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 14 Jul 2013 Fixed
15.7 SP121 17 Dec 2013 Fixed
17 Jan 2014 Fixed
Description
The message "current process infected with 11" in the module 'LeBulkOpOpenCleanup' together with a stack trace which includes the module 'LeBulkOpOpen' may be reported in the error log while migrating data from one platform to another using sybmigrate.



CR:740987
CR Number:   740987
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2013 One-off Provided
15.7 SP110 02 Jul 2013 Fixed
15.7 SP60 23 Jul 2013 Fixed
Description
In rare circumstance, the size of non-unique indexes on DOL tables may grow very quickly if lots of data is inserted, or the index columns are updated frequently.



CR:741021
CR Number:   741021
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2014 Fixed
20 Feb 2014 Fixed
Description
Buffer pool wash size increments unexpectedly for user defined caches when remote node is booted



CR:741044
CR Number:   741044
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 17 Jun 2013 Fixed
26 Jun 2013 Port Not Needed
Description
The message "'<version>' is not a valid target for downgrade." may be reported when downgrade to ESD2 or ESD3 using sp_downgrade_esd.



CR:741063
CR Number:   741063
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 05 Jun 2013 Fixed
Description
The 6914 message, "Procedure 'sp_dump_info', The parameter 'Invalid pointer param number 1, pointer value 0x000000000000000A' is not a valid dump type", will be raised if an invalid dump type is passed to the stored procedure sp_dump_info.



CR:741071
CR Number:   741071
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 13 Jun 2013 Fixed
15.7 SP110 14 Jun 2013 Fixed
27 Jun 2013 One-off Provided
13 May 2014 One-off Provided
Description
When executing a subquery with a scalar aggregate, ASE may fail to clean up resources and terminate processing after an attention thus leading to an 803 error.



CR:741079
CR Number:   741079
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2013 Third Party Problem
27 Aug 2013 Third Party Problem
27 Aug 2013 Third Party Problem
Description
sp_sendmsg is much slower on AIX than other platforms.



CR:741105
CR Number:   741105
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 16 Jun 2013 Fixed
15.7 SP102 16 Jun 2013 Fixed
Description
The message, "Current process infected with signal 11", together with a stack trace that includes the module scan_getrow() may be reported in the error log when executing DBCC CHECKTABLE if a shrink-database operation is not completed and the dataserver is rebooted.



CR:741160
CR Number:   741160
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2013 One-off Provided
19 Jun 2013 Bundled Request
29 May 2014 Port Not Needed
Description
ASE hits signal 11 in canlisten_on_othereng(), which is triggered when an engine on which a listener is running becomes non-responsive.
Workaround Description
 First increase configuration for:



sp_configure "workload manager cache size", 200



and then change the configuration option for "max online engine".



CR:741178
CR Number:   741178
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 12 Jun 2013 Fixed
15.7 SP110 24 Jun 2013 Fixed
Description
An 806 error, "Could not find virtual page for logical page <pagenum> in database <dbid>", may be reported in the error log with a stack trace which includes the modules bufnewpage(), quitfn() and log_to_virt() if a session is killed while executing a query that required a work table creation in the tempdb database, or, required page allocations in a different database.



CR:741191
CR Number:   741191
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 10 Jun 2013 Fixed
15.7 SP102 16 Jun 2013 Fixed
Description
Under some rare circumstances, a shrink-database operation can encounter errors of index not consistent on DOL tables and little endian platform.



CR:741214
CR Number:   741214
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request: Include SSQLID in monProcessStatement
Workaround Description
 You can do this currently as follows:



dbcc traceon(3604)

dbcc sqltext(<spid>)



Which gives output like this:



SQL Text: select * from test..t1



Executing procedure: *ss1137874382_1262752346ss*

Subordinate SQL Text: select * from test..t1



The second number in the procedure name is the hash key for the statement cache: 1262752346

So you can then do:



select SSQLID from monCachedStatement where Hashkey = 1262752346



CR:741228
CR Number:   741228
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2013 Not a Bug
Description
Update on proxy table fail to update right number of rows.
Workaround Description
 // disable all Omni optimizations

dbcc traceon(11298)

go



CR:741229
CR Number:   741229
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2013 One-off Provided
15.7 SP50 19 Jun 2013 Fixed
15.7 SP110 26 Jun 2013 Fixed
Description
Permission denied errors might be reported when executing nested stored procedures if unrelated roles are modified.



CR:741239
CR Number:   741239
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 21 Jun 2013 Fixed
15.7 SP50 18 Jun 2013 Fixed
15.7 SP102 18 Jun 2013 Fixed
Description
In some cases, runtime rollback of a transaction that is done in parallel (parallel CREATE INDEX, SELECT INTO, REORG REBUILD or ALTER TALBLE (with data copy)) will be incomplete leaving the database in an inconsistent state.
Workaround Description
 If parallel operations are being used post 15.7 ESD 4.2 the 3968 (serverwide) trace flag must be turned on, to disable the log jumping optimisation.



CR:741256
CR Number:   741256
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An CIS query may fail with 7732 error on remote server:

"The UPDATE/DELETE WHERE CURRENT OF failed for cursor '%.*s' because the curso

r is read only."



The CIS query looks like:

"UPDATE PROXY_TABLE ... FROM LOCAL_TABLE, PROXY_TABLE where ..."



For the invalid query plan which caused 7732 error, it has join order proxy_table -> local_table,

ORDER BY join_column clause is added for the partial query sent to remote server,

remote server declared a cursor using a statement looks like:

SELECT ... FROM ... ORDER BY ... FOR UPDATE OF ...



This issue is related to a known CR 652032: "Allow positioned updates when ORDER BY is used".



Please force a valid plan via a valid abstract plan or force join order via 'set forceplan on' to work around this 7732 error.
Workaround Description
 Force join order via 'set forceplan on' or use a valid abstract plan.



CR:741278
CR Number:   741278
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 19 Jun 2013 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module ra__store_last_rs_error() may be reported in the error log if multiple Rep Agent threads are started on the same database at the same time.
Workaround Description
 Don't run multiple sp_start_rep_agent commands on the same database at the same time.



CR:741286
CR Number:   741286
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: extend sp_checkreswords to sysroles and master..syssrvroles



CR:741302
CR Number:   741302
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customers would like a feature to refresh an IMDB from its template without restarting the ASE or recreating the database.
Workaround Description
 Restart the ASE

recreate the IMDB



CR:741330
CR Number:   741330
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 02 Jul 2013 Fixed
15.7 SP110 03 Jul 2013 Fixed
15.7 SP50 02 Jul 2013 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the modules sparclock() and kssolnetctlrWaitForCompletion() may be reported in the error log when SAP ASE is running in the threaded kernel mode on the Solaris operating system after which the ASE may become non-responsive. This issue only affects SAP ASE on the Solaris platforms.



CR:741350
CR Number:   741350
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 11 Jun 2013 Fixed
Description
The stored procedure sp_helprotect does not display a row for built-in function asehostname for a user who has been granted SELECT on the built-in function.



CR:741352
CR Number:   741352
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 26 Jun 2013 Fixed
15.7 SP102 21 Jun 2013 Fixed
Description
Under rare circumstances the Rep Agent may report a 9219 error with state number 61, "RepAgent(<dbid>): Internal coding error", when processing LOB data resulting in the Rep Agent termination.



CR:741365
CR Number:   741365
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_configure output display extra spaces on run value , config value with

non-unique parameter or with an individual parameter

on ASE 15.7 SP100 release



CR:741368
CR Number:   741368
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 14 Jul 2013 Fixed
Description
If DDL IN TRAN is turned on and some indexes are created in an uncommitted transaction, then concurrent DBCC CHECKDB, DBCC CHECKTABLE or DBCC CHECKINDEX that involves the table will hang.



CR:741386
CR Number:   741386
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 23 Jul 2013 Fixed
15.7 SP110 19 Jun 2013 Fixed
Description
Schema creation is incorrectly logged for DDL replication if the CREATE SCHEMA is not the only statement in the batch and when the statement cache is ON.



CR:741389
CR Number:   741389
Product Name:   Sybase ETL
Product Component:   CDC
Status:   Open
OS:   Windows 2003
Original Version:   Denali
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Trying to 'create replication' in the CDC Provider for Replication Server Sybase after making sure database the source table is in has been added to replication server's definitions with rs_init errors out with '<source db> has not been added to replication system'



CR:741426
CR Number:   741426
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 20 Jun 2013 Fixed
24 Jun 2013 One-off Provided
15.7 SP110 25 Jun 2013 Fixed
Description
The messages, "ncheck: select, Operation not applicable" or "poll() returned 32 on socket <#>" may be repeatedly reported in the errorlog after an ASE listener has migrated from a non-responsive engine.
Workaround Description
 Add all the listeners into interfaces file and do not spawn a new listener via sp_listener, i.e



(content of interfaces file should have something like):



start_all_servers

master tcp ether <hostname> 7800

master tcp ether <hostname> 7801

master tcp ether <hostname> 7802



CR:741439
CR Number:   741439
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 13 Jun 2013 Fixed
15.7 SP102 14 Jun 2013 Fixed
Description
A 4306 error, "There was activity on database since last load, unable to load", may be reported when loading a database or transaction log dump of a database whose size is smaller than the target database into which it is being loaded, thereby breaking the load sequence.



CR:741451
CR Number:   741451
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 19 Jun 2013 Fixed
15.7 SP102 17 Jun 2013 Fixed
15.7 SP50 20 Jun 2013 Fixed
Description
A 691: "Encountered invalid logical page '<page>' while accessing <partition>. This is an internal system error. Please contact Sybase Technical Support." error followed by a stack trace that contains the modules getpage_with_validation() and wrongpage() may be reported in the error log under the following conditions:

(1) The configuration option "streamlined dynamic SQL" is enabled, either directly or by enabling functionality group and

(2) A dynamic prepared INSERT or UPDATE statement is executed on a table that has been created with deferred_allocation and

(3) The prepared statement has been executed successfully at least once and

(4) The target table that is inserted/updated is dropped and re-created as a defered_allocation table and

(5) The dynamic INSERT/UPDATE query is re-executed from the same ASE connection.
Workaround Description
 turn off 'deferred table allocation' for the database



CR:741461
CR Number:   741461
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2013 Bundled Request
Description
When ASE attempts to write a CSMD (configurable shared memory dump) after a failure, it fails to halt and resume the engine threads with the error, "SuspendThread failed for thread (n), error 6".



CR:741478
CR Number:   741478
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2013 Fixed
19 Jul 2013 Bundled Request
Description
Option to export already cached results instead of fetching complete results from the server.



CR:741481
CR Number:   741481
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 21 Jun 2013 Fixed
15.7 SP110 01 Jul 2013 Fixed
30 Jun 2013 One-off Provided
Description
An 804 error, "Unable to find buffer <buffer_address> from cache <cachename> holding logical page <pageno> in sdes <sdes_address> kept buffer pool for object <objname>", may be raised under heavy load of concurrent DMLs when the log is nearly full.



CR:741487
CR Number:   741487
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 14 Jun 2013 Fixed
15.7 SP60 02 Aug 2013 Fixed
Description
A timeslice error followed by a stack trace that involves the module buf__unhash_and_keep_grabbed_mass() may be reported in the error log during HASH based statistics gathering.



CR:741605
CR Number:   741605
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
In some situations, LOAD DATABASE recovery may fail with error 2620, severity 21, state 3, reporting that redo of an APL index insert log record could not be processed. This is likely to occur if the transaction causing the APL index page split were to rollback at run-time while the DUMP DATABASE was performed concurrently.



CR:741621
CR Number:   741621
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 02 Jul 2013 Fixed
27 Jun 2013 One-off Provided
15.7 SP110 27 Jun 2013 Fixed
Description
SAP ASE reports invalid process status messages like "kpsched: kpid 1962483841 bad status 0x400414" followed by "upstatus: kpid = 1962483841, status 0x400414 not valid". The exact bad status may vary across messages.



CR:741677
CR Number:   741677
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 27 Jun 2013 Fixed
Description
Under some conditions in threaded kernel mode, when the ASE task is blocked in some OS call, it can hit timeslice error if the thread gets a SIGUSR1 signal.



CR:741711
CR Number:   741711
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
increase default stacksize.
Workaround Description
 sp_configure "stack size", XXXXX

go



CR:741717
CR Number:   741717
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
cepheus 18 Jul 2013 Fixed
Description
Collect PartitionID information in monDeadLock, monLockTimeout, clmdiag



CR:741742
CR Number:   741742
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 02 Aug 2013 Fixed
30 Jul 2013 Reservation Made
Description
When a small table (number of rows is less than twice the number of steps in the histogram) has a unique index, the range density and range unique values may be inaccurate on the column set for the unique index. This costing change is enabled with optcriteria cr741742.



CR:741751
CR Number:   741751
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2013 Fixed
15.7 SP121 16 Dec 2013 Fixed
08 Jan 2014 Port Not Needed
Description
Under rare circumstances, the SAP ASE Cluster Edition keeps running into a lock lookup error and may hang. In the SAP ASE errorlog there will be messages such as "Cluster lock manager of instance 1 has received an invalid lookup request for directory instance 1 from instance 4"



CR:741759
CR Number:   741759
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2013 Fixed
25 Jun 2013 Fixed
27 Jun 2013 Fixed
19 Jul 2013 Fixed
31 Jul 2013 Fixed
31 Jul 2013 Reservation Made
04 Aug 2013 Fixed
15.7 SP121 26 Aug 2013 Fixed
15.7 SP121 27 Aug 2013 Fixed
28 Nov 2013 Fixed
Description
Enhance DBCC LOG to support specifying a start marker for the log scan when searching for log records affecting a page, or log records for a transaction. For some usages, the (indid, ptnid) arguments are over-loaded to specify a start (log page#, row #) marker for the log scan. Extend DBCC HELP('log') output to reflect the entire set of options, arguments and variations. Various other improvements to the scan filtering for DBCC LOG added.



CR:741770
CR Number:   741770
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP50 19 Jun 2013 Fixed
15.7 SP110 26 Jun 2013 Fixed
20 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
Description
The error message, "Could not execute login script for user sa", may be reported in the error log when the global login trigger is updated with a new login trigger.
Workaround Description
 Use a new login trigger with an object name that is longer than the current name



CR:741786
CR Number:   741786
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 19 Jun 2013 Fixed
25 Jun 2013 One-off Provided
15.7 SP60 09 Jul 2013 Fixed
24 Jul 2014 Fixed
Description
A 706 error, "Process <pid> tried to remove PROC_HDR <phdr> that it does not hold in Pss", may be encountered when an SQL statement is executed and it is either stored in the SQL statement cache or it is a dynamic SQL statement and during execution a regeneration of the statement query tree from SQL text is required and an exception is encountered during the parsing of the corresponding SQL text.



CR:741799
CR Number:   741799
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 26 Jul 2013 Fixed
15.7 SP110 30 Jul 2013 Fixed
30 Jul 2013 Fixed
Description
The Sybmon restart command fails with an error, "Unknown command", when executed without specifying an engine number for a server running in process kernel mode.
Workaround Description
 Issue the restart command for each engine individually.



CR:741822
CR Number:   741822
Product Name:   Sybase SQL Server
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2013 Fixed
11 Dec 2013 Port Not Needed
Description
When create a huge size database(data size > 63G), stack trace including module pg__gam_extend() may be detected. For example executing statement as "create database testdb on ldev1='50m', #nulldev='7t', ldev2='50m' log on ldev3='50m'", it will hit the stack trace.



CR:741847
CR Number:   741847
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 01 Jul 2013 Fixed
18 Jul 2013 Fixed
15.7 SP60 20 Aug 2013 Fixed
Description
The 3051 message, "The dump configuration '' supplied for DUMP DATABASE is invalid", can be mistakenly returned for the valid dump configuration which has a 30 bytes long name.



CR:741871
CR Number:   741871
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 01 Jul 2013 Fixed
Description
The sp_downgrade_esd stored procedure cannot be used to downgrade to ASE 15.7 SP50.



CR:741894
CR Number:   741894
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP102 21 Jun 2013 Fixed
15.7 SP110 03 Jul 2013 Fixed
21 Jun 2013 Reservation Made
Description
When DDL replication is ON, the execution of a DDL command as a prepared statement aborts with error 11314. Trace flag 9152 can be used to allow the DDL command to proceed without being replicated.



CR:741900
CR Number:   741900
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Windows
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2013 Duplicate
Description
Dump database to TSM API may fail on Windows with the error message:



CR:741901
CR Number:   741901
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 21 Jun 2013 Fixed
15.7 SP60 08 Jul 2013 Fixed
24 Jun 2013 Fixed
Description
When a CREATE INDEX command is executed and the following conditions are met, (1) The configuration option, 'enable functionality group' is on and (2) The table upon which the index is being created has datarows locking scheme and (3) The first index-key column contains at least one NULL value and (4) a Lava parallel execution plan is used, then the resulting index may be missing rows for the NULL-valued columns.
Workaround Description
 use traceflag 549.



CR:741910
CR Number:   741910
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 31 Jul 2013 Fixed
15.7 SP121 21 Oct 2013 Fixed
02 Dec 2013 Fixed
15.7 SP111 07 Mar 2014 Fixed
Description
Enable a login with mon_role to execute sp_monitorconfig on SAP ASE 15.7



CR:741924
CR Number:   741924
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 01 Jul 2013 Fixed
15.7 SP110 28 Jun 2013 Fixed
15.7 SP102 28 Jun 2013 Fixed
15.7 SP50 02 Jul 2013 Fixed
04 Jul 2013 Fixed
Description
An undetected deadlock might occur between a process that ran out of syslogs space and has crossed the last chance syslogs threshold and another process that is attempting to expand the syslogs size by executing an ALTER DATABASE command. The output of dbcc stacktrace(<spid>) command for one of these two processes will show the modules 'th_sleep_on_lct' and 'upsleepgeneric' whereas for the other process the modules 'writeLock' and 'upyield'. An SAP ASE restart is needed to unblock this situation.
Workaround Description
 Set the database option 揳bort tran on log full to TRUE. This option is not set by default.



CR:741934
CR Number:   741934
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2013 Fixed
15.7 SP121 21 Aug 2013 Fixed
15.7 SP110 22 Aug 2013 Fixed
Description
In rare circumstances, a time slice error may be reported in the error log followed by a stack trace which includes the modules ind_ides_init() and ind__ides_install() while DBCC TUNE ('des_bind') is executed concurrently with utility commands such as CREATE TABLE that is run at isolation level 0.



CR:741942
CR Number:   741942
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SIGSEGV in LeOrScanContext::getNextVtup().



CR:741950
CR Number:   741950
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2013 Added to user documentation
Description
Doc CR: please clarify that checkverify reads the suspect faults



CR:741953
CR Number:   741953
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2013 Not a Bug
Description
checkstorage and checkverify reporting faults inconsistently
Workaround Description
 sp_dbcc_faultreport "long", "dbname"

instead of checkverify



CR:741959
CR Number:   741959
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 25 Jul 2013 Fixed
15.7 SP110 26 Jul 2013 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module mda__process_sdes() may be reported in the error log when querying the monProcessObject MDA table.



CR:741984
CR Number:   741984
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 12 Jul 2013 Fixed
Description
A stack trace may occur when a CREATE INDEX command is interrupted (using Ctrl C) and the command is being executed using a parallel Lava query plan. The stack trace may include functions such as bt_create_index(), ups_stat_memalloc(), ups_get_stat_page() and/or memalloc_auxbufarray(), bufauxinstall() depending upon which phase of the CREATE INDEX processng is active at the time of the interrupt.



CR:742008
CR Number:   742008
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 25 Jun 2013 Fixed
Description
If a database that is created WITH ASYNC_INIT option is used before it is fully initialized as the target database of a LOAD command, the execution of system stored procedure sp_helpdb will display "Allocation Unit Initializer disk fragment" entries that should have been removed.



CR:742031
CR Number:   742031
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2013 Fixed
09 Jan 2014 Presently Not Targeted For Any Future Release Of This Product
04 Feb 2014 Fixed
Description
Shutting down an instance may cause a stack trace if I/O fencing is enabled.



CR:742061
CR Number:   742061
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When trying to insert a non-null value into a timestamp column and a light-weight procedure is recompiled, the insert statement fails due to a 137 error.



CR:742074
CR Number:   742074
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2014 Insufficient Info to Progress
28 Jun 2013 Reservation Made
03 Oct 2014 Port Not Needed
Description
In limited cases when a system is under heavy load, memory could

be corrupted resulting in a self-referencing ptr in a names struct.

This can result in a process allocating the entire procedure cache

under cpynameslist(). The process cannot be killed requiring a server

reboot. A check for a self-referencing names struct has been added in

cpynameslist()and the overloaded error 7733, state 2 added if such a ptr

is found. This error can be used for configurable memdumps. This check

for a cyclic ptr reference is enabled under trace command line flag 7728.



CR:742098
CR Number:   742098
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 04 Nov 2013 Fixed
15.7 SP60 28 Oct 2013 Fixed
08 Nov 2013 Fixed
15.7 SP110 02 Nov 2013 Fixed
Description
A 1265 error, "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr=<value>, lrmagic=<value>)" together with a stack trace which includes the modules 'th_lct_admin' and 'num_logpages' may be reported in the error log if the builtin lct_admin("num_logpages", <dbid>) is executed concurrently by several processes.



CR:742139
CR Number:   742139
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2013 Fixed
15.7 SP102 28 Jun 2013 Fixed
01 Jul 2013 Reservation Made
15.7 SP110 28 Jun 2013 Fixed
Description
The message, "Current process infected with signal 11", in the module 'dam_prepare_dump_end' together with a stack trace which includes the modules 'dpdb_main' and 's_execute' may be reported in the error log when a DUMP DATABASE command is executed and the database option 'allow incremental dumps' is enabled and the system table SYSDAMS contains an extent that is the first extent of an allocation unit causing this table to have a number of pages that is not a multiple of 8.
Workaround Description
 Please, be aware that this workaround is to avoid hitting the problem.

Once you hit the problem you are in troubles because you can have a transaction

in the log that will avoid you can recover the database when you reboot, or that

you can recover the database if you dump it (after disabling cumulative dumps)

and load it somewhere else. We would need a way to get rid of the bad XREC_PAGEIMAGE record.

With this fix, we are including the trace flag 3334 that could be used to skip

this transaction. If the server has not been shutdown since the problem was found

and the database is still usable, you could use a page editor (sybedit or

/usr/u/cruiz/tools/CHPAGE/chpage*) tool to edit the log page reported the 3478 error,

get the record offset by looking at the dbcc log() output, and using

this offset + 2 bytes, replace the op 85 (0x55) value for XREC_PAGEIMAGE

by 10 (0x0A) for XREC_NOOP. This way, if you reboot, this record will be skipped.



If you have not hit the problem yet, you will know that you will potentially

hit it if the number of pages in sysdams is not a multiple of 8.



A possible workaround would be to recreate sysdams and hope it's created

in a different extent. The following procedure can be repeated until we get

a table with a number of pages multiple of 8:



1) Verify that this is your problem:



dbcc traceon(3604)

go

declare @firstpage unsigned int

select @firstpage=firstpage from syspartitions where id=58

dbcc pglinkage(<dbname>,@firstpage,0,2,0,1)

go



2) Assuming you have a number of pages that is not < multiple of 8



dbcc traceon(3604)

go

dbcc traceon(3717)

go

dbcc dam(test,抎rop)

go

create table t(a text)

go

-- Insert some rows expecting that the space

-- previously used by sysdams is reused by this table

-- we will insert 100 rows, but if the allocation of

-- sysdams later shows again that we picked up the

-- first extent from the alloc unit, you may have

-- to insert more or less rows.....

insert t values(揳)

go 100

dbcc dam(test,抍reate)

go

drop table t

go

declare @firstpage unsigned int

select @firstpage=firstpage from syspartitions where id=58

dbcc pglinkage(<dbname>,@firstpage,0,2,0,1)

go



Verify that the table has now a multiple of 8, and if not, repeat this

process changing the number of rows inserted in the table 't'.



3) If, in the very unlikely case of a brand new system that gets the table

SYSDAMS created with less than 16 pages (it has to be exactly 16 pages), because

this table would be copied to any new database, we would have to apply the workaround

explained in 2 to the model database.



CR:742143
CR Number:   742143
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 11 Sep 2013 Fixed
15.7 SP121 09 Sep 2013 Fixed
15.7 SP110 09 Sep 2013 Fixed
Description
The nested level of functions in expressions has been raised from 10 to 32.



CR:742152
CR Number:   742152
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jul 2013 Fixed
04 Jul 2013 Fixed
07 Jul 2013 Fixed
05 Jul 2013 Fixed
10 Jul 2013 Fixed
15.7 SP110 15 Jul 2013 Fixed
15.7 SP60 16 Jul 2013 Fixed
17 Jul 2013 Fixed
Description
On a server that has a large number of objects, the sp_sysmon report may take a long time to complete and error message 1508, "Create index aborted on duplicate rows. Primary key is <keyname>", may be reported in the error log.
Workaround Description
 Modify sp_sysmon to eliminate the "Socktab Spinlock[i]" spinlocks from the #temp_sysmon_baseline table. This doesn't affect any of the sp_sysmon metrics as far as we can tell.

For the query:



insert into #temp_sysmon_baseline

select group_name, field_id, value

from master.dbo.sysmonitors holdlock

Add a where clause:



insert into #temp_sysmon_baseline

select group_name, field_id, value

from master.dbo.sysmonitors holdlock

/* adding the following to work around Err 1508 */

where field_name <> "Socktab Spinlock[i]"

/* end workaroud for Err 1508 */



CR:742158
CR Number:   742158
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 01 Oct 2013 Fixed
30 Sep 2013 Fixed
01 Oct 2013 Reservation Made
15.7 SP121 03 Oct 2013 Fixed
Description
If 'literal autoparam' is enabled, the sometimes a print statement that uses a literal in a stored procedure could lead to remap error 2805 'Bad pointer 0x%p encountered while remapping stored procedure '%.*s'. Must re-create procedure.'.
Workaround Description
 Remove the print statement noted in the CR description.



- or -



Edit the procedure so that the parameters to the print statement noted in the CR description are

all constants, rather than a mix of constants and literals.



- or -



Avoid the combination of abstract plan load = 1 and enable literal autoparam = 1



CR:742168
CR Number:   742168
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 19 Jul 2013 Fixed
15.7 SP60 29 Jul 2013 Fixed
Description
When SAP ASE is running in process mode, if the dynamic listener is on a hung engine, SAP ASE may continuously report , "necheck: select, Bad file descriptor" in the errorlog.



CR:742191
CR Number:   742191
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2013 Fixed
26 Jul 2013 Fixed
15.7 SP110 01 Aug 2013 Fixed
24 Jul 2014 Fixed
25 Jul 2014 Port Not Needed
Description
SAP Adaptive Server may hang without reporting an error when the pool of locks is exhausted.
Workaround Description
 Increase configuration parameter 'number of locks' and restart Adaptive Server

to workaround the problem.



CR:742199
CR Number:   742199
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2013 Duplicate
Description
Procudure sp_versioncrack does not handle new SAP SP style version string (from ASE 15.7 SP100).
Workaround Description
 Use updated procedure from /remote/cases/11792000s/11792121 in file versioncrack_corrected.sql



CR:742216
CR Number:   742216
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 02 Jul 2013 Fixed
08 Jul 2013 Deferred
15.7 SP60 03 Jul 2013 Fixed
Description
Booting an SAP ASE may fail permission checks with an error message, "Permission denied, database master, owner dbo. You need the following permission(s) to run this command: MANAGE SERVER CONFIGURATION", when the configuration parameter 'enable granular permissions' is set in the default configuration file.



CR:742226
CR Number:   742226
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP110 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 09 Sep 2013 Fixed
09 Sep 2013 Reservation Made
15.7 SP110 10 Sep 2013 Fixed
09 Sep 2013 Reservation Made
Description
Support of DDL replication for prepared DDL statements is now provided. This is enabled by trace flag 16984.



CR:742233
CR Number:   742233
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 28 Jun 2013 Fixed
15.7 SP60 02 Jul 2013 Fixed
Description
Incorrect results can be reported with 'streamlined dynamic SQL' on when using a subquery not containing a table reference to check for no rows returned. This can affect SQl constructs that include (but not limited to) isnull, nullif, case, if not exists & coalesce.



CR:742249
CR Number:   742249
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 19 Jul 2013 Fixed
15.7 SP60 28 Jul 2013 Fixed
Description
With single engine configurations, a SAP ASE polite shutdown request may hang if the JS Agent is executing a job whose spid is set to LOW priority.
Workaround Description
 start up ASE with more than 1 engine (syb_default_pool with number of threads more than 1)



CR:742263
CR Number:   742263
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 02 Jul 2013 Fixed
Description
The error 14108, "Could not find partition descriptor for objid, indid -1, ptnid in dbid" may be reported when either the command DBCC DBSHUTDOWN or DBCC FAILBACK_DBSHUTDOWN is executed and the database option 'allow incremental dumps' is enabled in the given database.



CR:742292
CR Number:   742292
Product Name:   Adaptive Server Enterprise
Product Component:   sybmon
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 04 Jul 2013 Fixed
04 Jul 2013 Fixed
15.7 SP110 07 Jul 2013 Fixed
15.7 SP60 04 Jul 2013 Fixed
Description
Sybmon might get hang with huge garbage SQL text printed when running "sample context=y" command.
Workaround Description
 Avoid using context=y with sybmon's sample command.



CR:742310
CR Number:   742310
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 08 Jul 2013 Fixed
Description
After running DUMP DATABASE, the time stamp of some pages may become incorrect. If DBCC CHECKSTOREAGE is subsequently executed, error message "Fault Type: 100004 (timestamp error); Hard fault" may be reported.



CR:742312
CR Number:   742312
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 02 Jul 2013 Fixed
15.7 SP51 10 Sep 2013 Fixed
15.7 SP110 13 Sep 2013 Fixed
15.7 SP121 17 Sep 2013 Fixed
Description
DDLGen generates duplicate partition values when a range or a list partitioned table has a local index
Workaround Description
 create the table with more than 1 range partition



CR:742352
CR Number:   742352
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2013 Fixed
15 Jul 2013 Insufficient priority to fix
18 Jul 2013 Reservation Made
15.7 SP110 04 Aug 2013 Fixed
Description
When running the DISK INIT/RE_INIT command or the sp_deviceattr stored procedure, ASE silently ignores dsync=false if DIRECTIO is not specified.



CR:742356
CR Number:   742356
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 09 Aug 2013 Fixed
15.7 SP110 12 Aug 2013 Fixed
Description
An 803 error, "Unable to place buffer <buf> from cache <cache_name> holding logical page <page_num> in sdes for object <object_name> - either there is no room in sdes or buffer already in requested slot", may be reported when running a multiple table join under parallel processing.



CR:742376
CR Number:   742376
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 02 Jul 2013 Fixed
07 Mar 2014 One-off Provided
15.7 SP110 02 Jul 2013 Fixed
02 Jul 2013 Fixed
15.7 SP50 02 Jul 2013 Fixed
15.7 SP60 02 Jul 2013 Fixed
04 Jul 2013 Fixed
Description
The built-in function set_appcontext() mistakenly allows the update of an attribute without running rm_appcontext().



CR:742407
CR Number:   742407
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 08 Jul 2013 Fixed
02 Jul 2013 Reservation Made
02 Aug 2013 One-off Provided
19 Aug 2013 One-off Provided
13 Sep 2013 One-off Provided
15.7 SP51 10 Sep 2013 Fixed
15.7 SP103 11 Sep 2013 Fixed
15.7 SP60 17 Sep 2013 Fixed
15.7 SP110 17 Sep 2013 Fixed
15.7 SP121 19 Sep 2013 Fixed
23 Oct 2013 Fixed
Description
Add extra diagnostics for the data change fragment pool in order to help catch incorrect memory accesses of the data change fragment pool and thus also improve robustness.



CR:742434
CR Number:   742434
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 29 Oct 2013 Fixed
15.7 SP121 31 Oct 2013 Fixed
31 Oct 2013 Fixed
Description
The message "current process infected with 11" in the module 'pthread_kill' together with a stack trace will be reported in the error log on Linux platforms only, when the Java option is enabled, the Kernel mode is set to process mode, and the PCI option is disabled.



CR:742485
CR Number:   742485
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   DYNIX/ptx
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 02 Aug 2013 Fixed
03 Jul 2013 Fixed
15.7 SP121 03 Oct 2013 Fixed
Description
If 'stack size' is configured too small, sometimes it could lead to error, 'Stack guardword corrupted', with OmniQuickPass::generateSelect(), OmniQuickPass::generateStatement() in the stacktrace when select large number of columns for a remote table.



CR:742515
CR Number:   742515
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2013 Fixed
15.7 SP110 03 Jul 2013 Fixed
02 Jul 2013 Reservation Made
Description
RepAgent may not send table schema information to Replication Server if the table contains a compressible LOB column. RAT may also wrongly consider that a table contains a compressible column when it has sent the table schema to Replication Server.



CR:742541
CR Number:   742541
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2013 Reservation Made
15.7 SP121 16 Sep 2013 Fixed
14 Nov 2013 Fixed
Description
New 'force' option to the kill command to forcibly kill the spid.



CR:742603
CR Number:   742603
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.7 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 14 Jul 2013 Fixed
15.7 SP110 15 Jul 2013 Fixed
24 Jul 2014 Fixed
Description
The PhysicalReads value in the monProcessActivity and monProcessStatement MDA tables do not include APF Reads. The PagesRead value in the monProcessActivity MDA table is also incorrect.



CR:742623
CR Number:   742623
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
drop proxy table will cause the object definition to be dropped too



CR:742643
CR Number:   742643
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
infected with 11 in LeScanOp::LeGetScanInd





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------