远程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:742667
CR Number:   742667
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 SP60 09 Jul 2013 Fixed
15.7 SP110 16 Jul 2013 Fixed
Description
The message, "Current process infected with signal 11", followed by a stack trace that includes the module ulpspinlock() and kstcpnetctlrCancelRequests() may be reported by an SAP ASE running in the threaded kernel mode on the Solaris platform. The SAP ASE may subsequently hang.
Workaround Description
 no workaround



CR:742693
CR Number:   742693
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2013 Fixed
21 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=<addr_val>, lrmagic=<char_val>)." may be reported when running DBCC FIX_TEXT on a table having one or more text columns.



CR:742694
CR Number:   742694
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Group insert (TF450) can give wrong results depending on data ordering
Workaround Description
 Don't use traceflag 450



CR:742728
CR Number:   742728
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 Duplicate
Description
When issuing an update statement against a compressed (var)char column it is possible for

the update to fail reporting error 614 and for a stack trace to appear in the ASE error

log along with a message 'Invalid DOL data row pointer' and Error: 614, Severity: 21,

State: 12

'Adaptive Server accessed a row that has an illegal length'
Workaround Description
 Upgrade to 15.7 ESD#5 (SP50) or SP100



CR:742762
CR Number:   742762
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 09 Jul 2013 Fixed
09 Jul 2013 Fixed
15.7 SP110 17 Jul 2013 Fixed
15.7 SP50 10 Jul 2013 Fixed
Description
Under some circumstances, an 8203 error, "Expected to find the descriptor for object <object_id> in database <db_name> in <state> state", followed by a stack trace that include the modules ssql_droptext() and procrm() may be reported in the error log.



CR:742771
CR Number:   742771
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T:Monitoring Tables
Status:   Open
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Document all possible module names in monProcedureCacheModuleUsage



CR:742782
CR Number:   742782
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4.2 BLK
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 14 Aug 2013 Fixed
13 Aug 2013 Fixed
15.7 SP121 03 Oct 2013 Fixed
Description
Sometimes, sp_showplan may cause a signal 11 (SIGSEGV) with a stacktrace reported in the errorlog involving the function listChildQueries().
Workaround Description
 the ct has turned off the query plan collection option in ProActiveDBA to avoid this error



CR:742786
CR Number:   742786
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jul 2013 Fixed
15.7 SP110 29 Jul 2013 Fixed
15.7 SP60 30 Jul 2013 Fixed
Description
In very rare circumstances, error 1765 (related to level 0 scan) could be raised unexpectedly.



CR:742847
CR Number:   742847
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 12 Sep 2013 Fixed
15.7 SP110 12 Sep 2013 Fixed
12 Sep 2013 Reservation Made
26 Sep 2013 Reservation Made
Description
With a new set option 'set sqlnull on', string concatenation with NULL value will follow SQL standard, i.e. return NULL value



CR:742869
CR Number:   742869
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)
07 Apr 2014 DEFER
Description
sig 11 in open__byname when creating a lwp
Workaround Description
 turn off statement cache at the session level for the application



CR:742871
CR Number:   742871
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4 PL1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 02 Aug 2013 Fixed
11 Jul 2013 Fixed
15.7 SP121 03 Oct 2013 Fixed
Description
If 'procedure cache' is configured too small for a heavy loaded server, it could lead to stacktraces with s_chooselocks(), s_setup_lockrequest() and insert_to_heap().



CR:742873
CR Number:   742873
Product Name:   Universal Alerts Engine
Product Component:   CORE
Status:   Closed
OS:   AIX
Original Version:   8.3 SP01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2013 Fixed
8.2 PC08 22 Aug 2013 Fixed
8.2 PC08 25 Aug 2013 Fixed
12 Nov 2013 Fixed
23 Jul 2014 Fixed
Description
UAE Username/password requirement problem
Target Version
 8.3 SP01



CR:742889
CR Number:   742889
Product Name:   ASE Management
Product Component:   Web Console
Status:   Closed
OS:   Generic
Original Version:   3.2.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2013 Fixed
Description
The Login view in the Admin Console shows wrong default database for server 15.7 or above when the login is created under following two conditions.

1. If the login is created ignoring login profile, the "create login..." command lacks the clause of 'login profile ignore' or "sp_addlogin" is used.

2. If the login is created with login profile and the login profile has blank default database.



