远程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:747189
CR Number:   747189
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   Microsoft Windows
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 07 Nov 2013 Fixed
Description
Password echo on console when entering it using auditinit in sa login screen.



CR:747209
CR Number:   747209
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 22 Sep 2013 Fixed
24 Oct 2013 Presently Not Targeted For Any Future Release Of This Product
24 Oct 2013 Presently Not Targeted For Any Future Release Of This Product
20 Oct 2013 One-off Provided
15.7 SP60 28 Oct 2013 Fixed
27 Nov 2013 Port Not Needed
15.7 SP111 27 Feb 2014 Fixed
Description
The builtin function MAX() may return an incorrect value when used with a compressed table.



CR:747218
CR Number:   747218
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request to extend shrink database functionality to allow users to load larger sparse database dumps into smaller databases by performing the shrink database during the load.
Workaround Description
 Load full database into staging ASE and run the shrinkdb process there.

Downside is this is a 2 stage process and requires duplicate of space.



CR:747251
CR Number:   747251
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 25 Sep 2013 Fixed
15.7 SP121 12 Dec 2013 Fixed
16.0 08 Jan 2014 Fixed
Description
During extreme insert load on APL tables with clustered index, during page

allocation, server might hit error 8419 as :

Error: 8419, Severity: 20, State: 3

Could not find index descriptor for objid 240003886, indid 0 in dbid 19.



CR:747368
CR Number:   747368
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
error message 15422 is misleading for select into temp table query



CR:747441
CR Number:   747441
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.0.3 ESD#4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Signal 11 on crp_var when database in 'dbo use only'
Workaround Description
 sp_dboption dbname,'dbo use only',false



CR:747444
CR Number:   747444
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 03 Dec 2013 Fixed
16.0 25 Nov 2013 Fixed
Description
Customer may see error 644 when create a temp table and hit memory

issue in the middle of update syspartitions table.



CR:747463
CR Number:   747463
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 02 Oct 2013 Fixed
02 Oct 2013 Reservation Made
15.7 SP121 04 Oct 2013 Fixed
15.7 SP121 31 Oct 2013 Fixed
16.0 15 Nov 2013 Fixed
16.0 18 Nov 2013 Fixed
15.7 SP111 28 Feb 2014 Fixed
Description
Alter table add/drop partition command gets 4956 error while level 0 scans are active. This new feature is enabled when the new configuration option 'enable utility lvl 0 scan wait' is set.



CR:747507
CR Number:   747507
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 SP121 06 Nov 2013 Fixed
16.0 19 Nov 2013 Fixed
Description
UPDATE a column referenced by a materialized computed column after an ALTER table modifying a column may corrupt the computed column.
Workaround Description
 try to trigger update of a definition tree by modifying the computed column just using current exact definition.



for the example in Reproduction,

before UPDATE but after ALTER table, execute

alter table t1 modify CC AS col2 + col3 materialized



CR:747572
CR Number:   747572
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 08 Oct 2013 Fixed
16.0 28 Nov 2013 Fixed
Description
100001 faults (Invalid page ids in header) may be reported for DOL tables by dbcc checkstorage()

if it's run after shrink database operation.



CR:747591
CR Number:   747591
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2014 Fixed
04 Apr 2014 Fixed
02 Apr 2014 Fixed
Description
MERGE into statement with columns having decrypt defaults in their ON clause may not produce expected results when the user does not have decrypt permission.



CR:747648
CR Number:   747648
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 21 Oct 2013 Fixed
16.0 07 Nov 2013 Fixed
15.7 SP60 05 Nov 2013 Fixed
15.7 SP110 02 Nov 2013 Fixed
21 Dec 2013 One-off Provided
24 Jul 2014 Fixed
Description
A 3478 error: "During undo the page timestamp value is less than new timestamp from log...", or a 3474 error: "During redo the page timestamp value is less than old timestamp from log...", or a 12337 error: "Page <pageid> in database <dbname> was incorrectly found to be uninitialized when it was read. Recovery of this database cannot continue." may sometimes be reported during recovery if the server crashed while a transaction doing a CREATE TABLE operation was rolling back.
Workaround Description
 Boot the server, or LOAD DATABASE with the 3412 trace flag turned on.



