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

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

CR:752839

CR Number:   752839 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 27 Dec 2013 Fixed 20 Jan 2014 One-off Provided 21 Dec 2013 One-off Provided 19 Dec 2013 Fixed 16.0 27 Dec 2013 Fixed 13 May 2014 One-off Provided 15.7 SP61 22 Jan 2014 Fixed 05 Feb 2014 One-off Provided 24 Jul 2014 Fixed Description The message "current process infected with 11 (SIGSEGV)" in the module 'cpynodes' together with a stack trace which includes the modules 's_copytmps' and 'batch_loopend' may be reported in the SAP ASE errorlog when a BATCH INSERT into a temporary table is executed, followed by 6103 and 703 error while SAP ASE attempts to free procedure cache memory.

CR:752858

CR Number:   752858 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) 09 Apr 2014 DEFER 20 Oct 2014 Fixed 30 Sep 2014 Reservation Made 03 Nov 2014 Fixed 23 Dec 2014 Fixed 08 Jan 2015 Fixed Description Replicating "datetime" data type from primary DB when primary client application apply data having different localization than RepServer, cause DSI to goes down with error #249 when Statement-Replication is activated and threshold is reach: E. 2013/12/02 08:55:31. ERROR #1028 DSI EXEC(106(1) db_srv2.ads_main) - dsiqmint.c(4358) Message from server: Message: 249, State 1, Severity 16 -- 'Syntax error during implicit conversion of VARCHAR value 'Dez 1 2013 11:00:23:020PM' to a DATETIME field.'. (here, Dez word (in datetime value Dez 1 2013 11:00:23:020PM) is the short name for December month in German) This may also impact other "date" data type. Workaround Description  Change RepServer localization, set it same as primary client application. or turn off statement replication.

CR:752871

CR Number:   752871 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2013 One-off Provided 16.0 12 Dec 2013 Fixed 15.7 SP60 11 Dec 2013 Fixed 15.7 SP121 12 Dec 2013 Fixed 12 Dec 2013 Fixed 20 Dec 2013 One-off Provided 15.7 SP111 28 Feb 2014 Fixed Description A 644 error "Index row entry for data row id (<page#>, <row#>) is missing from index page <page#> of index id <value> of table '<name>' in database 'name'. Xactid is (<page#>,<row#>) ). Drop and re-create the index." may be reported when a clustered index on a Data Locked Only table permits duplicate keys and the index refers to pages with logical page numbers higher than the value of 2147483647.

CR:752892

CR Number:   752892 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 11 Dec 2013 Fixed 16.0 16 Dec 2013 Fixed Description DDLGen failed and showed error 'UDM51: java.sql.SQLException' if syslanguages.langid > 99

CR:752984

CR Number:   752984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a configurable parameter for the limit on the number of or-terms.

CR:752991

CR Number:   752991 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 20 Dec 2013 Fixed 19 Dec 2013 Reservation Made Description Trace flag 7796 will prevent the query from being aborted when the recompilation limit has been exceeded. Instead informational messages will be printed when some multiple of the recompilation limit has been reached.

CR:753022

CR Number:   753022 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP61 06 Jan 2014 Fixed 15 Jan 2014 Fixed 15.7 SP121 15 Jan 2014 Fixed 10 Jan 2014 Port Not Needed Description SAP ASE running on Windows platforms may report the following message in the SAP ASE errorlog early on during startup: "kernel KERNEL structure not padded correctly - size = 1736". This message may be safely ignored, and this CR prevents it being reported.

CR:753035

CR Number:   753035 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 Feb 2014 Fixed 27 Feb 2014 Fixed Description When merge partitions for table with local indexes, if index rebuild on parallel, error message 14108 will be raised.

CR:753036

CR Number:   753036 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 Jan 2014 Fixed 16.0 29 Jan 2014 Fixed Description There is an incorrect assertion that hits with diagserver during rebooting the server if server crashed during online reorg rebuild.

CR:753037

CR Number:   753037 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   cepheus beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2013 Fixed 16.0 17 Dec 2013 Fixed Description Fail to replicate a new login, or a password change in UTF8 dataserver when 'stream replication' is set to TRUE. A stacktrace is reported in the standby dataserver including the functions lobj_crtlogin()->lobj_crtloginmain()

CR:753079

CR Number:   753079 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 SP121 18 Dec 2013 Fixed 16.0 18 Dec 2013 Fixed 19 Dec 2013 Fixed Description For internal use. Workaround Description  No workaround

CR:753085

CR Number:   753085 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) 16.0 13 Dec 2013 Fixed 15.7 SP121 13 Dec 2013 Fixed Description Tracing optimizer behavior may not use the correct indentation when printing plan fragments

CR:753087

CR Number:   753087 Product Name:   Adaptive Server Enterprise Product Component:   Component Drop Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2013 Added to user documentation Description ASE15.7 SP60 PC Client is released with the following updates: PCC SP60 is released with OCS SDK 15.7 SP122. PCC SP60 is released with jConn jConnect (TM) for JDBC(TM)/7.07 SP120 N-OFF (Build 26972)/P/EBF21999/JDK 1.6.0/jdbcmain/OPT/Thu Nov 7 06:04:54 PST 2013 PCC SP60 is released with ODBC c:\DataAccess\bin>odbcversion -version 15.7.0.401 No Power Designer is shipped with this image, as there are no updates to PD. Please continue to use your existing Power Designer installation.

