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

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

CR:772749

CR Number:   772749 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2014 Fixed 08 Dec 2014 Fixed 23 Dec 2014 Fixed Description Under some rare conditions, execute dynamic sql sttaements could lead to the SIG 11 and stacktrace includes crp_vardec(), crp_var(), and sqt_reparse().

CR:772814

CR Number:   772814 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) 04 Nov 2014 Duplicate Description You can get Msg 707, Severity: 20, State: 5 when your ASE process is backing out from an error as Msg 208.

CR:772878

CR Number:   772878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2014 Fixed Description When server-wide audit options like 'dump_config' is turned on, 'dump config' interface doesn't record database name in sysaudits table.

CR:772903

CR Number:   772903 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2014 Fixed 03 Nov 2014 Fixed 14 Jan 2015 Fixed Description If a dump is created with the database option 'allow page signing' enabled and loaded 'WITH LISTONLY = CREATE_SQL', the sp_dboption command is not generated by 'CREATE_SQL' for setting the option 'allow page signing'.

CR:772915

CR Number:   772915 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Wrong result set solved after recreating index Workaround Description  Recreate index

CR:772979

CR Number:   772979 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2014 Fixed 08 Dec 2014 Fixed 11 Dec 2014 Fixed Description DDLGEN does not support WITH DBID= for CREATE DATABASE in ASE 15.7

CR:773010

CR Number:   773010 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2014 Fixed 10 Nov 2014 Fixed 11 Nov 2014 Fixed 15 Nov 2014 Fixed 08 Dec 2014 Fixed 09 Dec 2014 Fixed 23 Dec 2014 Fixed Description When a query causes timeout error, it incorrectly reads bytes from the TDS stream, reports an unexpected error like "Type '64' not implemented" and generates two RESPONSE messages to the client.

CR:773036

CR Number:   773036 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP63 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2014 Duplicate Description RA gets 9275 on a delete/insert pair that was an update. No merge bit on in the delete/insert pair. Workaround Description  use DOL tables?

CR:773070

CR Number:   773070 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2014 Fixed Description When running Adaptive Server diagserver and the service key "syb_extpasswdkey" is dropped, under some circumstances the following assertion failure is seen in the errorlog: "Assertion (pwdlen < SAMAXPWDLEN+1) failed in file /remote/aptos_bld1/asecorona/SMP/porttree/svr/sql/generic/source/utils/ssladmin.c line 414"

CR:773094

CR Number:   773094 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2014 Fixed 10 Dec 2014 Bundled Request 10 Dec 2014 Bundled Request Description DBISQL 16.0 allows results to be editable from the results window.

CR:773116

CR Number:   773116 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2014 Fixed Description Support mount/unmount encrypted database

CR:773128

CR Number:   773128 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined 27 Oct 2014 Fixed Description Make visible. This is a placeholder CR for routing purposes, not a real fix.

CR:773131

CR Number:   773131 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances ASE may hit heap memory error(712) when executing dbcc listoam on table with high OAM entry count. "Error 712: There is insufficient heap memory to allocate %ld bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system"

CR:773191

CR Number:   773191 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Open OS:   Linux Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Incorrect values reported by optdiag "Large I/O efficiency" with large I/O pool configured Workaround Description  Use built-in derived_stat(<tab_name>,indid,"lgio") instead.

CR:773230

CR Number:   773230 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description NaN values can be inserted into float and real data type columns by bulk copy routines.

CR:773273

CR Number:   773273 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) 07 Nov 2014 Fixed 05 Dec 2014 Fixed 04 Dec 2014 Consult Complete 23 Dec 2014 Fixed Description When a database has enabled page signing, under rare circumstances a transaction log page may be written with invalid page linking pointers. This can manifest as 806 errors during recovery or rollback.

CR:773430

