Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:740746

CR Number:   740746 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2013 Fixed Description A new feature request to make ASE set 0 to segmap of sysusages if ASE finds segmap=0 in allocation pages of tempdb while rebuilding sysusages.

CR:740776

CR Number:   740776 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2013 Duplicate Description Hash based statistics collection may fail with an internal error

CR:740790

CR Number:   740790 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   chaumont Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When generating a XSM from an OOM, the Class attributes are not generated if the Class Description property is populated. To reproduce: Use sample OOM to generate an XML model or 1) create an OOM 2) add a Class with several attributes 3) enter some text in the Description of the Class 4) Generate XML model; on the Detail tab select 'Generate Attributes as 'Attributes' In the resulting XSM, the attributes have not been generated for the Class

CR:740800

CR Number:   740800 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2013 Fixed 15.7 SP110 20 Jun 2013 Fixed 06 Jun 2013 One-off Provided 15.7 SP50 12 Jun 2013 Fixed 20 Jun 2013 Reservation Made Description In rare scenarios, a timeslice error may be reported along with stack trace which includes the modules ind_ides_init() and ind__ides_install() after using the DBCC TUNE('des_bind') utility.

CR:740814

CR Number:   740814 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2014 Fixed Description There are missing VA information in some Lava plan operators when using show_cached_plan_in_xml().

CR:740817

CR Number:   740817 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2013 Not a Bug Description

CR:740835

CR Number:   740835 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 07 Jul 2013 Fixed Description In stress test, when scanning a table using transaction isolation level 0, error 12301 state 1 "Data is marked deleted but index is not." might be output.

CR:740878

CR Number:   740878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 27 Jun 2013 Fixed 15.7 SP50 20 Jun 2013 Fixed 27 Jun 2013 One-off Provided Description If a process uses up all the locks leading to error 1204, then a new login attempt may cause a stack trace that involves the module lock_do_logical() to be reported in the ASE error log.

CR:740882

CR Number:   740882 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 15 Jul 2013 Fixed Description Table scans may be used by the optimizer if parameters values are not visible at optimization time for range predicates since the magic numbers used by a range predicate ">", "<", ">=" or "<=" will use 33% selectivity, and an "in-between" predicate in which a lower and upper bound are specified will use 25% selectivity. sp_modifystats has a new option MODIFY_DEFAULT_SELECTIVITY for which the defaults of .33 and .25 can be overridden for a specific column if it is known that typical predicates for a column has different selectivities from the defaults. Workaround Description  There are 3 workarounds 1) use dynamic mode in the java config file to allow parameters to be used by the optimizer to use histogramming for more accurate estimates. 2) Another workaround could be to set the optimizer concurrency threshold to -1 so that table scans are avoided, but the downside would be that an index scan would be used in cases where a table scan could be much more efficient (i.e. avoiding 1 data page lookup per index row possibly looking up the same data page multiple times and thrashing on the buffer cache, vs looking up the data page once in the table scan) 3) enable the statement cache so java parameterized language statements provide values to the optimizer so that histogramming can be used instead of magic numbers for selectivity estimates.

CR:740883

CR Number:   740883 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2013 Presently Not Targeted For Any Future Release Of This Product Description Close it as 'not to be fixed' since sybmigrate need target server is a newly installed server.

CR:740909

CR Number:   740909 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2013 Fixed Description Error 913:"Could not find row in sysdatabases with database id 4" observed while creating database asynchronously.

CR:740957

CR Number:   740957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 14 Jul 2013 Fixed 15.7 SP121 17 Dec 2013 Fixed 17 Jan 2014 Fixed Description The message "current process infected with 11" in the module 'LeBulkOpOpenCleanup' together with a stack trace which includes the module 'LeBulkOpOpen' may be reported in the error log while migrating data from one platform to another using sybmigrate.

CR:740987

CR Number:   740987 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2013 One-off Provided 15.7 SP110 02 Jul 2013 Fixed 15.7 SP60 23 Jul 2013 Fixed Description In rare circumstance, the size of non-unique indexes on DOL tables may grow very quickly if lots of data is inserted, or the index columns are updated frequently.

CR:741021

CR Number:   741021 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2014 Fixed 20 Feb 2014 Fixed Description Buffer pool wash size increments unexpectedly for user defined caches when remote node is booted

CR:741044

CR Number:   741044 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 17 Jun 2013 Fixed 26 Jun 2013 Port Not Needed Description The message "'<version>' is not a valid target for downgrade." may be reported when downgrade to ESD2 or ESD3 using sp_downgrade_esd.

CR:741063

