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

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

CR:742667

CR Number:   742667 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 09 Jul 2013 Fixed 15.7 SP110 16 Jul 2013 Fixed Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module ulpspinlock() and kstcpnetctlrCancelRequests() may be reported by an SAP ASE running in the threaded kernel mode on the Solaris platform. The SAP ASE may subsequently hang. Workaround Description  no workaround

CR:742693

CR Number:   742693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2013 Fixed 21 Nov 2013 Fixed Description A 1265 error, "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr=<addr_val>, lrmagic=<char_val>)." may be reported when running DBCC FIX_TEXT on a table having one or more text columns.

CR:742694

CR Number:   742694 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Group insert (TF450) can give wrong results depending on data ordering Workaround Description  Don't use traceflag 450

CR:742728

CR Number:   742728 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2013 Duplicate Description When issuing an update statement against a compressed (var)char column it is possible for the update to fail reporting error 614 and for a stack trace to appear in the ASE error log along with a message 'Invalid DOL data row pointer' and Error: 614, Severity: 21, State: 12 'Adaptive Server accessed a row that has an illegal length' Workaround Description  Upgrade to 15.7 ESD#5 (SP50) or SP100

CR:742762

CR Number:   742762 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 09 Jul 2013 Fixed 09 Jul 2013 Fixed 15.7 SP110 17 Jul 2013 Fixed 15.7 SP50 10 Jul 2013 Fixed Description Under some circumstances, an 8203 error, "Expected to find the descriptor for object <object_id> in database <db_name> in <state> state", followed by a stack trace that include the modules ssql_droptext() and procrm() may be reported in the error log.

CR:742771

CR Number:   742771 Product Name:   Adaptive Server Generic Docs Product Component:   P&T:Monitoring Tables Status:   Open OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Document all possible module names in monProcedureCacheModuleUsage

CR:742782

CR Number:   742782 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 14 Aug 2013 Fixed 13 Aug 2013 Fixed 15.7 SP121 03 Oct 2013 Fixed Description Sometimes, sp_showplan may cause a signal 11 (SIGSEGV) with a stacktrace reported in the errorlog involving the function listChildQueries(). Workaround Description  the ct has turned off the query plan collection option in ProActiveDBA to avoid this error

CR:742786

CR Number:   742786 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2013 Fixed 15.7 SP110 29 Jul 2013 Fixed 15.7 SP60 30 Jul 2013 Fixed Description In very rare circumstances, error 1765 (related to level 0 scan) could be raised unexpectedly.

CR:742847

CR Number:   742847 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 12 Sep 2013 Fixed 15.7 SP110 12 Sep 2013 Fixed 12 Sep 2013 Reservation Made 26 Sep 2013 Reservation Made Description With a new set option 'set sqlnull on', string concatenation with NULL value will follow SQL standard, i.e. return NULL value

CR:742869

CR Number:   742869 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4.2 BLK Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2014 DEFER Description sig 11 in open__byname when creating a lwp Workaround Description  turn off statement cache at the session level for the application

CR:742871

CR Number:   742871 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 PL1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Aug 2013 Fixed 11 Jul 2013 Fixed 15.7 SP121 03 Oct 2013 Fixed Description If 'procedure cache' is configured too small for a heavy loaded server, it could lead to stacktraces with s_chooselocks(), s_setup_lockrequest() and insert_to_heap().

CR:742873

CR Number:   742873 Product Name:   Universal Alerts Engine Product Component:   CORE Status:   Closed OS:   AIX Original Version:   8.3 SP01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2013 Fixed 8.2 PC08 22 Aug 2013 Fixed 8.2 PC08 25 Aug 2013 Fixed 12 Nov 2013 Fixed 23 Jul 2014 Fixed Description UAE Username/password requirement problem Target Version  8.3 SP01

CR:742889

CR Number:   742889 Product Name:   ASE Management Product Component:   Web Console Status:   Closed OS:   Generic Original Version:   3.2.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2013 Fixed Description The Login view in the Admin Console shows wrong default database for server 15.7 or above when the login is created under following two conditions. 1. If the login is created ignoring login profile, the "create login..." command lacks the clause of 'login profile ignore' or "sp_addlogin" is used. 2. If the login is created with login profile and the login profile has blank default database.

CR:742896