CR Number:   773430 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Adding new VARCHAR column with single space default value via ALTER TABLE ADD NEW_COLUMN_NAME VARCHAR(column_length) DEFAULT ' ' may fail to insert the default value to the new column if database option 'allow null by default' is on. ASE may output 'Invalid column length' error to errorlog when it read a row having invalid column data. For Business Suite on ASE installation. Process of customizing SAP application systems may alter SAP application system table which is stored in ASE database, e.g. 'SAPSR3.MARA'. If a SAP table stored in ASE has just been changed with new columns added during customizing procedure, and there exists invalid column length message and stack trace in the errorlog while accessing to this table, then please consider extract the data and reload it, and also to perform this during downtime. For standalone ASE, please drop and recreate related table if it exists invalid column data to resolve the problem. If a database has database option 'allow nulls by default' on, then may need to specify 'NOT NULL' to add VARCHAR column with space as default value via ALTER TABLE, e.g. alter table table_name add new_varchar_column(column_length) default ' ' not null Workaround Description  Drop and rebuild SAP application system table "SAPSR3.MARA" to resolve the problem if the table has bad data in new added columns after customizing. If related database has database option 'allow nulls by default' on, then may need to specify 'NOT NULL' to insert space as default value to add VARCHAR column via ALTER TABLE, e.g. alter table obj add new_varchar_col default ' ' not null (Thank Yan Hong's finding)

CR:773512

CR Number:   773512 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2014 Fixed 20 Nov 2014 Fixed 06 Nov 2014 Insufficient priority to fix 11 Nov 2014 Fixed Description A segmentation violation occurs when executing command "ALTER ENCRYPTION KEY .. WITH PASSWD login_passwd ADD ENCRYPTION .. FOR LOGIN_ASSOCIATION"

CR:773554

CR Number:   773554 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2014 Fixed 17 Nov 2014 Fixed 23 Dec 2014 Fixed 31 Dec 2014 Fixed Description The execution of loginfo(<dbid>, xactspanbyspid, <spid>) built-in could take long time to complete while a DUMP TRANSACTION is concurrently run or when the amount of transaction log that is held up by it is very big.

CR:773621

CR Number:   773621 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2014 Fixed 23 Dec 2014 Fixed Description Failed upgrade cannot be restart by sqlupgrade/syconfig/sybatch. Workaround Description  Backup master device before upgrading. If failed to upgrade, restore the master device before restart the upgrading.

CR:773638

CR Number:   773638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP122 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2014 Fixed 14 Nov 2014 Fixed 21 Nov 2014 Fixed 21 Nov 2014 Fixed 24 Nov 2014 Fixed 15 Dec 2014 Fixed 15 Jan 2015 Fixed Description In large, highly concurrent environments, SAP ASE may, under specific circumstances, cease to elect large (>1 page) IO and instead revert to regular (1 page) IO for asynchronous pre-fetch (APF) for a cache. The specific circumstances include that a single table is very frequently accessed, that the table does not fit into its named cache, causing cache misses and that the workload is such that the plans include large IO and APF.

CR:773651

CR Number:   773651 Product Name:   Adaptive Server Enterprise Product Component:   ODATA Provider Status:   Open OS:   Linux Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ODATA: Cannot start ODATA service after installation on Linux platform - reports Segmentation fault. Workaround Description  1) Rename dbosrv16.ini file located in $SYBASE/ODATA-16_0/bin64 to some other name. 2) Ensure the JRE 7 bin directory under $SYBASE/shared directory is included in the path. 3) Start ODATA Server from the $SYBASE/ODATA-16_0/classes directory as: ../bin64/dbosrv16 <path to the properties file>

CR:773706

CR Number:   773706 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Queries on proxy tables using local DATETIME variables and literal values may compare incorrectly and produce incorrect results. Workaround Description  -- workaround 1 declare @MaxDate smalldatetime select @MaxDate = '20140811' select * from jProxy where datediff(dd, @MaxDate, '20111205') < 0 go -- workaround 2 declare @MaxDate smalldatetime select @MaxDate = '20140811' if @MaxDate >= '20111205' begin select * from jProxy end go

CR:773733

CR Number:   773733 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Due to a keyword collision with the new ALTER TABLE MODIFY OWNER command, trying to use ALTER TABLE to modify the datatype of a column named "owner" fails with syntax error 102. As a workaround, use SET QUOTED_IDENTIFIER ON and quote the column name "owner" in the ALTER TABLE command. Workaround Description  1) Use SET QUOTED_IDENTIFIER ON and quote the column name "owner" set quoted_identifier on go alter table t modify "owner" char(16) go