CR:753098

CR Number:   753098 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP61 15 Dec 2013 Fixed 15.7 SP121 17 Dec 2013 Fixed 16.0 17 Dec 2013 Fixed 18 Dec 2013 Bundled Request Description In a long running SAP ASE server configured for SSL, SSL handshake errors due to memory allocation failures appear for new incoming connections.

CR:753140

CR Number:   753140 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2014 Fixed 05 Feb 2014 Fixed 16.0 06 Jan 2014 Fixed 07 Jan 2014 Fixed Description The message "current process infected with 11" in the module 'plc__discard' together with a stack trace which includes the modules 'xact_endupdate' and 'reorg_main' may be reported in the error log during 'REORG REBUILD <table> WITH ONLINE' while this command is executed on a system where high concurrent DML activity is happening on the same table. Alternatively this error can occur during a high concurrent DML activity in a low durability database.

CR:753147

CR Number:   753147 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows 2008 Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 26 Dec 2013 Fixed 27 Dec 2013 Fixed 16.0 27 Dec 2013 Fixed Description In an HA environment, when the same user tries to login on both primary and companion server at the same time then the login process occasionally hangs.

CR:753171

CR Number:   753171 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2014 Fixed 25 Sep 2014 Fixed 29 Sep 2014 Fixed 03 Oct 2014 Fixed Description Error 1289 - "Internal Error in lock manager routine: Invalid lock mode ..." may be raised when SAP ASE executes a select-for-update (SFU) query and the following conditions apply: 1. The SFU query contains a TOP clause or a 'set rowcount' command was previously executed to limit the number of rows returned by the SFU query and 2. The number of rows that qualify for the SFU query exceeds the limit imposed by the TOP clause or 'set rowcount' command and 3. The optimizer chooses a parallel query plan to execute the SFU query.

CR:753175

CR Number:   753175 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2014 Fixed 03 Mar 2014 Fixed 06 Jun 2014 Fixed Description The database level replication status may become inaccurate after changing the replication status of tables or stored procedures while the secondary truncation point is not set. Workaround Description  In order to avoid the leftover status bits, all replicated tables and stored procedures that were marked explicitly for replication need to be unmarked before disabling the Secondary Truncation Point (either with dbcc settrunc or with sp_config_rep_agent disable). To clear the leftover status bits, enable and disable RepAgent: use db go sp_config_rep_agent db, enable, RS, RSuser, RSpwd go sp_config_rep_agent db, disable go

CR:753181

CR Number:   753181 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 19 Jan 2014 Fixed Description The monDeviceIO table Reads column value includes the count of APF reads. The description for this column in the monTableColumns table incorrectly stated that it did not. We removed this phrase from the description of this column.

CR:753208

CR Number:   753208 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 Feb 2014 Fixed Description Under some circumstances, some SAP ASE diagnostic tools may report logical page numbers higher than 2147483647 as negative numbers.

CR:753302

CR Number:   753302 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) 08 Sep 2014 Fixed Description When we create a table with global variable as a default and then insert a row into this table in the same batch, it will trigger a n infected with 11 (SIGSEGV) stacktrace in the SAP ASE errorolog if the insert is not cached either due to switch off due to the statement cache being disabled or by using special traceflags.

CR:753357

CR Number:   753357 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide SQL interface to retrieve the results of past dump and load operations.

CR:753387

CR Number:   753387 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The progress status messages [example: Processed 50381 allocation unit(s) out of 251904 units (allocation page 12897280). 20% completed. ] for the CREATE DATABASE, ALTER DATABASE, DROP DATABASE, and DBCC GAM commands may stop being output before the command reaches 100%, although the command does complete successfully.

CR:753408

CR Number:   753408 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) 18 Mar 2014 Fixed 08 Dec 2014 Fixed Description PagesTouched queried from monCachePool is larger than AllocatedPages under some rare circumstance.

CR:753423

CR Number:   753423 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for user level "password exp warn interval".

CR:753461

CR Number:   753461 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 20 Dec 2013 Fixed 20 Dec 2013 Fixed 16.0 20 Dec 2013 Fixed 20 Dec 2013 Bundled Request 15.7 SP61 24 Dec 2013 Fixed Description A segmentation violation occurs when sp_listener starts an SSL listener where no SSL listeners had been started previously.

CR:753525

CR Number:   753525 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP50 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2014 Fixed 15.7 SP121 22 Jan 2014 Fixed 16.0 10 Jan 2014 Fixed 10 Jan 2014 Reservation Made 25 Feb 2014 Fixed 16 Jan 2014 One-off Provided 16.0 20 Jan 2014 Fixed 15.7 SP61 20 Feb 2014 Fixed 20 Jan 2014 Reservation Made 16.0 27 Jan 2014 Fixed 15.7 SP121 11 Feb 2014 Fixed 16.0 05 Feb 2014 Fixed 16.0 14 Feb 2014 Fixed 15.7 SP121 21 Feb 2014 Fixed Description SAP ASE running on Unix/Linux platforms only prints the top 25 stack frames in a stack overflow stacktrace report which could mask the root cause and also provide insufficient diagnostics when a stack overflow is caused by a recursive function. If the stack overflow backout code uses too much stack, the backout process can cause stack guard word corruption resulting in server shutdown. This CR removes the limitation on number of frames in the stacktrace and if the stack overflow backout code use of the stack reaches within 4K bytes of the stack boundary, it then initiates forcible termination of the task to prevent stack guardword corruption. The default value of 'stack guard size' is increased by 4K bytes to retain earlier level of stack availability. Traceflag 3687 provides a stacktrace when a transaction is aborted due to insufficient stack space that can provide additional diagnostics on stack usage by the query. Traceflag 3686 disables this change. This change is not applicable to the Microsoft Windows platform.