CR Number:   741063 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 05 Jun 2013 Fixed Description The 6914 message, "Procedure 'sp_dump_info', The parameter 'Invalid pointer param number 1, pointer value 0x000000000000000A' is not a valid dump type", will be raised if an invalid dump type is passed to the stored procedure sp_dump_info.

CR:741071

CR Number:   741071 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 13 Jun 2013 Fixed 15.7 SP110 14 Jun 2013 Fixed 27 Jun 2013 One-off Provided 13 May 2014 One-off Provided Description When executing a subquery with a scalar aggregate, ASE may fail to clean up resources and terminate processing after an attention thus leading to an 803 error.

CR:741079

CR Number:   741079 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2013 Third Party Problem 27 Aug 2013 Third Party Problem 27 Aug 2013 Third Party Problem Description sp_sendmsg is much slower on AIX than other platforms.

CR:741105

CR Number:   741105 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 16 Jun 2013 Fixed 15.7 SP102 16 Jun 2013 Fixed Description The message, "Current process infected with signal 11", together with a stack trace that includes the module scan_getrow() may be reported in the error log when executing DBCC CHECKTABLE if a shrink-database operation is not completed and the dataserver is rebooted.

CR:741160

CR Number:   741160 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2013 One-off Provided 19 Jun 2013 Bundled Request 29 May 2014 Port Not Needed Description ASE hits signal 11 in canlisten_on_othereng(), which is triggered when an engine on which a listener is running becomes non-responsive. Workaround Description  First increase configuration for: sp_configure "workload manager cache size", 200 and then change the configuration option for "max online engine".

CR:741178

CR Number:   741178 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 12 Jun 2013 Fixed 15.7 SP110 24 Jun 2013 Fixed Description An 806 error, "Could not find virtual page for logical page <pagenum> in database <dbid>", may be reported in the error log with a stack trace which includes the modules bufnewpage(), quitfn() and log_to_virt() if a session is killed while executing a query that required a work table creation in the tempdb database, or, required page allocations in a different database.

CR:741191

CR Number:   741191 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 10 Jun 2013 Fixed 15.7 SP102 16 Jun 2013 Fixed Description Under some rare circumstances, a shrink-database operation can encounter errors of index not consistent on DOL tables and little endian platform.

CR:741214

CR Number:   741214 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature Request: Include SSQLID in monProcessStatement Workaround Description  You can do this currently as follows: dbcc traceon(3604) dbcc sqltext(<spid>) Which gives output like this: SQL Text: select * from test..t1 Executing procedure: *ss1137874382_1262752346ss* Subordinate SQL Text: select * from test..t1 The second number in the procedure name is the hash key for the statement cache: 1262752346 So you can then do: select SSQLID from monCachedStatement where Hashkey = 1262752346

CR:741228

CR Number:   741228 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2013 Not a Bug Description Update on proxy table fail to update right number of rows. Workaround Description  // disable all Omni optimizations dbcc traceon(11298) go

CR:741229

CR Number:   741229 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2013 One-off Provided 15.7 SP50 19 Jun 2013 Fixed 15.7 SP110 26 Jun 2013 Fixed Description Permission denied errors might be reported when executing nested stored procedures if unrelated roles are modified.

CR:741239

CR Number:   741239 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 21 Jun 2013 Fixed 15.7 SP50 18 Jun 2013 Fixed 15.7 SP102 18 Jun 2013 Fixed Description In some cases, runtime rollback of a transaction that is done in parallel (parallel CREATE INDEX, SELECT INTO, REORG REBUILD or ALTER TALBLE (with data copy)) will be incomplete leaving the database in an inconsistent state. Workaround Description  If parallel operations are being used post 15.7 ESD 4.2 the 3968 (serverwide) trace flag must be turned on, to disable the log jumping optimisation.

CR:741256

CR Number:   741256 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) Description An CIS query may fail with 7732 error on remote server: "The UPDATE/DELETE WHERE CURRENT OF failed for cursor '%.*s' because the curso r is read only." The CIS query looks like: "UPDATE PROXY_TABLE ... FROM LOCAL_TABLE, PROXY_TABLE where ..." For the invalid query plan which caused 7732 error, it has join order proxy_table -> local_table, ORDER BY join_column clause is added for the partial query sent to remote server, remote server declared a cursor using a statement looks like: SELECT ... FROM ... ORDER BY ... FOR UPDATE OF ... This issue is related to a known CR 652032: "Allow positioned updates when ORDER BY is used". Please force a valid plan via a valid abstract plan or force join order via 'set forceplan on' to work around this 7732 error. Workaround Description  Force join order via 'set forceplan on' or use a valid abstract plan.

CR:741278

CR Number:   741278 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 19 Jun 2013 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module ra__store_last_rs_error() may be reported in the error log if multiple Rep Agent threads are started on the same database at the same time. Workaround Description  Don't run multiple sp_start_rep_agent commands on the same database at the same time.