CR:773747

CR Number:   773747 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A validation check may fail on an encrypted column created with login_association option and a 15432 error is raised when an RPC is executed and Adaptive Server tries to decrypt an encryption key.

CR:773859

CR Number:   773859 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 GA PL04 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances, a INSERT statement could appear as hang if it is executed using "INS_BY_BULK" optimization criteria, the target table has several indexes and the system does not have any available worker process. Workaround Description  Increase the number of worker threads

CR:773875

CR Number:   773875 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 GA PL04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2014 Fixed 20 Nov 2014 Deferred Description The message "current process infected with 11" in the module mda__populate_RepScannersTable together with a stack trace which includes the modules mda_exec and mda_populate_monRepScanners may be reported in the error log when a query on the master..monRepScanners table is run and while the Replication Agent is shut down concurrently.

CR:773879

CR Number:   773879 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   AIX Original Version:   15.7 SP122 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2014 Fixed 11 Nov 2014 Fixed 17 Nov 2014 Fixed 23 Dec 2014 Fixed Description SAP ASE running in threaded kernel mode on the IBM AIX platform may hit a stack overflow error while starting the Job Scheduler and this may lead to a shutdown of SAP ASE.

CR:773880

CR Number:   773880 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2014 Fixed Description In rare scenarios, during a workload startup the rdbtmgr_spin spinlock might have contention.

CR:773950

CR Number:   773950 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Dec 2014 Fixed 08 Dec 2014 Fixed 22 Dec 2014 Fixed 30 Dec 2014 Fixed Description A 1295 error, "Unconditional lock request for table or page <>, dbid <> was made while holding a latch." followed by the message "current process infected with 11" in the module 'xls_sessionid' together with a stack trace which includes the modules ' chk_and_send_audit' and 'send_audit' may be reported in the error log when REORG REBUILD INDEX is executed concurrently with DUMP DATABASE.

CR:773957

CR Number:   773957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2014 Fixed 23 Dec 2014 Fixed 07 Jan 2015 Fixed Description Wrong result could be inserted into the under table when updating a view with float literal if the view has a instead of trigger and literal autoparam and statement cache are enabled. Workaround Description  sp_configure "statement cache",0 go sp_configure "enable literal autoparam",0 go or just for the session at the point of the insert. set literal_autoparam off set statement_cache off go

CR:773966

CR Number:   773966 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) 24 Dec 2014 Fixed 31 Dec 2014 Fixed 11 Jan 2015 Fixed 11 Jan 2015 Fixed Description An infected with 11 (SIGSEGV) in the function in StgStatPkg::StgVarLengthColEstimates may be reported in the SAP ASE errorlog.

CR:773978

CR Number:   773978 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) 14 Nov 2014 Fixed 13 Nov 2014 Fixed 18 Nov 2014 Fixed Description When parallel CREATE INDEX with hash based statistics gathering is used, there is a possibility of a worker thread being placed in a sleep state and not be woken up, which will cause the session to hang. Workaround Description  use serial create index with hash based statistics gathering or avoid using hash based statistics gathering with parallel create index

CR:774050

CR Number:   774050 Product Name:   ASE Management Product Component:   Administration Client Status:   Open OS:   Generic Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SAP Control Center for SAP ASE JobScheduler wizard does not present all available templates when creating new scheduled jobs. Workaround Description  Create Jobs from scratch.

CR:774069

CR Number:   774069 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When statement cache is active and a user has executed a statement that references an object owned by dbo and then creates their own object with the same name and executes the same statement, the results will continue to reflect the dbo's object rather than the user's object until the cached statement is purged from statement cache.

CR:774079

CR Number:   774079 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2014 Fixed 09 Dec 2014 Port Not Needed 18 Nov 2014 Fixed 22 Dec 2014 Presently Not Targeted For Any Future Release Of This Product Description Eliminate a spinlock window while updating MASS Status during hk_bufawrite.

CR:774082

CR Number:   774082 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) 13 Nov 2014 Fixed 17 Nov 2014 Fixed 14 Nov 2014 Fixed Description When running parallel CREATE INDEX with hash based statistics gathering there may be a timeslice error. Workaround Description  use serial create index with hash stats or use parallel create index without hash stats.

