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

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

CR:732406

CR Number:   732406 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2013 Fixed 27 Feb 2013 Fixed Description sybmigrate does not preserve indexes in the indexid order.

CR:732410

CR Number:   732410 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2013 Presently Not Targeted For Any Future Release Of This Product 23 Jul 2013 Fixed Description In rare cases, dataserver can hang due to this deadlock situation: one session sleeps on grabbing DES while updating statistic in rollback a DELETE; the other session sleeps on writing dirty buffers when scavenging a DES.

CR:732482

CR Number:   732482 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) 25 Sep 2013 Fixed 25 Sep 2013 Fixed Description A query against a remote table may get a signal 11 during UPDATE STATISTICS. Workaround Description  If the remote server is also an ASE server, then a possible workaround may be to use trace flag 11229, which will suppress importing statistics from the remote server during update statistics, and instead will read all the rows from the remote server to generate up-to-date statistics (but this could be a much slower process).

CR:732503

CR Number:   732503 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) 06 Nov 2014 Fixed 12 Nov 2014 Fixed 03 Dec 2014 Fixed 10 Dec 2014 Fixed Description The message "current process infected with 11 (SIGSEGV)" in the module 'des__clean' together with a stack trace which includes the modules 'des_refreshall' and 'online_database' may be reported in the SAP ASE error log when multiple sessions are executing the ONLINE DATABASE command simultaneously for the same database. This will result in SAP ASE shutting down implicitly. Workaround Description  single session to online a specific database, avoid concurrent online the same database.

CR:732560

CR Number:   732560 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 ASE attempts to checkout a license after it is already checked-out.

CR:732588

CR Number:   732588 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 02 Apr 2013 Fixed 08 Apr 2013 Fixed Description Under certain circumstances when a threshold action is defined, and user is dropping a procedure, and the procedure happens to be the last row of the sysprocedures page, an 873 error may be reported when log space is low, and the threshold proc gets spawned. Workaround Description  Do not use user-defined optimization goals.

CR:732604

CR Number:   732604 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) 22 Feb 2013 Fixed 15.7 SP50 12 Jun 2013 Fixed Description The summary stats for histogram (i.e. unique count, density) generated by hash based statistics gathering may be inaccurate. This could occur when OPTDIAG labels a histogram as "high domain".

CR:732613

CR Number:   732613 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Linux Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2014 Fixed 17 Jan 2014 Fixed 21 Jan 2014 Fixed Description 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"]" Workaround Description  set quoted_identifier off go sp_sjobcontrol @name=NULL, @option='start_js' go

CR:732631

CR Number:   732631 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 19 Aug 2013 Fixed 15.7 SP121 20 Aug 2013 Fixed 28 Nov 2013 Fixed Description REORG REBUILD <table_name> WITH ONLINE command, does not update the index create time-stamp(index_created field in sp_helpindex output) for the indexes rebuilt.

CR:732640

CR Number:   732640 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2013 Fixed Description Schema lock displayed as GUID lock in sp_lock output

CR:732693

CR Number:   732693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2013 Fixed 23 Jan 2014 Fixed Description ALTER TABLE <TABLENAME> SPLIT PARTITION may fail with errors such as 2601 (Attempt to insert duplicate key row in object <name> with unique index <name>) when there is a non-clustered index.

CR:732723

CR Number:   732723 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2013 Added to user documentation Description typos and fix problems for fast bcp section of utility guide

CR:732728

CR Number:   732728 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2013 Fixed 20 Mar 2013 Fixed Description The unreserved space stored in the table sysusages can become a huge number bigger than the fragment itself if the number of allocated pages indicated in the OAM pages for some objects becomes corrupted and show pages allocated that are not.

CR:732777

CR Number:   732777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2013 Fixed 25 Feb 2013 Fixed Description Under some circumstances, a 4720 error "Cannot truncate table '%.*s' because there are one or more isolation level 0 scans, or REORG command, active on the table." may be reported while a temporray is being dropped. Such temporary table is found to have a dlevel0cnt = 12.

CR:732841

CR Number:   732841 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RepAgent won't connect to RepServer when 'cis connect timeout' > 2147.

CR:732911

CR Number:   732911 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2013 Duplicate Description If a table has constraint check and its name is quoted identifier, when migrate the table, sybmigrate failed in the error like that: SqlState: 42000 java.sql.SQLException: Incorrect syntax near

CR:732921

