SAP Knowledge Base Article - Preview

2080932 - Targeted CR List for ASE 15.7 ESD#3 - SAP ASE

Symptom

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

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

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

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