CR:774172

CR Number:   774172 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Open OS:   Microsoft Windows NT Original Version:   16.0 GA PL03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2014 Fixed 21 Nov 2014 Fixed 19 Dec 2014 Fixed Description SAP DBISQL 16 may use a lot of memory and scrolling the result set is slow in text mode. Workaround Description  use Scrollable table mode.

CR:774184

CR Number:   774184 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UNIX Original Version:   15.7 SP102 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 724 and timeslice in dseg_proc_allloc

CR:774198

CR Number:   774198 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DOL table to be partitioned the values for concurrency_opt_threshold are lost.

CR:774203

CR Number:   774203 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) 14 Nov 2014 Fixed 16 Nov 2014 Fixed 20 Nov 2014 Fixed 16 Dec 2014 Fixed Description If the database option "enforce dump tran sequence" is enabled, do not disallow CREATE INDEX with ONLINE option to run if the index is also being created with the DEFERRED_RECOVERY option.

CR:774211

CR Number:   774211 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2014 Fixed 26 Nov 2014 Insufficient priority to fix 10 Dec 2014 Fixed 28 Nov 2014 Fixed 10 Dec 2014 Fixed 10 Dec 2014 Fixed Description A 3935 error, Fatal protocol error. xact_beginupdate() API was invoked in the wrong context. The transaction is currently in 'Command-attached' state. may be reported when a DML query is executed which includes an expression that references the reserve_identity() built-in.

CR:774228

CR Number:   774228 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This is a test CR.

CR:774231

CR Number:   774231 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2014 Duplicate Description Sometimes, if temp tables change in between two batch insert calls via jdbc, then we might have a situation where we point to memory that has been freed, leading to either of following errors : 705, 706, 707, 715 or Error 719 or similar error related to memory free, having stacktrace of batch_loopend -> s_copytmps -> memfree.

CR:774323

CR Number:   774323 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 Nov 2014 Fixed 17 Nov 2014 Fixed 20 Nov 2014 Fixed 20 Nov 2014 Fixed 23 Dec 2014 Fixed Description A 644 error: "Index row entry for data row id (<pageid>, <rownum>) is missing from index page <index_pageid> of index id <indid> of table '<tabname>' in database '<dbname>' may sometimes be reported during recovery while undoing log records pertaining to an index on a Datarows Only Locked table.

CR:774338

CR Number:   774338 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2014 Fixed 09 Dec 2014 Fixed 08 Jan 2015 Fixed Description In rare circumstances an 11051 error, CREATE INDEX on the object <table> failed. Table is currently being used by one or more other tasks. Retry your query later. may be reported while transaction isolation level 0 scans are active on the same table. Starting SAP ASE with trace flag 8225 will reduce the likelihood of this error.

CR:774358

CR Number:   774358 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2015 Fixed 18 Jan 2015 Fixed Description A 632 error, "Attempt to move memory with an incorrect length of -106. Maximum allowed length is 16384", may be reported when DBCC CHECKTABLE is executed on an all-pages-locked table with a compressed index.

CR:774383

CR Number:   774383 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When a dynamic SQL with homogeneous batch parameters is executed and it's required to recompile, a 16817 error may occur if a config parameter "streamlined dynamic SQL" is OFF. Workaround Description  Don't set 0 to "streamlined dynamic SQL".

CR:774411

CR Number:   774411 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 Nov 2014 Fixed 20 Nov 2014 Fixed 25 Nov 2014 Fixed 25 Nov 2014 Fixed 26 Nov 2014 Fixed 19 Dec 2014 Fixed Description In rare circumstances a 706 error, "Process tried to remove PROC_HDR that it does not hold in Pss", in the module onlutl_release_resources() together with a stack trace which includes the modules 'memfree' and 'rm_prochdr' may be reported in the SAP ASE error log when running CREATE INDEX or REORG REBUILD with the online option.

CR:774416

