2203150 - Targeted CR List for ASE 16.0 CE SP01 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2203150 - Targeted CR List for ASE 16.0 CE SP01

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
393424 KBA 2159644 - The sp_monitor connection option may encounter an arithmetic overflow exception of any of the connections with active queries on the server has been established for a long period of time.
575996 Enable SELECT INTO at LEVEL 0 by extending the already present INSERT SELECT at LEVEL 0.
609692 When dumping and loading databases containing functional indexes between specific platforms, dropping indexes on the new server can fail with a syntax error message.
643556 Cross platform transaction load is not supported, but it is allowed and it may result in Msg 695, Level 21 "An attempt was made to read logical page ' < pageid > ' for database ' < db_name > ' ... Wrong logical page '2433379939' was broughtinto cache"; Cross platform load in an archive database is also not supported but it is allowed and may result in Msg 15760 - "Invalid dump header when loading the database with ID ' < n > '.".
650268 For options, for example 'cpas per ccb', defined as CFG_MEMORY_USED but do not consume any memory at run time, sp_helpconfig will raise error when estimate the memory usage on them.
724843 Signal 11 in OmniQuickPass::targetlist()could occur for SQL statement with subquery when show_transformed_sql is on.
731023 KBA 2063257 - Relax restriction when we raise the message 3193 in relation to ALTER DATABASE OFF at LOAD TRANSACTION time, by delaying the generation of holes in a load sequence to ONLINE DATABASE time.
732131 A 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #= < > , object id = < > , page timestamp= < > . Log old timestamp= < > . Log record marker = ( < > ).", may be reported during LOAD TRANSACTION if either the built-in reserve_identity() or the dbcc set_identity_burn_max() command have been executed when the transaction dump was taken.
732503 The message "current process infected with 11 (SIGSEGV)" in the module 'des__clean' together with a stack trace which includes the modules 'des_refreshall' and 'online_database' may be reported in the SAP ASE error log when multiple sessions are executing the ONLINE DATABASE command simultaneously for the same database. This will result in SAP ASE shutting down implicitly.
733331 Error message 1509 may be raised when CREATE INDEX or UPDATE STATISTIC is executed in parallel on huge table where there are very few distinct COLUMNS values.
735498 It can take a long time to detect that there has been a KILL of a REORG REBUILD and thus to start a rollback when a huge table is involved.
743245 KBA 2067664 : ALTER TABLE places TEXT pages of a table onto incorrect system segment if ALTER TABLE adds the first TEXT/IMAGE/UNITEXT column for the table.
743958 Under some rare situation, the error, "Current process infected with signal 11 (SIGSEGV)" followed by a stack trace involving the module 'CgEvals::_CgCompVcol' may be reported if the plan has HASH join or MERGE join with numeric parameters in the join predicate.
744670 In very rare cases open cursor may give incorrect results if a concurrent online partition utility like SPLIT, MERGE commits concurrently.
745472 Incorrect output of message 3705 is displayed when executing DBCC TABLE sysdams if trace flag 3717 is on.
746163 A warning message, "WARNING: memory usage in procedure headers ( < count > ) does not match memory usage count in Pss ( < pss_memusage_count > ) for server process id (spid > ", may be seen in the SAP ASE error log when dumping a database to a non-existing directory.
750705 Query performance may be affected on queries for which optimizations are based on stale statistics where column histograms are out-of-range. A new UPDATE STATISTICS option is added to provided to collect statistics for a user-specified growing column so that a new histogram which include the out-of-range values can be generated during optimization.
750720 KBA 2176014 - Selecting a remote column with a LIKE clause may get wrong result if the remote server's collation is different from that of the local server.
752858 Replicating "datetime" data type from primary DB when primary client application apply data having different localization than RepServer, cause DSI to goes down with error #249 when Statement-Replication is activated and threshold is reach: E. 2013/12/02 08:55:31. ERROR #1028 DSI EXEC(106(1) db_srv2.ads_main) - dsiqmint.c(4358) Message from server: Message: 249, State 1, Severity 16 -- 'Syntax error during implicit conversion of VARCHAR value 'Dez 1 2013 11:00:23:020PM' to a DATETIME field.'. (here, “Dez” word (in datetime value “Dez 1 2013 11:00:23:020PM”) is the short name for December month in German) This may also impact other "date" data type.
753408 Under some rare circumstance, the value of PagesTouched queried from the monCachePool MDA table is larger than AllocatedPages .
754621 preupgrade may underestimate the needed space for databases to be upgraded to 15.7 SP100 or later.
756990 Raise the restriction limit on proxy table queries from 50 tables to 250 tables.
757323 The MDA table monRepSyncTaskStatistics that provides statistics on (near) synchronous replication, will report information erroneously when the current replication mode is asynchronous.
757495 XP server will fail to boot, to execute extended stored procedure or to shutdown if some other process is listening on the xpserver port. ASE shutdown may also hang if some other process is listening on the xpserver port.
757643 Child sort thread during index rebuild leads to assertion failure as it does not recognize concurrent partition level utility execution.
760979 On AIX platform, in rare circumstances,buffer unlatch raises 871 error OR CREATE INDEX may fail with error 1289:"Internal Error in lock manager routine: Invalid lock mode exclusive page, requested by task (family id < > , spid < > ) conflicts with existing family request mode exclusive page belonging to task (family id < > , spid < > ).
761835 KBA 2130834 - SAP ASE might hit a timeslice error in the function kbfusage when doing a query involving the monMemoryUsage table.
762262 ALTER DATABASE set durability no_recover does not show "enhanced performance" status in sp_helpdb output.
762392 In rare circumstances many processes could get locked when a 'dump database' or 'alter database' command is running.
762625 KBA 2127755 - An UPDATE statement which doesn't update any row and involves a replicated table with a LOB column may fail with an error 539 "Unexpected internal access methods error..." and state 31.
764438 There is a potential for high statement cache spinlock contention when the statement cache is full and all/most of the statements are pinned by a SPID. This may result in significant system sluggishness. Dumping the monitor counters shows that proc_ssql_not_found is relatively high while proc_ssql_procs_available is relatively low for an interval in addition to the SSQL_CACHE spinlock counters being high and possibly negative due to overflow.
764509 Modularize output from sp_help, sp_helpindex and sp_helpartition to provide terse output which is useful for tables and indexes with large number of partitions.
764953 fact table hint may lead to less optimal plan with huge table ( > = 1 billion rows).
765273 Select-into was not allowed in multi-statement transaction. This is now possible and is enabled by the new configuration option 'enable select into in tran'.
765296 Msg 422 - 'Too many nested expressions or logical operators to compile. Try splitting query or limiting ANDs and ORs.' is seen for queries on tables with high number of partitions and local indexes.
766512 sp_showplan has been extended to report optimizer timeout and optimizer timeout due to exceeding procedure cache limit.
766673 Roundrobin support index more than 255 ptn.
767002 KBA 2118380. UNION operators that contain fewer than four SELECT statements could consume a large portion and possibly all of the procedure cache if one or more of the select statements has a significant number of joins in it. This is unlikely to occur if the optgoal is allrows_oltp as fewer join pops are generated.
767019 When turn on trace flag 3601, a stacktrace with exc__callprint() will be hit.
767021 In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #= < pg > , page timestamp= < ts > . Log old timestamp= < ts2 > ." may be reported during recovery when an online utility like ONLINE REORG REBUILD / ONLINE CREATE CLUSTERED INDEX / ONLINE SPLIT PARTITION command was running at the time SAP ASE was shutdown with nowait or was abnormally stopped.
767058 KBA 2076259 - In rare circumstances, the error, "Current process infected with 11 (SIGSEGV)", followed by a stack trace involving the function 'com__exctnume_copy' may be reported in the SAP ASE error log when executing a query if a java client set "HOMOGENEOUS_BATCH" to true and the parameter is numeric type and its value is set to NULL.
767792 A new dbcc command DELETE_EXTENTS has been added to delete orphaned extents. It must be used under the guidance of SAP support only.
768319 In some cases, killing an Adaptive Server process that is executing a dump command on a big database, might take some time to terminate the Backup Server process. While the process in the SAP Adaptive Server is gone, the counterpart process in the SAP ASE Backup Server could continue running for some extra time unnecessarily.
768463 DDLGen reports an EC2 SybSQLException error when -TEC -N% is used on an SAP ASE server with a large number of databases.
768510 Database timestamp (@@dbts) jumps by a large amount unexpectedly during LOAD TRANSACTION.
768530 On a hash partitioned table, a disqualified partition predicate (i.e always FALSE predicate) can be treated as a predicate on non-partitioning columns. This causes certain partitions that could be eliminated, to be classified as valid partitions.
768535 The materialization of deferred table does not update statistics appropriately which leads to incorrect forward row count value reflected in table statistics.
768584 In SAP DBISQL if a user sets "showplan on", and the result display is in scrollable table mode and is editable, the plans for internal queries would be displayed along with the plan for the actual executed query.
768903 SAP ASE running on the Windows platform can suffer an access violation exception (0xc0000005) at location 0x0 with a corrupted stack.
769247 Sometimes concurrent DMLs will fail when using online CREATE INDEX.
769444 KBA 2081276 - An 832 error, "Unable to place buffer < buffer_id > holding logical page < page_id > in sdes for object < object_name > - there is no room in sdes aux keep pool", may be reported when 'max buffers per lava operator' is set to the maximum config value of 65535 or to a value very close to maximum value.
769607 When creating a partitioned table with a large number of partitions (greater than 3000) and a large number of local indexes (greater than 10) then a 702 error may result.
769653 Sybmigrate supports the ASE 15.7 SP130 new features: HADR and 'Resolve as owner' on Stand By server.
769727 Error 706 (Process < n > tried to remove PROC_HDR < addr > that it does not hold in Pss.) and 913 (Could not find row in sysdatabases with database id < n > .) may be reported for the following scenarios 1) Predicated Privileges are not being automatically re-normalized after being loaded from a dump. 2) When a predicated privilege fails to re-compile, the exception handling incorrectly cleans up leading to 706 errors.
769966 KBA 2115571. Index creation always running in serial mode when the first selected column contains large percentage of NULL values.
769985 A 923 error, "User not allowed in database - only the owner of this database can access it", is raised when a nested stored procedure prefixed with the database name is executed in a database configured for DBO USE ONLY.
770016 When execute some statements through JDBC such as table create statement, sometimes, it could hang.
770041 OpenSSL FIPS is not certified.
770092 A 3606 error "Arithmetic overflow occurred." may be reported during the execution of sp_helpdb on a database after loading a transaction dump into a database that has a trailing log hole.
770140 When there is an error while executing a login trigger such as "Could not execute login script for user login_name", the session setting export_options remains enabled. Any subsequent set commands executed in a stored procedure i.e. 'set rowcount N' will persist after completion.
770254 For an HADR enabled SAP ASE on the IBM AIX platform, if "sp_hadr_admin activate" command is executed, extraneous characters such as ": !" are displayed.
770415 When using hash based statistics gathering on partitioned tables, there could be statistics missing on some local partitions and hence the final global histogram is inaccurate. The inaccurate histogram could result in sub-optimal query plans. This also would result in the DATACHANGE() counters for that column on that partition not being reset, resulting in frequent update statistics maintenance on the partitioned table when depending on the DATACHANGE() function.
770449 Even if "number of open databases" is increased on ASE in a High Availability System, the additional number of open databases cannot be used.
770497 Error 2809 may be raised incorrectly, specifying the name of an object that isn't involved in the query, for some queries involving a derived table and view in another database that has the same object id as a procedure in the user's current database.
770514 KBA 2117327. A 691 error, "Encountered invalid logical page '0' while accessing database ' < dbname > ' ( < dbid > ), object 'sysgams' (14), index 'sysgams' (0), partition 'sysgams_14' (14). This is an internal system error..." together with a stack trace which includes the modules 'am_op' and 'pg_ptndeall' may be reported in the SAP ASE error log, during the execution of a DML command, when the database size has been extended such that it would have required the Global Allocation Map (GAM) to be extended. The GAM would need to be extended for every 64 G-bytes in a 2 K-bytes page size server, 128 G-bytes in a 4 K-bytes page size server, etc. Alternatively a 690 or 692 error may be reported.
770563 DDLGEN does not generate the correct webservice DDL.
770759 Creating a login by using CREATE LOGIN command within conditional statements like IF etc., with auditing enabled may lead to stack trace due to incorrect length for a memory move.
770848 DSParser failed to detect the interfaces format when the first entry's server name is not followed immediately by the query/master service definitions.
770863 The error, "Current process infected with 11 (SIGSEGV)", may be reported in the SAP ASE error log and SAP ASE may core dump if SAP ASE receives an external attention during MERGE join and internal sorting.
770896 On connection to Adaptive Server when the user password has expired, ALTER LOGIN MODIFY PASSWORD is prevented from changing the password.
770933 When running in threaded mode on the Linux, HP and Solaris platforms, or in process mode on any platform, SAP ASE may become CPU bound if a task on which network input is pending is suspended due to the shortage of some resource. The issue is avoided by temporarily disabling network input checking on a connection in the above conditions. This CR can be disabled via trace flag 7862.
771006 KBA 2126474 - A query that us using multiple DMLs may hit an infected with 11 (SIGSEGV) error with stacktrace including the function bt__getrestartpg() in the SAP ASE errorlog.
771053 SAP ASE may encounter a signal 11 (SIGSEGV) in the function usgetipaddr() on the IBM AIX platform
771090 KBA 2104659. The message "Invalid DOL data row pointer: row < value > with status 0x80e must be normal row instead of compressed row." in the module 'collocate' together with a stack trace which includes the modules 'writetext' and 's_execute' may be reported in the SAP ASE error log when a WRITETEXT command is run on a page compressed table in order to update a LOB column with a null value.
771137 Performance enhancement for "DUMP TRAN with TRUNCATE_ONLY" option when many concurrent sessions are active.
771141 KBA 2115565. A query with select into a temporary table with union having predicated privileges for tables in the from clause may produce a 225 error - "Cannot run query--referenced object (name < name > ) dropped during query optimization.".
771143 Memory allocation errors similar to "ks_falloc: Cannot allocate using ubfalloc(rnetmempool, 4096). Encryption provider initialization failed on engine 19." may be noticed in the SAP ASE errorlog file when engines are made offline and online in threaded kernel mode.
771147 Enhance the error handling and diagnostic reporting for invalid column data length errors.
771158 In rare cases, the table may be corrupted if exception occurs when executing ALTER TABLE command to change compressed table's lock schema.
771172 parallel checkpoint may hit error 8601
771176 When statement cache is enabled, occasionally a query may fail to unlink its query metrics from the sql cache's ssql_mdaqmetrics list, thus causing an infected with 11 (SIGSEGV) stacktrace to be reported in the SAP ASE errorlog with the function ssql_unlink_stmtmetrics() or metrics_GetForMDATable() on the stack.
771228 SAP ASE may report the message "Assertion (this- > tMagic == 0x4B545255) failed in file ..." when using sp_sysmon
771286 KBA 2145773 - The SAP ASE optimizer can make an unexpected selectivity estimate of 0.001 when a selectivity of 0.0 is detected and optcriteria avoid_zero_weight_histograms is enabled. The cr771286 optcriteria corrects the mis-estimate.
771344 sybdiag does not report the configuration option "prevent automatic upgrade".
771451 SAP ASE may log an infected with 11 (SIGSEGV) referencing the function kboflushcache in the SAP ASE errorlog.
771550 A session using a java function may raise error 712 "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." after a while.
771630 Reduce contention for the MONITOR_LOCK spinlock when resource monitoring is enabled.
771676 When a select from a table with predicated privileges is done after running update index statistics on the table, errors 706 - "Process < n > tried to remove PROC_HDR < addr > that it does not hold in Pss." and 913 - "Could not find row in sysdatabases with database id < n > ." may be reported.
771677 The SAP DBISQL window title fails to refresh after a "use < db_name > " statement is executed.
771719 KBA 2080922 - DDLGEN may capture incorrect stored procedure DDL when stored procedure is set to both ‘anymode’ and 'dynamic'
771770 KBA 2076762 - In rare circumstances, an undetected deadlock may occur following 1249 error, "Process became runnable before lock it was waiting for was released", is reported.
771870 When processing replicated data for a table having several BIT datatype columns, RepAgent may stacktrace in the module 'ra__substitute_vals'.
771876 KBA 2111156: Performance problem with application context builtins due to excessive permission checks.
771897 KBA 2108039. The loginfo builtin with the 'xactspanbyspid' option can sometimes result in a stacktrace being reported in the SAP ASE errorlog with a message like "ubo_object_from_slot:Pss Invalid slot id 0".
771901 An 834 error, “Illegal attempt to clean buffer…” in the module ‘cm_dbclean’ together with a stack trace which includes the modules ‘onl_online_db’ and ‘buf_online_database’ may be reported in the error log when DUMP TRANSACTION or DUMP DATABASE and ONLINE DATABASE are executed simultaneously for the same database.
771949 KBA 2115498. SAP ASE is returning a longer string/resultset for str_replace.
772000 The message "timeslice -501, current process infected" in the module 'plc__discard' together with a stack trace which includes the modules 'xact__rollbackxact' and 'finishlog' may be reported in the error log when a multi-database transaction is executed in chained mode whereby the option dml_logging=minimal is enabled and while a DML command is rolled back following an error encountered.
772045 SAP ASE Application context built-in functions may report an unexpected permissions error.
772101 KBA 2099190. There may be a signal 11 (SIGSEGV) reported in the SAP ASE errorlog when in a query a union or union all with 4 or more sides of the union exist. This is rare and would usually be accompanied by missing stats resulting in large overestimates in the optimizer, and/or an underconfigured tempdb.
772285 Audit options for newly added system defined roles hadr_admin_role_gp and replication_maint_role_gp are missing
772356 KBA 2094262. Execution of sp_downgrade may take a very long time to complete.
772405 KBA 2117914. A 9004 error, "I/O error detected on disk buffer 0x... for page request < value > , dbid < value > ." followed by a stack trace that contains the module 'crdb_init_first_au' may be reported in the SAP ASE error log when trying to execute an ALTER DATABASE FOR LOAD command for an in-memory database.
772435 KBA 2116143. If user's machine is too slow, sqlupgrade[res] and syconfig.exe/sybatch.exe may failed to upgrade SAP ASE because it can't reconnect to the SAP ASE booted in single user mode.
772456 In HADR configured ASE, unplanned failover i.e. sp_hadr_admin primary, 'force' occasionally fails if remote node is not reachable.
772481 Upon attempting "set plan for show_execio_xml to message on" command is used before the DML statement to get the execution statistics in XML output and if the stack-trace with a method printXMLNodeMetrics() occurred, most likely this bug is exposed.
772605 The error "d_log(): xls_startscan() failed - XLS error -3: Invalid condition" may be reported when executing DBCC LOG to get the log records for a particular SAP ASE process id when passing - < process ID > as the second parameter value of this command.
772668 SAP ASE in threaded kernel mode configured with synchronous IO may hang when there is an IO failure returned from the OS e.g. EIO.
772670 KBA 2104559. When turning on the "utility statistics hashing" configuration parameter (or explicitly using the with statistics hashing phrase) and using parallel CREATE INDEX command then a 697 error "An attempt was made to fetch logical page ' < page > ' for < ptninfo > _PTNINFO from cache ' < cache > '. Wrong logical page ' < page > ' was found in cache." can occur. This will not affect UPDATE STATISTICS or the serial CREATE INDEX command.
772718 The message 16758, The configuration option 'optimize dump for faster load' is currently not supported in SAP Adaptive Server Cluster Edition." will be reported and the server will fail to boot if this option is set to any value other than 0 in the configuration file, or sp_configure is run to do this, because the only valid value for this option in Shared Disk Cluster edition is 0.
772741 KBA 2084181 : ASE running on Linux shows the incorrect time for Europe/Moscow Time Zone.
772749 KBA 2090182. Under some rare conditions, execute dynamic sql sttaements could lead to the SIG 11 and stacktrace includes crp_vardec(), crp_var(), and sqt_reparse().
772903 If a dump is created with the database option 'allow page signing' enabled and loaded 'WITH LISTONLY = CREATE_SQL', the sp_dboption command is not generated by 'CREATE_SQL' for setting the option 'allow page signing'.
772979 KBA 2085367 - DDLGEN does not support WITH DBID= for CREATE DATABASE in ASE 15.7
773010 When a query causes timeout error, it incorrectly reads bytes from the TDS stream, reports an unexpected error like "Type '64' not implemented" and generates two RESPONSE messages to the client.
773070 Under some circumstances, the assertion failure, "Assertion (pwdlen < SAMAXPWDLEN+1) failed in file /remote/aptos_bld1/asecorona/SMP/porttree/svr/sql/generic/source/utils/ssladmin.c line 414", may be reported when running SAP ASE diagserver and the service key 'syb_extpasswdkey' is dropped.
773094 KBA 2094527 - DBISQL 16.0 allows results to be editable from the results window.
773116 Support mount/unmount encrypted database
773131 KBA 2139552 - In rare circumstances, a heap memory error 712, "There is insufficient heap memory to allocate %ld bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system" may be reported when executing DBCC LISTOAM on table with high OAM entry count.
773220 sp_hadr_admin dropserver did not drop related monservers on standby.
773273 KBA 2116202. When a database has enabled page signing, under rare circumstances a transaction log page may be written with invalid page linking pointers. This can manifest as 806 errors during recovery or rollback.
773477 HADR Propagate fails when done from a dropped, brought back up and then newly promoted server with error message 'Rejecting the HADR propagate command as the received generation number is less than server current generation number'
773512 A segmentation violation occurs when executing command "ALTER ENCRYPTION KEY .. WITH PASSWD login_passwd ADD ENCRYPTION .. FOR LOGIN_ASSOCIATION"
773554 The execution of loginfo( < dbid > , ‘xactspanbyspid’, < spid > ) built-in could take long time to complete while a DUMP TRANSACTION is concurrently run or when the amount of transaction log that is held up by it is very big.
773638 In large, highly concurrent environments, SAP ASE may, under specific circumstances, cease to elect large ( > 1 page) IO and instead revert to regular (1 page) IO for asynchronous pre-fetch (APF) for a cache. The specific circumstances include that a single table is very frequently accessed, that the table does not fit into its named cache, causing cache misses and that the workload is such that the plans include large IO and APF.
773768 With statement cache enabled and database loaded from dump of same ASE version where the database contains table with predicated privileges, query on the table with predicated privilege may fail with 225 error.
773800 If the internal memory becomes exhausted, the SAP ASE Job scheduler may hit an infected with 11 (SIGSEGV) in various code paths such as at the Job Scheduler boot time or when adding new jobs.
773859 In rare circumstances, a INSERT statement could appear as hang if it is executed using "INS_BY_BULK" optimization criteria, the target table has several indexes and the system does not have any available worker process.
773879 KBA 2116754. SAP ASE running in threaded kernel mode on the IBM AIX platform may hit a stack overflow error while starting the Job Scheduler and this may lead to a shutdown of SAP ASE.
773880 In rare scenarios, during a workload startup the rdbtmgr_spin spinlock might have contention.
773950 A 1295 error, "Unconditional lock request for table or page < > , dbid < > was made while holding a latch." followed by the message "current process infected with 11" in the module 'xls_sessionid' together with a stack trace which includes the modules ' chk_and_send_audit' and 'send_audit' may be reported in the error log when REORG REBUILD INDEX is executed concurrently with DUMP DATABASE.
773957 Wrong result could be inserted into the under table when updating a view with float literal if the view has a instead of trigger and literal autoparam and statement cache are enabled.
773966 KBA 2113516 - An infected with 11 (SIGSEGV) in the function in StgStatPkg::StgVarLengthColEstimates may be reported in the SAP ASE errorlog.
773978 When parallel CREATE INDEX with hash based statistics gathering is used, there is a possibility of a worker thread being placed in a sleep state and not be woken up, which will cause the session to hang.
774079 Eliminate a spinlock window while updating MASS Status during hk_bufawrite.
774082 When running parallel CREATE INDEX with hash based statistics gathering there may be a timeslice error.
774172 SAP DBISQL 16 may use a lot of memory and scrolling the result set is slow in text mode.
774198 When DOL tables are partitioned the values for concurrency_opt_threshold are lost.
774203 If the database option "enforce dump tran sequence" is enabled, do not disallow CREATE INDEX with ONLINE option to run if the index is also being created with the DEFERRED_RECOVERY option.
774211 A 3935 error, “Fatal protocol error. xact_beginupdate() API was invoked in the wrong context. The transaction is currently in 'Command-attached' state.” may be reported when a DML query is executed which includes an expression that references the reserve_identity() built-in.
774289 A 1105 error, "Can't allocate space for object ' < name > ' in database ' < db > ' because ' < segname > ' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment", may be reported when ONLINE PARALLEL CREATE INDEX is executed with a large number of consumers and the default configuration is used.
774323 A 644 error: "Index row entry for data row id ( < pageid > , < rownum > ) is missing from index page < index_pageid > of index id < indid > of table ' < tabname > ' in database ' < dbname > ' may sometimes be reported during recovery while undoing log records pertaining to an index on a Datarows Only Locked table.
774338 In rare circumstances an 11051 error, “CREATE INDEX on the object ‘ < table > ’ failed. Table is currently being used by one or more other tasks. Retry your query later.” may be reported while transaction isolation level 0 scans are active on the same table. Starting SAP ASE with trace flag 8225 will reduce the likelihood of this error.
774358 A 632 error, "Attempt to move memory with an incorrect length of -106. Maximum allowed length is 16384", may be reported when DBCC CHECKTABLE is executed on an all-pages-locked table with a compressed index.
774397 Add a new stored procedure sp_showprogress to display progress of a update statistics command. It can be extended to other commands later. Syntax: sp_showprogress < spid > [, display_option] spid is target process which is running update statistics so far. display_option: short: display the overall information about command of target process. long: display detail information. Default for display_option is short.
774411 In rare circumstances a 706 error, "Process tried to remove PROC_HDR that it does not hold in Pss", in the module onlutl_release_resources() together with a stack trace which includes the modules 'memfree' and 'rm_prochdr' may be reported in the SAP ASE error log when running CREATE INDEX or REORG REBUILD with the online option.
774416 Occasionally a error 644,"Index row entry for data row id (%u, %d) is missing from index page %u of index id %d of table ' < name > ' in database ' < n > '. Xactid is (%u,%d). Drop and re-create the index." will be reported, when online parallel create index on unpartitioned DOL table with concurrent DMLs.
774555 DDLGen with option -Cnumber will generate wrong table owner
774569 KBA 2134924 - "set showplan" commands are ignored when they are in the middle of a batch
774650 A SPID is holding a latch on a buffer and sleeping and some other SPID's are waiting on the same buffer leading to a hang.
774683 The SAP ASE server kills database connections when deadlocks occur when a language batch command is followed by an RPC call. A stacktrace with an access violation/infected with 11 (SIGSEGV) is reported in SAP ASE errorlog.
774699 Under rare circumstances during upgrade or initial installation, after SAP ASE reports that it is beginning upgrade step ID 1650 it may produce a stack trace saying that a stack overrun was detected and that the stack guardword is corrupt.
774786 A 820 error, "Attempt to dirty non-log buffer ... which is in I/O" in the module 'bufpindirty' together with a stack trace which includes the modules 'undo_bt_split' and 'rec__undo_abort_incomplete_ntas' may be reported in the error log during the undo phase of boot recovery if there are incomplete transactions that split index pages of Data Only Locked tables.
774830 With auditing enabled, the query "alter encryption key master with passwd 'abcdef123456' add encryption for automatic_startup" may hit error 632 - "Attempt to move memory with an incorrect length of < n > . Maximum allowed length is < max > "
774871 Under rare conditions, error 14622, "The dbinfo anchor in the database '% < dbname > ' is already locked by the task", could be raised when attempting to lock the database context information structure during exception handling.
774906 A 605 error, "An attempt was made to fetch logical page ' < > ' from cache ' < > '. Page belongs to database ' < > ' ...", in the module ‘bt__getchildlatched’ together with a stack trace which includes the modules ‘rec_undo_session_apf’ and ‘xact__rollback_local’ may be reported in the error log while a session is rolling back a transaction containing a CREATE INDEX that is followed by DMLs in a database with the option 'ddl in tran' enabled.
775030 KBA 2117888. Sometimes, if temp tables change in between two batch insert calls via jdbc, then we might have a situation where we point to memory that has been freed, leading to either of following errors : 705, 706, 707, 715 or Error 719 or similar error related to memory free, having stacktrace of batch_loopend - > s_copytmps - > memfree.
775034 A 691 error, "Encountered invalid logical page '0' while accessing database < dbname > , object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8)." may sometimes be reported while running the loginfo() built-in with "stp_pages" option.
775036 When an online utility rolls back, a concurrent update on the same table could hit the error 12319 "Fatal internal error encountered during deferred dml on table < > in database < > . All rows that qualified during the first phase were not visited during second phase of dml."
775123 Performance enhancement provided for estimating the size of the log to be processed by Replication Agent.
775297 When the Job Scheduler initialization fails or terminates, the subsequent Job scheduler boot may fail with an error "Attempt to insert duplicate key row in object ' < js_table_name > ' with unique index ' < js_row_index > '"
775355 A 1108 error, "Cannot deallocate extent < extentid > , database < dbid > . Object id < objid > , index id < indid > , status 1 in extent does not match object id < objid2 > , index id < indid2 > , status 0 in object being deallocated. Run DBCC CHECKALLOC." may be reported in the module 'pg__dropbuf' together with a stack trace in the error log which includes the modules 'xact_rollback' and 'undo_apl_aextent', when an index page split occurs during the logical synchronization phase of ONLINE CREATE INDEX for a Data Only Locked table and the command is rolled back in the end.
775422 During rollback of online create index, level0 scanners might not be able to use the DES.
775446 KBA 2105799. The SAP ASE server might not boot with the error "defined cache configuration consumes more memory than is available for buffer caches".
775501 SAP ASE could hit error 705 ("There is no room for process xxx to store PROC_HDR 0xxxx in Pss") when a lot of recompilations happen due to schema count changes.
775559 A 102 error, Incorrect syntax near '~'. One or more indexes are corrupt. They will be rebuilt ...", may be reported during ONLINE DATABASE if the database contains an index whose name is a quoted_identifier and the index was created with defer_recovery = NONE option and while the recovery of this index has been deferred by LOAD TRANSACTION.
775561 A 'hang' situation due to an infinite loop may be encountered by a LOAD TRANSACTION command if the transaction log being loaded has more than 631 CREATE INDEX transactions with DEFER_RECOVERY option set.
775572 The 12334 error, "Attempts to read logical page `%ld`, virtpage `%ld` from virtual device `%d` for %S_PTNINFO failed due to read failure in prefetch. Please contact Sybase Technical Support", may be observed during prefetch while running selects on the tables APL table table with clustered or local index and on DOL tables with local index.
775598 In rare circumstances the message "current process infected with 11" in the module 'xls_last_notflushed_plcblk' together with a stack trace which includes the modules 'crdb_main' and 'xls_reconfig_plcblk' may be reported in the error log during CREATE DATABASE.
775599 In rare circumstances, a 1295 error, "Unconditional lock request for table or page < page number > , dbid < dbid > was made while holding a latch.", may be reported by the system housekeeper chores task.
775622 KBA 2153952 - When upper case letters are used in a login name, sp_passwordpolicy 'expire login passwords' on that login name fails to find the login.
775633 Logical I/Os metrics may be incorrect for MDA tables for sensitive, insenstive cursors
775654 In rare circumstances, the message "current process infected with 11 (SIGSEGV)" in the module 's_setreturns' or 'LeEmitNoSndOp::_LeOpNext' together with a stack trace maybe be reported in the SAP ASE error log when the Job Scheduler is started using the stored procedure SP_SJOBCONTROL and a 1204 error, "ASE has run out of LOCKS. Re-run your command ..." is triggered.
775710 When using SET STATISTICS PLAN_HTML, TIMING_HTML ON for queries on tables with a high number of partitions and they were run in parallel mode then the "CPU" and "Threads" diagram sections in the HTML show plan output could show inaccurate information.
775721 The assertion failure: "Assertion (xdes- > xcomplogbytesleft_diag > = 0) failed in file /calm/svr/sql/generic/source/access/do.c line < line_num > " may be seen with a diagserver during the ROLLBACK of a CREATE INDEX with ONLINE command.
775729 An optcriteria "force_top_plljoin" has been added to force parallel hash joins for star join fact table hinted strategies if possible. Of course, this is only applicable when parallelism is enabled.
775735 A 605 error, "An attempt was made to fetch logical page ' < pgid > ' from cache ' < cachename > '. Page belongs to < obj_name1 > and not to < obj_name2 > ", may be sometimes reported when a transaction containing multiple CREATE and DROP INDEX commands is rolled back in a database that has the 'ddl in tran' option enabled.
775787 In a synchronous replication environment, a committed transaction may be mistakenly aborted internally by SAP ASE if the message "uppause: No free alarms available” is reported in error log, resulting in data missing on the primary site while it was correctly replicated on the standby site.
775820 A 2628 error, "In database < > , page < > is linked forward to page < > , but that page is linked backward to page < > . Please report this internal error to Sybase Technical Support.", followed by a 644 error, "Index row entry for data row id < > is missing from index page < > of index id < > of table < > in database < > . Xactid is < > . Drop and re-create the index." may be reported when a DROP INDEX command is run concurrently with ONLINE CREATE INDEX command.
775875 KBA 2107400 - Parallel queries may close their child threads before the child is completely drained. This can happen when non-correlated subqueries are flattened internally into existence joins. Unfortunately, the child thread will continue to drain it's plan fragment even when the pipe it is writing to is closed, leading to bad performance.
775888 If SDC instances are running with different versions of ASE server then the data exchange between the nodes may fail.
775943 In rare circumstances, an aborted ONLINE CREATE INDEX or ONLINE REORG REBUILD may cause a subsequent UPDATE or DELETE command to hit a 644 error, "Index row entry for data row id < > is missing from index page < > of index id < > of table < > in database < > . Xactid is < > . Drop and re-create the index.".
775947 New built in functions hadr_state(), hadr_mode() and sp_hadr_admin stored procedure options "state", "mode" that provide descriptive output for globals @@hadr_mode, @@hadr_state are now provided.
776075 In rare circumstances the signal 11 may occur when executing query in parallel in ASE 16.0 GA PL05. This could occur if the final plan has HASH JOIN BUILD operators where their parent Replicated EXCHANGE operator as no parent EXCHANGE operator to initiate parallel processing.
776090 KBA 2114230. In rare circumstances, the message "timeslice, current process infected" in the module 'qualpage' together with a stack trace which includes the modules 'dol_def_update' and 'xls_getnext' may be reported in the SAP ASE error log when an UPDATE statement is run in deferred mode. At boot recovery or load transaction time a 3301 error, "Invalid log record found in syslogs (logop < value > )", may be reported. Alternatively during data consistency checks a 7928 error, "Index < name > is not consistent; found < n-1 > leaf rows but < n > data rows. Drop and recreate the index." may be reported.
776152 KBA 2105598. The message "current process infected with 11 (SIGSEGV)" in the module ‘dbts_ptscmp’ together with a stack trace which includes the modules ‘th_lct_admin’ and ‘num_logpages’ may be reported in the SAP ASE error log when the lct_admin() built-in is used to get total number of log pages for databases with mixed log and data segments.
776176 A 1142 error, "Invalid OAM Page < oampgid > . Found pstat= < page_status > , object= < objid > , database= < dbid > , indid= < indid > .", may be reported when CREATE INDEX and DROP INDEX commands are executed in a user transaction and while the database option 'ddl in tran' is enabled.
776222 KBA 2111076. A 644 error, "Index row entry for data row id ( < page# > , < row# > ) is missing from index page < page# > of index id < value > of table ' < name > ' in database 'name'. Xactid is ( < page# > , < row# > ) ). Drop and re-create the index.", may be reported on little-endian platforms when a clustered index on a Data Only Locked table permits duplicate keys and the index refers to pages of which the hex value of lowest two bytes is 0xffff.
776266 In rare cases, a 1503 error, "Sort Internal Error: The Root page of right/left sub-index tree is missing." may be reported if LAVA parallel index creation is ongoing and one of the child thread is killed by SQL command: "KILL < spid > ".
776287 The message “ERROR: Can't get a new log page in db < > . num_left= < > num_in_plc= < > .” may be reported few times in the error log followed by a 3475 error, “There is no space available in SYSLOGS to log a record for which space has been reserved in database ' < > ' (id < > ). This process will retry at intervals of one minute.”, when the count of the log records in the Private Log Cache went negative due to an internal error.
776348 After installing HADR or Warm Standby Replication, materialization may fail or permission errors may occur on the standby server for privileged logins.
776409 KBA 2117329. In rare circumstances a task may not be able to abort its current active transactions and hang when sp_hadr_admin deactivate was issued by another task. The task will appear to hang in the module 'stack_abort' followed by the modules 'getpage_with_validation' and 'hadr_endxacts'.
776418 Error 442, Maximum number of user tables under all sides of a UNION statement can not exceed 512. Please simplify the query and retry. The number of allowed open tables has been increased from 512 to 2048. This should help with union queries which have many sides of a union, and the number of total tables in the from list or inside views exceed 512. This should also help avoid sort nodes with hyper partitioned tables with a local index in which an ORDER BY is performed on the index key.
776433 The SAP ASE Agent Plugin shows incorrect version string
776454 When the procedure sp_dump_history is called with the 'list' option and the dump history file doesn't exist, it will be mistakenly created as an empty file.
776470 When upgrading ASE from versions prior to 16.0 SP0 PL5, if configuration option "enable functionality group" is set to 1 then it can happen that not all members of functionality group are enabled by default.
776539 The fact_table hint is disregarded for snowflake queries when one of the dimension tables is larger than the hinted central fact table. This limitation is eliminated when the relax_fact_table_hint optcriteria is enabled.
776546 A 12308 error "Internal error : Invalid row id (Row < > , Page < > ) encountered in the table < > in database < > ." may be reported by level 0 scans / dirty reads or a 1514 error "Sort failed because it attempted to allocate page < > and found that the page was busy..." may be reported during create index, on a table on which 'reorg rebuild with online' has been run.
776549 KBA 2115587. The message "Assertion(!"xfep- > xfe_up_skip_in_clr_ctr < 0") failed' in the module 'rec_undo_log' together with a stack trace which includes the modules 'online_database' and 'rec_onlinetime' may be reported in the SAP ASE error log if the diagserver binary is used, duting ONLINE DATABASE recovery after loading a database dump that contained CREATE INDEX rolled back operations and the database had the option "ddl in tran" enabled.
776552 After upgrade from SAP ASE 15.7 ESD#4.2 or older releases to SAP ASE 15.7 SP63, SP130, ASE16.0 the decryption of LDAPUA access account passwords or SSL private key passwords stored in sysattributes which use 3DES encryption algorithm fails with message in errorlog: "... SSL or Crypto Error Message: 'An unexpected failure occurred while performing an OpenSSL cryptography operation. Root error: error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt.'."
776653 An invalid record with dump type 6 will be added to the dump history file when the option 'dump history' is enabled and a DUMP TRANSACTION WITH STANDBY_ACCESS is executed.
776683 If a segmentation violation error is encountered by the Rep Agent process while the option 'stream replication' is enabled, Adaptive Server may shut down itself.
776684 Error message 692 may be raised when table OAM scan is used in a long transaction if database option "ddl in tran" is enabled and a clustered index is created before the table OAM scan under the same long transaction. The message says "Uninitialized logical page ' < page_id > ' was read while accessing database ' < database_name > ' ( < db_id > ), object ' < table_name > '( < object_id > ), index ' < index_name > ' ( < index_id > ), partition ' < partition_name > ' ( < partition_id > ). Please contact SAP Technical Support."
776692 KBA 2112862 - suser_name() may display incorrect user name after a cross database execute as owner stored procedure is executed from a parent stored procedure.
776748 KBA 2127763 - In rare circumstances, Adaptive Server may hang as a result of an undetected self-deadlock for a process that is doing DUMP DATABASE if the database option ‘allow incremental dumps’ is enabled.
776796 When Granular Permissions is enabled, a user with CHANGE PASSWORD privilege but not MANAGE ANY LOGIN privilege fails to change another user's password with the following error: Msg 10331, Level 14, State 2: Line 1: Permission denied, database master, owner dbo. You need the following permission(s) to run this command: MANAGE ANY LOGIN.
776827 KBA 2141530 - In a HADR configured ASE, msg 3957 - “New transaction cannot be started due to an ongoing HADR deactivate operation. The command could not be completed” is raised even after completing deactivation, i.e. server is in inactive state. The message text in this case is incorrect.
776836 New column 'execution_time' is added into system table SYSPROCESSES. Execution time (including compilation time) is the time that the process has been running and the precision is milliseconds.
776942 In GUI mode, sybmigrate cannot connect to the dataserver. An error message like "Fail to connect to 'servername'. Please check if server is running and serve name is correct" will be reported.
776950 KBA 2114465 - When auditing is enabled and audit options turned on, inserting an empty string value as a variable into a table that does not allow NULLs will incorrectly fail with Msg 515, "Attempt to insert NULL value into column ...; column does not allow nulls"
776952 ASE does not print transaction info to the error log when HADR deactivation (sp_hadr_admin 'deactivate') fails due to active transactions.
776962 Under some rare circumstance, the error, "Current process infected with signal 11 (SIGSEGV)", may be reported during concurrent queries on the monProcessProcedures MDA table. It is possible that no stacktrace is printed.
776981 User with sso_role can not create database encryption key when granular permission is enabled.
777033 New permissions granted to system defined roles post 157esd#2 are not reflected in the upgraded server.
777090 Under some circumstances, after sp_reptostandby has been run to set up replication in a database containing text/image columns, SAP ASE may report an error 691 in that database: "Encountered invalid logical page {ID} while accessing {partition}."
777104 auditinit failed load messages during startup on ibmaix, solaris and hpia.
777119 An infected with 11 (SIGSEGV), stack trace, and server panic from a call to kbfalloc may occur when SAP ASE is under a heavy load of login connections and network password encryption is used by the connections.
777205 In rare circumstances, a timeslice error may occur while executing a query using the monCachedStatement table and while the SPID is holding the statement cache spinlock. When this occurs SAP ASE will shut down unexpectedly.
777210 A 631 error, "The length of < > passed to delete row routine for the row at offset < > is incorrect on the following page of database ' < > ' ... The offset should be no greater than < > .", in the module 'rec_undo_session' together with a stack trace which includes the modules 'LeBulkOpOpen' and 'xact_rollback' may be reported in the error log when a table is encrypted and eligible for incremental transfer and BCP utility is used to load data into it.
777239 The message "current process infected with signal 11" in the module 'com__exctnume_divby10' together with a stack trace which includes the modules 'comnb_numtovarchar' and 'prDTYPE_TO_DTYPE' may be reported in the error log when the Rep Agent trace flag 9229 and the option 'stream replication' are enabled.
777296 A 940 error, "Dbtable in wrong state for operation: < name > ", is reported against tempdb when repeating a query which uses work table for more than 32k times.
777308 The message "INTERNAL ERROR #74051 CAP Parser ..." may be reported in the SAP SRS error log while data for a table that has default not-null non-materialized columns is replicated from SAP ASE and the streaming replication is enabled. This error will cause the replication stream with SAP ASE to be stopped.
777382 CREATE ONLINE INDEX WITH HASH STATS was not working as documented.
777431 In rare circumstances, a 2540 error, "Table Corrupt: Page is allocated but not linked. Run DBCC TABLEALLOC to correct the problem. (allocation page#= < > , extent id= < > , logical page#= < > , object id in extent= < > , object name= < > , index id in extent= < > )", may be reported during DBCC CHECKALLOC after ONLINE CREATE INDEX is run with concurrent DMLs.
777475 In rare circumstances, a 644 error (Index row entry for data row id ( < page > , < row > ) is missing from index page < page > of index id of table 'sysstatistics' in database ' < db > ') may be reported during the load of an SAP ASE 12.5 database into an SAP ASE 15.7 dataserver.
777553 Undetected deadlock involving dbcc checkalloc(sybsecurity) and audit process
777566 An additional shared memory segment is created when the local cache partitions for the default data cache is set to "default" and the number of online engines is greater than 2, resulting in auto-tuning recommending additional cachelets. It is also possible that this may cause the server to fail to boot.
777610 After abnormal shutdown of job scheduler due to issues like inconsistency in Job Scheduler work tables, failing to execute jobs, js stop functioning due to resource issue or disconnecting with jsagent, the job scheduler does not restart automatically after "max js restart attempts".
777693 KBA 2131993 - Under a rare situation, an infected with 11 (SIGSEGV) stacktrace in the function s_readproc() with s_recompile() and tdsrecv__dynexec_xoltp() may be reported in the SAP ASE errorlog.
777720 When an ASE installation that was originally created by version 15.0.3 is upgraded to version 15.7, the newer version ASE may print a message in the error log that the installation is configured to require upgrade permission, and then shut down. If this occurs, booting the new version will continue to fail unless the option "--upgrade-ok" is given on the ASE command line so that upgrade may occur.
777749 Error 15095, "An invalid 'data row id' value (PAGE #, ROW #) was found in first text page of a text/image/unitext column. This information is on page < PAGE # > , partition ID < PTN ID > , and belongs to the object with ID < OBJ ID > . Text/image/unitext replication on this column may not work.", may be reported on replicated tables when running DBCC CHECKDB or DBCC CHECKTABLE following sp_reptostandby or sp_setreptable without using 'use_index' option.
777802 When a database with the option 'allow incremental dumps' is loaded onto a database with this option disabled, the option remains mistakenly enabled after the load completes. For this option, the setting of the target database should prevail.
777813 Stacktrace on diagserver when online parallel create index with non-empty DOL table which first partition is empty.
777822 An exception (e.g. infected with 11, SIGSEGV) in the ctlib async thread brings down the SAP ASE server.
777861 Attempt to read past EOM reported by client when doing batch insert with triggers on the target table and a row error occurs.
777895 KBA 2154406 - A 6103 error, "Unable to do cleanup for the killed process; received Msg < message_num > " followed by the error, "Current process infected with signal 11 (SIGSEGV)", may be reported in the SAP ASE error log, when executing sort on a worktable.
777932 srvbuild[res] failed to optimize server with error "Error fetching results for query: 'sp_configure 'number of engines at startup'"
777994 In ASE HADR cluster, if ASE is already in Primary state and 'sp_hadr_admin primary' command is issued, incorrect message "standby command is not allowed in current server state" is reported.
778001 ddlgen does not generate 'allow page signing' database option in the output.
778011 When a config parameter is successfully changed, but the value provided by the user is readjusted by ASE, the server message 5853 used to be sent as an error messageto the application. This change modifies the behavior to send message 5853 as an informational message. For example, henceforth the following will be sent as an informational message: additional network memory' has been modified from '31232' to '30720' by the verification routine.
778140 When Job scheduler stored procedure "sp_sjobcontrol" is executing with option "stop_js_wait", the options "stop_js" or "terminate" the running job cannot be issued.
778145 KBA2203739: A new resource governor limit, lock_count, is provided to allow limiting the number of locks held at once by a process.
778190 When a database is put in bypass recovery mode, and if during the recovery of this database an error is encountered, the subsequent databases will not be recovered although they should, resulting in either a 962 error, "Database with ID ' < > ' is not available. Please try again later.", or a 921 error, "Database 'd < > ' has not been recovered yet - please wait and try again.", being reported respectively for temporary and user databases.
778217 KBA 2123202 : A 2601 error, "Attempt to insert duplicate key row in object 'sysusers' with unique index 'ncsysusers1'", may be reported when some legacy user databases fail to upgrade to SP130 (or SP131) at upgrade step 245.
778227 set proxy inside a regular stored procedure clears the session user's roles after execution of the procedure.
778304 KBA 2133657 - The error, "Current process (0x1c3300de) infected with signal 11 (SIGSEGV)", followed by a stack trace involving the module 'ubo_slotscan_getnext' may be reported in the error log when sp_sysmon is executed or the monTask MDA table is queried with KTID or ThreadPoolID specified.
778359 KBA 2140761 - A 2601 error, "Attempt to insert duplicate key row in object ' < objname > ' with unique index ' < indname > '", may be erroneously hit while updating a Data Only Lock table that is partitioned with a unique index. Additionally a 9275 error, "RepAgent(#): Could not locate the before image for the INSERT log record at ( < pageid, row_num > ).", may be reported if the table is replicated.
778439 An exhausted fragment pool can lead to timeslice errors being reported in the SAP ASE errorlog.
778448 KBA 2129014. The task doing REORG DEFRAG might hang indefinitely with dbcc stacktrace(spid) showing at the top of the stack, functions like util_logpgimage(), rdfrag__copy_row(). A subsequent kill of reorg defrag might result in the error 1265 at severity 20 and state 5 "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr= < > , lrmagic= < > )."
778536 A 1205 error, "Your server command (family id #%d, process id #%d) encountered a deadlock situation. Please re-run your command", may be reported in Cluster Edition for some concurrent DMLs even in one node.
778553 KBA 2154849 - ASE server goes down periodically on windows platform when the monState table is queried multiple times.
778585 A 2540 error, "Table Corrupt: Page is allocated but not linked" may be reported when running DBCC CHECKALLOC on a SDC server.
778617 If a database/cube schema and query combination provide an option for a "pure" star join strategy and the query contains a fact table hint, then the optimizer may generate the "pure" star join strategy without evaluating any other strategies in the search space. The "pure" star join strategy can be very expensive in some cases. The original intent of the "fact table" hint feature was to allow a search space traversal to occur when a "pure" star join strategy was found.
778697 KBA 2126188 - ASE : Spurious sysdams message when loading pre 15.7 SP100 dump into SP13X
778706 If the user that starts backup server has allocated a shared memory segment with ID 0, the backup server will mistakenly delete it after the execution of a DUMP command.
778707 In rare circumstances the partial rollback of a transaction (command rollback) may take a lot longer than the transaction itself, or more sections of the transaction can be rolled back than those affected by the partial rollback.
778882 After executing the procedure sp_dumpoptimize to set the backup server allocation threshold level, every DUMP command execution should resend the defined values to the backup server. Instead, the DUMP command is only sending a command to the backup server to retrieve and display the current setting.
778889 The Rep Agent is now capable to shut down itself after one of its threads has hit a segmentation violation error while the option 'stream replication' is enabled.
778959 The message "current process infected with 11" in the module 'plc__flush' together with a stack trace may be reported in the error log when running DISK INIT with a duplicate logical name on a SDC server.
779109 ASE server runs into I/O error during failover in HA environment if it contains encrypted databases.
779163 A re-run of reorg defrag on a table results in the error 8233 "REORG operation is in progress on the object < > in database < > . Retry your query later.", after a prior run reorg defrag command got aborted by an internal error or an explicit kill and while aborting, hit an exception thereby, effecting an incomplete clean up of the resources acquired.
779225 Encrypted database can not be unmounted on HPIA64, AIX64 and Sparc64 platforms.
779262 Page allocation could get expensive when a table grows so large that it requires several hundred OAM pages.
779387 KBA 2184272 - Error messages 15960, 806 and 15996 may be reported when encrypting and then decrypting a database.
779398 A 9242 error, "RepAgent( < dbid > ): Underflow or overflow of state stack occurred.", may be reported when the option 'stream replication' is enabled while the Rep Agent process tries to open a stream towards Replication Server. This error will prevent the Rep Agent from being stopped and will require an Adaptive Server reboot to correct the issue.
779495 KBA 2153917 : 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. may sometimes be encountered while rolling back a transaction containing an open cursor on an ALLPAGES LOCKED table with a clustered index and one or more nonclustered indexes, if DMLs within that transaction caused a page split of the data page on which the cursor was positioned.
779599 When a a bunch of selects from tables with predicated privileges are done in a batch after running alter table and update index statistics on the table, errors 706 - "Process < n > tried to remove PROC_HDR < addr > that it does not hold in Pss." and 941 - "Illegal database context operation." may be reported.
779616 The stored procedure, sp_modifythreshold, can create a duplicate threshold entry if two identical thresholds exist on two different segments, and one of them is changed to monitor the other segment.
779750 KBA 2040888 - Error 12034 occurs due to global fragment pool too small when read MDA tables such as monCachedObjects, monStatementCache
779792 The command REORG DEFRAG ... WITH TIME=hh:mm doesn't take into account the time spent on waiting for synchronization with isolation level 0, read uncommitted, scanners while checking for the duration this command can continue to be active.
779794 KBA2135388. The informational message "The specified partitions, or all the partitions, of table ' < > ' are already marked as fully defragmented. Retry your command without the ' < > ' option to restart the defragmentation." may be reported during the execution of REORG DEFRAG with the option 'resume' enabled when it finds that the partition/table is marked fully defragmented. The expected behavior is to have the SAP ASE resume the defragmentation from the start of the object instead of prompting a re-issue of the command.
779845 In rare circumstances the Rep Agent process may not replicate some data mistakenly, when the option 'stream replication' is enabled and while it re-connects to the Replication Server following a retrievable error.
779858 If the command sp_dumpoptimize is executed to change the allocation_threshold using either a suffix of this keyword or via 'archive=min|max|default', the value will be set in the Backup Server but it will be overwritten at dump time with a default value of 40% or with any previous value that has been configured using the full allocation_threshold keyword.
779877 In rare circumstances the performance of the undo recovery pass during boot recovery may be sub-optimal when open long running transactions need to be rolled back, and SAP ASE had been terminated with an impolite shutdown command or had crashed.
779891 DDLGEN may report a “Critical internal application error” if there is a Cross Database Foreign Key and there is a bad dbid in sysreferences.
779974 In rare circumstances, when REORG REBUILD ... WITH ONLINE is aborted due to an internal error or a forced kill, while the database options ‘full logging for all', 'full logging for reorg rebuild', and ‘enforce dump tran sequence' are enabled, errors like 605 "An attempt was made to fetch logical page '' from cache ''. Page belongs to < > and not to < > .", 697 "An attempt was made to fetch logical page '' for < > from cache ''. Wrong logical page '' was found in cache.", 12546 "During undo the timestamp to be assigned to a page is less than the current page timestamp. Page = '', object id = < > , page timestamp = (x y), new page timestamp = (p q), or 806 "Could not find virtual page for logical page '' in database < > ' may be reported in the SAP ASE error log.
779980 When the supplied fact_table optimizer hint is found to be invalid, the optimizer skips compatibility mode AP application, and hence the alternative greedy algorithm is not used to prime the search engine.
780039 KBA 2135472 : REORG REBUILD on deferred tables fails with 691 error.
780041 The stored procedure "sp_crtbwoptgoal" has been added to create the user-defined optgoal "sap_olap". This optgoal setting has proven to be particularly useful in various SAP (parallel) BW installations. The procedure is run at the finish of installmaster so that the "sap_olap" will be automatically defined for all installations.
780097 When the fact table hint abstract plan directive "(USE FACT_TABLE < table name > )" is used with queries involving UNION clauses from a derived table (or view) the table could not be considered as the central fact table in a star or snowflake query and therefore the hint is ignored.
780207 KBA 2136531 - A segmentation violation error may be hit by the SAP ASE backup server process during the execution of a DUMP or LOAD database command causing it to shut down, if the machine has configured a network interface with no addresses. In the backup server errorlog a stack trace with the modules 'ng_islocalif', 'ng__cmpifaddr' and 'get_in_addr' may be reported.
780228 When the stored procedure sp_hadr_admin 'config_bs' receives a NULL second parameter it inserts one entry for the backup server listener IP address in the hosts.allow file. This a new feature to insert one line for each of the host names aliases for the listener IP address instead of the IP address.
780308 When a complex query is submitted using the "enabled deferred parallel" mode, ASE will choose a more conservative serial plan over a parallel plan without the "deferred parallel" mode. This can result in significant loss in performance.
780390 When shared memory is not available from the operating system during server startup and a memory allocation fails during initialization of RSA module, then a segmentation violation may occur in uppopaffinity().
780424 During periods of heavy I/O stress, creating page signatures can result in incorrect page linkage with 2628 error, "In database < db_name > , page < page_id1 > is linked forward to page < page_id2 > , but that page is linked backward to page < page_id3 > . Please report this internal error to Sybase Technical Support" reported in the error log.
780453 In some cases the columns NumStreamSwSynctoAsync and NumStreamSwAsynctoSync in master..monRepCoordinator are not reflecting the correct number of mode switches, while the option 'stream replication' is enabled.
780508 Queries that have more than 32 "ordering columns" may return results in the wrong order when run using server-side cursors. The problem is specific to server-side cursors. Note that the number "ordering columns" are the sum of the order-by, distinct, and group-by columns.
780565 The following DBISQL/ASE-specific option defaults have been changed to be more suitable for ASE servers, especially those with large number of objects: - Results / Disable editing (new default= true) - Commands / Commit after every statement (new default= false) - Commands / Commit on exit or disconnect (new default= false) - Query Editor / Get list of tables on startup (new default= false)
780611 Under rare conditions, the message, "Current process infected with signal 11 (SIGSEGV)" or a timeslice error in the function metrics_GetForMDATable(), may be reported in the error log when the monCachedStatement table is queried in a heavy-loaded environment.
780614 cis idle connection timeout does not work as expected.
780619 KBA 2140170 : Under some conditions, such as killing a process using execute immediate, may cause the server to hang.
780724 A timeslice error in the module 'dol_def_update' together with a stack trace which includes the modules 'dodeferred' and 'xact_endupdate' may be reported in the error log when an UPDATE is executed for a long transaction in deferred mode.
780736 A 9242 error, "RepAgent( < dbid > ): Underflow or overflow of state stack occurred.", may be reported in the SAP ASE error log when the stream replication is enabled. This error will shutdown the Replication Agent process for the given database.
780738 DBCC ZAPDEFRAGINFO will not delete the rows from sysattributes when no action is specified.
780764 The error message, "Current process infected with signal 11 (SIGSEGV)", followed by the stack trace involving the modules 'ra__coord_driver' and 'ra_schema_dealloc_cache' may be reported against the Replication Agent Coordinator Thread when Replication Agent is configured for Multiple Paths Replication and Multiple Scanners, and it is stopped by executing sp_stop_rep_agent.
780810 KBA 2144033 - Framework collectors in DBACockpit DCF fail with Error 605 while running REORG DEFRAG table WITH SKIP_COMPACT_EXTENTS on multiple saptools staging tables concurrently
780832 In case we are running REORG REBUILD in a multi-threaded environment on an APL table followed by DBCC CHECKALLOC() on the database to which the table belongs, the DBCC hits error 12909 indicating that pages reserved by LSA are not unreserved.
780907 KBA 2138576 - When 'FIPS login password encryption' is configured, CREATE ENCRYPTION KEY gets a segmentation violation with a stack trace, and the server fails to start due to SSL initialization failures if SSL is enabled, producing errorlog messages: "... SSL profile initialization failed. SSL is not available." followed by "... Encryption provider initialization failed on engine 0."
780962 sp_who may report AWAITING CMD for currently executing commands. This may happen when executing optimized access for dynamic sql queries.
781057 wrong result could happen when using a scalar aggregate derived table/view as an outer join inner table during INSERT or SELECT...INTO. SELECT c1= d1.d1a , c2= d2.d2a INTO selinto1 FROM (select d1a=avg(c3a) from t3) d1 LEFT JOIN (select d2a=sum(c2a) from t2) d2 ON d1.d1a != d2.d2a WHERE d1.d1a != d2.d2a
781067 Enhancement to allow the Backup Server be identified by another remote Backup Server by its listening address instead of using the default one defined by the routine tables in the operating system. This option is enabled by default. To disable this feature execute "sp_configure 'bind backupserver address', 0".
781099 KBA 2143875 : SAP ASE goes into an infinite loop during index creation with parallel hashstats enabled.
781374 A 7175 error, "Textptr ( < > ) for an in row lob either contains an invalid datarow RID or the datarow cannot be read.", may be reported when running WRITETEXT command with a text pointer value obtained from @@textptr immediately after updating in-row LOB column and one or more columns of other datatype in the same UPDATE command.
781403 KBA 2148393 - DBISQL/jConnect sometimes fails to connect in a VLAN setup and gets a connection timeout when the host is behind a proxy server. To work around the connection issue, try to add "-Dase.useSystemProxies=false" to "VM_ARGUMENTS" line in dbisql.ini file (which is located under "bin" directory.)
781408 When executing a batch insert on a table with a trigger on the table, the trigger may only fire once after the last insert even though each row qualified.
781455 KBA 2168445 - Running UPDATE STATISTICS and TRUNCATE TABLE concurrently may cause the server to hang due to undetected deadlock.
781493 A timeslice error in the module 'rdfrag__display_progress' together with a stack trace which includes the modules 'reorg__ptn_defrag' and 'reorg_main' may be reported in the error log when REORG DEFRAG is executed with the option 'skip_compact_extents' enabled.
781495 KBA 2153895 : An 814 error, "Keep count of buffer < ID > in cache < cache_name > holding logical page < page_id > in database < db_name > has become negative", may be reported when altering an IMDB having multiple cache partitions.
781513 ASE on windows may report an error with a stack trace including an unknown signal (-1073741784)followed by the message, "A SERIOUS UNHANDLED EXCEPTION HAS OCCURRED".
781577 In some circumstances for some queries joining several tables the optimizer could choose a query execution plan which generates bloom filters that at the end are not efficient in filtering out any row and could result in a slight performance degradation.
781610 Under rare circumstances, REORG DEFRAG utility when run with the option 'skip_compact_extents' may terminate prematurely with the error, "REORG DEFRAG of < dbname > terminated due to error or user interrupt.
781628 Duplicate identity column values maybe result after running SELECT INTO when an already existing selected field inherits the identity property.
781650 An 834 error, “Illegal attempt to clean buffer: BUF= < > , MASS= < > , ...”, in the module ‘buffree’ together with a stack trace which includes the modules ‘bufunkeep_cache’ and ‘inserttext’ may be reported in the SAP ASE error log while an INSERT command is executed into an in-memory database table.
781666 The show_condensed_text() built-in function might run into stack trace when condensing some statements with derived tables from union statements or when condensing merge statements.
781684 In rare circumstance, a memory dump might fail with an "Error writing memory segment" error when the option "memory dump compression level" is set as a value greater than 1.
781774 In rare circumstances, CREATE INDEX may fail with a 1289 error, "Internal Error in lock manager routine: Invalid lock mode exclusive page, requested by task (family id < > , spid < > ) conflicts with existing family request mode exclusive page belonging to task (family id < > , spid < > )"
781815 Under rare circumstances, a 605 error, "An attempt was made to fetch logical page ' < > ' from cache ... ", together with a stack trace which includes the module 'dol_bt_getnext' may be reported in the error log when a DML is executed on a table on which a REORG DEFRAG command was run before while rows were being concurrently inserted.
781825 When "enable streamlined parallel" is set to 1, parallel query plans may get generated resulting in serious performance issues.
781828 A 12964 error, "DBCC cannot insert the row in the dbcc_operation_log table for this check of database < database name > , aborting check." may be reported when running DBCC CHECKSTORAGE on a SDC server.
781853 In rare circumstances a query executed in parallel may appear as hang when it is killed by other session. If DBCC STACKTRACE() is run in the parent session it would report a stack trace which includes the modules 'uwdisconnect' and 'err_disconnect_allchildren' and if run in any of the worker processes it includes 'LeScanContext::syncOnBloomFilters' and 'LeExecuteWorkUnits'.
781859 KBA 2154464 - In some circumstances, Adaptive Server may report a stacktrace which includes modules GtsState::GtsGetGt() and SeHyPsStarQueryRule::_RuleSnowFlakeMatch(), when a fact_table hint is given in the input abstract plan.
781934 KBA 2161325 - sp_monitorconfig "additional network memory" always return a value of 0 for Num_active.
782006 A new error message 140064, "ERROR in < module_name > for plc < 0x > ... " is created to qualify for a shared memory dump condition in case wrong number of log records are moved during PLC discard which may result in wrong count in PLC. Additionally new error message 140063, "ERROR in < module_name > for plc < 0x > ... " is created to qualify for a shared memory dump condition in case of wrong PLC count or wrong log record size in PLC while the PLC is flushed to syslogs. These messages are printed in the error log. These errors may result in error 3475.
782010 In rare circumstances, SAP ASE may hang as a result of an undetected deadlock between a process doing REORG DEFRAG and a process doing level 0 scans or dirty reads under a transaction that included DMLs.
782011 A 1108 error, "Cannot deallocate extent < extentid > , database < dbid > . Object id < objid > , index id < indid > , status 1 in extent does not match object id < objid2 > , index id < indid2 > , status 0 in object being deallocated. Run DBCC CHECKALLOC." may be reported in the module 'pg__dropbuf' together with a stack trace in the error log which includes the modules 'xact_rollback' and 'undo_apl_aextent', when online reorg rebuild rolls back.
782102 A 3475 error, "There is no space available in SYSLOGS to log a record for which space has been reserved in database ' < dbname > '", can sometimes be reported if the current process or other processes in the system are executing minimally logged DMLs on tables having TEXT/IMAGE columns.
782158 KBA 2158479 - An 806 error, "Could not find virtual page for logical page < page_no > in database < dbname > " may be reported in the error log when executing ALTER DATABASE for encryption after an upgrade from a pre-16.0 server.
782182 New option "short" added for sp_showplan to display statistics information only. Query text and plan won't be printed with this option. "Rows affected" is also added to output of sp_showplan.
782222 The fix for CR 776287 is redesigned not to take corrective actions in the context of error 3475.
782225 A 1105 error, “Can't allocate space for object ' < > ' in database ' < > ' because 'syslogs' segment is full/has no free extents…”, may be reported on a user defined temporary in-memory database when DML commands are executed concurrently in cross-imdb transactions whereby the log cannot be truncated.
782294 When auditing is enabled and an audit option that captures ALTER LOGIN is set and ALTER LOGIN .. MODIFY PASSWD is executed, then the ALTER LOGIN audit event is missing in the audit trail.
782316 A 11277 error, "Operating system error 2: 'No such file or directory'", may be reported on Windows when the stored procedure sp_dump_history is run with the 'list' option.
782319 sp_helpcache reports the "In memory cache size" as negative for cache sizes > = 2GB.
782345 Incorrect progress report (progress > 100%) may be reported when running dbcc tablealloc() on syslogs table.
782426 KBA 2184795. The SKIP_ALLOC, INSTANCE and TYPE clause for DISK INIT only accepts "true" or "false" in lower case. This is inconsistent with other clauses such as DSYNC and DIRECTIO, which accept any case.
782443 When ASE Replication Agent is configured for Multiple Paths Replication, the procedure rs_ticket is not distributed properly to all replication paths due to missing 'begin tran' commands.
782486 KBA 2190386 - The error, "Attempt to start database device i/o failed: State = 118 Msg = Attempt to issue i/o beyond offset of 2 GB failed, since the operating system does not support it", will be reported in the Backup Server errorlog when a database device is bigger than 2GB in solaris 64 bits.
782519 The error,"Current process infected with signal 11 (SIGSEGV)", followed by a stack trace involving the module 'decompress_column_by_coloff' may be reported in the error log when executing online split partitions.
782567 Enhancements to the Sybmon utility to prevent signal 11 when 'mmgrpools' or 'who' command is executed, improve the performance of the 'spinlocks' command, and prevent signal 11 when 'log on' command is executed while the log file is already open.
782571 Addition of validation checks for a session's User Log Cache when log records are added or removed from it, so as to manage error handling in case any inconsistencies are found.
782573 In rare circumstances SAP ASE Cluster Edition may encounter an infected with 11 (SIGSEGV) or errors 1265 - "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family...." or 834 - "Illegal attempt to clean buffer: ..." during compilation of stored procedures.
782596 KBA 2168634 : A 3474 error, "During redo the page timestamp value is less than old timestamp from log. ...", may be reported during LOAD TRANSACTION of a transaction log dump that includes log records pertaining to DMLs executed after a successful run of the online reorg rebuild. Or, a 2503 error, "Table corrupt: Page linkage is not consistent" may be reported by a DBCC CHECKTABLE on the table after the database has been onlined after the above mentioned load sequence.
782609 The timestamp in a database after a cross platform load does not match the timestamp of the source database.
782634 Print object list for INSERT/UPDATE/DELETE/SELECT with option 'set show_object_list on'. Print object list in output of sp_showplan with option 'long' and 'full'.
782648 The message, "Backup Server: 1.67.2.16: Backup Server Internal Error in function 'fatoi'", will be raised by the Backup Server when trying to execute a remote dump or load on a Backup Server with a version less than 15.7SP60, or a version between 15.7SP101 and 15.7SP121.
782685 A 7128 error, "Text pointer value < value > references a data page which is no longer allocated. This text pointer references first text page < page # > , which belongs to object ID < object ID > .", may be reported when running SELECT command on LOB columns while concurrent DELETE command is also running on the same table.
782706 When using deferred parallel, optimizer may not choose parallel query plans that it would have chosen in non-deferred mode.
782714 If more than one dimension tables are joined using the same column from a fact table, the fact_table hint may fail.
782735 The role_locked audit option is missing in the list displayed by sp_audit
782817 The error, "Current process infected with signal 11 (SIGSEGV)", followed by a stack trace involving the function 'bi_dbencryption_status' may be reported in the error log when executing ALTER DATABASE for encryption/decryption.
782835 KBA 2161415 : On SAP ASE Cluster Edition, the value of the spid displayed is zero when executing the system stored procedure sp_help_rep_agent and when querying the MDA tables monRepLogActivity, monRepScanners and monRepSenders even though the Replication Agent Thread is running.
782845 When using "alter database ... off" to shrink a database, if a disk piece's location column in sysusages is null and that disk piece must be divided, the resultant sysusages entry for that disk piece can have invalid entries for unreservedpgs and crdate.
782869 KBA2197020: SQL query with TOP and abstract plan using user defined optimization goal may fail with stack traces reported in the error log.
782871 KBA 2164927 : In some circumstances, a query on the monLock MDA table may cause some running processes to be infected by timeslice errors.
782880 KBA 2165280 - A 10350 error, "Permission related internal error was encountered. Unable to continue", may be reported when executing DML statements on tables with encrypted column having decrypt default on columns 64 and above.
782896 Allow the use of sp_chgattribute < tablename > , plldegree < degree > as a way to force HASH based parallel scan of a table that does not have a data skew above the maximum threshold for partitioning skew.
782906 Disable ISP and PIU for CE. Will be supported in following SP's
782907 In rare circumstances an undetected deadlock may be seen among DUMP DATABASE, DUMP TRANSACTION and CREATE INDEX when these commands are executed on the same database concurrently. A 8213 error, "Failed to acquire address lock on object DDLOG", may result from the deadlock.
783010 In rare cases, a 14108 error, "Could not find partition descriptor for objid < > , indid < > , ptnid < > in dbid < > ." may be reported in the SAP ASE error log when an ALTER TABLE command is rolled back following some error.
783048 An 806 error, "Could not find virtual page for logical page < psge# > in database 'master'", may be reported in the SAP ASE error log when streaming replication is enabled and while failover or failback operations are taking place in an HADR system.
783072 KBA 2160024 - A 11060 error, "This statement has exceeded the maximum number of recompilations (10). This indicates an internal error", may be reported when executing a stored procedure that includes a SELECT INTO with the source table having an encrypted column with decrypt default and a convert() function.
783192 When textptr() and ORDER BY are both used in the same SELECT statement, textptr() may return bad text pointers if the target TEXT/IMAGE/UNITEXT column has NULL values.
783261 KBA 2162777 : A 9209 error, "RepAgent( < dbid > ): Missing datarow in TEXT/IMAGE/UNITEXT insert log record. Transaction log may be corrupt. Please contact SYBASE Technical Support. (current marker = ( < page# > , < row# > ))", may be reported in the SAP ASE error log during data replication, if the server uses a multi-byte character set, and if LOB data is inserted by WRITETEXT bulk command, and if the last character of the LOB data is a multi-byte character that has to be split into two LOB pages. Alternatively a 9219 error, "RepAgent( < dbid > ): Internal coding error", may be reported.
783294 KBA 2161945 : Error 4902 is reported when running ALTER TABLE on a table named 'master'.
783581 Do not log DDL for replication when dropping a definition time object.
783594 jConnect: Calling getColumns() method on DatabaseMetaData object may execute with sub-optimal query plans after a large number of database objects are created.
783598 KBA 2166005 - If a query has several predicates on the same columns and the columns are CHAR/VARCHAR datatypes, it could hang when we try to eliminate some predicates. For the DEBUG binary, it will cause an assertion failure.
783610 When stream replication is enabled the Replication Agent scanner process can sometimes not be killed using the T-SQL kill command.
783665 The PCA/JVM default configuration settings have been changed to disable File I/O opeartions for the temporary directory option 'pca_jvm_tmp_dir' and the working directory option 'pca_jvm_work_dir'.
783667 The PCA/JVM provided Secure Class loader will deny executing methods that request to load dynamic shared libraries by default.
783804 KBA 2172868. The 15413 message, "An internal error occurred during an encryption operation (error code -1). Please contact Sybase Technical Support", will be reported with inserting into encrypted columns with select list and order by having encrypted column with length > 255 bytes.
783860 The qrmutil tool may return an exit status of 0 even when when the command fails.
783985 KBA 2168462 - The error, "Pathname parameter must specify an absolute pathname", followed by error, "RPC ('as_arch_device') execution failed", may be reported in the SAP Backup Server error log if a remote DUMP DATABASE USING CONFIG command is executed while using a remote configuration option that was defined by sp_config_dump 'remote_cfg'.
784023 In rare circumstances on a SDC server, a duplicate identity value may result when invoke RESERVE_IDENTITY after LOAD TRAN.
784030 The 15432 message, "A validation check failed when Adaptive Server decrypted an encryption key. This error may indicate an incorrect password.", will be raised when ALTER ENCRYPTION KEY is executed to add key copy for recovery and to recover the key copy in a stored procedure.
784222 KBA 2170606 : An 899 error, "The page < page# > requested for in-memory database ' < dbname > ' ( < dbid > ), object ' < name > ' ( < id > ) was not found in in-memory storage cache ' < cachename > '(id < cacheid > ). Please contact Sybase Technical Support.", may be reported in the SAP ASE error log during startup while an in-memory database is recovered and when there is more than one in-memory database and the configuration option ‘number of large i/o buffers’ value is not sufficient. This error can also be reported during the creation of in-memory database when a concurrent load database is run. Sometimes a 6103 error, "Unable to do cleanup for the killed process; received Msg 14120.", may also be reported.
784547 A 3101 error, "Database in use. A user with System Administrator (SA) role must have exclusive use of database to run load.", may be reported during the execution of DUMP database, if the RepAgent has been previously shutdown.
784563 A 19816 error, "You cannot set configuration values from inside a local temporary database" may be reported when executing sp_configure on a Single Instance Database.
784606 An 871 error, "Process %d is trying to release a latch on buffer 0x%x (dbid: %d, pageno: %u) without holding a latch on the buffer", may occur when executing an online parallel create index in the Data Page lock scheme.
784686 In ASE Cluster Edition, in certain cases, a 1204 error, 'ASE has run out of LOCKS' may be reported.
784994 The message "current process infected with 11" in the module 'ra__relocate_dol_vals' or 'ra__relocate_apl_vals' together with a stack trace which includes the modules 'ra__ci_scanner_scan' and 'ra__process_xrowimage' may be reported in the SAP ASE error log while the Rep Agent process is processing a datarow for a table having not null non materialized default columns.
785103 In rare circumstances, a 605 error "An attempt was made to fetch logical page '' from cache ''. Page belongs to < > and not to < > .", or a 697 error "An attempt was made to fetch logical page '' for < > from cache ''. Wrong logical page '' was found in cache.", or a 12546 error "During undo the timestamp to be assigned to a page is less than the current page timestamp. Page = '', object id = < > , page timestamp = (x y), new page timestamp = (p q), or an 806 error "Could not find virtual page for logical page '' in database < > ' may be reported in the SAP ASE error log by an 'online database' command when preceded by a sequence of load trans of transaction logs that contain at least one incomplete transaction pertaining to online reorg rebuild.
785218 Error 622 could be seen followed by error 3702 at the time of drop of that object if compatibility mode is ON and a query with LIKE clause is run.
785237 Error 691 "Encountered invalid logical page 'pgno' while accessing 'ptninfo'. This is an internal system error. Please contact SAP Technical Support." maybe reported, when several parallel create local index run at same time.
785333 KBA 2186543. An infected with 11 (SIGSEGV) at decompress_column_by_colid() may be encountered during upgrade from SAP ASE 12.5 to SAP ASE 15.7.
785377 TRUNCATE of a specified partition may sometimes may truncate the wrong partition when there exists a partition name for the table whose partition name starts with the full partition name of the partition that is intended to be truncated. e.g. if partition name "week1" was requested to be truncated and there was also a partition name on the table called "week14", then "week14" may be truncated instead of "week1".
785404 ESP (extended stored procedure) execution may fail if overall path of the ESP DLL is more than 99 characters or more (including the name of the DLL).
785441 In rare circumstances, when online partition utility is running, an infected with signal 11 (SIGSEGV) may be reported in the SAP ASE errorlog.
785504 KBA 2181636 - When loading a database dump that contains CIS proxy tables with LOB columns that map to remote tables on a system that does't support text pointers, the load sequence will be incorrectly broken if SAP ASE is restarted, because the database recovery will incorrectly create one transaction for each of these proxy tables.
785554 Under UTF8 sort order 99, if a composite index contains a leading NULL VARCHAR field, REORG REINDEX may not be able to rebuild the index.
785644 KBA:2185800 - When there is a line comment line in stored procedure with odd number of "*", error 724 raised in auditing process.
785701 In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #= < > , object id = < > ..." is reported by SAP ASE during a LOAD TRAN of a transaction dump that includes a transaction of online REORG REBUILD or non-online CREATE INDEX if the earlier portion of load sequence contains a transaction of online CREATE INDEX with deferred recovery.
785923 Reduce the likelihood of deadlocks contention if a unique index exists on a table.
786104 Using ALTER TABLE ADD column_name IDENTITY sets the wrong attributes in syscolumns.
786126 In rare cases, when doing parallel CREATE INDEX in tempdb or other low durability database, error 3478 (the timestamp on the page is older than the log new ts in the log record) may be reported during rollback of the transaction at the time when rolling back an OAMCREATE log record. Alternatively error 1142 (invalid OAM page) may be seen during rollback of parallel reorg rebuild.
786420 KBA 2201449: A 15413 error, "An internal error occurred during an encryption operation (error code < n > ). Please contact SAP Technical Support", may be reported when selecting data from encrypted columns.
786474 The monLocks table, may only report a subset of locks from syslocks..
786588 An 8201 error, "Mismatch found between the name and id descriptor hash table for table...", accompanied by a stack trace that includes the modules 'des__clean' and 'des__scavenge' may be reported in the error log in some high concurrency scenarios.
786594 It can take a long time to return all rows from MDA tables if the result set is very large.
786618 KBA 2192618: On AIX Platform, xpserver fails to start with error messages: "exec(): 0509-036 Cannot load program xpserver because of the following errors: 0509-150 Dependent module libsybsrv64.so could not be loaded. 0509-022 Cannot load module libsybsrv64.so. 0509-026 System error: A file or directory in the path name does not exist." This shared object is not distributed with SAP ASE or the SAP Connectivity SDK.
786637 CT-Lib ct_results() returned CS_CMD_FAIL for errors previously ignored, causing compatibility issues in JSTemplate due to SAP OCS CR 770865.
786692 The command LOAD DATABASE from < archive > with listonly=create_sql may incorrectly report the options INDEX_COMPRESSION or ENCRYPT WITH < keyname > for the CREATE and ALTER DATABASE commands, when the dump file belongs to an older SAP ASE version where these options did not exist.
786727 In rare cases, when doing parallel reorg rebuild in tempdb or other low durability database, error 3478 (the timestamp on the page is older than the log new ts in the log record) may be reported during rollback of the transaction at the time when rolling back an ALLOC log record.
786728 In rare circumstances where partition locking is enabled and a command is being executed using parallel threads ASE may hit timeslice error involving lock_antinherit() function.
786780 In rare circumstances, the message "current process infected with signal 11" in the module OptGlobal::_GblAddTopLevel() together with a stack trace which includes the module emitMatchProperties() may be reported when running a complex query.
786808 The message, "SYBMULTBUF ERROR: Fatal Error: Database emulator failed while executing command 161", will be printed in the Backup Server error log and a DUMP command will abort if the database being dumped is created on ZFS file system and the backup server is started with trace flag -D512.
786895 If a stored procedure is accessing an object that is created by a different user, SAP ASE cluster edition may report the error "Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object ' < object name > '.". The stored procedure will still be created.
787016 KBA 2224574 - If SAP ASE configured to use native threads encounters a segmentation fault (infected with 11 (SIGSEGV)) whilst dumping shared memory (a the dump configured with multiple dump threads) then SAP ASE may crash.
787084 When Adaptive Server is running the query processor in compatibility mode, queries with tables having predicated privileges will not work.
787228 At SAP ASE startup the following error message may appear in the errorlog, "Error: 3701, Severity: 11, State: 1, Cannot drop the encryption key 'syb_xpskey*', because it doesn't exist in the system catalogs."
787245 In rare circumstances, SAP ASE may fail to perform ALTER TABLE UNPARTITION with error 11051 - " < op > on the object < name > ' failed. Table is currently being used by one or more other tasks", if the table is created with 'for load' option and ALTER TABLE UNPARTITION is being executed from a node immediately after booting the node.
787692 The monProcedureCacheModuleUsage and monProcedureCacheMemoryUsage tables might report zero in HWM column although the Active column is not zero.
787699 In rare circumstances, when online CREATE INDEX is issued on an empty table and concurrent DMLs insert new rows in the table that cause addition of new index level, syspartition may report wrong ptnfirst value and subsequent CHECKALLOC may fail.
787729 In rare circumstances, during connection migration, "conn__migrate_delete_context: sysid < value > sesid < value > could not delete context" error may be reported in the error log and the migration may fail.
787815 The message "current process infected with signal 11" in the module 'mon_embedDestroy', together with a stack trace that involves the modules 'ra__init_thread' and 'ra_close_context' may be reported in the SAP ASE error log during the early stages of Rep Agent startup.
787843 ASE Cluster Edition which is I/O fencing enabled may fail to find a matching fence device for a database device when it reboots.
787966 The message, "Current process infected with signal 11 (SIGSEGV)", followed by a stacktrace that includes the module mda_fill_and_send_monProcessObject() may be reported in the error log when running the query, "insert #monProcessObject select from master..monProcessObject"
788080 On the IBM AIX platform, xp_cmdshell executions may fail with the error message: "Could not load library < $SYBASE > / < $SYBASE_ASE > /lib/sybsyesp.so"
788353 KBA 2208560: XPServer behaviour change for running shell scripts from SP135 onwards
788427 In rare circumstances, during connection migration, "conn__migrate_delete_context: sysid < value > sesid < value > could not delete context" error may be reported in the error log.
788474 KBA 2211717: Under some rare condition, if columns in a table have more than one constraints (not necessary in the same column), it can cause invalid rows to be inserted.
788492 NFR: RDMA support in sybcluster
788552 In rare circumstances, when CREATE INDEX with ONLINE is executed on an APL table and there are several concurrent DMLs active, SAP ASE may hit an infected with 11 (SIGSEGV).
788570 The value of "Pass Active For" time reported by dbcc showrecovery is always a multiple of 1000 milli seconds.
788702 The 3475 message, "There is no space available in SYSLOGS to log a record for which space has been reserved in database 'tempdb'", may be reported in the SAP ASE error log for database tempdb, when a log fragment was previously dropped from tempdb using sp_dropsegment.
788769 The message "current process infected with 11" in the module ‘mda__populate_RepScannersTable’ together with a stack trace which includes the modules ‘mda_exec’ and ‘mda_populate_monRepScanners’ may be reported in the error log when a query on the master..monRepScanners table is run and while the Replication Agent is shut down concurrently.
788911 In certain circumstances, preupgrade fails with “Invalid column name 'status2'” error when trying to access the status2 column of the master..sysdevices table
789109 The error 'uncompress(): Input data corrupted' could be raised when loading a compressed dump created either using the Backup Server API "compress::" or the command option WITH COMPRESSION [= 1..9].
789553 Sybcluster failed to get heartbeat info sometimes.
789675 The p_drv_bcpmetadata stored procedure is enhanced in order to improve the performance of jConnect ENABLE_BULK_LOAD.
789944 Under some rare situations, updating a table through a IOT (instead of trigger) could result in error 16863.
789967 In rare circumstances, a 12308 error, "Invalid row id (Row < > , Page < > ) encountered in the table 'T' in database 'D'" or a 614 error "Adaptive Server accessed a row that has an illegal length of < n > while in data base 'X' ..." may be reported by a REORG REBUILD index or a DML following REORG DEFRAG on a table.
790239 ASE might report boot failures with error such as "Incorrect Java Virtual Machine library version" in errorlog file on Windows NT platforms (nt386 / winx64) if the ASE PCI Bridge configuration parameter “pci memory size” is set as a value lower than 512 reserving 1 MBytes memory.
790240 When predicated privileges, granular permissions or restricted decrypt permission configuration options are enabled, the Adaptive Server running on SDC mode fails to start.
790265 The message, "Current process infected with 11 (SIGSEGV)", in the module 'ds_destroy_table' together with a stack trace which includes the modules 'exec_dbcc' and 'checkalloc' may be reported in the SAP ASE error log when DBCC CHECKALLOC is interrupted by a Control-C.
790397 sybcluster may hit 'Connection refused' error when creating server if set loopback address to hostname in /etc/hosts
790456 Under rare circumstances, an 871 error "Process < n > is trying to release a latch on buffer < 0x > (dbid: < n > , pageno: < n > ) without holding a latch on the buffer" may be reported in the SAP ASE error log by reorg defrag when used with 'skip_compact_extents' option and a lock promotion to table level has occurred while reorg was executed.
790473 The command DBCC CHECKSTORAGE() can report the error 'Compressed length ( < value > ) is too big. File probably corrupted.' in the SAP error log, if executed on an archive database that is created on a compressed dump.
790582 The 4325 error, "The specified recovery date is not between the start and end date.", may be reported when executing the LOAD TRAN WITH UNTIL_TIME generated by LOAD DATABASE WITH LISTONLY,UNTIL_TIME, if the selected time is between the time of the last transaction in the dump and the moment the dump transaction is executed.
790776 Default value of "physical lock cushion" changed to 100.
790983 A 3475 error, "There is no space available in SYSLOGS to log a record for which space has been reserved in database ' < name > ' ( < id > )", may be reported when the difference between the last change threshold and a user defined threshold for the log segment is less than 128 pages.
791390 The message, "Current process infected with signal 11 (SIGSEGV)" in the module 'xpd_swap_msb_i2' together with a stack trace which includes the modules 'lddb__unscr_phys_page' and 'lddb_unscramble' may be reported in the SAP ASE error log during the execution of a cross-platform DATABASE LOAD command.
791585 sp_helpconfig stored procedure fails to generate a descriptive message or worse it may generate a totally unrelated message to the configuration option given as argument.
791654 A 2620 error, "The offset of the row number at offset < > does not match the entry in the offset table of the following page: Page pointer = < > , pageno = < > , status = < > , ptnid = < > , indexid = < > , level = < > , pnextrno = < > .", may be reported when loading a transaction dump either from SAP ASE 15.7 SP60, or 15.7 SP110 version, into SAP ASE 16.0 GA version.
791753 Disable DTA infrastructure for SDC
791767 A 2620 error, "The offset of the row number at offset < > does not match the entry in the offset table of the following page: Page pointer = < > , pageno = < > , status = < > , ptnid = < > , indexid = < > , level = < > , pnextrno = < > .", may be reported when loading a transaction dump from either SAP ASE 15.7 SP60, or 15.7 SP110 version, into SAP ASE 16.0 GA version.
791847 The message, "Current process infected with signal 11 (SIGSEGV)", may be reported in the error log after starting XPserver with traceflag 8022 (turn off enhanced security) enabled.
791935 In rare cases when creating a database of max db size, error "Cluster lock manager of instance %d has received an invalid lookup request for directory instance %d from instance %d" can be seen followed by a hang.
792483 In rare case, if DOL table with datapages lockschema has unique index, concurrent DML may hit index corruption (error 12313 "Insert into page id < page # > of index id < index # > of table ' < table name > ' (id = < id # > ) in database ' < db name > ' tried to replace undeleted RID ( < > , < > ) at slot < slot # > and ridposn < # > . Try dropping and recreating the index.").
792841 KBA 2240012 : A 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #= < > , object id = < > , page timestamp= < > . Log old timestamp= < > . Log record marker = ( < > ).", may be reported during LOAD TRANSACTION if either the built-in reserve_identity() or the dbcc set_identity_burn_max() command have been executed when the transaction dump was taken. Extended fix for SDC.

Read more...

Environment

  • AIX 64bit
  • HP-UX on IA64 64bit
  • Linux on x86 64 64bit
  • Solaris on Sparc 64bit
  • Solaris on x86 64 64bit

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR, CR List, ASE 16.0 CE SP01, ASE CE SP01, CE SP01, Cluster Edition SP01 , KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.