CR Number:   742896 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 09 Jul 2013 Fixed 10 Jul 2013 Fixed 15.7 SP110 10 Jul 2013 Fixed Description In some cases, SAP ASE may report a timeslice error in module shm_mergedump() when "memory dump compression level" is set as non-zero value.

CR:742914

CR Number:   742914 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 11 Jul 2013 Fixed 15.7 SP51 11 Jul 2013 Fixed 23 Sep 2013 Port Not Needed Description DDLGen cannot generate a 'GRANTED BY' permission clause when run against SAP ASE 15.7 SP50 and higher versions.

CR:742985

CR Number:   742985 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2013 Fixed Description Default value of max total shared memory is insufficient to build server.

CR:742987

CR Number:   742987 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 10 Jul 2013 Fixed 15.7 SP60 19 Jul 2013 Fixed 07 Feb 2014 Fixed Description An 814 error, "Keep count of buffer <buf_num> in cache <cache_name> holding logical page <page_id> in database <db_name> has become negative", followed by an 837 error, "Attempted to grab wash header" may be reported during UPDATE STATISTICS or CREATE INDEX.

CR:742991

CR Number:   742991 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 18 Jul 2013 Fixed Description After a server crash while shrink database is sorting a non-unique index, boot-time recovery will set the index to be suspect with out any information in errorlog.

CR:742992

CR Number:   742992 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 12 Sep 2013 Fixed 14 Nov 2013 Fixed Description "alter database" option "with check_only" does not warn about indexes having many duplicated key entries, which could cause shrink database to keep the table locked for unacceptable lengths of time while it sorts index entries. Knowing about these potential problems can help customers plan their work.

CR:742997

CR Number:   742997 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2014 Added to user documentation Description Three words "manage", "decrypt_default" and "xmltable" are not in the list of ASE reserved words.

CR:743045

CR Number:   743045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 23 Jul 2013 Fixed 15.7 SP121 31 Oct 2013 Fixed 18 Nov 2013 Fixed Description When log segment of a database exhausts and tasks involving page allocation are in progress, ASE could hit 804 error : "Unable to find buffer '0x..' from cache '...' holding logical page '...' in sdes '0x...' kept buffer pool for object '...'. Workaround Description  There is no workaround for the 804 error. But avoiding 1105 error through having considerably big log segment for database would avoid 804 error too.

CR:743053

CR Number:   743053 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2013 Fixed Description sp_config_rep_agent enable must now be run with a non-NULL password.

CR:743055

CR Number:   743055 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 19 Jul 2013 Fixed 15.7 SP60 28 Jul 2013 Fixed Description A SAP ASE that running in threaded kernel mode on the Linux or HPUX operating systems may print a stack trace including ulpspinlock and kstcpnetctlrCancelRequests and thereafter the SAP ASE becomes non-responsive.

CR:743075

CR Number:   743075 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 SP60 17 Jul 2013 Fixed 15.7 SP110 19 Jul 2013 Fixed Description The configuration option, 'enable plan sharing' is no longer automatically enabled when the configuration option, 'enable functionality group' is enabled. The option 'enable plan sharing' must now be enabled explicitly.

CR:743144

CR Number:   743144 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2014 Already Fixed by Another CR Description The sp_config_dump parameter documented as @retain_days should be actually be @retaindays. The procedure will ignore any value passed as @retain_days.

CR:743145

CR Number:   743145 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP100 PL00 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 17 Jul 2013 Fixed Description Cumulative dumps cannot be done in Cluster Edition. An error will now be reported if sp_dboption is used with the "allow incremental dumps" option in Cluster Edition.

CR:743177

CR Number:   743177 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 Jul 2013 Fixed 15.7 SP110 17 Jul 2013 Fixed 15.7 SP60 24 Jul 2013 Fixed Description System stored procedures, such as sp_password, sp_extrapwdchecks, sp_addlogin, do not have asterisks stored in audit table for password parameters when 'exec_procedure' auditing option is on.

CR:743203

CR Number:   743203 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 15 Jul 2013 Fixed 18 Jul 2013 Fixed Description DDLGen cannot generate 'Granted by' permission clause for ASE 15.7 SP50 and higher version.

CR:743211

CR Number:   743211 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP102 12 Jul 2013 Fixed 15.7 SP60 16 Jul 2013 Fixed 15.7 SP110 16 Jul 2013 Fixed Description During BCP for a table which has undergone an ALTER TABLE DROP column with no datacopy operation, ASE may send wrong default values for columns to the client.

