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

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

CR:681538

CR Number:   681538 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Windows 2008 Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2011 Fixed 26 Aug 2011 One-off Provided 28 Sep 2011 One-off Provided 25 Oct 2011 One-off Provided Description When installing ASE using one off release EBF #19426, misleading warnings about connectivity may be reported. These can be ignored. Target Version  One-off Workaround Description  Ignore the misleading warning.

CR:681570

CR Number:   681570 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Suse 10 Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Under certain circumstances a query that has an outer join to a view that is itself included in an outer join no query plan may be identified by the optimiser. At least one of the view included in the query must also contains a query in the select list of the query that defines the view. Workaround Description  Remove the select statement from the select list of the query that defines View1 and include that table as a join. IE: Change create view dbo.View1 as select C.a , C.d , (select max (B.b) from B where B.b = C.a ) as X FROM C To create view dbo.View2 as select Ca , C.d, max(B.b) as X FROM C , B where B.b = C.a go This appears to result in a working query.

CR:681574

CR Number:   681574 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Refresh Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2011 Fixed 24 Aug 2011 Fixed Description show_cached_plan_in_xml() does not display BIGDATETIME and BIGTIME values correctly.

CR:681587

CR Number:   681587 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description feature request for sysobjects lastusage column for stored procs Workaround Description  enable auditing and audit sproc execution or use MDA tables monSysStatement and copy rows to user table

CR:681622

CR Number:   681622 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2011 Fixed 12 Oct 2011 Fixed 13 Oct 2011 Fixed 08 Nov 2011 Fixed 28 Oct 2011 Fixed 23 Nov 2011 Fixed 27 Nov 2011 Fixed 13 Dec 2011 Fixed 08 Dec 2011 Fixed Description Enable HA support on Windows 64 bit platform

CR:681629

CR Number:   681629 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) 21 Aug 2011 Fixed Description "alter database ... set lob_compression = 0" command doesn't work when executed following "alter database ... set compression = <new compression schema>" command. The LOB compression level will stay unchanged after the command.

CR:681652

CR Number:   681652 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2011 Fixed 06 Sep 2011 Fixed Description For roundrobin partitioned table, if each individual partition has its own compression level, the compression level setting is lost after create global clustered/placement index.

CR:681666

CR Number:   681666 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Library Status:   Closed OS:   Windows Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2011 Fixed Description The message "Error #0; Result Table was expected but not received" may be reported in Sybase Central when running "Object Page IO Monitor" in monitors folder.

CR:681716

CR Number:   681716 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 Feature request to make reorg compact not take shared table lock when it finds OAM entries with zero used/unused page.

CR:681719

CR Number:   681719 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2011 Added to user documentation Description Documents should be updated with reorg compact take shared table lock when it find OAM entries with zero used/unused page.

CR:681729

CR Number:   681729 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 Feature request for a CHORE(service task) to do the maintenance of the DOL tables with no customer interaction.

CR:681811

CR Number:   681811 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2011 Fixed 22 Nov 2011 Fixed Description The IOR_INTER_CALL error message is incorrect and is missing the device name.

CR:681817

CR Number:   681817 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Refresh Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2011 Fixed 17 Aug 2011 Fixed Description When configuration parameter 'FIPS login password encryption' is enabled and there is no valid ASE_ASM license, sp_configure unexpectedly succeeds. License checks done at ASE startup correctly report that no license is available, but unexpectedly allow continued use of the FIPS login password encryption configuration option.

CR:681948

CR Number:   681948 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2011 Fixed 10 May 2012 Fixed 12 Nov 2012 Fixed Description The threshold status passed to the threshold stored procedure sp_thresholdaction may contain some unexpected data for thresholds other than the last chance threshold.

CR:681970

CR Number:   681970 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2013 Insufficient info provided 28 Sep 2011 Presently Not Targeted For Any Future Release Of This Product Description In rare circumstances executing dbcc sqltext(spid) might cause signal 11 and stacktrace.

CR:682053

