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

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

CR:728759

CR Number:   728759 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2013 One-off Provided 09 Jan 2013 Fixed 10 Jan 2013 Fixed 19 Feb 2013 Fixed Description When the number of statements in the Adaptive Server statement cache is large (approximately 13,000 or more) a query on monCachedStatement may terminate with error 3621, "Command has been aborted".

CR:728804

CR Number:   728804 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#2 rolling Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2013 Fixed 06 Jun 2013 One-off Provided 03 Jun 2013 One-off Provided 15.7 SP50 05 Jun 2013 Fixed Description A procedure having SELECT INTO a temp table having UNION ALL and encrypted columns could result in wrong data in the target table and a subsequent SELECT from the table will result in a 15417: "An internal error occurred during a decryption operation (error code <n>). Please contact Sybase Technical Support." error. Workaround Description  move the base encryption table #b to outside of the sp, using insert instead of select into

CR:728845

CR Number:   728845 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) 31 Jan 2013 Fixed 18 Feb 2013 Fixed 25 Feb 2013 Fixed Description When attempting to migrate objects that may have storable comments such as PROCEDUREs, VIEWs, UDFs, PRE-COMPUTED RESULTSETs etc, if there are braces (curly brackets) within the comment section migration will fail with with a java.sql.SQLException. The same error will be observed if a curly brace appears anywhere in the proc DDL (search argument for example). Workaround Description  Migrate objects manually.

CR:728894

CR Number:   728894 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2013 Fixed Description ASE fails to install with Job Scheduler on roman8 charset.

CR:728903

CR Number:   728903 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2013 Fixed 07 Feb 2013 Reservation Made 15.7 SP60 28 Oct 2013 Fixed 24 Mar 2014 Fixed Description Under some rare conditions, if there is a HASH AGGREGATE operator above a JOIN operator, wrong query results may occur and it could also lead to data corruption.

CR:728961

CR Number:   728961 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) 13 Jan 2013 Fixed 15.7 SP50 02 May 2013 Fixed Description Error 207 may occur while running the sp_dboption stored procedure if quoted_identifier is turned on. This may also affect the Sybase Control Center Database Properties dialog by preventing the database options from being viewed or modified within Sybase Control Center. Workaround Description  Turn quoted_identifier off before executing the sp_dboption stored procedure. This can be done by executing the following command: set quoted_identifier off.

CR:728963

CR Number:   728963 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) 11 Jan 2013 Fixed Description Fixed spelling abbraviation error, mesc (millisecond) to proper abbreviation: sec.

CR:728979

CR Number:   728979 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) corona 25 Feb 2014 Added to user documentation Description The documentation for sp_dump_config should have a note that it does not support tape devices. The parameter @stripe_dir must be a file system directory, not an tape device. If a tape device is specified, backupserver will raise the error "Volume validation error: failed to obtain device information"

CR:728995

CR Number:   728995 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Tables Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) cepheus 28 Feb 2014 Added to user documentation Description The "expired login" status bit in syslogins may be off even though sp_displaylogin indicates the password is expired. This is because the status bit is not set on until the first time that user attempts to log in after their password has expired. This CR is for a minor documentation enhancement to clarify the behavior of the status bit.

CR:729022

CR Number:   729022 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2013 Fixed 15.7 SP60 03 Sep 2013 Fixed 05 Sep 2013 Fixed 15.7 SP121 03 Oct 2013 Fixed Description For some special table names, REORG REBUILD and ALTER TABLE fail with an infected with 11 error on IdentifierType::IdentifierType. Workaround Description  Use sp_rename to temporarily give the table a different name, reorg it, then change the name back. Or permanently change the name of the table, but that will likely require changes to applications.

CR:729074

CR Number:   729074 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2013 One-off Provided 18 Jan 2013 Port Not Needed 25 Mar 2013 Fixed 07 Jun 2012 Port Not Needed Description The message "current process infected with 11" in the module 'xact_beginupdate' together with a stack trace which includes the modules 'tmp_alldrop' and 'clean_process' may be reported in the error log when a task attempts to clean up its temporary objects while disconnecting.

CR:729088

CR Number:   729088 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2013 One-off Provided 06 Apr 2013 One-off Provided 15.7 SP50 13 Jun 2013 Fixed 15.7 SP110 20 Jun 2013 Fixed 15.7 SP102 21 Jun 2013 Fixed Description ASE on Windows crashes due to system exception (0xc0000005) generated by a storage access violation with error message "attempted write to memory location 0000000000000000 from instruction at location 0x0000000000000000". This issue only affects ASE on the Windows platforms.

