Symptom
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
KeywordsKBA , 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 pageThis 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 resultsVisit SAP Support Portal's SAP Notes and KBA Search. |