CR:743214

CR Number:   743214 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2014 EOL'd version. Not to be Fixed. Description Signal 11 in crdb_phys during recovery

CR:743218

CR Number:   743218 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7.1 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 15 Aug 2013 Fixed 02 Jul 2014 Presently Not Targeted For Any Future Release Of This Product 22 Aug 2013 Fixed 15.7 SP110 15 Aug 2013 Fixed Description When a table is altered to have not materialized columns with default values, null values are sent to the Rep Server instead of the default values during the execution of an UPDATE command. Workaround Description  Simpler repro : language mode, no index =============== use pdb go drop table test go create table test ( c1 int null ) go sp_setreptable test,true go use rdb go drop table test go create table test ( c1 int null ) go grant all on test to public go insert into test values (1) go use pdb go alter table test add c2 int default 1000 not null not materialized, c3 int default 1000 not null not materialized, c4 int default 1000 not null not materialized, c5 int default 1000 not null not materialized, c6 int default 1000 not null not materialized, c7 int default 1000 not null not materialized, c8 int default 1000 not null not materialized, c9 int default 1000 not null not materialized, c10 int default 1000 not null not materialized go use rdb go alter table test add c2 int default 1000 not null not materialized, c3 int default 1000 not null not materialized, c4 int default 1000 not null not materialized, c5 int default 1000 not null not materialized, c6 int default 1000 not null not materialized, c7 int default 1000 not null not materialized, c8 int default 1000 not null not materialized, c9 int default 1000 not null not materialized, c10 int default 1000 not null not materialized go use pdb go update test set c2 = c2 + 1, c3 = c3 + 1 go T. 2013/07/12 06:47:02. (94): 'begin transaction [0a] update top 1 dbo.test_null2 set c2=1001, c3=1001 where c1=1 and c2 is NULL and c3 is NULL and c4 is NULL and c5 is NULL and c6 is NULL and c7 is NULL and c8 is NULL and c9 is NULL and c10 is NULL ' W. 2013/07/12 06:47:02. WARNING #5185 DSI EXEC(103(1) ASE1572.rdb) - /dsiexec.c(18931) Row count mismatch for the command executed on 'ASE1572.rdb'. The command impacted 0 rows but it should impact 1 rows. I. 2013/07/12 06:47:02. The error was caused by output command #2 of the failed transaction on table 'dbo.test_null2'. I. 2013/07/12 06:47:02. The DSI thread for database 'ASE1572.rdb' is shutdown.

CR:743245

CR Number:   743245 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2014 Fixed 28 Sep 2014 Fixed Description ALTER TABLE places text pages of a table onto incorrect system segment if ALTER TABLE adds the first text/image/unitext column for the table. Workaround Description  1. create at least one text/image column during CREATE TABLE. then you can use ALTER TABLE to add more text/image columns. if you do not have any text/image column at the time of CREATE TABLE, you can use a dummy text/image column. and drop the dummy text/image column after you add your text/image column using ALTER TABLE. or 2. after the ALTER TABLE assign the incorrect segment to text/image pages, use sp_placeobject to place the text/image pages to desired segment. sp_placeobject <segment_name>, "<table_name>.t<table_name>" Note: After you execute sp_placeobject, pages that were previously written on the old device remain allocated, but all new allocations take place on the new segment.

CR:743270

CR Number:   743270 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2013 Fixed 15.7 SP110 16 Jul 2013 Fixed 15.7 SP60 16 Jul 2013 Fixed Description When an APL table is defined as PAGE COMPRESSED and contains a clustered index, some duplicate rows may be inserted successfully even though this is not allowed.

CR:743313

CR Number:   743313 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows 2008 Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2013 Presently Not Targeted For Any Future Release Of This Product Description FR: Relax implementation of Windows security requirements in ASE 15.7 ESD#2.

CR:743321

CR Number:   743321 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 26 Sep 2013 Fixed 27 Nov 2013 Fixed Description Altering an un-partition table with unique local index to a roundrobin partition table does not give an error.

CR:743350

CR Number:   743350 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 messages 12806 and 12807 could be made more useful if they identified the table the tuple's belonged to and the database the problem happened in.

CR:743361

CR Number:   743361 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 19 Jul 2013 Fixed 03 Dec 2013 Port Not Needed Description The row count used when a histogram is created on a column is now printed by optdiag and sp_showoptstats. The line "Scanned Rows:" will be added to optdiag output, and the tag <scannedRows> will be added to the sp_showoptstats output.

CR:743433

CR Number:   743433 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) 16 Jan 2014 Fixed 30 Dec 2013 Fixed 20 Dec 2013 Reservation Made 03 Jan 2014 Fixed Description Performing decryption of encrypted column data can be much slower for standard users when decrypt default is used. Workaround Description  Create a stored procedure owned by a user with sso_role with execute as owner. Grant execute on this procedure to user test1. See below where kevin has sso_role, creates procedure p1 with execute as owner and user test1 is granted execute on p1. 1> sp_showtext "kevin.p1" 2> go create procedure p1 with execute as owner as select max(comp_annual) from emp_encrypt (return status = 0) 1> sp_helprotect "kevin.p1" 2> go grantor grantee type action object column predicate grantable -------------- -------------- ---------- -------------- ------------ ------------ ------------------ ------------------ kevin test1 Grant Execute p1 All NULL FALSE (1 row affected) (return status = 0) 1> quit (tcsh)linuxsecure4% cat tp.sql set showplan on set statistics time on go execute kevin.p1 go isql -Utest1 -Psybase -S k1 -Ddb11791845 -i tp.sql Execution Time 0. Adaptive Server cpu time: 0 ms. Adaptive Server elapsed time: 0 ms. QUERY PLAN FOR STATEMENT 1 (at line 1). STEP 1 The type of query is EXECUTE. Parse and Compile Time 0. Adaptive Server cpu time: 0 ms. QUERY PLAN FOR STATEMENT 1 (at line 2). Optimized using Serial Mode STEP 1 The type of query is SELECT. 3 operator(s) under root |ROOT:EMIT Operator (VA = 3) | | |SCALAR AGGREGATE Operator (VA = 2) | | Evaluate Ungrouped MAXIMUM AGGREGATE. | | | | |RESTRICT Operator (VA = 1)(0)(0)(0)(9)(0) | | | | | | |SCAN Operator (VA = 0) | | | | FROM TABLE | | | | emp_encrypt | | | | Table Scan. | | | | Forward Scan. | | | | Positioning at start of table. | | | | Using I/O Size 2 Kbytes for data pages. | | | | With LRU Buffer Replacement Strategy for data pages. Parse and Compile Time 0. Adaptive Server cpu time: 0 ms. --------------------------- 10037992.000000 Execution Time 1. Adaptive Server cpu time: 45 ms. Adaptive Server elapsed time: 45 ms. (1 row affected) (return status = 0) Execution Time 0. Adaptive Server cpu time: 45 ms. Adaptive Server elapsed time: 45 ms. Execution Time 0. Adaptive Server cpu time: 0 ms. Adaptive Server elapsed time: 52 ms. (tcsh)linuxsecure4% cat test.sql set showplan on set statistics time on go select max(comp_annual) from emp_encrypt go isql -Utest1 -Psybase -S k1 -Ddb11791845 -i test.sql Execution Time 0. Adaptive Server cpu time: 0 ms. Adaptive Server elapsed time: 0 ms. QUERY PLAN FOR STATEMENT 1 (at line 1). Optimized using Serial Mode STEP 1 The type of query is SELECT. 3 operator(s) under root |ROOT:EMIT Operator (VA = 3) | | |SCALAR AGGREGATE Operator (VA = 2) | | Evaluate Ungrouped MAXIMUM AGGREGATE. | | | | |RESTRICT Operator (VA = 1)(0)(0)(0)(9)(0) | | | | | | |SCAN Operator (VA = 0) | | | | FROM TABLE | | | | emp_encrypt | | | | Table Scan. | | | | Forward Scan. | | | | Positioning at start of table. | | | | Using I/O Size 2 Kbytes for data pages. | | | | With LRU Buffer Replacement Strategy for data pages. Parse and Compile Time 0. Adaptive Server cpu time: 0 ms. --------------------------- 10037992.000000 Execution Time 30. Adaptive Server cpu time: 2975 ms. Adaptive Server elapsed time: 2975 ms. (1 row affected) Execution Time 0. Adaptive Server cpu time: 39 ms. Adaptive Server elapsed time: 2976 ms.

CR:743464

CR Number:   743464 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2014 Added to user documentation Description Documentation enhancement request for the EXECUTE command entry in the Reference Manual, to also document here that stored procedures silently ignore any extra parameters they are passed.

CR:743486

CR Number:   743486 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 24 Jul 2013 Fixed 15.7 SP110 19 Jul 2013 Fixed 24 Jul 2014 Fixed Description Auditing of GRANT and/or REVOKE commands may cause a timeslice error when the command contains many whitespaces.

CR:743496

CR Number:   743496 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 15 Aug 2013 Fixed 15.7 SP110 16 Aug 2013 Fixed Description Under rare circumstances SAP Adaptive Server Cluster Edition may report during the execution of sp_config_rep_agent an inaccurate run value for parameter 'bind to engine' on some nodes in the Cluster.

CR:743542

CR Number:   743542 Product Name:   ASE Management Product Component:   Administration Core Status:   Closed OS:   Generic Original Version:   3.2.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2013 Fixed Description SCC to support sp_droploginm @with_override=1 change made in ASE

CR:743558

CR Number:   743558 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) 30 Dec 2013 Fixed 31 Jan 2014 Fixed 08 Jul 2014 Fixed Description Error 14613 (The '<name>' field in usage anchor has '<n>' which does not match with '<n> from sysusages. Dbid '<id>'. Lstart '<n>'.) formats the last 4 parameters incorrectly so the output appears garbled. The field name is correct.

CR:743573

CR Number:   743573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 24 Jul 2013 Fixed 08 Dec 2013 One-off Provided 15.7 SP121 15 Dec 2013 Fixed 20 Dec 2013 Fixed Description The message "Current process infected with signal 11" in the module NormalizeScalar() with a stacktrace which includes the modules PesState::PesInit() may be reported when executing an UPDATE...FROM query on a table that has immediate refresh pre-computed result set (PRS) defined on it. Workaround Description  precomputed result set using manual refresh

CR:743580

CR Number:   743580 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description clarify and/or document library dependencies "not found" by ldd on linux

CR:743601

CR Number:   743601 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 Dec 2013 Fixed 15.7 SP121 13 Dec 2013 Fixed Description Stack trace with error 622 may occur when running update statistics

CR:743637

CR Number:   743637 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) 15.7 SP60 06 Sep 2013 Fixed 15.7 SP121 27 Sep 2013 Fixed 15.7 SP110 13 Sep 2013 Fixed 15.7 SP51 06 Sep 2013 Fixed 15.7 SP103 10 Sep 2013 Fixed Description MERGE triggers on DOL tables may return the incorrect number of rows for the inserted table: too few rows for the UPDATE trigger and possibly too many rows for the INSERT trigger.

CR:743676

CR Number:   743676 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2013 Fixed 05 Aug 2013 Port Not Needed 07 Jun 2012 Presently Not Targeted For Any Future Release Of This Product Description Wrong data may show up in page-compressed APL table with all fixed length columns.

CR:743731

CR Number:   743731 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 13 Aug 2013 Fixed Description An 806 error, "Could not find virtual page for logical page <page_id> in database '<db_name>'" may be reported when executing CHECKTABLE/CHECKINDEX/CHECKDB after shrinking a database containing a table with suspect index. Workaround Description  rebuild suspect index using DBCC REINDEX or REOGR REBUILD after shrinking database.

CR:743763

CR Number:   743763 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2014 Not a Bug Description When dumping a VLDB (> 2 TB) created on 15.5 (or prior) and loading to 15.7x, using the older compress:: syntax, the database load may fail. Workaround Description  Retake the db dump using new the compress syntax. compress = 101 is known to have worked okay.

CR:743771

CR Number:   743771 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2013 Consult Complete Description Using "lava based parallel create index" needs to have its own configuration option.

CR:743775

CR Number:   743775 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2013 Fixed 15.7 SP60 05 Aug 2013 Fixed 15.7 SP121 21 Aug 2013 Fixed 24 Jul 2014 Fixed Description Audit table records might be malformed or missing for table access events when auditing is turned on.

CR:743795

CR Number:   743795 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2013 Fixed Description ase_default optlevel changed to include all optimizer changes from all releases prior to ase 15.7 sp200

CR:743863

CR Number:   743863 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to have Sybmigrate migrate the current next identity value for tables.

CR:743864

CR Number:   743864 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 19 Dec 2013 Fixed 02 Jul 2014 Presently Not Targeted For Any Future Release Of This Product 24 Jan 2014 Fixed 15.7 SP121 20 Dec 2013 Fixed 30 Jan 2014 Fixed 31 Jan 2014 Reservation Made Description When using alter table not materialized with defaults replication needs to be supplied with the correct default values for log records created before the alter table if replication is behind in reading the log.

CR:743869

CR Number:   743869 Product Name:   Universal Alerts Engine Product Component:   CORE Status:   Open OS:   AIX Original Version:   2.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2013 Fixed 21 Aug 2013 Fixed 12 Nov 2013 Fixed Description Problem finding AutoStartUAE.properties

CR:743874

CR Number:   743874 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 Msg 941 'Illegal database context operation.' may be raised if run DBCC IOSIZE() for an object in a database which cannot be currently accessed.

CR:743913

CR Number:   743913 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2013 Fixed 15.7 SP121 16 Oct 2013 Fixed 15.7 SP60 17 Oct 2013 Fixed Description When a new plan for a procedure is installed, the accumulated metric LogicalReads in the monCachedProcedures table for the cached procedure maybe incorrect.

CR:743922

CR Number:   743922 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2013 Consult Complete 08 Aug 2013 Consult Complete 15.7 SP60 06 Aug 2013 Fixed 15.7 SP110 07 Aug 2013 Fixed 15.7 SP51 09 Sep 2013 Fixed 15.7 SP103 09 Sep 2013 Fixed Description In rare circumstances, a SELECT FOR UPDATE query may return successfully without getting the exclusive lock on the row, even if READPAST mode was not being used. This only affects the AIX platforms and has been identified as an AIX compiler optimization issue when high levels of optimization are used on a specific module.

CR:743929

CR Number:   743929 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 22 Aug 2013 Fixed 28 Nov 2013 Fixed Description The maximum length of a user defined datatype (UDD), formerly restricted to the page size, is increased to the maximum size of a local variable of the same base type. See the output of DBCC SERVERLIMITS for the values of current limits.

CR:743936

CR Number:   743936 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 25 Jul 2013 Fixed 25 Jul 2013 Fixed Description srvbuild/srvbuildres does not report any error message if the given device file paths do not have read/write permission.

CR:743938

CR Number:   743938 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 have an XML schema docuement for showplan_in_xml() output included in the ASE distribution package.

CR:743959

CR Number:   743959 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2014 Added to user documentation Description The reference manual entry on the dump database command has a note indicating that the dump file size may be incorrect when overwriting a file of the same name. As of 15.0.2 this is no longer true, the older file is now deleted before the new dump file is created, resulting in a correct file size.

CR:744011

CR Number:   744011 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2013 Duplicate 02 Sep 2013 One-off Provided 03 Jun 2014 Fixed 10 Jun 2014 Fixed 12 Jun 2014 Port Not Needed Description When a user database is binded to a named cache, create index in it might report Error 693 while a dump database process running simutanously.

CR:744013

CR Number:   744013 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Aug 2013 Fixed 15.7 SP110 02 Aug 2013 Fixed 14 Nov 2013 Not a Bug 15 Nov 2013 Fixed Description In a High Availability server, sp_addlogin and sp_addremotelogin will fail with permission errors when the user executing the stored procedures is granted sso_role only. Workaround Description  Grant sa_role and ha_role to user executing sp_addlogin or sp_addremotelogin.

CR:744015

CR Number:   744015 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Nov 2013 Fixed Description syconfig: Syconfig.exe: additional argument cannot be read into "Command Line" field

CR:744021

CR Number:   744021 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 29 Aug 2013 Fixed 15.7 SP110 29 Aug 2013 Fixed 10 Sep 2013 Bundled Request Description When the RepAgent configuration parameter 'rs servername' is longer than 30 characters, the run value of that parameter gets corrupted in memory.

CR:744045

CR Number:   744045 Product Name:   ASE Management Product Component:   Administration Core Status:   Closed OS:   Generic Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2013 Fixed Description In the 'Include Objects in DDL Output' dialog that is opened from the Generate Objects DDL menu option of a database, you will see that the count of objects for Scalar Functions and SQLJ Functions is not correctly including the count for the Scalar Functions if they do exist. The count only shows the number of SQLJ Functions.

CR:744049

CR Number:   744049 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2013 Fixed Description sp_help does not display information if partition locking is enabled on table.

CR:744075