CR:729192

CR Number:   729192 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2013 Fixed 15 Mar 2013 Fixed Description Deadlock may occur when SHRINKDB runs concurrently with REORG DEFRAG.

CR:729204

CR Number:   729204 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) 25 Feb 2013 Fixed Description Data Only Locked tables with placement index undergoing ALTER TABLE MERGE PARTITION may lead to index corruption with 696 errors.

CR:729246

CR Number:   729246 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A new option WITH COPYONLY=<target_file_path> is added to LOAD DATABASE/TRANSACTION commands allowing to extract a DATABASE/TRANSACTION DUMP from a storage system and copy it into a local directory.

CR:729284

CR Number:   729284 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE raises error 1703 with severity 10 although the documentation says the severity is 17.

CR:729335

CR Number:   729335 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2013 Fixed Description ALTER TABLE MERGE PARTITION may fail with error 14108 on a empty range partitioned All Page Locked table with a clustered index.

CR:729373

CR Number:   729373 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2013 Fixed 15 Feb 2013 Fixed 28 Jan 2013 Fixed Description During the execution of DUMP DATABASE if the "compress::" option is used and only one stripe is specified, ASE 15.7 ESD#3, 15.7 ESD#3.1 and 15.7 ESD#4 will ignore the compression option prefix, resulting in an uncompressed dump. Additionally loading a valid pre-15.7 ESD#3 compressed single stripe dump will fail. Workaround Description  Either 1) Use WITH COMPRESSION instead of compress:: OR 2) Use multiple stripes

CR:729461

CR Number:   729461 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 Feb 2013 Fixed 15.7 SP50 12 Jun 2013 Fixed Description Columns with more than 65535 unique values, which also have some skewed values (i.e. represented as frequency cells in the histogram) could result in inconsistent histograms in which weights are outside the range of 0.0 to 1.0

CR:729509

CR Number:   729509 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) 04 Feb 2013 Fixed Description An 8201 error, "Keep count of descriptor was expected to be 1. Instead 0 was found" may be reported by the upgrade utility when upgrading from 12.5.4 Workaround Description  Before running preupgrade utility, increase the dbsize of pubs2 and pubs3, then upgrade will succeed. For 16K page size, increase about 12M will work around this issue. alter database pubs2 on default="12M"

CR:729551

CR Number:   729551 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) 16 Jan 2013 Duplicate Description Load database is ignoring compress::<>:: syntax if single dump device.

CR:729603

CR Number:   729603 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) 18 Jan 2013 Fixed 30 Jan 2013 Fixed 19 Feb 2013 Fixed Description In rare cases, after the last chance threshold is crossed and the user executes DUMP TRANSACTION to free up log space, the last chance bit DBTH_LASTCHANCE will remain set in memory in DBTABLE, which will continue to cause processes to be suspended by the last chance threshold mistakenly. Workaround Description  Increase log space via 'alter database ctdb log on logdevicename' may clear DBTH_LASTCHANCE bit. If cannot increase log size, then may need to reboot the ASE. Please update this field if you have better workaround. ------------------------ Notes: 1. Customers may use dbcc dbtable to check bit DBTH_LASTCHANCE: Dbcc traceon(3604) go dbcc dbtable(dbname) go to confirm status bit DBTH_LASTCHANCE 0x01 (log last chance threshold was crossed) was set in field dbt_threshstat: dbt_threshstat=0x1 2. Some commands to check log row count, free space, or log transafer state for a database select count(*) from dbname..syslogs go use db_name go sp_spaceused syslogs go dbcc gettrunc go

CR:729624

CR Number:   729624 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP121 26 Aug 2013 Fixed 27 Feb 2013 One-off Provided 15.7 SP50 22 Apr 2013 Fixed 25 Apr 2013 Fixed 18 Nov 2013 Port Not Needed Description Cluster deadlock occurs when process allocating a new page holding LLOL waits on WAIT_FOR_BASTPENDING. This issue only affects ASE Cluster Edition.

CR:729664

CR Number:   729664 Product Name:   Adaptive Server Enterprise Product Component:   Component Drop Status:   Closed OS:   Microsoft Windows Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2013 Added to user documentation Description This PC-Client EBF is based on SDK 15.7 ESD#5. A list of changes in that SDK 15.7 ESD#5 is available at http://download.sybase.com/swr/16225/EBF20570_Buglist.txt