CR:747678
CR Number:   747678
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
request to add column to monSysStatement containing dbid that the proc was called in



CR:747686
CR Number:   747686
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP51
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 01 Oct 2013 Fixed
16 Dec 2013 Port Not Needed
Description
sybrestore is not able to restore databases when the source server is 15.7 SP50 or 15.7 SP51 version



CR:747731
CR Number:   747731
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 SP50
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2013 Duplicate
29 May 2014 Port Not Needed
Description
Under rare circumstances, when a query plan with one or more hash joins is re-executed and one or more join keys from the outer/left side of the hash join are converted to be datatype compatible with join keys from the inner/right side of the hash join, then pages in the data cache that tempdb is bound to may get corrupted. Hash joins are enabled by default in the allrows_dss optgoal mode, otherwise they must be explicitly enabled in order for them to be used.
Workaround Description
 Use optimization goal allrows_mix

(hash join is off by default for optimization goal allrows_mix and allrows_oltp)



Or

'set hash_join off' for queries which have join columns on different datatypes, e.g.

select .....

from tab_a, tab_b

where tab_a.column_int_datatype = tab_b.column_bit_datatype

and ....



CR:747758
CR Number:   747758
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 14 Oct 2013 Fixed
16.0 17 Nov 2013 Fixed
Description
In HADR configuration:

1. If the length of hostname and port number together are equal to or more than 30 characters, login redirection fails.

2. SAP ASE runs into different issues when server options are changed using sp_serveroption for HADR_GROUP class(17) entry in sysservers.



CR:747778
CR Number:   747778
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 03 Oct 2013 Fixed
15.7 SP121 30 Oct 2013 Fixed
16.0 07 Nov 2013 Fixed
Description
After loss of ASE_ENCRYPTION license, DROP ENCRYPTION KEY generates a segmentation violation and stacktrace.



CR:747816
CR Number:   747816
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Open
OS:   all
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
there is no indications in the optdiags that update statistics table partition was performed. customer requests that we add that functionality somewhere.



CR:747920
CR Number:   747920
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2013 Not a Bug
Description
Load of master database receives numerous 2601 errors and two 9007 errors before shutting down, recovery of master then fails with a 605 error.



CR:747948
CR Number:   747948
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2014 Fixed
18 Mar 2014 Fixed
Description
There may be inconsistencies in the values reported between the monProcedureCacheModuleUsage and monProcedureCacheMemoryUsage tables.



CR:747977
CR Number:   747977
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 02 Oct 2013 Fixed
16.0 11 Nov 2013 Fixed
24 Jul 2014 Fixed
Description
The command ALTER DATABASE will fail silently to extend a database that is offline if the database dump is from an SAP ASE version where the table SYSDAMS did not exist.
Workaround Description
 Alter the database before loading it.



CR:747983
CR Number:   747983
Product Name:   SCC Web Framework
Product Component:   Repository
Status:   Closed
OS:   Generic
Original Version:   3.2.7 ESD2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2013 Fixed
01 Oct 2013 Fixed
07 Oct 2013 Fixed
01 Oct 2013 Fixed
02 Oct 2013 Fixed
02 Oct 2013 Fixed
Description
SCC 3.2.8 and earlier releases are affected by an issue where an internal repository table has been seeded with dates through 9/30/2013. The included fix provides a startup check which determines if the affected table requires an update and, if so, automatically updates with new entries.



CR:747990
CR Number:   747990
Product Name:   ASE Management
Product Component:   Administration Agent Plugin
Status:   Open
OS:   Generic
Original Version:   TBD
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
customers are wanting global options to manage alerts for multiple servers instead of having to setup an alert for each ASE instance individually.



CR:748000
CR Number:   748000
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 18 Oct 2013 Fixed
15.7 SP121 21 Oct 2013 Fixed
30 Oct 2013 One-off Provided
15.7 SP110 24 Oct 2013 Fixed
16.0 17 Nov 2013 Fixed
Description
SAP ASE running in process kernel mode may hang waiting for disk IO completion.
Workaround Description
 1. Use threaded mode

2. configure disk i/o structures (and max async *) high enough to not run out/scavenge.



CR:748008
CR Number:   748008
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 05 Dec 2013 Fixed
16.0 11 Dec 2013 Fixed
Description
Signal 11 in alt__lock_fix_computedcol
Workaround Description
 Drop functional indexes and recreate after an upgrade or insert a dummy row into the table to fix the index before doing the alter table.