CR Number:   744075 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 05 Sep 2013 Fixed 15.7 SP110 11 Sep 2013 Fixed Description When RepAgent is configured to use multi-path replication thru the option multithread rep agent and the number of replication paths is at least set to 2 thru the option 'max number of replication paths', in rare circumstances the replicated data between the primary and the standby databases may show inconsistencies resulting in data not being correctly replicated.

CR:744116

CR Number:   744116 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 07 Aug 2013 Fixed 15.7 SP121 23 Oct 2013 Fixed 14 Nov 2013 Fixed Description The SAP ASE Rep Agent thread sends float values ending in .0 without the .0 which makes them appear to be integers instead of floating point values. This can cause statement caching to create multiple plans for the same table leading to contention in the statement cache and degrading query performance.

CR:744123

CR Number:   744123 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 29 Jul 2013 Fixed 24 Jul 2014 Fixed Description A 2760 error, "Column name '' does not exist in target table", may be reported during the automatic generation of temp table statistics when the temp table uses a NUMERIC datatype. Workaround Description  set auto_temptable_stats off

CR:744179

CR Number:   744179 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 Umbrella CR for memory corruption with functionality group enabled.

CR:744181

CR Number:   744181 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) 15.7 SP110 30 Jul 2013 Fixed Description The message, "Current process infected with signal 11", may be reported in the error log when killing the spid (using the sql 'kill <spid>') while running REORG DEFRAG.

CR:744185

CR Number:   744185 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2013 Fixed Description When running reorg rebuild index on compressed index, error 12323 state 43 may be raised during key movement.

CR:744195

CR Number:   744195 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 19 Sep 2013 Fixed 30 Sep 2013 Presently Not Targeted For Any Future Release Of This Product 26 Sep 2013 Fixed 24 Sep 2013 One-off Provided Description A 10707 error Unhandled Java Exception: may be reported by the PCA/JVM Security Manager when the JRE needs to internally process information on native methods properties while executing a user supplied method. In order for the PCA/JVM Security Manager to allow the execution of native methods the directive "-Dsybase.allow.native.lib=true" in the "pca_jvm_java_options" configuration must be set to true in the sybpcidb database. Workaround Description  For sunsparc and possibly sunx64, modify $SYBASE/shared/JRE-7_0_7/lib/security/java.security file as follows and reboot ASE to reset the JVM. Comment out UcryptoProvider and re-order 1-10 like below. # # List of providers and their preference orders (see above): # #security.provider.1=com.oracle.security.ucrypto.UcryptoProvider ${java.home}/lib/security/ucrypto-solaris.cfg security.provider.1=sun.security.pkcs11.SunPKCS11 ${java.home}/lib/security/sunpkcs11-solaris.cfg security.provider.2=sun.security.provider.Sun security.provider.3=sun.security.rsa.SunRsaSign security.provider.4=sun.security.ec.SunEC security.provider.5=com.sun.net.ssl.internal.ssl.Provider security.provider.6=com.sun.crypto.provider.SunJCE security.provider.7=sun.security.jgss.SunProvider security.provider.8=com.sun.security.sasl.Provider security.provider.9=org.jcp.xml.dsig.internal.dom.XMLDSigRI security.provider.10=sun.security.smartcardio.SunPCSC

CR:744199

CR Number:   744199 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   chaumont Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Cardinality defined on references is lost when generating XML Model from PDM.

CR:744256

CR Number:   744256 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 29 Jul 2013 Fixed 15.7 SP60 31 Jul 2013 Fixed Description In rare circumstances, soft fault 100015 (page loop error) reported by DBCC CHECKSTORAGE may be upgraded to hard fault after running DBCC CHECKVERIFY.

CR:744283

CR Number:   744283 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 22 Nov 2013 Fixed 15.7 SP121 06 Dec 2013 Fixed 06 Dec 2013 Fixed Description When the SAP ASE builtin function ABS() is given a bigint or integer minimum value, a negative result is returned.

CR:744303

CR Number:   744303 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 14 Aug 2013 Fixed 15.7 SP110 15 Aug 2013 Fixed Description In cases where REORG DEFRAG or SHRINK DATABASE command encounters a signal 11 error, the table might not be usable by Level 0 scanners.

CR:744317

CR Number:   744317 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2013 Fixed Description Reorg rebuild index on compressed index may hit assertion failure in bt__rowcmp() during key movement.

CR:744349

CR Number:   744349 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Add abstract plan ID and plan group ID (from sysqueryplans) to monSysStatement when query is executed using a previously stored abstract plan.

