/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in 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 |
|---|---|
| 671152 | KBA 2280641 : In rare circumstances, a 3475 error, "There is no space available in SYSLOGS to log a record for which space has been reserved in database ' < name > '" may be reported for a mixed log and data database that has a user defined threshold defined for the log segment. |
| 684701 | The "for xml" clause is being stripped off from the text which is saved in syscomments. This causes the procedure output to change unexpectedly (output is no longer in XML format) following upgrade. |
| 706483 | A NULL value may be inserted into TEXT/IMAGE/UNITEXT columns that do not allow NULL values during the execution of an INSERT-SELECT command if the attribute "dealloc_first_txtpg" is not set to 1 in the source table. |
| 713340 | KBA 2210395 Static configuration parameters are lost after running alter thread pool to modify thread count. |
| 729246 | A new option WITH COPYONLY= < target_file_path > is added to LOAD DATABASE and LOAD TRANSACTION commands. It allows to extract a DATABASE DUMP or a TRANSACTION DUMP from a storage system and copy it into a local directory. |
| 730962 | When running installhasvss, an error message indicating that it has 'failed to locate the sybsecuritydb' is hit. |
| 731023 | KBA 2063257 - Relax restriction when we raise the message 3193 in relation to ALTER DATABASE OFF at LOAD TRANSACTION time, by delaying the generation of holes in a load sequence to ONLINE DATABASE time. |
| 732131 | A 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #= < > , object id = < > , page timestamp= < > . Log old timestamp= < > . Log record marker = ( < > ).", may be reported during LOAD TRANSACTION if either the built-in reserve_identity() or the dbcc set_identity_burn_max() command have been executed when the transaction dump was taken. |
| 736079 | A cheaper plan containing the merge_union_all operator may be skipped in favor of a more expensive plan using a sort operator on top of an append_union_all. |
| 737093 | When a table is partitioned based on a list of values including the NULL value, the NULL value may be ignored when compared to NULL, leading to wrong results. |
| 747441 | Signal 11 on crp_var when database in 'dbo use only' |
| 749560 | When the server level option 'abstract plan sharing' is enabled but the session level option is disabled by 'set plan shared off', the shared AP is still loaded. |
| 752523 | Switch ASE_JAVA support from COTS JavaVM towards SAP JVM delivery |
| 756284 | When there are nested subqueries with invariant materialization steps in each respective subquery, it is possible that a signal 11 can occur. |
| 759590 | When SAP ASE is upgraded and the higher version server writes a new configuration file after upgrade is complete, then under some circumstances that configuration file may contain entries that were unexpectedly changed from what the older version server originally configured. |
| 760979 | On AIX platform, in rare circumstances,buffer unlatch raises 871 error OR CREATE INDEX may fail with error 1289:"Internal Error in lock manager routine: Invalid lock mode exclusive page, requested by task (family id < > , spid < > ) conflicts with existing family request mode exclusive page belonging to task (family id < > , spid < > ). |
| 762610 | A segmentation fault may occur when a query is executed on the monSpinlockActivity table when the last owner of a spinlock was a native thread and the ASE server has failed over to the standby server. |
| 763497 | In rare cases, the backup server could hang waiting for input on a pipe that is never received. The stack trace of the sybmultbuf process that causes the problem will show the function sys_ipc_io(). |
| 768872 | Systemwide switch (traceflag) 3605 is left active if a fatal error occurs while outputting diagnostic information for an invalid column length error. A stacktrace that includes the function colleen() will be seen in the errorlog followed by SWITCH SERVERWIDE ON 3605 followed by a fatal error. Traceflag 2779 disables the function turns on this switch to output additional diagnostics on the column length error. |
| 770419 | the CR need close. |
| 771528 | The new ODBC driver was updated to use the “optimal” TDS batching feature when ODBC uses parameter sets like this: SQLSetStmtAttrW( stmt, SQL_ATTR_PARAMSET_SIZE, (SQLPOINTER)size, SQL_IS_UINTEGER ); This picks language batch and causes error 16817, "A query plan cannot be generated for DML command executed with homogeneous batch parameters. The batch was aborted.". |
| 773524 | Under rare circumstances, when a transaction rollback fails, the transaction remains open erroneously and allows other concurrent transactions to progress. Eventually this failed transaction becomes the oldest open transaction and prevents the transaction log truncation thus making the database unusable when the log last chance threshold is reached. Additionally if SAP ASE is restarted, the database recovery fails and the database is marked suspect. The new database option "allow db suspect on rollback error" if enabled allows a forceful shutdown of the database and marks the database suspect if a non-recoverable error is hit during a transaction rollback. This provides the ability to the end-user to execute a last DUMP TRAN allowing to archive all the transactions up to the point the rollback failed. |
| 776004 | KBA 2107233 - Adding multiple partitions with later table using separate statements in a single batch can raise Msg 712 insufficient heap memory. |
| 777883 | In ASE Cluster Edition, coordinator shutdown may cause the new coordinator to initiate unnecessary shutdown. |
| 778001 | ddlgen does not generate 'allow page signing' database option in the output. |
| 778455 | When a user tries to bind cache to tempdb, error was raised from the sp_bindcache stored proc. Now its replaced with 'print msg'. |
| 778531 | Add additional diagnostics for Global Allocation MAP (GAM) status issues. |
| 779137 | The message "Current process infected with signal 11" in the module 'proc_decr_pbsharecnt' followed by a stack trace that includes the module 'showCachedPlanInXml' and/or 'show_cached_plan_in_xml' may be reported in the error log leading to a crash of the database server. |
| 780228 | When the stored procedure sp_hadr_admin 'config_bs' receives a NULL second parameter it inserts one entry for the backup server listener IP address in the hosts.allow file. This a new feature to insert one line for each of the host names aliases for the listener IP address instead of the IP address. |
| 780373 | During a batch INSERT in the database server, Data Load processes on BW systems frequently fail with the error 30292, "Attempting to read past stream EOM" |
| 780611 | Under rare conditions, the message, "Current process infected with signal 11 (SIGSEGV)" or a timeslice error in the function metrics_GetForMDATable(), may be reported in the SAP ASE error log when the monCachedStatement table is queried in a heavy-loaded environment. |
| 780909 | The message "Current process infected with signal 11" in the module 'kbfusage' together with a stack trace which includes the modules 'ubfprop' and 'mda_exec' may be reported in the error log during a query on the monMemoryUsage table. |
| 781067 | Enhancement to allow the Backup Server be identified by another remote Backup Server by its listening address instead of using the default one defined by the routine tables in the operating system. This option is enabled by default. To disable this feature execute "sp_configure 'bind backupserver address', 0". |
| 781585 | KBA 2146288 - A Signal 11 may occur in ubffreef when ASE runs out of locks and error 1204 is reported. |
| 781684 | In rare circumstance, a memory dump might fail with an "Error writing memory segment" error when the option "memory dump compression level" is set as a value greater than 1. |
| 782359 | Query from proxy LOB column mapped to IQ may be slow. |
| 782426 | KBA 2184795. The SKIP_ALLOC, INSTANCE and TYPE clause for DISK INIT only accepts "true" or "false" in lower case. This is inconsistent with other clauses such as DSYNC and DIRECTIO, which accept any case. |
| 783010 | In rare cases, a 14108 error, "Could not find partition descriptor for objid < > , indid < > , ptnid < > in dbid < > ." may be reported in the SAP ASE error log when an ALTER TABLE command is rolled back following some error. |
| 783192 | When textptr() and ORDER BY are both used in the same SELECT statement, textptr() may return bad text pointers if the target TEXT/IMAGE/UNITEXT column has NULL values. |
| 783601 | Killing a thread executing UPDATE STATISTICS on a column with highly-duplicate values causes a signal 11 in stat_sargden_accumulate(). |
| 784616 | KBA 2174314 : If compatibility mode is enabled and a complex query needs a sort operation (such as ORDER BY clause) and the query creates many worktables, Adaptive Server may generate a stack trace including a function j_joinsortavert(). |
| 784620 | In rare circumstance, 701 error, "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache.", may be reported when running CREATE INDEX/ALTER TABLE/REORG REBUILD commands on table with thousands of data partitions. |
| 784686 | In SAP ASE Cluster Edition, in certain cases, a 1204 error, 'ASE has run out of LOCKS' may be reported. |
| 785218 | Error 622 could be seen followed by error 3702 at the time of drop of that object if compatibility mode is ON and a query with LIKE clause is run. |
| 785554 | Under UTF8 sort order 99, if a composite index contains a leading NULL VARCHAR field, REORG REINDEX may not be able to rebuild the index. |
| 785672 | SAP ASE spids might hang indefinitely waiting on the MASS_DESTROY bit to be reset when tempdb is being used. |
| 785680 | A 2805 error, "Bad pointer < address > encountered while remapping stored procedure < proc_name > . Must re-create or replace procedure", may be raised during recompilation if 'plan load' & 'literal autoparam' are enabled. |
| 785831 | Explicit conversion errors, "Explicit conversion from datatype 'IMAGE_LOCATOR' to 'VARCHAR' is not allowed", may be reported when inserting IMAGE data into a table with an IMAGE field using dynamic prepare and auditing is enabled. |
| 785971 | sp_help reports the object status value of "keep first text page" on a table that does not have LOB columns defined. |
| 786126 | In rare cases, when doing parallel CREATE INDEX in tempdb or in a low durability database, error 3478 (the timestamp on the page is older than the log new timestamp in the log record) may be reported during rollback of the transaction while an OAMCREATE log record is rolled back. Alternatively error 1142 (invalid OAM page) may be reported during the rollback of a parallel REORG REBUILD. |
| 786244 | If network disconnect occurs before ASE has spawned a task for a network connection, say in case of a port siffer which immediately disconnects after connecting, hung spid may occur and a message of the following type may be seen in the error log 00:0008:00000:00000:2015/06/29 06:15:43.56 kernel ncheck_quit: no pid associated with fd 20, vsn = 4, socket type = 2 |
| 786256 | KBA 2186419 - Dead spids left with in ASE with a status of "Maintenance Token" in sp_who |
| 786540 | When auditing is enabled, the spurious message, "kernel ksnetctlrSanity: vsn 6622 psn 165 kpid 1503595925 flags 0xc0000020, events 0x8", may be reported in the SAP ASE error log on the Solaris platform. |
| 786588 | An 8201 error, "Mismatch found between the name and id descriptor hash table for table...", accompanied by a stack trace that includes the modules 'des__clean' and 'des__scavenge' may be reported in the error log in some high concurrency scenarios. |
| 786637 | CT-Lib ct_results() returned CS_CMD_FAIL for errors previously ignored, causing compatibility issues in JSTemplate due to SAP OCS CR 770865. |
| 786643 | In rare circumstances, ASE Cluster Edition server may hit a SEGV when it runs out of CIPC messages. |
| 786724 | KBA 2201130:Values of IOTimes in MDA table monIOQueue and monDeviceIO do not match |
| 786727 | In rare cases, when doing parallel REORG REBUILD in tempdb or in a low durability database, error 3478 (the timestamp on the page is older than the log new timestamp in the log record) may be reported during rollback of the transaction while an ALLOC log record is rolled back. |
| 786879 | Revoking 'sa_role' and 'sso_role' from 'sa' user account may stall the SAP ASE server when no other user accounts have system defined roles such as sa_role and sso_role. KBA 2289887 - How to revoke sso_role from sa login - SAP ASE |
| 786895 | If a stored procedure is accessing an object that is created by a different user, SAP ASE cluster edition may report the error "Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object ' < object name > '.". The stored procedure will still be created. |
| 787019 | The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'qualpage' together with a stack trace which includes the modules 'rep_agent_config' and 'attrib_getrow' may be reported in the SAP ASE error log when executing the built-in rep_agent_config() on an offline database after having loaded a 12.5.4 database dump into it. |
| 787054 | The message "Current process infected with signal 11" in the module 'PartNodeInfo::collocatedSite' followed by a stack trace that involves the module 'Pop < ParallelCost, ParallelProps > ::popIsCollocated' may be reported in the error log when running a complex query with proxy tables. |
| 787084 | When Adaptive Server is running the query processor in compatibility mode, queries with tables having predicated privileges will not work. |
| 787555 | In the context of synchronous replication if a transaction is aborted during forced deactivation while a task is idle, the task will be allowed to commit the aborted transaction in case the primary is reactivated and the task was not marked for termination during deactivation. |
| 787673 | Please help review. |
| 787699 | Dbcc checktable will report error 7928 after creating the index in 'ONLINE' mode on empty table if concurrent DML queries cause addition of new index level. Index %.*s is not consistent; found %s leaf rows but %s data rows. Drop and recreate the index. |
| 787900 | An incorrect path provided for the SSL Certificate file does not lead to an error being reported. |
| 787934 | The recovery fault isolation feature is not enabled during the execution of a LOAD TRANSACTION in the database server. This feature could exclude a blocking error from the loaded backup. |
| 788080 | On the IBM AIX platform, xp_cmdshell executions may fail with the error message: "Could not load library < $SYBASE > / < $SYBASE_ASE > /lib/sybsyesp.so" |
| 788353 | KBA 2208560: XPServer behaviour change for running shell scripts from SP135 onwards |
| 788474 | KBA 2211717: Under some rare condition, if columns in a table have more than one constraints (not necessary in the same column), it can cause invalid rows to be inserted. |
| 788552 | In rare circumstances, index creation in 'ONLINE' mode will encounter singal 11, when it is executed on an APL table with several concurrent DML queries. |
| 788562 | Parallel queries may terminate early without returning all the required rows. |
| 788593 | In rare circumstances, Adaptive Server may hit a timeslice error while holding a spinlock when a query that references the system table systransactions is executed. This error will cause Adaptive Server to shutdown implicitly. |
| 788691 | KBA 2209489 - ALTER OWNER does not affect defaults created with 'enable inline default sharing' turned on |
| 788702 | The 3475 message, "There is no space available in SYSLOGS to log a record for which space has been reserved in database 'tempdb'", may be reported in the SAP ASE error log for database tempdb, when a log fragment was previously dropped from tempdb using sp_dropsegment. |
| 788769 | The message "current process infected with 11" in the module ‘mda__populate_RepScannersTable’ together with a stack trace which includes the modules ‘mda_exec’ and ‘mda_populate_monRepScanners’ may be reported in the error log when a query on the master..monRepScanners table is run and while the Replication Agent is shut down concurrently. |
| 788952 | In rare circumstance, dbcc shrinkdb_setup() may not be able to correct text back link for text/image/unitext columns of tables that are set to be replicated. |
| 789109 | The error 'uncompress(): Input data corrupted' could be raised when loading a compressed dump created either using the Backup Server API "compress::" or the command option WITH COMPRESSION [= 1..9]. |
| 789186 | New traceflag 7168 is provided for restricted use to make builtin textptr() return NULL for NULL value of text/image/unitext columns. |
| 789251 | KBA 2218075 - In rare circumstances unexpected results could be returned when a query involving a LIKE clause is executed inside a stored procedure run WITH UPGRADE option (or which required to be upgraded internally from source text) and the LIKE clause references input parameters defined in the stored procedure. |
| 789359 | KBA 2214120 - Engine number incorrect reported for user defined thread pools in threaded kernel |
| 789377 | In rare circumstances, 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 during the execution of an UPDATE or DELETE command on a table after an unsuccessful online CREATE INDEX on the table. Alternatively a 3474 or 6902 error may also be reported during boot time recovery or when loading a transaction dump that includes the aborted online CREATE INDEX and other concurrent DML activity. |
| 789426 | When IMDB is used with multiple cachelets and the database size is altered, then SAP ASE may report error 899, "The page < page > requested for in-memory < objinfo > was not found in in-memory storage cache ' < name > ' (id < n > ). Please contact SAP Technical Support." |
| 789613 | In some situations ddlgen generates incorrect permission ddls in the output for a stored procedure where the grantee information is not generated. |
| 789670 | KBA 2205765 - sp_dbcc_run_summaryreport cannot show an SUID greater than 99999 |
| 789675 | The p_drv_bcpmetadata stored procedure is enhanced in order to improve the performance of jConnect ENABLE_BULK_LOAD. |
| 789944 | Under some rare situations, updating a table through a IOT (instead of trigger) could result in error 16863. |
| 789967 | In rare circumstances, a 12308 error, "Invalid row id (Row < > , Page < > ) encountered in the table 'T' in database 'D'" or a 614 error "Adaptive Server accessed a row that has an illegal length of < n > while in data base 'X' ..." may be reported by a REORG REBUILD index or a DML following REORG DEFRAG on a table. |
| 790223 | The str_replace() function returns a much wider result when the pattern string is a function or variable rather than a quoted string literal. |
| 790239 | ASE might report boot failures with error such as "Incorrect Java Virtual Machine library version" in errorlog file on Windows NT platforms (nt386 / winx64) if the ASE PCI Bridge configuration parameter “pci memory size” is set as a value lower than 512 reserving 1 MBytes memory. |
| 790265 | The message, "Current process infected with 11 (SIGSEGV)", in the module 'ds_destroy_table' together with a stack trace which includes the modules 'exec_dbcc' and 'checkalloc' may be reported in the SAP ASE error log when DBCC CHECKALLOC is interrupted by a Control-C. |
| 790394 | In rare circumstances, the message "Current process infected with signal 11 (SIGSEGV)" in the module 'dbt_unkeep' together with a stack trace which includes the module 'close_range' may be reported in the SAP ASE error log when a query uses a worktable. |
| 790397 | sybcluster may hit 'Connection refused' error when creating server if set loopback address to hostname in /etc/hosts |
| 790406 | A 14108 error, "Could not find partition descriptor for objid < > , indid 255, ptnid < > in dbid < > .", together with a stack trace which includes the modules ‘get_txtpage’ and 'inserttext’ may be reported in the SAP ASE error log during the execution of an UPDATE command while attempting to move a LOB datum from in-row to off-row. |
| 790414 | In rare circumstances, the message "Current process infected with signal 7 (SIGBUS)" in the module 'ldx__load_type' may be reported in the error log when executing LOAD TRANSACTION. |
| 790436 | Under some rare conditions, the message, "Current process infected with signal 11 (SIGSEGV)" in the module memset(), followed by a stack trace that includes the modules comnb_i4tonum() and set_cast_truncate() may be reported in the error log when converting from int to numeric. |
| 790456 | Under rare circumstances, an 871 error "Process < n > is trying to release a latch on buffer < 0x > (dbid: < n > , pageno: < n > ) without holding a latch on the buffer" may be reported in the SAP ASE error log by reorg defrag when used with 'skip_compact_extents' option and a lock promotion to table level has occurred while reorg was executed. |
| 790463 | Procedure cache may get full with multiple plan copies of single stored procedure involving DDL inside a transaction. |
| 790582 | The 4325 error, "The specified recovery date is not between the start and end date.", may be reported when executing the LOAD TRAN WITH UNTIL_TIME generated by LOAD DATABASE WITH LISTONLY,UNTIL_TIME, if the selected time is between the time of the last transaction in the dump and the moment the dump transaction is executed. |
| 790631 | KBA: 2226027 Online Reorg rebuild is blocked/deadlocked with an OPEN CURSOR when traceflag 2792 is enabled |
| 790654 | The %SYBASE_ASE%\bin\optase.vbs script reports an invalid 'exit' statement if the specified memory is lower than the required size. |
| 790672 | In rare scenarios where the monOpenObjectActivity table is used and a #temp table is being dropped, the 3702 error, "Cannot drop or replace the < obj_name > because it is currently in use" may be reported and the temp table could not be dropped. |
| 790682 | In rare circumstances, user tasks may be suspended when attempting to log information in a mixed-log and data database, although there are no visible space issues for this database when executing either sp_helpdb or sp_spaceused for syslogs. |
| 790741 | DDLGen generates output with wrong @@error check |
| 790742 | SAP Replication Agent may fail with error 9289 state 83 when replicating the execution of a stored procedure whose parameter values include large values and null values, or when replicating a SQL statement with a large WHERE clause. |
| 790834 | On Solution Manager systems, database server processes that completed executing UPDATE INDEX STATISTICS may remain active and stall connections. |
| 790983 | A 3475 error, "There is no space available in SYSLOGS to log a record for which space has been reserved in database ' < name > ' ( < id > )", may be reported when the difference between the last change threshold and a user defined threshold for the log segment is less than 128 pages. |
| 791028 | In ASE Cluster Edition, when an instance is joining a cluster, 'Warning clock comparison' message may be reported in the error log. |
| 791146 | If a stored procedure has a 'select into temp table' and a session running the stored procedure is chosen to be the deadlock victim, error 267, "Object < obj_name > cannot be found", will be raised after error 1205, "Your server command (family id, process id) encountered a deadlock situation. Please re-run your command". |
| 791207 | A 702 error, "Memory request for < > bytes exceeds the size of single page of < > bytes.", together with a stack trace which includes the modules 'writetext’ and 'memalloc’ may be reported in the SAP ASE error log if an in-row LOB column is updated using SAP OCS APIs. |
| 791364 | Under certain situations, for queries involving huge number of OR predicates, a kill spid may not be able to kill the spid during histogram processing in the optimizer. |
| 791390 | The message, "Current process infected with signal 11 (SIGSEGV)" in the module 'xpd_swap_msb_i2' together with a stack trace which includes the modules 'lddb__unscr_phys_page' and 'lddb_unscramble' may be reported in the SAP ASE error log during the execution of a cross-platform DATABASE LOAD command. |
| 791669 | In rare circumstances, a process may hang in the module ‘cm_writelogdes_upto_sequence’ while concurrent sessions are executing DML commands. In the call stack of the hanging process the modules ‘xact_commit’ and ‘bufwritedes_log’ will also be reported. |
| 791758 | Server may reach a hang state after running of "dump database" command several times. |
| 791767 | A 2620 error, "The offset of the row number at offset < > does not match the entry in the offset table of the following page: Page pointer = < > , pageno = < > , status = < > , ptnid = < > , indexid = < > , level = < > , pnextrno = < > .", may be reported when loading a transaction dump from either SAP ASE 15.7 SP60, or 15.7 SP110 version, into SAP ASE 16.0 GA version. |
| 791857 | A table may contain two indexes with same name, if there are two CREATE INDEX commands with same name on same table running at same time. |
| 791901 | Sometimes error 7794, "You cannot scan table < table_name > at isolation level 0 because another process is running a utility command that is incompatible with level 0 scans. Please retry later", may be reported with concurrent SELECTs (level 0 scans) and UPDATE STATISTICS on large tables. |
| 792089 | A DUMP or LOAD from or to database devices created on veritas file system on HP could hang if the backup server is started using the trace flag -D1024 to enable posix async I/O. |
| 792164 | Post commit shrink operations and the housekeeper garbage collection may become deadlocked with each other. Post commit shrink may also hit a 2630 error if it is trying to shrink a page with BT_SHRINK set. A 2630 error is "In database ' < name > ', page < a > is linked backward to page < b > , but that page is linked forward to page < c > . Please report this internal error to SAP Technical Support." |
| 792195 | During an UPGRADE or a DUMP and LOAD from different versions of the SAP ASE server, execution of extended system stored procedures raises an incorrect 2851 error. |
| 792211 | In rare circumstances, where the database server is configured to use character set GB18030 and after data is inserted into a TEXT column which is not defined to be compressed, then a DBCC CHECKTABLE may report a 7951 error, "Data size mismatch while checking a text value. The first page for this value is < page id > , partition ID < partition id > . < value > characters were found; however, the expected length is < value > characters". |
| 792229 | KBA 2243588. During the upgrade to 15.7 SP135 or later the new column user_status is added to sysusers. In rare cases this new column does not get the expect value 0. |
| 792339 | A query on the monOpenObjectActivity table in which the DBID, ObjectID and IndexID columns are fully specified in the WHERE cause may cause a 3702 error in another connection if that connection attempts to drop the same table that the query on the monOpenObjectActivity table is analyzing at the same time. |
| 792471 | When using resource governor lock_count limit in ASE Cluster Edition and the threshold is reached, process might be infected with SIGSEGV while trying to release locks and the cluster instance will shutdown. |
| 792483 | In rare case, if DOL table with datapages lockschema has unique index, concurrent DML may hit index corruption with error 12313, "Insert into page id < page # > of index id < index # > of table ' < table name > ' (id = < id # > ) in database ' < db name > ' tried to replace undeleted RID ( < > , < > ) at slot < slot # > and ridposn < # > . Try dropping and recreating the index". |
| 792553 | In rare circumstances in ASE Cluster Edition, the message "Current process infected with signal 11" in the module 'lock_getvalue' may be reported in the error log when the instance boots. |
| 793135 | In some circumstances, the database server may run out of procedure cache during histogram processing when the query has a large IN-list containing out-of-domain values. |
| 793168 | In rare circumstances, an instance joining the cluster may hang after other instance hitting error 3653. |
| 793243 | When a dump sequence contains a transaction dump followed by an unlogged operation, a cumulative dump, and another transaction dump, the command LOAD WITH LISTONLY=LOAD_SQL,UNTIL_TIME= < time between last transaction dump and cumulative dump > will generate an invalid load sequence. |
| 793367 | Certificate Authority root certificates provided as examples in database server release areas have expired. |
| 793518 | The message, "Current process infected with signal 11" in the module 'dam_cache', together with a stack trace which includes the modules 'db_fill' and 'dam_enable' may be reported in the error log when loading a database dump into a database that has an invalid system table SYSDAMS and the database option 'allow incremental dump' is enabled. |
| 793627 | KBA 2258264 : During an SAP ASE upgrade from 15.7 SP122 version to SP132 or SP135 with SSL enabled, the database response time increase resulting in poor performance. |
| 793666 | A 8006 error followed by a stack trace that includes the module 'as_send_db_map' may be reported in the error log, followed by the message "Device < master-device > : < # > is not a legal virtual block number.", while trying to dump the master database, if the system table SYSDEVICES contains some other device that has a ‘vdevno’ value of 0. |
| 793766 | The message, "ulvspinlock: spinlock being released improperly" or "ulpspinlock: spinlock order violation" may be reported in the error log on Solaris M-Series machines when the diagserver binary is used. |
| 793902 | In some cases, the database server might report error 12034, "Collection of monitoring data for table < table_name > failed due to insufficient memory. Retry when there is less load, or fewer users, on the server. < nn > rows were not returned because < xx > bytes of memory could not be allocated" and error 8601, "Process < spid1 > tried to keep the PSS for process < spid2 > when it already had the PSS for process < spid3 > kept", and the affected process would be terminated. |
| 793910 | Provide the ability to capture application workload with the Workload Analyzer feature. Note that analysis and replay of the workload is only supported by using the ASE Cockpit component in ASE 16.0 SP02 or later releases. |
| 793950 | The message "current process infected with signal 11" in the module 'GenCondensedText::isInTree' followed by a stack trace that includes the modules 'GenCondensedText::getAghead' and 'GenCondensedText::generateAggregate' may be reported in the error log when running show_condensed_text() built-in function. |
| 793963 | Dataserver spids might hang indefinitely waiting on the MASS_DESTROY bit to be reset when tempdbs are used. |
| 794010 | KBA 2304324 : When imdb devices are configured, they will cause error 12055 when querying on monDeviceSpaceUsage . |
| 794082 | Rolling back transactions within nested triggers can cause unnecessary recompilations of the parent trigger. |
| 794128 | Wait Event 215 (waiting on run queue after sleep) is not reported in the monProcessWaits table |
| 794556 | Executing multiple queries on the monMemoryUsage table may result in reduction in the amount of free memory available in the database server's Global Fragment Pool. This may cause further queries on the monMemoryUsage table or other commands in the database server to fail. |
| 794568 | In a replication environment with DDL enabled, if a GRANT with predicated privilege command is larger than 255 characters, it will be truncated mistakenly, whereby the truncated command will be replicated to the SAP Replication Server, which will cause the replication stream to stop because the truncated GRANT command cannot be recognized by the target database server. |
| 794666 | The monDeviceSpaceUsage will leak memory from Global Fragment Pool under some exceptional circumstance. |
| 794764 | Under rare circumstances, the message "current process infected with signal 11" in the module 'CgpGlobal::CgpTransform' followed by a stack trace that include the modules 'CgpGlobal::CgpGenerate' and 'Optimize' may be reported in the error log if a batch with IF EXISTS condition is executed. |
| 794920 | Under Windows NT, ASE may not be able to create new native threads to execute UDF or ADT constructs with JavaVM as soon as the amount of these requests exceeds the value of the 'pci_xopt_maxthreads' option of sp_pciconfig whose default value is 1056. |
| 794963 | A 3475 error, "There is no space available in SYSLOGS to log a record for which space has been reserved in database < dbid > (id < id_no > )", may be reported after a database dump with a log hole is loaded into a database with a data hole instead. |
| 794972 | In some rare cases, update statistics command run along with reorg defrag or other online utility could end up in an undetected deadlock. |
| 794981 | The message "current process infected with 11" in the module ’kbfusage’ together with a stack trace which includes the modules ‘mda_populate_monMemoryUsage’ and ‘mda__MemUsg_one_FragmentPool’ may be reported in the SAP ASE error log while executing a query on the master..monMemoryUsage table. Alternatively a timeslice error in the same module ’kbfusage’ may be reported. |
| 795006 | Under rare circumstances, a LOAD CUMULATIVE or LOAD TRANSACTION command might hang when the database in the dump has some hole and the target database does not. The stack trace of the hang process will show the modules 'rec__reconcile_dmap', 'crdb_update_sysusages', and 'buf_get_latch'. |
| 795071 | When an ALTER DATABASE OFF command is executed on a database that has been created with asynchronous initialization, a 695 error, "An attempt was made to read logical page < > for database < > ( < > )), object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8) from disk. Wrong logical page < > ' was brought into cache 'default data cache'. If pages are being signed, this may indicate a signature check failure." in the module 'getpage__noscan' together with a stack trace which includes the modules 'altdb_shrink' and 'altdb__move_extents' may be reported in the database server error log. |
| 795239 | In rare circumstances, the server may hit a timeslice error in the modeule des_checkpoint_flush_sysstats(). |
| 795278 | In rare cases, some extents may not be deallocated when dropping a table or index if an extent is part of the seven first extents in an allocation page and only the first page is allocated in this extent. The execution of DBCC CHECKALLOC may report a 2540 error, however no corruption or data loss is associated with this error. |
| 795382 | Spurious "invalid column length" errors may be reported by DBCC CHECKTABLE on encrypted columns and when running sp_post_xpload. |
| 795702 | KBA 2281187. Signal 11 or signal 10 in routine memtextlen(), then procedure cache memory pool is corrupted with infected with signal in mem_pageallocate(). If a related stored procedure has xml parameter (@var_xml text) and it has statement using XML builtin function XMLTABLE which uses parameter @var_xml, then please drop and recreate the procedure to use 'with recompile' option to avoid using cached query plan for the procedure. |
| 795780 | In rare circumstances, a 605 error "An attempt was made to fetch logical page < > from cache 'default data cache'. Page belongs to database < > , object < > , index < > , partition < > and not to database < > , object < > , index < > , partition < > ." may be reported in the SAP ASE error log during the execution of an online reorg rebuild command on a table whose descriptor is bound to the metadata objects cache. |
| 795809 | During the execution of CREATE or ALTER DATABASE, if SAP ASE fails to allocate space for the system table SYSDAMS while the option 'allow incremental dumps' is disabled, SAP ASE is incorrectly aborting the command after printing the warning message "The allocation of extents for sysdams in database ' < name > ' failed". The command should fail only if the option 'allow incremental dumps' is enabled. |
| 795886 | KBA 2312920 - In rare circumstances, a timeslice error in the module 'bt__lockprevpg' together with a stack trace which includes the modules 'bt__pgdealloc' and 'hkgc_garbagecollect' may be reported in the SAP ASE error log while a heavy activity of concurrent DML commands on Data Only Locked tables is taking place that requires index pages to be shrunk. |
| 796038 | The overhead rate might become 100% at the beginning of a workload capture. |
| 796565 | KBA 2290005: The embedded HTTP server for ASE Webservices allows older ciphers and protocols that are now considered weak, this CR is created to update the HTTP server for ASE Webservices use the latest ciphers and protocols. |
| 796657 | ODBC : 'sp_drv_getcomment' was causing slowdown because of table scan on syscomments table. |
| 796735 | In rare circumstances, DUMP TRANSACTION may hang in the module ‘cm__waitfor_io’ while heavy activity of concurrent DML commands on Data Only Locked tables is taking place that requires index pages to be shrunk. This will prevent the log from being archived. |
| 796916 | KBA 2294241: SAP ASE might encounter an infected with a signal 11 (SIGSEGV) in the function mda__traverse_lock_bucket when accessing the monLocks table. The stacktrace will be reported in the SAP ASE errorlog. |
| 796980 | KBA 2297748 : Under rare circumstances, a 6902 error "Page timestamp value falls between the old and new timestamps from log. Page #=3, object id = 1, page timestamp= < ts > . Log: old timestamp= < ts2 > , new timestamp= < ts3 > . Log record marker..." may be reported in the SAP ASE error log for commands whose changes are mistakenly logged in a different database. Alternatively a 614 error "Adaptive Server accessed a row that has an illegal length of 0 while in data base ...", followed by a 3478 error "During undo the page timestamp value is less than new timestamp from log. Page #=22, object id = 2, page timestamp= < ts > . Log new timestamp= < ts > . Log record marker..." may be reported. |
| 797119 | The stored procedure execution may lead to signal 11 when the stored procedure is created in same transaction for a database with 'ddl in tran' option set. Alternatively other system errors related to memory manager may be observed. |
| 797184 | Post commit shrink feature is disabled by default. To enable this feature, when instructed, bootstrap ASE with trace flag 3991, or execute on a live system the command ‘set switch serverwide on 3991 with override’. |
| 797492 | An 814 error, “Keep count of buffer ' < > ' in cache ‘ < > ' holding logical page ‘ < > ’ in database ' < > ' has become negative” may be reported in the SAP ASE error log when an INSERT command is executed on a Data Only Locked Table. |
| 797534 | Under rare circumstances the error "A01: SYBMULTBUF ERROR: Failed to write to copy device in" may be printed in the ASE backup server error log when a database dump is loaded using the backup sever API. |
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 SP137
- 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
"Change Request", Fix, Patch, Error, Bug, EBF, SP , 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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)