SAP Knowledge Base Article - Preview

2332779 - Targeted CR List for ASE 16.0 SP02 PL05

Symptom

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 NumberDescription
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.