CR:729666

CR Number:   729666 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description upon recovery and rescan alloc page only if there are negative values.

CR:729715

CR Number:   729715 Product Name:   ASE Management Product Component:   Web Console Status:   Closed OS:   Windows XP Pro Original Version:   3.2.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2013 Fixed Description While displaying a large number of User Tables or Proxy Tables in Administration Console of an ASE server, the UI might be hung. Navigation within the Monitoring view and Administration Console is not responsive .

CR:729766

CR Number:   729766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2013 Fixed 20 Feb 2013 Fixed 04 Mar 2013 Fixed 04 Mar 2013 Fixed 06 Mar 2013 Fixed Description A new configuration value of '2' is added to configuration option 'enable xml' for external entity reference in XML documents, ie, set "sp_configure 'enable xml', 2" for external entity reference in XML documents.

CR:729795

CR Number:   729795 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 IT Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 23 Jul 2013 Fixed 15.7 SP121 14 Aug 2013 Fixed 15.7 SP110 15 Aug 2013 Fixed Description The incorrect message "The dump configuration '<value>' supplied for SELECT is invalid. The change is completed. The option is dynamic and ASE need not be rebooted for the change to take effect." may be reported by sp_config_dump with an option that is longer than the supported length.

CR:729919

CR Number:   729919 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2013 Fixed 15 Mar 2013 Fixed 13 Mar 2013 Fixed 07 Mar 2013 Fixed 05 Mar 2013 Fixed Description In very rare situations where incorrect port number is specified for sp_listener, subsequent calls to sp_listener might fail.

CR:729937

CR Number:   729937 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) 07 Feb 2013 Fixed 28 Feb 2013 Bundled Request 18 Feb 2013 Fixed Description Enhancement is made to reduce the use of MASTER..SYSDATABASES scan for better performance when accessing tables in other databases.

CR:729957

CR Number:   729957 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 Feb 2013 Fixed Description A 2626 error, "Illegal attempt to insert duplicate key row in the clustered index partition database <dbname>, object <objname>, index <idxname>, partition <ptnname>" followed by a stack trace involving the module indinsert() may be reported when inserting and deleting duplicate key rows in the clustered index partition for All Pages Locked table numerous times.

CR:729984

CR Number:   729984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2013 Fixed 24 Feb 2013 Fixed 25 Feb 2013 Fixed 15.7 SP50 23 Apr 2013 Fixed Description getpass.exe which is utilized in Web Services on Windows only, is currently not compatible with x64 platforms. This issue only affects ASE on the Windows 64 platform.

CR:730051

CR Number:   730051 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2014 Fixed Description When REORG REBUILD WITH ONLINE is running in parallel with DMLs, DMLs may fail with a 540 error - "Schema for database object '<name>' has changed since compilation of this query. Please re-execute query.".

CR:730070

CR Number:   730070 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2013 Fixed Description When running sp_downgrade with @override = 1 for a SDC server, ASE will raise error 969 for attempting to access local temporary databases from non-owner instances.

CR:730082

CR Number:   730082 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 Feb 2013 Fixed Description DBCC REINDEX has been enhanced to provide a new option (option value: 32) to drop suspect replication indexes only. The syntax is DBCC REINDEX (tab_name | tabid , 32)

CR:730153

CR Number:   730153 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) 17 May 2013 Insufficient priority to fix Description Execute immediate on sp_configure does not return result for 1 row result set. Workaround Description  use normal execute, not execute immediate : execute sp_configure 'parameter'

CR:730154

CR Number:   730154 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 26 Jun 2013 Fixed 15.7 SP50 11 Apr 2013 Fixed 04 Apr 2013 Reservation Made 04 Nov 2013 Fixed 03 Feb 2014 Bundled Request 16 Apr 2014 Not a Bug Description Increase the number of expressions allowed in an ORDER BY clause. Workaround Description  No work around possible either from the database side or application side.

CR:730164

CR Number:   730164 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 Jan 2013 Bundled Request Description When shrinkdb try to move pages from 256, it may hit error 691 like this: Encountered invalid logical page '0' while accessing database 'tdb1' (4), object 'sysdams' (58), index 'sysdams' (0), partition 'sysdams_58' (58).

CR:730183