CR:742896
CR Number:   742896
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 SP60 09 Jul 2013 Fixed
10 Jul 2013 Fixed
15.7 SP110 10 Jul 2013 Fixed
Description
In some cases, SAP ASE may report a timeslice error in module shm_mergedump() when "memory dump compression level" is set as non-zero value.



CR:742914
CR Number:   742914
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 11 Jul 2013 Fixed
15.7 SP51 11 Jul 2013 Fixed
23 Sep 2013 Port Not Needed
Description
DDLGen cannot generate a 'GRANTED BY' permission clause when run against SAP ASE 15.7 SP50 and higher versions.



CR:742985
CR Number:   742985
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   RH Linux
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2013 Fixed
Description
Default value of max total shared memory is insufficient to build server.



CR:742987
CR Number:   742987
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 10 Jul 2013 Fixed
15.7 SP60 19 Jul 2013 Fixed
07 Feb 2014 Fixed
Description
An 814 error, "Keep count of buffer <buf_num> in cache <cache_name> holding logical page <page_id> in database <db_name> has become negative", followed by an 837 error, "Attempted to grab wash header" may be reported during UPDATE STATISTICS or CREATE INDEX.



CR:742991
CR Number:   742991
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 18 Jul 2013 Fixed
Description
After a server crash while shrink database is sorting a non-unique index, boot-time recovery will set the index to be suspect with out any information in errorlog.



CR:742992
CR Number:   742992
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 12 Sep 2013 Fixed
14 Nov 2013 Fixed
Description
"alter database" option "with check_only" does not warn about indexes having many duplicated key entries, which could cause shrink database to keep the table locked for unacceptable lengths of time while it sorts index entries. Knowing about these potential problems can help customers plan their work.



CR:742997
CR Number:   742997
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2014 Added to user documentation
Description
Three words "manage", "decrypt_default" and "xmltable" are not in the list of ASE reserved words.



CR:743045
CR Number:   743045
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 23 Jul 2013 Fixed
15.7 SP121 31 Oct 2013 Fixed
18 Nov 2013 Fixed
Description
When log segment of a database exhausts and tasks involving page allocation are in progress, ASE could hit 804 error : "Unable to find buffer '0x..' from cache '...' holding

logical page '...' in sdes '0x...' kept buffer pool for object '...'.
Workaround Description
 There is no workaround for the 804 error. But avoiding 1105 error through having considerably big log segment for database would avoid 804 error too.



CR:743053
CR Number:   743053
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2013 Fixed
Description
sp_config_rep_agent enable must now be run with a non-NULL password.



CR:743055
CR Number:   743055
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 19 Jul 2013 Fixed
15.7 SP60 28 Jul 2013 Fixed
Description
A SAP ASE that running in threaded kernel mode on the Linux or HPUX operating systems may print a stack trace including ulpspinlock and kstcpnetctlrCancelRequests and thereafter the SAP ASE becomes non-responsive.



CR:743075
CR Number:   743075
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 SP60 17 Jul 2013 Fixed
15.7 SP110 19 Jul 2013 Fixed
Description
The configuration option, 'enable plan sharing' is no longer automatically enabled when the configuration option, 'enable functionality group' is enabled. The option 'enable plan sharing' must now be enabled explicitly.



CR:743144
CR Number:   743144
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2014 Already Fixed by Another CR
Description
The sp_config_dump parameter documented as @retain_days should be actually be @retaindays. The procedure will ignore any value passed as @retain_days.



CR:743145
CR Number:   743145
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 17 Jul 2013 Fixed
Description
Cumulative dumps cannot be done in Cluster Edition. An error will now be reported if sp_dboption is used with the "allow incremental dumps" option in Cluster Edition.



CR:743177
CR Number:   743177
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 Jul 2013 Fixed
15.7 SP110 17 Jul 2013 Fixed
15.7 SP60 24 Jul 2013 Fixed
Description
System stored procedures, such as sp_password, sp_extrapwdchecks, sp_addlogin, do not have asterisks stored in audit table for password parameters when 'exec_procedure' auditing option is on.



CR:743203
CR Number:   743203
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 15 Jul 2013 Fixed
18 Jul 2013 Fixed
Description
DDLGen cannot generate 'Granted by' permission clause for ASE 15.7 SP50 and higher version.



CR:743211
CR Number:   743211
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 SP102 12 Jul 2013 Fixed
15.7 SP60 16 Jul 2013 Fixed
15.7 SP110 16 Jul 2013 Fixed
Description
During BCP for a table which has undergone an ALTER TABLE DROP column with no datacopy operation, ASE may send wrong default values for columns to the client.



