2332779 - Targeted CR List for ASE 16.0 SP02 PL05

The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in Adaptive Server Enterprise (ASE) 16.0 SP02 PL05. Please be sure to read the Disclaimer below.

If the EBF/SP has been released, check the CR list and coverletter at the support.sap.com.

Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release.

CR Number	Description
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 Read more... Product SAP Adaptive Server Enterprise 16.0 Keywords KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem About this page This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required). Search for additional results Visit SAP Support Portal's SAP Notes and KBA Search. Legal Privacy | Terms of use | Legal Disclosure | Copyright | Trademark Follow