CR:753577

CR Number:   753577 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2014 Fixed Description ASE with SSL configured and using CIS may hit SEGV in np__validate_servername() which would bring down the server.

CR:753695

CR Number:   753695 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2014 Fixed 27 Feb 2014 Fixed 03 Apr 2014 Port Not Needed 07 Apr 2014 Port Not Needed 24 Jul 2014 Fixed Description If a stored procedure is compiled in deferred compilation mode and when a compilation error is raised, it could cause an infected with 11 (SIGSEGV) stacktrace and other unexpected error messages to be reported in the ASE errorlog. Workaround Description  Switch off 'procedure deferred compilation' can avoid the problem.

CR:753704

CR Number:   753704 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 21 Jan 2014 Fixed 14 Jan 2014 Consult Complete 23 Jan 2014 Fixed Description If quoted_identifier is ON and sp_hadr_admin primary is executed, next time HADR primary server reboots as standby, instead of primary.

CR:753753

CR Number:   753753 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 25 Dec 2013 Fixed 15.7 SP121 07 Jan 2014 Fixed 26 Dec 2013 Fixed Description In rare circumstances Online REORG / ONLINE CREATE INDEX may hit SIGSEGV when table contains compressed row but table is marked as not compressed.

CR:753842

CR Number:   753842 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 26 Dec 2013 Fixed Description In rare circumstances, 691 error, "Encountered invalid logical page '0' while accessing database 'dbname' (dbid), object 'object name' (object id), index 'index name' (index id), partition 'partition name' (partition id). This is an internal system error. Please contact SAP Technical Support." may be reported with stacktrace when inserting data into TEXT/IMAGE/UNITEXT columns.

CR:753905

CR Number:   753905 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Dec 2013 Fixed 15.7 SP61 26 Dec 2013 Fixed 15.7 SP121 26 Dec 2013 Fixed 16.0 26 Dec 2013 Fixed Description When using ALTER DATABASE, an 806 error, "Could not find virtual page for logical page <page#> in database '<dbname>'..." may be reported if ALTER DATABASE removes more than a single fragment from the end of the given database. Workaround Description  There are several options: 1) Dump the database before executing the last ALTER DATABASE or 2) execute DBCC DBREPAIR(dbname, 'remap') immediately after the log off and before extending the database or 3) create a hole manually in the space that has been incorrectly left without an entry in sysusages. In the example, there is a missing row for the space between lstart 7680 and 10240. So, we would have to insert: insert sysusages values(5, 0, 7680, 2560, 0, 9, 2550, getdate(), -5 ) go dbcc dbrepair(dbname, remap) go

CR:753927

CR Number:   753927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP70 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2014 Fixed Description Performance of queries with decrypt default when run by non-privileged user is very slow.

CR:753942

CR Number:   753942 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2014 Fixed 28 Mar 2014 Fixed Description In rare cases, if SAP ASE server crashes during a ALTER TABLE UNPARTITION or MERGE PARTITION transaction, after recovery, DBCC CHECKTABLE of the table may report a 2583 error, "Number of data pages (#) counted by DBCC differs from count in the data OAM (#) for dbid <db_id> object <obj_id>". Workaround Description  Workaround-1: ============= We are getting the page count mismatch for the partitions when running 'dbcc checktable', that can be fixed by running 'dbcc tablealloc' before 'dbcc checktable'. In the testcase we are also doing 'dbcc tablealloc' but after 'dbcc checktable'. By changing the order of these two the issue is getting resolved- change in the procedure plm3_check_dbcc of calm/svr/qtst/ddl/tables/partition/PLM/tcl/plm_grp3.tcl- SQL_ok R sqlsa "dbcc tablealloc ('$tblname')" if [$R fail] { util_log "dbcc tablealloc command fails for $tblname." return -1 } util_log "dbcc tablealloc PASS" SQL_ok R sqlsa "dbcc checktable ('$tblname')" if [$R fail] { util_log "dbcc checktable command fails for $tblname." return -1 } util_log "dbcc checktable PASS" Workaround-2: ============= As mentioned in the res-2 description, if we have a checkpoint before running the online utility then 'dbcc checktable' and the affected testcases are getting PASSED.

CR:753956

CR Number:   753956 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 23 Jan 2014 Fixed 27 Jan 2014 Fixed 15.7 SP121 27 Jan 2014 Fixed 15.7 SP61 27 Jan 2014 Fixed 27 Jan 2014 Fixed Description When an insert trigger exists on the target table of the MERGE statement, the wrong result may happen.

