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 |
---|---|
744560 | In rare circumstances, when the CREATE INDEX and REORG REBUILD commands are running in parallel, WORKER processes may hang/sleep infinitely. |
747046 | The odata metadata query shows precision=0 and scale=0 for money, smallmoney, datetime, bigdatetime, time data types. The values are now displayed correctly following the code change. |
749795 | The loginfo() built-in has been optimized to avoid blocking while database dump or dump transaction is executed concurrently. Similar optimization was made to lct_admin() built-in when used with "num_logpages" option. |
750655 | The message, "current process infected with signal 11", together with a stack trace involving the functions rtms_print_um_error() may be reported when a spid waiting for get a JMS message raises error. |
751184 | The Secondary Truncation Point may not be moving as expected by the SAP ASE RepAgent process in a Multiple Paths Replication environment. |
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. |
753302 | When we create a table with global variable as a default and then insert a row into this table in the same batch, it will stacktrace if the insert is not cached either due to switch off statement cache or using special traceflags. |
754653 | SAP ASE may fail to boot on AIX 7.1 machine with following error if it has missing /usr/vacpp/lib/libhC.a library, for example: % $SYBASE/$SYBASE_ASE/dataserver -v "exec(): 0509-036 Cannot load program < binary path > because of the following errors: 0509-150 Dependent module libhC.a(ansi_64.o) could not be loaded. 0509-022 Cannot load module libhC.a(ansi_64.o). 0509-026 System error: A file or directory in the path name does not exist." |
760269 | A 9254 error 'RepAgent( < dbid > ): Could not locate schema version for object id ' < value > ' in the transaction log." followed by a 9204 error 'RepAgent( < dbid > ): Could not locate schema for object with id = ( < value > ), current marker ( < page# > , < row# > ).' may be reported in the SAP ASE error log when SQL Statement Replication is active and a transaction involving SQL statement Replication is rolled back. This will result in the Rep Agent Thread terminating abnormally. |
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. |
762057 | In rare circumstances if dbcc pss fails it may leave the pss in a kept state and cause subsequent commands to get fail with error 8601 "Process %d tried to keep the PSS for process %d when it already had the PSS for process %d kept." |
762072 | The messages 'ERROR: JNI_CreateJavaVM; failed attaching to the JVM for AttachCurrentThread() with -1', 'WARNING: FindClassWithLoaderID; is re-throwing Exception' or 'WARNING: FindPublicMethodFlags; is re-throwing Exception' may be reported in the SAP ASE error log, when the PCI memory pool is running out of memory. |
764036 | UPDATE with builtin in the SET clause executes ineffieciently as compared to ASE 12.5. |
765074 | A 2546 error: "Table Corrupt: Extent id < extid > on allocation pg# < pgnum > has objid < objid > , indid < indid > , and used bit on, but reference bit off." may sometimes be reported by DBCC CHECKALLOC following the rollback of a transaction that contains a CREATE INDEX command as well as DMLs to the table within the same transaction, in a database with DDL_IN_TRAN option turned on. |
765348 | New configuration option 'prevent automatic upgrade' will prevent newer SAP ASE versions from making changes that might prevent booting an older version on this installation. New command line argument --upgrade-ok grants permission for the upgrade. |
765621 | In rare circumstances, when "Update statistics" and BCP running in parallel, update Stats may fail with "Error 605: An attempt was made to fetch logical page %d from cache 'default data cache'. Page belongs to database 'brfdb' (32), object ' < Unknown > ' (0), index ' < Unknown > ' (0), partition ' < Unknown > ' (-1) and not to database 'brfdb' (32), object %s, index ' < Unknown > ' (0), partition %s. |
766325 | Under heavy systems with ‘enable functionality group’ is on, a cursor dynamic prepared statement executed by non DBO users under recompilation path may run into 225 or 208 error. |
766387 | Online parallel create index may fail if the SAP ASE configuration value 'max (utility) parallel degree' is not enough. |
766751 | When RepAgent is configured for Multiple Paths Replication and objects bound to different paths are modified within the same transaction, a redundant 'begin transaction' may be generated by RepAgent for some of the replication paths. |
766882 | When the database option 'ddl in tran' is set, RepAgent may get infected with a timeslice error in the module 'ra_invalidate_schema' while replicating DDL commands such as 'CREATE TABLE' and 'ALTER TABLE' in a transaction. |
766956 | The command LOAD DATABASE WITH LISTONLY [=FULL|=VOLUME] produces a misleading error message:"Backup Server: 4.22.1.1: Option LISTONLY is not valid for device < device_name > ." |
767021 | In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #= < pg > , page timestamp= < ts > . Log old timestamp= < ts2 > ." may be reported during recovery when an online utility like ONLINE REORG REBUILD / ONLINE CREATE CLUSTERED INDEX / ONLINE SPLIT PARTITION command was running at the time SAP ASE was shutdown with nowait or was abnormally stopped. |
767295 | When the built-in lct_admin('abort',0, < dbid > ) or lct_admin('abort', < spid > ) is issued on a task that is in the process of being killed and is in log-suspended state, the message "Unable to do cleanup for the killed process; received Msg 3617." may be reported in the SAP ASE error log, resulting in the killed task not freeing all of its resources. |
767390 | There may be a performance difference between pre SAP ASE 15.0 servers and post SAP ASE 15.0 servers due to the evaluation order of multiple subqueries on the same operator. Optcriteria cr767390 was introduced to order the subquery evaluation, when evaluated on the same operator, in the order that they were written in the query. |
767605 | UPDATE STATISTICS when run concurrently with REORG DEFRAG or TRUNCATE TABLE might end up in a state where no progress is made. |
768028 | When a database contains more than 2,147,483,648 logical pages, certain database diagnostic tools will print very large page numbers as negative numbers instead of their proper page ID. |
768097 | The loginfo() built-in when executed with option 'can_free_using_dump_tran' may occasionally return values other than between 0 and 100 %. |
768198 | In rare circumstances, when the number of OAM pages for a table exceeds the value of 32767, ASE may hit a stack overflow error with a stack trace which includes the modules 'pg_allocoam' and 'pg__cond_insertoam' reported in the error log. |
768475 | If a table created in an user database with cross database encryption and decrypt default on the column is dropped from master, the following error message "The decrypt_default for column id 2 was not found in the system catalogs." is raised to the end-user. |
768497 | The message "current process infected with 11 (SIGSEGV)" in the module 'ejrCacheClean' together with a stack trace which includes the modules 'tdsrecv__process_batchparam' and 'sequencer' may be reported in the SAP ASE error log if a Jconnect application inserts values into a numeric column as a language batch in non-BCP mode. |
768596 | A 803 error "Unable to place buffer < > from cache < > holding logical page < > in sdes for object < > - either there is no room in sdes or buffer already in requested slot." may be reported, when online parallel create index with large partition table. |
768780 | REORG DEFRAG leaves the number of deleted rows in systabstats unmodified. |
768853 | The execution of sp_addthreshold immediately after having dropped a segment with sp_dropsegment, will result in the server shutting down if the debug version of SAP ASE is used together with a stack trace which includes the modules 'th__modify_thresh_idx' and 'dbrepair' reported in the error log. |
768880 | In rare circumstances a deadlock may be seen between DUMP DATABASE and DUMP TRANSACTION when these commands are executed on the same database concurrently and the configuration option "enable concurrent dump tran" is set. |
768925 | The upgrade of a database created on a version prior to SAP ASE 15.7 SP100 to a higher version can take a long time to create the system table SYSDAMS if the database is big and it's almost fully allocated. |
768980 | grant dbcc monitor to < user > fails with error 165 in SAP ASE 15.7 ESD2 and later versions with the error message 16 - 'Privilege DBCC monitor may not be GRANTed or REVOKEd.' |
769075 | Then update statistics command may take additional time when a cntrl-C interrupt or a KILL spid is used. With this change, Adaptive Server will check more frequently for the termination request and gracefully exit the command in a more timely manner. |
769243 | When the loginfo() built-in is executed with any of the following options, “oldest_active_transaction_pct”, “stp_span_pct” or “can_free_using_dump_tran”, it may return an incorrect value of 0. |
769721 | On the HPIA platform, online CREATE INDEX may fail with a 2601 "Attempt to insert duplicate key row in object 'syspartitions' with unique index 'csyspartitions'" error. |
769727 | Error 706 (Process < n > tried to remove PROC_HDR < addr > that it does not hold in Pss.) and 913 (Could not find row in sysdatabases with database id < n > .) may be reported for the following scenarios 1) Predicated Privileges are not being automatically re-normalized after being loaded from a dump. 2) When a predicated privilege fails to re-compile, the exception handling incorrectly cleans up leading to 706 errors. |
769868 | SAP ASE might report an infected with 11 (SIGSEGV) stacktrace in the function mda_flush_iostats() when the SAP ASE configuration option "enable monitoring" is set to 1. |
769886 | A 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization" or a 208 error, " < object name > not found. Specify onwer.objectname or use sp_help..." may be reported when "streamlined dynamic SQL" configuration parameter is ON, a dynamic SQL prepared statement is re-executed and due to some changes in the underlying referenced objects the statement had to be recompiled. |
770052 | using the sp_chgattribute tab_name, "plldegree", degree_no function will set the parallel degree but subsequently when either update statistics is run, or if housekeeper flushes the table level stats, then the systabstats.plldegree for the respective table will be reset to 0. This will disable consideration of parallelism for that table until the sp_chgattribute is once again executed. |
770255 | In rare circumstances, a 605 error "An attempt was made to fetch logical page ' < pageno > ' from cache 'log cache'. Page belongs to database ' < dbname > ', object ' < Unknown > ' (0), index ' < Unknown > ' (0), partition ' < Unknown > ' (-1) and not to database ' < dbname > ' ( < dbid > ), object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8)" together with a stack trace which includes the modules 'getpage_with_validation', 'num_logpages' and 'loginfo3_xactspanbyspid' may be reported in the error log when the loginfo() built-in is executed with the 'xactspanbyspid' option. |
770260 | In rare circumstances, the message "current process infected with 11" in the module 'LeAlfaStatsCollector::LeWriteThStatsToCollector' may be reported in the error log when a query is executed inside a stored procedure (or the statement was cached) and the plan is executed in parallel while some monitoring options are altered. |
770403 | Dump database with verify=read_after_write and verify=crc but with no compression specified may produce an unexpected verification message such as "Backup Server: 4.190.1.1: Database repro_db: Verification reported x errors.". |
770418 | Added a new rule to use serial optimizer when all main query blocks don't have partitioned table and all non-partitioned tables set their "plldegree" attribute to < =1. The rule condition includes the plldegree setting for the table's useful indexes (if any). "plldegree" can be set for a table using the following command: sp_chgattribute t1, "plldegree", 4 The rule is only active when the cmdline traceflag 16993 is on. Also under the same traceflag, optimizer will not use a table's plldegree setting as its useful index's plldegree when the index doesn't have the attribute set. |
770422 | The error "Page Verification Error: Page mismatch. Page < pageno > contains < swapped pageno > in page header." may be reported in the SAP backup server error log if the database contains untranslated pages that were originally loaded from a dump taken in an architecture with different endianness. |
770468 | A 12531 error "The table SYSDAMS could not be opened in database ..." will be unnecessarily reported when loading a database dump taken from a pre-15.7 version into an SAP ASE version equal or greater than 15.7, although this error will not cause the load of the database dump to fail. |
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. |
770992 | 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 | 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. |
771055 | On AIX, while generating stack trace, SIGSEGV (Signal 11) or timeslice error is observed in search_tbt() or strncpy(). |
771090 | 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. |
771170 | A SAP ASE CE 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 |
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. |
771230 | Reorg defrag process, if killed in rare cases could leave the state of object specifying an utility is active. |
771301 | The error "Volume validation error: attempt to open ' < file name > ' returned Too many open files" can be raised by the backup server when trying to dump or load on SOLARIS, HP and AIX after running for some time because a socket is being left opened every time a connection is established. |
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. |
772670 | 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 can occur. This will not affect update statistics or the serial create index command. |
Read more...
Environment
- 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
CR, ASE 15.7 SP131, ASE 15.7, SP131, Adaptive, Server, Enterprise, Fix, Patch, Error, 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.