CR:748021
CR Number:   748021
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 17 Oct 2013 Fixed
06 Nov 2013 Added to user documentation
Description
Add an option to disable the session-level lock wait period to the 'set lock wait' command.



CR:748027
CR Number:   748027
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 25 Oct 2013 Fixed
15.7 SP121 29 Oct 2013 Fixed
21 Nov 2013 Bundled Request
21 Nov 2013 Bundled Request
15.7 SP60 11 Nov 2013 Fixed
27 Jun 2014 Bundled Request
21 Jul 2014 Port Not Needed
21 Jul 2014 Port Not Needed
Description
The error IO_UNCOMPRESS_BUF_E, "The 'uncompress' call failed for database/archive device while working on stripe device <filename> with error number 0 (The operation completed successfully)." could be raised by sybmultbuf when using a block size bigger than the default.



CR:748031
CR Number:   748031
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2013 One-off Provided
15.7 SP121 07 Nov 2013 Fixed
16.0 18 Nov 2013 Fixed
07 Nov 2013 One-off Provided
11 Nov 2013 One-off Provided
15.7 SP60 28 Nov 2013 Fixed
24 Feb 2014 Bundled Request
15.7 SP111 28 Feb 2014 Fixed
20 Jan 2015 Bundled Request
20 Jan 2015 Bundled Request
Description
Avoid a rare race condition in the SAP ASE buffer handling that may result in an 839 - "Grabbed buffer dirty but not writing: <buffer info>" error.
Workaround Description
 Have suggested the customer to create tempdb_cache and bind tempdb to the new named cache to reduce the chance of 8xx errors as previous case.



CR:748045
CR Number:   748045
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 SP121 24 Oct 2013 Fixed
15.7 SP121 24 Oct 2013 Fixed
16.0 18 Nov 2013 Fixed
Description
Job scheduler upgrade sometimes hit this error failing Job Scheduler to boot :

"Execution of rule check_jsc_state failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.check_jsc_state"



CR:748055
CR Number:   748055
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The handling of numeric literals may differ between 12.5.4 and 15.7 causing unexpected arithmetic

overflows.
Workaround Description
 Append a decimal point to the literal. For example use 1000000000000000000.0 instead of

1000000000000000000



CR:748086
CR Number:   748086
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 20 Oct 2013 Fixed
15.7 SP121 18 Oct 2013 Fixed
15.7 SP60 09 Oct 2013 Fixed
Description
When DOL data pages are undergoing deallocation and table scans are concurrently executed on the table, inserts from other concurrent threads may incorrectly qualify to-be-deallocated pages.

This may lead to error: "12316: Attempt to garbage collect a deallocated data page 13407 in table 'table1_PDR', database 'onlinedb'. Aborting the transaction" could be seen.



CR:748108
CR Number:   748108
Product Name:   SCC Web Framework
Product Component:   Repository
Status:   Closed
OS:   Generic
Original Version:   3.2.7 ESD2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2013 Fixed
05 Nov 2013 Fixed
Description
In rare cases, the system network utilities return invalid values for network information causing high CPU usage for the SCC process.



CR:748258
CR Number:   748258
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 SP121 17 Oct 2013 Fixed
15.7 SP60 17 Oct 2013 Fixed
16.0 17 Oct 2013 Fixed
17 Feb 2014 One-off Provided
15.7 SP111 21 Feb 2014 Fixed
Description
A dynamic sql statement with a LIKE and ESCAPE or builtin with more than one declaration in a where clause could have a performance issue if the plan is removed from procedure cache.
Workaround Description
 run sp_recompile for table(s) frequently



CR:748282
CR Number:   748282
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR ability to force a nonclustered index to be Local



CR:748302
CR Number:   748302
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 SP120 24 Oct 2013 Fixed
16.0 15 Nov 2013 Fixed
15 Nov 2013 Fixed
Description
Logical cluster failback without a failover leaves the logical in a timed_wait state.



CR:748304
CR Number:   748304
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UX
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Opening a cursor was not allowed with online utilities like online reorg rebuild, online create index.