CR:753996

CR Number:   753996 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 05 Jan 2014 Fixed 15.7 SP61 07 Jan 2014 Fixed 27 Feb 2014 Fixed 16.0 09 Jan 2014 Fixed Description An SAP ASE shutdown occurs after hitting a SIGSEGV (infected with 11). In the SIGSEGV message in the SAP ASE errorlog the faulting address may reference the function uppushaffinity(). Workaround Description  sp_configure "allocate max shared memory", 1

CR:754075

CR Number:   754075 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 SP121 10 Jan 2014 Fixed 15.7 SP61 13 Jan 2014 Fixed 16.0 17 Jan 2014 Fixed 27 Feb 2014 Fixed Description In some rare conditions, error 8201 - "Keep count of descriptor (objid=<objid>, dbid=<dbid>) was expected to be <n>. Instead <m> was found.", error severity 26, state 1 might be raised during high availability failover accompanied by a stack trace in the SAP ASE errorlog with the functions des_do_get()/ha_session_check() in it.

CR:754081

CR Number:   754081 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 07 Jan 2014 Fixed Description Signal 11 stacktrace could happen during LePipeRepart::LePipeWriteVtuple() call when a list partitioned table is the inner table of a parallel outer equi-join and the join is on the partition column. The same stacktrace could also happen for a range partitioned (instead of list partitioned) table when the upper bound of the partition condition is not MAX.

CR:754095

CR Number:   754095 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 08 Jan 2014 Fixed 15.7 SP121 08 Jan 2014 Fixed 08 Jan 2014 Fixed 15.7 SP61 08 Jan 2014 Fixed Description On the AIX platform, when SSL is enabled, after a few thousand connections, connection failures occur and error message "ks_falloc: Cannot allocate using ubfalloc" appears in the SAP ASE errorlog.

CR:754142

CR Number:   754142 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description As of 15.7 GA, the empty OAM entries reported in message 15082 can also be removed by running REORG COMPACT or REORG RECLAIM_SPACE.

CR:754150

CR Number:   754150 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 REORG RECLAIM_SPACE fails to clean up empty OAM entries.

CR:754167

CR Number:   754167 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 05 Jan 2014 Fixed 05 Jan 2014 Fixed Description When upgrade from 16.0beta1 to 16.0beta2 or later version, If the master database has a secondary truncation point set, it indicates to turn the secondary truncation point off using older server, and when rebooting with the older server an error 950(Database 'master' is currently offline. Please wait and try your command again later) will be raised.

CR:754255

CR Number:   754255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.7 SP50 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2014 Fixed 13 Feb 2014 Reservation Made 19 Feb 2014 Fixed 25 Feb 2014 Fixed 15.7 SP111 03 Mar 2014 Fixed 15.7 SP121 27 Feb 2014 Fixed 28 Feb 2014 Fixed 16.0 GA PL01 05 Mar 2014 Fixed Description A 331 error, "Query is too complex and has exhausted the name space for Ordering IDs, please breakup query into simpler components.", may be reported during a complex query with multi-tables especially using aggregates and allrows_dss optgoal.

CR:754273

CR Number:   754273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2014 Fixed 15.7 SP61 15 Jan 2014 Fixed 16.0 15 Jan 2014 Fixed 15 Jan 2014 Fixed 15.7 SP121 16 Jan 2014 Fixed Description Client connections to SAP ASE may hang when SSL is enabled and the network memory pool is exhausted.

CR:754283

CR Number:   754283 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2014 Fixed 19 Feb 2014 Fixed 04 Feb 2014 Fixed 19 Feb 2014 Not a Bug 19 Feb 2014 Not a Bug 19 Feb 2014 Not a Bug 31 Mar 2014 One-off Provided 09 Jun 2014 One-off Provided 17 Jun 2014 Fixed 29 May 2014 Port Not Needed Description Backup Server on HPUX may die with error messages: A00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 1, error code=0, system message=Pipe I/O returned 0 bytes. D00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=0, system message=Pipe I/O returned 0 bytes while trying to print out a legitimate API error.

CR:754371

CR Number:   754371 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 10 Jan 2014 Fixed 03 Feb 2014 Bundled Request Description When using compatibility mode with more than 32 columns in an order by expression, the server may stack trace.

CR:754508

CR Number:   754508 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2014 Fixed 30 Apr 2014 Fixed 02 Apr 2014 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the modules def_insert() and xls_sessionid() may be reported in the error log when an INSERT query is run in DEFERRED mode.

CR:754542

CR Number:   754542 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2014 Fixed 20 Feb 2014 Fixed 20 Feb 2014 Fixed 30 Jun 2014 Fixed Description Under some rare condition, an infected with 11 (SIGSEGV) error in the function querytuning_ins_sysoptions() may be reported in the SAP ASE errorlog.

CR:754548

CR Number:   754548 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 19 Jan 2014 Fixed Description In rare circumstances, a 2583 error, "Number of data pages (<count1>) counted by DBCC differs from count in the data OAM (<count2>) for dbid <dbid> object <objid>", may reported when running dbcc checkdb after rebooting a crashed server or loading a database dump, when a SELECT INTO or ALTER TABLE command was active at the time the server crashed or the dump was taken. Workaround Description  N/A

