Switch to standard view 
  Sybase logo
 
 
 



Targeted CR List for ASE 15.7 ESD#4

The purpose of this document is to help Sybase customers obtain a general idea of potential bug fixes in future Adaptive Server Enterprise (ASE) EBF releases. Please be sure to read the Disclaimer and General Notes below.

If the EBF has been released, check the CR list and coverletter at the sybase.com EBF/Maintenance site: http://downloads.sybase.com/swd/base.do

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

Bug IDDescription
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 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.
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.


Back to Top
© Copyright 2010, Sybase Inc.