CR Number:   774416 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2014 Fixed 21 Nov 2014 Fixed 27 Nov 2014 Fixed 05 Dec 2014 Fixed 08 Dec 2014 Fixed 16 Dec 2014 Fixed Description Occasionally a error 644,"Index row entry for data row id (%u, %d) is missing from index page %u of index id %d of table '<name>' in database '<n>'. Xactid is (%u,%d). Drop and re-create the index." will be reported, when online parallel create index on unpartitioned DOL table with concurrent DMLs.

CR:774472

CR Number:   774472 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances An 806 error, "Could not find virtual page for logical page <pagenum> in database <dbname>" may be reported when executing dbcc checkstorage in parallel.

CR:774555

CR Number:   774555 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2014 Fixed 26 Nov 2014 Fixed Description DDLGen with option -Cnumber will generate wrong table owner

CR:774569

CR Number:   774569 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Open OS:   all Original Version:   16.0 GA PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description "set showplan" commands are ignored when they are in the middle of a batch Workaround Description  -- putting 'set showplan off' in own batch by adding a 'go' after 'select 1' is the WA select 1 go set showplan off go

CR:774594

CR Number:   774594 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.7 SP110 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances cursor fetch execution might hit the error 290024 of "Invalid column length: ... Value must be between XX and XX" in ASE 15.7 SP110.

CR:774650

CR Number:   774650 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) 23 Dec 2014 Fixed 07 Jan 2015 Fixed 18 Jan 2015 Fixed Description A SPID is holding a latch on a buffer and sleeping and some other SPID's are waiting on the same buffer leading to a hang.

CR:774683

CR Number:   774683 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2014 Fixed 02 Dec 2014 Fixed 09 Dec 2014 Fixed 02 Jan 2015 Bundled Request 28 Dec 2014 Fixed Description The SAP ASE server kills database connections when deadlocks occur when a language batch command is followed by an RPC call. A stacktrace with an access violation/infected with 11 (SIGSEGV) is reported in SAP ASE errorlog.

CR:774690

CR Number:   774690 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP60 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE may raise errors 5899 during recovery and 5861 when running sp_configure (even for options that do not require more memory) when "global cache partitions" is set to a non-zero value and the amount of free memory remaining is relatively small. Set 'max memory' to the value specified in the 5861 error (or free some memory by reducing other parameters and reboot) to correct this issue.

CR:774699

CR Number:   774699 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2014 Fixed 15 Jan 2015 Fixed 15 Jan 2015 Fixed 16 Jan 2015 Fixed 15 Jan 2015 Fixed Description Under rare circumstances during upgrade or initial installation, after ASE reports that it is beginning upgrade step ID 1650 it may produce a stack trace saying that a stack overrun was detected and that the stack guardword is corrupt.

CR:774751

CR Number:   774751 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 monDeviceIO.ReadTime and WriteTime should be bigint's and not int

CR:774786

CR Number:   774786 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2014 Fixed 20 Nov 2014 Fixed 22 Dec 2014 Fixed 24 Dec 2014 Fixed Description A 820 error, "Attempt to dirty non-log buffer ... which is in I/O" in the module 'bufpindirty' together with a stack trace which includes the modules 'undo_bt_split' and 'rec__undo_abort_incomplete_ntas' may be reported in the error log during the undo phase of boot recovery if there are incomplete transactions that split index pages of Data Only Locked tables.

CR:774789

CR Number:   774789 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE fails to detect numeric overflow for the BIGINT datatype. Overflow should raise error 3606.

CR:774830

CR Number:   774830 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Nov 2014 Fixed 02 Dec 2014 Fixed Description With auditing enabled, the query "alter encryption key master with passwd 'abcdef123456' add encryption for automatic_startup" may hit error 632 - "Attempt to move memory with an incorrect length of <n>. Maximum allowed length is <max>"

CR:774871

CR Number:   774871 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2014 Fixed Description Under rare conditions, error 14622, "The dbinfo anchor in the database '%<dbname>' is already locked by the task", could be raised when attempting to lock the database context information structure during exception handling.

CR:774892

CR Number:   774892 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 GA PL05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2014 Fixed Description placeholder CR only. NOt a real fix.

CR:774905

CR Number:   774905 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.7 SP121 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances the timeslice error might occur when HK GC is looping in bt__lockprevpg() to get page failed in ASE 15.7 SP121

CR:774906

