远程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:772749
CR Number:   772749
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2014 Fixed
08 Dec 2014 Fixed
23 Dec 2014 Fixed
Description
Under some rare conditions, execute dynamic sql sttaements could lead to the SIG 11 and stacktrace includes crp_vardec(), crp_var(), and sqt_reparse().



CR:772814
CR Number:   772814
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)
04 Nov 2014 Duplicate
Description
You can get Msg 707, Severity: 20, State: 5 when your ASE process is backing out from an error as Msg 208.



CR:772878
CR Number:   772878
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Fixed
Description
When server-wide audit options like 'dump_config' is turned on, 'dump config' interface doesn't record database name in sysaudits table.



CR:772903
CR Number:   772903
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2014 Fixed
03 Nov 2014 Fixed
14 Jan 2015 Fixed
Description
If a dump is created with the database option 'allow page signing' enabled and loaded 'WITH LISTONLY = CREATE_SQL', the sp_dboption command is not generated by 'CREATE_SQL' for setting the option 'allow page signing'.



CR:772915
CR Number:   772915
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Wrong result set solved after recreating index
Workaround Description
 Recreate index



CR:772979
CR Number:   772979
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2014 Fixed
08 Dec 2014 Fixed
11 Dec 2014 Fixed
Description
DDLGEN does not support WITH DBID= for CREATE DATABASE in ASE 15.7



CR:773010
CR Number:   773010
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Fixed
10 Nov 2014 Fixed
11 Nov 2014 Fixed
15 Nov 2014 Fixed
08 Dec 2014 Fixed
09 Dec 2014 Fixed
23 Dec 2014 Fixed
Description
When a query causes timeout error, it incorrectly reads bytes from the TDS stream, reports an unexpected error like "Type '64' not implemented" and generates two RESPONSE messages to the client.



CR:773036
CR Number:   773036
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP63
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2014 Duplicate
Description
RA gets 9275 on a delete/insert pair that was an update. No merge bit on in the delete/insert pair.
Workaround Description
 use DOL tables?



CR:773070
CR Number:   773070
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2014 Fixed
Description
When running Adaptive Server diagserver and the service key "syb_extpasswdkey" is dropped, under some circumstances the following assertion failure is seen in the errorlog: "Assertion (pwdlen < SAMAXPWDLEN+1) failed in file /remote/aptos_bld1/asecorona/SMP/porttree/svr/sql/generic/source/utils/ssladmin.c line 414"



CR:773094
CR Number:   773094
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2014 Fixed
10 Dec 2014 Bundled Request
10 Dec 2014 Bundled Request
Description
DBISQL 16.0 allows results to be editable from the results window.



CR:773116
CR Number:   773116
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   all
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2014 Fixed
Description
Support mount/unmount encrypted database



CR:773128
CR Number:   773128
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
To Be Determined 27 Oct 2014 Fixed
Description
Make visible. This is a placeholder CR for routing purposes, not a real fix.



CR:773131
CR Number:   773131
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances ASE may hit heap memory error(712) when executing dbcc listoam on table with high OAM entry count.

"Error 712: There is insufficient heap memory to allocate %ld bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system"



CR:773191
CR Number:   773191
Product Name:   Adaptive Server Enterprise
Product Component:   optdiag
Status:   Open
OS:   Linux
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Incorrect values reported by optdiag "Large I/O efficiency" with large I/O pool configured
Workaround Description
 Use built-in derived_stat(<tab_name>,indid,"lgio") instead.



CR:773230
CR Number:   773230
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
NaN values can be inserted into float and real data type columns by bulk copy routines.



CR:773273
CR Number:   773273
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)
07 Nov 2014 Fixed
05 Dec 2014 Fixed
04 Dec 2014 Consult Complete
23 Dec 2014 Fixed
Description
When a database has enabled page signing, under rare circumstances a transaction log page may be written with invalid page linking pointers. This can manifest as 806 errors during recovery or rollback.



CR:773430
CR Number:   773430
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Adding new VARCHAR column with single space default value via

ALTER TABLE ADD NEW_COLUMN_NAME VARCHAR(column_length) DEFAULT ' '

may fail to insert the default value to the new column if database option 'allow null by default' is on. ASE may output 'Invalid column length' error to errorlog when it read a row having invalid column data.



