/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 PL00. 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. |
| 769843 | In some circumstances, SAP ASE may return an incorrect result set for a SELECT query, when the configuration option "disable varbinary truncation" is enabled and a unique index exists on a varbinary column of a DOL table, and the index is used by the query execution. See KBA 3380593. |
| 774290 | A 823 error, "I/O error detected during read for BUF= < # > , MASS= < # > , Buf= < # > , page= < # > , dbid= < # > , Mass vdevno= < # > , vpage= < # > , Buf lpage= < # > ,Mass stat= < # > , Buf stat= < # > , size= < # > , cid= < # > ('default data cache'), Pinned xdes= < # > ,spid= < # > ", and a 15754 error, "Unable to read and decompress the block that contains page 25 in the archive database ' < # > '", may be reported by SAP ASE when trying to load dumps that were taken with different compression levels. |
| 782482 | SAP ASE Sybdiag utility is enhanced to include jsagent log file and some other diagnostic information. |
| 812699 | set show_object_list on does not provide object information for cache statements. |
| 816038 | The message, "SYBMULTBUF ERROR: Internal error: In get_init_command, expected C_INIT command. Instead, received command = 0.", may be reported in the Backup Server error log during a backup execution when there is a mismatch between 'backupserver' and 'sybmultbuf' binaries versions. See KBA 2675940. |
| 819750 | In some cases, ASE data compression ratio is nearly 60%, but MSSQL data compression ratio is nearly 90%. So compared with MSSQL, ASE data compression ratio is not high. |
| 820309 | The message, “Current process (0x5f0554d0) infected with signal 11 (SIGSEGV)”, in the module ‘ubfgrow’ together with a stack trace which includes the module ‘memallocheap’ may be reported in the SAP ASE error log due to heap memory corruption. When Adaptive Server is bootstrapped with trace flag 797 instrumentation logic will be enabled allowing to capture the process causing this issue. See KBA 2858959. |
| 820878 | Feature request for an option to revert to previous auditing behavior where the text of the associated command was not stored in the extrainfo column. See KBA 2896259. |
| 820881 | DBCC CHECKDB improvements for very large databases. See KBA 2895917. |
| 822063 | A feature request to support TLS 1.3 in ASE and CCL. See KBA 2942212. |
| 822514 | The output of DBCC HOTBUFS may report a database id of 0 (dbid) for buffers that have been freed to the LRU end chain of the buffer cache. See KBA 2957818. |
| 822641 | The full text of the DUMP and LOAD commands that were run in SAP ASE will now be logged in the Backup Server error log. |
| 823033 | In HADR setup with fault manager configured, the fault manager will fail to boot and heartbeat errors like "heartbeat died after startup" can be seen in FM log (dev_sybdbfm)) |
| 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. |
| 824462 | The error message, "Backup Server: 4.141.2.66: [0] The 'write' call failed for database/archive device while working on stripe device < stripe-device-path > with error number 32 (Broken pipe). Refer to your operating system documentation for further details.", may be reported in the Backupserver error log when DUMP DATABASE is executed. See KBA 3061896. |
| 824712 | The ch_events view in sybsecurity is empty when then "audit trail type" is set to "syslog". Providing a new mechanism (independent of auditing infrastructure) to read out ASE configuration changes. |
| 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. |
| 825583 | The new LOAD_STATUS option for the LOAD DATABASE ... WITH LISTONLY command allows SAP ASE to check if the LOAD DATABASE execution would have failed with either error 3105, “Data on dump will not fit into current database. Need < > Mbyte database.”, or error 3185, “The < > segment in the target database < > is too small ( < > MB) to accommodate the < > segment from the dumped database ( < > MB).”. |
| 826348 | The message, "stack_tracer: stack overflow last chance handler. Task < kpid-value > has completely exhausted stack at line ...", may be reported in the SAP ASE error log when a stored procedure that is calling a user defined function which is using a temporary table is interrupted. See KBA 3168911. |
| 826360 | In rare circumstances, the frequent message with transaction commit wait expired will be reported in primary ASE error log when the primary ASE is restarted from crash situation or shutdown with wait nowait_hadr. |
| 826382 | The 'LockRequests' and 'LockWaits' columns for MDA tables monOpenObjectActivity and monTempdbActivity may report lock statistics data which unexpectedly include lock statistics data for internally scanned system tables. |
| 826576 | A new configuration option 'number of backup config files' is introduced in SAP ASE to allow setting the number of configuration files. |
| 826815 | Feature enhancement to provide ability to read out data from table with corruption. See KBA 3358688. |
| 826820 | SAP Adaptive Server is enhanced to allow grouping of network controllers based on application name. See KBA 3268863. |
| 827219 | In rare circumstances, misleading information may be reported in the SAP ASE error log during the recovery of a database. For example, the message, "Redo pass for database ' < database-name > ': 1220408100 records done (99%); 13 records left.", is unexpectedly followed a couple of hours later by the message, "Redo pass of recovery has processed < number-of-records > committed and < number-of-records > aborted transactions.", although the expectation is that Adaptive Server would have needed few minutes only to recover the reported 13 log records and complete the Redo pass phase. |
| 827243 | The online partition utilities are made compatible with DDL replication. |
| 827358 | A 7452 error, “Failed to find specified threshold in threshold cache on instance 1 for database < database-name > ... Use 'dbcc thresholds' to see the threshold cache contents.”, may be reported by SAP ASE when sp_dbextend is run against a mixed log and data database. Additionally the status for the segment ‘logsegment’ will be changed to “disabled by LCT”. See KBA 3268402. |
| 827431 | The stored procedure sp_displayaudit will report NULL for Subject Name if auditing for a login is enabled and that login has been dropped. See KBA 3277237. |
| 827437 | A 5899 error, "The value of the 'max memory' parameter ( < value > ) defined in the configuration file is not high enough to set the other parameter values specified in the configuration file.", may be reported when trying to set the value for "number of open databases" to a very high value (over 5300) even though there is sufficient memory available. See KBA 3452741 |
| 827492 | In SAP ASE sample extended stored procedure program xp_echo.c fails to compile with error "xp_echo.c:20:18: fatal error: port.h: No such file or directory". See KBA 3281995. |
| 827541 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'vu_materialize' together with a stack trace including the modules 's_recompile' and 's_recompile' may be reported in the SAP ASE error log when a database is quiesced or when the transaction log gets full while querying a view. See KBA 03470774. |
| 827848 | The message, "Assertion (xdes- > xcomplogbytesleft_diag > = 0) ", may be reported in the SAP ASE error log during the ROLLBACK of a CREATE INDEX with ONLINE command and the diagserver binary is in use. |
| 827916 | Enhance the shutdown command to supply a user defined message to the log during shutdown. See KBA 3323967. |
| 828109 | Feature enhancement to have the 1621 error message specify the ip address and port that sent the incorrect packet. See KBA 1973518. |
| 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. |
| 828195 | The descriptions reported by sp_helpconfig for multiple configurations are incorrect or incomplete. See KBA 3425488. |
| 828201 | The global variable @@heapmemsize may return a large negative value if the size of the SAP ASE configuration option 'heap memory per user' exceeds 2GB. See KBA 3355209. |
| 828237 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'Optimize' together with a stack trace which includes the module 'open_range' followed by a second signal 11 occurrence in the module 'tabvar_release' may be reported in the SAP ASE error log when INSERT TABVAR SELECT statement is run. See KBA 3357731. |
| 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. |
| 828550 | SAP ASE may report inconsistent I/O activity data for temp tables in the monIOQueue MDA table. See KBA 3390201. |
| 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. |
| 828637 | A 605 error, "An attempt was made to fetch logical page ' < page-number > from cache 'default data cache'...", together with a stack trace while includes the modules 'extent_reconfigure' and 'pg_zapoam' may be reported in the SAP ASE error log when DBCC REBUILDEXTENTS is run on an All Pages Locked (APL) table. |
| 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 SAP ASE error log when a manual shared memory dump is taken with the Sybmon utility. |
| 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. |
| 828827 | In rare circumstances, random messages, "Current process infected with 11 (SIGSEGV)", or other errors like a 8201 error, "Keep count of descriptor (objid= < > , dbid= < > ) was expected to be < > . Instead < > was found.", together with a stack trace, may be reported in the SAP ASE error log when Adaptive Server runs out of "open objects", "open partitions", or "open indexes". |
| 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. |
| 828901 | In rare circumstances an undetected deadlock may occur in SAP ASE between three sessions, when one session executes reserved_pages() built-in on syslogs, another session executes an INSERT which requires additional space allocation for logging needs, and another session attempts to expand the database log via ALTER DATABASE. See KBA 3464199. |
| 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. |
| 828933 | A site handler process will appear to hang after receiving an invalid packet. See KBA 3417710. |
| 828937 | In rare circumstances, SELECT INTO may hang on heavily loaded SAP ASE systems when executed into an in-memory database with a call stack which includes the modules 'pg__allocate_in_oamcreate', 'getpage__noscan', 'getpage_with_validation' and 'bufsearch_cache_getlatch'. See KBA 3418026. |
| 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. |
| 828966 | The message, "The page number for page < page-number > in the buffer < buffer-address > found zero (ppageno = 0, pptnid = 0, pindid = 0, ppstat = 0x0, pts_hi = 0000, pts_lo = 00000000). This may indicate uninitialized page.", may be reported in the SAP ASE error log when trace flag 829 or 830 is enabled although there is no reason per se. |
| 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. |
| 829006 | The message text for error 12944 has been enhanced with, "The insert free space value ( < value > ) in the page header of DOL datapage < value > , partition ID < value > is not equal to the sum of cfs and ncfs ( < value > ) in the page, recomputation of insfs will be attempted.", and when the recompute gives the same values the new informational message, "The Insert free space value ( < value > ) in the page header of DOL datapage < value > , partition ID < value > has not changed. Plan to run REORG REBUILD for table ' < value > '.", will be reported by DBCC CHECKTABLE. |
| 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. |
| 829094 | SAP ASE will support 'threaded' kernel mode only. 'Process' kernel mode is deprecated. |
| 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. |
| 829100 | If reserve_identity() built-in function is called against a table in another database, error 10330 may be reported with a message "INSERT permission denied" on the wrong table and database names although the user has the INSERT permission on the given table. See KBA 3434663. |
| 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. |
| 829152 | In rare circumstances a 2622 error, "Insufficient room on this page to insert a row of length < > . Page pointer = < > , pageno = < > , status = < > , ptnid = < > , indexid = 0, level = 0, pnextrno = < > .", together with a stack trace which includes the module 'dol_putdrow' may be reported in the SAP error log when a row for a DOL table is either inserted or updated. See KBA 3514582. |
| 829167 | The optimizer may have incorrect costing resulting in a poor performing plan when the page count of a table in the query exceeds 2147483647 pages. See KBA 3441930. |
| 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. |
| 829234 | When sp_serverinfo is executed by a high number of sessions this results in high accumulated logical I/O on the syscurconfigs system table which causes performance degradation. See KBA 3445837. |
| 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. |
| 829247 | The message, "Current process infected with signal 11 (SIGSEGV)", together with a stack trace which includes the module 'os_schedcoma' may be reported in the SAP ASE error log when starting the server using process mode on AIX. See KBA 3448238. |
| 829254 | In rare circumstances, a user task in SAP ASE may indefinitely sleep in the module 'xls_flush_plcqueue' while detaching an external transaction which action triggers the User Log Cache of the task to be flushed in the syslogs system table. See KBA 3448476. |
| 829259 | A 11105 error, "No such user/role ' < name > ' exists.", followed by a 7729 error, "Invalid role string ' < name > ' entered.", may be reported by SAP ASE when SET PROXY < user-name > is executed while Adaptive Server was started with trace flag 859 and < user-name > has a role name that is exactly 30 bytes long. See KBA 3451391. |
| 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. |
| 829292 | Adaptive server enterprise new stored procedure "sp_helpaltermessage" will report message altered for "WITH_LOG" or "WITH_STACK". See KBA 3452284. |
| 829297 | A 530 error, "Attempt to insert NULL value into column < column-identifier > in work table (table id < table-identifier > ); column does not allow NULLS. UPDATE fails.", may be reported in the SAP ASE error log during the execution of a SELECT query that includes Table-valued User Defined Functions (TUDF), Aggregate Functions and “Hash Vector Aggregate Operators” is shown in the query plan through “set showplan on”. See KBA 3515494. |
| 829302 | SAP ASE Workload Analyzer Command Line Utility would fail to connect to an SSL enabled repository server or would fail to start a capture or replay on an SSL enabled ASE server if a keystore protected by non-default password ("changeit") is specified. |
| 829318 | A 11216 error, "Internal Ct-Lib/Cs-Lib error 33816856: 'cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.'.", may be reported when sp_dump_history is run and an entry in the dump history file is broken into multiple lines instead of a single line. See KBA 3455971. |
| 829324 | A 17260 error, "Can't run sp_dump_history from within a transaction.", may be reported when executing sp_dump_history and the option "set chained on" is enabled. See KBA 3520065. |
| 829327 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'tmp_get_tmpobj_by_name' together with a stack trace which includes the modules 's_mustrecompile' and 'seq_schema_check' may be reported in the SAP ASE error log during the compilation phase of a query. See KBA 3463010. |
| 829328 | A 622 message, "Opentable was passed a varno of 0. Object ' < object-name > ' in database ' < database-name > ' already has that session descriptor in use. This occurred while opening object id < object-id > in database id < database-id > .", may be reported in the SAP ASE error log when executing a procedure that references a SQL User Defined Function after upgrading to 16.0 from 15.7 release. See KBA 3464200. |
| 829335 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'ra__ci_destroy_stop_scanner' together with a stack trace may be reported in the SAP ASE error log while Rep Agent is being shutdown. See KBA 3468141. |
| 829336 | A 605 error, "An attempt was made to fetch logical page < > from cache < > . Page belongs to database < > , object < > , index < > , partition < > and not to database < > , object < > , index < > , partition < > . Restart of ASE will clear the error. Please contact your System Administrator for help.", with state 9, or a 696 error, "An attempt was made to fetch logical page < > from cache < > . Page belongs to database < > , object < > , index < > , partition < > and not to database < > , object < > , index < > , partition < > . Restart of ASE will clear the error. Please contact your System Administrator for help.", with state 9, may be reported in the SAP ASE error log while scanning a DOL table or during an ASE version upgrade to 16.0 SPO4 PL05 or PL06. See SAP KBA 3502182. |
| 829337 | A deadlock scenario may occur when a new site handler for a backup server is spawned and at the same time the current site handler is closing. See KBA 3470720. |
| 829342 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'get_range_sdes' together with a stack trace which includes the modules 's_mustrecompile' and 's_opentables' may be reported in the SAP ASE error log during the compilation phase of a query. See KBA 3476350. |
| 829348 | Enhance the output of deadlock information printed in the SAP ASE error log to include the isolation level when the configuration "print deadlock information" is enabled. |
| 829357 | A 834 error, "Illegal attempt to clean buffer ...", may be reported in the SAP ASE error log when running ONLINE DATABASE against a database that is currently in boot time recovery. See KBA 3467486. |
| 829421 | In rare circumstances, the CHECKPOINT process may be put to sleep when checkpointing a database, with a 3475 error, "There is no space available in SYSLOGS to log a record for which space has been reserved in database ' < database-name > ' (id < database-id > ). This process will retry at intervals of one minute.", reported in the SAP ASE error log. This may lead into an undetected deadlock situation when the user attempts to increase the database log space. See KBA 3474684. |
| 829432 | A 403 error, "Invalid operator for datatype op: BUILTIN FUNCTION type: < datatype > .", may be reported when a stored procedure that includes a MERGE command having an UPDATE action which also assigns a local variable is run and the SAP ASE configuration option "enable HugePages" is not enabled. See KBA 3471006. |
| 829476 | Audit event 39 may continue to be inserted into the sysaudits table for each trigger execution after turning off auditing for a specific login. See KBA xxx. |
| 829484 | A 3606 error, "Arithmetic overflow occurred.", may be reported by SAP ASE when sp_sysmon_spinlock is run while sp_sysmon is executed. See KBA 3479652. |
| 829512 | The message, "BACKUPSERVER: bs_trap; process received signal 11", together with a stack trace which includes the module 'bs__check_auth' may be reported in the Backup Server error log when an ODBC client issues a command to the Backup Server and the client's hostname is not included in the Backup Server's "hosts.allow" file. See KBA 3483225. |
| 829543 | setuphadr now requires user installed openssl. |
| 829583 | In some cases, SAP ASE may perform an extra OAM scan when page allocation for new data is taking place on an allocation unit where the table did not have data residing onto it previously. This may contribute to additional latch contention on the table's first OAM page as well on the target allocation page. |
| 829615 | A 820 error, "Attempt to dirty non-log buffer ...", together with a stack stack trace which includes the modules 'bufpindirty', 'xls_bufpindirty_single' and 'bufdirty' may be reported in the SAP ASE error log when sessions execute concurrent transactions in a low durability database, like system tempdb, along with a dump database operation being in progress. See KBA 3496547. |
| 829624 | Apache Commons CLI is upgraded to version 1.8.0. |
| 829629 | Apache Commons CLI and POI library in Workload Analyzer Command Line Utility is upgraded to commons-io-1.8.0 and poi-5.3.0. |
| 829703 | The default optimization level is set to "ase_current" in 16.1 SP00PL00. |
| 829738 | Support login names containing special characters like "." or "-". |
| 829757 | Sybdiag may report incorrect "Kernel Interface Table" information on SuSE 15.x or RHEL 9.x. |
| 829762 | In rare circumstances, a 3478 error, "During undo the page timestamp value is less than new timestamp from log ...", followed upon the given database reboot with the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'dol_deldrow' together with a stack trace which includes the modules 'undo_dol_insert' and 'boot__recover_and_online' may be reported in the SAP ASE error log. |
| 829830 | A 2560 error, "The parameter 'Page_Num' as invalid value/type", may be reported when running DBCC FIX_PAGE on a page that is in unsigned integer range. See KBA 3516805. |
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 PL00, 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)