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

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

CR:735662

CR Number:   735662 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) 03 Oct 2013 Fixed Description In rare scenarios, highly contended system with large number of databases, workload consisting of large number of short dmls, rdbts_spin could be highly contended.

CR:735692

CR Number:   735692 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2014 Fixed 16 Jan 2014 Fixed 17 Jan 2014 Fixed Description The function row_count() when used on system tables returns zero after upgrade from SAP ASE 12.5.4 Workaround Description  Run update statistics on system tables after upgrade.

CR:735705

CR Number:   735705 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2013 Fixed Description If a procedure get recompiled during execution, query against monProcessProcedures may get duplicate procedure entries.

CR:735727

CR Number:   735727 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2013 Fixed Description When updating an in-row LOB datum to NULL, the LTL generated for the update of the datum wrongly includes the LTL qualifier 'tpinit' instead of the qualifier 'zerolen'. This does not cause data corruption, or interruption of replication. Nevertheless, according to the LTL specification, the qualifier 'zerolen' must be used.

CR:735752

CR Number:   735752 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 PL1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When using ResultSet.deleteRow() from jdbc application against a select query (as updatable cursor) involving a list of over 128 OR conditions it is possible that the delete will fail with error 592. This may also occur when issuing the sql language comnmand 'delete where current of' against an updatable cursor. Workaround Description  Force the join order of the query by specifying an abstract plan which will put the OR scan on the left side of the join. '(join (values) (scan <table>))'

CR:735812

CR Number:   735812 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) 15.7 SP50 08 Apr 2013 Fixed 09 Apr 2013 Fixed 06 Jun 2013 One-off Provided Description The unreserved space reported by either the stored procedure sp_helpdb or the builtin curunreservedpgs() could be wrong after executing any of the stored procedures sp_addsegment, sp_extendsegment or sp_dropsegment.

CR:735863

CR Number:   735863 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) 06 May 2014 Fixed Description When running optimization goal allrows_dss it is possible that an incorrect aggregate result may be returned in rare circumstances involving a derived table or view containing a union all with the aggregate operating on a constant in the select list on at least one side of the union all. Workaround Description  set advanced_aggregation off --in user defined optgoal based on allrows_dss --or dbcc traceon (15341) --server-wide and can be used at startup if required.

CR:735868

CR Number:   735868 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2013 Fixed Description In rare case, SELECT on a DOL table with index may cause ASE to shut down with a timeslice error and followed by a stack trace that includes the modules bt__handle_LAdone(), bt__qualpage(), bt__scan_massoffset() and bufoffset().

CR:735879

CR Number:   735879 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2013 Fixed 03 Apr 2013 Presently Not Targeted For Any Future Release Of This Product Description The backupserver sample resource file is missing ASE login and password attributes for sybatch.exe

CR:735884

CR Number:   735884 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2013 Fixed 29 Apr 2013 Fixed 29 May 2013 One-off Provided 08 Jul 2013 Port Not Needed 24 Jan 2014 Port Not Needed Description ASE may suffer from a memory leak when several client connections are simultaneously made using encrypted passwords.

CR:735895

CR Number:   735895 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) 09 Apr 2013 Consult Complete 08 Apr 2013 One-off Provided 17 Dec 2013 Port Not Needed 17 Dec 2013 Port Not Needed Description Instrumentation: ASE at times can hit timeslice error coming from ksctsuspend(). This could occur when configuration parameter "cis idle connection timeout" is set to a non default value and server has active CIS connections. Instrumentation is added under traceflag 7899 which prints diagnostic messages to the errolog when the issue occurs. Instrumentation is also added to avoid more than one CIS task from accessing a connection in parallel.

CR:736016

CR Number:   736016 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature requests on making session level settable options to limit lio/cpu/locks/elapsed_time/tempdb_sapce similar to resource govern. Workaround Description  For queries with the potential to use many locks, the LOCK TABLE command can be used prior to the query to ensure a table lock is used rather than large numbers of page/row locks.

CR:736017

CR Number:   736017 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 01 Apr 2013 Fixed 31 Mar 2013 Fixed Description A 7949 error, "The number of pages used and unused for object <objid> index 255 partition <ptnid> on allocation page <alloc_page_no> do not match the counts in the OAM entry." followed by error 7940, "The counts in the OAM are incorrect. This implies that there are entries missing. Run tablealloc utility with the FIX option on the table with the inaccurate OAM counts." may be reported by DBCC TEXTALLOC and FULL option after inserting data with BCP into a table that has LOB columns and the option 'lob_compression' is enabled in the target database. Workaround Description  The 7949 errors can be corrected by running dbcc textalloc with fix option.

CR:736019

CR Number:   736019 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 Apr 2013 Fixed 15.7 SP50 12 Jun 2013 Fixed Description When using hash based statistics collection and over 65535 unique values exist in the column then it is possible that the summary statistics (such as density) may be slightly inaccurate. If one looks at the optdiag output for the column and determines that a range cell is used for the first cell even though only one domain value can fit into the cell, then it is possible for summary statistics inaccuracies. It is possible, but unlikely, that query plans could be adversely affected. Workaround Description  avoid hash based statistics gathering for columns that may have this problem.

CR:736021

CR Number:   736021 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: kill command with time to complete warning client message b4 dead

CR:736079

CR Number:   736079 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2013 Fixed 02 Aug 2013 Reservation Made Description A cheaper plan containing the merge_union_all operator may be skipped in favor of a more expensive plan using a sort operator on top of an append_union_all. Workaround Description  disable avoid_bmo_sorts optcriteria

CR:736093

CR Number:   736093 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2013 Fixed Description In rare cases in a cluster environment with more than one node, ONLINE DATABASE may hang if the log segment free space falls below a threshold.

CR:736132

CR Number:   736132 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 FR: sp_showcontrolinfo warning message or allow to be run in any db

CR:736158

CR Number:   736158 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) 14 May 2013 Duplicate Description Builtin function object_id('"OBJECT_NAME"') may return null for quoted identifier if new parameter 'quoted identifier enhancements' = 1. To workaround, disable this new parameter via: sp_configure 'quoted identifier enhancements', 0 Workaround Description  Disable the related new parameter via sp_configure 'quoted identifier enhancements', 0

CR:736179

CR Number:   736179 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP100 PL00 02 Apr 2013 Fixed 15.7 SP50 10 Apr 2013 Fixed 05 Jun 2013 One-off Provided 03 Jun 2013 One-off Provided 18 Jun 2013 Presently Not Targeted For Any Future Release Of This Product 16.0 16 Aug 2013 Fixed 16.0 16 Aug 2013 Fixed Description A 3261 error, "You cannot load this dump because it contains functionality that is available only on the server on which it was dumped" will be reported by LOAD DATABASE when trying to load a database dump which was taken while the database option "deallocate first text page" was active, or at least one table in this database had the attribute "dealloc_first_txtpg" set to 2. Workaround Description  Turn off db option "deallocate first text page" by sp_dboption dbname, "deallocate first text page", off

CR:736268

CR Number:   736268 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2013 Fixed 29 May 2013 One-off Provided 15.7 SP50 11 Apr 2013 Fixed 15 Apr 2013 Reservation Made 07 May 2013 Fixed 29 May 2013 One-off Provided 15.7 SP110 04 Jun 2013 Fixed Description A login account that has a login-specific password expiration setting may have the global password expiration setting applied to it if the server encounters a 1204 (out of locks) error during the login attempt.

CR:736288

CR Number:   736288 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When dropping a HADR standby server, remove HADR environment from the dropped server without manual intervention if the server is reachable.

CR:736309

CR Number:   736309 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 PL1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2013 One-off Provided 19 Jul 2013 One-off Provided 20 Aug 2013 One-off Provided 12 Sep 2013 One-off Provided 16 Dec 2013 Port Not Needed 16 Dec 2013 Port Not Needed Description INSTRUMENTATION: In rare circumstances, Adaptive Server may crash as a result of SIGSEGV error in kbfalloc() while holding DATACHG_SPIN spinlock. Workaround Description  This issue was finally identified through the instrumentation to be a bug in QP code and resolved under 738117

CR:736349

CR Number:   736349 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 07 Jun 2012 Presently Not Targeted For Any Future Release Of This Product Description Place the CR 702346 changes under a trace flag, disabled by default. CR 702346 changes are unlikely to be needed in ASE 15.7 due to different code paths.

CR:736426

CR Number:   736426 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.5 ESD #5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2013 One-off Provided 18 Sep 2013 One-off Provided 15.7 SP60 09 Aug 2013 Fixed 15.7 SP121 09 Sep 2013 Fixed 09 Sep 2013 Fixed 15 Oct 2013 Fixed 17 Jun 2014 One-off Provided Description The Java Compile Suite layer in Adaptive Server that is responsible for UDF/ADT support and SQLJ queries execution towards the target JavaVM has been enhanced to allow the release of intermediate allocated Java objects. This was causing the JavaVM heap memory allocation to be exhausted under a heavy load application environment.

CR:736428

CR Number:   736428 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2013 Fixed 15.7 SP110 29 May 2013 Fixed Description The message, "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = 1, Current count = 0" is wrongly reported in chain mode.

CR:736435

CR Number:   736435 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 23 Apr 2013 Fixed 15.7 SP110 02 Jun 2013 Fixed Description In rare circumstances, dropping a connection upon the CIS idle timeout may result in concurrent execution of Ct-library calls which may result in undesirable behavior.

CR:736441

CR Number:   736441 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 Feature request for an online (non-blocking) ALTER TABLE LOCK

CR:736499

CR Number:   736499 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Win32s Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 22 May 2013 Fixed 02 May 2013 Added to user documentation Description Linux client failed to redirect connections to Windows Server.

CR:736524

CR Number:   736524 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 PL1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Under very specific circumstances involving a join between the result of a concatenation of a derived table (or view) column and a string value. Also involving a correlated sub- query within the derived table definition it is possible for the optimizer to generate a plan which may lead to an unexpected error 249 (or similar) dependant on data. Workaround Description  The options are to either convert to a char value on the right side of the join to ensure the datatypes are comparable, or to protect against a null return from the min() aggregate operation to guard against this kind of optimization. For the repro, something like:- select dt.* from (select aa.a1 as aaa1, ab.a1 as aba1 from a aa inner join a ab on ab.a1= isnull ((select min(ac.a1) from a ac where ac.a1 > aa.a1),'19000101') ) dt where convert (char(6), dt.aba1,112) +'01' = dt.aaa1 go --or select dt.* from (select aa.a1 as aaa1, ab.a1 as aba1 from a aa inner join a ab on ab.a1=(select min(ac.a1) from a ac where ac.a1 > aa.a1) ) dt where convert (char(6), dt.aba1,112) +'01' = convert (char,dt.aaa1) go

CR:736535

CR Number:   736535 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2013 Duplicate Description On ASE 12.5.x, When DISK INIT is used to create a 32GB device on a raw partition using vdevno 255, it fails with error 5115 and corrupts the master device (zeros out pages in the config block and master database). The issue is not seen when vdevno 255 is a file system device, or if the size is less than 31 GB.

CR:736536

CR Number:   736536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 13 May 2013 Fixed 13 May 2013 Presently Not Targeted For Any Future Release Of This Product Description sp_dbextend does not observe default device growby limits. Workaround Description  If we do not want the repro_data_1 device to autoexpand, have a policy for the device explicitly using: sp_dbextend 'set', 'device', 'repro_data_1', '0' go

CR:736538

CR Number:   736538 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 May 2013 Fixed 15.7 SP50 03 Jun 2013 Fixed 15.7 SP110 05 Jun 2013 Fixed Description sp_sysmon gives wrong average values for 'Engine Busy Utilization' in process kernel mode.

CR:736550

CR Number:   736550 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 17 May 2013 Fixed 15.7 SP110 22 May 2013 Fixed 15.7 SP101 20 May 2013 Fixed 20 May 2013 Fixed 21 May 2013 Fixed 22 May 2013 Fixed 06 Jun 2013 One-off Provided Description Under rare circumstances a 696 error: "An attempt was made to read logical page '<page#>' for database '<dbname>' (<dbid>), object '<tablename>' ... from disk. Wrong logical page '<page#>' was brought into cache 'default data cache'." may be reported in the error log for allocation pages after the execution of CREATE, ALTER or LOAD DATABASE commands in an ASE installation using a page size that is greater than 2K-bytes and when during their execution the message "No large buffers were available, so pages are being cleared by writing each page separately. Please be patient" is reported. Alternatively a 2529 error, "Table Corrupt: Attempted to get page <page#>, partition ID 99; got page <page#>, partition ID 99." may be reported by DBCC CHECKALLOC. Workaround Description  Increase 'number of large i/o buffers'

CR:736603

CR Number:   736603 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 PL3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 14 Aug 2013 Fixed 15.7 SP110 15 Aug 2013 Fixed 15.7 SP60 29 Aug 2013 Fixed 15.7 SP121 15 Aug 2013 Fixed Description In some rare cases, accessing a system table could result in 8201 error being raised.

CR:736622

CR Number:   736622 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) 16 Jan 2014 Fixed 20 Jan 2014 Port Not Needed 16 Jan 2014 Fixed 16 Jan 2014 Fixed 15.7 SP61 16 Jan 2014 Fixed 15.7 SP121 17 Jan 2014 Fixed Description When running REORG REBUILD against a table whose name or any column name might form part of a reserved double or triple keyword phrase it is possible for an error 156 error to be reported along with error 11934 and for the REORG REBUILD command to abort. Workaround Description  Use sp_rename to rename the problematic identifiers then sp_rename to change it back after reorg.

CR:736626

CR Number:   736626 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 09 Apr 2013 Fixed 09 Apr 2013 Fixed 23 Apr 2013 One-off Provided 06 Jun 2013 One-off Provided Description When ASE is configured with the 'process' kernel mode and with several engines, the RepAgent Thread may be infected with signal 11 in the module 'uctSetIssuedCnt' while shutting down with a stack trace reported in the error log which includes the modules 'usctclose' and 'ra_drop_csconn'.

CR:736645

CR Number:   736645 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2013 Fixed Description After downgrading from ASE 15.7 to ASE 15.5GA, when booting the ASE 15.5GA server, a segmentation fault may be encountered during startup while attempting to reconcile the downgraded configuration options.

CR:736699

CR Number:   736699 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 Apr 2013 Fixed 11 Apr 2013 Reservation Made Description If there are significant concurrent activities which pin buffer cache pages in the named tempdb cache (or default data cache) then it is possible that the server could appear to hang due to lack of buffer cache. The kind of activity that could lead to this state is "hash based statistics gathering", "sorts", "query plans using hash operators". Workaround Description  lower "max resource granularity" use sort based statistics gathering have few concurrent sessions updating statistics or creating indexes with hashing increase the size of the tempdb cache (or default data cache)

CR:736754

CR Number:   736754 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 11 Apr 2013 Fixed 11 Apr 2013 Fixed Description The error 2550, "Missing segment in sysusages segmap", will be unnecessarily reported by DBCC CHECKCATALOG if a database has a fragment with a segmap equal to 0.

CR:736819

CR Number:   736819 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2013 Bundled Request 30 Aug 2013 Added to user documentation Description A new option is added to 'Text' display mode to wrap long lines on Results panel.

CR:736888

CR Number:   736888 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2013 Fixed 03 Jun 2013 Reservation Made Description In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log" may happen while loading a transaction log dump containing a rollback of a CREATE INDEX operation in database that has ddl_in_tran option on.

CR:736902

CR Number:   736902 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 17 May 2013 Fixed 15.7 SP110 21 May 2013 Fixed Description Optdiag tool was running as a ctlib application of a lower version, so it misinterpreted (and wrongly displayed) BIGDATETIME and BIGTIME values reported for statistics. Workaround Description  If optdiag is being used to port statistics and the same underlying architecture is being used, then using optdiag in binary mode would preserve precision lost when converting to text.

CR:736951

CR Number:   736951 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 25 Jun 2013 Fixed 01 Aug 2013 Consult Complete Description Improved the RAT Multiple Scanners code concurrency by removing the usage of un-needed locking primitives.

CR:736957

CR Number:   736957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 24 May 2013 Fixed 15.7 SP110 28 May 2013 Fixed 15.7 SP101 24 May 2013 Fixed Description In certain circumstances, databases, including system databases, can incorrectly get into LOG SUSPEND mode, issuing message: "Space available in the log segment has fallen critically low in database '<dbname>'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available." This may happen even though there is much unreserved space in the database. The problem may also manifest in 3475 errors: "There is no space available in SYSLOGS to log a record for which space has been reserved in database <dbname>." Workaround Description  alter database model on dbdevice=1 if LOG SUSPEND on model database with much unreserved space.

CR:736977

CR Number:   736977 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2013 Bundled Request Description In rare circumstances, an undetected deadlock may occur following a 1204 error: "ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS.", where the process that ran into the 1204 error holds the append log semaphore. Workaround Description  Increase the number of locks configured to reduce the likelyhood of running into 1204 errors.

CR:736978