For Business Suite on ASE installation. Process of customizing SAP application systems may alter SAP application system table which is stored in ASE database, e.g. 'SAPSR3.MARA'. If a SAP table stored in ASE has just been changed with new columns added during customizing procedure, and there exists invalid column length message and stack trace in the errorlog while accessing to this table, then please consider extract the data and reload it, and also to perform this during downtime.



For standalone ASE, please drop and recreate related table if it exists invalid column data to resolve the problem.



If a database has database option 'allow nulls by default' on, then may need to specify 'NOT NULL' to add VARCHAR column with space as default value via ALTER TABLE, e.g.

alter table table_name add new_varchar_column(column_length) default ' ' not null
Workaround Description
 Drop and rebuild SAP application system table "SAPSR3.MARA" to resolve the problem if the table has bad data in new added columns after customizing.



If related database has database option 'allow nulls by default' on, then may need to specify 'NOT NULL' to insert space as default value to add VARCHAR column via ALTER TABLE, e.g.



alter table obj add new_varchar_col default ' ' not null



(Thank Yan Hong's finding)



CR:773512
CR Number:   773512
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2014 Fixed
20 Nov 2014 Fixed
06 Nov 2014 Insufficient priority to fix
11 Nov 2014 Fixed
Description
A segmentation violation occurs when executing command "ALTER ENCRYPTION KEY .. WITH PASSWD login_passwd ADD ENCRYPTION .. FOR LOGIN_ASSOCIATION"



CR:773554
CR Number:   773554
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2014 Fixed
17 Nov 2014 Fixed
23 Dec 2014 Fixed
31 Dec 2014 Fixed
Description
The execution of loginfo(<dbid>, 憍actspanbyspid, <spid>) built-in could take long time to complete while a DUMP TRANSACTION is concurrently run or when the amount of transaction log that is held up by it is very big.



CR:773621
CR Number:   773621
Product Name:   Adaptive Server Enterprise
Product Component:   sqlupgrade
Status:   Open
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2014 Fixed
23 Dec 2014 Fixed
Description
Failed upgrade cannot be restart by sqlupgrade/syconfig/sybatch.
Workaround Description
 Backup master device before upgrading. If failed to upgrade, restore the master device before restart the upgrading.



CR:773638
CR Number:   773638
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP122 Goodyear
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2014 Fixed
14 Nov 2014 Fixed
21 Nov 2014 Fixed
21 Nov 2014 Fixed
24 Nov 2014 Fixed
15 Dec 2014 Fixed
15 Jan 2015 Fixed
Description
In large, highly concurrent environments, SAP ASE may, under specific circumstances, cease to elect large (>1 page) IO and instead revert to regular (1 page) IO for asynchronous pre-fetch (APF) for a cache. The specific circumstances include that a single table is very frequently accessed, that the table does not fit into its named cache, causing cache misses and that the workload is such that the plans include large IO and APF.



CR:773651
CR Number:   773651
Product Name:   Adaptive Server Enterprise
Product Component:   ODATA Provider
Status:   Open
OS:   Linux
Original Version:   15.7 SP131
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODATA: Cannot start ODATA service after installation on Linux platform - reports Segmentation fault.
Workaround Description
 1) Rename dbosrv16.ini file located in $SYBASE/ODATA-16_0/bin64 to some other name.

2) Ensure the JRE 7 bin directory under $SYBASE/shared directory is included in the path.

3) Start ODATA Server from the $SYBASE/ODATA-16_0/classes directory as: ../bin64/dbosrv16 <path to the properties file>



CR:773706
CR Number:   773706
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Queries on proxy tables using local DATETIME variables and literal values may compare incorrectly and produce incorrect results.
Workaround Description
 -- workaround 1

declare @MaxDate smalldatetime

select @MaxDate = '20140811'

select * from jProxy

where datediff(dd, @MaxDate, '20111205') < 0

go



-- workaround 2

declare @MaxDate smalldatetime

select @MaxDate = '20140811'

if @MaxDate >= '20111205'

begin

select * from jProxy

end

go



CR:773733
CR Number:   773733
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
Due to a keyword collision with the new ALTER TABLE MODIFY OWNER command, trying to use ALTER TABLE to modify the datatype of a column named "owner" fails with syntax error 102. As a workaround, use SET QUOTED_IDENTIFIER ON and quote the column name "owner" in the ALTER TABLE command.
Workaround Description
 1) Use SET QUOTED_IDENTIFIER ON and quote the column name "owner"