CR:748320
CR Number:   748320
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 28 Nov 2013 Fixed
25 Dec 2013 Bundled Request
15.7 SP121 12 Dec 2013 Fixed
24 Dec 2013 Fixed
Description
Alter table split/ move partition on a table followed by drop column with no datacopy can cause data corruption.



CR:748339
CR Number:   748339
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2013 One-off Provided
17 Dec 2013 Port Not Needed
Description
In rare circumstances, error 12308:"Invalid row id (Row %d, Page %d) encountered in the table %s in database %s" may be seen due to race condition between delete and inserts on the same page.



CR:748377
CR Number:   748377
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 23 Oct 2013 Fixed
16.0 08 Nov 2013 Fixed
16.0 03 Dec 2013 Fixed
Description
Change in number are messages being printed in errorlog.

Earlier used to print a message for every cache-partition in the cache, now it will be printed only for 1 cache-partition. This will avoid flooding messages in the errorlog.



CR:748391
CR Number:   748391
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 15 Oct 2013 Fixed
15.7 SP121 16 Oct 2013 Fixed
16.0 30 Oct 2013 Fixed
24 Apr 2014 Presently Not Targeted For Any Future Release Of This Product
Description
When tracing systabstats values using trace flag 2701, during UPDATE STATISTICS operations that reference non-clustered indices, the command may be aborted due to printing an uninitialized float value.



CR:748421
CR Number:   748421
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 SP50
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2014 Not a Bug
Description
Incorrect permissions can occur when switching beteen normal and granular permissions



CR:748423
CR Number:   748423
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 08 Oct 2013 Fixed
15.7 SP110 09 Oct 2013 Fixed
16.0 11 Nov 2013 Fixed
Description
DUMP DATABASE CUMULATIVE will silently fail when the auditing configuration option is turned on.
Workaround Description
 Disable auditing or disable cumulative dumps.



CR:748459
CR Number:   748459
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)
28 Oct 2013 Duplicate
Description
Various stacktraces and timeslices running INSERT..SELECT FROM with ORDER BY



CR:748461
CR Number:   748461
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An infected with signal 11 error occurs in open_byname with a stacktrace that includes function names col_open_range and vu_redefine



CR:748519
CR Number:   748519
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 21 Oct 2013 Fixed
22 Oct 2013 One-off Provided
15.7 SP60 16 Oct 2013 Fixed
16.0 21 Nov 2013 Fixed
Description
Various errors like 206, 4701, 247 maybe given when using EXECUTE AS CALLER procedure with select into a temporary table or create index statements.



CR:748569
CR Number:   748569
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2014 Fixed
19 May 2014 Reservation Made
22 May 2014 Fixed
Description
When the EQUALS_SCAN_SUPERSET optcriteria hueristic is enabled, it would not apply in the case that the index with no positioning equi-sargs exist (i.e. a full index scan). The heuristics should apply in this case if the more expensive index covers all the equi-sargs of the former index, and includes positioning equi-sargs as well. optcriteria cr748569 will support the enhanced functionality to heuristic optcriteria EQUALS_SCAN_SUPERSET. Related to this enhancement to the EQUALS_SCAN_SUPERSET is optcriteria cr763859
Workaround Description
 Use forceplan to force the good index.



CR:748578
CR Number:   748578
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If compatibility mode is enabled, a union query with a self-join of a materialized view may fails due to a 622 error because 'temp worktable' is already in use.
Workaround Description
 1. Turn off compatibility mode if possible.



2. Create another view having a different name and modify the query to avoid using the self-join of the meterialized view.



CR:748675
CR Number:   748675
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2013 Fixed
16 Oct 2013 Fixed
31 Oct 2013 One-off Provided
22 Nov 2013 Port Not Needed
09 Dec 2013 One-off Provided
09 Dec 2013 One-off Provided
09 Dec 2013 One-off Provided
16 Dec 2013 Port Not Needed
02 Jun 2014 Port Not Needed
08 Jun 2014 One-off Provided
Description
Insert into corrupted table failed and did not return any error, originally seen on 12.5.4.



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



CR:748689
CR Number:   748689
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2013 Fixed
10 Jan 2014 Presently Not Targeted For Any Future Release Of This Product
15 Jan 2014 Extra Tests Not Needed
29 Jan 2014 Fixed
19 Feb 2014 Fixed
01 Jul 2014 Fixed
Description
Add support for single instance user databases for the SAP ASE Cluster Edition.