CR:744360

CR Number:   744360 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2013 Insufficient priority to fix Description Under some circumstances you can get an abstract plan warning message when using UNION ALL

CR:744363

CR Number:   744363 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2013 Insufficient priority to fix Description Inconsistant output to optimiser trace files

CR:744369

CR Number:   744369 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2014 Added to user documentation Description Doc CR: fix all the current reorg docs pertaining to allpages.

CR:744375

CR Number:   744375 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Linux Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 02 Aug 2013 Fixed 15.7 SP110 02 Aug 2013 Fixed Description The scheduled jobs configured using the Job Scheduler, with 'repeats' value greater than one day (eg. repeats=2d or repeats=25h or repeats=1441m) may run daily at the incorrect time.

CR:744389

CR Number:   744389 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 04 Aug 2013 Fixed 15.7 SP110 06 Aug 2013 Fixed 14 Jan 2014 Fixed 14 Jan 2014 Fixed Description The message, "Current process infected with signal 8 (SIGFPE)", followed by a stack trace that includes the module sam_setup_ptn() may be reported in the error log under rare circumstances.

CR:744484

CR Number:   744484 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 SP110 01 Aug 2013 Fixed 05 Aug 2013 Fixed 15.7 SP60 05 Aug 2013 Fixed Description The datatype of 'starttime' output parameter of sp_xact_loginfo is not correct. This results in a NULL value in starttime when executing the stored procedure with the 'oldestactive' option.

CR:744492

CR Number:   744492 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 19 Sep 2013 Fixed 14 Nov 2013 Fixed Description Backup Server: does not support syntax " dump ... with compression = 0" contrary to documentation. Workaround Description  N/A

CR:744541

CR Number:   744541 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2013 Fixed 04 Dec 2013 Fixed 05 Dec 2013 Fixed 19 May 2014 Fixed Description Assertion (ISUSERTABID(objid)) fails in the function xact__getdlm_fromxdes() during upgrade when running diagserver.

CR:744560

CR Number:   744560 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2014 Fixed 06 Oct 2014 Fixed Description In rare circumstances, when the CREATE INDEX and REORG REBUILD commands are running in parallel, WORKER processes may hang/sleep infinitely.

CR:744564

CR Number:   744564 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2013 Fixed Description Error 2622 can be generated while gathering statistics on a DOL (data only locking) table, in which the set of attributes cannot fit into an APL (all pages locking) row of a worktable. This can happen when statistics are explicitly updated on a column(s), or implicitly when auto_temptable_stats is enabled (explicitly or thru an optlevel containing this optcriteria).

CR:744567

CR Number:   744567 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 SP101 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 12 Sep 2013 Fixed 15 Nov 2013 Fixed 24 Jul 2014 Fixed Description Improve HK Chores cleanup processing after errors.

CR:744571

CR Number:   744571 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Unknown Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 06 Aug 2013 Fixed 15.7 SP110 06 Aug 2013 Fixed Description The DBCC utility reset_cached_plan_stats incorrectly checks for granular permissions.

CR:744588

CR Number:   744588 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   chaumont Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Generating PDM from an XSM: it does not generate PDM domains from XSM Simple types if they are not used by an element. The generated PDM is empty.

CR:744634

CR Number:   744634 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2013 Fixed 04 Sep 2013 Reservation Made 29 Oct 2013 Not a Bug Description Support Volatile Table whose row count may change dramatically so corresponding statistics are not maintained.

CR:744650

CR Number:   744650 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2013 Fixed Description When Engine local cache percent value is increased above the threshold, the server is infected with SIGNAL 11.

CR:744670

CR Number:   744670 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2014 Fixed 21 Oct 2014 Fixed Description In very rare cases open cursor may give incorrect results if a concurrent online partition utility like SPLIT, MERGE commits concurrently.

CR:744671

CR Number:   744671 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 14 Aug 2013 Fixed 15.7 SP110 14 Aug 2013 Fixed Description Under rare circumstances, shrinking a database can cause a subsequent recovery failure of that database. This is indicated by a message in the error log upon restart, saying that the object descriptor of object {N} cannot be installed. {N} may be 1, 2, or 28.

CR:744695

CR Number:   744695 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 12 Aug 2013 Fixed Description The show_condensed_text() function will return NULL with 208 error in some cases and will return NULL for dynamic prepared statement with the 102 error.