CR Number:   730183 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP101 29 Apr 2013 Fixed 29 Apr 2013 Fixed 08 May 2013 Fixed 08 May 2013 Fixed 21 May 2013 Fixed 09 May 2013 Fixed 15.7 SP50 14 May 2013 Fixed 15 May 2013 Fixed 20 May 2013 Fixed 05 Jun 2013 One-off Provided Description Extended stored procedures added using sp_addextendedproc are malformed leading to failure of the extended stored procedure. sp_helpextendedproc shows an extraneous '[' character in the DLL name. Workaround Description  Instead of using sp_addextendedproc, define the esp using CREATE PROC 'myproc' AS EXTERNAL NAME 'mydll'

CR:730215

CR Number:   730215 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2013 Fixed 17 Apr 2014 Fixed Description The message, "Current process infected with signal 11" followed by a stack trace that includes the modules d_deleteplan() and proc_plan_get() may be reported in the SAP ASE errorlog when executing DBCC DELETEPLAN.

CR:730276

CR Number:   730276 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2013 Fixed 29 Jan 2013 Fixed 29 Jan 2013 Fixed Description The Backup Server error message indicates that there is RPC parameter count mismatch between ASE 15.5 and Backup Server 15.0.3. The message needs enhancement to prompt user to verify Backup Server version compatibility with ASE.

CR:730280

CR Number:   730280 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.7 ESD#4 PL2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Dec 2013 Fixed 27 Dec 2013 Reservation Made 27 Mar 2014 Fixed Description 12308 error with delete or update against table in a query with distinctness e.g. joining to a distinct view or distinct derived table, and exists subquery, a union view or union in a derived table. changes associated with optcriteria cr669847 are enabled by default, but previous behavior (i.e. turn on fix only if optcriteria cr669847 is on) can be obtained by using trace flag 16987 Workaround Description  turn on compatibility mode or set merge_join off use optimization level ase_current or turn on optcriteria cr669847

CR:730281

CR Number:   730281 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 Jan 2013 Fixed Description The sense of Trace Flag 7773 has been inverted. Use of Trace Flag 7773 now disables the fix for CR 653511, which is on by default, ie, if a stored procedure undergoes recompilation, and the procedure makes assumptions regarding the session's state (ie session environment settings), the resulting recompiled plan can be significantly different than the original. This fix is now disabled when Trace Flag 7773 is on.

CR:730354

CR Number:   730354 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2013 One-off Provided 27 Jan 2013 Fixed 05 Feb 2013 Fixed Description sp_sysmon can return incorrect CPU metrics.

CR:730437

CR Number:   730437 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.7 ESD#3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2013 Fixed 16 May 2013 Bundled Request 15.7 SP50 24 Apr 2013 Fixed 27 Mar 2013 Reservation Made 23 Jan 2014 Port Not Needed Description Signal handler diagnostics have been added for the JS Agent process. Fatal signals are now logged in the JS Agent error log.

CR:730503

CR Number:   730503 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) 31 May 2013 Fixed Description An update of a view that has an INSTEAD OF trigger can cause an infected with signal 11 stacktrace in function copy_one_resdom() if the update assigns values to local variables.

CR:730608

CR Number:   730608 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) 07 Nov 2013 Fixed 27 Nov 2014 Fixed Description ASE might report the 225 error that some query--referenced object cannot be dropped during query optimization in sp_sysmon_kernel_threaded when running sp_sysmon in parallel.

CR:730656

CR Number:   730656 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 Jul 2013 Fixed 15.7 SP110 02 Jul 2013 Fixed 24 Jul 2014 Fixed Description Cache bindings may be ignored if a 'strict' database recovery order is specified. Workaround Description  Do not include the "strict" option when running sp_dbrecovery_order.

CR:730673

CR Number:   730673 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2013 Fixed 17 May 2013 Fixed 22 Apr 2013 Fixed 15.7 SP50 29 May 2013 Fixed 15.7 SP110 27 May 2013 Fixed 21 Jun 2013 One-off Provided 09 Sep 2013 Fixed Description The PCI Memory management layer is enhanced to better service memory allocation requests for ASE tasks executing JAVA operations. The layer now makes a better decision from where to allocate the requested memory. It either uses the PCI Fragment memory pool for end-user coded objects, or the O/S system run-time for JavaVM internal operations. Workaround Description  For Unix platforms only, disable the PCI memory and let it escape to runtime memory allocations via: sp_configure 'pci memory size', 0 go