CR:743214
CR Number:   743214
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2014 EOL'd version. Not to be Fixed.
Description
Signal 11 in crdb_phys during recovery



CR:743218
CR Number:   743218
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 15 Aug 2013 Fixed
02 Jul 2014 Presently Not Targeted For Any Future Release Of This Product
22 Aug 2013 Fixed
15.7 SP110 15 Aug 2013 Fixed
Description
When a table is altered to have not materialized columns with default values, null values are sent to the Rep Server instead of the default values during the execution of an UPDATE command.
Workaround Description
 Simpler repro : language mode, no index

===============

use pdb

go

drop table test

go

create table test

(

c1 int null

)

go

sp_setreptable test,true

go

use rdb

go

drop table test

go

create table test

(

c1 int null

)

go

grant all on test to public

go

insert into test values (1)

go

use pdb

go

alter table test

add

c2 int default 1000 not null not materialized,

c3 int default 1000 not null not materialized,

c4 int default 1000 not null not materialized,

c5 int default 1000 not null not materialized,

c6 int default 1000 not null not materialized,

c7 int default 1000 not null not materialized,

c8 int default 1000 not null not materialized,

c9 int default 1000 not null not materialized,

c10 int default 1000 not null not materialized

go

use rdb

go

alter table test

add

c2 int default 1000 not null not materialized,

c3 int default 1000 not null not materialized,

c4 int default 1000 not null not materialized,

c5 int default 1000 not null not materialized,

c6 int default 1000 not null not materialized,

c7 int default 1000 not null not materialized,

c8 int default 1000 not null not materialized,

c9 int default 1000 not null not materialized,

c10 int default 1000 not null not materialized

go

use pdb

go

update test set c2 = c2 + 1, c3 = c3 + 1

go



T. 2013/07/12 06:47:02. (94): 'begin transaction [0a] update top 1 dbo.test_null2 set c2=1001, c3=1001 where c1=1 and c2 is NULL and c3 is NULL and c4 is NULL and c5 is NULL and c6 is NULL and c7 is NULL and c8 is NULL and c9 is NULL and c10 is NULL '

W. 2013/07/12 06:47:02. WARNING #5185 DSI EXEC(103(1) ASE1572.rdb) - /dsiexec.c(18931)

Row count mismatch for the command executed on 'ASE1572.rdb'. The command impacted 0 rows but it should impact 1 rows.

I. 2013/07/12 06:47:02. The error was caused by output command #2 of the failed transaction on table 'dbo.test_null2'.

I. 2013/07/12 06:47:02. The DSI thread for database 'ASE1572.rdb' is shutdown.



CR:743245
CR Number:   743245
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)
15 Sep 2014 Fixed
28 Sep 2014 Fixed
Description
ALTER TABLE places text pages of a table onto incorrect system segment if ALTER TABLE adds the first text/image/unitext column for the table.
Workaround Description
 1. create at least one text/image column during CREATE TABLE. then you can use ALTER TABLE to add more text/image columns. if you do not have any text/image column at the time of CREATE TABLE, you can use a dummy text/image column. and drop the dummy text/image column after you add your text/image column using ALTER TABLE.



or



2. after the ALTER TABLE assign the incorrect segment to text/image pages, use sp_placeobject to place the text/image pages to desired segment.

sp_placeobject <segment_name>, "<table_name>.t<table_name>"



Note: After you execute sp_placeobject, pages that were previously written on the old device remain allocated, but all new allocations take place on the new segment.



CR:743270
CR Number:   743270
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2013 Fixed
15.7 SP110 16 Jul 2013 Fixed
15.7 SP60 16 Jul 2013 Fixed
Description
When an APL table is defined as PAGE COMPRESSED and contains a clustered index, some duplicate rows may be inserted successfully even though this is not allowed.



CR:743313
CR Number:   743313
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows 2008
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2013 Presently Not Targeted For Any Future Release Of This Product
Description
FR: Relax implementation of Windows security requirements in ASE 15.7 ESD#2.



CR:743321
CR Number:   743321
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 26 Sep 2013 Fixed
27 Nov 2013 Fixed
Description
Altering an un-partition table with unique local index to a roundrobin partition table does not give an error.



CR:743350
CR Number:   743350
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
Error messages 12806 and 12807 could be made more useful if they identified the table the tuple's belonged to and the database the problem happened in.



CR:743361
CR Number:   743361
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
03 Dec 2013 Port Not Needed
Description
The row count used when a histogram is created on a column is now printed by optdiag and sp_showoptstats. The line "Scanned Rows:" will be added to optdiag output, and the tag <scannedRows> will be added to the sp_showoptstats output.