set quoted_identifier on

go

alter table t modify "owner" char(16)

go



CR:773747
CR Number:   773747
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A validation check may fail on an encrypted column created with login_association option and a 15432 error is raised when an RPC is executed and Adaptive Server tries to decrypt an encryption key.



CR:773859
CR Number:   773859
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   16.0 GA PL04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances, a INSERT statement could appear as hang if

it is executed using "INS_BY_BULK" optimization criteria, the target

table has several indexes and the system does not have any available

worker process.
Workaround Description
 Increase the number of worker threads



CR:773875
CR Number:   773875
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   16.0 GA PL04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2014 Fixed
20 Nov 2014 Deferred
Description
The message "current process infected with 11" in the module 憁da__populate_RepScannersTable together with a stack trace which includes the modules 憁da_exec and 憁da_populate_monRepScanners may be reported in the error log when a query on the master..monRepScanners table is run and while the Replication Agent is shut down concurrently.



CR:773879
CR Number:   773879
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   AIX
Original Version:   15.7 SP122 Goodyear
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2014 Fixed
11 Nov 2014 Fixed
17 Nov 2014 Fixed
23 Dec 2014 Fixed
Description
SAP ASE running in threaded kernel mode on the IBM AIX platform may hit a stack overflow error while starting the Job Scheduler and this may lead to a shutdown of SAP ASE.



CR:773880
CR Number:   773880
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2014 Fixed
Description
In rare scenarios, during a workload startup the rdbtmgr_spin spinlock might have contention.



CR:773950
CR Number:   773950
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2014 Fixed
08 Dec 2014 Fixed
22 Dec 2014 Fixed
30 Dec 2014 Fixed
Description
A 1295 error, "Unconditional lock request for table or page <>, dbid <> was made while holding a latch." followed by the message "current process infected with 11" in the module 'xls_sessionid' together with a stack trace which includes the modules ' chk_and_send_audit' and 'send_audit' may be reported in the error log when REORG REBUILD INDEX is executed concurrently with DUMP DATABASE.



CR:773957
CR Number:   773957
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2014 Fixed
23 Dec 2014 Fixed
07 Jan 2015 Fixed
Description
Wrong result could be inserted into the under table when updating a view with float literal if the view has a instead of trigger and literal autoparam and statement cache are enabled.
Workaround Description
 sp_configure "statement cache",0

go

sp_configure "enable literal autoparam",0

go



or just for the session at the point of the insert.



set literal_autoparam off

set statement_cache off

go



CR:773966
CR Number:   773966
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Dec 2014 Fixed
31 Dec 2014 Fixed
11 Jan 2015 Fixed
11 Jan 2015 Fixed
Description
An infected with 11 (SIGSEGV) in the function in StgStatPkg::StgVarLengthColEstimates may be reported in the SAP ASE errorlog.



CR:773978
CR Number:   773978
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)
14 Nov 2014 Fixed
13 Nov 2014 Fixed
18 Nov 2014 Fixed
Description
When parallel CREATE INDEX with hash based statistics gathering is used, there is a possibility of a worker thread being placed in a sleep state and not be woken up, which will cause the session to hang.
Workaround Description
 use serial create index with hash based statistics gathering

or

avoid using hash based statistics gathering with parallel create index



CR:774050
CR Number:   774050
Product Name:   ASE Management
Product Component:   Administration Client
Status:   Open
OS:   Generic
Original Version:   3.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SAP Control Center for SAP ASE JobScheduler wizard does not present all available templates when creating new scheduled jobs.
Workaround Description
 Create Jobs from scratch.



CR:774069
CR Number:   774069
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When statement cache is active and a user has executed a statement that references an object owned by dbo and then creates their own object with the same name and executes the same statement, the results will continue to reflect the dbo's object rather than the user's object until the cached statement is purged from statement cache.



CR:774079
CR Number:   774079
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2014 Fixed
09 Dec 2014 Port Not Needed
18 Nov 2014 Fixed
22 Dec 2014 Presently Not Targeted For Any Future Release Of This Product
Description
Eliminate a spinlock window while updating MASS Status during hk_bufawrite.