CR Number:   732921 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2013 Fixed Description A 8201 error, "Keep count of descriptor (objid=14, dbid=<value>) was expected to be 1. Instead 0 was found" followed by a stack trace that includes the module 'des__unkeep' may be raised if ASE fails to allocate space for either SYSGAMS or SYSDAMS.

CR:732977

CR Number:   732977 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: create a parameter that will make getutcdate() only be evaluated once per statement as getdate() is by default. Workaround Description  use the case statement

CR:732995

CR Number:   732995 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) 07 Mar 2013 Fixed 13 Mar 2013 One-off Provided 14 Mar 2013 Fixed Description Sometimes Procedure Cache ELC (Engine Local Cache) for some of the engines does not get configured during engine boot, which leads to Procedure cache ELC not getting used on the engine and thus leads to contention on the rproccache_spin spinlock. This condition can be detected using the ASE errorlog. If an engine is brought online but does not have the message "Proc header memory allocated <nn> pages for engine <engine_id> local cache" for that engine then the Procedure Cache ELC is not properly configured for that engine.

CR:733006

CR Number:   733006 Product Name:   ASE Management Product Component:   sybrestore Status:   Closed OS:   Generic Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2013 Fixed Description This problem may show up when the database has first bit set ON in the status (meaning upgrade started on this database) and the database devices, that are inactivated in a database, may not get 'init' by Sybrestore.

CR:733051

CR Number:   733051 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2013 Fixed 06 Mar 2013 Fixed Description If the number of system roles of target server is more than source server's, after running symigrate -m migrate, sybmigrate will drop from sysusers those roles that are 'new' in the target server. This issue can specially be seen when users are migrating from ASE 12.5.4 to ASE 15.7.x

CR:733146

CR Number:   733146 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2013 Fixed 19 Mar 2013 Fixed Description In rare cases, the message "Invalid column length" may be reported in the ASE errorlog to indicate there are issues in the index creation when creating an index on a Page Compressed table. Workaround Description  +) For DOL table, Pls turn on TF 549 to disable lava pll create index +) For APL table, Pls remove the 'with consumers" clause to use serial sort +) No workaround if you create a clustered index on APL table. +) Pls add 'with consumers" and turn on TF549 to use old pll create index if you create a placement index on DOL table.

CR:733194

CR Number:   733194 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) 04 Mar 2013 Fixed 01 Apr 2014 Fixed Description Incorrect disk activity may be reported by sp_sysmon_diskio when there is no disk I/O in given sample period on this device. Workaround Description  re-initialize the SUM() conditionals to 0 if it returns null by using function isnull(SUM(value), 0)

CR:733215

CR Number:   733215 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2013 Fixed Description After upgrading, the value of systabstats.rowcnt for the syspartitions and sysobjects tables will be 1 less than the actual number of rows in these two system tables.

CR:733226

CR Number:   733226 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 20 May 2013 Fixed 11 Apr 2013 Fixed 15.7 SP110 21 May 2013 Fixed Description If a parallel plan's thread count exceeds the session's parallel degree, then the plan will undergo Compile time Thread Adjustment (CTA). If the plan contains a semantic scan under a semantic dependent operator (JOIN, DISTINCT, GROUP, or UNION_DISTINCT), then the semantic dependent operator's plan fragment (from its containing xchg op) may have it's degree adjusted incorrectly which could result in wrong results. Workaround Description  There are a few workarounds: 1. Remove the subquery since there exists an equivalent JOIN CLAUSE in the query. For test query in house: select count(*) from #tab1 t1, #tab2 t2, pbugs3_tab p (index pbugs3_tab_ci) where p.creation_ts=t1.creation_ts and p.sy_product_family=t1.sy_product_family and p.sy_product_family=t2.sy_product_family --- --- and p.sy_product_family in (select sy_product_family from #tab2) -- the subquery above is equivalent to p.sy_product_family=t2.sy_product_family --- and t1.bug_id between p.bug_id and p.bugid2 ------------- For customer's original query: SELECT count(*) from #EntGMT1_aam3 E , Scenarios_vector V (index PK_Scenarios_2), <-- range partitioned table #RsPRsk1_aam3 RF WHERE E.COBDate = V.COBDate <-- V.COBDate is range partition column AND V.ID_ENTITY = E.ID_CHILD AND RF.ID_RISK_FACTOR = V.ID_RISK_FACTOR --- AND V.ID_RISK_FACTOR IN (SELECT ID_RISK_FACTOR FROM #RsPRsk1_aam3) -- may be removed AND RF.IsVaR = 1 AND E.ts_begin BETWEEN V.ts_begin AND V.ts_end -------------------------------- The subquery is equivalent to join clause: RF.ID_RISK_FACTOR = V.ID_RISK_FACTOR ------------------------ 2. Use serial plan via 'set parallel_query off'