CR:754621

CR Number:   754621 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2014 Fixed Description preupgrade may underestimate the needed space for databases to be upgraded to 15.7 SP100 or later.

CR:754622

CR Number:   754622 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 14 Jan 2014 Fixed 25 Mar 2014 Fixed 03 Apr 2014 Fixed 04 Apr 2014 Fixed Description Performance of concurrent insert is slow.

CR:754644

CR Number:   754644 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 14 Jan 2014 Fixed 28 Jan 2014 Port Not Needed Description After upgrading from SAP ASE 15.7 SP100 to a higher version and re-running installmaster, configuration parameter 'engine local cache percent' may not be configurable through procedure sp_configure. Workaround Description  This can be worked around by adding the missing option by hand. From an account having 'sa_role', do this: 1> sp_configure 'allow update', 1 2> go 1> insert into sysconfigures (config,value,comment,status,name,parent) 2> values (592, 50, 'engine local cache percent', 524293, 'engine local cache percent', 14) 3> go 1> sp_configure 'allow update', 0 2> go

CR:754648

CR Number:   754648 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2014 Fixed 02 Apr 2014 Fixed 17 Apr 2014 Fixed 08 Jul 2014 One-off Provided 16 Sep 2014 Port Not Needed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module mda_fill_and_send_monProcessStatement() may be reported in the error log when running a query of the form SELECT ... INTO temptable.

CR:754653

CR Number:   754653 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   cepheus beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2014 Fixed 26 Sep 2014 Fixed 29 Sep 2014 Fixed 13 Oct 2014 One-off Provided Description SAP ASE may fail to boot on an AIX 7.1 machine if the machine has a missing /usr/vacpp/lib/libhC.a library. The AIX error message will report that "Dependent module libhC.a(ansi_64.o) could not be loaded." Workaround Description  Install vacpp.memdbg.aix53.rte 11.1.0.0 http://publib.boulder.ibm.com/infocenter/comphelp/v101v121/index.jsp?topic=/com.ibm.xlcpp101.aix.doc/compiler_ref/ruliblnk.html Redistributable libraries : If you build your application using XL C/C++, it may use one or more of the following redistributable libraries. If you ship the application, ensure that the users of the application have the filesets containing the libraries. To make sure the required libraries are available to users, one of the following can be done: You can ship the filesets that contain the redistributable libraries with the application. The filesets are stored under the runtime/ directory on the installation CD. The user can download the filesets that contain the redistributable libraries from the XL C/C++ support Web site at: http://www.ibm.com/software/awdtools/xlcpp/support/ vacpp.memdbg.aix53.rte : User heap/memory debug toolkit for AIX /usr/vacpp/lib/aix53/libhC.a /usr/vacpp/lib/aix53/libhC_r.a /usr/vacpp/lib/profiled/aix53/libhC.a /usr/vacpp/lib/profiled/aix53/libhC_r.a

CR:754679

CR Number:   754679 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   cepheus beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 09 Jan 2014 Fixed 15.7 SP121 14 Jan 2014 Fixed 14 Jan 2014 Fixed 16 Jan 2014 Fixed 15.7 SP61 17 Jan 2014 Fixed Description In some cases, a DML command is not correctly replicated because SAP ASE Replication Agent may mistakenly generate the table schema definition for metadata reduction for a table that is marked for replication. Schema building is needed when the table is created or altered in the same user transaction as the DML which affects the same table.

CR:754736

CR Number:   754736 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) 13 Jan 2014 Fixed 12 Jun 2014 Already Fixed by Another CR 20 Oct 2014 Fixed 24 Nov 2014 Fixed 02 Dec 2014 Fixed 22 Dec 2014 Already Fixed by Another CR Description When starting an SAP ASE server up with hundreds of engines, the CPU utilization is high and the server seems to hang.

CR:754753

CR Number:   754753 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2014 Fixed Description Alter table move partition can fail with error 326 (ALTER TABLE '<table name>' failed. The table is 0-way partitioned, and a 1-way parallel plan was generated due to lack of parallel resources. Increase the value of 'max parallel degree' and 'number of worker processes' to at least 0, and try again.), when compatibility mode is ON.

CR:754792

CR Number:   754792 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 23 Jan 2014 Fixed 24 Jan 2014 Port Not Needed 27 Jan 2014 Fixed 15.7 SP121 24 Jan 2014 Fixed 24 Jan 2014 Port Not Needed 15.7 SP111 26 Mar 2014 Fixed Description SAP ASE may enter a CPU intensive loop after a SIGSEGV (infected with 11) at ktMuxThreadTick+0x24d with the following seen in the errorlog: "Returning from kmultimap_iterator_cleanup with lock held" and "Attempting to return from utpApplyAll while holding a multimap read lock (0x<address>). The lock will be released"

CR:754856