CR Number:   682053 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2011 Fixed Description A 2799 error, "'ALTER TABLE' command failed because 'COMPRESSION' is not enabled. A user with System Administrator (SA) role must reconfigure 'enable compression' to 1." will be reported when running ALTER TABLE ... ADD COLUMN NOT COMPRESSED with 'enable compression' being configured as 0.

CR:682117

CR Number:   682117 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2011 Presently Not Targeted For Any Future Release Of This Product Description Add valid check on default value in create table command.

CR:682220

CR Number:   682220 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Configuration Guide for UNIX Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2011 Added to user documentation Description Minor typo in 15.5 configuration guide incorrectly references 12.5 Workaround Description  n/a

CR:682354

CR Number:   682354 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2013 Fixed 19 Feb 2013 Fixed 04 Mar 2013 Reservation Made 05 Mar 2013 Fixed 05 Mar 2013 Fixed 22 Mar 2013 Fixed Description Allows stored procedures which reference temp tables created outside the procedure to not require recompilation for every execution. This was previously supported by trace flag 299.

CR:682360

CR Number:   682360 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 New Feature Request: to be able to specify optimizer timeout limit specifically to individual stored procedures when created. Workaround Description  n/a

CR:682374

CR Number:   682374 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2012 Fixed Description When capturing metrics using sp_configure enable metrics capture stack traces may be reported in mem_pageallocate. The issue does not occur if enable metrics capture is not configured. Workaround Description  The issue appears to be avoidable by setting enable metrics capture to false.

CR:682470

CR Number:   682470 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2013 Consult Complete Description ASE is inconsistant when handling the letter 'E' as a numeric constant

CR:682479

CR Number:   682479 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Refresh Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2011 Fixed Description Upgrades involving views or procedures whose definitions contain "select *" might fail if any of the column names in the expansion of "*" requires delimited identifiers.

CR:682486

CR Number:   682486 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2014 Deferred 08 Dec 2014 Fixed 10 Dec 2014 Fixed Description Add a new fake table in 'master', named 'syslogsdetail'. This is used to serve up the log records details, only metadata and not including user data, as a result set.

CR:682506

CR Number:   682506 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Solaris Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Current installation instructions do not adequately handle upgrade of Cluster Edition, CE, releases. Simplied instructions for upgrading existing private and shared installations should have clarified steps for the simple upgrades

CR:682559

CR Number:   682559 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 txt_seek with update trigger using 'for xml'

CR:682636

CR Number:   682636 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2011 Fixed 03 Apr 2012 Fixed Description Any uppercase letter 'Z' in column name will be mistakenly converted into lowercase letter 'z' in the output of SELECT FOR XML.

CR:682738

CR Number:   682738 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2011 Fixed 28 Sep 2011 One-off Provided 20 Sep 2011 Reservation Made 25 Oct 2011 One-off Provided 14 Aug 2012 Fixed 13 Sep 2012 Fixed Description CIS creates the first text page in an INSERT-SELECT query even though the source data is null. To activate the fix, trace flag 11241 needs to be turned on.

CR:682864

CR Number:   682864 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2011 Fixed 27 Sep 2011 Fixed 29 Sep 2011 Fixed 28 Sep 2011 One-off Provided 25 Oct 2011 One-off Provided Description Error 17290 can be reported by syconfig when creating a backupserver even though it is correctly created and setup in the ASE. Workaround Description  Quit syconfig after the new ASE is configured. Run a new syconfig session to configure the new backupserver.

CR:682931

CR Number:   682931 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2012 Fixed Description When running DBCC PGLINKAGE with the target page being identical to the starting page, the target page will not be found and thus leads to a searching failure.

CR:682958

CR Number:   682958 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2011 Fixed 31 Aug 2011 Fixed Description Using bigdatetime caused DML performance drop when 'stmt cache monitoring' enabled, Revert bigdatetime back to datetime to fix performance drop issue, these changes will cause the granularity of elapsed time increase to 3ms.

CR:682987

CR Number:   682987 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2012 Fixed Description ASE may not release memory allocated to MEMC_MEMAUXBUF_1 in some circumstances such as when we use BCP to load data into table with large number of partitions. This may lead to error 701.

CR:683008