CR:741286

CR Number:   741286 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: extend sp_checkreswords to sysroles and master..syssrvroles

CR:741302

CR Number:   741302 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customers would like a feature to refresh an IMDB from its template without restarting the ASE or recreating the database. Workaround Description  Restart the ASE recreate the IMDB

CR:741330

CR Number:   741330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Jul 2013 Fixed 15.7 SP110 03 Jul 2013 Fixed 15.7 SP50 02 Jul 2013 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the modules sparclock() and kssolnetctlrWaitForCompletion() may be reported in the error log when SAP ASE is running in the threaded kernel mode on the Solaris operating system after which the ASE may become non-responsive. This issue only affects SAP ASE on the Solaris platforms.

CR:741350

CR Number:   741350 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 11 Jun 2013 Fixed Description The stored procedure sp_helprotect does not display a row for built-in function asehostname for a user who has been granted SELECT on the built-in function.

CR:741352

CR Number:   741352 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 26 Jun 2013 Fixed 15.7 SP102 21 Jun 2013 Fixed Description Under rare circumstances the Rep Agent may report a 9219 error with state number 61, "RepAgent(<dbid>): Internal coding error", when processing LOB data resulting in the Rep Agent termination.

CR:741365

CR Number:   741365 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_configure output display extra spaces on run value , config value with non-unique parameter or with an individual parameter on ASE 15.7 SP100 release

CR:741368

CR Number:   741368 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 14 Jul 2013 Fixed Description If DDL IN TRAN is turned on and some indexes are created in an uncommitted transaction, then concurrent DBCC CHECKDB, DBCC CHECKTABLE or DBCC CHECKINDEX that involves the table will hang.

CR:741386

CR Number:   741386 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 23 Jul 2013 Fixed 15.7 SP110 19 Jun 2013 Fixed Description Schema creation is incorrectly logged for DDL replication if the CREATE SCHEMA is not the only statement in the batch and when the statement cache is ON.

CR:741389

CR Number:   741389 Product Name:   Sybase ETL Product Component:   CDC Status:   Open OS:   Windows 2003 Original Version:   Denali Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Trying to 'create replication' in the CDC Provider for Replication Server Sybase after making sure database the source table is in has been added to replication server's definitions with rs_init errors out with '<source db> has not been added to replication system'

CR:741426

CR Number:   741426 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 20 Jun 2013 Fixed 24 Jun 2013 One-off Provided 15.7 SP110 25 Jun 2013 Fixed Description The messages, "ncheck: select, Operation not applicable" or "poll() returned 32 on socket <#>" may be repeatedly reported in the errorlog after an ASE listener has migrated from a non-responsive engine. Workaround Description  Add all the listeners into interfaces file and do not spawn a new listener via sp_listener, i.e (content of interfaces file should have something like): start_all_servers master tcp ether <hostname> 7800 master tcp ether <hostname> 7801 master tcp ether <hostname> 7802

CR:741439

CR Number:   741439 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 13 Jun 2013 Fixed 15.7 SP102 14 Jun 2013 Fixed Description A 4306 error, "There was activity on database since last load, unable to load", may be reported when loading a database or transaction log dump of a database whose size is smaller than the target database into which it is being loaded, thereby breaking the load sequence.

CR:741451

CR Number:   741451 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 19 Jun 2013 Fixed 15.7 SP102 17 Jun 2013 Fixed 15.7 SP50 20 Jun 2013 Fixed Description A 691: "Encountered invalid logical page '<page>' while accessing <partition>. This is an internal system error. Please contact Sybase Technical Support." error followed by a stack trace that contains the modules getpage_with_validation() and wrongpage() may be reported in the error log under the following conditions: (1) The configuration option "streamlined dynamic SQL" is enabled, either directly or by enabling functionality group and (2) A dynamic prepared INSERT or UPDATE statement is executed on a table that has been created with deferred_allocation and (3) The prepared statement has been executed successfully at least once and (4) The target table that is inserted/updated is dropped and re-created as a defered_allocation table and (5) The dynamic INSERT/UPDATE query is re-executed from the same ASE connection. Workaround Description  turn off 'deferred table allocation' for the database

CR:741461

CR Number:   741461 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2013 Bundled Request Description When ASE attempts to write a CSMD (configurable shared memory dump) after a failure, it fails to halt and resume the engine threads with the error, "SuspendThread failed for thread (n), error 6".

CR:741478

CR Number:   741478 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2013 Fixed 19 Jul 2013 Bundled Request Description Option to export already cached results instead of fetching complete results from the server.

CR:741481