CR Number:   774906 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2015 Fixed 19 Dec 2014 Fixed 22 Dec 2014 Fixed 24 Dec 2014 Fixed Description A 605 error, "An attempt was made to fetch logical page '<>' from cache '<>'. Page belongs to database '<>' ...", in the module bt__getchildlatched together with a stack trace which includes the modules rec_undo_session_apf and xact__rollback_local may be reported in the error log while a session is rolling back a transaction containing a CREATE INDEX that is followed by DMLs in a database with the option 'ddl in tran' enabled.

CR:775022

CR Number:   775022 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   16.0 GA PL04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2014 Consult Complete Description A login with js_admin_role can't delete a scheduled job belongs to another user

CR:775030

CR Number:   775030 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 GA PL05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2014 Fixed 07 Dec 2014 Fixed 22 Dec 2014 Fixed 18 Dec 2014 Fixed 09 Dec 2014 Presently Not Targeted For Any Future Release Of This Product 10 Dec 2014 DEFER 09 Dec 2014 Fixed 22 Dec 2014 Fixed Description Sometimes, if temp tables change in between two batch insert calls via jdbc, then we might have a situation where we point to memory that has been freed, leading to either of following errors : 705, 706, 707, 715 or Error 719 or similar error related to memory free, having stacktrace of batch_loopend -> s_copytmps -> memfree.

CR:775034

CR Number:   775034 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   16.0 GA PL05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2014 Fixed 15 Dec 2014 Fixed Description A 691 error, "Encountered invalid logical page '0' while accessing database <dbname>, object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8)." may sometimes be reported while running the loginfo() built-in with "stp_pages" option. Workaround Description  n/a

CR:775036

CR Number:   775036 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.7 SP131 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2014 Fixed 03 Dec 2014 Reservation Made 23 Dec 2014 Fixed Description When an online utility rolls back, a concurrent update on the same table could hit the error 12319 "Fatal internal error encountered during deferred dml on table <> in database <>. All rows that qualified during the first phase were not visited during second phase of dml."

CR:775146

CR Number:   775146 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide ability in Replication Agent to skip a single log record if there is an error in processing the log record by the RA. Workaround Description  Current workaround is to release the secondary truncation point and restart the RA at the next log page. However in doing so, the remaining log records could contain commits for open transactions, begins for new transactions and work done to other tables. This is a lot more impact, than just skipping the log record for the one table whose objectid cannot be found

CR:775241

CR Number:   775241 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_downgrade may hang if a database has async log service (ALS) on Workaround Description  Turn off async log service on all databases before running sp_downgrade.

CR:775297

CR Number:   775297 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2014 Fixed 07 Dec 2014 Fixed 08 Dec 2014 Fixed 08 Dec 2014 Fixed 16 Dec 2014 Fixed 05 Jan 2015 Fixed 23 Dec 2014 Fixed 16 Dec 2014 Fixed 23 Dec 2014 Fixed 23 Dec 2014 Fixed Description When the Job Scheduler initialization fails or terminates, the subsequent Job scheduler boot may fail with an error "Attempt to insert duplicate key row in object '<js_table_name>' with unique index '<js_row_index>'" Workaround Description  delete sybmgmtdb..js_callouts where jsc_calloutid = 2147483647 and jsc_sjobid = 2147483647 delete sybmgmtdb..js_history where jsh_exid = 2147483647 and jsh_jobname = 'FAKE_JSJOB' and jsh_user_run = 'FAKE_JSUSER' delete sybmgmtdb..js_seqsql where ssql_sid = 2147483647 and ssql_name = 'FAKE_JSSQL' delete sybmgmtdb..js_scheduledjobs where sjob_id = 2147483647 and sjob_name = 'FAKE_JSSJOB' delete sybmgmtdb..js_schedules where sched_id = 2147483647 and sched_owner = 'FAKE_JSUSER' delete sybmgmtdb..js_jobs where job_id = 2147483647 and job_owner = 'FAKE_JSUSER'

CR:775355

