/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 future Adaptive Server Enterprise (ASE) EBF/SP or PL releases. Please be sure to read the Disclaimer below.
If the EBF/SP has been released, check the CR list and coverletter at the service.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 |
|---|---|
| 572789 | KBA 2314036. Error message 911, "Attempt to locate entry in sysdatabases for database '' by name failed - no entry found under that name. Make sure that name is entered properly." may be raised for a select into query where dbo is specified as the table owner and the table contains a user defined datatype. |
| 680410 | KBA 1945011. The execution of the system stored procedure sp_help_rep_agent with a client application which doesn't support large identifiers fails with error 103 because the identifier 'max_number_of_replication_paths' is too long. |
| 689056 | An UPDATE that modifies more than one column may cause an infected with 11 (SIGSEGV) stacktrace in the module CgpPop::CgpInplaceUpdateVars. |
| 689359 | KBA 2092097. Sig 11 occurred when running a simple query where clause having 129 value lists IN. But having 128 value lists for the same query works fine without problem. |
| 712089 | Job Scheduler: jobs may fail to run if they require 'large identifiers'. Currently Job Task clients are limited to OpenClient 12.5 capabilities. |
| 717101 | The LogicalReads, PhysicalReads, PagesRead, PhysicalWrites and PagesWritten columns in monProcessActivity and the LogicalReads, PhysicalReads and PagesModified columns in monPrcessStatement and monSysStatement are changed from 32bit to 64bit. |
| 718500 | Illegal outer-join request gives infected 11 in oj_syboj_ojdepends_maps instead of an error. |
| 720215 | A 107 error, “The column prefix ' < tabname > ' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.”, may be reported on the standby SAP ASE when SQL Statement replication is enabled, during the execution of an UPDATE command that has a SET clause on a column with a rule defined on it. |
| 742910 | A timeslice error with a stacktrace in the module 'copy_colinfo' may be seen for queries using a "*" in the select into list along with a join clause, where one of the columns in the projection is an encrypted column. |
| 747033 | There could be a deadlock between level0 scanner and alter table add/drop utility, when we have "enable utility lvl 0 scan wait" set to one, when there is L0 cursor open by the scanner. |
| 747441 | When a database is in 'dbo use only', an infected with 11 (SIG SEGV) stacktrace may be reported in the SAP ASE errorlog, with the function crp_var() mentioned in the stacktrace. |
| 749893 | Waiting behavior change on uncommitted insert. When the value of 'wait on uncommitted insert' is set to 2, the INSERT wait for the uncommitted insert as well. |
| 758554 | The message, "Current process < process address > infected with signal 11" together with a stack trace with the module 'dol__index_decompress_row' may be reported in the SAP ASE error log after REORG REBUILD has been run on some specific tables whose indexes are defined as index compressed. |
| 760112 | Under rare circumstances sybdumptran may fail because it is not be able to find the first log page when the meta data file is not the last (tran) dump, but an earlier dump. |
| 765578 | A 702 error, “Memory request for 18096 bytes exceeds the size of single page of 16384 bytes.” may be reported in the SAP ASE error log with a stack trace which includes the modules ‘memalloc’ and 'LeSendRow::genRowFormats’ on a 16K page size dataserver when selecting more than 2048 columns while the configuration option 'streamlined dynamic SQL' is enabled. |
| 767607 | A deadlock may be reported when unique non-clustered indexes are created concurrently on a replicated table. |
| 768303 | sp_sysmon raises error message 1508, "Create index aborted on duplicate rows.", when creating clustered index with field_id column. |
| 768479 | In rare circumstances when a SELECT query that use a LIKE clause is executed, an unexpected result set may be returned when one operand in the search arguments is a LOB whose length is bigger than 255 characters. |
| 771528 | The new ODBC driver was updated to use the “optimal” TDS batching feature when ODBC uses parameter sets like this: SQLSetStmtAttrW( stmt, SQL_ATTR_PARAMSET_SIZE, (SQLPOINTER)size, SQL_IS_UINTEGER ); This picks language batch and causes error 16817, "A query plan cannot be generated for DML command executed with homogeneous batch parameters. The batch was aborted.". |
| 771633 | KBA 2371593. In Windows the message "current process infected with 11" in the module 'vcwprintf_s' together with a stack trace which includes the modules 'proc_read' and 'des_fill_col_dflt_info' may be reported in the SAP ASE error log while the error 2805, "Bad pointer < > encountered while remapping stored procedure ' < > '. Must re-create or replace procedure." is raised. |
| 772567 | Add ability to edit workload repository database connection in the ASE Cockpit setting dialog. |
| 774383 | KBA 2110307. When a dynamic SQL with homogeneous batch parameters is executed and it's required to recompile, a 16817 error may occur if a config parameter "streamlined dynamic SQL" is OFF. |
| 775488 | Optimization for "filling free space info" after an unpolite shutdown of ASE. |
| 775625 | A replicated password may be truncated of the last several bytes if the new login is added by sp_addlogin or the password is changed by sp_password. |
| 775812 | In a Multiple Paths Replication environment, when a transaction is rolled back to a savepoint, Replication Server may report error 9022 ("Cannot deliver a command from < RSname > . < pathname > since no transaction is open."). |
| 776589 | Allow the use of a label option in the 'with =' construct of DUMP DATABASE and DUMP TRANSACTION commands to facilitate the re-synchronization of replicated databases in an HADR setup. |
| 777190 | An error 702 - "Memory request for < n1 > bytes exceeds the size of single page of < n2 > bytes." can be raised from a large IN list when sql statement replication is enabled. |
| 777215 | When a column datatype is LOB/varchar and there is implicit datatype conversion in a stored procedure where "LOB/varchar" is converted to "text", result fails if we renormalize the stored procedure or restore a db with the same proc. Handling of data type conversion from LOB to varchar in case of renormalization ( backup restore ) missing has been implemented. |
| 778060 | KBA 2122073. In some cases during boot time recovery the message “The server will recover databases serially." or "WARNING: The value of 'max concurrently recovered db' ( < value1 > ) exceeds the server resource limit ( < value2 > ). The server will limit the maximum number of recovery processes to < value2 > ." may be reported in the SAP ASE error log, resulting in fewer recovery internal tasks being spawned and less databases being concurrently recovered than expected. |
| 778143 | Order-by queries with 7 or more tables or that use compatibility mode may generate a 325 error (no legal query plan found). This behavior can be sporadic. Note that the 7 or more tables may consist of worktables used to materialize interim results. For example, aggregates that contain a distinct clause may require a worktable to calculate the result. These interim tables will then need to be joined back together to produce a final result. |
| 778590 | When the database option 'ddl in tran' is enabled in the context of streaming replication, the execution of a SQL batch whereby inside the same user transaction a user table is created and then its schema is changed, or alternatively the schema of an existing user table is changed more than once, will not cause a hang situation between the user task executing the batch and the ‘REP AGENT CI SCANNER’ task that is pre-loading this table schema in the Rep Agent schema cache. |
| 778761 | The message "current process infected with 11" in the module ‘buf_consolidate_lfb_find_newbuf’ together with a stack trace which includes the modules ‘bt__insert_into_leaf’ and ‘ins_insert’ may be reported in the SAP ASE error log when a DML is executed into an in-memory database on a DOL table that has an index which was created with the option ‘latch_free_index’ enabled. |
| 780617 | When statement cache is on and JDBC option LITERAL_PARAMS is false, conversions between the following stored procedure parameter and registered callable statement return parameter may stack trace. This will occur in a conversion function such as com__datetodatea(). |
| 780628 | Apf reads from some utility commands are not included in monProcessActivity.PhysicalReads or monProcessStatement.PhysicalReads. |
| 780850 | KBA 2141342 : The progress report during the execution of CREATE DATABASE may not always be accurate whereby the completion percentage reported value may not reach the value of 100%. Alternatively the same inaccuracy can be seen during the execution of ALTER DATABASE with the LOG OFF option, or during the execution of DROP DATABASE for a database which has holes. |
| 782103 | SEGV may occur in result() function when trigger executes INSERT ... SELECT statement; this disappears when the trigger is recreated. |
| 782188 | (KBA 2156958)error 225 when exec stored procedure after adding column in table of view |
| 784095 | Running out of free extents can lead to an 1122 error: "Attempt to read allocation page before openning SYSALLOCPGS." |
| 784167 | KBA 2315399. Prevent the DBA from truncating the log using DUMP TRAN WITH NO_LOG, when a database is in bypass recovery mode, to avoid causing data inconsistency. By default error 4246 will be raised instructing the end-user how to bypass this restriction by using the new option FORCE_KEY= < value > . |
| 784192 | KBA 2171618. In rare circumstances, a 706 error, "Process < value > tried to remove PROC_HDR < value > that it does not hold in Pss." together with a stack trace which includes the modules 'mem_pageallocate' and 'st_readstatistics' may be reported in the SAP ASE error log when a process is killed. |
| 784616 | KBA 2174314 : If compatibility mode is enabled and a complex query needs a sort operation (such as ORDER BY clause) and the query creates many worktables, SAP ASE may log a stack trace including a function j_joinsortavert() in the SAP ASE errorlog |
| 784620 | In rare circumstance, a 701 error, "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache.", may be reported when running CREATE INDEX/ALTER TABLE/REORG REBUILD commands on a table with thousands of data partitions. |
| 784679 | When creating a global index on a round-robin partitioned table with the sorted_data option, empty partitions were mishandled in a way that could corrupt internal data structures, causing a thread to crash. |
| 784709 | Job Scheduler in ASE cannot be restarted if the job scheduler spid gets terminated due to any exception. Only way to have it running is to bounce the server. |
| 785304 | When multi-path replication is enabled, suspending the connection of a Rep Agent sender to SRS while no replicated activity occurs on the primary database may result in a hang situation, instead of a Rep Agent re-scan. Furthermore, if activity on the primary database causes the hang to cease, Rep Agent will terminate instead of re-scanning. |
| 786724 | KBA 2201130: The values of IOTimes in the monIOQueue and monDeviceIO MDA tables do not match. |
| 787066 | In the context of streaming replication, a new configuration parameter ‘buffer pool size’ is introduced in the Rep Agent. This new option will allow auto-scaling and throttling in order to reduce the likelihood of error 9417, ”RepAgent( < dbid > ): The CI-resource 'CMD Package' is exhausted, please use 'sp_config_rep_agent' to increase the configuration value of 'buffer pool size'. Waiting for a free package may result in performance degradation.”, from being reported in the SAP ASE error log. |
| 787075 | Workload captured during replay of a workload will include all commands executed on the replay server. This includes commands executed by other applications connected to the replay server during the replay session. |
| 788691 | KBA 2209489 - ALTER OWNER does not affect defaults created with 'enable inline default sharing' turned on |
| 788721 | The command LOAD WITH LISTONLY=TRAILER returns "Label validation error: seek to trailer labels failed" when the archive file is created with the archive API. Instead, the message "Option LISTONLY [= [FULL | VOLUME | TRAILER]] is not supported on archives created using the Backup Server API." should be returned. |
| 789481 | Sporadic signal 11 (SIGSEGV) assertion (in execproc()) while executing a procedure under statement_caching ON. |
| 789501 | TCP ports in session report dashboard is not correct. |
| 789670 | KBA 2205765 - sp_dbcc_run_summaryreport cannot show an SUID greater than 99999 |
| 789866 | A new configure parameter 'allow memory grow at startup' is added to make the server automatically grow its 'max memory' if needed during boot, so the server boot will not FAIL due to insufficient 'max memory'. |
| 790069 | When the master database is extended, in generating the response file from connecting to an existing server (using the Edit Resource files menu), the calculated value of the master database size will miss the value of the extended size of the master database. |
| 790826 | KBA 2279999. Query involving many tables gets error indicating maximum of 50 tables per query although DBCC SERVERLIMITS indicates limit is 512 (15.7) or 1023 (16.0). |
| 791015 | Workload analyzer is enhanced to support sorting by more columns in different dashboards. |
| 791603 | Add a column to report the average execution time for each repeated query in the Top Frequent Running Requests screen of the Workload Dashboard. And the column is sortable for displayed requests. |
| 791652 | Long running internal 'sort_local' transaction during cursor processing may cause tempdb log full scenario. |
| 791662 | New configuration option "restore database options" to force the database options in a database dump be applied to the target database at load database or load transaction time. |
| 792268 | When creating a proxy table on SAP ASE against an SAP IQ remote table, the column name is truncated if it is more than 30 bytes long. |
| 792416 | A new ASE SQL feature is added to support ROWS LIMIT clause. The ROWS LIMIT clause for a SELECT query allows to query a specified number (limit) of rows from a specified (offset) row. It provides paging query support for SELECT statement. |
| 792540 | SAP ASE does not return a value when querying a global variable with the option nodata on. |
| 792662 | KBA 2248390. In rare circumstances on a heavily-loaded multi-engine system, a timeslice error in the module 'prepprev' together with a stack trace which includes the modules 'apl__startscan' and 'rec_undo_session' may be reported in the SAP ASE error log during the rollback of a failed bulk-insert command due to a duplicate key violation error 2601. |
| 792815 | Performance improvement of transaction rollback processing by ASE Replication Agent. |
| 793021 | Analyzing dynamic SQLs might be slow in workload analyzer feature if the workload includes huge dynamic SQLs. In some special cases, the analysis might even get hang while analyzing dynamic SQLs. |
| 793065 | KBA 2252511: Kill spid in log suspect causes Error 4720 and failure to drop temp table |
| 793217 | Transferring NULL LOB data from remote source via INSERT-SELECT may result in wrong data inserted. |
| 793418 | KBA 2256377 : Error 15497 with a message "The password for the master key of database 'database name' has not been set." may be raised when accessing encrypted columns in unattended start-up mode on HA secondary companion during failover mode. |
| 793645 | The "replay failed sessions" option in replay status is not always displayed correctly. |
| 793881 | KBA 2260479: DML to table variable inside open transaction executes automatic commit for entire transaction. |
| 793885 | If a Run-To-Completion thread hits an exception while holding a spinlock, spinlock information is not printed in SAP ASE error log and ASE continues to run although it should implicitly shutdown. |
| 793959 | KBA 2326973 : Due to isolevel change, LWPs don't store correct compile setting |
| 794112 | When connecting to repository database, if repository configuration does not meet the requirement the repository configuration requirement, a dialog will show the current configuration values and expected value. If user press "Enter", there will be unexpected exceptions and the browser will get hang. |
| 794294 | The message "current process infected with signal 11" in the module 'GenCondensedText::isInTree' followed by a stack trace that includes the modules 'GenCondensedText::getAghead' and 'GenCondensedText::generateAggregate' may be reported in the error log when running show_condensed_text() built-in function. |
| 794308 | Workload Analyzer replay comparison functionality is enabled in this CR. This provides detailed comparison for each queries, sessions in a replay and the original capture. |
| 794440 | Stack trace with signal 11 at LeSarg::mapSarg if a conflict happens when updating a primary key in self-referencing query; error 546 should be raised instead. |
| 794512 | The manifest file created by UNMOUNT DATABASE, QUIESCE DATABASE or CREATE MANIFEST FILE is closed without flushing the file system buffers. This flush is required if some low level utilities are used to clone the disk content. |
| 794882 | KBA 2269820: DBCC reports Invalid Column Length errors on syscomments in sybsystemprocs after installing or upgrading to SAP ASE releases at or above 15.7 SP133, 16.0 SP01 PL02, and 16.0 SP02. Error message number: 15946, 3 15946, 4 |
| 795008 | SSL connection attempts will fail when a cipher suite which is not supported by TLS 1.0 such as TLS_DHE_DSS_WITH_RC4_128_SHA. |
| 795206 | Timeslice stack trace problem happened during querying monThread. |
| 795576 | When the force_bloom_filter_for_ap_joins switch is enabled and a SELECT JOIN query is forced by an abstract plan while the physical operator can use a bloom filter, the bloom filter will be used. This won't override the join_bloom_filter switch setting. |
| 795627 | KBA 2277984 - monProcessSQLText contains less information after 15.7 SP111 |
| 795705 | The Replay Status area of the Replay Status screen is too small to display the full text of messages that are received during replay. With this fix, we provide a tool tip so that, when the mouse hovers over a row in the panel the full text of the message is displayed in the tool tip box. In request explorer, remove quick preview when clicking one row and instead add a tool tip so that when mouse hovers over the request text column the full text of the request text will be displayed. |
| 795883 | SAP ASE running on the IBM AIX platform may encounter signal 11 at usrcancel+0xb8() when processing a cancel request from old (pre TDS5) clients. |
| 796008 | When RAT-CI is started and ASE DTM is enabled, a warning message is printed in the SAP ASE error log as follows: "Rep Agent (%d) Warning: RAT-CI and HADR are not guaranteed to work with XA/MSDTC distributed transactions." |
| 796037 | The execution time of a query might be a negative value like -16854 day 22:46:13.895540 if it is still running when capture is stopped. |
| 796038 | The overhead rate might become 100% at the beginning of a workload capture. |
| 796257 | When the nesting of table-valued UDFs approaches the value of config param 'max nesting level', a stack trace may occur and the transaction aborted. Also, when table-valued UDFs are used in queries that contain 6 or more joins, stack traces may occur and the transaction aborted. |
| 796398 | An 804 error "Unable to find buffer ..." followed by an 834 error "Illegal attempt to clean buffer...", may be reported when loading a database dump after a previous attempt to load a database dump has failed. |
| 796409 | New feature request to allow reinitializing a device that has been deleted from the operating system without having to drop and recreate the logical name in ASE. The new feature is exercised when the DISK REINIT command is executed passing a logical name but not the physical name. |
| 796532 | KBA 2289636. When a query references a table with a name that starts with '##', SAP ASE may raise error 2812 complaining about a non-existent procedure. A 2812 error is of the form "Stored procedure ' < name > ' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output)." |
| 796550 | The monProcessProcedures can't report correct ExecutionCount for trigger procedures. |
| 796565 | KBA 2290005: The embedded HTTP server for SAP ASE Webservices allows older ciphers and protocols that are now considered weak. Allow the HTTP server for SAP ASE Webservices to use the latest ciphers and protocols. |
| 796610 | An error like "You don't have permission to capture workload from this server" or "You don't have permission to replay workload on this server" will be reported on the first page of the capture/replay wizard if the cockpit user has no permission to run capture/replay on the server. |
| 796745 | KBA 2291967. The error message "Invalid column length: < > . Value must be between < > and < > at offset < > for 'all-pages' row with minimum row length of < > ." together with a stack trace which includes the modules 'leafdatacheck' and 'collocate' may be reported in the SAP ASE error log when DBCC CHECKDB is executed on a database that has been previously decrypted. |
| 796760 | In current implementation, we use different color to distinguish whether the column is sortable. With this resolution, If a column is sortable then when the mouse hovers over the column header, the background of this column header will change. |
| 796763 | Builtin function query_text might hit stack trace at query_text. |
| 797160 | In rare circumstances the system stored procedure SP_DEPENDS may report an incorrect mapping value when a column is multiple of 8. |
| 797200 | KBA 2305866. A 3906 error, "Attempt to BEGIN TRANSACTION in database ' < dbname > ' failed because database is READ ONLY." may be reported when a DUMP DATABASE is executed on a 'read only' database and the configuration option 'enable dump history' is set to 1. |
| 797258 | KBA 2298391: If a database is loaded onto another database with different layout, requiring the data and log devices to be remapped, the target database will lose all the user defined segments. |
| 797430 | In rare circumstances, SAP ASE may hang as a result of undetected deadlocks caused by a process that is queuing a ‘lock entry’ request to itself after hitting an error. |
| 797504 | KBA 2302039 - Mutually exclusive LIKE clauses can hang connections |
| 797539 | The built-in ROW_COUNT() returns the value of zero rows for a system table mistakenly, when the database was created with the 'no_recovery' durability option. |
| 797604 | This request enables customer to set the specific table's attribute of row recompile factor which can be float. |
| 797611 | KBA2303515 The message "current process infected with 8" in the module 'fm__init_fmlist' together with a stack trace which includes the modules 'cfg_read_vrfy_dumpconfig' and 'dsinit' may be reported in the error log if more than 9 dump configurations exist with post-16.0 SP02 PL02 SAP ASE installations. Alternatively a 5859 error, "The configuration number '652' is invalid." may be reported. |
| 797634 | In rare circumstance, monProcessStatement.CpuTime will report an invalid value like 2007021037 for short running statements. |
| 797672 | In a very rare, highly concurrent scenario when encryption/decryption task is enabled, SAP ASE may hit signal 11 because of unallocated pages. |
| 797689 | The sample API program pipedev.c fails to dump or load a database. The backup server errorlog will show the messages"SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=0, system message=Pipe I/O returned 0 bytes.", followed by a set of messages "Error in srv_select() - file descriptor # is no longer active". |
| 797745 | Under rare circumstances when the number of objects cached for a database in the metadata cache is high, in the range of thousands, the house keeper process may hit a time slice error in the module 'des_checkpoint_flush_sysstats' while flushing objects statistics which will result in an implicit shutdown of SAP ASE. |
| 797750 | The shutdown procedure of the SAP ASE may hang indefinitely or result in a crash whenever the ASE is 'shutdown with nowait' under server conditions where the SAP ASE has ASE_JAVA methods in execution under the PCA/JVM JRE. This problem only occurs for SAP ASE releases that have the SAP JRE integrated. |
| 797751 | KBA 2305168 : Spurious message in preupgrade for hash partitioned table |
| 797757 | KBA 2304599 - An undetected deadlock can occur between the Housekeeper process and another process trying to flush datachange counters to sysstatistics. Dbcc stacktrace on the spid trying to flush datachange counters will be sleeping on the routine ptn__datachange_reset. |
| 797796 | A 2824 error, "Process < spid > cannot hold PROC_BUF < address > named ' < name > ’ because it holds another PROC_BUF < address > named ' < name > '. A process can only hold one view, rule, or default at a time." may be reported in the SAP ASE error log during the server startup and while the RepAgent is attempting to replace a stored procedure buffer with the same buffer in a replicated database. |
| 797940 | KBA 2309309: The error "Could not open TSM library /usr/tivoli/tsm/client/api/bin64/libApiTSM64.a(dsmapish.o)" will be raised when trying to execute the 64 bits program sybtsmpasswd on AIX. |
| 798063 | Setuphadr utility allow ASE and setuphadr have different versions. |
| 798089 | KBA 2308401 : CPU usage may continue to peek or stay at 100% after a site handler timed out on HP Itanium platforms. |
| 798091 | Enable setuphadr to create RMA service with specific account on windows. |
| 798092 | In an SAP HADR environment, when the Primary SAP ASE is in a deactivating state (i.e. undergoing deactivation) or in an inactive state (i.e. deactivation is complete) then the Job Scheduler could run into issues as the connections from the JS Agent get terminated. |
| 798133 | Under rare circumstances when SAP ASE Replication Agent attempts to put a new command into a package that is full, instead of stopping or retrying, it will continue sending data to SAP Repserver mistakenly. This will cause wrong data row information to be stored in the SQP that will eventually cause the SAP Repserver to terminate abnormally. |
| 798136 | The @srv_version value for JConnect was calculated incorrectly. |
| 798160 | Under very rare circumstances SAP ASE may hit a timeslice error while releasing a spinlock and there after could hit multiple timeslice errors eventually requiring server reboot. |
| 798192 | sp_help doesn't work in chained transaction mode |
| 798209 | SAP ASE hits a stack trace in the function ktMuxThreadGetSchedQ during shutdown. |
| 798240 | When a SQL statement contains both syntax errors and braces ('{' or '}'), the syntax error is not displayed. |
| 798271 | The errors 14545, 14547 and 14519 will be raised by MOUNT DATABASE if the unmounted database had previously been mounted on a server where the database ID was used and a new database ID was assigned, and this database was extended without previously running DBCC CHECKALLOC(dbname, fix). Additionally, two new options have been added to the MOUNT command: WITH FIXDBID, to instruct the MOUNT command to fix any possible database ID mismatch, and WITH ALLOW_DBID_MISMATCH, to prevent that MOUNT DATABASE fails if the database has different database ID values in the allocation pages. |
| 798285 | KBA 2311800. Prior to 15.7 ESD#2, statements such as "select upper(c1) from t1" (where c1 is a column containing utf8 data that includes at least one row with a bad value) would raise error 2431 with severity 10, return a NULL for the bad value, and complete processing the result set. In ESD#2 and higher, SAP ASE now raises error 1579 with severity 16 instead of 2431 with severity 10, causing the statement to be aborted. This CR is a request for an option to revert to the earlier behavior. |
| 798311 | When RepAgent is configured for stream replication, it may fail to retrieve the schema of a table while processing text/image data and terminate with error 9204 state 115: "RepAgent( < dbid > ): Could not locate schema for object with id = ( < objid > ), current marker ( < pageno > , < rowno > ))". |
| 798397 | If user database sizes are different on 2 sites, warning message will be printed instead of error. |
| 798521 | The message "current process infected with 11" in the module 'comnb_i4tovarchar’ together with a stack trace which includes the modules 'ra_ci_trace_CMD_applied_get_colvalue’ and 'd__print_replr’ may be reported in the SAP ASE error log when the DBCC print_replr command is executed. Alternatively the error may be seen in module 'com__bigdatetimetochar’ when the DBCC log command is executed. |
| 798585 | When SAP ASE uses NV cache feature, during boot server may report message like 'timeslice < > , current process infected at < > (ssd_buf_hash+ < > )' in error log |
| 798625 | Under rare circumstances the message "current process infected with 11 (SIGSEGV)" in the module 'smp_bufpredirty' together with a stack trace which includes the modules 'finishlog' and 'xact_commit' may be reported in the SAP ASE error log when a transaction is committed |
| 798645 | In rare circumstances, the message "current process infected with 11 (SIGSEGV)" in the module fgunlock() may be reported in the SAP ASE error log if an exception is raised in query. |
| 798669 | For very large databases(of size > 4TB) sp_spaceused can throw Error Msg 247: Arithmetic overflow during implicit conversion of UNSIGNED INT NULL value < > to a INT field . |
| 798691 | Error 11060 may be reported for exceeding the maximum number of recompilations (10). This can occur for procedures running as isolation level 0 transactions. |
| 798696 | When TCP port is reused by different sessions, the sessions information might include some non-existing sessions which requests are zero. During replay, these session might get a replay error. |
| 798750 | When a lightweight procedure creates a temporary object (i.e. a temp table) and the lightweight procedure is compiled/recompiled, a check of the partition information on the temporary object can provoke a stack trace. |
| 798774 | The message "current process infected with 11" in the module 'objSendString' together with a stack trace which includes the modules 'LeSendRow::_sendColsToClient' and 'exec_lava' may be reported in the SAP ASE error log when a select query is executed which retrieves a NULL Java string value. |
| 798819 | For Linux and Solaris, added means of handling a secondary failure in the spid fatal signal handler (i.e. handler for SIGSEGV, SIGBUS etc) for the SAP ASE dataserver. |
| 798822 | KBA 2388613 In the context of streaming replication the Rep Agent will not report by default the message “RepAgent( < dbid > ): Warning: number of mutex retries for mutex package info mutex exceeds 150 at ( < reason > ).”, and “RepAgent( < dbid > ): Warning: mutex package info mutex is acquired after < value > retries at ( < reason > ).”, in the ASE error log. Instead new MDA columns in the monitoring table monRepSyncTaskStatistics will capture a possible mutex contention detected. Additionally the message text for error 9417 is enhanced with “RepAgent( < dbid > ): The CI-resource 'CMD Package' is exhausted, please use 'sp_config_rep_agent' to increase the configuration value of 'buffer pool size'. Waiting for a free package may result in performance degradation.”. |
| 798866 | KBA 2319128 If parameters "abstract plan load" and "enable literal autoparam" are on, error 207 might be seen during procedure creation which uses a subquery and order by a column reference or calculation. Alternately, error 411 can be raised from a compute clause during procedure creation. |
| 798869 | KBA 2359143. In rare circumstances, the message "Current process < > infected with signal 11 (SIGSEGV)" may be reported in SAP ASE error log with function cm_grabmem_clock() show in the stack in error log while sp_poolconfig was being used in parallel to configure buffer cache pools. |
| 798895 | The system stored procedure sp_help_rep_agent should display all the streaming replication configuration parameters of each replicated database when it is called with a null value for @dbname. |
| 798907 | The message "timeslice < value > current process infected at" in the module 'charindex' together with a stack trace which includes the modules 'rvm__audit_login' and 'lobj_crtlogin' may be reported in the SAP ASE error log during the execution of sp_addlogin when a new login is created with an encrypted password. |
| 798949 | In rare circumstances, a 614 error "Adaptive Server accessed a row that has an illegal length of < value > ..." may be reported on IMDB temporary database. |
| 798961 | License heartbeat reported to crash ASE in keipanic |
| 798991 | Errors like 692/696 on worktables leads to the recursive deallocations leading to error 803. |
| 799006 | KBA2332768: Error 692 or 696 may be reported on worktables. A 692 error is of the form "Uninitialized logical page < n > was read while accessing < name > . Please contact SAP Technical Support.". A 696 error is of the form "An attempt was made to fetch logical page < n > from cache < cache > . Page belongs to < name1 > and not to < name2 > . Restart of SAP ASE will clear the error. Please contact your System Administrator for help.". |
| 799010 | KBA 2324155. A 712 error may be reported when builtin function set_appcontext is frequently used. A 712 error is of the form "There is insufficient heap memory to allocate < n > bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system." |
| 799039 | KBA2231450 When a large IN List is used in conjunction with a LIKE clause, it does not qualify for Large IN List Optimization, leading to large consumption of procedure cache memory during compilation. |
| 799057 | Command line (boot time) trace flag 16939 has been added, which when enabled, will suppress showplan information (from a set showplan on) when executing system stored procedures. |
| 799059 | KBA 2365687 - In rare circumstances, when a database is encrypted, SAP ASE may crash or a task may crash with message "timeslice < > , current process infected at < > (pausenonatomic +0x < > )" reported in SAP ASE's errorlog. The errorlog also shows message like "Spinlocks held by kpid < > " where reported kpid is that of one of the task showing time slice error with pausenonatomic |
| 799170 | For Linux and Solaris, 2 new configuration parameters 'sigstack min size' and 'sigstack csmd min size' are introduced in order to configure the minimum amount of stack needed for handling an address violation signal for the SAP ASE dataserver. A task which incurs an address violation and does not dispose of the required amount of free stack will be transformed into a zombie task. It is advised to contact SAP technical support before modifying these configuration parameters. This feature can be disabled via trace flag 2913. |
| 799231 | On a server configured with the UTF-8 charset and a non-binary sort order, the built-in functions charindex and str_replace may give wrong results space and comma characters. See KBA:2323608 |
| 799273 | When a database containing log or data holes is unmounted and mounted back, the information of the hole type that is stored in the location field the table master..sysusages is lost. |
| 799279 | Error 536 might be raised from sp_helptext on a view when the view is created by a long string. |
| 799296 | The handling of a concurrent execution between ALTER TABLE ADD PARTITION and UPDATE INDEX STATISTICS on the same table, when 'enable utility lvl 0 scan wait' is set to 1, has been enhanced to give preference to add partition over update statistics. |
| 799304 | KBA 2347547. In an SAP ASE configured for multiple temporary databases, a performance impact can be seen during a check to determine whether a user defined tempdb is an in-memory user defined tempdb. The user defined tempdb does not need to be an in-memory tempdb in order to be impacted. A lot of iterations over the sequence tree or query plan (however not common for most customers) can lead to the performance degradation. |
| 799330 | New builtin curcorinfo() to retrieve information about cursors. |
| 799333 | For ASE running in threaded kernel mode, a task (spid) may hang with kctCheckAsync() seen as the top function in the output from dbcc stacktrace( < spid > ). |
| 799359 | A 1514 error, "Sort failed because it attempted to allocate page < pgid > and found that the page was busy. Buffer < address > contains a cached ...", may be reported in the SAP ASE error log when sort transactions on very large tables or worktables are rolled back in databases that have mixed-log-and-data. |
| 799370 | When lots of procedure cache memory is consumed during a query execution, there is no way to kill the process which is grabbing memory. |
| 799417 | The creation of stored procedures that invoke table-valued UDFs may fail with one or more type resolution errors, and the spid may then hang. |
| 799437 | placeholder CR for SAP Accelerator for ASE 1.0 Revision 112.02 SP12 |
| 799454 | In an HADR environment using stream replication, the drain of the transaction logs fails to be aborted when the Rep Agent Thread fails to reconnect to Replication Server. |
| 799491 | When setting an appcontext followed by a remove appcontext, an infected with 11 (SIGSEGV) may be logged in the SAP ASE errorlog. The stacktrace will include the function actx__create_attr() near the top of the stacktrace. |
| 799568 | KBA 2329226 - reorg defrag with resume cause table corruption. Error 614 and 9991 reported in dbcc checktable. |
| 799601 | The message "process infected with signal 11" may be reported in the error log together with a stack trace which includes the modules 'ra__connect_server', 'usctconnect' and 'uctSetIssuedCnt' when several Replication Agent Threads are started simultaneously and fail to connect to Replication Server. |
| 799605 | KBA 2329834 : XP Server logs incomplete messages on Windows 64bit. |
| 799609 | In a HADR setup, non-privileged connection using SSL to standby ASE fails. |
| 799639 | FM will be started as a service on windows |
| 799690 | The message "current process infected with 11" in the module 'memmove' together with a stack trace which includes the modules 'tdsrecv__dynexec' and 'tdsrecv_params' may be reported in the SAP ASE error log if a JDBC application has the DYNAMIC_PREPARE option enabled while a dynamic INSERT command is executed that involves parameter values of VARCHAR type. |
| 799706 | The option 'enable delta tran dump' will not include in the transaction dump any log page that has been sent in a previous transaction dump. If, between two transaction dumps the logical size of the log has changed and it has to be rebuilt from the log in the dump, the resulting log will be incomplete and the target database will be corrupted. |
| 799735 | When a view containing a table-valued UDF is renormalized due to a change in an underlying table, renormalization of the T-UDF fails on columns representing arguments to the function. |
| 799747 | KBA 2387517 -- A segmentation violation followed by a stack trace that contains the module 'am__chain_extent_count' may be raised if the system table SYSGAMS or SYSDAMS is corrupted and it contains more pages than the maximum allowed for these tables. The maximum number of pages allowed for SYSGAMS is 1048 and for SYSDAMS is 2096. |
| 799751 | KBA 2340330 : The message, "Current process infected with signal 11 (SIGSEGV)", followed by a stack trace that includes the module 'sendtext' may be reported in the SAP ASE error log when a UNION ALL along with an ORDER BY is being used and if the outer table has in-row LOB columns with NULL values. |
| 799801 | KBA: 2333673 - More procedure cache is consumed after setting "auditing" to 1 in ASE16.x |
| 799835 | In a HADR environment, after running sap_teardown on the RMA, @@hadr_state returned by SAP ASE indicates 2 (INACTIVE). |
| 799907 | KBA2388707 With statement cache turned on, a long query might need long time to save the statement into statement cache. |
| 799924 | For a request TDS packet, if its ninth byte is 0xAD, it might be wrongly analyzed as a response. And the analysis result will have one more session and the session information is empty. |
| 799955 | KBA 2337117 - SAP ASE may raise error 622 when DML is performed against a table that has a trigger and a materialized view that depends on the table. The error leaves the table marked as being in use. |
| 800027 | Add following properties to ICU tools to create log device for sybmgmtdb. sqlsrv.sybmgmtdb_create_log_device: no sqlsrv.sybmgmtdb_log_device_physical_name: PUT_THE_PATH_OF_YOUR_SYBMGMTDB_DEVICE_HERE sqlsrv.sybmgmtdb_log_device_size: USE_DEFAULT sqlsrv.sybmgmtdb_log_database_size: USE_DEFAULT |
| 800147 | The message "current process infected with 11" in the module 'OptBlock::_OptInitBlobTcIdBm’ together with a stack trace which includes the modules 's_compile_stmt’ and 's_execute' may be reported in the SAP ASE error log if a SELLECT query with a FOR UPDATE clause contains an uncorrelated subquery. |
| 800162 | In "Capture Dashboard", the time precision for "Session Duration" is second. It is changed to microsecond. |
| 800167 | The command DUMP DATABASE CUMULATIVE could fail and the backup server could die if the table SYSDAMS became corrupted. |
| 800190 | When SAP ASE is upgraded from prior to 15.5 to 15.5 or later releases then stored procedure sp_helpcache displays Config Size of 'default data cache' as 0 Mb". |
| 800203 | A 1295 error, "Unconditional lock request for table or page < value > , dbid < value > was made while holding a latch." together with a stack trace which includes the modules 'altdb__upd_bcache' and 'altdb__do_shrinkdb' may be reported in the SAP ASE error log when ALTER DATABASE with the LOG OFF option is executed. |
| 800204 | KBA 2340669 - Clients may hang against Solaris X64 SAP ASE |
| 800300 | KBA 2385151 -- The message "current process infected with 11" in the module 'execproc' together with a stack trace which includes the modules 'sequencer' and 's_execute' may be reported in the SAP ASE error log when a stored procedure is executed. |
| 800349 | KBA 2347037. A memory leak of 2K bytes in the ‘Global Block Pool’ may occur when SAP ASE spawns a task to drop historical data and attribute bindings when a database, table, index, or partition is dropped. |
| 800396 | KBA 2352929. The message "current process infected with 11" in the module 'bufpindirty' together with a stack trace which includes the modules 'xls_flush_plcqueue' and 'xact_commit' may be reported in the SAP ASE error log when a transaction is committed. |
| 800405 | A spurious 691 error, "Encountered invalid logical page '0' while accessing database ' < dbname > ( < dbid > ), object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8). This is an internal system error. Please contact SAP Technical Support" may be reported when running the built-in loginfo( < dbid > , "inactive_pages") when a secondary truncation point exists in this database but there is no oldest active transaction present. |
| 800461 | SSL connection fails intermittently. |
| 800569 | LOAD TRAN WITH HEADERONLY output was beautified in the SAP ASE 16.0 SP02 version onwards but unintentionally lost seconds and milliseconds precision. |
| 800589 | KBA 2347130 - function char_length() returns incorrect result with auditing enabled |
| 800625 | A 940 error, "Dbtable in wrong state for operation: DBTABLE pointer = < value > , dbid = < value > , state = < value > , status= < value > , keep = < value > , system task keep = < value > , name = < value > " with state 11 and 52 might be seen when customized optimization goal setting is on. |
| 800721 | KBA 2348911: In case of unlogged activity happening while the dump command is running on a database, the Adaptive Server may report the message "(0 rows affected)". |
| 800733 | Dropping a database on a corrupt device can lead to timeslice errors and result in corruption of the master database. |
| 800813 | sp_helpdefrag can result in arithmetic overflow due to type mismatch. |
| 800822 | Job Scheduler may fail to start during setup with sapinst. |
| 800855 | In rare circumstances, ASE may hit error 515 for a 16K page size dataserver after explicitly adding the identity column in a table which is already populated. |
| 800873 | 2 issues were resolved (1) Error 12052 may occur for table monTableCompression and SAP ASE may hit access violation in the module 'senderror' on Windows platform. (2) SAP ASE may hit access violation in the module 'mda_populate_monSpinlockActivity' on Windows platform. |
| 800880 | KBA 2351844. The message "current process infected with 11" in the module 'pg_clean_oam_entries’ together with a stack trace which includes the modules 'reorg__ptn_fr’ and 'reorg_main’ may be reported in the SAP ASE error log when the command REORG COMPACT is executed. |
| 800942 | Job Scheduler spid while starting hit SEGV in function js__callout() when there are simultaneous job scheduler start requests. |
| 800980 | For all Unix platforms, add means of handling a secondary failure in the spid fatal signal handler (i.e. handler for SIGSEGV, SIGBUS etc) and stack overflow checking in signal handler for SAP ASE. 2 new configuration parameters 'sigstack min size' and 'sigstack csmd min size' are introduced in order to configure the minimum amount of stack needed for handling the signal. A task which gets infected with a signal and does not dispose of the required amount of free stack will be transformed into a zombie task. It is advised to contact SAP technical support before modifying these configuration parameters. Minimum stack checking can be disabled via trace flag 2913 and secondary signal handler can be turned off using Trace Flag 2912. |
| 800995 | KBA 2354552. When the DUMP TRAN command fails, the bits DMPX_TRUNCLOG and DMPX_DUMPLOG remain set in the DBTABLE field dbt_extstat, and the bit DBTX_DUMPLOGFAILED, that should be set, is not. |
| 801024 | A 12316 error, "Internal error: Attempt to garbage collect a deallocated data page < > in table < > , database < > . Aborting the transaction.", may be reported by HKGC task when accessing a deallocated page while concurrent DML activity is taking place in parallel and some commands are rolled-back. |
| 801058 | The command DBCC CHECKALLOC could report a discrepancy between the actual number of free log pages and the cached number of free log pages, after ALTER DATABASE LOG OFF fails with an error 5053 due to existing log pages in the log fragment to be shrunk. |
| 801096 | Add new property setup_bs to allow user to set installation mode |
| 801105 | Permissions on user defined system stored procedure are revoked during upgrade. |
| 801114 | When inner table of an outer join query has in-row LOB column which is not part of the transitive closure, the query should succeed without a stack trace. |
| 801147 | In rare circumstances a user process may hung on PLC Sleep with recursive calls to module 'amc_alloc_firstpages' when running DUMP TRAN WITH TRUNCATE_ONLY on a database that has the option "trunc log on chkpt" enabled. |
| 801198 | KBA 2385089 -- A 5031 error, "Database test which is currently offline has been altered from size < > logical pages ( < > physical pages) to < > logical pages ( < > physical pages).", may be reported when ALTER DATABASE is executed even though the database is actually online. The error message is harmless and should be ignored. |
| 801220 | LOAD ... WITH COPYONLY does not work for compressed archive dumps. |
| 801248 | KBA 2356869 - Invalid date and process ID in the row added to the system table syslogshold when DUMP DATABASE or DUMP TRANSACTION are executed. |
| 801260 | In an HADR environment using stream replication, when a DUMP TRANSACTION command is executed on the primary database, the corresponding command is not received by SAP ASE Replication Server until an additional commit command is run on the primary database. |
| 801355 | For a large workload, when we try to open "Request Info" dashboard immediately after "Requests Explorer" is opened, the response time might be very long. With this fix, "Request Info" dashboard can be opened very soon. |
| 801377 | The message, "Current process infected with signal 11 (SIGSEGV)" in the module 'ex_subhandle' together with a stacktrace which includes the modules 'ex_subhandle' and 'kill_proc' may be reported in the error log during SAP HANA Accelerator for SAP ASE installation. |
| 801406 | default rma tds port change to 4909 |
| 801422 | The DUMP command can fail with the message "Unable to create database information file" when the backup server tries to create a temporary file with the same name and different owner than an existing one. |
| 801424 | $SYBASE/SYBASE_ASE/bin/haisql incorrectly prints diagnostic messages while encryption/decryption. |
| 801427 | Query with join and search clause comparing varbinary column and varchar constant may return incorrect results : rows which should be qualified are not returned. Showplan option will indicate that a unique index is used to scan the table with varbinary column. |
| 801433 | KBA2392234 In rare circumstances, the message "current process infected with 11" in the module 'pchk__indcomp_row' together with a stack trace which includes the modules 'pchk_bt_page_row' and 'pchk_scan_main' may be reported in the SAP ASE error log when DBCC CHECKSTORAGE on a database having index compressed tables is executed. |
| 801442 | User can specify another host name for rma/srs if elastic IP is enabled on target host. |
| 801565 | In rare circumstances where multiple LEVEL0 scanners and online utilities are running together with the "enable utility lvl 0 scan wait" option enabled, there is a possibility that LEVEL0 scanner can get access to pages which are now belonging to another object leading to a 605 error. |
| 801618 | In rare circumstances, the message "current process infected with 11" in the module 's_compile_stmt' together with a stack trace which includes the modules 'execproc' and 's_compile' may be reported in the SAP ASE error log during a stored procedure execution following a 8211 error first reported in the system tempdb database, 'Mismatch found between the name and id descriptor hash table for table < > , objid = < > . Descriptor hashed by name = < > and hashed by id = < > .', due to an object id generated value conflict. |
| 801725 | If a session has started a cursor scan at isolation level 0, while another session is executing an 'alter table add/drop partition' command on the same table, an undetected deadlock between these two sessions may occur if in the former session another query is executed at isolation level 1 or higher. |
| 801727 | Stream replication does not support in-memory databases. Startup of RAT for stream replicationon an in-memory database will fail and write the message "Rep Agent ( < dbid > ) RAT-CI could not be started. It is not supported on in-memory databases." to the SAP ASE error log. |
| 801735 | A 631 error "The length of < value > passed to delete row routine for the row at offset < value > is incorrect on the following page of database ' < DBID > ': < PAGE > . The expected row length is < value > . The offset should be no greater than < value > ." may be reported when redo of DELETE log record on APL data compressed table with clustered index during LOAD TRAN. |
| 801824 | A 624 error, "Adaptive Server failed to retrieve a row via its RID in database < dbname > because the requested RID has a higher number than the last RID on the page.", or a 625 error, "Adaptive Server failed to retrieve a row via its RID in database < dbname > because the entry in the offset table for that RID is less than or equal to 0.", may be reported while a row is inserted into an APL table that has a clustered index and the insert causes a page split to happen. |
| 801902 | A 3606 error, 'Arithmetic overflow occurred.' may be reported when an attempt is made to configure a statement cache size that is bigger than 2G bytes using the format of 'kKmMgG' through the execution of sp_configure "statement cache size",0,"2G", instead of specifying the number of 2k pages. |
| 801912 | The message "Current process infected with 11" in the module 'mem__pageallocate_this_engine' together with a 718 error, "Memory allocation from process private memory is being performed by an incorrect process. Current Spid: ' < value > '. Owning Spid: ' < value > '. Memory: ' < value > '. This is an Adaptive Server internal error. Please contact SAP Tech Support." and a 707 error, "System error detected during attempt to free memory at address < value > . Please consult the ASE error log for more details." may be reported in the SAP ASE error log when a stored procedure involving temporary tables is executed. |
| 801921 | KBA 2366977 : The message "current process infected with signal 11" in the module 'amc_finish_command' together with a stack trace which includes the modules 's__finish_alttab’ and 'rbld__table_via_amc’ may be reported in the SAP ASE error log if a reorg rebuild command is executed on a table that has multiple triggers defined. |
| 801959 | New feature request to allow a database that is either not recovered, suspect or inconsistent due to an aborted load, to be loaded without having to drop and recreate it first. |
| 802032 | KBA 2390995 - In rare circumstances the message "Current process infected with signal 11" in the module 'plc__flush' together with a stack trace that contains the modules 'xls_startscan', 'rec_undo_session' and 'abort__all' may be reported in the SAP ASE error log when a user connection that is hanging for log space to be made available is killed. |
| 802083 | A 705 error, "There is no room for process < value > to store PROC_HDR < value > in Pss." together with a stack trace which includes the modules 'memalloc' and 'add_prochdr' may be reported in the error log due to an explicit kill < spid > or attention and the process being killed has some temporary tables. |
| 802108 | In stream replication mode, while doing a database re-synchronization, the resync marker may be discarded by Replication Server because of a low OQID, and not be sent to the DSI, causing the re-synchronization to fail. |
| 802272 | The message "current process infected with 11" in the module 'yyparse' together with a stack trace which includes the modules 'sqlpars' and 'tdsrecv_language' may be reported in the error log when using "ROWS OFFSET ?" in a prepared statement. |
| 802539 | placeholder CR for SAP Accelerator for ASE 1.0 Revision 112.03 SP12 |
| 802601 | A database or transaction dump fails to read database devices created on a device that has 4KB physical sector size. |
| 802685 | KBA 2383378 - Error 7634 ("Tables X and X have same exposed names") may be returned for queries involving two distinct invocations on Table-Valued UDFs, where the first invocation uses a correlation name identical to the name of the UDF. |
| 802750 | NFR: Allow user to specify SSL options in FM installer. |
| 802761 | In rare circumstances on a heavily-loaded multi-engine system, a timeslice error in the module 'ubfshrink' together with a stack trace which includes the modules 'ssql__rmplans' and 's_compile' may be reported in the SAP ASE error log during the execution of a dynamic statement. |
| 802771 | In rare circumstances on a heavily-loaded multi-engine system, a timeslice error in the module 'lock__draincache' together with a stack trace which includes the modules 'lock_release' and 'closetable' may be reported in the SAP ASE error log during the execution of a dynamic statement. |
| 802811 | In rare circumstances on a heavily-loaded multi-engine system, a timeslice error in the module 'kboalloc' together with a stack trace which includes the modules 'ptn__pdes_grab' and 'des__fill_common' may be reported in the SAP ASE error log during execution of the built-in row_count(). |
| 802819 | The AFA Cockpit home page will display warning message indication Cockpit 1.0 to 2.0 migration. http://host:port/sap/hana/ase/cockpit |
| 802855 | The message "current process infected with 11" in the module 'FindClassWithLoaderID' together with a stack trace which includes the modules 'pci_tpmworker_thrd' and 'pci_tpminvoker_chores' will be reported in the SAP ASE error log if a Java UDF or ADT is run and a backup server was explicitly shut down in the same session before the Java UDF or ADT execution. |
| 802871 | sp_helpserver truncates network_name if it's length is greater than 32 characters. |
| 802903 | Follow up from CR 800396 and KBA 2352929. The message "current process infected with 11" in the module 'bufpindirty' together with a stack trace which includes the modules 'xls_flush_plcqueue' and 'xact_commit' may be reported in the SAP ASE error log when a transaction is committed. |
| 802957 | setuphadr will return 0 for '-v' and '-h' arguments. |
| 803083 | In an HADR environment using LTL replication, the drain of the transaction logs fails to be aborted when the Rep Agent Thread fails to reconnect to Replication Server. |
| 803141 | The message "current process infected with 11" in the module 'systs_des_has_stats_to_flush' together with a stack trace which includes the modules 'ptn__pdes_scavenge' and 'ind_ides_init' may be reported in the SAP ASE error log when an object descriptor is instantiated in the metadata cache for the first time during the execution of a query while the configuration parameter 'number of open partitions’ is under configured. This will cause an implicit ASE shutdown because the spinlock ‘Resource- > rdesmgr_spin’ is held at that point in time. |
| 803221 | KBA 2307017. DUMP or LOAD using the compression library 'libcompress.so' may result in relocation errors in Solaris running on machines with AMD processor. |
| 803223 | ASE Express Edition running on Linux reports incorrect limits for CPU, memory and disk space in the log during startup. |
| 803288 | A 8203 error, "Expected to find the descriptor for object < value > in database < value > in DROP state." may be reported while executing 'dbcc purgesqlcache' after execution of SELECT queries which have built-in show_cached_plan_in_html in where clause. |
| 803378 | NFR: Add DR admin user to secure store for BHADR. |
| 803497 | A 7377 error, "SELECT INSERT cannot be specified with isolation level clause." may be reported when a select-insert command is executed because the OMNI layer may add to the query the clause "AT ISOLATION" mistakenly. |
| 803547 | KBA 2397851. The message "current process infected with 11" in the module ‘com__exctnume_copy’ together with a stack trace which includes the modules ‘mod_numeric’ and ‘LeRun’ may be reported in the SAP ASE error log when a query that involves modulus operations on numeric variables is re-executed. |
| 803614 | The message "current process infected with 11" in the module 'bt__delrow’ together with a stack trace which includes the modules 'buf_consolidate_lfb_delta’ and 'alt__ind_set_latch_free’ may be reported in the SAP ASE error log when ALTER INDEX is executed to disable the option 'latch_free_index’. |
| 803627 | A 1795 error, "'ALTER TABLE' failed because the dataserver was unable to allocate space for deferred table ' < name > in database ' < name > ." may be reported when ALTER TABLE is executed on a table that was created with the option 'deferred_allocation' enabled. |
| 803634 | When replicating compressed LOB columns, Replication Server DSI may fail with ASE error 7153. |
| 803651 | Every time when granular permission is enabled or auditing is enabled and any Non-Volatile cache configuration command is executed using sp_nvcacheconfig or sp_nvbindcache then the message "current process infected with signal 11" in the module "prot_pcr_get_perms" will be reported in error log. Alternatively a message like "NV cache change failed on cache: < cachename > return code: 0." could be displayed to user |
| 803681 | The performance of INSERTs statments might be slower while using Dynamic prepare for VARCHAR/TEXT type column. |
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
SAP Adaptive Server Enterprise 16.0
Keywords
CR, CR List, ASE 16.0 SP02 PL05, ASE SP02 PL05, Adaptive Server Enterprise, Fix, Patch, Error, Bug, SP02 PL05 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.