/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 PL06. 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 |
|---|---|
| 754150 | When REORG RECLAIM_SPACE is run SAP ASE fails to clear out OAM entries with zero used/unused counts for a table, while REORG COMPACT and REORG FORWARDED_ROWS utilities are able to do so. The session trace flag 11908 can be used to disable this cleanup when these REORG utilities are run. |
| 823906 | A 1157 error, "Insert free space value < negative-value > in page header of DOL datapage < page-number > belonging to object id < object-id > in database ' < database-id > ' is incorrect. It has been recomputed and is now < negative-value > .", may incorrectly be reported by SAP ASE when the table attribute "exp_row_size" has been changed via sp_chgattribute for a table with existing data. See KBA 3010154. |
| 824031 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'sdes_hookup' together with a stacktrace which includes the modules 'builtin_derived_stat' and 'getid' may be reported in the SAP ASE error log when executing the built-in derived_stat(). See KBA 2343934. |
| 825520 | The error message, "Backup Server: 5.16.2.2: Client-Library error: Error number 44, Layer 4, Origin 1, Severity 188978561028: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed..", may be reported by SAP Backup Server when DUMP DATABASE is executed and Kerberos authentication is enabled in Adaptive Server. See KBA 3422498. |
| 828017 | A 631 error, "The length of < length > passed to delete row routine for the row at offset < offset > is incorrect on the following page of database ' < database-id > ': < page-id > . The expected row length is < length > . The offset should be no greater than < offset > .", may be reported in the SAP ASE error log during runtime rollback with PAGE_COMPRESS log records. See KBA 3420711. |
| 828188 | In rare circumstances, heavy latch contention may be seen with SAP ASE when many concurrent INSERT or WRITETEXT operations are executed in a very large database. See KBA 3415716. |
| 828344 | The stored procedure sp_passwordpolicy silently ignores the fourth parameter when using the 'set' option for any setting other than 'keypair regeneration period'. See KBA 3372056. |
| 828369 | A 15497 error, "The password for the master key of database 'master' has not been set", may be reported when Adaptive Server tries to decrypt database sybsystemdb/sybsystemprocs during SAP ASE restart. See KBA 3373725. |
| 828415 | A 208 error, "tempdb..syslkstats not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).", may be reported when sp_object_stats system procedure is executed by the login user sapsupport. |
| 828470 | A 247 error, "Arithmetic overflow during implicit conversion of BIGINT value '2166745886' to a INT field.", may be reported when the system stored procedure sp_sysmon_taskmgmt is executed. See KBA 3381723. |
| 828550 | SAP ASE may report inconsistent I/O activity data for temp tables in the monIOQueue MDA table. See KBA 3390201. |
| 828553 | Upgrade SAP CCL library to version 8.5.52. |
| 828603 | SAP Adaptive Server may fail to bootstrap and produce a core dump file during startup after having upgraded SUSE operating system glibc library to version 13.2 which includes library version libstdc++.so.6.0.32. See KBA 3394455. |
| 828605 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'ct__api_state_trans' together with a stack trace may be reported in the SAP ASE error log when a Component Integration Service (CIS) query is executed. See KBA 3394426. |
| 828630 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'apply_grrev' together with a stack trace which includes the modules 'grantrev' and 's_execute' may be reported in the SAP ASE error log when GRANT or REVOKE is executed. See KBA 3411308. |
| 828691 | A 14218 error, “Cannot create or execute a SQLJ UDF, because Java services are not enabled.”, may be reported by SAP ASE when executing a stored procedure which includes a function that has not been yet created because the configuration option “deferred name resolution” is enabled. See KBA 3422986. |
| 828710 | The fix made in CR 822733 for encrypted databases and released in 16.0 SP04 PL03 and 16.0 SP03 PL12 is backed out in the current CR 828710 because it causes issues. See KBA 3411406. |
| 828711 | In a high concurrency system, some SQL descriptor memory from the procedure cache may be reallocated to a new session, yet another session may still access this memory. This can cause SIGSEGV errors to be reported in the SAP ASE error log while a session is accessing this memory. See KBA 3464047. |
| 828736 | ASE Webservices is responding to HTTP TRACE and TRACK request during ASE Webservices is running. See KBA 3422047. |
| 828738 | In rare circumstance the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'get_range_sdes' together with a stack trace which includes the modules 'StoredTab::open()' and 's_compile_stmt' may be reported in the SAP ASE error log when a query is being compiled. See KBA 3408394. |
| 828786 | In HADR setup, the command "sp_hadr_admin setlogin, < login > " will fail and the error "Arithmetic overflow during implicit conversion of INT value to a UNSIGNED INT field" will be reported, if login which has negative suid is being used during setlogin. See KBA 3418052. |
| 828797 | Print a diagnostic message to the ASE error log when a manual memory dump is taken. |
| 828803 | In rare circumstances, the message "Current process infected with signal 11 (SIGSEGV)", together with a stack trace which includes the module 'bufunkeep_do_decrement()' may be reported in the SAP ASE error log when DBCC CHECKSTORAGE is executed for encrypted database. |
| 828809 | The error message, "Archive API information for device='syb_tsm:: < stripe-device-path > ': Vendor application name=Sybase-TSM API, Library version=2, Message=Tivoli Storage Manager error returned. Message = ANS1302E (RC2) No objects on server match query", may be reported in the SAP Backup Server error log when a DUMP command is executed using TSM. Despite this error, the Backup Serve error log displays a conflicting message stating that the "Dump is complete" suggesting that the dump database command was executed successfully which is incorrect. See KBA 3411362. |
| 828815 | The SAP Adaptive Server system stored procedure sp_sysmon is enhanced to report the top 10 spinlock activities by spins and contention. See KBA 3422968. |
| 828820 | In rare circumstances the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'procrm' together with a stack trace which includes the modules 'd_proccache' and 'freeprocs' may be reported in the SAP ASE error log when DBCC PROC_CACHE is executed. This may sometimes lead to an implicit shutdown of Adaptive Server. See KBA 3301324. |
| 828870 | DBCC PDES is enhanced for debugging purposes to print the OAM hints array stored in the partition descriptor structure. See KBA 3415735. |
| 828877 | A 102 error, "Incorrect syntax near '/'.", may be reported by Replication Server DSI resulting in a shutdown when an INSERT-SELECT command is replicated and SQL Statement Replication feature is enabled in a Business Suite HADR setup. This error is seen when the object name is using complex identifiers. |
| 828883 | In rare circumstances, the message, "Current process infected with signal 11 (SIGSEGV)", together with a stack trace may be reported in the SAP ASE error log during the execution of a query plan in systems using index compression feature. The stack trace for the killed connection may report different information depending on the victim’s code path and the procedure cache memory corruption caused by concurrent index decompression operations being executed. See KBA 3464195. |
| 828889 | Running KILL < spid > WITH FORCE on an active process may result in leaving a buffer latch request queued in SAP ASE which may lead to a stall system. See KBA 3415756. |
| 828900 | A 712 error, "There is insufficient heap memory to allocate < number > bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system.", may be reported when DBCC LISTOAM is run against a very large table. See KBA 2139552. |
| 828913 | In rare circumstances the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'memalloc' together with a stack trace which includes the modules 'rvm__audit_getcommand_subcommand' and 'ex_audit' may be reported in the SAP ASE error log when auditing is enabled and an error for a client cursor is being processed. See KBA 3425476. |
| 828917 | In rare cases, the PhysicalReads column in monProcessActivity system table may report negative value when insensitive cursor is executed. |
| 828953 | The TCP/IP incoming connections backlog queue for SAP ASE on Linux is restricted to 128, potentially causing certain clients to fail to connect during a surge of incoming connection requests. Similarly, this issue can arise on the Solaris platform, where the backlog queue is limited to 256. See KBA 3419671. |
| 828984 | A 3052 error, "DUMP TRANSACTION requires a dump configuration name because the configuration option 'enforce dump configuration' is enabled.", may be reported by SAP ASE when DUMP TRANSACTION is run while the configuration option 'enforce dump configuration' is set, but the dump succeeds instead of failing. See KBA 3429418. |
| 828986 | Enhance transfer encryption key command to import/export Database Encryption Key to/from a file. |
| 829008 | SAP Adaptive Server fail to bootstrap and report the message, "ASE_PCI: failed to bridge Pluggable Component Interfaces with code -77", on SLES 15 SP6. See KBA 3425215. |
| 829024 | When ALTER DATABASE SUSPEND ENCRYPTION is executed, the command may hang after the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'fm_item_by_index' together with a stack trace which includes the module 'ea_encrypt_decrypt_db_main' is reported in the SAP ASE error log. |
| 829097 | SAP Adaptive Server is enhanced to suppress SSL messages for module 'ssl_server_handshake' from being reported in the ASE error log. The ASE trace flag 7871 enables this behavior. See KBA 3442564. |
| 829123 | The error message, " < archive-name > is not a valid file path.", may be reported with SAP ASE 16.0 SP04 PL05 release when DUMP DATABASE is executed and the < archive-name > includes a double dot ".." character. See KBA 3442246. |
| 829140 | In rare circumstances, a shared memory dump taken with SAP ASE may run into hang on SuSE 15.6 or later versions. |
| 829170 | A 3512 error, "Cannot checkpoint database < database-name > because its status is: not usable.", may be reported when sp_dboption is executed on an Archive Database to enable the 'single user' option. |
| 829220 | In rare circumstances the message, "Remapping failure for the query: < query-text > ", may be reported in the SAP ASE error log when executing a query which involves parameterized views. |
| 829240 | In rare circumstances, an interrupt request send by the application to Adaptive Server may be acknowledged while a user local transaction was in process, resulting in this transaction being rolled backed implicitly but unexpectedly. Thereafter a 12104 error, "A LOCK TABLE command is not allowed outside the scope of a transaction on table ' < table-name > ' in the database ' < database-name > '." may be reported by SAP ASE, or the message, "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = 1, Current count = 0.", may be seen in the SAP ASE error log. See KBA 3446837. |
| 829267 | SAP ASE may implicitly shutdown when CREATE, ALTER, or DROP ENCRYPTION KEY command is executed for HSM key after ASE was restarted, due to a SIGTRAP signal. The message, "fatal: morestack on g0", will be reported in the SAP ASE error log. |
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 PL06, ASE SP04 PL06, SP04 PL06 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/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)