CR Number:   741481 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 21 Jun 2013 Fixed 15.7 SP110 01 Jul 2013 Fixed 30 Jun 2013 One-off Provided Description An 804 error, "Unable to find buffer <buffer_address> from cache <cachename> holding logical page <pageno> in sdes <sdes_address> kept buffer pool for object <objname>", may be raised under heavy load of concurrent DMLs when the log is nearly full.

CR:741487

CR Number:   741487 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 14 Jun 2013 Fixed 15.7 SP60 02 Aug 2013 Fixed Description A timeslice error followed by a stack trace that involves the module buf__unhash_and_keep_grabbed_mass() may be reported in the error log during HASH based statistics gathering.

CR:741605

CR Number:   741605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2013 Not reproducible with latest version of the product available as of Resolution Date Description In some situations, LOAD DATABASE recovery may fail with error 2620, severity 21, state 3, reporting that redo of an APL index insert log record could not be processed. This is likely to occur if the transaction causing the APL index page split were to rollback at run-time while the DUMP DATABASE was performed concurrently.

CR:741621

CR Number:   741621 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Jul 2013 Fixed 27 Jun 2013 One-off Provided 15.7 SP110 27 Jun 2013 Fixed Description SAP ASE reports invalid process status messages like "kpsched: kpid 1962483841 bad status 0x400414" followed by "upstatus: kpid = 1962483841, status 0x400414 not valid". The exact bad status may vary across messages.

CR:741677

CR Number:   741677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 27 Jun 2013 Fixed Description Under some conditions in threaded kernel mode, when the ASE task is blocked in some OS call, it can hit timeslice error if the thread gets a SIGUSR1 signal.

CR:741711

CR Number:   741711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description increase default stacksize. Workaround Description  sp_configure "stack size", XXXXX go

CR:741717

CR Number:   741717 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) cepheus 18 Jul 2013 Fixed Description Collect PartitionID information in monDeadLock, monLockTimeout, clmdiag

CR:741742

CR Number:   741742 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 02 Aug 2013 Fixed 30 Jul 2013 Reservation Made Description When a small table (number of rows is less than twice the number of steps in the histogram) has a unique index, the range density and range unique values may be inaccurate on the column set for the unique index. This costing change is enabled with optcriteria cr741742.

CR:741751

CR Number:   741751 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2013 Fixed 15.7 SP121 16 Dec 2013 Fixed 08 Jan 2014 Port Not Needed Description Under rare circumstances, the SAP ASE Cluster Edition keeps running into a lock lookup error and may hang. In the SAP ASE errorlog there will be messages such as "Cluster lock manager of instance 1 has received an invalid lookup request for directory instance 1 from instance 4"

CR:741759