CR:774082
CR Number:   774082
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)
13 Nov 2014 Fixed
17 Nov 2014 Fixed
14 Nov 2014 Fixed
Description
When running parallel CREATE INDEX with hash based statistics gathering there may be a timeslice error.
Workaround Description
 use serial create index with hash stats

or

use parallel create index without hash stats.



CR:774172
CR Number:   774172
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Open
OS:   Microsoft Windows NT
Original Version:   16.0 GA PL03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2014 Fixed
21 Nov 2014 Fixed
19 Dec 2014 Fixed
Description
SAP DBISQL 16 may use a lot of memory and scrolling the result set is slow in text mode.
Workaround Description
 use Scrollable table mode.



CR:774184
CR Number:   774184
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UNIX
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error 724 and timeslice in dseg_proc_allloc



CR:774198
CR Number:   774198
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DOL table to be partitioned the values for concurrency_opt_threshold are lost.



CR:774203
CR Number:   774203
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)
14 Nov 2014 Fixed
16 Nov 2014 Fixed
20 Nov 2014 Fixed
16 Dec 2014 Fixed
Description
If the database option "enforce dump tran sequence" is enabled, do not disallow CREATE INDEX with ONLINE option to run if the index is also being created with the DEFERRED_RECOVERY option.



CR:774211
CR Number:   774211
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2014 Fixed
26 Nov 2014 Insufficient priority to fix
10 Dec 2014 Fixed
28 Nov 2014 Fixed
10 Dec 2014 Fixed
10 Dec 2014 Fixed
Description
A 3935 error, 揊atal protocol error. xact_beginupdate() API was invoked in the wrong context. The transaction is currently in 'Command-attached' state. may be reported when a DML query is executed which includes an expression that references the reserve_identity() built-in.



CR:774228
CR Number:   774228
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
This is a test CR.



CR:774231
CR Number:   774231
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   One-off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2014 Duplicate
Description
Sometimes, if temp tables change in between two batch insert calls via jdbc, then we might have a situation where we point to memory that has been freed, leading to either of following errors : 705, 706, 707, 715 or Error 719 or similar error related to memory free, having stacktrace of batch_loopend -> s_copytmps -> memfree.



CR:774323
CR Number:   774323
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2014 Fixed
17 Nov 2014 Fixed
20 Nov 2014 Fixed
20 Nov 2014 Fixed
23 Dec 2014 Fixed
Description
A 644 error: "Index row entry for data row id (<pageid>, <rownum>) is missing from index page <index_pageid> of index id <indid> of table '<tabname>' in database '<dbname>' may sometimes be reported during recovery while undoing log records pertaining to an index on a Datarows Only Locked table.



CR:774338
CR Number:   774338
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2014 Fixed
09 Dec 2014 Fixed
08 Jan 2015 Fixed
Description
In rare circumstances an 11051 error, 揅REATE INDEX on the object <table> failed. Table is currently being used by one or more other tasks. Retry your query later. may be reported while transaction isolation level 0 scans are active on the same table. Starting SAP ASE with trace flag 8225 will reduce the likelihood of this error.



CR:774358
CR Number:   774358
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2015 Fixed
18 Jan 2015 Fixed
Description
A 632 error, "Attempt to move memory with an incorrect length of -106. Maximum allowed length is 16384", may be reported when DBCC CHECKTABLE is executed on an all-pages-locked table with a compressed index.



CR:774383
CR Number:   774383
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a dynamic SQL with homogeneous batch parameters is executed and it's required to recompile, a 16817 error may occur if a config parameter "streamlined dynamic SQL" is OFF.
Workaround Description
 Don't set 0 to "streamlined dynamic SQL".



CR:774411
CR Number:   774411
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 Nov 2014 Fixed
20 Nov 2014 Fixed
25 Nov 2014 Fixed
25 Nov 2014 Fixed
26 Nov 2014 Fixed
19 Dec 2014 Fixed
Description
In rare circumstances a 706 error, "Process tried to remove PROC_HDR that it does not hold in Pss", in the module onlutl_release_resources() together with a stack trace which includes the modules 'memfree' and 'rm_prochdr' may be reported in the SAP ASE error log when running CREATE INDEX or REORG REBUILD with the online option.