CR Number:   775355 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2014 Fixed 18 Dec 2014 Fixed 18 Dec 2014 Fixed 22 Dec 2014 Fixed Description A 1108 error, "Cannot deallocate extent <extentid>, database <dbid>. Object id <objid>, index id <indid>, status 1 in extent does not match object id <objid2>, index id <indid2>, status 0 in object being deallocated. Run DBCC CHECKALLOC." may be reported in the module 'pg__dropbuf' together with a stack trace in the error log which includes the modules 'xact_rollback' and 'undo_apl_aextent', when an index page split occurs during the logical synchronization phase of ONLINE CREATE INDEX for a Data Only Locked table and the command is rolled back in the end.

CR:775402

CR Number:   775402 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If procedure 'sp_object_stats' is cancelled then trace flag 1213 can remain enabled causing performance problems in the environment. It is necessary to disable it manually by dbcc traceoff

CR:775417

CR Number:   775417 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide a new utility program named 'asecodeloc', that is used to decode ASE code location values that may appear in the error log, or other diagnostic outputs. The encoded code location can be decoded into its constituent file name / line number parts using this asecodeloc utility program.

CR:775419

CR Number:   775419 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement to error log printing routines to also synthesize and print to the error log an encoded 4-byte int value of the file name / line number where the error message is printed. Using a new 'asecodeloc' binary, this encoded value from the error log can be decoded to accurately locate the source of the error resulting in the message to the log file.

CR:775422

CR Number:   775422 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 Dec 2014 Fixed 23 Dec 2014 Fixed 09 Jan 2015 Fixed Description During rollback of online create index, level0 scanners might not be able to use the DES.

CR:775446

CR Number:   775446 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP120 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2014 Fixed 17 Dec 2014 Fixed 17 Dec 2014 Fixed 23 Dec 2014 Fixed Description The SAP ASE server might not boot with the error "defined cache configuration consumes more memory than is available for buffer caches".

CR:775459

CR Number:   775459 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances, the message "current process infected with 11" together with a stack trace which includes the modules 'check__comprow' may be reported in the error log when running DBCC CHECKTABLE on an allpage-locked table.

CR:775501

CR Number:   775501 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2014 Fixed 26 Dec 2014 Fixed Description SAP ASE could hit error 705 (("There is no room for process xxx to store PROC_HDR 0xxxx in Pss") when a lot of recompilations happen due to schema count changes.

CR:775553

CR Number:   775553 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) 04 Jan 2015 Fixed Description When calling sp_configure, some options with very long names are truncated in output.

CR:775559

CR Number:   775559 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) 19 Dec 2014 Fixed 04 Dec 2014 Fixed 23 Dec 2014 Fixed Description A 102 error, Incorrect syntax near '~'. One or more indexes are corrupt. They will be rebuilt ...", may be reported during ONLINE DATABASE if the database contains an index whose name is a quoted_identifier and the index was created with defer_recovery = NONE option and while the recovery of this index has been deferred by LOAD TRANSACTION.

CR:775561

CR Number:   775561 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2014 Fixed 23 Dec 2014 Fixed 31 Dec 2014 Fixed Description A 'hang' situation due to an infinite loop may be encountered by a LOAD TRANSACTION command if the transaction log being loaded has more than 631 CREATE INDEX transactions with DEFER_RECOVERY option set.

CR:775598

CR Number:   775598 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2014 Fixed 16 Dec 2014 Fixed Description In rare circumstances the message "current process infected with 11" in the module 'xls_last_notflushed_plcblk' together with a stack trace which includes the modules 'crdb_main' and 'xls_reconfig_plcblk' may be reported in the error log during CREATE DATABASE.

CR:775599

CR Number:   775599 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 SP131 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2014 Fixed 10 Dec 2014 Fixed 31 Dec 2014 Fixed Description In rare circumstances, a 1295 error, "Unconditional lock request for table or page <page number>, dbid <dbid> was made while holding a latch.", may be reported by the system housekeeper chores task.

CR:775625

CR Number:   775625 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A replicated password may be truncated last several bytes　if the new login is added by sp_addlogin or the password is changed by sp_password.

CR:775633

CR Number:   775633 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 SP01 PL02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Logical I/Os metrics incorrect for MDA tables for sensitive, insenstive cursors

CR:775654