CR:733305

CR Number:   733305 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 07 Apr 2013 Fixed 24 Mar 2013 Fixed 07 Apr 2013 Fixed 02 May 2013 One-off Provided 23 May 2013 One-off Provided Description An ASE spid with remote I/O may hang when killed. Even reissuing the kill does not help.

CR:733331

CR Number:   733331 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2014 Fixed 19 Jan 2015 Fixed 16 Nov 2014 Fixed 18 Dec 2014 Fixed Description Error message 1509 may be raised when CREATE INDEX or UPDATE STATISTIC is executed in parallel on huge table where there are very few distinct COLUMNS values. Workaround Description  Configure bigger value for "number of sort buffer" can avoid this issue to occur.

CR:733346

CR Number:   733346 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2013 Fixed 15.7 SP60 19 Jul 2013 Fixed Description The stored procedure sp_dropexternlogin will fail when executed by a user that has SSO_ROLE and not SA_ROLE when granular permissions is not enabled.

CR:733367

CR Number:   733367 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2013 Fixed 15.7 SP121 15 Aug 2013 Fixed 15 Aug 2013 Fixed 15.7 SP110 20 Aug 2013 Fixed 15.7 SP121 20 Aug 2013 Fixed Description Provide downgrade support from 15.7 SP110 to SP100 to prevent loading database or transaction dumps containing transactional activity from INSERT-BULK with parallel index updates work load. Extend db_attr(), and loginfo() built-ins to examine database feature-set. Extend LOAD ... WITH HEADERONLY to report the features found in the dumps.

CR:733428

CR Number:   733428 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2013 Fixed 15.7 SP121 24 Oct 2013 Fixed 09 Aug 2013 Reservation Made 13 Sep 2013 Fixed 15.7 SP60 14 Oct 2013 Fixed 01 Dec 2013 Fixed Description The "recovery prefetch size" configuration parameter is added to configure the lookahead size (in terms of log pages) in order for recovery to prefetch to-be-recovered pages. When set to 0, SAP ASE will automatically optimize the value.

CR:733446

CR Number:   733446 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2013 Fixed Description In DDLGen 15.7 ESD#3 and later, 'set quoted_identifier on' is reported in the DDL output even when it is not specified in the actual create table SQL.

CR:733462

CR Number:   733462 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 SP50 02 Apr 2013 Fixed 13 Mar 2013 Fixed Description A timeslice error may occur followed by a stack trace involving the module itl_au_update_xfer_mark() with executing BCP-IN or update DMLs, if 'transfer table' is set on a large table with data more than 47GB on 2KB page size (95GB on 4KB pagesize, 190GB on 8KB pagesize, 380GB on 16KB pagesize). Workaround Description  Possible workaround is to turn off transfer table on the table being bcp'ed into.

CR:733573

CR Number:   733573 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2013 Bundled Request 30 Aug 2013 Added to user documentation Description Use "SET ISQL" command to set the option. Maximum number of rows can be set through command "SET ISQL _maximum_displayed_rows '<value>'". Note the previous command only makes the new value applicable to the session. To make the option permanent, use command "SET ISQL PERMANENT _maximum_displayed_rows '<value>'". Note the optional keyword "PERMANENT" or "TEMPORARY" after "ISQL" is new in DBISQL16/ASE.

CR:733579

CR Number:   733579 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2014 Fixed 01 Apr 2014 Fixed 03 Apr 2014 Fixed Description 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.

CR:733604

CR Number:   733604 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) 06 Mar 2013 Fixed 22 Apr 2013 Fixed Description Add the ability to suppress warning message regarding the ignoring of hints under the presence of abstract plans. This is enabled under Trace Flag 15381.

CR:733623