CR:748731
CR Number:   748731
Product Name:   Adaptive Server Generic Docs
Product Component:   Adaptive Server New Features Guide
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2013 Added to user documentation
Description
Doc bug: sp_dump_history has some errors



CR:748789
CR Number:   748789
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Improve performance and concurrency of dbcc rebuild_text.



CR:748815
CR Number:   748815
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 14 Oct 2013 Fixed
16.0 13 Nov 2013 Fixed
Description
A segmentation violation followed by a stack trace that contains the module strtok_r() will be raised at boot time on a Windows SAP Adaptive Server Enterprise if the configuration option 'enable dump history' is enabled and the file configured in 'dump history filename' exists but it's empty.



CR:748843
CR Number:   748843
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In compatibility mode, max() trims trailing blanks from a local char variable permanently.
Workaround Description
 Declare anothet local variable and copy the original one.



declare @a char(10), @b char(10)

select @a = " " -- 10 single-byte scpace

select @b = @a

select datalength(@a)

select max(@a)

select @a = @b

select datalength(@b)

go



CR:748851
CR Number:   748851
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP51
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2014 Fixed
14 Mar 2014 Fixed
16.0 17 Dec 2013 Fixed
Description
'Invalid pointer value' error messages may occur when a non-database owner accesses the SAP ASE database.
Workaround Description
 May select the 923 error row from sysmessages.



CR:748867
CR Number:   748867
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Microsoft Windows
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 07 Nov 2013 Fixed
Description
internal only: version change.



CR:748891
CR Number:   748891
Product Name:   Unified Agent
Product Component:   Security Services
Status:   Closed
OS:   all
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2013 Presently Not Targeted For Any Future Release Of This Product
Description
NFR - Request a GUI function to refresh the login info from csi_config.xml



CR:748941
CR Number:   748941
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Windows 2008
Original Version:   15.7 ESD#4 PL2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 24 Oct 2013 Fixed
15.7 SP121 24 Oct 2013 Fixed
16.0 24 Oct 2013 Fixed
Description
installTemplateXml.bat fails with EOF error



CR:748968
CR Number:   748968
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 SP121 05 Nov 2013 Fixed
16.0 07 Nov 2013 Fixed
Description
The sybdumptran utility has been enhanced to switch automatically to the mirror of a log device when opening the primary log device fails. The metadata file used by sybdumptran must be a dump that has been made using an SAP ASE version that contains the current fix.



CR:748990
CR Number:   748990
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2013 Fixed
13 Nov 2013 Added to user documentation
20 Oct 2013 Fixed
18 Nov 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
ASEMAP cannot successfully complete the collection of optimizer and field diagnostic data when these operations are launched for an ASE server from the administration console.



CR:749004
CR Number:   749004
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 24 Oct 2013 Fixed
15.7 SP121 29 Oct 2013 Fixed
16.0 07 Nov 2013 Fixed
Description
The message "current process infected with 11" in the module 'getpage_with_validation' together with a stack trace which includes the modules 'apl__startscan' and 'startptnscan' may be reported in the error log when the stored procedure sp_helpdb is run and its execution is interrupted.
Workaround Description
 N/A



CR:749046
CR Number:   749046
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2014 DEFER
27 Mar 2014 Fixed
19 Feb 2014 Reservation Made
27 Mar 2014 Reservation Made
02 Jun 2014 Insufficient priority to fix
Description
INSERT SELECT does not support LEVEL0 scan. This is a new functionality request, to allow INSERT SELECT to support LEVEL0 scan.



CR:749058
CR Number:   749058
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2014 Fixed
28 May 2014 One-off Provided
15 Jul 2014 One-off Provided
09 Nov 2014 Fixed
Description
In rare circumstances on a heavily-loaded Server, the message "current process infected with 11" together with a stack trace which includes the module 'mda__tc_scan_mempool' may be reported in the error log when table monTableCompression is accessed.
Workaround Description
 disable the configure 'capture compression statistics' and do not access the table monTableCompression



CR:749080
CR Number:   749080
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2014 Fixed
Description
When using date_diff with smalldatetime and varchar arguments, a bigint may be returned.
Workaround Description
 -- When passing a smalldatetime variable to datediff that also has a varchar constant, use datetime instead