CR Number:   754856 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) 08 Apr 2014 Fixed 24 Feb 2014 Fixed 08 Apr 2014 Fixed 15 Apr 2014 Fixed 03 Jul 2014 Fixed Description When we try to alter temporary table for the database which has proxy database mapped on secondary companion, we hit error 177: CREATE PROXY_TABLE cannot create a temporary object (with '#' as the first character name. Workaround Description  Customer has been told to use tempdb..tables instead, however per the frequency used they are not able to invest time to modify their application. Customer has been told to avoid ALTER TABLE on hashed temporary tables, per the same reason above is not feasible. To ignore the WARNING message on their application, however customer has not evaluated if this disrupt the message handling on their application code.

CR:754928

CR Number:   754928 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) 24 Nov 2014 Work as design 23 Feb 2014 Reservation Made 10 Apr 2014 Fixed 01 Apr 2014 Reservation Made 19 May 2014 Fixed 29 Apr 2014 Fixed 28 Oct 2014 Reservation Made 01 Jul 2014 Fixed Description Add Partial Index support to SAP ASE.

CR:755181

CR Number:   755181 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 16 Jan 2014 Fixed Description Updated sp_help_rep_agent 'config' output to include properties related to stream replication.

CR:755225

CR Number:   755225 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description dbcc checktable() may unnecessarily report "Invalid column length 0 found for compressed column ... The last compressed column cannot be a NULL column." if a jConnect BULK_LOAD application inserts NULL values. Workaround Description  REORG REBUILD will correct the data. (Also SELECT INTO).

CR:755230

CR Number:   755230 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 16 Jan 2014 Fixed 26 Jan 2014 Fixed 26 Jan 2014 Fixed Description For tables with several indexes and TEXT/IMAGE/UNITEXT columns, a 605 error, "An attempt was made to fetch logical page <page id> from cache <cache>. Page belongs to database <db>, object <object>, index <index>, partition <partition> and not to database <db>, object <object>, index <index>, partition <partition>.", may be reported when running 'SELECT...INTO...FROM ... WHERE condition1 or condition2 or ...' command on it with concurrent DELETE/UPDATE/TRUNCATE TABLE commands.

CR:755287

CR Number:   755287 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2014 Fixed 06 Apr 2014 Fixed 04 Apr 2014 Fixed Description An assertion will occur if encrypted columns is enabled and there are external passwords that need to be recreated.

CR:755330

CR Number:   755330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 05 Feb 2014 Fixed 15.7 SP61 19 Feb 2014 Fixed 15.7 SP121 19 Feb 2014 Fixed 20 Feb 2014 Fixed 20 Feb 2014 Fixed Description When using LDAP, an assertion message and a SIGABRT/SIGIOT (infected with 6) stacktrace may be reported in the SAP ASE errorlog. The assertion will say "result == SYBCSI_RESULT_OK, file core/source/csimemory.c". The stacktrace will include the function login__ldapauth().

CR:755333

CR Number:   755333 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2014 Fixed 07 May 2014 Already Fixed by Another CR 07 May 2014 Already Fixed by Another CR 12 May 2014 One-off Provided 29 May 2014 Port Not Needed Description The Sybmon 'stack all' command may hit signal 11 because of reference to null pointer.

CR:755424

CR Number:   755424 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 31 Jan 2014 Fixed 03 Feb 2014 Fixed 03 Feb 2014 Fixed Description When RepAgent is configured for Multiple Paths Replication and verbose LTL traces are active through Repagent traces 9201, 9227 and 9228, a SIGSEGV may occur together with a stack trace showing the module ra__sender_ltl_cmds.

CR:755454

CR Number:   755454 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2014 Fixed 24 Jun 2014 Fixed Description When migrating from SAP ASE 15.5, Sybmigrate fails at report session and shows the error: There are still external logins for the server 'mtrs$999'.

CR:755465

CR Number:   755465 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2014 Fixed 13 Jun 2014 Port Not Needed 12 Jun 2014 Fixed Description Dynamic SQL with LOB parameter which results in a character set conversion for a single, very, very large text field can raise a 712 error (out of heap memory). Avoidance of the 712 error involves using a workaround that avoids the large text field character set conversion altogether. When the error is invoked by a Java program, instead of by batch mode processing there can be a large memory leak of the heap memory for the connection. That memory leak is addressed by this CR. Workaround Description  Increase 'heap memory per user' via sp_configure to reduce the chance of 712 error. Reboot ASE regularly to recycle "Pss Session Heap" mempool if memory fragmenation due to memory leak and no much free memory to increase the memory pool size. We tried a few tests, Dan found out that we may avoid unitext ->text conversion if change table column colb data type from text to unitext. "unitext" data may be stored as UTF16 (take more disk space)? We tried connection property LANGUAGE_CURSOR=true&DYNAMIC_PREPARE=false, but still see 712 error having unitext to text conversion routine on the stack. ***update workaround*** Might have found a fix for this. Please give it a try. The basis of the problem I believe is FileReader passed to setClob will automagically use UTF-16. In order to avoid the casting, we need to use something that wont use UTF-16. InputStreamReader functions much like FileReader except you have the ability to force a Charset. In this case, forcing to iso_1 allows the same data to be inserted as BLOB_VARCHAR via setString. This inserted into my ASE 16 (entire file) without the 712 error or any modification of heap memory since we arent going through the conversions. DISCLAIMER Im not a java expert and not sure if this is the best approach to getting to InputStreamReader, however this is working. Additionally, this will have to be sanity tested against very large data as further modifications may be needed. - /DISCLAIMER PreparedStatement pstmt = conn.prepareStatement("insert into clobTest values (?, ?)"); //Prepare the file for processing StringBuffer buffer = new StringBuffer(); FileInputStream infile = new FileInputStream("clobber.txt"); InputStreamReader inread = new InputStreamReader(infile, "ISO-8859-1"); Reader in = new BufferedReader(inread); int ch; while ((ch=in.read()) > -1) { buffer.append((char)ch); } pstmt.setInt(1, 1); System.out.println("Reading entire file..."); pstmt.setString(2, buffer.toString()); pstmt.executeUpdate(); pstmt.close();

CR:755473

CR Number:   755473 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 20 Jan 2014 Fixed 20 Jan 2014 Reservation Made 21 Jan 2014 Fixed 15.7 SP121 21 Jan 2014 Fixed Description The DUMP DATABASE command may hang when run concurrently with a many other tasks if the option 'optimize dump for faster load' is set to a non zero value.

CR:755508

CR Number:   755508 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Statement contains ORDER BY clause with a select-list number will not be stored in statement cache with literal autoparameterization for parameters.

CR:755520

CR Number:   755520 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP103 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2014 Fixed 19 Feb 2014 Fixed 23 Jul 2014 Fixed Description An "infected with 11 (SIGSEGV) may occur in LeScanOp::LeGetScanInd (called from LeOrScanContext::getNextVtup) when the SAP ASE configuration option 'streamlined dynamic SQL' is turned on and the query contains ORed joins and one of the outer table's join columns contains a NULL value. Workaround Description  Turn off 'streamlined dynamic SQL'

CR:755558

CR Number:   755558 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 21 Jan 2014 Fixed 22 Jan 2014 Fixed 15.7 SP121 22 Jan 2014 Fixed Description The message "timeslice -501, current process infected" in the module 'ra_ms_get_object_filters_for_path' together with a stack trace which includes the modules 'ra__ms_apply_repfilters' and 'ra_ms_get_object_filters_for_path' may be reported in the error log by the SAP Replication Agent scanner thread for the default path when the filter distribution model is used.

CR:755644

CR Number:   755644 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2014 Fixed 14 Mar 2014 Fixed 27 Jun 2014 Fixed Description Ocassionally, a heap memory spinlock violation and followed by various stacktraces may happen for session running multiple XML queries with errors.

CR:755682

CR Number:   755682 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP51 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2014 Fixed 13 Mar 2014 Fixed 17 Mar 2014 Fixed 05 Jul 2014 Fixed Description An ALTER TABLE SPLIT PARTITION command may report a SIGSEGV (infected with 11) in the SAP ASE errorlog if the destination partition name is not specified.

CR:755705

CR Number:   755705 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 31 Jan 2014 Fixed 19 Mar 2014 Fixed Description SAP ASE Replication Agent under a multiple path replication setup will not replicate the execution of rs_ticket stored procedure to all paths.

CR:755714

CR Number:   755714 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2014 Fixed 11 Feb 2014 Reservation Made 16.0 GA PL01 21 Feb 2014 Fixed Description If the DML contains a builtin function with two or more parameters, the audit trail may print the parameters in reverse order.

CR:755734

CR Number:   755734 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2014 Fixed 19 Dec 2014 Reservation Made Description When using Synchronous Replication, the size of a batch of replicated commands can be configured by using sp_config_rep_agent to set the parameter 'max commands per package'.

CR:755806

CR Number:   755806 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 27 Jan 2014 Fixed 16.0 05 Feb 2014 Fixed 19 Feb 2014 Fixed 19 Feb 2014 Fixed Description Under extreme OLTP activity in a mixed-log and data database (like tempdb), a task doing CREATE INDEX may report "Stack overflow detected: limit: 0x0x*, guardpage: 0x0x*, sp: 0x0x*" and "*** Stack guardword corrupted" together with a stack trace that includes the modules 'pg__updateoam', 'pg_oamspace', and 'pg_allocoam'.

CR:755887

CR Number:   755887 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) 16.0 22 Jan 2014 Fixed 22 Jan 2014 Fixed 22 Jan 2014 Fixed Description The error 1120, "Adaptive Server failed to access page <pageno> in database '<database name>' because it is not an allocation page." can be raised if the commands DBCC CHECKALLOC or DBCC TABLEALLOC(syslogs) are executed on an archive database.

CR:755917

CR Number:   755917 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2014 Fixed 03 Jun 2014 Fixed 16 Jun 2014 Fixed 27 Jun 2014 Fixed 13 Jun 2014 Reservation Made 08 Jul 2014 Fixed 10 Jul 2014 Fixed Description Additional stream replication specific diagnostic information is provided through the sp_help_rep_agent procedure and several MDA tables.

CR:755985

CR Number:   755985 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2014 Fixed 10 Jun 2014 Fixed 17 Jul 2014 Fixed Description HADR deactivation operation with 'force' option kills transactions on non-HADR databases.

CR:755990

CR Number:   755990 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2014 Fixed Description When using show_sqltext a client state error may occur at the end of a batch.

CR:756069

CR Number:   756069 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 27 Jan 2014 Fixed 28 Jan 2014 Fixed 15.7 SP121 28 Jan 2014 Fixed 16.0 28 Jan 2014 Fixed Description When text is bound to a different cache than data for a given table, back-linking text partitions via dbcc shrinkdb_setup() can produce bad links.

CR:756100

CR Number:   756100 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2014 Fixed Description When the SAP ASE RepAgent is started and stopped simultaneously by concurrent users, this may cause the SAP Replication Server to shut down itself. The message "Open Server error: Error: 16330, State: 0, Severity 15 -- 'Pass-through is incomplete for spid: <number>'. RSCIOCSDisconnectHandler: consumer not up. Exiting due to a fatal error." will be reported in the Replication Server error log. Workaround Description  Restart Replication Server

CR:756143

CR Number:   756143 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 30 Jan 2014 Fixed 03 Feb 2014 Bundled Request Description Stack overflow may occur which would terminate the server, instead of the offending session. This may occur if the stack is insufficient and there are a large number of tables in the FROM lists of the query.

CR:756199

CR Number:   756199 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 27 Jan 2014 Fixed Description Applying update statistics in parallel mode on a HADR configured standby generates stacktrace and fails.

CR:756274

CR Number:   756274 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 29 Jan 2014 Fixed 29 Jan 2014 Fixed 30 Jan 2014 Fixed Description When reporting on the dump header of a dump that was taken with a higher SAP ASE version that has used new metadata in the dump, an error 3264, "The dump header contains device information with invalid token length ...", possibly followed by errors such as 3208 Unexpected end of file while reading beginning of dump... will be reported. An unknown element warning message will now be reported instead.

CR:756284

CR Number:   756284 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 03 Feb 2014 Fixed Description When there are nested subqueries with invariant materialization steps in each respective subquery, it is possible that a signal 11 can occur. Workaround Description  Use traceflag 478 can workaround the bug. The resulting plan under the traceflag could be less performant.

CR:756290

CR Number:   756290 Product Name:   ASE Management Product Component:   Monitoring Data Collector Status:   Open OS:   RH Linux Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Unable to create segment free space alert for newly added segments for databases Workaround Description  clear the authentication and Re-authenticate again

CR:756321

CR Number:   756321 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 31 Jan 2014 Fixed 11 Feb 2014 Fixed 11 Feb 2014 Fixed Description The message "Invalid column length: <num>. Value must be between 0 and 255 at offset 0 for 'data-only' row with minimum row length of 70." together with a stack trace including the modules 'collocate' and 'ra__new_schema' may be reported if a row for a replicated table with a name of the maximum length (255 char) created by a user with a name of the maximum length (30 char) is encountered by Replication Agent.

CR:756412

CR Number:   756412 Product Name:   Sybase SQL Server Product Component:   sybinit Status:   Closed OS:   Microsoft Windows Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2014 Fixed Description internal only: wrong cfg file name was created if make an overlay installation with ASE16.0GA.

CR:756437

CR Number:   756437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2014 Fixed 20 Feb 2014 Consult Complete 12 Feb 2014 Port Not Needed 19 Feb 2014 Fixed Description A statement that inserts into a table with an identity column and references a view or derived table that contains a union-all that terminates a union statement may generate a 264 error (duplicate column id) if the identity value is implicitly generated (i.e. - not explicitly provided in the insert's value list). Workaround Description  Trace flag 7789 (which disables to fix for CR 723847)

CR:756574

CR Number:   756574 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 05 Feb 2014 Fixed Description When dbcc page(dbid,pageno, opt) searches the desired page in deleted cache, causing sig 11.

CR:756600

CR Number:   756600 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2014 Fixed 27 Feb 2014 Fixed Description Error 11203 - "The command '<cmd>' is not legal for objects of this type. External definition: <name>" may be incorrectly raised when a proxy table mapped to a file system is part of an update/delete statement.

CR:756609

CR Number:   756609 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2014 Fixed 04 Aug 2014 Fixed 16 Nov 2014 Port Not Needed Description The wrong suid may be reported in sysprocesses when executing a stored procedure with execute as owner from another database context.

CR:756618

CR Number:   756618 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) 06 May 2014 Fixed 09 May 2014 Fixed 01 May 2014 Fixed 06 May 2014 Fixed 02 Jul 2014 Fixed Description Duplicate identity values may be generated after loading a transaction log dump containing transactions that inserted identity values reserved using multiple calls to RESERVE_IDENTITY().

CR:756619

CR Number:   756619 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) 05 Feb 2014 Fixed 06 Mar 2014 Fixed 25 Mar 2014 Fixed Description Selecting a remote column from DB2 may hit illegal symbol error if the schema name contains special characters.

CR:756631

CR Number:   756631 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 05 Feb 2014 Fixed 10 Mar 2014 Fixed 07 Mar 2014 Fixed 16.0 05 Feb 2014 Fixed 10 Mar 2014 Fixed 10 Mar 2014 Fixed 10 Mar 2014 Fixed 15.7 SP111 07 Mar 2014 Fixed 15.7 SP121 08 Mar 2014 Fixed Description A 644 error, "Index row entry for data row id (<pageid>, <rnum>) is missing from index page <index_pagenum> of index id <indid> of table '<tablename>' in database '<dbname>'. Xactid is (<xactid>). Drop and re-create the index." may sometimes be reported in heavily concurrent systems using DATAROWS LOCKED or DATAPAGES LOCKED tables.