CR Number:   733623 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 SP50 03 Apr 2013 Fixed 20 Mar 2013 Fixed 27 Mar 2013 Fixed Description ASE allows configuration parameter 'max online engines' to be set to a value lower than 'number of engines at startup' leading to an incorrect value for the parameter 'max online Q engines'. This can result in incorrect calculations for the 'maximum number of engines' resulting in ASE hitting a SIGSEGV followed by a stack trace involving the module ueisonline(). Workaround Description  Ensure 'max online engines' is higher than 'number of engines at startup' + 'max online Q engines'.

CR:733750

CR Number:   733750 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) 05 Mar 2013 Fixed 15.7 SP50 12 Jun 2013 Fixed Description Timeslices may occur with statistics gathering using hashing.

CR:733752

CR Number:   733752 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) 05 Mar 2013 Fixed 15.7 SP60 28 Jun 2013 Fixed Description The estimate for NULLs in the optimizer may be incorrect if hash based statistics gathering is used, when the number of unique values in the column is greater than 65535.

CR:733766

CR Number:   733766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2013 Fixed Description The severity of error message 5805 and 5806 is now changed from EX_USER to EX_INFO since they are just warnings.

CR:733776

CR Number:   733776 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2013 Fixed 15 Apr 2013 Fixed 06 Jun 2013 Not a Bug 02 Jun 2013 Not a Bug 02 Jun 2013 Not a Bug 02 Jun 2013 Not a Bug Description After an upgrade, execution of a procedure may fail with error 102 "incorrect syntax near [ endend | grantgrant ]" and error 11031 due to the source code being stored incorrectly in syscomments when it contains multiple GRANT statements. Manually correct the source code, then drop and re-create the procedure.

CR:733838

CR Number:   733838 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2013 Fixed Description ASE no longer rejects requests to add remote logins with same server name as local server.

CR:733893

CR Number:   733893 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2013 Fixed Description Device Props does not display databases that are using a device on little-endian machines. On big-endian machines, unintended databases may get displayed.

CR:733904

CR Number:   733904 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2013 One-off Provided 15.7 SP50 10 Apr 2013 Fixed 10 Apr 2013 Fixed 30 May 2013 One-off Provided Description Active roles being reset leading to permission errors.

CR:733907

CR Number:   733907 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2013 Fixed 20 Mar 2013 Fixed Description The error 822 "Could not start I/O for request.." followed by a stack trace that includes the module altdb_shrinklog() could be raised in a Cluster Edition server if a fragment of the database log is shurnk using the command ALTER DATABASE LOG OFF and the device where this fragment was is dropped.

CR:733932

CR Number:   733932 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2013 Fixed 15.7 SP50 17 Jun 2013 Fixed 15.7 SP110 18 Jun 2013 Fixed 25 Jun 2013 One-off Provided Description When a user with sso_role runs a query accessing a table, a 2736 error, "Owner name that was specified is a group name. Objects cannot be owned by groups" may occur followed by a 706 error, "Process <n> tried to remove PROC_HDR <addr> that it does not hold in Pss", during recompiling a light-weight procedure if statement cache is enabled. The processed will be terminated. Workaround Description  turn off statement cache or add the login that is failing with 2736/706 errors as a legitimate user of the current database

CR:733937

CR Number:   733937 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) 07 Mar 2013 Fixed 15.7 SP50 12 Jun 2013 Fixed Description When using hash based statistics gathering on columns with more than 65535 unique values there is a possibility of inaccurate summary statistics of the range density and range unique counts as displayed in optdiag. This may lead to suboptimal query plan selection.

CR:734031

CR Number:   734031 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2013 Fixed Description Add open client version to monProcess under column ClientVersion

CR:734125

CR Number:   734125 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2013 Fixed Description The 695 error, "An attempt was made to read logical page '<n>' for database '<dbname>'..." could be raised in an archive database when the database dump contains more than 256 contiguous log pages.

CR:734176

CR Number:   734176 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 SP60 09 Jul 2013 Fixed 15.7 SP110 19 Jul 2013 Fixed Description If DBCC DBREBOOT is unsuccessful for some reason, the status in sysdatabases may sometimes incorrectly indicate that a forced shutdown is in progress, even after SAP ASE has been shutdown and rebooted successfully. Workaround Description  Bit can be cleared with an update followed by an immediate shutdown with nowait update sysdatabases set status3=(select status3 from sysdatabases where dbid=1) where name='dbname' go shutdown with nowait go

CR:734184

