Symptom
The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in future Adaptive Server Enterprise (ASE) EBF/SP or PL releases. Please be sure to read the Disclaimer below.
If the EBF/SP has been released, check the CR list and coverletter at the service.sap.com.
Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release.
CR Number | Description |
---|---|
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 > '.". |
724843 | Signal 11 in OmniQuickPass::targetlist()could occur for SQL statement with subquery when show_transformed_sql is on. |
730608 | ASE might report the 225 error that some query--referenced object cannot be dropped during query optimization in sp_sysmon_kernel_threaded when running sp_sysmon in parallel. |
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. |
737720 | A 3914 error - "llegal internal transaction status. This is an internal system error." may be reported with the SAP ASE Cluster Edition when using dynamic SQL. |
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. |
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 errorlog when dumping a database to a non-existing directory. |
749462 | KBA 2115602. When statement cache is on and if fewer of parameters are sent to SAP ASE than the query expects, then an infected with 11 (SIGSEGV) stacktrace in the s__make_param() function may be reported in the SAP ASE errorlog. |
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. |
753171 | Error 1289 - "Internal Error in lock manager routine: Invalid lock mode ..." may be raised when SAP ASE executes a select-for-update (SFU) query and the following conditions apply: 1. The SFU query contains a TOP clause or a 'set rowcount' command was previously executed to limit the number of rows returned by the SFU query and 2. The number of rows that qualify for the SFU query exceeds the limit imposed by the TOP clause or 'set rowcount' command and 3. The optimizer chooses a parallel query plan to execute the SFU query. |
753408 | PagesTouched queried from monCachePool is larger than AllocatedPages under some rare circumstance. |
754621 | preupgrade may underestimate the needed space for databases to be upgraded to 15.7 SP100 or later. |
754653 | SAP ASE may fail to boot on an AIX 7.1 machine if the machine has a missing /usr/vacpp/lib/libhC.a library. The AIX error message will report that "Dependent module libhC.a(ansi_64.o) could not be loaded." |
754736 | When starting an SAP ASE server up with hundreds of engines, the CPU utilization is high and the server seems to hang. |
759322 | If replication is currently disabled and a table having non-materialized columns is dropped or one of its non-materialized defaults changes, then when replication is enabled again, it can encounter errors when trying to replicate that table's rows. |
761333 | In some workloads with lot of dynamic prepare statements executing on the system, we would see buffer cache of system table 'sysusers' and 'sysdatabases' to be hot. |
761835 | 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_helpdn output. |
762392 | In rare circumstances many processes could get locked when a dump command is trying to prune trailing holes at the end of the database. |
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. |
767058 | In rare circumstances an infected with 11 (SIGSEGV) in the function com__exctnume_copy may be reported in the SAP ASE errorlog 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. |
767605 | UPDATE STATISTICS when run concurrently with REORG DEFRAG or TRUNCATE TABLE might end up in a state where no progress is made. |
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. |
767966 | Reduce the sybmgmtdb database space requirement in the Job Scheduler upgrade. |
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. |
768374 | The replication support for tables that have default not-null non-materialized columns has been enhanced. |
768463 | DDLGen gets EC2 SybSQLException error when -TEC -N% on a huge number of db server |
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. |
768781 | Under rare circumstances, reorg defrag might hit error 1265 "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr= < > , lrmagic=f)." just before ending its final transaction. |
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 | Error 832 when 'max buffers per lava operator' is set to maximum config value 65535 (or very close to max value). |
769653 | Sybmigrate supports the ASE 15.7 SP130 new features: HADR and 'Resolve as owner' on Stand By server. |
769966 | KBA 2115571. Index creation always running in serial mode when the first selected column contains large percentage of NULL values. |
770016 | When execute some statements through JDBC such as table create statement, sometimes, it could hang. |
770041 | OpenSSL FIPS is not certified. |
770078 | Rep Agent stops working while processing a Data Modification Language operation on a table containing not materialized defaults with datetime data type. The error reported is 249: Syntax error during implicit converstion of VARCHAR value 'xxxxx' to a DATE field. The stack trace reported will include the function des_get_column_dflt() |
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. |
770513 | The error message 'The text column descriptor returned from the execution of rs_get_textptr function string output commands is NULL. The text descriptor must be valid. The DSI thread for database is shutdown.' will be reported in Repserver error log file, if Repserver configure 'dsi_compile_enabl' is off, when try to update a NULL LOB column which could be replicated. |
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. |
770822 | An SAP ASE Cluster Edition server might crash with error "Unknown logical cluster type" during boot after upgrade |
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 | If SAP ASE received an external attention during merge join and internal sorting, an infected with 11 (SIGSEGV) in routine sortclean() may be reported in the SAP ASE errorlog and SAP ASE may core dump. |
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. |
770992 | KBA 2109339. In rare circumstances, the error 692, " Uninitialized logical page ' < pageno > ' was read while accessing database ..." could be raised when creating a database with FOR LOAD option. |
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. |
771039 | In rare circumstances when the option 'enable incremental dump' is enabled in the database, the message 'closetable: table already closed for sdes ...' followed by a stack trace that includes the modules 'xact_end_session' and 'closetable' may be reported in the SAP ASE error log. |
771053 | SAP ASE may encounter a signal 11 (SIGSEGV) in the function usgetipaddr() on the IBM AIX platform |
771055 | On the IBM AIX platform, while generating stack trace, SIGSEGV (Signal 11) or timeslice error is observed in search_tbt() or strncpy(). |
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. |
771170 | An SAP ASE Cluster Edition server or connection might hang when binding a Single Instance Database (SIDB) to a Single Instance Logical Cluter (SILC) after the SILC has been onlined |
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. |
771198 | The message "current process infected with 11 (SIGSEGV)" in the module 'dam_prepare_dump_end' together with a stack trace which includes the module 'dpdb_main' may be reported in the SAP ASE error log when a DUMP DATABASE is executed and while a concurrent DUMP TRANSACTION is aborted. This would require the configuration option 'enable concurrent dump' and the database option 'allow incremental dumps' being both enabled. |
771228 | SAP ASE may report the message "Assertion (this- > tMagic == 0x4B545255) failed in file ..." when using sp_sysmon |
771230 | A REORG DEFRAG process, if killed, then in rare cases could leave the state of object specifying that an utility is active. |
771240 | sybcluster: new option 'upgrade_ok' for command 'start cluster' and 'start instance' to support start server with new binary against old data devices. |
771258 | Server command "update t2 set c1 = 6 " encountered a deadlock situation |
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. |
771301 | The error "Volume validation error: attempt to open ' < file name > ' returned Too many open files" can be raised by the SAP ASE backup server when trying to dump or load on the SOLARIS, HP and IBM AIX platforms after running for some time because a socket is being left opened every time a connection is established. |
771344 | sybdiag does not report the configuration option "prevent automatic upgrade". |
771370 | If a query contains a COUNT_BIG() aggregate and the optimizer generates a 2 phase PARALLEL aggregation strategy, then the value returned will be incorrect. The value will be equal to the number of producer threads under the 2 phase aggregate's supporting XCHG operator. |
771433 | Repeated reduction/increasing the number of running engines in threaded kernel mode (using alter thread pool) may eventually lead to a situation where a server login is not possible. |
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. |
771719 | DDLGEN capturing incorrect Stored Procedure DDL: When SP is set to both ‘anymode’ and 'dynamic' |
771770 | In rare circumstances, an undetected deadlock may occur following 1249 error, "Process became runnable before lock it was waiting for was released", is reported. |
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. |
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 | 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 | When running SAP ASE diagserver and the service key "syb_extpasswdkey" is dropped, under some circumstances the following assertion failure is seen in the errorlog: "Assertion (pwdlen < SAMAXPWDLEN+1) failed in file /remote/aptos_bld1/asecorona/SMP/porttree/svr/sql/generic/source/utils/ssladmin.c line 414" |
773131 | In rare circumstances ASE may hit heap memory error(712) when executing dbcc listoam on table with high OAM entry count. "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" |
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. |
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. |
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 | 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. |
774198 | KBA 2077419 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. |
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. |
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 |
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 > " |
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. |
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." |
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. |
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. |
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. |
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. |
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. |
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 | 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. |
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.". |
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'. |
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. |
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. |
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 | suser_name() may display incorrect user name after a cross database execute as owner stored procedure is executed from a parent stored procedure. |
776748 | 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. |
776962 | Under some rare circumstance, concurrent queries on monProcessProcedures in may lead to an "infected with 11 (SIGSEGV)" being reported in the SAP ASE errorlog. It is possible that no stacktrace is printed. |
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}." |
777119 | Segmentation violation, stack trace, and server panic from a call to kbfalloc occurs when server is under heavy load of login connections and network password encryption is used by the connections. |
777205 | In rare circumstances, a timeslice error might be reported when running a query using the monCachedStatement table. |
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. |
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 |
777693 | 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. |
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. |
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. |
778217 | KBA 2123202 : Some legacy user databases may fail to upgrade to SP130 (or SP131) at upgrade step 245 with: Error: 2601, Severity: 14, State: 6 Attempt to insert duplicate key row in object 'sysusers' with unique index 'ncsysusers1' |
778227 | set proxy inside a regular stored procedure clears the session user's roles after execution of the procedure. |
778304 | Customer might see signal 11 error from ubo_slotscan_getnext() when sp_sysmon is executed or the monTask table is queried with KTID or ThreadPoolID specified. |
778359 | 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= < > )." |
778585 | A 2540 error, "Table Corrupt: Page is allocated but not linked" may be reported when running DBCC CHECKALLOC on a SDC server. |
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. |
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. |
779262 | Page allocation could get expensive when a table grows so large that it requires several hundred OAM pages. |
779445 | When fast BCP is used in databases where page signatures are enabled, it can happen that ASE attempts to fetch a page using an invalid page ID. When this happens, a stack trace appears that will include function "log_to_virt()". |
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. |
779498 | If the join_skew_threshold is active then there could be incorrect estimates for semi-join costing. In particular, this could be a problem for bloom filter costing which includes semi-join costing. the join_skew_threshold feature is not documented at this point. |
779750 | KBA2040888. 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 | 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. |
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. |
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. |
780207 | 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. |
780424 | During periods of heavy I/O stress, creating page signatures can result in error 2628, incorrect page linkage. |
780619 | KBA 2140170 - UPDATE STATISTICS consumes 100% CPU after being killed |
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 |
781099 | KBA 2143875 - When a dirty buffer chain link is broken then ASE goes into an infinite loop. |
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. |
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 - Altering IMDB having multiple cache partitions caused 814 error. |
781513 | ASE on windows may print a stack trace including "unknown signal (-1073741784)" followed by "A SERIOUS UNHANDLED EXCEPTION HAS OCCURRED" |
781610 | Under rare circumstances, reorg defrag utility might terminate prematurely when run with the option 'skip_compact_extents' logging in the errorlog a statement 'REORG DEFRAG of < > terminated due to error or user interrupt.' |
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. |
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. |
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 having the option dml_logging=minimal enabled when DML commands are executed concurrently in cross-imdb transactions whereby the log cannot be truncated. |
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. |
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 SP134
- AIX 64bit
- HP-UX on IA64 64bit
- Linux on Power 64bit
- Linux on x86 64 64bit
- Solaris on Sparc 64bit
- Solaris on x86 64 64bit
- Windows on x64 64bit
Product
Keywords
Fix, Patch, Bug , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.