CR Number:   683008 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Suse 10 Original Version:   15.7 Drop#3B Refresh Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2011 Fixed 30 Aug 2011 Fixed 29 Sep 2011 Fixed Description In rare circumstances, e.g under heavy load environment, Adaptive Server may encounter timeslice error when querying the MDA table monCachedProcedures.

CR:683014

CR Number:   683014 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2011 Fixed Description Replication Agent related MDA tables like monRepLogActivity in a multi-engine ASE environment may report wrong values for various monitor counters. Workaround Description  use sp_sysmon

CR:683015

CR Number:   683015 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) 02 Nov 2011 Fixed Description The execution of DBCC LOGTRANSFER may be aborted with the error message "ct_fetch(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect" when attempting to process a BIGTIME value.

CR:683027

CR Number:   683027 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to enhance dbcc checktable and tablealloc with some extra checks for syslogs pages containing the last checkpoint record, oldest open transaction, and ltm marker.

CR:683028

CR Number:   683028 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2011 Fixed 12 Sep 2011 One-off Provided 22 Nov 2011 Fixed 19 Sep 2012 Fixed Description Dynamic Partition Elimination is not used for a store procedure with EXEC IMMEDIATE.

CR:683064

CR Number:   683064 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2012 Fixed Description A procedure executing a function bound using des_bind encounters a 8242 error if a DDL statement is executed concurrently. Workaround Description  dbcc tune des_unbind the user function

CR:683068

CR Number:   683068 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) 06 Jun 2012 Fixed Description On Windows 64bit platform, if multiple network interfaces are available on the system, the Job Scheduler (JS) Task may fail to connect to JSAgent leading to failure of JS configuration. Workaround Description  Either use a direct IP address in the interfaces file OR configure DNS/host file on the host to name the specific interfaces so that the correct one is found.

CR:683127

CR Number:   683127 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2013 Fixed 31 Oct 2013 Fixed 15.7 SP120 14 Nov 2013 Fixed 15.7 SP120 05 Nov 2013 Consult Complete 09 Nov 2013 Fixed Description DDL is now replicated within user stored procedures.

CR:683137

CR Number:   683137 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2011 Fixed 27 Sep 2011 Fixed Description Using Sybase Central ASE-Plug-in to set the Cluster Edition (CE) cluster admin password does not work. Workaround Description  1) Use the Sybcluster 'set cluster login' command to set the UAF login, password or both. This command is documented in the Sybcluster chapter of the ASE Cluster Edition Users Guide.Syntax: set cluster login sa-login [password sa-password] Note: You must connect to the cluster before issuing the above command. or 3) Edit the UAF configuration files directly The UAF ASE login ad password are stored in the file: $SYBASE/UAF-2_5/nodes/<node name>/plugins/<cluster name>/agent-config.xml See the following tags in this XML file: <set-property property="ase.user" value="sa"/> <set-property property="ase.password" value=""/> Set the appropriate values for ase.user and ase.password. Note: The password tag may be missing. If so, add it as above. To generate the encrypted password, execute the following utility program: $SYBASE/UAF-2_5/bin/passencrypt Enter the password value in clear text and the utility will generate an encrypted text string. Enter this *entire* string between the quotation marks in the password tag in the agent-plugin.xml file

CR:683163

CR Number:   683163 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2012 Presently Not Targeted For Any Future Release Of This Product 25 Oct 2011 Fixed 14 Apr 2012 Fixed Description Queries in parallel mode using trace flag 16953 may generate bad plans because costing for parallel operators is incorrect. This is due to incorrect costing of one of the cost components in the parallel cost object.

CR:683192

CR Number:   683192 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2011 Fixed 01 Sep 2011 Fixed 01 Sep 2011 Fixed 05 Oct 2011 Fixed Description After downgrading from ASE 15.7 to ASE 15.5, when booting the ASE 15.5 server, a segmentation fault may be encountered during startup while attempting to reconcile the downgraded configuration options. This prevents successful completion of the server boot.

CR:683203

CR Number:   683203 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2011 Added to user documentation Description Doc: Contrary to the explanation of Performance and Tuning guide, sysstatistics is affected by CREATE TABLE command.