CR:730730

CR Number:   730730 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 24 Apr 2013 Fixed 23 Apr 2013 Reservation Made 15 May 2013 Bundled Request 23 Jan 2014 Port Not Needed Description Enable auto restart of the Job Scheduler after an abnormal Job Scheduler shutdown. Workaround Description  Manually restart Job Scheduler with : Steps : 1. Stop JS : sybmgmtdb..sp_sjobcontrol @name=NULL, @option="stop_js" 2. Start JS : sybmgmtdb..sp_sjobcontrol @name=NULL, @option="start_js"

CR:730758

CR Number:   730758 Product Name:   SCC Web Framework Product Component:   Security Status:   Open OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: SSLv3.0/TLSv1.0 Protocol Weak CBC Mode Vulnerability port 8283/tcp over SSL

CR:730782

CR Number:   730782 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2013 Added to user documentation Description Doc cr: let's fix this odd example usage of sp_configure sp_countmetadata for "number of open partitions"

CR:730787

CR Number:   730787 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) 07 Feb 2013 Fixed Description CREATE LOGIN does not check if the login name already exists before calling sp_extrapwdchecks. This can cause sp_extrapwdchecks to update information stored for the existing login. Workaround Description  If the server is configured for monitoring so that monProcessProcedures is available, this query can be used from within sp_extrapwdchecks to determine if it was called directly by CREATE LOGIN or by some stored procedure (returns no rows for CREATE LOGIN): select * from master..monProcessProcedures where SPID = @@spid and ObjectName = "sp_password" If it was called by CREATE LOGIN, then check for an existing login with the same name and fail if it already exists.

CR:730788

CR Number:   730788 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: change the traceflag to a more user friendly optcriteria, and give users the ability to change the switchable status of deferred compilation on/off at the session level without sa_role/sso_role set deferred_compilation {on | off}

CR:730807

CR Number:   730807 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#3 IT Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2013 Fixed 11 Apr 2013 Fixed Description While using the partition_name builtin on multiple objects, the active objects could be recycled resulting in an information message, "Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation" being printed in the ASE errorlog. Workaround Description  For SAP installations facing this issue (seen when ever dba cockpit runs background job for getting information on the tables) Apply SAP NOTE 1839485

CR:730815

CR Number:   730815 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Windows W2k Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE crashes in scl__reuse_cred

CR:730831

CR Number:   730831 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#3 PL1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2013 Fixed Description sybcluster: create cluster complain release not exist when just no permission

CR:730901

CR Number:   730901 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Infected with 11 in fix_multiref() occurs when literal autoparam is on and stored procedure executes a SELECT statement that contains a complex ORDER BY clause.

CR:730906

CR Number:   730906 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Dec 2013 Fixed 27 Mar 2014 Fixed 28 Mar 2014 Fixed Description Isolation level 0 queries occasionally fail with errors when REORG REBUILD WITH ONLINE is in progress concurrently on the same table.

CR:730938

CR Number:   730938 Product Name:   ASE Management Product Component:   Administration Client Status:   Closed OS:   Windows XP Pro Original Version:   3.2.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2013 Fixed 05 Feb 2013 Duplicate Description There are two problems fixed in this resolution 1. Logical devices such as the one created by sp_dumpdevice are shown in the Database Devices view. 2. Archive database is displayed in the User Databases view for SDC server.

CR:730953

CR Number:   730953 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2013 Fixed Description The global variable @@tranchained shows inconsistent value when "SET CHAINED ON" is executed in the login trigger.

CR:730962

CR Number:   730962 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 Jun 2013 Fixed 11 Jun 2013 Fixed Description When running installhasvss, an error message indicating that it has 'failed to locate the sybsecuritydb' is hit.

CR:730982

CR Number:   730982 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 Feb 2013 Fixed Description When downgrading from 15.7 SP100 to a lower version, a 943 error will be raised when booting the server with the lower version and a stack trace will be encountered when running installmaster.

CR:731023

CR Number:   731023 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   cepheus Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Relax restriction when we Msg 3193 in relation to alter database <database> off <device_name> the load transaction.

CR:731026

CR Number:   731026 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) 21 Feb 2013 One-off Provided 14 Feb 2013 Fixed 15 Feb 2013 Fixed Description Certain stored procedures created with "execute as caller" may encounter errors at execution time. Workaround Description  Change variable type to numeric or float.

