SAP Knowledge Base Article - Preview

2110922 - Targeted CR List for ASE 15.7 SP134

Symptom

The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in future Adaptive Server Enterprise (ASE) EBF/SP or PL releases. Please be sure to read the Disclaimer below.

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

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

CR NumberDescription
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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition

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.