CR:774416
CR Number:   774416
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2014 Fixed
21 Nov 2014 Fixed
27 Nov 2014 Fixed
05 Dec 2014 Fixed
08 Dec 2014 Fixed
16 Dec 2014 Fixed
Description
Occasionally a error 644,"Index row entry for data row id (%u, %d) is missing from index page %u of index id %d of table '<name>' in database '<n>'. Xactid is (%u,%d). Drop and re-create the index." will be reported, when online parallel create index on unpartitioned DOL table with concurrent DMLs.



CR:774472
CR Number:   774472
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX 5.1
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances An 806 error, "Could not find virtual page for logical page <pagenum> in database <dbname>" may be reported when executing dbcc checkstorage in parallel.



CR:774555
CR Number:   774555
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2014 Fixed
26 Nov 2014 Fixed
Description
DDLGen with option -Cnumber will generate wrong table owner



CR:774569
CR Number:   774569
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Open
OS:   all
Original Version:   16.0 GA PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
"set showplan" commands are ignored when they are in the middle of a batch
Workaround Description
 -- putting 'set showplan off' in own batch by adding a 'go' after 'select 1' is the WA



select 1

go

set showplan off

go



CR:774594
CR Number:   774594
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX 5.1
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances cursor fetch execution might hit the error 290024 of "Invalid column length: ... Value must be between XX and XX" in ASE 15.7 SP110.



CR:774650
CR Number:   774650
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2014 Fixed
07 Jan 2015 Fixed
18 Jan 2015 Fixed
Description
A SPID is holding a latch on a buffer and sleeping and some other SPID's are waiting on the same buffer leading to a hang.



CR:774683
CR Number:   774683
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2014 Fixed
02 Dec 2014 Fixed
09 Dec 2014 Fixed
02 Jan 2015 Bundled Request
28 Dec 2014 Fixed
Description
The SAP ASE server kills database connections when deadlocks occur when a language batch command is followed by an RPC call. A stacktrace with an access violation/infected with 11 (SIGSEGV) is reported in SAP ASE errorlog.



CR:774690
CR Number:   774690
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE may raise errors 5899 during recovery and 5861 when running sp_configure (even for options that do not require more memory) when "global cache partitions" is set to a non-zero value and the amount of free memory remaining is relatively small. Set 'max memory' to the value specified in the 5861 error (or free some memory by reducing other parameters and reboot) to correct this issue.



CR:774699
CR Number:   774699
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2014 Fixed
15 Jan 2015 Fixed
15 Jan 2015 Fixed
16 Jan 2015 Fixed
15 Jan 2015 Fixed
Description
Under rare circumstances during upgrade or initial installation, after ASE reports that it is beginning upgrade step ID 1650 it may produce a stack trace saying that a stack overrun was detected and that the stack guardword is corrupt.



CR:774751
CR Number:   774751
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
monDeviceIO.ReadTime and WriteTime should be bigint's and not int



CR:774786
CR Number:   774786
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2014 Fixed
20 Nov 2014 Fixed
22 Dec 2014 Fixed
24 Dec 2014 Fixed
Description
A 820 error, "Attempt to dirty non-log buffer ... which is in I/O" in the module 'bufpindirty' together with a stack trace which includes the modules 'undo_bt_split' and 'rec__undo_abort_incomplete_ntas' may be reported in the error log during the undo phase of boot recovery if there are incomplete transactions that split index pages of Data Only Locked tables.



CR:774789
CR Number:   774789
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
ASE fails to detect numeric overflow for the BIGINT datatype. Overflow should raise error 3606.



CR:774830
CR Number:   774830
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Nov 2014 Fixed
02 Dec 2014 Fixed
Description
With auditing enabled, the query "alter encryption key master with passwd 'abcdef123456' add encryption for automatic_startup" may hit error 632 - "Attempt to move memory with an incorrect length of <n>. Maximum allowed length is <max>"



CR:774871
CR Number:   774871
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2014 Fixed
Description
Under rare conditions, error 14622, "The dbinfo anchor in the database '%<dbname>' is already locked by the task", could be raised when attempting to lock the database context information structure during exception handling.



CR:774892
CR Number:   774892
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   16.0 GA PL05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2014 Fixed
Description
placeholder CR only. NOt a real fix.



CR:774905
CR Number:   774905
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.7 SP121
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances the timeslice error might occur when HK GC is looping in bt__lockprevpg() to get page failed in ASE 15.7 SP121