or



-- Add a convert(int) around the datediff i.e. convert(int, datediff(..))



CR:749086
CR Number:   749086
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 23 Oct 2013 Fixed
16.0 11 Nov 2013 Fixed
Description
CREATE and ALTER DATABASE FOR LOAD initialize the database allocation pages
when it's unnecessary.



CR:749097
CR Number:   749097
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)
16.0 15 Jan 2014 Fixed
20 Jan 2014 Fixed
15.7 SP111 28 Feb 2014 Fixed
15.7 SP121 26 Feb 2014 Fixed
Description
If update statistics is used on a table with a large number of partitions (e.g. 1000), then the performance declines significantly, and an inordinate number of log records are created.



CR:749101
CR Number:   749101
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 29 Oct 2013 Fixed
18 Nov 2013 One-off Provided
15.7 SP60 29 Oct 2013 Fixed
16.0 08 Nov 2013 Fixed
14 Nov 2013 Fixed
17 Mar 2014 Fixed
17 Dec 2013 Fixed
05 Feb 2014 One-off Provided
20 Mar 2014 One-off Provided
11 Jun 2014 Fixed
19 Jun 2014 Fixed
19 Jun 2014 Fixed
Description
The connection to a backup server can be rejected if the client host has multiple IP addresses and the entries in the target backup server hosts.allow file are not authorizing the first remote IP address. Likewise, the connections will be rejected if the host name used in the first column of the hosts.allow file specifies a host alias different from the actual host name.
Workaround Description
 In the case of multiple ip's on the same interface, but not the first

Setup hosts.allow to be the form of

[real host name] [backupserver address]

or

[real host name] +



CR:749129
CR Number:   749129
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 SP121 23 Oct 2013 Fixed
15.7 SP110 23 Oct 2013 Fixed
16.0 17 Nov 2013 Fixed
Description
The command "select * from monHADRMembers" sometimes returns 0 rows when executed on a standby member of an HADR cluster.



CR:749138
CR Number:   749138
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP50
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 18 Oct 2013 Fixed
18 Nov 2013 One-off Provided
15.7 SP121 07 Nov 2013 Fixed
16.0 22 Nov 2013 Fixed
15.7 SP111 27 Feb 2014 Fixed
Description
A 422 error, "Too many nested expressions or logical operators to compile. Try splitting query or limiting ANDs and ORs." may be reported during the execution of a SELECT query that uses an abstract plan and references a table with more than 2000 range partitions.



CR:749139
CR Number:   749139
Product Name:   Adaptive Server Generic Docs
Product Component:   To Be Determined
Status:   Open
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
documentation for monSpinlockActivity details for each spinlock in SpinlockName.



CR:749156
CR Number:   749156
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 05 Nov 2013 Fixed
15.7 SP121 05 Nov 2013 Fixed
16.0 07 Nov 2013 Fixed
06 Nov 2013 Reservation Made
15.7 SP60 06 Nov 2013 Fixed
Description
A 3474 error: "During redo the page timestamp value is less than old timestamp from log." and other miscellaneous errors can be encountered upon loading a transaction log dump containing a CREATE INDEX transaction on a table that has compressed data and nonmaterialized columns having default values.



CR:749157
CR Number:   749157
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)
07 Apr 2014 DEFER
Description
Infected with 11 in sqt_deallocate



CR:749172
CR Number:   749172
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 22 Oct 2013 Fixed
15.7 SP110 24 Oct 2013 Fixed
16.0 17 Nov 2013 Fixed
Description
If JS Agent hits some inconsistency in operation then Job Scheduler auto restart attempts may enter into an infinite loop.



CR:749189
CR Number:   749189
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If string_rtruncation is set on, error message 9502 is raised when values are assigned to VARCHAR variables that have been defined too short. Unfortunately, it appears that string_rtruncation does not work for such assignment query if it is inside a stored procedure or SQL function.



CR:749267
CR Number:   749267
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)
22 Jan 2014 Fixed
27 Feb 2014 Fixed
Description
DBCC TABLEALLOC needs to scan allocation pages of the database several times, when used like 'DBCC TABLEALLOC(name, full, fix)', it may partially cause the command run a long time. DBCC CHECKALLOC has same performance issue.