CR:683262

CR Number:   683262 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) 27 Sep 2011 Duplicate Description Shutting down the coordinator may cause the new coordinator to fence itself out which will cause it to error and shutdown.

CR:683269

CR Number:   683269 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Install Guide-Adaptive Server Enterprise Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2011 Fixed Description Change this: "see Installing version 15.5 over an existing 15.x Adaptive Server." to this: "Installing Adaptive Server Using Binary Overlay"

CR:683378

CR Number:   683378 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2011 Fixed Description Enhance Active Messaging to avoid memory leak for MSGRECV() and MSGCONSUME() with STRING property.

CR:683443

CR Number:   683443 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2012 Fixed Description In rare circumstances, the next_identity() could return NULL in ASE 15.5 ESD#1 after upgraded from 15.0.3 ESD#4.

CR:683542

CR Number:   683542 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to include database name or dbid in addition to the table name currently printed in REORG related messages in the ASE errorlor

CR:683582

CR Number:   683582 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2011 Added to user documentation Description There are some wrong description about transfer_table audit option in ASE 15.5 System Administration Guide.

CR:683626

CR Number:   683626 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2011 Fixed 17 Nov 2011 Reservation Made 17 Nov 2011 Fixed 06 Feb 2012 One-off Provided 20 Sep 2012 Presently Not Targeted For Any Future Release Of This Product 21 Sep 2012 Fixed 04 Oct 2012 Fixed Description Abstract plan error message could be reported when using "set forceplan on" for outer join query with subquery. Workaround Description  The workaround is to configure compatibility mode: "sp_configure 'compatibility_mode',1

CR:683708

CR Number:   683708 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) 28 Oct 2011 Fixed 09 Sep 2011 Fixed Description On IBM and HP platforms, when running in HA mode, console logging has to be enabled regardless of the setting of 'enable console logging' configuration parameter.

CR:683815

CR Number:   683815 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2011 Fixed Description A 16321 error, "Integer value '<value>' is disallowed." may be reported when a CREATE LOGIN command is executed and the option FULLNAME, PASSWORD EXPIRATION and SUID are specified. ALTER LOGIN command may result in similar error when the options FULLNAME and PASSWORD EXPIRATION are specified. Workaround Description  Work around is to specify the login attributes (suid/fullname/password exp) separately and not as part of a single statement. Note that this can affect alter login also. So fullname and password expiration should be specified in separate alter login statements. Example: --------- 1> create login hauser2 with password 'mysybase#123' suid 10 2> go 1> alter login hauser2 modify fullname 'mysybase#123' 2> go

CR:683882

CR Number:   683882 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) 13 Aug 2012 Fixed Description Excessive I/O to quorum devices is observed when SCC is up and cluster is down.

CR:683887

CR Number:   683887 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2011 Not a Bug Description query with a VERY large IN (over 23K) list fails with stackguard word corruption Workaround Description  increasing stack size (double) and stack guard word(double) the query ran, however at times I still see the stack but the server does not go down.

CR:683967

CR Number:   683967 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2011 Fixed 21 Nov 2011 Fixed Description In case of language batch parameter processing, error 2834 may be reported together with the stack trace involving module proce_release(), s_copytmps() and s_cleanframe().

CR:683997

CR Number:   683997 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) 29 Nov 2011 Fixed 23 Sep 2011 Fixed 13 Dec 2011 Fixed 15 Feb 2012 Presently Not Targeted For Any Future Release Of This Product Description When show_cached_plan_in_xml is executed, the time calculated for AVG and MAX time is in milliseconds. If a query takes less than a millisecond, the time displayed is 0. A more granular time mechanism is now provided to display the query execution time in microseconds.

CR:683998

CR Number:   683998 Product Name:   ASE Management Product Component:   Administration Client Status:   Closed OS:   Windows XP Pro Original Version:   3.2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2011 Fixed 16 Sep 2011 Added to user documentation Description ROW data-compression type is wrongly displayed as PAGE data-compression type in the Database Properties dialog.

CR:684046