CR Number:   734184 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2013 One-off Provided 15.7 SP110 24 May 2013 Fixed 15.7 SP50 23 May 2013 Fixed 15.7 SP101 24 May 2013 Fixed 04 Jun 2013 One-off Provided Description In rare occasions, Adaptive Server's internal timer becomes non-operational. Such occurrence is reported to the errorlog with messages like Warning: Alarm Service for Timer non-operational. If this message generated multiple times, report to support and restart the server (alarminterval=-7001)

CR:734204

CR Number:   734204 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2013 Fixed 14 Nov 2013 Reservation Made 21 Nov 2013 Fixed 13 Dec 2013 Fixed 13 Dec 2013 Reservation Made Description When the configuration parameter 'max network peek depth' is configured to a positive value, ASE will look for an attention up to the specified depth in the pending input on a connection, and if one is found, all input preceding the attention packet as well as the attention packet itself are discarded, the currently executing command is canceled and an attention acknowledgement is sent to the client. When running with the default value 0 of the configuration parameter, ASE looks for an attention only at the start of pending input.

CR:734211

CR Number:   734211 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2013 Fixed 15.7 SP50 16 May 2013 Fixed Description DDLGen can generate an incorrect header message while generating ddl for a load profile. Instead of saying 'DDL for LoadProfile', it can say 'DDL for :user'.

CR:734212

CR Number:   734212 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 08 Apr 2013 Fixed 09 Apr 2013 Fixed 05 Jun 2013 One-off Provided Description ASE hits SIGNAL 11 (SIGSEGV) when it runs out of spinlocks under heavy CT-Lib calls if 'max cis remote connections' configuration value is DEFAULT (which is 0). Setting 'max cis remote connections' to appropriate value is suggested to avoid reserving high number of spinlocks (upto four times 'number of user connections').

CR:734214

CR Number:   734214 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2013 Fixed 07 Mar 2013 Fixed 07 Mar 2013 Reservation Made 20 Mar 2013 Fixed 11 Mar 2013 Reservation Made Description Command line trace flag 16964 is added to turn off the row constructor optimization for range predicates. This optimization may cause an underestimate of the limiting selectivity of an index scan when a range predicate exists on an indexed column followed by limiting predicates on subsequent columns. For example, if an index I(a,b,c) has predicates a>5 and b=10 and c>20 then the range predicate on a is followed by minor attributes b and c which also have limiting predicates... then the scan selectivity on the index "I" may be underestimated.

CR:734218

CR Number:   734218 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description plan removed from procedure cache for trigger when you have an raise error in triggers.

CR:734253

CR Number:   734253 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2013 Added to user documentation Description After moving the transaction log to another device and data and log devices are separated, the database may still keep "mixed log and data" status. dbcc findstranded(database_name) can be executed to correct the status if needed.

CR:734394

CR Number:   734394 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2013 Fixed Description When ASE Server is not in single user mode during sp_downgrade 'prepare', report a warning message to indicate it instead of stopping the validation.

CR:734395

CR Number:   734395 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2013 Fixed 12 Mar 2013 Presently Not Targeted For Any Future Release Of This Product Description When dropping an encryption key, the 15401 message is reported with malformed values in the message.

CR:734464

CR Number:   734464 Product Name:   Adaptive Server Enterprise Product Component:   coverletter Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2013 Added to user documentation 15 May 2013 Added to user documentation 26 Jun 2013 Added to user documentation 19 Jul 2013 Not a Bug 26 Jun 2013 Added to user documentation 26 Jun 2013 Added to user documentation 09 Jul 2013 Added to user documentation 04 Jul 2013 Added to user documentation 04 Jul 2013 Added to user documentation 18 Jul 2013 DEFER Description Cover letter CR for ASE 15.7 SP50. Was ESD#5 and previously ESD#4.2

CR:734470

CR Number:   734470 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 08 Aug 2013 Fixed 15.7 SP121 04 Nov 2013 Fixed 07 Aug 2013 Bundled Request 08 Nov 2013 Fixed Description When SAP ASE is booted with trace flag 7437 it will not switch from an OAM scan to an allocation page scan when an incorrect page count value in one or more OAM entries is found during boot time recovery and while calculating the free space page counts for a database.

CR:734475

CR Number:   734475 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 22 May 2013 Fixed 19 Jul 2013 One-off Provided 15.7 SP50 16 Jun 2013 Fixed 12 Feb 2014 Port Not Needed 23 Jul 2014 Fixed Description The LogicalReads value in the monProcessActivity and monProcessStatement MDA tables remained unchanged when a long query is executing.

