/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 |
|---|---|
| 671238 | The message "current process infected with 11" in the module 'proc_find_subscribable' together with a stack trace which includes the modules 'lt_sqlrep_exec_polic' and 's_mustrecompile' may be reported in the error log when a stored procedure is marked for replication and ASE is checking if the stored procedure needs recompilation. |
| 686341 | Recovery may fail with an 8201 error when the configuration parameter "per object statistics active" is enabled. |
| 697751 | For an LOB column which is defined both in-row and LOB compressed, if the column is marked as replicated, when replicating the LOB data from this LOB column, the data selected from the target table may be corrupt. |
| 700640 | In Threaded kernel mode, if an ASE task which is doing remote I/O is killed more than once, a SIGSEGV followed by a stack trace that includes the module np__conn_doconnect() may occur and the dataserver then crashes. |
| 700652 | In rare circumstances, a signal 11 may be reported in the errorlog with a stack trace involving the sort module if a reformatting query plan is used. |
| 701065 | In rare circumstances, a 2601 error, "Attempt to insert duplicate key row in object 'syspartitions' with unique index 'ncsyspartitions'", may be reported when creating or partitioning a table, some time after the creation of a table within the database was recovered (either after an impolite shutdown, or by LOAD DATABASE or LOAD TRAN). |
| 703285 | ASE logs the message "Expected object passed to utGetOsId is not of type thread" and "Expected object passed to utGetThid is not of type thread" repeatedly. |
| 703437 | ASE reports message "kshpnetctlrWaitForCompletion : received error 8 for psn ..." when a connection gets killed abruptly. |
| 704724 | Remote Backup Server name is now allowed to be specified as 'hostname:portnumber'. |
| 705677 | The message, "current process infected with signal 11", together with a stack trace involving the functions stat_mergestats_all(), sort() and cri_ptn_index() may be reported when a parallel CREATE INDEX specifies that 0 histogram steps should be used, effectively disabling histogram creation, and multi-attribute density creation. |
| 705733 | In some situations, a signal 11 may occur in lock__get_heldlocknum if a deadlock or lock timeout event happens. |
| 707351 | When running UPDATE INDEX STATISTICS or UPDATE STATISTICS for a specific column, the leaf level of an index is scanned to get the values of any non-leading columns (if available). It is possible for ASE not to select the most efficient index to do this operation if the column exists as a non-leading column in more than one index. |
| 708519 | When upgrading from a pre-15.7 ASE version that does not support compression, RepAgent ASE 15.7 incorrectly assumes that compression is on for uncompressed tables. |
| 708527 | The message, "Current process (0x < value > ) infected with signal 11 (SIGSEGV)", in the module 'kbfalloc' together with a stack trace which includes the modules 'ra__process_xtext' and 'ra__process_txtblk' may be reported in the error log when replicating large, compressed TEXT columns. |
| 708945 | In rare circumstances, when replicating compressed IMAGE/UNITEXT LOB data, the replicate ASE may raise a 7153 error, "Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end", and the Replication Server may abort the connection. |
| 709211 | Following an abnormal termination of ASE, the recovery analysis and redo passes can be unnecessarily long in recovering large databases that had a very large number of different pages flushed to disk since the last checkpoint prior to the termination. |
| 709371 | The message, "timeslice < value > , current process infected at < value > ", in the module 'io_submit' together with a stack trace which includes the module 'bufawrite' may be reported in the error log when ASE is started in threaded mode and while it is creating a large database. |
| 709572 | A 301402 error, "Backup Server: 3.14.2.4: Logical page < page_number > is not in the given database map.", may be reported by the Backup Server during the execution of LOAD WITH VERIFYONLY on a database whose size is bigger than 2147483647 pages in an ASE installation that uses page size greater than 2K page. |
| 709947 | Syntax is added to the UPDATE STATISTICS command to allow printing of progress messages while the command is running. The new syntax is UPDATE STATISTICS < tablename > ... with "print_progress"= < 0|1 > where 0 = disable and 1 = enable. The default value is 0. |
| 710048 | A 1525 error, "Sort Failure. Rollforward of sort encountered sort descriptor timestamps out of sequence. Old timestamp in log: < old_ts > . New timestamp in log: < new_ts > . Timestamp in sort descriptor: < sort_ts > .", may be reported when loading a transaction dump that contains a CREATE INDEX command that was executed using parallel sort. ASE should have disallowed a transaction dump to be taken if it contains a parallel index creation. |
| 710496 | When Replication Agent is enabled to use the multipath distribution per connection model, and if the option "ddl path for unbound objects" is set to "default", it is possible that DDL commands are replicated to the incorrect path. |
| 710603 | A 1163 error, "The space allocated to the sysgams table in database 'tempdb' (dbid = 2) must be at least 16 pages.", together with a stack trace which includes the modules 'pggam__srchonegampage', 'pg_allocate_syslogs' and 'crdb__logtrunc' may be reported at ASE startup if the system tempdb is bigger than 63GB and has dedicated log devices which are placed out of the 63GB range. |
| 710847 | The error messge, "Page Verification Error: Virtual page < page_num > in device < dev_num > is out of database range." may be reported in the Backup Server error log as a result of a LOAD DATABASE command. |
| 711168 | In rare circumstances, when the ASE configuration parameter "disable varbinary truncation" is set to 1, a delete from a DOL table which has a unique index which has varbinary columns may hit a 644 error, "Index row entry for data row id (Pageid, Rowid) is missing from index page < page id > of index id < index id > of table < table name > in database < db name > . Xactid is ( < Transaction Id > ). Drop and re-create the index." |
| 711453 | Permissions through roles granted to non-default login profiles can be lost or reduced if there exists a default login profile that has not been granted all the roles that the non-default login profile has and a permission changing event (such as a grant or revoke) occurs in the server. |
| 711654 | The ASE errorlog may contain many instances of the kernel message "Expected object passed to blkioDescriptor is not of type BLKIO,..." |
| 711713 | In rare circumstance, when replicating an off-row compressed LOB column, the replicate ASE may raise the 7153 error, "Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end." and Replication Server will abort the connection. |
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
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition
Keywords
CR, ASE 15.7 ESD#1 Refresh #2, ASE 15.7, ESD#1 Refresh #2, 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.
/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)