CR Number:   775654 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP131 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2014 Fixed Description In rare circumstances, the message "current process infected with 11" in the module 's_setreturns' or 'LeEmitNoSndOp::_LeOpNext' together with a stack trace maybe be reported in the error log when Job Scheduler is started using the stored procedure SP_SJOBCONTROL and a 1204 error, "ASE has run out of LOCKS. Re-run your command ..." is triggered.

CR:775721

CR Number:   775721 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 SP131 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2014 Fixed 08 Dec 2014 Fixed 24 Dec 2014 Fixed Description The assertion failure: "Assertion (xdes->xcomplogbytesleft_diag >= 0) failed in file /calm/svr/sql/generic/source/access/do.c line <line_num>" may be seen with a diagserver during the ROLLBACK of a CREATE INDEX with ONLINE command.

CR:775729

CR Number:   775729 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2015 Reservation Made Description An optcriteria "force_top_plljoin" has been added to force parallel hash joins for star join fact table hinted strategies if possible. Of course, this is only applicable when parallelism is enabled.

CR:775735

CR Number:   775735 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) 17 Dec 2014 Bundled Request 09 Dec 2014 Fixed 17 Dec 2014 Bundled Request 22 Dec 2014 Bundled Request Description A 605 error, "An attempt was made to fetch logical page '<pgid>' from cache '<cachename>'. Page belongs to <obj_name1> and not to <obj_name2>", may be sometimes reported when a transaction containing multiple CREATE and DROP INDEX commands is rolled back in a database that has the 'ddl in tran' option enabled.

CR:775787

CR Number:   775787 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2014 Fixed 22 Dec 2014 Fixed 09 Dec 2014 Fixed Description In a synchronous replication environment, a committed transaction may be mistakenly aborted internally by SAP ASE if the message "uppause: No free alarms available is reported in error log, resulting in data missing on the primary site while it was correctly replicated on the standby site. Workaround Description  Increase the "number of alarms" by the "number of user connections". This can be achieved by running sp_configure "number of alarms", <n>.

CR:775820

CR Number:   775820 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.7 SP131 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2014 Fixed 23 Dec 2014 Fixed Description A 2628 error, "In database <>, page <> is linked forward to page <>, but that page is linked backward to page <>. Please report this internal error to Sybase Technical Support.", followed by a 644 error, "Index row entry for data row id <> is missing from index page <> of index id <> of table <> in database <>. Xactid is <>. Drop and re-create the index." may be reported when a DROP INDEX command is run concurrently with ONLINE CREATE INDEX command.

CR:775875

CR Number:   775875 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.7 SP131 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Dec 2014 Fixed 10 Dec 2014 Reservation Made 10 Dec 2014 Fixed 22 Dec 2014 Fixed Description Parallel queries may close their child threads before the child is completely drained. This can happen when non-correlated subqueries are flattened internally into existence joins. Unfortunately, the child thread will continue to drain it's plan fragment even when the pipe it is writing to is closed leading to bad performance.

CR:775934

CR Number:   775934 Product Name:   Adaptive Server Enterprise Product Component:   charsets Status:   Open OS:   all Original Version:   15.7 SP131 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description To add in big5-2003 symbols into ASE unicode conversion

CR:775943

CR Number:   775943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP131 Goodyear Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2014 Fixed 22 Dec 2014 Fixed 23 Dec 2014 Fixed Description In rare circumstances, an aborted ONLINE CREATE INDEX or ONLINE REORG REBUILD may cause a subsequent UPDATE or DELETE command to hit a 644 error, "Index row entry for data row id <> is missing from index page <> of index id <> of table <> in database <>. Xactid is <>. Drop and re-create the index.".

CR:775947

CR Number:   775947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   corona Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New feature: Provide built in functions hadr_state(), hadr_mode() and sp_hadr_admin stored procedure options "state", "mode" that provide descriptive output for globals @@hadr_mode, @@hadr_state.

CR:776004

CR Number:   776004 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 SP130 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Adding multiple partitions with later table using separate statements in a single batch can raise Msg 712 insufficient heap memory. Workaround Description  Avoid using a single batch.

CR:776028

CR Number:   776028 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.7 SP122 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RA stops with 9204, cannot locate schema Workaround Description  Currently, all one can do is move the RA to read past the problem log record.