CR:743433
CR Number:   743433
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)
16 Jan 2014 Fixed
30 Dec 2013 Fixed
20 Dec 2013 Reservation Made
03 Jan 2014 Fixed
Description
Performing decryption of encrypted column data can be much slower for standard users when decrypt default is used.
Workaround Description
 Create a stored procedure owned by a user with sso_role with execute as owner. Grant execute on this procedure to user test1. See below where kevin has sso_role, creates procedure p1 with execute as owner and user test1 is granted execute on p1.



1> sp_showtext "kevin.p1"

2> go

create procedure p1 with execute as owner as

select max(comp_annual) from emp_encrypt





(return status = 0)

1> sp_helprotect "kevin.p1"

2> go

grantor grantee type action object

column predicate grantable

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

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

kevin test1 Grant Execute p1

All NULL FALSE



(1 row affected)

(return status = 0)

1> quit

(tcsh)linuxsecure4% cat tp.sql

set showplan on

set statistics time on

go

execute kevin.p1

go





isql -Utest1 -Psybase -S k1 -Ddb11791845 -i tp.sql



Execution Time 0.

Adaptive Server cpu time: 0 ms. Adaptive Server elapsed time: 0 ms.



QUERY PLAN FOR STATEMENT 1 (at line 1).





STEP 1

The type of query is EXECUTE.



Parse and Compile Time 0.

Adaptive Server cpu time: 0 ms.



QUERY PLAN FOR STATEMENT 1 (at line 2).

Optimized using Serial Mode





STEP 1

The type of query is SELECT.



3 operator(s) under root



|ROOT:EMIT Operator (VA = 3)

|

| |SCALAR AGGREGATE Operator (VA = 2)

| | Evaluate Ungrouped MAXIMUM AGGREGATE.

| |

| | |RESTRICT Operator (VA = 1)(0)(0)(0)(9)(0)

| | |

| | | |SCAN Operator (VA = 0)

| | | | FROM TABLE

| | | | emp_encrypt

| | | | Table Scan.

| | | | Forward Scan.

| | | | Positioning at start of table.

| | | | Using I/O Size 2 Kbytes for data pages.

| | | | With LRU Buffer Replacement Strategy for data pages.





Parse and Compile Time 0.

Adaptive Server cpu time: 0 ms.



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

10037992.000000



Execution Time 1.

Adaptive Server cpu time: 45 ms. Adaptive Server elapsed time: 45 ms.



(1 row affected)

(return status = 0)



Execution Time 0.

Adaptive Server cpu time: 45 ms. Adaptive Server elapsed time: 45 ms.



Execution Time 0.

Adaptive Server cpu time: 0 ms. Adaptive Server elapsed time: 52 ms.



(tcsh)linuxsecure4% cat test.sql

set showplan on

set statistics time on

go

select max(comp_annual) from emp_encrypt

go

isql -Utest1 -Psybase -S k1 -Ddb11791845 -i test.sql



Execution Time 0.

Adaptive Server cpu time: 0 ms. Adaptive Server elapsed time: 0 ms.



QUERY PLAN FOR STATEMENT 1 (at line 1).

Optimized using Serial Mode





STEP 1

The type of query is SELECT.



3 operator(s) under root



|ROOT:EMIT Operator (VA = 3)

|

| |SCALAR AGGREGATE Operator (VA = 2)

| | Evaluate Ungrouped MAXIMUM AGGREGATE.

| |

| | |RESTRICT Operator (VA = 1)(0)(0)(0)(9)(0)

| | |

| | | |SCAN Operator (VA = 0)

| | | | FROM TABLE

| | | | emp_encrypt

| | | | Table Scan.

| | | | Forward Scan.

| | | | Positioning at start of table.

| | | | Using I/O Size 2 Kbytes for data pages.

| | | | With LRU Buffer Replacement Strategy for data pages.





Parse and Compile Time 0.

Adaptive Server cpu time: 0 ms.



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

10037992.000000



Execution Time 30.

Adaptive Server cpu time: 2975 ms. Adaptive Server elapsed time: 2975 ms.



(1 row affected)



Execution Time 0.

Adaptive Server cpu time: 39 ms. Adaptive Server elapsed time: 2976 ms.



CR:743464
CR Number:   743464
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2014 Added to user documentation
Description
Documentation enhancement request for the EXECUTE command entry in the Reference Manual, to also document here that stored procedures silently ignore any extra parameters they are passed.



