/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 SP04 PL10. 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 |
|---|---|
| 820675 | Procedure cache fills due to subordinate procedure plans not being cleaned up. See KBA 3421119. |
| 828068 | In rare circumstances, a 702 error, a 724 error or the message "current process infected with 11" together with a stack trace which includes the modules 'treecpynames', 'cpynamelist' and 'vu_viewcopy' may be reported in the SAP ASE error log if a query involving views including derived tables with UNION/UNION ALL runs. See KBA 3339850. |
| 828332 | execute as (caller/owner) clause is added for trigger creation. Existing trigger creation(without any clause) and execution behaviour is same as earlier |
| 829509 | In rare circumstances, a 7452 error, "Failed to find specified threshold in threshold cache on instance 1 for database < database name > ( < database id > ), segment < segment number > , free space < > . Use 'dbcc thresholds' to see the threshold cache contents.", may be reported in the SAP ASE error log. After this error, dump database may fail with a 1166 error, "You cannot execute the command 'DUMP' on database < database name > because it was created with asynchronous initialization and it has not been fully initialized. Retry the command later.". See KBA 3484901. |
| 830688 | Provide a mechanism to prevent sparse files from being created when a device resides on a tmpfs filesystem. See KBA 3600264. |
| 831033 | A 12308 error, "Internal error: Invalid row id (Row < row > , Page < page > ) encountered in the table ' < table > ' in database ' < database > '.", may be reported in the SAP ASE error log after a REORG REBUILD WITH ONLINE command has been executed on a large DOL table with page compression enabled, when the housekeeper garbage collection task processes a page that was deallocated by the REORG operation before post-commit processing has completed. See SAP note 3636010 |
| 831356 | Poor performance and high engine utilization can be seen on active servers when the monitoring options "statement pipe active" and/or "statement statistics active" are active. See KBA 3752594. |
| 831397 | High spinlock contention on the SSQLCACHE_SPIN[i] is observed when there is high turnover in the statement cache pool. See KBA 3677140. |
| 831565 | Error message 247, "Arithmetic overflow during implicit conversion of UNSIGNED INT NULL value 'xxxxxxxxxx' to a INT field ." can be raised when performing a query that does an ORDER BY SUM() on an unsigned integer column while using the allrows_dss optgoal. See KBA 3696096. |
| 831604 | The message, "timeslice -1001, current process infected at ", in the module "pausenonatomic" or "x64_lock" together with a stack trace which includes the modules "bufsearch_cache_getlatch", "has_privilege", "ex__doprint" and "log_to_virt" may be reported in the SAP ASE error log while extend database. See KBA 3699305. |
| 831709 | A very large amount of procedure cache may be consumed by a query performing an EXCEPT or MINUS clause against a table with millions of rows. See KBA 3707695. |
| 831766 | sp_configure "o/s file descriptors" can report a different value for Config Value compared to Run Value if the ASE has been upgraded and the Run Value has changed since the last upgrade. See KBA 3713631. |
| 831848 | Error 834 State 3 on two different dbids on the exact same BUF. See KBA 3748008. |
| 831858 | In rare circumstances a SIGSEGV (Signal 11) in prXITEM() can happen when DBCC SHOWRECOVERY is executed during ongoing recovery processing. |
| 831879 | Infected with signal 11 (SIGSEGV) at address in idxpi_memfree(). See KBA 3734475. |
| 831882 | While loading a database dump, a 631 error with state 3 is raised with the message "The length of xxx passed to delete row routine for the row at offset 0 is incorrect on the following page of database ' < database name > ': Page pointer = < address > , pageno = < page number > , status = < address > , ptnid = < partition ID > , indexid = 0, level = 0, pnextrno = 0. The expected row length is < length > . The offset should be no greater than < offset value > ." in the recovery redo phase. See KBA 3729693. |
| 831897 | Following a 1204 error, the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'setuser' together with a stack trace may be reported in the SAP ASE error log. See KBA 3733477. |
| 831914 | A 247 error, " Arithmetic overflow during explicit conversion of DATE value 'Dec 17 1899' to a SMALLDATETIME field .", may be reported in the SAP ASE error log during executing a parallel SELECT query with the getdate() and convert() built-in functions. See KBA 3735305. |
| 831948 | An 10350 error, "Permission related internal error was encountered. Unable to continue execution", may be reported if using "sp_configure 'configuration file'" to update configuration file with GP enabled. |
| 831971 | The Secondary Truncation Point of all the replicated databases of an HADR system may stop moving. See KBA 3742840. |
| 831991 | When performing an upgrade with SSL enabled on AIX, the upgrade tool might fail due to an internal network library error. |
| 832002 | The command DUMP TRANSACTION hangs when executed on the primary ASE of an HADR system. Rep Agent eventually raises an error 9416, "Rep Agent on database ' < database-name > ' switched from mode 'sync' to mode 'async' because timer on commit expired". See KBA 3762374 |
| 832015 | The message, "Current process infected with signal 11 (SIGSEGV)", together with a stack trace which includes the module 's_execute' may be reported in the SAP ASE error log after the message "SIGSEGV is caught by VEH_execute()" is reported from a query using a TUDF. See KBA 3745284. |
| 832024 | The upgrade or preupgrade utility will fail to connect if the length of the sa password is 30 bytes long. |
| 832027 | The hashkey value stored for sysquerymetrics does not match the hashkey generated in monCachedStatement for a cached statement when 'set plan dump' is enabled and trace flag 11032 is enabled. See KBA 3746812. |
| 832057 | In rare circumstances, timeslice error may be encountered with a stack trace which includes the modules 'lddb__unscr_phys_page' reported in the SAP ASE error log when performing a cross-platform load of a dump containing unallocated encrypted SYSLOG pages from the source database. |
| 832111 | Spinlock Contention on fglockspins may be high under heavy load when server configuration 'enable granular permissions' is enabled in the ASE server. See SAP note 3789757. |
| 832131 | SAP ASE Workload Analyzer Command Line Utility (WLACLIUtil) may not refresh the analysis progress for long time when a capture or replay is being analyzed. |
| 832133 | SAP ASE Workload Analyzer Command Line Utility (WLACLIUtil) may run slowly when the analysis progress is close to or at 80%. |
| 832139 | SAP ASE Workload Analyzer Command Line Utility (WLACLIUtil) is enhanced to support parallel analysis which can be enabled by setting ASECAT_PARALLEL_TDS_FETCH=1. |
| 832182 | A 245 error, "Domain error during implicit conversion of DECIMAL value '' to a DECIMAL field," may be reported in the SAP ASE error log during the execution of a SELECT query when a DECIMAL parameter is required in a parameterized view. |
| 832207 | A 12001 error, "Data collection failed: Command 'netstat -ea' failed (Exit code 1): Cannot run netstat - execvpe failed (ENOENT - No such file or directory)", may be reported from SAP ASE Sybdiag utility while it is used to collect osdata with "-Tosdata" option on SuSE 15 or above versions. |
| 832252 | SAP ASE Workload Analyzer Command Line Utility (WLACLIUtil) may run slow when analyzing a capture or replay that contains many big queries. |
| 832272 | A new option, "-Q", is added to SAP ASE Sybdiag utility to suppress the console log output. |
| 832297 | SAP ASE Sybdiag utility may not report os_iostat data correctly on Linux servers which kernel is 4.x (like SuSE 12.5, RHEL 7.x/8.x etc.) |
| 832456 | FOSS in sybrestore are upgraded to latest version. |
| 832459 | FOSS of SAP ASE Workload Analyzer Command Line Utility has been upgraded to the latest version. |
Read more...
Environment
- AIX 64bit
- HP-UX on IA64 64bit
- Linux on x86 64 64bit
- Solaris on Sparc 64bit
- Windows on x64 64bit
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR, CR List, ASE 16.0 SP04 PL10, ASE SP06 PL10, SP04 PL10 Adaptive Server Enterprise, Fix, Patch, Error, Bug , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)