/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in Adaptive Server Enterprise (ASE) 16.0 CE SP01. Please be sure to read the Disclaimer below.
If the EBF/SP has been released, check the CR list and coverletter at the support.sap.com.
Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release.
| CR Number | Description |
|---|---|
| 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)