CR:774906
CR Number:   774906
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2015 Fixed
19 Dec 2014 Fixed
22 Dec 2014 Fixed
24 Dec 2014 Fixed
Description
A 605 error, "An attempt was made to fetch logical page '<>' from cache '<>'. Page belongs to database '<>' ...", in the module 慴t__getchildlatched together with a stack trace which includes the modules 憆ec_undo_session_apf and 憍act__rollback_local may be reported in the error log while a session is rolling back a transaction containing a CREATE INDEX that is followed by DMLs in a database with the option 'ddl in tran' enabled.



CR:775022
CR Number:   775022
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   16.0 GA PL04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2014 Consult Complete
Description
A login with js_admin_role can't delete a scheduled job belongs to another user



CR:775030
CR Number:   775030
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   16.0 GA PL05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2014 Fixed
07 Dec 2014 Fixed
22 Dec 2014 Fixed
18 Dec 2014 Fixed
09 Dec 2014 Presently Not Targeted For Any Future Release Of This Product
10 Dec 2014 DEFER
09 Dec 2014 Fixed
22 Dec 2014 Fixed
Description
Sometimes, if temp tables change in between two batch insert calls via jdbc, then we might have a situation where we point to memory that has been freed, leading to either of following errors : 705, 706, 707, 715 or Error 719 or similar error related to memory free, having stacktrace of batch_loopend -> s_copytmps -> memfree.



CR:775034
CR Number:   775034
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   16.0 GA PL05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2014 Fixed
15 Dec 2014 Fixed
Description
A 691 error, "Encountered invalid logical page '0' while accessing database <dbname>, object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8)." may sometimes be reported while running the loginfo() built-in with "stp_pages" option.
Workaround Description
 n/a



CR:775036
CR Number:   775036
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.7 SP131 Goodyear
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2014 Fixed
03 Dec 2014 Reservation Made
23 Dec 2014 Fixed
Description
When an online utility rolls back, a concurrent update on the same table could hit the error 12319 "Fatal internal error encountered during deferred dml on table <> in database <>. All rows that qualified during the first phase were not visited during second phase of dml."



CR:775146
CR Number:   775146
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide ability in Replication Agent to skip a single log record if there is an error in processing the log record by the RA.
Workaround Description
 Current workaround is to release the secondary truncation point and restart the RA at the next log page. However in doing so, the remaining log records could contain commits for open transactions, begins for new transactions and work done to other tables. This is a lot more impact, than just skipping the log record for the one table whose objectid cannot be found



CR:775241
CR Number:   775241
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_downgrade may hang if a database has async log service (ALS) on
Workaround Description
 Turn off async log service on all databases before running sp_downgrade.



CR:775297
CR Number:   775297
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2014 Fixed
07 Dec 2014 Fixed
08 Dec 2014 Fixed
08 Dec 2014 Fixed
16 Dec 2014 Fixed
05 Jan 2015 Fixed
23 Dec 2014 Fixed
16 Dec 2014 Fixed
23 Dec 2014 Fixed
23 Dec 2014 Fixed
Description
When the Job Scheduler initialization fails or terminates, the subsequent Job scheduler boot may fail with an error "Attempt to insert duplicate key row in object '<js_table_name>' with unique index '<js_row_index>'"
Workaround Description
 delete sybmgmtdb..js_callouts where jsc_calloutid = 2147483647 and jsc_sjobid = 2147483647

delete sybmgmtdb..js_history where jsh_exid = 2147483647 and jsh_jobname = 'FAKE_JSJOB' and jsh_user_run = 'FAKE_JSUSER'

delete sybmgmtdb..js_seqsql where ssql_sid = 2147483647 and ssql_name = 'FAKE_JSSQL'

delete sybmgmtdb..js_scheduledjobs where sjob_id = 2147483647 and sjob_name = 'FAKE_JSSJOB'

delete sybmgmtdb..js_schedules where sched_id = 2147483647 and sched_owner = 'FAKE_JSUSER'

delete sybmgmtdb..js_jobs where job_id = 2147483647 and job_owner = 'FAKE_JSUSER'