CR:734485

CR Number:   734485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description segv in rvm_fetch_attr() when using a cached plan during validation of view and objects used s_mustrecompile() and possibly prot_validate() in calling path.

CR:734500

CR Number:   734500 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2013 Fixed 15.7 SP50 10 Apr 2013 Fixed 10 Apr 2013 Fixed Description The index page scanning selectivity estimate may be too optimistic for an index, in which a prefix of 0 or more positioning equality predicates (such as r.a = 1 and r.b = 2) is followed by a positioning range predicate such as (r.c > 5) is following by subsequent trailing positioning predicates (such as r.d = 10 and r.e >= 20). The change enabled by the new optcriteria limit_row_constructor will limit the index page scan reduction by at most 50% (in our example it will limit reductions contributed by r.d, r.e). Workaround Description  use abstract plan

CR:734605

CR Number:   734605 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 Need a description and formula for multiple dependent SARGs selectivity estimation on 15.7.x

CR:734617

CR Number:   734617 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 SP60 06 Aug 2013 Fixed 15.7 SP110 07 Aug 2013 Fixed Description Adaptive Server 15.7 may execute SELECT queries at isolation level 3 on Data Only Locked scheme tables slower than SAP ASE 15.0.3 or 15.5 if the session executing the SELECT query holds a large number of locks.

CR:734660

CR Number:   734660 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2013 Fixed 20 Mar 2013 Fixed 26 Mar 2013 One-off Provided 01 May 2013 Fixed Description The error "Page Verification Error: Page mismatch. Page <page #> contains 0 in page header." could be incorrectly printed in the Backup Server errorlog when executing DUMP DATABASE WITH VERIFY. This error is spurious and can be ignored.

CR:734674

CR Number:   734674 Product Name:   ASE Management Product Component:   Monitoring Agent Plugin Status:   Open OS:   Generic Original Version:   3.2.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Filter SQL in SQL Activity Window (SCC)

CR:734702

CR Number:   734702 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2013 Fixed 20 Mar 2013 Fixed Description For objects with no storage, error 691 may be reported while running a CREATE INDEX command if either a dump is in progress or an incremental dump is in progress.

CR:734705

CR Number:   734705 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2013 Fixed 20 Mar 2013 Bundled Request Description After running sp_reptostandby/sp_setreptable/sp_setrepcol with "use_index" option on compressed in-row LOB columns, dbcc checktable() may report various kinds of index errors.

CR:734716

CR Number:   734716 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) 20 Mar 2013 Fixed 20 Mar 2013 Fixed Description At times the systabstats empty page count column may get values near to 2^32 (~4294967295) if inserts into a table are rolled back.

CR:734750

CR Number:   734750 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   AIX 5.1 Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 06 Jun 2013 Fixed Description srvbuildres optimization fails when specifying '16K' as the logical page size in the resource file for the Adaptive Server. Workaround Description  use "16k"(lowercase) instead of "16K"(uppercase)

CR:734761

CR Number:   734761 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description NFR: enable more than 32767 user connections in ASE

CR:734800

CR Number:   734800 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 26 Sep 2013 Fixed 15.7 SP60 27 Sep 2013 Fixed 13 Nov 2013 Fixed Description Backup Server may occasionally report a spurious error when executing a DUMP or LOAD WITH VERIFY[ONLY], as a result of checking a page that is already deallocated. This is more likely to happen when the deallocated page belonged to compressed table.

CR:734866

CR Number:   734866 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2013 Fixed Description The builtin asehostname() is now made a grantable builtin.

CR:734897

CR Number:   734897 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 SP50 03 Apr 2013 Fixed 08 Apr 2013 One-off Provided 09 Apr 2013 Fixed Description On a High Availability (HA) System, sp_companion may hang if sp_sysmon is running at the same time. Workaround Description  Do not run sp_companion while sp_sysmon is running.

CR:734899

CR Number:   734899 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 12 Jul 2013 Fixed 15.7 SP110 15 Jul 2013 Fixed 07 Aug 2013 Bundled Request Description A 692 error, "Uninitialized logical page <pageno> was read while accessing database ...", may be reported after loading an in-memory database dump from a database where this page was used but was marked as deallocated incorrectly, resulting in this page not being archived in the dump. Workaround Description  Before taking the imdb memory dump execute: sp_dumpoptimize 'archive_space=maximum'

CR:734968

