Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 

 
 
CLICK TO EXPAND NAVIGATION
CLICK TO EXPAND NAVIGATION
 
 
 
 
Support > Technical Documents > Document Types > Technote > Targeted CR List for ASE 15.7 SP130  
RSS Feed
 
 
 

Targeted CR List for ASE 15.7 SP130

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 ID Description
448907 Adds the PREPARE DATABASE command. This command is very similar to the QUIESCE DATABASE command, with the exception that it does not block write activity during the HOLD phase. The HOLD/RELEASE options can be used to execute a mirror split or snapshot on the database using a certified agent, to create a copy of a database on which transaction logs can be loaded.
618245 UPDATE STATISTICS on a proxy table with a specified column may return error 12814 - "Failed to write information in SYSTABSTATS."
645898 In rare circumstances, after configuring a big data cache or a large stack size, SAP ASE might implicitly shut down following a JavaVM crash while executing a Java query. The message EXCEPTION_ACCESS_VIOLATION or 'ExceptionCode: c0000005' will be reported in the SAP ASE error log.
664848 In rare circumstances, the message "current process infected with 11 (SIGSEGV)" in the module 'ind__get_sysindrow()' together with a stack trace which includes the modules 'getindexname()' and 'CgGenLava::CGConsScanOp()' may be reported in the SAP ASE error log. This may happen when a statement, using temporary user tables or tables created in the same batch or stored procedure and with indexes defined, is being compiled before execution.
678527 In some long running ASE servers, an 8203 error - "Expected to find the descriptor for object < objid > in database < db_num > in < state > state." might be raised with crt_main in the stack trace while creating a temporary table. There will be an information message "INFO: Total Object Ids in temporary database generated: < total id count > , LWPs generated: < LWP id count > " printed for every 100 million object ids generated
684459 On AIX platform, the mapping of addresses to function names in SAP ASE stack traces has been improved. This will provide a superior mapping when the address is in a shared library.
689004 Setting the configuration parameter 'send doneinproc tokens' to zero, can cause the global variable @@rowcount to report an incorrect value inside a stored procedure or trigger.
697129 Supporting Lock Remastering for SAP ASE Cluster Edition. When the master assignment is set to affinity mode, the masters will gradually get re-allocated to the instances that initiates the lock convert requests, if “enable lock remastering” is set to 1(ON) in the configuration file. By default, “enable lock remastering” is set to 0 (OFF). It is not recommended to set “enable lock remastering” to 1 (ON) for badly partitioned cases.
708830 sp_dump_history returns error 17152, version missing or invalid, when dump history file does not exist.
710057 The timing and IO metrics in monCachedStatement for running queries were unchanged until the query completed. Four new columns have been added to provide intermediate updates. The new columns are called TotalLIO, TotalPIO, TotalCPUTime and TotalElapsedTime.
715312 Use of online utilities like 'reorg rebuild with online' might lead to incorrect used/unused counts in the OAM for the table. This is reflected by a later 'dbcc checkalloc' on the table reporting error messages 7949 and 7940.
718398 Update statistics options are 'sticky', meaning previous values which are explicitly set will continue to be used for future update statistics and create index commands on the same table if these options are not specified. These sticky options are: step count (using step values); histogram_tuning_factor; sampling; hashing, partial_hashing, no_hashing. This CR implements a configuration parameter "enable sticky statistics" to control statistics stickiness server wide. The default for "enable sticky statistics" is 1, which matches existing sticky statistics behavior. To turn off sticky statistics, use: sp_configure “enable sticky statistics” , 0
718733 Support a 'WITH RECOMPILE' clause at the statement level.
725864 Improve "ddlgen" performance for generating ddl for schema objects
725872 Print extra information for home location of DOL forwarded rows in DBCC PAGE output.
730051 When REORG REBUILD WITH ONLINE is running in parallel with DMLs, DMLs may fail with a 540 error - "Schema for database object ' < name > ' has changed since compilation of this query. Please re-execute query.".
730280 12308 error with delete or update against table in a query with distinctness e.g. joining to a distinct view or distinct derived table, and exists subquery, a union view or union in a derived table. changes associated with optcriteria cr669847 are enabled by default, but previous behavior (i.e. turn on fix only if optcriteria cr669847 is on) can be obtained by using trace flag 16987
730906 Isolation level 0 queries occasionally fail with errors when REORG REBUILD WITH ONLINE is in progress concurrently on the same table.
732258 DBCC UPGRADE_OBJECT with the "check" option may raise bogus 11031 (Execution of < type > < name > failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate < name > ) errors on every object checked after it encounters an object with an actual error.
732613 The Job Scheduler fails to start if quoted_identifier property is set for the connection (which is used to start the Job Scheduler). The following error is logged in the SAP ASE errorlog: "Job Scheduler: IS_ISQL_EXT failed [set nocount on use sybmgmtdb print ":s: %1!", "sybmgmtdb"]"
733579 The unreserved page count might be off by the number of pages of the table SYSDAMS if SAP ASE uses the OAM pages to calculate the free space counts. The database fragments containing pages of the system table SYSDAMS will show the space used by this table as free.
735692 The function row_count() when used on system tables returns zero after upgrade from SAP ASE 12.5.4
735863 When running optimization goal allrows_dss it is possible that an incorrect aggregate result may be returned in rare circumstances involving a derived table or view containing a union all with the aggregate operating on a constant in the select list on at least one side of the union all.
736622 When running REORG REBUILD against a table whose name or any column name might form part of a reserved double or triple keyword phrase it is possible for an error 156 error to be reported along with error 11934 and for the REORG REBUILD command to abort.
740079 Log the full sql text of the string passed to execute immediate in the monSysSQLText table. This is only available when traceflag 8391 is enabled.
740635 In rare circumstances, when running TRUNCATE TABLE on a very large table, the table does not show up on monProcessObject.
740814 There are missing VA information in some Lava plan operators when using show_cached_plan_in_xml().
741021 Buffer pool wash size increments unexpectedly for user defined caches when remote node is booted
742031 Shutting down an instance may cause a stack trace if I/O fencing is enabled.
743433 Performing decryption of encrypted column data can be much slower for standard users when decrypt default is used.
743558 Error 14613 (The ' < name > ' field in usage anchor has ' < n > ' which does not match with ' < n > from sysusages. Dbid ' < id > '. Lstart ' < n > '.) formats the last 4 parameters incorrectly so the output appears garbled. The field name is correct.
744541 Assertion (ISUSERTABID(objid)) fails in the function xact__getdlm_fromxdes() during upgrade when running diagserver.
744807 LPAD function will left-pad the input string with a specified pad to a supplied number of characters. RPAD function will right-pad the input string with a specified pad to a supplied number of characters.
746101 When using sp_downgrade to downgrade an SAP ASE from version 15.7 or higher to an SAP ASE that is version 15.5 based, the keycnt in sysindexes for index sysattributes.ncsysattributes will become incorrect.
747168 A 702 error, "Memory request for NN bytes exceeds the size of single page of 16384 bytes. ASE is terminating this process", may be reported when using queries with tables that have more than 4192 partitions.
747591 MERGE into statement with columns having decrypt defaults in their ON clause may not produce expected results when the user does not have decrypt permission.
747948 There may be inconsistencies in the values reported between the monProcedureCacheModuleUsage and monProcedureCacheMemoryUsage tables.
748569 When the EQUALS_SCAN_SUPERSET optcriteria hueristic is enabled, it would not apply in the case that the index with no positioning equi-sargs exist (i.e. a full index scan). The heuristics should apply in this case if the more expensive index covers all the equi-sargs of the former index, and includes positioning equi-sargs as well. optcriteria cr748569 will support the enhanced functionality to heuristic optcriteria EQUALS_SCAN_SUPERSET. Related to this enhancement to the EQUALS_SCAN_SUPERSET is optcriteria cr763859
748689 Add support for single instance user databases for the SAP ASE Cluster Edition.
748851 'Invalid pointer value' error messages may occur when a non-database owner accesses the SAP ASE database.
749046 INSERT SELECT does not support LEVEL0 scan. This is a new functionality request, to allow INSERT SELECT to support LEVEL0 scan.
749058 In rare circumstances on a heavily-loaded Server, the message "current process infected with 11" together with a stack trace which includes the module 'mda__tc_scan_mempool' may be reported in the error log when table monTableCompression is accessed.
749080 When using date_diff with smalldatetime and varchar arguments, a bigint may be returned.
749097 If update statistics is used on a table with a large number of partitions (e.g. 1000), then the performance declines significantly, and an inordinate number of log records are created.
749267 DBCC TABLEALLOC needs to scan allocation pages of the database several times, when used like 'DBCC TABLEALLOC(name, full, fix)', it may partially cause the command run a long time. DBCC CHECKALLOC has same performance issue.
749449 If dump history file is manually edited and the first line becomes blank, the file is assumed to be empty and then is initialized.
749712 FR: db shrink warning if not enough space available. Adding this as a part of the checking done by "alter database ... with check_only"
750317
750500 Stored procedures with application context functions take a very long time to execute because SAP ASE accesses system catalogs each time for protection checks.
750883 auto_temptable_stats will automatically generate in-memory statistics on a #temptable column on the first optimizable statement that needs statistics on that column. However, the statistics are not regenerated after a subsequent INSERT/DELETE/UPDATE or TRUNCATE table command. The optcriteria or traceflag 12801 will delete all in-memory statistics on the respective table so that up-to-date statistics will be generated on the next optimizable query referencing the respective #temptable. Note that the ase_current optimization level will not enable this functionality. In order to enable this functionality, explicitly execute "set cr750883 on", or define a user defined optgoal that includes this optcriteria, or enable trace flag 12801 on server startup.
750937 Sometimes a long running transaction can be seen in tempdb for $sort_local which results in tempdb filling up if a large data set needs to be sorted.
751067 DELETE not using row limit optimizations The optimization is enabled by optcriteria.
751192 A 9022 error, “Cannot deliver a command from < connection > . < database > since no transaction is open.” may be reported in the SAP RS error log, when the SAP ASE RepAgent is configured to use the ‘Multi-Path Replication’ feature and while a DML command is rolled back in ASE resulting in the replication stream to fail.
751510 If any online utility is running and HK_GC fails to get DES, it gives rise to an 8233 error (" < name > operation is in progress on the object ' < obj > ' in database ' < dbname > '. Retry your query later."). If traceflag 2792 is ON HK_GC will wait there, which may then cause an undetected deadlock.
751924 A 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization" may be reported when SET ANSINULL statement is used inside a batch containing other statements.
751933 When HADR is enabled, a graceful shutdown of the primary server requires that its state be inactive and the transaction logs be drained unless the new shutdown option 'nowait_hadr' be used.
752115 When the SAP ASE kernel mode is configured as process and an SSL session/connection is abruptly killed/aborted, a SIGSEGV (infected with 11) with a stacktrace may be reported in the SAP ASE errorlog. The functions drop_connection() and ssl_nclose() are likely to be seen as part of the stacktrace.
752170 The ASE COTS JavaVM version is updated to version JRE 7 update 55 for each supported platform in the sybpcidb database.
752211 Error message 3128 "The dump image specified does not contain information for any of the database devices" will be printed when a transaction dump generated by sybdumptran is use with the command LOAD DATABASE ... WITH LISTONLY = CREATE_SQL"
752352 In some rare cases, in SAP ASE Cluster Edition, when one of the nodes goes down and FAILOVER recovery starts on the other node, a deallocated page can be wrongly brought into the cache. An INSERT which is fired after recovery has completed can pick up this deallocated page and insert into it. This may result in 7928 or other index corruption errors reported from DBCC CHECKTABLE.
752415 Forcing an index on one table, where the query has more than 6 table joins and the configuration parameter 'enable deferred parallel' set to ON, can cause an infected with 11 (SIGSEGV) to be reported in the SAP ASE errorlog with a stacktrace involving ResVector::getScalarSum or GtgGroup::GtSecondaryInit
753035 When merge partitions for table with local indexes, if index rebuild on parallel, error message 14108 will be raised.
753036 There is an incorrect assertion that hits with diagserver during rebooting the server if server crashed during online reorg rebuild.
753140 The message "current process infected with 11" in the module 'plc__discard' together with a stack trace which includes the modules 'xact_endupdate' and 'reorg_main' may be reported in the error log during 'REORG REBUILD < table > WITH ONLINE' while this command is executed on a system where high concurrent DML activity is happening on the same table. Alternatively this error can occur during a high concurrent DML activity in a low durability database.
753175 The database level replication status may become inaccurate after changing the replication status of tables or stored procedures while the secondary truncation point is not set.
753525 SAP ASE running on Unix/Linux platforms only prints the top 25 stack frames in a stack overflow stacktrace report which could mask the root cause and also provide insufficient diagnostics when a stack overflow is caused by a recursive function. If the stack overflow backout code uses too much stack, the backout process can cause stack guard word corruption resulting in server shutdown. This CR removes the limitation on number of frames in the stacktrace and if the stack overflow backout code use of the stack reaches within 4K bytes of the stack boundary, it then initiates forcible termination of the task to prevent stack guardword corruption. The default value of 'stack guard size' is increased by 4K bytes to retain earlier level of stack availability. Traceflag 3687 provides a stacktrace when a transaction is aborted due to insufficient stack space that can provide additional diagnostics on stack usage by the query. Traceflag 3686 disables this change. This change is not applicable to the Microsoft Windows platform.
753577 ASE with SSL configured and using CIS may hit SEGV in np__validate_servername() which would bring down the server.
753695 If a stored procedure is compiled in deferred compilation mode and when a compilation error is raised, it could cause stacktrace with SIG 11 and other unexpected error message.
753704 If quoted_identifier is ON and sp_hadr_admin primary is executed, next time HADR primary server reboots as standby, instead of primary.
753956 When an insert trigger exists on the target table of the MERGE statement, the wrong result may happen.
754255 A 331 error, "Query is too complex and has exhausted the name space for Ordering IDs, please breakup query into simpler components.", may be reported during a complex query with multi-tables especially using aggregates and allrows_dss optgoal.
754273 Client connections to SAP ASE may hang when SSL is enabled and the network memory pool is exhausted.
754283 Backup Server on HPUX may die with error messages: A00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 1, error code=0, system message=Pipe I/O returned 0 bytes. D00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=0, system message=Pipe I/O returned 0 bytes while trying to print out a legitimate API error.
754508 The message, "Current process infected with signal 11", followed by a stack trace that includes the modules def_insert() and xls_sessionid() may be reported in the error log when an INSERT query is run in DEFERRED mode.
754542 Under some rare condition, an infected with 11 (SIGSEGV) error in the function querytuning_ins_sysoptions() may be reported in the SAP ASE errorlog.
754622 Performance of concurrent insert is slow.
754648 The message, "Current process infected with signal 11", followed by a stack trace that includes the module mda_fill_and_send_monProcessStatement() may be reported in the error log when running a query of the form SELECT ... INTO temptable.
754792 SAP ASE may enter a CPU intensive loop after a SIGSEGV (infected with 11) at ktMuxThreadTick+0x24d with the following seen in the errorlog: "Returning from kmultimap_iterator_cleanup with lock held" and "Attempting to return from utpApplyAll while holding a multimap read lock (0x < address > ). The lock will be released"
754856 When we try to alter temporary table for the database which has proxy database mapped on secondary companion, we hit error 177: CREATE PROXY_TABLE cannot create a temporary object (with '#' as the first character name.
754928 Partial Index support
755230 For tables with several indexes and TEXT/IMAGE/UNITEXT columns, a 605 error, "An attempt was made to fetch logical page < page id > from cache < cache > . Page belongs to database < db > , object < object > , index < index > , partition < partition > and not to database < db > , object < object > , index < index > , partition < partition > .", may be reported when running 'SELECT...INTO...FROM ... WHERE condition1 or condition2 or ...' command on it with concurrent DELETE/UPDATE/TRUNCATE TABLE commands.
755287 An assertion will occur if encrypted columns is enabled and there are external passwords that need to be recreated.
755330 When using LDAP, an assertion message and a SIGABRT/SIGIOT (infected with 6) stacktrace may be reported in the SAP ASE errorlog. The assertion will say "result == SYBCSI_RESULT_OK, file core/source/csimemory.c". The stacktrace will include the function login__ldapauth().
755424 When RepAgent is configured for Multiple Paths Replication and verbose LTL traces are active through Repagent traces 9201, 9227 and 9228, a SIGSEGV may occur together with a stack trace showing the module ra__sender_ltl_cmds.
755454 When migrate from ase155, Sybmigrate fails at report session and shows error: There are still external logins for the server 'mtrs$999'.
755465 Dynamic SQL with LOB parameter which results in a character set conversion for a single, very, very large text field can raise a 712 error (out of heap memory). Avoidance of the 712 error involves using a workaround that avoids the large text field character set conversion altogether. When the error is invoked by a Java program, instead of by batch mode processing there can be a large memory leak of the heap memory for the connection. That memory leak is addressed by this CR.
755473 The DUMP DATABASE command may hang when run concurrently with a many other tasks if the option 'optimize dump for faster load' is set to a non zero value.
755520 A signal 11 may occur in LeScanOp::LeGetScanInd (called from LeOrScanContext::getNextVtup)when 'streamlined dynamic SQL' is turned on and the query contains ORed joins and one of the outer table's join columns contains a NULL value.
755558 The message "timeslice -501, current process infected" in the module 'ra_ms_get_object_filters_for_path' together with a stack trace which includes the modules 'ra__ms_apply_repfilters' and 'ra_ms_get_object_filters_for_path' may be reported in the error log by the SAP Replication Agent scanner thread for the default path when the filter distribution model is used.
755644 Ocassionally, a heap memory spinlock violation and followed by various stacktraces may happen for session running multiple XML queries with errors.
755682 An ALTER TABLE SPLIT PARTITION command may report a SIGSEGV (infected with 11) in the SAP ASE errorlog if the destination partition name is not specified.
755705 SAP ASE Replication Agent under a multiple path replication setup will not replicate the execution of rs_ticket stored procedure to all paths.
755806 Under extreme OLTP activity in a mixed-log and data database (like tempdb), a task doing CREATE INDEX may report "Stack overflow detected: limit: 0x0x*, guardpage: 0x0x*, sp: 0x0x*" and "*** Stack guardword corrupted" together with a stack trace that includes the modules 'pg__updateoam', 'pg_oamspace', and 'pg_allocoam'.
755887 The error 1120, "Adaptive Server failed to access page < pageno > in database ' < database name > ' because it is not an allocation page." can be raised if the commands DBCC CHECKALLOC or or DBCC TABLEALLOC(syslogs) are executed on an archive database.
755985 HADR deactivation operation with 'force' option kills transactions on non-HADR databases.
756069 When text is bound to a different cache than data for a given table, back-linking text partitions via dbcc shrinkdb_setup() can produce bad links.
756274 When reporting on the dump header of a dump that was taken with a higher SAP ASE version that has used new metadata in the dump, an error 3264, "The dump header contains device information with invalid token length ...", possibly followed by errors such as 3208 “Unexpected end of file while reading beginning of dump...” will be reported. An unknown element warning message will now be reported instead.
756321 The message "Invalid column length: < num > . Value must be between 0 and 255 at offset 0 for 'data-only' row with minimum row length of 70." together with a stack trace including the modules 'collocate' and 'ra__new_schema' may be reported if a row for a replicated table with a name of the maximum length (255 char) created by a user with a name of the maximum length (30 char) is encountered by Replication Agent.
756437 A statement that inserts into a table with an identity column and references a view or derived table that contains a union-all that terminates a union statement may generate a 264 error (duplicate column id) if the identity value is implicitly generated (i.e. - not explicitly provided in the insert's value list).
756600 Error 11203 - "The command ' < cmd > ' is not legal for objects of this type. External definition: < name > " may be incorrectly raised when a proxy table mapped to a file system is part of an update/delete statement.
756609 Wrong suid in sysprocesses when executing stored procedure with execute as owner from another database context.
756618 Duplicate identity values may be generated after loading a transaction log dump containing transactions that inserted identity values reserved using multiple calls to RESERVE_IDENTITY().
756619 Selecting a remote column from DB2 may hit illegal symbol error if the schema name contains special characters.
756631 A 644 error, "Index row entry for data row id ( < pageid > , < rnum > ) is missing from index page < index_pagenum > of index id < indid > of table ' < tablename > ' in database ' < dbname > '. Xactid is ( < xactid > ). Drop and re-create the index." may sometimes be reported in heavily concurrent systems using DATAROWS LOCKED or DATAPAGES LOCKED tables.
756648 A 213 error, "Insert error: column name or number of supplied values does not match table definition." may be reported in a stored procedure, when deferred compilation is active, if a column is added to a table and there is a dependency on "select * " behavior to ignore the extra column. Trace flag 7798 will ignore this error if deferred compilation is turned on and allow normal compilation to process the statement. If normal compilation still sees an inconsistency, or some other activity causes re-resolution of the stored procedure, then errors may be still be reported.
756819 Arithmetic overflow occurred in procedure 'sp_sysmon_kernel'.
756875 When executing a DUMP command with more than one VERIFY option, the backup server will ignore all but the last one. Also, on Windows platform, if the archive is bigger than 4GB and we are executing WITH VERIFY=READ_AFTER_WRITE or VERIFY=CRC and the verification fails when reading a block that is at an offset greater than 4GB, the error message will report an offset value that is only the two lower bytes of the actual offset, for example "There was a failure decompressing < # > bytes at offset 804831240 when processing stripe ' < the stripe name > '" instead of the offset value for 5099798536.
756894 The error message 7786 has been updated to include the server user name.
756988 Reduce dynamic SQL procedure cache footprint when 'streamlined dynamic SQL' is configured by saving SQL text in the statement cache only.
756990 Raise the restriction limit on proxy table queries from 50 tables to 250 tables.
757038 Sometimes, error 7705 could be raised unexpectedly for LIKE predicate with ESCAPE clause if there is a same letter in LIKE and ESCAPE clause, but one is an upper case letter and the other is a lower case letter.
757061 When shared memory size exceeds 1TB, sp_shmdumpconfig might report error 265, "Insufficient result space for explicit conversion of INT value '1382954' to a CHAR field.".
757164 A timeslice error followed by a stacktrace that includes the modules stphd_release_last_mvcc_histogram(), stphd_release_unreferenced_mvcc_histograms() and stu_nosort_range() may be reported in the error log in a heavily loaded system during the CREATE INDEX operation when using hashing.
757177 LIKE optimization does not happen for a ? + ? pattern that is used in a prepared statement.
757215 In rare circumstances, a 1105 message "Can't allocate space for object 'syslogs' in database 'tempdb' because 'logsegment' segment is full" may incorrectly be printed for tempdb when the first pages of tempdb are not mapped in sysusages.
757251 Add 'Proc Cache Header' diagnostic enhancements for the block pool to capture the time spent in bitmap scanning and collect memory allocation/free patterns. These diagnostics are disabled by default.
757258 When displaying configuration values for Replication Agent using the sp_help_rep_agent procedure the 'rs_servername' displays only the first 30 characters.
757301 When a 331 error occurs or there are long query optimization times or large procedure cache usage occurs in the optimization phase, then this may be due to the optimizer not pruning subplans in the search space as early as possible. Improve pruning can be turned on with optcriteria cr757301, or by using ase_current with optimization level of at least ase157sp130. Trace flag 16992 will turn off the optimization even if the optcriteria is enabled.
757310 Cannot use syconfig to do backup server upgrade on Windows 64bit
757398 In some rare scenarios, a utility command modifying a table and waiting for a level 0 scanner on the table to exit, might not respond to a client killing the session where a utility command is executed.
757459 A timeslice error, followed by a stacktrace that includes the module memshrink(), may be reported in the SAP ASE errorlog during a sort operation on a very large data set.
757501 Improve the clarity of error message 16346, "The LOAD_SQL LISTONLY option is valid only if a stripe device is not specified.". This error message will now be reported as, "You cannot use the FROM clause with the LISTONLY=LOAD_SQL option.”
757531 RepAgent may fail with error 9275 "RepAgent ( < dbid > ): Could not locate the before image for the INSERT log record at ( < page# > , < rowid# > )." while processing the log records for a MERGE command leading to inserts and updates.
757620 Deferred Recovery of Create Index Feature.
757649 A 4720 error, "Cannot truncate table < tablename > because there are one or more isolation level 0 scans, or REORG command, active on the table", may be reported during a TRUNCATE TABLE command while level 0 scans are active. This new feature is enabled when the new configuration option 'enable utility lvl 0 scan wait' is set.
757824 When running in SAP ASE process mode under heavy load in a multiengine environment, an engine may become CPU bound when handling network cancel requests arising from attentions received either from the client or from kill commands. In the event that the network listener was on the run queue of the engine which has become CPU bound as above, it may be impossible to establish new logins to the server.
757829 Incorrect hash partition elimination may lead to incorrect results when there is an OR predicate on the partition column(s)
757850 When running on a table with thousands of partitions, create local nonclustered index or placement index command may fail due to stack overflow with no error message printed.
757883 When a user invokes DDLGen from a script and wishes to hide the password by supplying the pseudo password (-Pext) and including the actual password in a file or setting in an environment variable, the error "DG16: Could not get Console instance" is reported.
757895 Support Quoted Identifiers on session temporary tables. This requires that the configuration parameter "quoted identifier enhancements" is set and the session level option "quoted_identifiers" is on.
757962 Error message 806 (Could not find virtual page for logical page ... in database ...) may be reported for an update query with multiple outer joins when the update mode chosen for the query is not deferred update mode.
758214 The message, "Current process infected with signal 11", followed by a stack trace that includes the module s_recompile() may be reported in the error log when a table schema change happens after processing the first row, and before finishing the second row of an dynamic batch INSERT.
758297 Skip blank lines in the dump history file when searching for the version record. If an invalid version record is found, initialize the history file after copying the file to a back up.
758328 A poor index may be chosen for a join, if the selectivity of previous joins is estimated to be 0 rows (likely caused by a predicate selecting an 0.0 weight range cell in the histogram). The optcriteria avoid_zero_weight_histograms or trace flag 16991 will adjust selectivity estimates so that at least one row will be selected when joining histograms. Note that ase_current will not enable this functionality, and that "set avoid_zero_weight_histograms on", a user defined optgoal which includes avoid_zero_weight_histograms or trace flag 16991 is needed.
758340 Creation of temporary tables in a large number of concurrent user sessions leads to a high number of accesses to syslogins.
758349 DDL commands within prepared statements can now be replicated.
758353 When using data encryption functionality on Windows platforms, encryption operations can make an engine stall for short periods of time.
758408 Stored procedures using "execute as caller" with queries that create and query #temporary tables fail with error 208, "Server ' < servername > ', Line 26: < #temporary_table > not found after LOAD DATABASE".
758765 An incorrect decision by optimizer to do the update in direct mode might result in consecutively repeated update of the same row and resulting in page corruption, manifesting in the errors 806, 614, 120024, etc.
758938 When a process that is executing a DUMP DATABASE command is killed either using the KILL command or using CTRL-C or the SQL session goes away, the Backup Server will not release its associated resources until it finishes copying the whole database. One of the consequences is that the archive devices can remain locked for a long time because the sybmultbuf processes stay alive.
758959 In rare circumstances, when the MDA table monProcessProcedures is being used, an infected with 11 (SIGSEGV) error along with a stacktrace may be logged in the SAP ASE errorlog . This is a similar situation as addressed by CR 754648 (which covered monProcessStatement).
758973 A SIGSEGV (infected with 11) can be logged in the SAP ASE errorlog on the Windows platform if the loginfo() built-in is called with three parameters and for whatever reason the built-in returns an error.
759041 Support online parallel create index.
759142 When UPDATE STATISTICS is performed on a character column with a non-binary character set, and in addition UPDATE STATISTICS uses the consumers phrase, then there is the possibility of many small weight frequency cells following a zero weight range cell. This may cause poor query plan selection if a predicate selects a zero weight histogram cell. Optcriteria cr759142 will avoid generation of small frequency cells following a zero weight range cell, when the consumers phrase is used in UPDATE STATISTICS to generate stats on a mostly unique non-binary character set column.
759143 A poor query plan might be selected when parallel UPDATE STATISTICS (for instance using the consumers phrase) is used to gather statistics. After installing SAP ASE with the fix for this issue, update statistics will need to be run on affected tables.
759188 The message, "Current process infected with signal 11", followed by a stack trace that includes the module sendtext() may be reported in the error log when a MERGE JOIN is being used and if the inner table has in-row LOB columns with NULL values.
759245 If there are equality predicates or joins which are used for index keys, then occasionally an index which has few positioning keys specified than another index will be chosen. If 2 indexes have only equality predicates or equality joins used for keys, then a heuristic is added to choose the index with more limiting keys if those keys cover all the limiting and filtering keys of another index. The optcriteria EQUALS_SCAN_SUPERSET and trace flag 16989 will apply the heuristic to index scan which are not the inner of a nested loop join. The optcriteria EQUALS_NLJOIN_SCAN_SUPERSET and trace flag 16990 will apply the heuristics to all index scans. Note that the optcriteria are not turned on by any optgoal, and a SET command, user defined optgoal, or trace flag is needed to enable the heuristic.
759377 In very rare situations, SAP ASE may panic and shutdown if sp_sysmon is being run and a connection disconnects at the same time.
759433 On Windows platform, SAP ASE may open an arbitrary listener port during MS DTC service initialization for distributed transaction management.
759501 Allow the command LOAD WITH VERIFYONLY to be executed using less stripes than the number used at DUMP time.
759562 Support creation of a global index in parallel for a partitioned table that has one or more empty partitions. Previously, when creating a global index on partition table, if there were any empty partitions, then the index would be created in serial.
759624 On ASE Cluster Edition insert jobs may unexpectedly continue to run with no new rows inserted into the target table. There are NO lost inserts but, dbcc checkalloc or tablealloc may report Msg 2546 or we may encounter deadlocks which can be seen in the error log.
759637 The message, "Current process infected with signal 11", followed by a stack trace that includes the module LeScanOp::_LeOpNext() may be reported in the error log when an online utility (e.g. REORG REBUILD) is in progress on a table that contains forwarded rows.
759646 Arithmetic overflow may occur when executing procedure sp_sysmon_locks.
759679 When 'net password encryption reqd' set to 1, charset/langinstall will run into 1640 (Adaptive Server requires encryption of the login password on the network) and 4002 (Login failed) errors.
759728 CREATE TABLE commands may not perform well in situations where a lot of CREATE TABLE commands are run in parallel and the SAP ASE configuration has 'enable inline default sharing' set.
759923 Traceflag 3605 gets left on after error 707 state 11 is hit, resulting in a wide variety of diagnostic information being written to the errorlog, in turn causing the errorlog to grow rapidly.
759937 If a trigger for a DML query has certain commands that execute immediate are not allowed, such as begin tran, rollback trans, etc, error 11736 and 11031 could be raised for the first post-upgrade using execute immediate for the DML query.
759945 When LOAD DATABASE ... WITH LISTONLY = 'CREATE_SQL' is used with the new functionality to create DDL for a differently named target database, the target database name is not reflected in the sp_dboption statements.
760002 DBCC CHECKTABLE may encounter a 2511 error, "Keys of index ID < id > for table < tablename > in leaf page are not in the correct order. Drop and re-create the index (index page < pageno > , partition ID < partition_id > )", if 'enable functionality group' is enabled and the base table lockscheme is DOL and changing the table's lockscheme from DOL to APL as part of AMC.
760054 On ASE Cluster Edition insert jobs may unexpectedly continue to run with no new rows inserted to the target table. Dbcc checkalloc or tablealloc may report Msg 2546.
760159 The 6918 error, "The SYSDAMS page that stores the state of page # in database ' < dbname > ' could not be found. The option 'allow incremental dumps' will be disabled because SAP ASE cannot continue recording page modifications", can be raised if the table SYSDAMS gets the very first extent of an allocation unit allocated.
760176 Optcriteria equals_scan_superset and avoid_zero_weight_histograms are associated with the ase157sp130 optimization level. Previously, a user defined optgoal needed to be defined to enable these optcriteria (or trace flags 16989 and 16991 respectively).
760187 The index ID is incorrectly reported as 0 in the SAP ASE error message number 12301, "Internal error: the index (id = < ID > ) and the data for row ( < page > , < row > ) in table ' < table > ', database < db > are inconsistent; data is marked deleted but index is not. Aborting the transaction".
760248 Under some circumstances, a worker thread may hang due to incorrect error handling during parallel CREATE INDEX with "utility statistics hashing" turned on.
760274 In rare circumstances, a time slice error followed by a stack trace that includes the modules ups_end_statglobalnosort() and close_table() may be reported in the error log when running UPDATE INDEX STATISTICS.
760365 Isolation level 0 queries fail with errors when CREATE CLUSTERED INDEX WITH ONLINE is in progress concurrently on the same table.
760390 A DUMP WITH COMPRESSION could fail with the message "SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=0, system message=Pipe I/O returned 0 bytes". If a core file is produced the stack will show the module sm__do_allocations().
760453 Wrong result could happen when an EQUIJOIN on a single INT4 column is placing a bloom filter probe into the scan and the scan is at the inner side of another NESTED LOOP JOIN with a pushdown EQUIJOIN sarg on the same column.
760539 SAP ASE fails to boot on Windows with the message "FATAL: shared memory region is being held at xxx bytes but yyy bytes are required" being reported in the SAP ASE errorlog.
760621 On a server that has a large number of objects, the sp_sysmon report may take a long time to complete and error message 1508, "Create index aborted on duplicate rows. Primary key is < keyname > ", may be reported in the error log.
760661 The procedure cache allocation is optimised. This vastly speeds up the start-up of SAP ASE configured with a very large procedure cache.
760672 A 3478 error, "During undo the page timestamp value is less than new timestamp from log." or other fatal errors may be reported in the error log when SAP ASE is rolling back a transaction following an 863 error, "Buffer resources in cache < cache_name > are unavailable. Please re-run this query or ask the system administrator to re-configure buffer cache memory." that is accompanied with messages "Named cache < cache_name, cache_id > is configured too small for current demands".
760673 If the data cache is configured small, SAP ASE may report a 'cache too small' error when the new sort buffer algorithm is used.
760684 A 707 error, "System error detected during attempt to free memory at address < addr > . Please consult the ASE error log for more details", may be raised by SAP ASE when multiple SAP ASE connections are executing parallel CREATE INDEX commands.
760711 In rare circumstances, after using the configuration option 'global cache partition number', the dataserver may hang. If the diagserver was being used then an Assertion (! "locks not cleaned") will be reported in the SAP ASE errorlog.
760875 sp_sysmon and monEngine do not report DiskIOChecks in process mode.
760876 Deprecate plan sharing feature.
760897 A 6908 error, "During redo the page timestamp value is less than old timestamp from log. etc." followed by a stack trace that includes the module 'recovery' could be raised when loading a database dump if the configuration parameter 'optimize dump for faster load' is enabled and there is very high update activity in SAP ASE while the dump database command is running. To workaround the problem the end-user can set the trace flag 3022 (either via the command line or by using dbcc traceon or by using SET SWITCH ON ignore_trailer_ckpt) before loading the database.
761036 Under rare conditions, a 12301 error, "Internal error: the index (id = < num > ) and the data for row ( < page# > , < row# > ) in table < table_name > , database < dbnum > are inconsistent; data is marked deleted but index is not. Aborting the transaction", may be reported during an isolation level 0 scan.
761062 When using sql replication and nested builtins with a column reference, an incorrect sql statement may be generated instead of defaulting to row replication.
761117 DML on tables with Encrypted Columns are significantly slower than SP50.
761155 For SAP ASE Cluster Edition, when table creation is in progress, the checkpoint process may hit an infected with 11 (SIGSEGV) in the module 'ocm_hold()' and report a stacktrace in the SAP ASE errorlog that includes the modules 'des_has_onlutl_active()' and 'cm_writedes()'.
761275 When there are several scans on the same index and some of the scans hit the same index page needed to be shrunk concurrently, the index page may be shrunk twice. The second attempt will fail and a 2630 error, "In database < db > , page < page#2 > is linked backward to page < page#1 > , but that page is linked forward to page < page#3 > . Please report this internal error to SAP Technical Support". Although a 2630 error is raised, the index is not corrupted.
761282 When execute command ALTER TABLE ... SPLIT PARTITION ..., use of parallel sort and table's partition number > 1, it will encounter an Error 675: "Invalid Buffer Cache Access: Attempt to locate page < page > , database < dbid > in cache failed because no object id was specified. scan_context={objid < objid > , indid < indid > , cid < cid > }. Contact Technical Support for Assistance."
761385 The message, "Current process infected with signal 10 (SIGBUS)", followed by a stack trace that includes the modules 'loginfo_builtin' and 'exec_lava' may be reported in the error log when the builtin loginfo(' < dbname > ','oldest_active_transaction_date') is executed.
761410 UPDATE STATISTICS WITH SAMPLING may report error 614: "Adaptive Server accessed a row that has an illegal length of < n > while in data base ' < db > ." or error 806: "Could not find virtual page for logical page < n > in database ' < db > ', while concurrent DML is going on the same object.
761518 A 7786 error, "Unable to turn role off since user is not a valid user in the current database", may be reported incorrectly when executing the SET ROLE OFF command.
761555 Some of the cache buffers used for sort are not claimed and unclaimed correctly. This can lead to a performance impact if cache swap occurs.
761679 LOAD DATABASE WITH LISTONLY=LOAD_SQL with UNTIL_TIME after a tran dump and before a database dump generates incorrect load SQL.
761743 The optcriteria EQUALS_SCAN_SUPERSET and EQUALS_NLJOIN_SCAN_SUPERSET have had the comments changed so that the respective optcriteria names shows up in the sysoptions output.
761825 Bulk insert to proxy tables mapped to DirectConnect for Oracle was disabled in ASE 15.0.
761830 [Feature request] Provide a means for ASE to detect and report whether a database has been put in PREPARE state. This request is addressed by a new builtin is_prepared( < dbid > ).
761836 New Feature: Bucket Pool memory manager to enable ASE scale over large CPU core configuration.
761881 BCP in to a table with encrypted columns is much slower with the change from the use of the Certicom libraries.
761958 DBCC CHECKTABLE may report a 605 error, "An attempt was made to fetch logical page < pageno > from cache < name > . Page belongs to < info1 > and not to < info2 > " may be reported after creating an index with online option.
762174 The message, "Current process infected with signal 11", followed by a stack trace that includes the module SearchEngine::_SeFindOptimal may be reported in the error log after a lengthy optimization, most likely after an aggregate with a GROUP BY in which the GROUP BY columns originate from multiple tables.
762178 When ansinull is off, incorrect NULL value row could be returned when an equi-join under OR predicate are on two columns with NULL values and the final plan is using a special OR strategy plan for the OR predicate. An example of such OR predicate is "t1.col1 IN (1,2,t2.col2)".
762223 When granular permissions is enabled and the user who has "own database" permission has executed setuser " < another_user > ", the user is not able to select from < another_user > .table.
762257 When a dynamic batch insert is executed, an "infected with 11" (SIGSEGV) stacktrace may be reported in the SAP ASE errorlog. The stack trace will reference the functions tdsrecv__process_batchparam() and tdsrecv_dynamic().
762266 Under a rare condition, the fix for CR 750937 could cause a performance regression. The fix for 750937 is now only enabled under traceflag 219.
762281 The version of OpenSSL used has been upgraded to OpenSSL 1.0.1g
762349 The expression -(minimum integer value) does not raise an error.
762712 When a non-language batch query (e.g. 'if @@transtate = 3 select 3 else select 0') is followed a language batch query which triggers an error (e.g. a query causing parsing error), an "infected with 11" (SIGSEGV) stacktrace to be reported in the SAP ASE errorlog. The stack trace will reference the functions batchparam_save_SQL() and memalloc().
762728 When INSERT INTO SELECT at LEVEL 0 is enabled, SELECT INTO does not wait for locked rows so may return wrong results.
762909 sp_showoptstats will have poor performance if a large number of partitions are defined and/or a large number of columns have histograms defined.
762959 DDLGen terminates when the config option 'quoted identifier enhancements' is off.
762960 When permission on built-in function is granted to a role which is granted to a user, then executing the built-in function may result in permission error.
763150 Create login command does not pass the login name to sp_extrapwdchecks.
763162 For tables with LOB columns and attribute "dealloc_first_txtpg" set to 1, error 7133 "NULL textptr passed to %s function." will be reported when WRITETEXT command is running with the new text pointer after the LOB column is updated to NULL.
763213 Sybmigrate space estimation report fails with error 291 state 1 "Access to sysdams is disallowed".
763247 Using a NOT LIKE clause to compare with a local variable assigned to a constant string could return different results than comparing to the constant string directly if the column has NULL values in it.
763271 For the diagserver on Solaris platforms, if SAP ASE is running in threaded kernel mode, setting the congiguration option "number of disk tasks" to any value greater than 1, will result in an assertion failure being reported in the SAP ASE errorlog.
763351 In rare circumstances, error message "WARNING - Fatal Error 614 occurred at ... Adaptive Server accessed a row that has an illegal length ..." may be raised if there is "ORDER BY" clause in a query that uses an in-memory temp database.
763376 A 6908 error, "During redo the page timestamp value is less than old timestamp from log. Page .. object id = 99, page timestamp=0000 00000000. Log old timestamp=0000 00000001." may be reported during load tran in a database that has been altered with the "async_init" option.
763510 If many queries that use an "ORDER BY" clause are executed concurrently and the "default data cache" is configured to use a large value for the "local cache partition number" parameter, then SAP ASE may run very slowly or even appear to hang.
763514 A 2510 error, "Key mismatch between index page < value > , partition ID < value > ;... Drop and re-create index ID < value > of table ' < value > ' in database ' < value > '." followed by the message "current process infected with 11" in the module 'byte_eq' together with a stack trace which includes the modules 'compress_page' and 's_xoltp_dml' may be reported in the error log when an INSERT is executed and while the configuration option "streamlined dynamic SQL" is active. Additionally a 631 error will be reported while SAP ASE is rolling back the current transaction.
763609 If an upgrade from a SAP ASE server with a version lower than 15.7 SP100 fails to create the table SYSDAMS because it ran out of space, executing ALTER DATABASE to extend the space will fail with the 12324 error, "In database < dbname > , the server failed to open required table 'SYSDAMS'".
763672 Update statistics on proxy table mapped to Oracle using DCO may stacktrace at stat_sargden_accumulate if the proxy table contains NULLs.
763772 Conversion to a text or image column containing nulls in a stored procedure may cause seemingly random stacktraces (infected with 11/SIGSEGV) to be reported in the SAP ASE errorlog.
763794 When a RID is used to scan a table and the table has defaults that are not materialized, wrong results may be returned.
763859 The EQUALS_SCAN_SUPERSET optcriteria hueristic rule is applied to prefer an index with more limiting equi-sarg keys specified over another index with fewer limiting keys, given that the index limiting equi-sargs keys is a superset of the latter index, and that it is also a superset all the limiting sargs and filtering sargs the latter index. However, if an enforcer such as a SORT or XCHG is applied, the index with fewer limiting equi-sarg keys may still be chosen. Optcriteria cr763859 will use the rule hueristic, but it will only apply if optcriteria EQUALS_SCAN_SUPERSET is also enabled.
764074 The "Alter thread pool" command may cause an infected with 11 (SIGSEGV) along with a stacktrace that references the function rvm_dispatch() to be reported in the SAP ASE errorlog.
764186 In rare circumstances, the message "current process infected with 11" (SIGSEGV) in the module 'dpdb__dflpurge' together with a stack trace may be reported in the error log followed by the message "Spinlocks held by kpid ... Resource- > rdbt_ext_spin" resulting in SAP ASE shutting down implicitly during the execution of a DUMP DATABASE command and while the configuration option "optimize dump for faster load" is set to 1.
764288 Under some rare condition, error msg 605 could occur when try to delete a row from a table which has IN ROW LOB if compatibility mode is on.
764402 A 692 error, "Uninitialized logical page ' < value > ' was read while accessing database 'value', object '' (99), index ' < Unknown > ' (0), partition ' < Unknown > ' (99)." may be reported during the execution of either ALTER or CREATE DATABASE command when the "FOR LOAD" option is used and while the database is larger than 64 GB. This may be followed by the message "current process infected with 11" in the module 'buf_cleanup_write_queue' together with a stack trace in the SAP ASE error log which includes the modules 'terminate_process' and 'quitfn'.
764543 Backup Server may log false page verification errors with a message "Incorrect column type in the offset table of row x in page xxx of object ID xxxxxxxx." when executing dump database command with verify = full on a database with 'allow wide dol rows' turned on.
764623 When performing a dictionary decompress for varchar column with character encoding, SAP ASE may report a 9829 error - " Compressed data row < rowid > in objid < objid > , dbid < dbid > is corrupted."
764801 Under an HADR environment the current task may hang forever in the log drain phase of the deactivation process if the SAP ASE Replication Agent is unable to connect to the SAP Replication Server during the execution of 'sp_hadr_admin deactivate'.
764830 When the advanced_aggregation optcriteria is used (typically this occurs when the optimization goal is allrows_dss), then there is a possibility of a wrong answer when a SUM, or AVG aggregate is used on an exact numeric datatype column.
764862 The message text for error 3543 is enhanced to include the database id value such as "One or more entries in the data segment free space counts in database ID %d was found to be negative and has been set to 0."
764924 The errors 'Object id wrong' or 'Page mismatch' can be mistakenly reported by DUMP WITH VERIFY if the system is very busy while the database dump is in progress.
765133 Error message 15746 is modified and made generic as "Unable to run this command on the archive database '%S_DBID' because it is not supported."
765216 sp_hadr_admin failover_timeestimate reports high value for estimated failover time.
765381 Select negative number from tinyint column does not return 'Arithmetic overflow" error.
765517 If auditing is enabled & stack overflow is detected, server gets SIGNAL 11 (SIGSEGV) in chk_usr_role_audit(). As a consequence, normal shutdown hangs, but 'shutdown with nowait' works.
765677 In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #= < pg > , page timestamp= < ts > . Log old timestamp= < ts2 > ." may be reported during recovery when an ALTER TABLE or REORG REBUILD command was running at the time SAP Adaptive Server was shutdown with nowait or was abnormally stopped.
765728 When BULK-INSERT optimization is used for INSERT INTO ... SELECT ... statement, and when there is an exception occurs (in this case, a landing partition for a row is not found causing exception), the table will be closed by the exception handler and hence the corresponding internal table descriptor structure is also closed before the CLOSE phase. Hence, further dereferencing the internal table descriptor structure causing SEGV. This was handled before by appropriately freeing all the memory and bail-out in the CLOSE phase however, there are few bits that needed to be cleared were not cleared properly. Not clearing these bits was causing the issue described in CR# 763514.
765911 A 3223 error, "Attempt to read a dump trailer failed; returned error code is 2.", will be reported when trying to load a database dump into a pre-15.7 SP121 SAP ASE release, if the dump was taken either with 15.7 SP121 or 15.7 SP122 SAP ASE releases and the option 'optimize dump for faster load' was enabled when the dump was taken.
765924 In SAP ASE Cluster Edition, duplicate identity values may be generated in column that was created with the IDENTITY() built in function.
765991 The message "Current process infected with signal 11" together with a stack trace containing the module 'ups_stat_memalloc' may be reported in the error log while running update index statistics with hashing.
766109 Under a heavily loaded Java application environment, the messages 'PCI(M1): ERROR: JNI_CreateJavaVM; failed attaching to the JVM for AttachCurrentThread() with -1' and 'PCI(M1): ERROR: JNI_CreateJavaVM; PCA/VM FAILED; general failure' may be reported in the SAP Adaptive Server error log. These messages usually indicate that the JavaVM heap space is exhausted. In order to solve this problem the SAP Adaptive Server needs be restarted.
766247 In rare circumstances a DUMP or LOAD command could fail on a Windows platform with the error message in the backup server errorlog 'Error in acknowledging command '152' to the archive emulator'.
766324 Under an HADR environment on the AIX platform, a user connection (not having 'allow hadr login' privilege) to the ASE in standby mode is not redirected to the primary ASE, and the user login fails.
766427 The indexes created internally for the replication of text/image columns are system objects and they cannot be renamed by executing the system stored procedure sp_rename.
766492 An attempt to connect to the Backup Server could fail with the error 'The host ' < IP address > ' is not authorized to connect to this Backup Server.' reported in the SAP backup server error log if the SAP backup server is booted using a virtual address and the 'hosts.allow' file doesn't contain an entry for the actual real address.
766526 Using the statement cache, literal auto parameterization, views and instead triggers all together may result in the wrong length for text columns after the column is updated with an instead of trigger being executed.
766567 On Solaris platforms, a 940 error "Dbtable in wrong state for operation: DBTABLE pointer = < address > , dbid = < value > ..." together with a stack trace may be reported in the error log if 'list_dump_fs' or 'get_dump_fs' attribute is queried using function db_attr() or sp_downgrade_esd is executed.
766616 On the Solaris platform, when a user has created a user message and the login account of this user is dropped, then an infected with 10/SIGBUS stacktrace may be logged in the SAP errorlog.
766647 Under a heavily loaded Java application environment, the messages 'PCI(M1): ERROR: JNI_CreateJavaVM; failed attaching to the JVM for AttachCurrentThread() with -1' and 'PCI(M1): ERROR: JNI_CreateJavaVM; PCA/VM FAILED; general failure' may be reported in the SAP Adaptive Server error log. These messages usually indicate that the JavaVM heap space is exhausted. In order to solve this problem the SAP Adaptive Server needs be restarted.
766770 When a MERGE statement is run on a table that has an insert and an update trigger defined, the implicit execution of the triggers may cause wrong results on the target table of the insert trigger.
766822 In rare circumstances, the message "current process infected with 11" in the module 'th_accounting' together with a stack trace which includes the modules 'pg_th_reserve' and 'pg_allocate_syslogs' may be reported in the error log, if an ALTER DATABASE command is executed to extend the database size and a high level of concurrent activity is taking place in the database. This may result in the SAP Adaptive Server shutting down implicitly.
766896 Resolve issues revealed by Coverity for RAT code.
767208 Update sqlloc to support new sort order 'binaryalt'

 

Related Links

DOCUMENT ATTRIBUTES
Last Revised: Jul 17, 2014
Product: Adaptive Server Enterprise
Technical Topics: Error Message, Database Admin, Bug Information, Troubleshooting
  
Business or Technical: Technical
Content Id: 1099394
Infotype: Technote
 
 
 

 
© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics