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

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

CR:769868

CR Number:   769868 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2014 Fixed 01 Sep 2014 Fixed 17 Nov 2014 Fixed 08 Oct 2014 One-off Provided Description SAP ASE might report an infected with 11 (SIGSEGV) stacktrace in the function mda_flush_iostats() when the SAP ASE configuration option "enable monitoring" is set to 1. Workaround Description  Use TF 8392 to avoid problems in mda_flush_iostats.

CR:769966

CR Number:   769966 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2014 Fixed 23 Dec 2014 Fixed 07 Jan 2015 Fixed Description Index creation always running in serial mode when the first selected column contains large percentage of NULL values.

CR:769982

CR Number:   769982 Product Name:   Adaptive Server Enterprise Product Component:   Component Drop Status:   Open OS:   Microsoft Windows Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Not a Bug Description This PC-Client SP is based on SDK 15.7 SP130

CR:770016

CR Number:   770016 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2014 Fixed 23 Dec 2014 Fixed 07 Jan 2015 Fixed Description When execute some statements through JDBC such as table create statement, sometimes, it could hang.

CR:770041

CR Number:   770041 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2014 Fixed 09 Dec 2014 Fixed Description OpenSSL FIPS is not certified.

CR:770052

CR Number:   770052 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) 08 Sep 2014 Fixed 09 Sep 2014 Fixed Description using the sp_chgattribute tab_name, "plldegree", degree_no function will set the parallel degree but subsequently when either update statistics is run, or if housekeeper flushes the table level stats, then the systabstats.plldegree for the respective table will be reset to 0. This will disable consideration of parallelism for that table until the sp_chgattribute is once again executed.

CR:770072

CR Number:   770072 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Using the MERGE command on tables with function based indexes may result in a signal 11 with a stacktrace containing the function CgpSort::cgpInit or CgpMerge::_CgpCreateMergeInfo Workaround Description  Remove the function based index.

CR:770078

CR Number:   770078 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   UNIX Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2014 Bundled Request Description Rep Agent stops working while processing a Data Modification Language operation on a table containing not materialized defaults with datetime data type. The error reported is 249: Syntax error during implicit converstion of VARCHAR value 'xxxxx' to a DATE field. The stack trace reported will include the function des_get_column_dflt()

CR:770079

CR Number:   770079 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Open OS:   AIX Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE SAP JRE bootstraps for SAPJRE version 7.1.018 can result in a SEGV and messages like reporting "A fatal error has been detected by the SAP Java Virtual Machine". To overcome this problem the Corona Beta release on IBM AIX64 platform needs to disable its SAPJRE JIT support. Workaround Description  This problem is resolved from SAP JRE 7.1.025. To determine the SAP JRE version execute below command; ${SYBASE}/shared/SAPJRE-7_1_018_64BIT/bin/java -version java version "1.7.0_55" Java(TM) SE Runtime Environment (build 7.1.018) SAP Java Server VM (build 7.1.018 24.55-b03, Apr 24 2014 03:54:02 - 71_REL - optU - aix ppc64 - 6 - bas2:216925 (mixed mode)) Prior to SAP JRE 7.1.025 (SAP JRE 7.1.018 - SAP JRE 7.1.024) the workaround to apply is to disable JIT support; % isql -Usa -PSYBASE -w333 -Dsybpcidb 1> sp_jreconfig 'update', 'pca_jvm_java_options', '-Djava.compiler=JIT', '-Djava.compiler=NONE' 2> go 1> sp_jreconfig 'reload' 2> go

CR:770092

CR Number:   770092 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 SP01 PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2014 Fixed 27 Sep 2014 Fixed 21 Oct 2014 Fixed 21 Oct 2014 Fixed 21 Oct 2014 Fixed 12 Dec 2014 Fixed Description A 3606 error "Arithmetic overflow occurred." may be reported during the execution of sp_helpdb on a database after loading a transaction dump into a database that has a trailing log hole. Workaround Description  (1) Workaround dbcc tablealloc (syslogs,full,fix) (2) as mentioned above, if I remove "{dump|load} {database|transaction}" from the reproduction scenario, sp_helpdb does not raise the Arithmetic overflow

CR:770214

CR Number:   770214 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2014 Fixed 10 Sep 2014 Fixed Description While online utilities are running and new identity values are generated, a system crash and recovery could result in regeneration of identity values.

CR:770254

CR Number:   770254 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2014 Fixed 28 Oct 2014 Fixed 09 Dec 2014 Fixed Description For an HADR enabled SAP ASE on the IBM AIX platform, if "sp_hadr_admin activate" command is executed, extraneous characters such as ": !" are displayed.

CR:770255

CR Number:   770255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP122 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2014 Fixed 09 Sep 2014 Fixed 23 Sep 2014 Fixed 10 Sep 2014 Fixed Description In rare circumstances, a 605 error "An attempt was made to fetch logical page '<pageno>' from cache 'log cache'. Page belongs to database '<dbname>', object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (-1) and not to database '<dbname>' (<dbid>), object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8)" together with a stack trace which includes the modules 'getpage_with_validation', 'num_logpages' and 'loginfo3_xactspanbyspid' may be reported in the error log when the loginfo() built-in is executed with the 'xactspanbyspid' option.

CR:770260

CR Number:   770260 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP122 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2014 Fixed 12 Sep 2014 Fixed 20 Oct 2014 Fixed Description In rare circumstances, the message "current process infected with 11" in the module 'LeAlfaStatsCollector::LeWriteThStatsToCollector' may be reported in the error log when a query is executed inside a stored procedure (or the statement was cached) and the plan is executed in parallel while some monitoring options are altered. Workaround Description  disable parallelism or disable stats collection in HTML - latter is not feasible in a Business Suite on ASE env

CR:770297

CR Number:   770297 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_monitorconfig "number of user connections" may return an inaccurate figure for Max_Used

CR:770377

CR Number:   770377 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to provide resource requirement estimates before trying to load an archive database.

CR:770403

CR Number:   770403 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2014 Fixed 18 Sep 2014 Fixed 10 Oct 2014 Fixed Description Dump database with verify=read_after_write and verify=crc but with no compression specified may produce an unexpected verification message such as "Backup Server: 4.190.1.1: Database repro_db: Verification reported x errors.". Workaround Description  Using verify=crc and/or verify=read_after_write is used on a non-compressed dump, the verification will not run dispite being reported in the log. If the intention is to use crc or read_after_write, use a compressed dump. Otherwise, the verifiction report in the dump can be ignored if the dump is not compressed.

CR:770415

CR Number:   770415 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2014 Port Not Needed 17 Oct 2014 Port Not Needed 09 Oct 2014 Fixed 14 Oct 2014 Fixed 14 Oct 2014 Fixed 23 Dec 2014 Fixed Description When using hash based statistics gathering on partitioned tables, there could be statistics missing on some local partitions and hence the final global histogram is inaccurate. The inaccurate histogram could result in sub-optimal query plans. This also would result in the DATACHANGE() counters for that column on that partition not being reset, resulting in frequent update statistics maintenance on the partitioned table when depending on the DATACHANGE() function. Workaround Description  The customer would need to manually check every cube, every partioned F- or E- fact table, check the datachange() value for all partitions and all key columns, and update statistics where needed. use update statistics ... with no_hashing on partitioned tables

CR:770418

CR Number:   770418 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2014 Fixed 12 Sep 2014 Fixed 12 Sep 2014 Reservation Made 12 Sep 2014 Fixed 12 Sep 2014 Fixed Description Added a new rule to use serial optimizer when all main query blocks don't have partitioned table and all non-partitioned tables set their "plldegree" attribute to <=1. The rule condition includes the plldegree setting for the table's useful indexes (if any). "plldegree" can be set for a table using the following command: sp_chgattribute t1, "plldegree", 4 The rule is only active when the cmdline traceflag 16993 is on. Also under the same traceflag, optimizer will not use a table's plldegree setting as its useful index's plldegree when the index doesn't have the attribute set.

CR:770422

CR Number:   770422 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2014 Fixed 12 Sep 2014 Port Not Needed 20 Jan 2015 Fixed 25 Sep 2014 One-off Provided Description The error "Page Verification Error: Page mismatch. Page <pageno> contains <swapped pageno> in page header." may be reported in the SAP backup server error log if the database contains untranslated pages that were originally loaded from a dump taken in an architecture with different endianness.

CR:770449

CR Number:   770449 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2014 Fixed Description Even if "number of open databases" is increased on ASE in a High Availability System, the additional number of open databases cannot be used. Workaround Description  Reboot your ASE.

CR:770468

CR Number:   770468 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 Sep 2014 Fixed 12 Sep 2014 Fixed 18 Sep 2014 Fixed Description A 12531 error "The table SYSDAMS could not be opened in database ..." will be unnecessarily reported when loading a database dump taken from a pre-15.7 version into an SAP ASE version equal or greater than 15.7, although this error will not cause the load of the database dump to fail.

CR:770473

CR Number:   770473 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Open OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Optimization criteria enabled with ase_current does not match a document version.

CR:770497

CR Number:   770497 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 2809 may be raised incorrectly, specifying the name of an object that isn't involved in the query at all, for some cross-database queries involving a view in another database that has the same object id as a procedure in the user's current database. As a workaround, drop and recreate either object to assign it a different object id.

CR:770513

CR Number:   770513 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7.1 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2014 Third Party Problem 28 Sep 2014 Fixed 29 Sep 2014 Fixed 06 Nov 2014 Port Not Needed 18 Nov 2014 Fixed Description The error message 'The text column descriptor returned from the execution of rs_get_textptr function string output commands is NULL. The text descriptor must be valid. The DSI thread for database is shutdown.' will be reported in Repserver error log file, if Repserver configure 'dsi_compile_enabl' is off, when try to update a NULL LOB column which could be replicated.

CR:770514

CR Number:   770514 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2014 Fixed 19 Sep 2014 Fixed 23 Dec 2014 Fixed 23 Dec 2014 Fixed Description A 691 error, "Encountered invalid logical page '0' while accessing database '<dbname>' (<dbid>), object 'sysgams' (14), index 'sysgams' (0), partition 'sysgams_14' (14). This is an internal system error..." together with a stack trace which includes the modules 'am_op' and 'pg_ptndeall' may be reported in the SAP ASE error log, during the execution of a DML command, when the database size has been extended such that it would have required the Global Allocation Map (GAM) to be extended. The GAM would need to be extended for every 64 G-bytes in a 2 K-bytes page size server, 128 G-bytes in a 4 K-bytes page size server, etc. Alternatively a 690 or 692 error may be reported. Workaround Description  dbcc gam(<dbid>,0, 0, fillsupergam)

CR:770563

CR Number:   770563 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2014 Fixed 29 Sep 2014 Fixed 08 Dec 2014 Fixed Description DDLGEN does not generate the correct webservice DDL.

CR:770579

CR Number:   770579 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Rep Agent support upport for database resynchronization functionality, using synchronous replication.

CR:770768

CR Number:   770768 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2014 Not reproducible with latest version of the product available as of Resolution Date Description In rare circumstances, the replication of a commit command may be discarded by SAP Replication Server mistakenly, if the SAP Rep Agent is configured to use streaming replication in either near sync or sync mode. This will prevent the Replication Servers in-bound queue from being truncated.

CR:770791

CR Number:   770791 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Open OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Suppress output to Message tab in DBISQL for non user issued queries under set statistics commands.

CR:770822

CR Number:   770822 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2014 Fixed 07 Oct 2014 Fixed Description An SAP ASE Cluster Edition server might crash with error "Unknown logical cluster type" during boot after upgrade Workaround Description  Drop all logical clusters created by pre-SP130 binary Boot the cluster using SP130 (or later) binary Re-create logical clusters if needed

CR:770848

CR Number:   770848 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 SP01 PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2014 Fixed 14 Oct 2014 Fixed 03 Oct 2014 Fixed 07 Nov 2014 Bundled Request Description DSParser failed to detect the interfaces format when the first entry's server name is not followed immediately by the query/master service definitions.

CR:770863

CR Number:   770863 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2014 Fixed 15 Oct 2014 Fixed Description If SAP ASE received an external attention during merge join and internal sorting, an infected with 11 (SIGSEGV) in routine sortclean() may be reported in the SAP ASE errorlog and SAP ASE may core dump.

CR:770867

CR Number:   770867 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP63 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2014 Consult Complete 04 Dec 2014 One-off Provided 25 Nov 2014 Fixed 25 Nov 2014 Port Not Needed 25 Nov 2014 Port Not Needed 25 Nov 2014 Port Not Needed 25 Nov 2014 Port Not Needed Description A 2601 error, "Attempt to insert duplicate key row in object '<table_name>' with unique index <index_name>" may be reported for an APL table that is marked for replication when SAP Rep Server attempts to insert a row on the standby database. Alternatively a 9275 error, "RepAgent(<database_id>): Could not locate the before image for the INSERT log record at (<page_number>, <row_number>)." may be reported in the SAP ASE error log. In both cases this will result in the replication stream to be stopped. Workaround Description  Use DOL tables if possible.

CR:770896

CR Number:   770896 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2014 Fixed 27 Nov 2014 Fixed 16 Nov 2014 Fixed Description On connection to Adaptive Server when the user password has expired, ALTER LOGIN MODIFY PASSWORD is prevented from changing the password. Workaround Description  Use sp_password to change expired passwords.

CR:770933

CR Number:   770933 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2015 Fixed 05 Nov 2014 Backed Out 18 Nov 2014 Reservation Made 14 Nov 2014 Fixed 20 Nov 2014 Backed Out 23 Dec 2014 Presently Not Targeted For Any Future Release Of This Product 26 Nov 2014 Back Out Description When running in threaded mode on the Linux, HP and Solaris platforms, or in process mode on any platform, SAP ASE may become CPU bound if a task on which network input is pending is suspended due to the shortage of some resource. The issue is avoided by temporarily disabling network input checking on a connection in the above conditions. This CR can be disabled via trace flag 7862.

CR:770943

CR Number:   770943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 SP01 PL01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE can't read 3 level chained SSL certificates.

CR:770992

CR Number:   770992 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2014 Fixed 29 Sep 2014 Fixed 03 Oct 2014 Fixed 03 Oct 2014 Fixed 24 Nov 2014 Fixed Description In rare circumstances, the error 692, " Uninitialized logical page '<pageno>' was read while accessing database ..." could be raised when creating a database with FOR LOAD option. Workaround Description  Truncate the transaction log of the model database or whatever database is used as a template if different from model.

CR:771006

CR Number:   771006 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2014 Fixed 06 Nov 2014 Fixed 12 Oct 2014 Fixed 13 Oct 2014 Fixed 08 Dec 2014 Fixed Description A query that us using multiple DMLs may hit an infected with 11 (SIGSEGV) error with stacktrace including the function bt__getrestartpg() in the SAP ASE errorlog.

CR:771039

CR Number:   771039 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows 2008 Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2014 Fixed 03 Oct 2014 Fixed 03 Oct 2014 Fixed 06 Oct 2014 Fixed Description In rare circumstances when the option 'enable incremental dump' is enabled in the database, the message 'closetable: table already closed for sdes ...' followed by a stack trace that includes the modules 'xact_end_session' and 'closetable' may be reported in the SAP ASE error log.

CR:771053

CR Number:   771053 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2014 Presently Not Targeted For Any Future Release Of This Product 18 Nov 2014 Fixed 17 Nov 2014 Fixed 18 Nov 2014 Fixed 18 Nov 2014 Fixed 30 Dec 2014 Fixed Description SAP ASE may encounter a signal 11 (SIGSEGV) in the function usgetipaddr() on the IBM AIX platform

CR:771055

CR Number:   771055 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP122 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2014 Fixed 23 Sep 2014 Reservation Made 29 Sep 2014 Fixed 28 Sep 2014 Fixed 05 Oct 2014 Fixed 16 Nov 2014 Bundled Request 06 Jan 2015 Fixed Description On the IBM AIX platform, while generating stack trace, SIGSEGV (Signal 11) or timeslice error is observed in search_tbt() or strncpy(). Workaround Description  There is no workaround for this problem. In the binary containing this fix, search_tbt() is disabled by default and when required traceflag 6304 can be used to get detailed stack trace if it is safe (like running on a dev/test box, not production box).

CR:771081

CR Number:   771081 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2014 Fixed Description update the testset

CR:771090

CR Number:   771090 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2014 Fixed 20 Oct 2014 Fixed 19 Oct 2014 Port Not Needed 20 Oct 2014 Fixed 26 Oct 2014 Fixed 18 Nov 2014 Fixed Description The message "Invalid DOL data row pointer: row <value> with status 0x80e must be normal row instead of compressed row." in the module 'collocate' together with a stack trace which includes the modules 'writetext' and 's_execute' may be reported in the SAP ASE error log when a WRITETEXT command is run on a page compressed table in order to update a LOB column with a null value.

CR:771124

CR Number:   771124 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   all Original Version:   16.0 SP01 PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description feature request to add the license server name to monLicense table Workaround Description  n/a

CR:771137

CR Number:   771137 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP132 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2014 Fixed 07 Nov 2014 Reservation Made 10 Nov 2014 Fixed Description Performance enhancement for "DUMP TRAN with TRUNCATE_ONLY" option when many concurrent sessions are active.

CR:771141

CR Number:   771141 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2014 Fixed 09 Nov 2014 Fixed 27 Oct 2014 Fixed 23 Dec 2014 Fixed Description A query with select into a temporary table with union having predicated privileges for tables in the from clause may produce a 225 error - "Cannot run query--referenced object (name <name>) dropped during query optimization.". Workaround Description  run query as "sa"

CR:771143

CR Number:   771143 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2014 Fixed 08 Oct 2014 Fixed 04 Nov 2014 Fixed 17 Nov 2014 Fixed 23 Dec 2014 Fixed Description Memory allocation errors similar to "ks_falloc: Cannot allocate using ubfalloc(rnetmempool, 4096). Encryption provider initialization failed on engine 19." may be noticed in the ASE error log file when engines are made offline and online in threaded mode kernel.

CR:771158

CR Number:   771158 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2014 Fixed 05 Nov 2014 Fixed 10 Nov 2014 Fixed 10 Nov 2014 Fixed Description In rare cases, the table may be corrupted if exception occurs when executing ALTER TABLE command to change compressed table's lock schema.

CR:771170

CR Number:   771170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2014 Fixed 06 Oct 2014 Fixed Description An SAP ASE Cluster Edition server or connection might hang when binding a Single Instance Database (SIDB) to a Single Instance Logical Cluter (SILC) after the SILC has been onlined Workaround Description  Perform SIDB to SILC binding before onlining the SILC. While issuing a bind, SILC should be in offline state. So the last steps given in repro section should be in reverse order: sp_cluster 'logical','add','SILC1','database','SIDB1' sp_cluster logical,'online','SILC1'

CR:771198

CR Number:   771198 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Oct 2014 Fixed 08 Oct 2014 Fixed 04 Oct 2014 Fixed Description The message "current process infected with 11 (SIGSEGV)" in the module 'dam_prepare_dump_end' together with a stack trace which includes the module 'dpdb_main' may be reported in the SAP ASE error log when a DUMP DATABASE is executed and while a concurrent DUMP TRANSACTION is aborted. This would require the configuration option 'enable concurrent dump' and the database option 'allow incremental dumps' being both enabled. Workaround Description  Disable either 'enable concurrent dump' or 'allow_incremental' or both if they are not needed.

CR:771228

CR Number:   771228 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2014 Presently Not Targeted For Any Future Release Of This Product 05 Nov 2014 Fixed 17 Nov 2014 Fixed 18 Nov 2014 Fixed 30 Dec 2014 Fixed 23 Dec 2014 Fixed Description ASE may report the message "Assertion (this->tMagic == 0x4B545255) failed in file ..." when using sp_sysmon

CR:771230

CR Number:   771230 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2014 Fixed 27 Sep 2014 Fixed 27 Oct 2014 Fixed 27 Oct 2014 Fixed 06 Oct 2014 Fixed 27 Oct 2014 Reservation Made Description A REORG DEFRAG process, if killed, then in rare cases could leave the state of object specifying that an utility is active.

CR:771240

CR Number:   771240 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2014 Fixed Description sybcluster: new option 'upgrade_ok' for command 'start cluster' and 'start instance' to support start server with new binary against old data devices.

CR:771258

CR Number:   771258 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2014 Fixed Description Server command "update t2 set c1 = 6 " encountered a deadlock situation

CR:771286

CR Number:   771286 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2014 Fixed 03 Oct 2014 Reservation Made 09 Oct 2014 Fixed 15 Oct 2014 Fixed Description The SAP ASE optimizer can make an unexpected selectivity estimate of 0.001 when a selectivity of 0.0 is detected and optcriteria avoid_zero_weight_histograms is enabled. The cr771286 optcriteria corrects the mis-estimate. Workaround Description  Set the optlevel to ase157sp110. turn off optcriteria avoid_zero_weight_histogram

CR:771301

CR Number:   771301 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   AIX Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2014 Fixed 26 Sep 2014 Fixed 16.0 GA PL05 26 Sep 2014 Fixed 01 Oct 2014 Insufficient priority to fix 05 Dec 2014 Fixed 04 Dec 2014 One-off Provided 26 Nov 2014 Port Not Needed 26 Nov 2014 Port Not Needed 28 Nov 2014 Port Not Needed 10 Dec 2014 Port Not Needed Description The error "Volume validation error: attempt to open '<file name>' returned Too many open files" can be raised by the SAP ASE backup server when trying to dump or load on the SOLARIS, HP and IBM AIX platforms after running for some time because a socket is being left opened every time a connection is established. Workaround Description  Either use a compatible prior version of the backup server without this bug, like SP122 or reboot backup server from time to time.

CR:771307

CR Number:   771307 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 SP63 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances Signal 11 might occur when executing LWP with query of "select top 1 * from wf_main_tbl" which is partition table.

CR:771344

CR Number:   771344 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2014 Fixed 22 Dec 2014 Fixed 06 Jan 2015 Fixed Description sybdiag does not report the configuration option "prevent automatic upgrade".

CR:771370

CR Number:   771370 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2014 Fixed 03 Oct 2014 Fixed 03 Oct 2014 Fixed Description If a query contains a COUNT_BIG() aggregate and the optimizer generates a 2 phase PARALLEL aggregation strategy, then the value returned will be incorrect. The value will be equal to the number of producer threads under the 2 phase aggregate's supporting XCHG operator.

CR:771382

CR Number:   771382 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 1142 error was raised on a user defined tempdb (saptempdb) during boot time recovery against 15.7 sp122 ASE. Please use system procedure sp_dbrecovery_order to change database recovery order, e.g. sp_dbrecovery_order saptempdb, 1, force,strict It will let ASE rebuild user defined tempdb saptempdb first after recovery system databases, then recovery other user databases. Workaround Description  Please use system procedure sp_dbrecovery_order to change database recovery order, e.g. sp_dbrecovery_order saptempdb, 1, force,strict (let ASE rebuild user defined tempdb saptempdb first after system databases recovery for BS on ASE system)

CR:771433

CR Number:   771433 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2014 Fixed 06 Oct 2014 Fixed 07 Oct 2014 Fixed 08 Oct 2014 Fixed 29 Oct 2014 Fixed 16 Nov 2014 Bundled Request Description Repeated reduction/increasing the number of running engines in threaded kernel mode (using alter thread pool) may eventually lead to a situation where a server login is not possible.

CR:771451

CR Number:   771451 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2014 EOL'd version. Not to be Fixed. 23 Dec 2014 Fixed 06 Jan 2015 Fixed 08 Jan 2015 Fixed 08 Jan 2015 Fixed Description ASE stack trace at kboflushcache+0xd9() with SIGSEGV

CR:771550

CR Number:   771550 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) 05 Nov 2014 Fixed 22 Dec 2014 Fixed 07 Jan 2015 Fixed Description A session using a java function may raise error 712 "There is insufficient heap memory to allocate <n> bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system." after a while. Workaround Description  Please try: 1. Increase parameter value 'heap memory per user' via sp_configure. 2. Shorter java session to recycle resources holding by the session quickly.

CR:771676

CR Number:   771676 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2014 Fixed 16 Jan 2015 One-off Provided 27 Oct 2014 Fixed 28 Oct 2014 Fixed 16 Jan 2015 Fixed Description When a select from a table with predicated privileges is done after running update index statistics on the table, errors 706 - "Process <n> tried to remove PROC_HDR <addr> that it does not hold in Pss." and 913 - "Could not find row in sysdatabases with database id <n>." may be reported.

CR:771677

CR Number:   771677 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows 7 Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2014 Fixed 07 Nov 2014 Bundled Request Description The SAP DBISQL window title fails to refresh after a "use <db_name>" statement is executed.

CR:771696

CR Number:   771696 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2014 Fixed Description Currently we return error as a part of coalesce, case and nullif functionality when both the parameters or all parameters provided are 'null'. This behaviour is different as compared to other competitors. To make it CDS/BW compliant we need to make sure that we return NULL in these cases. This cr would correct the behaviour to make it CDS/BW compliant.

CR:771719

CR Number:   771719 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Linux Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2014 Presently Not Targeted For Any Future Release Of This Product 16 Oct 2014 Fixed 19 Oct 2014 Fixed Description DDLGEN capturing incorrect Stored Procedure DDL: When SP is set to both anymode and 'dynamic'

CR:771750

CR Number:   771750 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature Request: for configuration option that would cause CREATE DATABASE and ALTER DATABASE to fail if it was unable to allocate all the space requested. Workaround Description  Check the messages returned by CREATE DATABASE eg: CREATE DATABASE: allocating 7936 logical pages (124.0 megabytes) on disk 'dbccdb1_log_001' (81920 logical pages requested).

CR:771770

CR Number:   771770 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2014 Fixed 23 Dec 2014 Fixed 06 Jan 2015 Fixed Description In rare circumstances, an undetected deadlock may occur following 1249 error, "Process became runnable before lock it was waiting for was released", is reported.

CR:771817

CR Number:   771817 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description An incorrect rows affected value is returned for first UPDATE statement on a table following an ALTER TABLE COMPRESSION = NONE statement.

CR:771846

CR Number:   771846 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When decrypting a null password for Job Scheduler, ASE will report "kernel SSL or Crypto Error Message: 'An unexpected failure occurred while performing an OpenSSL cryptography operation. Root error: error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt.'" Workaround Description  Do not use null password for Job Scheduler logins for issue 2.

CR:771870

CR Number:   771870 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 sp03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2014 Fixed 11 Dec 2014 Fixed Description When processing replicated data for a table having several BIT datatype columns, RepAgent may stacktrace in the module 'ra__substitute_vals'.

CR:771876

CR Number:   771876 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Performance problem with application context builtins Workaround Description  Setting sa_role on for dbo

CR:771887

CR Number:   771887 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a getutcbigdatetime() function.

CR:771897

CR Number:   771897 Product Name:   Adaptive Server Enterprise Product Component:   SQL Status:   Closed OS:   all Original Version:   15.7 SP122 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2014 Presently Not Targeted For Any Future Release Of This Product 11 Dec 2014 Port Not Needed 03 Nov 2014 Fixed 17 Nov 2014 Fixed 23 Dec 2014 Fixed Description The loginfo builtin with the 'xactspanbyspid' option can sometimes result in a stacktrace being reported in the SAP ASE errorlog with a message like "ubo_object_from_slot:Pss Invalid slot id 0".

CR:771901

CR Number:   771901 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2014 Fixed 09 Dec 2014 Fixed 05 Dec 2014 Fixed 09 Dec 2014 Fixed 24 Dec 2014 Fixed Description An 834 error, Illegal attempt to clean buffer in the module cm_dbclean together with a stack trace which includes the modules onl_online_db and buf_online_database may be reported in the error log when DUMP TRANSACTION or DUMP DATABASE and ONLINE DATABASE are executed simultaneously for the same database.

CR:771949

CR Number:   771949 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2014 Fixed 23 Dec 2014 Fixed 06 Jan 2015 Fixed Description SAP ASE is returning a longer string/resultset for str_replace. Workaround Description  select convert(varchar(35), str_replace(convert(varchar(35), getdate(),111 ), '/', '-'))

CR:771968

CR Number:   771968 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances a customer hit the signal 11 in execrpc() ASE 157 CE ESD#03

CR:772000

CR Number:   772000 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2014 Fixed 09 Dec 2014 Fixed 09 Dec 2014 Fixed 05 Jan 2015 Fixed Description The message "timeslice -501, current process infected" in the module 'plc__discard' together with a stack trace which includes the modules 'xact__rollbackxact' and 'finishlog' may be reported in the error log when a multi-database transaction is executed in chained mode whereby the option dml_logging=minimal is enabled and while a DML command is rolled back following an error encountered. Workaround Description  In customer ENV, set dml_logging to full can avoid this issue.

CR:772030

CR Number:   772030 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2014 Duplicate Description In rare circumstances running sp_altermessage might hit the error 225. state 3 on ASE 15.0.3 ESD#4.2

CR:772045

CR Number:   772045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2014 Fixed 22 Dec 2014 Fixed 30 Dec 2014 Fixed 30 Dec 2014 Reservation Made 08 Jan 2015 Fixed Description SAP ASE Application context built-in functions may report an unexpected permissions error.

CR:772101

CR Number:   772101 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2014 Fixed 11 Nov 2014 Fixed 18 Dec 2014 Fixed 23 Dec 2014 Fixed 31 Dec 2014 Fixed Description There may be a signal 11 (SIGSEGV) reported in the SAP ASE errorlog when in a query a union or union all with 4 or more sides of the union exist. This is rare and would usually be accompanied by missing stats resulting in large overestimates in the optimizer, and/or an underconfigured tempdb. Workaround Description  set alternative_greedy_search off or use trace flag 460 to turn off the fix for CR 439391

CR:772278

CR Number:   772278 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2014 Bundled Request Description DBISQL for ASE the select options are not saved to the configuration file immediately and can be lost. Workaround Description  10) Open dbisql 11) Go to tools/options/SAP Adaptive Server Enterprise 12) Observe the truncation length has reset to default. 13) Modify the value again to 1000, click OK 14) Disconnect from the database (do not close dbisql) 15) Reconnect 16) Go to tools/options/SAP Adaptive Server Enterprise 17) Observe the truncation length has been preserved (as it is in jvm memory) 18) Click OK again (this time the file will save)

CR:772303

CR Number:   772303 Product Name:   ASE Management Product Component:   sybrestore Status:   Closed OS:   Generic Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2014 Fixed 13 Oct 2014 Fixed Description In point-in-time restore, when the last dump of a dump series after a database dump is a cumulative dump, the time range in Sybrestore will miss to account the last cumulative dump.

CR:772345

CR Number:   772345 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description HA Script ase_stop reports wrongly when ASE fails to stop Workaround Description  Customer has to manually kill the process on the secondary node.

CR:772346

CR Number:   772346 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 row_count() on a table may be incorrect after parallel create index or reorg. Workaround Description  Run UPDATE STATISTICS after the CREATE INDEX or REORG on the table.

CR:772356

CR Number:   772356 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2014 Fixed 30 Oct 2014 One-off Provided 03 Nov 2014 Fixed 15 Jan 2015 Fixed Description sp_downgrade may take a very long time to complete

CR:772405

CR Number:   772405 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2014 Fixed 16 Oct 2014 Fixed 17 Dec 2014 Fixed 22 Dec 2014 Fixed Description A 9004 error, "I/O error detected on disk buffer 0x... for page request <value>, dbid <value>." followed by a stack trace that contains the module 'crdb_init_first_au' may be reported in the SAP ASE error log when trying to execute an ALTER DATABASE FOR LOAD command for an in-memory database. Workaround Description  Don't use ALTER DATABASE FOR LOAD on in-memory databases.

CR:772435

CR Number:   772435 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2014 One-off Provided 21 Oct 2014 Fixed 21 Oct 2014 Fixed 27 Oct 2014 Fixed 23 Dec 2014 Fixed 30 Dec 2014 Fixed Description If user's machine is too slow, sqlupgrade[res] and syconfig.exe/sybatch.exe may failed to upgrade SAP ASE because it can't reconnect to the SAP ASE booted in single user mode.

CR:772436

CR Number:   772436 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 915 reports wrongly for the table and dbname.

CR:772456

CR Number:   772456 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2015 Fixed Description In HADR configured ASE, unplanned failover i.e. sp_hadr_admin primary, 'force' occasionally fails if remote node is not reachable.

CR:772481

CR Number:   772481 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2014 Fixed Description Upon attempting "set plan for show_execio_xml to message on" command is used before the DML statement to get the execution statistics in XML output and if the stack-trace with a method printXMLNodeMetrics() occurred, most likely this bug is exposed. Workaround Description  Not to use "set plan for show_execio_xml to message on" but that is a limitation. In order to use the feature to generate XML, there is no work-around !

CR:772498

CR Number:   772498 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2014 Duplicate Description Customer sent a memdump for investigation as why online database got infected with 11. Customer asked to raise an error message instead of doing a hard termination with infected 11 Workaround Description  Avoid running multiple 'online database' command on the same database

CR:772506

CR Number:   772506 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2014 One-off Provided 11 Dec 2014 Port Not Needed Description The dataserver will not accept any connections and messages regarding kbfalloc not being able to allocate memory are displayed. A stacktrace is displayed with sybcsi_profile_destroy on the stack.

CR:772605

CR Number:   772605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP133 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2014 Fixed 27 Oct 2014 Fixed 11 Dec 2014 Fixed 22 Dec 2014 Fixed Description The error "d_log(): xls_startscan() failed - XLS error -3: Invalid condition" may be reported when executing DBCC LOG to get the log records for a particular SAP ASE process id when passing -<process ID> as the second parameter value of this command. Workaround Description  Pass a negative number of log records such as dbcc log(dbid, -spid, 0, -1000000)

CR:772650

CR Number:   772650 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances Signal 11 might occur in LeHashBucket::Find() when creating proc under a complex view

CR:772668

CR Number:   772668 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 SP132 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2014 Fixed 05 Nov 2014 Fixed 06 Nov 2014 Fixed 09 Dec 2014 Fixed Description SAP ASE in threaded kernel mode configured with synchronous IO may hang when there is an IO failure returned from the OS e.g. EIO.

CR:772670

CR Number:   772670 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2014 Fixed 03 Nov 2014 Fixed 04 Nov 2014 Fixed 11 Nov 2014 Fixed Description When turning on the "utility statistics hashing" configuration parameter (or explicitly using the with statistics hashing phrase) and using parallel CREATE INDEX command then a 697 error "An attempt was made to fetch logical page '<page>' for <ptninfo>_PTNINFO from cache '<cache>'. Wrong logical page '<page>' was found in cache." can occur. This will not affect UPDATE STATISTICS or the serial CREATE INDEX command. Workaround Description  Disable 'utility statistics hashing' via sp_configure 'utility statistics hashing',0 Avoid turning on "utility statistics hashing" with parallel CREATE INDEX, or use the serial CREATE INDEX command when using hashing (i.e. avoid consumers)

CR:772718

CR Number:   772718 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2014 Fixed 23 Oct 2014 Fixed Description The message 16758, The configuration option 'optimize dump for faster load' is currently not supported in SAP Adaptive Server Cluster Edition." will be reported and the server will fail to boot if this option is set to any value other than 0 in the configuration file, or sp_configure is run to do this, because the only valid value for this option in Shared Disk Cluster edition is 0.