CR:743486
CR Number:   743486
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 24 Jul 2013 Fixed
15.7 SP110 19 Jul 2013 Fixed
24 Jul 2014 Fixed
Description
Auditing of GRANT and/or REVOKE commands may cause a timeslice error when the command contains many whitespaces.



CR:743496
CR Number:   743496
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 15 Aug 2013 Fixed
15.7 SP110 16 Aug 2013 Fixed
Description
Under rare circumstances SAP Adaptive Server Cluster Edition may report during the execution of sp_config_rep_agent an inaccurate run value for parameter 'bind to engine' on some nodes in the Cluster.



CR:743542
CR Number:   743542
Product Name:   ASE Management
Product Component:   Administration Core
Status:   Closed
OS:   Generic
Original Version:   3.2.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2013 Fixed
Description
SCC to support sp_droploginm @with_override=1 change made in ASE



CR:743558
CR Number:   743558
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)
30 Dec 2013 Fixed
31 Jan 2014 Fixed
08 Jul 2014 Fixed
Description
Error 14613 (The '<name>' field in usage anchor has '<n>' which does not match with '<n> from sysusages. Dbid '<id>'. Lstart '<n>'.) formats the last 4 parameters incorrectly so the output appears garbled. The field name is correct.



CR:743573
CR Number:   743573
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 24 Jul 2013 Fixed
08 Dec 2013 One-off Provided
15.7 SP121 15 Dec 2013 Fixed
20 Dec 2013 Fixed
Description
The message "Current process infected with signal 11" in the module NormalizeScalar() with a stacktrace which includes the modules PesState::PesInit() may be reported when executing an UPDATE...FROM query on a table that has immediate refresh pre-computed result set (PRS) defined on it.
Workaround Description
 precomputed result set using manual refresh



CR:743580
CR Number:   743580
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
clarify and/or document library dependencies "not found" by ldd on linux



CR:743601
CR Number:   743601
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2013 Fixed
15.7 SP121 13 Dec 2013 Fixed
Description
Stack trace with error 622 may occur when running update statistics



CR:743637
CR Number:   743637
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)
15.7 SP60 06 Sep 2013 Fixed
15.7 SP121 27 Sep 2013 Fixed
15.7 SP110 13 Sep 2013 Fixed
15.7 SP51 06 Sep 2013 Fixed
15.7 SP103 10 Sep 2013 Fixed
Description
MERGE triggers on DOL tables may return the incorrect number of rows for the inserted table: too few rows for the UPDATE trigger and possibly too many rows for the INSERT trigger.



CR:743676
CR Number:   743676
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)
30 Jul 2013 Fixed
05 Aug 2013 Port Not Needed
07 Jun 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Wrong data may show up in page-compressed APL table with all fixed length columns.



CR:743731
CR Number:   743731
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 13 Aug 2013 Fixed
Description
An 806 error, "Could not find virtual page for logical page <page_id> in database '<db_name>'" may be reported when executing CHECKTABLE/CHECKINDEX/CHECKDB after shrinking a database containing a table with suspect index.
Workaround Description
 rebuild suspect index using DBCC REINDEX or REOGR REBUILD after shrinking database.



CR:743763
CR Number:   743763
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2014 Not a Bug
Description
When dumping a VLDB (> 2 TB) created on 15.5 (or prior) and loading to 15.7x, using the older 揷ompress:: syntax, the database load may fail.
Workaround Description
 Retake the db dump using new the compress syntax.

揷ompress = 101 is known to have worked okay.



CR:743771
CR Number:   743771
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 Jul 2013 Consult Complete
Description
Using "lava based parallel create index" needs to have its own configuration option.



CR:743775
CR Number:   743775
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2013 Fixed
15.7 SP60 05 Aug 2013 Fixed
15.7 SP121 21 Aug 2013 Fixed
24 Jul 2014 Fixed
Description
Audit table records might be malformed or missing for table access events when auditing is turned on.



CR:743795
CR Number:   743795
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2013 Fixed
Description
ase_default optlevel changed to include all optimizer changes from all releases prior to ase 15.7 sp200



CR:743863
CR Number:   743863
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have Sybmigrate migrate the current next identity value for tables.



CR:743864
CR Number:   743864
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 SP121 19 Dec 2013 Fixed
02 Jul 2014 Presently Not Targeted For Any Future Release Of This Product
24 Jan 2014 Fixed
15.7 SP121 20 Dec 2013 Fixed
30 Jan 2014 Fixed
31 Jan 2014 Reservation Made
Description
When using alter table not materialized with defaults replication needs to be supplied with the correct default values for log records created before the alter table if replication is behind in reading the log.



