/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in Adaptive Server Enterprise (ASE) 16.0 SP02 PL01. Please be sure to read the Disclaimer below.
If the EBF/SP has been released, check the CR list and coverletter at the support.sap.com.
Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release.
| CR Number | Description |
|---|---|
| 785554 | Under UTF8 sort order 99, if a composite index contains a leading NULL VARCHAR field, REORG REINDEX may not be able to rebuild the index. |
| 785701 | In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #= < > , object id = < > ..." is reported by SAP ASE during a LOAD TRAN of a transaction dump that includes a transaction of online REORG REBUILD or non-online CREATE INDEX if the earlier portion of load sequence contains a transaction of online CREATE INDEX with deferred recovery. |
| 786420 | KBA 2201449: A 15413 error, "An internal error occurred during an encryption operation (error code < n > ). Please contact SAP Technical Support", may be reported when selecting data from encrypted columns. |
| 786780 | In rare circumstances, the message "current process infected with signal 11" in the module OptGlobal::_GblAddTopLevel() together with a stack trace which includes the module emitMatchProperties() may be reported when running a complex query. |
| 787016 | There is a high probability that the ASE native thread segmentation fault caused server crash in dumping shared memory when the dump configured with multiple dump threads. |
| 787024 | When SAP ASE RepAgent is configured for stream replication in synchronous mode, the primary database may run out of log space if most of the activity in this database is performed on non-replicated objects. |
| 787759 | In HADR cluster, during planned failover, client connections do not get killed and therefore they linger on old Primary server and receive Msg 2379, "The primary server has been successfully deactivated" rather than failing over to the new primary server. |
| 788022 | The config value of 'wait on uncommitted insert’ and ‘enable bulk inserts’ changed when sp_configure other parameters. |
| 788087 | In some circumstances, the message, "Current process infected with signal 11 (SIGSEGV)", may be reported in the error log together with a stack trace which includes the modules 'tmp_get_tmpobj_by_name' and 'open_range' when multiple Table UDFs are involved in a query. |
| 788228 | When SAP ASE RepAgent is configured for stream replication in synchronous mode, the time reported by sp_hadr_admin 'failover_timeestimate' may be inaccurate when SAP RepAgent is not running. |
| 788474 | KBA 2211717: Under some rare condition, if columns in a table have more than one constraints (not necessary in the same column), it can cause invalid rows to be inserted. |
| 788609 | Full DB encryption could run into error 2956 if the buffer size is not configured to be sufficient. |
| 788772 | The replay of workload may fail for connections that had already been established at the time that the original capture was initiated. |
| 788791 | A 2628 error, "In database < dbname > , page < pageno_1 > is linked forward to page < pageno_2 > , but that page is linked backward to page < pageno_3 > . Please report this internal error to SAP Technical Support", may be encountered when using a Latch Free index in a high concurrency environment. |
| 788808 | Improper text may be generated while running sp_helptext in a procedure which has SET < some option > ON followed by the COMMIT statement. |
| 788861 | In an HADR cluster, if Granular Permission is enabled, replication may stop with DSI reporting a permission error, such as "ERROR #1028 DSI EXEC" due to SRS encountering ASE error "Message: 10330 'INSERT permission denied on object ....'". |
| 788898 | The execution of DBCC CHECKSTORAGE on the master database may erroneously report faults 100009, 100029, and 100030 on the sysanchors table. |
| 788921 | langinstall fails to install language on AIX Platform using LDAP directory services. |
| 788942 | A 644 error, "Index row entry for data row id < row_id > is missing from index page < page_no > of index id < index_id > of table < table_name > in database < db_name > . Xactid is < trans_id > . Drop and re-create the index.", may be reported against a Latch Free index created for a large table which has a lot of duplicate keys. |
| 789141 | SAP ASE unnecessarily requires that the command "load database master with listonly=load_sql" be run in single user mode and it also prints the message, “WARNING: In order to LOAD the master database, the ASE must run in single-user mode”. |
| 789251 | In rare circumstances unexpected results could be returned when a query involving a LIKE clause is executed inside a stored procedure run WITH UPGRADE option (or which required to be upgraded internally from source text) and the LIKE clause references input parameters defined in the stored procedure. |
| 789323 | The message, "The log for database < dbname > includes a CREATE INDEX (with deferred roll-forward) operation that is incompatible with this server version and operating environment." may be reported during LOAD TRAN if the transaction dump contains an index that will be recovered as deferred item during the LOAD TRAN recovery. |
Read more...
Environment
- AIX 64bit
- HP-UX on IA64 64bit
- Linux on Power 64bit
- Linux on x86 64 64bit
- Solaris on Sparc 64bit
- Solaris on x86 64 64bit
- Windows on x64 64bit
Product
Keywords
CR, CR List, ASE 16.0 SP02 PL01, ASE SP02 PL01, SP02 PL01, SP02 PL 01, Adaptive Server Enterprise, Fix, Patch, Error, Bug, GA SP02 PL01 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)