Switch to standard view 
  Sybase logo
 
 
 



Targeted CR List for ASE 15.0.3 ESD#3

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
367477 New Feature: User-defined default execution attributes.
374892 When User create record session without enable "sybase_script", Recording into ASE database not working.
394542 Dump / Load command having archive device name with newline character does not get parsed appropriately and causes segmentation fault in sybmultbuf.
429009 Occasionally on a multi-engine system, sp_monitorconfig "Active procedure cache" values might be higher than configuration value
461451 change the description for the IndexID column in monCachedObjects table.
469817 DDLGen: DDLGen incorrectly generates foreign key contraints for tables that do not have any if the tables have a object_ids that match referencing tables in other databases.
470655 To remove the message of 'per object statistics active' configuration parameter required for monProcessActivity table.
475139 allow concurrent access to the table while doing Reorg Rebuild or creating clustered index
497292 ALTER DATABASE might take an uneccessarily long time to complete the extension of a large database when the database has been extended over a boundary that is a multiple of 63 GB.
497750 Newly added audit options are not removed when downgrading from 15.0.2 to 15.0.1.
499982 The message, "Current process infected with signal 11 (SIGSEGV)", may be reported in the errorlog together with a stacktrace which involves the modules '_StTcCharacterSample' and 'StTcMrgBnds' when executing a SELECT query with an IN list on encrypted columns.
500474 In rare circumstances, Adaptive Server may give a time slice error with a stack trace which contains modules 'cm__check_page_range' or 'cm_choose_buffer_pool'.
529026 During instance startup, a set of three messages is logged, if a secondary interconnect is not defined for the cluster. Messages are: "The cluster interconnect protocol has not been defined in the cluster input file", "Cannot resolve host name '' for the local interface of the link to monitor", and "Cannot resolve host name '' for the remote interface of the link to monitor".
530473 Under rare circumstances, dbcc checkalloc might report a 2525 error: "Table Corrupt: Object id wrong" with "objid in ext=0" following an ONLINE DATABASE after loading two or more transaction logs.
531631 In rare circumstances, datatype field in c6 column in sysstatistics FMT_COLUMN formatid row might be corrupted during upgrade during online database after the database is loaded across platform where byte-order is different, if the table has more than 255 columns.
531785 Add option to remove server entry after disconnecting from ASE.
532777 sp_configure may encounter error message 10840 with error message, "Internal error, FDP API, fdp_get_memory(): Failed to allocate 2097061 bytes.", in the errorlog.
540665 Query performance may be affected on queries involving private temp tables for which optimizations are based on some magic numbers when statistics are not explicitly updated on the tables. An option is provided to implicitly generate statistics for private temp tables. The statistics are kept in memory until the temp table is dropped. Traceflag 2716 is used to turn on this option. Note that external tools such as optdiag and sp_modifystats will not affect the in-memory statistics. The feature does not support regular, partitioned and proxy tables, as well as optdiag output, compatibility mode and DDLs in stored procedures when deferred compilation is turned off.
541233 In rare circumstances, a 834 error, "Illegal attempt to clean buffer" together with a stack trace which includes modules 'dbt_unreserve()' and 'cm_dbclean()' may be reported in the error log when dropping a suspect database.
544498 diagserver could run into assertion fail when 'enable stmt cache monitoring' enabled.
545416 Occasionally, when ASE write the logfile to dumpfile,"Error: I/O error, errno: 5 "may be reported in the errlog.
547118 A new builtin function is_singleusermode is created to determine if server is in single-user mode. sp_downgrade will force the server to be in single-user mode before downgrade is performed.
548235 When you run dump database command on ASE of sjis and Backup Server of eucjis, Backup Server outputs some Open Client/Server errors below and dump database command does not respond. Open Server Error: 16368.10.0.0 srv_senddone(): A message was initialized, but not completed
549423 If the PCI subsystem fails to startup then stack traces may be seen preventing ASE from booting.
551094 Attempting to retrieve data inserted using a deferred INSERT command for a table created with the "ignore_dup_key" clause and having TEXT columns may fail with a fatal 7114 error reading "Page < Page Number > is not a valid text page." together with a stack trace showing modules "sendtext" and "get_txtpage".
552026 Monitor Historical Server process memory usage keeps growing while recording a session.
552227 ASE does not check if the type of the supplied default value matches the type of the column at user table creation time.
552508 A new column "Transactions" has been added to the monState table
553163 dbcc stackused reports the wrong maximum amount of stack memory used on Itanium platforms.
553866 If built-in function like data_pages(), which accesses OAM pages is called on a table in temporary database while the table is being dropped error 677 may be raised.
554404 Incorrect information is displayed under "data cache managementt" section of sysmon report.
556134 The index checking of DBCC CHECKTABLE doesn't check the first row of every non-leaf page, so it can't check out the corrupt index if someone of first keys is bad.
556770 A 10334 error, "Permission related internal error was encountered. Unable to continue execution." may be reported in errorlog while running the DBCC CACHEDATAREMOVE command.
557592 Replicating data into an encrypted column that is bound to a domain rule fails with error 225. The same failure can occur when inserting data through bcp using the -C flag.
557939 Executing a query involving views and coalesce() may get error 4409 incorrectly.
560359 When using builtin function object_owner_id(), if the object name is longer than 30 bytes, the builtin could return wrong owner id for the object.
560776 PC Client 1503 ESD#1 Installer log.txt file show error message
560954 Feature request for a dbcc command to fix 100004 checkstorage faults (timestamp value in page header larger than database timestamp).
561626 A 8242 error "The table < table_name > in database < dbname > is bound to metadata cache ..." maybe raised when doing delete operation on a DOL table that is bound as hot object using DBCC TUNE 'des_bind' command.
561660 CREATE EXISTING TABLE command against MSSQL backend results in Msg 11213 if the remote column is defined with a DEFAULT clause. In the same situation, CREATE PROXY_TABLE fails silently and does not return any error.
561673 The builtin function valid_name() could cause stacktrace if NULL is passed as the second parameter.
561876 Sometimes, ASE terminates connection to the client after error 603, "not enough system session descriptors available" occurs.
562468 Incorrect referential interity (RI) check could happen for update/delete when there is mixed datatype equijoin between the RI column and another column. The similar mixed datatype equijoin under a view could also lead to wrong result when the view is joined to itself and has to be materialized into a worktable first.
562556 When upgrading the server which is booted with single user mode, upgrade utility was not able to perform. It required 4 connections to finish the upgrade work. And it can finish the work with only one connection.
562635 sp_dbcc_summaryreport is expanded to support the exclusion of faults registered in the dbcc_exclusions table like sp_dbcc_faultreport does.
562947 When a cursor is implicitly updatable, i.e. does not have a FOR UPDATE clause or a FOR READONLY clause, and at least one index is available, then a table scan will not be considered. This change will allow a table scan to be considered if there are no unique indices available. The change was placed under optcriteria cr562947 and will be on by default for 15.0.3 ESD #2.
563378 preupgrade utility should identify stored procedures that use depreciated function calls such as reserved_pgs().
564439 The message reported in the ASE server log when the sybpcidb database does not exist has been improved and now contains more information. The new message suggests that the sybpcidb database may be missing, or it may need to be initialized with the installpcidb script.
565273 signal 11 could happen in ResRelOp() during codegen when a constant expression from a view or derived table is SELECTed from an outer join view inner side and the constant expression is further participating in a simple WHERE clause (comparison involving other constant only) when the outerjoin view is queried.
565276 Under compatibility mode, traceflag 302 diagnostics might output "unnamed-col" for predicate printing instead of the real column name.
565484 Using a large value for 'max memory' and setting 'allocate max shared memory'=1 may cause the shared memory dump size to be much bigger than expected against SYBMON.
565752 Add ability to kill process querying syslocks table.
565877 Message 14623 doesn't provide enough info for users to perform corresponding operations to continue downgrade. It should provide more infomation like which objid and indid the row has.
566882 Modifying a segment's auto expansion attributes (grow-by or max-size) results a syntax error.
566981 Signal 11 in GtuUnion::GtSecondaryInit() may be seen in the error log and the spid terminated when selecting from a view containing a union all and the select includes > 1 variable assigment from the same column.
566990 sp_object_stats "00:01:00" does not produce output in version 15.0.x even if you have contention.
567239 Due to an issue with underlying dbcc checktable, sp_post_xpload can not detect all kind of index corruption, such as first key of one non-leaf page is bad. The new 'force' option of sp_post_xpload will force rebuild all the index except APL clustered index.
567355 ddlgen generates a redundant "go" between the two ENDs for dropping the primarykey and foreignkey
567466 If statement cache is turned on and exception is occur in compiling a statement with temporary tables in it, it could raise 8203 error sometimes.
567656 Monitor server hung on ibmplinux redhat 5.1 platform.
567766 RepAgent may send an incomplete multi-byte character in text data to Replication Server when the text data is longer than 4KB and starts with an XML declaration element and contains multi-byte characters.
567787 When statement cache and literal autoparam are enabled, a batch that contains \r\n (CR NL) sequence in the middle of two statements, the statement that right after \r\n sequence may not get correctly parameterized, offset may be shifted 2 bytes on the left.
567885 Fully qualified ASE table name in query causes exception in using DBISQL's Query Editor.
568659 Under rare conditions a query on the monOpenObjectActivity MDA table may result in a timeslice error.
568798 Under some circumstances, a signal 4 may be raised while calling ex_raise and ex_print.
568957 "ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received" may result when accessing data containing null bytes on an ASE server when character set conversion using Unilib is employed.
569171 A stack trace in the function, setGlobalIdentity, may be generated when an INSERT query is run and this query inserts into a proxy table that is created on a remote view and the remote view is created on a table that contains an identity column and the datatype of the identity column is not NUMERIC (i.e. it could be integer or smallint) and the remote view has an instead-of trigger for insert and the instead-of trigger contains a query that selects the identity column from the inserted pseudo table.
569523 If the interfaces file does not exist or contains no server entries, opening 'Job Scheduler Server' page of Server Properties results an NullPointerException.
569541 AFter changing the name of the table with sp_rename triggers defined on the table may no longer working.
569567 Allow UPDATE STATISTICS to be performed in a multi-statement transaction. Update statistics changes will become part of the transaction, and and all the work done by update statistics will be removed by any rollback. If a multi-statement transaction does not exist, then update statistics will continue to use internal transactions to commit multiple minimal atomic parts of the update statistics command which will remain even if the command is aborted. Trace flag 2720 can be used to continue with the pre-fix behaviour, in which case an attempt to run this command in a multi-statement transaction is disallowed with an error message.
569724 Update ASE startup reporting to recognise Windows Vista and Server 2008
569742 Logins folder's Full Name column was mistakenly removed.
569804 Logging SQL when an instance is shut down gets a NullPointerException.
569904 In rare circumstances, Job Scheduler might fail to run with the error "Incorrect syntax near '`'".
569940 Truncate table is not consistent when switching tables under 'suspend audit when device full=0'
569947 SELECT INTO using ISNULL builtin in the SELECT list could lead to target table column non-nullable while the early behavior of ASE would make the target table column nullable even when the ISNULL result can't be null for the query.
569969 Update DBISQL from version 11.0.0 to 11.0.1.
570117 Deleting a table with LOB columns (text, image, unitext) and non-datarows locking scheme under direct mode may hit SIGSEGV together with stack trace in the module of LeDeleteOp::_LeOpNext() if the query plan has merge joins.
570136 Restore the old behavior in ASE125 to use parallel sort while creating index on more than one output devices.
570307 Deferred compilation may cause unexpected parse errors when setting quoted_identifier on\off within a procedure defintion. (Error 102, 257 etc)
570345 Sybmon planprint could cause stacktrace.
570457 Stacktrace could happen during GroupInsert operator execution under compatibility mode for GroupBy query with a lot of aggregates.
570794 Execution of a stored procedure which creates a table with non-materialized computed column may sometimes result in a message "current process infected with 11" and the stack trace reported in the errlrog file if the procedure performs SELECT query on this table. This is likely to happen if a procedure query tree is renormalized. Stack trace may reference modules pre__replace_cpc and s_getTreeOrPlan.
570901 ASE 15.0.3, esd#1 HKGC, Error 12316 occurs repeatedly
570910 The message "storage access violation" in various XML related modules together with a stack trace which includes XML related built-in modules may be reported in the error log after an error 712 raised from a previous XML query involving a large XML document.
570931 On rare occasions a 605 error may be reported when BCP and UPDATE INDEX STATISTICS with sampling are concurrently executed on the same Data Only Locked table that has at least one non-clustered index present.
570986 GUI: while selecting a license key file, the default directory is empty if user specify an installation destination that does not exist.
571049 On HPPA64 and HPIA64 platforms, if Java in Database feature is enabled in High Availability system, during failback operation, "sp_companion resume" operation on the primary causes the secondary companion either to hang or die due to an internal error if PCI/JVM is active on the secondary companion. In the event of a hang, the system 'ps' command will show an extra server process running. That is, in a two engine system 'ps' would show three server processes rather than the expected two. If the error results in dead engine on the secondary companion, the error log will contain messages indicating the engine hosting the JVM has exited with a signal 11.
571072 Create Table or Alter Table with Case statement that uses an IN list or NOT column NOT IN list or the equivalent of those expressions in a computed column will cause stacktrace.
571615 SQL which concatenates at least two contiguous NULLs with strings may cause error 257. For example, select NULL + NULL + 'abc'.
571645 The message "current process infected with 11" in the module 's_free' with a stack trace which includes the modules 'kill_proc', 'metrics_dump' and 's_recompile' may be reported in the error log after killing a session that was executing a stored procedure which had to be recompiled and it was hang because transaction log was almost full and the configuration option "enable metrics capture" was set to 1.
571772 On linux platforms with jmp_buffer mangling, engine dies abruptly with the message "Engine exited with signal 11".
571924 Executing a query with compute clause may hit SIGSEGV together with stack trace in the modules of subparserr() and parserr2().
572133 Under some rare circumstance when ASE is unable to allocate memory for query execution the usual message for error 701 " There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache." is accompanied by the stack trace in the errorlog file. The stack trace will indicate modules LePlanRelease and LeParentOp::LeOpProcessIOStats. The issue will happen if options to display statistics were activated.
572163 Request new Backup Server verbosity level to disable "Connection from Server" messages.
572188 Drop in sp_addlogin and sp_role grant/revoke performance after an upgrade from ASE 12.5.3 to 15.0.3 ESD#1 on a ASE HA cluster.
572577 When the Properties button on Threshold page of Segment Properties dialog is clicked, an internal error occurs.
572796 Sp_addexternlogin does not work when the target server password has special characters e.g. "=". This can cause the sybmigrate process fail with an error like "Incorrect syntax near '
572959 Compiler Optimizations that rearrange code blocks will lead to (-)ve Keep count in the Partition descriptor.
572977 Run sybmon command "set" without arguments caused SIGSEGV.
573341 Index counters may not be updated in monOpenObjectActivity for a table
573619 On AIX when Sybase Central 6.0.0 encounters an internal error, an internal error message about missing libjysblib600_r.a is shown instead of the regular error dialog.
573639 The message "current process infected with 11" in the module 'memcpy' together with a stack trace which includes the modules 'LeRun' and 'LeJoinContext::computeVirtualCols' may be reported in the error log if a SELECT UNION ALL query is executed involving an outer join, a TEXT column from the inner table is selected and some NULL values are returned.
573897 WaitEventID(which is larger than 251) in monProcess is incorrect.
573933 Deletes over CIS to IQ may fail with error 11298. The 'DELETE' command contains syntax that requires it to use a cursor but ASE has disabled the support of updateable cursors against IQ.
574227 If the master database has a secondary truncation point set during an upgrade from 12.5.x to 15.0.x, then an error 950 (Database 'master' is currently offline. Please wait and try your command again later) may be raised. To avoid this issue, preupgrade or upgrade will report an error if there is a secondary truncation point set.
574264 In rare circumstances, the message "Current process (...) infected with signal 11(SIGSEGV)" together with modules like (bool PopEmit < SerialCost,SerialProps > ::emitMatchProperties, PopBase*OptGlobal::_GblAddTopLevel maybe be encountered for queries involving statement cache, literal autoparameterization, compatibility mode and OR terms.
574532 Permission denied error is being given on SET_APPCONTEXT when executing a proc.
574533 Sometimes users will see error message "JZ0R1: Result set is IDLE as you are not currently accessing a row." when accessing a ASE 12.5.x database
574724 Duplicate rows could be incorrectly returned when an EXISTS subquery is SELECTing from a DISTINCT view and not all of the view's SELECT columns are participating in the subquery's correlated equijoin predicates.
574771 A query having concatenated columns in GROUP BY clause may return the incorrect result if all the set of GROUP BY columns are unique to the result set.
575064 Procedural queries with optimizable LIKE clause may underperform executing more logical IOs than expected.
575080 DDLGen doesn't hide password when a space is supplied before the password.
575115 If there is a mismatch between the datatypes of the constants in the IN/OR list and the respective column, special OR strategy might not be used. ASE now provides a optcriteria 'use_mixed_dt_sarg_under_specialor' which when enabled, will allow special OR strategy to be considered in case of mixed datatype SARGs in the IN/OR list. Additionally, traceflag 434 has been provided to turn OFF this feature. The traceflag setting overrides the optcriteria setting.
575151 An infected with 11 error is raised with function LeUpdateOp::_LeOpNext on the stack when the tsequal function is passed a datatype other than timestamp.
575251 Wrong result may happen for a query if the SELECT list has an extended column which is not included in the GROUP BY clause and one of the group by columns has a constant sarg (col= < cnst > ) on it. Similar wrong result could also happen for an equijoin between a GROUP BY view/derived table and other table when there is a constant sarg in the view for the joining column.
575330 ASE stacktraces with signal 11 when the number of columns returned from a remote procedure is less than expected from the select list to a proxy table mapped to this remote procedure.
575337 Msg 7305: after execute select ... for update in a stored proc
575359 ASE assumes DC supports BIGINT datatype and incorrectly sends signed/unsigned NULL integer parameters as BIGINT datatype.
575392 Insert queries involving proxy tables which are either part of a trigger or will fire a remote trigger may crash at signal 11.
575675 Server always selects Slow Bulk mode for bulk copying rows into table with non-clustered unique index.
575946 The database option "no ckpt on recovery" is incorrectly turned on after load database command on master database successfully completes.
575993 Connect Dialog would not allow modified server entry if it's previously connected to the server before modification.
576295 There is possibility of segmentation fault during XPDL conversion of a page whose page header is incorrect with PG_DATA and PG_OFFSET bits set simultaneously.
576357 If a parallel plan is chosen for an AMC repartition operation, sometimes the data could be inserted into the wrong partitions.
576525 Database Wizard's (Add) Device Size Dialog does not sort device sizes correctly.
576647 If error 249 occurs during and it does not appear to be due to constant in the query and the query has not started execution i.e. compilation is still proceeding, then this error may occur due to expression histogram processing. This can be verified by looking at the optdiag output for the columns in the query, and determining if there is a possible conversion error that could occur with one of the histogram step values. The change in behavior will be to suppress the error and use magic numbers for the selectivity of that column when used in expression histogramming.
576708 Inserting a NULL value into a TEXT column of a proxy table with an INSTEAD OF TRIGGER may result in an assertion failure involving the module eval_locator_bi().
576895 INSERT into a VIEW which triggers an INSERT into the proxy table may cause error 3651 when the remote table also triggers a change in one of the column values being inserted.
577113 It's possible of deadlock on sysconfigures table if running two sp_configure at the same time.
577504 On NT platform, Monitor server didn't shut itself down when ASE is down
577525 When ddlgen is used to extract the DDL for an object, that contains a user defined datatype which has a default bound to the type, the DDL generated contains an extra sp_binddefault command that fails because the default already exists.
577680 ins_syn_sql incorrectly calculates free space on the default disk
577686 If two indexes on different tables have the same name and if output from DDLGen is generated just for indexes, then an attempt to run this generated output fails if the indexes have been deleted in the server after the DDlGen was first run for the indexes.
577711 Unable to connect to ASE using the reserved administrative connection when network password encryption (-X) is enabled.
577713 Sometimes, the message "current process infected with 11" in the module 's_handle' is reported in the error log along with errors 2601 and 546 while trying to insert into a table with foreign key constraints.
578157 Some stored procedures using temporary tables and trace 299 (forced open by name resolution) may result in stack trace. This happens if a procedure is frequently renormalized. Stack trace shows module lastleft.
578424 The message "current process infected with 11" may be reported in the error log together with a stack trace which includes the modules 'Optimize' and 's_compile' when executing an UPDATE statement involving a join between two or more tables and the table being updated has defined a functional index involving columns which are being updated with values from columns from the other table(s) participating in the join.
578662 If forceplan is used to force the use of a vhash index to scan the table in a join, a SIGSEGV or incorrect result can occur.
578692 when outer joins have inner tables which are derived tables with UNION operators then there is a possibility of a stack trace.
578874 Under rare circumstances ASE fails to compile statements in the deferred compilation mode.
578889 After ASE detects a 605 error on a DOL index, ASE does not report the 605 error again on the same wrong page until ASE restarts.
578991 There is a possibility that during bcp operation, some rows get corrupted as received from the network. But they safely make it into the database and corrupt the data pages and eventually corrupt the database.
579040 Segmentation violation occurs under stress conditions in artificial environment not seen with normal replication environment.
579044 ASE Plug-in and DBISQL's Connect Dialog encounters a syntax error setting a new password when the old password contains special characters.
579240 An error 209 with the message "Ambiguous column name" may appear if a stored procedure which performs the UPDATE or DELETE with the selfjoin is executed by the non owner of a procedure and the execution is performed using the deferred compilation mechanism.
579241 Under some rare circumstance related to the runtime recompilation of the parallel queries using expression involving LIKE and variables or parameters ASE may fail to generate parallel plan and report stack traces in the errorlog file. A trace will show modules copy__eval and copy__eoptlike.
579586 Query on monSysStatement table causes timeslice error with large statement pipe.
579962 Full index scans may be selected over limiting index scans in scenarios where there is a single or no rows in the table and the costings are the same for both indices. An index scan is "limiting" when the key's major attribute has a sarg on it. The full-index scan may be selected if it has a minor optimizable attribute and it's ID is less than that of the limiting index. IDs increase in the order of index creation. Full-index scan strategies were never considerend in pre-15.0. Setting the configuration parameter "mnc_full_index_filter" to 3 or enabling the optcriteria full_index_filter will eliminate full-index-scan strategies.
580042 sp_dbcc_configreport will report arithmetic overflow error for databases larger than 2.5TB.
580098 Select data from monOpenObjectActivity could cause timeslice when heavy load.
580264 XML- > sqlj functionality can regress if sequence of COTS JavaVM is out of order wrt conversion results.
580552 Under very exceptional circumstances a timeslice followed by ungraceful shutdown of the server due to the LDAP_SPIN spinlock being held may be seen involving the housekeeper whilst checking ldap configuration.
581043 Queries from complex views may return no results at all. Running with the diagserver executable shows an assertion failure in res_view.c: "unprocessed view found"
581347 Histserver memory usage keeps growing.
581380 Null clause is unnecessarily appended to the ALTER TABLE MODIFY command when it is not explicitly specified in the command statement, resulting in an Oracle ORA-01442 error. This issue is specific only for Oracle and a traceflag 11237 is used to enable this fix.
581422 Recompilation of stored procedures reporting TABMISSING\TEMPMISSING may be seen on case-insensitive servers under traceflag 299 if column names are not consistently specified as upper or lower case in the temp table definition between executions and table re-creation.
581724 During worktable creation, if we fail to access the tempdb, it may lead to sig-11
581748 After a dumped ase1254 database was loaded into an ase1503 server, if the database includes tables with encrypted columns which reference keys in other databases, onlining the database will cause a stack trace. The data is brought online and can be used.
581827 If literal autoparam is turn on, in some rare cases, isnull() builtin function could return different result comparing when literal autoparam is turned off if the parameters in the isnull() is either CHAR or VARCHAR datatype.
581984 In some cases, dbcc checkstorage may incorrectly report the soft error "100041 (Log free space discrepancy error): Current syslogs free space does not match what dbcc counted.".
582000 Reorg rebuild / create index on a table with a CI resets systabstats.datarowsize to initial default of average row length.
582171 In some queries involving distinct and temp tables, if we have "capture missing statistics" config turned on we might get a stack trace with error "closetable: called with null SDES".
582178 Selecting "Tools"- > "Adaptive Server Enterprise"- > "Preferences" results a NullPointerException when ASE Plug-in is running on a system with Spanish locale.
582344 Timeslice and stack trace contaning LeOperator*CgpNlJoin::cgpCodeGenTryNaryNLJ amongst others may be seen under rare circumstances when executing a query involving group by and aggregation.
582855 ASE errorlog contains "TPM FATAL 'unknown TPM error-level raised' for Task xxx in ThreadID yyy"
583896 Create Proxy Table Wizard sometimes gets ArrayIndexOutOfBoundsException after clicking Finish.
583910 If the either of the optcriterias mnc_full_index_filter or full_index_filter is enabled, then explicitly updateable cursors (declare statement contains and update-clause) and dirty reads on APL tables could lead to a 311 error: open mycursor Msg 311, Level 16, State 2: Line 2: The optimizer could not find a unique index which it could use to scan table 'mytab' for cursor 'mycursor'.
584139 The dump command does not raise error message for "No space left on device" on Linux when the device is closed.
584149 Simultaneous load operation with same archive device name fails with 'Device already in use' error.
584292 Statements that use the application context builtins such as set_appcontext() while the statement cache is enabled may result in Error 4060.
584296 sp_displayaudit with "login" option fails with 18004 error on 15.0.x
584298 BY default, dbcc checkalloc( < dbname > ) turns on traceflag 3605 with SERVERWIDE scope. This can cause other processes in the ASE to unexpectedly write messages to the errorlog while the checkalloc is running.
584342 ASE may crash with Signal 11 at CtlibRemoteCaps::generateConstant when it runs out of memory.
584467 During execution, if "run script" options is selected for Fix Statistics or QPTune Wizard, a stack trace occurs preventing the execution to finish.
584552 If an insert parameterized language request with certain Numeric values is sent to the dataserver and statement caching is enabled then a segv occurs. A regular statement is fine with the same values.
584770 For srvbuild, the default available physical memory value of OOB task is shown as 80% of RAM even if this value is larger than the "max shared memory" set on the operating system.
584851 If a query involves an extended column (a GROUP BY column which does not appear in the select list) and if the select list includes an encrypted column, the execution of the query will hit a stack trace reporting a null encryption key. An exemplary query is: table t2 (a2 int, b2 int encrypt with key1) select t2.* from t1, t2 where t1.a1 = t2.a2 group by t1.a1
585079 When an instead-of trigger contains a query that accesses the inserted or deleted log tables and the schema counts of the view upon which the instead-of trigger is created and the log (syslogs) do not match, a 11060 error may be raised, resulting from too many (10) attempts to recompile the query plan without succeeding.
585168 Performance issue might be hit for a query with up to 5 joining tables involving cartesian products and/or theta-only joins.
585260 Unnecessary recompilations may happen if 'open by name' trace flag 299 is activated and a temporary table has at least one BIT column.
585467 Despite traceflag 11906 being on, reorg rebuild messages are reported to the errorlog.
585517 When a user with sa_role executes SETUSER to a non-sa_role user, creates a table and a procedure referring to that table, then execution of that procedure following a schema change such as dropping and recreating the table will result in an "object not found" error (Msg 208).
585665 Feed back optimization opened exception code shortcomings under the PCI Bridge (COTS JavaVM Integration) under AMD64 platform architectures. These code shortcomings are very severe and easily lead towards memory corruption when JDBC or Java Stream operations are invoked from ASE Tasks.
585991 Set switch command does not work with traceflag 7714 ad 7715.
586167 Automatic workspace expansion in checkstorage does not expand the text workspace automatically even though the text workspace is smaller than the recommended size, which is 25% the size of the scan workspace.
586220 The error msg 414 could be raised if the plan chose reformatting strategy and it has many join predicates.
586356 For queries containing IN/OR list s.t. one or more elements in the IN/OR list is a function then unexpected results might be returned.
586425 When running on a Unix system, BCP Wizard cannot BCP in/out multiple tables.
586565 Dump / Load operation failing to open the device may not report the Operating System error.
586779 The dump command may not raise an error message reporting "No space left on device" on Linux when the device is closed using Backup API compress.
587437 When using parallel sort on worktable, several issues were encountered while executing sort operator.
588464 Sometimes, database upgrade fails with error 1204, "out of lock error" while upgrading a system table with huge number of rows.
588594 When the optimizer chooses a query plan that includes and Nary-Nested-Loop Join Operator (as seen in showplan output) and at least one of the Scan Operators under the Join is doing dynamic partition elimination (also shown in showplan), the query may return too few rows. This problem ocurrs in queries with at least three tables and which contain join predicates involving columns of the partitioned table that are not part of the partition condition of that table.
588703 Some of the qualifying rows could be missed by an UPDATE statement using at least 2 tables other than the updated table (either directly in the UPDATE statement's FROM clause or within EXISTS/IN subqueries) and the join of these 2 tables involves an expression which contains one of these tables' columns which is also in the UPDATE's SET clause to compute the new values.
589061 TEXTPTR() builtin function may sometimes return truncated result. Pending zeros are removed.
589473 When parallelism is involved, some queries having more than 6 tables may timeout earlier during plan enumeration resulting in merge joins plan that uses excessive tempdb space.
589657 With SQL Replication enabled queries with CASE constant expression that is expression which is not referencing table columns may fail with error 401 "Invalid operator for datatype op: = type: MAINTENANCE TOKEN" or error 551 "An unknown EVAL was sent to the execution module."
589674 Sending a Java object using Java/JDBC on the client-side can result in a corrupted object stream being stored in a database table.
590395 The JVM dies with error 143 when the user logs off from Windows OS running ASE.
590604 When the view is redefined during the deferred compilation the ASE may fail during the redefinition process. Stack trace will be logged in the errorlog referencing modules like vu_redefine, col_open_range.
590760 A transaction dump that has a DROP and CREATE index commands logged for a clustered index with sorted_data, max_rows_per_page and fillfactor options used, may result after load in a corrupted table where errors 692, 605, 2509, and 2525 could be reported.
591217 The ASE server could potentially dump core in final stages of a server shutdown under the condition of stale PCI Bridge arranged JavaVM activities. This error is not a dangerous or worrisome event but the core files as left are ugly and consume lots of file system space.
592022 The message "timeslice - < number > , current process infected" together with a stack trace which includes the modules "dbts_insert", 'dbts_commits_addxdes', 'xls_test_set_lrdata' and 'ha_session_dealloc' may be reported in the error log when CHAINED transactions are used in and HA environment.
592026 Introduce configurable control for allowing or disallowing loading native libraries from within the PCA/JVM using the load and loadLibrary methods in the java.lang.System and java.lang.Runtime classes.
592603 When compatibility mode is enabled and a stored procedure is executed, ASE may stacktrace in the function ind__itagsetup(). This happens if a query in a stored procedure refers to a table that is created and dropped inside the stored procedure and that stored procedure happens to recompile after the table has been dropped.
592605 ASE may report 3474 and 3478 fatal errors if bulk-insert ctlib application making use of multi databases transaction needs to rollback.
592737 After CR 531964 changes, sysprocesses.physical_io maps to piotot which is only incremented at the end of each statement because of which monProcessActivity had to be used for tracking i/o activity for running query. The physical_io should report pbufread\pbufwrite which are incremented as each i/o completes.
593117 Unexpected errors may happen as a side effect of the compilation of SELECT INTO #TABLE statament. Errorlog will report module s_normalize. Also under some very rare circumstances on a heavy load systems a risk of random memory corruptions exists.
593582 In rare circumstances when using 'SET ROWCOUNT' option or 'TOP' directive with 'SELECT INTO' executed in the parallel mode the rows may fail to be inserted.
594204 When dboption "dbo use only" is set, the database owner executing sp_adduser may result in an access error (Msg 923).
595825 Duplicate rows may be inserted into a table that has a non-unique clustered index and that has one or more BIT columns even though the option, allow_dup_row is not set. For duplicate rows to be inserted, the total number of BIT columns in a row must not be an exact multiple of the number of BITs that can be stored in a BYTE (8) - this is a necesary, but not sufficient condition.
595988 If $SYBASE starts with /net, srvbuild[res], sqlloc[res], and sqlupgrade[res] report error: unable to load localization file < path > .
605811 After the command 'set proxy' is executed, RepAgent still sends the original login for replicated transactions instead of the new impersonated login. As a consequence, when replicating DDL commands, objects might be created with a different owner at the replicate site.
607467 In some rare situation, if a plan has groupinsert operator, it could raise 613 error.
616224 Like pattern matching may return fewer rows when the following conditions are met: 1. server's default sortorder is non-binary single-byte sortorder 2. like pattern is a constant literal 3. like pattern string length is the same as column data length 4. column is either varchar or char


Back to Top
© Copyright 2010, Sybase Inc.