/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. |
| 642038 | On Platforms other than x86 Linux and Solaris Sparc, the rdesmgr_spin spinlock was hot in some scenarios. |
| 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. |
| 667751 | Support for UNIX Domain Sockets for ASE has been added for the Linux and Unix platforms. Adaptive Server Enterprise version 15.7 ESD#4 and later now support the UNIX domain socket communication, which avoids some of the overhead the TCP protocol incurs. Similar to other protocols, include the AF_UNIX protocol in the interfaces file for clients to connect to Adaptive Server. The syntax for an AF_UNIX in the interfaces file is: master afunix unused // < hostname > / < pipe > |
| 672255 | In some circumstance, the CPU usage of ASE might increase to near 100% after turning on the “plan text pipe active” option. |
| 676991 | High CPU usage may be seen along with with high rprocmgr_spin contention. |
| 685171 | When the set option "timestamp_insert" is enabled, an invalid value may result when inserting a "NULL" value into a timestamp column. |
| 688481 | The message "current process infected with 11" in the module sdes_num_in_chain() together with a stack trace which includes the modules kill_proc() and LeExecSqlFunc() may be reported in the error log if a long running user-defined SQL function session gets killed. ASE may need to be rebooted following this error. |
| 689230 | The message "current process infected with 11" in the module "uwdisconnect" may be reported in the error log when a DBCC CHECKSTORAGE was aborted by CTRL+C or client application was killed. |
| 689990 | Using "SET STATISTICS" type tracing without appropriate user permissions can result in a stacktrace in OptGlobal::_GblSearchEngine(int*) being reported in the ASE errorlog. |
| 692870 | Enable pinning of dynamic SQL query plans via the configuration option 'dynamic SQL plan pinning'. This is a productization of trace flag 480. |
| 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). |
| 695557 | Allow a nondefault sql.ini location to be specified in dbisql |
| 696676 | When a query with IN list chooses a special OR strategy, the query plan still shows a RESTRICT operator which is superfluous and can be quite expensive up to 35% |
| 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. |
| 700034 | A parameterized varchar column in the SELECT lists combined by a UNION (ALL) clause in the derived table may return unexpected trailing spaces if statement cache is enabled. |
| 701299 | Implement variable network packet size for better performance. |
| 702346 | Timeslice error including routines s_free(), rvm_clean_pcrtree(), and rvm__ipcr_attr_cleanup() on the stack. Request new timeslice check in the related resource cleanup path. |
| 705093 | Extensions to the Remote Backup Server name feature allowing to be specified as 'hostname:portnumber'. |
| 706799 | Memory allocation failures appear in the ASE errorlog when the network memory pool is exhausted or when fragmentation of memory occurs due to memory that is not freed. |
| 708356 | Invoking the reog rebuild command on a table with a bracketed identifiers will generate a warning claimin an Abstract Plan (AP) syntax error. |
| 708798 | In specific circumstances involving execution of a stored procedure under execute immediate in combination with additional statements it is possible for the following error.. CT-LIBRARY error: ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read ..to be observed when using isql or any other ct-lib client and the subsequent statement (after the execute immediate) to not be executed. The issue only arises under very specific circumstances when certain statements that are deferred for compilation at runtime have to be compiled when under an execute immediate. |
| 708821 | Checktable and Checkdb report an error that "An invalid 'data row id' value was found in first text page of a text/image/unitext column." for replicated DOL tables that have text columns with values on forwarded rows. |
| 709184 | Improve UTF-8 sort order 25 performance for well-formed UTF-8, under sp_configure parameter "enable permissive unicode". |
| 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. |
| 711819 | Replicating a SELECT-INTO statement fails when the source table contains quoted column names. |
| 712531 | In rare circumstances the query on FDP table might get some uninitialized data after the FDP table is re-sized. |
| 712554 | The message "infected with 11" together with modules like "tdsrecv__dynexec" and "sequencer" if using jconn3.jar with text/image datatypes and an ASE157 releases. Often, message 3805 will be reported too. |
| 713707 | The message, "Current process infected with signal 11", together with a stack trace which includes the modules 'bi__xml_query' and 'bi_xmlextract' may be reported in the error log when an external KILL signal is issued to a regular XML query session. |
| 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. |
| 714355 | It is difficult to understand just what 'dbcc markprocs' in sp_downgrade is doing, so replace the statement in sp_downgrade with a more understandable SQL update. |
| 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. |
| 715094 | A 716 error, "Unable to allocate memory of size %d bytes from the '%S_MSG' pool" may be reported when querying a partitioned view including compressed tables many times. |
| 715234 | On AIX, the monThread MDA table incorrectly indicates that the Listener thread is consuming 100% CPU. |
| 716166 | A 12324 error, "In database 'dbname' the server failed to open required table 'syspartitions'. Please contact Sybase Technical Support." may be reported during the execution of either LOAD DATABASE or USE < database > commands when ASE is requested to calculate threshold information by performing OAM scans. |
| 716457 | The ASE Backup Server process has a memory leak when dumping and loading databases, which causes it to grow until it exceeds the memory limit. |
| 716567 | A query having MDA table monProcessObject caused signal 11 in routine mda__process_sdes() with an invalid SDES in a cursor. This CR seems a concurrency issue since another session was doing 'OPEN CURSOR' and the related internal cursor structures might be changing. May need to add more validation code in the related routine. A possible workaround is not to query monProcessObject. |
| 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. |
| 716870 | Adaptive Server may not kill a task that is marked for termination, which is reporting shortage of buffers in buffer pool like "cache is configured too small for current demands". |
| 716981 | When the configuration option 'number of network tasks' is set to greater than 1, ASE running on HP-UX may hit infected with signal 11 (SIGSEGV) in module kstcpnetctlrCancelRequests. |
| 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. |
| 717212 | An infected with 11 (SIGSEGV) stacktrace in statinit soblddolpages occurs when trying to ALTER TABLE to add a column to a table with indexes. |
| 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. |
| 717574 | Event ID 178's description is updated, it is wait time for client connections. |
| 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. |
| 717828 | A 9254 error, "Could not locate schema version for object id '0' in the transaction log." followed by a 9204 error, "Could not locate schema for object with id = (0), current marker (0, 0)." may be reported in the error log when inserting or updating an in-row LOB datum and the ‘multipath distribution model’ is enabled. This will result in the Rep Agent Thread shutting down itself. |
| 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'. |
| 718133 | If more than one process tries to materialize a deferred table, they all will be stuck in a deadlock and only one process would succeed causing all others to rollback. |
| 718191 | Error 2812 or 11214 is raised when accessing an MDA table specifically mapped as a proxy table. |
| 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. |
| 718261 | Running sp_monitor will lead to an error 2812 raised via sp_monitor_server. |
| 718284 | An 823 error, "I/O error detected during wait for BUF= < value > ... cid=0 ('default data cache') ... " may be reported when an ASE 12.5.4 database dump is loaded into an in-memory database and while ONLINE DATABASE is run. This will result in a database upgrade failure. |
| 718440 | When executing sp_dboption without any parameters to list database options, the output is hard to read due to a lot of empty spaces. |
| 718466 | A 1508 error, "Create index aborted on duplicate rows. Primary key is 'spinlock_p, -32768'" may be reported when running sp_sysmon and sp_sysmon runs very slowly. |
| 718587 | A task deleting rows from a DOL table in an in-memory database might wait indefinitely for an EX_LATCH by holding the SH_LATCH on the data page. |
| 718628 | Signal 8 can occur when the "update statistics hashing" configuration parameter is used |
| 718637 | Parallel queries with the following query plan scenario MIGHT fail with a "Command has been aborted" message and no other warnings/errors reported in the error log: (1) There is a merge-join op where one of its child trees contains a replication exchange operator. (2) There is no "draining" operator (e.g. sort operator) between the merge-join and the exchange operator. (3) The merge-join's other child drains its input stream before the child with the replication exchange does. |
| 718658 | A signal 11 (SIGSEGV) error occured in kmuxtskGetThreadpool() while running sp_sysmon. This is a timing-related issue that is not easy to reproduce. It occurs only on a server that is running in threaded kernel mode. |
| 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 error 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. |
| 719290 | When DUMP DATABASE or DUMP TRANSACTION is run to a tape device, if the tape device configuration file ‘backup_tape.cfg’ exists, ASE will not be able to read it and the dump will fail. The Backup Server will report an error: "The format of the device configuration file < $SYBASE > /backup_tape.cfg is invalid. Remove the configuration file and reconfigure the device by issuing a DUMP with the INIT qualifier. Return code = 0". |
| 719361 | The reported database name is truncated to 20 characters when executing sp_dbrecovery_order for a database with database name longer than 20 characters. |
| 719389 | In sybmon, shared memory dump will not be compressed if "memory dump compression level" is set as 0 although the "memdump compress" command is executed explicitly. |
| 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. |
| 719560 | On ASE Cluster Edition Solaris platform, when a user with sa_role executes 'set role sa_role on' followed by 'alter thread pool' command, the login connection hangs with following message in the error log: "There is no thread pool named '' defined in the system." |
| 719597 | Report the compressed shared memory dump file size and configuration setting in the sp_shmdumpconfig stored procedure. |
| 719616 | When ASE Cluster Edition is configured error message 969 "You can access database ' < db > ' only from its owner instance.." is not being raised when the sp_ddlgen_permissions stored procedure accesses a tembdb on another instance. Errors such as 567 "You must have the following role(s) to execute this command/procedure.." or 17230 "You must be the System Administrator (SA) or the Database Owner (dbo) to execute this procedure" were reported instead. |
| 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. |
| 719673 | A 14108 error, "Could not find partition descriptor for objid %d, indid %d, ptnid %d in dbid %d" may be reported when running DBCC DBREBOOT if traceflag 12315 is off. |
| 719678 | Under some circumstances, in a Shared Disk Cluster environment, sessions may hang because space usage on the segment has been put incorrectly in a freeze state, owing to threshold manager limits being mistakenly hit when they should not have been. |
| 719683 | A 3223 error, "Attempt to read a dump header failed; returned error code is 12." followed by a 3208 error, "Unexpected end of file while reading beginning of dump. Please confirm that dump media contains a valid ASE dump. The ASE error log may contain more information on the problem." may be reported due to a corrupted dump header while loading a database dump that was taken on ASE 15.7 ESD#2 and the database was created with a template. |
| 719722 | The values for the IOTime column in the monIOQueue table are incorrect. |
| 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. |
| 719838 | Executing the incorrect syntax 'grant execute on set_appcontext to < user > ' causes a system exception (signal 11) referencing 'grrev_nullflush'. The command should be 'grant SELECT ...' |
| 719859 | If data row decompression is used, then update index statistics may be slower since an unnecessary data row decompression is performed. |
| 719911 | DDLGen is not backward compatible for archive databases in ASE 15.7 ESD#2 |
| 719915 | DDLGEN fails to include the LOB_COMPRESSION attribute when run on a database that was upgraded from ASE 15.0.3. |
| 719961 | Under some rare cases, a signal 11 (SIGSEGV) could occur in open_byname() when executing nested stored procedures. |
| 720139 | When doing upgrade using upgrade utilities or downgrade for such databases which name contains blank or tab character, upgrade utilities or sp_downgrade/sp_downgrade_esd will report syntax error on the database name. |
| 720162 | When the system stored procedure sp_help_rep_agent is executed with no parameter or a null value for @dbname, error message 18374 may be unexpectedly printed with an empty database name. |
| 720224 | Errors 7961 and 2759 are raised when a variable is used in a GRANT ROLE predicate definition. The errors are raised correctly but the wording is cryptic. |
| 720313 | ASE 15.7 fails to start during upgrade from ASE 12.5 due to the lack of enough ASE kernel resource memory being reserved. |
| 720417 | If the user does not have sso_role when running installmaster, the message "You must possess System Security Officer (SSO) role to run the installmaster script" will be displayed when on a Cluster Edition server instead of "You must possess System Administrator (SA) role, System Security Officer (SSO) role, Sybase Technical Suport role and Monitor and Diagnosis role to run the installmaster script." |
| 720655 | If running:- sp_restore_system_role 'sa_serverprivs_role' after having re-created 'sa_serverprivs_role' and the role id for 'sa_serverprivs_role' is greater than 99, you will receive error 265 Msg 265, Level 16, State 1: Server 'UBUSAP', Procedure 'sp_restore_system_role', Line 202: Insufficient result space for explicit conversion of INT value '100' to a VARCHAR field. (return status = -6) |
| 720659 | There may be very slow optimisation of queries with large IN clauses or excessive stack usage with aggregate queries with large IN clauses. |
| 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. |
| 720971 | On ASE Cluster Edition, a user connection may not execute the global login trigger. |
| 720980 | In rare circumstances, ASE might report a signal 11 (SIGSEGV) in collectMonCSInfo() when querying the monCachedStatement MDA table. |
| 721003 | When downgrade from 157ESD#3 or later version to pre-155, downgrade prepare step will fail with error message "ERROR: Cannot downgrade to '15.0.0.0' server, which does not support bigdatetime and bigtime datatypes." |
| 721093 | The informational error 16833 was added to extend parallel diagnostics. This error provides a CSMD point to dump the system state at the point that parallel primary error processing begins. At this point, all of the parallel family's state is available for diganostic analysis. |
| 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. |
| 721500 | ASE is not able to boot with more than 50 thread pools |
| 721559 | On AIX, if ASE threaded kernel mode is being used, then ASE may report a SIGSEGV in mda_nap_start along with a "Scheduler infected: exiting" message in the ASE errorlog. |
| 721594 | If plan sharing is enabled, an error 8210 "Duplicate of work table descriptor found in the id hash table for temporary object < n > ." with stacktraces including des_wkinstall() and crt_work() may be encountered. |
| 721620 | Msg 2601 duplicate key on 'sysindexes' with unique index 'csysindexes' when dropping and recreating constraint on a partitioned APL table changed to DOL locking scheme. |
| 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. |
| 721781 | The value of the 'status' column of most rows of system group in 'sysconfigures' table will be changed from 2 to 386 when upgrading to 15.7 ESD#2 or later version. |
| 721889 | When either 'streamlined dynamic SQL' or 'enable functionaity group' is configured and a client cursor containing host variables is declared through embedded SQL, and the cursor statement references the same host variable more than once, an error like: -201 : Prodecure < procedure_name > expects parameter < parameter_name > where < parameter_name > is the name of the host variable that appears more than once in the cursor-declare statement, will be generated. |
| 721959 | Literal auto parameterization of large IN lists may cause performance issues. Trace flag 7786 was introduced to turn off literal auto parameterization of queries with large IN lists ( > 128 constants) as well as avoiding caching of the respective statement. Trace flag 7786 only has an effect if literal auto parameterization is turned on i.e. if literal auto parameterization is turned off, then the statement will still be cached. |
| 722535 | On Windows 2012, using syconfig, the backup server does not start when using the default backup server name. |
| 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. |
| 722709 | The values of the SharedLockWaitTime, UpdateLockWaitTime and ExclusiveLockWaitTime columns in the monOpenObjectActivity table are incorrect when the DBID, ObjectID and IndexID parameters are fully specified in a query on the monOpenObjectActivity table. |
| 722767 | The remote backup server name length for DUMP/LOAD commands has been expanded to support more than 30 characters. |
| 722777 | ASE does not respond and appears to hang when invalid packets are sent to it. |
| 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. |
| 723026 | In rare circumstances, a stack overflow resulting in stack corruption may occur with a stack trace involving the modules 'XmlMallocFragment' and 'xml_malloc_fragment' when an XML query is executed with insufficent heap memory. |
| 723116 | sp_sysmon spinlock contention values are incorrectly reported as zero. |
| 723250 | Granting an invalid permission to a user will cause the dataserver to print a stack trace and terminate the process. |
| 723268 | When granular permissions is not enabled and a user has sso_role if the user tries to online a database error message 2736 will be raised. When granular permissions is enabled a user with online any database privilege can not online a database. |
| 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. |
| 723756 | When hash based statistics gathering is used, the histogram tuning factor is not correctly reported by optdiag |
| 723861 | During ASE boot in "process" kernel mode, when configured with a high value for configuration parameter 'number of engines at startup', an engine fails to come online with 'ulinitspinlock' error. |
| 723880 | Column information is unnecessarily displayed when executing sp_help for an object that is not a view, system table or user table. |
| 723882 | When granular permissions is enabled a user can not online a database that needs an upgrade. The error message 969 will be displayed. |
| 723984 | Additional diagnostics have been added for hash based histogram gathering under trace flag 2740. |
| 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. |
| 724074 | If SET PROXY is used in a stored procedure, then an 4058 error "Login currently under set session authorization. It is required to go back to the original identity before performing another set session authorization." may be reported. |
| 724444 | Some web methods added with OVERRIDE clause need to be re-added when ASE WS is restarted. |
| 724987 | A 3475 error: "There is no space available in SYSLOGS to log a record for which space has been reserved in database < dbname > " may happen under rare circumstances along with the below message in the errorlog:"ERROR: Can't get a new log page in db < dbid > . num_left= < numlogrecords1 > num_in_plc= < numlogrecords2 > ". |
| 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. |
| 725885 | srvbuildres cannot configure ASE when the available free space on the disk is very large. |
| 725956 | If a previous Job Scheduler configuration failed, syconfig.exe and sybatch.exe do not re-install the ASE-15_0/scripts/installjsdb script in a rerun. |
| 726003 | In the cases of extreme heavy loading, it is possible that CREATE CLUSTERED INDEX in parallel on a big table causes a small volume of data to be lost. |
| 726004 | On Solaris SPARC, HP-UX and AIX systems an incorrect result may be reported when executing sp_tran_dumpable_status < dbname > . |
| 726763 | The command ALTER DATABASE LOG OFF can result in the error 5057 ("The free space counts for the log are incorrect ...") being raised if the database has been loaded from a database dump where the command ALTER DATABASE LOG ON was run initially to extend the log. |
| 726770 | In rare cases of extreme heavy loading, it is possible that BCP/SELECT INTO a big table might lose allocation page entries from the OAM. |
| 726957 | The message "current process infected with 11" in the module 'ksct_startio' together with a stack trace which includes the modules 'ra_init_rs' and 'ra__connect_server' may be reported in the error log when the Rep Agent Thread attempts to open a new connection to the Replication Server and a previous connection attempt has failed. |
| 727259 | A 9284 error, "RepAgent( < dbid > ). Cannot allocate < value > bytes of memory. You may need to reconfigure the parameter 'replication agent memory size' with more memory.", followed by a 9219 error, "RepAgent( < dbid > ): Internal coding error. Rep Agent Thread for database ' < name > ' (dbid = < value > ) terminated abnormally with error. (major 92, minor 19)" maybe be reported in the error log if the Rep Agent Thread is recycled many times and compressed data is replicated. |
| 727475 | If the user is granted system roles indirectly through a user defined role, execution of sp_addthreshold fails with error message 10353 "You must have any of the following role(s) to execute this command/procedure: ' < names > ' . Please contact a user with the appropriate role for help." |
| 727884 | Downgrade to versions lower than 15.7 ESD#2 will not remove the predid column from sysprotects.csysprotects. sp_fixindex or dbcc reindex will not change the index to the pre 15.7 ESD#2 definition. |
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#4, ASE 15.7, ESD#4, ESD 4, 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.