CR Number:   736978 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 Apr 2014 Fixed 16 Apr 2014 Reservation Made Description On High Availability (HA) System, accessing a proxy table may raise a 102 error (Incorrect syntax near '.') after failover occurs and the connection is migrated to the secondary companion ASE. Workaround Description  1. Use create existing table command without enclosing double quotes. 2. Run sp_remotesql servername, "set quoted_identifier on" after failover. 3. Create a login trigger which runs "set quoted_identifier on" in it.

CR:737039

CR Number:   737039 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 12 May 2013 Fixed 15.7 SP50 14 May 2013 Fixed Description A 941 error, "Illegal database context operation." may be repeatedly reported in the error log by the housekeeper wash task. An ASE reboot is the only option to stop this message from being reported. Workaround Description  Reboot and disable hk_wash using sp_configure "housekeeper free write percent", 0 to avoid infinite loop.

CR:737093

CR Number:   737093 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2013 Not reproducible with latest version of the product available as of Resolution Date 20 Jan 2014 Fixed Description When a table is partitioned based on a list of values including the NULL value, the NULL value may be ignored when compared to NULL, leading to wrong results.

CR:737108

CR Number:   737108 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2013 Fixed 15.7 SP60 31 Jul 2013 Fixed 30 Jul 2013 Fixed Description Assertion fail in le_subst.cpp maybe raised when index only contains fixed-length columns.

CR:737139

CR Number:   737139 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 Internal error 724 or abstract plan errors may be raised when table names are also abstract plan operator names.

CR:737164

CR Number:   737164 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) 10 Jun 2013 Not reproducible with latest version of the product available as of Resolution Date Description Request for instrumentation to determine what is causing a database's keep count to become higher than it should be (left larger than zero after all processes have stopped using the database).

CR:737289

CR Number:   737289 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 sp_modifystats incorrect where clause in MODIFY_DENSITY

CR:737292

CR Number:   737292 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 SP50 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2013 Fixed Description In some circumstances, monOpenObjectActivity may report ObjectCacheDate for the cached object as 'Jan 1 1900 12:00AM' or other wrong date value.

CR:737316

CR Number:   737316 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2013 Insufficient info provided Description As of ASE 15.0 ESD2 no longer needs a separate license for DTM license, it is part of ASE_CORE license

CR:737327

CR Number:   737327 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) 03 Nov 2013 Fixed Description Querying a DATE column from remote DB2 table may result in cs_convert overflow error. Workaround Description  Use bigdatetime for the column datatype in the "create existing table" statement.

CR:737335

CR Number:   737335 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When system get out of locks 1204 error this results in 3914 error from checkpoint processes and after this to resource clean up problem.

CR:737338

CR Number:   737338 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 17 Apr 2013 Fixed 23 Apr 2013 Fixed Description When the stored procedure sp_renamedb is executed from a read-only database, a wrong error message, "You cannot run stored procedure 'sp_renamedb' from a low durability database" is reported. The message should be "You cannot run stored procedure 'sp_renamedb' from a read-only database".

CR:737365

CR Number:   737365 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) 15.7 SP50 20 Jun 2013 Fixed 15.7 SP110 25 Jun 2013 Fixed 01 Jul 2013 Fixed Description DUMP DATABASE to TSM API on Windows platforms can fail with the error message, "D00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=109, system message=Cannot get operating system error tex." Occasionally, the message, "system message =The pipe has been ended. Refer to your operating system documentation for further details." can also be reported. This issues only affects ASE on the Windows platforms.

CR:737481

CR Number:   737481 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 Apr 2013 Fixed 15.7 SP50 24 Apr 2013 Fixed Description In rare cases, when updating CHAR, VARCHAR or IN-ROW-LOB columns on a PAGE compressed table and there are many non-printable characters in the existing column value, the update may fail.

CR:737524

CR Number:   737524 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 06 Aug 2013 Fixed 15.7 SP60 09 Aug 2013 Fixed Description In rare circumstances, an 8201 error, "Keep count of descriptor (objid=<obj_id>, dbid=<db_id>) was expected to be 1. Instead 2 was found" followed by a stack trace that includes the modules des__clean() and des__scavenge() when a system is running out of descriptors.

CR:737543