CR Number:   734968 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2013 Fixed Description Sometimes queries that involve multiple DERIVED TABLEs or VIEWs may return wrong results. The kind of queries that could be affected by this needs the following elements: (1) A DERIVED TABLE with a correlated expression SUBQUERY as one of the DERIVED TABLEs SELECT list items. (2) Another correlated SUBQUERY in the parent query block which is referencing the expression SUBQUERY result from 1) as the correlated column. (3) Both 1) and 2) are under an IN SUBQUERY of the top query block. 1) and 2) lead ASE query tree to use a worktable for the DERIVED TABLE and 3) puts an EXISTS requirement over a table used by the DERIVED TABLE. The combination causes ASE to miss the EXISTS requirement on the table when generating a plan and leads to duplicate rows. Workaround Description  compatibility mode

CR:734983

CR Number:   734983 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 13 Sep 2013 Fixed 15.7 SP60 07 Aug 2013 Fixed 05 Jul 2013 Reservation Made 22 Nov 2013 Fixed Description Added new option SET PLAN SHARED ON and server wide param 'abstract plan sharing'. It enables Abstract Plan sharing between different users. Tables in the query with shared abstract plan must be explicitly prefixed with the owner name or belong to the DBO user.

CR:735003

CR Number:   735003 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 29 Jul 2013 Fixed 29 Jul 2013 Reservation Made 15.7 SP121 29 Oct 2013 Fixed 15.7 SP121 29 Oct 2013 Fixed 18 Nov 2013 Fixed Description The built-ins or stored procedures that rely on OAM for space accounting get blocked on an exclusive table lock on the table.

CR:735029

CR Number:   735029 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2013 Fixed 15.7 SP50 10 Apr 2013 Fixed 09 Apr 2013 Fixed Description When the source server is 15.7 ESD#2 or later, sybmigrate -m migrate session may fail with the error, "The catalog 'sysusers' in the target database appears to contain rows which were either installed by the user or were previously migrated. Cannot proceed with migration of 'Users'".

CR:735036

CR Number:   735036 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2013 Fixed 28 Mar 2013 Reservation Made 02 May 2014 Fixed 02 May 2014 Fixed 02 May 2014 Port Not Needed 28 Apr 2014 Port Not Needed 28 Apr 2014 Port Not Needed Description When running concurrent SELECT commands and DELETE/UPDATE commands on TEXT/IMAGE/UNITEXT columns, the client connection may hang or report a TDS token error or raise error 7128 state 6.

CR:735107

CR Number:   735107 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) 25 Jul 2013 Fixed 15.7 SP60 29 Jul 2013 Fixed 15.7 SP110 30 Jul 2013 Fixed Description A 247 (arithmetic overflow) error may be reported when the syscachepoolinfo and syscacheinfo MDA tables are queried. Workaround Description  The customer can recreate this view ,syscacheinfo, with below modification: change from : convert(numeric(5,2), convert (float,cu.memory_used ) / 1024) change to : convert(numeric(7,2), convert (float,cu.memory_used ) / 1024) This view isn't a system table, just a user view created by installmaster. If they do recreate the view, they will also want to set permissions, just as installmaster does. grant select on syscacheinfo to public

CR:735163

CR Number:   735163 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 SP50 04 Apr 2013 Fixed 08 Apr 2013 One-off Provided 11 Apr 2013 Fixed 11 Apr 2013 Reservation Made Description Adaptive Server Enterprise may crash and generate a core dump without any stack trace or messsage while multiple sessions run sp_companion simultaneously in threaded kernel mode.

CR:735187

CR Number:   735187 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2013 Fixed Description A 2583 error, "Number of data pages <value> counted by DBCC differs from count in the data OAM <pageid> for dbid <dbid> object <objectid>." may be reported when running DBCC CHECKTABLE on a table having a clustered index or placement index after the database that the table resides on experienced a load tran of ASE 15.5 or earlier to a server of ASE 15.7 or after. Workaround Description  Run DBCC TABLEALLOC on the affected tables.

CR:735223

CR Number:   735223 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2013 Duplicate Description Deffered Name resolution can cause unexpected syntax errors

CR:735256

CR Number:   735256 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 12 Aug 2013 Fixed 12 Aug 2013 Reservation Made 15.7 SP60 15 Aug 2013 Fixed 15.7 SP121 03 Oct 2013 Fixed Description Sometimes an insert query with union view or derived table with union in which tables have check constraint, could cause a signal 11 (SIGSEGV) and a stacktrace in errorlog involving the function NormalizeScalar().