CR:749274
CR Number:   749274
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 19 Nov 2013 Fixed
16.0 20 Nov 2013 Fixed
15.7 SP111 10 Mar 2014 Fixed
11 Mar 2014 Fixed
Description
When the monDeviceSpaceUsage table is queried concurrently from different processes, SAP ASE running with threaded mode might report a SIGSEGV (infected with 11) error that mentions the function mda__init_FSList() on the IBM AIX platform.
Workaround Description
 Query the monDeviceSpaceUsage table in one single thread.



CR:749279
CR Number:   749279
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 26 Dec 2013 Fixed
15.7 SP121 09 Jan 2014 Fixed
15.7 SP61 12 Jan 2014 Fixed
10 Feb 2014 Fixed
Description
When a rule is created which is not compatible with the column to which it is bound, SAP ASE generates an error message when it tries to insert a value. After raising the error, an infected with 11 (SIGSEGV) along with a stack trace is reported in the SAP ASE errorlog.



CR:749286
CR Number:   749286
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a way to track the number of lava buffers that have overflowed to tempdb pages.



CR:749311
CR Number:   749311
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 14 Nov 2013 Fixed
Description
When 'set option show_abstract_plan on', SELECT FOR XML query may return error instead of the acutal return



CR:749312
CR Number:   749312
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2013 Fixed
03 Feb 2014 Bundled Request
16.0 09 Jan 2014 Fixed
02 Jun 2014 Port Not Needed
31 Dec 2014 Fixed
Description
When using a large IN list and the statement cache is on, if the plan chosen has > 96 tables, the query may stack trace during compilation.



CR:749313
CR Number:   749313
Product Name:   Adaptive Server Enterprise
Product Component:   coverletter
Status:   Closed
OS:   Solaris
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2014 Added to user documentation
Description
The Cover Letter of EBF 21770 for Sun Solaris SPARC 64bit contains EBF numbers for Windows x86.



CR:749368
CR Number:   749368
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   NA
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 24 Oct 2013 Fixed
16.0 24 Oct 2013 Fixed
Description
DDLGen not displaying SAP ASE errors raised during execution



CR:749381
CR Number:   749381
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 25 Oct 2013 Fixed
25 Oct 2013 Reservation Made
15.7 SP110 25 Oct 2013 Fixed
16.0 18 Nov 2013 Fixed
Description
Job Scheduler may go down during HADR deactivation.



CR:749441
CR Number:   749441
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide an easy to use interface which would give advice on which (if any) REORG command should be run against which tables in a database.



CR:749443
CR Number:   749443
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 07 Nov 2013 Fixed
Description
Under some rare situation, if statement cache is on and a plan need to be recompiled during execution time, it could leave the statement pagecount with a negative number for FBO binary and stacktrace for DEBUG binary.



CR:749449
CR Number:   749449
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2014 Fixed
26 Feb 2014 Fixed
Description
If dump history file is manually edited and the first line becomes blank, the file is assumed to be empty and then is initialized.



CR:749462
CR Number:   749462
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)
16.0 27 Nov 2013 Fixed
07 Nov 2014 Fixed
23 Dec 2014 Fixed
Description
When statement cache is on and if fewer of parameters are sent to ASE than the query expects, then an infected with 11 (SIGSEGV) stacktrace in the s__make_param() function may be reported in the SAP ASE errorlog.



CR:749479
CR Number:   749479
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 SP121 20 Nov 2013 Fixed
15.7 SP60 19 Nov 2013 Fixed
16.0 22 Nov 2013 Fixed
15.7 SP111 28 Feb 2014 Fixed
Description
A Parallel query that uses a shared worktable may result in a 940 error "Dbtable in wrong state for Operation" and the process being terminated.
Workaround Description
 When I turned on 12315 trace flag, the 940 error went away, and the repro works

fine. This trace flag disables the change for PSS level dbtable caching feature,

CR 610956.



However, the TF 12315 is not a valid workaround. It just delays the 940 error.

When the TF is not used, the dbtable keep count is counted in PSS, its field is

defined as int16, ie. 2byte signed integer. With this repro, the dbtable keep

count of tempdb continues to increase to about 40000. When the keep count