CR Number:   741759 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2013 Fixed 25 Jun 2013 Fixed 27 Jun 2013 Fixed 19 Jul 2013 Fixed 31 Jul 2013 Fixed 31 Jul 2013 Reservation Made 04 Aug 2013 Fixed 15.7 SP121 26 Aug 2013 Fixed 15.7 SP121 27 Aug 2013 Fixed 28 Nov 2013 Fixed Description Enhance DBCC LOG to support specifying a start marker for the log scan when searching for log records affecting a page, or log records for a transaction. For some usages, the (indid, ptnid) arguments are over-loaded to specify a start (log page#, row #) marker for the log scan. Extend DBCC HELP('log') output to reflect the entire set of options, arguments and variations. Various other improvements to the scan filtering for DBCC LOG added.

CR:741770

CR Number:   741770 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 19 Jun 2013 Fixed 15.7 SP110 26 Jun 2013 Fixed 20 Jun 2013 Presently Not Targeted For Any Future Release Of This Product Description The error message, "Could not execute login script for user sa", may be reported in the error log when the global login trigger is updated with a new login trigger. Workaround Description  Use a new login trigger with an object name that is longer than the current name

CR:741786

CR Number:   741786 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 19 Jun 2013 Fixed 25 Jun 2013 One-off Provided 15.7 SP60 09 Jul 2013 Fixed 24 Jul 2014 Fixed Description A 706 error, "Process <pid> tried to remove PROC_HDR <phdr> that it does not hold in Pss", may be encountered when an SQL statement is executed and it is either stored in the SQL statement cache or it is a dynamic SQL statement and during execution a regeneration of the statement query tree from SQL text is required and an exception is encountered during the parsing of the corresponding SQL text.

CR:741799

CR Number:   741799 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 26 Jul 2013 Fixed 15.7 SP110 30 Jul 2013 Fixed 30 Jul 2013 Fixed Description The Sybmon restart command fails with an error, "Unknown command", when executed without specifying an engine number for a server running in process kernel mode. Workaround Description  Issue the restart command for each engine individually.

CR:741822

CR Number:   741822 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2013 Fixed 11 Dec 2013 Port Not Needed Description When create a huge size database(data size > 63G), stack trace including module pg__gam_extend() may be detected. For example executing statement as "create database testdb on ldev1='50m', #nulldev='7t', ldev2='50m' log on ldev3='50m'", it will hit the stack trace.

CR:741847

CR Number:   741847 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 01 Jul 2013 Fixed 18 Jul 2013 Fixed 15.7 SP60 20 Aug 2013 Fixed Description The 3051 message, "The dump configuration '' supplied for DUMP DATABASE is invalid", can be mistakenly returned for the valid dump configuration which has a 30 bytes long name.

CR:741871

CR Number:   741871 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 01 Jul 2013 Fixed Description The sp_downgrade_esd stored procedure cannot be used to downgrade to ASE 15.7 SP50.

CR:741894

CR Number:   741894 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP102 21 Jun 2013 Fixed 15.7 SP110 03 Jul 2013 Fixed 21 Jun 2013 Reservation Made Description When DDL replication is ON, the execution of a DDL command as a prepared statement aborts with error 11314. Trace flag 9152 can be used to allow the DDL command to proceed without being replicated.

CR:741900

CR Number:   741900 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Windows Original Version:   15.7 ESD#4 PL1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2013 Duplicate Description Dump database to TSM API may fail on Windows with the error message:

CR:741901

CR Number:   741901 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 21 Jun 2013 Fixed 15.7 SP60 08 Jul 2013 Fixed 24 Jun 2013 Fixed Description When a CREATE INDEX command is executed and the following conditions are met, (1) The configuration option, 'enable functionality group' is on and (2) The table upon which the index is being created has datarows locking scheme and (3) The first index-key column contains at least one NULL value and (4) a Lava parallel execution plan is used, then the resulting index may be missing rows for the NULL-valued columns. Workaround Description  use traceflag 549.

CR:741910

CR Number:   741910 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 31 Jul 2013 Fixed 15.7 SP121 21 Oct 2013 Fixed 02 Dec 2013 Fixed 15.7 SP111 07 Mar 2014 Fixed Description Enable a login with mon_role to execute sp_monitorconfig on SAP ASE 15.7

CR:741924

CR Number:   741924 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 01 Jul 2013 Fixed 15.7 SP110 28 Jun 2013 Fixed 15.7 SP102 28 Jun 2013 Fixed 15.7 SP50 02 Jul 2013 Fixed 04 Jul 2013 Fixed Description An undetected deadlock might occur between a process that ran out of syslogs space and has crossed the last chance syslogs threshold and another process that is attempting to expand the syslogs size by executing an ALTER DATABASE command. The output of dbcc stacktrace(<spid>) command for one of these two processes will show the modules 'th_sleep_on_lct' and 'upsleepgeneric' whereas for the other process the modules 'writeLock' and 'upyield'. An SAP ASE restart is needed to unblock this situation. Workaround Description  Set the database option abort tran on log full to TRUE. This option is not set by default.

CR:741934

CR Number:   741934 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2013 Fixed 15.7 SP121 21 Aug 2013 Fixed 15.7 SP110 22 Aug 2013 Fixed Description In rare circumstances, a time slice error may be reported in the error log followed by a stack trace which includes the modules ind_ides_init() and ind__ides_install() while DBCC TUNE ('des_bind') is executed concurrently with utility commands such as CREATE TABLE that is run at isolation level 0.

CR:741942

CR Number:   741942 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SIGSEGV in LeOrScanContext::getNextVtup().

CR:741950

CR Number:   741950 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2013 Added to user documentation Description Doc CR: please clarify that checkverify reads the suspect faults

CR:741953

CR Number:   741953 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2013 Not a Bug Description checkstorage and checkverify reporting faults inconsistently Workaround Description  sp_dbcc_faultreport "long", "dbname" instead of checkverify

CR:741959

CR Number:   741959 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 25 Jul 2013 Fixed 15.7 SP110 26 Jul 2013 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module mda__process_sdes() may be reported in the error log when querying the monProcessObject MDA table.

CR:741984

CR Number:   741984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 12 Jul 2013 Fixed Description A stack trace may occur when a CREATE INDEX command is interrupted (using Ctrl C) and the command is being executed using a parallel Lava query plan. The stack trace may include functions such as bt_create_index(), ups_stat_memalloc(), ups_get_stat_page() and/or memalloc_auxbufarray(), bufauxinstall() depending upon which phase of the CREATE INDEX processng is active at the time of the interrupt.

CR:742008

CR Number:   742008 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 25 Jun 2013 Fixed Description If a database that is created WITH ASYNC_INIT option is used before it is fully initialized as the target database of a LOAD command, the execution of system stored procedure sp_helpdb will display "Allocation Unit Initializer disk fragment" entries that should have been removed.

CR:742031

CR Number:   742031 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2013 Fixed 09 Jan 2014 Presently Not Targeted For Any Future Release Of This Product 04 Feb 2014 Fixed Description Shutting down an instance may cause a stack trace if I/O fencing is enabled.

CR:742061

CR Number:   742061 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When trying to insert a non-null value into a timestamp column and a light-weight procedure is recompiled, the insert statement fails due to a 137 error.

CR:742074

CR Number:   742074 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2014 Insufficient Info to Progress 28 Jun 2013 Reservation Made 03 Oct 2014 Port Not Needed Description In limited cases when a system is under heavy load, memory could be corrupted resulting in a self-referencing ptr in a names struct. This can result in a process allocating the entire procedure cache under cpynameslist(). The process cannot be killed requiring a server reboot. A check for a self-referencing names struct has been added in cpynameslist()and the overloaded error 7733, state 2 added if such a ptr is found. This error can be used for configurable memdumps. This check for a cyclic ptr reference is enabled under trace command line flag 7728.

CR:742098

CR Number:   742098 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 04 Nov 2013 Fixed 15.7 SP60 28 Oct 2013 Fixed 08 Nov 2013 Fixed 15.7 SP110 02 Nov 2013 Fixed Description A 1265 error, "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr=<value>, lrmagic=<value>)" together with a stack trace which includes the modules 'th_lct_admin' and 'num_logpages' may be reported in the error log if the builtin lct_admin("num_logpages", <dbid>) is executed concurrently by several processes.

CR:742139

CR Number:   742139 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2013 Fixed 15.7 SP102 28 Jun 2013 Fixed 01 Jul 2013 Reservation Made 15.7 SP110 28 Jun 2013 Fixed Description The message, "Current process infected with signal 11", in the module 'dam_prepare_dump_end' together with a stack trace which includes the modules 'dpdb_main' and 's_execute' may be reported in the error log when a DUMP DATABASE command is executed and the database option 'allow incremental dumps' is enabled and the system table SYSDAMS contains an extent that is the first extent of an allocation unit causing this table to have a number of pages that is not a multiple of 8. Workaround Description  Please, be aware that this workaround is to avoid hitting the problem. Once you hit the problem you are in troubles because you can have a transaction in the log that will avoid you can recover the database when you reboot, or that you can recover the database if you dump it (after disabling cumulative dumps) and load it somewhere else. We would need a way to get rid of the bad XREC_PAGEIMAGE record. With this fix, we are including the trace flag 3334 that could be used to skip this transaction. If the server has not been shutdown since the problem was found and the database is still usable, you could use a page editor (sybedit or /usr/u/cruiz/tools/CHPAGE/chpage*) tool to edit the log page reported the 3478 error, get the record offset by looking at the dbcc log() output, and using this offset + 2 bytes, replace the op 85 (0x55) value for XREC_PAGEIMAGE by 10 (0x0A) for XREC_NOOP. This way, if you reboot, this record will be skipped. If you have not hit the problem yet, you will know that you will potentially hit it if the number of pages in sysdams is not a multiple of 8. A possible workaround would be to recreate sysdams and hope it's created in a different extent. The following procedure can be repeated until we get a table with a number of pages multiple of 8: 1) Verify that this is your problem: dbcc traceon(3604) go declare @firstpage unsigned int select @firstpage=firstpage from syspartitions where id=58 dbcc pglinkage(<dbname>,@firstpage,0,2,0,1) go 2) Assuming you have a number of pages that is not < multiple of 8 dbcc traceon(3604) go dbcc traceon(3717) go dbcc dam(test,drop) go create table t(a text) go -- Insert some rows expecting that the space -- previously used by sysdams is reused by this table -- we will insert 100 rows, but if the allocation of -- sysdams later shows again that we picked up the -- first extent from the alloc unit, you may have -- to insert more or less rows..... insert t values(a) go 100 dbcc dam(test,create) go drop table t go declare @firstpage unsigned int select @firstpage=firstpage from syspartitions where id=58 dbcc pglinkage(<dbname>,@firstpage,0,2,0,1) go Verify that the table has now a multiple of 8, and if not, repeat this process changing the number of rows inserted in the table 't'. 3) If, in the very unlikely case of a brand new system that gets the table SYSDAMS created with less than 16 pages (it has to be exactly 16 pages), because this table would be copied to any new database, we would have to apply the workaround explained in 2 to the model database.

CR:742143

CR Number:   742143 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 11 Sep 2013 Fixed 15.7 SP121 09 Sep 2013 Fixed 15.7 SP110 09 Sep 2013 Fixed Description The nested level of functions in expressions has been raised from 10 to 32.

CR:742152

CR Number:   742152 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2013 Fixed 04 Jul 2013 Fixed 07 Jul 2013 Fixed 05 Jul 2013 Fixed 10 Jul 2013 Fixed 15.7 SP110 15 Jul 2013 Fixed 15.7 SP60 16 Jul 2013 Fixed 17 Jul 2013 Fixed Description 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. Workaround Description  Modify sp_sysmon to eliminate the "Socktab Spinlock[i]" spinlocks from the #temp_sysmon_baseline table. This doesn't affect any of the sp_sysmon metrics as far as we can tell. For the query: insert into #temp_sysmon_baseline select group_name, field_id, value from master.dbo.sysmonitors holdlock Add a where clause: insert into #temp_sysmon_baseline select group_name, field_id, value from master.dbo.sysmonitors holdlock /* adding the following to work around Err 1508 */ where field_name <> "Socktab Spinlock[i]" /* end workaroud for Err 1508 */

CR:742158

CR Number:   742158 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 01 Oct 2013 Fixed 30 Sep 2013 Fixed 01 Oct 2013 Reservation Made 15.7 SP121 03 Oct 2013 Fixed Description If 'literal autoparam' is enabled, the sometimes a print statement that uses a literal in a stored procedure could lead to remap error 2805 'Bad pointer 0x%p encountered while remapping stored procedure '%.*s'. Must re-create procedure.'. Workaround Description  Remove the print statement noted in the CR description. - or - Edit the procedure so that the parameters to the print statement noted in the CR description are all constants, rather than a mix of constants and literals. - or - Avoid the combination of abstract plan load = 1 and enable literal autoparam = 1

CR:742168

CR Number:   742168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 19 Jul 2013 Fixed 15.7 SP60 29 Jul 2013 Fixed Description When SAP ASE is running in process mode, if the dynamic listener is on a hung engine, SAP ASE may continuously report , "necheck: select, Bad file descriptor" in the errorlog.

CR:742191

CR Number:   742191 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2013 Fixed 26 Jul 2013 Fixed 15.7 SP110 01 Aug 2013 Fixed 24 Jul 2014 Fixed 25 Jul 2014 Port Not Needed Description SAP Adaptive Server may hang without reporting an error when the pool of locks is exhausted. Workaround Description  Increase configuration parameter 'number of locks' and restart Adaptive Server to workaround the problem.

CR:742199

CR Number:   742199 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2013 Duplicate Description Procudure sp_versioncrack does not handle new SAP SP style version string (from ASE 15.7 SP100). Workaround Description  Use updated procedure from /remote/cases/11792000s/11792121 in file versioncrack_corrected.sql

CR:742216

CR Number:   742216 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 02 Jul 2013 Fixed 08 Jul 2013 Deferred 15.7 SP60 03 Jul 2013 Fixed Description Booting an SAP ASE may fail permission checks with an error message, "Permission denied, database master, owner dbo. You need the following permission(s) to run this command: MANAGE SERVER CONFIGURATION", when the configuration parameter 'enable granular permissions' is set in the default configuration file.

CR:742226

CR Number:   742226 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 09 Sep 2013 Fixed 09 Sep 2013 Reservation Made 15.7 SP110 10 Sep 2013 Fixed 09 Sep 2013 Reservation Made Description Support of DDL replication for prepared DDL statements is now provided. This is enabled by trace flag 16984.

CR:742233

CR Number:   742233 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 28 Jun 2013 Fixed 15.7 SP60 02 Jul 2013 Fixed Description Incorrect results can be reported with 'streamlined dynamic SQL' on when using a subquery not containing a table reference to check for no rows returned. This can affect SQl constructs that include (but not limited to) isnull, nullif, case, if not exists & coalesce.

CR:742249

CR Number:   742249 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 19 Jul 2013 Fixed 15.7 SP60 28 Jul 2013 Fixed Description With single engine configurations, a SAP ASE polite shutdown request may hang if the JS Agent is executing a job whose spid is set to LOW priority. Workaround Description  start up ASE with more than 1 engine (syb_default_pool with number of threads more than 1)

CR:742263

CR Number:   742263 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 02 Jul 2013 Fixed Description The error 14108, "Could not find partition descriptor for objid, indid -1, ptnid in dbid" may be reported when either the command DBCC DBSHUTDOWN or DBCC FAILBACK_DBSHUTDOWN is executed and the database option 'allow incremental dumps' is enabled in the given database.

CR:742292

CR Number:   742292 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 04 Jul 2013 Fixed 04 Jul 2013 Fixed 15.7 SP110 07 Jul 2013 Fixed 15.7 SP60 04 Jul 2013 Fixed Description Sybmon might get hang with huge garbage SQL text printed when running "sample context=y" command. Workaround Description  Avoid using context=y with sybmon's sample command.

CR:742310

CR Number:   742310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 08 Jul 2013 Fixed Description After running DUMP DATABASE, the time stamp of some pages may become incorrect. If DBCC CHECKSTOREAGE is subsequently executed, error message "Fault Type: 100004 (timestamp error); Hard fault" may be reported.

CR:742312

CR Number:   742312 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Jul 2013 Fixed 15.7 SP51 10 Sep 2013 Fixed 15.7 SP110 13 Sep 2013 Fixed 15.7 SP121 17 Sep 2013 Fixed Description DDLGen generates duplicate partition values when a range or a list partitioned table has a local index Workaround Description  create the table with more than 1 range partition

CR:742352

CR Number:   742352 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2013 Fixed 15 Jul 2013 Insufficient priority to fix 18 Jul 2013 Reservation Made 15.7 SP110 04 Aug 2013 Fixed Description When running the DISK INIT/RE_INIT command or the sp_deviceattr stored procedure, ASE silently ignores dsync=false if DIRECTIO is not specified.

CR:742356

CR Number:   742356 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 09 Aug 2013 Fixed 15.7 SP110 12 Aug 2013 Fixed Description An 803 error, "Unable to place buffer <buf> from cache <cache_name> holding logical page <page_num> in sdes for object <object_name> - either there is no room in sdes or buffer already in requested slot", may be reported when running a multiple table join under parallel processing.

CR:742376

CR Number:   742376 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Jul 2013 Fixed 07 Mar 2014 One-off Provided 15.7 SP110 02 Jul 2013 Fixed 02 Jul 2013 Fixed 15.7 SP50 02 Jul 2013 Fixed 15.7 SP60 02 Jul 2013 Fixed 04 Jul 2013 Fixed Description The built-in function set_appcontext() mistakenly allows the update of an attribute without running rm_appcontext().

CR:742407

CR Number:   742407 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 08 Jul 2013 Fixed 02 Jul 2013 Reservation Made 02 Aug 2013 One-off Provided 19 Aug 2013 One-off Provided 13 Sep 2013 One-off Provided 15.7 SP51 10 Sep 2013 Fixed 15.7 SP103 11 Sep 2013 Fixed 15.7 SP60 17 Sep 2013 Fixed 15.7 SP110 17 Sep 2013 Fixed 15.7 SP121 19 Sep 2013 Fixed 23 Oct 2013 Fixed Description Add extra diagnostics for the data change fragment pool in order to help catch incorrect memory accesses of the data change fragment pool and thus also improve robustness.

CR:742434

CR Number:   742434 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 29 Oct 2013 Fixed 15.7 SP121 31 Oct 2013 Fixed 31 Oct 2013 Fixed Description The message "current process infected with 11" in the module 'pthread_kill' together with a stack trace will be reported in the error log on Linux platforms only, when the Java option is enabled, the Kernel mode is set to process mode, and the PCI option is disabled.

CR:742485

CR Number:   742485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   DYNIX/ptx Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Aug 2013 Fixed 03 Jul 2013 Fixed 15.7 SP121 03 Oct 2013 Fixed Description If 'stack size' is configured too small, sometimes it could lead to error, 'Stack guardword corrupted', with OmniQuickPass::generateSelect(), OmniQuickPass::generateStatement() in the stacktrace when select large number of columns for a remote table.

CR:742515

CR Number:   742515 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2013 Fixed 15.7 SP110 03 Jul 2013 Fixed 02 Jul 2013 Reservation Made Description RepAgent may not send table schema information to Replication Server if the table contains a compressible LOB column. RAT may also wrongly consider that a table contains a compressible column when it has sent the table schema to Replication Server.

CR:742541

CR Number:   742541 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2013 Reservation Made 15.7 SP121 16 Sep 2013 Fixed 14 Nov 2013 Fixed Description New 'force' option to the kill command to forcibly kill the spid.

CR:742603

CR Number:   742603 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 14 Jul 2013 Fixed 15.7 SP110 15 Jul 2013 Fixed 24 Jul 2014 Fixed Description The PhysicalReads value in the monProcessActivity and monProcessStatement MDA tables do not include APF Reads. The PagesRead value in the monProcessActivity MDA table is also incorrect.

CR:742623

CR Number:   742623 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description drop proxy table will cause the object definition to be dropped too

CR:742643

CR Number:   742643 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description infected with 11 in LeScanOp::LeGetScanInd