CR:731065

CR Number:   731065 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) 09 Apr 2013 Fixed 15.7 SP50 10 Apr 2013 Fixed Description DUMP DATABASE is getting a inappropriate warning message about DUMP TRAN with truncate_only

CR:731079

CR Number:   731079 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2013 Fixed 02 Apr 2013 Fixed 16 Apr 2013 Fixed Description The number of unreserved pages may be incorrect after LOAD DATABASE has been executed if the database dump is from an older ASE version and it contains a large number of tables, each having multiple partitions. Workaround Description  dbcc usedextents(energydb,0,1,1) will correct that values

CR:731137

CR Number:   731137 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature: Maintenance mode for databases which can be applied when databse is in use.

CR:731171

CR Number:   731171 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 19 Apr 2013 Fixed 04 Apr 2013 Fixed Description An arithmetic overflow error may be reported by the function sp_f_getval when sp_spaceused is executed against large tables. Workaround Description  We changed the procedure 'sp_f_getval' to workaround the problem. It was changed: ===== 1) ) returns unsigned int to ) returns bigint 2) declare @retval unsigned int to declare @retval bigint 3) set @retval = convert(unsigned int, @right) to set @retval = convert(bigint, @right) ==== I put script on case ditrectory: /remote/cases/11773000s/11773196 The new code is also described on CR notes

CR:731179

CR Number:   731179 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2013 Fixed 15 Feb 2013 Reservation Made 05 Apr 2013 Fixed 08 Apr 2013 Fixed Description The recovery redo pass unnecessarily attempts to fix problems with deallocations and reservations for some committed transactions in cases where there was a long-running transaction at the time of the last checkpoint.

CR:731180

CR Number:   731180 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) 27 Feb 2013 Not a Bug Description Upgrading ASE can cause Web Services to fail to boot

CR:731193

CR Number:   731193 Product Name:   Sybase SQL Server Product Component:   upgrade Status:   Closed OS:   Microsoft Windows Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2013 Workaround Description Job scheduler upgrad sometimes hit this error failing Job Scheduler to boot : "Execution of rule check_jsc_state failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.check_jsc_state" Workaround Description  Set enable job scheduler to 0 when we first time boot the server with new binary.

CR:731305

CR Number:   731305 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Windows Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2013 Fixed Description PC Client installer first screen says ESD#2, but should say ESD#4

CR:731354

CR Number:   731354 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2013 One-off Provided 06 Feb 2013 Fixed 08 Feb 2013 Fixed 19 Feb 2013 Fixed Description A signal 11 occurs in the function collectMonCSInfo when a query is executed on the monCachedStatement MDA table and the statement cache contains a statement that was created with a user-defined optimization goal.

CR:731372

CR Number:   731372 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2013 Fixed 22 May 2013 One-off Provided 15.7 SP50 24 May 2013 Fixed Description On tables with indexes, heavy insert activities can lead to 1295 errors, "Unconditional lock request for table or page was made while holding a latch".

CR:731424

CR Number:   731424 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) 12 Mar 2013 Bundled Request Description Instrumentation: ERP upgrade from 15.7 ESD#3 to 15.7 ESD#4 fails in R3load due to client connections timing out. This instrumentation captures timestamps of major login phases to identify if the timeout is caused during login and which module is introducing the delay.

CR:731437

CR Number:   731437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2013 Fixed 07 Feb 2013 Fixed Description DUMP DATABASE with verify[=header | full] options and LOAD DATABASE with verify[only][=header | full] options commands have been enhanced to detect a mismatch between the page header and tail timestamps for Data Only Locked tables.

CR:731468

CR Number:   731468 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 29 Jul 2013 Fixed Description sp_versioncrack returns NULL as ESD, with new ASE version strings.

CR:731531

CR Number:   731531 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) 07 Feb 2013 Fixed 28 Feb 2013 Bundled Request 25 Feb 2013 Fixed 04 Mar 2013 Fixed Description Enhancement is made to use less SYSTYPES scans when creating table.

CR:731617

CR Number:   731617 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2013 Fixed 22 Apr 2013 Fixed Description When DUMP DATABASE or DUMP TRANSACTION is run to a tape device, if the tape device configuration file backup_tape.cfg exists, ASE will not be able to read it and the dump will fail. The Backup Server will report the error, "The format of the device configuration file <$SYBASE>/backup_tape.cfg is invalid. Remove the configuration file and reconfigure the device by issuing a DUMP with the INIT qualifier. Return code = 0". Workaround Description  Delete the existing configuration file before issuing the DUMP command. ASE will create a new configuration file and dump the database.