increments from 32767, it overflows to negative, -32768, hence 940 error.



When the TF is used, the dbtable keep count is counted in global dbtable for

tempdb. The field is defined as int, ie. 4byte signed integer. If the repro

query is repeated more than about 53600 times, then same overflow in the int

field will happen even with the TF.



Thanks,

Terada



CR:749482
CR Number:   749482
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.2.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2013 Added to user documentation
Description
Trigger property page cannot be launched from the "Referenced By" page of a stored procedure property sheet.



CR:749486
CR Number:   749486
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 06 Nov 2013 Fixed
16.0 08 Nov 2013 Fixed
Description
Loading a transaction dump created with NO_TRUNCATE will fail with a 4334 error, 'Specified file is out of sequence...' if it is loaded after a cumulative dump has been loaded.



CR:749510
CR Number:   749510
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
cepheus 28 Feb 2014 Added to user documentation
Description
doc bug: sp_optgoal missing the most important part. sp_configure



CR:749515
CR Number:   749515
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Open
OS:   Linux
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Defunct child processes of Xpserver not correctly waiting for the termination might due to the no_wait mode
Workaround Description
 Do not use no_wait mode



CR:749526
CR Number:   749526
Product Name:   Adaptive Server Enterprise
Product Component:   ASE Agent Plugin
Status:   Closed
OS:   RH Linux
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 31 Oct 2013 Fixed
Description
internal review



CR:749632
CR Number:   749632
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2014 Duplicate
Description
Reorg rebuild on tables with text columns can run slow and consume more space in syslogs.
Workaround Description
 If the table is not configured for replication, pls reset text back

link before running reorg rebuild cmd by



dbcc shrinkdb_setup(@dbname, @objname, 1, 1, 1)



while the parameter list of this cmd is



dbcc shrinkdb_setup( @db [,@object [,@force [,@verbose [,@undo]]]] )



CR:749643
CR Number:   749643
Product Name:   ASE Management
Product Component:   Monitoring Agent Plugin
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2013 Fixed
24 Oct 2013 Fixed
Description
Error 209 reported while displaying In memory Storage tab in Cache view of ASE monitoring view when the monitored ASE is set up with case-insensitive sort order.



CR:749669
CR Number:   749669
Product Name:   Adaptive Server Enterprise
Product Component:   sybdiag
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 15 Nov 2013 Fixed
18 Nov 2013 Added to user documentation
Description
Add new -D option to specify user data directory



CR:749712
CR Number:   749712
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2014 Fixed
17 Jun 2014 Fixed
Description
Add a db shrink warning if there not enough space available. This has been added as a part of the checking done by "alter database ... with check_only"



CR:749721
CR Number:   749721
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 SP60 20 Nov 2013 Fixed
15.7 SP121 25 Nov 2013 Fixed
20 Nov 2013 Reservation Made
16.0 27 Nov 2013 Fixed
Description
In rare circumstances, a 2601 error, "Attempt to insert duplicate key row in object '<name>' with unique index

'<index name>'", may be reported during the load of an 12.5 database in a 15.7 dataserver.
Workaround Description
 It seems running sp_fixindex on source db help fix this issue (it worked on one of the environments at customer site), the question is why? because there is no corruption carried forward in the dump...moreover this dump works fine on ASE 15.5.



SP_FIXINDEX on sysstatistics and redo the dump on 12.5.4 will work around this problem.

1> use master

2> go

1> sp_dboption test_cdb, 'single user', true

2> go

1> use test_cdb

2> go

1> sp_fixindex test_cdb, sysstatistics, 2

2> go

1> sp_dboption test_cdb, 'single user', false

2> go

1> checkpoint test_cdb

2> go



CR:749724
CR Number:   749724
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 ESD#2 rolling
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
object_status "contains compressed data" remains after table is truncated
Workaround Description
 Reorg rebuild works to clear the "contains compressed data" status.



CR:749795
CR Number:   749795
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)
18 Aug 2014 Fixed
18 Aug 2014 Fixed
27 Aug 2014 Reservation Made
21 Aug 2014 Fixed
23 Sep 2014 Fixed
Description
The loginfo() built-in has been optimized to avoid blocking while database dump or dump transaction is executed concurrently. Similar optimization was made to lct_admin() built-in when used with "num_logpages" option.





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