/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.1 SP00 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 |
|---|---|
| 822898 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 's_estmt_pssinit' together with a stack trace may be reported in the SAP ASE error log, sometimes following a 701 error, "There is not enough procedure cache to run this procedure ...". See KBA 2358848. |
| 824449 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'pci_tpminvoke_longfunction' together with a stack trace which includes the modules 'objVerifySerializability' and 'BRIDGEapi_DeleteGlobalRef' may be reported in the SAP ASE error log when inserting rows with Java object to a table with Java ADT column types. |
| 824865 | A 8009 error, "Error encountered by Backup Server. Please refer to Backup Server messages for details.", may be reported when 'LOAD DATABASE < database-name > with listonly=create_sql' is executed and previously a database dump was taken using a dump configuration file. |
| 826480 | The global variable @@triggerstatus is introduced in SAP Adaptive Server. It returns the value for the action that has caused a trigger to be executed that is either 1 when the trigger was executed by an INSERT statement, 2 by an UPDATE statement, 3 by a DELETE statement, or 0 otherwise. |
| 826612 | The message, "Current process infected with 11 (SIGSEGV)", in the module 'ptn__get_field' together with a stacktrace which includes the module 'mda_populate_monOpenObjectActivity' may be reported in the SAP ASE error log when querying the MDA table monOpenObjectActivity after running DROP INDEX WITH NOWAIT. See KBA 3205143. |
| 826720 | Improve error message 9829 "Compressed data row 0xxxxxxxxx in objid 1111111111, dbid 4 is corrupted." by including the page number the row is on. |
| 827149 | A 3621 error with state 2, "You cannot load this dump because it contains functionality (feature ID < invalid-value > ) that is available only on the server on which it was dumped.", may sometimes be reported when downgrading SAP ASE to a version that does not support some feature. See KBA 3252070. |
| 827511 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'prSQLTEXT' together with a stack trace which includes the module 'exec_dbcc' may be reported in the SAP ASE error log when DBCC SQLTEXT( < spid-value > ) is run against an active session. See KBA 3282789. |
| 828246 | Setting a BigDecimal type in prepared insert statement causes the scale part lost when executing the java code through JDBC dispatched in ASE server PCI/JVM. However directly executing the same code in standard JDBC client code can insert the value correctly. |
| 828331 | When server configuration 'enable granular permissions' is set to 1, the message "Permission related internal error was encountered. Unable to continue execution." is reported while executing command DBCC PRINTOLOG. |
| 829062 | SAP ASE diagserver may report an assertion failure, "Assertion ((rgadmlobp- > admlob_oldcolscopied + rgadmlobp- > admlob_oldcolsdropped) == rgadmlobp- > admlob_numoldcols) failed in < path > /generic/source/sequencer/pre_alttab.c" when a LOB column is changed from "materialized" to "not materialized" |
| 829138 | The message, "Current process infected with signal 11 (SIGSEGV)" in the module 'a_remapqblockvar' followed by a stack trace that includes the modules 'tree_traverse_roots', 'tree_traverse_roots' and 'ApPlan::ApInit', may be reported in the SAP ASE error log when a complex join query that involves at least 6 tables and outer joins is run. See KBA 3476885. |
| 829173 | The message "Sybmon encountered signal 11 at address os_get_prev_stk_desc + < offset > " may be reported when "profile" is run in sybmon on ibmaix64 platform. |
| 829481 | The message "ssl_nrpacket: vsn xxx kpid xxxxxx read returning -4 state 1" is reported in the SAP ASE error log when ASE performs a network receive on an SSL client that has disconnected abruptly. See KBA 3478645. |
| 829514 | The message, "Current process infected with signal 8 (SIGFPE)", or "timeslice < value > , current process infected at < address > ", in the module 's__collectdiagparam' may be reported in the SAP ASE error log when Adaptive Server has not restarted for long time. See KBA 2998380. |
| 829540 | When a MERGE command that has an UPDATE action which also assigns local variables is executed, SAP ASE will assign a NULL value to the second and subsequent local variables in the UPDATE action. See KBA 3531173. |
| 829574 | A 2742 message, "SET DATEFIRST < > is out of range." and 'Error: 2805, state: 20', may be reported by SAP ASE when a stored procedure is executed with recompile and the configuration options 'enable metrics capture' and 'enable literal autoparam' are enabled. See KBA 3492504. |
| 829608 | When TRUNCATE TABLE < table-name > PARTITION < partition-name > is executed, SAP ASE will rebuild the global indexes of the given table, even if the partition being truncated is empty. Additionally, the execution of DUMP TRANSACTION may be blocked for the duration of the global indexes rebuild. See KBA 3498667. |
| 829656 | The message, "Current process infected with signal 11 (SIGSEGV)", either in the module 'memfree' or 'sequencer' may be reported in the SAP ASE error log when running sp_showplan against a running spid. See KBA 3426914. |
| 829660 | Under rare circumstances, the message "timeslice < negative-value > , current process infected at free__linkedcst" together with a stack trace when inserting a parameterized text value into a unitext column using a dynamically prepared statement. See KBA 3531166. |
| 829803 | In rare circumstances, the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'plc__flush' together with a stack trace which includes the modules 'xls_pre_alloc_numclrs', 'xact_begin' and 'crt_main' may be reported in the SAP ASE error log when a stored procedure is run. |
| 829918 | In rare scenarios, a hang can be observed after hitting error 1249 followed by error 1251 and 6103 with stack containing symbols lock__semawait, log__lock, xls__get_lastlogbp, plc__flush on AIX platform. See KBA 3536134. |
| 829983 | The MDA table monSQLRepMisses may indicate Configuration instead of QueryLimitation as the cause for some queries which are not eligible for SQL statement replication. |
| 829999 | A 4402 error, “Infinite loop in view definition. Cannot resolve the view definitions in the query to the underlying tables.”, may be reported by SAP ASE when querying a view that references a SQL Function that is using a TUDF (Table User Defined Function) and before the query execution the SQL Function has been recreated. |
| 830005 | Limit 'create database' and 'drop database' to only saptu when 'cloudservice' is enabled. |
| 830014 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'LeRun' together with a stack trace may be reported in the SAP ASE error log when querying a view that includes table-valued UDFs and performs a hash union distinct join. See KBA 3542784. |
| 830015 | In rare circumstances, SAP Backup Server may run out of server connections when a client fails to connect to it and the two messages, "Backup Server: 1.28.2. < state-value > : Open Server routine srv_senddone failed. See Backup Server error log for additional information.", with state values 49 and 51 are reported in the Backup Server error log. See KBA 3542841. |
| 830030 | In rare circumstances, the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'xls_pre_alloc_numclrs' together with a stack trace which includes the modules 'lrd_log_run_dealloc', 'dmpx_truncatemain' and 'ckptproc' may be reported in the SAP ASE error log when the checkpoint task does checkpoint a database. See KBA 3535124. |
| 830034 | Enable sequence when "functionality group" is ON |
| 830117 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'xact_rollback' together with a stack trace which includes the module 'set_repdb_off' may be reported in the SAP ASE error log when the command SP_REPTOSTANDBY < database-name > , 'NONE' is executed on an active system and is victim of a deadlock. See KBA 3545082. |
| 830195 | In rare circumstances, a 12858 error, "Update to sysobjects row for database ' < database-name > ' ( < database-id > ), object 'rs_ticket_history' ( < object-id > ) failed.", may be reported in the SAP ASE error log together with a stack trace which includes the modules 'dpdb_main', 'checkpoint’, des_idtflush' and 'obj_updrow' when DUMP DATABASE is run on an HADR system and concurrently table 'rs_ticket_history' is being dropped. See KBA 3564105. |
| 830209 | The default value for optimize temp table resolution depends on the value to which enable functionality group is set. If you set enable functionality group to: 0 – the default value for optimize temp table resolution is 0. 1 – the default value for optimize temp table resolution is 1. However, if you set optimize temp table resolution to 1, it uses a value of 1 regardless of what you set enable functionality group to. |
| 830254 | An error 10364, "Permission denied.", is reported when a user other than the dbo and without sa_role or replication_role, executes the system stored procedure SP_SETREPTABLE or SP_SETREPPROC without any parameter in order to list the replicated objects in the current database. See KBA 3556852. |
Read more...
Environment
- AIX 64bit
- Linux on x86 64 64bit
- Windows on x64 64bit
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR, CR List, ASE 16.1,SP00 PL01, 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)