CR:743869
CR Number:   743869
Product Name:   Universal Alerts Engine
Product Component:   CORE
Status:   Open
OS:   AIX
Original Version:   2.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2013 Fixed
21 Aug 2013 Fixed
12 Nov 2013 Fixed
Description
Problem finding AutoStartUAE.properties



CR:743874
CR Number:   743874
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 941 'Illegal database context operation.' may be raised if run DBCC IOSIZE() for an object in

a database which cannot be currently accessed.



CR:743913
CR Number:   743913
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2013 Fixed
15.7 SP121 16 Oct 2013 Fixed
15.7 SP60 17 Oct 2013 Fixed
Description
When a new plan for a procedure is installed, the accumulated metric LogicalReads in the monCachedProcedures table for the cached procedure maybe incorrect.



CR:743922
CR Number:   743922
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)
23 Jul 2013 Consult Complete
08 Aug 2013 Consult Complete
15.7 SP60 06 Aug 2013 Fixed
15.7 SP110 07 Aug 2013 Fixed
15.7 SP51 09 Sep 2013 Fixed
15.7 SP103 09 Sep 2013 Fixed
Description
In rare circumstances, a SELECT FOR UPDATE query may return successfully without getting the exclusive lock on the row, even if READPAST mode was not being used. This only affects the AIX platforms and has been identified as an AIX compiler optimization issue when high levels of optimization are used on a specific module.



CR:743929
CR Number:   743929
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 22 Aug 2013 Fixed
28 Nov 2013 Fixed
Description
The maximum length of a user defined datatype (UDD), formerly restricted to the page size, is increased to the maximum size of a local variable of the same base type. See the output of DBCC SERVERLIMITS for the values of current limits.



CR:743936
CR Number:   743936
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 25 Jul 2013 Fixed
25 Jul 2013 Fixed
Description
srvbuild/srvbuildres does not report any error message if the given device file paths do not have read/write permission.



CR:743938
CR Number:   743938
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
Feature request to have an XML schema docuement for showplan_in_xml() output included in the ASE distribution package.



CR:743959
CR Number:   743959
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2014 Added to user documentation
Description
The reference manual entry on the dump database command has a note indicating that the dump file size may be incorrect when overwriting a file of the same name. As of 15.0.2 this is no longer true, the older file is now deleted before the new dump file is created, resulting in a correct file size.



CR:744011
CR Number:   744011
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jul 2013 Duplicate
02 Sep 2013 One-off Provided
03 Jun 2014 Fixed
10 Jun 2014 Fixed
12 Jun 2014 Port Not Needed
Description
When a user database is binded to a named cache, create index in it might report Error 693 while a dump database process running simutanously.



CR:744013
CR Number:   744013
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 SP60 02 Aug 2013 Fixed
15.7 SP110 02 Aug 2013 Fixed
14 Nov 2013 Not a Bug
15 Nov 2013 Fixed
Description
In a High Availability server, sp_addlogin and sp_addremotelogin will fail with permission errors when the user executing the stored procedures is granted sso_role only.
Workaround Description
 Grant sa_role and ha_role to user executing sp_addlogin or sp_addremotelogin.



CR:744015
CR Number:   744015
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Nov 2013 Fixed
Description
syconfig: Syconfig.exe: additional argument cannot be read into "Command Line" field



CR:744021
CR Number:   744021
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 29 Aug 2013 Fixed
15.7 SP110 29 Aug 2013 Fixed
10 Sep 2013 Bundled Request
Description
When the RepAgent configuration parameter 'rs servername' is longer than 30 characters, the run value of that parameter gets corrupted in memory.



CR:744045
CR Number:   744045
Product Name:   ASE Management
Product Component:   Administration Core
Status:   Closed
OS:   Generic
Original Version:   3.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2013 Fixed
Description
In the 'Include Objects in DDL Output' dialog that is opened from the 慓enerate Objects DDL menu option of a database, you will see that the count of objects for Scalar Functions and SQLJ Functions is not correctly including the count for the Scalar Functions if they do exist. The count only shows the number of SQLJ Functions.



CR:744049
CR Number:   744049
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2013 Fixed
Description
sp_help does not display information if partition locking is enabled on table.