CR:775355
CR Number:   775355
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2014 Fixed
18 Dec 2014 Fixed
18 Dec 2014 Fixed
22 Dec 2014 Fixed
Description
A 1108 error, "Cannot deallocate extent <extentid>, database <dbid>. Object id <objid>, index id <indid>, status 1 in extent does not match object id <objid2>, index id <indid2>, status 0 in object being deallocated. Run DBCC CHECKALLOC." may be reported in the module 'pg__dropbuf' together with a stack trace in the error log which includes the modules 'xact_rollback' and 'undo_apl_aextent', when an index page split occurs during the logical synchronization phase of ONLINE CREATE INDEX for a Data Only Locked table and the command is rolled back in the end.



CR:775402
CR Number:   775402
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Procedures
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If procedure 'sp_object_stats' is cancelled then trace flag 1213 can remain enabled causing performance problems in the environment. It is necessary to disable it manually by dbcc traceoff



CR:775417
CR Number:   775417
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide a new utility program named 'asecodeloc', that is used to decode ASE code location values

that may appear in the error log, or other diagnostic outputs. The encoded code location can be

decoded into its constituent file name / line number parts using this asecodeloc utility program.



CR:775419
CR Number:   775419
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement to error log printing routines to also synthesize and print to the error log an encoded

4-byte int value of the file name / line number where the error message is printed. Using a new

'asecodeloc' binary, this encoded value from the error log can be decoded to accurately locate the

source of the error resulting in the message to the log file.



CR:775422
CR Number:   775422
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 Dec 2014 Fixed
23 Dec 2014 Fixed
09 Jan 2015 Fixed
Description
During rollback of online create index, level0 scanners might not be able to use the DES.



CR:775446
CR Number:   775446
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)
04 Dec 2014 Fixed
17 Dec 2014 Fixed
17 Dec 2014 Fixed
23 Dec 2014 Fixed
Description
The SAP ASE server might not boot with the error "defined cache configuration consumes more memory than is available for buffer caches".



CR:775459
CR Number:   775459
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In rare circumstances, the message "current process infected with 11" together with a stack trace which includes the modules 'check__comprow' may be reported in the error log when running DBCC CHECKTABLE on an allpage-locked table.



CR:775501
CR Number:   775501
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP131
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2014 Fixed
26 Dec 2014 Fixed
Description
SAP ASE could hit error 705 (("There is no room for process xxx to store PROC_HDR 0xxxx in Pss") when a lot of recompilations happen due to schema count changes.



CR:775553
CR Number:   775553
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)
04 Jan 2015 Fixed
Description
When calling sp_configure, some options with very long names are truncated in output.



CR:775559
CR Number:   775559
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)
19 Dec 2014 Fixed
04 Dec 2014 Fixed
23 Dec 2014 Fixed
Description
A 102 error, Incorrect syntax near '~'. One or more indexes are corrupt. They will be rebuilt ...", may be reported during ONLINE DATABASE if the database contains an index whose name is a quoted_identifier and the index was created with defer_recovery = NONE option and while the recovery of this index has been deferred by LOAD TRANSACTION.



CR:775561
CR Number:   775561
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)
02 Dec 2014 Fixed
23 Dec 2014 Fixed
31 Dec 2014 Fixed
Description
A 'hang' situation due to an infinite loop may be encountered by a LOAD TRANSACTION command if the transaction log being loaded has more than 631 CREATE INDEX transactions with DEFER_RECOVERY option set.



CR:775598
CR Number:   775598
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2014 Fixed
16 Dec 2014 Fixed
Description
In rare circumstances the message "current process infected with 11" in the module 'xls_last_notflushed_plcblk' together with a stack trace which includes the modules 'crdb_main' and 'xls_reconfig_plcblk' may be reported in the error log during CREATE DATABASE.



CR:775599
CR Number:   775599
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP131 Goodyear
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2014 Fixed
10 Dec 2014 Fixed
31 Dec 2014 Fixed
Description
In rare circumstances, a 1295 error, "Unconditional lock request for table or page <page number>, dbid <dbid> was made while holding a latch.", may be reported by the system housekeeper chores task.



CR:775625
CR Number:   775625
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP131
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A replicated password may be truncated last several bytes if the new login is added by sp_addlogin or the password is changed by sp_password.



CR:775633
CR Number:   775633
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   16.0 SP01 PL02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Logical I/Os metrics incorrect for MDA tables for sensitive, insenstive cursors



CR:775654
CR Number:   775654
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP131 Goodyear
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2014 Fixed
Description
In rare circumstances, the message "current process infected with 11"