CR:735270

CR Number:   735270 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2013 Fixed Description For query SELECTing multiple count aggregates, wrong result could happen when the final plan uses two phase aggregates. One of the count aggregates could come from an AVG(). It is more likely to happen when the two phase aggregate plan is also a parallel plan, or when the query is also a GROUPBY query with a HAVING clause equal-comparing two of the count aggregates. Workaround Description  set advanced_aggregation off

CR:735292

CR Number:   735292 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2013 Fixed 25 Apr 2013 Fixed 24 Apr 2013 Fixed 15.7 SP50 11 Apr 2013 Fixed Description An ASE task making a remote procedure call to a server with server option 'net password encryption' set to true and 'cis_rpc_handling' disabled can go to sleep indefinitely and the client appears to be hung.

CR:735311

CR Number:   735311 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2013 Fixed 15.7 SP50 10 Apr 2013 Fixed Description syconfig.exe fails to optimize the server.

CR:735327

CR Number:   735327 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 22 Mar 2013 Fixed 02 Apr 2013 Fixed 26 Mar 2013 One-off Provided 01 May 2013 Fixed Description A 692 error, "Uninitialized logical page '24' was read while accessing object '2' in database '<dbid>'. Please contact Sybase Technical Support." may be reported when a 12.5.4 ASE database dump that was made with a 15.7 ESD#4.2 Backup Server is loaded back in a 12.5.4 ASE.

CR:735346

CR Number:   735346 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2013 Fixed 05 Sep 2013 Fixed 15 Sep 2013 One-off Provided 27 Nov 2013 Fixed Description ALTER TABLE on a data compressed table may lead to heap memory (CPINFO pool) corruption. ASE stacktraces may be seen involving the functions kbfalloc() and cpinfo_allocbufs().

CR:735394

CR Number:   735394 Product Name:   Adaptive Server Enterprise Product Component:   sybsetup - UNIX Status:   Open OS:   AIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request to know how much of the disk space requirements for installing ASE so customer can be sure that they have enough space when they are ready to install. Workaround Description  Users can run the installer in interactive mode (GUI or console) to test the space requirement. If they see the "Pre-Installation Summary" panel, then the disk space requirement is satisfied. In this panel, they can click Next to continue the installation or quit the installer and rerun it in silent mode at later time.

CR:735431

CR Number:   735431 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2013 Fixed 26 Mar 2013 One-off Provided 01 May 2013 Fixed 03 Apr 2013 Fixed Description The error, "Table Corrupt: The row number and offset of each row in the page should have a matching entry in row number table ..." will be incorrectly reported in the Backup Server error log on pages with deleted rows that belong to an All Pages Locked table when executing DUMP/LOAD WITH VERIFY.

CR:735513

CR Number:   735513 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2013 Fixed Description System table sysusers is accessed too often during procedure execution.

CR:735516

CR Number:   735516 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2013 Fixed 18 Apr 2013 Reservation Made 15.7 SP60 07 Aug 2013 Fixed 15.7 SP110 12 Aug 2013 Fixed Description Need a mechanism to change the size of Engine Local Cache (ELC). By default ELC is 50 % of configured procedure cache size.

CR:735567

CR Number:   735567 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2013 One-off Provided 15.7 SP50 05 Apr 2013 Fixed 01 May 2013 Fixed 04 Apr 2013 Fixed Description The Backup Server is enhanced to perform consistency checks on Data Only Locked (DOL) index pages besides data pages during DUMP DATABASE execution.

CR:735568

CR Number:   735568 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description checkalloc is running 9-15 hours

CR:735578

CR Number:   735578 Product Name:   SCC Web Framework Product Component:   Repository Status:   Closed OS:   RH Linux Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 5515 04 Dec 2013 Bundled Request Description Need SCC built with SQL Anywhere 12.0.1 3842 or later Workaround Description  Set SA_DISABLE_DIRECTIO=1 prior to starting SCC.

CR:735590

CR Number:   735590 Product Name:   Adaptive Server Enterprise Product Component:   SQL Status:   Closed OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2013 Work as design Description user can get set tracefile rights when login is not a user in master db

CR:735660

CR Number:   735660 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2013 Third Party Problem Description monThread can have incorrect values on AIX, which can result in overly large or negative values in the sp_sysmon OS section.