/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 |
|---|---|
| 484953 | Sybcluster show instance status does not show correct status if shutdown instance outside sybcluster immediately. |
| 569808 | In rare circumstances, the message "current process infected with 11" in the module 'adb__reserve_pg' together with a stack trace which includes the module 'adb_dirty' may be reported in the error log after the load of an archive database. |
| 584647 | The values in "Default", "Config value", "Run Value" columns aren't right aligned when the sp_configure command is executed. |
| 636677 | Improve efficiency of spinlocks on the AIX platforms. |
| 646013 | When creating local index on semantic partitioning table, mapping between index partitions and datapartitions is not guaranteed in the same order of semantic partitioning boundary. |
| 649701 | Previously diagnostic information was available for error 290024 - invalid column. Due to possible performance issues, we now print it only if traceflag 2779 is set. |
| 666556 | Performance of sp_spaceused procedure is very slow when executed to get the space metrics for the entire database, especially so for databases with a very large number of objects and indexes. Improve the performance of this procedure by applying server-side changes along with a re-work of the procedure's logic. A new installmaster along with new ASE binary is needed to deliver this performance improvement. (The stored procedure changes alone are not sufficient). |
| 668790 | An audit process exception error message may occur that reports the incorrect numbers. The full error number is reported as the major number, the severity is reported as the minor number, the state is reported as the severity. |
| 670275 | ASE may allow four reader tasks to skip over a queued update task in lock sleep if the readers are trying to obtain a shared intent lock. |
| 682738 | CIS creates the first text page in an INSERT-SELECT query even though the source data is null. To activate the fix, trace flag 11241 needs to be turned on. |
| 685874 | A 3250 error, "The devices < value > and < value > specified in the command should be differnt" may be reported if the devices name length is more than 127 bytes when running a DUMP DATABASE command. |
| 688495 | If a new instance is dynamically added to the cluster in SDC mode, it may not be able to join the cluster when no other activity is taking place in the cluster. |
| 690437 | Expression subquery was always evaluated as part of the aggregate input expression even when the subquery is under CASE expression and the actual execution of the CASE doesn't need the result of the subquery. This could lead to unexpected exception during the unnecessary execution of the subquery. |
| 690533 | A wrong result could happen for an equi-join between two columns with different datatypes (such as INT2 = INT4) and there are two or more OR predicates (including IN list predicates) on one of the joining columns. |
| 693355 | When the ASE ESD number is not an integer (e.g. 1.1, 4.1 or 5.1 etc), then anything using the sp_versioncrack stored procedure (e.g. sp_spaceusage) may encounter a 249 error (conversion error). |
| 694912 | Exception is raised from localize command in sybcluster if ASE-15_0/locales contains unnecessary files/dirs. |
| 697125 | When using sp_downgrade to downgrade from 15.7 ESD#2 or later version of SDC server to 15.x SDC server, prepare will fail and raise message "One or more databases still permit wide DOL rows." on local system and global temporary databases. |
| 698089 | A 3475 error: "There is no space available in SYSLOGS to log a record for which space has been reserved in database '%.*s' (id %d)" may be reported under some circumstances when Adaptive Server has been booted with trace flag 3608, shutdown after some operations and then restarted in normal mode. |
| 698657 | The error 'Invalid RPC sequence at RPC as_cmd' may be reported by the Backup Server when a dump is attempted using a remote backup server and the local interfaces name is different from the remote backup server start-up name. |
| 702339 | After upgrading to release 15.7 ldap logins fail. Initial attempt fell back to ase login. Next attempt received 'Server is unwilling to perform'. |
| 703123 | Predicates that contain more than 128 or-terms in a disjunct may not be optimized using a general-or strategy. In cases where such a general-or strategy provides the only efficient search strategy, query performance could be poor. |
| 704679 | DISK REFIT fails to restore 'durability' and 'crdate' column information in sysdatabases system table. |
| 705093 | Extensions to the Remote Backup Server name feature allowing to be specified as 'hostname:portnumber'. |
| 706581 | The message, "current process infected with signal 11", together with a stack trace involving the function prot_view_decdef_cols() may be reported with a complex query when access is made through a VIEW and the accessed columns are encrypted with decrypt_default. |
| 706777 | The message text for error 9262 has been changed to report the database name and ID values such as "A Rep Agent Thread for database ' < dbname > ' (dbid= < value > ) is already running". |
| 707065 | In rare situations, a 1514 error might occur while creating the index with a reserved page gap. |
| 707411 | In rare cases with tables having non-unique indexes with huge duplicates, the index might end up having lot of near empty pages. |
| 707783 | When using traceflag 7738 to enable statement cache user id sharing, sometimes an error 622 (Opentable was passed a varno of ...) may be raised if compatibility mode is also enabled. |
| 708058 | Extend sp_helpconfig to support a new "estimate" clause to estimate the size of 'compression info pool size' config option based on other config parameters, or user-overrides. |
| 708071 | In ASE Cluster Edition during instance failover recovery, the checkpoint process may be blocked by the threshold manager process that is doing free space accounting recovery for a large database that has the "trunc log on chkpt" database option turned on. |
| 708240 | For RTC (run to completion) threads such as syb_system_pool & syb_blocking_pool, values from monThread for BusyTicks shows it is alway busy. It is corrected to reflect work done. |
| 708273 | For an update query with instead of trigger, if it updates numeric column, it could return wrong result if literal autoparam configuration parameter is turned on. |
| 708876 | When the user specifies for dump configurations a default directory for the dump stripes with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when generating the list of commands that are needed to create a target database with the same layout as the source database. |
| 708900 | In rare circumstances, when a query involves join with many remote tables, a message "current process infected with 11" in the module 'sdes_hookup' together with a stack trace which includes the modules 'omni_remote_name' may be reported in the error log. The problem occurs when 'showplan' is on or 'plan text pipe active' is configured to 1. |
| 709255 | In some rare case, it could stacktrace when we print query execution info or final plan in XML. |
| 709453 | If an application passes an invalid TEXTPTR to different LOB-related T-SQL commands (e.g READTEXT, WRITETEXT, TEXTVALID, etc) for an IN-ROW LOB, sometimes the command may report fatal 605 or 625 errors. |
| 709510 | Enabling I/O fencing may result in "reservation conflict" messages in the system log. |
| 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. |
| 709651 | A number of different errors and stack traces might be seen in the error log in an ASE CE system after executing ONLINE DATABASE on one instance, having loaded one or more dump that were taken on an earlier version of Adaptive Server compared to that into which they are loaded, on another instance. |
| 709721 | When an in-row LOB column which has both data compression and LOB compression properties defined has its schema changed by setting the LOB compression property to not compressed, ASE following a SELECT query execution may return incorrect results for this column for data that was inserted into this column before the column schema change occured. |
| 709805 | In some case, downgrade could cause memory corruption issues and stacktrace. |
| 709963 | If a union view creator does not specify the owner of base views, it could get error msg 225 if the same base view name is created by an sa and the union view creator. |
| 710240 | Sybmon would report a signal 11 error when the quite command is executed on 32bit or 64bit windows platform. |
| 710300 | Deploy plugin raises an error but reports that it succeed |
| 710430 | A histogram with a range cell at the very end of the histogram may have the weight of the lower bound of the cell incorrectly added to the last cell. Range cells by convention are exclusive of the lower bound of the cell. This may result in mis-estimates and poor query plans when predicates in queries reference the lower bound value. This is especially true if the lower bound has a high row count associated with it. |
| 710495 | On Linux platforms, monThreads.OSThreadID is sometimes reported as a negative number that does not match the OS reported thread ID. |
| 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. |
| 710536 | Data may be corrupted during page compression if there is a compressed in-row LOB column in the table. |
| 710589 | Column statistics histogram may be skewed in the last histogram step if the total sampling row count is greater than 2,147,483,647 when updating statistics. |
| 710594 | DBT_SPIN is hot when there are lot of queries or stored procedures that work across multiple databases. |
| 710693 | For the jobs having repeat interval of one minute, if job creation time is less than starttime of job, second execution of the job is missed. In addition, for the jobs having repeat interval of one minute, if starttime is greater than or equal to endtime, alternate executions of the job are missed after midnight till endtime. Finally, for the jobs having the same startime and endtime with any repeat interval, the job starts executing before starttime if startdate is same as job creation date. |
| 710754 | When sort_resources is on, negative row count maybe be reported when executing CREATE INDEX, UPDATE INDEX STATISTICS or UPDATE ALL STATISTICS on table with more than 2147483647 rows. |
| 710843 | While running a batch of ADD or DROP constraints out of which a few fail due to valid reasons, the subsequent ADD/DROP constraints may fail with the error 4956. |
| 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. |
| 711008 | ASE becomes unresponsive, ASE's network controller thread loops consuming 100% of one cpu |
| 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." |
| 711170 | When enabling the RepAgent configuration parameter 'activate monitoring', after stopping and restarting the RepAgent, the setting automatically reverts back to 'disabled' mistakenly. |
| 711220 | DBISQL stacktrace when loading an xml plan generated by sp_showoptstats |
| 711299 | ASE running in threaded kernel mode allows user to decrease the value of 'max online engine' less than the total number of engine threads leading to a boot failure while rebooting the server. A message saying "The total number of mux threads X is exceeding cmaxonline Y." may be reported. |
| 711328 | Using sybcluster to add an instance in interactive mode failed. |
| 711332 | ASE may not be able to start a large number of engines with the ASE kernel configured for Process mode as a Spinlock allocation error can be encountered. |
| 711412 | When the user is running a batch query with a temp table creation outside a stored procedure, and execute the stored procedure referencing this temp table, the procedure will be renormalized each time. When there're many processes calling this batch query at the same time, random signal 11 stack traces will be observed. |
| 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. |
| 711494 | Server hang when executing ALTER TABLE spt_TableTransfer SET TRANSFER TABLE OFF. |
| 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. |
| 711953 | When attempting to execute a stored procedure in a database that the user is not a user in two error messages will be displayed stating that the user is not a user in the database. |
| 711978 | A segmentation violation can occur when configuration parameter "suspend audit when device full" is set to 0 after the audit segment becomes full. |
| 712125 | If there are more than 32 columns used in an UPDATE STATISTICS command, either explicitly or implicitly through the auto_temptable_stats feature, then there is a possibility of a stacktrace. |
| 712258 | TOP N syntax is not shipped to the IQ server. |
| 712461 | If multi-column syntax is used with update statistics tabname (colname1, colname2,...) using out_of_range {on | off | default }, then the assignment of out_of_range behavior may not be associated with the correct columns. |
| 712480 | The LAVA based index creation is enhanced to support the case where the index leading columns are duplicated. |
| 712541 | sp_displayrole does not report expired password. User get error 11176. |
| 712636 | Too many steps may be created for a histogram when parallelism is used during create index or update statistics. |
| 712783 | When multiple queries are executed on one of the MDA FDP Tables with Adaptive Server Enterprise Cluster Edition the same row may appear in the results of multiple queries. This is not expected since the FDP tables should not present the same row in multiple queries. |
| 712808 | In some cases, DBCC CHECKTABLE may report error message 7948 after a clustered index is created on a compressed APL table which contains only 1 row. |
| 712855 | Invoking the soundex() or difference() built-ins on unichar/univarchar strings larger than 127 characters (254 bytes) may cause the process to be terminated. |
| 712903 | Idle connections may fail to migrate during instance shutdown. |
| 712940 | Complex queries (often with a large number of group-by columns and a large number of joins where generally each grouping column belongs to a different "joined" table) may SEGV after generating a 331 error terminating the session. The 331 error is raised because the query has exhausted the sort id namespace. |
| 712949 | When dbcc page() for text page with print option 3 or 4, the output may be out of the range of the page size or hit infinite loop, also, if dbcc page() for text page with print option 1, 3 or 4, it may report a corrupt row message. |
| 712996 | sp_showoptstats output has been changed for the < statsOutRan > tag to have a value of "on" if the "using out_of_range on" phrase was used in update statistics, and "off" if the "using out_of_range off" phrase was used, and will not be printed if "default" is in effect. Previously "true" was printed when "on" or "off" was used. |
| 713074 | Monitor server has been retired since 15.7 GA but sybcluster still contained the operations for configuring monitor server. These operation options have now been removed. |
| 713189 | If the Cluster Editions is configured with both backup or xp servers, then adding an instance with an xml input file may fail. |
| 713291 | In rare circumstance, error 1204, "ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS.", and error 5619, "Adaptive Server internal error. Could not obtain count of in-doubt transactions for space reservation.", may be reoported when running BCP IN/INSERT/UPDATE on table with TEXT/IMAGE/UNITEXT columns marked replicated. |
| 713411 | When replicating the value from an LOB column which have both in-row and LOB compression property, if the defined in-row length of LOB column at replicate side is so long that is close to @@maxpagesize, replicate ASE may raise error 7153 '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 Rep Server abort the connection. |
| 713464 | Error 1503 may occur when index is created with LAVA based index creation if the number of distict index value is not greater than CONSUMERS number. |
| 713481 | Negative row count may be shown in the output of DBCC CHECKTABLE and CHECKINDEX commands if there are more than 2,147,483,647 rows in the table. |
| 713540 | When the user specifies for dump configurations a default directory for the dump stripes with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when generating the list of load database and load transaction commands that are needed to repopulate the database to a specified point in time. |
| 713547 | A wrong number of rows may be updated with INSTEAD OF TRIGGER when the base table of the view has predicates defined on it. |
| 713631 | Error 832 may be reported when creating an index whose depth is greater than 6 if 'number of sort buffers' is configured as smaller value. |
| 713728 | After upgrade from 12.5 to 15.7 ESD#1 or later version, if the 15.7 server is SMP server, "allow wide DOL rows" option is missing on tempdb; if is SDC server, this option is missing on the local temporary databases. |
| 713800 | With plan sharing enabled, and under heavy workloads consisting of concurrent queries that qualify for query plan sharing, some shared plans may be prematurely terminated. |
| 713840 | 'dbcc markproc' was failing with error 12309 : Expanding update on object was failing on page due to insufficient free bytes. |
| 713848 | On the Solaris platform, when ASE is running on a cluster in threaded kernel mode, if the XP server of an instance is shutdown from an isql session on another instance, the isql session will hang. |
| 713855 | When migrating from Adaptive Server versions 12.5.4 or 15.0 to version 15.7 ESD #2 using sybmigrate, the execption, "Failed to add the role 'sa_serverprivs_role' into the current database catalogs", may be raised. |
| 713881 | A 9830 error may be reported when inserting a row into a table with compressed data. |
| 713945 | In some circumstances, the message "current process infected with 11" in the module 'LeScanOp::_LeOpRelease' together with a stack trace which includes the modules 'LeUnionOp::_LeOpRelease' and 'LeEmittOp::_LeOpRelease' may be reported in the error log after an error message 716 if the query involves a UNION ALL clause. |
| 713950 | A stacktrace may occur when using UPDATE STATISTICS with HASHING on character string datatypes which have a non-binary sort order, and there are more than 65535 unique values. |
| 714034 | DBCC CHECKTABLE or CHECKINDEX may report error 803 if the index is very deep. |
| 714061 | Forwarded row count in the SYSTABSTATS for a table that underwent 'REORG REBUILD < tabname > WITH ONLINE' may be incorrect. |
| 714086 | In some cases, if a union query involves concate varchar type of variable, it could return wrong result due to unexpected truncation. |
| 714131 | In some customer scenarios with stored procedures or sql accessing multiple databases, rdbtmgr_spin would show high contention. |
| 714153 | Parallel index creation may fail because of error 832 if 'number of sort buffers' is configured as very small and the index depth is very large. |
| 714217 | Supplying an overflow or underflow search constant to a query on a proxy table may return incorrect result. |
| 714306 | When 'literal autoparam' is enabled, it could raise an error if a query has a literal in order by clause such as ' ', 'a' and the query was cached in statement cache and it needs to be recompiled. |
| 714478 | In some rare case, if 'functionality group' is turned on or 'streamlined dynamic SQL' is enabled, it could cause stacktrace in LeHashInputSet::releaseExtents(), LeHashOP::LeOpSaveIOStates() when a stored procedure or a cached statement is executed multiple times and its plan has LeHash operator. |
| 714612 | A 2846 error, "SQL function 'dbo.sp_ < function name > ' not found. Specify owner.objectname or use sp_help to ..." may be incorrectly reported when a SQL user defined function created in sybsystemprocs database with a name prefixed by "sp_" is invoked from a database while a open transaction in the same database is creating a stored procedure, view, trigger, rule or default. |
| 714638 | monEngine connections column is wrong for kernel mode threaded. |
| 714670 | sp_downgrade_esd does not report tables which are configured for in-row LOB compression. |
| 714798 | On AIX platform, ASE Cluster Edition may fail to start if logical volumes are used and I/O fencing is enabled. |
| 714806 | When ASE is shut down using the 'nowait' option and while data is loaded using fast bulk-copy into a table that is created with the 'fot load' attribute, on ASE restart some data my be lost. |
| 715086 | When shutdown cluster is issued from one instance, busy user tasks running on other instances may be immediately terminated. |
| 715183 | The replication of a stored procedure for which a 'request function replication definition' has been created fails with Replication Server error 5157 indicating that the transaction owner's password is missing. |
| 715240 | ASE Cluster Edition allows user to create thread pool when "max online engines" is not sufficient. |
| 715670 | CS_IODESC.name has view name instead of table name for LOB column. |
| 715785 | Signal 11 in set_password or sync_password |
| 715835 | Modify auditinit utility to create log file with 600 permission, instead of user's umask. |
| 715967 | auditinit utility requires user to enter non-null sa password for existing ASE. |
| 716284 | asecfg core dumps when started on Solaris x64. |
| 716349 | In some cases, ONLINE DATABASE or DBCC CHECKDB executed on a database with large number of compressed objects might fail with error 716 (Unable to allocate memory from the compression info memory pool), when the 'compression info pool size' configuration option is set too low (e.g. the default value of 4096). |
| 716618 | When use TF7751 and TF7752, sometimes it could cause stacktrace during plan printing. |
| 716645 | During an UPDATE command on a table that has in-row LOB columns defined, ASE may move some of these columns from in-row to off-row or vice-versa if the size of a datarow exceeds configured limits. When such a table has a datarow with an off-row LOB column that is not explicitly updated, ASE may not log this column data correctly. This will result in replication failing if this column is marked as always_replicate. |
| 716679 | When network password encryption is used and sp_passwordpolicy option 'unique keypair per session' is set to 0, client connections will fail with error message: Sybase CSI Error Message: Error generating asymmetric key. Root error: error:0906D06C:PEM routines:PEM_read_bio:no start line CT-LIBRARY error: ct_connect(): protocol specific layer: internal Client Library error: There is a tds login error. The installed encryption handler returned a status that was not CS_SUCCEED. |
| 716720 | Remove error # 12061 when a query is executed on an MDA Table that contains localized message text when the client is configured to use a language into which the MDA Table messages have not been translated. Specifically, if the client language is set to 'german' error 12061 will no longer occur when a query is executed on the monWaitEventInfo table. |
| 716798 | select involving aggregates and having predicated privileges defined at column level on the table could result in wrong results. |
| 716960 | ASE fails to boot on Windows Server 2012 with a stacktrace containing kiprint_os_version() on the stack. |
| 717050 | A 3502 error, "DUMP TRANSACTION requires a dump configuration name because the configuration option 'enforce dump configuration' is enabled." may be reported during the installation of an ASE ESD release on top of 15.7 ESD #1 version while 'instmsgs.ebf' is installed and ASE uses a dump configuration. Alternatively when ASE uses a dump configuration the execution of "DUMP TRANSACTION < database > WITH NO_LOG" will fail. |
| 717079 | The ASE COTS JavaVM version is updated to version JRE 6 update 33 for each supported platform in the sybpcidb database. |
| 717224 | Execution of sp_sysmon by a user other then "sa" can result in error 4066 when "sa" login is locked. |
| 717232 | When using update statistics with hashing there may be a stacktrace when the number of unique values in the column is greater than 65535. |
| 717481 | If with hashing is used, and the column has more then 65535 unique values then there is a possibility that the sarg density and unique count for the column are under-estimated. |
| 717491 | Importing data in DBISQL by selecting Data - > Import from a database menu option, fails with password length issue JZ002 |
| 717496 | ASE returns error message (Msg 16341, Level 19, State 1) when split a range partitioned table when partititoning filed is a VARCHAR, DATETIME fields. |
| 717610 | when using hash-based statistic gathering, the default column width should be used for fixed length columns instead of being computed. |
| 717627 | sp_showoptstats would always display 4.00 as the default average width for any fixed length column |
| 717662 | When using fast logged bcp to insert data into a table that is marked for replication and has TEXT/IMAGE/UNITEXT columns, some TEXT/IMAGE/UNITEXT data may not be successfully replicated. |
| 717740 | Bcp-in was failing for a table with columns more than 128 column and having one of them as text column. |
| 717879 | When a set role command is executed within a procedure or SQLUDF, it takes effect during the context of the procedure or UDF only. |
| 717910 | When the built-in function GETREPDEFMODE() is called in a query involving a table, an error 622 may be reported together with a stack trace in the error log which includes the modules 'get_repdef_mode', 'open_user_table' and 'sdes_hookup'. |
| 718206 | If the master database has a secondary truncation point set during an upgrade from 15.0.1 to 15.7, an error 950(Database 'master' is currently offline. Please wait and try your command again later) will be raised during the upgrade. |
| 718628 | Signal 8 can occur when the "update statistics hashing" configuration parameter is used |
| 718696 | When an AP plan clause is specified as part of a dynamic SQL prepare statement, the plan clause is not saved in the statement cache when such statement is cached under ‘enable functionality group’ or ‘streamlined dynamic SQL’. |
| 718710 | The message "current process infected with 11" in the module 's_begupdate' together with a stack trace which includes the modules 's_execute' and 'execproc' may be reported in the error log when a stored procedure executes a DML statement which was compiled at runtime. |
| 718741 | Signal 11 in bufdlink() *also reporting ups_nosort_init_prestat() & us_allocate_stat_proc_hdr() * may appear in the error log along with the server shutting down. This can happen when there is a worktable used by an update statistics command that resides on an in-memory tempdb (IMDB) |
| 718778 | The message "current process infected with 11" in the module 'ra__process_xchange' together with a stack trace which includes the modules 'decompress_row' and 'decompress__crow_to_apl' may be reported in the error log, after an alter table with no datacopy command is run on a table that has compressed data, and while the replication agent task is attempting to decompress data to be sent to the Rep Server. |
| 718876 | sybdiag fails with an unhelpful error on Solaris when the SYBASE_JRE6 environment variable is not set |
| 719019 | An argument to error message 103 (The < msg > that starts with ' < string > ' is too long. Maximum length is < n > .) is too long. The argument needs to be truncated. |
| 719023 | The error message "A00: SYBMULTBUF ERROR: Internal error: The number of archive strings in the database info file exceeds the maximum number of allowed stripes." may be reported by the backupserver when an attempt to execute a DUMP TRANSACTION command with many STRIPE ON clauses is made. |
| 719124 | ALTER TABLE SPLIT raises errror 16341 for range partitioning when it is based on DATETIME values. |
| 719138 | The ASE server fails to boot on the HP-UX IA64 platform in Process mode if Kerberos is enabled. |
| 719162 | When using fast logged bcp to insert data into a table that is marked for replication and has compressed TEXT/IMAGE/UNITEXT columns, the compressed TEXT/IMAGE/UNITEXT data may not be inserted successfully and the bcp command fails. |
| 719399 | When the followng three conditions are met: - the SQL statement has enough predicates to generat at least 400 SARGs and - the SQL statement is executing at isloation level 0 (dirty reads) and - a unique index with at least 10 columns is chosen by the optimizer to use for repositioning the scan, A 702 error can be raised with the function, setupSargArray in the call stack. |
| 719449 | Adaptive Server may encounter a storage access violation error when query execution is interrupted or some special query is executed on 64bit diagsrvr.exe or 32bit sqlsrvr.exe on windows platform. |
| 719532 | When GP (Granular Permissions) is enabled, booting ASE could result in a 10331 (Permission denied..) error. |
| 719639 | The message "Missing datarow in TEXT/IMAGE/UNITEXT insert log record. Transaction log may be corrupt." may be reported when attempting to replicate data after an alter table drop column with no datacopy command is run on a table with LOB data. |
| 719643 | If hash based statistics collection is used with a large number of steps, then a stack trace in the function ups_stat_memalloc() may be encountered. |
| 719752 | When GP (Granular Permissions) is enabled, booting ASE could result in 16802 (You must have the following permission to execute this command/procedure..) error. |
| 719859 | If data row decompression is used, then update index statistics may be slower since an unnecessary data row decompression is performed. |
| 720703 | The first row insertion into DOL table might lead to in-correct emptypgcnt value in SYSTABSTATS due to '0' emptypgcnt set by the task creating the index on empty DOL table. |
| 721144 | If Java in the database is being used, then if the "same" shared configuration file is used by more than one instance or Server, then there is a race condition during JVM initialization where it is possible that the message “current process infected with signal 11” in the function ‘jvminit’ may be reported in the error log, followed by the message “Failed to initialize Java services". This may result in ASE shutting itself down. |
| 721278 | A 691 error "Encountered invalid logical page '0' while accessing database ... This is an internal system error ..." may be reported in the error log followed by a stack trace which includes the functions 'set_repdb_status', 'txtimg_upd_table' and 'pg_oamscan_startscan' if a database that has the option "deferred table allocation" set is being marked for replication with SP_REPTOSTANDBY and the 'all' option. |
| 721731 | ASE Alarm Subsystem may stop working that can result in "waitfor delay hh:mm:ss" exceeding specified time or even hang. This can also cause log records having stale time values that can prevent "point in time restore of a database" not working. |
| 721735 | After ASE upgrade, Job Scheduler may fail to boot with error "Execution of rule check_jsc_state failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.check_jsc_state." Running "dbcc upgrade_object" on sybmgmtdb resolve the problem. |
| 722547 | On Unix systems the execution of DBCC DBTABLE may report descriptions of DBT3 bits when printing DBT2 bits mistakenly. On Windows systems a stack trace in the module 'prSTAT_str' may be reported in the error log due to a storage access violation. |
| 722659 | ASE reports a timeslice error with ksnetctlrPostWrite and ksmaskspost on the stack. Shared memory dump for the error shows a circular "Cancel Queue" leading to the timeslice error. |
| 722673 | The execution of the command "DROP PRECOMPUTED RESULT SET < prs_name > " on the primary database cannot be replicated into the standby database successfully. |
| 722767 | The remote backup server name length for DUMP/LOAD commands has been expanded to support more than 30 characters. |
| 722856 | In an HA environment when a role that contains a role activation predicate is dropped on the primary server the secondary server does not remove the predicate metadata. |
| 722902 | DDLGen generates data partition names instead of index partition names in the index partition clause for a clustered index on an all pages locked table . Also the semantic order of partitions in the index partition clause for both clustered and non clustered indexes is not correct. Also if index partition names are system generated, then they are not generated in the partition spec , when -XPN option is specified |
| 723015 | The backupserver error message "3.27.2.1: Invalid RPC sequence at RPC as_cmd." followed by "5.7.2.7: RPC ('as_cmd') execution failed." may be reported when a LOAD DATABASE is executed and the backupserver name "hostname:portnumber" cannot be resolved correctly. |
| 723500 | When using Replication Server with HVAR turned on and an update statement against a table on the primary causes non-updated in-row LOB datums to be moved off-row so the new data could fit in the target row, then the LTL generated by Rep Agent may be wrong, and replication may result in those datums being set to NULL on the replicate. |
| 723986 | After 'reorg rebuild' or 'change lock' an empty table, the emptypgcnt of systabstats becomes 0, which, however, should be 1. |
| 724023 | The message "current process infected with 11" in the module 'bufreserve' together with a stack trace which includes the modules 'drop_al_dbid' and 'alterdb' may be reported in the error log when an ALTER DATABASE LOG OFF command is executed to shrink this database log space. |
| 725209 | ASE on Windows may report "LAST CHANCE EXCEPTION HANDLER on OS thread id < threadID > ...A SERIOUS UNHANDLED EXCEPTION HAS OCCURRED SERVER MAY NOT BE ABLE TO CONTINUE" with kcierrfmt() on the stack during shutdown when the server is forcefully shutdown, for example through CTRL-BREAK. |
| 725211 | ASE engines may start consuming 100% CPU which can result in ASE being unresponsive. New client connections may not also be possible. |
| 725810 | The message "current process infected with 11" in the module 'th_curunreservedpgs' together with a stack trace which includes the modules 'LeRun' and 'exec_lava' may be reported in the error log when a session executes a SELECT statement that uses the T-SQL function "curunreservedpgs" while another session is in the process of extending the size of the current database with ALTER DATABASE 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
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition
Keywords
CR, ASE 15.7 ESD#3, ASE 15.7, ESD#3, 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)