CR:731644

CR Number:   731644 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) corona 25 Feb 2014 Added to user documentation Description Doc CR: remove arguments codepoint and debug from the ref manual section on the sp_shmdumpconfig. Also, add comments on dbcc.

CR:731718

CR Number:   731718 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) 16 Mar 2013 Fixed 15.7 SP50 10 Apr 2013 Fixed Description When a character set conversion is required for very long string input (> 255 character), for example converting client Windows code page 1252 to a server using code page 850, if the input string had a character unconvertible to the server character set, the connection would be inappropriately killed (with a stack trace), in addition to the issuance of the server conversion error message. Workaround Description  Fix the application to eliminate the wrong character

CR:731753

CR Number:   731753 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) 26 Sep 2013 Fixed 15.7 SP60 27 Sep 2013 Fixed 15.7 SP121 20 Oct 2013 Fixed Description If ALTER TABLE is used to add a NOT MATERIALIZED column <c2> with a default, then another nullable column <c3> is added to the table and REORG REBUILD the table, a query to the table will also assign the default to the column <c3>. Workaround Description  restart the Server.

CR:731758

CR Number:   731758 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2013 Fixed 14 Feb 2013 Fixed 21 May 2013 Fixed 02 May 2013 Fixed 13 Feb 2013 Not a Bug Description When executing UPDATE STATISTICS with an object name that contains unusual characters, the command may fail with an internal error.

CR:731769

CR Number:   731769 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.7 ESD#1 Refresh #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 07 Aug 2013 Fixed 06 Dec 2013 Fixed 15.7 SP121 10 Dec 2013 Fixed Description In case of an exception, SAP ASE hits an error 1265 while aborting / rolling back the transaction. Abort or rollback of the transaction may happen because of some internal / external error. Error: 1265, Severity: 20, State: 1 An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family.

CR:731783

CR Number:   731783 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) 27 Feb 2013 Fixed 15.7 SP50 08 Apr 2013 Fixed Description The message, "An internal memory management error has occurred. Error code: Invalid slot id.", followed by a stack trace involving the modules mda_exec() and mda_populate_monTask() may be reported when querying table monTask with clause KTID=0.

CR:731808

CR Number:   731808 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2013 One-off Provided 15.7 SP50 10 Apr 2013 Fixed 03 Apr 2013 Fixed 01 Apr 2013 Reservation Made 02 Apr 2013 Reservation Made 10 Apr 2013 Fixed 30 Apr 2013 Fixed Description If a LIKE predicate is used, then optimizer estimates for keys for a limiting index scan may be incorrect if a VARCHAR variable is used for the pattern match. This is especially true when there are no pattern matching characters used e.g. r.a LIKE "ABC". optcriteria CR731808 can be used to correct the optimizer estimate issue. Command line trace flag 16965 will also enable the fix. Workaround Description  Use an abstract plan. another workaround is to use "char" instead of "varchar" as the parameter declaration of the stored procedure.

CR:731818

CR Number:   731818 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2013 Fixed 06 Mar 2013 Fixed 09 Mar 2013 One-off Provided 06 Mar 2013 Presently Not Targeted For Any Future Release Of This Product 06 Mar 2013 Fixed 01 May 2013 Fixed 03 Apr 2013 One-off Provided Description The Backup Server is enhanced to perform consistency checks on All Pages Locked (APL) and Data Only Locked (DOL) data pages during DUMP DATABASE execution. If an error is detected on a page, the page is reread for validation. These checks will be performed if DUMP DATABASE is executed using WITH VERIFY option. Alternatively, start up the backup server with boot time trace flag -D64, or use the run time trace flag SYB_BACKUP...qatraceon 8, to enable these checks by default.

CR:731874

CR Number:   731874 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) 12 Feb 2013 Fixed 14 Feb 2013 Fixed 22 Feb 2013 One-off Provided 20 Feb 2013 Fixed 19 Feb 2013 Fixed Description A 15432 error, "A validation check failed when Adaptive Server decrypted an encryption key. This error may indicate an incorrect password" is raised when a user with login association of a key executes a stored procedure that accesses a column that is encrypted with the key. Workaround Description  Create the stored procedure with execute as caller.