CR Number:   684046 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) 10 Sep 2011 Fixed 03 Oct 2011 Fixed 03 Oct 2011 Fixed Description Free the Kernel Resource Memory after copying the thread pool configuration.

CR:684110

CR Number:   684110 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2011 Fixed 03 Nov 2011 Fixed 21 Nov 2011 Fixed 13 Sep 2012 Fixed Description Under rare circumstances, a 8601 error, "Process <pid1> tried to keep the PSS for process <pid2> when it already had the PSS for process <pid3> kept", may be reported when executing utility functions, such as sp_showplan, which query another active spid. Workaround Description  Not running sp_showplan during a "create index" should be a valid work around. any command like showplan that works on other pss'es and then try to open SDES'es for some usage (internally used for getting some info on an object) on tables which are having DDL's that recreates PDESes (eg: placement index creation for DOL for non-partitioned table, cluster table creation for APL etc.)has probability to endup like this.

CR:684174

CR Number:   684174 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.7 Drop#3B RTC Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2012 Presently Not Targeted For Any Future Release Of This Product 30 Dec 2011 Fixed 05 Jan 2012 Fixed Description When a scheduled job is deleted before its next execution time, then when its actual schedule time comes and if the number of 'job scheduler tasks' is less than number of jobs running simultaneously, then at this point of time the Job Scheduler task may stop with error "Job Scheduler Task state set to stop". Workaround Description  Set the config value 'job scheduler tasks' greater than number of jobs that could run simultaneously.

CR:684188

CR Number:   684188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2011 Fixed 14 Oct 2011 Reservation Made 23 Nov 2011 Fixed Description When the systabstats row for a table is deleted and the DES for the table is flushed (such as on a reboot), the table can no longer be accessed. A 15601 error, "Failed to cache systabstats contents for database <dbname>, object <objname>" may subsequently be reported in the errorlog. Workaround Description  For dataservers not having this fix =================================== Manually insert rows into systabstats corresponding to the object in question with appropriate values for id,indid and ptnid fields. Rest of the values can be zeroes. Then do an 'update statistics' to get the correct values into the rows inserted. For dataservers having this fix ================================== Switch on the new trace flag 8212 introduced in this CR and then do an 'update statistics' on the table to get the systabstats row back for the table. Traceflag 8212 can be switched off after this.

CR:684222

CR Number:   684222 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2012 Bundled Request Description The message, "WARNING: The transaction log for database '<dbname>' (dbid <dbid>) can no longer be dumped due to user '<username>' (suid <suid>) executing <cmdname>", should not be raised for databases with "trunc log on chkpt" enabled.

CR:684229

CR Number:   684229 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a method to mark user procedures or procedure parameters sensitive so that sensitive parameter values (such as passwords) are not captured by auditing of cmdtext or procedure execution, and are hidden in the output of MDA sql capture tables.

CR:684244

CR Number:   684244 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2011 One-off Provided 04 Sep 2012 Fixed Description Sometimes, when ASTC task gets error 1204, out of lock error, ASTC task may fail release shared page lock on a page in syslogins table, which might lead to blocking in the server. Workaround Description  Increase Number of locks.

CR:684249

CR Number:   684249 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 Implement Deferred Compilation for batches and select into Workaround Description  - force index - disable large IO - disable reformatting - if we split the batch in two so the optimizer is costing correctly the temp table - using compatibility mode

CR:684304

CR Number:   684304 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 Drop#3B Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2011 Third Party Problem Description On AIX 6.x and 7.x platforms, Adaptive Server running in threaded mode may stop responding to some clients under heavy i/o load. This is due to AIX APAR IV10828. Contact IBM to get a fix for this bug.

CR:684459

CR Number:   684459 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2014 Fixed 15.7 SP111 27 Mar 2014 Fixed 02 Apr 2014 Fixed 15.7 SP122 16 Apr 2014 Fixed 07 Apr 2014 Fixed 10 Apr 2014 Fixed Description On AIX platform, the mapping of addresses to function names in SAP ASE stack traces has been improved. This will provide a superior mapping when the address is in a shared library.

CR:684549