CR:744075
CR Number:   744075
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 Sep 2013 Fixed
15.7 SP110 11 Sep 2013 Fixed
Description
When RepAgent is configured to use multi-path replication thru the option 憁ultithread rep agent and the number of replication paths is at least set to 2 thru the option 'max number of replication paths', in rare circumstances the replicated data between the primary and the standby databases may show inconsistencies resulting in data not being correctly replicated.



CR:744116
CR Number:   744116
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 07 Aug 2013 Fixed
15.7 SP121 23 Oct 2013 Fixed
14 Nov 2013 Fixed
Description
The SAP ASE Rep Agent thread sends float values ending in .0 without the .0 which makes them appear to be integers instead of floating point values. This can cause statement caching to create multiple plans for the same table leading to contention in the statement cache and degrading query performance.



CR:744123
CR Number:   744123
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 29 Jul 2013 Fixed
24 Jul 2014 Fixed
Description
A 2760 error, "Column name '' does not exist in target table", may be reported during the automatic generation of temp table statistics when the temp table uses a NUMERIC datatype.
Workaround Description
 set auto_temptable_stats off



CR:744179
CR Number:   744179
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
Umbrella CR for memory corruption with 揻unctionality group enabled.



CR:744181
CR Number:   744181
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 30 Jul 2013 Fixed
Description
The message, "Current process infected with signal 11", may be reported in the error log when killing the spid (using the sql 'kill <spid>') while running REORG DEFRAG.



CR:744185
CR Number:   744185
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2013 Fixed
Description
When running reorg rebuild index on compressed index, error 12323 state 43 may be raised

during key movement.



CR:744195
CR Number:   744195
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 19 Sep 2013 Fixed
30 Sep 2013 Presently Not Targeted For Any Future Release Of This Product
26 Sep 2013 Fixed
24 Sep 2013 One-off Provided
Description
A 10707 error 揢nhandled Java Exception: 厰 may be reported by the PCA/JVM Security Manager when the JRE needs to internally process information on native methods properties while executing a user supplied method. In order for the PCA/JVM Security Manager to allow the execution of native methods the directive "-Dsybase.allow.native.lib=true" in the "pca_jvm_java_options" configuration must be set to true in the sybpcidb database.
Workaround Description
 For sunsparc and possibly sunx64, modify $SYBASE/shared/JRE-7_0_7/lib/security/java.security file as follows and reboot ASE to reset the JVM.

Comment out UcryptoProvider and re-order 1-10 like below.

#

# List of providers and their preference orders (see above):

#

#security.provider.1=com.oracle.security.ucrypto.UcryptoProvider ${java.home}/lib/security/ucrypto-solaris.cfg

security.provider.1=sun.security.pkcs11.SunPKCS11 ${java.home}/lib/security/sunpkcs11-solaris.cfg

security.provider.2=sun.security.provider.Sun

security.provider.3=sun.security.rsa.SunRsaSign

security.provider.4=sun.security.ec.SunEC

security.provider.5=com.sun.net.ssl.internal.ssl.Provider

security.provider.6=com.sun.crypto.provider.SunJCE

security.provider.7=sun.security.jgss.SunProvider

security.provider.8=com.sun.security.sasl.Provider

security.provider.9=org.jcp.xml.dsig.internal.dom.XMLDSigRI

security.provider.10=sun.security.smartcardio.SunPCSC



CR:744199
CR Number:   744199
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
Cardinality defined on references is lost when generating XML Model from PDM.



CR:744256
CR Number:   744256
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 29 Jul 2013 Fixed
15.7 SP60 31 Jul 2013 Fixed
Description
In rare circumstances, soft fault 100015 (page loop error) reported by DBCC CHECKSTORAGE may

be upgraded to hard fault after running DBCC CHECKVERIFY.



CR:744283
CR Number:   744283
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 22 Nov 2013 Fixed
15.7 SP121 06 Dec 2013 Fixed
06 Dec 2013 Fixed
Description
When the SAP ASE builtin function ABS() is given a bigint or integer minimum value, a negative result is returned.



CR:744303
CR Number:   744303
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 14 Aug 2013 Fixed
15.7 SP110 15 Aug 2013 Fixed
Description
In cases where REORG DEFRAG or SHRINK DATABASE command encounters a signal 11 error, the table might not be usable by Level 0 scanners.



CR:744317
CR Number:   744317
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2013 Fixed
Description
Reorg rebuild index on compressed index may hit assertion failure in bt__rowcmp()

during key movement.



CR:744349
CR Number:   744349
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
Add abstract plan ID and plan group ID (from sysqueryplans) to monSysStatement when query is executed using a previously stored abstract plan.