CR Number:   737543 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2013 One-off Provided 07 Jun 2013 Fixed 15.7 SP50 13 Jun 2013 Fixed 15.7 SP110 10 Jun 2013 Fixed 20 Nov 2013 One-off Provided 11 Nov 2013 One-off Provided 05 Jan 2015 One-off Provided 05 Jan 2015 One-off Provided 15 Jan 2015 Fixed 18 Jan 2015 Fixed Description Added a diagnostic check to help identify LRU chain issues. Trace flag 897 has been added to enable the instrumentation. Workaround Description  Have suggested the customer to 1.reduce 'housekeeper free write percent' from 25(%) to default 1(%) 2. create a new named cache tempdb_cache for tempdb to reduce default data cache contention

CR:737552

CR Number:   737552 Product Name:   Adaptive Server Enterprise Product Component:   Component Drop Status:   Closed OS:   Microsoft Windows Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2013 Added to user documentation Description This PC Client release for ASE157esd4.2 fulfills an SAP internal requirement. Content-wise, this PC Client is exactly the same as version released with ASE157esd4.

CR:737577

CR Number:   737577 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2013 Fixed 15.7 SP50 22 Apr 2013 Fixed Description The 3702 error,"Cannot drop the procedure 'sp_aux_getsize' because it is currently in use." will be raised if a user tries to drop the stored procedure sp_aux_getsize before the server has finished the recovery of every database.

CR:737628

CR Number:   737628 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 SP110 19 Jul 2013 Fixed 19 Jul 2013 Reservation Made 15.7 SP60 22 Jul 2013 Fixed Description Intelligient index scan may lead to non-optimal index in plan selection. Workaround Description  trace 15353

CR:737629

CR Number:   737629 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) 30 Jun 2013 Not reproducible with latest version of the product available as of Resolution Date Description A query using the xmlextract() function terminates with an infected with 11 or timeslice error with the function bi__xml_query() on the stack.

CR:737697

CR Number:   737697 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 23 Apr 2013 Fixed 24 Apr 2013 Fixed 20 Jun 2013 Fixed Description When running UPDATE INDEX STATISTICS with SAMPLING command, numerous errors may be reported in the errorlog - 1105 errors: "Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment" and 1764 errors: "Failed to insert row into worktable, when projecting base table on to work table for collecting statistics".

CR:737702

CR Number:   737702 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 30 Apr 2013 Fixed 15.7 SP110 03 May 2013 Fixed 10 May 2013 One-off Provided Description Certain stored procedures created with "execute as caller" and using user defined datatypes may produce 2716 errors at execution time. Workaround Description  Don't use user defined datatypes.

CR:737712

CR Number:   737712 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 feature request for ASE to handle stack overflow issues for some queries with large IN or UNION clauses without crashing the server.

CR:737720

CR Number:   737720 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 3914 error with cluster edition 157esd4 and dynamic sql. conflicts in internal sql.

CR:737721

CR Number:   737721 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 Feature request to avoid flushing the BEGINXACT for a SELECT INTO command until the select starts producing rows to be inserted.

CR:737722

CR Number:   737722 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a supported method for dumping databases and transaction logs to Amazon cloud storage [Simple Storage Service (S3) API]

CR:737733

CR Number:   737733 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2013 Fixed 15.7 SP50 23 Apr 2013 Fixed Description The 12320 message, "Fatal internal error encountered when forwarding row <rowid> in table <tablename>, database <dbname> during update. Aborting the transaction" may be reported when updating a DOL row on a table defined as Page Compressed.

CR:737762

CR Number:   737762 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.5 ESD #5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2013 Fixed 15.7 SP50 24 Apr 2013 Fixed 24 Apr 2013 Fixed 06 May 2013 Fixed 22 May 2013 Fixed 12 Jul 2013 One-off Provided 12 Jul 2013 One-off Provided Description Under rare circumstances backup server may produce unpredictable text attached to the dump trailer.

CR:737820

CR Number:   737820 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 Feature request for an ALTER TABLE LOCK implementation that would minimize blocking by changing the lock scheme for rows only as they were modified. i.e. ASE would maintain up to three subtables (one for each lockscheme) and present a consistent view of them as one table.

CR:737824

CR Number:   737824 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) 22 Apr 2013 Fixed 15.7 SP50 22 Apr 2013 Fixed 23 Apr 2013 Fixed Description The 18124 message, "No matching configuration options" may be reported when executing sp_configure "solaris async i/o mode"

CR:737837

CR Number:   737837 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 May 2013 Fixed 15.7 SP101 06 May 2013 Fixed Description Shrinkpage() will raise a 631 error if the parent nonleaf page has only one nonleaf row that points to the shrinking page.