CR Number:   684549 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2011 Fixed 23 Sep 2011 Reservation Made 23 Apr 2012 Fixed Description A new session level trace flag 11908 is added, if it's turned on, zero used/unused OAM entries will not be removed when running reorg compact.

CR:684554

CR Number:   684554 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2011 Duplicate 26 Sep 2012 Duplicate Description When 'restricted decrypt permission' is enabled, implicit decrypt permission is NOT granted to sso_role although documentation states it should be. Workaround Description  Explicitly grant decrypt permission to sso_role.

CR:684602

CR Number:   684602 Product Name:   ASE Management Product Component:   Monitoring Data Collector Status:   Open OS:   Generic Original Version:   3.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description feature request: add the ability to extract the collection data in a bcp format for distribution

CR:684618

CR Number:   684618 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description doc bug: alter table not allowed in transaction missing from docs

CR:684623

CR Number:   684623 Product Name:   Adaptive Server Generic Docs Product Component:   Using Backup Server with IBM Tivoli Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2011 Added to user documentation Description The document "Using Backup Server with IBM Tivoli Storage Manager" should include a clear note stating that the use of remote backupservers with this option is not supported.

CR:684690

CR Number:   684690 Product Name:   ASE Management Product Component:   Administration Agent Plugin Status:   Closed OS:   Generic Original Version:   3.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2012 Fixed Description Would like the capability supplied to SCC and ASE plugins to generate alerts related to long running ASE transactions. Would like the alerts to also be able to provide the actual sql statement and query plan of the long running transactions.

CR:684701

CR Number:   684701 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 The "for xml" clause is being stripped off of the text which is saved in syscomments. This makes for difficulty in re-compiling procedures which need these clauses.

CR:684705

CR Number:   684705 Product Name:   Adaptive Server Generic Docs Product Component:   Adaptive Server New Features Guide Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2011 Added to user documentation Description "int" appears to be a typo in the doc for dbcc purgesqlcache. Should be removed.

CR:684753

CR Number:   684753 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2011 Fixed 21 Sep 2011 Added to user documentation Description Occasionally with 15.7 ASE on HP Itanium the message "Current process ... infected with signal 4 (SIGILL)" in the module 'pci_launcher_trigger' together with a stack trace which includes the modules 'jcnstCopy' and 'LeExecEvalsExec' may be reported in the error log when queries that are using Java datatypes are being executed.

CR:684761

CR Number:   684761 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2011 Fixed Description A 2799 error, "'ALTER TABLE' command failed because 'COMPRESSION' is not enabled. A user with System Administrator (SA) role must reconfigure 'enable compression' to 1.", will be reported when running ALTER TABLE ... MODIFY <non-LOB column> NOT COMPRESSED or ALTER TABLE ... DROP COLUMN on compresssed table with "enable compression" having been configured to 0.

CR:684763

CR Number:   684763 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 Request to enhance ASE's handling of timeouts while writing to SAN disks during 'disk init' command. Workaround Description  Restart ASE.

CR:684770

CR Number:   684770 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 ASE Web Service fails to start if any of the databases on it's ASE are offline. Workaround Description  Make sure all databases are online before starting webservices server.

CR:684849

CR Number:   684849 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2011 Fixed 24 Feb 2012 Presently Not Targeted For Any Future Release Of This Product 08 Nov 2011 Fixed Description Code optimization in the compression module to reduce the repeated acquisition of the resources and to use the local information as much as possible to avoid referring to global structures.

CR:684903

CR Number:   684903 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2011 Fixed Description sp_help_rep_agent <dbname>,'scan' does not correctly show log_recs_scanned and oldest_transction. Workaround Description  no equivalent method other than reading traces.

CR:684918

CR Number:   684918 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2011 Fixed 10 Oct 2011 Fixed 10 Oct 2011 Fixed Description The message "current process infected with 11" in the module 'upsleepgeneric' together with a stack trace which includes the modules 'ha_checkalive' and 'ha_vcs_getgroup' may be reported in the error log during the installation of ASE HA Cluster companionship on AIX.

CR:684938