CR:732011

CR Number:   732011 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2013 Workaround Description In rare cases a process attempting to cache a statement in the statement cache may fail with an infected with 11 in sqt_deallocate().

CR:732064

CR Number:   732064 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) 03 Mar 2013 Fixed 04 Mar 2013 Fixed 04 Mar 2013 Reservation Made 13 Mar 2013 One-off Provided 03 Apr 2013 One-off Provided Description The message, "Current process infected with signal 11", followed by a stack trace that includes the module ptn_get_aphintpage() may be reported when executing a CREATE INDEX or REORG REBUILD command.

CR:732131

CR Number:   732131 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Recovery may raise a 3474 if DBCC SET_IDENTITY_BURN_MAX was used to reset a columns identity value to 0 when it was already set to 0. Workaround Description  Workaround: only execute the DBCC if the value is already larger than 0. if identity_burn_max(<column name>) > 0 begin dbcc set_identity_burn_max(<table>,<column>,'0') end

CR:732185

CR Number:   732185 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2013 Fixed 15.7 SP50 10 Apr 2013 Fixed 17 May 2013 Fixed Description An ALTER TABLE command issued on a partitioned table where the partition degree is greater than the user's parallel degree may result in various failures. Workaround Description  Configure 'max parallel degree' and 'number of worker processes' to be greater than the no. of data partitions in the table on which 'alter table add columns' is being executed. -- ssimhach

CR:732227

CR Number:   732227 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) 26 Apr 2013 One-off Provided 08 Mar 2013 One-off Provided 10 Mar 2013 One-off Provided 15 Mar 2013 One-off Provided 21 Mar 2013 One-off Provided 01 Apr 2013 One-off Provided 26 Sep 2011 Already Fixed by Another CR 17 Nov 2014 Port Not Needed Description Certain stored procedures when executed repeatedly may result in a signal 10 or signal 11 in the functions rvm_clean_pcrtree(), proc__setdb_pcr() or rvm_fetch_attr(). In some cases error 10350 (Permission related internal error was encountered. Unable to continue execution.) is also printed in the errorlog.

CR:732231

CR Number:   732231 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When a table has been created with partition conditions these will create compiled objects whose source text is stored in syscomments. If the conditions are non-standard dateformat, then when these conditions are re-created from text under a different dateformat. (which will happen after upgrade or via upgrade_object) it is possible for a 247 error to be raised and a stack trace to appear in the error log in function name s__recrtPtncond(), the session will be terminated. Workaround Description  Ensure the dateformat (set dateformat) is set to what it was when the partitions were created before running any statements after upgrade (or before running upgrade_object) Or:- Manually update the partition condition date format (this is only an example that may work on a specific format of the way they were inputted, but please test it first) update syscomments set text=stuff (text, (charindex ("'", text)+1), 10, convert (char(8),( convert (date,(substring (text, charindex ("'", text)+1,10)),103)),2)) from syscomments sc, sysobjects so where sc.id=so.id and so.type='N'

CR:732258

CR Number:   732258 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) 28 Apr 2014 Fixed 06 May 2014 Fixed Description DBCC UPGRADE_OBJECT with the "check" option may raise bogus 11031 (Execution of <type> <name> failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate <name>) errors on every object checked after it encounters an object with an actual error.

CR:732318

CR Number:   732318 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If running with server-level 'deferred name resolution' = 1 then running the command:- set deferred_name_resolution off from a session will not function and it will behave as if it were still enabled.

CR:732329

CR Number:   732329 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) 06 Mar 2013 Fixed 06 Mar 2013 Fixed Description Under some rare conditions, a 4720 error "Cannot truncate table '%.*s' because there are one or more isolation level 0 scans, or REORG command, active on the table" may be reported if auto_temptable_stats is turned on. Workaround Description  set auto_temptable_stats off

CR:732385

CR Number:   732385 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2013 Fixed Description The message, "Current process infected with signal 11" followed by a stack trace that includes the module VTABRemoteAccess() may be raised when accessing a proxy table materialized at procedure whose name starts with a '$'.

CR:732393

CR Number:   732393 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2013 Fixed Description An 804 error, "Unable to find buffer <buffer address> from cache <cache name> holding logical page <page number> in sdes <sdes address> kept buffer pool for object <table name>", may be reported when inserting data into TEXT/IMAGE/UNITEXT columns.