in the module 's_setreturns' or 'LeEmitNoSndOp::_LeOpNext' together

with a stack trace maybe be reported in the error log when Job Scheduler

is started using the stored procedure SP_SJOBCONTROL and a 1204 error,

"ASE has run out of LOCKS. Re-run your command ..." is triggered.



CR:775721
CR Number:   775721
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 SP131 Goodyear
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2014 Fixed
08 Dec 2014 Fixed
24 Dec 2014 Fixed
Description
The assertion failure: "Assertion (xdes->xcomplogbytesleft_diag >= 0) failed in file /calm/svr/sql/generic/source/access/do.c line <line_num>" may be seen with a diagserver during the ROLLBACK of a CREATE INDEX with ONLINE command.



CR:775729
CR Number:   775729
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2015 Reservation Made
Description
An optcriteria "force_top_plljoin" has been added to force parallel hash joins

for star join fact table hinted strategies if possible. Of course, this is

only applicable when parallelism is enabled.



CR:775735
CR Number:   775735
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 Dec 2014 Bundled Request
09 Dec 2014 Fixed
17 Dec 2014 Bundled Request
22 Dec 2014 Bundled Request
Description
A 605 error, "An attempt was made to fetch logical page '<pgid>' from cache '<cachename>'. Page belongs to <obj_name1> and not to <obj_name2>", may be sometimes reported when a transaction containing multiple CREATE and DROP INDEX commands is rolled back in a database that has the 'ddl in tran' option enabled.



CR:775787
CR Number:   775787
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2014 Fixed
22 Dec 2014 Fixed
09 Dec 2014 Fixed
Description
In a synchronous replication environment, a committed transaction may be mistakenly aborted internally by SAP ASE if the message "uppause: No free alarms available is reported in error log, resulting in data missing on the primary site while it was correctly replicated on the standby site.
Workaround Description
 Increase the "number of alarms" by the "number of user connections".

This can be achieved by running sp_configure "number of alarms", <n>.



CR:775820
CR Number:   775820
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   15.7 SP131 Goodyear
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2014 Fixed
23 Dec 2014 Fixed
Description
A 2628 error, "In database <>, page <> is linked forward to page <>, but that page is linked backward to page <>. Please report this internal error to Sybase Technical Support.", followed by a 644 error, "Index row entry for data row id <> is missing from index page <> of index id <> of table <> in database <>. Xactid is <>. Drop and re-create the index." may be reported when a DROP INDEX command is run concurrently with ONLINE CREATE INDEX command.



CR:775875
CR Number:   775875
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   AIX
Original Version:   15.7 SP131 Goodyear
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Dec 2014 Fixed
10 Dec 2014 Reservation Made
10 Dec 2014 Fixed
22 Dec 2014 Fixed
Description
Parallel queries may close their child threads before the child is completely drained. This can happen when non-correlated subqueries are flattened internally into existence joins. Unfortunately,

the child thread will continue to drain it's plan fragment even when the pipe it is

writing to is closed leading to bad performance.



CR:775934
CR Number:   775934
Product Name:   Adaptive Server Enterprise
Product Component:   charsets
Status:   Open
OS:   all
Original Version:   15.7 SP131
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
To add in big5-2003 symbols into ASE unicode conversion



CR:775943
CR Number:   775943
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP131 Goodyear
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2014 Fixed
22 Dec 2014 Fixed
23 Dec 2014 Fixed
Description
In rare circumstances, an aborted ONLINE CREATE INDEX or ONLINE REORG REBUILD may cause a subsequent UPDATE or DELETE command to hit a 644 error, "Index row entry for data row id <> is missing from index page <> of index id <> of table <> in database <>. Xactid is <>. Drop and re-create the index.".



CR:775947
CR Number:   775947
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   corona
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature: Provide built in functions hadr_state(), hadr_mode() and sp_hadr_admin stored procedure options "state", "mode" that provide descriptive output for globals @@hadr_mode, @@hadr_state.



CR:776004
CR Number:   776004
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Adding multiple partitions with later table using separate statements in a single batch

can raise Msg 712 insufficient heap memory.
Workaround Description
 Avoid using a single batch.



CR:776028
CR Number:   776028
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.7 SP122
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RA stops with 9204, cannot locate schema
Workaround Description
 Currently, all one can do is move the RA to read past the problem log record.





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