CR Number:   684938 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2011 Fixed 31 Oct 2011 Fixed 14 Nov 2011 Fixed Description In rare circumstances, if TEXT/IMAGE/UNITEXT columns have NULL value previously, they may not be updated to have the new value in some qualifying data rows when running UPDATE command on these columns.

CR:684964

CR Number:   684964 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2011 Fixed 22 Nov 2011 Fixed Description Error msg 1579 is raised if the second char_expression is longer than 255 in builtin function compare().

CR:684967

CR Number:   684967 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2011 Fixed 12 Oct 2011 Reservation Made Description Only one text page for compressed LOB columns will be allocated during INSERT/UPDATE, others will be allocated on demand. This will reduce unnecessary text page reservation and is enabled only with a new session level Traceflag 7192.

CR:685000

CR Number:   685000 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2011 Fixed 23 Sep 2011 Fixed 30 Oct 2011 Presently Not Targeted For Any Future Release Of This Product 28 Nov 2011 Presently Not Targeted For Any Future Release Of This Product Description If the version of source server is ASE 15.0, the exception "Error while getting the configuration of net password encryption reqd for server" may be raised.

CR:685079

CR Number:   685079 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2011 Presently Not Targeted For Any Future Release Of This Product 09 Oct 2011 Presently Not Targeted For Any Future Release Of This Product Description There is no help topic for Options dialog for an editor window (such as the one for the DDLGen output).

CR:685098

CR Number:   685098 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) 23 Sep 2011 Fixed 21 Sep 2011 Reservation Made 29 Sep 2011 Reservation Made Description New interface sp_chgattribute <objectname>, 'ptn_locking', 0/1 to enable/disable partition locking

CR:685159

CR Number:   685159 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The sections about ssdone error for ASE 15.x. in Troubleshooting Guide is not correct. "Adaptive Server Enterprise 15.0 > Troubleshooting Guide: Error Messages Advanced Resolutions > Kernel Errors"

CR:685171

CR Number:   685171 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2012 Fixed 20 May 2013 Fixed Description When the set option "timestamp_insert" is enabled, an invalid value may result when inserting a "NULL" value into a timestamp column.

CR:685267

CR Number:   685267 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2011 Deferred Description suboptimal plan for query with sub query and max() with CR# 624835 enable the CR# 624835 improve thing but it still not a good plan. Workaround Description  This particular query does not fit either compatibility/new optimizer mode. Use a AP to force an appropriate query plan. NOTE: you will need to use 157esd1 or consult Sybase Technical support about ONE-OFF availablility.

CR:685349

CR Number:   685349 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2012 Fixed 06 Mar 2012 Fixed Description New columns are added to the monCachedStatement MDA table to provide data on rows read, lock usage and sort activity.

CR:685367

CR Number:   685367 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) 26 Sep 2011 Fixed Description A user who does not have the sso_role should not be authorized to run the installmaster script.

CR:685409

CR Number:   685409 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2011 Fixed 04 Nov 2011 Fixed Description While restarting ASE after a non polite shutdown, Asynchronous Pre-Fetch subsystem may be inefficient for the allocation page scan happening during data free space recalculation. This may happen for dedicated log databases having one or several log fragments in between their data fragments.

CR:685536

CR Number:   685536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2011 Fixed Description The CompRowUpdated value in the monTableCompression MDA table is not increased after a UPDATE is done on a Datapages Locked table.

CR:685585

CR Number:   685585 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhance checkcatalog to catch an invalid combination of status bits in sysprocedures.

CR:685718

CR Number:   685718 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2011 Fixed 01 Nov 2011 Fixed 09 Nov 2011 Fixed 09 Nov 2011 Fixed Description Performance improvement for disk init on XFS and EXT4 file system devices in AIX and Linux platforms.

CR:685736

CR Number:   685736 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 feature request to drop user in all dbs and master login with one cascading sp_droplogin command similar to CR 613678 (@with_override), in response to the workaround for CR 652640.

CR:685808

CR Number:   685808 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2011 Fixed Description Trailing blanks are not trimmed whn converting in-row UNITEXT/TEXT into VARCHAR/UNIVARCHAR.