CR:737879

CR Number:   737879 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 17 Oct 2013 Fixed 15.7 SP60 11 Jul 2013 Fixed 19 Jul 2013 One-off Provided 07 Aug 2013 Reservation Made 21 Nov 2013 Fixed Description When backup server is started with trace flag D2048, the pages that have been allocated after the backup server built a list of pages to be archived and before the related allocation page is read by sybmultbuf, will be resent. Prior to dump a database one can run SYB_BACKUPqatraceon 105 that will add appropriate messages in the backup server error log when a resent has occurred.

CR:737907

CR Number:   737907 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2013 Fixed Description If the server crashes in the middle of SHRINKDB, the segmap number on sysusages table may not be updated to 0.

CR:737933

CR Number:   737933 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2013 Fixed 30 Aug 2013 Added to user documentation Description Add option to Connect Dialog to connect to the last-used database (instead of the default database).

CR:738007

CR Number:   738007 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 07 Jun 2013 Fixed 04 Jun 2013 Consult Complete 15.7 SP102 17 Jun 2013 Fixed Description In rare circumstances, the RepAgent thread may fail to terminate and hang in the module 'upsleepgeneric'. The execution for DBCC STACKTRACE(<RepAgent_spid>) would indicate the RepAgent sleeping in the modules 'usctcancel' and 'ksctsuspend'. Workaround Description  N/A unless you consider restarting ASE being a workaround (ugly).

CR:738033

CR Number:   738033 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 08 May 2013 Fixed 15.7 SP110 17 May 2013 Fixed 17 Oct 2013 Fixed Description When auditing option to remove java classes is turned 'on', sp_audit stored procedure returns with a message that the option is 'off'. Workaround Description  With below "remove" audit option turn on , cause the audit report wrong # define AUDB_S_JCSREMOVE 0x40000000 /* jcs "remove" cmd success */ # define AUDB_F_JCSREMOVE 0x80000000 /* jcs "remove" cmd failure */ So the workaround is to turn it "off" if customer has turn it "on" sp_audit "remove","all", db1, "off"

CR:738117

CR Number:   738117 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) 19 Jul 2013 Presently Not Targeted For Any Future Release Of This Product 23 Jan 2014 Port Not Needed 22 Aug 2013 One-off Provided 05 Sep 2013 One-off Provided 15.7 SP110 05 Sep 2013 Fixed 15.7 SP51 09 Sep 2013 Fixed 15.7 SP103 12 Sep 2013 Fixed 15.7 SP60 13 Sep 2013 Fixed 15.7 SP121 25 Nov 2013 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module ssql_release() or ssql_choose_victims() may be reported in the SAP ASE error log when the statement cache is full in a high concurrency SAP ASE environment.

CR:738127

CR Number:   738127 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Although the DOUBLE PRECISION datatype supports values up to ~1.79E308, the ASE parser raises errors 103 "The number that starts with ... is too long. Maximum length is 255." for values larger than 1.0E255 when submitted as a decimal string. Such large values can be inserted using E-notation.

CR:738162

CR Number:   738162 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to make AUDIT PROCESS EXCEPTION as more "Critical" or a "FATAL" message

CR:738189

CR Number:   738189 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 26 Apr 2013 Fixed 15.7 SP50 26 Apr 2013 Fixed 29 Apr 2013 Fixed Description Load dump with list_only=create_sql sometimes fails. A Unrecoverable I/O or volume error may be reported.

CR:738196

CR Number:   738196 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 19 Jul 2013 Fixed 15.7 SP60 28 Jul 2013 Fixed 29 Jul 2013 Reservation Made Description A core dump facility is added to the sybmon configurable shared memory dump feature. This is supported only on Windows platforms.

CR:738218

CR Number:   738218 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2013 Fixed 15.7 SP101 21 May 2013 Fixed 15.7 SP110 22 May 2013 Fixed 09 Sep 2013 Fixed 02 May 2014 Fixed Description A 1209 error, "Internal Error in lock manager routine: Attempted lock upgrade from shared intent to shared table in parallel query thread is illegal", may be reported in the error log during a SELECT or SELECT-INTO query on a table with parallel plan if there are concurrent DMLs or utilities operating on the table. Workaround Description  Increase the lock promotion threshold for pages and rows to a larger number. sp_configure 'page lock promotion HWM', 10000 sp_configure 'page lock promotion LWM', 10000 sp_configure 'row lock promotion HWM', 20000 sp_configure 'row lock promotion LWM', 20000