CR:744360
CR Number:   744360
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2013 Insufficient priority to fix
Description
Under some circumstances you can get an abstract plan warning message when using UNION ALL



CR:744363
CR Number:   744363
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2013 Insufficient priority to fix
Description
Inconsistant output to optimiser trace files



CR:744369
CR Number:   744369
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2014 Added to user documentation
Description
Doc CR: fix all the current reorg docs pertaining to allpages.



CR:744375
CR Number:   744375
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 02 Aug 2013 Fixed
15.7 SP110 02 Aug 2013 Fixed
Description
The scheduled jobs configured using the Job Scheduler, with 'repeats' value greater than one day (eg. repeats=2d or repeats=25h or repeats=1441m) may run daily at the incorrect time.



CR:744389
CR Number:   744389
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 04 Aug 2013 Fixed
15.7 SP110 06 Aug 2013 Fixed
14 Jan 2014 Fixed
14 Jan 2014 Fixed
Description
The message, "Current process infected with signal 8 (SIGFPE)", followed by a stack trace that includes the module sam_setup_ptn() may be reported in the error log under rare circumstances.



CR:744484
CR Number:   744484
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 01 Aug 2013 Fixed
05 Aug 2013 Fixed
15.7 SP60 05 Aug 2013 Fixed
Description
The datatype of 'starttime' output parameter of sp_xact_loginfo is not correct. This results in a NULL value in starttime when executing the stored procedure with the 'oldestactive' option.



CR:744492
CR Number:   744492
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.7 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP121 19 Sep 2013 Fixed
14 Nov 2013 Fixed
Description
Backup Server: does not support syntax " dump ... with compression = 0" contrary to documentation.
Workaround Description
 N/A



CR:744541
CR Number:   744541
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2013 Fixed
04 Dec 2013 Fixed
05 Dec 2013 Fixed
19 May 2014 Fixed
Description
Assertion (ISUSERTABID(objid)) fails in the function xact__getdlm_fromxdes() during upgrade when running diagserver.



CR:744560
CR Number:   744560
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)
01 Sep 2014 Fixed
06 Oct 2014 Fixed
Description
In rare circumstances, when the CREATE INDEX and REORG REBUILD commands are running in parallel, WORKER processes may hang/sleep infinitely.



CR:744564
CR Number:   744564
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2013 Fixed
Description
Error 2622 can be generated while gathering statistics on a DOL (data only locking) table, in which the set of attributes cannot fit into an APL (all pages locking) row of a worktable. This can happen when statistics are explicitly updated on a column(s), or implicitly when auto_temptable_stats is enabled (explicitly or thru an optlevel containing this optcriteria).



CR:744567
CR Number:   744567
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 12 Sep 2013 Fixed
15 Nov 2013 Fixed
24 Jul 2014 Fixed
Description
Improve HK Chores cleanup processing after errors.



CR:744571
CR Number:   744571
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Unknown
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP60 06 Aug 2013 Fixed
15.7 SP110 06 Aug 2013 Fixed
Description
The DBCC utility reset_cached_plan_stats incorrectly checks for granular permissions.



CR:744588
CR Number:   744588
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
Generating PDM from an XSM: it does not generate PDM domains from XSM Simple types if they are not used by an element. The generated PDM is empty.



CR:744634
CR Number:   744634
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2013 Fixed
04 Sep 2013 Reservation Made
29 Oct 2013 Not a Bug
Description
Support Volatile Table whose row count may change dramatically so corresponding statistics are not maintained.



CR:744650
CR Number:   744650
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2013 Fixed
Description
When Engine local cache percent value is increased above the threshold, the server is infected with SIGNAL 11.



CR:744670
CR Number:   744670
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2014 Fixed
21 Oct 2014 Fixed
Description
In very rare cases open cursor may give incorrect results if a concurrent online partition utility like SPLIT, MERGE commits concurrently.



CR:744671
CR Number:   744671
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 14 Aug 2013 Fixed
15.7 SP110 14 Aug 2013 Fixed
Description
Under rare circumstances, shrinking a database can cause a subsequent recovery failure of that database. This is indicated by a message in the error log upon restart, saying that the object descriptor of object {N} cannot be installed. {N} may be 1, 2, or 28.



CR:744695
CR Number:   744695
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 Aug 2013 Fixed
Description
The show_condensed_text() function will return NULL with 208 error in some cases and will return NULL for dynamic prepared statement with the 102 error.





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