CR:738286

CR Number:   738286 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) Description request to make the SySAM message "ASE will shutdown ..." a critical or fatal message, not just a warning message

CR:738309

CR Number:   738309 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 SP101 29 Apr 2013 Fixed 29 Apr 2013 Fixed Description In rare circumstances, the task will hang when LIKE clause or patindex(builtin) operator on the columns which contain the LOB data defined as compressed.

CR:738319

CR Number:   738319 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 10 May 2013 Fixed 15.7 SP101 10 May 2013 Fixed Description After multiple HADR failovers, new client connections to a server in the HADR group may fail with error message "Read from the server has timed out" or "There is a tds login error".

CR:738322

CR Number:   738322 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2013 Fixed 15.7 SP110 28 May 2013 Fixed 15.7 SP50 29 May 2013 Fixed 11 Jun 2013 Fixed 29 May 2013 Fixed 26 Jul 2013 Fixed 21 Aug 2013 Consult Complete 21 Aug 2013 Fixed 05 Nov 2013 Fixed 29 Oct 2013 Fixed 11 Jun 2014 Fixed Description Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature (NB, CR 749101 also needed if the network interface has more than one IP address). Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE. The location and name can be changed using the Backup Server parameter -h.

CR:738367

CR Number:   738367 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 07 May 2013 Fixed 15.7 SP110 08 May 2013 Fixed 10 May 2013 One-off Provided Description Stored procedures using "execute as caller" with builtin functions may attempt to access objects that do not belong to the caller (but do belong to the procedure owner). Workaround Description  None known.

CR:738370

CR Number:   738370 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) 07 Jun 2013 One-off Provided 15.7 SP50 17 Jun 2013 Already Fixed by Another CR 27 Jun 2013 Presently Not Targeted For Any Future Release Of This Product 08 Oct 2014 Port Not Needed Description HK skips flushing log masses causing non-positive wash deficit leading to 839 error

CR:738403

CR Number:   738403 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 06 Aug 2013 Fixed 15.7 SP121 18 Dec 2013 Fixed 17 Jan 2014 Fixed 15.7 SP111 21 Mar 2014 Fixed Description The show_cached_plan_in_xml() function reports incorrect timings on the AIX platform.

CR:738537

CR Number:   738537 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) 15.7 SP50 05 Jun 2013 Fixed 15.7 SP110 10 Jun 2013 Fixed Description When LOAD DATABASE <dbname> WITH LISTONLY=LOAD_SQL is executed, incorrect output may be generated if the database was dumped using a dump configuration with an external API. As an example "LOAD DATABASE test FROM 'C:\Windows\system32\syb_tsm::test.DB.20130429.171214.000'" may be reported instead of "LOAD DATABASE test FROM 'syb_tsm::test.DB.20130429.171214.000'".

CR:738538

CR Number:   738538 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 03 May 2013 Fixed 03 May 2013 Fixed 15.7 SP101 16 May 2013 Fixed Description "shutdown with nowait" may fail to shutdown the server followed by SIGSEGV stacktrace with modules ktMuxThreadGetSchedQ(), ktMuxThreadTick(), utpApplyAll(), utpmApplyAll(), kaclkintr_thread() on the stack.

CR:738551

CR Number:   738551 Product Name:   SySAM Product Component:   FLEXlm Status:   Open OS:   NA Original Version:   2.2.1.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request that allows licenses from sybase.subscribenet.com to be generated in one batch.

CR:738552

CR Number:   738552 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 20 May 2013 Fixed 15.7 SP101 20 May 2013 Fixed Description If a table has small compressible off-row LOB columns that are not compressed due to size or other factors, ASE RepAgent may send an incorrect text length to Replication Server causing the Replication Server to stop replicating. Workaround Description  This problem only happens when bulk lib writetext is used by Rep Server to insert LOBs that can be compressed into a database and that same LOB gets replicated through another Rep Server. The second Rep Server will get a length error. Turning off compression or the use of bulk lib in Rep Server will eliminate this problem.

CR:738558

CR Number:   738558 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) 28 May 2013 Insufficient priority to fix Description The sysmessages entry for error 701 indicates the severity level is 19 when it is actually 17.